PeopleSoft 9
Account Payables

Table Name GFAP_SPS_SUM

Table Description
GFAP_SPS_SUM
Columns
Name Datatype Is PK Is FK
BANK_SETID VARCHAR(5) Yes No
BANK_CD VARCHAR(5) Yes Yes
BANK_ACCT_KEY VARCHAR(4) Yes Yes
SCHEDULE_ID VARCHAR(10) Yes No
GFAP_SPS_SUM_PAY1 VARCHAR(1) No No
GFAP_SPS_SUM_PAY2 VARCHAR(1) No No
RFC_CODE VARCHAR(3) No No
GFAP_SPS_MAC_CODE VARCHAR(8) No No
PROCESS_COMPLETE VARCHAR(1) No No
PYMNT_DT datetime No No
GFAP_SPS_TAPE_1 VARCHAR(7) No No
GFAP_SPS_TAPE_2 VARCHAR(7) No No
GFAP_SPS_TAPE_3 VARCHAR(7) No No
GFAP_SPS_TAPE_4 VARCHAR(7) No No
GFAP_SPS_TAPE_5 VARCHAR(7) No No
COMMENTS_254 VARCHAR(254) No No
Index
Name Type Unique Member
PS_GFAP_SPS_SUM PK Yes
Member(s) of "PS_GFAP_SPS_SUM" Index
BANK_SETID
BANK_CD
BANK_ACCT_KEY
SCHEDULE_ID

Published June 06, 2007