PYCYCL_NBAL_VW2 (SQL View)	Index Back
Temp Table for Payment Select This temporary table is used in AP payment selection processing to hold all suppliers that have a negative total amount to pay based on the payment selection criteria.

PYCYCL_NBAL_VW2

(SQL View)

Temp Table for Payment Select

This temporary table is used in AP payment selection processing to hold all suppliers that have a negative total amount to pay based on the payment selection criteria.

SELECT A.PAY_CYCLE , A.PAY_CYCLE_SEQ_NUM , A.REMIT_SETID , A.REMIT_VENDOR , A.REMIT_ADDR_SEQ_NUM , A.VNDR_LOC , A.BANK_SETID , A.BANK_CD , A.BANK_ACCT_KEY , A.PYMNT_METHOD , A.PYMNT_HANDLING_CD , A.CURRENCY_PYMNT , A.BUSINESS_UNIT_AP , A.COMBINE_PYMNT_OPT , SUM(A.PAID_AMT) FROM PS_PYCYCL_NEG_TMP A GROUP BY A.PAY_CYCLE , A.PAY_CYCLE_SEQ_NUM , A.REMIT_SETID , A.REMIT_VENDOR , A.REMIT_ADDR_SEQ_NUM , A.VNDR_LOC , A.BANK_SETID , A.BANK_CD , A.BANK_ACCT_KEY , A.PYMNT_METHOD , A.PYMNT_HANDLING_CD , A.CURRENCY_PYMNT , A.BUSINESS_UNIT_AP , A.COMBINE_PYMNT_OPT

# 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 REMIT_SETID Character(5) VARCHAR2(5) NOT NULL Remit SetID

4 REMIT_VENDOR Character(10) VARCHAR2(10) NOT NULL Remit Vendor

5 REMIT_ADDR_SEQ_NUM Number(5,0) INTEGER NOT NULL Remitting Location

6 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location

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

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

9 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

10 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

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

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

13 BUSINESS_UNIT_AP Character(5) VARCHAR2(5) NOT NULL AP Business Unit

14 COMBINE_PYMNT_OPT Character(1) VARCHAR2(1) NOT NULL Combine Pymnt Option

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

#	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	REMIT_SETID	Character(5)	VARCHAR2(5) NOT NULL	Remit SetID
4	REMIT_VENDOR	Character(10)	VARCHAR2(10) NOT NULL	Remit Vendor
5	REMIT_ADDR_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	Remitting Location
6	VNDR_LOC	Character(10)	VARCHAR2(10) NOT NULL	Vendor Location
7	BANK_SETID	Character(5)	VARCHAR2(5) NOT NULL	The PeopleSoft tableset ID associated with a given bank/counterparty.
8	BANK_CD	Character(5)	VARCHAR2(5) NOT NULL	Bank Code
9	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
10	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
11	PYMNT_HANDLING_CD	Character(2)	VARCHAR2(2) NOT NULL	Payment Handling
12	CURRENCY_PYMNT	Character(3)	VARCHAR2(3) NOT NULL	Payment Currency
13	BUSINESS_UNIT_AP	Character(5)	VARCHAR2(5) NOT NULL	AP Business Unit
14	COMBINE_PYMNT_OPT	Character(1)	VARCHAR2(1) NOT NULL	Combine Pymnt Option
15	PAID_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Paid Amount