PLM setup
This function is used to set up the interface with the PLM @UDROS product.
This interface is used to transfer, via .csv files, the , the data contained in the Products and Manufacturing BOMs and Sub-contracting BOMs database coming from the @UDROS product.
The Principles of the interface functioning are given below.
Once the setup is done, the processing can be launched using the following function: Start PLM interface.
Prerequisite
Refer to documentation Implementation
Screen management
Entry screen
The setup consists in indicating:
- The references of the Products and BOMs pivots, describing the expected .csv files.
- The production BOM alternative code used.
- The Manufacturing or Sub-contracting BOM type.
- The recipients' email addresses of the workflow issued when the interface processing fails and/or produces rejects.
- The storage directory for the .csv files to process, the files processed and the directory in which the .csv file containing the product references made up in Sage X3 is created.
- The default value of the Products and BOMs table headings, not loaded by the interface file. A list of these headings is suggested by default, but all the fields contained in the file might have a default value.
Block number 1
| Identifier (field ID) |
|
Identification code of the interface setup. |
| field INTIT |
Block number 2
| Product set (pivot) (field ITMPIT) |
|
Enter a pivot for the items to process. |
| BOM set (pivot) (field BOMPIT) |
|
Enter a pivot for the BOMs. |
| BOM type (field BOMALTTYP) |
|
This field is used to indicate the BOM type, "Manufacturing" or "Sub-contracting", in order to orient the import type when importing a BOM file. |
| BOM code (field BOMALT) |
|
Several BOMs can be defined for the same product reference. The various BOM codes can be used to manage different product structures according to their use in context:
To set up the PLM interface, select among the production codes those that should be used to create the BOMs. |
| Email address (field ADDEML1) |
|
Enter the e-mail address of the person who will be receiving the data transfer reports and any error messages during the transfer. |
| field ADDEML2 |
| Destination type (field TYPEXP) |
| Directory to be scanned (field VOLFILRCP) |
| Storage directory for processed files (field VOLFILSTO) |
| Deposit directory (field VOLFILISS) |
| Table code (field CODFIC) |
|
Code of the table to which belongs the heading for which a default value has been defined. |
| Field code (field CODZONE) |
|
Code of the heading for which a default value has been defined. |
| Description (field COM) |
| Default value (field VALDEF) |
|
It is possible to specify here an expression which will be suggested by default for the field. A selection can be suggested depending on the field code chosen. |
Specific points
The processing by interface is, in a broad outline, identical, whether it concerns the Products or the BOMs. It uses .csv files supplied by the PLM @UDROS product.
General information on the files
- Format: .csv
- Type: UTF8 (can be modified by entry point, see below)
- The fields have a variable length and are separated by ";" (this can be modified by entry point, see below)
- For numbers, the decimal mark is the point.
- For dates, the format is "YYYYMMDDHHmm" or "YYYYMMDD"
- Durations are expressed in hours
- Booleans can take either the value 0 (false) or 1 (true)
- The files have no header.
The description of each file line is given by a Pivot specifying the fields orders, their size and describing their loading (directly via table fields or via functions).
The files name and the pivots used by default are indicated below.
|
Expected files |
|
Default pivots |
BOM type |
|
Products |
PLMKI |
(no effect) |
|
|
Production BOMs |
PLMKB |
Manufacturing |
|
|
Sub-contractin BOMs |
PLMKS |
Subcontract |
Entry points
The PIVOTSFILE entry point of the CONNECTFCT processing can be used to modify the coding type of the files and the column separator.
Description of the imported files in Sage X3
Products: ITMxxx.csv
Pivot: PLMKI
|
Information |
Field reference |
Mand. |
Type |
Note |
|
IDENTIFICATION DATA |
|
|
|
|
|
Product reference @UDROS |
ITMMASTER/PLMITMREF |
X |
Alphanumerical (70) |
|
|
X3 Product reference |
ITMMASTER/ITMREF |
|
Alphanumerical (20) |
ITMMASTER Table |
|
Category |
ITMMASTER/TCLCOD |
X |
Alphanumerical (5) |
ITMCATEG Table |
|
Product status |
ITMMASTER/ITMSTA |
|
Integer (2) |
246 Menu |
|
Search key |
ITMMASTER/SEAKEY |
|
Alphanumerical (20) |
|
|
Description 1 |
ITMMASTER/ITMDES1 |
X |
Alphanumerical (30) |
|
|
Description 2 |
ITMMASTER/ITMDES2 |
|
Alphanumerical (30) |
|
|
Description 3 |
ITMMASTER/ITMDES3 |
|
Alphanumerical (30) |
|
|
Standard |
ITMMASTER/ITMSTD |
|
Alphanumerical (20) |
|
|
UPC code |
ITMMASTER/EANCOD |
|
Alphanumerical (20) |
|
|
Default title (in %) |
ITMMASTER/DEFPOT |
|
Decimal (5.4) |
If product managed by title |
|
Start of life |
ITMMASTER/LIFSTRDAT |
|
date-format YYYYMMDD |
|
|
End of life |
ITMMASTER/LIFENDDAT |
|
date-format YYYYMMDD |
|
|
Stock unit |
ITMMASTER/STU |
X |
Alphanumerical (3) |
TABUNIT Table |
|
Weight unit |
ITMMASTER/WEU |
|
Alphanumerical (3) |
TABUNIT Table |
|
STK unit weight |
ITMMASTER/ITMWEI |
|
Decimal (6.3) |
|
|
Volume Unit |
ITMMASTER/VOU |
|
Alphanumerical (3) |
TABUNIT Table |
|
STK unit Volume |
ITMMASTER/ITMVOU |
|
Decimal (5.3) |
|
|
Density |
ITMMASTER/DTY |
|
Decimal (5.6) |
|
|
Expiry management |
ITMMASTER/EXYMGTCOD |
|
Integer (2) |
211 Menu |
|
Expiry status |
ITMMASTER/EXYSTA |
|
Alphanumerical (1) |
|
|
Expiry lead-time |
ITMMASTER/SHL |
|
Integer (4) |
|
|
New control lead-time |
ITMMASTER/SHLLTI |
|
Integer (4) |
|
|
New control status |
ITMMASTER/NEWLTISTA |
|
Alphanumerical (1) |
|
|
Coefficient UBD |
ITMMASTER/DLU |
|
Decimal (5.6) |
|
|
Expiry time unit |
ITMMASTER/SHLUOM |
|
Integer (2) |
2759 Menu |
|
New control time Unit |
ITMMASTER/SHLLTIUOM |
|
Integer (2) |
2759 Menu |
|
SUPPLIER DATA |
|
|
|
|
|
Supplier |
ITMBPS/BPSNUM |
|
Alphanumerical (15) |
BPARTNER Table |
|
Supplier product reference |
ITMBPS/ITMREFBPS |
|
Alphanumerical (20) |
|
|
Supplier product description |
ITMBPS/ITMDESBPS |
|
Alphanumerical (30) |
|
|
Priority |
ITMBPS/PIO |
|
Integer (2) |
|
|
Quality rank |
ITMBPS/QLYMRK |
|
Integer (2) |
|
|
Frequency |
ITMBPS/QUAFRY |
|
Integer (4) |
|
|
Control number |
ITMBPS/QUANUM |
|
Integer (4) |
|
|
Quality record |
ITMBPS/QLYCRD |
|
Alphanumerical (8) |
|
|
Submitted to control |
ITMBPS/QUAFLG |
|
Integer (2) |
275 Menu |
|
ATTACHMENTS |
|
|
|
|
|
URL on PLM linked documents |
ITMMASTER/PLMATTURL |
|
Alphanumerical (250) |
|
|
URL on PLM history documents |
ITMMASTER/PLMHISURL |
|
Alphanumerical (250) |
|
Product default values
The following default values are used if no value is given in the file.
Any field in the file might have a default value.
|
Table |
Field |
Default value |
|
ITMMASTER |
ITMSTA |
1 "Active" |
|
ITMMASTER |
EXYMGTCOD |
1 " No management" |
|
ITMMASTER |
SHLUOM |
1 "Calendar D." |
|
ITMMASTER |
SHLLTIUOM |
1 "Calendar D." |
|
ITMBPS |
QUAFLG |
1 "No control" |
Note concerning the descriptions of products to import:
In the Product set (pivot) PLMKI of the PLM connector, the first description of the product is displayed in the import language. Nevertheless, it is possible to indicate in the pivot file a language code and a description in this language code.
To do this, it is necessary to duplicate the pivot PLMKI and to follow this procedure:
- In the copy of the pivot PLMKI, the two folllowing fields must be indicated.
Since they are qualified as "not managed", they must not be placed at the end of the file.
Table code: ITMMASTER
Field code: WLAN
Select: Field not managed
And
Table code : ITMMASTER
Field code: WITMDES1
Select: Field not managed
- In the corresponding Product file,
For column WLAN: indicate for each product line to import, a language code present in the Sage X3 language table (for instance: ENG). If the code does not exist, the import will fail.
For column WITMDES1: indicate a description matching the indicated language.
BOMs: BOMxxx.csv
Pivot: PLMKB
|
Information |
Field reference |
Mand. |
Type (max length) |
Note |
|
HEADER DATA |
|
|
|
|
|
Parent product |
BOM/ITMREF |
X |
Alphanumerical (70) |
ITMMASTER/PLMITMREF table |
|
Description |
BOM/BOMDES |
X |
Alphanumerical (30) |
|
|
Use status |
BOM/USESTA |
|
Integer (2) |
240 Menu |
|
Validity start date |
BOM/BOHSTRDAT |
|
date - YYYYMMDD format |
|
|
Validity end date |
BOM/BOHENDDAT |
|
date - YYYYMMDD format |
|
|
Base quantity |
BOM/BASQTY |
|
Decimal (15) |
|
|
Management unit |
BOM/QTYCOD |
|
Integer (2) |
225 Menu |
|
ATTACHMENTS |
|
|
|
|
|
URL on PLM linked documents |
BOM/PLMATTURL |
|
Alphanumerical (250) |
|
|
DETAIL DATA |
|
|
|
|
|
Sequence |
BOMD/BOMSEQ |
X |
Integer |
Order number |
|
Component |
BOMD/CPNITMREF |
X |
Alphanumerical (70) |
ITMMASTER/PLMITMREF table |
|
Component type |
BOMD/CPNTYP |
|
Integer (2) |
438 Menu |
|
Link description |
BOMD/BOMSHO |
|
Alphanumerical (30) |
|
|
Validity start lot |
BOMD/BOMSTRLOT |
|
date - YYYYMMDD format |
|
|
Validity end lot |
BOMD/BOMENDLOT |
|
date - YYYYMMDD format |
|
|
Validity start |
BOMD/BOMSTRDAT |
|
date - YYYYMMDD format |
|
|
Validity end |
BOMD/BOMENDDAT |
|
date - YYYYMMDD format |
|
|
Link quantity code |
BOMD/LIKQTYCOD |
|
Integer (2) |
226 Menu |
|
Rounded quantity |
BOMD/QTYRND |
|
Integer (2) |
293 Menu |
|
UOM |
BOMD/BOMUOM |
|
Alphanumerical (3) |
TABUNIT Table |
|
UOM link quantity |
BOMD/BOMQTY |
|
Decimal (15) |
|
|
STK link quantity |
BOMD/LIKQTY |
X |
Decimal (15) |
|
|
Code to use |
BOMD/PKC |
|
Integer (2) |
2328 Menu |
Sub-contracting BOMs: BOMSxxx.csv
Pivot: PLMKS
The pivot can be used to import:
- A sub-contracting BOM header
- At least one service line.
- Optionally, one or several material lines.
The header is repeated irrespective of the line type (service or material).
Depending on the type of line (service or material) that is imported, not the same fields will be imported. Nevertheless, the different fields are present in the import file and must be left empty, according to the following array:
|
Information |
Field reference |
Mand. |
Type (max length) |
Note |
Service |
Material |
|
HEADER DATA |
|
|
|
|
|
|
|
Parent product |
BOM/ITMREF |
X |
Alphanumerical (70) |
ITMMASTER/PLMITMREF table |
X |
X |
|
Description |
BOM/BOMDES |
X |
Alphanumerical (30) |
|
X |
X |
|
Use status |
BOM/USESTA |
|
Integer (2) |
240 Menu |
X |
X |
|
Validity start date |
BOM/BOHSTRDAT |
|
date - YYYYMMDD format |
|
X |
X |
|
Validity end date |
BOM/BOHENDDAT |
|
date - YYYYMMDD format |
|
X |
X |
|
Base quantity |
BOM/BASQTY |
|
Decimal (15) |
|
X |
X |
|
Management unit |
BOM/QTYCOD |
|
Integer (2) |
225 Menu |
X |
X |
|
ATTACHMENTS |
|
|
|
|
|
|
|
URL on PLM linked documents |
BOM/PLMATTURL |
|
Alphanumerical (250) |
|
X |
X |
|
DETAIL DATA |
|
|
|
|
|
|
|
Sequence |
BOMD/BOMSEQ |
Integer (4) |
|
X |
X |
|
|
Component |
BOMD/CPNITMREF |
X |
Alphanumerical (20) |
|
X |
X |
|
Component type |
BOMD/CPNTYP |
X |
Alphanumerical (15) |
|
X |
X |
|
Link description |
BOMD/BOMSHO |
|
Alphanumerical (30) |
|
X |
X |
|
Validity start |
BOMD/BOMSTRDAT |
|
date - YYYYMMDD format |
|
X |
X |
|
Validity end |
BOMD/BOMENDDAT |
|
date - YYYYMMDD format |
|
X |
X |
|
Operation lead time |
BOMD/BOMOFS |
|
Integer (4) |
|
X |
X |
|
Link quantity code |
BOMD/LIKQTYCOD |
|
Integer (2) |
226 Menu |
X |
X |
|
Rounded quantity |
BOMD/QTYRND |
|
Integer (2) |
293 Menu |
X |
X |
|
UOM link quantity |
BOMD/BOMQTY |
|
Decimal (15) |
|
X |
X |
|
Link quantity |
BOMD/LIKQTY |
X |
Decimal (15) |
|
X |
X |
|
UOM |
BOMD/BOMUOM |
|
Alphanumerical (3) |
|
X |
|
|
UOM-STK coefficient |
BOMD/BOMSTUCOE |
|
Decimal (5.6) |
|
X |
|
|
Replenishment type |
BOMD/SCOFLG |
X |
Integer (2) |
2225 Menu |
|
X |
|
Scrap percentage |
BOMD/SCA |
|
Decimal (3.3) |
|
|
X |
BOM default values
The following default values are used if no value is given in the file.
Any field in the file might have a default value.
|
Table |
Field |
Default value |
|
BOM |
USESTA |
2 "Operation" |
|
BOM |
BASQTY |
1/ |
|
BOM |
QTYCOD |
1 "for one" |
|
BOM |
BOMALTTYP |
2 "Manufacturing" for the manufacturing BOMs |
|
BOMD |
CPNTYP |
1 "Normal" |
|
BOMD |
LIKQTYCOD |
1 "Proportional" |
|
BOMD |
QTYRND |
1 "To the nearest" |
|
BOMD |
PKC |
1 "Component not weighed using a weighing station" |
Tables load
Product tables load
Each line of the IT XXX.csv file (where xxx represents a unique number) corresponds to a product. These line will load the tables:
The interface processing (CONNECTITM connector), which manages the data of these tables, is used to:
- load the screens of the OITM standard window - Products,
- assign pivot values,
- control the standard and specific screens,
- validate elements.
Updating these products is carried out by an actual update of elements by triggering the standard and any specific controls.
The load terms of the Products tables, via the interface processing, are given below.
Products Tables: ITMMASTER
|
Field |
Type |
Menu |
Normal title |
Load |
|
ITMREF |
ITM |
|
Product |
Interface file |
|
TSICOD |
ADI |
|
Statistical group |
Recovered from the category |
|
TCLCOD |
ITG |
|
Category |
Interface file |
|
SEAKEY |
A |
Search key |
Interface file |
|
|
DIE |
DIE |
|
Dimension code |
Recovered from the category |
|
CCE |
CCE |
|
Analytical dimension |
Recovered from the category |
|
ACCCOD |
CAC |
|
Accounting code |
Recovered from the category |
|
ITMDES1 |
DES |
|
Description 1 |
Interface file |
|
ITMDES2 |
DES |
|
Description 2 |
Interface file |
|
ITMDES3 |
DES |
|
Description 3 |
Interface file |
|
DES1AXX |
AXX |
|
Description 1 |
Interface file (ITMDES1) |
|
DES2AXX |
AXX |
|
Description 2 |
Interface file (ITMDES2) |
|
DES3AXX |
AXX |
|
Description 3 |
Interface file (ITMDES3) |
|
STDFLG |
M |
Management mode |
Recovered from the category |
|
|
ITMSTD |
A |
|
Standard |
Interface file |
|
EANCOD |
A |
|
UPC code |
Interface file |
|
ITMSTA |
M |
Product status |
Interface file or default value |
|
|
DEFPOT |
DCB |
|
Default title (in %) |
Interface file |
|
DEFACT |
DCB |
|
Default title (in UI) |
Not managed |
|
LIFSTRDAT |
D |
|
Start of life |
Interface file |
|
LIFENDDAT |
D |
|
End of life |
Interface file |
|
STOCRD |
A |
|
Storage record |
|
|
STU |
UOM |
|
Stock unit |
Interface file |
|
PUU |
UOM |
|
Purchase unit |
Copy of ITM.STU |
|
SAU |
UOM |
|
Sales unit |
Copy of ITM.STU |
|
SSU |
UOM |
|
Statistical unit |
Copy of ITM.STU |
|
EEU |
UOM |
|
EU unit |
Copy of ITM.STU |
|
PUUSTUCOE |
COE |
|
SAL-STK coefficient |
1/ |
|
DACPUUCOE |
M |
1/ |
Enter purchase coeff |
1 " no " |
|
SAUSTUCOE |
COE |
SAL-STK coefficient |
1/ |
|
|
DACSAUCOE |
M |
1/ |
Enter sales coeff |
1 " no " |
|
SSUSTUCOE |
COE |
|
StatU-STK coefficient |
1/ |
|
EEUSTUCOE |
COE |
|
EUU-STK coefficient |
|
|
WEU |
UOM |
|
Weight unit |
Interface file or Recovered from the category or default value |
|
ITMWEI |
WEI |
|
STK unit weight |
Interface file or Recovered from the category or default value |
|
VOU |
UOM |
|
Volume Unit |
Interface file or Recovered from the category or default value |
|
ITMVOU |
VOL |
|
STK unit Volume |
Interface file or Recovered from the category or default value |
|
PCU |
UOM |
Packing |
Recovered from the category |
|
|
PCUSTUCOE |
COE |
PAC-STK coefficient |
Recovered from the category |
|
|
DACPCUCOE |
M |
1/ |
Authorized coeff entry |
Recovered from the category |
|
PCURUL |
M |
CU stock issue |
Recovered from the category |
|
|
LBEFMT |
ARP |
|
Label format |
Recovered from the category |
|
STOMGTCOD |
|
Stock management |
Recovered from the category |
|
|
LOTMGTCOD |
|
Lot management |
Recovered from the category |
|
|
LOTCOU |
ANM |
Lot sequence number counter |
Recovered from the category |
|
|
SERCOU |
ANM |
Serial number sequence counter |
Recovered from the category |
|
|
SERMGTCOD |
M |
Serial management |
Recovered from the category |
|
|
EXYMGTCOD |
M |
Expiry management |
Interface file |
|
|
EXYSTA |
A |
|
Expiry status |
Interface file |
|
SHL |
C |
|
Expiry lead-time |
Interface file |
|
SHLLTI |
C |
|
New control lead-time |
Interface file |
|
NEGSTO |
M |
1/ |
Stock < 0 authorized |
Recovered from the category |
|
CSTGRP |
A |
|
Cost group |
|
|
BRDCOD |
M |
Cost group |
Recovered from the category |
|
|
PLAACS |
ACS |
|
Manager access |
Recovered from the category |
|
RPLITM |
ITM |
|
Replacement product |
|
|
EECGES |
M |
1/ |
Subject to Intrastat |
2 "Yes" |
|
CUSREF |
INO |
Customs reference |
|
|
|
EECSCHITD |
SCH |
|
Introduction rule |
|
|
EECSCHSHI |
SCH |
|
Shipment rule |
|
|
VACITM |
ADI |
Tax level |
Recovered from the category |
|
|
FRTHORUOM |
M |
Time unit w/o planning |
Recovered from the category |
|
|
FRTHOR |
C |
|
Planned horizon |
Recovered from the category |
|
FIMHOR |
C |
|
Firm horizon |
Recovered from the category |
|
FIMHORUOM |
M |
Time unit w/o firm |
Recovered from the category |
|
|
BUY |
AUS |
|
Buyer |
Recovered from the category |
|
PLANNER |
AUS |
|
Planner |
Recovered from the category |
|
OFS |
C |
|
Reorder lead-time |
Recovered from the category |
|
MINRMNPRC |
RAT |
|
Balance tolerance % |
Recovered from the category |
|
RCPFLG |
M |
1/ |
Receipt code |
Recovered from the category |
|
PRQFLG |
M |
1/ |
Mandatory PO |
Recovered from the category |
|
PURTEX |
TXC |
|
Purchase text |
|
|
MFGTEX |
TXC |
|
Production text |
|
|
ITMEXNFLG |
A |
|
Exemption flag |
|
|
STATAXFLG |
A |
|
Taxability flag |
|
|
CFGLIN |
TLP |
|
Product line |
Recovered from the category |
|
CFGFLDNUM1 |
DCB |
|
Field no. 1 |
|
|
CFGFLDNUM2 |
DCB |
|
Field no. 2 |
|
|
CFGFLDNUM3 |
DCB |
|
Field no. 3 |
|
|
CFGFLDNUM4 |
DCB |
|
Field no. 4 |
|
|
CFGFLDNUM5 |
DCB |
|
Field no. 5 |
|
|
CFGFLDNUM6 |
DCB |
|
Field no. 6 |
|
|
CFGFLDALP1 |
A |
|
Alphanumerical field 1/ |
|
|
CFGFLDALP2 |
A |
|
Alphanumerical field 2/ |
|
|
CFGFLDALP3 |
A |
|
Alphanumerical field 3/ |
|
|
CFGFLDALP4 |
A |
|
Alphanumerical field 4/ |
|
|
CFGFLDALP5 |
A |
|
Alphanumerical field 5/ |
|
|
CFGFLDALP6 |
A |
|
Alphanumerical field 6/ |
|
|
CFGVCRNUM |
VCR |
|
no. config. document |
|
|
CFGBPRNUM |
BPR |
|
BP |
|
|
CFGBPRREF |
A |
|
BP reference |
|
|
CFGITMREF |
ITM |
|
Reference product |
|
|
CFGDELDAT |
D |
|
Config. purge date |
|
|
CREMAC |
M |
1/ |
Creation on the installed base |
|
|
FLYCAT |
ADI |
|
Voucher category |
|
|
TPLCONLND |
COT |
|
Loan contract |
|
|
TPLCONGUA |
COT |
|
Warranty contract |
|
|
TPLCONSRV |
COT |
|
Service contract |
|
|
PITCDT |
L |
|
Tokens credited |
|
|
PITCDTUOM |
UOM |
Credit unit |
||
|
STULBEFMT |
ARP |
|
Label format |
Recovered from the category |
|
ALTBOMHDK |
TBO |
|
Alternative |
|
|
HDKITMTYP |
M |
Product type |
|
|
|
STOISSDEF |
M |
1/ |
Stock issue |
|
|
DAYUOM |
UOM |
|
Unit for the days |
|
|
HOUUOM |
UOM |
|
Unit for the hour |
|
|
MNTUOM |
UOM |
Unit for minutes |
|
|
|
DTY |
COE |
|
Density |
Interface or calculated file |
|
TRKCOD |
M |
Traceability |
Recovered from the category |
|
|
PURFLG |
M |
1/ |
Purchased |
Recovered from the category |
|
MFGFLG |
M |
1/ |
Manufactured |
Recovered from the category |
|
SCPFLG |
M |
1/ |
Subcontracted |
Recovered from the category |
|
SCSFLG |
M |
1/ |
Subcontract |
Recovered from the category |
|
PHAFLG |
M |
1/ |
Phantom product |
Recovered from the category |
|
GENFLG |
M |
1/ |
Generic |
Recovered from the category |
|
TOOFLG |
M |
1/ |
Tools |
Recovered from the category |
|
DLVFLG |
M |
1/ |
Deliverable |
Recovered from the category |
|
SALFLG |
M |
1/ |
Sold |
Recovered from the category |
|
INTFLG |
M |
1/ |
Intermediary |
Recovered from the category |
|
FLGFAS |
M |
1/ |
Capitalizable |
|
|
NEWLISTA |
A |
|
New control status |
Interface file |
|
DLU |
COE |
|
Coefficient UBD |
Interface file |
|
SHLUOM |
M |
2759/ |
Expiry time unit |
Interface file or default value |
|
SHLLTIUOM |
M |
2759/ |
Recontrol time Unit |
Interface file or default value |
|
EXPNUM |
L |
|
Export no. |
Recovered from the category |
|
CREDAT |
D |
|
Creation date |
Date in creation |
|
CREUSR |
A |
|
Creation operator |
GUSER in creation |
|
UPDDAT |
D |
|
Date modification |
Date$ in modification |
|
UPDUSR |
A |
|
Operator modif |
GUSER in modification |
|
STAFED |
ADI |
|
Federal state |
|
|
PLMITMREF |
A |
|
PLM Product reference |
Interface file |
|
PLMATTURL |
A |
|
URL on PLM documents |
Interface file |
|
PLMHISURL |
A |
|
URL on PLM history |
Interface file |
Products - Sites Table: ITMFACILIT
|
Field |
Type |
Menu |
Normal title |
Load |
|
ITMREF |
ITM |
0/ |
Product |
Recovered from header |
|
STOFCY |
FCY |
0/ |
Storage site |
Determined for the set up alternative |
|
CUNFLG |
M |
1/ |
Held stock count |
1 " no " |
|
CUNLISNUM |
VCR |
0/ |
Stock count in progress |
|
|
ABCCLS |
M |
ABC category |
Recovered from the category |
|
|
LOCMGTCOD |
M |
1/ |
Location management |
Recovered from the category |
|
STOCOD |
M |
Stock issue mode |
Recovered from the category |
|
|
CUNCOD |
M |
Count mode |
Recovered from the category |
|
|
SESCOD |
SES |
0/ |
Seasonality |
Recovered from the category |
|
DAYCOV |
COV |
0/ |
Coverage |
Recovered from the category |
|
TOTLTI |
LTI |
0/ |
Multi-level lead-time |
|
|
QUALTI |
LTI |
0/ |
Quality ctrl lead-time |
|
|
PLH |
C |
0/ |
Firm horizon |
Recovered from the category |
|
PLHUOT |
M |
Time unit w/o firm |
Recovered from the category |
|
|
FOH |
C |
0/ |
Request horizon |
Recovered from the category |
|
FOHUOT |
M |
Time unit w/o firm |
Recovered from the category |
|
|
OFS |
LTI |
0/ |
Reorder lead-time |
Recovered from the category |
|
MFGLTI |
LTI |
0/ |
Production lead-time |
|
|
PRPLTI |
LTI |
0/ |
Picking lead-time |
|
|
MIC |
C |
0/ |
Degression coeff |
|
|
REOMGTCOD |
M |
Replenishment mode |
Recovered from the category |
|
|
REOPER |
C |
0/ |
Replenishment frequency |
Recovered from the category |
|
REOCOD |
M |
Suggestion type |
Recovered from the category |
|
|
REOFCY |
FCY |
0/ |
Replenishment site |
Recovered from the category |
|
REOPOL |
RPO |
0/ |
Replenishment policy |
Recovered from the category |
|
SAFSTO |
QTY |
0/ |
Safety stock |
Recovered from the category |
|
SAFSTOCLC |
QTY |
0/ |
Calculated safety stock |
|
|
REOTSD |
QTY |
0/ |
Replenishment threshold |
Recovered from the category |
|
REOTSDCLC |
QTY |
0/ |
Calculated replenishment threshold |
|
|
MAXSTO |
QTY |
0/ |
Maximum stock |
Recovered from the category |
|
MAXSTOCLC |
QTY |
0/ |
Maxi stock calculated |
|
|
REOMINQTY |
QTY |
0/ |
Economic lot |
Recovered from the category |
|
REOMINCLC |
QTY |
0/ |
Eco lot calculated |
|
|
MFGLOTQTY |
QTY |
0/ |
Technical lot |
Recovered from the category |
|
SHR |
DCB |
0/ |
Shrinkage percentage |
Recovered from the category |
|
PLANNER |
AUS |
0/ |
Planner |
Recovered from the category |
|
BUY |
AUS |
0/ |
Buyer |
Recovered from the category |
|
OTRSTYP |
M |
Movement type |
Recovered from the category |
|
|
OVECOD |
OVE |
0/ |
Overheads |
Recovered from the category |
|
OVECPNFLG |
M |
1/ |
OH cpn level OH calculation |
Recovered from the category |
|
STDCSTUPD |
M |
Update standard cost |
Recovered from the category |
|
|
CUTCSTUPD |
M |
Updated standard cost |
Recovered from the category |
|
|
BUDCSTUPD |
M |
Updated standard budget cost |
Recovered from the category |
|
|
SIMCSTUPD |
M |
Update simulation cost |
Recovered from the category |
|
|
MFGROU |
A |
0/ |
Production range |
|
|
CSTROU |
A |
0/ |
Cost range |
|
|
RCCROU |
A |
0/ |
RCCP range |
|
|
MFGROUALT |
TRO |
0/ |
Alternative |
|
|
CSTROUALT |
TRO |
0/ |
Alternative |
|
|
RCCROUALT |
TRO |
0/ |
Alternative |
|
|
MFGSHTCOD |
M |
1/ |
Launch if shortage |
Recovered from the category |
|
RELSCATIA |
M |
1/ |
Loss at launch |
|
|
MONPROYEA |
C |
0/ |
Last monthly processing |
|
|
MONPROMON |
C |
0/ |
Last monthly processing |
|
|
YEAPROYEA |
C |
0/ |
Last annual processing |
|
|
CLEPCTAUT |
DCB |
0/ |
% automatic balance sheet amount |
Recovered from the category |
|
CFGVCRNUM |
VCR |
0/ |
no. config. document |
|
|
ISM |
A |
0/ |
ISM record |
|
|
WGRACS |
A |
0/ |
Weigh station access |
|
|
REDMODFLG |
M |
Adjustment mode |
|
|
|
VLTCOD |
TCM |
0/ |
Valuation method |
Recovered from the category |
|
PROPER |
RAT |
0/ |
Prorata regul. qty |
|
|
LOCNUM |
M |
Location no. |
|
|
|
DEFLOCTYP |
A |
0/ |
Location/default type |
|
|
DEFLOC |
EMP |
0/ |
Default location |
|
|
WIPPRO |
M |
1/ |
WIP protect. |
|
|
PCK |
PCK |
0/ |
Packaging |
Recovered from the category |
|
PCKCAP |
COE |
0/ |
Packaging capacity |
Recovered from the category |
|
STOMGTCOD |
M |
Stock management |
Recovered from the category |
|
|
PTOCOD |
A |
0/ |
Rule |
Recovered from the category |
|
PCKSTKFLG |
M |
1/ |
Detailed stock |
Recovered from the category |
|
QUAFLG |
M |
Submitted to control |
Recovered from the product |
|
|
QLYCRD |
A |
0/ |
Quality record |
Recovered from the product |
|
QUAACS |
A |
0/ |
Quality operator access |
Recovered from the category |
|
QUAFRY |
L |
0/ |
Frequency |
Recovered from the product |
|
QUANUM |
L |
0/ |
Entry no. |
Recovered from the product |
|
SMPTYP |
M |
Sampling |
Recovered from the product or default value |
|
|
SMPMOD |
M |
Sampling mode |
Recovered from the product or default value |
|
|
GENLEVINS |
M |
General level |
Recovered from the product or default value |
|
|
AQL |
M |
AQL |
Recovered from the product or default value |
|
|
QUAADXUID |
L |
0/ |
Frequency process |
|
|
QUANUMUID |
L |
0/ |
Process entries |
|
|
SHLLTI |
C |
0/ |
New control lead-time |
Recovered from the product |
|
SHLLTIUOM |
M |
New control time Unit |
|
|
|
NEWLTISTA |
A |
0/ |
Recontrol status |
Recovered from the product |
|
DLU |
COE |
0/ |
Coefficient UBD |
Recovered from the product |
|
LTIQLYCRD |
A |
0/ |
New control record |
|
|
EXPNUM |
L |
0/ |
Export no. |
|
|
CREDAT |
D |
0/ |
Creation date |
Date in creation |
|
CREUSR |
A |
0/ |
Creation operator |
GUSER in creation |
|
UPDDAT |
D |
0/ |
Date modification |
Date$ in modification |
|
UPDUSR |
A |
0/ |
Operator modif |
GUSER in modification |
|
STAFED |
ADI |
0/ |
Federal state |
|
Supplier product Table: ITMBPS
|
Field |
Type |
Menu |
Normal title |
Load |
|
ITMREF |
ITM |
0/ |
Product |
Recovered from header |
|
BPSNUM |
BPR |
0/ |
Supplier |
Interface file |
|
PIO |
C |
0/ |
Priority |
Interface file |
|
ITMREFBPS |
A |
0/ |
Supplier product |
Interface file |
|
ITMDESBPS |
DES |
0/ |
Supplier description |
Interface file |
|
EANCODBPS |
A |
0/ |
Supplier EAN code |
|
|
PUU |
UOM |
0/ |
Purchase unit |
|
|
PUUSTUCOE |
COE |
0/ |
SAL-STK coefficient |
|
|
PCU |
UOM |
0/ |
Packing |
|
|
PCUPUUCOE |
COE |
0/ |
PAC-STK coefficient |
|
|
EECINCRAT |
RAT |
0/ |
EU increase |
|
|
PURMINQTY |
QTY |
0/ |
Purchase minimum Qty |
|
|
CPRCOE |
COE |
0/ |
Approach charges coef |
|
|
QLYMRK |
C |
0/ |
Quality rank |
Interface file |
|
DOUFLG |
M |
Blocking |
|
|
|
QUAFLG |
M |
Submitted to control |
Interface file - recovered from the product |
|
|
CTMBPSFLG |
M |
1/ |
Back-to-back order |
|
|
TEX |
TXC |
0/ |
Text |
|
|
CFGVCRNUM |
VCR |
0/ |
no. config. document |
|
|
BOMALT |
TBO |
0/ |
Subcon alt |
|
|
SCOLTI |
C |
0/ |
Subcontract lead-time |
|
|
QLYCRD |
A |
0/ |
Quality record |
Interface file - recovered from the product |
|
QUAFRY |
L |
0/ |
Frequency |
Interface file |
|
QUANUM |
L |
0/ |
Control number |
Interface file |
|
QUAADXUID |
L |
0/ |
Frequency process |
|
|
QUANUMUID |
L |
0/ |
Process entries |
|
|
EXPNUM |
L |
0/ |
Export no. |
|
|
CREUSR |
A |
0/ |
Creation operator |
GUSER in creation |
|
CREDAT |
D |
0/ |
Creation date |
Date in creation |
|
UPDUSR |
A |
0/ |
Operator modif |
GUSER in modification |
|
UPDDAT |
D |
0/ |
Date modification |
Date$ in modification |
Specific points
Category
The category is an essential piece of information in Sage X3. The product category must be loaded in PLM @UDROS with a value that corresponds to a Sage X3 category.
It is possible to extract the list of categories via an export in Sage X3 in order to load a list of values in PLM @UDROS.
Product reference codification
The product reference can be:
- entered in the file and used directly as a reference,
- or determined by a counter on the category.
The references created via a counter are listed in a file generated when starting the interface.
This file, called REFITMxxx.csv, is stored in the Load directory specified in this setup function. It is described below in the Processing result.
The reference of the @UDROS product will be stored in the ITMMASTER products table (PLMITMREF field), allowing the update of the product.
Site
The site does not exist in PLM @UDROS, loading Products - Sites information is then carried out according to the BOM alternative linked with the interface:
- If the code contains a site: a single Product-Site record is created for this site.
- If the code does not contain any site: as many Product - Site records are created as there are existing storage sites.
Notes :
- The creation of these sites is carried out with the default values, the same way as from the Product - Sites creation function.
- If a site is specified in the interface file (STOFCY field), the Product-Site record is:
- created if necessary,
- and/or updated with the other values given in the file.
Suppliers
It is possible to extract the list of suppliers via an export in Sage X3 in order to load a list of values in PLM @UDROS.
Linked documents management
The ITMxxx.csv file can supply an URL for each product to a web page suggesting linked documents as well as an URL for each product to a web page displaying the history.
These URLs will be used to open an Internet browser session of the client workstation from the Products management X3 screens in order to access the documents.
Loading the BOM tables
Several lines from the BOMxxx.csv file (where xxx represents a unique number) corresponds to a BOM. These line will load the tables:
The interface processing (CONNECTBOM connector) that manages the data of these tables can create and update BOMs. The deletion and insertion of new BOMs can be done as follows:
- delete data if the BOM already exists,
- load the screens of the OBODP standard window - in creation mode,
- assign pivot values,
- control the standard and specific screens,
- validate the elements.
The load terms of the BOMs tables, via the interface processing, are given below.
BOMs table - Header: BOM
BOMs table - Detail: BOMD
|
Field |
Type |
Menu |
Normal title |
Load |
|
ITMREF |
ITM |
0/ |
Parent product |
Recovered from header |
|
BOMALT |
C |
0/ |
BOM alternative |
Recovered from header |
|
BOMSEQ |
C |
0/ |
Sequence |
Managed by the system (no 5 that can be set up) |
|
BOMSEQNUM |
C |
0/ |
Sequence addition |
Managed by the system (no 5 that can be set up) |
|
CPNITMREF |
ITM |
0/ |
Component |
Interface File (link ITMMASTER/PLMITMREF) |
|
CPNTYP |
M |
Component type |
Interface file or default value |
|
|
BOMSHO |
SHO |
0/ |
Link description |
Interface file |
|
BOMALTTYP |
M |
Alternative type |
Recovered from header |
|
|
BOMSTRLOT |
LOT |
0/ |
Validity start lot |
Interface file |
|
BOMENDLOT |
LOT |
0/ |
Validity end lot |
Interface file |
|
BOMSTRDAT |
D |
0/ |
Validity start |
Interface file |
|
BOMENDDAT |
D |
0/ |
Validity end |
Interface file |
|
LIKQTYCOD |
M |
Link quantity code |
Interface file or default value |
|
|
QTYRND |
M |
Rounded quantity |
Interface file or default value |
|
|
BOMUOM |
UOM |
0/ |
UOM |
Interface or ITM.STU file |
|
BOMSTUCOE |
COE |
0/ |
UOM/STK factor |
calculated |
|
BOMQTY |
QTY |
0/ |
UOM link quantity |
Interface or calculated file |
|
LIKQTY |
QTY |
0/ |
Link quantity |
Interface file |
|
SCA |
DCB |
0/ |
Scrap percentage |
|
|
CPNOPE |
C |
0/ |
Range operation |
|
|
OPENUMLEV |
C |
0/ |
Suffix range ope |
|
|
BOMOFS |
C |
0/ |
Operation lead time |
|
|
PICPRN |
M |
1/ |
Material note printing |
2 " yes " |
|
OCNPRN |
M |
1/ |
AOR printing |
|
|
NDEPRN |
M |
1/ |
Delivery note printing |
|
|
INVPRN |
M |
1/ |
Print the invoice |
|
|
LIKRLE |
A |
0/ |
Link revision index |
0/ |
|
BOMTEXNUM |
TXC |
0/ |
Link text |
|
|
CSTFLG |
M |
1/ |
Valuation |
2 " yes " |
|
PKC |
M |
Code to use |
Interface file or default value |
|
|
SCOFLG |
M |
Replenishment type |
|
|
|
CREDAT |
D |
0/ |
Creation date |
Date in creation |
|
CREUSR |
A |
0/ |
Creation operator |
GUSER in creation |
|
UPDDAT |
D |
0/ |
Date modification |
Date$ in modification |
|
UPDUSR |
A |
0/ |
Operator modif |
GUSER in modification |
|
EXPNUM |
L |
0/ |
Export no. |
|
Specific points
Linked documents management
The BOMxxx.csv file can supply an URL for each BOM to a web page suggesting linked documents. These URLs will be used to open an Internet browser session of the client workstation from the BOMs management X3 screens in order to access the documents.
BOM codes
Only one BOM code is used by the interface to create the BOMs: the one indicated in the setup.
Multi-level BOMs
For these BOMs, it is necessary that the product BOMxxx.csv file lines are sorted (by Component and Sequence) in order for the shortages to be processed and the number of requested BOMs to be created in the X3.
Example of BOM:
|
CD100 |
|
|
|
Red truck |
1/ |
Un |
|
|
CH005 |
|
|
Mounted chassis |
1/ |
Un |
|
|
|
ES000 |
|
Mounted axle |
15/ |
Un |
|
|
|
|
WHEEL |
Wheel |
150/ |
Un |
|
|
|
P004 |
|
Bumpers |
100/ |
Un |
|
|
|
P005 |
|
Normal headlight |
1/ |
Un |
|
|
M000 |
|
|
Blue engine |
1/ |
Un |
|
|
|
ABS |
|
Plastics |
1.25/ |
Un |
|
|
ABS1 |
|
Plastic |
3/ |
Un |
|
|
|
H000 |
|
|
Blue container |
1/ |
Un |
|
|
P006 |
|
|
Quartz iodine headlight |
2/ |
Un |
|
|
MPEMP |
|
|
MPEMP |
1/ |
Plain |
File sorted by Reference, Component and Sequence, that should be produced by @UDROS: :
CD100;;Red semi trailer truck;;;;;;1;CH005;;Mounted frame;;;;;;;;;1;
CD100;;Red semi trailer truck;;;;;;2;M000;;Blue engine;;;;;;;;;1;
CD100;;Red semi trailer truck;;;;;;3;H000;;Blue container;;;;;;;;;1;
CD100;;Red semi trailer truck;;;;;;4;P006;;Iodine headlight;;;;;;;;;1;
CD100;;Red semi trailer truck;;;;;;5;MPEMP;;MPEMP;;;;;;;;;1;
CH005;;Mounted frame;;;;;;1;ES000;;Mounted axle;;;;;;;;;15;
CH005;;Mounted frame;;;;;;2;P004;;Bumper;;;;;;;;;100;
CH005;;Mounted frame;;;;;;4;P005;;Standard headlight;;;;;;;;;1;
ES000;;Mounted axle;;;;;;1;WHEEL;;wheel;;;;;;;;;150;
M000;;Blue engine;;;;;;1;;ABS;;Plastic;;;;;;;;;1.25;
M000;;Blue engine;;;;;;2;;ABS1;;Plastic;;;;;;;;;3;
Result of the processing
REFITMxxx.csv File
This file, generated at the end of the interface, contains the list of X3 references of the products, determined by a counter on the category.
It is stored in the Load directoryindicated in the PLM setupfunction.
|
Information |
Reference of the corresponding |
Type |
|
Product reference @UDROS |
ITMMASTER/PLMITMREF |
Alphanumerical (70) |
|
X3 Product referenceX |
ITMMASTER/ITMREF |
Alphanumerical (20) |
The products for which a new reference has been assigned are the only one to appear in this file.