About This Guide > BankImpLine
  
BankImpLine
Bank Statement Import Line
 
 
Field Name
Label
Col-Label
Format
Dec
 
BankImp_ID
Link to BankImp
 
9999999999
 
 
BankImpLine_ID
Record ID
 
9999999999
 
 
BankImpLineAction
Action
 
x(20)
 
 
BankImpLineAddressCity
Address City
 
x(20)
 
 
BankImpLineAddressCountry
Address Country
 
x(3)
 
 
BankImpLineAddressLine
Address Line
 
x(40)
 
 
BankImpLineAddressZip
Address Zip
 
x(10)
 
 
BankImpLineAmountTC
Amount TC
 
->>>,>>>,>>>,>>9.99
4
 
BankImpLineBankNumber
Bank Number
 
x(40)
 
 
BankImpLineBatchNbr
Batch Number
 
->,>>>,>>9
 
 
BankImpLineBusRelType
Business Relation Type
 
x(20)
 
 
BankImpLineCost
Cost
 
x(20)
 
 
BankImpLineCreditorCode
Supplier Code
 
x(20)
 
 
BankImpLineCreditorName
Supplier Name
 
x(40)
 
 
BankImpLineCurrencyCode
Currency
 
x(3)
 
 
BankImpLineDebtorCode
Customer Code
 
x(20)
 
 
BankImpLineDebtorName
Customer Name
 
x(40)
 
 
BankImpLineDescription
Description
 
x(40)
 
 
BankImpLineDiscAmtTC
TC Discount Amount
 
->>>,>>>,>>>,>>9.99
4
 
BankImpLineExchangeRate
Exchange Rate
 
->,>>>,>>9.9999999999
10
 
BankImpLineFileFormatCode
Format Code
 
x(20)
 
 
BankImpLineInfo
Info
 
x(2000)
 
 
BankImpLineInOut
Direction
 
x(3)
 
 
BankImpLineIntAmtTC
TC Interest Amount
 
->>>,>>>,>>>,>>9.99
4
 
BankImpLineInvRefList
Invoices
 
x(2000)
 
 
BankImpLineIsCreateBE
Create Banking Entry
 
yes/no
 
 
BankImpLineIsPayDDoc
New Payments as Paid
 
yes/no
 
 
BankImpLineOrigAmountTC
Original Amount TC
 
->>>,>>>,>>>,>>9.99
4
 
BankImpLineOrigCurrCode
Original Currency
 
x(3)
 
 
BankImpLineOrigTransDate
Original Transaction Date
 
99/99/9999
 
 
BankImpLineOwnBankNumber
Account Number
 
x(40)
 
 
BankImpLinePaymentNbr
Payment Number
 
x(20)
 
 
BankImpLinePaymentRef
Payment Reference
 
x(40)
 
 
BankImpLineProcessDate
Process Date
 
99/99/9999
 
 
BankImpLineProcessedStatus
Process Status
 
x(20)
 
 
BankImpLineRateScale
Exchange Scale
 
->,>>>,>>9.9999999999
10
 
BankImpLineReference
Reference
 
x(50)
 
 
BankImpLineResultAction
Result Action
 
x(20)
 
 
BankImpLineSeq
Sequence
Seq
->,>>>,>>9
 
 
BankImpLineStatNumber
Statement Number
 
x(10)
 
 
BankImpLineTransType
Transaction Type
 
x(20)
 
 
BankImpLineValueDate
Value Date
 
99/99/9999
 
 
BankState_ID
Link to BankState
 
9999999999
 
 
CDocument_ID
Link to CDocument
 
9999999999
 
 
Creditor_ID
Link to Creditor
 
9999999999
 
 
DDocument_ID
Link to DDocument
 
9999999999
 
 
Debtor_ID
Link to Debtor
 
9999999999
 
 
LastModifiedDate
Last Modified Date
Mod Date
99/99/9999
 
 
LastModifiedTime
Last Modified Time
Mod Time
99999
 
 
LastModifiedUser
Last Modified User
Mod User
x(20)
 
 
PayFormatCode_ID
Link to PayFormatCode
 
9999999999
 
 
ProcessByUsr_ID
Link to Usr
 
9999999999
 
 
ProcessInCompany_ID
Link to Company
 
9999999999
 
 
QADC01
 
 
x(40)
 
 
QADC02
 
 
x(255)
 
 
QADD01
 
 
->,>>>,>>9.9999
10
 
QADT01
 
 
99/99/9999
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
BankImp
no
BankImp_ID
yes
no
 
BankState
no
BankState_ID
yes
no
 
BatchNbr
no
BankImpLineBatchNbr
yes
no
 
CDoc
no
CDocument_ID
yes
no
 
Creditor
no
Creditor_ID
yes
no
 
DDoc
no
DDocument_ID
yes
no
 
Debtor
no
Debtor_ID
yes
no
 
PayFormat
no
PayFormatCode_ID
yes
no
 
PrcCyIdx
no
ProcessInCompany_ID
yes
no
 
PrcUsrIdx
no
ProcessByUsr_ID
yes
no
 ∗
Prim
yes
BankImpLine_ID
yes
no
 
ProcessedStatIdx
no
BankImpLineProcessedStatus
yes
no
 
UniqueIdx
yes
BankImpLineSeq
yes
no
 
 
 
BankImp_ID
yes
no