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.
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:
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.
Integration does not contemplate the generation of orders by APS. |
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=*******
The PCP Protheus x PC-Factory PPI-Multitask is activated through the following steps:
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:
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.
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. |
The following transactions are exchanged between TOTVS and PPI-Multitask:
Method | ID | Description | Origin | Destination | XSD (versions may vary) | Programs | Table |
Registers | 01 | Product | Protheus | PC-Factory | Item_3_001.xsd | MATA010 | SB1 |
02 | Stock Location | Protheus | PC-Factory | Warehouse_1_001.xsd | AGRA045 | NNR | |
03 | Machines | Protheus | PC-Factory | Machine_1_000.xsd | MATA610 SFCA002 | SH1 CYB | |
04 | Resources | Protheus | PC-Factory | Resource_1_000 | MATA620 SFCA006 | SH4 CYH | |
05 | Structure | Protheus | PC-Factory | ItemStructure_1_000 | MATA200 | SG1 | |
06 | Script | Protheus | PC-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 | |
08 | Address | Protheus | PC-Factory | AddressStock_1_000 | MATA015 | SBE | |
09 | Stock | Protheus | PC-Factory | ItemStockLevel_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 |
10 | Reason of Scrap | PC-Factory | Protheus | WasteReason_1_000 | CFGX016 SFCA003 | SX5 CYO | |
11 | Annotation of Production | PC-Factory | Protheus | ProductionAppointment_2_000 | MATA681 SFCA316 | SH6 SD3 CYV | |
12 | Annotation of Stoppage | PC-Factory | Protheus | StopReport_1_001 | MATA682 SFCA311 | SH6 CYX | |
13 | Stock - Request | PC-Factory | Protheus | StockLevel_2_00 | SB2 SB8 SBF | ||
14 | Movements | PC-Factory | Protheus | MovementsInternal_1_001 | MATA240 MATA250 | SD3 | |
15 | Transfer | PC-Factory | Protheus | TransferWarehouse_1_003 | MATA261 | SD3 | |
16 | Refusal | PC-Factory | Protheus | Refusal_1_000 | MATA685 | SBC |
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) |
|
|
|
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 | -- |
|
|
|
|
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) |
|
|
|
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 |
|
|
|
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 | -- | -- |
|
|
|
|
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) |
|
|
|
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) |
|
|
|
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 | -- | -- |
|
|
|
|
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 |
|
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 | -- |
|
|
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) |
|
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.
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: