AccountId | Account | Lookup → Account | Yes | The customer the order is raised on. It is locked after creation, is required before GetOpenDocuments will run, and forms the party pair with PartnerAccountId for the credit-limit check. |
AccountName | Account Name | Text | | |
AccountPhone | Phone | Text | | |
AdjustedAdvanceAmount | Adjusted Advance Amount | Currency | | |
AdvanceAmount | Advance Amount | Currency | | Advance or deposit taken against the order. TotalOrderAmount minus this gives the calculated OpenAmount, and AdjustedAdvanceAmount records how much of it has since been consumed. |
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 | | Operating branch of the order. It is validated against PartnerAccountId (the branch must belong to that partner) on both insert and update, and it cannot be changed once the order exists. |
ContactId | Contact | Lookup → Contact | | |
ContactName | Contact Name | Text | | |
ContactNumber | Contact Number | Text | | |
CreatedById | Created By | Lookup → UserAccount | Yes | |
CreatedDateTime | Created Date | DateAndTime | Yes | |
Discount | Discount | Number | | Header discount percentage. Changing it on a saved order pushes the value down onto every OrderLine.OrderDiscount, and a new line copies a non-zero value into its own Discount — the header field itself does not reduce the totals directly. |
DiscountGroupId | Discount Group | Lookup → DiscountGroup | | Discount group used to resolve rule-based line discounts; a default is set by the discount-group service when the order is inserted. The rule matched for each line is recorded on OrderLine.DiscountGroupRuleId. |
DocumentDate | Document Date | Date | | Stamped with the current date and time when the order is created, and then locked — the handler rejects any later change to DocumentDate, AccountId or BranchId. |
ExecutiveId | Executive | Lookup → Resource | | Labelled 'Executive': the Resource (sales or field person) attached to the order. The resource service validates it on both insert and update, so an unmatched or ineligible resource is rejected at save. |
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 to true only by the purchase-order service when it generates this order as a dealer order from a PurchaseOrder. It is not set by the order's own PerformCreateDealerOrder action, which instead pulls purchase order lines into an order that already exists. |
IsDeliveryReleased | Delivery Released | Boolean | | Declared as a system flag that users are blocked from editing, but no code path in the platform ever writes it, so in practice it stays empty. Judge delivery progress from PendingDeliveryQuantity 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 | | Declared as a system flag that users are blocked from editing, but no code path in the platform ever writes it, so in practice it stays empty. Judge invoicing progress from PendingInvoiceQuantity 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 calculated sum of OrderLine.Amount, i.e. line values after line-level discounts but before header round-off. It is not the grand total — TotalOrderAmount sums GrossAmount and so includes line tax. |
Mobile | Mobile | Text | | |
ModeOfPayment | Mode Of Payment | PickList | | |
ModifiedById | Modified By | Lookup → UserAccount | Yes | |
Name | Document Number | Text | | |
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 | | Source opportunity. On insert, and only when QuoteId is empty, the opportunity's lines are copied into OrderLines automatically; if both are set the quote wins and the opportunity is ignored. |
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, not entered: LineSubTotal + TotalTaxAmount2 - AmountPaid - FinanceAmount. It is a different measure from OpenAmount (TotalOrderAmount - AdvanceAmount) — outstanding nets tax, cash received and finance, while open nets only the advance. |
OwnerId | Owner | Lookup → UserAccount | Yes | |
PartnerAccountId | Partner Account | Lookup → Account | | The selling party in multi-party dealer and distributor flows, validated against BranchId. Together with AccountId it identifies the pair whose credit limit is checked when the order is created. |
PendingDeliveryQuantity | Pending Delivery Quantity | Calculated (calculated) | | |
PendingFulfilmentAllocationQuantity | Pending Fulfilment Allocation Quantity | Calculated (calculated) | | |
PendingFulfilmentQuantity | Pending Fulfilment Quantity | Calculated (calculated) | | Pending Fulfillment Quantity |
PendingInvoiceQuantity | Pending Invoice Quantity | Calculated (calculated) | | |
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 | | |
PriceListId | Price List | Lookup → PriceList | | |
PromisedDate | Promised Date | Date | | |
PurchaseOrderId | Purchase Order | Lookup → PurchaseOrder | | |
QuoteId | Quote | Lookup → Quote | | Source quote. When an order is inserted with this set, the platform copies that quote's lines into OrderLines automatically — item, quantity, unit prices, discounts, tax group, SKU and lot type — so the lines should not be created by hand as well. |
RecordTypeId | Record Type | Guid, hidden | | |
Remark | Remark | Text | | |
RequiredDate | Tentative Buying Date | Date | | Stored as RequiredDate but labelled 'Tentative Buying Date' — the customer's expected purchase date rather than a delivery commitment. PromisedDate is the separate commitment field. |
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 | | |
SourceOfSupply | Source of Supply | PickList | | Values: Maharashtra, Gujarat, Rajasthan, Haryana. |
Status | Status | PickList | | 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 | | 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) | | Calculated sum of OrderLine.NetDiscount — the resolved value of the regular, cash and contract discount pairs on the lines. Promotion value is excluded and rolls up separately into TotalSchemeDiscountAmount. |
TotalLineBaseAmount | Total Line Base Amount | Calculated (calculated) | | |
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) | | |
TotalSchemeDiscountAmount | Total Scheme Amount | Calculated (calculated) | | Labelled 'Total Scheme Amount': the calculated sum of OrderLine.NetSchemeDiscount, i.e. the promotion-engine discount on the lines, deliberately kept apart from TotalDiscountAmount. |
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. When such an order is inserted the platform also writes this order's id back onto the Visit, so visit and order reference each other. |
VisitPlanId | Visit Plan | Lookup → VisitPlan | | |
VisitRouteId | Visit Route | Lookup → VisitRoute | | |