| field name | data type | mnd. | description |
|---|---|---|---|
| BankImpLine_ID | integer | yes | Record ID |
| BankImp_ID | integer | yes | Link to BankImp |
| Debtor_ID | integer | no | Link to Debtor |
| Creditor_ID | integer | no | Link to Creditor |
| BankState_ID | integer | no | Link to BankState |
| DDocument_ID | integer | no | Link to DDocument |
| CDocument_ID | integer | no | Link to CDocument |
| PayFormatCode_ID | integer | no | Link to PayFormatCode |
| BankImpLineSeq | integer | yes | Sequence |
| ProcessInCompany_ID | integer | yes | Link to Company |
| BankImpLineFileFormatCode | character(20) | yes | Format Code |
| ProcessByUsr_ID | integer | yes | Link to Usr |
| BankImpLineTransType | character(20) | yes | Transaction Type |
| BankImpLineAction | character(20) | yes | Action |
| value list: | {&BANKIMPORTACTIONS} | ||
| BankImpLineBusRelType | character(20) | yes | Business Relation Type |
| value list: | {&BANKIMPBUSRELTYPES} | ||
| BankImpLineProcessedStatus | character(20) | yes | Process Status |
| value list: | {&BANKIMPPROCSTATUSES} | ||
| BankImpLineOwnBankNumber | character(40) | yes | Account Number |
| BankImpLineValueDate | date | no | Value Date |
| BankImpLineStatNumber | character(10) | no | Statement Number |
| BankImpLineDescription | character(40) | no | Description |
| BankImpLineInOut | character(3) | yes | Direction |
| value list: | {&TRANSDIRECTIONS} | ||
| BankImpLineAmountTC | decimal(4) | no | Amount TC |
| BankImpLineCurrencyCode | character(3) | no | Currency |
| BankImpLineOrigAmountTC | decimal(4) | no | Original Amount TC |
| BankImpLineOrigCurrCode | character(3) | no | Original Currency |
| BankImpLineExchangeRate | decimal(10) | no | Exchange Rate |
| BankImpLineRateScale | decimal(10) | no | Exchange Scale |
| BankImpLineOrigTransDate | date | no | Original Transaction Date |
| BankImpLineDebtorCode | character(20) | no | Customer Code |
| BankImpLineCreditorCode | character(20) | no | Supplier Code |
| BankImpLineDebtorName | character(40) | no | Customer Name |
| BankImpLineCreditorName | character(40) | no | Supplier Name |
| BankImpLineAddressLine | character(40) | no | Address Line |
| BankImpLineAddressCity | character(20) | no | Address City |
| BankImpLineAddressZip | character(10) | no | Address Zip |
| BankImpLineAddressCountry | character(3) | no | Address Country |
| BankImpLineBankNumber | character(40) | no | Bank Number |
| BankImpLinePaymentNbr | character(20) | no | Payment Number |
| BankImpLinePaymentRef | character(40) | no | Payment Reference |
| BankImpLineInvRefList | character(2000) | no | Invoices |
| BankImpLineInfo | character(2000) | no | Info |
| BankImpLineCost | character(20) | no | Cost |
| BankImpLineBatchNbr | integer | no | Batch Number |
| BankImpLineReference | character(50) | no | Reference |
| BankImpLineDiscAmtTC | decimal(4) | no | TC Discount Amount |
| BankImpLineIntAmtTC | decimal(4) | no | TC Interest Amount |
| BankImpLineResultAction | character(20) | no | Result Action |
| value list: | {&BANKIMPORTRESULTACTIONS} | ||
| BankImpLineProcessDate | date | no | Process Date |
| BankImpLineIsCreateBE | logical | yes | Create Banking Entry |
| BankImpLineIsPayDDoc | logical | yes | New Payments as Paid |
| tiOwnBankNumber_ID | integer | no | |
| tlIsProcessed | logical | no | |
| tlIsDifferentAction | logical | 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 |
|---|---|---|---|
| BankImpLineLog_ID | integer | yes | Record ID |
| BankImpLine_ID | integer | yes | Link to BankImpLine |
| BankImpLineLogRowid | character(20) | yes | Row ID |
| BankImpLineLogFieldName | character(80) | no | Field Name |
| BankImpLineLogFieldValue | character(2000) | no | Field Value |
| BankImpLineLogLog | character(4000) | no | Log |
| BankImpLineLogMessage | character(2000) | no | Message |
| BankImpLineLogSeverity | integer | no | Severity |
| BankImpLineLogType | character(20) | no | Type |
| BankImpLineLogFieldLabel | character(80) | no | Field Label |
| 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 | = tBankImpLine.tc_Rowid |
| tc_Status | character | no | update status |
| field name | data type | mnd. | description |
|---|---|---|---|
| BankImpLinePrc_ID | integer | yes | Record ID |
| BankImpLine_ID | integer | yes | Link to BankImpLine |
| BankImp_ID | integer | no | Link to BankImp |
| ParentBankImpLinePrc_ID | integer | no | Link to BankImpLinePrc - Parent |
| BankImpLinePrcCode | character(40) | yes | Process Name |
| BankImpLinePrcDesc | character(255) | no | Description |
| BankImpLinePrcResult | character(2000) | no | Process Result |
| BankImpLinePrcParam | character(2000) | no | Process Parameters |
| BankImpLinePrcStatus | character(20) | no | Process Status |
| BankImpLinePrcLevel | integer | no | Process Level |
| 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 |
| CustomShort10 | character(20) | no | Custom Short Field |
| CustomShort11 | character(20) | no | Custom Short Field |
| CustomShort12 | character(20) | no | Custom Short Field |
| CustomShort13 | character(20) | no | Custom Short Field |
| CustomShort14 | character(20) | no | Custom Short Field |
| CustomCombo10 | character(20) | no | Custom Combo Field |
| CustomCombo11 | character(20) | no | Custom Combo Field |
| CustomCombo12 | character(20) | no | Custom Combo Field |
| CustomCombo13 | character(20) | no | Custom Combo Field |
| CustomCombo14 | character(20) | no | Custom Combo 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 | yes | = tBankImpLine.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 |