PeopleSoft 9
Account Payables

Table Name PYCYCL_STATRPT

Table Description
PYCYCL_STATRPT
Columns
Name Datatype Is PK Is FK
PAY_CYCLE VARCHAR(6) Yes Yes
PAY_CYCLE_SEQ_NUM int Yes Yes
BANK_SETID VARCHAR(5) Yes Yes
BANK_CD VARCHAR(5) Yes Yes
BANK_ACCT_KEY VARCHAR(4) Yes Yes
PYMNT_METHOD VARCHAR(3) Yes Yes
PYMNT_FILENAME VARCHAR(18) Yes No
FORM_TYPE VARCHAR(3) No No
PRINT_SWITCH VARCHAR(1) No No
FIRST_PYMNT_REF_ID VARCHAR(10) No No
PAY_RUN_AP_STATUS VARCHAR(1) No No
OUTDEST VARCHAR(127) No No
OUTDESTTYPE VARCHAR(3) No No
SERVERNAME VARCHAR(8) No No
STL_THROUGH VARCHAR(2) No No
Index
Name Type Unique Member
PS_PYCYCL_STATRPT PK Yes
Member(s) of "PS_PYCYCL_STATRPT" Index
PAY_CYCLE
PAY_CYCLE_SEQ_NUM
BANK_SETID
BANK_CD
BANK_ACCT_KEY
PYMNT_METHOD
PYMNT_FILENAME

Published June 06, 2007