SETIDPrompt Table: SP_SETID_NONVW
INV_ITEM_IDEFFDTDefault Value: %date
1=Open
2=Restricted
3=Hold
4=Rejected
INV_ITM_CVW(SQL View) |
Index Back |
|---|---|
Item Master Effective DatedItem Master Effective Dated |
| SELECT A.SETID , A.INV_ITEM_ID , A.EFFDT , A.UPC_ID , A.POTENCY_RATING , A.INV_ITEM_TEMPLATE , A.INV_ITEM_TYPE , A.RECYCLE_FLAG , A.REUSABLE_FLAG , A.DISPOSABLE_FLAG , A.INV_STOCK_TYPE , A.PACKING_CD , A.STOR_RULES_ID , A.SHIP_TYPE_ID , A.RECOM_STOR_TEMP , A.RECOM_HUMIDITY_PCT , A.INV_PROD_GRADE , A.MAX_CAPACITY , A.HAZ_CLASS_CD , A.INTL_HAZARD_ID , A.CHARGE_CODE , A.SHELF_LIFE , A.AVAIL_STATUS , A.INV_ITEM_HEIGHT , A.INV_ITEM_LENGTH , A.INV_ITEM_WIDTH , A.INV_ITEM_WEIGHT , A.INV_ITEM_VOLUME , A.INV_ITEM_SIZE , A.INV_ITEM_COLOR , A.UNIT_MEASURE_DIM , A.UNIT_MEASURE_WT , A.UNIT_MEASURE_TEMP , A.UNIT_MEASURE_VOL , A.COMMODITY_CD , A.HARMONIZED_CD , A.MSDS_ID , A.LAST_MAINT_OPRID , A.LAST_DTTM_UPDATE , A.DESCR254 , A.COMMODITY_CD_EU , A.AVAIL_LEAD_TIME , A.RETEST_LEAD_TIME , A.CHARGE_MARKUP_PCNT , A.CHARGE_MARKUP_AMT FROM PS_INV_ITEMS A |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Prompt Table: SP_SETID_NONVW |
| 2 | INV_ITEM_ID |
Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 3 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 4 | UPC_ID | Character(18) | VARCHAR2(18) NOT NULL | Uniform Product Code ID |
| 5 | POTENCY_RATING | Character(4) | VARCHAR2(4) NOT NULL | Potency Code |
| 6 | INV_ITEM_TEMPLATE | Character(5) | VARCHAR2(5) NOT NULL | Template ID |
| 7 | INV_ITEM_TYPE | Character(5) | VARCHAR2(5) NOT NULL | Item Type |
| 8 | RECYCLE_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Item Recycle Flag |
| 9 | REUSABLE_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Reusable Item Flag |
| 10 | DISPOSABLE_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Special Disposable Flag |
| 11 | INV_STOCK_TYPE | Character(4) | VARCHAR2(4) NOT NULL | Stock Type |
| 12 | PACKING_CD | Character(4) | VARCHAR2(4) NOT NULL | Packing Code |
| 13 | STOR_RULES_ID | Character(4) | VARCHAR2(4) NOT NULL | Storage Rule ID |
| 14 | SHIP_TYPE_ID | Character(10) | VARCHAR2(10) NOT NULL | Ship Via Code |
| 15 | RECOM_HUMIDITY_PCT | Signed Number(7,2) | DECIMAL(5,2) NOT NULL | Storage Humidity |
| 16 | RECOM_STOR_TEMP | Signed Number(7,2) | DECIMAL(5,2) NOT NULL | Storage Temp |
| 17 | INV_PROD_GRADE | Character(4) | VARCHAR2(4) NOT NULL | Grade |
| 18 | MAX_CAPACITY | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Max Capacity |
| 19 | HAZ_CLASS_CD | Character(4) | VARCHAR2(4) NOT NULL | Hazard Code |
| 20 | INTL_HAZARD_ID | Character(15) | VARCHAR2(15) NOT NULL | Intl Hazard ID |
| 21 | CHARGE_CODE | Character(20) | VARCHAR2(20) NOT NULL | Charge Code |
| 22 | SHELF_LIFE | Number(4,0) | SMALLINT NOT NULL | Shelf Life (Days) |
| 23 | AVAIL_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Availability Status
1=Open 2=Restricted 3=Hold 4=Rejected |
| 24 | INV_ITEM_HEIGHT | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Item Height |
| 25 | INV_ITEM_LENGTH | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Item Length |
| 26 | INV_ITEM_WIDTH | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Item Width |
| 27 | INV_ITEM_WEIGHT | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Item Weight |
| 28 | INV_ITEM_VOLUME | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Volume |
| 29 | INV_ITEM_SIZE | Character(5) | VARCHAR2(5) NOT NULL | Item Size |
| 30 | INV_ITEM_COLOR | Character(10) | VARCHAR2(10) NOT NULL | Item Color |
| 31 | UNIT_MEASURE_DIM | Character(3) | VARCHAR2(3) NOT NULL | Dimension UOM |
| 32 | UNIT_MEASURE_WT | Character(3) | VARCHAR2(3) NOT NULL | Weight UOM |
| 33 | UNIT_MEASURE_TEMP | Character(3) | VARCHAR2(3) NOT NULL | Temperature UOM |
| 34 | UNIT_MEASURE_VOL | Character(3) | VARCHAR2(3) NOT NULL | Volume UOM |
| 35 | COMMODITY_CD | Character(10) | VARCHAR2(10) NOT NULL | Commodity Code |
| 36 | HARMONIZED_CD | Character(14) | VARCHAR2(14) NOT NULL | Harmonized Code |
| 37 | MSDS_ID | Character(10) | VARCHAR2(10) NOT NULL | MSDS ID |
| 38 | LAST_MAINT_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Last Maintained By Operator ID |
| 39 | LAST_DTTM_UPDATE | DateTime(26) | TIMESTAMP | Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts. |
| 40 | DESCR254 | Character(254) | VARCHAR2(254) NOT NULL | Description of length 254 |
| 41 | COMMODITY_CD_EU | Character(10) | VARCHAR2(10) NOT NULL | EU Commodity Code |
| 42 | AVAIL_LEAD_TIME | Number(4,0) | SMALLINT NOT NULL | Availability Lead Time (Days) |
| 43 | RETEST_LEAD_TIME | Number(4,0) | SMALLINT NOT NULL | Retest Lead Time (Days) |
| 44 | CHARGE_MARKUP_PCNT | Signed Number(16,2) | DECIMAL(14,2) NOT NULL | Charge Markup % |
| 45 | CHARGE_MARKUP_AMT | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Charge Markup Amt |