Explore the MYOB Acumatica (Advanced) API data model

Pulling data from the MYOB Acumatica (Advanced) API is only the first part of your reporting. You also need to understand the relationships between different endpoints - something that APIs typically fail to convey.

At SYNCHUB, we not only sync your MYOB API endpoints down into a reportable format, we also describe their relationships (e.g. in terms of foreign keys) so that you can quickly get a grasp of your data and how it fits together. This page is intended as technical documentation of these relationships.

Browse the data model below, or if you'd prefer, we also have an interactive ERD over here.

Account

Column	Type	Relates to	Notes
RemoteID	string	-	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ID	string	-	-
Description	string	-	-
AccountCD	string	-	-
AccountClass	string	-	-
AccountGroup	string	-	-
CurrencyID	string	Customer → RemoteID	-
AccountID	int	-	-
ChartOfAccountsOrder	int	-	-
CashAccount	boolean	-	-
Active	boolean	-	-
ConsolidationAccount	string	-	-
PostOption	string	-	-
RequireUnits	boolean	-	-
RevaluationRateType	string	-	-
Secured	boolean	-	-
UseDefaultSubaccount	boolean	-	-
TaxCategory	string	-	-
Type	string	-	-
CreatedDateTime	datetime	-	-
LastModifiedDateTime	datetime	-	-
RowNumber	int	-	-
Note	string	-	-

AttributeDefinition

Column	Type	Relates to	Notes
RemoteID	string	-	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ID	string	-	-
Description	string	-	-
AttributeID	string	-	-
ControlType	string	-	-
EntryMask	string	-	-
RegExp	string	-	-
Internal	boolean	-	-
CreatedDateTime	datetime	-	-
LastModifiedDateTime	datetime	-	-
RowNumber	int	-	-
Note	string	-	-

Bill

Column	Type	Relates to	Notes
RemoteID	string	-	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ID	string	-	-
Description	string	-	-
ReferenceNbr	string	-	-
Amount	decimal	-	-
ApprovedForPayment	boolean	-	-
Balance	decimal	-	-
CashAccount	string	-	-
CurrencyID	string	-	-
Date	datetime	-	-
DueDate	datetime	-	-
Hold	boolean	-	-
PostPeriod	string	-	-
Status	string	-	-
TaxTotal	decimal	-	-
Terms	string	-	-
Type	string	-	-
Vendor	string	-	-
VendorRef	string	-	-
CreatedDateTime	datetime	-	-
LastModifiedDateTime	datetime	-	-
RowNumber	int	-	-
Note	string	-	-

Branch

Column	Type	Relates to	Notes
RemoteID	string	-	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ID	string	-	-
BranchCD	string	-	-
LedgerCD	string	-	-
OrganizationCD	string	-	-
Note	string	-	-
AcctName	string	-	-
CreatedDateTime	datetime	-	-
LastModifiedDateTime	datetime	-	-
RowNumber	int	-	-

BusinessAccount

Column	Type	Relates to	Notes
RemoteID	string	-	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ID	string	-	-
Name	string	-	-
BusinessAccountID	string	-	-
AccountRef	string	-	-
Duplicate	string	-	-
OwnerEmployeeName	string	-	-
EnableCurrencyOverride	boolean	-	-
OverrideSalesTerritory	boolean	-	-
MainAddressValidated	boolean	-	-
LastIncomingActivity	datetime	-	-
LastOutgoingActivity	datetime	-	-
NoteID	guid	-	-
Owner	int	-	-
ClassID	string	-	-
SourceCampaign	string	-	-
CurrencyID	string	Currency → CurrencyID	-
Status	string	-	-
Type	string	-	-
CreatedDateTime	datetime	-	-
LastModifiedDateTime	datetime	-	-
RowNumber	int	-	-
Note	string	-	-

Contact

Column	Type	Relates to	Notes
RemoteID	string	-	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ID	string	-	-
ContactID	long	-	-
DateOfBirth	datetime	-	-
Status	string	-	-
CompanyName	string	-	-
DisplayName	string	-	-
BusinessAccount	string	-	-
ContactMethod	string	-	-
Email	string	-	-
Fax	string	-	-
FaxType	string	-	-
FirstName	string	-	-
Gender	string	-	-
JobTitle	string	-	-
Image	string	-	-
LanguageOrLocale	string	-	-
LastIncomingActivity	datetime	-	-
LastName	string	-	-
LastOutgoingActivity	datetime	-	-
MaritalStatus	string	-	-
MiddleName	string	-	-
Owner	string	-	-
OwnerEmployeeName	string	-	-
ParentAccount	string	-	-
Phone1	string	-	-
Phone1Type	string	-	-
Phone2Type	string	-	-
Phone2	string	-	-
Phone3Type	string	-	-
Phone3	string	-	-
SpouseOrPartnerName	string	-	-
Title	string	-	-
Type	string	-	-
WebSite	string	-	-
WorkgroupDescription	string	-	-
Workgroup	string	-	-
Active	boolean	-	-
Synchronize	boolean	-	-
OverrideAccountAddress	boolean	-	-
DuplicateFound	boolean	-	-
CreatedDateTime	datetime	-	-
LastModifiedDateTime	datetime	-	-
RowNumber	int	-	-
Note	string	-	-

Currency

Column	Type	Relates to	Notes
RemoteID	string	-	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ID	string	-	-
Description	string	-	-
CurrencyID	string	-	-
CurrencySymbol	string	-	-
EntryMask	string	-	-
Active	boolean	-	-
UseForAccounting	boolean	-	-
DecimalPrecision	decimal	-	-
CreatedDateTime	datetime	-	-
LastModifiedDateTime	datetime	-	-
RowNumber	int	-	-
Note	string	-	-

Customer

Column	Type	Relates to	Notes
RemoteID	string	-	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ID	string	-	-
CustomerID	string	-	-
Status	string	-	-
WarehouseID	string	-	-
ApplyOverdueCharges	boolean	-	-
AutoApplyPayments	boolean	-	-
BillingAddressOverride	boolean	-	-
BillingContactOverride	boolean	-	-
PrintDunningLetters	boolean	-	-
PrintInvoices	boolean	-	-
PrintStatements	boolean	-	-
ResidentialDelivery	boolean	-	-
SaturdayDelivery	boolean	-	-
SendDunningLettersbyEmail	boolean	-	-
SendInvoicesbyEmail	boolean	-	-
SendStatementsbyEmail	boolean	-	-
ShippingRule	string	-	-
AccountRef	string	-	-
StatementCycleID	string	-	-
StatementType	string	-	-
BAccountID	long	-	-
CurrencyID	string	Currency → RemoteID	-
CreditLimit	decimal	-	-
CurrencyRateType	string	-	-
CustomerClass	string	-	-
OrderPriority	int	-	-
MainContactID	long	Contact → ContactID	-
BillingContactID	long	Contact → ContactID	-
PrimaryContactID	long	Contact → ContactID	-
ShippingContactID	long	Contact → ContactID	-
CreatedDateTime	datetime	-	-
LastModifiedDateTime	datetime	-	-
RowNumber	int	-	-
Note	string	-	-

CustomerLocation

Column	Type	Relates to	Notes
RemoteID	string	-	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ID	string	-	-
LocationID	string	-	-
Active	boolean	-	-
AddressOverride	boolean	-	-
Calendar	string	-	-
ContactOverride	boolean	-	-
Customer	string	Customer → CustomerID	-
EntityUsageType	string	-	-
FedExGroundCollect	boolean	-	-
FOBPoint	string	-	-
Insurance	boolean	-	-
LeadTimeDays	decimal	-	-
LocationName	string	-	-
OrderPriority	decimal	-	-
PriceClass	string	-	-
ResidentialDelivery	boolean	-	-
SaturdayDelivery	boolean	-	-
ShippingRule	string	-	-
ShippingTerms	string	-	-
ShippingZone	string	-	-
ShipVia	string	-	-
TaxExemptionNbr	string	-	-
TaxRegistrationID	string	-	-
TaxZone	string	-	-
Warehouse	string	-	-
CreatedDateTime	datetime	-	-
LastModifiedDateTime	datetime	-	-
RowNumber	int	-	-
Note	string	-	-

Employee

Column	Type	Relates to	Notes
RemoteID	string	-	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ID	string	-	-
EmployeeID	string	-	-
EmployeeName	string	-	-
Note	string	-	-
Status	string	-	-
Email	string	-	-
DateOfBirth	datetime	-	-
FirstName	string	-	-
LastName	string	-	-
Phone1	string	-	-
Phone1Type	string	-	-
Phone2	string	-	-
Phone2Type	string	-	-
Phone3	string	-	-
Phone3Type	string	-	-
Title	string	-	-
WebSite	string	-	-
BranchID	string	Branch → BranchCD	-
Calendar	string	-	-
CurrencyID	string	Currency → CurrencyID	-
CurrencyRateTypeID	string	-	-
DepartmentID	string	-	-
EmployeeClass	string	-	-
EmployeeRefNbr	string	-	-
LaborItem	string	-	-
RegularHoursValidation	string	-	-
CreatedDateTime	datetime	-	-
LastModifiedDateTime	datetime	-	-
RowNumber	int	-	-

Invoice

Column	Type	Relates to	Notes
RemoteID	string	-	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ID	string	-	-
Description	string	-	-
Amount	decimal	-	-
ReferenceNbr	string	-	-
Balance	decimal	-	-
BillingPrinted	boolean	-	-
BillToContactOverride	boolean	-	-
Customer	string	Customer → CustomerID	-
CustomerOrder	string	-	-
Date	datetime	-	-
DueDate	datetime	-	-
Hold	boolean	-	-
LinkARAccount	string	-	-
PostPeriod	string	-	-
ShipToContactOverride	boolean	-	-
Status	string	-	-
TaxTotal	decimal	-	-
Terms	string	-	-
Type	string	-	-
ShipToContactAttention	string	-	-
ShipToContactBusinessName	string	-	-
ShipToContactEmail	string	-	-
ShipToContactPhone1	string	-	-
BillToContactAttention	string	-	-
BillToContactBusinessName	string	-	-
BillToContactEmail	string	-	-
BillToContactPhone1	string	-	-
RowNumber	int	-	-
Note	string	-	-

