PYCYCL_02_VW2

(SQL View)
 Index Back

Pay Cycle Data Record


SELECT A.PAY_CYCLE ,A.PAY_CYCLE_SEQ_NUM ,A.PYMNT_IMAGE_ID ,A.SOURCE_TXN ,A.BUSINESS_UNIT ,A.PAY_DOC_ID ,A.PAY_DOC_SEQ ,A.PYCYCL_KEY_FIELD1 ,A.PYCYCL_KEY_FIELD2 ,A.PYCYCL_KEY_FIELD3 ,A.PAY_DOC_DT ,A.DUE_DT ,A.SCHEDULED_PAY_DT ,A.BANK_SETID ,A.BANK_CD ,A.BANK_ACCT_KEY ,A.PYMNT_METHOD ,A.PAID_AMT_GROSS ,A.CURRENCY_PYMNT ,A.PYMNT_ID ,A.VOUCHER_ID ,A.INVOICE_ID ,A.REMIT_SETID ,A.REMIT_VENDOR ,A.VENDOR_NAME_SHORT ,A.VNDR_LOC ,A.EMPLID ,A.WTHD_SW ,A.BANK_RPL_STATUS ,A.BANK_RPL_STATUS FROM PS_PYCYCL_02_TMP A , PS_PAY_IMG_HDR_TMP B WHERE A.PAY_CYCLE = B.PAY_CYCLE AND A.PAY_CYCLE_SEQ_NUM = B.PAY_CYCLE_SEQ_NUM AND A.PYMNT_IMAGE_ID = B.PYMNT_IMAGE_ID

# 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 PYMNT_IMAGE_ID Number(10,0) DECIMAL(10) NOT NULL Payment Image ID
4 SOURCE_TXN Character(4) VARCHAR2(4) NOT NULL Source Transaction
5 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
6 PAY_DOC_ID Character(20) VARCHAR2(20) NOT NULL Advice ID
7 PAY_DOC_SEQ Number(5,0) INTEGER NOT NULL Advice Sequence
8 PYCYCL_KEY_FIELD1 Character(20) VARCHAR2(20) NOT NULL Pay Cycle Mapping Key Field 1
9 PYCYCL_KEY_FIELD2 Date(10) DATE Pay Cycle Mapping Key Field 2
10 PYCYCL_KEY_FIELD3 Number(15,0) DECIMAL(15) NOT NULL Pay Cycle Mapping Key Field 3
11 PAY_DOC_DT Date(10) DATE Advice Date
12 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.
13 SCHEDULED_PAY_DT Date(10) DATE Scheduled to Pay
14 BANK_SETID Character(5) VARCHAR2(5) NOT NULL The PeopleSoft tableset ID associated with a given bank/counterparty.
15 BANK_CD Character(5) VARCHAR2(5) NOT NULL Bank Code
16 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
17 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
18 PAID_AMT_GROSS Signed Number(28,3) DECIMAL(26,3) NOT NULL Gross Paid Amount
19 CURRENCY_PYMNT Character(3) VARCHAR2(3) NOT NULL Payment Currency
20 PYMNT_ID Character(10) VARCHAR2(10) NOT NULL Payment Number
21 VOUCHER_ID Character(8) VARCHAR2(8) NOT NULL Voucher ID
22 INVOICE_ID Character(30) VARCHAR2(30) NOT NULL Invoice Number
23 REMIT_SETID Character(5) VARCHAR2(5) NOT NULL Remit SetID
24 REMIT_VENDOR Character(10) VARCHAR2(10) NOT NULL Remit Vendor
25 VENDOR_NAME_SHORT Character(14) VARCHAR2(14) NOT NULL Short Vendor Name
26 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location
27 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
28 WTHD_SW Character(1) VARCHAR2(1) NOT NULL Withholding Applicable Flag
B=Global and 1099
G=Global
T=1099
29 BANK_RPL_STATUS Character(1) VARCHAR2(1) NOT NULL Replacement Status
B=Invalid electronic bank setup
C=Bank currency not supported
L=Invalid bank layout
N=Not Replaced
P=Payment method not supported
R=Missing currency convert rates
S=Invalid Set ID
Y=Bank Replaced
30 EXCEPTION_BANK Character(1) VARCHAR2(1) NOT NULL Exception Type
A=All
B=Pay To Bank
C=Payment Currency
L=Invalid Layout
P=Payment Method
S=Invalid Setid