TOTVS Protheus is an ERP widely used by Brazilian companies for finance, sales, inventory, and invoicing. This connector reads Protheus through its own REST service, using the standard framework API that queries Protheus tables (GenericQuery), so it works on Protheus servers on TOTVS Cloud and on your own infrastructure.

Before you start

Ask your Protheus administrator (or your TOTVS partner) to check the following:

The Protheus REST service is running and reachable from the internet over HTTPS, for example https://mycompany.protheus.cloudtotvs.com.br:4050/rest. Nekt runs in the cloud, so an address that only works inside your network cannot be used. The connection sends the Protheus user and password on every request, so http:// addresses are refused.
The REST service has security enabled (SECURITY=1 in the REST configuration). The API this connector uses only runs with security on.
The Protheus framework library (LIB) is up to date. The GenericQuery API is part of the framework libraries released since 2022. Environments on TOTVS Cloud on a supported release already have it.
A Protheus user for the integration with access to the tables of the streams you want (for example, accounts receivable, customers, products). To receive CPF/CNPJ, e-mail, and phone numbers, the user also needs access to personal and sensitive data (LGPD) in the Protheus Configurator: otherwise Protheus hides those columns and they arrive empty (the run log lists them).
The company group code and a branch code the user can access (for example, 01 and 0101).

Each request opened by the connector uses a Protheus REST thread, like any other integration with the Protheus API. Schedule the source outside peak hours if your REST service has few threads.

Configuring TOTVS Protheus as a Source

In the Sources tab, click on the “Add source” button located on the top right of your screen. Then, select the TOTVS Protheus option from the list of connectors. Click Next and you’ll be prompted to add your access.

1. Add account access

The following configurations are available:

Protheus REST URL: Address of the Protheus REST service including its path, as reached from the internet, for example https://mycompany.protheus.cloudtotvs.com.br:4050/rest.
Username and Password: The Protheus user for the integration.
Company group code: The Protheus company group (grupo de empresas) to extract, for example 01. To extract more than one company group, create one source per group.
Branch code: Any branch (filial) of that group the user can access, for example 0101. It only opens the session: the data of every branch of the group is extracted, and each record carries its branch in the *_filial column.
Start date (optional): Limits accounts receivable to those issued on or after this date, plus every receivable that is still open, and sales orders and their items to orders issued on or after this date. Leave it empty to read the whole history. If you set it, keep in mind:
- A receivable issued before this date stays in the table only while it is open. When it is paid, it disappears from the table (it does not show up as paid).
- Receivables issued before this date that were already paid are never loaded.
- Moving the date forward makes the tables smaller.
- Totals of received amounts from this table are complete only for receivables issued on or after this date.
Page size (advanced): Records requested per call. Lower it if the Protheus REST service times out.
Verify SSL certificate (advanced): Turn off only if your Protheus server uses a self-signed or incomplete certificate.

Once you’re done, click Next.

2. Select streams

Choose which data streams you want to sync. Before extracting anything, Nekt checks every selected stream with Protheus. If the user cannot read a table, or a table is not used in your Protheus environment, the run stops before extracting anything and the run log lists each stream and what to fix. Give the user access to the table or unselect the stream. Select the streams and click Next.

3. Configure data streams

Customize how you want your data to appear in your catalog. Select the desired layer where the data will be placed, a folder to organize it inside the layer, a name for each table (which will effectively contain the fetched data) and the type of sync.

Layer: Choose between the existing layers on your catalog. This is where you will find your new extracted tables as the extraction runs successfully.
Folder: A folder can be created inside the selected layer to group all tables being created from this new data source.
Table name: We suggest a name, but feel free to customize it. You have the option to add a prefix to all tables at once and make this process faster!
Sync Type: Every stream is FULL_TABLE: each run replaces the table with what Protheus has at that moment, within the Start date limit described above. Read more about Sync Types here.

Once you are done configuring, click Next.

4. Configure data source

