Schema

You can obtain the full MoneyWorks database schema by exporting "xmlschema" to a file. E.g.

tell application "MoneyWorks Gold" to export "xmlschema" into POSIX file "/schema.xml"

Note that text field usable sizes are general one byte less than the size indicated here, in some cases they are larger than the size indicated (spillover is stored elsewhere).


<?xml version="1.0"?>
<tables>
    <table>
        <file_num>0</file_num>
        <name>Account</name>
        <fields>
            <field name="SequenceNumber" type="long" unsigned="true" />
            <field name="LastModifiedTime" type="time" unsigned="true" />
            <field name="Code" type="string" size="8" indexed="true" />
            <field name="Type" type="char_short" indexed="true" />
            <field name="Group" type="string" size="6" indexed="true" />
            <field name="Category" type="string" size="8" indexed="true" />
            <field name="Description" type="string" size="40" />
            <field name="PandL" type="string" size="8" indexed="true" />
            <field name="TaxCode" type="string" size="4" />
            <field name="Flags" type="short" />
            <field name="System" type="char_short" indexed="true" />
            <field name="Created" type="time" unsigned="true" />
            <field name="Category2" type="string" size="16" />
            <field name="Category3" type="string" size="16" />
            <field name="Category4" type="string" size="16" />
            <field name="AccountantCode" type="string" size="10" />
            <field name="Colour" type="short" />
            <field name="Currency" type="string" size="4" />
            <field name="SecurityLevel" type="short" />
            <field name="BankAccountNumber" type="string" size="24" />
            <field name="BalanceLimit" type="decimal" />
            <field name="ManualChequeNumber" type="string" size="12" />
            <field name="PrintedChequeNumber" type="string" size="12" />
            <field name="LastStatementImport" type="time" unsigned="true" />
            <field name="Comments" type="string" size="200" />
            <field name="ManualChequeNumDigits" type="byte" />
            <field name="PrintedChequeNumDigits" type="byte" />
        </fields>
    </table>
    <table>
        <file_num>1</file_num>
        <name>Ledger</name>
        <fields>
            <field name="SequenceNumber" type="long" unsigned="true" />
            <field name="LastModifiedTime" type="time" unsigned="true" />
            <field name="AccountCode" type="string" size="8" />
            <field name="Department" type="string" size="6" indexed="true" />
            <field name="Category" type="string" size="8" indexed="true" />
            <field name="Classification" type="string" size="6" indexed="true" />
            <field name="Type" type="char_short" indexed="true" />
            <field name="BalanceLast91" type="decimal" />
            <field name="BalanceLast90" type="decimal" />
            <field name="BalanceLast89" type="decimal" />
            <field name="BalanceLast88" type="decimal" />
            <field name="BalanceLast87" type="decimal" />
            <field name="BalanceLast86" type="decimal" />
            <field name="BalanceLast85" type="decimal" />
            <field name="BalanceLast84" type="decimal" />
            <field name="BalanceLast83" type="decimal" />
            <field name="BalanceLast82" type="decimal" />
            <field name="BalanceLast81" type="decimal" />
            <field name="BalanceLast80" type="decimal" />
            <field name="BalanceLast79" type="decimal" />
            <field name="BalanceLast78" type="decimal" />
            <field name="BalanceLast77" type="decimal" />
            <field name="BalanceLast76" type="decimal" />
            <field name="BalanceLast75" type="decimal" />
            <field name="BalanceLast74" type="decimal" />
            <field name="BalanceLast73" type="decimal" />
            <field name="BalanceLast72" type="decimal" />
            <field name="BalanceLast71" type="decimal" />
            <field name="BalanceLast70" type="decimal" />
            <field name="BalanceLast69" type="decimal" />
            <field name="BalanceLast68" type="decimal" />
            <field name="BalanceLast67" type="decimal" />
            <field name="BalanceLast66" type="decimal" />
            <field name="BalanceLast65" type="decimal" />
            <field name="BalanceLast64" type="decimal" />
            <field name="BalanceLast63" type="decimal" />
            <field name="BalanceLast62" type="decimal" />
            <field name="BalanceLast61" type="decimal" />
            <field name="BalanceLast60" type="decimal" />
            <field name="BalanceLast59" type="decimal" />
            <field name="BalanceLast58" type="decimal" />
            <field name="BalanceLast57" type="decimal" />
            <field name="BalanceLast56" type="decimal" />
            <field name="BalanceLast55" type="decimal" />
            <field name="BalanceLast54" type="decimal" />
            <field name="BalanceLast53" type="decimal" />
            <field name="BalanceLast52" type="decimal" />
            <field name="BalanceLast51" type="decimal" />
            <field name="BalanceLast50" type="decimal" />
            <field name="BalanceLast49" type="decimal" />
            <field name="BalanceLast48" type="decimal" />
            <field name="BalanceLast47" type="decimal" />
            <field name="BalanceLast46" type="decimal" />
            <field name="BalanceLast45" type="decimal" />
            <field name="BalanceLast44" type="decimal" />
            <field name="BalanceLast43" type="decimal" />
            <field name="BalanceLast42" type="decimal" />
            <field name="BalanceLast41" type="decimal" />
            <field name="BalanceLast40" type="decimal" />
            <field name="BalanceLast39" type="decimal" />
            <field name="BalanceLast38" type="decimal" />
            <field name="BalanceLast37" type="decimal" />
            <field name="BalanceLast36" type="decimal" />
            <field name="BalanceLast35" type="decimal" />
            <field name="BalanceLast34" type="decimal" />
            <field name="BalanceLast33" type="decimal" />
            <field name="BalanceLast32" type="decimal" />
            <field name="BalanceLast31" type="decimal" />
            <field name="BalanceLast30" type="decimal" />
            <field name="BalanceLast29" type="decimal" />
            <field name="BalanceLast28" type="decimal" />
            <field name="BalanceLast27" type="decimal" />
            <field name="BalanceLast26" type="decimal" />
            <field name="BalanceLast25" type="decimal" />
            <field name="BalanceLast24" type="decimal" />
            <field name="BalanceLast23" type="decimal" />
            <field name="BalanceLast22" type="decimal" />
            <field name="BalanceLast21" type="decimal" />
            <field name="BalanceLast20" type="decimal" />
            <field name="BalanceLast19" type="decimal" />
            <field name="BalanceLast18" type="decimal" />
            <field name="BalanceLast17" type="decimal" />
            <field name="BalanceLast16" type="decimal" />
            <field name="BalanceLast15" type="decimal" />
            <field name="BalanceLast14" type="decimal" />
            <field name="BalanceLast13" type="decimal" />
            <field name="BalanceLast12" type="decimal" />
            <field name="BalanceLast11" type="decimal" />
            <field name="BalanceLast10" type="decimal" />
            <field name="BalanceLast09" type="decimal" />
            <field name="BalanceLast08" type="decimal" />
            <field name="BalanceLast07" type="decimal" />
            <field name="BalanceLast06" type="decimal" />
            <field name="BalanceLast05" type="decimal" />
            <field name="BalanceLast04" type="decimal" />
            <field name="BalanceLast03" type="decimal" />
            <field name="BalanceLast02" type="decimal" />
            <field name="BalanceLast01" type="decimal" />
            <field name="Balance" type="decimal" />
            <field name="BudgetALast29" type="long" />
            <field name="BudgetALast28" type="long" />
            <field name="BudgetALast27" type="long" />
            <field name="BudgetALast26" type="long" />
            <field name="BudgetALast25" type="long" />
            <field name="BudgetALast24" type="long" />
            <field name="BudgetALast23" type="long" />
            <field name="BudgetALast22" type="long" />
            <field name="BudgetALast21" type="long" />
            <field name="BudgetALast20" type="long" />
            <field name="BudgetALast19" type="long" />
            <field name="BudgetALast18" type="long" />
            <field name="BudgetALast17" type="long" />
            <field name="BudgetALast16" type="long" />
            <field name="BudgetALast15" type="long" />
            <field name="BudgetALast14" type="long" />
            <field name="BudgetALast13" type="long" />
            <field name="BudgetALast12" type="long" />
            <field name="BudgetALast11" type="long" />
            <field name="BudgetALast10" type="long" />
            <field name="BudgetALast09" type="long" />
            <field name="BudgetALast08" type="long" />
            <field name="BudgetALast07" type="long" />
            <field name="BudgetALast06" type="long" />
            <field name="BudgetALast05" type="long" />
            <field name="BudgetALast04" type="long" />
            <field name="BudgetALast03" type="long" />
            <field name="BudgetALast02" type="long" />
            <field name="BudgetALast01" type="long" />
            <field name="BudgetA" type="long" />
            <field name="BudgetANext01" type="long" />
            <field name="BudgetANext02" type="long" />
            <field name="BudgetANext03" type="long" />
            <field name="BudgetANext04" type="long" />
            <field name="BudgetANext05" type="long" />
            <field name="BudgetANext06" type="long" />
            <field name="BudgetANext07" type="long" />
            <field name="BudgetANext08" type="long" />
            <field name="BudgetANext09" type="long" />
            <field name="BudgetANext10" type="long" />
            <field name="BudgetANext11" type="long" />
            <field name="BudgetANext12" type="long" />
            <field name="BudgetANext13" type="long" />
            <field name="BudgetANext14" type="long" />
            <field name="BudgetANext15" type="long" />
            <field name="BudgetANext16" type="long" />
            <field name="BudgetANext17" type="long" />
            <field name="BudgetANext18" type="long" />
            <field name="BudgetBLast29" type="long" />
            <field name="BudgetBLast28" type="long" />
            <field name="BudgetBLast27" type="long" />
            <field name="BudgetBLast26" type="long" />
            <field name="BudgetBLast25" type="long" />
            <field name="BudgetBLast24" type="long" />
            <field name="BudgetBLast23" type="long" />
            <field name="BudgetBLast22" type="long" />
            <field name="BudgetBLast21" type="long" />
            <field name="BudgetBLast20" type="long" />
            <field name="BudgetBLast19" type="long" />
            <field name="BudgetBLast18" type="long" />
            <field name="BudgetBLast17" type="long" />
            <field name="BudgetBLast16" type="long" />
            <field name="BudgetBLast15" type="long" />
            <field name="BudgetBLast14" type="long" />
            <field name="BudgetBLast13" type="long" />
            <field name="BudgetBLast12" type="long" />
            <field name="BudgetBLast11" type="long" />
            <field name="BudgetBLast10" type="long" />
            <field name="BudgetBLast09" type="long" />
            <field name="BudgetBLast08" type="long" />
            <field name="BudgetBLast07" type="long" />
            <field name="BudgetBLast06" type="long" />
            <field name="BudgetBLast05" type="long" />
            <field name="BudgetBLast04" type="long" />
            <field name="BudgetBLast03" type="long" />
            <field name="BudgetBLast02" type="long" />
            <field name="BudgetBLast01" type="long" />
            <field name="BudgetB" type="long" />
            <field name="BudgetBNext01" type="long" />
            <field name="BudgetBNext02" type="long" />
            <field name="BudgetBNext03" type="long" />
            <field name="BudgetBNext04" type="long" />
            <field name="BudgetBNext05" type="long" />
            <field name="BudgetBNext06" type="long" />
            <field name="BudgetBNext07" type="long" />
            <field name="BudgetBNext08" type="long" />
            <field name="BudgetBNext09" type="long" />
            <field name="BudgetBNext10" type="long" />
            <field name="BudgetBNext11" type="long" />
            <field name="BudgetBNext12" type="long" />
            <field name="BudgetBNext13" type="long" />
            <field name="BudgetBNext14" type="long" />
            <field name="BudgetBNext15" type="long" />
            <field name="BudgetBNext16" type="long" />
            <field name="BudgetBNext17" type="long" />
            <field name="BudgetBNext18" type="long" />
            <field name="Concat" type="string" size="14" indexed="true" />
            <field name="System" type="char_short" indexed="true" />
        </fields>
    </table>
    <table>
        <file_num>2</file_num>
        <name>General</name>
        <fields>
            <field name="SequenceNumber" type="long" unsigned="true" />
            <field name="LastModifiedTime" type="time" unsigned="true" />
            <field name="Code" type="string" size="10" indexed="true" />
            <field name="Description" type="string" size="32" />
            <field name="Date" type="date" unsigned="true" />
            <field name="Long" type="long" />
        </fields>
    </table>
    <table>
        <file_num>3</file_num>
        <name>Department</name>
        <fields>
            <field name="SequenceNumber" type="long" unsigned="true" />
            <field name="LastModifiedTime" type="time" unsigned="true" />
            <field name="Code" type="string" size="6" indexed="true" />
            <field name="Description" type="string" size="36" />
            <field name="Classification" type="string" size="6" indexed="true" />
            <field name="Custom1" type="string" size="16" />
            <field name="Custom2" type="string" size="10" />
            <field name="Flags" type="short" />
        </fields>
    </table>
    <table>
        <file_num>4</file_num>
        <name>Link</name>
        <fields>
            <field name="SequenceNumber" type="long" unsigned="true" />
            <field name="LastModifiedTime" type="time" unsigned="true" />
            <field name="Dept" type="string" size="6" indexed="true" />
            <field name="Group" type="string" size="6" indexed="true" />
        </fields>
    </table>
    <table>
        <file_num>5</file_num>
        <name>Transaction</name>
        <fields>
            <field name="SequenceNumber" type="long" unsigned="true" indexed="true" />
            <field name="LastModifiedTime" type="time" unsigned="true" />
            <field name="OurRef" type="string" size="12" indexed="true" />
            <field name="TransDate" type="date" unsigned="true" indexed="true" />
            <field name="EnterDate" type="date" unsigned="true" indexed="true" />
            <field name="DueDate" type="date" unsigned="true" />
            <field name="Period" type="short" indexed="true" />
            <field name="Type" type="string" size="4" indexed="true" />
            <field name="TheirRef" type="string" size="22" />
            <field name="NameCode" type="string" size="12" indexed="true" />
            <field name="Flag" type="string" size="6" />
            <field name="Description" type="string" size="26" />
            <field name="Gross" type="decimal" />
            <field name="Analysis" type="string" size="10" />
            <field name="Contra" type="string" size="8" />
            <field name="ToFrom" type="string" size="26" />
            <field name="Status" type="string" size="2" indexed="true" />
            <field name="Hold" type="boolean" />
            <field name="DatePaid" type="date" unsigned="true" />
            <field name="AmtPaid" type="decimal" />
            <field name="unused" type="char_short" />
            <field name="PayAmount" type="decimal" />
            <field name="Aging" type="short" />
            <field name="TaxAmount" type="decimal" />
            <field name="TaxCycle" type="short" />
            <field name="Recurring" type="boolean" />
            <field name="Printed" type="short" />
            <field name="Flags" type="long" />
            <field name="TaxProcessed" type="decimal" />
            <field name="Salesperson" type="string" size="6" />
            <field name="Colour" type="short" />
            <field name="BankJNSeq" type="long" unsigned="true" />
            <field name="PaymentMethod" type="short" />
            <field name="TimePosted" type="time" unsigned="true" />
            <field name="SecurityLevel" type="short" />
            <field name="User1" type="string" size="12" />
            <field name="User2" type="string" size="12" />
            <field name="User3" type="string" size="12" />
            <field name="PromptPaymentDate" type="date" unsigned="true" />
            <field name="PromptPaymentAmt" type="decimal" />
            <field name="ProdPriceCode" type="string" size="2" />
            <field name="MailingAddress" type="string" size="2" />
            <field name="DeliveryAddress" type="string" size="2" />
            <field name="FreightCode" type="string" size="16" />
            <field name="FreightAmount" type="decimal" />
            <field name="FreightDetails" type="string" size="2" />
            <field name="SpecialBank" type="string" size="2" />
            <field name="SpecialBranch" type="string" size="2" />
            <field name="SpecialAccount" type="string" size="2" />
            <field name="Currency" type="string" size="4" />
            <field name="ExchangeRate" type="double" />
            <field name="EnteredBy" type="string" size="4" />
            <field name="PostedBy" type="string" size="4" />
            <field name="AmtWrittenOff" type="decimal" />
            <field name="OrderTotal" type="decimal" />
            <field name="OrderShipped" type="decimal" />
            <field name="OrderDeposit" type="decimal" />
            <field name="OriginatingOrderSeq" type="long" />
            <field name="CurrencyTransferSeq" type="long" />
            <field name="PromptPaymentTerms" type="short" />
            <field name="PromptPaymentDisc" type="float" />
        </fields>
    </table>
    <table>
        <file_num>6</file_num>
        <name>Detail</name>
        <fields>
            <field name="Detail.SequenceNumber" type="long" unsigned="true" />
            <field name="Detail.LastModifiedTime" type="time" unsigned="true" />
            <field name="Detail.ParentSeq" type="long" indexed="true" />
            <field name="Detail.Sort" type="short" />
            <field name="Detail.Account" type="string" size="14" indexed="true" />
            <field name="Detail.Dept" type="string" size="6" />
            <field name="Detail.PostedQty" type="double" />
            <field name="Detail.TaxCode" type="string" size="4" />
            <field name="Detail.Gross" type="decimal" />
            <field name="Detail.Tax" type="decimal" />
            <field name="Detail.Debit" type="decimal" />
            <field name="Detail.Credit" type="decimal" />
            <field name="Detail.Description" type="string" size="34" />
            <field name="Detail.StockQty" type="double" />
            <field name="Detail.StockCode" type="string" size="16" indexed="true" />
            <field name="Detail.CostPrice" type="double" />
            <field name="Detail.UnitPrice" type="double" />
            <field name="Detail.Statement" type="long" indexed="true" />
            <field name="Detail.JobCode" type="string" size="10" indexed="true" />
            <field name="Detail.SaleUnit" type="string" size="4" />
            <field name="Detail.Discount" type="double" />
            <field name="Detail.Flags" type="short" />
            <field name="Detail.OrderQty" type="double" />
            <field name="Detail.BackorderQty" type="double" />
            <field name="Detail.PrevShipQty" type="double" />
            <field name="Detail.BaseCurrencyNet" type="decimal" />
            <field name="Detail.SerialNumber" type="string" size="2" />
            <field name="Detail.Period" type="short" />
            <field name="Detail.TransactionType" type="char_short" />
            <field name="Detail.SecurityLevel" type="short" />
            <field name="Detail.RevalueQty" type="double" />
            <field name="Detail.StockLocation" type="string" size="4" />
            <field name="Detail.OrderStatus" type="boolean" />
            <field name="Detail.ExpensedTax" type="decimal" />
        </fields>
    </table>
    <table>
        <file_num>7</file_num>
        <name>Log</name>
        <fields>
            <field name="SequenceNumber" type="long" unsigned="true" />
            <field name="LastModifiedTime" type="time" unsigned="true" />
            <field name="Description" type="char_long" />
            <field name="Who" type="string" size="4" />
            <field name="Info1" type="string" size="16" />
            <field name="Info2" type="string" size="16" />
            <field name="Info3" type="string" size="16" />
        </fields>
    </table>
    <table>
        <file_num>8</file_num>
        <name>TaxRate</name>
        <fields>
            <field name="SequenceNumber" type="long" unsigned="true" />
            <field name="LastModifiedTime" type="time" unsigned="true" />
            <field name="TaxCode" type="string" size="4" />
            <field name="PaidAccount" type="string" size="8" />
            <field name="RecAccount" type="string" size="8" />
            <field name="Rate1" type="double" />
            <field name="Date" type="date" unsigned="true" />
            <field name="Rate2" type="double" />
            <field name="Combine" type="short" />
            <field name="CombineRate1" type="double" />
            <field name="CombineRate2" type="double" />
            <field name="GSTReceived" type="decimal" />
            <field name="NetReceived" type="decimal" />
            <field name="GSTPaid" type="decimal" />
            <field name="NetPaid" type="decimal" />
            <field name="RateName" type="string" size="30" />
            <field name="ReportCycleStart" type="short" />
            <field name="ReportCycleEnd" type="short" />
            <field name="ReportDate" type="date" unsigned="true" />
            <field name="PSTReceived" type="decimal" />
            <field name="PSTPaid" type="decimal" />
            <field name="Type" type="short" />
            <field name="Combination" type="string" size="16" />
        </fields>
    </table>
    <table>
        <file_num>9</file_num>
        <name>Message</name>
        <fields>
            <field name="SequenceNumber" type="long" unsigned="true" />
            <field name="LastModifiedTime" type="time" unsigned="true" />
            <field name="StartDate" type="date" unsigned="true" />
            <field name="EndDate" type="date" unsigned="true" />
            <field name="NextDate" type="date" unsigned="true" indexed="true" />
            <field name="Keep" type="boolean" />
            <field name="Ref" type="long" />
            <field name="LastDay" type="byte" />
            <field name="NDaily" type="byte" />
            <field name="NWeekly" type="byte" />
            <field name="NMonthly" type="byte" />
            <field name="Once" type="byte" />
            <field name="XTimes" type="byte" />
            <field name="Forever" type="byte" />
            <field name="Day" type="byte" />
            <field name="Type" type="short" />
            <field name="DayOfWeek" type="byte" />
            <field name="N" type="byte" />
            <field name="X" type="byte" />
            <field name="AvoidWeekends" type="byte" />
            <field name="Reverse" type="byte" />
            <field name="" type="byte" />
            <field name="Message" type="string" size="256" />
            <field name="User" type="string" size="4" />
        </fields>
    </table>
    <table>
        <file_num>10</file_num>
        <name>Name</name>
        <fields>
            <field name="SequenceNumber" type="long" unsigned="true" />
            <field name="LastModifiedTime" type="time" unsigned="true" />
            <field name="Code" type="string" size="12" indexed="true" />
            <field name="Name" type="string" size="30" />
            <field name="Contact" type="string" size="26" />
            <field name="Position" type="string" size="30" />
            <field name="Address1" type="string" size="22" />
            <field name="Address2" type="string" size="22" />
            <field name="Address3" type="string" size="22" />
            <field name="Address4" type="string" size="22" />
            <field name="Delivery1" type="string" size="22" />
            <field name="Delivery2" type="string" size="22" />
            <field name="Delivery3" type="string" size="22" />
            <field name="Delivery4" type="string" size="22" />
            <field name="Phone" type="string" size="20" />
            <field name="Fax" type="string" size="20" />
            <field name="Category1" type="string" size="8" />
            <field name="Category2" type="string" size="8" />
            <field name="Category3" type="string" size="8" />
            <field name="Category4" type="string" size="8" />
            <field name="CustomerType" type="short" indexed="true" />
            <field name="D90Plus" type="decimal" />
            <field name="D60Plus" type="decimal" />
            <field name="D30Plus" type="decimal" />
            <field name="DCurrent" type="decimal" />
            <field name="CCurrent" type="decimal" />
            <field name="DebtorTerms" type="byte" />
            <field name="CreditorTerms" type="byte" />
            <field name="Bank" type="string" size="8" />
            <field name="AccountName" type="string" size="22" />
            <field name="BankBranch" type="string" size="22" />
            <field name="TheirRef" type="string" size="16" />
            <field name="Hold" type="boolean" />
            <field name="RecAccount" type="string" size="8" />
            <field name="PayAccount" type="string" size="8" />
            <field name="Kind" type="short" indexed="true" />
            <field name="CreditLimit" type="long" />
            <field name="Discount" type="decimal" />
            <field name="Comment" type="string" size="24" />
            <field name="SupplierType" type="short" indexed="true" />
            <field name="Colour" type="short" />
            <field name="Salesperson" type="string" size="6" />
            <field name="TaxCode" type="string" size="4" />
            <field name="SplitMode" type="short" />
            <field name="PostCode" type="string" size="12" />
            <field name="State" type="string" size="4" />
            <field name="BankAccountNumber" type="string" size="24" />
            <field name="Currency" type="string" size="4" />
            <field name="PaymentMethod" type="short" />
            <field name="DBalance" type="decimal" />
            <field name="DDI" type="string" size="20" />
            <field name="eMail" type="string" size="30" />
            <field name="Mobile" type="string" size="14" />
            <field name="AfterHours" type="string" size="12" />
            <field name="Contact2" type="string" size="12" />
            <field name="Position2" type="string" size="12" />
            <field name="DDI2" type="string" size="12" />
            <field name="eMail2" type="string" size="22" />
            <field name="Mobile2" type="string" size="14" />
            <field name="AfterHours2" type="string" size="12" />
            <field name="WebURL" type="string" size="10" />
            <field name="ProductPricing" type="string" size="2" />
            <field name="DateOfLastSale" type="date" unsigned="true" />
            <field name="SplitAcct1" type="string" size="14" />
            <field name="SplitAcct2" type="string" size="14" />
            <field name="SplitPercent" type="double" />
            <field name="SplitAmount" type="decimal" />
            <field name="UserNum" type="double" />
            <field name="UserText" type="string" size="8" />
            <field name="CustPromptPaymentTerms" type="short" />
            <field name="CustPromptPaymentDiscount" type="float" />
            <field name="SuppPromptPaymentTerms" type="short" />
            <field name="SuppPromptPaymentDiscount" type="float" />
            <field name="LastPaymentMethod" type="short" />
            <field name="CreditCardNum" type="string" size="20" />
            <field name="CreditCardExpiry" type="string" size="6" />
            <field name="CreditCardName" type="string" size="20" />
            <field name="TaxNumber" type="string" size="20" />
            <field name="Custom1" type="string" size="16" />
            <field name="Custom2" type="string" size="16" />
            <field name="Custom3" type="string" size="16" />
            <field name="Custom4" type="string" size="16" />
            <field name="DeliveryPostcode" type="string" size="12" />
            <field name="DeliveryState" type="string" size="4" />
            <field name="AddressCountry" type="string" size="16" />
            <field name="DeliveryCountry" type="string" size="16" />
            <field name="ReceiptMethod" type="short" />
            <field name="ABUID" type="string" size="2" />
            <field name="BankParticulars" type="string" size="2" />
            <field name="Flags" type="short" />
        </fields>
    </table>
    <table>
        <file_num>11</file_num>
        <name>Payments</name>
        <fields>
            <field name="SequenceNumber" type="long" unsigned="true" />
            <field name="LastModifiedTime" type="time" unsigned="true" />
            <field name="InvoiceID" type="long" indexed="true" />
            <field name="CashTrans" type="long" indexed="true" />
            <field name="Date" type="date" unsigned="true" />
            <field name="GSTCycle" type="short" />
            <field name="Amount" type="decimal" />
        </fields>
    </table>
    <table>
        <file_num>13</file_num>
        <name>Product</name>
        <fields>
            <field name="SequenceNumber" type="long" unsigned="true" />
            <field name="LastModifiedTime" type="time" unsigned="true" />
            <field name="Code" type="string" size="16" indexed="true" />
            <field name="SuppliersCode" type="string" size="20" />
            <field name="Supplier" type="string" size="12" />
            <field name="Description" type="string" size="38" />
            <field name="Comment" type="string" size="30" />
            <field name="Category1" type="string" size="8" />
            <field name="Category2" type="string" size="8" />
            <field name="Category3" type="string" size="8" />
            <field name="Category4" type="string" size="8" />
            <field name="SalesAcct" type="string" size="14" />
            <field name="COGAcct" type="string" size="14" />
            <field name="StockAcct" type="string" size="14" />
            <field name="UserNum" type="double" />
            <field name="SellUnit" type="string" size="4" />
            <field name="SellPrice" type="double" />
            <field name="Plussage" type="float" />
            <field name="BuyWeight" type="float" />
            <field name="BuyUnit" type="string" size="4" />
            <field name="CostPrice" type="double" />
            <field name="ConversionFactor" type="double" />
            <field name="MarginWarning" type="double" />
            <field name="SellDiscount" type="double" />
            <field name="SellDiscountMode" type="short" />
            <field name="UserText" type="string" size="8" />
            <field name="StockOnHand" type="double" />
            <field name="StockValue" type="double" />
            <field name="MinBuildQty" type="double" />
            <field name="NormalBuildQty" type="double" />
            <field name="ReorderLevel" type="double" />
            <field name="JobPricingMode" type="short" />
            <field name="Flags" type="long" />
            <field name="Colour" type="short" />
            <field name="UseMultiplePrices" type="boolean" />
            <field name="SellPriceB" type="double" />
            <field name="SellPriceC" type="double" />
            <field name="SellPriceD" type="double" />
            <field name="SellPriceE" type="double" />
            <field name="SellPriceF" type="double" />
            <field name="QtyBreak1" type="float" />
            <field name="QtyBreak2" type="float" />
            <field name="QtyBreak3" type="float" />
            <field name="QtyBreak4" type="float" />
            <field name="QtyBrkSellPriceA1" type="double" />
            <field name="QtyBrkSellPriceA2" type="double" />
            <field name="QtyBrkSellPriceA3" type="double" />
            <field name="QtyBrkSellPriceA4" type="double" />
            <field name="QtyBrkSellPriceB1" type="double" />
            <field name="QtyBrkSellPriceB2" type="double" />
            <field name="QtyBrkSellPriceB3" type="double" />
            <field name="QtyBrkSellPriceB4" type="double" />
            <field name="Type" type="string" size="2" indexed="true" />
            <field name="Count" type="double" />
            <field name="OnOrder" type="double" />
            <field name="StockTakeStartQty" type="double" />
            <field name="StockTakeValue" type="double" />
            <field name="StockTakeNewQty" type="double" />
            <field name="BarCode" type="string" size="20" indexed="true" />
            <field name="BuyPriceCurrency" type="string" size="4" />
            <field name="BuyPrice" type="double" />
            <field name="Custom1" type="string" size="16" />
            <field name="Custom2" type="string" size="16" />
            <field name="Custom3" type="string" size="16" />
            <field name="Custom4" type="string" size="16" />
            <field name="BuyTaxCode" type="string" size="4" />
            <field name="SellTaxCode" type="string" size="4" />
            <field name="LeadTimeDays" type="short" />
            <field name="Hash" type="short" indexed="true" />
            <field name="SellWeight" type="float" />
        </fields>
    </table>
    <table>
        <file_num>15</file_num>
        <name>Job</name>
        <fields>
            <field name="SequenceNumber" type="long" unsigned="true" />
            <field name="LastModifiedTime" type="time" unsigned="true" />
            <field name="Code" type="string" size="10" indexed="true" />
            <field name="Description" type="string" size="40" />
            <field name="Client" type="string" size="12" />
            <field name="Comment" type="string" size="40" />
            <field name="StartDate" type="date" unsigned="true" />
            <field name="Markup" type="double" />
            <field name="Quote" type="decimal" />
            <field name="Billed" type="decimal" />
            <field name="Status" type="char_short" indexed="true" />
            <field name="Flags" type="short" />
            <field name="Colour" type="short" />
            <field name="WIPAccount" type="string" size="14" />
            <field name="Category1" type="string" size="8" />
            <field name="Category2" type="string" size="8" />
            <field name="Category3" type="string" size="8" />
            <field name="Category4" type="string" size="8" />
            <field name="OrderNum" type="string" size="12" />
            <field name="Contact" type="string" size="20" />
            <field name="Phone" type="string" size="20" />
            <field name="EndDate" type="date" unsigned="true" />
            <field name="Manager" type="string" size="4" />
            <field name="PercentComplete" type="float" />
            <field name="Variations" type="decimal" />
            <field name="RetentionsHeld" type="decimal" />
            <field name="RetentionsOwing" type="decimal" />
            <field name="ProductPricing" type="string" size="2" />
            <field name="RetainPercent" type="float" />
            <field name="UserNum" type="double" />
            <field name="UserText" type="string" size="8" />
            <field name="Project" type="string" size="10" />
            <field name="TargetDate" type="date" unsigned="true" />
            <field name="Custom1" type="string" size="10" />
            <field name="Custom2" type="string" size="10" />
            <field name="Custom3" type="string" size="16" />
            <field name="Custom4" type="string" size="16" />
        </fields>
    </table>
    <table>
        <file_num>17</file_num>
        <name>Build</name>
        <fields>
            <field name="SequenceNumber" type="long" unsigned="true" />
            <field name="LastModifiedTime" type="time" unsigned="true" />
            <field name="Build.ProductSeq" type="long" indexed="true" />
            <field name="Build.Order" type="short" />
            <field name="Build.Qty" type="double" />
            <field name="Build.PartCode" type="string" size="16" />
            <field name="Build.Flags" type="short" />
        </fields>
    </table>
    <table>
        <file_num>18</file_num>
        <name>JobSheet</name>
        <fields>
            <field name="SequenceNumber" type="long" unsigned="true" />
            <field name="LastModifiedTime" type="time" unsigned="true" />
            <field name="Job" type="string" size="10" indexed="true" />
            <field name="Qty" type="double" />
            <field name="Resource" type="string" size="16" indexed="true" />
            <field name="Date" type="date" unsigned="true" />
            <field name="CostCentre" type="string" size="6" unsigned="true" />
            <field name="Account" type="string" size="8" />
            <field name="Period" type="short" />
            <field name="Units" type="string" size="4" />
            <field name="CostPrice" type="decimal" />
            <field name="SellPrice" type="decimal" />
            <field name="Memo" type="string" size="40" />
            <field name="DestTransSeq" type="long" />
            <field name="SourceTransSeq" type="long" indexed="true" />
            <field name="DateEntered" type="date" unsigned="true" />
            <field name="Flags" type="short" />
            <field name="Colour" type="short" />
            <field name="Status" type="char_short" indexed="true" />
            <field name="Type" type="char_short" />
            <field name="Analysis" type="string" size="10" />
            <field name="BillValue" type="decimal" />
            <field name="ActivityCode" type="string" size="10" />
            <field name="Comments" type="string" size="40" />
            <field name="Batch" type="long" />
            <field name="EnteredBy" type="string" size="4" indexed="true" />
        </fields>
    </table>
    <table>
        <file_num>19</file_num>
        <name>BankRecs</name>
        <fields>
            <field name="SequenceNumber" type="long" unsigned="true" indexed="true" />
            <field name="LastModifiedTime" type="time" unsigned="true" />
            <field name="Account" type="string" size="8" />
            <field name="Opening" type="decimal" />
            <field name="Closing" type="decimal" />
            <field name="Statement" type="short" />
            <field name="Date" type="date" unsigned="true" />
            <field name="ReconciledTime" type="time" unsigned="true" />
            <field name="Discrepancy" type="decimal" />
        </fields>
    </table>
    <table>
        <file_num>22</file_num>
        <name>AutoSplit</name>
        <fields>
            <field name="SequenceNumber" type="long" unsigned="true" />
            <field name="LastModifiedTime" type="time" unsigned="true" />
            <field name="MatchFunction" type="string" size="256" />
            <field name="SplitMode" type="long" />
            <field name="SplitAcct1" type="string" size="14" />
            <field name="SplitAcct2" type="string" size="14" />
            <field name="SplitAmount1" type="double" />
            <field name="SplitAmount2" type="double" />
            <field name="SplitAcct3" type="string" size="14" />
            <field name="SplitAcct4" type="string" size="14" />
            <field name="SplitAmount3" type="double" />
            <field name="MatchName" type="string" size="12" />
            <field name="Priority" type="short" />
        </fields>
    </table>
    <table>
        <file_num>23</file_num>
        <name>Memo</name>
        <fields>
            <field name="SequenceNumber" type="long" unsigned="true" />
            <field name="LastModifiedTime" type="time" unsigned="true" />
            <field name="Memo.NameSeq" type="long" indexed="true" />
            <field name="Memo.Order" type="short" />
            <field name="Memo.Date" type="date" unsigned="true" />
            <field name="Memo.RecallDate" type="date" unsigned="true" indexed="true" />
            <field name="Memo.Flags" type="short" />
            <field name="Memo.Text" type="string" size="80" />
        </fields>
    </table>
    <table>
        <file_num>24</file_num>
        <name>User</name>
        <fields>
            <field name="SequenceNumber" type="long" unsigned="true" />
            <field name="LastModifiedTime" type="time" unsigned="true" />
            <field name="Key" type="string" size="10" indexed="true" />
            <field name="Data" type="string" size="246" />
        </fields>
    </table>
    <table>
        <file_num>25</file_num>
        <name>OffLedger</name>
        <fields>
            <field name="SequenceNumber" type="long" unsigned="true" />
            <field name="LastModifiedTime" type="time" unsigned="true" />
            <field name="Kind" type="string" size="4" indexed="true" />
            <field name="Name" type="string" size="16" indexed="true" />
            <field name="Description" type="string" size="40" />
            <field name="Flags" type="long" />
            <field name="" type="string" size="8" />
            <field name="" type="string" size="8" />
            <field name="Balance91" type="double" />
            <field name="Balance90" type="double" />
            <field name="Balance89" type="double" />
            <field name="Balance88" type="double" />
            <field name="Balance87" type="double" />
            <field name="Balance86" type="double" />
            <field name="Balance85" type="double" />
            <field name="Balance84" type="double" />
            <field name="Balance83" type="double" />
            <field name="Balance82" type="double" />
            <field name="Balance81" type="double" />
            <field name="Balance80" type="double" />
            <field name="Balance79" type="double" />
            <field name="Balance78" type="double" />
            <field name="Balance77" type="double" />
            <field name="Balance76" type="double" />
            <field name="Balance75" type="double" />
            <field name="Balance74" type="double" />
            <field name="Balance73" type="double" />
            <field name="Balance72" type="double" />
            <field name="Balance71" type="double" />
            <field name="Balance70" type="double" />
            <field name="Balance69" type="double" />
            <field name="Balance68" type="double" />
            <field name="Balance67" type="double" />
            <field name="Balance66" type="double" />
            <field name="Balance65" type="double" />
            <field name="Balance64" type="double" />
            <field name="Balance63" type="double" />
            <field name="Balance62" type="double" />
            <field name="Balance61" type="double" />
            <field name="Balance60" type="double" />
            <field name="Balance59" type="double" />
            <field name="Balance58" type="double" />
            <field name="Balance57" type="double" />
            <field name="Balance56" type="double" />
            <field name="Balance55" type="double" />
            <field name="Balance54" type="double" />
            <field name="Balance53" type="double" />
            <field name="Balance52" type="double" />
            <field name="Balance51" type="double" />
            <field name="Balance50" type="double" />
            <field name="Balance49" type="double" />
            <field name="Balance48" type="double" />
            <field name="Balance47" type="double" />
            <field name="Balance46" type="double" />
            <field name="Balance45" type="double" />
            <field name="Balance44" type="double" />
            <field name="Balance43" type="double" />
            <field name="Balance42" type="double" />
            <field name="Balance41" type="double" />
            <field name="Balance40" type="double" />
            <field name="Balance39" type="double" />
            <field name="Balance38" type="double" />
            <field name="Balance37" type="double" />
            <field name="Balance36" type="double" />
            <field name="Balance35" type="double" />
            <field name="Balance34" type="double" />
            <field name="Balance33" type="double" />
            <field name="Balance32" type="double" />
            <field name="Balance31" type="double" />
            <field name="Balance30" type="double" />
            <field name="Balance29" type="double" />
            <field name="Balance28" type="double" />
            <field name="Balance27" type="double" />
            <field name="Balance26" type="double" />
            <field name="Balance25" type="double" />
            <field name="Balance24" type="double" />
            <field name="Balance23" type="double" />
            <field name="Balance22" type="double" />
            <field name="Balance21" type="double" />
            <field name="Balance20" type="double" />
            <field name="Balance19" type="double" />
            <field name="Balance18" type="double" />
            <field name="Balance17" type="double" />
            <field name="Balance16" type="double" />
            <field name="Balance15" type="double" />
            <field name="Balance14" type="double" />
            <field name="Balance13" type="double" />
            <field name="Balance12" type="double" />
            <field name="Balance11" type="double" />
            <field name="Balance10" type="double" />
            <field name="Balance09" type="double" />
            <field name="Balance08" type="double" />
            <field name="Balance07" type="double" />
            <field name="Balance06" type="double" />
            <field name="Balance05" type="double" />
            <field name="Balance04" type="double" />
            <field name="Balance03" type="double" />
            <field name="Balance02" type="double" />
            <field name="Balance01" type="double" />
            <field name="Balance00" type="double" />
            <field name="Budget29" type="double" />
            <field name="Budget28" type="double" />
            <field name="Budget27" type="double" />
            <field name="Budget26" type="double" />
            <field name="Budget25" type="double" />
            <field name="Budget24" type="double" />
            <field name="Budget23" type="double" />
            <field name="Budget22" type="double" />
            <field name="Budget21" type="double" />
            <field name="Budget20" type="double" />
            <field name="Budget19" type="double" />
            <field name="Budget18" type="double" />
            <field name="Budget17" type="double" />
            <field name="Budget16" type="double" />
            <field name="Budget15" type="double" />
            <field name="Budget14" type="double" />
            <field name="Budget13" type="double" />
            <field name="Budget12" type="double" />
            <field name="Budget11" type="double" />
            <field name="Budget10" type="double" />
            <field name="Budget09" type="double" />
            <field name="Budget08" type="double" />
            <field name="Budget07" type="double" />
            <field name="Budget06" type="double" />
            <field name="Budget05" type="double" />
            <field name="Budget04" type="double" />
            <field name="Budget03" type="double" />
            <field name="Budget02" type="double" />
            <field name="Budget01" type="double" />
            <field name="Budget00" type="double" />
            <field name="BudgetNext01" type="double" />
            <field name="BudgetNext02" type="double" />
            <field name="BudgetNext03" type="double" />
            <field name="BudgetNext04" type="double" />
            <field name="BudgetNext05" type="double" />
            <field name="BudgetNext06" type="double" />
            <field name="BudgetNext07" type="double" />
            <field name="BudgetNext08" type="double" />
            <field name="BudgetNext09" type="double" />
            <field name="BudgetNext10" type="double" />
            <field name="BudgetNext11" type="double" />
            <field name="BudgetNext12" type="double" />
            <field name="BudgetNext13" type="double" />
            <field name="BudgetNext14" type="double" />
            <field name="BudgetNext15" type="double" />
            <field name="BudgetNext16" type="double" />
            <field name="BudgetNext17" type="double" />
            <field name="BudgetNext18" type="double" />
            <field name="LinkedAccountU" type="string" size="14" />
            <field name="LinkedAccountR" type="string" size="14" />
            <field name="PreferredBankCR" type="string" size="8" />
            <field name="PreferredBankCP" type="string" size="8" />
        </fields>
    </table>
    <table>
        <file_num>26</file_num>
        <name>Filter</name>
        <fields>
            <field name="SequenceNumber" type="long" unsigned="true" />
            <field name="LastModifiedTime" type="time" unsigned="true" />
            <field name="File" type="short" />
            <field name="TabSet" type="short" />
            <field name="Tab" type="short" />
            <field name="Type" type="short" />
            <field name="User" type="string" size="4" />
            <field name="Name" type="string" size="32" />
            <field name="FilterFunction" type="string" size="256" />
            <field name="Order" type="short" />
        </fields>
    </table>
    <table>
        <file_num>27</file_num>
        <name>Stickies</name>
        <fields>
            <field name="SequenceNumber" type="long" unsigned="true" />
            <field name="LastModifiedTime" type="time" unsigned="true" />
            <field name="FileNum" type="short" indexed="true" />
            <field name="Colour" type="short" />
            <field name="User" type="string" size="4" />
            <field name="OwnerSeq" type="long" indexed="true" />
            <field name="Message" type="string" size="158" />
            <field name="Flags" type="short" />
        </fields>
    </table>
    <table>
        <file_num>28</file_num>
        <name>Lists</name>
        <fields>
            <field name="SequenceNumber" type="long" unsigned="true" />
            <field name="LastModifiedTime" type="time" unsigned="true" />
            <field name="ListID" type="string" size="16" indexed="true" />
            <field name="Item" type="string" size="16" indexed="true" />
            <field name="Comment" type="string" size="68" />
        </fields>
    </table>
    <table>
        <file_num>29</file_num>
        <name>Login</name>
        <fields>
            <field name="SequenceNumber" type="long" unsigned="true" />
            <field name="LastModifiedTime" type="time" unsigned="true" />
            <field name="Initials" type="string" size="4" indexed="true" />
            <field name="Name" type="string" size="32" />
            <field name="Password" type="string" size="34" />
            <field name="" type="string" size="158" />
            <field name="Privileges" type="string" size="66" />
            <field name="email" type="string" size="32" />
            <field name="Flags" type="short" />
            <field name="Category" type="string" size="8" />
            <field name="email_extra" type="string" size="14" />
        </fields>
    </table>
    <table>
        <file_num>30</file_num>
        <name>User2</name>
        <fields>
            <field name="SequenceNumber" type="long" unsigned="true" />
            <field name="LastModifiedTime" type="time" unsigned="true" />
            <field name="DevKey" type="long" unsigned="true" indexed="true" />
            <field name="Key" type="string" size="28" indexed="true" />
            <field name="Int1" type="long" />
            <field name="Int2" type="long" />
            <field name="Float1" type="double" />
            <field name="Float2" type="double" />
            <field name="Date1" type="date" unsigned="true" />
            <field name="Date2" type="date" unsigned="true" />
            <field name="Text1" type="string" size="20" />
            <field name="Text2" type="string" size="20" />
            <field name="Text" type="string" size="152" />
        </fields>
    </table>
</tables>
Posted in Database | Comments Off on Schema