This entry point is located in the TRTMIG processing.
It is used by the overall flow migration procedures.
It is used to change the temporary table name as selected for a given table.
This entry point must be defined in the application root folder.
There is no transaction in progress.
There is an open log file.
Upon creating temporary tables, it makes it possible to modify the temporary table name as selected for a table.
Then, it is used by the overall optimized migration flows.
PDOSSIER Identifies the folder where work is to be carried out
PTABLE Provides the original table name
MTABLE Contains the temporary table name as selected for the PTABLE table. This variable should be modified in order to give another name.
The temporary tables are created by adding letter U at the beginning of the table code.
If the initial code of the table has 10 characters, the first letter is deleted before addition of letter U.
For some tables, letter U is also added at the end of the code for uniqueness purposes.
Table | Temporary table | Optimization index |
ITMMASTER | UITMMASTER |
|
ITMFACILIT | UTMFACILIT |
|
GACCDUDATE | UACCDUDATE | ACCNUM+DUDLIG |
ORDERS | UORDERS |
|
BOMD | UBOMD |
|
BOMRET | UBOMRET |
|
ITMBOM | UITMBOM |
|
ITMBOMCFG | UITMBOMCFG |
|
CFGSCE | UCFGSCE |
|
CFGHISHEA | UCFGHISHEA |
|
CBNHEA | UCBNHEA |
|
PDPHEA | UPDPHEA |
|
BPARTNER | UBPARTNER |
|
SALESREP | USALESREP |
|
BPCUSTOMER | UPCUSTOMER | BPCPYR+BPCNUM |
BPDLVCUST | UBPDLVCUST |
|
BPSUPPLIER | UPSUPPLIER |
|
BPCARRIER | UBPCARRIER |
|
GACCENTRY | UGACCENTRY | CPY+TYP+NUM |
GACCENTRYA | UACCENTRYA |
|
GACCENTRYD | UACCENTRYD |
|
GACEIAS | UGACEIAS | CPY+TYP+NUM |
GACEIASD | UGACEIASD |
|
GCOMMIT | UGCOMMIT | CPY+NUM |
GCOMMITD | UGCOMMITD |
|
GENTLOT | UGENTLOT | CPY+LOT |
GENTLOTH | UGENTLOTH |
|
GENTLOTD | UGENTLOTD |
|
GENTLOTA | UGENTLOTA |
|
BUD | UBUD | FCY+BUD+FIY+CNA+CCE1+CCE2+CCE3 |
BUDOD | UBUDOD |
|
BUDODS | UBUDODS | NUM+FCY+LINNUM |
SINVOICE | USINVOICE | CPY+NUM |
PINVOICE | UPINVOICE | CPY+FCY+NUM |
BPCINVLIG | UBPCINVLIG |
|
BPCINVLIGA | UPCINVLIGA |
|
BPSINVLIG | UBPSINVLIG |
|
BPSINVLIGA | UPSINVLIGA |
|
PAYMENTH | UPAYMENTH | CPY+NUM |
PAYMENTD | UPAYMENTD |
|
PAYMENTA | UPAYMENTA |
|
EXPENSES | UEXPENSES | CPY+ACCNUM |
SQUOTE | USQUOTE |
|
SQUOTED | USQUOTED | SALFCY+SQHNUM+SQDLIN |
SORDER | USORDER | SOHCAT+SALFCY+SOHNUM |
SORDERP | USORDERP | SOHCAT+SALFCY+SOHNUM+SOPLIN+SOPSEQ |
SORDERQ | USORDERQ |
|
SORDERC | USORDERC |
|
VSORDER | UVSORDER | SOHCAT+SALFCY+SOHNUM+REVNUM |
VSORDERP | UVSORDERP |
|
VSORDERQ | UVSORDERQ |
|
VSORDERC | UVSORDERC |
|
SDELIVERY | USDELIVERY |
|
SDELIVERYD | UDELIVERYD | STOFCY+SDHNUM+SDDLIN |
SRETURN | USRETURN | STOFCY+SRHNUM |
SRETURND | USRETURND |
|
SINVOICEV | USINVOICEV | SALFCY+NUM |
SINVOICED | USINVOICED |
|
BPCUSTMVT | UBPCUSTMVT |
|
PREQUIS | UPREQUIS | PSHFCY+PSHNUM |
PREQUISD | UPREQUISD |
|
PORDER | UPORDERU | POHTYP+POHFCY+POHNUM |
PORDERP | UPORDERPU | POHNUM+POPLIN+POPDAT+POPSEQ |
PORDERQ | UPORDERQU |
|
PORDERC | UPORDERCU |
|
UPORDER | UUPORDERU | POHTYP+POHFCY+POHNUM+REVNUM |
UPORDERP | UUPORDERPU | POHNUM+LINREVNUM+POPLIN+POPDAT+POPSEQ |
UPORDERQ | UUPORDERQU |
|
UPORDERC | UUPORDERCU |
|
PRECEIPT | UPRECEIPT | PRHFCY+PTHNUM |
PRECEIPTD | UPRECEIPTD |
|
PRETURN | UPRETURN | PNHFCY+PNHNUM |
PRETURND | UPRETURND |
|
PINVOICEV | UPINVOICEV |
|
PINVOICED | UPINVOICED |
|
BPSUPPMVT | UBPSUPPMVT |
|
PAPPCONF | UPAPPCONF | APPRUL+CPY |
PAPPRECORD | UAPPRECORD |
|
PAPPROVAL | UPAPPROVAL |
|
STOJOU | USTOJOU | STOFCY+ITMREF+IPTDAT+UPDCOD+MVTSEQ+MVTIND |
ITMCOST | UITMCOST |
|
ITCNAT | UITCNAT |
|
ITMMVT | UITMMVT |
|
STOCOST | USTOCOST |
|
MFGWIP | UMFGWIP |
|
WIPCOST | UWIPCOST |
|
MFGCOST | UMFGCOST |
|
MFCNAT | UMFCNAT |
|
MFGHEAD | UMFGHEAD | MFGFCY+MFGNUM |
MFGITM | UMFGITM | MFGFCY+MFGNUM+MFGLIN |
MFGMAT | UMFGMAT | MFGFCY+MFGNUM+MFGLIN+BOMSEQ+ITMREF |
MFGOPE | UMFGOPE | MFGFCY+MFGNUM+OPENUM+OPESPLNUM |
MFGHEADTRK | UFGHEADTRK | MFGFCY+MFGTRKNUM |
MFGITMTRK | UMFGITMTRK | MFGFCY+MFGTRKNUM+ITMTRKLIN |
MFGMATTRK | UMFGMATTRK | MFGFCY+MFGTRKNUM+MATTRKLIN |
MFGOPETRK | UMFGOPETRK | MFGFCY+MFGTRKNUM+OPETRKLIN |
PAYLOT | UPAYLOT |
|
SERREQUEST | USERREQUEST | [F :SREM] |
CONTSERV | UCONTSERV | [F :CONM] |
This entry point is located in the TRTMIG processing.
It is used by the overall flow migration procedures.
It makes it possible to change the selected abbreviation for a given temporary table.
This entry point must be defined in the application root folder.
There is no transaction in progress.
There is an open log file.
Upon creating temporary tables, it makes it possible to modify the abbreviation as selected for a temporary table.
Then, it is used by the overall optimized migration flows.
PDOSSIER Identifies the folder where work is to be carried out
PTABLE Provides the original table name
MTABLE Gives the temporary table name
MABR Contains the abbreviation as selected for MTABLE temporary table. This variable should be modified in order to provide another abbreviation.
This entry point is located in the TRTMIG processing.
It is used by the overall flow migration procedures.
It is used to add
- a global selection clause to filter the records read by the migration flow,
- a HINT to be used on the query for record reading.
This entry point must be defined in the application root folder.
There is no transaction in progress.
There is an open log file.
FLUX Identifies the flow that calls the EP (see the code list above)
FILTRELIN Value 1 indicates that there will be a filter in the loop via the VERIFSEL entry point.
CRITERESPE Clause Where to be added to the related query.Depending on the flow type, the clause may use the abbreviation on the file mentioned in the above table.
HINTSPE Key to be used to position a Hint on the query.
List of the concerned X3 migration procedures and abbreviations to use for the Where clause:
Module | FLOW | Description | Abbreviation |
Common data | UUMGTRTTRC01 | Products | ITMM |
| UUMGTRTTRC02 | Product-sites | ITFM |
| UUMGTRTTRC03 | A/P - A/R Accounting | BPRM |
| UUMGTRTTRC04 | Open items | DUDM |
| UUMGTRTTRC06 | Sales reps | REPM |
| UUMGTRTTRC07 | Customers | BPCM |
| UUMGTRTTRC08 | Suppliers | BPSM |
| UUMGTRTTRC09 | Carriers | BPTM |
| UUMGTRTTRC10 | On-hand orders | ORDM |
| UUMGTRTTRC11 | BOM (detail) | BODM |
| UUMGTRTTRC12 | MRP results | CBHM |
| UUMGTRTTRC13 | MDS results | PDHM |
| UUMGTRTTRC14 | Products - BOMs | ITBM |
| UUMGTRTTRC15 | Component requirements | BMRM |
| UUMGTRTTRC16 | Products - BOMs (Configurator) | CFBM |
| UUMGTRTTRC17 | Scenario (Configurator) | CSCM |
| UUMGTRTTRC18 | Configuration history header (Configurator) | CHHM |
Accounting | UUMGTRTCPT01 | General accounting entry | HAEM |
| UUMGTRTCPT02 | IAS accounting entry | HIAM |
| UUMGTRTCPT03 | Commitments | CMMM |
| UUMGTRTCPT04 | Batch of entries | LOTM |
| UUMGTRTCPT05 | Budget | BUDM |
| UUMGTRTCPT06 | Budget MO | BDEM |
| UUMGTRTCPT51 | General balance resync | Particular case: filter only on the COMPANY table, CPY9 abbreviation |
| UUMGTRTCPT52 | Dimension balance resync | Particular case: filter only on the COMPANY table, CPY9 abbreviation |
| UUMGTRTCPT53 | Commitment balance resync | Particular case: filter only on the COMPANY table, CPY9 abbreviation |
| UUMGTRTCPT54 | Quantity balance resync | Particular case: filter only on the COMPANY table, CPY9 abbreviation |
A/P-A/R accounting | UUMGTRTTRS01 | Customer BP invoices | SIHM |
| UUMGTRTTRS02 | Supplier BP invoices | PIHM |
| UUMGTRTTRS03 | Payments | PYHM |
| UUMGTRTTRS04 | Expense notes | EXSM |
| UUMGTRTTRS05 | Lot entry | PYLM |
Sales | UUMGTRTSAL01 | Quotation | SQHM Specific case: The VALORISATION variable can be set to 0 in this entry point in order to skip the valuation of quotes at this step. In this case, it will be necessary to launch UUMGPOSSAL01 to perform the valuation of quotes after the migration. |
| UUMGTRTSAL02 | Normal orders | SOHM |
| UUMGTRTSAL03 | Contract orders | SOHM |
| UUMGTRTSAL04 | Normal orders hist. | VOHM |
| UUMGTRTSAL05 | Open orders hist. | VOHM |
| UUMGTRTSAL06 | Deliveries | SDHM |
| UUMGTRTSAL07 | Returns | SRHM |
| UUMGTRTSAL08 | Invoices | SIHM |
| UUMGTRTSAL51 | Customer transactions | MVCM |
Purchase | UUMGTRTPUR01 | Purchase request | PSHM |
| UUMGTRTPUR02 | Normal orders | POHM |
| UUMGTRTPUR03 | Contract orders | POHM |
| UUMGTRTPUR04 | Normal orders hist. | UOHM |
| UUMGTRTPUR05 | Open orders hist. | UOHM |
| UUMGTRTPUR06 | Receipts | PTHM |
| UUMGTRTPUR07 | Returns | PNHM |
| UUMGTRTPUR08 | Invoices/Credit memos | PIHM |
| UUMGTRTPUR41 | Signatures/Assignment rules | PACM |
| UUMGTRTPUR42 | Signatures/User assignment | PACM |
| UUMGTRTPUR43 | Signatures/Workflow tracking history | PADM |
| UUMGTRTPUR44 | Signatures/Screen and window deletion | PACM |
| UUMGTRTPUR51 | Supplier transactions | MVSM |
Stocks | UUMGTRTSTO01 | Stock journal | STJM |
| UUMGTRTSTO02 | Product-costs | ITCM Specific case: The LICAFLT variable can be set to 0 in this entry point to avoid deleting the duplicated revised standard costs. |
| UUMGTRTSTO03 | Product-site totals + Stock FIFO cost | ITVM |
Manufacturing | UUMGTRTGPA01 | Production WIP | MWHM |
| UUMGTRTGPA02 | Production cost | MFCM |
| UUMGTRTGPA03 | WO | MFGM |
| UUMGTRTGPA04 | WO trackings | MTKM |
List of the concerned post-migration procedures and abbreviations to use:
Module | FLOW | Description | Abbreviation |
Accounting | UUMGPOSCPT51 | General balance resync | Particular case: filter only on the COMPANY table, CPY9 abbreviation |
| UUMGPOSCPT52 | Dimension balance resync | Particular case: filter only on the COMPANY table, CPY9 abbreviation |
| UUMGPOSCPT53 | Commitment balance resync | Particular case: filter only on the COMPANY table, CPY9 abbreviation |
| UUMGPOSCPT54 | Quantity balance resync | Particular case: filter only on the COMPANY table, CPY9 abbreviation |
Sales | UUMGPOSSAL01 | Quotation | SQH |
This entry point is located in the TRTMIG processing.
It is used by the overall flow migration procedures.
It is used to create a filter on the records in the loop, after reading.
This entry point must be defined in the application root folder.
There is one transaction in progress.
There is an open log file.
The F class corresponding to the flow (above code list) is loaded.
FLUX Identifies the flow that calls the EP (see the code list above)
ISVALID Set to value 0 so that the record read should not be processed by the migration procedure.
[F:ADS]DOSSIER contains the folder where work is carried out
This entry point will not be called unless variable FILTRELIN is positioned to 1, for the flow, in the CRITSEL entry point
List of the concerned migration procedures and abbreviations to use:
Module | FLOW | Description | Abbreviation |
Common data | UUMGTRTTRC01 | Products | ITMM |
| UUMGTRTTRC02 | Product-sites | ITFM |
| UUMGTRTTRC03 | A/P - A/R Accounting | BPRM |
| UUMGTRTTRC04 | Open items | DUDM |
| UUMGTRTTRC06 | Sales reps | REPM |
| UUMGTRTTRC07 | Customers | BPCM |
| UUMGTRTTRC08 | Suppliers | BPSM |
| UUMGTRTTRC09 | Carriers | BPTM |
| UUMGTRTTRC10 | On-hand orders | ORDM |
| UUMGTRTTRC11 | BOM (detail) | BODM |
| UUMGTRTTRC12 | MRP results | CBHM |
| UUMGTRTTRC13 | MDS results | PDHM |
| UUMGTRTTRC14 | Products - BOMs | ITBM |
| UUMGTRTTRC15 | Component requirements | BMRM |
| UUMGTRTTRC16 | Products - BOMs (Configurator) | CFBM |
| UUMGTRTTRC17 | Scenario (Configurator) | CSCM |
| UUMGTRTTRC18 | Configuration history header (Configurator) | CHHM |
Accounting | UUMGTRTCPT01 | General accounting entry | HAEM |
| UUMGTRTCPT02 | IAS accounting entry | HIAM |
| UUMGTRTCPT03 | Commitments | CMMM |
| UUMGTRTCPT04 | Batch of entries | LOTM |
| UUMGTRTCPT05 | Budget | BUDM |
| UUMGTRTCPT06 | Budget MO | BDEM |
A/P-A/R accounting | UUMGTRTTRS01 | Customer BP invoices | SIHM |
| UUMGTRTTRS02 | Supplier BP invoices | PIHM |
| UUMGTRTTRS03 | Payments | PYHM |
| UUMGTRTTRS04 | Expense notes | EXSM |
| UUMGTRTTRS05 | Batch input | PYLM |
Sales | UUMGTRTSAL01 | Quotation | SQHM |
| UUMGTRTSAL02 | Normal orders | SOHM |
| UUMGTRTSAL03 | Contract orders | SOHM |
| UUMGTRTSAL04 | Normal orders hist. | VOHM |
| UUMGTRTSAL05 | Open orders hist. | VOHM |
| UUMGTRTSAL06 | Deliveries | SDHM |
| UUMGTRTSAL07 | Returns | SRHM |
| UUMGTRTSAL08 | Invoices | SIHM |
| UUMGTRTSAL51 | Customer transactions | MVCM |
Purchase | UUMGTRTPUR01 | Purchase request | PSHM |
| UUMGTRTPUR02 | Normal orders | POHM |
| UUMGTRTPUR03 | Contract orders | POHM |
| UUMGTRTPUR04 | Normal orders hist. | UOHM |
| UUMGTRTPUR05 | Open orders hist. | UOHM |
| UUMGTRTPUR06 | Receipts | PTHM |
| UUMGTRTPUR07 | Returns | PNHM |
| UUMGTRTPUR08 | Invoices/Credit memos | PIHM |
| UUMGTRTPUR41 | Signatures/Assignment rules | PACM |
| UUMGTRTPUR42 | Signatures/User assignment | PACM |
| UUMGTRTPUR43 | Signatures/Workflow tracking history | PADM |
| UUMGTRTPUR44 | Signatures/Screen and window deletion | PACM |
| UUMGTRTPUR51 | Supplier transactions | MVSM |
Stocks | UUMGTRTSTO01 | Stock journal | STJM |
| UUMGTRTSTO02 | Product-costs | ITCM |
| UUMGTRTSTO03 | Product-site totals + Stock FIFO cost | ITVM |
Manufacturing | UUMGTRTGPA01 | Production WIP | MWHM |
| UUMGTRTGPA02 | Production cost | MFCM |
| UUMGTRTGPA03 | WO | MFGM |
| UUMGTRTGPA04 | WO trackings | MTKM |
List of the concerned post-migration procedures and abbreviations to use:
Module | FLOW | Description | Abbreviation |
Sales | UUMGPOSSAL01 | Quotation | SQH |
