Field Listing for Table FINANCIALSALESCOSTS

Field:TRANSACTIONDATE Type: DATE
Field:INVOICENUMBER Type: VARCHAR Length: 15
Field:INVOICECUSTOMER Type: VARCHAR Length: 50
Field:INVOICECUSTOMERTYPE Type: VARCHAR Length: 20
Field:INVOICECUSTOMERREGION Type: VARCHAR Length: 20
Field:ORDERCUSTOMER Type: VARCHAR Length: 50
Field:ORDERCUSTOMERTYPE Type: VARCHAR Length: 20
Field:ORDERCUSTOMERREGION Type: VARCHAR Length: 20
Field:ORDERCLASS Type: VARCHAR Length: 20
Field:ORDERTYPE Type: VARCHAR Length: 20
Field:ORDERNUMBER Type: VARCHAR Length: 15
Field:ORDERSALESPERSON Type: VARCHAR Length: 30
Field:CODETYPE Type: VARCHAR Length: 20
Field:LINECODE Type: VARCHAR Length: 50
Field:CATEGORY Type: VARCHAR Length: 20
Field:ANALYSISGROUP Type: VARCHAR Length: 20
Field:WAREHOUSE Type: VARCHAR Length: 20
Field:LOCATION Type: VARCHAR Length: 20
Field:FINANCIALCOST Type: DOUBLE
Field:DEBITCOSTCENTRECODE Type: VARCHAR Length: 50
Field:CREDITCOSTCENTRECODE Type: VARCHAR Length: 50
Field:BATCHFILENO Type: DOUBLE
Field:TRANSACTIONSTATUS Type: VARCHAR Length: 20
Field:TRANSACTIONMESSAGE Type: VARCHAR Length: 300
Field:OLDGROUPVALUE Type: VARCHAR Length: 15
Field:SOURCESYSUNIQUEID Type: DOUBLE
Field:SOURCENAME Type: VARCHAR Length: 50
Field:SOURCENUMBER Type: VARCHAR Length: 100
Field:SYSDATECREATED Type: TIMESTAMP
Field:SYSDATEMODIFIED Type: TIMESTAMP
Field:SYSUNIQUEID Type: DOUBLE