Real Estate Transaction Management

Document Sample
Real Estate Transaction Management Powered By Docstoc
					                                                                                           Asset Management Required Fields

       Field Name                            Long Name                        Use and Processing Considerations               No.                 Tables Updated      Defaults from    Agency     Column for
                                                                                                                           Characters                                 Asset Profile   Provided    Agency Use

Financial
BUSINESS_UNIT                      Business Unit                           Business unit is a high level unique                           BOOK, COST, DEPRECIATION,
                                                                           identifier. Each agency is assigned a five                     RETIREMENT, OPEN_TRANS
                                                                           digit business unit, the agency number
                                                                           followed by two zeros.                               5                                                        X
BOOK                               Asset Book Name                         Book will default in from the profile setup.                   BOOK, COST, DEPRECIATION,
                                                                           Choices are capitalize or noncapitalize.             10        RETIREMENT, OPEN_TRANS           X
OPERATING_UNIT                     Financial Reporting                     Agency provided ChartField used for                            COST, DEPRECIATION
                                                                           Financial Reporting.                                 8                                                        X
DEPTID                             ORGCode                                 Agency provided org code                                       COST, DEPRECIATION
                                                                                                                                10                                                       X
FUND_CODE                          Fund Code                               Agency provided fund                                  5        COST, DEPRECIATION                             X
CLASS_FLD                          Appropriation                           Agency provided appropriation                                  COST, DEPRECIATION
                                                                                                                                 5                                                       X
CATEGORY                           Asset Category                          Agency provided from listing of asset                          COST, DEPRECIATION
                                                                           categories (i.e. LIMPD = land improvements,
                                                                           BIMPD = buildings).                                   5                                         X
METHOD                             Depreciation Method                     Identifies the depreciation method to be                       BOOK
                                                                           used. Valid values are in the translate table.
                                                                           Defaults from asset profile.                          2
IN_SERVICE_DT                      In Service Date                         Agency provided date placed in service              Date       BOOK                                           X
DEPR_STATUS                        Depreciation Status                     Agency provided depreciable or                                 BOOK
                                                                           nondepreciable (D or N)                               1                                                       X
LIFE                               Life                                    Agency provided useful life (years times 12),                  BOOK
                                                                           Asset profile listing has initial useful life in
                                                                           years.                                           Any length                                     X
SALVAGE_VALUE                      Salvage Value                           Agency provided residual value that is to be                   COST
                                                                           used in the depreciation calculation.                26                                                       X
QUANTITY                           Asset Quantity                          Agency provided quantity of the asset              System      COST
                                                                                                                            allows 15,
                                                                                                                             however
                                                                                                                             agencies
                                                                                                                            should list
                                                                                                                            each asset
                                                                                                                            separately                                                   X
DEPR                               Depreciation Amount                     The depreciation amount of this transaction.                   DEPRECIATION
                                                                                                                                26                                                       X
                                                                                                                                                                                                 8/1/20116:52 PM
         D:\Docstoc\Working\pdf\9eaa55ee-59bb-4fa8-90db-e338dc945f9d.xls                                                                                                                             Page 1 of 36
                                                                                           Asset Management Required Fields

       Field Name                           Long Name                        Use and Processing Considerations                  No.               Tables Updated   Defaults from    Agency     Column for
                                                                                                                             Characters                            Asset Profile   Provided    Agency Use

COST                              Cost                                    Cost of asset                                         26        COST                                        X
Physical A
ASSET_TYPE                        Asset Type                              Asset Classification.                                           ASSET
                                                                                                                                 3                                      X
ASSET_SUBTYPE                     Asset Subtype                           Asset Classification.                                           ASSET
                                                                                                                                15                                      X
DESCR                             Description                             A description of the asset. 30 characters.            30        ASSET                                       X
DESCRSHORT                        Short Description                       A short description of the asset. 10                            ASSET
                                                                          characters.                                           10                                                    X
FINANCIAL_ASSET_SW Capitalized Asset?                                     Identifies whether this asset has been                          ASSET
                                                                          capitalized. Valid values are „Y‟ for yes and
                                                                          „N‟ for no. If an asset has not been
                                                                          capitalized, there can be no financial
                                                                          information or transactions for the asset
                                                                          (BOOK, COST, DEPRECIATION,
                                                                          RETIREMENT, OPEN_TRANS, etc.).
                                                                          However, there can be acquisition detail
                                                                          information (ASSET_ACQ_DET). Since
                                                                          acquisition detail is not tied to accounting
                                                                          events - it is an audit trail, you can store as
                                                                          much expense information as you would like.
                                                                                                                                 1                                                    X
ACQUISITION_DT                    Acquisition Date                        Identifies the acquisition date of this asset.                  ASSET
                                                                          This is a memo only field and is not used for
                                                                          any calculations.                                    Date                                                   X
PROFILE_ID                        Asset Profile ID                        Identifies the profile to be used to default the                ASSET
                                                                          book information on an asset add. This field
                                                                          is only used if the
                                                                          INTFC_FIN.DEFAULT_PROFILE_SW = „Y‟.
                                                                          When that field is set to „Y‟ then Profile ID
                                                                          must be populated with a valid, effective-
                                                                          dated Profile ID on the PROFILE_DET_TBL.
                                                                                                                                10                                                    X




                                                                                                                                                                                              8/1/20116:52 PM
        D:\Docstoc\Working\pdf\9eaa55ee-59bb-4fa8-90db-e338dc945f9d.xls                                                                                                                           Page 2 of 36
                                                                                          Asset Management Required Fields

     Field Name                            Long Name                        Use and Processing Considerations                 No.                  Tables Updated   Defaults from    Agency     Column for
                                                                                                                           Characters                               Asset Profile   Provided    Agency Use

ASSET_CLASS                      Asset Class                             Identifies the asset class that this asset falls                  ASSET
                                                                         into. This is just another way to categorize
                                                                         your assets. This field must be a valid value
                                                                         on the ASSET_CLASS_TBL. This table is
                                                                         maintained in the Establish Asset Processing
                                                                         menu online.                                            10                                      X
CAPITALIZATION_SW                Capitalized?                            Identifies whether this particular transaction                    ASSET_ACQ_DET
                                                                         should be capitalized. Valid values are on
                                                                         the translate table. This must be set to 1, 2,
                                                                         3, or 4 in order for acquisition detail records
                                                                         to be inserted.                                          1                                      X
LOCATION_EFFDT                   Location Effective Date                 The date the location of this asset became                        ASSET_LOCATION
                                                                         effective. If the transaction is an add, the
                                                                         date should be the same as the trans_dt. It is
                                                                         very important that this field be formatted
                                                                         with a valid date on an add transaction,
                                                                         whether or not the location is known.
                                                                         Transaction loader uses this when inserting
                                                                         location entries. If it is null, a location entry is
                                                                         not loaded.                                            Date                                                   X
LOCATION_EFFSEQ                  Location Effective                      The sequence number of the location. This                         ASSET_LOCATION
                                 Sequence                                will be zero unless the asset has been in
                                                                         more than one location for a given effective
                                                                         date.                                                Any length                                               X
LOCATION                         Location                                The location of this asset. Should be a valid                     PI_ASSET_HIST
                                                                         value on the LOCATION_TBL.                              10                                                    X
Physical B
ASSET_STATUS                     Asset Status                            The status of the asset. The valid values are                     ASSET
                                                                         in the translate table. This field is generally
                                                                         for information purposes only. No accounting
                                                                         events are tied to this status.                         1                                                     X
BUSINESS_UNIT                    Business Unit                           Identifies the business unit of the transaction                   ASSET_ATTRIBUTE,
                                                                         to be processed. This field is required.                          ASSET_COMMENTS,
                                                                                                                                           ASSET_LICENSE,
                                                                                                                                 5         ASSET_WARRANTY                X
                                                                                                                                                                                               8/1/20116:52 PM
       D:\Docstoc\Working\pdf\9eaa55ee-59bb-4fa8-90db-e338dc945f9d.xls                                                                                                                             Page 3 of 36
                                                                                      Asset Management Optional Fields

         Field Name                                 Long Name                   Use and Processing Considerations                   No.          Tables Updated    Column for Agency Use
                                                                                                                                 Characters
Financial
COST_TYPE                               Cost Type                          An asset ChartField that is used to derive the GL                  COST, DEPRECIATION
                                                                           accounts for any given financial transaction.
                                                                                                                                     1
IN_SERVICE_PD                           In Service Period                  The calendar period in which the in service date                   BOOK
                                                                           falls. If this field is not populated, the
                                                                           depreciation calculation program will calculate it.
                                                                                                                                 Any length
IN_SERVICE_FY                           In Service Fiscal Year             The calendar fiscal year in which the in service                   BOOK
                                                                           date falls. If this field is not populated, the
                                                                           depreciation calculation program will calculate it.
                                                                                                                                 Any length
PROPERTY_TYPE                           Property Type                      Identifies the type of property the asset book                     BOOK
                                                                           represents. Valid values are „R‟ for real property
                                                                           and „P‟ for personal property.                            1
UOP_ID                                  Units of Production ID             Represents the ID of the Units of Production                       BOOK
                                                                           control table that specifies the units of
                                                                           production for this asset book.                          10
GROUP_ASSET_ID                          Group Asset ID                     Used to identify which group asset group                           BOOK, COST,
                                                                           members report to.                                                 DEPRECIATION,
                                                                                                                                    12        OPEN_TRANS
UD_METHOD_ID                            Method ID                          Identities the user-defined depreciation method                    BOOK
                                                                           to be used. This field must reference a valid user-
                                                                           defined depreciation method. The user defined
                                                                           methods are specified in the Establish Asset
                                                                           Processing window.                                        5
FUTURE_DEPR_YEARS                       Number of Future                   Number of future years of depreciation                             BOOK
                                        Depreciation Years                                                                       Any length
SALVAGE_VAL                             Salvage Value                      Asset residual value for future transactions             26        BOOK
SALVAGE_PCT                             Salvage Percent                    Used to calculate salvage value as a percentage                    BOOK
                                                                           of the cost.                                             15
PRODUCT                                 Product                            A ChartField used for product                             6        COST, DEPRECIATION
PROGRAM_CODE                            Program Code                       A ChartField used for program code                        5        COST, DEPRECIATION
CHARTFIELD1                             Responsibility Area                A ChartField used for responsibility area                10        COST, DEPRECIATION
CHARTFIELD2                             Function                           A ChartField used for function                           10        COST, DEPRECIATION
CHARTFIELD3                             Site                               A ChartField used for site                               10        COST, DEPRECIATION
                                                                                                                                                                                           8/1/20116:52 PM
         D:\Docstoc\Working\pdf\9eaa55ee-59bb-4fa8-90db-e338dc945f9d.xls                                                                                                                       Page 4 of 36
                                                                                    Asset Management Optional Fields

       Field Name                                  Long Name                   Use and Processing Considerations              No.        Tables Updated    Column for Agency Use
                                                                                                                           Characters
PROJECT_ID                             Project                            A ChartField used for project                       15      COST, DEPRECIATION
FUND_CODE                              Fund Code                          Agency provided fund.                                       ASSET_ACQ_DET

                                                                                                                              5
CLASS_FLD                              Appropriation                      Agency provided appropriation.                             ASSET_ACQ_DET

                                                                                                                              5
PROGRAM_CODE                           Program Code                       Agency provided program code.                       5      ASSET_ACQ_DET
CHARTFIELD1                            Responsibility Area                A ChartField designated to represent                       ASSET_ACQ_DET
(Responsibility Center)                                                   responsibility center.                              10
CHARTFIELD2 (Function)                 Function                           A ChartField designated to represent function.      10     ASSET_ACQ_DET
CHARTFIELD3 (Site)                     Site                               A ChartField designated to represent site.          10     ASSET_ACQ_DET




                                                                                                                                                                                   8/1/20116:52 PM
        D:\Docstoc\Working\pdf\9eaa55ee-59bb-4fa8-90db-e338dc945f9d.xls                                                                                                                Page 5 of 36
                                                                                   Asset Management Optional Fields

      Field Name                                 Long Name                   Use and Processing Considerations                  No.          Tables Updated     Column for Agency Use
                                                                                                                             Characters
