PCP Protheus x PPI-Multitask Integration


Business Context

  1. Manufacturing Execution Systems, or simply MES is the term used to refer to the systems focused on the management of production activities establishing a direct link between planning and shop floor. The MES systems generate precise information and in real time promoting the optimization of all production stages since the issue of an order to the shipment of finished products shipment.
    The importance of these systems comes from the gap that regularly exist between the ERP (Enterprise Resource Planning) and the specific softwares of the production line.  The MES can import data from ERP and integrate with the production daily routine, managing and synchronizing the productive tasks with the flow of materials.
    Considering that in the supply chain the highest added value is in the production, it makes sense investing in systems optimizing the flow, control and quality of material (Source: PPI-Multitask).
  2. Planning and Production Control  Gathering of means of production (raw material, labor, and equipment) enables manufacture of products that arise from the action of productive systems. The plans are the guide of execution and in production control are commanded by the auxiliary body named Planning and Controlling of Production (PCP) that establishes the production line rules, aiming at an ordered and continuous flow of the productive process.
  3. Shop Floor Allows you to plan, punch and monitor activities executed in each work center of the plant and machine, enabling an integrated view of executed operations, under execution and to be processed.  Allows the Management and Monitoring of results (productivity, efficiency, delays, quality, use, levels of downtime, scrap reason, deviation of real/standard time etc). In MES integrated use, punches are executed by MES system.

 

Systems Involved

 

Integration

The aim of the PC Factory Integration (MES software of company PPI Multitask) X PROTHEUS is to make available to TOTVS customers a new option to control the production through the automation of processes, enabling the updating and extraction of online information to simplify the customers flow.

 

Scope

 

Enables the integration between the PCP module of SIGASFC Protheus with MES PC-Factory of PPI Multitask, aiming at controlling the annotation of production orders. Protheus is responsible by the creation of production orders and the PC-Factory with annotation.

The integration contemplates the following routines and processes in PHASE 1:

  1. Parameterization: Enables to parameterize the use of integration, indicating if it is ACTIVE. Indicates whether there is generation of XML files of information that is transferred between the systems, and also enables to define filters that are applied to information.
  2. Integrators: Adapters are functions responsible for sending or receiving information that is transferred between Protheus and PC Factory systems. Integration contemplates the following information: Product, stock location, resource, production orders, production annotation and stoppage annotation.
  3. Pendencies: Enables to manage the pendencies of PCP Protheus delivery to PC-Factory as well as to check the history and errors of integration process.
  4. WebService: Enables to process the annotation of production and stoppage sent from PC-Factory to Protheus;
  5. Synchronization: Enables to execute the synchronization of data from PCP Protheus and PC-Factory. Able to send data from Products, Stock Location, Resource and Production Order.
  6. Import Log: Enables to query the integration process of annotation of production and stoppage sent from PC-Factory to Protheus.

The integration contemplates the following routines and processes in PHASE 2:

Phase 2 contemplates the consumption of components, movements executed by PC-Factory and balances in stock. It also considers the SIGASFC - Shop Floor system.

  1. Parameterization: Enables to parameterize the use of integration, indicating if it is ACTIVE. Indicates whether there is generation of XML files of information that is transferred between the systems, and also enables to define filters that are applied to information.
  2. Integrators: Adapters are functions responsible for sending or receiving information that is transferred between Protheus and PC Factory systems. Integration contemplates the following information: Product, stock location, resource, machine, tools, script, structure, address, production order, balance in stock, movements and transfer of stock, annotation or production and stoppage annotation.
  3. Pendencies: Enables to manage the pendencies of PCP Protheus delivery to PC-Factory as well as to check the history and errors of integration process.
  4. WebService: Enables to process the annotation of production and stoppage sent from PC-Factory to Protheus;
  5. Synchronization: Enables to execute the synchronization of data from Protheus and PC-Factory. Able to send data from Products, Stock Location, Resource, Machine, Script, Structure, Address, Balance in Stock and Production Order.
  6. Import Log: Enables to query the integration process of annotation of production, refusal and stoppage sent from PC-Factory to Protheus.


Integration does not contemplate the generation of orders by APS.

Install/Implement/Use Requirements

For Protheus version 12, apply package of updates from version 12.1.10 in Phase I. It can also be used in version 11.80.14 for Phase I and 11.80.17 for Phase II. Run the update of dictionary with program U_UPDPCP34.
Build must be equal to or later than 7.00.131227A and date 9/8/2014.
IP Address and released port for WebService execution. These data are used in APPSERVER.INI file in session WEBSERVICE.
Update APPSERVER.INI  file in session WEBSERVICE.
To configure a WebService, check this configuration: http://tdn.totvs.com/pages/viewpage.action?pageId=6064937
Exemplo :
; WEBSERVICE CONFIGURATION


[WebServices]
Enable=1
Environment=mssqlserver
Conout=1
Trace=1
PrepareIn=99,01
NameSpace=http://10.80.62.219:8090
URLLocation=http://10.80.62.219

[HTTP]
enable=1
port=8090

[ONSTART]
JOBS=JOB_WS_9901

[10.80.62.219]
ENABLE=1
Trace=1
PATH=C:\TOTVS 11\Microsiga\Protheus_Data\web\ws
ENVIRONMENT=mssqlserver
INSTANCENAME=WS
RESPONSEJOB=JOB_WS_9901
DEFAULTPAGE=wsindex.apw

[JOB_WS_9901]
TYPE=WEBEX
ENVIRONMENT=mssqlserver
INSTANCES=1,20
SIGAWEB=WS
INSTANCENAME=WS
ONSTART=__WSSTART
ONCONNECT=__WSCONNECT

;FIM CONFIGURACAO WEBSERVICE

 

You can also update in APPSERVER.INI file in session PROXY (if there is configured proxy)

[PROXY]

Enable=1
Server=proxy-jv.jv01.local
Port=8080
User=XXXXX
Password=*******

 

Installation/Updating

The PCP Protheus x PC-Factory PPI-Multitask is activated through the following steps:

  1. Open the progrm of Integration Parameters: PCPA109 (Updates -> Integration MES-> Parameters).
  2. Set the field Active to "1- Active".
  3. In the field path enter the URL of WebService of PPI-Multitask.
  4. Check WebService connectivity through Test button.
  5. Indicate whether the integration physically generate the XML files.
  6. Configure the filters for each information that is transferred between the systems.
  7. Confirm the activation through the button CONFIRM.

The Test button check whether you can execute the connection with WebService entered in the field Path. This button has two returns:

Selecting the field Generate XML, the XML of the exchanged messages is generated. If you do not select it, the system saves it only in tables. You are not required to create files. It works as a useful tool to find problems and it can be saved in XML directory successfully sent or pending XMLs.
The file names follow these standard:

OK_<MSG>_<DATAHORA>_<REGISTRO>
PEND_<MSG>_<DATAHORA>_<REGISTRO>
ERR_<MSG>_<DATAHORA>_<REGISTRO>
Where: OK - Message sent with no problems
           PEND- Message not sent
           ERR - Message sent, but returned with error.
          MSG - Name of message. Ex.: Item, Wharehouse, Workcenter, etc.
           DATETIME: Date and Time of sending
           RECORD: Record code being sent. Ex.: Item code, order number, etc.

For each file moved (product, stock location, resource, tool, machine, script, structure, address, movements, balances and production order) a folder exists. For each folder, you can assemble filters and define parameterizations. These filters are used in routines that send PC-Factory information enabling you to select what must be sent. The fields of selected table (folders) and operators are displayed so filters are assembled. If there is no filter registered, every record added, edited or deleted is sent to PC-Factory. To assemble the filters, the user must know the database, as table names and fields are directly used.
Example:
To assemble a filter, so only products classified as Finished Product are sent. Filter is: B1_TIPO = "PA"

The delivery of Protheus information for PC-Factory PPI Multitask, the following transactions occur:

 

The delivery of PCP-Factory PPI Multitask information for Protheus, the following transactions occur:

 

Version Control

TOTVS group, represented by its brands, manages the layout progress demands and other adjustments, agreeing together with requesters the release approval term.
All progress scheduled must be discussed and approved by brands before the start of development and is only developed in case of agreement of brands and alignment with directive defined by TOTVS Integration Committee.

 

Support

All lines are responsible for support to integration resources; hence, the support teams of RM Connector and Protheus® Back Office products are ready to make the first analysis and, whenever needed, to transfer it to the fittest team in each case.


This support model is being reviewed by TOTVS.


Transactions/Entities/Singles Messages

The following transactions are exchanged between TOTVS and PPI-Multitask:

 

 

 

 

Method

ID

Description

Origin

Destination

XSD (versions may vary)

ProgramsTable

Registers

01

Product

Protheus

PC-Factory

Item_3_001.xsd

MATA010SB1

02

Stock Location

Protheus

PC-Factory

Warehouse_1_001.xsd

AGRA045NNR

03

Machines

Protheus

PC-Factory

Machine_1_000.xsd

MATA610

SFCA002

SH1

CYB

04ResourcesProtheusPC-FactoryResource_1_000

MATA620

SFCA006

SH4

CYH

05StructureProtheusPC-FactoryItemStructure_1_000MATA200SG1
06ScriptProtheusPC-Factory ItemScript_1_000

MATA632

MATA637

SG2

07

Production Order

Protheus

PC-Factory

ProductionOrder_2_004.xsd

MATA650

MATA651

MATA380

MATA381

MATA690

MATA712

PCPA107

SFCA310

SC2
08AddressProtheusPC-Factory AddressStock_1_000MATA015SBE
09StockProtheusPC-FactoryItemStockLevel_1_000

B2ATUCOMD1

B2ATUCOMD2

B2ATUCOMD3

MATA220

MATA805

SB2

SB8

SBF

Processes

09

Reason of Stoppage

PC-Factory

Protheus

StopReason_1_000

CFGX016

SFCA004

SX5

CYN

10Reason of ScrapPC-FactoryProtheusWasteReason_1_000

CFGX016

SFCA003

SX5

CYO

11Annotation of ProductionPC-FactoryProtheusProductionAppointment_2_000

