AccountId | Account | Lookup → Account | Yes | The customer. Only active customer accounts can be picked. Locked once saved. Together with the partner account it identifies the credit limit checked when the order is first saved. |
AccountName | Account Name | Text | | |
AccountPhone | Phone | Text | | |
AdjustedAdvanceAmount | Adjusted Advance Amount | Currency | | How much of the advance has since been used. |
AdvanceAmount | Advance Amount | Currency | | Advance or deposit taken against the order. Open Amount is Total Amount less this. |
AllocatedQuantity | Allocated Quantity | Calculated (calculated) | | Order-level roll-up of OrderLine.FulfilmentAllocatedQuantity: how much of the order has been reserved against specific stock lots by the allocation actions. |
AmountPaid | Amount Paid | Currency | | Cash recorded as received against the order. It appears in two calculated fields: OutstandingAmount subtracts it (together with FinanceAmount) from the line subtotal plus tax, and TotalCreditAmount is AmountPaid minus FinanceAmount. |
BillingAddress | Billing Address | Text | | |
BillingCity | Billing City | PickList | | Values: Pune, Chandigarh, Mumbai. |
BillingCityPlaceId | Billing City | Lookup → Place | | |
BillingContactAddressId | Billing Address | Lookup → ContactAddress | | |
BillingCountry | Billing Country | PickList | | Values: India. |
BillingPostalCode | Billing Postal Code | Text | | |
BillingRegion | Billing Region | Text | | |
BillingState | Billing State | PickList | | Values: Haryana, Maharashtra, New Delhi, Punjab. |
BillingStreet | Billing Street | Text | | Billing |
BookingAmount | Booking Amount | Currency | | |
BranchId | Branch | Lookup → Branch | | The location the order is sold from. Must be active and belong to the partner account, and is required when the partner account has branches. Locked once saved. |
ContactId | Contact | Lookup → Contact | | The customer contact. Limited to the account's contacts and filled from the account's default contact when left empty. |
ContactName | Contact Name | Text | | |
ContactNumber | Contact Number | Text | | |
CreatedById | Created By | Lookup → UserAccount | Yes | |
CreatedDateTime | Created Date | DateAndTime | Yes | |
Discount | Discount | Number | | A header discount percentage. Changing it copies the value to every line as Order Discount. Not on the shipped forms. |
DiscountGroupId | Discount Group | Lookup → DiscountGroup | | The discount group line discounts come from. A matching group for the partner account, branch and account groups is set on save. |
DocumentDate | Document Date | Date | | The order's business date, stamped with the current date and time on save. A future date is set back to now. Locked once saved. |
ExecutiveId | Executive | Lookup → Resource | | Labelled Executive: the sales person responsible for the order. Required on the shipped web form and must be an active resource allowed to sell for the order's partner account and branch. |
ExternalId | External | Text, unique | | |
FinanceAmount | Finance Amount | Currency | | The financed portion of the order. It is the amount the credit-limit check weighs when the order is created (FinanceAmount, falling back to TotalOrderAmount), and it is subtracted in both OutstandingAmount and TotalCreditAmount, so a non-zero value reduces what the order counts as still owed in cash. |
FulfilmentOrderQuantity | Fulfilment Order Quantity | Calculated (calculated) | | Order-level roll-up of OrderLine.FulfilmentOrderQuantity: quantity already placed on an inventory fulfilment. PendingFulfilmentQuantity is the remainder still to be released. |
FulfilmentReleased | Fulfilment Released | Boolean | | Metadata-only field with no counterpart in the platform: neither the Order domain type nor the schema created by the platform migration has a column of this name. |
GSTIN | GSTIN | Text | | |
Id | Id | Guid | Yes | |
IsDealerOrderCreated | Dealer Sale Order Created | Boolean | | Set when the order was created as a dealer order from another organization's purchase order. |
IsDeliveryReleased | Delivery Released | Boolean | | Legacy flag; not maintained by the release actions. Read Pending Delivery Quantity or Document State instead. |
IsILPosted | IL Posted | Boolean | | |
IsInJobQueue | In Job Queue | Boolean | | A boolean column on the order that no code in the platform reads or writes; it does not indicate whether an asynchronous action for this order is queued or running. |
IsInvoiceReleased | Invoice Released | Boolean | | Legacy flag; not maintained by the release actions. Read Pending Invoice Quantity or Document State instead. |
IsKPICalculated | KPI Calculated | Boolean | | |
JobQueueId | Job Queue | Lookup | | Metadata-only field with no counterpart in the platform: the Order domain type and the schema created by the platform migration have no JobQueueId column. Asynchronous processing of an order is tracked by the platform's own job ledger, not by a field on the order. |
LineSubTotal | Total Line Amount | Calculated (calculated) | | Labelled Total Line Amount: the sum of line amounts after discounts, before tax. |
Mobile | Mobile | Text | | |
ModeOfPayment | Mode Of Payment | PickList | | |
ModifiedById | Modified By | Lookup → UserAccount | Yes | |
Name | Document Number | Text | | The order's document number, generated on save from the Order Document Name Setting. The shipped format is SO, a hyphen, the document date as DDMMYYYY, a hyphen and a six-digit counter that restarts each day. |
OpenAdvanceAmount | Open Advance Amount | Calculated (calculated) | | Calculated as AdvanceAmount minus AdjustedAdvanceAmount: advance money held on the order that has not yet been applied to anything. |
OpenAmount | Open Amount | Calculated (calculated) | | |
OpportunityId | Opportunity | Lookup → Opportunity | | The opportunity the order was raised from. Each run of the opportunity's Order action creates a new order for the quantity still pending on its lines. |
OTCInvoicedQuantity | OTC Invoiced Quantity | Calculated (calculated) | | Order-level roll-up of OrderLine.OTCInvoicedQuantity: quantity invoiced over the counter, meaning through invoice lines with no allocation line behind them, as opposed to allocation-backed invoicing. |
OutstandingAmount | Outstanding Amount | Calculated (calculated) | | Calculated: Total Line Amount plus tax, less Amount Paid and Finance Amount. The Payment button in the Amount Summary shows while it is above zero. |
OwnerId | Owner | Lookup → UserAccount | Yes | |
PartnerAccountId | Partner Account | Lookup → Account | | Your selling company. Required on save and must be active; only active partner accounts can be picked. It scopes stock, credit and numbering for the order. |
PendingDeliveryQuantity | Pending Delivery Quantity | Calculated (calculated) | | Quantity still to be delivered over all lines. |
PendingFulfilmentAllocationQuantity | Pending Fulfilment Allocation Quantity | Calculated (calculated) | | Quantity of stock-tracked items still to be allocated. The allocation buttons show while it is above zero. |
PendingFulfilmentQuantity | Pending Fulfilment Quantity | Calculated (calculated) | | Pending Fulfillment Quantity |
PendingInvoiceQuantity | Pending Invoice Quantity | Calculated (calculated) | | Quantity still to be invoiced over all lines. The invoice buttons show while it is above zero. |
PerformCreateDealerOrder | Perform Create Dealer Sale Order | Boolean | | |
PerformInventoryPosting | Perform Inventory Posting | Boolean | | |
PerformKPICalculation | Perform KPI Calculation | Boolean | | |
PerformReleaseDelivery | Perform Release Delivery | Boolean | | |
PerformReleaseFulfilment | Perform Release Fulfilment | Boolean | | A stored boolean, not a trigger. The same is true of the other Perform* booleans on this entity. |
PerformReleaseInvoice | Perform Release Invoice | Boolean | | A stored boolean, not a trigger. Invoicing is started by invoking the server action of the same name; no code in the platform reads this field. |
PerformReleaseInvoiceAllocatedLines | Perform Release Invoice Allocated Lines | Boolean | | |
PerformReprice | Perform Reprice | Boolean | | |
PickedQuantity | Picked Quantity | Calculated (calculated) | | Order-level roll-up of OrderLine.PickedQuantity: quantity confirmed picked in the warehouse, one stage beyond allocation. |
PlaceOfSupply | Place of Supply | PickList | | Values: Maharashtra, Gujarat, Rajasthan, Haryana. |
PriceAsOnDate | Price As On Date | Date | | The date prices are taken from. Changing it re-prices every line from the price list in force on that date. |
PriceListId | Price List | Lookup → PriceList | | The price list the lines are priced from. When left empty, a sale price list matching the partner account, branch and the customer's account groups is chosen on save. |
PromisedDate | Promised Date | Date | | |
PurchaseOrderId | Purchase Order | Lookup → PurchaseOrder | | The purchase order of another organization on the platform that this order was created from as a dealer order. |
QuoteId | Quote | Lookup → Quote | | The quote the order was created from. The quote's lines are copied in with their prices, discounts, tax group, SKU and lot type. A quote can create only one order. |
RecordTypeId | Record Type | Guid, hidden | | |
Remark | Remark | Text | | |
RequiredDate | Tentative Buying Date | Date | | Labelled Tentative Buying Date: the customer's expected purchase date. Not on the shipped forms. |
RnaExternalId | RnaExternal | LongMultiLineText | | |
RoundOff | Round Off | Currency | | |
SampleTest | SampleTest | Boolean | | |
ShippingAddress | Shipping Address | Text | | |
ShippingCity | Shipping City | PickList | | Values: Pune, Mumbai, Chandigarh. |
ShippingCityPlaceId | Shipping City | Lookup → Place | | |
ShippingContactAddressId | Shipping Address | Lookup → ContactAddress | | |
ShippingCountry | Shipping Country | PickList | | Values: India. |
ShippingPostalCode | Shipping Postal Code | Text | | |
ShippingRegion | Shipping Region | Text | | |
ShippingState | Shipping State | PickList | | Values: Haryana, Maharashtra, New Delhi, Punjab. |
ShippingStreet | Shipping Street | Text | | |
SkipScheme | Skip Scheme | Boolean | | Turns off automatic trade-scheme evaluation for the whole order. Changing it re-runs scheme evaluation. |
SourceOfSupply | Source of Supply | PickList | | Values: Maharashtra, Gujarat, Rajasthan, Haryana. |
Status | Status | PickList | | The order's stage, Draft by default. Shipped business rules set Fulfilment, Invoicing, Delivery or Closed on save when nothing is left to allocate, invoice or deliver (Closed when nothing is left to deliver or invoice). A manual change to a stage the quantities do not support is refused. Actions such as Cancel Order do not set Status. Values: Draft, Pending Approval, Approved, Fulfilment, Invoicing, Delivery, Closed, Rejected. |
SupplierAccountId | Supplier Account | Lookup | | Supplying party on the order, used to scope dealer and distributor documents. Note that the metadata field carries no lookup relation even though the domain model links it to Account, so it will not behave as a lookup in generic tooling. |
Tax1 | Tax 1 | Currency | | Header-level tax slot (with Tax1Name, Tax1Rate and Tax1Type alongside it), stamped by the tax-group service on insert and whenever TaxGroupId, TaxId or TCSEligibleAmount changes. It is excluded from TotalTaxAmount2, which is TotalLineTaxAmount minus this value. |
Tax1Name | TaxName1 | Text | | |
Tax1Rate | TaxRate1 | Currency | | |
Tax1Type | TaxType1 | Text | | |
TaxGroupId | Tax Group | Lookup → TaxGroup | | |
TaxId | Tax | Lookup → Tax | | |
TaxSupplyType | Tax Supply Type | PickList | | Within State or Outside State. Used to pick each line's tax group from the tax rules. Values: Within State, Outside State. |
TCSEligibleAmount | TCS Eligible Amount | Decimal | | Base amount the header-level tax is computed on. Changing it re-runs the header tax stamping, exactly as changing TaxGroupId or TaxId does. |
TotalCreditAmount | Total Credit Amount | Calculated (calculated) | | Calculated as AmountPaid minus FinanceAmount, i.e. the part of what was received that was not financed. It is not a credit limit and not a credit-note total. |
TotalDiscountAmount | Total Discount Amount | Calculated (calculated) | | The sum of line discounts, excluding scheme discounts. |
TotalLineBaseAmount | Total Line Base Amount | Calculated (calculated) | | Quantity times unit price over all lines, before discounts, excluding discounted-item lines. |
TotalLineGrossAmount | Total Line Gross Amount | Calculated (calculated) | | Calculated sum of OrderLine.GrossAmount. TotalOrderAmount is defined by the identical expression, so the two fields always carry the same number. |
TotalLineTaxAmount | Total Line Tax Amount | Calculated (calculated) | | Calculated sum of OrderLine.TaxAmount across all six per-line tax slots. TotalTaxPostingAmount uses the same expression, and TotalTaxAmount2 is this figure less the header-level Tax1. |
TotalOrderAmount | Total Amount | Calculated (calculated) | | Labelled Total Amount: the order total including line tax. |
TotalSchemeDiscountAmount | Total Scheme Amount | Calculated (calculated) | | Labelled Total Scheme Amount: the sum of scheme discounts on the lines. |
TotalTaxAmount2 | Total Tax Amount | Calculated (calculated) | | Labelled simply 'Total Tax Amount' but calculated as TotalLineTaxAmount minus Tax1 — line taxes excluding the header-level tax component. This is the tax term used inside OutstandingAmount. |
TotalTaxPostingAmount | Total Tax Posting Amount | Calculated (calculated) | | |
TransactionType | Transaction Type | PickList | | |
UIProps | UI Props | Text | | |
UpdatedDateTime | Modified Date | DateAndTime | Yes | |
VisitId | Visit | Lookup → Visit | | The field visit the order was taken on. The visit is linked back to its first order. |
VisitPlanId | Visit Plan | Lookup → VisitPlan | | |
VisitRouteId | Visit Route | Lookup → VisitRoute | | |