Physical A
PARENT_ID                            Parent Asset ID                    Used to identify the parent of this asset.                        ASSET, PARENT_ASSET
                                                                        Parent/Child relationships can be built using the
                                                                        Parent ID. A parent can be an existing asset (the
                                                                        parent ID is the asset ID of another asset) or a
                                                                        “virtual” asset (the parent ID is not an actual
                                                                        asset ID). In any case the parent ID should be a
                                                                        valid entry on the record Parent_Asset. If an
                                                                        entry does not exist on Parent_Asset for the
                                                                        parent ID, then Transaction Loader will create
                                                                        one.                                                    12
PARENT_DESCR                         Parent Asset Description           The description of the parent asset that will be                  PARENT_ASSET
                                                                        entered on the table parent_asset if an entry
                                                                        does not exist.                                         30
PARENT_DESCRLONG50                   Parent Asset Long                  The long description of the parent asset that will                PARENT_ASSET
                                     Description                        be entered on the table parent_asset if an entry
                                                                        does not exist.                                         50
COMPONENT_OF_ID                      Component of Asset                 Used to establish Asset Components Structure.           12        ASSET
ASSET_ASSIGNED_TO                    Asset Assigned To                                                                          12        ASSET
TAGGABLE_SW                          Taggable Asset Switch              Indicates whether the asset is taggable or not.                   ASSET
                                                                        Valid values are „Y‟ or „N‟. A tag is the physical
                                                                        tag that is affixed to an asset.                         1
TAG_NUMBER                           Tag Number                         The tag number that is assigned to this asset.          12        ASSET
REPLACE_SW                           Replacement Asset?                 Identifies whether this is a replacement asset.          1        ASSET
REPLACE_ASSET_ID                     Replaced Asset ID                  If this is a replacement asset, what is the Asset                 ASSET
                                                                        ID of the asset that was replaced.                      12
NEW_ASSET_SW                         New Asset?                         Was this asset acquired new? Valid values are                     ASSET
                                                                        „Y‟ or „N‟.                                              1
AVAIL_SW                             Resale?                            Is this asset available for resale? Valid values                  ASSET
                                                                        are „Y‟ or „N‟. When marked „Y‟ this field can be
                                                                        queried to identify assets that are not being used
                                                                        by their custodians and are available for resale
                                                                        or internal transfer. A PS/Query is shipped with
                                                                        Asset Management as an example.
                                                                                                                                 1

                                                                                                                                                                                        8/1/20116:52 PM
      D:\Docstoc\Working\pdf\9eaa55ee-59bb-4fa8-90db-e338dc945f9d.xls                                                                                                                       Page 6 of 36
                                                                                    Asset Management Optional Fields

      Field Name                                  Long Name                   Use and Processing Considerations                   No.          Tables Updated   Column for Agency Use
                                                                                                                               Characters
AVAIL_CONTACT                         Availability Contact               If the asset is available, who should be                           ASSET
                                                                         contacted if someone is interested in the asset.
                                                                                                                                  30
AVAIL_PHONE                           Availability Phone                 Phone number of the contact above.                       12        ASSET
ACQUISITION_CD                        Acquisition Code                   Identifies how this asset was acquired. The valid                  ASSET
                                                                         values are in the translate table.                        1
FINANCING_CD                          Financing Code                     User defined financing code. Should be a valid                     ASSET
                                                                         value on the FINANCE_CD_TBL.                              5
CAP_NUM                               Capital Acquisition Plan           Combined with CAP_SEQUENCE this field                              ASSET
                                      Number                             identifies the C.A.P. that this asset is associated
                                                                         with. Capital Acquisition Planning (C.A.P.) is a
                                                                         way of specifying asset budgets or
                                                                         appropriations.                                          15
MFG_ID                                Manufacturer ID                    Manufacturer Id of the Asset.                            50        ASSET
MANUFACTURER                          Manufacturer Name                  Manufacturer of the asset.                               30        ASSET
MODEL                                 Model                              Model of the asset.                                      30        ASSET
PROD_VERSION                          Product Version                    Product version of the asset.                            10        ASSET
SERIAL_ID                             Serial ID                          Serial number of the asset.                              20        ASSET
PRODUCTION_DT                         Production Date                    Production date of the asset.                           Date       ASSET
PLANT                                 Manufacturing Plant                Plant that manufactured the asset.                       30        ASSET
MANUFACTUR_CONTACT                    Manufacturing Contact              Contact at the plant that manufactured the asset.                  ASSET
                                                                                                                                  30
CAP_SEQUENCE                          C.A.P. Sequence                    Combined with CAP_NUM this field identifies the                    ASSET
                                                                         C.A.P. that this asset is associated with. Capital
                                                                         Acquisition Planning (C.A.P.) is a way of
                                                                         specifying asset budgets or appropriations.
                                                                                                                               Any length
REPLACEMENT_COST                      Replacement Cost                   Estimated replacement cost of the asset. This                      ASSET
                                                                         field can be processed by the Indexing feature in
                                                                         Asset Management. The indexing feature only
                                                                         updates replacement cost. It does not perform
                                                                         the initial population of this field.
                                                                                                                                  26
LEASE_ASSET_ID                        Lease Asset ID                     If this is a non-capitalized asset and is                          ASSET
                                                                         associated with a lease, this is the Asset ID of
                                                                         that lease. This field must identify a capitalized
                                                                         asset ID with an acquisition code of leased.             12
                                                                                                                                                                                        8/1/20116:52 PM
       D:\Docstoc\Working\pdf\9eaa55ee-59bb-4fa8-90db-e338dc945f9d.xls                                                                                                                      Page 7 of 36
                                                                                    Asset Management Optional Fields

       Field Name                                 Long Name                   Use and Processing Considerations                     No.          Tables Updated   Column for Agency Use
                                                                                                                                 Characters
INDEX_NAME                            Index Name                         Identifies which index to use in revaluing asset                     ASSET
                                                                         cost. DFS will be using for buildings.                     20
INDEX_DETAIL_NAME                     Index Detail Name                  Same as INDEX_NAME. DFS will be using for                            ASSET
                                                                         buildings.                                                 35
LAST_INDEX_VALUE                      Last Index Value                   Last index value used to revalue assets, such as                     ASSET
                                                                         the Consumer Price Index. DFS Use.                         26
ACQUISITION_DESCR                     DESCR field for                    A description for the acquisition detail for this                    ASSET_ACQ_DET
                                      ACQ_DETAIL                         transaction.                                               30
REFERENCE_ID                          Reference Number                   A general reference number associated with the                       ASSET_ACQ_DET
                                                                         acquisition of this asset.                                 10
INVOICE_DT                            Invoice Date                       Represents the date of the invoice associated                        ASSET_ACQ_DET
                                                                         with this transaction.                                    Date
VENDOR_ID                             Vendor ID                          The vendor ID from Accounts Payable or                               ASSET_ACQ_DET
                                                                         Purchasing that is associated with this
                                                                         transaction.                                               10
VENDOR_NAME                           Vendor Name                        The name of the vendor associated with this                          ASSET_ACQ_DET
                                                                         transaction. This would only be used when an
                                                                         external purchasing or payable system is used.
                                                                                                                                    30
INVOICE_ID                            Invoice Number                     The invoice number of the invoice associated                         ASSET_ACQ_DET
                                                                         with this transaction.                                     30
TXN_AMOUNT                            Transaction Amount                 Amount in Transaction Currency.                            26        ASSET_ACQ_DET
AMOUNT                                Amount                             The amount of this transaction. This is the                          ASSET_ACQ_DET
                                                                         amount that will be capitalized if that is what has
                                                                         been requested. Note that this field is NOT used
                                                                         by Transaction Loader for inserting cost. It is the
                                                                         amount field on Acq Detail. It should match the
                                                                         COST field on INTFC_FIN.                                   26
QUANTITY                              Quantity                           The quantity of this transaction. This is the                        ASSET_ACQ_DET
                                                                         quantity that will be capitalized if that is what has
                                                                         been requested. Note that this field is NOT used
                                                                         by Transaction Loader for inserting cost. It is the
                                                                         quantity field on Acq Detail. It should match the
                                                                         QUANTITY field on INTFC_FIN.
                                                                                                                                    15
FREIGHT_AMT                           Freight Amount                     The amount of freight associated with this                           ASSET_ACQ_DET
                                                                         transaction.                                               26

                                                                                                                                                                                          8/1/20116:52 PM
       D:\Docstoc\Working\pdf\9eaa55ee-59bb-4fa8-90db-e338dc945f9d.xls                                                                                                                        Page 8 of 36
                                                                                      Asset Management Optional Fields

         Field Name                                 Long Name                   Use and Processing Considerations                   No.        Tables Updated   Column for Agency Use
                                                                                                                                 Characters
FREIGHT_AMT_BSE                         Base Freight Amount                Freight Amount in Transaction Currency.                  26      ASSET_ACQ_DET
INV_ITEM_ID                             Inventory Item ID                  Identifies the inventory item ID that this                       ASSET_ACQ_DET
                                                                           transaction is associated with.                          18
OPERATING_UNIT                          Operating Unit                     The operating unit (ChartField) associated with                  ASSET_ACQ_DET
                                                                           this transaction. This field should be the same as
                                                                           the corresponding ChartField on the INTFC_FIN
                                                                           table. See the online ChartField customization
                                                                           topic for further discussion.
                                                                                                                                     8
DEPTID                                  Department                         The department (ChartField) associated with this                 ASSET_ACQ_DET
                                                                           transaction. This field should be the same as the
                                                                           corresponding ChartField on the INTFC_FIN
                                                                           table.                                                   10
PRODUCT                                 Product                            The product (ChartField) associated with this                    ASSET_ACQ_DET
                                                                           transaction This field should be the same as the
                                                                           corresponding ChartField on the INTFC_FIN
                                                                           table.                                                    6
PROJECT_ID                              Project ID                         The project (ChartField) associated with this                    ASSET_ACQ_DET
                                                                           transaction This field should be the same as the
                                                                           corresponding ChartField on the INTFC_FIN
                                                                           table.                                                   15
CATEGORY                                Asset Category                     The category associated with this transaction.                   ASSET_ACQ_DET
                                                                           This field should be the same as the category on
                                                                           the INTFC_FIN table.                                      5
COST_TYPE                               Cost Type                          The cost type associated with this transaction.                  ASSET_ACQ_DET
                                                                           This field should be the same as the cost type
                                                                           on the INTFC_FIN table.                                   1
CUSTODIAN_EFFDT                         Asset Custodian Effective          The date the custodian of this asset became                      ASSET_CUSTODIAN
                                        Date                               effective. If the transaction is an add, the date
                                                                           should be the same as the trans_dt. It is very
                                                                           important that this field be formatted with a valid
                                                                           date on an add transaction, whether or not the
                                                                           custodian is known. Transaction loader uses this
                                                                           when inserting custodian entries. If it is null, no
                                                                           custodian entry is loaded.
                                                                                                                                   Date

                                                                                                                                                                                        8/1/20116:52 PM
         D:\Docstoc\Working\pdf\9eaa55ee-59bb-4fa8-90db-e338dc945f9d.xls                                                                                                                    Page 9 of 36
                                                                                     Asset Management Optional Fields

      Field Name                                    Long Name                   Use and Processing Considerations               No.          Tables Updated   Column for Agency Use
                                                                                                                             Characters
EFFSEQ                                  Effective Sequence                 The sequence number of the custodian. This will                ASSET_CUSTODIAN
                                                                           be zero unless the asset has had more than one
                                                                           custodian for a given effective date.             Any length
CUSTODIAN                               Custodian                          The name of the custodian of this asset.             30        ASSET_CUSTODIAN
EMPLID                                  Asset Custodian Employee           The employee ID of the custodian of this asset.                ASSET_CUSTODIAN
                                        ID                                                                                      11
CUSTODIAN_DEPTID                        Asset Custodian Department The department of the custodian of this asset.                         ASSET_CUSTODIAN


                                                                                                                                10
CUSTODIAN_PROJECT                       Asset Custodian Project     The project associated with the custodian of this                     ASSET_CUSTODIAN
                                                                    asset.                                                      15
OFFSITE_SW                              Offsite?                    Is this asset offsite? Valid values are „Y‟ or „N‟.          1        ASSET_CUSTODIAN
AUTH_STATUS                             Authorization Status        The status of the authorization for this asset to                     ASSET_CUSTODIAN
                                                                    be assigned to this custodian.                               1
AUTHORIZATION_NAME                      Authorization Name          The name of the person will has authorized this                       ASSET_CUSTODIAN
                                                                    asset to be assigned to this custodian.                     30
AUTHORIZATION_DT                        Authorization Date          The date of the authorization for this asset to be                    ASSET_CUSTODIAN
                                                                    assigned to this custodian.                                Date
INVENTORY_DT                            Last Inventory Date         The last date that this asset was inventoried at                      PI_ASSET_HIST
                                                                    this location.                                             Date
PERFORMED_BY                            Performed By                The name of the person who performed the last                         PI_ASSET_HIST
                                                                    inventory.                                                  30
DOCUMENT_ID                             Document                    A reference document ID associated with this                          ASSET_LOCATION
                                                                    asset.                                                      12
LOC_AUTH_STATUS                         Location Authorization      The authorization status for this asset at this                       ASSET_LOCATION
                                        Status                      location.                                                    1
LOC_AUTH_NAME                           Location Authorization Name The name of the person who authorized this                            ASSET_LOCATION
                                                                    asset to be at this location.                               30
LOC_AUTH_DT                             Location Authorization Date The date the authorization was given for this                         ASSET_LOCATION
                                                                    asset to be at this location.                              Date
REPLACE_COST_DT                         Replacement Cost Date       Same as INDEX_NAME.                                        Date       ASSET
GROUP_ASSET_FLAG                        Group Asset Flag            Used for Group Asset Processing.                            1         ASSET
GROUP_ASSET_ID                          Group Asset ID              Used to identify which group asset group                              BOOK, COST,
                                                                    members report to.                                                    DEPRECIATION,
                                                                                                                                12        OPEN_TRANS
RD_PLANT_ASSET                          R&D Plant Asset                    Flag to indicate this asset is used for R&D.          1        ASSET
RD_START_DATE                           R&D Start Date                     Date asset became used for R&D.                     Date       ASSET
                                                                                                                                                                                      8/1/20116:52 PM
         D:\Docstoc\Working\pdf\9eaa55ee-59bb-4fa8-90db-e338dc945f9d.xls                                                                                                                 Page 10 of 36
                                                                                   Asset Management Optional Fields

      Field Name                                  Long Name                   Use and Processing Considerations                  No.          Tables Updated   Column for Agency Use
                                                                                                                              Characters
RD_USE_NBV                            Use NBV for R&D                    Use net book value in gain/loss calculations for                  ASSET
                                                                         R&D assets.                                              1
LAST_INDEX_VALUE                      Last Index Value                   Last index value used to revalue assets, such as                  ASSET
                                                                         the Consumer Price Index.                               26
INCENTIVE_ID                          Incentive ID                       An incentive ID, as would be assigned to a grant.                 ASSET_ACQ_DET
                                                                         Assigned in Projects and sent to Asset
                                                                         Management.                                             10
AM_AST_UD_CHAR1                       User-defined Asset                 For Risk Management Use. To identify risk                         ASSET
                                      character field                    management categories when completing DOA
                                                                         risk management forms.                                  10
SKU                                   Stock Keeping Unit                 Used to identify IT Software                            50        ASSET
UPC_ID                                Uniform Product Code ID            Used to identify IT Software                            18        ASSET
VIN                                   VIN                                Vehicle Identification Number                           18        ASSET
CONVERSION_ID                         Old Asset ID                       Identifies the ID in an old system for this asset.                ASSET
                                                                         We recommend that you do not try to convert
                                                                         your Asset IDs from your old system to AM.              15




                                                                                                                                                                                       8/1/20116:52 PM
       D:\Docstoc\Working\pdf\9eaa55ee-59bb-4fa8-90db-e338dc945f9d.xls                                                                                                                    Page 11 of 36
                                                                                   Asset Management Optional Fields

      Field Name                                 Long Name                   Use and Processing Considerations                     No.          Tables Updated   Column for Agency Use
                                                                                                                                Characters
Physical B
ATTRIBUTE_EFFDT                      Asset Attribute Effective          These next fields relate to the Asset_Attributes                     ASSET_ATTRIBUTE
                                     Date                               record. This is optional information. If you do not
                                                                        populate these fields then a row of asset
                                                                        attribute information will not be created for the
                                                                        asset (thus saving space). You can populate the
                                                                        asset attributes on as many (or as few) assets
                                                                        as you like. It is not an all or nothing proposition.
                                                                        If you are not planning on tracking attributes
                                                                        (color, weight, height, width, length, capacity,
                                                                        power rating) for an asset, then do not populate
                                                                        these fields for that asset. The effective date of
                                                                        the attributes of this asset. If the asset is being
                                                                        added, this should be the same as the trans_dt.
                                                                                                                                  Date
ASSET_COLOR                          Asset Color                 The color of the asset.                                           15        ASSET_ATTRIBUTE
ASSET_WEIGHT                         Asset Weight                The weight of the asset.                                          12        ASSET_ATTRIBUTE
WEIGHT_UM                            Asset Weight Unit of        The unit of measure used for the asset weight.                              ASSET_ATTRIBUTE
                                     Measure                     Should be a valid unit of measure defined on the
                                                                 units of measure table.                                            3
ASSET_HEIGHT                         Asset Height                The height of the asset.                                          12        ASSET_ATTRIBUTE
HEIGHT_UM                            Asset Height Unit of        The unit of measure used for the asset height.                              ASSET_ATTRIBUTE
                                     Measure                     Should be a valid unit of measure defined on the
                                                                 units of measure table.                                            3
ASSET_WIDTH                          Asset Width                 The width of the asset.                                           12        ASSET_ATTRIBUTE
WIDTH_UM                             Asset Width Unit of Measure The unit of measure used for the asset width.                               ASSET_ATTRIBUTE
                                                                 Should be a valid unit of measure defined on the
                                                                 units of measure table.                                            3
ASSET_LENGTH                         Asset Length                The length of the asset.                                          12        ASSET_ATTRIBUTE
LENGTH_UM                            Asset Length Unit of        The unit of measure used for the asset length.                              ASSET_ATTRIBUTE
                                     Measure                     Should be a valid unit of measure defined on the
                                                                 units of measure table.                                            3
ASSET_CAPACITY                       Asset Capacity              The capacity of the asset.                                        12        ASSET_ATTRIBUTE
CAPACITY_UM                          Asset Capacity Unit of      The unit of measure used for the asset capacity.                            ASSET_ATTRIBUTE
                                     Measure                     Should be a valid unit of measure defined on the
                                                                 units of measure table.                                            3
POWER_RATING                         Asset Power Rating          The power rating of the asset.                                    12        ASSET_ATTRIBUTE

                                                                                                                                                                                         8/1/20116:52 PM
      D:\Docstoc\Working\pdf\9eaa55ee-59bb-4fa8-90db-e338dc945f9d.xls                                                                                                                       Page 12 of 36
                                                                                    Asset Management Optional Fields

       Field Name                                 Long Name                   Use and Processing Considerations                    No.          Tables Updated   Column for Agency Use
                                                                                                                                Characters
POWER_RATING_UM                       Asset Power Rating Unit of         The unit of measure used for the asset power                        ASSET_ATTRIBUTE
                                      Measure                            rating. Should be a valid unit of measure defined
                                                                         on the units of measure table.                             3
NAME                                  Name                               The name of the person who entered the                              ASSET_COMMENTS
                                                                         comments.                                                 50
COMMENTS50                            Comments 50 Characters             The comments for the assets. This field is long                     ASSET_COMMENTS
                                                                         on the Asset_Comments record, but is a 50 byte
                                                                         character field here due to database restrictions.
                                                                         You can load additional comments online that
                                                                         can be up to 32k in length.
                                                                                                                                   50
AGENCY_ID                             Agency ID                          These next fields relate to the Asset_License                       ASSET_LICENSE
                                                                         record. It is used to track the license or
                                                                         registration of an asset with a given agency or
                                                                         vendor. An example may be a vehicle
                                                                         registration with the state or software registration
                                                                         with a vendor (like PeopleSoft!). This is optional
                                                                         information. If you do not populate these fields
                                                                         then a row of asset license information will not
                                                                         be created for the asset (thus saving space).
                                                                         You can populate asset license information on
                                                                         as many (or as few) assets as you like. It is not
                                                                         an all or nothing proposition. If you are not
                                                                         planning on tracking license information for an
                                                                         asset, then do not populate these fields for that
                                                                         asset. This field is the agency that the asset is
                                                                         registered with and is mutually exclusive of the
                                                                         asset license vendor ID. Should be a valid value
                                                                         on the Agency_Tbl record.
                                                                                                                                   20
LICENSE_VENDOR_ID                     Asset License Vendor ID            This is the vendor that the asset is registered                     ASSET_LICENSE
                                                                         with and is mutually exclusive with the agency
                                                                         ID. Should be a valid value on the VNDR_FS
                                                                         record.                                                   25
REGISTRATION_NO                       Registration Number                The registration number for the asset.                    25        ASSET_LICENSE
INSPECTION_SW                         Inspection Required?               Is an inspection of the asset required? Valid                       ASSET_LICENSE
                                                                         values are „Y‟ or „N‟.                                    1
LIC_START_DT                          License Effective Date             The effective date of the license or registration.       Date       ASSET_LICENSE
                                                                                                                                                                                         8/1/20116:52 PM
       D:\Docstoc\Working\pdf\9eaa55ee-59bb-4fa8-90db-e338dc945f9d.xls                                                                                                                      Page 13 of 36
                                                                                      Asset Management Optional Fields

         Field Name                                 Long Name                   Use and Processing Considerations                   No.          Tables Updated   Column for Agency Use
                                                                                                                                 Characters
LIC_END_DT                              License Expiration Date            The expiration date of the license or registration.                ASSET_LICENSE
                                                                                                                                   Date
REGISTER_NAME                           Name                               The name of the person under which the asset is                    ASSET_LICENSE
                                                                           registered.                                              30
COUNTRY                                 Country                            The country in which the asset is registered.                      ASSET_LICENSE,
                                                                                                                                     3        COUNTRY
ADDRESS1                                Address 1                          The address line 1 under which the asset is                        ASSET_LICENSE
                                                                           registered.                                              55
ADDRESS2                                Address 2                          The address line 2 under which the asset is                        ASSET_LICENSE
                                                                           registered.                                              55
ADDRESS3                                Address 3                          The address line 3 under which the asset is                        ASSET_LICENSE
                                                                           registered.                                              55
ADDRESS4                                Address 4                          The address line 4 under which the asset is                        ASSET_LICENSE
                                                                           registered.                                              55
CITY                                    City                               The city under which the asset is registered.            30        ASSET_LICENSE
NUM1                                    Number 1                                                                                     6        ASSET_LICENSE
NUM2                                    Number 2                                                                                     4        ASSET_LICENSE
HOUSE_TYPE                              House Type                         The type of house, for example houseboat,                          ASSET_LICENSE
                                                                           trailer.                                                  2
ADDR_FIELD1                             Address Field 1                    Address Field                                             2        ASSET_LICENSE
ADDR_FIELD2                             Address Field 2                    Address Field                                             4        ASSET_LICENSE
ADDR_FIELD3                             Address Field 3                    Address Field                                             4        ASSET_LICENSE
COUNTY                                  County                             The county under which the asset is registered.                    ASSET_LICENSE
                                                                                                                                    30
STATE                                   State                     The state under which the asset is registered.                     6        ASSET_LICENSE
POSTAL                                  Postal Code               The postal code under which the asset is                                    ASSET_LICENSE
                                                                  registered.                                                       12
IN_CITY_LIMIT                           In City Limit             Is vendor within city limit?                                       1        ASSET_LICENSE
LICENSE_COMMENTS50                      Asset License Comments 50 Comments about the license or registration for                              ASSET_LICENSE
                                        Characters                the asset.                                                        50




                                                                                                                                                                                          8/1/20116:52 PM
         D:\Docstoc\Working\pdf\9eaa55ee-59bb-4fa8-90db-e338dc945f9d.xls                                                                                                                     Page 14 of 36
                                                                                    Asset Management Optional Fields

      Field Name                                  Long Name                   Use and Processing Considerations                    No.          Tables Updated   Column for Agency Use
                                                                                                                                Characters
