PUR_ITEM_BU_VW (SQL View)	Index Back
Purchasing Item Attributes

PUR_ITEM_BU_VW

(SQL View)

Purchasing Item Attributes

SELECT A.SETID , A.INV_ITEM_ID , A.BUSINESS_UNIT , A.ACCOUNT , A.ALTACCT , A.DEPTID , %subrec(CF14_AN_SBR, A) , A.PROJECT_ID , 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.ACCEPT_ALL_VENDOR , A.ACCEPT_ALL_SHIPTO , A.CONTRACT_REQ , A.RECV_PARTIAL_FLG , A.CURRENCY_CD , A.PCT_UNDER_QTY , A.STOCKLESS_FLG , A.INSPECT_SAMPLE_PER , A.VAT_SVC_PERFRM_FLG , A.LAST_PO_PRICE_PAID , %subrec(PRC_TOL_L_SBR, A) , 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.KB_OVR_RECV_TOL , A.ULTIMATE_USE_CD , A.BU_UPD_PRICE , %subrec(LAST_UPDATE_SBR, A) FROM PS_PURCH_ITEM_BU 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 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Prompt Table: SP_BU_PM5_NONVW

4 ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account
Prompt Table: PO_ACCOUNT_VW

5 ALTACCT Character(10) VARCHAR2(10) NOT NULL Alternate Account

6 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
Prompt Table: DEPT_TBL

7 OPERATING_UNIT Character(8) VARCHAR2(8) NOT NULL Operating Unit ChartField
Prompt Table: OPER_UNIT_TBL

8 PRODUCT Character(6) VARCHAR2(6) NOT NULL Product ChartField
Prompt Table: PRODUCT_TBL

9 FUND_CODE Character(5) VARCHAR2(5) NOT NULL Fund Code
Prompt Table: FUND_TBL

10 CLASS_FLD Character(5) VARCHAR2(5) NOT NULL Class Field
Prompt Table: CLASS_CF_TBL

11 PROGRAM_CODE Character(5) VARCHAR2(5) NOT NULL Program Code ChartField
Prompt Table: PROGRAM_TBL

12 BUDGET_REF Character(8) VARCHAR2(8) NOT NULL Budget Reference
Prompt Table: BUD_REF_TBL

13 AFFILIATE Character(5) VARCHAR2(5) NOT NULL Affiliate
Prompt Table: AFFILIATE_VW

14 AFFILIATE_INTRA1 Character(10) VARCHAR2(10) NOT NULL IntraUnit Affiliate1
Prompt Table: %EDIT_INTRA01

15 AFFILIATE_INTRA2 Character(10) VARCHAR2(10) NOT NULL Operating Unit Affiliate
Prompt Table: %EDIT_INTRA02

16 CHARTFIELD1 Character(10) VARCHAR2(10) NOT NULL Expansion chartfield 1
Prompt Table: CHARTFIELD1_TBL

17 CHARTFIELD2 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 2
Prompt Table: CHARTFIELD2_TBL

18 CHARTFIELD3 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 3
Prompt Table: CHARTFIELD3_TBL

19 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField

20 PRICE_LIST Number(16,5) DECIMAL(15,5) NOT NULL Standard Price

21 TAXABLE_CD Character(1) VARCHAR2(1) NOT NULL Taxable or Non-Taxable
Y/N Table Edit

22 AUTO_SOURCE Character(1) VARCHAR2(1) NOT NULL Auto Select
Y/N Table Edit

23 STD_LEAD Number(3,0) SMALLINT NOT NULL Purchase Lead Time Days

24 UNIT_PRC_TOL Number(14,5) DECIMAL(13,5) NOT NULL Unit Price Tolerance

25 EXT_PRC_TOL Number(14,5) DECIMAL(13,5) NOT NULL Ext Price Tolerance

26 PCT_UNIT_PRC_TOL Number(6,2) DECIMAL(5,2) NOT NULL % Unit Price Tolerance

27 PCT_EXT_PRC_TOL Number(6,2) DECIMAL(5,2) NOT NULL % Ext Price Tolerance

28 INSPECT_CD Character(1) VARCHAR2(1) NOT NULL Inspection Required
N=No
Y=Yes
Y/N Table Edit

