PILOROTA WINDOWS Version |
INSTRUCTIONS Interfacing with external software |
Avant propos
Pilorota has been designed to communicate with an external software. The communication can be made in 3 ways :
- transfer of ASCII files on request or scheduled.
- With a dynamic link through transfer tables where both softwares write their actions.
- With execution of SAP functions in the BAPI / RFC. This solution is a real time.
The standard mode of exchange with Pilorota is the text file exchange and is described below..
Description
Exchanged data
Pilorota can receive from the ERP the following information :
- List of items to input (LENTX.TXT),
- List of items to return (LRETX.TXT),
- List of items to output (LSORX.TXT),
- List of items to inventory (LINVX.TXT).
Moreocver, Pilorota can send reports to the ERP. :
- Report of transmitted inputs.
- Report of transmitted returns,
- Report of transmitted outputs,
- Report of transmitted inventories.
Mode
The exchanges are made in a shared directory, accessible for Pilorota and the ERP.
The ERP copies the files to be transmitted to Pilorota in that directory, the Pilorota imports those files.
Pilorota copies the reports in that directory and leaves them at the disposal of the ERP.
The software that imports them has to delete them after the import.
The names of files are examples, and can be modified.
Text files in CSV format are formatted in the following way :
- 1 record per line separated with CR/LF,
- Record with different length with TAB as a separation,
- Date format is YYYYMMDD
- Decimals are separated with a dot not with a comma.
Sécurity
In order to avoid conflicts of access to the files, it is sufficient to plan the tasks with a delay between Pilorota and the ERP.
Otherwise, the name of files can include the date and time :
NAME_<datetime>.txt
At the end, the software that has written the control file deletes it after the transfer.
APPENDIX
Below a description of files that can be used to communicate with an external Software.
Input Lists
The file transmitted by the ERP, permits to import the list of items to put on stock.
Pilorota imports the content of inputs to be made and creates as many list as there is different N° of Delivery/ N° of Order in the file LENTX.TXT.
LENTX.TXT
Description of the field | Structure | Field | Format | Comment | |
N° of Delivery/ N° of Order | car (10) | ||||
Description N Delivery/N of Order | car (30) | ||||
Date of reception of the product | date (8) | YYYYMMDD | |||
Number of the line of the order | car (3) | ||||
Item Id | car (25) | ||||
Item Description | car (40) | ||||
Group | car (10) | ||||
Unit | car (4) | ||||
Quantity | num (6) | 999999 | |||
Batch number | car (10) | ||||
Expiration Date | date (8) | YYYYMMDD | |||
Serial Number | car (10) | (if in use) | |||
Machine Number | car (20) | ||||
Location : Level/Zone/Compartment | car (9) | LLLLZZZCC | |||
If serial numbers are in use, the ERP has to send the lines one by one (one line per different serial number)
Input Reports
That report transmits to the ERP the real Quantities entered (corrected by the operator).
The report is optional.
XENTR.TXT (externe)
Description of the field | Structure | Field | Format | Comment | |
N° of Delivery/ N° of Order | car (10) | ||||
Number of the line of the order | car (3) | ||||
Item Id | car (25) | ||||
Quantity | num (6) | 999999 | |||
Date of operation | date (8) | YYYYMMDD | |||
Operator that made the input | car (8) | ||||
Batch number | car (10) | ||||
Expiration Date | date (8) | YYYYMMDD | |||
Serial Number | car (10) | (if in use) | |||
Machine Number | car (20) | ||||
Location : Level/Zone/Compartment | car (9) | LLLLZZZCC | |||
Liste of returns
The file transmitted by the ERP, permits to import the list of items to be returned.
Pilorota imports the content of returns to be made and creates as many list as there is different N° of Delivery/ N° of Order in the file LRETX.TXT
LRETX.TXT
Description of the field | Structure | Field | Format | Comment | |
N° of Delivery/ N° of Order | car (10) | ||||
Description N Delivery/N of Order | car (30) | ||||
Date of reception of the product | date (8) | YYYYMMDD | |||
Number of the line of the order | car (3) | ||||
Item Id | car (25) | ||||
Item Description | car (40) | ||||
Group | car (10) | ||||
Unit | car (4) | ||||
Quantity | num (6) | 999999 | |||
Batch number | car (10) | ||||
Expiration Date | date (8) | YYYYMMDD | |||
Serial Number | car (10) | (if in use) | |||
Machine Number | car (20) | ||||
Location : Level/Zone/Compartment | car (9) | LLLLZZZCC | |||
If serial numbers are in use, the ERP has to send the lines one by one (one line per different serial number)
Return Reports
That report transmits to the ERP the real Quantities entered (corrected by the operator).
The report is optional.
XENTR.TXT (externe)
Description of the field | Structure | Field | Format | Comment | |
N° OF/ N° commande | car (10) | ||||
Number of the line of the order | car (3) | ||||
Item Id | car (25) | ||||
Quantity | num (6) | 999999 | |||
Date of operation | date (8) | YYYYMMDD | |||
Operator that made the input | car (8) | ||||
Batch number | car (10) | ||||
Expiration Date | date (8) | YYYYMMDD | |||
Serial Number | car (10) | (if in use) | |||
Machine Number | car (20) | ||||
Location : Level/Zone/Compartment | car (9) | LLLLZZZCC | |||
List of outputs
The file transmitted by the ERP, permits to import the list of items to take from stock.
Pilorota imports the content of inputs to be made and creates as many list as there is different N° of Delivery/ N° of Order in the file LSORX.TXT.
LSORX.TXT
Description of the field | Structure | Field | Format | Comment | ||
N° of Delivery/ N° of Order | car (10) | |||||
Description N° of Delivery/ N° of Order | car (30) | |||||
Priority | car (1) | 1, 2 ou 3 | 1(immediately), 2 (Urgent) or 3 (Normal) | |||
Date of order | date (8) | YYYYMMDD | ||||
Number of the line of the order | car (3) | |||||
Item Id | car (25) | |||||
Quantity | num (6) | 999999 | ||||
Batch number | car (10) | (if in use) | ||||
Expiration Date | date (8) | YYYYMMDD | (if in use) | |||
Serial Number | car (10) | (if in use) | ||||
Machine Number | car (20) | |||||
Location : Level/Zone/Compartment | car (9) | LLLLZZZCC | ||||
If serial numbers are in use, the ERP has to send the lines one by one (one line per different serial number).
Output Reports
That report transmits to the ERP the real Quantities entered (corrected by the operator).
The report is optional.
XSORT.TXT
Description of the field | Structure | Field | Format | Comment | |
N° of Delivery/ N° of Order | car (10) | ||||
Number of the line of the order | car (3) | ||||
Item Id | car (25) | ||||
Quantity | num (6) | 999999 | |||
Date of operation | date (8) | YYYYMMDD | |||
Operator that made the input | car (8) | ||||
Batch number | car (10) | ||||
Expiration Date | date (8) | YYYYMMDD | |||
Serial Number | car (10) | (if in use) | |||
Machine Number | car (20) | ||||
Location : Level/Zone/Compartment | car (9) | LLLLZZZCC | |||
List of items to inventory
The file transmitted by the ERP, permits to import the list of items to inventory.
Pilorota imports that table and asks the user to enter the quantity in the location.
LINVE.TXT
Description of the field | Structure | Field | Format | Comment |
N° of Inventory List | car (10) | |||
Description of the inventory list | car (30) | |||
Priority | car (1) | 1, 2 ou 3 | 1(immediately), 2 (Urgent) or 3 (Normal) | |
Date of request | date (8) | YYYYMMDD | ||
N° of line of the item to inventory | car (3) | |||
Item Id | car (25) | |||
N° de lot | Car (10) | |||
Machine Number | car (20) | |||
Location : Level/Zone/Compartment | car (9) | LLLLZZZCC | ||
Inventory reports
The report transmits to the ERP the quantities.The report is optional.
XINVE.TXT
Description of the field | Structure | Field | Format | Comment | |
N° of inventory list | car (10) | ||||
N° of line of the item | car (3) | ||||
Item Id | car (25) | ||||
Quantity counted at the location | num (6) | 999999 | |||
Date of operation | date (8) | YYYYMMDD | |||
Operator that made the inventory | car (8) | ||||
Batch number | car (10) | ||||
Expiration Date | date (8) | YYYYMMDD | |||
Serial Number | car (10) | (if in use) | |||
Machine Number | car (20) | ||||
Location : Level/Zone/Compartment | car (9) | LLLLZZZCC | |||