CM_APGL_VW

(SQL View)
 Index Back

CM/AP Summation AP lines

This record will sum all the costing entries in the CM_GLRECN_TBL to the receiver line.

SELECT a.run_cntl_id , a.request_id , a.business_unit_ap , a.voucher_id , a.voucher_line_num , a.distrib_line_num , b.business_unit , b.voucher_style , b.invoice_id , b.vendor_setid , a.business_unit_recv , a.receiver_id , a.recv_ln_nbr , a.recv_ship_seq_nbr , a.business_unit_gl , a.account , a.altacct , A.DEPTID , %subrec(cf16_an_sbr, a) , %subrec(PC_CF1_N_sbr, a) , a.monetary_amount , a.currency_cd , a.monetary_amount , a.vendor_id , a.inv_item_id FROM ps_cm_aprecn_tbl2 a , PS_VOUCHER b WHERE a.source = 'AP' AND a.cm_ap_error_ok = 'N' AND a.business_unit_ap = b.business_unit AND a.voucher_id = b.voucher_id AND NOT EXISTS ( SELECT 'X' FROM ps_cm_aprecn_tbl c WHERE c.run_cntl_id = a.run_cntl_id AND c.request_id = a.request_id AND c.receiver_id = a.receiver_id AND c.recv_ln_nbr = a.recv_ln_nbr AND c.recv_ship_seq_nbr = a.recv_ship_seq_nbr AND c.distrib_line_num = a.distrib_line_num)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
2 REQUEST_ID Character(10) VARCHAR2(10) NOT NULL Request ID

Prompt Table: APGL_RECN_TBL

3 BUSINESS_UNIT_AP Character(5) VARCHAR2(5) NOT NULL AP Business Unit
4 VOUCHER_ID Character(8) VARCHAR2(8) NOT NULL Voucher ID
5 VOUCHER_LINE_NUM Number(5,0) INTEGER NOT NULL Voucher Line Number
6 DISTRIB_LINE_NUM Number(5,0) INTEGER NOT NULL Distribution Line
7 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT

Prompt Table: BUS_UNIT_TBL_AP

8 VOUCHER_STYLE Character(4) VARCHAR2(4) NOT NULL Voucher Style
ADJ=Adjustments
AMR=Amortization Voucher
CLBK=Claim Voucher
CORR=Reversal Voucher
JRNL=Journal Voucher
PPAY=Prepaid Voucher
REG=Regular Voucher
RGTR=Register Voucher
SGLP=Single Payment Voucher
THRD=Third Party Voucher
TMPL=Template Voucher
9 INVOICE_ID Character(30) VARCHAR2(30) NOT NULL Invoice Number
10 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID

Default Value: VENDOR.SETID

11 BUSINESS_UNIT_RECV Character(5) VARCHAR2(5) NOT NULL Receiving Business Unit
12 RECEIVER_ID Character(10) VARCHAR2(10) NOT NULL Receiver number
13 RECV_LN_NBR Number(5,0) INTEGER NOT NULL Receipt Line
14 RECV_SHIP_SEQ_NBR Number(3,0) SMALLINT NOT NULL Receiver Shipping Sequence
15 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit

Prompt Table: SP_BUPRCR_NONVW

16 ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account
17 ALTACCT Character(10) VARCHAR2(10) NOT NULL Alternate Account
18 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

Prompt Table: DEPTID_BUGL_VW

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

Prompt Table: OPERUNT_BUGL_VW

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

Prompt Table: PRODUCT_BUGL_VW

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

Prompt Table: FUND_BUGL_VW

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

Prompt Table: CLASSCF_BUGL_VW

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

Prompt Table: PROGRAM_BUGL_VW

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

Prompt Table: BUD_REF_BUGL_VW

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

Prompt Table: AFFILIATE_VW

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

Prompt Table: %EDIT_INTRA01

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

Prompt Table: %EDIT_INTRA02

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

Prompt Table: CF1_BUGL_VW

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

Prompt Table: CF2_BUGL_VW

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

Prompt Table: CF3_BUGL_VW

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

Prompt Table: %EDIT_BU_PC

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

Prompt Table: %EDIT_PROJECT

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

Prompt Table: %EDIT_ACTIVITY

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

Prompt Table: PROJ_RESTYPE_FS
Set Control Field: BUSINESS_UNIT_PC

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

Prompt Table: %EDIT_RES_CAT
Set Control Field: BUSINESS_UNIT_PC

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

Prompt Table: %EDIT_RES_SUB
Set Control Field: BUSINESS_UNIT_PC

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

Prompt Table: %EDIT_ANALYSIS
Set Control Field: BUSINESS_UNIT_PC

38 MONETARY_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Specifies the monetary amount of a debit or credit in the business unit base currency. Debit entries are positive and credit entries are negative. This amount is only zero if associated with a statistical account.
39 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
40 DIFFERENCE_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Difference Amount
41 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
42 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID