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>