Histórico da Página
PCP PPIMulti Task Integration
Requirement Features
Product Group: | Protheus | ||||||||||
Industry: | Manufacture | ||||||||||
Module: | SIGAPCP | ||||||||||
Routine: |
| ||||||||||
Initial Registration: | . | ||||||||||
Parameter(s): |
| ||||||||||
Entry Point: | MATI681CRG_Add_information_Adapter_of_annotation MTI650ADOP_Add_new_operation_adapter_production_order MTI650FCOP_Change_conversion_factor_second_unit_of_operation_measure_adapter_production_order MTI650QTOP_Change_quantity_of_operation_adapter_production_order MTI650UMOP_Change_second_unit_of_measure_of_operation_adapter_productionn_order PCPXFUNPPI_Routines_not_executing_integration_with_the_PC_Factory MT680VAL - Addition of Productions
| ||||||||||
Related tickets |
| ||||||||||
Requirement (ISSUE): | PCREQ-6129; PCREQ-6130;PCREQ-6131;PCREQ-6132;PCREQ-6133;PCREQ-6657;PCREQ-7024 | ||||||||||
Country(ies): | All | ||||||||||
Database: | All | ||||||||||
Tables: | SOF SOE SOD SOG | ||||||||||
Operational system(s): | Windows®/Linux® | ||||||||||
Versions/Release: | 12.1.10 and 11.80.14 |
...
- SOD Table - Parameters of integration
Field | OD_FILIAL |
Type | Character |
Size | 2 |
Decimal | 0 |
Format |
|
Title | Branch |
Description | Branch |
Level | 1 |
Used | No |
Required | No |
Browse | No |
Options |
|
When |
|
Relationship |
|
Val. System |
|
Help | Branch Code |
Field | OD_ATIVO |
Type | Character |
Size | 1 |
Decimal | 0 |
Format |
|
Title | Active |
Description | Active |
Level | 1 |
Used | Yes |
Required | No |
Browse | Yes |
Options |
|
When |
|
Relationship | "N" |
Val. System |
|
Help | Indicates whether integration is active. |
Field | OD_CAMINHO |
Type | Character |
Size | 100 |
Decimal | 0 |
Format |
|
Title | Path |
Description | Path |
Level | 1 |
Used | Yes |
Required | No |
Browse | Yes |
Options |
|
When |
|
Relationship |
|
Val. System |
|
Help | Indicates the patch of WebService from PC-Factory |
Field | OD_GERAXML |
Type | Character |
Size | 1 |
Decimal | 0 |
Format |
|
Title | Generates XML |
Description | Generates XML |
Level | 1 |
Used | Yes |
Required | No |
Browse | Yes |
Options |
|
When |
|
Relationship |
|
Val. System |
|
Help | Indicates whether files XML |
Field | OD_DIRENV |
Type | Character |
Size | 100 |
Decimal | 0 |
Format |
|
Title | Sent |
Description | Sent |
Level | 1 |
Used | Yes |
Required | No |
Browse | Yes |
Options |
|
When |
|
Relationship |
|
Val. System |
|
Help | Indicates whether the directory to register the XML files sent. |
Field | OD_DIRPEND |
Type | Character |
Size | 100 |
Decimal | 0 |
Format |
|
Title | Pendency |
Description | Pendency |
Level | 1 |
Used | Yes |
Required | No |
Browse | Yes |
Options |
|
When |
|
Relationship |
|
Val. System |
|
Help | Indicates the directory to register XML files with error or delivery pendency. |
...
- SOD Table - Parameters of integration
Field | OE_FILIAL |
Type | Character |
Size | 2 |
Decimal | 0 |
Format |
|
Title | Branch |
Description | Branch |
Level | 1 |
Used | No |
Required | No |
Browse | No |
Options |
|
When |
|
Relationship |
|
Val. System |
|
Help | Branch Code |
Field | OE_TABELA |
Type | Character |
Size | 10 |
Decimal | 0 |
Format |
|
Title | Table |
Description | Table |
Level | 1 |
Used | Yes |
Required | No |
Browse | Yes |
Options |
|
When |
|
Relationship |
|
Val. System |
|
Help | Indicates the name of the table |
Field | OE_FILTRO |
Type | Memo |
Size | 10 |
Decimal | 0 |
Format |
|
Title | Filter |
Description | Filter |
Level | 1 |
Used | Yes |
Required | No |
Browse | Yes |
Options |
|
When |
|
Relationship |
|
Val. System |
|
Help | Used to filter records of table |
...
- SOF Table - Protheus-PCFactory Integration
Field | OF_FILIAL |
Type | Character |
Size | 2 |
Decimal | 0 |
Format | @! |
Title | Branch |
Description | System Branch |
Level | 1 |
Used | No |
Required | No |
Browse | No |
Options |
|
When |
|
Relationship |
|
Val. System |
|
Help | Indicates the system branch to which the record belongs to. |
Field | OF_TRANSAC |
Type | Character |
Size | 10 |
Decimal | 0 |
Format | @! |
Title | Table |
Description | Table name |
Level | 1 |
Used | Yes |
Required | Yes |
Browse | Yes |
Options |
|
When |
|
Relationship |
|
Val. System |
|
Help | Table name that is sent to PC-Factory. |
Field | OF_REGIST |
Type | Character |
Size | 50 |
Decimal | 0 |
Format | @! |
Title | Record |
Description | Record Code |
Level | 1 |
Used | Yes |
Required | Yes |
Browse | Yes |
Options |
|
When |
|
Relationship |
|
Val. System |
|
Help | Record code being sent. |
Field | OF_STATUS |
Type | Character |
Size | 1 |
Decimal | 0 |
Format | @! |
Title | Status |
Description | Status |
Level | 1 |
Used | Yes |
Required | Yes |
Browse | Yes |
Options | 1=Ok;2=Pending;3=Error |
When |
|
Relationship | "1" |
Val. System | Belong("123") |
Help | Delivery Status 1 - OK; 2 - Pending; 3 - Error. |
Field | OF_GERAXML |
Type | Character |
Size | 1 |
Decimal | 0 |
Format | @! |
Title | Generate XML |
Description | Generate XML |
Level | 1 |
Used | Yes |
Required | No |
Browse | Yes |
Options | 1=Yes;2=No |
When |
|
Relationship |
|
Val. System | Belong("12") |
Help | Indicates whether Generate XML. 1 - Yes; 2 - No. |
Field | OF_NOMEXML |
Type | Character |
Size | 100 |
Decimal | 0 |
Format |
|
Title | Name XML |
Description | XML File Name |
Level | 1 |
Used | Yes |
Required | No |
Browse | Yes |
Options |
|
When |
|
Relationship |
|
Val. System |
|
Help | XML generate file name |
Field | OF_DTENVIO |
Type | Date |
Size | 8 |
Decimal | 0 |
Format |
|
Title | Delivery Date |
Description | XML delivery date |
Level | 1 |
Used | Yes |
Required | Yes |
Browse | Yes |
Options |
|
When |
|
Relationship |
|
Val. System |
|
Help | Delivery date of XML to PCFactory. |
Field | OF_HRENVIO |
Type | Character |
Size | 8 |
Decimal | 0 |
Format |
|
Title | Delivery time |
Description | XML delivery time |
Level | 1 |
Used | Yes |
Required | Yes |
Browse | Yes |
Options |
|
When |
|
Relationship |
|
Val. System |
|
Help | Delivery date of XML to PCFactory. HH:MM:SS |
Field | OF_USU |
Type | Character |
Size | 25 |
Decimal | 0 |
Format |
|
Title | User |
Description | User |
Level | 1 |
Used | Yes |
Required | No |
Browse | No |
Options |
|
When |
|
Relationship |
|
Val. System |
|
Help | User sending XML to PCFactory. |
Field | OF_MSGRET |
Type | Memo |
Size | 255 |
Decimal | 0 |
Format |
|
Title | Return Msg |
Description | Return message |
Level | 1 |
Used | Yes |
Required | No |
Browse | No |
Options |
|
When |
|
Relationship |
|
Val. System |
|
Help | Return message to PCFactory. |
Field | OF_XML |
Type | Memo |
Size | 255 |
Decimal | 0 |
Format |
|
Title | Content |
Description | XML Content |
Level | 1 |
Used | Yes |
Required | No |
Browse | No |
Options |
|
When |
|
Relationship |
|
Val. System |
|
Help | XML generated content. |
Field | OF_DATPROC |
Type | Date |
Size | 8 |
Decimal | 0 |
Format |
|
Title | Dt. Reproces |
Description | Reprocessing date |
Level | 1 |
Used | Yes |
Required | No |
Browse | Yes |
Options |
|
When |
|
Relationship |
|
Val. System |
|
Help | Indicates the date the reprocessing of XML was executed through the program PCPA 110 - Pendencies. |
Field | OF_HORPROC |
Type | Character |
Size | 8 |
Decimal | 0 |
Format |
|
Title | HR Reproces |
Description | Reprocessing Time |
Level | 1 |
Used | Yes |
Required | No |
Browse | Yes |
Options |
|
When |
|
Relationship |
|
Val. System |
|
Help | Indicates the schedule the reprocessing of XML was executed through the program PCPA 110 - Pendencies. |
Field | OF_PROGRAM |
Type | Character |
Size | 10 |
Decimal | 0 |
Format | @! |
Title | Program |
Description | Generator program |
Level | 1 |
Used | Yes |
Required | No |
Browse | Yes |
Options |
|
When |
|
Relationship |
|
Val. System |
|
Help | Indicates the program generated XML file. |
- SOG Table - Import Log
Field | OG_FILIAL |
Type | Character |
Size | 02 |
Decimal | 0 |
Format | @! |
Title | Branch |
Description | Branch |
Level | 1 |
Used | Yes |
Required | Yes |
Browse | Yes |
Options |
|
When |
|
Relationship |
|
Val. System |
|
Help | Branch |
Field | OG_TRANSAC |
Type | Character |
Size | 10 |
Decimal | 0 |
Format | @! |
Title | Transaction |
Description | Transaction |
Level | 1 |
Used | Yes |
Required | Yes |
Browse | Yes |
Options |
|
When |
|
Relationship |
|
Val. System |
|
Help | Indicates the record source transaction |
Field | OG_OP |
Type | Character |
Size | 13 |
Decimal | 0 |
Format | @! |
Title | Production order |
Description | Production order |
Level | 1 |
Used | Yes |
Required | No |
Browse | Yes |
Options |
|
When |
|
Relationship |
|
Val. System |
|
Help | Indicates the production order. |
Field | OG_PRODUTO |
Type | Character |
Size | 15 |
Decimal | 0 |
Format | @! |
Title | Product |
Description | Product |
Level | 1 |
Used | Yes |
Required | No |
Browse | Yes |
Options |
|
When |
|
Relationship |
|
Val. System |
|
Help | Indicates the product code. |
Field | OG_RECURSO |
Type | Character |
Size | 06 |
Decimal | 0 |
Format | @! |
Title | Resource |
Description | Resource |
Level | 1 |
Used | Yes |
Required | Yes |
Browse | Yes |
Options |
|
When |
|
Relationship |
|
Val. System |
|
Help | Indicates the resource code. |
Field | OG_STATUS |
Type | Character |
Size | 01 |
Decimal | 0 |
Format | @! |
Title | Status |
Description | Status |
Level | 1 |
Used | Yes |
Required | Yes |
Browse | Yes |
Options |
|
When |
|
Relationship |
|
Val. System |
|
Help | Indicates whether annotation was successfully processed. Status: 1 = OK; 2 = Error. |
Field | OG_DATA |
Type | Date |
Size | 8 |
Decimal | 0 |
Format |
|
Title | Processing date |
Description | Processing date |
Level | 1 |
Used | Yes |
Required | Yes |
Browse | Yes |
Options |
|
When |
|
Relationship |
|
Val. System |
|
Help | Annotation processing date. |
Field | OG_HORA |
Type | Character |
Size | 8 |
Decimal | 0 |
Format |
|
Title | Processing Time |
Description | Processing Time |
Level | 1 |
Used | Yes |
Required | Yes |
Browse | Yes |
Options |
|
When |
|
Relationship |
|
Val. System |
|
Help | Annotation processing time. |
Field | OG_DTAPONT |
Type | Date |
Size | 8 |
Decimal | 0 |
Format |
|
Title | Annotation Start Date |
Description | Annotation Start Date |
Level | 1 |
Used | Yes |
Required | No |
Browse | Yes |
Options |
|
When |
|
Relationship |
|
Val. System |
|
Help | Annotation Start Date |
Field | OG_HRAPONT |
Type | Character |
Size | 8 |
Decimal | 0 |
Format |
|
Title | Annotation Start Time |
Description | Annotation Start Time |
Level | 1 |
Used | Yes |
Required | No |
Browse | Yes |
Options |
|
When |
|
Relationship |
|
Val. System |
|
Help | Annotation Start Time |
Field | OG_DTFIMAP |
Type | Date |
Size | 8 |
Decimal | 0 |
Format |
|
Title | Annotation End Date |
Description | Annotation End Date |
Level | 1 |
Used | Yes |
Required | No |
Browse | Yes |
Options |
|
When |
|
Relationship |
|
Val. System |
|
Help | Annotation End Date |
Field | OG_HRFIMAP |
Type | Character |
Size | 8 |
Decimal | 0 |
Format |
|
Title | Annotation End Time |
Description | Annotation End Time |
Level | 1 |
Used | Yes |
Required | No |
Browse | Yes |
Options |
|
When |
|
Relationship |
|
Val. System |
|
Help | Annotation End Time |
Field | OG_ESTORNO |
Type | Character |
Size | 01 |
Decimal | 0 |
Format |
|
Title | Reversal |
Description | Reversal |
Level | 1 |
Used | Yes |
Required | No |
Browse | Yes |
Options |
|
When |
|
Relationship |
|
Val. System |
|
Help | Indicates whether it is reverse record 1=YES;2=No
|
Field | OG_OPERAC |
Type | Character |
Size | 02 |
Decimal | 0 |
Format |
|
Title | Operation |
Description | Operation |
Level | 1 |
Used | Yes |
Required | No |
Browse | Yes |
Options |
|
When |
|
Relationship |
|
Val. System |
|
Help | Indicates the operation code |
Field | OG_QUANTID |
Type | Numeric |
Size | 11 |
Decimal | 2 |
Format |
|
Title | Quantity |
Description | Quantity |
Level | 1 |
Used | Yes |
Required | No |
Browse | Yes |
Options |
|
When |
|
Relationship |
|
Val. System |
|
Help | Annotation Quantity |
Field | OG_SEQ |
Type | Numeric |
Size | 10 |
Decimal | 0 |
Format |
|
Title | Sequence |
Description | Sequence |
Level | 1 |
Used | Yes |
Required | Yes |
Browse | Yes |
Options |
|
When |
|
Relationship |
|
Val. System |
|
Help | Record sequence |
Field | OG_XML |
Type | Memo |
Size |
|
Decimal |
|
Format |
|
Title | XML |
Description | Annotation XML |
Level | 1 |
Used | Yes |
Required | Yes |
Browse | Yes |
Options |
|
When |
|
Relationship |
|
Val. System |
|
Help | Annotation XML |
Field | OG_MSGRET |
Type | Memo |
Size |
|
Decimal |
|
Format |
|
Title | Message |
Description | Return Message |
Level | 1 |
Used | Yes |
Required | Yes |
Browse | Yes |
Options |
|
When |
|
Relationship |
|
Val. System |
|
Help | Return Message |
Important:
...
3. Creation of Indexes to file SIX – Indexes:
Index | SOD |
Order | 1 |
Key | OD_FILIAL+OD_ATIVO+OD_CAMINHO |
Description | Branch + Active + Path |
Owner | S |
Index | SOE |
Order | 1 |
Key | OE_FILIAL+OE_TABELA |
Description | Branch + Table |
Owner | S |
Index | SOF |
Order | 1 |
Key | OF_FILIAL+OF_TRANSAC+OF_REGIST+OF_STATUS+DTOS(OF_DTENVIO)+OF_HRENVIO |
Description | Branch+Table+Record+Status+Delivery date+Delivery Time |
Owner | S |
Index | SOG |
Order | 1 |
Key | OG_FILIAL+OG_TRANSAC+OG_RECURSO+OG_OP+OG_PRODUTO+OG_STATUS+DTOS(OG_DATA)+OG_HORA |
Description | Transaction + Resource + Production Order + Product + Status + Processing Date + Processing Time |
Owner | S |
Index | SOG |
Order | 2 |
Key | OG_FILIAL+OG_TRANSAC+OG_OP+OG_STATUS+DTOS(OG_DATA)+OG_HORA |
Description | Transaction + Production Order + Status + Processing Date + Processing Time |
Owner | S |
Index | SOG |
Order | 3 |
Key | OG_FILIAL+OG_TRANSAC+OG_RECURSO+OG_STATUS+DTOS(OG_DATA)+OG_HORA |
Description | Transaction + Resource + Status + Processing Date + Processing Time |
Owner | S |
Index | SOG |
Order | 4 |
Key | OG_FILIAL+OG_TRANSAC+OG_PRODUTO+OG_STATUS+DTOS(OG_DATA)+OG_HORA |
Description | Transaction + Production + Status + Processing Date + Processing Time |
Owner | S |
OG_ESTORNO
Procedure for Configuration
...
1. In Configurator (SIGACFG), access Environments/Register/Menu (CFGX013). Enter new option of menu fro SIGAPCP, according to instruction as follows:
Menu | Updates |
Submenu | MES Integration |
Routine Name | Parameters |
Program | PCPA109 |
Module | Production Contr Plan |
Type | Protheus Function |
Menu | Updates |
Submenu | MES Integration |
Routine Name | Pendencies |
Program | PCPA110 |
Module | Production Contr Plan |
Type | Protheus Function |
Menu | Updates |
Submenu | MES Integration |
Routine Name | Synchronization |
Program | PCPA111 |
Module | Production Contr Plan |
Type | Protheus Function |
Menu | Updates |
Submenu | MES Integration |
Routine Name | Import Log |
Program | PCPA112 |
Module | Production Contr Plan |
Type | Protheus Function |
Procedure for Use
...
Import HTML Content
Visão Geral
Conteúdo das Ferramentas