| field name | data type | description |
|---|---|---|
| BankNumber_ID | integer | |
| BankBusinessRelation_ID | integer | |
| ParentObject_ID | integer | |
| Currency_ID | integer | |
| BankPayFormat_ID | integer | |
| CompanySharedSet_ID | integer | |
| BankAccFormat_ID | integer | |
| DDocumentStatus_ID | integer | |
| BankNumberBankChargeGL_ID | integer | |
| BankNumber | character | |
| BankNumberFormatted | character | |
| BankNumberIsActive | logical | |
| BankNumberIsDefault | logical | |
| BankNumberExtension | character | |
| BankNumberValidation | character | |
| BankNumberSwiftCode | character | |
| BankNumberParentType | character | |
| BankNumberBranch | character | |
| BankNumberIsSBDef | logical | |
| BankNumberIsBankCharge | logical | |
| BankNumberBankAccountType | character | |
| tcParentObjectCode | character | |
| tcBankBusinessRelationCode | character | |
| tcCurrencyCode | character | |
| tcCompanyCode | character | Entity Code |
| tcOwnBankNumber | character | |
| tcOwnGLCode | character | |
| tcPayFormatTypeCode | character | |
| tcPayFormatTypePaymentInstrument | character | |
| tlBankNumberIsReferenced | logical | |
| tcBankAccFormatCode | character | |
| tcDDocumentStatusTR | character | |
| tlExistRecord | logical | For use in Excel Integration. Enhancement ID: ER DPRD-7SFCFX |
| tcBankChargeGLCode | character | |
| CustomShort0 | character | |
| CustomShort1 | character | |
| CustomShort2 | character | |
| CustomShort3 | character | |
| CustomShort4 | character | |
| CustomShort5 | character | |
| CustomShort6 | character | |
| CustomShort7 | character | |
| CustomShort8 | character | |
| CustomShort9 | character | |
| CustomCombo0 | character | |
| CustomCombo1 | character | |
| CustomCombo2 | character | |
| CustomCombo3 | character | |
| CustomCombo4 | character | |
| CustomCombo5 | character | |
| CustomCombo6 | character | |
| CustomCombo7 | character | |
| CustomCombo8 | character | |
| CustomCombo9 | character | |
| CustomLong0 | character | |
| CustomLong1 | character | |
| CustomNote | character | |
| CustomDate0 | date | |
| CustomDate1 | date | |
| CustomDate2 | date | |
| CustomDate3 | date | |
| CustomDate4 | date | |
| CustomInteger0 | integer | |
| CustomInteger1 | integer | |
| CustomInteger2 | integer | |
| CustomInteger3 | integer | |
| CustomInteger4 | integer | |
| CustomDecimal0 | decimal(4) | |
| CustomDecimal1 | decimal(4) | |
| CustomDecimal2 | decimal(4) | |
| CustomDecimal3 | decimal(4) | |
| CustomDecimal4 | decimal(4) | |
| LastModifiedDate | date | |
| LastModifiedTime | integer | |
| LastModifiedUser | character | |
| QADC01 | character | unused QAD reserved field |
| QADC02 | character | unused QAD reserved field |
| QADT01 | date | unused QAD reserved field |
| QADD01 | decimal(10) | unused QAD reserved field |
| tc_Rowid | character | |
| tc_ParentRowid | character | |
| tc_Status | character |