MATA681

SFCA316

SH6

SD3

CYV

12

Annotation of Stoppage

PC-Factory

Protheus

StopReport_1_001

MATA682

SFCA311

SH6

CYX

13Stock - RequestPC-FactoryProtheusStockLevel_2_00 

SB2

SB8

SBF

14MovementsPC-FactoryProtheus MovementsInternal_1_001

MATA240

MATA250

SD3
15TransferPC-FactoryProtheusTransferWarehouse_1_003MATA261SD3
16RefusalPC-FactoryProtheusRefusal_1_000MATA685SBC

 

 


Information Flow

Transactions information flow:

 

Entry Point

To make the use of integration easier and flexible in any productive environment, some entry points were created to solve possible specific situations not answered by the default process and also to enable more precise configurations in the integration use:

Annotation: The entry point MATI681CRG enables to add information that is used in annotation of production and in the stoppage annotation, table SH6. Example: In case there is a specific field or table not handled by the integration, you can use this function to set its content. Details in: MATI681CRG_Add_information_Adapter_of_annotation.

Annotation: The entry point  MT680VAL  enables to validate if any information must be mandatory as time, quantity, among others. These validations are under the customers' responsibility, as each has its own rule. Details in: MT680VAL - Addition of Productions.

Annotation: The entry point MATI680OPR enables to change the code of operation received in the annotation of production. Details in: MATI681OPR_Edit_operation_code_message_annotation_production.

Annotation: The entry point MTI681QTAP enables to edit the quantity received in the annotation of production. This entry point is indicated to apply the conversion factor in the amount of annotation when ERP and PC-Factory work with different unit of measurement. Details in: MTI681QTAP_Edit_amount_of_annotation_ProductionAppointment.

Annotation: The entry point MATI681EXC enables to check whether the annotation is executed. This entry point is indicated for validations that hinder the annotation of production and stoppage. It is also used for cases in which you have to update some information before annotation (example: reversal an address). Details in: MATI681EXC_Processes_Message_Annotation.

Production Order: The Entry Point  MTI650ADOP enables to add a new operation in the production orders message. For each operation being sent   this entry point is executed once. Details in:: MTI650ADOP_Add new operation of production order adapter.

Production Order: Production Order: The Entry Point MTI650FCOP enables to change the second unit of measure of the operation being sent in the production orders message. Details in:: MTI650FCOP_Change_conversion_factor_second_unit_of_operation_measure_adapter_production_order.

Production Order: The Entry Point MTI650QTOP enables to change the amount of operation being sent in the production orders message. Details in: MTI650QTOP_Change_quantity_of_operation_adapter_production_order.

Production Order: The Entry Point MTI650UMOP enables to change the second unit of measure of the operation being sent in the production orders message. Details in: MTI650UMOP_Change_second_unit_of_measure_of_operation_adapter_productionn_order.

Production Order: The Entry Point MTI650TMAC enables to change the machine time (TimeMachine) in the message of ProductionOrder. Details in: MTI650TMAC_Edit_amount_of_machine_time_production_order.

Production Order: The Entry Point MTI650LOTE enables to generate the Batch of the order in the tag LotCode in the message ProductionOrder. Details in: MTI650LOTE_Add_batch_in_message_of_production_orders

Registers: The Entry Point PCPXFUNPPI  enables to inhibit the integration in certain routine. Example: If you do not want integration to occur in the creation of MATA650 orders, you can use this function to inhibit the use. Details in: PCPXFUNPPI_Routines_not_executing_integration_with_the_PC_Factory.

Register of Item: o Ponto de entrada PCPADDTAGS permite incluir tags específicas nas mensagens padrões TOTVS. Está habilitado para o cadastro de item MATA010. Detalhes em: PCPADDTAGS_Adicionar_informacoes_XML_integracao_TOTVS_MES.

Cadastro de Processos: o Ponto de entrada PCPADDTAGS permite incluir tags específicas nas mensagens padrões TOTVS. Está habilitado para o cadastro de roteiro MATA632. Detalhes em: PCPADDTAGS_Adicionar_informacoes_XML_integracao_TOTVS_MES

Internal Movements. The entry points MATI250CRG and MATI240CRG enable specific validation. These validations are under the customers' responsibility, as each has its own rule. You cannot generate the values of fields that were generated by message. Details in:MATI240CRG_Add_information_Adapter_of_internal_movements and MATI250CRG_Add_information_Adapter_of_production_movements

Transfers: The entry point MI261RCV does not enable the execution of the integration. Details in: MI261RCV_Execute_integration_TransferWarehouse

Recusa: O ponto de entrada MATI685EXC permite verificar se a recusa será executado ou não. Este ponto de entrada é indicado para validações que impeçam o apontamento de recusa ou atualizações de informações necessárias para realizar a recusa. Detalhes em: MATI685EXC_Processa_Mensagem_Recusa

 

Execute in various branches

In an environment with various branches, just one WEBSERVICE is necessary for execution. The TAGs indicate the branch in which the annotation is processes:

<CompanyId>10</CompanyId>

<BranchId>CLSC0001</BranchId>

Note: When these tags are in blank the system considers what is defined in APPSERVER.ini in session WEBSERVICE field PrepareIn.

[WebServices]

PrepareIn=99,01

 

Routines

Parameterization - PCPA109

Setting parameters directly influences records not moved between the two systems.

The parameter settings routine has the following fields:

Each file transacted has a folder. For each folder, you can assemble filters. These filters are used in routines that send PC-Factory information enabling you to select what must be sent. The fields of selected table (folders) and operators are displayed so filters are assembled. Like the filters, some files are parameterized.

The routine has the following folders:

"1" - BackFlush: Whenever issue of components is executed according to what is defined in Engineering.   

"2" - Actual Consumption: Consumption according to component list.

 

Synchronization - PCPA111

The synchronization is the process that is used to populate or update the base of PC-Factory with data from Protheus. It will work the same manner the other routines of integration do, by integrating a XML message to WebService of PC-Factory, following the parameterizations defined in PCPA109. The only difference is that all data of the table being integrated are viewed (following the filters) instead of only one record.

 

 

Pendencies - PCPA110

Routine to resend messages not sent to PC-Factory system, whether they are pendencies or mistakes. The routine also enables to query the messages sent (delivery LOG).

To check pendencies and log of messages moved between the systems:

With the following options: 

 

Import Log - PCPA112

When receiving data from PC-Factory, Webservice Protheus saves information so they are queried (SOG table). Find the list of movements generation LOG below:

 

 

Messages

Registers

Transaction Item: Item_3_001.xsd
Message Identifier: Item
Version: 3_001
Protheus Module: SiGAPCP
Sending Type: Synchronous

 

Message

Tag

Description

Table/Field: Protheus

Type

Table/Field: PC-Factory

Type

BusinessContentType

CompanyId 

Logged Company Code

 

 

CHAR(02)

 

 

 

BranchId 

Branch Code

 SB1.B1_FILIAL

CHAR(02)

 

 

 

CompanyInternalId

Company+Branch

 COMPANY + SB1.B1_FILIAL

 

 

 

 

Code 

Product code

SB1.B1_COD

CHAR(15)

 

 

 

Name 

Product Description

SB1.B1_DESC

CHAR(30)

 

 

 

InternalId

Company+branch+product code

COMPANY + SB1.B1_FILIAL + SB1.B1_COD

 

 

 

 

ShortName 

Short name

SB1.B1_DESC

CHAR(30)

 

 

 

Active 

Active item?

SB1.B1_ATIVO

CHAR(01)

 

 

 

UnitOfMeasureCode 

Unit of Measurement:

SB1.B1_UM

CHAR(02)

 

 

 

UnitOfMeasureInternalId

Company+branch+unit or measure

COMPANY + SB1.B1_FILIAL + SB1.B1_UM

 

 

 

 

StockGroupCode

Inventory Group

SB1.B1_GRUPO

CHAR(04)

 

 

 

StockGroupInternalId

Company+branch+stock group

COMPANY + SB1.B1_FILIAL + SB1.B1_GRUPO

 

 

 

 

StockGroupDescription

Stock Group Description

SBM.BM_DESC

CHAR(30)

 

 

 

StandardWarehouseCode

Stock Location

SB1.B1_LOCPAD

CHAR(02)

 

 

 

StandardWarehouseInternalId

Company+branch+stock location

COMPANY + SB1.B1_FILIAL + SB1.B1_LOCPAD

 

 

 

 

StandardWarehouseDescription

Stock Location Description

NNR.NNR_DESCRI

CHAR(40)

 

 

 

EconomicLot 

Economic Lot

SB1.B1_LE

DEC(12,2)

 

 

 

MinimumLot 

Minimum Lot

SB1.B1_LM

DEC(12,2)

 

 

 

FamilyCode 

Family

SB1.B1_FPCOD

CHAR(10)

 

 

 

FamilyInternalId

Company+branch+family

COMPANY + SB1.B1_FILIAL + SB1.B1_FPCOD

 

 

 

 

FamilyDescription 

Family Description

SYC.YC_NOME

CHAR(40)

 

 

 

NetWeight

Item Weight

SB1.B1_PESO

DEC(11,4)

 

 

 

GrossWeigh

Gross Weight

SB1.B1_PESBRU

DEC(11,4)

 

 

 

Trail

Trace

SB1.B1_RASTRO

CHAR(01)

 

 

 

BinControl

Controls Address

SB1.B1_LOCALIZ

CHAR(01)

 

 

 

SecondUnitOfMeasureCode

Second Measurement Unit

SB1.B1_SEGUM

CHAR(02)

 

 

 

SecondUnitOfMeasureInternalId

Company+branch+ sec. measure unit

COMPANY + SB1.B1_FILIAL + SB1.B1_SEGUM

 

 

 

 

MultiplicationFactorValue 

Conversion Factor

SB1.B1_CONV

DEC(5,2)

 

 

 

ProductType

Type of Item

SB1.B1_TIPO

CHAR(02)

 

 

 

PackingQuantity 

Package Quantity

SB1.B1_QE

