Data in this section is described in accordance with the Conexxus Standard: https://www.conexxus.org/.
In this section, the following information about the Categories data is presented:
- Category Settings in CStoreOffice®
- Category Data Mapping Table
- XML Example with Category Data
- Categories Data Export via the Business Documents API
Category Settings in CStoreOffice®
Categories data used by the system is taken from the account price book. In CStoreOffice®, you can find categories data in the following forms:
- Category form
The form can be opened from Price Book > Category list. For more information, see Categories.
- Minimum Stock form
The form can be opened from Price Book > Category list > select a category > click Edit > click the Set Minimum Stock button. For more information, see Categories.
Category Data Mapping Table
Categories data from the above forms is converted to XML data according to the Category Data Mapping Table which is presented below.
Category Data Mapping Table
To learn more about CStoreOffice® forms and entities mentioned in the Description column, use the Category Settings in CStoreOffice® section or Petrosoft University Portal.
XML Example with Category Data
The example below is taken from the testing environment with testing data. No association with any real company, product, event, or data is intended or should be inferred.
XML Example with Category Data
<?xml version="1.0"?>
<MCTDetail>
<MerchandiseCode>6</MerchandiseCode>
<ActiveFlag value="yes"/>
<MerchandiseCodeDescription>Juices</MerchandiseCodeDescription>
<DescriptionID>1</DescriptionID>
<SalesRestriction>
<ProhibitDiscountFlag value="yes"/>
</SalesRestriction>
<Extension>
<Number/>
<GL>226</GL>
<GLDepartment>126</GLDepartment>
<GLCOG>121</GLCOG>
<ReportID/>
<ProhibitGPMCalc value="yes"/>
<IncompleteInvoicesAcceptanceFlag value="yes"/>
<IMOA value="yes"/>
<ExcludeFromFullInventoryAudits value="yes"/>
<MinStock/>
<DescriptionDetails>
<DescriptionID>1</DescriptionID>
<LanguageCode>esl/spa</LanguageCode>
<MerchandiseCodeDescription>Jugos</MerchandiseCodeDescription>
</DescriptionDetails>
<DescriptionDetails>
<DescriptionID>1</DescriptionID>
<LanguageCode>eng</LanguageCode>
<Description>All Packaged, Canned Or Bottled Juices And Water Sold As Single Drinks (Examples: Very Fine,Gatorade All Sizes, Tropicana.)</Description>
</DescriptionDetails>
<DescriptionDetails>
<DescriptionID>1</DescriptionID>
<LanguageCode>esl/spa</LanguageCode>
<Description>Todos los jugos envasados, enlatados o embotellados y agua vendidos como bebidas individuales (Ejemplos: muy finos, Gatorade todos los tamaсos, Tropicana.)</Description>
</DescriptionDetails>
</Extension>
</MCTDetail>
To download the XML Example with Category Data XML file, click here.
Categories Data Export via the Business Documents API
To export the XML files with the Categories data via the Business Documents API:
- Start calling the API from the
/account-level-resourcesendpoint. - Use categories as the Document type identifier value.
For more information, see Calling the Business Documents API at the Account Level.
