PROCESS_INSTANCESETIDCATEGORY_CDCATEGORY_IDPrompt Table: PO_ACCT_SET_VW
01=User Defined
02=UN/SPSC
PV_CP_CAT_TMP(SQL Table) |
Index Back |
|---|
| # | 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 |
| 3 | CATEGORY_CD |
Character(18) | VARCHAR2(18) NOT NULL | Category Code |
| 4 | CATEGORY_ID |
Character(5) | VARCHAR2(5) NOT NULL | Category ID |
| 5 | DESCR60 | Character(60) | VARCHAR2(60) NOT NULL | Description |
| 6 | ACCOUNT | Character(10) | VARCHAR2(10) NOT NULL |
Account
Prompt Table: PO_ACCT_SET_VW |
| 7 | PV_CP_CREATE_DATE | Date(10) | DATE | CUP Create Date |
| 8 | PV_CP_LEAD_TIME | Number(11,0) | DECIMAL(11) NOT NULL | CUP Lead Time |
| 9 | PV_CP_SUPPLIER_ID | Number(3,0) | SMALLINT NOT NULL | CUP Supplier ID |
| 10 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 11 | PV_MS_SUP_MPID | Character(50) | VARCHAR2(50) NOT NULL | e |
| 12 | DESCR254_MIXED | Character(254) | VARCHAR2(254) NOT NULL | Description |
| 13 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |
| 14 | 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 |
| 15 | COMMENTS_LONG | Long Character | CLOB | Comment Text |