Table 1571 VAT Entry Posting Preview in 20
- App
- Base Application
Versions171819202122232425262728latest
Source29
Fields, 61
| 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 | - |
| 81 | Realized Amount | Decimal | - |
| 82 | Realized Base | Decimal | - |
| 83 | Add.-Curr. Realized Amount | Decimal | - |
| 84 | Add.-Curr. Realized Base | Decimal | - |
| 1570 | Indentation | Integer | - |
| 1571 | VAT Entry No. | Integer | - |
Keys, 1
| Name | Fields | Obsolete |
|---|---|---|
| Key1, clustered | Entry No. | - |