...
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:
...
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. |
...
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 |
...
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 | Belong 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 | 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 | |
DescriptionReprocessing | 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 |
DescriptionGenerator | programReprocessing Time |
Level | 1 |
Used | Yes |
Required | No |
Browse | Yes |
Options |
|
When |
|
Relationship |
|
Val. System |
|
Help | Indicates the schedule the program generated XML file. |
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 | ||
DescriptionBranch | Generating Program | ||
Level | 1 | ||
Used | Yes | ||
Required | YesNo | ||
Browse | Yes | ||
Options |
| ||
When |
| ||
Relationship |
| ||
Val. System |
| ||
Help | Branch | Indicates program that generated XML file. |
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 |
DescriptionProduct | Production 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 |
DescriptionAnnotation | 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 | |
DescriptionReversal | Annotation 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 |
DescriptionReturn | 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.
...
Index | SOD |
Order | 1 |
Key | OD_FILIAL+OD_ATIVO+OD_CAMINHO |
Description | Branch + Active + Path |
Owner | S |
| Index | SOE |
...
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 | 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 | 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 |
...
