CM_KK_ACTGLN_VW

(SQL View)
 Index Back

KK Update View

This view is used by the Budget Processor as the update header rec as defined for source transaction CM_TRNXTN. It mimics the keys found on the select header rec so that the join by common keys during the BP process is correct. The where clause further limits the view to kk enabled GL BUs so that '036' transactions having the same key set for inv side and expense side will only update the kk enabled expense side. 12/08 F-MLIZI-L7QX0: add DELIVERY_ID for 9.1 freight project

SELECT a.BUSINESS_UNIT , a.INV_ITEM_ID , a.DT_TIMESTAMP , a.SEQ_NBR , a.TRANSACTION_GROUP , a.ACCOUNTING_DT , a.ACCTG_LINE_NO , a.CM_BOOK , a.DISTRIB_TYPE , a.COST_ELEMENT , a.APPL_JRNL_ID , a.ACCOUNT , a.ALTACCT , a.DEPTID , %subrec(cf16_an_sbr,a) , %subrec(pc_cf1_n_sbr,a) , a.STATISTICS_CODE , a.CURRENCY_CD , a.MONETARY_AMOUNT , a.STATISTIC_AMOUNT , a.UNIT_MEASURE_STD , a.FOREIGN_AMOUNT , a.FOREIGN_CURRENCY , a.RT_TYPE , a.RATE_MULT , a.RATE_DIV , a.FERC_CD , a.DEMAND_SOURCE , a.SOURCE_BUS_UNIT , a.ORDER_NO , a.ORDER_INT_LINE_NO , a.SCHED_LINE_NO , a.DEMAND_LINE_NO , a.STAGED_DATE , a.INV_LOT_ID , a.SERIAL_ID , a.STORAGE_AREA , a.STOR_LEVEL_1 , a.STOR_LEVEL_2 , a.STOR_LEVEL_3 , a.STOR_LEVEL_4 , a.RECEIVER_ID , a.RECV_LN_NBR , a.RECV_SHIP_SEQ_NBR , a.DISTRIB_LINE_NUM , a.COUNTING_EVENT_ID , a.REVALUE_FLAG , a.JRNL_LN_REF , a.LINE_DESCR , a.BUSINESS_UNIT_GL , a.JOURNAL_ID , a.JOURNAL_DATE , a.ACCOUNTING_PERIOD , a.FISCAL_YEAR , a.GL_DISTRIB_STATUS , a.PC_DISTRIB_STATUS , a.PROCESS_INSTANCE , a.COMBO_EDIT_STATUS , a.INTRAUNIT_BAL , a.REQ_REVERSAL_POST , a.LEDGER , a.LEDGER_GROUP , a.PRDN_AREA_CODE , a.PRODUCTION_ID , a.OP_SEQUENCE , a.FROM_PRDN_AREA , a.FROM_PRDN_ID , a.FROM_PRDN_TYPE , a.TO_PRDN_AREA , a.TO_PRDN_ID , a.TO_PRDN_TYPE , a.IN_PROCESS_FLG , a.INTRAUNIT_REF , a.TRANSACTION_SOURCE , a.TRANS_LINE_TYPE , a.AP_SEQ_NBR , a.VARIANCE_TYPE , a.VARIANCE_SOURCE , a.MG_PROC_INSTANCE , a.CONFIG_CODE , a.REVALUE_TYPE , a.CONTAINER_ID , a.UNIT_OF_MEASURE , a.SCHED_LINE_NBR , a.SHIP_ID , a.DELIVERY_ID , a.CHARGE_TYPE , a.CONVERSION_TYPE , a.JOURNAL_LINE , a.PRODUCTION_TYPE , a.DESTIN_BU , a.INV_ITEM_GROUP , a.DEBIT_CREDIT , a.COMBO_VALID_FLG , a.BUDGET_HDR_STATUS , a.BUDGET_LINE_STATUS , a.BUDGET_DT , a.CM_SEQ_NBR , a.CM_DT_TIMESTAMP , a.CM_DT_TIMESTAMP_A , a.CM_SEQ_NBR_A , a.CM_SEQ_COST , a.TRANS_DATE , a.TRANS_TIME , a.KK_AMOUNT_TYPE , a.KK_TRAN_OVER_DTTM , a.KK_TRAN_OVER_FLAG , a.KK_TRAN_OVER_OPRID , a.CM_RULE , a.IU_ANCHOR_FLG , a.IU_SYS_TRAN_CD , a.IU_TRAN_CD , a.CM_IU_STATUS , a.CM_IU_INDICATOR , a.ADJUST_TYPE , a.IU_ENTRY_TYPE , a.CM_IU_SEQ_FIELD , a.CE_COST_CATEGORY , a.CE_RESOURCE , a.CE_SEQ_NBR , a.CE_CODE , a.KK_PROCESS_PRIOR , a.POSTED_DATE FROM PS_CM_ACCTG_LINE a WHERE EXISTS ( SELECT 'X' FROM PS_BU_LED_GRP_TBL G , PS_SET_CNTRL_REC H , PS_LED_GRP_LED_TBL I , PS_LED_GRP_FLD_TBL J WHERE a.BUSINESS_UNIT_GL = G.BUSINESS_UNIT AND a.LEDGER_GROUP = G.LEDGER_GROUP AND H.RECNAME = 'LED_GRP_LED_TBL' AND H.SETCNTRLVALUE = G.BUSINESS_UNIT AND I.SETID = H.SETID AND I.LEDGER_GROUP = G.LEDGER_GROUP AND (a.LEDGER = ' ' OR I.LEDGER = a.LEDGER) AND I.SETID = J.SETID AND I.LEDGER_GROUP = J.LEDGER_GROUP AND J.CHARTFIELD = 'BUSINESS_UNIT' AND G.COMMITMENT_CNTL = 'Y')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: SP_BUIN_NONVW

