|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
BankState_ID
|
Link to BankState
|
|
9999999999
|
|
|
|
BankStateAlloc_ID
|
Record ID
|
|
9999999999
|
|
|
|
BankStateAllocAmountLC
|
BC Amount
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
BankStateAllocAmountTC
|
TC Allocated
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
BankStateAllocBankAmountLC
|
BC Bank Amount
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
BankStateAllocBankAmountTC
|
TC Bank Amt
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
BankStateAllocBankDiscLC
|
BC Bank Discount
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
BankStateAllocBankDiscTC
|
TC Bank Discount
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
BankStateAllocBankImpRef
|
Bank Importing Reference
|
|
x(255)
|
|
|
|
BankStateAllocBankRate
|
Accounting Rate
|
|
->,>>>,>>9.9999999999
|
10
|
|
|
BankStateAllocBankRteScale
|
Scale Factor
|
|
->,>>>,>>9.9999999999
|
10
|
|
|
BankStateAllocBankValDate
|
Rate Date
|
|
99/99/9999
|
|
|
|
BankStateAllocCCRate
|
SC Rate
|
|
->,>>>,>>9.9999999999
|
10
|
|
|
BankStateAllocCCScale
|
SC Rate Scale
|
|
->,>>>,>>9.9999999999
|
10
|
|
|
BankStateAllocDifferenceCC
|
SC Exch Rate Variance
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
BankStateAllocDifferenceLC
|
BC Difference
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
BankStateAllocDifferenceTC
|
TC Difference
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
BankStateAllocDiscountTC
|
TC Discount
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
BankStateAllocOpenBalTC
|
Open Balance TC
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
BankStateAllocPaidAmtTC
|
TC Paid Amount
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
BankStateAllocType
|
Allocation Type
|
|
x(20)
|
|
|
|
BankStateAllocWHTAmtCC
|
SC WHT Amount
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
BankStateAllocWHTAmtLC
|
BC WHT Amount
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
BankStateAllocWHTAmtTC
|
TC WHT Amount
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
BankStateAllocWHTCCRate
|
WHT SC Rate
|
|
->,>>>,>>9.9999999999
|
10
|
|
|
BankStateAllocWHTCCScale
|
WHT SC Scale
|
|
->,>>>,>>9.9999999999
|
10
|
|
|
BankStateAllocWHTLCRate
|
WHT BC Rate
|
|
->,>>>,>>9.9999999999
|
10
|
|
|
BankStateAllocWHTLCScale
|
WHT BC Scale
|
|
->,>>>,>>9.9999999999
|
10
|
|
|
BankStateAllocWHTPerc
|
WHT Percentage
|
|
->>9.99
|
2
|
|
|
BankStateAllocWHTTxFeeTC
|
TC WHT Taxable Fee
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
BankStateLine_ID
|
Link to BankStateLine
|
|
9999999999
|
|
|
|
CCollection_ID
|
Link to CCollection
|
|
9999999999
|
|
|
|
CInvoice_ID
|
Link to CInvoice
|
|
9999999999
|
|
|
|
Company_ID
|
Link to Company
|
|
9999999999
|
|
|
|
Currency_ID
|
Currency Code
|
Curr
|
9999999999
|
|
|
|
DCollection_ID
|
Link to DCollection
|
|
9999999999
|
|
|
|
DInvoice_ID
|
Link to DInvoice
|
|
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)
|
|
|
|
Posting_ID
|
Link to Posting
|
|
9999999999
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
AllocType
|
no
|
BankStateAllocType
|
yes
|
no
|
|
|
BankStateLine
|
no
|
BankStateLine_ID
|
yes
|
no
|
|
|
BankStIdx
|
no
|
BankState_ID
|
yes
|
no
|
|
|
CCollection
|
no
|
CCollection_ID
|
yes
|
no
|
|
|
CInvoice
|
no
|
CInvoice_ID
|
yes
|
no
|
|
|
CompanyIdx
|
no
|
Company_ID
|
yes
|
no
|
|
|
Currency
|
no
|
Currency_ID
|
yes
|
no
|
|
|
DCollection
|
no
|
DCollection_ID
|
yes
|
no
|
|
|
DInvoice
|
no
|
DInvoice_ID
|
yes
|
no
|
|
|
Posting
|
no
|
Posting_ID
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
BankStateAlloc_ID
|
yes
|
no
|