| Item Name | Item Description | Item Depends On | It Ext Column | Item Key | Item Id |
| Asset Category Id | Identifies category to which the asset belongs | Asset.Asset Category Id | ASSET_CATEGORY_ID | ASSET_CATEGORY_ID | 116557 |
| Asset Id | System generated asset identification number | Asset.Asset Id | ASSET_ID | ASSET_ID | 116567 |
| Asset Number | User assigned asset number | Asset.Asset Number | ASSET_NUMBER | ASSET_NUMBER | 116577 |
| Asset Type | Indicates whether the asset is CIP, capitalized, or expensed | Asset.Asset Type | ASSET_TYPE | ASSET_TYPE | 116587 |
| Book Type Code | Book name | Asset.Book Type Code | BOOK_TYPE_CODE | BOOK_TYPE_CODE | 120183 |
| Category Description | Description of the category | Asset.Category Description | CATEGORY_DESCRIPTION | CATEGORY_DESCRIPTION | 121681 |
| Code Combination | | Asset.Code Combination | CODE_COMBINATION | CODE_COMBINATION | 122401 |
| Current Units | Current number of units for the asset | Asset.Current Units | CURRENT_UNITS | CURRENT_UNITS | 127370 |
| Description | The accounting period description. | Asset.Description | ASSET_DESCRIPTION | DESCRIPTION | 129523 |
| Distribution Id | Unique distribution identification number | Asset.Distribution Id | DISTRIBUTION_ID | DISTRIBUTION_ID | 130227 |
| In Use Flag | Indicates whether the asset is in use | Asset.In Use Flag | IN_USE_FLAG | IN_USE_FLAG | 137569 |
| Inventorial Flag | Indicates whether the asset should be included in physical inventory | Asset.Inventorial Flag | INVENTORIAL | INVENTORIAL_FLAG | 137183 |
| Lease Id | Lease identification number | Asset.Lease Id | LEASE_ID | LEASE_ID | 141733 |
| Lease Number | | Asset.Lease Number | LEASE_NUMBER | LEASE_NUMBER | 141735 |
| Manufacturer Name | Name of manufacturer | Asset.Manufacturer Name | MANUFACTURER_NAME | MANUFACTURER_NAME | 146139 |
| Model Number | Model number of asset | Asset.Model Number | MODEL_NUMBER | MODEL_NUMBER | 147412 |
| New Used Flag | Indicates whether the asset is new or used | Asset.New Used Flag | NEW_USED | NEW_USED_FLAG | 148044 |
| Owned Leased Flag | Indicates whether asset is owned or leased | Asset.Owned Leased Flag | OWNED_LEASED | OWNED_LEASED_FLAG | 151742 |
| Parent Asset Number | Identifies a parent asset for subcomponents | Asset.Parent Asset Number | PARENT_ASSET_ID | PARENT_ASSET_NUMBER | 151853 |
| Property 1245 1250 Code | Indicates whether property class is 1245 (personal) or 1250 (real) | Asset.Property 1245 1250 Code | PROPERTY_1245_1250_CODE | PROPERTY_1245_1250_CODE | 156744 |
| Property Type Code | Indicates the property type | Asset.Property Type Code | PROPERTY_TYPE_CODE | PROPERTY_TYPE_CODE | 156747 |
| Serial Number | Serial number of asset | Asset.Serial Number | SERIAL_NUMBER | SERIAL_NUMBER | 161374 |
| Tag Number | Tag number of the asset | Asset.Tag Number | TAG_NUMBER | TAG_NUMBER | 164525 |
| Join Name | Join Condition | Join Details | Optional Join Configuration | Auto |
| Asset -> Asset Assignment | Asset.Asset Id = Asset Assignment.Asset Id | Always exist in master folder | None | No |
| Asset -> Asset Book Asset | Asset.Asset Id = Asset Book Asset.Asset Id | Always exist in master folder | None | No |
| Asset -> Asset Source Line | Asset.Asset Id = Asset Source Line.Asset Id | Always exist in master folder | None | No |
| Asset -> Asset Transaction Header | Asset.Asset Id = Asset Transaction Header.Asset Id | Always exist in master folder | None | No |
| Asset -> Asset Transaction Line | Asset.Asset Id = Asset Transaction Line.Asset Id | Always exist in master folder | None | No |
| Asset -> Depreciation | Asset.Asset Id = Depreciation.Asset Id | Always exist in master folder | None | No |