ItemClass

Column	Type	Relates to	Notes
RemoteID	string	-	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ID	string	-	-
Description	string	-	-
ClassID	string	-	-
AvailabilityCalculationRule	string	-	-
BaseUOM	string	-	-
CountryOfOrigin	string	-	-
ItemType	string	-	-
LotSerialClass	string	-	-
PostingClass	string	-	-
PriceClass	string	-	-
StockItem	boolean	-	-
TaxCategoryID	string	-	-
ValuationMethod	string	-	-
CreatedDateTime	datetime	-	-
LastModifiedDateTime	datetime	-	-
RowNumber	int	-	-
Note	string	-	-

JournalTransaction

Column	Type	Relates to	Notes
RemoteID	string	-	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ID	string	-	-
Description	string	-	-
BatchNbr	string	-	-
BranchID	string	Branch → BranchCD	-
CurrencyID	string	Currency → CurrencyID	-
LedgerID	string	Ledger → LedgerID	-
Module	string	-	-
PostPeriod	string	-	-
Status	string	-	-
Hold	boolean	-	-
TransactionDate	datetime	-	-
Account	string	Account → AccountCD	-
CreditAmount	decimal	-	-
DebitAmount	decimal	-	-
Qty	decimal	-	-
DetailsDescription	string	-	-
IsNonPM	boolean	-	-
NonBillable	boolean	-	-
LineNbr	int	-	-
Project	string	-	-
ProjectTask	string	-	-
ProjectTransactionID	string	-	-
ReferenceNbr	string	-	-
TransactionDescription	string	-	-
UOM	string	-	-
ELEEMPEROR	string	-	-
Subaccount	string	SubAccount → SubaccountCD	-
CreatedDateTime	datetime	-	-
LastModifiedDateTime	datetime	-	-
RowNumber	int	-	-
Note	string	-	-

Ledger

Column	Type	Relates to	Notes
RemoteID	string	-	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ID	string	-	-
Description	string	-	-
LedgerID	string	-	-
Currency	string	-	-
Type	string	-	-
ConsolidationSource	boolean	-	-
CreatedDateTime	datetime	-	-
LastModifiedDateTime	datetime	-	-
RowNumber	int	-	-
Note	string	-	-

Payment

Column	Type	Relates to	Notes
RemoteID	string	-	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ID	string	-	-
Description	string	-	-
NoteID	guid	-	-
ApplicationDate	datetime	-	-
ExternalRef	string	-	-
OrigTransaction	string	-	-
Status	string	-	-
Type	string	-	-
PaymentMethod	string	-	-
PaymentRef	string	-	-
ReferenceNbr	string	-	-
AppliedToDocuments	decimal	-	-
AppliedToOrders	decimal	-	-
PaymentAmount	decimal	-	-
AvailableBalance	decimal	-	-
Hold	boolean	-	-
IsNewCard	boolean	-	-
SaveCard	boolean	-	-
BranchID	string	Branch → BranchCD	-
CustomerID	string	Customer → CustomerID	-
CurrencyID	string	Currency → CurrencyID	-
CreatedDateTime	datetime	-	-
LastModifiedDateTime	datetime	-	-
RowNumber	int	-	-
Note	string	-	-

PurchaseOrder

Column	Type	Relates to	Notes
RemoteID	string	-	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ID	string	-	-
Description	string	-	-
OrderNbr	string	-	-
NoteID	string	-	-
Branch	string	-	-
LastModifiedDateTime	datetime	-	-
PromisedOn	datetime	-	-
BaseCurrencyID	string	Currency → RemoteID	-
ControlTotal	decimal	-	-
CurrencyID	string	Currency → RemoteID	-
CurrencyRate	decimal	-	-
CurrencyReciprocalRate	decimal	-	-
CurrencyRateTypeID	string	-	-
Date	datetime	-	-
CurrencyEffectiveDate	datetime	-	-
Hold	boolean	-	-
IsTaxValid	boolean	-	-
OrderTotal	decimal	-	-
Status	string	-	-
TaxTotal	decimal	-	-
ShippingDestinationType	string	-	-
ShippingLocation	string	-	-
ShipTo	string	-	-
Warehouse	string	-	-
ShipToAddressOverride	boolean	-	-
ShipToAddressValidated	boolean	-	-
ShipToContactOverride	boolean	-	-
ShipToContactAttention	string	-	-
ShipToContactBusinessName	string	-	-
ShipToContactEmail	string	-	-
ShipToContactPhone1	string	-	-
ShipToAddressAddressLine1	string	-	-
ShipToAddressAddressLine2	string	-	-
ShipToAddressCity	string	-	-
ShipToAddressCountry	string	-	-
ShipToAddressPostalCode	string	-	-
ShipToAddressState	string	-	-
RowNumber	int	-	-
Note	string	-	-