NUM(09)

 

 

 

CostCenterCode

Cost Center

SB1.B1_CC

CHAR(09)

 

 

If it is an undefined type, it must be saved as GENERIC. Example: Type = SAMPLER.

 

Deposit Transaction: Warehouse_1_001.xsd
Message Identifier: Warehouse
Version: 1_001
Protheus Module: SiGAPCP
Sending Type: Synchronous

 

Message

Tag

Description

Table/Field: Protheus

Type

Table/Field: PC-Factory

Type

BusinessContentType

CompanyId

Company Code

 

CHAR(02)

 

 

 

BranchId

Branch Code

NNR.NNR_FILIAL

CHAR(02)

 

 

 

CompanyInternalId

Company+Branch

COMPANY + NNR.NNR_FILIAL

 

 

 

 

Code

Code of Stock Location(warehouse/deposit)

NNR.NNR_CODIGO

CHAR(02)

 

 

 

InternalId

Company+Branch+location code

COMPANY + NNR.NNR_FILIAL +

NNR.NNR_CODIGO

 

 

 

 

Description

Description of Stock Location (warehouse/deposit)

NNR.NNR_DESCRI

CHAR(20)

 

 

 

Active

Location of Active Stock?

TRUE

CHAR(01)

 

 

 

Type

Type of Stock Location

NNR.NNR_TIPO

CHAR(01)

 

 

 

WarehouseClassification

Classification

NNR.NNR_INTP

CHAR(01)

 

 

 

Transaction Resource PCP / Machine SFC: Machine_1_000.xsd
Message Identifier: Machine
Version: 1_000
Protheus Module: SIGAPCP, SIGASFC
Sending Type: Synchronous

Message

Tag

Description

Table/Field:

Protheus PCP

Table Field:

Protheus SFC

Type

Table/Field: PC-Factory

Type

BusinessContentType

 

 

 

 

 

 

 

 

Code

Machine Code

SH1.H1_CODIGO

CYB.CYB_CDMQ

CHAR(20)

 

 

 

Description

Machine Description

SH1.H1DESCRI

CYB.CYB_DSMQ

CHAR(40)

 

 

 

WorkCenterCode

Work Center Code

SH1.H1_CTRAB

CYB.CYB_CDCETR

CHAR(10)

 

 

 

WorkCenterDescription

Work Center Description

SHB.HB_NOME

CYB.CYB_DSCETR

CHAR(40)

 

 

 

CostCenterCode

Cost Center Code

SH1.H1_CCUST

CYB.CYB_CDCECS

CHAR(20)

 

 

 

ProcessorType

Type of Processing

 

CYB.CYB_TPPC

1=Single processing; 2=Batch processing;

3=Multiple Processings;4=Manual

CHAR(01)

 

 

 

LaborType

Type MOD

 

CYB.CYB_TPMOD

1=Does not report;2=Operator;3=Team

CHAR(01)

 

 

 

VolumeMachineQuantity

Machine Volume Quantity

 

CYB.CYB_QTVMMQ

DEC(12,4)

 

 

 

EfficiencyMachineValue

Machine Efficiency

 

CYB.CYB_VLEFMQ

DEC(05,2)

 

 

 

OperatorMachineQuantity

Machine Operator Quantity

 

CYB.CYB_QTOEMQ

NUM(02)

 

 

 

SimultaneousActivityQuantity

Simultaneous Operations Quantity

 

CYB.CYB_QTATSM

NUM(03)

 

 

 

IsSetup

Has Setup

 

CYB.CYB_LGSU

BOOLEAN

 

 

 

IsOverlapReport

Overlap annotation

 

CYB.CYB_LGOVRP

BOOLEAN

 

 

 

ProductionAreaCode

Production Area

 

CYB.CYB_CDARPO

CHAR(10)

 

 

 

InitialValidateDate

Validity Start Date

 

CYB.CYB_DTBGVD

DATE

 

 

 

FinalValidateDate

Validity End Date

 

CYB.CYB_DTEDVD

DATE

 

 

ListOfResources

 

 

 

 

 

 

 

 

 ResourceType

Resource Type

 

CYC.CYC_TPRC

1=Operator;2=Tool;

3=Team;4=Equipment

CHAR(01)

 

 

 

ResourceCode

Resource Code

 

CYC.CYC_CDRC

CHAR(20)

 

 

 

ResourceName

Resource Name

 

CYC.CYC_NMRC

CHAR(40)

 

 

 

UnitTimeType

Time Measure Type

 

CYC.CYC_TPUNTE

1 = Hours;2=Minutes;3=Seconds

CHAR(01)

 

 

 

StartExpirationDate

Expiration Start Date

 

CYC.CYC_DTBGVD

DATE

 

 

 

EndExpirationDate

Expiration End Date

 

CYC.CYC_DTEDVD

DATE

 

 

 

CycleQuantity

Number Cycles

 

CYC.CYC_QTCI

DEC(11,4)

 

 

 

IsTimeActivity

Determines time

 

CYC.CYC_LGTEAT

BOOLEAN

 

 

ListOfProductionShifts

 

 

 

 

 

 

 

 

ProductionShiftCode

Shift Model Code

 

CYL.CYL_CDTN

CHAR(08)

 

 

 

ProductionShiftDescription

Shift Model Description

 

CYL.CYL_DSTN

CHAR(40)

 

 

 

BeginDate

Expiration Start Date

 

CYL.CYL_DTVDBG

DATE

 

 

 

EndDate

Expiration End Date

 

CYL.CYL_DTVDED

DATE

 

 


In PCP, the machines are registered in the routine of resources MATA610 and in the Shop Floor, the routine is SFCA002. Nomenclature is also changed. When using Shop Floor, it is named MACHINE. When using only PCP. it is RESOURCE. The routine of parameters PCPA109 is ready to present the name according tothe use of the system.

 

SFC Resource Transaction: Resource_1_000
Message Identifier: Resource
Version: 1_000
Protheus Module: SIGAPCP
Sending Type: Synchronous

Message

Tag

Description

Table/Field:

Protheus PCP

Table Field:

Protheus SFC

Type

Table/Field: PC-Factory

Type

BusinessContentType

 

 

 

 

 

 

 

 

Code

Resource Code

SH4.H4_CODIGO

CYH.CYH_CDRC

CHAR(06)

 

 

 

Name

Resource Name

SH4.H4_DESCRI

CYH.CYH_NMRC

CHAR(40)

 

 

 

Type

Resource Type

1=Operator;2=Tool;

3=Team;4=Equipment.

 

CYH.CYH_TPRC

 1=Operator;2=Tool;

3=Team;4=Equipment

CHAR(25)

 

 

 

ProductionAreaCode

Production Area

 

CYH.CYH_CDARPO

CHAR(10)

 

 

 

ProductionAreaDescription

Production area description

 

CYA.CYA_DSARPO

CHAR(40)

 

 

 ItemComponentType

 

 

 

 

 

 

 

 

ProductionShiftNumber

Shift

SH4.H4_TURNO

CYH.CYH_NRTN

CHAR(05)

 

 

 

LaborCode

MOB

Fixed '1'

CYH.CYH_CDMOD

CHAR(08)

 

 

 

StartExpirationDate

Start validity date

Current Date

CYH.CYH_DTVDBG

DATE

 

 

 

EndExpirationDate

End Validity Date

 

CYH.CYH_DTVDED

DATE

 

 

 

UnitCycleQuantity

Units Cycles

 

CYH.CYH_QTUNCI

NUM(07)

 

 

 

ToolCode

Tool

 

CYH.CYH_CDMPRC

CHAR(15)

 

 

 

ToolDescription

Tool Description

 

CYH.CYH_DSMPRC

CHAR(40)

 

 

  • The Resource in the PCP indicates the machine, in the shop floor indicates toosl, operator etc;
  • When origin is PCP the tag Type (Resource Type) is generated in fixed value '2';
  • When origin is PCP the tag UnitCycleQuantity (Cycles Unit) is generated in fixed value '1';
  • When origin is PCP the tag UnitCycleQuantity (Cycles Unit) is generated in fixed value '1';
  • When origin is PCP the tag StartExpirationDate (Start Validity) is generated with date of message generation;
  • When origin is PCP the tag EndExpirationDate (End Validity) is generated in fixed value '1';
    Current date (dDataBase) + lifespan of tool (H4_VIDAUTI). Consider type of lifec ycle (H4_TIPOVID) - D=Days;H=Hours;M=Month;A=Year


Transaction Structure: ItemStructure_1_000.xsd 
Message Identifier: ItemStructure
Version: 1_000
Protheus Module: SiGAPCP
Sending Type: Synchronous

 

Message

Tag

Description

Table/Field: Protheus

Type

Table/Field: PC-Factory

Type

BusinessContentType

CompanyId

Company Code

 

CHAR(02)

 

 

 

CompanyInternalId

Company+Branch

COMPANY + SG1.G1_FILIAL

 

 

 

 

ItemInternalId

Company+Branch+parent item code

COMPANY + SG1.G1_FILIAL +

SG1.G1_COD

 

 

 

 

ItemCode

Parent Item Code

SG1.G1_COD

CHAR(15)

 

 

 

ItemAmount

Base quantity of parent item

SB1.B1_QB

NUM(07)

 

 

ItemComponentType

 

 

 

 

 

 

 

ItemSequence

Component sequence

SG1.G1_TRT

NUM(05)

 

 

 

ItemComponentCode

Component item code

SG1.G1_COMP

CHAR(15)

 

 

 

ItemComponentInternalId

Internal Id of Component Item

COMPANY +SG1.G1_FILIAL +SG1.G1_COMP

 

 

 

 

InitialDate

Start validity date

SG1.G1_INI

DATE

 

 

 

FinalDate

End Validity Date

SG1.G1_FIM

DATE

 

 

 

IsGhostMaterial

Indicates if is ghost

SB1.B1_FANTASM

CHAR(01)

 

 

 

ItemComponentAmount

Component Item Quantity

SG1.G1_QUANT

DEC(12,6)

 

 

 

LossFactor

Loss factor

SG1.G1_PERDA

