Field Listing for Table PURCHASERECEIPTLINES

Field:RECEIPTNUMBER Type: INTEGER
Field:ORDERNUMBER Type: VARCHAR Length: 15
Field:LINENUMBER Type: INTEGER
Field:CODETYPE Type: VARCHAR Length: 20
Field:LINECODE Type: VARCHAR Length: 50
Field:LINEDESCRIPTION Type: VARCHAR Length: 255
Field:LINEUNIT Type: VARCHAR Length: 15
Field:TAXCODE Type: VARCHAR Length: 10
Field:REMAINORDERQTY Type: DOUBLE
Field:ORDERUNITPRICE Type: DOUBLE
Field:RECEIPTQTY Type: DOUBLE
Field:RECEIPTUNITPRICE Type: DOUBLE
Field:MATCHEDLINEQTY Type: DOUBLE
Field:INVOICEUNITPRICE Type: DOUBLE
Field:MATCHEDLINESTATUS Type: VARCHAR Length: 20
Field:LINKEDCATALOGUENAME Type: VARCHAR Length: 20
Field:SUPPLIERCODE Type: VARCHAR Length: 50
Field:SUPPLIERUNIT Type: VARCHAR Length: 15
Field:SUPPLIERQTY Type: DOUBLE
Field:SUPPLIERUNITPRICE Type: DOUBLE
Field:SUPPLIERCONVERSION Type: DOUBLE
Field:EXTENDEDRECEIPTPRICE Type: DOUBLE
Field:LOCALORDERUNITPRICE Type: DOUBLE
Field:LOCALRECEIPTUNITPRICE Type: DOUBLE
Field:LOCALINVOICEUNITPRICE Type: DOUBLE
Field:ADDITIONALFIELD_1 Type: VARCHAR Length: 100
Field:ADDITIONALFIELD_2 Type: VARCHAR Length: 100
Field:ADDITIONALFIELD_3 Type: VARCHAR Length: 100
Field:ADDITIONALFIELD_4 Type: VARCHAR Length: 100
Field:ADDITIONALDATEFIELD_1 Type: DATE
Field:ADDITIONALDATEFIELD_2 Type: DATE
Field:CREATIONSOURCEID Type: DOUBLE
Field:PURCHASELINESYSUNIQUEID Type: DOUBLE
Field:HEADERSYSUNIQUEID Type: DOUBLE
Field:SYSDATECREATED Type: TIMESTAMP
Field:SYSDATEMODIFIED Type: TIMESTAMP
Field:SYSUNIQUEID Type: DOUBLE
Field:SYSUSERCREATED Type: VARCHAR Length: 30
Field:SYSUSERMODIFIED Type: VARCHAR Length: 30
Field:ALLOCATIONSUMMARY Type: VARCHAR Length: 500