APOP_VCHRDLP_VW (SQL View)	Index Back
Vchr Late Pymnt Detail VW Voucher Late Payment Detail VW

APOP_VCHRDLP_VW

(SQL View)

Vchr Late Pymnt Detail VW

Voucher Late Payment Detail VW

SELECT A.BUSINESS_UNIT , A.VOUCHER_ID , A.INVOICE_ID , A.INVOICE_DT , A.DUE_DT , A.PYMNT_DT , A.AP_DAYSBETWEEN , A.GROSS_AMT , A.DSCNT_AMT , A.TXN_CURRENCY_CD , A.VENDOR_SETID , A.VENDOR_ID , V.VENDOR_NAME_SHORT , A.PYMNT_ID_REF , A.PYMNT_HANDLING_CD , A.PYMNT_TERMS_CD , A.DISPLAY_ORDER , A.BANK_SETID , A.BANK_CD , A.BANK_ACCT_KEY , A.PYMNT_METHOD FROM %Table(APOD_PYMTLAT_MV) A , %Table(VENDOR) V WHERE V.SETID = A.VENDOR_SETID AND V.VENDOR_ID = A.VENDOR_ID

Related Language Record: APOP_VCHRDLPLVW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

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

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

4 INVOICE_DT Date(10) DATE Invoice Date

5 DUE_DT Date(10) DATE Specifies the date that a transaction is due. It is a generic field used in multiple PeopleSoft applications including Receivables Payables and Purchasing. For example it represents the date that payment is due for a voucher or the date that a scheduled shipment is due to be received.

6 PYMNT_DT Date(10) DATE Payment Date

7 AP_DAYSBETWEEN Number(12,0) DECIMAL(12) NOT NULL Used to keep the difference between 2 dates.

8 GROSS_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Gross Invoice Amount

9 DSCNT_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Discount Amount

10 TXN_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Transaction Currency

11 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID

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

13 VENDOR_NAME_SHORT Character(14) VARCHAR2(14) NOT NULL Short Vendor Name

14 PYMNT_ID_REF Character(20) VARCHAR2(20) NOT NULL Payment Reference

15 PYMNT_HANDLING_CD Character(2) VARCHAR2(2) NOT NULL Payment Handling

16 PYMNT_TERMS_CD Character(5) VARCHAR2(5) NOT NULL Specifies how the payment due date and discount due date are calculated. A payment terms code is associated with various business units bill-to customers vendors as well as sales orders purchase orders and vouchers.

17 DISPLAY_ORDER Number(3,0) SMALLINT NOT NULL Display order for ordering items in a list - web style

18 BANK_SETID Character(5) VARCHAR2(5) NOT NULL The PeopleSoft tableset ID associated with a given bank/counterparty.

19 BANK_CD Character(5) VARCHAR2(5) NOT NULL Bank Code

20 BANK_ACCT_KEY Character(4) VARCHAR2(4) NOT NULL A user defined unique identifier that facilitates the identification of a given account with a given bank

21 PYMNT_METHOD Character(3) VARCHAR2(3) NOT NULL Payment Method
ACH=Automated Clearing House
BEF=Draft - Customer EFT
BOO=Draft - Customer Initiated
CHK=System Check
D=Deposit
DD=Direct Debit
DFT=Draft - Supplier Initiated
DRA=Draft
EFT=Electronic Funds Transfer
GE=Giro - EFT
GM=Giro - Manual
LC=Letter of Credit
MAN=Manual Check
TRW=Treasury Wire
WIR=Wire Transfer

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	VOUCHER_ID	Character(8)	VARCHAR2(8) NOT NULL	Voucher ID
3	INVOICE_ID	Character(30)	VARCHAR2(30) NOT NULL	Invoice Number
4	INVOICE_DT	Date(10)	DATE	Invoice Date
5	DUE_DT	Date(10)	DATE	Specifies the date that a transaction is due. It is a generic field used in multiple PeopleSoft applications including Receivables Payables and Purchasing. For example it represents the date that payment is due for a voucher or the date that a scheduled shipment is due to be received.
6	PYMNT_DT	Date(10)	DATE	Payment Date
7	AP_DAYSBETWEEN	Number(12,0)	DECIMAL(12) NOT NULL	Used to keep the difference between 2 dates.
8	GROSS_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Gross Invoice Amount
9	DSCNT_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Discount Amount
10	TXN_CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Transaction Currency
11	VENDOR_SETID	Character(5)	VARCHAR2(5) NOT NULL	Vendor SetID
12	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier
13	VENDOR_NAME_SHORT	Character(14)	VARCHAR2(14) NOT NULL	Short Vendor Name
14	PYMNT_ID_REF	Character(20)	VARCHAR2(20) NOT NULL	Payment Reference
15	PYMNT_HANDLING_CD	Character(2)	VARCHAR2(2) NOT NULL	Payment Handling
16	PYMNT_TERMS_CD	Character(5)	VARCHAR2(5) NOT NULL	Specifies how the payment due date and discount due date are calculated. A payment terms code is associated with various business units bill-to customers vendors as well as sales orders purchase orders and vouchers.
17	DISPLAY_ORDER	Number(3,0)	SMALLINT NOT NULL	Display order for ordering items in a list - web style
18	BANK_SETID	Character(5)	VARCHAR2(5) NOT NULL	The PeopleSoft tableset ID associated with a given bank/counterparty.
19	BANK_CD	Character(5)	VARCHAR2(5) NOT NULL	Bank Code
20	BANK_ACCT_KEY	Character(4)	VARCHAR2(4) NOT NULL	A user defined unique identifier that facilitates the identification of a given account with a given bank
21	PYMNT_METHOD	Character(3)	VARCHAR2(3) NOT NULL	Payment Method ACH=Automated Clearing House BEF=Draft - Customer EFT BOO=Draft - Customer Initiated CHK=System Check D=Deposit DD=Direct Debit DFT=Draft - Supplier Initiated DRA=Draft EFT=Electronic Funds Transfer GE=Giro - EFT GM=Giro - Manual LC=Letter of Credit MAN=Manual Check TRW=Treasury Wire WIR=Wire Transfer