View: Customer eInvoicing

RotoID: EC0130
Table: ECCUST
Protocol: Flat
DLL:ECCUST

Compositions: 2

RotoID Tables Title DLL

AR0024 ARCUS Customers ARCUS
EC0110 ECBUSU Singapore Business Units ECBUSU

Keys: 2

Title Fields

Customer Number IDCUST
Peppol ID PEPPOLID

Fields: 13

Field Index Type Title Attributes Presentation

IDCUST 1 String*12 Customer Number E A K R  Mask: %-12C
PEPPOLID 2 String*50 Customer Peppol ID E A 
AGD 3 Integer Accountant-General's Department? E A  List:2 entries
0 = No
1 = Yes
BUSUNIT 4 String*10 Business Unit E A 
PPLSPEC 5 Integer Peppol Billing Specification E A  List:2 entries
0 = Singapore BIS Billing 3.0
1 = PINT SG Billing 1.0
CNTYNAME 6 Integer Country Name E A  List:231 entries
1 = Afghanistan
2 = Albania
3 = Algeria
4 = American Samoa
5 = Andorra
6 = Angola
7 = Anguilla
8 = Antarctica
9 = Antigua and Barbuda
10 = Argentina
11 = Armenia
12 = Aruba
13 = Australia
14 = Austria
15 = Azerbaijan
16 = Bahamas
17 = Bahrain
18 = Bangladesh
19 = Barbados
20 = Belarus
21 = Belgium
22 = Belize
23 = Benin
24 = Bermuda
25 = Bhutan
26 = Bolivia
27 = Bosnia and Herzegovina
28 = Botswana
29 = Brazil
30 = British Indian Ocean Territory
31 = British Virgin Islands
32 = Brunei
33 = Bulgaria
34 = Burkina Faso
35 = Burma (Myanmar)
36 = Burundi
37 = Cambodia
38 = Cameroon
39 = Canada
40 = Cape Verde
41 = Cayman Islands
42 = Central African Republic
43 = Chad
44 = Chile
45 = China
46 = Christmas Island
47 = Cocos (Keeling) Islands
48 = Colombia
49 = Comoros
50 = Cook Islands
51 = Costa Rica
52 = Croatia
53 = Cuba
54 = Cyprus
55 = Czech Republic
56 = Democratic Republic of the Congo
57 = Denmark
58 = Djibouti
59 = Dominica
60 = Dominican Republic
61 = Ecuador
62 = Egypt
63 = El Salvador
64 = Equatorial Guinea
65 = Eritrea
66 = Estonia
67 = Ethiopia
68 = Falkland Islands
69 = Faroe Islands
70 = Fiji
71 = Finland
72 = France
73 = French Polynesia
74 = Gabon
75 = Gambia
76 = Georgia
77 = Germany
78 = Ghana
79 = Gibraltar
80 = Greece
81 = Greenland
82 = Grenada
83 = Guam
84 = Guatemala
85 = Guinea
86 = Guinea-Bissau
87 = Guyana
88 = Haiti
89 = Holy See (Vatican City)
90 = Honduras
91 = Hungary
92 = Iceland
93 = India
94 = Indonesia
95 = Iran
96 = Iraq
97 = Ireland
98 = Isle of Man
99 = Israel
100 = Italy
101 = Ivory Coast
102 = Jamaica
103 = Japan
104 = Jersey
105 = Jordan
106 = Kazakhstan
107 = Kenya
108 = Kiribati
109 = Kuwait
110 = Kyrgyzstan
111 = Laos
112 = Latvia
113 = Lebanon
114 = Lesotho
115 = Liberia
116 = Libya
117 = Liechtenstein
118 = Lithuania
119 = Luxembourg
120 = Macedonia
121 = Madagascar
122 = Malawi
123 = Malaysia
124 = Maldives
125 = Mali
126 = Malta
127 = Marshall Islands
128 = Mauritania
129 = Mauritius
130 = Mayotte
131 = Mexico
132 = Micronesia
133 = Moldova
134 = Monaco
135 = Mongolia
136 = Montenegro
137 = Montserrat
138 = Morocco
139 = Mozambique
140 = Namibia
141 = Nauru
142 = Nepal
143 = Netherlands
144 = Netherlands Antilles
145 = New Caledonia
146 = New Zealand
147 = Nicaragua
148 = Niger
149 = Nigeria
150 = Niue
151 = North Korea
152 = Northern Mariana Islands
153 = Norway
154 = Oman
155 = Pakistan
156 = Palau
157 = Panama
158 = Papua New Guinea
159 = Paraguay
160 = Peru
161 = Philippines
162 = Pitcairn Islands
163 = Poland
164 = Portugal
165 = Puerto Rico
166 = Qatar
167 = Republic of the Congo
168 = Romania
169 = Russia
170 = Rwanda
171 = Saint Barthelemy
172 = Saint Helena
173 = Saint Kitts and Nevis
174 = Saint Lucia
175 = Saint Martin
176 = Saint Pierre and Miquelon
177 = Saint Vincent and the Grenadines
178 = Samoa
179 = San Marino
180 = Sao Tome and Principe
181 = Saudi Arabia
182 = Senegal
183 = Serbia
184 = Seychelles
185 = Sierra Leone
186 = Singapore
187 = Slovakia
188 = Slovenia
189 = Solomon Islands
190 = Somalia
191 = South Africa
192 = South Korea
193 = Spain
194 = Sri Lanka
195 = Sudan
196 = Suriname
197 = Svalbard
198 = Swaziland
199 = Sweden
200 = Switzerland
201 = Syria
202 = Taiwan
203 = Tajikistan
204 = Tanzania
205 = Thailand
206 = Timor-Leste
207 = Togo
208 = Tokelau
209 = Tonga
210 = Trinidad and Tobago
211 = Tunisia
212 = Turkey
213 = Turkmenistan
214 = Turks and Caicos Islands
215 = Tuvalu
216 = Uganda
217 = Ukraine
218 = United Arab Emirates
219 = United Kingdom
220 = United States
221 = Uruguay
222 = US Virgin Islands
223 = Uzbekistan
224 = Vanuatu
225 = Venezuela
226 = Vietnam
227 = Wallis and Futuna
228 = Western Sahara
229 = Yemen
230 = Zambia
231 = Zimbabwe
EMAILED 7 Integer Notified by Email E A  List:2 entries
0 = No
1 = Yes
NAMECUST 20 String*60 Customer Name E A 
NAMECTAC 21 String*60 Contact Name E A 
BRN 22 String*30 Business Registration Number E A 
COUNTRY 23 String*2 2-Character Country Code E A 
EMAIL1 24 String*50 Contact's Email E A 
CURNCODE 25 String*3 Customer Currency Code E A