2024 is the year of the connector - vote here

Explore the MYOB Acumatica (Advanced) API data model

See how the various MYOB Acumatica (Advanced) endpoints relate to each other, using our handy Entity Relationship Diagram

Try our interactive ERD

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 Acumatica (Advanced) 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.

Endpoints

GLAccount

Documentation: https://help.acumatica.com/dacBrowser/PX.Objects.GL/GLAccount

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Description string - -
AccountID long - -
AccountCD string - -
AccountingType string - -
AccountClassID string - -
Type string - -
ControlAccountModule string - -
AllowManualEntry boolean - -
COAOrder long - -
Active boolean - -
PostOption string - -
DirectPost boolean - -
NoSubDetail boolean - -
RequireUnits boolean - -
GLConsolAccountCD string - -
CuryID string - -
AccountGroupID long - -
RevalCuryRateTypeID string - -
Box1099 string - -
NoteID guid - -
NoteText string - -
CreatedByID guid - -
CreatedByScreenID string - -
CreatedDateTime datetime - -
LastModifiedByID guid - -
LastModifiedByScreenID string - -
LastModifiedDateTime datetime - -
IsCashAccount boolean - -
TypeTotal string - -
ReadableActive int - -
TransactionsForGivenCurrencyExists boolean - -
Included boolean - -
TaxCategoryID string - -
Secured boolean - -
Tstamp string - -

GLHistory

Documentation: https://help.acumatica.com/dacBrowser/PX.Objects.GL/GLAccount

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
LedgerID long - -
BranchID long - -
AccountID long GLAccount → AccountID -
SubID long - -
FinPeriodID string - -
BalanceType string - -
CuryID string - -
FinPtdCredit decimal - -
FinPtdDebit decimal - -
FinYtdBalance decimal - -
FinBegBalance decimal - -
FinPtdRevalued decimal - -
TranPtdCredit decimal - -
TranPtdDebit decimal - -
TranYtdBalance decimal - -
TranBegBalance decimal - -
CuryFinPtdCredit decimal - -
CuryFinPtdDebit decimal - -
CuryFinYtdBalance decimal - -
CuryFinBegBalance decimal - -
CuryTranPtdCredit decimal - -
CuryTranPtdDebit decimal - -
CuryTranYtdBalance decimal - -
CuryTranBegBalance decimal - -
FinFlag boolean - -
REFlag boolean - -
PtdCredit decimal - -
PtdDebit decimal - -
YtdBalance decimal - -
BegBalance decimal - -
PtdRevalued decimal - -
CuryPtdCredit decimal - -
CuryPtdDebit decimal - -
CuryYtdBalance decimal - -
CuryBegBalance decimal - -
LastModifiedDateTime datetime - -
FinYear string - -
DetDeleted boolean - -
AllocPtdBalance decimal - -
AllocBegBalance decimal - -
Tstamp string - -

INItemCost

Documentation: https://help.acumatica.com/dacBrowser/PX.Objects.IN/INItemCost

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
InventoryID long InventoryItem → InventoryID -
CuryID string - -
LastCost decimal - -
LastCostDate datetime - -
TotalCost decimal - -
QtyOnHand decimal - -
AvgCost decimal - -
MinCost decimal - -
MaxCost decimal - -
TranUnitCost decimal - -
Tstamp string - -

INItemCostHistory

Documentation: https://help.acumatica.com/dacBrowser/PX.Objects.IN/INItemCostHist

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
InventoryID long InventoryItem → InventoryID -
CostSiteID long - -
AccountID long - -
SubID long - -
CostSubItemID long -
  • 16 Jul 2024 We have observed an empty value coming down for this, however it still contributes to the unique key
