| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | EHPRCD_COD_CHKR | Check Result | 19 | DECL_TYPE | Type of Declaration | nvarchar | 20 | 0 | | |
2 | FIKZD_REGINV_IN | Incoming Invoice Registration Journal | 52 | DECL_TYPE | Declaration Type | nvarchar | 1 | 0 | | |
3 | FIKZD_REGINV_OUT | Outgoing Invoice Registration Journal | 51 | DECL_TYPE | Declaration Type | nvarchar | 1 | 0 | | |
4 | FIKZD_RET_REG | Register for customer returns (VAT and Tax Import) | 6 | DECL_TYPE | Declaration Type | nvarchar | 1 | 0 | | |
TOPBelgium |
5 | T5BR6 | Form types | 4 | DECL_TYPE | Declaration Type | nvarchar | 1 | 0 | | |
TOPFinancial Accounting |
6 | FOTDECLSTA | Status Information Rep Data Electronic Data Transmission | 2 | DECL_TYPE | Return Type for Authorities | nvarchar | 4 | 0 | | |
7 | FOTDECLTYC | Return Type Electronic Data Transmission to Authorities | 1 | DECL_TYPE | Return Type for Authorities | nvarchar | 4 | 0 | | |
8 | FOTDECLTYT | Name of Return Type Electronic Data Transmission | 2 | DECL_TYPE | Return Type for Authorities | nvarchar | 4 | 0 | | |
9 | FOTETAXC | Settings Electronic Data Transmission to Authorities | 4 | DECL_TYPE | Return Type for Authorities | nvarchar | 4 | 0 | | |
10 | FOTPARREFC | Assignment of Parameters Reporting Country Return Type | 1 | DECL_TYPE | Return Type for Authorities | nvarchar | 4 | 0 | | |
11 | FOTRFDITM | VAT Refund Items | 3 | DECL_TYPE | Return Type for Authorities | nvarchar | 4 | 0 | | |
12 | FOTRFDPER | Period/Month in VAT Refund Application | 2 | DECL_TYPE | Return Type for Authorities | nvarchar | 4 | 0 | | |
13 | FOTTBUKRS | Assignment of Company Codes to Dominant Enterprises | 2 | DECL_TYPE | Return Type for Authorities | nvarchar | 4 | 0 | | |
14 | FOTTDCLITM | Multinational ATR Items (TaxDeclarationNotificationItem) | 2 | DECL_TYPE | Return Type for Authorities | nvarchar | 4 | 0 | | |
15 | FOTTDCLNOT | Multinational ATR Rep. Data (TaxDeclarationNotification) | 2 | DECL_TYPE | Return Type for Authorities | nvarchar | 4 | 0 | | |