PeopleSoft 9
Account Payables

Table Name PYCYCL_CR_RESET

Table Description
PYCYCL_CR_RESET
Columns
Name Datatype Is PK Is FK
PAY_CYCLE VARCHAR(6) Yes Yes
PAY_CYCLE_SEQ_NUM int Yes Yes
BUSINESS_UNIT VARCHAR(5) Yes No
PAY_DOC_ID VARCHAR(20) Yes No
PAY_DOC_SEQ int Yes No
NEW_PYMNT_CNT int No No
PYMNT_GROSS_AMT decimal(26,3) No No
GROSS_AMT_BSE decimal(26,3) No No
Index
Name Type Unique Member
PS_PYCYCL_CR_RESET PK Yes
Member(s) of "PS_PYCYCL_CR_RESET" Index
PAY_CYCLE
PAY_CYCLE_SEQ_NUM
BUSINESS_UNIT
PAY_DOC_ID
PAY_DOC_SEQ

Published June 06, 2007