DEC(05,2)

 

 

 ListOfScript

 

 

 

 

 

 

 

Scriptcode

Script Code

SGF.GF_ROTEIRO

CHAR(02)

 

 

 

ScriptAlternative

Script Alternative

--

 

 

 

 

ActivityIntenalID

Operation ID

--

 

 

 

 

ActivityCode

Operation Code

SGF.GF_OPERAC

CHAR(02)

 

 

 

ActivityComponentSequence

Sequence of component in operation

SGF.GF_TRT

NUM(03)

 

 

 

Script Transaction - Item Operations: ItemScript_1_000.xsd 
Message Identifier: ItemScript
Version: 1_000
Protheus Module: SiGAPCP
Sending Type: Synchronous

 

Message

Tag

Description

Table/Field: Protheus

Type

Table/Field: PC-Factory

Type

BusinessContentType

ItemCode

Item code

SG2.G2_PRODUTO

CHAR(15)

 

 

 

ItemDescription

Item Description

SB1.B1_DESC

CHAR(40)

 

 

 

ItemInternalId

Company|Branch|Item

COMPANY + SG2.G2_FILIAL +

SG2.G2_PRODUTO

 

 

 

 

ScriptCode

Script Code

SG2.G2_CODIGO

CHAR(02)

 

 

 

ScriptDescription

Script Description

--

CHAR(40)

 

 

 

ScriptAlternative

Alternative Script

--

CHAR(02)

 

 

ListOfActivity

 

 

 

 

 

 

 

ActivityInternalID

Operation ID

SG2.R_E_C_N_O_

NUM(05)

 

 

 

ActivityCode

Operation Code

SG2.G2_OPERAC

CHAR(02)

 

 

 

ActivityDescription

Operation Description

SG2.G2_DESCRI

CHAR(60)

 

 

 

MachineCode

Machine Code

SG2.G2_RECURSO

CHAR(06)

 

 

 

ToolCode

Tool Code

SG2.G2_FERRAM

CHAR(06)

 

 

 

ActivityType

Operation Type

1 = Executes operation; 2 = Does not execute.

CHAR(01)

 

 

 

WorkCenterCode

Work Center Code

SG2.G2_CTRAB

CHAR(06)

 

 

 

WorkCenterInternalId

Work Center Id

COMPANY + SG2.G2_FILIAL +SG2.G2_CTRAB

 

 

 

 

UnitItemNumber

Standard lot 

SG2.G2_LOTEPAD

NUM(06)

 

 

 

TimeResource

Resource Time

0

 

 

 

 

TimeMachine

Machine Time

SG2.G2_TEMPAD

DEC(05,2)

 

 

 

TimeSetup

Preparation Time

SG2.G2_SETUP

DEC(05,2)

 

 

 

UnitTimeType

Time Unit Type

1 = Hours;2=Minutes;3=Seconds;4=Days

 

 

 

 

ScriptAlternative

Alternative

SG2.G2_ROTALT

CHAR(02)

 

 

 

InitialDate

Start Date

SG2.G2_DTINI

DATE

 

 

 

FinalDate

End Date

SG2.G2_DTFIM

DATE

 

 

 

PercentageScrapValue

% Scrap

--

 

 

 

 

PercentageValue

Proportion

--

 

 

 

 

ResourceQuantity

Resource Quantity

--

 

 

 

  • The tag ActivityType (Operation Type) is generated with fixed value '1';
  • The tag ActivityType (Time Unit Type) is generated with fixed value '1';
  • The tag ListOfPertOrders is not generated for Protheus;
  • In the deletion of a script, do not delete if there is integrity with the routine of OPERATIONS x COMPONENTS, MATA637. In this case, you do not need to send any message to PC-Factory;
  • When adding, editing or deleting data from MATA637, structure message is sent, ItemStructure.


Addresses Transaction: AdressStock_1_000.xsd
Message Idenfier: AdressStock
Version: 1_000
Protheus Module: SiGAPCP
Sending Type: Synchronous

 

Message

Tag

Description

Table/Field: Protheus

Type

Table/Field: PC-Factory

Type

BusinessContentType

WarehouseCode

Warehouse/Deposit

SBE.BE_LOCAL

CHAR(02)

 

 

 

LocationCode

Address/Location

SBE.BE_LOCALIZ

CHAR(15)

 

 

 

AdressInternalId

Address full key

 COMPANY + SBE.BE_FILIAL + SBE.BE_LOCAL + SBE.BE_LOCALIZ

 

 

 

 

AdressStockDescription

Address description

SBE.BE_DESCRIC

CHAR(30)

 

 

 

Balance Transaction: ItemStockLevel_1_000.xsd
Message Identifier: ItemStockLevel
Version: 1_000
Protheus Module: Various
Sending Type: Synchronous

 

Message

Tag

Description

Table/Field: Protheus

Type

Table/Field: PC-Factory

Type

BusinessContentType

ItemCode

Product code

SB2.B2_COD

CHAR(15)

 

 

 

ItemDescription

Item Description

SB1.B1_DESC

CHAR(30)

 

 

ListOfStock

 

 

 

 

 

 

 

ReferenceCode

Reference

--

 

 

 

 

WarehouseCode

Deposit/Stock location/Warehouse

SB2.B2_LOCAL

CHAR(02)

 

 

 

LotCode

Lot Number

SB8.B8_LOTECTL

CHAR(10)

 

 

 

SubLotCode

Sub-lot

SB8.B8_NUMLOTE

CHAR(06)

 

 

 

NumberSeries

Serial Number

SBF.BF_NUMSERI

CHAR(20)

 

 

 

AddressCode

Address/Location

SBF.BF_LOCALIZ

CHAR(15)

 

 

 

LotDueDate

Expiration Date

SB8.B8_DTVALID

DATE

 

 

 

CurrentStockAmount

Stock balance

SB2.B2_QATU

SB8.B8_SALDO

SBF.BF_QUANT

DEC(12,2)

 

 

 

BookedStockAmount

Reserved Quantity

SB2.B2_RESERVA

SB8.B8_EMPENHO

SBF.BF_EMPENHO

DEC(12,2)

 

 

 

AvailableStockAmount

Available balance

SB2.B2_QATU - SB2.B2_RESERVA

SB8.B8_SALDO - SB8.B8_EMPENHO

SBF.BF_QUANT - SBF.BF_EMPENHO

DEC(12,2)

 

 

 

QuantityUpdated

Updated Quantity

 

DEC(12,2)

 

 

 

InputOutput

Input or Output

1=Input or 2=Output.

CHAR(01)

 

 

  • When updating new balance in ERP, message is sent to PC-Factory.
    Transactions generating movement of stock and executing balance updating routines activating integration:
    Inbound Inv.  - Function B2ATUCOMD1
    Sale Inv. - Function B2ATUCOMD2 Internal Transac. - Function B2ATUCOMD3
  • When the balance is updated by an update of PC-Factory do not generated the balance updating message. When the origin of the balance change is TOTVSMES, message is not generated.
    In production annotation message, tag Product Name indicates what is sent to record. For TOTVS MES, this information is saved in SH6.H6_OBSERVA = 'TOTVSMES'.
    If the movement is internal, it is registered in SD3.D3_OBSERVA = 'TOTVSMES'.
  • The field QuantityUpdated corresponds to the updated quantity, that is, quantity being moved. 
  • The field InputOutput indicates if the movement is input or output. 
  • When the item controls address (B1_LOCALIZ), the balance message must be generated only in the confirmation of MATA265, routine executing the address.
  • The routines of initial balance of PCP and Stock, MATA220 and MATA805 also generated the balance message.


Waste Reason Transaction: WasteReason_1_000.xsd 

Message Identifier: WasteReason
Version: 1_000
Protheus Module: SIGAPCP/SIGASFC
Sending Type: Synchronous

 

Message

Tag

Description

Table/Field:

Protheus PCP

Table Field:

Protheus SFC

Type

Table/Field: PC-Factory

Type

BusinessContentType

Code

Waste Code

SX5.X5_CHAVE

CYO.CYO_CDRF

CHAR(08)

 

 

 

Description

Scrap Description

X5_DESCRI

X5_DESCSPA

X5_DESCENG

CYO.CYO_DSRF

CHAR(40)

 

 

 

IsRework

Rework

 

CYO.CYO_LGRT

BOOLEAN

 

 

 

IsScrapMaterial

Scrap Material

SBE.BE_DESCRIC

CYO.CYO_LGRFMP

BOOLEAN

 

 

    • When no is integrated with Shop Floor, MV_INTSFC equal to '0' the scrap is registered in generic table SX5. 
    • It must search in SX5 table according to command below:
      select X5_CHAVE from sx5990 where X5_TABELA = '43'
      Where:
      - Code of reason is X5_CHAVE
      Table of reason is '43'.
    • When it is integrated with  Shop Floor, MV_INTSFC equal to '1' is generated only the table of  Shop Floor - CYO. Routine SFCA003. If in the message there is no indicator of scrap or rework, consider scrap (CYO_LGRFMP = 'T').
    • Waste reasons have different sizes in tables. Validate it if receipt code does not exceed the size of columns in Protheus.
    • When uses the SIGAPCP it must validate a SX5.X5_CHAVE and SBC.BC_MOTIVO.
    • When uses the SIGASFC validate against the CYO.CYO_CDRF, CY0.CY0_CDRF  and SBC.BC_MOTIVO.

 

Stop Reason Transaction: StopReason_1_000.xsd

Message Identifier: StopReason
Version: 1_000
Protheus Module: SIGAPCP/SIGASFC
Sending Type: Synchronous

 

Message

Tag

Description

Table/Field:

Protheus PCP

Table Field:

Protheus SFC

Type

Table/Field: PC-Factory

Type

BusinessContentType

Code

Stoppage Reason Code

SX5.X5_CHAVE

CYN.CYN_CDSP

CHAR(10)

 

 

 

Description

Stoppage Description

X5_DESCRI

X5_DESCSPA

X5_DESCENG

CYN.CYN_DSSP

CHAR(40)

 

 

 

IsEfficiency

