CM_USER_CST_TMP

(SQL Table)
 Index Back

Cost-Only Adjustment Wrk Rec

Work record for the Cost-Only Adjustments panel KDN CM800-7.1: Added ALTACCT field. EJ CM800-4.0: Item Attributes at BU changed peoplecode on INV_ITEM_ID.FieldEdit

# 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 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_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number
8 CM_UNIT_COST Signed Number(27,15) DECIMAL(25,15) NOT NULL 07/99 GMG CN800-9.0:
9 CM_UNIT_COST_OLD Number(26,15) DECIMAL(25,15) NOT NULL 07/99 GMG CN800-9.0:
10 CM_ADJ_TYPE Character(1) VARCHAR2(1) NOT NULL 07/99 GMG CN800-9.0:
0=Original Cost
1=Cost Adjustment
2=Value Adjustment
11 DISTRIB_TYPE Character(10) VARCHAR2(10) NOT NULL Distrib. Type
12 REASON_CD Character(10) VARCHAR2(10) NOT NULL Reason Code
13 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
14 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
15 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive
16 CM_DTTM_IN_EFFECT DateTime(26) TIMESTAMP Date Timestamp
17 CM_DTTM_STAMP DateTime(26) TIMESTAMP Date Timestamp
18 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).