...
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_CODE | CYB.CYB_CDMQ | CHAR(20) | TBLInResource.code | CHAR(15) | |
Description | Machine Description | SH1.H1DESCRI | CYB.CYB_DSMQ | CHAR(40) | TBLInResource.Name TBLInResource.Nickname | CHAR(20) | |
WorkCenterCode | Work Center Code | SH1.H1_CTRAB | CYB.CYB_CDCETR | CHAR(10) | TBLInResource.ManagerGrpCode | CHAR(15) | |
WorkCenterDescription | Work Center Description | SHB.HB_NAME | CYB.CYB_DSCETR | CHAR(40) | TBLInResource.WorkCenterDescription | CHAR(15) | |
CostCenterCode | Cost Center Code | SH1.H1_CCUST | CYB.CYB_CDCECS | CHAR(20) | |||
ProcessorType | Type of Processing | CYB.CYB_TPPC 1=Monoprocess;2=By Batch; 3=Multiple Processes;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 | Quantity Simultaneous Operations | CYB.CYB_QTATSM | NUM(03) | ||||
IsSetup | It is set up | CYB.CYB_LGSU | BOOLEAN | ||||
IsOverlapReport | Overlaps Annotation | CYB.CYB_LGOVRP | BOOLEAN | ||||
ProductionAreaCode | Production Area | CYB.CYB_CDARPO | CHAR(10) | ||||
InitialValidateDate | Validity Initial 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) | TBLInUser.Code | CHAR(30) | ||
ResourceName | Resource Name | CYC.CYC_NMRC | CHAR(40) | TBLInUser.Name TBLInUser.Nickname | CHAR(60) | ||
UnitTimeType | Measure Time Type | CYC.CYC_TPUNTE 1=Hours;2=Minutes;3=Seconds | CHAR(01) | ||||
StartExpirationDate | Validity Start Date | CYC.CYC_DTBGVD | DATE | ||||
EndExpirationDate | Validity End Date | CYC.CYC_DTEDVD | DATE | ||||
CycleQuantity | Number Cycles | CYC.CYC_QTCI | DEC(11,4) | ||||
IsTimeActivity | Determines time | CYC.CYC_LGTEAT | BOOLEAN | ||||
ListOfProductionShifts | |||||||
ProductionShiftCode | Code Shift Model | CYL.CYL_CDTN | CHAR(08) | ||||
ProductionShiftDescription | Description Shift Model | CYL.CYL_DSTN | CHAR(40) | ||||
BeginDate | Validity Start Date | CYL.CYL_DTVDBG | DATE | ||||
EndDate | Validity End Date | CYL.CYL_DTVDED | DATE |
...
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_BRANCH | ||||
ItemInternalId | Company+Branch+code parent item | COMPANY + SG1.G1_BRANCH + SG1.G1_COD | ||||
ItemCode | Code parent item | SG1.G1_COD | CHAR(15) | TBLInWOHD.ProductCode TBLInWOHD.WOCode | CHAR(30) | |
ItemAmount | Base quantity of parent item | SB1.B1_QB | NUM(07) | TBLInWOHD.TotalQTY | DEC(19,4) | |
ItemComponentType | ||||||
ItemSequence | Sequence of component | SG1.G1_TRT | NUM(05) | TBLInBillMat.BillMatExtCode | CHAR(20) | |
ItemComponentCode | Code item component | SG1.G1_COMP | CHAR(15) | TBLInBillMat.ProductCode | CHAR(20) | |
ItemComponentInternalId | Internal Id of Item Component | COMPANY + SG1.G1_BRANCH + SG1.G1_COMP | ||||
InitialDate | Validity Initial Date | SG1.G1_INI | DATE | TBLInWOHD.DtPlanStart | DATETIME | |
FinalDate | Validity End Date | SG1.G1_FIM | DATE | TBLInWOHD.DtPlanEnd | DATETIME | |
IsGhostMaterial | Indicates whether it is ghost | SB1.B1_FANTASM | BOOLEAN ( FALSE ou TRUE) | |||
ItemComponentAmount | Quantity of component item | SG1.G1_QUANT | DEC(12,6) | |||
LossFactor | Factor of loss | SG1.G1_LOSS | DEC(05,2) | |||
ListOfScript | ||||||
Scriptcode | Code of Script | SGF.GF_SCRIPT | CHAR(02) | TBLInWOHD.ExtCode | CHAR(20) | |
ScriptAlternative | Alternative of Script | -- | ||||
ActivityIntenalID | ID Operation | -- | ||||
ActivityCode | Code of Operation | SGF.GF_OPERAC | CHAR(02) | TBLInWodet.Code | CHAR(10) | |
ActivityComponentSequence | Sequence of component in the operation | SGF.GF_TRT | NUM(03) |
...
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 | ||
---|---|---|
| ||
|
Stop Reason Transaction: StopReason_1_000.xsd
...
Nota | ||
---|---|---|
| ||
|
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) |
...
Shop Floor Notes
...
Message Identifier: StopReport
Version: 1_001
Protheus Module: SIGAPCP
Sending Type: Synchronous
Nota | ||
---|---|---|
| ||
This message is generated by PC-Factory and sent to Protheus. |
MensagemMessage | Tag | DescriçãoDescription | TabelaTable/CampoField Protheus PCP | TabelaTable/CampoField Protheus SFC | TipoType | TabelaTable/CampoField: PC-Factory | TipoType |
---|---|---|---|---|---|---|---|
MachineCode | Código MáquinaMachine Code | SH6.H6_RECURSORESOURCE | CYX.CYX_CDMQ | CHAR(06) | TBLOutRSEv.ResourceCode | CHAR(15) | |
MachineDescription | Descrição MaquinaMachine Description | ||||||
StopReasonCode | Código Motivo ParadaCode Reason Stoppage | SH6.H6_MOTIVOREASON | CYX.CYX_CDSP | CHAR(02) | TBLOutRSEv.ResourceStatusCode | CHAR(20) | |
StopReasonDescription | Descrição Motivo ParadaDescription Reason Stoppage | SX5.X5_DESCRI * | CYX.CYX_DSSP | CHAR(40) | |||
StartDateTime | DataSt Date/Hora InícioTime | SH6.H6_DATAINI SH6.H6_HORAINI | CYX.CYX_DTBGSP CYX_HRBGSP | DATE | TBLOutRSEv.ShiftDtStart | DATETIME | |
EndDateTime | DataEnd Date/Hora FimTime | SH6.H6_DATAFIN SH6.H6_HORAFIN | CYX.CYX_DTEDSP CYX.CYX_HREDSP | DATE | TBLOutRSEv.ShiftDtEnd | DATETIME | |
OperatorCode | Código OperadorOperator Code | SH6.H6_OPERADO | CYX.CYX_CDOE | CHAR(20) | TBLOutRSEv.UserCodeStart | CHAR(30) | |
ReportDateTime | DataReport Date/Hora ReporteTime | SH6.H6_DTAPONT | CYX.CYX_DTRP | DATE | TBLOutRSEv.DtTimeStamp | DATETIME | |
ToolCode | Código FerramentaCode Tool | -- | CYX.CYX_CDFEPO | ||||
ProductionTeamCode | Código EquipeCode Team | -- | CYX.CYX_CDGROE | ||||
StopType | Tipo Parada Type Stoppage (1=Não ProgramadaNot Scheduled;2=ProgramadaScheduled) | -- | CYX.CYX_TPSP | ||||
ReportSequence | ID PC-Factory | -- | -- | TBLOutRSEv.IDOutRSEv |
Nota | ||
---|---|---|
| ||
|
...
This Request is generated by PC-Factory and sent to Protheus. This Return is generated by Protheus to PC-Factory.
Request
MensagemMessage | Tag | DescriçãoDescription | TipoType |
---|---|---|---|
ListOfRequest | ItemInternalIdCódigo do produto | Code of product | CHAR(15) |
ReferenceCode | ReferênciaReference | CHAR(20) | |
WarehouseInternalIdCódigo | do depósito/local de estoque/ArmazémCode of deposit/location of stock/Warehouse | CHAR(10) | |
LotNumber | LoteLot | CHAR(10) | |
SubLotCode | SubLoteSubLot | CHAR(10) | |
SerialNumberNúmero de Série | Number of Series | CHAR(20) | |
Address | LocalizaçãoLocation | CHAR(15) | |
LotExpirationDateData | de ValidadeValidity Date | DATE |
Nota | ||
---|---|---|
| ||
|
Return
MensagemMessage | Tag | DescriçãoDescription | TabelaTable/CampoField | TipoType |
---|---|---|---|---|
ReturnContentType | ClosingStockDateData fechamento estoque | Stock closing date | -- | |
ListOfReturnItem | CompanyId | EmpresaCompany | ||
BranchId | FilialBranch | |||
CompanyInternalId | Empresa Company + FilialBranch | |||
ItemInternalIdCódigo do produto | Code of product | SB2.B2_COD | CHAR(15) | |
ReferenceCode | ReferenciaReference | -- | ||
ListOfStockBalance | ||||
WarehouseInternalId | Local de Estoque (Armazém/DepósitoLocation of Stock (Warehouse/Deposit) | SB2.B2_LOCAL | CHAR(10) | |
LotNumberNúmero do Lote | Number of Lot | SB8.B8_LOTECTL | CHAR(10) | |
SubLotCode | Sub LoteLot | SB8.B8_NUMLOTE | CHAR(10) | |
LotExpirationDateData | de validadeValidity Date | SB8.B8_DTVALID | DATE | |
SerialNumberNúmero de série | Number of series | SBF.BF_NUMSERI | CHAR(20) | |
Address | LocalizaçãoLocation | SBF.BF_LOCALIZ | CHAR(15) | |
CurrentStockAmountSaldo do Produto em quantidade | Balance of Product in quantity | SB2.B2_QATU SB8.B8_SALDOBALANCE SBF.BF_QUANT | DEC(17,4) | |
BookedStockAmountQuantidade reservada em Estoque | Quantity reserved in Stock | SB2.B2_RESERVARESERVATION SB8.B8_EMPENHOALLOCATION SBF.BF_EMPENHOALLOCATION | DEC(17,4) | |
AvailableStockAmountSaldo disponível do Produto em quantidade | Balance available of Product in quantity | SB2.B2_QATU - SB2.B2_RESERVARESERVATION SB8.B8_SALDO - SB8.B8_EMPENHOALLOCATION SBF.BF_QUANT - SBF.BF_EMPENHOALLOCATION | DEC(17,4) | |
UnitItemCostCusto unitário do Produto | Unitary cost of Product | -- | ||
AverageUnitItemCostCusto médio do Produto | Average cost of Product | -- | ||
ValueOfCurrentStockAmountSaldo atual do estoque do produto em valor | Current balance of stock of product 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.
MensagemMessage | Tag | DescriçãoDescription | TabelaTable/CampoField | TipoType | TabelaTable/CampoField: PC-Factory | TipoType | |
---|---|---|---|---|---|---|---|
BusinessContentType | CompanyIdCódigo da empresa | Code of company | |||||
BranchId | FilialBranch | ||||||
CompanyInternalId | InternalId da chave completa da empresaof full key of the company | ||||||
InternalId | InternalId da movimentaçãoof movement. | ||||||
TypeMovementCodeCódigo do Tipo de Movimento interno | Code of Type of internal movement | SD3.D3_TM | CHAR(03) | ||||
EmissionDateData de Emissão | Date of Issue | SD3.D3_EMISSAOISSUE | DATE | TBLOutInteg. DtTimeStamp | DATETIME | ||
ItemCodeCódigo do Produto | Code of Product | SD3.D3_COD | CHAR(15) | TBLOutInteg.ProductCode | CHAR(20) | ||
UnitOfMeasureCodeUnidade de Medida | Unit of Measure | SD3.D3_UM | CHAR(02) | ||||
Quantity | QuantidadeQuantity | SD3.D3_QUANT | DEC(12,2) | TBLOutInteg.Qty | DEC(19,4) | ||
WarehouseCodeCódigo do Armazém | Code of Warehouse | SD3.D3_LOCAL | CHAR(02) | TBLOutInteg.WarehouseCode | CHAR(15) | ||
LotNumber | LoteLot | SD3.D3_LOTECTL | CHAR(10) | TBLOutInteg.LotCode | CHAR(41) | ||
SubLotNumber | SubLoteSubLot | SD3.D3_NUMLOTE | CHAR(06) | ||||
LotExpirationDateData Validade do Lote | Lot Validity Date | SD3.D3_DTVALID | DATE | TBLLot.DTDUE | DATETIME | ||
Address | EndereçoAddress | SD3.D3_LOCALIZ | CHAR(15) | TBLOutInteg.Address1Code | CHAR(15) | ||
NumberSeries | NumberSeries | SD3.D3_NUMSERI | CHAR(20) | TBLOutInteg.LotCode | CHAR(41) | ||
InputOrOutput | Movimento de Entrada ou Saída | Input or Output Movement | I=Input / O = OutputE=Entrada / S = Saída | CHAR(01) | TBLOutInteg.MovTypeCode | CHAR(05) | |
ReferenceCode | ReferênciaReference | -- | |||||
ScriptCode | RoteiroScript | SD4.D4_ROTEIROSCRIPT | CHAR(02) | ||||
ActivityCode | OperaçãoOperation | SD4.D4_OPERAC | CHAR(02) | TBLOutInteg.WODetCode | CHAR(15) | ||
ProductionOrderNumber | Ordem de Produção/DocumentoProduction Order/Document | SD3.D3_OP e SD3.D3_DOC | CHAR(13) | TBLOutInteg.WOCode | CHAR(41) | ||
FatherItemCode | Parent Item Pai | -- |
Nota | ||
---|---|---|
| ||
|
...
Note: This message is generated by PC-Factory and sent to Protheus.
MensagemMessage | Tag | DescriçãoDescription | TabelaTable/CampoField | TipoType | TabelaTable/CampoField: PC-Factory | TipoType |
---|---|---|---|---|---|---|
BusinessContentType | CompanyId | EmpresaCompany | ||||
BranchId | FilialBranch | |||||
CompanyInternalId | InternalId da chave completa da empresaof full key of the company | |||||
InternalId | InternalId da transferênciaof transfer | |||||
NumberNúmero da Movimentação | Number of Movement | SD3.D3_NUMSEQ | CHAR(06) | |||
RegisterDateTimeData de Emissão da solicitação | Date of Issue of Request | SD3.D3_EMISSAOISSUE | DATE | |||
TransferWarehouseType | ||||||
InternalId | InternalId da transferênciaof transfer | |||||
EmissionDateData | de EmissãoIssue Date | SD3.D3_EMISSAOISSUE | DATE | TBLOutInteg.DtTimeStamp | DATETIME | |
ItemCodeFrom | Item/Produto OrigemProduct Origin | SD3.D3_COD | CHAR(15) | TBLOutInteg.ProductCode | CHAR(20) | |
ItemCodeTo | Item/Produto DestinoProduct Destination | SD3.D3_COD | CHAR(15) | TBLMovEv.ProductCode | CHAR(20) | |
UnitOfMeasureFromUnidade de Medida Origem | Unit of Measure Origin | SD3.D3_UM | CHAR(02) | |||
UnitOfMeasureToUnidade de Medida Destino | Unit of Measure Destination | SD3.D3_UM | CHAR(02) | |||
Quantity | QuantidadeQuantity | SD3.D3_QUANT | DEC(12,2) | TBLOutInteg.Qty | DEC(19,4) | |
WarehouseCodeFromCódigo do Armazém de Origem | Code of Origin Warehouse | SD3.D3_LOCAL | CHAR(02) | TBLOutInteg.WarehouseCode | CHAR(15) | |
WarehouseCodeToCódigo do Armazém Destino | Code of Destination Warehouse | SD3.D3_LOCAL | CHAR(02) | TBLMovEv.WarehouseCode | CHAR(15) | |
LotNumberFromNúmero do Lote de Origem | Number of Origin Lot | SD3.D3_LOTECTL | CHAR(10) | TBLOutInteg.LotCode | CHAR(41) | |
LotNumberToNúmero do Lote de Destino | Number of Destination Lot | SD3.D3_LOTECTL | CHAR(10) | TBLMovEv.LotCode | CHAR(41) | |
SubLotNumberNúmero do SubLote | Number of SubLot | SD3.D3_NUMLOTE | CHAR(06) | |||
LotExpirationDateFromData de validade do Lote Origem | Validity Date of Origin Lot | SD3.D3_DTVALID | DATE | TBLLot.DtDue | DATETIME | |
LotExpirationDateToData de validade do Lote Destino | Validity Date of Destination Lot | SD3.D3_DTVALID | DATE | TBLLot.DtDue | DATETIME | |
AddressFromEndereço | OrigemOrigin Address | SD3.D3_LOCALIZ | CHAR(15) | TBLOutInteg.Address1Code | CHAR(15) | |
AddressToEndereço | DestinoDestination Address | SD3.D3_LOCALIZ | CHAR(15) | TBLOutInteg.Address2Code | CHAR(15) | |
NumberSeriesNúmero de série | Number of Series | SD3.D3_NUMSERI | CHAR(20) | TBLOutInteg.LotCode | CHAR(41) |
Nota | ||
---|---|---|
| ||
|
Transação RecusaTransaction Refusal: Refusal_1_000.xsd
Identificador da Mensagem Identifier of Message: Refusal
Versão Version: 1_000
Módulo Module Protheus: SIGAPCP
Tipo de Envio: Síncrona
Esta mensagem será utilizada para registrar as perdas da produção quando são registradas peças boas e posteriormente verificado que houve algum defeito. Também pode ser utilizada para registrar as perdas da matéria-prima.
Nota:
Type of Delivery: Synchronous
This message is used to register the losses of production when good spare parts are registered, then later a defect is verified. It can be used to register the losses of raw material.
Note:
This message is generated by PC-Factory and sent to Esta mensagem será gerada pelo PC-Factory e enviada ao Protheus.
MensagemMessage | Tag | DescriçãoDescription | TabelaTable/CampoField | TipoType | TabelaTable/CampoField: PC-Factory | TipoType |
BusinessContentType | ProductionOrderNumberOrdem | de ProduçãoProduction Order | SBC.BC_OP | CHAR(20) |
|
|
| IdReport | ID ApontamentoAnnotation |
| CHAR(10) |
|
|
| ItemCodeProduto | RecusadoRefused Product | SBC.BC_PRODUTOPRODUCT | CHAR(20) |
|
|
| WarehouseCodeCódigo | do depósitoDeposit Code | SBC.BC_LOCORIG | CHAR(02) |
|
|
| AddressCode | EndereçoAddress | SBC.BC_LOCALIZ | CHAR(15) |
|
|
| NumberSeries Número | de SérieSeries Number | SBC.BC_NUMSERI | CHAR(20) |
|
|
| TypeTipo | PerdaType Loss | SBC.BC_TIPO | CHAR(01) |
|
|
| WasteCodeMotivo de Perda | Reason of Loss | SBC.BC_MOTIVOREASON | CHAR(02) |
|
|
| WasteDescriptionDescrição da Perda | Description of Loss | SBC.BC_DESCRI | CHAR(40) |
|
|
| LossQuantityQuantidade de Perda | Quantity of Loss | SBC.BC_QUANT | DEC(11,2) |
|
|
| CostCenterCodeCentro | de CustoCost Center | SBC.BC_CC | CHAR(09) |
|
|
| ItemCodeToProduto | GeradoProduct Generated | SBC.BC_CODDEST | CHAR(20) |
|
|
| WarehouseCodeToCódigo do depósito Destino | Code of Destination deposit | SBC.BC_LOCAL | CHAR(02) |
|
|
| AdressCodeToEndereço | DestinoDestination Address | SBC.BC_LOCDEST | CHAR(15) |
|
|
| NumberSeriesToNr | . de Série DestinoNo. of Destination Series | SBC.BC_NSEDEST | CHAR(20) |
|
|
| QuantityToQuantidade | destinoDestination Quantity | SBC.BC_QTDDEST | DEC(11,2) |
|
|
| ActivityCode | OperaçãoOperation | SBC.BC_OPERAC | CHAR(10) |
|
|
| ResourceCode | MáquinaMachine/RecursoResource | SBC.BC_RECURSORESOURCE | CHAR(20) |
|
|
| LossDateData da Perda | Date of Loss | SBC.BC_DATADATE | DATE |
|
|
| LotCode | LoteLot | SBC.BC_LOTECTL | CHAR(10) |
|
|
| SubLotCode | SubLoteSubLot | SBC.BC_NUMLOTE | CHAR(06) |
|
|
| LotDueDateData | de ValidadeValidity Date | SBC.BC_DTVALID | DATE |
|
|
Esta mensagem terá as seguintes finalidades:
Perda do Produto Acabado informando produto destino:
Permite que seja alterado uma determinada quantidade que já foi apontada e está no estoque como boa. Denomina-se recusa do produto acabado, pois não será necessário realizar os estornos e depois o ajuste do apontamento.
Exemplo: OP de 50 unidades, 5 apontamentos de 10, Necessidade de acerto de 45 peças com defeitos e 5 boas.
Ao invés de estornar os 5 apontamentos e "reapontar" 5 boas e 45 refugos na ProductionAppointment poderá ser enviada uma mensagem de Recusa de 45 para a OP, informando o motivo da recusa/defeito e código do produto destino.
Perda de Matéria Prima:
A mensagem de recusa também será utilizada para registrar perda de matéria prima durante o processo produtivo. A matéria prima pode gerar um subproduto ou não.
Perda do Produto Acabado sem informar produto destino:
Poderá ser utilizado para informar a perda do produto acabado sem que seja necessário gerar as tags de destino.
Nota:
This message will have the following purposes:
Loss of Finished Product entering destination product:
Enables you to change certain amount that has already been registered and is in stock as good. It is called refusal of finished product, as you do not need to perform reversal and adjustment of annotation.
Example: OP of 50 units, 5 annotations of 10, Need of adjustment of 45 spare parts with deffects and 5 good.
Instead of reversing 5 annotation and register again 5 good ones and 45 scraps in ProductionAppointment, a Refusal message can be sent for OP, indicating the reason of refusal/defect and code of destination product.
Loss of Raw Material:
The message of refusal is also used to register loss of raw material during the productive process. The raw material can generated a subproduct or not.
Loss of Finished Product without entering destination product:
Used to enter the loss of finished product, without being necessary to generate the destination tags.
Note:
...