PeopleSoft 9
Asset Management

Table Name LTAX_INFO2_TBL

Table Description
LTAX_INFO2_TBL
Columns
Name Datatype Is PK Is FK
BUSINESS_UNIT char(5) Yes Yes
ASSET_ID char(12) Yes Yes
FISCAL_YEAR smallint Yes Yes
DTTM_STAMP PSDATETIME Yes No
TRANS_DT PSDATE Yes No
TRANS_TYPE char(3) Yes No
TRANS_CODE char(5) Yes No
TRANS_IN_OUT char(1) Yes No
COMPLETE_PARTIAL char(1) Yes No
DISPOSAL_CODE char(1) Yes No
ACTIVITY_SW smallint No No
RETIRE_SW smallint No No
LTAX_OFFICE_CODE char(5) No No
ASSET_RETURN_TYPE char(1) No No
ACQUISITION_DT PSDATE No No
IN_SERVICE_DT PSDATE 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
TRANSFER_BU char(5) No No
TRANSFER_ASSET_ID char(12) No No
TRF_LTAX_OFFICE_CD char(5) No No
TRF_RETURN_TYPE char(1) No No
OPRID char(30) No No
FROM_CUR char(3) No No
Index
Name Type Unique Member
PS_LTAX_INFO2_TBL PK Yes
Member(s) of "PS_LTAX_INFO2_TBL" Index
BUSINESS_UNIT
ASSET_ID
FISCAL_YEAR
DTTM_STAMP
TRANS_DT
TRANS_TYPE
TRANS_CODE
TRANS_IN_OUT
COMPLETE_PARTIAL
DISPOSAL_CODE

Published December 16, 2006