WM_SUMCOST_AET (SQL Table)	Index Back
Cost Summary State Table Cost Summary State Record Table

WM_SUMCOST_AET

(SQL Table)

Cost Summary State Table

Cost Summary State Record Table

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID

3 BASE_CURRENCY Character(3) VARCHAR2(3) NOT NULL "Specifies the primary currency for a general ledger business unit, and is sometimes referred to as the ""book"" currency. Each business unit has one base currency. which is usually, but not always, the local currency for the organization. Journal entries are posted to a business unit in its base currency. "

4 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.

5 RT_RATE_INDEX Character(10) VARCHAR2(10) NOT NULL Market Rate Index

6 RATE_MULT Signed Number(17,8) DECIMAL(15,8) NOT NULL Rate Multiplier

7 TRANS_DT Date(10) DATE Transaction Date

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

9 SUMCOST_OPT Character(1) VARCHAR2(1) NOT NULL Options to process Cost Summarization
A=All
B=Business Unit
S=Shop
W=Work Order

10 SHOP_ID Character(10) VARCHAR2(10) NOT NULL Shop Identification

11 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

12 ACTL_COST_LBR Signed Number(28,3) DECIMAL(26,3) NOT NULL Actual Labor Cost

13 ACTL_COST_TLS Signed Number(28,3) DECIMAL(26,3) NOT NULL Actual Tools Cost

14 ACTL_COST_MAT Signed Number(28,3) DECIMAL(26,3) NOT NULL Actual Cost

15 ACTL_COST_PO Signed Number(28,3) DECIMAL(26,3) NOT NULL Actual procurement costs for a work order

16 CAPITALIZE_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount to be Capitalized

17 WHERE_CLAUSE Character(254) VARCHAR2(254) NOT NULL Where Clause

18 BUSINESS_UNIT_WO Character(5) VARCHAR2(5) NOT NULL Business Unit Work Order
Prompt Table: SP_BU_WM_NONVW

19 WO_ID Character(10) VARCHAR2(10) NOT NULL Work Order Identification
Prompt Table: %EDIT_WO_ID

20 WO_TASK_ID Number(5,0) INTEGER NOT NULL Task Number
Prompt Table: %EDIT_WO_TASK

21 RSRC_TYPE Character(1) VARCHAR2(1) NOT NULL Work Order Management Resource Types
1=Labor
2=Tools
3=Material

22 RES_LN_NBR Number(5,0) INTEGER NOT NULL Resource Line No.
Prompt Table: %EDIT_RES_LINE

23 RATE_DIV Number(16,8) DECIMAL(15,8) NOT NULL Rate Divisor

24 COST_SUMM_DAYS_TSK Signed Number(6,0) DECIMAL(5) NOT NULL Number of days for Cost Summarization to Collect Cost

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
3	BASE_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	"Specifies the primary currency for a general ledger business unit, and is sometimes referred to as the ""book"" currency. Each business unit has one base currency. which is usually, but not always, the local currency for the organization. Journal entries are posted to a business unit in its base currency. "
4	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.
5	RT_RATE_INDEX	Character(10)	VARCHAR2(10) NOT NULL	Market Rate Index
6	RATE_MULT	Signed Number(17,8)	DECIMAL(15,8) NOT NULL	Rate Multiplier
7	TRANS_DT	Date(10)	DATE	Transaction Date
8	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
9	SUMCOST_OPT	Character(1)	VARCHAR2(1) NOT NULL	Options to process Cost Summarization A=All B=Business Unit S=Shop W=Work Order
10	SHOP_ID	Character(10)	VARCHAR2(10) NOT NULL	Shop Identification
11	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
12	ACTL_COST_LBR	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Actual Labor Cost
13	ACTL_COST_TLS	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Actual Tools Cost
14	ACTL_COST_MAT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Actual Cost
15	ACTL_COST_PO	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Actual procurement costs for a work order
16	CAPITALIZE_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Amount to be Capitalized
17	WHERE_CLAUSE	Character(254)	VARCHAR2(254) NOT NULL	Where Clause
18	BUSINESS_UNIT_WO	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Work Order Prompt Table: SP_BU_WM_NONVW
19	WO_ID	Character(10)	VARCHAR2(10) NOT NULL	Work Order Identification Prompt Table: %EDIT_WO_ID
20	WO_TASK_ID	Number(5,0)	INTEGER NOT NULL	Task Number Prompt Table: %EDIT_WO_TASK
21	RSRC_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Work Order Management Resource Types 1=Labor 2=Tools 3=Material
22	RES_LN_NBR	Number(5,0)	INTEGER NOT NULL	Resource Line No. Prompt Table: %EDIT_RES_LINE
23	RATE_DIV	Number(16,8)	DECIMAL(15,8) NOT NULL	Rate Divisor
24	COST_SUMM_DAYS_TSK	Signed Number(6,0)	DECIMAL(5) NOT NULL	Number of days for Cost Summarization to Collect Cost