| field name | data type | mnd. | description |
|---|---|---|---|
| DPaySel_ID | integer | yes | Record ID |
| Company_ID | integer | yes | Link to Company |
| GL_ID | integer | no | Link to GL |
| BankPayFormat_ID | integer | yes | Link to BankPayFormat |
| DPaySelCode | character(20) | yes | Payment Selection |
| DPaySelDate | date | no | Date |
| DPaySelStatus | character(20) | yes | Status |
| DPaySelIsDocPerDueDate | logical | yes | Create Payment Per Due Date |
| tcBankNumber | character(40) | no | Own Bank Number |
| tdDPaySelTotalAmountBC | decimal(4) | no | |
| tcGLCode | character(8) | no | |
| tcPayFormatTypeCode | character(20) | yes | |
| tcBankCurrencyCode | character(20) | no | |
| tcPayFormatTypePayInstrument | character(20) | no | |
| tcDDocumentType | character(20) | no | Payment Instrument |
| 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. |
| tcDPaySelStatusTR | character | no | |
| tlPaySelIsExecuted | logical | no | |
| tiBankNumber_ID | integer | yes | |
| 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 |
|---|---|---|---|
| DPaySelLine_ID | integer | yes | Record ID |
| DPaySel_ID | integer | yes | Link to DPaySel |
| BankNumber_ID | integer | no | Link to Bank Number |
| DPaySelLineParentObject_ID | integer | no | Reference ID of the caller |
| DPaySelLineObjectType | character(20) | no | Object Type |
| DPaySelPayFormatTypeCode | character(20) | no | Payment format of the payment selection |
| DPaySelLineIsRefInFile | logical | yes | Is contained in export file |
| DPaySelLineAmountTC | decimal(4) | no | TC Amount |
| DPaySelLineDiscountTC | decimal(4) | no | TC Discount |
| DPaySelLineIntAmtTC | decimal(4) | no | TC Interest Amount |
| DPaySelLineIntRate | decimal(10) | no | Interest Rate |
| DPaySelLineStatus | character(20) | no | Status |
| DPaySelLineWHTAmtLC | decimal(4) | no | BC WHT Amount |
| DPaySelLineWHTAmtTC | decimal(4) | no | TC WHT Amount |
| 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 |
| DPaySelLineWHTAmtCC | decimal(4) | no | SC WHT Amount |
| tlIsSelected | logical | no | Line is selected |
| tcDebtorCode | character(8) | no | Specifies the code that identifies the customer making a payment |
| tcBusinessRelationCode | character | no | Identifies the business relation associated with the customer |
| tcCurrencyCode | character | no | 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 |
| tcInvoiceCrDt | character | no | |
| tcPaymentCrDt | character | no | |
| tcDivisionCode | character(20) | no | Sub Account Code |
| tdDInvoiceBalance | decimal(4) | no | |
| tcDInvoiceNumber | character | no | Invoice Number. |
| tcPaymentLevelPayCode | character(20) | no | Payment Level Code. this field identifies the Payment level formats used by the payment |
| ttDueDate | date | no | |
| ttDiscountDueDate | date | no | |
| tdDiscountPercentage | decimal(4) | no | |
| ttInvoiceDate | date | no | |
| tdInvoiceRate | decimal(4) | no | |
| tdInvoiceRateScale | decimal(0) | no | |
| tcInvoiceCurrencyCode | character(8) | no | |
| tdOpenInvoiceAmountTC | decimal(4) | no | |
| tdOriginalInvoiceAmountTC | decimal(4) | no | |
| tdOriginalInvoiceAmountNetTC | decimal(4) | no | |
| CustomShort0 | character(20) | no | |
| CustomShort1 | character(20) | no | |
| CustomShort2 | character(20) | no | |
| CustomShort3 | character(20) | no | |
| CustomShort4 | character(20) | no | |
| CustomShort5 | character(20) | no | |
| CustomShort6 | character(20) | no | |
| CustomShort7 | character(20) | no | |
| CustomShort8 | character(20) | no | |
| CustomShort9 | character(20) | no | |
| CustomCombo0 | character(20) | no | |
| CustomCombo1 | character(20) | no | |
| CustomCombo2 | character(20) | no | |
| CustomCombo3 | character(20) | no | |
| CustomCombo4 | character(20) | no | |
| CustomCombo5 | character(20) | no | |
| CustomCombo6 | character(20) | no | |
| CustomCombo7 | character(20) | no | |
| CustomCombo8 | character(20) | no | |
| CustomCombo9 | character(20) | no | |
| CustomLong0 | character(255) | no | |
| CustomLong1 | character(255) | no | |
| CustomNote | character(2000) | no | |
| CustomDate0 | date | no | |
| CustomDate1 | date | no | |
| CustomDate2 | date | no | |
| CustomDate3 | date | no | |
| CustomDate4 | date | no | |
| CustomInteger0 | integer | no | |
| CustomInteger1 | integer | no | |
| CustomInteger2 | integer | no | |
| CustomInteger3 | integer | no | |
| CustomInteger4 | integer | no | |
| CustomDecimal0 | decimal(4) | no | |
| CustomDecimal1 | decimal(4) | no | |
| CustomDecimal2 | decimal(4) | no | |
| CustomDecimal3 | decimal(4) | no | |
| CustomDecimal4 | decimal(4) | no | |
| tc_Rowid | character | yes | primary index |
| tc_ParentRowid | character | yes | = tDPaySel.tc_Rowid |
| tc_Status | character | no | update status |
| field name | data type | mnd. | description |
|---|---|---|---|
| DPaySelLineStg_ID | integer | yes | Record ID |
| DPaySelLine_ID | integer | yes | Link to DPaySel |
| CInvoiceStage_ID | integer | no | Link to CInvoiceStage |
| DInvoiceStage_ID | integer | no | Link to DInvoiceStage |
| DPaySel_ID | integer | no | Link to DPaySel |
| DPaySelLineStgOrigAmtTC | decimal(4) | no | TC Orig Amount |
| DPaySelLineStgOpenAmtTC | decimal(4) | no | TC Open Amount |
| DPaySelLineStgPaymAmtTC | decimal(4) | no | TC Payment Amount |
| DPaySelLineStgDiscAmtTC | decimal(4) | no | TC Discount Amount |
| 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 |
| DPaySelLineStgIntRate | decimal(10) | no | Interest Rate |
| DPaySelLineStgStatus | character(20) | no | Status |
| ttDInvoiceStageDueDate | date | no | |
| tc_Rowid | character | yes | primary index |
| tc_ParentRowid | character | yes | = tDPaySelLine.tc_Rowid |
| tc_Status | character | no | update status |
| field name | data type | mnd. | description |
|---|---|---|---|
| DPaySelPayCode_ID | integer | yes | Record ID |
| DPaySel_ID | integer | yes | Link to DPaySel |
| PayFormatCode_ID | integer | no | Link to PayFormatCode |
| PayFormatGroup_ID | integer | yes | Link to PayFormatGroup |
| DPaySelPayCodeValue | character(40) | no | Value |
| tcPayFormatGroupCode | character(20) | no | Attribute Name |
| tlPayFormatGroupIsMandatory | logical | no | Attribute Mandatory |
| tcPayFormatCode | character(20) | no | Attribute Value |
| tcPayFormatGroupDataType | character(20) | no | Attribute Data Type |
| tcPayFormatGroupInputOption | character(20) | no | Attribute Input Option |
| tcPayFormatGroupDescription | character(20) | no | Attribute Name Description |
| tcPayFormatCodeDescription | character(20) | no | PayFormatCodeDescription |
| 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 | = tDPaySel.tc_Rowid |
| tc_Status | character | no | update status |
| field name | data type | mnd. | description |
|---|---|---|---|
| DPaySelPayRef_ID | integer | yes | Record ID |
| DPaySelLine_ID | integer | yes | Link to DPaySelLine |
| DPaySelLineStg_ID | integer | no | Link to DPaySelLineStage |
| DPaySel_ID | integer | no | Link to DPaySel |
| DPaySelPayRefCode | character(10) | yes | Payment Reference Code |
| DPaySelPayRefBankRef | character(45) | no | Bank Reference |
| 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 | = tDPaySelLine.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 |