Intrastat Report Line #4812

Other table in Microsoft Dynamics 365 Business Central. 55 fields, 0 records in Cronus demo.

55
Fields
0
Records
2
Primary key
0
FlowFields
17
Relations
Open in Data Explorer →

Primary key

The primary key uniquely identifies each record in this table. It consists of: Intrastat No., Line No..

All fields (55)

Intrastat Report Line — FIELDS
NO.FIELDTYPECLASSRELATION
1 Intrastat No. PK Code Normal → Intrastat Report Header #4811
2 Line No. PK Integer Normal
3 Type Option Normal
4 Date Date Normal
5 Tariff No. Code Normal → Tariff Number #260
6 Tariff No. Description Text Normal
7 Country/Region Code Code Normal → Country/Region #9
8 Transaction Type Code Normal → Transaction Type #258
9 Transport Method Code Normal → Transport Method #259
10 Source Type Option Normal
11 Source Entry No. Integer Normal
12 Net Weight Decimal Normal
13 Amount Decimal Normal
14 Quantity Decimal Normal
15 Cost Regulation % Decimal Normal
16 Indirect Cost Decimal Normal
17 Statistical Value Decimal Normal
18 Document No. Code Normal
19 Item No. Code Normal
20 Item Name Text Normal
21 Total Weight Decimal Normal
22 Supplementary Units Boolean Normal
23 Internal Ref. No. Text Normal
24 Country/Region of Origin Code Code Normal → Country/Region #9
25 Entry/Exit Point Code Normal → Entry/Exit Point #282
26 Area Code Normal → Area #284
27 Transaction Specification Code Normal → Transaction Specification #285
28 Shpt. Method Code Code Normal → Shipment Method #10
29 Tax Reg. No. Text Normal
30 Location Code Code Normal → Location #14
31 Counterparty Boolean Normal
32 Correction Boolean Normal
33 Supplementary Unit Conversion Factor Decimal Normal
34 Supplementary Unit of Measure Text Normal → Item Unit of Measure #5404
35 Supplementary Quantity Decimal Normal
36 Statistical System Option Normal
37 Currency Code Code Normal → Currency #4
38 Source Currency Amount Decimal Normal
39 Corrective entry Boolean Normal
40 Group Code Code Normal
41 Statistics Period Code Normal
42 Reference Period Code Normal
43 Payment Method Code Normal → Payment Method #289
44 Corrected Intrastat Report No. Code Normal
45 Country/Region of Payment Code Code Normal → Country/Region #9
46 Progressive No. Code Normal
47 Obligation Level Code Normal
48 Corrected Document No. Code Normal
100 Record ID Filter Text Normal
101 Intrastat Country/Region Code Code Normal
2000000000 System ID GUID Normal
2000000001 Created At DateTime Normal
2000000002 Created By GUID Normal
2000000003 Modified At DateTime Normal
2000000004 Modified By GUID Normal

Related tables (14)

Tables referenced by fields on the Intrastat Report Line table through TableRelation properties.

Intrastat Report Header
#4811 · Other · via Intrastat No.
Tariff Number
#260 · Other · via Tariff No.
Country/Region
#9 · General Ledger · via Country/Region Code, Country/Region of Origin Code, Country/Region of Payment Code
Transaction Type
#258 · Other · via Transaction Type
Transport Method
#259 · Other · via Transport Method
Entry/Exit Point
#282 · Other · via Entry/Exit Point
Area
#284 · Other · via Area
Transaction Specification
#285 · Other · via Transaction Specification
Shipment Method
#10 · General Ledger · via Shpt. Method Code
Location
#14 · General Ledger · via Location Code
Item Unit of Measure
#5404 · Other · via Supplementary Unit of Measure
Currency
#4 · General Ledger · via Currency Code
Payment Method
#289 · Other · via Payment Method