FinPeriodID string - -
SiteID long INSite → SiteID -
FinPtdCostIssued decimal - -
FinPtdCostReceived decimal - -
FinBegCost decimal - -
FinYtdCost decimal - -
FinPtdQtyIssued decimal - -
FinPtdQtyReceived decimal - -
FinBegQty decimal - -
FinYtdQty decimal - -
FinPtdCOGS decimal - -
FinPtdCOGSCredits decimal - -
FinPtdCOGSDropShips decimal - -
FinPtdCostTransferIn decimal - -
FinPtdCostTransferOut decimal - -
FinPtdCostAssemblyIn decimal - -
FinPtdCostAssemblyOut decimal - -
FinPtdCostAMAssemblyIn decimal - -
FinPtdCostAMAssemblyOut decimal - -
FinPtdCostAdjusted decimal - -
FinPtdQtySales decimal - -
FinPtdQtyCreditMemos decimal - -
FinPtdQtyDropShipSales decimal - -
FinPtdQtyTransferIn decimal - -
FinPtdQtyTransferOut decimal - -
FinPtdQtyAssemblyIn decimal - -
FinPtdQtyAssemblyOut decimal - -
FinPtdQtyAMAssemblyIn decimal - -
FinPtdQtyAMAssemblyOut decimal - -
FinPtdQtyAdjusted decimal - -
FinPtdSales decimal - -
FinPtdCreditMemos decimal - -
FinPtdDropShipSales decimal - -
TranPtdCostReceived decimal - -
TranPtdCostIssued decimal - -
TranPtdQtyReceived decimal - -
TranPtdQtyIssued decimal - -
TranPtdCOGS decimal - -
TranPtdCOGSCredits decimal - -
TranPtdCOGSDropShips decimal - -
TranPtdCostTransferIn decimal - -
TranPtdCostTransferOut decimal - -
TranPtdCostAssemblyIn decimal - -
TranPtdCostAssemblyOut decimal - -
TranPtdCostAMAssemblyIn decimal - -
TranPtdCostAMAssemblyOut decimal - -
TranPtdCostAdjusted decimal - -
TranPtdQtySales decimal - -
TranPtdQtyCreditMemos decimal - -
TranPtdQtyDropShipSales decimal - -
TranPtdQtyTransferIn decimal - -
TranPtdQtyTransferOut decimal - -
TranPtdQtyAssemblyIn decimal - -
TranPtdQtyAssemblyOut decimal - -
TranPtdQtyAMAssemblyIn decimal - -
TranPtdQtyAMAssemblyOut decimal - -
TranPtdQtyAdjusted decimal - -
TranPtdSales decimal - -
TranPtdCreditMemos decimal - -
TranPtdDropShipSales decimal - -
TranBegCost decimal - -
TranYtdCost decimal - -
TranBegQty decimal - -
TranYtdQty decimal - -
LastModifiedDateTime datetime - -
Tstamp string - -

INRegister

Documentation: https://help.acumatica.com/dacBrowser/PX.Objects.IN/INRegister

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
DocType string - -
RefNbr string - -
BranchID long - -
OrigModule string - -
OrigRefNbr string - -
SrcDocType string - -
SrcRefNbr string - -
SiteID long INSite → SiteID -
ToSiteID long INSite → SiteID -
TransferType string - -
TransferNbr string - -
TranDesc string - -
Released boolean - -
ReleasedToVerify boolean - -
Hold boolean - -
Status string - -
TranDate datetime - -
FinPeriodID string - -
TranPeriodID string - -
LineCntr long - -
TotalQty decimal - -
TotalAmount decimal - -
TotalCost decimal - -
ControlQty decimal - -
ControlAmount decimal - -
ControlCost decimal - -
BatchNbr string - -
ExtRefNbr string - -
KitInventoryID long - -
KitRevisionID string - -
KitLineNbr long - -
SOOrderType string - -
SOOrderNbr string - -
SOShipmentType string - -
SOShipmentNbr string - -
POReceiptType string - -
POReceiptNbr string - -
PIID string - -
CreatedByID guid - -
CreatedByScreenID string - -
CreatedDateTime datetime - -
LastModifiedByID guid - -
LastModifiedByScreenID string - -
LastModifiedDateTime datetime - -
NoteID guid - -
NoteText string - -
IsPPVTran boolean - -
IsTaxAdjustmentTran boolean - -
Tstamp string - -

INSite

