PeopleSoft 9.0
Cash Management

Table Name PMT_DETAIL_TBL

Table Description
PMT_DETAIL_TBL
Columns
Name Datatype Is PK Is FK
PMT_ID char(15) Yes No
PMT_SOURCE CHAR(10) No Yes
BUSINESS_UNIT char(5) No No
SRC_REF_ID char(20) No No
AMOUNT decimal(26,3) No No
AMOUNT_CURRENCY_CD char(3) No No
PYMNT_DT datetime No No
VALUE_DT datetime No No
ESTIMATED_DUE_DATE datetime No No
PMT_STATUS char(2) No No
PMT_LAST_STATUS char(2) No No
PMT_TYPE char(4) No No
BANK_SETID char(5) No No
BANK_CD char(5) No No
BANK_ACCT_KEY char(4) No No
ACCT_BUS_UNIT_GL char(5) No No
FROM_BNK_ID_NBR char(20) No No
FROM_BNK_ACCT_NUM char(17) No No
FROM_DFI_ID_NUM char(12) No No
FROM_DFI_ID_QUAL char(2) No No
PYMNT_METHOD char(3) No No
FORMAT_ID char(10) No No
PRENOTE_FLAG char(1) No No
PAY_IMMEDIATELY char(1) No No
COUNTRY char(3) No No
BANK_ID_QUAL char(3) No No
BNK_ID_NBR char(20) No No
BRANCH_ID char(10) No No
BANK_ACCT_TYPE char(2) No No
BANK_ACCOUNT_NUM char(17) No No
CHECK_DIGIT char(2) No No
DFI_ID_QUAL char(2) No No
DFI_ID_NUM char(12) No No
BANK_NAME char(30) No No
BANK_NAME_AC char(30) No No
BRANCH_DESCR char(30) No No
BRANCH_NAME_AC char(30) No No
IBAN_CHECK_DIGIT char(2) No No
IBAN_ID char(34) No No
PARTY_ID_TYPE char(4) No No
PARTY_SETID char(5) No No
PARTY_ID char(30) No No
NAME1 char(40) No No
NAME1_AC char(40) No No
NAME2 char(40) No No
STD_ID_NUM char(20) No No
STD_ID_NUM_QUAL char(3) No No
EFT_PYMNT_FMT_CD char(3) No No
EFT_RTNG_FLG char(1) No No
EFT_RTNG_STATUS char(1) No No
EFT_TRANS_HANDLING char(1) No No
EFT_DOM_COSTS_CD char(1) No No
EFT_CORR_COSTS_CD char(1) No No
EFT_CROSSED_CHECK char(1) No No
EFT_CHECK_FWRD_CD char(1) No No
EFT_CHECK_DRAW_CD char(1) No No
EFT_PAY_INST_CD1 char(3) No No
EFT_PAY_INST_CD2 char(3) No No
EFT_PAY_INST_CD3 char(3) No No
EFT_PAY_INST_CD4 char(3) No No
EFT_PAY_INST_REF1 char(40) No No
EFT_PAY_INST_REF2 char(40) No No
ADDENDA_VALUE char(254) No No
REPETITVE_TRNFR_CD char(15) No No
DRAWDOWN_FLG char(1) No No
CREATED_BY_USER char(30) No No
PMT_FIELD1 char(30) No No
PMT_FIELD2 char(30) No No
PMT_FIELD3 char(30) No No
PAY_CYCLE char(6) No No
PAY_CYCLE_SEQ_NUM int No No
BATCH_NAME char(30) No No
PMT_FILE_ID CHAR(8) No Yes
BANK_REF_ID char(16) No No
EVENT_TRACKING_ID decimal(10) No No
PMT_MSG_ID char(15) No No
PMTRUNINSTANCE decimal(10) No No
IN_PROCESS_FLG char(1) No No
PAYEE_VIOLATION CHAR(1) No No
Index
Name Type Unique Member
PS_PMT_DETAIL_TBL PK Yes
PSAPMT_DETAIL_TBL IE1 No
PSBPMT_DETAIL_TBL IE2 No
PSCPMT_DETAIL_TBL IE3 No
PSDPMT_DETAIL_TBL IE4 No
Member(s) of "PS_PMT_DETAIL_TBL" Index
PMT_ID
Member(s) of "PSAPMT_DETAIL_TBL" Index
PYMNT_DT
PMT_STATUS
Member(s) of "PSBPMT_DETAIL_TBL" Index
PMTRUNINSTANCE
Member(s) of "PSCPMT_DETAIL_TBL" Index
BANK_SETID
BANK_CD
BANK_ACCT_KEY
Member(s) of "PSDPMT_DETAIL_TBL" Index
FROM_BNK_ID_NBR
FROM_BNK_ACCT_NUM

Published April 30, 2007