PeopleSoft 9
Asset Management

Table Name INSTALLATION

Table Description
INSTALLATION
Columns
Name Datatype Is PK Is FK
SYNCID int Yes No
COUNTRY char(3) No No
EXCHNG_TO_CURRENCY char(3) No No
EXCHNG_TO_RT_TYPE char(5) No No
INSTALLATION_CD char(5) No No
AM char(1) No No
AP char(1) No No
AR char(1) No No
AUC char(1) No No
BI char(1) No No
CA char(1) No No
CAT char(1) No No
CCM char(1) No No
CFG char(1) No No
CP char(1) No No
DEAL char(1) No No
DP char(1) No No
EB char(1) No No
EG char(1) No No
ES char(1) No No
EX char(1) No No
FO char(1) No No
FO_PBM char(1) No No
FP char(1) No No
GL char(1) No No
GM char(1) No No
GVC char(1) No No
HR char(1) No No
INV char(1) No No
IP char(1) No No
ITAM char(1) No No
ITK char(1) No No
MG char(1) No No
MPA char(1) No No
OM char(1) No No
PC char(1) No No
PGM char(1) No No
PM char(1) No No
PO char(1) No No
PV char(1) No No
QS char(1) No No
RE char(1) No No
RISK char(1) No No
RS char(1) No No
SCMT char(1) No No
SP char(1) No No
SPL char(1) No No
TD char(1) No No
TE char(1) No No
TP char(1) No No
TR char(1) No No
TPM char(1) No No
WO char(1) No No
WR char(1) No No
CCU char(1) No No
PPALM char(1) No No
PPESA char(1) No No
PPFIN char(1) No No
PPSCM char(1) No No
ADDRESS_VENDOR char(1) No No
TAX_VENDOR char(1) No No
JETFORMS char(1) No No
DC_INSTALLED char(1) No No
MULTIBOOK_FLAG char(1) No No
ALTACCT_OPTN char(1) No No
COMMITMENT_CNTL_AP char(1) No No
COMMITMENT_CNTL_AR char(1) No No
COMMITMENT_CNTL_BI char(1) No No
COMMITMENT_CNTL_EX char(1) No No
COMMITMENT_CNTL_GL char(1) No No
COMMITMENT_CNTL_GM char(1) No No
COMMITMENT_CNTL_IN char(1) No No
COMMITMENT_CNTL_PC char(1) No No
COMMITMENT_CNTL_PO char(1) No No
COMMITMENT_PROCARD char(1) No No
BUDG_DT_DFLT_OPT char(1) No No
RVSL_DT_OPTN char(1) No No
PROC_PART_GL char(1) No No
SYNCDTTM PSDATETIME No No
Index
Name Type Unique Member
PSAINSTALLATION PK Yes
Member(s) of "PSAINSTALLATION" Index
SYNCID

Published December 16, 2006