WARRANTY_EFFDT                        Warranty Effective Date            The following fields relate to the Asset_Warranty                   ASSET_WARRANTY
                                                                         record. This is optional information. If you do not
                                                                         populate these fields then a row of asset
                                                                         warranty information will not be created for the
                                                                         asset (thus saving space). You can populate
                                                                         asset warranty information on as many (or as
                                                                         few) assets as you like. It is not an all or nothing
                                                                         proposition. If you are not planning on tracking
                                                                         warranty information for an asset, then do not
                                                                         populate these fields for that asset. This field
                                                                         represents the date the warranty for this asset
                                                                         became effective.
                                                                                                                                  Date
EFF_STATUS                            Status as of Effective Date        The status of the warranty as of the effective                      ASSET_WARRANTY
                                                                         date. Valid values are „A‟ for active, or „I‟ for
                                                                         inactive.                                                  1
WARRANTY_VENDOR_ ID                   Warranty Vendor ID         The vendor ID that has provided the warranty.                               ASSET_WARRANTY
                                                                 This should be a valid value on the VNDR.FS
                                                                 record.                                                           10
WARRANTY_NUM                          Warranty Number            The number of the warranty.                                       30        ASSET_WARRANTY
WARRANTY_DURATION                     Warranty Duration (Months) The duration of the warranty in months.                                     ASSET_WARRANTY
                                                                                                                                Any length
COVERAGE50                            Asset Warranty Coverage 50 The comments on the coverage of the warranty.                               ASSET_WARRANTY
                                      Characters                 This field is a long field on the Asset_Warranty
                                                                 record, but is only 50 characters here. Online
                                                                 you can enter up to 32K of information into this
                                                                 field.                                                            50
JURISDICTION                          Jurisdiction               Identifies the municipal authority of which it is a                         ASSET_LICENSE
                                                                 part. Could be used by property tax to identify
                                                                 taxing authority.                                                  5




                                                                                                                                                                                         8/1/20116:52 PM
       D:\Docstoc\Working\pdf\9eaa55ee-59bb-4fa8-90db-e338dc945f9d.xls                                                                                                                      Page 15 of 36
                                                                                   Asset Management Optional Fields

      Field Name                                  Long Name                   Use and Processing Considerations                  No.          Tables Updated    Column for Agency Use
                                                                                                                              Characters
Optional Financial and Physical Fields that will not be Used in the Conversion
TRANS_IN_OUT                          Transaction In/Out          Used to identify which side of a transfer or                             COST, DEPRECIATION
                                                                  recategorization this transaction represents.                 Date
DEPR_PERCENT                          Percent                     Identifies the percent to be used. This field is                         BOOK
                                                                  only used when the depreciation method is flat
                                                                  rate or declining balance.                                      9
DB_PERCENT                            Declining Balance Percent Identifies the declining balance percent.                        15        BOOK
DEPR_SCHED_CD                         Depreciation Schedule Code Identifies the depreciation schedule to be used.                          BOOK
                                                                  This field is only used if the depreciation method
                                                                  is schedule.                                                   10
DEPR_LIMIT_CD                         Depreciation Limit Code     Identifies the depreciation limits to be used.                           BOOK
                                                                  Depreciation limits are used to limit the amount
                                                                  of depreciation expense that can be taken in a
                                                                  given fiscal year.                                             10
BASIS_RED_TOTAL                       Basis Reduction Total       The total amount of the reduction in the cost                            BOOK
                                                                  basis for this asset book.                                     26
BASIS_RED_RECAP                       Basis Reduction Recapture The total amount of the recapture of the basis                             BOOK
                                                                  reduction for this asset book.                                 26
CURRENCY_CD                           Currency Code               This field represents the transaction currency.                 3        COST, RETIREMENT
FULLY_DEPR_SW                         Retire as Fully Depreciated Used to retire assets as fully depreciated.                              RETIREMENT
                                                                                                                                  1
RETIREMENT_DT                         Retirement Date                    The retirement date of the transaction. This field                RETIREMENT
                                                                         is used for retirement transactions only.              Date
RETIRE_CONVENTION                     Retirement Convention              Represents the convention used for the                            RETIREMENT
                                                                         retirement transaction.                                  2
END_DEPR_DT                           End Depreciation Date              The date that depreciation will stop for this                     RETIREMENT
                                                                         asset.                                                 Date
DISPOSAL_CODE                         Disposal Code                      Represents a memo field detailing the method                      RETIREMENT
                                                                         that was used to dispose of this asset.                  1
RETIREMENT_TYPE                       Retirement Type                    Represents whether this retirement transaction                    RETIREMENT
                                                                         was ordinary or extraordinary according to U.S.
                                                                         Tax code.                                                1
RETIREMENT_STATUS                     Retirement Status                  Represents the status of the retirement                           RETIREMENT
                                                                         transaction.                                             1
VOLUNTARY                             Voluntary Conversion               Represents whether the retirement was                             RETIREMENT
                                                                         voluntary or involuntary.                                1

                                                                                                                                                                                        8/1/20116:52 PM
       D:\Docstoc\Working\pdf\9eaa55ee-59bb-4fa8-90db-e338dc945f9d.xls                                                                                                                     Page 16 of 36
                                                                                    Asset Management Optional Fields

       Field Name                                 Long Name                   Use and Processing Considerations             No.          Tables Updated   Column for Agency Use
                                                                                                                         Characters
TRADE_IN_ASSET_ID                     Asset ID Bought with Trade Represents the asset ID that was bought using                        RETIREMENT
                                      In                         this asset as a trade-in.                                  12
TRADE_IN_DTTM_STMP                    Trade In Date/Time Stamp Represents the date/time stamp of the asset add                        RETIREMENT
                                                                 transaction for the asset that was bought                 Date
TRADE_IN_AMT                          Trade In Amount            The amount received for the trade-in of an asset.                    RETIREMENT
                                                                                                                            26
REFERENCE                             Reference Code           A memo field that can be used to tie this                              RETIREMENT
                                                               retirement transaction to a reference document.
                                                               This field is only used for retirement
                                                               transactions.                                                30
RETIRE_QUANTITY                       Retirement Quantity      The quantify of the asset book being retired by                        RETIREMENT
                                                               this transaction. This field is only used for
                                                               retirement transactions.                                     15
RETIREMENT_AMT                        Retirement Amount        The amount of cost for the asset book being                            RETIREMENT
                                                               retired by this transaction. This field is only used
                                                               for retirement transactions.                                 26
PROCEEDS                              Retirement Proceeds      The proceeds received for this asset. This is                          RETIREMENT
                                                               used in the depreciation calculation program to
                                                               derive the gain/loss amount. This field is only
                                                               used for retirement transactions.                            26
REMOVAL_COST                          Removal Cost             The cost of removal for this asset. This is used                       RETIREMENT
                                                               in the depreciation calculation program to derive
                                                               the gain/loss amount. This field is only used for
                                                               retirement transactions.                                     26
RETIREMENT_RSV                        Reserve Retired          The accumulated depreciation being retired by                          RETIREMENT
                                                               this transaction. This is calculated by the
                                                               depreciation calculation program. This field is
                                                               only used for retirement transactions.                       26
GAIN_LOSS                             Retirement Gain/Loss     The gain/loss amount for this retirement                               RETIREMENT
                                                               transaction. This is calculated by the
                                                               depreciation calculation program. This field is
                                                               only used for retirement transactions.                       26
LEASE_REM_PAYMNTS                     Lease Remaining Payments The number of payments remaining at the time                           RETIREMENT
                                                               of the retirement.                                           26
TRADE_IN_VALUE                        Trade In value           To retire an asset by trading it for another asset.                    RETIREMENT
                                                                                                                            26
CASH                                  Cash Received/Paid                 "Cash received in a like-kind exchange is                    RETIREMENT
                                                                         taxable and is often referred to as “boot”. "      26

                                                                                                                                                                                  8/1/20116:52 PM
       D:\Docstoc\Working\pdf\9eaa55ee-59bb-4fa8-90db-e338dc945f9d.xls                                                                                                               Page 17 of 36
                                                                                    Asset Management Optional Fields

      Field Name                                  Long Name                   Use and Processing Considerations                      No.          Tables Updated   Column for Agency Use
                                                                                                                                  Characters
LIABILITY_ASSUMED                     Liabilities Assumed        "If you are surrendering a building with a                                    RETIREMENT
                                                                 mortgage of USD 70,000 and acquiring a
                                                                 building with a mortgage of USD 30,000, you
                                                                 would enter 40,000 as the net liability. "                          26
NON_LIKE_KIND                         FMV Non Like Kind Property Fair Market Value for Non Like Kind Property.                                 RETIREMENT
                                                                                                                                     26
LIFE_END_DT                           Useful Life End Date               This field represents the end date of the useful                      BOOK
                                                                         life on the asset book. This field can be used as
                                                                         an alternate to the life field. Life and life end date
                                                                         are mutually exclusive.                                    Date
DEPR_LOW_LIMIT                        Depreciation Low Limit             This field represents the low amount that net                         BOOK
                                      Amount                             book value must reach before an asset stops
                                                                         depreciating.                                               26
SUSPEND_STATUS                        Suspend Status                     Indicates whether the book is currently                               BOOK
                                                                         “mothballed”.                                               1
SUSPEND_DT                            Suspend Date                       The date that depreciation was suspended.                  Date       BOOK
RESUME_DT                             Resume Date                        The date that depreciation was resumed after a                        BOOK
                                                                         suspension.                                                Date
SUSPENDED_PERIODS                     Number of Suspended                The number of periods that depreciation was                           BOOK
                                      Periods                            suspended for.                                           Any Length
COST_BASIS_LIMIT                      Cost Basis Limit                   The maximum amount that can be capitalized for                        BOOK
                                                                         this asset book.                                            26
INCLUDE_CAP_GAINS                     CGT Applicable                     A flag which determines whether or not capital                        BOOK
                                                                         gains tax should be included in the gain/loss of a
                                                                         book.                                                        1
BILL_TO_CUST_ID                       Customer                           Bill to Information.                                                  RETIREMENT
                                                                                                                                     15
ADDRESS_SEQ_NUM                       Address Sequence Number Bill to Information.                                                             RETIREMENT
                                                                                                                                  Any Length
SHIP_TO_CUST_ID                       Ship To Customer                   Ship to Information.                                                  RETIREMENT
                                                                                                                                     15
SHIP_TO_ADDR_NUM                      Ship To Address Sequence Ship to Information.                                                            RETIREMENT
                                      Num                                                                                         Any Length
SHIP_FROM_LOC                         Ship From Location       Ship to Information.                                                            RETIREMENT
                                                                                                                                     10
SOLD_TO_CUST_ID                       Sold To Customer                   Sold to Information.                                                  RETIREMENT
                                                                                                                                     15


                                                                                                                                                                                           8/1/20116:52 PM
       D:\Docstoc\Working\pdf\9eaa55ee-59bb-4fa8-90db-e338dc945f9d.xls                                                                                                                        Page 18 of 36
                                                                                  Asset Management Optional Fields

      Field Name                                 Long Name                   Use and Processing Considerations      No.           Tables Updated   Column for Agency Use
                                                                                                                 Characters
SOLD_TO_ADDR_NUM                     Sold To Address Sequence           Sold to Information.                                  RETIREMENT
                                     Num                                                                         Any Length
BILL_SOURCE_ID                       Bill Source                        Billing Source.                              10       AMBI_INTFC_BILL
TOT_OBLIGATION                       Lease Total Obligation             Leasing Obligation.                          26       BOOK
TXN_CASH                             Transaction Cash                   Cash in transaction currency.                26       COST
TXN_COST                             Transaction Cost                   Cost in transaction currency.                26       COST
TXN_CURRENCY_CD                      Transaction Currency               Transaction Currency.                         3       COST
TXN_CURRENCY_CD2                     Transaction Currency               Transaction Currency.                                 COST
                                     Display                                                                         3
TXN_LIAB_ASSUMED                     Transaction Liability              Liab Assumed in transaction currency.                 RETIREMENT
                                     Assumed                                                                        26
TXN_NON_LIKE_KIND                    FMV Non Like-Kind          Non Like Kind in transaction currency.              26        RETIREMENT
TXN_PROCEEDS                         Transaction Proceeds       Used to populate an amount for Billing – Asset
                                                                Management transactions.                            26
