PeopleSoft 9.0
Cash Management

Table Name STL_EFT_TRAN

Table Description
STL_EFT_TRAN
Columns
Name Datatype Is PK Is FK
TR_SOURCE_CD CHAR(1) Yes No
SOURCE_BUS_UNIT CHAR(5) Yes No
TR_SOURCE_ID CHAR(12) Yes No
BUSINESS_DATE PSDATE Yes No
CASH_FLOW_LINE DECIMAL(15) Yes No
CASH_FLOW_LEG SMALLINT Yes No
PAY_DOC_SEQ INT No No
CASH_TYPE CHAR(2) No No
AMOUNT DECIMAL(26,3) No No
CURRENCY_CD CHAR(3) No No
BANK_SETID CHAR(5) No No
BANK_CD_CUST 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
BNK_ID_NBR CHAR(20) No No
BANK_ACCOUNT_NUM CHAR(17) No No
RECONCILE_DT PSDATE No No
RECONCILE_OPRID CHAR(30) No No
RECON_TYPE CHAR(1) No No
RECON_STATUS CHAR(3) No No
RECON_CYCLE_NBR DECIMAL(10) No No
STTLMNT_DT_ACTUAL PSDATE No No
NET_STATUS CHAR(1) No No
APPROVAL_OPRID CHAR(30) No No
CPTY_REFERENCE CHAR(15) No No
NET_REF_ID CHAR(12) No No
CF_SOURCE_REF_ID CHAR(40) No No
CP_NETTOR CHAR(30) No No
PYMNT_METHOD CHAR(3) No No
SETTLEMENT_ID CHAR(5) No No
PYMNT_SELCT_STATUS CHAR(1) No No
APPROVAL_FLG_TR CHAR(1) No No
APPROV_SUBMITTED CHAR(1) No No
PYMNT_ID CHAR(10) No No
CURRENCY_CD_BASE CHAR(3) No No
BASE_AMT DECIMAL(26,3) No No
BASE_CURRENCY_BNK CHAR(3) No No
BNK_RATE_DIV DECIMAL(15,8) No No
BNK_RATE_MULT DECIMAL(15,8) No No
CUR_RT_TYPE_BNK CHAR(5) No No
CURRENCY_PYMNT CHAR(3) No No
PAID_AMT DECIMAL(26,3) No No
PAID_AMT_BNK_BSE DECIMAL(26,3) No No
PAID_AMT_BSE DECIMAL(26,3) No No
PYMNT_RATE_DIV DECIMAL(15,8) No No
PYMNT_RATE_MULT DECIMAL(15,8) No No
PAY_CYCLE CHAR(6) No No
PAY_CYCLE_SEQ_NUM INT No No
SETID CHAR(5) No No
LOCATION CHAR(10) No No
BANK_ID_QUAL CHAR(3) No No
BRANCH_ID CHAR(10) No No
DFI_ID_QUAL CHAR(2) No No
DFI_ID_NUM CHAR(12) No No
BANK_ACCT_QUAL CHAR(1) No No
BNK_ID_NBR_TARG CHAR(20) No No
BANK_ACCT_TYPE CHAR(2) No No
BANK_ACCT_NUM_TARG CHAR(17) No No
CHECK_DIGIT CHAR(2) No No
BENEFICIARY_BANK CHAR(30) No No
BUS_UNIT_NAME CHAR(30) 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
NAME1 CHAR(40) No No
NAME1_AC CHAR(40) No No
NAME2 CHAR(40) No No
NAME2_AC CHAR(40) No No
COUNTRY CHAR(3) No No
ADDRESS1 CHAR(55) No No
ADDRESS2 CHAR(55) No No
ADDRESS3 CHAR(55) No No
ADDRESS4 CHAR(55) No No
CITY CHAR(30) No No
NUM1 CHAR(6) No No
NUM2 CHAR(4) No No
HOUSE_TYPE CHAR(2) No No
ADDR_FIELD1 CHAR(2) No No
ADDR_FIELD2 CHAR(4) No No
ADDR_FIELD3 CHAR(4) No No
COUNTY CHAR(30) No No
STATE CHAR(6) No No
POSTAL CHAR(12) No No
GEO_CODE CHAR(11) No No
IN_CITY_LIMIT CHAR(1) No No
COUNTRY_CODE CHAR(3) No No
PHONE CHAR(24) No No
EXTENSION CHAR(6) No No
FAX CHAR(24) No No
TR_RVL_RT_TYPE CHAR(5) No No
RATE_MULT DECIMAL(15,8) No No
RATE_DIV DECIMAL(15,8) No No
ADDENDA CHAR(140) No No
STL_THROUGH CHAR(2) No No
PMTRUNINSTANCE DECIMAL(10) No No
REPETITVE_TRNFR_CD CHAR(15) No No
DRAWDOWN_FLG CHAR(1) No No
PMT_FILE_ID CHAR(8) No No
Index
Name Type Unique Member
PS_STL_EFT_TRAN PK Yes
PSASTL_EFT_TRAN IE1 No
PSBSTL_EFT_TRAN IE2 No
Member(s) of "PS_STL_EFT_TRAN" Index
TR_SOURCE_CD
SOURCE_BUS_UNIT
TR_SOURCE_ID
BUSINESS_DATE
CASH_FLOW_LINE
CASH_FLOW_LEG
Member(s) of "PSASTL_EFT_TRAN" Index
PMTRUNINSTANCE
Member(s) of "PSBSTL_EFT_TRAN" Index
PMT_FILE_ID

Published April 30, 2007