PeopleSoft 9
Asset Management

Table Name INTFC_BI_AEDS

Table Description
INTFC_BI_AEDS
Columns
Name Datatype Is PK Is FK
INTFC_ID int Yes Yes
INTFC_LINE_NUM int Yes Yes
TRANS_TYPE_BI char(4) Yes Yes
TRANS_TYPE_BI_SEQ smallint Yes Yes
ACCT_ENTRY_TYPE char(3) No No
LOAD_STATUS_BI char(3) No No
ERROR_STATUS_BI char(4) No No
BUSINESS_UNIT char(5) No No
INVOICE char(22) No No
LINE_SEQ_NUM int No No
LINE_DST_SEQ_NUM smallint No No
DST_ID char(10) No No
DST_ID_DFR char(10) No No
DISC_SUR_LVL smallint No No
DISC_SUR_INDICATOR char(1) No No
DISC_SUR_ID char(15) No No
DESCR char(30) No No
AMOUNT decimal(26,3) No No
PERCENTAGE decimal(5,2) No No
BI_CURRENCY_CD char(3) No No
BASE_CURRENCY char(3) No No
BUSINESS_UNIT_GL char(5) No No
BUSINESS_UNIT_TO char(5) No No
TARGET_INVOICE char(22) 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
STATISTIC_AMOUNT decimal(15,2) No No
BUDGET_DT PSDATE No No
PPRC_PROMO_CD char(20) No No
MERCH_TYPE char(10) No No
SETID char(5) No No
OPEN_ITEM_KEY char(30) No No
JRNL_LN_REF char(10) No No
PROCESS_INSTANCE decimal(10) No No
ADD_DTTM PSDATETIME No No
LAST_UPDATE_DTTM PSDATETIME No No
Index
Name Type Unique Member
PS_INTFC_BI_AEDS PK Yes
Member(s) of "PS_INTFC_BI_AEDS" Index
INTFC_ID
INTFC_LINE_NUM
TRANS_TYPE_BI
TRANS_TYPE_BI_SEQ

Published December 16, 2006