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 |