PeopleSoft 9
Asset Management

Table Name AM_GL_RECON_TBL

Table Description
AM_GL_RECON_TBL
Columns
Name Datatype Is PK Is FK
OPRID char(30) Yes No
RUN_ID char(25) Yes No
BUSINESS_UNIT char(5) Yes No
ASSET_ID char(12) Yes No
BOOK char(10) Yes No
CF_SEQNO int Yes No
CATEGORY char(5) Yes No
COST_TYPE char(1) Yes No
OPERATING_UNIT char(8) Yes No
PRODUCT char(6) Yes No
FUND_CODE char(5) Yes No
CLASS_FLD char(5) Yes No
PROGRAM_CODE char(5) Yes No
BUDGET_REF char(8) Yes No
AFFILIATE char(5) Yes No
AFFILIATE_INTRA1 char(10) Yes No
AFFILIATE_INTRA2 char(10) Yes No
DEPTID char(10) Yes No
PROJECT_ID char(15) Yes No
TRANS_TYPE char(3) Yes No
CHARTFIELD1 char(10) No No
CHARTFIELD2 char(10) No No
CHARTFIELD3 char(10) No No
DESCR char(30) No No
COST decimal(26,3) No No
CURRENCY_CD char(3) No No
LOCATION char(10) No No
ASSET_CLASS char(10) No No
PROFILE_ID char(10) No No
TRANS_IN_OUT char(1) No No
ACCUM_DEPR decimal(26,3) No No
DEPR_YTD decimal(26,3) No No
DEPR_LTD decimal(26,3) No No
AS_OF_DATE PSDATE No No
Index
Name Type Unique Member
PS_AM_GL_RECON_TBL PK Yes
PSWAM_GL_RECON_TBL IE1 No
Member(s) of "PS_AM_GL_RECON_TBL" Index
OPRID
RUN_ID
BUSINESS_UNIT
ASSET_ID
BOOK
CF_SEQNO
CATEGORY
COST_TYPE
OPERATING_UNIT
PRODUCT
FUND_CODE
CLASS_FLD
PROGRAM_CODE
BUDGET_REF
AFFILIATE
AFFILIATE_INTRA1
AFFILIATE_INTRA2
DEPTID
PROJECT_ID
TRANS_TYPE
Member(s) of "PSWAM_GL_RECON_TBL" Index
OPRID
RUN_ID
BUSINESS_UNIT
ASSET_ID
BOOK
CF_SEQNO
CATEGORY
COST_TYPE
OPERATING_UNIT
PRODUCT
FUND_CODE
CLASS_FLD
PROGRAM_CODE
BUDGET_REF
AFFILIATE
AFFILIATE_INTRA1

Published December 16, 2006