QAD 2017 Enterprise Edition > Technical References > Database Definitions >
  
prsd_det
Production Scheduler Resource Detail
 
 
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
prs_mstr
Production Scheduler Resource Master
 
 
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
pr_mstr
Printer Master
 
 
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
pshc_ctrl
Purchase Shipper Control
 
 
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
ps_mstr
Product Structure Master
 
 
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
ptat_ctrl
Item Attribute Control File
 
 
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
pta_det
Associated Item Detail
 
 
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
ptc_det
Container Item Detail
 
 
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
pth_hist
Products Sales History
 
 
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
pti_det
Item Inventory Data
 
 
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
ptls_det
Item Lot/Serial Detail
 
 
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
ptpac_det
Bill of Packaging Code by Domain/Item/Site/Address
 
 
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
ptp_det
Item Planning Detail
 
 
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
ptqa_det
Item Quantitative Analysis Detail
 
 
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
ptre_det
Item Replacement Detail
 
 
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
ptr_det
Item Routing Detail
 
 
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
pts_det
Item Substitute Detail
 
 
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
ptt_det
Item Tax Detail
 
 
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
ptv_det
Item Statistical Value Detail
 
 
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
pt_mstr
Item Master
 
 
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
PurchaseCode
Purchase Code
 
 
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
PurchaseGLMatrix
Purchase GL Matrix
 
 
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
PurchaseType
Purchase Type
 
 
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
pvod_det
Pending Voucher Detail
 
 
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
pvo_mstr
Pending Voucher Master
 
 
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