WM_GETCOST_AET

(SQL Table)
Index Back

State record for IN cost

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 BUSINESS_UNIT_WO Character(5) VARCHAR2(5) NOT NULL Business Unit Work Order
3 PM_SCHD_ID Character(10) VARCHAR2(10) NOT NULL Preventive Maintenance Schedule ID
4 WO_ID Character(10) VARCHAR2(10) NOT NULL Work Order Identification
5 WO_TASK_ID Number(5,0) INTEGER NOT NULL Task Number
6 RQMT_LN_NBR Number(5,0) INTEGER NOT NULL Requirement Line Number

Default Value: 1

7 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
8 CM_BOOK Character(10) VARCHAR2(10) NOT NULL Cost Book
9 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
10 UNIT_MEASURE_ORD Character(3) VARCHAR2(3) NOT NULL Ordering UOM
11 UNIT_MEASURE_STD Character(3) VARCHAR2(3) NOT NULL Standard Unit of Measure
12 QTY_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Base Quantity
13 CONVERSION_RATE Signed Number(17,8) DECIMAL(15,8) NOT NULL Conversion Rate
14 CM_UNIT_COST Signed Number(27,15) DECIMAL(25,15) NOT NULL 07/99 GMG CN800-9.0:
15 CE_EXTENDED_COST Signed Number(32,15) DECIMAL(30,15) NOT NULL Extended Cost
16 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
17 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.