Describe your data source for easy identification within your organization, not exceeding 140 characters. To define your Trigger, consider how often you want data to be extracted from this source and the load on your Protheus REST service. Accounts receivable and sales orders are usually the largest tables: use the Start date to keep them bounded. Optionally, you can define some additional settings:

Delta Log Retention: Determine for how long we should store old states of this table as it gets updated. Read more about this resource here.

Once you are ready, click Next to finalize the setup.

5. Check your new source

You can view your new source on the Sources page. If needed, manually trigger the source extraction by clicking on the arrow button. Once executed, your data will appear in your Catalog.

For you to be able to see it on your Catalog, you need at least one successful source run.

Good to know

Column names are the Protheus field names in lower case (E1_NUM becomes e1_num), so anyone who knows the Protheus data dictionary recognizes them. Custom fields (*_X...) and any other field Protheus returns are kept in the extra_fields column as JSON.
Bank slips (2nd copy): the accounts receivable stream brings the bank’s own number (e1_numbco, nosso número), the barcode as stored in Protheus (e1_codbar), the due dates, the amount, and the open balance. Nekt also derives the 47-digit typeable line (boleto_digitable_line) from the barcode, validating the check digits. The barcode is only present for receivables already registered with the bank (CNAB return, online bank API, or slip printing). The slip PDF or a slip URL is not available through the Protheus API.
Stock: b2_qatu is the physical quantity per product and warehouse. Reserved (b2_reserva) and committed (b2_qemp) quantities are separate columns, so the available quantity is b2_qatu - b2_reserva - b2_qemp.
Prices: the commercial prices are in the Price table items stream (da1_prcven per table and product). b1_prv1 in Products is only the base price registered on the product.
Deleted records in Protheus are not extracted, and they disappear from the tables on the next run.
Text values come without the trailing blanks Protheus pads its fields with. Dates are stored as YYYY-MM-DD; an empty Protheus date is stored empty.
Records changed during a run: Nekt reads each table in the order of its key, continuing from the last record read, so records added or removed elsewhere in the table during the run do not make it skip others. A record added during the run in a part of the table already read, or removed after it was read, shows up correctly on the next run.

Streams and Fields

Available streams

The table below lists every stream, its slug (the exact identifier to pass when creating the source via API), the Protheus table it reads, and its sync type.

Stream	Slug	Protheus table	Sync
Accounts receivable and bank slips	`accounts_receivable`	SE1 - Contas a Receber	Full table
Customers	`customers`	SA1 - Clientes	Full table
Products	`products`	SB1 - Produtos	Full table
Product complements	`product_complements`	SB5 - Complemento de Produto	Full table
Price tables	`price_tables`	DA0 - Tabelas de Preço	Full table
Price table items	`price_table_items`	DA1 - Itens da Tabela de Preço	Full table
Stock balances	`stock_balances`	SB2 - Saldos em Estoque	Full table
Warehouses	`warehouses`	NNR - Locais de Estoque	Full table
Sales orders	`sales_orders`	SC5 - Pedidos de Venda	Full table
Sales order items	`sales_order_items`	SC6 - Itens dos Pedidos de Venda	Full table
Sales representatives	`sellers`	SA3 - Vendedores	Full table
Payment terms	`payment_terms`	SE4 - Condições de Pagamento	Full table
Branches	`branches`	Company group branches (framework API)	Full table

Fields by stream

Accounts receivable and bank slips

Stream name: accounts_receivable. Source: SE1 - Contas a Receber.Sync Strategy:

Full table (the whole table is read on every run)
Primary key(s): e1_filial, e1_prefixo, e1_num, e1_parcela, e1_tipo, e1_cliente, e1_loja

