Table 5475 "Sales Invoice Entity Aggregate"

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

Learn documents this table through its pages: Page 30012 “APIV2 - Sales Invoices” (6 Learn pages), Page 20012 “APIV1 - Sales Invoices” (5).

Properties

Property	Value
Caption	Sales Invoice Entity Aggregate
DataClassification	CustomerContent
Permissions	tabledata “VAT Posting Setup” = R

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
1	Document Type	Enum “Sales Document Type”	—	enum Enum 36 “Sales Document Type”
2	Sell-to Customer No.	Code[20]	—	TableRelation Table 18 “Customer”; NotBlank
3	No.	Code[20]	—
4	Bill-to Customer No.	Code[20]	—	TableRelation Table 18 “Customer”; NotBlank
5	Bill-to Name	Text[100]	—	TableRelation Customer.Name
7	Bill-to Address	Text[100]	—
8	Bill-to Address 2	Text[50]	—
9	Bill-to City	Text[30]	—	TableRelation Table 225 “Post Code” (if (“Bill-to Country/Region Code” = const(‘’)) “Post Code”.City else if (“Bill-to Country/Region Code” = filter(<> ‘’)) “Post Code”.City where(“Country/Region Code” = field(“Bill-to Country/Region Code”)))
10	Bill-to Contact	Text[100]	—
11	Your Reference	Text[35]	—
12	Ship-to Code	Code[10]	—
13	Ship-to Name	Text[100]	—
15	Ship-to Address	Text[100]	—
16	Ship-to Address 2	Text[50]	—
17	Ship-to City	Text[30]	—	TableRelation Table 225 “Post Code” (if (“Ship-to Country/Region Code” = const(‘’)) “Post Code”.City else if (“Ship-to Country/Region Code” = filter(<> ‘’)) “Post Code”.City where(“Country/Region Code” = field(“Ship-to Country/Region Code”)))
18	Ship-to Contact	Text[100]	—
20	Posting Date	Date	—
23	Payment Terms Code	Code[10]	—	TableRelation Table 3 “Payment Terms” (Payment Terms)
24	Due Date	Date	—
27	Shipment Method Code	Code[10]	—	TableRelation Table 10 “Shipment Method” (Shipment Method)
29	Shortcut Dimension 1 Code	Code[20]	—	TableRelation Table 349 “Dimension Value” (“Dimension Value”.Code where(“Global Dimension No.” = const(1)))
30	Shortcut Dimension 2 Code	Code[20]	—	TableRelation Table 349 “Dimension Value” (“Dimension Value”.Code where(“Global Dimension No.” = const(2)))
31	Customer Posting Group	Code[20]	—	TableRelation Table 92 “Customer Posting Group” (Customer Posting Group)
32	Currency Code	Code[10]	—	TableRelation Table 4 “Currency”
35	Prices Including VAT	Boolean	—
43	Salesperson Code	Code[20]	—	TableRelation Table 13 “Salesperson/Purchaser” (Salesperson/Purchaser)
44	Order No.	Code[20]	—
56	Recalculate Invoice Disc.	Boolean	—	FlowField: exist(“Sales Line” where(“Document Type” = const(Invoice), “Document No.” = field(“No.”), “Recalculate Invoice Disc.” = const(true))); not editable
60	Amount	Decimal	—
61	Amount Including VAT	Decimal	—
70	VAT Registration No.	Text[20]	—
79	Sell-to Customer Name	Text[100]	—	TableRelation Customer.Name
81	Sell-to Address	Text[100]	—
82	Sell-to Address 2	Text[50]	—
83	Sell-to City	Text[30]	—	TableRelation Table 225 “Post Code” (if (“Sell-to Country/Region Code” = const(‘’)) “Post Code”.City else if (“Sell-to Country/Region Code” = filter(<> ‘’)) “Post Code”.City where(“Country/Region Code” = field(“Sell-to Country/Region Code”)))
84	Sell-to Contact	Text[100]	—
85	Bill-to Post Code	Code[20]	—	TableRelation Table 225 “Post Code” (Post Code)
86	Bill-to County	Text[30]	—
87	Bill-to Country/Region Code	Code[10]	—	TableRelation Table 9 “Country/Region” (Country/Region)
88	Sell-to Post Code	Code[20]	—	TableRelation Table 225 “Post Code” (if (“Sell-to Country/Region Code” = const(‘’)) “Post Code” else if (“Sell-to Country/Region Code” = filter(<> ‘’)) “Post Code” where(“Country/Region Code” = field(“Sell-to Country/Region Code”)))
89	Sell-to County	Text[30]	—
90	Sell-to Country/Region Code	Code[10]	—	TableRelation Table 9 “Country/Region” (Country/Region)
91	Ship-to Post Code	Code[20]	—	TableRelation Table 225 “Post Code” (if (“Ship-to Country/Region Code” = const(‘’)) “Post Code” else if (“Ship-to Country/Region Code” = filter(<> ‘’)) “Post Code” where(“Country/Region Code” = field(“Ship-to Country/Region Code”)))
92	Ship-to County	Text[30]	—
93	Ship-to Country/Region Code	Code[10]	—	TableRelation Table 9 “Country/Region” (Country/Region)
99	Document Date	Date	—
100	External Document No.	Code[35]	—
114	Tax Area Code	Code[20]	—	TableRelation Table 318 “Tax Area” (Tax Area)
115	Tax Liable	Boolean	—
116	VAT Bus. Posting Group	Code[20]	—	TableRelation Table 323 “VAT Business Posting Group” (VAT Business Posting Group)
121	Invoice Discount Calculation	Option	—	OptionCaption: None,%,Amount
122	Invoice Discount Value Δ BC28	Decimal	—
170	IsTest	Boolean	—
171	Sell-to Phone No.	Text[30]	—
172	Sell-to E-Mail	Text[80]	Email caption
210	Ship-to Phone No. + BC25	Text[30]	—
1304	Cust. Ledger Entry No.	Integer	—	TableRelation Table 21 “Cust. Ledger Entry” (“Cust. Ledger Entry”.“Entry No.”)
1305	Invoice Discount Amount	Decimal	—
1340	Dispute Status + BC24	Code[10]	—	TableRelation Table 142 “Dispute Status” (Dispute Status)
1341	Promised Pay Date + BC24	Date	—
5052	Sell-to Contact No.	Code[20]	—	TableRelation Table 5050 “Contact”
8000	Id	Guid	—	DataClassification SystemMetadata
8010	Dispute Status Id + BC24	Guid	—	TableRelation Table 142 “Dispute Status” (“Dispute Status”.SystemId)
9600	Total Tax Amount	Decimal	Specifies the total tax amount for the sales invoice. via Page 20012 “APIV1 - Sales Invoices”
9601	Status	Enum “Invoice Entity Aggregate Status”	Specifies the status of the Sales Invoice (cancelled, paid, on hold, created). via Page 20012 “APIV1 - Sales Invoices”	enum Enum 5477 “Invoice Entity Aggregate Status”
9602	Posted	Boolean	—
9603	Subtotal Amount	Decimal	—	not editable
9624	Discount Applied Before Tax	Boolean	—
9630	Last Modified Date Time	DateTime	—	not editable; DataClassification SystemMetadata
9631	Customer Id	Guid	—	TableRelation Customer.SystemId; DataClassification SystemMetadata
9632	Order Id	Guid	—	DataClassification SystemMetadata
9633	Contact Graph Id	Text[250]	—	DataClassification SystemMetadata
9634	Currency Id	Guid	—	TableRelation Currency.SystemId; DataClassification SystemMetadata
9635	Payment Terms Id	Guid	—	TableRelation Table 3 “Payment Terms” (“Payment Terms”.SystemId); DataClassification SystemMetadata
9636	Shipment Method Id	Guid	—	TableRelation Table 10 “Shipment Method” (“Shipment Method”.SystemId); DataClassification SystemMetadata
9637	Tax Area ID	Guid	—	DataClassification SystemMetadata
9638	Bill-to Customer Id	Guid	—	TableRelation Customer.SystemId; DataClassification SystemMetadata

