ORDENT_INVITMVW(SQL View) |
Index Back |
|---|---|
Inventory Item Master - OM |
| SELECT S.SETID , S.INV_ITEM_ID , S.EFFDT , 'A' , S.UPC_ID , S.POTENCY_RATING , S.INV_ITEM_TEMPLATE , S.INV_ITEM_TYPE , S.RECYCLE_FLAG , S.REUSABLE_FLAG , S.DISPOSABLE_FLAG , S.INV_STOCK_TYPE , S.PACKING_CD , S.STOR_RULES_ID , S.SHIP_TYPE_ID , S.RECOM_STOR_TEMP , S.RECOM_HUMIDITY_PCT , S.INV_PROD_GRADE , S.MAX_CAPACITY , S.HAZ_CLASS_CD , S.INTL_HAZARD_ID , S.CHARGE_CODE , S.SHELF_LIFE , S.AVAIL_STATUS , S.INV_ITEM_HEIGHT , S.INV_ITEM_LENGTH , S.INV_ITEM_WIDTH , S.INV_ITEM_WEIGHT , S.INV_ITEM_VOLUME , S.INV_ITEM_SIZE , S.INV_ITEM_COLOR , S.UNIT_MEASURE_DIM , S.UNIT_MEASURE_WT , S.UNIT_MEASURE_TEMP , S.UNIT_MEASURE_VOL , S.COMMODITY_CD , S.HARMONIZED_CD , S.MSDS_ID , M.INVENTORY_ITEM , S.LAST_MAINT_OPRID , S.LAST_DTTM_UPDATE , S.DESCR254 , S.COMMODITY_CD_EU , S.AVAIL_LEAD_TIME , S.RETEST_LEAD_TIME , M.PROMISE_OPTION FROM PS_INV_ITEMS S , PS_MASTER_ITEM_TBL M WHERE S.SETID = M.SETID AND S.INV_ITEM_ID = M.INV_ITEM_ID |
| # | 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 NOT NULL |
Effective Date
Default Value: %date |
| 4 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive |
| 5 | UPC_ID | Character(18) | VARCHAR2(18) NOT NULL | Uniform Product Code ID |
| 6 | POTENCY_RATING | Character(4) | VARCHAR2(4) NOT NULL |
Potency Code
Prompt Table: POTENCY_CD_INV |
| 7 | INV_ITEM_TEMPLATE | Character(5) | VARCHAR2(5) NOT NULL |
Template ID
Prompt Table: INV_ITEM_TEMPL |
| 8 | INV_ITEM_TYPE | Character(5) | VARCHAR2(5) NOT NULL | Item Type |
| 9 | RECYCLE_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Item Recycle Flag
Y/N Table Edit Default Value: N |
| 10 | REUSABLE_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Reusable Item Flag
Y/N Table Edit Default Value: N |
| 11 | DISPOSABLE_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Special Disposable Flag
Y/N Table Edit Default Value: N |
| 12 | INV_STOCK_TYPE | Character(4) | VARCHAR2(4) NOT NULL | Stock Type |
| 13 | PACKING_CD | Character(4) | VARCHAR2(4) NOT NULL | Packing Code |
| 14 | STOR_RULES_ID | Character(4) | VARCHAR2(4) NOT NULL | Storage Rule ID |
| 15 | SHIP_TYPE_ID | Character(10) | VARCHAR2(10) NOT NULL | Ship Via Code |
| 16 | RECOM_STOR_TEMP | Signed Number(7,2) | DECIMAL(5,2) NOT NULL | Storage Temp |
| 17 | RECOM_HUMIDITY_PCT | Signed Number(7,2) | DECIMAL(5,2) NOT NULL | Storage Humidity |
| 18 | INV_PROD_GRADE | Character(4) | VARCHAR2(4) NOT NULL | Grade |
| 19 | MAX_CAPACITY | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Max Capacity |
| 20 | HAZ_CLASS_CD | Character(4) | VARCHAR2(4) NOT NULL | Hazard Code |
| 21 | INTL_HAZARD_ID | Character(15) | VARCHAR2(15) NOT NULL | Intl Hazard ID |
| 22 | CHARGE_CODE | Character(20) | VARCHAR2(20) NOT NULL | Charge Code |
| 23 | SHELF_LIFE | Number(4,0) | SMALLINT NOT NULL | Shelf Life (Days) |
| 24 | AVAIL_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Availability Status
1=Open 2=Restricted 3=Hold 4=Rejected |
| 25 | INV_ITEM_HEIGHT | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Item Height |
| 26 | INV_ITEM_LENGTH | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Item Length |
| 27 | INV_ITEM_WIDTH | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Item Width |
| 28 | INV_ITEM_WEIGHT | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Item Weight |
| 29 | INV_ITEM_VOLUME | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Volume |
| 30 | INV_ITEM_SIZE | Character(5) | VARCHAR2(5) NOT NULL | Item Size |
| 31 | INV_ITEM_COLOR | Character(10) | VARCHAR2(10) NOT NULL | Item Color |
| 32 | UNIT_MEASURE_DIM | Character(3) | VARCHAR2(3) NOT NULL | Dimension UOM |
| 33 | UNIT_MEASURE_WT | Character(3) | VARCHAR2(3) NOT NULL | Weight UOM |
| 34 | UNIT_MEASURE_TEMP | Character(3) | VARCHAR2(3) NOT NULL | Temperature UOM |
| 35 | UNIT_MEASURE_VOL | Character(3) | VARCHAR2(3) NOT NULL | Volume UOM |
| 36 | COMMODITY_CD | Character(10) | VARCHAR2(10) NOT NULL | Commodity Code |
| 37 | HARMONIZED_CD | Character(14) | VARCHAR2(14) NOT NULL | Harmonized Code |
| 38 | MSDS_ID | Character(10) | VARCHAR2(10) NOT NULL | MSDS ID |
| 39 | INVENTORY_ITEM | Character(1) | VARCHAR2(1) NOT NULL |
Inventory Item
N=No Y=Yes |
| 40 | LAST_MAINT_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Last Maintained By Operator ID |
| 41 | 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. |
| 42 | DESCR254 | Character(254) | VARCHAR2(254) NOT NULL | Description of length 254 |
| 43 | COMMODITY_CD_EU | Character(10) | VARCHAR2(10) NOT NULL | EU Commodity Code |
| 44 | AVAIL_LEAD_TIME | Number(4,0) | SMALLINT NOT NULL | Availability Lead Time (Days) |
| 45 | RETEST_LEAD_TIME | Number(4,0) | SMALLINT NOT NULL | Retest Lead Time (Days) |
| 46 | PROMISE_OPTION | Character(1) | VARCHAR2(1) NOT NULL |
Order Promise Option
2=Perform ATP Reservations |