TXN_REMOVAL_COST                     Transaction Removal Cost Removal Cost in transaction currency.                 26        RETIREMENT
TXN_TRADE_IN_VALUE                   Transaction Trade-In Value Trade in value in transaction currency.                       RETIREMENT
                                                                                                                    26
DEPR_BONUS_SW                        Depreciation Bonus         Depreciation Bonus Switch for Depreciation                    BOOK
                                                                Calculation.                                         1
DEPR_BONUS_PCT                       Depreciation Bonus Percent Depreciation Bonus Percentage for Depreciation                BOOK
                                                                Calculation.                                          5
SPECIAL_DEPR_SW                      Special Depreciation       Depreciation Calculation.                             1       BOOK
ACCELERATED_TERMS                    Accelerated Terms          Depreciation Calculation.                            10       BOOK
INITIAL_TERMS                        Initial Terms              Depreciation Calculation.                            10       BOOK
SPECIAL_TERMS                        Special Terms              Depreciation Calculation.                            10       BOOK
YEAR_CHANGE                          Year of Change             Depreciation Calculation.                        Any Length   BOOK
LIFE_IN_YRS                          Life in Years              Depreciation Calculation.                             5       BOOK
MULTI_SHIFT_CODE                     Multi-Shift Code           Depreciation Calculation.                             6       BOOK
MULTI_SHIFT_NBR                      Shift Factor Number        Depreciation Calculation.                        Any Length   BOOK
DEPR_LIMIT_PCT                       Depreciation Limit Percent Depreciation Calculation.                             5       BOOK
DEPR_PASS_LIFE_SW                    Depreciate Pass Life SW    Depreciation Calculation.                             1       BOOK
DEROGATORY_SW                        Derogatory Depreciation    Depreciation Calculation.                             1       BOOK
ACCEL_DEPR                           Accelerated Depreciation   Depreciation Calculation.                            26       BOOK
INCREASE_DEPR                        Increased Depreciation     Depreciation Calculation.                            26       BOOK
INITIAL_DEPR                         Initial Depreciation       Depreciation Calculation.                            26       BOOK
SPEC_DEPR                            Special Depreciation       Depreciation Calculation.                            26       BOOK
STANDARD_DEPR                        Standard Depreciation      Depreciation Calculation.                            26       BOOK


                                                                                                                                                                           8/1/20116:52 PM
      D:\Docstoc\Working\pdf\9eaa55ee-59bb-4fa8-90db-e338dc945f9d.xls                                                                                                         Page 19 of 36
                                                                              Asset Management Optional Fields

        Field Name                                 Long Name              Use and Processing Considerations               No.          Tables Updated   Column for Agency Use
                                                                                                                       Characters
BUSINESS_UNIT_PO                       PO Business Unit            The business unit from Purchasing that is                        ASSET_ACQ_DET
                                                                   associated with this transaction.                       5
PO_ID                                  Purchase Order Number       The PO number from Purchasing that is                            ASSET_ACQ_DET
                                                                   associated with this transaction.                      10
PO_LINE_NBR                            Purchase Order Line         The PO line number from Purchasing that is                       ASSET_ACQ_DET
                                       Number                      associated with this transaction.                   Any length
SCHED_NBR                              Schedule Number             The schedule number from Purchasing that is                      ASSET_ACQ_DET
                                                                   associated with this transaction.                   Any length
PO_DIST_LINE_NUM                       PO Distribution Line Number The distribution line number from Purchasing                     ASSET_ACQ_DET
                                                                   that is associated with this transaction.           Any length
BUSINESS_UNIT_PC                       Projects Business Unit      The business unit in Projects that generated this                ASSET_ACQ_DET
                                                                   asset transaction. Can also come from
                                                                   Purchasing/Payables integration.                        5
BUSINESS_UNIT_RECV                     Business Unit Receive       Identifies the Purchasing receiving business unit                ASSET_ACQ_DET
                                                                   that this transaction is associated with.               5
RECEIVER_ID                            Receiver ID                 Identifies the Purchasing receiving receiver ID                  ASSET_ACQ_DET
                                                                   that this transaction is associated with.

                                                                                                                          10
RECV_LN_NBR                            Receiver Line Number       Identifies the Purchasing receiving line number                   ASSET_ACQ_DET
                                                                  that this transaction is associated with.            Any length
RECV_SHIP_SEQ_NBR                      Receiver Shipping Sequence Identifies the Purchasing receiving shipping                      ASSET_ACQ_DET
                                       Number                     sequence number that this transaction is
                                                                  associated with.                                     Any length
RECV_DIST_LINE_NUM                     Receiver Distribution Line Identifies the Purchasing receiving distribution                  ASSET_ACQ_DET
                                       Number                     line number that this transaction is associated
                                                                  with.                                                Any length
DISTRIB_SEQ_NUM                        Distribution Sequence      Identifies the Purchasing receiving distribution                  ASSET_ACQ_DET
                                       Number                     sequence number that this transaction is
                                                                  associated with.                                     Any length
MASTER_PROJECT                         Master Project             The master project in Projects that generated                     ASSET_ACQ_DET
                                                                  this asset transaction.                                 15
ACTIVITY_ID                            Activity ID                The activity ID in Projects that generated this                   ASSET_ACQ_DET
                                                                  asset transaction. Can also come from
                                                                  Purchasing/ Payables integration.                       15
RESOURCE_TYPE                          Resource Type              The resource type in Projects that generated this                 ASSET_ACQ_DET
                                                                  asset transaction. Can also come from
                                                                  Purchasing/ Payables integration.                        5
                                                                                                                                                                                8/1/20116:52 PM
        D:\Docstoc\Working\pdf\9eaa55ee-59bb-4fa8-90db-e338dc945f9d.xls                                                                                                            Page 20 of 36
                                                                                    Asset Management Optional Fields

       Field Name                                 Long Name                   Use and Processing Considerations                 No.          Tables Updated   Column for Agency Use
                                                                                                                             Characters
RESOURCE_SUB_CAT                      Resource subcategory               The resource subcategory from Projects,                          ASSET_ACQ_DET
                                                                         Purchasing or Payables.                                 5
ANALYSIS_TYPE                         Resource Analysis type             The resource analysis type in Projects that                      ASSET_ACQ_DET
                                                                         generated this asset transaction. Can also come
                                                                         from Purchasing/ Payables integration.                  3
RESOURCE_CATEGORY                     Resource category                  The resource category in Projects that                           ASSET_ACQ_DET
                                                                         generated this asset transaction. Can also come
                                                                         from Purchasing/ Payables integration.                  5
COMPOSITE_SW                          Composite Asset?                   Used to indicate whether the asset is a                          ASSET
                                                                         composite asset.                                        1
COMPOSITE_ID                          Composite Asset ID                                                                        12        ASSET
BUDGET_REF                            Budget Reference                   A ChartField, which can be customized. See the                   ASSET_ACQ_DET
                                                                         online ChartField customization topic for further
                                                                         discussion.                                             8
AFFILIATE                             Affiliate                          A ChartField, which can be customized. See the                   ASSET_ACQ_DET
                                                                         online ChartField customization topic for further
                                                                         discussion.                                             5
AFFILIATE_INTRA1                      Fund Affiliate                     A ChartField, which can be customized. See the                   ASSET_ACQ_DET
                                                                         online ChartField customization topic for further
                                                                         discussion.                                            10
AFFILIATE_INTRA2                      Operating Unit Affiliate           A ChartField, which can be customized. See the                   ASSET_ACQ_DET
                                                                         online ChartField customization topic for further
                                                                         discussion.                                            10
MERCH_AMT_BSE                         Merchandise amount                 Used in Payables/Assets integration.                             ASSET_ACQ_DET
                                                                                                                                26
IN_SERVICE_DT                         In Service Date                    Used to determine if the asset is still under                    ASSET
                                                                         warranty.                                             Date
MISC_AMT_BSE                          Base Misc. Amount                  Used in Payables/Assets integration.                   26        ASSET_ACQ_DET




                                                                                                                                                                                      8/1/20116:52 PM
       D:\Docstoc\Working\pdf\9eaa55ee-59bb-4fa8-90db-e338dc945f9d.xls                                                                                                                   Page 21 of 36
                                                                                Asset Management System Generated Fields

           Field Name                                   Long Name                                   Use and Processing Considerations                            No.                          Tables Updated
                                                                                                                                                              Characters

Financial
ASSET_ID                                      Asset Identification                   The system automatically assigns numbers to assets incrementally                      BOOK, COST, DEPRECIATION, RETIREMENT,
                                                                                     when field contains the value "NEXT".                                        12       OPEN_TRANS
INTFC_ID                                      Interface ID                           Key to this table. An interface ID is typically assigned to a group of                Used internally.
                                                                                     transactions with the same load type.                                    Any Length
INTFC_LINE_NUM                                Interface Line Number                   Interface Line Number is used as a key for multiple lines for the                    Used Internally.
                                                                                     same Interface ID for transactions with similar keys (for example.,
                                                                                     multiple acquisition details, such as CAP).
                                                                                                                                                              Any Length
DTTM_STAMP                                    Date/Time Stamp                        Used to populate the key field of datetime stamp on many tables.                      COST, DEPRECIATION, RETIREMENT,
                                                                                     Represents the date/time that this transaction was added to the                       OPEN_TRANS
                                                                                     system.                                                                     Date
CF_SEQNO                                      Chartfield Sequence                    Internal Use. Every combination of Chartfield values at the                           COST, DEPRECIATION
                                              Number                                 Asset/Book level has a unique ChartField sequence number.
                                                                                                                                                              Any Length
VOUCHER_ID                                    Voucher ID                             Identifies the voucher associated with the financial transaction.                     Used internally.

                                                                                                                                                                  8
VOUCHER_LINE_NUM                              Voucher Line Number                    Identifies the voucher line number associated with the financial                      Used internally.
                                                                                     transaction. This is used in AP integration.
                                                                                                                                                              Any length
DISTRIB_LINE_NUM                              Distribution Line Number               Identifies the voucher line distribution number associated with the                   Used internally.
                                                                                     financials transaction. This is used in AP integration.
                                                                                                                                                              Any length
INTFC_TYPE                                    Interface Type, also called Identifies the interface type.                                                                   Used internally.
                                              Load Type                                                                                                           3
SYSTEM_SOURCE                                 System Source               The source system that created this transaction.                                        3        Used internally.
APPROVAL_SW                                   Auto-approval Status        Identifies whether the transaction is approved or not.                                           Used internally.
                                                                                                                                                                  1
PI_ID                                         Physical Inventory ID                  The physical inventory ID that was entered when defining physical                     Used internally.
                                                                                     inventory is used here.                                                      10
INTFC_STATUS                                  Interface Status                       Used for internal processing. Default this field to „DON‟.                            Used internally.
                                                                                                                                                                  3
LOAD_STATUS                                   Load Status                            Identifies the status of this transaction. Updated by the Transaction               Used internally.
                                                                                     Loader.                                                                      3
ORIG_INTFC_ID                                 Original Interface ID                  Used for internal processing. Do not populate.                           Any Length Used internally.

                                                                                                                                                                                                               8/1/2011 6:52 PM
        D:\Docstoc\Working\pdf\9eaa55ee-59bb-4fa8-90db-e338dc945f9d.xls SYSTEM GENERATED                                                                                                                           Page 22 of 36
                                                                              Asset Management System Generated Fields

           Field Name                                 Long Name                                   Use and Processing Considerations                           No.                          Tables Updated
                                                                                                                                                           Characters

ORIG_LINE_NUM                               Original Interface Line     Used for internal processing. Do not populate.                                                  Used internally.
                                            Number                                                                                                         Any Length
DEFAULT_PROFILE_SW                          Default Books from Profile? Identifies whether a profile will be used for an asset add or                                   Used internally.
                                                                        capitalization by the Transaction Loader.
                                                                                                                                                               1
TRANS_DT                                    Transaction Date                       Denotes the date this transaction occurred. During conversion it is                  COST, DEPRECIATION, OPEN_TRANS
                                                                                   important that this field represent the last period for which
                                                                                   depreciation has been calculated.
                                                                                                                                                             Date
ACCOUNTING_DT                               Accounting Date                        Denotes the date this transaction was accounted for. This is the date                COST, OPEN_TRANS
                                                                                   that will be passed to the general ledger.
                                                                                                                                                             Date
