PeopleSoft 9
Account Payables

Table Name PYCYCL_JOB_TBL

Table Description
PYCYCL_JOB_TBL
Columns
Name Datatype Is PK Is FK
PAY_CYCLE VARCHAR(6) Yes Yes
PAY_CYCLE_SEQ_NUM int Yes Yes
PAY_RUN_AP_STATUS VARCHAR(1) Yes No
JOB_TYPE VARCHAR(1) Yes No
BANK_SETID VARCHAR(5) Yes No
BANK_CD VARCHAR(5) Yes No
BANK_ACCT_KEY VARCHAR(4) Yes No
PYMNT_METHOD VARCHAR(3) Yes No
PYMNT_FILENAME VARCHAR(18) Yes No
PRCSINSTANCE int Yes No
PRCSTYPE VARCHAR(30) Yes No
PRCSNAME VARCHAR(12) Yes No
BUSPROCNAME VARCHAR(30) Yes No
ACTIVITYNAME VARCHAR(30) Yes No
EVENTNAME VARCHAR(30) Yes No
Index
Name Type Unique Member
PS_PYCYCL_JOB_TBL PK Yes
Member(s) of "PS_PYCYCL_JOB_TBL" Index
PAY_CYCLE
PAY_CYCLE_SEQ_NUM
PAY_RUN_AP_STATUS
JOB_TYPE
BANK_SETID
BANK_CD
BANK_ACCT_KEY
PYMNT_METHOD
PYMNT_FILENAME
PRCSINSTANCE
PRCSTYPE
PRCSNAME
BUSPROCNAME
ACTIVITYNAME
EVENTNAME

Published June 06, 2007