About This Guide > ConsolidDump
  
ConsolidDump
Consolidation Export
 
 
Field Name
Label
Col-Label
Format
Dec
 
Company_ID
Link to Company
 
9999999999
 
 
ConsolidDump_ID
Record ID
 
9999999999
 
 
ConsolidDumpChunkSize
Chunk Size
 
->,>>>,>>9
 
 
ConsolidDumpCode
Code
 
x(20)
 
 
ConsolidDumpConsolCCRate
SC Rate
 
->,>>>,>>9.9999999999
10
 
ConsolidDumpConsolCCScale
SC Rate Scale
 
->,>>>,>>9.9999999999
10
 
ConsolidDumpConsolCompCode
Consolidation Entity
Consol Entity Code
x(20)
 
 
ConsolidDumpConsolRate
Consolidation Rate
Consol Rate
->,>>>,>>9.9999999999
10
 
ConsolidDumpConsolRteScale
Consolid Scale Factor
Scale Fact
->,>>>,>>9.9999999999
10
 
ConsolidDumpDate
Export Date
 
99/99/9999
 
 
ConsolidDumpDirectory
Export Directory
 
x(255)
 
 
ConsolidDumpIsOpeningBal
Include Opening Balance
Incl Opening Balance
yes/no
 
 
ConsolidDumpIsWithDetail
Include Detail
Incl Detail
yes/no
 
 
Currency_ID
Statutory Currency
Mgmnt Curr
9999999999
 
 
FromPeriod_ID
From GL Period
 
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)
 
 
OpeningPeriod_ID
Opening GL Period
 
9999999999
 
 
QADC01
 
 
x(40)
 
 
QADC02
 
 
x(255)
 
 
QADD01
 
 
->,>>>,>>9.9999
10
 
QADT01
 
 
99/99/9999
 
 
ToPeriod_ID
To GL Period
 
9999999999
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
Company
no
Company_ID
yes
no
 
Currency
no
Currency_ID
yes
no
 
FromPeriod
no
FromPeriod_ID
yes
no
 
OpenPdIdx
no
OpeningPeriod_ID
yes
no
 ∗
Prim
yes
ConsolidDump_ID
yes
no
 
ToPeriod
no
ToPeriod_ID
yes
no
 
UniqueIdx
yes
Company_ID
yes
no
 
 
 
ConsolidDumpCode
yes
no