DEPR_IN_SERVICE_SW                          Depreciate When in                     This field marks whether the yearly depreciation in the year of                      BOOK
                                            Service?                               acquisition should be spread from the in service date through the
                                                                                   end of the year or from the begin depreciation date as calculated
                                                                                   using the convention and the in service date.

                                                                                                                                                               1
BEGIN_DEPR_DT                               Begin Depreciation Date                The date the asset begins depreciating.                                              BOOK
                                                                                                                                                             Date
BEGIN_DEPR_PD                               Begin Depreciation Period Used for internal processing. Do not populate.                                                    BOOK
                                                                                                                                                           Any Length
BEGIN_DEPR_FY                               Begin Depreciation Fiscal              Used for internal processing. Do not populate.                                       BOOK
                                            Year                                                                                                           Any Length
BEGIN_FRACTION                              Begin Depreciation Period              Used for internal processing. Do not populate.                                       BOOK
                                            Fraction                                                                                                          15
DEPR_CALC_SW                                Depreciation Calculation               Used for internal processing. Do not populate.                                       BOOK
                                            Switch                                                                                                             1
BEGIN_CALC_DT                               Begin Depreciation                     Used for internal processing. Do not populate.                                       BOOK
                                            Calculation Date                                                                                                 Date
BEGIN_CALC_PD                               Begin Calculation Period               Used for internal processing. Do not populate.                                       BOOK
                                                                                                                                                           Any Length
BEGIN_CALC_FY                               Begin Calculation Fiscal               Used for internal processing. Do not populate.                                       BOOK
                                            Year                                                                                                           Any Length
CALCULATION_TYPE                            Calculation Type                       The type of depreciation calculation that will be performed by the                   BOOK
                                                                                   depreciation calculation program.
                                                                                                                                                               1

                                                                                                                                                                                                            8/1/2011 6:52 PM
      D:\Docstoc\Working\pdf\9eaa55ee-59bb-4fa8-90db-e338dc945f9d.xls SYSTEM GENERATED                                                                                                                          Page 23 of 36
                                                                                 Asset Management System Generated Fields

            Field Name                                   Long Name                                   Use and Processing Considerations                            No.                      Tables Updated
                                                                                                                                                               Characters

LAST_CALC_TYPE                                 Last Calculation Type                  Used for internal processing. Do not populate.                               1        BOOK
RSV_FRACTION                                   Reserve Fraction                       Used for internal processing. Do not populate.                                        BOOK
                                               (RSV/Cost)                                                                                                         15
RECALC_RSV_SW                                  Recalculate RSV Fraction               Used for internal processing. Do not populate.                                        BOOK
                                               (RSV/Cost)                                                                                                          1
SCHED_FRACTION                                 Fraction of Schedule                   Used for internal processing. Do not populate.                                        BOOK
                                               Elapsed                                                                                                            15
YEAR_REM_FRACTION                              Year Remaining Fraction                Used for internal processing. Do not populate.                                        BOOK
                                                                                                                                                                  15
CONVENTION                                     Prorate Convention                     Identifies the depreciation prorate convention to be used with this                   BOOK
                                                                                      asset book.                                                                  2
LIFE_REMAINING                                 Remaining Life                         Used for internal processing. Do not populate.                              15        BOOK
TAX_CREDIT_SW                                  Tax Credit Switch                      Used for internal processing. Do not populate.                               1        BOOK
ACTIVITY_SW                                    Activity Switch                        Identifies whether this transaction reflects an active ChartField                     COST, DEPRECIATION
                                                                                      combination for an asset. For asset adds, this field will always be 0.
                                                                                                                                               Any Length
RETIRE_SW                                      Retirement Switch         Identifies whether this ChartField combination for the asset book has                              COST
                                                                         been retired (fully) or not.                                          Any Length
FISCAL_YEAR                                    Fiscal Year               Represents the fiscal year in which the depreciation was taken.                                    DEPRECIATION
                                                                                                                                               Any Length
START_PD                                       Start Period              Represents the start period for which the depreciation was taken.                                  DEPRECIATION
                                                                                                                                               Any Length
END_PD                                         End Period                Represents the end period for which the depreciation was taken.                                    DEPRECIATION
                                                                                                                                               Any Length
YTD_FLAG                                       Original Reserve          Set value to „N‟ for Depreciation Amount that represents                                           DEPRECIATION
                                                                         accumulated depreciation as of the conversion date. Default to „Y‟
                                                                         for other depreciation transactions.
                                                                                                                                                    1
DEPR_YTD                                       Year-to-Date Depreciation Populate with Year To Date Depreciation                                                            DEPRECIATION
                                                                                                                                                   26
OPEN_TRANS_ID                                  Open Transaction ID       The ID (key) for the OPEN_TRANS table. For performance                                             OPEN_TRANS
                                                                         reasons, this field should be populated for conversions. A single
                                                                         unique OPEN_TRANS_ID can be used for a group of the same
                                                                         transaction types, for example, CN1s.                                     10




                                                                                                                                                                                                            8/1/2011 6:52 PM
         D:\Docstoc\Working\pdf\9eaa55ee-59bb-4fa8-90db-e338dc945f9d.xls SYSTEM GENERATED                                                                                                                       Page 24 of 36
                                                                               Asset Management System Generated Fields

           Field Name                                  Long Name                                   Use and Processing Considerations                              No.                          Tables Updated
                                                                                                                                                               Characters

CALC_DEPR_STATUS                             Depreciation                           This field is used to determine whether depreciation needs to be                        OPEN_TRANS
                                                                                    calculated on this transaction. Only financial transactions need
                                                                                    depreciation calculated.
                                                                                                                                                                   1
CALC_DIST_STATUS                             Distribution                           This field is used to determine whether accounting entries need to                      OPEN_TRANS
                                                                                    be created for this transaction. Only financial transactions on a book
                                                                                    marked for accounting entry creation need to have accounting
                                                                                    entries created.
                                                                                                                                                                   1
MESSAGE_SET_NBR                              Message Set Number                     Used for internal processing. Do not populate.                             Any Length Used internally
DEPR_AVG_OPTION                              Averaging Option                       A special option that applies only to the flat rate depreciation                      BOOK
                                                                                    method. Valid values are „M‟ (Monthly), „Y‟ (Yearly), or „N‟ (None).

                                                                                    If you‟re doing a conversion (CN1), you must set this field to a value,
                                                                                    no matter what depreciation method you‟re using.
                                                                                                                                                                    1
MC_DEFN_ID                                   Mass Change ID                         Used for internal processing. Do not populate.                                 30       Used internally.
AUTO_RETIRED_SW                              Auto-Retired Fully                     Internal                                                                                RETIREMENT
                                             Depreciated                                                                                                           1
IMPAIR_FLG                                   Impairment Process                     Impairment Processing Switch.                                                  1        BOOK
CC_FLAG                                      Component Changeout                    Internal Use
                                             Old/New                                                                                                               3
Physical A
INTFC_ID                                     Interface ID                           Key to this table. An interface ID is typically assigned to a group of                  Used internally.
                                                                                    transactions with the same load type.
                                                                                                                                                               Any Length
INTFC_LINE_NUM                               Interface Line Number                  Key to this table. Interface Line Number is used as a key for multiple                  Used internally.
                                                                                    lines for the same Interface ID for transactions with similar keys (ex.,
                                                                                    multiple acquisition details, such as CAP).
                                                                                                                                                               Any Length
ASSET_ID                                     Asset Identification                   The asset ID that identifies the asset to be processed. This field is                   ASSET, ASSET_ACQ_DET,
                                                                                    required. If this field contains the value „NEXT‟ and the interface type                ASSET_CUSTODIAN, ASSET_LOCATION, and
                                                                                    is FAD or CN1 then Transaction Loader will assign the next asset ID                     many others
                                                                                    for this business unit.
                                                                                                                                                                   12



                                                                                                                                                                                                                8/1/2011 6:52 PM
       D:\Docstoc\Working\pdf\9eaa55ee-59bb-4fa8-90db-e338dc945f9d.xls SYSTEM GENERATED                                                                                                                             Page 25 of 36
                                                                              Asset Management System Generated Fields

         Field Name                                   Long Name                                   Use and Processing Considerations                             No.                          Tables Updated
                                                                                                                                                             Characters

DTTM_STAMP                                  Date/Time Stamp                        Used to populate the key field of datetime stamp on many tables.
                                                                                   Represents the date/time that this transaction was added to the
                                                                                   system. During conversion it is important that this field represent the
                                                                                   period through which depreciation has been calculated

                                                                                                                                                                Date
INTFC_TYPE                                  Interface Type, also called Identifies the type of transaction this is. Transaction loader will                               Used internally.
                                            Load Type                   process this transaction based upon this field. Valid values are listed
                                                                        in the translate table.
                                                                                                                                                                  3
MC_DEFN_ID                                  Mass Change ID                         Used for internal processing. Do not populate.                                30       Used internally.
SYSTEM_SOURCE                               System Source                          The source system that created this transaction. Valid values are                      ASSET_ACQ_DET
                                                                                   listed in the translate table. This field is used extensively by AM to
                                                                                   drill back to source system. Feel free to add valid values to the
                                                                                   translate table for your external systems. You can run Transaction
                                                                                   Loader selectively for specific values of system source.

                                                                                                                                                                 3
APPROVAL_SW                                 Auto Approval Status                   Identifies whether the transaction is approved or not. Transaction                     Used internally.
                                                                                   Loader will only load approved transactions. Valid values are „Y‟ for
                                                                                   approved and „N‟ for not approved.
                                                                                                                                                                 1
INTFC_STATUS                                Interface Status                       Used for internal processing. Default this field to „DON‟.                             Used internally.
                                                                                                                                                                 3
LOAD_STATUS                                 Load Status                            Identifies the status of this transaction. Valid values are „NEW‟ = not                Used internally.
                                                                                   processed; „ERR‟ = an error exists on this transaction and it will not
                                                                                   be processed; „DON‟ = the transaction has been successfully
                                                                                   processed. CON = transaction has been consolidated into a different
                                                                                   transaction and it will not be loaded. UNI = transaction has been
                                                                                   unitized into a different transaction and it will not be loaded.



                                                                                                                                                                 3
ORIG_INTFC_ID                               Original Interface ID                  Used for internal processing. Do not populate.                            Any Length Used internally.
ORIG_LINE_NUM                               Original Interface Line                Used for internal processing. Do not populate.                                       Used internally.
                                            Number                                                                                                           Any Length

                                                                                                                                                                                                              8/1/2011 6:52 PM
      D:\Docstoc\Working\pdf\9eaa55ee-59bb-4fa8-90db-e338dc945f9d.xls SYSTEM GENERATED                                                                                                                            Page 26 of 36
                                                                               Asset Management System Generated Fields

           Field Name                                  Long Name                                   Use and Processing Considerations                              No.                          Tables Updated
                                                                                                                                                               Characters

DEFAULT_PROFILE_SW                           Default Books from Profile Identifies whether a profile will be used for an asset add by the                                   Used internally.
                                                                        Transaction Loader. When this switch is set to „Y‟ the BOOK table
                                                                        will have its fields defaulted from the profile tables rather than the
                                                                        load tables (INTFC...). The category on the cost table will also be
                                                                        defaulted from the profile tables. The profile_ID is identified on the
                                                                        INTFC_PHY_A table. When performing a CN1, you must set the
                                                                        DEFAULT_PROFILE_SW to „N‟. The value of
                                                                        DEFAULT_PROFILE_SW in INTFC_FIN must match the value of
                                                                        DEFAULT_PROFILE_SW in INTFC_PHY_A.
                                                                                                                                                                   1
Physical B
ASSET_DTTM_STAMP                             Asset Date/Time Stamp                  Used for internal processing. Do not populate.                                Date    Used internally.
SEQUENCE_NBR_6                               Sequence                               Used to sequence the acquisition detail table.                             Any Length ASSET_ACQ_DET
BUSINESS_UNIT_AP                             AP Business Unit                       The business unit from Accounts Payable that generated this                           ASSET_ACQ_DET
                                                                                    transactions.                                                                   5
TXN_CURRENCY_CD                              Transaction Currency                   Transaction Currency Code                                                       3     ASSET_ACQ_DET
CURRENCY_CD                                  Currency Code                          Represents the currency of the transaction.                                     3     ASSET_ACQ_DET
PROCESS_INSTANCE                             Process Instance                       Internal                                                                       10
MERCHANDISE_AMT                              Merchandise Amt                        Merchandise Amount in Transaction Currency.                                    26     ASSET_ACQ_DET
CC_FLAG                                      Component Changeout                    Internal
                                             Old/New                                                                                                              10
