|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
CMask_ID
|
Record ID
|
|
-99999999999
|
|
|
|
CMaskCode
|
Closing Mask
|
|
x(20)
|
|
|
|
CMaskDescription
|
Description
|
Closing Mask Description
|
x(40)
|
|
|
|
CMaskIsActive
|
Active
|
|
yes/no
|
|
|
|
CMaskType
|
Type
|
Seq
|
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
|
|
|
|
SharedSet_ID
|
Link to SharedSet
|
|
-99999999999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
IsActIdx
|
no
|
CMaskIsActive
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
CMask_ID
|
yes
|
no
|
|
|
SSidx
|
no
|
SharedSet_ID
|
yes
|
no
|
|
|
UniqIdx
|
yes
|
CMaskCode
|
yes
|
no
|
|
|
|
|
SharedSet_ID
|
yes
|
no
|
|
|
ViewIdx
|
no
|
CMaskIsActive
|
yes
|
no
|
|
|
|
|
CMaskCode
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
CMask_ID
|
Link to CMask
|
|
-99999999999
|
|
|
|
CMaskJournal_ID
|
Record ID
|
|
-99999999999
|
|
|
|
CMaskJournalIsAllowCC
|
Allow postings in Stat Curr
|
|
yes/no
|
|
|
|
CMaskJournalIsAllowLC
|
Allow postings in Base Curr
|
|
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)
|
|
|
|
Journal_ID
|
Link to Journal
|
|
-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
|
|
|
CMaskIdx
|
no
|
CMask_ID
|
yes
|
no
|
|
|
JrnlIdx
|
no
|
Journal_ID
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
CMaskJournal_ID
|
yes
|
no
|
|
|
UniqIdx
|
yes
|
Journal_ID
|
yes
|
no
|
|
|
|
|
CMask_ID
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
CMask_ID
|
Link to CMask
|
|
-99999999999
|
|
|
|
CMaskJrnlGroup_ID
|
Record ID
|
|
-99999999999
|
|
|
|
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)
|
|
|
|
JournalGroup_ID
|
Link to JournalGroup
|
|
-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
|
|
|
CMaskIdx
|
no
|
CMask_ID
|
yes
|
no
|
|
|
JrnlGrpIdx
|
no
|
JournalGroup_ID
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
CMaskJrnlGroup_ID
|
yes
|
no
|
|
|
UniqIdx
|
yes
|
JournalGroup_ID
|
yes
|
no
|
|
|
|
|
CMask_ID
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
cmc__qadc01
|
|
|
x(8)
|
|
|
|
cmc__qadi01
|
|
|
->>>>>>>9
|
|
|
|
cmc_domain
|
Domain
|
|
x(8)
|
|
|
|
cmc_nbr
|
Next Customer
|
|
99999999
|
|
|
|
cmc_user1
|
Ufld1
|
|
x(8)
|
|
|
|
cmc_user2
|
Ufld2
|
|
x(8)
|
|
|
|
oid_cmc_ctrl
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
cmc_index1
|
yes
|
cmc_domain
|
yes
|
no
|
|
|
oid_cmc_ctrl
|
yes
|
oid_cmc_ctrl
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
cmd__qadc01
|
|
|
x(8)
|
|
|
|
cmd_domain
|
Domain
|
|
x(8)
|
|
|
|
cmd_field
|
Field
|
|
x(24)
|
|
|
|
cmd_file
|
File Name
|
File
|
x(32)
|
|
|
|
cmd_key_val
|
Index Key Values
|
Values
|
x(32)
|
|
|
|
cmd_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
cmd_mod_userid
|
User ID
|
|
x(16)
|
|
|
|
cmd_ref_date
|
Reference Date
|
|
99/99/99
|
|
|
|
cmd_ref_time
|
Reference Time
|
|
>>>>>>9
|
|
|
|
cmd_trans_nbr
|
Transaction Number
|
Trans
|
>>>>>>>>9
|
|
|
|
cmd_user1
|
Ufld1
|
|
x(8)
|
|
|
|
cmd_user2
|
Ufld2
|
|
x(8)
|
|
|
|
cmd_val
|
Field Value
|
Value
|
x(18)
|
|
|
|
oid_cmd_det
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
cmd_trans_nbr
|
yes
|
cmd_domain
|
yes
|
no
|
|
|
|
|
cmd_trans_nbr
|
yes
|
no
|
|
|
|
|
cmd_file
|
yes
|
no
|
|
|
|
|
cmd_field
|
yes
|
no
|
|
|
|
|
cmd_key_val
|
yes
|
no
|
|
|
oid_cmd_det
|
yes
|
oid_cmd_det
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
cmf__qadc01
|
|
|
x(8)
|
|
|
|
cmf_doc_ref
|
Doc Ref
|
Ref
|
x(12)
|
|
|
|
cmf_doc_type
|
Doc Type
|
Type
|
x(3)
|
|
|
|
cmf_domain
|
Domain
|
|
x(8)
|
|
|
|
cmf_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
cmf_mod_userid
|
User ID
|
|
x(16)
|
|
|
|
cmf_ref_date
|
Reference Date
|
|
99/99/99
|
|
|
|
cmf_ref_time
|
Reference Time
|
|
>>>>>>9
|
|
|
|
cmf_so_po
|
Purchase Order
|
|
x(8)
|
|
|
|
cmf_status
|
Status
|
St
|
x
|
|
|
|
cmf_trans_nbr
|
Transaction Number
|
Trans
|
>>>>>>>9
|
|
|
|
cmf_user1
|
Ufld1
|
|
x(8)
|
|
|
|
cmf_user2
|
Ufld2
|
|
x(8)
|
|
|
|
oid_cmf_mstr
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
cmf_doc
|
yes
|
cmf_domain
|
yes
|
no
|
|
|
|
|
cmf_doc_type
|
yes
|
no
|
|
|
|
|
cmf_doc_ref
|
yes
|
no
|
|
|
|
|
cmf_status
|
yes
|
no
|
|
∗
|
cmf_trans_nbr
|
yes
|
cmf_domain
|
yes
|
no
|
|
|
|
|
cmf_trans_nbr
|
yes
|
no
|
|
|
oid_cmf_mstr
|
yes
|
oid_cmf_mstr
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
cmh__chr01
|
|
|
x(8)
|
|
|
|
cmh__chr02
|
|
|
x(8)
|
|
|
|
cmh__chr03
|
|
|
x(8)
|
|
|
|
cmh__chr04
|
|
|
x(8)
|
|
|
|
cmh__chr05
|
|
|
x(8)
|
|
|
|
cmh__chr06
|
|
|
x(8)
|
|
|
|
cmh__chr07
|
|
|
x(8)
|
|
|
|
cmh__chr08
|
|
|
x(8)
|
|
|
|
cmh__chr09
|
|
|
x(8)
|
|
|
|
cmh__chr10
|
|
|
x(8)
|
|
|
|
cmh__dec01
|
|
|
>>>,>>>,>>9.99
|
10
|
|
|
cmh__dec02
|
|
|
>>>,>>>,>>9.99
|
10
|
|
|
cmh__dte01
|
|
|
99/99/99
|
|
|
|
cmh__dte02
|
|
|
99/99/99
|
|
|
|
cmh__log01
|
|
|
yes/no
|
|
|
|
cmh__log02
|
|
|
yes/no
|
|
|
|
cmh_cust
|
Customer
|
|
x(8)
|
|
|
|
cmh_domain
|
Domain
|
|
x(8)
|
|
|
|
cmh_tot_cost
|
YTD Cost
|
|
->,>>>,>>>,>>9
|
10
|
|
|
cmh_tot_sale
|
YTD Sales
|
|
->,>>>,>>>,>>9
|
10
|
|
|
cmh_type
|
Ship Type
|
T
|
x(1)
|
|
|
|
cmh_user1
|
Ufld1
|
|
x(8)
|
|
|
|
cmh_user2
|
Ufld2
|
|
x(8)
|
|
|
|
cmh_year
|
Year
|
|
9999
|
|
|
|
oid_cmh_hist
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
cmh_custyear
|
yes
|
cmh_domain
|
yes
|
no
|
|
|
|
|
cmh_cust
|
yes
|
no
|
|
|
|
|
cmh_year
|
yes
|
no
|
|
∗
|
cmh_yearcust
|
yes
|
cmh_domain
|
yes
|
no
|
|
|
|
|
cmh_year
|
yes
|
no
|
|
|
|
|
cmh_cust
|
yes
|
no
|
|
|
oid_cmh_hist
|
yes
|
oid_cmh_hist
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
cmt__qadc01
|
|
|
x(8)
|
|
|
|
cmt_cmmt[15]
|
Comment Data
|
|
x(76)
|
|
|
|
cmt_domain
|
Domain
|
|
x(8)
|
|
|
|
cmt_expire
|
Expire
|
|
99/99/99
|
|
|
|
cmt_indx
|
Index
|
|
>>>>>>>9
|
|
|
|
cmt_lang
|
Language
|
|
x(2)
|
|
|
|
cmt_print
|
Print Control
|
|
x(24)
|
|
|
|
cmt_ref
|
Reference
|
|
x(40)
|
|
|
|
cmt_seq
|
Page
|
|
>9
|
|
|
|
cmt_start
|
Start
|
|
99/99/99
|
|
|
|
cmt_type
|
Type
|
T
|
x(2)
|
|
|
|
cmt_user1
|
Ufld1
|
|
x(8)
|
|
|
|
cmt_user2
|
Ufld2
|
|
x(8)
|
|
|
|
oid_cmt_det
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
cmt_ref
|
yes
|
cmt_domain
|
yes
|
no
|
|
|
|
|
cmt_indx
|
yes
|
no
|
|
|
|
|
cmt_seq
|
yes
|
no
|
|
|
oid_cmt_det
|
yes
|
oid_cmt_det
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
cm__chr01
|
|
|
x(8)
|
|
|
|
cm__chr02
|
|
|
x(8)
|
|
|
|
cm__chr03
|
|
|
x(8)
|
|
|
|
cm__chr04
|
|
|
x(8)
|
|
|
|
cm__chr05
|
|
|
x(8)
|
|
|
|
cm__chr06
|
|
|
x(8)
|
|
|
|
cm__chr07
|
|
|
x(8)
|
|
|
|
cm__chr08
|
|
|
x(8)
|
|
|
|
cm__chr09
|
|
|
x(8)
|
|
|
|
cm__chr10
|
|
|
x(8)
|
|
|
|
cm__dec01
|
|
|
>>>,>>>,>>9.99
|
10
|
|
|
cm__dec02
|
|
|
>>>,>>>,>>9.99
|
10
|
|
|
cm__dte01
|
|
|
99/99/99
|
|
|
|
cm__dte02
|
|
|
99/99/99
|
|
|
|
cm__log01
|
|
|
yes/no
|
|
|
|
cm__qad04[3]
|
|
|
->9.99<%
|
10
|
|
|
cm__qad06
|
|
|
yes/no
|
|
|
|
cm__qadc01
|
|
|
x(8)
|
|
|
|
cm__qadc02
|
|
|
x(8)
|
|
|
|
cm__qadc03
|
|
|
x(8)
|
|
|
|
cm__qadc04
|
|
|
x(8)
|
|
|
|
cm__qadc05
|
|
|
x(8)
|
|
|
|
cm__qadc06
|
|
|
x(8)
|
|
|
|
cm__qadc07
|
|
|
x(8)
|
|
|
|
cm__qadd01
|
|
|
->>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
cm__qadd02
|
|
|
->>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
cm__qadi01
|
|
|
->,>>>,>>9
|
|
|
|
cm__qadi02
|
|
|
->,>>>,>>9
|
|
|
|
cm__qadi03
|
|
|
>>>>>>9
|
|
|
|
cm__qadi04
|
|
|
>>>>>>9
|
|
|
|
cm__qadl01
|
|
|
yes/no
|
|
|
|
cm__qadl02
|
|
|
yes/no
|
|
|
|
cm__qadl03
|
|
|
yes/no
|
|
|
|
cm__qadl04
|
|
|
yes/no
|
|
|
|
cm__qadt01
|
|
|
99/99/99
|
|
|
|
cm__qadt02
|
|
|
99/99/99
|
|
|
|
cm_active
|
Active
|
|
yes/no
|
|
|
|
cm_addr
|
Customer
|
|
x(8)
|
|
|
|
cm_ar_acct
|
AR Acct
|
|
x(8)
|
|
|
|
cm_ar_cc
|
AR Cost Ctr
|
CC
|
x(4)
|
|
|
|
cm_ar_sub
|
AR Sub-Acct
|
Sub-Acct
|
x(8)
|
|
|
|
cm_avg_pay
|
Avg Days Paid Late
|
Avg!Days Late
|
->>,>>9
|
|
|
|
cm_balance
|
Balance
|
|
->>,>>>,>>>,>>9.99
|
10
|
|
|
cm_bank
|
Bank
|
Bk
|
x(2)
|
|
|
|
cm_bill
|
Bill-To
|
|
x(8)
|
|
|
|
cm_btb_cr
|
EMT Credit Flow
|
|
yes/no
|
|
|
|
cm_btb_mthd
|
Confirmed EMT SO
|
|
yes/no
|
|
|
|
cm_btb_type
|
EMT Type
|
|
xx
|
|
|
|
cm_class
|
Class
|
|
x(8)
|
|
|
|
cm_coll_mthd
|
Collection Method
|
M
|
x(1)
|
|
|
|
cm_conrep_logic
|
Consume/Replace Logic
|
|
x(1)
|
|
|
|
cm_cons_inv
|
Consolidate Invoices
|
|
yes/no
|
|
|
|
cm_cr_hold
|
Credit Hold
|
Hold
|
yes/no
|
|
|
|
cm_cr_limit
|
Credit Limit
|
Cr Limit
|
>>>,>>>,>>>,>>9
|
0
|
|
|
cm_cr_rating
|
Credit Rating
|
Cr Rate
|
x(8)
|
|
|
|
cm_cr_review
|
Last Credit Review
|
Cr Limit!Review
|
99/99/99
|
|
|
|
cm_cr_terms
|
Terms
|
|
x(8)
|
|
|
|
cm_cr_update
|
Last Credit Update
|
Cr Limit!Update
|
99/99/99
|
|
|
|
cm_curr
|
Currency
|
Cur
|
x(3)
|
|
|
|
cm_cust_itm_reqd
|
Customer Item Required
|
|
yes/no
|
|
|
|
cm_cust_self_bill
|
Self-Billing Customer
|
|
yes/no
|
|
|
|
cm_datacomplete
|
Data Complete
|
|
yes/no
|
|
|
|
cm_daybookset
|
Daybook Set
|
Dybk Set
|
x(8)
|
|
|
|
cm_db
|
DB Number
|
|
x(12)
|
|
|
|
cm_disc_comb
|
Discount Combination Type
|
|
x(24)
|
|
|
|
cm_disc_pct
|
Disc %
|
|
->>9.99%
|
10
|
|
|
cm_domain
|
Domain
|
|
x(8)
|
|
|
|
cm_drft_apv
|
Approved
|
Apv
|
yes/no
|
|
|
|
cm_drft_bal
|
Draft Balance
|
|
->>,>>>,>>>,>>9.99
|
10
|
|
|
cm_drft_disc
|
Discountable
|
Dsc
|
yes/no
|
|
|
|
cm_drft_max
|
Max Draft Amt
|
|
->>>>,>>>,>>9.99
|
10
|
|
|
cm_drft_min
|
Min Draft Amt
|
|
->>>>,>>>,>>9.99
|
10
|
|
|
cm_dun
|
Dun Letter
|
Dun
|
yes/no
|
|
|
|
cm_ex_ratetype
|
Rate Type
|
|
x(8)
|
|
|
|
cm_fin
|
Finance Chg
|
Fin
|
yes/no
|
|
|
|
cm_fin_date
|
Last Finance Charge Date
|
Last Finance!Charge Date
|
99/99/99
|
|
|
|
cm_fix_pr
|
Fixed Price
|
|
yes/no
|
|
|
|
cm_fr_list
|
Freight List
|
Frt List
|
x(8)
|
|
|
|
cm_fr_min_wt
|
Min Frt Wt
|
|
->>>,>>>,>>9
|
0
|
|
|
cm_fr_terms
|
Freight Terms
|
Fr Terms
|
x(8)
|
|
|
|
cm_fst_id
|
FST ID
|
|
x(18)
|
|
|
|
cm_gst_id
|
Tax ID - Federal
|
|
x(18)
|
|
|
|
cm_high_cr
|
High Credit
|
|
->>,>>>,>>>,>>9
|
10
|
|
|
cm_high_date
|
High Date
|
|
99/99/99
|
|
|
|
cm_internal
|
Internal
|
|
yes/no
|
|
|
|
cm_invoices
|
Total Invoices
|
Invoices
|
>,>>>,>>9
|
|
|
|
cm_lang
|
Language
|
|
x(2)
|
|
|
|
cm_lc_bal
|
LC Balance
|
|
->>,>>>,>>>,>>9.99
|
10
|
|
|
cm_misc1_id
|
Tax ID - Misc 1
|
|
x(18)
|
|
|
|
cm_misc2_id
|
Tax ID - Misc 2
|
|
x(18)
|
|
|
|
cm_misc3_id
|
Tax ID - Misc 3
|
|
x(18)
|
|
|
|
cm_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
cm_partial
|
Partial OK
|
Partial
|
yes/no
|
|
|
|
cm_pay_date
|
Last Payment
|
Last Pay
|
99/99/99
|
|
|
|
cm_pay_method
|
Payment Method
|
PM
|
x(2)
|
|
|
|
cm_po_reqd
|
PO Required
|
PO Reqd
|
yes/no
|
|
|
|
cm_pr_list
|
Disc Tbl
|
|
x(8)
|
|
|
|
cm_pr_list2
|
Price Tbl
|
Pr Tbl
|
x(8)
|
|
|
|
cm_promo
|
Promotion Group
|
|
x(10)
|
|
|
|
cm_pst
|
PST Taxable
|
|
yes/no
|
|
|
|
cm_pst_id
|
PST ID
|
|
x(18)
|
|
|
|
cm_region
|
Region
|
|
x(4)
|
|
|
|
cm_resale
|
Resale
|
|
x(20)
|
|
|
|
cm_rmks
|
Remarks
|
|
x(40)
|
|
|
|
cm_rss_cal_option
|
RSS Calendar Option
|
|
>>9
|
|
|
|
cm_sale_date
|
Last Sale
|
|
99/99/99
|
|
|
|
cm_sb_auto_payment
|
Self-Bill Automatic Payment
|
|
yes/no
|
|
|
|
cm_scurr
|
Second Cur
|
2nd Cur
|
x(3)
|
|
|
|
cm_serv_terms
|
Service Terms
|
|
X(8)
|
|
|
|
cm_ship
|
Ship-To
|
|
x(8)
|
|
|
|
cm_ship_lt
|
Customer Shipping LT
|
Cust Ship LT
|
>>9
|
|
|
|
cm_shipvia
|
Ship Via
|
|
x(20)
|
|
|
|
cm_sic
|
SIC
|
|
x(4)
|
|
|
|
cm_site
|
Site
|
|
x(8)
|
|
|
|
cm_slspsn[4]
|
Salesperson
|
Salespsn
|
x(8)
|
|
|
|
cm_sort
|
Sort Name
|
|
x(28)
|
|
|
|
cm_stmt
|
Statement
|
Stmt
|
yes/no
|
|
|
|
cm_stmt_cyc
|
Stmt Cycle
|
Cycle
|
x(4)
|
|
|
|
cm_submit_prop
|
Allow Submission Proposed Drft
|
|
yes/no
|
|
|
|
cm_svc_list
|
Service Price List
|
|
x(8)
|
|
|
|
cm_tax_in
|
Tax In
|
|
yes/no
|
|
|
|
cm_tax_in_city
|
In City
|
|
yes/no
|
|
|
|
cm_tax_usage
|
Tax Usage
|
Tax Use
|
x(8)
|
|
|
|
cm_tax_zone
|
Tax Zone
|
|
x(16)
|
|
|
|
cm_taxable
|
Taxable
|
Tax
|
yes/no
|
|
|
|
cm_taxc
|
Tax Class
|
TxC
|
x(3)
|
|
|
|
cm_type
|
Type
|
|
x(4)
|
|
|
|
cm_user1
|
Ufld1
|
|
x(8)
|
|
|
|
cm_user2
|
Ufld2
|
|
x(8)
|
|
|
|
cm_userid
|
User ID
|
|
x(8)
|
|
|
|
cm_xslspsn
|
Slspsn[1]
|
|
x(8)
|
|
|
|
cm_xslspsn2
|
Slspsn[2]
|
|
x(8)
|
|
|
|
oid_btr_mstr
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
oid_cm_mstr
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
cm_active
|
no
|
cm_domain
|
yes
|
no
|
|
|
|
|
cm_active
|
yes
|
no
|
|
∗
|
cm_addr
|
yes
|
cm_domain
|
yes
|
no
|
|
|
|
|
cm_addr
|
yes
|
no
|
|
|
cm_datacomplete
|
no
|
cm_domain
|
yes
|
no
|
|
|
|
|
cm_datacomplete
|
yes
|
no
|
|
|
cm_sort
|
no
|
cm_domain
|
yes
|
no
|
|
|
|
|
cm_sort
|
yes
|
no
|
|
|
oid_cm_mstr
|
yes
|
oid_cm_mstr
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
cncix__qadc01
|
|
|
x(24)
|
|
|
|
cncix__qadc02
|
|
|
x(24)
|
|
|
|
cncix_aged_date
|
Aged Date
|
Aged
|
99/99/99
|
|
|
|
cncix_asn_shipper
|
Shipper
|
|
x(20)
|
|
|
|
cncix_auth
|
Authorization
|
|
x(24)
|
|
|
|
cncix_curr
|
Currency
|
Cur
|
x(3)
|
|
|
|
cncix_current_loc
|
Location
|
|
x(8)
|
|
|
|
cncix_cust
|
Sold-To
|
|
x(8)
|
|
|
|
cncix_cust_dock
|
Customer Dock
|
|
x(30)
|
|
|
|
cncix_cust_job
|
Customer Job
|
|
x(30)
|
|
|
|
cncix_cust_ref
|
Customer Reference
|
|
x(30)
|
|
|
|
cncix_cust_seq
|
Customer Sequence
|
|
x(30)
|
|
|
|
cncix_custpart
|
Customer Item
|
|
x(30)
|
|
|
|
cncix_domain
|
Domain
|
|
x(8)
|
|
|
|
cncix_int_consignment
|
Internal Consignment
|
|
yes/no
|
|
|
|
cncix_intransit
|
In-Transit
|
|
yes/no
|
|
|
|
cncix_line_feed
|
Line Feed
|
|
x(30)
|
|
|
|
cncix_lotser
|
Lot/Serial
|
|
x(18)
|
|
|
|
cncix_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
cncix_mod_userid
|
User ID
|
|
x(8)
|
|
|
|
cncix_modelyr
|
Model Year
|
|
x(4)
|
|
|
|
cncix_orig_aged_date
|
Original Aged Date
|
Original!Aged
|
99/99/99
|
|
|
|
cncix_part
|
Item
|
|
x(18)
|
|
|
|
cncix_pkey
|
Primary Key
|
|
>>>>>>>>>
|
|
|
|
cncix_po
|
Customer PO
|
|
x(22)
|
|
|
|
cncix_price
|
Price
|
|
->>,>>>,>>9.99<<<
|
10
|
|
|
cncix_qty_ship
|
Ship Qty
|
|
->>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
cncix_qty_stock
|
Qty In-Stock
|
Qty!In-Stock
|
->>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
cncix_ref
|
Reference
|
Ref
|
x(8)
|
|
|
|
cncix_selfbill
|
Self-Bill
|
|
yes/no
|
|
|
|
cncix_ship_date
|
Ship Date
|
|
99/99/99
|
|
|
|
cncix_ship_trnbr
|
Trans Nbr
|
|
>>>>>>>>>>
|
|
|
|
cncix_ship_value
|
Ship Value
|
|
->>>>,>>>,>>9.99<
|
10
|
|
|
cncix_shipto
|
Ship-To
|
|
x(8)
|
|
|
|
cncix_site
|
Site
|
|
x(8)
|
|
|
|
cncix_so_nbr
|
Sales Order
|
Order
|
x(8)
|
|
|
|
cncix_sod_line
|
Line
|
|
>>>9
|
|
|
|
cncix_stock_um
|
Stock UM
|
UM
|
x(2)
|
|
|
|
cncix_user1
|
User Field Character 1
|
|
x(24)
|
|
|
|
cncix_user2
|
User Field Character 2
|
|
x(24)
|
|
|
|
oid_cncix_mstr
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
cncix_loc_part
|
no
|
cncix_domain
|
yes
|
no
|
|
|
|
|
cncix_site
|
yes
|
no
|
|
|
|
|
cncix_current_loc
|
yes
|
no
|
|
|
|
|
cncix_part
|
yes
|
no
|
|
|
|
|
cncix_ship_date
|
yes
|
no
|
|
|
|
|
cncix_lotser
|
yes
|
no
|
|
|
|
|
cncix_ref
|
yes
|
no
|
|
|
cncix_order_line
|
no
|
cncix_domain
|
yes
|
no
|
|
|
|
|
cncix_so_nbr
|
yes
|
no
|
|
|
|
|
cncix_sod_line
|
yes
|
no
|
|
|
|
|
cncix_aged_date
|
yes
|
no
|
|
∗
|
cncix_primary_key
|
yes
|
cncix_domain
|
yes
|
no
|
|
|
|
|
cncix_pkey
|
yes
|
no
|
|
|
cncix_shipper
|
no
|
cncix_domain
|
yes
|
no
|
|
|
|
|
cncix_asn_shipper
|
yes
|
no
|
|
|
cncix_site_cust
|
no
|
cncix_domain
|
yes
|
no
|
|
|
|
|
cncix_site
|
yes
|
no
|
|
|
|
|
cncix_cust
|
yes
|
no
|
|
|
|
|
cncix_shipto
|
yes
|
no
|
|
|
|
|
cncix_so_nbr
|
yes
|
no
|
|
|
|
|
cncix_part
|
yes
|
no
|
|
|
|
|
cncix_po
|
yes
|
no
|
|
|
|
|
cncix_modelyr
|
yes
|
no
|
|
|
|
|
cncix_current_loc
|
yes
|
no
|
|
|
|
|
cncix_lotser
|
yes
|
no
|
|
|
|
|
cncix_ref
|
yes
|
no
|
|
|
|
|
cncix_auth
|
yes
|
no
|
|
|
cncix_site_part
|
no
|
cncix_domain
|
yes
|
no
|
|
|
|
|
cncix_site
|
yes
|
no
|
|
|
|
|
cncix_part
|
yes
|
no
|
|
|
|
|
cncix_cust
|
yes
|
no
|
|
|
|
|
cncix_shipto
|
yes
|
no
|
|
|
|
|
cncix_so_nbr
|
yes
|
no
|
|
|
|
|
cncix_po
|
yes
|
no
|
|
|
|
|
cncix_modelyr
|
yes
|
no
|
|
|
|
|
cncix_current_loc
|
yes
|
no
|
|
|
|
|
cncix_lotser
|
yes
|
no
|
|
|
|
|
cncix_ref
|
yes
|
no
|
|
|
|
|
cncix_auth
|
yes
|
no
|
|
|
oid_cncix_mstr
|
yes
|
oid_cncix_mstr
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
cncs__qadc01
|
|
|
x(24)
|
|
|
|
cncs__qadc02
|
|
|
x(24)
|
|
|
|
cncs_auto_replenish
|
Auto Replenish
|
Auto!Replenish
|
yes/no
|
|
|
|
cncs_consign_flag
|
Consignment Orders
|
Consignment
|
yes/no
|
|
|
|
cncs_consign_loc
|
Consignment Location
|
Consignment!Location
|
x(8)
|
|
|
|
cncs_domain
|
Domain
|
|
x(8)
|
|
|
|
cncs_intrans_loc
|
In-Transit Location
|
In-Transit!Location
|
x(8)
|
|
|
|
cncs_max_aging_days
|
Maximum Aging Days
|
Maximum!Aging Days
|
>>9
|
|
|
|
cncs_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
cncs_mod_userid
|
User ID
|
|
x(8)
|
|
|
|
cncs_part
|
Item Number
|
|
x(18)
|
|
|
|
cncs_shipto
|
Ship-To
|
|
x(8)
|
|
|
|
cncs_user1
|
User Field Character 1
|
|
x(24)
|
|
|
|
cncs_user2
|
User Field Character 2
|
|
x(24)
|
|
|
|
oid_cncs_mstr
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
cncs_shipto_part
|
yes
|
cncs_domain
|
yes
|
no
|
|
|
|
|
cncs_shipto
|
yes
|
no
|
|
|
|
|
cncs_part
|
yes
|
no
|
|
|
oid_cncs_mstr
|
yes
|
oid_cncs_mstr
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
cncud__qadc01
|
|
|
x(24)
|
|
|
|
cncud__qadc02
|
|
|
x(24)
|
|
|
|
cncud_aged_date
|
Aged Date
|
Aged
|
99/99/99
|
|
|
|
cncud_asn_shipper
|
Shipper
|
|
x(20)
|
|
|
|
cncud_cncix_pkey
|
Primary Key2
|
|
>>>>>>>>>
|
|
|
|
cncud_cncu_pkey
|
Primary Key1
|
|
>>>>>>>>>
|
|
|
|
cncud_curr
|
Currency
|
Cur
|
x(3)
|
|
|
|
cncud_current_loc
|
Location
|
|
x(8)
|
|
|
|
cncud_cust_dock
|
Customer Dock
|
|
x(30)
|
|
|
|
cncud_domain
|
Domain
|
|
x(8)
|
|
|
|
cncud_int_consignment
|
Internal Consignment
|
|
yes/no
|
|
|
|
cncud_line_feed
|
Line Feed
|
|
x(30)
|
|
|
|
cncud_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
cncud_mod_userid
|
User ID
|
|
x(8)
|
|
|
|
cncud_orig_aged_date
|
Original Aged Date
|
Original!Aged
|
99/99/99
|
|
|
|
cncud_price
|
Price
|
|
>>,>>>,>>9.99<<<
|
10
|
|
|
cncud_qty_ship
|
Ship Qty
|
|
->>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
cncud_selfbill
|
Self-Bill
|
|
yes/no
|
|
|
|
cncud_ship_date
|
Ship Date
|
|
99/99/99
|
|
|
|
cncud_ship_trnbr
|
Trans Nbr
|
|
>>>>>>>>>>
|
|
|
|
cncud_ship_value
|
Ship Value
|
|
->>>>,>>>,>>9.99<
|
10
|
|
|
cncud_stock_um
|
Stock UM
|
UM
|
x(2)
|
|
|
|
cncud_usage_qty
|
Usage Qty
|
|
->>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
cncud_usage_um
|
UM
|
|
x(2)
|
|
|
|
cncud_usage_um_conv
|
Usage UM Conv
|
|
>>>>9.9999<<<<
|
10
|
|
|
cncud_user1
|
User Field Character 1
|
|
x(24)
|
|
|
|
cncud_user2
|
User Field Character 2
|
|
x(24)
|
|
|
|
oid_cncud_det
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
cncud_cncu_pkey
|
no
|
cncud_domain
|
yes
|
no
|
|
|
|
|
cncud_cncu_pkey
|
yes
|
no
|
|
|
|
|
cncud_cust_dock
|
yes
|
no
|
|
|
|
|
cncud_line_feed
|
yes
|
no
|
|
∗
|
cncud_primary_key
|
yes
|
cncud_domain
|
yes
|
no
|
|
|
|
|
cncud_cncu_pkey
|
yes
|
no
|
|
|
|
|
cncud_cncix_pkey
|
yes
|
no
|
|
|
cncud_reverse_key
|
no
|
cncud_domain
|
yes
|
no
|
|
|
|
|
cncud_cncix_pkey
|
yes
|
no
|
|
|
|
|
cncud_cncu_pkey
|
yes
|
no
|
|
|
oid_cncud_det
|
yes
|
oid_cncud_det
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
cncu__qadc01
|
|
|
x(24)
|
|
|
|
cncu__qadc02
|
|
|
x(24)
|
|
|
|
cncu_auth
|
Authorization
|
|
x(24)
|
|
|
|
cncu_batch
|
Batch
|
|
>>>>>>>>>
|
|
|
|
cncu_cum_qty
|
Cum Usage Qty
|
Cum Usage
|
->>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
cncu_cust
|
Sold-To
|
|
x(8)
|
|
|
|
cncu_cust_job
|
Customer Job
|
|
x(30)
|
|
|
|
cncu_cust_ref
|
Customer Reference
|
|
x(30)
|
|
|
|
cncu_cust_seq
|
Customer Sequence
|
|
x(30)
|
|
|
|
cncu_cust_usage_date
|
Customer Usage Date
|
Customer!Usage Date
|
99/99/99
|
|
|
|
cncu_cust_usage_ref
|
Customer Usage Ref
|
Customer!Usage Ref
|
x(20)
|
|
|
|
cncu_custpart
|
Customer Item
|
|
x(30)
|
|
|
|
cncu_domain
|
Domain
|
|
x(8)
|
|
|
|
cncu_eff_date
|
Effective Date
|
Effective
|
99/99/99
|
|
|
|
cncu_invoice
|
Invoice
|
|
x(8)
|
|
|
|
cncu_lotser
|
Lot/Serial
|
|
x(18)
|
|
|
|
cncu_manual_qty
|
Manual Qty
|
|
->>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
cncu_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
cncu_mod_userid
|
User ID
|
|
x(8)
|
|
|
|
cncu_modelyr
|
Model Year
|
|
x(4)
|
|
|
|
cncu_origin
|
Origin
|
|
x(8)
|
|
|
|
cncu_part
|
Item
|
|
x(18)
|
|
|
|
cncu_pkey
|
Primary Key
|
|
>>>>>>>>>
|
|
|
|
cncu_po
|
Customer PO
|
|
x(22)
|
|
|
|
cncu_ref
|
Reference
|
Ref
|
x(8)
|
|
|
|
cncu_selfbill_auth
|
SelfBill Auth
|
Self-Bill Authorization
|
x(24)
|
|
|
|
cncu_shipto
|
Ship-To
|
|
x(8)
|
|
|
|
cncu_site
|
Ship-From
|
|
x(8)
|
|
|
|
cncu_so_nbr
|
Sales Order
|
Order
|
x(8)
|
|
|
|
cncu_sod_line
|
Line
|
|
>>>9
|
|
|
|
cncu_trans_date
|
Transaction Date
|
Transaction
|
99/99/99
|
|
|
|
cncu_trnbr
|
Trans Nbr
|
|
>>>>>>>>>>
|
|
|
|
cncu_usage_qty
|
Usage Qty
|
|
->>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
cncu_usage_so_um_conv
|
Usage SO UM Conv
|
|
>>>>9.9999<<<<
|
10
|
|
|
cncu_usage_um
|
Usage UM
|
|
x(2)
|
|
|
|
cncu_usage_um_conv
|
Usage UM Conv
|
|
>>>>9.9999<<<<
|
10
|
|
|
cncu_user1
|
User Field Character 1
|
|
x(24)
|
|
|
|
cncu_user2
|
User Field Character 2
|
|
x(24)
|
|
|
|
oid_cncu_mstr
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
cncu_batch
|
no
|
cncu_domain
|
yes
|
no
|
|
|
|
|
cncu_batch
|
yes
|
no
|
|
|
|
|
cncu_so_nbr
|
yes
|
no
|
|
|
|
|
cncu_sod_line
|
yes
|
no
|
|
|
|
|
cncu_lotser
|
yes
|
no
|
|
|
|
|
cncu_ref
|
yes
|
no
|
|
|
|
|
cncu_auth
|
yes
|
no
|
|
|
cncu_invoice
|
no
|
cncu_domain
|
yes
|
no
|
|
|
|
|
cncu_invoice
|
yes
|
no
|
|
|
cncu_order
|
no
|
cncu_domain
|
yes
|
no
|
|
|
|
|
cncu_so_nbr
|
yes
|
no
|
|
|
|
|
cncu_sod_line
|
yes
|
no
|
|
|
cncu_origin
|
no
|
cncu_domain
|
yes
|
no
|
|
|
|
|
cncu_origin
|
yes
|
no
|
|
|
|
|
cncu_so_nbr
|
yes
|
no
|
|
|
|
|
cncu_sod_line
|
yes
|
no
|
|
|
|
|
cncu_trans_date
|
yes
|
no
|
|
∗
|
cncu_primary_key
|
yes
|
cncu_domain
|
yes
|
no
|
|
|
|
|
cncu_pkey
|
yes
|
no
|
|
|
cncu_shipfrom
|
no
|
cncu_domain
|
yes
|
no
|
|
|
|
|
cncu_site
|
yes
|
no
|
|
|
|
|
cncu_shipto
|
yes
|
no
|
|
|
|
|
cncu_cust_usage_ref
|
yes
|
no
|
|
|
|
|
cncu_cust_usage_date
|
yes
|
no
|
|
|
|
|
cncu_so_nbr
|
yes
|
no
|
|
|
|
|
cncu_sod_line
|
yes
|
no
|
|
|
|
|
cncu_lotser
|
yes
|
no
|
|
|
|
|
cncu_ref
|
yes
|
no
|
|
|
|
|
cncu_auth
|
yes
|
no
|
|
|
cncu_trnbr
|
no
|
cncu_domain
|
yes
|
no
|
|
|
|
|
cncu_trnbr
|
yes
|
no
|
|
|
oid_cncu_mstr
|
yes
|
oid_cncu_mstr
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
cnc__qadc01
|
|
|
x(24)
|
|
|
|
cnc__qadc02
|
|
|
x(24)
|
|
|
|
cnc__qadi01
|
|
|
->>>>>>>9
|
|
|
|
cnc_active
|
Using Consignment Inventory
|
|
yes/no
|
|
|
|
cnc_auto_replenish
|
Auto Replenish
|
Auto!Replenish
|
yes/no
|
|
|
|
cnc_consign_flag
|
Consignment Orders
|
Consignment
|
yes/no
|
|
|
|
cnc_consign_loc
|
Consignment Location
|
Consignment!Location
|
x(8)
|
|
|
|
cnc_domain
|
Domain
|
|
x(8)
|
|
|
|
cnc_intrans_loc
|
In-Transit Location
|
In-Transit!Location
|
x(8)
|
|
|
|
cnc_max_aging_days
|
Maximum Aging Days
|
Maximum!Aging Days
|
>>9
|
|
|
|
cnc_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
cnc_mod_userid
|
User ID
|
|
x(8)
|
|
|
|
cnc_user1
|
User Field Character 1
|
|
x(24)
|
|
|
|
cnc_user2
|
User Field Character 2
|
|
x(24)
|
|
|
|
oid_cnc_ctrl
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
cnc_index1
|
yes
|
cnc_domain
|
yes
|
no
|
|
|
oid_cnc_ctrl
|
yes
|
oid_cnc_ctrl
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
cnsix__qadc01
|
|
|
x(24)
|
|
|
|
cnsix__qadc02
|
|
|
x(24)
|
|
|
|
cnsix_aged_date
|
Aged Date
|
Aged
|
99/99/99
|
|
|
|
cnsix_asn_shipper
|
Shipper
|
|
x(20)
|
|
|
|
cnsix_domain
|
Domain
|
|
x(8)
|
|
|
|
cnsix_int_consignment
|
Internal Consignment
|
|
yes/no
|
|
|
|
cnsix_lotser
|
Lot/Serial
|
|
x(18)
|
|
|
|
cnsix_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
cnsix_mod_userid
|
User ID
|
|
x(8)
|
|
|
|
cnsix_orig_aged_date
|
Original Aged Date
|
Original!Aged
|
99/99/99
|
|
|
|
cnsix_part
|
Item Number
|
|
x(18)
|
|
|
|
cnsix_pkey
|
Primary Key
|
|
>>>>>>>>>
|
|
|
|
cnsix_po_nbr
|
Purchase Order
|
Order
|
x(8)
|
|
|
|
cnsix_pod_line
|
Line
|
|
>>9
|
|
|
|
cnsix_qty_consigned
|
Qty Consigned
|
Qty!Consigned
|
->>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
cnsix_receipt_trnbr
|
Trans Nbr
|
|
>>>>>>>>>>
|
|
|
|
cnsix_receiver
|
Receiver
|
|
x(8)
|
|
|
|
cnsix_ref
|
Reference
|
Ref
|
x(8)
|
|
|
|
cnsix_site
|
Site
|
|
x(8)
|
|
|
|
cnsix_user1
|
User Field Character 1
|
|
x(24)
|
|
|
|
cnsix_user2
|
User Field Character 2
|
|
x(24)
|
|
|
|
oid_cnsix_mstr
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
cnsix_item_order
|
no
|
cnsix_domain
|
yes
|
no
|
|
|
|
|
cnsix_part
|
yes
|
no
|
|
|
|
|
cnsix_site
|
yes
|
no
|
|
|
|
|
cnsix_po_nbr
|
yes
|
no
|
|
|
|
|
cnsix_pod_line
|
yes
|
no
|
|
|
cnsix_order_line
|
no
|
cnsix_domain
|
yes
|
no
|
|
|
|
|
cnsix_po_nbr
|
yes
|
no
|
|
|
|
|
cnsix_pod_line
|
yes
|
no
|
|
|
|
|
cnsix_aged_date
|
yes
|
no
|
|
∗
|
cnsix_primary_key
|
yes
|
cnsix_domain
|
yes
|
no
|
|
|
|
|
cnsix_pkey
|
yes
|
no
|
|
|
cnsix_receiver_ln
|
no
|
cnsix_domain
|
yes
|
no
|
|
|
|
|
cnsix_receiver
|
yes
|
no
|
|
|
|
|
cnsix_po_nbr
|
yes
|
no
|
|
|
|
|
cnsix_pod_line
|
yes
|
no
|
|
|
|
|
cnsix_lotser
|
yes
|
no
|
|
|
|
|
cnsix_ref
|
yes
|
no
|
|
|
cnsix_shipper
|
no
|
cnsix_domain
|
yes
|
no
|
|
|
|
|
cnsix_asn_shipper
|
yes
|
no
|
|
|
oid_cnsix_mstr
|
yes
|
oid_cnsix_mstr
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
cnss__qadc02
|
|
|
x(24)
|
|
|
|
cnss__qadc03
|
|
|
x(24)
|
|
|
|
cnss_consign_flag
|
Consignment Orders
|
Consignment
|
yes/no
|
|
|
|
cnss_cost_point
|
PO Cost Point
|
|
x(8)
|
|
|
|
cnss_domain
|
Domain
|
|
x(8)
|
|
|
|
cnss_max_aging_days
|
Maximum Aging Days
|
Maximum!Aging Days
|
>>9
|
|
|
|
cnss_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
cnss_mod_userid
|
User ID
|
|
x(8)
|
|
|
|
cnss_part
|
Item Number
|
|
x(18)
|
|
|
|
cnss_supplier
|
Supplier
|
|
x(8)
|
|
|
|
cnss_user1
|
User Field Character 1
|
|
x(24)
|
|
|
|
cnss_user2
|
User Field Character 2
|
|
x(24)
|
|
|
|
oid_cnss_mstr
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
cnss_supplier_part
|
yes
|
cnss_domain
|
yes
|
no
|
|
|
|
|
cnss_supplier
|
yes
|
no
|
|
|
|
|
cnss_part
|
yes
|
no
|
|
|
oid_cnss_mstr
|
yes
|
oid_cnss_mstr
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
cnsud__qadc01
|
|
|
x(24)
|
|
|
|
cnsud__qadc02
|
|
|
x(24)
|
|
|
|
cnsud_aged_date
|
Aged Date
|
Aged
|
99/99/99
|
|
|
|
cnsud_asn_shipper
|
Shipper
|
|
x(20)
|
|
|
|
cnsud_cnsix_pkey
|
Primary Key2
|
|
>>>>>>>>>
|
|
|
|
cnsud_cnsu_pkey
|
Primary Key1
|
|
>>>>>>>>>
|
|
|
|
cnsud_domain
|
Domain
|
|
x(8)
|
|
|
|
cnsud_int_consignment
|
Internal Consignment
|
|
yes/no
|
|
|
|
cnsud_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
cnsud_mod_userid
|
User ID
|
|
x(8)
|
|
|
|
cnsud_orig_aged_date
|
Original Aged Date
|
Original!Aged
|
99/99/99
|
|
|
|
cnsud_qty_used
|
Usage Qty
|
|
->>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
cnsud_receipt_trnbr
|
Receipt Trans Nbr
|
Receipt!Trans Nbr
|
>>>>>>>>>>
|
|
|
|
cnsud_receiver
|
Receiver
|
|
x(8)
|
|
|
|
cnsud_user1
|
User Field Character 1
|
|
x(24)
|
|
|
|
cnsud_user2
|
User Field Character 2
|
|
x(24)
|
|
|
|
oid_cnsud_det
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
cnsud_cnsu_pkey
|
no
|
cnsud_domain
|
yes
|
no
|
|
|
|
|
cnsud_cnsu_pkey
|
yes
|
no
|
|
|
|
|
cnsud_receiver
|
yes
|
no
|
|
∗
|
cnsud_primary_key
|
yes
|
cnsud_domain
|
yes
|
no
|
|
|
|
|
cnsud_cnsu_pkey
|
yes
|
no
|
|
|
|
|
cnsud_cnsix_pkey
|
yes
|
no
|
|
|
cnsud_reverse_key
|
no
|
cnsud_domain
|
yes
|
no
|
|
|
|
|
cnsud_cnsix_pkey
|
yes
|
no
|
|
|
|
|
cnsud_cnsu_pkey
|
yes
|
no
|
|
|
oid_cnsud_det
|
yes
|
oid_cnsud_det
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
cnsu__qadc01
|
|
|
x(24)
|
|
|
|
cnsu__qadc02
|
|
|
x(24)
|
|
|
|
cnsu_batch
|
Batch
|
|
>>>>>>>>>
|
|
|
|
cnsu_cum_qty
|
Cum Usage Qty
|
Cum Usage
|
->>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
cnsu_domain
|
Domain
|
|
x(8)
|
|
|
|
cnsu_edi_batch
|
EDI Batch ID
|
|
x(24)
|
|
|
|
cnsu_eff_date
|
Effective Date
|
Effective
|
99/99/99
|
|
|
|
cnsu_export_flag
|
Exported
|
|
yes/no
|
|
|
|
cnsu_lotser
|
Lot/Serial
|
|
x(18)
|
|
|
|
cnsu_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
cnsu_mod_userid
|
User ID
|
|
x(8)
|
|
|
|
cnsu_part
|
Item Number
|
|
x(18)
|
|
|
|
cnsu_pkey
|
Primary Key
|
|
>>>>>>>>>
|
|
|
|
cnsu_po_nbr
|
Purchase Order
|
Order
|
x(8)
|
|
|
|
cnsu_pod_line
|
Line
|
|
>>>9
|
|
|
|
cnsu_print_flag
|
Printed
|
|
yes/no
|
|
|
|
cnsu_qty_used
|
Usage Qty
|
|
->>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
cnsu_ref
|
Reference
|
Ref
|
x(8)
|
|
|
|
cnsu_site
|
Site
|
|
x(8)
|
|
|
|
cnsu_trans_date
|
Transaction Date
|
Transaction
|
99/99/99
|
|
|
|
cnsu_trnbr
|
Trans Nbr
|
|
>>>>>>>>>>
|
|
|
|
cnsu_user1
|
User Field Character 1
|
|
x(24)
|
|
|
|
cnsu_user2
|
User Field Character 2
|
|
x(24)
|
|
|
|
oid_cnsu_mstr
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
cnsu_batch
|
no
|
cnsu_domain
|
yes
|
no
|
|
|
|
|
cnsu_batch
|
yes
|
no
|
|
|
|
|
cnsu_trnbr
|
yes
|
no
|
|
|
|
|
cnsu_po_nbr
|
yes
|
no
|
|
|
|
|
cnsu_pod_line
|
yes
|
no
|
|
|
|
|
cnsu_lotser
|
yes
|
no
|
|
|
|
|
cnsu_ref
|
yes
|
no
|
|
|
cnsu_edi_batch
|
no
|
cnsu_domain
|
yes
|
no
|
|
|
|
|
cnsu_edi_batch
|
yes
|
no
|
|
|
cnsu_order
|
no
|
cnsu_domain
|
yes
|
no
|
|
|
|
|
cnsu_po_nbr
|
yes
|
no
|
|
|
|
|
cnsu_pod_line
|
yes
|
no
|
|
|
cnsu_part_site
|
no
|
cnsu_domain
|
yes
|
no
|
|
|
|
|
cnsu_part
|
yes
|
no
|
|
|
|
|
cnsu_site
|
yes
|
no
|
|
∗
|
cnsu_primary_key
|
yes
|
cnsu_domain
|
yes
|
no
|
|
|
|
|
cnsu_pkey
|
yes
|
no
|
|
|
cnsu_trnbr
|
no
|
cnsu_domain
|
yes
|
no
|
|
|
|
|
cnsu_trnbr
|
yes
|
no
|
|
|
oid_cnsu_mstr
|
yes
|
oid_cnsu_mstr
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
cns__qadc02
|
|
|
x(24)
|
|
|
|
cns__qadc03
|
|
|
x(24)
|
|
|
|
cns__qadi01
|
|
|
->>>>>>>9
|
|
|
|
cns_active
|
Using Consignment Inventory
|
|
yes/no
|
|
|
|
cns_consign_flag
|
Consignment Orders
|
Consignment
|
yes/no
|
|
|
|
cns_cost_point
|
PO Cost Point
|
|
x(8)
|
|
|
|
cns_domain
|
Domain
|
|
x(8)
|
|
|
|
cns_max_aging_days
|
Maximum Aging Days
|
Maximum!Aging Days
|
>>9
|
|
|
|
cns_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
cns_mod_userid
|
User ID
|
|
x(8)
|
|
|
|
cns_picking_logic
|
Consigned Picking Logic
|
Consigned!Picking
|
x(8)
|
|
|
|
cns_transfer_ownership
|
Transfer Ownership
|
Ownership
|
x(8)
|
|
|
|
cns_user1
|
User Field Character 1
|
|
x(24)
|
|
|
|
cns_user2
|
User Field Character 2
|
|
x(24)
|
|
|
|
oid_cns_ctrl
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
cns_index1
|
yes
|
cns_domain
|
yes
|
no
|
|
|
oid_cns_ctrl
|
yes
|
oid_cns_ctrl
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
CnvXref_ID
|
Record ID
|
|
-99999999999
|
|
|
|
efas_ID
|
EFAS ID
|
|
-99999999999
|
|
|
|
efas5_ID
|
EFAS ID (5)
|
|
-99999999999
|
|
|
|
EfasCoCode
|
Entity (EFAS)
|
|
->,>>>,>>9
|
|
|
|
EfasCode
|
Code (EFAS)
|
|
x(10)
|
|
|
|
EfasType
|
Type (EFAS)
|
|
x(10)
|
|
|
|
LastModifiedDate
|
Last Modified Date
|
|
99/99/9999
|
|
|
|
LastModifiedTime
|
Last Modified Time
|
|
99999
|
|
|
|
LastModifiedUser
|
Last Modified User
|
|
x(20)
|
|
|
|
Profile_ID
|
Profile
|
|
-99999999999
|
|
|
|
ProfileLink_ID
|
Profile Link
|
|
-99999999999
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
key_efas_id
|
no
|
efas_ID
|
yes
|
no
|
|
|
key_efas5_ID
|
no
|
efas5_ID
|
yes
|
no
|
|
|
Key_efastype
|
no
|
EfasType
|
yes
|
no
|
|
|
key_log_key
|
no
|
EfasCoCode
|
yes
|
no
|
|
|
|
|
EfasType
|
yes
|
no
|
|
|
|
|
EfasCode
|
yes
|
no
|
|
|
Key_profile_id
|
no
|
Profile_ID
|
yes
|
no
|
|
|
key_profile_link_id
|
no
|
ProfileLink_ID
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
CnvXref_ID
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
AltCOAStruct_ID
|
Alternate COA Structure
|
|
-99999999999
|
|
|
|
COACrossRef_ID
|
COA Cross Reference
|
|
-99999999999
|
|
|
|
COACrossRefCode
|
Code
|
|
x(20)
|
|
|
|
COACrossRefDescription
|
Description
|
|
x(40)
|
|
|
|
COACrossRefIsActive
|
Active
|
|
yes/no
|
|
|
|
COACrossRefType
|
Type
|
|
x(20)
|
|
|
|
LastModifiedDate
|
Last Mod Date
|
Last Modified Date
|
99/99/9999
|
|
|
|
LastModifiedTime
|
Last Mod Time
|
Last Modified Time
|
99999
|
|
|
|
LastModifiedUser
|
Last Mod User
|
Last Modified User
|
x(20)
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
SourceDomain_ID
|
Source Domain
|
|
-99999999999
|
|
|
|
TargetDomain_ID
|
Target Domain
|
|
-99999999999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
AlternateCOA
|
no
|
AltCOAStruct_ID
|
yes
|
no
|
|
|
CodeIdx
|
no
|
COACrossRefCode
|
yes
|
no
|
|
|
IsActive
|
no
|
COACrossRefIsActive
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
COACrossRef_ID
|
yes
|
no
|
|
|
TargetDomain
|
no
|
TargetDomain_ID
|
yes
|
no
|
|
|
Type
|
no
|
COACrossRefType
|
yes
|
no
|
|
|
Uniq
|
yes
|
SourceDomain_ID
|
yes
|
no
|
|
|
|
|
COACrossRefCode
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
COACrossRef_ID
|
Cross Reference
|
|
-99999999999
|
|
|
|
COACrossRefDet_ID
|
Cross Reference Detail
|
|
-99999999999
|
|
|
|
COACrossRefDetSrcCCFrom
|
Source Cost Center From
|
|
x(20)
|
|
|
|
COACrossRefDetSrcCCTo
|
Source Cost Center To
|
|
x(20)
|
|
|
|
COACrossRefDetSrcDivFrom
|
Source Sub-Account From
|
|
x(20)
|
|
|
|
COACrossRefDetSrcDivTo
|
Source Sub-Account To
|
|
x(20)
|
|
|
|
COACrossRefDetSrcGLFrom
|
Source GL Account From
|
|
x(20)
|
|
|
|
COACrossRefDetSrcGLTo
|
Source GL Account To
|
|
x(20)
|
|
|
|
COACrossRefDetSrcProjFrom
|
Source Project From
|
|
x(20)
|
|
|
|
COACrossRefDetSrcProjTo
|
Source Project To
|
|
x(20)
|
|
|
|
LastModifiedDate
|
Last Mod Date
|
Last Modified Date
|
99/99/9999
|
|
|
|
LastModifiedTime
|
Last Mod Time
|
Last Modified Time
|
99999
|
|
|
|
LastModifiedUser
|
Last Mod User
|
Last Modified User
|
x(20)
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
TargetAltCOAStructDet_ID
|
Target Alternate COA
|
|
-99999999999
|
|
|
|
TargetCostCentre_ID
|
Target Cost Center
|
|
-99999999999
|
|
|
|
TargetDivision_ID
|
Target Sub-Account
|
|
-99999999999
|
|
|
|
TargetGL_ID
|
Target GL Account
|
|
-99999999999
|
|
|
|
TargetProject_ID
|
Target Project
|
|
-99999999999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
Prim
|
yes
|
COACrossRefDet_ID
|
yes
|
no
|
|
|
TargetAltCOA
|
no
|
TargetAltCOAStructDet_ID
|
yes
|
no
|
|
|
TargetCC
|
no
|
TargetCostCentre_ID
|
yes
|
no
|
|
|
TargetDiv
|
no
|
TargetDivision_ID
|
yes
|
no
|
|
|
TargetGL
|
no
|
TargetGL_ID
|
yes
|
no
|
|
|
TargetProj
|
no
|
TargetProject_ID
|
yes
|
no
|
|
|
Uniq
|
yes
|
COACrossRef_ID
|
yes
|
no
|
|
|
|
|
COACrossRefDetSrcGLFrom
|
yes
|
no
|
|
|
|
|
COACrossRefDetSrcGLTo
|
yes
|
no
|
|
|
|
|
COACrossRefDetSrcDivFrom
|
yes
|
no
|
|
|
|
|
COACrossRefDetSrcDivTo
|
yes
|
no
|
|
|
|
|
COACrossRefDetSrcCCFrom
|
yes
|
no
|
|
|
|
|
COACrossRefDetSrcCCTo
|
yes
|
no
|
|
|
|
|
COACrossRefDetSrcProjFrom
|
yes
|
no
|
|
|
|
|
COACrossRefDetSrcProjTo
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
COAMaskCC_ID
|
COA Mask Cost Center
|
|
-99999999999
|
|
|
|
COAMaskCCCode
|
Cost Center COA Mask Code
|
|
x(20)
|
|
|
|
COAMaskCCDesc
|
Description
|
|
x(40)
|
|
|
|
COAMaskCCIsActive
|
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
|
COAMaskCC_ID
|
yes
|
no
|
|
|
UniqueIdx
|
yes
|
SharedSet_ID
|
yes
|
no
|
|
|
|
|
COAMaskCCCode
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
COAMaskCC_ID
|
COA Mask CC
|
|
-99999999999
|
|
|
|
COAMaskCCDiv_ID
|
COA Mask CC Range GL
|
|
-99999999999
|
|
|
|
COAMaskCCDivDescr
|
Description
|
|
x(40)
|
|
|
|
COAMaskCCDivFrom
|
From
|
|
x(8)
|
|
|
|
COAMaskCCDivIsNeg
|
Disallowed Range
|
|
yes/no
|
|
|
|
COAMaskCCDivTo
|
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
|
COAMaskCCDiv_ID
|
yes
|
no
|
|
|
SharedSetIdx
|
no
|
DivSharedSet_ID
|
yes
|
no
|
|
|
UniqueIdx
|
yes
|
COAMaskCC_ID
|
yes
|
no
|
|
|
|
|
DivSharedSet_ID
|
yes
|
no
|
|
|
|
|
COAMaskCCDivFrom
|
yes
|
no
|
|
|
|
|
COAMaskCCDivTo
|
yes
|
no
|
|
|
|
|
COAMaskCCDivIsNeg
|
yes
|
no
|