BUSINESS_UNITORDER_NODS_NETWORK_CODESHIP_FROM_BUPRODUCT_IDUNIT_OF_MEASUREMHR=Muti Hourly
PER=Percentage
SQF=Square Footage
CURRENCY_CDPROD_PRCIBU3_VW(SQL View) |
Index Back |
|---|---|
Product price by IBU |
| SELECT oh.business_unit , oh.order_no , s.ds_network_code , s.business_unit_in , p.product_id , p.unit_of_measure , p.currency_cd , p.list_price FROM ps_prod_price p , ps_set_cntrl_rec sc2 , ps_ds_netdet_tbl s , ps_set_cntrl_rec sc , PS_ORD_HEADER oh WHERE p.setid = sc2.setid AND p.business_unit_in = s.business_unit_in AND p.eff_status = 'A' AND %EffdtCheck(prod_price p2, p, oh.order_date) AND sc2.setcntrlvalue = oh.business_unit AND sc2.recname = 'PROD_PRICE' AND s.setid = sc.setid AND sc.setcntrlvalue = oh.business_unit AND sc.recname = 'DS_NETDET_TBL' |
| # | 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 | DS_NETWORK_CODE |
Character(6) | VARCHAR2(6) NOT NULL | Distribution Network Code |
| 4 | SHIP_FROM_BU |
Character(5) | VARCHAR2(5) NOT NULL | Ship from INV BU |
| 5 | PRODUCT_ID |
Character(18) | VARCHAR2(18) NOT NULL | Product ID |
| 6 | UNIT_OF_MEASURE |
Character(3) | VARCHAR2(3) NOT NULL |
Used on an approval rule set.
MHR=Muti Hourly PER=Percentage SQF=Square Footage |
| 7 | CURRENCY_CD |
Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 8 | LIST_PRICE | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | List Price |