tcBusinessFieldName | tcDataType | tcOperator |
iiCompanyId | i | |
iiDebtorID | i | = |
icDebtorCode | c | = |
tCurrency.CurrencyCode | c | =,>=,>,<>,<=,<,begins,can-do,matches |
tDebtor.DebtorCode | c | =,>=,>,<>,<=,<,begins,can-do,matches |
tDebtorCreditRating.DebtorCreditRatingCode | c | =,>=,>,<>,<=,<,begins,can-do,matches |
tDebtor.DebtorFixedCredLimTC | d | =,>=,>,<>,<=,< |
tDebtor.DebtorHighCredit | d | =,>=,>,<>,<=,< |
tDebtor.DebtorHighCreditDate | t | =,>=,>,<>,<=,< |
tDebtor.DebtorIsLockedCredLim | l | =,<> |
tDebtor.DebtorLastCreditReview | t | =,>=,>,<>,<=,< |
tDebtor.DebtorLastCreditUpdate | t | =,>=,>,<>,<=,< |
tDebtor.DebtorLastSale | t | =,>=,>,<>,<=,< |
tDebtor.DebtorPercTurnOverCredLim | d | =,>=,>,<>,<=,< |
tDebtor.DebtorSalesOrderBalance | d | =,>=,>,<>,<=,< |
field name | data type | db field | description |
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. |
tcDebtorCreditRatingCode | character | DebtorCreditRating.DebtorCreditRatingCode | A code (maximum eight characters) that identifies a customer credit rating. |
tdDebtorFixedCredLimTC | decimal | Debtor.DebtorFixedCredLimTC | When Apply Fixed Ceiling is selected, specify the currency amount that determines the maximum credit extended to this customer. |
| api annotation: | | Value for this field defaults to 0.0000 . |
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. |
tlDebtorIsLockedCredLim | logical | Debtor.DebtorIsLockedCredLim | Indicate whether to put this customer on hold. |
| api annotation: | | Value for this field defaults to false. |
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. |
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. |
tdDebtorPercTurnOverCredLim | decimal | Debtor.DebtorPercTurnOverCredLim | When Apply % of Turnover is selected,specify a percentage value. The system applies this percentage to the last year turnover and displays the result in the Credit on Turnover field. The amount is recalculated when you change the percentage. |
| api annotation: | | Value for this field defaults to 0.00 . |
tdDebtorSalesOrderBalance | decimal | Debtor.DebtorSalesOrderBalance | Current balance of all sales order related to this customer. |
| api annotation: | | Value for this field defaults to 0.0000 . |
DebtorCustom | character | calculated | custom fields |
CurrencyCustom | character | calculated | custom fields |
DebtorCreditRatingCustom | character | calculated | custom fields |
ti_sequence | integer | calculated | primary index |
tc_rowid | character | calculated | = rowid(Debtor),rowid(Currency),rowid(DebtorCreditRating) |