SalesOrder
SalesOrder is an auto-generated table.
Columns
Name | Type | ReadOnly | Description |
Id [KEY] | String | True | |
LinkedShipToContact | String | False | |
OrderNbr [KEY] | String | False | |
CurrencyID | String | False | |
TaxTotal | Double | False | |
Status | String | False | |
CurrencyRate | Double | False | |
LinkedBillToContact | String | False | |
PaymentMethod | String | False | |
ControlTotal | Double | False | |
VATTaxableTotal | Double | False | |
ShipToAddressOverride | Bool | False | |
CustomerID | String | False | |
PreferredWarehouseID | String | False | |
OrderTotal | Double | False | |
PreAuthorizationNbr | String | False | |
BaseCurrencyID | String | False | |
Description | String | False | |
BillToAddressValidated | Bool | False | |
EffectiveDate | Datetime | False | |
IsTaxValid | Bool | False | |
BillToContactOverride | Bool | False | |
PreAuthorizedAmount | Double | False | |
LinkedShipments | String | False | |
Hold | Bool | False | |
CurrencyRateTypeID | String | False | |
LastModified | Datetime | False | |
LocationID | String | False | |
CreditHold | Bool | False | |
ShipToAddressValidated | Bool | False | |
LinkedShipToAddress | String | False | |
LinkedCommissions | String | False | |
LinkedDiscountDetails | String | False | |
CashAccount | String | False | |
ReciprocalRate | Double | False | |
OrderType [KEY] | String | False | |
LinkedBillToAddress | String | False | |
PaymentCardIdentifier | String | False | |
CustomerOrder | String | False | |
VATExemptTotal | Double | False | |
ExternalRef | String | False | |
BillToAddressOverride | Bool | False | |
LinkedDetails | String | False | |
NewCard | Bool | False | |
Date | Datetime | False | |
DestinationWarehouseID | String | False | |
LinkedPayments | String | False | |
PaymentRef | String | False | |
OrderedQty | Double | False | |
LinkedShippingSettings | String | False | |
Approved | Bool | False | |
ShipToContactOverride | Bool | False | |
ShipVia | String | False | |
RequestedOn | Datetime | False | |
LinkedTaxDetails | String | False | |
LinkedTotals | String | False | |
Project | String | False | |
LinkedFinancialSettings | String | False | |
Custom_CurrentDocument_CuryPremiumFreightAmt | String | False | |
Custom_CurrentDocument_DueDate | String | False | |
Custom_CurrentDocument_CuryDiscTot | String | False | |
Custom_CurrentDocument_CuryUnpaidBalance | String | False | |
Custom_CurrentDocument_PackageWeight | String | False | |
Custom_CurrentDocument_OverrideTaxZone | Bool | False | |
Custom_CurrentDocument_AvalaraCustomerUsageType | String | False | |
Custom_CurrentDocument_CuryOpenOrderTotal | String | False | |
Custom_CurrentDocument_CuryFreightCost | String | False | |
Custom_CurrentDocument_Insurance | Bool | False | |
Custom_CurrentDocument_CCAuthExpirationDate | String | False | |
Custom_CurrentDocument_CuryTaxTotal | String | False | |
Custom_CurrentDocument_CreatePMInstance | Bool | False | |
Custom_CurrentDocument_CuryPaymentTotal | String | False | |
Custom_CurrentDocument_PreAuthTranNumber | String | False | |
Custom_DefPaymentMethodInstance_NoteID | String | False | |
Custom_CurrentDocument_CancelDate | String | False | |
Custom_CurrentDocument_PMInstanceID | Int | False | |
Custom_CurrentDocument_FOBPoint | String | False | |
Custom_CurrentDocument_ExtRefNbr | String | False | |
Custom_CurrentDocument_GroundCollect | Bool | False | |
Custom_CurrentDocument_CuryMiscTot | String | False | |
Custom_CurrentDocument_Emailed | Bool | False | |
Custom_CurrentDocument_PaymentMethodID | String | False | |
Custom_Document_DontApprove | Bool | False | |
Custom_CurrentDocument_CCPaymentStateDescr | String | False | |
Custom_CurrentDocument_CuryUnbilledOrderTotal | String | False | |
Custom_CurrentDocument_CaptureTranNumber | String | False | |
Custom_CurrentDocument_UseCustomerAccount | Bool | False | |
Custom_CurrentDocument_OrigOrderType | String | False | |
Custom_CurrentDocument_FreightCostIsValid | Bool | False | |
Custom_CurrentDocument_DefaultSiteID | String | False | |
Custom_CurrentDocument_UnbilledOrderQty | String | False | |
Custom_CurrentDocument_Cancelled | Bool | False | |
Custom_CurrentDocument_OrigOrderNbr | String | False | |
Custom_CurrentDocument_PMInstanceID_description | String | False | |
Custom_CurrentDocument_CuryFreightAmt | String | False | |
Custom_CurrentDocument_OrderVolume | String | False | |
Custom_CurrentDocument_CCCardNumber | String | False | |
Custom_CurrentDocument_CuryCCPreAuthAmount | String | False | |
Custom_CurrentDocument_RefTranExtNbr | String | False | |
Custom_CurrentDocument_WillCall | Bool | False | |
Custom_CurrentDocument_FinPeriodID | String | False | |
Custom_CurrentDocument_OrderWeight | String | False | |
Custom_Document_CuryViewState | Bool | False | |
Custom_CurrentDocument_ShipZoneID | String | False | |
Custom_CurrentDocument_CuryLineTotal | String | False | |
Custom_CurrentDocument_ShipComplete | String | False | |
Custom_CurrentDocument_FreightTaxCategoryID | String | False | |
Custom_CurrentDocument_PCResponseReasonText | String | False | |
Custom_CurrentDocument_Resedential | Bool | False | |
Custom_CurrentDocument_NoteID | String | False | |
Custom_Document_NoteText | String | False | |
Custom_CurrentDocument_ShipDate | String | False | |
Custom_CurrentDocument_ShipTermsID | String | False | |
Custom_CurrentDocument_CashAccountID | String | False | |
Custom_DefPaymentMethodInstance_CCProcessingCenterID | String | False | |
Custom_CurrentDocument_ShipVia | String | False | |
Custom_Document_NoteID | String | False | |
Custom_CurrentDocument_SaturdayDelivery | Bool | False | |
Custom_CurrentDocument_CampaignID | String | False | |
Custom_CurrentDocument_TermsID | String | False | |
Custom_CurrentDocument_ShipSeparately | Bool | False | |
Custom_CurrentDocument_OwnerID | String | False | |
Custom_CurrentDocument_OpenOrderQty | String | False | |
Custom_CurrentDocument_TaxZoneID | String | False | |
Custom_CurrentDocument_BillSeparately | Bool | False | |
Custom_CurrentDocument_InvoiceNbr | String | False | |
Custom_CurrentDocument_Priority | Int | False | |
Custom_CurrentDocument_DiscDate | String | False | |
Custom_CurrentDocument_BranchID | String | False | |
Custom_CurrentDocument_InvoiceDate | String | False |