| field name | data type | mnd. | description |
|---|
| PaySel_ID | integer | yes | Record ID |
| GL_ID | integer | yes | Account |
| Company_ID | integer | yes | Link to Company |
| BankPayFormat_ID | integer | yes | Link to BankPayFormat |
| PaySelCode | character(20) | yes | Code |
| PaySelDate | date | yes | Execution Date |
| PaySelStatus | character(20) | yes | Status |
| value list: | | {&PAYMENTSELECTIONSTATUSS} |
| tdBankAccountTotalBalanceBC | decimal(4) | no | Current Balance |
| tcBankNumber | character(40) | no | Account Number |
| tdPaySelTotalAmountBC | decimal(4) | no | Payment Total |
| tcPaySelCurrencyCode | character | no | Currency |
| tlIsMultipleFormat | logical | no | Multiple Format |
| tiPostingYear | integer | no | Posting Year/GL Period |
| tiPostingPeriod | integer | no | GL Period |
| ttPostingDate | date | no | Posting Date |
| tcPostingJournal | character | no | Daybook/Voucher |
| tcLayerCode | character | no | Layer |
| tcTransferAccountGLCode | character(20) | no | Transfer Account |
| tcAPDiscountAccountGLCode | character(20) | no | Discount Account |
| tcTransferAccountGLDesc | character(40) | no | Description |
| tcAPDiscountAccountGLDesc | character(40) | no | Description |
| tcGLDescription | character | no | Description |
| tiPostingVoucher | integer | no | Voucher |
| tcCreditTR | character(6) | no | CR |
| tcDebitTR | character(6) | no | DR |
| tiNumDec | integer | no | NumDec |
| tcPayFormatTypeCode | character(20) | no | Pay Format |
| tlCreditDirectlyOnBank | logical | no | Credit Directly on Bank |
| tcGLCode | character(8) | yes | Account |
| tlDocumentPerDueDate | logical | no | |
| tcPayFormatTypePayInstrument | character(40) | no | |
| tcBankNumberFormatted | character(40) | no | |
| tlBankNumberIsBankCharge | logical | no | |
| tiOwnBankNumberId | integer | 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 |
|---|
| PaySelLine_ID | integer | yes | Record ID |
| PaySel_ID | integer | yes | Link to PaySel |
| PaySelLineAmountTC | decimal(4) | no | Amount |
| PaySelLineDiscountTC | decimal(4) | no | Discount |
| PaySelLineObjectType | character(20) | yes | Type |
| value list: | | {&PAYMENTSELECTIONTYPES} |
| PaySelLineParentObject_ID | integer | no | Parent Object |
| PayFormatTypeCode | character(20) | no | Payment format of the payment selection |
| BankNumber_ID | integer | no | Link to BankNumber |
| PaySelLineIntAmtTC | decimal(4) | no | TC Interest Amount |
| PaySelLineIsRefInFile | logical | no | Ref in File |
| PaySelLineWHTAmtTC | decimal(4) | no | TC WHT Amount |
| PaySelLineWHTAmtLC | decimal(4) | no | BC WHT Amount |
| PaySelLineWHTAmtCC | decimal(4) | no | SC WHT Amount |
| PaySelLineIsConfirmed | logical | yes | PaySelLine is confirmed |
| tcBusinessRelationCode | character | no | Business Relation |
| tcInternalNumber | character | no | Internal Number |
| tcTSM | character | no | TSM |
| ttDueDate | date | no | Due Date |
| ttDiscountDueDate | date | no | Discount Due Date |
| ttInvoiceDate | date | no | Invoice Date |
| tcInvoiceCurrencyCode | character | no | Invoice Currency |
| tdDiscountPercentage | decimal(10) | no | Discount Percentage |
| tdOpenInvoiceAmountTC | decimal(4) | no | Open Amount |
| tdOriginalInvoiceAmountTC | decimal(4) | no | Original Amount |
| tcCreditorCode | character | no | CreditorCode |
| tlProposedLineIsSelected | logical | no | ProposedLineIsSelected |
| tcExternalNumber | character(40) | no | ExternalNumber |
| tdInvoiceRate | decimal(10) | no | Invoice Rate |
| tdInvoiceRateScale | decimal(10) | no | Scale Factor |
| tcDebtorCode | character(20) | no | Customer Code |
| tcInvoiceCrDt | character(2) | no | DR/CR |
| tcPaymentCrDt | character(2) | no | DR/CR |
| tcDivisionCode | character(20) | no | Sub-Account |
| tdOriginalInvoiceAmountNetTC | decimal(4) | no | OriginalInvoiceAmountNetTC |
| tiMaster_ID | integer | no | Identity field of the Master (Creditor, Debtor,...) |
| tcVatCountryCode | character(20) | no | Tax Country Code |
| tcBusinessRelationName1 | character | no | Business Relation Name |
| tdCInvoiceHoldAmountTC | decimal(4) | no | CInvoiceHoldAmountTC |
| tdWHTAmtTC | decimal(4) | no | |
| tdWHTTaxableFeeTC | decimal(4) | no | |
| tdWHTTCLCExchangeRate | decimal(10) | no | |
| tdWHTTCLCRateScale | decimal(10) | no | |
| tdWHTTCCCExchangeRate | decimal(10) | no | |
| tdWHTTCCCRateScale | decimal(10) | no | |
| tdTotWHTAmtTC | decimal(4) | no | |
| tdTotWHTAmtLC | decimal(4) | no | |
| tdCInvoiceTotWHTBaseTC | decimal(4) | no | |
| tdWHTPerc | decimal(2) | no | |
| tlUpdateTax | logical | no | |
| tlCreditorIsWHT | logical | no | |
| tdWHTAmtLC | decimal(4) | no | |
| tdWHTAmtCC | decimal(4) | no | |
| tdCInvoiceWHTAmtTC | decimal(4) | no | |
| tdCInvoiceOriginalTC | decimal(4) | no | |
| tdCInvoiceTotWHTTC | decimal(4) | no | |
| tdCInvoiceWHTUnpaidAmtTC | decimal(4) | no | Unpaid withholding tax amount |
| tdInitiallyAllocatedWHTAmntTC | decimal(4) | no | Withholding tax amount in TC that is allocated but not yet paid in withholding tax |
| tdInvoiceVatBaseTC | decimal(4) | no | |
| tdInvoiceVatTC | decimal(4) | no | |
| tcInvoiceOriginalAmountSign | character(1) | no | |
| tcInvoiceBalanceCrDt | character(10) | no | |
| tdInvoiceBalanceTCSigned | decimal(4) | no | |
| tcDiscountCrDt | character(10) | no | |
| tcGroupUnionType | character | no | |
| tiInvoiceCompany_ID | 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 | = tPaySel.tc_Rowid |
| tc_Status | character | no | update status |
| field name | data type | mnd. | description |
|---|
| PaySelPayCode_ID | integer | yes | Record ID |
| PaySel_ID | integer | yes | Link to PaySel |
| PayFormatCode_ID | integer | no | Link to PayFormatCode |
| PayFormatGroup_ID | integer | no | Link to PayFormatGroup |
| PaySelPayCodeValue | character(40) | no | Value |
| tcPayFormatGroupCode | character(200) | no | Group |
| tiPayFormatGroupSequence | integer | no | Sequence |
| tlPayFormatGroupIsMandatory | logical | no | Mandatory |
| tcPayFormatGroupDataType | character(20) | no | Attribute Data Type |
| tcPayFormatGroupDescription | character(40) | no | Attribute Name Description |
| tcPayFormatGroupInputOption | character(20) | no | Attribute Input Option |
| tcPayFormatCode | character(40) | no | Attribute Value |
| tcPayFormatCodeDescription | character(40) | no | Description |
| tcPayFormatCodeValue | character(40) | no | Value |
| 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 | = tPaySel.tc_Rowid |
| tc_Status | character | no | update status |