QAD 2017 Enterprise Edition > Technical References > Database Definitions >
  
nfelg_hist
Electronic Nota Fiscal Log
 
 
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
nfews_mstr
Electronic Nota Fiscal Web Service Master
 
 
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
nffcic_det
FCI uploaded data
 
 
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
nffcih_det
FCI historical data
 
 
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
nffi_mstr
Fiscal interface definitions
 
 
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
nfptf_det
Item fiscal Data by site
 
 
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
nf_mstr
Nota Fiscal Master
 
 
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
Nomenclature
Nomenclature
 
 
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
nrh_hist
Number Range History
 
 
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
nr_mstr
Number Range Master
 
 
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
nsoc_ctrl
Non-Sales Order Control
 
 
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
oa_det
Action Message Detail
 
 
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
ObjectStatus
Object Status
 
 
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
ocm_mstr
Service/Support On Call Master
 
 
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
OIAdjust
Open Item Adjustment
 
 
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
OIAdjustLn
Open Item Adjustment Line
 
 
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
opc_ctrl
Shop Floor Operation History Control
 
 
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
opgl_det
Shop Floor Operation General Ledger Detail
 
 
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
opm_mstr
Standard Operation Master
 
 
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
ops_ctrl
Operations Plan Control
 
 
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
op_hist
Operation Transaction History
 
 
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
OrdAllocD
Warehousing Order Allocation Detail
 
 
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