2 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
3 DT_TIMESTAMP DateTime(26) TIMESTAMP NOT NULL Date Timestamp
4 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number
5 TRANSACTION_GROUP Character(3) VARCHAR2(3) NOT NULL 11/7/02 LLR - Added the new (600's) transactions groups for 8.8.
6 ACCOUNTING_DT Date(10) DATE NOT NULL The accounting entry construction date for a given transaction (a generic field that crosses multiple
7 ACCTG_LINE_NO Number(15,0) DECIMAL(15) NOT NULL Accounting Line Number
8 CM_BOOK Character(10) VARCHAR2(10) NOT NULL Cost Book
9 DISTRIB_TYPE Character(10) VARCHAR2(10) NOT NULL Distrib. Type

Prompt Table: CM_DISTR_TYPE

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

Prompt Table: CM_ELEMENT

11 APPL_JRNL_ID Character(10) VARCHAR2(10) NOT NULL Journal Template
12 ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account

Prompt Table: GL_ACCOUNT_TBL

13 ALTACCT Character(10) VARCHAR2(10) NOT NULL Alternate Account
14 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
15 OPERATING_UNIT Character(8) VARCHAR2(8) NOT NULL Operating Unit ChartField

Prompt Table: OPERUNT_BUGL_VW

16 PRODUCT Character(6) VARCHAR2(6) NOT NULL Product ChartField

Prompt Table: PRODUCT_BUGL_VW

17 FUND_CODE Character(5) VARCHAR2(5) NOT NULL Fund Code

Prompt Table: FUND_BUGL_VW

18 CLASS_FLD Character(5) VARCHAR2(5) NOT NULL Class Field

Prompt Table: CLASSCF_BUGL_VW

19 PROGRAM_CODE Character(5) VARCHAR2(5) NOT NULL Program Code ChartField

Prompt Table: PROGRAM_BUGL_VW

20 BUDGET_REF Character(8) VARCHAR2(8) NOT NULL Budget Reference

Prompt Table: BUD_REF_BUGL_VW

21 AFFILIATE Character(5) VARCHAR2(5) NOT NULL Affiliate

Prompt Table: AFFILIATE_VW

22 AFFILIATE_INTRA1 Character(10) VARCHAR2(10) NOT NULL IntraUnit Affiliate1

Prompt Table: %EDIT_INTRA01

23 AFFILIATE_INTRA2 Character(10) VARCHAR2(10) NOT NULL Operating Unit Affiliate

Prompt Table: %EDIT_INTRA02

24 CHARTFIELD1 Character(10) VARCHAR2(10) NOT NULL Expansion chartfield 1

Prompt Table: CF1_BUGL_VW

25 CHARTFIELD2 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 2

Prompt Table: CF2_BUGL_VW

26 CHARTFIELD3 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 3

Prompt Table: CF3_BUGL_VW

27 BUSINESS_UNIT_PC Character(5) VARCHAR2(5) NOT NULL PC Business Unit

Prompt Table: %EDIT_BU_PC

28 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField

Prompt Table: %EDIT_PROJECT

29 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID

Prompt Table: %EDIT_ACTIVITY

30 RESOURCE_TYPE Character(5) VARCHAR2(5) NOT NULL Source Type

Prompt Table: PROJ_RESTYPE_FS
Set Control Field: BUSINESS_UNIT_PC

31 RESOURCE_CATEGORY Character(5) VARCHAR2(5) NOT NULL Category

Prompt Table: %EDIT_RES_CAT
Set Control Field: BUSINESS_UNIT_PC

32 RESOURCE_SUB_CAT Character(5) VARCHAR2(5) NOT NULL Subcategory

Prompt Table: %EDIT_RES_SUB
Set Control Field: BUSINESS_UNIT_PC

33 ANALYSIS_TYPE Character(3) VARCHAR2(3) NOT NULL Analysis Type

Prompt Table: %EDIT_ANALYSIS
Set Control Field: BUSINESS_UNIT_PC

34 STATISTICS_CODE Character(3) VARCHAR2(3) NOT NULL Statistics Code
35 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
36 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.
37 STATISTIC_AMOUNT Signed Number(17,2) DECIMAL(15,2) NOT NULL Specifies the amount associated with a statistical account on a journal line or a distribution line. It represents a quantity rather than a monetary amount and is qualified by the Unit of Measure associated with the STATISTICS_CODE or statistics ACCOUNT.
38 UNIT_MEASURE_STD Character(3) VARCHAR2(3) NOT NULL Standard Unit of Measure
39 FOREIGN_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Specifies the monetary amount of a debit or credit (accounting entry line) in the entry currency of the item. The sum of FOREIGN_AMOUNT values on AR lines should equal the ENTRY_AMT on the pending item.
40 FOREIGN_CURRENCY Character(3) VARCHAR2(3) NOT NULL Foreign Currency Code
41 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.
42 RATE_MULT Signed Number(17,8) DECIMAL(15,8) NOT NULL Rate Multiplier

Default Value: 1

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

Default Value: 1

44 FERC_CD Character(10) VARCHAR2(10) NOT NULL FERC Code
45 DEMAND_SOURCE Character(2) VARCHAR2(2) NOT NULL Demand Source
IN=Material Request
OM=Sales Order
PL=Planning Requisition
PO=Purchase Order
PR=Purchasing Requisition
RT=Material Return
SF=Production Request
WM=Work Order
46 SOURCE_BUS_UNIT Character(5) VARCHAR2(5) NOT NULL Source Bus Unit
47 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
48 ORDER_INT_LINE_NO Number(5,0) INTEGER NOT NULL Order Line
49 SCHED_LINE_NO Number(7,2) DECIMAL(6,2) NOT NULL Sched Line NO
50 DEMAND_LINE_NO Number(4,0) SMALLINT NOT NULL Demand Line No
51 STAGED_DATE Date(10) DATE Staged Date
52 INV_LOT_ID Character(15) VARCHAR2(15) NOT NULL Lot ID
53 SERIAL_ID Character(20) VARCHAR2(20) NOT NULL Serial ID
54 STORAGE_AREA Character(5) VARCHAR2(5) NOT NULL Storage Area
55 STOR_LEVEL_1 Character(4) VARCHAR2(4) NOT NULL Storage Level 1
56 STOR_LEVEL_2 Character(4) VARCHAR2(4) NOT NULL Storage Level 2
57 STOR_LEVEL_3 Character(4) VARCHAR2(4) NOT NULL Storage Level 3
58 STOR_LEVEL_4 Character(4) VARCHAR2(4) NOT NULL Storage Level 4
59 RECEIVER_ID Character(10) VARCHAR2(10) NOT NULL Receiver number
60 RECV_LN_NBR Number(5,0) INTEGER NOT NULL Receipt Line
61 RECV_SHIP_SEQ_NBR Number(3,0) SMALLINT NOT NULL Receiver Shipping Sequence
62 DISTRIB_LINE_NUM Number(5,0) INTEGER NOT NULL Distribution Line
63 COUNTING_EVENT_ID Number(15,0) DECIMAL(15) NOT NULL Counting Event ID
64 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

Default Value: N

65 JRNL_LN_REF Character(10) VARCHAR2(10) NOT NULL Identifies a document, person, invoice, date, or any other piece of information that is associated with a journal line. It can be manually entered, or be defaulted from an accounting entry definition or from a Journal Generator Template. The journal line reference is optional, but helpful if you need to trace back to the source of the transaction.
66 LINE_DESCR Character(30) VARCHAR2(30) NOT NULL Describes the nature of a journal line. It is defaulted from the description of the Account ChartField or manually entered.
67 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit
68 JOURNAL_ID Character(10) VARCHAR2(10) NOT NULL Identifies a journal entry, consisting of a header and one or more lines. The Journal ID itself does not have to be unique, but together with the journal business unit and journal date, it forms a unique journal identifier.
69 JOURNAL_DATE Date(10) DATE Specifies the date the journal was created.
70 ACCOUNTING_PERIOD Number(3,0) SMALLINT NOT NULL Identifies a time period to which you post transactions. Typically, an accounting period represents a month, but it can also represent a week, a day, or any user-defined interval. An accounting period has a beginning date and an ending date, and is defined in the calendar table.
71 FISCAL_YEAR Number(4,0) SMALLINT NOT NULL Fiscal Year
72 GL_DISTRIB_STATUS Character(1) VARCHAR2(1) NOT NULL Distribution Status
C=Available to Contracts
D=Distributed
G=Generated
H=Hold
I=Ignored
J=Creating Journals
M=Modified
N=None
P=To be processed
X=Waiting for Reversal
73 PC_DISTRIB_STATUS Character(1) VARCHAR2(1) NOT NULL PC Distribution Status
B=Budget Check
D=Distributed
G=Generated
H=Hold
I=Ignore
M=Modified
N=Not Distributed
S=Staged
74 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
75 COMBO_EDIT_STATUS Character(2) VARCHAR2(2) NOT NULL Combination Edit Status
E=Error
I=Ignore
V=Valid
76 INTRAUNIT_BAL Character(1) VARCHAR2(1) NOT NULL IntraUnit Balance

Default Value: N

77 REQ_REVERSAL_POST Character(1) VARCHAR2(1) NOT NULL Requisition Reversal Posting

Default Value: N

78 LEDGER Character(10) VARCHAR2(10) NOT NULL Ledger
79 LEDGER_GROUP Character(10) VARCHAR2(10) NOT NULL Ledger Group
80 PRDN_AREA_CODE Character(10) VARCHAR2(10) NOT NULL Production Area
81 PRODUCTION_ID Character(10) VARCHAR2(10) NOT NULL Production ID
82 OP_SEQUENCE Number(4,0) SMALLINT NOT NULL Operation Sequence
83 FROM_PRDN_AREA Character(10) VARCHAR2(10) NOT NULL From Production Area
84 FROM_PRDN_ID Character(10) VARCHAR2(10) NOT NULL From Production ID
85 FROM_PRDN_TYPE Character(2) VARCHAR2(2) NOT NULL From Production Type
PR=Production
RW=Rework
SV=Service
TD=Teardown
86 TO_PRDN_AREA Character(10) VARCHAR2(10) NOT NULL To Production Area
87 TO_PRDN_ID Character(10) VARCHAR2(10) NOT NULL To Production ID
88 TO_PRDN_TYPE Character(2) VARCHAR2(2) NOT NULL To Production Type
PR=Production
RW=Rework
SV=Service
TD=Teardown
89 IN_PROCESS_FLG Character(1) VARCHAR2(1) NOT NULL In process flag

Default Value: N

90 INTRAUNIT_REF Number(15,0) DECIMAL(15) NOT NULL IntraUnit Reference Nbr
91 TRANSACTION_SOURCE Character(2) VARCHAR2(2) NOT NULL Transaction Source
92 TRANS_LINE_TYPE Character(3) VARCHAR2(3) NOT NULL Transaction Line Type
0=Regular
1=Interunit Transfer
2=Gain
3=Loss
4=PPV (Favorable)
5=PPV (Unfavorable)
6=ERV (Favorable)
7=ERV (Unfavorable)
8=InterCompany Transfer
93 AP_SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Payables Sequence Number
94 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
95 VARIANCE_SOURCE Character(2) VARCHAR2(2) NOT NULL Variance Source
C=Close
O=Re-Open
R=Report
96 MG_PROC_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
97 CONFIG_CODE Character(50) VARCHAR2(50) NOT NULL Product Configurator
98 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
99 CONTAINER_ID Character(10) VARCHAR2(10) NOT NULL Container ID
100 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
101 SCHED_LINE_NBR Number(6,0) INTEGER NOT NULL Schedule Line Number
102 SHIP_ID Character(10) VARCHAR2(10) NOT NULL Shipping ID
103 DELIVERY_ID Character(10) VARCHAR2(10) NOT NULL Delivery ID
104 CHARGE_TYPE Character(1) VARCHAR2(1) NOT NULL Shipping Charge Type
F=Freight
M=Misc Chrgs
N=Non-stock
105 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
106 JOURNAL_LINE Number(9,0) DECIMAL(9) NOT NULL Uniquely identifies a journal line with a sequence number. Within a single journal entry, the line sequence begins with 1 and automatically increments by 1 for each succeeding journal line. There can be any number of lines associated with a journal header.
107 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
108 DESTIN_BU Character(5) VARCHAR2(5) NOT NULL Destination Unit
109 INV_ITEM_GROUP Character(15) VARCHAR2(15) NOT NULL Item Group
110 DEBIT_CREDIT Character(2) VARCHAR2(2) NOT NULL Debit / Credit Indicator
CR=Credit
DR=Debit
111 COMBO_VALID_FLG Character(1) VARCHAR2(1) NOT NULL ChartField Combinatn Valid Flg
?=Validation in Progress
V=Valid ChartField Combination
X=Invalid ChartField Combo
112 BUDGET_HDR_STATUS Character(1) VARCHAR2(1) NOT NULL Budget Checking Header Status
E=Error in Budget Check
I=Document In Processing
N=Not Budget Checked
P=Provisionally Valid
V=Valid
113 BUDGET_LINE_STATUS Character(1) VARCHAR2(1) NOT NULL -> SL - 15-AUG-2002 MISC_CRITERIA label has been added <-
B=Bypass
E=Error
N=Not Chk'd
V=Valid
W=Warning
114 BUDGET_DT Date(10) DATE Budget Date
115 CM_SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number
116 CM_DT_TIMESTAMP DateTime(26) TIMESTAMP Receipt dttm.
117 CM_DT_TIMESTAMP_A DateTime(26) TIMESTAMP 07/99 GMG CN800-9.0: Original putaway dttm when bin-to-bin'd.
118 CM_SEQ_NBR_A Number(15,0) DECIMAL(15) NOT NULL 07/99 GMG CN800-9.0:
119 CM_SEQ_COST Number(15,0) DECIMAL(15) NOT NULL Cost Sequence Number. Incremented each time the actual cost is updated.
120 TRANS_DATE Date(10) DATE Transaction Date
121 TRANS_TIME Time(15) TIMESTAMP Transaction Time
122 KK_AMOUNT_TYPE Character(1) VARCHAR2(1) NOT NULL Commitment Control Amount Type
0=Budget
1=Actuals and Recognized
2=Encumbrance
3=Pre-Encumbrance
4=Collected Revenue
5=Planned
7=Actuals, Recognize and Collect
9=Dynamic
123 KK_TRAN_OVER_DTTM DateTime(26) TIMESTAMP Commitment Control source transaction override datetime
124 KK_TRAN_OVER_FLAG Character(1) VARCHAR2(1) NOT NULL Commitment Control source transaction override flag
N=No
Y=Yes
125 KK_TRAN_OVER_OPRID Character(30) VARCHAR2(30) NOT NULL Commitment Control source transaction override operator
126 CM_RULE Number(2,0) SMALLINT NOT NULL Accounting Rule Number
127 IU_ANCHOR_FLG Character(1) VARCHAR2(1) NOT NULL Y/N flag used to specify which transaction line is the Inter/IntraUnit anchor flag (the line that contains the anchor Business Unit and ChartFields).
128 IU_SYS_TRAN_CD Character(8) VARCHAR2(8) NOT NULL System Transactions are delivered system data, representing the activities that can require interunit or intraunit accounting entries.
129 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.
130 CM_IU_STATUS Character(1) VARCHAR2(1) NOT NULL IntraUnit Status
B=Balanced
E=Error
H=Hold for other BU's affiliates
I=Ignore
N=Not Balanced
P=In Process
S=Staged
X=Balancing Not Required
131 CM_IU_INDICATOR Character(1) VARCHAR2(1) NOT NULL IU Balancing Entry
132 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
133 IU_ENTRY_TYPE Character(4) VARCHAR2(4) NOT NULL Entry Type
AEAP=IntraEntity Accrued Payable
AECG=IntraEntity Cost of Goods
AECS=IntraEntity Customer Shipments
AEEX=IntraEntity Expense
AEPY=IntraEntity Payable
AERC=IntraEntity Receivable
AERV=IntraEntity Revenue
AETR=IntraEntity In Transit
AUEX=IntraUnit Expense
AUPY=IntraUnit Payable
AURC=IntraUnit Receivable
AURV=IntraUnit Revenue
AUTR=IntraUnit In Transit
IEAP=InterEntity Accrued Payable
IECG=InterEntity Cost of Goods
IECS=InterEntity Customer Shipments
IEEX=InterEntity Expense
IEPY=InterEntity Payable
IERC=InterEntity Receivable
IERV=InterEntity Revenue
IETR=InterEntity In Transit
IUAP=InterUnit Accrued Payable
IUCG=InterUnit Cost of Goods
IUCS=InterUnit Customer Shipments
IUEX=InterUnit Expense
IUPY=InterUnit Payable
IURC=InterUnit Receivable
IURV=InterUnit Revenue
IUTR=InterUnit In Transit
134 CM_IU_SEQ_FIELD Number(15,0) DECIMAL(15) NOT NULL CM IntraUnit Sequence Field
135 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
136 CE_RESOURCE Character(18) VARCHAR2(18) NOT NULL Resource
137 CE_SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number
138 CE_CODE Character(4) VARCHAR2(4) NOT NULL Conversion Code
139 KK_PROCESS_PRIOR Character(1) VARCHAR2(1) NOT NULL Process Prior Document
140 POSTED_DATE Date(10) DATE Specifies the date that a journal entry is posted. This field is maintained by the posting program of PeopleSoft General Ledger.

Default Value: %date