PeopleSoft 9
Account Payables

Table Name PAYMENT_RCN_TBL

Table Description
PAYMENT_RCN_TBL
Columns
Name Datatype Is PK Is FK
BNK_ID_NBR VARCHAR(20) Yes No
BANK_ACCOUNT_NUM VARCHAR(17) Yes No
PYMNT_ID VARCHAR(10) Yes No
CREATE_DTTM PSDATETIME Yes No
PYMNT_ID_REF VARCHAR(20) Yes No
PYMNT_CLEAR_DT PSDATE No No
CURRENCY_PYMNT VARCHAR(3) No No
RECON_DIFF_AMT decimal(26,3) No No
RECON_PAYEE_ID VARCHAR(40) No No
RECON_TYPE VARCHAR(1) No No
PROCESS_INSTANCE decimal(10) No No
OPRID VARCHAR(30) No No
DESCR VARCHAR(30) No No
Index
Name Type Unique Member
PS_PAYMENT_RCN_TBL PK Yes
Member(s) of "PS_PAYMENT_RCN_TBL" Index
BNK_ID_NBR
BANK_ACCOUNT_NUM
PYMNT_ID
CREATE_DTTM
PYMNT_ID_REF

Published June 06, 2007