AP_DCM_VCHR_PY (SQL View)	Index Back
Imaging Invoice Lines Imaging Invoice Lines

AP_DCM_VCHR_PY

(SQL View)

Imaging Invoice Lines

SELECT A.BUSINESS_UNIT %Concat '.' %Concat A.VOUCHER_ID , A.BUSINESS_UNIT , A.VOUCHER_ID , C.PYMNT_CNT , C.PYMNT_SELCT_STATUS , C.PYMNT_GROSS_AMT , C.TXN_CURRENCY_CD , C.PYMNT_MESSAGE , C.PYMNT_METHOD , C.DUE_DT , C.DSCNT_DUE_DT , C.SCHEDULED_PAY_DT , C.DSCNT_PAY_AMT , C.PAID_AMT , C.CURRENCY_PYMNT , C.PYMNT_ID FROM PS_VOUCHER A , PS_AP_DM_BU D , PS_PYMNT_VCHR_XREF C WHERE A.VCHR_SRC = 'DCM' AND A.BUSINESS_UNIT = D.BUSINESS_UNIT AND A.BUSINESS_UNIT = C.BUSINESS_UNIT AND A.VOUCHER_ID = C.VOUCHER_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 DCM_VCHR_KEY Character(14) VARCHAR2(14) NOT NULL Voucher Id Key

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

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

4 PYMNT_CNT Number(5,0) INTEGER NOT NULL Payments

5 PYMNT_SELCT_STATUS Character(1) VARCHAR2(1) NOT NULL Payment Selection Status
C=Closed
D=Negative Voucher Sum
E=Externally Paid
F=Federal Sanctions Error
I=In Process - EFT
N=Not Selected for Payment
O=Financial Sanctions Review
P=Paid
R=Requested for Payment
S=Settlement Payment
V=Convert Error
X=Canceled
Y=Prepaid
Default Value: N

6 PYMNT_GROSS_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Gross Payment Amount

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

8 PYMNT_MESSAGE Character(70) VARCHAR2(70) NOT NULL Payment Message

9 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
Prompt Table: BNK_PYMTHD_VW1

10 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.

11 DSCNT_DUE_DT Date(10) DATE Discount Due Date

12 SCHEDULED_PAY_DT Date(10) DATE Scheduled to Pay

13 DSCNT_PAY_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Payment Discount Amount

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

15 CURRENCY_PYMNT Character(3) VARCHAR2(3) NOT NULL Payment Currency
Prompt Table: BANK_CURR_AP_VW

16 PYMNT_ID Character(10) VARCHAR2(10) NOT NULL Payment Number

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	DCM_VCHR_KEY	Character(14)	VARCHAR2(14) NOT NULL	Voucher Id Key
2	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
3	VOUCHER_ID	Character(8)	VARCHAR2(8) NOT NULL	Voucher ID
4	PYMNT_CNT	Number(5,0)	INTEGER NOT NULL	Payments
5	PYMNT_SELCT_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Payment Selection Status C=Closed D=Negative Voucher Sum E=Externally Paid F=Federal Sanctions Error I=In Process - EFT N=Not Selected for Payment O=Financial Sanctions Review P=Paid R=Requested for Payment S=Settlement Payment V=Convert Error X=Canceled Y=Prepaid Default Value: N
6	PYMNT_GROSS_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Gross Payment Amount
7	TXN_CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Transaction Currency
8	PYMNT_MESSAGE	Character(70)	VARCHAR2(70) NOT NULL	Payment Message
9	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 Prompt Table: BNK_PYMTHD_VW1
10	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.
11	DSCNT_DUE_DT	Date(10)	DATE	Discount Due Date
12	SCHEDULED_PAY_DT	Date(10)	DATE	Scheduled to Pay
13	DSCNT_PAY_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Payment Discount Amount
14	PAID_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Paid Amount
15	CURRENCY_PYMNT	Character(3)	VARCHAR2(3) NOT NULL	Payment Currency Prompt Table: BANK_CURR_AP_VW
16	PYMNT_ID	Character(10)	VARCHAR2(10) NOT NULL	Payment Number