Documentation: https://help.acumatica.com/dacBrowser/PX.Objects.IN/INSite

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
SiteID long - -
SiteCD string - -
Descr string - -
ReasonCodeSubID long - -
SalesAcctID long GLAccount → AccountID -
SalesSubID long - -
InvtAcctID long GLAccount → AccountID -
InvtSubID long - -
COGSAcctID long GLAccount → AccountID -
COGSSubID long - -
StdCstRevAcctID long GLAccount → AccountID -
StdCstRevSubID long - -
StdCstVarAcctID long GLAccount → AccountID -
StdCstVarSubID long - -
PPVAcctID long GLAccount → AccountID -
PPVSubID long - -
POAccrualAcctID long GLAccount → AccountID -
POAccrualSubID long - -
LCVarianceAcctID long GLAccount → AccountID -
LCVarianceSubID long - -
ReceiptLocationID long - -
ReceiptLocationIDOverride long - -
ShipLocationID long - -
ShipLocationIDOverride long - -
DropShipLocationID long - -
ReturnLocationID long - -
LocationValid string - -
BranchID long - -
BAccountID long - -
BaseCuryID string - -
AddressID long - -
ContactID long - -
BuildingID long - -
NoteID guid - -
NoteText string - -
ReplenishmentClassID string - -
AvgDefaultCost string - -
FIFODefaultCost string - -
OverrideInvtAccSub boolean - -
Active boolean - -
CreatedByID guid - -
CreatedByScreenID string - -
CreatedDateTime datetime - -
LastModifiedByID guid - -
LastModifiedByScreenID string - -
Included boolean - -
UseItemDefaultLocationForPicking boolean - -
CarrierFacility long - -
Secured boolean - -
LastModifiedDateTime datetime - -
Tstamp string - -

INSiteStatus

Documentation: https://help.acumatica.com/dacBrowser/PX.Objects.IN/INSiteStatus

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
InventoryID long InventoryItem → InventoryID -
SiteID long INSite → SiteID -
SubItemID long -
  • 15 Jul 2024 Note that the SubItemID field can be NULL, but is still a valid RemoteID component
QtyOnHand decimal - -
QtyNotAvail decimal - -
QtyExpired decimal - -
QtyAvail decimal - -
QtyHardAvail decimal - -
QtyActual decimal - -
QtyInTransit decimal - -
QtyInTransitToSO decimal - -
QtyPOPrepared decimal - -
QtyPOOrders decimal - -
QtyPOReceipts decimal - -
QtyFSSrvOrdBooked decimal - -
QtyFSSrvOrdAllocated decimal - -
QtyFSSrvOrdPrepared decimal - -
QtySOBackOrdered decimal - -
QtySOPrepared decimal - -
QtySOBooked decimal - -
QtySOShipped decimal - -
QtySOShipping decimal - -
QtyINIssues decimal - -
QtyINReceipts decimal - -
QtyINAssemblyDemand decimal - -
QtyINAssemblySupply decimal - -
QtyInTransitToProduction decimal - -
QtyProductionSupplyPrepared decimal - -
QtyProductionSupply decimal - -
QtyPOFixedProductionPrepared decimal - -
QtyPOFixedProductionOrders decimal - -
QtyProductionDemandPrepared decimal - -
QtyProductionDemand decimal - -
QtyProductionAllocated decimal - -
QtySOFixedProduction decimal - -
QtyProdFixedPurchase decimal - -
QtyProdFixedProduction decimal - -
QtyProdFixedProdOrdersPrepared decimal - -
QtyProdFixedProdOrders decimal - -
QtyProdFixedSalesOrdersPrepared decimal - -
QtyProdFixedSalesOrders decimal - -
QtyINReplaned decimal - -
QtyFixedFSSrvOrd decimal - -
QtyPOFixedFSSrvOrd decimal - -
QtyPOFixedFSSrvOrdPrepared decimal - -
QtyPOFixedFSSrvOrdReceipts decimal - -
QtySOFixed decimal - -
QtyPOFixedOrders decimal - -
QtyPOFixedPrepared decimal - -
QtyPOFixedReceipts decimal - -
QtySODropShip decimal - -
QtyPODropShipOrders decimal - -
QtyPODropShipPrepared decimal - -
QtyPODropShipReceipts decimal - -
LastModifiedDateTime datetime - -
Tstamp string - -

INTran

Documentation: https://help.acumatica.com/dacBrowser/PX.Objects.IN/INTran

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
RefNbr string INRegister → RefNbr -
DocType string - -
LineNbr long - -
BranchID long - -
OrigModule string - -
TranType string - -
SortOrder long - -
TranDate datetime - -
IsIntercompany boolean - -
POLineType string - -
InvtMult decimal - -
IsStockItem boolean - -
InventoryID long InventoryItem → InventoryID -
SiteID long INSite → SiteID -
LocationID long - -
BAccountID long - -
DestBranchID long - -
SOOrderType string - -
SOOrderNbr string - -
SOOrderLineNbr long - -
CostCenterID long - -
CostCodeID string - -
OrigDocType string - -
OrigTranType string - -
OrigRefNbr string - -
OrigLineNbr long - -
OrigToLocationID long - -
OrigIsLotSerial boolean - -
OrigNoteID guid - -
AcctID long GLAccount → AccountID -
SubID long - -
ReclassificationProhibited boolean - -
InvtAcctID long GLAccount → AccountID -
InvtSubID long - -
COGSAcctID long GLAccount → AccountID -
COGSSubID long - -
ToSiteID long INSite → SiteID -
ToLocationID long - -
LotSerialNbr string - -
ExpireDate datetime - -
UOM string - -
Qty decimal - -
Released boolean - -
ReleasedDateTime datetime - -
FinPeriodID string - -
TranPeriodID string - -
UnitPrice decimal - -
TranAmt decimal - -
ExactCost boolean - -
ManualCost boolean - -
UnitCost decimal - -
OverrideUnitCost decimal - -
AvgCost decimal - -
TranCost decimal - -
TranDesc string - -
AccrueCost boolean - -
ReasonCode string - -
OrigQty decimal - -
BaseQty decimal - -
MaxTransferBaseQty decimal - -
UnassignedQty decimal - -
CostedQty decimal - -
OrigTranCost decimal - -
OrigTranAmt decimal - -
ARDocType string - -
ARRefNbr string - -
ARLineNbr long - -
SOShipmentType string - -
SOShipmentNbr string - -
SOShipmentLineNbr long - -
SOLineType string - -
UpdateShippedNotInvoiced boolean - -
POReceiptType string - -
POReceiptNbr string - -
POReceiptLineNbr long - -
AssyType string - -
OrigPlanType string - -
ToCostCodeID string - -
ToCostCenterID long - -
ReceiptedBaseQty decimal - -
INTransitBaseQty decimal - -
ReceiptedQty decimal - -
INTransitQty decimal - -
IsCostUnmanaged boolean - -
HasMixedProjectTasks boolean - -
IsComponentItem boolean - -
NoteID guid - -
NoteText string - -
PIID string - -
PILineNbr long - -
OrigUOM string - -
OrigFullQty decimal - -
BaseOrigFullQty decimal - -
CreatedByID guid - -
CreatedByScreenID string - -
CreatedDateTime datetime - -
LastModifiedByID guid - -
LastModifiedByScreenID string - -
LastModifiedDateTime datetime - -
SalesMult decimal - -
SrvOrdType string - -
AppointmentRefNbr string - -
AppointmentLineNbr long - -
ServiceOrderRefNbr string - -
ServiceOrderLineNbr long - -
ServiceContractRefNbr string - -
ServiceContractPeriodID string - -
Tstamp string - -

InventoryItem

