APD_APPROVE_VW4 (SQL View)	Index Back
DraftApprovalPanelDraftID SPD Detail Line

APD_APPROVE_VW4

(SQL View)

DraftApprovalPanelDraftID SPD

Detail Line

SELECT PAY_CYCLE ,PAY_CYCLE_SEQ_NUM ,BANK_SETID ,DFT_MASTER_ID ,DFT_XREF_INCL_FLG ,DFT_CREATE_KEY ,SUM(PAID_AMT) ,DFT_MASTER_STATUS ,PYMNT_METHOD_ALT ,DUE_DT ,0 ,CURRENCY_PYMNT FROM PS_APD_DRAFT_STG GROUP BY PAY_CYCLE ,PAY_CYCLE_SEQ_NUM ,BANK_SETID ,DFT_MASTER_ID ,DFT_XREF_INCL_FLG ,DFT_CREATE_KEY ,DFT_MASTER_STATUS ,PYMNT_METHOD_ALT ,DUE_DT ,CURRENCY_PYMNT

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PAY_CYCLE Character(6) VARCHAR2(6) NOT NULL Pay Cycle

2 PAY_CYCLE_SEQ_NUM Number(6,0) INTEGER NOT NULL Pay Cycle Sequence Number

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

4 DFT_MASTER_ID Character(10) VARCHAR2(10) NOT NULL Draft Master ID

5 DFT_XREF_INCL_FLG Character(1) VARCHAR2(1) NOT NULL Used during Pay Cycle to include or exclude Drafts from Pay Cycle based after Draft rounding
E=Xref Excluded
I=Xref Included

6 DFT_CREATE_KEY Character(10) VARCHAR2(10) NOT NULL Draft Create Key

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

8 DFT_MASTER_STATUS Character(1) VARCHAR2(1) NOT NULL Draft Master Status
A=Approved
N=Not Apprv
R=Rejected

9 PYMNT_METHOD_ALT Character(3) VARCHAR2(3) NOT NULL Payment Method
ACH=Automated Clearing House
CHK=System Check
DD=Direct Debit
EFT=Electronic Funds Transfer
GE=Giro - EFT
GM=Giro - Manual
LC=Letter of Credit
MAN=Manual Check
WIR=Wire Report

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 AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount

12 CURRENCY_PYMNT Character(3) VARCHAR2(3) NOT NULL Payment Currency

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PAY_CYCLE	Character(6)	VARCHAR2(6) NOT NULL	Pay Cycle
2	PAY_CYCLE_SEQ_NUM	Number(6,0)	INTEGER NOT NULL	Pay Cycle Sequence Number
3	BANK_SETID	Character(5)	VARCHAR2(5) NOT NULL	The PeopleSoft tableset ID associated with a given bank/counterparty.
4	DFT_MASTER_ID	Character(10)	VARCHAR2(10) NOT NULL	Draft Master ID
5	DFT_XREF_INCL_FLG	Character(1)	VARCHAR2(1) NOT NULL	Used during Pay Cycle to include or exclude Drafts from Pay Cycle based after Draft rounding E=Xref Excluded I=Xref Included
6	DFT_CREATE_KEY	Character(10)	VARCHAR2(10) NOT NULL	Draft Create Key
7	PAID_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Paid Amount
8	DFT_MASTER_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Draft Master Status A=Approved N=Not Apprv R=Rejected
9	PYMNT_METHOD_ALT	Character(3)	VARCHAR2(3) NOT NULL	Payment Method ACH=Automated Clearing House CHK=System Check DD=Direct Debit EFT=Electronic Funds Transfer GE=Giro - EFT GM=Giro - Manual LC=Letter of Credit MAN=Manual Check WIR=Wire Report
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	AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Amount
12	CURRENCY_PYMNT	Character(3)	VARCHAR2(3) NOT NULL	Payment Currency