Table 263 "Intrastat Jnl. Line"

Base Application · Microsoft.Inventory.Intrastat · BC23-30 · source at ea08af5e · facts from BC29

Properties

Property	Value
Caption	Intrastat Jnl. Line
DataClassification	CustomerContent
ObsoleteState	Removed
ObsoleteTag	25.0
ObsoleteReason	Intrastat related functionalities are moved to Intrastat extensions.

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	Journal Template Name Δ BC25	Code[10]	—
2	Journal Batch Name Δ BC25	Code[10]	—
3	Line No.	Integer	—
4	Type	Option	—	OptionCaption: Receipt,Shipment
5	Date	Date	—
6	Tariff No. Δ BC25	Code[20]	—	NotBlank
7	Item Description	Text[100]	—
8	Country/Region Code	Code[10]	—	TableRelation Table 9 “Country/Region” (Country/Region)
9	Transaction Type	Code[10]	—	TableRelation Table 258 “Transaction Type” (Transaction Type)
10	Transport Method	Code[10]	—	TableRelation Table 259 “Transport Method” (Transport Method)
11	Source Type Δ BC26 Δ BC29	Enum “Intrastat Source Type”	—	obsolete Removed 29.0; #if not CLEANSCHEMA29; enum Enum 264 “Intrastat Source Type”
12	Source Entry No. Δ BC29	Integer	—	not editable
13	Net Weight Δ BC28	Decimal	—
14	Amount Δ BC28	Decimal	—
15	Quantity Δ BC28	Decimal	—
16	Cost Regulation % Δ BC28	Decimal	—
17	Indirect Cost Δ BC28	Decimal	—
18	Statistical Value Δ BC28	Decimal	—
19	Document No.	Code[20]	—
20	Item No. Δ BC25	Code[20]	—
21	Name	Text[100]	—
22	Total Weight Δ BC28	Decimal	—	not editable
23	Supplementary Units	Boolean	—	not editable
24	Internal Ref. No.	Text[10]	—	not editable
25	Country/Region of Origin Code	Code[10]	—	TableRelation Table 9 “Country/Region” (Country/Region)
26	Entry/Exit Point	Code[10]	—	TableRelation Table 282 “Entry/Exit Point” (Entry/Exit Point)
27	Area	Code[10]	—	TableRelation Table 284 “Area”
28	Transaction Specification	Code[10]	—	TableRelation Table 285 “Transaction Specification” (Transaction Specification)
29	Shpt. Method Code	Code[10]	—	TableRelation Table 10 “Shipment Method” (Shipment Method)
30	Partner VAT ID	Text[50]	—
31	Location Code	Code[10]	—	TableRelation Table 14 “Location”
32	Counterparty	Boolean	—

Keys

Key1: Journal Template Name, Journal Batch Name, Line No. (clustered)
Key5: Document No.
Key6: Journal Template Name, Journal Batch Name, Type, Internal Ref. No.
Key7: Journal Template Name, Journal Batch Name, Type, Country/Region Code, Tariff No., Transaction Type, Transport Method, Country/Region of Origin Code, Partner VAT ID

Relations

Shpt. Method Code: TableRelation Table 10 “Shipment Method”
Location Code: TableRelation Table 14 “Location”
Transaction Type: TableRelation Table 258 “Transaction Type”
Transport Method: TableRelation Table 259 “Transport Method”
Entry/Exit Point: TableRelation Table 282 “Entry/Exit Point”
Area: TableRelation Table 284 “Area”
Transaction Specification: TableRelation Table 285 “Transaction Specification”
Country/Region Code: TableRelation Table 9 “Country/Region”
Country/Region of Origin Code: TableRelation Table 9 “Country/Region”

Countries that replace it

AT, BE, CH, CZ, DE, ES, FI, FR, GB, IT, NL

Deprecations

object: Removed 25.0 (#if not CLEANSCHEMA25), “Intrastat related functionalities are moved to Intrastat extensions.”
field Source Type: Removed 29.0 (#if not CLEANSCHEMA29), “Intrastat related functionalities are moved to Intrastat extensions.”

Source: AL metadata extracted from the code (names, ids, signatures, properties); no code bodies (D10).

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: "Intrastat Jnl. Line"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.