PeopleSoft 9.0 Cash Management |
Table Name | TR_WR_HEADER |
Table Description |
TR_WR_HEADER |
Columns |
Name | Datatype | Is PK | Is FK |
BUSINESS_UNIT | CHAR(5) | Yes | Yes |
TR_SOURCE_ID | CHAR(12) | Yes | No |
DESCR | CHAR(30) | No | No |
OPRID_ENTERED_BY | CHAR(30) | No | No |
DTTM_ENTERED | PSDATETIME | No | No |
APPR_STATUS | CHAR(1) | No | No |
OPRID_APPROVED_BY | CHAR(30) | No | No |
APPROVAL_DT | PSDATE | No | No |
TR_WR_TEMPLATE_ID | CHAR(12) | No | No |
ACCTG_TMPL_ID | CHAR(15) | No | No |
FED_WIRE_ID | CHAR(12) | No | No |
REPETITVE_TRNFR_CD | CHAR(15) | No | No |
DRAWDOWN_FLG | CHAR(1) | No | No |
TMPL_EXPIRATION_DT | PSDATE | No | No |
TRP_BUSINESS_UNIT | CHAR(5) | No | No |
POOL_ID | CHAR(10) | No | No |
PRENOTE_FLAG | CHAR(1) | No | No |
Index |
Name | Type | Unique | Member |
PS_TR_WR_HEADER | PK | Yes |
![]() |
PS0TR_WR_HEADER | IE1 | No |
![]() |
Member(s) of "PS_TR_WR_HEADER" Index |
BUSINESS_UNIT |
TR_SOURCE_ID |
Member(s) of "PS0TR_WR_HEADER" Index |
DESCR |
BUSINESS_UNIT |
TR_SOURCE_ID |
Published April 30, 2007 |