29 INSPECT_UOM_TYPE Character(1) VARCHAR2(1) NOT NULL Inspection UOM
S=Standard
V=Supplier

30 ROUTING_ID Character(10) VARCHAR2(10) NOT NULL Inspection Routing ID
Prompt Table: ROUTING_HDR

31 RECV_REQ Character(1) VARCHAR2(1) NOT NULL Receiving Required
N=Optional
X=Do Not
Y=Required

32 QTY_RECV_TOL_PCT Number(6,2) DECIMAL(5,2) NOT NULL Qty Rcvd Tolerance %

33 RJCT_OVER_TOL_FLAG Character(1) VARCHAR2(1) NOT NULL Reject Qty Over Tolerance
Y/N Table Edit

34 RFQ_REQ_FLAG Character(1) VARCHAR2(1) NOT NULL RFQ Required
Y/N Table Edit

35 REJECT_DAYS Number(3,0) SMALLINT NOT NULL Early Ship Rjct Days

36 PRIMARY_BUYER Character(30) VARCHAR2(30) NOT NULL Primary Buyer
Prompt Table: BUYER_ACTIVE_VW

37 ACCEPT_ALL_VENDOR Character(1) VARCHAR2(1) NOT NULL Accept Any Vendor
Y/N Table Edit

38 ACCEPT_ALL_SHIPTO Character(1) VARCHAR2(1) NOT NULL Accept Any Ship To
Y/N Table Edit

39 CONTRACT_REQ Character(1) VARCHAR2(1) NOT NULL Contract Required
Y/N Table Edit

40 RECV_PARTIAL_FLG Character(1) VARCHAR2(1) NOT NULL Partial Qty
1=Recvd
2=Recvd/Warn
3=Open
4=Open/Warn
5=Open/Error

41 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
Prompt Table: CURRENCY_CD_TBL

42 PCT_UNDER_QTY Signed Number(4,0) DECIMAL(3) NOT NULL Close PO Under Qty Pct Tol

43 STOCKLESS_FLG Character(1) VARCHAR2(1) NOT NULL Stockless Item
N=No
Y=Yes

44 INSPECT_SAMPLE_PER Number(6,2) DECIMAL(5,2) NOT NULL Inspect Sample Percent

45 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

46 LAST_PO_PRICE_PAID Number(16,5) DECIMAL(15,5) NOT NULL Last PO Price Paid

47 UNIT_PRC_TOL_L Number(14,5) DECIMAL(13,5) NOT NULL Unit Price Tolerance - Under

48 PCT_UNIT_PRC_TOL_L Number(6,2) DECIMAL(5,2) NOT NULL % Unit Price Tolerance - Under

49 EXT_PRC_TOL_L Number(14,5) DECIMAL(13,5) NOT NULL Ext Price Tolerance - Under

50 PCT_EXT_PRC_TOL_L Number(6,2) DECIMAL(5,2) NOT NULL % Ext Price Tolerance - Under

51 PACKING_VOLUME Signed Number(17,4) DECIMAL(15,4) NOT NULL Packing Volume

52 PACKING_WEIGHT Signed Number(17,4) DECIMAL(15,4) NOT NULL Packing Weight

53 UNIT_MEASURE_VOL Character(3) VARCHAR2(3) NOT NULL Volume UOM

54 UNIT_MEASURE_WT Character(3) VARCHAR2(3) NOT NULL Weight UOM

55 SHIP_LATE_DAYS Number(4,0) SMALLINT NOT NULL Days Allowed After Request Dt

56 SHIP_TYPE_ID Character(10) VARCHAR2(10) NOT NULL Ship Via Code

57 KB_PAST_DUE_PO Character(1) VARCHAR2(1) NOT NULL Flag to determine where to include Past Due Purchase Orders for Kanban Receiving

58 KB_OVR_RECV_TOL Number(6,2) DECIMAL(5,2) NOT NULL Kanban Recv Cascade %

59 ULTIMATE_USE_CD Character(8) VARCHAR2(8) NOT NULL Ultimate Use Code
Prompt Table: SUT_USE_CD

