QAD 2017 Enterprise Edition > Technical References > Database Definitions >
  
dpt_mstr
Department Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
dpt__chr01
 
 
x(8)
 
 
dpt__chr02
 
 
x(8)
 
 
dpt__chr03
 
 
x(8)
 
 
dpt__chr04
 
 
x(8)
 
 
dpt__chr05
 
 
x(8)
 
 
dpt__dec01
 
 
>>>,>>>,>>9.99
10
 
dpt__dec02
 
 
>>>,>>>,>>9.99
10
 
dpt__dte01
 
 
99/99/99
 
 
dpt__dte02
 
 
99/99/99
 
 
dpt__log01
 
 
yes/no
 
 
dpt__qadc01
 
 
x(8)
 
 
dpt__qadc02
 
 
x(4)
 
 
dpt__qadc03
 
 
x(8)
 
 
dpt__qadc04
 
 
x(4)
 
 
dpt__qadc05
 
 
x(8)
 
 
dpt__qadc06
 
 
x(4)
 
 
dpt__qadc07
 
 
x(8)
 
 
dpt__qadc08
 
 
x(4)
 
 
dpt_bdn_acct
Burden
 
x(8)
 
 
dpt_bdn_cc
Burden Cost Ctr
CC
x(4)
 
 
dpt_bdn_sub
Burden Sub-Acct
Sub-Acct
x(8)
 
 
dpt_bvar_acc
Burden Usage Variance
Bdn Use
x(8)
 
 
dpt_bvar_cc
Burden Usage Variance CC
CC
x(4)
 
 
dpt_bvar_sub
Burden Usage Var Sub
Sub-Acct
x(8)
 
 
dpt_bvrr_acc
Burden Rate Variance
Bdn Rate
x(8)
 
 
dpt_bvrr_cc
Burden Rate Variance CC
CC
x(4)
 
 
dpt_bvrr_sub
Burden Rate Var Sub
Sub-Acct
x(8)
 
 
dpt_cop_acct
Cost of Production
COP
x(8)
 
 
dpt_cop_cc
Cost of Production Cost Ctr
CC
x(4)
 
 
dpt_cop_sub
Cost of Production Sub
Sub-Acct
x(8)
 
 
dpt_dept
Department
Dept
x(8)
 
 
dpt_desc
Description
 
x(24)
 
 
dpt_domain
Domain
 
x(8)
 
 
dpt_lbr_acct
Labor
 
x(8)
 
 
dpt_lbr_cap
Labor capacity
 
->,>>>,>>9
 
 
dpt_lbr_cc
Labor Cost Ctr
CC
x(4)
 
 
dpt_lbr_sub
Labor Sub-Acct
Sub-Acct
x(8)
 
 
dpt_lvar_acc
Labor Usage Variance
Lbr Use
x(8)
 
 
dpt_lvar_cc
Labor Usage Variance CC
CC
x(4)
 
 
dpt_lvar_sub
Labor Usage Var Sub
Sub-Acct
x(8)
 
 
dpt_lvrr_acc
Labor Rate Variance
Lbr Rate
x(8)
 
 
dpt_lvrr_cc
Labor Rate Variance CC
CC
x(4)
 
 
dpt_lvrr_sub
Labor Rate Var Sub
Sub-Acct
x(8)
 
 
dpt_mod_date
Modified Date
Mod Date
99/99/99
 
 
dpt_user1
Ufld1
 
x(8)
 
 
dpt_user2
Ufld2
 
x(8)
 
 
dpt_userid
User ID
 
x(8)
 
 
oid_dpt_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
dpt_dept
yes
dpt_domain
yes
no
 
 
 
dpt_dept
yes
no
 
dpt_desc
yes
dpt_domain
yes
no
 
 
 
dpt_desc
yes
no
 
 
 
dpt_dept
yes
no
 
oid_dpt_mstr
yes
oid_dpt_mstr
yes
no
drp_ctrl
Distribution Requirements Planning Control
 
 
Field Name
Label
Col-Label
Format
Dec
 
drp__qadc01
 
 
x(8)
 
 
drp__qadi01
 
 
->>>>>>>9
 
 
drp_auto_nbr
Auto D/O Numbers
Auto D/O
yes/no
 
 
drp_auto_req
Auto Requisitions
 
yes/no
 
 
drp_dcmmts
Distribution Order Comments
D/O Cmmts
yes/no
 
 
drp_domain
Domain
 
x(8)
 
 
drp_mrp
DRP/MRP Combined
DRP/MRP
yes/no
 
 
drp_nbr
Next D/O Nbr
Next D/O
>>>>>>>9
 
 
drp_nbr_pre
D/O Prefix
Pre
x(3)
 
 
drp_rcmmts
Requisition Comments
Req Cmmts
yes/no
 
 
drp_req_nbr
Next Req Nbr
Next Req
>>>>>>>9
 
 
drp_req_pre
Req Prefix
Pre
x(3)
 
 
drp_user1
Ufld1
 
x(8)
 
 
drp_user2
Ufld2
 
x(8)
 
 
oid_drp_ctrl
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
drp_ctrl
yes
drp_domain
yes
no
 
oid_drp_ctrl
yes
oid_drp_ctrl
yes
no
dsd_det
Distributed Site Requisition Detail
 
 
Field Name
Label
Col-Label
Format
Dec
 
dsd__chr01
 
 
x(8)
 
 
dsd__chr02
 
 
x(8)
 
 
dsd__chr03
 
 
x(8)
 
 
dsd__chr04
 
 
x(8)
 
 
dsd__chr05
 
 
x(8)
 
 
dsd__dec01
 
 
>>>,>>>,>>9.99
10
 
dsd__dec02
 
 
>>>,>>>,>>9.99
10
 
dsd__dte01
 
 
99/99/99
 
 
dsd__dte02
 
 
99/99/99
 
 
dsd__log01
 
 
yes/no
 
 
dsd_cmtindx
Comment Index
Comment
>>>>>>>9
 
 
dsd_domain
Domain
 
x(8)
 
 
dsd_due_date
Due Date
 
