Previous  Next          Contents  Index  Glossary  Library

Detail Records - list details for customers from whom VAT was collected (Belgian Annual VAT Return)

Field Nr
Position
Length
Type
Description
Table/Column Name
1
001 - 006
6
character
Customer Count
-
2
007 - 038
32
Character
Name of the Customer
RA_CUSTOMERS
CUSTOMER_NAME
3
039 - 062
24
Character
Street and Number
RA_ADDRESSES
ADDRESS1
4
063 - 066
4
Numeric
Postal Code
RA_ADDRESSES
POSTAL_CODE
5
067 - 089
23
Character
Town
RA_ADDRESSES
CITY
6
090 - 100
11
Character
VAT Number
RA_SITE_USES
TAX_REFERENCE
7
101 - 110
10
Numeric
Line Amount (exclusive of VAT)
RA_CUSTOMER_TRX_LINES
EXTENDED_
AMOUNT
8
111 - 120
10
Numeric
VAT Amount
RA_CUSTOMER_TRX_LINES
EXTENDED
_AMOUNT
9
121 - 128
8
Character
Spaces
-


         Previous  Next          Contents  Index  Glossary  Library