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 |