Content was last updated in 06.23.03-00
This data conversion can be used to create/update Sub-Category definitions in R2.
The following table shows the fields which are supposed to be in the CSV format, required to create or Update Inventory Sub-Category definitions in R2 using Data Conversion.
Column Name |
Data Type |
Description |
Default Value |
Is Mandatory? |
Can be Updated? |
Invsubcategoryid |
Varchar2(22) |
Inventory Sub-category’s ID. |
|
Yes |
|
InvSubcategorydesc |
Varchar2(22) |
Inventory Sub-category’s description. |
|
Yes |
Yes |
Availgroup |
Varchar2(40) |
Availability group’s ID (Support is not given). |
Null |
|
Yes |
Exchangegroup |
Varchar2(40) |
Sub-Category’s Exchange Group’s ID. |
Null |
|
Yes |
Commgroup |
Varchar2(40) |
Sub-Category’s Commission Group’s ID. |
Null |
|
Yes |
Metergroup |
Varchar2(40) |
Sub-Category’s Meter Group’s ID. |
Null |
|
Yes |
Reportgroup |
Varchar2(40) |
Sub-Category’s Report Group’s ID. |
Null |
|
Yes |
Maingroup |
Varchar2(40) |
Sub-Category’s Main Group’s ID. |
Null |
|
Yes |
Attrgroup |
Varchar2(50) |
Sub-Category’s Attribute Group’s ID. |
Null |
|
Yes |
Taxgroup |
Varchar2(40 |
Sub-Category’s Tax Group’s ID. |
Null |
|
Yes |
Maintenancegroup |
Varchar2(40) |
Sub-Category’s Maintenance Group’s ID. |
Null |
|
Yes |
Pricinggroup |
Varchar2(40) |
Sub-Category’s Pricing Group’s ID. |
Null |
|
Yes |
Lifegroupid |
Varchar2(40) |
Sub-Category’s Life Group’s ID |
Null |
|
Yes |
Canrent |
Char(1) |
Whether allowed for Renting or not. Y - Yes , N - No |
Null |
|
Yes |
CanSell |
Char(1) |
Whether allowed for Selling or not. Y - Yes , N - No |
Null |
|
Yes |
AllowSubrent |
Char(1) |
Whether allowed for Sub-renting or not. Y - Yes , N - No |
Null |
|
Yes |
Allowdiscount |
Number(15,6) |
|
|
|
Yes |
Affectsavailability |
Char(1) |
Y - Yes , N - No |
Null |
|
Yes |
Isdepreciable |
Char(1) |
Y - Yes , N - No |
Null |
|
Yes |
Ismaintainstatistics |
Char(1) |
Y - Yes , N - No |
Null |
|
Yes |
Damagewaiver |
Char(1) |
Y - Yes , N - No |
Null |
|
Yes |
Revenuegroup |
Varchar2(40) |
Sub-Category’s Revenue Group’s ID. |
Null |
|
Yes |
Sellglcode |
Varchar2(40) |
Sub-Category’s Sell GL Code. |
Null |
|
Yes |
Subrentglcode |
Varchar2(40) |
Sub-Category’s Sub-rent GL Code. |
Null |
|
Yes |
Subrentalexpense |
Varchar2(40) |
Sub-rental Expense. |
Null |
|
Yes |
Cogsgroup |
Varchar2(40) |
Sub-Category’s COGS Group. |
Null |
|
Yes |
Deprglcode |
Varchar2(40) |
Sub-Category’s Depreciation GL Code. |
Null |
|
Yes |
Inventorygroup |
Varchar2(40) |
Sub-Category’s Inventory Group. |
Null |
|
Yes |
Accumdeprglcode |
Varchar2(40) |
Sub-Category’s Accumulated Depreciation GL Code. |
Null |
|
Yes |
Writeoffglcode |
Varchar2(40) |
Sub-Category’s Write Off GL Code. |
Null |
|
Yes |
Discountgroup |
Varchar2(40) |
Sub-Category’s Discount Group. |
Null |
|
Yes |
Categoryid |
Varchar2(50) |
Category’s ID |
Null |
|
Yes |
Daysinweek |
Number(12,3) |
Days in a week. |
Null |
|
|
Deprgrouplife |
Number(9) |
Value within the Life field of the Depreciation Group. |
Null |
|
|
Consumable |
Char(1) |
0 - No, 1 - Yes |
Null |
|
Yes |
A log file named ErrInvSubCategory_Data.log gets generated, if any errors occur while creating/updating the field definitions for Inventory Sub-Category. The following table shows the fields present in the log file.
Column Name |
Description |
Invsubcategoryid |
ID of Sub-Category whose creation/updation has failed |
InvSubcategorydesc |
Description of Sub-Category whose creation/updation has failed |
ErrorDetails |
The reason for failure |