Power BI Connector for Acumatica

Build 24.0.9060

SalesOrder

SalesOrder is an auto-generated table.

Columns

Name Type ReadOnly Description
Id [KEY] String True

LinkedShipToContact String False

OrderNbr [KEY] String False

CurrencyID String False

TaxTotal Double False

Status String False

CurrencyRate Double False

LinkedBillToContact String False

PaymentMethod String False

ControlTotal Double False

VATTaxableTotal Double False

ShipToAddressOverride Bool False

CustomerID String False

PreferredWarehouseID String False

OrderTotal Double False

PreAuthorizationNbr String False

BaseCurrencyID String False

Description String False

BillToAddressValidated Bool False

EffectiveDate Datetime False

IsTaxValid Bool False

BillToContactOverride Bool False

PreAuthorizedAmount Double False

LinkedShipments String False

Hold Bool False

CurrencyRateTypeID String False

LastModified Datetime False

LocationID String False

CreditHold Bool False

ShipToAddressValidated Bool False

LinkedShipToAddress String False

LinkedCommissions String False

LinkedDiscountDetails String False

CashAccount String False

ReciprocalRate Double False

OrderType [KEY] String False

LinkedBillToAddress String False

PaymentCardIdentifier String False

CustomerOrder String False

VATExemptTotal Double False

ExternalRef String False

BillToAddressOverride Bool False

LinkedDetails String False

NewCard Bool False

Date Datetime False

DestinationWarehouseID String False

LinkedPayments String False

PaymentRef String False

OrderedQty Double False

LinkedShippingSettings String False

Approved Bool False

ShipToContactOverride Bool False

ShipVia String False

RequestedOn Datetime False

LinkedTaxDetails String False

LinkedTotals String False

Project String False

LinkedFinancialSettings String False

Custom_CurrentDocument_CuryPremiumFreightAmt String False

Custom_CurrentDocument_DueDate String False

Custom_CurrentDocument_CuryDiscTot String False

Custom_CurrentDocument_CuryUnpaidBalance String False

Custom_CurrentDocument_PackageWeight String False

Custom_CurrentDocument_OverrideTaxZone Bool False

Custom_CurrentDocument_AvalaraCustomerUsageType String False

Custom_CurrentDocument_CuryOpenOrderTotal String False

Custom_CurrentDocument_CuryFreightCost String False

Custom_CurrentDocument_Insurance Bool False

Custom_CurrentDocument_CCAuthExpirationDate String False

Custom_CurrentDocument_CuryTaxTotal String False

Custom_CurrentDocument_CreatePMInstance Bool False

Custom_CurrentDocument_CuryPaymentTotal String False

Custom_CurrentDocument_PreAuthTranNumber String False

Custom_DefPaymentMethodInstance_NoteID String False

Custom_CurrentDocument_CancelDate String False

Custom_CurrentDocument_PMInstanceID Int False

Custom_CurrentDocument_FOBPoint String False

Custom_CurrentDocument_ExtRefNbr String False

Custom_CurrentDocument_GroundCollect Bool False

Custom_CurrentDocument_CuryMiscTot String False

Custom_CurrentDocument_Emailed Bool False

Custom_CurrentDocument_PaymentMethodID String False

Custom_Document_DontApprove Bool False

Custom_CurrentDocument_CCPaymentStateDescr String False

Custom_CurrentDocument_CuryUnbilledOrderTotal String False

Custom_CurrentDocument_CaptureTranNumber String False

Custom_CurrentDocument_UseCustomerAccount Bool False

Custom_CurrentDocument_OrigOrderType String False

Custom_CurrentDocument_FreightCostIsValid Bool False

Custom_CurrentDocument_DefaultSiteID String False

Custom_CurrentDocument_UnbilledOrderQty String False

Custom_CurrentDocument_Cancelled Bool False

Custom_CurrentDocument_OrigOrderNbr String False

Custom_CurrentDocument_PMInstanceID_description String False

Custom_CurrentDocument_CuryFreightAmt String False

Custom_CurrentDocument_OrderVolume String False

Custom_CurrentDocument_CCCardNumber String False

Custom_CurrentDocument_CuryCCPreAuthAmount String False

Custom_CurrentDocument_RefTranExtNbr String False

Custom_CurrentDocument_WillCall Bool False

Custom_CurrentDocument_FinPeriodID String False

Custom_CurrentDocument_OrderWeight String False

Custom_Document_CuryViewState Bool False

Custom_CurrentDocument_ShipZoneID String False

Custom_CurrentDocument_CuryLineTotal String False

Custom_CurrentDocument_ShipComplete String False

Custom_CurrentDocument_FreightTaxCategoryID String False

Custom_CurrentDocument_PCResponseReasonText String False

Custom_CurrentDocument_Resedential Bool False

Custom_CurrentDocument_NoteID String False

Custom_Document_NoteText String False

Custom_CurrentDocument_ShipDate String False

Custom_CurrentDocument_ShipTermsID String False

Custom_CurrentDocument_CashAccountID String False

Custom_DefPaymentMethodInstance_CCProcessingCenterID String False

Custom_CurrentDocument_ShipVia String False

Custom_Document_NoteID String False

Custom_CurrentDocument_SaturdayDelivery Bool False

Custom_CurrentDocument_CampaignID String False

Custom_CurrentDocument_TermsID String False

Custom_CurrentDocument_ShipSeparately Bool False

Custom_CurrentDocument_OwnerID String False

Custom_CurrentDocument_OpenOrderQty String False

Custom_CurrentDocument_TaxZoneID String False

Custom_CurrentDocument_BillSeparately Bool False

Custom_CurrentDocument_InvoiceNbr String False

Custom_CurrentDocument_Priority Int False

Custom_CurrentDocument_DiscDate String False

Custom_CurrentDocument_BranchID String False

Custom_CurrentDocument_InvoiceDate String False

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060