field name | data type | db field | description |
tiBankAccFormat_ID | integer | BankNumber.BankAccFormat_ID | Bank Account Format |
tcBankAccFormatCode | character | BankAccFormat.BankAccFormatCode | Bank Account Format |
tcBankNumberBankAccountType | character | BankNumber.BankNumberBankAccountType | Bank Account Type |
tiBankNumberBankChargeGL_ID | integer | BankNumber.BankNumberBankChargeGL_ID | Link to GL for Bank Charges |
tcBankNumberBranch | character | BankNumber.BankNumberBranch | Branch |
tlBankNumberIsBankCharge | logical | BankNumber.BankNumberIsBankCharge | Bank Charge |
tlBankNumberIsSBDef | logical | BankNumber.BankNumberIsSBDef | Self-Bill Default |
tcBankNumberValidation | character | BankNumber.BankNumberValidation | Validation |
tiBankPayFormat_ID | integer | BankNumber.BankPayFormat_ID | Link to BankPayFormat |
tiBankPayFormat_ID1 | integer | BankPayFormat.BankPayFormat_ID | Record ID |
tiCompany_ID | integer | Company.Company_ID | Record ID |
tiCompany_ID1 | integer | CompanySharedSet.Company_ID | Entity |
tcCompanyCode | character | Company.CompanyCode | Entity Code |
tiCompanySharedSet_ID1 | integer | CompanySharedSet.CompanySharedSet_ID | Record ID |
tcCustomCombo0 | character | BankNumber.CustomCombo0 | Custom Combo Field |
tcCustomCombo1 | character | BankNumber.CustomCombo1 | Custom Combo Field |
tcCustomCombo2 | character | BankNumber.CustomCombo2 | Custom Combo Field |
tcCustomCombo3 | character | BankNumber.CustomCombo3 | Custom Combo Field |
tcCustomCombo4 | character | BankNumber.CustomCombo4 | Custom Combo Field |
tcCustomCombo5 | character | BankNumber.CustomCombo5 | Custom Combo Field |
tcCustomCombo6 | character | BankNumber.CustomCombo6 | Custom Combo Field |
tcCustomCombo7 | character | BankNumber.CustomCombo7 | Custom Combo Field |
tcCustomCombo8 | character | BankNumber.CustomCombo8 | Custom Combo Field |
tcCustomCombo9 | character | BankNumber.CustomCombo9 | Custom Combo Field |
ttCustomDate0 | date | BankNumber.CustomDate0 | Custom Date Field |
ttCustomDate1 | date | BankNumber.CustomDate1 | Custom Date Field |
ttCustomDate2 | date | BankNumber.CustomDate2 | Custom Date Field |
ttCustomDate3 | date | BankNumber.CustomDate3 | Custom Date Field |
ttCustomDate4 | date | BankNumber.CustomDate4 | Custom Date Field |
tdCustomDecimal0 | decimal | BankNumber.CustomDecimal0 | Custom Decimal Field |
tdCustomDecimal1 | decimal | BankNumber.CustomDecimal1 | Custom Decimal Field |
tdCustomDecimal2 | decimal | BankNumber.CustomDecimal2 | Custom Decimal Field |
tdCustomDecimal3 | decimal | BankNumber.CustomDecimal3 | Custom Decimal Field |
tdCustomDecimal4 | decimal | BankNumber.CustomDecimal4 | Custom Decimal Field |
tiCustomInteger0 | integer | BankNumber.CustomInteger0 | Custom Integer Field |
tiCustomInteger1 | integer | BankNumber.CustomInteger1 | Custom Integer Field |
tiCustomInteger2 | integer | BankNumber.CustomInteger2 | Custom Integer Field |
tiCustomInteger3 | integer | BankNumber.CustomInteger3 | Custom Integer Field |
tiCustomInteger4 | integer | BankNumber.CustomInteger4 | Custom Integer Field |
tcCustomLong0 | character | BankNumber.CustomLong0 | Custom Long Field |
tcCustomLong1 | character | BankNumber.CustomLong1 | Custom Long Field |
tcCustomNote | character | BankNumber.CustomNote | Custom Note Field |
tcCustomShort0 | character | BankNumber.CustomShort0 | Custom Short Field |
tcCustomShort1 | character | BankNumber.CustomShort1 | Custom Short Field |
tcCustomShort2 | character | BankNumber.CustomShort2 | Custom Short Field |
tcCustomShort3 | character | BankNumber.CustomShort3 | Custom Short Field |
tcCustomShort4 | character | BankNumber.CustomShort4 | Custom Short Field |
tcCustomShort5 | character | BankNumber.CustomShort5 | Custom Short Field |
tcCustomShort6 | character | BankNumber.CustomShort6 | Custom Short Field |
tcCustomShort7 | character | BankNumber.CustomShort7 | Custom Short Field |
tcCustomShort8 | character | BankNumber.CustomShort8 | Custom Short Field |
tcCustomShort9 | character | BankNumber.CustomShort9 | Custom Short Field |
tiDDocumentStatus_ID | integer | BankNumber.DDocumentStatus_ID | Payment Status |
tiGL_ID | integer | GL.GL_ID | Record ID |
tcGLCode | character | GL.GLCode | A code identifying the GL account. |
tcOwnBankNumber | character | BankNumber2.BankNumber | Bank Number |
tiOwnBankNumber_ID | integer | BankNumber2.BankNumber_ID | Record ID |
tcPayFormatTypeCode | character | BankPayFormat.PayFormatTypeCode | Payment Format |
tcPayFormatTypePayInstrument | character | PayFormatType.PayFormatTypePayInstrument | Payment Instrument |
tiBankBusinessRelation_ID | integer | BankNumber.BankBusinessRelation_ID | Business Relation |
tcBankNumber | character | BankNumber.BankNumber | Bank Number |
tcBankNumberFormatted | character | BankNumber.BankNumberFormatted | Formatted Bank Account No |
tcBankNumberExtension | character | BankNumber.BankNumberExtension | Bank Extension |
tlBankNumberIsActive | logical | BankNumber.BankNumberIsActive | Active |
tlBankNumberIsDefault | logical | BankNumber.BankNumberIsDefault | Default |
tcBankNumberParentType | character | BankNumber.BankNumberParentType | Type |
tcBankNumberSwiftCode | character | BankNumber.BankNumberSwiftCode | SWIFT Code |
tiBankNumber_ID | integer | BankNumber.BankNumber_ID | Record ID |
tiParentObject_ID | integer | BankNumber.ParentObject_ID | Parent Object |
tiCurrency_ID | integer | BankNumber.Currency_ID | Currency Code |
tiCompanySharedSet_ID | integer | BankNumber.CompanySharedSet_ID | Link to CompanySharedSet |
tcBankBusinessRelationCode | character | BusinessRelation.BusinessRelationCode | Business Relation. A code to identify the business relation. If this field does not have a input from the user, the system automatically generates a number for the record based on the sequence defined in Business Relation Autonumber Create. |
tcCurrencyCode | character | Currency.CurrencyCode | Currency Code |
ti_sequence | integer | calculated | primary index |
tc_rowid | character | calculated | = rowid(BankNumber),rowid(BankAccFormat),rowid(BankPayFormat),rowid(BankNumber2),rowid(CompanySharedSet),rowid(Company),rowid(GL),rowid(PayFormatType),rowid(BusinessRelation),rowid(Currency) |