Table 5476 "Sales Invoice Line Aggregate"

Base Application · Microsoft.Integration.Entity · BC23-30 · source at ea08af5e · facts from BC29

Learn documents this table through its pages: Page 30043 “APIV2 - Sales Invoice Lines” (5 Learn pages), Page 30044 “APIV2 - Sales Order Lines” (5), Page 30045 “APIV2 - Sales Quote Lines” (5), Page 30046 “APIV2 - Sales Credit Mem Lines” (5).

Properties

Property	Value
Caption	Sales Invoice Line Aggregate
TableType	Temporary
DataClassification	CustomerContent

Fields

Explanation: the field’s ToolTip in the code; without one, the ToolTip of a page control bound to the field (marked via the page); without that, its Caption (marked caption) when that differs from the name.

No.	Name	Type	Explanation	Notes
4	Line No.	Integer	Specifies the sales invoice lines sequence. via Page 20043 “APIV1 - Sales Invoice Lines”
5	Type	Enum “Sales Line Type”	—	enum Enum 37 “Sales Line Type”
6	No.	Code[20]	—
7	Location Code	Code[10]	—	TableRelation Table 14 “Location” (Location where(“Use As In-Transit” = const(false)))
10	Shipment Date	Date	Specifies the shipment date. via Page 20043 “APIV1 - Sales Invoice Lines”
11	Description	Text[100]	Specifies the description of the sales invoice line. via Page 20043 “APIV1 - Sales Invoice Lines”
12	Description 2	Text[50]	—
15	Quantity Δ BC28	Decimal	Specifies the quantity. via Page 20043 “APIV1 - Sales Invoice Lines”
17	Qty. to Invoice Δ BC28	Decimal	Specifies the quantity to invoice. via Page 20044 “APIV1 - Sales Order Lines”
18	Qty. to Ship Δ BC28	Decimal	Specifies the quantity to ship. via Page 20044 “APIV1 - Sales Order Lines”
22	Unit Price	Decimal	Specifies the unit price. via Page 20043 “APIV1 - Sales Invoice Lines”
25	VAT % Δ BC28	Decimal	Specifies the tax percent. via Page 20043 “APIV1 - Sales Invoice Lines”
27	Line Discount % Δ BC28	Decimal	Specifies the line discount percent. via Page 20043 “APIV1 - Sales Invoice Lines”
28	Line Discount Amount	Decimal	Specifies the line discount amount. via Page 20043 “APIV1 - Sales Invoice Lines”
29	Amount	Decimal	Specifies the net amount. via Page 20043 “APIV1 - Sales Invoice Lines”
30	Amount Including VAT	Decimal	Specifies the net amount including tax. via Page 20043 “APIV1 - Sales Invoice Lines”
60	Quantity Shipped Δ BC28	Decimal	Specifies the shipped quantity. via Page 20044 “APIV1 - Sales Order Lines”	not editable
61	Quantity Invoiced Δ BC28	Decimal	Specifies the invoiced quantity. via Page 20044 “APIV1 - Sales Order Lines”	not editable
69	Inv. Discount Amount	Decimal	—	not editable
87	Tax Group Code	Code[20]	—	TableRelation Table 321 “Tax Group” (Tax Group)
90	VAT Prod. Posting Group	Code[20]	—	TableRelation Table 324 “VAT Product Posting Group” (VAT Product Posting Group)
91	Currency Code	Code[10]	—	TableRelation Table 4 “Currency”
99	VAT Base Amount	Decimal	—
103	Line Amount	Decimal	—
180	Line Discount Calculation	Option	—	OptionCaption: None,%,Amount
5402	Variant Code	Code[10]	—	TableRelation Table 5401 “Item Variant” (if (Type = const(Item)) “Item Variant”.Code where(“Item No.” = field(“No.”)))
5407	Unit of Measure Code	Code[10]	—	TableRelation Table 204 “Unit of Measure”, Table 205 “Resource Unit of Measure”, Table 5404 “Item Unit of Measure” (if (Type = const(Item), “No.” = filter(<> ‘’)) “Item Unit of Measure”.Code where(“Item No.” = field(“No.”)) else if (Type = const(Resource), “No.” = filter(<> ‘’)) “Resource Unit of Measure”.Code where(“Resource No.” = field(“No.”)) else “Unit of Measure”)
8000	Document Id	Guid	Specifies the document ID. via Page 20043 “APIV1 - Sales Invoice Lines”
8001	Id	Text[50]	Specifies the ID. via Page 20043 “APIV1 - Sales Invoice Lines”
8002	Variant Id	Guid	Specifies the item variant id. via Page 20043 “APIV1 - Sales Invoice Lines”	TableRelation Table 5401 “Item Variant” (if (Type = const(Item)) “Item Variant”.SystemId where(“Item No.” = field(“No.”)))
9020	Tax Code	Code[50]	Specifies the tax code. via Page 20043 “APIV1 - Sales Invoice Lines”
9021	Tax Amount	Decimal	Specifies the net tax amount. via Page 20043 “APIV1 - Sales Invoice Lines”
9022	Discount Applied Before Tax	Boolean	Specifies the discount applied before tax. via Page 20043 “APIV1 - Sales Invoice Lines”
9029	API Type	Enum “Invoice Line Agg. Line Type”	Specifies the API Type. via Page 20043 “APIV1 - Sales Invoice Lines”	enum Enum 5478 “Invoice Line Agg. Line Type”
9030	Item Id	Guid	Specifies the Item Id. via Page 20043 “APIV1 - Sales Invoice Lines”	TableRelation Item.SystemId
9031	Account Id	Guid	Specifies the Account Id. via Page 20043 “APIV1 - Sales Invoice Lines”	TableRelation Table 15 “G/L Account” (“G/L Account”.SystemId)
9032	Unit of Measure Id	Guid	—	TableRelation Table 204 “Unit of Measure” (“Unit of Measure”.SystemId)
9039	Line Tax Amount	Decimal	Specifies the tax amount. via Page 20043 “APIV1 - Sales Invoice Lines”
9040	Line Amount Including Tax	Decimal	Specifies the line amount including tax. via Page 20043 “APIV1 - Sales Invoice Lines”
9041	Line Amount Excluding Tax	Decimal	Specifies the line amount excluding tax. via Page 20043 “APIV1 - Sales Invoice Lines”
9042	Prices Including Tax	Boolean	—
9043	Inv. Discount Amount Excl. VAT	Decimal	Specifies the invoice discount amount excluding tax. via Page 20043 “APIV1 - Sales Invoice Lines”
9044	Tax Id	Guid	—
9050	Line Discount Value Δ BC28	Decimal	—
9070	Location Id	Guid	—	TableRelation Location.SystemId

