CM_CST_PRJRC_VW

(SQL View)
 Index Back

Costed Project Receipt View

CN# CM750-10.0 PSG 11/10/97 - multiply PxQ in COBOL instead of the view to aviod error when there are too many decimals.

select a.business_unit, a.inv_item_id, a.dt_timestamp, a.seq_nbr, b.cost_element, b.trans_line_type, b.ap_seq_nbr, a.storage_area, a.business_unit_pc, a.activity_id, a.qty_base, (b.tl_cost + b.ll_cost), a.unit_measure_std, a.distrib_type, b.posted_flag, b.process_instance from PS_TRANSACTION_INV a, ps_cost_inv b where a.business_unit = b.business_unit and a.inv_item_id = b.inv_item_id and a.dt_timestamp = b.dt_timestamp and a.seq_nbr = b.seq_nbr and b.posted_flag = 'N' and b.trans_line_type = '0' and a.transaction_group = '023'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID

Prompt Table: MST_ITM_PRPT_VW

3 DT_TIMESTAMP DateTime(26) TIMESTAMP 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 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
7 AP_SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Payables Sequence Number
8 STORAGE_AREA Character(5) VARCHAR2(5) NOT NULL Storage Area
9 BUSINESS_UNIT_PC Character(5) VARCHAR2(5) NOT NULL PC Business Unit
10 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID
11 QTY_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Base Quantity
12 TOTAL_COST Signed Number(16,4) DECIMAL(14,4) NOT NULL Total Cost
13 UNIT_MEASURE_STD Character(3) VARCHAR2(3) NOT NULL Standard Unit of Measure
14 DISTRIB_TYPE Character(10) VARCHAR2(10) NOT NULL Distrib. Type

Prompt Table: CM_DISTR_TYPE

15 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
16 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance