QAD 2017 Enterprise Edition > Technical References > Database Definitions >
  
csa_mstr
Controlled Substance Authority Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
csa__qadc01
 
 
x(8)
 
 
csa_auth
Authority
Auth
x(8)
 
 
csa_cmtindx
Comment Index
Comments
>>>>>>>9
 
 
csa_domain
Domain
 
x(8)
 
 
csa_group
Group
 
x(8)
 
 
csa_name
Name
 
x(28)
 
 
csa_type
Type
 
x(8)
 
 
csa_user1
Ufld1
 
x(8)
 
 
csa_user2
Ufld2
 
x(8)
 
 
oid_csa_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
csa_auth
yes
csa_domain
yes
no
 
 
 
csa_auth
yes
no
 
csa_group
no
csa_domain
yes
no
 
 
 
csa_group
yes
no
 
csa_name
no
csa_domain
yes
no
 
 
 
csa_name
yes
no
 
oid_csa_mstr
yes
oid_csa_mstr
yes
no
cscp_det
Links between period, currency, cost set for Periodic Costing
 
 
Field Name
Label
Col-Label
Format
Dec
 
cscp__qadc01
 
 
x(24)
 
 
cscp__qadc02
 
 
x(24)
 
 
cscp_mod_date
Modified Date
Mod Date
99/99/99
 
 
cscp_mod_userid
User ID
 
x(8)
 
 
cscp_user1
User Field Character 1
 
x(24)
 
 
cscp_user2
User Field Character 2
 
x(24)
 
 
oid_cs_mstr
Identifier Child Cost Set
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
oid_cscp_det
Identifier Cost Set Currency Period Link
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
oid_cu_mstr
Identifier Currency
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
oid_glccp_det
Identifier Cost Calculation Period
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
cscp_cost_cal_pd
no
oid_glccp_det
yes
no
 
cscp_cs_cal_pd_curr
yes
oid_cs_mstr
yes
no
 
 
 
oid_glccp_det
yes
no
 
 
 
oid_cu_mstr
yes
no
 
cscp_currency
no
oid_cu_mstr
yes
no
oid_cscp_det
yes
oid_cscp_det
yes
no
csc_mstr
Controlled Substance Customer Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
csc__qadc01
 
 
x(8)
 
 
csc_addr
Address Code
Address
x(8)
 
 
csc_auth
Authority
Auth
x(8)
 
 
csc_cmtindx
Comment Index
Comments
>>>>>>>9
 
 
csc_ctrl
Control Number
 
x(20)
 
 
csc_ctry_code
Country
Ctry
x(3)
 
 
csc_domain
Domain
 
x(8)
 
 
csc_end
End Date
End
99/99/99
 
 
csc_start
Start Date
Start
99/99/99
 
 
csc_user1
Ufld1
 
x(8)
 
 
csc_user2
Ufld2
 
x(8)
 
 
oid_csc_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
csc_addr_auth
no
csc_domain
yes
no
 
 
 
csc_addr
yes
no
 
 
 
csc_auth
yes
no
 
csc_ctrl_addr
no
csc_domain
yes
no
 
 
 
csc_ctrl
yes
no
 
 
 
csc_addr
yes
no
csc_ctry_auth
yes
csc_domain
yes
no
 
 
 
csc_ctry_code
yes
no
 
 
 
csc_auth
yes
no
 
 
 
csc_addr
yes
no
 
oid_csc_mstr
yes
oid_csc_mstr
yes
no
csd_det
Service/Support Call Skill Detail
 
 
Field Name
Label
Col-Label
Format
Dec
 
csd__qadc01
 
 
x(24)
 
 
csd__qadc02
 
 
x(24)
 
 
csd_ca_nbr
Call ID
 
x(8)
 
 
csd_category
Category
 
x(8)
 
 
csd_domain
Domain
 
x(8)
 
 
csd_line
Line
 
>>9
 
 
csd_mod_date
Modified Date
Mod Date
99/99/99
 
 
csd_mod_userid
User ID
 
x(8)
 
 
csd_problem
Prob/Skill
Prob
x(8)
 
 
csd_user1
User Field Character 1
 
x(24)
 
 
csd_user2
User Field Character 2
 
x(24)
 
 
oid_csd_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
csd_line_nbr
yes
csd_domain
yes
no
 
 
 
csd_category
yes
no
 
 
 
csd_ca_nbr
yes
no
 
 
 
