Histórico da Página

...

Message	Tag	Description	Table/Field: Protheus PCP	Table Field: Protheus SFC	Type	Table/Field: PC-Factory	Type
*BusinessContentType*
	Code	Resource Code	SH4.H4_CODE	CYH.CYH_CDRC	CHAR(06)	TBLTooling.Code	CHAR(15)
	Name	Resource Name	SH4.H4_DESCRI	CYH.CYH_NMRC	CHAR(40)	TBLTooling.Name	CHAR(50)
	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	TBLTooling.Period	INT
	EndExpirationDate	End Validity Date		CYH.CYH_DTVDED	DATE	TBLTooling.Period	INT
	UnitCycleQuantity	Units Cycles		CYH.CYH_QTUNCI	NUM(07)
	ToolCode	Tool		CYH.CYH_CDMPRC	CHAR(15)
	ToolDescription	Tool Description		CYH.CYH_DSMPRC	CHAR(40)

Nota

title	NotaNote:

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

...

Message	Tag	Description	Table/Field: Protheus	Type	Table/Field: PC-Factory	Type
BusinessContentType	ItemCode	Item Code	SG2.G2_PRODUTOPRODUCT	CHAR(15)	TBLInWOHD.ProductCode TBLInWOHD.WOCode	CHAR(20)
	ItemDescription	Description of item	SB1.B1_DESC	CHAR(40)
	ItemInternalId	Company[Branch\|Item	EMPRESA COMPANY + SG2.G2_FILIAL BRANCH + SG2.G2_PRODUTOPRODUCT
	ScriptCode	Code of Scripto	SG2.G2_CODIGOCODE	CHAR(02)
	ScriptDescription	Description Script	--	CHAR(40)
	ScriptAlternative	Script Alternative	--	CHAR(02)
ListOfActivity
	ActivityInternalID	ID Operation	SG2.R_E_C_N_O_	NUM(05)
	ActivityCode	Code of Operation	SG2.G2_OPERAC	CHAR(02)	TBLInWodet.Code	CHAR(10)
	ActivityDescription	Description Operation	SG2.G2_DESCRI	CHAR(60)	TBLInWodet.Name	CHAR(40)
	MachineCode	Machine Code	SG2.G2_RECURSORESOURCE	CHAR(06)	TBLInWodet.Resource	CHAR(15)
	ToolCode	Code Tool	SG2.G2_FERRAMTOOL	CHAR(06)
	ActivityType	Type Operation	1 = Executa operaçãoExecutes operation; 2 = Não executaDoes not execute.	CHAR(01)
	WorkCenterCode	Code Work Center	SG2.G2_CTRAB	CHAR(06)	TBLInWodet.ManagerGrpCode	CHAR(15)
	WorkCenterInternalId	Id Work Center	EMPRESA COMPANY + SG2.G2_FILIAL BRANCH + SG2.G2_CTRAB
	UnitItemNumber	Standard Lot	SG2.G2_LOTEPAD	NUM(06)	TBLInWodet. StdSpeed	DEC(28,23)
	TimeResource	Time Resource	0		TBLInWodet. StdSpeed	DEC(28,23)
	TimeMachine	Time Machine	SG2.G2_TEMPAD	DEC(05,2)	TBLInWodet. StdSpeed	DEC(28,23)
	TimeSetup	Time Preparation	SG2.G2_SETUP	DEC(05,2)	TBLInWodet. SetUpTime	INT
	UnitTimeType	Type Unit Time	1 = HorasHours;2=MinutosMinutes;3=SegundosSeconds;4=DiasDays		TBLInWodet. StdSpeedFormat	TINYINT
	ScriptAlternative	Alternative	SG2.G2_ROTALT	CHAR(02)
	InitialDate	Initial Date	SG2.G2_DTINI	DATE	TBLInWodet.DtPlanStart	DATETIME
	FinalDate	Final Date	SG2.G2_DTFIM	DATE	TBLInWodet.DtPlanEnd	DATETIME
	PercentageScrapValue	% Scrap	--
	PercentageValue	Proportion	--
	ResourceQuantity	Quantity Resource	--

Nota

title	NotaNote:

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

MensagemMessage	Tag	DescriçãoDescription	TabelaTable/CampoField: Protheus	TipoType	TabelaTable/CampoField: PC-Factory	TipoType
BusinessContentType	WarehouseCode	ArmazémWarehouse/DepósitoDeposit	SBE.BE_LOCALLOCAT	CHAR(02)	TBLInAddress.WarehouseCode	CHAR(15)
	LocationCode	EndereçoAddress/LocalizaçãoLocation	SBE.BE_LOCALIZLOCAT	CHAR(15)	TBLInAddress.Code	CHAR(15)
	AdressInternalId	Chave completa endereço	Full Key address	COMPANY EMPRESA + SBE.BE_FILIAL BRANCH + SBE.BE_LOCAL LOCAT + SBE.BE_LOCALIZLOCAT
	AdressStockDescription	Descrição do endereçoDescription of addresso	SBE.BE_DESCRICDESCRIP	CHAR(30)	TBLInAddress.ExtCode	CHAR(20)

...

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

MensagemMessage	Tag	DescriçãoDescription	TabelaTable/CampoField: Protheus	TipoType	TabelaTable/CampoField: PC-Factory	TipoType
BusinessContentType	ItemCode	Código do produtoCode of product	SB2.B2_COD	CHAR(15)	TBLInMovMat.ProductCode	CHAR(20)
	ItemDescription	Descrição do Description of item	SB1.B1_DESC	CHAR(30)
ListOfStock
	ReferenceCode	ReferênciaReference	--
	WarehouseCode	Depósito/Local de estoqe/ArmazemDeposit/Location of stock/Warehouse	SB2.B2_LOCALLOCAT	CHAR(02)	TBLInMovMat.WarehouseCode	CHAR(15)
	LotCode	Número do LoteNumber of Lot	SB8.B8_LOTECTL	CHAR(10)	TBLInMovMat.LotCode	CHAR(41)
	SubLotCode	Sub-LoteLot	SB8.B8_NUMLOTENUMBATCH	CHAR(06)
	NumberSeries	Número de SérieNumber of Series	SBF.BF_NUMSERI	CHAR(20)
	AddressCode	EndereçoAddress/LocalizaçãoLocation	SBF.BF_LOCALIZLOCAT	CHAR(15)	TBLInMovMat.AddressCode	CHAR(15)
	LotDueDate	Data de ValidadeValidity Date	SB8.B8_DTVALID	DATE	TBLInMovMat.LotDtValidity	DATETIME
	CurrentStockAmount	Saldo de estoqueBalance of stock	SB2.B2_QATU SB8.B8_SALDOBALANCE SBF.BF_QUANT	DEC(12,2)
	BookedStockAmount	Quantidade ReservadaReserved Quantiy	SB2.B2_RESERVA SB8.B8_EMPENHOALLOCATION SBF.BF_EMPENHOALLOCATION	DEC(12,2)
	AvailableStockAmount	Saldo disponívelBalance available	SB2.B2_QATU - SB2.B2_RESERVA SB8.B8_SALDO - SB8.B8_EMPENHOALLOCATION SBF.BF_QUANT - SBF.BF_EMPENHOALLOCATION	DEC(12,2)
	QuantityUpdated	Quantidade AtualizadaUpdated Quantity		DEC(12,2)	TBLInMovMat.Qty	DEC(18,2)
	InputOutput	Entrada ou SaídaInput or Output	1 = Entrada ou Input or 2 = SaídaOutput	CHAR(01)	TBLInMovMat.Classification	CHAR(15)

Nota

title	NotaNote:

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.

...

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

MessageMensagem	Tag	DescriçãoDescription	TabelaTable/CampoField: Protheus PCP	Tabela CampoTable Field: Protheus SFC	TipoType	TabelaTable/CampoField: PC-Factory	TipoType
BusinessContentType	Code	Código RefugoScrap Code	SX5.X5_CHAVEKEY	CYO.CYO_CDRF	CHAR(08)	TBLOutScrap.Code	CHAR(15)
	Description	Descrição do RefugoDescription of Scrap	X5_DESCRI X5_DESCSPA X5_DESCENG	CYO.CYO_DSRF	CHAR(40)	TBLOutScrap.Name	CHAR(30)
	IsRework	RetrabalhoRework		CYO.CYO_LGRT	BOOLEAN
	IsScrapMaterial	Refugo Material Scrap	SBE.BE_DESCRIC	CYO.CYO_LGRFMP	BOOLEAN

Nota

title	NotaNote:

- 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.

...

Message	Tag	Description	Table/Field: Protheus PCP	Table Field: Protheus SFC	Type	Table/Field: PC-Factory	Type
*BusinessContentType*	Code	Stoppage Reason Code	SX5.X5_CHAVEKEY	CYN.CYN_CDSP	CHAR(10)	TBLOutResourceStatus.Code	CHAR(05)
	Description	Stoppage Description	X5_DESCRI X5_DESCSPA X5_DESCENG	CYN.CYN_DSSP	CHAR(40)	TBLOutResourceStatus.Name	CHAR(30)
	IsEfficiency	Change Efficiency	--	--
	IsEmailEquipment	E-mail Planner	--	--
	IsServiceRequest	Issue Service Request	--	--
	IsSetup	Setup Stoppage	--	--		TBLOutResourceStatus.FlgSetup	SMALLINT

Nota

title	NotaNote:

- 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

...

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

MessageMesagem	Tag	DescriçãoDescription	TabelaTable/CampoField	TipoType	TabelaTable/CampoField: PC-Factory	TipoType
BusinessContentType	Number	Número Ordem ProduçãoNumber Production Order	SC2.C2_NUM + SC2.C2_ITEM + SC2.C2_SEQUEN	CHAR(20)	TBLInWOHD.Code	CHAR(41)
	ProductionOrderUniqueID	EmpresaCompany+FilialBranch+Ordem ProduçãoProduction Order	EMPRESA + SC2.C2_FILIAL + SC2.C2_NUM + SC2.C2_ITEM + SC2.C2_SEQUEN	CHAR(30)
	ItemCode	Código Code Item	SC2.C2_PRODUTO	CHAR(15)	TBLInWOHD.ProductCode	CHAR(20)
	ItemDescription	Descrição Description Item	SB1.B1_DESC	CHAR(40)
	Type	Tipo da OrdemType of Order	1= Interna; 2=Externa; 3=Interna/Externa; 4=Retrabalho; 5=Conserto; 6=Manutenção; 7=Ativo Fixo; 8=Ferramentaria; 9=Reaproveitamento	CHAR(01)	TBLInWOHD.WoTypeCode	CHAR(20)
	Quantity	QuantidadeQuantity	SC2.C2_QUANT	DEC(12,2)	TBLInWOHD.TotalQty	DEC(19,4)
	ReportQuantity	Quantidade ReportadaQuantity Reported	SC2.C2QUJE	DEC(12,2)
	UnitOfMeasureCode	Unidade MedidaUnit of Measure	SC2.C2_UM	CHAR(02)	TBLInWoDet.Unit1Code	CHAR(05)
	RequestOrderCode	Código Pedido Ordem ProduçãoRequest Code Production Order	SC2.C2_PEDIDO	CHAR(06)
	StatusOrderType	Estado da ordemOrder Status	Prevista/Aberta = 1 Iniciada = 6 Encerrada Parcial/Total = 7 Ociosa = 9	CHAR(01)	TBLInWOHD.Status	SMALLINT
	WarehouseCode	Código Depósito	SC2.C2_LOCAL	CHAR(02)	TBLInWOHD.AuxCode1	CHAR(20)
	EndOrderDateTime	Data Fim Ordem Produção CP	SC2.C2_DATPRF	DATE	TBLInWOHD.DtPlanEnd	DATETIME
	StartOrderDateTime	Data Início Ordem Produção CP	SC2.C2_DATPRI	DATE	TBLInWOHD.DtPlanStart	DATETIME
	AbbreviationProviderName	Nome Cliente	SC5.C5_CLIENTE ( SA1.A1_NOME)	CHAR(30)
	ScriptCode	Código Roteiro	SC2.C2_ROTEIRO	CHAR(02)
	ReportOrderType	Tipo de Reporte	1 = Ordem; 2 = Operações; 3 = Ponto Controle; 4 = Item	CHAR(01)
ListOfActivityOrders
	ProductionOrderNumber	Ordem de Produção	SC2.C2_NUM + SC2.C2_ITEM + SC2.C2_SEQUEN	CHAR(20)	TBLInWoDet.Wocode	CHAR(10)
	ActivityID	ID do Registro	RECNO (SG2,SHY ou SH8)	CHAR(10)
	ActivityCode	Código Operação	SG2.G2_OPERAC SHY.HY_OPERAC SH8.H8_OPER	CHAR(02)	TBLInWoDet.WODetCode+Split	CHAR(10)
	ActivityDescription	Descrição Operação	SG2.G2_DESCRI	CHAR(40)	TBLInWoDet.WODetName	CHAR(30)
	Split	Desdobramento da operação	SH8.H8_DESDOBR	CHAR(04)
	ItemCode	Código do item	SC2.C2_PRODUTO	CHAR(15)
	ItemDescription	Descrição do item	SB1.B1_DESC	CHAR(40)
	ActivityType	Tipo Operação	1 - Aponta ; 2-Não Aponta	CHAR(01)
	WorkCenterCode	Código Centro de Trabalho	SG2.G2_CTRAB SHY.HY_CTRAB SH8.H8_CTRAB	CHAR(06)	TLBInWODet.ManagerGrpCode	CHAR(15)
	WorkCenterDescription	Descrição Centro de Trabalho	SHB.HB_NOME	CHAR(30)
	UnitTimeType	Tipo Unidade Tempo	1 - Horas; 2 - Minutos; 3- Segundos; 4 - Dias	CHAR(01)	TLBInWODet.StdSpeedFormat	TINYINT
	TimeResource	Tempo Recurso (Tempo padrão para um lote)	SG2.G2_TEMPAD	DEC(05,2)	TLBInWODet.StdSpeed	DEC(28,23)
	TimeMachine	Tempo Máquina (Tempo para fazer toda a ordem)	SG2.G2_TEMPAD * SC2.C2_QUANT SHY.HY_TEMPO SH8.H8_HRINI - SH8.H8_HRFIM	DEC(14,4)	TLBInWODet.StdSpeed	DEC(28,23)
	TimeSetup	Tempo Preparação	SG2.G2_SETUP SHY.HY_TEMPOS SH8.H8_SETUP	DEC(15,4)	TLBInWODet.SetUpTime	INT
	TimeMOD	Tempo Homen	--
	TimeIndMES	Iindicador de tempo no MES	1 = Tempo Máquina; 2 = Tempo mão-de-obra; 3 = Escolha pelo MES.	CHAR(01)
	ScriptCode	Código Roteiro	SG2.G2_CODIGO SHY.HY_ROTEIRO SH8.H8_ROTEIRO	CHAR(02)
	LaborCode	Código Mão de Obra Direta	MOD+CC	CHAR(08)
	UnitItemNumber	Lote Padrão	SG2.G2_LOTEPAD	NUM(05)	TLBInWODet.StdSpeed	DEC(28,23)
	IsActivityEnd	Última Operação	Na última operação passar TRUE. Nas demais FALSE.	BOOLEAN	TLBInWODet.ReportTrigger	TINYINT
	MachineCode	Código Máquina	SG2_RECURSO SHY_RECURSO H8_RECURSO	CHAR(06)
	StartPlanDateTime	Data/Hora Início Programação	SHY.HY_HORAINI SC2.C2_DATPRI SH8.H8_DTINI	DATE	TLBInWODet.StartPlanDateTime	DATETIME
	EndPlanDateTime	Data/Hora Fim Programação	SHY.HY_HORAFIM SC2.C2_DATPRF SH8.H8_DTFIM	DATE	TLBInWODet.EndPlanDateTime	DATETIME
	ProductionQuantity	Quantidade a produzir na operação	SHY.HY_QUANT SH8.H8_QUANT SC2.C2_QUANT	DEC(12,2)	TLBInWODet.Qty	DEC(19,4)
	ActivityQuantity	Quantidade da operação	SHY.HY_QUANT SH8.H8_QUANT SC2.C2_QUANT	DEC(12,2)
	UnitActivityCode	Unidade de medida	SB1.B1_UM	CHAR(02)	TLBInWODet.Unit1Code	CHAR(5)
	SecondUnitActivityCode	Segunda unidade de medida na operação	--		TLBInWODet.Unit2Code	CHAR(5)
	SecondUnitActivityFactor	Fator de conversão para segunda un. na operação	--		TLBInWODet.Unit2Factor	DEC(8,4)
	ResourceQuantity	Quantidade de recursos	SG2.G2_MAOOBRA SHY.HY_MAOOBRA	NUM(03)
ListOfMaterialOrders
	ProductionOrderNumber	Ordem de produção	SC2.C2_NUM + SC2.C2_ITEM + SC2.C2_SEQUEN	CHAR(20)	TBLInBillMat.Wocode	CHAR(41)
	MaterialID	ID do registro da reserva	SD4.R_E_C_N_O_	CHAR(10)
	MaterialCode	Código Item Reserva	SD4.D4_COD	CHAR(15)	TBLInBillMat.ProductCode	CHAR(20)
	MaterialDescription	Descrição do Item	SB1.B1_DESC	CHAR(40)
	ScriptCode	Código Roteiro	SD4.D4_ROTEIRO	CHAR(02)
	ActivityCode	Código Operação	SD4.D4_OPERAC	CHAR(02)	TBLInBillMat.WODetCode	CHAR(10)
	WarehouseCode	Código Depósito	SD4.D4_LOCAL	CHAR(02)	TBLInBillMat.ExtCode	CHAR(20)
	MaterialDate	Data Reserva	SD4.D4_DATA	DATE
	MaterialQuantity	Quantidade Reserva	SD4.D4_QUANT	DEC(12,2)	TBLInBillMat.TotalQty	DEC(19,4)
	LotCode	Lote	SD4.D4_LOTECTL	CHAR(10)
	PertMaterialNumber	Sequência do item	SD4.D4_TRT	CHAR(03)
	RequestType	Tipo da Requisição	SB1.B1_APROPRI	CHAR(01)	TBLInBillMat.Comments	CHAR(500)
ListOfAllocatedMaterial
	WarehouseCode	Código Depósito	SD4.D4_LOCAL	CHAR(02)	TBLInMovMat.WarehouseCode	CHAR(15)
	LotCode	Código Lote	SD4.D4_LOTECTL SDC.DC_LOTECTL	CHAR(10)	TBLInMovMat.LotCode	CHAR(41)
	LocationCode	Localização/Endereço	SDC.DC_LOCALIZ	CHAR(15)	TBLInMovMat.AddressCode	CHAR(15)
	ActivityCode	Código Operação	SD4.D4_OPERAC	CHAR(02)	TBLInMovMat.WoDetCode	CHAR(10)
	ScriptCode	Código Roteiro	SD4.D4_ROTEIRO	CHAR(02)
	AllocationQuantity	Quantidade Alocada	SD4.D4_QUANT SDC.DC_QUANT	DEC(12,2)	TBLInMovMat.Qty	DEC(19,4)
	AllocationType	Tipo Alocação	1 = Soma;2=Diminui;3=Valor Absoluto	CHAR(01)	TBLInMovMat.AllocationType	INT
	SubLoteCode	Sub Lote	SD4.D4_NUMLOTE SDC.DC_NUMLOTE	CHAR(06)
	NumberSeries	Número de Serie	SDC.DC_NUMSERI	CHAR(20)
	LotDueDate	Data de Validade	SD4.D4_DTVALID	DATE	TBLInMovMat.LotDtValidity	DATETIME
ListOfQuotaActivity
	ProductionOrderNumber	Número Ordem Produção	CY9.CY9_NRORPO	CHAR(20)
	ControlType	Seleção Split	--
	ActivityID	ID Operação	CY9.CY9_CDAT	CHAR(10)
	ItemCode	Código do iten	CYY.CYY_CDAC	CHAR(15)
	ItemDescription	Descrição do item	CYY.CYY_DSAC	CHAR(40)
	StartActivityDateTime	Data/Hora Início Atividade	CYY.CYY_DTBGAT / CYY.CYY_HRBGAT	DATETIME	TBLInWODet.StartPlanDateTime	DATETIME
	EndActivityDateTime	Data/Hora Fim Atividade	CYY.CYY_DTEDAT / CYY.CYY_HREDAT	DATETIME	TBLInWODet.EndPlanDateTime	DATETIME
	ApprovedQuantity	Quantidade Aprovada	CYY.CYY_QTATAP	DEC(13,4)
	ScrapQuantity	Quantidade Refugada	CYY.CYY_QTATRF	DEC(13,4)
	MachineCode	Código Máquina	CYY.CYY_CDMQ	CHAR(20)	TBLInWODet.ResourceCode	CHAR(15)
	MachineDescription	Descrição da Máquina	CYY.CYY_DSMQ	CHAR(40)
	ActivityQuantity	Quantidade Prevista	CYY.CYY_QTAT	DEC(12,4)	TBLInWODet.QTY	DEC(19,4)
	StandardSetup	Tempo Padrão Preparação	CYY.CYY_QTPASU	NUM(10)
	StandardActivity	Tempo Padrão Operação	CYY.CYY_QTPAAT	NUM(10)
	StandardPostprocessing	Tempo Padrão Pós_processo	CYY.CYY_QTPAPP	NUM(10)
	StandardMachine	Tempo Padrão Máquina	CYY.CYY_QTPAMQ	NUM(10)
	StandardOperator	Tempo Padrão MOD	CYY.CYY_QTPAOE	NUM(10)
	UsedCapacity	Capacidade Utilizada	CYY.CYY_QTVMAT	DEC(12,4)
	ActivityTimeQuantity	Hora Disponível Atividade	CYY.CYY_HRDI	CHAR(08)
	ReportQuantity	Quantidade Reportada	CYY.CYY_QTATRP	DEC(13,4)
	ReworkQuantity	Quantidade Retrabalhada	CYY.CYY_QTATRT	DEC(12,4)
	StartSetupDateTime	Data/Hora Início Preparação	CYY.CYY_DTBGSU / CYY.CYY_HRBGSU	DATETIME
	EndSetupDateTime	Data/Hora Fim Preparação	CYY.CYY_DTEDSU / CYY.CYY_HREDSU	DATETIME
	TimeSetup	Tempo Preparação	CY9.CY9_QTTESU	NUM(10)	TBLInWODet.SetUpTime	TINYINT
	TimeMachine	Tempo Máquina	CY9.CY9_QTTEMQ	NUM(10)	TBLInWODet.StdSpeed	DEC(28,23)
	TimeOperator	Tempo MOD	CY9.CY9_QTTERC	NUM(10)
	TimePostprocessing	Tempo Pós Processo	CY9.CY9_QTTEPP	NUM(10)
	QuotaActivityID	ID Split	CYY.CYY_IDATQO	CHAR(05)	ActivityCode+ TBLInWODet.WODetCode	CHAR(10)
	WorkCenterCode	Centro de Trabalho	CY9.CY9_CDCETR	CHAR(10)	TBLInWODet.ManagerGrpCode	CHAR(15)
	ReportedSplit	Split Reportado	CYY.CYY_LGQORP	BOOELAN
	StatusActivityType	Estado Operação	CYY.CYY_TPSTAT	CHAR(01)
ListOfQuotaActivityTools
	ToolCode	Ferramenta	CYY.CYY_CDFE	CHAR(20)
	ToolQuantity	Quantidade Ferramenta	CYY.CYY_QTFE	NUM(03)

...

Atalhos

Páginas filhas

Versões comparadas

Versão antiga 11

Nova versão 12

Chave