True
Account Activities
AccountActivityID,System.Int32
AccountID,System.Int32
Amount,System.Double
FinancialYear,System.Int16
Period,System.Int16
Account Activities
MYOB DATA.Account Activities
Account Budgets
AccountBudgetID,System.Int32
AccountID,System.Int32
Amount,System.Double
FinancialYear,System.Int16
Period,System.Int16
Account Budgets
MYOB DATA.Account Budgets
Accounts
AccountantLinkCode,System.String
AccountClassificationID,System.String
AccountDescription,System.String
AccountID,System.Int32
AccountLevel,System.Int16
AccountName,System.String
AccountNumber,System.String
AccountTypeID,System.String
BankAccountName,System.String
BankAccountNumber,System.String
BankCode,System.String
BSBCode,System.String
CashFlowClassificationID,System.String
CompanyTradingName,System.String
CreateBankFiles,System.String
CurrencyExchangeAccountID,System.Int32
CurrencyID,System.Int32
CurrentAccountBalance,System.Double
DirectEntryUserID,System.String
IsCreditBalance,System.String
IsInactive,System.String
IsReconciled,System.String
IsSelfBalancing,System.String
IsTotal,System.String
LastChequeNumber,System.Int32
LastReconciledDate,System.DateTime
LastYearOpeningBalance,System.Double
OpeningAccountBalance,System.Double
ParentAccountID,System.Int32
PostThisYearActivity,System.Double
PreLastYearActivity,System.Double
StatementBalance,System.Double
StatementCode,System.String
StatementParticulars,System.String
StatementReference,System.String
SubAccountClassificationID,System.String
TaxCodeID,System.Int32
ThisYearOpeningBalance,System.Double
Accounts
MYOB DATA.Accounts
Address
AddressID,System.Int32
CardRecordID,System.Int32
ChangeControl,System.String
City,System.String
ContactName,System.String
Country,System.String
Email,System.String
Fax,System.String
Location,System.Int32
Phone1,System.String
Phone2,System.String
Phone3,System.String
Postcode,System.String
Salutation,System.String
State,System.String
Street,System.String
StreetLine1,System.String
StreetLine2,System.String
StreetLine3,System.String
StreetLine4,System.String
WWW,System.String
Address
MYOB DATA.Address
Audit Trail
AuditTrailID,System.Int32
AuditTypeID,System.String
ChangeDate,System.DateTime
Description,System.String
IsReconciled,System.String
OriginalDate,System.DateTime
TransactionNumber,System.String
UserID,System.Int32
WasThirteenthPeriod,System.String
Audit Trail
MYOB DATA.Audit Trail
Card Activities
CardActivityID,System.Int32
CardRecordID,System.Int32
DollarsSold,System.Double
FinancialYear,System.Int16
Period,System.Int16
Card Activities
MYOB DATA.Card Activities
Cards
CardIdentification,System.String
CardRecordID,System.Int32
CardTypeID,System.String
ChangeControl,System.String
CurrencyID,System.Int32
CustomField1,System.String
CustomField2,System.String
CustomField3,System.String
CustomList1ID,System.Int32
CustomList2ID,System.Int32
CustomList3ID,System.Int32
FirstName,System.String
IdentifierID,System.String
Identifiers,System.String
IsInactive,System.String
IsIndividual,System.String
LastName,System.String
Name,System.String
Notes,System.String
PaymentDeliveryID,System.String
Cards
MYOB DATA.Cards
Contact Log
CardRecordID,System.Int32
ChangeControl,System.String
Contact,System.String
ContactLogID,System.Int32
Date,System.DateTime
ElapsedTime,System.String
LogDate,System.DateTime
Notes,System.String
RecontactDate,System.DateTime
Contact Log
MYOB DATA.Contact Log
Customers
ABN,System.String
ABNBranch,System.String
CardIdentification,System.String
CardRecordID,System.Int32
ChangeControl,System.String
CreditLimit,System.Double
CurrencyID,System.Int32
CurrentBalance,System.Double
CustomerID,System.Int32
CustomerSince,System.DateTime
CustomField1,System.String
CustomField2,System.String
CustomField3,System.String
CustomList1ID,System.Int32
CustomList2ID,System.Int32
CustomList3ID,System.Int32
FirstName,System.String
FreightTaxCodeID,System.Int32
GSTIDNumber,System.String
HighestInvoiceAmount,System.Double
HighestReceivableAmount,System.Double
HourlyBillingRate,System.Double
IdentifierID,System.String
Identifiers,System.String
IncomeAccountID,System.Int32
InvoiceDeliveryID,System.String
IsInactive,System.String
IsIndividual,System.String
LastName,System.String
LastPaymentDate,System.DateTime
LastSaleDate,System.DateTime
MethodOfPaymentID,System.Int32
Name,System.String
Notes,System.String
OnHold,System.String
PaymentBankAccountName,System.String
PaymentBankAccountNumber,System.String
PaymentBankBranch,System.String
PaymentBSB,System.String
PaymentCardNumber,System.String
PaymentDeliveryID,System.String
PaymentExpirationDate,System.String
PaymentNameOnCard,System.String
PaymentNotes,System.String
Picture,System.String
PriceLevelID,System.String
PrintedForm,System.String
ReceiptMemo,System.String
SaleCommentID,System.Int32
SaleLayoutID,System.String
SalespersonID,System.Int32
ShippingMethodID,System.Int32
TaxCodeID,System.Int32
TaxIDNumber,System.String
TermsID,System.Int32
TotalDeposits,System.Double
TotalPaidInvoices,System.Int32
TotalReceivableDays,System.Int32
UseCustomerTaxCode,System.String
VolumeDiscount,System.Double
Customers
MYOB DATA.Customers
Data File Info
ABN,System.String
ABNBranch,System.String
ACN,System.String
Address,System.String
BankAccountName,System.String
BankAccountNumber,System.String
BankCode,System.String
BankID,System.String
BSBCode,System.String
ChangeControl,System.String
CompanyFileNumber,System.String
CompanyName,System.String
CompanyRegistrationNumber,System.String
ConversionDate,System.DateTime
CostCentresRequired,System.String
CurrentFinancialYear,System.Int16
DatabaseVersion,System.String
DataFileCountry,System.String
DefaultCustomerCreditLimit,System.Double
DefaultCustomerFreightTaxCodeID,System.Int32
DefaultCustomerPriceLevelID,System.String
DefaultCustomerTaxCodeID,System.Int32
DefaultCustomerTermsID,System.Int32
DefaultSupplierCreditLimit,System.Double
DefaultSupplierFreightTaxCodeID,System.Int32
DefaultSupplierTaxCodeID,System.Int32
DefaultSupplierTermsID,System.Int32
DefaultUseCustomerTaxCode,System.String
DefaultUseSupplierTaxCode,System.String
DriverBuildNumber,System.Int32
Email,System.String
FaxNumber,System.String
FirstAgeingPeriod,System.Int16
GSTRegistrationNumber,System.String
IdentifyAgeByName,System.String
IncludeInvoiceNumber,System.String
IncludeInvoiceOrderNumber,System.String
IncludeInvoiceQuoteNumber,System.String
IncludePurchaseNumber,System.String
IncludePurchaseOrderNumber,System.String
IncludePurchaseQuoteNumber,System.String
InvoiceMessage,System.String
InvoiceOrderMessage,System.String
InvoiceOrderSubject,System.String
InvoiceQuoteMessage,System.String
InvoiceQuoteSubject,System.String
InvoiceSubject,System.String
IsSelfBalancing,System.String
LastBackupDate,System.DateTime
LastMonthInFinancialYear,System.Int16
LastPurgeDate,System.DateTime
LimitTypeID,System.String
LockPeriodDate,System.DateTime
LockPeriodIsActive,System.String
LockThirteenthPeriod,System.String
PayeeNumber,System.String
PaymentMessage,System.String
PaymentSubject,System.String
PeriodsPerYear,System.Int16
Phone,System.String
PurchaseMessage,System.String
PurchaseOrderMessage,System.String
PurchaseOrderSubject,System.String
PurchaseQuoteMessage,System.String
PurchaseQuoteSubject,System.String
PurchaseSubject,System.String
SalesTaxNumber,System.String
SecondAgeingPeriod,System.Int16
SerialNumber,System.String
SimplifiedTaxSystemDate,System.DateTime
SmallBusinessEntityConcessionDate,System.DateTime
StatementCode,System.String
StatementMessage,System.String
StatementParticulars,System.String
StatementReference,System.String
StatementSubject,System.String
ThirdAgeingPeriod,System.Int16
UseAuditTracking,System.String
UseCostCentres,System.String
UseCreditLimitWarning,System.String
UseDailyAgeing,System.String
UseMultipleCurrencies,System.String
UsePayablesDeposits,System.String
UsePayablesDiscounts,System.String
UsePayablesFreight,System.String
UsePayablesInventory,System.String
UsePayablesLateFees,System.String
UseReceivablesDeposits,System.String
UseReceivablesDiscounts,System.String
UseReceivablesFreight,System.String
UseReceivablesLateFees,System.String
UseRetailManagerLink,System.String
UseSimplifiedTaxSystem,System.String
UseSmallBusinessEntityConcession,System.String
UseStandardCost,System.String
Data File Info
MYOB DATA.Data File Info
Employees
Bank1Value,System.Double
Bank1ValueTypeID,System.String
Bank2Value,System.Double
Bank2ValueTypeID,System.String
Bank3Value,System.Double
Bank3ValueTypeID,System.String
BankAccountName,System.String
BankAccountName2,System.String
BankAccountName3,System.String
BankAccountNumber,System.String
BankAccountNumber2,System.String
BankAccountNumber3,System.String
BasePay,System.Double
BSBCode,System.String
BSBCode2,System.String
BSBCode3,System.String
CardIdentification,System.String
CardRecordID,System.Int32
ChangeControl,System.String
CostCentreID,System.Int32
CurrencyID,System.Int32
CustomField1,System.String
CustomField2,System.String
CustomField3,System.String
CustomList1ID,System.Int32
CustomList2ID,System.Int32
CustomList3ID,System.Int32
DateOfBirth,System.DateTime
DefaultWagesID,System.Int32
EmployeeID,System.Int32
EmploymentBasisID,System.String
EmploymentCategoryID,System.String
EmploymentClassificationID,System.Int32
EmploymentStatusID,System.String
EstimatedCostPerHour,System.Double
ExtraTax,System.Double
FirstName,System.String
Gender,System.String
HourlyBillingRate,System.Double
HoursInPayPeriod,System.Double
IdentifierID,System.String
Identifiers,System.String
IsInactive,System.String
IsIndividual,System.String
IsPaidElectronically,System.String
LastName,System.String
Name,System.String
Notes,System.String
NumberBankAccounts,System.Int32
PayBasisID,System.String
PayFrequencyID,System.String
PaymentDeliveryID,System.String
PaymentTypeID,System.String
PaySlipDelType,System.String
PaySlipEmail,System.String
Picture,System.String
RecurringPayID,System.Int32
StartDate,System.DateTime
StatementText,System.String
SuperannuationFundID,System.Int32
SuperannuationMembershipNumber,System.String
TaxFileNumber,System.String
TaxScaleID,System.Int32
TerminatedBy,System.String
TerminationDate,System.DateTime
TerminationMethodID,System.String
TerminationReason,System.String
TotalRebates,System.Double
UseTimesheets,System.String
WagesExpenseAccountID,System.Int32
WithholdingVariationRate,System.Double
Employees
MYOB DATA.Employees
Invoice Delivery
Description,System.String
InvoiceDeliveryID,System.String
Invoice Delivery
MYOB DATA.Invoice Delivery
Invoice Type
Description,System.String
InvoiceTypeID,System.String
Invoice Type
MYOB DATA.Invoice Type
Item Purchases History
FinancialYear,System.Int16
ItemID,System.Int32
ItemPurchasesHistoryID,System.Int32
Period,System.Int16
PurchaseAmount,System.Double
UnitsBought,System.Double
Item Purchases History
MYOB DATA.Item Purchases History
Item Sales History
CostOfSalesAmount,System.Double
FinancialYear,System.Int16
ItemID,System.Int32
ItemSalesHistoryID,System.Int32
Period,System.Int16
SaleAmount,System.Double
UnitsSold,System.Double
Item Sales History
MYOB DATA.Item Sales History
Item Sales Line All
CostOfGoodsSoldAmount,System.Double
Description,System.String
Discount,System.Double
IsMultipleJob,System.String
ItemID,System.Int32
ItemSaleLineID,System.Int32
JobID,System.Int32
LineNumber,System.Int32
LineTypeID,System.String
LocationID,System.Int32
Quantity,System.Double
SaleID,System.Int32
SaleLineID,System.Int32
SalesTaxCalBasisID,System.String
TaxBasisAmount,System.Double
TaxBasisAmountIsInclusive,System.String
TaxCodeID,System.Int32
TaxExclusiveTotal,System.Double
TaxExclusiveUnitPrice,System.Double
TaxInclusiveTotal,System.Double
TaxInclusiveUnitPrice,System.Double
Item Sales Line All
MYOB DATA.Item Sales Line All
Items
BaseSellingPrice,System.Double
BuyTaxCodeID,System.Int32
BuyUnitMeasure,System.String
BuyUnitQuantity,System.Int16
ChangeControl,System.String
CustomField1,System.String
CustomField2,System.String
CustomField3,System.String
CustomList1ID,System.Int32
CustomList2ID,System.Int32
CustomList3ID,System.Int32
DefaultReceiveLocationID,System.Int32
DefaultReorderQuantity,System.Double
DefaultSellLocationID,System.Int32
ExpenseAccountID,System.Int32
IncomeAccountID,System.Int32
InventoryAccountID,System.Int32
IsInactive,System.String
ItemDescription,System.String
ItemID,System.Int32
ItemIsBought,System.String
ItemIsInventoried,System.String
ItemIsSold,System.String
ItemName,System.String
ItemNumber,System.String
LastUnitPrice,System.Double
MinLevelBeforeReorder,System.Double
NegativeAverageCost,System.Double
NegativeQuantityOnHand,System.Double
NegativeValueOnHand,System.String
Picture,System.String
PositiveAverageCost,System.Double
PriceIsInclusive,System.String
PrimarySupplierID,System.Int32
PurchaseOnOrder,System.Double
QuantityAvailable,System.Double
QuantityOnHand,System.Double
ReceivedOnOrder,System.Double
SalesTaxCalcBasisID,System.String
SellOnOrder,System.Double
SellTaxCodeID,System.Int32
SellUnitMeasure,System.String
SellUnitQuantity,System.Int16
SupplierItemNumber,System.String
TaxExclusiveLastPurchasePrice,System.Double
TaxExclusiveStandardCost,System.Double
TaxInclusiveLastPurchasePrice,System.Double
TaxInclusiveStandardCost,System.Double
UseDescription,System.String
ValueOnHand,System.Double
Items
MYOB DATA.Items
Job Accounts
AccountID,System.Int32
CurrentBalance,System.Double
JobAccountID,System.Int32
JobID,System.Int32
LastYearOpeningBalance,System.Double
OpeningBalance,System.Double
PostThisYearActivity,System.Double
PreLastYearActivity,System.Double
ThisYearOpeningBalance,System.Double
Job Accounts
MYOB DATA.Job Accounts
Job Budgets
AccountID,System.Int32
Amount,System.Double
JobBudgetID,System.Int32
JobID,System.Int32
Job Budgets
MYOB DATA.Job Budgets
Jobs
ContactName,System.String
CustomerID,System.Int32
FinishDate,System.DateTime
IsHeader,System.String
IsInactive,System.String
IsTrackingReimburseable,System.String
JobDescription,System.String
JobID,System.Int32
JobLevel,System.Int16
JobName,System.String
JobNumber,System.String
Manager,System.String
ParentJobID,System.Int32
PercentCompleted,System.Double
StartDate,System.DateTime
Jobs
MYOB DATA.Jobs
Locations
CanBeSold,System.String
City,System.String
Contact,System.String
ContactPhone,System.String
Country,System.String
IsInactive,System.String
LocationID,System.Int32
LocationIdentification,System.String
LocationName,System.String
Notes,System.String
PostCode,System.String
State,System.String
Street,System.String
Locations
MYOB DATA.Locations
Money Spent
CardRecordID,System.Int32
ChequeNumber,System.String
CostCentreID,System.Int32
CurrencyID,System.Int32
Date,System.DateTime
IsAutoRecorded,System.String
IsPrinted,System.String
IssuingAccountID,System.Int32
IsTaxInclusive,System.String
IsThirteenthPeriod,System.String
Memo,System.String
MoneySpentID,System.Int32
Payee,System.String
PayeeLine1,System.String
PayeeLine2,System.String
PayeeLine3,System.String
PayeeLine4,System.String
PaymentDeliveryID,System.String
PaymentStatusID,System.String
StatementText,System.String
TotalSpentAmount,System.Double
TransactionDate,System.DateTime
TransactionExchangeRate,System.Double
Money Spent
MYOB DATA.Money Spent
Money Spent Lines
AccountID,System.Int32
IsMultipleJob,System.String
JobID,System.Int32
LineMemo,System.String
LineNumber,System.Int32
MoneySpentID,System.Int32
MoneySpentLineID,System.Int32
TaxCodeID,System.Int32
TaxExclusiveAmount,System.Double
TaxInclusiveAmount,System.Double
Money Spent Lines
MYOB DATA.Money Spent Lines
Order Status
Description,System.String
OrderStatusID,System.String
Order Status
MYOB DATA.Order Status
Payment Methods
MethodType,System.String
PaymentMethod,System.String
PaymentMethodID,System.Int32
Payment Methods
MYOB DATA.Payment Methods
Personal Cards
CardIdentification,System.String
CardRecordID,System.Int32
ChangeControl,System.String
CurrencyID,System.Int32
CustomField1,System.String
CustomField2,System.String
CustomField3,System.String
CustomList1ID,System.Int32
CustomList2ID,System.Int32
CustomList3ID,System.Int32
FirstName,System.String
IdentifierID,System.String
Identifiers,System.String
IsInactive,System.String
IsIndividual,System.String
LastName,System.String
Name,System.String
Notes,System.String
PaymentDeliveryID,System.String
PersonalCardID,System.Int32
Picture,System.String
Personal Cards
MYOB DATA.Personal Cards
Purchases
BackorderPurchaseID,System.Int32
CardRecordID,System.Int32
Comment,System.String
CostCentreID,System.Int32
CurrencyID,System.Int32
Date,System.DateTime
DaysTillPaid,System.Int16
FreightTaxCodeID,System.Int32
InvoiceDeliveryID,System.String
IsAutoRecorded,System.String
IsHistorical,System.String
IsPrinted,System.String
IsTaxInclusive,System.String
IsThirteenthPeriod,System.String
LinesPurged,System.String
Memo,System.String
OrderStatusID,System.String
OutstandingBalance,System.Double
PreAuditTrail,System.String
PromisedDate,System.DateTime
PurchaseDate,System.DateTime
PurchaseID,System.Int32
PurchaseNumber,System.String
PurchaseStatusID,System.String
PurchaseTypeID,System.String
ReversalLinkID,System.Int32
ShippingMethodID,System.Int32
ShipToAddress,System.String
ShipToAddressLine1,System.String
ShipToAddressLine2,System.String
ShipToAddressLine3,System.String
ShipToAddressLine4,System.String
ShipToAddressLine5,System.String
ShipToAddressLine6,System.String
SupplierInvoiceNumber,System.String
TaxExclusiveFreight,System.Double
TaxInclusiveFreight,System.Double
TermsID,System.Int32
TotalDebits,System.Double
TotalDeposits,System.Double
TotalDiscounts,System.Double
TotalLines,System.Double
TotalPaid,System.Double
TotalTax,System.Double
TransactionExchangeRate,System.Double
Purchases
MYOB DATA.Purchases
Purchases History
CardRecordID,System.Int32
FinancialYear,System.Int16
Period,System.Int16
PurchaseAmount,System.Double
PurchasesHistoryID,System.Int32
Purchases History
MYOB DATA.Purchases History
Sale Lines
Description,System.String
IsMultipleJob,System.String
JobID,System.Int32
LineNumber,System.Int32
LineTypeID,System.String
SaleID,System.Int32
SaleLineID,System.Int32
TaxBasisAmount,System.Double
TaxBasisAmountIsInclusive,System.String
TaxCodeID,System.Int32
TaxExclusiveAmount,System.Double
TaxInclusiveAmount,System.Double
Sale Lines
MYOB DATA.Sale Lines
Sale Lines All
Description,System.String
IsMultipleJob,System.String
JobID,System.Int32
LineNumber,System.Int32
LineTypeID,System.String
SaleID,System.Int32
SaleLineID,System.Int32
TaxBasisAmount,System.Double
TaxBasisAmountIsInclusive,System.String
TaxCodeID,System.Int32
TaxExclusiveAmount,System.Double
TaxInclusiveAmount,System.Double
Sale Lines All
MYOB DATA.Sale Lines All
Sales
BackorderSaleID,System.Int32
CardRecordID,System.Int32
Comment,System.String
CostCentreID,System.Int32
CurrencyID,System.Int32
CustomerPONumber,System.String
Date,System.DateTime
DaysTillPaid,System.Int16
FreightTaxCodeID,System.Int32
InvoiceDate,System.DateTime
InvoiceDeliveryID,System.String
InvoiceNumber,System.String
InvoiceStatusID,System.String
InvoiceTypeID,System.String
IsAutoRecorded,System.String
IsHistorical,System.String
IsPrinted,System.String
IsTaxInclusive,System.String
IsThirteenthPeriod,System.String
LinesPurged,System.String
Memo,System.String
OutstandingBalance,System.Double
PreAuditTrail,System.String
PromisedDate,System.DateTime
ReferralSourceID,System.Int32
SaleID,System.Int32
SalesPersonID,System.Int32
ShippingMethodID,System.Int32
ShipToAddress,System.String
ShipToAddressLine1,System.String
ShipToAddressLine2,System.String
ShipToAddressLine3,System.String
ShipToAddressLine4,System.String
ShipToAddressLine5,System.String
ShipToAddressLine6,System.String
TaxExclusiveFreight,System.Double
TaxInclusiveFreight,System.Double
TermsID,System.Int32
TotalCredits,System.Double
TotalDeposits,System.Double
TotalDiscounts,System.Double
TotalLines,System.Double
TotalPaid,System.Double
TotalTax,System.Double
TransactionExchangeRate,System.Double
Sales
MYOB DATA.Sales
Sales History
CardRecordID,System.Int32
FinancialYear,System.Int16
Period,System.Int16
SaleAmount,System.Double
SalesHistoryID,System.Int32
Sales History
MYOB DATA.Sales History
Service Sale Lines
AccountID,System.Int32
Description,System.String
IsMultipleJob,System.String
JobID,System.Int32
LineNumber,System.Int32
LineTypeID,System.String
SaleID,System.Int32
SaleLineID,System.Int32
ServiceSaleLineID,System.Int32
TaxBasisAmount,System.Double
TaxBasisAmountIsInclusive,System.String
TaxCodeID,System.Int32
TaxExclusiveAmount,System.Double
TaxInclusiveAmount,System.Double
Service Sale Lines
MYOB DATA.Service Sale Lines
Service Sale Lines All
AccountID,System.Int32
Description,System.String
IsMultipleJob,System.String
JobID,System.Int32
LineNumber,System.Int32
LineTypeID,System.String
SaleID,System.Int32
SaleLineID,System.Int32
ServiceSaleLineID,System.Int32
TaxBasisAmount,System.Double
TaxBasisAmountIsInclusive,System.String
TaxCodeID,System.Int32
TaxExclusiveAmount,System.Double
TaxInclusiveAmount,System.Double
Service Sale Lines All
MYOB DATA.Service Sale Lines All
Suppliers
ABN,System.String
ABNBranch,System.String
BankAccountName,System.String
BankAccountNumber,System.String
BSBCode,System.String
CardIdentification,System.String
CardRecordID,System.Int32
ChangeControl,System.String
CreditLimit,System.Double
CurrencyID,System.Int32
CurrentBalance,System.Double
CustomField1,System.String
CustomField2,System.String
CustomField3,System.String
CustomList1ID,System.Int32
CustomList2ID,System.Int32
CustomList3ID,System.Int32
EstimatedCostPerHour,System.Double
ExpenseAccountID,System.Int32
FirstName,System.String
FreightTaxCodeID,System.Int32
HighestPayableAmount,System.Double
HighestPurchaseAmount,System.Double
HourlyBillingRate,System.Double
IdentifierID,System.String
Identifiers,System.String
InvoiceDeliveryID,System.String
IsInactive,System.String
IsIndividual,System.String
IsPaidElectronically,System.String
LastName,System.String
LastPaymentDate,System.DateTime
LastPuchaseDate,System.DateTime
MethodOfPaymentID,System.Int32
Name,System.String
Notes,System.String
PaymentBankAccountName,System.String
PaymentBankAccountNumber,System.String
PaymentBSB,System.String
PaymentCardNumber,System.String
PaymentDeliveryID,System.String
PaymentExpirationDate,System.String
PaymentMemo,System.String
PaymentNameOnCard,System.String
PaymentNotes,System.String
Picture,System.String
PrintedForm,System.String
PurchaseCommentID,System.Int32
PurchaseLayoutID,System.String
ShippingMethodID,System.Int32
SupplierID,System.Int32
SupplierSince,System.DateTime
TaxCodeID,System.Int32
TaxIDNumber,System.String
TermsID,System.Int32
TotalDeposits,System.Double
TotalPaidPurchases,System.Int32
TotalPayableDays,System.Int32
UseSupplierTaxCode,System.String
VolumeDiscount,System.Double
Suppliers
MYOB DATA.Suppliers
Terms
BalanceDueDate,System.String
BalanceDueDays,System.Int16
DiscountDate,System.String
DiscountDays,System.Int16
EarlyPaymentDiscountPercent,System.Double
ImportPaymentIsDue,System.Int32
LatePaymentChargePercent,System.Double
TermsID,System.Int32
TermsOfPaymentID,System.String
Terms
MYOB DATA.Terms
Users
BillingUnit,System.Int16
IncludeItemsInTimeBilling,System.String
MinuteIncrement,System.Int16
RoundCalculatedTime,System.String
RoundToID,System.String
UseBillingUnits,System.String
UserID,System.Int32
UserName,System.String
UseTimeslipsLink,System.String
Users
MYOB DATA.Users
Invoice Delivery
PaymentDeliveryID
Invoice Delivery
PayDelivery
InvoiceDeliveryID
Cards
CustomerID
Cards
CustomerRecord
CardRecordID
Terms
TermsID
Terms
CustomerTerms
TermsID
Invoice Delivery
InvoiceDeliveryID
Invoice Delivery
CustomerDelivery
InvoiceDeliveryID
Invoice Delivery
PaymentDeliveryID
Invoice Delivery_2
CustomerPayDelivery
InvoiceDeliveryID
Invoice Delivery
PaymentDeliveryID
Invoice Delivery
EmployeeDelivery
InvoiceDeliveryID
Invoice Delivery
PaySlipDelType
Invoice Delivery_2
EmployeePayDelivery
InvoiceDeliveryID
Terms
TermsID
Terms
SupplierTerms
TermsID
Invoice Delivery
PaymentDeliveryID
Invoice Delivery
SupplierPayDelivery
InvoiceDeliveryID
Invoice Delivery
InvoiceDeliveryID
Invoice Delivery_2
SupplierDelivery
InvoiceDeliveryID
Cards
CardRecordID
Cards
CardsAddress
CardRecordID
Invoice Type
InvoiceTypeID
Invoice Type
Invoice Type
InvoiceTypeID
Customers
CardRecordID
Customers
CustomersSales
CardRecordID
Invoice Delivery
InvoiceDeliveryID
Invoice Delivery
InvDelivery
InvoiceDeliveryID
Customers
CardRecordID
Customers
SalesHistory
CustomerID
Sales
SaleID
Sales
SaleLines
SaleID
Jobs
JobID
Jobs
ClientJob
JobID
Order Status
OrderStatusID
Order Status
OrderStatus
OrderStatusID
Invoice Delivery
InvoiceDeliveryID
Invoice Delivery
PODelivery
InvoiceDeliveryID
Suppliers
CardRecordID
Suppliers
PurchaseHistory
CardRecordID
Items
ItemID
Items
SalesItems
ItemID
Items
ItemID
Items
PurchaseItems
ItemID
Accounts
AccountID
Accounts
AccActivity
AccountID
Accounts
AccountID
Accounts
AccBudgets
AccountID
Sales
SaleID
Sales
SaleLinesAll
SaleID
Jobs
JobID
Jobs
SaleJobLine
JobID
Sales
SaleID
Sales
ServiceSaleLinesAll
SaleID
Accounts
AccountID
Accounts
ServiceSaleLinesAllAccount
AccountID
Sale Lines
SaleLineID
Sale Lines
ServiceSaleLineID
SaleLineID
Sales
SaleID
Sales
ServiceSaleLines
SaleID
Accounts
AccountID
Accounts
ServiceSaleAccount
AccountID
Sale Lines
SaleLineID
Sale Lines
SalesLine
SaleLineID
Customers
CustomerID
Customers
ClientJobs
CustomerID
Jobs
JobID
Jobs
JobsAccounts
JobID
Accounts
AccountID
Accounts
JobBudgetAccounts
AccountID
Jobs
JobID
Jobs
JobsBudgets
JobID
Accounts
AccountID
Accounts
JobsAccountsAccounts
AccountID
Cards
CardRecordID
Cards
CardActivity
CardRecordID
Cards
CardRecordID
Cards
ContactLogs
CardRecordID
Users
UserID
Users
AuditTrail
UserID
Money Spent
MoneySpentID
Money Spent
MoneySpentLines
MoneySpentID
Sales
SaleID
Sales
SalesSalesLine
SaleID
Sale Lines
SaleLineID
Sale Lines
SalesLine2
SaleLineID
Jobs
JobID
Jobs
SaleJob
JobID
SaleJobLine
JobID
SaleJobLine
SaleJobLine
JobID
EngineV2
DoublePass
Control
Control
264,-144,104,24
Microsoft Sans Serif,8
Black
a1e65aabe3004dc298ebcd1b15dc6953
264, -144
LabelControl1
104, 24
Client Name
StiFilter userFilter = new StiFilter("{Sales.CardRecordID == " + cboClientName.SelectedItem + "}");
DataSales.Filters.Add(userFilter);
272,288,96,24
True
OK
Microsoft Sans Serif,8
Black
272, 288
btnOK
96, 24
Preview
272,320,96,24
Cancel
Microsoft Sans Serif,8
Black
272, 320
btnCancel
96, 24
Cancel
Control
8,80,360,184
Window
144,48,184,20
DropDownList
Microsoft Sans Serif,8
Black
Customers.Name
144, 48
cboClientName
Customers.CardRecordID
Sales.CustomersSales.CardRecordID
184, 20
True
Customers.Name
Control
16,48,120,24
Microsoft Sans Serif,8
Black
16, 48
lblFilterBy
120, 24
Customer Name:
MiddleRight
Control
16,80,120,24
Microsoft Sans Serif,8
Black
08e49bbab5e546f7b9ad09c2efbd228e
16, 80
LabelControl2
120, 24
Invoice Date From:
MiddleRight
Control
16,112,120,24
Microsoft Sans Serif,8
Black
d3da771ec8894105a6d0c2894673f153
16, 112
LabelControl3
120, 24
Invoice Date To:
MiddleRight
Control
16,144,120,24
Microsoft Sans Serif,8
Black
ee7b9f6e4e784d479858a3de90362362
16, 144
LabelControl4
120, 24
Job Number:
MiddleRight
Window
144,80,184,20
dd/MM/yyyy
Microsoft Sans Serif,8
Black
Custom
144, 80
12/31/9998 12:00:00 AM
1/1/1753 12:00:00 AM
dtpDateFrom
184, 20
1/1/0001 12:00:00 AM
Window
144,112,184,20
Microsoft Sans Serif,8
Black
Custom
4ad7f68707b1466881e294d1b5be2cbe
144, 112
12/31/9998 12:00:00 AM
1/1/1753 12:00:00 AM
dtpDateTo
184, 20
5/20/2010 12:00:00 AM
Window
144,144,184,20
DropDownList
Microsoft Sans Serif,8
Black
Jobs.JobNumber
144, 144
cboJobNumber
Jobs.JobID
184, 20
True
Control
144,16,208,24
Microsoft Sans Serif,8
Black
144, 16
rbGST
208, 24
Print Report with Tax Inclusive Figures
Microsoft Sans Serif,8
Black
8, 80
GroupBoxControl2
360, 184
Filter By
< Ref="98" type="Stimulsoft.Report.Dialogs.StiGroupBoxControl" isKey="true">
Control
8,16,360,48
Control
64,16,280,20
Microsoft Sans Serif,8
Black
64, 16
True
TextBoxControl1
280, 20
ReportName
Microsoft Sans Serif,8
Black
8, 16
360, 48
Report Name
Microsoft Sans Serif,8
867bdbc3d6794a29921a2e2516938808
0, 0
Form1
456, 384
Sorting Data
None;Black;2;Solid;False;4;Black
Transparent
Transparent
0,0.4,19,1.4
None;[250:206:170];1;Solid;False;4;Black
Transparent
6.4,0,8.6,0.6
Arial,11,Bold
0,0,0,0
Text9
{Data_File_Info.CompanyName}
[87:118:157]
None;[250:206:170];1;Solid;False;4;Black
Transparent
2.8,0.8,6.8,0.6
Arial,12,Bold
Right
0,0,0,0
Text24
{ReportName}
[23:54:93]
SystemVariables
None;[250:206:170];1;Solid;False;4;Black
Transparent
9.8,0.8,3.8,0.6
Arial,12,Bold
0,0,0,0
Text25
{rbGST.Checked?"(Inc GST)":"(Ex GST)"}
[23:54:93]
Expression
PageHeaderBand1
Top;Black;1;Solid;False;4;Black
Transparent
0,26.5,19,1.2
None;[250:206:170];1;Solid;False;4;Black
Transparent
16.2,0.1,2.8,0.6
Arial,8,Bold
Right
0,0,0,0
Text11
Page {PageNumber}
Black
None;[250:206:170];1;Solid;False;4;Black
Transparent
0,0.1,3.2,0.6
Arial,8,Bold
0,0,0,0
Text13
Printed on {Today}
Black
PageFooterBand1
Transparent
0,2.6,19,1.8
None;[250:206:170];1;Solid;False;4;Black
Transparent
4.6,0,4,0.6
Arial,8,Bold
0,0,0,0
Text15
{cboClientName.Text}
[23:54:93]
Expression
None;[250:206:170];1;Solid;False;4;Black
Transparent
2,0,2.4,0.6
Arial,8,Bold
Right
0,0,0,0
Text16
Client Name:
[23:54:93]
Expression
None;[250:206:170];1;Solid;False;4;Black
Transparent
13.8,0,2.4,0.6
Arial,8,Bold
63b203fe2541476a8068ff19a942236d
Right
0,0,0,0
Text17
Job Number:
[23:54:93]
Expression
None;[250:206:170];1;Solid;False;4;Black
Transparent
16.4,0,2.6,0.6
Arial,8,Bold
21e0a053fe6e4833ab319ff06c7ecb4b
0,0,0,0
Text18
{cboJobNumber.Text}
[23:54:93]
Expression
None;[250:206:170];1;Solid;False;4;Black
Transparent
1.6,0.6,2.8,0.6
Arial,8,Bold
5a14502e3316438a8deab7614d36aa1a
Right
0,0,0,0
Text19
Invoice Date From:
[23:54:93]
Expression
None;[250:206:170];1;Solid;False;4;Black
Transparent
1.6,1.2,2.8,0.6
Arial,8,Bold
4dbe46fc582c4c21853c079ff7705464
Right
0,0,0,0
Text20
Invoice Date To:
[23:54:93]
Expression
None;[250:206:170];1;Solid;False;4;Black
Transparent
13.8,0.6,2.4,0.6
Arial,8,Bold
e11c4c18024242298617e2a795c93ff5
Right
0,0,0,0
Text21
Project Number:
[23:54:93]
Expression
None;[250:206:170];1;Solid;False;4;Black
Transparent
4.6,0.6,3.4,0.6
Arial,8,Bold
5de30f2f21414966a0e3a119db82b778
0,0,0,0
Text22
{dtpDateFrom.Value}
[23:54:93]
Expression
None;[250:206:170];1;Solid;False;4;Black
Transparent
4.6,1.2,3.4,0.6
Arial,8,Bold
6fd2e02d696141a4bdc8a04736b18b65
0,0,0,0
Text23
{dtpDateTo.Value}
[23:54:93]
Expression
ReportTitleBand1
Transparent
0,5.2,19,0.6
GroupHeaderBand1
Bottom;[23:54:93];1;Solid;False;4;Black
Transparent
0,6.6,19,1
Transparent
0,0,5.2,0.8
Arial,10,Bold
0,0,0,0
HeaderSale_Lines_JobID
Client / Invoice Number
[23:54:93]
HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,
Center
Transparent
12.6,0,3.4,0.8
Arial,10,Bold
0,0,0,0
HeaderSale_Lines_Description
Job Description
[23:54:93]
HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,
Center
Transparent
16,0,3,0.8
Arial,10,Bold
Right
0,0,0,0
HeaderSale_Lines_TaxInclusiveAmount
Invoice Amount
[23:54:93]
HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,
Center
Transparent
10.2,0,2.4,0.8
Arial,10,Bold
7cfa8537ecda460d98b4a3ca403c3639
0,0,0,0
Text2
Job Number
[23:54:93]
HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,
Center
Transparent
7.8,0,2.4,0.8
Arial,10,Bold
16f6d0cd923745c294eda1113fcda4cd
0,0,0,0
Text5
Invoice Type
[23:54:93]
HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,
Center
Transparent
5.4,0,2.4,0.8
Arial,10,Bold
09a3e54ad1284d269f6672f17f9519c1
0,0,0,0
Text8
Invoice Date
[23:54:93]
HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,
Center
HeaderSale_Lines
EmptyBrush
0,8.4,19,1.6
None;[250:206:170];1;Solid;False;4;Black
Transparent
0,0.2,5.2,0.6
Arial,10,Bold
0,0,0,0
Text3
{Sales.Customers.Name}
Black
Transparent
True
0,0.8,2.8,0.8
Arial,8
1804de2bce014ee5b6aa712d9962f195
0,0,0,0
DataSales_InvoiceNumber
{Sales.InvoiceNumber}
Black
HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,
Center
None;[250:206:170];1;Solid;False;4;Black
Transparent
16.2,0.2,2.8,0.6
Arial,8
Right
0,0,0,0
Text1
{rbGST.Checked?Sale_Lines_All.TaxInclusiveAmount:Sale_Lines_All.TaxExclusiveAmount}
Black
,
0
0
Expression
None;[250:206:170];1;Solid;False;4;Black
Transparent
5.4,0.2,2.4,0.6
Arial,8
0,0,0,0
Text6
{Sales.InvoiceDate}
Black
Transparent
10,0.2,2.4,0.6
Arial,8
Right
0,0,0,0
Text14
{Sale_Lines_All.SaleJobLine.JobNumber}
Black
Expression
None;[250:206:170];1;Solid;False;4;Black
Transparent
8.2,0.2,1.6,0.6
Arial,8
0,0,0,0
Text4
{Sales.Invoice_Type.Description}
Black
None;[250:206:170];1;Solid;False;4;Black
Transparent
12.6,0.2,3.4,0.6
Arial,8
0,0,0,0
Text7
{Sale_Lines_All.SaleJobLine.JobName}
Black
Sales
DataSales
Style1
ASC
CustomersSales
Name
ASC
InvoiceNumber
ASC
InvoiceDate
Top, Bottom;Black;1;Solid;False;4;Black
Transparent
0,10.8,19,0.8
None;[250:206:170];1;Solid;False;4;Black
Transparent
0,0.2,4.2,0.6
Arial,11,Bold
0,0,0,0
Text12
Report Totals
Black
None;[250:206:170];1;Solid;False;4;Black
Transparent
16.4,0,2.6,0.6
Arial,12,Bold
Right
0,0,0,0
Text10
{rbGST.Checked?Sum(DataSale_Lines_All,Sale_Lines_All.TaxInclusiveAmount):Sum(DataSale_Lines_All,Sale_Lines_All.TaxExclusiveAmount)}
Black
,
0
0
Expression
GroupFooterBand1
Transparent
True
0,12.4,19,0
SaleLinesAll
Sale Lines All
Style1
DataSale Lines All
Style1
Transparent
0,13.2,19,0.2
ReportSummaryBand1
9a25fbf8eb2c487588ed676e10f3393a
1,1,1,1
Page1
29.7
21
Arial,100
[50:0:0:0]
System.Dll
System.Drawing.Dll
System.Windows.Forms.Dll
System.Data.Dll
System.Xml.Dll
Stimulsoft.Controls.Dll
Stimulsoft.Base.Dll
Stimulsoft.Report.Dll
Invoices By Client
6/6/2010 12:59:10 PM
5/28/2010 7:02:08 PM
E:\Projects\KC Report Writer v2.04\KC Report Writer v2.04\bin\Debug\Reports\Invoices By Client.mrt
fcf0bbcd84a94e50ab94f71d33190b9b
Invoices By Client
Centimeters
2010.2.727
CSharp
Bisque
Arial,8
Style1
Black