Contents
- 1 Introduction
- 2 Communication overview
- 3 Inbound transactions
- 4 Outbound transactions
Introduction
This guide explains the communication processes and types of information that Iptor WM1 can receive and send. It provides an overview of the communication concepts along with the integration detail tables.
Communication overview
This chapter describes the general concepts and standards for Iptor WM1 communication.
Standard communication processes
Iptor WM1 works with Iptor Integrator to communicate with host and external systems, such as Iptor Enterprise and Lucas Systems™ voice-directed solutions. This section explains the standard processes for this communication.
Communication terminology
To understand the Iptor WM1 communication processes, it is first important to understand the terminology upon which the communication processes are built.
- Trigger – A defined occurrence that causes a transaction to be sent. Triggers are format neutral and cause data to be obtained from the system database or from an inbound interface file (IF) for later communication.
- Inbound communication – Communication that originates in an external system, such as Enterprise, and is received by Iptor WM1.
- Inbound IF – The entity in which the inbound communication data is sent. The IF defines how a record is identified and the IF segment information associated with the record. IFs are format-specific depending on the system to which they are mapped.
- Inbound IF segment – Represents a portion of the data that comprises the Inbound IF. The IF defines the set of fields for a segment record, including the position, data type, and length of each field.
- Outbound communication – Communication that originates from Iptor WM1 and is sent to an external system, such as Enterprise.
- Outbound IF – Data derived from a trigger and sent to another system.
- Outbound IF segment – Represents a portion of the data that comprises an outbound IF. For example, for a WMS reception trigger, the purchase order line reception and the purchase order header reception may be defined as different external segments.
Communication methods
Iptor WM1, through Integrator, can accept and process inbound data that has been written to a file or posted to a web service. XML or non-XML communication (such as .CSV or fixed byte files) formats can be used for either communication method.
For outbound communication, Iptor WM1 creates the information required for outbound integration transactions, and writes the information to the database in real time as the related operation occurs.
Inbound communication process
The following steps explain the actions that occur during standard inbound communication.
- An external system, such as Enterprise, sends information to Integrator as a download composed of one or more inbound interface files (IFs).
- Integrator identifies the IF, IF segments, and each instance, and then performs the following tasks:
- Determines what to do with the information, such as add, modify, or update.
- Generates a trigger.
- Determines resulting IFs.
- Populates IF segment tables within Iptor WM1.
- Sends data to the receiving application.
| Note | Inbound data is typically sent to the application database; however, a trigger may also generate an IF to an external system. |
Outbound communication process
The following steps explain the actions that occur during outbound communication.
- A defined action within Iptor WM1, such as picking inventory, generates a trigger.
- Integrator performs the following tasks:
- Determines the outbound IFs.
- Gathers the export data from the application database.
- Creates the outbound IFs.
- Sends the data to the receiving system using the assigned communication method.
Integration transactions format
Valid characters
The following characters are allowed for each of the communication formats:
- XML communication – Characters for XML communication must follow XML standards. Certain characters may need to be escaped when used as part of the data, such as ‘<’ and ‘>’. Some special characters, such as ampersands (&), at symbols (@), single quote characters (‘), and colons ( : ), may be reserved characters for other programs and processes that Iptor WM1 uses.
- Non-XML communication – Printable ASCII characters are allowed, including alphanumeric values such as A–Z, a–z, and 0–9. Certain characters may need to be escaped as needed for the data layout. For example, when using a .CSV file, a double quote (“) must be escaped by another double quote, as in “ “.
Common inbound transaction elements
The following transaction elements are common to all inbound transactions:
- Transaction name – Identifies the transaction being sent. Integrator refers to the inbound transaction name and then maps the inbound data to the matching Integrator transaction.
- Segment name(s) – Identifies a specific segment (for example, header or detail) in a transaction.
- Transaction type – Action performed on the segment. Valid values are (A)dd, (N)ext, (D)elete, and (C)hange.
Data exchange with a host system
Direction of exchange
The following table explains the information that Iptor WM1 can receive from and send to a host system.
|
Information |
Direction of Exchange |
|
Trailer information |
Inbound from host |
|
Outbound shipment |
Inbound from host |
|
Inbound shipment |
Inbound from host |
|
Trailer move |
Outbound to host |
|
Trailer audit discrepancy |
Outbound to host |
Data exchange with Enterprise
Direction of exchange
The following table explains the information that Iptor WM1 can receive from and send to Enterprise.
|
Information |
Direction of Exchange |
|
Basic items |
Inbound from Enterprise |
|
Business partner data |
Inbound from Enterprise |
|
Sales order information for dispatch planning |
Inbound from Enterprise |
|
Code synchronization |
Outbound to Enterprise |
|
Pick list information |
Outbound to Enterprise |
|
Purchase order information for reception planning |
Inbound from Enterprise |
|
Reception information |
Outbound to Enterprise |
|
Inventory adjustment |
Outbound to Enterprise |
|
Stock synchronization |
Outbound to Enterprise |
Inbound transactions mapping
The following table explains how inbound transactions from Enterprise map to Iptor WM1.
|
Enterprise Message Type |
Iptor WM1 IF |
Web Service |
|
|
IFIBPART |
Inbound Business Partner Interface |
IFIBPART |
http://serveraddress:webserviceport/web service name/service name/businessPartnerInterface/wsID |
|
IFIBPADR |
Inbound Business Partner Address Interface |
IFIBPADR |
http://serveraddress:webserviceport/web service name/service name/businessPartnerAddressInterface/wsID |
|
IFIITEM |
Inbound Item Interface |
IFIITEM |
http://serveraddress:webserviceport/web service name/service name/itemInterface/wsID |
|
IFIITEMBP |
Inbound Item Business Partner Interface |
IFIITEMBP |
http://serveraddress:webserviceport/web service name/service name/itemBusinessParterInterface/wsID |
|
IFIITEMLA |
Inbound Item Language Interface |
IFIITEMLA |
http://serveraddress:webserviceport/web service name/service name/itemLanguageInterface/wsID |
|
IFIITEMUN |
Inbound Item Unit Interface |
IFIITEMUN |
http://serveraddress:webserviceport/web service name/service name/itemUnitInterface/wsID |
|
IFIITTX |
Inbound Item Text Interface |
IFITTX |
http://serveraddress:webserviceport/web service name/service name/itemTextInterface/wsID |
|
IFIINOR |
Inbound Purchase (Inbound) Order Interface |
IFPURHD |
http://serveraddress:webserviceport/web service name/service name/purchaseOrderInterface/wsID |
|
IFPURDT |
Inbound Purchase (Inbound) Order Detail Interface |
IFPURDT |
http://serveraddress:webserviceport/web service name/service name/purchaseOrderDetailInterface/wsID |
|
IFIIBOHTX |
Inbound Purchase (Inbound) Order Text Interface |
IFIBOTX |
http://serveraddress:webserviceport/web service name/service name/purchaseOrderTextInterface/wsID |
|
IFIIOBPADR |
Inbound Purchase (Inbound) Order Business Partner Interface |
IFIBPADR |
http://serveraddress:webserviceport/web service name/service name/purchaseOrderBusinessPartnerAddressInterface/wsID |
|
IFIIBODTX |
Inbound Purchase (Inbound) Order Detail Text Interface |
IFIIBOTX |
http://serveraddress:webserviceport/web service name/service name/purchaseOrderDetailTextInterface/wsID |
|
IFSALHD |
Inbound Sales (Outbound) Order Interface |
IFSALHD |
http://serveraddress:webserviceport/web service name/service name/salesOrderInterface/wsID |
|
IFSALDT |
Inbound Sales (Outbound) Order Detail Interface |
IFSALDT |
http://serveraddress:webserviceport/web service name/service name/salesOrderDetailInterface/wsID |
|
IFIOBOHTX |
Inbound Sales (Outbound) Order Text Interface |
IFIOBOTX |
http://serveraddress:webserviceport/web service name/service name/salesOrderTextInterface/wsID |
|
IFIOUTBADR |
Inbound Sales (Outbound) Order Business Partner Address Interface |
IFIBADR |
http://serveraddress:webserviceport/web service name/service name/salesOrderBusinessPartnerAddressInterface/wsID |
|
IFIOBOTX |
Inbound Sales (Outbound) Order Detail Text Interface |
IFOBOTX |
http://serveraddress:webserviceport/web service name/service name/salesOrderDetailTextInterface/wsID |
Outbound transactions mapping
The following table explains the web service to use to send transactions from Iptor WM1 to Enterprise.
|
Transaction Type |
Web Service |
|
WMS Code Checking |
http://serveraddress:webserviceport/WmsToIbsEnterprise/CodeCheckService |
|
WMS Reception |
http://serveraddress:webserviceport/WmsToIbsEnterprise/ReceptionService |
|
WMS Picking |
http://serveraddress:webserviceport/WmsToIbsEnterprise/PickingService |
|
WMS Inventory |
http://serveraddress:webserviceport/WmsToIbsEnterprise/InventoryService |
|
WMS Stock Synchronization |
http://serveraddress:webserviceport/WmsToIbsEnterprise/SynchronizationService |
Data exchange with Lucas Systems voice-directed solutions
Direction of exchange
The following table explains the information that Iptor WM1 can receive from and send to Lucas Systems™ voice-directed solutions.
|
Information |
Direction of Exchange |
|
Voice task complete |
Inbound from Lucas Systems |
|
Business partner data |
Outbound from Lucas Systems |
|
Item information |
Outbound from Lucas Systems |
|
Location information |
Outbound to Lucas Systems |
|
Pick data |
Outbound to Lucas Systems |
Inbound transactions
This chapter describes the transactions that Iptor WM1 accepts from host and Enterprise systems.
Host transactions
This section provides the detailed inbound transaction layouts for host systems.
Trailer Interface transaction
Trailer segment
|
Column |
Description |
Required |
Foreign Key |
Default Value |
Data Type |
Length |
|
Container_code |
Container Code |
Yes |
Yes |
|
string |
10 |
|
owner_code |
Owner Code |
No |
Yes |
|
string |
20 |
|
transport_company_code |
Transport Company Code |
No |
Yes |
|
string |
35 |
|
container_type_code |
Container Type Code |
Yes |
Yes |
|
string |
10 |
|
container_size_code |
Container Size Code |
Yes |
Yes |
|
string |
10 |
|
container_level_type |
Container Level Type |
Yes |
Yes |
|
string |
10 |
|
stacking_class_code |
Stacking Class Code |
No |
No |
|
string |
18 |
|
container_code_alias |
Container Code Alias |
No |
No |
|
string |
18 |
|
pincode |
Pincode |
No |
No |
|
string |
10 |
|
container_usage |
Container Usage |
Yes |
No |
|
string |
5 |
|
task_abc_code |
Task ABC Code |
No |
No |
|
string |
1 |
|
container_active |
Container Active |
No |
No |
|
bit |
|
|
date_1 |
Date 1 |
No |
No |
|
datetime |
|
|
date_2 |
Date 2 |
No |
No |
|
datetime |
|
|
date_3 |
Date 3 |
No |
No |
|
datetime |
|
|
date_4 |
Date 4 |
No |
No |
|
datetime |
|
|
date_5 |
Date 5 |
No |
No |
|
datetime |
|
|
user_def_flag_1 |
User Defined Field 1 |
No |
No |
|
string |
10 |
|
user_def_flag_2 |
User Defined Field 2 |
No |
No |
|
string |
10 |
|
user_def_flag_3 |
User Defined Field 3 |
No |
No |
|
string |
10 |
|
user_def_flag_4 |
User Defined Field 4 |
No |
No |
|
string |
10 |
|
user_def_flag_5 |
User Defined Field 5 |
No |
No |
|
string |
10 |
|
user_def_flag_6 |
User Defined Field 6 |
No |
No |
|
string |
10 |
|
user_def_flag_7 |
User Defined Field 7 |
No |
No |
|
string |
10 |
|
user_def_flag_8 |
User Defined Field 8 |
No |
No |
|
string |
10 |
|
user_def_flag_9 |
User Defined Field 9 |
No |
No |
|
string |
10 |
|
reference_1 |
Reference Field 1 |
No |
No |
|
string |
35 |
|
reference_2 |
Reference Field 2 |
No |
No |
|
string |
35 |
|
reference_3 |
Reference Field 3 |
No |
No |
|
string |
35 |
|
reference_4 |
Reference Field 4 |
No |
No |
|
string |
35 |
|
reference_5 |
Reference Field 5 |
No |
No |
|
string |
35 |
|
length |
Length |
No |
No |
|
float |
|
|
width |
Width |
No |
No |
|
float |
|
|
height |
Height |
No |
No |
|
float |
|
|
putaway_key_code_handling |
Putaway Key Code Handling |
No |
Yes |
|
string |
2 |
|
putaway_key_code |
Putaway Key Code |
No |
No |
|
string |
128 |
|
damage_flag |
Damage Flag |
No |
No |
|
bit |
|
|
damage_code |
Damage Code |
No |
Yes |
|
string |
10 |
|
weight_threshold |
Weight Threshold |
No |
No |
|
float |
|
Outbound Shipment Interface transaction
Outbound shipment segment
|
Column |
Description |
Required |
Foreign Key |
Default Value |
Data Type |
Length |
|
external_outbound_shipment_id |
Outbound Shipment Id |
Yes |
No |
|
string |
35 |
|
external_shipment_id |
Load Number |
Yes |
No |
|
string |
35 |
|
owner_code |
Owner Code |
No |
Yes |
|
string |
10 |
|
container_code |
Container Code |
No |
Yes |
|
string |
18 |
|
outbound_template_code |
Outbound Template Code |
No |
No |
|
string |
10 |
|
shipping_method |
Shipping Method |
No |
No |
|
string |
5 |
|
outbound_shipment_desc |
Outbound Shipment Description |
No |
No |
|
string |
50 |
|
outbound_shipment_desc_2 |
Outbound Shipment Description |
No |
No |
|
string |
50 |
|
outbound_shipment_desc_3 |
Outbound Shipment Description |
No |
No |
|
string |
50 |
|
outbound_shipment_desc_4 |
Outbound Shipment Description |
No |
No |
|
string |
50 |
|
shipping_warehouse_code |
Shipping Warehouse Code |
No |
Yes |
|
string |
10 |
|
shipping_location_code |
Shipping Location Code |
No |
Yes |
|
string |
10 |
|
outbound_shipment_type |
Outbound Shipment Type |
No |
No |
|
string |
5 |
|
outbound_shipment_closing |
Outbound Shipment Closing |
No |
No |
|
string |
5 |
|
shipping_sequence_handling |
Shipping Sequence |
No |
No |
|
string |
5 |
|
sequence_offset |
Sequence Offset |
No |
No |
|
integer |
|
|
early_shipping_handling |
Early Shipping Handling |
No |
No |
|
string |
5 |
|
outbound_shipment_cat_1 |
Outbound Shipment Category 1 |
No |
No |
|
string |
20 |
|
outbound_shipment_cat_2 |
Outbound Shipment Category 2 |
No |
No |
|
string |
20 |
|
outbound_shipment_cat_3 |
Outbound Shipment Category 3 |
No |
No |
|
string |
20 |
|
outbound_shipment_cat_4 |
Outbound Shipment Category 4 |
No |
No |
|
string |
20 |
|
outbound_shipment_cat_5 |
Outbound Shipment Category 5 |
No |
No |
|
string |
20 |
|
outbound_shipment_cat_6 |
Outbound Shipment Category 6 |
No |
No |
|
string |
20 |
|
outbound_shipment_cat_7 |
Outbound Shipment Category 7 |
No |
No |
|
string |
20 |
|
outbound_shipment_cat_8 |
Outbound Shipment Category 8 |
No |
No |
|
string |
20 |
|
outbound_shipment_cat_9 |
Outbound Shipment Category 9 |
No |
No |
|
string |
20 |
|
load_simulation_activity_group_code |
Load Simulation Activity Group Code |
No |
No |
|
string |
10 |
|
calculated_volume |
Calculated Volume |
No |
No |
0 |
float |
|
|
calculated_weight |
Calculated Weight |
No |
No |
0 |
float |
|
|
gross_volume |
Gross Volume |
No |
No |
0 |
float |
|
|
gross_weight |
Gross Weight |
No |
No |
0 |
float |
|
|
net_volume |
Net Volume |
No |
No |
0 |
float |
|
|
net_weight |
Net Weight |
No |
No |
0 |
float |
|
|
calculated_activity_time |
Calculated Activity Time |
No |
No |
0 |
float |
|
|
planned_sequence |
Planned Sequence |
No |
No |
|
integer |
|
|
earliest_departure_dt |
Earliest Departure Date |
No |
No |
|
datetime |
|
|
latest_departure_dt |
Latest Departure Date |
No |
No |
|
datetime |
|
|
planned_start_dt |
Planned Start Date |
No |
No |
|
datetime |
|
|
planned_end_dt |
Planned End Date |
No |
No |
|
datetime |
|
|
calculated_start_time |
Calculated Start Time |
No |
No |
|
datetime |
|
|
calculated_end_time |
Calculated End Time |
No |
No |
|
datetime |
|
|
confirmed_start_time |
Confirmed Start Time |
No |
No |
|
datetime |
|
|
confirmed_end_time |
Confirmed End Time |
No |
No |
|
datetime |
|
|
effective_start_dt |
Effective Start date |
No |
No |
|
datetime |
|
|
effective_end_dt |
Effective End Date |
No |
No |
|
datetime |
|
|
shipment_planning_type |
Shipment Planning Type |
No |
No |
N |
string |
1 |
|
vehicle_type_code |
Vehicle Type Code |
No |
Yes |
|
string |
10 |
|
vehicle_code |
Vehicle Code |
No |
Yes |
|
string |
35 |
|
transport_company_code |
Transport Company Code |
No |
Yes |
|
string |
35 |
|
license_plate |
License Plate |
No |
No |
|
string |
20 |
|
driver_name |
Driver Name |
No |
No |
|
string |
50 |
|
cmr_document |
CMR Document |
No |
No |
|
string |
50 |
|
slot_start_dt |
Slot Start Date |
No |
No |
|
datetime |
|
|
slot_end_dt |
Slot End Date |
No |
No |
|
datetime |
|
|
arrival_time |
Arrival Time |
No |
No |
|
datetime |
|
|
departure_dt |
Departure Date |
No |
No |
|
datetime |
|
|
user_def_counter_1 |
User Default Counter 1 |
No |
No |
0 |
integer |
|
|
user_def_counter_2 |
User Default Counter 2 |
No |
No |
0 |
integer |
|
|
user_def_counter_3 |
User Default Counter 3 |
No |
No |
0 |
integer |
|
|
user_def_counter_4 |
User Default Counter 4 |
No |
No |
0 |
integer |
|
|
user_def_flag_1 |
User Default Flag 1 |
No |
No |
|
string |
10 |
|
user_def_flag_2 |
User Default Flag 2 |
No |
No |
|
string |
10 |
|
user_def_flag_3 |
User Default Flag 3 |
No |
No |
|
string |
10 |
|
user_def_flag_4 |
User Default Flag 4 |
No |
No |
|
string |
10 |
|
priority_1 |
Priority 1 |
No |
No |
0 |
integer |
|
|
priority_2 |
Priority 2 |
No |
No |
0 |
integer |
|
|
priority_3 |
Priority 3 |
No |
No |
0 |
integer |
|
|
priority_4 |
Priority 4 |
No |
No |
0 |
integer |
|
|
due_dt |
Due Date |
No |
No |
|
datetime |
|
|
host_reference |
Host Reference |
No |
No |
|
string |
128 |
|
convey_code |
Conveyor Code |
No |
Yes |
|
string |
10 |
|
commodity_code |
Commodity Code |
No |
Yes |
|
string |
10 |
|
preferred_door_code |
Preferred Door Code |
No |
No |
|
string |
10 |
|
user_def_field1 |
User Defined Field |
No |
No |
|
string |
50 |
|
user_def_field2 |
User Defined Field |
No |
No |
|
string |
50 |
|
yard_template_code |
Yard Template Code |
No |
Yes |
|
string |
10 |
|
yard_shipment_type |
Yard Shipment Type |
No |
Yes |
|
string |
5 |
|
yard_status_id |
Yard Status Id |
No |
Yes |
|
string |
10 |
|
shipment_desc |
Shipment Desc |
No |
No |
|
string |
50 |
|
shipment_desc_2 |
Shipment Desc 2 |
No |
No |
|
string |
50 |
|
shipment_desc_3 |
Shipment Desc 3 |
No |
No |
|
string |
50 |
|
shipment_desc_4 |
Shipment Desc 4 |
No |
No |
|
string |
50 |
|
owner_reference |
Owner Reference |
No |
No |
|
string |
35 |
|
service_code |
Service Code |
No |
No |
|
string |
10 |
|
license_plate_2 |
License Plate 2 |
No |
No |
|
string |
20 |
|
prepare_container_flag |
Prepare Container Flag |
No |
No |
|
bit |
|
|
capture_weight_flag |
Capture Weight Flag |
No |
No |
|
bit |
|
|
weight_threshold |
Weight Threshold |
No |
No |
|
float |
|
|
driver_id |
Driver Id |
No |
No |
|
string |
50 |
|
container_locked_flag |
Container Locked Flag |
No |
No |
|
bit |
|
|
putaway_group_code |
Putaway Group Code |
No |
No |
|
string |
10 |
|
live_flag |
Live Flag |
No |
No |
|
bit |
|
|
capture_temperature_flag |
Capture Temperature Flag |
No |
No |
|
bit |
|
Required equipment type segment
|
Column |
Description |
Required |
Foreign Key |
Default Value |
Data Type |
Length |
|
external_shipment_id |
External Shipment Id |
Yes |
Yes |
|
string |
35 |
|
vehicle_type_code |
Vehicle Type Code |
Yes |
Yes |
|
string |
35 |
Inbound Shipment Interface transaction
Inbound shipment segment
|
Column |
Description |
Required |
Foreign Key |
Default Value |
Data Type |
Length |
|
external_inbound_shipment_id |
Inbound Shipment Id |
Yes |
Yes |
|
string |
35 |
|
external_shipment_id |
Load Number |
Yes |
Yes |
|
string |
35 |
|
owner_code |
Owner Code |
No |
Yes |
|
string |
10 |
|
container_code |
Container Code |
No |
Yes |
|
string |
18 |
|
inbound_shipment_type |
Inbound Shipment Type |
No |
Yes |
|
string |
2 |
|
arrival_processing |
Arrival Processing |
No |
No |
|
string |
5 |
|
inbound_shipment_desc |
Inbound Shipment Description |
No |
No |
|
string |
50 |
|
inbound_shipment_desc_2 |
Inbound Shipment Description 2 |
No |
No |
|
string |
50 |
|
inbound_shipment_desc_3 |
Inbound Shipment Description 3 |
No |
No |
|
string |
50 |
|
inbound_shipment_desc_4 |
Inbound Shipment Description 4 |
No |
No |
|
string |
50 |
|
input_warehouse_code |
Input Warehouse Code |
No |
No |
Warehouse code in single warehouse environment |
string |
10 |
|
input_location_code |
Input Location Code |
No |
Yes |
|
string |
10 |
|
shipping_sequence_handling |
Shipping Sequence |
No |
No |
|
string |
5 |
|
load_simulation_activity_group_code |
Load Simulation Activity Group Code |
No |
No |
|
string |
10 |
|
calculated_volume |
Calculated Volume |
No |
No |
0 |
float |
|
|
calculated_weight |
Calculated Weight |
No |
No |
0 |
float |
|
|
calculated_activity_time |
Calculated Activity Time |
No |
No |
0 |
float |
|
|
planned_sequence |
Planned Sequence |
No |
No |
0 |
integer |
|
|
planned_start_time |
Planned Start Time |
No |
No |
|
datetime |
|
|
planned_end_time |
Planned End Time |
No |
No |
|
datetime |
|
|
estimated_minutes |
Estimated Minutes |
No |
No |
0 |
integer |
|
|
calculated_start_time |
Calculated Start Time |
No |
No |
|
datetime |
|
|
calculated_end_time |
Calculated End Time |
No |
No |
|
datetime |
|
|
confirmed_start_time |
Confirmed Start Time |
No |
No |
|
datetime |
|
|
confirmed_end_time |
Confirmed End Time |
No |
No |
|
datetime |
|
|
effective_start_dt |
Effective Start Date |
No |
No |
|
datetime |
|
|
effective_end_dt |
Effective End Date |
No |
No |
|
datetime |
|
|
effective_minutes |
Effective Minutes |
No |
No |
0 |
integer |
|
|
shipment_planning_type |
Shipment Planning Type |
No |
No |
N |
string |
1 |
|
vehicle_code |
Vehicle Code |
No |
Yes |
|
string |
35 |
|
transport_company_code |
Transport Company Code |
No |
Yes |
|
string |
35 |
|
license_plate |
License Plate |
No |
No |
|
string |
20 |
|
driver_name |
Driver Name |
No |
No |
|
string |
50 |
|
cmr_document |
CMR Document |
No |
No |
|
string |
50 |
|
slot_start_dt |
Slot Start Date |
No |
No |
|
datetime |
|
|
slot_end_dt |
Slot End Date |
No |
No |
|
datetime |
|
|
arrival_time |
Arrival Time |
No |
No |
|
datetime |
|
|
departure_dt |
Departure Date |
No |
No |
|
datetime |
|
|
user_def_counter_1 |
User Default Counter 1 |
No |
No |
0 |
integer |
|
|
user_def_counter_2 |
User Default Counter 2 |
No |
No |
0 |
integer |
|
|
user_def_counter_3 |
User Default Counter 3 |
No |
No |
0 |
integer |
|
|
user_def_counter_4 |
User Default Counter 4 |
No |
No |
0 |
integer |
|
|
user_def_flag_1 |
User Default Flag 1 |
No |
No |
0 |
string |
10 |
|
user_def_flag_2 |
User Default Flag 2 |
No |
No |
0 |
string |
10 |
|
user_def_flag_3 |
User Default Flag 3 |
No |
No |
0 |
string |
10 |
|
user_def_flag_4 |
User Default Flag 4 |
No |
No |
0 |
string |
10 |
|
priority_1 |
Priority 1 |
No |
No |
0 |
integer |
|
|
priority_2 |
Priority 2 |
No |
No |
0 |
integer |
|
|
priority_3 |
Priority 3 |
No |
No |
0 |
integer |
|
|
priority_4 |
Priority 4 |
No |
No |
0 |
integer |
|
|
due_dt |
Due Date |
No |
No |
|
datetime |
|
|
host_reference |
|
No |
No |
|
string |
128 |
|
convey_code |
Conveyor Code |
No |
Yes |
|
string |
10 |
|
commodity_code |
Commodity Code |
No |
Yes |
|
string |
10 |
|
preferred_door_code |
Preferred Door Code |
No |
No |
|
string |
10 |
|
user_def_field1 |
User Defined Field |
No |
No |
|
string |
50 |
|
user_def_field2 |
User Defined Field |
No |
No |
|
string |
50 |
Arrival segment
|
Column |
Description |
Required |
Foreign Key |
Default Value |
Data Type |
Length |
|
owner_code |
Owner Code |
No |
Yes |
|
string |
10 |
|
arrival_type |
Arrival Type |
No |
Yes |
|
string |
2 |
|
arrival_number |
Arrival Number |
No |
No |
|
integer |
|
|
arrival_processing |
Arrival Processing |
No |
No |
ASS |
string |
5 |
|
arrival_desc |
Arrival Description |
No |
No |
|
string |
50 |
|
arrival_desc_2 |
Arrival Description 2 |
No |
No |
|
string |
50 |
|
arrival_desc_3 |
Arrival Description 3 |
No |
No |
|
string |
50 |
|
arrival_desc_4 |
Arrival Description 4 |
No |
No |
|
string |
50 |
|
input_warehouse_code |
Input Warehouse Code |
No |
Yes |
|
string |
10 |
|
input_location_code |
Input Location Code |
No |
Yes |
|
string |
10 |
|
assc_warehouse_code |
Associated Warehouse Code |
No |
Yes |
|
string |
10 |
|
assc_location_code |
Associated Location Code |
No |
Yes |
|
string |
10 |
|
vehicle_code |
Vehicle Code |
No |
Yes |
|
string |
35 |
|
license_plate |
License Plate |
No |
No |
|
string |
20 |
|
driver_name |
Driver Name |
No |
No |
|
string |
50 |
|
owner_reference |
Owner Reference |
No |
No |
|
string |
35 |
|
business_partner_code |
Business Partner Code |
No |
Yes |
|
string |
35 |
|
transport_company_code |
Transport Company |
No |
Yes |
|
string |
35 |
|
terms_of_delivery_code |
Terms of Delivery Code |
No |
No |
|
string |
10 |
|
manner_of_transport_code |
Manner of Transport Code |
No |
No |
|
string |
10 |
|
user_def_counter_1 |
User Default Counter 1 |
No |
No |
0 |
integer |
|
|
user_def_counter_2 |
User Default Counter 2 |
No |
No |
0 |
integer |
|
|
user_def_counter_3 |
User Default Counter 3 |
No |
No |
0 |
integer |
|
|
user_def_counter_4 |
User Default Counter 4 |
No |
No |
0 |
integer |
|
|
user_def_flag_1 |
User Default Flag 1 |
No |
No |
0 |
string |
10 |
|
user_def_flag_2 |
User Default Flag 2 |
No |
No |
0 |
string |
10 |
|
user_def_flag_3 |
User Default Flag 3 |
No |
No |
0 |
string |
10 |
|
user_def_flag_4 |
User Default Flag 4 |
No |
No |
0 |
string |
10 |
|
priority_1 |
Priority 1 |
No |
No |
0 |
integer |
|
|
priority_2 |
Priority 2 |
No |
No |
0 |
integer |
|
|
priority_3 |
Priority 3 |
No |
No |
0 |
integer |
|
|
priority_4 |
Priority 4 |
No |
No |
0 |
integer |
|
|
due_dt |
Due Date |
No |
No |
|
datetime |
|
|
generate_task |
Generate Work Tasks |
No |
No |
0 |
bit |
|
|
expected_time |
Expected Time |
No |
No |
|
datetime |
|
|
host_reference |
Host Reference |
No |
No |
|
string |
128 |
|
yard_template_code |
Yard Template Code |
No |
Yes |
|
string |
10 |
|
yard_shipment_type |
Yard Shipment Type |
No |
Yes |
|
string |
5 |
|
yard_status_id |
Yard Status Id |
No |
Yes |
|
string |
10 |
|
shipment_desc |
Shipment Desc |
No |
No |
|
string |
50 |
|
shipment_desc_2 |
Shipment Desc 2 |
No |
No |
|
string |
50 |
|
shipment_desc_3 |
Shipment Desc 3 |
No |
No |
|
string |
50 |
|
shipment_desc_4 |
Shipment Desc 4 |
No |
No |
|
string |
50 |
|
owner_reference |
Owner Reference |
No |
No |
|
string |
35 |
|
service_code |
Service Code |
No |
No |
|
string |
20 |
|
license_plate_2 |
License Plate 2 |
No |
No |
|
string |
20 |
|
prepare_container_flag |
Prepare Container Flag |
No |
No |
|
bit |
|
|
capture_weight_flag |
Capture Weight Flag |
No |
No |
|
bit |
|
|
weight_threshold |
Weight Threshold |
No |
No |
|
float |
|
|
driver_id |
Driver Id |
No |
No |
|
string |
50 |
|
container_locked_flag |
Container Locked Flag |
No |
No |
|
bit |
|
|
putaway_group_code |
Putaway Group Code |
No |
No |
|
string |
10 |
|
live_flag |
Live Flag |
No |
No |
|
bit |
|
|
capture_temperature_flag |
Capture Temperature Flag |
No |
No |
|
bit |
|
Enterprise transactions
This section provides the detailed inbound transaction layouts for Enterprise systems.
IFIBPART (Inbound Business Partner Interface) transaction
IFIBPART path parameter
|
Parameter |
Description |
Required |
Foreign Key |
Default Value |
Data Type |
Length |
|
wsID |
Web service identification of calling system |
Yes |
No |
String |
20 |
IFIBPART segment
|
Column |
Description |
Required |
Foreign Key |
Default Value |
Data Type |
Length |
|
action |
Transaction type (*ADD, *NEXT, *DELETE, *CHANGE) |
Yes |
No |
String |
10 |
IFIBPART XML elements
|
Column |
Description |
Required |
Foreign Key |
Default Value |
Data Type |
Length |
|
ownerCode |
Owner Code |
Yes |
Yes |
String |
10 |
|
|
businessPartnerCode |
Business Partner Code |
Yes |
No |
String |
35 |
|
|
businessPartnerName |
Business Partner Name |
Yes |
No |
String |
50 |
|
|
internalName |
Internal Name |
No |
No |
String |
35 |
|
|
businessPartnerAlias |
Business Partner Alias |
No |
No |
String |
35 |
|
|
customerType |
Customer Type |
Yes |
No |
Boolean |
||
|
supplierType |
Supplier Type |
Yes |
No |
Boolean |
||
|
languageCode |
Language Code |
Yes |
Yes |
String |
10 |
|
|
backlogAllowed |
Backlog Allowed |
Yes |
No |
Boolean |
||
|
termsOfDeliveryCode |
Terms of Delivery Code |
No |
Yes |
String |
10 |
|
|
mannerOfTransportCode |
Manner of Transport Code |
No |
Yes |
String |
10 |
|
|
termsOfPaymentCode |
Terms of Payment Code |
No |
Yes |
String |
10 |
|
|
cashOnDelivery |
Cash on Delivery |
No |
Yes |
N |
String |
1 |
|
currencyCode |
Currency Code |
No |
Yes |
String |
10 |
|
|
relationGroupCode |
Relation Group Code |
No |
Yes |
String |
10 |
|
|
nameCat1 |
Name Catalog 1 |
No |
No |
String |
20 |
|
|
nameCat2 |
Name Catalog 2 |
No |
No |
String |
20 |
|
|
nameCat3 |
Name Catalog 3 |
No |
No |
String |
20 |
|
|
nameCat4 |
Name Catalog 4 |
No |
No |
String |
20 |
|
|
nameCat5 |
Name Catalog 5 |
No |
No |
String |
20 |
|
|
nameCat6 |
Name Catalog 6 |
No |
No |
String |
20 |
|
|
certificated |
Certificated |
Yes |
Yes |
UN |
String |
2 |
|
inboundLogisticGroupCode |
Inbound Logistics Group Code |
No |
Yes |
String |
10 |
|
|
outboundLogisticGroupCode |
Outbound Logistics Group Code |
No |
Yes |
String |
10 |
|
|
allowProductSubstitution |
Allow Product Substitution |
Yes |
No |
0 |
Boolean |
|
|
checkProductSubstitution |
Check Product Substitution |
Yes |
Yes |
ITSUB |
String |
5 |
|
creationUserCode |
Creation User Code |
No |
Yes |
String |
10 |
|
|
responsibleUserCode |
Responsible User Code |
No |
Yes |
String |
10 |
|
|
businessPartnerActive |
Business Partner Active |
Yes |
No |
Boolean |
||
|
userDefFlag1 |
User Defined Flag |
No |
No |
String |
10 |
|
|
userDefFlag2 |
User Defined Flag |
No |
No |
String |
10 |
|
|
userDefFlag3 |
User Defined Flag |
No |
No |
String |
10 |
|
|
userDefFlag4 |
User Defined Flag |
No |
No |
String |
10 |
|
|
userDefFlag5 |
User Defined Flag |
No |
No |
String |
10 |
|
|
userDefFlag6 |
User Defined Flag |
No |
No |
String |
10 |
|
|
userDefFlag7 |
User Defined Flag |
No |
No |
String |
10 |
|
|
userDefFlag8 |
User Defined Flag |
No |
No |
String |
10 |
|
|
userDefFlag9 |
User Defined Flag |
No |
No |
String |
10 |
|
|
businessPartnerTrusted |
Business Partner Trusted |
Yes |
No |
0 |
Boolean |
IFIBPADR (Inbound Business Partner Address Interface) segment
|
Column |
Description |
Required |
Foreign Key |
Default Value |
Data Type |
Length |
|
action |
Transaction type (*ADD, *NEXT, *DELETE, *CHANGE) |
Yes |
String |
10 |
IFIBPADR XML elements
|
Column |
Description |
Required |
Foreign Key |
Default Value |
Data Type |
Length |
|
owner_code |
Owner Code |
Yes |
Yes |
String |
10 |
|
|
business_partner_code |
Business Partner Code |
Yes |
Yes |
String |
35 |
|
|
address_number |
Address Number |
Yes |
No |
Numeric |
||
|
business_partner_name |
Business Partner Name |
Yes |
No |
String |
50 |
|
|
contact_person |
Contact Person |
No |
No |
String |
50 |
|
|
address_line_1 |
Address Line |
No |
No |
String |
50 |
|
|
address_line_2 |
Address Line |
No |
No |
String |
50 |
|
|
address_line_3 |
Address Line |
No |
No |
String |
50 |
|
|
address_line_4 |
Address Line |
No |
No |
String |
50 |
|
|
postal_code |
Postal Code |
No |
No |
String |
35 |
|
|
country_code |
Country Code |
Yes |
Yes |
String |
10 |
|
|
language_code |
Language Code |
Yes |
Yes |
String |
10 |
|
|
telephone_number |
Telephone Number |
No |
No |
String |
35 |
|
|
fax_number |
Fax Number |
No |
No |
String |
35 |
|
|
email_address |
Email Address |
No |
No |
String |
128 |
|
|
vat_registration_number |
VAT Registration Number |
No |
No |
String |
16 |
|
|
ean_address_code |
EAN Address Code |
No |
No |
String |
14 |
|
|
consol_address_code |
Consol Address Code |
No |
No |
String |
50 |
|
|
layout_type_code |
Layout Type Code |
No |
Yes |
String |
10 |
|
|
temporary_address_flag |
Temporary Address Flag |
No |
No |
Boolean |
IFIITEM (Inbound Item Interface) transaction
IFIITEM path parameter
|
Parameter |
Description |
Required |
Foreign Key |
Default Value |
Data Type |
Length |
|
wsID |
Web service identification of calling system |
Yes |
No |
String |
20 |
IFIITEM segment
|
Column |
Description |
Required |
Foreign Key |
Default Value |
Data Type |
Length |
|
if_action |
Transaction type (*ADD, *NEXT, *DELETE, *CHANGE) |
Yes |
Yes |
String |
10 |
IFIITEM XML elements
|
Column |
Description |
Required |
Foreign Key |
Default Value |
Data Type |
Length |
|
owner_code |
Owner Code |
Yes |
Yes |
String |
10 |
|
|
item_code |
Item Code |
Yes |
No |
String |
35 |
|
|
item_code_alias |
Item Code Alias |
No |
No |
String |
35 |
|
|
item_desc |
Item Description |
Yes |
No |
String |
50 |
|
|
item_desc_extra |
Item Description Continued |
No |
No |
String |
50 |
|
|
item_desc_3 |
Item Description Continued |
No |
No |
String |
50 |
|
|
item_desc_4 |
Item Description Continued |
No |
No |
String |
50 |
|
|
labeled |
Labeled |
No |
Yes |
String |
5 |
|
|
stock_keeping_unit_code |
Stock Keeping Unit |
Yes |
Yes |
String |
10 |
|
|
second_stock_keeping_ |
Second Stock Keep Unit |
No |
Yes |
String |
10 |
|
|
product_location_group_ |
Product Location Group Update Action |
No |
No |
String |
5 |
|
|
product_location_group_ |
Product Location Code |
Yes |
Yes |
String |
10 |
|
|
product_family_code |
Product Family Code |
No |
Yes |
String |
10 |
|
|
item_level_type |
Item Level Type |
Yes |
Yes |
M |
String |
10 |
|
default_warehouse_code |
Default Warehouse Code |
Yes |
Yes |
String |
10 |
|
|
backlog_allowed |
Backlog allowed |
Yes |
No |
0 |
Boolean |
|
|
sku_number_of_decimals |
SKU number of decimals |
No |
No |
0 |
Short |
|
|
abc_code_update_action |
ABC Code Update Action |
No |
No |
String |
5 |
|
|
abc_code |
ABC Code |
No |
Yes |
A |
String |
1 |
|
ean_code |
EAN Code |
No |
No |
String |
14 |
|
|
item_cat_1 |
Item Catalog 1 |
No |
No |
String |
20 |
|
|
item_cat_2 |
Item Catalog 2 |
No |
No |
String |
20 |
|
|
item_cat_3 |
Item Catalog 3 |
No |
No |
String |
20 |
|
|
item_cat_4 |
Item Catalog 4 |
No |
No |
String |
20 |
|
|
item_cat_5 |
Item Catalog 5 |
No |
No |
String |
20 |
|
|
item_cat_6 |
Item Catalog 6 |
No |
No |
String |
20 |
|
|
dimension_unit_code |
Dimension Unit Code |
No |
Yes |
String |
10 |
|
|
length |
Length |
No |
No |
0 |
Big |
|
|
width |
Width |
No |
No |
0 |
Big |
|
|
height |
Height |
No |
No |
0 |
Big |
|
|
volume |
Volume |
No |
No |
0 |
Big |
|
|
weight |
Weight |
No |
No |
0 |
Big |
|
|
tare_weight |
Tare Weight |
No |
No |
0 |
Big |
|
|
standard_unit_value |
Standard Unit Value |
No |
No |
0 |
Big |
|
|
price_group |
Price Group |
No |
No |
String |
35 |
|
|
un_number |
UN Number |
No |
No |
String |
10 |
|
|
adr_class_number |
Address Class Number |
No |
No |
String |
10 |
|
|
validation_expression_1 |
Validation Expression 1 |
No |
No |
String |
128 |
|
|
validation_expression_2 |
Validation Expression 2 |
No |
No |
String |
128 |
|
|
validation_expression_3 |
Validation Expression 3 |
No |
No |
String |
128 |
|
|
validation_expression_4 |
Validation Expression 4 |
No |
No |
String |
128 |
|
|
validation_expression_5 |
Validation Expression 5 |
No |
No |
String |
128 |
|
|
number_of_count_per_ |
Number of Count Per Year |
No |
No |
0 |
Short |
|
|
lot_life_time_in_days |
Lot Life Time in Days |
No |
No |
0 |
Integer |
|
|
inbound_limit_on_expiry_ |
Inbound Limit on Expiration in Days |
No |
No |
0 |
Integer |
|
|
outbound_limit_on_expiry_in_days |
Outbound Limit on Expiration in Days |
No |
No |
0 |
Integer |
|
|
min_purchase_qty |
Minimum Purchase Quantity |
No |
No |
Big |
||
|
min_sales_qty |
Minimum Sales Quantity |
No |
No |
Big |
||
|
repl_point |
Replenishment Point |
No |
No |
0 |
Big |
|
|
min_repl_qty |
Minimum Replenishment Quantity |
No |
No |
0 |
Big |
|
|
max_repl_qty |
Maximum Replenishment Quantity |
No |
No |
0 |
Big |
|
|
product_control_type_ |
Product Control Type Code |
Yes |
Yes |
String |
10 |
|
|
counting_group_code |
Counting Group Code |
No |
Yes |
String |
10 |
|
|
package_nesting_code |
Package Nesting Code |
No |
Yes |
String |
10 |
|
|
package_reuse_code |
Package Reuse Code |
No |
Yes |
String |
10 |
|
|
package_compression_ |
Package Compression Code |
No |
Yes |
String |
10 |
|
|
putaway_group_code |
Putaway Group Code |
No |
Yes |
String |
10 |
|
|
picking_group_code |
Picking Group Code |
No |
Yes |
String |
10 |
|
|
repl_group_code |
Replenishment Group Code |
No |
Yes |
String |
10 |
|
|
inbound_logistic_group_ |
Inbound Logistics Group Code |
No |
Yes |
String |
10 |
|
|
outbound_logistic_group_code |
Outbound Logistics Group Code |
No |
Yes |
String |
10 |
|
|
planning_user_code |
Planning User Code |
No |
Yes |
String |
10 |
|
|
item_active |
Item Active |
Yes |
No |
0 |
Boolean |
|
|
container_type_code |
Container Type Code |
No |
Yes |
String |
10 |
|
|
container_size_code |
Container Size Code |
No |
Yes |
String |
10 |
|
|
handling_unit_code |
Handling Unit Code |
Yes |
Yes |
String |
10 |
|
|
inbound_unit_code |
Inbound Unit Code |
No |
Yes |
String |
10 |
|
|
outbound_unit_code |
Outbound Unit Code |
No |
Yes |
String |
10 |
|
|
qty_per_container_ |
Quantity per Container Expected |
No |
No |
0 |
Big |
|
|
reception_inventory_ |
Reception Inventory Status Code |
No |
Yes |
String |
10 |
|
|
quarantine_days |
Quarantine Days |
No |
No |
0 |
Short |
|
|
quarantine_hours |
Quarantine Hours |
No |
No |
0 |
Short |
|
|
item_type |
Item Type |
No |
Yes |
String |
||
|
availability_check |
Availability Check |
Yes |
Yes |
NOCHK |
String |
5 |
|
rounding_qualifier |
Rounding Qualifier |
No |
Yes |
EXACT |
String |
10 |
|
supplier_business_ |
Supplier Business Partner Code |
No |
Yes |
String |
35 |
|
|
package_type_code |
Package Type Code |
No |
Yes |
String |
10 |
|
|
stacking_class_code |
Stacking Class Code |
No |
Yes |
String |
10 |
|
|
sample_rule |
Sample Rule |
Yes |
Yes |
NONE |
String |
5 |
|
sample_qty |
Sample Quantity |
Yes |
No |
0 |
Big |
|
|
picking_unit_code |
Picking Unit Code |
No |
No |
String |
10 |
|
|
user_def_flag_1 |
User Defined Flag 1 |
No |
No |
String |
10 |
|
|
user_def_flag_2 |
User Defined Flag 2 |
No |
No |
String |
10 |
|
|
user_def_flag_3 |
User Defined Flag 3 |
No |
No |
String |
10 |
|
|
user_def_flag_4 |
User Defined Flag 4 |
No |
No |
String |
10 |
|
|
user_def_flag_5 |
User Defined Flag 5 |
No |
No |
String |
10 |
|
|
user_def_flag_6 |
User Defined Flag 6 |
No |
No |
String |
10 |
|
|
user_def_flag_7 |
User Defined Flag 7 |
No |
No |
String |
10 |
|
|
user_def_flag_8 |
User Defined Flag 8 |
No |
No |
String |
10 |
|
|
user_def_flag_9 |
User Defined Flag 9 |
No |
No |
String |
10 |
|
|
product_code_2 |
Product Code 2 |
No |
No |
String |
20 |
|
|
product_code_3 |
Product Code 3 |
No |
No |
String |
20 |
|
|
product_code_4 |
Product Code 4 |
No |
No |
String |
20 |
|
|
product_code_5 |
Product Code 5 |
No |
No |
String |
20 |
|
|
product_code_6 |
Product Code 6 |
No |
No |
String |
20 |
|
|
product_code_7 |
Product Code 7 |
No |
No |
String |
20 |
|
|
product_code_8 |
Product Code 8 |
No |
No |
String |
20 |
|
|
expiry_dt |
Expiration Date |
No |
No |
String |
14 |
|
|
stock_product_desc |
Stock Product Description |
Yes |
No |
String |
50 |
|
|
ean_addon |
EAN Addon |
No |
No |
String |
5 |
|
|
stock_product_nature |
Stock Product Name |
No |
Yes |
String |
5 |
|
|
product_active |
Product Active |
No |
0 |
Boolean |
||
|
warehouse_code |
Warehouse Code |
No |
Yes |
String |
10 |
|
|
safety_stock_qty |
Safety Stock Quantity |
No |
0 |
Big |
IFIITEMBP (Inbound Item Business Partner Interface) segment
|
Column |
Description |
Required |
Foreign Key |
Default Value |
Data Type |
Length |
|
if_action |
Transaction type (*ADD, *NEXT, *DELETE, *CHANGE) |
Yes |
Yes |
String |
10 |
IFIITEMBP XML elements
|
Column |
Description |
Required |
Foreign Key |
Default Value |
Data Type |
Length |
|
owner_code |
Owner Code |
Yes |
Yes |
String |
10 |
|
|
item_code |
Item Code |
Yes |
Yes |
String |
35 |
|
|
business_partner_ |
Business Patner Owner |
Yes |
Yes |
String |
10 |
|
|
business_partner_code |
Business Partner Code |
Yes |
Yes |
String |
35 |
|
|
item_code_long |
Item Code – Long |
No |
No |
String |
50 |
|
|
item_desc |
Item Description |
No |
No |
String |
50 |
|
|
item_desc_extra |
Item Description Continued |
No |
No |
String |
50 |
|
|
item_desc_3 |
Item Description Continued |
No |
No |
String |
50 |
|
|
item_desc_4 |
Item Description Continued |
No |
No |
String |
50 |
|
|
ean_code |
EAN Code |
No |
No |
String |
14 |
|
|
inbound_logistic_group_code |
Inbound Logistic Group Code |
No |
Yes |
String |
10 |
|
|
outbound_logistic_ |
Outbound Logistic Group Code |
No |
Yes |
String |
10 |
IFIITEMLA (Inbound Item Language Interface) segment
|
Column |
Description |
Required |
Foreign Key |
Default Value |
Data Type |
Length |
|
if_action |
Transaction type (*ADD, *NEXT, *DELETE, *CHANGE) |
Yes |
Yes |
String |
10 |
IFIITEMLA XML elements
|
Column |
Description |
Required |
Foreign Key |
Default Value |
Data Type |
Length |
|
owner_code |
Owner Code |
Yes |
Yes |
String |
10 |
|
|
item_code |
Item Code |
Yes |
Yes |
String |
35 |
|
|
language_code |
Language Code |
Yes |
Yes |
String |
10 |
|
|
item_desc |
Item Description |
No |
No |
String |
50 |
|
|
item_desc_extra |
Item Description Continued |
No |
No |
String |
50 |
|
|
item_desc_3 |
Item Description Continued |
No |
No |
String |
50 |
|
|
item_desc_4 |
Item Description Continued |
No |
No |
String |
50 |
IFIITEMUN (Inbound Item Unit Interface) segment
|
Column |
Description |
Required |
Foreign Key |
Default Value |
Data Type |
Length |
|
if_action |
Transaction type (*ADD, *NEXT, *DELETE, *CHANGE) |
Yes |
Yes |
String |
10 |
IFIITEMUN XML elements
|
Column |
Description |
Required |
Foreign Key |
Default Value |
Data Type |
Length |
|
owner_code |
Owner Code |
Yes |
Yes |
String |
10 |
|
|
item_code |
Item Code |
Yes |
Yes |
String |
35 |
|
|
from_unit_code |
From Unit Code |
Yes |
Yes |
String |
10 |
|
|
to_unit_code |
To Unit Code |
Yes |
Yes |
String |
10 |
|
|
multiplication_factor |
Multiplication Factor |
No |
No |
0 |
BigDecimal |
|
|
container_type_code |
Container Type Code |
No |
Yes |
String |
10 |
|
|
number_of_containers |
Number of Containers |
No |
No |
0 |
Integer |
|
|
allowed_for_storage |
Allow for Storage |
No |
No |
1 |
Boolean |
|
|
allowed_for_inbound_ |
Allow for Inbound Order |
No |
No |
1 |
Boolean |
|
|
allowed_for_receiving |
Allow for Receiving |
No |
No |
1 |
Boolean |
|
|
allowed_for_outbound_order |
Allow for Outbound Order |
No |
No |
1 |
Boolean |
|
|
allowed_for_picking |
Allow for Picking |
No |
No |
1 |
Boolean |
|
|
allowed_on_rf |
Allow on RF |
No |
No |
1 |
Boolean |
|
|
item_unit_active |
Item Unit Active |
No |
No |
1 |
Boolean |
|
|
product_code_2 |
Product Code 2 |
No |
Yes |
String |
20 |
|
|
product_code_3 |
Product Code 3 |
No |
Yes |
String |
20 |
|
|
product_code_4 |
Product Code 4 |
No |
Yes |
String |
20 |
|
|
product_code_5 |
Product Code 5 |
No |
Yes |
String |
20 |
|
|
product_code_6 |
Product Code 6 |
No |
Yes |
String |
20 |
|
|
product_code_7 |
Product Code 7 |
No |
Yes |
String |
20 |
|
|
product_code_8 |
Product Code 8 |
No |
Yes |
String |
20 |
|
|
handling_unit_code |
Handling Unit Code |
No |
Yes |
String |
10 |
|
|
ean_code |
EAN Code |
No |
No |
String |
14 |
|
|
ean_addon |
EAN Addon |
No |
No |
String |
2 |
|
|
abc_code |
ABC Code |
No |
Yes |
String |
1 |
|
|
length |
Length |
No |
No |
0 |
BigDecimal |
|
|
width |
Width |
No |
No |
0 |
BigDecimal |
|
|
height |
Height |
No |
No |
0 |
BigDecimal |
|
|
volume |
Volume |
No |
No |
0 |
BigDecimal |
|
|
weight |
Weight |
No |
No |
0 |
BigDecimal |
|
|
tare_weight |
Tare Weight |
No |
No |
0 |
BigDecimal |
|
|
sku_number_of_ |
SKU Number or Decimals |
No |
No |
0 |
Short |
|
|
inbound_logistic_group_code |
Inbound Logistic Group Code |
No |
Yes |
String |
10 |
|
|
outbound_logistic_ |
Outbound Logistic Group Code |
No |
Yes |
String |
10 |
|
|
product_unit_active |
Product Unit Active |
No |
No |
0 |
Boolean |
IFIITTX (Inbound Item Text Interface) segment
|
Column |
Description |
Required |
Foreign Key |
Default Value |
Data Type |
Length |
|
if_action |
Transaction type (*ADD, *NEXT, *DELETE, *CHANGE) |
Yes |
Yes |
String |
10 |
IFIITTX XML elements
|
Column |
Description |
Required |
Foreign Key |
Default Value |
Data Type |
Length |
|
owner_code |
Owner Code |
Yes |
Yes |
String |
10 |
|
|
item_code |
Item Code |
Yes |
Yes |
String |
35 |
|
|
language_code |
Language Code |
Yes |
Yes |
String |
10 |
|
|
text_number |
Text Number |
Yes |
Yes |
0 |
Integer |
|
|
descriptive_text |
Descriptive Text |
No |
No |
String |
256 |
|
|
text_sort |
Text Sort |
No |
Yes |
GEN |
String |
5 |
|
text_type |
Text Type |
No |
Yes |
T |
String |
|
|
document_1_print_text |
Document 1 Print Text |
No |
No |
0 |
Boolean |
|
|
document_2_print_text |
Document 1 Print Text |
No |
No |
0 |
Boolean |
|
|
document_3_print_text |
Document 3 Print Text |
No |
No |
0 |
Boolean |
|
|
document_4_print_text |
Document 4 Print Text |
No |
No |
0 |
Boolean |
|
|
document_5_print_text |
Document 5 Print Text |
No |
No |
0 |
Boolean |
|
|
document_6_print_text |
Document 6 Print Text |
No |
No |
0 |
Boolean |
|
|
document_7_print_text |
Document 7 Print Text |
No |
No |
0 |
Boolean |
|
|
document_8_print_text |
Document 8 Print Text |
No |
No |
0 |
Boolean |
|
|
document_9_print_text |
Document 9 Print Text |
No |
No |
0 |
Boolean |
IFPURHD (Inbound Purchase [Inbound] Order Interface) transaction
IFPURHD path parameter
|
Parameter |
Description |
Required |
Foreign Key |
Default Value |
Data Type |
Length |
|
wsID |
Web service identification of calling system |
Yes |
No |
String |
20 |
IFPURHD segment
|
Column |
Description |
Required |
Foreign Key |
Default Value |
Data Type |
Length |
|
if_action |
Transaction type (*ADD, *NEXT, *DELETE, *CHANGE) |
Yes |
Yes |
String |
10 |
IFPURD XML elements
|
Column |
Description |
Required |
Foreign Key |
Default Value |
Data Type |
Length |
|
owner_code |
Owner Code |
Yes |
Yes |
String |
10 |
|
|
inbound_order_sort |
Inbound Order Sort |
Yes |
Yes |
String |
3 |
|
|
inbound_order_number |
Inbound Order Number |
Yes |
No |
Long |
||
|
warehouse_code |
Warehouse Code |
No |
Yes |
String |
10 |
|
|
order_type |
Order Type |
No |
No |
String |
5 |
|
|
business_partner_code |
Business Partner Code |
Yes |
Yes |
String |
35 |
|
|
address_number |
Address Number |
Yes |
Yes |
0 |
Integer |
|
|
transport_company_code |
Transport Company |
No |
Yes |
String |
35 |
|
|
order_date |
Order Date |
No |
No |
String |
14 |
|
|
reference_of_origin |
Reference of Origin |
No |
No |
String |
35 |
|
|
reference_of_destination |
Reference of Destination |
No |
No |
String |
35 |
|
|
reference_of_project |
Reference of Project |
No |
No |
String |
35 |
|
|
due_dt |
Due Date |
Yes |
No |
String |
14 |
|
|
order_cat_1 |
Order Catagory 1 |
No |
No |
String |
20 |
|
|
order_cat_2 |
Order Catagory 2 |
No |
No |
String |
20 |
|
|
order_cat_3 |
Order Catagory 3 |
No |
No |
String |
20 |
|
|
order_cat_4 |
Order Catagory 4 |
No |
No |
String |
20 |
|
|
order_cat_5 |
Order Catagory 5 |
No |
No |
String |
20 |
|
|
order_cat_6 |
Order Catagory 6 |
No |
No |
String |
20 |
|
|
terms_of_delivery_code |
Terms of Delivery Code |
No |
Yes |
String |
10 |
|
|
manner_of_transport_code |
Manner of Transport Code |
No |
Yes |
String |
10 |
|
|
terms_of_payment_code |
Terms of Payment Code |
No |
Yes |
String |
10 |
|
|
currency_code |
Currency Code |
No |
Yes |
String |
10 |
|
|
creation_user_code |
Creation User Code |
No |
Yes |
String |
10 |
|
|
responsible_user_code |
Responsible User Code |
No |
Yes |
String |
10 |
|
|
input_location_code |
Input Location Code |
No |
Yes |
String |
10 |
|
|
generate_task |
Generate Task |
No |
No |
Boolean |
||
|
host_reference |
Host Reference |
No |
No |
String |
128 |
|
|
inbound_order_status |
Inbound Order Status |
Yes |
Yes |
Short |
IFIBPADR segment
|
Column |
Description |
Required |
Foreign Key |
Default Value |
Data Type |
Length |
|
action |
Transaction type (*ADD, *NEXT, *DELETE, *CHANGE) |
Yes |
String |
10 |
IFIBPADR XML elements
|
Column |
Description |
Required |
Foreign Key |
Default Value |
Data Type |
Length |
|
owner_code |
Owner Code |
Yes |
Yes |
String |
10 |
|
|
business_partner_code |
Business Partner Code |
Yes |
Yes |
String |
35 |
|
|
address_number |
Address Number |
Yes |
No |
Numeric |
||
|
business_partner_name |
Business Partner Name |
Yes |
No |
String |
50 |
|
|
contact_person |
Contact Person |
No |
No |
String |
50 |
|
|
address_line_1 |
Address Line |
No |
No |
String |
50 |
|
|
address_line_2 |
Address Line |
No |
No |
String |
50 |
|
|
address_line_3 |
Address Line |
No |
No |
String |
50 |
|
|
address_line_4 |
Address Line |
No |
No |
String |
50 |
|
|
postal_code |
Postal Code |
No |
No |
String |
35 |
|
|
country_code |
Country Code |
Yes |
Yes |
String |
10 |
|
|
language_code |
Language Code |
Yes |
Yes |
String |
10 |
|
|
telephone_number |
Telephone Number |
No |
No |
String |
35 |
|
|
fax_number |
Fax Number |
No |
No |
String |
35 |
|
|
email_address |
Email Address |
No |
No |
String |
128 |
|
|
vat_registration_number |
VAT Registration Number |
No |
No |
String |
16 |
|
|
ean_address_code |
EAN Address Code |
No |
No |
String |
14 |
|
|
consol_address_code |
Consol Address Code |
No |
No |
String |
50 |
|
|
layout_type_code |
Layout Type Code |
No |
Yes |
String |
10 |
|
|
temporary_address_flag |
Temporary Address Flag |
No |
No |
Boolean |
IFPURDT (Inbound Purchase [Inbound] Order Detail Interface) segment
|
Column |
Description |
Required |
Foreign Key |
Default Value |
Data Type |
Length |
|
action |
Transaction type (*ADD, *NEXT, *DELETE, *CHANGE) |
Yes |
Yes |
String |
10 |
IFPURDT XML Element
|
Column |
Description |
Required |
Foreign Key |
Default Value |
Data Type |
Length |
|
owner_code |
Owner Code |
Yes |
Yes |
String |
10 |
|
|
inbound_order_sort |
Inbound Order Sort |
Yes |
Yes |
String |
2 |
|
|
inbound_order_number |
Inbound Order Number |
Yes |
Yes |
BigDecimal |
||
|
inbound_order_line_number |
Inbound Order Line Number |
Yes |
Yes |
BigDecimal |
||
|
inbound_order_status |
Inbound Order Status |
Yes |
Yes |
Short |
||
|
business_partner_code |
Business Partner Code |
Yes |
Yes |
String |
35 |
|
|
address_number |
Address Number |
Yes |
Yes |
Integer |
||
|
reference_of_origin |
Reference of Origin |
No |
No |
String |
35 |
|
|
reference_of_destination |
Reference of Destination |
No |
No |
String |
35 |
|
|
reference_of_project |
Reference of Project |
No |
No |
String |
35 |
|
|
transport_company_code |
Transport Company Code |
No |
Yes |
String |
35 |
|
|
warehouse_code |
Warehouse Code |
Yes |
Yes |
String |
10 |
|
|
stock_product_owner |
Stock Product Code |
Yes |
Yes |
String |
10 |
|
|
item_code |
Item Code |
Yes |
Yes |
String |
35 |
|
|
product_code_2 |
Product Code 2 |
No |
No |
String |
20 |
|
|
product_code_3 |
Product Code 3 |
No |
No |
String |
20 |
|
|
product_code_4 |
Product Code 4 |
No |
No |
String |
20 |
|
|
product_code_5 |
Product Code 5 |
No |
No |
String |
20 |
|
|
product_code_6 |
Product Code 6 |
No |
No |
String |
20 |
|
|
product_code_7 |
Product Code 7 |
No |
No |
String |
20 |
|
|
product_code_8 |
Product Code 8 |
No |
No |
String |
20 |
|
|
handling_unit_code |
Handling Unit Code |
Yes |
Yes |
String |
10 |
|
|
item_desc |
Item Description |
Yes |
No |
String |
5 |
|
|
original_product_owner |
Original Product Owner |
Yes |
Yes |
String |
10 |
|
|
original_item_code |
Original Item Code |
Yes |
Yes |
String |
35 |
|
|
original_product_code_2 |
Original Product Code 2 |
No |
No |
String |
20 |
|
|
original_product_code_3 |
Original Product Code 3 |
No |
No |
String |
20 |
|
|
original_product_code_4 |
Original Product Code 4 |
No |
No |
String |
20 |
|
|
original_product_code_5 |
Original Product Code 5 |
No |
No |
String |
20 |
|
|
original_product_code_6 |
Original Product Code 6 |
No |
No |
String |
20 |
|
|
original_product_code_7 |
Original Product Code 7 |
No |
No |
String |
20 |
|
|
original_product_code_8 |
Original Product Code 8 |
No |
No |
String |
20 |
|
|
backlog_allowed |
Backlog Allowed |
Yes |
No |
Boolean |
||
|
stock_product_nature |
Stock Product Nature |
Yes |
No |
String |
5 |
|
|
ordered_qty |
Ordered Quantity |
No |
No |
0 |
BigDecimal |
|
|
unit_code |
Unit Code |
Yes |
Yes |
String |
10 |
|
|
due_dt |
Due Date |
Yes |
No |
String |
14 |
|
|
latest_end_dt |
Latest End Date |
No |
No |
0 |
String |
14 |
|
order_cat_1 |
Order Catalog 1 |
No |
No |
String |
20 |
|
|
order_cat_2 |
Order Catalog 2 |
No |
No |
String |
20 |
|
|
order_cat_3 |
Order Catalog 3 |
No |
No |
String |
20 |
|
|
order_cat_4 |
Order Catalog 4 |
No |
No |
String |
20 |
|
|
order_cat_5 |
Order Catalog 5 |
No |
No |
String |
20 |
|
|
order_cat_6 |
Order Catalog 6 |
No |
No |
String |
20 |
|
|
inbound_unit_price |
Inbound Unit Price |
No |
No |
0 |
BigDecimal |
|
|
line_amount |
Line Amount |
No |
No |
0 |
BigDecimal |
|
|
price_unit_code |
Price Unit Code |
No |
Yes |
String |
10 |
|
|
inbound_limit_on_expiry_in_ |
Inbound Limit on Expiration in Days |
No |
No |
0 |
Integer |
|
|
product_expiry_time |
Product Expiration Time |
No |
No |
String |
14 |
|
|
receiving_instruction |
Receiving Instructions |
No |
No |
String |
50 |
|
|
generate_task |
Generate Task |
No |
No |
0 |
Boolean |
|
|
reception_inventory_status_ |
Reception Inventory Status Code |
No |
Yes |
String |
10 |
|
|
sample_rule |
Sample Rule |
No |
Yes |
NONE |
String |
5 |
|
sample_qty |
Sample Quantity |
No |
No |
0 |
BigDecimal |
|
|
host_reference |
Host Reference |
No |
No |
String |
128 |
|
|
close_order |
Close Order |
No |
Yes |
EXACT |
String |
5 |
|
lower_margin_perc |
Lower Margin Percentage |
No |
No |
0 |
BigDecimal |
|
|
upper_margin_perc |
Upper Margin Percentage |
No |
No |
0 |
BigDecimal |
|
|
lower_margin_qty |
Lower Margin Quantity |
No |
No |
0 |
BigDecimal |
|
|
upper_margin_qty |
Upper Margin Quantity |
No |
No |
0 |
BigDecimal |
|
|
line_in_backorder |
Line in Backorder |
Yes |
No |
Boolean |
||
|
inbound_logistic_group_ |
Inbound Logistic Group Code |
No |
Yes |
String |
||
|
workload_class_code |
Workload Class Code |
No |
Yes |
String |
10 |
|
|
workload_factor |
Workload Factor |
No |
No |
0 |
BigDecimal |
10 |
|
if_processing |
Interface Processing |
No |
No |
1 |
Boolean |
|
|
generate_stock_product |
Generate Stock Product |
No |
No |
0 |
Boolean |
|
|
expiry_dt |
Expiration Date |
No |
No |
String |
14 |
|
|
stock_product_desc |
Stock Product Description |
Yes |
No |
String |
50 |
|
|
product_location_group_ |
Product Location Group Update Action |
No |
String |
5 |
||
|
product_location_group_ |
Product Location Group Code |
Yes |
Yes |
String |
10 |
|
|
product_family_code |
Product Family Code |
No |
Yes |
String |
10 |
|
|
abc_code_update_action |
ABC Code Update Action |
No |
String |
5 |
||
|
abc_code |
ABC Code |
No |
Yes |
A |
String |
1 |
|
ean_code |
EAN Code |
No |
No |
String |
14 |
|
|
ean_addon |
EAN Addon |
No |
No |
String |
5 |
|
|
picking_unit_code |
Picking Unit Code |
No |
Yes |
String |
10 |
|
|
dimension_unit_code |
Dimension Unit Code |
No |
Yes |
String |
10 |
|
|
length |
Length |
No |
No |
0 |
BigDecimal |
|
|
width |
Width |
No |
No |
0 |
BigDecimal |
|
|
height |
Height |
No |
No |
0 |
BigDecimal |
|
|
volume |
Volume |
No |
No |
0 |
BigDecimal |
|
|
weight |
Weight |
No |
No |
0 |
BigDecimal |
|
|
tare_weight |
Tare Weight |
No |
No |
0 |
BigDecimal |
|
|
standard_unit_value |
Standard Unit Value |
No |
No |
0 |
BigDecimal |
|
|
outbound_limit_on_expiry_in_days |
Outbound Limit on Expiration in Days |
No |
No |
0 |
Integer |
|
|
putaway_group_code |
Putaway Group Code |
No |
Yes |
String |
10 |
|
|
picking_group_code |
Picking Group Code |
No |
Yes |
String |
10 |
|
|
repl_group_code |
Replenishment Group Code |
No |
Yes |
String |
10 |
|
|
product_active |
Product Active |
No |
0 |
Boolean |
||
|
counting_group_code |
Counting Group Code |
No |
String |
10 |
||
|
repl_point |
Replenishment Point |
No |
0 |
BigDecimal |
||
|
min_repl_qty |
Minimum Replenishment Quantity |
No |
0 |
BigDecimal |
||
|
max_repl_qty |
Maximum Replenishment Quantity |
No |
0 |
BigDecimal |
||
|
safety_stock_qty |
Safety Stock Quantity |
No |
0 |
BigDecimal |
IFIIBOTX Inbound Purchase [Inbound] Order Text Interface) segment
|
Column |
Description |
Required |
Foreign Key |
Default Value |
Data Type |
Length |
|
action |
Transaction type (*ADD, *NEXT, *DELETE, *CHANGE) |
Yes |
Yes |
String |
10 |
IFIIBOTX XML elements
|
Column |
Description |
Required |
Foreign Key |
Default Value |
Data Type |
Length |
|
owner_code |
Owner Code |
Yes |
Yes |
String |
10 |
|
|
inbound_order_sort |
Inbound Order Sort |
Yes |
Yes |
String |
2 |
|
|
inbound_order_number |
Inbound Order Number |
No |
Yes |
0 |
BigDecimal |
|
|
inbound_order_line_ |
Inbound Order Line Number |
No |
Yes |
0 |
BigDecimal |
|
|
language_code |
Language Code |
Yes |
Yes |
String |
10 |
|
|
text_number |
Text Number |
No |
No |
0 |
Integer |
|
|
text_type |
Text Type |
No |
Yes |
T |
String |
5 |
|
long_text |
Long Text |
No |
No |
String |
256 |
|
|
document_1_print_text |
Document 1 Print Text |
No |
No |
0 |
Boolean |
|
|
document_2_print_text |
Document 2 Print Text |
No |
No |
0 |
Boolean |
|
|
document_3_print_text |
Document 3 Print Text |
No |
No |
0 |
Boolean |
|
|
document_4_print_text |
Document 4 Print Text |
No |
No |
0 |
Boolean |
|
|
document_5_print_text |
Document 5 Print Text |
No |
No |
0 |
Boolean |
|
|
document_6_print_text |
Document 6 Print Text |
No |
No |
0 |
Boolean |
|
|
document_7_print_text |
Document 7 Print Text |
No |
No |
0 |
Boolean |
|
|
document_8_print_text |
Document 8 Print Text |
No |
No |
0 |
Boolean |
|
|
document_9_print_text |
Document 9 Print Text |
No |
No |
0 |
Boolean |
IFSALHD (Inbound Sales [Outbound] Order Interface) transaction
IFSALHD path parameter
|
Parameter |
Description |
Required |
Foreign Key |
Default Value |
Data Type |
Length |
|
wsID |
Web service identification of calling system |
Yes |
No |
String |
20 |
IFSALHD segment
|
Column |
Description |
Required |
Foreign Key |
Default Value |
Data Type |
Length |
|
if_action |
Transaction type (*ADD, *NEXT, *DELETE, *CHANGE) |
Yes |
Yes |
String |
10 |
IFSALHD XML elements
|
Column |
Description |
Required |
Foreign Key |
Default Value |
Data Type |
Length |
|
owner_code |
Owner Code |
Yes |
Yes |
String |
10 |
|
|
outbound_order_sort |
Outbound Order Sort |
Yes |
Yes |
String |
2 |
|
|
outbound_order_number |
Outbound Order Number |
No |
No |
0 |
BigDecimal |
|
|
warehouse_code |
Warehouse Code |
No |
Yes |
String |
10 |
|
|
order_type |
Order Type |
No |
No |
String |
5 |
|
|
business_partner_code |
Business Partner Code |
Yes |
Yes |
String |
35 |
|
|
address_number |
Address Number |
Yes |
Yes |
0 |
Integer |
|
|
invoice_business_partner_ |
Invoice Business Partner Code |
No |
Yes |
String |
35 |
|
|
transport_company_code |
Transport Company Code |
No |
Yes |
String |
35 |
|
|
order_reference |
Order Reference |
No |
No |
String |
35 |
|
|
reference_of_origin |
Reference of Origin |
No |
No |
String |
35 |
|
|
reference_of_destination |
Reference of Destination |
No |
No |
String |
35 |
|
|
reference_of_project |
Reference of Project |
No |
No |
String |
35 |
|
|
order_date |
Order Date |
No |
No |
String |
14 |
|
|
wave_template_code |
Wave Template Code |
No |
Yes |
String |
10 |
|
|
picklist_template_code |
Picklist Template Code |
No |
Yes |
String |
10 |
|
|
outbound_template_code |
Outbound Template Code |
No |
Yes |
String |
10 |
|
|
replen_template_code |
Replenishment Template Code |
No |
Yes |
String |
10 |
|
|
route_code |
Route Code |
No |
No |
String |
50 |
|
|
order_picking |
Order Picking |
No |
Yes |
C |
String |
1 |
|
dispatch_code |
Dispatch Code |
No |
Yes |
Short |
||
|
due_dt |
Due Date |
No |
No |
String |
14 |
|
|
requested_dt |
Requested Date |
No |
No |
String |
14 |
|
|
order_cat_1 |
Order Catalog 1 |
No |
No |
String |
20 |
|
|
order_cat_2 |
Order Catalog 2 |
No |
No |
String |
20 |
|
|
order_cat_3 |
Order Catalog 3 |
No |
No |
String |
20 |
|
|
order_cat_4 |
Order Catalog 4 |
No |
No |
String |
20 |
|
|
order_cat_5 |
Order Catalog 5 |
No |
No |
String |
20 |
|
|
order_cat_6 |
Order Catalog 6 |
No |
No |
String |
20 |
|
|
dock_relation_code |
Dock Relation Code |
No |
Yes |
String |
10 |
|
|
terms_of_delivery_code |
Terms of Delivery Code |
No |
Yes |
String |
10 |
|
|
manner_of_transport_code |
Manner of Transport Code |
No |
Yes |
String |
10 |
|
|
terms_of_payment_code |
Terms of Payment Code |
No |
Yes |
String |
10 |
|
|
currency_code |
Currency Code |
No |
Yes |
String |
10 |
|
|
cash_on_delivery |
Cash On Delivery |
No |
Yes |
N |
String |
1 |
|
host_reference |
Host Reference |
No |
No |
String |
128 |
|
|
creation_user_code |
Creation User Code |
No |
Yes |
String |
10 |
|
|
responsible_user_code |
Responsible user code |
No |
Yes |
String |
10 |
|
|
outbound_order_status |
Outbound Order Status |
Yes |
Yes |
Short |
IFIBPADR segment
|
Column |
Description |
Required |
Foreign Key |
Default Value |
Data Type |
Length |
|
action |
Transaction type (*ADD, *NEXT, *DELETE, *CHANGE) |
Yes |
String |
10 |
IFIBPADR XML elements
|
Column |
Description |
Required |
Foreign Key |
Default Value |
Data Type |
Length |
|
owner_code |
Owner Code |
Yes |
Yes |
String |
10 |
|
|
business_partner_code |
Business Partner Code |
Yes |
Yes |
String |
35 |
|
|
address_number |
Address Number |
Yes |
No |
Numeric |
||
|
business_partner_name |
Business Partner Name |
Yes |
No |
String |
50 |
|
|
contact_person |
Contact Person |
No |
No |
String |
50 |
|
|
address_line_1 |
Address Line |
No |
No |
String |
50 |
|
|
address_line_2 |
Address Line |
No |
No |
String |
50 |
|
|
address_line_3 |
Address Line |
No |
No |
String |
50 |
|
|
address_line_4 |
Address Line |
No |
No |
String |
50 |
|
|
postal_code |
Postal Code |
No |
No |
String |
35 |
|
|
country_code |
Country Code |
Yes |
Yes |
String |
10 |
|
|
language_code |
Language Code |
Yes |
Yes |
String |
10 |
|
|
telephone_number |
Telephone Number |
No |
No |
String |
35 |
|
|
fax_number |
Fax Number |
No |
No |
String |
35 |
|
|
email_address |
Email Address |
No |
No |
String |
128 |
|
|
vat_registration_number |
VAT Registration Number |
No |
No |
String |
16 |
|
|
ean_address_code |
EAN Address Code |
No |
No |
String |
14 |
|
|
consol_address_code |
Consol Address Code |
No |
No |
String |
50 |
|
|
layout_type_code |
Layout Type Code |
No |
Yes |
String |
10 |
|
|
temporary_address_flag |
Temporary Address Flag |
No |
No |
Boolean |
IFSALDT (Inbound Sales [Outbound] Order Detail Interface) segment
|
Column |
Description |
Required |
Foreign Key |
Default Value |
Data Type |
Length |
|
if_action |
Transaction type (*ADD, *NEXT, *DELETE, *CHANGE) |
Yes |
Yes |
String |
10 |
IFSALDT XML elements
|
Column |
Description |
Required |
Foreign Key |
Default Value |
Data Type |
Length |
|
owner_code |
Owner Code |
Yes |
Yes |
String |
10 |
|
|
outbound_order_sort |
Outbound Order Sort |
Yes |
Yes |
String |
2 |
|
|
outbound_order_number |
Outbound Order Number |
Yes |
Yes |
0 |
BigDecimal |
|
|
outbound_order_line_number |
Outbound Order Line Number |
No |
No |
0 |
BigDecimal |
|
|
outbound_order_status |
Outbound Order Status |
Yes |
Yes |
Short |
||
|
business_partner_code |
Business Partner Code |
Yes |
Yes |
String |
35 |
|
|
address_number |
Address Number |
Yes |
Yes |
0 |
Integer |
|
|
order_reference |
Order Reference |
No |
No |
String |
35 |
|
|
reference_of_origin |
Reference of Origin |
No |
No |
String |
35 |
|
|
reference_of_destination |
Reference of Destination |
No |
No |
String |
35 |
|
|
reference_of_project |
Reference of Project |
No |
No |
String |
35 |
|
|
warehouse_code |
Warehouse Code |
Yes |
Yes |
String |
10 |
|
|
stock_product_owner |
Stock Product Owner |
Yes |
Yes |
String |
10 |
|
|
item_code |
Item Code |
Yes |
Yes |
String |
35 |
|
|
product_code_2 |
Product Code 2 |
No |
No |
String |
20 |
|
|
product_code_3 |
Product Code 3 |
No |
No |
String |
20 |
|
|
product_code_4 |
Product Code 4 |
No |
No |
String |
20 |
|
|
product_code_5 |
Product Code 5 |
No |
No |
String |
20 |
|
|
product_code_6 |
Product Code 6 |
No |
No |
String |
20 |
|
|
product_code_7 |
Product Code 7 |
No |
No |
String |
20 |
|
|
product_code_8 |
Product Code 8 |
No |
No |
String |
20 |
|
|
handling_unit_code |
Handling Unit Code |
Yes |
Yes |
String |
10 |
|
|
item_desc |
Item Description |
No |
No |
String |
50 |
|
|
stock_product_nature |
Stock Product Nature |
Yes |
Yes |
String |
5 |
|
|
original_product_owner |
Original Product Owner |
Yes |
Yes |
String |
10 |
|
|
original_item_code |
Original Item Code |
Yes |
Yes |
String |
35 |
|
|
original_product_code_2 |
Original Product Code 2 |
No |
No |
String |
20 |
|
|
original_product_code_3 |
Original Product Code 3 |
No |
No |
String |
20 |
|
|
original_product_code_4 |
Original Product Code 4 |
No |
No |
String |
20 |
|
|
original_product_code_5 |
Original Product Code 5 |
No |
No |
String |
20 |
|
|
original_product_code_6 |
Original Product Code 6 |
No |
No |
String |
20 |
|
|
original_product_code_7 |
Original Product Code 7 |
No |
No |
String |
20 |
|
|
original_product_code_8 |
Original Product Code 8 |
No |
No |
String |
20 |
|
|
backlog_allowed |
Backlog Allowed |
No |
No |
0 |
Boolean |
|
|
backlog_on_host |
Backlog on Host |
No |
No |
0 |
Boolean |
|
|
order_picking |
Order Picking |
Yes |
Yes |
C |
String |
1 |
|
ordered_qty |
Ordered Quantity |
No |
No |
0 |
BigDecimal |
|
|
requested_qty |
Requested Quantity |
No |
No |
0 |
BigDecimal |
|
|
backorder_qty |
Backorder Quantity |
No |
No |
0 |
BigDecimal |
|
|
unit_code |
Unit Code |
Yes |
No |
String |
10 |
|
|
rounding_qualifier |
Rounding Qualifier |
No |
No |
EXACT |
String |
10 |
|
due_date_type |
Due Date Type |
No |
No |
O |
String |
1 |
|
due_dt |
Due Date |
Yes |
No |
String |
14 |
|
|
latest_end_dt |
Latest End Date |
No |
No |
String |
14 |
|
|
requested_dt |
Requested Date |
Yes |
No |
String |
14 |
|
|
transport_company_code |
Temporary Company Code |
No |
Yes |
String |
35 |
|
|
terms_of_delivery_code |
Terms of Delivery Code |
No |
Yes |
String |
10 |
|
|
manner_of_transport_code |
Manner of Transport Code |
No |
Yes |
String |
10 |
|
|
package_type_code |
Package Type Code |
Yes |
Yes |
String |
10 |
|
|
route_code |
Route Code |
No |
No |
String |
50 |
|
|
sequence_in_route |
Sequence in Route |
No |
No |
0 |
BigInteger |
|
|
reservation_priority |
Reservation Priority |
No |
No |
0 |
Integer |
|
|
priority_increment |
Priority Increment |
No |
No |
0 |
Short |
|
|
pick_sequence |
Pick Sequence |
No |
No |
0 |
BigInteger |
|
|
sequential_number |
Sequential Number |
No |
No |
BigInteger |
||
|
capacity_parameter_1 |
Capacity Parameter 1 |
No |
No |
0 |
BigDecimal |
|
|
capacity_parameter_2 |
Capacity Parameter 2 |
No |
No |
0 |
BigDecimal |
|
|
capacity_parameter_3 |
Capacity Parameter 3 |
No |
No |
0 |
BigDecimal |
|
|
order_cat_1 |
Order Catalog 1 |
No |
No |
String |
20 |
|
|
order_cat_2 |
Order Catalog 2 |
No |
No |
String |
20 |
|
|
order_cat_3 |
Order Catalog 3 |
No |
No |
String |
20 |
|
|
order_cat_4 |
Order Catalog 4 |
No |
No |
String |
20 |
|
|
order_cat_5 |
Order Catalog 5 |
No |
No |
String |
20 |
|
|
order_cat_6 |
Order Catalog 6 |
No |
No |
String |
20 |
|
|
outbound_unit_price |
Outbound Unit Price |
No |
No |
0 |
BigDecimal |
|
|
line_amount |
Line Amount |
No |
No |
0 |
BigDecimal |
|
|
price_unit_code |
Price Unit Code |
No |
Yes |
String |
10 |
|
|
outbound_limit_on_expiry_in_ |
Outbound Limit on Expiration in Days |
No |
No |
0 |
Integer |
|
|
product_expiry_time |
Product Expiration Time |
No |
No |
String |
14 |
|
|
picking_instruction |
Picking Instruction |
No |
No |
String |
50 |
|
|
packing_instruction |
Packing Instruction |
No |
No |
String |
50 |
|
|
shipping_instruction |
Shipping Instruction |
No |
No |
String |
50 |
|
|
reservation_inventory_status_ |
Reservation Inventory Status Code |
No |
Yes |
String |
10 |
|
|
dock_relation_code |
Dock Relation Code |
No |
Yes |
String |
10 |
|
|
wave_template_code |
Wave Template Code |
No |
Yes |
String |
10 |
|
|
picklist_template_code |
Picklist Template Code |
No |
Yes |
String |
10 |
|
|
outbound_template_code |
Outbound Template Code |
No |
Yes |
String |
10 |
|
|
replen_template_code |
Replenishment Template Code |
No |
Yes |
String |
10 |
|
|
picking_group_code |
Picking Group Code |
No |
Yes |
String |
10 |
|
|
host_reference |
Host Reference |
No |
No |
String |
128 |
|
|
line_in_backorder |
Line in Backorder |
No |
No |
0 |
Boolean |
|
|
original_line_number |
Original Line Number |
No |
No |
BigInteger |
||
|
reference_line_number |
Reference Line Number |
No |
No |
BigInteger |
||
|
outbound_logistic_group_ |
Outbound Logistic Group Code |
No |
Yes |
String |
10 |
|
|
workload_class_code |
Workload Class Code |
No |
Yes |
String |
10 |
|
|
workload_factor |
Workload Factor |
No |
No |
0 |
BigDecimal |
|
|
if_processing |
Interface Processing |
No |
No |
1 |
Boolean |
|
|
generate_stock_product |
Generate Stock Product |
No |
No |
0 |
Boolean |
|
|
expiry_dt |
Expiration Date |
No |
No |
String |
14 |
|
|
stock_product_desc |
Stock Product Description |
Yes |
No |
String |
50 |
|
|
product_location_group_ |
Product Location Group Update Action |
No |
String |
5 |
||
|
product_location_group_code |
Product Location Group Code |
Yes |
Yes |
String |
10 |
|
|
product_family_code |
Product Family Code |
No |
Yes |
String |
10 |
|
|
abc_code_update_action |
ABC Code Update Action |
No |
String |
5 |
||
|
abc_code |
ABC Code |
No |
Yes |
A |
String |
1 |
|
ean_code |
EAN Code |
No |
No |
String |
14 |
|
|
ean_addon |
EAN Addon |
No |
No |
String |
5 |
|
|
picking_unit_code |
Picking Unit Code |
No |
Yes |
String |
10 |
|
|
dimension_unit_code |
Dimension Unit Code |
No |
Yes |
String |
10 |
|
|
length |
Length |
No |
No |
0 |
BigDecimal |
|
|
width |
Width |
No |
No |
0 |
BigDecimal |
|
|
height |
Height |
No |
No |
0 |
BigDecimal |
|
|
volume |
Volume |
No |
No |
0 |
BigDecimal |
|
|
weight |
Weight |
No |
No |
0 |
BigDecimal |
|
|
tare_weight |
Tare Weight |
No |
No |
0 |
BigDecimal |
|
|
standard_unit_value |
Standard Unit Value |
No |
No |
0 |
BigDecimal |
|
|
inbound_limit_on_expiry_in_ |
Inbound Limit on Expiration in Days |
No |
No |
0 |
Integer |
|
|
putaway_group_code |
Putaway Group Code |
No |
Yes |
String |
10 |
|
|
repl_group_code |
Replenishment Group Code |
No |
Yes |
String |
10 |
|
|
product_active |
Product Active |
No |
0 |
Boolean |
||
|
counting_group_code |
Counting Group Code |
No |
String |
10 |
||
|
repl_point |
Replenishment Point |
No |
0 |
BigDecimal |
||
|
min_repl_qty |
Minimum Replenishment Quantity |
No |
0 |
BigDecimal |
||
|
max_repl_qty |
Maximum Replenishment Quantity |
No |
0 |
BigDecimal |
||
|
safety_stock_qty |
Safety Stock Quantity |
No |
0 |
BigDecimal |
IFIOBOTX (Inbound Sales [Outbound] Order Text Interface) segment
|
Column |
Description |
Required |
Foreign Key |
Default Value |
Data Type |
Length |
|
action |
Transaction type (*ADD, *NEXT, *DELETE, *CHANGE) |
Yes |
Yes |
String |
10 |
IFIOBOTX XML Element
|
Column |
Description |
Required |
Foreign Key |
Default Value |
Data Type |
Length |
|
owner_code |
Owner Code |
Yes |
Yes |
String |
10 |
|
|
outbound_order_sort |
Outbound Order Sort |
Yes |
Yes |
String |
2 |
|
|
outbound_order_number |
Outbound Order Number |
No |
Yes |
0 |
BigDecimal |
|
|
outbound_order_line_number |
Outbound Order Line Number |
No |
Yes |
0 |
BigDecimal |
|
|
language_code |
Language Code |
Yes |
Yes |
String |
10 |
|
|
text_number |
Text Number |
No |
No |
0 |
Integer |
|
|
text_type |
Text Type |
No |
Yes |
T |
String |
5 |
|
long_text |
Long Text |
No |
No |
String |
256 |
|
|
document_1_print_text |
Document 1 Print Text |
No |
No |
0 |
Boolean |
|
|
document_2_print_text |
Document 2 Print Text |
No |
No |
0 |
Boolean |
|
|
document_3_print_text |
Document 3 Print Text |
No |
No |
0 |
Boolean |
|
|
document_4_print_text |
Document 4 Print Text |
No |
No |
0 |
Boolean |
|
|
document_5_print_text |
Document 5 Print Text |
No |
No |
0 |
Boolean |
|
|
document_6_print_text |
Document 6 Print Text |
No |
No |
0 |
Boolean |
|
|
document_7_print_text |
Document 7 Print Text |
No |
No |
0 |
Boolean |
|
|
document_8_print_text |
Document 8 Print Text |
No |
No |
0 |
Boolean |
|
|
document_9_print_text |
Document 9 Print Text |
No |
No |
0 |
Boolean |
Lucas Systems voice transactions
This section provides the detailed inbound transaction layouts for Lucas Systems™ voice-directed solutions.
Voice Task Complete Interface transaction
Voice task complete segment
|
Column |
Description |
Required |
Foreign Key |
Default Value |
Data Type |
Length |
|
AssignmentNumber |
Pick List Number |
Y |
N |
|
integer |
|
|
RecordId |
Task Number |
Y |
Y |
|
string |
20 |
|
Order |
Outbound Order Number |
Y |
N |
|
integer |
|
|
ToContainerId |
To Container Code |
Y |
Y |
|
string |
20 |
|
EmployeeId |
User Code |
Y |
Y |
|
string |
30 |
|
PickDateTime |
Date Task Completed |
Y |
N |
|
datetime |
|
|
ItemNumber |
Item Number and Owner Code |
Y |
Y |
|
string |
45 |
|
QuantityPicked |
Picked Quantity |
Y |
N |
|
float |
|
|
QuantityShorted |
Shorted Quantity |
Y |
N |
|
float |
|
|
ExpirationDate |
Expiration Date |
N |
N |
|
datetime |
|
Outbound transactions
This chapter describes the transactions that Iptor WM1 sends to host and Enterprise systems.
Host transactions
This section provides the detailed outbound transaction layouts for host systems.
Trailer Move transaction
Trailer move segment
|
Column |
Description |
Required |
Data Type |
Length |
|
container_code |
Container Code |
Yes |
string |
10 |
|
owner_code |
Owner Code |
No |
string |
10 |
|
transport_company_code |
Transport Company Code |
No |
string |
35 |
|
container_type_code |
Container Type Code |
Yes |
string |
10 |
|
from_location_code |
From Location Code |
Yes |
string |
10 |
|
from_warehouse_code |
From Warehouse Code |
Yes |
string |
10 |
|
to_location_code |
To Location Code |
Yes |
string |
10 |
|
to_warehouse_code |
To Warehouse Code |
Yes |
string |
10 |
|
check_in_flag |
Check-in Flag |
Yes |
bit |
|
|
departure_flag |
Departure Flag |
Yes |
bit |
|
|
door_location_flag |
Door Location Flag |
Yes |
bit |
|
|
empty |
Empty Flag |
Yes |
bit |
|
|
full_container |
Full Container Flag |
Yes |
bit |
|
|
trans_user_code |
Transaction User Code |
Yes |
string |
10 |
|
trans_time |
Transaction Time |
Yes |
datetime |
|
|
external_shipment_id |
External Id for Shipment |
No |
string |
35 |
|
external_inbound_shipment_id |
External Id for Inbound Shipment |
No |
string |
35 |
|
external_outbound_shipment_id |
External Id for Outbound Shipment |
No |
string |
35 |
|
container_date_1 |
Date 1 |
No |
datetime |
|
|
container_date_2 |
Date 2 |
No |
datetime |
|
|
container_date_3 |
Date 3 |
No |
datetime |
|
|
container_date_4 |
Date 4 |
No |
datetime |
|
|
container_date_5 |
Date 5 |
No |
datetime |
|
|
container_user_def_flag_1 |
User Defined Field 1 |
No |
string |
10 |
|
container_user_def_flag_2 |
User Defined Field 2 |
No |
string |
10 |
|
container_user_def_flag_3 |
User Defined Field 3 |
No |
string |
10 |
|
container_user_def_flag_4 |
User Defined Field 4 |
No |
string |
10 |
|
container_user_def_flag_5 |
User Defined Field 5 |
No |
string |
10 |
|
container_user_def_flag_6 |
User Defined Field 6 |
No |
string |
10 |
|
container_user_def_flag_7 |
User Defined Field 7 |
No |
string |
10 |
|
container_user_def_flag_8 |
User Defined Field 8 |
No |
string |
10 |
|
container_user_def_flag_9 |
User Defined Field 9 |
No |
string |
10 |
|
container_reference_1 |
Reference Field 1 |
No |
string |
10 |
|
container_reference_2 |
Reference Field 2 |
No |
string |
35 |
|
container_reference_3 |
Reference Field 3 |
No |
string |
35 |
|
container_reference_4 |
Reference Field 4 |
No |
string |
35 |
|
container_reference_5 |
Reference Field 5 |
No |
string |
35 |
|
damage_flag |
Damage Flag |
No |
bit |
|
|
damage_code |
Damage Code |
No |
string |
10 |
|
lost_flag |
Lost Flag |
No |
bit |
|
|
container_wash_flag |
Wash Flag |
No |
bit |
|
|
shipment_user_def_counter_1 |
User Default Counter 1 |
No |
integer |
|
|
shipment_user_def_counter_2 |
User Default Counter 2 |
No |
integer |
|
|
shipment_user_def_counter_3 |
User Default Counter 3 |
No |
integer |
|
|
shipment_user_def_counter_4 |
User Default Counter 4 |
No |
integer |
|
|
shipment_user_def_flag_1 |
User Default Flag 1 |
No |
string |
10 |
|
shipment_user_def_flag_2 |
User Default Flag 2 |
No |
string |
10 |
|
shipment_user_def_flag_3 |
User Default Flag 3 |
No |
string |
10 |
|
shipment_user_def_flag_4 |
User Default Flag 4 |
No |
string |
10 |
|
shipment_priority_1 |
Priority 1 |
No |
integer |
|
|
shipment_priority_2 |
Priority 2 |
No |
integer |
|
|
shipment_priority_3 |
Priority 3 |
No |
integer |
|
|
shipment_priority_4 |
Priority 4 |
No |
integer |
|
|
commodity_code |
Commodity Code |
No |
string |
10 |
Trailer Audit Discrepancy transaction
Trailer audit discrepancy segment
|
Column |
Description |
Required |
Data Type |
Length |
|
container_code |
Container Code |
Yes |
string |
10 |
|
container_type_code |
Container Type Code |
Yes |
string |
10 |
|
location_code |
Location Code |
Yes |
string |
10 |
|
trans_user_code |
Transaction User Code |
Yes |
string |
10 |
|
trans_time |
Transaction Time |
Yes |
datetime |
|
|
counting_template_code |
Counting Template |
Yes |
string |
10 |
|
transport_company_code |
Transport Company Code |
No |
string |
35 |
|
container_size_code |
Expected Container Size Code |
Yes |
string |
10 |
|
container_level_type |
Expected Container Level Type |
Yes |
string |
10 |
|
stacking_class_code |
Expected Stacking Class Code |
No |
string |
18 |
|
container_code_alias |
Expected Container Code Alias |
No |
string |
18 |
|
pincode |
Expected Pincode |
No |
string |
10 |
|
container_usage |
Expected Container Usage |
No |
string |
5 |
|
task_abc_code |
Expected Task ABC Code |
No |
string |
1 |
|
container_active |
Expected Container Active |
No |
bit |
|
|
date_1 |
Expected Date 1 |
No |
datetime |
|
|
date_2 |
Expected Date 2 |
No |
datetime |
|
|
date_3 |
Expected Date 3 |
No |
datetime |
|
|
date_4 |
Expected Date 4 |
No |
datetime |
|
|
date_5 |
Expected Date 5 |
No |
datetime |
|
|
user_def_flag_1 |
Expected User Defined Field 1 |
No |
string |
10 |
|
user_def_flag_2 |
Expected User Defined Field 2 |
No |
string |
10 |
|
user_def_flag_3 |
Expected User Defined Field 3 |
No |
string |
10 |
|
user_def_flag_4 |
Expected User Defined Field 4 |
No |
string |
10 |
|
user_def_flag_5 |
Expected User Defined Field 5 |
No |
string |
10 |
|
user_def_flag_6 |
Expected User Defined Field 6 |
No |
string |
10 |
|
user_def_flag_7 |
Expected User Defined Field 7 |
No |
string |
10 |
|
user_def_flag_8 |
Expected User Defined Field 8 |
No |
string |
10 |
|
user_def_flag_9 |
Expected User Defined Field 9 |
No |
string |
10 |
|
reference_1 |
Expected Reference Field 1 |
No |
string |
35 |
|
reference_2 |
Expected Reference Field 2 |
No |
string |
35 |
|
reference_3 |
Expected Reference Field 3 |
No |
string |
35 |
|
reference_4 |
Expected Reference Field 4 |
No |
string |
35 |
|
reference_5 |
Expected Reference Field 5 |
No |
string |
35 |
|
length |
Expected Length |
No |
float |
|
|
width |
Expected Width |
No |
float |
|
|
height |
Expected Height |
No |
float |
|
|
gross_volume |
Expected Gross Volume |
No |
float |
|
|
net_volume |
Expected Net Volume |
No |
float |
|
|
net_weight |
Expected Net Weight |
No |
float |
|
|
tare_weight |
Expected Tare Weight |
No |
float |
|
|
damage_flag |
Expected Damage Flag |
No |
bit |
|
|
damage_code |
Expected Damage Code |
No |
string |
10 |
|
lost_flag |
Expected Lost Flag |
No |
bit |
|
|
container_wash_flag |
Expected Wash Flag |
No |
bit |
|
|
entered_transport_company_code |
Entered Transport Company Code |
No |
string |
35 |
|
entered_container_size_code |
Entered Container Size Code |
No |
string |
10 |
|
entered_container_level_type |
Entered Container Level Type |
No |
string |
10 |
|
entered_stacking_class_code |
Entered Stacking Class Code |
No |
string |
18 |
|
entered_container_code_alias |
Entered Container Code Alias |
No |
string |
18 |
|
entered_pincode |
Entered Pincode |
No |
string |
10 |
|
entered_container_usage |
Entered Container Usage |
No |
string |
5 |
|
entered_task_abc_code |
Entered Task ABC Code |
No |
string |
1 |
|
entered_container_active |
Entered Container Active |
No |
bit |
|
|
entered_date_1 |
Entered Date 1 |
No |
datetime |
|
|
entered_date_2 |
Entered Date 2 |
No |
datetime |
|
|
entered_date_3 |
Entered Date 3 |
No |
datetime |
|
|
entered_date_4 |
Entered Date 4 |
No |
datetime |
|
|
entered_date_5 |
Entered Date 5 |
No |
datetime |
|
|
entered_user_def_flag_1 |
Entered User Defined Field 1 |
No |
string |
10 |
|
entered_user_def_flag_2 |
Entered User Defined Field 2 |
No |
string |
10 |
|
entered_user_def_flag_3 |
Entered User Defined Field 3 |
No |
string |
10 |
|
entered_user_def_flag_4 |
Entered User Defined Field 4 |
No |
string |
10 |
|
entered_user_def_flag_5 |
Entered User Defined Field 5 |
No |
string |
10 |
|
entered_user_def_flag_6 |
Entered User Defined Field 6 |
No |
string |
10 |
|
entered_user_def_flag_7 |
Entered User Defined Field 7 |
No |
string |
10 |
|
entered_user_def_flag_8 |
Entered User Defined Field 8 |
No |
string |
10 |
|
entered_user_def_flag_9 |
Entered User Defined Field 9 |
No |
string |
10 |
|
entered_reference_1 |
Entered Reference Field 1 |
No |
string |
35 |
|
entered_reference_2 |
Entered Reference Field 2 |
No |
string |
35 |
|
entered_reference_3 |
Entered Reference Field 3 |
No |
string |
35 |
|
entered_reference_4 |
Entered Reference Field 4 |
No |
string |
35 |
|
entered_reference_5 |
Entered Reference Field 5 |
No |
string |
35 |
|
entered_length |
Entered Length |
No |
float |
|
|
entered_width |
Entered Width |
No |
float |
|
|
entered_height |
Entered Height |
No |
float |
|
|
entered_gross_volume |
Entered Gross Volume |
No |
float |
|
|
entered_net_volume |
Entered Net Volume |
No |
float |
|
|
entered_net_weight |
Entered Net Weight |
No |
float |
|
|
entered_tare_weight |
Entered Tare Weight |
No |
float |
|
|
entered_damage_flag |
Entered Damage Flag |
No |
bit |
|
|
entered_damage_code |
Entered Damage Code |
No |
string |
10 |
|
entered_lost_flag |
Entered Lost Flag |
No |
bit |
|
|
entered_container_wash_flag |
Entered Wash Flag |
No |
bit |
|
Enterprise transactions
This section provides the detailed outbound transaction layouts for Enterprise systems.
WMS Code Checking transaction
Create or update (*NEXT)
Create or update WMS Code Checking records used in validation of WMS Business Partner WMS Item information.
|
Parameter |
Description |
Required |
Length |
Iptor WM1 |
|
wsid |
Web service identification, identifies the caller |
Yes |
10 |
|
|
transactionevent |
Transaction event |
Yes |
10 |
case IFOCDCHK.CODACT=0 then ‘*NEXT’ else IFOCDCHK.INTACT |
|
codetable |
Code table |
Yes |
256 |
IFOCDCHK.CODTAB |
|
codevalue |
Code value |
Yes |
20 |
IFOCDCHK.CODVAL |
|
codedescription |
Code description |
Yes |
50 |
IFOCDCHK.CODDES |
|
messageid |
Message id, callers identification of the transaction |
No |
15/0 |
IFOCDCHK.MSGNBR |
Delete (*DELETE)
Delete WMS Code Checking records used in validation of WMS Business Partner and WMS Item information.
|
Parameter |
Description |
Required |
Length |
Iptor WM1 |
|
wsid |
Web service identification, identifies the caller |
Yes |
10 |
|
|
transactionevent |
Transaction event |
Yes |
10 |
case IFOCDCHK.CODACT=0 then ‘*DELETE’ else IFOCDCHK.INTACT |
|
codetable |
Code table |
Yes |
256 |
IFOCDCHK.CODTAB |
|
codevalue |
Code value |
Yes |
20 |
IFOCDCHK.CODVAL |
|
codedescription |
Code description |
Yes |
50 |
IFOCDCHK.CODDES |
|
messageid |
Message id, callers identification of the transaction |
No |
15/0 |
IFOCDCHK.MSGNBR |
WMS Reception transaction
Line start (*LINESTART)
Set the status on the purchase order line to 30 (ready for reception).
|
Parameter |
Description |
Required |
Length |
Iptor WM1 |
|
wsid |
Web service identification, identifies the caller |
Yes |
10 |
|
|
transactionevent |
Transaction event |
Yes |
10 |
*LINESTART |
|
ordernumber |
Order number |
Yes |
12/0 |
IFOIRS.PURHDN |
|
orderlinenumber |
Order line number |
Yes |
5/0 |
IFOIRS.PURDTN |
|
messageid |
Message id, callers identification of the transaction |
No |
15/0 |
IFOIRS.MSGNBR |
Streaming (*STREAMING)
Reception occurs pallet by pallet for the purchase order line.
|
Parameter |
Description |
Required |
Length |
Iptor WM1 |
|
wsid |
Web service identification, identifies the caller |
Yes |
10 |
|
|
transactionevent |
Transaction event |
Yes |
10 |
*STREAMING |
|
ordernumber |
Order number |
Yes |
12/0 |
IFOIRD.PURHDN |
|
orderlinenumber |
Order line number |
Yes |
5/0 |
IFOIRD.PURDTN |
|
actualquantity |
Actual quantity |
Yes |
15/3 |
IFOIRD.RECQTY |
|
actualbatch |
Actual batch |
No |
13 |
IFOIRD.PRCOD7 |
|
usebydate |
Use by date |
No |
8/0 |
IFOIRD.EXPIDT (extract from timestamp) |
|
serialnumber |
Serial number |
No |
20 |
IFOIRD.PRCOD8 |
|
transportnoteno |
Transport note number from supplier |
No |
35 |
|
|
supplierdispatchdate |
Supplier dispatch date |
No |
8/0 |
|
|
messageid |
Message id, callers identification of the transaction |
No |
15/0 |
IFOIRD.MSGNBR |
Line close (*LINECLOSE)
Close the purchase order line. If partial reception has been made and backlog flag on order in Enterprise is Yes, create a backlog line with the remaining quantity.
|
Parameter |
Description |
Required |
Length |
Iptor WM1 |
|
wsid |
Web service identification, identifies the caller |
Yes |
10 |
|
|
transactionevent |
Transaction event |
Yes |
10 |
*LINECLOSE |
|
ordernumber |
Order number |
Yes |
12/0 |
IFOIRS.PURHDN |
|
orderlinenumber |
Order line number |
Yes |
5/0 |
IFOIRS.PURDTN |
|
messageid |
Message id, callers identification of the transaction |
No |
15/0 |
IFOIRS.MSGNBR |
Supplier return with negative quantity (*STREAMING)
Handle the supplier return as a reception with a negative quantity in Enterprise, meaning that Outbound result in Iptor WM1 for a supplier return is to WMS Reception.
|
Parameter |
Description |
Required |
Length |
Iptor WM1 |
|
wsid |
Web service identification, identifies the caller |
Yes |
10 |
|
|
transactionevent |
Transaction event |
Yes |
10 |
*STREAMING |
|
ordernumber |
Order number |
Yes |
12/0 |
IFOORD.SALHDN |
|
orderlinenumber |
Order line number |
Yes |
5/0 |
IFOORD.SALLNN |
|
actualquantity |
Actual quantity |
Yes |
15/3 |
IFOORD.SHPQTY |
|
actualbatch |
Actual batch |
No |
13 |
IFOORD.PRCOD7 |
|
usebydate |
Use by date |
No |
8/0 |
IFOORD.EXPIDT (extract from timestamp) |
|
serialnumber |
Serial number |
No |
20 |
IFOORD.PRCOD8 |
|
messageid |
Message id, callers identification of the transaction |
No |
15/0 |
IFOORD.MSGNBR |
Supplier return with zero picking (*LINECLOSE)
Handle the supplier return with zero picking (cancel and close).
|
Parameter |
Description |
Required |
Length |
Iptor WM1 |
|
wsid |
Web service identification, identifies the caller |
Yes |
10 |
|
|
transactionevent |
Transaction event |
Yes |
10 |
*LINECLOSE |
|
ordernumber |
Order number |
Yes |
12/0 |
IFOORS.SALHDN |
|
orderlinenumber |
Order line number |
Yes |
5/0 |
IFOORS.SALLNN |
|
messageid |
Message id, callers identification of the transaction |
No |
15/0 |
IFOORS.MSGNBR |
WMS Picking transaction
Line pick (*LINEPICK)
Hold the picked (shipped) quantity and completion flag (status) for the sales order line. If line close and partial delivery and backlog flag in Enterprise is Yes, create a backlog line with the remaining quantity.
|
Parameter |
Description |
Required |
Length |
Iptor WM1 |
|
wsid |
Web service identification, identifies the caller |
Yes |
10 |
|
|
transactionevent |
Transaction event |
Yes |
10 |
*LINEPICK |
|
ordernumber |
Order number |
Yes |
12/0 |
IFOORD.SALHDN |
|
orderlinenumber |
Order line number |
Yes |
5/0 |
IFOORD.SALLLN |
|
linestatus |
Order line status |
Yes |
2/0 |
IFOORD.SALLST |
|
quantitypicked |
Quantity picked |
Yes |
15/3 |
IFOORD.PICQTY |
|
quantityshipped |
Quantity shipped |
Yes |
15/3 |
IFOORD.SHPQTY |
|
actualbatch |
Actual batch |
No |
13 |
IFOORD.PRCOD7 |
|
serialnumber |
Serial number |
No |
20 |
IFOORD.PRCOD8 |
|
transportnotenumber |
Transport note number |
No |
12/0 |
IFOORD.SHIPNR |
|
messageid |
Message id, callers identification of the transaction |
No |
15/0 |
IFOORD.MSGNBR |
Line pick with zero picking (*LINEPICK)
Line pick with zero picking.
|
Parameter |
Description |
Required |
Length |
Iptor WM1 |
|
wsid |
Web service identification, identifies the caller |
Yes |
10 |
|
|
transactionevent |
Transaction event |
Yes |
10 |
*LINEPICK |
|
ordernumber |
Order number |
Yes |
12/0 |
IFOORS.SALHDN |
|
orderlinenumber |
Order line number |
Yes |
5/0 |
IFOORS.SALLLN |
|
linestatus |
Order line status |
Yes |
2/0 |
IFOORS.SALLST |
|
quantitypicked |
Quantity picked |
Yes |
15/3 |
*zero |
|
quantityshipped |
Quantity shipped |
Yes |
15/3 |
*zero |
|
actualbatch |
Actual batch |
No |
13 |
IFOORS.PRCOD7 |
|
serialnumber |
Serial number |
No |
20 |
IFOORS.PRCOD8 |
|
transportnotenumber |
Transport note number |
No |
12/0 |
*zero |
|
messageid |
Message id, callers identification of the transaction |
No |
15/0 |
IFOORS.MSGNBR |
Line pick with negative quantity (*LINEPICK)
Handle customer return as a picking with a negative quantity in Enterprise, meaning that Inbound result in Iptor WM1 for a customer return is mapped to WMS Picking.
|
Parameter |
Description |
Required |
Length |
Iptor WM1 |
|
wsid |
Web service identification, identifies the caller |
Yes |
10 |
|
|
transactionevent |
Transaction event |
Yes |
10 |
*LINEPICK |
|
ordernumber |
Order number |
Yes |
12/0 |
IFOIRD.PURHDN |
|
orderlinenumber |
Order line number |
Yes |
5/0 |
IFOIRD.PURDTN |
|
linestatus |
Order line status |
Yes |
2/0 |
IFOIRD.PURDST |
|
quantitypicked |
Quantity picked |
Yes |
15/3 |
IFOIRD.RECQTY |
|
quantityshipped |
Quantity shipped |
Yes |
15/3 |
IFOIRD.RECQTY |
|
actualbatch |
Actual batch |
No |
13 |
IFOIRD.PRCOD7 |
|
serialnumber |
Serial number |
No |
20 |
IFOIRD.PRCOD8 |
|
transportnotenumber |
Transport note number |
No |
12/0 |
*zero |
|
messageid |
Message id, callers identification of the transaction |
No |
15/0 |
IFOIRD.MSGNBR |
Line pick with zero reception (*LINEPICK)
Customer return with zero reception (cancel and close).
|
Parameter |
Description |
Required |
Length |
Iptor WM1 |
|
wsid |
Web service identification, identifies the caller |
Yes |
10 |
|
|
transactionevent |
Transaction event |
Yes |
10 |
*LINEPICK |
|
ordernumber |
Order number |
Yes |
12/0 |
IFOIRS.PURHDN |
|
orderlinenumber |
Order line number |
Yes |
5/0 |
IFOIRS.PURDTN |
|
linestatus |
Order line status |
Yes |
2/0 |
IFOIRS.PURDST |
|
quantitypicked |
Quantity picked |
Yes |
15/3 |
*zero |
|
quantityshipped |
Quantity shipped |
Yes |
15/3 |
*zero |
|
actualbatch |
Actual batch |
No |
13 |
IFOIRS.PRCOD7 |
|
serialnumber |
Serial number |
No |
20 |
IFOIRS.PRCOD8 |
|
transportnotenumber |
Transport note number |
No |
12/0 |
*zero |
|
messageid |
Message id, callers identification of the transaction |
No |
15/0 |
IFOIRS.MSGNBR |
WMS Inventory transaction
Change existing item inventory (*ADJUST)
Increase or decrease item inventory quantities.
|
Parameter |
Description |
Required |
Length |
Iptor WM1 |
|
wsid |
Web service identification, identifies the caller |
Yes |
10 |
|
|
transactionevent |
Transaction event |
Yes |
10 |
*ADJUST |
|
item |
Item code |
Yes |
35 |
IFOINVAD.ITMCOD |
|
warehouse |
Warehouse code |
Yes |
3 |
IFOINVAD.WHSCOD |
|
transactiontype |
Transaction type |
No |
5/0 |
IFOINVAD.INTRTP |
|
inventorystatus |
Inventory status |
No |
10 |
|
|
quantity |
Quantity in stock unit |
Yes |
15/3 |
IFOINVAD.QTYAFT – IFOINVAD.QTYBEF |
|
batch |
Batch |
No |
13 |
IFOINVAD.PRCOD7 |
|
serialnumber |
Serial number |
No |
20 |
IFOINVAD.PRCOD8 |
|
transactiondescription |
Transaction description |
No |
30 |
IFOINVAD.INTRTX |
|
orderreferencenumber |
Order reference number |
No |
12/0 |
IFOINVAD.PRCOD6 (1-12) |
|
orderreferencelinenumber |
Order reference line number |
No |
5/0 |
IFOINVAD.PRCOD6 (13-17) |
|
usebydate |
Use by date |
No |
8/0 |
IFOINVAD.EXPIDT |
|
container |
Container |
No |
20 |
IFOINVAD.CONCOD |
|
nccnumber |
NCC number |
No |
12/0 |
|
|
signature |
Signature (NCC) |
No |
10 |
|
|
messageid |
Message id, callers identification of the transaction |
No |
15/0 |
IFOINVAD.MSGNBR |
Create item inventory (*ADJUST)
Create new item inventory.
|
Parameter |
Description |
Required |
Length |
Iptor WM1 |
|
wsid |
Web service identification, identifies the caller |
Yes |
10 |
|
|
transactionevent |
Transaction event |
Yes |
10 |
*ADJUST |
|
item |
Item code |
Yes |
35 |
case IFOINVAD.TOITEM <> *blanks then TOITEM else ITMCOD |
|
warehouse |
Warehouse code |
Yes |
3 |
case IFOINVAD.TOWHS <> *blank then TOWHS else WHSCOD |
|
transactiontype |
Transaction type |
No |
5/0 |
IFOINVAD.INTRTP |
|
inventorystatus |
Inventory status |
No |
10 |
|
|
quantity |
Quantity in stock unit |
Yes |
15/3 |
case IFOINVAD.TQTYBE = *zero and IFOINVAD.TQTYAF = *zero |
|
batch |
Batch |
No |
13 |
IFOINVAD.PRCOD7 |
|
serialnumber |
Serial number |
No |
20 |
IFOINVAD.PRCOD8 |
|
transactiondescription |
Transaction description |
No |
30 |
IFOINVAD.INTRTX |
|
orderreferencenumber |
Order reference number |
No |
12/0 |
IFOINVAD.PRCOD6 (1-12) |
|
orderreferencelinenumber |
Order reference line number |
No |
5/0 |
IFOINVAD.PRCOD6 (13-17) |
|
usebydate |
Use by date |
No |
8/0 |
IFOINVAD.EXPIDT (extract from timestamp) |
|
container |
Container |
No |
20 |
IFOINVAD.CONCOD |
|
nccnumber |
NCC number |
No |
12/0 |
|
|
signature |
Signature (NCC) |
No |
10 |
|
|
messageid |
Message id, callers identification of the transaction |
No |
15/0 |
IFOINVAD.MSGNBR |
Remove item inventory (*ADJUST)
Remove item inventory.
|
Parameter |
Description |
Required |
Length |
Iptor WM1 |
|
wsid |
Web service identification, identifies the caller |
Yes |
10 |
|
|
transactionevent |
Transaction event |
Yes |
10 |
*ADJUST |
|
item |
Item code |
Yes |
35 |
IFOINVAD.ITMCOD |
|
warehouse |
Warehouse code |
Yes |
3 |
IFOINVAD.WHSCOD |
|
transactiontype |
Transaction type |
No |
5/0 |
IFOINVAD.INTRTP |
|
inventorystatus |
Inventory status |
No |
10 |
|
|
quantity |
Quantity in stock unit |
Yes |
15/3 |
IFOINVAD.QTYAFT – IFOINVAD.QTYBEF |
|
batch |
Batch |
No |
13 |
IFOINVAD.PRCOD7 |
|
serialnumber |
Serial number |
No |
20 |
IFOINVAD.PRCOD8 |
|
transactiondescription |
Transaction description |
No |
30 |
IFOINVAD.INTRTX |
|
orderreferencenumber |
Order reference number |
No |
12/0 |
IFOINVAD.PRCOD6 (1-12) |
|
orderreferencelinenumber |
Order reference line number |
No |
5/0 |
IFOINVAD.PRCOD6 (13-17) |
|
usebydate |
Use by date |
No |
8/0 |
IFOINVAD.EXPIDT (extract from timestamp) |
|
container |
Container |
No |
20 |
IFOINVAD.CONCOD |
|
nccnumber |
NCC number |
No |
12/0 |
|
|
signature |
Signature (NCC) |
No |
10 |
|
|
messageid |
Message id, callers identification of the transaction |
No |
15/0 |
IFOINVAD.MSGNBR |
Add inventory status (*ADDSTS)
Add inventory status for normal stock (increase quantity for the quantity type that corresponds to the inventory stats).
|
Parameter |
Description |
Required |
Length |
Iptor WM1 |
|
wsid |
Web service identification, identifies the caller |
Yes |
10 |
|
|
transactionevent |
Transaction event |
Yes |
10 |
*ADDSTS |
|
item |
Item code |
Yes |
35 |
IFOINVAD.ITMCOD |
|
warehouse |
Warehouse code |
Yes |
3 |
IFOINVAD.WHSCOD |
|
transactiontype |
Transaction type |
No |
5/0 |
IFOINVAD.INTRTP |
|
inventorystatus |
Inventory status |
Yes |
10 |
IFOINVAD.TINSTA |
|
quantity |
Quantity in stock unit |
Yes |
15/3 |
IFOINVAD.TQTYAF |
|
batch |
Batch |
No |
13 |
IFOINVAD.PRCOD7 |
|
serialnumber |
Serial number |
No |
20 |
IFOINVAD.PRCOD8 |
|
transactiondescription |
Transaction description |
No |
30 |
IFOINVAD.INTRTX |
|
orderreferencenumber |
Order reference number |
No |
12/0 |
IFOINVAD.PRCOD6 (1-12) |
|
orderreferencelinenumber |
Order reference line number |
No |
5/0 |
IFOINVAD.PRCOD6 (13-17) |
|
usebydate |
Use by date |
No |
8/0 |
IFOINVAD.EXPIDT |
|
container |
Container |
No |
20 |
IFOINVAD.CONCOD |
|
messageid |
Message id, callers identification of the transaction |
No |
15/0 |
IFOINVAD.MSGNBR |
Remove inventory status (*RMVSTS)
Remove inventory status for normal stock (decrease quantity for the quantity type that corresponds to the inventory status).
|
Parameter |
Description |
Required |
Length |
Iptor WM1 |
|
wsid |
Web service identification, identifies the caller |
Yes |
10 |
|
|
transactionevent |
Transaction event |
Yes |
10 |
*RMVSTS |
|
item |
Item code |
Yes |
35 |
IFOINVAD.ITMCOD |
|
warehouse |
Warehouse code |
Yes |
3 |
IFOINVAD.WHSCOD |
|
transactiontype |
Transaction type |
No |
5/0 |
IFOINVAD.INTRTP |
|
inventorystatus |
Inventory status |
Yes |
10 |
IFOINVAD.TINSTB |
|
quantity |
Quantity in stock unit |
Yes |
15/3 |
*zero – IFOINVAD.TQTYAF |
|
batch |
Batch |
No |
13 |
IFOINVAD.PRCOD7 |
|
serialnumber |
Serial number |
No |
20 |
IFOINVAD.PRCOD8 |
|
transactiondescription |
Transaction description |
No |
30 |
IFOINVAD.INTRTX |
|
orderreferencenumber |
Order reference number |
No |
12/0 |
IFOINVAD.PRCOD6 (1-12) |
|
orderreferencelinenumber |
Order reference line number |
No |
5/0 |
IFOINVAD.PRCOD6 (13-17) |
|
usebydate |
Use by date |
No |
8/0 |
IFOINVAD.EXPIDT |
|
container |
Container |
No |
20 |
IFOINVAD.CONCOD |
|
messageid |
Message id, callers identification of the transaction |
No |
15/0 |
IFOINVAD.MSGNBR |
Move normal to non-conform (*NORMTONCC)
Move from a normal stock category to a non-conform stock category.
|
Parameter |
Description |
Required |
Length |
Iptor WM1 |
|
wsid |
Web service identification, identifies the caller |
Yes |
10 |
|
|
transactionevent |
Transaction event |
Yes |
10 |
*NORMTONCC |
|
item |
Item code |
Yes |
35 |
IFOINVAD.ITMCOD |
|
warehouse |
Warehouse code |
Yes |
3 |
IFOINVAD.WHSCOD |
|
inventorystatus |
Inventory status |
Yes |
10 |
IFOINVAD.TINSTA |
|
quantity |
Quantity in stock unit |
Yes |
15/3 |
IFOINVAD.TQTYAF |
|
batch |
Batch |
No |
13 |
IFOINVAD.PRCOD7 |
|
serialnumber |
Serial number |
No |
20 |
IFOINVAD.PRCOD8 |
|
transactiondescription |
Transaction description |
No |
30 |
case IFOINVAD.INTRTX = *blank then ‘Iptor WM1’ else IFOINVAD.INTRTX |
|
reasoncode |
Reason code |
No |
3 |
|
|
orderreferencenumber |
Order reference number |
No |
12/0 |
IFOINVAD.PRCOD6 (1-12) |
|
orderreferencelinenumber |
Order reference line number |
No |
5/0 |
IFOINVAD.PRCOD6 (13-17) |
|
towarehouse |
To Warehouse |
No |
3 |
IFOINVAD.WHSCOD |
|
stockcategory |
Stock category |
Yes |
3 |
IFOINVAD.TINSTA |
|
signature |
Signature |
Yes |
10 |
IFOINVAD.REQUSR |
|
container |
Container |
No |
20 |
IFOINVAD.CONCOD |
|
nccnumber |
NCC number |
No |
12/0 |
|
|
messageid |
Message id, callers identification of the transaction |
No |
15/0 |
IFOINVAD.MSGNBR |
Move non-conform to normal (*NCCTONORM)
Move from a non-conform stock category to a normal stock category.
|
Parameter |
Description |
Required |
Length |
Iptor WM1 |
|
wsid |
Web service identification, identifies the caller |
Yes |
10 |
|
|
transactionevent |
Transaction event |
Yes |
10 |
*NCCTONORM |
|
item |
Item code |
Yes |
35 |
IFOINVAD.ITMCOD |
|
warehouse |
Warehouse code |
Yes |
3 |
IFOINVAD.WHSCOD |
|
quantity |
Quantity in stock unit |
Yes |
15/3 |
IFOINVAD.TQTYAF |
|
batch |
Batch |
No |
13 |
IFOINVAD.PRCOD7 |
|
serialnumber |
Serial number |
No |
20 |
IFOINVAD.PRCOD8 |
|
transactiondescription |
Transaction description |
No |
30 |
case IFOINVAD.INTRTX = *blank then ‘Iptor WM1’ else IFOINVAD.INTRTX |
|
reasoncode |
Reason code |
No |
3 |
|
|
orderreferencenumber |
Order reference number |
No |
12/0 |
IFOINVAD.PRCOD6 (1-12) |
|
orderreferencelinenumber |
Order reference line number |
No |
5/0 |
IFOINVAD.PRCOD6 (13-17) |
|
stockcategory |
Stock category |
Yes |
3 |
IFOINVAD.TINSTB |
|
signature |
Signature |
Yes |
10 |
IFOINVAD.REQUSR |
|
nccnumber |
NCC number |
No |
12/0 |
|
|
container |
Container |
No |
20 |
IFOINVAD.CONCOD |
|
messageid |
Message id, callers identification of the transaction |
No |
15/0 |
IFOINVAD.MSGNBR |
Move non-conform to non-conform (*NCCCAT)
Move from one non-conform stock category to another non-conform stock category.
Not applicable.
WMS Stock Synchronization transaction
Stock synchronization
Stock synchronization containing stock quantities for different quantity types for every item.
|
Parameter |
Description |
Required |
Length |
Iptor WM1 |
|
wsid |
Web service identification, identifies the caller |
Yes |
10 |
|
|
item |
Item code |
Yes |
35 |
IFOSSD.ITMCOD |
|
warehouse |
Warehouse code |
Yes |
3 |
IFOSSD.WHSCOD |
|
batch |
Batch |
No |
13 |
IFOSSD.PRCOD7 |
|
serialnumber |
Serial number |
No |
20 |
IFOSSD.PRCOD8 |
|
nccnumber |
NCC number |
No |
12/0 |
|
|
quantityonhand |
Stock on hand quantity in stock unit |
Yes |
15/3 |
IFOSSD.INVQTY |
|
quantityonpicklist |
Quantity on pick list in stock unit |
Yes |
15/3 |
IFOSSD.QTYLST |
|
quantitynotonpicklist |
Quantity not on pick list in stock unit |
Yes |
15/3 |
IFOSSD.QTYNPL |
|
quantitypicked |
Quantity picked in stock unit |
Yes |
15/3 |
IFOSSD.PICQTY |
|
orderreferencenumber |
Order reference number |
No |
12/0 |
IFOSSD.PRCOD6 (1-12) |
|
orderreferencelinenumber |
Order reference line number |
No |
5/0 |
IFOSSD.PRCOD6 (13-17) |
|
inventorystatus |
Inventory status |
No |
10 |
IFOSSD.INVSTC |
|
messageid |
Message id, callers identification of the transaction |
No |
15/0 |
IFOSSD.MSGNBR |
Lucas Systems voice transactions
This section provides the detailed outbound transaction layouts for Lucas Systems™ voice-directed solutions.
Business Partner transaction
Business partner segment
|
Column |
Description |
Required |
Data Type |
Length |
|
Name |
Business Partner Name |
Y |
string |
50 |
|
Number |
Business Partner Code |
Y |
string |
35 |
|
Description |
Business Partner Alias |
N |
string |
35 |
|
Address1 |
Address Line 1 |
N |
string |
50 |
|
Address2 |
Address Line 2 |
N |
string |
50 |
|
City |
Address Line 3 |
N |
string |
50 |
|
State |
Address Line 4 |
N |
string |
50 |
|
Zip |
Postal Code |
N |
string |
35 |
|
Country |
Country Code |
N |
string |
10 |
|
Phone |
Telephone Number |
N |
string |
35 |
|
Fax |
Fax Number |
N |
string |
35 |
|
ContactInfo |
Email Address |
N |
string |
35 |
|
ContactInfo2 |
Contact Information |
N |
string |
35 |
|
SpecialInstruction1 |
Special Instruction 1 |
N |
string |
35 |
|
SpecialInstruction2 |
Special Instruction 2 |
N |
string |
35 |
|
SpecialInstruction3 |
Special Instruction 3 |
N |
string |
35 |
Item transaction
Item segment
|
Column |
Description |
Required |
Data Type |
Length |
|
ItemNumber |
Owner Code and Item Code |
N |
string |
45 |
|
Description |
Item Description |
N |
string |
50 |
|
UOM1 |
Base Unit Code |
N |
string |
10 |
|
UOM2 |
Second Unit Code |
N |
string |
10 |
|
UOM3 |
Third Unit Code |
N |
string |
10 |
|
UOM4 |
Fourth Unit Code |
N |
string |
10 |
|
PackFactor1 |
Base Multiplication Factor |
N |
float |
|
|
PackFactor2 |
Second Multiplication Factor |
N |
float |
|
|
PackFactor3 |
Third Multiplication Factor |
N |
float |
|
|
PackFactor4 |
Fourth Multiplication Factor |
N |
float |
|
|
EnforceExpDateRangeFlag |
Enforce Expiration Date Check |
N |
bit |
|
|
ExpDateFormat |
Expiration Date Format |
N |
string |
10 |
Location transaction
Location segment
|
Column |
Description |
Required |
Data Type |
Length |
|
PickSection |
Picking Zone Code |
N |
string |
10 |
|
Warehouse |
Warehouse Code |
Y |
string |
10 |
|
LocationSequenceNumber |
Pick Sequence |
Y |
integer |
|
|
LocationString |
Location Code |
Y |
string |
10 |
|
IsStagingLocation |
Staging Location |
N |
bit |
|
|
DeleteFlag |
Remove |
N |
bit |
|
Pick Data transaction
Pick list header segment
|
Column |
Description |
Required |
Data Type |
Length |
|
MOT |
Transport Company Code |
Y |
string |
35 |
|
Route |
Outbound Route |
N |
string |
30 |
|
Stop |
Outbound Stop |
N |
string |
30 |
|
ShipDateTime |
Due Date |
Y |
datetime |
|
|
AssignmentNumber |
Picklist Number |
Y |
integer |
|
|
Warehouse |
Warehouse Code |
Y |
string |
10 |
|
WorkTypeCode |
Work Type Code |
Y |
string |
20 |
|
ToLocation |
To Location Code |
Y |
string |
10 |
|
BatchWeight |
Max Weight |
N |
float |
|
|
BatchCube |
Max Volume |
N |
float |
|
Pick list detail segment
|
Column |
Description |
Required |
Data Type |
Length |
|
Record Id |
Task Detail Number |
Y |
integer |
|
|
Order |
Outbound Order Number |
Y |
integer |
|
|
OrderRequestDateTime |
Requested Date |
Y |
datetime |
|
|
CustomerNumber |
Order Type |
Y |
string |
5 |
|
PickSection |
Picking Zone Code |
Y |
string |
10 |
|
LocationString |
From Location Code |
Y |
string |
10 |
|
ItemNumber |
Item Code |
Y |
string |
45 |
|
PickSequence |
Task Sequence |
Y |
integer |
|
|
QuantityOrdered |
Inventory Quantity |
Y |
float |
|
|
FromLocationType |
Equpiment Zone Code |
N |
string |
10 |
|
PickSpecialInstruction |
Instruction Text |
N |
string |
50 |
|
FromExpirationDate |
From Expiration Date |
N |
datetime |
|
|
ToExpirationDate |
To Expiration Date |
N |
datetime |
|
|
TransactionType |
Transaction Type Translated |
N |
string |
1 |
|
LPN |
To Container Code |
N |
string |
20 |