99/99/99
 
 
dsd_git_acct
Goods in Transit Acct
GIT Acct
x(8)
 
 
dsd_git_cc
Cost Center
CC
x(4)
 
 
dsd_git_site
In Transit Site
GIT Site
x(8)
 
 
dsd_git_sub
Goods in Tran Sub-Acct
Sub-Acct
x(8)
 
 
dsd_loc
Location
 
x(8)
 
 
dsd_nbr
Order Number
Order
x(8)
 
 
dsd_part
Item Number
 
x(18)
 
 
dsd_per_date
Performance Date
Perform
99/99/99
 
 
dsd_po_nbr
Purchase Order
P/O Nbr
x(8)
 
 
dsd_pod_line
Line
Ln
>>9
 
 
dsd_project
Project
 
x(8)
 
 
dsd_qty_chg
Qty To Receive
Receipt Qty
->,>>>,>>9.9<<<<<<<<
10
 
dsd_qty_conf
Qty Confirmed
 
->,>>>,>>9.9<<<<<<<<
10
 
dsd_qty_ord
Qty Ordered
 
->,>>>,>>9.9<<<<<<<<
10
 
dsd_qty_rcvd
Qty Received
 
->,>>>,>>9.9<<<<<<<<
10
 
dsd_qty_ship
Qty Shipped
 
->,>>>,>>9.9<<<<<<<<
10
 
dsd_req_nbr
Requisition
Req Nbr
x(8)
 
 
dsd_residual
In Transit Value
 
->>>,>>>,>>9.99<<<
10
 
dsd_rev
Rev
 
x(4)
 
 
dsd_rmks
Remarks
 
x(40)
 
 
dsd_shipdate
Ship Date
Ship
99/99/99
 
 
dsd_shipsite
Shipping Site
Source
x(8)
 
 
dsd_site
Site
 
x(8)
 
 
dsd_status
Status
St
x(1)
 
 
dsd_trans_id
Transportation Code
Transport
x(8)
 
 
dsd_transit
In Transit
 
->,>>>,>>9.9<<<<<<<<
10
 
dsd_updated
Updated
 
yes/no
 
 
dsd_user1
Ufld1
 
x(8)
 
 
dsd_user2
Ufld2
 
x(8)
 
 
oid_dsd_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
dsd_nbr
no
dsd_domain
yes
no
 
 
 
dsd_nbr
yes
no
 
 
 
dsd_shipsite
yes
no
 
dsd_req_nbr
yes
dsd_domain
yes
no
 
 
 
dsd_req_nbr
yes
no
 
 
 
dsd_site
yes
no
 
 
 
dsd_shipsite
yes
no
dsd_site
yes
dsd_domain
yes
no
 
 
 
dsd_site
yes
no
 
 
 
dsd_req_nbr
yes
no
 
 
 
dsd_shipsite
yes
no
 
dsr_part_due
no
dsd_domain
yes
no
 
 
 
dsd_part
yes
no
 
 
 
dsd_site
yes
no
 
 
 
dsd_due_date
yes
no
 
dsr_part_rel
no
dsd_domain
yes
no
 
 
 
dsd_part
yes
no
 
 
 
dsd_shipsite
yes
no
 
 
 
dsd_shipdate
yes
no
 
oid_dsd_det
yes
oid_dsd_det
yes
no
dsr_mstr
Distributed Site Requisition Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
dsr__chr01
 
 
x(8)
 
 
dsr__chr02
 
 
x(8)
 
 
dsr__chr03
 
 
x(8)
 
 
dsr__chr04
 
 
x(8)
 
 
dsr__chr05
 
 
x(8)
 
 
dsr__dec01
 
 
>>>,>>>,>>9.99
10
 
dsr__dec02
 
 
>>>,>>>,>>9.99
10
 
dsr__dte01
 
 
99/99/99
 
 
dsr__dte02
 
 
99/99/99
 
 
dsr__log01
 
 
yes/no
 
 
dsr_app_owner
Owner Application
 
x(12)
 
 
dsr_cmtindx
Comment Index
Comment
>>>>>>>9
 
 
dsr_domain
Domain
 
x(8)
 
 
dsr_due_date
Due Date
 
99/99/99
 
 
dsr_loc
Location
 
x(8)
 
 
dsr_ord_date
Order Date
Ord Date
99/99/99
 
 
dsr_part
Item Number
 
x(18)
 
 
dsr_project
Project
 
x(8)
 
 
dsr_qty_req
Quantity
 
->,>>>,>>9.9<<<<<<<<
10
 
dsr_req_nbr
Requisition
Req Nbr
x(8)
 
 
dsr_rev
Rev
 
x(4)
 
 
dsr_rmks
Remarks
 
x(40)
 
 
dsr_site
Site
 
x(8)
 
 
dsr_so_job
Sales/Job
SO/Job
x(8)
 
 
dsr_status
Status
St
x(1)
 
 
dsr_user1
Ufld1
 
x(8)
 
 
dsr_user2
Ufld2
 
x(8)
 
 
oid_dsr_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
dsr_mstr
yes
dsr_domain
yes
no
 
 
 
dsr_site
yes
no
 
 
 
dsr_req_nbr
yes
no
 
dsr_part
no
dsr_domain
yes
no
 
 
 
dsr_part
yes
no
 
 
 
dsr_site
yes
no
 
 
 
dsr_due_date
yes
no
 
dsr_req_nbr
yes
dsr_domain
yes
no
 
 
 
dsr_req_nbr
yes
no
 
 
 
dsr_site
yes
no
 
oid_dsr_mstr
yes
oid_dsr_mstr
yes
no
dss_mstr
Distributed Site Order Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
dss__chr01
 
 
x(8)
 
 
dss__chr02
 
 
x(8)
 
 
dss__chr03
 
 
x(8)
 
 
dss__chr04
 
 
x(8)
 
 
dss__chr05
 
 
x(8)
 
 
dss__chr06
 
 
x(8)
 
 
dss__chr07
 
 
x(8)
 
 
dss__chr08
 
 
x(8)
 
 
dss__chr09
 
 
x(8)
 
 
dss__chr10
 
 
x(8)
 
 
dss__dec01
PST
 
