TD_CLAIMS_PY_VW (SQL View)	Index Back
View Claims entered for Promo

TD_CLAIMS_PY_VW

(SQL View)

View Claims entered for Promo

SELECT A.SETID , A.PPRC_PROMO_CD , A.CUST_ID , A.MERCH_TYPE , A.CLAIM_ID , A.PAYMENT_METHOD_PL , A.TD_STATUS , A.REFERENCE_NUM , A.CURRENCY_CD , A.BASE_CURRENCY , A.RT_TYPE , A.RATE_MULT , A.RATE_DIV , A.AMOUNT , A.AMOUNT_BSE , C.MERCHANDISE_AMT , A.PAID_AMT_BSE , A.BUSINESS_UNIT , A.BUSINESS_UNIT_BI , A.BUSINESS_UNIT_GL , A.BUSINESS_UNIT_AP , A.VENDOR_SETID , A.VENDOR_ID , B.VOUCHER_ID , A.VOUCHER_LINE_NUM , A.ENTERED_DT , ' ' , A.CUST_ID2 FROM PS_TD_CLAIMS_PAY A , PS_TD_CLAIMS_HDR B , PS_VOUCHER_LINE C WHERE A.SETID = B.SETID AND A.CUST_ID = B.CUST_ID AND A.CLAIM_ID = B.CLAIM_ID AND A.BUSINESS_UNIT_AP = C.BUSINESS_UNIT AND B.VOUCHER_ID = C.VOUCHER_ID AND A.VOUCHER_LINE_NUM = C.VOUCHER_LINE_NUM

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
Default Value: TD_PAYMENT_TBL.SETID
Prompt Table: SP_SETID_NONVW

2 PPRC_PROMO_CD Character(20) VARCHAR2(20) NOT NULL Price Promotion Code
Default Value: TD_PAYMENT_TBL.PPRC_PROMO_CD
Prompt Table: PPRC_PROMO_TBL

3 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.
Default Value: TD_PAYMENT_TBL.CUST_ID
Prompt Table: %EDITTABLE

4 MERCH_TYPE Character(10) VARCHAR2(10) NOT NULL Merchandising Type
Default Value: TD_PAYMENT_TBL.MERCH_TYPE
Prompt Table: TD_PROM_MRCH_VW

5 CLAIM_ID Character(15) VARCHAR2(15) NOT NULL Claim ID
Default Value: NEXT
Prompt Table: TD_CLAIM_AUT_VW

6 PAYMENT_METHOD_PL Character(1) VARCHAR2(1) NOT NULL Planned Payment Method
1=Deduction
2=Check
3=Field Draft
4=Credit Memo
6=Chargeback
Default Value: TD_PRO_MERC_CUS.PAYMENT_METHOD_PL

7 TD_STATUS Character(1) VARCHAR2(1) NOT NULL Status
A=Approved
I=Initial
P=Pending
R=Rejected
Default Value: I

8 REFERENCE_NUM Character(30) VARCHAR2(30) NOT NULL Reference

9 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
Default Value: TD_PAYMENT_TBL.CURRENCY_CD
Prompt Table: CURRENCY_CD_TBL

10 BASE_CURRENCY Character(3) VARCHAR2(3) NOT NULL "Specifies the primary currency for a general ledger business unit, and is sometimes referred to as the ""book"" currency. Each business unit has one base currency. which is usually, but not always, the local currency for the organization. Journal entries are posted to a business unit in its base currency. "
Default Value: TD_SETID_TBL.BASE_CURRENCY
Prompt Table: CURRENCY_CD_TBL

11 RT_TYPE Character(5) VARCHAR2(5) NOT NULL Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.
Default Value: TD_PAYMENT_TBL.RT_TYPE

12 RATE_MULT Signed Number(17,8) DECIMAL(15,8) NOT NULL Rate Multiplier
Default Value: TD_PAYMENT_TBL.RATE_MULT

13 RATE_DIV Number(16,8) DECIMAL(15,8) NOT NULL Rate Divisor
Default Value: TD_PAYMENT_TBL.RATE_DIV

14 AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount

15 AMOUNT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount

16 PAID_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Paid Amount

17 PAID_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Base Paid Amount

18 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Prompt Table: SP_BU_TD_NONVW