csd_line
yes
no
csd_nbrprob
yes
csd_domain
yes
no
 
 
 
csd_category
yes
no
 
 
 
csd_ca_nbr
yes
no
 
 
 
csd_problem
yes
no
 
oid_csd_det
yes
oid_csd_det
yes
no
csid_det
Controlled Substance Item Detail
 
 
Field Name
Label
Col-Label
Format
Dec
 
csid__qadc01
 
 
x(8)
 
 
csid_addr1
Address Code
Address
x(8)
 
 
csid_addr2
Address Code
Address
x(8)
 
 
csid_addr3
Address Code
Address
x(8)
 
 
csid_auth
Authority
Auth
x(8)
 
 
csid_class
Class
 
x(8)
 
 
csid_ctrl
Control Number
 
x(20)
 
 
csid_ctry_code
Country
Ctry
x(3)
 
 
csid_domain
Domain
 
x(8)
 
 
csid_end
End Date
End
99/99/99
 
 
csid_intrastat
Intrastat Item
 
yes/no
 
 
csid_orig_ctry
Originating Country
Ctry
x(3)
 
 
csid_orig_pct
Originating Percent
Pct
>>9.99
10
 
csid_part
Item Number
 
x(18)
 
 
csid_pref
Preference Criteria
 
x(8)
 
 
csid_start
Start Date
Start
99/99/99
 
 
csid_status
Status
 
x(8)
 
 
csid_user1
Ufld1
 
x(8)
 
 
csid_user2
Ufld2
 
x(8)
 
 
oid_csid_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
csid_ctrl_part
no
csid_domain
yes
no
 
 
 
csid_ctrl
yes
no
 
 
 
csid_part
yes
no
csid_ctry_auth
yes
csid_domain
yes
no
 
 
 
csid_ctry_code
yes
no
 
 
 
csid_auth
yes
no
 
 
 
csid_ctrl
yes
no
 
 
 
csid_part
yes
no
 
csid_part_auth
yes
csid_domain
yes
no
 
 
 
csid_part
yes
no
 
 
 
csid_ctry_code
yes
no
 
 
 
csid_auth
yes
no
 
oid_csid_det
yes
oid_csid_det
yes
no
csil_mstr
Controlled Substance Individual License Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
csil__qadc01
 
 
x(8)
 
 
csil_addr1
Licensee Address
Licensee
x(8)
 
 
csil_addr2
Producer Address
Producer
x(8)
 
 
csil_addr3
Intermediate Consignee Addr
Int Con
x(8)
 
 
csil_addr4
Final Consignee Address
Fin Con
x(8)
 
 
csil_auth
Authority
Auth
x(8)
 
 
csil_cmtindx
Comment Index
Comments
>>>>>>>9
 
 
csil_ctry_code
Country
Ctry
x(3)
 
 
csil_domain
Domain
 
x(8)
 
 
csil_end
End Date
End
99/99/99
 
 
csil_licen
License Number
 
x(30)
 
 
csil_start
Start Date
Start
99/99/99
 
 
csil_user1
Ufld1
 
x(8)
 
 
csil_user2
Ufld2
 
x(8)
 
 
oid_csil_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
csil_addr4_licen
no
csil_domain
yes
no
 
 
 
csil_addr4
yes
no
 
 
 
csil_licen
yes
no
csil_ctry_auth
yes
csil_domain
yes
no
 
 
 
csil_ctry_code
yes
no
 
 
 
csil_auth
yes
no
 
 
 
csil_licen
yes
no
 
csil_licen
no
csil_domain
yes
no
 
 
 
csil_licen
yes
no
 
oid_csil_mstr
yes
oid_csil_mstr
yes
no
csim_mstr
Controlled Substance Item Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
csim__qadc01
 
 
x(8)
 
 
csim_auth
Authority
Auth
x(8)
 
 
csim_cmtindx
Comment Index
Comments
>>>>>>>9
 
 
csim_ctrl
Control Number
 
x(20)
 
 
csim_ctry_code
Country
Ctry
x(3)
 
 
csim_desc
Description
 
x(28)
 
 
csim_domain
Domain
 
x(8)
 
 
csim_um
Unit of Measure
UM
x(2)
 
 
csim_user1
Ufld1
 
x(8)
 
 
csim_user2
Ufld2
 
x(8)
 
 
oid_csim_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
csim_auth_ctrl
no
csim_domain
yes
no
 
 
 
