# EXO DR_ACCS (debtor master) — full column list, captured 2026-07-25 from
# INFORMATION_SCHEMA.COLUMNS. Columns relevant to Evolution contact creation flagged.
# NOTE: NO contact-person column here — EXO contact people are in the CONTACTS table,
#       linked via DR_ACCS.STATEMENT_CONTACT_SEQNO.

ACCNO int                 -> contacts.externalRef2  (EXO debtor id; the CSV col-1 client id)
NAME nvarchar(60)         -> contacts.company
ADDRESS1..ADDRESS5 nvarchar(30)   -> street/address lines
DELADDR1..DELADDR6 nvarchar(30)   -> delivery address
X_CITY nvarchar(256), X_STATE nvarchar(256), POST_CODE nvarchar(12)
PHONE nvarchar(30), FAX nvarchar(30), EMAIL nvarchar(60), WEBSITE nvarchar(50)
TAXREG nvarchar(30)       -> ABN / GST registration (primary)
X_TAXIDNUMBER nvarchar(50), X_GSTIDNUMBER nvarchar(50)  -> custom ABN fields (fallback)
ALPHACODE nvarchar(15)    -> EXO short code
ISACTIVE char(1)          -> 'Y'/'N' active flag
BALANCE float, PRIOR_BALANCE float
NOTES nvarchar(max)
STATEMENT_CONTACT_SEQNO int -> FK to EXO CONTACTS table for the contact person
X_PHONE2/X_PHONE3 nvarchar(50)
-- (other cols: banking, aged balances, GL control accts, credit terms, social — not needed for import)