Defines the common properties for all sales document lines in the Sales Order Processing module of Microsoft Dynamics GP.
Property |
Type |
Length |
Default |
Description |
---|---|---|---|---|
Key |
N/A |
N/A |
The sales line key object that uniquely identifies a sales line. |
|
UnitPrice |
N/A |
0 |
The unit price of the item. |
|
TotalAmount |
N/A |
If not provided, set to UnitPrice x Quantity. |
The extended price for the sales line. |
|
Quantity |
N/A |
0 |
The quantity for the sales line. |
|
Discount |
N/A |
Default from sales document, otherwise 0. |
The type and amount of the markdown for the sales line. The markdown amount can be a money amount or a percent. |
|
UnitCost |
N/A |
Default from item if a return document line, otherwise 0. |
The unit cost of a non-inventory item or an item on a return document line. |
|
ItemDescription |
string |
100 |
Empty |
The description of the item on the sales line. |
IsNonInventory |
boolean |
N/A |
False |
Indicates whether the item on the sales line is not an inventory item.True indicates it is non-inventory item. False indicates it is an inventory item. |
IsDropShip |
boolean |
N/A |
False |
Indicates whether the item is a drop ship item. True indicates it is a drop ship item. False indicates it is not. The drop ship status must be set to False for a negative quantity invoice item. |
RequestedShipDate |
dateTime |
N/A |
If not provided, defaults to the document date. |
The date on which the item should be shipped. |
Comment |
string |
N/A |
Empty |
A comment on the sales line. |
UofM |
string |
8 |
Empty |
The unit of measure for the sales line. |
DeleteOnUpdate |
boolean |
N/A |
False |
Set to True when calling the Update operation to remove the sales line. |
ExtendedCost |
N/A |
Set to Quantity x UnitCost |
The extended cost of the sales line. This property is read-only. |
|
ItemTaxScheduleKey |
N/A |
N/A |
The tax schedule key object that uniquely identifies the item tax schedule for a sales line. This property is read-only. |
|
TaxBasis |
N/A |
N/A |
A tax option which will determine whether the item on the sales line is taxable. If it is taxable, it also specifies which tax schedule will be used. If the tax option for the item is Taxable, the tax schedule for the line item is compared to the item tax schedule. Taxes will be calculated for tax details found in both schedules. If the tax option for the item is Nontaxable, no tax is calculated for that item. If the tax option for the item is Based on Customer, the line item's tax schedule is used for calculating taxes for item. This property is read-only. |
|
TaxAmount |
N/A |
Sum of the tax details for the line. |
The tax amount for the sales line. This property is read-only. |
|
TaxScheduleKey |
N/A |
N/A |
The tax schedule key object that uniquely identifies the sales tax schedule for a sales line. This property is read-only. |
|
CostOfSalesGLAccount |
N/A |
N/A |
The GL account number key object that specifies the account to which cost of sales amounts for this sales line will be posted. This property is read-only. |
|
DamagedGLAccountKey |
N/A |
N/A |
The GL account number key object that specifies the account to which damaged goods costs for this sales line will be posted. This property is read-only. |
|
InServiceGLAccountKey |
N/A |
N/A |
The GL account number key object that specifies the account that will be updated when you enter a return document line and return some part of the total item quantity to the In Service quantity type. This property is read-only. |
|
InUseGLAccountKey |
N/A |
N/A |
The GL account number key object that specifies the account that will be updated when you enter a return document line and return some part of the total item quantity to the In Use quantity type. This property is read-only. |
|
InventoryGLAccountKey |
N/A |
N/A |
The GL account number key object that specifies the account to which inventory amounts for this sales line will be posted. This property is read-only. |
|
DiscountGLAccountKey |
N/A |
N/A |
The GL account number key object that specifies the account to which discount (markdown) amounts for this sales line will be posted. This property is read-only. |
|
ReturnsGLAccountKey |
N/A |
N/A |
The GL account number key object that specifies the account to which return amounts for this sales line will be posted. This property is read-only. |
|
SalesGLAccountKey |
N/A |
N/A |
The GL account number key object that specifies the account to which sales amounts for this sales line will be posted. This property is read-only. |
|
FrontOfficeIntegrationId |
string |
|
|
|
IntegrationSource |
int |
|
|
|
IntegrationId |
string |
|
|
|
WarehouseKey |
N/A |
If not provided, set based on the Default Warehouse Behavior option specified. |
The warehouse key object that uniquely identifies the warehouse for a sales line. |
|
ItemKey |
N/A |
N/A |
The item key object that uniquely identifies the item for a sales line. |
|
ShippingMethodKey |
N/A |
If not provided, defaults from Sales Document. |
The shipping method key object that uniquely identifies the shipping method for a sales line. |
|
SalesTerritoryKey |
N/A |
N/A |
The sales territory key object that uniquely identifies the sales territory for a sales line. |
|
SalespersonKey |
N/A |
If not provided, defaults from ship to address on the sales line. |
The salesperson key object that uniquely identifies the salesperson for a sales line. |
|
CommentKey |
N/A |
N/A |
The comment key object that uniquely identifies the comment for a sales line. |
|
PriceLevelKey |
N/A |
N/A |
The price level key object that uniquely identifies the price level for a sales line. |
|
ShipToAddressKey |
N/A |
N/A |
The customer address key object that uniquely identifies the ship to address for a sales line. |
|
ShipToAddress |
N/A |
If nothing is supplied, the default will be supplied from the “ship to” address on the SalesDocument. If any one of the following are supplied, the remaining that are not supplied will default to blank: BusinessAddress.Name Address.Line1 Address.Line2 Address.Line3 Address.City Address.State Address.PostalCode Address.Country BusinessAddress.ContactPerson Address.Phone1 Address.Phone2 Address.Phone3 Address.Fax
|
The address details of the ship to address for the sales line. |
|
Taxes |
N/A |
N/A |
A collection a tax details for a sales line. |