PUR_ITM_ATR_CVW

(SQL View)
 Index Back

Item Purchasing Attributes

Item Purchasing Attributes

SELECT A.SETID , A.INV_ITEM_ID , A.PO_AVAIL_DT , A.PO_UNAVAIL_DT , A.DESCR , A.DESCRSHORT , A.ACCOUNT , A.ALTACCT , %subrec(CF27_AN_SBR, A) , A.PRICE_LIST , A.TAXABLE_CD , A.AUTO_SOURCE , A.STD_LEAD , A.UNIT_PRC_TOL , A.EXT_PRC_TOL , A.PCT_UNIT_PRC_TOL , A.PCT_EXT_PRC_TOL , A.INSPECT_CD , A.INSPECT_UOM_TYPE , A.ROUTING_ID , A.RECV_REQ , A.QTY_RECV_TOL_PCT , A.RJCT_OVER_TOL_FLAG , A.RFQ_REQ_FLAG , A.REJECT_DAYS , A.PRIMARY_BUYER , A.MODEL , A.ACCEPT_ALL_VENDOR , A.ACCEPT_ALL_SHIPTO , A.CONTRACT_REQ , A.DESCR254_MIXED , A.FILENAME , A.FILE_EXTENSION , A.RECV_PARTIAL_FLG , A.CURRENCY_CD , A.PCT_UNDER_QTY , A.STOCKLESS_FLG , A.INSPECT_SAMPLE_PER , A.SRC_METHOD , A.LEAD_TIME_IMP , A.PRICE_IMP , A.SHIPTO_PR_IMP , A.VNDR_PR_IMP , A.USE_CAT_SRC_CNTL , A.UNIT_PRC_TOL_L , A.PCT_UNIT_PRC_TOL_L , A.EXT_PRC_TOL_L , A.PCT_EXT_PRC_TOL_L , A.PACKING_VOLUME , A.PACKING_WEIGHT , A.UNIT_MEASURE_VOL , A.UNIT_MEASURE_WT , A.SHIP_LATE_DAYS , A.SHIP_TYPE_ID , A.KB_PAST_DUE_PO , A.VAT_SVC_PERFRM_FLG , A.ULTIMATE_USE_CD FROM PS_PURCH_ITEM_ATTR A

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

Prompt Table: SP_SETID_NONVW

2 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
3 PO_AVAIL_DT Date(10) DATE PO Available Date
4 PO_UNAVAIL_DT Date(10) DATE PO Unavailable Date
5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
6 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
7 ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account
8 ALTACCT Character(10) VARCHAR2(10) NOT NULL Alternate Account
9 OPERATING_UNIT Character(8) VARCHAR2(8) NOT NULL Operating Unit ChartField

Prompt Table: OPERUNT_NB_VW

10 PRODUCT Character(6) VARCHAR2(6) NOT NULL Product ChartField

Prompt Table: PRODUCT_NB_VW

11 FUND_CODE Character(5) VARCHAR2(5) NOT NULL Fund Code

Prompt Table: FUND_NB_VW

12 CLASS_FLD Character(5) VARCHAR2(5) NOT NULL Class Field

Prompt Table: CLASS_CF_NB_VW

13 PROGRAM_CODE Character(5) VARCHAR2(5) NOT NULL Program Code ChartField

Prompt Table: PROGRAM_NB_VW

14 BUDGET_REF Character(8) VARCHAR2(8) NOT NULL Budget Reference

Prompt Table: BUD_REF_NB_VW

15 AFFILIATE Character(5) VARCHAR2(5) NOT NULL Affiliate

Prompt Table: AFFILIATE_VW

16 AFFILIATE_INTRA1 Character(10) VARCHAR2(10) NOT NULL IntraUnit Affiliate1

Prompt Table: %EDIT_INTRA01

17 AFFILIATE_INTRA2 Character(10) VARCHAR2(10) NOT NULL Operating Unit Affiliate

Prompt Table: %EDIT_INTRA02

18 CHARTFIELD1 Character(10) VARCHAR2(10) NOT NULL Expansion chartfield 1

Prompt Table: CF1_NB_VW

19 CHARTFIELD2 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 2

Prompt Table: CF2_NB_VW

20 CHARTFIELD3 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 3

Prompt Table: CF3_NB_VW

21 PRICE_LIST Number(16,5) DECIMAL(15,5) NOT NULL Standard Price
22 TAXABLE_CD Character(1) VARCHAR2(1) NOT NULL Taxable or Non-Taxable

Y/N Table Edit

