Field Listing for Table CUSTOMERDEPOSITS

Field:DEPOSITNUMBER Type: INTEGER
Field:DEPOSITDATE Type: DATE
Field:DEPOSITSTATUS Type: VARCHAR Length: 20
Field:DEPOSITFOR Type: VARCHAR Length: 20
Field:ORDERNUMBER Type: VARCHAR Length: 15
Field:DEPOSITREFERENCE Type: VARCHAR Length: 50
Field:CUSTOMER Type: VARCHAR Length: 50
Field:PAYMENTMETHOD Type: VARCHAR Length: 20
Field:BANKINGMETHOD Type: VARCHAR Length: 20
Field:PAYMENTREFERENCE Type: VARCHAR Length: 20
Field:PAYMENTACCOUNT Type: VARCHAR Length: 30
Field:TAXCODE Type: VARCHAR Length: 10
Field:DEPOSITAMOUNT Type: DOUBLE
Field:APPLIEDAMOUNT Type: DOUBLE
Field:UNAPPLIEDAMOUNT Type: DOUBLE
Field:DEPOSITNOTES Type: BLOB
Field:BEENPRINTEDONSTATEMENT Type: BOOLEAN
Field:LASTAPPLIEDDATE Type: DATE
Field:BANKINGNUMBER Type: INTEGER
Field:PAYERNAME Type: VARCHAR Length: 50
Field:PAYERBANK Type: VARCHAR Length: 30
Field:PAYERBRANCH Type: VARCHAR Length: 30
Field:CURRENCYCODE Type: VARCHAR Length: 3
Field:EXCHANGERATE Type: DOUBLE
Field:SITENAME Type: VARCHAR Length: 50
Field:POSPAYMENTID 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