About This Guide > Consolid
  
Consolid
Consolidation
 
 
Field Name
Label
Col-Label
Format
Dec
 
Consolid_ID
Record ID
 
9999999999
 
 
ConsolidCompany_ID
Entity Code
 
9999999999
 
 
ConsolidDate
Date
 
99/99/9999
 
 
ConsolidEndTime
End Time
 
->,>>>,>>9
 
 
ConsolidNumber
Number
 
->,>>>,>>9
 
 
ConsolidSourceLayerTypCode
Source Layer Type
 
x(20)
 
 
ConsolidStartTime
Start Time
 
->,>>>,>>9
 
 
ConsolidStatus
Status
 
x(20)
 
 
ConsolidTargetLayerTypCode
Target Layer Type
 
x(20)
 
 
FromPeriod_ID
GL Calendar Year
GL Cal Year
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
Voucher
 
9999999999
 
 
QADC01
 
 
x(40)
 
 
QADC02
 
 
x(255)
 
 
QADD01
 
 
->,>>>,>>9.9999
10
 
QADT01
 
 
99/99/9999
 
 
SourceCompany_ID
Entity Code
 
9999999999
 
 
ToPeriod_ID
GL Calendar Year
GL Cal Year
9999999999
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
ConsolidCompanyIdx
no
ConsolidCompany_ID
yes
no
 
FromPeriodIdx
no
FromPeriod_ID
yes
no
 
PostingIdx
no
Posting_ID
yes
no
 ∗
Prim
yes
Consolid_ID
yes
no
 
SourceCompanyIdx
no
SourceCompany_ID
yes
no
 
ToPeriodIdx
no
ToPeriod_ID
yes
no