About This Guide > BankImp
  
BankImp
Bank Statement Import
 
 
Field Name
Label
Col-Label
Format
Dec
 
BankImp_ID
Record ID
 
9999999999
 
 
BankImpCurrencyCode
Bank Currency Code
 
x(3)
 
 
BankImpFileName
Bank File Name
 
x(255)
 
 
BankImpFileType
File Type
 
x(20)
 
 
BankImpLinesCount
Numbers of Detail Lines
 
->,>>>,>>9
 
 
BankImpLoadedDate
Upload Date
 
99/99/9999
 
 
BankImpLoadedTime
Time Loaded
 
99999
 
 
BankImpTotalAmountInTC
Total Amount In
 
->>>,>>>,>>>,>>9.99
4
 
BankImpTotalAmountOutTC
Total Amount Out
 
->>>,>>>,>>>,>>9.99
4
 
LastModifiedDate
Last Modified Date
Mod Date
99/99/9999
 
 
LastModifiedTime
Last Modified Time
Mod Time
99999
 
 
LastModifiedUser
Last Modified User
Mod User
x(20)
 
 
QADC01
 
 
x(40)
 
 
QADC02
 
 
x(255)
 
 
QADD01
 
 
->,>>>,>>9.9999
10
 
QADT01
 
 
99/99/9999
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
FileNameIdx
no
BankImpFileName
yes
no
 ∗
Prim
yes
BankImp_ID
yes
no
 
UniqueIdx
yes
BankImpLoadedDate
yes
no
 
 
 
BankImpLoadedTime
yes
no