OM_MCP_LFLTR_VW

(SQL View)
Index Back

Price List Filter

Price List Filter

SELECT OM_MCP_LINE_STATUS , ERROR_LABEL , PRICE_LIST_ID , PRODUCT_ID , INV_ITEM_ID , UNIT_OF_MEASURE , CURRENCY_CD , UNIT_COST , ALTERNATE_COST , LIST_PRICE , EFFDT , END_DATE , BREAK_QTY_LOW , BREAK_QTY_HIGH FROM PS_OM_MCP_LPRC_DTL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OM_MCP_LINE_STATUS Character(2) VARCHAR2(2) NOT NULL 06/01/2014 Price Mass Maintenance
10=New
20=Changed
30=Validated
40=Validate Error
50=Uploaded
60=Upload Error
2 ERROR_LABEL Character(100) VARCHAR2(100) NOT NULL Error Label
3 PRICE_LIST_ID Character(10) VARCHAR2(10) NOT NULL Price List ID

Prompt Table: EOEP_PRCLST_VW

4 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID

Prompt Table: OM_MCP_LPROD_VW

5 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID

Prompt Table: OM_MCP_LITM_VW

6 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage

Prompt Table: OM_MCP_LUOM_VW

7 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

Prompt Table: OM_MCP_LCUR_VW

8 UNIT_COST Signed Number(16,4) DECIMAL(14,4) NOT NULL Unit Cost
9 ALTERNATE_COST Signed Number(16,4) DECIMAL(14,4) NOT NULL Alternate Cost for Mass Pricing.
10 LIST_PRICE Signed Number(17,4) DECIMAL(15,4) NOT NULL List Price
11 EFFDT Date(10) DATE Effective Date

Default Value: %date

12 END_DATE Date(10) DATE End Date
13 BREAK_QTY_LOW Number(15,4) DECIMAL(14,4) NOT NULL Low Quantity/Amount

Default Value: 0

14 BREAK_QTY_HIGH Number(15,4) DECIMAL(14,4) NOT NULL Upper Quantity/Amount