Structure of the Inventory module database
This document describes the structure of the tables and main fields of the database in the inventory module. In this new structure, tables have the 'INV_' prefix. The INV_TiposOrigem table records which other modules integrate with inventory (VND - Sales; CMP - Purchases; CCT - Payables and receivables; etc.). The INV_OrigensTiposDocumentos table contains additional data of document types (ES - Stock Entry; SS - Stock Issue; TS - Stock Transfer; etc) The INV_OrigensDrillDown table represents the DrillDown events associated with the types of origin The INV_Estados table represents the inventory states table States reserved by the system: BLOQ - Locked DISP - Available INV - Inventory PREV - Expected PREV.RES - Expected with reservation RES - Reserved TRAN - In Transit TRAN.RES - In Transit with reservation Users can create custom states. The objective of the INV_ConfigEstados table is to share document type state configurations between ERP modules so that these configurations can be found in document types of the different modules. 0 - positive 1 - negative The INV_GruposCusto table is the Inventory Cost Group table The ParametersGCP table holds all the parameters of the Logistics and Cash Management area, ie Inventory, Sales, Purchases, Payables and Receivables, Cash Management. The Armazens table holds all warehouses used in Sales, Purchases, Internal and Inventory movements. 0 - Ignore; 1 - Warning; 2 - Lock; The INV_Origens table stores the origin of the stock and/or cost movement agnostically. For example, in the case of a stock entry, you will view the information of the document line and header you integrated in the module. The entries in this table are always made in the unit of movement and not in the base unit of the article. Stock movement records are made in table INV_Movimentos. Unlike the old structure, this table only records stock movements and existing values, before and after each of the records, thus ensuring the persistence of stock on the date. All stock columns are doubled with the suffixes _Previous and _Actual, thus representing the stock existing before and after the registration of the same E - Input; S - Output; The recording of changes to the costing of articles is made in table INV_Custeio. This table will only contain the records of the movements that cause changes in the costing of articles. Like the table of movements, this table also contains information on the previous and current costs, i.e. after the movement has been recorded. 0 - Normal 1 - Charge 2 - Discount 3 - VPT (Change in price on transformation) The INV_ValoresActuaisStock table facilitates the search of current stock quantities The INV_ValoresActuaisCusteio table facilitates the search for current costing values This table allows you to view, per item, the serial numbers in stock. If the serial numbers are no longer in stock, '0' will appear in the Stock field. This table may also be used to check the status, magazine, location and batch of a certain serial number TypeDoc Series/NumDoc #NumLine All movements of serial numbers are recorded in table INV_NumerosSerieMovimento, which records, by stock movement, which serial numbers were moved. If, for example, a certain stock movement enters 5 serial numbers, this table will identify those 5 serial numbers linked to the same stock movement. The INV_Reservas table allows you to save all the information about a reservation, such as the line data, source and destination document, as well as the amount of the reservation and its current status 0 - Reserved by origin; 1 - Reserved by destination; The INV_CabecTransferencias table represents the record table of transfer document headers The INV_LinhasTransferencias table represents the table of transfer document rows The INV_CabecTransferenciasArtigo table represents the registration of article transfer header documents. The INV_LinhasTransferenciasArtigo table represents the row record table of article transfer documents The INV_DocumentosTransferencia table represents the record table of transfer document types and their configurations. TA – Item transfer: TALE – Warehouse/Location/State transfer; TE – State transfer; TLT – Lot transfer; TNS – Serial number transfer; TRA - Warehouse transfer; TS – Stock transfer; 0 - Warehouse transfer; 1 - Lot transfer; 2 - Serial number transfer; 3 - Item/Dimension transfer; 4 - Location transfer; 0 - None; 1 - Cost budget; 2 - Consumption; 3 - Purchases; 4 - Earnings budget; 5 - Earnings; 0 - None; 1 - Cost budget; 2 - Consumption; 3 - Purchases; 4 - Earnings budget; 5 - Earnings; The table INV_SeriesTransferencias represents the record and configuration table for the transfer documents series. Can only be one by document type. The table INV_PeriodosBloqueadosTransferencias defines locked periods for transfer documents. The table INV_CabecComposicoes represents the composition and breakdown document headers table. The table INV_LinhasComposicoes represents the composition and breakdown lines' table. 0- component 1- compound The table INV_DocumentosComposicao represents the record and configuration table for the composition and breakdown document types. 0 - Composition; 1 - Breakdown; 0 - None; 1 - Cost Budget; 2 - Consumption; 3 - Purchases; 4 - Earnings budget; 5 - Earnings; 0 - None; 1 - Cost Budget; 2 - Consumption; 3 - Purchases; 4 - Earnings budget; 5 - Earnings; The table INV_SeriesComposicoes represents the record and configuration table for the composition and breakdown document series. Can only be one by document type. The table INV_PeriodosBloqueadosComposicoes represents the record table for theclosed periods of the composition and breakdown documents. The table INV_CustosComposicao represents the configuration of costs associated to be posted in the composition documents. The table INV_CabecInventarios represents the inventory document header table. 1 - Under preparation; 2 - Being Counted; 3 - Closed; The table INV_LinhasInventarios represents the inventory lines table. The table INV_FormatosInventaricao represents the configuration table for the import and export formatting for the inventory terminals. The table INV_DetalhesLinhasInventarios represents the inventory quantities by stock state. The table INV_Valorizacoes represents the document cost value that applies value. The table INV_Variacoes represents all all average cost price variations associated to values. The table INV_VariacoesCBL represents the variation to be integrated in accounting. The table INV_CabecRececcoes represents the goods receipt document header table. The table INV_LinhasRececoes represents the goods reception lines. The table INV_LinhasRececoesNumSerie represents the serial numbers associated to the reception lines. The table INV_FormatosExpedicao records the format type that can be used when shipping. The table INV_CabecExpedicoes represents the shipping documents header. The table INV_LinhasExpedicoes represents the shipping document lines table. The tableINV_UnidadesExpedicoes records the adding units used in shipping. The table INV__LinhasExpedicoesNumSerie records the serial numbers associated to the shipping lines.INV_TiposOrigem
Field Description Modulo Letter that identifies the module APL Abbreviation of the module application UsaTipoDocumento Defines whether the module is integrated using its documents CampoTipoDocumento Defines the INV_Origens table field, where the document type is recorded DrillDown DrillDown action inside the ERP CodigoEntidadeVarPerfis Identifier of dynamic permissions INV_OrigensTiposDocumentos
Field Description TipoDocumento Code of the applicable document type (FA - Invoice; DEV - Return, TA - Article transfer; etc) SugeridoEst Defines whether this document type is automatically selected in inventory explorations INV_OrigensDrillDown
Field Description CamposDrillDown Fields (comma separated) that can be drilled-down in explorations CampoChaveDrillDown Field from the INV_Origens table from which information will be retrieved to perform the DrillDown for the record INV_Estados
Field Description Estado Identifier of the Inventory State. Descricao Description of the Inventory State Disponivel Indicates if this State is the available stock Existencias Indicates if the State should be considered as available stock Inventariavel Indicates whether the State is included for inventory taking EstadoReserva Indicates whether this State that can be used for reservations Sistema Indicates whether this is a default system State Previsto Indicates if this is a State where you expect stock entries in the short term Transito Indicates if this is a State in which stock is in transit INV_ConfigEstados
Field Description Documento Document identifier EstadoOrigem Defines the source state for stock EstadoDestino Defines the target state for stock TipoMov Defines the configuration for positive or negative movements: INV_GruposCustos
Field Description Grupo Identifier of the Cost Group Descricao Description of the Cost Group ValorizacaoLote Indication of whether the Cost Group does Lot valuation ParametrosGCP
Field Description MovStockConsecutivos Prevent stock movements that are not chronologically consecutive Armazens
Field Description RupturaStocks Identifies the option to be taken in case of stock shortage in the warehouse: ControlaRupturaStocks Indicates whether there is specific stock control in the warehouse GrupoCustos Identifies the cost group of the warehouse INV_Origens
Field Description Document Identifier of the document IdChave1 Header ID of the document that generated the flow IdChave2 Line ID of the document that generated the flow Chave1 Identifies the document type Chave2 Identifies the document series NumChave1 Identifies the document number AplicaValorizacao Indicates whether the origin of the movement will affect valuations Transferencia Sets whether it is a stock transfer movement INV_Movimentos
Field Description TipoMovimento Defines the type of stock movement: Colunas Stock_ Identify the stock of the item to the state defined in the row Colunas Existencias_ Identify the stock of the item at the moment for all states that count for stocks, regardless of the state of the row Sistema Identifies flows that were generated automatically by the system when posting data for a process IDReserva Identifies the reserve to which the stock movement is associated _Arm_ Columns Stock by warehouse _Lot_ Columns Stock by Batch _Loc_ Columns Stock by location _LocLot_ Columns Stock by location/batch _ArmLot_ Columns Stock by warehouse/batch Data Indicates the date of the stock movement DataIntegracao Record registration date NumRegisto Represents the record registration order INV_Custeio
Field Description TipoLancamentoCusteio Sets the type of posting: IdMovimentoStock If there is a stock movement associated with the movement of costing, identifies that movement TransferenciaValor Identifies a value transfer between two different cost groups ValorUnitario_ Row Unit Cost. In the case of rows with posting type costing<>0, this is the total value to be imputed to the row ValorAdicional_ Total Added Value of Row (Ex: Additional purchasing costs) ValorAbater_ Total value to be deducted from the row (Ex: Purchase discounts) Custo_ Columns Columns Identify the average cost value of the current article after the row posting and immediately prior to this posting _Lot_ Columns Cost to row lot, regardless of cost group. Only valid for articles with batch handling _GrpCst_ Columns Cost to row cost group _GrpCstLot_ Columns Cost to cost group/batch. Only valid when the cost group separates lot costing and the article handles prepacks IdValorizacao Identifier of the valuation that will assign the value to the movement INV_ValoresActuaisStock
Field Description DataStock Date of last stock movement EstadoStock Indicates the stock status Bloqueado Indicates whether the article/warehouse is locked for inventory-taking INV_ValoresActuaisCusteio
Field Description GruposCustos Identifies the cost group DataCusteio Identifies the date of the last movement of the article INV_NumerosSerie
Field Description Artigo Article identifier EstadoStock Indicates stock status NumeroSerie Represents the serial number. when the serial number is not referred to in the stock entry, a code identified in the document field is assumed Documento Represents the document that gave rise to the serial number by the following formula: INV_NumerosSerieMovimento
Field Description NumeroSerie Represents the serial number of the movement NumRegisto Represents the record number of the movement INV_Reservas
Field Description IdTipoOrigem(origin/destination) Identifies the integration module of the source or destination of the reserve line IdChave(origin/destination) Identifies the origin or destination key of the booking. In the case of sales and purchases, represents the ID of the row in question Descricao(origin/destination) The description of the origin or destination that will be presented on the holdings or processes treating stocks Estado(origin/destination) State of stock from which the stock of the reserve originates or to which it has been sent Quantidade Total quantity in the base unit of the article reserved Quantidade pendente Pending quantity to satisfy the reservation Fechada Identifies whether the reservation has been closed ReservadoPor Identifies who triggered the reservation process: IdReservaOriginal the case of a booking linkage, identifies the booking that gave rise to it INV_CabecTransferencias
Field Description ID Identifier of the article transfer TipoDoc Document Type NumDoc Document number Filial Identifier of the branch where the document is created. Valid only for branch licenses Serie Document series TipoEntidade Type of entity used for the accompanying document Entidade Entity used for the accompanying document Moeda Document Currency (Represents the base currency of the company) Cambio Exrate of the currency used in entries against the reference currency CambioMAlt Exrate of the alternative currency against the reference currency CambioMBase Exrate of the base currency against the reference currency Arredondamento Number of rounding decimal places Data Document date Observacoes Comments field Diario Accounting journal number NumDiario Indicates whether the document is already exported to accounting AnoCBL Year of the accounting year to which the document is posted MovContab Indicates if the document is already exported to accounting DocImp Indicates whether the document was printed IdGDOC Identification of PRIMAVERA Document Management document ObraId If all document lines are associated with a project/work, this field is filled with the project/work identification Utilizador Identifier of the user who launched the document DataUltimaActualizacao Field that indicates the date of the last update of the register IdCabecMovCbl Accounting document identifier TipoLancamento Posting type related to the flow in accounting WBSItem WBS element identifier INV_LinhasTransferencias
Field Description Id Identifier of the document line IdCabecTransfercias Document header identifier NumLinha Line number TipoLinha Line type identifier Artigo Identifier of the article Armazem Warehouse of origin of the moved article Localizacao Location of the goods (article) in the warehouse Lote movement lot of the article Descricao Article description Quantidade Quantity moved Unidade Unit used for entering the movement PrecUnit Unit price of the movement PrecoCusto Indicates the cost price of the material Data Date of movement FactorConv Conversion factor of the line values to the base unit of the article ArredFConv Rounding of the conversion factor ObraId Identification of the project/work to which the document line is associated ClasseId Identification of the work activity class. Applicable only for companies with CCOP integration SubEmpId Identification of the subcontract work. Applicable only for companies with CCOP integration CategoriaId Category to which the work article belongs. Applicable only for companies with CCOP integration IdLinhaOrigem Source line identifier IdLinhaPai Identifier of the line with the master article (parent) ItemId Item identifier in the CCOP module ItemCod Item code in the CCOP module ItemDesc Item description in the CCOP module WBSItem WBS element identifier ProcessoID Identifier of the STP (Technical Services) process CCustoCBL Accounting cost center account ContaCBL Accounting account AnaliticaCBL Accounting account for Analítica FuncionalCBL Accounting account for the functional EstadoOrigem Source state of the movement EstadoDestino Destination state of the movement TipoLinhaTransf Indicates whether it is a source or destination line INV_CabecTransferenciasArtigo
Field Description ID Identifier of the article transfer TipoDoc Identifier of the type of document NumDoc Document number Filial Identifier of the branch where the document is created. Valid only for branch licenses Serie Series of the document Moeda Document currency (must be the base currency of the company code) Cambio Exrate of the currency used in entries against the reference currency CambioMAlt Exrate of the alternative currency against the reference currency CambioMBase Exrate of the base currency against the reference currency Arredondamento Number of rounding decimal places Data Document date Observacoes Comments field Diario Accounting journal number NumDiario Indicates whether the document is already exported to accounting AnoCBL Year of the accounting year to which the document is posted MovContab Indicates if the document is already exported to accounting DocImp Indicates whether the document was printed ArtigoOrigem Indicates the article from which the transfer originated ArtigoDestino Indicates the article destination of the shipment LoteDestino Indicates the batch of the target material of the transfer IdGDOC Identification of PRIMAVERA Document Management document Utilizador Identifier of the user who posted the document DataUltimaActualizacao Field that indicates the date of the last update of the register IdCabecMovCbl Accounting document identifier TipoLancamento Posting type related to the flow in accounting INV_LinhasTransferenciasArtigo
Field Description Id Line identifier of the article transfer IdCabecTransferencias Document header identifier NumLinha Line number Armazem Warehouse identifier Localizacao Identifier of the location Lote Identifier of the batch EstadoStock Stock status identifier Quantidade Total stock of the item in the Warehouse/Location/Batch/Line State PrecoCusto Item cost in Warehouse/Location/Batch/Line State INV_DocumentosTransferencia
Field Description Documento Document identifier: Descricao Document type description TipoTransferencia Specifies the type of transfer: SugestaoEstat Specifies if the document is considered by default in the explorations. ActPCU Specifies if the document updates the last cost price. ActPC Specifies if the document updates the average cost price. ActUltEntrada Specifies if the document updates the last entry date. ActUltSaida Specifies if the document updates the last exit date. EnviaEmail Specifies if the document can be sent by email. EmailTo Email recipient. In case it is not the fixed email address, it will be the contact type. EmailFixo Specifies if it will be sent to a fixed email address or a contact list. EMailBCC Invisible recipient to receive an email copy. EMailCC Recipient to receive an email copy. EMailTexto Message attached to be sent by email with the document. EMailConfirmar Specifies if the user is asked to confirm the reception of the document by email. EMailVisualizar Specifies if the email will be viewed before being sent. DataUltimaActualizacao Field that specifies the last record update date. PermiteAltAposExp Specifies if the document can be changed after being exported to and from branches. Used only with license to Branches. Interno Specifies if the document is internal. In this case, this document cannot be used by the users. ControlaCustosPorObra Specifies if the document controls costs by work. ClasseAnaliticaEntrada Analytic Class of Projects/Works Entry: ClasseAnaliticaSaida Analytic Class of Projects/Works exit: TransitaEstado Identifies if the document performs the Project State Transition. EstadoTransitar Identifies the project state when it changes, if the document is configured. IgnoraBloqueioArm If this option is selected for a transfer document, this means that when inserting an item in a warehouse marked as blocked for stock entries and/or issues, the locking indication will be ignored. Therefore, it is possible to register the receipt or issue of stock to that warehouse (useful, for example, when you wish to issue material with poor quality to return to supplier). BensCirculacao When saving, generate document to accompany the goods. TipoDocCompra Types of document used to accompany the goods for suppliers. TipoDocVenda Types of document used to accompany the goods for customers. TipoPrecoBensCirculacao Type of price used when generating the document to accompany the goods. TransfereArmazem Specifies if the document can transfer stock between warehouses TransfereLocalizacao Specifies if the document can transfer stock between locations TransfereLote Specifies if the document can transfer stock between batches TransfereNSerie Specifies if the document can transfer serial numbers TransfereEstado Specifies if the document can transfer stock between states ColocaStockTransito Specifies if the document allows Transit states Estado Inventory state identifier. INV_SeriesTransferencias
Field Description AlterarData Specifies if the document can be saved with a date previous to the last one in the series. ArmazemSugestao Identifies the Suggested Warehouse. Config Default document printing configuration. DataFinal Final date of the series. DataInicial Start date of the series. DataUltimoDocumento Last document date of the series. Descricao Series description DescricaoVia01 Copy printing description. DescricaoVia02 Duplicate printing description. DescricaoVia03 Third copy printing description. DescricaoVia04 Fourth copy printing description. DescricaoVia05 Fifth copy printing description. DescricaoVia06 Sixth copy printing description. LimiteInferior Lower limit for document numbering. LimiteSuperior Upper limit for document numbering. LocalSugestao Identifies the Suggested Location. NumeracaoAutomatica Specifies if the series has automatic numbering. Numerador Number of the last document performed. Used for numeric sequence. NumVias Number of copies to be printed when the document is issued. Ordem Series ordering field Previsao Specifies if the document is previewed when printing. Serie Series identifier. SerieAutomatica Discontinued. SerieInactiva Specifies if the series is active. SeriePorDefeito Specifies if is is the default series. SugereDataSistema Specifies if the series suggests the system date when creating the documents. SugereMoradaArmazem Specified if the suggested warehouse address should or not be used for loading and unloading. TipoDoc Document type to which the series belong to. TipoLancamento Posting type identifier. UtilizadoEmPMS Specifies if the series is available in PMS. INV_PeriodosBloqueadosTransferencias
Field Description DataFinal Final period date. DataInicial Start period date. Documento Locked document INV_CabecComposicoes
Field Description Id Document header identifier. TipoDoc Document type. NumDoc Document number. Filial Identifier of the branch where the document is created. Valid only for Branches licenses. Serie Document series. Moeda Document currency. Cambio Introduction currency exchange rate regarding the reference currency. CambioMAlt Alternative currency exchange rate based on the reference currency. CambioMBase Base currency exchange rate based on the reference currency. Data Document date. Observacoes Document observations. Diario Accounting journal in which the document is posted. NumDiario Accounting journal number. AnoCBL Accounting fiscal year in which the document is posted. MovContab Specifies if the document was already exported to accounted DocImp Specifies if the document was printed. IdGDOC PRIMAVERA Documentary Management document identification. ObraId If all the rows in the document are associated to a project/work, this field is filled in with the project/work identification. Utilizador Identifier for the user who posted the document. DataUltimaActualizacao Field that specifies the last record update. IdCabecMovCbl Accounting document identifier. TipoLancamento Type of posting regarding the accounting posting. WBSItem Project WBS item identifier. TipoMov Specifies the price posting type. TipoQtdComposicao Specifies if the component quantities in the Composition/Breakdown documents are unitary or total. INV_LinhasComposicoes
Field Description Id Document line identifier. IdCabecComposicoes Document header identifier. NumLinha Line number. TipoLinha Specifies the line type. TipoComposto Specifies if it regards a compound or a component: Artigo Item identifier. Armazem Warehouse from which the item is posted. Localizacao Goods location (item) in the warehouse. Lote Item transaction batch. Descricao Item description. Quantidade Posted quantity. Unidade Postings entering unit. PrecUnit Posting unitary price. PrecoLiquido Postings net price. EstadoOrigem Posting source state. EstadoDestino Posting target state. EntradaSaida Specifies if the posting is entry or issue. Data Posting date. FactorConv Conversion factor of the line values for the base item unit. ArredFConv Conversion factor rounding. ObraId Identification of the project/work to which the document line is associated to. ClasseId Identification of the work activity class. Only applicable to companies with CCOP integration. SubEmpId Identification of the work subcontracting. Only applicable to companies with CCOP integration. CategoriaId Category the work item belongs to. Only applicable to companies with CCOP integration. MovStk Specifies if the line moves stock. IdLinhaComposto Compound line identifier. PCPadrao Specifies the item standard price. PrecoCusto Specifies the item cost price. ItemId Item identifier in the CCOP module. ItemCod Item code in the CCOP module. ItemDesc Item description in the CCOP module. WBSItem WBS item identifier. CCustoCBL Accounting cost center account. ContaCBL Accounting account. AnaliticaCBL Accounting account to Analytic. FuncionalCBL Accounting account to functional. IdLinhaPai Line identifier with the master item (parent). INV_DocumentosComposicao
Field Description Documento Document identifier. Descricao Document type description. TipoComposicao Specifies the composition type: SugestaoEstat Specifies if the document is considered by default in the explorations. ActPCU Specifies if the document updates the last cost price. ActPC Specifies if the document updates the average cost price. ActUltEntrada Specifies if the document updates the last entry date. ActUltSaida Specifies if the document updates the last issue date. PrecoUnitario Specifies the type of price to be used in the documents. EnviaEmail Specifies if the document can be sent by email. EmailTo Email recipient. In case it is not the fixed email address, it will be the contact type. EmailFixo Specifies if if will be sent to a fixed email address or to a contact list. EMailBCC Invisible recipient to receive an email copy. EMailCC Recipient to receive an email copy. EMailTexto Message attached to be sent by email with the document. EMailConfirmar Specified if the user is requested to confirm the reception of the document by email. EMailVisualizar Specifies if the email will be viewed before being sent. DataUltimaActualizacao Field that specifies the last record update. PermiteAltAposExp Specifies if the document can be changed before exporting from and to branches. Used only with Branches licenses. VersaoUltAct Field updated by the SQL when the record is saved. Used in branches to know which records are changed after the last import. Interno Specifies if the document is internal. In this case, the document cannot be used by the users. ControlaCustosPorObra Specifies if the document allows costs per work. ClasseAnaliticaEntrada Analytic Class for Projects/Works Entry: ClasseAnaliticaSaida Analytic Class for Projects/Works Issue: TransitaEstado Identifies if the document performs the Project State Transition. EstadoTransitar Identifies the project state when it changes, if the document is configured. INV_SeriesComposicoes
Field Description AlterarData Specifies if the document can be saved with a date previous to the last document in the series. ArmazemSugestao Identifies the Suggested Warehouse. Config Default document printing configuration. DataFinal Final date of the series. DataInicial Start date of the series. DataUltimoDocumento Last document date of the series. Descricao Series description DescricaoVia01 Copy printing description. DescricaoVia02 Duplicate printing description. DescricaoVia03 Third copy printing description. DescricaoVia04 Fourth copy printing description. DescricaoVia05 Fifth copy printing description. DescricaoVia06 Sixth copy printing description. LimiteInferior Lower limit for document numbering. LimiteSuperior Upper limit for document numbering. LocalSugestao Identifies the Suggested Location. NumeracaoAutomatica Specifies if the series has automatic numbering. Numerador Number of the last document performed. Used for numeric sequence. NumVias Number of copies to be printed when the document is issued. Ordem Series ordering field Previsao Specifies if the document is previewed when printing. Serie Series identifier. SerieInactiva Specifies if the series is active. SeriePorDefeito Specifies if is is the default series. SugereDataSistema Specifies if the series suggests the system date when creating the documents. SugereMoradaArmazem Specified if the suggested warehouse address should or not be used for loading and unloading. TipoDoc Document type to which the series belong to. TipoLancamento Posting type identifier. UtilizadoEmPMS Specifies if the series is available in PMS. INV_PeriodosBloqueadosComposicoes
Field Description DataFinal Final period date. DataInicial Start period date. Documento Locked document INV_CustosComposicao
Field Description ID Record identifier. Artigo Composed item identifier to which the Cost line is associated to. Descrição Cost line description. Custo Cost monetary value (Base Currency). Ordem Line sequence. INV_CabecInventarios
Field Description NumDoc Represents the number of the inventory document TipoDocEntrada Represents the entry document type TipoDocSaida Represents the entry document type EstadoDoc Defines the inventory state: ArtigosInventariadosAte Record filter criterion applied to inventory. ArtigosInventariadosAteData Record filter criterion applied to inventory. ArtigosAnulados Record filter criterion applied to inventory. ExcluirLotesInactivos Record filter criterion applied to inventory. ExcluirLocalizacoesInactivas Record filter criterion applied to inventory. ValorMinimoArt Record filter criterion applied to inventory. ValorMaximoArt Record filter criterion applied to inventory. StockMinimoArt Record filter criterion applied to inventory. StockMaximoArt Record filter criterion applied to inventory. RestricaoArtigos Record filter criterion applied to inventory. RestricaoFamilias Record filter criterion applied to inventory. RestricaoSubFamilias Record filter criterion applied to inventory. RestricaoMarcas Record filter criterion applied to inventory. RestricaoModelos Record filter criterion applied to inventory. RestricaoFornecedores Record filter criterion applied to inventory. RestricaoLocalizacoes Record filter criterion applied to inventory. RestricaoEstados Record filter criterion applied to inventory. SQLRestricoes Record filter criterion applied to inventory. BloquearStock Defines if the inventory perfoms the stock locking. InventarioCego When there is no current stock value specification. InventariacaoFixa New items cannot be added to inventory. INV_LinhasInventarios
Field Description Artigo Item identifier QtdOriginal Existing quantity in stock at that time QtdStock Counted quantity DataStock Counting date in which the stock will be moved (Ex.: Avoids the stock locking). INV_FormatosInventariacao
Field Description FormatoImportacao If the import is applicable. FormatoExportação If the export is applicable. Configuracao Formatting field configuration. INV_DetalhesLinhasInventarios
Field Description EstadoStock specifies the stock state. QtdOriginal Existing quantity in stock at that time. QtdStock Counted stock quantity. INV_Valorizacoes
Field Description IdOrigem specifies the stock state. IdMovimentoStock Stock movement identifier. IdMovimentoCusteio Cost posting identifier. Data Worth date. DataValor Value date. CustoMBase Cost in base currency. CustoMAlt Cost in alternative currency. CustoAnteriorMBase Previous cost in base currency. CustoAnteriorMAlt Previous cost in alternative currency. INV_Variacoes
Field Description IdCusteioRef Reference cost identifier (VFA). IdCusteioVariacao Identifier of the cost that originated the variation (VPT/ENC/DES). IdValorizacao Value identification to which the variation refers to (NULL indicates a variation in cost, ex.: VFA). DataRef Cost reference date (VFA). DataVariacao Date of the cost that originated the value (VPT/ENC/DES). ValorMBase Variation value in the base currency. ValorMAlt Variation value in the alternative currency ValorAnteriorMBase Previous value in the base currency variation. ValorAnteriorMAlt Previous value in the alternative currency variation. ValorRefMBase Reference value in the currency value. ValorRefMAlt Reference value in the alternative value. QuantidadeRef Reference quantity. INV_VariacoesCBL
Field Description IdVariacao Variation identifier (VFA). Conta Account to be posted. Natureza Posting nature. ValorMBase Variation value in the base currency. ValorMAlt Variation value in the alternative currency DescMovimento Posting description. SubModulo Posting submodule. IdDocOrigem Identifier of the document to which the variation is applied (FA). IdDocCusto Identifier of the document that originated the variation (VFA). IdMovCBL Identifier of the CBL posting already registered to DocOrigem. LoteCBL Identifier of the CBL posting batch already registered to DocOrigem. ContaOrigemCBL Identifier of the source account CBL posting already registered to DocOrigem. TipoContaCBL Identifier of the Account Type CBL posting already registered to DocOrigem. IdDocIntegracao Identifier of the posting that preceded the posting integration. INV_CabecRececoes
Field Description Id Identifier of the good receipt. Filial Identifier of the branch where the reception document is created. Valid only for branches licenses. NumDoc Document number. Armazem Reception document warehouse identifier. Descricao Document reception description. Data Reception document date. DataGravacao Reception document saving date. Observacoes Observation field. Utilizador Identifier for the user who posted the reception document. INV_LinhasRececoes
Field Description Id Reception document line identifier. IdCabecRececoes Reception document header identifier. NumLinha Line number. TipoLinha Specifies the line type. IdDocumentoOrigem Source document identifier. IdLinhaOrigem Source document line identifier. ModuloOrig Identifies the source document module. TipoDocOrig Identifies the source document type. IdLinhaPai Line identifier with the master item (parent). Modulo Identifies the target document module. IdDocumento Target document identifier. IdLinhaDocumento Target document line identifier. TipoEntidade Type of entity used for the reception document. Entidade Entity used for the reception document. Artigo Item identifier. Localizacao Location identifier. Lote Batch identifier. Descricao Item description. Unidade Postings entering unit. FactorConv Conversion factor of the line values for the base item unit. VariavelA Variable A. VariavelB Variable B. VariavelC Variable C. QntFormula Formula quantity. QuantidadePendente Quantity pending reception. Quantidade Received quantity. QuantidadeRejeitada Quantity rejected or not good. Fechar Identifies if the line was closed. MaterialNaoEnc Identifies if the line was originated in material not ordered / line inserted manually. INV_LinhasRececoesNumSerie
Field Description IdLinhasRececoes Reception line identifier IdNumeroSerie Identifier of the source document serial number NumeroSerie Represents the serial number of the reception line INV_FormatosExpedicao
Field Description Formato Shipping unit code. Descricao Shipping unit description. Arredonda Number of decimal places for the shipping format. Peso Shipping unit weight. INV_CabecExpedicoes
Field Description Id Goods shipping identifier. Filial Identifier of the branch where the shipping document is created. Valid only for Branches licenses. NumDoc Document number. Armazem Shipping warehouse document identifier. Descricao Document shipping description. Data Shipping document date. DataGravacao Shipping document saving date. Observacoes Observation field. Utilizador Identifier for the user who posted the shipping document. INV_LinhasExpedicoes
Field Description Id Shipping document line identifier IdCabecExpedicoes Shipping document header identifier NumLinha Line number TipoLinha Specifies the line type TipoEntidade Type of entity used for the shipping document< Entidade Entity used for the shipping document< IdDocumentoOrigem Source document identifier. IdLinhaOrigem Source document line identifier. ModuloOrigem Identifies the source document module. ModuloDestino Identifies the target document module. IdDocumentoDestino Target document identifier. IdLinhaDocumentoDestino Target document line identifier. UnidadeExpedicao Specifies the shipping unit IdLinhaOrigemUE Divided source line identifier IdLinhaPai Line identifier with the master item (parent). Artigo Item identifier. Armazem Warehouse identifier. Localizacao Location identifier. Lote Batch identifier. Descricao Item description. Unidade Postings entering unit. FactorConv Conversion factor of the line values for the base item unit. VariavelA Variable A. VariavelB Variable B. VariavelC Variable C. QntFormula Formula quantity. Quantidade Shipping quantity. Fechar Identifies if the line was closed. MaterialNaoEnc Identifies if the line was originated in material not ordered / line inserted manually. INV_UnidadesExpedicoes
Field Description Id Shipping unit identifier. IdCabecExpedicoes Shipping document line identifier UnidadeExpedicao Specifies the shipping unit. FormatoExpedicao Specifies the shipping format. Descricao Shipping unit description. Arredonda Number of decimal places for the shipping format. Peso Shipping unit weight. INV_LinhasExpedicoesNumSerie
Field Description IdLinhasExpedicoes Shipping line identifier. IdNumeroSerie Identifier of the source document serial number. NumeroSerie Represents the serial number of the shipping line.
login para deixar a sua opinião.