Histórico da Página

...

Message	Tag	Description	Table/Field: Protheus	Type	Table/Field: PC-Factory	Type
BusinessContentType	WarehouseCode	Warehouse/Deposit	SBE.BE_LOCAL	CHAR(02)	TBLInAddress.WarehouseCode	CHAR(15)
	LocationCode	Address/Location	SBE.BE_LOCALIZ	CHAR(15)	TBLInAddress.Code	CHAR(15)
	AdressInternalId	Full Key address	COMPANY + SBE.BE_BRANCH + SBE.BE_LOCAL + SBE.BE_LOCALIZ
	AdressStockDescription	Description of addressoaddress	SBE.BE_DESCRIP	CHAR(30)	TBLInAddress.ExtCode	CHAR(20)

...

Message	Tag	Description	Table/Field: Protheus	Type	Table/Field: PC-Factory	Type
BusinessContentType	ItemCode	Code of product	SB2.B2_COD	CHAR(15)	TBLInMovMat.ProductCode	CHAR(20)
	ItemDescription	Description of item	SB1.B1_DESC	CHAR(30)
ListOfStock
	ReferenceCode	Reference	--
	WarehouseCode	Deposit/Location of stock/Warehouse	SB2.B2_LOCAL	CHAR(02)	TBLInMovMat.WarehouseCode	CHAR(15)
	LotCode	Number of Lot	SB8.B8_LOTECTL	CHAR(10)	TBLInMovMat.LotCode	CHAR(41)
	SubLotCode	Sub-Lot	SB8.B8_NUMBATCH	CHAR(06)
	NumberSeries	Number of Series	SBF.BF_NUMSERI	CHAR(20)
	AddressCode	Address/Location	SBF.BF_LOCAL	CHAR(15)	TBLInMovMat.AddressCode	CHAR(15)
	LotDueDate	Validity Date	SB8.B8_DTVALID	DATE	TBLInMovMat.LotDtValidity	DATETIME
	CurrentStockAmount	Balance of stock	SB2.B2_QATU SB8.B8_BALANCE SBF.BF_QUANT	DEC(12,2)
	BookedStockAmount	Reserved Quantiy	SB2.B2_RESERVARESERVATION SB8.B8_ALLOCATION SBF.BF_ALLOCATION	DEC(12,2)
	AvailableStockAmount	Balance 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.Qty	DEC(18,2)
	InputOutput	Input or Output	1 = Input or 2 = Output	CHAR(01)	TBLInMovMat.Classification	CHAR(15)

...

Nota

title	Note:

- 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 TABLE = '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_MOTIVOREASON.

Stop Reason Transaction: StopReason_1_000.xsd

...

Nota

title	Note:

- 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_MOTIVOREASON
  When it uses the SIGASFC validate against the CYN.CYN_CDSP, CYX.CYX_CDSP and SH6.H6_MOTIVOREASON

Production Order Transaction: ProductionOrder_2_004.xsd

...

Message	Tag	Description	Table/Field	Type	Table/Field: PC-Factory	Type
BusinessContentType	Number	Number Production Order	SC2.C2_NUM + SC2.C2_ITEM + SC2.C2_SEQUEN	CHAR(20)	TBLInWOHD.Code	CHAR(41)
	ProductionOrderUniqueID	Company+Branch+Production Order	COMPANY + SC2.C2_FILIAL BRANCH + SC2.C2_NUM + SC2.C2_ITEM + SC2.C2_SEQUEN	CHAR(30)
	ItemCode	Code Item	SC2.C2_PRODUCT	CHAR(15)	TBLInWOHD.ProductCode	CHAR(20)
	ItemDescription	Description Item	SB1.B1_DESC	CHAR(40)
	Type	Type of Order	1= Internal; 2=External; 3=Internal/External; 4=Rework; 5=Fixing; 6=Maintenance; 7=Fixed Asset; 8=Tooling; 9=Reuse	CHAR(01)	TBLInWOHD.WoTypeCode	CHAR(20)
	Quantity	Quantity	SC2.C2_QUANT	DEC(12,2)	TBLInWOHD.TotalQty	DEC(19,4)
	ReportQuantity	Quantity Reported	SC2.C2QUJE	DEC(12,2)
	UnitOfMeasureCode	Unit of Measure	SC2.C2_UM	CHAR(02)	TBLInWoDet.Unit1Code	CHAR(05)
	RequestOrderCode	Request Code Production Order	SC2.C2_ORDER	CHAR(06)
	StatusOrderType	Order Status	Estimated/Opened = 1 Started = 6 Partial/Total Closed = 7 Idle = 9	CHAR(01)	TBLInWOHD.Status	SMALLINT
	WarehouseCode	Code Deposit	SC2.C2_LOCAL	CHAR(02)	TBLInWOHD.AuxCode1	CHAR(20)
	EndOrderDateTime	End Date Production Order CP	SC2.C2_DATPRF	DATE	TBLInWOHD.DtPlanEnd	DATETIME
	StartOrderDateTime	Start Date Production Order CP	SC2.C2_DATPRI	DATE	TBLInWOHD.DtPlanStart	DATETIME
	AbbreviationProviderName	Name Customer	SC5.C5_CLIENTE ( SA1.A1_NOME)	CHAR(30)
	ScriptCode	Code Script	SC2.C2_SCRIPT	CHAR(02)
	ReportOrderType	Type of Report	1 = Order; 2 = Operations; 3 = Control Point; 4 = Item	CHAR(01)