SalesInvoice

Column	Type	Relates to	Notes
RemoteID	string	-	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ID	string	-	-
Description	string	-	-
ReferenceNbr	string	-	-
CashDiscount	decimal	-	-
CreditHold	boolean	-	-
Currency	string	-	-
Date	datetime	-	-
CustomerID	string	Customer → CustomerID	-
CustomerOrder	string	-	-
Amount	decimal	-	-
DiscountTotal	decimal	-	-
DueDate	datetime	-	-
IsTaxValid	boolean	-	-
FreightPrice	decimal	-	-
Hold	boolean	-	-
PaymentTotal	decimal	-	-
Project	string	-	-
Status	string	-	-
TaxTotal	decimal	-	-
Type	string	-	-
TaxExemptTotal	decimal	-	-
TaxTaxableTotal	decimal	-	-
RowNumber	int	-	-
Note	string	-	-

SalesOrder

Column	Type	Relates to	Notes
RemoteID	string	-	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ID	string	-	-
Description	string	-	-
Approved	boolean	-	-
LastModified	datetime	-	-
OrderNbr	string	-	-
NoteID	string	-	-
CreatedDate	datetime	-	-
BaseCurrencyID	string	Currency → RemoteID	-
BillToAddressOverride	boolean	-	-
BillToContactOverride	boolean	-	-
CashAccount	string	-	-
ContactID	string	Contact → RemoteID	-
ControlTotal	decimal	-	-
CreditHold	boolean	-	-
CurrencyID	string	Currency → RemoteID	-
CurrencyRate	decimal	-	-
CurrencyRateTypeID	string	-	-
CustomerID	string	Customer → CustomerID	-
CustomerOrder	string	-	-
Date	datetime	-	-
DestinationWarehouseID	string	-	-
DisableAutomaticDiscountUpdate	boolean	-	-
DisableAutomaticTaxCalculation	boolean	-	-
EffectiveDate	datetime	-	-
ExternalOrderOrigin	string	-	-
ExternalOrderOriginal	boolean	-	-
ExternalOrderSource	string	-	-
ExternalRef	string	-	-
ExternalRefundRef	string	-	-
Hold	boolean	-	-
IsTaxValid	boolean	-	-
OrderedQty	decimal	-	-
OrderTotal	decimal	-	-
OrderType	string	-	-
PaymentMethod	string	-	-
PaymentRef	string	-	-
ReciprocalRate	decimal	-	-
RequestedOn	datetime	-	-
ShipToAddressOverride	boolean	-	-
ShipToContactOverride	boolean	-	-
ShipVia	string	-	-
Status	string	-	-
TaxCalcMode	string	-	-
TaxTotal	decimal	-	-
VATExemptTotal	decimal	-	-
VATTaxableTotal	decimal	-	-
WillCall	boolean	-	-
ShipToContactAttention	string	-	-
ShipToContactBusinessName	string	-	-
ShipToContactEmail	string	-	-
ShipToContactPhone1	string	-	-
BillToContactAttention	string	-	-
BillToContactBusinessName	string	-	-
BillToContactEmail	string	-	-
BillToContactPhone1	string	-	-
RowNumber	int	-	-
Note	string	-	-

Salesperson

Column	Type	Relates to	Notes
RemoteID	string	-	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ID	string	-	-
Name	string	-	-
SalespersonID	string	-	-
IsActive	boolean	-	-
SalesSubAccount	string	-	-
DefaultCommission	decimal	-	-
CreatedDateTime	datetime	-	-
LastModifiedDateTime	datetime	-	-
RowNumber	int	-	-
Note	string	-	-

StockItem

Column	Type	Relates to	Notes
RemoteID	string	-	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ID	string	-	-
Description	string	-	-
InventoryID	string	-	-
LastModified	datetime	-	-
ABCCode	string	-	-
AutoIncrementalValue	string	-	-
Availability	string	-	-
AverageCost	decimal	-	-
BaseUOM	string	-	-
COGSAccount	string	-	-
COGSSubaccount	string	-	-
Content	string	-	-
CountryOfOrigin	string	-	-
CurrentStdCost	decimal	-	-
CurySpecificMSRP	decimal	-	-
CurySpecificPrice	decimal	-	-
CustomURL	string	-	-
DefaultPrice	decimal	-	-
DimensionVolume	decimal	-	-
DimensionWeight	decimal	-	-
DiscountAccount	string	-	-
DiscountSubaccount	string	-	-
ExportToExternal	boolean	-	-
ImageUrl	string	-	-
InventoryAccount	string	-	-
InventorySubaccount	string	-	-
IsAKit	boolean	-	-
ItemClass	string	ItemClass → ClassID	-
ItemStatus	string	-	-
ItemType	string	-	-
LandedCostVarianceAccount	string	-	-
LandedCostVarianceSubaccount	string	-	-
LastCost	decimal	-	-
LastStdCost	decimal	-	-
LotSerialClass	string	-	-
Markup	decimal	-	-
MaxCost	decimal	-	-
MetaDescription	string	-	-
MetaKeywords	string	-	-
MinCost	decimal	-	-
MinMarkup	decimal	-	-
MSRP	decimal	-	-
NotAvailable	string	-	-
NoteID	string	-	-
PageTitle	string	-	-
PendingStdCost	decimal	-	-
POAccrualAccount	string	-	-
POAccrualSubaccount	string	-	-
PostingClass	string	-	-
PriceClass	string	-	-
PriceManager	string	-	-
PriceWorkgroup	string	-	-
ProductManager	string	-	-
ProductWorkgroup	string	-	-
PurchasePriceVarianceAccount	string	-	-
PurchasePriceVarianceSubaccount	string	-	-
ReasonCodeSubaccount	string	-	-
SalesAccount	string	-	-
SalesSubaccount	string	-	-
SearchKeywords	string	-	-
StandardCostRevaluationAccount	string	-	-
StandardCostRevaluationSubaccount	string	-	-
StandardCostVarianceAccount	string	-	-
StandardCostVarianceSubaccount	string	-	-
SubjectToCommission	boolean	-	-
TaxCategory	string	-	-
TemplateItemID	string	StockItem → RemoteID	-
ValuationMethod	string	-	-
Visibility	string	-	-
VolumeUOM	string	-	-
WeightUOM	string	-	-
RowNumber	int	-	-
Note	string	-	-

SubAccount

Column	Type	Relates to	Notes
RemoteID	string	-	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ID	string	-	-
Description	string	-	-
SubaccountCD	string	-	-
SubaccountID	long	-	-
AccountClass	string	-	-
Secured	boolean	-	-
Active	boolean	-	-
CreatedDateTime	datetime	-	-
LastModifiedDateTime	datetime	-	-
RowNumber	int	-	-
Note	string	-	-

Vendor

Column	Type	Relates to	Notes
RemoteID	string	-	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ID	string	-	-
VendorID	string	-	-
AccountRef	string	-	-
APAccount	string	-	-
APSubaccount	string	-	-
CashAccount	string	-	-
CurrencyID	string	Currency → RemoteID	-
CurrencyRateType	string	-	-
EnableCurrencyOverride	boolean	-	-
EnableRateOverride	boolean	-	-
FOBPoint	string	-	-
LandedCostVendor	boolean	-	-
LeadTimedays	decimal	-	-
LocationName	string	-	-
MaxReceipt	decimal	-	-
MinReceipt	decimal	-	-
ParentAccount	string	-	-
PaymentBy	string	-	-
PaymentLeadTimedays	decimal	-	-
PaymentMethod	string	-	-
PaySeparately	boolean	-	-
PrintOrders	boolean	-	-
ReceiptAction	string	-	-
RemittanceAddressOverride	boolean	-	-
RemittanceContactOverride	boolean	-	-
SendOrdersbyEmail	boolean	-	-
ShippingAddressOverride	boolean	-	-
ShippingContactOverride	boolean	-	-
ShippingTerms	string	-	-
ShipVia	string	-	-
Status	string	-	-
Warehouse	string	-	-
TaxCalculationMode	string	-	-
TaxRegistrationID	string	-	-
TaxZone	string	-	-
Terms	string	-	-
ThresholdReceipt	decimal	-	-
VendorClass	string	-	-
VendorIsLaborUnion	boolean	-	-
VendorIsTaxAgency	boolean	-	-
VendorName	string	-	-
MainContactID	long	Contact → ContactID	-
RemittanceContactID	long	Contact → ContactID	-
PrimaryContactID	long	Contact → ContactID	-
ShippingContactID	long	Contact → ContactID	-
CreatedDateTime	datetime	-	-
LastModifiedDateTime	datetime	-	-
RowNumber	int	-	-
Note	string	-	-

Warehouse

