ITEM_CAT_TBL_EC

(SQL Table)
Index Back

Category Codes

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 SETID Character(5) VARCHAR2(5) NOT NULL SetID

Default Value: OPR_DEF_TBL_FS.SETID

Prompt Table: SP_SETID_NONVW

3 CATEGORY_ID Character(5) VARCHAR2(5) NOT NULL Category ID
4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
5 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
6 PROFILE_ID Character(10) VARCHAR2(10) NOT NULL Asset Profile ID

Prompt Table: %EDIT_PROFILE

7 NBR_OF_ITMS Number(5,0) INTEGER NOT NULL Number of Items
8 LEAD_TIME Number(3,0) SMALLINT NOT NULL Lead Time Days
9 INSPECT_CD Character(1) VARCHAR2(1) NOT NULL Inspection Required
N=No
Y=Yes

Y/N Table Edit

Default Value: N

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

Default Value: S

11 ROUTING_ID Character(10) VARCHAR2(10) NOT NULL Inspection Routing ID

Prompt Table: %EDITTABLE

12 REJECT_DAYS Number(3,0) SMALLINT NOT NULL Early Ship Rjct Days
13 ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account

Prompt Table: %EDIT_ACCOUNT

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

Prompt Table: %EDIT_ALTACCT

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

Default Value: 0

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

Default Value: 0

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

Y/N Table Edit

Default Value: Y

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

Default Value: 0

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

Default Value: 0

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

Default Value: 0

21 RJCT_OVER_TOL_FLAG Character(1) VARCHAR2(1) NOT NULL Reject Qty Over Tolerance

Y/N Table Edit

Default Value: N

22 PRIMARY_BUYER Character(30) VARCHAR2(30) NOT NULL Primary Buyer

Prompt Table: %EDIT_BUYER

23 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

24 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

Prompt Table: CURRENCY_CD_TBL

25 PCT_UNDER_QTY Signed Number(4,0) DECIMAL(3) NOT NULL Close PO Under Qty Pct Tol
26 SRC_METHOD Character(1) VARCHAR2(1) NOT NULL Sourcing Method
B=Basic
F=Flexible
H=Cumulative Split
S=Sched Split

Default Value: B

Prompt Table: SRC_METHOD_VW1

27 LEAD_TIME_IMP Number(6,2) DECIMAL(5,2) NOT NULL Lead Time Factor %
28 PRICE_IMP Number(6,2) DECIMAL(5,2) NOT NULL Price Factor %
29 SHIPTO_PR_IMP Number(6,2) DECIMAL(5,2) NOT NULL Ship to Priority Factor %
30 VNDR_PR_IMP Number(6,2) DECIMAL(5,2) NOT NULL Vendor Priority Factor %
31 HIST_END_DT Date(10) DATE End Date
32 HIST_NBR_MTHS Number(3,0) SMALLINT NOT NULL Number of Months
33 HIST_START_DT Date(10) DATE Historical Start Date
34 HIST_START_MTH Number(2,0) SMALLINT NOT NULL Month to Start
35 MERCH_AMT_CAT_TOT Signed Number(28,3) DECIMAL(26,3) NOT NULL Total Category Amount
36 UNIT_PRC_TOL_L Number(14,5) DECIMAL(13,5) NOT NULL Unit Price Tolerance - Under
37 PCT_UNIT_PRC_TOL_L Number(6,2) DECIMAL(5,2) NOT NULL % Unit Price Tolerance - Under
38 EXT_PRC_TOL_L Number(14,5) DECIMAL(13,5) NOT NULL Ext Price Tolerance - Under
39 PCT_EXT_PRC_TOL_L Number(6,2) DECIMAL(5,2) NOT NULL % Ext Price Tolerance - Under
40 SHIP_LATE_DAYS Number(4,0) SMALLINT NOT NULL Days Allowed After Request Dt
41 CUM_SRC_RUN_LEVEL Character(1) VARCHAR2(1) NOT NULL Accumulate Level
R=Run Level
S=Schedule Level
42 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive

Default Value: A

43 CATALOG_ID Character(18) VARCHAR2(18) NOT NULL Catalog ID
44 PARENT_NODE Character(20) VARCHAR2(20) NOT NULL Parent Tree Node
45 ITEM_LOAD_STATUS Character(1) VARCHAR2(1) NOT NULL Next Action
D=Delete
H=On Hold
U=Update