TD_PRO_CU_OI_VW

(SQL View)
 Index Back

Promos Off-Inv Disc for cust

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 C.SETID , B.SOLD_TO_CUST_ID , D.PPRC_PROMO_CD , D.MERCH_TYPE , A.ACCOUNTING_DT , '3' , ' ' , ' ' , ' ' , B.INVOICE , B.INVOICE_LINE , B.LINE_SEQ_NUM , D.DISC_SUR_LVL , D.DISC_SUR_ID , ' ' , 0 , 0 , 0 , %DecMult(D.AMOUNT, -1) , B.BI_CURRENCY_CD , A.BILL_TO_CUST_ID , ' ' , ' ' , ' ' , 0 , ' ' , B.BUSINESS_UNIT , D.BUSINESS_UNIT_GL , ' ' FROM PS_BI_HDR A , PS_BI_LINE B , PS_SET_CNTRL_REC C , PS_BI_LINE_DS_DTL D , PS_TD_PROMO_CUST E , PS_TD_PRO_MERFU_CU F WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.INVOICE = B.INVOICE AND ( A.INVOICE_TYPE = 'RAD' OR A.INVOICE_TYPE = 'REG') AND B.BUSINESS_UNIT = D.BUSINESS_UNIT AND B.INVOICE = D.INVOICE AND B.LINE_SEQ_NUM = D.LINE_SEQ_NUM AND D.PPRC_PROMO_CD <> ' ' AND A.BILL_STATUS = 'INV' AND C.RECNAME = 'PPRC_PROMO_TBL' AND C.SETCNTRLVALUE = A.BUSINESS_UNIT AND C.SETID = E.SETID AND B.SOLD_TO_CUST_ID = E.CUST_ID AND D.PPRC_PROMO_CD = E.PPRC_PROMO_CD AND F.SETID = E.SETID AND F.CUST_ID = F.CUST_ID AND D.MERCH_TYPE = F.MERCH_TYPE AND F.PPRC_PROMO_CD = E.PPRC_PROMO_CD

# 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