Field	Type	Description
`e1_filial`	String	Branch (filial) code of the record; blank when the table is shared by every branch of the company.
`e1_prefixo`	String	Receivable prefix (E1_PREFIXO), part of the receivable key.
`e1_num`	String	Receivable number (E1_NUM), usually the invoice number.
`e1_parcela`	String	Installment of the receivable (E1_PARCELA); blank for a single installment.
`e1_tipo`	String	Receivable type (E1_TIPO): NF invoice, DP duplicate, BOL bank slip, RA advance, NCC credit note, AB- deduction, etc.
`e1_cliente`	String	Customer code (E1_CLIENTE); joins customers.a1_cod.
`e1_loja`	String	Customer store/unit (E1_LOJA); joins customers.a1_loja.
`e1_nomcli`	String	Customer short name stored on the receivable (E1_NOMCLI).
`e1_naturez`	String	Financial nature code (E1_NATUREZ).
`e1_emissao`	Date	Issue date of the receivable (E1_EMISSAO).
`e1_vencori`	Date	Original due date (E1_VENCORI).
`e1_vencto`	Date	Due date (E1_VENCTO).
`e1_vencrea`	Date	Actual due date, moved to the next business day when needed (E1_VENCREA).
`e1_valor`	Number	Original amount of the receivable in its currency (E1_VALOR).
`e1_saldo`	Number	Open balance still to be received (E1_SALDO); 0 when fully settled.
`e1_vlcruz`	Number	Amount converted to the local currency (E1_VLCRUZ).
`e1_moeda`	Number	Currency number of the receivable (E1_MOEDA); 1 is the local currency.
`e1_descont`	Number	Discount granted (E1_DESCONT).
`e1_juros`	Number	Interest charged (E1_JUROS).
`e1_multa`	Number	Late fee charged (E1_MULTA).
`e1_acresc`	Number	Additions to the amount (E1_ACRESC).
`e1_decresc`	Number	Reductions of the amount (E1_DECRESC).
`e1_valliq`	Number	Net amount received on the last settlement (E1_VALLIQ).
`e1_porcjur`	Number	Daily interest rate (%) used for late payment (E1_PORCJUR).
`e1_baixa`	Date	Date of the last settlement (E1_BAIXA); empty while nothing was received.
`e1_status`	String	Receivable status (E1_STATUS): A open, B settled.
`e1_situaca`	String	Collection situation (E1_SITUACA): 0 portfolio, 1 simple collection, 2 discounted, 3 pledged, 4 linked, 5 lawyer, 6 judicial, etc.
`e1_portado`	String	Bank code of the collecting bank (E1_PORTADO).
`e1_agedep`	String	Agency of the collecting bank (E1_AGEDEP).
`e1_conta`	String	Account at the collecting bank (E1_CONTA).
`e1_numbco`	String	Bank’s own number of the slip, ‘nosso número’ (E1_NUMBCO).
`e1_codbar`	String	Bank slip barcode as stored in Protheus (E1_CODBAR).
`e1_coddig`	String	Bank slip typeable line as stored in Protheus (E1_CODDIG); not filled on every release or setup.
`e1_idcnab`	String	CNAB identifier sent to the bank (E1_IDCNAB).
`e1_numbor`	String	Collection batch (borderô) number (E1_NUMBOR).
`e1_databor`	Date	Date of the collection batch (E1_DATABOR).
`e1_vend1`	String	Code of the main sales representative (E1_VEND1); joins sellers.a3_cod.
`e1_pedido`	String	Sales order number that originated the receivable (E1_PEDIDO).
`e1_serie`	String	Invoice series (E1_SERIE).
`e1_fatura`	String	Number of the grouping invoice, when the receivable was grouped (E1_FATURA).
`e1_origem`	String	Protheus routine that created the receivable (E1_ORIGEM).
`e1_filorig`	String	Branch where the receivable originated (E1_FILORIG).
`e1_hist`	String	Free-text history of the receivable (E1_HIST).
`boleto_barcode`	String	44-digit bank slip barcode, validated (general check digit) by the connector from E1_CODBAR or E1_CODDIG; null when Protheus has no valid bank slip for the receivable.
`boleto_digitable_line`	String	47-digit bank slip typeable line (linha digitável) derived by the connector from the barcode, following the FEBRABAN layout; null when there is no valid bank slip.
`extra_fields`	String (JSON)	Every other field Protheus returned for the record (custom fields, fields of newer releases), as a JSON object keyed by the lower-case Protheus field name.

