TD_CLAIM_HDR_VW

(SQL View)

SELECT SETID , CLAIM_ID , CUST_ID , BUSINESS_UNIT , AMOUNT , CURRENCY_CD , PAYMENT_METHOD_PL FROM PS_TD_CLAIMS_HDR WHERE TD_STATUS = 'A' AND EXPORT_STATUS <> 'C'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
Default Value: OPR_DEF_TBL_FS.SETID

2 CLAIM_ID Character(15) VARCHAR2(15) NOT NULL Claim ID

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.

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

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

6 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

7 PAYMENT_METHOD_PL Character(1) VARCHAR2(1) NOT NULL Planned Payment Method
1=Deduction
2=Check
3=Field Draft
4=Credit Memo
6=Chargeback

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Default Value: OPR_DEF_TBL_FS.SETID
2	CLAIM_ID	Character(15)	VARCHAR2(15) NOT NULL	Claim ID
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.
4	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
5	AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Amount
6	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
7	PAYMENT_METHOD_PL	Character(1)	VARCHAR2(1) NOT NULL	Planned Payment Method 1=Deduction 2=Check 3=Field Draft 4=Credit Memo 6=Chargeback