SO
BlanketSOOrder
PX.Objects.SO.DAC.Projections52 of 52 fields
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
OrderNbr | nvarchar(15) | - | ||
Description:No description available | ||||
OrderType | char(2) | SOOrderType | ||
Description:No description available | ||||
Approved | bit | - | ||
Description:No description available | ||||
BlanketOpenQty | decimal(25, 6) | - | ||
Description:No description available | ||||
CCAuthorizedAmt | decimal(19, 4) | - | ||
Description:No description available | ||||
ChildLineCntr | int | - | ||
Description:No description available | ||||
Completed | bit | - | ||
Description:No description available | ||||
CuryCCAuthorizedAmt | decimal(19, 4) | - | ||
Description:No description available | ||||
CuryID | nvarchar(5) | Currency | Currency | |
Description:No description available | ||||
CuryInfoID | bigint | CurrencyInfo | ||
Description:No description available | ||||
CuryOpenLineTotal | decimal(19, 4) | - | ||
Description:No description available | ||||
CuryOpenOrderTotal | decimal(19, 4) | - | ||
Description:No description available | ||||
CuryOpenTaxTotal | decimal(19, 4) | - | ||
Description:No description available | ||||
CuryPaidAmt | decimal(19, 4) | - | ||
Description:No description available | ||||
CuryPaymentOverall | decimal(19, 4) | - | ||
Description:No description available | ||||
CuryPaymentTotal | decimal(19, 4) | - | ||
Description:No description available | ||||
CuryTransferredToChildrenPaymentTotal | decimal(19, 4) | - | ||
Description:No description available | ||||
CuryUnbilledLineTotal | decimal(19, 4) | - | ||
Description:No description available | ||||
CuryUnbilledOrderTotal | decimal(19, 4) | - | ||
Description:No description available | ||||
CuryUnbilledTaxTotal | decimal(19, 4) | - | ||
Description:No description available | ||||
CuryUnreleasedPaymentAmt | decimal(19, 4) | - | ||
Description:No description available | ||||
ExpireDate | datetime2 | - | ||
Description:No description available | ||||
Hold | bit | - | ||
Description:No description available | ||||
IsExpired | bit | - | ||
Description:No description available | ||||
IsOpenTaxValid | bit | - | ||
Description:No description available | ||||
LastModifiedByID | uniqueidentifier | Last Modified By | - | |
Description:No description available | ||||
LastModifiedByScreenID | char(8) | - | ||
Description:No description available | ||||
LastModifiedDateTime | datetime | - | ||
Description:No description available | ||||
MinSchedOrderDate | datetime2 | - | ||
Description:No description available | ||||
NoteID | uniqueidentifier | - | ||
Description:No description available | ||||
OpenLineCntr | int | - | ||
Description:No description available | ||||
OpenLineTotal | decimal(19, 4) | - | ||
Description:No description available | ||||
OpenOrderQty | decimal(25, 6) | - | ||
Description:No description available | ||||
OpenOrderTotal | decimal(19, 4) | - | ||
Description:No description available | ||||
OpenSiteCntr | int | - | ||
Description:No description available | ||||
OpenTaxTotal | decimal(19, 4) | - | ||
Description:No description available | ||||
OrderDate | datetime2 | - | ||
Description:No description available | ||||
OrigOpenLineCntr | int | - | ||
Description:No description available | ||||
PaidAmt | decimal(19, 4) | - | ||
Description:No description available | ||||
PaymentOverall | decimal(19, 4) | - | ||
Description:No description available | ||||
PaymentTotal | decimal(19, 4) | - | ||
Description:No description available | ||||
QtyOnOrders | decimal(25, 6) | - | ||
Description:No description available | ||||
ShipmentCntr | int | - | ||
Description:No description available | ||||
ShipmentCntrUpdatedNonexistent in DB | bit | - | ||
Description:No description available | ||||
TaxCalcMode | char(1) | - | ||
Description:No description available | ||||
TransferredToChildrenPaymentTotal | decimal | - | ||
Description:No description available | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||
UnbilledLineTotal | decimal(19, 4) | - | ||
Description:No description available | ||||
UnbilledOrderQty | decimal(25, 6) | - | ||
Description:No description available | ||||
UnbilledOrderTotal | decimal(19, 4) | - | ||
Description:No description available | ||||
UnbilledTaxTotal | decimal(19, 4) | - | ||
Description:No description available | ||||
UnreleasedPaymentAmt | decimal(19, 4) | - | ||
Description:No description available | ||||