Keys

Key1: No., Posted
Key2: Id (clustered)
Key3: Cust. Ledger Entry No.
Key4: Document Date, Status

Procedures

UpdateCurrencyId()
UpdatePaymentTermsId()
UpdateDisputeStatusId() + BC24
UpdateDisputeStatus() + BC24
UpdateShipmentMethodId()
UpdateReferencedRecordIds()
IsUsingVAT(): Boolean
GetIsRenameAllowed(): Boolean
SetIsRenameAllowed(RenameAllowed: Boolean)
GetParentRecordNativeInvoicing(var SalesHeader: Record "Sales Header"; var SalesInvoiceHeader: Record "Sales Invoice Header"): Boolean

Plus 13 local procedures.

Triggers

OnInsert, OnModify, OnRename

Relations

Shipment Method Code: TableRelation Table 10 “Shipment Method”
Shipment Method Id: TableRelation Table 10 “Shipment Method”
Salesperson Code: TableRelation Table 13 “Salesperson/Purchaser”
Dispute Status: TableRelation Table 142 “Dispute Status”
Dispute Status Id: TableRelation Table 142 “Dispute Status”
Bill-to Customer No.: TableRelation Table 18 “Customer”
Sell-to Customer No.: TableRelation Table 18 “Customer”
Cust. Ledger Entry No.: TableRelation Table 21 “Cust. Ledger Entry”
Bill-to City: TableRelation Table 225 “Post Code” (conditional)
Bill-to Post Code: TableRelation Table 225 “Post Code”
Sell-to City: TableRelation Table 225 “Post Code” (conditional)
Sell-to Post Code: TableRelation Table 225 “Post Code” (conditional)
Ship-to City: TableRelation Table 225 “Post Code” (conditional)
Ship-to Post Code: TableRelation Table 225 “Post Code” (conditional)
Payment Terms Code: TableRelation Table 3 “Payment Terms”
Payment Terms Id: TableRelation Table 3 “Payment Terms”
Tax Area Code: TableRelation Table 318 “Tax Area”
VAT Bus. Posting Group: TableRelation Table 323 “VAT Business Posting Group”
Shortcut Dimension 1 Code: TableRelation Table 349 “Dimension Value”
Shortcut Dimension 2 Code: TableRelation Table 349 “Dimension Value”
Recalculate Invoice Disc.: CalcFormula Table 37 “Sales Line”
Currency Code: TableRelation Table 4 “Currency”
Sell-to Contact No.: TableRelation Table 5050 “Contact”
Bill-to Country/Region Code: TableRelation Table 9 “Country/Region”
Sell-to Country/Region Code: TableRelation Table 9 “Country/Region”
Ship-to Country/Region Code: TableRelation Table 9 “Country/Region”
Customer Posting Group: TableRelation Table 92 “Customer Posting Group”

Referenced by

1 fields in 1 objects relate to this table (TableRelation or CalcFormula).

Table 81 “Gen. Journal Line”: Applies-to Invoice Id

Pages and codeunits on this table

Page 20012 “APIV1 - Sales Invoices” (source table)
Page 30012 “APIV2 - Sales Invoices” (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 Entity Aggregate"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.