project QadFinancials > class BBankImportLine > dataset BBankImportLine

class dataset

object identification

primary key
BankImpLine_ID
object identity
BankImpLine_ID

table tBankImpLine


field namedata typemnd.description
BankImpLine_IDintegeryesRecord ID
BankImp_IDintegeryesLink to BankImp
Debtor_IDintegernoLink to Debtor
Creditor_IDintegernoLink to Creditor
BankState_IDintegernoLink to BankState
DDocument_IDintegernoLink to DDocument
CDocument_IDintegernoLink to CDocument
PayFormatCode_IDintegernoLink to PayFormatCode
BankImpLineSeqintegeryesSequence
ProcessInCompany_IDintegeryesLink to Company
BankImpLineFileFormatCodecharacter(20)yesFormat Code
ProcessByUsr_IDintegeryesLink to Usr
BankImpLineTransTypecharacter(20)yesTransaction Type
BankImpLineActioncharacter(20)yesAction
value list:{&BANKIMPORTACTIONS}
BankImpLineBusRelTypecharacter(20)yesBusiness Relation Type
value list:{&BANKIMPBUSRELTYPES}
BankImpLineProcessedStatuscharacter(20)yesProcess Status
value list:{&BANKIMPPROCSTATUSES}
BankImpLineOwnBankNumbercharacter(40)yesAccount Number
BankImpLineValueDatedatenoValue Date
BankImpLineStatNumbercharacter(10)noStatement Number
BankImpLineDescriptioncharacter(40)noDescription
BankImpLineInOutcharacter(3)yesDirection
value list:{&TRANSDIRECTIONS}
BankImpLineAmountTCdecimal(4)noAmount TC
BankImpLineCurrencyCodecharacter(3)noCurrency
BankImpLineOrigAmountTCdecimal(4)noOriginal Amount TC
BankImpLineOrigCurrCodecharacter(3)noOriginal Currency
BankImpLineExchangeRatedecimal(10)noExchange Rate
BankImpLineRateScaledecimal(10)noExchange Scale
BankImpLineOrigTransDatedatenoOriginal Transaction Date
BankImpLineDebtorCodecharacter(20)noCustomer Code
BankImpLineCreditorCodecharacter(20)noSupplier Code
BankImpLineDebtorNamecharacter(40)noCustomer Name
BankImpLineCreditorNamecharacter(40)noSupplier Name
BankImpLineAddressLinecharacter(40)noAddress Line
BankImpLineAddressCitycharacter(20)noAddress City
BankImpLineAddressZipcharacter(10)noAddress Zip
BankImpLineAddressCountrycharacter(3)noAddress Country
BankImpLineBankNumbercharacter(40)noBank Number
BankImpLinePaymentNbrcharacter(20)noPayment Number
BankImpLinePaymentRefcharacter(40)noPayment Reference
BankImpLineInvRefListcharacter(2000)noInvoices
BankImpLineInfocharacter(2000)noInfo
BankImpLineCostcharacter(20)noCost
BankImpLineBatchNbrintegernoBatch Number
BankImpLineReferencecharacter(50)noReference
BankImpLineDiscAmtTCdecimal(4)noTC Discount Amount
BankImpLineIntAmtTCdecimal(4)noTC Interest Amount
BankImpLineResultActioncharacter(20)noResult Action
value list:{&BANKIMPORTRESULTACTIONS}
BankImpLineProcessDatedatenoProcess Date
BankImpLineIsCreateBElogicalyesCreate Banking Entry
BankImpLineIsPayDDoclogicalyesNew Payments as Paid
tiOwnBankNumber_IDintegerno
tlIsProcessedlogicalno
tlIsDifferentActionlogicalyes
LastModifiedDatedatenoLast Modified Date
LastModifiedTimeintegernoLast Modified Time
LastModifiedUsercharacter(20)noLast Modified User
QADC01character(40)nounused QAD reserved field
QADC02characternounused QAD reserved field
QADT01datenounused QAD reserved field
QADD01decimal(10)nounused QAD reserved field
tc_Rowidcharacteryesprimary index
tc_ParentRowidcharacternoempty string
tc_Statuscharacternoupdate status

table tBankImpLineLog


