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