PeopleSoft 9
Account Payables

Table Name PYMNT_RPLCD

Table Description
PYMNT_RPLCD
Columns
Name Datatype Is PK Is FK
BANK_SETID VARCHAR(5) Yes Yes
BANK_CD VARCHAR(5) Yes Yes
BANK_ACCT_KEY VARCHAR(4) Yes Yes
PYMNT_ID_OLD VARCHAR(20) Yes No
PYMNT_ID_REF_OLD VARCHAR(20) Yes No
PYMNT_METHOD VARCHAR(3) No No
PYMNT_ID VARCHAR(10) No Yes
PYMNT_ID_REF VARCHAR(20) No No
SOURCE_TXN VARCHAR(4) No Yes
PAY_CYCLE VARCHAR(6) No Yes
PAY_CYCLE_SEQ_NUM int No Yes
Index
Name Type Unique Member
PS_PYMNT_RPLCD PK Yes
PS0PYMNT_RPLCD IE1 No
PS1PYMNT_RPLCD IE2 No
Member(s) of "PS_PYMNT_RPLCD" Index
BANK_SETID
BANK_CD
BANK_ACCT_KEY
PYMNT_ID_OLD
PYMNT_ID_REF_OLD
Member(s) of "PS0PYMNT_RPLCD" Index
PYMNT_METHOD
BANK_SETID
BANK_CD
BANK_ACCT_KEY
PYMNT_ID_OLD
PYMNT_ID_REF_OLD
Member(s) of "PS1PYMNT_RPLCD" Index
PYMNT_ID_REF
BANK_SETID
BANK_CD
BANK_ACCT_KEY
PYMNT_ID_OLD
PYMNT_ID_REF_OLD

Published June 06, 2007