CM_CST_RCYL_VW

(SQL View)
 Index Back

Recycle By Product 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.CE_RESOURCE , 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) FROM PS_CE_ACTUAL_COST A , PS_BUS_UNIT_TBL_IN B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.TRANSACTION_GROUP = '621' 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 TOTAL_COST Signed Number(16,4) DECIMAL(14,4) NOT NULL Total 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