|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
COAMaskCC_ID
|
COA Mask CC
|
|
-99999999999
|
|
|
|
COAMaskCCGL_ID
|
COA Mask CC Range GL
|
|
-99999999999
|
|
|
|
COAMaskCCGLDescr
|
Description
|
|
x(40)
|
|
|
|
COAMaskCCGLFrom
|
From
|
|
x(8)
|
|
|
|
COAMaskCCGLIsNeg
|
Disallowed Range
|
|
yes/no
|
|
|
|
COAMaskCCGLTo
|
To
|
|
x(8)
|
|
|
|
GLSharedSet_ID
|
Shared Set
|
|
-99999999999
|
|
|
|
LastModifiedDate
|
Last Modified Date
|
Mod Date
|
99/99/9999
|
|
|
|
LastModifiedTime
|
Last Modified Time
|
Mod Time
|
99999
|
|
|
|
LastModifiedUser
|
Last Modified User
|
Mod User
|
x(20)
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
Prim
|
yes
|
COAMaskCCGL_ID
|
yes
|
no
|
|
|
SharedSetIdx
|
no
|
GLSharedSet_ID
|
yes
|
no
|
|
|
UniqueIdx
|
yes
|
COAMaskCC_ID
|
yes
|
no
|
|
|
|
|
GLSharedSet_ID
|
yes
|
no
|
|
|
|
|
COAMaskCCGLFrom
|
yes
|
no
|
|
|
|
|
COAMaskCCGLTo
|
yes
|
no
|
|
|
|
|
COAMaskCCGLIsNeg
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
COAMaskDiv_ID
|
COA Mask Sub-Account
|
|
-99999999999
|
|
|
|
COAMaskDivCode
|
Sub-Account COA Mask Code
|
|
x(20)
|
|
|
|
COAMaskDivDesc
|
Description
|
|
x(40)
|
|
|
|
COAMaskDivIsActive
|
Active
|
|
yes/no
|
|
|
|
LastModifiedDate
|
Last Modified Date
|
Mod Date
|
99/99/9999
|
|
|
|
LastModifiedTime
|
Last Modified Time
|
Mod Time
|
99999
|
|
|
|
LastModifiedUser
|
Last Modified User
|
Mod User
|
x(20)
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
SharedSet_ID
|
Shared Set
|
|
-99999999999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
Prim
|
yes
|
COAMaskDiv_ID
|
yes
|
no
|
|
|
UniqueIdx
|
yes
|
SharedSet_ID
|
yes
|
no
|
|
|
|
|
COAMaskDivCode
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
COAMaskDiv_ID
|
COA Mask Sub-Account
|
|
-99999999999
|
|
|
|
COAMaskDivGL_ID
|
Record ID
|
|
-99999999999
|
|
|
|
COAMaskDivGLDescr
|
Description
|
|
x(40)
|
|
|
|
COAMaskDivGLFrom
|
From
|
|
x(8)
|
|
|
|
COAMaskDivGLIsNeg
|
Disallowed Range
|
|
yes/no
|
|
|
|
COAMaskDivGLTo
|
To
|
|
x(8)
|
|
|
|
GLSharedSet_ID
|
Shared Set
|
|
-99999999999
|
|
|
|
LastModifiedDate
|
Last Modified Date
|
Mod Date
|
99/99/9999
|
|
|
|
LastModifiedTime
|
Last Modified Time
|
Mod Time
|
99999
|
|
|
|
LastModifiedUser
|
Last Modified User
|
Mod User
|
x(20)
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
Prim
|
yes
|
COAMaskDivGL_ID
|
yes
|
no
|
|
|
SharedSetIdx
|
no
|
GLSharedSet_ID
|
yes
|
no
|
|
|
UniqueIdx
|
yes
|
COAMaskDiv_ID
|
yes
|
no
|
|
|
|
|
GLSharedSet_ID
|
yes
|
no
|
|
|
|
|
COAMaskDivGLFrom
|
yes
|
no
|
|
|
|
|
COAMaskDivGLTo
|
yes
|
no
|
|
|
|
|
COAMaskDivGLIsNeg
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
COAMaskProj_ID
|
Record ID
|
|
-99999999999
|
|
|
|
COAMaskProjCode
|
Project COA Mask Code
|
|
x(20)
|
|
|
|
COAMaskProjDesc
|
Description
|
|
x(40)
|
|
|
|
COAMaskProjIsActive
|
Active
|
|
yes/no
|
|
|
|
LastModifiedDate
|
Last Modified Date
|
Mod Date
|
99/99/9999
|
|
|
|
LastModifiedTime
|
Last Modified Time
|
Mod Time
|
99999
|
|
|
|
LastModifiedUser
|
Last Modified User
|
Mod User
|
x(20)
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
SharedSet_ID
|
Shared Set
|
|
-99999999999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
Prim
|
yes
|
COAMaskProj_ID
|
yes
|
no
|
|
|
UniqueIdx
|
yes
|
SharedSet_ID
|
yes
|
no
|
|
|
|
|
COAMaskProjCode
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
CCSharedSet_ID
|
Shared Set
|
|
-99999999999
|
|
|
|
COAMaskProj_ID
|
COA Mask Project
|
|
-99999999999
|
|
|
|
COAMaskProjCC_ID
|
Record ID
|
|
-99999999999
|
|
|
|
COAMaskProjCCDescr
|
Description
|
|
x(40)
|
|
|
|
COAMaskProjCCFrom
|
From
|
|
x(8)
|
|
|
|
COAMaskProjCCIsNeg
|
Disallowed Range
|
|
yes/no
|
|
|
|
COAMaskProjCCTo
|
To
|
|
x(8)
|
|
|
|
LastModifiedDate
|
Last Modified Date
|
Mod Date
|
99/99/9999
|
|
|
|
LastModifiedTime
|
Last Modified Time
|
Mod Time
|
99999
|
|
|
|
LastModifiedUser
|
Last Modified User
|
Mod User
|
x(20)
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
Prim
|
yes
|
COAMaskProjCC_ID
|
yes
|
no
|
|
|
SharedSetIdx
|
no
|
CCSharedSet_ID
|
yes
|
no
|
|
|
UniqueIdx
|
yes
|
COAMaskProj_ID
|
yes
|
no
|
|
|
|
|
CCSharedSet_ID
|
yes
|
no
|
|
|
|
|
COAMaskProjCCFrom
|
yes
|
no
|
|
|
|
|
COAMaskProjCCTo
|
yes
|
no
|
|
|
|
|
COAMaskProjCCIsNeg
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
COAMaskProj_ID
|
COA Mask Project
|
|
-99999999999
|
|
|
|
COAMaskProjDiv_ID
|
Record ID
|
|
-99999999999
|
|
|
|
COAMaskProjDivDescr
|
Description
|
|
x(40)
|
|
|
|
COAMaskProjDivFrom
|
From
|
|
x(8)
|
|
|
|
COAMaskProjDivIsNeg
|
Disallowed Range
|
|
yes/no
|
|
|
|
COAMaskProjDivTo
|
To
|
|
x(8)
|
|
|
|
DivSharedSet_ID
|
Shared Set
|
|
-99999999999
|
|
|
|
LastModifiedDate
|
Last Modified Date
|
Mod Date
|
99/99/9999
|
|
|
|
LastModifiedTime
|
Last Modified Time
|
Mod Time
|
99999
|
|
|
|
LastModifiedUser
|
Last Modified User
|
Mod User
|
x(20)
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
Prim
|
yes
|
COAMaskProjDiv_ID
|
yes
|
no
|
|
|
SharedSetIdx
|
no
|
DivSharedSet_ID
|
yes
|
no
|
|
|
UniqueIdx
|
yes
|
COAMaskProj_ID
|
yes
|
no
|
|
|
|
|
DivSharedSet_ID
|
yes
|
no
|
|
|
|
|
COAMaskProjDivFrom
|
yes
|
no
|
|
|
|
|
COAMaskProjDivTo
|
yes
|
no
|
|
|
|
|
COAMaskProjDivIsNeg
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
COAMaskProj_ID
|
COA Mask Project
|
|
-99999999999
|
|
|
|
COAMaskProjGL_ID
|
Record ID
|
|
-99999999999
|
|
|
|
COAMaskProjGLDescr
|
Description
|
|
x(40)
|
|
|
|
COAMaskProjGLFrom
|
From
|
|
x(8)
|
|
|
|
COAMaskProjGLIsNeg
|
Disallowed Range
|
|
yes/no
|
|
|
|
COAMaskProjGLTo
|
To
|
|
x(8)
|
|
|
|
GLSharedSet_ID
|
Shared Set
|
|
-99999999999
|
|
|
|
LastModifiedDate
|
Last Modified Date
|
Mod Date
|
99/99/9999
|
|
|
|
LastModifiedTime
|
Last Modified Time
|
Mod Time
|
99999
|
|
|
|
LastModifiedUser
|
Last Modified User
|
Mod User
|
x(20)
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
Prim
|
yes
|
COAMaskProjGL_ID
|
yes
|
no
|
|
|
SharedSetIdx
|
no
|
GLSharedSet_ID
|
yes
|
no
|
|
|
UniqueIdx
|
yes
|
COAMaskProj_ID
|
yes
|
no
|
|
|
|
|
GLSharedSet_ID
|
yes
|
no
|
|
|
|
|
COAMaskProjGLFrom
|
yes
|
no
|
|
|
|
|
COAMaskProjGLTo
|
yes
|
no
|
|
|
|
|
COAMaskProjGLIsNeg
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
code__qadc01
|
|
|
x(8)
|
|
|
|
code_cmmt
|
Comments
|
|
x(40)
|
|
|
|
code_desc
|
Description
|
|
x(24)
|
|
|
|
code_domain
|
Domain
|
|
x(8)
|
|
|
|
code_fldname
|
Field Name
|
|
x(32)
|
|
|
|
code_group
|
Group
|
|
X(24)
|
|
|
|
code_user1
|
Ufld1
|
|
x(8)
|
|
|
|
code_user2
|
Ufld2
|
|
x(8)
|
|
|
|
code_value
|
Value
|
|
x(8)
|
|
|
|
oid_code_mstr
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
code_fldval
|
yes
|
code_domain
|
yes
|
no
|
|
|
|
|
code_fldname
|
yes
|
no
|
|
|
|
|
code_value
|
yes
|
no
|
|
|
code_group
|
no
|
code_group
|
yes
|
no
|
|
|
|
|
code_domain
|
yes
|
no
|
|
|
|
|
code_fldname
|
yes
|
no
|
|
|
|
|
code_value
|
yes
|
no
|
|
|
oid_code_mstr
|
yes
|
oid_code_mstr
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
comd__qadc01
|
QAD Field
|
|
X(8)
|
0
|
|
|
comd__qadc02
|
QAD Field
|
|
X(8)
|
0
|
|
|
comd__qadc03
|
QAD Field
|
|
X(8)
|
0
|
|
|
comd__qadc04
|
QAD Field
|
|
X(8)
|
0
|
|
|
comd__qadd01
|
|
|
->>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
comd__qadd02
|
|
|
->>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
comd__qadi01
|
|
|
>>>>>>9
|
|
|
|
comd__qadi02
|
|
|
>>>>>>9
|
|
|
|
comd__qadl01
|
|
|
yes/no
|
|
|
|
comd__qadl02
|
|
|
yes/no
|
|
|
|
comd__qadt01
|
|
|
99/99/99
|
|
|
|
comd__qadt02
|
|
|
99/99/99
|
|
|
|
comd_comm_code
|
Commodity Code
|
|
x(20)
|
|
|
|
comd_domain
|
Domain
|
|
x(8)
|
|
|
|
comd_part
|
Item Number
|
|
x(18)
|
|
|
|
comd_user1
|
Ufld1
|
|
x(8)
|
|
|
|
comd_user2
|
Ufld2
|
|
x(8)
|
|
|
|
comd_user3
|
|
|
x(8)
|
|
|
|
comd_user4
|
|
|
x(8)
|
|
|
|
oid_comd_det
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
comd_comm_code
|
yes
|
comd_domain
|
yes
|
no
|
|
|
|
|
comd_comm_code
|
yes
|
no
|
|
|
|
|
comd_part
|
yes
|
no
|
|
|
comd_part
|
yes
|
comd_domain
|
yes
|
no
|
|
|
|
|
comd_part
|
yes
|
no
|
|
|
oid_comd_det
|
yes
|
oid_comd_det
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
Company_ID
|
Record ID
|
|
-99999999999
|
|
|
|
CompanyCode
|
Entity Code
|
|
x(20)
|
|
|
|
CompanyDescription
|
Entity Description
|
|
x(24)
|
|
|
|
CompanyDomain
|
Domain
|
|
x(40)
|
|
|
|
CompanyIsActive
|
Active
|
Act
|
yes/no
|
|
|
|
Domain_ID
|
Domain
|
|
-99999999999
|
|
|
|
LastModifiedDate
|
Last Modified Date
|
Mod Date
|
99/99/9999
|
|
|
|
LastModifiedTime
|
Last Modified Time
|
Mod Time
|
99999
|
|
|
|
LastModifiedUser
|
Last Modified User
|
Mod User
|
x(20)
|
|
|
|
LocalisationCode
|
Localization Code
|
|
x(20)
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
Active
|
no
|
CompanyIsActive
|
yes
|
no
|
|
|
Code
|
yes
|
CompanyCode
|
yes
|
no
|
|
|
Domain_FK
|
no
|
Domain_ID
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
Company_ID
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
ActCostPostingJournal_ID
|
Daybook Code
|
|
-99999999999
|
|
|
|
ActSalaryPostingJournal_ID
|
Daybook Code
|
|
-99999999999
|
|
|
|
BusinessRelation_ID
|
Business Relation
|
|
-99999999999
|
|
|
|
Company_ID
|
Link to Company
|
|
-99999999999
|
|
|
|
CompanyProperty_ID
|
Record ID
|
|
-99999999999
|
|
|
|
CompanyPropertyActCheckp
|
Activity Sheets Checkpoint
|
|
x(20)
|
|
|
|
CompanyPropertyActConvFact
|
Conversion Factor to Minutes
|
|
->,>>>,>>9.99
|
8
|
|
|
CompanyPropertyAutoBalYEFailAc
|
Auto-balance Action
|
|
x(20)
|
|
|
|
CompanyPropertyCode
|
Entity Code
|
|
x(20)
|
|
|
|
CompanyPropertyDelTax
|
Delayed Tax
|
|
x(20)
|
|
|
|
CompanyPropertyDelTaxDateType
|
Delayed Date Type
|
|
x(20)
|
|
|
|
CompanyPropertyExchTolAP
|
AP Exchange Tolerance %
|
|
->,>>>,>>9.9999999999
|
10
|
|
|
CompanyPropertyExchTolAR
|
AR Exchange Tolerance %
|
|
->,>>>,>>9.9999999999
|
10
|
|
|
CompanyPropertyIsActDurat
|
Allow Duration
|
|
yes/no
|
|
|
|
CompanyPropertyIsActive
|
Active
|
Act
|
yes/no
|
|
|
|
CompanyPropertyIsAddGLLnNbrIN
|
Additional GL Line Numbering (IN)
|
|
yes/no
|
|
|
|
CompanyPropertyIsAddGLNbr
|
Additional GL Numbering
|
|
yes/no
|
|
|
|
CompanyPropertyIsAddNrYrly
|
Yearly Additional JE Numbering
|
|
yes/no
|
|
|
|
CompanyPropertyIsAPDiscInInvCy
|
Apply AP-Discounts in invoicing Entity
|
|
yes/no
|
|
|
|
CompanyPropertyIsAPTaxExcluded
|
AP Tax Excluded
|
|
yes/no
|
|
|
|
CompanyPropertyIsAPUseInvDate
|
AP Exchange Rate - Use Invoice Date
|
|
yes/no
|
|
|
|
CompanyPropertyIsARDiscInInvCy
|
Apply AR-Discounts in invoicing Entity
|
|
yes/no
|
|
|
|
CompanyPropertyIsARTaxExcluded
|
AR Tax Excluded
|
|
yes/no
|
|
|
|
CompanyPropertyIsARUseTaxDate
|
AR Exchange Rate - Use Taxpoint Date
|
|
yes/no
|
|
|
|
CompanyPropertyIsBudOverCh
|
Check Budgets on Overlap
|
|
yes/no
|
|
|
|
CompanyPropertyIsCInvApprWkfl
|
Supplier Invoice Approval Workflow
|
|
yes/no
|
|
|
|
CompanyPropertyIsCompens
|
Customer/Supplier Compensation allowed
|
|
yes/no
|
|
|
|
CompanyPropertyIsConsolid
|
Consolidation Entity
|
|
yes/no
|
|
|
|
CompanyPropertyIsDelPaid
|
Delay Until Paid Status
|
|
yes/no
|
|
|
|
CompanyPropertyIsDocPerInv
|
Create Payment per Invoice
|
|
yes/no
|
|
|
|
CompanyPropertyIsExclCC
|
Cost Center Restriction
|
|
yes/no
|
|
|
|
CompanyPropertyIsExclGL
|
GL Account Restriction
|
|
yes/no
|
|
|
|
CompanyPropertyIsGlobalTax
|
Global Tax
|
|
yes/no
|
|
|
|
CompanyPropertyIsGrIncAcc
|
Gross Income Accounting
|
|
yes/no
|
|
|
|
CompanyPropertyIsOICrossCy
|
Open Item Cross Entity Allowed
|
|
yes/no
|
|
|
|
CompanyPropertyIsPaySelApWkfl
|
Supplier Payment Selection Approval Workflow
|
Supplier PaySel Approval Workflow
|
yes/no
|
|
|
|
CompanyPropertyIsPLReverse
|
Reverse P&L Revaluations
|
|
yes/no
|
|
|
|
CompanyPropertyIsPrimary
|
Primary Entity
|
|
yes/no
|
|
|
|
CompanyPropertyIsPrintRem
|
Print Remittance
|
|
yes/no
|
|
|
|
CompanyPropertyIsSalPost
|
Salary Posting
|
Sal
|
yes/no
|
|
|
|
CompanyPropertyIsShowSEPAMsg
|
Show SEPA Messages
|
|
yes/no
|
|
|
|
CompanyPropertyIsStockMgt
|
Stock Management
|
Stock Mgt
|
yes/no
|
|
|
|
CompanyPropertyIsSuspPaid
|
Suspend Until Paid Status
|
|
yes/no
|
|
|
|
CompanyPropertyIsWHT
|
Use Withholding Tax
|
|
yes/no
|
|
|
|
CompanyPropertyMirrorSetup
|
Mirror Setup
|
|
x(20)
|
|
|
|
CompanyPropertyOINetRestr
|
Open Item Netting Restriction
|
|
x(20)
|
|
|
|
CompanyPropertyOrdUppLimit
|
Ordinary Invoice Upper Limit
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
CompanyPropertyPriceNumDec
|
Decimals for Price
|
|
->,>>>,>>9
|
|
|
|
CompanyPropertyQtyNumDec
|
Decimals for Qty
|
|
->,>>>,>>9
|
|
|
|
CompanyPropertyRevRecMinim
|
Minimum Percentage of Completion
|
Min % of Completion
|
>>9.99
|
2
|
|
|
CompanyPropertyRevRecTresh
|
Forecasted Revenue Threshold
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
CompanyPropertySuspTax
|
Suspended Tax
|
|
x(20)
|
|
|
|
CompanyPropertySusTaxDateType
|
Suspended Date Type
|
|
x(20)
|
|
|
|
CompanyPropertyUppLimit
|
Special Invoice Upper Limit
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
CompanyPropertyWHTNextNbr
|
Next WHT Number
|
|
999999999
|
|
|
|
CompPropIntercoAPCrGL_ID
|
Link to GL
|
|
-99999999999
|
|
|
|
CompPropIntercoAPDbGL_ID
|
Link to GL
|
|
-99999999999
|
|
|
|
CompPropIntercoARCrCc_ID
|
Cost Center
|
|
-99999999999
|
|
|
|
CompPropIntercoARCrDiv_ID
|
Sub-Account
|
Sub-Acct
|
-99999999999
|
|
|
|
CompPropIntercoARCrGL_ID
|
Account
|
|
-99999999999
|
|
|
|
CompPropIntercoARDbCc_ID
|
Cost Center
|
|
-99999999999
|
|
|
|
CompPropIntercoARDbDiv_ID
|
Sub-Account
|
Sub-Acct
|
-99999999999
|
|
|
|
CompPropIntercoARDbGL_ID
|
Account
|
|
-99999999999
|
|
|
|
CompPropIntercoFACrCc_ID
|
Cost Center
|
|
-99999999999
|
|
|
|
CompPropIntercoFACrDiv_ID
|
Sub-Account
|
Sub-Acct
|
-99999999999
|
|
|
|
CompPropIntercoFACrGL_ID
|
Account
|
|
-99999999999
|
|
|
|
CompPropIntercoFADbCc_ID
|
Cost Center
|
|
-99999999999
|
|
|
|
CompPropIntercoFADbDiv_ID
|
Sub-Account
|
Sub-Acct
|
-99999999999
|
|
|
|
CompPropIntercoFADbGL_ID
|
Account
|
|
-99999999999
|
|
|
|
CompPropIntercoICCrCc_ID
|
Cost Center
|
|
-99999999999
|
|
|
|
CompPropIntercoICCrDiv_ID
|
Sub-Account
|
Sub-Acct
|
-99999999999
|
|
|
|
CompPropIntercoICCrGL_ID
|
Account
|
|
-99999999999
|
|
|
|
CompPropIntercoICDbCc_ID
|
Cost Center
|
|
-99999999999
|
|
|
|
CompPropIntercoICDbDiv_ID
|
Sub-Account
|
Sub-Acct
|
-99999999999
|
|
|
|
CompPropIntercoICDbGL_ID
|
Account
|
|
-99999999999
|
|
|
|
CompPropIsRRAutogenRevReq
|
Review Required for Auto-Generated Contracts
|
|
yes/no
|
|
|
|
CostSafStructure_ID
|
Structure Code
|
Structure
|
-99999999999
|
|
|
|
Currency_ID
|
Base Currency
|
Curr
|
-99999999999
|
|
|
|
CustomCombo0
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo1
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo10
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo11
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo12
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo13
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo14
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo2
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo3
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo4
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo5
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo6
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo7
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo8
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo9
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomDate0
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate1
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate2
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate3
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate4
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDecimal0
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal1
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal2
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal3
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal4
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomInteger0
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger1
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger2
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger3
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger4
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomLong0
|
Custom Long Field
|
|
x(255)
|
|
|
|
CustomLong1
|
Custom Long Field
|
|
x(255)
|
|
|
|
CustomNote
|
Custom Note Field
|
|
x(2000)
|
|
|
|
CustomShort0
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort1
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort10
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort11
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort12
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort13
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort14
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort2
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort3
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort4
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort5
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort6
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort7
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort8
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort9
|
Custom Short Field
|
|
x(20)
|
|
|
|
LastModifiedDate
|
Last Modified Date
|
Mod Date
|
99/99/9999
|
|
|
|
LastModifiedTime
|
Last Modified Time
|
Mod Time
|
99999
|
|
|
|
LastModifiedUser
|
Last Modified User
|
Mod User
|
x(20)
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
RevRecJournal_ID
|
Revenue Recognition Daybook
|
|
-99999999999
|
|
|
|
SafConcept_ID
|
SAF Concept Code
|
|
-99999999999
|
|
|
|
SalarySafStructure_ID
|
Structure Code
|
Structure
|
-99999999999
|
|
|
|
SharedAddNrCompany_ID
|
Entity Code
|
|
-99999999999
|
|
|
|
Unit_ID
|
Time Unit of Measure
|
Time UM
|
-99999999999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
Active
|
no
|
CompanyPropertyIsActive
|
yes
|
no
|
|
|
BusRelIdx
|
no
|
BusinessRelation_ID
|
yes
|
no
|
|
|
Code
|
no
|
CompanyPropertyCode
|
yes
|
no
|
|
|
Company
|
yes
|
Company_ID
|
yes
|
no
|
|
|
CurrencyIdx
|
no
|
Currency_ID
|
yes
|
no
|
|
|
Journal
|
no
|
ActCostPostingJournal_ID
|
yes
|
no
|
|
|
LastModIdx
|
no
|
LastModifiedDate
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
CompanyProperty_ID
|
yes
|
no
|
|
|
SafStructure
|
no
|
CostSafStructure_ID
|
yes
|
no
|
|
|
Unit
|
no
|
Unit_ID
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
Company_ID
|
Entity
|
|
-99999999999
|
|
|
|
CompanySharedSet_ID
|
Record ID
|
|
-99999999999
|
|
|
|
LastModifiedDate
|
Last Modified Date
|
Mod Date
|
99/99/9999
|
|
|
|
LastModifiedTime
|
Last Modified Time
|
Mod Time
|
99999
|
|
|
|
LastModifiedUser
|
Last Modified User
|
Mod User
|
x(20)
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
SharedSet_ID
|
Shared Set
|
|
-99999999999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
Company
|
no
|
Company_ID
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
CompanySharedSet_ID
|
yes
|
no
|
|
|
SharedSet
|
no
|
SharedSet_ID
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
com__log01
|
|
|
yes/no
|
|
|
|
com__qad01
|
|
|
x(8)
|
|
|
|
com__qad02
|
|
|
x(8)
|
|
|
|
com__qad03
|
|
|
yes/no
|
|
|
|
com_comm_code
|
Commodity Code
|
Com Code
|
x(20)
|
|
|
|
com_desc
|
Description
|
|
x(24)
|
|
|
|
com_domain
|
Domain
|
|
x(8)
|
|
|
|
com_pref_policy
|
Preferential Policy
|
|
Yes/No
|
|
|
|
com_pref_policy_desc
|
Policy Description
|
|
x(50)
|
|
|
|
com_suppl
|
Supplementary Units Required
|
S
|
yes/no
|
|
|
|
com_uom
|
Supplementary UOM
|
UOM
|
x(2)
|
|
|
|
com_user1
|
Ufld1
|
|
x(8)
|
|
|
|
com_user2
|
Ufld2
|
|
x(8)
|
|
|
|
com_zero_tax_flag
|
Zero Tax Rate Flag
|
|
x(2)
|
|
|
|
oid_com_mstr
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
com_comm_code
|
yes
|
com_domain
|
yes
|
no
|
|
|
|
|
com_comm_code
|
yes
|
no
|
|
|
oid_com_mstr
|
yes
|
oid_com_mstr
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
Company_ID
|
Link To Company
|
|
-99999999999
|
|
|
|
ConCheck_ID
|
Record ID
|
|
-99999999999
|
|
|
|
ConCheckBatch
|
Batch Code
|
|
x(8)
|
|
|
|
ConCheckDuration
|
Duration
|
|
99999
|
|
|
|
ConCheckErrCount
|
Error Count
|
|
->,>>>,>>9
|
|
|
|
ConCheckIsBatchRun
|
Execute In Batch
|
|
yes/no
|
|
|
|
ConCheckIsUpToDate
|
Up To Date
|
|
yes/no
|
|
|
|
ConCheckResult
|
Result
|
|
x(20)
|
|
|
|
ConCheckSeq
|
Sequence
|
|
->,>>>,>>9
|
|
|
|
ConCheckStartDate
|
Start Date
|
|
99/99/9999
|
|
|
|
ConCheckStartTime
|
Start Time
|
|
99999
|
|
|
|
ConCheckType
|
Type
|
|
x(20)
|
|
|
|
ConCheckVersion
|
Version
|
|
x(20)
|
|
|
|
CustomCombo0
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo1
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo2
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo3
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo4
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo5
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo6
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo7
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo8
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo9
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomDate0
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate1
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate2
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate3
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate4
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDecimal0
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal1
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal2
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal3
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal4
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomInteger0
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger1
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger2
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger3
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger4
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomLong0
|
Custom Long Field
|
|
x(255)
|
|
|
|
CustomLong1
|
Custom Long Field
|
|
x(255)
|
|
|
|
CustomNote
|
Custom Note Field
|
|
x(2000)
|
|
|
|
CustomShort0
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort1
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort2
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort3
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort4
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort5
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort6
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort7
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort8
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort9
|
Custom Short Field
|
|
x(20)
|
|
|
|
LastModifiedDate
|
Last Modified Date
|
Mod Date
|
99/99/9999
|
|
|
|
LastModifiedTime
|
Last Modified Time
|
Mod Time
|
99999
|
|
|
|
LastModifiedUser
|
Last Modified User
|
Mod User
|
x(20)
|
|
|
|
Period_ID
|
Link To Period
|
|
-99999999999
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
CyIdx
|
no
|
Company_ID
|
yes
|
no
|
|
|
PeriodIdx
|
no
|
Period_ID
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
ConCheck_ID
|
yes
|
no
|
|
|
UniqIdx
|
yes
|
Company_ID
|
yes
|
no
|
|
|
|
|
Period_ID
|
yes
|
no
|
|
|
|
|
ConCheckType
|
yes
|
no
|
|
|
|
|
ConCheckSeq
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
ConCheck_ID
|
Con Check
|
|
-99999999999
|
|
|
|
ConCheckLine_ID
|
Record ID
|
|
-99999999999
|
|
|
|
ConCheckLineDuration
|
Duration
|
|
99999
|
|
|
|
ConCheckLineIsSel
|
Select
|
|
yes/no
|
|
|
|
ConCheckLineIsUpToDate
|
Up To Date
|
|
yes/no
|
|
|
|
ConCheckLineResult
|
Result
|
|
->,>>>,>>9
|
|
|
|
ConCheckLineStartDate
|
Start Date
|
|
99/99/9999
|
|
|
|
ConCheckLineStartTime
|
Start Time
|
|
99999
|
|
|
|
ConCheckLineType
|
Type
|
|
x(20)
|
|
|
|
CustomCombo0
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo1
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo2
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo3
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo4
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo5
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo6
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo7
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo8
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo9
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomDate0
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate1
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate2
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate3
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate4
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDecimal0
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal1
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal2
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal3
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal4
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomInteger0
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger1
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger2
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger3
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger4
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomLong0
|
Custom Long Field
|
|
x(255)
|
|
|
|
CustomLong1
|
Custom Long Field
|
|
x(255)
|
|
|
|
CustomNote
|
Custom Note Field
|
|
x(2000)
|
|
|
|
CustomShort0
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort1
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort2
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort3
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort4
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort5
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort6
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort7
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort8
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort9
|
Custom Short Field
|
|
x(20)
|
|
|
|
LastModifiedDate
|
Last Modified Date
|
Mod Date
|
99/99/9999
|
|
|
|
LastModifiedTime
|
Last Modified Time
|
Mod Time
|
99999
|
|
|
|
LastModifiedUser
|
Last Modified User
|
Mod User
|
x(20)
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
ConChIdx
|
no
|
ConCheck_ID
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
ConCheckLine_ID
|
yes
|
no
|
|
|
UniqIdx
|
yes
|
ConCheck_ID
|
yes
|
no
|
|
|
|
|
ConCheckLineType
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
ConCheck_ID
|
Con Check
|
|
-99999999999
|
|
|
|
ConCheckLine_ID
|
Con Check Line
|
|
-99999999999
|
|
|
|
ConCheckLineDet_ID
|
Record ID
|
|
-99999999999
|
|
|
|
ConCheckLineDetDuration
|
Duration
|
|
99999
|
|
|
|
ConCheckLineDetErrCount
|
Error Count
|
|
->,>>>,>>9
|
|
|
|
ConCheckLineDetResult
|
Result
|
|
->,>>>,>>9
|
|
|
|
ConCheckLineDetStartDate
|
Start Date
|
|
99/99/9999
|
|
|
|
ConCheckLineDetStartTime
|
Start Time
|
|
99999
|
|
|
|
ConCheckLineDetType
|
Type
|
|
x(20)
|
|
|
|
ConCheckLineDetVersion
|
Version
|
|
x(20)
|
|
|
|
CustomCombo0
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo1
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo2
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo3
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo4
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo5
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo6
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo7
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo8
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo9
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomDate0
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate1
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate2
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate3
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate4
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDecimal0
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal1
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal2
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal3
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal4
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomInteger0
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger1
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger2
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger3
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger4
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomLong0
|
Custom Long Field
|
|
x(255)
|
|
|
|
CustomLong1
|
Custom Long Field
|
|
x(255)
|
|
|
|
CustomNote
|
Custom Note Field
|
|
x(2000)
|
|
|
|
CustomShort0
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort1
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort2
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort3
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort4
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort5
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort6
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort7
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort8
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort9
|
Custom Short Field
|
|
x(20)
|
|
|
|
LastModifiedDate
|
Last Modified Date
|
Mod Date
|
99/99/9999
|
|
|
|
LastModifiedTime
|
Last Modified Time
|
Mod Time
|
99999
|
|
|
|
LastModifiedUser
|
Last Modified User
|
Mod User
|
x(20)
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
ConsChIdx
|
no
|
ConCheck_ID
|
yes
|
no
|
|
|
ConsChLnIdx
|
no
|
ConCheckLine_ID
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
ConCheckLineDet_ID
|
yes
|
no
|
|
|
UniqIdx
|
yes
|
ConCheckLine_ID
|
yes
|
no
|
|
|
|
|
ConCheckLineDetType
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
Consolid_ID
|
Record ID
|
|
-99999999999
|
|
|
|
ConsolidCompany_ID
|
Entity Code
|
|
-99999999999
|
|
|
|
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
|
-99999999999
|
|
|
|
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
|
|
-99999999999
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
SourceCompany_ID
|
Entity Code
|
|
-99999999999
|
|
|
|
ToPeriod_ID
|
GL Calendar Year
|
GL Cal Year
|
-99999999999
|
|
|
|
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
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
Company_ID
|
Entity Code
|
|
-99999999999
|
|
|
|
ConsolidCycle_ID
|
Record ID
|
|
-99999999999
|
|
|
|
ConsolidCycleDefTaxCode
|
Default Tax Code
|
|
x(8)
|
|
|
|
ConsolidCycleIsWithCostCtr
|
Cost Center
|
|
yes/no
|
|
|
|
ConsolidCycleIsWithDiv
|
Sub-Account
|
|
yes/no
|
|
|
|
ConsolidCycleIsWithProject
|
Project
|
|
yes/no
|
|
|
|
ConsolidCycleIsWithSaf
|
SAF
|
|
yes/no
|
|
|
|
ConsolidCycleStatus
|
Status
|
|
x(20)
|
|
|
|
CostCentre_ID
|
Cost Center Code
|
|
-99999999999
|
|
|
|
Division_ID
|
Sub-Account
|
|
-99999999999
|
|
|
|
GL_ID
|
Rounding Diff Acc
|
Rounding Acc
|
-99999999999
|
|
|
|
LastModifiedDate
|
Last Modified Date
|
Mod Date
|
99/99/9999
|
|
|
|
LastModifiedTime
|
Last Modified Time
|
Mod Time
|
99999
|
|
|
|
LastModifiedUser
|
Last Modified User
|
Mod User
|
x(20)
|
|
|
|
Project_ID
|
Project
|
|
-99999999999
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
CCIdx
|
no
|
CostCentre_ID
|
yes
|
no
|
|
|
CompanyUnique
|
yes
|
Company_ID
|
yes
|
no
|
|
|
Division
|
no
|
Division_ID
|
yes
|
no
|
|
|
GLIdx
|
no
|
GL_ID
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
ConsolidCycle_ID
|
yes
|
no
|
|
|
PrjIdx
|
no
|
Project_ID
|
yes
|
no
|
|
|
Statusdx
|
no
|
ConsolidCycleStatus
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
COACrossRef_ID
|
COA Cross Reference
|
|
-99999999999
|
|
|
|
ConsolidCycle_ID
|
Link to ConsolidCycle
|
|
-99999999999
|
|
|
|
ConsolidCycleCompany_ID
|
Record ID
|
|
-99999999999
|
|
|
|
ConsolidCycleCompanyPerc
|
Percentage
|
|
>>9.99
|
2
|
|
|
LastModifiedDate
|
Last Modified Date
|
Mod Date
|
99/99/9999
|
|
|
|
LastModifiedTime
|
Last Modified Time
|
Mod Time
|
99999
|
|
|
|
LastModifiedUser
|
Last Modified User
|
Mod User
|
x(20)
|
|
|
|
ManagementJournal_ID
|
Management Daybook Code
|
|
-99999999999
|
|
|
|
OfficialJournal_ID
|
Official Daybook Code
|
|
-99999999999
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
SourceCompany_ID
|
Subsidiary Entity
|
|
-99999999999
|
|
|
|
TransientJournal_ID
|
Transient Daybook Code
|
|
-99999999999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
AltPrim
|
yes
|
SourceCompany_ID
|
yes
|
no
|
|
|
|
|
ConsolidCycle_ID
|
yes
|
no
|
|
|
COAIdx
|
no
|
COACrossRef_ID
|
yes
|
no
|
|
|
ConsCycl
|
no
|
ConsolidCycle_ID
|
yes
|
no
|
|
|
ManJrnl
|
no
|
ManagementJournal_ID
|
yes
|
no
|
|
|
OffJrnl
|
yes
|
OfficialJournal_ID
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
ConsolidCycleCompany_ID
|
yes
|
no
|
|
|
SourceCy
|
no
|
SourceCompany_ID
|
yes
|
no
|
|
|
TranJrnl
|
no
|
TransientJournal_ID
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
ConsolidCycle_ID
|
Link to ConsolidCycle
|
|
-99999999999
|
|
|
|
ConsolidCycleSaf_ID
|
Record ID
|
|
-99999999999
|
|
|
|
ConsolidCycleSafInputSeq
|
Sequence
|
|
->,>>>,>>9
|
|
|
|
ConsolidCycleSafParentType
|
SAF Parent Type
|
|
x(20)
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
Saf_ID
|
SAF Code
|
|
-99999999999
|
|
|
|
SafStructure_ID
|
Structure Code
|
Structure
|
-99999999999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
ConsolCycle
|
no
|
ConsolidCycle_ID
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
ConsolidCycleSaf_ID
|
yes
|
no
|
|
|
Saf
|
no
|
Saf_ID
|
yes
|
no
|
|
|
SafStructure
|
no
|
SafStructure_ID
|
yes
|
no
|
|
|
UniqueIdx
|
yes
|
ConsolidCycleSafInputSeq
|
yes
|
no
|
|
|
|
|
ConsolidCycleSafParentType
|
yes
|
no
|
|
|
|
|
ConsolidCycle_ID
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
Company_ID
|
Link to Company
|
|
-99999999999
|
|
|
|
ConsolidDump_ID
|
Record ID
|
|
-99999999999
|
|
|
|
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
|
-99999999999
|
|
|
|
FromPeriod_ID
|
From GL Period
|
|
-99999999999
|
|
|
|
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
|
|
-99999999999
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
ToPeriod_ID
|
To GL Period
|
|
-99999999999
|
|
|
|
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
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
Consolid_ID
|
Link to Consolid
|
|
-99999999999
|
|
|
|
ConsolidLayer_ID
|
Record ID
|
|
-99999999999
|
|
|
|
Layer_ID
|
Source Layer Code
|
Source Layer
|
-99999999999
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
Consolid
|
no
|
Consolid_ID
|
yes
|
no
|
|
|
Layer
|
no
|
Layer_ID
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
ConsolidLayer_ID
|
yes
|
no
|
|
|
UniqueIdx
|
yes
|
Consolid_ID
|
yes
|
no
|
|
|
|
|
Layer_ID
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
Company_ID
|
Link to Company
|
|
-99999999999
|
|
|
|
ConsolidationCompany_ID
|
Consolidation Entity
|
|
-99999999999
|
|
|
|
ConsolidationPeriod_ID
|
Consolidation Period
|
Cons Period
|
-99999999999
|
|
|
|
ConsolidPeriodXref_ID
|
Record ID
|
|
-99999999999
|
|
|
|
LastModifiedDate
|
Last Modified Date
|
Mod Date
|
99/99/9999
|
|
|
|
LastModifiedTime
|
Last Modified Time
|
Mod Time
|
99999
|
|
|
|
LastModifiedUser
|
Last Modified User
|
Mod User
|
x(20)
|
|
|
|
Period_ID
|
Source GL Period
|
|
-99999999999
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
AltPrim
|
yes
|
Company_ID
|
yes
|
no
|
|
|
|
|
ConsolidationCompany_ID
|
yes
|
no
|
|
|
|
|
Period_ID
|
yes
|
no
|
|
|
CompanyIdx
|
no
|
Company_ID
|
yes
|
no
|
|
|
ConsolCy
|
no
|
ConsolidationCompany_ID
|
yes
|
no
|
|
|
ConsolPd
|
no
|
ConsolidationPeriod_ID
|
yes
|
no
|
|
|
PeriodIdx
|
no
|
Period_ID
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
ConsolidPeriodXref_ID
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
Consolid_ID
|
Link to Consolid
|
|
-99999999999
|
|
|
|
ConsolidPostingXref_ID
|
Record ID
|
|
-99999999999
|
|
|
|
PostingHist_ID
|
Link to PostingHist
|
|
-99999999999
|
|
|
|
PostingLine_ID
|
Link to PostingLine
|
|
-99999999999
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
Consolid
|
no
|
Consolid_ID
|
yes
|
no
|
|
|
PostHist
|
no
|
PostingHist_ID
|
yes
|
no
|
|
|
PostLine
|
no
|
PostingLine_ID
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
ConsolidPostingXref_ID
|
yes
|
no
|
|
|
UniqueIdx
|
yes
|
Consolid_ID
|
yes
|
no
|
|
|
|
|
PostingLine_ID
|
yes
|
no
|
|
|
|
|
PostingHist_ID
|
yes
|
no
|