Index

_

__init__() (lib.remote.Compile method) (lib.remote.Construct method) (lib.remote.DataStructure method) (lib.remote.Output method) (lib.remote.SheetStructure method) (lib.remote.Super method) _assert_column_existence() (lib.remote.Output method) _change_data_types() (lib.remote.Output method) _create() (lib.remote._Query method) _join_methods() (lib.remote.Output method)

_metadata() (lib.remote.Compile method) (lib.remote.Construct method) (lib.remote.Output method) _Parameters (class in lib.remote) _process_methods() (lib.remote.Output method) _Query (class in lib.remote) _verify() (lib.remote._Parameters method) _verify_column() (lib.remote._Query method) _verify_join() (lib.remote._Query method) _verify_where() (lib.remote._Query method)

A

acc_category_desc_pt (lib.remote._Parameters attribute) account_category_pt (lib.remote._Parameters attribute) account_group_pt (lib.remote._Parameters attribute) account_pt (lib.remote._Parameters attribute) accounts (lib.reports.OptionalArgs attribute), [1] add_hierarchy() (in module lib.national) add_parents() (in module lib.national) ade module

adhoc_data() (in module lib.formatting) adhoc_pivot() (in module lib.formatting) (lib.remote.Compile method) Admin (class in lib.admin) aggfunc (lib.reports.PivotArgs attribute), [1] agreement_pt (lib.remote._Parameters attribute) agreements (lib.reports.OptionalArgs attribute), [1] args (lib.reports.CompilateArgs attribute), [1] Argument (class in lib.arguments) atoi() (in module lib.natural_keys)

C

calendar() (in module lib.dates) cc (lib.reports.Email attribute), [1] cell (lib.remote.SheetStructure attribute) check_db_update() (lib.admin.Admin method) check_reports_update() (lib.admin.Admin method) client_pt (lib.remote._Parameters attribute) client_slides() (lib.remote.Compile method) clients (lib.reports.OptionalArgs attribute), [1], [2] close() (in module lib.dates) code_pt (lib.remote._Parameters attribute) columns (lib.remote._Query attribute) (lib.reports.PivotArgs attribute), [1] (lib.reports.RequiredArgs attribute), [1] compilate (lib.reports.Report attribute), [1]

CompilateArgs (class in lib.reports) Compile (class in lib.remote) compile() (lib.remote.Output method) Construct (class in lib.remote) construct (lib.remote.Compile attribute) (lib.remote.Output attribute) convert_decimal() (in module lib.util.data) convert_pascal() (in module lib.util.data) cost_center_pt (lib.remote._Parameters attribute) counter_subset() (in module lib.reports) create_dirs() (in module lib.admin) create_files() (in module lib.admin) create_list_of_list_from_list() (in module lib.arguments) customer_search() (in module lib.remote)

D

daily_agreement() (lib.remote.Output method) data (lib.remote.Compile attribute) (lib.remote.DataStructure attribute) DataStructure (class in lib.remote) date (lib.reports.RequiredArgs attribute), [1] date_pt (lib.remote._Parameters attribute) days_in_month() (in module lib.dates)

days_to_pay() (in module lib.remote) del_hierarchy() (in module lib.national) departments (lib.reports.OptionalArgs attribute), [1] dept_pt (lib.remote._Parameters attribute) description (lib.reports.Parent attribute), [1] df (lib.remote.Output attribute) division_pt (lib.remote._Parameters attribute)

E

Email (class in lib.reports) email (lib.reports.Report attribute), [1]

email() (in module lib.mail) equipment_report() (lib.remote.Compile method) ext (lib.reports.Parent attribute), [1]

F

file() (lib.remote.Compile method) (lib.remote.Output method) filename (lib.reports.Report attribute), [1] fill_unused_optional_args() (in module lib.reports)

from_excel() (in module lib.dates) fuel_tank() (lib.remote.Output method) function (lib.reports.Report attribute), [1] FunctionArgs (class in lib.reports)

G

get() (in module lib.local) (lib.remote.Output method) get_bin_config() (lib.admin.Admin method) get_db_root() (lib.admin.Admin method) get_existing_reports() (in module lib.reports)

get_image_path() (in module lib.arguments) get_rate() (lib.remote.Output method) get_schema_path() (in module lib.arguments) get_usage() (lib.remote.Output method) get_version() (in module lib.arguments)

I

index (lib.reports.PivotArgs attribute), [1] initializor() (in module lib.admin) int_pt (lib.remote._Parameters attribute)

invoice_base() (in module lib.remote) invoices (lib.reports.OptionalArgs attribute), [1] itemrate_split() (lib.remote.Output method)

J

joins (lib.remote._Query attribute) (lib.reports.OptionalArgs attribute), [1]

K

key (lib.reports.Parent attribute), [1] (lib.reports.Report attribute), [1]

L

lib.admin module lib.arguments module lib.connections module lib.dates module lib.formatting module lib.local module lib.mail module lib.national module

lib.natural_keys module lib.remote module lib.reports module lib.util.cleanup module lib.util.data module lib.util.sql module location() (in module lib.util.cleanup) (lib.remote.Output method) location_search() (in module lib.remote) locations() (in module lib.local) logger() (in module lib.admin)

