ItemCategoryAssignments
ItemCategoryAssignments
Columns
| Name | Type | Description |
| CatalogId [KEY] | Long | Value that uniquely identifies the catalog. |
| CatalogCode | String | Abbreviation that identifies the catalog. |
| CatalogName | String | Name of the catalog. Review and update the value for this attribute using the Items work area, and the Manage Catalogs task. |
| CategoryId [KEY] | Long | Value that uniquely identifies the category. |
| CategoryCode | String | Abbreviation that identifies the category. |
| CategoryName | String | Name of the category. Review and update the value for this attribute using the Items work area, and the Manage Catalogs task. |
| ItemId [KEY] | Long | Value that uniquely identifies the item. |
| OrganizationId [KEY] | Long | Value that uniquely identifies the organization. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Inventory Organizations task. |
| Item | String | Value that uniquely identifies the part, item, product, or service. |
| OrganizationCode | String | Abbreviation that identifies the organization. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Inventory Organizations task. |
| ItemDescription | String | Description of the item. |
| ItemClassId | Long | Value that uniquely identifies the item class. |
| ItemClassName | String | Name of the item class. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Item Classes task. |
| StartDate | Date | Date when the item category assignment becomes active. |
| EndDate | Date | Date when the item category assignment becomes inactive. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| Finder | String | finder |