Documentation: https://help.acumatica.com/dacBrowser/PX.Objects.IN/InventoryItem

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
InventoryID long - -
InventoryCD string StockItem → InventoryID -
IsConverted boolean - -
IsConversionMode boolean - -
StkItem boolean - -
Descr string - -
ItemClassID long - -
ParentItemClassID long - -
ItemStatus string - -
ItemType string - -
ValMethod string - -
TaxCategoryID string - -
TaxCalcMode string - -
WeightItem boolean - -
BaseUnit string - -
SalesUnit string - -
PurchaseUnit string - -
DecimalBaseUnit boolean - -
DecimalSalesUnit boolean - -
DecimalPurchaseUnit boolean - -
Commisionable boolean - -
ReasonCodeSubID long - -
SalesAcctID long GLAccount → AccountID -
SalesSubID long - -
InvtAcctID long GLAccount → AccountID -
InvtSubID long - -
COGSAcctID long GLAccount → AccountID -
COGSSubID long - -
ExpenseAccrualAcctID long - -
ExpenseAccrualSubID long - -
ExpenseAcctID long - -
ExpenseSubID long - -
StdCstRevAcctID long - -
StdCstRevSubID long - -
StdCstVarAcctID long - -
StdCstVarSubID long - -
PPVAcctID long GLAccount → AccountID -
PPVSubID long - -
POAccrualAcctID long GLAccount → AccountID -
POAccrualSubID long - -
LCVarianceAcctID long GLAccount → AccountID -
LCVarianceSubID long - -
DeferralAcctID long GLAccount → AccountID -
DeferralSubID long - -
LastSiteID long - -
LastStdCost decimal - -
PendingStdCost decimal - -
PendingStdCostDate datetime - -
StdCost decimal - -
StdCostDate datetime - -
BasePrice decimal - -
BaseWeight decimal - -
BaseVolume decimal - -
BaseItemWeight decimal - -
BaseItemVolume decimal - -
WeightUOM string - -
VolumeUOM string - -
PackSeparately boolean - -
PackageOption string - -
PreferredVendorID long - -
PreferredVendorLocationID long - -
DefaultSubItemOnEntry boolean - -
DfltSiteID long INSite → SiteID -
DfltShipLocationID long - -
DfltReceiptLocationID long - -
ProductWorkgroupID long - -
ProductManagerID long - -
PriceWorkgroupID long - -
PriceManagerID long - -
NegQty boolean - -
OrigLotSerClassID string - -
LotSerClassID string - -
PostClassID string - -
DeferredCode string - -
DefaultTerm int - -
DefaultTermUOM string - -
PriceClassID string - -
IsSplitted boolean - -
UseParentSubID boolean - -
TotalPercentage decimal - -
KitItem boolean - -
MinGrossProfitPct decimal - -
NonStockReceipt boolean - -
NonStockReceiptAsService boolean - -
NonStockShip boolean - -
AccrueCost boolean - -
CostBasis string - -
PercentOfSalesPrice decimal - -
CompletePOLine string - -
ABCCodeID string - -
ABCCodeIsFixed boolean - -
MovementClassID string - -
MovementClassIsFixed boolean - -
MarkupPct decimal - -
RecPrice decimal - -
ImageUrl string - -
CommodityCodeType string - -
HSTariffCode string - -
UndershipThreshold decimal - -
OvershipThreshold decimal - -
CountryOfOrigin string - -
NoteID string - -
NoteText string - -
NotePopupText string - -
CreatedByID string - -
CreatedByScreenID string - -
CreatedDateTime datetime - -
LastModifiedByID string - -
LastModifiedByScreenID string - -
LastModifiedDateTime datetime - -
Tstamp string - -

InventoryItemCurySettings

Documentation: https://help.acumatica.com/dacBrowser/PX.Objects.IN/InventoryItemCurySettings

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
InventoryID long InventoryItem → InventoryID -
CuryID string - -
LastStdCost decimal - -
PendingStdCost decimal - -
PendingStdCostDate datetime - -
StdCost decimal - -
StdCostDate datetime - -
BasePrice decimal - -
RecPrice decimal - -
DfltSiteID long INSite → SiteID -
DfltShipLocationID long - -
DfltReceiptLocationID long - -
PreferredVendorID long - -
PreferredVendorLocationID long - -
CreatedByID string - -
CreatedByScreenID string - -
CreatedDateTime datetime - -
LastModifiedByID string - -
LastModifiedDateTime datetime - -
Tstamp string - -

Organization

Documentation: https://help.acumatica.com/dacBrowser/PX.Objects.GL.DAC/Organization

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Name string - -
OrganizationCD string - -
OrganizationID long - -
BAccountID long - -
OrganizationType string - -
FileTaxesByBranches boolean - -
ForeignEntity boolean - -
CFSFiler boolean - -
ContactName string - -
BaseCuryID string - -
Status string - -
OrganizationName string - -
CountryID string - -
OrganizationLocalizationCode string - -
CTelNumber string - -
CEmail string - -
Reporting1099 boolean - -
Reporting1099ByBranches boolean - -
CreatedDateTime datetime - -
CreatedByID string - -
CreatedByScreenID string - -
LastModifiedDateTime datetime - -
LastModifiedByID string - -
LastModifiedByScreenID string - -
Included boolean - -
NoteText string - -
NoteID string - -
CDFid string - -
AbnBranchNumber string - -
Tstamp string - -

SOShipLine

Documentation: https://help.acumatica.com/dacBrowser/PX.Objects.SO/SOShipLine

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ShipmentNbr string SOShipment → ShipmentNbr -
ShipmentType string - -
LineNbr long - -
SortOrder long - -
CustomerID long - -
ShipDate datetime - -
Confirmed boolean - -
Released boolean - -
LineType string - -
OrigOrderType string - -
OrigOrderNbr string - -
OrigLineNbr long - -
OrigSplitLineNbr long - -
Operation string - -
SOLineSign decimal - -
OrigPlanType string - -
InvtMult decimal - -
IsStockItem boolean - -
InventoryID long InventoryItem → InventoryID -
IsIntercompany boolean - -
TranType string - -
PlanType string - -
SiteID long INSite → SiteID -
LocationID long - -
LotSerialNbr string - -
ExpireDate datetime - -
OrderUOM string - -
UOM string - -
ShippedQty decimal - -
BaseShippedQty decimal - -
BaseOriginalShippedQty decimal - -
OriginalShippedQty decimal - -
UnassignedQty decimal - -
CompleteQtyMin decimal - -
BaseOrigOrderQty decimal - -
OrigOrderQty decimal - -
OpenOrderQty decimal - -
FullOrderQty decimal - -
BaseFullOrderQty decimal - -
UnitCost decimal - -
ExtCost decimal - -
UnitPrice decimal - -
DiscPct decimal - -
LineAmt decimal - -
AlternateID string - -
TranDesc string - -
UnitWeigth decimal - -
UnitVolume decimal - -
ExtWeight decimal - -
ExtVolume decimal - -
ProjectID long - -
TaskID long - -
CostCodeID string - -
ReasonCode string - -
IsFree boolean - -
ManualPrice boolean - -
ManualDisc boolean - -
IsUnassigned boolean - -
DiscountID string - -
DiscountSequenceID string - -
KeepManualFreight boolean - -
ShipComplete string - -
RequireINUpdate boolean - -
PickedQty decimal - -
BasePickedQty decimal - -
PackedQty decimal - -
BasePackedQty decimal - -
NoteID guid - -
NoteText string - -
CreatedByID guid - -
CreatedByScreenID string - -
CreatedDateTime datetime - -
LastModifiedByID guid - -
LastModifiedByScreenID string - -
LastModifiedDateTime datetime - -
BlanketType string - -
BlanketNbr string - -
BlanketLineNbr long - -
BlanketSplitLineNbr long - -
IsSpecialOrder boolean - -
CostCenterID long - -
HasMixedProjectTasks boolean - -
Tstamp string - -

SOShipment