Column	Type	Relates to	Notes
RemoteID	string	-	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ID	string	-	-
Description	string	-	-
WarehouseID	string	-	-
COGSExpenseAccount	string	Account → AccountCD	-
DiscountAccount	string	Account → AccountCD	-
FreightChargeAccount	string	Account → AccountCD	-
InventoryAccount	string	Account → AccountCD	-
LandedCostVarianceAccount	string	Account → AccountCD	-
MiscChargeAccount	string	Account → AccountCD	-
POAccrualAccount	string	Account → AccountCD	-
PurchasePriceVarianceAccount	string	Account → AccountCD	-
SalesAccount	string	Account → AccountCD	-
StandardCostRevaluationAccount	string	Account → AccountCD	-
StandardCostVarianceAccount	string	Account → AccountCD	-
COGSExpenseSubaccount	string	SubAccount → SubaccountCD	-
SalesSubaccount	string	SubAccount → SubaccountCD	-
FreightChargeSubaccount	string	SubAccount → SubaccountCD	-
DiscountSubaccount	string	SubAccount → SubaccountCD	-
InventorySubaccount	string	SubAccount → SubaccountCD	-
LandedCostVarianceSubaccount	string	SubAccount → SubaccountCD	-
MiscChargeSubaccount	string	SubAccount → SubaccountCD	-
OverrideInventoryAccountSubaccount	string	SubAccount → SubaccountCD	-
POAccrualSubaccount	string	SubAccount → SubaccountCD	-
PurchasePriceVarianceSubaccount	string	SubAccount → SubaccountCD	-
ReasonCodeSubaccount	string	SubAccount → SubaccountCD	-
StandardCostRevaluationSubaccount	string	SubAccount → SubaccountCD	-
StandardCostVarianceSubaccount	string	SubAccount → SubaccountCD	-
DropShipLocationID	string	WarehouseLocation → LocationID	-
ReceivingLocationID	string	WarehouseLocation → LocationID	-
RMALocationID	string	WarehouseLocation → LocationID	-
ShippingLocationID	string	WarehouseLocation → LocationID	-
Active	boolean	-	-
CreatedDateTime	datetime	-	-
LastModifiedDateTime	datetime	-	-
RowNumber	int	-	-
Note	string	-	-

BillDetail

Column	Type	Relates to	Notes
RemoteID	string	-	-
BillRemoteID	string	Bill → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ID	string	-	-
Description	string	-	-
BillID	string	Bill → RemoteID	-
RowNumber	int	-	-
Account	string	-	-
Amount	decimal	-	-
CalculateDiscountsOnImport	boolean	-	-
CostCode	string	-	-
ExtendedCost	decimal	-	-
InventoryID	string	StockItem → RemoteID	-
POReceiptLine	int	-	-
POReceiptNbr	string	-	-
POReceiptType	string	-	-
Qty	decimal	-	-
Subaccount	string	-	-
TaxCategory	string	-	-
TransactionDescription	string	-	-
UnitCost	decimal	-	-
UOM	string	-	-
Note	string	-	-

BusinessAccountMainAddress

Column	Type	Relates to	Notes
RemoteID	string	-	-
BusinessAccountRemoteID	string	BusinessAccount → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ID	string	-	-
BusinessAccountID	string	BusinessAccount → BusinessAccountID	-
Iterator	int	-	-
AddressLine1	string	-	-
AddressLine2	string	-	-
City	string	-	-
Country	string	-	-
PostalCode	string	-	-
State	string	-	-
Validated	boolean	-	-
RowNumber	int	-	-
Note	string	-	-

BusinessAccountShippingAddress

Column	Type	Relates to	Notes
RemoteID	string	-	-
BusinessAccountRemoteID	string	BusinessAccount → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ID	string	-	-
BusinessAccountID	string	BusinessAccount → BusinessAccountID	-
Iterator	int	-	-
AddressLine1	string	-	-
AddressLine2	string	-	-
City	string	-	-
Country	string	-	-
PostalCode	string	-	-
State	string	-	-
Validated	boolean	-	-
RowNumber	int	-	-
Note	string	-	-

ContactAddress

Column	Type	Relates to	Notes
RemoteID	string	-	-
ContactRemoteID	string	Contact → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ID	string	-	-
ContactID	string	Contact → RemoteID	-
Iterator	int	-	-
AddressLine1	string	-	-
AddressLine2	string	-	-
City	string	-	-
Country	string	-	-
PostalCode	string	-	-
State	string	-	-
Validated	boolean	-	-
RowNumber	int	-	-
Note	string	-	-

ContactCase

Column	Type	Relates to	Notes
RemoteID	string	-	-
ContactRemoteID	string	Contact → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ID	string	-	-
ContactID	string	Contact → RemoteID	-
CaseID	string	-	-
ClassID	string	-	-
ClosingDate	datetime	-	-
DateReported	datetime	-	-
Estimation	string	-	-
InitialResponse	string	-	-
Owner	string	-	-
Reason	string	-	-
Severity	string	-	-
Status	string	-	-
Subject	string	-	-
RowNumber	int	-	-
Note	string	-	-

CustomerContact

Column	Type	Relates to	Notes
RemoteID	string	-	-
CustomerRemoteID	string	Customer → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
CustomerID	string	Customer → RemoteID	-
ContactID	long	Contact → ContactID	-

CustomerSalesperson

Column	Type	Relates to	Notes
RemoteID	string	-	-
CustomerRemoteID	string	Customer → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ID	string	-	-
Name	string	-	-
CustomerID	string	Customer → RemoteID	-
SalespersonID	string	Salesperson → SalespersonID	-
LocationID	string	-	-
Default	boolean	-	-
Commission	decimal	-	-
RowNumber	int	-	-
Note	string	-	-