field namedata typemnd.description
BankImpLineLog_IDintegeryesRecord ID
BankImpLine_IDintegeryesLink to BankImpLine
BankImpLineLogRowidcharacter(20)yesRow ID
BankImpLineLogFieldNamecharacter(80)noField Name
BankImpLineLogFieldValuecharacter(2000)noField Value
BankImpLineLogLogcharacter(4000)noLog
BankImpLineLogMessagecharacter(2000)noMessage
BankImpLineLogSeverityintegernoSeverity
BankImpLineLogTypecharacter(20)noType
BankImpLineLogFieldLabelcharacter(80)noField Label
LastModifiedDatedatenoLast Modified Date
LastModifiedTimeintegernoLast Modified Time
LastModifiedUsercharacter(20)noLast Modified User
QADC01character(40)nounused QAD reserved field
QADC02characternounused QAD reserved field
QADT01datenounused QAD reserved field
QADD01decimal(10)nounused QAD reserved field
tc_Rowidcharacteryesprimary index
tc_ParentRowidcharacteryes = tBankImpLine.tc_Rowid
tc_Statuscharacternoupdate status

table tBankImpLinePrc


field namedata typemnd.description
BankImpLinePrc_IDintegeryesRecord ID
BankImpLine_IDintegeryesLink to BankImpLine
BankImp_IDintegernoLink to BankImp
ParentBankImpLinePrc_IDintegernoLink to BankImpLinePrc - Parent
BankImpLinePrcCodecharacter(40)yesProcess Name
BankImpLinePrcDesccharacter(255)noDescription
BankImpLinePrcResultcharacter(2000)noProcess Result
BankImpLinePrcParamcharacter(2000)noProcess Parameters
BankImpLinePrcStatuscharacter(20)noProcess Status
BankImpLinePrcLevelintegernoProcess Level
CustomShort0character(20)noCustom Short Field
CustomShort1character(20)noCustom Short Field
CustomShort2character(20)noCustom Short Field
CustomShort3character(20)noCustom Short Field
CustomShort4character(20)noCustom Short Field
CustomShort5character(20)noCustom Short Field
CustomShort6character(20)noCustom Short Field
CustomShort7character(20)noCustom Short Field
CustomShort8character(20)noCustom Short Field
CustomShort9character(20)noCustom Short Field
CustomCombo0character(20)noCustom Combo Field
CustomCombo1character(20)noCustom Combo Field
CustomCombo2character(20)noCustom Combo Field
CustomCombo3character(20)noCustom Combo Field
CustomCombo4character(20)noCustom Combo Field
CustomCombo5character(20)noCustom Combo Field
CustomCombo6character(20)noCustom Combo Field
CustomCombo7character(20)noCustom Combo Field
CustomCombo8character(20)noCustom Combo Field
CustomCombo9character(20)noCustom Combo Field
CustomLong0character(255)noCustom Long Field
CustomLong1character(255)noCustom Long Field
CustomNotecharacter(2000)noCustom Note Field
CustomDate0datenoCustom Date Field
CustomDate1datenoCustom Date Field
CustomDate2datenoCustom Date Field
CustomDate3datenoCustom Date Field
CustomDate4datenoCustom Date Field
CustomInteger0integernoCustom Integer Field
CustomInteger1integernoCustom Integer Field
CustomInteger2integernoCustom Integer Field
CustomInteger3integernoCustom Integer Field
CustomInteger4integernoCustom Integer Field
CustomDecimal0decimal(4)noCustom Decimal Field
CustomDecimal1decimal(4)noCustom Decimal Field
CustomDecimal2decimal(4)noCustom Decimal Field
CustomDecimal3decimal(4)noCustom Decimal Field
CustomDecimal4decimal(4)noCustom Decimal Field
CustomShort10character(20)noCustom Short Field
CustomShort11character(20)noCustom Short Field
CustomShort12character(20)noCustom Short Field
CustomShort13character(20)noCustom Short Field
CustomShort14character(20)noCustom Short Field
CustomCombo10character(20)noCustom Combo Field
CustomCombo11character(20)noCustom Combo Field
CustomCombo12character(20)noCustom Combo Field
CustomCombo13character(20)noCustom Combo Field
CustomCombo14character(20)noCustom Combo Field
LastModifiedDatedatenoLast Modified Date
LastModifiedTimeintegernoLast Modified Time
LastModifiedUsercharacter(20)noLast Modified User
QADC01character(40)nounused QAD reserved field
QADC02characternounused QAD reserved field
QADT01datenounused QAD reserved field
QADD01decimal(10)nounused QAD reserved field
tc_Rowidcharacteryesprimary index
tc_ParentRowidcharacteryes = tBankImpLine.tc_Rowid
tc_Statuscharacternoupdate status

