Assets
This Asset table shows the columns in the import file:
| Column | Description | Type | Size |
|---|---|---|---|
| Member | The member name or ID in the database (such as a unit or a product) used for the Detail Budgeting data (e.g., San Diego or Baseball). | Text | 255 |
| AssetID | The ID of the asset. | Text | 255 |
| AcquisitionDate | The purchase date of the asset. | Date | mm/dd/yyyy |
| Quantity | The number of items purchased. | Integer | 5 |
| AssetType | The asset type. | Text | 255 |
| Description | (Optional) The asset description. | Text | 255 |
| AcquisitionCost | The cost of the items purchased. | Number | 21 |
| DisposalDate | (Optional) The date of transfer or disposal of asset if different from the date calculated by Detail Budgeting Administrator. | Date | mm/dd/yyyy |
| ActualDate | (Optional) The date of the initial purchase. Used for asset transfer. | Date | mm/dd/yyyy |
| ActualCost | (Optional) The Initial cost of the asset. Used for asset transfer. | Number | 21 |
| Version | (Optional) The Version dimension member for the data. If the version is mentioned in the section head, then the column is optional. If the Version parameter in the section head is Multiple, then the column is required. | Integer | 8 |
| SecondAllocation | (Optional) The allocation ID used for the secondary dimension. This ID determines how data is allocated across one or more of the secondary dimension members. | Integer | 8 |
This is a sample text file that could be imported into Detail Budgeting for assets.
Detail Budgeting]
Version=Budget
Columns=Member,AssetID,AcquisitionDate,Quantity,AssetType,Description,AcquisitionCost,DisposalDate,ActualDate,ActualCost
Administration,0001,7/1/98,1,Furniture,Chair,15000