InvoiceDetail

Column	Type	Relates to	Notes
RemoteID	string	-	-
InvoiceRemoteID	string	Invoice → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ID	string	-	-
InvoiceID	string	Invoice → ReferenceNbr	-
RowNumber	int	-	-
Account	string	-	-
Amount	decimal	-	-
Branch	string	-	-
CalculateDiscountsOnImport	boolean	-	-
CostCode	string	-	-
DiscountAmount	decimal	-	-
ExtendedPrice	decimal	-	-
InventoryID	string	StockItem → InventoryID	-
LineNbr	int	-	-
ProjectTask	string	-	-
Qty	decimal	-	-
SubAccount	string	-	-
TransactionDescription	string	-	-
UnitPrice	decimal	-	-
TaxCategory	string	-	-
UOM	string	-	-
Note	string	-	-

InvoiceDiscountDetail

Column	Type	Relates to	Notes
RemoteID	string	-	-
InvoiceRemoteID	string	Invoice → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ID	string	-	-
Description	string	-	-
InvoiceID	string	Invoice → ReferenceNbr	-
RowNumber	int	-	-
DiscountableAmount	decimal	-	-
DiscountableQty	decimal	-	-
DiscountAmount	decimal	-	-
DiscountCode	string	-	-
DiscountPercent	decimal	-	-
ExternalDiscountCode	string	-	-
ManualDiscount	boolean	-	-
OrderNbr	string	-	-
OrderType	string	-	-
RetainedDiscount	decimal	-	-
SequenceIDType	string	-	-
SkipDiscount	boolean	-	-
Type	string	-	-
Note	string	-	-

PurchaseOrderTaxDetail

Column	Type	Relates to	Notes
RemoteID	string	-	-
PurchaseOrderRemoteID	string	PurchaseOrder → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ID	string	-	-
PurchaseOrderID	string	PurchaseOrder → RemoteID	-
Iterator	int	-	-
RetainedTaxableAmount	decimal	-	-
RetainedTaxAmount	decimal	-	-
TaxAmount	decimal	-	-
TaxableAmount	decimal	-	-
TaxRate	decimal	-	-
TaxID	string	-	-
RowNumber	int	-	-
Note	string	-	-

PurchaseOrderDetail

Column	Type	Relates to	Notes
RemoteID	string	-	-
PurchaseOrderRemoteID	string	PurchaseOrder → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ID	string	-	-
Description	string	-	-
PurchaseOrderID	string	PurchaseOrder → RemoteID	-
RowNumber	int	-	-
Account	string	Account → AccountCD	-
AlternateID	string	-	-
BranchID	string	-	-
CalculateDiscountsOnImport	boolean	-	-
Cancelled	boolean	-	-
Completed	boolean	-	-
CompleteOn	decimal	-	-
CostCode	string	-	-
ExtendedCost	decimal	-	-
InventoryID	string	StockItem → InventoryID	-
LineDescription	string	-	-
LineNbr	int	-	-
LineType	string	-	-
MaxReceiptPercent	decimal	-	-
MinReceiptPercent	decimal	-	-
OrderedQty	decimal	-	-
OrderNbr	string	-	-
OrderQty	decimal	-	-
OrderType	string	-	-
OrigPONbr	string	-	-
OrigPOType	string	-	-
Promised	datetime	-	-
QtyOnReceipts	decimal	-	-
ReceiptAction	string	-	-
ReceivedAmount	decimal	-	-
Requested	datetime	-	-
TaxCategory	string	-	-
UnitCost	decimal	-	-
UOM	string	-	-
WarehouseID	string	-	-
Note	string	-	-

SalesInvoiceDetail

Column	Type	Relates to	Notes
RemoteID	string	-	-
SalesInvoiceRemoteID	string	SalesInvoice → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ID	string	-	-
Description	string	-	-
SalesInvoiceID	string	SalesInvoice → ReferenceNbr	-
RowNumber	int	-	-
Amount	decimal	-	-
BranchID	string	-	-
CalculateDiscountsOnImport	boolean	-	-
CostCode	string	-	-
DiscountAmount	decimal	-	-
DiscountPercent	decimal	-	-
ExtendedPrice	decimal	-	-
ExpirationDate	datetime	-	-
InventoryDocType	string	-	-
InventoryID	string	StockItem → InventoryID	-
InventoryRefNbr	string	-	-
LineNbr	int	-	-
LotSerialNbr	string	-	-
ManualDiscount	boolean	-	-
OrderLineNbr	int	-	-
OrderNbr	string	SalesOrder → OrderNbr	-
OrderType	string	-	-
OrigInvLineNbr	int	-	-
OrigInvNbr	string	Invoice → ReferenceNbr	-
OrigInvType	string	-	-
Qty	decimal	-	-
ShipmentNbr	string	-	-
TaxCategory	string	-	-
TransactionDescription	string	-	-
UnitPrice	decimal	-	-
UOM	string	-	-
Note	string	-	-

