SO
SOFreightDetail
PX.Objects.SO35 of 35 fields
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
DocType | char(3) | - | ||
Description:No description available | ||||
OrderNbr | nvarchar(15) | Order Nbr. | SOOrder | |
Description:No description available | ||||
OrderType | char(2) | Order Type | SOOrderType | |
Description:No description available | ||||
RefNbr | nvarchar(15) | ARInvoice | ||
Description:No description available | ||||
ShipmentNbr | nvarchar(15) | Shipment Nbr. | SOOrderShipment | |
Description:No description available | ||||
ShipmentType | char(1) | Shipment Type | - | |
Description:No description available | ||||
AccountID | int | Account | Account | |
Description:No description available | ||||
CreatedByID | uniqueidentifier | Created By | Users | |
Description:No description available | ||||
CreatedByScreenID | char(8) | - | ||
Description:No description available | ||||
CreatedDateTime | datetime | - | ||
Description:No description available | ||||
CuryFreightAmt | decimal(19, 6) | Freight Price | - | |
Description:No description available | ||||
CuryFreightCost | decimal(19, 4) | Freight Cost | - | |
Description:No description available | ||||
CuryInfoID | bigint | CurrencyInfo | ||
Description:No description available | ||||
CuryLineTotal | decimal(19, 6) | Line Total | - | |
Description:No description available | ||||
CuryPremiumFreightAmt | decimal(19, 6) | Premium Freight Price | - | |
Description:No description available | ||||
CuryTotalFreightAmt | decimal(19, 6) | Total Freight Price | - | |
Description:No description available | ||||
FreightAmt | decimal(19, 6) | - | ||
Description:No description available | ||||
FreightCost | decimal(19, 4) | - | ||
Description:No description available | ||||
LastModifiedByID | uniqueidentifier | Last Modified By | Users | |
Description:No description available | ||||
LastModifiedByScreenID | char(8) | - | ||
Description:No description available | ||||
LastModifiedDateTime | datetime | - | ||
Description:No description available | ||||
LineTotal | decimal(19, 6) | - | ||
Description:No description available | ||||
NoteID | uniqueidentifier | - | ||
Description:No description available | ||||
PremiumFreightAmt | decimal(19, 6) | - | ||
Description:No description available | ||||
ProjectID | int | PMProject | ||
Description:No description available | ||||
ShipTermsID | nvarchar(10) | Shipping Terms | ShipTerms | |
Description:No description available | ||||
ShipVia | nvarchar(15) | Ship Via | Carrier | |
Description:No description available | ||||
ShipZoneID | nvarchar(15) | Shipping Zone ID | ShippingZone | |
Description:No description available | ||||
SubID | int | Sub. | Sub | |
Description:No description available | ||||
TaskID | int | Project Task | PMTask | |
Description:No description available | ||||
TaxCategoryID | nvarchar(15) | Tax Category | TaxCategory | |
Description:No description available | ||||
TotalFreightAmt | decimal(19, 6) | - | ||
Description:No description available | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||
Volume | decimal(19, 6) | Volume | - | |
Description:No description available | ||||
Weight | decimal(19, 6) | Weight | - | |
Description:No description available | ||||