Customers

Stream name: customers. Source: SA1 - Clientes.Sync Strategy:

Full table (the whole table is read on every run)
Primary key(s): a1_filial, a1_cod, a1_loja

Field	Type	Description
`a1_filial`	String	Branch (filial) code of the record; blank when the table is shared by every branch of the company.
`a1_cod`	String	Customer code (A1_COD).
`a1_loja`	String	Customer store/unit (A1_LOJA); a customer may have several.
`a1_nome`	String	Customer legal name (A1_NOME).
`a1_nreduz`	String	Customer trade/short name (A1_NREDUZ).
`a1_pessoa`	String	Person type (A1_PESSOA): F individual, J company.
`a1_tipo`	String	Customer type for taxes (A1_TIPO): F final consumer, L rural producer, R reseller, S ICMS substitution, X export.
`a1_cgc`	String	CNPJ (company) or CPF (individual) of the customer (A1_CGC).
`a1_inscr`	String	State registration (A1_INSCR).
`a1_inscrm`	String	Municipal registration (A1_INSCRM).
`a1_email`	String	E-mail of the customer (A1_EMAIL).
`a1_ddd`	String	Area code of the phone (A1_DDD).
`a1_tel`	String	Phone number (A1_TEL).
`a1_contato`	String	Contact person (A1_CONTATO).
`a1_end`	String	Street address (A1_END).
`a1_complem`	String	Address complement (A1_COMPLEM).
`a1_bairro`	String	District (A1_BAIRRO).
`a1_mun`	String	City name (A1_MUN).
`a1_cod_mun`	String	City IBGE code (A1_COD_MUN).
`a1_est`	String	State abbreviation (A1_EST).
`a1_cep`	String	ZIP code (A1_CEP).
`a1_pais`	String	Country code (A1_PAIS).
`a1_endcob`	String	Billing address (A1_ENDCOB).
`a1_bairroc`	String	Billing district (A1_BAIRROC).
`a1_munc`	String	Billing city (A1_MUNC).
`a1_estc`	String	Billing state (A1_ESTC).
`a1_cepc`	String	Billing ZIP code (A1_CEPC).
`a1_vend`	String	Code of the customer’s sales representative (A1_VEND); joins sellers.a3_cod.
`a1_cond`	String	Default payment term (A1_COND); joins payment_terms.e4_codigo.
`a1_tabela`	String	Default price table (A1_TABELA); joins price_tables.da0_codtab.
`a1_naturez`	String	Default financial nature (A1_NATUREZ).
`a1_risco`	String	Credit risk rating (A1_RISCO): A to E.
`a1_lc`	Number	Credit limit (A1_LC).
`a1_venclc`	Date	Credit limit expiry date (A1_VENCLC).
`a1_ultcom`	Date	Date of the last purchase (A1_ULTCOM).
`a1_dtcad`	Date	Registration date (A1_DTCAD).
`a1_hpage`	String	Web site (A1_HPAGE).
`a1_msblql`	String	Blocked flag (A1_MSBLQL): 1 blocked, 2 or blank active.
`extra_fields`	String (JSON)	Every other field Protheus returned for the record (custom fields, fields of newer releases), as a JSON object keyed by the lower-case Protheus field name.

Products

Stream name: products. Source: SB1 - Produtos.Sync Strategy:

Full table (the whole table is read on every run)
Primary key(s): b1_filial, b1_cod

