DP_DDH_ITEMM_VW(SQL View) |
Index Back |
|---|---|
Fetch Item data for DDHview to fetch basic INV ITEM data for transfer to demand history. Custom Item field are comming form MATER_ITEM_TBL. |
| SELECT IM.SETID , IB.BUSINESS_UNIT , IM.INV_ITEM_ID , IM.INV_ITEM_GROUP , IM.DESCR , IM.CATEGORY_ID , IM.INV_PROD_FAM_CD , II.INV_ITEM_TYPE , II.INV_ITEM_COLOR , II.UPC_ID , IM.ITEM_FIELD_C10_A , IM.ITEM_FIELD_C10_B , IM.ITEM_FIELD_C10_C , IM.ITEM_FIELD_C10_D , IM.ITEM_FIELD_C1_A , IM.ITEM_FIELD_C1_B , IM.ITEM_FIELD_C1_C , IM.ITEM_FIELD_C1_D , IM.ITEM_FIELD_C2 , IM.ITEM_FIELD_C30_A , IM.ITEM_FIELD_C30_B , IM.ITEM_FIELD_C30_C , IM.ITEM_FIELD_C30_D , IM.ITEM_FIELD_C4 , IM.ITEM_FIELD_C6 , IM.ITEM_FIELD_C8 , IM.ITEM_FIELD_N12_A , IM.ITEM_FIELD_N12_B , IM.ITEM_FIELD_N12_C , IM.ITEM_FIELD_N12_D , IM.ITEM_FIELD_N15_A , IM.ITEM_FIELD_N15_B , IM.ITEM_FIELD_N15_C , IM.ITEM_FIELD_N15_D , IB.FORECAST_ITEM_FLAG , ' ' , ' ' FROM PS_MASTER_ITEM_TBL IM , PS_INV_ITEMS II , PS_BU_ITEMS_INV IB WHERE IB.INV_ITEM_ID = IM.INV_ITEM_ID AND (II.SETID = IM.SETID AND II.INV_ITEM_ID = IM.INV_ITEM_ID) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 3 | INV_ITEM_ID | Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 4 | INV_ITEM_GROUP | Character(15) | VARCHAR2(15) NOT NULL | Item Group |
| 5 | MITBL_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 6 | CATEGORY_ID | Character(5) | VARCHAR2(5) NOT NULL | Category ID |
| 7 | INV_PROD_FAM_CD | Character(10) | VARCHAR2(10) NOT NULL | Family |
| 8 | INV_ITEM_TYPE | Character(5) | VARCHAR2(5) NOT NULL | Item Type |
| 9 | INV_ITEM_COLOR | Character(10) | VARCHAR2(10) NOT NULL | Item Color |
| 10 | UPC_ID | Character(18) | VARCHAR2(18) NOT NULL | Uniform Product Code ID |
| 11 | ITEM_FIELD_C10_A | Character(10) | VARCHAR2(10) NOT NULL | User-defined item field - Character 10 |
| 12 | ITEM_FIELD_C10_B | Character(10) | VARCHAR2(10) NOT NULL | User-defined item field - Character 10 |
| 13 | ITEM_FIELD_C10_C | Character(10) | VARCHAR2(10) NOT NULL | User-defined item field - Character 10 |
| 14 | ITEM_FIELD_C10_D | Character(10) | VARCHAR2(10) NOT NULL | User-defined item field - Character 10 |
| 15 | ITEM_FIELD_C1_A | Character(1) | VARCHAR2(1) NOT NULL | User-defined item field - Character 1 |
| 16 | ITEM_FIELD_C1_B | Character(1) | VARCHAR2(1) NOT NULL | User-defined item field - Character 1 |
| 17 | ITEM_FIELD_C1_C | Character(1) | VARCHAR2(1) NOT NULL | User-defined item field - Character 1 |
| 18 | ITEM_FIELD_C1_D | Character(1) | VARCHAR2(1) NOT NULL | User-defined item field - Character 1 |
| 19 | ITEM_FIELD_C2 | Character(2) | VARCHAR2(2) NOT NULL | User-defined item field - Character 2 |
| 20 | ITEM_FIELD_C30_A | Character(30) | VARCHAR2(30) NOT NULL | User-defined item field - Character 30 |
| 21 | ITEM_FIELD_C30_B | Character(30) | VARCHAR2(30) NOT NULL | User-defined item field - Character 30 |
| 22 | ITEM_FIELD_C30_C | Character(30) | VARCHAR2(30) NOT NULL | User-defined item field - Character 30 |
| 23 | ITEM_FIELD_C30_D | Character(30) | VARCHAR2(30) NOT NULL | User-defined item field - Character 30 |
| 24 | ITEM_FIELD_C4 | Character(4) | VARCHAR2(4) NOT NULL | User-defined item field - Character 4 |
| 25 | ITEM_FIELD_C6 | Character(6) | VARCHAR2(6) NOT NULL | User-defined item field - Character 6 |
| 26 | ITEM_FIELD_C8 | Character(8) | VARCHAR2(8) NOT NULL | User-defined item field - Character 8 |
| 27 | ITEM_FIELD_N12_A | Number(16,3) | DECIMAL(15,3) NOT NULL | User-defined item field - Unsigned Decimal 12.3 |
| 28 | ITEM_FIELD_N12_B | Number(16,3) | DECIMAL(15,3) NOT NULL | User-defined item field - Unsigned Decimal 12.3 |
| 29 | ITEM_FIELD_N12_C | Number(16,3) | DECIMAL(15,3) NOT NULL | User-defined item field - Unsigned Decimal 12.3 |
| 30 | ITEM_FIELD_N12_D | Number(16,3) | DECIMAL(15,3) NOT NULL | User-defined item field - Unsigned Decimal 12.3 |
| 31 | ITEM_FIELD_N15_A | Number(15,0) | DECIMAL(15) NOT NULL | User-defined item field - Unsigned Decimal 15.0 |
| 32 | ITEM_FIELD_N15_B | Number(15,0) | DECIMAL(15) NOT NULL | User-defined item field - Unsigned Decimal 15.0 |
| 33 | ITEM_FIELD_N15_C | Number(15,0) | DECIMAL(15) NOT NULL | User-defined item field - Unsigned Decimal 15.0 |
| 34 | ITEM_FIELD_N15_D | Number(15,0) | DECIMAL(15) NOT NULL | User-defined item field - Unsigned Decimal 15.0 |
| 35 | FORECAST_ITEM_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Demand Planning Item |
| 36 | UTILIZ_CD | Character(4) | VARCHAR2(4) NOT NULL |
Utilization Type
Prompt Table: DP_UTILIZ_CD_VW |
| 37 | UTILIZ_GROUP | Character(4) | VARCHAR2(4) NOT NULL |
Utilization Group
CYCL=Cycle Count Prompt Table: DP_UTILIZ_GP_VW |