CM_CST_ALAB_VW (SQL View)	Index Back
Actual Labor Cost Posting

CM_CST_ALAB_VW

(SQL View)

Actual Labor Cost Posting

SELECT A.BUSINESS_UNIT , A.PRODUCTION_ID , A.OP_SEQUENCE , A.CE_COST_CATEGORY , A.CE_RESOURCE , A.CM_BOOK , A.DT_TIMESTAMP , A.CE_SEQ_NBR , A.COST_ELEMENT , A.CE_CODE , A.INV_ITEM_ID , A.CE_EXTENDED_COST , A.QTY , A.DISTRIB_TYPE , A.POSTED_FLAG , A.PROCESS_INSTANCE , B.BUSINESS_UNIT_GL , A.TRANSACTION_GROUP , B.BASE_CURRENCY , B.BASE_CURRENCY , B.APPL_JRNL_ID , %DatePart(A.DT_TIMESTAMP) , %subrec(CM_CE_ACTCS_SBR ,A) FROM PS_CE_ACTUAL_COST A , PS_BUS_UNIT_TBL_IN B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.TRANSACTION_GROUP = '640' AND A.POSTED_FLAG = 'N'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

2 PRODUCTION_ID Character(10) VARCHAR2(10) NOT NULL Production ID

3 OP_SEQUENCE Number(4,0) SMALLINT NOT NULL Operation Sequence

4 CE_COST_CATEGORY Character(4) VARCHAR2(4) NOT NULL 10/07/02 - LLR Added field CE_COST_CATEGORY for Debits to WIP.
%L=% Labor Overhead
%M=% Material Overhead
ADD=Additional Cost
ADJ=Adjustments
CO=Co Product
LAB=Labor Cost
MACH=Machine Cost
MAT=Material Cost
OTH=Other Cost
OVHD=Standard Cost Overhead
PL=Per Labor Overhead
PM=Per Machine Overhead
PO=Subcontracted PO-STD Cost
PRIM=Primary Product
PU=Per Unit Overhead
RB=Recycle By-Products
SCRP=Scrap Cost
STD=Subcontracted Standard Cost
SUBC=Subcontracted Cost
VCHR=Subcontracted VCHR - PO Cost
WB=Waste By-Products
WO=Write-off no cost adj

5 CE_RESOURCE Character(18) VARCHAR2(18) NOT NULL Resource

6 CM_BOOK Character(10) VARCHAR2(10) NOT NULL Cost Book

7 DT_TIMESTAMP DateTime(26) TIMESTAMP Date Timestamp

8 CE_SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number

9 COST_ELEMENT Character(4) VARCHAR2(4) NOT NULL Cost Element

10 CE_CODE Character(4) VARCHAR2(4) NOT NULL Conversion Code

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

12 CE_EXTENDED_COST Signed Number(32,15) DECIMAL(30,15) NOT NULL Extended Cost

13 QTY_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Base Quantity
Default Value: 1

14 DISTRIB_TYPE Character(10) VARCHAR2(10) NOT NULL Distrib. Type

15 POSTED_FLAG Character(1) VARCHAR2(1) NOT NULL A flag that indicates whether or not a Receivables item has been posted. This field is automatically updated by the Receivables Update program.
N=Not Posted
X=Don't Post
Y=Posted

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

17 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit

