|
|
SAP Business One SDK 10.0 - Database Tables Reference |
VAT Reposting Wizard - Rows 2
Table Name: VRW2
Table Description: VAT Reposting Wizard - Rows 2
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| AbsEntry | Internal Number | Int | 11 | - | Â | Â | Â |
| TaxInvID | A/P Tax Invoice ID | Int | 11 | OTPI | Â | Â | Â |
| VatGroup | VAT Group Code | nVarChar | 8 | OVTG | Â | Â | Â |
| Selected | Selected Line | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| LineStatus | Line Status | VarChar | 1 | - | R | C | Canceled |
| Â | Â | Â | Â | Â | Â | R | Regular |
| DebitAcc | Debit Account | nVarChar | 15 | OACT | Â | Â | Â |
| DocDate | Document Date | Date | 8 | - | Â | Â | Â |
| VatAmount | VAT Amount | Num | 19.6 | - | Â | Â | Â |
| NetAmount | Net Amount | Num | 19.6 | - | Â | Â | Â |
| JETransID | Journal Entry Number | Int | 11 | OJDT | Â | Â | Â |
| Ref1 | Reference 1 | nVarChar | 200 | - | Â | Â | Â |
| Ref2 | Reference 2 | nVarChar | 200 | - | Â | Â | Â |
| Ref3 | Reference 3 | nVarChar | 200 | - | Â | Â | Â |
| Remarks | Journal Entry Remarks | nVarChar | 254 | - | Â | Â | Â |
| TrnsCode | Code | nVarChar | 4 | - | Â | Â | Â |
| BPLId | Branch | Int | 11 | OBPL | Â | Â | Â |
| ARINVAbs | First A/R Invoice Abs Entry | Int | 11 | - | 0 | Â | Â |
| ARDocNumAb | A/R Document No. | nVarChar | 20 | - | Â | Â | Â |
| ARAbsEntry | A/R Document Abs Entry | Int | 11 | - | 0 | Â | Â |
| ARObjType | A/R Document Object Type | nVarChar | 20 | - | Â | Â | Â |
| ARDocDate | A/R Document Date | Date | 8 | - | Â | Â | Â |
| CstmrCode | Customer Code | nVarChar | 15 | - | Â | Â | Â |
| CstmrName | Customer Name | nVarChar | 200 | - | Â | Â | Â |
| TpiDocNum | A/P Tax Invoice No. | Int | 11 | - | Â | Â | Â |
| TpiDocDate | A/P Tax Invoice Posting Date | Date | 8 | - | Â | Â | Â |
| VendorCode | Vendor Code | nVarChar | 15 | - | Â | Â | Â |
| VendorName | Vendor Name | nVarChar | 200 | - | Â | Â | Â |
| ARDocMemo | A/R Document Remarks | nVarChar | 254 | - | Â | Â | Â |
| TpiMemo | A/P Tax Invoice Remarks | nVarChar | 254 | - | Â | Â | Â |
| GrsAmt | Gross Amount | Num | 19.6 | - | Â | Â | Â |
| VatAcc | VAT Account | nVarChar | 15 | - | Â | Â | Â |
| OpenVatAmt | Open VAT Amount | Num | 19.6 | - | Â | Â | Â |
| OpenNetAmt | Open Net Amount | Num | 19.6 | - | Â | Â | Â |
| OpenGrsAmt | Open Gross Amount | Num | 19.6 | - | Â | Â | Â |
| RepstedVat | Reposted VAT | Num | 19.6 | - | Â | Â | Â |
| Key | Unique | Field |
| PRIMARY | Yes | AbsEntry |
| Â | Â | TaxInvID |
| Â | Â | VatGroup |
| Â | Â | ARINVAbs |