PeopleSoft 9
Account Payables

Table Name PYCYCL_BNK_OVR

Table Description
PYCYCL_BNK_OVR
Columns
Name Datatype Is PK Is FK
PAY_CYCLE VARCHAR(6) Yes Yes
SETID VARCHAR(5) Yes Yes
BANK_CD VARCHAR(5) Yes Yes
BANK_ACCT_KEY VARCHAR(4) Yes Yes
PYMNT_METHOD VARCHAR(3) Yes No
BANK_SETID VARCHAR(5) No No
BANK_CD_NEW VARCHAR(5) No No
BANK_ACCT_KEY_NEW VARCHAR(4) No No
PYMNT_METHOD_NEW VARCHAR(3) No No
BANK_OVERRIDE_FLG VARCHAR(1) No No
Index
Name Type Unique Member
PS_PYCYCL_BNK_OVR PK Yes
Member(s) of "PS_PYCYCL_BNK_OVR" Index
PAY_CYCLE
SETID
BANK_CD
BANK_ACCT_KEY
PYMNT_METHOD

Published June 06, 2007