{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Settings","ZCJ_ContractUpdateItems Import","Lookups"],"not_rendered":{"images":3,"macros":1,"external_links":2,"defined_names":9,"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"Settings","index":0,"n_rows":16,"n_cols":6,"rows_kept":16,"merged":[[14,5,16,11]]}
[null,null,"ZCJ_ContractUpdateItems Import version 1.1"]
[]
[null,null,"Company DB Name","Server",null,"When clicking on export to import buttons on other sheets user will be prompted to log in with user name and password."]
[null,null,"CEOJuice","EAUTO12"]
[{"$nulls":5},"Note: the user name and password are for a valid SQL Server login"]
[]
[]
[null,null,"Filters:"]
[null,null,"Column","Value"]
[null,null,"Contract Number",null,null,"Limit the export list by Contract # \"contains\" or leave blank to include all."]
[]
[]
[]
[]
[null,null,"Other Settings:",null,null,"leave blank to process all records regardless of local change detection, or change to YES to only process rows where Excel detected a possible local change to one of the row values."]
[null,null,"Process Locally Dectected Changes Only"]

{"sheet":"ZCJ_ContractUpdateItems Import","index":1,"n_rows":11,"n_cols":18,"rows_kept":11}
[{"$f":"Settings!C1","v":"ZCJ_ContractUpdateItems Import version 1.1"},null,"Process Locally Dectected Changes Only",{"$f":"IF(LOCAL_EDITS_ONLY=\"YES\",1,0)","v":0}]
[null,null,"THESE COLUMNS CANNOT BE UPDATED"]
[null,null,"THESE COLUMNS CAN BE UPDATED"]
[]
[]
[]
[{"$nulls":10},"Internal BatchID across all rows to be changed with each new import."]
["Status","Error Message","Post Action","Local Edits Detected","TransactionID","TargContractNumber","TargContractTab","ItemNumber/Misc Code","TargItemDesc","BaseRateToUpdate","BatchControlNumber","TargAction","TermDate","TermCode","StartDate","BillStartDate","EndBillDate","CreateDate"]
[{"$nulls":3},"YES",null,"Contract #1","Equipment","ITEM NUMBER HERE","ITEM NUMBER DESCRIPTION HERE",0,"Sept142021","UPDATE"]
[{"$nulls":3},"YES",null,"Contract #2","Miscellaneous","MISC CODE HERE","MISC CODE DESCRIPTION HERE",348,"Sept142021","TERMINATE"]
[{"$nulls":3},"YES",null,"Contract #3","Equipment","ITEM NUMBER HERE","ITEM NUMBER DESCRIPTION HERE",12.5,"Sept142021","ADD"]

{"sheet":"Lookups","index":2,"n_rows":4,"n_cols":1,"rows_kept":4,"hidden":true}
["Type"]
["ADD"]
["UPDATE"]
["TERMINATE"]