PeopleSoft 9.0
Cash Management

Table Name TRA_ACCTG_HDR

Table Description
TRA_ACCTG_HDR
Columns
Name Datatype Is PK Is FK
BUSINESS_UNIT CHAR(5) Yes Yes
ACCOUNTING_ID CHAR(10) Yes No
DESCR60 CHAR(60) No No
TRA_SOURCE_CD CHAR(1) No No
EVENT_ID CHAR(20) No No
ACCOUNTING_DT PSDATE No No
SEQ_NBR DECIMAL(15) No No
TRANSACTION_LEG SMALLINT No No
ACCTG_EVENT_TYPE CHAR(2) No No
BANK_ACCOUNT_NUM CHAR(17) No No
TRAN_REF_ID CHAR(20) No No
TRANSACTION_DT PSDATE No No
ERROR_STATUS CHAR(2) No No
ACCTG_STATUS CHAR(1) No No
TRA_REVIEW_STATUS CHAR(1) No No
BUILD_ACCOUNTING CHAR(1) No No
PROCESS_INSTANCE DECIMAL(10) No No
ORIG_OPRID CHAR(30) No No
ORIG_DTTM PSDATETIME No No
LAST_MAINT_DTTM PSDATETIME No No
ACCTG_TMPL_ID CHAR(15) No No
LAST_MAINT_OPRID CHAR(30) No No
DOC_TYPE CHAR(8) No No
INTEGRATION_STATUS CHAR(3) No No
BATCH_ID CHAR(18) No No
Index
Name Type Unique Member
PS_TRA_ACCTG_HDR PK Yes
PS0TRA_ACCTG_HDR IE5 No
PS1TRA_ACCTG_HDR IE6 No
PS2TRA_ACCTG_HDR IE7 No
PSATRA_ACCTG_HDR IE8 No
Member(s) of "PS_TRA_ACCTG_HDR" Index
BUSINESS_UNIT
ACCOUNTING_ID
Member(s) of "PS0TRA_ACCTG_HDR" Index
ACCTG_STATUS
BUSINESS_UNIT
ACCOUNTING_ID
Member(s) of "PS1TRA_ACCTG_HDR" Index
BUILD_ACCOUNTING
BUSINESS_UNIT
ACCOUNTING_ID
Member(s) of "PS2TRA_ACCTG_HDR" Index
PROCESS_INSTANCE
BUSINESS_UNIT
ACCOUNTING_ID
Member(s) of "PSATRA_ACCTG_HDR" Index
PROCESS_INSTANCE
ERROR_STATUS
ACCOUNTING_ID
ACCOUNTING_DT
BUSINESS_UNIT

Published April 30, 2007