PeopleSoft 9
Account Payables

Table Name PYCYCL_SUM

Table Description
PYCYCL_SUM
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
BANK_SETID VARCHAR(5) Yes No
BANK_CD VARCHAR(5) Yes No
BANK_ACCT_KEY VARCHAR(4) Yes No
DESCRSHORT VARCHAR(10) No No
CURRENCY_PYMNT VARCHAR(3) No No
PAID_AMT decimal(26,3) No No
NUM_OF_VOUCHERS int No No
Index
Name Type Unique Member
PS_PYCYCL_SUM PK Yes
Member(s) of "PS_PYCYCL_SUM" Index
PAY_CYCLE
PAY_CYCLE_SEQ_NUM
BUSINESS_UNIT
BANK_SETID
BANK_CD
BANK_ACCT_KEY

Published June 06, 2007