Documentation: https://help.acumatica.com/dacBrowser/PX.Objects.SO/SOShipment

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ShipmentNbr string - -
ShipDate datetime - -
Operation string - -
ShipmentType string - -
CustomerID long - -
CustomerLocationID long - -
CustomerOrderNbr string - -
SiteID long INSite → SiteID -
SiteBranchID long - -
DestinationSiteID long INSite → SiteID -
ShipmentDesc string - -
ShipAddressID long - -
ShipContactID long - -
FOBPoint string - -
ShipVia string - -
WillCall boolean - -
UseCustomerAccount boolean - -
Resedential boolean - -
SaturdayDelivery boolean - -
Insurance boolean - -
GroundCollect boolean - -
LabelsPrinted boolean - -
CommercialInvoicesPrinted boolean - -
PickListPrinted boolean - -
ConfirmationPrinted boolean - -
ShippedViaCarrier boolean - -
ShipTermsID string - -
ShipZoneID string - -
LineTotal decimal - -
CuryID string - -
CuryInfoID long - -
CuryFreightCost decimal - -
FreightCost decimal - -
OverrideFreightAmount boolean - -
FreightAmountSource string - -
CuryFreightAmt decimal - -
FreightAmt decimal - -
CuryPremiumFreightAmt decimal - -
PremiumFreightAmt decimal - -
CuryTotalFreightAmt decimal - -
TotalFreightAmt decimal - -
TaxCategoryID string - -
NoteID guid - -
NoteText string - -
Hold boolean - -
Confirmed boolean - -
ConfirmedToVerify boolean - -
Released boolean - -
Picked boolean - -
PickedViaWorksheet boolean - -
PickedQty decimal - -
PackedQty decimal - -
Status string - -
LineCntr long - -
OrderCntr long - -
BilledOrderCntr long - -
UnbilledOrderCntr long - -
ReleasedOrderCntr long - -
ControlQty decimal - -
ShipmentQty decimal - -
ShipmentWeight decimal - -
ShipmentVolume decimal - -
PackageLineCntr long - -
PackageWeight decimal - -
IsPackageValid boolean - -
RecalcPackagesReason long - -
PackageCount long - -
IsManualPackage boolean - -
IsPackageContentDeleted boolean - -
CreatedByID guid - -
CreatedByScreenID string - -
CreatedDateTime datetime - -
LastModifiedByID guid - -
LastModifiedByScreenID string - -
LastModifiedDateTime datetime - -
GotReadyForArchiveAt datetime - -
Hidden boolean - -
WorkgroupID long - -
OwnerID long - -
FreeItemQtyTot decimal - -
StatusIsNull string - -
BillSeparately boolean - -
ConfirmedByID guid - -
ConfirmedDateTime datetime - -
CreateARDoc boolean - -
CurrentWorksheetNbr string - -
IsIntercompany boolean - -
IntercompanyPOReceiptNbr string - -
ExcludeFromIntercompanyProc boolean - -
Excluded boolean - -
ShipViaUpdateFromShopForRate boolean - -
ExtCarrierPlugIn string - -
ExtCarrierServiceMethod string - -
ShipperCountry string - -
FreightClass string - -
SkipAddressVerification boolean - -
ManifestNbr string - -
TermsOfSale string - -
EndorsementService string - -
DeliveryConfirmation string - -
DHLBillingRef string - -
IsFSRelated boolean - -
Installed boolean - -
CuryRate decimal - -
CuryViewState string - -
Tstamp string - -

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 - -
NoteID 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 - -
NoteID string - -
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 - -
NoteID 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 - -
NoteID string - -
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 - -
NoteID string - -
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 -
NoteID string - -
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 - -
NoteID string - -
CreatedDateTime datetime - -
LastModifiedDateTime datetime - -
RowNumber int - -
Note string - -

Invoice

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID string - -
Description string - -
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 - -
Amount decimal - -
NoteID string - -
CreatedDateTime datetime - -
LastModifiedDateTime datetime - -
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 - -
NoteID string - -
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 - -
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 - -
LastModifiedDateTime datetime - -
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 - -
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 - -
Date datetime - -
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 - -
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 - -
Approved boolean - -
LastModified datetime - -
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 - -
NoteID string - -
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 - -

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 -
NoteID string - -
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 - -

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 -
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 -

Need more?

SyncHub lives and breathes APIs and data. Keep exploring using the links below.

Connect your own MYOB Acumatica (Advanced) data Interactive ERD Querying MYOB Acumatica (Advanced) using regular SQL