SalesOrderLines
Return a list of: SalesOrderLines
Columns
Name | Type | Description |
ExtensionsExtensionAggregate | String | |
ActualShipDate | Datetime | |
AuditTrailCode | String | |
BackorderDate | Datetime | |
BatchKeyCreatedDateTime | Datetime | |
BatchId | String | |
BatchKeySource | String | |
BillToAddressKeyCustomerId | String | |
BillToAddressId | String | |
Comment | String | |
CommentId | String | |
CommissionAmountCurrency | String | |
CommissionAmount | Decimal | |
CommissionBasedOn | String | |
CommissionSaleAmountCurrency | String | |
CommissionSaleAmount | Decimal | |
CommissionsAggregate | String | |
CreatedBy | String | |
CreatedDate | Datetime | |
CurrencyKeyISOCode | String | |
CustomerId | String | |
CustomerName | String | |
CustomerPONumber | String | |
Date | Datetime | |
DiscountAmountCurrency | String | |
DiscountAmount | Decimal | |
DocumentTypeId | String | |
DocumentTypeKeyType | String | |
ExchangeDate | Datetime | |
ExchangeRate | Decimal | |
FreightAmountCurrency | String | |
FreightAmount | Decimal | |
FreightTaxAmountCurrency | String | |
FreightTaxAmount | Decimal | |
FreightTaxBasis | String | |
FreightTaxScheduleId | String | |
FreightTaxesAggregate | String | |
FrontOfficeIntegrationId | String | |
FulfillDate | Datetime | |
IntegrationId | String | |
IntegrationSource | Int | |
InvoiceDate | Datetime | |
IsIntrastatDocument | Bool | |
IsVoided | Bool | |
Id | String | |
LastModifiedDate | Datetime | |
LineTotalAmountCurrency | String | |
LineTotalAmount | Decimal | |
MasterNumber | Int | |
MiscellaneousAmountCurrency | String | |
MiscellaneousAmount | Decimal | |
MiscellaneousTaxAmountCurrency | String | |
MiscellaneousTaxAmount | Decimal | |
MiscellaneousTaxBasis | String | |
MiscellaneousTaxScheduleId | String | |
MiscellaneousTaxesAggregate | String | |
ModifiedDate | Datetime | |
Note | String | |
OriginalSalesDocumentId | String | |
OriginalSalesDocumentType | String | |
PaymentTermsId | String | |
PriceLevelId | String | |
ProcessHoldsAggregate | String | |
QuoteDate | Datetime | |
Reference | String | |
RequestedShipDate | Datetime | |
ReturnDate | Datetime | |
SalesTerritoryId | String | |
SalespersonId | String | |
ShipCompleteOnly | Bool | |
ShipToAddressExtensionsExtensionAggregate | String | |
ShipToAddressCity | String | |
ShipToAddressLine1 | String | |
ShipToAddressLine2 | String | |
ShipToAddressLine3 | String | |
ShipToAddressPostalCode | String | |
ShipToAddressState | String | |
ShipToAddressCountryRegion | String | |
ShipToAddressFaxCountryCode | String | |
ShipToAddressFaxExtension | String | |
ShipToAddressFax | String | |
ShipToAddressPhone1CountryCode | String | |
ShipToAddressPhone1Extension | String | |
ShipToAddressPhone1 | String | |
ShipToAddressPhone2CountryCode | String | |
ShipToAddressPhone2Extension | String | |
ShipToAddressPhone2 | String | |
ShipToAddressPhone3CountryCode | String | |
ShipToAddressPhone3Extension | String | |
ShipToAddressPhone3 | String | |
ShipToAddressCountryRegionCodeId | String | |
ShipToAddressContactPerson | String | |
ShipToAddressName | String | |
ShipToAddressKeyCustomerId | String | |
ShipToAddressId | String | |
ShippingMethodId | String | |
TaxAmountCurrency | String | |
TaxAmount | Decimal | |
TaxExemptNumber1 | String | |
TaxExemptNumber2 | String | |
TaxRegistrationNumber | String | |
TaxScheduleId | String | |
TaxesAggregate | String | |
TotalAmountCurrency | String | |
TotalAmount | Decimal | |
TrackingNumbersAggregate | String | |
TradeDiscountItem | String | |
TransactionState | String | |
Type | String | |
UPSZone | String | |
UserDefinedDate01 | Datetime | |
UserDefinedDate02 | Datetime | |
UserDefinedList01 | String | |
UserDefinedList02 | String | |
UserDefinedList03 | String | |
UserDefinedText01 | String | |
UserDefinedText02 | String | |
UserDefinedText03 | String | |
UserDefinedText04 | String | |
UserDefinedText05 | String | |
WarehouseId | String | |
DaysToIncrement | Int | |
DepositAmountCurrency | String | |
DepositAmount | Decimal | |
DocumentFrequency | String | |
IsRepeating | Bool | |
LinesExtensionsExtensionAggregate | String | |
LinesComment | String | |
LinesCommentId | String | |
LinesCostOfSalesGLAccountId | String | |
LinesCostOfSalesGLAccountKeyIsEncrypted | Bool | |
LinesDamagedGLAccountId | String | |
LinesDamagedGLAccountKeyIsEncrypted | Bool | |
LinesDeleteOnUpdate | Bool | |
LinesDiscountItem | String | |
LinesDiscountGLAccountId | String | |
LinesDiscountGLAccountKeyIsEncrypted | Bool | |
LinesExtendedCostCurrency | String | |
LinesExtendedCost | Decimal | |
LinesFrontOfficeIntegrationId | String | |
LinesInServiceGLAccountId | String | |
LinesInServiceGLAccountKeyIsEncrypted | Bool | |
LinesInUseGLAccountId | String | |
LinesInUseGLAccountKeyIsEncrypted | Bool | |
LinesIntegrationId | String | |
LinesIntegrationSource | Int | |
LinesInventoryGLAccountId | String | |
LinesInventoryGLAccountKeyIsEncrypted | Bool | |
LinesIsDropShip | Bool | |
LinesIsNonInventory | Bool | |
LinesItemDescription | String | |
LinesItemId | String | |
LinesItemTaxScheduleId | String | |
LinesKeyLineSequenceNumber [KEY] | Int | |
LinesKeySalesDocumentId [KEY] | String | |
LinesPriceLevelId | String | |
LinesQuantity | Decimal | |
LinesRequestedShipDate | Datetime | |
LinesReturnsGLAccountId | String | |
LinesReturnsGLAccountKeyIsEncrypted | Bool | |
LinesSalesGLAccountId | String | |
LinesSalesGLAccountKeyIsEncrypted | Bool | |
LinesSalesTerritoryId | String | |
LinesSalespersonId | String | |
LinesShipToAddressExtensionsExtensionAggregate | String | |
LinesShipToAddressCity | String | |
LinesShipToAddressLine1 | String | |
LinesShipToAddressLine2 | String | |
LinesShipToAddressLine3 | String | |
LinesShipToAddressPostalCode | String | |
LinesShipToAddressState | String | |
LinesShipToAddressCountryRegion | String | |
LinesShipToAddressFaxCountryCode | String | |
LinesShipToAddressFaxExtension | String | |
LinesShipToAddressFax | String | |
LinesShipToAddressPhone1CountryCode | String | |
LinesShipToAddressPhone1Extension | String | |
LinesShipToAddressPhone1 | String | |
LinesShipToAddressPhone2CountryCode | String | |
LinesShipToAddressPhone2Extension | String | |
LinesShipToAddressPhone2 | String | |
LinesShipToAddressPhone3CountryCode | String | |
LinesShipToAddressPhone3Extension | String | |
LinesShipToAddressPhone3 | String | |
LinesShipToAddressCountryRegionCodeId | String | |
LinesShipToAddressContactPerson | String | |
LinesShipToAddressName | String | |
LinesShipToAddressKeyCustomerId | String | |
LinesShipToAddressId | String | |
LinesShippingMethodId | String | |
LinesTaxAmountCurrency | String | |
LinesTaxAmount | Decimal | |
LinesTaxBasis | String | |
LinesTaxScheduleId | String | |
LinesTaxesAggregate | String | |
LinesTotalAmountCurrency | String | |
LinesTotalAmount | Decimal | |
LinesUnitCostCurrency | String | |
LinesUnitCost | Decimal | |
LinesUnitPriceCurrency | String | |
LinesUnitPrice | Decimal | |
LinesUofM | String | |
LinesWarehouseId | String | |
LinesActualShipDate | Datetime | |
LinesBinsAggregate | String | |
LinesComponentsAggregate | String | |
LinesFulfillDate | Datetime | |
LinesLotsAggregate | String | |
LinesQuantityAllocated | Decimal | |
LinesQuantityCanceled | Decimal | |
LinesQuantityFulfilled | Decimal | |
LinesQuantityToBackorder | Decimal | |
LinesQuantityToInvoice | Decimal | |
LinesSerialsAggregate | String | |
PaymentAmountCurrency | String | |
PaymentAmount | Decimal | |
PaymentsAggregate | String | |
ShippingProcessStatus | String | |
TimesToRepeat | Int | |
WorkflowPriority | String | |
WorkflowsAggregate | String |
Pseudo-Columns
Pseudo-Column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
Name | Type | Description |
PagingColumn | String |