Skip to main content

Sales Order

Summary

A Sales Order is a document that records a customer's request to purchase goods or services from a company. It includes information such as the customer's name, address, contact information, the items being ordered, the quantity of each item, the price of each item, and the total amount of the order.

Schema

SalesOrder

Data TypeField NameRulesAbout
AttributeFieldattributeFieldZero to Many[Attribute Field]
BusinessPartnerbillToZero or OneInternal reference to the business partner record of the party to receive billing information
BusinessPartnerbusinessPartnerZero to ManyA list of all other potential business partners involved in the sales order
BusinessPartnerbuyerZero to OneInternal reference to the business partner record of the Sold to party
stringbuyerPoNumberZero or OneExternal purchase order number provided by the buyer
CustomerAccountcustomerAccountZero to OneDocument reference to the customer account document for which the order is placed.
CustomerAccountreceivingCustomerAccountZero to OneRepresents the customer designated to receive the sales order.
DateTimedeliveryDateZero or OneRequested date time of delivery
ExtensionFieldextendedByZero to ManyRefer to: Extension Field
ExternalIDexternalIdentityZero to ManyRefer to: External ID
MonetarygrossAmountZero or OneTotal amount of an order for the sale of goods or services, before any adjustments.
MonetarynetAmountZero or OneThe amount of money a company actually receives from a customer after any discounts, returns, or allowances have been applied.
DateTimeorderDateZero or OneThe date and time the order was placed in the originating system
BusinessPartnerpayerZero to OneInternal reference to the business partner record for the party responsible for payment
BusinessPartnerreceiverZero to OneInternal reference to the business partner record for the party to who the goods will be delivered
RecordedByUserrecordedByZero to ManyThe user who captured the sales order in the originating system
BusinessPartnersalesEmployeeZero or OneInternal reference to the business partner record of the sales representative responsible for the receiver business partner
BusinessPartnersellerZero to OneInternal reference to the business partner record for the sales organization
stringsourceSystemCodeZero or OneRefer to: Source System
stringsourceSystemIDZero or OneRefer to: Source System
MonetarytaxAmountZero or OneMonetary amount of tax applied to the sales order
TaxTypetaxTypeZero or OneDocument Reference to the TaxType document describing the tax applied to the Sales Order.
stringtransactionNumberZero or OneBusiness defined canonical user facing sales order number.
SalesOrderItemtxDocumentZero to ManyA collection of all the items included in the sales order.

SalesOrderItem

Data TypeField NameRulesAbout
AttributeFieldattributeFieldZero to ManyRefer to: Attribute Field
ProductcatalogItemZero or OneRefer to: Product
MonetarycostAmountZero or OneItem price before markup, taxes etc. Disposition: Under consideration for deprecation. See Price Element
MonetarydiscountAmountZero or OneMonetary amount to be deducted from the sales order item. Disposition: Under consideration for deprecation.See Price Element
DecimaldiscountRateZero or OnePercentage to be deducted from the gross amount as a discount on this sales order item. Disposition: Under consideration for deprecation. See Price Element
ExtensionFieldextendedByZero to ManyRefer to: Extension Field
ExternalIDexternalIdentityZero to ManyRefer to: External ID
MonetaryfreightAmountZero or OneDisposition: Under consideration for deprecation. See Price Element
StringitemIdentifierZero or OneThe customer-facing identifier for this item.
MonetarygrossAmountZero or OneTotal amount for the line item, before any adjustments for the sale of the good or service. Disposition: Under consideration for deprecation. See Price Element
StringlineNumberZero or OneThe number of this sales order item within the collection of sales order items on the parent sales order.
MonetarylistAmountZero or OneListed price for this sales order item. Disposition: Under consideration for deprecation. See Price Element
MonetarynetAmountZero or OneThe amount of money a company actually receives for this sales order item from a customer after any discounts, returns, or allowances have been applied. Disposition: Under consideration for deprecation. See Price Element
SalesOrderItemOverallStatusoverallStatusZero or OneExternal system status of the sales order item. (Open, In Progress, Complete) Refer to: Overall Status
MagnitudequantityZero or OneNumber of items requested for this sales order line item
RecordedByUserrecordedByZero to ManyReference to the record for the user who captured the sales order item in the originating system
DecimalremainingQuantityZero or OneThe quantity of a product or service that is still outstanding and has not yet been delivered or fulfilled to the customer as part of a sales order.
StringsourceSystemCodeZero or OneRefer to: Source System
StringsourceSystemIDZero or OneRefer to: Source System
MonetarytaxAmountZero or OneThe monetary amount of the tax applied to the sales order item.
DecimaltaxRateZero or OneA percentage rate of the tax applied to the sales order item
TaxTypetaxTypeZero or OneDescription and reference of the tax applied to the Sales Order Item. Refer to: Tax Type
MonetaryunitAmountZero or OneDisposition: Under consideration for deprecation. See Price Element
MonetaryunitCostAmountZero or OneDisposition: Under consideration for deprecation. See Price Element
MonetaryunitFreightAmountZero or OneDisposition: Under consideration for deprecation. See Price Element
ScheduleLineItemscheduleLineItemZero to ManyA collection of items documenting changes to actual delivery date vs original expected delivery date. Schedule Line Item
PriceElementpriceElementZero to ManyA collection of all the monetary movements recorded for this sales order item.
StringsupplyingPlantCodeZero or OneThe plant that fulfills the sales order item.

