PeopleSoft 9
Asset Management

Table Name INSTALLATION_BI

Table Description
INSTALLATION_BI
Columns
Name Datatype Is PK Is FK
ADD_DTTM PSDATETIME Yes No
INVOICE_NUMBERING char(1) No No
IVC_NUM_ID char(8) No No
TMP_IVC_NUM_ID char(8) No No
PNLSERIES_OPTION char(1) No No
BI_PNLSERIES_ID char(8) No No
GL_OPT char(1) No No
GL_LVL char(1) No No
AR_OPT char(1) No No
AR_LVL char(1) No No
AR_DST_OPT char(1) No No
DFR_REV_PRORATION char(1) No No
DFR_ACCTG_DT_CD char(1) No No
ENABLE_DFR_REV_FLG char(1) No No
DFR_MID_PERIOD_DAY smallint No No
COUNTRY char(3) No No
CURRENCY_CD_XEU char(3) No No
MAX_ROWS_SCROLL int No No
BI_ENTRY_MAX_ROWS int No No
PROCESS_INSTANCE decimal(10) No No
DTTM_STAMP PSDATETIME No No
IVC_PRO_TOGGLE char(1) No No
COMBO_EDIT_FLG char(1) No No
LAST_INTFC_ID int No No
DATA_PARTITION_OPT char(1) No No
ENABLE_FAX_IVC char(1) No No
SETID_FAX char(5) No No
FAX_ID char(10) No No
LAST_UPDATE_DTTM PSDATETIME No No
LAST_MAINT_OPRID char(30) No No
MANUAL_LIN_NUM_FLG char(1) No No
ACCTG_DISP_OPT char(1) No No
TEMPLATE_ID CHAR(30) No No
BI_HYPERLINK_OPT char(1) No No
BILL_LINE_ADD smallint No No
ENABLE_EFFDT_FLG char(1) No No
BUS_UNIT_LOOP_OPT char(1) No No
Index
Name Type Unique Member
PSAINSTALLATION_BI PK Yes
Member(s) of "PSAINSTALLATION_BI" Index
ADD_DTTM

Published December 16, 2006