|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
oid_prsd_det
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
prsd__qadc01
|
|
|
x(24)
|
|
|
|
prsd__qadc02
|
|
|
x(24)
|
|
|
|
prsd_domain
|
Domain
|
|
x(8)
|
|
|
|
prsd_mch
|
Machine
|
|
x(8)
|
|
|
|
prsd_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
prsd_mod_userid
|
User ID
|
|
x(8)
|
|
|
|
prsd_part
|
Item
|
|
x(18)
|
|
|
|
prsd_resourceid
|
WC/PL ID
|
|
x(8)
|
|
|
|
prsd_resourcetype
|
Type
|
|
9
|
|
|
|
prsd_site
|
Site
|
|
x(8)
|
|
|
|
prsd_user1
|
Ufld1
|
|
x(24)
|
|
|
|
prsd_user2
|
Ufld2
|
|
x(24)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
oid_prsd_det
|
yes
|
oid_prsd_det
|
yes
|
no
|
|
∗
|
prsd_part
|
yes
|
prsd_domain
|
yes
|
no
|
|
|
|
|
prsd_site
|
yes
|
no
|
|
|
|
|
prsd_resourcetype
|
yes
|
no
|
|
|
|
|
prsd_resourceid
|
yes
|
no
|
|
|
|
|
prsd_mch
|
yes
|
no
|
|
|
|
|
prsd_part
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
oid_prs_mstr
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
prs__qadc01
|
|
|
x(24)
|
|
|
|
prs__qadc02
|
|
|
x(24)
|
|
|
|
prs_desc
|
Description
|
|
x(24)
|
|
|
|
prs_domain
|
Domain
|
|
x(8)
|
|
|
|
prs_mch
|
Machine
|
|
x(8)
|
|
|
|
prs_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
prs_mod_userid
|
User ID
|
|
x(8)
|
|
|
|
prs_resourceid
|
WC/PL ID
|
|
x(8)
|
|
|
|
prs_resourcetype
|
Type
|
Type
|
9
|
|
|
|
prs_scheduler
|
Scheduler ID
|
|
x(24)
|
|
|
|
prs_site
|
Site
|
|
x(8)
|
|
|
|
prs_user1
|
Ufld1
|
|
x(24)
|
|
|
|
prs_user2
|
Ufld2
|
|
x(24)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
oid_prs_mstr
|
yes
|
oid_prs_mstr
|
yes
|
no
|
|
∗
|
prs_resource
|
yes
|
prs_domain
|
yes
|
no
|
|
|
|
|
prs_site
|
yes
|
no
|
|
|
|
|
prs_resourcetype
|
yes
|
no
|
|
|
|
|
prs_resourceid
|
yes
|
no
|
|
|
|
|
prs_mch
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
oid_pr_mstr
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
pr__qadc01
|
|
|
x(8)
|
|
|
|
pr_blank
|
Blank Lines/Page
|
BLPP
|
>>9
|
|
|
|
pr_desc
|
Description
|
|
x(24)
|
|
|
|
pr_end_bc
|
Bar Code End
|
|
x(100)
|
|
|
|
pr_init
|
Initialize
|
|
x(100)
|
|
|
|
pr_length
|
Lines / page
|
LPP
|
>>>9
|
|
|
|
pr_neg_line
|
Neg Line Feed
|
|
x(100)
|
|
|
|
pr_page
|
Page Control
|
|
x(60)
|
|
|
|
pr_reset
|
Reset
|
|
x(100)
|
|
|
|
pr_st_132
|
132 Column Start
|
|
x(100)
|
|
|
|
pr_st_80
|
80 Column Start
|
|
x(100)
|
|
|
|
pr_st_bc
|
Bar Code Start
|
|
x(100)
|
|
|
|
pr_type
|
Printer Type
|
Type
|
x(8)
|
|
|
|
pr_user1
|
Ufld1
|
|
x(8)
|
|
|
|
pr_user2
|
Ufld2
|
|
x(8)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
oid_pr_mstr
|
yes
|
oid_pr_mstr
|
yes
|
no
|
|
∗
|
pr_type
|
yes
|
pr_type
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
oid_pshc_ctrl
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
pshc__qadc01
|
|
|
x(24)
|
|
|
|
pshc__qadc02
|
|
|
x(24)
|
|
|
|
pshc__qadi01
|
|
|
->>>>>>>9
|
|
|
|
pshc_domain
|
Domain
|
|
x(8)
|
|
|
|
pshc_inv_sort_seq
|
Invoice Line Sorting Sequence
|
|
x(8)
|
|
|
|
pshc_master_nr_id
|
Master Bill Sequence ID
|
|
x(8)
|
|
|
|
pshc_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
pshc_mod_userid
|
User ID
|
|
x(8)
|
|
|
|
pshc_shipper_nr_id
|
Shipper Sequence ID
|
|
x(8)
|
|
|
|
pshc_user1
|
User Field Character 1
|
|
x(24)
|
|
|
|
pshc_user2
|
User Field Character 2
|
|
x(24)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
oid_pshc_ctrl
|
yes
|
oid_pshc_ctrl
|
yes
|
no
|
|
∗
|
pshc_index1
|
yes
|
pshc_domain
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
oid_ps_mstr
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
ps__chr01
|
User Character Field 1
|
|
X(8)
|
|
|
|
ps__chr02
|
User Character Field 2
|
|
X(8)
|
|
|
|
ps__dec01
|
User Decimal Field 1
|
|
->>>,>>>,>>9.99<<
|
10
|
|
|
ps__dec02
|
User Decimal Field 2
|
|
->>>,>>>,>>9.99<<
|
10
|
|
|
ps__dte01
|
User Date Field 1
|
|
99/99/99
|
|
|
|
ps__dte02
|
User Date Field 2
|
|
99/99/99
|
|
|
|
ps__log01
|
User Logical Field 1
|
|
yes/no
|
|
|
|
ps__log02
|
User Logical Field 2
|
|
yes/no
|
|
|
|
ps__qad01
|
|
|
yes/no
|
|
|
|
ps__qadc01
|
QAD Character Field 1
|
|
X(8)
|
|
|
|
ps__qadc02
|
QAD Character Field 2
|
|
X(8)
|
|
|
|
ps__qadd01
|
QAD Decimal Field 1
|
|
->>>,>>>,>>9.99<<
|
10
|
|
|
ps__qadd02
|
QAD Decimal Field 2
|
|
->>>,>>>,>>9.99<<
|
10
|
|
|
ps__qadl01
|
QAD Logical Field 1
|
|
yes/no
|
|
|
|
ps__qadl02
|
QAD Logical Field 2
|
|
yes/no
|
|
|
|
ps__qadt01
|
QAD Date Field 1
|
|
99/99/99
|
|
|
|
ps__qadt02
|
QAD Date Field 2
|
|
99/99/99
|
|
|
|
ps__qadt03
|
QAD Date Field 3
|
|
99/99/99
|
|
|
|
ps_assay
|
Assay
|
|
>>9.99%
|
10
|
|
|
ps_batch_pct
|
Batch Percent
|
Batch %
|
->>>>9.9<<<<%
|
10
|
|
|
ps_cmtindx
|
Comment Index
|
Comment
|
>>>>>>>9
|
|
|
|
ps_comm_code
|
Commodity Code
|
Commodity
|
x(8)
|
|
|
|
ps_comp
|
Component Item
|
|
x(18)
|
|
|
|
ps_comp_um
|
UM
|
|
x(2)
|
|
|
|
ps_cop_qty
|
Quantity
|
Qty
|
->,>>>,>>9.9<<<<<<<<
|
10
|
|
|
ps_critical
|
Critical
|
|
yes/no
|
|
|
|
ps_cst_pct
|
Cost Allocation
|
Cost!Alloc
|
>>9.99%
|
10
|
|
|
ps_default
|
Default Option
|
Default
|
yes/no
|
|
|
|
ps_domain
|
Domain
|
|
x(8)
|
|
|
|
ps_end
|
End Effective
|
End Eff
|
99/99/99
|
|
|
|
ps_end_ecn
|
End ECN
|
|
x(8)
|
|
|
|
ps_exclusive
|
Exclusive
|
|
yes/no
|
|
|
|
ps_fcst_pct
|
Forecast
|
Fcst
|
>>9.99%
|
10
|
|
|
ps_group
|
Option Group
|
Group
|
x(8)
|
|
|
|
ps_item_no
|
Sequence Number
|
Seq Nbr
|
->>>>>>>
|
|
|
|
ps_joint_type
|
Co/By Type
|
CT
|
x(1)
|
|
|
|
ps_lt_off
|
LT Offset
|
LTO
|
->>
|
|
|
|
ps_mandatory
|
Mandatory
|
|
yes/no
|
|
|
|
ps_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
ps_non_bal
|
Non-Balanced
|
Non-Bal
|
yes/no
|
|
|
|
ps_op
|
Op
|
|
>>>>>>
|
|
|
|
ps_par
|
Parent Item
|
|
x(18)
|
|
|
|
ps_process
|
Process
|
|
x(8)
|
|
|
|
ps_prod_pct
|
Process
|
Process!Percent
|
>>9.99%
|
10
|
|
|
ps_ps_code
|
Structure Type
|
T
|
x(1)
|
|
|
|
ps_qty_cons
|
Qty Consumed
|
|
->,>>>,>>9.9<<<<<<<<
|
10
|
|
|
ps_qty_diag
|
Qty Diagnose
|
|
->,>>>,>>9.9<<<<<<<<
|
10
|
|
|
ps_qty_exch
|
Qty Exchanged
|
|
->,>>>,>>9.9<<<<<<<<
|
10
|
|
|
ps_qty_per
|
Qty Per
|
|
->,>>>,>>9.9<<<<<<<<
|
10
|
|
|
ps_qty_per_b
|
Qty Per
|
|
->,>>>,>>9.9<<<<<<<<
|
10
|
|
|
ps_qty_type
|
Qty Type
|
T
|
x(1)
|
|
|
|
ps_ref
|
Reference
|
|
x(12)
|
|
|
|
ps_rmks
|
Remarks
|
|
x(24)
|
|
|
|
ps_scrp_pct
|
Scrap
|
|
>>9.99%
|
10
|
|
|
ps_start
|
Start Effective
|
Start Eff
|
99/99/99
|
|
|
|
ps_start_ecn
|
Start ECN
|
|
x(8)
|
|
|
|
ps_um_conv
|
UM Conv
|
|
>>>>9.9999<<<<
|
10
|
|
|
ps_user1
|
Ufld1
|
|
x(8)
|
|
|
|
ps_user2
|
Ufld2
|
|
x(8)
|
|
|
|
ps_userid
|
User ID
|
|
x(8)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
oid_ps_mstr
|
yes
|
oid_ps_mstr
|
yes
|
no
|
|
|
ps_comp
|
no
|
ps_domain
|
yes
|
no
|
|
|
|
|
ps_comp
|
yes
|
no
|
|
|
|
|
ps_par
|
yes
|
no
|
|
|
ps_par
|
no
|
ps_domain
|
yes
|
no
|
|
|
|
|
ps_par
|
yes
|
no
|
|
|
|
|
ps_item_no
|
yes
|
no
|
|
|
|
|
ps_comp
|
yes
|
no
|
|
∗
|
ps_parcomp
|
yes
|
ps_domain
|
yes
|
no
|
|
|
|
|
ps_par
|
yes
|
no
|
|
|
|
|
ps_comp
|
yes
|
no
|
|
|
|
|
ps_ref
|
yes
|
no
|
|
|
|
|
ps_start
|
yes
|
no
|
|
|
ps_parref
|
yes
|
ps_domain
|
yes
|
no
|
|
|
|
|
ps_par
|
yes
|
no
|
|
|
|
|
ps_ref
|
yes
|
no
|
|
|
|
|
ps_comp
|
yes
|
no
|
|
|
|
|
ps_start
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
oid_ptat_ctrl
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
ptat__qadc01
|
|
|
x(8)
|
|
|
|
ptat__qadc02
|
|
|
x(8)
|
|
|
|
ptat__qadc03
|
|
|
x(8)
|
|
|
|
ptat__qadd01
|
QAD Field
|
|
>>>,>>>,>>9.99
|
10
|
|
|
ptat__qadd02
|
QAD Field
|
|
>>>,>>>,>>9.99
|
10
|
|
|
ptat__qadl01
|
|
|
yes/no
|
|
|
|
ptat__qadt01
|
QAD Date Field
|
|
99/99/99
|
|
|
|
ptat__qadt02
|
QAD Date Field
|
|
99/99/99
|
|
|
|
ptat_append_value
|
Append Value
|
|
Yes/No
|
|
|
|
ptat_attr_seq
|
Attribute ID Sequence ID
|
|
x(8)
|
|
|
|
ptat_auto_lot_seq
|
Auto Lot Sequence ID
|
|
x(8)
|
|
|
|
ptat_conflict_resolution_code
|
Conflict Resolution Code
|
|
x(2)
|
|
|
|
ptat_display_spec
|
Display Specification
|
|
Yes/No
|
|
|
|
ptat_domain
|
Domain
|
|
x(8)
|
|
|
|
ptat_include_spec
|
Include Spec in History
|
|
Yes/No
|
|
|
|
ptat_lot_order_seq
|
Lot Order Sequence ID
|
|
x(8)
|
|
|
|
ptat_mod_date
|
Modified Date
|
|
99/99/99
|
|
|
|
ptat_mod_userid
|
User ID
|
|
x(8)
|
|
|
|
ptat_nc_status_code
|
Non-conforming Status
|
|
x(8)
|
|
|
|
ptat_status_code
|
Attribute Status
|
|
x(8)
|
|
|
|
ptat_use_ref_as_sublot
|
Use Ref As Sublot
|
|
Yes/No
|
|
|
|
ptat_user1
|
Ufld1
|
|
x(8)
|
|
|
|
ptat_user2
|
Ufld2
|
|
x(8)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
oid_ptat_ctrl
|
yes
|
oid_ptat_ctrl
|
yes
|
no
|
|
∗
|
ptat_domain
|
yes
|
ptat_domain
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
oid_pta_det
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
pta__chr01
|
|
|
x(8)
|
|
|
|
pta__chr02
|
|
|
x(8)
|
|
|
|
pta__chr03
|
|
|
x(8)
|
|
|
|
pta__chr04
|
|
|
x(8)
|
|
|
|
pta__chr05
|
|
|
x(8)
|
|
|
|
pta__chr06
|
|
|
x(8)
|
|
|
|
pta__chr07
|
|
|
x(8)
|
|
|
|
pta__chr08
|
|
|
x(8)
|
|
|
|
pta__chr09
|
|
|
x(8)
|
|
|
|
pta__chr10
|
|
|
x(8)
|
|
|
|
pta__dec01
|
|
|
>>>,>>>,>>9.99
|
10
|
|
|
pta__dec02
|
|
|
>>>,>>>,>>9.99
|
10
|
|
|
pta__dte01
|
|
|
99/99/99
|
|
|
|
pta__dte02
|
|
|
99/99/99
|
|
|
|
pta__log01
|
|
|
yes/no
|
|
|
|
pta__qadc01
|
|
|
x(8)
|
|
|
|
pta__qadc02
|
|
|
x(8)
|
|
|
|
pta__qadd01
|
|
|
->>>,>>>,>>9.9<<<
|
10
|
|
|
pta__qadd02
|
|
|
->>>,>>>,>>9.9<<<
|
10
|
|
|
pta__qadl01
|
|
|
yes/no
|
|
|
|
pta_assoc_item
|
Associated Item
|
|
x(18)
|
|
|
|
pta_assoc_qty
|
Associated Qty
|
|
->>,>>>,>>9.9<<
|
10
|
|
|
pta_assoc_type
|
Association Type
|
|
x(24)
|
|
|
|
pta_assoc_um
|
Associated UM
|
UM
|
x(2)
|
|
|
|
pta_cmtindx
|
Comment Index
|
Comment
|
>>>>>>>9
|
|
|
|
pta_curr
|
Currency
|
Cur
|
x(3)
|
|
|
|
pta_domain
|
Domain
|
|
x(8)
|
|
|
|
pta_expire
|
Expire
|
|
99/99/99
|
|
|
|
pta_extrec
|
External Entry
|
Ext
|
yes/no
|
|
|
|
pta_item
|
Item
|
|
x(18)
|
|
|
|
pta_max_qty
|
Max Quantity
|
|
->>,>>>,>>9.9<<<<<<<<
|
10
|
|
|
pta_min_ord
|
Min Ord Qty
|
|
->>,>>>,>>9.9<<<<<<<<
|
10
|
|
|
pta_net_price
|
Net Price
|
|
>>>>,>>>,>>9.99
|
10
|
|
|
pta_pri_type
|
Price Type
|
|
x(24)
|
|
|
|
pta_qty_mult
|
Qty Multiple
|
|
->>,>>>,>>9.9<<<<<<<<
|
10
|
|
|
pta_start
|
Start
|
|
99/99/99
|
|
|
|
pta_um
|
UM
|
|
x(2)
|
|
|
|
pta_user1
|
Ufld1
|
|
x(8)
|
|
|
|
pta_user2
|
Ufld2
|
|
x(8)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
oid_pta_det
|
yes
|
oid_pta_det
|
yes
|
no
|
|
|
pta_assoc_item
|
no
|
pta_domain
|
yes
|
no
|
|
|
|
|
pta_assoc_item
|
yes
|
no
|
|
|
|
|
pta_assoc_type
|
yes
|
no
|
|
|
|
|
pta_item
|
yes
|
no
|
|
|
|
|
pta_start
|
yes
|
no
|
|
∗
|
pta_item
|
yes
|
pta_domain
|
yes
|
no
|
|
|
|
|
pta_item
|
yes
|
no
|
|
|
|
|
pta_assoc_type
|
yes
|
no
|
|
|
|
|
pta_um
|
yes
|
no
|
|
|
|
|
pta_assoc_item
|
yes
|
no
|
|
|
|
|
pta_curr
|
yes
|
no
|
|
|
|
|
pta_start
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
oid_ptc_det
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
ptc__qadc01
|
|
|
x(24)
|
|
|
|
ptc__qadc02
|
|
|
x(24)
|
|
|
|
ptc_charge
|
Apply Charges
|
|
yes/no
|
|
|
|
ptc_charge_type
|
Charge Type
|
Charge!Type
|
x(8)
|
|
|
|
ptc_container_desc
|
Description
|
|
x(24)
|
|
|
|
ptc_container_ref
|
Reference
|
|
x(16)
|
|
|
|
ptc_container_type
|
Container Type
|
|
x(16)
|
|
|
|
ptc_domain
|
Domain
|
|
x(8)
|
|
|
|
ptc_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
ptc_mod_userid
|
User ID
|
|
x(8)
|
|
|
|
ptc_part
|
Container
|
|
x(18)
|
|
|
|
ptc_userc01
|
User Field Character 1
|
|
x(24)
|
|
|
|
ptc_userc02
|
User Field Character 2
|
|
x(24)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
oid_ptc_det
|
yes
|
oid_ptc_det
|
yes
|
no
|
|
∗
|
ptc_part
|
yes
|
ptc_domain
|
yes
|
no
|
|
|
|
|
ptc_part
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
oid_pth_hist
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
pth__chr01
|
|
|
x(8)
|
|
|
|
pth__chr02
|
|
|
x(8)
|
|
|
|
pth__chr03
|
|
|
x(8)
|
|
|
|
pth__chr04
|
|
|
x(8)
|
|
|
|
pth__chr05
|
|
|
x(8)
|
|
|
|
pth__dec01
|
|
|
>>>,>>>,>>9.99
|
10
|
|
|
pth__dec02
|
|
|
>>>,>>>,>>9.99
|
10
|
|
|
pth__dte01
|
|
|
99/99/99
|
|
|
|
pth__dte02
|
|
|
99/99/99
|
|
|
|
pth__log01
|
|
|
yes/no
|
|
|
|
pth_domain
|
Domain
|
|
x(8)
|
|
|
|
pth_for
|
For
|
|
x(18)
|
|
|
|
pth_part
|
Item Number
|
|
x(18)
|
|
|
|
pth_tot_cost
|
YTD Cost
|
|
->,>>>,>>>,>>9
|
10
|
|
|
pth_tot_qty
|
YTD Qty
|
|
->>>,>>>,>>9
|
10
|
|
|
pth_tot_sale
|
YTD Sales
|
|
->,>>>,>>>,>>9
|
10
|
|
|
pth_type
|
Ship Type
|
T
|
x(1)
|
|
|
|
pth_user1
|
Ufld1
|
|
x(8)
|
|
|
|
pth_user2
|
Ufld2
|
|
x(8)
|
|
|
|
pth_year
|
Year
|
|
9999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
oid_pth_hist
|
yes
|
oid_pth_hist
|
yes
|
no
|
|
|
pth_partyear
|
yes
|
pth_domain
|
yes
|
no
|
|
|
|
|
pth_part
|
yes
|
no
|
|
|
|
|
pth_year
|
yes
|
no
|
|
∗
|
pth_yearpart
|
yes
|
pth_domain
|
yes
|
no
|
|
|
|
|
pth_year
|
yes
|
no
|
|
|
|
|
pth_part
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
oid_pt_mstr
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
oid_pti_det
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
oid_si_mstr
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
pti__qadc01
|
|
|
x(24)
|
|
|
|
pti__qadc02
|
|
|
x(24)
|
|
|
|
pti__qadd01
|
|
|
->>>>,>>>,>>9.99<<<<<<<<
|
10
|
|
|
pti__qadi01
|
|
|
->>>>>>>9
|
|
|
|
pti__qadi02
|
|
|
->,>>>,>>9
|
|
|
|
pti__qadl01
|
|
|
yes/no
|
|
|
|
pti__qadt01
|
|
|
99/99/99
|
|
|
|
pti_abc
|
ABC Class
|
ABC
|
x(1)
|
|
|
|
pti_auto_lot
|
Auto Lot Numbers
|
Auto!Lot
|
yes/no
|
|
|
|
pti_avg_int
|
Avg Int
|
Avg!Int
|
>>9
|
|
|
|
pti_critical
|
Key Item
|
|
yes/no
|
|
|
|
pti_cyc_int
|
Cyc Cnt Int
|
Cyc!Int
|
>>9
|
|
|
|
pti_destructive
|
Destructive
|
Destr
|
yes/no
|
|
|
|
pti_id_qty
|
ID Quantity
|
ID!Qty
|
>>>9
|
|
|
|
pti_insp_days
|
Insp Frequency (Days)
|
Insp Freq (D)
|
>>9
|
|
|
|
pti_insp_freq
|
Insp Frequency
|
Insp Freq.
|
>>>>>>9
|
|
|
|
pti_insp_ref
|
Ref
|
|
yes/no
|
|
|
|
pti_insp_req
|
Inspection Required
|
Insp Req
|
yes/no
|
|
|
|
pti_invent_days[10]
|
Days From Expiration/Manufacture
|
Days From!Expire/!Manuf.
|
>>,>>9
|
|
|
|
pti_issue_method
|
Issue Method
|
Issue!Method
|
x(8)
|
|
|
|
pti_kanban_qty
|
Default Kanban Qty
|
|
->,>>>,>>9.9<<<<<<<<
|
10
|
|
|
pti_kanban_replist
|
Kanban Replen. List
|
|
x(8)
|
|
|
|
pti_loc
|
Location
|
|
x(8)
|
|
|
|
pti_loc_type
|
Location Type
|
Loc Type
|
x(8)
|
|
|
|
pti_lot_grp
|
Lot Group
|
|
x(8)
|
|
|
|
pti_lot_ser
|
Lot/Serial Control
|
Lot/Ser
|
x(1)
|
|
|
|
pti_memo_type
|
Memo Order Type
|
|
x(1)
|
|
|
|
pti_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
pti_mod_userid
|
User ID
|
|
x(8)
|
|
|
|
pti_opc_threshold
|
OPC Threshold
|
|
->>>,>>9.9<<<<<<
|
10
|
|
|
pti_part_type
|
Warehouse Item Type
|
Warehouse!Item Type
|
x(8)
|
|
|
|
pti_pop_code
|
Popularity
|
|
X(8)
|
|
|
|
pti_print_id
|
Print ID
|
Print!ID
|
yes/no
|
|
|
|
pti_random_insp_pct
|
Random Inspection %
|
|
->>9.99
|
10
|
|
|
pti_rctpo_active
|
Active
|
Act
|
yes/no
|
|
|
|
pti_rctpo_status
|
PO Rcpt Status
|
Status
|
x(8)
|
|
|
|
pti_rctwo_active
|
Active
|
Act
|
yes/no
|
|
|
|
pti_rctwo_status
|
WO Rcpt Status
|
Status
|
x(8)
|
|
|
|
pti_rep_type
|
Replenishment Type
|
Rep Type
|
X(8)
|
|
|
|
pti_same_days[10]
|
Same Day Window
|
Same Day!Window
|
>>,>>9
|
|
|
|
pti_sample_pct
|
Sample %
|
Sample %
|
>>9
|
|
|
|
pti_sample_qty
|
Sample Quantity
|
Sample Qty
|
->,>>>,>>9.9<<<<<<<<
|
10
|
|
|
pti_shelflife
|
Shelf Life
|
|
->,>>>,>>>
|
|
|
|
pti_single_trans
|
Single Put-Away Transactions
|
Single!Trans
|
yes/no
|
|
|
|
pti_site_loc
|
Site Location
|
Site!Location
|
x(8)
|
|
|
|
pti_sngl_lot
|
Allocate Single Lot
|
Sngl!Lot
|
yes/no
|
|
|
|
pti_user1
|
User Field Character 1
|
|
x(24)
|
|
|
|
pti_user2
|
User Field character 2
|
|
x(24)
|
|
|
|
pti_userd01
|
User Field Decimal 1
|
|
->>>>,>>>,>>9.99<<<<<<<<
|
10
|
|
|
pti_useri01
|
User Field Integer 1
|
|
->>>>>>>9
|
|
|
|
pti_userl01
|
User Field Logical 1
|
|
yes/no
|
|
|
|
pti_usert01
|
User Field Date 1
|
|
99/99/99
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
oid_pti_det
|
yes
|
oid_pti_det
|
yes
|
no
|
|
∗
|
pti_oid_pt_mstr
|
yes
|
oid_pt_mstr
|
yes
|
no
|
|
|
|
|
oid_si_mstr
|
yes
|
no
|
|
|
pti_oid_si_mstr
|
yes
|
oid_si_mstr
|
yes
|
no
|
|
|
|
|
oid_pt_mstr
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
oid_ptls_det
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
ptls__chr01
|
|
|
x(8)
|
|
|
|
ptls__chr02
|
|
|
x(8)
|
|
|
|
ptls__chr03
|
|
|
x(8)
|
|
|
|
ptls__chr04
|
|
|
x(8)
|
|
|
|
ptls__chr05
|
|
|
x(8)
|
|
|
|
ptls__dec01
|
|
|
->>,>>9.99
|
10
|
|
|
ptls__dec02
|
|
|
->>,>>9.99
|
10
|
|
|
ptls_assay
|
Assay %
|
|
>>9.99%
|
10
|
|
|
ptls_cmtindx
|
Comment Index
|
|
>>>>>>>9
|
|
|
|
ptls_domain
|
Domain
|
|
x(8)
|
|
|
|
ptls_expire
|
Expire Date
|
Expire
|
99/99/99
|
|
|
|
ptls_grade
|
Grade
|
|
x(2)
|
|
|
|
ptls_lotser
|
Lot/Serial
|
|
x(18)
|
|
|
|
ptls_part
|
Item Number
|
|
x(18)
|
|
|
|
ptls_ref
|
Ref
|
Reference
|
x(8)
|
|
|
|
ptls_status
|
Inventory Status
|
Status
|
x(8)
|
|
|
|
ptls_user1
|
Ufld1
|
|
x(8)
|
|
|
|
ptls_user2
|
Ufld2
|
|
x(8)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
oid_ptls_det
|
yes
|
oid_ptls_det
|
yes
|
no
|
|
∗
|
ptls_partlotr
|
yes
|
ptls_domain
|
yes
|
no
|
|
|
|
|
ptls_part
|
yes
|
no
|
|
|
|
|
ptls_lotser
|
yes
|
no
|
|
|
|
|
ptls_ref
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
oid_ptpac_det
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
ptpac__qadc01
|
|
|
x(24)
|
|
|
|
ptpac__qadc02
|
|
|
x(24)
|
|
|
|
ptpac_addr
|
Address
|
|
x(8)
|
|
|
|
ptpac_bop_code
|
BOP Code
|
|
x(18)
|
|
|
|
ptpac_domain
|
Domain
|
|
x(8)
|
|
|
|
ptpac_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
ptpac_mod_userid
|
User ID
|
|
x(8)
|
|
|
|
ptpac_part
|
Item
|
|
x(18)
|
|
|
|
ptpac_site
|
Site
|
|
x(8)
|
|
|
|
ptpac_trans_type
|
Transaction Type
|
|
x(8)
|
|
|
|
ptpac_user1
|
User Field Character 1
|
|
x(24)
|
|
|
|
ptpac_user2
|
User Field Character 2
|
|
x(24)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
oid_ptpac_det
|
yes
|
oid_ptpac_det
|
yes
|
no
|
|
∗
|
ptpac_trans_type
|
yes
|
ptpac_domain
|
yes
|
no
|
|
|
|
|
ptpac_part
|
yes
|
no
|
|
|
|
|
ptpac_site
|
yes
|
no
|
|
|
|
|
ptpac_addr
|
yes
|
no
|
|
|
|
|
ptpac_trans_type
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
oid_ptp_det
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
ptp__chr01
|
|
|
x(8)
|
|
|
|
ptp__chr02
|
|
|
x(8)
|
|
|
|
ptp__chr03
|
|
|
x(8)
|
|
|
|
ptp__chr04
|
|
|
x(8)
|
|
|
|
ptp__chr05
|
|
|
x(8)
|
|
|
|
ptp__chr06
|
|
|
x(8)
|
|
|
|
ptp__chr07
|
|
|
x(8)
|
|
|
|
ptp__chr08
|
|
|
x(8)
|
|
|
|
ptp__chr09
|
|
|
x(8)
|
|
|
|
ptp__chr10
|
|
|
x(8)
|
|
|
|
ptp__dec01
|
|
|
>>>,>>>,>>9.99
|
10
|
|
|
ptp__dec02
|
|
|
>>>,>>>,>>9.99
|
10
|
|
|
ptp__dte01
|
|
|
99/99/99
|
|
|
|
ptp__dte02
|
|
|
99/99/99
|
|
|
|
ptp__log01
|
|
|
yes/no
|
|
|
|
ptp__log02
|
|
|
yes/no
|
|
|
|
ptp__qad01
|
|
|
99/99/99
|
|
|
|
ptp__qad02
|
|
|
>>>,>>9.9
|
0
|
|
|
ptp__qad03
|
|
|
>>9
|
|
|
|
ptp__qad04
|
|
|
>>9
|
|
|
|
ptp__qad05
|
|
|
>>9
|
|
|
|
ptp_added
|
Added
|
|
99/99/99
|
|
|
|
ptp_assay
|
Assay %
|
|
>>9.99%
|
10
|
|
|
ptp_atp_enforcement
|
ATP Enforcement
|
ATP Enf
|
x(1)
|
|
|
|
ptp_atp_family
|
Family ATP
|
Fam ATP
|
yes/no
|
|
|
|
ptp_atp_horizon
|
ATP Horizon
|
Horizon
|
>>>9
|
|
|
|
ptp_batch
|
Batch Qty
|
Batch!Qty
|
>>,>>>,>>9.9<<<<<<<<
|
10
|
|
|
ptp_bom_code
|
BOM/Formula
|
|
x(18)
|
|
|
|
ptp_btb_type
|
EMT Type
|
|
xx
|
|
|
|
ptp_buyer
|
Buyer/Planner
|
Buy!Pln
|
x(8)
|
|
|
|
ptp_cfg_type
|
Configuration
|
Config
|
x(1)
|
|
|
|
ptp_cum_lead
|
Cum LT
|
Cum!LT
|
>>9
|
|
|
|
ptp_domain
|
Domain
|
|
x(8)
|
|
|
|
ptp_draw
|
Drawing
|
|
x(18)
|
|
|
|
ptp_drp_pct
|
DRP
|
|
>>9.9<%
|
10
|
|
|
ptp_eco_pend
|
ECO Pending
|
ECO
|
yes/no
|
|
|
|
ptp_gcfg_type
|
Configuration Type
|
Cfg Type
|
x(8)
|
|
|
|
ptp_grade
|
Grade
|
|
x(2)
|
|
|
|
ptp_ins_lead
|
Ins LT
|
Ins!LT
|
>>9
|
|
|
|
ptp_ins_rqd
|
Inspect
|
Ins!Req
|
yes/no
|
|
|
|
ptp_insp_loc
|
Inspection Location
|
Inspect
|
x(8)
|
|
|
|
ptp_iss_pol
|
Issue Policy
|
Iss
|
yes/no
|
|
|
|
ptp_joint_type
|
Co/By Type
|
CT
|
x(1)
|
|
|
|
ptp_ll_bom
|
Low Level
|
Low Lvl
|
->>>>>9
|
|
|
|
ptp_ll_drp
|
DRP Low Level
|
DRP LL
|
->>>>>9
|
|
|
|
ptp_mfg_lead
|
Mfg LT
|
Mfg!LT
|
>>9
|
0
|
|
|
ptp_mfg_pct
|
Manufactured
|
Mfg
|
>>9.9<%
|
10
|
|
|
ptp_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
ptp_ms
|
Master Sched
|
MS
|
yes/no
|
|
|
|
ptp_network
|
Network Code
|
|
x(18)
|
|
|
|
ptp_op_yield
|
Op Based Yield
|
|
yes/no
|
|
|
|
ptp_ord_max
|
Max Ord
|
|
>>,>>>,>>9
|
0
|
|
|
ptp_ord_min
|
Min Ord
|
|
>>,>>>,>>9
|
0
|
|
|
ptp_ord_mult
|
Ord Mult
|
Mult
|
>>,>>>,>>9
|
0
|
|
|
ptp_ord_per
|
Order Period
|
Ord!Per
|
>>9
|
|
|
|
ptp_ord_pol
|
Order Policy
|
Ord!Pol
|
x(3)
|
|
|
|
ptp_ord_qty
|
Order Qty
|
|
>>,>>>,>>9
|
10
|
|
|
ptp_part
|
Item Number
|
|
x(18)
|
|
|
|
ptp_phantom
|
Phantom
|
|
yes/no
|
|
|
|
ptp_pick_logic
|
Pick Logic
|
Pick
|
-9
|
|
|
|
ptp_plan_ord
|
Plan Orders
|
Pln
|
yes/no
|
|
|
|
ptp_pm_code
|
Pur/Mfg
|
P/M
|
x(1)
|
|
|
|
ptp_po_site
|
PO Site
|
|
x(8)
|
|
|
|
ptp_pou_code
|
Point of Use Code
|
|
x(18)
|
|
|
|
ptp_pur_lead
|
Pur LT
|
Pur!LT
|
>>9
|
|
|
|
ptp_pur_pct
|
Purchased
|
Pur
|
>>9.9<%
|
10
|
|
|
ptp_replenishment_mthd
|
Replenishment Method
|
|
x(8)
|
|
|
|
ptp_rev
|
Rev
|
|
x(4)
|
|
|
|
ptp_rollup
|
Rollup Reqd
|
|
yes/no
|
|
|
|
ptp_rollup_id
|
Rollup ID
|
|
x(8)
|
|
|
|
ptp_rop
|
Reorder Point
|
ROP
|
>>>,>>9
|
0
|
|
|
ptp_routing
|
Routing Code
|
|
x(18)
|
|
|
|
ptp_run
|
Run Time
|
Run
|
>>>,>>9.999<<<<<<
|
10
|
|
|
ptp_run_ll
|
Run LL
|
|
>>>,>>9.999<<<<<<
|
10
|
|
|
ptp_run_seq1
|
Run Seq 1
|
|
x(8)
|
|
|
|
ptp_run_seq2
|
2
|
Run Seq 2
|
x(8)
|
|
|
|
ptp_setup
|
Setup Time
|
Setup
|
>>>,>>9.999<<<<<<
|
10
|
|
|
ptp_setup_ll
|
Setup LL
|
|
>>>,>>9.999<<<<<<
|
10
|
|
|
ptp_sfty_stk
|
Safety Stk
|
Safety!Stock
|
>>,>>>,>>9
|
0
|
|
|
ptp_sfty_tme
|
Safety Time
|
Safety!Time
|
>>9
|
0
|
|
|
ptp_site
|
Site
|
|
x(8)
|
|
|
|
ptp_timefnce
|
Time Fence
|
|
->>>9
|
|
|
|
ptp_trantype
|
Transport Type
|
Tran Type
|
x(8)
|
|
|
|
ptp_user1
|
Ufld1
|
|
x(8)
|
|
|
|
ptp_user2
|
Ufld2
|
|
x(8)
|
|
|
|
ptp_userid
|
User ID
|
|
x(8)
|
|
|
|
ptp_vend
|
Supplier
|
|
x(8)
|
|
|
|
ptp_wks_avg
|
Avg Weeks Cover
|
Avg Wks
|
>>9.9
|
10
|
|
|
ptp_wks_max
|
Max Weeks Cover
|
Max Wks
|
>>9.9
|
10
|
|
|
ptp_wks_min
|
Min Weeks Cover
|
Min Wks
|
>>9.9
|
10
|
|
|
ptp_yld_pct
|
Yield%
|
|
>>9.99%
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
oid_ptp_det
|
yes
|
oid_ptp_det
|
yes
|
no
|
|
|
ptp_bom_code
|
no
|
ptp_domain
|
yes
|
no
|
|
|
|
|
ptp_bom_code
|
yes
|
no
|
|
|
|
|
ptp_part
|
yes
|
no
|
|
|
ptp_network
|
no
|
ptp_domain
|
yes
|
no
|
|
|
|
|
ptp_network
|
yes
|
no
|
|
|
|
|
ptp_site
|
yes
|
no
|
|
|
|
|
ptp_part
|
yes
|
no
|
|
∗
|
ptp_part
|
yes
|
ptp_domain
|
yes
|
no
|
|
|
|
|
ptp_part
|
yes
|
no
|
|
|
|
|
ptp_site
|
yes
|
no
|
|
|
ptp_routing
|
yes
|
ptp_domain
|
yes
|
no
|
|
|
|
|
ptp_routing
|
yes
|
no
|
|
|
|
|
ptp_part
|
yes
|
no
|
|
|
|
|
ptp_site
|
yes
|
no
|
|
|
ptp_site
|
yes
|
ptp_domain
|
yes
|
no
|
|
|
|
|
ptp_site
|
yes
|
no
|
|
|
|
|
ptp_part
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
oid_ptqa_det
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
ptqa__chr01
|
|
|
x(8)
|
|
|
|
ptqa__chr02
|
|
|
x(8)
|
|
|
|
ptqa__chr03
|
|
|
x(8)
|
|
|
|
ptqa__chr04
|
|
|
x(8)
|
|
|
|
ptqa__chr05
|
|
|
x(8)
|
|
|
|
ptqa__dec01
|
|
|
->>,>>9.99
|
10
|
|
|
ptqa__dec02
|
|
|
->>,>>9.99
|
10
|
|
|
ptqa__log01
|
|
|
yes/no
|
|
|
|
ptqa__log02
|
|
|
yes/no
|
|
|
|
ptqa_cmtindx
|
Comment Index
|
|
>>>>>>>9
|
|
|
|
ptqa_conf_pct
|
Confidence %
|
Conf %
|
>>9.9<%
|
10
|
|
|
ptqa_domain
|
Domain
|
|
x(8)
|
|
|
|
ptqa_element
|
Analysis Element
|
Element
|
x(8)
|
|
|
|
ptqa_interval
|
Confidence Interval
|
Conf Interval
|
>>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
ptqa_part
|
Item Number
|
|
x(18)
|
|
|
|
ptqa_qty
|
Quantity
|
|
>>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
ptqa_um
|
UM
|
|
x(4)
|
|
|
|
ptqa_user1
|
Ufld1
|
|
x(8)
|
|
|
|
ptqa_user2
|
Ufld2
|
|
x(8)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
oid_ptqa_det
|
yes
|
oid_ptqa_det
|
yes
|
no
|
|
|
ptqa_element
|
yes
|
ptqa_domain
|
yes
|
no
|
|
|
|
|
ptqa_element
|
yes
|
no
|
|
|
|
|
ptqa_part
|
yes
|
no
|
|
∗
|
ptqa_part
|
yes
|
ptqa_domain
|
yes
|
no
|
|
|
|
|
ptqa_part
|
yes
|
no
|
|
|
|
|
ptqa_element
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
oid_ptre_det
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
ptre__qadc01
|
|
|
x(24)
|
|
|
|
ptre__qadc02
|
|
|
x(24)
|
|
|
|
ptre__qadd01
|
|
|
->>>>,>>>,>>9.99<<<<<<<<
|
10
|
|
|
ptre__qadi01
|
|
|
->>>>>>>9
|
|
|
|
ptre__qadl01
|
|
|
yes/no
|
|
|
|
ptre__qadt01
|
|
|
99/99/99
|
|
|
|
ptre_auto_accept
|
Auto Accept
|
|
yes/no
|
|
|
|
ptre_cmtindx
|
Comment Index
|
Comment
|
>>>>>>>9
|
|
|
|
ptre_cust
|
Customer
|
|
x(8)
|
|
|
|
ptre_default
|
Default
|
|
yes/no
|
|
|
|
ptre_domain
|
Domain
|
|
x(8)
|
|
|
|
ptre_eff_date
|
Eff Date
|
|
99/99/99
|
|
|
|
ptre_end_date
|
End Eff Date
|
End Date
|
99/99/99
|
|
|
|
ptre_include
|
Include
|
Inc
|
yes/no
|
|
|
|
ptre_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
ptre_mod_userid
|
User ID
|
|
x(8)
|
|
|
|
ptre_part
|
Item Number
|
|
x(18)
|
|
|
|
ptre_pco
|
PCO Number
|
PCO
|
x(8)
|
|
|
|
ptre_preference
|
Preference
|
|
>>>>>>>9
|
|
|
|
ptre_qty
|
Quantity
|
|
->,>>>,>>9.9<<<<<<<<
|
10
|
|
|
ptre_ref
|
Reference
|
|
x(18)
|
|
|
|
ptre_rep_part
|
Replacement Item
|
|
x(18)
|
|
|
|
ptre_rep_qty
|
Replacement Qty
|
|
->,>>>,>>9.9<<<<<<<<
|
10
|
|
|
ptre_round_qty
|
Round Qty
|
|
x(8)
|
|
|
|
ptre_schd_chg_qty
|
Schedule Change Over Qty
|
|
>,>>>,>>>,>>9.9<<<<<<<<
|
10
|
|
|
ptre_site
|
Site
|
|
x(8)
|
|
|
|
ptre_type
|
Type
|
|
x(8)
|
|
|
|
ptre_user1
|
User Field Character 1
|
|
x(24)
|
|
|
|
ptre_user2
|
User Field character 2
|
|
x(24)
|
|
|
|
ptre_userd01
|
User Field Decimal 1
|
|
->>>>,>>>,>>9.99<<<<<<<<
|
10
|
|
|
ptre_useri01
|
User Field Integer 1
|
|
->>>>>>>9
|
|
|
|
ptre_userl01
|
User Field Logical 1
|
|
yes/no
|
|
|
|
ptre_usert01
|
User Field Date 1
|
|
99/99/99
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
oid_ptre_det
|
yes
|
oid_ptre_det
|
yes
|
no
|
|
∗
|
ptre_part
|
yes
|
ptre_domain
|
yes
|
no
|
|
|
|
|
ptre_type
|
yes
|
no
|
|
|
|
|
ptre_part
|
yes
|
no
|
|
|
|
|
ptre_site
|
yes
|
no
|
|
|
|
|
ptre_cust
|
yes
|
no
|
|
|
|
|
ptre_eff_date
|
yes
|
no
|
|
|
|
|
ptre_rep_part
|
yes
|
no
|
|
|
ptre_rep_part
|
no
|
ptre_domain
|
yes
|
no
|
|
|
|
|
ptre_type
|
yes
|
no
|
|
|
|
|
ptre_rep_part
|
yes
|
no
|
|
|
|
|
ptre_site
|
yes
|
no
|
|
|
|
|
ptre_cust
|
yes
|
no
|
|
|
|
|
ptre_eff_date
|
yes
|
no
|
|
|
|
|
ptre_part
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
oid_ptr_det
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
ptr__qadc01
|
|
|
x(8)
|
|
|
|
ptr_appr_id
|
Approved By
|
Appr ID
|
x(8)
|
|
|
|
ptr_apprdate
|
Approved Date
|
Approved
|
99/99/99
|
|
|
|
ptr_batch
|
Batch Qty
|
|
>>,>>>,>>9.9<<<<<<<<
|
10
|
|
|
ptr_bom_code
|
BOM/Formula
|
|
x(18)
|
|
|
|
ptr_burden
|
Burden Cost
|
|
>>>>,>>>,>>9.99<<<
|
10
|
|
|
ptr_cmtindx
|
Comment Index
|
Comment
|
>>>>>>>9
|
|
|
|
ptr_domain
|
Domain
|
|
x(8)
|
|
|
|
ptr_end
|
End Effective
|
End Eff
|
99/99/99
|
|
|
|
ptr_labor
|
Labor Cost
|
|
>>>>,>>>,>>9.99<<<
|
10
|
|
|
ptr_material
|
Material Cost
|
|
>>>>,>>>,>>9.99<<<
|
10
|
|
|
ptr_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
ptr_overhead
|
Overhead
|
|
>>>>,>>>,>>9.99<<<
|
10
|
|
|
ptr_part
|
Item Number
|
|
x(18)
|
|
|
|
ptr_routing
|
Routing Code
|
|
x(18)
|
|
|
|
ptr_site
|
Site
|
|
x(8)
|
|
|
|
ptr_start
|
Start Effective
|
Start Eff
|
99/99/99
|
|
|
|
ptr_subcontract
|
Subcontract Cost
|
Subcontract
|
>>>>,>>>,>>9.99<<<
|
10
|
|
|
ptr_total_cost
|
Total Cost
|
|
>>>>,>>>,>>9.99<<<
|
10
|
|
|
ptr_user1
|
Ufld1
|
|
x(8)
|
|
|
|
ptr_user2
|
Ufld2
|
|
x(8)
|
|
|
|
ptr_userid
|
User ID
|
|
x(8)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
oid_ptr_det
|
yes
|
oid_ptr_det
|
yes
|
no
|
|
|
ptr_bom_code
|
no
|
ptr_domain
|
yes
|
no
|
|
|
|
|
ptr_bom_code
|
yes
|
no
|
|
|
|
|
ptr_part
|
yes
|
no
|
|
|
|
|
ptr_site
|
yes
|
no
|
|
∗
|
ptr_part
|
yes
|
ptr_domain
|
yes
|
no
|
|
|
|
|
ptr_part
|
yes
|
no
|
|
|
|
|
ptr_site
|
yes
|
no
|
|
|
|
|
ptr_routing
|
yes
|
no
|
|
|
|
|
ptr_bom_code
|
yes
|
no
|
|
|
|
|
ptr_start
|
yes
|
no
|
|
|
ptr_routing
|
no
|
ptr_domain
|
yes
|
no
|
|
|
|
|
ptr_routing
|
yes
|
no
|
|
|
|
|
ptr_part
|
yes
|
no
|
|
|
|
|
ptr_site
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
oid_pts_det
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
pts__qadc01
|
|
|
x(8)
|
|
|
|
pts_cmtindx
|
Comment Index
|
Index
|
>>>>>>>9
|
|
|
|
pts_domain
|
Domain
|
|
x(8)
|
|
|
|
pts_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
pts_par
|
Parent Item
|
|
x(18)
|
|
|
|
pts_part
|
Item Number
|
|
x(18)
|
|
|
|
pts_qty_per
|
Substitute Qty
|
Sub Qty
|
->>>,>>9.9<<<<<<
|
10
|
|
|
pts_rmks
|
Remarks
|
|
x(12)
|
|
|
|
pts_sub_part
|
Substitute Item
|
|
x(18)
|
|
|
|
pts_user1
|
Ufld1
|
|
x(8)
|
|
|
|
pts_user2
|
Ufld2
|
|
x(8)
|
|
|
|
pts_userid
|
User ID
|
|
x(8)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
oid_pts_det
|
yes
|
oid_pts_det
|
yes
|
no
|
|
∗
|
pts_det
|
yes
|
pts_domain
|
yes
|
no
|
|
|
|
|
pts_part
|
yes
|
no
|
|
|
|
|
pts_par
|
yes
|
no
|
|
|
|
|
pts_sub_part
|
yes
|
no
|
|
|
pts_par
|
yes
|
pts_domain
|
yes
|
no
|
|
|
|
|
pts_par
|
yes
|
no
|
|
|
|
|
pts_part
|
yes
|
no
|
|
|
|
|
pts_sub_part
|
yes
|
no
|
|
|
pts_sub_part
|
yes
|
pts_domain
|
yes
|
no
|
|
|
|
|
pts_sub_part
|
yes
|
no
|
|
|
|
|
pts_par
|
yes
|
no
|
|
|
|
|
pts_part
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
oid_ptt_det
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
ptt__qadc01
|
|
|
x(8)
|
|
|
|
ptt_domain
|
Domain
|
|
x(8)
|
|
|
|
ptt_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
ptt_part
|
Part
|
|
x(18)
|
|
|
|
ptt_tax_type
|
Tax Type
|
|
x(3)
|
|
|
|
ptt_taxable
|
Taxable
|
|
yes/no
|
|
|
|
ptt_taxc
|
Tax Class
|
TxC
|
x(3)
|
|
|
|
ptt_user1
|
Ufld1
|
|
x(8)
|
|
|
|
ptt_user2
|
Ufld2
|
|
x(8)
|
|
|
|
ptt_userid
|
User ID
|
|
x(8)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
oid_ptt_det
|
yes
|
oid_ptt_det
|
yes
|
no
|
|
∗
|
ptt_part
|
yes
|
ptt_domain
|
yes
|
no
|
|
|
|
|
ptt_part
|
yes
|
no
|
|
|
|
|
ptt_tax_type
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
oid_ptv_det
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
ptv__chr01
|
|
|
x(8)
|
|
|
|
ptv__dec01
|
|
|
->>>,>>>,>>9.99
|
10
|
|
|
ptv__log01
|
|
|
yes/no
|
|
|
|
ptv__qad01
|
|
|
x(8)
|
|
|
|
ptv__qad02
|
|
|
x(8)
|
|
|
|
ptv__qad03
|
|
|
->>>,>>>,>>9.99
|
10
|
|
|
ptv__qad04
|
|
|
yes/no
|
|
|
|
ptv_ctry_exp
|
Export Country
|
ExC
|
x(3)
|
|
|
|
ptv_ctry_imp
|
Import Country
|
ImC
|
x(3)
|
|
|
|
ptv_domain
|
Domain
|
|
x(8)
|
|
|
|
ptv_part
|
Item Number
|
|
x(18)
|
|
|
|
ptv_stat_value
|
Statistical Value
|
Stat Value
|
>>>>,>>>,>>9.99
|
10
|
|
|
ptv_user1
|
Ufld1
|
|
x(8)
|
|
|
|
ptv_user2
|
Ufld2
|
|
x(8)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
oid_ptv_det
|
yes
|
oid_ptv_det
|
yes
|
no
|
|
∗
|
ptv_part
|
yes
|
ptv_domain
|
yes
|
no
|
|
|
|
|
ptv_part
|
yes
|
no
|
|
|
|
|
ptv_ctry_exp
|
yes
|
no
|
|
|
|
|
ptv_ctry_imp
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
oid_pt_mstr
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
pt__chr01
|
|
|
x(8)
|
|
|
|
pt__chr02
|
|
|
x(8)
|
|
|
|
pt__chr03
|
|
|
x(8)
|
|
|
|
pt__chr04
|
|
|
x(8)
|
|
|
|
pt__chr05
|
|
|
x(8)
|
|
|
|
pt__chr06
|
|
|
x(8)
|
|
|
|
pt__chr07
|
|
|
x(8)
|
|
|
|
pt__chr08
|
|
|
x(8)
|
|
|
|
pt__chr09
|
|
|
x(8)
|
|
|
|
pt__chr10
|
|
|
x(8)
|
|
|
|
pt__dec01
|
|
|
>>>,>>>,>>9.99
|
10
|
|
|
pt__dec02
|
|
|
>>>,>>>,>>9.99
|
10
|
|
|
pt__dte01
|
|
|
99/99/99
|
|
|
|
pt__dte02
|
|
|
99/99/99
|
|
|
|
pt__log01
|
|
|
yes/no
|
|
|
|
pt__log02
|
|
|
yes/no
|
|
|
|
pt__qad01
|
|
|
->,>>>,>>9.9<<<<<<<<
|
10
|
|
|
pt__qad02
|
|
|
->,>>>,>>9.9<<<<<<<<
|
10
|
|
|
pt__qad03
|
|
|
->>>,>>9.999
|
10
|
|
|
pt__qad04
|
|
|
->>>,>>9.999
|
10
|
|
|
pt__qad05
|
|
|
99/99/99
|
|
|
|
pt__qad06
|
|
|
99/99/99
|
|
|
|
pt__qad07
|
|
|
99/99/99
|
|
|
|
pt__qad08
|
|
|
99/99/99
|
|
|
|
pt__qad09
|
|
|
->,>>>,>>9.9<<<<<<<<
|
10
|
|
|
pt__qad10
|
|
|
->,>>>,>>9.9<<<<<<<<
|
10
|
|
|
pt__qad11
|
|
|
->,>>>,>>9.9<<<<<<<<
|
10
|
|
|
pt__qad12
|
|
|
>>>>9.9999<<<<
|
10
|
|
|
pt__qad13
|
Incorp Rev
|
Inc!Rev
|
x(4)
|
|
|
|
pt__qad14
|
|
|
99/99/99
|
|
|
|
pt__qad15
|
|
|
yes/no
|
|
|
|
pt__qad16
|
|
|
>>>,>>9.9
|
0
|
|
|
pt__qad17
|
|
|
yes/no
|
|
|
|
pt__qad18
|
|
|
>>>>,>>>,>>9.99<<<
|
10
|
|
|
pt__qad19
|
|
|
>>>>,>>>,>>9.99<<<
|
10
|
|
|
pt__qad20
|
|
|
>>>>,>>>,>>9.99<<<
|
10
|
|
|
pt__qad21
|
|
|
>>>>,>>>,>>9.99<<<
|
10
|
|
|
pt__qad22
|
|
|
yes/no
|
|
|
|
pt__qad23
|
|
|
>>9
|
|
|
|
pt__qad24
|
|
|
>>9
|
|
|
|
pt__qad25
|
|
|
>>9
|
|
|
|
pt__qad26
|
|
|
yes/no
|
|
|
|
pt__qad27
|
|
|
->,>>>,>>9
|
|
|
|
pt_abc
|
ABC Class
|
ABC
|
x(1)
|
|
|
|
pt_abc_amt
|
ABC Value
|
|
->,>>>,>>9.9<<<<<<<<
|
10
|
|
|
pt_abc_qty
|
ABC Quantity
|
|
->,>>>,>>9.9<<<<<<<<
|
10
|
|
|
pt_added
|
Added
|
|
99/99/99
|
|
|
|
pt_app_owner
|
Owner Application
|
|
x(12)
|
|
|
|
pt_article
|
Article Number
|
|
x(18)
|
|
|
|
pt_assay
|
Assay %
|
|
>>9.99%
|
10
|
|
|
pt_atp_enforcement
|
ATP Enforcement
|
ATP Enf
|
x(1)
|
|
|
|
pt_atp_family
|
Family ATP
|
Fam ATP
|
yes/no
|
|
|
|
pt_atp_horizon
|
ATP Horizon
|
Horizon
|
>>>9
|
|
|
|
pt_auto_lot
|
Auto Lot Numbers
|
Auto!Lot
|
yes/no
|
|
|
|
pt_avg_int
|
Avg Int
|
Avg!Int
|
>>9
|
|
|
|
pt_barcode1
|
Barcode 1
|
Barcode 1
|
x(24)
|
|
|
|
pt_barcode2
|
Barcode 2
|
Barcode 2
|
x(24)
|
|
|
|
pt_batch
|
Batch Qty
|
|
>>,>>>,>>9.9<<<<<<<<
|
10
|
|
|
pt_bom_code
|
BOM/Formula
|
|
x(18)
|
|
|
|
pt_break_cat
|
Price Break Cat
|
|
x(18)
|
|
|
|
pt_btb_type
|
EMT Type
|
|
xx
|
|
|
|
pt_buyer
|
Buyer/Planner
|
Buy!Pln
|
x(8)
|
|
|
|
pt_cfg_type
|
Configuration
|
Config
|
x(1)
|
|
|
|
pt_classification
|
Classification
|
|
x(12)
|
|
|
|
pt_comm_code
|
Commodity Code
|
Comm Code
|
x(8)
|
|
|
|
pt_cover
|
Coverage
|
CV
|
x(1)
|
|
|
|
pt_crit_days
|
Critical Days
|
Critical!Days
|
>>,>>9
|
|
|
|
pt_critical
|
Key Item
|
|
yes/no
|
|
|
|
pt_cum_lead
|
Cum LT
|
Cum!LT
|
>>9
|
|
|
|
pt_cur_date
|
Cur Cost Update
|
Cur Update
|
99/99/99
|
|
|
|
pt_cyc_int
|
Cyc Cnt Int
|
Cyc!Int
|
>>9
|
|
|
|
pt_dea
|
DEA Controlled
|
DEA
|
yes/no
|
|
|
|
pt_desc1
|
Description
|
|
x(24)
|
|
|
|
pt_desc2
|
Description
|
|
x(24)
|
|
|
|
pt_destructive
|
Destructive
|
Destr
|
yes/no
|
|
|
|
pt_dim_um
|
Dimensns UM
|
|
x(2)
|
|
|
|
pt_domain
|
Domain
|
|
x(8)
|
|
|
|
pt_draw
|
Drawing
|
|
x(18)
|
|
|
|
pt_drp_pct
|
DRP
|
|
>>9.9<%
|
10
|
|
|
pt_drwg_loc
|
Drawing Loc
|
Drwg Loc
|
x(8)
|
|
|
|
pt_drwg_size
|
Drwg Size
|
DS
|
x(2)
|
|
|
|
pt_dsgn_grp
|
Design Group
|
Dsgn Grp
|
x(8)
|
|
|
|
pt_ecn_rev
|
ECN Rev
|
ECN!Rev
|
x(4)
|
|
|
|
pt_fiscal_class
|
Fiscal Class
|
|
x(18)
|
|
|
|
pt_fiscal_type
|
Fiscal Type
|
|
x(2)
|
|
|
|
pt_formula
|
Formula
|
|
yes/no
|
|
|
|
pt_fr_class
|
Freight Class
|
|
x(8)
|
|
|
|
pt_freight_nature
|
Freight Nature
|
|
x(1)
|
|
|
|
pt_fru
|
FRU
|
|
yes/no
|
|
|
|
pt_fsc_code
|
Service Category
|
Svc Cat
|
x(8)
|
|
|
|
pt_gcfg_type
|
Configuration Type
|
Cfg Type
|
x(8)
|
|
|
|
pt_group
|
Group
|
|
x(8)
|
|
|
|
pt_gtin_barcode1
|
GTIN Barcode 1
|
|
x(24)
|
|
|
|
pt_gtin_barcode2
|
GTIN Barcode 2
|
|
x(24)
|
|
|
|
pt_hazard
|
Hazard
|
|
x(8)
|
|
|
|
pt_height
|
Height
|
|
>>,>>9.9999
|
10
|
|
|
pt_id_qty
|
ID Quantity
|
ID!Qty
|
>>>9
|
|
|
|
pt_ins_bom
|
Installation BOM
|
Ins BOM
|
X(18)
|
|
|
|
pt_ins_call_type
|
Installation Call Type
|
Ins Call Type
|
X(8)
|
|
|
|
pt_ins_route
|
Installation Routing
|
Ins Route
|
X(18)
|
|
|
|
pt_insp_days
|
Insp Frequency (Days)
|
Insp Freq (D)
|
>>9
|
|
|
|
pt_insp_freq
|
Insp Frequency
|
Insp Freq.
|
>>>>>>9
|
|
|
|
pt_insp_lead
|
Ins LT
|
Ins!LT
|
>>9
|
|
|
|
pt_insp_ref
|
Ref
|
|
yes/no
|
|
|
|
pt_insp_req
|
Inspection Required
|
Insp Req
|
yes/no
|
|
|
|
pt_insp_rqd
|
Inspect
|
Ins!Req
|
yes/no
|
|
|
|
pt_inst_call
|
Install
|
|
yes/no
|
|
|
|
pt_invent_days[10]
|
Days From Expiration/Manufacture
|
Days From!Expire/!Manuf.
|
>>,>>9
|
|
|
|
pt_isb
|
Installed Base
|
Inst Base
|
yes/no
|
|
|
|
pt_iss_pol
|
Issue Policy
|
Iss
|
yes/no
|
|
|
|
pt_issue_method
|
Issue Method
|
Issue!Method
|
x(8)
|
|
|
|
pt_joint_type
|
Co/By Type
|
CT
|
x(1)
|
|
|
|
pt_last_eco
|
Last ECO
|
|
99/99/99
|
|
|
|
pt_length
|
Length
|
|
>>,>>9.9999
|
10
|
|
|
pt_ll_code
|
Low Level
|
Low Lvl
|
->>>>>9
|
|
|
|
pt_ll_drp
|
DRP Low Level
|
DRP LL
|
->>>>>9
|
|
|
|
pt_loc
|
Location
|
|
x(8)
|
|
|
|
pt_loc_type
|
Location Type
|
Loc Type
|
x(8)
|
|
|
|
pt_lot_grp
|
Lot Group
|
|
x(8)
|
|
|
|
pt_lot_ser
|
Lot/Serial Control
|
Lot/Ser
|
x(1)
|
|
|
|
pt_memo_type
|
Memo Order Type
|
|
x(1)
|
|
|
|
pt_meter_interval
|
Meter Interval
|
|
>>>>,>>>,>>9.99<<<
|
10
|
|
|
pt_meter_um
|
Meter UM
|
|
X(2)
|
|
|
|
pt_mfg_lead
|
Mfg LT
|
Mfg!LT
|
>>9
|
0
|
|
|
pt_mfg_mtbf
|
MFG MTBF
|
|
->>,>>9.99
|
10
|
|
|
pt_mfg_mttr
|
MFG MTTR
|
|
->>,>>9.99
|
10
|
|
|
pt_mfg_pct
|
Manufactured
|
Mfg
|
>>9.9<%
|
10
|
|
|
pt_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
pt_model
|
Model
|
|
x(18)
|
0
|
|
|
pt_mrp
|
MRP Required
|
MRP Req
|
yes/no
|
|
|
|
pt_ms
|
Master Sched
|
MS
|
yes/no
|
|
|
|
pt_mtbf
|
MTBF
|
|
>>,>>9.99
|
10
|
|
|
pt_mttr
|
MTTR
|
|
>>,>>9.99
|
10
|
|
|
pt_net_wt
|
Net Weight
|
|
->>,>>9.99<<<<
|
10
|
|
|
pt_net_wt_um
|
Net Weight UM
|
UM
|
x(2)
|
|
|
|
pt_network
|
Network Code
|
|
x(18)
|
|
|
|
pt_nve1_code
|
NVE code
|
|
x(6)
|
|
|
|
pt_nve2_code
|
NVE code
|
|
x(6)
|
|
|
|
pt_nve3_code
|
NVE code
|
|
x(6)
|
|
|
|
pt_nve4_code
|
NVE code
|
|
x(6)
|
|
|
|
pt_nve5_code
|
NVE code
|
|
x(6)
|
|
|
|
pt_nve6_code
|
NVE code
|
|
x(6)
|
|
|
|
pt_nve7_code
|
NVE code
|
|
x(6)
|
|
|
|
pt_nve8_code
|
NVE code
|
|
x(6)
|
|
|
|
pt_obs_date
|
Obsolete Date
|
|
99/99/99
|
|
|
|
pt_op_yield
|
Op Based Yield
|
|
yes/no
|
|
|
|
pt_opc_threshold
|
OPC Threshold
|
|
->>>,>>9.9<<<<<<
|
10
|
|
|
pt_ord_max
|
Max Ord
|
|
>>,>>>,>>9
|
0
|
|
|
pt_ord_min
|
Min Ord
|
|
>>,>>>,>>9
|
0
|
|
|
pt_ord_mult
|
Ord Mult
|
Mult
|
>>,>>>,>>9
|
0
|
|
|
pt_ord_per
|
Order Period
|
Ord!Per
|
>>9
|
|
|
|
pt_ord_pol
|
Order Policy
|
Ord!Pol
|
x(3)
|
|
|
|
pt_ord_qty
|
Order Qty
|
|
>>,>>>,>>9
|
10
|
|
|
pt_origin
|
Country of Origin
|
|
x(12)
|
|
|
|
pt_part
|
Item Number
|
|
x(18)
|
|
|
|
pt_part_type
|
Item Type
|
Type
|
x(8)
|
|
|
|
pt_phantom
|
Phantom
|
|
yes/no
|
|
|
|
pt_pick_logic
|
Pick Logic
|
Pick
|
-9
|
|
|
|
pt_pkg_code
|
Pkg Code
|
|
x(18)
|
|
|
|
pt_plan_ord
|
Plan Orders
|
Pln
|
yes/no
|
|
|
|
pt_pm_code
|
Pur/Mfg
|
P/M
|
x(1)
|
|
|
|
pt_pm_mrp
|
Need PM MRP
|
|
yes/no
|
|
|
|
pt_po_site
|
PO Site
|
|
x(8)
|
|
|
|
pt_pop_code
|
Popularity
|
|
X(8)
|
|
|
|
pt_pou_code
|
Point of Use Code
|
|
x(18)
|
|
|
|
pt_price
|
Price
|
|
>>>>,>>>,>>9.99<<<
|
10
|
|
|
pt_print_id
|
Print ID
|
Print!ID
|
yes/no
|
|
|
|
pt_prod_line
|
Prod Line
|
Line
|
x(4)
|
|
|
|
pt_promo
|
Promotion Group
|
|
x(10)
|
|
|
|
pt_pur_lead
|
Pur LT
|
Pur!LT
|
>>9
|
|
|
|
pt_pur_pct
|
Purchased
|
Pur
|
>>9.9<%
|
10
|
|
|
pt_pvm_bom
|
PM BOM
|
|
x(18)
|
|
|
|
pt_pvm_days
|
Days Between PM
|
PM Days
|
>>>>9
|
|
|
|
pt_pvm_route
|
PM Routing
|
|
x(18)
|
|
|
|
pt_pvm_um
|
UM
|
|
x(2)
|
|
|
|
pt_qc_lead
|
QC LT
|
|
>>9
|
|
|
|
pt_random_insp_pct
|
Random Inspection %
|
|
->>9.99
|
10
|
|
|
pt_rctpo_active
|
Active
|
Act
|
yes/no
|
|
|
|
pt_rctpo_status
|
PO Rcpt Status
|
Status
|
x(8)
|
|
|
|
pt_rctwo_active
|
Active
|
Act
|
yes/no
|
|
|
|
pt_rctwo_status
|
WO Rcpt Status
|
Status
|
x(8)
|
|
|
|
pt_rep_type
|
Replenishment Type
|
Rep Type
|
X(8)
|
|
|
|
pt_repairable
|
Repairable
|
|
yes/no
|
|
|
|
pt_replenishment_mthd
|
Replenishment Method
|
|
x(8)
|
|
|
|
pt_rev
|
Rev
|
|
x(4)
|
|
|
|
pt_rollup
|
Rollup Reqd
|
|
yes/no
|
|
|
|
pt_rollup_id
|
Rollup ID
|
|
x(8)
|
|
|
|
pt_rop
|
Reorder Point
|
ROP
|
>>>,>>9
|
0
|
|
|
pt_routing
|
Routing Code
|
|
x(18)
|
|
|
|
pt_rp_bom
|
Repair BOM
|
|
x(18)
|
|
|
|
pt_rp_route
|
Repair Routing
|
|
x(18)
|
|
|
|
pt_rp_vendor
|
Repair Supplier
|
|
x(8)
|
|
|
|
pt_run
|
Run Time
|
Run
|
>>>,>>9.999<<<<<<
|
10
|
|
|
pt_run_ll
|
Run LL
|
|
>>>,>>9.999<<<<<<
|
10
|
|
|
pt_run_seq1
|
Run Seq 1
|
|
x(8)
|
|
|
|
pt_run_seq2
|
2
|
Run Seq 2
|
x(8)
|
|
|
|
pt_same_days[10]
|
Same Day Window
|
Same Day!Window
|
>>,>>9
|
|
|
|
pt_sample_pct
|
Sample %
|
Sample %
|
>>9
|
|
|
|
pt_sample_qty
|
Sample Quantity
|
Sample Qty
|
->,>>>,>>9.9<<<<<<<<
|
10
|
|
|
pt_serialized
|
Serialized
|
|
>9
|
|
|
|
pt_service_code
|
Service Code
|
|
x(4)
|
|
|
|
pt_setup
|
Setup Time
|
Setup
|
>>>,>>9.999<<<<<<
|
10
|
|
|
pt_setup_ll
|
Setup LL
|
|
>>>,>>9.999<<<<<<
|
10
|
|
|
pt_sfty_stk
|
Safety Stk
|
Safety!Stock
|
>>,>>>,>>9
|
0
|
|
|
pt_sfty_time
|
Safety Time
|
Safety!Time
|
>>9
|
0
|
|
|
pt_shelf_offset
|
Shelf Life Offset
|
Shelf Life!Offset
|
>>,>>9
|
|
|
|
pt_shelflife
|
Shelf Life
|
|
->,>>>,>>>
|
|
|
|
pt_ship_wt
|
Ship Weight
|
|
->>,>>9.99<<<<
|
10
|
|
|
pt_ship_wt_um
|
Ship Weight UM
|
UM
|
x(2)
|
|
|
|
pt_single_trans
|
Single Put-Away Transactions
|
Single!Trans
|
yes/no
|
|
|
|
pt_site
|
Site
|
|
x(8)
|
|
|
|
pt_size
|
Size
|
|
->>,>>9.99
|
10
|
|
|
pt_size_um
|
Size UM
|
UM
|
x(2)
|
|
|
|
pt_sngl_lot
|
Allocate Single Lot
|
Sngl!Lot
|
yes/no
|
|
|
|
pt_sourcetype
|
Source Type
|
|
x(8)
|
|
|
|
pt_spec_grav
|
Specific Gravity
|
Spec Grav
|
>>,>>9.9<<<
|
10
|
|
|
pt_spec_hdlg
|
Special Handling Code
|
|
x(8)
|
|
|
|
pt_status
|
Status
|
St
|
x(8)
|
|
|
|
pt_std_date
|
Std Cost Update
|
|
99/99/99
|
|
|
|
pt_sttr
|
STTR
|
|
->>,>>9.99
|
10
|
|
|
pt_svc_group
|
Service Group
|
Svc Grp
|
x(8)
|
|
|
|
pt_svc_type
|
Service Type
|
Ser Type
|
x(2)
|
0
|
|
|
pt_sys_type
|
System Type
|
|
x(2)
|
|
|
|
pt_tariff
|
Tariff
|
|
x(8)
|
|
|
|
pt_taxable
|
Tax
|
|
yes/no
|
|
|
|
pt_taxc
|
Tax Class
|
TxC
|
x(3)
|
|
|
|
pt_timefence
|
Time Fence
|
|
->>>9
|
|
|
|
pt_trace_active
|
Trace Active
|
|
yes/no
|
|
|
|
pt_trace_detail
|
Trace Detail
|
|
yes/no
|
|
|
|
pt_trade_class
|
Trade Class
|
|
x(8)
|
|
|
|
pt_transtype
|
Transport Type
|
Tran Type
|
x(8)
|
|
|
|
pt_um
|
UM
|
|
x(2)
|
|
|
|
pt_um_group
|
UM Group
|
|
x(8)
|
|
|
|
pt_unit_isb
|
Isb Unit Quantity
|
|
yes/no
|
|
|
|
pt_upc
|
UPC
|
|
x(12)
|
|
|
|
pt_user1
|
Ufld1
|
|
x(8)
|
|
|
|
pt_user2
|
Ufld2
|
|
x(8)
|
|
|
|
pt_user3
|
User3
|
|
x(8)
|
|
|
|
pt_userid
|
User ID
|
|
x(8)
|
|
|
|
pt_ven_warr
|
Supplier Warranty
|
Supp|Warr
|
yes/no
|
|
|
|
pt_vend
|
Supplier
|
|
x(8)
|
|
|
|
pt_warr_cd
|
Warranty Code
|
Warr Cd
|
x(8)
|
|
|
|
pt_wh
|
Warehoused Item
|
WH
|
yes/no
|
|
|
|
pt_whse_part_type
|
Warehouse Item Type
|
Warehouse!Item Type
|
x(8)
|
|
|
|
pt_width
|
Width
|
|
>>,>>9.9999
|
10
|
|
|
pt_wks_avg
|
Average Weeks of Coverage
|
Avg!Cover
|
>>9.9
|
10
|
|
|
pt_wks_max
|
Maximum Weeks of Coverage
|
Max!Cover
|
>>9.9
|
10
|
|
|
pt_wks_min
|
Minimum Weeks of Coverage
|
Min!Cover
|
>>9.9
|
10
|
|
|
pt_xbdn_ll
|
Cur Burden LL
|
|
>>>>,>>>,>>9.99<<<
|
10
|
|
|
pt_xbdn_stdll
|
Std Burden LL
|
|
>>>>,>>>,>>9.99<<<
|
10
|
|
|
pt_xbdn_stdtl
|
Std Burden TL
|
|
>>>>,>>>,>>9.99<<<
|
10
|
|
|
pt_xbdn_tl
|
Cur Burden TL
|
|
>>>>,>>>,>>9.99<<<
|
10
|
|
|
pt_xlbr_ll
|
Cur Labor LL
|
|
>>>>,>>>,>>9.99<<<
|
10
|
|
|
pt_xlbr_stdll
|
Std Lbr LL
|
|
>>>>,>>>,>>9.99<<<
|
10
|
|
|
pt_xlbr_stdtl
|
Std Labor TL
|
|
>>>>,>>>,>>9.99<<<
|
10
|
|
|
pt_xlbr_tl
|
Cur Labor TL
|
|
>>>>,>>>,>>9.99<<<
|
10
|
|
|
pt_xmtl_ll
|
Cur Matl LL
|
|
>>>>,>>>,>>9.99<<<
|
10
|
|
|
pt_xmtl_stdll
|
Std Mtl LL
|
|
>>>>,>>>,>>9.99<<<
|
10
|
|
|
pt_xmtl_stdtl
|
Std Matl TL
|
|
>>>>,>>>,>>9.99<<<
|
10
|
|
|
pt_xmtl_tl
|
Cur Matl TL
|
|
>>>>,>>>,>>9.99<<<
|
10
|
|
|
pt_xovh_ll
|
Cur Ovhead LL
|
|
>>>>,>>>,>>9.99<<<
|
10
|
|
|
pt_xovh_stdll
|
Std Ovhead LL
|
|
>>>>,>>>,>>9.99<<<
|
10
|
|
|
pt_xovh_stdtl
|
Std Ovhead TL
|
|
>>>>,>>>,>>9.99<<<
|
10
|
|
|
pt_xovh_tl
|
Cur Ovhead TL
|
|
>>>>,>>>,>>9.99<<<
|
10
|
|
|
pt_xsub_ll
|
Cur Sub LL
|
|
>>>>,>>>,>>9.99<<<
|
10
|
|
|
pt_xsub_stdll
|
Std Sub LL
|
|
>>>>,>>>,>>9.99<<<
|
10
|
|
|
pt_xsub_stdtl
|
Std Sub TL
|
|
>>>>,>>>,>>9.99<<<
|
10
|
|
|
pt_xsub_tl
|
Cur Sub TL
|
|
>>>>,>>>,>>9.99<<<
|
10
|
|
|
pt_xtot_cur
|
Total TL & LL
|
|
>>>>,>>>,>>9.99<<<
|
10
|
|
|
pt_xtot_std
|
Std Total
|
|
>>>>,>>>,>>9.99<<<
|
10
|
|
|
pt_yield_pct
|
Yield%
|
|
>>9.99%
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
oid_pt_mstr
|
yes
|
oid_pt_mstr
|
yes
|
no
|
|
|
pt_barcode1
|
no
|
pt_domain
|
yes
|
no
|
|
|
|
|
pt_barcode1
|
yes
|
no
|
|
|
|
|
pt_sourcetype
|
yes
|
no
|
|
|
pt_barcode2
|
no
|
pt_domain
|
yes
|
no
|
|
|
|
|
pt_barcode2
|
yes
|
no
|
|
|
|
|
pt_sourcetype
|
yes
|
no
|
|
|
pt_bom_code
|
no
|
pt_domain
|
yes
|
no
|
|
|
|
|
pt_bom_code
|
yes
|
no
|
|
|
|
|
pt_part
|
yes
|
no
|
|
|
|
|
pt_sourcetype
|
yes
|
no
|
|
|
pt_desc
|
yes
|
pt_domain
|
yes
|
no
|
|
|
|
|
pt_desc1
|
yes
|
no
|
|
|
|
|
pt_desc2
|
yes
|
no
|
|
|
|
|
pt_part
|
yes
|
no
|
|
|
|
|
pt_sourcetype
|
yes
|
no
|
|
|
pt_group
|
yes
|
pt_domain
|
yes
|
no
|
|
|
|
|
pt_group
|
yes
|
no
|
|
|
|
|
pt_part
|
yes
|
no
|
|
|
|
|
pt_sourcetype
|
yes
|
no
|
|
|
pt_model
|
no
|
pt_domain
|
yes
|
no
|
|
|
|
|
pt_model
|
yes
|
no
|
|
|
|
|
pt_sourcetype
|
yes
|
no
|
|
|
pt_network
|
no
|
pt_domain
|
yes
|
no
|
|
|
|
|
pt_network
|
yes
|
no
|
|
|
|
|
pt_part
|
yes
|
no
|
|
|
|
|
pt_sourcetype
|
yes
|
no
|
|
∗
|
pt_part
|
yes
|
pt_domain
|
yes
|
no
|
|
|
|
|
pt_part
|
yes
|
no
|
|
|
pt_part_type
|
yes
|
pt_domain
|
yes
|
no
|
|
|
|
|
pt_part_type
|
yes
|
no
|
|
|
|
|
pt_part
|
yes
|
no
|
|
|
|
|
pt_sourcetype
|
yes
|
no
|
|
|
pt_pm_mrp
|
no
|
pt_domain
|
yes
|
no
|
|
|
|
|
pt_pm_mrp
|
yes
|
no
|
|
|
|
|
pt_part
|
yes
|
no
|
|
|
|
|
pt_sourcetype
|
yes
|
no
|
|
|
pt_prod_part
|
yes
|
pt_domain
|
yes
|
no
|
|
|
|
|
pt_prod_line
|
yes
|
no
|
|
|
|
|
pt_part
|
yes
|
no
|
|
|
|
|
pt_sourcetype
|
yes
|
no
|
|
|
pt_pvm_bom
|
no
|
pt_domain
|
yes
|
no
|
|
|
|
|
pt_pvm_bom
|
yes
|
no
|
|
|
|
|
pt_part
|
yes
|
no
|
|
|
|
|
pt_sourcetype
|
yes
|
no
|
|
|
pt_routing
|
yes
|
pt_domain
|
yes
|
no
|
|
|
|
|
pt_routing
|
yes
|
no
|
|
|
|
|
pt_part
|
yes
|
no
|
|
|
|
|
pt_sourcetype
|
yes
|
no
|
|
|
pt_sourcetype
|
yes
|
pt_domain
|
yes
|
no
|
|
|
|
|
pt_sourcetype
|
yes
|
no
|
|
|
|
|
pt_part
|
yes
|
no
|
|
|
pt_svc_group
|
no
|
pt_domain
|
yes
|
no
|
|
|
|
|
pt_svc_group
|
yes
|
no
|
|
|
|
|
pt_sourcetype
|
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
|
Lst Modified Date
|
|
99/99/9999
|
|
|
|
LastModifiedTime
|
Lst Modified Time
|
|
99999
|
|
|
|
LastModifiedUser
|
Lst Modified User
|
|
x(20)
|
|
|
|
PurchaseCode
|
Code
|
|
x(20)
|
|
|
|
PurchaseCode_ID
|
Record ID
|
|
-99999999999
|
|
|
|
PurchaseCodeDescription
|
Description
|
|
x(40)
|
|
|
|
PurchaseCodeIsActive
|
Active
|
|
yes/no
|
|
|
|
PurchaseCodeType
|
Type
|
|
x(20)
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
Active
|
no
|
PurchaseCodeIsActive
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
PurchaseCode_ID
|
yes
|
no
|
|
|
PurchaseCode
|
yes
|
PurchaseCode
|
yes
|
no
|
|
|
PurchaseType
|
no
|
PurchaseCodeType
|
yes
|
no
|
|
|
ViewIndex
|
no
|
PurchaseCodeIsActive
|
yes
|
no
|
|
|
|
|
PurchaseCode
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
CostCentreGL_ID
|
Link to CostCentreGL_ID
|
|
-99999999999
|
|
|
|
CreditorPurchaseCode_ID
|
Link to CreditorPurchaseCode
|
|
-99999999999
|
|
|
|
ItemPurchaseCode_ID
|
Link to ItemPurchaseCode
|
|
-99999999999
|
|
|
|
LastModifiedDate
|
Lst Modified Date
|
|
99/99/9999
|
|
|
|
LastModifiedTime
|
Lst Modified Time
|
|
99999
|
|
|
|
LastModifiedUser
|
Lst Modified User
|
|
x(20)
|
|
|
|
NoAnalysisGL_ID
|
Link to NoAnalysisGL_ID
|
|
-99999999999
|
|
|
|
ProjectGL_ID
|
Link to ProjectGL_ID
|
|
-99999999999
|
|
|
|
PurchaseGLMatrix_ID
|
Record ID
|
|
-99999999999
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
SharedSet_ID
|
Link to SharedSet
|
|
-99999999999
|
|
|
|
StockMovementGL_ID
|
Link to StockMovementGL_ID
|
|
-99999999999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
CostCentreGL
|
no
|
CostCentreGL_ID
|
yes
|
no
|
|
|
CredItemSet
|
yes
|
SharedSet_ID
|
yes
|
no
|
|
|
|
|
CreditorPurchaseCode_ID
|
yes
|
no
|
|
|
|
|
ItemPurchaseCode_ID
|
yes
|
no
|
|
|
CredPurch
|
no
|
CreditorPurchaseCode_ID
|
yes
|
no
|
|
|
ItemPurch
|
no
|
ItemPurchaseCode_ID
|
yes
|
no
|
|
|
NoAnalysisGL
|
no
|
NoAnalysisGL_ID
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
PurchaseGLMatrix_ID
|
yes
|
no
|
|
|
ProjectGL
|
no
|
ProjectGL_ID
|
yes
|
no
|
|
|
SharedSet
|
no
|
SharedSet_ID
|
yes
|
no
|
|
|
StockMovIdx
|
no
|
StockMovementGL_ID
|
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)
|
|
|
|
PurchaseType_ID
|
Record ID
|
|
-99999999999
|
|
|
|
PurchaseTypeCode
|
Purchase Type
|
|
x(4)
|
|
|
|
PurchaseTypeDescription
|
Description
|
|
x(40)
|
|
|
|
PurchaseTypeIsActive
|
Active
|
|
yes/no
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
Code
|
yes
|
PurchaseTypeCode
|
yes
|
no
|
|
|
LastModIdx
|
no
|
LastModifiedDate
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
PurchaseType_ID
|
yes
|
no
|
|
|
ViewIndex
|
yes
|
PurchaseTypeIsActive
|
yes
|
no
|
|
|
|
|
PurchaseTypeCode
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
oid_pvod_det
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
pvod__qadc01
|
|
|
x(24)
|
|
|
|
pvod__qadc02
|
|
|
x(24)
|
|
|
|
pvod__qadc03
|
|
|
x(24)
|
|
|
|
pvod__qadc04
|
|
|
x(24)
|
|
|
|
pvod__qadd01
|
|
|
->>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
pvod_accrual_acct
|
Accrual Account
|
Accrual!Account
|
x(8)
|
|
|
|
pvod_accrual_cc
|
Accrual Cost Ctr
|
Accrual!CC
|
x(4)
|
|
|
|
pvod_accrual_sub
|
Accrual Sub-Account
|
Accrual!Sub-Acct
|
x(8)
|
|
|
|
pvod_accrued_amt
|
Accrued Amount
|
|
->>>>,>>>,>>9.99<
|
10
|
|
|
pvod_bdn_std
|
Item Burden Cost
|
Item Burden
|
->>>,>>>,>>9.99<<<
|
10
|
|
|
pvod_channel
|
Channel
|
|
x(8)
|
|
|
|
pvod_cinvoice_id
|
Invoice ID
|
|
-99999999999
|
|
|
|
pvod_cost_update
|
Update Current Cost
|
|
yes/no
|
|
|
|
pvod_domain
|
Domain
|
|
x(8)
|
|
|
|
pvod_eff_date
|
Effective Date
|
Eff Date
|
99/99/99
|
|
|
|
pvod_ex_rate
|
Exch Rate
|
|
>>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
pvod_ex_rate2
|
Exch Rate 2
|
|
>>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
pvod_ex_ratetype
|
Rate Type
|
|
x(8)
|
|
|
|
pvod_exru_seq
|
Sequence
|
|
>>>>>>>>9
|
|
|
|
pvod_id
|
Pending Voucher ID
|
Pend Vchr
|
>>>>>>>>>
|
|
|
|
pvod_id_line
|
Line
|
Ln
|
>>>>>>>9
|
|
|
|
pvod_internal_ref
|
Internal Reference
|
|
x(23)
|
|
|
|
pvod_internal_ref_type
|
Internal Reference Type
|
Internal!Ref Type
|
x(2)
|
|
|
|
pvod_last_voucher
|
Supplier Invoice
|
|
x(22)
|
|
|
|
pvod_lbr_std
|
Item Labor Cost
|
Item Labor
|
->>>,>>>,>>9.99<<<
|
10
|
|
|
pvod_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
pvod_mod_userid
|
User ID
|
|
x(8)
|
|
|
|
pvod_mtl_std
|
Item Material Cost
|
Item Material
|
->>>,>>>,>>9.99<<<
|
10
|
|
|
pvod_order
|
Order
|
|
x(8)
|
|
|
|
pvod_order_line
|
Order Line
|
Ln
|
>>9
|
|
|
|
pvod_order_type
|
Order Type
|
Order!Type
|
x(2)
|
|
|
|
pvod_ovh_std
|
Item Overhead Cost
|
Item Overhead
|
->>>,>>>,>>9.99<<<
|
10
|
|
|
pvod_part
|
Item Number
|
Item
|
x(18)
|
|
|
|
pvod_project
|
Project
|
|
x(8)
|
|
|
|
pvod_pur_cost
|
PO Cost
|
|
->,>>>,>>>,>>9.99<<<
|
10
|
|
|
pvod_pur_std
|
Item PO Cost
|
|
->>>,>>>,>>9.99<<<
|
10
|
|
|
pvod_shipfrom
|
Ship-From
|
|
x(8)
|
|
|
|
pvod_shipto
|
Ship-To
|
|
x(8)
|
|
|
|
pvod_sub_std
|
Item Subcontract Cost
|
Item Subcontract
|
->>>,>>>,>>9.99<<<
|
10
|
|
|
pvod_tax_env
|
Tax Environment
|
Tax Env
|
x(16)
|
|
|
|
pvod_tax_in
|
Tax In
|
Tax!In
|
yes/no
|
|
|
|
pvod_tax_usage
|
Tax Usage
|
TaxUsage
|
x(8)
|
|
|
|
pvod_taxable
|
Taxable
|
Tax
|
yes/no
|
|
|
|
pvod_taxc
|
Tax Class
|
TxC
|
x(3)
|
|
|
|
pvod_trans_date
|
Transaction Date
|
Trans Date
|
99/99/99
|
|
|
|
pvod_trans_qty
|
Transaction Qty
|
Trans Qty
|
->>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
pvod_user1
|
User Field Character 1
|
|
x(24)
|
|
|
|
pvod_user2
|
User Field Character 2
|
|
x(24)
|
|
|
|
pvod_vouchered_amt
|
Vouchered Amount
|
|
->>>>,>>>,>>9.99<
|
10
|
|
|
pvod_vouchered_qty
|
Vouchered Qty
|
Vouchered Qty
|
->>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
oid_pvod_det
|
yes
|
oid_pvod_det
|
yes
|
no
|
|
∗
|
pvod_id
|
yes
|
pvod_domain
|
yes
|
no
|
|
|
|
|
pvod_id
|
yes
|
no
|
|
|
|
|
pvod_id_line
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
oid_pvo_mstr
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
pvo__qadc01
|
|
|
x(24)
|
|
|
|
pvo__qadc02
|
|
|
x(24)
|
|
|
|
pvo__qadc03
|
|
|
x(24)
|
|
|
|
pvo__qadc04
|
|
|
x(24)
|
|
|
|
pvo__qadd01
|
|
|
->>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
pvo__qadd02
|
|
|
->>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
pvo__qadd03
|
|
|
->>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
pvo__qadi01
|
|
|
>>>>>>>>>9
|
|
|
|
pvo_accrual_acct
|
Accrual Account
|
Accrual!Account
|
x(8)
|
|
|
|
pvo_accrual_cc
|
Accrual Cost Ctr
|
Accrual!CC
|
x(4)
|
|
|
|
pvo_accrual_sub
|
Accrual Sub-Account
|
Accrual!Sub-Acct
|
x(8)
|
|
|
|
pvo_accrued_amt
|
Accrued Amount
|
|
->>>>,>>>,>>9.99<
|
10
|
|
|
pvo_approver
|
Approved By
|
Approved
|
x(8)
|
|
|
|
pvo_buyer
|
Buyer
|
|
x(8)
|
|
|
|
pvo_cinvoice_id
|
Invoice ID
|
|
-99999999999
|
|
|
|
pvo_consignment
|
Consignment
|
|
yes/no
|
|
|
|
pvo_cost_update
|
Update Current Cost
|
|
yes/no
|
|
|
|
pvo_curr
|
Currency
|
Cur
|
x(3)
|
|
|
|
pvo_domain
|
Domain
|
|
x(8)
|
|
|
|
pvo_eff_date
|
GL Effective Date
|
Effective
|
99/99/99
|
|
|
|
pvo_ers_opt
|
ERS Option
|
ERS!Opt
|
>9
|
|
|
|
pvo_ers_price_lst_opt
|
ERS Price List Option
|
ERS!PLO
|
>9
|
|
|
|
pvo_ers_status
|
ERS Status
|
ERS!St
|
>9
|
|
|
|
pvo_external_ref
|
External Reference
|
External!Ref
|
x(20)
|
|
|
|
pvo_id
|
Pending Voucher ID
|
Pend Vchr
|
>>>>>>>>>
|
|
|
|
pvo_internal_ref
|
Internal Reference
|
Internal!Ref
|
x(20)
|
|
|
|
pvo_internal_ref_adj
|
Internal Reference Adjustment
|
Ref!Adj
|
>>
|
|
|
|
pvo_internal_ref_type
|
Internal Reference Type
|
Internal!Ref Type
|
x(2)
|
|
|
|
pvo_last_voucher
|
Voucher
|
|
x(22)
|
|
|
|
pvo_lc_charge
|
Logistics Charge Code
|
Chrg Code
|
x(8)
|
|
|
|
pvo_line
|
Line
|
Ln
|
>>9
|
|
|
|
pvo_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
pvo_mod_userid
|
User ID
|
|
x(8)
|
|
|
|
pvo_order
|
Order
|
|
x(8)
|
|
|
|
pvo_order_type
|
Order Type
|
Order!Type
|
x(2)
|
|
|
|
pvo_part
|
Item Number
|
Item
|
x(18)
|
|
|
|
pvo_project
|
Project
|
|
x(8)
|
|
|
|
pvo_shipfrom
|
Ship-From
|
|
x(8)
|
|
|
|
pvo_shipto
|
Ship-To
|
|
x(8)
|
|
|
|
pvo_supplier
|
Supplier
|
|
x(8)
|
|
|
|
pvo_tax_env
|
Tax Environment
|
Tax Env
|
x(16)
|
|
|
|
pvo_tax_in
|
Tax In
|
|
yes/no
|
|
|
|
pvo_tax_usage
|
Tax Usage
|
TaxUsage
|
x(8)
|
|
|
|
pvo_taxable
|
Taxable
|
|
yes/no
|
|
|
|
pvo_taxc
|
Tax Class
|
TxC
|
x(3)
|
|
|
|
pvo_trans_date
|
Transaction Date
|
Transaction
|
99/99/99
|
|
|
|
pvo_trans_qty
|
Transaction Qty
|
Trans Qty
|
->>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
pvo_user1
|
User Field Character 1
|
|
x(24)
|
|
|
|
pvo_user2
|
User Field Character 2
|
|
x(24)
|
|
|
|
pvo_vouchered_amt
|
Vouchered Amt
|
|
->>>>,>>>,>>9.99<
|
10
|
|
|
pvo_vouchered_qty
|
Vouchered Qty
|
|
->>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
oid_pvo_mstr
|
yes
|
oid_pvo_mstr
|
yes
|
no
|
|
|
pvo_eff_date
|
no
|
pvo_domain
|
yes
|
no
|
|
|
|
|
pvo_eff_date
|
yes
|
no
|
|
|
pvo_ers
|
no
|
pvo_domain
|
yes
|
no
|
|
|
|
|
pvo_ers_status
|
yes
|
no
|
|
|
|
|
pvo_lc_charge
|
yes
|
no
|
|
|
|
|
pvo_internal_ref
|
yes
|
no
|
|
|
|
|
pvo_internal_ref_adj
|
yes
|
no
|
|
|
|
|
pvo_line
|
yes
|
no
|
|
∗
|
pvo_id
|
yes
|
pvo_domain
|
yes
|
no
|
|
|
|
|
pvo_id
|
yes
|
no
|
|
|
pvo_internal_ref
|
no
|
pvo_domain
|
yes
|
no
|
|
|
|
|
pvo_internal_ref
|
yes
|
no
|
|
|
|
|
pvo_internal_ref_adj
|
yes
|
no
|
|
|
pvo_last_voucher
|
no
|
pvo_domain
|
yes
|
no
|
|
|
|
|
pvo_last_voucher
|
yes
|
no
|
|
|
|
|
pvo_curr
|
yes
|
no
|
|
|
|
|
pvo_lc_charge
|
yes
|
no
|
|
|
|
|
pvo_order
|
yes
|
no
|
|
|
pvo_logistics_charge
|
no
|
pvo_domain
|
yes
|
no
|
|
|
|
|
pvo_lc_charge
|
yes
|
no
|
|
|
|
|
pvo_internal_ref
|
yes
|
no
|
|
|
|
|
pvo_internal_ref_adj
|
yes
|
no
|
|
|
|
|
pvo_line
|
yes
|
no
|
|
|
|
|
pvo_external_ref
|
yes
|
no
|
|
|
pvo_order
|
no
|
pvo_domain
|
yes
|
no
|
|
|
|
|
pvo_order
|
yes
|
no
|
|
|
|
|
pvo_internal_ref
|
yes
|
no
|
|
|
|
|
pvo_internal_ref_adj
|
yes
|
no
|
|
|
|
|
pvo_line
|
yes
|
no
|
|
|
pvo_supplier
|
no
|
pvo_domain
|
yes
|
no
|
|
|
|
|
pvo_supplier
|
yes
|
no
|
|
|
|
|
pvo_last_voucher
|
yes
|
no
|
|
|
|
|
pvo_lc_charge
|
yes
|
no
|
|
|
pvo_trans_date
|
no
|
pvo_domain
|
yes
|
no
|
|
|
|
|
pvo_trans_date
|
yes
|
no
|