Previous  Next          Contents  Index  Glossary  Library

Customer Records - details of customers from whom VAT was collected (Belgian VAT ESL Return)

Field Nr
Position
Length
Type
Description
Table/Column Name
1
001 - 006
6
Numeric
Line Number
JE_BE_ESL_SUMMARIES
LINE_NUMBER
2
007 - 038
32
Character
Name of the Customer
JE_BE_ESL_SUMMARIES
CUSTOMER_NAME
3
039 - 062
24
Character
Street and Number
RA_ADDRESSES
ADDRESS1
4
063 - 066
4
Character
Postal Code
RA_ADDRESSES
POSTAL_CODE
5
067 - 090
24
Character
Town
RA_ADDRESSES
CITY
6
091 - 092
2
Character
Country Code
FND_TERRITORIES
ALTERNATE_
TERRITORY_CODE
7
093 - 104
12
Character
VAT Number
RA_SITE_USES
TAX_REFERENCE
(from pos. 3 onwards)
8
105 - 105
1
Character
ESL Code
JE_BE_ESL_SUMMARIES
ESL_CODE
9
106 - 118
13
Numeric
Amount (exclusive of VAT)
JE_BE_ESL_SUMMARIES
EXTENDED_AMOUNT
10
119 - 123
5
Character
Correction Period
GL_PERIODS
QUARTER_NUM and PERIOD_YEAR

11
124 - 128
5
Character
Spaces
-


         Previous  Next          Contents  Index  Glossary  Library