Objects/Tables/Table 263 Intrastat Jnl. Line
Table 263 Intrastat Jnl. Line in 22
Jonas Paprotka, Base Application 22.5.59966.64723, checked
- App
- Base Application
- Obsolete
- Pending 22.0. Intrastat related functionalities are moved to Intrastat extensions.
Fields, 32Keys, 7Procedures, 5Events, 6
Versions171819202122232425262728latest
Source29
Fields, 32
| Id | Name | Type | Obsolete |
|---|
| 1 | Journal Template Name | Code[10] | - |
| 2 | Journal Batch Name | Code[10] | - |
| 3 | Line No. | Integer | - |
| 4 | Type | Option | - |
| 5 | Date | Date | - |
| 6 | Tariff No. | Code[20] | - |
| 7 | Item Description | Text[100] | - |
| 8 | Country/Region Code | Code[10] | - |
| 9 | Transaction Type | Code[10] | - |
| 10 | Transport Method | Code[10] | - |
| 11 | Source Type | Enum Intrastat Source Type | - |
| 12 | Source Entry No. | Integer | - |
| 13 | Net Weight | Decimal | - |
| 14 | Amount | Decimal | - |
| 15 | Quantity | Decimal | - |
| 16 | Cost Regulation % | Decimal | - |
| 17 | Indirect Cost | Decimal | - |
| 18 | Statistical Value | Decimal | - |
| 19 | Document No. | Code[20] | - |
| 20 | Item No. | Code[20] | - |
| 21 | Name | Text[100] | - |
| 22 | Total Weight | Decimal | - |
| 23 | Supplementary Units | Boolean | - |
| 24 | Internal Ref. No. | Text[10] | - |
| 25 | Country/Region of Origin Code | Code[10] | - |
| 26 | Entry/Exit Point | Code[10] | - |
| 27 | Area | Code[10] | - |
| 28 | Transaction Specification | Code[10] | - |
| 29 | Shpt. Method Code | Code[10] | - |
| 30 | Partner VAT ID | Text[50] | - |
| 31 | Location Code | Code[10] | - |
| 32 | Counterparty | Boolean | - |
Keys, 7
| Name | Fields | Obsolete |
|---|
| Key1, clustered | Journal Template Name, Journal Batch Name, Line No. | - |
| Key2 | Source Type, Source Entry No. | - |
| Key3 | Type, Country/Region Code, Tariff No., Transaction Type, Transport Method, Country/Region of Origin Code, Partner VAT ID | - |
| Key4 | Internal Ref. No. | - |
| 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 | - |
Procedures, 5
| Name | Parameters | Returns | Access | Obsolete |
|---|
| IsOpenedFromBatch | () | Boolean | public | - |
| GetCountryOfOriginCode | () | Code[10] | public | - |
| GetPartnerID | () | Text[50] | public | - |
| IsCustomerPrivatePerson | (Code[20]) | Boolean | protected | - |
| IsVendorPrivatePerson | (Code[20]) | Boolean | protected | - |
Events, 6
| Kind | Name | Parameters | Obsolete |
|---|
| Integration event | OnBeforeCheckBatchIsNotReported | (Record Intrastat Jnl. Line, Record Intrastat Jnl. Batch, var Boolean) | - |
| Integration event | OnAfterGetCountryOfOriginCode | (var Record Intrastat Jnl. Line, var Code[10]) | - |
| Integration event | OnBeforeGetItemDescription | (var Boolean, var Record Intrastat Jnl. Line) | - |
| Integration event | OnBeforeGetPartnerID | (var Record Intrastat Jnl. Line, var Text[50], var Boolean) | - |
| Integration event | OnBeforeGetPartnerIDForCountry | (Code[10], Text[50], Boolean, Boolean, var Text[50], var Boolean) | - |
| Integration event | OnAfterGetPartnerIDFromJobEntry | (var Record Intrastat Jnl. Line, Record Customer, var Text[50]) | - |