ListOfActivityOrders
	ProductionOrderNumber	Production Order	SC2.C2_NUM + SC2.C2_ITEM + SC2.C2_SEQUEN	CHAR(20)	TBLInWoDet.Wocode	CHAR(10)
	ActivityID	ID of Record	RECNO (SG2,SHY ou SH8)	CHAR(10)
	ActivityCode	Code Operation	SG2.G2_OPERAC SHY.HY_OPERAC SH8.H8_OPER	CHAR(02)	TBLInWoDet.WODetCode+Split	CHAR(10)
	ActivityDescription	Description Operation	SG2.G2_DESCRI	CHAR(40)	TBLInWoDet.WODetName	CHAR(30)
	Split	Split of operation	SH8.H8_DESDOBR	CHAR(04)
	ItemCode	Code of item	SC2.C2_PRODUCT	CHAR(15)
	ItemDescription	Description of item	SB1.B1_DESC	CHAR(40)
	ActivityType	Type Operation	1 - Register ; 2-Does not register	CHAR(01)
	WorkCenterCode	Code Work Center	SG2.G2_CTRAB SHY.HY_CTRAB SH8.H8_CTRAB	CHAR(06)	TLBInWODet.ManagerGrpCode	CHAR(15)
	WorkCenterDescription	Description Work Center	SHB.HB_NOME	CHAR(30)
	UnitTimeType	Type Unit Time	1 - Hours; 2 - Minutes; 3- Seconds; 4 - Days	CHAR(01)	TLBInWODet.StdSpeedFormat	TINYINT
	TimeResource	Time Resource (Standard time for lot)	SG2.G2_TEMPAD	DEC(05,2)	TLBInWODet.StdSpeed	DEC(28,23)
	TimeMachine	Time Machine (Time to order)	SG2.G2_TEMPAD * SC2.C2_QUANT SHY.HY_TIME SH8.H8_HRINI - SH8.H8_HRFIM	DEC(14,4)	TLBInWODet.StdSpeed	DEC(28,23)
	TimeSetup	Tiem Setup	SG2.G2_SETUP SHY.HY_TIMES SH8.H8_SETUP	DEC(15,4)	TLBInWODet.SetUpTime	INT
	TimeMOD	Time Man	--
	TimeIndMES	Iindicator of time in MES	1 = Machine Time; 2 = Labor Time; 3 = Choice by MES.	CHAR(01)
	ScriptCode	Code Script	SG2.G2_CODE SHY.HY_SCRIPT SH8.H8_SCRIPT	CHAR(02)
	LaborCode	Code Direct Labor	MOD+CC	CHAR(08)
	UnitItemNumber	Standard Lot	SG2.G2_LOTEPAD	NUM(05)	TLBInWODet.StdSpeed	DEC(28,23)
	IsActivityEnd	Last Operation	In the last operation, TRUE. Otherwise, FALSE.	BOOLEAN	TLBInWODet.ReportTrigger	TINYINT
	MachineCode	Machine Code	SG2_RESOURCE SHY_RESOURCE H8_RESOURCE	CHAR(06)
	StartPlanDateTime	Date/Time Start Schedule	SHY.HY_HORAINI SC2.C2_DATPRI SH8.H8_DTINI	DATE	TLBInWODet.StartPlanDateTime	DATETIME
	EndPlanDateTime	Date/Time End Schedule	SHY.HY_HORAFIM SC2.C2_DATPRF SH8.H8_DTFIM	DATE	TLBInWODet.EndPlanDateTime	DATETIME
	ProductionQuantity	Quantity to produce in operation	SHY.HY_QUANT SH8.H8_QUANT SC2.C2_QUANT	DEC(12,2)	TLBInWODet.Qty	DEC(19,4)
	ActivityQuantity	Quantity of operation	SHY.HY_QUANT SH8.H8_QUANT SC2.C2_QUANT	DEC(12,2)
	UnitActivityCode	Unit of measure	SB1.B1_UM	CHAR(02)	TLBInWODet.Unit1Code	CHAR(5)
	SecondUnitActivityCode	Second unit of measure in operation	--		TLBInWODet.Unit2Code	CHAR(5)
	SecondUnitActivityFactor	Conversor Factor for second unit in operation	--		TLBInWODet.Unit2Factor	DEC(8,4)
	ResourceQuantity	Quantity of resources	SG2.G2_MAOOBRA SHY.HY_MAOOBRA	NUM(03)