60 BU_UPD_PRICE Character(1) VARCHAR2(1) NOT NULL Business Unit Update Price
Default Value: N

61 OPRID_MODIFIED_BY Character(30) VARCHAR2(30) NOT NULL Last User to Modify Entered By 07/25/2011:Ensured that OPRID_MODIFIED_BY is set with format type of MixedCase.

62 LAST_DTTM_UPDATE DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

#	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	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: SP_BU_PM5_NONVW
4	ACCOUNT	Character(10)	VARCHAR2(10) NOT NULL	Account Prompt Table: PO_ACCOUNT_VW
5	ALTACCT	Character(10)	VARCHAR2(10) NOT NULL	Alternate Account
6	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department Prompt Table: DEPT_TBL
7	OPERATING_UNIT	Character(8)	VARCHAR2(8) NOT NULL	Operating Unit ChartField Prompt Table: OPER_UNIT_TBL
8	PRODUCT	Character(6)	VARCHAR2(6) NOT NULL	Product ChartField Prompt Table: PRODUCT_TBL
9	FUND_CODE	Character(5)	VARCHAR2(5) NOT NULL	Fund Code Prompt Table: FUND_TBL
10	CLASS_FLD	Character(5)	VARCHAR2(5) NOT NULL	Class Field Prompt Table: CLASS_CF_TBL
11	PROGRAM_CODE	Character(5)	VARCHAR2(5) NOT NULL	Program Code ChartField Prompt Table: PROGRAM_TBL
12	BUDGET_REF	Character(8)	VARCHAR2(8) NOT NULL	Budget Reference Prompt Table: BUD_REF_TBL
13	AFFILIATE	Character(5)	VARCHAR2(5) NOT NULL	Affiliate Prompt Table: AFFILIATE_VW
14	AFFILIATE_INTRA1	Character(10)	VARCHAR2(10) NOT NULL	IntraUnit Affiliate1 Prompt Table: %EDIT_INTRA01
15	AFFILIATE_INTRA2	Character(10)	VARCHAR2(10) NOT NULL	Operating Unit Affiliate Prompt Table: %EDIT_INTRA02
16	CHARTFIELD1	Character(10)	VARCHAR2(10) NOT NULL	Expansion chartfield 1 Prompt Table: CHARTFIELD1_TBL
17	CHARTFIELD2	Character(10)	VARCHAR2(10) NOT NULL	Expansion Chartfield 2 Prompt Table: CHARTFIELD2_TBL
18	CHARTFIELD3	Character(10)	VARCHAR2(10) NOT NULL	Expansion Chartfield 3 Prompt Table: CHARTFIELD3_TBL
19	PROJECT_ID	Character(15)	VARCHAR2(15) NOT NULL	Project Id ChartField
20	PRICE_LIST	Number(16,5)	DECIMAL(15,5) NOT NULL	Standard Price
21	TAXABLE_CD	Character(1)	VARCHAR2(1) NOT NULL	Taxable or Non-Taxable Y/N Table Edit
22	AUTO_SOURCE	Character(1)	VARCHAR2(1) NOT NULL	Auto Select Y/N Table Edit
23	STD_LEAD	Number(3,0)	SMALLINT NOT NULL	Purchase Lead Time Days
24	UNIT_PRC_TOL	Number(14,5)	DECIMAL(13,5) NOT NULL	Unit Price Tolerance
25	EXT_PRC_TOL	Number(14,5)	DECIMAL(13,5) NOT NULL	Ext Price Tolerance
26	PCT_UNIT_PRC_TOL	Number(6,2)	DECIMAL(5,2) NOT NULL	% Unit Price Tolerance
27	PCT_EXT_PRC_TOL	Number(6,2)	DECIMAL(5,2) NOT NULL	% Ext Price Tolerance
28	INSPECT_CD	Character(1)	VARCHAR2(1) NOT NULL	Inspection Required N=No Y=Yes Y/N Table Edit
29	INSPECT_UOM_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Inspection UOM S=Standard V=Supplier
30	ROUTING_ID	Character(10)	VARCHAR2(10) NOT NULL	Inspection Routing ID Prompt Table: ROUTING_HDR
31	RECV_REQ	Character(1)	VARCHAR2(1) NOT NULL	Receiving Required N=Optional X=Do Not Y=Required
32	QTY_RECV_TOL_PCT	Number(6,2)	DECIMAL(5,2) NOT NULL	Qty Rcvd Tolerance %
33	RJCT_OVER_TOL_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Reject Qty Over Tolerance Y/N Table Edit
34	RFQ_REQ_FLAG	Character(1)	VARCHAR2(1) NOT NULL	RFQ Required Y/N Table Edit
35	REJECT_DAYS	Number(3,0)	SMALLINT NOT NULL	Early Ship Rjct Days
36	PRIMARY_BUYER	Character(30)	VARCHAR2(30) NOT NULL	Primary Buyer Prompt Table: BUYER_ACTIVE_VW
37	ACCEPT_ALL_VENDOR	Character(1)	VARCHAR2(1) NOT NULL	Accept Any Vendor Y/N Table Edit
38	ACCEPT_ALL_SHIPTO	Character(1)	VARCHAR2(1) NOT NULL	Accept Any Ship To Y/N Table Edit
39	CONTRACT_REQ	Character(1)	VARCHAR2(1) NOT NULL	Contract Required Y/N Table Edit
40	RECV_PARTIAL_FLG	Character(1)	VARCHAR2(1) NOT NULL	Partial Qty 1=Recvd 2=Recvd/Warn 3=Open 4=Open/Warn 5=Open/Error
41	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Prompt Table: CURRENCY_CD_TBL
42	PCT_UNDER_QTY	Signed Number(4,0)	DECIMAL(3) NOT NULL	Close PO Under Qty Pct Tol
43	STOCKLESS_FLG	Character(1)	VARCHAR2(1) NOT NULL	Stockless Item N=No Y=Yes
44	INSPECT_SAMPLE_PER	Number(6,2)	DECIMAL(5,2) NOT NULL	Inspect Sample Percent
45	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
46	LAST_PO_PRICE_PAID	Number(16,5)	DECIMAL(15,5) NOT NULL	Last PO Price Paid
47	UNIT_PRC_TOL_L	Number(14,5)	DECIMAL(13,5) NOT NULL	Unit Price Tolerance - Under
48	PCT_UNIT_PRC_TOL_L	Number(6,2)	DECIMAL(5,2) NOT NULL	% Unit Price Tolerance - Under
49	EXT_PRC_TOL_L	Number(14,5)	DECIMAL(13,5) NOT NULL	Ext Price Tolerance - Under
50	PCT_EXT_PRC_TOL_L	Number(6,2)	DECIMAL(5,2) NOT NULL	% Ext Price Tolerance - Under
51	PACKING_VOLUME	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Packing Volume
52	PACKING_WEIGHT	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Packing Weight
53	UNIT_MEASURE_VOL	Character(3)	VARCHAR2(3) NOT NULL	Volume UOM
54	UNIT_MEASURE_WT	Character(3)	VARCHAR2(3) NOT NULL	Weight UOM
55	SHIP_LATE_DAYS	Number(4,0)	SMALLINT NOT NULL	Days Allowed After Request Dt
56	SHIP_TYPE_ID	Character(10)	VARCHAR2(10) NOT NULL	Ship Via Code
57	KB_PAST_DUE_PO	Character(1)	VARCHAR2(1) NOT NULL	Flag to determine where to include Past Due Purchase Orders for Kanban Receiving
58	KB_OVR_RECV_TOL	Number(6,2)	DECIMAL(5,2) NOT NULL	Kanban Recv Cascade %
59	ULTIMATE_USE_CD	Character(8)	VARCHAR2(8) NOT NULL	Ultimate Use Code Prompt Table: SUT_USE_CD
60	BU_UPD_PRICE	Character(1)	VARCHAR2(1) NOT NULL	Business Unit Update Price Default Value: N
61	OPRID_MODIFIED_BY	Character(30)	VARCHAR2(30) NOT NULL	Last User to Modify Entered By 07/25/2011:Ensured that OPRID_MODIFIED_BY is set with format type of MixedCase.
62	LAST_DTTM_UPDATE	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.