CM_ACT_CST_TEO1

(SQL Table)
Index Back

CCU TEO temp table

CCU temporary table for CM_ACTUAL_COST

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EO_PROCESS_INST Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
3 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
4 DT_TIMESTAMP DateTime(26) TIMESTAMP Date Timestamp
5 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number
6 COST_ELEMENT Character(4) VARCHAR2(4) NOT NULL Cost Element
7 CM_SEQ_COST Number(15,0) DECIMAL(15) NOT NULL Cost Sequence Number. Incremented each time the actual cost is updated.
8 BUSINESS_UNIT_RECV Character(5) VARCHAR2(5) NOT NULL Receiving Business Unit
9 RECEIVER_ID Character(10) VARCHAR2(10) NOT NULL Receiver number
10 RECV_LN_NBR Number(5,0) INTEGER NOT NULL Receipt Line
11 RECV_SHIP_SEQ_NBR Number(3,0) SMALLINT NOT NULL Receiver Shipping Sequence
12 DISTRIB_LINE_NUM Number(5,0) INTEGER NOT NULL Distribution Line
13 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive
14 CM_DTTM_IN_EFFECT DateTime(26) TIMESTAMP Date Timestamp
15 CM_DTTM_STAMP DateTime(26) TIMESTAMP Date Timestamp
16 CM_ADJ_TYPE Character(1) VARCHAR2(1) NOT NULL 07/99 GMG CN800-9.0:
0=Original Cost
1=Cost Adjustment
2=Value Adjustment
17 CM_COST_SOURCE Character(1) VARCHAR2(1) NOT NULL 12/29/2005 dbe ICE 1379942000 - Added "U" Xlat.
0=Depletion
1=PO Receipt
2=Expr Ptway
3=IUTransfer
4=AP Matched
5=User Adj
6=Qty Adjs.
7=Bin to Bin
8=Prelim Cst
9=Prdn Compl
C=NegQty
R=Return
S=Split from
U=75 Upgrade
18 CM_UNIT_COST Signed Number(27,15) DECIMAL(25,15) NOT NULL 07/99 GMG CN800-9.0:
19 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
20 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
21 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

Default Value: N

22 EO_FROM_CURRENCY Character(3) VARCHAR2(3) NOT NULL Currency Code