{"text_format":"dbase-jsonl-2026-09-30","columns":[{"name":"SHIPMENTID","type":"number","width":8,"decimals":0},{"name":"TRACK_NO","type":"character","width":20},{"name":"SHIPDATE","type":"date","width":8},{"name":"SHIPTIME","type":"number","width":4,"decimals":0},{"name":"CLOSEDATE","type":"date","width":8},{"name":"CLOSETIME","type":"number","width":4,"decimals":0},{"name":"WS_ID","type":"character","width":20},{"name":"SHIPPER_ID","type":"character","width":10},{"name":"SH_ACCTNO","type":"character","width":10},{"name":"SH_NAME","type":"character","width":35},{"name":"SH_ADDR1","type":"character","width":35},{"name":"SH_ADDR2","type":"character","width":35},{"name":"SH_ADDR3","type":"character","width":35},{"name":"SH_POSTAL","type":"character","width":15},{"name":"SH_CITY","type":"character","width":30},{"name":"SH_PROV","type":"character","width":30},{"name":"SH_COUNTRY","type":"character","width":3},{"name":"SH_CONTACT","type":"character","width":35},{"name":"SH_PHONE","type":"character","width":25},{"name":"SH_FAX","type":"character","width":25},{"name":"SH_TAXID","type":"character","width":35},{"name":"ST_ACCTNO","type":"character","width":10},{"name":"ST_NAME","type":"character","width":35},{"name":"ST_ADDR1","type":"character","width":35},{"name":"ST_ADDR2","type":"character","width":35},{"name":"ST_ADDR3","type":"character","width":35},{"name":"ST_POSTAL","type":"character","width":15},{"name":"ST_CITY","type":"character","width":30},{"name":"ST_PROV","type":"character","width":30},{"name":"ST_COUNTRY","type":"character","width":3},{"name":"CTRY_NAME","type":"character","width":25},{"name":"ST_CONTACT","type":"character","width":35},{"name":"ST_PHONE","type":"character","width":25},{"name":"ST_FAX","type":"character","width":25},{"name":"ST_CUSTID","type":"character","width":14},{"name":"ST_TAXID","type":"character","width":35},{"name":"SO_ACCTNO","type":"character","width":10},{"name":"SO_NAME","type":"character","width":35},{"name":"SO_ADDR1","type":"character","width":35},{"name":"SO_ADDR2","type":"character","width":35},{"name":"SO_ADDR3","type":"character","width":35},{"name":"SO_POSTAL","type":"character","width":15},{"name":"SO_CITY","type":"character","width":30},{"name":"SO_PROV","type":"character","width":30},{"name":"SO_COUNTRY","type":"character","width":3},{"name":"SO_CONTACT","type":"character","width":35},{"name":"SO_PHONE","type":"character","width":25},{"name":"SO_FAX","type":"character","width":25},{"name":"SO_CUSTID","type":"character","width":14},{"name":"SO_TAXID","type":"character","width":35},{"name":"BT_ACCTNO","type":"character","width":10},{"name":"BT_NAME","type":"character","width":35},{"name":"BT_ADDR1","type":"character","width":35},{"name":"BT_ADDR2","type":"character","width":35},{"name":"BT_ADDR3","type":"character","width":35},{"name":"BT_POSTAL","type":"character","width":15},{"name":"BT_CITY","type":"character","width":30},{"name":"BT_PROV","type":"character","width":30},{"name":"BT_COUNTRY","type":"character","width":3},{"name":"BT_CONTACT","type":"character","width":35},{"name":"BT_PHONE","type":"character","width":25},{"name":"BT_FAX","type":"character","width":25},{"name":"BT_CUSTID","type":"character","width":14},{"name":"BT_TAXID","type":"character","width":35},{"name":"PKG_TYPE","type":"number","width":1,"decimals":0},{"name":"PKG_COUNT","type":"number","width":5,"decimals":0},{"name":"TOT_WGT","type":"number","width":10,"decimals":2},{"name":"TOT_DIM","type":"number","width":10,"decimals":2},{"name":"BILL_WGT","type":"number","width":10,"decimals":2},{"name":"SRV_LVL","type":"character","width":2},{"name":"ZONE","type":"number","width":3,"decimals":0},{"name":"SERV_ZONE","type":"character","width":3},{"name":"BILL_OPT","type":"character","width":3},{"name":"COMM_ENTS","type":"character","width":50},{"name":"REFERENCE0","type":"character","width":35},{"name":"REFERENCE1","type":"character","width":35},{"name":"REFERENCE2","type":"character","width":35},{"name":"REFERENCE3","type":"character","width":35},{"name":"REFERENCE4","type":"character","width":35},{"name":"REFERENCE5","type":"character","width":35},{"name":"REFERENCE6","type":"character","width":35},{"name":"REFERENCE7","type":"character","width":35},{"name":"REFERENCE8","type":"character","width":35},{"name":"REFERENCE9","type":"character","width":35},{"name":"CHARGE","type":"number","width":8,"decimals":2},{"name":"GST","type":"number","width":8,"decimals":2},{"name":"PST","type":"number","width":8,"decimals":2},{"name":"QST","type":"number","width":8,"decimals":2},{"name":"HST","type":"number","width":8,"decimals":2},{"name":"PUB_CHARGE","type":"number","width":8,"decimals":2},{"name":"PUB_GST","type":"number","width":8,"decimals":2},{"name":"PUB_PST","type":"number","width":8,"decimals":2},{"name":"PUB_QST","type":"number","width":8,"decimals":2},{"name":"PUB_HST","type":"number","width":8,"decimals":2},{"name":"MU_CHARGE","type":"number","width":8,"decimals":2},{"name":"MU_GST","type":"number","width":8,"decimals":2},{"name":"MU_PST","type":"number","width":8,"decimals":2},{"name":"MU_QST","type":"number","width":8,"decimals":2},{"name":"MU_HST","type":"number","width":8,"decimals":2},{"name":"ADD_CHARGE","type":"number","width":8,"decimals":2},{"name":"CONS_ID","type":"number","width":7,"decimals":0},{"name":"CONS_CNT","type":"number","width":5,"decimals":0},{"name":"CONS_CHRG","type":"number","width":8,"decimals":2},{"name":"CONS_GST","type":"number","width":8,"decimals":2},{"name":"CONS_PST","type":"number","width":8,"decimals":2},{"name":"CONS_QST","type":"number","width":8,"decimals":2},{"name":"CONS_HST","type":"number","width":8,"decimals":2},{"name":"CONS_ADDC","type":"number","width":8,"decimals":2},{"name":"MANI_NUM","type":"character","width":12},{"name":"DOCUMENTS","type":"logical","width":1},{"name":"CST_BROKER","type":"character","width":35},{"name":"CUSTOMS_D","type":"character","width":60},{"name":"INVOICE_NO","type":"character","width":35},{"name":"INV_TOTAL","type":"number","width":16,"decimals":2},{"name":"INV_COMM","type":"character","width":60},{"name":"TERMS_SALE","type":"character","width":3},{"name":"CURR_TYPE","type":"character","width":3},{"name":"RELE_DATE","type":"date","width":8},{"name":"TRANS_TYPE","type":"number","width":3,"decimals":0},{"name":"X_COD_AMT","type":"number","width":8,"decimals":2},{"name":"X_COD_TRNO","type":"character","width":20},{"name":"SAT_DELV","type":"logical","width":1},{"name":"ADULT_SIG","type":"logical","width":1},{"name":"P_OVERRIDE","type":"logical","width":1},{"name":"Q_SHIP","type":"logical","width":1},{"name":"ADD_DOC","type":"logical","width":1},{"name":"PALLETID","type":"character","width":1},{"name":"VOID","type":"logical","width":1},{"name":"DECL_VALUE","type":"number","width":9,"decimals":2},{"name":"DUTIABLE","type":"logical","width":1},{"name":"ERR_STAT","type":"character","width":1},{"name":"ERR_CODE","type":"character","width":120},{"name":"VRBL_CONF","type":"logical","width":1},{"name":"EXT_A_SCHG","type":"logical","width":1},{"name":"EMAILASN","type":"character","width":100},{"name":"EMAILTEXT","type":"character","width":120},{"name":"EMAILASN2","type":"character","width":100},{"name":"EMAILTEXT2","type":"character","width":120},{"name":"CSE","type":"logical","width":1},{"name":"CC","type":"logical","width":1},{"name":"US_DIRECT","type":"logical","width":1},{"name":"ARS","type":"logical","width":1},{"name":"ARS_MASTER","type":"number","width":8,"decimals":0},{"name":"RS","type":"number","width":2,"decimals":0},{"name":"DECL_STMT","type":"character","width":250},{"name":"GCC","type":"number","width":1,"decimals":0},{"name":"PORT_CODE","type":"character","width":4},{"name":"LID","type":"character","width":10},{"name":"IDG","type":"logical","width":1},{"name":"CARRIER","type":"number","width":2,"decimals":0},{"name":"FSI_ACCTNO","type":"character","width":6},{"name":"TRUCK_NO","type":"character","width":20},{"name":"RES_IND","type":"logical","width":1},{"name":"CWT","type":"logical","width":1},{"name":"EMAILASN3","type":"character","width":250},{"name":"CLASS","type":"number","width":5,"decimals":1},{"name":"QVNSHIP1","type":"logical","width":1},{"name":"QVNEXC1","type":"logical","width":1},{"name":"QVNDEL1","type":"logical","width":1},{"name":"QVNSUB1","type":"number","width":1,"decimals":0},{"name":"QVNEMAIL1","type":"character","width":50},{"name":"QVNSHIP2","type":"logical","width":1},{"name":"QVNEXC2","type":"logical","width":1},{"name":"QVNDEL2","type":"logical","width":1},{"name":"QVNSUB2","type":"number","width":1,"decimals":0},{"name":"QVNEMAIL2","type":"character","width":50},{"name":"QVNSHIP3","type":"logical","width":1},{"name":"QVNEXC3","type":"logical","width":1},{"name":"QVNDEL3","type":"logical","width":1},{"name":"QVNSUB3","type":"number","width":1,"decimals":0},{"name":"QVNEMAIL3","type":"character","width":50},{"name":"QVNSHIP4","type":"logical","width":1},{"name":"QVNEXC4","type":"logical","width":1},{"name":"QVNDEL4","type":"logical","width":1},{"name":"QVNSUB4","type":"number","width":1,"decimals":0},{"name":"QVNEMAIL4","type":"character","width":50},{"name":"QVNSHIP5","type":"logical","width":1},{"name":"QVNEXC5","type":"logical","width":1},{"name":"QVNDEL5","type":"logical","width":1},{"name":"QVNSUB5","type":"number","width":1,"decimals":0},{"name":"QVNEMAIL5","type":"character","width":50},{"name":"QVNFAIL","type":"character","width":50},{"name":"QVNENABLE","type":"logical","width":1},{"name":"EXCH_COLL","type":"logical","width":1},{"name":"EXC_RMAIL","type":"character","width":100},{"name":"EXC_SMAIL","type":"character","width":100},{"name":"EXC_AMOUNT","type":"number","width":16,"decimals":2},{"name":"EXC_CURR","type":"character","width":10},{"name":"EXC_RPCT","type":"number","width":3,"decimals":0},{"name":"EXC_DESC","type":"character","width":100},{"name":"EXC_ADDC","type":"character","width":100},{"name":"DT_ACCTNO","type":"character","width":10},{"name":"DT_NAME","type":"character","width":35},{"name":"DT_ADDR1","type":"character","width":35},{"name":"DT_ADDR2","type":"character","width":35},{"name":"DT_ADDR3","type":"character","width":35},{"name":"DT_POSTAL","type":"character","width":14},{"name":"DT_CITY","type":"character","width":30},{"name":"DT_PROV","type":"character","width":30},{"name":"DT_COUNTRY","type":"character","width":3},{"name":"DT_CONTACT","type":"character","width":35},{"name":"DT_PHONE","type":"character","width":25},{"name":"DT_FAX","type":"character","width":25},{"name":"DT_CUSTID","type":"character","width":14},{"name":"DT_TAXID","type":"character","width":35},{"name":"BILL_FRT","type":"number","width":1,"decimals":0},{"name":"BILL_DT","type":"number","width":1,"decimals":0},{"name":"ISC_TYPES","type":"character","width":30},{"name":"AES","type":"character","width":28},{"name":"LTL_NO","type":"character","width":20},{"name":"E_INV","type":"logical","width":1},{"name":"DVS","type":"logical","width":1},{"name":"PRO_RESP","type":"logical","width":1},{"name":"CARBON","type":"logical","width":1}],"n_rows":1,"rows_kept":1,"cut":false,"deleted_skipped":0,"read_ended":"whole","bounds":"16MiB/16384/4096/first_that_fit","version":"dbase_level_three","encoding_class":"enc_absent","reader":"statdb_count/9"}
[40,"1ZA966A1CF32900399","2012-04-23",1243,"2012-04-23",1700,null,"CA-TEST","A966A1","CONNECT-WIN7","2900 W STEELES AVE W",null,null,"L4K3S2","CONCORD","ON","CA","TAHIR","9054500984",null,null,"A966A3","TEST COMPANY","TEST CONTACT",null,null,"L6L6L6","OAKVILLE","ON","CA",null,"TEST CONTACT","9056608604",null,"CA-TEST",null,"A966A3","TEST COMPANY","TEST CONTACT",null,null,"L6L6L6","OAKVILLE","ON","CA","TEST CONTACT","9056608604",null,"CA-TEST",null,"A966A1","CONNECT-WIN7","2900 W STEELES AVE W",null,null,"L4K3S2","CONCORD","ON","CA","TAHIR","9054500984",null,null,null,0,1,2.00,11.00,11.00,"04",0,"500","PRE","CONNECT-WIN7 COMPABILITY TEST","REF1-TEST","NO PKG SHIPPED-PLD UPLOAD TEST",null,null,null,null,null,null,null,null,14.05,0.00,0.00,0.00,7.67,14.05,0.00,0.00,0.00,7.67,0.00,0.00,0.00,0.00,0.00,44.95,0,null,null,null,null,null,null,null,"4539753024",false,null,null,null,0.00,null,null,null,"2012-04-23",0,0.00,null,true,false,false,false,false,null,false,100.00,false,null,null,null,false,null,"connect win7 compability test",null,null,null,null,null,false,null,0,null,0,null,null,false,0,null,null,false,false,null,null,true,true,true,0,"tbukhari@ups.com",false,false,false,0,null,false,false,false,0,null,false,false,false,0,null,false,false,false,0,null,"tbukhari@ups.com",true,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,0,null,null,null,false,false,false,true]