field name | data type | mnd. | description |
Debtor_ID | integer | yes | Record ID |
SharedSet_ID | integer | yes | Link to SharedSet |
InvControlGLProfile_ID | integer | yes | Control GL Profile (Invoice) |
CnControlGLProfile_ID | integer | yes | Control GL Profile (Credit Note) |
FinChgGLProfile_ID | integer | no | Finance Charge Profile |
NormalPaymentCondition_ID | integer | yes | Credit Terms Code |
BusinessRelation_ID | integer | yes | Business Relation |
Currency_ID | integer | yes | Currency Code |
DivisionProfile_ID | integer | no | Sub-Account Profile |
SalesCode_ID | integer | no | Link to SalesCode |
VatDeliveryType | character(20) | yes | Tax Nature. Legacy field from the Soft Cell version of the product. This field is now replaced by the GTM tax field. |
| value list: | | {&VATDELIVERYTYPES} |
Reason_ID | integer | yes | Invoice Status Code |
BLWIGroup_ID | integer | no | BLWI Group Code |
DeliveryCond_ID | integer | no | Link to DeliveryCond |
PaymentGroup_ID | integer | no | Payment Group |
SalesAccountGLProfile_ID | integer | yes | Sales Account GL Profile |
BillToDebtor_ID | integer | no | Bill-To Customer |
DebtorType_ID | integer | no | Customer Type |
DebtorCreditRating_ID | integer | no | Credit Rating |
PrePayControlGLProfile_ID | integer | yes | Control GL Profile (Pre-payment) |
DeductionCtrlGLProfile_ID | integer | no | Link to Deduction Profile |
Employee_ID | integer | no | Link to Employee |
BillSchedule_ID | integer | no | Link to BillSchedule |
DebtorCode | character(8) | yes | 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. |
DebtorIsActive | logical | yes | Indicate if this is an active record. |
| api annotation: | | Value for this field defaults to false. |
VatPercentageLevel | character(20) | yes | Tax Level- Possible values: None, Zero, Low, Medium, High.legacy field from the Soft Cell version of the product. This field is now replaced by the GTM tax field. |
| value list: | | {&VATPERCENTAGELEVELS} |
DebtorIsPrintStatement | logical | yes | Indicate if statements should be printed for this customer. When this field is selected, a statement is printed for this customer using the frequency specified in Statement Cycle. |
| api annotation: | | Value for this field defaults to false. |
DebtorIsPrintReminder | logical | yes | Indicate if reminders are typically printed for this customer to report past due balances. |
| api annotation: | | Value for this field defaults to false. |
DomiciliationNumber | integer | no | Domiciliation Number |
DebtorIsTaxable | logical | yes | Indicate if business activities for this address are normally subject to tax. |
| api annotation: | | Value for the field defaults from the Taxable field in Global Tax Management Control. |
DebtorIsTaxInCity | logical | yes | This setting determines whether the address is in the city limits for taxation purposes. It is used only with the Sales and Use Tax Interface for US and Canadian tax processing. |
| api annotation: | | Value for the field defaults from the business relation. |
DebtorIsTaxIncluded | logical | yes | Tax Is Included |
DebtorTaxIDFederal | character(18) | no | Federal Tax- the tax ID assigned to this address by the federal or national government. |
| api annotation: | | Value for the field defaults to null. |
DebtorTaxIDState | character(18) | no | State Tax- For reference and documentation purposes, enter either a state or provincial tax identification number or a VAT registration number. |
| api annotation: | | Value for the field defaults to null. |
DebtorTaxIDMisc1 | character(18) | no | Miscellaneous tax 1, 2, 3. For reference and documentation purposes, enter any other tax identification numbers that are useful. |
| api annotation: | | Values for these fields default to null. |
DebtorTaxIDMisc2 | character(18) | no | Miscellaneous Tax 2 |
DebtorTaxIDMisc3 | character(18) | no | Miscellaneous Tax 3 |
DebtorTaxDeclaration | integer | no | Tax Declaration |
DebtorIsFixedCredLim | logical | yes | Indicate if the credit limit of the customer is fixed. |
| api annotation: | | Value for this field defaults to false. |
DebtorFixedCredLimTC | decimal(4) | no | 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 . |
DebtorIsTurnOverCredLim | logical | yes | Indicate whether you can enter a percentage in the Percentage of Turnover field. |
| api annotation: | | Value for this field defaults to false. |
DebtorPercTurnOverCredLim | decimal(2) | no | 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 . |
DebtorIsMaxDaysDueCredLim | logical | yes | 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. |
DebtorMaxNumDaysCredLim | integer | no | 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. |
DebtorIsInclOpenItmCredLim | logical | yes | Indicate whether to include the balance of unpaid invoices or not. |
| api annotation: | | Value for this field defaults to false. |
ObsoleteInclPreInvCredLim | logical | yes | Include Pre-Invoices |
DebtorIsInclSOCredLim | logical | yes | Indicate whether to include the balance of open sales orders in the system. |
| api annotation: | | Value for this field defaults to false. |
DebtorIsInclDraftCredLim | logical | yes | Indicate whether to include the balance of open drafts in the system. |
| api annotation: | | Value for this field defaults to false. |
DebtorIsCheckBefSOCredLim | logical | yes | Indicate whether to perform the credit check before a new order is entered or not. |
| api annotation: | | Value for this field defaults to false. |
DebtorIsCheckAftSOCredLim | logical | yes | 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. |
ObsoleteCheckBefPICredLim | logical | yes | Check before Pre-Invoice Entry |
ObsoleteCheckAftPICredLim | logical | yes | Check after Pre-Invoice Entry |
DebtorIsCheckBefDICredLim | logical | yes | Indicate whether to perform the credit check before a new customer invoice is entered. |
| api annotation: | | Value for this field defaults to false. |
DebtorIsCheckAftDICredLim | logical | yes | 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. |
DebtorPercWarningCredLim | decimal(2) | no | 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 . |
DebtorIsOverruleSOCredLim | logical | yes | 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. |
ObsoleteOverrulePICredLim | logical | yes | Overrule Allowed |
DebtorIsOverruleDICredLim | logical | yes | 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. |
DebtorIsLockedCredLim | logical | yes | Indicate whether to put this customer on hold. |
| api annotation: | | Value for this field defaults to false. |
DebtorIsToBeLockedCredLim | logical | yes | 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. |
DebtorIsWithPreInvGroup | logical | yes | Indicate if Customer is Member of Pre-Invoice Group or not. |
| api annotation: | | Value for this field defaults to false. |
ObsoleteGroupingSOOnPreInv | logical | yes | Group Customer's SO on Pre-Invoice |
DebtorIsInvoiceByAuth | logical | yes | Indicate how invoice totals should be calculated and displayed for this customer. |
| api annotation: | | Value for this field defaults to false. |
DebtorDBNumber | character(12) | no | The credit agency reference number assigned to this customer. |
| api annotation: | | Value for this field defaults to null. |
DebtorIsFinanceCharge | logical | yes | Indicate whether to make this customer’s accounts liable for finance charges or not. |
| api annotation: | | Value for this field defaults to false. |
DebtorStatementCycle | character(4) | no | A value to indicate how often you normally print AR statements for this customer. |
| api annotation: | | Value for this field defaults to null. |
DebtorLastPayment | date | no | Last payment date. |
| api annotation: | | The system automatically updates this date when transactions are posted in Banking Entry, Petty Cash, and Customer Payments. |
DebtorLastSale | date | no | The date an invoice was last posted for this customer. |
| api annotation: | | This date is updated by Invoice Post and Print. |
DebtorHighCredit | decimal(4) | no | 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. |
DebtorHighCreditDate | date | no | The date the highest credit amount was extended to this customer. |
DebtorLastCreditReview | date | no | The date when the customer’s credit status was last reviewed. |
DebtorLastCreditUpdate | date | no | The date when the customer’s credit status was last updated. |
DebtorCommentNote | character(2000) | no | Free-form text related to this customer that is saved with the customer record. |
| api annotation: | | Value for this field defaults to null. |
DebtorSalesOrderBalance | decimal(4) | no | Current balance of all sales order related to this customer. |
| api annotation: | | Value for this field defaults to 0.0000 . |
DebtorLastFinChargeDate | date | no | The date when finance charge is last calculated for this customer. |
| api annotation: | | Value for this field defaults to null. |
DebtorTotalDaysLate | integer | no | Total Days Late |
DebtorTotalNbrOfInvoices | integer | no | Number of paid invoices related to this customer. |
DebtorIsPrintBillWithItemDet | logical | yes | Bill With Item Details |
TxzTaxZone | character(16) | yes | The tax zone for this address, defined in Tax Zone Maintenance. A value is required. |
| api annotation: | | The system searches for a default based on the country, state or province, county, city, and postal code of the current address. |
TxclTaxCls | character(3) | no | A tax class previously defined in Tax Class Maintenance. Tax classes group addresses taxed at specific rates or that are tax-exempt and help determine the default tax environment (set of tax types) for related transactions. |
| api annotation: | | The value of tax class defaults from the header of transactions created for this address. |
TxuTaxUsage | character(8) | no | A tax usage code previously defined in Tax Usage Maintenance. Tax usage codes identify the normal use of items sold to this address.Common tax usages are retail, manufacturing, and industrialization. |
| api annotation: | | The value of tax usage defaults from the header of transactions created for this address. |
ObsoletePreInvGroup_ID | integer | no | Link to PreInvGroup |
tlBusinessRelationIsInterco | logical | no | Indicate whether the business relation which associated with this customer identifies an entity that is a member of a group of entities that trade with each other - intercompany business relation. |
tcNormalPaymentConditionType | character(20) | no | The type of credit term code associated with this customer. |
| api annotation: | | Value for this field relates to the field NormalPaymentCondition. |
tcInvControlGLProfileCode | character(20) | yes | Specify the valid, active GL profile of type Customer Account used to determine the accounts receivable GL control account for invoices. |
tcCnControlGLProfileCode | character(20) | yes | Specify the valid, active GL profile of type Customer Account used to determine the accounts receivable GL control account for credit notes. |
tcFinanceChgProfileCode | character(20) | no | Specify the valid, active GL profile of type Sales Account used to determine the account for finance charge postings. |
| api annotation: | | This field is required when the Finance Charge field in the Payment tab is selected. |
tcDivisionProfileCode | character(20) | no | Optionally specify a default sub-account profile. |
| api annotation: | | If the account specified by the Control GL Profile (Invoice) of the customer requires a sub-account, the value used is either: 1.The sub-account found in this profile, if specified. 2.The default sub-account associated with the GL control account. |
tcSalesAccountGLProfileCode | character(20) | yes | Specify the valid GL profile of type Sales Account used to determine the account for sales. |
tcPrepayControlGLProfileCode | character(20) | yes | Specify the valid, active GL profile of type Customer Account used to determine the accounts receivable GL control account for prepayments. |
tcBLWIGroupCode | character(20) | no | Specify the default group associated with this customer for Belgian-Luxembourgian BLWI reporting. |
| api annotation: | | The default value is 999. |
tcNormalPaymentConditionCode | character(8) | yes | Specify the default credit terms for this customer. |
tcBusinessRelationName1 | character(36) | yes | The name of business relation which is associated with this customer. |
tcBusinessRelationCode | character(20) | yes | A business relation code associated with this customer. |
| api annotation: | | Address and contact details default from the headoffice address type of the business relation. |
tcReasonCode | character(20) | yes | Specify the default invoice status for invoices for this customer. |
tcCurrencyCode | character(3) | yes | Specify the currency code for this customer. |
| api annotation: | | Currency defaults from the current domain base currency, but can be modified. |
tcPaymentGroupCode | character(20) | no | Specify a payment group in which you want to include this customer. |
| api annotation: | | Value for this field defaults to null. |
tcDebtorTypeCode | character(4) | no | An optional code classifying customers by type. |
| api annotation: | | Value for this field defaults to null. |
tcBillToDebtorCode | character(8) | no | An optional code that identifies another customer that receives the bills for this customer. |
| api annotation: | | Value for this field defaults to null. |
tcDebtorCreditRatingCode | character(8) | no | An optional code rating the customer's creditworthiness; Credit rating is for reference only. It displays on the Customer Credit View and can help you evaluate customer credit issues. |
| api annotation: | | Value for this field defaults to null. |
tcDeductionCtrlGLProfileCode | character(20) | no | |
tcEmployeeCode | character(8) | no | |
tcBillScheduleCode | character(20) | no | |
CustomShort0 | character(20) | no | Custom Short Field |
CustomShort1 | character(20) | no | Custom Short Field |
CustomShort2 | character(20) | no | Custom Short Field |
CustomShort3 | character(20) | no | Custom Short Field |
CustomShort4 | character(20) | no | Custom Short Field |
CustomShort5 | character(20) | no | Custom Short Field |
CustomShort6 | character(20) | no | Custom Short Field |
CustomShort7 | character(20) | no | Custom Short Field |
CustomShort8 | character(20) | no | Custom Short Field |
CustomShort9 | character(20) | no | Custom Short Field |
CustomCombo0 | character(20) | no | Custom Combo Field |
CustomCombo1 | character(20) | no | Custom Combo Field |
CustomCombo2 | character(20) | no | Custom Combo Field |
CustomCombo3 | character(20) | no | Custom Combo Field |
CustomCombo4 | character(20) | no | Custom Combo Field |
CustomCombo5 | character(20) | no | Custom Combo Field |
CustomCombo6 | character(20) | no | Custom Combo Field |
CustomCombo7 | character(20) | no | Custom Combo Field |
CustomCombo8 | character(20) | no | Custom Combo Field |
CustomCombo9 | character(20) | no | Custom Combo Field |
CustomLong0 | character(255) | no | Custom Long Field |
CustomLong1 | character(255) | no | Custom Long Field |
CustomNote | character(2000) | no | Custom Note Field |
CustomDate0 | date | no | Custom Date Field |
CustomDate1 | date | no | Custom Date Field |
CustomDate2 | date | no | Custom Date Field |
CustomDate3 | date | no | Custom Date Field |
CustomDate4 | date | no | Custom Date Field |
CustomInteger0 | integer | no | Custom Integer Field |
CustomInteger1 | integer | no | Custom Integer Field |
CustomInteger2 | integer | no | Custom Integer Field |
CustomInteger3 | integer | no | Custom Integer Field |
CustomInteger4 | integer | no | Custom Integer Field |
CustomDecimal0 | decimal(4) | no | Custom Decimal Field |
CustomDecimal1 | decimal(4) | no | Custom Decimal Field |
CustomDecimal2 | decimal(4) | no | Custom Decimal Field |
CustomDecimal3 | decimal(4) | no | Custom Decimal Field |
CustomDecimal4 | decimal(4) | no | Custom Decimal Field |
CustomShort10 | character(20) | no | Custom Short Field |
CustomShort11 | character(20) | no | Custom Short Field |
CustomShort12 | character(20) | no | Custom Short Field |
CustomShort13 | character(20) | no | Custom Short Field |
CustomShort14 | character(20) | no | Custom Short Field |
CustomShort15 | character(20) | no | Custom Short Field |
CustomShort16 | character(20) | no | Custom Short Field |
CustomShort17 | character(20) | no | Custom Short Field |
CustomShort18 | character(20) | no | Custom Short Field |
CustomShort19 | character(20) | no | Custom Short Field |
CustomCombo10 | character(20) | no | Custom Combo Field |
CustomCombo11 | character(20) | no | Custom Combo Field |
CustomCombo12 | character(20) | no | Custom Combo Field |
CustomCombo13 | character(20) | no | Custom Combo Field |
CustomCombo14 | character(20) | no | Custom Combo Field |
CustomDecimal5 | decimal(4) | no | Custom Decimal Field |
CustomDecimal6 | decimal(4) | no | Custom Decimal Field |
CustomDecimal7 | decimal(4) | no | Custom Decimal Field |
CustomDecimal8 | decimal(4) | no | Custom Decimal Field |
CustomDecimal9 | decimal(4) | no | Custom Decimal Field |
CustomDate5 | date | no | Custom Date Field |
CustomDate6 | date | no | Custom Date Field |
CustomDate7 | date | no | Custom Date Field |
CustomDate8 | date | no | Custom Date Field |
CustomDate9 | date | no | Custom Date Field |
LastModifiedDate | date | no | Last Modified Date |
LastModifiedTime | integer | no | Last Modified Time |
LastModifiedUser | character(20) | no | Last Modified User |
QADC01 | character(40) | no | unused QAD reserved field |
QADC02 | character | no | unused QAD reserved field |
QADT01 | date | no | unused QAD reserved field |
QADD01 | decimal(10) | no | unused QAD reserved field |
tc_Rowid | character | yes | primary index |
tc_ParentRowid | character | no | empty string |
tc_Status | character | no | update status |