table tCustomTable0

Description

Empty table intended for non-intrusive customization only

field namedata typedescription
tcCustomShort0character
tcCustomShort1character
tcCustomShort2character
tcCustomShort3character
tcCustomShort4character
tcCustomShort5character
tcCustomShort6character
tcCustomShort7character
tcCustomShort8character
tcCustomShort9character
tcCustomCombo0character
tcCustomCombo1character
tcCustomCombo2character
tcCustomCombo3character
tcCustomCombo4character
tcCustomCombo5character
tcCustomCombo6character
tcCustomCombo7character
tcCustomCombo8character
tcCustomCombo9character
tcCustomLong0character
tcCustomLong1character
tcCustomNotecharacter
ttCustomDate0date
ttCustomDate1date
ttCustomDate2date
ttCustomDate3date
ttCustomDate4date
tiCustomInteger0integer
tiCustomInteger1integer
tiCustomInteger2integer
tiCustomInteger3integer
tiCustomInteger4integer
tdCustomDecimal0decimal(4)
tdCustomDecimal1decimal(4)
tdCustomDecimal2decimal(4)
tdCustomDecimal3decimal(4)
tdCustomDecimal4decimal(4)
tc_RowidcharacterUse this data item to add as a field in public temp-tables (with index).
tc_ParentRowidcharacter
tc_Statuscharacter

table tCustomTable1

Description

Empty table intended for non-intrusive customization only

field namedata typedescription
tcCustomShort0character
tcCustomShort1character
tcCustomShort2character
tcCustomShort3character
tcCustomShort4character
tcCustomShort5character
tcCustomShort6character
tcCustomShort7character
tcCustomShort8character
tcCustomShort9character
tcCustomCombo0character
tcCustomCombo1character
tcCustomCombo2character
tcCustomCombo3character
tcCustomCombo4character
tcCustomCombo5character
tcCustomCombo6character
tcCustomCombo7character
tcCustomCombo8character
tcCustomCombo9character
tcCustomLong0character
tcCustomLong1character
tcCustomNotecharacter
ttCustomDate0date
ttCustomDate1date
ttCustomDate2date
ttCustomDate3date
ttCustomDate4date
tiCustomInteger0integer
tiCustomInteger1integer
tiCustomInteger2integer
tiCustomInteger3integer
tiCustomInteger4integer
tdCustomDecimal0decimal(4)
tdCustomDecimal1decimal(4)
tdCustomDecimal2decimal(4)
tdCustomDecimal3decimal(4)
tdCustomDecimal4decimal(4)
tc_RowidcharacterUse this data item to add as a field in public temp-tables (with index).
tc_ParentRowidcharacter
tc_Statuscharacter

table tCustomTable2

Description

Empty table intended for non-intrusive customization only

field namedata typedescription
tcCustomShort0character
tcCustomShort1character
tcCustomShort2character
tcCustomShort3character
tcCustomShort4character
tcCustomShort5character
tcCustomShort6character
tcCustomShort7character
tcCustomShort8character
tcCustomShort9character
tcCustomCombo0character
tcCustomCombo1character
tcCustomCombo2character
tcCustomCombo3character
tcCustomCombo4character
tcCustomCombo5character
tcCustomCombo6character
tcCustomCombo7character
tcCustomCombo8character
tcCustomCombo9character
tcCustomLong0character
tcCustomLong1character
tcCustomNotecharacter
ttCustomDate0date
ttCustomDate1date
ttCustomDate2date
ttCustomDate3date
ttCustomDate4date
tiCustomInteger0integer
tiCustomInteger1integer
tiCustomInteger2integer
tiCustomInteger3integer
tiCustomInteger4integer
tdCustomDecimal0decimal(4)
tdCustomDecimal1decimal(4)
tdCustomDecimal2decimal(4)
tdCustomDecimal3decimal(4)
tdCustomDecimal4decimal(4)
tc_RowidcharacterUse this data item to add as a field in public temp-tables (with index).
tc_ParentRowidcharacter
tc_Statuscharacter