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 |