field name | data type | description |
BankStateLine_ID | integer | |
BankState_ID | integer | |
Period_ID | integer | |
Posting_ID | integer | |
Company_ID | integer | |
BankStateLineNumber | integer | |
BankStateLineValueDate | date | |
BankStateLinePostingDate | date | |
BankStateLineDescription | character | |
BankStateLineAmountTC | decimal(4) | |
BankStateLineInOut | character | |
BankStateLineStatus | character | |
BankStateLineBankImpRef | character | |
BankStateLineInformation | character | |
BankStateLineExtRateScale | decimal(10) | |
BankStateLineExtReference | character | |
BankStateLineExtTSM | character | |
BankStateLineExtName | character | |
BankStateLineExtSwiftCode | character | |
BankStateLineExtAddress | character | |
BankStateLineExtZip | character | |
BankStateLineExtCity | character | |
BankStateLineExtBankNumber | character | |
BankStateLineExtDebCred | character | |
BankStateLineExtOriginalTC | decimal(4) | |
BankStateLineExtCurrency | character | |
BankStateLineExtBankRate | decimal(10) | |
BankStateLineExtCountry | character | |
BankStateLineExtCostCode | character | |
tiPostingVoucher | integer | Posting Voucher |
tiPostingPeriodYear | integer | Posting Period Year |
tcPostingJournalCode | character | Posting Daybook Code |
tiPeriodYear | integer | |
tiPeriodPeriod | integer | |
tcPostingRowId | character | |
tlPrint | logical | |
tdBankStateLineAmountLC | decimal(4) | Bank state line amount lc |
tcExternalUniqueIdentifier | character | Store the external identity of class table if the component is started in batch mode. This value will be used for SetMessage method to link the tFcmessage recotd with external class table records. Now only PIBF is using this item. This field will store the BankImpLine.tc_rowid, because every bankimline record can be used to create one BankStateLine record. |
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 | |