POITMCAT_TEO3(SQL Table) |
Index Back |
|---|---|
CCU TEO temp tableCCU temporary table for ITM_CAT_TBL |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EO_PROCESS_INST | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 3 | CATEGORY_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
Category Type
PSF=User Def UNS=UN/SPSC |
| 4 | CATEGORY_CD | Character(18) | VARCHAR2(18) NOT NULL | Category Code |
| 5 | CATEGORY_ID | Character(5) | VARCHAR2(5) NOT NULL | Category ID |
| 6 | EFFDT | Date(10) | DATE | Effective Date |
| 7 | DESCR60 | Character(60) | VARCHAR2(60) NOT NULL | Description |
| 8 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |
| 9 | PROFILE_ID | Character(10) | VARCHAR2(10) NOT NULL | Asset Profile ID |
| 10 | NBR_OF_ITMS | Number(5,0) | INTEGER NOT NULL | Number of Items |
| 11 | LEAD_TIME | Number(3,0) | SMALLINT NOT NULL | Lead Time Days |
| 12 | INSPECT_CD | Character(1) | VARCHAR2(1) NOT NULL |
Inspection Required
N=No Y=Yes |
| 13 | INSPECT_UOM_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Inspection UOM
S=Standard V=Supplier |
| 14 | ROUTING_ID | Character(10) | VARCHAR2(10) NOT NULL | Inspection Routing ID |
| 15 | REJECT_DAYS | Number(3,0) | SMALLINT NOT NULL | Early Ship Rjct Days |
| 16 | ACCOUNT | Character(10) | VARCHAR2(10) NOT NULL | Account |
| 17 | ALTACCT | Character(10) | VARCHAR2(10) NOT NULL | Alternate Account |
| 18 | UNIT_PRC_TOL | Number(14,5) | DECIMAL(13,5) NOT NULL | Unit Price Tolerance |
| 19 | PCT_UNIT_PRC_TOL | Number(6,2) | DECIMAL(5,2) NOT NULL | % Unit Price Tolerance |
| 20 | RECV_REQ | Character(1) | VARCHAR2(1) NOT NULL |
Receiving Required
N=Optional X=Do Not Y=Required |
| 21 | EXT_PRC_TOL | Number(14,5) | DECIMAL(13,5) NOT NULL | Ext Price Tolerance |
| 22 | PCT_EXT_PRC_TOL | Number(6,2) | DECIMAL(5,2) NOT NULL | % Ext Price Tolerance |
| 23 | QTY_RECV_TOL_PCT | Number(6,2) | DECIMAL(5,2) NOT NULL | Qty Rcvd Tolerance % |
| 24 | RJCT_OVER_TOL_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Reject Qty Over Tolerance |
| 25 | PRIMARY_BUYER | Character(30) | VARCHAR2(30) NOT NULL | Primary Buyer |
| 26 | RECV_PARTIAL_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Partial Qty
1=Recvd 2=Recvd/Warn 3=Open 4=Open/Warn 5=Open/Error |
| 27 | COMMENTS_LONG | Long Character | CLOB | Comment Text |
| 28 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 29 | PCT_UNDER_QTY | Signed Number(4,0) | DECIMAL(3) NOT NULL | Close PO Under Qty Pct Tol |
| 30 | SRC_METHOD | Character(1) | VARCHAR2(1) NOT NULL |
Sourcing Method
B=Basic F=Flexible H=Cumulative Split S=Sched Split |
| 31 | LEAD_TIME_IMP | Number(6,2) | DECIMAL(5,2) NOT NULL | Lead Time Factor % |
| 32 | PRICE_IMP | Number(6,2) | DECIMAL(5,2) NOT NULL | Price Factor % |
| 33 | SHIPTO_PR_IMP | Number(6,2) | DECIMAL(5,2) NOT NULL | Ship to Priority Factor % |
| 34 | VNDR_PR_IMP | Number(6,2) | DECIMAL(5,2) NOT NULL | Vendor Priority Factor % |
| 35 | HIST_END_DT | Date(10) | DATE | End Date |
| 36 | HIST_NBR_MTHS | Number(3,0) | SMALLINT NOT NULL | Number of Months |
| 37 | HIST_START_DT | Date(10) | DATE | Historical Start Date |
| 38 | MERCH_AMT_CAT_TOT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Total Category Amount |
| 39 | HIST_START_MTH | Number(2,0) | SMALLINT NOT NULL | Month to Start |
| 40 | UNIT_PRC_TOL_L | Number(14,5) | DECIMAL(13,5) NOT NULL | Unit Price Tolerance - Under |
| 41 | PCT_UNIT_PRC_TOL_L | Number(6,2) | DECIMAL(5,2) NOT NULL | % Unit Price Tolerance - Under |
| 42 | EXT_PRC_TOL_L | Number(14,5) | DECIMAL(13,5) NOT NULL | Ext Price Tolerance - Under |
| 43 | PCT_EXT_PRC_TOL_L | Number(6,2) | DECIMAL(5,2) NOT NULL | % Ext Price Tolerance - Under |
| 44 | SHIP_LATE_DAYS | Number(4,0) | SMALLINT NOT NULL | Days Allowed After Request Dt |
| 45 | CUM_SRC_RUN_LEVEL | Character(1) | VARCHAR2(1) NOT NULL |
Accumulate Level
R=Run Level S=Schedule Level |
| 46 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive |
| 47 | 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 |
| 48 | PHYSICAL_NATURE | Character(1) | VARCHAR2(1) NOT NULL |
Physical Nature
G=Goods S=Services Default Value: G |
| 49 | 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 |
| 50 | ULTIMATE_USE_CD | Character(8) | VARCHAR2(8) NOT NULL | Ultimate Use Code |
| 51 | WF_PRC_TOL_OVR | Number(14,5) | DECIMAL(13,5) NOT NULL | Over Workflow Price Tolerance |
| 52 | WF_PRC_TOL_UND | Number(14,5) | DECIMAL(13,5) NOT NULL | Under Workflow Price Tolerance |
| 53 | WF_PCT_PRC_TOL_OVR | Number(6,2) | DECIMAL(5,2) NOT NULL | Over Wkflow % Price Tolerance |
| 54 | WF_PCT_PRC_TOL_UND | Number(6,2) | DECIMAL(5,2) NOT NULL | Under Wkflow % Price Tolerance |
| 55 | RFQ_REQ_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
RFQ Required
Y/N Table Edit Default Value: N |
| 56 | EO_FROM_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |