PeopleSoft 9
Asset Management

Table Name DIST_LN_ARCH

Table Description
DIST_LN_ARCH
Columns
Name Datatype Is PK Is FK
BUSINESS_UNIT char(5) Yes No
ASSET_ID char(12) Yes No
BOOK char(10) Yes No
DTTM_STAMP PSDATETIME Yes No
CF_SEQNO int Yes No
ACCOUNT char(10) Yes No
ALTACCT char(10) Yes No
DEPTID char(10) Yes No
DISTRIBUTION_TYPE char(2) Yes No
TRANS_TYPE char(3) Yes No
ACCOUNTING_DT PSDATE Yes No
IU_MAP_KEY smallint Yes No
OPERATING_UNIT char(8) Yes No
PRODUCT char(6) Yes No
FUND_CODE char(5) Yes No
CLASS_FLD char(5) Yes No
PROGRAM_CODE char(5) Yes No
BUDGET_REF char(8) Yes No
AFFILIATE char(5) Yes No
AFFILIATE_INTRA1 char(10) Yes No
AFFILIATE_INTRA2 char(10) Yes No
PROJECT_ID char(15) Yes No
CATEGORY char(5) Yes No
COST_TYPE char(1) Yes No
TRANS_CODE char(5) Yes No
TRANS_IN_OUT char(1) Yes No
CHARTFIELD1 char(10) No No
CHARTFIELD2 char(10) No No
CHARTFIELD3 char(10) No No
ARCHIVE_ID char(8) No No
ARCHIVE_DT PSDATE No No
APPL_JRNL_ID char(10) No No
AMOUNT decimal(26,3) No No
JOURNAL_ID char(10) No No
JOURNAL_DATE PSDATE No No
JOURNAL_LINE int No No
PROCESS_INSTANCE decimal(10) No No
GL_DISTRIB_STATUS char(1) No No
OPRID char(30) No No
LEDGER_GROUP char(10) No No
LEDGER char(10) No No
FISCAL_YEAR smallint No No
ACCOUNTING_PERIOD smallint No No
BUSINESS_UNIT_GL char(5) No No
BUSINESS_UNIT_PC char(5) No No
PC_DISTRIB_STATUS char(1) No No
CURRENCY_CD char(3) No No
TXN_CURRENCY_CD char(3) No No
TXN_AMOUNT decimal(26,3) No No
RATE_MULT decimal(15,8) No No
RATE_DIV decimal(15,8) No No
RT_TYPE char(5) 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
ALLOC_RUN char(1) No No
IU_ANCHOR_FLG char(1) No No
IU_SYS_TRAN_CD char(8) No No
IU_TRAN_CD char(8) No No
IUT_JOURNAL_ID char(30) No No
TRANSFER_BU char(5) No No
TRANSFER_ASSET_ID char(12) No No
TRANSFER_BOOK char(10) No No
REVERSE_STATUS char(1) No No
REVERSE_DTTM_STAMP PSDATETIME No No
Index
Name Type Unique Member
PS_DIST_LN_ARCH PK Yes
PS0DIST_LN_ARCH IE1 No
PSADIST_LN_ARCH IE2 No
PSBDIST_LN_ARCH IE3 No
PSCDIST_LN_ARCH IE4 No
PSWDIST_LN_ARCH IE5 No
Member(s) of "PS_DIST_LN_ARCH" Index
BUSINESS_UNIT
ASSET_ID
BOOK
DTTM_STAMP
CF_SEQNO
ACCOUNT
ALTACCT
DEPTID
DISTRIBUTION_TYPE
TRANS_TYPE
ACCOUNTING_DT
IU_MAP_KEY
OPERATING_UNIT
PRODUCT
FUND_CODE
CLASS_FLD
PROGRAM_CODE
BUDGET_REF
AFFILIATE
AFFILIATE_INTRA1
AFFILIATE_INTRA2
PROJECT_ID
CATEGORY
COST_TYPE
TRANS_CODE
TRANS_IN_OUT
Member(s) of "PS0DIST_LN_ARCH" Index
JOURNAL_ID
BUSINESS_UNIT
ASSET_ID
BOOK
DTTM_STAMP
CF_SEQNO
ACCOUNT
ALTACCT
DEPTID
DISTRIBUTION_TYPE
TRANS_TYPE
ACCOUNTING_DT
IU_MAP_KEY
OPERATING_UNIT
PRODUCT
FUND_CODE
Member(s) of "PSADIST_LN_ARCH" Index
PROCESS_INSTANCE
Member(s) of "PSBDIST_LN_ARCH" Index
APPL_JRNL_ID
BUSINESS_UNIT
BOOK
GL_DISTRIB_STATUS
ACCOUNTING_DT
Member(s) of "PSCDIST_LN_ARCH" Index
BUSINESS_UNIT
ASSET_ID
Member(s) of "PSWDIST_LN_ARCH" Index
BUSINESS_UNIT
ASSET_ID
BOOK
DTTM_STAMP
CF_SEQNO
ACCOUNT
ALTACCT
DEPTID
DISTRIBUTION_TYPE
TRANS_TYPE
ACCOUNTING_DT
IU_MAP_KEY
OPERATING_UNIT
PRODUCT
FUND_CODE
CLASS_FLD

Published December 16, 2006