csim_auth
yes
no
 
 
 
csim_ctrl
yes
no
csim_ctry_auth
yes
csim_domain
yes
no
 
 
 
csim_ctry_code
yes
no
 
 
 
csim_auth
yes
no
 
 
 
csim_ctrl
yes
no
 
csim_desc
no
csim_domain
yes
no
 
 
 
csim_auth
yes
no
 
 
 
csim_desc
yes
no
 
oid_csim_mstr
yes
oid_csim_mstr
yes
no
csld_det
Controlled Substance Individual License Detail
 
 
Field Name
Label
Col-Label
Format
Dec
 
csld__qadc01
 
 
x(8)
 
 
csld_auth
Authority
Auth
x(8)
 
 
csld_cmtindx
Comment Index
Comments
>>>>>>>9
 
 
csld_ctry_code
Country
Ctry
x(3)
 
 
csld_curr
Currency
Cur
x(3)
 
 
csld_domain
Domain
 
x(8)
 
 
csld_licen
License Number
 
x(30)
 
 
csld_max_amt
Max Amount
 
>>>,>>>,>>9.99<<<
10
 
csld_max_qty
Max Quantity
 
>>>,>>>,>>9
 
 
csld_part
Item Number
 
x(18)
 
 
csld_tot_amt
Total Amount
 
>>>>,>>>,>>9.99<<<
10
 
csld_tot_qty
Total Quantity
 
>>>,>>>,>>9
 
 
csld_user1
Ufld1
 
x(8)
 
 
csld_user2
Ufld2
 
x(8)
 
 
oid_csld_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
csld_ctry_auth
yes
csld_domain
yes
no
 
 
 
csld_ctry_code
yes
no
 
 
 
csld_auth
yes
no
 
 
 
csld_licen
yes
no
 
 
 
csld_part
yes
no
 
csld_licen_part
no
csld_domain
yes
no
 
 
 
csld_licen
yes
no
 
 
 
csld_part
yes
no
 
csld_part_licen
no
csld_domain
yes
no
 
 
 
csld_part
yes
no
 
 
 
csld_licen
yes
no
 
oid_csld_det
yes
oid_csld_det
yes
no
cslm_mstr
Controlled Substance General License Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
cslm__qadc01
 
 
x(8)
 
 
cslm_auth
Authority
Auth
x(8)
 
 
cslm_cmtindx
Comment Index
Comments
>>>>>>>9
 
 
cslm_ctrl
Control Num / ECCN
 
x(20)
 
 
cslm_ctry_code
Country
Ctry
x(3)
 
 
cslm_curr
Currency
Cur
x(3)
 
 
cslm_domain
Domain
 
x(8)
 
 
cslm_end
End Date
End
99/99/99
 
 
cslm_group
Country Groups
 
x(60)
 
 
cslm_licen
License Number
 
x(30)
 
 
cslm_max_amt
Max Amount
 
>>>>,>>>,>>9.99<<<
10
 
cslm_max_qty
Max Quantity
 
>>>,>>>,>>9
 
 
cslm_start
Start Date
Start
99/99/99
 
 
cslm_tot_amt
Total Amount
 
>>>>,>>>,>>9.99<<<
10
 
cslm_tot_qty
Total Quantity
 
>>>,>>>,>>9
 
 
cslm_user1
Ufld1
 
x(8)
 
 
cslm_user2
Ufld2
 
x(8)
 
 
oid_cslm_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
cslm_ctrl_licen
no
cslm_domain
yes
no
 
 
 
cslm_ctrl
yes
no
 
 
 
cslm_licen
yes
no
cslm_ctry_auth
yes
cslm_domain
yes
no
 
 
 
cslm_ctry_code
yes
no
 
 
 
cslm_auth
yes
no
 
 
 
cslm_licen
yes
no
 
 
 
cslm_ctrl
yes
no
 
cslm_grp
no
cslm_domain
yes
no
 
 
 
cslm_group
yes
no
 
oid_cslm_mstr
yes
oid_cslm_mstr
yes
no
cssi_det
Site Cost Detail
 
 
Field Name
Label
Col-Label
Format
Dec
 
cssi__qadc01
 
 
x(8)
 
 
cssi_active
Active
Act
yes/no
 
 
cssi_cur
Currency
Cur
x(3)
 
 
cssi_domain
Domain
 
x(8)
 
 
cssi_mod_date
Modified Date
Mod Date
99/99/99
 
 
cssi_set
Cost Set
 