23 AUTO_SOURCE Character(1) VARCHAR2(1) NOT NULL Auto Select
24 STD_LEAD Number(3,0) SMALLINT NOT NULL Purchase Lead Time Days
25 UNIT_PRC_TOL Number(14,5) DECIMAL(13,5) NOT NULL Unit Price Tolerance
26 EXT_PRC_TOL Number(14,5) DECIMAL(13,5) NOT NULL Ext Price Tolerance
27 PCT_UNIT_PRC_TOL Number(6,2) DECIMAL(5,2) NOT NULL % Unit Price Tolerance
28 PCT_EXT_PRC_TOL Number(6,2) DECIMAL(5,2) NOT NULL % Ext Price Tolerance
29 INSPECT_CD Character(1) VARCHAR2(1) NOT NULL Inspection Required
N=No
Y=Yes
30 INSPECT_UOM_TYPE Character(1) VARCHAR2(1) NOT NULL Inspection UOM
S=Standard
V=Supplier
31 ROUTING_ID Character(10) VARCHAR2(10) NOT NULL Inspection Routing ID
32 RECV_REQ Character(1) VARCHAR2(1) NOT NULL Receiving Required
N=Optional
X=Do Not
Y=Required
33 QTY_RECV_TOL_PCT Number(6,2) DECIMAL(5,2) NOT NULL Qty Rcvd Tolerance %
34 RJCT_OVER_TOL_FLAG Character(1) VARCHAR2(1) NOT NULL Reject Qty Over Tolerance
35 RFQ_REQ_FLAG Character(1) VARCHAR2(1) NOT NULL RFQ Required
36 REJECT_DAYS Number(3,0) SMALLINT NOT NULL Early Ship Rjct Days
37 PRIMARY_BUYER Character(30) VARCHAR2(30) NOT NULL Primary Buyer
38 MODEL Character(30) VARCHAR2(30) NOT NULL Model
39 ACCEPT_ALL_VENDOR Character(1) VARCHAR2(1) NOT NULL Accept Any Vendor
40 ACCEPT_ALL_SHIPTO Character(1) VARCHAR2(1) NOT NULL Accept Any Ship To
41 CONTRACT_REQ Character(1) VARCHAR2(1) NOT NULL Contract Required
42 DESCR254_MIXED Character(254) VARCHAR2(254) NOT NULL Description
43 FILENAME Character(80) VARCHAR2(80) NOT NULL File Name
44 FILE_EXTENSION Character(4) VARCHAR2(4) NOT NULL File Extension
45 RECV_PARTIAL_FLG Character(1) VARCHAR2(1) NOT NULL Partial Qty
1=Recvd
2=Recvd/Warn
3=Open
4=Open/Warn
5=Open/Error
46 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
47 PCT_UNDER_QTY Signed Number(4,0) DECIMAL(3) NOT NULL Close PO Under Qty Pct Tol
48 STOCKLESS_FLG Character(1) VARCHAR2(1) NOT NULL Stockless Item
N=No
Y=Yes
49 INSPECT_SAMPLE_PER Number(6,2) DECIMAL(5,2) NOT NULL Inspect Sample Percent
50 SRC_METHOD Character(1) VARCHAR2(1) NOT NULL Sourcing Method
B=Basic
F=Flexible
H=Cumulative Split
S=Sched Split
51 LEAD_TIME_IMP Number(6,2) DECIMAL(5,2) NOT NULL Lead Time Factor %
52 PRICE_IMP Number(6,2) DECIMAL(5,2) NOT NULL Price Factor %
53 SHIPTO_PR_IMP Number(6,2) DECIMAL(5,2) NOT NULL Ship to Priority Factor %
54 VNDR_PR_IMP Number(6,2) DECIMAL(5,2) NOT NULL Vendor Priority Factor %
55 USE_CAT_SRC_CNTL Character(1) VARCHAR2(1) NOT NULL Use Category Sourcing Controls
56 UNIT_PRC_TOL_L Number(14,5) DECIMAL(13,5) NOT NULL Unit Price Tolerance - Under
57 PCT_UNIT_PRC_TOL_L Number(6,2) DECIMAL(5,2) NOT NULL % Unit Price Tolerance - Under
58 EXT_PRC_TOL_L Number(14,5) DECIMAL(13,5) NOT NULL Ext Price Tolerance - Under
59 PCT_EXT_PRC_TOL_L Number(6,2) DECIMAL(5,2) NOT NULL % Ext Price Tolerance - Under
60 PACKING_VOLUME Signed Number(17,4) DECIMAL(15,4) NOT NULL Packing Volume
61 PACKING_WEIGHT Signed Number(17,4) DECIMAL(15,4) NOT NULL Packing Weight
62 UNIT_MEASURE_VOL Character(3) VARCHAR2(3) NOT NULL Volume UOM
63 UNIT_MEASURE_WT Character(3) VARCHAR2(3) NOT NULL Weight UOM
64 SHIP_LATE_DAYS Number(4,0) SMALLINT NOT NULL Days Allowed After Request Dt
65 SHIP_TYPE_ID Character(10) VARCHAR2(10) NOT NULL Ship Via Code
66 KB_PAST_DUE_PO Character(1) VARCHAR2(1) NOT NULL Flag to determine where to include Past Due Purchase Orders for Kanban Receiving
67 VAT_SVC_PERFRM_FLG Character(1) VARCHAR2(1) NOT NULL Where VAT Services Physically Performed Flag
1=Ship To Location
2=Ship From Location
3=Buyer's Location
4=Supplier's Location
68 ULTIMATE_USE_CD Character(8) VARCHAR2(8) NOT NULL Ultimate Use Code