>>>,>>>,>>9.99
10
 
dss__dec02
 
 
>>>,>>>,>>9.99
10
 
dss__dte01
 
 
99/99/99
 
 
dss__dte02
 
 
99/99/99
 
 
dss__log01
 
 
yes/no
 
 
dss__qad01
 
 
-z,zzz,zzz,zz9.99
10
 
dss__qad02
 
 
-z,zzz,zzz,zz9.99
10
 
dss__qad03
 
 
-z,zzz,zzz,zz9.99
10
 
dss__qad04
 
 
>
 
 
dss__qad05[2]
 
 
>>9.9<<
10
 
dss_app_owner
Owner Application
 
x(12)
 
 
dss_bol
BOL
 
x(18)
 
 
dss_cartons
Cartons
 
>,>>>,>>9
 
 
dss_cmtindx
Comment Index
Comment
>>>>>>>9
 
 
dss_created
Date Created
Ord Date
99/99/99
 
 
dss_domain
Domain
 
x(8)
 
 
dss_due_date
Due Date
 
99/99/99
 
 
dss_fob
FOB Point
 
x(20)
 
 
dss_fr_list
Freight List
Frt List
x(8)
 
 
dss_fr_min_wt
Frt Min Wt
 
->>>,>>>,>>9
10
 
dss_fr_terms
Freight Terms
Fr Terms
x(8)
 
 
dss_lang
Language
 
x(2)
 
 
dss_nbr
Order Number
Order
x(8)
 
 
dss_po_nbr
Purchase Order
PO
x(22)
 
 
dss_rec_site
Ship-To
 
x(8)
 
 
dss_rmks
Remarks
 
x(40)
 
 
dss_shipdate
Ship Date
 
99/99/99
 
 
dss_shipsite
Site
 
x(8)
 
 
dss_shipvia
Ship Via
 
x(20)
 
 
dss_so_nbr
Sales Order
S/O
x(8)
 
 
dss_status
Order Status
Status
x(8)
 
 
dss_user1
Ufld1
 
x(8)
 
 
dss_user2
Ufld2
 
x(8)
 
 
dss_weight
Weight
 
->>>,>>>,>>9.9999
10
 
dss_weight_um
Weight UM
UM
x(2)
 
 
oid_dss_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
dss_nbr
yes
dss_domain
yes
no
 
 
 
dss_nbr
yes
no
 
 
 
dss_shipsite
yes
no
 
dss_rec_site
no
dss_domain
yes
no
 
 
 
dss_rec_site
yes
no
 
 
 
dss_shipsite
yes
no
 
 
 
dss_nbr
yes
no
 
dss_shipsite
no
dss_domain
yes
no
 
 
 
dss_shipsite
yes
no
 
 
 
dss_rec_site
yes
no
 
 
 
dss_nbr
yes
no
 
oid_dss_mstr
yes
oid_dss_mstr
yes
no
ds_det
Distributed Site Order Detail
 
 
Field Name
Label
Col-Label
Format
Dec
 
ds__chr01
 
 
x(8)
 
 
ds__chr02
 
 
x(8)
 
 
ds__chr03
 
 
x(8)
 
 
ds__chr04
 
 
x(8)
 
 
ds__chr05
 
 
x(8)
 
 
ds__dec01
 
 
>>>,>>>,>>9.99
10
 
ds__dec02
 
 
>>>,>>>,>>9.99
10
 
ds__dte01
 
 
99/99/99
 
 
ds__dte02
 
 
99/99/99
 
 
ds__log01
 
 
yes/no
 
 
ds_cmtindx
Comment Index
Comment
>>>>>>>9
 
 
ds_domain
Domain
 
x(8)
 
 
ds_due_date
Due Date
 
99/99/99
 
 
ds_fr_chg
Unit Freight Charge
 
->>>,>>>,>>9.99
10
 
ds_fr_class
Freight Class
 
x(8)
 
 
ds_fr_list
Freight List
Frt List
x(8)
 
 
ds_fr_rate
Freight Rate
 
>>>,>>>,>>9.99<<
10
 
ds_fr_wt
Unit Ship Weight
 
->,>>>,>>9.<<<<<<
10
 
ds_fr_wt_um
UM
 
x(2)
 
 
ds_git_acct
Goods In Transit Acct
GIT Acct
x(8)
 
 
ds_git_cc
Cost Center
CC
x(4)
 
 
ds_git_site
In Transit Site
GIT Site
x(8)
 
 
ds_git_sub
Goods In Tran Sub-Acct
Sub-Acct
x(8)
 
 
ds_line
Line
Ln
>>>>>>>>9
 
 
ds_loc
Location
 
x(8)
 
 
ds_nbr
Order Number
Order
x(8)
 
 
ds_order_category
Category
 
x(8)
 
 
ds_part
Item Number
 
x(18)
 
 
ds_per_date
Performance Date
Perform
99/99/99
 
 
ds_project
Project
 
x(8)
 
 
ds_qty_all
Qty Allocated
Allocated
->,>>>,>>9.9<<<<<<<<
10
 
ds_qty_chg
Qty To Issue
Issue Qty
->,>>>,>>9.9<<<<<<<<
10
 
ds_qty_conf
Qty Confirmed
Qty Conf
->,>>>,>>9.9<<<
10
 
ds_qty_ord
Qty Ordered
 
->,>>>,>>9.9<<<
10
 
ds_qty_pick
Qty Picked
 
->,>>>,>>9.9<<<<<<<<
10
 
ds_qty_ship
Qty Shipped
 
->,>>>,>>9.9<<<
10
 
ds_req_nbr
Requisition Number
Req Nbr
x(8)
 
 
ds_residual
In Transit Value
 
->>>,>>>,>>9.99
10
 
ds_rev
Rev
 
x(4)
 
 
ds_rmks
Remarks
 
x(40)
 
 
ds_shipdate
Ship Date
Ship
99/99/99
 
 
ds_shipsite
Shipping Site
Source
x(8)
 
 
ds_site
Site
 
x(8)
 
 
ds_so_nbr
Sales Order
S/O Nbr
x(8)
 
 
ds_sod_line
Line
Ln
>>9
 
 
ds_status
Status
St
x(1)
 
 
ds_trans_id
Transport ID
Transport
x(8)
 
 
ds_user1
Ufld1
 
x(8)
 
 
ds_user2
Ufld2
 
x(8)
 
 
oid_ds_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
ds_det
yes
ds_domain
yes
no
 
 
 
ds_shipsite
yes
no
 
 
 
ds_req_nbr
yes
no
 
 
 
ds_site
yes
no
 
ds_fr_list
no
ds_domain
yes
no
 
 
 
ds_nbr
yes
no
 
 
 
ds_shipsite
yes
no
 
 
 
ds_fr_list
yes
no
 
ds_nbr
no
ds_domain
yes
no
 
 
 
ds_nbr
yes
no
 
 
 
ds_shipsite
yes
no
 
 
 
ds_line
yes
no
 
ds_part
no
ds_domain
yes
no
 
 
 
ds_part
yes
no
 
 
 
ds_shipsite
yes
no
 
 
 
ds_shipdate
yes
no
ds_req_nbr
yes
ds_domain
yes
no
 
 
 
ds_req_nbr
yes
no
 
 
 
ds_site
yes
no
 
 
 
ds_shipsite
yes
no
 
oid_ds_det
yes
oid_ds_det
yes
no
dvfv_det
Data Validation Field Value Detail
 
 
Field Name
Label
Col-Label
Format
Dec
 
dvfv__qadc01
 
 
x(24)
 
 
dvfv__qadc02
 
 
x(24)
 
 
dvfv_allow_import
 
 
yes/no
 
 
dvfv_fldvalue
Field Value
 
x(22)
 
 
dvfv_import_date
 
 
99/99/99
 
 
dvfv_import_filename
Import Filename
 
x(18)
 
 
dvfv_import_userid
Import Userid
 
x(8)
 
 
dvfv_mod_date
Modified Date
Mod Date
99/99/99
 
 
dvfv_mod_userid
User ID
 
x(8)
 
 
dvfv_user1
User Field Character 1
 
x(24)
 
 
dvfv_user2
User Field Character 2
 
x(24)
 
 
oid_dvf_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
oid_dvfv_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
oid_dvfv_parent
OID Parent
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_dvf_det
yes
oid_dvf_det
yes
no
 
 
 
oid_dvfv_parent
yes
no
 
 
 
dvfv_fldvalue
yes
no
 ∗
oid_dvfv_det
yes
oid_dvfv_det
yes
no
 
oid_dvfv_parent
no
oid_dvfv_parent
yes
no
 
 
 
dvfv_fldvalue
yes
no
dvf_det
Data Validation Field Detail
 
 
Field Name
Label
Col-Label
Format
Dec
 
dvf__qadc01
 
 
x(24)
 
 
dvf__qadc02
 
 
x(24)
 
 
dvf_fldname
Field Name
 
x(22)
 
 
dvf_level
Field Level
 
99
 
 
dvf_mod_date
Modified Date
Mod Date
99/99/99
 
 
dvf_mod_userid
User ID
 
x(8)
 
 
dvf_user1
User Field Character 1
 
x(24)
 
 
dvf_user2
User Field Character 2
 
x(24)
 
 
oid_dv_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
oid_dvf_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
dvf_fldname
yes
oid_dv_mstr
yes
no
 
 
 
dvf_fldname
yes
no
dvf_level
yes
oid_dv_mstr
yes
no
 
 
 
dvf_level
yes
no
 
oid_dvf_det
yes
oid_dvf_det
yes
no
dvlbx_ref
Label Format Rule Cross Reference
 
 
Field Name
Label
Col-Label
Format
Dec
 
dvlbx__qadc01
 
 
x(24)
 
 
dvlbx__qadc02
 
 
x(24)
 
 
dvlbx_mod_date
Modified Date
 
99/99/99
 
 
dvlbx_mod_userid
User ID
 
x(8)
 
 
dvlbx_pri_lblf_format_id
Primary Format ID
 
X(30)
 
 
dvlbx_sec_lblf_format_id
Secondary Format ID
 
X(30)
 
 
dvlbx_user1
User Field Character 1
 
x(24)
 
 
dvlbx_user2
User Field Character 2
 
x(24)
 
 
oid_dvfv_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
oid_dvlbx_ref
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_dvfv_det
yes
oid_dvfv_det
yes
no
oid_dvlbx_ref
yes
oid_dvlbx_ref
yes
no
dvshx_ref
Data Validation Rule Cross Reference
 
 
Field Name
Label
Col-Label
Format
Dec
 
dvshx__qadc01
 
 
x(24)
 
 
dvshx__qadc02
 
 
x(24)
 
 
dvshx_mod_date
Modified Date
Mod Date
99/99/99
 
 
dvshx_mod_userid
User ID
 
x(8)
 
 
dvshx_user1
User Field Character 1
 
x(24)
 
 
dvshx_user2
User Field Character 2
 
x(24)
 
 
oid_dvfv_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
oid_dvshx_ref
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
oid_shphr_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_dvfv_det
no
oid_dvfv_det
yes
no
 
 
 
oid_shphr_det
yes
no
oid_dvshx_ref
yes
oid_dvshx_ref
yes
no
 
oid_shphr_det
no
oid_shphr_det
yes
no
 
 
 
oid_dvfv_det
yes
no
dv_mstr
Data Validation Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
dv__qadc01
 
 
x(24)
 
 
dv__qadc02
 
 
x(24)
 
 
dv_data_category
Data Category
 
x(22)
 
 
dv_domain
Domain
 
x(8)
 
 
dv_mod_date
Modified Date
Mod Date
99/99/99
 
 
dv_mod_userid
User ID
 
x(8)
 
 
dv_user1
User Field Character 1
 
x(24)
 
 
dv_user2
User Field Character 2
 
x(24)
 
 
oid_dv_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
dv_data_category
yes
dv_domain
yes
no
 
 
 
dv_data_category
yes
no
 
