|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
Address_ID
|
Link to Address
|
|
-99999999999
|
|
|
|
BusinessRelation_ID
|
Link to BusinessRelation
|
|
-99999999999
|
|
|
|
Contact_ID
|
Record ID
|
|
-99999999999
|
|
|
|
ContactEmail
|
E-Mail
|
|
x(48)
|
|
|
|
ContactFax
|
Fax
|
|
x(40)
|
|
|
|
ContactFunction
|
Function
|
|
x(20)
|
|
|
|
ContactGender
|
Gender
|
|
x(10)
|
|
|
|
ContactInitials
|
Initials
|
|
x(20)
|
|
|
|
ContactIsPrimary
|
Primary Contact
|
Primary
|
yes/no
|
|
|
|
ContactIsSecondary
|
Secondary Contact
|
Secondary
|
yes/no
|
|
|
|
ContactMobilePhone
|
Mobile Phone
|
Mobile
|
x(40)
|
|
|
|
ContactName
|
Name
|
|
x(24)
|
|
|
|
ContactTelephone
|
Telephone
|
|
x(40)
|
|
|
|
ContactTitle
|
Title
|
|
x(10)
|
|
|
|
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)
|
|
|
|
Lng_ID
|
Language Code
|
Lang
|
-99999999999
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
Address
|
no
|
Address_ID
|
yes
|
no
|
|
|
AddressName
|
yes
|
Address_ID
|
yes
|
no
|
|
|
|
|
ContactName
|
yes
|
no
|
|
|
BusinessRelation
|
no
|
BusinessRelation_ID
|
yes
|
no
|
|
|
ContactName
|
no
|
ContactName
|
yes
|
no
|
|
|
LastModIdx
|
no
|
LastModifiedDate
|
yes
|
no
|
|
|
LngIdx
|
no
|
Lng_ID
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
Contact_ID
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
cont__qadc01
|
|
|
x(24)
|
|
|
|
cont__qadc02
|
|
|
x(24)
|
|
|
|
cont_class
|
Class
|
|
x(8)
|
|
|
|
cont_cmtindx
|
Comment Index
|
Comment
|
>>>>>>>9
|
|
|
|
cont_color
|
Color
|
|
x(8)
|
|
|
|
cont_composition
|
Composition
|
Comp
|
x(8)
|
|
|
|
cont_desc
|
Description
|
|
x(24)
|
|
|
|
cont_domain
|
Domain
|
|
x(8)
|
|
|
|
cont_height
|
Height
|
|
->>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
cont_hwl_um
|
UM
|
|
x(2)
|
|
|
|
cont_id_method
|
ID Method
|
|
x(24)
|
|
|
|
cont_length
|
Length
|
|
->>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
cont_max_load_weight
|
Maximum Load Weight
|
Max Load
|
->>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
cont_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
cont_mod_userid
|
User ID
|
|
x(8)
|
|
|
|
cont_owner
|
Container Owner
|
Container!Owner
|
>9
|
|
|
|
cont_reference1
|
Reference 1
|
|
x(24)
|
|
|
|
cont_reference2
|
Reference 2
|
|
x(24)
|
|
|
|
cont_reference3
|
Reference 3
|
|
x(24)
|
|
|
|
cont_reference4
|
Reference 4
|
|
x(24)
|
|
|
|
cont_reference5
|
Reference 5
|
|
x(24)
|
|
|
|
cont_returnable
|
Returnable
|
|
yes/no
|
|
|
|
cont_reusable
|
Reusable
|
|
yes/no
|
|
|
|
cont_size
|
Size
|
|
x(8)
|
|
|
|
cont_special_reqmnts
|
Special Requirements
|
Spec!Req
|
yes/no
|
|
|
|
cont_tare_weight
|
Tare Weight
|
|
->>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
cont_thickness
|
Thickness
|
|
->>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
cont_thickness_um
|
UM
|
|
x(2)
|
|
|
|
cont_type
|
Container Type
|
Cont!Type
|
x(8)
|
|
|
|
cont_user1
|
User Field Character 1
|
|
x(24)
|
|
|
|
cont_user2
|
User Field Character 2
|
|
x(24)
|
|
|
|
cont_volume
|
Volume
|
|
->>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
cont_volume_um
|
UM
|
|
x(2)
|
|
|
|
cont_weight_um
|
UM
|
|
x(2)
|
|
|
|
cont_width
|
Width
|
|
->>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
oid_cont_mstr
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
cont_type
|
yes
|
cont_domain
|
yes
|
no
|
|
|
|
|
cont_type
|
yes
|
no
|
|
|
oid_cont_mstr
|
yes
|
oid_cont_mstr
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
CorporateGroup_ID
|
Record ID
|
|
-99999999999
|
|
|
|
CorporateGroupCode
|
Group Name
|
|
x(20)
|
|
|
|
CorporateGroupDescription
|
Description
|
|
x(40)
|
|
|
|
CorporateGroupIsActive
|
Active
|
Act
|
yes/no
|
|
|
|
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
|
|
|
Code
|
yes
|
CorporateGroupCode
|
yes
|
no
|
|
|
LastModIdx
|
no
|
LastModifiedDate
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
CorporateGroup_ID
|
yes
|
no
|
|
|
ViewIndex
|
no
|
CorporateGroupIsActive
|
yes
|
no
|
|
|
|
|
CorporateGroupCode
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
BudgetGroup_ID
|
Budget Group
|
|
-99999999999
|
|
|
|
COAMaskCCProfile_ID
|
COAMask Profile
|
|
-99999999999
|
|
|
|
CostCentre_ID
|
Record ID
|
|
-99999999999
|
|
|
|
CostCentreCode
|
Cost Center
|
|
x(4)
|
|
|
|
CostCentreDescription
|
Description
|
|
x(24)
|
|
|
|
CostCentreIsActive
|
Active
|
|
yes/no
|
|
|
|
CostCentreIsStructFromGL
|
Retrieve SAF Structure from GL
|
Retrieve Structure from GL
|
yes/no
|
|
|
|
CostCentreIsWithSaf
|
SAF Enabled
|
SAF
|
yes/no
|
|
|
|
CostCentreSafSetOnByUsr_ID
|
Link to Usr
|
|
-99999999999
|
|
|
|
CostCentreSafSetOnOnDate
|
SAF Set on Date
|
|
99/99/9999
|
|
|
|
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)
|
|
|
|
DivisionProfile_ID
|
Link to Profile
|
|
-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
|
Link to SharedSet
|
|
-99999999999
|
|
|
|
Usr_ID
|
Cost Center Administrator
|
|
-99999999999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
BudgetGroup
|
no
|
BudgetGroup_ID
|
yes
|
no
|
|
|
CCByUsrIdx
|
no
|
CostCentreSafSetOnByUsr_ID
|
yes
|
no
|
|
|
COAMaskProfileIdx
|
no
|
COAMaskCCProfile_ID
|
yes
|
no
|
|
|
Code
|
no
|
CostCentreCode
|
yes
|
no
|
|
|
DivProfIdx
|
no
|
DivisionProfile_ID
|
yes
|
no
|
|
|
IsActive
|
no
|
CostCentreIsActive
|
yes
|
no
|
|
|
LastModIdx
|
no
|
LastModifiedDate
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
CostCentre_ID
|
yes
|
no
|
|
|
SharedSet
|
no
|
SharedSet_ID
|
yes
|
no
|
|
|
SharedSetAndCode
|
yes
|
SharedSet_ID
|
yes
|
no
|
|
|
|
|
CostCentreCode
|
yes
|
no
|
|
|
UsrIdx
|
no
|
Usr_ID
|
yes
|
no
|
|
|
ViewIndex
|
no
|
SharedSet_ID
|
yes
|
no
|
|
|
|
|
CostCentreIsActive
|
yes
|
no
|
|
|
|
|
CostCentreCode
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
CostCentre_ID
|
Link to CostCentre
|
|
-99999999999
|
|
|
|
CostCentreSafDefault_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
|
|
|
|
Saf_ID
|
SAF Code
|
|
-99999999999
|
|
|
|
SafConcept_ID
|
SAF Concept Code
|
|
-99999999999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
CostC
|
no
|
CostCentre_ID
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
CostCentreSafDefault_ID
|
yes
|
no
|
|
|
Saf
|
no
|
Saf_ID
|
yes
|
no
|
|
|
SafConc
|
no
|
SafConcept_ID
|
yes
|
no
|
|
|
UniIdx
|
yes
|
CostCentre_ID
|
yes
|
no
|
|
|
|
|
SafConcept_ID
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
cost__qadc01
|
|
|
x(8)
|
|
|
|
cost_cmtindx
|
Comment
|
|
>>>>>>>9
|
|
|
|
cost_domain
|
Domain
|
|
x(8)
|
|
|
|
cost_memo
|
Memo
|
|
x(24)
|
|
|
|
cost_set
|
Cost Set
|
|
x(18)
|
|
|
|
cost_site
|
Site
|
|
x(8)
|
|
|
|
cost_start
|
Start Date
|
Start
|
99/99/99
|
|
|
|
cost_user1
|
Ufld1
|
|
x(8)
|
|
|
|
cost_user2
|
Ufld2
|
|
x(8)
|
|
|
|
oid_cost_cal
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
cost_cal
|
yes
|
cost_domain
|
yes
|
no
|
|
|
|
|
cost_site
|
yes
|
no
|
|
|
|
|
cost_set
|
yes
|
no
|
|
|
|
|
cost_start
|
yes
|
no
|
|
∗
|
cost_date
|
yes
|
cost_domain
|
yes
|
no
|
|
|
|
|
cost_start
|
yes
|
no
|
|
|
|
|
cost_site
|
yes
|
no
|
|
|
cost_site
|
yes
|
cost_domain
|
yes
|
no
|
|
|
|
|
cost_site
|
yes
|
no
|
|
|
|
|
cost_start
|
yes
|
no
|
|
|
oid_cost_cal
|
yes
|
oid_cost_cal
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
BLWICountry_ID
|
BLWI Country Code
|
BLWI Country
|
-99999999999
|
|
|
|
Country_ID
|
Record ID
|
|
-99999999999
|
|
|
|
CountryAdditionalCodeIN
|
Country Additional Code (IN)
|
|
x(20)
|
|
|
|
CountryBLWICode
|
BLWI Code
|
|
x(20)
|
|
|
|
CountryCode
|
Country Code
|
Country
|
x(3)
|
|
|
|
CountryDescription
|
Description
|
|
x(28)
|
|
|
|
CountryFormat
|
Postal Format
|
|
9
|
|
|
|
CountryIsActive
|
Active
|
|
yes/no
|
|
|
|
CountryIsEUCountry
|
EU Member
|
EU
|
yes/no
|
|
|
|
CountryIsInListIN
|
In List (IN)
|
|
yes/no
|
|
|
|
Currency_ID
|
Currency Code
|
Country
|
-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)
|
|
|
|
CustomShort15
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort16
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort17
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort18
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort19
|
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
|
|
|
Active
|
no
|
CountryIsActive
|
yes
|
no
|
|
|
Code
|
yes
|
CountryCode
|
yes
|
no
|
|
|
CurrIdx
|
no
|
Currency_ID
|
yes
|
no
|
|
|
LastModIdx
|
no
|
LastModifiedDate
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
Country_ID
|
yes
|
no
|
|
|
ViewIndex
|
no
|
CountryIsActive
|
yes
|
no
|
|
|
|
|
CountryCode
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
Country_ID
|
Link to Country
|
|
-99999999999
|
|
|
|
CountryVatFormat
|
Tax Format
|
|
x(20)
|
|
|
|
CountryVatFormat_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
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
AltUniqueIdx
|
yes
|
CountryVatFormat
|
yes
|
no
|
|
|
|
|
Country_ID
|
yes
|
no
|
|
|
Country
|
no
|
Country_ID
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
CountryVatFormat_ID
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
County_ID
|
Record ID
|
|
-99999999999
|
|
|
|
CountyCode
|
County Code
|
County
|
x(20)
|
|
|
|
CountyDescription
|
Description
|
|
x(40)
|
|
|
|
CountyIsActive
|
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
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
Code
|
yes
|
CountyCode
|
yes
|
no
|
|
|
IsActive
|
no
|
CountyIsActive
|
yes
|
no
|
|
|
LastModIdx
|
no
|
LastModifiedDate
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
County_ID
|
yes
|
no
|
|
|
ViewIndex
|
no
|
CountyIsActive
|
yes
|
no
|
|
|
|
|
CountyCode
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
co__qad01
|
Primary Statement Version
|
Primary!Stmt Ver
|
x(8)
|
|
|
|
co__qadi01
|
|
|
->>>>>>>9
|
|
|
|
co__qadl01
|
|
|
yes/no
|
|
|
|
co_allow_mod
|
Allow Changes to Module Transactions
|
Allow! Mod
|
yes/no
|
|
|
|
co_audglt
|
GL Transaction Audit Trail
|
|
yes/no
|
|
|
|
co_bfb_acct
|
Brought Forward Balance Acct
|
BFB Acct
|
x(8)
|
|
|
|
co_bfb_cc
|
Brought Forward Balance CC
|
BFB CC
|
x(4)
|
|
|
|
co_bfb_desc
|
Brought Forward Balance Desc
|
|
x(20)
|
|
|
|
co_bfb_sub
|
Brought Forward Balance Sub
|
BFB Sub
|
x(8)
|
|
|
|
co_close_bs
|
Close Balance Sheet
|
|
yes/no
|
|
|
|
co_cont_page
|
Continuous Page Numbers for Post Audit
|
Cont!Page
|
yes/no
|
|
|
|
co_daily_seq
|
Daily/Continuous Reference Sequence
|
|
Daily/Continuous
|
|
|
|
co_domain
|
Domain
|
|
x(8)
|
|
|
|
co_enty_bal
|
Balanced Entities
|
Bal Enty
|
yes/no
|
|
|
|
co_ex_ratetype
|
Rate Type
|
|
x(8)
|
|
|
|
co_fa_trans_exp
|
Fixed Assets Transactions Posted
|
FA Posted
|
yes/no
|
|
|
|
co_fx_acct
|
Translation Adj Acct (IS)
|
Trans (IS)
|
x(8)
|
|
|
|
co_gl_batch_size
|
GL Posting Batch Size
|
|
->,>>>,>>9
|
|
|
|
co_ic_trans_exp
|
Inventory Transactions Posted
|
IC Posted
|
yes/no
|
|
|
|
co_page_num
|
Last Page Number for Post Audit
|
Page
|
>>>>9
|
|
|
|
co_pl
|
Profit/Loss Account (BS)
|
P/L Acct
|
x(8)
|
|
|
|
co_ret
|
Retained Earnings Account
|
Ret Earn
|
x(8)
|
|
|
|
co_so_trans_exp
|
Sales Order Transactions Posted
|
SO Posted
|
yes/no
|
|
|
|
co_sup_reop
|
Suppress Reopen Closed Periods
|
|
yes/no
|
|
|
|
co_trns_acct
|
Translation Adj Acct (BS)
|
Trans (BS)
|
x(8)
|
|
|
|
co_use_cc
|
Use Cost Centers
|
Use!CC
|
yes/no
|
|
|
|
co_use_sub
|
Use Sub-Accounts
|
Sub!Acct
|
yes/no
|
|
|
|
co_user1
|
Ufld1
|
|
x(8)
|
|
|
|
co_user2
|
Ufld2
|
|
x(8)
|
|
|
|
co_var_acct
|
Unrealized Exch Gain/Loss Acct
|
Un Gn/Ls
|
x(8)
|
|
|
|
co_wo_trans_exp
|
Work Order Transactions Posted
|
WO Posted
|
yes/no
|
|
|
|
co_yec_acct
|
Year End Closing Balance Acct
|
YEC Acct
|
x(8)
|
|
|
|
co_yec_cc
|
Year End Closing Balance CC
|
YEC CC
|
x(4)
|
|
|
|
co_yec_desc
|
Year End Closing Balance Desc
|
|
x(20)
|
|
|
|
co_yec_sub
|
Year End Closing Balance Sub
|
YEC Sub
|
x(8)
|
|
|
|
oid_co_ctrl
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
co_index1
|
yes
|
co_domain
|
yes
|
no
|
|
|
oid_co_ctrl
|
yes
|
oid_co_ctrl
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
CDocument_ID
|
Link to CDocument
|
|
-99999999999
|
|
|
|
CInvoice_ID
|
Link to CInvoice
|
|
-99999999999
|
|
|
|
CPay_ID
|
Record ID
|
|
-99999999999
|
|
|
|
CPayConfirmType
|
Confirm Message Type
|
|
x(20)
|
|
|
|
CPayTransTpStat
|
Transaction Type Status
|
|
x(20)
|
|
|
|
CPayTypeCode
|
Type
|
|
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)
|
|
|
|
PaySelLine_ID
|
Link to PaySelLine
|
|
-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
|
|
|
CDocument
|
no
|
CDocument_ID
|
yes
|
no
|
|
|
CInvoice
|
no
|
CInvoice_ID
|
yes
|
no
|
|
|
PaySelLineIdx
|
no
|
PaySelLine_ID
|
yes
|
no
|
|
|
PostingLine
|
no
|
PostingLine_ID
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
CPay_ID
|
yes
|
no
|
|
|
TypeCode
|
no
|
CPayTypeCode
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
cpcd__chr01
|
|
|
x(8)
|
|
|
|
cpcd__chr02
|
|
|
x(8)
|
|
|
|
cpcd__chr03
|
|
|
x(8)
|
|
|
|
cpcd__chr04
|
|
|
x(8)
|
|
|
|
cpcd__dec01
|
|
|
->>,>>9.99
|
10
|
|
|
cpcd__log01
|
|
|
yes/no
|
|
|
|
cpcd_cust
|
Customer
|
|
x(8)
|
|
|
|
cpcd_domain
|
Domain
|
|
x(8)
|
|
|
|
cpcd_end
|
Expire
|
|
99/99/99
|
|
|
|
cpcd_per
|
Period
|
|
>>9
|
|
|
|
cpcd_start
|
Start
|
|
99/99/99
|
|
|
|
cpcd_type
|
Period Type
|
Type
|
x(1)
|
|
|
|
cpcd_user1
|
Ufld1
|
|
x(8)
|
|
|
|
cpcd_user2
|
Ufld2
|
|
x(8)
|
|
|
|
cpcd_year
|
Year
|
|
9999
|
|
|
|
oid_cpcd_det
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
cpcd_per
|
yes
|
cpcd_domain
|
yes
|
no
|
|
|
|
|
cpcd_cust
|
yes
|
no
|
|
|
|
|
cpcd_year
|
yes
|
no
|
|
|
|
|
cpcd_type
|
yes
|
no
|
|
|
|
|
cpcd_per
|
yes
|
no
|
|
|
oid_cpcd_det
|
yes
|
oid_cpcd_det
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
cpc__chr01
|
|
|
x(8)
|
|
|
|
cpc__chr02
|
|
|
x(8)
|
|
|
|
cpc__chr03
|
|
|
x(8)
|
|
|
|
cpc__chr04
|
|
|
x(8)
|
|
|
|
cpc__dec01
|
|
|
->>,>>9.99
|
10
|
|
|
cpc__log01
|
|
|
yes/no
|
|
|
|
cpc_cust
|
Customer
|
|
x(8)
|
|
|
|
cpc_desc
|
Description
|
Desc
|
x(24)
|
|
|
|
cpc_domain
|
Domain
|
|
x(8)
|
|
|
|
cpc_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
cpc_type
|
Period Type
|
Type
|
x(1)
|
|
|
|
cpc_user1
|
Ufld1
|
|
x(8)
|
|
|
|
cpc_user2
|
Ufld2
|
|
x(8)
|
|
|
|
cpc_userid
|
User ID
|
|
x(8)
|
|
|
|
cpc_year
|
Year
|
|
9999
|
|
|
|
oid_cpc_mstr
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
cpc_cust
|
yes
|
cpc_domain
|
yes
|
no
|
|
|
|
|
cpc_cust
|
yes
|
no
|
|
|
|
|
cpc_year
|
yes
|
no
|
|
|
|
|
cpc_type
|
yes
|
no
|
|
|
oid_cpc_mstr
|
yes
|
oid_cpc_mstr
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
cph__chr01
|
|
|
x(8)
|
|
|
|
cph__chr02
|
|
|
x(8)
|
|
|
|
cph__chr03
|
|
|
x(8)
|
|
|
|
cph__chr04
|
|
|
x(8)
|
|
|
|
cph__chr05
|
|
|
x(8)
|
|
|
|
cph__dec01[12]
|
|
|
>>>>,>>>,>>9.99
|
10
|
|
|
cph__dec02[12]
|
|
|
>>>>,>>>,>>9.99
|
10
|
|
|
cph__dte01
|
|
|
99/99/99
|
|
|
|
cph__dte02
|
|
|
99/99/99
|
|
|
|
cph__log01
|
|
|
yes/no
|
|
|
|
cph_cost[12]
|
Cost
|
|
->>>>,>>>,>>9
|
10
|
|
|
cph_cust
|
Customer
|
|
x(8)
|
|
|
|
cph_domain
|
Domain
|
|
x(8)
|
|
|
|
cph_part
|
Item Number
|
|
x(18)
|
|
|
|
cph_pl
|
Product Line
|
|
x(4)
|
|
|
|
cph_qty[12]
|
Quantity
|
|
->,>>>,>>9
|
10
|
|
|
cph_sales[12]
|
Sales
|
|
->>>>,>>>,>>9
|
10
|
|
|
cph_ship
|
Ship-To
|
|
x(8)
|
|
|
|
cph_site
|
Site
|
|
x(8)
|
|
|
|
cph_smonth
|
Start Month
|
|
>9
|
|
|
|
cph_tot_cost
|
YTD Cost
|
|
->>,>>>,>>>,>>9
|
10
|
|
|
cph_tot_qty
|
YTD Quantity
|
|
->>>,>>>,>>9
|
10
|
|
|
cph_tot_sale
|
YTD Sales
|
|
->>,>>>,>>>,>>9
|
10
|
|
|
cph_type
|
Ship Type
|
T
|
x(1)
|
|
|
|
cph_user1
|
Ufld1
|
|
x(8)
|
|
|
|
cph_user2
|
Ufld2
|
|
x(8)
|
|
|
|
cph_year
|
Year
|
|
9999
|
|
|
|
oid_cph_hist
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
cph_cust
|
yes
|
cph_domain
|
yes
|
no
|
|
|
|
|
cph_cust
|
yes
|
no
|
|
|
|
|
cph_ship
|
yes
|
no
|
|
|
|
|
cph_pl
|
yes
|
no
|
|
|
|
|
cph_part
|
yes
|
no
|
|
|
|
|
cph_type
|
yes
|
no
|
|
|
|
|
cph_year
|
yes
|
no
|
|
|
|
|
cph_site
|
yes
|
no
|
|
|
cph_part
|
no
|
cph_domain
|
yes
|
no
|
|
|
|
|
cph_part
|
yes
|
no
|
|
|
|
|
cph_type
|
yes
|
no
|
|
|
|
|
cph_year
|
yes
|
no
|
|
∗
|
cph_pl
|
no
|
cph_domain
|
yes
|
no
|
|
|
|
|
cph_pl
|
yes
|
no
|
|
|
|
|
cph_part
|
yes
|
no
|
|
|
|
|
cph_type
|
yes
|
no
|
|
|
|
|
cph_year
|
yes
|
no
|
|
|
oid_cph_hist
|
yes
|
oid_cph_hist
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
cp__qadc01
|
|
|
x(8)
|
|
|
|
cp_comment
|
Comment
|
|
x(40)
|
|
|
|
cp_cust
|
Customer
|
|
x(8)
|
|
|
|
cp_cust_eco
|
Customer Item ECO Nbr
|
|
x(8)
|
|
|
|
cp_cust_part
|
Customer Item
|
|
x(30)
|
|
|
|
cp_cust_partd
|
Display Customer Item
|
|
x(30)
|
|
|
|
cp_domain
|
Domain
|
|
x(8)
|
|
|
|
cp_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
cp_part
|
Item Number
|
|
x(18)
|
|
|
|
cp_pkg_code
|
Pkg Code
|
|
x(18)
|
|
|
|
cp_user1
|
Ufld1
|
|
x(8)
|
|
|
|
cp_user2
|
Ufld2
|
|
x(8)
|
|
|
|
cp_userid
|
User ID
|
|
x(8)
|
|
|
|
oid_cp_mstr
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
cp_cust
|
yes
|
cp_domain
|
yes
|
no
|
|
|
|
|
cp_cust
|
yes
|
no
|
|
|
|
|
cp_cust_part
|
yes
|
no
|
|
|
cp_cust_part
|
no
|
cp_domain
|
yes
|
no
|
|
|
|
|
cp_cust_part
|
yes
|
no
|
|
|
|
|
cp_part
|
yes
|
no
|
|
|
cp_part_cust
|
no
|
cp_domain
|
yes
|
no
|
|
|
|
|
cp_part
|
yes
|
no
|
|
|
|
|
cp_cust
|
yes
|
no
|
|
|
oid_cp_mstr
|
yes
|
oid_cp_mstr
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
crc__qadc01
|
|
|
x(8)
|
|
|
|
crc__qadi01
|
|
|
->>>>>>>9
|
|
|
|
crc_domain
|
Domain
|
|
x(8)
|
|
|
|
crc_nbr
|
Next Carrier
|
|
99999999
|
|
|
|
crc_user1
|
Ufld1
|
|
x(8)
|
|
|
|
crc_user2
|
Ufld2
|
|
x(8)
|
|
|
|
oid_crc_ctrl
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
crc_index1
|
yes
|
crc_domain
|
yes
|
no
|
|
|
oid_crc_ctrl
|
yes
|
oid_crc_ctrl
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
crd__qadc01
|
|
|
x(24)
|
|
|
|
crd__qadc02
|
|
|
x(24)
|
|
|
|
crd_alarm_date
|
Alarm Date
|
|
99/99/99
|
|
|
|
crd_alarm_time
|
Alarm Time
|
|
99:99
|
|
|
|
crd_ca_nbr
|
Call ID
|
|
x(8)
|
|
|
|
crd_category
|
Category
|
|
x(8)
|
|
|
|
crd_close
|
Alarm Closed
|
|
yes/no
|
|
|
|
crd_comments
|
Comments
|
|
x(76)
|
|
|
|
crd_desc
|
Description
|
|
x(76)
|
|
|
|
crd_domain
|
Domain
|
|
x(8)
|
|
|
|
crd_id
|
Reminder ID
|
|
>>>>>>>9
|
|
|
|
crd_itm_line
|
Line
|
|
>>9
|
|
|
|
crd_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
crd_mod_userid
|
User ID
|
|
x(8)
|
|
|
|
crd_status
|
Status
|
|
x(1)
|
|
|
|
crd_user1
|
User Field Character 1
|
|
x(24)
|
|
|
|
crd_user2
|
User Field Character 2
|
|
x(24)
|
|
|
|
crd_userid
|
Entered by
|
|
x(8)
|
|
|
|
oid_crd_det
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
crd_nbrid
|
yes
|
crd_domain
|
yes
|
no
|
|
|
|
|
crd_category
|
yes
|
no
|
|
|
|
|
crd_ca_nbr
|
yes
|
no
|
|
|
|
|
crd_itm_line
|
yes
|
no
|
|
|
|
|
crd_id
|
yes
|
no
|
|
|
oid_crd_det
|
yes
|
oid_crd_det
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
BLWIGroup_ID
|
BLWI Group
|
|
-99999999999
|
|
|
|
BusinessRelation_ID
|
Name
|
|
-99999999999
|
|
|
|
CnControlGLProfile_ID
|
Control GL Profile (Credit Note)
|
|
-99999999999
|
|
|
|
Creditor_ID
|
Record ID
|
|
-99999999999
|
|
|
|
CreditorBirthCity
|
Birth City
|
|
x(20)
|
|
|
|
CreditorBirthDate
|
Birth Date
|
|
99/99/9999
|
|
|
|
CreditorCocNumber
|
Chamber of Commerce Number
|
|
x(8)
|
|
|
|
CreditorCode
|
Supplier Code
|
Supplier
|
x(8)
|
|
|
|
CreditorCommentNote
|
Comment Note
|
|
x(2000)
|
|
|
|
CreditorDBNumber
|
Credit Agency Reference
|
|
x(16)
|
|
|
|
CreditorDebtorNumber
|
External Customer Number
|
|
x(10)
|
|
|
|
CreditorForeignFiscalCode
|
Foreign Fiscal Code
|
|
x(18)
|
|
|
|
CreditorIsActive
|
Active
|
|
yes/no
|
|
|
|
CreditorIsBearBankCharge
|
Pays Bank Charge
|
|
yes/no
|
|
|
|
CreditorIsIndividualPaymnt
|
Individual Payments
|
|
yes/no
|
|
|
|
CreditorIsReportedIN
|
Reported (IN)
|
|
yes/no
|
|
|
|
CreditorIsSendRemittance
|
Send Remittance
|
|
yes/no
|
|
|
|
CreditorIsTaxable
|
Taxable Supplier
|
|
yes/no
|
|
|
|
CreditorIsTaxConfirmed
|
Tax Confirmed
|
|
yes/no
|
|
|
|
CreditorIsTaxInCity
|
Tax in City
|
|
yes/no
|
|
|
|
CreditorIsTaxIncluded
|
Tax Is Included
|
|
yes/no
|
|
|
|
CreditorIsTaxReport
|
Tax Report
|
|
yes/no
|
|
|
|
CreditorIsWHT
|
Withholding Tax
|
|
yes/no
|
|
|
|
CreditorTaxDeclaration
|
Tax Declaration
|
|
->,>>>,>>9
|
|
|
|
CreditorTaxIDFederal
|
Federal Tax
|
|
x(18)
|
|
|
|
CreditorTaxIDFiscalCode
|
Tax ID / Fiscal Code
|
|
x(18)
|
|
|
|
CreditorTaxIDMisc1
|
Miscellaneous Tax 1
|
|
x(18)
|
|
|
|
CreditorTaxIDMisc2
|
Miscellaneous Tax 2
|
|
x(18)
|
|
|
|
CreditorTaxIDMisc3
|
Miscellaneous Tax 3
|
|
x(18)
|
|
|
|
CreditorTaxIDState
|
State Tax
|
|
x(18)
|
|
|
|
CreditorTIDNotice
|
TID Notice
|
|
x(1)
|
|
|
|
CreditorType_ID
|
Supplier Type
|
|
-99999999999
|
|
|
|
Currency_ID
|
Currency Code
|
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
|
|
|
|
CustomDate5
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate6
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate7
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate8
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate9
|
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
|
|
|
CustomDecimal5
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal6
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal7
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal8
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal9
|
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)
|
|
|
|
CustomShort15
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort16
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort17
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort18
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort19
|
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)
|
|
|
|
DeliveryCond_ID
|
Link to DeliveryCond
|
|
-99999999999
|
|
|
|
DivisionProfile_ID
|
Sub-Account Profile
|
|
-99999999999
|
|
|
|
FinChgGLProfile_ID
|
Finance Charge GL Profile ID
|
|
-99999999999
|
|
|
|
InvControlGLProfile_ID
|
Control GL Profile (Invoice)
|
|
-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)
|
|
|
|
NormalPaymentCondition_ID
|
Credit Terms
|
|
-99999999999
|
|
|
|
PaymentGroup_ID
|
Payment Group
|
|
-99999999999
|
|
|
|
PrePayControlGLProfile_ID
|
Control GL Profile (Pre-payment)
|
|
-99999999999
|
|
|
|
PurchaseCode_ID
|
Link to PurchaseCode
|
|
-99999999999
|
|
|
|
PurchaseGLProfile_ID
|
Purchases Account GL Profile
|
|
-99999999999
|
|
|
|
PurchaseType_ID
|
Purchase Type
|
|
-99999999999
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
Reason_ID
|
Invoice Status Code
|
|
-99999999999
|
|
|
|
SharedSet_ID
|
Link to SharedSet
|
|
-99999999999
|
|
|
|
TxclTaxCls
|
Tax Class
|
|
x(3)
|
|
|
|
TxuTaxUsage
|
Tax Usage
|
|
x(8)
|
|
|
|
TxzTaxZone
|
Tax Zone
|
|
x(16)
|
|
|
|
VatDeliveryType
|
Tax Nature
|
|
x(20)
|
|
|
|
VatPercentageLevel
|
Tax Level
|
|
x(20)
|
|
|
|
WHTCertFormat_ID
|
Link to Withholding Tax Certificate Format
|
|
-99999999999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
BankChrgIdx
|
no
|
CreditorIsBearBankCharge
|
yes
|
no
|
|
|
CnGLControl
|
no
|
CnControlGLProfile_ID
|
yes
|
no
|
|
|
Code
|
no
|
CreditorCode
|
yes
|
no
|
|
|
CreditorTax
|
no
|
CreditorTaxIDFederal
|
yes
|
no
|
|
|
|
|
CreditorIsTaxReport
|
yes
|
no
|
|
|
CreditorType
|
no
|
CreditorType_ID
|
yes
|
no
|
|
|
CurrIdx
|
no
|
Currency_ID
|
yes
|
no
|
|
|
DelCondIdx
|
no
|
DeliveryCond_ID
|
yes
|
no
|
|
|
DivIdx
|
no
|
DivisionProfile_ID
|
yes
|
no
|
|
|
FinChgIdx
|
no
|
FinChgGLProfile_ID
|
yes
|
no
|
|
|
InvGLControl
|
no
|
InvControlGLProfile_ID
|
yes
|
no
|
|
|
IsWHT
|
no
|
CreditorIsWHT
|
yes
|
no
|
|
|
LastModIdx
|
no
|
LastModifiedDate
|
yes
|
no
|
|
|
NormPayCondIdx
|
no
|
NormalPaymentCondition_ID
|
yes
|
no
|
|
|
PaymentGroup
|
no
|
PaymentGroup_ID
|
yes
|
no
|
|
|
PrePayProfile
|
no
|
PrePayControlGLProfile_ID
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
Creditor_ID
|
yes
|
no
|
|
|
PurchCodeIdx
|
no
|
PurchaseCode_ID
|
yes
|
no
|
|
|
PurchGLIdx
|
no
|
PurchaseGLProfile_ID
|
yes
|
no
|
|
|
PurchTypeIdx
|
no
|
PurchaseType_ID
|
yes
|
no
|
|
|
ReasonIdx
|
no
|
Reason_ID
|
yes
|
no
|
|
|
Relation
|
no
|
BusinessRelation_ID
|
yes
|
no
|
|
|
SharedSet
|
no
|
SharedSet_ID
|
yes
|
no
|
|
|
SharedSetAndCode
|
yes
|
SharedSet_ID
|
yes
|
no
|
|
|
|
|
CreditorCode
|
yes
|
no
|
|
|
ViewIndex
|
no
|
SharedSet_ID
|
yes
|
no
|
|
|
|
|
CreditorIsActive
|
yes
|
no
|
|
|
|
|
CreditorCode
|
yes
|
no
|
|
|
WHTCert
|
no
|
WHTCertFormat_ID
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
Creditor_ID
|
Link to Creditor
|
|
-99999999999
|
|
|
|
CreditorSafDefault_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
|
|
|
|
Saf_ID
|
SAF Code
|
|
-99999999999
|
|
|
|
SafConcept_ID
|
SAF Concept Code
|
|
-99999999999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
Creditor
|
no
|
Creditor_ID
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
CreditorSafDefault_ID
|
yes
|
no
|
|
|
Saf
|
no
|
Saf_ID
|
yes
|
no
|
|
|
SafConcept
|
no
|
SafConcept_ID
|
yes
|
no
|
|
|
UniqueIdx
|
yes
|
Creditor_ID
|
yes
|
no
|
|
|
|
|
SafConcept_ID
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
CreditorType_ID
|
Record ID
|
|
-99999999999
|
|
|
|
CreditorTypeCode
|
Code
|
|
x(4)
|
|
|
|
CreditorTypeDescription
|
Description
|
|
x(40)
|
|
|
|
CreditorTypeIsActive
|
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
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
IsActive
|
no
|
CreditorTypeIsActive
|
yes
|
no
|
|
|
LastModIdx
|
no
|
LastModifiedDate
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
CreditorType_ID
|
yes
|
no
|
|
|
UniqueIdx
|
yes
|
CreditorTypeCode
|
yes
|
no
|
|
|
ViewIndex
|
no
|
CreditorTypeIsActive
|
yes
|
no
|
|
|
|
|
CreditorTypeCode
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
Creditor_ID
|
Link to Creditor
|
|
-99999999999
|
|
|
|
CreditorVat_ID
|
Record ID
|
|
-99999999999
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
Vat_ID
|
Link to Vat
|
|
-99999999999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
Creditor
|
no
|
Creditor_ID
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
CreditorVat_ID
|
yes
|
no
|
|
|
Vat
|
no
|
Vat_ID
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
cref__qadc01
|
|
|
x(8)
|
|
|
|
cref_cset
|
Cost Set
|
|
x(8)
|
|
|
|
cref_domain
|
Domain
|
|
x(8)
|
|
|
|
cref_item1
|
Item 1
|
|
x(18)
|
|
|
|
cref_item2
|
Item 2
|
|
x(18)
|
|
|
|
cref_item3
|
Item 3
|
|
x(18)
|
|
|
|
cref_item4
|
Item 4
|
|
x(18)
|
|
|
|
cref_qad_date1
|
Qad Date 1
|
|
99/99/99
|
|
|
|
cref_qad_date2
|
Qad Date 2
|
|
99/99/99
|
|
|
|
cref_qad_dec01
|
Qad Decimal 1
|
|
->>,>>9.99
|
10
|
|
|
cref_qad_dec02
|
Qad Decimal 2
|
|
->>,>>9.99
|
10
|
|
|
cref_qad_log01
|
Qad Field 1
|
|
yes/no
|
|
|
|
cref_qad_log02
|
Qad Logical 2
|
|
yes/no
|
|
|
|
cref_ref_type
|
Reference Type
|
|
x(8)
|
|
|
|
cref_system
|
System
|
|
yes/no
|
|
|
|
cref_user1
|
Ufld1
|
|
x(8)
|
|
|
|
cref_user2
|
Ufld2
|
|
x(8)
|
|
|
|
oid_cref_mstr
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
cref_item12
|
yes
|
cref_domain
|
yes
|
no
|
|
|
|
|
cref_ref_type
|
yes
|
no
|
|
|
|
|
cref_item1
|
yes
|
no
|
|
|
|
|
cref_item2
|
yes
|
no
|
|
|
oid_cref_mstr
|
yes
|
oid_cref_mstr
|
yes
|
no
|