CM_NP_SFVAR_VW

(SQL View)
 Index Back

Pending SF_VARIANCES rows


SELECT A.BUSINESS_UNIT , B.CM_BOOK , A.TRANS_DATE , ' ' , C.TRANSACTION_GROUP , A.COST_ELEMENT , A.PRODUCTION_ID , 0 , ' ' , A.VARIANCE_TYPE , A.VARIANCE_SOURCE , ' ' , ' ' , A.SEQ_NBR , ' ' , A.POSTED_FLAG , %Substring(D.MESSAGE_TEXT, 1,50) , ' ' , 0 , A.TRANS_DATE , A.TRANS_TIME , %DateTimeNull , %DateTimeNull , 0 , 0 , %DateTimeNull , 0 , ' ' , ' ' , ' ' , 0 , 0 , ' ' , ' ' , ' ' , ' ' , A.PROCESS_INSTANCE , ' ' , ' ' , 0 , ' ' FROM PS_SF_VARIANCES A , PS_CM_BU_BOOK_TBL B , PS_CM_NP_TRANGRP C , PSMSGCATDEFN D WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND B.CM_BOOK_STATUS = 'A' AND A.POSTED_FLAG = 'N' AND C.RECNAME = 'VARIANCES' AND A.VARIANCE_TYPE = C.VARIANCE_TYPE AND A.VARIANCE_SOURCE IN ('C','0') AND D.MESSAGE_SET_NBR = 15500 AND D.MESSAGE_NBR = 199

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 CM_BOOK Character(10) VARCHAR2(10) NOT NULL Cost Book
3 TRANSACTION_DATE Date(10) DATE Transaction Date
4 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
5 TRANSACTION_GROUP Character(3) VARCHAR2(3) NOT NULL 11/7/02 LLR - Added the new (600's) transactions groups for 8.8.
6 COST_ELEMENT Character(4) VARCHAR2(4) NOT NULL Cost Element
7 PRODUCTION_ID Character(10) VARCHAR2(10) NOT NULL Production ID
8 OP_SEQUENCE Number(4,0) SMALLINT NOT NULL Operation Sequence
9 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
10 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
11 VARIANCE_SOURCE Character(2) VARCHAR2(2) NOT NULL Variance Source
C=Close
O=Re-Open
R=Report
12 CONFIG_CODE Character(50) VARCHAR2(50) NOT NULL Product Configurator
13 REVALUE_TYPE Character(2) VARCHAR2(2) NOT NULL 1/25/99 - CRC EN800-6.0 : added revalue type = '05' for co/by product
01=Inventory
02=Inspection
03=WIP - Comp
04=WIP - Assy
05=WIP - Waste
14 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number
15 CM_COST_MODE Character(1) VARCHAR2(1) NOT NULL 07/99 GMG CN800-9.0:
L=Live
S=Simulated
16 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
17 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50
18 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.
19 MG_PROC_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
20 TRANS_DATE Date(10) DATE Transaction Date
21 TRANS_TIME Time(15) TIMESTAMP Transaction Time
22 DT_TIMESTAMP DateTime(26) TIMESTAMP Date Timestamp
23 CM_DT_TIMESTAMP_A DateTime(26) TIMESTAMP 07/99 GMG CN800-9.0: Original putaway dttm when bin-to-bin'd.
24 CM_SEQ_NBR_A Number(15,0) DECIMAL(15) NOT NULL 07/99 GMG CN800-9.0:
25 CM_SEQ_COST Number(15,0) DECIMAL(15) NOT NULL Cost Sequence Number. Incremented each time the actual cost is updated.
26 CM_DT_TIMESTAMP DateTime(26) TIMESTAMP Receipt dttm.
27 CM_SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number
28 FROM_PRDN_ID Character(10) VARCHAR2(10) NOT NULL From Production ID
29 TO_PRDN_ID Character(10) VARCHAR2(10) NOT NULL To Production ID
30 ORDER_NO Character(10) VARCHAR2(10) NOT NULL Identifies a customer order number that appears as a reference on a receivables pending item. Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop
31 ORDER_INT_LINE_NO Number(5,0) INTEGER NOT NULL Order Line
32 SCHED_LINE_NBR Number(6,0) INTEGER NOT NULL Schedule Line Number
33 SHIP_ID Character(10) VARCHAR2(10) NOT NULL Shipping ID
34 DELIVERY_ID Character(10) VARCHAR2(10) NOT NULL Delivery ID
35 CHARGE_TYPE Character(1) VARCHAR2(1) NOT NULL Shipping Charge Type
F=Freight
M=Misc Chrgs
N=Non-stock
36 STORAGE_AREA Character(5) VARCHAR2(5) NOT NULL Storage Area
37 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
38 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
39 CE_RESOURCE Character(18) VARCHAR2(18) NOT NULL Resource
40 CE_SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number
41 CE_CODE Character(4) VARCHAR2(4) NOT NULL Conversion Code