PeopleSoft 9.0
Cash Management

Table Name TR_WR_DETAIL

Table Description
TR_WR_DETAIL
Columns
Name Datatype Is PK Is FK
BUSINESS_UNIT CHAR(5) Yes Yes
TR_SOURCE_ID CHAR(12) Yes Yes
TR_SOURCE_CD CHAR(1) Yes No
CASH_FLOW_LINE DECIMAL(15) No No
CASH_FLOW_LEG SMALLINT No No
NAME1 CHAR(40) No No
NAME1_AC CHAR(40) No No
NAME2 CHAR(40) No No
NAME2_AC CHAR(40) 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
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
BENEFICIARY_BANK CHAR(30) No No
BENEFICIARY_BNK_AC CHAR(30) No No
BENEF_BRANCH CHAR(30) No No
BENEF_BRANCH_AC CHAR(30) 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
IBAN_CHECK_DIGIT CHAR(2) No No
IBAN_ID CHAR(34) No No
BANK_ACCT_QUAL CHAR(1) No No
TO_BANK_CD CHAR(5) No No
TO_BANK_ACCT_KEY CHAR(4) No No
DESCRLONG TEXT No No
Index
Name Type Unique Member
PS_TR_WR_DETAIL PK Yes
Member(s) of "PS_TR_WR_DETAIL" Index
BUSINESS_UNIT
TR_SOURCE_ID
TR_SOURCE_CD

Published April 30, 2007