Change Efficiency

--

--

 

 

 

 

IsEmailEquipment

E-mail Planner

--

--

 

 

 

 

IsServiceRequest

Issue Service Request

--

--

 

 

 

 

IsSetup

Setup Stoppage

--

--

 

 

 

    • When no is integrated with Shop Floor, MV_INTSFC equal to '0' the stoppage reason is registered in generic table SX5. 
    • It must search in SX5 table according to command below:
      select X5_CHAVE from sx5990 where X5_TABELA = '44'
      Where:
      - Code of reason is X5_CHAVE
      Table of reason is '44'.
    • When it is integrated with  Shop Floor, MV_INTSFC equal to '1' is generated only the table of  Shop Floor - CYN. Routine SFCA004. 
    • Stoppage reasons have different sizes in tables. Validate it if receipt code does not exceed the size of columns in Protheus.
      When it uses the SIGAPCP it must validate against the SX5.X5_CHAVE and SH6.H6_MOTIVO
      When it uses the SIGASFC validate against the CYN.CYN_CDSP, CYX.CYX_CDSP and SH6.H6_MOTIVO


Production Order Transaction: ProductionOrder_2_003.xsd

Message Identifier: ProductionOrder
Version: 2_003
Module Protheus: SIGAPCP
Sending Type: Synchronous

Message

Tag

Description

Table/Field

Type

Table/Field: PC-Factory

Type

BusinessContentType

Number

Production Order Number

SC2.C2_NUM + SC2.C2_ITEM + SC2.C2_SEQUEN

CHAR(20)

 

 

 

ProductionOrderUniqueID

Company+Branch+Production Order

COMPANY + SC2.C2_FILIAL + SC2.C2_NUM +

SC2.C2_ITEM + SC2.C2_SEQUEN

CHAR(30)

 

 

 

ItemCode

Item Code

SC2.C2_PRODUTO

CHAR(15)

 

 

 

ItemDescription

Item Description

SB1.B1_DESC

CHAR(40)

 

 

 

Type

Order type

1= Internal; 2=External; 3=Internal/External; 4=Rework;

5=Repair; 6=Maintenance; 7=Fixed Asset;

8=Tool Shop; 9=Reuse

 

CHAR(01)

 

 

 

Quantity

Quantity

SC2.C2_QUANT

DEC(12,2)

 

 

 

ReportQuantity

Reported Quantity

SC2.C2QUJE

DEC(12,2)

 

 

 

UnitOfMeasureCode

Measurement Unit

SC2.C2_UM

CHAR(02)

 

 

 

RequestOrderCode

Production Order Code

SC2.C2_PEDIDO

CHAR(06)

 

 

 

StatusOrderType

Order status

Estimated/Opened = 1

Started = 6

Partial/Total Closed = 7

Idle = 9

CHAR(01)

 

 

 

WarehouseCode

Deposit Code

SC2.C2_LOCAL

CHAR(02)

 

 

 

EndOrderDateTime

CP Production Order End Date

SC2.C2_DATPRF

DATE

 

 

 

StartOrderDateTime

CP Production Order Start Date

SC2.C2_DATPRI

DATE

 

 

 

AbbreviationProviderName

Customer Name

SC5.C5_CLIENTE ( SA1.A1_NOME)

CHAR(30)

 

 

 

ScriptCode

Script Code

SC2.C2_ROTEIRO

CHAR(02)

 

 

ListOfActivityOrders

 

 

 

 

 

 

 

ProductionOrderNumber

Production Order

SC2.C2_NUM + SC2.C2_ITEM +

SC2.C2_SEQUEN

CHAR(20)

 

 

 

ActivityID

Record ID

RECNO (SG2,SHY or SH8)

CHAR(10)

 

 

 

ActivityCode

Operation Code

SG2.G2_OPERAC

SHY.HY_OPERAC

SH8.H8_OPER

CHAR(02)

 

 

 

ActivityDescription

Operation Description

SG2.G2_DESCRI

CHAR(40)

 

 

 

Split

Operation split

SH8.H8_DESDOBR

CHAR(04)

 

 

 

ItemCode

Item Code

SC2.C2_PRODUTO

CHAR(15)

 

 

 

ItemDescription

Item Description

SB1.B1_DESC

CHAR(40)

 

 

 

ActivityType

Operation Type

1 - Register ; 2-Does not Register

CHAR(01)

 

 

 

WorkCenterCode

Work Center Code

SG2.G2_CTRAB

SHY.HY_CTRAB

SH8.H8_CTRAB

CHAR(06)

 

 

 

WorkCenterDescription

Work Center Description

SHB.HB_NOME

CHAR(30)

 

 

 

UnitTimeType

Time Unit Type

1 - Hours; 2 - Minutes; 3- Seconds 4 - Days

CHAR(01)

 

 

 

TimeResource

Resource Time (Standard time for a lot)

SG2.G2_TEMPAD

DEC(05,2)

 

 

 

TimeMachine

Machine Time (Time to do all order)

SG2.G2_TEMPAD *SC2.C2_QUANT

SHY.HY_TEMPO 

SH8.H8_HRINI - SH8.H8_HRFIM

DEC(14,4)

 

 

 

TimeSetup

Preparation Time

SG2.G2_SETUP

SHY.HY_TEMPOS

SH8.H8_SETUP

DEC(15,4)

 

 

 

ScriptCode

Script Code

SG2.G2_CODIGO

SHY.HY_ROTEIRO

SH8.H8_ROTEIRO

CHAR(02)

 

 

 

LaborCode

Direct Labor Code

MOD+CC

CHAR(08)

 

 

 

UnitItemNumber

Default Batch

SG2.G2_LOTEPAD

NUM(05)

 

 

 

IsActivityEnd

Last Operation

Last operation, pass TRUE.

In others FALSE.

BOOLEAN

 

 

 

MachineCode

Machine Code

SG2_RECURSO

SHY_RECURSO

H8_RECURSO

CHAR(06)

 

 

 

StartPlanDateTime

Schedule Start Date/Time

SHY.HY_HORAINI

SC2.C2_DATPRI

SH8.H8_DTINI

DATE

 

 

 

EndPlanDateTime

Schedule End Date/Time

SHY.HY_HORAFIM

SC2.C2_DATPRF

SH8.H8_DTFIM

DATE

 

 

 

ProductionQuantity

Quantity to produce in the operation

SHY.HY_QUANT 

SH8.H8_QUANT 

SC2.C2_QUANT

DEC(12,2)

 

 

 

UnitActivityCode

Measurement Unit

SB1.B1_UM

CHAR(02)

 

 

 

SecondUnitActivityCode

Second measure unit in operation

--

 

 

 

 

SecondUnitActivityFactor

Conversion factor for second unit in operation

--

 

 

 

ListOfMaterialOrders

 

 

 

 

 

 

 

ProductionOrderNumber

Production order

SC2.C2_NUM + SC2.C2_ITEM +

SC2.C2_SEQUEN

CHAR(20)

 

 

 

MaterialID

Reservation record ID

SD4.R_E_C_N_O_

CHAR(10)

 

 

 

MaterialCode

Reservation Item Code

SD4.D4_COD

CHAR(15)

 

 

 

MaterialDescription

Item Description

SB1.B1_DESC

CHAR(40)

 

 

 

ScriptCode

Script Code

SD4.D4_ROTEIRO

CHAR(02)

 

 

 

ActivityCode

Operation Code

SD4.D4_OPERAC

CHAR(02)

 

 

 

WarehouseCode

Deposit Code

SD4.D4_LOCAL

CHAR(02)

 

 

 

MaterialDate

Reservation Date

SD4.D4_DATA

DATE

 

 

 

MaterialQuantity

Reservation Quantity

SD4.D4_QUANT

DEC(12,2)

 

 

 

LotCode

Lot

SD4.D4_LOTECTL

CHAR(10)

 

 

 

PertMaterialNumber

Item sequence

SD4.D4_TRT

CHAR(03)

 

 

 

RequestType

Request type

SB1.B1_APROPRI

CHAR(01)

 

 

ListOfAllocatedMaterial

 

 

 

 

 

 

 

 

WarehouseCode

Deposit Code

SD4.D4_LOCAL

CHAR(02)

 

 

 

LotCode

Lot Code

SD4.D4_LOTECTL

SDC.DC_LOTECTL

CHAR(10)

 

 

 

LocationCode

Location/Address

SDC.DC_LOCALIZ

CHAR(15)

 

 

 

ActivityCode

Operation Code

SD4.D4_OPERAC

CHAR(02)

 

 

 

ScriptCode

Script Code

SD4.D4_ROTEIRO

CHAR(02)

 

 

 

 AllocationQuantity

Allocated Quantity

SD4.D4_QUANT 

SDC.DC_QUANT

DEC(12,2)

 

 

 

AllocationType

Allocation Type

1 = Add;2=Reduce;3=Absolut Value

CHAR(01)

 

 

 

SubLotCode

Sub-lot

SD4.D4_NUMLOTE

SDC.DC_NUMLOTE

CHAR(06)

 

 

 

NumberSeries

Serial Number

SDC.DC_NUMSERI

CHAR(20)

 

 

 

LotDueDate

Expiration Date

SD4.D4_DTVALID

DATE

 

 

ListOfQuotaActivity

 

 

 

 

 

 

 

ProductionOrderNumber

Production Order Number

CY9.CY9_NRORPO

CHAR(20)

 

 

 

ControlType

Split Selection

--

 

 

 

 

ActivityID

Operation ID

CY9.CY9_CDAT

CHAR(10)

 

 

 

ItemCode

Item code

CYY.CYY_CDAC

CHAR(15)

 

 

 

ItemDescription

Item Description

CYY.CYY_DSAC

CHAR(40)

 

 

 

StartActivityDateTime

Activity Start Date/Time

CYY.CYY_DTBGAT / CYY.CYY_HRBGAT

DATETIME

 

 

 

EndActivityDateTime

Activity End Date/Time

CYY.CYY_DTEDAT / CYY.CYY_HREDAT

DATETIME

 

 

 

ApprovedQuantity

Approved Quantity