Field	Type	Description
`b1_filial`	String	Branch (filial) code of the record; blank when the table is shared by every branch of the company.
`b1_cod`	String	Product code (B1_COD).
`b1_desc`	String	Product description/title (B1_DESC).
`b1_tipo`	String	Product type (B1_TIPO): PA finished good, MP raw material, ME merchandise, etc.
`b1_um`	String	Unit of measure (B1_UM).
`b1_segum`	String	Second unit of measure (B1_SEGUM).
`b1_conv`	Number	Conversion factor between the two units (B1_CONV).
`b1_grupo`	String	Product group code (B1_GRUPO).
`b1_locpad`	String	Default warehouse (B1_LOCPAD); joins warehouses.nnr_codigo.
`b1_prv1`	Number	Base sale price registered on the product (B1_PRV1); price tables hold the commercial prices.
`b1_custd`	Number	Standard cost (B1_CUSTD).
`b1_uprc`	Number	Last purchase price (B1_UPRC).
`b1_codbar`	String	Barcode / EAN of the product (B1_CODBAR).
`b1_posipi`	String	NCM tax classification (B1_POSIPI).
`b1_cest`	String	CEST code (B1_CEST).
`b1_origem`	String	Tax origin of the goods (B1_ORIGEM).
`b1_peso`	Number	Net weight (B1_PESO).
`b1_pesbru`	Number	Gross weight (B1_PESBRU).
`b1_ts`	String	Default outgoing tax operation code, TES (B1_TS).
`b1_te`	String	Default incoming tax operation code, TES (B1_TE).
`b1_ucom`	Date	Date of the last purchase (B1_UCOM).
`b1_msblql`	String	Blocked flag (B1_MSBLQL): 1 blocked, 2 or blank active.
`extra_fields`	String (JSON)	Every other field Protheus returned for the record (custom fields, fields of newer releases), as a JSON object keyed by the lower-case Protheus field name.

Product complements

Stream name: product_complements. Source: SB5 - Complemento de Produto.Sync Strategy:

Full table (the whole table is read on every run)
Primary key(s): b5_filial, b5_cod

Field	Type	Description
`b5_filial`	String	Branch (filial) code of the record; blank when the table is shared by every branch of the company.
`b5_cod`	String	Product code (B5_COD); joins products.b1_cod.
`b5_ceme`	String	Extended product name/description (B5_CEME).
`extra_fields`	String (JSON)	Every other field Protheus returned for the record (custom fields, fields of newer releases), as a JSON object keyed by the lower-case Protheus field name.

Price tables

Stream name: price_tables. Source: DA0 - Tabelas de Preço.Sync Strategy:

Full table (the whole table is read on every run)
Primary key(s): da0_filial, da0_codtab

Field	Type	Description
`da0_filial`	String	Branch (filial) code of the record; blank when the table is shared by every branch of the company.
`da0_codtab`	String	Price table code (DA0_CODTAB).
`da0_descri`	String	Price table description (DA0_DESCRI).
`da0_datde`	Date	First day the table is valid (DA0_DATDE).
`da0_horade`	String	Time the table starts being valid (DA0_HORADE).
`da0_datate`	Date	Last day the table is valid (DA0_DATATE); empty when open-ended.
`da0_horate`	String	Time the table stops being valid (DA0_HORATE).
`da0_condpg`	String	Payment term tied to the table (DA0_CONDPG).
`da0_ativo`	String	Active flag (DA0_ATIVO): 1 active, 2 inactive.
`extra_fields`	String (JSON)	Every other field Protheus returned for the record (custom fields, fields of newer releases), as a JSON object keyed by the lower-case Protheus field name.

Price table items

Stream name: price_table_items. Source: DA1 - Itens da Tabela de Preço.Sync Strategy:

Full table (the whole table is read on every run)
Primary key(s): da1_filial, da1_codtab, da1_item, da1_codpro

Field	Type	Description
`da1_filial`	String	Branch (filial) code of the record; blank when the table is shared by every branch of the company.
`da1_codtab`	String	Price table code (DA1_CODTAB); joins price_tables.da0_codtab.
`da1_item`	String	Item number inside the price table (DA1_ITEM).
`da1_codpro`	String	Product code (DA1_CODPRO); joins products.b1_cod.
`da1_grupo`	String	Product group, for prices set per group (DA1_GRUPO).
`da1_prcven`	Number	Sale price (DA1_PRCVEN).
`da1_vlrdes`	Number	Discount value (DA1_VLRDES).
`da1_perdes`	Number	Discount percentage (DA1_PERDES).
`da1_prcmax`	Number	Maximum price (DA1_PRCMAX).
`da1_ativo`	String	Active flag (DA1_ATIVO): 1 active, 2 inactive.
`da1_estado`	String	State the price applies to (DA1_ESTADO); blank for every state.
`da1_tpoper`	String	Operation type the price applies to (DA1_TPOPER).
`da1_qtdlot`	Number	Quantity up to which the price applies, for tiered prices (DA1_QTDLOT).
`da1_indlot`	String	Lot/tier indicator (DA1_INDLOT).
`da1_moeda`	Number	Currency number of the price (DA1_MOEDA).
`da1_datvig`	Date	Date the price becomes valid (DA1_DATVIG).
`da1_frete`	Number	Freight value (DA1_FRETE).
`extra_fields`	String (JSON)	Every other field Protheus returned for the record (custom fields, fields of newer releases), as a JSON object keyed by the lower-case Protheus field name.

Stock balances

Stream name: stock_balances. Source: SB2 - Saldos em Estoque.Sync Strategy:

Full table (the whole table is read on every run)
Primary key(s): b2_filial, b2_cod, b2_local

Field	Type	Description
`b2_filial`	String	Branch (filial) code of the record; blank when the table is shared by every branch of the company.
`b2_cod`	String	Product code (B2_COD); joins products.b1_cod.
`b2_local`	String	Warehouse code (B2_LOCAL); joins warehouses.nnr_codigo.
`b2_qatu`	Number	Current physical quantity in stock (B2_QATU).
`b2_reserva`	Number	Quantity reserved (B2_RESERVA).
`b2_qemp`	Number	Quantity committed to production orders (B2_QEMP).
`b2_qpedven`	Number	Quantity in sales orders not yet released (B2_QPEDVEN).
`b2_salpedi`	Number	Quantity in purchase orders still to arrive (B2_SALPEDI).
`b2_qaclass`	Number	Quantity waiting for classification (B2_QACLASS).
`b2_cm1`	Number	Average unit cost in the local currency (B2_CM1).
`b2_vatu1`	Number	Total stock value in the local currency (B2_VATU1).
`b2_dinvent`	Date	Date of the last inventory count (B2_DINVENT).
`extra_fields`	String (JSON)	Every other field Protheus returned for the record (custom fields, fields of newer releases), as a JSON object keyed by the lower-case Protheus field name.

Warehouses

Stream name: warehouses. Source: NNR - Locais de Estoque.Sync Strategy:

Full table (the whole table is read on every run)
Primary key(s): nnr_filial, nnr_codigo

Field	Type	Description
`nnr_filial`	String	Branch (filial) code of the record; blank when the table is shared by every branch of the company.
`nnr_codigo`	String	Warehouse code (NNR_CODIGO).
`nnr_descri`	String	Warehouse description (NNR_DESCRI).
`extra_fields`	String (JSON)	Every other field Protheus returned for the record (custom fields, fields of newer releases), as a JSON object keyed by the lower-case Protheus field name.

Sales orders

Stream name: sales_orders. Source: SC5 - Pedidos de Venda.Sync Strategy:

Full table (the whole table is read on every run)
Primary key(s): c5_filial, c5_num

