Table 5478 "Purch. Inv. Line Aggregate"

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

Learn documents this table through its pages: Page 30047 “APIV2 - Purchase Invoice Lines” (5 Learn pages), Page 30067 “APIV2 - Purchase Order Lines” (5), Page 30084 “APIV2 - Purch. Cr. Memo Lines” (5).

Properties

Property	Value
Caption	Purch. Inv. 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 purchase invoice lines sequence. via Page 20047 “APIV1 - Purchase Invoice Lines”
5	Type	Enum “Purchase Line Type”	—	enum Enum 39 “Purchase Line Type”
6	No.	Code[20]	—
7	Location Code	Code[10]	—	TableRelation Table 14 “Location” (Location where(“Use As In-Transit” = const(false)))
10	Expected Receipt Date	Date	Specifies the expected receipt date. via Page 20047 “APIV1 - Purchase Invoice Lines”
11	Description	Text[100]	Specifies the description of the purchase invoice line. via Page 20047 “APIV1 - Purchase Invoice Lines”
12	Description 2	Text[50]	—
15	Quantity Δ BC28	Decimal	Specifies the quantity. via Page 20047 “APIV1 - Purchase Invoice Lines”
17	Qty. to Invoice Δ BC28	Decimal	—
18	Qty. to Receive Δ BC28	Decimal	—
22	Direct Unit Cost	Decimal	Specifies the direct unit cost. via Page 20047 “APIV1 - Purchase Invoice Lines”
25	VAT % Δ BC28	Decimal	Specifies the tax percent. via Page 20047 “APIV1 - Purchase Invoice Lines”
27	Line Discount % Δ BC28	Decimal	Specifies the line discount percent. via Page 20047 “APIV1 - Purchase Invoice Lines”
28	Line Discount Amount	Decimal	Specifies the line discount amount. via Page 20047 “APIV1 - Purchase Invoice Lines”
29	Amount	Decimal	Specifies the net amount. via Page 20047 “APIV1 - Purchase Invoice Lines”
30	Amount Including VAT	Decimal	Specifies the net amount including tax. via Page 20047 “APIV1 - Purchase Invoice Lines”
60	Quantity Received Δ BC28	Decimal	—	not editable
61	Quantity Invoiced Δ BC28	Decimal	—	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	—
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 5404 “Item Unit of Measure” (if (Type = const(Item), “No.” = filter(<> ‘’)) “Item Unit of Measure”.Code where(“Item No.” = field(“No.”)) else “Unit of Measure”)
8000	Document Id	Guid	Specifies the Document ID. via Page 20047 “APIV1 - Purchase Invoice Lines”
8001	Id	Text[50]	Specifies the ID. via Page 20047 “APIV1 - Purchase Invoice Lines”
8002	Variant Id	Guid	Specifies the item variant id. via Page 20047 “APIV1 - Purchase 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 20047 “APIV1 - Purchase Invoice Lines”
9021	Tax Amount	Decimal	Specifies the net tax amount. via Page 20047 “APIV1 - Purchase Invoice Lines”
9022	Discount Applied Before Tax	Boolean	Specifies the discount applied before tax. via Page 20047 “APIV1 - Purchase Invoice Lines”
9029	API Type	Enum “Invoice Line Agg. Line Type”	Specifies the API Type. via Page 20047 “APIV1 - Purchase Invoice Lines”	enum Enum 5478 “Invoice Line Agg. Line Type”
9030	Item Id	Guid	Specifies the Item Id. via Page 20047 “APIV1 - Purchase Invoice Lines”	TableRelation Item.SystemId
9031	Account Id	Guid	Specifies the Account Id. via Page 20047 “APIV1 - Purchase 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 20047 “APIV1 - Purchase Invoice Lines”
9040	Line Amount Including Tax	Decimal	Specifies the line amount including tax. via Page 20047 “APIV1 - Purchase Invoice Lines”
9041	Line Amount Excluding Tax	Decimal	Specifies the line amount excluding tax. via Page 20047 “APIV1 - Purchase Invoice Lines”
9042	Prices Including Tax	Boolean	—
9043	Inv. Discount Amount Excl. VAT	Decimal	Specifies the invoice discount amount excluding tax. via Page 20047 “APIV1 - Purchase Invoice Lines”
9044	Tax Id	Guid	—
9070	Location Id	Guid	—	TableRelation Location.SystemId

Keys

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

Procedures

UpdateItemId()
UpdateAccountId()
UpdateNo()
UpdateReferencedRecordIds()

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”
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 20047 “APIV1 - Purchase Invoice Lines” (source table)
Page 30047 “APIV2 - Purchase Invoice Lines” (source table)
Page 30067 “APIV2 - Purchase Order Lines” (source table)
Page 30084 “APIV2 - Purch. Cr. Memo 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: "Purch. Inv. Line Aggregate"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.