ITEM_CAT_TBL_VW

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW
2	CATEGORY_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Category Type PSF=User Def UNS=UN/SPSC Default Value: INSTALLATION_PO.CATEGORY_TYPE
3	CATEGORY_CD	Character(18)	VARCHAR2(18) NOT NULL	Category Code
4	CATEGORY_ID	Character(5)	VARCHAR2(5) NOT NULL	Category ID
5	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
6	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
7	DESCRSHORT	Character(10)	VARCHAR2(10) NOT NULL	Short Description
8	PROFILE_ID	Character(10)	VARCHAR2(10) NOT NULL	Asset Profile ID Prompt Table: %EDIT_PROFILE
9	NBR_OF_ITMS	Number(5,0)	INTEGER NOT NULL	Number of Items
10	LEAD_TIME	Number(3,0)	SMALLINT NOT NULL	Lead Time Days
11	INSPECT_CD	Character(1)	VARCHAR2(1) NOT NULL	Inspection Required N=No Y=Yes Y/N Table Edit Default Value: N
12	INSPECT_UOM_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Inspection UOM S=Standard V=Supplier Default Value: S
13	ROUTING_ID	Character(10)	VARCHAR2(10) NOT NULL	Inspection Routing ID Prompt Table: %EDITTABLE
14	REJECT_DAYS	Number(3,0)	SMALLINT NOT NULL	Early Ship Rjct Days
15	ACCOUNT	Character(10)	VARCHAR2(10) NOT NULL	Account Prompt Table: %EDIT_ACCOUNT
16	ALTACCT	Character(10)	VARCHAR2(10) NOT NULL	Alternate Account Prompt Table: ALTACCT_XREF
17	UNIT_PRC_TOL	Number(14,5)	DECIMAL(13,5) NOT NULL	Unit Price Tolerance Default Value: 0
18	PCT_UNIT_PRC_TOL	Number(6,2)	DECIMAL(5,2) NOT NULL	% Unit Price Tolerance Default Value: 0
19	RECV_REQ	Character(1)	VARCHAR2(1) NOT NULL	Receiving Required N=Optional X=Do Not Y=Required Default Value: Y
20	EXT_PRC_TOL	Number(14,5)	DECIMAL(13,5) NOT NULL	Ext Price Tolerance Default Value: 0
21	PCT_EXT_PRC_TOL	Number(6,2)	DECIMAL(5,2) NOT NULL	% Ext Price Tolerance Default Value: 0
22	QTY_RECV_TOL_PCT	Number(6,2)	DECIMAL(5,2) NOT NULL	Qty Rcvd Tolerance % Default Value: 0
23	RJCT_OVER_TOL_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Reject Qty Over Tolerance Y/N Table Edit Default Value: N
24	PRIMARY_BUYER	Character(30)	VARCHAR2(30) NOT NULL	Primary Buyer Prompt Table: %EDIT_BUYER
25	RECV_PARTIAL_FLG	Character(1)	VARCHAR2(1) NOT NULL	Partial Qty 1=Recvd 2=Recvd/Warn 3=Open 4=Open/Warn 5=Open/Error Default Value: 1
26	COMMENTS_LONG	Long Character	CLOB	Comment Text
27	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Prompt Table: CURRENCY_CD_TBL
28	PCT_UNDER_QTY	Signed Number(4,0)	DECIMAL(3) NOT NULL	Close PO Under Qty Pct Tol
29	SRC_METHOD	Character(1)	VARCHAR2(1) NOT NULL	Sourcing Method B=Basic F=Flexible H=Cumulative Split S=Sched Split Default Value: B
30	LEAD_TIME_IMP	Number(6,2)	DECIMAL(5,2) NOT NULL	Lead Time Factor %
31	PRICE_IMP	Number(6,2)	DECIMAL(5,2) NOT NULL	Price Factor %
32	SHIPTO_PR_IMP	Number(6,2)	DECIMAL(5,2) NOT NULL	Ship to Priority Factor %
33	VNDR_PR_IMP	Number(6,2)	DECIMAL(5,2) NOT NULL	Vendor Priority Factor %
34	HIST_END_DT	Date(10)	DATE	End Date
35	HIST_NBR_MTHS	Number(3,0)	SMALLINT NOT NULL	Number of Months
36	HIST_START_DT	Date(10)	DATE	Historical Start Date
37	MERCH_AMT_CAT_TOT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Total Category Amount
38	HIST_START_MTH	Number(2,0)	SMALLINT NOT NULL	Month to Start
39	UNIT_PRC_TOL_L	Number(14,5)	DECIMAL(13,5) NOT NULL	Unit Price Tolerance - Under
40	PCT_UNIT_PRC_TOL_L	Number(6,2)	DECIMAL(5,2) NOT NULL	% Unit Price Tolerance - Under
41	EXT_PRC_TOL_L	Number(14,5)	DECIMAL(13,5) NOT NULL	Ext Price Tolerance - Under
42	PCT_EXT_PRC_TOL_L	Number(6,2)	DECIMAL(5,2) NOT NULL	% Ext Price Tolerance - Under
43	SHIP_LATE_DAYS	Number(4,0)	SMALLINT NOT NULL	Days Allowed After Request Dt
44	CUM_SRC_RUN_LEVEL	Character(1)	VARCHAR2(1) NOT NULL	Accumulate Level R=Run Level S=Schedule Level
45	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive Default Value: A
46	MARKETCODE	Character(2)	VARCHAR2(2) NOT NULL	This field is added to help the following data entry programs to determine how to handle different coding schemes for CATEGORY_CD: - Item Categories (Component) - PV_CP_LOAD (App. Engine) - IN_ITMLOAD (App. Engine) Since release 8, CATEGORY_TYPE was added to allow multiple coding schemes for CATEGORY_CD. The limitation imposed upon by how it was implemented is that although multiple coding schemes can be maintained separately but only one coding schemes can be used based on INSTALLATION_PO.CATEGORY_TYPE. 01=User Defined 02=UN/SPSC Default Value: 01
47	PHYSICAL_NATURE	Character(1)	VARCHAR2(1) NOT NULL	Physical Nature G=Goods S=Services Default Value: G
48	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
49	ULTIMATE_USE_CD	Character(8)	VARCHAR2(8) NOT NULL	Ultimate Use Code Prompt Table: SUT_USE_CD
50	WF_PRC_TOL_OVR	Number(14,5)	DECIMAL(13,5) NOT NULL	Over Workflow Price Tolerance Default Value: 99999999
51	WF_PRC_TOL_UND	Number(14,5)	DECIMAL(13,5) NOT NULL	Under Workflow Price Tolerance Default Value: 99999999
52	WF_PCT_PRC_TOL_OVR	Number(6,2)	DECIMAL(5,2) NOT NULL	Over Wkflow % Price Tolerance Default Value: 999
53	WF_PCT_PRC_TOL_UND	Number(6,2)	DECIMAL(5,2) NOT NULL	Under Wkflow % Price Tolerance Default Value: 999
54	RFQ_REQ_FLAG	Character(1)	VARCHAR2(1) NOT NULL	RFQ Required Y/N Table Edit Default Value: N