Skip to content

Instantly share code, notes, and snippets.

@johntbush
Created July 13, 2016 20:00
Show Gist options
  • Select an option

  • Save johntbush/0f2753effe91f42a5343f19def95908c to your computer and use it in GitHub Desktop.

Select an option

Save johntbush/0f2753effe91f42a5343f19def95908c to your computer and use it in GitHub Desktop.
sample_fb
{
"Invrootid" : "INVC0000416022038880002",
"FbCreatDtm" : "2016-07-10T00:00:00.000",
"VendFbType" : "Manual Bill",
"FbAdjmCnt" : 0,
"FbAppDscntAmt" : 0,
"FbAppFrghtAmt" : 0,
"FbAccAmt" : 379.58,
"FbDscntAmt" : -1017.69,
"FbAppAccAmt" : 526.29,
"FbClass" : "Waybill",
"VendSrvcName" : "ACCELERATED",
"FbVoidFlag" : false,
"LmPkupActualDtm" : "2016-06-24T12:00:00.000",
"AlOrig1" : "TEXAS INSTRUMENTS INC.",
"VendName" : "YRC",
"ImgPageCnt" : 3,
"AlCntryCodeOrig" : "US",
"AlStateProvOrig" : "TX",
"SrvcReqCode" : "ACCELERATED",
"BatId" : "BACH0000416022038880000",
"FbCurrencyQual" : "USD",
"InvKey" : "4991436014",
"AlPostCodeOrig" : "76177",
"AlCityOrig" : "FORT WORTH",
"AlCntryCodeDest" : "US",
"BatKey" : "02203888",
"FbPcsCnt" : 1,
"FbAppAmt" : 526.29,
"FbLnCnt" : 8,
"FbStat" : "Open",
"T003" : "LTL",
"AlDest3" : "1717 E 28TH ST.",
"FbTaxAmt" : 0,
"OwnerKey" : "000-0416",
"FbFrghtAmt" : 1164.4,
"FbFnclWt" : 540.0,
"FbDueDtm" : "2016-08-09T00:00:00.000",
"FbAppTaxPcnt" : 0.0,
"CaInfo2Raw" : ";",
"InvId" : "INVC0000416022038880002",
"CurrEnv" : "Data",
"FbType" : "Original",
"Fbnid" : "3000832088155280002",
"FbKey" : "00333170040417122",
"InterStateProvFlag" : false,
"Mode" : "Surface",
"ImgPageNum" : 5,
"FbDuFlag" : true,
"FbAppTaxAmt" : 0,
"T020" : "MappingFlow: Legacy",
"AlOrig3" : "13601 INDEPENDENCE PARKWAY",
"FbAmt" : 526.29,
"VendLabl" : "RDWY",
"Exdesc" : "Data Exception",
"FbActualWt" : 540.0,
"ForceFaExFlag" : false,
"T015" : "Rated: OneSourceLineItemV1",
"AlPostCodeDest" : "90755",
"DeniedFlag" : false,
"CaInfo1Raw" : "VX:340492670;PRT:SKD E & PS CALCULATORS,ADDING MACHINES OR CALCULATORS;P9:5,5;REF:PO 7394;BOL:00333170040417122,00333170040417122;",
"AlDest1" : "SCHOOL SAVERS",
"IntraStateProvFlag" : false,
"FbPkgType" : "PIECES",
"State" : "Data Exception",
"EntTypeBlng" : "Third Party",
"FbPaymtCnt" : 0,
"ModeType" : "LTL",
"FbTerms" : "30",
"AlStateProvDest" : "CA",
"AlCityDest" : "SIGNAL HILL",
"FbId" : "FBLL0000416022038880002",
"FbDupManualRslt" : false,
"InternationalFlag" : false,
"FbAppCurrencyQual" : "USD",
"FbPaymtTermsCode" : "PP",
"ExCode" : "CA",
"exceptions" : [ {
"name" : "Data Exception",
"description" : " Norm ChargeCode: LnChrgCode CBLS is invalid; Norm Category: Category ACCESSORIAL is invalid for LnChrgCode CBLS(CORRECTED BILL OF LADING);",
"code" : "CA",
"record_asof" : "2016-07-10T22:32:48.000",
"record_posted" : "2016-07-10T22:32:51.000",
"type" : "Data"
} ],
"ALine" : "ST*DEEDI*0000002****\r\nB3**4991436014*****52629*ORIGINAL INVOICE***RDWY***\r\nB3A**1\r\nC3*USD\r\nITD***************\r\nN1*BT*TRAX TECHNOLOGIES INC**RDWY01913\r\nN2*TEXAS INSTRUMENTS\r\nN3*PO BOX 6514\r\nN4*ENGLEWOOD*CO*80155-6514*\r\nN1*RI*YRC FREIGHT**RDWY00233\r\nN3*P.O. BOX 730375\r\nN4*DALLAS*TX*75373-0375*\r\nN9*InvId*INVC0010416MXX449470002\r\nN9*VX*340492670\r\nN9*P9*5*3\r\nLX*000001\r\nN1*CN*SCHOOL SAVERS\r\nN3*1717 E 28TH ST.\r\nN4*SIGNAL HILL*CA*90755*\r\nN1*CNINV*SCHOOL SAVERS\r\nN3*1717 E 28TH ST\r\nN4*SIGNAL HILL*CA*90755*\r\nN1*SH*TEXAS INSTRUMENTS INC.\r\nN3*13601 INDEPENDENCE PARKWAY\r\nN4*FORT WORTH**76177*\r\nN1*SHINV*TEXAS INSTRUMENTS\r\nN3*13601 INDEPENDENCE PKWY STE 150\r\nN4*FT WORTH*TX*76177*\r\nN9*FbId*FBLL0010416MXX449470002\r\nN9*P9*5*3\r\nN9*REF*PO 7394\r\nN9*BOL*00333170040417122\r\nN9*BOL*00333170040417122\r\nN9*CLASS*92.5\r\nP1**20160624*011*1200\r\nPOD***\r\nR1*****\r\nR3************\r\nRMT*FR**526.29*\r\nCUR*PF*USD*******\r\nNTE*\r\nL5*0**100*N\r\nL0*0*******1*PIECES**\r\nL5*1*SKD E & PS CALCULATORS*****ZZ\r\nL0*1****G***1***\r\nL5*2*ADDING MACHINES OR CALCULATORS*****ZZ\r\nL0*2***430.7*G***1***\r\nL10*540*B*\r\nL10*540*G*\r\nSL1*ACCELERATED*****PREPAID\r\nL1*1*21563*PER*116440****E100****FREIGHT*540***100*540**********\r\nC3*USD****\r\nL1*2*87.40*PERCENT*-101769****DISC****DISCOUNT***************\r\nC3*USD****\r\nL1*3**PER*12200****LTDD****LIMITED ACCESS DELIVERY***************\r\nC3*USD****\r\nL1*4**PER*15900****LFTD****LIFTGATE SERVICE DESTINATION***************\r\nC3*USD****\r\nL1*5**PER*3000****CBLS****CORRECTED BILL OF LADING***************\r\nC3*USD****\r\nL1*6**PER*3000****ACEL****ACCELERATED SERVICE***************\r\nC3*USD****\r\nL1*7**PER*200****PRNT****PAPER INVOICE FEE***************\r\nC3*USD****\r\nL1*8*20.70*PERCENT*3658****FSC****GENERAL SURCHARGE (FUEL/FRT)***************\r\nC3*USD****\r\nL3*****52629\r\nSE**0000002",
"Environment" : {
"EnvId" : "851d3b68-1267-41e7-be7a-36033dba8df9",
"DatabaseName" : "TexasInstrumentsAMRProd",
"SqlDns" : "TexasInstrumentsAMRProdSQL.traxtech.com",
"OwnerKey" : "000-0416",
"Name" : "Texas Instruments AMR Prod",
"WkGrpId" : "22a11c23-43c3-4f01-a59a-70f3d3d2e664",
"OrgId" : "dc5f21d8-6060-4911-a8a5-840d536962cd",
"OrgName" : "Texas Instruments",
"Purpose" : "Production",
"RootPath" : "\\\\Filex.com\\Customers\\Texas Instruments\\AMR\\Prod",
"Generation" : "Chameleon",
"ArchivePath" : null,
"Description" : null,
"MSharpRepositoryPath" : null,
"DisplayName" : "Texas Instruments AMR"
},
"Organization" : {
"RootParentName" : null,
"ParentName" : null,
"Name" : "Texas Instruments",
"Description" : "Texas Instruments",
"ParentId" : null,
"LogoRef" : "https://traxclientsite.s3.amazonaws.com/production/images/org_logos/dc5f21d8-6060-4911-a8a5-840d536962cd/1417561354-TI_logo.png.jpg",
"OrgId" : "dc5f21d8-6060-4911-a8a5-840d536962cd",
"RootParentId" : null,
"ReportServiceId" : null,
"ZabbixServiceId" : null,
"LspType" : null,
"IsShipper" : true,
"IsLSP" : false,
"HasReports" : null
},
"suid" : {
"buyer" : "91186731-816e-50a8-8082-9b82ea9d5a16",
"seller" : "bbb1e9c6-a49f-5ec9-9e3b-851840eb5c6d"
},
"InvNorm" : {
"LspOrgConfidence" : 3,
"RecordDtmUTC" : "2016-07-11T11:37:00.000",
"ParentLspOrgName" : "YRC Freight",
"LspParentOrgId" : "7803BD25-F99E-4D5E-81FD-102582935AA4",
"LspOrgDtmUTC" : "2016-07-11T11:37:00.000",
"LspRootOrgId" : "2C3C2411-FBDE-492E-8FDC-6F1729502B36",
"LspRootOrgName" : "YRC Logistics",
"LspOrgId" : "3B7A502E-58EA-4470-B2A0-8EB9846C1ACB",
"LspRootOrgIdStr" : "2C3C2411-FBDE-492E-8FDC-6F1729502B36",
"LspOrgAuthority" : "OwnerKeySCAC",
"LspParentOrgIdStr" : "7803BD25-F99E-4D5E-81FD-102582935AA4",
"InvNId" : "2000832088155280002",
"LspOrgTrust" : 1,
"INV_ID" : "INVC0000416022038880002",
"LspOrgName" : "Roadway Express",
"LspOrgIdStr" : "3B7A502E-58EA-4470-B2A0-8EB9846C1ACB"
},
"InvBat" : {
"BatPdAmt" : 0,
"BatDueDtm" : "2016-08-09T00:00:00.000",
"BatAppAmt" : 0,
"VendBatAmt" : 704.33,
"BatInvCnt" : 2,
"BatCurrencyQual" : "USD",
"BatId" : "BACH0000416022038880000",
"BatType" : "Manual",
"RuleProcessCycCnt" : 1,
"BatAdjmAmt" : 0,
"BatKey" : "02203888",
"VendBatKey" : "MXX44947.000",
"OwnerKey" : "000-0416",
"BatAmt" : 704.33,
"BatSuspendCnt" : 0,
"BatStat" : "Exception",
"BatAdjmCnt" : 0,
"BatFbCnt" : 2,
"BatPaymtCnt" : 0,
"BatSuspendAmt" : 0,
"VendLabl" : "RDWY",
"BatVoidFlag" : false,
"VendBatDtm" : "2016-07-10T22:18:25.000",
"VendFeed" : "MXX44947",
"BatCreatDtm" : "2016-07-10T22:19:00.000"
},
"FbNorm" : {
"FbCreatDtm" : "2016-07-10T00:00:00.000",
"SrvcReqCodesource" : "Raw",
"VendSrvcName" : "ACCELERATED",
"LmPkupActualDtm" : "2016-06-24T12:00:00.000",
"FbWtQualsource" : "Raw",
"Modesource" : "Raw",
"LmPkupActualDtmsource" : "Raw",
"FbFnclWtsource" : "Raw",
"LmEtaDtmsource" : "Raw",
"SrvcReqCode" : "ACCELERATED",
"FbFnclWt" : 540.0,
"FbCreatDtmsource" : "Raw",
"CustModesource" : "Raw",
"LmAtaDtmsource" : "Raw",
"FbActualWtsource" : "Raw",
"Fbnid" : "3000832088155280002",
"Mode" : "Surface",
"ModeTypesource" : "Raw",
"FbPaymtTermsCodesource" : "Raw",
"VendSrvcNamesource" : "Raw",
"FbActualWt" : 540.0,
"ModeType" : "LTL",
"AcctNumVendBlngsource" : "Raw",
"FbId" : "FBLL0000416022038880002",
"FbPaymtTermsCode" : "PP"
},
"LineItems" : [ {
"RateAmt" : 21563,
"RateType" : "PER",
"LnActualWt" : 540.0,
"VendDesc" : "FREIGHT",
"LnRateAsWt" : 540.0,
"BatKey" : "02203888",
"Cat" : "FREIGHT",
"TxLineItemFlag" : true,
"ChrgDesc" : "Freight",
"PkgType" : "PIECES",
"QtyLabl" : "430.7",
"LnChrgCode" : "400",
"CmdtyClass" : "100",
"ChrgAmt" : 1164.4,
"CurrencyQual" : "USD",
"FbLineItemFlag" : true,
"FbId" : "FBLL0000416022038880002",
"PcsCnt" : 1,
"LineItemNum" : 1
}, {
"RateAmt" : 87.4,
"RateType" : "PERCENT",
"VendDesc" : "DISCOUNT",
"BatKey" : "02203888",
"Cat" : "DISCOUNT",
"TxLineItemFlag" : true,
"ChrgDesc" : "Discount",
"LnChrgCode" : "DSC",
"ChrgAmt" : -1017.69,
"CurrencyQual" : "USD",
"FbLineItemFlag" : true,
"FbId" : "FBLL0000416022038880002",
"LineItemNum" : 2
}, {
"RateType" : "PER",
"VendDesc" : "LIMITED ACCESS DELIVERY",
"BatKey" : "02203888",
"Cat" : "ACCESSORIAL",
"TxLineItemFlag" : true,
"ChrgDesc" : "Special Delivery",
"LnChrgCode" : "685",
"ChrgAmt" : 122,
"CurrencyQual" : "USD",
"FbLineItemFlag" : true,
"FbId" : "FBLL0000416022038880002",
"LineItemNum" : 3
}, {
"RateType" : "PER",
"VendDesc" : "LIFTGATE SERVICE DESTINATION",
"BatKey" : "02203888",
"Cat" : "ACCESSORIAL",
"TxLineItemFlag" : true,
"ChrgDesc" : "Lift Gate (Truck) or Forklift Service at Pickup/Delivery",
"LnChrgCode" : "LFT",
"ChrgAmt" : 159,
"CurrencyQual" : "USD",
"FbLineItemFlag" : true,
"FbId" : "FBLL0000416022038880002",
"LineItemNum" : 4
}, {
"RateType" : "PER",
"VendDesc" : "CORRECTED BILL OF LADING",
"BatKey" : "02203888",
"Cat" : "ACCESSORIAL",
"TxLineItemFlag" : true,
"ChrgDesc" : "CORRECTED BILL OF LADING",
"LnChrgCode" : "CBLS",
"ChrgAmt" : 3E+1,
"CurrencyQual" : "USD",
"FbLineItemFlag" : true,
"FbId" : "FBLL0000416022038880002",
"LineItemNum" : 5
}, {
"RateType" : "PER",
"VendDesc" : "ACCELERATED SERVICE",
"BatKey" : "02203888",
"Cat" : "ACCESSORIAL",
"TxLineItemFlag" : true,
"ChrgDesc" : "Priority Service",
"LnChrgCode" : "580",
"ChrgAmt" : 3E+1,
"CurrencyQual" : "USD",
"FbLineItemFlag" : true,
"FbId" : "FBLL0000416022038880002",
"LineItemNum" : 6
}, {
"RateType" : "PER",
"VendDesc" : "PAPER INVOICE FEE",
"BatKey" : "02203888",
"Cat" : "ACCESSORIAL",
"TxLineItemFlag" : true,
"ChrgDesc" : "Documentation Charge",
"LnChrgCode" : "DOC",
"ChrgAmt" : 2,
"CurrencyQual" : "USD",
"FbLineItemFlag" : true,
"FbId" : "FBLL0000416022038880002",
"LineItemNum" : 7
}, {
"RateAmt" : 20.7,
"RateType" : "PERCENT",
"VendDesc" : "GENERAL SURCHARGE (FUEL/FRT)",
"BatKey" : "02203888",
"Cat" : "ACCESSORIAL",
"TxLineItemFlag" : true,
"ChrgDesc" : "Fuel Surcharges",
"LnChrgCode" : "405",
"ChrgAmt" : 36.58,
"CurrencyQual" : "USD",
"FbLineItemFlag" : true,
"FbId" : "FBLL0000416022038880002",
"LineItemNum" : 8
} ],
"KeyRaws" : [ {
"Unttypeid" : 3,
"Instnum" : 1,
"Localuntnid" : "3000832088155280002",
"Keyval" : "5",
"Keyqual" : "P9"
}, {
"Unttypeid" : 3,
"Instnum" : 2,
"Localuntnid" : "3000832088155280002",
"Keyval" : "PO 7394",
"Keyqual" : "REF"
}, {
"Unttypeid" : 3,
"Instnum" : 3,
"Localuntnid" : "3000832088155280002",
"Keyval" : "00333170040417122",
"Keyqual" : "BOL"
}, {
"Unttypeid" : 3,
"Instnum" : 4,
"Localuntnid" : "3000832088155280002",
"Keyval" : "92.5",
"Keyqual" : "CLASS"
} ],
"ProdDtls" : [ {
"Localuntnid" : "3000832088155280002",
"Unttypeid" : 3,
"Instnum" : 1,
"Proddesc" : "SKD E & PS CALCULATORS"
}, {
"Unttypeid" : 3,
"Instnum" : 2,
"Localuntnid" : "3000832088155280002",
"Proddesc" : "ADDING MACHINES OR CALCULATORS",
"Prodgrosswt" : 430.7
} ],
"KeyIdents" : [ {
"KeyVal" : "00333170040417122",
"KeyQual" : "BOL",
"ValidKeyType" : "Valid",
"KeyOrd" : 1,
"ValidKeyPattern" : "Unknown",
"UntNId" : "3000832088155280002",
"KeyBase" : "",
"KeySource" : "frght_bl.ca_info_1_raw",
"KeyType" : "BOL"
}, {
"KeyVal" : "925",
"KeyQual" : "CLASS",
"ValidKeyType" : "Unknown",
"KeyOrd" : 1,
"ValidKeyPattern" : "Unknown",
"UntNId" : "3000832088155280002",
"KeyBase" : "",
"KeySource" : "a_line.cntxt",
"KeyType" : ""
}, {
"KeyVal" : "FBLL0010416MXX449470002",
"KeyQual" : "FbId",
"ValidKeyType" : "Unknown",
"KeyOrd" : 1,
"ValidKeyPattern" : "Unknown",
"UntNId" : "3000832088155280002",
"KeyBase" : "",
"KeySource" : "a_line.cntxt",
"KeyType" : ""
}, {
"KeyVal" : "00333170040417122",
"KeyQual" : "FbKey",
"ValidKeyType" : "Valid",
"KeyOrd" : 1,
"ValidKeyPattern" : "Unknown",
"UntNId" : "3000832088155280002",
"KeyBase" : "",
"KeySource" : "frght_bl.fb_key",
"KeyType" : "FbKey"
}, {
"KeyVal" : "INVC0010416MXX449470002",
"KeyQual" : "InvId",
"ValidKeyType" : "Unknown",
"KeyOrd" : 1,
"ValidKeyPattern" : "Unknown",
"UntNId" : "3000832088155280002",
"KeyBase" : "",
"KeySource" : "a_line.cntxt",
"KeyType" : ""
}, {
"KeyVal" : "4991436014",
"KeyQual" : "InvKey",
"ValidKeyType" : "Valid",
"KeyOrd" : 1,
"ValidKeyPattern" : "Unknown",
"UntNId" : "3000832088155280002",
"KeyBase" : "",
"KeySource" : "frght_bl.inv_key",
"KeyType" : "InvKey"
}, {
"KeyVal" : "5",
"KeyQual" : "P9",
"ValidKeyType" : "Unknown",
"KeyOrd" : 1,
"ValidKeyPattern" : "Unknown",
"UntNId" : "3000832088155280002",
"KeyBase" : "",
"KeySource" : "frght_bl.ca_info_1_raw",
"KeyType" : ""
}, {
"KeyVal" : "7394",
"KeyQual" : "REF",
"ValidKeyType" : "Unknown",
"KeyOrd" : 1,
"ValidKeyPattern" : "Unknown",
"UntNId" : "3000832088155280002",
"KeyBase" : "",
"KeySource" : "frght_bl.ca_info_1_raw",
"KeyType" : ""
}, {
"KeyVal" : "340492670",
"KeyQual" : "VX",
"ValidKeyType" : "Unknown",
"KeyOrd" : 1,
"ValidKeyPattern" : "Unknown",
"UntNId" : "3000832088155280002",
"KeyBase" : "",
"KeySource" : "frght_bl.ca_info_1_raw",
"KeyType" : ""
} ],
"Vendor" : {
"TaxAppPolicy" : "As Percent of Approved",
"VendName" : "YRC",
"RcrdWksCode" : "5001",
"ActiveStat" : "Active",
"PaymtTerms" : "30 days from receipt of invoice",
"SigRateVarncNegAmt" : 0.25,
"PaymtCurrencyCode" : "USD",
"OwnerKey" : "000-0416",
"Edi997FileGrp" : "EDI_Out",
"ExMaxFbAmt" : 1E+3,
"VendLabl" : "RDWY",
"MultiFbPerInvFlag" : false,
"SigRateVarncPosAmt" : 999999.99,
"RcrdCreatDtm" : "2011-07-13T18:42:30.000",
"N1" : 0.0,
"RcrdUserLogonKey" : "benjie.melgar"
},
"VendLablAcctNumVendBlng" : "RDWY ",
"FbDueWeek" : "2016-32",
"BillTo" : "TRAX TECHNOLOGIES INC ENGLEWOOD ",
"BillToAddress" : "TRAX TECHNOLOGIES INC PO BOX 6514 ENGLEWOOD CO ",
"VendLablBillTo" : "RDWY TRAX TECHNOLOGIES INC ENGLEWOOD ",
"OriginNameCityCountry" : "TEXAS INSTRUMENTS INC. FORT WORTH US",
"DestNameCityCountry" : "SCHOOL SAVERS SIGNAL HILL US",
"Invoice" : {
"Invnid" : "2000832088155280002",
"AlRemit3" : "P.O. BOX 730375",
"VendInvAmt" : 526.29,
"InvVoidFlag" : false,
"AlStateProvBlng" : "CO",
"AlPostCodeBlng" : "80155-6514",
"InvDupManualRslt" : false,
"InvAdjmCnt" : 0,
"InvCreatDtm" : "2016-07-10T00:00:00.000",
"InvPdAmt" : 0,
"InvCurrencyQual" : "USD",
"TaxRegKeyVend" : "340492670",
"ImgPageCnt" : 3,
"AlBlng2" : "TEXAS INSTRUMENTS",
"AlCityRemit" : "DALLAS",
"BatId" : "BACH0000416022038880000",
"InvKey" : "4991436014",
"InvType" : "Manual Bill",
"BatKey" : "02203888",
"VendBatKey" : "MXX44947.000",
"AlBlng1" : "TRAX TECHNOLOGIES INC",
"OwnerKey" : "000-0416",
"InvId" : "INVC0000416022038880002",
"ImgPageNum" : 5,
"AlPostCodeRemit" : "75373-0375",
"InvFbCnt" : 1,
"VendLabl" : "RDWY",
"InvStat" : "Open",
"AlBlng3" : "PO BOX 6514",
"InvAmt" : 526.29,
"InvDueDtm" : "2016-08-09T00:00:00.000",
"InvAppAmt" : 526.29,
"AlCityBlng" : "ENGLEWOOD",
"InvAdjmAmt" : 0,
"AlRemit1" : "YRC FREIGHT",
"InvPaymtCnt" : 0,
"AlStateProvRemit" : "TX",
"LastUpdatedDtm" : "2016-07-13T12:59:03.745-07:00",
"Organization" : {
"RootParentName" : null,
"ParentName" : null,
"Name" : "Texas Instruments",
"Description" : "Texas Instruments",
"ParentId" : null,
"LogoRef" : "https://traxclientsite.s3.amazonaws.com/production/images/org_logos/dc5f21d8-6060-4911-a8a5-840d536962cd/1417561354-TI_logo.png.jpg",
"OrgId" : "dc5f21d8-6060-4911-a8a5-840d536962cd",
"RootParentId" : null,
"ReportServiceId" : null,
"ZabbixServiceId" : null,
"LspType" : null,
"IsShipper" : true,
"IsLSP" : false,
"HasReports" : null
},
"suid" : {
"buyer" : "91186731-816e-50a8-8082-9b82ea9d5a16",
"seller" : "bbb1e9c6-a49f-5ec9-9e3b-851840eb5c6d"
},
"Environment" : {
"EnvId" : "851d3b68-1267-41e7-be7a-36033dba8df9",
"DatabaseName" : "TexasInstrumentsAMRProd",
"SqlDns" : "TexasInstrumentsAMRProdSQL.traxtech.com",
"OwnerKey" : "000-0416",
"Name" : "Texas Instruments AMR Prod",
"WkGrpId" : "22a11c23-43c3-4f01-a59a-70f3d3d2e664",
"OrgId" : "dc5f21d8-6060-4911-a8a5-840d536962cd",
"OrgName" : "Texas Instruments",
"Purpose" : "Production",
"RootPath" : "\\\\Filex.com\\Customers\\Texas Instruments\\AMR\\Prod",
"Generation" : "Chameleon",
"ArchivePath" : null,
"Description" : null,
"MSharpRepositoryPath" : null,
"DisplayName" : "Texas Instruments AMR"
},
"InvNorm" : {
"LspOrgConfidence" : 3,
"RecordDtmUTC" : "2016-07-11T11:37:00.000",
"ParentLspOrgName" : "YRC Freight",
"LspParentOrgId" : "7803BD25-F99E-4D5E-81FD-102582935AA4",
"LspOrgDtmUTC" : "2016-07-11T11:37:00.000",
"LspRootOrgId" : "2C3C2411-FBDE-492E-8FDC-6F1729502B36",
"LspRootOrgName" : "YRC Logistics",
"LspOrgId" : "3B7A502E-58EA-4470-B2A0-8EB9846C1ACB",
"LspRootOrgIdStr" : "2C3C2411-FBDE-492E-8FDC-6F1729502B36",
"LspOrgAuthority" : "OwnerKeySCAC",
"LspParentOrgIdStr" : "7803BD25-F99E-4D5E-81FD-102582935AA4",
"InvNId" : "2000832088155280002",
"LspOrgTrust" : 1,
"INV_ID" : "INVC0000416022038880002",
"LspOrgName" : "Roadway Express",
"LspOrgIdStr" : "3B7A502E-58EA-4470-B2A0-8EB9846C1ACB"
},
"InvoicePlaces" : {
"RemitCity" : "DALLAS",
"BlngCity" : "ENGLEWOOD",
"NormalizedBlngUsed" : 0,
"BlngStateProv" : "CO",
"NormalizedRemitUsed" : 0,
"InvNId" : "2000832088155280002",
"INV_ID" : "INVC0000416022038880002",
"RemitStateProv" : "TX"
},
"KeyRaws" : [ {
"Unttypeid" : 2,
"Instnum" : 1,
"Localuntnid" : "2000832088155280002",
"Keyval" : "ORIGINAL INVOICE",
"Keyqual" : "Vend_Invoice_Type"
}, {
"Unttypeid" : 2,
"Instnum" : 2,
"Localuntnid" : "2000832088155280002",
"Keyval" : "340492670",
"Keyqual" : "VX"
}, {
"Unttypeid" : 2,
"Instnum" : 3,
"Localuntnid" : "2000832088155280002",
"Keyval" : "5",
"Keyqual" : "P9"
} ],
"KeyIdents" : [ {
"KeyVal" : "4991436014",
"KeyQual" : "InvKey",
"ValidKeyType" : "Valid",
"KeyOrd" : 1,
"ValidKeyPattern" : "Unknown",
"UntNId" : "2000832088155280002",
"KeyBase" : "",
"KeySource" : "invoice.inv_key",
"KeyType" : "InvKey"
} ],
"Vendor" : {
"TaxAppPolicy" : "As Percent of Approved",
"VendName" : "YRC",
"RcrdWksCode" : "5001",
"ActiveStat" : "Active",
"PaymtTerms" : "30 days from receipt of invoice",
"SigRateVarncNegAmt" : 0.25,
"PaymtCurrencyCode" : "USD",
"OwnerKey" : "000-0416",
"Edi997FileGrp" : "EDI_Out",
"ExMaxFbAmt" : 1E+3,
"VendLabl" : "RDWY",
"MultiFbPerInvFlag" : false,
"SigRateVarncPosAmt" : 999999.99,
"RcrdCreatDtm" : "2011-07-13T18:42:30.000",
"N1" : 0.0,
"RcrdUserLogonKey" : "benjie.melgar"
},
"AlBlng1Raw" : "TRAX TECHNOLOGIES INC"
},
"LastUpdatedDtm" : "2016-07-13T12:59:43.716-07:00"
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment