Field Listing for Table PURCHASEINVOICES

Field:INVOICEBATCHNO Type: INTEGER
Field:PURCHASEINVDATE Type: DATE
Field:PURCHASEINVSTATUS Type: VARCHAR Length: 20
Field:PURCHASEINVREFERENCE Type: VARCHAR Length: 50
Field:PURCHASEINVSTYLE Type: VARCHAR Length: 30
Field:SUPPLIERINVOICENO Type: VARCHAR Length: 20
Field:SUPPLIERINVOICEDATE Type: DATE
Field:SUPPLIER Type: VARCHAR Length: 50
Field:CREDITTERM Type: VARCHAR Length: 20
Field:APPROVALSTATUS Type: VARCHAR Length: 20
Field:APPROVALDATE Type: DATE
Field:APPROVALUSERNAME Type: VARCHAR Length: 30
Field:ADDITIONALFREIGHTTAXCODE Type: VARCHAR Length: 15
Field:ADDITIONALFREIGHTNETT Type: DOUBLE
Field:ADDITIONALFREIGHTTAX Type: DOUBLE
Field:ADDITIONALFREIGHTTOTAL Type: DOUBLE
Field:ADDITIONALOTHERTAXCODE Type: VARCHAR Length: 15
Field:ADDITIONALOTHERNETT Type: DOUBLE
Field:ADDITIONALOTHERTAX Type: DOUBLE
Field:ADDITIONALOTHERTOTAL Type: DOUBLE
Field:SUPPLIERINVNETT Type: DOUBLE
Field:SUPPLIERINVTAX Type: DOUBLE
Field:SUPPLIERINVTOTAL Type: DOUBLE
Field:BATCHNETT Type: DOUBLE
Field:BATCHADDITIONAL Type: DOUBLE
Field:BATCHTAX Type: DOUBLE
Field:BATCHTAXNOADDITIONAL Type: DOUBLE
Field:BATCHTOTAL Type: DOUBLE
Field:BATCHTOTALNOADDITIONAL Type: DOUBLE
Field:BATCHDIFFERENCE Type: INT64
Field:PURCHASEINVNOTES Type: BLOB
Field:EXCHANGERATE Type: DOUBLE
Field:CURRENCYCODE Type: VARCHAR Length: 3
Field:LOCALADDITIONALFREIGHTNETT Type: DOUBLE
Field:LOCALADDITIONALFREIGHTTAX Type: DOUBLE
Field:LOCALADDITIONALFREIGHTTOTAL Type: DOUBLE
Field:LOCALADDITIONALOTHERNETT Type: DOUBLE
Field:LOCALADDITIONALOTHERTAX Type: DOUBLE
Field:LOCALADDITIONALOTHERTOTAL Type: DOUBLE
Field:LOCALSUPPLIERINVNETT Type: DOUBLE
Field:LOCALSUPPLIERINVTAX Type: DOUBLE
Field:LOCALSUPPLIERINVTOTAL Type: DOUBLE
Field:LOCALBATCHNETT Type: DOUBLE
Field:LOCALBATCHADDITIONAL Type: DOUBLE
Field:LOCALBATCHTAX Type: DOUBLE
Field:LOCALBATCHTAXNOADDITIONAL Type: DOUBLE
Field:LOCALBATCHTOTAL Type: DOUBLE
Field:LOCALBATCHTOTALNOADDITIONAL Type: DOUBLE
Field:CREATEDFROM Type: VARCHAR Length: 10
Field:SITENAME Type: VARCHAR Length: 50
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:ADDITIONALFIELD_5 Type: VARCHAR Length: 100
Field:ADDITIONALFIELD_6 Type: VARCHAR Length: 100
Field:ADDITIONALFIELD_7 Type: VARCHAR Length: 100
Field:ADDITIONALFIELD_8 Type: VARCHAR Length: 100
Field:ADDITIONALDATEFIELD_1 Type: DATE
Field:ADDITIONALDATEFIELD_2 Type: DATE
Field:ADDITIONALDATEFIELD_3 Type: DATE
Field:ADDITIONALDATEFIELD_4 Type: DATE
Field:ADDITIONALDATEFIELD_5 Type: DATE
Field:ADDITIONALDATEFIELD_6 Type: DATE
Field:ADDITIONALDATEFIELD_7 Type: DATE
Field:ADDITIONALDATEFIELD_8 Type: DATE
Field:DEFAULTALLOCATIONTYPE Type: VARCHAR Length: 15
Field:DEFAULTALLOCATIONREF Type: VARCHAR Length: 90
Field:OVERRIDELOCATIONS Type: BOOLEAN
Field:DEFAULTRECEIPTWAREHOUSE Type: VARCHAR Length: 20
Field:DEFAULTRECEIPTLOCATION Type: VARCHAR Length: 20
Field:ORDERNUMBER Type: VARCHAR Length: 200
Field:BATCHDIFFERENCETAX Type: INT64
Field:BATCHDIFFERENCENETT Type: INT64
Field:INVOICEDUEDATE Type: DATE
Field:FINANCIALCATEGORY Type: VARCHAR Length: 200
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:SUPPLIERPURCHASENAME Type: VARCHAR Length: 150
Field:BUYERCREATEDSOURCE Type: VARCHAR Length: 20
Field:BUYERCREATEDSOURCEID Type: VARCHAR Length: 20