Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals | |
---|---|---|---|---|---|---|---|---|---|---|
41: Inventory Management | ||||||||||
1 | F4101A | Item File | 74 | IM | ORIG | Country of Origin | String | UDC | 3 | 0 |
2 | F4101Z1 | F4101 Item Master Unedited Transaction Table | 156 | SZ | ORIG | Country of Origin | String | UDC | 3 | 0 |
3 | F4102 | Item Branch File | 32 | IB | ORIG | Country of Origin | String | UDC | 3 | 0 |
47: Electronic Commerce | ||||||||||
4 | F470472 | EDI Invoice Expanded Detail (Sales) | 17 | S6 | ORIG | Country of Origin | String | UDC | 3 | 0 |
5 | F47082 | EDI Price Sales Catalog Detail - Inbound | 45 | FY | ORIG | Country of Origin | String | UDC | 3 | 0 |
74: EMEA Localization | ||||||||||
6 | F0018T | Intrastat Revision | 16 | TD | ORIG | Country of Origin | String | UDC | 3 | 0 |
7 | F744101 | Intrastat Supplier/Item Cross Reference Table | 3 | IN | ORIG | Country of Origin | String | UDC | 3 | 0 |
76A: Argentina | ||||||||||
8 | F76A0209 | Header and Footer Invoice/ShipmentNote History WF - ARG - 76A | 74 | HF | ORIG | Country of Origin | String | UDC | 3 | 0 |
9 | F76A020P | Header/Footer Inv./ShipmentNote History WF Purge - AR - 76A | 74 | HF | ORIG | Country of Origin | String | UDC | 3 | 0 |
10 | F76A09 | Invoice Total - ARG - 00 - 00 | 62 | TT | ORIG | Country of Origin | String | UDC | 3 | 0 |
11 | F76A09P | Invoice Total Purge - ARG - 03B - 76A | 62 | TT | ORIG | Country of Origin | String | UDC | 3 | 0 |
12 | F76AUI20 | Header and Footer Invoice/ShipmentNote Workfile - ARG - - 00 | 74 | HF | ORIG | Country of Origin | String | UDC | 3 | 0 |
User Defined Codes are, by design, customisable and thus will differ from system to system depending on the business requirements.
UDC 00 / CN (Country Codes) stock values
Value | Description | Special Handling Code | Hard Coded | |
---|---|---|---|---|
1 | AE | UNITED ARAB EMIRATES | N | |
2 | AN | NETHERLANDS ANTILLES | N | |
3 | AZ | AZERBAIJAN | N | |
4 | BA | BOSNIA | N | |
5 | BB | BARBADOS | N | |
6 | BD | BANGLADESH | N | |
7 | BE | BELGIUM | N | |
8 | BF | BURKINA FASO | N | |
9 | BG | BULGARIA | N | |
10 | BH | BAHRAIN | N | |
11 | BI | BURUNDI | N | |
12 | BJ | BENIN | N | |
13 | BM | BERMUDA | N | |
14 | BN | BRUNEI | N | |
15 | BO | BOLIVIA | N | |
16 | BR | BRAZIL | N | |
17 | BS | BAHAMAS | N | |
18 | BT | BHUTAN | N | |
19 | BW | BOTSWANA | N | |
20 | BY | BELARUS | N | |
21 | BZ | BELIZE | N | |
22 | CA | CANADA | N | |
23 | CD | CONGO, | N | |
24 | CF | CENTRAL AFRICAN | N | |
25 | CG | CONGO | N | |
26 | CH | SWITZERLAND | N | |
27 | CI | COTE D'IVOIRE | N | |
28 | CK | COOK ISLANDS | N | |
29 | CL | CHILE | N | |
30 | CM | CAMEROON | N | |
31 | CN | CHINA, | N | |
32 | CO | COLOMBIA | N | |
33 | CR | COSTA RICA | N | |
34 | CU | CUBA | N | |
35 | CV | CAPE VERDE | N | |
36 | CY | CYPRUS | N | |
37 | CZ | CZECH REPUBLIC, THE | N | |
38 | DE | GERMANY | N | |
39 | DJ | DJIBOUTI | N | |
40 | DK | DENMARK | N | |
41 | DM | DOMINICA | N | |
42 | DO | DOMINICAN REPUBLIC | N | |
43 | EC | ECUADOR | N | |
44 | EE | ESTONIA | N | |
45 | EG | EGYPT | N | |
46 | ER | ERITREA | N | |
47 | ES | SPAIN | N | |
48 | ET | ETHIOPIA | N | |
49 | FI | FINLAND | N | |
50 | FJ | FIJI | N | |
51 | FK | FALKLAND ISLANDS | N | |
52 | FM | MICRONESIA, | N | |
53 | FO | FAROE ISLANDS | N | |
54 | FR | FRANCE | N | |
55 | GA | GABON | N | |
56 | GB | UNITED KINGDOM | N | |
57 | GD | GRENADA | N | |
58 | GE | GEORGIA | N | |
59 | GF | FRENCH GUYANA | N | |
60 | GG | GUERNSEY | N | |
61 | GH | GHANA | N | |
62 | GI | GIBRALTAR | N | |
63 | GL | GREENLAND | N | |
64 | GM | GAMBIA | N | |
65 | GN | GUINEA REPUBLIC | N | |
66 | GP | GUADELOUPE | N | |
67 | GQ | GUINEA-EQUATORIAL | N | |
68 | GR | GREECE | N | |
69 | GT | GUATEMALA | N | |
70 | GU | GUAM | N | |
71 | GW | GUINEA-BISSAU | N | |
72 | GY | GUYANA (BRITISH) | N | |
73 | HK | HONG KONG | N | |
74 | HN | HONDURAS | N | |
75 | HR | CROATIA | N | |
76 | HT | HAITI | N | |
77 | HU | HUNGARY | N | |
78 | IC | CANARY ISLANDS, THE | N | |
79 | ID | INDONESIA | N | |
80 | IE | IRELAND, REPUBLIC OF | N | |
81 | IL | ISRAEL | N | |
82 | IN | INDIA | N | |
83 | IQ | IRAQ | N | |
84 | IR | IRAN (ISLAMIC REPUBLIC OF) | N | |
85 | IS | ICELAND | N | |
86 | IT | ITALY | N | |
87 | JE | JERSEY | N | |
88 | JM | JAMAICA | N | |
89 | JO | JORDAN | N | |
90 | JP | JAPAN | N | |
91 | KE | KENYA | N | |
92 | KG | KYRGYZSTAN | N | |
93 | KH | CAMBODIA | N | |
94 | KI | KIRIBATI | N | |
95 | KM | COMOROS | N | |
96 | KN | ST. KITTS | N | |
97 | KP | KOREA, THE D.P.R OF | N | |
98 | KR | KOREA, REPUBLIC OF | N | |
99 | KV | KOSOVO | N | |
100 | KW | KUWAIT | N | |
101 | KY | CAYMAN ISLANDS | N | |
102 | KZ | KAZAKHSTAN | N | |
103 | LA | LAO PEOPLE'S | N | |
104 | LB | LEBANON | N | |
105 | LC | ST. LUCIA | N | |
106 | LI | LIECHTENSTEIN | N | |
107 | LK | SRI LANKA | N | |
108 | LR | LIBERIA | N | |
109 | LS | LESOTHO | N | |
110 | LT | LITHUANIA | N | |
111 | LU | LUXEMBOURG | N | |
112 | LV | LATVIA | N | |
113 | LY | LIBYA | N | |
114 | MA | MOROCCO | N | |
115 | MC | MONACO | N | |
116 | MD | MOLDOVA, REPUBLIC OF | N | |
117 | ME | MONTENEGRO, | N | |
118 | MG | MADAGASCAR | N | |
119 | MH | MARSHALL ISLANDS | N | |
120 | MK | MACEDONIA, | N | |
121 | ML | MALI | N | |
122 | MM | MYANMAR | N | |
123 | MN | MONGOLIA | N | |
124 | MO | MACAU | N | |
125 | MP | SAIPAN | N | |
126 | MQ | MARTINIQUE | N | |
127 | MR | MAURITANIA | N | |
128 | MS | MONTSERRAT | N | |
129 | MT | MALTA | N | |
130 | MU | MAURITIUS | N | |
131 | MV | MALDIVES | N | |
132 | MW | MALAWI | N | |
133 | MX | MEXICO | N | |
134 | MY | MALAYSIA | N | |
135 | MZ | MOZAMBIQUE | N | |
136 | NA | NAMIBIA | N | |
137 | NC | NEW CALEDONIA | N | |
138 | NE | NIGER | N | |
139 | NG | NIGERIA | N | |
140 | NI | NICARAGUA | N | |
141 | NL | NETHERLANDS, THE | N | |
142 | NO | NORWAY | N | |
143 | NP | NEPAL | N | |
144 | NR | NAURU, REPUBLIC OF | N | |
145 | NU | NIUE | N | |
146 | NZ | NEW ZEALAND | N | |
147 | OM | OMAN | N | |
148 | PA | PANAMA | N | |
149 | PE | PERU | N | |
150 | PF | TAHITI | N | |
151 | PG | PAPUA NEW GUINEA | N | |
152 | PH | PHILIPPINES, THE | N | |
153 | PK | PAKISTAN | N | |
154 | PL | POLAND | N | |
155 | PR | PUERTO RICO | N | |
156 | PT | PORTUGAL | N | |
157 | PW | PALAU | N | |
158 | PY | PARAGUAY | N | |
159 | QA | QATAR | N | |
160 | RE | REUNION, ISLAND OF | N | |
161 | RO | ROMANIA | N | |
162 | RS | SERBIA, REPUBLIC OF | N | |
163 | RU | RUSSIAN FEDERATION, THE | N | |
164 | RW | RWANDA | N | |
165 | SA | SAUDI ARABIA | N | |
166 | SB | SOLOMON ISLANDS | N | |
167 | SC | SEYCHELLES | N | |
168 | SD | SUDAN | N | |
169 | SE | SWEDEN | N | |
170 | SG | SINGAPORE | N | |
171 | SI | SLOVENIA | N | |
172 | SK | SLOVAKIA | N | |
173 | SL | SIERRA LEONE | N | |
174 | SM | SAN MARINO | N | |
175 | SN | SENEGAL | N | |
176 | SO | SOMALIA | N | |
177 | SR | SURINAME | N | |
178 | ST | SAO TOME AND PRINCIPE | N | |
179 | SV | EL SALVADOR | N | |
180 | SY | SYRIA | N | |
181 | SZ | SWAZILAND | N | |
182 | TC | TURKS AND CAICOS ISLANDS | N | |
183 | TD | CHAD | N | |
184 | TG | TOGO | N | |
185 | TH | THAILAND | N | |
186 | TJ | TAJIKISTAN | N | |
187 | TM | TURKMENISTAN | N | |
188 | TN | TUNISIA | N | |
189 | TO | TONGA | N | |
190 | TP | EAST TIMOR | N | |
191 | TR | TURKEY | N | |
192 | TT | TRINIDAD AND TOBAGO | N | |
193 | TV | TUVALU | N | |
194 | TW | TAIWAN | N | |
195 | TZ | TANZANIA | N | |
196 | UA | UKRAINE | N | |
197 | UG | UGANDA | N | |
198 | US | UNITED STATES OF AMERICA | N | |
199 | UY | URUGUAY | N | |
200 | UZ | UZBEKISTAN | N | |
201 | VC | ST. VINCENT | N | |
202 | VE | VENEZUELA | N | |
203 | VG | VIRGIN ISLANDS (BRITISH) | N | |
204 | VI | VIRGIN ISLANDS (US) | N | |
205 | VN | VIETNAM | N | |
206 | VU | VANUATU | N | |
207 | WS | SAMOA | N | |
208 | XB | BONAIRE | N | |
209 | XC | CURACAO | N | |
210 | XE | ST. EUSTATIUS | N | |
211 | XM | ST. MAARTEN | N | |
212 | XN | NEVIS | N | |
213 | XS | SOMALILAND, | N | |
214 | XY | ST. BARTHELEMY | N | |
215 | YE | YEMEN, REPUBLIC OF | N | |
216 | YT | MAYOTTE | N | |
217 | ZA | SOUTH AFRICA | N | |
218 | ZM | ZAMBIA | N | |
219 | ZW | ZIMBABWE | N |