QAD 2017 Enterprise Edition > Technical References > Database Definitions >
  
CMask
Period Closing Mask
 
 
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
CMaskJournal
Closing Mask Journal
 
 
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
CMaskJrnlGroup
Closing Mask Journal Group
 
 
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
cmc_ctrl
Customer Control
 
 
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
cmd_det
Enterprise Material Transfer Change Management Detail
 
 
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
cmf_mstr
Enterprise Material Transfer Change Management Master
 
 
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
cmh_hist
Customer Sales History
 
 
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
cmt_det
Transaction Comments
 
 
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
cm_mstr
Customer Master
 
 
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
cncix_mstr
Consigned Shipment Inventory Cross-Reference Master
 
 
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
cncs_mstr
Customer Consignment Ship-To/Item Master
 
 
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
cncud_det
Customer Consignment Shipment Usage Detail
 
 
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
cncu_mstr
Customer Consignment Shipment Usage Master
 
 
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
cnc_ctrl
Customer Consignment Control
 
 
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
cnsix_mstr
Supplier Consignment Receipt Inventory Master
 
 
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
cnss_mstr
Supplier Consignment Supplier/Item Master
 
 
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
cnsud_det
Supplier Consignment Receipt Usage Detail
 
 
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
cnsu_mstr
Supplier Consignment Receipt Usage Master
 
 
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
cns_ctrl
Supplier Consignment Control
 
 
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
CnvXref
Temporary Table used for converting SCBA
 
 
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
COACrossRef
COA Cross Reference
 
 
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
COACrossRefDet
Cross Reference Detail
 
 
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
COAMaskCC
COA Mask Cost Center
 
 
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
COAMaskCCDiv
COA Mask Cost Center Range GL
 
 
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