|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
Company_ID
|
Link to Company
|
|
9999999999
|
|
|
|
Currency_ID
|
Link To Currency
|
|
9999999999
|
|
|
|
GL_ID
|
Link to GL
|
|
9999999999
|
|
|
|
GLOpenItem_ID
|
Record ID
|
|
9999999999
|
|
|
|
GLOpenItemBalanceCC
|
SC Balance
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
GLOpenItemBalanceCreditCC
|
SC Credit Balance
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
GLOpenItemBalanceCreditLC
|
BC Balance Credit
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
GLOpenItemBalanceCreditTC
|
TC Credit Balance
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
GLOpenItemBalanceDebitCC
|
SC Debit Balance
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
GLOpenItemBalanceDebitLC
|
BC Balance Debit
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
GLOpenItemBalanceDebitTC
|
TC Debit Balance
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
GLOpenItemBalanceLC
|
BC Balance
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
GLOpenItemBalanceTC
|
TC Balance
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
GLOpenItemClosingDate
|
Closing Date
|
|
99/99/9999
|
|
|
|
GLOpenItemIsOpen
|
Open
|
|
yes/no
|
|
|
|
GLOpenItemKey
|
Allocation Key
|
|
x(40)
|
|
|
|
GLOpenItemOriginalCreditCC
|
SC Original Credit
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
GLOpenItemOriginalCreditLC
|
BC Original Credit
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
GLOpenItemOriginalCreditTC
|
TC Original Credit
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
GLOpenItemOriginalDebitCC
|
SC Original Debit
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
GLOpenItemOriginalDebitLC
|
BC Original Debit
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
GLOpenItemOriginalDebitTC
|
TC Original Debit
|
|
->>>,>>>,>>>,>>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)
|
|
|
|
PostingLine_ID
|
Link to PostingLine
|
|
9999999999
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
ClosingDate
|
no
|
GLOpenItemClosingDate
|
yes
|
no
|
|
|
CompanyGLClose
|
no
|
Company_ID
|
yes
|
no
|
|
|
|
|
GL_ID
|
yes
|
no
|
|
|
|
|
GLOpenItemClosingDate
|
yes
|
no
|
|
|
CompanyIdx
|
no
|
Company_ID
|
yes
|
no
|
|
|
CurrecyIdx
|
no
|
Currency_ID
|
yes
|
no
|
|
|
GL
|
no
|
GL_ID
|
yes
|
no
|
|
|
GLClosingDate
|
no
|
GL_ID
|
yes
|
no
|
|
|
|
|
GLOpenItemClosingDate
|
yes
|
no
|
|
|
GLOpenItemKey
|
yes
|
GL_ID
|
yes
|
no
|
|
|
|
|
GLOpenItemKey
|
yes
|
no
|
|
|
IsOpenIdx
|
no
|
GLOpenItemIsOpen
|
yes
|
no
|
|
|
PostingLine
|
no
|
PostingLine_ID
|
yes
|
no
|
|
∗
|
prim
|
yes
|
GLOpenItem_ID
|
yes
|
no
|