AP_EXT_HDR_VW

(SQL View)

SELECT DISTINCT A.SETID , A.VENDOR_ID , A.INVOICE_ID , A.EXTRACT_TYPE_HDR , A.PAYMENT_DT , A.INVOICE_DT , B.COMPANY , B.PAYGROUP , B.PAY_END_DT FROM PS_AP_EXTRACT_HDR A , PS_AP_EXTRACT_LINE B WHERE A.SETID = B.SETID AND A.VENDOR_ID = B.VENDOR_ID AND A.INVOICE_ID = B.INVOICE_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

2 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier

3 INVOICE_ID Character(22) VARCHAR2(22) NOT NULL Invoice Number

4 EXTRACT_TYPE_HDR Character(1) VARCHAR2(1) NOT NULL Extract Type
N=Non-Tax
T=Tax

5 PAYMENT_DT Date(10) DATE Payment Date

6 INVOICE_DT Date(10) DATE Invoice Date

7 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

8 PAYGROUP Character(3) VARCHAR2(3) NOT NULL Pay Group

9 PAY_END_DT Date(10) DATE Pay Period End Date

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
2	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier
3	INVOICE_ID	Character(22)	VARCHAR2(22) NOT NULL	Invoice Number
4	EXTRACT_TYPE_HDR	Character(1)	VARCHAR2(1) NOT NULL	Extract Type N=Non-Tax T=Tax
5	PAYMENT_DT	Date(10)	DATE	Payment Date
6	INVOICE_DT	Date(10)	DATE	Invoice Date
7	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company
8	PAYGROUP	Character(3)	VARCHAR2(3) NOT NULL	Pay Group
9	PAY_END_DT	Date(10)	DATE	Pay Period End Date