Skip to content

Instantly share code, notes, and snippets.

@johntbush

johntbush/gist:2c9817717f20a74a180480d5bb349820

Last active August 7, 2017 19:35
Show Gist options
  • Save johntbush/2c9817717f20a74a180480d5bb349820 to your computer and use it in GitHub Desktop.
Save johntbush/2c9817717f20a74a180480d5bb349820 to your computer and use it in GitHub Desktop.
Download ZIP
rating metrics from source
Raw
gistfile1.txt
{
"type" : "source",
"data" :{
"VendLabl": "TNT",
"FbId": "FBLL1000681002182280595",
"FbNId": 3.2013620087288801E18,
"BilledAmt": 2.52,
"BilledCurrency": "EUR",
"RatedAmt": 2.52,
"RatedCurrency": "EUR",
"ApprovedAmt": 2.52,
"ApprovedCurrency": "EUR",
"RequiresTraxReview": false,
"RequiresCustomerReview": false,
"HoldForVerification": false,
"BillConditionList": [],
"LineItemList": [{
"LineItemNum": 0,
"Category": 0,
"ChargeCode": "400",
"ChargeDesc": null,
"BilledAmt": 2.35,
"BilledCurrency": "EUR",
"RatedAmt": 2.35,
"RatedCurrency": "EUR",
"ApprovedAmt": 2.35,
"ApprovedCurrency": "EUR",
"PrevailingCondition": "RateExistsRatedEqualsBilled",
"PrevailingAuditPolicy": "ApproveBilledAmount",
"PrevailingReviewPolicy": "ReviewByReport",
"RequiresTraxReview": false,
"RequiresCustomerReview": false,
"HoldForVerification": false,
"LineConditionList": [{
"Condition": "RateExistsRatedEqualsBilled",
"AuditPolicy": "ApproveBilledAmount",
"ReviewPolicy": "ReviewByReport",
"RequiresTraxReview": false,
"RequiresCustomerReview": false,
"HoldForVerification": false
}],
"RateScac": "TNT_CombinedIndigoExpedite",
"TemplateId": "42524.14365",
"ICSNum": "682513",
"RateTableName": "AdditionalRates",
"RateSetName": "TNT_CombinedIndigoExpediteWorkbook",
"RateResult": "R=B",
"RateSet": [{
"FieldName": "Customer",
"DataMetric": "NotImplemented",
"ParamsValue": "*"
}, {
"FieldName": "Entity",
"DataMetric": "NotImplemented",
"ParamsValue": "100-0681"
}, {
"FieldName": "SCAC",
"DataMetric": "NotImplemented",
"ParamsValue": "TNT_CombinedIndigoExpedite"
}, {
"FieldName": "ModeType",
"DataMetric": "NotImplemented",
"ParamsValue": "*"
}, {
"FieldName": "AccountNumber",
"DataMetric": "NotImplemented",
"ParamsValue": "*"
}, {
"FieldName": "BusinessUnit",
"DataMetric": "NotImplemented",
"ParamsValue": "*"
}, {
"FieldName": "ServiceNationality",
"DataMetric": "NotImplemented",
"ParamsValue": "*"
}, {
"FieldName": "ServiceDirection",
"DataMetric": "NotImplemented",
"ParamsValue": "*"
}, {
"FieldName": "ChargeCategory",
"DataMetric": "NotImplemented",
"ParamsValue": "*"
}, {
"FieldName": "Date",
"DataMetric": "NotImplemented",
"ParamsValue": "6/1/2017 12:00:00 AM"
}],
"RateTable": [{
"FieldName": "ChargeCategory",
"DataMetric": "NotImplemented",
"ParamsValue": "Freight"
}, {
"FieldName": "ChargeCode",
"DataMetric": "NotImplemented",
"ParamsValue": ""
}, {
"FieldName": "ServiceLevel",
"DataMetric": "NotImplemented",
"ParamsValue": ""
}, {
"FieldName": "FlowIdentifier",
"DataMetric": "NotImplemented",
"ParamsValue": "International"
}],
"RateLookup": [{
"FieldName": "EffectiveDate",
"DataMetric": "ValidData",
"ParamsValue": "6/1/2017 12:00:00 AM"
}, {
"FieldName": "ServiceLevel",
"DataMetric": "ValidData",
"ParamsValue": "PC"
}, {
"FieldName": "ServiceDirection",
"DataMetric": "Undefined",
"ParamsValue": "Both Inbound %26 Outbound"
}, {
"FieldName": "OriginCountryCode",
"DataMetric": "ValidData",
"ParamsValue": "DE"
}, {
"FieldName": "OriginPostalCode",
"DataMetric": "Undefined",
"ParamsValue": "47059"
}, {
"FieldName": "OriginZone",
"DataMetric": "UnknownMissing",
"ParamsValue": null
}, {
"FieldName": "DestinationCountryCode",
"DataMetric": "ValidData",
"ParamsValue": "FR"
}, {
"FieldName": "DestinationPostalCode",
"DataMetric": "Undefined",
"ParamsValue": "67810"
}, {
"FieldName": "DestZone",
"DataMetric": "UnknownMissing",
"ParamsValue": null
}, {
"FieldName": "WeightRange",
"DataMetric": "Undefined",
"ParamsValue": "0.116999998688698"
}, {
"FieldName": "PalletCount",
"DataMetric": "ValidData",
"ParamsValue": "0"
}, {
"FieldName": "Zone",
"DataMetric": "ValidData",
"ParamsValue": "1"
}, {
"FieldName": "AccountNumber",
"DataMetric": "ValidData",
"ParamsValue": "070588768"
}, {
"FieldName": "PackageType",
"DataMetric": "UnknownMissing",
"ParamsValue": null
}, {
"FieldName": "ServiceType",
"DataMetric": "ValidData",
"ParamsValue": "Instant Ink Standard"
}],
"RateCalculation": [{
"FieldName": "Rate",
"DataMetric": "NotImplemented",
"ParamsValue": "1.608"
}, {
"FieldName": "RateType",
"DataMetric": "NotImplemented",
"ParamsValue": "Per"
}, {
"FieldName": "RateBasisType",
"DataMetric": "NotImplemented",
"ParamsValue": "Piece"
}, {
"FieldName": "RateBasisQuantity",
"DataMetric": "NotImplemented",
"ParamsValue": "1"
}, {
"FieldName": "RateBasisRoundingType",
"DataMetric": "NotImplemented",
"ParamsValue": "None"
}, {
"FieldName": "RateBasisScalar",
"DataMetric": "NotImplemented",
"ParamsValue": "1"
}, {
"FieldName": "Basis",
"DataMetric": "NotImplemented",
"ParamsValue": "1"
}, {
"FieldName": "BilledCurrency",
"DataMetric": "NotImplemented",
"ParamsValue": "EUR"
}, {
"FieldName": "RateCurrency",
"DataMetric": "NotImplemented",
"ParamsValue": "EUR"
}, {
"FieldName": "ExchangeRate",
"DataMetric": "NotImplemented",
"ParamsValue": "1"
}],
"RateDetails": {
"RatingCategory ": "RatedEqualsBilledUnvalidated",
"RatingDetails": "Rated at 6.349 EUR Per 0.116999998688698 FinancialWeight plus Rated at 1.608 EUR Per 1 Piece using InternationalRates in ICS 682513 for TNT_CombinedIndigoExpedite for freight and AdditionalRates in ICS 682513 for TNT_CombinedIndigoExpedite for freight for this shipment EffectiveDate (6/1/2017 12:00:00 AM), ServiceLevel (PC), ServiceDirection (Both Inbound %26 Outbound), OriginCountryCode (DE), OriginPostalCode (47059), DestinationCountryCode (FR), DestinationPostalCode (67810), WeightRange (0.116999998688698), PalletCount (0), Zone (1), AccountNumber (070588768), ServiceType (Instant Ink Standard). This is rated equals billed at 2.35 EUR ..These are unknown missing OriginZone, DestZone, PackageType.These are undefined ServiceDirection (Both Inbound %26 Outbound), OriginPostalCode (47059), DestinationPostalCode (67810), WeightRange (0.116999998688698).",
"RatingSummary": "Rated at 6.349 EUR Per 0.116999998688698 FinancialWeight plus Rated at 1.608 EUR Per 1 Piece using InternationalRates in ICS 682513 for TNT_CombinedIndigoExpedite for freight and AdditionalRates in ICS 682513 for TNT_CombinedIndigoExpedite for freight. This is rated equals billed at 2.35 EUR .."
}
}, {
"LineItemNum": 2,
"Category": 1,
"ChargeCode": "736",
"ChargeDesc": "Outbound",
"BilledAmt": 0.17,
"BilledCurrency": "EUR",
"RatedAmt": 0.17,
"RatedCurrency": "EUR",
"ApprovedAmt": 0.17,
"ApprovedCurrency": "EUR",
"PrevailingCondition": "RateExistsRatedEqualsBilled",
"PrevailingAuditPolicy": "ApproveBilledAmount",
"PrevailingReviewPolicy": "ReviewByReport",
"RequiresTraxReview": false,
"RequiresCustomerReview": false,
"HoldForVerification": false,
"LineConditionList": [{
"Condition": "RateExistsRatedEqualsBilled",
"AuditPolicy": "ApproveBilledAmount",
"ReviewPolicy": "ReviewByReport",
"RequiresTraxReview": false,
"RequiresCustomerReview": false,
"HoldForVerification": false
}],
"RateScac": "TNT_CombinedIndigoExpedite",
"TemplateId": "42524.14365",
"ICSNum": "682513",
"RateTableName": "AccessorialsAir",
"RateSetName": "TNT_CombinedIndigoExpediteWorkbook",
"RateResult": "R=B",
"RateSet": [{
"FieldName": "Customer",
"DataMetric": "NotImplemented",
"ParamsValue": "*"
}, {
"FieldName": "Entity",
"DataMetric": "NotImplemented",
"ParamsValue": "100-0681"
}, {
"FieldName": "SCAC",
"DataMetric": "NotImplemented",
"ParamsValue": "TNT_CombinedIndigoExpedite"
}, {
"FieldName": "ModeType",
"DataMetric": "NotImplemented",
"ParamsValue": "*"
}, {
"FieldName": "AccountNumber",
"DataMetric": "NotImplemented",
"ParamsValue": "*"
}, {
"FieldName": "BusinessUnit",
"DataMetric": "NotImplemented",
"ParamsValue": "*"
}, {
"FieldName": "ServiceNationality",
"DataMetric": "NotImplemented",
"ParamsValue": "*"
}, {
"FieldName": "ServiceDirection",
"DataMetric": "NotImplemented",
"ParamsValue": "*"
}, {
"FieldName": "ChargeCategory",
"DataMetric": "NotImplemented",
"ParamsValue": "*"
}, {
"FieldName": "Date",
"DataMetric": "NotImplemented",
"ParamsValue": "6/1/2017 12:00:00 AM"
}],
"RateTable": [{
"FieldName": "ChargeCategory",
"DataMetric": "NotImplemented",
"ParamsValue": "Accessorial"
}, {
"FieldName": "ChargeCode",
"DataMetric": "NotImplemented",
"ParamsValue": "736"
}, {
"FieldName": "ServiceLevel",
"DataMetric": "NotImplemented",
"ParamsValue": ""
}, {
"FieldName": "FlowIdentifier",
"DataMetric": "NotImplemented",
"ParamsValue": "Air"
}],
"RateLookup": [{
"FieldName": "EffectiveDate",
"DataMetric": "ValidData",
"ParamsValue": "6/1/2017 12:00:00 AM"
}, {
"FieldName": "ChargeCode",
"DataMetric": "ValidData",
"ParamsValue": "736"
}, {
"FieldName": "ServiceLevel",
"DataMetric": "ValidData",
"ParamsValue": "PC"
}, {
"FieldName": "Nationality",
"DataMetric": "ValidData",
"ParamsValue": "DE"
}, {
"FieldName": "ServiceType",
"DataMetric": "ValidData",
"ParamsValue": "Instant Ink Standard"
}, {
"FieldName": "ServiceClass",
"DataMetric": "UnknownMissing",
"ParamsValue": null
}, {
"FieldName": "AccountNumber",
"DataMetric": "ValidData",
"ParamsValue": "070588768"
}],
"RateCalculation": [{
"FieldName": "Rate",
"DataMetric": "NotImplemented",
"ParamsValue": "0.171"
}, {
"FieldName": "RateType",
"DataMetric": "NotImplemented",
"ParamsValue": "Per"
}, {
"FieldName": "RateBasisType",
"DataMetric": "NotImplemented",
"ParamsValue": "UnitQuantity"
}, {
"FieldName": "RateBasisQuantity",
"DataMetric": "NotImplemented",
"ParamsValue": "1"
}, {
"FieldName": "Basis",
"DataMetric": "NotImplemented",
"ParamsValue": "1"
}, {
"FieldName": "BilledCurrency",
"DataMetric": "NotImplemented",
"ParamsValue": "EUR"
}, {
"FieldName": "RateCurrency",
"DataMetric": "NotImplemented",
"ParamsValue": "EUR"
}, {
"FieldName": "ExchangeRate",
"DataMetric": "NotImplemented",
"ParamsValue": "1"
}],
"RateDetails": {
"RatingCategory ": "RatedEqualsBilledUnvalidated",
"RatingDetails": "Rated at 0.171 EUR Per 1 UnitQuantity using AccessorialsAir in ICS 682513 for TNT_CombinedIndigoExpedite for accessorial for this shipment EffectiveDate (6/1/2017 12:00:00 AM), ChargeCode (736), ServiceLevel (PC), Nationality (DE), ServiceType (Instant Ink Standard), AccountNumber (070588768). This is rated equals billed at 0.17 EUR ..This is unknown missing ServiceClass.",
"RatingSummary": "Rated at 0.171 EUR Per 1 UnitQuantity using AccessorialsAir in ICS 682513 for TNT_CombinedIndigoExpedite for accessorial. This is rated equals billed at 0.17 EUR .."
}
}],
"ExecutionTime": 1585.9375,
"LastUpdated": "2017-06-16T07:46:41.274-07:00",
"Environment": {
"envId": "af44d7ff-c069-482b-aee8-82f0a562ca99",
"db": {
"sqlDns": "HPiProdSQL.traxtech.com",
"databaseName": "HPiProd"
},
"ownerKey": "100-0681",
"generation": "MultiClient",
"wkGroupId": "cd5bfa9f-c7f8-4009-b5c5-b4c9db3783d8",
"name": "HPi EMEA Prod",
"orgName": "HP Inc. EMEA",
"orgId": "7955a7e5-6747-4769-8bb1-6d7ec965d8b9",
"purpose": "Production",
"displayName": "HPi EMEA"
}
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment