PeopleSoft 9.0
Cash Management

Table Name TRA_ACCTG_LINE

Table Description
TRA_ACCTG_LINE
Columns
Name Datatype Is PK Is FK
BUSINESS_UNIT CHAR(5) Yes Yes
ACCOUNTING_ID CHAR(10) Yes Yes
ACCOUNTING_LINE int Yes No
ACCOUNTING_DT PSDATE No No
ACCOUNT CHAR(10) No No
ALTACCT CHAR(10) No No
DEPTID CHAR(10) No No
OPERATING_UNIT CHAR(8) No No
PRODUCT CHAR(6) No No
FUND_CODE CHAR(5) No No
CLASS_FLD CHAR(5) No No
PROGRAM_CODE CHAR(5) No No
BUDGET_REF CHAR(8) No No
AFFILIATE CHAR(5) No No
AFFILIATE_INTRA1 CHAR(10) No No
AFFILIATE_INTRA2 CHAR(10) No No
CHARTFIELD1 CHAR(10) No No
CHARTFIELD2 CHAR(10) No No
CHARTFIELD3 CHAR(10) No No
PROJECT_ID CHAR(15) No No
STATISTICS_CODE CHAR(3) No No
FOREIGN_AMOUNT DECIMAL(26,3) No No
FOREIGN_CURRENCY CHAR(3) No No
RT_TYPE CHAR(5) No No
MONETARY_AMOUNT DECIMAL(26,3) No No
CURRENCY_CD CHAR(3) No No
STATISTIC_AMOUNT DECIMAL(15,2) No No
JRNL_LN_REF CHAR(10) No No
DESCR CHAR(30) No No
ACCOUNTING_PERIOD SMALLINT No No
FISCAL_YEAR SMALLINT No No
BUSINESS_UNIT_GL CHAR(5) No No
LEDGER CHAR(10) No No
LEDGER_GROUP CHAR(10) No No
JOURNAL_ID CHAR(10) No No
JOURNAL_DATE PSDATE No No
GL_DISTRIB_STATUS CHAR(1) No No
COMBO_STATUS CHAR(1) No No
APPL_JRNL_ID CHAR(10) No No
JOURNAL_LINE INT No No
RATE_MULT DECIMAL(15,8) No No
RATE_DIV DECIMAL(15,8) No No
PROCESS_INSTANCE DECIMAL(10) No No
IU_ANCHOR_FLG CHAR(1) No No
IU_SYS_TRAN_CD CHAR(8) No No
IU_TRAN_CD CHAR(8) No No
ACCTG_LINE_SOURCE CHAR(3) No No
AMOUNT_CALC_TYPE CHAR(2) No No
DOC_TYPE CHAR(8) No No
DOC_SEQ_NBR CHAR(12) No No
DOC_SEQ_DATE PSDATE No No
DOC_SEQ_STATUS CHAR(1) No No
Index
Name Type Unique Member
PS_TRA_ACCTG_LINE PK Yes
PSATRA_ACCTG_LINE IE1 No
PSBTRA_ACCTG_LINE IE2 No
Member(s) of "PS_TRA_ACCTG_LINE" Index
BUSINESS_UNIT
ACCOUNTING_ID
ACCOUNTING_LINE
Member(s) of "PSATRA_ACCTG_LINE" Index
BUSINESS_UNIT
ACCOUNTING_ID
ACCOUNTING_DT
CURRENCY_CD
FOREIGN_CURRENCY
Member(s) of "PSBTRA_ACCTG_LINE" Index
PROCESS_INSTANCE

Published April 30, 2007