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 |