18 TRANSACTION_GROUP Character(3) VARCHAR2(3) NOT NULL 11/7/02 LLR - Added the new (600's) transactions groups for 8.8.

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

20 FOREIGN_CURRENCY Character(3) VARCHAR2(3) NOT NULL Foreign Currency Code

21 APPL_JRNL_ID Character(10) VARCHAR2(10) NOT NULL Journal Template

22 ACCOUNTING_DT Date(10) DATE The accounting entry construction date for a given transaction (a generic field that crosses multiple

23 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number

24 DISTRIB_LINE_NUM Number(5,0) INTEGER NOT NULL Distribution Line

25 PRDN_AREA_CODE Character(10) VARCHAR2(10) NOT NULL Production Area

26 PRODUCTION_TYPE Character(2) VARCHAR2(2) NOT NULL JNW 11/1/98 (CN#SF800-13) activated teardown xlat
PR=Production
RW=Rework
SV=Service
TD=Teardown

27 RECEIVER_ID Character(10) VARCHAR2(10) NOT NULL Receiver number

28 RECV_LN_NBR Number(5,0) INTEGER NOT NULL Receipt Line

29 RECV_SHIP_SEQ_NBR Number(3,0) SMALLINT NOT NULL Receiver Shipping Sequence

30 REVALUE_FLAG Character(1) VARCHAR2(1) NOT NULL Can be either 'Y' or 'N'. This field is located on the ITEM Table and signifies whether or not an item will be considered by the Revaluation Process to be revaluated.

31 VARIANCE_TYPE Character(2) VARCHAR2(2) NOT NULL 9/9/02 CRC: added variance type '15' for Yield Variance
01=Configuration Variance
02=Usage Variance
03=Component Yield Variance
04=Labor Lot Size Variance
05=Process Routing Variance
06=Efficiency Variance
07=Rate Variance
08=Material Lot Size Variance
09=Rework Expense
10=Rework Labor Expense
11=Outside Processing PPV
12=Mix Variance
13=Teardown Material Expense
14=Teardown Conversion Expense
15=Yield Variance
16=Co-Product Rate Var
17=Material Rate Variance

32 MG_PROC_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

33 CONVERSION_TYPE Character(4) VARCHAR2(4) NOT NULL Conversion Type
1100=Lab Setup
1200=Lab Fixed
1300=Labor Run
1400=Lab PostPr
1500=Mach Setup
1600=Mach Fixed
1700=Mach Run
1800=MC PostPrd
2100=Ovhd 1
2200=Ovhd 2
2300=Ovhd 3
2400=Ovhd 4

34 CM_SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number

35 CM_DT_TIMESTAMP DateTime(26) TIMESTAMP Receipt dttm.

36 CM_DT_TIMESTAMP_A DateTime(26) TIMESTAMP 07/99 GMG CN800-9.0: Original putaway dttm when bin-to-bin'd.

37 CM_SEQ_NBR_A Number(15,0) DECIMAL(15) NOT NULL 07/99 GMG CN800-9.0:

38 CM_SEQ_COST Number(15,0) DECIMAL(15) NOT NULL Cost Sequence Number. Incremented each time the actual cost is updated.

39 TRANS_DATE Date(10) DATE Transaction Date

40 TRANS_TIME Time(15) TIMESTAMP Transaction Time

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	PRODUCTION_ID	Character(10)	VARCHAR2(10) NOT NULL	Production ID
3	OP_SEQUENCE	Number(4,0)	SMALLINT NOT NULL	Operation Sequence
4	CE_COST_CATEGORY	Character(4)	VARCHAR2(4) NOT NULL	10/07/02 - LLR Added field CE_COST_CATEGORY for Debits to WIP. %L=% Labor Overhead %M=% Material Overhead ADD=Additional Cost ADJ=Adjustments CO=Co Product LAB=Labor Cost MACH=Machine Cost MAT=Material Cost OTH=Other Cost OVHD=Standard Cost Overhead PL=Per Labor Overhead PM=Per Machine Overhead PO=Subcontracted PO-STD Cost PRIM=Primary Product PU=Per Unit Overhead RB=Recycle By-Products SCRP=Scrap Cost STD=Subcontracted Standard Cost SUBC=Subcontracted Cost VCHR=Subcontracted VCHR - PO Cost WB=Waste By-Products WO=Write-off no cost adj
5	CE_RESOURCE	Character(18)	VARCHAR2(18) NOT NULL	Resource
6	CM_BOOK	Character(10)	VARCHAR2(10) NOT NULL	Cost Book
7	DT_TIMESTAMP	DateTime(26)	TIMESTAMP	Date Timestamp
8	CE_SEQ_NBR	Number(15,0)	DECIMAL(15) NOT NULL	Sequence Number
9	COST_ELEMENT	Character(4)	VARCHAR2(4) NOT NULL	Cost Element
10	CE_CODE	Character(4)	VARCHAR2(4) NOT NULL	Conversion Code
11	INV_ITEM_ID	Character(18)	VARCHAR2(18) NOT NULL	Item ID
12	CE_EXTENDED_COST	Signed Number(32,15)	DECIMAL(30,15) NOT NULL	Extended Cost
13	QTY_BASE	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Base Quantity Default Value: 1
14	DISTRIB_TYPE	Character(10)	VARCHAR2(10) NOT NULL	Distrib. Type
15	POSTED_FLAG	Character(1)	VARCHAR2(1) NOT NULL	A flag that indicates whether or not a Receivables item has been posted. This field is automatically updated by the Receivables Update program. N=Not Posted X=Don't Post Y=Posted
16	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
17	BUSINESS_UNIT_GL	Character(5)	VARCHAR2(5) NOT NULL	GL Business Unit
18	TRANSACTION_GROUP	Character(3)	VARCHAR2(3) NOT NULL	11/7/02 LLR - Added the new (600's) transactions groups for 8.8.
19	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
20	FOREIGN_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	Foreign Currency Code
21	APPL_JRNL_ID	Character(10)	VARCHAR2(10) NOT NULL	Journal Template
22	ACCOUNTING_DT	Date(10)	DATE	The accounting entry construction date for a given transaction (a generic field that crosses multiple
23	SEQ_NBR	Number(15,0)	DECIMAL(15) NOT NULL	Sequence Number
24	DISTRIB_LINE_NUM	Number(5,0)	INTEGER NOT NULL	Distribution Line
25	PRDN_AREA_CODE	Character(10)	VARCHAR2(10) NOT NULL	Production Area
26	PRODUCTION_TYPE	Character(2)	VARCHAR2(2) NOT NULL	JNW 11/1/98 (CN#SF800-13) activated teardown xlat PR=Production RW=Rework SV=Service TD=Teardown
27	RECEIVER_ID	Character(10)	VARCHAR2(10) NOT NULL	Receiver number
28	RECV_LN_NBR	Number(5,0)	INTEGER NOT NULL	Receipt Line
29	RECV_SHIP_SEQ_NBR	Number(3,0)	SMALLINT NOT NULL	Receiver Shipping Sequence
30	REVALUE_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Can be either 'Y' or 'N'. This field is located on the ITEM Table and signifies whether or not an item will be considered by the Revaluation Process to be revaluated.
31	VARIANCE_TYPE	Character(2)	VARCHAR2(2) NOT NULL	9/9/02 CRC: added variance type '15' for Yield Variance 01=Configuration Variance 02=Usage Variance 03=Component Yield Variance 04=Labor Lot Size Variance 05=Process Routing Variance 06=Efficiency Variance 07=Rate Variance 08=Material Lot Size Variance 09=Rework Expense 10=Rework Labor Expense 11=Outside Processing PPV 12=Mix Variance 13=Teardown Material Expense 14=Teardown Conversion Expense 15=Yield Variance 16=Co-Product Rate Var 17=Material Rate Variance
32	MG_PROC_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
33	CONVERSION_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Conversion Type 1100=Lab Setup 1200=Lab Fixed 1300=Labor Run 1400=Lab PostPr 1500=Mach Setup 1600=Mach Fixed 1700=Mach Run 1800=MC PostPrd 2100=Ovhd 1 2200=Ovhd 2 2300=Ovhd 3 2400=Ovhd 4
34	CM_SEQ_NBR	Number(15,0)	DECIMAL(15) NOT NULL	Sequence Number
35	CM_DT_TIMESTAMP	DateTime(26)	TIMESTAMP	Receipt dttm.
36	CM_DT_TIMESTAMP_A	DateTime(26)	TIMESTAMP	07/99 GMG CN800-9.0: Original putaway dttm when bin-to-bin'd.
37	CM_SEQ_NBR_A	Number(15,0)	DECIMAL(15) NOT NULL	07/99 GMG CN800-9.0:
38	CM_SEQ_COST	Number(15,0)	DECIMAL(15) NOT NULL	Cost Sequence Number. Incremented each time the actual cost is updated.
39	TRANS_DATE	Date(10)	DATE	Transaction Date
40	TRANS_TIME	Time(15)	TIMESTAMP	Transaction Time