M

main() (in module ade) margins (lib.reports.PivotArgs attribute), [1] matches (lib.remote._Query attribute) message (lib.reports.Email attribute), [1] MetadataConverter (class in lib.remote) mod() (in module lib.util.sql) mod_budget() (in module lib.national) mod_hierarchy() (in module lib.national) mod_parents() (in module lib.national) module ade lib.admin lib.arguments lib.connections lib.dates lib.formatting lib.local lib.mail lib.national lib.natural_keys lib.remote lib.reports lib.util.cleanup lib.util.data lib.util.sql

monthcount() (in module lib.dates)

N

na() (in module lib.util.cleanup) name (lib.arguments.Argument attribute), [1] (lib.arguments.Parser attribute), [1] (lib.reports.Parent attribute), [1] (lib.reports.PivotArgs attribute), [1] (lib.reports.Report attribute), [1]

national_account() (lib.remote.Compile method) natural_keys() (in module lib.natural_keys) not_where (lib.remote._Query attribute)

O

operator() (in module lib.util.sql) operators (lib.remote._Parameters attribute) opportunity() (in module lib.util.cleanup) opptype() (lib.remote.Output method) optional (lib.arguments.Parser attribute), [1] (lib.reports.Report attribute), [1]

OptionalArgs (class in lib.reports) ors (lib.reports.OptionalArgs attribute), [1] other (lib.reports.OptionalArgs attribute), [1] Output (class in lib.remote) output (lib.remote.Compile attribute) (lib.remote.DataStructure attribute) outstanding() (in module lib.remote)

P

params (lib.arguments.Argument attribute), [1] (lib.remote._Query attribute) (lib.remote.Construct attribute) Parent (class in lib.reports) parent (lib.reports.Report attribute), [1] parent() (in module lib.util.cleanup) (lib.remote.Output method) parse() (in module lib.reports) parse_params() (in module lib.reports) Parser (class in lib.arguments) parser (lib.arguments.Parser attribute), [1] pivot (lib.reports.Report attribute), [1] PivotArgs (class in lib.reports) po_expiry() (in module lib.util.cleanup) (lib.remote.Output method) pos (lib.reports.OptionalArgs attribute), [1]

post (lib.reports.FunctionArgs attribute) post_methods (lib.remote.Output attribute) power_source() (lib.remote.Output method) prefix (lib.remote._Query attribute) prepare_arguments() (in module lib.arguments) print_pyinstaller() (in module ade) product() (in module lib.util.cleanup) (lib.remote.Output method) product_description() (lib.remote.Output method) product_revenue() (lib.remote.Compile method) products (lib.reports.OptionalArgs attribute), [1] products() (in module lib.local) pull (lib.reports.FunctionArgs attribute) pull() (in module lib.remote) (lib.remote.Construct method) pull_methods (lib.remote.Output attribute)

Q

query (lib.remote.Construct attribute) (lib.reports.PivotArgs attribute)

R

rate_by_days() (lib.remote.Output method) rebate() (lib.remote.Compile method) recurring_monthly() (lib.remote.Output method) regions (lib.reports.OptionalArgs attribute), [1] remove_column_duplicates() (in module lib.util.data) rentals_rates() (lib.remote.Compile method) replace() (in module lib.reports) Report (class in lib.reports)

report (lib.arguments.Parser attribute), [1] (lib.remote.Compile attribute) (lib.remote.Output attribute) (lib.remote.Super attribute) required (lib.arguments.Parser attribute), [1] (lib.reports.Report attribute), [1] RequiredArgs (class in lib.reports) run() (in module ade) (in module lib.remote)

S

save_file() (in module lib.local) schema (lib.remote._Query attribute) schema() (in module lib.local) sectors (lib.reports.OptionalArgs attribute), [1] separate_dict_params() (in module lib.arguments) sheet (lib.remote.SheetStructure attribute) SheetStructure (class in lib.remote) site() (in module lib.util.cleanup) (lib.remote.Output method)

sites() (in module lib.local) split_parameter_list() (in module lib.util.sql) str_pt (lib.remote._Parameters attribute) string (lib.remote._Query attribute) structure (lib.remote.DataStructure attribute) subject (lib.reports.Email attribute), [1] subs (lib.reports.PivotArgs attribute), [1] subtotal() (in module lib.util.data) Super (class in lib.remote)

T

table (lib.remote._Query attribute) (lib.reports.RequiredArgs attribute), [1] tables (lib.remote._Query attribute) time() (in module lib.local) timedelta() (in module lib.util.cleanup) to (lib.reports.Email attribute), [1]

to_date_id() (in module lib.dates) to_dict() (lib.remote._Parameters method) to_excel() (in module lib.dates) to_list() (lib.remote._Parameters method) triple_shift() (lib.remote.Output method) types (lib.remote._Parameters attribute)

V

values (lib.reports.PivotArgs attribute), [1]

vector_cal() (in module lib.dates)

W

where (lib.remote._Query attribute)