oid_dv_mstr
yes
oid_dv_mstr
yes
no
dybs_mstr
Daybook Set Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
dybs__qadc01
 
 
x(24)
 
 
dybs__qadc02
 
 
x(24)
 
 
dybs_active
Active
 
yes/no
 
 
dybs_adjustment_dybk
Adjustment Daybook
Adj Dybk
x(8)
 
 
dybs_by_site
By Site
 
yes/no
 
 
dybs_code
Daybook Set
 
x(8)
 
 
dybs_credit_dybk
Credit Note Daybook
 
x(8)
 
 
dybs_desc
Description
 
x(24)
 
 
dybs_domain
Domain
 
x(8)
 
 
dybs_interco_dybk
Intercompany Daybook
 
x(8)
 
 
dybs_invoices_dybk
Invoice Daybook
 
x(8)
 
 
dybs_mod_date
Modified Date
Mod Date
99/99/99
 
 
dybs_mod_userid
User ID
 
x(8)
 
 
dybs_neg_crcn_dybk
Correction Credit Note (Negative)
 
x(8)
 
 
dybs_neg_criv_dybk
Correction Invoice (Negative)
 
x(8)
 
 
dybs_pos_crcn_dybk
Correction Credit Note (Positive)
 
x(8)
 
 
dybs_pos_criv_dybk
Correction Invoice (Positive)
 
x(8)
 
 
dybs_site
Site
 
x(8)
 
 
dybs_site_from
Site From
 
x(8)
 
 
dybs_site_to
Site To
 
x(8)
 
 
dybs_type
Type
 
x(2)
 
 
dybs_user1
User Field Character 1
 
x(24)
 
 
dybs_user2
User Field Character 2
 
x(24)
 
 
oid_dybs_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
dybs_active
no
dybs_domain
yes
no
 
 
 
dybs_code
yes
no
 
 
 
dybs_active
yes
no
 
 
 
dybs_by_site
yes
no
dybs_code
yes
dybs_domain
yes
no
 
 
 
dybs_code
yes
no
 
 
 
dybs_site
yes
no
 
oid_dybs_mstr
yes
oid_dybs_mstr
yes
no
dyd_mstr
General Ledger Default Daybook Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
dyd__qadc01
 
 
x(8)
 
 
dyd_doc_type
Doc Type
 
x(8)
 
 
dyd_domain
Domain
 
x(8)
 
 
dyd_dy_code
Daybook
 
x(8)
 
 
dyd_entity_fr
From Entity
 
x(20)
 
 
dyd_entity_to
To Entity
 
x(20)
 
 
dyd_tr_type
Trans Type
Trans
x(2)
 
 
dyd_user1
Ufld1
 
x(8)
 
 
dyd_user2
Ufld2
 
x(8)
 
 
oid_dyd_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
dyd_type
yes
dyd_domain
yes
no
 
 
 
dyd_tr_type
yes
no
 
 
 
dyd_doc_type
yes
no
 
 
 
dyd_entity_fr
yes
no
 
 
 
dyd_entity_to
yes
no
 
oid_dyd_mstr
yes
oid_dyd_mstr
yes
no
dy_mstr
General Ledger Daybook Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
dy__qadc01
 
 
x(8)
 
 
dy_active
Active
 
yes/no
 
 
dy_desc
Desc
 
x(40)
 
 
dy_domain
Domain
 
x(8)
 
 
dy_dy_code
Daybook
 
x(8)
 
 
dy_last_entcen
Central Last Entry
Central Entry
x(40)
 
 
dy_last_entdet
Daybook Last Entry
Daybook Entry
x(40)
 
 
dy_next_pgcen
Central Next Page
Central Page
>>>>>>>9
 
 
dy_next_pgdet
Daybook Next Page
Daybook Page
>>>>>>>9
 
 
dy_nrm_seg
Daybook Segment in NRM
 
x(16)
 
 
dy_type
Daybook Type
 
x(30)
 
 
dy_user1
Ufld1
 
x(8)
 
 
dy_user2
Ufld2
 
x(8)
 
 
oid_dy_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
dy_code
yes
dy_domain
yes
no
 
 
 
dy_dy_code
yes
no
 
oid_dy_mstr
yes
oid_dy_mstr
yes
no
ea_mstr
Earnings Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
ea__qad01
 
 
yes/no
 
 
ea__qad02
 
 
yes/no
 
 
ea__qad03
 
 
yes/no
 
 
ea__qad04
 
 
yes/no
 
 
ea__qad05
 
 
yes/no
 
 
ea__qad06
 
 
yes/no
 
 
ea_acc
Default Account
Account
x(8)
 
 
ea_cc
Default Cost Ctr
CC
x(4)
 
 
ea_desc
Description
 
x(24)
 
 
ea_domain
Domain
 
x(8)
 
 
ea_earn
Earnings Code
Earn
x(4)
 
 
ea_fed_yn
Piece Rate
 
yes/no
 
 
ea_mod_date
Modified Date
Mod Date
99/99/99
 
 
ea_piece
Piece Rate
Pc
yes/no
 
 
ea_rate
Pay Rate Multiplier
Mult
->>>.99<<
10
 
ea_reg_earn
Majority earnings code
Major!Earn
x(4)
 
 
ea_sub
Default Sub-Account
Sub-Acct
x(8)
 
 
ea_type
Earnings Type
Type
x(1)
 
 
ea_user1
Ufld1
 
x(8)
 
 
ea_user2
Ufld2
 
x(8)
 
 
ea_userid
User ID
 
x(8)
 
 
oid_ea_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
ea_desc
yes
ea_domain
yes
no
 
 
 
ea_desc
yes
no
 
 
 
ea_earn
yes
no
ea_earn
yes
ea_domain
yes
no
 
 
 
ea_earn
yes
no
 
oid_ea_mstr
yes
oid_ea_mstr
yes
no
eca_mstr
Engineering Change Approval Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
eca__qad01
First Rec
 
yes/no
 
 
eca__qad02
 
 
99/99/99
 
 
eca__qad03
ReRoute Permission
ReRoute
x(8)
 
 
eca__qad04
 
 
x(8)
 
 
eca__qad05
 
 
x(8)
 
 
eca_code
Approval Code
Approval
x(8)
 
 
eca_domain
Domain
 
