Bling! Field Reference


Fields

IDTypeNameDescriptionReport
account_idTEXTAccount IDThe Account ID
account_nameTEXTAccount NameThe Account Name
datasourceTEXTData SourceThe name of the Windsor connector returning the row
dateDATEDateThe Date
invoice_date_issueDATEInvoice Date IssueInvoice Date (Notas Fiscais Eletrônicas)
invoice_date_operationDATEInvoice Date OperationInvoice Date Operation (Notas Fiscais Eletrônicas)
invoice_idTEXTInvoice IDInvoice ID (Notas Fiscais Eletrônicas)
invoice_numberTEXTInvoice NumberInvoice Number (Notas Fiscais Eletrônicas)
invoice_statusTEXTInvoice StatusInvoice Status (Notas Fiscais Eletrônicas) Available values : 1 (Pendente), 2 (Cancelada), 3 (Aguardando recibo), 4 (Rejeitada), 5 (Autorizada), 6 (Emitida DANFE), 7 (Registrada), 8 (Aguardando protocolo), 9 (Denegada), 10 (Consulta situação), 11 (Bloqueada)
invoice_typeTEXTInvoice TypeInvoice Type (Notas Fiscais Eletrônicas) Available values : 0 (Entrada), 1 (Saída)
order_purchases_dateDATEOrder Purchases DateOrder Purchases Date (Pedidos Compras)
order_purchases_date_previsionDATEOrder Purchases Date PrevisionOrder Purchases Date Prevision (Pedidos Compras)
order_purchases_idTEXTOrder Purchases IDOrder Purchases ID (Pedidos Compras)
order_purchases_numberTEXTOrder Purchases NumberOrder Purchases Number (Pedidos Compras)
order_purchases_totalNUMERICOrder Purchases TotalOrder Purchases Total (Pedidos Compras)
order_purchases_total_productsNUMERICOrder Purchases Total ProductsOrder Purchases Total Products (Pedidos Compras)
order_sales_dateDATEOrder Sales DateOrder Sales Date (Pedidos Vendas)
order_sales_date_outDATEOrder Sales Date OutOrder Sales Date Out (Pedidos Vendas)
order_sales_date_previsionDATEOrder Sales Date PrevisionOrder Sales Date Prevision (Pedidos Vendas)
order_sales_idTEXTOrder Sales IDOrder Sales ID (Pedidos Vendas)
order_sales_numberTEXTOrder Sales NumberOrder Sales Number (Pedidos Vendas)
order_sales_number_storeTEXTOrder Sales Number StoreOrder Sales Number Store (Pedidos Vendas)
order_sales_totalNUMERICOrder Sales TotalOrder Sales Total (Pedidos Vendas)
order_sales_total_productsNUMERICOrder Sales Total ProductsOrder Sales Total Products (Pedidos Vendas)
product_codeTEXTProduct Code (product_code)Product Code
product_formatTEXTProduct FormatProduct Format
product_idTEXTProduct IDProduct ID
product_nameTEXTProduct NameProduct Name
product_priceNUMERICProduct PriceProduct Price
product_short_descriptionTEXTProduct Short DescriptionProduct Short Description
product_statusTEXTProduct StatusProduct Status
product_typeTEXTProduct TypeProduct Type Available values : P (Produtos), S (Serviços), E (Composições), PS (Produtos simples), C (Com variações), V (Variações)
sourceTEXTSourceThe name of the Windsor connector returning the row
todayDATETodayToday's date