x(8)
 
 
cssi_site
Site
 
x(8)
 
 
cssi_user1
Ufld1
 
x(8)
 
 
cssi_user2
Ufld2
 
x(8)
 
 
cssi_userid
User ID
 
x(8)
 
 
oid_cssi_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
cssi_set_site
yes
cssi_domain
yes
no
 
 
 
cssi_set
yes
no
 
 
 
cssi_site
yes
no
 
 
 
cssi_active
yes
no
cssi_site_set
yes
cssi_domain
yes
no
 
 
 
cssi_site
yes
no
 
 
 
cssi_set
yes
no
 
 
 
cssi_active
yes
no
 
oid_cssi_det
yes
oid_cssi_det
yes
no
css_mstr
Controlled Substance Site Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
css__qadc01
 
 
x(8)
 
 
css_auth
Authority
Auth
x(8)
 
 
css_cmtindx
Comment Index
Comments
>>>>>>>9
 
 
css_ctrl
Control Number
 
x(20)
 
 
css_ctry_code
Country
Ctry
x(3)
 
 
css_domain
Domain
 
x(8)
 
 
css_end
End Date
End
99/99/99
 
 
css_site
Site
 
x(8)
 
 
css_start
Start Date
Start
99/99/99
 
 
css_user1
Ufld1
 
x(8)
 
 
css_user2
Ufld2
 
x(8)
 
 
oid_css_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
css_ctrl_site
no
css_domain
yes
no
 
 
 
css_ctrl
yes
no
 
 
 
css_site
yes
no
css_ctry_auth
yes
css_domain
yes
no
 
 
 
css_ctry_code
yes
no
 
 
 
css_auth
yes
no
 
 
 
css_site
yes
no
 
css_site_auth
no
css_domain
yes
no
 
 
 
css_site
yes
no
 
 
 
css_auth
yes
no
 
oid_css_mstr
yes
oid_css_mstr
yes
no
cst_mstr
Fixed Asset Custodian Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
cst__qad01
 
 
x(8)
 
 
cst__qad02
 
 
x(8)
 
 
cst_cust
Custodian
 
x(12)
 
 
cst_desc
Description
 
x(30)
 
 
cst_user1
Ufld1
 
x(8)
 
 
cst_user2
Ufld2
 
x(8)
 
 
oid_cst_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
cst_cust
yes
cst_cust
yes
no
 
cst_desc
no
cst_desc
yes
no
 
 
 
cst_cust
yes
no
 
oid_cst_mstr
yes
oid_cst_mstr
yes
no
cs_mstr
Cost Set Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
cs__qadc01
 
 
x(8)
 
 
cs_desc
Description
 
x(24)
 
 
cs_domain
Domain
 
x(8)
 
 
cs_method
Costing Method
Mthd
x(4)
 
 
cs_pc_costset
Periodic Costing Default costset
 
yes/no
 
 
cs_set
Cost Set
 
x(18)
 
 
cs_set_isparent
Parent Costset
 
yes/no
 
 
cs_type
Cost Set Type
Type
x(4)
 
 
cs_user1
Ufld1
 
x(8)
 
 
cs_user2
Ufld2
 
x(8)
 
 
oid_cs_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
oid_cs_mstr_parent
Identifier of Parent Cost Set
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
cs_set
yes
cs_domain
yes
no
 
 
 
cs_set
yes
no
 
cs_type
yes
cs_domain
yes
no
 
 
 
cs_type
yes
no
 
 
 
cs_set
yes
no
 
oid_cs_mstr
yes
oid_cs_mstr
yes
no
ctd_det
Credit Terms Detail
 
 
Field Name
Label
Col-Label
Format
Dec
 
ctd__qadc01
 
 
x(8)
 
 
ctd_code
Terms Code
Terms
x(8)
 
 
ctd_date_cd
Dating Code
Dating
x(8)
 
 
ctd_domain
Domain
 
x(8)
 
 
ctd_pct_due
% Due
 
->>9.99
10
 
ctd_seq
Sequence
Seq
>>9
 
 
ctd_user1
Ufld1
 
x(8)
 
 
ctd_user2
Ufld2
 
x(8)
 
 
oid_ctd_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
ctd_cdseq
yes
ctd_domain
yes
no
 
 
 
ctd_code
yes
no
 
 
 
ctd_seq
yes
no
 
