PeopleSoft 9
Account Payables

Table Name AP_BANK_SCHED

Table Description
AP_BANK_SCHED
Columns
Name Datatype Is PK Is FK
BNK_ID_NBR VARCHAR(20) Yes No
BANK_ACCOUNT_NUM VARCHAR(17) Yes No
SCHEDULE_ID VARCHAR(10) Yes No
PYMNT_TR_SENT_DT PSDATE No No
PYMNT_DT PSDATE No No
CANCEL_DT PSDATE No No
DISBURSED_DT PSDATE No No
PYMNT_STATUS VARCHAR(1) No No
CANCEL_ACTION VARCHAR(1) No No
PAY_CYCLE VARCHAR(6) No No
PAY_CYCLE_SEQ_NUM int No No
Index
Name Type Unique Member
PS_AP_BANK_SCHED PK Yes
Member(s) of "PS_AP_BANK_SCHED" Index
BNK_ID_NBR
BANK_ACCOUNT_NUM
SCHEDULE_ID

Published June 06, 2007