| field name | data type | mnd. | description |
|---|
| BankNumber_ID | integer | yes | Record ID |
| BankBusinessRelation_ID | integer | no | Business Relation |
| ParentObject_ID | integer | yes | Parent Object |
| Currency_ID | integer | no | Currency Code |
| BankPayFormat_ID | integer | no | Link to BankPayFormat |
| CompanySharedSet_ID | integer | no | Link to CompanySharedSet |
| BankAccFormat_ID | integer | no | Bank Account Format |
| DDocumentStatus_ID | integer | no | Payment Status |
| BankNumberBankChargeGL_ID | integer | no | Link to GL for Bank Charges |
| BankNumber | character(40) | yes | Bank Number |
| BankNumberFormatted | character(40) | yes | Formatted Bank Account No |
| BankNumberIsActive | logical | yes | Active |
| BankNumberIsDefault | logical | yes | Default |
| BankNumberExtension | character(20) | no | Bank Extension |
| BankNumberValidation | character(20) | yes | Validation |
| BankNumberSwiftCode | character(40) | no | SWIFT Code |
| BankNumberParentType | character(20) | yes | Type |
| value list: | | {&BANKNUMBERPARENTTYPES} |
| BankNumberBranch | character(8) | no | Branch |
| BankNumberIsSBDef | logical | yes | Self-Bill Default |
| BankNumberIsBankCharge | logical | yes | Bank Charge |
| BankNumberBankAccountType | character(40) | no | Bank Account Type |
| tcParentObjectCode | character(20) | no | Parent Object Code |
| tcBankBusinessRelationCode | character(20) | no | Business Relation |
| tcCurrencyCode | character(3) | no | Currency Code |
| tcCompanyCode | character(20) | no | Entity Code |
| tcOwnBankNumber | character(40) | no | Own Bank Number |
| tcOwnGLCode | character(20) | no | Own GL Account |
| tcPayFormatTypeCode | character(20) | no | Payment Format |
| tcPayFormatTypePaymentInstrument | character(20) | no | Payment Instrument |
| tlBankNumberIsReferenced | logical | no | Referenced |
| tcBankAccFormatCode | character(20) | no | Bank Account Format |
| tcDDocumentStatusTR | character | no | |
| tlExistRecord | logical | no | For use in Excel Integration.
Enhancement ID: ER DPRD-7SFCFX |
| tcBankChargeGLCode | character(8) | 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 |
|---|
| BankNumberPayCode_ID | integer | yes | Record ID |
| BankNumber_ID | integer | yes | Link to BankNumber |
| PayFormatCode_ID | integer | no | Description |
| PayFormatGroup_ID | integer | no | Link to PayFormatGroup |
| BankNumberPayCodeSequence | integer | yes | Sequence |
| BankNumberPayCodeValue | character(40) | no | Attribute Value |
| tcPayFormatCode | character(40) | no | Bank Code |
| tcPayFormatCodeDescription | character(40) | no | Description |
| tiPayFormatGroupSequence | integer | no | PayFormatGroupSequence |
| tcPayFormatGroupDescription | character(40) | no | PayFormatGroupDescription |
| tcPayFormatGroupInputOption | character(20) | no | Attribute Input Option |
| tcPayFormatGroupCode | character(200) | no | Attribute Name |
| tcPayFormatGroupDataType | character(20) | no | Attribute Data Type |
| tlPayFormatGroupIsMandatory | logical | no | Attribute Mandatory |
| tcPayFormatCodeValue | character(40) | no | Attribute Value |
| tcPayFormatTypeCode | character(100) | no | Payment Format Type |
| 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 | = tBankNumber.tc_Rowid |
| tc_Status | character | no | update status |