SalesOrderBillToAddress

Column	Type	Relates to	Notes
RemoteID	string	-	-
SalesOrderRemoteID	string	SalesOrder → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ID	string	-	-
SalesOrderID	string	SalesOrder → RemoteID	-
Iterator	int	-	-
AddressLine1	string	-	-
AddressLine2	string	-	-
City	string	-	-
Country	string	-	-
PostalCode	string	-	-
State	string	-	-
Validated	boolean	-	-
RowNumber	int	-	-
Note	string	-	-

SalesOrderTotals

Column	Type	Relates to	Notes
RemoteID	string	-	-
SalesOrderRemoteID	string	SalesOrder → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ID	string	-	-
SalesOrderID	string	SalesOrder → RemoteID	-
DiscountTotal	decimal	-	-
UnpaidBalance	decimal	-	-
UnbilledQty	decimal	-	-
UnbilledAmount	decimal	-	-
TaxTotal	decimal	-	-
PremiumFreight	decimal	-	-
PackageWeight	decimal	-	-
OrderWeight	decimal	-	-
OrderVolume	decimal	-	-
MiscTotalAmount	decimal	-	-
LineTotalAmount	decimal	-	-
FreightCost	decimal	-	-
Freight	decimal	-	-
FreightTaxCategory	string	-	-
OverrideFreightAmount	boolean	-	-
FreightCostIsuptodate	boolean	-	-
RowNumber	int	-	-
Note	string	-	-

SalesOrderShipToAddress

Column	Type	Relates to	Notes
RemoteID	string	-	-
SalesOrderRemoteID	string	SalesOrder → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ID	string	-	-
SalesOrderID	string	SalesOrder → RemoteID	-
Iterator	int	-	-
AddressLine1	string	-	-
AddressLine2	string	-	-
City	string	-	-
Country	string	-	-
PostalCode	string	-	-
State	string	-	-
Validated	boolean	-	-
RowNumber	int	-	-
Note	string	-	-

SalesOrderDetail

Column	Type	Relates to	Notes
RemoteID	string	-	-
SalesOrderRemoteID	string	SalesOrder → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ID	string	-	-
SalesOrderID	string	SalesOrder → RemoteID	-
RowNumber	int	-	-
Account	string	Account → AccountCD	-
AlternateID	string	-	-
Amount	decimal	-	-
AssociatedOrderLineNbr	long	-	-
AutoCreateIssue	boolean	-	-
AverageCost	decimal	-	-
CalculateDiscountsOnImport	boolean	-	-
Commissionable	boolean	-	-
Completed	boolean	-	-
CostCode	string	-	-
CustomerOrderNbr	string	-	-
DiscountAmount	decimal	-	-
DiscountCode	string	-	-
DiscountedUnitPrice	decimal	-	-
DiscountPercent	decimal	-	-
ExtendedPrice	decimal	-	-
ExternalRef	string	-	-
FreeItem	boolean	-	-
GiftMessage	string	-	-
InventoryID	string	StockItem → InventoryID	-
InvoiceLineNbr	int	-	-
InvoiceNbr	string	-	-
InvoiceType	string	-	-
LineDescription	string	-	-
LineNbr	int	-	-
LineType	string	-	-
LotSerialNbr	string	-	-
ManualDiscount	boolean	-	-
ManualPrice	boolean	-	-
MarkForPO	boolean	-	-
OpenQty	decimal	-	-
Operation	string	-	-
POSource	string	-	-
OrderQty	decimal	-	-
OvershipThreshold	decimal	-	-
QtyOnShipments	decimal	-	-
ReasonCode	string	-	-
RequestedOn	datetime	-	-
SalespersonID	string	Salesperson → RemoteID	-
SchedOrderDate	datetime	-	-
ShippingRule	string	-	-
TaxCategory	string	-	-
TaxZone	string	-	-
UnbilledAmount	decimal	-	-
UndershipThreshold	decimal	-	-
UnitCost	decimal	-	-
UnitPrice	decimal	-	-
UOM	string	-	-
Note	string	-	-

VendorContact

Column	Type	Relates to	Notes
RemoteID	string	-	-
VendorRemoteID	string	Vendor → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
VendorID	string	Vendor → VendorID	-
ContactID	long	Contact → ContactID	-

WarehouseLocation

Column	Type	Relates to	Notes
RemoteID	string	-	-
WarehouseRemoteID	string	Warehouse → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ID	string	-	-
Description	string	-	-
WarehouseID	string	Warehouse → WarehouseID	-
LocationID	string	-	-
Active	boolean	-	-
AssemblyAllowed	boolean	-	-
ReceiptsAllowed	boolean	-	-
SalesAllowed	boolean	-	-
TransfersAllowed	boolean	-	-
PickPriority	int	-	-
RowNumber	int	-	-
Note	string	-	-