CYY.CYY_QTATAP

DEC(13,4)

 

 

 

ScrapQuantity

Scrap Quantity

CYY.CYY_QTATRF

DEC(13,4)

 

 

 

MachineCode

Machine Code

CYY.CYY_CDMQ

CHAR(20)

 

 

 

MachineDescription

Machine Description

CYY.CYY_DSMQ

CHAR(40)

 

 

 

ActivityQuantity

Expected Quantity

CYY.CYY_QTAT

DEC(12,4)

 

 

 

StandardSetup

Standard Setup Time

CYY.CYY_QTPASU

NUM(10)

 

 

 

StandardActivity

Standard Operation Time

CYY.CYY_QTPAAT

NUM(10)

 

 

 

StandardPostprocessing

Standard Post-process Time

CYY.CYY_QTPAPP

NUM(10)

 

 

 

StandardMachine

Standard Machine Time

CYY.CYY_QTPAMQ

NUM(10)

 

 

 

StandardOperator

Standard Time MOD

CYY.CYY_QTPAOE

NUM(10)

 

 

 

UsedCapacity

Used Capacity

CYY.CYY_QTVMAT

DEC(12,4)

 

 

 

ActivityTimeQuantity

Available Activity Time

CYY.CYY_HRDI

CHAR(08)

 

 

 

ReportQuantity

Reported Quantity

CYY.CYY_QTATRP

DEC(13,4)

 

 

 

ReworkQuantity

Reworked Quantity

CYY.CYY_QTATRT

DEC(12,4)

 

 

 

StartSetupDateTime

Setup Start Date/Time

CYY.CYY_DTBGSU / CYY.CYY_HRBGSU

DATETIME

 

 

 

EndSetupDateTime

Setup End Date/Time

CYY.CYY_DTEDSU / CYY.CYY_HREDSU

DATETIME

 

 

 

TimeSetup

Preparation Time

CY9.CY9_QTTESU

NUM(10)

 

 

 

TimeMachine

Machine Time

CY9.CY9_QTTEMQ

NUM(10)

 

 

 

TimeOperator

Time MOD

CY9.CY9_QTTERC

NUM(10)

 

 

 

TimePostprocessing

Post-processing Time

CY9.CY9_QTTEPP

NUM(10)

 

 

 

QuotaActivityID

ID Split

CYY.CYY_IDATQO

CHAR(05)

 

 

 

WorkCenterCode

Work Center

CY9.CY9_CDCETR

CHAR(10)

 

 

 

ReportedSplit

Reported Split

CYY.CYY_LGQORP

BOOELAN

 

 

 

StatusActivityType

Operation Status

CYY.CYY_TPSTAT

CHAR(01)

 

 

ListOfQuotaActivityTools

 

 

 

 

 

 

 

ToolCode

Tool

CYY.CYY_CDFE

CHAR(20)

 

 

 

ToolQuantity

Tool Quantity

CYY.CYY_QTFE

NUM(03)

 

 

    • The tags not used by PCP Protheus x PC-Factory integration, even in messages, described in Schema of TOTVS Single Message are not mentioned in this document.
    • The tag Type (Order Type) is generated with value "1" - Internal Order.
    • The tag RequestType (Request Type) identifies if the request can be done separately from the production report, according to rule below:
      If parameter MV_REQAUT has 'D' the DIRECT materials are entered and the INDIRECT are automatically loaded;
      If parameter MV_REQAUT has 'A' the consumption of materials is executed in all components;
      This tag has the following values: 1-Direct, 2-Indirect.
    • The tag Allocation Type (Allocation Type) is generated with value "3" - Absolute Order.
    • The session ListOfAllocatedMaterial follows some rules for allocation: 
      If item controls address and did not generate SBC it does not generate data from list  ListOfAllocatedMaterial (verificar only when parameter MV_LOCALIZ = S);
      If item controls trace and did not generate the batch in SD4,  it does not generate data from list ListOfAllocatedMaterial;
      If item does not control address or batch, it must generate data from list  ListOfAllocatedMaterial based on SD4.
    • The tags of operations os session order ListOfActivityOrders can have different origin according to parameterization or executed routines. If you execute the machine MATA690, table SH8 is used. When parameter MV_PCPATOR has 'S', table SHY is used. If parameter MV_PCPATOR has 'N', table SG2 is used. 
    • The tag Split of session ListOfActivityOrders is generated when there is unfolding of operation in several resources. Generated when using Shop Floor.
    • The tag ActivityType (Operation Type) is generated with value '1' - Register;
    • The tag UnitTimeType (Unit Measure Type) is generated with value '1' - Time;
    • The tag UnitItemNumber is used to register the standard batch of operation production.
    • For PC-Factory, indicate in which operation the component is consumed. When component x operation concept is not used, link components in last operation.
    • The tag TimeMachine (Machine Time) indicates time for production order.
      By using parameter MV_PCPATOR the time is SHY.HY_TEMPOM.
      When machine load is used, use the difference between SH8.H8_HRINI and SH8.H8_HRFIM.
      The time can have variation according to Operation Type (when it is not in SHY):
      Operation Type 1 Regular: Apply the batch time the quantity of order. Which are: (SG2.G2_TEMPAD / SG2.G2_LOTEPAD) * SC2.C2_QUANT) / SH1.H1_MAOOBRA. Note: If time and lot are zero, consider 1.
      Operation Type 2 Fixed and 3 Unlimited: Regardless of amount, the time is the same. Which are: SG2.G2_TEMPAD. Note: If zero delivers 1.
      Operation Type 4 Minimum Time: Considers the multiple quantity of batch. Example: Lot = 10. Time = 5. Order Amt. = 7. It must consider time to make 10 spare parts. The same calculation is type 1 Regular.
      Another point to consider is the PC-Factory waits time in Centesimal. When parameter MV_TPHR is other than 'C', time is converted to centesimal.
    • The tag TimeResource (Resource Time) indicates tiem to make standard batch.
    • The tag LaborCode (Labor Code) is indicated by 'MOD' + Cost Center.
    • The session ListOfQuotaActivity is generated only when Shop Floor is active.
    • The tag StatusActivityType has the following values: 1=Not Started;2=Programmed;3=Released;4=Started;5=Finished;6=Suspended


Processes

Production Annotation Transaction: ProductionAppointment_1_001.xsd
Message Identifier: ProductionAppointment
Version: 1_001
Protheus Module: SIGAPCP/SIGASFC
Sending Type: Synchronous 

This message is generated by PC-Factory and sent to Protheus.


 

Message

Tag

Description

Table/Field

Protheus PCP

Table Field

Protheus SFC

Type

Table/Field: PC-Factory

Type

BusinessContentType

MachineCode

Machine

SH6.H6_RECURSO

CYV.CYV_CDMQ

CHAR(06)

 

 

 

ProductionOrderNumber

Production Order

SH6.H6_OP

CYV.CYV_NRORPO

CHAR(20)

 

 

 

ActivityCode

Operation

SH6.H6_OPERAC

CYV.CYV_CDAT

CHAR(02)

 

 

 

Split

Split

SH6.H6_DESDOBR

CYV.CYV_IDATQO

CHAR(04)

 

 

 

ActivityID

Operation ID

--

--

 

 

 

 

ItemCode

Product

SH6.H6_PRODUTO

CYV.CYV_CDACRP

CHAR(15)

 

 

 

ApprovedQuantity

Approved Quantity

SH6.H6_QTDPROD

CYV.CYV_QTATAP

DEC(11,2)

 

 

 

ScrapQuantity

Scrap Quantity

SH6.H6_QTDPERD

CYV.CYV_QTATRF

DEC(11,2)

 

 

 

ReworkQuantity

Reworked Quantity

--

--

 

 

 

 

StartSetupDateTime

Setup Start Date/Time

--

CYV_DTBGSU

CYV_HRBGSU

DATETIME

 

 

 

EndSetupDateTime

Setup End Date/Time

--

CYV_DTEDSU

CYV_HREDSU

DATETIME

 

 

 

SetupCode

Setup Code

--

CYV_CDSU

CHAR(10)

 

 

 

OpTimeInt

Operation Time

--

CYV.CYV_QTTERP

NUM(10)

 

 

 

ProductionShiftCode

Shift Model Code

--

CYV.CYV_CDTN

CHAR(08)

 

 

 

ProductionShiftNumber

Shift Number

--

CYV.CYV_NRTN

CHAR(05)

 

 

 

DocumentCode

Document

--

CYV.CYV_NRDO

CHAR(20)

 

 

 

DocumentSeries

Document Series

--

CYV.CYV_NRSR

CHAR(05)

 

 

 

StartReportDateTime

Report Start Date/Time

SH6.H6_DATAINI

SH6.H6_HORAINI

CYV.CYV_DTRPBG

CYV.CYV_HRRPBG

DATETIME

 

 

 

EndReportDateTime

Report End Date/Time

SH6.H6_DATAFIN

SH6.H6_HORAFIN

CYV.CYV_DTRPED

CYV.CYV_HRRPED

DATETIME

 

 

 

ReversedReport

Annotation Reversal

TRUE or FALSE

TRUE or FALSE

BOOLEAN

 

 

 

ReversalDate

Reversal Date

--

CYV.CYV_DTEO

DATE

 

 

 

ReportDateTime

Report Date/Time

SH6.H6_DTAPONT

CYV.CYV_DTRP

CYV.CYV_HRRP

DATETIME

 

 

 

WarehouseCode

Deposit Code

SH6.H6_LOCAL

CYV.CYV_CDDP

CHAR(02)

 

 

 

LotCode

Lot/Series

SH6.H6_LOTECTL

CYV.CYV_CDLOSR

CHAR(10)

 

 

 

LotDueDate

Lot Validity Date

SH6.H6_DTVALID

CYV.CYV_DTVDLO

DATE

 

 

 

IntegrationReport

Record to be reversed

 

 

CHAR(10)

 

 

 

CloseOperation

Closes Operation

SH6.H6_PT

CYV.CYV_LGEDRP

BOOLEAN

 

 

 

LocationCode

Location

--

CYV.CYV_CDLC

CHAR(20)

 

 

WasteAppointment

 

 

 

 

 

 

 

 

WasteCode

Waste Code

SBC.BC_MOTIVO

CY0.CY0_CDRF

CHAR(02)

 

 

 

WasteDescription

Waste Description

SBC.BC_DESCRI

CY0.CY0_DSRF

CHAR(40)

 

 

 

ScrapQuantity

Scrap Quantity

SBC.BC_QUANT

CY0.CY0_QTRF

DEC(11,2)

 

 

ResourceAppointment

 

 

 

 

 

 

 

 

OperatorCode

Operator Code

--

CYW.CYW_CDOE

CHAR(20)

 

 

 

StartDateTime

Start Date/Time

--

CYW.CYW_DTBGRP

CYW.CYW_HRBGRP

DATETIME

 

 

 

EndDateTime

End Date/Time

--

CYW.CYW_DTEDRP

CYW.CYW_HREDRP

DATETIME

 

 

 

MOBTime

Direct Labor Time

--

CYW.CYW_QTTEOE

NUM(10)

 

 

 

ExtraTime

Over time

--

CYW.CYW_QTTEEX

NUM(10)

 

 

 

UtilTime

Working Time

--

CYW.CYW_QTTEUT

NUM(10)

 

 

 

ProductionShiftCode

Shift Model Code

--

CYW.CYW_CDTN

CHAR(08)

 

 

 

ProductionShiftNumber

Shift Number

--

CYW.CYW_NRTN

CHAR(05)

 

 

SupplyOrder

 

 

 

 

 

 

 

 

ProductionOrderNumber

Production Order Number

SD3.D3_OP

CZP.CZP_NRORPO

CHAR(20)

 

 

 

MaterialCode

Reservation Item Code

SD3.D3_COD

CZP.CZP_CDMT

CHAR(15)

 

 

 

UsedQuantity

Used Quantity

SD3.D3_QUANT

CZP.CZP_QTRPPO

DEC(12,2)

 

 

 

WarehouseCode

Deposit Code

SD3.D3_LOCAL

CZP.CZP_CDDP

CHAR(02)

 

 

 

LocationCode

Location

SD3.D3_LOCALIZ

CZP.CZP_CDLC

CHAR(15)

 

 

 

LotCode

Lot/Series

SD3.D3_LOTECTL

or

SD3.D3_NUMSERI

CZP.CZP_CDLO

CHAR(20)

 

 

 

ActivityCode

Operation Code

--

CZP.CZP_CDAT

CHAR(02)

 

 

 

ScriptCode

Script

--

CZP.CZP_CDRT

CHAR(02)

 

 

ReportToolActivity

 

 

 

 

 

 

 

 

ToolCode

Tool Code

--

CZ0.CZ0_IDFE

CHAR(20)

 

 

    • The default annotation for this integration is MATA681.
    • The fields Machine, Production Order, Operation, Product and Date/Time Report are mandatory.
    • If Report Date/Time is earlier than the current date, the system uses the current Date/Time, that is, date and time the integration is being processed.
    • If the deposit code field is without completion, use the default location of item register(SB1.B1_LOCPAD).
    • The field CloseOperation indicates whether the annotation is TOTAL or PARTIAL. If you send true, it must be T=total. If false, it is considered as P=Partial. 
      The following rule is used to finish the order/production in Protheus is used.
      Close OPERATION: The following TAGS must be entered: ProductionOrderNumber, ActivityCode, CloseOperation (TRUE when TOTAL annotation or closed/finished operation), ReportDateTime. The other quantity fields(ApprovedQuantity and ScrapQuantity) and date/time start/end (StartReportDateTime and EndReportDateTime) must be passed without value (blank)
      Close ORDER: Annotation of quantity in the last operation with tag CloseOperation = TRUE.
    • Every annotation must send a return message, indicating possible problems or processing performed with success. 
      In case of success, the number of annotation is sent to Pc-Factory in the return message of ProductionAnnotation and corresponds to RECNO of SH6. This same number is used when a reverse must be registered(IntegrationReport).
    • The reversal when the field ReversedReport (Annotation Reversal) with content TRUE.
      When is reversal, it must have  the number of annotation, field IntegrationReport. 
    • The reversal can be generated in two ways in the file: only reversal or reversal + annotation. 
      Only reversal: it has approved quantity and zeroed scrap (or without content) and ReversedReport data.
      Reversal + annotation: with ReversedReport indicated and order data and quantity approved or scrap than zero.
    • The field SH6.H6_OBSERVA = 'TOTVSMES' is automatically registered to indicate the record was generated through TOTVSMES integration.
    • The system PC-Factory uses the format of hours with HH:MM:SS. For PCP Protheus, only HH:MM is considered. Annotation with time lower than 1 minute is rejected.
    • Import respects parameters defined in routines MATA681 through function F12 for user "admin".
    • As in PC-Factory, the operation can be issued later to the annotation, the following rule is used:
      The following TAGS must be entered:
      ProductionOrderNumber: Production Order 
      ActivityCode: Operation 
      CloseOperation: True or False. If TRUE when TOTAL annotation or closed/finalized operation. False in case of PARTIAL operation. 
      ReportDateTime: Annotation date.
    • The other quantity fields(ApprovedQuantity and ScrapQuantity) and date/time start/end (StartReportDateTime and EndReportDateTime) must be passed without value (blank)
    • The integration follows the rules and triggers defined by customers. Example: The start and end date/time are not mandatory, but the customer can define the obligatoriness through dictionary making tags to be filled out.
    • If is integrated to Shop Floor SIGASFC, it must save tables in this system. The base will be the process of Annotation Model 2, SFCA316


Consumption notes of components:

 

Shop Floor Notes

 

Scrap Notes

 

Machine Stoppage Annotation Transaction: StopReport_1_001.xsd StopReport_1_001.xsd

Message Identifier: StopReport
Version: 1_001
Protheus Module: SIGAPCP
Sending Type: Synchronous

This message is generated by PC-Factory and sent to Protheus.

Message

Tag

Description

Table/Field

Protheus PCP

Table/Field

Protheus SFC

Type

Table/Field: PC-Factory

Type

 

MachineCode

Machine Code

SH6.H6_RECURSO

CYX.CYX_CDMQ

 

 

 

 

MachineDescription

Machine Description

 

 

 

 

 

 

StopReasonCode

Stoppage Reason Code

SH6.H6_MOTIVO

CYX.CYX_CDSP

 

 

 

 

StopReasonDescription

Stoppage Reason Description

SX5.X5_DESCRI *

CYX.CYX_DSSP

 

 

 

 

StartDateTime

Start Date/Time

SH6.H6_DATAINI

SH6.H6_HORAINI

CYX.CYX_DTBGSP

CYX_HRBGSP

 

 

 

 

EndDateTime

End Date/Time

SH6.H6_DATAFIN

SH6.H6_HORAFIN

CYX.CYX_DTEDSP

CYX.CYX_HREDSP

 

 

 

 

OperatorCode

Operator Code

SH6.H6_OPERADO

CYX.CYX_CDOE

 

 

 

 

ReportDateTime

Report Date/Time

SH6.H6_DTAPONT

CYX.CYX_DTRP

 

 

 

 

ToolCode

Tool Code

-- 

CYX.CYX_CDFEPO

 

 

 

 

ProductionTeamCode

Team Code

--

CYX.CYX_CDGROE

 

 

 

 

StopType

Stop Type (1=Not Programmed;2=Programmed)

--

CYX.CYX_TPSP

 

 

 

 

ReportSequence

ID PC-Factory

--

--

 

 

 

  • The annotation of standard stoppage for this integration is MATA682 in PCP and in Shop Floor the routine is SFCA311.
  • The fields Machine,Stoppage Reason, Start and End Date/Time and Report Date/Time are mandatory.
  • If Report Date/Time is earlier than the current date, the system uses the current Date/Time, that is, date and time the integration is being processed.
  • Stoppage annotation sets SH6.H6_TIPO = 'I'.
  • Product must be labor. Generated by system. Example: SH6.H6_PRODUTO = MOD001
  • The quantity loss is generated by the system. SH6.H6_QTDPERD.
  • The field SH6.H6_IDENT is also generated by the system.
  • The field SH6.H6_TEMPO must be calculated by adapter. It must be the stoppage total time.
  • Stoppage Reason:
    The reason can be registered through integration. It must check the stoppage reason is registered. If not, you must add the reason used in annotation in table SX5.
    Where:
    Code of reason is X5_CHAVE
    Table of reason is '44'.
    For Shop Floor, table - CYN must be generated.
  • Every annotation must send a return message, indicating possible problems or processing performed with success. 
  • In case of success, the number of annotation is sent to PV-Factory in the return message of StopReport and corresponds to RECNO of SH6. This same number is used when a reverse must be registered(IntegrationReport).
  • The reversal when the field ReversedReport (Annotation Reversal) with content TRUE.
    When is reversal, it must have  the number of annotation, field IntegrationReport.
  • The reversal can be generated in two ways in the file: only reversal or reversal + annotation. When the message has the reversal and the annotation only can commit the movements when both are concluded.
    To identify whether the message only has reversal or reversal + annotation, the following status must be checked:
    Only reversal: it only has the information of ReverseReport and IntegrationReport with other tags without data. 
    Reversal + annotation: has ReversedReport and IntegrationReport entered and the other mandatory data (Machine, Stoppage Reason, Start and End Date/Time and Report Date/Time) filled out.
  • The field SH6.H6_OBSERVA = 'PPI' is automatically registered to indicate the record was generated through PCP Protheus x PC-Factory.
  • The system PC-Factory uses the format of hours with HH:MM:SS. For PCP Protheus, only HH:MM is considered. Annotation with time lower than 1 minute is rejected.
  • The field ReportSequence is used to register ID of table registering the stoppage information. It must be used in MATI681CRG entry point.
  • Shift model and number is automatically generated by routine SFCA311. Only when using Shop Floor.
  • If message does not send StopType, it is considered as 2= Not Scheduled. Only when using Shop Floor.
  • Stoppage reasons have different sizes in tables. Validate it if receipt code does not exceed the size of columns in Protheus.
    When it uses the PCP it must validate SX5.X5_CHAVE and SBC.BC_MOTIVO.
    When it uses the SIGASFC validate against the CYO.CYO_CDSF, CY0.CY0_CDSP and SH6.H6_MOTIVO. 

 

Transaction Balance in Stock - Request: StockLevel_2_000.xsd
Message Identifier: StockLevel
Version: 2_000
Protheus Module: SIGAPCP
Sending Type: Synchronous

 

For this type of updating the PC Factory requests balance to Protheus. Message has two parts. Request, in which parameters for balance query and the Return, which has the balance return, are displayed.

This Request is generated by PC-Factory and sent to Protheus. This Return is generated by Protheus to PC-Factory.

 

Request

Message

Tag

Description

Type

ListOfRequest

ItemInternalId

Product code

CHAR(15)

 

ReferenceCode

Reference

CHAR(20)

 

WarehouseInternalId

Code of deposit/stock location/Warehouse

CHAR(10)

 

LotNumber

Lot

CHAR(10)

 

SubLotCode

Sub-lot

CHAR(10)

 

SerialNumber

Serial Number

CHAR(20)

 

Address

Location

CHAR(15)

 

LotExpirationDate

Expiration Date

DATE

    • The search can happen as follows:
      Per Product: It returns information of all location of product stock.
      By Stock Location (Warehouse): It returns information of all products in stock location.
    • By Stock Location (Warehouse) and Product: It returns information on Product of Stock Location defined.
      For other fields, Batch, Sub-Batch, series number, location and validity date consider only if you enter product code. If you send these fields without the product code, it must return error message.
    • The Request may be a request list.


Return

Message

Tag

Description

Table/Field

Type

ReturnContentType

ClosingStockDate

Stock closing date

--

 

ListOfReturnItem

CompanyId

Company

 

 

 

BranchId

Branch

 

 

 

CompanyInternalId

Company+Branch

 

 

 

ItemInternalId

Product code

SB2.B2_COD

CHAR(15)

 

ReferenceCode

Referencia

--

 

 ListOfStockBalance

 

 

 

 

 

WarehouseInternalId

Location of Stock (Warehouse/Deposit)

SB2.B2_LOCAL

CHAR(10)

 

LotNumber

Lot Number

SB8.B8_LOTECTL 

CHAR(10)

 

SubLotCode

Sub-lot

SB8.B8_NUMLOTE

CHAR(10)

 

LotExpirationDate

Expiration date

SB8.B8_DTVALID

DATE

 

SerialNumber

Serial number

SBF.BF_NUMSERI 

CHAR(20)

 

Address

Location

SBF.BF_LOCALIZ

CHAR(15)

 

CurrentStockAmount

Product balance in quantity

SB2.B2_QATU

SB8.B8_SALDO

SBF.BF_QUANT

DEC(17,4)

 

BookedStockAmount

Amount reserved in Stock

SB2.B2_RESERVA

SB8.B8_EMPENHO

SBF.BF_EMPENHO

DEC(17,4)

 

AvailableStockAmount

Available balance of the Product in quantity

SB2.B2_QATU - SB2.B2_RESERVA

SB8.B8_SALDO - SB8.B8_EMPENHO

SBF.BF_QUANT - SBF.BF_EMPENHO

DEC(17,4)

 

UnitItemCost

Product unit price

--

 

 

AverageUnitItemCost

Product average price

--

 

 

ValueOfCurrentStockAmount

Current balance of product stock in value

--

 

 

Stock Movement Transactions:  MovementsInternal_1_001.xsd 
Message Identifier: MovementsInternal
Version: 1_001
Protheus Module: SIGAPCP
Sending Type: Synchronous

Note: This message is generated by PC-Factory and sent to Protheus.

 

Message

Tag

Description

Table/Field

Type

BusinessContentType

CompanyId

Company code

 

 

 

BranchId

Branch

 

 

 

CompanyInternalId

InternalId of full key of company

 

 

 

InternalId

InternalId of movement.

 

 

 

TypeMovementCode

Code of internal movement type

SD3.D3_TM

CHAR(03)

 

EmissionDate

Date of Issue

SD3.D3_EMISSAO

DATE

 

ItemCode

Product Code

SD3.D3_COD

CHAR(15)

 

UnitOfMeasureCode

Unit of Measurement:

SD3.D3_UM

CHAR(02)

 

Quantity

Quantity

SD3.D3_QUANT

DEC(12,2)

 

WarehouseCode

Warehouse Code

SD3.D3_LOCAL

CHAR(02)

 

LotNumber

Lot

SD3.D3_LOTECTL

CHAR(10)

 

SubLotNumber

Sub-lot

SD3.D3_NUMLOTE

CHAR(06)

 

LotExpirationDate

Lot Expiration Date

SD3.D3_DTVALID

DATE

 

Address

Address

SD3.D3_LOCALIZ

CHAR(15)

 

NumberSeries

NumberSeries

SD3.D3_NUMSERI

CHAR(20)

 

InputOrOutput

Input or Output Movement

I=Input / O = Output

CHAR(01)

 

ReferenceCode

Reference

--

 

 

ScriptCode

Script

SD4.D4_ROTEIRO

CHAR(02)

 

ActivityCode

Operation

SD4.D4_OPERAC

CHAR(02)

 

ProductionOrderNumber

Production Order/Document

SD3.D3_OP and SD3.D3_DOC

CHAR(13)

 

FatherItemCode

Parent Item

--

 

  • It registers the movement had origin in integration with PC-Factory. The field SD3.D3_OBSERVA is saved as content "TOTVSMES".
  • If tag InputOrOutput is I (input) it must execute routine MATA250. If O (output), it executes the process of routine MATA240. Different than I or O, reject message.
  • The tag InputOrOutput indicates if it is input or output. Based on this information, consider the type of movement of register PCPA109, folder MOVEMENTS. If input, use field OE_VAR1. If output, use field OE_VAR2.
  • No option of reversal. To execute a reversal process, it must send the opposite movement, that is, to reverse an input, it must send an output movement.
  • For tag ProductionOrderNumber, it is validate if content is production order (SC2), If OP saves in field SD3.D3_OP, otherwise, saves in field SD3.D3_DOC.
  • When Shop Floor is in use, the routine does not allow to execute movement of manual input. Only annotation through Shop Floor.

 

Transaction Transfers:  TransferWarehouse_1_003.xsd 
Message Identifier: TransferWarehouse 
Version: 1_003
Protheus Module: SIGAPCP
Sending Type: Synchronous

Note: This message is generated by PC-Factory and sent to Protheus.

 

Message

Tag

Description

Table/Field

Type

BusinessContentType

CompanyId

Company

 

 

 

BranchId

Branch

 

 

 

CompanyInternalId

InternalId of full key of company

 

 

 

InternalId

InternalId of transfer

 

 

 

Number

movement Number

SD3.D3_NUMSEQ

CHAR(06)

 

RegisterDateTime

Request issue date

SD3.D3_EMISSAO

DATE

TransferWarehouseType

 

 

 

 

 

InternalId

InternalId of transfer

 

 

 

EmissionDate

Date of Issue

SD3.D3_EMISSAO

DATE

 

ItemCodeFrom

Item/Source Product

SD3.D3_COD

CHAR(15)

 

ItemCodeTo

Item/Target Product

SD3.D3_COD

CHAR(15)

 

UnitOfMeasureFrom

Unit of Origin Measurement:

SD3.D3_UM

CHAR(02)

 

UnitOfMeasureTo

Unit of Destination Measurement:

SD3.D3_UM

CHAR(02)

 

Quantity

Quantity

SD3.D3_QUANT

DEC(12,2)

 

WarehouseCodeFrom

Origin Warehouse Code

SD3.D3_LOCAL

CHAR(02)

 

WarehouseCodeTo

Destination Warehouse Code

SD3.D3_LOCAL

CHAR(02)

 

LotNumberFrom

Origin Lot Number

SD3.D3_LOTECTL

CHAR(10)

 

LotNumberTo

Destination Lot Number

SD3.D3_LOTECTL

CHAR(10)

 

SubLotNumber

Sub-lot Number

SD3.D3_NUMLOTE

CHAR(06)

 

LotExpirationDateFrom

Validity Date of Origin Batch

SD3.D3_DTVALID

DATE

 

LotExpirationDateTo

Validity Date of Destination Batch

SD3.D3_DTVALID

DATE

 

AddressFrom

Origin Address

SD3.D3_LOCALIZ

CHAR(15)

 

AddressTo

Destination Address

SD3.D3_LOCALIZ

CHAR(15)

 

NumberSeries

Serial number

SD3.D3_NUMSERI

CHAR(20)

  • It is registered that its origin transfers was through integration with  PC-Factory. The field SD3.D3_OBSERVA is saved as content "TOTVSMES".
  • For transfers, routine MATA261 is executed.
  • No option of reversal. To execute a reversal process, it must send the opposite movement, that is, to reverse a transfer from X to Y, it must send a transfer movement from Y to X.

 

General Limitations/Restrictions

The integration does not contempalte the generation of orders by APs, register through Fluig (WorkFlow) or routines not described in this document.
Build must be equal to or later than 7.00.131227A and date 9/8/2014.

 

Common Situations 

Possible common problematic status that can happen during the work of the integration and how to solve it.

1) When the message is sent to PCP Protheus for PC-Factory, there may be situations in which the WebService is not totally functional. In these cases, a generic error message is displayed on screen:

Unable to execute the connection with WebService of PCFactory. 

To solve this problems, check configurations of destination system, by analyzing the work of the server used for this communication and if it is enabled in WebService address. 

 

2) Customers with changes in dictionary with specific rules affecting the routines listed in this document.

To solve this problem, it must check dictionary and see each case.

 

3)Waiting time of WebService. Due to the fact that some processes take some a long time to be executed, when ERP sends return, WebService may not be waiting.

Change waiting time of WebService PC-Factory.

 

Application support checklist

Verification Checklist: