SO
SOMiscLine2
PX.Objects.SO62 of 62 fields
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
LineNbr | int | - | ||
Description:No description available | ||||
OrderNbr | nvarchar(15) | SOOrder | ||
Description:No description available | ||||
OrderType | char(2) | SOOrderType | ||
Description:No description available | ||||
BaseBilledQty | decimal(25, 6) | - | ||
Description:No description available | ||||
BaseUnbilledQty | decimal(25, 6) | - | ||
Description:No description available | ||||
BilledAmt | decimal(19, 4) | - | ||
Description:No description available | ||||
BilledQty | decimal(25, 6) | - | ||
Description:No description available | ||||
BlanketLineNbr | int | BlanketSOLine | ||
Description:No description available | ||||
BlanketNbr | nvarchar(15) | SOBlanketOrderLink | ||
Description:No description available | ||||
BlanketSplitLineNbr | int | BlanketSOLineSplit | ||
Description:No description available | ||||
BlanketType | char(2) | - | ||
Description:No description available | ||||
BranchID | int | Branch | ||
Description:No description available | ||||
Commissionable | bit | - | ||
Description:No description available | ||||
Completed | bit | Completed | - | |
Description:No description available | ||||
CostCodeID | int | PMCostCode | ||
Description:No description available | ||||
CuryBilledAmt | decimal(19, 4) | - | ||
Description:No description available | ||||
CuryDiscAmt | decimal(19, 4) | Ext. Amount | - | |
Description:No description available | ||||
CuryExtPrice | decimal(19, 6) | - | ||
Description:No description available | ||||
CuryInfoID | bigint | CurrencyInfo | ||
Description:No description available | ||||
CuryLineAmt | decimal(19, 4) | Ext. Amount | - | |
Description:No description available | ||||
CuryUnbilledAmt | decimal(19, 4) | - | ||
Description:No description available | ||||
CuryUnitPrice | decimal(19, 6) | - | ||
Description:No description available | ||||
CuryUnitPriceDR | decimal(19, 6) | Unit Price for DR | - | |
Description:No description available | ||||
DefaultOperation | char(1) | SOOrderTypeOperation | ||
Description:No description available | ||||
DefScheduleID | int | DRSchedule | ||
Description:No description available | ||||
DiscAmt | decimal(19, 4) | - | ||
Description:No description available | ||||
DiscountID | nvarchar(10) | Discount Code | ARDiscount | |
Description:No description available | ||||
DiscountSequenceID | nvarchar(10) | Discount Sequence | DiscountSequence | |
Description:No description available | ||||
DiscPct | decimal(9, 6) | - | ||
Description:No description available | ||||
DiscPctDR | decimal(9, 6) | Discount Percent for DR | - | |
Description:No description available | ||||
DocumentDiscountRate | decimal(21, 18) | - | ||
Description:No description available | ||||
DRTermEndDate | datetime2 | Term End Date | - | |
Description:No description available | ||||
DRTermStartDate | datetime2 | Term Start Date | - | |
Description:No description available | ||||
GroupDiscountRate | decimal(21, 18) | - | ||
Description:No description available | ||||
InventoryID | int | Inventory ID | - | |
Description:No description available | ||||
InvoiceDate | datetime2 | - | ||
Description:No description available | ||||
InvoiceLineNbr | int | ARTran | ||
Description:Number of the Invoice line to which the return SO line is applied. | ||||
InvoiceNbr | nvarchar(15) | SOInvoice | ||
Description:Number of the Invoice to which the return SO line is applied. | ||||
InvoiceType | char(3) | - | ||
Description:Type of the Invoice to which the return SO line is applied. | ||||
IsFree | bit | Free Item | - | |
Description:No description available | ||||
LineAmt | decimal(19, 4) | - | ||
Description:No description available | ||||
LineSign | smallint | - | ||
Description:No description available | ||||
ManualDisc | bit | Manual Discount | - | |
Description:No description available | ||||
ManualPrice | bit | - | ||
Description:No description available | ||||
NoteID | uniqueidentifier | - | ||
Description:No description available | ||||
Operation | char(1) | Operation | SOOrderTypeOperation | |
Description:No description available | ||||
OrderQty | decimal(25, 6) | - | ||
Description:No description available | ||||
ProjectID | int | PMProject | ||
Description:No description available | ||||
SalesAcctID | int | Account | - | |
Description:No description available | ||||
SalesPersonID | int | Salesperson ID | - | |
Description:No description available | ||||
SalesSubID | int | Subaccount | - | |
Description:No description available | ||||
ShipDate | datetime2 | - | ||
Description:No description available | ||||
SiteID | int | INSite | ||
Description:No description available | ||||
SortOrder | int | - | ||
Description:No description available | ||||
TaskID | int | Project Task | - | |
Description:No description available | ||||
TaxCategoryID | nvarchar(15) | TaxCategory | ||
Description:No description available | ||||
TaxZoneID | nvarchar(10) | TaxZone | ||
Description:No description available | ||||
TranDesc | nvarchar(256) | Line Description | - | |
Description:No description available | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||
UnbilledAmt | decimal(19, 4) | - | ||
Description:No description available | ||||
UnbilledQty | decimal(25, 6) | - | ||
Description:No description available | ||||
UOM | nvarchar(6) | UOM | - | |
Description:No description available | ||||