Inventory attributes
| Attribute name | Attribute | Table name |
|---|---|---|
| Inventory On Hand | ||
| Commodity Code | COMMODITY_CODE | ITEMMAST |
| Costing Method | COST_METHOD | ICCOMPANY |
| Generic Name | GENERIC | ITEMMAST |
| Hazard Code | HAZARD_CODE | ITEMMAST |
| Hazardous | HARMONIZE_CD | ITEMMAST |
| IC Company | COMPANY | ICLOCATION |
| IC Company | COMPANY | ITEMLOC |
| IC Location Type | LOCATION_TYPE | ICLOCATION |
| Inventory Location Code | LOCATION | ICLOCATION |
| Inventory Location Name | NAME | ICLOCATION |
| Inventory Major Class | DESCRIPTION | MAJORCL |
| Inventory Minor Class | DESCRIPTION | MINORCL |
| Item Description | DESCRIPTION | ITEMMAST |
| Item Group | ITEM_GROUP | ITEMMAST |
| Item Number | ITEM | ITEMMAST |
| Manufacturer Code | MANUF_CODE | ITEMLOC |
| Manufacturer Code | MANUF_CODE | ITEMMAST |
| Manufacturer Division | MANUF_DIVISION | ITEMLOC |
| Manufacturer Division | MANUF_DIVISION | ITEMMAST |
| Manufacturer Number | MANUF_NBR | ITEMLOC |
| Manufacturer Number | MANUF_NBR | ITEMMAST |
| Purchasing Major Class | DESCRIPTION | MAJORCL |
| Purchasing Minor Class | DESCRIPTION | MINORCL |
| Reorder Document | REORD_DOC_CD | ITEMLOC |
| Sales Major Class | DESCRIPTION | MAJORCL |
| Sales Minor Class | DESCRIPTION | MINORCL |
| UNSPSC Class | ICCODE_LDESC | ICITEMCODE |
| UNSPSC Commodity | ICCODE_LDESC | ICITEMCODE |
| UNSPSC Family | ICCODE_LDESC | ICITEMCODE |
| UNSPSC Segment | ICCODE_LDESC | ICITEMCODE |
| Work Order Location Type | WO_LOC_TYPE | ICLOCATION |
| Inventory History | ||
| Commodity Code | COMMODITY_CODE | ITEMMAST |
| Generic Name | GENERIC | ITEMMAST |
| Hazard Code | HAZARD_CODE | ITEMMAST |
| Hazardous | HARMONIZE_CD | ITEMMAST |
| IC Company | COMPANY | ICLOCATION |
| IC Location Type | LOCATION_TYPE | ICLOCATION |
| Inventory Location Code | LOCATION | ICLOCATION |
| Inventory Location Name | NAME | ICLOCATION |
| Inventory Major Class | DESCRIPTION | MAJORCL |
| Inventory Minor Class | DESCRIPTION | MINORCL |
| Item Description | DESCRIPTION | ITEMMAST |
| Item Group | ITEM_GROUP | ITEMMAST |
| Item Number | ITEM | ITEMMAST |
| Manufacturer Code | MANUF_CODE | ITEMMAST |
| Manufacturer Division | MANUF_DIVISION | ITEMMAST |
| Manufacturer Number | MANUF_NBR | ITEMMAST |
| Purchasing Major Class | DESCRIPTION | MAJORCL |
| Purchasing Minor Class | DESCRIPTION | MINORCL |
| Sales Major Class | DESCRIPTION | MAJORCL |
| Sales Minor Class | DESCRIPTION | MINORCL |
| UNSPSC Class | ICCODE_LDESC | ICITEMCODE |
| UNSPSC Commodity | ICCODE_LDESC | ICITEMCODE |
| UNSPSC Family | ICCODE_LDESC | ICITEMCODE |
| UNSPSC Segment | ICCODE_LDESC | ICITEMCODE |
| Work Order Location Type | WO_LOC_TYPE | ICLOCATION |
| Inventory Transaction | ||
| Account Category | ACCT_CATEGORY | ICTRANS |
| Accounting Unit | INV_ACCT_UNIT | ICTRANS |
| Commodity Code | COMMODITY_CODE | ITEMMAST |
| Component Sequence | COMPONENT_SEQ | ICTRANS |
| Document | DOCUMENT | ICTRANS |
| Document Type | DOC_TYPE | ICTRANS |
| Generic Name | GENERIC | ITEMMAST |
| GL Account |
CASE WHEN ICTRANS.INV_ACCOUNT = 0 THEN 'No Account' else cast(ICTRANS.INV_ACCOUNT as varchar) + '-' + cast(ICTRANS.INV_SUB_ACCT as varchar) end |
ICTRANS |
| GL Chart | CHART_NAME | GLSYSTEM |
| Hazard Code | HAZARD_CODE | ITEMMAST |
| Hazardous | HARMONIZE_CD | ITEMMAST |
| IC Company | COMPANY | ICLOCATION |
| IC Company | COMPANY | ICTRANS |
| IC Location Type | LOCATION_TYPE | ICLOCATION |
| Inventory Location Code | LOCATION | ICLOCATION |
| Inventory Location Name | NAME | ICLOCATION |
| Inventory Major Class | DESCRIPTION | MAJORCL |
| Inventory Minor Class | DESCRIPTION | MINORCL |
| Item Description | DESCRIPTION | ITEMMAST |
| Item Group | ITEM_GROUP | ITEMMAST |
| Item Number | ITEM | ITEMMAST |
| Line Number | LINE_NBR | ICTRANS |
| Manufacturer Code | MANUF_CODE | ITEMMAST |
| Manufacturer Division | MANUF_DIVISION | ITEMMAST |
| Manufacturer Number | MANUF_NBR | ITEMMAST |
| Purchasing Major Class | DESCRIPTION | MAJORCL |
| Purchasing Minor Class | DESCRIPTION | MINORCL |
| Sales Major Class | DESCRIPTION | MAJORCL |
| Sales Minor Class | DESCRIPTION | MINORCL |
| System Code | SYSTEM_CD | ICTRANS |
| UNSPSC Class | ICCODE_LDESC | ICITEMCODE |
| UNSPSC Commodity | ICCODE_LDESC | ICITEMCODE |
| UNSPSC Family | ICCODE_LDESC | ICITEMCODE |
| UNSPSC Segment | ICCODE_LDESC | ICITEMCODE |
| Work Order Location Type | WO_LOC_TYPE | ICLOCATION |