Field Listing for Table CUSTOMERPAYMENTS

Field:PAYMENTNUMBER Type: INTEGER
Field:PAYMENTDATE Type: DATE
Field:PAYMENTSTATUS Type: VARCHAR Length: 20
Field:PAYMENTSTYLE Type: VARCHAR Length: 30
Field:DEPOSITNUMBER Type: INTEGER
Field:CREDITNUMBER Type: VARCHAR Length: 15
Field:REFERENCE 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:PAYMENTAMOUNT Type: DOUBLE
Field:DISCOUNTAMOUNT Type: DOUBLE
Field:APPLIEDAMOUNT Type: DOUBLE
Field:PAYMENTROUNDING Type: DOUBLE
Field:UNAPPLIEDAMOUNT Type: DOUBLE
Field:PAYMENTNOTES 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:SITENAME Type: VARCHAR Length: 50
Field:POSPAYMENTID Type: DOUBLE
Field:PAYMENTTYPE Type: VARCHAR Length: 20
Field:PAYMENTDISCOUNTSTYLE Type: VARCHAR Length: 20
Field:FIXEDDISCOUNTPERCENTAGE Type: DOUBLE
Field:CURRENCYCODE Type: VARCHAR Length: 3
Field:EXCHANGERATE Type: DOUBLE
Field:FINANCECHARGEAMOUNT Type: DOUBLE
Field:FINANCECHARGESTYLE Type: VARCHAR Length: 20
Field:FINANCECHARGEPERCENT Type: DOUBLE
Field:FINANCECHARGETAXCODE Type: VARCHAR Length: 10
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:APPLYTOACCOUNT Type: BOOLEAN
Field:EXTERNALPAYMENT Type: BOOLEAN
Field:EXTERNALID Type: VARCHAR Length: 100
Field:SYSDATECREATED Type: TIMESTAMP
Field:SYSDATEMODIFIED Type: TIMESTAMP
Field:SYSUNIQUEID Type: DOUBLE
Field:SYSUSERCREATED Type: VARCHAR Length: 30
Field:SYSUSERMODIFIED Type: VARCHAR Length: 30