| field name | data type | db field | description |
|---|
| tiBusinessRelation_ID | integer | Debtor.BusinessRelation_ID | Business Relation |
| tiCurrency_ID | integer | Debtor.Currency_ID | 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. |
| tdDebtorHighCredit | decimal | Debtor.DebtorHighCredit | The highest amount of credit you have ever extended to this customer. This is the largest AR balance they have had open at one time. |
| ttDebtorHighCreditDate | date | Debtor.DebtorHighCreditDate | The date the highest credit amount was extended to this customer. |
| ttDebtorLastCreditReview | date | Debtor.DebtorLastCreditReview | The date when the customer’s credit status was last reviewed. |
| ttDebtorLastCreditUpdate | date | Debtor.DebtorLastCreditUpdate | The date when the customer’s credit status was last updated. |
| ttDebtorLastFinChargeDate | date | Debtor.DebtorLastFinChargeDate | The date when finance charge is last calculated for this customer. |
| api annotation: | | Value for this field defaults to null. |
| 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 . |
| ttLastModifiedDate | date | Debtor.LastModifiedDate | Last Modified Date |
| tiLastModifiedTime | integer | Debtor.LastModifiedTime | Last Modified Time |
| tcLastModifiedUser | character | Debtor.LastModifiedUser | Last Modified User |
each Debtor where