ListOfMaterialOrders
	ProductionOrderNumber	Production Order	SC2.C2_NUM + SC2.C2_ITEM + SC2.C2_SEQUEN	CHAR(20)	TBLInBillMat.Wocode	CHAR(41)
	MaterialID	ID of reservation record	SD4.R_E_C_N_O_	CHAR(10)
	MaterialCode	Code Reservation Item	SD4.D4_COD	CHAR(15)	TBLInBillMat.ProductCode	CHAR(20)
	MaterialDescription	Description of Item	SB1.B1_DESC	CHAR(40)
	ScriptCode	Code Script	SD4.D4_ROTEIROSCRIPT	CHAR(02)
	ActivityCode	Code Operation	SD4.D4_OPERAC	CHAR(02)	TBLInBillMat.WODetCode	CHAR(10)
	WarehouseCode	Code Deposit	SD4.D4_LOCAL	CHAR(02)	TBLInBillMat.ExtCode	CHAR(20)
	MaterialDate	Date Reservation	SD4.D4_DATADATE	DATE
	MaterialQuantity	Quantity of Reservation	SD4.D4_QUANT	DEC(12,2)	TBLInBillMat.TotalQty	DEC(19,4)
	LotCode	Lot	SD4.D4_LOTECTL	CHAR(10)
	PertMaterialNumber	Sequence of item	SD4.D4_TRT	CHAR(03)
	RequestType	Type of Request	SB1.B1_APROPRI	CHAR(01)	TBLInBillMat.Comments	CHAR(500)
ListOfAllocatedMaterial
	WarehouseCode	Code Deposit	SD4.D4_LOCAL	CHAR(02)	TBLInMovMat.WarehouseCode	CHAR(15)
	LotCode	Code Lot	SD4.D4_LOTECTL SDC.DC_LOTECTL	CHAR(10)	TBLInMovMat.LotCode	CHAR(41)
	LocationCode	Location/Address	SDC.DC_LOCALIZ	CHAR(15)	TBLInMovMat.AddressCode	CHAR(15)
	ActivityCode	Code Operation	SD4.D4_OPERAC	CHAR(02)	TBLInMovMat.WoDetCode	CHAR(10)
	ScriptCode	Code Script	SD4.D4_ROTEIROSCRIPT	CHAR(02)
	AllocationQuantity	Allocated Quantity	SD4.D4_QUANT SDC.DC_QUANT	DEC(12,2)	TBLInMovMat.Qty	DEC(19,4)
	AllocationType	Type Allocation	1 = Adds;2=Decreases;3=Absolute Value	CHAR(01)	TBLInMovMat.AllocationType	INT
	SubLoteCode	Sub Lot	SD4.D4_NUMLOTE SDC.DC_NUMLOTE	CHAR(06)
	NumberSeries	Number of Series	SDC.DC_NUMSERI	CHAR(20)
	LotDueDate	Validity Date	SD4.D4_DTVALID	DATE	TBLInMovMat.LotDtValidity	DATETIME