oid_ctd_det
yes
oid_ctd_det
yes
no
ctg_mstr
Category Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
ctg__qadc01
 
 
x(30)
 
 
ctg__qadc02
 
 
x(30)
 
 
ctg_category
Category
 
X(20)
 
 
ctg_mod_date
Modified Date
Mod Date
99/99/99
 
 
ctg_mod_userid
User ID
 
x(8)
 
 
ctg_user1
User Field Character 1
 
x(24)
 
 
ctg_user2
User Field Character 2
 
x(24)
 
 
ctg_value
Value
 
X(24)
 
 
oid_ctg_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
ctg_value
yes
ctg_category
yes
no
 
 
 
ctg_value
yes
no
 
oid_ctg_mstr
yes
oid_ctg_mstr
yes
no
ctry_mstr
Country Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
ctry__chr01
 
 
x(8)
 
 
ctry__log01
 
 
yes/no
 
 
ctry__qad01
 
 
x(8)
 
 
ctry__qad02
 
 
x(8)
 
 
ctry__qad03
 
 
x(8)
 
 
ctry__qad04
 
 
yes/no
 
 
ctry__qad05
 
 
yes/no
 
 
ctry_active
Active
 
yes/no
 
 
ctry_cmtindx
Comment Index
Comment
>>>>>>>9
 
 
ctry_code1
Alternate Code
Alt.!Code
x(2)
 
 
ctry_country
Name
 
x(28)
 
 
ctry_ctry_code
Country Code
Ctry
x(3)
 
 
ctry_dea_flag
DEA Country
DEA
yes/no
 
 
ctry_ec_flag
EC Country
EC
yes/no
 
 
ctry_fiscal_code
Fiscal Country Code
 
x(5)
 
 
ctry_format
Format
 
>9
 
 
ctry_gatt_flag
GATT Country
GATT
yes/no
 
 
ctry_group
Country Group
Group
x(8)
 
 
ctry_ie_code
IntraStat Country Code
 
x(3)
 
 
ctry_intra_curr
Intrastat Currency
Intrastat Curr
x(3)
 
 
ctry_nafta_flag
NAFTA Country
NAFTA
yes/no
 
 
ctry_type
Country Type
Type
x(8)
 
 
ctry_user1
Ufld1
 
x(8)
 
 
ctry_user2
Ufld2
 
x(8)
 
 
ctry_vat_reg_prefix
VAT Registration Prefix
 
x(2)
 
 
oid_ctry_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
ctry_code1
no
ctry_code1
yes
no
 
ctry_country
yes
ctry_country
yes
no
ctry_ctry_code
yes
ctry_ctry_code
yes
no
 
ctry_ec_flag
no
ctry_ec_flag
yes
no
 
oid_ctry_mstr
yes
oid_ctry_mstr
yes
no
ct_mstr
Credit Terms Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
ct__qadc01
 
 
x(8)
 
 
ct_base_date
Base Date
 
99/99/99
 
 
ct_base_days
Base Days
 
->>9
 
 
ct_code
Terms Code
Terms
x(8)
 
 
ct_dating
Multiple Due Dates
 
yes/no
 
 
ct_desc
Description
 
x(40)
 
 
ct_disc_date
Disc Date
 
99/99/99
 
 
ct_disc_days
Disc Days
Disc!Days
->>9
10
 
ct_disc_pct
Disc %
 
->>>9.99%
10
 
ct_domain
Domain
 
x(8)
 
 
ct_due_date
Due Date
 
99/99/99
 
 
ct_due_days
Due Days
Due!Days
->>9
10
 
ct_due_inv
Due Date From
Start!Due
>9
 
 
ct_from_inv
Disc Date From
Start!Disc
>9
 
 
ct_grace_days
Grace Days
 
->>9
 
 
ct_late_int
Daily Overdue Int Pct
Daily!Overdue!Int Pct
->>>9.99
10
 
ct_min_days
Minimum Due Days
 
>>9
 
 
ct_mod_date
Modified Date
Mod Date
99/99/99
 
 
ct_mtd_disc
30 days
 
yes/no
 
 
ct_mtd_due
30 days
 
yes/no
 
 
ct_terms_int
Terms Interest Pct
Trms Int%
->>>9.99
10
 
ct_user1
Ufld1
 
x(8)
 
 
ct_user2
Ufld2
 
x(8)
 
 
ct_userid
User ID
 
