PeopleSoft 9
Account Payables

Table Name GFAP_PYCERT_WL

Table Description
GFAP_PYCERT_WL
Columns
Name Datatype Is PK Is FK
BUSPROCNAME VARCHAR(30) Yes No
ACTIVITYNAME VARCHAR(30) Yes No
EVENTNAME VARCHAR(30) Yes No
WORKLISTNAME VARCHAR(30) Yes No
INSTANCEID int Yes No
TRANSACTIONID int Yes No
PAY_CYCLE VARCHAR(6) Yes Yes
PAY_CYCLE_SEQ_NUM int No No
BANK_SETID VARCHAR(5) No No
BANK_CD VARCHAR(5) No No
BANK_ACCT_KEY VARCHAR(4) No No
PYMNT_METHOD VARCHAR(3) No No
PAY_RUN_AP_STATUS VARCHAR(1) No No
Index
Name Type Unique Member
PS_GFAP_PYCERT_WL PK Yes
Member(s) of "PS_GFAP_PYCERT_WL" Index
BUSPROCNAME
ACTIVITYNAME
EVENTNAME
WORKLISTNAME
INSTANCEID
TRANSACTIONID
PAY_CYCLE

Published June 06, 2007