TD_PRO_CU_PD_VW

(SQL View)
 Index Back

Payments made for cust Promos

Payments made for customer Promotions The following views should always have the same fields TD_PRO_CU_PD_VW TD_PRO_CU_OI_VW TD_PRO_CU_CR_VW TD_PRO_CU_DE_VW

SELECT DISTINCT A.SETID ,A.CUST_ID , A.PPRC_PROMO_CD , A.MERCH_TYPE , C.ACCOUNTING_DT , '2' , A.CLAIM_ID , B.VOUCHER_ID , B.PYMNT_ID_REF , B.INVOICE , 0 , 0 , 0 , ' ' , ' ' , 0 , 0 , 0 , A.AMOUNT , A.CURRENCY_CD , B.BILL_TO_CUST_ID , B.VENDOR_SETID , B.VENDOR_ID , B.VNDR_LOC , B.ADDRESS_SEQ_NUM , B.BUSINESS_UNIT , B.BUSINESS_UNIT_BI , B.BUSINESS_UNIT_GL , B.BUSINESS_UNIT_AP FROM PS_TD_CLAIMS_PAY A , PS_TD_CLAIMS_HDR B , PS_VOUCHER C , PS_TD_PRO_MERFU_CU D , PS_TD_PROMO_CUST E WHERE A.SETID = B.SETID AND A.CUST_ID = B.CUST_ID AND A.CLAIM_ID = B.CLAIM_ID AND (A.PAYMENT_METHOD_PL = '2' OR A.PAYMENT_METHOD_PL = '3') AND B.BUSINESS_UNIT_AP = C.BUSINESS_UNIT AND B.VOUCHER_ID = C.VOUCHER_ID AND A.SETID = D.SETID AND A.PPRC_PROMO_CD = D.PPRC_PROMO_CD AND A.CUST_ID = D.CUST_ID AND D.SETID = E.SETID AND D.PPRC_PROMO_CD = E.PPRC_PROMO_CD AND D.CUST_ID = E.CUST_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

Prompt Table: SP_SETTD_NONVW

2 CUST_ID Character(15) VARCHAR2(15) NOT NULL Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.

Prompt Table: TD_CUST_OPRVW

3 PPRC_PROMO_CD Character(20) VARCHAR2(20) NOT NULL Price Promotion Code

Prompt Table: PPRC_PROMO_TBL

4 MERCH_TYPE Character(10) VARCHAR2(10) NOT NULL Merchandising Type

Prompt Table: TD_MERCH_TYP_VW
Set Control Field: SETID

5 ACCOUNTING_DT Date(10) DATE The accounting entry construction date for a given transaction (a generic field that crosses multiple
6 TD_PAYMENT_TYPE Character(1) VARCHAR2(1) NOT NULL Payment Type
1=Deduction
2=Check
3=Off-Invoice
4=Credit
7 CLAIM_ID Character(15) VARCHAR2(15) NOT NULL Claim ID

Prompt Table: TD_CLAIM_AUT_VW

8 VOUCHER_ID Character(8) VARCHAR2(8) NOT NULL Voucher ID

Prompt Table: TD_VCHR_AUT_VW

9 PYMNT_ID_REF Character(20) VARCHAR2(20) NOT NULL Payment Reference
10 INVOICE Character(22) VARCHAR2(22) NOT NULL Invoice
11 INVOICE_LINE Number(5,0) INTEGER NOT NULL Invoice Line
12 LINE_SEQ_NUM Number(5,0) INTEGER NOT NULL Sequence
13 DISC_SUR_LVL Number(2,0) SMALLINT NOT NULL Discount/Surcharge Level
14 DISC_SUR_ID Character(15) VARCHAR2(15) NOT NULL Identifier

Prompt Table: %EDITTABLE5

15 ITEM Character(30) VARCHAR2(30) NOT NULL Uniquely identifies an invoice credit memo or debit memo. The item ID is also called the invoice number.
16 ITEM_LINE Number(6,0) INTEGER NOT NULL Item Line
17 SPLIT_ID Number(3,0) SMALLINT NOT NULL Suffix Number
18 SEQ_NBR_4 Number(4,0) SMALLINT NOT NULL Sequence Nbr 4
19 AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount
20 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

Prompt Table: CURRENCY_CD_TBL

21 BILL_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Customer

Prompt Table: TD_CUS_BILTO_VW

22 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
23 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier

Prompt Table: VNDR_ACTIVE_VW

24 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location

Prompt Table: VNDR_LOC_AP_VW

25 ADDRESS_SEQ_NUM Number(5,0) INTEGER NOT NULL Address Sequence Number

Prompt Table: VENDOR_ADDR_VW

26 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: SP_BU_TD_NONVW

27 BUSINESS_UNIT_BI Character(5) VARCHAR2(5) NOT NULL Billing Business Unit

Prompt Table: SP_BU_BI_NONVW

28 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit
29 BUSINESS_UNIT_AP Character(5) VARCHAR2(5) NOT NULL AP Business Unit

Prompt Table: SP_BU_AP_NONVW