OM_PWCLC_AET

(SQL Table)
Index Back

Price List State Record

06/01/2014 Price Mass Maintenance

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
3 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
4 BUSINESS_UNIT_OM Character(5) VARCHAR2(5) NOT NULL Order Management Business Unit
5 SETID Character(5) VARCHAR2(5) NOT NULL SetID
6 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
7 DATE_SEL_DT Date(10) DATE 03/23/2004 SFC Added PROD_COST_EFF_DT label
8 RT_TYPE Character(5) VARCHAR2(5) NOT NULL Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.
9 CUR_EFFDT Date(10) DATE Specifies the effective date associated with the currency used as the base currency for the Business Unit on the Journal Entry Header.