project QadFinancials > class BDebtor > dataset BDebtor

class dataset

object identification

primary key
Debtor_ID
object identity
Debtor_ID

table tDebtor

Annotation

<QUERYTYPE=Application Table - Master Data>

Description

Customer

field namedata typemnd.description
Debtor_IDintegeryesRecord ID
SharedSet_IDintegeryesLink to SharedSet
InvControlGLProfile_IDintegeryesControl GL Profile (Invoice)
CnControlGLProfile_IDintegeryesControl GL Profile (Credit Note)
FinChgGLProfile_IDintegernoFinance Charge Profile
NormalPaymentCondition_IDintegeryesCredit Terms Code
BusinessRelation_IDintegeryesBusiness Relation
Currency_IDintegeryesCurrency Code
DivisionProfile_IDintegernoSub-Account Profile
SalesCode_IDintegernoLink to SalesCode
VatDeliveryTypecharacter(20)yesTax 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_IDintegeryesInvoice Status Code
BLWIGroup_IDintegernoBLWI Group Code
DeliveryCond_IDintegernoLink to DeliveryCond
PaymentGroup_IDintegernoPayment Group
SalesAccountGLProfile_IDintegeryesSales Account GL Profile
BillToDebtor_IDintegernoBill-To Customer
DebtorType_IDintegernoCustomer Type
DebtorCreditRating_IDintegernoCredit Rating
PrePayControlGLProfile_IDintegeryesControl GL Profile (Pre-payment)
DeductionCtrlGLProfile_IDintegernoLink to Deduction Profile
Employee_IDintegernoLink to Employee
BillSchedule_IDintegernoLink to BillSchedule
DebtorCodecharacter(8)yesA 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.
DebtorIsActivelogicalyesIndicate if this is an active record.
api annotation:Value for this field defaults to false.
VatPercentageLevelcharacter(20)yesTax 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}
DebtorIsPrintStatementlogicalyesIndicate 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.
DebtorIsPrintReminderlogicalyesIndicate if reminders are typically printed for this customer to report past due balances.
api annotation:Value for this field defaults to false.
DomiciliationNumberintegernoDomiciliation Number
DebtorIsTaxablelogicalyesIndicate 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.
DebtorIsTaxInCitylogicalyesThis 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.
DebtorIsTaxIncludedlogicalyesTax Is Included
DebtorTaxIDFederalcharacter(18)noFederal Tax- the tax ID assigned to this address by the federal or national government.
api annotation:Value for the field defaults to null.
DebtorTaxIDStatecharacter(18)noState 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.
DebtorTaxIDMisc1character(18)noMiscellaneous 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.
DebtorTaxIDMisc2character(18)noMiscellaneous Tax 2
DebtorTaxIDMisc3character(18)noMiscellaneous Tax 3
DebtorTaxDeclarationintegernoTax Declaration
DebtorIsFixedCredLimlogicalyesIndicate if the credit limit of the customer is fixed.
api annotation:Value for this field defaults to false.
DebtorFixedCredLimTCdecimal(4)noWhen 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 .
DebtorIsTurnOverCredLimlogicalyesIndicate whether you can enter a percentage in the Percentage of Turnover field.
api annotation:Value for this field defaults to false.
DebtorPercTurnOverCredLimdecimal(2)noWhen 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 .
DebtorIsMaxDaysDueCredLimlogicalyesIndicate whether you can enter a value in the Maximum Number of Days field or not.
api annotation:Value for this field defaults to false.
DebtorMaxNumDaysCredLimintegernoSpecify 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.
DebtorIsInclOpenItmCredLimlogicalyesIndicate whether to include the balance of unpaid invoices or not.
api annotation:Value for this field defaults to false.
ObsoleteInclPreInvCredLimlogicalyesInclude Pre-Invoices
DebtorIsInclSOCredLimlogicalyesIndicate whether to include the balance of open sales orders in the system.
api annotation:Value for this field defaults to false.
DebtorIsInclDraftCredLimlogicalyesIndicate whether to include the balance of open drafts in the system.
api annotation:Value for this field defaults to false.
DebtorIsCheckBefSOCredLimlogicalyesIndicate whether to perform the credit check before a new order is entered or not.
api annotation:Value for this field defaults to false.
DebtorIsCheckAftSOCredLimlogicalyesIndicate 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.
ObsoleteCheckBefPICredLimlogicalyesCheck before Pre-Invoice Entry
ObsoleteCheckAftPICredLimlogicalyesCheck after Pre-Invoice Entry
DebtorIsCheckBefDICredLimlogicalyesIndicate whether to perform the credit check before a new customer invoice is entered.
api annotation:Value for this field defaults to false.
DebtorIsCheckAftDICredLimlogicalyesIndicate 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.
DebtorPercWarningCredLimdecimal(2)noSelect 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 .
DebtorIsOverruleSOCredLimlogicalyesIndicate 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.
ObsoleteOverrulePICredLimlogicalyesOverrule Allowed
DebtorIsOverruleDICredLimlogicalyesIndicate 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.
DebtorIsLockedCredLimlogicalyesIndicate whether to put this customer on hold.
api annotation:Value for this field defaults to false.
DebtorIsToBeLockedCredLimlogicalyesIndicate 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.
DebtorIsWithPreInvGrouplogicalyesIndicate if Customer is Member of Pre-Invoice Group or not.
api annotation:Value for this field defaults to false.
ObsoleteGroupingSOOnPreInvlogicalyesGroup Customer's SO on Pre-Invoice
DebtorIsInvoiceByAuthlogicalyesIndicate how invoice totals should be calculated and displayed for this customer.
api annotation:Value for this field defaults to false.
DebtorDBNumbercharacter(12)noThe credit agency reference number assigned to this customer.
api annotation:Value for this field defaults to null.
DebtorIsFinanceChargelogicalyesIndicate whether to make this customer’s accounts liable for finance charges or not.
api annotation:Value for this field defaults to false.
DebtorStatementCyclecharacter(4)noA value to indicate how often you normally print AR statements for this customer.
api annotation:Value for this field defaults to null.
DebtorLastPaymentdatenoLast payment date.
api annotation:The system automatically updates this date when transactions are posted in Banking Entry, Petty Cash, and Customer Payments.
DebtorLastSaledatenoThe date an invoice was last posted for this customer.
api annotation:This date is updated by Invoice Post and Print.
DebtorHighCreditdecimal(4)noThe highest amount of credit you have ever extended to this customer. This is the largest AR balance they have had open at one time.
DebtorHighCreditDatedatenoThe date the highest credit amount was extended to this customer.
DebtorLastCreditReviewdatenoThe date when the customer’s credit status was last reviewed.
DebtorLastCreditUpdatedatenoThe date when the customer’s credit status was last updated.
DebtorCommentNotecharacter(2000)noFree-form text related to this customer that is saved with the customer record.
api annotation:Value for this field defaults to null.
DebtorSalesOrderBalancedecimal(4)noCurrent balance of all sales order related to this customer.
api annotation:Value for this field defaults to 0.0000 .
DebtorLastFinChargeDatedatenoThe date when finance charge is last calculated for this customer.
api annotation:Value for this field defaults to null.
DebtorTotalDaysLateintegernoTotal Days Late
DebtorTotalNbrOfInvoicesintegernoNumber of paid invoices related to this customer.
DebtorIsPrintBillWithItemDetlogicalyesBill With Item Details
TxzTaxZonecharacter(16)yesThe 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.
TxclTaxClscharacter(3)noA 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.
TxuTaxUsagecharacter(8)noA 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_IDintegernoLink to PreInvGroup
tlBusinessRelationIsIntercologicalnoIndicate 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.
tcNormalPaymentConditionTypecharacter(20)noThe type of credit term code associated with this customer.
api annotation:Value for this field relates to the field NormalPaymentCondition.
tcInvControlGLProfileCodecharacter(20)yesSpecify the valid, active GL profile of type Customer Account used to determine the accounts receivable GL control account for invoices.
tcCnControlGLProfileCodecharacter(20)yesSpecify the valid, active GL profile of type Customer Account used to determine the accounts receivable GL control account for credit notes.
tcFinanceChgProfileCodecharacter(20)noSpecify 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.
tcDivisionProfileCodecharacter(20)noOptionally 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.
tcSalesAccountGLProfileCodecharacter(20)yesSpecify the valid GL profile of type Sales Account used to determine the account for sales.
tcPrepayControlGLProfileCodecharacter(20)yesSpecify the valid, active GL profile of type Customer Account used to determine the accounts receivable GL control account for prepayments.
tcBLWIGroupCodecharacter(20)noSpecify the default group associated with this customer for Belgian-Luxembourgian BLWI reporting.
api annotation:The default value is 999.
tcNormalPaymentConditionCodecharacter(8)yesSpecify the default credit terms for this customer.
tcBusinessRelationName1character(36)yesThe name of business relation which is associated with this customer.
tcBusinessRelationCodecharacter(20)yesA business relation code associated with this customer.
api annotation:Address and contact details default from the headoffice address type of the business relation.
tcReasonCodecharacter(20)yesSpecify the default invoice status for invoices for this customer.
tcCurrencyCodecharacter(3)yesSpecify the currency code for this customer.
api annotation:Currency defaults from the current domain base currency, but can be modified.
tcPaymentGroupCodecharacter(20)noSpecify a payment group in which you want to include this customer.
api annotation:Value for this field defaults to null.
tcDebtorTypeCodecharacter(4)noAn optional code classifying customers by type.
api annotation:Value for this field defaults to null.
tcBillToDebtorCodecharacter(8)noAn optional code that identifies another customer that receives the bills for this customer.
api annotation:Value for this field defaults to null.
tcDebtorCreditRatingCodecharacter(8)noAn 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.
tcDeductionCtrlGLProfileCodecharacter(20)no
tcEmployeeCodecharacter(8)no
tcBillScheduleCodecharacter(20)no
CustomShort0character(20)noCustom Short Field
CustomShort1character(20)noCustom Short Field
CustomShort2character(20)noCustom Short Field
CustomShort3character(20)noCustom Short Field
CustomShort4character(20)noCustom Short Field
CustomShort5character(20)noCustom Short Field
CustomShort6character(20)noCustom Short Field
CustomShort7character(20)noCustom Short Field
CustomShort8character(20)noCustom Short Field
CustomShort9character(20)noCustom Short Field
CustomCombo0character(20)noCustom Combo Field
CustomCombo1character(20)noCustom Combo Field
CustomCombo2character(20)noCustom Combo Field
CustomCombo3character(20)noCustom Combo Field
CustomCombo4character(20)noCustom Combo Field
CustomCombo5character(20)noCustom Combo Field
CustomCombo6character(20)noCustom Combo Field
CustomCombo7character(20)noCustom Combo Field
CustomCombo8character(20)noCustom Combo Field
CustomCombo9character(20)noCustom Combo Field
CustomLong0character(255)noCustom Long Field
CustomLong1character(255)noCustom Long Field
CustomNotecharacter(2000)noCustom Note Field
CustomDate0datenoCustom Date Field
CustomDate1datenoCustom Date Field
CustomDate2datenoCustom Date Field
CustomDate3datenoCustom Date Field
CustomDate4datenoCustom Date Field
CustomInteger0integernoCustom Integer Field
CustomInteger1integernoCustom Integer Field
CustomInteger2integernoCustom Integer Field
CustomInteger3integernoCustom Integer Field
CustomInteger4integernoCustom Integer Field
CustomDecimal0decimal(4)noCustom Decimal Field
CustomDecimal1decimal(4)noCustom Decimal Field
CustomDecimal2decimal(4)noCustom Decimal Field
CustomDecimal3decimal(4)noCustom Decimal Field
CustomDecimal4decimal(4)noCustom Decimal Field
CustomShort10character(20)noCustom Short Field
CustomShort11character(20)noCustom Short Field
CustomShort12character(20)noCustom Short Field
CustomShort13character(20)noCustom Short Field
CustomShort14character(20)noCustom Short Field
CustomShort15character(20)noCustom Short Field
CustomShort16character(20)noCustom Short Field
CustomShort17character(20)noCustom Short Field
CustomShort18character(20)noCustom Short Field
CustomShort19character(20)noCustom Short Field
CustomCombo10character(20)noCustom Combo Field
CustomCombo11character(20)noCustom Combo Field
CustomCombo12character(20)noCustom Combo Field
CustomCombo13character(20)noCustom Combo Field
CustomCombo14character(20)noCustom Combo Field
CustomDecimal5decimal(4)noCustom Decimal Field
CustomDecimal6decimal(4)noCustom Decimal Field
CustomDecimal7decimal(4)noCustom Decimal Field
CustomDecimal8decimal(4)noCustom Decimal Field
CustomDecimal9decimal(4)noCustom Decimal Field
CustomDate5datenoCustom Date Field
CustomDate6datenoCustom Date Field
CustomDate7datenoCustom Date Field
CustomDate8datenoCustom Date Field
CustomDate9datenoCustom Date Field
LastModifiedDatedatenoLast Modified Date
LastModifiedTimeintegernoLast Modified Time
LastModifiedUsercharacter(20)noLast Modified User
QADC01character(40)nounused QAD reserved field
QADC02characternounused QAD reserved field
QADT01datenounused QAD reserved field
QADD01decimal(10)nounused QAD reserved field
tc_Rowidcharacteryesprimary index
tc_ParentRowidcharacternoempty string
tc_Statuscharacternoupdate status

table tDebtorSafDefault


field namedata typemnd.description
DebtorSafDefault_IDintegeryesRecord ID
Debtor_IDintegeryesLink to Debtor
SafConcept_IDintegeryesSAF Concept Code
Saf_IDintegeryesSAF Code
tcSafConceptCodecharacter(20)yesSpecify an SAF concept code as default for this customer.
tcSafCodecharacter(20)yesSpecify an SAF code under the used saf concept code.
LastModifiedDatedatenoLast Modified Date
LastModifiedTimeintegernoLast Modified Time
LastModifiedUsercharacter(20)noLast Modified User
QADC01character(40)nounused QAD reserved field
QADC02characternounused QAD reserved field
QADT01datenounused QAD reserved field
QADD01decimal(10)nounused QAD reserved field
tc_Rowidcharacteryesprimary index
tc_ParentRowidcharacteryes = tDebtor.tc_Rowid
tc_Statuscharacternoupdate status

table tCustomTable0

Description

Empty table intended for non-intrusive customization only

field namedata typedescription
tcCustomShort0character
tcCustomShort1character
tcCustomShort2character
tcCustomShort3character
tcCustomShort4character
tcCustomShort5character
tcCustomShort6character
tcCustomShort7character
tcCustomShort8character
tcCustomShort9character
tcCustomCombo0character
tcCustomCombo1character
tcCustomCombo2character
tcCustomCombo3character
tcCustomCombo4character
tcCustomCombo5character
tcCustomCombo6character
tcCustomCombo7character
tcCustomCombo8character
tcCustomCombo9character
tcCustomLong0character
tcCustomLong1character
tcCustomNotecharacter
ttCustomDate0date
ttCustomDate1date
ttCustomDate2date
ttCustomDate3date
ttCustomDate4date
tiCustomInteger0integer
tiCustomInteger1integer
tiCustomInteger2integer
tiCustomInteger3integer
tiCustomInteger4integer
tdCustomDecimal0decimal(4)
tdCustomDecimal1decimal(4)
tdCustomDecimal2decimal(4)
tdCustomDecimal3decimal(4)
tdCustomDecimal4decimal(4)
tc_RowidcharacterUse this data item to add as a field in public temp-tables (with index).
tc_ParentRowidcharacter
tc_Statuscharacter

table tCustomTable1

Description

Empty table intended for non-intrusive customization only

field namedata typedescription
tcCustomShort0character
tcCustomShort1character
tcCustomShort2character
tcCustomShort3character
tcCustomShort4character
tcCustomShort5character
tcCustomShort6character
tcCustomShort7character
tcCustomShort8character
tcCustomShort9character
tcCustomCombo0character
tcCustomCombo1character
tcCustomCombo2character
tcCustomCombo3character
tcCustomCombo4character
tcCustomCombo5character
tcCustomCombo6character
tcCustomCombo7character
tcCustomCombo8character
tcCustomCombo9character
tcCustomLong0character
tcCustomLong1character
tcCustomNotecharacter
ttCustomDate0date
ttCustomDate1date
ttCustomDate2date
ttCustomDate3date
ttCustomDate4date
tiCustomInteger0integer
tiCustomInteger1integer
tiCustomInteger2integer
tiCustomInteger3integer
tiCustomInteger4integer
tdCustomDecimal0decimal(4)
tdCustomDecimal1decimal(4)
tdCustomDecimal2decimal(4)
tdCustomDecimal3decimal(4)
tdCustomDecimal4decimal(4)
tc_RowidcharacterUse this data item to add as a field in public temp-tables (with index).
tc_ParentRowidcharacter
tc_Statuscharacter

table tCustomTable2

Description

Empty table intended for non-intrusive customization only

field namedata typedescription
tcCustomShort0character
tcCustomShort1character
tcCustomShort2character
tcCustomShort3character
tcCustomShort4character
tcCustomShort5character
tcCustomShort6character
tcCustomShort7character
tcCustomShort8character
tcCustomShort9character
tcCustomCombo0character
tcCustomCombo1character
tcCustomCombo2character
tcCustomCombo3character
tcCustomCombo4character
tcCustomCombo5character
tcCustomCombo6character
tcCustomCombo7character
tcCustomCombo8character
tcCustomCombo9character
tcCustomLong0character
tcCustomLong1character
tcCustomNotecharacter
ttCustomDate0date
ttCustomDate1date
ttCustomDate2date
ttCustomDate3date
ttCustomDate4date
tiCustomInteger0integer
tiCustomInteger1integer
tiCustomInteger2integer
tiCustomInteger3integer
tiCustomInteger4integer
tdCustomDecimal0decimal(4)
tdCustomDecimal1decimal(4)
tdCustomDecimal2decimal(4)
tdCustomDecimal3decimal(4)
tdCustomDecimal4decimal(4)
tc_RowidcharacterUse this data item to add as a field in public temp-tables (with index).
tc_ParentRowidcharacter
tc_Statuscharacter