ListOfQuotaActivity
	ProductionOrderNumber	Number Production Order	CY9.CY9_NRORPO	CHAR(20)
	ControlType	Selection Split	--
	ActivityID	ID Operation	CY9.CY9_CDAT	CHAR(10)
	ItemCode	Code of item	CYY.CYY_CDAC	CHAR(15)
	ItemDescription	Description of item	CYY.CYY_DSAC	CHAR(40)
	StartActivityDateTime	Date/Time Start Activity	CYY.CYY_DTBGAT / CYY.CYY_HRBGAT	DATETIME	TBLInWODet.StartPlanDateTime	DATETIME
	EndActivityDateTime	Date/Time End Activity	CYY.CYY_DTEDAT / CYY.CYY_HREDAT	DATETIME	TBLInWODet.EndPlanDateTime	DATETIME
	ApprovedQuantity	Approved Quantity	CYY.CYY_QTATAP	DEC(13,4)
	ScrapQuantity	Scrapped Quantity	CYY.CYY_QTATRF	DEC(13,4)
	MachineCode	Code Machine	CYY.CYY_CDMQ	CHAR(20)	TBLInWODet.ResourceCode	CHAR(15)
	MachineDescription	Description of Machine	CYY.CYY_DSMQ	CHAR(40)
	ActivityQuantity	Estimated Quantity	CYY.CYY_QTAT	DEC(12,4)	TBLInWODet.QTY	DEC(19,4)
	StandardSetup	Standard Time Preparation	CYY.CYY_QTPASU	NUM(10)
	StandardActivity	Standard Time Operation	CYY.CYY_QTPAAT	NUM(10)
	StandardPostprocessing	Standard Time Post_process	CYY.CYY_QTPAPP	NUM(10)
	StandardMachine	Standard Time Machine	CYY.CYY_QTPAMQ	NUM(10)
	StandardOperator	Standard Time MOD	CYY.CYY_QTPAOE	NUM(10)
	UsedCapacity	Capacity Used	CYY.CYY_QTVMAT	DEC(12,4)
	ActivityTimeQuantity	Activity Available 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	Date/Time Start Setup	CYY.CYY_DTBGSU / CYY.CYY_HRBGSU	DATETIME
	EndSetupDateTime	Date/Time End Setup	CYY.CYY_DTEDSU / CYY.CYY_HREDSU	DATETIME
	TimeSetup	Time Setup	CY9.CY9_QTTESU	NUM(10)	TBLInWODet.SetUpTime	TINYINT
	TimeMachine	Machine Time	CY9.CY9_QTTEMQ	NUM(10)	TBLInWODet.StdSpeed	DEC(28,23)
	TimeOperator	Time MOD	CY9.CY9_QTTERC	NUM(10)
	TimePostprocessing	Post Process Time	CY9.CY9_QTTEPP	NUM(10)
	QuotaActivityID	ID Split	CYY.CYY_IDATQO	CHAR(05)	ActivityCode+ TBLInWODet.WODetCode	CHAR(10)
	WorkCenterCode	Work Center	CY9.CY9_CDCETR	CHAR(10)	TBLInWODet.ManagerGrpCode	CHAR(15)
	ReportedSplit	Reported Split	CYY.CYY_LGQORP	BOOELAN
	StatusActivityType	State Operation	CYY.CYY_TPSTAT	CHAR(01)
ListOfQuotaActivityTools
	ToolCode	Tool	CYY.CYY_CDFE	CHAR(20)
	ToolQuantity	Quantity Tool	CYY.CYY_QTFE	NUM(03)

...

Routine MATA685 is executed
The tag IdReport is not mandatory. It indicates the production report that must be updated (Not used for Protheus)
A The tag Type, indica se é Refugo ou indicates whether it is Scrap. 1 = RefugoNo ; 2= ScrapYes.

General Limitations/Restrictions

...

Atalhos

Páginas filhas

Versões comparadas

Versão antiga 14

Nova versão Atual

Chave

General Limitations/Restrictions