Field	Type	Description
`c5_filial`	String	Branch (filial) code of the record; blank when the table is shared by every branch of the company.
`c5_num`	String	Sales order number (C5_NUM).
`c5_tipo`	String	Order type (C5_TIPO): N normal, D return, B goods for processing, C/I/P price complements.
`c5_cliente`	String	Customer code (C5_CLIENTE); joins customers.a1_cod.
`c5_lojacli`	String	Customer store/unit (C5_LOJACLI); joins customers.a1_loja.
`c5_client`	String	Delivery customer code (C5_CLIENT).
`c5_lojaent`	String	Delivery customer store/unit (C5_LOJAENT).
`c5_condpag`	String	Payment term (C5_CONDPAG); joins payment_terms.e4_codigo.
`c5_tabela`	String	Price table used (C5_TABELA); joins price_tables.da0_codtab.
`c5_vend1`	String	Main sales representative (C5_VEND1); joins sellers.a3_cod.
`c5_emissao`	Date	Order date (C5_EMISSAO).
`c5_tpfrete`	String	Freight type (C5_TPFRETE): C CIF, F FOB, T third party, S none.
`c5_frete`	Number	Freight value (C5_FRETE).
`c5_transp`	String	Carrier code (C5_TRANSP).
`c5_moeda`	Number	Currency number (C5_MOEDA).
`c5_descont`	Number	Discount value of the order (C5_DESCONT).
`c5_liberok`	String	Release flag (C5_LIBEROK): S when the order was released.
`c5_blq`	String	Block flag (C5_BLQ): blank unblocked, 1 business rule, 2 budget.
`c5_nota`	String	Invoice number, once invoiced (C5_NOTA).
`c5_serie`	String	Invoice series (C5_SERIE).
`c5_mennota`	String	Message printed on the invoice (C5_MENNOTA).
`extra_fields`	String (JSON)	Every other field Protheus returned for the record (custom fields, fields of newer releases), as a JSON object keyed by the lower-case Protheus field name.

Sales order items

Stream name: sales_order_items. Source: SC6 - Itens dos Pedidos de Venda.Sync Strategy:

Full table (the whole table is read on every run)
Primary key(s): c6_filial, c6_num, c6_item, c6_produto

Field	Type	Description
`c6_filial`	String	Branch (filial) code of the record; blank when the table is shared by every branch of the company.
`c6_num`	String	Sales order number (C6_NUM); joins sales_orders.c5_num.
`c6_item`	String	Item number inside the order (C6_ITEM).
`c6_produto`	String	Product code (C6_PRODUTO); joins products.b1_cod.
`c6_descri`	String	Product description on the item (C6_DESCRI).
`c6_um`	String	Unit of measure (C6_UM).
`c6_qtdven`	Number	Quantity sold (C6_QTDVEN).
`c6_prcven`	Number	Unit sale price (C6_PRCVEN).
`c6_prunit`	Number	List unit price before discounts (C6_PRUNIT).
`c6_valor`	Number	Total value of the item (C6_VALOR).
`c6_descont`	Number	Discount percentage (C6_DESCONT).
`c6_valdesc`	Number	Discount value (C6_VALDESC).
`c6_qtdent`	Number	Quantity already delivered/invoiced (C6_QTDENT).
`c6_local`	String	Warehouse the item ships from (C6_LOCAL).
`c6_tes`	String	Tax operation code, TES (C6_TES).
`c6_cf`	String	Fiscal operation code, CFOP (C6_CF).
`c6_entreg`	Date	Delivery date (C6_ENTREG).
`c6_cli`	String	Customer code (C6_CLI).
`c6_loja`	String	Customer store/unit (C6_LOJA).
`c6_nota`	String	Invoice number, once invoiced (C6_NOTA).
`c6_serie`	String	Invoice series (C6_SERIE).
`c6_datfat`	Date	Invoicing date (C6_DATFAT).
`c6_blq`	String	Block flag of the item (C6_BLQ): R residue eliminated, S manual block.
`extra_fields`	String (JSON)	Every other field Protheus returned for the record (custom fields, fields of newer releases), as a JSON object keyed by the lower-case Protheus field name.

Sales representatives

Stream name: sellers. Source: SA3 - Vendedores.Sync Strategy:

Full table (the whole table is read on every run)
Primary key(s): a3_filial, a3_cod