x(8)
 
 
eca_group
Group
 
x(8)
 
 
eca_mod_date
Modified Date
Mod Date
99/99/99
 
 
eca_reroute
Re-Approval
Re
>9
 
 
eca_seq
Sequence
Seq
>>9
 
 
eca_user1
Ufld1
 
x(8)
 
 
eca_user2
Ufld2
 
x(8)
 
 
eca_userid
User ID
 
x(8)
 
 
oid_eca_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
eca_code_group
yes
eca_domain
yes
no
 
 
 
eca_code
yes
no
 
 
 
eca_group
yes
no
 
oid_eca_mstr
yes
oid_eca_mstr
yes
no
ecd1_det
Engineering Change Product Structure Detail
 
 
Field Name
Label
Col-Label
Format
Dec
 
ecd1__qad01
Deactivate
D
yes/no
 
 
ecd1__qad02
Start
 
99/99/99
 
 
ecd1__qad03
Structure Type
T
x(8)
 
 
ecd1__qad04
Mandatory
 
x(8)
 
 
ecd1__qad05
Default Option
Default
x(8)
 
 
ecd1_batch
Batch Size
 
>>>,>>>,>>9.9<<<<<<<<
10
 
ecd1_batch_pct
Batch Percent
Batch %
->>>>9.9<<<<%
10
 
ecd1_batch_um
UM
 
x(2)
 
 
ecd1_cmtindx
Comment Index
Comment
>>>>>>>9
 
 
ecd1_comp
Component Item
 
x(18)
 
 
ecd1_deactivate
Deactivate
 
yes/no
 
 
ecd1_default
Default Option
Default
yes/no
 
 
ecd1_domain
Domain
 
x(8)
 
 
ecd1_fcst_pct
Forecast
Fcst
>>9.99%
10
 
ecd1_group
Option Group
Group
x(8)
0
 
ecd1_item_no
Number
 
->>>>>>>
 
 
ecd1_lt_off
LT Offset
LTO
->>
 
 
ecd1_mandatory
Mandatory
 
yes/no
 
 
ecd1_mod_date
Modified Date
Mod Date
99/99/99
 
 
ecd1_nbr
ECN Number
ECN
x(8)
 
 
ecd1_op
Op
 
>>>>>>
 
 
ecd1_par
Parent Item
 
x(18)
 
 
ecd1_process
Process
 
x(8)
 
 
ecd1_ps_code
Structure Type
T
x(1)
0
 
ecd1_psprocess
Process
 
x(8)
0
 
ecd1_qty_per
Qty Per
 
->,>>>,>>9.9<<<<<<<<
10
 
ecd1_qty_per_b
Qty Per
 
->,>>>,>>9.9<<<<<<<<
10
 
ecd1_qty_type
Qty Type
T
x(1)
 
 
ecd1_recindx
Cross Reference
Xref
>>>>>>>9
 
 
ecd1_ref
Reference
 
x(12)
 
 
ecd1_rmks
Remarks
 
x(24)
 
 
ecd1_scrp_pct
Scrap
 
>>9.99%
10
 
ecd1_start
Start Date
Start
99/99/99
 
 
ecd1_user1
Ufld1
 
x(8)
 
 
ecd1_user2
Ufld2
 
x(8)
 
 
ecd1_userid
User ID
 
x(8)
 
 
oid_ecd1_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
ecd1_comp_par
no
ecd1_domain
yes
no
 
 
 
ecd1_nbr
yes
no
 
 
 
ecd1_comp
yes
no
 
 
 
ecd1_par
yes
no
ecd1_par_comp
yes
ecd1_domain
yes
no
 
 
 
ecd1_nbr
yes
no
 
 
 
ecd1_par
yes
no
 
 
 
ecd1_comp
yes
no
 
 
 
ecd1_ref
yes
no
 
oid_ecd1_det
yes
oid_ecd1_det
yes
no
ecd2_det
Engineering Change Routing Detail
 
 
Field Name
Label
Col-Label
Format
Dec
 
ecd2__qad01
 
 
yes/no
 
 
ecd2__qad02
 
 
99/99/99
 
 
ecd2__qad03
 
 
x(8)
 
 
ecd2__qad04
 
 
x(8)
 
 
ecd2__qad05
 
 
x(8)
 
 
ecd2_batch
Batch Qty
 
>>,>>>,>>9.9<<<<<<<<
10
 
ecd2_cmtindx
Comment Index
Comment
>>>>>>>9
 
 
ecd2_desc
Description
 
x(24)
 
 
ecd2_domain
Domain
 
x(8)
 
 
ecd2_mch
Machine
 
x(8)
 
 
ecd2_mch_op
Machines per Op
Mach / Op
->,>>>,>>9
 
 
ecd2_men_mch
Run Crew
 
->>,>>9.99
10
 
ecd2_mod_date
Modified Date
Mod Date
99/99/99
 
 
ecd2_nbr
ECN Number
ECN
x(8)
 
 
ecd2_op
Operation
Op
>>>>9
 
 
ecd2_process
Process
 
x(8)
 
 
ecd2_recindx
Cross Reference
Xref
>>>>>>>9
 
 
ecd2_routing
Routing Code
 
x(18)
 
 
ecd2_run
Run Time
Run
>>>,>>>,>>9.9<<<<<<<<
10
 
ecd2_run_per_b
Run Time/Batch Qty
R/B
>>>,>>>,>>9.9<<<<<<<<
10
 
ecd2_setup
Setup Time
Setup
>,>>9.9<<
10
 
ecd2_setup_men
Setup Crew
 
->>,>>9.99
10
 
ecd2_std_op
Standard Operation
Std Op
x(8)
 
 
ecd2_sub_cost
Subcontract Cost
Subcontract
>>>>,>>>,>>9.99<<<
10
 
ecd2_subcntrt
Subcontract
Sub
yes/no
 
 
ecd2_tool
Tool Code
Tool
x(8)
 
 
ecd2_user1
Ufld1
 
x(8)
 
 
ecd2_user2
Ufld2
 
x(8)
 
 
ecd2_userid
User ID
 
x(8)
 
 
ecd2_vend
Supplier
 
x(8)
 
 
ecd2_wkctr
Work Center
Work Ctr
x(8)
 
 
ecd2_yield_pct
Yield%
 
>>9.99%
10
 
oid_ecd2_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
ecd2_ro_op
yes
ecd2_domain
yes
no
 
 
 
ecd2_nbr
yes
no
 
 
 
ecd2_routing
yes
no
 
 
 
ecd2_op
yes
no
 
oid_ecd2_det
yes
oid_ecd2_det
yes
no
ecd3_det
Engineering Change Text File Detail
 
 
Field Name
Label
Col-Label
Format
Dec
 
ecd3__qad01
 
 
yes/no
 
 
ecd3__qad02
 
 
99/99/99
 
 
ecd3__qad03
Reference
 
x(40)
 
 
ecd3__qad04
 
 
x(8)
 
 
ecd3__qad05
 
 
x(8)
 
 
ecd3_cmtindx
Comment Index
Comment
>>>>>>>9
 
 
ecd3_domain
Domain
 
x(8)
 
 
ecd3_mod_date
Modified Date
Mod Date
99/99/99
 
 
ecd3_nbr
ECN Number
ECN
x(8)
 
 
ecd3_order
Order
 
->>>>>>>
 
 
ecd3_process
Process
 
x(8)
 
 
ecd3_user1
Ufld1
 
x(8)
 
 
ecd3_user2
Ufld2
 
x(8)
 
 
ecd3_userid
User ID
 
x(8)
 
 
oid_ecd3_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
ecd3_cmt
yes
ecd3_domain
yes
no
 
 
 
ecd3_nbr
yes
no
 
 
 
ecd3_cmtindx
yes
no
 
oid_ecd3_det
yes
oid_ecd3_det
yes
no
ecd4_det
Product Change Control Test Results Detail
 
 
Field Name
Label
Col-Label
Format
Dec
 
ecd4__qadc01
 
 
x(8)
 
 
ecd4__qadi01
 
 
>>>>>>>>9
 
 
ecd4_attach
Attachments
 
X(70)
 
 
ecd4_attribute
Attribute
 
X(8)
 
 
ecd4_cmtindx
Comment Index
Comment
>>>>>>>>9
 
 
ecd4_doc_nbr
Documnet Number
 
>>>>>>>>9
 
 
ecd4_doc_rev
Revision
Rev
>>>9.<<<
10
 
ecd4_domain
Domain
 
x(8)
 
 
ecd4_maximum
Maximum Value
 
X(8)
 
 
ecd4_minimum
Minimum Value
 
X(8)
0
 
ecd4_nbr
Document
 
x(8)
0
 
ecd4_op
Operation
Op
>>>>9
 
 
ecd4_part
Item Number
 
x(18)
0
 
ecd4_property
Property Name
 
x(24)
0
 
ecd4_propertyum
Unit of Measure
UOM
x(12)
0
 
ecd4_routing
Routing
 
x(18)
0
 
ecd4_sequence
Test Sequence
 
x(8)
0
 
ecd4_spec_det
Specification
 
x(26)
0
 
ecd4_specid
Internal QSpec Number
 
>>>>>>>>9
 
 
ecd4_target
Target Value
 
X(8)
 
 
ecd4_testmthd
Test Method
 
X(8)
0
 
ecd4_user1
Ufld1
 
x(8)
0
 
ecd4_user2
Ufld2
 
x(8)
0
 
oid_ecd4_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
ecd4_nbr_specid
no
ecd4_domain
yes
no
 
 
 
ecd4_nbr
yes
no
 
 
 
ecd4_specid
yes
no
 
 
 
ecd4_sequence
yes
no
ecd4_part_seq
yes
ecd4_domain
yes
no
 
 
 
ecd4_part
yes
no
 
 
 
ecd4_routing
yes
no
 
 
 
ecd4_op
yes
no
 
 
 
ecd4_nbr
yes
no
 
 
 
ecd4_sequence
yes
no
 
oid_ecd4_det
yes
oid_ecd4_det
yes
no
ecd5_det
Product Change Control Item Routing Detail
 
 
Field Name
Label
Col-Label
Format
Dec
 
ecd5__qadc01
 
 
x(8)
 
 
ecd5_appr_id
Approved By
Appr ID
x(8)
0
 
ecd5_apprdate
Approved Date
Approved
99/99/99
 
 
ecd5_batch
Batch Qty
 
>>,>>>,>>9.9<<<<<<<<
10
 
ecd5_bom_code
BOM/Formula
 
x(18)
0
 
ecd5_burden
Burden Cost
 
>>>>,>>>,>>9.99<<<
10
 
ecd5_cmtindx
Comment Index
Comment
>>>>>>>9
 
 
ecd5_domain
Domain
 
x(8)
 
 
ecd5_end
End Effective
End Eff
99/99/99
 
 
ecd5_labor
Labor Cost
 
>>>>,>>>,>>9.99<<<
10
 
ecd5_material
Material Cost
 
>>>>,>>>,>>9.99<<<
10
 
ecd5_mod_date
Modified Date
Mod Date
99/99/99
 
 
ecd5_overhead
Overhead
 
>>>>,>>>,>>9.99<<<
10
 
ecd5_part
Item Number
 
x(18)
0
 
ecd5_qspec_id
QSpecid
 
>>>>>>>>9
 
 
ecd5_qspec_nbr
QSpec Number
 
X(40)
 
 
ecd5_routing
Routing Code
 
x(18)
0
 
ecd5_site
Site
 
x(8)
0
 
ecd5_start
Start Effective
Start Eff
99/99/99
 
 
ecd5_subcontract
Subcontract Cost
Subcontract
>>>>,>>>,>>9.99<<<
10
 
ecd5_total_cost
Total Cost
 
>>>>,>>>,>>9.99<<<
10
 
ecd5_user1
Ufld1
 
x(8)
0
 
ecd5_user2
Ufld2
 
x(8)
0
 
ecd5_userid
User ID
 
x(8)
0
 
oid_ecd5_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
ecd5_bom_code
no
ecd5_domain
yes
no
 
 
 
ecd5_bom_code
yes
no
 
 
 
ecd5_part
yes
no
 
 
 
ecd5_site
yes
no
ecd5_part
yes
ecd5_domain
yes
no
 
 
 
ecd5_part
yes
no
 
 
 
ecd5_site
yes
no
 
 
 
ecd5_routing
yes
no
 
 
 
ecd5_bom_code
yes
no
 
 
 
ecd5_start
yes
no
 
ecd5_routing
no
ecd5_domain
yes
no
 
 
 
ecd5_routing
yes
no
 
 
 
ecd5_part
yes
no
 
 
 
ecd5_site
yes
no
 
oid_ecd5_det
yes
oid_ecd5_det
yes
no
ecd9_det
Engineering Change Approval Detail
 
 
Field Name
Label
Col-Label
Format
Dec
 
ecd9__qad01
First Rec
 
yes/no
 
 
ecd9__qad02
 
 
99/99/99
 
 
ecd9__qad03
ReRoute Level
Re Lvl
x(8)
 
 
ecd9__qad04
ReRoute
 
x(8)
 
 
ecd9__qad05
Approver ID
Approver
x(8)
 
 
ecd9_appr_date
Approved Date
Date!Approved
99/99/99
 
 
ecd9_approved
Approved
 
yes/no
 
 
ecd9_cmtindx
Comment Index
Comment
>>>>>>>9
 
 
ecd9_domain
Domain
 
x(8)
 
 
ecd9_group
Group
 
x(8)
 
 
ecd9_mod_date
Modified Date
Mod Date
99/99/99
 
 
ecd9_nbr
ECN Number
ECN
x(8)
 
 
ecd9_seq
Sequence
Seq
>>9
 
 
ecd9_status
Status
 
x(8)
 
 
ecd9_user1
Ufld1
 
x(8)
 
 
ecd9_user2
Ufld2
 
x(8)
 
 
ecd9_userid
User ID
 
x(8)
 
 
oid_ecd9_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
ecd9_group
yes
ecd9_domain
yes
no
 
 
 
ecd9_nbr
yes
no
 
 
 
ecd9_group
yes
no
 
oid_ecd9_det
yes
oid_ecd9_det
yes
no
ecd_det
Engineering Change Item Detail
 
 
Field Name
Label
Col-Label
Format
Dec
 
ecd__qad01
Parent
Par
yes/no
 
 
ecd__qad02
 
 
99/99/99
 
 
ecd__qad03
 
 
x(8)
 
 
ecd__qad04
 
 
x(8)
 
 
ecd__qad05
 
 
x(8)
 
 
ecd_break_cat
Price Break Cat
 
x(18)
 
 
ecd_cmtindx
Comment Index
Comment
>>>>>>>9
 
 
ecd_domain
Domain
 
x(8)
 
 
ecd_draw
Drawing
 
x(18)
 
 
ecd_drwg_loc
Drawing Loc
Drwg Loc
x(8)
 
 
ecd_drwg_size
Drwg Size
DS
x(2)
 
 
ecd_dsgn_grp
Design Group
Dsgn Grp
x(8)
 
 
ecd_end
End
 
99/99/99
 
 
ecd_group
Group
 
x(8)
 
 
ecd_inv_dspn
Disposition
 
x(12)
 
 
ecd_mod_date
Modified Date
Mod Date
99/99/99
 
 
ecd_nbr
ECO Number
ECO
x(8)
 
 
ecd_new
New
 
yes/no
 
 
ecd_new_rev
New Rev
New
x(4)
 
 
ecd_old_rev
Old Rev
Old
x(4)
 
 
ecd_part
Item Number
 
x(18)
 
 
ecd_part_type
Item Type
Type
x(8)
 
 
ecd_process
Process
 
x(8)
 
 
ecd_prodline
Prod Line
Line
x(4)
 
 
ecd_start
Start
 
99/99/99
 
 
ecd_status
Status
St
x(8)
 
 
ecd_user1
Ufld1
 
x(8)
 
 
ecd_user2
Ufld2
 
x(8)
 
 
ecd_userid
User ID
 
x(8)
 
 
oid_ecd_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
ecd_det
yes
ecd_domain
yes
no
 
 
 
ecd_nbr
yes
no
 
 
 
ecd_part
yes
no
 
 
 
ecd_new
yes
no
 
ecd_part_rev
no
ecd_domain
yes
no
 
 
 
ecd_part
yes
no
 
 
 
ecd_new_rev
yes
no
 
oid_ecd_det
yes
oid_ecd_det
yes
no
ecl_list
Engineering Change Master Lists
 
 
Field Name
Label
Col-Label
Format
Dec
 
ecl__qad01
First Rec
 
yes/no
 
 
ecl__qad02
End Date
 
99/99/99
 
 
ecl__qad03
 
 
x(8)
 
 
ecl__qad04
 
 
x(8)
 
 
ecl__qad05
 
 
x(8)
 
 
ecl_copies
Copies
Cp
>>9
 
 
ecl_desc
Description
 
x(24)
 
 
ecl_dev
Output
 
x(8)
 
 
ecl_domain
Domain
 
x(8)
 
 
ecl_group
Group
 
x(8)
 
 
ecl_id
User Id
 
x(8)
 
 
ecl_mod_date
Modified Date
Mod Date
99/99/99
 
 
ecl_type
Type
T
x(2)
 
 
ecl_user1
Ufld1
 
x(8)
 
 
ecl_user2
Ufld2
 
x(8)
 
 
ecl_userid
User ID
 
x(8)
 
 
oid_ecl_list
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
ecl_id_type
yes
ecl_domain
yes
no
 
 
 
ecl_id
yes
no
 
 
 
ecl_group
yes
no
 
 
 
ecl_type
yes
no
ecl_type_id
yes
ecl_domain
yes
no
 
 
 
ecl_type
yes
no
 
 
 
ecl_group
yes
no
 
 
 
ecl_id
yes
no
 
oid_ecl_list
yes
oid_ecl_list
yes
no