ItemBatches
The Item Batches resource manages item batches and submits the interface records of item batches for import.
Columns
| Name | Type | Description |
| BatchNumber | String | Number that identifies the item batch. |
| BatchName | String | Name of the item batch. |
| BatchId [KEY] | String | Value that uniquely identifies the item batch. |
| SpokeSystemName | String | Name of the spoke system. Review and update the value for this attribute using the Product Information Management work area, and the Manage Spoke Systems task. |
| SpokeSystemCode | String | Abbreviation that identifies the spoke system. Review and update the value for this attribute using the Product Information Management work area, and the Manage Spoke Systems task. |
| SpokeSystemId | String | Value that uniquely identifies the spoke system. Review and update the value for this attribute using the Product Information Management work area, and the Manage Spoke Systems task. |
| AssignedTo | String | User who is assigned to the item batch. |
| DefaultOrganizationCode | String | Abbreviation that identifies the default organization of the item batch. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Inventory Organizations task. |
| DefaultOrganizationId | String | Value that uniquely identifies the default organization of the item batch. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Inventory Organizations task. The default value is the value from the spoke system of the item batch. |
| ImportCrossReferencesOnlyFlag | Bool | Contains one of the following values: true or false. If true, then only cross-references are imported. If false, then cross-references are not imported. The default value is the value from the spoke system of the item batch. |
| BatchStatus | String | Status of the item batch. A list of accepted values is defined in the lookup type EGI_IMPORT_BATCH_STATUS. Review the list of values using the Setup and Maintenance work area, and the Manage Standard Lookups task. |
| BatchStatusCode | String | Abbreviation that identifies the status of the item batch. A list of accepted values is defined in the lookup type EGI_IMPORT_BATCH_STATUS. Review the list of values using the Setup and Maintenance work area, and the Manage Standard Lookups task. |
| CreatedBy | String | User who created the item batch. |
| CreationDateTime | Datetime | Date and time when the user created the item batch. |
| LastUpdateDateTime | Datetime | Date and time when the user most recently updated the item batch. |
| LastUpdatedBy | String | User who most recently updated the item batch. |
| ImportSchedule | String | Value that indicates how item data gets imported after uploading it to the item batch. A list of accepted values is defined in the lookup type EGI_IMPORT_ON_DATA_LOAD. Review the list of values using the Setup and Maintenance work area, and the Manage Standard Lookups task. |
| ImportScheduleCode | String | Abbreviation that identifies how item data gets imported after uploading it to the item batch. A list of accepted values is defined in the lookup type EGI_IMPORT_ON_DATA_LOAD. Review the list of values using the Setup and Maintenance work area, and the Manage Standard Lookups task. The default value is the value from the spoke system of the item batch. |
| ScheduleDateTime | Datetime | Date and time when the item batch is scheduled to run to import the item data. |
| ProcessItems | String | Value that indicates how items are grouped during import. A list of accepted values is defined in the lookup type ORA_EGI_PROCESS_ITEMS_OPTIONS. Review the list of values using the Setup and Maintenance work area, and the Manage Standard Lookups task. |
| ProcessItemsCode | String | Abbreviation that identifies how items are grouped during import. A list of accepted values is defined in the lookup type ORA_EGI_PROCESS_ITEMS_OPTIONS. Review the list of values using the Setup and Maintenance work area, and the Manage Standard Lookups task. The default value is the value from the spoke system of the item batch. |
| DeleteProcessedRows | String | Value that indicates the interface rows that are to be deleted after import. A list of accepted values is defined in the lookup type ORA_EGP_PURGE_BATCH_ROWS_TYPE. Review the list of values using the Setup and Maintenance work area, and the Manage Standard Lookups task. |
| DeleteProcessedRowsCode | String | Abbreviation that identifies the interface rows that are to be deleted after import. A list of accepted values is defined in the lookup type ORA_EGP_PURGE_BATCH_ROWS_TYPE. Review the list of values using the Setup and Maintenance work area, and the Manage Standard Lookups task. The default value is the value from the spoke system of the item batch. |
| EnableDataQualityMatchingFlag | Bool | Contains one of the following values: true or false. If true, then data quality matching is enabled. If false, then data quality matching is not enabled. The default value is the value from the spoke system of the item batch. |
| ConfirmSingleMatchFlag | Bool | Contains one of the following values: true or false. If true, then single item matches get automatically confirmed during import. If false, then single item matches do not get automatically confirmed during import. The default value is the value from the spoke system of the item batch. |
| ConfirmUnmatchedNewFlag | Bool | Contains one of the following values: true or false. If true, then unmatched items get confirmed as new items during import. If false, then unmatched items do not get confirmed as new items during import. The default value is the value from the spoke system of the item batch. |
| StructureName | String | Name of the item structure. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Item Structure Type Details task. |
| StructureNameCode | String | Abbreviation that identifies the item structure. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Item Structure Type Details task. This attribute defaults the value from the spoke system of the item batch. |
| StructureEffectivityControl | String | Effectivity control of the item structure. Valid value is Date. |
| StructureEffectivityControlCode | Int | Abbreviation that identifies the effectivity control of the item structure. Valid value is 1. |
| StructureEffectivityDateTime | Datetime | Date and time when the structure component becomes effective. |
| StructureUpdate | String | Value that indicates the structure components that are to be updated. A list of accepted values is defined in the lookup type EGI_IMPORT_STRUCTURE_CONTENT. Review the list of values using the Setup and Maintenance work area, and the Manage Standard Lookups task. |
| StructureUpdateCode | String | Abbreviation that identifies the structure components that are to be updated. A list of accepted values is defined in the lookup type EGI_IMPORT_STRUCTURE_CONTENT. Review the list of values using the Setup and Maintenance work area, and the Manage Standard Lookups task. The default value is the value from the spoke system of the item batch. |
| PackUpdate | String | Value that identifies the pack components that are to be updated. A list of accepted values is defined in the lookup type EGI_IMPORT_STRUCTURE_CONTENT. Review the list of values using the Setup and Maintenance work area, and the Manage Standard Lookups task. |
| PackUpdateCode | String | Abbreviation that identifies the pack components that are to be updated. A list of accepted values is defined in the lookup type EGI_IMPORT_STRUCTURE_CONTENT. Review the list of values using the Setup and Maintenance work area, and the Manage Standard Lookups task. The default value is the value from the spoke system of the item batch. |
| NewItemRequestOption | String | Value that indicates how new item requests are created or updated by the item batch. A list of accepted values is defined in the lookup type EGI_CHANGE_ORDER_OPTION. Review the list of values using the Setup and Maintenance work area, and the Manage Standard Lookups task. |
| NewItemRequestOptionCode | String | Abbreviation that identifies how new item requests are created or updated by the item batch. A list of accepted values is defined in the lookup type EGI_CHANGE_ORDER_OPTION. Review the list of values using the Setup and Maintenance work area, and the Manage Standard Lookups task. The default value is the value from the spoke system of the item batch. |
| NewItemRequestSplitAutomaticallyFlag | Bool | Contains one of the following values: true or false. If true, then the imported items are split into multiple new item requests. If false, then the imported items are not split into multiple new item requests. The default value is the value from the spoke system of the item batch. |
| NewItemRequestAssociate | String | Value that indicates the creation of a new item request for the imported items or adding the imported items to an existing item request. A list of accepted values is defined in the lookup type EGI_CHG_ORDER_CREATION. Review the list of values using the Setup and Maintenance work area, and the Manage Standard Lookups task. |
| NewItemRequestAssociateCode | String | Abbreviation that identifies the creation of a new item request for the imported items or adding the imported items to an existing item request. A list of accepted values is defined in the lookup type EGI_CHG_ORDER_CREATION. Review the list of values using the Setup and Maintenance work area, and the Manage Standard Lookups task. The default value is the value from the spoke system of the item batch. |
| NewItemRequestNumber | String | Number that identifies the new item request. The default value is the value from the spoke system of the item batch. |
| NewItemRequestName | String | Name of the new item request. The default value is the value from the spoke system of the item batch. |
| NewItemRequestAddAllItemsFlag | Bool | Contains one of the following values: true or false. If true, then all imported items are added to a new item request. If false, then imported items are added to a new item request. The default value is the value from the spoke system of the item batch. |
| NewItemRequestEffectiveDateType | String | Value that indicates when the items imported to the new item request become effective. A list of accepted values is defined in the lookup type EGI_NIR_CO_EFFECTIVE_DATE. Review the list of values using the Setup and Maintenance work area, and the Manage Standard Lookups task. |
| NewItemRequestEffectiveDateTypeCode | String | Abbreviation that identifies when the items imported to the new item request become effective. A list of accepted values is defined in the lookup type EGI_NIR_CO_EFFECTIVE_DATE. Review the list of values using the Setup and Maintenance work area, and the Manage Standard Lookups task. The default value is the value from the spoke system of the item batch. |
| ChangeOrderOption | String | Value that indicates how change orders get created or updated by the item batch. A list of accepted values is defined in the lookup type EGI_CHANGE_ORDER_OPTION. Review the list of values using the Setup and Maintenance work area, and the Manage Standard Lookups task. |
| ChangeOrderOptionCode | String | Abbreviation that identifies how change orders get created or updated by the item batch. A list of accepted values is defined in the lookup type EGI_CHANGE_ORDER_OPTION. Review the list of values using the Setup and Maintenance work area, and the Manage Standard Lookups task. The default value is the value from the spoke system of the item batch. |
| ChangeOrderSplitAutomaticallyFlag | Bool | Contains one of the following values: true or false. If true, then the imported items are split into multiple change orders. If false, then the imported items are not split into multiple change orders. The default value is the value from the spoke system of the item batch. |
| ChangeOrderAssociate | String | Value that indicates the creation a new change order for the imported item changes or adding the imported item changes to an existing change order. A list of accepted values is defined in the lookup type EGI_CHG_ORDER_CREATION. Review the list of values using the Setup and Maintenance work area, and the Manage Standard Lookups task. |
| ChangeOrderAssociateCode | String | Abbreviation that identifies creation of a new change order for the imported item changes or adding the imported item changes to an existing change order. A list of accepted values is defined in the lookup type EGI_CHG_ORDER_CREATION. Review the list of values using the Setup and Maintenance work area, and the Manage Standard Lookups task. The default value is the value from the spoke system of the item batch. |
| ChangeOrderType | String | Type of change order. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Change Order Types task. |
| ChangeOrderTypeCode | String | Abbreviation that identifies the type of change order. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Change Order Types task. The default value is the value from the spoke system of the item batch. |
| ChangeOrderNumber | String | Number that identifies the change order. The default value is the value from the spoke system of the item batch. |
| ChangeOrderName | String | Name of the change order. The default value is the value from the spoke system of the item batch. |
| ChangeOrderAddAllItemsFlag | Bool | Contains one of the following values: true or false. If true, then all imported item changes are added to a change order. If false, then the imported item changes are not added to a change order. The default value is the value from the spoke system of the item batch. |
| ChangeOrderEffectiveDateType | String | Value that indicates when the item changes imported to the change order become effective. A list of accepted values is defined in the lookup type ORA_EGI_CO_EFFECTIVE_DATE. Review the list of values using the Setup and Maintenance work area, and the Manage Standard Lookups task. |
| ChangeOrderEffectiveDateTypeCode | String | Abbreviation that identifies when the item changes imported to the change order become effective. A list of accepted values is defined in the lookup type ORA_EGI_CO_EFFECTIVE_DATE. Review the list of values using the Setup and Maintenance work area, and the Manage Standard Lookups task. The default value is the value from the spoke system of the item batch. |
| LastMatchRequestId | String | Value that uniquely identifies last run item matching scheduled process. |
| LastImportRequestId | String | Value that uniquely identifies last run import scheduled process. |
| Type | String | Type of the Item batch. Valid values are E and I. The default value is E. |