Sending Outbound Data with the Item Master EIP
With the Item Master EIPs, you can send and receive complete item records.
The Item Master EIP includes four XML-based service operations defined in PeopleSoft Integration Broker: ITEM_SYNC, ITEM_SYNC_EFF, ITEM_FULLSYNC, and ITEM_FULLSYNC_EFF. Activate the ITEM_SYNC service operation to send incremental updates automatically as item information is updated online or by using the Change Item Status process (INS4000), Item Loader process (IN_ITMLOAD), or Publish Outbound Message process. Activate the ITEM_FULLSYNC service operation to perform full data replication by scheduling a batch process using the Full Data Publish utility. This process generates an outbound transaction containing item information.
If you are sending item data to a third-party system that cannot process effective-dated rows, activate the _EFF version of either the ITEM_SYNC or ITEM_FULLSYNC service operations. When you send item updates by using the _EFF service operations, future-dated segments of the data are removed from the outbound transaction and sent when the effective date equals the current date.
When you activate the ITEM_SYNC or ITEMSYNC_EFF service operations, outbound item information is generated from these 11 points within the PeopleSoft system as approved items are being maintained:
-
Define Item component.
-
Purchasing Attributes component.
-
Approve Item component.
-
Purchasing Attributes component.
-
Units of Measure component.
-
Universal Item Identifiers.
-
Copy Item component.
-
Revision Maintenance component.
-
BOM Mass Maintenance by MMC.
-
BOM Mass Maintenance by ECO.
-
Item Loader process (IN_ITMLOAD).
-
Item Add component.
Note:
To send the outbound data for BOM Mass Maintenance by MMC or by ECO, run both the ENPMMAIN COBOL process and the Publish Outbound Message (Item Revision option) process. To send the data for Revision Maintenance, run the Publish Outbound Message (Item Revision option) process.
See PeopleSoft Supply Chain Management Integration: PeopleSoft SCM Outbound EIPs.
See PeopleSoft Supply Chain Management Integration: General WMS Integration Issues.
Message Structure
Each service operation uses a message to define the fields and records to be used in the EIP. The structure of the item messages is:
| Segment | Parent | Valid Relationships |
|---|---|---|
|
Item Master. |
None. |
|
|
Item Detail. |
Item Master. |
1:1 on effective-dated messages or both 1:1 and 1:many on messages that are not effective-dated. |
|
Item UOM. |
Item Master. |
1:1 or 1:many. |
|
Item Purchasing Attributes. |
Item Master. |
1:0 or 1:1. |
|
Item Bus Unit Attributes. |
Item Master. |
1:0, 1:1, or 1:many. |
|
Item Bus Unit Weight/Volume. |
Item Bus Unit Attributes. |
1:0 or 1:1, or 1:many. |
|
Item Revision. |
Item Bus Unit Attributes. |
1:0, 1:1, or 1:many. |
|
Item Category. |
Item Master. |
1:0, 1:1, or 1:many. |
|
Item Manufacturer. |
Item Master. |
1:0, 1:1, or 1:many. |
|
Universal Item Identifier. |
Item Master. |
1:0, 1:1, or 1:many. |
Message Segments
The segments that are delivered in each of the item messages vary depending on the source of the message. The tables that are provided under each of the data sources display the segments that are delivered based on the function that is being performed.
-
The parent segment of the message is always included on the EIP transaction.
If the parent segment does not have a PSCAMA record, or if it does have a PSCAMA record with a blank audit action code, then no modifications are made to the parent segment. In this case, the parent is included only for reference purposes.
-
The EIP transaction is published if any fields for a source record are altered on any of the pages that are listed.
The audit action code on the PSCAMA record is set to the appropriate code based on the action that is being performed (add, change, or delete). Because all fields of the source record are not sent on the EIP transaction, cases may exist in which transactions are published even though none of the fields have been modified. The logic that determines whether to publish a transaction only checks that the source record has been altered. It does not check field by field to determine whether the altered fields are on the message used by the EIP transaction.
-
Because the logic that publishes the transaction does not check field by field to determine whether a specific field has been altered, all fields that are on a message segment are published if any field that is on the source record is altered.
-
The item EIP transactions are published only for an item that has an Approved status.
Define Item
The component sends out various segments of a message depending on the function that is being performed.
-
Add mode with a status of Approved:
Segment Audit Action Comments and Data Rules Item Master
A
Always published.
Item Detail
A
Always published.
Item UOM
A
Always published.
-
Update or Correction mode with an item that is saved with a new Approved status.
Because an item EIP transaction is never published until it is approved, all message segments for the item are used when approved:
Segment Audit Action Comments and Data Rules Item Master
A
Always published.
Item Detail
A
Always published.
Item UOM
A
Always published.
Item Purchasing Attributes
A
Published only if any exist.
Item Bus Unit Attributes
A
Published only if any exist.
Item Bus Unit Wgt/Vol
A
Published only if any exist.
Item Revision
A
Published only if any exist.
Item Category
A
Published only if any exist.
Item Manufacturer
A
Published only if any exist.
Universal Item Identifier
A
Published only if any exist.
-
Update or Correction mode with a previously approved item:
Segment Audit Action Comments and Data Rules Item Master
C or space
Always published.
Item Detail
C, D, or space
Published only if a field from the Inventory Item table (ITEM_INV) is modified.
Item UOM Page
The Item UOM page provides these message segments:
| Segment | Audit Action | Comments and Data Rules |
|---|---|---|
|
Item Master |
Space |
Always published. |
|
Item UOM |
A, C, or D |
Always published. |
|
Item Manufacturer |
Space |
Published only if GTINs are added, changed, or deleted. |
|
Universal Item Identifier |
A, C, or D |
Published only if GTINs are added, changed, or deleted. |
Universal Item Identifiers Page
The Universal Item Identifiers page provides these message segments:
| Segment | Audit Action | Comments and Data Rules |
|---|---|---|
|
Item Master |
Space |
Always published. |
|
Item Manufacturer |
Space |
Published only if GTINs are added, changed, or deleted. |
|
Universal Item Identifier |
A, C, or D |
Published only if GTINs are added, changed, or deleted. |
Purchasing Attributes Page
The Purchasing Attributes page provides these message segments:
| Segment | Audit Action | Comments and Data Rules |
|---|---|---|
|
Item Master |
Space |
Always published. |
|
Item Purchasing Attributes |
A or C |
Always published. |
Define Business Unit Item Page
You can use Add or Update mode.
-
Add mode: When the page is saved in Add mode, all message segments for the Item EIP are published with an Audit Action Code of A.
Interfacing systems that are only taking a transaction when the item is added to the business unit use this message to build all information for the item.
Interfacing systems that take transactions before a business unit is established update their item structures with the business unit level information:
Segment Audit Action Comments and Data Rules Item Master
A
Always published.
Item Detail
A
Always published.
Item UOM
A
Always published.
Item Purchasing Attributes
A
Published only if it exists.
Item Bus Unit Attributes
A
Only the business unit that is being added is published. In this situation, the relationship between the Item Master segment and the Item Bus Unit Attributes segment is always a one-to-one relationship.
Item Bus Unit Wgt/Vol
A
Published only if any exist.
-
Update mode:
Segment Audit Action Comments and Data Rules Item Master
Space
Always published.
Item Bus Unit Attributes
C or space
Only the business unit that is being changed is published. In this situation, the relationship between the Item Master segment and the Item Bus Unit Attributes segment is always a one–to-one relationship.
Item Bus Unit Wgt/Vol
A, C, or D
Only published if the BU_ITEMS_WTVOL is modified.
Item Approval Page
Because the item EIP is never published until an item is approved, all segments for the item are published when it is approved:
| Segment | Audit Action | Comments and Data Rules |
|---|---|---|
|
Item Master |
A |
Always published. |
|
Item Detail |
A |
Always published. |
|
Item UOM |
A |
Always published. |
|
Item Purchasing Attributes |
A |
Published only if any exist. |
|
Item Bus Unit Attributes |
A |
Published only if any exist. |
|
Item Bus Unit Wgt/Vol |
A |
Published only if any exist. |
|
Item Revision |
A |
Published only if any exist. |
|
Item Category |
A |
Published only if any exist. |
|
Item Manufacturer |
A |
Published only if any exist. |
|
Universal Item Identifier |
A |
Published only if any exist. |
Item Copy Page
The Item Copy page provides these message segments:
| Segment | Audit Action | Comments and Data Rules |
|---|---|---|
|
Item Master |
A or space |
Always published. |
|
Item Detail |
A |
Published only if this segment is copied. |
|
Item UOM |
A |
Published only if this segment is copied. |
|
Item Purchasing Attributes |
A |
Published only if this segment is copied. |
|
Item Bus Unit Attributes |
A |
Published only if this segment is copied. |
|
Item Bus Unit Wgt/Vol |
A |
Published only if this segment is copied. |
|
Item Category |
A |
Published only if any exist. |
REV Maintenance
The REV Maintenance page provides these message segments:
| Segment | Audit Action | Comments and Data Rules |
|---|---|---|
|
Item Master |
Space |
Always published. |
|
Item Bus Unit Attributes |
Space |
Always published. |
|
Item Bus Unit Wgt/Vol |
A, C, or D |
Always published. |
BOM Mass Maintenance by MMC and BOM Mass Maintenance by ECO
The BOM Mass Maintenance pages provide these message segments:
| Segment | Audit Action | Comments and Data Rules |
|---|---|---|
|
Item Master |
Space |
Always published. |
|
Item Bus Unit Attributes |
Space |
Always published. |
|
Item Bus Unit Wgt/Vol |
A, C, or D |
Always published. |
Item Loader Process
The Item Loader process provides different message segments depending on the action that is being taken with the item.
When adding a new item with an Approved status:
| Segment | Audit Action | Comments and Data Rules |
|---|---|---|
|
Item Master |
A |
Always published. |
|
Item Detail |
A |
Always published. |
|
Item UOM |
A |
Always published. |
|
Item Purchasing Attributes |
A |
Published only if it exists. |
|
Item Bus Unit Attributes |
A |
Published only if it exists. |
|
Item Bus Unit Wgt/Vol |
A |
Published only if it exists. |
|
Item Revision |
A |
Published only if it exists. |
|
Item Category |
A |
Published only if it exists. |
|
Item Manufacturer |
A |
Published only if it exists. |
|
Universal Item Identifier |
A |
Published only if it exists. |
When updating an existing item that has reached an Approved status:
| Segment | Audit Action | Comments and Data Rules |
|---|---|---|
|
Item Master |
C or space |
Always published. |
|
Item Detail |
C or space |
Published only if altered on inbound message. |
|
Item UOM |
A, C, or space |
Published only if altered on inbound message. |
|
Item Purchasing Attributes |
C or space |
Published only if altered on inbound message. |
|
Item Bus Unit Attributes |
A, C, or space |
Published only if altered on inbound message. |
|
Item Bus Unit Wgt/Vol |
A, C, or space |
Published only if altered on inbound message. |
|
Item Revision |
A, C, or space |
Published only if altered on inbound message. |
|
Item Category |
A, C, or space |
Published only if altered on inbound message. |
|
Item Manufacturer |
A, C, or space |
Published only if altered on inbound message. |
|
Universal Item Identifier |
A, C, or space |
Published only if altered on inbound message. |
Full Data Publish
This function is used to copy all items in the database to an interfacing system, or if chunking is being used, to copy all items for a specific chunking value. In this case, all data is published with an audit action code of A:
| Segment | Audit Action | Comments and Data Rules |
|---|---|---|
|
Item Master |
A |
Always published. |
|
Item Detail |
A |
Always published. |
|
Item UOM |
A |
Always published. |
|
Item Purchasing Attributes |
A |
Published only if it exists. |
|
Item Bus Unit Attributes |
A |
Published only if it exists. |
|
Item Bus Unit Wgt/Vol |
A |
Published only if it exists. |
|
Item Revision |
A |
Published only if it exists. |
|
Item Category |
A |
Published only if it exists. |
|
Item Manufacturer |
A |
Published only if it exists. |
|
Universal Item Identifier |
A |
Published only if it exists. |