1. Home
  2. /
  3. Product Documentation
  4. /
  5. Integration Transactions Guide

Integration Transactions Guide

Contents

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.

  1. An external system, such as Enterprise, sends information to Integrator as a download composed of one or more inbound interface files (IFs).
  2. Integrator identifies the IF, IF segments, and each instance, and then performs the following tasks:
  3. Determines what to do with the information, such as add, modify, or update.
  4. Generates a trigger.
  5. Determines resulting IFs.
  6. Populates IF segment tables within Iptor WM1.
  7. 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.

  1. A defined action within Iptor WM1, such as picking inventory, generates a trigger.
  2. Integrator performs the following tasks:
  3. Determines the outbound IFs.
  4. Gathers the export data from the application database.
  5. Creates the outbound IFs.
  6. 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_
unit_code

Second Stock Keep Unit

No

Yes

 

String

10

product_location_group_
update_action

Product Location Group Update Action

No

No

 

String

5

product_location_group_
code

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
Decimal

 

width

Width

No

No

0

Big
Decimal

 

height

Height

No

No

0

Big
Decimal

 

volume

Volume

No

No

0

Big
Decimal

 

weight

Weight

No

No

0

Big
Decimal

 

tare_weight

Tare Weight

No

No

0

Big
Decimal

 

standard_unit_value

Standard Unit Value

No

No

0

Big
Decimal

 

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_
year

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_
in_days

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
Decimal

 

min_sales_qty

Minimum Sales Quantity

No

No

 

Big
Decimal

 

repl_point

Replenishment Point

No

No

0

Big
Decimal

 

min_repl_qty

Minimum Replenishment Quantity

No

No

0

Big
Decimal

 

max_repl_qty

Maximum Replenishment Quantity

No

No

0

Big
Decimal

 

product_control_type_
code

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_
code

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_
code

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_
expected

Quantity per Container Expected

No

No

0

Big
Decimal

 

reception_inventory_
status_code

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_
partner_code

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
Decimal

 

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
Decimal

 

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_
owner

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_
group_code

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_
order

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_
decimals

SKU Number or Decimals

No

No

0

Short

 

inbound_logistic_group_code

Inbound Logistic Group Code

No

Yes

 

String

10

outbound_logistic_
group_code

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_
days

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_
code

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_
code

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_
update_action

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

 

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_
number

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_
code

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_
days

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_
code

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_
code

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_
update_action

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_
days

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
(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

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
then IFOINVAD.QTYAFT – IFOINVAD.QTYBEF
else IFOINVAD.TQTYAF-IFOINVAD.TQTYBE

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
(extract from timestamp)

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
(extract from timestamp)

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