PeopleSoft 9
Asset Management

Table Name LTAX_INFO1_TBL

Table Description
LTAX_INFO1_TBL
Columns
Name Datatype Is PK Is FK
BUSINESS_UNIT char(5) Yes Yes
ASSET_ID char(12) Yes Yes
FISCAL_YEAR smallint Yes No
ACQUISITION_DT PSDATE No No
IN_SERVICE_DT PSDATE No No
NEW_USED_CODE char(1) No No
LTAX_OFFICE_CODE char(5) No No
ASSET_RETURN_TYPE char(1) No No
EXCEPTION_RATE1 smallint No No
EXCEPTION_RATE2 smallint No No
QUANTITY decimal(15,4) No No
COST decimal(26,3) No No
THEORETICAL_NBV decimal(26,3) No No
ASSESSMENT_VALUE decimal(26,3) No No
APPLIED_AMOUNT decimal(26,3) No No
TAXABLE_STD_AMOUNT decimal(26,3) No No
OPRID char(30) No No
FROM_CUR char(3) No No
Index
Name Type Unique Member
PS_LTAX_INFO1_TBL PK Yes
Member(s) of "PS_LTAX_INFO1_TBL" Index
BUSINESS_UNIT
ASSET_ID
FISCAL_YEAR

Published December 16, 2006