SETID_PRODUCTPRODUCT_IDPrompt Table: PROD_ITEM
CURRENCY_CDUNIT_OF_MEASURECS=Case
EA=Each
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
Prompt Table: %EDITTABLE
PROD_UOM_SET_VW(SQL View) |
Index Back |
|---|---|
Product UOM by setid_product |
| SELECT A.setid , A.product_id , B.currency_cd , A.unit_of_measure , B.list_price , A.min_order_qty , A.max_order_qty , A.order_increment , B.unit_cost FROM PS_PROD_UOM A , PS_PROD_PRICE B WHERE B.SETID = A.SETID AND B.PRODUCT_ID = A.PRODUCT_ID AND B.UNIT_OF_MEASURE = A.UNIT_OF_MEASURE AND B.EFFDT = ( SELECT MAX(C.EFFDT) FROM PS_PROD_PRICE C WHERE C.SETID = B.SETID AND C.PRODUCT_ID = B.PRODUCT_ID AND C.UNIT_OF_MEASURE = B.UNIT_OF_MEASURE AND C.CURRENCY_CD = B.CURRENCY_CD AND C.EFF_STATUS = 'A' AND C.EFFDT <= %CurrentDateIn ) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID_PRODUCT |
Character(5) | VARCHAR2(5) NOT NULL | Product SetID |
| 2 | PRODUCT_ID |
Character(18) | VARCHAR2(18) NOT NULL |
Product ID
Prompt Table: PROD_ITEM |
| 3 | CURRENCY_CD |
Character(3) | VARCHAR2(3) NOT NULL | This field stores the Currency Code value. |
| 4 | UNIT_OF_MEASURE |
Character(3) | VARCHAR2(3) NOT NULL |
Used on an approval rule set.
CS=Case EA=Each MHR=Muti Hourly PER=Percentage SQF=Square Footage Prompt Table: %EDITTABLE |
| 5 | LIST_PRICE | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | List Price |
| 6 | MIN_ORDER_QTY | Number(15,4) | DECIMAL(14,4) NOT NULL | Min Ord Qty |
| 7 | MAX_ORDER_QTY | Number(15,4) | DECIMAL(14,4) NOT NULL | Max Ord Qty |
| 8 | ORDER_INCREMENT | Number(15,4) | DECIMAL(14,4) NOT NULL | Increment Quantity |
| 9 | UNIT_COST | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | Unit Cost |