Power BI Connector for Acumatica

Build 24.0.9060

SalesOrder_Details

SalesOrder_Details is an auto-generated table.

Columns

Name Type Description
ParentGUID [KEY] String
ParentOrderType [KEY] String
ParentOrderNbr [KEY] String
OpenQty Double
AlternateID String
DiscountedUnitPrice Double
Operation String
ShippingRule String
Account String
ReasonCode String
WarehouseID String
UndershipThreshold Double
MarkForPO Bool
LineType String
SalespersonID String
UnitCost Double
QtyOnShipments Double
Subitem String
UnitPrice Double
POSource String
ProjectTask String
ManualDiscount Bool
Commissionable Bool
AverageCost Double
LineNbr Int
DiscountCode String
Branch String
UOM String
ShipOn Datetime
ExtendedPrice Double
TaxCategory String
FreeItem Bool
OrderQty Double
OvershipThreshold Double
LastModifiedDate String
Completed Bool
DiscountPercent Double
DiscountAmount Double
Location String
AutoCreateIssue Bool
RequestedOn Datetime
LineDescription String
InventoryID String
UnbilledAmount Double
Custom_Transactions_Availability String
Custom_Transactions_DRTermStartDate String
Custom_Transactions_DRTermEndDate String
Custom_Transactions_CuryUnitPriceDR String
Custom_Transactions_SalesSubID String
Custom_Transactions_IsStockItem Bool
Custom_Transactions_OrderType String
Custom_Transactions_CostCodeID String
Custom_Transactions_SortOrder Int
Custom_Transactions_OrderNbr String
Custom_Transactions_InvoiceNbr String
Custom_Transactions_ManualPrice Bool
Custom_Transactions_DiscountSequenceID String
Custom_Transactions_NoteText String
Custom_Transactions_NoteID String
Custom_Transactions_ExpireDate String
Custom_Transactions_DiscPctDR String
Custom_Transactions_BaseOrderQty String
Custom_Transactions_LotSerialNbr String

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