Skip to content

Instantly share code, notes, and snippets.

@johntbush

johntbush/gist:c9424089c81147d27987a186dea26d09

Created February 10, 2017 16:08
Show Gist options
  • Save johntbush/c9424089c81147d27987a186dea26d09 to your computer and use it in GitHub Desktop.
Save johntbush/c9424089c81147d27987a186dea26d09 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
{
"RateDetails": {
"FbId": "FBLL1000691004813140001",
"LineNum": 3,
"RateScac": "KWEO_Onesource",
"TemplateId": "41228.40293",
"ICSNum": "663485",
"RatingCategory ": "RatedEqualsBilledUnvalidated",
"RatingDetails": "Rated at 12 USD Flat using AirOceanAccessorials in ICS 663485 for KWEO_Onesource for accessorial for this shipment EffectiveDate (10/25/2016 12:00:00 AM), ChargeCode (DFO), Qualifier (ORIGIN HANDLING AND DOCUM), OriginPort_Airport (THBKK), OriginCity (PHET BURI), OriginCountry (TH), OriginPostalCodeRange (10110), DestinationPort_Airport (CNSHA), DestinationCity (SHANGHAI), DestinationCountry (CN), DestinationPostalCodeRange (200131), ServiceLevel (LCL), ServiceScope (LCL), WeightRange (1000), QuantityRange (1). This is rated equals billed at 12 USD ..These are unknown missing LocationID, Subcarrier, OriginState, OriginZone, OriginRegion, DestinationState, DestinationZone, DestinationRegion, EquipmentType, FlowIndentifier, MileageBandRange.These are undefined Qualifier (ORIGIN HANDLING AND DOCUM), OriginPostalCodeRange (10110), DestinationCity (SHANGHAI), DestinationPostalCodeRange (200131), ServiceLevel (LCL), WeightRange (1000), QuantityRange (1).",
"TableName": "AirOceanAccessorials",
"RatingSummary": "Rated at 12 USD Flat using AirOceanAccessorials in ICS 663485 for KWEO_Onesource for accessorial. This is rated equals billed at 12 USD ..",
"TimeStamp": "2017-02-10T05:55:19"
},
"RateSet": [{
"FbId": "FBLL1000691004981740001",
"LineNum": 1,
"RateScac": "KWEO_Onesource",
"TemplateId": "41228.40293",
"TableType": "RateSet",
"TableName": "OneSourceLTLWorkbook",
"FieldName": "Customer",
"DataMetric": "NotImplemented",
"ParamsValue": "*",
"RateMetric": "R=B",
"TimeStamp": "2017-01-20T01:55:32"
}, {
"FbId": "FBLL1000691004981740001",
"LineNum": 1,
"RateScac": "KWEO_Onesource",
"TemplateId": "41228.40293",
"TableType": "RateSet",
"TableName": "OneSourceLTLWorkbook",
"FieldName": "Entity",
"DataMetric": "NotImplemented",
"ParamsValue": "100-0691",
"RateMetric": "R=B",
"TimeStamp": "2017-01-20T01:55:32"
}, {
"FbId": "FBLL1000691004981740001",
"LineNum": 1,
"RateScac": "KWEO_Onesource",
"TemplateId": "41228.40293",
"TableType": "RateSet",
"TableName": "OneSourceLTLWorkbook",
"FieldName": "SCAC",
"DataMetric": "NotImplemented",
"ParamsValue": "KWEO_Onesource",
"RateMetric": "R=B",
"TimeStamp": "2017-01-20T01:55:32"
}, {
"FbId": "FBLL1000691004981740001",
"LineNum": 1,
"RateScac": "KWEO_Onesource",
"TemplateId": "41228.40293",
"TableType": "RateSet",
"TableName": "OneSourceLTLWorkbook",
"FieldName": "ModeType",
"DataMetric": "NotImplemented",
"ParamsValue": "*",
"RateMetric": "R=B",
"TimeStamp": "2017-01-20T01:55:32"
}, {
"FbId": "FBLL1000691004981740001",
"LineNum": 1,
"RateScac": "KWEO_Onesource",
"TemplateId": "41228.40293",
"TableType": "RateSet",
"TableName": "OneSourceLTLWorkbook",
"FieldName": "AccountNumber",
"DataMetric": "NotImplemented",
"ParamsValue": "*",
"RateMetric": "R=B",
"TimeStamp": "2017-01-20T01:55:32"
}, {
"FbId": "FBLL1000691004981740001",
"LineNum": 1,
"RateScac": "KWEO_Onesource",
"TemplateId": "41228.40293",
"TableType": "RateSet",
"TableName": "OneSourceLTLWorkbook",
"FieldName": "BusinessUnit",
"DataMetric": "NotImplemented",
"ParamsValue": "*",
"RateMetric": "R=B",
"TimeStamp": "2017-01-20T01:55:32"
}, {
"FbId": "FBLL1000691004981740001",
"LineNum": 1,
"RateScac": "KWEO_Onesource",
"TemplateId": "41228.40293",
"TableType": "RateSet",
"TableName": "OneSourceLTLWorkbook",
"FieldName": "ServiceNationality",
"DataMetric": "NotImplemented",
"ParamsValue": "*",
"RateMetric": "R=B",
"TimeStamp": "2017-01-20T01:55:32"
}, {
"FbId": "FBLL1000691004981740001",
"LineNum": 1,
"RateScac": "KWEO_Onesource",
"TemplateId": "41228.40293",
"TableType": "RateSet",
"TableName": "OneSourceLTLWorkbook",
"FieldName": "ServiceDirection",
"DataMetric": "NotImplemented",
"ParamsValue": "*",
"RateMetric": "R=B",
"TimeStamp": "2017-01-20T01:55:32"
}, {
"FbId": "FBLL1000691004981740001",
"LineNum": 1,
"RateScac": "KWEO_Onesource",
"TemplateId": "41228.40293",
"TableType": "RateSet",
"TableName": "OneSourceLTLWorkbook",
"FieldName": "ChargeCategory",
"DataMetric": "NotImplemented",
"ParamsValue": "*",
"RateMetric": "R=B",
"TimeStamp": "2017-01-20T01:55:32"
}, {
"FbId": "FBLL1000691004981740001",
"LineNum": 1,
"RateScac": "KWEO_Onesource",
"TemplateId": "41228.40293",
"TableType": "RateSet",
"TableName": "OneSourceLTLWorkbook",
"FieldName": "Date",
"DataMetric": "NotImplemented",
"ParamsValue": "11/10/2016 12:00:00 AM",
"RateMetric": "R=B",
"TimeStamp": "2017-01-20T01:55:32"
}],
"RateTable": [{
"FbId": "FBLL1000691004981740001",
"LineNum": 1,
"RateScac": "KWEO_Onesource",
"TemplateId": "41228.40293",
"TableType": "RateTable",
"TableName": "OneSourceLTLWorkbook",
"FieldName": "ChargeCategory",
"DataMetric": "NotImplemented",
"ParamsValue": "ACCESSORIAL",
"RateMetric": "R=B",
"TimeStamp": "2017-01-20T01:55:32"
}, {
"FbId": "FBLL1000691004981740001",
"LineNum": 1,
"RateScac": "KWEO_Onesource",
"TemplateId": "41228.40293",
"TableType": "RateTable",
"TableName": "OneSourceLTLWorkbook",
"FieldName": "ChargeCode",
"DataMetric": "NotImplemented",
"ParamsValue": "PRC",
"RateMetric": "R=B",
"TimeStamp": "2017-01-20T01:55:32"
}, {
"FbId": "FBLL1000691004981740001",
"LineNum": 1,
"RateScac": "KWEO_Onesource",
"TemplateId": "41228.40293",
"TableType": "RateTable",
"TableName": "OneSourceLTLWorkbook",
"FieldName": "ServiceLevel",
"DataMetric": "NotImplemented",
"ParamsValue": "FCL",
"RateMetric": "R=B",
"TimeStamp": "2017-01-20T01:55:32"
}, {
"FbId": "FBLL1000691004981740001",
"LineNum": 1,
"RateScac": "KWEO_Onesource",
"TemplateId": "41228.40293",
"TableType": "RateTable",
"TableName": "OneSourceLTLWorkbook",
"FieldName": "ServiceScope",
"DataMetric": "NotImplemented",
"ParamsValue": "FCL",
"RateMetric": "R=B",
"TimeStamp": "2017-01-20T01:55:32"
}, {
"FbId": "FBLL1000691004981740001",
"LineNum": 1,
"RateScac": "KWEO_Onesource",
"TemplateId": "41228.40293",
"TableType": "RateTable",
"TableName": "OneSourceLTLWorkbook",
"FieldName": "FlowIdentifier",
"DataMetric": "NotImplemented",
"ParamsValue": "",
"RateMetric": "R=B",
"TimeStamp": "2017-01-20T01:55:32"
}],
"RateLookup": [{
"FbId": "FBLL1000691004981740001",
"LineNum": 1,
"RateScac": "KWEO_Onesource",
"TemplateId": "41228.40293",
"TableType": "RateLookup",
"TableName": "AirOceanAccessorials",
"FieldName": "EffectiveDate",
"DataMetric": "ValidData",
"ParamsValue": "11/10/2016 12:00:00 AM",
"RateMetric": "R=B",
"TimeStamp": "2017-01-20T01:55:32"
}, {
"FbId": "FBLL1000691004981740001",
"LineNum": 1,
"RateScac": "KWEO_Onesource",
"TemplateId": "41228.40293",
"TableType": "RateLookup",
"TableName": "AirOceanAccessorials",
"FieldName": "LocationID",
"DataMetric": "UnknownMissing",
"ParamsValue": "",
"RateMetric": "R=B",
"TimeStamp": "2017-01-20T01:55:32"
}, {
"FbId": "FBLL1000691004981740001",
"LineNum": 1,
"RateScac": "KWEO_Onesource",
"TemplateId": "41228.40293",
"TableType": "RateLookup",
"TableName": "AirOceanAccessorials",
"FieldName": "Subcarrier",
"DataMetric": "UnknownMissing",
"ParamsValue": "",
"RateMetric": "R=B",
"TimeStamp": "2017-01-20T01:55:32"
}, {
"FbId": "FBLL1000691004981740001",
"LineNum": 1,
"RateScac": "KWEO_Onesource",
"TemplateId": "41228.40293",
"TableType": "RateLookup",
"TableName": "AirOceanAccessorials",
"FieldName": "ChargeCode",
"DataMetric": "ValidData",
"ParamsValue": "PRC",
"RateMetric": "R=B",
"TimeStamp": "2017-01-20T01:55:32"
}, {
"FbId": "FBLL1000691004981740001",
"LineNum": 1,
"RateScac": "KWEO_Onesource",
"TemplateId": "41228.40293",
"TableType": "RateLookup",
"TableName": "AirOceanAccessorials",
"FieldName": "Qualifier",
"DataMetric": "Undefined",
"ParamsValue": "(HP) DOOR PICK UP",
"RateMetric": "R=B",
"TimeStamp": "2017-01-20T01:55:32"
}, {
"FbId": "FBLL1000691004981740001",
"LineNum": 1,
"RateScac": "KWEO_Onesource",
"TemplateId": "41228.40293",
"TableType": "RateLookup",
"TableName": "AirOceanAccessorials",
"FieldName": "OriginPort_Airport",
"DataMetric": "ValidData",
"ParamsValue": "CNSZX",
"RateMetric": "R=B",
"TimeStamp": "2017-01-20T01:55:32"
}, {
"FbId": "FBLL1000691004981740001",
"LineNum": 1,
"RateScac": "KWEO_Onesource",
"TemplateId": "41228.40293",
"TableType": "RateLookup",
"TableName": "AirOceanAccessorials",
"FieldName": "OriginCity",
"DataMetric": "ValidData",
"ParamsValue": "GUANGZHOU",
"RateMetric": "R=B",
"TimeStamp": "2017-01-20T01:55:32"
}, {
"FbId": "FBLL1000691004981740001",
"LineNum": 1,
"RateScac": "KWEO_Onesource",
"TemplateId": "41228.40293",
"TableType": "RateLookup",
"TableName": "AirOceanAccessorials",
"FieldName": "OriginState",
"DataMetric": "UnknownMissing",
"ParamsValue": "",
"RateMetric": "R=B",
"TimeStamp": "2017-01-20T01:55:32"
}, {
"FbId": "FBLL1000691004981740001",
"LineNum": 1,
"RateScac": "KWEO_Onesource",
"TemplateId": "41228.40293",
"TableType": "RateLookup",
"TableName": "AirOceanAccessorials",
"FieldName": "OriginCountry",
"DataMetric": "ValidData",
"ParamsValue": "CN",
"RateMetric": "R=B",
"TimeStamp": "2017-01-20T01:55:32"
}, {
"FbId": "FBLL1000691004981740001",
"LineNum": 1,
"RateScac": "KWEO_Onesource",
"TemplateId": "41228.40293",
"TableType": "RateLookup",
"TableName": "AirOceanAccessorials",
"FieldName": "OriginZone",
"DataMetric": "Undefined",
"ParamsValue": "Huangpu",
"RateMetric": "R=B",
"TimeStamp": "2017-01-20T01:55:32"
}, {
"FbId": "FBLL1000691004981740001",
"LineNum": 1,
"RateScac": "KWEO_Onesource",
"TemplateId": "41228.40293",
"TableType": "RateLookup",
"TableName": "AirOceanAccessorials",
"FieldName": "OriginRegion",
"DataMetric": "UnknownMissing",
"ParamsValue": "",
"RateMetric": "R=B",
"TimeStamp": "2017-01-20T01:55:32"
}, {
"FbId": "FBLL1000691004981740001",
"LineNum": 1,
"RateScac": "KWEO_Onesource",
"TemplateId": "41228.40293",
"TableType": "RateLookup",
"TableName": "AirOceanAccessorials",
"FieldName": "OriginPostalCodeRange",
"DataMetric": "UnknownMissing",
"ParamsValue": "",
"RateMetric": "R=B",
"TimeStamp": "2017-01-20T01:55:32"
}, {
"FbId": "FBLL1000691004981740001",
"LineNum": 1,
"RateScac": "KWEO_Onesource",
"TemplateId": "41228.40293",
"TableType": "RateLookup",
"TableName": "AirOceanAccessorials",
"FieldName": "DestinationPort_Airport",
"DataMetric": "ValidData",
"ParamsValue": "INNSA",
"RateMetric": "R=B",
"TimeStamp": "2017-01-20T01:55:32"
}, {
"FbId": "FBLL1000691004981740001",
"LineNum": 1,
"RateScac": "KWEO_Onesource",
"TemplateId": "41228.40293",
"TableType": "RateLookup",
"TableName": "AirOceanAccessorials",
"FieldName": "DestinationCity",
"DataMetric": "ValidData",
"ParamsValue": "NHAVA SHEVA",
"RateMetric": "R=B",
"TimeStamp": "2017-01-20T01:55:32"
}, {
"FbId": "FBLL1000691004981740001",
"LineNum": 1,
"RateScac": "KWEO_Onesource",
"TemplateId": "41228.40293",
"TableType": "RateLookup",
"TableName": "AirOceanAccessorials",
"FieldName": "DestinationState",
"DataMetric": "UnknownMissing",
"ParamsValue": "",
"RateMetric": "R=B",
"TimeStamp": "2017-01-20T01:55:32"
}, {
"FbId": "FBLL1000691004981740001",
"LineNum": 1,
"RateScac": "KWEO_Onesource",
"TemplateId": "41228.40293",
"TableType": "RateLookup",
"TableName": "AirOceanAccessorials",
"FieldName": "DestinationCountry",
"DataMetric": "ValidData",
"ParamsValue": "IN",
"RateMetric": "R=B",
"TimeStamp": "2017-01-20T01:55:32"
}, {
"FbId": "FBLL1000691004981740001",
"LineNum": 1,
"RateScac": "KWEO_Onesource",
"TemplateId": "41228.40293",
"TableType": "RateLookup",
"TableName": "AirOceanAccessorials",
"FieldName": "DestinationZone",
"DataMetric": "UnknownMissing",
"ParamsValue": "",
"RateMetric": "R=B",
"TimeStamp": "2017-01-20T01:55:32"
}, {
"FbId": "FBLL1000691004981740001",
"LineNum": 1,
"RateScac": "KWEO_Onesource",
"TemplateId": "41228.40293",
"TableType": "RateLookup",
"TableName": "AirOceanAccessorials",
"FieldName": "DestinationRegion",
"DataMetric": "UnknownMissing",
"ParamsValue": "",
"RateMetric": "R=B",
"TimeStamp": "2017-01-20T01:55:32"
}, {
"FbId": "FBLL1000691004981740001",
"LineNum": 1,
"RateScac": "KWEO_Onesource",
"TemplateId": "41228.40293",
"TableType": "RateLookup",
"TableName": "AirOceanAccessorials",
"FieldName": "DestinationPostalCodeRange",
"DataMetric": "UnknownMissing",
"ParamsValue": "",
"RateMetric": "R=B",
"TimeStamp": "2017-01-20T01:55:32"
}, {
"FbId": "FBLL1000691004981740001",
"LineNum": 1,
"RateScac": "KWEO_Onesource",
"TemplateId": "41228.40293",
"TableType": "RateLookup",
"TableName": "AirOceanAccessorials",
"FieldName": "ServiceLevel",
"DataMetric": "Undefined",
"ParamsValue": "FCL",
"RateMetric": "R=B",
"TimeStamp": "2017-01-20T01:55:32"
}, {
"FbId": "FBLL1000691004981740001",
"LineNum": 1,
"RateScac": "KWEO_Onesource",
"TemplateId": "41228.40293",
"TableType": "RateLookup",
"TableName": "AirOceanAccessorials",
"FieldName": "ServiceScope",
"DataMetric": "Undefined",
"ParamsValue": "FCL",
"RateMetric": "R=B",
"TimeStamp": "2017-01-20T01:55:32"
}, {
"FbId": "FBLL1000691004981740001",
"LineNum": 1,
"RateScac": "KWEO_Onesource",
"TemplateId": "41228.40293",
"TableType": "RateLookup",
"TableName": "AirOceanAccessorials",
"FieldName": "EquipmentType",
"DataMetric": "ValidData",
"ParamsValue": "20ST",
"RateMetric": "R=B",
"TimeStamp": "2017-01-20T01:55:32"
}, {
"FbId": "FBLL1000691004981740001",
"LineNum": 1,
"RateScac": "KWEO_Onesource",
"TemplateId": "41228.40293",
"TableType": "RateLookup",
"TableName": "AirOceanAccessorials",
"FieldName": "FlowIndentifier",
"DataMetric": "UnknownMissing",
"ParamsValue": "",
"RateMetric": "R=B",
"TimeStamp": "2017-01-20T01:55:32"
}, {
"FbId": "FBLL1000691004981740001",
"LineNum": 1,
"RateScac": "KWEO_Onesource",
"TemplateId": "41228.40293",
"TableType": "RateLookup",
"TableName": "AirOceanAccessorials",
"FieldName": "WeightRange",
"DataMetric": "Undefined",
"ParamsValue": "9500",
"RateMetric": "R=B",
"TimeStamp": "2017-01-20T01:55:32"
}, {
"FbId": "FBLL1000691004981740001",
"LineNum": 1,
"RateScac": "KWEO_Onesource",
"TemplateId": "41228.40293",
"TableType": "RateLookup",
"TableName": "AirOceanAccessorials",
"FieldName": "MileageBandRange",
"DataMetric": "UnknownMissing",
"ParamsValue": "0",
"RateMetric": "R=B",
"TimeStamp": "2017-01-20T01:55:32"
}, {
"FbId": "FBLL1000691004981740001",
"LineNum": 1,
"RateScac": "KWEO_Onesource",
"TemplateId": "41228.40293",
"TableType": "RateLookup",
"TableName": "AirOceanAccessorials",
"FieldName": "QuantityRange",
"DataMetric": "Undefined",
"ParamsValue": "1",
"RateMetric": "R=B",
"TimeStamp": "2017-01-20T01:55:32"
}],
"RateCalculation": [{
"FbId": "FBLL1000691004981740001",
"LineNum": 1,
"RateScac": "KWEO_Onesource",
"TemplateId": "41228.40293",
"TableType": "RateCalculation",
"TableName": "AirOceanAccessorials",
"FieldName": "Rate",
"DataMetric": "NotImplemented",
"ParamsValue": "410",
"RateMetric": "R=B",
"TimeStamp": "2017-01-20T01:55:32"
}, {
"FbId": "FBLL1000691004981740001",
"LineNum": 1,
"RateScac": "KWEO_Onesource",
"TemplateId": "41228.40293",
"TableType": "RateCalculation",
"TableName": "AirOceanAccessorials",
"FieldName": "RateType",
"DataMetric": "NotImplemented",
"ParamsValue": "Type not handled in JsonBuilder - RateType",
"RateMetric": "R=B",
"TimeStamp": "2017-01-20T01:55:32"
}, {
"FbId": "FBLL1000691004981740001",
"LineNum": 1,
"RateScac": "KWEO_Onesource",
"TemplateId": "41228.40293",
"TableType": "RateCalculation",
"TableName": "AirOceanAccessorials",
"FieldName": "RateBasisType",
"DataMetric": "NotImplemented",
"ParamsValue": "Container",
"RateMetric": "R=B",
"TimeStamp": "2017-01-20T01:55:32"
}, {
"FbId": "FBLL1000691004981740001",
"LineNum": 1,
"RateScac": "KWEO_Onesource",
"TemplateId": "41228.40293",
"TableType": "RateCalculation",
"TableName": "AirOceanAccessorials",
"FieldName": "RateBasisQuantity",
"DataMetric": "NotImplemented",
"ParamsValue": "1",
"RateMetric": "R=B",
"TimeStamp": "2017-01-20T01:55:32"
}, {
"FbId": "FBLL1000691004981740001",
"LineNum": 1,
"RateScac": "KWEO_Onesource",
"TemplateId": "41228.40293",
"TableType": "RateCalculation",
"TableName": "AirOceanAccessorials",
"FieldName": "RateBasisScalar",
"DataMetric": "NotImplemented",
"ParamsValue": "1",
"RateMetric": "R=B",
"TimeStamp": "2017-01-20T01:55:32"
}, {
"FbId": "FBLL1000691004981740001",
"LineNum": 1,
"RateScac": "KWEO_Onesource",
"TemplateId": "41228.40293",
"TableType": "RateCalculation",
"TableName": "AirOceanAccessorials",
"FieldName": "Basis",
"DataMetric": "NotImplemented",
"ParamsValue": "1",
"RateMetric": "R=B",
"TimeStamp": "2017-01-20T01:55:32"
}, {
"FbId": "FBLL1000691004981740001",
"LineNum": 1,
"RateScac": "KWEO_Onesource",
"TemplateId": "41228.40293",
"TableType": "RateCalculation",
"TableName": "AirOceanAccessorials",
"FieldName": "BilledCurrency",
"DataMetric": "NotImplemented",
"ParamsValue": "USD",
"RateMetric": "R=B",
"TimeStamp": "2017-01-20T01:55:32"
}, {
"FbId": "FBLL1000691004981740001",
"LineNum": 1,
"RateScac": "KWEO_Onesource",
"TemplateId": "41228.40293",
"TableType": "RateCalculation",
"TableName": "AirOceanAccessorials",
"FieldName": "RateCurrency",
"DataMetric": "NotImplemented",
"ParamsValue": "USD",
"RateMetric": "R=B",
"TimeStamp": "2017-01-20T01:55:32"
}, {
"FbId": "FBLL1000691004981740001",
"LineNum": 1,
"RateScac": "KWEO_Onesource",
"TemplateId": "41228.40293",
"TableType": "RateCalculation",
"TableName": "AirOceanAccessorials",
"FieldName": "ExchangeRate",
"DataMetric": "NotImplemented",
"ParamsValue": "1",
"RateMetric": "R=B",
"TimeStamp": "2017-01-20T01:55:32"
}]
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment