Field Listing for Table PURCHASEINVOICELINES

Field:INVOICEBATCHNO Type: INTEGER
Field:LINESELECTED Type: BOOLEAN
Field:RECEIPTNUMBER Type: INTEGER
Field:RECEIPTDATE Type: DATE
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:RECEIPTQTY Type: DOUBLE
Field:RECEIPTUNITPRICE Type: DOUBLE
Field:INVOICEQTY Type: DOUBLE
Field:INVOICEUNITPRICE Type: DOUBLE
Field:EXTENDEDNETTLINEPRICE Type: DOUBLE
Field:RECEIPTLINESYSUNIQUEID Type: DOUBLE
Field:CLOSERECEIPTLINEMATCHING Type: BOOLEAN
Field:LINKEDCATALOGUENAME Type: VARCHAR Length: 20
Field:ALLOCATIONTYPE Type: VARCHAR Length: 15
Field:ALLOCATIONREFERENCE Type: VARCHAR Length: 90
Field:CATALOGUECATEGORY Type: VARCHAR Length: 20
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:SOURCESYSUNIQUEID 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:EXTENDEDLINETAX Type: DOUBLE
Field:EXTENDEDLINEPRICE Type: DOUBLE
Field:ALLOCATIONSUMMARY Type: VARCHAR Length: 500