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 |