Table 4812 "Intrastat Report Line"
Intrastat · Microsoft.Inventory.Intrastat
Across versions
- BC23-28not present
- BC29present
- BC30changed
Neighbourhood 21 connected objects and pages
Intrastat · Microsoft.Inventory.Intrastat · BC29-30 · source at ea08af5e · facts from BC29
Properties
| Property | Value |
|---|---|
| Caption | Intrastat Report Line |
| 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 |
|---|---|---|---|---|
| 1 | Intrastat No. | Code[20] | — | TableRelation Table 4811 “Intrastat Report Header” (Intrastat Report Header); not editable; NotBlank |
| 2 | Line No. | Integer | — | |
| 3 | Type | Enum “Intrastat Report Line Type” | Specifies whether the item was received or shipped by the company. | enum Enum 4811 “Intrastat Report Line Type” |
| 4 | Date | Date | Specifies the date the item entry was posted. | |
| 5 | Tariff No. | Code[20] | Specifies the item’s tariff number. | TableRelation Table 260 “Tariff Number” (Tariff Number); NotBlank |
| 6 | Tariff Description | Text[250] | Specifies the name of the tariff no. that is associated with the item. | |
| 7 | Country/Region Code | Code[10] | Specifies the country/region of the address. | TableRelation Table 9 “Country/Region” (Country/Region) |
| 8 | Transaction Type | Code[10] | Specifies the type of transaction that the document represents, for the purpose of reporting to Intrastat. | TableRelation Table 258 “Transaction Type” (Transaction Type) |
| 9 | Transport Method | Code[10] | Specifies the transport method, for the purpose of reporting to Intrastat. | TableRelation Table 259 “Transport Method” (Transport Method) |
| 10 | Source Type | Enum “Intrastat Report Source Type” | Specifies the entry type. | enum Enum 4810 “Intrastat Report Source Type” |
| 11 | Source Entry No. | Integer | Specifies the number that the item entry had in the table it came from. | TableRelation Table 169 “Job Ledger Entry”, Table 32 “Item Ledger Entry”, Table 5601 “FA Ledger Entry” (if (“Source Type” = const(“Item Entry”)) “Item Ledger Entry” else if (“Source Type” = const(“Job Entry”)) “Job Ledger Entry” else if (“Source Type” = const(“FA Entry”)) “FA Ledger Entry”) |
| 12 | Net Weight | Decimal | Specifies the net weight of one unit of the item. | |
| 13 | Amount | Decimal | Specifies the total amount of the entry, excluding VAT. | |
| 14 | Quantity | Decimal | Specifies the number of units of the item in the entry. | |
| 15 | Cost Regulation % | Decimal | Specifies any indirect costs, as a percentage. | |
| 16 | Indirect Cost | Decimal | Specifies an amount that represents the costs for freight and insurance. | |
| 17 | Statistical Value | Decimal | Specifies the entry’s statistical value, which must be reported to the statistics authorities. | |
| 18 | Document No. | Code[20] | Specifies the document number on the entry. | |
| 19 | Item No. | Code[20] | Specifies the number of the item. | TableRelation Table 27 “Item”, Table 5600 “Fixed Asset” (if (“Source Type” = const(“Item Entry”)) Item else if (“Source Type” = const(“Job Entry”)) Item else if (“Source Type” = const(“FA Entry”)) “Fixed Asset”) |
| 20 | Item Name | Text[100] | Specifies the name of the item. | |
| 21 | Total Weight | Decimal | Specifies the total weight for the items in the item entry. | not editable |
| 22 | Supplementary Units | Boolean | Specifies if you must report information about quantity and units of measure for this item. | not editable |
| 23 | Internal Ref. No. | Text[10] | Specifies a reference number used by the customs and tax authorities. | not editable |
| 24 | Country/Region of Origin Code | Code[10] | Specifies a code for the country/region where the item was produced or processed. | TableRelation Table 9 “Country/Region” (Country/Region) |
| 25 | Entry/Exit Point | Code[10] | Specifies the code of either the port of entry where the items passed into your country/region or the port of exit. | TableRelation Table 282 “Entry/Exit Point” (Entry/Exit Point) |
| 26 | Area | Code[10] | Specifies the area of the customer or vendor, for the purpose of reporting to Intrastat. | TableRelation Table 284 “Area” |
| 27 | Transaction Specification | Code[10] | Specifies a specification of the document’s transaction, for the purpose of reporting to Intrastat. | TableRelation Table 285 “Transaction Specification” (Transaction Specification) |
| 28 | Shpt. Method Code | Code[10] | Specifies the item’s shipment method. | TableRelation Table 10 “Shipment Method” (Shipment Method) |
| 29 | Partner VAT ID | Text[50] | Specifies the counter party’s VAT number. | |
| 30 | Location Code | Code[10] | Specifies the code for the location that the entry is linked to. | TableRelation Table 14 “Location” |
| 31 | Counterparty | Boolean | — | |
| 32 | Correction | Boolean | — | |
| 33 | Suppl. Conversion Factor | Decimal | Specifies the conversion factor of the item on this Intrastat report line. | not editable |
| 34 | Suppl. Unit of Measure | Text[10] | Specifies the unit of measure code for the tariff number on this line. | TableRelation Table 5404 “Item Unit of Measure” (“Item Unit of Measure”.Code where(“Item No.” = field(“Item No.”))) |
| 35 | Supplementary Quantity | Decimal | Specifies the quantity of supplementary units on the Intrastat line. | not editable |
| 36 | Statistical System | Enum “Intrastat Report Stat. System” | — | enum Enum 4815 “Intrastat Report Stat. System” |
| 37 | Currency Code | Code[10] | — | TableRelation Table 4 “Currency” |
| 38 | Source Currency Amount | Decimal | — | |
| 39 | Corrective entry | Boolean | — | |
| 40 | Group Code | Code[10] | — | not editable |
| 41 | Statistics Period | Code[10] | — | |
| 42 | Reference Period | Code[10] | — | |
| 43 | Payment Method | Code[10] | — | TableRelation Table 289 “Payment Method” (Payment Method) |
| 44 | Corrected Intrastat Report No. | Code[20] | — | |
| 45 | Country/Region of Payment Code | Code[10] | — | TableRelation Table 9 “Country/Region” (Country/Region) |
| 46 | Progressive No. | Code[5] | — | |
| 47 | Obligation Level | Code[20] | — | |
| 48 | Corrected Document No. | Code[20] | — | |
| 100 | Record ID Filter | Text[250] | — | not editable |
| 101 | Intrastat Country/Region Code | Code[10] | — |
Keys
- Key1: Intrastat No., Line No. (clustered)
- Key2: Source Type, Source Entry No.
- Key3: Document No.
- Key4: Intrastat No., Type, Internal Ref. No.
- Key5: Intrastat No., Type, Country/Region Code, Tariff No., Transaction Type, Transport Method, Country/Region of Origin Code, Partner VAT ID
- Key6: Intrastat No., Type, Country/Region Code, Tariff No., Transaction Type, Transport Method, Area, Transaction Specification, Country/Region of Origin Code, Partner VAT ID
- Key7: Intrastat No., Type, Country/Region Code, Tariff No., Transaction Type, Transport Method, Transaction Specification, Area, Country/Region of Origin Code, Partner VAT ID
- Key8: Type, Country/Region Code, Partner VAT ID, Transaction Type, Tariff No., Group Code, Transport Method, Transaction Specification, Country/Region of Origin Code, Area, Corrective entry
- Key9: Intrastat No., Type
- Key10: Partner VAT ID, Transaction Type, Tariff No., Group Code, Transport Method, Transaction Specification, Country/Region of Origin Code, Area, Corrective entry
Events published
OnBeforeGetCountryOfOriginCode(var IntrastatReportLine: Record "Intrastat Report Line"; var CountryOfOriginCode: Code[10]; var IsHandled: Boolean)(integration)OnAfterGetCountryOfOriginCode(var IntrastatReportLine: Record "Intrastat Report Line"; var CountryOfOriginCode: Code[10])(integration)OnBeforeGetItemDescription(var IsHandled: Boolean; var IntrastatReportLine: Record "Intrastat Report Line")(integration)OnBeforeGetPartnerID(var IntrastatReportLine: Record "Intrastat Report Line"; var PartnerID: Text[50]; var IsHandled: Boolean)(integration)OnBeforeGetPartnerIDFromItemEntry(var IntrastatReportLine: Record "Intrastat Report Line"; var PartnerID: Text[50]; var IsHandled: Boolean)(integration)OnBeforeGetCustomerPartnerIDFromItemEntry(var Customer: Record Customer; EU3rdPartyTrade: Boolean; var PartnerID: Text[50]; var IsHandled: Boolean)(integration)OnBeforeGetVendorPartnerIDFromItemEntry(var Vendor: Record Vendor; var PartnerID: Text[50]; var IsHandled: Boolean)(integration)OnBeforeGetPartnerIDFromJobEntry(var IntrastatReportLine: Record "Intrastat Report Line"; var PartnerID: Text[50]; var IsHandled: Boolean)(integration)OnBeforeGetCustomerPartnerIDFromJobEntry(var Customer: Record Customer; var PartnerID: Text[50]; var IsHandled: Boolean)(integration)OnBeforeGetPartnerIDFromFAEntry(var IntrastatReportLine: Record "Intrastat Report Line"; var PartnerID: Text[50]; var IsHandled: Boolean)(integration)OnBeforeGetVendorPartnerIDFromFAEntry(var Vendor: Record Vendor; var PartnerID: Text[50]; var IsHandled: Boolean)(integration)OnBeforeGetCustomerPartnerIDFromFAEntry(var Customer: Record Customer; var PartnerID: Text[50]; var IsHandled: Boolean)(integration)OnBeforeGetPartnerIDForCountry(CountryRegionCode: Code[10]; VATRegistrationNo: Text[50]; IsPrivatePerson: Boolean; IsThirdPartyTrade: Boolean; var PartnerID: Text[50]; var IsHandled: Boolean)(integration)OnBeforeCheckDateInRange(var IntrastatReportLine: Record "Intrastat Report Line"; var IsHandled: Boolean)(integration)OnAfterSetIntrastatReportHeaderFilters(var IntrastatReportHeaderWithFiltersSet: Record "Intrastat Report Header"; IntrastatReportHeaderForLine: Record "Intrastat Report Header")(integration)
Procedures
CheckHeaderStatusOpen()GetCountryOfOriginCode(): Code[10]GetPartnerID(): Text[50]SetIntrastatReportHeaderFilters(var IntrastatReportHeaderWithFiltersSet: Record "Intrastat Report Header")
Plus 7 local procedures.
Triggers
OnDelete, OnInsert, OnModify, OnRename
Relations
- Shpt. Method Code: TableRelation Table 10 “Shipment Method”
- Location Code: TableRelation Table 14 “Location”
- Source Entry No.: TableRelation Table 169 “Job Ledger Entry” (conditional)
- Transaction Type: TableRelation Table 258 “Transaction Type”
- Transport Method: TableRelation Table 259 “Transport Method”
- Tariff No.: TableRelation Table 260 “Tariff Number”
- Item No.: TableRelation Table 27 “Item” (conditional)
- Entry/Exit Point: TableRelation Table 282 “Entry/Exit Point”
- Area: TableRelation Table 284 “Area”
- Transaction Specification: TableRelation Table 285 “Transaction Specification”
- Payment Method: TableRelation Table 289 “Payment Method”
- Source Entry No.: TableRelation Table 32 “Item Ledger Entry” (conditional)
- Currency Code: TableRelation Table 4 “Currency”
- Intrastat No.: TableRelation Table 4811 “Intrastat Report Header”
- Suppl. Unit of Measure: TableRelation Table 5404 “Item Unit of Measure”
- Item No.: TableRelation Table 5600 “Fixed Asset” (conditional)
- Source Entry No.: TableRelation Table 5601 “FA Ledger Entry” (conditional)
- Country/Region Code: TableRelation Table 9 “Country/Region”
- Country/Region of Origin Code: TableRelation Table 9 “Country/Region”
- Country/Region of Payment Code: TableRelation Table 9 “Country/Region”
Pages and codeunits on this table
- Page 4813 “Intrastat Report Subform” (source table)
- Page 4816 “Intrastat Report Lines” (source table)
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 4810 “IntrastatReportManagement” (9 calls:
GetPartnerIDFromFAEntry → GetVATRegNo,GetPartnerIDFromFAEntry → IsCustomerPrivatePerson,GetPartnerIDFromFAEntry → IsVendorPrivatePerson, …)
Recent changes
- 2026-09-02 #10876 [29.x]When Intrastat line is added manually the “Intrastat Country/Region Code” is not automatically populated after adding the “Country/Region Code” (releases/29.x, BC29, fix)
- 2026-08-27 #10558 [Master]-When Intrastat line is added manually the “Intrastat Country/Region Code” is not automatically populated after adding the “Country/Region Code” (main, BC30, fix)
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: "table", object_name: "Intrastat Report Line"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.