PYCYCL_STATRTMP (SQL Table)	Index Back
Output Info - Payment Process

PYCYCL_STATRTMP

(SQL Table)

Output Info - Payment Process

# 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 BANK_CD Character(5) VARCHAR2(5) NOT NULL Bank Code

5 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

6 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

7 PYMNT_FILENAME Character(18) VARCHAR2(18) NOT NULL Report ID

8 FORM_TYPE Character(10) VARCHAR2(10) NOT NULL Form and Builder Field
ADV=Remittance Advice Only
CAV=Check with Separate Advice
CRA=Crystal Check w/Advice
CRW=Crystal Check
CSA=Check over Stub with Advice
CSO=Check over Stub with Overflow
EFA=EFT File with Advice
EFT=EFT File
SCA=Stub over Check with Advice
SCO=Stub over Check with Overflow

9 PRINT_SWITCH Character(1) VARCHAR2(1) NOT NULL Print Switch
Y/N Table Edit
Default Value: N

10 FIRST_PYMNT_REF_ID Character(12) VARCHAR2(12) NOT NULL First Payment

11 PAY_RUN_AP_STATUS Character(1) VARCHAR2(1) NOT NULL Payment Run Status
1=Exceptions found
2=Nothing to process
3=Process running
6=Rejected
7=Selected/Staged
8=Waiting for Certification
C=Completed
D=Reset
E=Error
K=Restarted
N=New
R=Selected
U=Created
V=Trial Register Approved
X=Printed
Y=Confirmed
Z=Positive Payment Formatted

12 OUTDEST Character(127) VARCHAR2(127) NOT NULL Process Scheduler Output Destination

13 OUTDESTTYPE Character(3) VARCHAR2(3) NOT NULL Process Request output destination type.
0=Any
1=(None)
2=File
3=Printer
4=Window
5=Email
6=Web
7=Default
8=Feed
9=IB Node
Prompt Table: AP_OUTTYPE_VW

14 SERVERNAME Character(8) VARCHAR2(8) NOT NULL Server Name
Prompt Table: PYCYCL_SERVERS

15 STL_THROUGH Character(2) VARCHAR2(2) NOT NULL Settle through
01=Financial Gateway
02=Pay Cycle

#	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	BANK_CD	Character(5)	VARCHAR2(5) NOT NULL	Bank Code
5	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
6	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
7	PYMNT_FILENAME	Character(18)	VARCHAR2(18) NOT NULL	Report ID
8	FORM_TYPE	Character(10)	VARCHAR2(10) NOT NULL	Form and Builder Field ADV=Remittance Advice Only CAV=Check with Separate Advice CRA=Crystal Check w/Advice CRW=Crystal Check CSA=Check over Stub with Advice CSO=Check over Stub with Overflow EFA=EFT File with Advice EFT=EFT File SCA=Stub over Check with Advice SCO=Stub over Check with Overflow
9	PRINT_SWITCH	Character(1)	VARCHAR2(1) NOT NULL	Print Switch Y/N Table Edit Default Value: N
10	FIRST_PYMNT_REF_ID	Character(12)	VARCHAR2(12) NOT NULL	First Payment
11	PAY_RUN_AP_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Payment Run Status 1=Exceptions found 2=Nothing to process 3=Process running 6=Rejected 7=Selected/Staged 8=Waiting for Certification C=Completed D=Reset E=Error K=Restarted N=New R=Selected U=Created V=Trial Register Approved X=Printed Y=Confirmed Z=Positive Payment Formatted
12	OUTDEST	Character(127)	VARCHAR2(127) NOT NULL	Process Scheduler Output Destination
13	OUTDESTTYPE	Character(3)	VARCHAR2(3) NOT NULL	Process Request output destination type. 0=Any 1=(None) 2=File 3=Printer 4=Window 5=Email 6=Web 7=Default 8=Feed 9=IB Node Prompt Table: AP_OUTTYPE_VW
14	SERVERNAME	Character(8)	VARCHAR2(8) NOT NULL	Server Name Prompt Table: PYCYCL_SERVERS
15	STL_THROUGH	Character(2)	VARCHAR2(2) NOT NULL	Settle through 01=Financial Gateway 02=Pay Cycle