Árvore de páginas

Excel

Aba Pedidos:

identifierweightvolumepickupTimeWindowStartpickupTimeWindowEnddeliveryTimeWindowStartdeliveryTimeWindowEndserviceLoadDurationserviceUnloadDurationoriginIdentifierdestinationIdentifier
Pedido_001
226
10
2021-07-01T08:00:00.0-03:00
2021-07-01T18:00:00.0-03:00
2021-07-01T08:00:00.0-03:00
2021-07-04T18:00:00.0-03:00
600000
1800000
CD-01 - CD JUNDIAI
CLI-000506-01 - MAKRO ATACADISTA S A
Pedido_002
5600
10
2021-07-01T08:00:00.0-03:00
2021-07-01T18:00:00.0-03:00
2021-07-01T08:00:00.0-03:00
2021-07-04T18:00:00.0-03:00
600000
1800000
CD-01 - CD JUNDIAI
CLI-056194-01 - SEGALA'S ALIMENTOS LTDA

Aba Localidades:

identifieroperationaddressCountryaddressStateaddressCityaddressZipCodeaddressAddressaddressLatitudeaddressLongitude
Casa antiga
UNRESTRICTED
BRA
SP
São Paulo
06766140
Rua Virginia Polzato Pereira, 215
-23,163984
-46,934046
CLI-000506-01 - MAKRO ATACADISTA S A
UNRESTRICTED
BRA
SP
São Paulo
05688990
Rua do Makro, 2015
-23,674084
-46,571411
CD-01 - CD JUNDIAI
UNRESTRICTED
BRA
SP
Jundiai
35666458
Rua do cd jundiai, 200
-23,163984
-46,934046
CLI-056194-01 - SEGALA'S ALIMENTOS LTDA
UNRESTRICTED
BRA
SP
São Paulo
05647895
Rua do SEGALA, 200
-26,890883
-48,989389

Json

{
    "orders": [
        {
            "identifier": "Pedido_001",
            "weight": 226,
            "volume": 10,
            "pickupTimeWindowStart": "2021-07-01T08:00:00.0-03:00",
            "pickupTimeWindowEnd": "2021-07-01T18:00:00.0-03:00",
            "deliveryTimeWindowStart": "2021-07-01T08:00:00.0-03:00",
            "deliveryTimeWindowEnd": "2021-07-04T18:00:00.0-03:00",
            "serviceLoadDuration": 600000,
            "serviceUnloadDuration": 1800000,
            "originIdentifier": "CD-01 - CD JUNDIAI",
            "destinationIdentifier": "CLI-000506-01 - MAKRO ATACADISTA S A"
        },
        {
            "identifier": "Pedido_002",
            "weight": 5600,
            "volume": 10,
            "pickupTimeWindowStart": "2021-07-01T08:00:00.0-03:00",
            "pickupTimeWindowEnd": "2021-07-01T18:00:00.0-03:00",
            "deliveryTimeWindowStart": "2021-07-01T08:00:00.0-03:00",
            "deliveryTimeWindowEnd": "2021-07-04T18:00:00.0-03:00",
            "serviceLoadDuration": 600000,
            "serviceUnloadDuration": 1800000,
            "originIdentifier": "CD-01 - CD JUNDIAI",
            "destinationIdentifier": "CLI-056194-01 - SEGALA'S ALIMENTOS LTDA"
        }
    ],
    "localities": [
        {
            "identifier": "Casa antiga",
            "operation": "UNRESTRICTED",
            "address": {
                "country": "BRA",
                "state": "SP",
                "city": "São Paulo",
                "zipCode": "06766140",
                "address": "Rua Virginia Polzato Pereira, 215",
                "latitude": -23.163984,
                "longitude": -46.934046
            }
        },
        {
            "identifier": "CLI-000506-01 - MAKRO ATACADISTA S A",
            "operation": "UNRESTRICTED",
            "address": {
                "country": "BRA",
                "state": "SP",
                "city": "São Paulo",
                "zipCode": "05688990",
                "address": "Rua do Makro, 2015",
                "latitude": -23.674084,
                "longitude": -46.571411
            }
        },
        {
            "identifier": "CD-01 - CD JUNDIAI",
            "operation": "UNRESTRICTED",
            "address": {
                "country": "BRA",
                "state": "SP",
                "city": "Jundiai",
                "zipCode": "35666458",
                "address": "Rua do cd jundiai, 200",
                "latitude": -23.163984,
                "longitude": -46.934046
            }
        },
        {
            "identifier": "CLI-056194-01 - SEGALA'S ALIMENTOS LTDA",
            "operation": "UNRESTRICTED",
            "address": {
                "country": "BRA",
                "state": "SP",
                "city": "São Paulo",
                "zipCode": "05647895",
                "address": "Rua do SEGALA, 200",
                "latitude": -26.890883,
                "longitude": -48.989389
            }
        }
    ]
}

Anexos

  Arquivo Modificado
Planilha do Microsoft Excel Pedido_exemplo.xlsx 23 ago, 2021 by Julio Vinicius Oliveira dos Santos
Arquivo Pedido_exemplo.json 23 ago, 2021 by Julio Vinicius Oliveira dos Santos

  • Sem rótulos