Table 254 VAT Entry in 21
- App
- Base Application
Fields, 63Keys, 12Procedures, 10Events, 4
Versions171819202122232425262728latest
Source29
Fields, 63
| Id | Name | Type | Obsolete |
|---|---|---|---|
| 1 | Entry No. | Integer | - |
| 2 | Gen. Bus. Posting Group | Code[20] | - |
| 3 | Gen. Prod. Posting Group | Code[20] | - |
| 4 | Posting Date | Date | - |
| 5 | Document No. | Code[20] | - |
| 6 | Document Type | Enum Gen. Journal Document Type | - |
| 7 | Type | Enum General Posting Type | - |
| 8 | Base | Decimal | - |
| 9 | Amount | Decimal | - |
| 10 | VAT Calculation Type | Enum Tax Calculation Type | - |
| 12 | Bill-to/Pay-to No. | Code[20] | - |
| 13 | EU 3-Party Trade | Boolean | - |
| 14 | User ID | Code[50] | - |
| 15 | Source Code | Code[10] | - |
| 16 | Reason Code | Code[10] | - |
| 17 | Closed by Entry No. | Integer | - |
| 18 | Closed | Boolean | - |
| 19 | Country/Region Code | Code[10] | - |
| 20 | Internal Ref. No. | Text[30] | - |
| 21 | Transaction No. | Integer | - |
| 22 | Unrealized Amount | Decimal | - |
| 23 | Unrealized Base | Decimal | - |
| 24 | Remaining Unrealized Amount | Decimal | - |
| 25 | Remaining Unrealized Base | Decimal | - |
| 26 | External Document No. | Code[35] | - |
| 28 | No. Series | Code[20] | - |
| 29 | Tax Area Code | Code[20] | - |
| 30 | Tax Liable | Boolean | - |
| 31 | Tax Group Code | Code[20] | - |
| 32 | Use Tax | Boolean | - |
| 33 | Tax Jurisdiction Code | Code[10] | - |
| 34 | Tax Group Used | Code[20] | - |
| 35 | Tax Type | Option | - |
| 36 | Tax on Tax | Boolean | - |
| 37 | Sales Tax Connection No. | Integer | - |
| 38 | Unrealized VAT Entry No. | Integer | - |
| 39 | VAT Bus. Posting Group | Code[20] | - |
| 40 | VAT Prod. Posting Group | Code[20] | - |
| 43 | Additional-Currency Amount | Decimal | - |
| 44 | Additional-Currency Base | Decimal | - |
| 45 | Add.-Currency Unrealized Amt. | Decimal | - |
| 46 | Add.-Currency Unrealized Base | Decimal | - |
| 48 | VAT Base Discount % | Decimal | - |
| 49 | Add.-Curr. Rem. Unreal. Amount | Decimal | - |
| 50 | Add.-Curr. Rem. Unreal. Base | Decimal | - |
| 51 | VAT Difference | Decimal | - |
| 52 | Add.-Curr. VAT Difference | Decimal | - |
| 53 | Ship-to/Order Address Code | Code[10] | - |
| 54 | Document Date | Date | - |
| 55 | VAT Registration No. | Text[20] | - |
| 56 | Reversed | Boolean | - |
| 57 | Reversed by Entry No. | Integer | - |
| 58 | Reversed Entry No. | Integer | - |
| 59 | EU Service | Boolean | - |
| 60 | Base Before Pmt. Disc. | Decimal | - |
| 78 | Journal Templ. Name | Code[10] | - |
| 79 | Journal Batch Name | Code[10] | - |
| 81 | Realized Amount | Decimal | - |
| 82 | Realized Base | Decimal | - |
| 83 | Add.-Curr. Realized Amount | Decimal | - |
| 84 | Add.-Curr. Realized Base | Decimal | - |
| 85 | G/L Acc. No. | Code[20] | - |
| 86 | VAT Reporting Date | Date | - |
Keys, 12
| Name | Fields | Obsolete |
|---|---|---|
| Key1, clustered | Entry No. | - |
| Key2 | Type, Closed, VAT Bus. Posting Group, VAT Prod. Posting Group, Posting Date, G/L Acc. No., VAT Reporting Date | - |
| Key3 | Type, Closed, Tax Jurisdiction Code, Use Tax, Posting Date | - |
| Key4 | Type, Country/Region Code, VAT Registration No., VAT Bus. Posting Group, VAT Prod. Posting Group, Posting Date | - |
| Key5 | Document No., Posting Date | - |
| Key6 | Transaction No. | - |
| Key7 | Tax Jurisdiction Code, Tax Group Used, Tax Type, Use Tax, Posting Date | - |
| Key8 | Type, Bill-to/Pay-to No., Transaction No. | - |
| Key9 | Type, Closed, VAT Bus. Posting Group, VAT Prod. Posting Group, Tax Jurisdiction Code, Use Tax, Posting Date, G/L Acc. No. | - |
| Key10 | Posting Date, Type, Closed, VAT Bus. Posting Group, VAT Prod. Posting Group, Reversed, G/L Acc. No. | - |
| Key11 | Document Date | - |
| Key12 | G/L Acc. No. | - |
Procedures, 10
| Name | Parameters | Returns | Access | Obsolete |
|---|---|---|---|---|
| GetLastEntryNo | () | Integer | public | - |
| GetUnrealizedVATPart | (Decimal, Decimal, Decimal, Decimal, Decimal) | Decimal | public | - |
| CopyFromGenJnlLine | (Record Gen. Journal Line) | public | - | |
| CopyAmountsFromVATEntry | (Record VAT Entry, Boolean) | public | - | |
| SetUnrealAmountsToZero | () | public | - | |
| SetGLAccountNo | (Boolean) | public | - | |
| SetGLAccountNoWithResponse | (Boolean, Boolean, var Boolean) | public | - | |
| CheckGLAccountNoFilled | () | public | - | |
| CopyPostingDataFromGenJnlLine | (Record Gen. Journal Line) | public | - | |
| SetVATDateFromGenJnlLine | (var Record Gen. Journal Line) | internal | - |
Events, 4
| Kind | Name | Parameters | Obsolete |
|---|---|---|---|
| Integration event | OnAfterCopyFromGenJnlLine | (var Record VAT Entry, Record Gen. Journal Line) | - |
| Integration event | OnAfterCopyAmountsFromVATEntry | (var Record VAT Entry, Boolean) | - |
| Integration event | OnBeforeSetGLAccountNo | (var Record VAT Entry, var Boolean, var Boolean, Boolean, Boolean) | - |
| Integration event | OnAfterSetGLAccountNo | (var Record VAT Entry, var Boolean, Boolean) | - |