| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | BUKRS | Company Code | nvarchar | 4 | 0 | | | | Allow NULL? |
| 3 | BUINR | VAT Identification number | nvarchar | 20 | 0 | | | | Allow NULL? |
| 4 | BSTAT | BULSTAT Identification | nvarchar | 15 | 0 | | | | Allow NULL? |
| 5 | CNAME | Name of the company | nvarchar | 150 | 0 | | | | Allow NULL? |
| 6 | CADRC | Address of the company | nvarchar | 200 | 0 | | | | Allow NULL? |
| 7 | PNPIN | VIES PIN/Pers.Number of Non-resident submitting the return | nvarchar | 15 | 0 | | | | Allow NULL? |
| 8 | PPERS | VIES Full Name of the person submitting the data | nvarchar | 150 | 0 | | | | Allow NULL? |
| 9 | PCITY | VIES City from the address for correspondence of sub. person | nvarchar | 50 | 0 | | | | Allow NULL? |
| 10 | PPOST | VIES Postal Code from address for correspondence subm.person | nvarchar | 4 | 0 | | | | Allow NULL? |
| 11 | PADRC | VIES Address for correspondence(quarter,resident complex,..) | nvarchar | 150 | 0 | | | | Allow NULL? |
| 12 | PCAPA | VIES Capacity of the person submitting the return | char | 1 | 0 | | | | Allow NULL? |
| 13 | CUNIT | Branch / Unit | nvarchar | 4 | 0 | | | | Allow NULL? |
| 14 | VRPSD | VAT Person submitting the data | nvarchar | 34 | 0 | | | | Allow NULL? |
| 15 | VRPIN | VAT PIN/Pers.Number of Non-resident submitting the return | nvarchar | 15 | 0 | | | | Allow NULL? |
| 16 | VRRPN | VAT Representative Person | nvarchar | 45 | 0 | | | | Allow NULL? |
| 17 | VRPOS | VAT Position of the representative person | nvarchar | 40 | 0 | | | | Allow NULL? |