Keys

Key1: Document Id, Line No. (clustered)
Key2: Id

Procedures

UpdateItemId()
UpdateAccountId()
UpdateNo()
UpdateReferencedRecordIds()
UpdateLineDiscounts()
SetDiscountValue()

Plus 6 local procedures.

Triggers

OnInsert, OnModify, OnRename

Relations

Location Code: TableRelation Table 14 “Location”
Account Id: TableRelation Table 15 “G/L Account”
Unit of Measure Code: TableRelation Table 204 “Unit of Measure” (conditional)
Unit of Measure Id: TableRelation Table 204 “Unit of Measure”
Unit of Measure Code: TableRelation Table 205 “Resource Unit of Measure” (conditional)
Tax Group Code: TableRelation Table 321 “Tax Group”
VAT Prod. Posting Group: TableRelation Table 324 “VAT Product Posting Group”
Currency Code: TableRelation Table 4 “Currency”
Variant Code: TableRelation Table 5401 “Item Variant”
Variant Id: TableRelation Table 5401 “Item Variant”
Unit of Measure Code: TableRelation Table 5404 “Item Unit of Measure” (conditional)

Pages and codeunits on this table

Page 20043 “APIV1 - Sales Invoice Lines” (source table)
Page 20044 “APIV1 - Sales Order Lines” (source table)
Page 20045 “APIV1 - Sales Quote Lines” (source table)
Page 20046 “APIV1 - Sales Credit Mem Lines” (source table)
Page 30043 “APIV2 - Sales Invoice Lines” (source table)
Page 30044 “APIV2 - Sales Order Lines” (source table)
Page 30045 “APIV2 - Sales Quote Lines” (source table)
Page 30046 “APIV2 - Sales Credit Mem Lines” (source table)

Ask your agent

Procedure bodies are not stored here (D10). 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: "table", object_name: "Sales Invoice Line Aggregate"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.