Páginas filhas
  • DI_PCP_Protheus_PPI_Multitask_Integration

Versões comparadas

Chave

  • Esta linha foi adicionada.
  • Esta linha foi removida.
  • A formatação mudou.

...

MessageTagDescriptionTable/Field: ProtheusTypeTable/Field: PC-FactoryType
BusinessContentTypeWarehouseCodeWarehouse/DepositSBE.BE_LOCATLOCALCHAR(02)TBLInAddress.WarehouseCodeCHAR(15)
 LocationCodeAddress/LocationSBE.BE_LOCATLOCALIZCHAR(15)TBLInAddress.CodeCHAR(15)
 AdressInternalIdFull Key address

 COMPANY + SBE.BE_BRANCH + SBE.BE_LOCAT LOCAL + SBE.BE_LOCATLOCALIZ

   
 AdressStockDescriptionDescription of addressoSBE.BE_DESCRIPCHAR(30)TBLInAddress.ExtCodeCHAR(20)

...

MessageTagDescriptionTable/Field: ProtheusTypeTable/Field: PC-FactoryType
BusinessContentTypeItemCodeCode of productSB2.B2_CODCHAR(15)TBLInMovMat.ProductCodeCHAR(20)
 ItemDescriptionDescription of itemSB1.B1_DESCCHAR(30)  
ListOfStock  

 

   
 ReferenceCodeReference--   
 WarehouseCodeDeposit/Location of stock/WarehouseSB2.B2_LOCATLOCALCHAR(02)TBLInMovMat.WarehouseCodeCHAR(15)
 LotCodeNumber of LotSB8.B8_LOTECTLCHAR(10)TBLInMovMat.LotCodeCHAR(41)
 SubLotCodeSub-LotSB8.B8_NUMBATCHCHAR(06)  
 NumberSeriesNumber of SeriesSBF.BF_NUMSERICHAR(20)  
 AddressCodeAddress/LocationSBF.BF_LOCATLOCALCHAR(15)TBLInMovMat.AddressCodeCHAR(15)
 LotDueDateValidity DateSB8.B8_DTVALIDDATETBLInMovMat.LotDtValidityDATETIME
 CurrentStockAmountBalance of stock

SB2.B2_QATU

SB8.B8_BALANCE

SBF.BF_QUANT

DEC(12,2)  
 BookedStockAmountReserved Quantiy

SB2.B2_RESERVA

SB8.B8_ALLOCATION

SBF.BF_ALLOCATION

DEC(12,2)  
 AvailableStockAmountBalance available

SB2.B2_QATU - SB2.B2_RESERVA

SB8.B8_SALDO - SB8.B8_ALLOCATION

SBF.BF_QUANT - SBF.BF_ALLOCATION

DEC(12,2)  
 
QuantityUpdated
Updated Quantity DEC(12,2)TBLInMovMat.QtyDEC(18,2)
 
InputOutputInput or Output1 = Input or 2 = OutputCHAR(01)TBLInMovMat.ClassificationCHAR(15)

...

MessageTagDescription

Table/Field

TypeTable/Field: PC-FactoryType
BusinessContentTypeNumberNumber Production OrderSC2.C2_NUM + SC2.C2_ITEM + SC2.C2_SEQUENCHAR(20)TBLInWOHD.CodeCHAR(41)
 ProductionOrderUniqueIDCompany+Branch+Production Order

EMPRESA COMPANY + SC2.C2_FILIAL + SC2.C2_NUM +

SC2.C2_ITEM + SC2.C2_SEQUEN

CHAR(30)  
 ItemCodeCode ItemSC2.C2_PRODUTOPRODUCTCHAR(15)TBLInWOHD.ProductCodeCHAR(20)
 ItemDescriptionDescription ItemSB1.B1_DESCCHAR(40)  
 TypeType of Order

1= InternaInternal; 2=ExternaExternal; 3=InternaInternal/ExternaExternal; 4=RetrabalhoRework;

5=ConsertoFixing; 6=ManutençãoMaintenance; 7=Ativo FixoFixed Asset;

8=FerramentariaTooling; 9=ReaproveitamentoReuse

 

