Table 4810 "Intrastat Report Setup"

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

Learn documents this table through its pages: Page 4810 “Intrastat Report Setup” (2 Learn pages).

Properties

Property	Value
Caption	Intrastat Report Setup
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	Code	Code[10]	—
2	Report Receipts	Boolean	Specifies that you must include arrivals of received goods in Intrastat reports.
3	Report Shipments	Boolean	Specifies that you must include shipments of dispatched items in Intrastat reports.
4	Default Trans. - Purchase	Code[10]	Specifies the default transaction type for regular sales shipments and service shipments, and purchase receipts.	TableRelation Table 258 “Transaction Type” (Transaction Type)
5	Default Trans. - Return	Code[10]	Specifies the default transaction type for sales returns and service returns, and purchase returns.	TableRelation Table 258 “Transaction Type” (Transaction Type)
6	Intrastat Contact Type	Enum “Intrastat Report Contact Type”	Specifies the Intrastat contact type.	enum Enum 4816 “Intrastat Report Contact Type”
7	Intrastat Contact No.	Code[20]	Specifies the Intrastat contact.	TableRelation if (“Intrastat Contact Type” = const(Contact)) Contact.“No.” else if (“Intrastat Contact Type” = const(Vendor)) Vendor.“No.”
9	Cust. VAT No. on File	Enum “Intrastat Report VAT File Fmt”	Specifies how a customer’s VAT registration number exports to the Intrastat file. 0 is the value of the VAT Reg. No. field, 1 adds the EU country code as a prefix, and 2 removes the EU country code.	enum Enum 4819 “Intrastat Report VAT File Fmt”
10	Vend. VAT No. on File	Enum “Intrastat Report VAT File Fmt”	Specifies how a vendor’s VAT registration number exports to the Intrastat file. 0 is the value of the VAT Reg. No. field, 1 adds the EU country code as a prefix, and 2 removes the EU country code.	enum Enum 4819 “Intrastat Report VAT File Fmt”
11	Company VAT No. on File	Enum “Intrastat Report VAT File Fmt”	Specifies how the company’s VAT registration number exports to the Intrastat file. 0 is the value of the VAT Reg. No. field, 1 adds the EU country code as a prefix, and 2 removes the EU country code.	enum Enum 4819 “Intrastat Report VAT File Fmt”
12	Default Trans. Spec. Code	Code[10]	—	TableRelation Table 285 “Transaction Specification” (Transaction Specification)
13	Default Trans. Spec. Ret. Code	Code[10]	Default Trans. Spec. Returns Code caption	TableRelation Table 285 “Transaction Specification” (Transaction Specification)
14	Intrastat Nos.	Code[20]	Specifies the code for the number series that will be used to assign numbers to intrastat documents. To see the number series that have been set up in the No. Series table, click the drop-down arrow in the field.	TableRelation No. Series
15	Split Files	Boolean	Specifies if Receipts and Shipments shall be reported in two separate files.
16	Zip Files	Boolean	Specifies if report file (-s) shall be added to Zip file.
17	Data Exch. Def. Code	Code[20]	Specifies the data exchange definition code to generate the intrastat file.	TableRelation Table 1222 “Data Exch. Def” (Data Exch. Def)
18	Data Exch. Def. Name	Text[100]	Specifies the data exchange definition name to generate the intrastat file.	FlowField: lookup(“Data Exch. Def”.Name where(Code = field(“Data Exch. Def. Code”))); not editable
19	Data Exch. Def. Code - Receipt	Code[20]	Specifies the data exchange definition code to generate the intrastat file for received goods.	TableRelation Table 1222 “Data Exch. Def” (Data Exch. Def)
20	Data Exch. Def. Name - Receipt	Text[100]	Specifies the data exchange definition name to generate the intrastat file for received goods.	FlowField: lookup(“Data Exch. Def”.Name where(Code = field(“Data Exch. Def. Code - Receipt”))); not editable
21	Data Exch. Def. Code - Shpt.	Code[20]	Specifies the data exchange definition code to generate the intrastat file for shipped goods.	TableRelation Table 1222 “Data Exch. Def” (Data Exch. Def)
22	Data Exch. Def. Name - Shpt.	Text[100]	Specifies the data exchange definition name to generate the intrastat file for shipped goods.	FlowField: lookup(“Data Exch. Def”.Name where(Code = field(“Data Exch. Def. Code - Shpt.”))); not editable
23	Shipments Based On	Enum “Intrastat Report Shpt. Base”	Specifies based on which country code Intrastat report lines are taken.	enum Enum 4817 “Intrastat Report Shpt. Base”
24	VAT No. Based On	Enum “Intrastat Report VAT No. Base”	Specifies based on which customer/vendor code VAT number is taken for the Intrastat report.	obsolete Removed 29.0; #if not CLEANSCHEMA29; enum Enum 4818 “Intrastat Report VAT No. Base”
25	Def. Private Person VAT No.	Text[50]	Specifies the default private person VAT number.
26	Def. 3-Party Trade VAT No.	Text[50]	Specifies the default 3-party trade VAT number.
27	Def. VAT for Unknown State	Text[50]	Specifies the default VAT number for unknown state.
28	Def. Country/Region Code	Code[10]	Specifies the default receiving country code.	FlowField: lookup(“Company Information”.“Ship-to Country/Region Code” where(“Primary Key” = const(‘’))); not editable
29	Suppl. Units Weight	Enum “Intrastat Report Suppl. Weight”	—	enum Enum 4821 “Intrastat Report Suppl. Weight”
30	Get Partner VAT For	Enum “Intrastat Report Line Type Sel”	Specifies the type of line that the partner’s VAT registration number is updated for.	enum Enum 4820 “Intrastat Report Line Type Sel”
31	Include Drop Shipment	Boolean	Specifies if drop shipment transactions are included in Intrastat reports.
32	Def. Country Code for Item Tr.	Enum “Default Ctry. Code-Item Track.”	Specifies the default source of country code for item tracking.	enum Enum 4822 “Default Ctry. Code-Item Track.”
33	Sales VAT No. Based On	Enum “Intrastat Report VAT No. Base”	Specifies based on which customer code, or document VAT number is taken for the Intrastat report.	enum Enum 4818 “Intrastat Report VAT No. Base”
34	Purchase VAT No. Based On	Enum “Intr. Rep. Purch. VAT No. Base”	Specifies based on which vendor code, or document VAT number is taken for the Intrastat report.	enum Enum 4823 “Intr. Rep. Purch. VAT No. Base”
35	Project VAT No. Based On	Enum “Intr. Rep. Proj. VAT No. Base”	Specifies based on which customer code VAT number is taken for the Intrastat report.	enum Enum 4826 “Intr. Rep. Proj. VAT No. Base”
36	Sales Intrastat Info Based On	Enum “Intr. Report Sales Info Base”	Specifies based on which customer code Intrastat settings are added to the document.	enum Enum 4824 “Intr. Report Sales Info Base”
37	Purch. Intrastat Info Based On	Enum “Intr. Report Purch. Info Base”	Specifies based on which vendor code Intrastat settings are added to the document.	enum Enum 4825 “Intr. Report Purch. Info Base”
38	Transaction Type Mandatory	Boolean	Specifies if it is mandatory to enter a transaction type on a document header.
39	Transaction Spec. Mandatory	Boolean	Specifies if it is mandatory to enter a transaction specification on a document header.
40	Transport Method Mandatory	Boolean	Specifies if it is mandatory to enter a transport method on a document header.
41	Shipment Method Mandatory	Boolean	Specifies if it is mandatory to enter a shipment method on a document header.
42	Max. No. of Lines in File	Integer	Specifies the maximum number of lines in the Intrastat file.

