MIN_DMD_UOM_VW1(SQL View) |
Index Back |
---|---|
Pick Feedback Loc UOM View |
SELECT DISTINCT BUSINESS_UNIT , INV_ITEM_ID , STORAGE_AREA , STOR_LEVEL_1 , STOR_LEVEL_2 , STOR_LEVEL_3 , STOR_LEVEL_4 ,SERIAL_ID ,INV_LOT_ID , UNIT_OF_MEASURE FROM PS_PHYSICAL_INV WHERE UNIT_OF_MEASURE <> ' ' AND (AVAIL_STATUS = '1' OR AVAIL_STATUS = '2') |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | Character(5) | VARCHAR2(5) NOT NULL | Business Unit | |
2 | Character(18) | VARCHAR2(18) NOT NULL | Item ID | |
3 | Character(5) | VARCHAR2(5) NOT NULL | Storage Area | |
4 | Character(4) | VARCHAR2(4) NOT NULL | Storage Level 1 | |
5 | Character(4) | VARCHAR2(4) NOT NULL | Storage Level 2 | |
6 | Character(4) | VARCHAR2(4) NOT NULL | Storage Level 3 | |
7 | Character(4) | VARCHAR2(4) NOT NULL | Storage Level 4 | |
8 | Character(254) | VARCHAR2(254) NOT NULL | Serial ID | |
9 | MIN_LOT_ID | Character(254) | VARCHAR2(254) NOT NULL | Lot ID |
10 | Character(3) | VARCHAR2(3) NOT NULL |
Used on an approval rule set.
MHR=Muti Hourly PER=Percentage SQF=Square Footage |