CHAR(01)TBLInWOHD.WoTypeCodeCHAR(20)
 QuantityQuantitySC2.C2_QUANTDEC(12,2)TBLInWOHD.TotalQty

 DEC(19,4)

 ReportQuantityQuantity ReportedSC2.C2QUJEDEC(12,2)  
 UnitOfMeasureCodeUnit of MeasureSC2.C2_UMCHAR(02)TBLInWoDet.Unit1CodeCHAR(05)
 RequestOrderCodeRequest Code Production OrderSC2.C2_PEDIDOORDERCHAR(06)  
 StatusOrderTypeOrder Status

PrevistaEstimated/Aberta Opened = 1

Iniciada Started = 6

Encerrada ParcialPartial/Total Closed = 7

Ociosa Idle = 9

CHAR(01)TBLInWOHD.StatusSMALLINT
 WarehouseCodeCódigo DepósitoCode DepositSC2.C2_LOCALCHAR(02)TBLInWOHD.AuxCode1CHAR(20)
 EndOrderDateTimeData Fim Ordem Produção End Date Production Order CPSC2.C2_DATPRFDATETBLInWOHD.DtPlanEndDATETIME
 StartOrderDateTimeData Início Ordem Produção Start Date Production Order CPSC2.C2_DATPRIDATETBLInWOHD.DtPlanStartDATETIME
 AbbreviationProviderNameNome ClienteName CustomerSC5.C5_CLIENTE ( SA1.A1_NOME)CHAR(30)  
 ScriptCodeCódigo RoteiroCode ScriptSC2.C2_ROTEIROSCRIPTCHAR(02)  
 ReportOrderTypeTipo de ReporteType of Report

1 = OrdemOrder; 2 = OperaçõesOperations; 3 = Ponto ControleControl Point; 4 = Item

 

CHAR(01)  
ListOfActivityOrders      
 ProductionOrderNumberOrdem de ProduçãoProduction Order

SC2.C2_NUM + SC2.C2_ITEM +

SC2.C2_SEQUEN

CHAR(20)TBLInWoDet.Wocode

CHAR(10)

 ActivityIDID do Registroof RecordRECNO (SG2,SHY ou SH8)CHAR(10)  
 ActivityCodeCódigo OperaçãoCode Operation

SG2.G2_OPERAC

SHY.HY_OPERAC

SH8.H8_OPER

CHAR(02)TBLInWoDet.WODetCode+Split

 CHAR(10)

 ActivityDescriptionDescrição OperaçãoDescription OperationSG2.G2_DESCRICHAR(40)TBLInWoDet.WODetName

CHAR(30)

 SplitDesdobramento da operaçãoSplit of operationSH8.H8_DESDOBRCHAR(04)  
 ItemCodeCódigo do Code of item

SC2.C2_PRODUTOPRODUCT

CHAR(15)  
 ItemDescriptionDescrição do Description of itemSB1.B1_DESCCHAR(40)  
 ActivityTypeTipo OperaçãoType Operation1 - Aponta Register ; 2-Não ApontaDoes not registerCHAR(01)  
 WorkCenterCodeCódigo Centro de TrabalhoCode Work Center

SG2.G2_CTRAB

SHY.HY_CTRAB

SH8.H8_CTRAB