Price Element

A price element refers to the individual components or factors that contribute to the determination of the final price for a product or service. These elements can include various costs, discounts, taxes, and other factors that impact the overall pricing structure.

Data TypeField NameAbout
MonetaryadjustmentAmountThe monetary value of the price element along with it’s currency etc.
stringdescriptionOptional text description for the price element
stringlineNumberDenotes the order of the price element in relation to other price elements in the sales order item’s set of price elements
PriceElementTypepriceElementTypeType of the price element.

Note omitted fields: attributeField, extendedBy, externalIdentity, recordedBy, sourceSystemCode, sourceSystemId, uniqueText.

PriceElementType

Data TypeDescription
stringListAmount
stringMinimumCharge
stringHeaderFreight
stringFreightAdmin
stringDownPayment
stringTax
stringCost
stringDiscretionaryDiscount
stringBillingDiscount

ScheduleLineItem

A Sales Order Schedule Line represents a specific delivery schedule for an item within a Sales Order Line Item. It defines the planned delivery date, quantity, and fulfillment status for a given sales order.

Data TypeField NameAbout
DateTimeconfirmedDeliveryDateDate confirmed for delivery (e.g. based on stock availability).
DecimalconfirmedQuantityQuantity that has been confirmed for delivery (e.g. based on stock availability).
StringlineNumberSequential number to differentiate multiple schedule lines within the same schedule line.
DecimalquantityDeliveredTotal quantity of the item that has been delivered.
DateTimerequestedDeliveryDateDate the customer initially requested for delivery of the schedule line quantity. This is typically based on customer expectations rather than system availability.

Note omitted fields: attributeField, extendedBy, externalIdentity, recordedBy, sourceSystemCode, sourceSystemId, uniqueText.

Sample JSON