Field	Type	Description
`a3_filial`	String	Branch (filial) code of the record; blank when the table is shared by every branch of the company.
`a3_cod`	String	Sales representative code (A3_COD).
`a3_nome`	String	Sales representative name (A3_NOME).
`a3_nreduz`	String	Short name (A3_NREDUZ).
`a3_tipo`	String	Type (A3_TIPO): I internal, E external, P partner.
`a3_cgc`	String	CNPJ or CPF of the sales representative (A3_CGC).
`a3_email`	String	E-mail (A3_EMAIL).
`a3_dddtel`	String	Area code of the phone (A3_DDDTEL).
`a3_tel`	String	Phone number (A3_TEL).
`a3_comis`	Number	Default commission percentage (A3_COMIS).
`a3_msblql`	String	Blocked flag (A3_MSBLQL): 1 blocked, 2 or blank active.
`extra_fields`	String (JSON)	Every other field Protheus returned for the record (custom fields, fields of newer releases), as a JSON object keyed by the lower-case Protheus field name.

Payment terms

Stream name: payment_terms. Source: SE4 - Condições de Pagamento.Sync Strategy:

Full table (the whole table is read on every run)
Primary key(s): e4_filial, e4_codigo

Field	Type	Description
`e4_filial`	String	Branch (filial) code of the record; blank when the table is shared by every branch of the company.
`e4_codigo`	String	Payment term code (E4_CODIGO).
`e4_tipo`	String	Payment term type (E4_TIPO), which defines how E4_COND is read.
`e4_cond`	String	Payment term rule (E4_COND), e.g. 30,60,90 for days after issue.
`e4_descri`	String	Payment term description (E4_DESCRI).
`e4_msblql`	String	Blocked flag (E4_MSBLQL): 1 blocked, 2 or blank active.
`extra_fields`	String (JSON)	Every other field Protheus returned for the record (custom fields, fields of newer releases), as a JSON object keyed by the lower-case Protheus field name.

Branches

Stream name: branches. Source: Company group branches (framework API).Sync Strategy:

Full table (the whole table is read on every run)
Primary key(s): enterprise_group, code

Field	Type	Description
`enterprise_group`	String	Company group code (grupo de empresas, M0_CODIGO); the first part of the tenantId.
`company_code`	String	Company code inside the group (Gestão Corporativa layout).
`unit_of_business`	String	Business unit code inside the company (Gestão Corporativa layout).
`code`	String	Branch code (M0_CODFIL), as found in the *_filial columns of the other streams. Branch (filial) code of the record.
`description`	String	Branch name (M0_NOME / M0_FILIAL).
`title`	String	Branch legal or trade name (M0_NOMECOM).
`cgc`	String	CNPJ of the branch (M0_CGC).
`state_registration`	String	State registration of the branch (M0_INSC).
`city_registration`	String	Municipal registration of the branch (M0_INSCM).
`street`	String	Street address of the branch (M0_ENDENT).
`complement`	String	Address complement of the branch.
`neighborhood`	String	District of the branch (M0_BAIRENT).
`city`	String	City of the branch (M0_CIDENT).
`city_code`	String	City IBGE code of the branch (M0_CODMUN).
`state`	String	State of the branch (M0_ESTENT).
`zip_code`	String	ZIP code of the branch (M0_CEPENT).
`phone`	String	Phone of the branch (M0_TEL).
`extra_fields`	String (JSON)	Every other field Protheus returned for the record (custom fields, fields of newer releases), as a JSON object keyed by the lower-case Protheus field name.

Get started

Context

Activate

Organizations

Workspaces

Resources

TOTVS Protheus as a data source

Before you start

Configuring TOTVS Protheus as a Source

1. Add account access

2. Select streams

3. Configure data streams

4. Configure data source

5. Check your new source

Good to know

Streams and Fields

Available streams

Fields by stream

​Before you start

​Configuring TOTVS Protheus as a Source

​1. Add account access

​2. Select streams

​3. Configure data streams

​4. Configure data source

​5. Check your new source

​Good to know

​Streams and Fields

​Available streams

​Fields by stream

Before you start

Configuring TOTVS Protheus as a Source

1. Add account access

2. Select streams

3. Configure data streams

4. Configure data source

5. Check your new source

Good to know

Streams and Fields

Available streams

Fields by stream