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 |