x(8)
 
 
ct_xdue_inv
Due Date From Invoice/EOM
Start!Due
Invoice/EOM
 
 
ct_xfrom_inv
Disc Date From Invoice/EOM
Start!Disc
Invoice/EOM
 
 
oid_ct_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
ct_code
yes
ct_domain
yes
no
 
 
 
ct_code
yes
no
 
ct_desc
yes
ct_domain
yes
no
 
 
 
ct_desc
yes
no
 
 
 
ct_code
yes
no
 
oid_ct_mstr
yes
oid_ct_mstr
yes
no
Currency
Currency
 
 
Field Name
Label
Col-Label
Format
Dec
 
Currency_ID
Record ID
 
-99999999999
 
 
CurrencyCode
Currency Code
Curr
x(3)
 
 
CurrencyDecimalDescription
Decimals Description
 
x(24)
 
 
CurrencyDescription
Currency Description
Curr Desc
x(24)
 
 
CurrencyIsActive
Active
Act
yes/no
 
 
CurrencyNumberOfDecimals
Number of Decimals
Decimals
->,>>>,>>9
 
 
CustomCombo0
Custom Combo Field
 
x(20)
 
 
CustomCombo1
Custom Combo Field
 
x(20)
 
 
CustomCombo10
Custom Combo Field
 
x(20)
 
 
CustomCombo11
Custom Combo Field
 
x(20)
 
 
CustomCombo12
Custom Combo Field
 
x(20)
 
 
CustomCombo13
Custom Combo Field
 
x(20)
 
 
CustomCombo14
Custom Combo Field
 
x(20)
 
 
CustomCombo2
Custom Combo Field
 
x(20)
 
 
CustomCombo3
Custom Combo Field
 
x(20)
 
 
CustomCombo4
Custom Combo Field
 
x(20)
 
 
CustomCombo5
Custom Combo Field
 
x(20)
 
 
CustomCombo6
Custom Combo Field
 
x(20)
 
 
CustomCombo7
Custom Combo Field
 
x(20)
 
 
CustomCombo8
Custom Combo Field
 
x(20)
 
 
CustomCombo9
Custom Combo Field
 
x(20)
 
 
CustomDate0
Custom Date Field
 
99/99/9999
 
 
CustomDate1
Custom Date Field
 
99/99/9999
 
 
CustomDate2
Custom Date Field
 
99/99/9999
 
 
CustomDate3
Custom Date Field
 
99/99/9999
 
 
CustomDate4
Custom Date Field
 
99/99/9999
 
 
CustomDecimal0
Custom Decimal Field
 
->,>>>,>>9.99
4
 
CustomDecimal1
Custom Decimal Field
 
->,>>>,>>9.99
4
 
CustomDecimal2
Custom Decimal Field
 
->,>>>,>>9.99
4
 
CustomDecimal3
Custom Decimal Field
 
->,>>>,>>9.99
4
 
CustomDecimal4
Custom Decimal Field
 
->,>>>,>>9.99
4
 
CustomInteger0
Custom Integer Field
 
->,>>>,>>9
 
 
CustomInteger1
Custom Integer Field
 
->,>>>,>>9
 
 
CustomInteger2
Custom Integer Field
 
->,>>>,>>9
 
 
CustomInteger3
Custom Integer Field
 
->,>>>,>>9
 
 
CustomInteger4
Custom Integer Field
 
->,>>>,>>9
 
 
CustomLong0
Custom Long Field
 
x(255)
 
 
CustomLong1
Custom Long Field
 
x(255)
 
 
CustomNote
Custom Note Field
 
x(2000)
 
 
CustomShort0
Custom Short Field
 
x(20)
 
 
CustomShort1
Custom Short Field
 
x(20)
 
 
CustomShort10
Custom Short Field
 
x(20)
 
 
CustomShort11
Custom Short Field
 
x(20)
 
 
CustomShort12
Custom Short Field
 
x(20)
 
 
CustomShort13
Custom Short Field
 
x(20)
 
 
CustomShort14
Custom Short Field
 
x(20)
 
 
CustomShort2
Custom Short Field
 
x(20)
 
 
CustomShort3
Custom Short Field
 
x(20)
 
 
CustomShort4
Custom Short Field
 
x(20)
 
 
CustomShort5
Custom Short Field
 
x(20)
 
 
CustomShort6
Custom Short Field
 
x(20)
 
 
CustomShort7
Custom Short Field
 
x(20)
 
 
CustomShort8
Custom Short Field
 
