PYCYCL_VND_VW3

(SQL View)
 Index Back

Supplier Requirements


SELECT a.pay_cycle , a.pay_cycle_seq_num , a.remit_setid , a.remit_vendor , b.voucher_id , b.business_unit , a.pay_doc_seq , a.bank_setid , a.bank_cd , a.bank_acct_key , a.pymnt_method , b.invoice_id , b.invoice_dt , a.scheduled_pay_dt , c.pymnt_hold , a.pymnt_separate , a.pymnt_handling_cd , b.vendor_id , a.paid_amt , a.pymnt_gross_amt , a.paid_amt_gross - a.paid_amt , a.dscnt_pay_amt , a.pymnt_message , c.pymnt_hold_reason , b.txn_currency_cd , b.base_currency , b.rt_type , a.currency_pymnt , a.cur_rt_type_pymnt , a.paid_amt_gross , a.paid_amt_dscnt , a.paid_amt_bse , a.paid_amt_gross_bse , a.paid_amt_dscnt_bse FROM ps_pycycl_data a , PS_VOUCHER b , ps_pymnt_vchr_xref c WHERE b.business_unit = a.business_unit AND b.voucher_id = a.voucher_id AND c.business_unit = a.business_unit AND c.voucher_id = a.voucher_id AND c.pymnt_cnt = a.pay_doc_seq AND a.pymnt_selct_status IN ('R','V','D')

# 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 VOUCHER_ID Character(8) VARCHAR2(8) NOT NULL Voucher ID
6 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
7 PYMNT_CNT Number(5,0) INTEGER NOT NULL Payments
8 BANK_SETID Character(5) VARCHAR2(5) NOT NULL The PeopleSoft tableset ID associated with a given bank/counterparty.
9 BANK_CD Character(5) VARCHAR2(5) NOT NULL Bank Code

Prompt Table: BANK_CD_TBL

10 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

Prompt Table: BANK_ACCT_TBL

11 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
12 INVOICE_ID Character(30) VARCHAR2(30) NOT NULL Invoice Number
13 INVOICE_DT Date(10) DATE Invoice Date
14 SCHEDULED_PAY_DT Date(10) DATE Scheduled to Pay
15 PYMNT_HOLD Character(1) VARCHAR2(1) NOT NULL Hold Payment
N=No
Y=Yes

Y/N Table Edit

Default Value: N

16 PYMNT_SEPARATE Character(1) VARCHAR2(1) NOT NULL Separate Payment
17 PYMNT_HANDLING_CD Character(2) VARCHAR2(2) NOT NULL Payment Handling
18 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
19 PAID_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Paid Amount
20 PYMNT_GROSS_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Gross Payment Amount
21 DISCOUNT_TAKEN Signed Number(28,3) DECIMAL(26,3) NOT NULL Discount Taken
22 DSCNT_PAY_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Payment Discount Amount
23 PYMNT_MESSAGE Character(70) VARCHAR2(70) NOT NULL Payment Message
24 PYMNT_HOLD_REASON Character(3) VARCHAR2(3) NOT NULL Hold Reason
ACC=Accounting in Dispute
ACV=Federal Supplier Inactive
ALC=Agency Location Code Required
AMT=Amount in Dispute
CCR=CCR Expired
CRT=Contract Retention
EFT=EFT incomplete or not Prenoted
FNS=Financial Sanctions
GDS=Goods in Dispute
GNV=G-Invoicing Hold
IPC=Inbound IPAC Required
OTH=Other
QTY=Quantity in Dispute
SAM=SAM Expired
WTH=Withholding Hold
25 TXN_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Transaction Currency
26 BASE_CURRENCY Character(3) VARCHAR2(3) NOT NULL "Specifies the primary currency for a general ledger business unit, and is sometimes referred to as the ""book"" currency. Each business unit has one base currency. which is usually, but not always, the local currency for the organization. Journal entries are posted to a business unit in its base currency. "
27 CUR_RT_TYPE Character(5) VARCHAR2(5) NOT NULL Currency Rate Type
28 CURRENCY_PYMNT Character(3) VARCHAR2(3) NOT NULL Payment Currency
29 CUR_RT_TYPE_PYMNT Character(5) VARCHAR2(5) NOT NULL Payment Currency Rate Type
30 PAID_AMT_GROSS Signed Number(28,3) DECIMAL(26,3) NOT NULL Gross Paid Amount
31 PAID_AMT_DSCNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Discount on Paid Amount
32 PAID_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Base Paid Amount
33 PAID_AMT_GROSS_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Base Gross Payment Amount
34 PAID_AMT_DSCNT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Base Discount Paid Amount