{
"@type": "SalesOrder",
"externalIdentity": [
{
"@type": "ExternalID",
"internalType": "SalesOrder",
"externalSystemCode": "OurExternalSystem1",
"externalId": "130"
},
{
"@type": "ExternalID",
"internalType": "SalesOrder",
"externalSystemCode": "OurExternalSystem2",
"externalId": "ABC"
}
],
"transactionNumber": "TransactionNumber-130",
"netAmount": {
"@type": "Monetary",
"decimalValue": 452,
"uniqueText": "380e3a73-33f8-4bc9-9abd-ea1f07ef6eaa",
"currency": "https://schema.limbergraph.com/limber/CurrencyUnit#NZD"
},
"buyerPoNumber": "202203181050",
"deliveryDate": "2022-03-17T21:50:31Z",
"orderDate": "2022-03-17T21:50:31Z",
"sourceSystemCode": "OurExternalSystem1",
"sourceSystemId": "130",
"buyer": {
"@type": "InternalReference",
"id": "22b64325-1c8b-4068-8e2d-bb1eff547e0f",
"className": "BusinessPartner",
"externalIdentities": [
{
"integrationKey": "NzSl",
"externalId": "aed8e6d7-f1a5-48aa-9ff8-ee0f6b3b9bef"
}
],
"keys": [
{
"uniqueText": "22b64325-1c8b-4068-8e2d-bb1eff547e0f"
}
]
},
"payer": {
"@type": "InternalReference",
"id": "22b64325-1c8b-4068-8e2d-bb1eff547e0f",
"className": "BusinessPartner",
"externalIdentities": [
{
"integrationKey": "NzSl",
"externalId": "aed8e6d7-f1a5-48aa-9ff8-ee0f6b3b9bef"
}
],
"keys": [
{
"uniqueText": "22b64325-1c8b-4068-8e2d-bb1eff547e0f"
}
]
},
"receiver": {
"@type": "InternalReference",
"id": "66be9b2c-d86d-4525-9d39-4a36af6211b1",
"className": "BusinessPartner",
"externalIdentities": [
{
"integrationKey": "NzSl",
"externalId": "52e4a5b9-7c3a-482f-91bf-df40964bd14d"
},
{
"integrationKey": "NZIntegrationB2B",
"externalId": "875786"
}
],
"keys": [
{
"uniqueText": "66be9b2c-d86d-4525-9d39-4a36af6211b1"
}
]
},
"seller": {
"@type": "InternalReference",
"id": "97ea228b-cfab-43c6-a113-900daeb4b73b",
"className": "BusinessPartner",
"externalIdentities": [
{
"integrationKey": "NzSl",
"externalId": "NZCG"
}
],
"keys": [
{
"uniqueText": "97ea228b-cfab-43c6-a113-900daeb4b73b"
}
]
},
"customerAccount": "https://schema.limbergraph.com/limber/CustomerAccount#9276be12-f1c0-4647-997d-7e2ae485d9bd",
"businessPartner": [
{
"@type": "BusinessPartner",
"uniqueText": "22b64325-1c8b-4068-8e2d-bb1eff547e0f",
"externalIdentity": [
{
"@type": "ExternalID",
"internalType": "BusinessPartner",
"externalSystemCode": "NzSl",
"externalId": "aed8e6d7-f1a5-48aa-9ff8-ee0f6b3b9bef"
}
],
"extendedBy": [
{
"@type": "ExtensionField",
"uniqueText": "bb388da7-1286-449f-a97d-f9b1164c5f87",
"key": "externalSystemCustomerNumber",
"value": ["2372-0"]
},
{
"@type": "ExtensionField",
"uniqueText": "654e0299-5734-483e-9fc5-87c6c9d2eaf5",
"key": "siteCode",
"value": ["Auck"]
},
{
"@type": "ExtensionField",
"uniqueText": "149fb2a7-6513-4712-860d-f6ee6369f2fb",
"key": "shipSite",
"value": ["auck"]
},
{
"@type": "ExtensionField",
"uniqueText": "820709b1-b35c-48aa-aa1f-9dcd0389f211",
"key": "priceCode",
"value": ["CBR"]
}
],
"emailAddress": {
"@type": "EmailAddress",
"uniqueText": "da97fba3-81d0-4a96-a9fa-cfa6e2b65972",
"email": "[email protected]"
},
"phoneAddress": {
"@type": "PhoneAddress",
"uniqueText": "4320b5d5-590a-4ca1-abcb-6e2fb54ea680",
"addressType": "https://schema.limbergraph.com/limber/PhoneAddressType#Phone",
"phoneNumber": "555 123 4567"
},
"physicalAddress": {
"@type": "PhysicalAddress",
"uniqueText": "a8283b40-5d68-4f04-8199-499d998e7180",
"extendedBy": [],
"line1": "Company Name",
"line2": "PO Box 999",
"regionName": "WAI",
"postalCode": "3443",
"cityName": "Putaruru",
"country": "https://schema.limbergraph.com/limber/Country#NZ"
},
"primaryName": "Company Name Here",
"businessPartnerRole": [
"https://schema.limbergraph.com/limber/BusinessPartnerRole#Payer",
"https://schema.limbergraph.com/limber/BusinessPartnerRole#Buyer"
]
},
{
"@type": "BusinessPartner",
"uniqueText": "66be9b2c-d86d-4525-9d39-4a36af6211b1",
"externalIdentity": [
{
"@type": "ExternalID",
"internalType": "BusinessPartner",
"externalSystemCode": "NzSl",
"externalId": "52e4a5b9-7c3a-482f-91bf-df40964bd14d"
},
{
"@type": "ExternalID",
"internalType": "BusinessPartner",
"externalSystemCode": "NZBeddingPortalBundleB2B",
"externalId": "875786"
}
],
"extendedBy": [
{
"@type": "ExtensionField",
"uniqueText": "8f69ca07-4bc5-4f68-99da-6f9bcee6532c",
"key": "externalSystemCustomerNumber",
"value": ["2372-1"]
},
{
"@type": "ExtensionField",
"uniqueText": "869dd8af-894c-49bd-a836-92c9e31c9015",
"key": "isPortalCustomer",
"value": ["true"]
},
{
"@type": "ExtensionField",
"uniqueText": "56019088-f68f-4b73-bde1-109e66a21993",
"key": "siteCode",
"value": ["Auck"]
},
{
"@type": "ExtensionField",
"uniqueText": "48761034-62e3-47fd-9f66-071077d235b0",
"key": "shipSite",
"value": ["auck"]
}
],
"physicalAddress": {
"@type": "PhysicalAddress",
"uniqueText": "3e1e50fd-0b92-40bc-90e9-3a5f3db167c4",
"extendedBy": [
{
"@type": "ExtensionField",
"uniqueText": "b3ee55d8-8ed0-47ec-960f-f9d6b5787659",
"key": "houseNumber",
"value": ["34"]
},
{
"@type": "ExtensionField",
"uniqueText": "06bf86b5-ead4-41d4-a112-48ae7889a39d",
"key": "streetSuffixName",
"value": ["34"]
}
],
"line1": "34 Some Street",
"regionName": "WAI",
"postalCode": "3200",
"cityName": "Somewhere",
"country": "https://schema.limbergraph.com/limber/Country#NZ"
},
"primaryName": "Bed Company",
"businessPartnerRole": [
"https://schema.limbergraph.com/limber/BusinessPartnerRole#Receiver"
]
},
{
"@type": "BusinessPartner",
"uniqueText": "97ea228b-cfab-43c6-a113-900daeb4b73b",
"externalIdentity": [
{
"@type": "ExternalID",
"internalType": "BusinessPartner",
"externalSystemCode": "NzSl",
"externalId": "NZCG"
}
],
"primaryName": "Another Company",
"businessPartnerRole": [
"https://schema.limbergraph.com/limber/BusinessPartnerRole#Seller"
]
}
],
"txDocItem": [
{
"@type": "SalesOrderItem",
"externalIdentity": [
{
"@type": "ExternalID",
"internalType": "SalesOrderItem",
"externalSystemCode": "NZBeddingPortalBC",
"externalId": "32"
}
],
"extendedBy": [],
"lineNumber": "1",
"grossAmount": {
"@type": "Monetary",
"decimalValue": 519.8,
"uniqueText": "b4017b7d-a3e3-4822-9c36-e3467020a15d",
"currency": "https://schema.limbergraph.com/limber/CurrencyUnit#NZD"
},
"netAmount": {
"@type": "Monetary",
"decimalValue": 452,
"uniqueText": "e6e1fb9e-3548-4a67-accb-ed08cd3d3bb9",
"currency": "https://schema.limbergraph.com/limber/CurrencyUnit#NZD"
},
"taxAmount": {
"@type": "Monetary",
"decimalValue": 67.8,
"uniqueText": "dfbcd687-d0d3-4dd6-a734-e2a96c0e836d",
"currency": "https://schema.limbergraph.com/limber/CurrencyUnit#NZD"
},
"taxType": "https://schema.limbergraph.com/limber/TaxType#GST_STANDARD_NZ",
"catalogItem": "https://schema.limbergraph.com/limber/Product#893db725-76d9-4f14-9030-b5914283a299",
"costAmount": {
"@type": "Monetary",
"decimalValue": 0,
"uniqueText": "86e9d2f8-aebc-4c22-b443-e938752ae8ec",
"currency": "https://schema.limbergraph.com/limber/CurrencyUnit#NZD"
},
"listAmount": {
"@type": "Monetary",
"decimalValue": 452,
"uniqueText": "6c28a0ac-2d41-46cf-9b45-a98e172c07f9",
"currency": "https://schema.limbergraph.com/limber/CurrencyUnit#NZD"
},
"quantity": {
"@type": "Magnitude",
"decimalValue": 1,
"uom": "https://schema.limbergraph.com/limber/UnitOfMeasure#each",
"uniqueText": "99e3543a-3366-46a2-82f6-dba776d868be"
},
"unitAmount": {
"@type": "Monetary",
"decimalValue": 452,
"uniqueText": "cee9aeb1-7ebe-4800-a733-9d3ef9f3b4e1",
"currency": "https://schema.limbergraph.com/limber/CurrencyUnit#NZD"
},
"unitCostAmount": {
"@type": "Monetary",
"decimalValue": 0,
"uniqueText": "e5724827-094b-49eb-9b52-728f7d7699c4",
"currency": "https://schema.limbergraph.com/limber/CurrencyUnit#NZD"
},
"uniqueText": "4deeb144-2553-4041-a514-1242db160f29",
"priceElement": [
{
"@type": "PriceAdjustment",
"adjustmentAmount": "https://schema.limbergraph.com/limber/CurrencyUnit#NZD",
"priceElementType": "https://schema.limbergraph.com/limber/PriceElementType#Cost",
"uniqueText": "f423f760-c697-491d-9f96-56b82855e07b"
}
]
}
],
"uniqueText": "8ba0a038-79f0-422f-a84b-0d0fa1e618c1"
}