CM_ACCTG_ER_OVW

(SQL View)
 Index Back

Accounting Line Error View

05/02 MXS B1068/RES100269/INC71232001 : ALC abends when processing two books from one BU. Date Initials Issue Description 120506 SS 1587321000 Changes done to correct the navigation of transfer hyperlinks on the Accounting Line Errors page for InterUnit transactions. 12/08 F-MLIZI-L7QX0: add DELIVERY_ID for 9.1 freight project

SELECT PROCESS_INSTANCE , A.BUSINESS_UNIT , TRANSACTION_GROUP , ACCTG_LINE_NO , CM_BOOK , SOURCE_BUS_UNIT , INV_ITEM_ID , INV_ITEM_GROUP , DISTRIB_TYPE , COST_ELEMENT , DEBIT_CREDIT , DT_TIMESTAMP , SEQ_NBR , CM_DT_TIMESTAMP , CM_SEQ_NBR , CM_DT_TIMESTAMP_A , CM_SEQ_NBR_A , CM_SEQ_COST , MG_PROC_INSTANCE , PRODUCTION_ID , STORAGE_AREA , CONFIG_CODE , REVALUE_TYPE , DESTIN_BU , OP_SEQUENCE , VARIANCE_TYPE , VARIANCE_SOURCE , TRANS_DATE , TRANS_TIME , PRODUCTION_TYPE , PRDN_AREA_CODE , CONVERSION_TYPE , REVALUE_FLAG , ORDER_NO , ORDER_INT_LINE_NO , SCHED_LINE_NBR , SHIP_ID , DELIVERY_ID , CHARGE_TYPE , FROM_PRDN_ID , TO_PRDN_ID , RECNAME_UPDATE , RECNAME_TRANS , ADJUST_TYPE , MONETARY_AMOUNT , RUN_CNTL_ID , REQUEST_ID , CM_ERROR_CODE , DEMAND_LINE_NO , IU_FROM_GLBU , IU_TO_GLBU , IU_TRAN_CD , SETID , IU_INTER_TMPLT_CD , IU_INTRA_TMPLT_CD , B.OPRID FROM PS_CM_ACCTG_ERR_VW A , PS_SEC_BU_OPR B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT

# 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 Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: SP_CMACTE_NONVW

3 TRANSACTION_GROUP Character(3) VARCHAR2(3) NOT NULL 11/7/02 LLR - Added the new (600's) transactions groups for 8.8.
4 ACCTG_LINE_NO Number(15,0) DECIMAL(15) NOT NULL Accounting Line Number
5 CM_BOOK Character(10) VARCHAR2(10) NOT NULL Cost Book
6 SOURCE_BUS_UNIT Character(5) VARCHAR2(5) NOT NULL Source Bus Unit
7 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
8 INV_ITEM_GROUP Character(15) VARCHAR2(15) NOT NULL Item Group
9 DISTRIB_TYPE Character(10) VARCHAR2(10) NOT NULL Distrib. Type
10 COST_ELEMENT Character(4) VARCHAR2(4) NOT NULL Cost Element
11 DEBIT_CREDIT Character(2) VARCHAR2(2) NOT NULL Debit / Credit Indicator
CR=Credit
DR=Debit
12 DT_TIMESTAMP DateTime(26) TIMESTAMP Date Timestamp
13 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number
14 CM_DT_TIMESTAMP DateTime(26) TIMESTAMP Receipt dttm.
15 CM_SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number
16 CM_DT_TIMESTAMP_A DateTime(26) TIMESTAMP 07/99 GMG CN800-9.0: Original putaway dttm when bin-to-bin'd.
17 CM_SEQ_NBR_A Number(15,0) DECIMAL(15) NOT NULL 07/99 GMG CN800-9.0:
18 CM_SEQ_COST Number(15,0) DECIMAL(15) NOT NULL Cost Sequence Number. Incremented each time the actual cost is updated.
19 MG_PROC_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
20 PRODUCTION_ID Character(10) VARCHAR2(10) NOT NULL Production ID
21 STORAGE_AREA Character(5) VARCHAR2(5) NOT NULL Storage Area
22 CONFIG_CODE Character(50) VARCHAR2(50) NOT NULL Product Configurator
23 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
24 DESTIN_BU Character(5) VARCHAR2(5) NOT NULL Destination Unit
25 OP_SEQUENCE Number(4,0) SMALLINT NOT NULL Operation Sequence
26 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
27 VARIANCE_SOURCE Character(2) VARCHAR2(2) NOT NULL Variance Source
C=Close
O=Re-Open
R=Report
28 TRANS_DATE Date(10) DATE Transaction Date
29 TRANS_TIME Time(15) TIMESTAMP Transaction Time
30 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
31 PRDN_AREA_CODE Character(10) VARCHAR2(10) NOT NULL Production Area
32 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
33 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.

Y/N Table Edit

34 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
35 ORDER_INT_LINE_NO Number(5,0) INTEGER NOT NULL Order Line
36 SCHED_LINE_NBR Number(6,0) INTEGER NOT NULL Schedule Line Number
37 SHIP_ID Character(10) VARCHAR2(10) NOT NULL Shipping ID
38 DELIVERY_ID Character(10) VARCHAR2(10) NOT NULL Delivery ID
39 CHARGE_TYPE Character(1) VARCHAR2(1) NOT NULL Shipping Charge Type
F=Freight
M=Misc Chrgs
N=Non-stock
40 FROM_PRDN_ID Character(10) VARCHAR2(10) NOT NULL From Production ID
41 TO_PRDN_ID Character(10) VARCHAR2(10) NOT NULL To Production ID
42 RECNAME_UPDATE Character(15) VARCHAR2(15) NOT NULL Record to Update
43 RECNAME_TRANS Character(18) VARCHAR2(18) NOT NULL Selected Transactions
44 ADJUST_TYPE Character(1) VARCHAR2(1) NOT NULL Adjustment Type
0=CM Only
A=VMI Return
D=Decrease
I=Increase
M=Misc Issue
R=Misc Return
S=Scrap
V=Scrap RTV
45 MONETARY_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Specifies the monetary amount of a debit or credit in the business unit base currency. Debit entries are positive and credit entries are negative. This amount is only zero if associated with a statistical account.
46 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
47 REQUEST_ID Character(10) VARCHAR2(10) NOT NULL Request ID
48 CM_ERROR_CODE Character(4) VARCHAR2(4) NOT NULL Account Line Creation Error
INTR=No InterUnit Rules
PROD=No Production Area Rule
RULE=No Account Distribution Rule
STOR=No Storage Area Rule
49 DEMAND_LINE_NO Number(4,0) SMALLINT NOT NULL Demand Line No
50 IU_FROM_GLBU Character(5) VARCHAR2(5) NOT NULL From GL Business Unit
51 IU_TO_GLBU Character(5) VARCHAR2(5) NOT NULL To GL Business Unit
52 IU_TRAN_CD Character(8) VARCHAR2(8) NOT NULL Transaction Codes are user-defined. They are mapped to the delivered System Transactions. InterUnit and IntraUnit Templates are keyed by Transaction code, allowing users to vary their accounting by transaction.
53 SETID Character(5) VARCHAR2(5) NOT NULL SetID
54 IU_INTER_TMPLT_CD Character(5) VARCHAR2(5) NOT NULL Key to the interunit template record. Assigned to a GLBU on the GL business unit table.
55 IU_INTRA_TMPLT_CD Character(5) VARCHAR2(5) NOT NULL Key field for IntraUnit Template
56 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).