Field Listing for Table FINANCIALPURCHASEVAR

Field:TRANSACTIONDATE Type: DATE
Field:ORDERNUMBER Type: VARCHAR Length: 15
Field:ORDERTYPE Type: VARCHAR Length: 20
Field:SUPPLIER Type: VARCHAR Length: 50
Field:SUPPLIERTYPE Type: VARCHAR Length: 20
Field:ALLOCATIONTYPE Type: VARCHAR Length: 15
Field:ALLOCATIONREFERENCE Type: VARCHAR Length: 90
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:WAREHOUSECODE Type: VARCHAR Length: 20
Field:LOCATIONCODE Type: VARCHAR Length: 20
Field:DEBITCOSTCENTRECODE Type: VARCHAR Length: 50
Field:CREDITCOSTCENTRECODE Type: VARCHAR Length: 50
Field:FINANCIALCOST Type: DOUBLE
Field:CATALOGUENAME Type: VARCHAR Length: 20
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