x(20)
 
 
CustomShort9
Custom Short Field
 
x(20)
 
 
LastModifiedDate
Last Modified Date
Mod Date
99/99/9999
 
 
LastModifiedTime
Last Modified Time
Mod Time
99999
 
 
LastModifiedUser
Last Modified User
Mod User
x(20)
 
 
QADC01
 
 
x(40)
 
 
QADC02
 
 
x(255)
 
 
QADD01
 
 
->,>>>,>>9.9999
10
 
QADT01
 
 
99/99/9999
 
 
RoundingMethod_ID
Rounding Method
 
-99999999999
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
Active
no
CurrencyIsActive
yes
no
 
Code
yes
CurrencyCode
yes
no
 
LastModIdx
no
LastModifiedDate
yes
no
 ∗
Prim
yes
Currency_ID
yes
no
 
RoundMthIdx
no
RoundingMethod_ID
yes
no
 
ViewIndex
no
CurrencyIsActive
yes
no
 
 
 
CurrencyCode
yes
no
CustInventM
Warehousing Customer/Inventory Status Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
Addr
Address
 
x(8)
 
 
Allow
Allow
 
yes/no
 
 
CmtIndx
Comments
 
>>>>>>>9
 
 
CreateDate
Create Date
 
99/99/99
 
 
CreateUserID
Created
 
x(8)
 
 
Domain
Domain
 
x(8)
 
 
InvStatus
Status
 
X(8)
 
 
ModDate
Modified
 
99/99/99
 
 
ModUserID
Modified
 
x(8)
 
 
oid_CustInventM
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
QadC01
QAD Field
 
X(8)
0
 
QadC02
QAD Field
 
X(8)
0
 
QadC03
QAD Field
 
X(8)
0
 
QadC04
QAD Field
 
X(8)
0
 
QadD01
QAD Field
 
->>>>,>>>,>>9.99<<<
10
 
QadD02
QAD Field
 
->>>>,>>>,>>9.99<<<
10
 
QadD03
QAD Field
 
->>>>,>>>,>>9.99<<<
10
 
QadI01
QAD Field
 
->,>>>,>>9
 
 
QadI02
QAD Field
 
->,>>>,>>9
 
 
QadI03
QAD Field
 
->,>>>,>>9
 
 
QadL01
QAD Field
 
yes/no
 
 
QadL02
QAD Field
 
yes/no
 
 
QadT01
QAD Field
 
99/99/99
 
 
QadT02
QAD Field
 
99/99/99
 
 
QadT03
QAD Field
 
99/99/99
 
 
User1
User 1
 
x(8)
 
 
User2
User 2
 
x(8)
 
 
UserC03
User Field Character 3
 
x(24)
 
 
UserC04
User Field Character 4
 
x(24)
 
 
UserC05
User Field Character 5
 
x(24)
 
 
UserD01
User Field Decimal 1
 
->>>>,>>>,>>9.9<<<<<<<<<
10
 
UserD02
User Field Decimal 2
 
->>>>,>>>,>>9.9<<<<<<<<<
10
 
UserL01
User Field Logical 1
 
yes/no
 
 
UserL02
User Field Logical 2
 
yes/no
 
 
UserT01
User Field Date 1
 
99/99/99
 
 
UserT02
User Field Date 2
 
99/99/99
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
AddrStatus
yes
Domain
yes
no
 
 
 
Addr
yes
no
 
 
 
InvStatus
yes
no
 
oid_CustInventM
yes
oid_CustInventM
yes
no
 
UsrIdx
no
Domain
yes
no
 
 
 
User1
yes
no
 
 
 
User2
yes
no
CustomValue
Custom Field Value
 
 
Field Name
Label
Col-Label
Format
Dec
 
CustomField_ID
Custom Field
 
-99999999999
 
 
CustomValue_ID
Record ID
 
-99999999999
 
 
CustomValueCode
Custom Value
 
x(20)
 
 
CustomValueSequence
Sequence
Seq
->,>>>,>>9
 
 
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
 
Parent
no
CustomField_ID
yes
no
 ∗
Prim
yes
CustomValue_ID
yes
no
CustPartM
Warehousing Customer/Item Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
Addr
Address
 
x(8)
 
 
CmtIndx
Comments
 
>>>>>>>9
 
 
CreateDate
Create Date
 
99/99/99
 
 
CreateUserID
Created
 
x(8)
 
 
Domain
Domain
 
