Table "VAT Entry Posting Preview"
Properties
| Name | Value |
|---|---|
| Caption | VAT Entry |
| TableType | Temporary |
| DataClassification | SystemMetadata |
Fields
| Name | Type | Description |
|---|---|---|
| "Entry No." | Integer | |
| "Gen. Bus. Posting Group" | Code[20] | Specifies the vendor's or customer's trade type to link transactions made for this business partner with the appropriate general ledger account according to the general posting setup. |
| "Gen. Prod. Posting Group" | Code[20] | Specifies the item's product type to link transactions made for this item with the appropriate general ledger account according to the general posting setup. |
| "Posting Date" | Date | Specifies the VAT entry's posting date. |
| "Document No." | Code[20] | Specifies the document number on the VAT entry. |
| "Document Type" | Enum Microsoft.Finance.GeneralLedger.Journal."Gen. Journal Document Type" | Specifies the document type that the VAT entry belongs to. |
| Type | Enum Microsoft.Foundation.Enums."General Posting Type" | Specifies the type of the VAT entry. |
| Base | Decimal | Specifies the amount that the VAT amount (the amount shown in the Amount field) is calculated from. |
| Amount | Decimal | Specifies the amount of the VAT entry in LCY. |
| "VAT Calculation Type" | Enum Microsoft.Foundation.Enums."Tax Calculation Type" | Specifies how VAT will be calculated for purchases or sales of items with this particular combination of VAT business posting group and VAT product posting group. |
| "Bill-to/Pay-to No." | Code[20] | Specifies the number of the bill-to customer or pay-to vendor that the entry is linked to. |
| "EU 3-Party Trade" | Boolean | Specifies if the transaction is related to trade with a third party within the EU. |
| "User ID" | Code[50] | |
| "Source Code" | Code[10] | |
| "Reason Code" | Code[10] | |
| "Closed by Entry No." | Integer | Specifies the number of the VAT entry that has closed the entry, if the VAT entry was closed with the Calc. and Post VAT Settlement batch job. |
| Closed | Boolean | Specifies whether the VAT entry has been closed by the Calc. and Post VAT Settlement batch job. |
| "Country/Region Code" | Code[10] | Specifies the country/region of the address. |
| "Internal Ref. No." | Text[30] | Specifies the internal reference number for the line. |
| "Transaction No." | Integer | |
| "Unrealized Amount" | Decimal | |
| "Unrealized Base" | Decimal | |
| "Remaining Unrealized Amount" | Decimal | |
| "Remaining Unrealized Base" | Decimal | |
| "External Document No." | Code[35] | |
| "No. Series" | Code[20] | |
| "Tax Area Code" | Code[20] | |
| "Tax Liable" | Boolean | |
| "Tax Group Code" | Code[20] | |
| "Use Tax" | Boolean | |
| "Tax Jurisdiction Code" | Code[10] | |
| "Tax Group Used" | Code[20] | |
| "Tax Type" | Option | |
| "Tax on Tax" | Boolean | |
| "Sales Tax Connection No." | Integer | |
| "Unrealized VAT Entry No." | Integer | |
| "VAT Bus. Posting Group" | Code[20] | Specifies the VAT specification of the involved customer or vendor to link transactions made for this record with the appropriate general ledger account according to the VAT posting setup. |
| "VAT Prod. Posting Group" | Code[20] | Specifies the VAT specification of the involved item or resource to link transactions made for this record with the appropriate general ledger account according to the VAT posting setup. |
| "Additional-Currency Amount" | Decimal | Specifies the amount of the VAT entry. The amount is in the additional reporting currency. |
| "Additional-Currency Base" | Decimal | Specifies the amount that the VAT amount is calculated from if you post in an additional reporting currency. |
| "Add.-Currency Unrealized Amt." | Decimal | |
| "Add.-Currency Unrealized Base" | Decimal | |
| "VAT Base Discount %" | Decimal | |
| "Add.-Curr. Rem. Unreal. Amount" | Decimal | |
| "Add.-Curr. Rem. Unreal. Base" | Decimal | |
| "VAT Difference" | Decimal | Specifies the difference between the calculated VAT amount and a VAT amount that you have entered manually. |
| "Add.-Curr. VAT Difference" | Decimal | Specifies, in the additional reporting currency, the VAT difference that arises when you make a correction to a VAT amount on a sales or purchase document. |
| "Ship-to/Order Address Code" | Code[10] | Specifies the address code of the ship-to customer or order-from vendor that the entry is linked to. |
| "Document Date" | Date | Specifies the date when the related document was created. |
| "VAT Registration No." | Text[20] | Specifies the VAT registration number of the customer or vendor that the entry is linked to. |
| Reversed | Boolean | Specifies if the entry has been part of a reverse transaction. |
| "Reversed by Entry No." | Integer | Specifies the number of the correcting entry. If the field Specifies a number, the entry cannot be reversed again. |
| "Reversed Entry No." | Integer | Specifies the number of the original entry that was undone by the reverse transaction. |
| "EU Service" | Boolean | Specifies if this VAT entry is to be reported as a service in the periodic VAT reports. |
| "Base Before Pmt. Disc." | Decimal | |
| "Realized Amount" | Decimal | |
| "Realized Base" | Decimal | |
| "Add.-Curr. Realized Amount" | Decimal | |
| "Add.-Curr. Realized Base" | Decimal | |
| Indentation | Integer | |
| "VAT Entry No." | Integer | |
| SystemId | Guid | |
| SystemCreatedAt | DateTime | |
| SystemCreatedBy | Guid | |
| SystemModifiedAt | DateTime | |
| SystemModifiedBy | Guid | |
| SystemRowVersion | BigInteger |