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

BAccount

Documentation: https://help.acumatica.com/dacBrowser/PX.Objects.CR/BAccount

Column	Type	Relates to	Notes
RemoteID	string	-	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
BAccountID	long	-	-
ParentBAccountID	long	BAccount → BAccountID	-
ConsolidatingBAccountID	long	BAccount → BAccountID	-
AcctName	string	-	-
AcctCD	string	-	-
AcctReferenceNbr	string	-	-
ClassID	string	-	-
Type	string	-	-
CampaignSourceID	string	-	-
TaxRegistrationID	string	-	-
IsCustomerOrCombined	boolean	-	-
IsBranch	boolean	-	-
ConsolidateToParent	boolean	-	-
AllowOverrideCury	boolean	-	-
AllowOverrideRate	boolean	-	-
CreatedDateTime	datetime	-	-
LastModifiedDateTime	datetime	-	-
LastModifiedByScreenID	string	-	-
CreatedByScreenID	string	-	-
DefaultUOM	string	-	-
NoteID	guid	-	-
NoteText	string	-	-
Status	string	-	-
VStatus	string	-	-
CuryID	string	Currency → CurrencyID	-
BaseCuryID	string	Currency → CurrencyID	-
CuryRateTypeID	string	-	-
LastModifiedByID	guid	-	-
CreatedByID	guid	-	-
OwnerID	long	-	-
DefAddressID	long	-	-
DefPOAddressID	long	-	-
DefLocationID	long	-	-
DefContactID	long	Contact → ContactID	-
PrimaryContactID	long	Contact → ContactID	-
Tstamp	string	-	-

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

User

Documentation: https://help.acumatica.com/dacBrowser/PX.SM/Users

Column	Type	Relates to	Notes
RemoteID	string	-	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
PKID	guid	-	-
DisplayName	string	-	-
Username	string	-	-
LastName	string	-	-
FirstName	string	-	-
FullName	string	-	-
ApplicationName	string	-	-
Email	string	-	-
Phone	string	-	-
Comment	string	-	-
Domain	string	-	-
ExtRef	string	-	-
CreationDate	datetime	-	-
LastLoginDate	datetime	-	-
Guest	boolean	-	-
IsApproved	boolean	-	-
IsAssigned	boolean	-	-
IsPendingActivation	boolean	-	-
LoginTypeID	long	-	-
ContactID	long	-	-
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	-