Pedido - Frete Original
{
"ordering": [
"CANAL_PEDIDO",
"UUID",
"ID_DO_PEDIDO",
"CODIGO_DE_REFERENCIA",
"DATA_DE_ADI\u00c7\u00c3O",
"DATA_DE_ALTERA\u00c7\u00c3O",
"NOME_CLIENTE(FATURA)",
"CPF_CLIENTE(FATURA)",
"EMAIL_CLIENTE(FATURA)",
"TELEFONE",
"ESTADO",
"CIDADE",
"NOME_CLIENTE",
"ENDERE\u00c7O",
"NUMERO",
"COMPLEMENTO",
"BAIRRO",
"CEP",
"TRANSPORTADORA",
"STATUS",
"METODO_PAGAMENTO",
"PARCELAS",
"TOTAL",
"QTD_ITENS",
"ID_SKU",
"CODIGO_DE_REFERENCIA_SKU",
"CODIGO_DE_REFERENCIA_PRODUTO",
"NOME_PRODUTO",
"PRE\u00c7O_UNITARIO",
"PRE\u00c7O_TOTAL",
"DESCONTO_ITEM",
"FRETE_ITEM",
"FRETE_TOTAL",
"FRETE_ORIGINAL",
"PEDIDO_TOTAL",
"DESCONTO_PEDIDO",
"OBS",
"ID_TRANSA\u00c7\u00c3O",
"TID",
"NSU",
"MASCARA_CART\u00c3O",
"DATA_TRANSA\u00c7AO",
"UUID_TRANSA\u00c7\u00c3O"
],
"fields": {
"PARCELAS": "transactions_installments",
"COMPLEMENTO": "order_shipping_detail_complement",
"BAIRRO": "order_shipping_detail_neighborhood",
"FRETE_ITEM": "item_shipping_total",
"ENDERE\u00c7O": "order_shipping_detail_address",
"UUID_TRANSA\u00c7\u00c3O": "transactions_transaction_uuid",
"ID_SKU": "item_sku_id",
"EMAIL_CLIENTE(FATURA)": "order_billing_detail_email",
"TID": "transactions_transaction_tid",
"FRETE_TOTAL": "order_shipping_total",
"ESTADO": "order_shipping_detail_state",
"METODO_PAGAMENTO": "transactions_payment_method",
"CODIGO_DE_REFERENCIA_PRODUTO": "item_product_reference_code",
"NOME_CLIENTE(FATURA)": "order_billing_detail_name",
"CIDADE": "order_shipping_detail_city",
"DATA_DE_ADI\u00c7\u00c3O": "order_add_date",
"DESCONTO_ITEM": "item_discount_unit_price",
"ID_TRANSA\u00c7\u00c3O": "transactions_transaction_id",
"CEP": "order_shipping_detail_postcode",
"TOTAL": "transactions_total",
"FRETE_ORIGINAL": "order_id",
"NSU": "transactions_transaction_nsu",
"STATUS": "order_status",
"ID_DO_PEDIDO": "order_id",
"NOME_PRODUTO": "item_sku_name",
"NOME_CLIENTE": "order_shipping_detail_name",
"CODIGO_DE_REFERENCIA_SKU": "item_sku_reference_code",
"NUMERO": "order_shipping_detail_number",
"PRE\u00c7O_UNITARIO": "item_unit_price",
"PEDIDO_TOTAL": "order_total",
"CANAL_PEDIDO": "order_channel",
"OBS": "order_observation",
"CODIGO_DE_REFERENCIA": "order_reference_code",
"PRE\u00c7O_TOTAL": "item_total_price",
"DATA_DE_ALTERA\u00c7\u00c3O": "order_update_date",
"CPF_CLIENTE(FATURA)": "order_billing_detail_document",
"UUID": "order_uuid",
"DESCONTO_PEDIDO": "order_discount_total",
"TRANSPORTADORA": "order_shipping_type",
"MASCARA_CART\u00c3O": "transactions_transaction_card_mask",
"DATA_TRANSA\u00c7AO": "transactions_transaction_add_date",
"QTD_ITENS": "item_quantity",
"TELEFONE": "order_shipping_detail_phone"
},
"format_eval": {
"FRETE_ORIGINAL": "order.cart.first().shipping_total_original if order.cart.exists() else ''"
}
}
Updated almost 2 years ago