|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
Company_ID
|
Link to Company
|
|
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)
|
|
|
|
Layer_ID
|
Layer Code
|
|
9999999999
|
|
|
|
Period_ID
|
GL Cal Year
|
|
9999999999
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
RevalHeader_ID
|
Record ID
|
|
9999999999
|
|
|
|
RevalHeaderDescription
|
Rev Desc
|
|
x(40)
|
|
|
|
RevalHeaderIsForCC
|
Include Statutory Currency
|
|
yes/no
|
|
|
|
RevalHeaderIsForLC
|
Include Base Currency
|
|
yes/no
|
|
|
|
RevalHeaderNumber
|
Rev Number
|
|
999999999
|
|
|
|
RevalHeaderRevalDate
|
Rev Date
|
|
99/99/9999
|
|
|
|
Source1Layer_ID
|
Link to Source Layer 1
|
|
9999999999
|
|
|
|
Source2Layer_ID
|
Link to Source Layer 2
|
|
9999999999
|
|
|
|
Source3Layer_ID
|
Link to Source Layer 3
|
|
9999999999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
Company
|
no
|
Company_ID
|
yes
|
no
|
|
|
Layer
|
no
|
Layer_ID
|
yes
|
no
|
|
|
Period
|
no
|
Period_ID
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
RevalHeader_ID
|
yes
|
no
|
|
|
RevalDate
|
no
|
RevalHeaderRevalDate
|
yes
|
no
|
|
|
RevalNumber
|
no
|
RevalHeaderNumber
|
yes
|
no
|
|
|
SourceLayer1
|
no
|
Source1Layer_ID
|
yes
|
no
|
|
|
SourceLayer2
|
no
|
Source2Layer_ID
|
yes
|
no
|
|
|
SourceLayer3
|
no
|
Source3Layer_ID
|
yes
|
no
|
|
|
UniqueIdx
|
yes
|
Company_ID
|
yes
|
no
|
|
|
|
|
Period_ID
|
yes
|
no
|
|
|
|
|
RevalHeaderNumber
|
yes
|
no
|