x(8)
 
 
LastDate
Last Date
 
99/99/99
 
 
LastExpire
Last Expiration Date
Last Exp
99/99/99
 
 
ModDate
Modified
 
99/99/99
 
 
ModUserID
Modified
 
x(8)
 
 
oid_CustPartM
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
Part
Item Number
 
x(18)
 
 
QadC01
QAD Field
 
X(8)
0
 
QadC02
QAD Field
 
X(8)
0
 
QadC03
QAD Field
 
X(8)
0
 
QadC04
QAD Field
 
X(8)
0
 
QadD01
QAD Field
 
->>>>,>>>,>>9.99<<<
10
 
QadD02
QAD Field
 
->>>>,>>>,>>9.99<<<
10
 
QadD03
QAD Field
 
->>>>,>>>,>>9.99<<<
10
 
QadI01
QAD Field
 
->,>>>,>>9
 
 
QadI02
QAD Field
 
->,>>>,>>9
 
 
QadI03
QAD Field
 
->,>>>,>>9
 
 
QadL01
QAD Field
 
yes/no
 
 
QadL02
QAD Field
 
yes/no
 
 
QadT01
QAD Field
 
99/99/99
 
 
QadT02
QAD Field
 
99/99/99
 
 
QadT03
QAD Field
 
99/99/99
 
 
SameExpire
# of Allowed same Expire
Allowed same!Expire
>>,>>9
 
 
ShelfOffset
Shelf Life Offset
Shelf Life!Offset
>>,>>9
 
 
User1
User 1
 
x(8)
 
 
User2
User 2
 
x(8)
 
 
UserC03
User Field Character 3
 
x(24)
 
 
UserC04
User Field Character 4
 
x(24)
 
 
UserC05
User Field Character 5
 
x(24)
 
 
UserD01
User Field Decimal 1
 
->>>>,>>>,>>9.9<<<<<<<<<
10
 
UserD02
User Field Decimal 2
 
->>>>,>>>,>>9.9<<<<<<<<<
10
 
UserL01
User Field Logical 1
 
yes/no
 
 
UserL02
User Field Logical 2
 
yes/no
 
 
UserT01
User Field Date 1
 
99/99/99
 
 
UserT02
User Field Date 2
 
99/99/99
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 ∗
AddrPart
yes
Domain
yes
no
 
 
 
Addr
yes
no
 
 
 
Part
yes
no
 
oid_CustPartM
yes
oid_CustPartM
yes
no
 
UsrIdx
no
Domain
yes
no
 
 
 
User1
yes
no
 
 
 
User2
yes
no
cu_mstr
Currency Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
cu__qadc01
 
 
x(8)
 
 
cu__qadc02
 
 
x(24)
 
 
cu__qadc03
 
 
x(24)
 
 
cu__qadc04
 
 
x(24)
 
 
cu__qadc05
 
 
x(24)
 
 
cu__qadc06
 
 
x(24)
 
 
cu__qadc07
 
 
x(24)
 
 
cu__qadc08
 
 
x(24)
 
 
cu__qadc09
 
 
x(24)
 
 
cu__qadc10
 
 
x(24)
 
 
cu__qadc11
 
 
x(24)
 
 
cu__qadc12
 
 
x(24)
 
 
cu__qadc13
 
 
x(24)
 
 
cu__qadc14
 
 
x(24)
 
 
cu__qadc15
 
 
x(24)
 
 
cu__qadc16
 
 
x(24)
 
 
cu__qadd01
 
 
>>,>>9.99999<<<<<
10
 
cu__qadl01
 
 
yes/no
 
 
cu__qadt01
 
 
99/99/99
 
 
cu__qadt02
 
 
99/99/99
 
 
cu_active
Active
 
yes/no
 
 
cu_curr
Currency
Cur
x(3)
 
 
cu_desc
Description
 
x(24)
 
 
cu_iso_curr
ISO Currency
 
x(3)
 
 
cu_mod_date
Modified Date
Mod Date
99/99/99
 
 
cu_mod_userid
User ID
 
x(8)
 
 
cu_rnd_mthd
Rounding Method
Rnd!Mthd
x(1)
 
 
cu_user1
Ufld1
 
x(8)
 
 
cu_user2
Ufld2
 
x(8)
 
 
oid_cu_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
cu_curr
yes
cu_curr
yes
no
 
oid_cu_mstr
yes
oid_cu_mstr
yes
no