Keys

Key1: Code (clustered)

Procedures

CheckDeleteIntrastatContact(ContactType: Enum "Intrastat Report Contact Type"; ContactNo: Code[20])
GetSetup()

Relations

Data Exch. Def. Name: CalcFormula Table 1222 “Data Exch. Def”
Data Exch. Def. Name - Receipt: CalcFormula Table 1222 “Data Exch. Def”
Data Exch. Def. Name - Shpt.: CalcFormula Table 1222 “Data Exch. Def”
Data Exch. Def. Code: TableRelation Table 1222 “Data Exch. Def”
Data Exch. Def. Code - Receipt: TableRelation Table 1222 “Data Exch. Def”
Data Exch. Def. Code - Shpt.: TableRelation Table 1222 “Data Exch. Def”
Default Trans. - Purchase: TableRelation Table 258 “Transaction Type”
Default Trans. - Return: TableRelation Table 258 “Transaction Type”
Default Trans. Spec. Code: TableRelation Table 285 “Transaction Specification”
Default Trans. Spec. Ret. Code: TableRelation Table 285 “Transaction Specification”
Def. Country/Region Code: CalcFormula Table 79 “Company Information”

Pages and codeunits on this table

Page 4810 “Intrastat Report Setup” (source table)
Page 4815 “Intrastat Report Setup Wizard” (source table)

Deprecations

field VAT No. Based On: Removed 29.0 (#if not CLEANSCHEMA29), “Use “Sales VAT No. Based On” and “Purchase VAT No. Based On” fields instead.”

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 Report Setup"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.