| field name | data type | db field | description |
|---|
| tiCurrency_ID | integer | Debtor.Currency_ID | Currency Code |
| tcCurrencyCode | character | Currency.CurrencyCode | Currency Code |
| tiDebtor_ID | integer | Debtor.Debtor_ID | Record ID |
| tcDebtorCode | character | Debtor.DebtorCode | A code (maximum eight characters) that identifies a customer. If the code you specify matches an existing supplier code, a warning message displays. You can choose to ignore the warning, and create the record. However, when a supplier and customer share the same code, they must reference the same business relation. |
| api annotation: | | If you leave the Customer Code field blank, the system automatically generates a number for the record based on the sequence defined in Customer Autonumber Create. |
| ttDebtorLastPayment | date | Debtor.DebtorLastPayment | Last payment date. |
| api annotation: | | The system automatically updates this date when transactions are posted in Banking Entry, Petty Cash, and Customer Payments. |
| ttDebtorLastSale | date | Debtor.DebtorLastSale | The date an invoice was last posted for this customer. |
| api annotation: | | This date is updated by Invoice Post and Print. |
| tdDebtorSalesOrderBalance | decimal | Debtor.DebtorSalesOrderBalance | Current balance of all sales order related to this customer. |
| api annotation: | | Value for this field defaults to 0.0000 . |
| tiDebtorTotalNbrOfInvoices | integer | Debtor.DebtorTotalNbrOfInvoices | Number of paid invoices related to this customer. |
each Debtor where