About This Guide > BankStateLine
  
BankStateLine
Bank Statement Line
 
 
Field Name
Label
Col-Label
Format
Dec
 
BankState_ID
Link to BankState
 
9999999999
 
 
BankStateLine_ID
Record ID
 
9999999999
 
 
BankStateLineAmountTC
TC Amount
 
->>>,>>>,>>>,>>9.99
4
 
BankStateLineBankImpRef
Bank Importing Reference
 
x(255)
 
 
BankStateLineDescription
Description
 
x(40)
 
 
BankStateLineExtAddress
Address (Ext)
 
x(40)
 
 
BankStateLineExtBankNumber
Bank Number (Ext)
 
x(40)
 
 
BankStateLineExtBankRate
Bank Rate (Ext)
 
->,>>>,>>9.9999999999
10
 
BankStateLineExtCity
City (Ext)
 
x(40)
 
 
BankStateLineExtCostCode
Cost Code (Ext)
 
x(20)
 
 
BankStateLineExtCountry
Country (Ext)
 
x(20)
 
 
BankStateLineExtCurrency
Currency (Ext)
 
x(20)
 
 
BankStateLineExtDebCred
Customer/Supplier (Ext)
 
x(20)
 
 
BankStateLineExtName
Name (Ext)
 
x(40)
 
 
BankStateLineExtOriginalTC
TC Original (Ext)
 
->>>,>>>,>>>,>>9.99
4
 
BankStateLineExtRateScale
Scale Factor
 
->,>>>,>>9.9999999999
10
 
BankStateLineExtReference
Reference (Ext)
 
x(40)
 
 
BankStateLineExtSwiftCode
SWIFT Code (Ext)
 
x(40)
 
 
BankStateLineExtTSM
TSM (Ext)
 
x(40)
 
 
BankStateLineExtZip
Zip Code (Ext)
 
x(20)
 
 
BankStateLineInformation
Information
 
x(2000)
 
 
BankStateLineInOut
In/Out
 
x(20)
 
 
BankStateLineNumber
Number
 
->,>>>,>>9
 
 
BankStateLinePostingDate
Posting Date
 
99/99/9999
 
 
BankStateLineStatus
Status
 
x(20)
 
 
BankStateLineValueDate
Value Date
 
99/99/9999
 
 
Company_ID
Link to Company
 
9999999999
 
 
CustomCombo0
Custom Combo Field
 
x(20)
 
 
CustomCombo1
Custom Combo Field
 
x(20)
 
 
CustomCombo2
Custom Combo Field
 
x(20)
 
 
CustomCombo3
Custom Combo Field
 
x(20)
 
 
CustomCombo4
Custom Combo Field
 
x(20)
 
 
CustomCombo5
Custom Combo Field
 
x(20)
 
 
CustomCombo6
Custom Combo Field
 
x(20)
 
 
CustomCombo7
Custom Combo Field
 
x(20)
 
 
CustomCombo8
Custom Combo Field
 
x(20)
 
 
CustomCombo9
Custom Combo Field
 
x(20)
 
 
CustomDate0
Custom Date Field
 
99/99/9999
 
 
CustomDate1
Custom Date Field
 
99/99/9999
 
 
CustomDate2
Custom Date Field
 
99/99/9999
 
 
CustomDate3
Custom Date Field
 
99/99/9999
 
 
CustomDate4
Custom Date Field
 
99/99/9999
 
 
CustomDecimal0
Custom Decimal Field
 
->,>>>,>>9.99
4
 
CustomDecimal1
Custom Decimal Field
 
->,>>>,>>9.99
4
 
CustomDecimal2
Custom Decimal Field
 
->,>>>,>>9.99
4
 
CustomDecimal3
Custom Decimal Field
 
->,>>>,>>9.99
4
 
CustomDecimal4
Custom Decimal Field
 
->,>>>,>>9.99
4
 
CustomInteger0
Custom Integer Field
 
->,>>>,>>9
 
 
CustomInteger1
Custom Integer Field
 
->,>>>,>>9
 
 
CustomInteger2
Custom Integer Field
 
->,>>>,>>9
 
 
CustomInteger3
Custom Integer Field
 
->,>>>,>>9
 
 
CustomInteger4
Custom Integer Field
 
->,>>>,>>9
 
 
CustomLong0
Custom Long Field
 
x(255)
 
 
CustomLong1
Custom Long Field
 
x(255)
 
 
CustomNote
Custom Note Field
 
x(2000)
 
 
CustomShort0
Custom Short Field
 
x(20)
 
 
CustomShort1
Custom Short Field
 
x(20)
 
 
CustomShort2
Custom Short Field
 
x(20)
 
 
CustomShort3
Custom Short Field
 
x(20)
 
 
CustomShort4
Custom Short Field
 
x(20)
 
 
CustomShort5
Custom Short Field
 
x(20)
 
 
CustomShort6
Custom Short Field
 
x(20)
 
 
CustomShort7
Custom Short Field
 
x(20)
 
 
CustomShort8
Custom Short Field
 
x(20)
 
 
CustomShort9
Custom Short Field
 
x(20)
 
 
LastModifiedDate
Last Modified Date
Mod Date
99/99/9999
 
 
LastModifiedTime
Last Modified Time
Mod Time
99999
 
 
LastModifiedUser
Last Modified User
Mod User
x(20)
 
 
Period_ID
GL Calendar Year
GL Cal Year
9999999999
 
 
Posting_ID
Voucher
 
9999999999
 
 
QADC01
 
 
x(40)
 
 
QADC02
 
 
x(255)
 
 
QADD01
 
 
->,>>>,>>9.9999
10
 
QADT01
 
 
99/99/9999
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
BankState
no
BankState_ID
yes
no
 
CompanyIdx
no
Company_ID
yes
no
 
Period
no
Period_ID
yes
no
 
Posting
no
Posting_ID
yes
no
 ∗
Prim
yes
BankStateLine_ID
yes
no
 
Stattus
no
BankStateLineStatus
yes
no
 
UniqueIdx
yes
BankState_ID
yes
no
 
 
 
BankStateLineNumber
yes
no