Tables and Key Fields for Shipments

You must use or configure the tables and the key fields to support the integration.

As a sales administrator or implementor, use this integration to facilitate the data flow between multiple systems to store shipment information:

DSD Shipment
DSD Shipment Line

DSD Shipment

Use the following table and the key fields in the DSD Shipment (__ORACO__ShipmentDSD_c) staging table used for storing shipment header information.

Key Fields	API Name	Description
Shipment Number	`RecordName`	A unique alphanumeric key in SCM that identifies a shipment.
Account	`__ORACO__Account_c` `(__ORACO__Account_Id_c)`	The retailer account to which the shipment is delivered. You must ensure that this field is correctly set.
Order Number	`__ORACO__OrderRN_c`	The order for which the shipment was created.
Shipment Date	`__ORACO__ScheduledDate_c`	The shipment date provided by SCM.
Legal Entity	`__ORACO__LegalEntity_c` `(__ORACO__LegalEntity_Id_c)`	The manufacturer legal entity for the shipment.
Source System	`__ORACO__OrderSS_c`	Uniquely identifies the source for the shipment to track shipment.
Source System Number	`__ORACO__OrderSSN_c`	The unique number within each source system for a shipment to track shipment.
Created On	`__ORACO__CreatedOn_c`	This field must be set to 0 (zero) to identify the new records from SCM.

DSD Shipment Line

Use the following table lists the key field in the DSD Shipment Line (__ORACO__ShipmentLineDSD_c) staging table for storing shipment line information.

Key Fields	API Name	Description
Shipment Line Number	`RecordName`	A globally unique alphanumeric string provided by SCM for each shipment line.
Line Number	`__ORACO__ShipmentLineLN_c`	A numeric and unique line number within a shipment.
Shipment	`__ORACO__Shipment_c` `(__ORACO__Shipment_Id_c)`	The shipment header associated with the shipment line.
Account	`__ORACO__Account_c` `(__ORACO__Account_Id_c)`	The retailer account to which the shipment is delivered. Same as the Account field in the Shipment header. This field must be set correctly.
Product	`__ORACO__Product_c` `(__ORACO__Product_Id_c)`	The product being shipped.
Quantity	`__ORACO__Quantity_c`	The quantity of the product being shipped.
Source System	`__ORACO__ShipmentLineSS_c`	Uniquely identifies the source for the shipment to track shipment.
Source System Number	`__ORACO__ShipmentLineSSN_c`	The unique number within each source system for a shipment to track shipment.
Line Number	`__ORACO__ShipmentLineLN_c`	The unique numeric line number within a shipment to track shipment.
Created On	`__ORACO__CreatedOn_c`	This must be set to 0 (zero) to identify the new records from SCM.