INTFC_ID                                     Interface ID                           Key to this table. An interface ID is typically assigned to a group of                  Used internally.
                                                                                    transactions with the same load type.
                                                                                                                                                               Any Length
INTFC_LINE_NUM                               Interface Line Number                  Key to this table. Interface Line Number is used as a key for multiple                  Used Internally.
                                                                                    lines for the same Interface ID for transactions with similar keys (ex.,
                                                                                    multiple acquisition details, such as CAP).
                                                                                                                                                               Any Length
ASSET_ID                                     Asset ID                               Identifies the asset ID of the transaction to be processed. This field                  ASSET_ATTRIBUTE, ASSET_COMMENTS,
                                                                                    is required. If this field contains the value „NEXT‟ and the interface                  ASSET_LICENSE, ASSET_WARRANTY
                                                                                    type is FAD then Transaction Loader will assign the next asset ID for
                                                                                    this business unit.
                                                                                                                                                                  12
INTFC_TYPE                                   Interface Type, also called Identifies the type of transaction this is. Transaction loader will                                Used internally.
                                             Load Type                   process this transaction based upon this field. Valid values are listed
                                                                         in the translate table.
                                                                                                                                                                   3
                                                                                                                                                                                                                8/1/2011 6:52 PM
       D:\Docstoc\Working\pdf\9eaa55ee-59bb-4fa8-90db-e338dc945f9d.xls SYSTEM GENERATED                                                                                                                             Page 27 of 36
                                                                               Asset Management System Generated Fields

          Field Name                                   Long Name                                   Use and Processing Considerations                              No.                          Tables Updated
                                                                                                                                                               Characters

SYSTEM_SOURCE                                System Source                          The source system that created this transaction. Valid values are                       Used internally.
                                                                                    listed in the translate table. This field is used extensively by AM to
                                                                                    drill back to source system. Feel free to add valid values to the
                                                                                    translate table for your external systems. You can run Transaction
                                                                                    Loader selectively for specific values of system source.

                                                                                                                                                                   3
MC_DEFN_ID                                   Mass Change ID                         Used for internal processing. Do not populate.                                30        Used internally.
APPROVAL_SW                                  Auto Approval Status                   Identifies whether the transaction is approved or not. Transaction                      Used internally.
                                                                                    Loader will only load approved transactions. Valid values are „Y‟ for
                                                                                    approved and „N‟ for not approved.
                                                                                                                                                                   1
INTFC_STATUS                                 Interface Status                       Used for internal processing. Do not populate.                                 3        Used internally.
LOAD_STATUS                                  Load Status                            Identifies the status of this transaction. Valid values are „NEW‟ = not                 Used internally.
                                                                                    processed; „ERR‟ = an error exists on this transaction and it will not
                                                                                    be processed; „DON‟ = the transaction has been successfully
                                                                                    processed. „CON‟ = transaction has been consolidated into a
                                                                                    different transaction and it will not be loaded. „UNI‟ = transaction has
                                                                                    been unitized into a different transaction and it will not be loaded.


                                                                                                                                                                   3
PROCESS_INSTANCE                             Process Instance                       Internal                                                                      10
OPRID                                        Operator ID                            The operator ID that initiated this transaction.                              30        COST, OPEN_TRANS
MESSAGE_NBR                                  Message Number                         Used for internal processing. Do not populate.                                          Used internally
                                                                                                                                                               Any Length
BUSINESS_UNIT_JV                             Joint Venture Business Unit The “parent” JV business unit, if the asset is part of a joint venture.                            Used internally
                                                                                                                                                                   5
PROCESS_INSTANCE                             Process Instance                       Internal field / Informational.                                               10
PI_ID                                        Physical Inventory ID                  Used for internal processing. Do not populate.                                          ASSET_LOCATION
                                                                                                                                                                  10




                                                                                                                                                                                                                8/1/2011 6:52 PM
       D:\Docstoc\Working\pdf\9eaa55ee-59bb-4fa8-90db-e338dc945f9d.xls SYSTEM GENERATED                                                                                                                             Page 28 of 36
                                                                               Asset Management System Generated Fields

          Field Name                                   Long Name                                   Use and Processing Considerations                             No.                     Tables Updated
                                                                                                                                                              Characters

VOUCHER_ID                                   Voucher ID                             Identifies the voucher associated with the financial transaction. This                 Used internally. ASSET_ACQ_DET
                                                                                    is used in AP integration. This field can be used for PeopleSoft or
                                                                                    non-PeopleSoft integration. This field is on this table so that the
                                                                                    INTFC_FIN transactions can be easily queried by voucher. This
                                                                                    should be formatted if the transaction is voucher related.


                                                                                                                                                                  8
VOUCHER_LINE_NUM                             Voucher Line Number                    Identifies the voucher line number associated with the financial                       Used internally. ASSET_ACQ_DET
                                                                                    transaction. This is used in AP integration. This field can be used for
                                                                                    PeopleSoft or non-PeopleSoft integration.
                                                                                                                                                              Any length
DISTRIB_LINE_NUM                             Distribution Line Number               Identifies the voucher line distribution number associated with the                    Used internally. ASSET_ACQ_DET
                                                                                    financials transaction. This is used in AP integration. This field can
                                                                                    be used for PeopleSoft or non-PeopleSoft integration.                     Any length




                                                                                                                                                                                                            8/1/2011 6:52 PM
       D:\Docstoc\Working\pdf\9eaa55ee-59bb-4fa8-90db-e338dc945f9d.xls SYSTEM GENERATED                                                                                                                         Page 29 of 36
                                                                      Asset Management Fields Not Intended for State Use

          Field Name                                                 Long Name                                     Use and Processing Considerations                           No.                Tables Updated
                                                                                                                                                                            Characters

Fields Not Intended for State Use
REGULATION                                   Depreciation Regulation                                  Identifies the U.S. tax regulation that covers this asset book.           1        BOOK
RECOVERY_LIFE                                Recovery Life                                            Identifies the U.S. tax recovery life for this asset book.                3        BOOK
RECOVERY_SUBTYPE                             Recovery Sub-type                                        Identifies the U.S. tax recovery sub-type for this asset book.            2        BOOK
TAX_CLASS_AM                                 Guideline Tax Class                                      Identifies the U.S. tax class associated with this asset book.            6        BOOK
PROPERTY_CD                                  Property Code                                            Identifies what code of property the asset book falls into for U.S.                BOOK
                                                                                                      tax processing purposes.                                                  1
SEC179_TAKEN_SW                              Section 179 Taken Switch                                 Identifies whether the asset book has qualified under the U.S.                     BOOK
                                                                                                      Tax regulation section 179.                                               1
SEC179_AMT                                   Section 179 Taken Amount                                 If the asset book qualified for section 179 expense, how much                      BOOK
                                                                                                      was taken?                                                               26
LISTED_PROP                                  Listed Property?                                         Identifies whether the asset is listed property or not. Only used                  BOOK
                                                                                                      for tax books.                                                           n/a
LISTED_PROP_TYPE                             Listed Property Type                                     Identifies the type of listed property the asset is.                     n/a       BOOK
BUS_USE_PERCENT                              Business Use Percent                                     Percentage that asset is used for business purposes.                     n/a       BOOK
GEO_CODE                                     Tax Vendor Geographical Code                             The tax vendor geographical code.                                        11        ASSET_LICENSE
PROPERTY_CD                                  Property Code                                            Identifies what code of property the asset book falls into for U.S.                BOOK
                                                                                                      tax processing purposes.                                                  1
REDUCED_COST                                 Reduced Cost Basis                                       Amount used in calculating gain/loss for Australian Customers.                     RETIREMENT
                                                                                                                                                                               26
CAPITAL_G_L                                  Capital Gains and Loss                                   Amount used in calculating gain/loss for Australian Customers.                     RETIREMENT
                                                                                                                                                                               26
RET_NON_CAP_AM2                              Non-Capitalized CGT amount.                              Amount used in calculating gain/loss for Australian Customers.                     RETIREMENT
                                                                                                                                                                               26
INCREASE_RATE                                Increased Rate                                           Used to calculate special depreciation amount. You can enter a                     BOOK
                                                                                                      rate and the standard depreciation will be modified by this
                                                                                                      percentage along all the life of the asset. This is a Japanese
                                                                                                      Requirement but can be used for any country.

                                                                                                                                                                                9
ACCOUNTING_MTHD                              Accounting Method                                        Supports 3 different accounting methods in Japan.                         3        BOOK
RATE_DIV                                     Rate Divisor                                             Currency Conversion                                                                RETIREMENT, COST, DEPRECIATION
                                                                                                                                                                               15




                                                                                                                                                                                                           8/1/20116:52 PM
       D:\Docstoc\Working\pdf\9eaa55ee-59bb-4fa8-90db-e338dc945f9d.xls FIELDS THAT WILL NOT BE USED                                                                                                           Page 30 of 36
                                                                      Asset Management Fields Not Intended for State Use

           Field Name                                                Long Name                                    Use and Processing Considerations                         No.                Tables Updated
                                                                                                                                                                         Characters

RATE_DIV_2                                   Rate Divisor                                             Currency Conversion                                                             RETIREMENT, COST, DEPRECIATION
                                                                                                                                                                            15
RATE_MULT                                    Rate Multiplier                                          Currency Conversion                                                             RETIREMENT, COST, DEPRECIATION
                                                                                                                                                                            15
RATE_MULT_2                                  Rate Multiplier                                          Currency Conversion                                                             RETIREMENT, COST, DEPRECIATION
                                                                                                                                                                            15
RT_EFFDT                                     Rate Effective Date                                      Currency Conversion                                                             RETIREMENT, COST, DEPRECIATION
                                                                                                                                                                           Date
RT_TYPE                                      Rate Type                                                Currency Conversion                                                             RETIREMENT, COST, DEPRECIATION
                                                                                                                                                                             5
RATE_DIV                                     Rate Divisor                                             Currency Conversion.                                                  15        ASSET_ACQ_DET
RATE_MULT                                    Rate Multiplier                                          Currency Conversion.                                                  15        ASSET_ACQ_DET
RT_TYPE                                      Rate Type                                                Currency Conversion.                                                   5        ASSET_ACQ_DET
SALETX_AMT                                   Sales Tax Distribution Amount                            The amount of sales tax associated with this transaction.             26        ASSET_ACQ_DET
SALETX_AMT_BSE                               Base Sales Tax Amount                                    Sale Tax Amount in Transaction Currency                               26        ASSET_ACQ_DET
SALETX_CD                                    Sales Tax Code                                           The code representing the sales taxing authority associated with                ASSET_ACQ_DET
                                                                                                      this transaction.                                                      8
USETAX_AMT                                   Use Tax Distribution Amount                              The amount of use tax associated with this transaction.               26        ASSET_ACQ_DET
USETAX_AMT_BSE                               Base Use Tax Amount                                      Use Tax Amount in Transaction Currency.                               26        ASSET_ACQ_DET
USETAX_CD                                    Use Tax Code                                             The code representing the use taxing authority associated with                  ASSET_ACQ_DET
                                                                                                      this transaction.                                                      8
FERC_CD                                      FERC Code                                                Identifies the FERC code associated with this asset.                  10        ASSET
VAT_INV_AMT                                  VAT Invoice Amount                                       Vat Invoice in Transaction Currency.                                  26        ASSET_ACQ_DET
VAT_INV_AMT_BSE                              VAT invoice amount                                       Used in Payables/Assets integration.                                  26        ASSET_ACQ_DET
VAT_NRCVR_AMT                                VAT NonRecoverable Amount                                Vat Non Recoverable in Transaction Currency.                          26        ASSET_ACQ_DET
VAT_NRCVR_AMT_BSE                            VAT Nonrecoverable amount                                Used in Payables/Assets integration.                                  26        ASSET_ACQ_DET
VAT_RCVRY_AMT                                VAT Recovery Amt                                         Vat Recoverable in Transaction Currency.                              26        ASSET_ACQ_DET
VAT_RCVRY_AMT_BSE                            VAT recovery amount                                      Used in Payables/Assets integration.                                  26        ASSET_ACQ_DET




                                                                                                                                                                                                        8/1/20116:52 PM
       D:\Docstoc\Working\pdf\9eaa55ee-59bb-4fa8-90db-e338dc945f9d.xls FIELDS THAT WILL NOT BE USED                                                                                                        Page 31 of 36
                                                                      Asset Management Fields Not Intended for State Use

          Field Name                                                 Long Name                                     Use and Processing Considerations                          No.                  Tables Updated
                                                                                                                                                                           Characters