19 BUSINESS_UNIT_BI Character(5) VARCHAR2(5) NOT NULL Billing Business Unit
Default Value: BUS_UNIT_TBL_OM.BUSINESS_UNIT_BI
Prompt Table: BUS_UNIT_TBL_BI

20 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit

21 BUSINESS_UNIT_AP Character(5) VARCHAR2(5) NOT NULL AP Business Unit
Default Value: TD_CLAIMS_PAY.BUSINESS_UNIT
Prompt Table: BUS_UNIT_TBL_AP

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 VOUCHER_ID Character(8) VARCHAR2(8) NOT NULL Voucher ID

25 VOUCHER_LINE_NUM Number(5,0) INTEGER NOT NULL Voucher Line Number

26 ENTERED_DT Date(10) DATE Entered on

27 FLAG4 Character(1) VARCHAR2(1) NOT NULL Flag4

28 CUST_ID2 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.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Default Value: TD_PAYMENT_TBL.SETID Prompt Table: SP_SETID_NONVW
2	PPRC_PROMO_CD	Character(20)	VARCHAR2(20) NOT NULL	Price Promotion Code Default Value: TD_PAYMENT_TBL.PPRC_PROMO_CD Prompt Table: PPRC_PROMO_TBL
3	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. Default Value: TD_PAYMENT_TBL.CUST_ID Prompt Table: %EDITTABLE
4	MERCH_TYPE	Character(10)	VARCHAR2(10) NOT NULL	Merchandising Type Default Value: TD_PAYMENT_TBL.MERCH_TYPE Prompt Table: TD_PROM_MRCH_VW
5	CLAIM_ID	Character(15)	VARCHAR2(15) NOT NULL	Claim ID Default Value: NEXT Prompt Table: TD_CLAIM_AUT_VW
6	PAYMENT_METHOD_PL	Character(1)	VARCHAR2(1) NOT NULL	Planned Payment Method 1=Deduction 2=Check 3=Field Draft 4=Credit Memo 6=Chargeback Default Value: TD_PRO_MERC_CUS.PAYMENT_METHOD_PL
7	TD_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Status A=Approved I=Initial P=Pending R=Rejected Default Value: I
8	REFERENCE_NUM	Character(30)	VARCHAR2(30) NOT NULL	Reference
9	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Default Value: TD_PAYMENT_TBL.CURRENCY_CD Prompt Table: CURRENCY_CD_TBL
10	BASE_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	"Specifies the primary currency for a general ledger business unit, and is sometimes referred to as the ""book"" currency. Each business unit has one base currency. which is usually, but not always, the local currency for the organization. Journal entries are posted to a business unit in its base currency. " Default Value: TD_SETID_TBL.BASE_CURRENCY Prompt Table: CURRENCY_CD_TBL
11	RT_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical. Default Value: TD_PAYMENT_TBL.RT_TYPE
12	RATE_MULT	Signed Number(17,8)	DECIMAL(15,8) NOT NULL	Rate Multiplier Default Value: TD_PAYMENT_TBL.RATE_MULT
13	RATE_DIV	Number(16,8)	DECIMAL(15,8) NOT NULL	Rate Divisor Default Value: TD_PAYMENT_TBL.RATE_DIV
14	AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Amount
15	AMOUNT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Amount
16	PAID_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Paid Amount
17	PAID_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Base Paid Amount
18	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: SP_BU_TD_NONVW
19	BUSINESS_UNIT_BI	Character(5)	VARCHAR2(5) NOT NULL	Billing Business Unit Default Value: BUS_UNIT_TBL_OM.BUSINESS_UNIT_BI Prompt Table: BUS_UNIT_TBL_BI
20	BUSINESS_UNIT_GL	Character(5)	VARCHAR2(5) NOT NULL	GL Business Unit
21	BUSINESS_UNIT_AP	Character(5)	VARCHAR2(5) NOT NULL	AP Business Unit Default Value: TD_CLAIMS_PAY.BUSINESS_UNIT Prompt Table: BUS_UNIT_TBL_AP
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	VOUCHER_ID	Character(8)	VARCHAR2(8) NOT NULL	Voucher ID
25	VOUCHER_LINE_NUM	Number(5,0)	INTEGER NOT NULL	Voucher Line Number
26	ENTERED_DT	Date(10)	DATE	Entered on
27	FLAG4	Character(1)	VARCHAR2(1) NOT NULL	Flag4
28	CUST_ID2	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.