|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
nfelg__qadc01
|
|
|
x(24)
|
|
|
|
nfelg__qadc02
|
|
|
x(24)
|
|
|
|
nfelg_action
|
Action
|
|
x(2)
|
|
|
|
nfelg_cmtindx
|
Comment Index
|
Comment
|
>>>>>>>9
|
|
|
|
nfelg_ext_time
|
Ext Time
|
|
x(25)
|
|
|
|
nfelg_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
nfelg_mod_userid
|
User ID
|
|
x(8)
|
|
|
|
nfelg_msg_date
|
Message Date
|
Msg Date
|
99/99/99
|
|
|
|
nfelg_msg_desc
|
Message Description
|
Msg
|
x(80)
|
|
|
|
nfelg_msg_nbr
|
Message Number
|
Msg Nbr
|
>>>>9
|
|
|
|
nfelg_msg_time
|
Message Time
|
Msg Time
|
>>>>>>>>9
|
|
|
|
nfelg_nfe_auth_nbr
|
Authorization Number
|
Auth Nbr
|
x(15)
|
|
|
|
nfelg_seq
|
Sequence Nbr
|
|
>>>>>>>>9
|
|
|
|
nfelg_user1
|
User Field Character 1
|
|
x(24)
|
|
|
|
nfelg_user2
|
User Field Character 2
|
|
x(24)
|
|
|
|
nfelg_ws_ver
|
Web Service Version
|
|
x(4)
|
|
|
|
oid_lgd_mstr
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
oid_nfelg_hist
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
nfelg_msg
|
no
|
oid_lgd_mstr
|
yes
|
no
|
|
|
|
|
nfelg_msg_nbr
|
yes
|
no
|
|
|
|
|
nfelg_msg_date
|
yes
|
no
|
|
|
|
|
nfelg_msg_time
|
yes
|
no
|
|
|
oid_nfelg_hist
|
yes
|
oid_nfelg_hist
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
nfews__qadc01
|
|
|
x(24)
|
|
|
|
nfews__qadc02
|
|
|
x(24)
|
|
|
|
nfews_action
|
Action
|
|
x(2)
|
|
|
|
nfews_domain
|
Domain
|
|
x(8)
|
|
|
|
nfews_env_type
|
Environment Type
|
|
x(2)
|
|
|
|
nfews_mod_date
|
Last Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
nfews_mod_userid
|
Last Modified User Id
|
|
x(8)
|
|
|
|
nfews_state
|
State
|
|
x(4)
|
|
|
|
nfews_user1
|
User Field Character 1
|
|
x(24)
|
|
|
|
nfews_user2
|
User Field Character 2
|
|
x(24)
|
|
|
|
nfews_ws_addr
|
Web Service Address
|
|
x(120)
|
|
|
|
nfews_ws_ver
|
Web Service Version
|
|
x(4)
|
|
|
|
oid_nfews_mstr
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
nfews_state_ver
|
yes
|
nfews_domain
|
yes
|
no
|
|
|
|
|
nfews_state
|
yes
|
no
|
|
|
|
|
nfews_env_type
|
yes
|
no
|
|
|
|
|
nfews_action
|
yes
|
no
|
|
|
|
|
nfews_ws_ver
|
yes
|
no
|
|
|
oid_nfews_mstr
|
yes
|
oid_nfews_mstr
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
nffcic__qadc01
|
|
|
x(24)
|
|
|
|
nffcic__qadc02
|
|
|
x(24)
|
|
|
|
nffcic__qadd01
|
|
|
->>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
nffcic__qadt01
|
|
|
99/99/99
|
|
|
|
nffcic_domain
|
Domain
|
|
x(8)
|
|
|
|
nffcic_fci_code
|
FCI Code
|
|
x(36)
|
|
|
|
nffcic_imp_ctt_pct
|
% Importation Content
|
|
->>9.9999
|
10
|
|
|
nffcic_imp_price
|
Imported Portion Unit Price
|
|
->>>,>>>,>>9.9999
|
10
|
|
|
nffcic_mod_date
|
Last Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
nffcic_mod_userid
|
Last Modified User Id
|
|
x(8)
|
|
|
|
nffcic_out_inter_price
|
Imported Portion Unit Price
|
|
->>>,>>>,>>9.9999
|
10
|
|
|
nffcic_part
|
Item code
|
|
x(18)
|
|
|
|
nffcic_rec_code
|
Receipt Code
|
|
x(36)
|
|
|
|
nffcic_rec_date
|
Receipt Date
|
|
99/99/99
|
|
|
|
nffcic_rec_time
|
Receipt time
|
|
>>>>>>>9
|
|
|
|
nffcic_site
|
Site code
|
|
x(8)
|
|
|
|
nffcic_update_date
|
Update Date
|
|
99/99/99
|
|
|
|
nffcic_update_time
|
Update time
|
|
>>>>>>>9
|
|
|
|
nffcic_user1
|
User Field Character 1
|
|
x(24)
|
|
|
|
nffcic_user2
|
User Field Character 2
|
|
x(24)
|
|
|
|
nffcic_val_date
|
Validation Date
|
|
99/99/99
|
|
|
|
nffcic_val_time
|
Validation time
|
|
>>>>>>>9
|
|
|
|
oid_nffcic_det
|
Unique application generated record identifier.
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
nffcic_main
|
yes
|
nffcic_domain
|
yes
|
no
|
|
|
|
|
nffcic_part
|
yes
|
no
|
|
|
|
|
nffcic_site
|
yes
|
no
|
|
|
|
|
nffcic_rec_date
|
yes
|
no
|
|
|
|
|
nffcic_rec_time
|
yes
|
no
|
|
|
oid_nffcic_det
|
yes
|
oid_nffcic_det
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
nffcih__qadc01
|
|
|
x(24)
|
|
|
|
nffcih__qadc02
|
|
|
x(24)
|
|
|
|
nffcih__qadd01
|
|
|
->>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
nffcih__qadt01
|
|
|
99/99/99
|
|
|
|
nffcih_calc_date
|
Calc Date
|
|
99/99/99
|
|
|
|
nffcih_calc_time
|
Calc time
|
|
>>>>>>>9
|
|
|
|
nffcih_domain
|
Domain
|
|
x(8)
|
|
|
|
nffcih_fci_code
|
FCI Code
|
|
x(36)
|
|
|
|
nffcih_imp_ctt_pct
|
% Importation Content
|
|
->>9.9999
|
10
|
|
|
nffcih_imp_price
|
Imported Portion Unit Price
|
|
->>>,>>>,>>9.9999
|
10
|
|
|
nffcih_mod_date
|
Last Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
nffcih_mod_userid
|
Last Modified User Id
|
|
x(8)
|
|
|
|
nffcih_out_inter_price
|
Imported Portion Unit Price
|
|
->>>,>>>,>>9.9999
|
10
|
|
|
nffcih_part
|
Item code
|
|
x(18)
|
|
|
|
nffcih_pend_fci
|
Pending FCI Code ?
|
|
Yes/No
|
|
|
|
nffcih_pt_origin
|
Origin Code
|
|
x(01)
|
|
|
|
nffcih_site
|
Site code
|
|
x(8)
|
|
|
|
nffcih_user1
|
User Field Character 1
|
|
x(24)
|
|
|
|
nffcih_user2
|
User Field Character 2
|
|
x(24)
|
|
|
|
oid_nffcih_det
|
Unique application generated record identifier.
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
nffcih_fci_code
|
no
|
nffcih_domain
|
yes
|
no
|
|
|
|
|
nffcih_part
|
yes
|
no
|
|
|
|
|
nffcih_site
|
yes
|
no
|
|
|
|
|
nffcih_fci_code
|
yes
|
no
|
|
∗
|
nffcih_main
|
yes
|
nffcih_domain
|
yes
|
no
|
|
|
|
|
nffcih_part
|
yes
|
no
|
|
|
|
|
nffcih_site
|
yes
|
no
|
|
|
|
|
nffcih_calc_date
|
yes
|
no
|
|
|
|
|
nffcih_calc_time
|
yes
|
no
|
|
|
nffcih_pend_fci
|
no
|
nffcih_domain
|
yes
|
no
|
|
|
|
|
nffcih_part
|
yes
|
no
|
|
|
|
|
nffcih_site
|
yes
|
no
|
|
|
|
|
nffcih_pend_fci
|
yes
|
no
|
|
|
oid_nffcih_det
|
yes
|
oid_nffcih_det
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
nffi__qadc01
|
|
|
x(24)
|
|
|
|
nffi__qadc02
|
|
|
x(24)
|
|
|
|
nffi__qadd01
|
|
|
->>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
nffi__qadl01
|
|
|
yes/no
|
|
|
|
nffi__qadt01
|
|
|
99/99/99
|
|
|
|
nffi_attrib
|
Fiscal Attribute
|
|
yes/no
|
|
|
|
nffi_dataset
|
Target Dataset
|
Dataset
|
x(16)
|
|
|
|
nffi_domain
|
Domain
|
|
x(8)
|
|
|
|
nffi_fi_type
|
Fiscal Interface Type
|
Fiscal Int Type
|
x(16)
|
|
|
|
nffi_key_code
|
Key Code
|
|
x(16)
|
|
|
|
nffi_mod_date
|
Last Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
nffi_mod_userid
|
Last Modified User Id
|
|
x(8)
|
|
|
|
nffi_user1
|
User Field Character 1
|
|
x(24)
|
|
|
|
nffi_user2
|
User Field Character 2
|
|
x(24)
|
|
|
|
oid_nffi_mstr
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
nffi_key
|
no
|
nffi_domain
|
yes
|
no
|
|
|
|
|
nffi_dataset
|
yes
|
no
|
|
|
|
|
nffi_fi_type
|
yes
|
no
|
|
|
|
|
nffi_key_code
|
yes
|
no
|
|
∗
|
oid_nffi_mstr
|
yes
|
oid_nffi_mstr
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
nfptf__qadc01
|
|
|
x(24)
|
|
|
|
nfptf__qadc02
|
|
|
x(24)
|
|
|
|
nfptf__qadd01
|
|
|
->>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
nfptf__qadt01
|
|
|
99/99/99
|
|
|
|
nfptf_domain
|
Domain
|
|
x(8)
|
|
|
|
nfptf_fiscal_type
|
Fiscal Type
|
|
x(2)
|
|
|
|
nfptf_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
nfptf_mod_userid
|
Last Modified User Id
|
|
x(8)
|
|
|
|
nfptf_origin
|
Country of Origin
|
|
x(12)
|
|
|
|
nfptf_part
|
Item Number
|
|
x(18)
|
|
|
|
nfptf_site
|
Site
|
|
x(8)
|
|
|
|
nfptf_user1
|
Ufld1
|
|
x(8)
|
|
|
|
nfptf_user2
|
Ufld2
|
|
x(8)
|
|
|
|
oid_nfptf_det
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
nfptf_part
|
yes
|
nfptf_domain
|
yes
|
no
|
|
|
|
|
nfptf_part
|
yes
|
no
|
|
|
|
|
nfptf_site
|
yes
|
no
|
|
|
nfptf_site
|
no
|
nfptf_domain
|
yes
|
no
|
|
|
|
|
nfptf_site
|
yes
|
no
|
|
|
|
|
nfptf_part
|
yes
|
no
|
|
∗
|
oid_nfptf_det
|
yes
|
oid_nfptf_det
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
nf__qadc01
|
|
|
x(24)
|
|
|
|
nf__qadc02
|
|
|
x(24)
|
|
|
|
nf__qadd01
|
|
|
->>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
nf__qadt01
|
|
|
99/99/99
|
|
|
|
nf_est_tot_tax_amt
|
Estimated total Tax amount
|
Est Tot Tax Amt
|
->>>>,>>>,>>9.99<
|
10
|
|
|
nf_exp_bol_date
|
Exportation BOL Date
|
|
99/99/99
|
|
|
|
nf_exp_bol_nbr
|
Exportation BOL Number
|
|
x(18)
|
|
|
|
nf_exp_bol_type
|
Exportation BOL Type
|
|
x(1)
|
|
|
|
nf_exp_doc_date
|
DE Date
|
|
99/99/99
|
|
|
|
nf_exp_doc_nbr
|
DE Number
|
|
x(11)
|
|
|
|
nf_exp_prim_effdate
|
Orig Effective Date
|
Orig Eff Date
|
99/99/99
|
|
|
|
nf_exp_prim_key_nbr
|
Access Key Number
|
Acc Key
|
x(44)
|
|
|
|
nf_exp_prim_nbr
|
Orig Doc Nbr
|
|
x(12)
|
|
|
|
nf_exp_prim_shipfrom
|
Orig Ship From
|
|
x(8)
|
|
|
|
nf_exp_prim_shipto
|
Orig Ship To
|
|
x(8)
|
|
|
|
nf_exp_reg_date
|
RE Date
|
|
99/99/99
|
|
|
|
nf_exp_reg_nbr
|
RE Number
|
|
x(12)
|
|
|
|
nf_exp_sign_date
|
Exportation Signature Date
|
|
99/99/99
|
|
|
|
nf_imp_decl_type
|
Importation Declaration Type
|
|
x(1)
|
|
|
|
nf_imp_doc_date
|
Import Doc Date
|
Imp Doc Date
|
99/99/99
|
|
|
|
nf_imp_doc_nbr
|
Import Doc Number
|
Imp Doc
|
x(10)
|
|
|
|
nf_imp_drawback_cons
|
Importation Drawback Concession
|
|
x(20)
|
|
|
|
nf_imp_par_type
|
Imp Partner Type
|
Imp Par Tp
|
x(1)
|
|
|
|
nf_mod_date
|
Last Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
nf_mod_userid
|
Last Modified User Id
|
|
x(8)
|
|
|
|
nf_nfe_auth_date
|
Authorization Date
|
Auth Date
|
99/99/99
|
|
|
|
nf_nfe_auth_nbr
|
Authorization Number
|
Auth Nbr
|
x(15)
|
|
|
|
nf_nfe_auth_time
|
Authorization Time
|
Auth Time
|
>>>>>>>>9
|
|
|
|
nf_nfe_batch_id
|
Batch ID
|
|
x(15)
|
|
|
|
nf_nfe_cancel_date
|
Cancel Date
|
|
99/99/99
|
|
|
|
nf_nfe_cancel_nbr
|
Cancel Protocol Number
|
Cancel Nbr
|
x(15)
|
|
|
|
nf_nfe_cancel_time
|
Cancel Time
|
|
>>>>>>>>9
|
|
|
|
nf_nfe_cmtindx
|
Contingency Comment Index
|
Comment
|
>>>>>>>9
|
|
|
|
nf_nfe_con_date
|
Contingency Mode Date
|
Contingency Date
|
99/99/99
|
|
|
|
nf_nfe_con_nbr
|
Contingency Suppl Number
|
Con Sup Nbr
|
x(36)
|
|
|
|
nf_nfe_con_time
|
Contingency Mode Time
|
Contingency Time
|
>>>>>>>>9
|
|
|
|
nf_nfe_env_type
|
Environment Type
|
Env Type
|
x(2)
|
|
|
|
nf_nfe_iss_type
|
NFe Issue Type
|
Iss Type
|
x(2)
|
|
|
|
nf_nfe_key_nbr
|
Access Key Number
|
Acc Key
|
x(44)
|
|
|
|
nf_nfe_pres_ind
|
NFe presence indicator
|
NFe pres ind
|
x(1)
|
|
|
|
nf_nfe_rec_nbr
|
Receipt Number
|
|
x(15)
|
|
|
|
nf_nfe_usage
|
NFe Usage
|
|
x(1)
|
|
|
|
nf_par_gst_id
|
Tax ID - Federal
|
|
x(18)
|
|
|
|
nf_par_state
|
State
|
St
|
x(2)
|
|
|
|
nf_port_disp
|
Port of Dispatch
|
|
x(60)
|
|
|
|
nf_prim_nfe_key_nbr
|
Access Key Number
|
Acc Key
|
x(44)
|
|
|
|
nf_ship_from_city
|
Shipment from city
|
|
x(60)
|
|
|
|
nf_ship_state
|
Ship State
|
|
x(2)
|
|
|
|
nf_trade_type
|
Trade Type
|
|
x(1)
|
|
|
|
nf_user1
|
User Field Character 1
|
|
x(24)
|
|
|
|
nf_user2
|
User Field Character 2
|
|
x(24)
|
|
|
|
nf_veh_id_state
|
Vehicle ID State
|
|
x(2)
|
|
|
|
oid_lgd_mstr
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
oid_lgd_mstr_exp_prim
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
oid_nf_mstr
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
nf_oid_lgd_mstr
|
yes
|
oid_lgd_mstr
|
yes
|
no
|
|
|
oid_lgd_mstr_exp_prim
|
no
|
oid_lgd_mstr_exp_prim
|
yes
|
no
|
|
|
oid_nf_mstr
|
yes
|
oid_nf_mstr
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
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
|
|
99/99/9999
|
|
|
|
LastModifiedTime
|
Last Modified Time
|
|
99999
|
|
|
|
LastModifiedUser
|
Last Modified User
|
|
x(20)
|
|
|
|
Nomenclature_ID
|
Record ID
|
|
-99999999999
|
|
|
|
NomenclatureCode
|
Code
|
|
x(20)
|
|
|
|
NomenclatureDescription
|
Description
|
|
x(40)
|
|
|
|
NomenclatureIsActive
|
Active
|
|
yes/no
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
Unit_ID
|
Link to Unit
|
|
-99999999999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
ActiveIdx
|
no
|
NomenclatureIsActive
|
yes
|
no
|
|
|
CodeIdx
|
yes
|
NomenclatureCode
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
Nomenclature_ID
|
yes
|
no
|
|
|
UnitIdx
|
no
|
Unit_ID
|
yes
|
no
|
|
|
ViewIndex
|
no
|
NomenclatureIsActive
|
yes
|
no
|
|
|
|
|
NomenclatureCode
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
nrh__qadc01
|
|
|
x(8)
|
|
|
|
nrh_action
|
Action
|
|
x(8)
|
|
|
|
nrh_date
|
Date
|
|
99/99/99
|
|
|
|
nrh_desc
|
Description
|
|
x(40)
|
|
|
|
nrh_domain
|
Domain
|
|
x(8)
|
|
|
|
nrh_inc
|
Incrementing Value
|
|
x(40)
|
|
|
|
nrh_line
|
Line
|
|
>,>>>,>>9
|
|
|
|
nrh_non_inc
|
Non Incrementing Value
|
|
x(40)
|
|
|
|
nrh_number
|
Sequence Value
|
|
x(40)
|
|
|
|
nrh_seqid
|
Sequence ID
|
Id
|
x(8)
|
|
|
|
nrh_time
|
Time
|
|
x(8)
|
|
|
|
nrh_user1
|
Ufld1
|
|
x(8)
|
|
|
|
nrh_user2
|
Ufld2
|
|
x(8)
|
|
|
|
nrh_userid
|
User ID
|
|
x(8)
|
|
|
|
oid_nrh_hist
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
nrh_index
|
yes
|
nrh_domain
|
yes
|
no
|
|
|
|
|
nrh_seqid
|
yes
|
no
|
|
|
|
|
nrh_number
|
yes
|
no
|
|
|
|
|
nrh_action
|
yes
|
no
|
|
|
|
|
nrh_line
|
yes
|
no
|
|
|
oid_nrh_hist
|
yes
|
oid_nrh_hist
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
nr__qadc01
|
|
|
x(8)
|
|
|
|
nr_allow_discard
|
Allow Discarding
|
|
yes/no
|
|
|
|
nr_allow_void
|
Allow Voiding
|
|
yes/no
|
|
|
|
nr_archived
|
Archived
|
|
yes/no
|
|
|
|
nr_curr_effdate
|
Value Effective Date
|
|
99/99/99
|
|
|
|
nr_dataset
|
Target Dataset
|
Dataset
|
x(16)
|
|
|
|
nr_desc
|
Description
|
|
x(40)
|
|
|
|
nr_domain
|
Domain
|
|
x(8)
|
|
|
|
nr_effdate
|
Effective Date
|
|
99/99/99
|
|
|
|
nr_exp_date
|
Expiration Date
|
|
99/99/99
|
|
|
|
nr_internal
|
Internal
|
|
yes/no
|
|
|
|
nr_next_set
|
Next Value Set
|
|
yes/no
|
|
|
|
nr_seg_format
|
Format
|
|
x(40)
|
|
|
|
nr_seg_ini
|
Initial Value
|
|
x(40)
|
|
|
|
nr_seg_max
|
Maximum Value
|
|
x(40)
|
|
|
|
nr_seg_min
|
Minimum Value
|
|
x(40)
|
|
|
|
nr_seg_nbr
|
Segment Number
|
Seg
|
x(40)
|
|
|
|
nr_seg_rank
|
Segment rank
|
|
x(40)
|
|
|
|
nr_seg_reset
|
Reset Value
|
|
x(40)
|
|
|
|
nr_seg_type
|
Type
|
|
x(8)
|
|
|
|
nr_seg_value
|
Next Value
|
|
x(40)
|
|
|
|
nr_segcount
|
Segment Count
|
Segs
|
>9
|
|
|
|
nr_seqid
|
Sequence Id
|
Id
|
x(8)
|
|
|
|
nr_user1
|
Ufld1
|
|
x(8)
|
|
|
|
nr_user2
|
Ufld2
|
|
x(8)
|
|
|
|
nr_valuemask
|
Valuemask
|
|
x(40)
|
|
|
|
oid_nr_mstr
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
nr_seqid
|
yes
|
nr_domain
|
yes
|
no
|
|
|
|
|
nr_seqid
|
yes
|
no
|
|
|
oid_nr_mstr
|
yes
|
oid_nr_mstr
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
nsoc__qadc01
|
QAD Character Field 1
|
|
x(24)
|
|
|
|
nsoc__qadc02
|
QAD Character Field 2
|
|
x(24)
|
|
|
|
nsoc__qadd01
|
QAD Decimal Field 1
|
|
->>>,>>>,>>9.99<<
|
10
|
|
|
nsoc__qadt01
|
QAD Date Field 1
|
|
99/99/99
|
|
|
|
nsoc_all_days
|
Allocate NSO Lines Due in Days
|
|
>>>>>9
|
|
|
|
nsoc_bo_advice
|
Next Back Order Advice
|
|
>>>>>>>>9
|
|
|
|
nsoc_confirm
|
Confirmed Orders
|
|
yes/no
|
|
|
|
nsoc_consume
|
Consume Forecast
|
Consume Fcst
|
yes/no
|
|
|
|
nsoc_det_all
|
Detail Allocations
|
|
yes/no
|
|
|
|
nsoc_dnote
|
Next Delivery Note
|
|
>>>>>>>>9
|
|
|
|
nsoc_domain
|
Domain
|
|
x(8)
|
|
|
|
nsoc_ex_ratetype
|
Rate Type
|
|
x(8)
|
|
|
|
nsoc_hcmmts
|
NSO Header Comments
|
|
yes/no
|
|
|
|
nsoc_immed_ship
|
Ship Immed
|
|
yes/no
|
|
|
|
nsoc_int_cust
|
Internal Customer
|
|
x(8)
|
|
|
|
nsoc_kit_auto
|
Autonumbering for Kits
|
|
yes/no
|
|
|
|
nsoc_kit_nbr
|
Next Kit Number
|
|
>>>>>>9
|
|
|
|
nsoc_kit_pre
|
Kit Prefix
|
|
x(8)
|
|
|
|
nsoc_lcmmts
|
NSO Line Comments
|
|
yes/no
|
|
|
|
nsoc_ln_fmt
|
Ln Format S/M
|
|
yes/no
|
|
|
|
nsoc_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
nsoc_mod_userid
|
User ID
|
|
x(8)
|
|
|
|
nsoc_req
|
Required Qty Reduces Qty Avail
|
|
yes/no
|
|
|
|
nsoc_ship_to
|
Ship To
|
|
yes/no
|
|
|
|
nsoc_shp_lead
|
Shipping Lead Time
|
|
>>>9
|
|
|
|
nsoc_so
|
Next Non-Sales Order
|
|
>>>>>>>9
|
|
|
|
nsoc_so_hist
|
Keep Booking History
|
Book!Hst
|
yes/no
|
|
|
|
nsoc_so_pre
|
Non-Sales Order Prefix
|
Pre
|
x(3)
|
|
|
|
nsoc_user1
|
User Field Character 1
|
|
x(24)
|
|
|
|
nsoc_user2
|
User Field Character 2
|
|
x(24)
|
|
|
|
oid_nsoc_ctrl
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
nsoc_index1
|
yes
|
nsoc_domain
|
yes
|
no
|
|
|
oid_nsoc_ctrl
|
yes
|
oid_nsoc_ctrl
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
oa__qadc01
|
|
|
x(8)
|
|
|
|
oa_code
|
Action Code
|
Code
|
999999
|
|
|
|
oa_detail
|
Action Message Detail
|
|
x(24)
|
|
|
|
oa_domain
|
Domain
|
|
x(8)
|
|
|
|
oa_fr_date
|
From Date
|
From
|
99/99/99
|
|
|
|
oa_line
|
Line/ID
|
|
x(8)
|
|
|
|
oa_nbr
|
Order
|
Order Number
|
x(18)
|
|
|
|
oa_part
|
Item Number
|
|
x(18)
|
|
|
|
oa_qty
|
Action Qty
|
Quantity
|
->,>>>,>>9.9<<<<<<<<
|
10
|
|
|
oa_review
|
Reviewed By
|
By
|
x(2)
|
|
|
|
oa_site
|
Site
|
|
x(8)
|
|
|
|
oa_to_date
|
To Date
|
Date
|
99/99/99
|
|
|
|
oa_user1
|
Ufld1
|
|
x(8)
|
|
|
|
oa_user2
|
Ufld2
|
|
x(8)
|
|
|
|
oid_oa_det
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
oa_part
|
yes
|
oa_domain
|
yes
|
no
|
|
|
|
|
oa_part
|
yes
|
no
|
|
|
|
|
oa_site
|
yes
|
no
|
|
|
|
|
oa_code
|
yes
|
no
|
|
|
|
|
oa_nbr
|
yes
|
no
|
|
|
|
|
oa_line
|
yes
|
no
|
|
|
|
|
oa_to_date
|
yes
|
no
|
|
|
oa_site
|
no
|
oa_domain
|
yes
|
no
|
|
|
|
|
oa_site
|
yes
|
no
|
|
|
|
|
oa_part
|
yes
|
no
|
|
|
oid_oa_det
|
yes
|
oid_oa_det
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
LastModifiedDate
|
Last Modified Date
|
Mod Date
|
99/99/9999
|
|
|
|
LastModifiedTime
|
Last Modified Time
|
Mod Time
|
99999
|
|
|
|
LastModifiedUser
|
Last Modified User
|
Mod User
|
x(20)
|
|
|
|
ObjectStatusCode
|
Code
|
|
x(20)
|
|
|
|
ObjectStatusDescription
|
Description
|
|
x(40)
|
|
|
|
ObjectStatusIsActive
|
Active
|
|
yes/no
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
Prim
|
yes
|
ObjectStatusCode
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
ocm__chr01
|
User Character Field 1
|
|
X(8)
|
|
|
|
ocm__dte01
|
User Date Field 1
|
|
99/99/99
|
|
|
|
ocm__log01
|
User Logical Field 1
|
|
yes/no
|
|
|
|
ocm__qadc01
|
QAD Character Field 1
|
|
X(8)
|
|
|
|
ocm__qadl01
|
QAD Logical Field 1
|
|
yes/no
|
|
|
|
ocm__qadt01
|
QAD Date Field 1
|
|
99/99/99
|
|
|
|
ocm_area
|
Area
|
|
x(8)
|
|
|
|
ocm_domain
|
Domain
|
|
x(8)
|
|
|
|
ocm_end_eff
|
End Effective
|
End
|
99/99/99
|
|
|
|
ocm_eng_code
|
Engineer Code
|
Eng Code
|
x(8)
|
|
|
|
ocm_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
ocm_mod_userid
|
User ID
|
|
X(8)
|
|
|
|
ocm_page
|
Page
|
|
Call/Page
|
|
|
|
ocm_schedule
|
On Call Schedule
|
Schedule
|
X(8)
|
|
|
|
ocm_start_eff
|
Start Effective
|
Start
|
99/99/99
|
|
|
|
ocm_user1
|
Ufld1
|
|
x(8)
|
|
|
|
ocm_user2
|
Ufld2
|
|
x(8)
|
|
|
|
oid_ocm_mstr
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
ocm_area
|
yes
|
ocm_domain
|
yes
|
no
|
|
|
|
|
ocm_area
|
yes
|
no
|
|
|
|
|
ocm_eng_code
|
yes
|
no
|
|
|
|
|
ocm_start_eff
|
yes
|
no
|
|
|
ocm_eng_code
|
no
|
ocm_domain
|
yes
|
no
|
|
|
|
|
ocm_eng_code
|
yes
|
no
|
|
|
|
|
ocm_start_eff
|
yes
|
no
|
|
|
ocm_eng_schedule
|
no
|
ocm_domain
|
yes
|
no
|
|
|
|
|
ocm_eng_code
|
yes
|
no
|
|
|
|
|
ocm_schedule
|
yes
|
no
|
|
|
|
|
ocm_start_eff
|
yes
|
no
|
|
|
oid_ocm_mstr
|
yes
|
oid_ocm_mstr
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
Company_ID
|
Link to Company
|
|
-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)
|
|
|
|
LastModifiedDate
|
Last Modified Date
|
Mod Date
|
99/99/9999
|
|
|
|
LastModifiedTime
|
Last Modified Time
|
Mod Time
|
99999
|
|
|
|
LastModifiedUser
|
Last Modified User
|
Mod User
|
x(20)
|
|
|
|
OIAdjust_ID
|
Record ID
|
|
-99999999999
|
|
|
|
OIAdjustComment
|
Comment
|
|
x(255)
|
|
|
|
OIAdjustDescription
|
Description
|
|
x(255)
|
|
|
|
OIAdjustPostingDate
|
Date
|
|
99/99/9999
|
|
|
|
OIAdjustPostingJournalCode
|
Daybook
|
|
x(8)
|
|
|
|
OIAdjustPostingJournalType
|
Daybook Type
|
|
x(30)
|
|
|
|
OIAdjustPostingPeriod
|
Period
|
|
99
|
|
|
|
OIAdjustPostingVoucher
|
Voucher
|
|
999999999
|
|
|
|
OIAdjustPostingYear
|
Year
|
|
9999
|
|
|
|
Posting_ID
|
Link to Posting
|
|
-99999999999
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
CompanyIdx
|
no
|
Company_ID
|
yes
|
no
|
|
|
CyYrJrnlVouch
|
no
|
Company_ID
|
yes
|
no
|
|
|
|
|
OIAdjustPostingYear
|
yes
|
no
|
|
|
|
|
OIAdjustPostingJournalCode
|
yes
|
no
|
|
|
|
|
OIAdjustPostingVoucher
|
yes
|
no
|
|
|
DateIdx
|
no
|
OIAdjustPostingDate
|
yes
|
no
|
|
|
Journal
|
no
|
OIAdjustPostingJournalCode
|
yes
|
no
|
|
|
JournalType
|
no
|
OIAdjustPostingJournalType
|
yes
|
no
|
|
|
Period
|
no
|
OIAdjustPostingPeriod
|
yes
|
no
|
|
|
PostingIdx
|
no
|
Posting_ID
|
yes
|
no
|
|
∗
|
prim
|
yes
|
OIAdjust_ID
|
yes
|
no
|
|
|
Voucher
|
no
|
OIAdjustPostingVoucher
|
yes
|
no
|
|
|
YearIdx
|
no
|
OIAdjustPostingYear
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
CInvoice_ID
|
Link to CInvoice
|
|
-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)
|
|
|
|
DInvoice_ID
|
Link to DInvoice
|
|
-99999999999
|
|
|
|
InvMovementPostingLine_ID
|
Link to PostingLine
|
|
-99999999999
|
|
|
|
JournalEntryPostingLine_ID
|
Link to PostingLine
|
|
-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)
|
|
|
|
OIAdjust_ID
|
Link to OIAdjust
|
|
-99999999999
|
|
|
|
OIAdjustLn_ID
|
Record ID
|
|
-99999999999
|
|
|
|
OIAdjustLnBaseCurrencyCode
|
Base Currency
|
BC
|
x(3)
|
|
|
|
OIAdjustLnCurrencyCode
|
Transactional Currency
|
TC
|
x(3)
|
|
|
|
OIAdjustLnGLCode
|
GL Account
|
|
x(8)
|
|
|
|
OIAdjustLnInvCompanyCode
|
Entity
|
|
x(20)
|
|
|
|
OIAdjustLnInvCredDebCode
|
Supplier/Customer
|
|
x(8)
|
|
|
|
OIAdjustLnInvDate
|
Invoice Date
|
|
99/99/9999
|
|
|
|
OIAdjustLnInvIdentifier
|
Invoice Number
|
|
x(40)
|
|
|
|
OIAdjustLnInvJournalCode
|
Daybook
|
|
x(8)
|
|
|
|
OIAdjustLnInvReference
|
Reference
|
|
x(40)
|
|
|
|
OIAdjustLnInvType
|
Invoice Type
|
|
x(20)
|
|
|
|
OIAdjustLnInvVoucher
|
Voucher
|
|
999999999
|
|
|
|
OIAdjustLnInvYear
|
Year
|
|
9999
|
|
|
|
OIAdjustLnMovementAmtLC
|
BC Movement
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
OIAdjustLnMovementAmtTC
|
TC Movement
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
OIAdjustLnNewBalanceAmtLC
|
BC New Balance
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
OIAdjustLnNewBalanceAmtTC
|
TC New Balance
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
OIAdjustLnOrigBalanceAmtLC
|
BC Orig Balance
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
OIAdjustLnOrigBalanceAmtTC
|
TC Orig Balance
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
OIAdjustLnPaidAmtTC
|
TC Paid Amount
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
OIAdjustLnPaymentDiscLC
|
BC Payment Disc
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
OIAdjustLnPaymentDiscTC
|
TC Payment Disc
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
OIAdjustLnReportingDateIN
|
Reporting Date (IN)
|
|
99/99/9999
|
|
|
|
OIAdjustLnTaxDiscLC
|
BC Tax Disc
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
OIAdjustLnTaxDiscTC
|
TC Tax Disc
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
OIAdjustLnType
|
Type
|
|
x(20)
|
|
|
|
OIAdjustLnWHTAmtCC
|
SC WHT Amount
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
OIAdjustLnWHTAmtLC
|
BC WHT Amount
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
OIAdjustLnWHTAmtTC
|
TC WHT Amount
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
OIAdjustLnWHTCCRate
|
WHT SC Rate
|
|
->,>>>,>>9.9999999999
|
10
|
|
|
OIAdjustLnWHTCCScale
|
WHT SC Scale
|
|
->,>>>,>>9.9999999999
|
10
|
|
|
OIAdjustLnWHTLCRate
|
WHT BC Rate
|
|
->,>>>,>>9.9999999999
|
10
|
|
|
OIAdjustLnWHTLCScale
|
WHT BC Scale
|
|
->,>>>,>>9.9999999999
|
10
|
|
|
OIAdjustLnWHTPerc
|
WHT Percentage
|
|
->>9.99
|
2
|
|
|
OIAdjustLnWHTTxFeeTC
|
TC WHT Taxable Fee
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
CInvoice
|
no
|
CInvoice_ID
|
yes
|
no
|
|
|
DInvoice
|
no
|
DInvoice_ID
|
yes
|
no
|
|
|
InvMovement
|
no
|
InvMovementPostingLine_ID
|
yes
|
no
|
|
|
JournalEntry
|
no
|
JournalEntryPostingLine_ID
|
yes
|
no
|
|
|
OIAdjust
|
no
|
OIAdjust_ID
|
yes
|
no
|
|
∗
|
prim
|
yes
|
OIAdjustLn_ID
|
yes
|
no
|
|
|
UniqueIdx
|
yes
|
OIAdjust_ID
|
yes
|
no
|
|
|
|
|
CInvoice_ID
|
yes
|
no
|
|
|
|
|
DInvoice_ID
|
yes
|
no
|
|
|
|
|
JournalEntryPostingLine_ID
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
oid_opc_ctrl
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
opc__qad01
|
|
|
>>>>>>9
|
|
|
|
opc__qadi01
|
|
|
->>>>>>>9
|
|
|
|
opc__qadi02
|
|
|
>>>>>9
|
|
|
|
opc_close_gl
|
Create GL
|
|
yes/no
|
|
|
|
opc_domain
|
Domain
|
|
x(8)
|
|
|
|
opc_move
|
Move Next Operation
|
|
yes/no
|
|
|
|
opc_payroll
|
Interface Payroll
|
|
yes/no
|
|
|
|
opc_std_hrs
|
Standard Hours
|
|
>>9.99
|
10
|
|
|
opc_std_per
|
Standard Period
|
|
x(1)
|
|
|
|
opc_time_ind
|
Time Indicator
|
|
x(1)
|
|
|
|
opc_user1
|
Ufld1
|
|
x(8)
|
|
|
|
opc_user2
|
Ufld2
|
|
x(8)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
oid_opc_ctrl
|
yes
|
oid_opc_ctrl
|
yes
|
no
|
|
∗
|
opc_index1
|
yes
|
opc_domain
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
oid_opgl_det
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
opgl__qadc01
|
|
|
x(8)
|
|
|
|
opgl_cr_acct
|
Cr Acct
|
|
x(8)
|
|
|
|
opgl_cr_cc
|
Cr Cost Ctr
|
CC
|
x(4)
|
|
|
|
opgl_cr_line
|
Line
|
|
>>>9
|
|
|
|
opgl_cr_proj
|
Cr Project
|
Project
|
x(8)
|
|
|
|
opgl_cr_sub
|
Cr Sub-Acct
|
Sub-Acct
|
x(8)
|
|
|
|
opgl_domain
|
Domain
|
|
x(8)
|
|
|
|
opgl_dr_acct
|
Dr Acct
|
|
x(8)
|
|
|
|
opgl_dr_cc
|
Dr Cost Ctr
|
CC
|
x(4)
|
|
|
|
opgl_dr_line
|
Line
|
|
>>>9
|
|
|
|
opgl_dr_proj
|
Dr Project
|
Project
|
x(8)
|
|
|
|
opgl_dr_sub
|
Dr Sub-Acct
|
Sub-Acct
|
x(8)
|
|
|
|
opgl_dy_code
|
Daybook
|
|
x(8)
|
|
|
|
opgl_dy_num
|
Entry Number
|
|
x(40)
|
|
|
|
opgl_eff_trans
|
Current
|
|
yes/no
|
|
|
|
opgl_gl_amt
|
Amount
|
|
->>>>>,>>9.99
|
10
|
|
|
opgl_gl_ref
|
GL Reference
|
|
x(14)
|
|
|
|
opgl_sequence
|
Sequence
|
|
->,>>>,>>9
|
|
|
|
opgl_trnbr
|
OP Transaction
|
Trans
|
>>>>>9
|
|
|
|
opgl_type
|
Type
|
|
x(8)
|
|
|
|
opgl_user1
|
Ufld1
|
|
x(8)
|
|
|
|
opgl_user2
|
Ufld2
|
|
x(8)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
oid_opgl_det
|
yes
|
oid_opgl_det
|
yes
|
no
|
|
|
opgl_dr_cr
|
no
|
opgl_domain
|
yes
|
no
|
|
|
|
|
opgl_dr_acct
|
yes
|
no
|
|
|
|
|
opgl_dr_sub
|
yes
|
no
|
|
|
|
|
opgl_dr_cc
|
yes
|
no
|
|
|
|
|
opgl_cr_acct
|
yes
|
no
|
|
|
|
|
opgl_cr_sub
|
yes
|
no
|
|
|
|
|
opgl_cr_cc
|
yes
|
no
|
|
|
opgl_dy
|
no
|
opgl_domain
|
yes
|
no
|
|
|
|
|
opgl_dy_code
|
yes
|
no
|
|
|
|
|
opgl_dy_num
|
yes
|
no
|
|
|
|
|
opgl_sequence
|
yes
|
no
|
|
∗
|
opgl_nbr_ref
|
yes
|
opgl_domain
|
yes
|
no
|
|
|
|
|
opgl_trnbr
|
yes
|
no
|
|
|
|
|
opgl_gl_ref
|
yes
|
no
|
|
|
|
|
opgl_sequence
|
yes
|
no
|
|
|
opgl_ref_nbr
|
no
|
opgl_domain
|
yes
|
no
|
|
|
|
|
opgl_gl_ref
|
yes
|
no
|
|
|
|
|
opgl_trnbr
|
yes
|
no
|
|
|
opgl_type_nbr_ref
|
no
|
opgl_domain
|
yes
|
no
|
|
|
|
|
opgl_type
|
yes
|
no
|
|
|
|
|
opgl_trnbr
|
yes
|
no
|
|
|
|
|
opgl_gl_ref
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
oid_opm_mstr
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
opm__chr01
|
|
|
x(8)
|
|
|
|
opm__chr02
|
|
|
x(8)
|
|
|
|
opm__chr03
|
|
|
x(8)
|
|
|
|
opm__chr04
|
|
|
x(8)
|
|
|
|
opm__chr05
|
|
|
x(8)
|
|
|
|
opm__dec01
|
|
|
>>>,>>>,>>9.99
|
10
|
|
|
opm__dec02
|
|
|
>>>,>>>,>>9.99
|
10
|
|
|
opm__dte01
|
|
|
99/99/99
|
|
|
|
opm__dte02
|
|
|
99/99/99
|
|
|
|
opm__log01
|
|
|
yes/no
|
|
|
|
opm__qadc01
|
QAD Character Field 1
|
|
X(8)
|
|
|
|
opm__qadc02
|
QAD Character Field 2
|
|
X(8)
|
|
|
|
opm__qadc03
|
QAD Character Field 3
|
|
X(8)
|
|
|
|
opm__qade01
|
QAD Decimal Field 1
|
|
->>,>>9.99
|
10
|
|
|
opm__qadl01
|
QAD Logical Field 1
|
|
yes/no
|
|
|
|
opm__qadl02
|
QAD Logical Field 2
|
|
yes/no
|
|
|
|
opm__qadt01
|
QAd Date Field 1
|
|
99/99/99
|
|
|
|
opm_batch
|
Batch Size
|
|
>,>>>,>>9
|
|
|
|
opm_bom_code
|
BOM Code
|
|
X(18)
|
|
|
|
opm_cmtindx
|
Comment Index
|
Comment
|
>>>>>>>9
|
|
|
|
opm_cyc_rate
|
Cycles/Hour
|
|
>>>,>>9.999
|
10
|
|
|
opm_cyc_unit
|
Units/Cycle
|
|
>>>>>9
|
0
|
|
|
opm_desc
|
Description
|
|
x(24)
|
|
|
|
opm_domain
|
Domain
|
|
x(8)
|
|
|
|
opm_fsc_code
|
Service Category
|
Svc Cat
|
x(8)
|
|
|
|
opm_fsm_type
|
FSM Type
|
|
x(8)
|
|
|
|
opm_inv_val
|
Inventory Value
|
|
>>>>,>>>,>>9.99<<<
|
10
|
|
|
opm_lbr_ovhd
|
Labor Overhead
|
Labor Ovhd
|
>>,>>9.999
|
10
|
|
|
opm_mch
|
Machine
|
|
x(8)
|
|
|
|
opm_mile
|
Milestone Operation
|
Milestone
|
yes/no
|
|
|
|
opm_move
|
Move Time
|
Move
|
>,>>9.9<<
|
10
|
|
|
opm_run
|
Run Time
|
Run
|
>>>,>>>,>>9.9<<<<<<<<
|
10
|
|
|
opm_setup
|
Setup Time
|
Setup
|
>,>>9.9<<
|
10
|
|
|
opm_std_op
|
Standard Operation
|
Std Op
|
x(8)
|
|
|
|
opm_sub_cost
|
Subcontract Cost
|
Subcontract
|
>>>>,>>>,>>9.99<<<
|
10
|
|
|
opm_sub_lead
|
Subcontract LT
|
Sub!LT
|
>>9
|
|
|
|
opm_tool
|
Tool Code
|
Tool
|
x(8)
|
|
|
|
opm_tran_qty
|
Overlap Units
|
Overlap
|
->,>>>,>>9
|
|
|
|
opm_user1
|
Ufld1
|
|
x(8)
|
|
|
|
opm_user2
|
Ufld2
|
|
x(8)
|
|
|
|
opm_vend
|
Supplier
|
|
x(8)
|
|
|
|
opm_wkctr
|
Work Center
|
Work Ctr
|
x(8)
|
|
|
|
opm_yld_pct
|
Yield%
|
|
>>9.99%
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
oid_opm_mstr
|
yes
|
oid_opm_mstr
|
yes
|
no
|
|
|
opm_desc
|
yes
|
opm_domain
|
yes
|
no
|
|
|
|
|
opm_desc
|
yes
|
no
|
|
|
|
|
opm_std_op
|
yes
|
no
|
|
∗
|
opm_std_op
|
yes
|
opm_domain
|
yes
|
no
|
|
|
|
|
opm_std_op
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
oid_ops_ctrl
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
ops__qadc01
|
|
|
x(8)
|
|
|
|
ops__qadi01
|
|
|
->>>>>>>9
|
|
|
|
ops_cover
|
Maximum Weeks Coverage
|
Max Wks
|
>9.99
|
10
|
|
|
ops_domain
|
Domain
|
|
x(8)
|
|
|
|
ops_move
|
Move Holiday Production
|
|
yes/no
|
|
|
|
ops_plan
|
Use Operations Plan
|
Ops Plan
|
yes/no
|
|
|
|
ops_round
|
Use Rounding
|
|
yes/no
|
|
|
|
ops_user1
|
Ufld1
|
|
x(8)
|
|
|
|
ops_user2
|
Ufld2
|
|
x(8)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
oid_ops_ctrl
|
yes
|
oid_ops_ctrl
|
yes
|
no
|
|
∗
|
ops_index1
|
yes
|
ops_domain
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
oid_op_hist
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
op__chr01
|
|
|
x(8)
|
|
|
|
op__chr02
|
|
|
x(8)
|
|
|
|
op__chr03
|
|
|
x(8)
|
|
|
|
op__chr04
|
|
|
x(8)
|
|
|
|
op__chr05
|
|
|
x(8)
|
|
|
|
op__dec01
|
|
|
>>>,>>>,>>9.99
|
10
|
|
|
op__dec02
|
|
|
>>>,>>>,>>9.99
|
10
|
|
|
op__dte01
|
|
|
99/99/99
|
|
|
|
op__dte02
|
|
|
99/99/99
|
|
|
|
op__log01
|
|
|
yes/no
|
|
|
|
op__qad01
|
|
|
x(8)
|
|
|
|
op__qad02
|
|
|
x(8)
|
|
|
|
op__qad03
|
|
|
x(4)
|
|
|
|
op__qad04
|
|
|
x(4)
|
|
|
|
op__qad05
|
|
|
x(8)
|
|
|
|
op__qad06
|
|
|
x(4)
|
|
|
|
op__qad07
|
|
|
x(8)
|
|
|
|
op__qad08
|
|
|
x(4)
|
|
|
|
op_act_rate
|
Act Cycles/Hour
|
Act Cyc/Hr
|
>>>,>>9.999
|
10
|
|
|
op_act_run
|
Act Run Time
|
Act Run
|
->,>>9.9<<
|
10
|
|
|
op_act_setup
|
Act Setup Time
|
Act Setup
|
->,>>9.9<<
|
10
|
|
|
op_act_units
|
Actual Units/Cycle
|
Act U/C
|
>>>>>9
|
0
|
|
|
op_bdn_cost
|
Burden Cost
|
Burden
|
->>>>,>>9.99
|
10
|
|
|
op_bdn_std
|
Burden Cost Std
|
Std Burden
|
->>>>,>>9.99
|
10
|
|
|
op_ca_int_type
|
Work Code
|
|
x(8)
|
|
|
|
op_ca_opn_date
|
|
|
99/99/99
|
|
|
|
op_cmtindx
|
Comment Index
|
|
>>>>>>>9
|
|
|
|
op_comment
|
Comment
|
|
x(40)
|
|
|
|
op_covered_amt
|
Covered Amount
|
|
>>>>,>>>,>>9.99<<<
|
10
|
|
|
op_curr
|
Currency
|
Cur
|
x(3)
|
|
|
|
op_date
|
Effective Date
|
Date
|
99/99/99
|
|
|
|
op_dept
|
Department
|
|
x(8)
|
|
|
|
op_doc_id
|
Document ID
|
|
x(24)
|
|
|
|
op_domain
|
Domain
|
|
x(8)
|
|
|
|
op_earn
|
Earning Code
|
|
x(4)
|
|
|
|
op_emp
|
Employee
|
|
x(8)
|
|
|
|
op_eng_area
|
Service Area
|
Area
|
x(18)
|
|
|
|
op_eng_code
|
Engineer Code
|
Eng Code
|
x(8)
|
|
|
|
op_ex_rate
|
Exch Rate
|
|
>>>>,>>>,>>9.9<<<<<<<<<<
|
10
|
|
|
op_ex_rate2
|
Exch Rate 2
|
|
>>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
op_ex_ratetype
|
Rate Type
|
|
x(8)
|
|
|
|
op_exru_seq
|
Sequence
|
|
>>>>>>>>9
|
|
|
|
op_fcg_code
|
Charge Code
|
|
x(8)
|
|
|
|
op_flbr_cstd
|
Curr Cost
|
|
->>>>,>>9.99
|
10
|
|
|
op_flbr_std
|
|
|
->>>>,>>9.99
|
10
|
|
|
op_flvrte_accr
|
|
|
->>>>,>>9.99
|
10
|
|
|
op_flvrte_post
|
|
|
->>>>,>>9.99
|
10
|
|
|
op_from_op
|
From Operation
|
|
>>>>99
|
|
|
|
op_fsc_code
|
Service Category
|
|
x(8)
|
|
|
|
op_fsm_type
|
FSM Type
|
|
x(8)
|
|
|
|
op_gl_amt
|
GL Amount
|
|
->>>>>,>>9.99
|
10
|
|
|
op_itm_line
|
|
|
>>>>9
|
|
|
|
op_lbr_cost
|
Labor Cost
|
Labor
|
->>>>,>>9.99
|
10
|
|
|
op_lbr_ovhd
|
Labor Overhead
|
Labor Ovhd
|
>>,>>9.999
|
10
|
|
|
op_lbr_std
|
Labor Cost Std
|
Std Labor
|
->>>>,>>9.99
|
10
|
|
|
op_line
|
Production Line
|
Line
|
x(8)
|
|
|
|
op_mch
|
Machine
|
|
x(8)
|
|
|
|
op_milestone
|
Milestone Operation
|
Milestone
|
yes/no
|
|
|
|
op_part
|
Item Number
|
|
x(18)
|
|
|
|
op_pay_calc
|
Payroll Calculated
|
|
yes/no
|
|
|
|
op_pc_sequence
|
PC Sequence
|
|
>>>>>>>>>>>>>>>>>>9
|
|
|
|
op_po_nbr
|
Purchase Order
|
PO
|
x(8)
|
|
|
|
op_pod_line
|
Line
|
|
>>9
|
|
|
|
op_prh_receiver
|
Receiver
|
|
x(8)
|
|
|
|
op_price
|
Price
|
|
>>>>,>>>,>>9.99<<<
|
10
|
|
|
op_pro_pct
|
Prorate Pct
|
|
->>9.99%
|
10
|
|
|
op_program
|
Program
|
|
x(12)
|
|
|
|
op_project
|
Project
|
|
x(8)
|
|
|
|
op_qty_adjust
|
Qty Adjusted
|
|
->,>>>,>>9.9<<<<<<<<
|
10
|
|
|
op_qty_comp
|
Qty Completed
|
|
->,>>>,>>9.9<<<<<<<<
|
10
|
|
|
op_qty_rjct
|
Qty Reject
|
|
->,>>>,>>9.9<<<<<<<<
|
10
|
|
|
op_qty_rwrk
|
Qty Rework
|
|
->,>>>,>>9.9<<<<<<<<
|
10
|
|
|
op_qty_scrap
|
Qty Scrapped
|
|
->,>>>,>>9.9<<<<<<<<
|
10
|
|
|
op_qty_wip
|
Qty WIP
|
|
->,>>>,>>9.9<<<<<<<<
|
10
|
|
|
op_rsn
|
Reason
|
|
x(8)
|
|
|
|
op_rsn_adjust
|
Adjust Reason
|
|
x(8)
|
|
|
|
op_rsn_down
|
Down Reason
|
|
x(8)
|
|
|
|
op_rsn_rjct
|
Reject Reason
|
Reject
|
x(8)
|
|
|
|
op_rsn_rwrk
|
Rework Reason
|
Rework
|
x(8)
|
|
|
|
op_rsn_scrap
|
Scrap Reason
|
|
x(8)
|
|
|
|
op_sa_nbr
|
Service Contract
|
|
x(8)
|
|
|
|
op_sad_line
|
Contract Line
|
Ln
|
>>>>>>>9
|
|
|
|
op_shift
|
Shift
|
|
x(2)
|
|
|
|
op_site
|
Site
|
|
x(8)
|
|
|
|
op_std_rate
|
Std Cycles/Hour
|
Std Cyc/Hr
|
>>>,>>9.999
|
10
|
|
|
op_std_run
|
Std Run Time
|
Std Run
|
>>>,>>>,>>9.9<<<<<<<<
|
10
|
|
|
op_std_setup
|
Std Setup Time
|
Std Setup
|
>,>>9.9<<
|
10
|
|
|
op_std_units
|
Std Units/Cycle
|
Std U/C
|
>>>>>9
|
0
|
|
|
op_sub_cost
|
Subcontract Cost
|
Subcontract
|
->>>>,>>9.99
|
10
|
|
|
op_sub_std
|
Subcontract Std
|
Std Subcntrct
|
->>>>,>>9.99
|
10
|
|
|
op_sv_code
|
Contract Type
|
|
x(8)
|
|
|
|
op_svc_type
|
|
|
x(1)
|
|
|
|
op_time
|
Time
|
|
>>,>>>,>>9
|
|
|
|
op_to_op
|
To Operation
|
|
>>>>99
|
|
|
|
op_tool
|
Tool Code
|
Tool
|
x(8)
|
|
|
|
op_tran_date
|
Tran Date
|
Tran!Date
|
99/99/99
|
|
|
|
op_trnbr
|
Trans
|
|
>>>>>9
|
|
|
|
op_type
|
Type
|
|
x(8)
|
|
|
|
op_user1
|
Ufld1
|
|
x(8)
|
|
|
|
op_user2
|
Ufld2
|
|
x(8)
|
|
|
|
op_userc03
|
User Field Character 3
|
|
x(24)
|
|
|
|
op_userd01
|
User Field Decimal 1
|
|
->>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
op_useri01
|
User Field Integer 1
|
|
->>>>>>>9
|
|
|
|
op_userid
|
User ID
|
|
x(8)
|
|
|
|
op_userl01
|
User Field Logical 1
|
|
yes/no
|
|
|
|
op_usert01
|
User Field Date 1
|
|
99/99/99
|
|
|
|
op_wip_lotser
|
Lot/Serial
|
|
x(18)
|
|
|
|
op_wip_ref
|
Reference
|
Ref
|
x(8)
|
|
|
|
op_wkctr
|
Work Center
|
Work Ctr
|
x(8)
|
|
|
|
op_wo_lot
|
ID
|
|
x(8)
|
|
|
|
op_wo_nbr
|
Work Order
|
|
x(18)
|
|
|
|
op_wo_op
|
Operation
|
Op
|
>>>>99
|
|
|
|
op_wo_serial
|
Lot/Serial
|
|
x(18)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
oid_op_hist
|
yes
|
oid_op_hist
|
yes
|
no
|
|
|
op_date
|
no
|
op_domain
|
yes
|
no
|
|
|
|
|
op_date
|
yes
|
no
|
|
|
|
|
op_trnbr
|
yes
|
no
|
|
|
op_emp
|
no
|
op_domain
|
yes
|
no
|
|
|
|
|
op_emp
|
yes
|
no
|
|
|
|
|
op_site
|
yes
|
no
|
|
|
|
|
op_date
|
yes
|
no
|
|
|
op_lot_op
|
no
|
op_domain
|
yes
|
no
|
|
|
|
|
op_wo_lot
|
yes
|
no
|
|
|
|
|
op_wo_op
|
yes
|
no
|
|
|
|
|
op_date
|
yes
|
no
|
|
|
op_part
|
no
|
op_domain
|
yes
|
no
|
|
|
|
|
op_part
|
yes
|
no
|
|
|
|
|
op_site
|
yes
|
no
|
|
|
|
|
op_wo_op
|
yes
|
no
|
|
|
|
|
op_date
|
yes
|
no
|
|
|
op_part_site_date
|
no
|
op_domain
|
yes
|
no
|
|
|
|
|
op_part
|
yes
|
no
|
|
|
|
|
op_site
|
yes
|
no
|
|
|
|
|
op_date
|
yes
|
no
|
|
|
|
|
op_type
|
yes
|
no
|
|
|
op_rsn
|
no
|
op_domain
|
yes
|
no
|
|
|
|
|
op_rsn
|
yes
|
no
|
|
|
|
|
op_site
|
yes
|
no
|
|
|
|
|
op_date
|
yes
|
no
|
|
|
op_rsn_rjct
|
no
|
op_domain
|
yes
|
no
|
|
|
|
|
op_rsn_rjct
|
yes
|
no
|
|
|
|
|
op_site
|
yes
|
no
|
|
|
|
|
op_date
|
yes
|
no
|
|
|
op_rsn_rwrk
|
no
|
op_domain
|
yes
|
no
|
|
|
|
|
op_rsn_rwrk
|
yes
|
no
|
|
|
|
|
op_site
|
yes
|
no
|
|
|
|
|
op_date
|
yes
|
no
|
|
∗
|
op_trnbr
|
yes
|
op_domain
|
yes
|
no
|
|
|
|
|
op_trnbr
|
yes
|
no
|
|
|
op_type
|
no
|
op_domain
|
yes
|
no
|
|
|
|
|
op_site
|
yes
|
no
|
|
|
|
|
op_type
|
yes
|
no
|
|
|
|
|
op_date
|
yes
|
no
|
|
|
op_wkctr
|
no
|
op_domain
|
yes
|
no
|
|
|
|
|
op_site
|
yes
|
no
|
|
|
|
|
op_wkctr
|
yes
|
no
|
|
|
|
|
op_mch
|
yes
|
no
|
|
|
|
|
op_date
|
yes
|
no
|
|
|
op_wo_nbr
|
no
|
op_domain
|
yes
|
no
|
|
|
|
|
op_wo_nbr
|
yes
|
no
|
|
|
|
|
op_wo_lot
|
yes
|
no
|
|
|
|
|
op_date
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
ABSID
|
ABS ID
|
|
x(8)
|
|
|
|
ABSShipFrom
|
Ship From
|
|
x(8)
|
|
|
|
AlgoNbr
|
Algorithm
|
Algo
|
>>9
|
|
|
|
CmtIndx
|
Comments
|
|
>>>>>>>9
|
|
|
|
CreateDate
|
Create Date
|
|
99/99/99
|
|
|
|
CreateTrans
|
Create Transaction
|
Create!Trans
|
yes/no
|
|
|
|
CreateUserID
|
Created
|
|
x(8)
|
|
|
|
Domain
|
Domain
|
|
x(8)
|
|
|
|
DSet
|
Data Set
|
|
x(12)
|
|
|
|
Line
|
Line/ID
|
|
x(8)
|
|
|
|
Loc
|
Location
|
|
x(8)
|
|
|
|
Lot
|
Lot/Serial
|
|
x(18)
|
|
|
|
ModDate
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
ModUserID
|
User ID
|
|
x(8)
|
|
|
|
Nbr
|
Order
|
|
x(18)
|
|
|
|
oid_OrdAllocD
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>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
|
|
|
|
Reason
|
Reason
|
|
x(8)
|
|
|
|
RecDSet
|
Receipt Data Set
|
|
x(12)
|
|
|
|
Receiver
|
Receiver
|
|
x(8)
|
|
|
|
RecLine
|
Receipt Line/ID
|
Receipt!Line/ID
|
x(8)
|
|
|
|
RecNbr
|
Receipt Order
|
|
x(18)
|
|
|
|
RecReqNbr
|
Requisition
|
|
x(8)
|
|
|
|
Ref
|
Reference
|
|
x(8)
|
|
|
|
Rmks
|
Remarks
|
|
x(24)
|
|
|
|
Site
|
Site
|
|
x(8)
|
|
|
|
SOJob
|
SO Job
|
|
x(8)
|
|
|
|
TrType
|
Type
|
|
x(8)
|
|
|
|
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
|
|
|
DSetNbrLine
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
DSet
|
yes
|
no
|
|
|
|
|
Nbr
|
yes
|
no
|
|
|
|
|
Line
|
yes
|
no
|
|
∗
|
DSetSiteLoc
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
DSet
|
yes
|
no
|
|
|
|
|
Site
|
yes
|
no
|
|
|
|
|
Loc
|
yes
|
no
|
|
|
|
|
Part
|
yes
|
no
|
|
|
|
|
Lot
|
yes
|
no
|
|
|
|
|
Ref
|
yes
|
no
|
|
|
oid_OrdAllocD
|
yes
|
oid_OrdAllocD
|
yes
|
no
|
|
|
ShipFromID
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
ABSShipFrom
|
yes
|
no
|
|
|
|
|
ABSID
|
yes
|
no
|
|
|
UsrIdx
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
User1
|
yes
|
no
|
|
|
|
|
User2
|
yes
|
no
|