| field name | data type | db field | description |
|---|
| tcBusinessRelationCode | character | BusinessRelation.BusinessRelationCode | Business Relation. A code to identify the business relation.
If this field does not have a input from the user, the system automatically generates a number for the record based on the sequence defined in Business Relation Autonumber Create. |
| 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 . |
| tlDebtorIsCheckAftDICredLim | logical | Debtor.DebtorIsCheckAftDICredLim | Indicate whether to perform the credit check when saving a new or modified invoice and include the new invoice amount in the total. |
| api annotation: | | Value for this field defaults to false. |
| tlDebtorIsCheckAftSOCredLim | logical | Debtor.DebtorIsCheckAftSOCredLim | Indicate whether to perform the credit check when saving a new or modified order and include the new order amount in the total. |
| api annotation: | | Value for this field defaults to false. |
| tlDebtorIsCheckBefDICredLim | logical | Debtor.DebtorIsCheckBefDICredLim | Indicate whether to perform the credit check before a new customer invoice is entered. |
| api annotation: | | Value for this field defaults to false. |
| tlDebtorIsCheckBefSOCredLim | logical | Debtor.DebtorIsCheckBefSOCredLim | Indicate whether to perform the credit check before a new order is entered or not. |
| api annotation: | | Value for this field defaults to false. |
| tlDebtorIsFixedCredLim | logical | Debtor.DebtorIsFixedCredLim | Indicate if the credit limit of the customer is fixed. |
| api annotation: | | Value for this field defaults to false. |
| tlDebtorIsInclDraftCredLim | logical | Debtor.DebtorIsInclDraftCredLim | Indicate whether to include the balance of open drafts in the system. |
| api annotation: | | Value for this field defaults to false. |
| tlDebtorIsInclOpenItmCredLim | logical | Debtor.DebtorIsInclOpenItmCredLim | Indicate whether to include the balance of unpaid invoices or not. |
| api annotation: | | Value for this field defaults to false. |
| tlDebtorIsInclSOCredLim | logical | Debtor.DebtorIsInclSOCredLim | Indicate whether to include the balance of open sales orders in the system. |
| api annotation: | | Value for this field defaults to false. |
| tlDebtorIsLockedCredLim | logical | Debtor.DebtorIsLockedCredLim | Indicate whether to put this customer on hold. |
| api annotation: | | Value for this field defaults to false. |
| tlDebtorIsMaxDaysDueCredLim | logical | Debtor.DebtorIsMaxDaysDueCredLim | Indicate whether you can enter a value in the Maximum Number of Days field or not. |
| api annotation: | | Value for this field defaults to false. |
| tlDebtorIsOverruleDICredLim | logical | Debtor.DebtorIsOverruleDICredLim | Indicate whether to allow users to enter invoice transactions for a customer when the customer’s credit limit is exceeded. |
| api annotation: | | Value for this field defaults to false. |
| tlDebtorIsOverruleSOCredLim | logical | Debtor.DebtorIsOverruleSOCredLim | Indicate whether to allow users to enter order transactions for a customer when the customer’s credit limit is exceeded. |
| api annotation: | | Value for this field defaults to false. |
| tlDebtorIsToBeLockedCredLim | logical | Debtor.DebtorIsToBeLockedCredLim | Indicate if the system puts the customer on credit hold if any of the credit limits are violated when new orders for this customer are created or not. |
| api annotation: | | Value for this field defaults to false. |
| tlDebtorIsTurnOverCredLim | logical | Debtor.DebtorIsTurnOverCredLim | Indicate whether you can enter a percentage in the Percentage of Turnover field. |
| api annotation: | | Value for this field defaults to false. |
| tiDebtorMaxNumDaysCredLim | integer | Debtor.DebtorMaxNumDaysCredLim | Specify the number of days that any invoice for this customer can be overdue before the system disallows any further credit. |
| api annotation: | | Value for this field defaults to 0. |
| 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 . |
| tdDebtorPercWarningCredLim | decimal | Debtor.DebtorPercWarningCredLim | Select to generate a warning message when the specified percentage of the credit limit has been reached. |
| 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 . |
each Debtor where