CM_COST_ADJB_VW

(SQL View)
 Index Back

View for CMS1000.sqr

12/09/02 - ST View for CMS1000.sqr

SELECT A.BUSINESS_UNIT , A.INV_ITEM_ID , A.DT_TIMESTAMP , A.SEQ_NBR , B.COST_ELEMENT , B.CM_BOOK , B.ADJ_COST , B.OLD_COST , A.ADJ_CODE , A.NEW_COST , A.DISTRIB_TYPE , A.OPRID , A.POSTED_FLAG , A.ORIG_DT_TIMESTAMP , A.ORIG_SEQ_NBR , A.TRANS_LINE_TYPE , A.AP_SEQ_NBR , A.WRITE_OFF_TYPE , A.REASON_CD , A.QTY_BASE , A.UNIT_MEASURE_STD , A.STORAGE_AREA , C.DESCR FROM PS_CM_COST_ADJ A , PS_CM_COST_ADJB B , PS_MASTER_ITEM_TBL C , PS_SET_CNTRL_REC D WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.BUSINESS_UNIT = D.SETCNTRLVALUE AND D.RECNAME = 'MASTER_ITEM_TBL' AND C.SETID = D.SETID AND A. INV_ITEM_ID = B.INV_ITEM_ID AND A. INV_ITEM_ID = C.INV_ITEM_ID AND A.DT_TIMESTAMP = B.DT_TIMESTAMP AND A.SEQ_NBR = B.SEQ_NBR AND A.COST_ELEMENT = B.COST_ELEMENT

# 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

Prompt Table: MST_ITM_PRPT_VW

3 DT_TIMESTAMP DateTime(26) TIMESTAMP NOT NULL Date Timestamp
4 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number
5 COST_ELEMENT Character(4) VARCHAR2(4) NOT NULL Cost Element
6 CM_BOOK Character(10) VARCHAR2(10) NOT NULL Cost Book
7 ADJ_COST Signed Number(16,4) DECIMAL(14,4) NOT NULL Adjustment
8 OLD_COST Signed Number(16,4) DECIMAL(14,4) NOT NULL 05/04 tw R158364/I701529003 Allow adjustment to negative averages
9 ADJ_CODE Character(1) VARCHAR2(1) NOT NULL Adjustment Method
D=Cost Adj - Decrease
I=Cost Adj - Increase
N=Cost Adj - New Cost
P=PPV Update
W=Write Off

Default Value: I

10 NEW_COST Signed Number(16,4) DECIMAL(14,4) NOT NULL 05/04 tw R158364/I701529003 Allow adjustment to negative averages
11 DISTRIB_TYPE Character(10) VARCHAR2(10) NOT NULL Distrib. Type
12 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
13 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

Y/N Table Edit

Default Value: N

14 ORIG_DT_TIMESTAMP DateTime(26) TIMESTAMP Orig Date Timestamp
15 ORIG_SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Original Sequence Number
16 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
17 AP_SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Payables Sequence Number
18 WRITE_OFF_TYPE Character(1) VARCHAR2(1) NOT NULL Write Off Type
1=PPV Quantity too large
2=Negative cost calculated
3=Zero Inventory Quantity
4=Qty negative at Putaway
5=Qty negative at Depletion
19 REASON_CD Character(10) VARCHAR2(10) NOT NULL Reason Code

Prompt Table: CM_COST_ADJ_VW

20 QTY_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Base Quantity
21 UNIT_MEASURE_STD Character(3) VARCHAR2(3) NOT NULL Standard Unit of Measure
22 STORAGE_AREA Character(5) VARCHAR2(5) NOT NULL Storage Area
23 DESCR Character(30) VARCHAR2(30) NOT NULL Description