SO
SOOrderProcessSelected
PX.Objects.SO281 of 281 fields
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
OrderNbr | nvarchar(15) | Order Nbr. | - | |
Description:No description available | ||||
OrderType | char(2) | Order Type | SOOrderType | |
Description:No description available | ||||
ActiveOperationsCntrNonexistent in DB | int | - | ||
Description:No description available | ||||
AllowsRequiredPrepaymentNonexistent in DB | bit | - | ||
Description:No description available | ||||
Approved | bit | - | ||
Description:No description available | ||||
ApprovedCredit | bit | - | ||
Description:No description available | ||||
ApprovedCreditAmt | decimal | - | ||
Description:No description available | ||||
ApprovedCreditByPayment | bit | - | ||
Description:No description available | ||||
ARDocTypeNonexistent in DB | nchar(3) | - | ||
Description:No description available | ||||
ArePaymentsApplicableNonexistent in DB | bit | ArePaymentsApplicable | - | |
Description:No description available | ||||
AuthorizedPaymentCntr | int | - | ||
Description:No description available | ||||
AvalaraCustomerUsageType | char(1) | Tax Exemption Type | - | |
Description:No description available | ||||
BackOrderedNonexistent in DB | bit | BackOrdered | - | |
Description:No description available | ||||
Behavior | char(2) | Behavior | - | |
Description:No description available | ||||
BillAddressID | int | SOAddress | ||
Description:No description available | ||||
BillContactID | int | SOContact | ||
Description:No description available | ||||
BilledCntr | int | - | ||
Description:No description available | ||||
BilledFreightTot | decimal | - | ||
Description:No description available | ||||
BilledPaymentTotal | decimal | - | ||
Description:No description available | ||||
BillSeparately | bit | Bill Separately | - | |
Description:No description available | ||||
BlanketLineCntr | int | - | ||
Description:No description available | ||||
BlanketOpenQty | decimal | Open Quantity | - | |
Description:No description available | ||||
BlanketSOAdjustCntr | int | - | ||
Description:No description available | ||||
BranchID | int | Branch | Branch | |
Description:No description available | ||||
CancelDate | datetime2 | Cancel By | - | |
Description:No description available | ||||
Cancelled | bit | Canceled | - | |
Description:No description available | ||||
CashAccountID | int | Cash Account | Account | |
Description:No description available | ||||
CCAuthorizedAmt | decimal | - | ||
Description:No description available | ||||
ChildLineCntr | int | - | ||
Description:No description available | ||||
CommnPct | decimal | - | ||
Description:No description available | ||||
Completed | bit | Completed | - | |
Description:No description available | ||||
ContactID | int | Contact | Contact | |
Description:No description available | ||||
ControlTotal | decimal | - | ||
Description:No description available | ||||
CreatedByID | uniqueidentifier | Created By | Users | |
Description:No description available | ||||
CreatedByScreenID | varchar(8) | - | ||
Description:No description available | ||||
CreatedDateTime | datetime | Created On | - | |
Description:No description available | ||||
CreditHold | bit | Credit Hold | - | |
Description:No description available | ||||
CuryBilledFreightTot | decimal | - | ||
Description:No description available | ||||
CuryBilledPaymentTotal | decimal | Total Transferred to Invoices | - | |
Description:No description available | ||||
CuryCCAuthorizedAmt | decimal | Authorized | - | |
Description:No description available | ||||
CuryControlTotal | decimal | Control Total | - | |
Description:No description available | ||||
CuryDetailExtPriceTotal | decimal | Detail Total | - | |
Description:No description available | ||||
CuryDiscTot | decimal | Document Discounts | - | |
Description:No description available | ||||
CuryDocBalNonexistent in DB | decimal | - | ||
Description:No description available | ||||
CuryDocumentDiscTotal | decimal | Document Discount | - | |
Description:No description available | ||||
CuryFreightAmt | decimal | Freight Price | - | |
Description:No description available | ||||
CuryFreightCost | decimal | Freight Cost | - | |
Description:No description available | ||||
CuryFreightTot | decimal | Freight Total | - | |
Description:No description available | ||||
CuryGoodsExtPriceTotal | decimal | Goods | - | |
Description:No description available | ||||
CuryGroupDiscTotal | decimal | Group Discounts | - | |
Description:No description available | ||||
CuryID | nvarchar(5) | Currency | Currency | |
Description:No description available | ||||
CuryInfoID | bigint | CurrencyInfo | ||
Description:No description available | ||||
CuryLineDiscTotal | decimal | Line Discounts | - | |
Description:No description available | ||||
CuryLineTotal | decimal | Line Total | - | |
Description:No description available | ||||
CuryManDiscObsolete | decimal | Manual Total | - | |
Description:No description available | ||||
CuryMarginAmt | decimal | Est. Margin Amount | - | |
Description:No description available | ||||
CuryMiscExtPriceTotal | decimal | Misc. Charges | - | |
Description:No description available | ||||
CuryMiscTot | decimal | Misc. Charges | - | |
Description:No description available | ||||
CuryNetSalesTotal | decimal | - | ||
Description:No description available | ||||
CuryOpenDiscTotal | decimal | - | ||
Description:No description available | ||||
CuryOpenLineTotal | decimal | Unshipped Line Total | - | |
Description:No description available | ||||
CuryOpenOrderTotal | decimal | Unshipped Amount | - | |
Description:No description available | ||||
CuryOpenTaxTotal | decimal | Unshipped Tax Total | - | |
Description:No description available | ||||
CuryOrderCosts | decimal | - | ||
Description:No description available | ||||
CuryOrderDiscTotal | decimal | Discount Total | - | |
Description:No description available | ||||
CuryOrderNetSales | decimal | - | ||
Description:No description available | ||||
CuryOrderTotal | decimal | Order Total | - | |
Description:No description available | ||||
CuryPaidAmt | decimal | Released | - | |
Description:No description available | ||||
CuryPaymentOverall | decimal | - | ||
Description:No description available | ||||
CuryPaymentTotal | decimal | Total Paid | - | |
Description:No description available | ||||
CuryPremiumFreightAmt | decimal | Premium Freight Price | - | |
Description:No description available | ||||
CuryPrepaymentReqAmt | decimal | Prepayment Amount | - | |
Description:No description available | ||||
CurySalesCostTotal | decimal | - | ||
Description:No description available | ||||
CuryTaxableFreightAmt | decimal | - | ||
Description:No description available | ||||
CuryTaxTotal | decimal | Tax Total | - | |
Description:No description available | ||||
CuryTermsDiscAmtNonexistent in DB | decimal | - | ||
Description:No description available | ||||
CuryTransferredToChildrenPaymentTotal | decimal | Total Transferred to Child Orders | - | |
Description:No description available | ||||
CuryUnbilledDiscTotal | decimal | - | ||
Description:No description available | ||||
CuryUnbilledFreightTot | decimal | - | ||
Description:No description available | ||||
CuryUnbilledLineTotal | decimal | Unbilled Line Total | - | |
Description:No description available | ||||
CuryUnbilledMiscTot | decimal | Unbilled Misc. Total | - | |
Description:No description available | ||||
CuryUnbilledOrderTotal | decimal | Unbilled Balance | - | |
Description:No description available | ||||
CuryUnbilledTaxTotal | decimal | Unbilled Tax Total | - | |
Description:No description available | ||||
CuryUnpaidBalance | decimal | Unpaid Balance | - | |
Description:No description available | ||||
CuryUnrefundedBalance | decimal | Unrefunded Balance | - | |
Description:No description available | ||||
CuryUnreleasedPaymentAmt | decimal | Not Released | - | |
Description:No description available | ||||
CuryVatExemptTotal | decimal | Tax Exempt Total | - | |
Description:No description available | ||||
CuryVatTaxableTotal | decimal | Taxable Total | - | |
Description:No description available | ||||
CustomerID | int | Customer | Customer | |
Description:No description available | ||||
CustomerLocationID | int | Location | Location | |
Description:No description available | ||||
CustomerOrderNbr | nvarchar(40) | Customer Order Nbr. | - | |
Description:No description available | ||||
CustomerRefNbr | nvarchar(40) | External Reference | - | |
Description:No description available | ||||
DefaultOperationNonexistent in DB | nchar(1) | SOOrderTypeOperation | ||
Description:No description available | ||||
DefaultSiteID | int | Preferred Warehouse ID | INSite | |
Description:No description available | ||||
DefaultTranTypeNonexistent in DB | nchar(3) | - | ||
Description:No description available | ||||
DeferPriceDiscountRecalculationNonexistent in DB | bit | Defer Price/Discount Recalculation | - | |
Description:No description available | ||||
DeliveryConfirmation | nvarchar(20) | Delivery Confirmation | - | |
Description:No description available | ||||
DeliveryMethod | char(1) | Link Delivery Method | - | |
Description:No description available | ||||
DestinationSiteID | int | Destination Warehouse | INSite | |
Description:No description available | ||||
DestinationSiteIdErrorMessageNonexistent in DB | nvarchar(150) | - | ||
Description:No description available | ||||
DetailExtPriceTotal | decimal | - | ||
Description:No description available | ||||
DisableAutomaticDiscountCalculation | bit | Disable Automatic Discount Update | - | |
Description:No description available | ||||
DisableAutomaticTaxCalculation | bit | Disable Automatic Tax Calculation | - | |
Description:No description available | ||||
DiscDate | datetime2 | Cash Discount Date | - | |
Description:No description available | ||||
DiscTot | decimal | Group and Document Discount Total | - | |
Description:No description available | ||||
DocBalNonexistent in DB | decimal | - | ||
Description:No description available | ||||
DocumentDiscTotal | decimal | Document Discount | - | |
Description:No description available | ||||
DontApproveNonexistent in DB | bit | Don't Approve | - | |
Description:No description available | ||||
DueDate | datetime2 | Due Date | - | |
Description:No description available | ||||
Emailed | bit | Emailed | - | |
Description:No description available | ||||
EmployeeIDNonexistent in DB | int | - | ||
Description:No description available | ||||
EndorsementService | nvarchar(30) | Endorsement | - | |
Description:No description available | ||||
ExpireDate | datetime2 | Expires On | - | |
Description:No description available | ||||
ExtCarrierPlugInNonexistent in DB | nvarchar(MAX) | - | ||
Description:No description available | ||||
ExtCarrierServiceMethodNonexistent in DB | nvarchar(MAX) | - | ||
Description:No description available | ||||
ExternalTaxesImportInProgressNonexistent in DB | bit | - | ||
Description:No description available | ||||
ExternalTaxExemptionNumber | nvarchar(30) | Tax Exemption Number | - | |
Description:No description available | ||||
ExtRefNbr | nvarchar(40) | Payment Ref. | - | |
Description:No description available | ||||
FinPeriodID | char(6) | Post Period | - | |
Description:No description available | ||||
FOBPoint | nvarchar(15) | FOB Point | FOBPoint | |
Description:No description available | ||||
ForceCompleteOrderNonexistent in DB | bit | - | ||
Description:No description available | ||||
FreightAmountSource | char(1) | Invoice Freight Price Based On | - | |
Description:No description available | ||||
FreightAmt | decimal | - | ||
Description:No description available | ||||
FreightClass | nvarchar(15) | Freight Class | - | |
Description:No description available | ||||
FreightCost | decimal | - | ||
Description:No description available | ||||
FreightCostIsValid | bit | Freight Cost Is up-to-date | - | |
Description:No description available | ||||
FreightTaxCategoryID | nvarchar(15) | Freight Tax Category | TaxCategory | |
Description:No description available | ||||
FreightTot | decimal | - | ||
Description:No description available | ||||
GoodsExtPriceTotal | decimal | - | ||
Description:No description available | ||||
GotReadyForArchiveAt | datetime2 | - | ||
Description:No description available | ||||
GroundCollect | bit | Ground Collect | - | |
Description:No description available | ||||
GroupDiscTotal | decimal | Group Discounts | - | |
Description:No description available | ||||
Hold | bit | Hold | - | |
Description:No description available | ||||
InclCustOpenOrders | bit | - | ||
Description:No description available | ||||
Insurance | bit | Insurance | - | |
Description:No description available | ||||
IntercompanyPONbr | nvarchar(15) | Related Order Nbr. | POOrder | |
Description:No description available | ||||
IntercompanyPOReturnNbr | nvarchar(15) | Related PO Return Nbr. | POReceipt | |
Description:No description available | ||||
IntercompanyPOType | char(2) | Related Order Type | - | |
Description:No description available | ||||
IntercompanyPOWithEmptyInventory | bit | - | ||
Description:No description available | ||||
InvoiceDate | datetime2 | Invoice Date | - | |
Description:No description available | ||||
InvoiceNbr | nvarchar(15) | Invoice Nbr. | SOInvoice | |
Description:No description available | ||||
IsCashSaleOrderNonexistent in DB | bit | - | ||
Description:No description available | ||||
IsCreditMemoOrderNonexistent in DB | bit | - | ||
Description:No description available | ||||
IsDebitMemoOrderNonexistent in DB | bit | - | ||
Description:No description available | ||||
IsExpired | bit | - | ||
Description:No description available | ||||
IsFreightAvailableNonexistent in DB | bit | - | ||
Description:No description available | ||||
IsFullyPaidNonexistent in DB | bit | - | ||
Description:No description available | ||||
IsIntercompanyNonexistent in DB | bit | - | ||
Description:No description available | ||||
IsInvoiceOrderNonexistent in DB | bit | - | ||
Description:No description available | ||||
IsLegacyMiscBilling | bit | - | ||
Description:No description available | ||||
IsManualPackage | bit | Manual Packaging | - | |
Description:No description available | ||||
IsManualTaxesValid | bit | Tax Is Up to Date | - | |
Description:No description available | ||||
IsMixedOrderNonexistent in DB | bit | - | ||
Description:No description available | ||||
IsNoAROrderNonexistent in DB | bit | - | ||
Description:No description available | ||||
IsOpenTaxValid | bit | - | ||
Description:No description available | ||||
IsOrchestrationAllowedNonexistent in DB | bit | - | ||
Description:No description available | ||||
IsPackageValid | bit | - | ||
Description:No description available | ||||
IsPaymentInfoEnabledNonexistent in DB | bit | - | ||
Description:No description available | ||||
IsPriceAndDiscountsValidNonexistent in DB | bit | Prices and discounts are up to date. | - | |
Description:No description available | ||||
IsRMAOrderNonexistent in DB | bit | - | ||
Description:No description available | ||||
IsTaxValid | bit | Tax Is Up to Date | - | |
Description:No description available | ||||
IsTransferOrderNonexistent in DB | bit | - | ||
Description:No description available | ||||
IsUnbilledTaxValid | bit | - | ||
Description:No description available | ||||
IsUserInvoiceNumberingNonexistent in DB | bit | - | ||
Description:No description available | ||||
KeepOrchestrationStatusNonexistent in DB | bit | - | ||
Description:No description available | ||||
LastModifiedByID | uniqueidentifier | Last Modified By | Users | |
Description:No description available | ||||
LastModifiedByScreenID | varchar(8) | - | ||
Description:No description available | ||||
LastModifiedDateTime | datetime | Last Modified On | - | |
Description:No description available | ||||
LastShipDate | datetime2 | Last Shipment Date | - | |
Description:No description available | ||||
LastSiteID | int | Last Shipment Site | INSite | |
Description:No description available | ||||
LimitWarehouse | bit | Limit Number of Fulfillment Warehouses | - | |
Description:No description available | ||||
LineCntr | int | - | ||
Description:No description available | ||||
LineDiscTotal | decimal | Line Discounts | - | |
Description:No description available | ||||
LineTotal | decimal | - | ||
Description:No description available | ||||
ManDiscObsolete | decimal | - | ||
Description:No description available | ||||
MarginAmt | decimal | - | ||
Description:No description available | ||||
MarginPct | decimal | Est. Margin (%) | - | |
Description:No description available | ||||
MinSchedOrderDate | datetime2 | Sched. Order Date | - | |
Description:No description available | ||||
MiscExtPriceTotal | decimal | - | ||
Description:No description available | ||||
MiscTot | decimal | - | ||
Description:No description available | ||||
NetSalesTotal | decimal | - | ||
Description:No description available | ||||
NoMarginLineCntr | int | - | ||
Description:No description available | ||||
NoteID | uniqueidentifier | - | ||
Description:No description available | ||||
NumberOfWarehouses | int | Number of Fulfillment Warehouses | - | |
Description:No description available | ||||
OpenDiscTotal | decimal | - | ||
Description:No description available | ||||
OpenDoc | bit | - | ||
Description:No description available | ||||
OpenLineCntr | int | - | ||
Description:No description available | ||||
OpenLineTotal | decimal | - | ||
Description:No description available | ||||
OpenOrderQty | decimal | Unshipped Quantity | - | |
Description:No description available | ||||
OpenOrderTotal | decimal | - | ||
Description:No description available | ||||
OpenShipmentCntr | int | - | ||
Description:No description available | ||||
OpenSiteCntr | int | - | ||
Description:No description available | ||||
OpenTaxTotal | decimal | - | ||
Description:No description available | ||||
OrchestrationStatus | char(2) | Orchestration Status | - | |
Description:No description available | ||||
OrchestrationStrategy | char(2) | Fulfillment Strategy | - | |
Description:No description available | ||||
OrderCosts | decimal | - | ||
Description:No description available | ||||
OrderDate | datetime2 | Date | - | |
Description:No description available | ||||
OrderDesc | nvarchar(256) | Description | - | |
Description:No description available | ||||
OrderDiscTotal | decimal | Discount Total | - | |
Description:No description available | ||||
OrderNetSales | decimal | - | ||
Description:No description available | ||||
OrderQty | decimal | Ordered Qty. | - | |
Description:No description available | ||||
OrderTaxAllocated | bit | - | ||
Description:No description available | ||||
OrderTotal | decimal | - | ||
Description:No description available | ||||
OrderVolume | decimal | Order Volume | - | |
Description:No description available | ||||
OrderWeight | decimal | Order Weight | - | |
Description:No description available | ||||
OrigOrderNbr | nvarchar(15) | Orig. Order Nbr. | SOOrder | |
Description:No description available | ||||
OrigOrderType | char(2) | Orig. Order Type | SOOrderType | |
Description:No description available | ||||
OverrideFreightAmount | bit | Override Freight Price | - | |
Description:No description available | ||||
OverridePrepayment | bit | Override Prepayment | - | |
Description:No description available | ||||
OverrideTaxZone | bit | Override Tax Zone | - | |
Description:No description available | ||||
OwnerID | int | Owner | Contact | |
Description:No description available | ||||
PackageLineCntr | int | - | ||
Description:No description available | ||||
PackageWeight | decimal | Package Weight | - | |
Description:No description available | ||||
PaidAmt | decimal | - | ||
Description:No description available | ||||
PayLinkID | int | - | ||
Description:No description available | ||||
PaymentCntr | int | - | ||
Description:No description available | ||||
PaymentMethodID | nvarchar(10) | Payment Method | PaymentMethod | |
Description:No description available | ||||
PaymentOverall | decimal | - | ||
Description:No description available | ||||
PaymentsNeedValidationCntr | int | - | ||
Description:No description available | ||||
PaymentTotal | decimal | - | ||
Description:No description available | ||||
PMInstanceID | int | Card/Account Nbr. | CustomerPaymentMethod | |
Description:No description available | ||||
PremiumFreightAmt | decimal | - | ||
Description:No description available | ||||
PrepaymentReqAmt | decimal | - | ||
Description:No description available | ||||
PrepaymentReqPct | decimal | Prepayment Percent | - | |
Description:No description available | ||||
PrepaymentReqPctToRestore | decimal | - | ||
Description:No description available | ||||
PrepaymentReqSatisfied | bit | Prepayment Requirements Satisfied | - | |
Description:No description available | ||||
Printed | bit | Printed | - | |
Description:No description available | ||||
Priority | smallint | Priority | - | |
Description:No description available | ||||
ProcessingCenterID | nvarchar(10) | Processing Center | - | |
Description:No description available | ||||
ProjectID | int | Project | PMProject | |
Description:No description available | ||||
QtyOnOrders | decimal | Qty. on Child Orders | - | |
Description:No description available | ||||
RejectedNonexistent in DB | bit | - | ||
Description:No description available | ||||
ReleasedCntr | int | - | ||
Description:No description available | ||||
RequestDate | datetime2 | Requested On | - | |
Description:No description available | ||||
Resedential | bit | Residential Delivery | - | |
Description:No description available | ||||
RiskLineCntr | int | - | ||
Description:No description available | ||||
SalesCostTotal | decimal | - | ||
Description:No description available | ||||
SalesPersonID | int | Default Salesperson | SalesPerson | |
Description:No description available | ||||
SaturdayDelivery | bit | Saturday Delivery | - | |
Description:No description available | ||||
SelectedNonexistent in DB | bit | Selected | - | |
Description:No description available | ||||
ShipAddressID | int | SOAddress | ||
Description:No description available | ||||
ShipComplete | char(1) | Shipping Rule | - | |
Description:No description available | ||||
ShipContactID | int | SOContact | ||
Description:No description available | ||||
ShipDate | datetime2 | Sched. Shipment | - | |
Description:No description available | ||||
ShipmentCntr | int | - | ||
Description:No description available | ||||
ShipmentDeletedNonexistent in DBObsolete | bit | - | ||
Description:No description available | ||||
ShipSeparately | bit | Ship Separately | - | |
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 | ShippingZone | |
Description:No description available | ||||
ShowDiscountsTabNonexistent in DB | bit | ShowDiscountsTab | - | |
Description:No description available | ||||
ShowOrdersTabNonexistent in DB | bit | ShowOrdersTab | - | |
Description:No description available | ||||
ShowShipmentsTabNonexistent in DB | bit | ShowShipmentsTab | - | |
Description:No description available | ||||
SiteCntr | int | - | ||
Description:No description available | ||||
SpecialLineCntr | int | - | ||
Description:No description available | ||||
Status | char(1) | Status | - | |
Description:No description available | ||||
SuggestRelatedItemsNonexistent in DB | bit | - | ||
Description:No description available | ||||
TaxableFreightAmt | decimal | - | ||
Description:No description available | ||||
TaxCalcMode | char(1) | Tax Calculation Mode | - | |
Description:No description available | ||||
TaxTotal | decimal | - | ||
Description:No description available | ||||
TaxZoneID | nvarchar(10) | Customer Tax Zone | TaxZone | |
Description:No description available | ||||
TermsDiscAmtNonexistent in DB | decimal | - | ||
Description:No description available | ||||
TermsID | nvarchar(10) | Terms | Terms | |
Description:No description available | ||||
TransferredToChildrenPaymentTotal | decimal | - | ||
Description:No description available | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||
UnbilledDiscTotal | decimal | - | ||
Description:No description available | ||||
UnbilledFreightTot | decimal | - | ||
Description:No description available | ||||
UnbilledLineTotal | decimal | - | ||
Description:No description available | ||||
UnbilledMiscTot | decimal | - | ||
Description:No description available | ||||
UnbilledOrderQty | decimal | Unbilled Quantity | - | |
Description:No description available | ||||
UnbilledOrderTotal | decimal | - | ||
Description:No description available | ||||
UnbilledTaxTotal | decimal | - | ||
Description:No description available | ||||
UnpaidBalance | decimal | - | ||
Description:No description available | ||||
UnrefundedBalance | decimal | - | ||
Description:No description available | ||||
UnreleasedPaymentAmt | decimal | - | ||
Description:No description available | ||||
UpdateNextNumberNonexistent in DB | bit | Update Next Number | - | |
Description:No description available | ||||
UseCustomerAccount | bit | Use Customer's Account | - | |
Description:No description available | ||||
VatExemptTotal | decimal | - | ||
Description:No description available | ||||
VatTaxableTotal | decimal | - | ||
Description:No description available | ||||
WillCallNonexistent in DB | bit | Will Call | - | |
Description:No description available | ||||
WorkgroupID | int | Workgroup | EPCompanyTree | |
Description:No description available | ||||