PeopleSoft 9.0
Cash Management

Table Name TR_WR_TEMPLATE

Table Description
TR_WR_TEMPLATE
Columns
Name Datatype Is PK Is FK
SETID CHAR(5) Yes No
TR_WR_TEMPLATE_ID CHAR(12) Yes No
TRANSFER_CLASS CHAR(3) Yes No
DESCR CHAR(30) No No
APPR_STATUS CHAR(1) No No
OPRID_APPROVED_BY CHAR(30) No No
APPROVAL_DT PSDATE No No
FROM_BNK_ID_NBR CHAR(20) No No
FROM_BNK_ACCT_NBR CHAR(17) No No
PAY_CURRENCY_CD CHAR(3) No No
PYMNT_METHOD CHAR(3) No No
ADDENDA CHAR(140) No No
AMOUNT DECIMAL(26,3) No No
ACCT_BUS_UNIT_GL CHAR(5) No No
ACCTG_TMPL_ID CHAR(15) No No
TR_WR_ACCTG_SW CHAR(1) No No
TR_WR_TEMPLATE_FLG CHAR(1) No No
TR_WR_ALLOW_STL_SW CHAR(1) 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
REPETITVE_TRNFR_SW CHAR(1) No No
REPETITVE_TRNFR_CD CHAR(15) No No
DRAWDOWN_FLG CHAR(1) No No
ACTIVE_STATUS CHAR(1) No No
BANK_CD CHAR(5) No No
BANK_ACCT_KEY CHAR(4) No No
FORMAT_ID CHAR(10) No No
TMPL_EXPIRATION_DT PSDATE No No
TO_BANK_CD CHAR(5) No No
TO_BANK_ACCT_KEY CHAR(4) No No
TRP_BUSINESS_UNIT CHAR(5) No No
POOL_ID CHAR(10) No No
PRENOTE_FLAG CHAR(1) No No
PRENOTE_STATUS CHAR(1) No No
PRENOTE_DAYS SMALLINT No No
PRENOTE_DATE datetime No No
BUSINESS_UNIT CHAR(5) No No
TR_SOURCE_ID CHAR(12) No No
DESCRLONG TEXT No No
Index
Name Type Unique Member
PS_TR_WR_TEMPLATE PK Yes
PS0TR_WR_TEMPLATE IE1 No
PS1TR_WR_TEMPLATE IE2 No
PS2TR_WR_TEMPLATE IE3 No
Member(s) of "PS_TR_WR_TEMPLATE" Index
SETID
TR_WR_TEMPLATE_ID
TRANSFER_CLASS
Member(s) of "PS0TR_WR_TEMPLATE" Index
DESCR
SETID
TR_WR_TEMPLATE_ID
TRANSFER_CLASS
Member(s) of "PS1TR_WR_TEMPLATE" Index
APPR_STATUS
SETID
TR_WR_TEMPLATE_ID
TRANSFER_CLASS
Member(s) of "PS2TR_WR_TEMPLATE" Index
REPETITVE_TRNFR_CD
SETID
TR_WR_TEMPLATE_ID
TRANSFER_CLASS

Published April 30, 2007