CREATE TABLE company_master (
    "company_id" serial
        PRIMARY KEY,            -- System generated unique ID, This is the mother of all keys
    "company_name" varchar(64),                 -- Company name
    "address_1" varchar(32),                                        -- Address line
    "address_2" varchar(32),                    -- Address line
    "address_3" varchar(32),                    -- Address line
    "city" varchar(32),                         -- City
    "locality" varchar(32),                     -- State, Province, Fylke, etc...
    "mailing_code" varchar(16),                 -- Zip, mailing code, etc...
    "phone" varchar(32),                        -- Phone
    "fax" varchar(32),                          -- Fax
    "toll_free_phone" varchar(32),              -- Toll-free phone number
    "email" varchar(64),                        -- Email
    "url" varchar(128),                         -- Web-site address
    "billing_name" varchar(64),                 -- Billing Name
    "billing_address_1" varchar(32),            -- Billing Addy 1
    "billing_address_2" varchar(32),            -- Billing Addy 2
    "billing_city" varchar(32),                 -- Billing City
    "billing_locality" varchar(32),             -- Billing Locality
    "billing_mailing_code" varchar(16),         -- Billing Mailing Code
    "billing_phone" varchar(32),                -- Billing Phone
    "billing_fax" varchar(32),                  -- Billing Fax
    "billing_email" varchar(64),                -- Billing Email
    "low_margin_order_percent" numeric(5,3),    -- Low-margin alert on order
    "low_margin_item_percent" numeric(5,3),     -- Low-margin alert on items
    "count_sheet_max_dollars" numeric(10,2),    -- Max dollar amount count can be off and still accepted
    "count_sheet_max_percent" int,              -- Max # of units count can be off and still accepted
    "last_end_of_day" timestamp                 -- Last end-of-day timestamp
        without time zone,
    "cash_in_bank_gl_account" varchar(12),      -- G/L interface A/R
    "cash_in_bank_gl_dept" numeric(4),          -- G/L interface A/R
    "return_sales_gl_account" varchar(12),      -- G/L interface A/R
    "return_sales_gl_dept" numeric(4),          -- G/L interface A/R
    "accounts_rec_gl_account" varchar(12),      -- G/L interface A/R
    "accounts_rec_gl_dept" numeric(4),          -- G/L interface A/R
    "sales_gl_account"        varchar(12),      -- G/L interface A/R
    "sales_gl_dept" numeric(4),                 -- G/L interface A/R
    "sales_tax_gl_account" varchar(12),         -- G/L interface A/R
    "sales_tax_gl_dept" numeric(4),             -- G/L interface A/R
    "misc_sp_chrg_gl_account" varchar(12),      -- G/L interface A/R
    "misc_sp_chrg_gl_dept" numeric(4),          -- G/L interface A/R
    "cash_discount_gl_account" varchar(12),     -- G/L interface A/R
    "cash_discount_gl_dept" numeric(4),         -- G/L interface A/R
    "cash_on_bad_debt_gl_account" varchar(12),  -- G/L interface A/R
    "cash_on_bad_debt_gl_dept" numeric(4),      -- G/L interface A/R
    "finance_chrg_gl_account" varchar(12),      -- G/L interface A/R
    "finance_chrg_gl_dept" numeric(4),          -- G/L interface A/R
    "freight_in_gl_account"  varchar(12),      -- G/L interface A/R
    "freight_in_gl_dept" numeric(4),           -- G/L interface A/R
    "freight_out_gl_account" varchar(12),      -- G/L interface A/R
    "freight_out_gl_dept" numeric(4),          -- G/L interface A/R
    "invt_cost_gl_account"   varchar(12),      -- G/L interface A/R
    "invt_cost_gl_dept" numeric(4),            -- G/L interface A/R
    "cost_of_goods_gl_account"  varchar(12),   -- G/L interface A/R
    "cost_of_goods_gl_dept" numeric(4),        -- G/L interface A/R
    "labor_gl_account"       varchar(12),      -- G/L interface A/R
    "labor_gl_dept" numeric(4),                -- G/L interface A/R
    "claims_recv_gl_account" varchar(12),      -- G/L interface A/R
    "claims_recv_gl_dept" numeric(4),          -- G/L interface A/R
    "cash_disburs_gl_account" varchar(12),      -- G/L interface A/P
    "freight_in_ap_account"  varchar(12),      -- G/L interface A/P
    "accounts_pay_gl_account" varchar(12),      -- G/L interface A/P
    "disc_earned_gl_account"  varchar(12),      -- G/L interface A/P
    "ar_posting_period"       numeric(2)        -- Current Posting period
        DEFAULT 0,
    "ap_posting_period"       numeric(2)        -- Current Posting period
        DEFAULT 0,
    "pr_posting_period"       numeric(2)        -- Current Posting period (Payroll)
        DEFAULT 0,
    "ro_posting_period"       numeric(2)        -- Current Posting period (Reoccurring JE's)
        DEFAULT 0,
    "fa_posting_period"       numeric(2)        -- Current Posting period (Fixed Assets)
        DEFAULT 0,
    "default_gl_dept"         numeric(4)        -- Current Posting period
        DEFAULT 1,

UNIQUE (company_name)
);