CHAR(06)TLBInWODet.ManagerGrpCode CHAR(15)
 WorkCenterDescriptionDescrição Centro de TrabalhoDescription Work CenterSHB.HB_NOMECHAR(30)  
 UnitTimeTypeTipo Unidade TempoType Unit Time1 - HorasHours; 2 - MinutosMinutes; 3- SegundosSeconds; 4 - DiasDaysCHAR(01)TLBInWODet.StdSpeedFormat TINYINT
 TimeResourceTempo Recurso (Tempo padrão para um loteTime Resource (Standard time for lot)SG2.G2_TEMPADDEC(05,2)TLBInWODet.StdSpeed DEC(28,23)
 TimeMachineTempo Máquina (Tempo para fazer toda a ordemTime Machine (Time to order)

SG2.G2_TEMPAD * SC2.C2_QUANT

SHY.HY_TEMPOTIME 

SH8.H8_HRINI - SH8.H8_HRFIM

DEC(14,4)

TLBInWODet.StdSpeed

DEC(28,23)
 TimeSetupTempo PreparaçãoTiem Setup

SG2.G2_SETUP

SHY.HY_TEMPOSTIMES

SH8.H8_SETUP

DEC(15,4)TLBInWODet.SetUpTimeINT
 TimeMODTempo HomenTime Man--   
 TimeIndMESIindicador de tempo no Iindicator of time in MES1 = Tempo MáquinaMachine Time; 2 = Tempo mão-de-obraLabor Time; 3 = Escolha pelo Choice by MES.CHAR(01)  
 ScriptCodeCódigo RoteiroCode Script

SG2.G2_CODIGOCODE

SHY.HY_ROTEIROSCRIPT

SH8.H8_ROTEIROSCRIPT

CHAR(02)  
 LaborCodeCódigo Mão de Obra DiretaCode Direct LaborMOD+CCCHAR(08)  
 UnitItemNumberLote PadrãoStandard LotSG2.G2_LOTEPADNUM(05)TLBInWODet.StdSpeedDEC(28,23)
 IsActivityEndÚltima OperaçãoLast Operation

In the last operation, Na última operação passar TRUE.

Nas demais Otherwise, FALSE.

BOOLEANTLBInWODet.ReportTrigger

TINYINT

 MachineCodeCódigo MáquinaMachine Code

SG2_RECURSORESOURCE

SHY_RECURSORESOURCE

H8_RECURSORESOURCE

CHAR(06)  
 StartPlanDateTimeData/Hora Início ProgramaçãoDate/Time Start Schedule

SHY.HY_HORAINI

SC2.C2_DATPRI

SH8.H8_DTINI

DATETLBInWODet.StartPlanDateTimeDATETIME
 EndPlanDateTimeData/Hora Fim ProgramaçãoDate/Time End Schedule

SHY.HY_HORAFIM

SC2.C2_DATPRF

SH8.H8_DTFIM

DATETLBInWODet.EndPlanDateTimeDATETIME
 ProductionQuantityQuantidade a produzir na operaçãoQuantity to produce in operation

SHY.HY_QUANT 

SH8.H8_QUANT 

SC2.C2_QUANT

DEC(12,2)TLBInWODet.Qty DEC(19,4)
 ActivityQuantityQuantidade da operaçãoQuantity of operation

SHY.HY_QUANT 

SH8.H8_QUANT 

SC2.C2_QUANT

DEC(12,2)  
 UnitActivityCodeUnidade de medidaUnit of measureSB1.B1_UMCHAR(02)TLBInWODet.Unit1CodeCHAR(5)
 SecondUnitActivityCodeSegunda unidade de medida na operaçãoSecond unit of measure in operation-- TLBInWODet.Unit2CodeCHAR(5)
 SecondUnitActivityFactorFator de conversão para segunda un. na operaçãoConversor Factor for second unit in operation-- TLBInWODet.Unit2Factor DEC(8,4)
 ResourceQuantityQuantidade de recursosQuantity of resources

SG2.G2_MAOOBRA

SHY.HY_MAOOBRA

NUM(03)  
ListOfMaterialOrders      
 ProductionOrderNumberOrdem de produçãoProduction Order

SC2.C2_NUM + SC2.C2_ITEM +

SC2.C2_SEQUEN

CHAR(20)TBLInBillMat.WocodeCHAR(41)
 MaterialIDID do registro da reservaof reservation recordSD4.R_E_C_N_O_CHAR(10)  
 MaterialCodeCódigo Code Reservation Item ReservaSD4.D4_CODCHAR(15)TBLInBillMat.ProductCodeCHAR(20)
 MaterialDescriptionDescrição do Description of ItemSB1.B1_DESCCHAR(40)  
 ScriptCodeCódigo RoteiroCode ScriptSD4.D4_ROTEIROCHAR(02)  
 ActivityCodeCódigo OperaçãoCode OperationSD4.D4_OPERACCHAR(02)TBLInBillMat.WODetCodeCHAR(10)
 WarehouseCodeCódigo DepósitoCode DepositSD4.D4_LOCALCHAR(02)TBLInBillMat.ExtCodeCHAR(20)
 MaterialDateData ReservaDate ReservationSD4.D4_DATADATE  
 MaterialQuantityQuantidade ReservaQuantity of ReservationSD4.D4_QUANTDEC(12,2)TBLInBillMat.TotalQtyDEC(19,4)
 LotCodeLoteLotSD4.D4_LOTECTLCHAR(10)  
 PertMaterialNumberSequência do Sequence of itemSD4.D4_TRTCHAR(03)  
 RequestTypeTipo da RequisiçãoType of RequestSB1.B1_APROPRICHAR(01)TBLInBillMat.CommentsCHAR(500)
(mais)ListOfAllocatedMaterial

 

      
 WarehouseCodeCódigo DepósitoCode DepositSD4.D4_LOCALCHAR(02)TBLInMovMat.WarehouseCodeCHAR(15)
 LotCodeCódigo LoteCode Lot

SD4.D4_LOTECTL

SDC.DC_LOTECTL

CHAR(10)TBLInMovMat.LotCodeCHAR(41)
 LocationCodeLocalizaçãoLocation/EndereçoAddressSDC.DC_LOCALIZCHAR(15)TBLInMovMat.AddressCodeCHAR(15)
 ActivityCodeCódigo OperaçãoCode OperationSD4.D4_OPERACCHAR(02)TBLInMovMat.WoDetCodeCHAR(10)
 ScriptCodeCódigo RoteiroCode ScriptSD4.D4_ROTEIROCHAR(02)  
 AllocationQuantityQuantidade AlocadaAllocated Quantity

SD4.D4_QUANT 

SDC.DC_QUANT

DEC(12,2)TBLInMovMat.Qty DEC(19,4)
 AllocationTypeTipo AlocaçãoType Allocation

1 = SomaAdds;2=DiminuiDecreases;3=Valor AbsolutoAbsolute Value

CHAR(01)TBLInMovMat.AllocationTypeINT
 SubLoteCodeSub LoteLot

SD4.D4_NUMLOTE

SDC.DC_NUMLOTE

CHAR(06)  
 NumberSeriesNúmero de SerieNumber of SeriesSDC.DC_NUMSERICHAR(20)  
 LotDueDateData de ValidadeValidity DateSD4.D4_DTVALIDDATETBLInMovMat.LotDtValidityDATETIME
ListOfQuotaActivity      
 ProductionOrderNumberNúmero Ordem ProduçãoNumber Production OrderCY9.CY9_NRORPOCHAR(20)  
 ControlTypeSeleção Selection Split--   
 ActivityIDID OperaçãoOperationCY9.CY9_CDATCHAR(10)  
 ItemCodeCódigo do itenCode of itemCYY.CYY_CDACCHAR(15)  
 ItemDescriptionDescrição do Description of itemCYY.CYY_DSACCHAR(40)  
 StartActivityDateTimeData/Hora Início AtividadeDate/Time Start ActivityCYY.CYY_DTBGAT / CYY.CYY_HRBGATDATETIMETBLInWODet.StartPlanDateTimeDATETIME
 EndActivityDateTimeData/Hora Fim AtividadeDate/Time End ActivityCYY.CYY_DTEDAT / CYY.CYY_HREDATDATETIME TBLInWODet.EndPlanDateTimeDATETIME
 ApprovedQuantityQuantidade AprovadaApproved QuantityCYY.CYY_QTATAPDEC(13,4)  
 ScrapQuantityQuantidade RefugadaScrapped QuantityCYY.CYY_QTATRFDEC(13,4)  
 MachineCodeCódigo MáquinaCode MachineCYY.CYY_CDMQCHAR(20)TBLInWODet.ResourceCodeCHAR(15)
 MachineDescriptionDescrição da MáquinaDescription of MachineCYY.CYY_DSMQCHAR(40)  
 ActivityQuantityQuantidade PrevistaEstimated QuantityCYY.CYY_QTATDEC(12,4)TBLInWODet.QTYDEC(19,4)
 StandardSetupTempo Padrão PreparaçãoStandard Time PreparationCYY.CYY_QTPASUNUM(10)  
 StandardActivityTempo Padrão OperaçãoStandard Time OperationCYY.CYY_QTPAATNUM(10)  
 StandardPostprocessingTempo Padrão Pós_processoStandard Time Post_processCYY.CYY_QTPAPPNUM(10)  
 StandardMachineTempo Padrão MáquinaStandard Time MachineCYY.CYY_QTPAMQNUM(10)  
 StandardOperatorTempo Padrão Standard Time MODCYY.CYY_QTPAOENUM(10)  
 UsedCapacityCapacidade UtilizadaCapacity UsedCYY.CYY_QTVMATDEC(12,4)  
 ActivityTimeQuantityHora Disponível AtividadeActivity Available TimeCYY.CYY_HRDICHAR(08)  
 ReportQuantityQuantidade ReportadaReported QuantityCYY.CYY_QTATRPDEC(13,4)  
 ReworkQuantityQuantidade RetrabalhadaReworked QuantityCYY.CYY_QTATRTDEC(12,4)  
 StartSetupDateTimeData/Hora Início PreparaçãoDate/Time Start SetupCYY.CYY_DTBGSU / CYY.CYY_HRBGSUDATETIME  
 EndSetupDateTimeData/Hora Fim PreparaçãoDate/Time End SetupCYY.CYY_DTEDSU / CYY.CYY_HREDSUDATETIME  
 TimeSetupTempo PreparaçãoTime SetupCY9.CY9_QTTESUNUM(10)TBLInWODet.SetUpTimeTINYINT
 TimeMachineTempo MáquinaMachine TimeCY9.CY9_QTTEMQNUM(10)TBLInWODet.StdSpeedDEC(28,23)
 TimeOperatorTempo Time MODCY9.CY9_QTTERCNUM(10)  
 TimePostprocessingTempo Pós ProcessoPost Process TimeCY9.CY9_QTTEPPNUM(10)  
 QuotaActivityIDID SplitCYY.CYY_IDATQOCHAR(05)

ActivityCode+

TBLInWODet.WODetCode
CHAR(10)
 WorkCenterCodeCentro de TrabalhoWork CenterCY9.CY9_CDCETRCHAR(10)TBLInWODet.ManagerGrpCodeCHAR(15)
 ReportedSplitReported Split ReportadoCYY.CYY_LGQORPBOOELAN  
 StatusActivityTypeEstado OperaçãoState OperationCYY.CYY_TPSTATCHAR(01)  
(mais) ListOfQuotaActivityTools      
 ToolCodeFerramentaToolCYY.CYY_CDFECHAR(20)  
 ToolQuantityQuantidade FerramentaQuantity ToolCYY.CYY_QTFENUM(03)  
Nota
titleNotaNote:
    • 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
    • O The co-produto será enviado ao product is sent to PC-Factory na ListOfMaterialOrders, tag MaterialQuantity, e na ListOfAllocatedMaterial, tag AllocationQuantity (quando existir) com quantidade negativa. O PC-Factory deverá enviar ao Protheus na mensagem de apontamento ProductionAppointment na SupplyOrder a the tag UsedQuantity com quantidade negativa, com isso o ERP entenderá que se trata de uma entrada de co-produto no estoque. O tipo de movimento para co-produto, será cadastrado no PCPA109 e deverá ter um conteúdo menor que 500 por se tratar de uma entrada e também deve ser do tipo de DEVOLUÇÃO e o campo Atualiza Empenho deve estar como sim (rotina with negative quantity, then the ERP understands that it is the input of a co-product in stock. The type of transaction for co-product, it is registered in the PCPA109 and must have content lower than 500, as it is an input and must be type RETURN and the field Update Allocation must be yes (routine MATA230).
    •  A tag TimeIndMES deve ser gerada como '3'. 

...

Production Annotation Transaction: ProductionAppointment_2_000.xsd
Message Identifier: ProductionAppointment
Version: 2_003
Protheus Module: SIGAPCP/SIGASFC
Sending Type: Synchronous 


Nota
titleNotaNote:

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


MensagemMessageTagDescriçãoDescription

TabelaTable/CampoField

Protheus PCP

Tabela CampoTable Field

Protheus SFC

TipoTypeTabelaTable/CampoField: PC-FactoryTipo
BusinessContentTypeMachineCodeMáquinaMachineSH6.H6_RECURSORESOURCECYV.CYV_CDMQCHAR(06)TBLOutInteg.ResourceCodeCHAR(15)
 ProductionOrderNumberOrdem de ProduçãoProduction OrderSH6.H6_OPCYV.CYV_NRORPOCHAR(20)TBLOutInteg.WOCodeCHAR(41)
 ActivityCodeOperaçãoOperationSH6.H6_OPERACCYV.CYV_CDATCHAR(02)TBLOutInteg.WODetCodeCHAR(10)
 SplitSplitSH6.H6_DESDOBRCYV.CYV_IDATQOCHAR(04)TBLOutInteg.WODetCodeCHAR(10)
 ActivityIDID OperaçãoOperation----   
 ItemCodeProdutoProductSH6.H6_PRODUTOPRODUCTCYV.CYV_CDACRPCHAR(15)TBLOutInteg.ProductCodeCHAR(20)
 ApprovedQuantityQuantidade AprovadaApproved QuantitySH6.H6_QTDPRODCYV.CYV_QTATAPDEC(11,2)TBLOutInteg.QtyDEC(19,4)
 ScrapQuantityQuantidade RefugadaScrapped QuantitySH6.H6_QTDPERDCYV.CYV_QTATRFDEC(11,2)TBLOutInteg.QtyDEC(19,4)
 ReworkQuantityQuantidade RetrabalhadaReworked Quantity----   
 StartSetupDateTimeData/Hora Início PreparaçãoDate/Time Start Setup--

CYV_DTBGSU

CYV_HRBGSU

DATETIME  
 EndSetupDateTimeData/Hora Fim PreparaçãoDate/Time End Setup--

CYV_DTEDSU

CYV_HREDSU

DATETIME  
 SetupCodeCódigo PreparaçãoSetup Code--CYV_CDSUCHAR(10)  
 OpTimeIntTempo OperaçãoOperation Time--CYV.CYV_QTTERPNUM(10)  
 ProductionShiftCodeCódigo Modelo TurnoCode Shift Model--CYV.CYV_CDTNCHAR(08)  
 ProductionShiftNumberNúmero TurnoShift Number--CYV.CYV_NRTNCHAR(05)TBLOutInteg.ShiftSMALLINT
 DocumentCodeDocumentoDocument--CYV.CYV_NRDOCHAR(20)TBLOutInteg.DocNumberCHAR(20)
 DocumentSeriesSérie DocumentoSeries Document--CYV.CYV_NRSRCHAR(05)  
 StartReportDateTimeData/Hora Início ReporteDate/Time Start Report

SH6.H6_DATAINI

SH6.H6_HORAINI

CYV.CYV_DTRPBG

CYV.CYV_HRRPBG

DATETIMETBLMSGERP.StartDATETIME
 EndReportDateTimeData/Hora Fim ReporteDate/Time End Report

SH6.H6_DATAFIN

SH6.H6_HORAFIN

CYV.CYV_DTRPED

CYV.CYV_HRRPED

DATETIMETBLMSGERP.EndDATETIME
 ReversedReportEstorno do ApontamentoAnnotation ReversalTRUE ou or FALSETRUE ou FALSEBOOLEAN  
 ReversalDateData do estornoReversal Date--CYV.CYV_DTEODATETBLOutInteg.DTEvDATETIME
 ReportDateTimeDataDate/Hora ReporteTime ReportSH6.H6_DTAPONT

CYV.CYV_DTRP

CYV.CYV_HRRP

DATETIMETBLOutInteg.DtEvDATETIME
 WarehouseCodeCódigo DepósitoDepositSH6.H6_LOCALCYV.CYV_CDDPCHAR(02)TBLOutInteg.WarehouseCodeCHAR(15)
 LotCodeLoteLot/SérieSeriesSH6.H6_LOTECTLCYV.CYV_CDLOSRCHAR(10)TBLOutInteg.LotCodeCHAR(41)
 LotDueDateData Validade LoteDate Validity LotSH6.H6_DTVALIDCYV.CYV_DTVDLODATE

TBLLot.DtValidity

DATETIME
 CloseOperationEncerra OperaçãoClose OperationSH6.H6_PTCYV.CYV_LGEDRPBOOLEAN  
 LocationCodeLocalizaçãoLocation--CYV.CYV_CDLCCHAR(20)TBLOutInteg.Address1CodeCHAR(15)
ListOfReversalAppointments       
 IntegrationReportRegistro a ser estornadoRecord to be reversed  CHAR(10)TBLOutInteg.TransacTypeTINYINT
 ReversalTypeTipo do EstornoType of Reversal  CHAR(01)  
 ReversalQuantityQuantidade revertidaQuantity reverted-- DEC(18,4)  
WasteAppointment       
 WasteCodeCódigo RefugoCode Scrap

SBC.BC_MOTIVOREASON

CY0.CY0_CDRFCHAR(02)TBLOutInteg.ScrapCodeCHAR(15)
 WasteDescriptionDescrição RefugoDescription Scrap

SBC.BC_DESCRI

CY0.CY0_DSRFCHAR(40)  
 ScrapQuantityQuantidade RefugadaScrapped Quantity

SBC.BC_QUANT

CY0.CY0_QTRFDEC(11,2)TBLOutInteg.QtyDEC(18,4)
 ScrapProductProduto RefugadoScrapped ProductSBC.BC_PRODUTOPRODUCT--CHAR(15)  
 WareHouseCodeDepósito Produto RefugadoDeposit Scrapped ProductSBC.BC_LOCORIG--CHAR(10)  
 ScrapProductToRefugo GeradoGenerated ScrapSBC.BC_CODDEST--CHAR(15)  
 WareHouseCodeToDepósito do Refugo geradoDeposit of generated scrapSBC.BC_LOCAL--CHAR(10)  
 AdressCodeEndereço OrigemOrigin AddressSBC.BC_LOCALIZ CHAR(15)  
 AdressCodeToEndereço DestinoDestination AddressSBC.BC_LOCDEST CHAR(15)  
 NumberSeriesNúmero de SérieNumber of SeriesSBC.BC_NUMSERI CHAR(20)  
 NumberSeriesToNúmero de Série DestinoNumber of Series DestinationSBC.BC_NSEDEST CHAR(20)  
 LotCodeLoteLotSBC.BC_LOTECTL CHAR(10)  
 SubLoteCodeSub LoteLotSBC.BC_NUMLOTE CHAR(06)  
 LotDueDateData de ValidadeValidity DateSBC.BC_DTVALID DATE  
 CostCenterCodeCentro de CustoCost CenterSBC.BC_CC CHAR(09)  
ResourceAppointment       
 OperatorCodeCódigo OperadorOperator Code--CYW.CYW_CDOECHAR(20)TBLOutInteg.UserCodeCHAR(30)
 StartDateTimeDataStart Date/Hora InícioTime--

CYW.CYW_DTBGRP

CYW.CYW_HRBGRP

DATETIMETBLMSGERP.StartDATETIME
 EndDateTimeDataEnd Date/Hora FimTime--

CYW.CYW_DTEDRP

CYW.CYW_HREDRP

DATETIMETBLMSGERP.EndDATETIME
 MOBTimeTempo Mão de Obra DiretaTime Direct Labor--CYW.CYW_QTTEOENUM(10)  
 ExtraTimeTempo Extra Time--CYW.CYW_QTTEEXNUM(10)  
 UtilTimeTempo ÚtilUseful Time--CYW.CYW_QTTEUTNUM(10)  
 ProductionShiftCodeCódigo Modelo TurnoCode Shift Model--CYW.CYW_CDTNCHAR(08)  
 ProductionShiftNumberNúmero TurnoNumber Shift--CYW.CYW_NRTNCHAR(05)TBLOutInteg.ShiftSMALLINT
SupplyOrder       
 ProductionOrderNumberNúmero Ordem ProduçãoNumber Production OrderSD3.D3_OPCZP.CZP_NRORPOCHAR(20)

TBLOutInteg.WOCode

CHAR(41)
 MaterialCodeCódigo Code Reservation Item ReservaSD3.D3_CODCZP.CZP_CDMTCHAR(15)TBLOutInteg.ProductCodeCHAR(20)
 UsedQuantityQuantidade UtilizadaQuantity UsedSD3.D3_QUANTCZP.CZP_QTRPPODEC(12,2)TBLOutInteg.Qty DEC(19,4)
 WarehouseCodeCódigo DepósitoCode DepositSD3.D3_LOCALCZP.CZP_CDDPCHAR(02)TBLOutInteg.WarehouseCodeCHAR(15)
 LocationCodeLocalizaçãoLocationSD3.D3_LOCALIZCZP.CZP_CDLCCHAR(15)TBLOutInteg.Address1CodeCHAR(15)
 LotCodeLoteLot/SérieSeries

SD3.D3_LOTECTL

ou

SD3.D3_NUMSERI

CZP.CZP_CDLOCHAR(20)TBLOutInteg.LotCodeCHAR(41)
 ActivityCodeCódigo OperaçãoCode Operation--CZP.CZP_CDATCHAR(02)TBLOutInteg.WODetCodeCHAR(10)
 ScriptCodeRoteiroScript--CZP.CZP_CDRTCHAR(02)  
ReportToolActivity       
 ToolCodeCódigo FerramentaCode Tool--CZ0.CZ0_IDFECHAR(20)  
Nota
titleNotaNote:
    • 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. Encerrar a ORDEM: Realizar o encerramento da ordem sem necessidade de informações de apontamento no XML. Considera somente as tags ProductionOrderNumber e CloseOperation(TRUE). Sendo que, deverá verificar se tem apontamento na última operação. Deverá executar o mesmo procedimento da opção "Encerrar" do MATA681. Devendo fazer as movimentações e atualização do campo SC.C2_DATRF.
    • 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. Poderá conter uma lista de Ids(ListOfReversalAppointments) que serão estornados. Pode estornar registros de apontamentos de produção e registros de recusa. Para isso a tag ReversalType indica qual o processo a ser executado, sendo, 1 = Produção; 2 = Recusa
    • 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
    • O subproduto é tratado na The subproduct is handled in the ListOfWasteAppointments, tags ScrapProduct e and ScrapProductTo. As movimentações dependem da parametrizaçãoThe movements depend on the parameterization(F12) do MATA685, que indica se consome o produto origem ou não. Não é obrigatório digitar os produtos refugados refugo gerado. Neste caso vai registrar somente os defeitos.
      Para que o subproduto seja gerado o parâmetro MV_DIGIPER, deve estar setado como of MATA685, indicating whether the origin product is consumed. Do not enter scrapped products generated scrap. In this case, register only the defects.
      For the subproduct to be generated, the parameter MV_DIGIPER, must be set as 'S'.Para o Reaproveitamento, o Refugo gerado deverá ser o mesmo produto da ordem. Nesse caso o que vai mudar será somente o depósito, onde existirá um local próprio para armazenar o refugo. Esta funcionalidade é para
    • empresas que reaproveitam o produto acabado com defeito (sem gerar subproduto) na composição de outro produto.Para este caso o depósito do refugo poderá ser parametrizado no PCPA109. As movimentações dependem da parametrização For Reuse, the generated Scrap must be the same product of the order. In this case, only the deposit will change, in which there will be a own location to store the scrap. This functionality is for companis that resue the finished product with defect (without generating subproduct) in the composition of other product. For this case, the deposit of the scrap can be parameterized in PCPA109. The movements depend on the parameterization (F12) do MATA685. Se esta parametrização estiver como 'S'  a rotina irá baixar o saldo do produto/local origem e acrescentar/gerar o saldo do produto/local destino. Se estiver como 'N' só irá atualizar o saldo do produto/local destinoIf this parameterization is 'S' the routine will download the balance of the product/origin location and add/generate the balance of the product/destination location. If 'N', it will only update the balance of the product/destination location.


Consumption notes of components:

...