| field name | data type | mnd. | description |
|---|---|---|---|
| DDocument_ID | integer | yes | Record ID |
| Company_ID | integer | yes | Link to Company |
| DCollection_ID | integer | no | Link to DCollection |
| Debtor_ID | integer | yes | Customer |
| Currency_ID | integer | yes | Currency Code |
| GL_ID | integer | yes | Bank Account |
| CreationUsr_ID | integer | no | Login |
| BankNumber_ID | integer | yes | Link to BankNumber |
| DPaySel_ID | integer | no | Link to DPaySel |
| DDocumentType | character(20) | yes | Payment Instrument. The system displays the payment instrument associated with the payment format linked to the customer bank. |
| value list: | {&PAYFORMATPAYINSTRUMENTS-AR} | ||
| DDocumentSubType | character(20) | yes | Subtype. This read-only field indicates that the payment is manual or automatic. You create manual customer payments through the Customer Payment activities, and automatic payments through the Customer Payment Selections. |
| value list: | {&DOCUMENTSUBTYPES} | ||
| DDocumentYear | integer | yes | Year/Number. This field displays the accounting year and payment sequence number, which is automatically generated by the accounting year. |
| DDocumentNumber | integer | yes | Document Number. This field hold a unified number for report use. |
| DDocumentReference | character(40) | no | Reference. Reference text for the payment. |
| DDocumentOriginalCreditTC | decimal(4) | no | TC Original Credit. This field holds the debit value of the payment in transaction currency. |
| DDocumentOriginalCreditLC | decimal(4) | no | BC Original Credit.This field holds the amount of the Payment in baisc currency. |
| DDocumentOriginalCreditCC | decimal(4) | no | SC Original Credit. This field hold the amount of the payment in management currency. |
| DDocumentOriginalDebitTC | decimal(4) | no | Amount.This field hold the value of the payment in the transaction currency. This field must be positive and can be entered manually or automatically by linking the payment to an open item. |
| DDocumentOriginalDebitLC | decimal(4) | no | TC Original Debit. This field holds the debit value of the payment in base currency. |
| DDocumentOriginalDebitCC | decimal(4) | no | TC Original Debit. This field holds the debit value of the payment in management currency. |
| DDocumentIsOpen | logical | yes | Open. This field indicates if the payment is completely paid already. |
| DDocumentDueDate | date | no | Due Date. The date on which the payment is receivable. |
| DDocumentStatus | character(20) | no | Status. The payment status. The default value for a new record is Initial. |
| value list: | {&DOCUMENTSTATUSDEBTORS} | ||
| DDocumentValueDays | integer | yes | Value Days. A value for the number of days required by the bank to process the transaction. The default is based on the payment status entered. |
| DDocumentCreationDate | date | yes | Creation Date.This field indicate the payment creation date. This field is read-only. |
| DDocumentTimesPrinted | integer | yes | Times Printed.This field indicates the number of times the payment has been printed. This field is read-only. |
| DDocumentLastPrintDate | date | no | Last Printed Date. This field indicates the most recent printing date. |
| DDocumentOriginalDebitBC | decimal(4) | no | BC Original Debit |
| DDocumentOriginalCreditBC | decimal(4) | no | BC Original Credit |
| DDocumentCreationTime | integer | no | Creation Time. The time payment is created. |
| DDocumentIncassoSelectCode | character(20) | no | Customer Payment Selection Code. This field displays the customer payment selection code. This field is read-only. |
| DDocumentExchangeRate | decimal(10) | no | Exchange Rate. This field holds the exchange rate applying to the transaction currency. |
| DDocumentRateScale | decimal(10) | no | Scale Factor. This field indicates the scaling factor applying to the transaction currency. |
| DDocumentCCRate | decimal(10) | no | SC Rate. The statutory scaling factor applying to the transaction currency. |
| DDocumentCCScale | decimal(10) | no | SC Rate Scale. The statutory exchange rate used by the invoice. |
| DDocumentClosingDate | date | no | Closing Date. The closing date of the payment. |
| DDocumentBankImpRef | character(255) | no | Bank Importing Reference |
| DDocumentTransTpStat | character(20) | no | Transaction Type Status |
| tcBusinessRelationCode | character(20) | no | Business Relation.This field identifies the business relation associated with the customer. |
| tcBusinessRelationName | character(36) | no | Business Relation Name.The business relation name associated with the customer. |
| tlInvoicesLinked | logical | no | Invoices Linked. This field indicates if the payment is linked to an invoice. |
| ttPostingDate | date | no | Posting Date. This field indicates the date the payment is posted. |
| tcPostingRowId | character(40) | no | Posting Row ID |
| tcDebtorBankNumber | character(20) | no | Customer Bank.The customer bank accosiated with the bank GL account. |
| tcPayFormatTypeCode | character(20) | no | Payment Format. This field identifies the payment format used by the payment. |
| tcPaymentLevelPayCode | character(20) | no | Payment level Code. This field identifies the Payment level formats used by the payment. |
| tcDebtorCode | character(8) | yes | Customer. Specify the code that identifies the customer making a payment. The system loads the customers default bank information defined in the Banking tab of Customer Create. Most bank details default from the bank and cannot be modified. |
| tcCurrencyCode | character(3) | yes | Currency. This field identifies the currency of the payment. The payment currency must be the same as that of the open item against which you allocate the payment. Currency information is contained in the payment format linked to your bank account, and you ensure that the currencies match by selecting the correct bank account. |
| tcGLCode | character(8) | yes | Bank Account. The GL account of type bank receiving the payment. If you specify a customer first, the banking details default from the customer. |
| tcCreationUsrLogin | character(20) | no | Login. This field displays the login ID of the user who create the payment. |
| tcOwnBankNumber | character(20) | no | Own Bank Number. This field displays the account number that receives payments from this customer. This number is defined on the customer record, and is normally the default bank account number for the entity you are currently working in. |
| tcPostingText | character | no | Value of this field is used as posting and posting line description. |
| tcBusinessRelationSearch | character(28) | no | |
| tcExternalUniqueIdentifier | 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 |
| 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 |
| field name | data type | mnd. | description |
|---|---|---|---|
| DDocInvoiceXrefStage_ID | integer | yes | Record ID |
| DDocumentInvoiceXref_ID | integer | yes | Link to DDocumentInvoiceXref |
| DInvoiceStage_ID | integer | no | Link to DInvoiceStage |
| DDocument_ID | integer | no | Link to DDocument |
| DDocInvoiceXrefStageAlloTC | decimal(4) | no | Stage TC Allocated. This field holds the payeent amount to be paid in the stage in transaction currency. |
| DDocInvoiceXrefStageDiscTC | decimal(4) | no | Stage Discount. This field indicates the payment discount amount in this stage in transaction currency. |
| DDocInvoiceXrefStagePaidAmtTC | decimal(4) | no | TC Paid Amount |
| tdDefaultPaymentAmountTC | decimal(4) | no | TC Payment Amount. This field indicates the payment amount in this stage in transaction currency. |
| tdDefaultDiscountAmountTC | decimal(4) | no | TC Discount Amount |
| tdDefaultDiscountPerc | decimal(2) | no | Default Discount Percentage |
| tiDInvoice_ID | integer | yes | |
| ttDefaultDueDate | date | no | Stage Due Date |
| ttDefaultDiscDate | date | no | Stage discount date |
| tdDefaultAllocAmountTC | decimal(4) | no | Default allocation amount |
| tlUIFullAllocation | logical | no | Full allocation of the staged payment |
| 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 | yes | = tDDocumentInvoiceXref.tc_Rowid |
| tc_Status | character | no | update status |
| field name | data type | mnd. | description |
|---|---|---|---|
| DDocumentInvoiceXref_ID | integer | yes | Record ID |
| DDocument_ID | integer | yes | Link to DDocument |
| DInvoice_ID | integer | no | Link to DInvoice |
| DDocumentInvoiceXrefAlloTC | decimal(4) | yes | TC Allocated Amount. This field indicates the invocie amount already Allocated in transaction currency. |
| DDocumentInvoiceXrefDiscTC | decimal(4) | yes | TC Discount Amount. This field indicates the discount amount of the invoice already allocated by transaction currency. |
| DDocumentInvoiceXrefIntTC | decimal(4) | no | TC Interest Amount |
| DDocumentInvoiceXrefPaidAmtTC | decimal(4) | no | TC Paid Amount |
| tcAllocAmountCrDt | character(2) | no | AllocateAmountCrDt. This field indicates that the payment is a credit or debit. |
| tcBusinessRelationCode | character(20) | no | Business Relation.The business relation code linked to the customer. This field is calculated by the system using the customer code. |
| tcDInvoiceBalanceCrDt | character(2) | no | Invoice Balance DR/CR. This field indicates that the customer invocie is a credit or debit before the payment. |
| tcDInvoiceReference | character(40) | no | Reference. An alphanumeric reference to help identify the invoice in the system. This reference is typically the ID number of the invoice received from the customer. |
| tcShipperCode | character(20) | no | Shipper. A shipper number to select invoices related to a specific shipment. This field applies to automatically created salesrelated invoices. |
| tcDInvoiceType | character(20) | no | Invoice Type. This field identifies the invoice type. |
| tcCompanyCode | character(20) | no | Entity Code. This field identifies the entity of the invocie. |
| tcCurrencyCode | character(20) | no | Currency Code.This filed identifies the currency used by the customer invoice. |
| tcNewBalanceCrDt | character(2) | no | New Invoice Balance DR/CR. This field indicates that the customer invocie is a credit or debit after the payment. |
| tdDInvoiceBalance | decimal(4) | no | Invoice Balance. This field holds the balance of the customer invoice before the payment. |
| tdDiscountPercentage | decimal(2) | no | Discount Percentage. When the invoice is paid before the discount due date, this is the discount percentage that can be given. |
| tdNewBalance | decimal(4) | no | Invoice Balance. This field holds the balance of the customer invoice after the payment. |
| tlUIFullAllocation | logical | no | Full. This field indicates if the payment is already completely paid or not. |
| ttDInvoiceDate | date | no | Invoice Date. This field indicates the invoice creation date. |
| ttDInvoiceDiscountDueDate | date | no | Discount Due Date.This field indicates the last date a discount applies, calculated by the system based on the credit terms and the invoice date. |
| ttDInvoiceDueDate | date | no | Due Date.This field indicates the date when payment become due. This field can be modified without affecting the credit terms. This field is calculated by the system based on the credit terms and the invoice date. |
| tdDefaultDiscountAmount | decimal(4) | no | Default discount Amount. This field holds the discount amount of the customer invoice calculated using the default discount rate. |
| tdDefaultPaymentAmount | decimal(4) | no | Default payment Amount. The Default payment Amount of the invoice. |
| tcDebtorCode | character(20) | no | Customer Code. The code that identifies the customer to be paid with this invoice. This field is calculated by the system. |
| tcDivisionCode | character(20) | no | Sub-Account Code. This field displays the code of sub-account if the customer control account is defined with sub-account analysis. This sub-account applies to all invoice posting lines. This field can be blank. |
| tdVatBaseTC | decimal(4) | no | if tdDInvoiceVatBaseDebitTC <> 0 =>tdDInvoiceVatBaseDebitTC if tdDInvoiceVatBaseDebitTC = 0 =>tdDInvoiceVatBaseCreditTC |
| tdVatTC | decimal(4) | no | if tdDInvoiceVatDebitTC <> 0 => tdDInvoiceVatDebitTC if tdDInvoiceVatDebitTC = 0 => tdDInvoiceVatCreditTC |
| tcVatBaseCrDt | character(20) | no | VatBaseCrDt. This field indicates if the Tax base amount is a credit or debit. |
| tcVatCrDt | character(20) | no | Tax CR/CR. This field indicates if the Tax amount of the customer invoice is a credit or debit. |
| tiDInvoicePostingId | integer | no | Invoice Posting ID. This field hold the posting ID(s) which handle(s) the payment of the invoices. |
| tcVatCountryCode | character(20) | no | Invoice Tax Country Code. This field indicates the tax Country of the invoice. |
| tlDiscountTaxAtPayment | logical | no | Discount Tax at payment. This field holds the discount tax amount when the invoice is paid. |
| tcCostCentreCode | character(20) | no | Cost Center Code. The cost center to which this invoice is to be posted. |
| tcProjectCode | character(20) | no | Project. The project to which this invoice is to be posted. |
| tcCorporateGroupCode | character(20) | no | Group Name. This field indicates the group the corporation belongs to. |
| tcBusinessRelationName1 | character | no | Business Relation Name.The business relation name associated with the customer. |
| tcDInvoiceDIText | character(32) | no | Legacy Invoice Number |
| tdDDocumentInvoiceXrefPaidTC | decimal(4) | no | Obsolete field (replaced by CDocumentInvoiceXrefPayTC) |
| tdNonDiscAmtTC | decimal(4) | no | Invoice Non Discountable Amount. This field display the invoice amount without discount in transaction currency. |
| tdLCExchangeRate | decimal(10) | no | Exchange Rate. The exchange rate used by the invoice. |
| tdLCExchangeRateScale | decimal(10) | no | Scale Factor. This field indicates the scale factor applying to the exchange rate in use for foreign currency payments. |
| tdCCExchangeRate | decimal(10) | no | SC Rate. The statutory exchange rate used by the invoice. |
| tdCCExchangeRateScale | decimal(10) | no | Scale Factor. This field indicates the scale factor applying to the SC rate in use for foreign currency payments. |
| tcDeductionCatCode | character | no | Deduction Catagory Code |
| tiDeductionCatLine_ID | integer | no | |
| tcDInvoiceDeductionStatus | character | no | |
| tdDeductionTC | decimal(2) | no | |
| tcDInvoiceDeductionParentRowID | character | no | |
| tcDInoviceDeductionCusReference | character(40) | no | |
| tcDInvoiceTSMNumber | character | no | contains the customer TSM Number |
| tiBillNumber | integer | no | |
| tcBillStatus | character | no | |
| tiBillYear | integer | no | |
| 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 | yes | = tDDocument.tc_Rowid |
| tc_Status | character | no | update status |
| field name | data type | mnd. | description |
|---|---|---|---|
| DDocumentPostingLine_ID | integer | yes | Record ID |
| DDocument_ID | integer | yes | Link to DDocument |
| PostingLine_ID | integer | yes | Link to PostingLine |
| DDocumentStatus | character(20) | no | Customer Payment Status. This field indicats the customer payment status. At a minimum, you must have two statuses: Paid and Void |
| value list: | {&DOCUMENTSTATUSDEBTORS} | ||
| 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 | yes | = tDDocument.tc_Rowid |
| tc_Status | character | no | update status |
| field name | data type | description |
|---|---|---|
| tcCustomShort0 | character | |
| tcCustomShort1 | character | |
| tcCustomShort2 | character | |
| tcCustomShort3 | character | |
| tcCustomShort4 | character | |
| tcCustomShort5 | character | |
| tcCustomShort6 | character | |
| tcCustomShort7 | character | |
| tcCustomShort8 | character | |
| tcCustomShort9 | character | |
| tcCustomCombo0 | character | |
| tcCustomCombo1 | character | |
| tcCustomCombo2 | character | |
| tcCustomCombo3 | character | |
| tcCustomCombo4 | character | |
| tcCustomCombo5 | character | |
| tcCustomCombo6 | character | |
| tcCustomCombo7 | character | |
| tcCustomCombo8 | character | |
| tcCustomCombo9 | character | |
| tcCustomLong0 | character | |
| tcCustomLong1 | character | |
| tcCustomNote | character | |
| ttCustomDate0 | date | |
| ttCustomDate1 | date | |
| ttCustomDate2 | date | |
| ttCustomDate3 | date | |
| ttCustomDate4 | date | |
| tiCustomInteger0 | integer | |
| tiCustomInteger1 | integer | |
| tiCustomInteger2 | integer | |
| tiCustomInteger3 | integer | |
| tiCustomInteger4 | integer | |
| tdCustomDecimal0 | decimal(4) | |
| tdCustomDecimal1 | decimal(4) | |
| tdCustomDecimal2 | decimal(4) | |
| tdCustomDecimal3 | decimal(4) | |
| tdCustomDecimal4 | decimal(4) | |
| tc_Rowid | character | Use this data item to add as a field in public temp-tables (with index). |
| tc_ParentRowid | character | |
| tc_Status | character |
| field name | data type | description |
|---|---|---|
| tcCustomShort0 | character | |
| tcCustomShort1 | character | |
| tcCustomShort2 | character | |
| tcCustomShort3 | character | |
| tcCustomShort4 | character | |
| tcCustomShort5 | character | |
| tcCustomShort6 | character | |
| tcCustomShort7 | character | |
| tcCustomShort8 | character | |
| tcCustomShort9 | character | |
| tcCustomCombo0 | character | |
| tcCustomCombo1 | character | |
| tcCustomCombo2 | character | |
| tcCustomCombo3 | character | |
| tcCustomCombo4 | character | |
| tcCustomCombo5 | character | |
| tcCustomCombo6 | character | |
| tcCustomCombo7 | character | |
| tcCustomCombo8 | character | |
| tcCustomCombo9 | character | |
| tcCustomLong0 | character | |
| tcCustomLong1 | character | |
| tcCustomNote | character | |
| ttCustomDate0 | date | |
| ttCustomDate1 | date | |
| ttCustomDate2 | date | |
| ttCustomDate3 | date | |
| ttCustomDate4 | date | |
| tiCustomInteger0 | integer | |
| tiCustomInteger1 | integer | |
| tiCustomInteger2 | integer | |
| tiCustomInteger3 | integer | |
| tiCustomInteger4 | integer | |
| tdCustomDecimal0 | decimal(4) | |
| tdCustomDecimal1 | decimal(4) | |
| tdCustomDecimal2 | decimal(4) | |
| tdCustomDecimal3 | decimal(4) | |
| tdCustomDecimal4 | decimal(4) | |
| tc_Rowid | character | Use this data item to add as a field in public temp-tables (with index). |
| tc_ParentRowid | character | |
| tc_Status | character |
| field name | data type | description |
|---|---|---|
| tcCustomShort0 | character | |
| tcCustomShort1 | character | |
| tcCustomShort2 | character | |
| tcCustomShort3 | character | |
| tcCustomShort4 | character | |
| tcCustomShort5 | character | |
| tcCustomShort6 | character | |
| tcCustomShort7 | character | |
| tcCustomShort8 | character | |
| tcCustomShort9 | character | |
| tcCustomCombo0 | character | |
| tcCustomCombo1 | character | |
| tcCustomCombo2 | character | |
| tcCustomCombo3 | character | |
| tcCustomCombo4 | character | |
| tcCustomCombo5 | character | |
| tcCustomCombo6 | character | |
| tcCustomCombo7 | character | |
| tcCustomCombo8 | character | |
| tcCustomCombo9 | character | |
| tcCustomLong0 | character | |
| tcCustomLong1 | character | |
| tcCustomNote | character | |
| ttCustomDate0 | date | |
| ttCustomDate1 | date | |
| ttCustomDate2 | date | |
| ttCustomDate3 | date | |
| ttCustomDate4 | date | |
| tiCustomInteger0 | integer | |
| tiCustomInteger1 | integer | |
| tiCustomInteger2 | integer | |
| tiCustomInteger3 | integer | |
| tiCustomInteger4 | integer | |
| tdCustomDecimal0 | decimal(4) | |
| tdCustomDecimal1 | decimal(4) | |
| tdCustomDecimal2 | decimal(4) | |
| tdCustomDecimal3 | decimal(4) | |
| tdCustomDecimal4 | decimal(4) | |
| tc_Rowid | character | Use this data item to add as a field in public temp-tables (with index). |
| tc_ParentRowid | character | |
| tc_Status | character |