| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | * | MANDT | Allow NULL? |
| 2 | BUKRS | Company Code | nvarchar | 4 | 0 | CHAR | (N' ') | No | * | BUKRS | Allow NULL? |
| 3 | BUINR | VAT Identification number | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | /BGLOCS/FI_VAT_NUMBER | Allow NULL? |
| 4 | BSTAT | BULSTAT Identification | nvarchar | 15 | 0 | CHAR | (N' ') | Yes | | /BGLOCS/FI_BULSTAT | Allow NULL? |
| 5 | CNAME | Name of the company | nvarchar | 150 | 0 | CHAR | (N' ') | Yes | | /BGLOCS/FI_CMP_NAME | Allow NULL? |
| 6 | CADRC | Address of the company | nvarchar | 200 | 0 | CHAR | (N' ') | Yes | | /BGLOCS/FI_CMP_ADR | Allow NULL? |
| 7 | PNPIN | VIES PIN/Pers.Number of Non-resident submitting the return | nvarchar | 15 | 0 | CHAR | (N' ') | Yes | | /BGLOCS/FI_PERS_PIN | Allow NULL? |
| 8 | PPERS | VIES Full Name of the person submitting the data | nvarchar | 150 | 0 | CHAR | (N' ') | Yes | | /BGLOCS/FI_PERS_NAME | Allow NULL? |
| 9 | PCITY | VIES City from the address for correspondence of sub. person | nvarchar | 50 | 0 | CHAR | (N' ') | Yes | | /BGLOCS/FI_PERS_CITY | Allow NULL? |
| 10 | PPOST | VIES Postal Code from address for correspondence subm.person | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | /BGLOCS/FI_PERS_POSTAL | Allow NULL? |
| 11 | PADRC | VIES Address for correspondence(quarter,resident complex,..) | nvarchar | 150 | 0 | CHAR | (N' ') | Yes | | /BGLOCS/FI_PERS_ADR | Allow NULL? |
| 12 | PCAPA | VIES Capacity of the person submitting the return | char | 1 | 0 | CHAR | (N' ') | Yes | | /BGLOCS/FI_PERS_CAPACITY | Allow NULL? |
| 13 | CUNIT | Branch / Unit | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | /BGLOCS/FI_COMP_UNIT | Allow NULL? |
| 14 | VRPSD | VAT Person submitting the data | nvarchar | 34 | 0 | CHAR | (N' ') | Yes | | /BGLOCS/FI_PERS_SUBMIT | Allow NULL? |
| 15 | VRPIN | VAT PIN/Pers.Number of Non-resident submitting the return | nvarchar | 15 | 0 | CHAR | (N' ') | Yes | | /BGLOCS/FI_PERS_PIN_VAT | Allow NULL? |
| 16 | VRRPN | VAT Representative Person | nvarchar | 45 | 0 | CHAR | (N' ') | Yes | | /BGLOCS/FI_PERS_NAME_VAT | Allow NULL? |
| 17 | VRPOS | VAT Position of the representative person | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | /BGLOCS/FI_PERS_POS | Allow NULL? |
