Advanced Enterprise Technologies, Inc.
Table of Contents

Items Sample

Item import samples are available in the following file formats:

 

Download Sample

Microsoft Excel Worksheet

Account ID Account Number Account Name Item ID Structure ID Item Type Item Description Item Value Date Added Date Dropped Serial Number Oil Change Date
1   DIV-A Division A     Fine Arts Andrew Wyeth painting 3500000 11/08/1997      
2 12176   Maintenance     Portable Yard Equipment Brush Hog Stump Grinder 3750 08/01/2020   BH002513A 07/09/2021
3                        
 
Download Sample

JSON File

{
  "items": [
    {
      "accountId": "",
      "accountNumber": "DIV-A",
      "accountName": "Division A",
      "itemId": "",
      "structureId": "",
      "itemType": "Fine Arts",
      "itemDescription": "Andrew Wyeth painting",
      "itemValue": "3500000",
      "dateAdded": "11/08/1997",
      "dateDropped": "",
      "serialNumber": "",
      "userDefinedFields": []
    },
    {
      "accountId": "12176",
      "accountNumber": "",
      "accountName": "Maintenance",
      "itemId": "",
      "structureId": "",
      "itemType": "Portable Yard Equipment",
      "itemDescription": "Brush Hog Stump Grinder",
      "itemValue": "3750",
      "dateAdded": "08/01/2020",
      "dateDropped": "",
      "serialNumber": "BH002513A",
      "userDefinedFields": [
        {
          "fieldName": "Oil Change Date",
          "fieldValue": "07/09/2021"
        }
      ]
    }
  ]
}
 
Download Sample

XML Document

<?xml version="1.0"?>
<import>
  <item>
    <accountId></accountId>
    <accountNumber>DIV-A</accountNumber>
    <accountName>Division A</accountName>
    <itemId></itemId>
    <structureId></structureId>
    <itemType>Fine Arts</itemType>
    <itemDescription>Andrew Wyeth painting</itemDescription>
    <itemValue>3500000</itemValue>
    <dateAdded>11/08/1997</dateAdded>
    <dateDropped></dateDropped>
    <serialNumber></serialNumber>
  </item>
  <item>
    <accountId>12176</accountId>
    <accountNumber></accountNumber>
    <accountName>Maintenance</accountName>
    <itemId></itemId>
    <structureId></structureId>
    <itemType>Portable Yard Equipment</itemType>
    <itemDescription>Brush Hog Stump Grinder</itemDescription>
    <itemValue>3750</itemValue>
    <dateAdded>08/01/2020</dateAdded>
    <dateDropped></dateDropped>
    <serialNumber>BH002513A</serialNumber>
    <userDefinedField>
      <fieldName>Oil Change Date</fieldName>
      <fieldValue>07/09/2021</fieldValue>
    </userDefinedField>
  </item>
</import>