BUSINESS_UNITORDER_NOPRODUCT_IDUNIT_OF_MEASUREMHR=Muti Hourly
PER=Percentage
SQF=Square Footage
D=Decimal
W=Whole Nbr
D=Round Down
N=Natural Round
U=Round Up
ORD_CONVRATE_VW(SQL View) |
Index Back |
|---|---|
Product Pricing UOM ViewProduct Pricing UOM View |
| SELECT DISTINCT L.BUSINESS_UNIT , L.ORDER_NO , L.PRODUCT_ID , I.UNIT_OF_MEASURE , I.SETID , I.INV_ITEM_ID , I.QTY_PRECISION , I.ROUND_RULE , I.CONVERSION_RATE FROM %Table(ORD_LINE) L , %Table(PROD_ITEM) P , %Table(SET_CNTRL_REC) X , %Table(INV_ORDR_UOM_VW) I WHERE L.PRODUCT_ID = P.PRODUCT_ID AND P.SETID = X.SETID AND X.SETCNTRLVALUE = L.BUSINESS_UNIT AND X.RECNAME = 'ORDENT_PITEM_VW' AND P.SETID = I.SETID AND P.INV_ITEM_ID = I.INV_ITEM_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | ORDER_NO |
Character(10) | VARCHAR2(10) NOT NULL | Identifies a customer order number that appears as a reference on a receivables pending item. Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop |
| 3 | PRODUCT_ID |
Character(18) | VARCHAR2(18) NOT NULL | Product ID |
| 4 | UNIT_OF_MEASURE |
Character(3) | VARCHAR2(3) NOT NULL |
Used on an approval rule set.
MHR=Muti Hourly PER=Percentage SQF=Square Footage |
| 5 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 6 | INV_ITEM_ID | Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 7 | QTY_PRECISION | Character(1) | VARCHAR2(1) NOT NULL |
Quantity Precision
D=Decimal W=Whole Nbr |
| 8 | ROUND_RULE | Character(1) | VARCHAR2(1) NOT NULL |
Rounding Rule
D=Round Down N=Natural Round U=Round Up |
| 9 | CONVERSION_RATE | Signed Number(17,8) | DECIMAL(15,8) NOT NULL | Conversion Rate |