A3PL to Intermediate XML

A3PL Data

Configuration (JSON)

{
	"*_940": {
		"ParentNodeMap": {
			"1040": [
				"1020"
			],
			"1060": [
				"1020"
			],
			"1070": [
				"1060",
				"1020"
			],
			"1090": [
				"1020"
			],
			"1110": [
				"1020"
			],
			"1120": [
				"1020"
			],
			"1130": [
				"1020"
			],
			"1140": [
				"1020"
			],
			"1141": [
				"1020"
			],
			"2005": [
				"1020"
			],
			"2020": [
				"2005",
				"1020"
			],
			"2030": [
				"2020"
			],
			"2040": [
				"2020"
			],
			"2045": [
				"2020"
			],
			"3010": [
				"1020"
			]
		},
		"Fields": {
			"1020": [
				{"FieldName": "OrderStatus","Length": 1},
				{"FieldName": "OrderNumber","Length": 22},
				{"FieldName": "PONumber","Length": 22},
				{"FieldName": "LinkSequenceNumber","Length": 8},
				{"FieldName": "MasterLinkNumber","Length": 22},
				{"FieldName": "TransactionTypeCode","Length": 2},
				{"FieldName": "ActionCode","Length": 2},
				{"FieldName": "ParcelCarrierAccountNumber","Length": 20},
				{"FieldName": "WarehouseCode","Length": 4},
				{"FieldName": "ReferenceNumber3","Length": 22},
				{"FieldName": "ReferenceNumber4","Length": 22}
			],
			"1040": [
				{"FieldName": "IdentifierCode","Length": 3},
				{"FieldName": "Name","Length": 60},
				{"FieldName": "IDType","Length": 2},
				{"FieldName": "EntityCode","Length": 80}
			],
			"1141": [
				{"FieldName":"WarehouseName", "Length":50}
			
			],
			"1060": [
				{"FieldName": "Address1","Length": 55},
				{"FieldName": "Address2","Length": 55}
			],
			"1070": [
				{"FieldName": "City","Length": 30},
				{"FieldName": "State","Length": 2},
				{"FieldName": "PostCode","Length": 15},
				{"FieldName": "Country","Length": 3}
			],
			"1090": [
				{"FieldName": "Qualifier","Length": 3},
				{"FieldName": "ReferenceID","Length": 30},
				{"FieldName": "ReferenceDescription","Length": 45},
				{"FieldName": "Date","Length": 8}
			],
			"1110": [
				{"FieldName": "Qualifier","Length": 2},
				{"FieldName": "Date","Length": 8},
				{"FieldName": "Qualifier","Length": 2},
				{"FieldName": "Time","Length": 4}
			],
			"1120": [
				{"FieldName": "Code","Length": 3},
				{"FieldName": "Remark","Length": 80}
			],
			"1130": [
				{"FieldName": "EquipmentDescriptionCode","Length": 2},
				{"FieldName": "Temperature1","Length": 6},
				{"FieldName": "UnitOfMeasure1","Length": 2},
				{"FieldName": "Temperature2","Length": 6},
				{"FieldName": "UnitOfMeasure2","Length": 2},
				{"FieldName": "Message","Length": 60}
			],
			"1140": [
				{"FieldName": "MethodofPayment","Length": 2},
				{"FieldName": "TransportationMethod","Length": 2},
				{"FieldName": "PalletExchangeCode","Length": 1},
				{"FieldName": "UnitLoadOptionCode","Length": 2},
				{"FieldName": "Route","Length": 35},
				{"FieldName": "FOBPointCode","Length": 2},
				{"FieldName": "FOBPoint","Length": 30},
				{"FieldName": "CODMethodofPayment","Length": 1},
				{"FieldName": "Amount","Length": 17},
				{"FieldName": "SCAC","Length": 4}
			],
			"1150": [
				{"FieldName": "AssignedNumber","Length": 9}
			],
			"2020": [
				{"FieldName": "Quantity","Length": 17},
				{"FieldName": "SKU","Length": 2},
				{"FieldName": "UPCCode","Length": 12},
				{"FieldName": "Qualifier","Length": 2},
				{"FieldName": "ItemCode","Length": 48},
				{"FieldName": "Qualifier","Length": 2},
				{"FieldName": "Level2","Length": 48},
				{"FieldName": "Filler","Length": 5},
				{"FieldName": "Filler","Length": 3},
				{"FieldName": "Filler","Length": 1},
				{"FieldName": "Reference","Length": 30},
				{"FieldName": "HoldCode","Length": 8},
				{"FieldName": "ShelfLifeDays","Length": 12},
				{"FieldName": "ConditionCode","Length": 2},
				{"FieldName": "Qualifier","Length": 2},
				{"FieldName": "ProductCode","Length": 48}
			],
			"2030": [
				{"FieldName": "Description","Length": 45}
			],
			"2040": [
				{"FieldName": "Qualifier","Length": 3},
				{"FieldName": "ReferenceID","Length": 30},
				{"FieldName": "ReferenceDescription","Length": 45}
			],
			"2045": [
				{"FieldName": "Code","Length": 3},
				{"FieldName": "Remark","Length": 80}
			],
			"3010": [
				{"FieldName": "TotalQuantity","Length": 9},
				{"FieldName": "TotalWeight","Length": 12},
				{"FieldName": "UnitOfMeasure","Length": 2}
			]
		},
		"RecordTypeNames": {
			"1020":"WarehouseOrderIdentification",
			"1040":"EntityName",
			"1060":"EntityAddress",
			"1070":"GeographicLocation",
			"1090":"ReferenceIdentification",
			"1110":"DateTime",
			"1120":"NoteSpecialInstruction",
			"1130":"EquipmentandTemperature",
			"1140":"CarrierDetail",
			"1141":"WarehouseName",
			"2005":"AssignedNumber",
			"2020":"LineItemDetail",
			"2030":"ItemDescription",
			"2040":"ReferenceIdentification",
			"2045":"NoteSpecialInstruction",
			"3010":"TotalShipmentInformation"
		}
	},
	"*_943": {
		"ParentNodeMap": {
			"1040": [
				"1020"
			],
			"1060": [
				"1020"
			],
			"1070": [
				"1060",
				"1020"
			],
			"1090": [
				"1020"
			],
			"1110": [
				"1020"
			],
			"1120": [
				"1020"
			],
			"1130": [
				"1020"
			],
			"1140": [
				"1020"
			],
			"1141": [
				"1020"
			],
			"2005": [
				"1020"
			],
			"2020": [
				"2005",
				"1020"
			],
			"2030": [
				"2020"
			],
			"2040": [
				"2020"
			],
			"2045": [
				"2020"
			],
			"3010": [
				"1020"
			]
		},
		"Fields": {
			"1020": [
				{"FieldName": "ReportingCode","Length": 1},
				{"FieldName": "DepositorOrderNumber","Length": 22},
				{"FieldName": "Date","Length": 8},
				{"FieldName": "ProBillNumber","Length": 30},
				{"FieldName": "AgentShipmentIDNumber","Length": 12},
				{"FieldName": "PurchaseOrderNumber","Length": 22},
				{"FieldName": "MasterReference","Length": 22}
			],
			"1040": [
				{"FieldName": "IdentifierCode","Length": 3},
				{"FieldName": "Name","Length": 60},
				{"FieldName": "IDType","Length": 2},
				{"FieldName": "EntityCode","Length": 80}
			],
			"1060": [
				{"FieldName": "Address1","Length": 55},
				{"FieldName": "Address2","Length": 55}
			],
			"1070": [
				{"FieldName": "City","Length": 30},
				{"FieldName": "State","Length": 2},
				{"FieldName": "PostCode","Length": 15},
				{"FieldName": "Country","Length": 3}
			],
			"1090": [
				{"FieldName": "Qualifier","Length": 3},
				{"FieldName": "ReferenceID","Length": 30}
			],
			"1110": [
				{"FieldName": "Qualifier","Length": 2},
				{"FieldName": "Date","Length": 8}
			],
			"1120": [
				{"FieldName": "Code","Length": 3},
				{"FieldName": "Remark","Length": 80}
			],
			"1130": [
				{"FieldName": "TransportationMethod","Length": 2},
				{"FieldName": "SCAC","Length": 4},
				{"FieldName": "Route","Length": 35},
				{"FieldName": "ShipmentMethodOfPayment","Length": 2},
				{"FieldName": "EquipmentDescriptionCode","Length": 2},
				{"FieldName": "EquipmentInitial","Length": 4},
				{"FieldName": "EquipmentNumber","Length": 10}
			],
			"1150": [
				{"FieldName": "UnitLoadOptionCode","Length": 2},
				{"FieldName": "QuantityOfPalletsShipped","Length": 5},
				{"FieldName": "PalletExchangeCode","Length": 1},
				{"FieldName": "SealNumber1","Length": 15},
				{"FieldName": "SealNumber2","Length": 15}
			],
			"2020": [
				{"FieldName": "Quantity","Length": 12},
				{"FieldName": "SKU","Length": 2},
				{"FieldName": "UPCCode","Length": 12},
				{"FieldName": "Qualifier","Length": 2},
				{"FieldName": "ItemCode","Length": 48},
				{"FieldName": "Qualifier2","Length": 2},
				{"FieldName": "Level2","Length": 48},
				{"FieldName": "FreightClassCode","Length": 5},
				{"FieldName": "RateClassCode","Length": 3},
				{"FieldName": "Qualifier","Length": 1},
				{"FieldName": "HoldCode","Length": 30},
				{"FieldName": "PalletBlock","Length": 8},
				{"FieldName": "ConditionHold","Length": 2},
				{"FieldName": "Qualifier3","Length": 2},
				{"FieldName": "InventoryLevel3","Length": 48},
				{"FieldName": "Qualifier","Length": 2},
				{"FieldName": "InventoryLevel4","Length": 48}
			],
			"2030": [
				{"FieldName": "Description1","Length": 45},
				{"FieldName": "Description2","Length": 40},
				{"FieldName": "Description3","Length": 40},
				{"FieldName": "Description4","Length": 40}
			],
			"2040": [
				{"FieldName": "Qualifier","Length": 3},
				{"FieldName": "ReferenceID","Length": 30},
				{"FieldName": "ReferenceDescription","Length": 45}
			],
			"3010": [
				{"FieldName": "TotalQuantity","Length": 9},
				{"FieldName": "TotalWeight","Length": 12},
				{"FieldName": "UnitOfMeasure","Length": 2}
			]
		},
		"RecordTypeNames": {
			"1020":"WarehouseOrderIdentification",
			"1040":"EntityName",
			"1060":"EntityAddress",
			"1070":"GeographicLocation",
			"1090":"ReferenceIdentification",
			"1110":"DateTime",
			"1120":"NoteSpecialInstruction",
			"1130":"EquipmentandTemperature",
			"1140":"CarrierDetail",
			"2005":"AssignedNumber",
			"2020":"LineItemDetail",
			"2030":"ItemDescription",
			"2040":"ReferenceIdentification",
			"2045":"NoteSpecialInstruction",
			"3010":"TotalShipmentInformation"
		}
	}
}