Beyond the Scope of the Current Project
TRANS_CODE                                   Transaction Code                                         Used to identify special accounting treatment for the transaction.                COST, DEPRECIATION
                                                                                                                                                                               5
IU_MAP_KEY                                   InterUnit Map Key                                        Used for InterUnit transfers.                                        Any length   Appears on COST.
AM_BK_UD_CHAR1                               User-Defined character field                                                                                                     10        BOOK
AM_BK_UD_CHAR2                               User-Defined character field                                                                                                     10        BOOK
AM_BK_UD_DATE1                               User-Defined date field                                                                                                         Date       BOOK
AM_BK_UD_NUM1                                User-Defined numeric field                                                                                                       18        BOOK
AM_BK_UD_NUM2                                User-Defined numeric field                                                                                                       18        BOOK
ASSET_RESOURCE_SW                            Asset Resource Switch                                    Used by Maintenance Management.                                                   ASSET


                                                                                                                                                                               1
ALLOW_OVERBOOK_SW                            Allow Overbooking                                        Used by Maintenance Management.                                                   ASSET


                                                                                                                                                                               1
CHARGE_BACK_SW                               Charge Back Switch                                       Used by Maintenance Management.                                                   ASSET


                                                                                                                                                                               1
SCHEDULABLE_SW                               Schedulable Switch                                       Used by Maintenance Management.                                                   ASSET


                                                                                                                                                                               1
EPL_TMPL_ID                                  Parts List Template                                      Used by Maintenance Management.                                                   ASSET


                                                                                                                                                                              15
REPAIRABLE_FLG                               Repairable Flag                                          Used by Maintenance Management.                                                   ASSET


                                                                                                                                                                               1




                                                                                                                                                                                                             8/1/20116:52 PM
       D:\Docstoc\Working\pdf\9eaa55ee-59bb-4fa8-90db-e338dc945f9d.xls FIELDS THAT WILL NOT BE USED                                                                                                             Page 32 of 36
                                                                      Asset Management Fields Not Intended for State Use

          Field Name                                                 Long Name                                    Use and Processing Considerations      No.               Tables Updated
                                                                                                                                                      Characters

REPAIR_STATUS                                Repair Status                                            Used by Maintenance Management.                              ASSET


                                                                                                                                                          1
BUSINESS_UNIT_WO                             Business Unit                                            Used by Maintenance Management..                             ASSET


                                                                                                                                                          5
SHOP_ID                                      Shop                                                     Used by Maintenance Management.                              ASSET


                                                                                                                                                         10
UNOWNED_FLG                                  Non-Owned Asset                                          Used by Maintenance Management.                              ASSET


                                                                                                                                                          1
WO_LOCATION_FLG                              Work Order Location                                      Used by Maintenance Management.                              ASSET


                                                                                                                                                          1
OFFLINE_FLG                                  Asset Offline                                            Used by Maintenance Management.                              ASSET


                                                                                                                                                          1
ASSET_CRITICALITY                            Asset Criticality                                        Used by Maintenance Management.                              ASSET


                                                                                                                                                          2
AVAIL_FOR_USE                                Available For Use                                        Used by Maintenance Management.                              ASSET


                                                                                                                                                          1
IT_UD_CHAR1                                  IT User Defined Char Field 1                             ITAM User Defined Fields                           50        ASSET
IT_UD_CHAR2                                  IT User Defined Char Field 2                             ITAM User Defined Fields                           50        ASSET
IT_UD_DATE1                                  IT User Defined Date Field                               ITAM User Defined Fields                          Date       ASSET



                                                                                                                                                                                    8/1/20116:52 PM
       D:\Docstoc\Working\pdf\9eaa55ee-59bb-4fa8-90db-e338dc945f9d.xls FIELDS THAT WILL NOT BE USED                                                                                    Page 33 of 36
                                                                       Asset Management Fields Not Intended for State Use

           Field Name                                                 Long Name                                    Use and Processing Considerations                       No.               Tables Updated
                                                                                                                                                                        Characters

PROPERTY_ID                                   Property I                                               Used by Real Estate Management. Identifier for an asset                       ASSET_PROPERTY
                                                                                                       property                                                            10
PROPERTY_DESCR                                Property Description                                     Used by Real Estate Management. Description of asset property                 ASSET_PROPERTY
                                                                                                                                                                           50
PROPERTY_NM                                   Property Name                                            Used by Real Estate Management. Name of the asset property.                   ASSET_PROPERTY
                                                                                                                                                                           50
PROPERTY_CLASS                                Property Class                                           Used by Real Estate Management. Indicator that the property is                ASSET_PROPERTY
                                                                                                       a SITE, BUILDING, FLOOR, AREA, or SPACE.                             2
PROPERTY_SUBCLASS                             Property Subclass                                        Used by Real Estate Management. Subcategory of Property                       ASSET_PROPERTY
                                                                                                       Class.                                                              20
PARENT_PROPERTY_ID                            Parent Property ID                                       Used by Real Estate Management. Parent Asset of the property.                 ASSET_PROPERTY
                                                                                                                                                                           10
SITE_PROPERTY_ID                              Site ID                                                  Used by Real Estate Management. Property ID of the SITE for                   ASSET_PROPERTY
                                                                                                       the asset's property hierarchy.                                     10
BLDG_PROPERTY_ID                              Building ID                                              Used by Real Estate Management. Property ID of the SITE for                   ASSET_PROPERTY
                                                                                                       the asset's property hierarchy.                                     10
FLOOR_PROPERTY_ID                             Floor ID                                                 Used by Real Estate Management. Property ID of the BUILDING                   ASSET_PROPERTY
                                                                                                       for the asset property hierarchy.                                   10
AREA_PROPERTY_ID                              Area ID                                                  Used by Real Estate Management. Property ID of the BUILDING                   ASSET_PROPERTY
                                                                                                       for the asset property hierarchy.                                   10
SPACE_PROPERTY_ID                             Space ID                                                 Used by Real Estate Management. Property ID of the AREA for                   ASSET_PROPERTY
                                                                                                       the asset's property hierarchy.                                     10
PARCEL_NUMBER                                 Parcel Number                                            Used by Real Estate Management. Property ID of the SPACE                      ASSET_PROPERTY
                                                                                                       for the asset's property hierarchy.                                 30
LOT                                           Lot Number                                               Used by Real Estate Management. Used to record legal                          ASSET_PROPERTY
                                                                                                       description from surveyors when recorded in Lots and Blocks.
                                                                                                                                                                           20
BLOCK                                         Block Number                                             Used by Real Estate Management. Used to record legal                          ASSET_PROPERTY
                                                                                                       description from surveyors when recorded in Lots and Blocks.
                                                                                                                                                                           20
TOTAL_AREA                                    Total Area                                               Used by Real Estate Management. Total measurement in sq. ft                   ASSET_PROPERTY
                                                                                                       or sq. meters for the asset.                                        17
SPACE_UOM                                     Space Unit of Measure                                    Used by Real Estate Management. Used in conjunction with                      ASSET_PROPERTY
                                                                                                       Total Area. Indicates Sq. Ft and Sq. Meters.                         1




                                                                                                                                                                                                      8/1/20116:52 PM
        D:\Docstoc\Working\pdf\9eaa55ee-59bb-4fa8-90db-e338dc945f9d.xls FIELDS THAT WILL NOT BE USED                                                                                                     Page 34 of 36
                                                                      Asset Management Fields Not Intended for State Use

           Field Name                                                Long Name                                     Use and Processing Considerations                         No.                    Tables Updated
                                                                                                                                                                          Characters

CURRENT_OCCUPANCY                            Current Occupancy                                        Used by Real Estate Management. Number of people currently                       ASSET_PROPERTY
                                                                                                      occupying the asset property.                                       Any length
MAX_OCCUPANCY                                Maximum Occupancy                                        Used by Real Estate Management. Max number of people that                        ASSET_PROPERTY
                                                                                                      can be assigned to the asset property.                              Any length
OCCUPANCY_STATUS                             Occupancy Status                                         Used by Real Estate Management. Indicates whether it is                          ASSET_PROPERTY
                                                                                                      "occupied" or "unoccupied".                                             2
OWNERSHIP_STATUS                             Ownership Status                                         Used by Real Estate Management. Indicates whether it is                          ASSET_PROPERTY
                                                                                                      "owned" or "leased".                                                    2
LEGAL_DESCR                                  Legal Description                                        Used by Real Estate Management. Legal description of asset                       ASSET_PROPERTY
                                                                                                      property using metes and bounds.                                      Long
REGION_CD                                    Region Code                                              Used by Real Estate Management for Space Utilization metrics.
                                                                                                      Prompt allows for values for RPT Region Types.                         10
BUDGET_REF                                   Budget Reference                                         A ChartField, which can be customized.                                  8        COST, DEPRECIATION
AFFILIATE                                    Affiliate                                                A ChartField, which can be customized.                                  5        COST, DEPRECIATION
AFFILIATE_INTRA1                             Fund Affiliate                                           A ChartField, which can be customized.                                 10        COST, DEPRECIATION
AFFILIATE_INTRA2                             Operating Unit Affiliate                                 A ChartField, which can be customized.                                 10        COST, DEPRECIATION
TRANSFER_BU                                  Transfer Business Unit                                   For an interunit asset transfer to transaction (transaction                      COST
                                                                                                      type=„TRF‟ and Transaction in/out switch=„I‟) this represents the
                                                                                                      business unit the asset was transferred from.
                                                                                                                                                                              5
TRANSFER_ASSET_ID                            Transfer Asset ID                                        This field works just like the Transfer Business Unit, only it                   COST
                                                                                                      represents the asset ID used in the transfer transaction.
                                                                                                                                                                             12
TRANSFER_BOOK                                Transfer From Book                                       This field works just like the Transfer Business Unit, only it                   COST
                                                                                                      represents the book used in the transfer transaction.                  10
IP_ADDRESS                                   IP Address                                               The Internet Protocol address of an asset, such as a computer                    ASSET
                                                                                                      or printer. Can be uploaded from Tangram‟s Asset Insight during
                                                                                                      Physical Inventory.                                                    15
IP_ALIAS                                     IP Alias                                                 May be used to capture the name of a user associated with an                     ASSET
                                                                                                      asset, since IP addresses may be dynamic.                              35
BUSINESS_UNIT_JV                             Joint Venture Business Unit                              The “parent” JV business unit, if the asset is part of a joint                   Used internally
                                                                                                      venture.                                                                5
MISC_AMT                                     Misc Charge Amount                                       Miscellaneous Charges in transaction Currency.                         26        ASSET_ACQ_DET
AM_AST_UD_CHAR1                              User Defined Char Field 1                                User defined.                                                          10        ASSET
AM_AST_UD_CHAR2                              User Defined Char Field 2                                User defined.                                                          10        ASSET


                                                                                                                                                                                                             8/1/20116:52 PM
       D:\Docstoc\Working\pdf\9eaa55ee-59bb-4fa8-90db-e338dc945f9d.xls FIELDS THAT WILL NOT BE USED                                                                                                             Page 35 of 36
                                                                     Asset Management Fields Not Intended for State Use

         Field Name                                                 Long Name                                    Use and Processing Considerations      No.               Tables Updated
                                                                                                                                                     Characters

AM_AST_UD_DATE1                             User Defined Date Field 1                                User defined.                                     Date       ASSET
AM_AST_UD_NUM1                              User Defined Number Field 1                              User defined.                                      18        ASSET
AM_AST_UD_NUM2                              User Defined Number Field 2                              User defined.                                      18        ASSET




                                                                                                                                                                                   8/1/20116:52 PM
      D:\Docstoc\Working\pdf\9eaa55ee-59bb-4fa8-90db-e338dc945f9d.xls FIELDS THAT WILL NOT BE USED                                                                                    Page 36 of 36

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:28
posted:8/2/2011
language:English
pages:36
Description: Real Estate Transaction Management document sample