Page 6403 "Sales Document Line Entity"
Base Application · Microsoft.Integration.Entity
Across versions
- BC23-30present
Neighbourhood 2 connected objects and pages
Base Application · Microsoft.Integration.Entity · BC23-30 · source at ea08af5e · facts from BC29
Properties
| Property | Value |
|---|---|
| Caption | ‘Sales Document Line Entity’, Locked = true |
| SourceTable | Sales Line |
| PageType | ListPart |
Fields on this page
Layout controls in source order, grouped by the container they sit in. Shows: the table field a control is bound to (or its expression as written); ToolTip: the control’s own, else the bound field’s (marked).
| Group | Control | Shows | ToolTip |
|---|---|---|---|
| Group | documentType | Document Type | Specifies the type of document that you are about to create. from the table field |
| sellToCustomerNumber | Sell-to Customer No. | Specifies the number of the customer. from the table field | |
| documentNumber | Document No. | Specifies the document number. from the table field | |
| lineNumber | Line No. | Specifies the line number. from the table field | |
| type | Type | Specifies the type of entity that will be posted for this sales line, such as Item, Resource, or G/L Account. The type that you enter in this field determines what you can select in the No. field. from the table field | |
| number | No. | Specifies the number of the involved entry or record, according to the specified number series. from the table field | |
| locationCode | Location Code | Specifies the inventory location from which the items sold should be picked and where the inventory decrease is registered. from the table field | |
| postingGroup | Posting Group | — | |
| shipmentDate | Shipment Date | Specifies when items on the document are shipped or were shipped. A shipment date is usually calculated from a requested delivery date plus lead time. from the table field | |
| description | Description | Specifies a description of the entry of the product to be sold. To add a non-transactional text line, fill in the Description field only. from the table field | |
| description2 | Description 2 | Specifies information in addition to the description. from the table field | |
| unitOfMeasure | Unit of Measure | Specifies the unit of measure for the item or resource on the sales line. from the table field | |
| quantity | Quantity | Specifies how many units are being sold. from the table field | |
| outstandingQuantity | Outstanding Quantity | Specifies how many units on the order line have not yet been shipped. from the table field | |
| qtyToInvoice | Qty. to Invoice | Specifies the quantity that remains to be invoiced. It is calculated as Quantity - Qty. Invoiced. from the table field | |
| qtyToShip | Qty. to Ship | Specifies the quantity of items that remain to be shipped. from the table field | |
| unitPrice | Unit Price | Specifies the price for one unit on the sales line. from the table field | |
| unitCostLcy | Unit Cost (LCY) | — | |
| vatPercent | VAT % | — | |
| lineDiscountPercent | Line Discount % | Specifies the discount percentage that is granted for the item on the line. from the table field | |
| lineDiscountAmount | Line Discount Amount | Specifies the discount amount that is granted for the item on the line. from the table field | |
| amount | Amount | Specifies the sum of amounts in the Line Amount field on the sales return order lines. from the table field | |
| amountIncludingVat | Amount Including VAT | — | |
| allowInvoiceDisc | Allow Invoice Disc. | Specifies if the invoice line is included when the invoice discount is calculated. from the table field | |
| grossWeight | Gross Weight | Specifies the gross weight of one unit of the item. In the sales statistics window, the gross weight on the line is included in the total gross weight of all the lines for the particular sales document. from the table field | |
| netWeight | Net Weight | Specifies the net weight of one unit of the item. In the sales statistics window, the net weight on the line is included in the total net weight of all the lines for the particular sales document. from the table field | |
| unitsPerParcel | Units per Parcel | Specifies the number of units per parcel of the item. In the sales statistics window, the number of units per parcel on the line helps to determine the total number of units for all the lines for the particular sales document. from the table field | |
| unitVolume | Unit Volume | Specifies the volume of one unit of the item. In the sales statistics window, the volume of one unit of the item on the line is included in the total volume of all the lines for the particular sales document. from the table field | |
| applToItemEntry | Appl.-to Item Entry | Specifies the number of the item ledger entry that the document or journal line is applied -to. from the table field | |
| shortcutDimension1Code | Shortcut Dimension 1 Code | Specifies the code for Shortcut Dimension 1, which is one of two global dimension codes that you set up in the General Ledger Setup window. from the table field | |
| shortcutDimension2Code | Shortcut Dimension 2 Code | Specifies the code for Shortcut Dimension 2, which is one of two global dimension codes that you set up in the General Ledger Setup window. from the table field | |
| customerPriceGroup | Customer Price Group | — | |
| jobNumber | Job No. | Specifies the number of the related project. If you fill in this field and the Project Task No. field, then a project ledger entry will be posted together with the sales line. from the table field | |
| workTypeCode | Work Type Code | Specifies which work type the resource applies to when the sale is related to a project. from the table field | |
| recalculateInvoiceDisc | Recalculate Invoice Disc. | — | |
| outstandingAmount | Outstanding Amount | — | |
| qtyShippedNotInvoiced | Qty. Shipped Not Invoiced | — | |
| shippedNotInvoiced | Shipped Not Invoiced | — | |
| quantityShipped | Quantity Shipped | Specifies how many units of the item on the line have been posted as shipped. from the table field | |
| quantityInvoiced | Quantity Invoiced | Specifies how many units of the item on the line have been posted as invoiced. from the table field | |
| shipmentNumber | Shipment No. | — | |
| shipmentLineNumber | Shipment Line No. | — | |
| profitPercent | Profit % | — | |
| billToCustomerNumber | Bill-to Customer No. | — | |
| invDiscountAmount | Inv. Discount Amount | Specifies the invoice discount amount for the line. from the table field | |
| purchaseOrderNumber | Purchase Order No. | — | |
| purchOrderLineNumber | Purch. Order Line No. | — | |
| dropShipment | Drop Shipment | Specifies if your vendor ships the items directly to your customer. from the table field | |
| genBusPostingGroup | Gen. Bus. Posting Group | Specifies the vendor’s or customer’s trade type to link transactions made for this business partner with the appropriate general ledger account according to the general posting setup. from the table field | |
| genProdPostingGroup | Gen. Prod. Posting Group | Specifies the item’s product type to link transactions made for this item with the appropriate general ledger account according to the general posting setup. from the table field | |
| vatCalculationType | VAT Calculation Type | — | |
| transactionType | Transaction Type | — | |
| transportMethod | Transport Method | — | |
| attachedToLineNumber | Attached to Line No. | Specifies the line number to which this sales line is attached. from the table field | |
| exitPoint | Exit Point | — | |
| area | Area | — | |
| transactionSpecification | Transaction Specification | — | |
| taxCategory | Tax Category | Specifies the VAT category in connection with electronic document sending. For example, when you send sales documents through the PEPPOL service, the value in this field is used to populate several fields, such as the ClassifiedTaxCategory element in the Item group. It is also used to populate the T… from the table field | |
| taxAreaCode | Tax Area Code | Specifies the tax area that is used to calculate and post sales tax. from the table field | |
| taxLiable | Tax Liable | Specifies if the customer or vendor is liable for sales tax. from the table field | |
| taxGroupCode | Tax Group Code | Specifies the tax group that is used to calculate and post sales tax. from the table field | |
| vatClauseCode | VAT Clause Code | — | |
| vatBusPostingGroup | VAT Bus. Posting Group | Specifies the vendor’s VAT specification to link transactions made for this vendor with the appropriate general ledger account according to the VAT posting setup. from the table field | |
| vatProdPostingGroup | VAT Prod. Posting Group | Specifies the VAT product posting group. Links business transactions made for the item, resource, or G/L account with the general ledger, to account for VAT amounts resulting from trade with that record. from the table field | |
| currencyCode | Currency Code | Specifies the currency that is used on the entry. from the table field | |
| outstandingAmountLcy | Outstanding Amount (LCY) | — | |
| shippedNotInvoicedLcy | Shipped Not Invoiced (LCY) | — | |
| shippedNotInvLcyNoVat | Shipped Not Inv. (LCY) No VAT | — | |
| reservedQuantity | Reserved Quantity | Specifies how many units of the item on the line have been reserved. from the table field | |
| reserve | Reserve | Specifies whether a reservation can be made for items on this line. from the table field | |
| blanketOrderNumber | Blanket Order No. | Specifies the number of the blanket order that the record originates from. from the table field | |
| blanketOrderLineNumber | Blanket Order Line No. | Specifies the number of the blanket order line that the record originates from. from the table field | |
| vatBaseAmount | VAT Base Amount | — | |
| unitCost | Unit Cost | — | |
| systemCreatedEntry | System-Created Entry | — | |
| lineAmount | Line Amount | Specifies the net amount, excluding any invoice discount amount, that must be paid for products on the line. from the table field | |
| vatDifference | VAT Difference | — | |
| invDiscAmountToInvoice | Inv. Disc. Amount to Invoice | Specifies the actual invoice discount amount that will be posted for the line in next invoice. from the table field | |
| vatIdentifier | VAT Identifier | — | |
| icPartnerRefType | IC Partner Ref. Type | Specifies the item or account in your IC partner’s company that corresponds to the item or account on the line. from the table field | |
| icPartnerReference | IC Partner Reference | Specifies the IC partner. If the line is being sent to one of your intercompany partners, this field is used together with the IC Partner Ref. Type field to indicate the item or account in your partner’s company that corresponds to the line. from the table field | |
| prepaymentPercent | Prepayment % | Specifies the prepayment percentage to use to calculate the prepayment for sales. from the table field | |
| prepmtLineAmount | Prepmt. Line Amount | Specifies the prepayment amount of the line in the currency of the sales document if a prepayment percentage is specified for the sales line. from the table field | |
| prepmtAmtInv | Prepmt. Amt. Inv. | Specifies the prepayment amount that has already been invoiced to the customer for this sales line. from the table field | |
| prepmtAmtInclVat | Prepmt. Amt. Incl. VAT | — | |
| prepaymentAmount | Prepayment Amount | — | |
| prepmtVatBaseAmt | Prepmt. VAT Base Amt. | — | |
| prepaymentVatPercent | Prepayment VAT % | — | |
| prepmtVatCalcType | Prepmt. VAT Calc. Type | — | |
| prepaymentVatIdentifier | Prepayment VAT Identifier | — | |
| prepaymentTaxAreaCode | Prepayment Tax Area Code | — | |
| prepaymentTaxLiable | Prepayment Tax Liable | — | |
| prepaymentTaxGroupCode | Prepayment Tax Group Code | — | |
| prepmtAmtToDeduct | Prepmt Amt to Deduct | Specifies the prepayment amount that has already been deducted from ordinary invoices posted for this sales order line. from the table field | |
| prepmtAmtDeducted | Prepmt Amt Deducted | Specifies the prepayment amount that has already been deducted from ordinary invoices posted for this sales order line. from the table field | |
| prepaymentLine | Prepayment Line | — | |
| prepmtAmountInvInclVat | Prepmt. Amount Inv. Incl. VAT | — | |
| prepmtAmountInvLcy | Prepmt. Amount Inv. (LCY) | — | |
| icPartnerCode | IC Partner Code | Specifies the code of the intercompany partner that the transaction is related to if the entry was created from an intercompany transaction. from the table field | |
| prepmtVatAmountInvLcy | Prepmt. VAT Amount Inv. (LCY) | — | |
| prepaymentVatDifference | Prepayment VAT Difference | — | |
| prepmtVatDiffToDeduct | Prepmt VAT Diff. to Deduct | — | |
| prepmtVatDiffDeducted | Prepmt VAT Diff. Deducted | — | |
| dimensionSetId | Dimension Set ID | — | |
| qtyToAssembleToOrder | Qty. to Assemble to Order | Specifies how many units of the sales line quantity that you want to supply by assembly. from the table field | |
| qtyToAsmToOrderBase | Qty. to Asm. to Order (Base) | — | |
| atoWhseOutstandingQty | ATO Whse. Outstanding Qty. | Specifies how many assemble-to-order units on the sales order line need to be assembled and handled in warehouse documents. from the table field | |
| atoWhseOutstdQtyBase | ATO Whse. Outstd. Qty. (Base) | — | |
| jobTaskNumber | Job Task No. | Specifies the number of the related project task. from the table field | |
| jobContractEntryNumber | Job Contract Entry No. | Specifies the entry number of the project planning line that the sales line is linked to. from the table field | |
| postingDate | Posting Date | — | |
| deferralCode | Deferral Code | Specifies the deferral template that governs how revenue earned with this sales document is deferred to the different accounting periods when the good or service was delivered. from the table field | |
| returnsDeferralStartDate | Returns Deferral Start Date | Specifies the starting date of the returns deferral period. from the table field | |
| variantCode | Variant Code | Specifies the variant of the item on the line. from the table field | |
| binCode | Bin Code | Specifies the bin where the items are picked or put away. from the table field | |
| qtyPerUnitOfMeasure | Qty. per Unit of Measure | Specifies an auto-filled number if you have included Sales Unit of Measure on the item card and a quantity in the Qty. per Unit of Measure field. from the table field | |
| planned | Planned | — | |
| unitOfMeasureCode | Unit of Measure Code | Specifies how each unit of the item or resource is measured, such as in pieces or hours. By default, the value in the Base Unit of Measure field on the item or resource card is inserted. from the table field | |
| quantityBase | Quantity (Base) | — | |
| outstandingQtyBase | Outstanding Qty. (Base) | — | |
| qtyToInvoiceBase | Qty. to Invoice (Base) | — | |
| qtyToShipBase | Qty. to Ship (Base) | — | |
| qtyShippedNotInvdBase | Qty. Shipped Not Invd. (Base) | — | |
| qtyShippedBase | Qty. Shipped (Base) | — | |
| qtyInvoicedBase | Qty. Invoiced (Base) | — | |
| reservedQtyBase | Reserved Qty. (Base) | Specifies the value in the Reserved Quantity field, expressed in the base unit of measure. from the table field | |
| faPostingDate | FA Posting Date | Specifies the date that will be used on related fixed asset ledger entries. from the table field | |
| depreciationBookCode | Depreciation Book Code | Specifies the code for the depreciation book to which the line will be posted if you have selected Fixed Asset in the Type field for this line. from the table field | |
| deprUntilFaPostingDate | Depr. until FA Posting Date | Specifies if depreciation was calculated until the FA posting date of the line. from the table field | |
| duplicateInDepreciationBook | Duplicate in Depreciation Book | Specifies a depreciation book code if you want the journal line to be posted to that depreciation book, as well as to the depreciation book in the Depreciation Book Code field. from the table field | |
| useDuplicationList | Use Duplication List | Specifies, if the type is Fixed Asset, that information on the line is to be posted to all the assets defined depreciation books. from the table field | |
| responsibilityCenter | Responsibility Center | — | |
| outOfStockSubstitution | Out-of-Stock Substitution | — | |
| substitutionAvailable | Substitution Available | Specifies that a substitute is available for the item on the sales line. from the table field | |
| originallyOrderedNumber | Originally Ordered No. | — | |
| originallyOrderedVarCode | Originally Ordered Var. Code | — | |
| itemReferenceNumber | Item Reference No. | Specifies item reference number. | |
| itemRefUnitOfMeasure | Item Reference Unit of Measure | Specifies item reference unit of measure code. | |
| itemReferenceType | Item Reference Type | Specifies item reference type. | |
| itemReferenceTypeNumber | Item Reference Type No. | Specifies item reference type number. | |
| itemCategoryCode | Item Category Code | — | |
| nonstock | Nonstock | Specifies that this item is a catalog item. from the table field | |
| purchasingCode | Purchasing Code | Specifies the code for a special procurement method, such as drop shipment. from the table field | |
| specialOrder | Special Order | Specifies that the item on the sales line is a special-order item. from the table field | |
| specialOrderPurchaseNumber | Special Order Purchase No. | — | |
| specialOrderPurchLineNumber | Special Order Purch. Line No. | — | |
| whseOutstandingQty | Whse. Outstanding Qty. | Specifies how many units on the sales order line remain to be handled in warehouse documents. from the table field | |
| whseOutstandingQtyBase | Whse. Outstanding Qty. (Base) | — | |
| completelyShipped | Completely Shipped | — | |
| requestedDeliveryDate | Requested Delivery Date | Specifies the date that the customer has asked for the order to be delivered. from the table field | |
| promisedDeliveryDate | Promised Delivery Date | Specifies the date that you have promised to deliver the order, as a result of the Order Promising function. from the table field | |
| shippingTime | Shipping Time | Specifies how long it takes from when the items are shipped from the warehouse to when they are delivered. from the table field | |
| outboundWhseHandlingTime | Outbound Whse. Handling Time | Specifies a date formula for the time it takes to get items ready to ship from this location. The time element is used in the calculation of the delivery date as follows: Shipment Date + Outbound Warehouse Handling Time = Planned Shipment Date + Shipping Time = Planned Delivery Date. from the table field | |
| plannedDeliveryDate | Planned Delivery Date | Specifies the planned date that the shipment will be delivered at the customer’s address. If the customer requests a delivery date, the program calculates whether the items will be available for delivery on this date. If the items are available, the planned delivery date will be the same as the requ… from the table field | |
| plannedShipmentDate | Planned Shipment Date | Specifies the date that the shipment should ship from the warehouse. If the customer requests a delivery date, the program calculates the planned shipment date by subtracting the shipping time from the requested delivery date. If the customer does not request a delivery date or the requested deliver… from the table field | |
| shippingAgentCode | Shipping Agent Code | Specifies the code for the shipping agent who is transporting the items. from the table field | |
| shippingAgentServiceCode | Shipping Agent Service Code | Specifies the code for the service, such as a one-day delivery, that is offered by the shipping agent. from the table field | |
| allowItemChargeAssignment | Allow Item Charge Assignment | Specifies that you can assign item charges to this line. from the table field | |
| qtyToAssign | Qty. to Assign | Specifies how many units of the item charge will be assigned to the line. from the table field | |
| qtyAssigned | Qty. Assigned | Specifies the quantity of the item charge that was assigned to a specified item when you posted this sales line. from the table field | |
| returnQtyToReceive | Return Qty. to Receive | Specifies the quantity of items that remain to be shipped. from the table field | |
| returnQtyToReceiveBase | Return Qty. to Receive (Base) | — | |
| returnQtyRcdNotInvd | Return Qty. Rcd. Not Invd. | — | |
| retQtyRcdNotInvdBase | Ret. Qty. Rcd. Not Invd.(Base) | — | |
| returnRcdNotInvd | Return Rcd. Not Invd. | — | |
| returnRcdNotInvdLcy | Return Rcd. Not Invd. (LCY) | — | |
| returnQtyReceived | Return Qty. Received | Specifies how many units of the item on the line have been posted as shipped. from the table field | |
| returnQtyReceivedBase | Return Qty. Received (Base) | — | |
| applFromItemEntry | Appl.-from Item Entry | Specifies the number of the item ledger entry that the document or journal line is applied from. from the table field | |
| bomItemNumber | BOM Item No. | — | |
| returnReceiptNumber | Return Receipt No. | — | |
| returnReceiptLineNumber | Return Receipt Line No. | — | |
| returnReasonCode | Return Reason Code | Specifies the code explaining why the item was returned. from the table field | |
| allowLineDisc | Allow Line Disc. | — | |
| customerDiscGroup | Customer Disc. Group | — | |
| subtype | Subtype | — | |
| priceDescription | Price description | — |
Procedures
1 local procedures, no public ones.
Triggers
OnInsertRecord, OnModifyRecord
Relations
- source table Table 37 “Sales Line”
Calls
From the extracted call graph of BC29 (graphify-al on the snapshot checkout): calls whose target is known from a declared type or an Object::"Name" argument. Interface dispatch and calls through events are not counted, so the list is not complete.
- Codeunit 378 “Transfer Extended Text” (2 calls:
InsertExtendedText → InsertSalesExtText,InsertExtendedText → SalesCheckIfAnyExtText)
Ask your agent
Procedure bodies are not stored here (D10). The call sections above are our own, per object, from the BC29 call graph. For a procedure body or the calls of one procedure, ask bc-code-atlas (external, by Stefan Maron, MIT; default corpus w1-28), which the bc-observatory plugin connects: bcatlas_resolve_node(object_type: "page", object_name: "Sales Document Line Entity"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.