Field Listing for Table PURCHASERECEIPTS

Field:RECEIPTNUMBER Type: INTEGER
Field:ORDERNUMBER Type: VARCHAR Length: 15
Field:RECEIPTSTATUS Type: VARCHAR Length: 20
Field:RECEIPTDATE Type: DATE
Field:RECEIPTREFERENCE Type: VARCHAR Length: 50
Field:RECEIPTSTYLE Type: VARCHAR Length: 20
Field:SUPPLIER Type: VARCHAR Length: 50
Field:RECEIPTPACKINGSLIP Type: VARCHAR Length: 20
Field:APPROVALSTATUS Type: VARCHAR Length: 20
Field:APPROVALDATE Type: DATE
Field:APPROVALUSERNAME Type: VARCHAR Length: 30
Field:RECEIPTNOTES Type: BLOB
Field:MATCHEDSTATUS Type: VARCHAR Length: 20
Field:EXCHANGERATE Type: DOUBLE
Field:CURRENCYCODE Type: VARCHAR Length: 3
Field:CREATEDFROM Type: VARCHAR Length: 10
Field:CREATEPURCHASEINVOICE Type: BOOLEAN
Field:POSTPURCHASEINVOICE Type: BOOLEAN
Field:PURCHASEINVOICESUPPLIERINVNO Type: VARCHAR Length: 20
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:RECEIPTEXTVALUE Type: DOUBLE
Field:OVERRIDELOCATIONS Type: BOOLEAN
Field:DEFAULTRECEIPTWAREHOUSE Type: VARCHAR Length: 20
Field:DEFAULTRECEIPTLOCATION Type: VARCHAR Length: 20
Field:DEFAULTALLOCATIONTYPE Type: VARCHAR Length: 15
Field:DEFAULTALLOCATIONREF Type: VARCHAR Length: 90
Field:BILLINGSUPPLIER Type: VARCHAR Length: 50
Field:FINANCIALCATEGORY Type: VARCHAR Length: 200
Field:CREATEDFROMSERVICESHEET Type: BOOLEAN
Field:SERVICESHEETID Type: VARCHAR Length: 30
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:INSERTSHIPMENTCHARGES Type: BOOLEAN
Field:SUPPLIERPURCHASENAME Type: VARCHAR Length: 150
Field:RECEIPTEDEMPLOYEE Type: VARCHAR Length: 30
Field:BUYERCREATEDSOURCE Type: VARCHAR Length: 20
Field:BUYERCREATEDSOURCEID Type: VARCHAR Length: 20