Field Listing for Table CUSTOMERPAYMENTTRANS
| Field: | PAYMENTNUMBER | Type: | INTEGER |
| Field: | INVOICENUMBER | Type: | VARCHAR Length: 15 |
| Field: | INVOICEDATE | Type: | DATE |
| Field: | INVOICEDUEDATE | Type: | DATE |
| Field: | INVOICETOTAL | Type: | DOUBLE |
| Field: | DISCOUNTAMOUNT | Type: | DOUBLE |
| Field: | APPLIEDAMOUNT | Type: | DOUBLE |
| Field: | INVOICEBALANCE | Type: | DOUBLE |
| Field: | APPLIEDDATE | Type: | DATE |
| Field: | CURRENCYCODE | Type: | VARCHAR Length: 3 |
| Field: | PAYMENTEXCHANGERATE | Type: | DOUBLE |
| Field: | INVOICEEXCHANGERATE | Type: | DOUBLE |
| Field: | INVOICECURRENCYCODE | Type: | VARCHAR Length: 3 |
| Field: | REALINVOICETOTAL | Type: | DOUBLE |
| Field: | REALDISCOUNTAMOUNT | Type: | DOUBLE |
| Field: | REALAPPLIEDAMOUNT | Type: | DOUBLE |
| Field: | REALINVOICEBALANCE | Type: | DOUBLE |
| Field: | DELIVERYCUSTOMER | Type: | VARCHAR Length: 50 |
| Field: | EXTERNALCREATION | Type: | BOOLEAN |
| Field: | SYSDATECREATED | Type: | TIMESTAMP |
| Field: | SYSDATEMODIFIED | Type: | TIMESTAMP |
| Field: | SYSUNIQUEID | Type: | DOUBLE |
| Field: | SYSUSERCREATED | Type: | VARCHAR Length: 30 |
| Field: | SYSUSERMODIFIED | Type: | VARCHAR Length: 30 |