CM_CST_PRJIS_VW

(SQL View)
 Index Back

Costed Trans - PRJ Issue 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. CN# CM750-10.0 PSG 11/21/97: add projects fields. KDN CM800-7.1: Added ALTACCT field.

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.qty_base , (b.tl_cost + b.ll_cost) , a.account , a.altacct , A.DEPTID , %subrec(cf16_an_sbr,a) , %subrec(pc_cf1_n_sbr,a) , 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 = '033'

# 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
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 QTY_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Base Quantity
10 TOTAL_COST Signed Number(16,4) DECIMAL(14,4) NOT NULL Total Cost
11 ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account
12 ALTACCT Character(10) VARCHAR2(10) NOT NULL Alternate Account
13 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

Prompt Table: DEPTID_BUGL_VW

14 OPERATING_UNIT Character(8) VARCHAR2(8) NOT NULL Operating Unit ChartField

Prompt Table: OPERUNT_BUGL_VW

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

Prompt Table: PRODUCT_BUGL_VW

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

Prompt Table: FUND_BUGL_VW

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

Prompt Table: CLASSCF_BUGL_VW

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

Prompt Table: PROGRAM_BUGL_VW

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

Prompt Table: BUD_REF_BUGL_VW

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

Prompt Table: AFFILIATE_VW

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

Prompt Table: %EDIT_INTRA01

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

Prompt Table: %EDIT_INTRA02

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

Prompt Table: CF1_BUGL_VW

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

Prompt Table: CF2_BUGL_VW

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

Prompt Table: CF3_BUGL_VW

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

Prompt Table: %EDIT_BU_PC

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

Prompt Table: %EDIT_PROJECT

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

Prompt Table: %EDIT_ACTIVITY

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

Prompt Table: PROJ_RESTYPE_FS
Set Control Field: BUSINESS_UNIT_PC

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

Prompt Table: %EDIT_RES_CAT
Set Control Field: BUSINESS_UNIT_PC

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

Prompt Table: %EDIT_RES_SUB
Set Control Field: BUSINESS_UNIT_PC

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

Prompt Table: %EDIT_ANALYSIS
Set Control Field: BUSINESS_UNIT_PC

33 UNIT_MEASURE_STD Character(3) VARCHAR2(3) NOT NULL Standard Unit of Measure
34 DISTRIB_TYPE Character(10) VARCHAR2(10) NOT NULL Distrib. Type

Prompt Table: CM_DISTR_TYPE

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