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 MATI681EXC_Processes_Annotation_Message
| ||||||||||
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 |
...
1. Creation of table in file SX2– Tables:
Key | Name | Mode | PYME |
SOD | Parameter of integration - Ger | E | S |
SOE | Parameters of integration | E | S |
SOF | Protheus-PCFactory Integration | E | S |
SOG | Import Log | E | S |
2. Creation of Fields in the file SX3 – Fields:
- 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 |
| |
System Val | . System
| |
Help | Branch Code | |
Field | OD_ATIVO | |
Type | Character | |
Size | 1 | |
Decimal | 0 | |
Format |
| |
Title | Active | |
Description | Active | |
Level | 1 | |
Used | Yes | |
| Required Mandatory | No Browse | |
Browser | Yes | |
Options |
| |
When |
| |
Relationship | "N" | |
System Val. | System
| |
Help | Indicates whetherif 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 | 1100 |
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 XMLif XML files are generated |
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 the XML files with error errors or that has pending 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_ | TABELATABLE |
Type | Character | |
Size | 102 | |
Decimal | 0 | |
Format |
| |
Title | Table | |
Description | Table | |
Level | 1 | |
Used | Yes | |
Required | No | |
Browse | Yes | |
Options |
| |
When |
| |
Relationship |
| |
Val. System |
| |
Help | Indicates the table 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 | nameName |
Level | 1 | |
Used | Yes | |
Required | Yes | |
Browse | Yes | |
Options |
| |
When |
| |
Relationship |
| |
Val. System |
| |
HelpTable name that is | Name of table being 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 Error |
When |
|
Relationship | "1" |
Val. System | BelongBelong("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 | File name XML | File Name|
Level | 1 | |
Used | Yes | |
Required | No | |
Browse | Yes | |
Options |
| |
When |
| |
Relationship |
| |
Val. System |
| |
Help | Name of XML generate file namegenerated |
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 timeDate | |
Description | XML delivery | timedate |
Level | 1 | |
Used | Yes | |
Required | Yes | |
Browse | Yes | |
Options |
| |
When |
| |
Relationship |
| |
Val. System |
| |
Help | Delivery date time 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 | Msg Return Msg | |
Description | Return | messageMessage |
Level | 1 | |
Used | Yes | |
Required | No | |
Browse | No | |
Options |
| |
When |
| |
Relationship |
| |
Val. System |
| |
Help | Return message to Message of 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_ | DATPROCXML |
Type | DateMemo | |
Size | 8255 | |
Decimal | 0 | |
Format |
| |
Title | Dt. ReprocesContent | |
Description | Reprocessing dateXML Content | |
Level | 1 | |
Used | Yes | |
Required | No | |
Browse | YesNo | |
Options |
| |
When |
| |
Relationship |
| |
Val. System |
| |
Help | Indicates the date the reprocessing of XML was executed through the program PCPA 110 - Pendencies. | XML generated content. |
Field | OF_ | HORPROCDATPROC |
Type | CharacterData | |
Size | 8 | |
Decimal | 0 | |
Format |
| |
Title | HR Reproces Dt | |
Description | Reprocessing | TimeDate |
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 | |
Field | OF_ | PROGRAMHORPROC |
Type | Character | |
Size | 108 | |
Decimal | 0 | |
Format | @!
| |
TitleProgram | Reproces Time | |
Description | Generator programReprocessing Time | |
Level | 1 | |
Used | Yes | |
Required | No | |
Browse | Yes | |
Options |
| |
When |
| |
Relationship |
| |
Val. System |
| |
Help | Indicates the schedule the program generated XML file. |
- SOG Table - Import Log
reprocessing of XML was executed through the program PCPA 110 - Pendencies. |
Field | OF_PROGRAM | Field | OG_FILIAL|
Type | Character | ||
Size | 028 | ||
Decimal | 0 | ||
Format | @@! | ||
Title | BranchProgram | ||
Description | BranchGenerating Program | ||
Level | 1 | ||
Used | Yes | ||
Required | YesNo | ||
Browse | Yes | ||
Options |
| ||
When |
| ||
Relationship |
| ||
Val. System |
| ||
Help | Branch | Indicates program that generated XML file. |
- SOG Table - Import Log
Field | OG_FILIAL | Field | OG_TRANSAC|
Type | Character | ||
Size | 1002 | ||
Decimal | 0 | ||
Format | @! | ||
Title | TransactionBranch | ||
Description | TransactionBranch | ||
Level | 1 | ||
Used | Yes | ||
Required | Yes | ||
Browse | Yes | ||
Options |
| ||
When |
| ||
Relationship |
| ||
Val. System |
| ||
Help | Indicates the record source transactionBranch |
Field | OG_ | OPTRANSAC |
Type | Character | |
Size | 1310 | |
Decimal | 0 | |
Format | @! | |
Title | Production orderTransaction | |
Description | Production orderTransaction | |
Level | 1 | |
Used | Yes | |
Required | NoYes | |
Browse | Yes | |
Options |
| |
When |
| |
Relationship |
| |
Val. System |
| |
Help | Indicates the production order.record source transaction | |
Field | OG_ | PRODUTOOP |
Type | Character | |
Size | 1513 | |
Decimal | 0 | |
Format | @! | |
TitleProduct | Production Order | |
Description | ProductProduction Order | |
Level | 1 | |
Used | Yes | |
Required | No | |
Browse | Yes | |
Options |
| |
When |
| |
Relationship |
| |
Val. System |
| |
Help | Indicates the product code.production order |
Field | OG_ | RECURSOPRODUTO |
Type | Character | |
Size | 0615 | |
Decimal | 0 | |
Format | @! | |
Title | ResourceProduct | |
Description | ResourceProduct | |
Level | 1 | |
Used | Yes | |
Required | YesNo | |
Browse | Yes | |
Options |
| |
When |
| |
Relationship |
| |
Val. System |
| |
Help | Indicates the resource product code. | |
Field | OG_ | STATUSRECURSO |
Type | Character | |
Size | 0106 | |
Decimal | 0 | |
Format | @! | |
Title | StatusResource | |
Description | StatusResource | |
Level | 1 | |
Used | Yes | |
Required | Yes | |
Browse | Yes | |
Options |
| |
When |
| |
Relationship |
| |
Val. System |
| |
Help | Indicates whether annotation was successfully processed. Status: 1 = OK; 2 = Errorthe resource code. |
Field | OG_ | DATASTATUS |
Type | DateCharacter | |
Size | 801 | |
Decimal | 0 | |
Format | @! | |
Title | Processing dateStatus | |
Description | Processing dateStatus | |
Level | 1 | |
Used | Yes | |
Required | Yes | |
Browse | Yes | |
Options |
| |
When |
| |
Relationship |
| |
Val. System |
| |
Help | Annotation processing date. | Indicates whether annotation was successfully processed. Status: 1 = OK; 2 = Error. |
Field | OG_DATA | Field | OG_HORA|
Type | CharacterDate | ||
Size | 8 | ||
Decimal | 0 | ||
Format |
| ||
Title | Processing TimeData | ||
Description | Processing | TimeData | |
Level | 1 | ||
Used | Yes | ||
Required | Yes | ||
Browse | Yes | ||
Options |
| ||
When |
| ||
Relationship |
| ||
Val. System |
| ||
Help | Annotation processing time.data |
Field | OG_ | DTAPONTHORA |
Type | DateCharacter | |
Size | 8 | |
Decimal | 0 | |
Format |
| |
TitleAnnotation | Start DateProcessing Time | |
Description | Annotation Start DateProcessing Time | |
Level | 1 | |
Used | Yes | |
Required | NoYes | |
Browse | Yes | |
Options |
| |
When |
| |
Relationship |
| |
Val. System |
| |
Help | Annotation Start Dateprocessing time. | |
Field | OG_ | HRAPONTDTAPONT |
Type | CharacterDate | |
Size | 8 | |
Decimal | 0 | |
Format |
| |
Title | Annotation Start TimeSt Dt | |
Description | Annotation | Start TimeSt Dt |
Level | 1 | |
Used | Yes | |
Required | No | |
Browse | Yes | |
Options |
| |
When |
| |
Relationship |
| |
Val. System |
| |
Help | Annotation Start TimeSt Dt |
Field | OG_ | DTFIMAPHRAPONT |
Type | DateCharacter | |
Size | 8 | |
Decimal | 0 | |
Format |
| |
Title | Annotation End DateStart Time | |
Description | Annotation | End DateStart Time |
Level | 1 | |
Used | Yes | |
Required | No | |
Browse | Yes | |
Options |
| |
When |
| |
Relationship |
| |
Val. System |
| |
Help | Annotation End DateStart Time | |
Field | OG_ | HRFIMAPDTFIMAP |
Type | CharacterDate | |
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_ | ESTORNOHRFIMAP |
Type | Character | |
Size | 018 | |
Decimal | 0 | |
Format |
| |
TitleReversal | Annotation End Time | |
Description | ReversalAnnotation End Time | |
Level | 1 | |
Used | Yes | |
Required | No | |
Browse | Yes | |
Options |
| |
When |
| |
Relationship |
| |
Val. System |
| |
Help | Indicates whether it is reverse record 1=YES;2=No
| Annotation End Time |
Field | OG_ESTORNO | Field | OG_OPERAC|
Type | Character | ||
Size | 0201 | ||
Decimal | 0 | ||
Format |
| ||
Title | OperationReversal | ||
Description | OperationReversal | ||
Level | 1 | ||
Used | Yes | ||
Required | No | ||
Browse | Yes | ||
Options |
| ||
When |
| ||
Relationship |
| ||
Val. System |
| ||
Help | Indicates the operation codewhether it is reverse record 1=Yes;2=No
| ||
Field | OG_ | QUANTIDOPERAC |
Type | NumericCharacter | |
Size | 1102 | |
Decimal | 20 | |
Format |
| |
Title | QuantityOperation | |
Description | QuantityOperation | |
Level | 1 | |
Used | Yes | |
Required | No | |
Browse | Yes | |
Options |
| |
When |
| |
Relationship |
| |
Val. System |
| |
Help | Annotation Quantity | Indicates the operation code
|
Field | OG_QUANTID |
Type | |
Field | OG_SEQ |
Type | Numeric |
Size | 1011 |
Decimal | 02 |
Format |
|
Title | SequenceQuantity |
Description | SequenceQuantity |
Level | 1 |
Used | Yes |
Required | YesNo |
Browse | Yes |
Options |
|
When |
|
Relationship |
|
Val. System |
|
HelpRecord | sequenceAnnotation Quantity |
Field | OG_ | XMLSEQ |
Type | MemoNumeric | |
Size | 10 | |
Decimal | 0 | |
Format |
| |
Title | XMLSequence | |
Description | Annotation XMLSequence | |
Level | 1 | |
Used | Yes | |
Required | Yes | |
Browse | Yes | |
Options |
| |
When |
| |
Relationship |
| |
Val. System |
| |
HelpAnnotation | XMLRecord sequence |
Field | OG_ | MSGRETXML |
Type | Memo | |
Size |
| |
Decimal |
| |
Format |
| |
Title | MessageXML | |
Description | Return MessageAnnotation XML | |
Level | 1 | |
Used | Yes | |
Required | Yes | |
Browse | Yes | |
Options |
| |
When |
| |
Relationship |
| |
Val. System |
| |
Help | Return Message |
Important:
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:
The size The size of the fields that have group can vary according to environment in use.
...
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 |
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( | OGOF_ | DATADTENVIO)+ | OGOF_ | HORAHRENVIO |
Description | Transaction + Production Order Branch+Table+Record+Status+ Processing Date Delivery date+ Processing Delivery Time | ||||
Owner | S | ||||
Index | SOG | |
Order | 32 | |
Key | OG_FILIAL+OG_TRANSAC+OG_ | RECURSOOP+OG_STATUS+DTOS(OG_DATA)+OG_HORA |
Description | Transaction + Resource Production Order + 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
...
Visão Geral
Import HTML Content
Conteúdo das Ferramentas
Tarefas