PeopleSoft 9
Account Payables

Table Name PYCYCL_STAT

Table Description
PYCYCL_STAT
Columns
Name Datatype Is PK Is FK
PAY_CYCLE VARCHAR(6) Yes Yes
PAY_CYCLE_SEQ_NUM int Yes No
PAY_RUN_AP_STATUS VARCHAR(1) No No
PAY_THRU_DT PSDATE No No
PYMNT_DT PSDATE No No
OPRID VARCHAR(30) No No
PAY_RUN_DT PSDATE No No
ACCOUNTING_DT PSDATE No No
TIME_HH SMALLINT No No
TIME_MM SMALLINT No No
COMMIT_STATUS SMALLINT No No
DSCNT_ALRT_FLG VARCHAR(1) No No
NEG_BAL_FLG VARCHAR(1) No No
CNV_ERR_FLG VARCHAR(1) No No
BAD_CURR_FLG VARCHAR(1) No No
SAME_REF_FLG VARCHAR(1) No No
PROCESS_INSTANCE decimal(10) No No
CURTEMPINSTANCE SMALLINT No No
Index
Name Type Unique Member
PS_PYCYCL_STAT PK Yes
Member(s) of "PS_PYCYCL_STAT" Index
PAY_CYCLE
PAY_CYCLE_SEQ_NUM

Published June 06, 2007