Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals | |
---|---|---|---|---|---|---|---|---|---|---|
40: Inventory/OP Base | ||||||||||
1 | F41500 | Tank Master File | 24 | PP | BUM3 | Unit of Measure | String | UDC | 2 | 0 |
2 | F49211 | Sales Order Detail File - Tag File | 38 | UD | BUM3 | Unit of Measure | String | UDC | 2 | 0 |
3 | F49211Z1 | Sales Order Detail Tag Unedited Transaction File | 51 | S1 | BUM3 | Unit of Measure | String | UDC | 2 | 0 |
4 | F49219 | Sales Order Detail - Tag History File | 38 | UD | BUM3 | Unit of Measure | String | UDC | 2 | 0 |
41B: Bulk Stock Management | ||||||||||
5 | F41509 | Four-Point Analysis Maintenance File | 16 | PG | BUM3 | Unit of Measure | String | UDC | 2 | 0 |
6 | F41511 | Bulk Product Transaction File | 25 | PA | BUM3 | Unit of Measure | String | UDC | 2 | 0 |
7 | F41514 | Operational Reconciliations History | 13 | RH | BUM3 | Unit of Measure | String | UDC | 2 | 0 |
42: Sales Management | ||||||||||
8 | F42565 | Invoice Print File | 116 | IW | BUM3 | Unit of Measure | String | UDC | 2 | 0 |
42B: Sales Order Entry | ||||||||||
9 | F49299 | S.O. Detail Tag Ledger File | 38 | UD | BUM3 | Unit of Measure | String | UDC | 2 | 0 |
43: Procurement | ||||||||||
10 | F43121Z | Receiver workfile | 117 | PW | BUM3 | Unit of Measure | String | UDC | 2 | 0 |
11 | F43121Z1 | Receipts Unedited Transaction Table | 125 | SZ | BUM3 | Unit of Measure | String | UDC | 2 | 0 |
49: Transportation Management | ||||||||||
12 | F49621 | Load Compartment Detail | 24 | TD | BUM3 | Unit of Measure | String | UDC | 2 | 0 |
13 | F49631 | Load In-transit Ledger | 50 | TO | BUM3 | Unit of Measure | String | UDC | 2 | 0 |
14 | F49632 | Load In-transit Left on Board | 19 | LB | BUM3 | Unit of Measure | String | UDC | 2 | 0 |
76A: Argentina | ||||||||||
15 | F76A0219 | Detail Lines Invoice/ShipmentNote History WF - ARG - - 76A | 38 | DL | BUM3 | Unit of Measure | String | UDC | 2 | 0 |
16 | F76A021P | Detail Lines Inv./ShipmentNote History WF Purge - ARG - 76A | 38 | DL | BUM3 | Unit of Measure | String | UDC | 2 | 0 |
17 | F76AUI21 | Detail Lines Invoice/ShipmentNote Workfile - ARG - 00 - 00 | 38 | DL | BUM3 | Unit of Measure | String | UDC | 2 | 0 |
User Defined Codes are, by design, customisable and thus will differ from system to system depending on the business requirements.
UDC 00 / UM (Unit of Measure) stock values
Value | Description | Special Handling Code | Hard Coded | |
---|---|---|---|---|
1 | % | Percent | N | |
2 | 12 | Twelve Pack | N | |
3 | AS | Annual Salary(rounded)xmult. | N | |
4 | AT | Annual Salary(truncated)xmult. | N | |
5 | BA | Bar Absolute (Pressure) | N | |
6 | BC | Bag | N | |
7 | BG | Bar Gauge (Pressure) | N | |
8 | BK | Bucket | N | |
9 | BL | Barrels | N | |
10 | BT | Bottles | N | |
11 | BU | Bushel | N | |
12 | BX | Box | N | |
13 | CA | Case | N | |
14 | CC | Cubic Centimeter | V | N |
15 | CF | Hundred Feet | N | |
16 | CI | Cubic Inches | V | N |
17 | CL | Centiliters | V | N |
18 | CM | Centimeters | N | |
19 | CN | Can | N | |
20 | CR | Carton | N | |
21 | CS | Hundred Square Feet | N | |
22 | CT | Carat | N | |
23 | CW | Hundredweight | W | N |
24 | CY | Cubic Yard | V | N |
25 | DC | Decimeters | N | |
26 | DL | Deciliter | N | |
27 | DR | drums | N | |
28 | DW | Penny Weight | ||
29 | DY | Days | N | |
30 | DZ | Dozen | N | |
31 | EA | Each | N | |
32 | FC | Cubic Feet | V | N |
33 | FF | Feet/Inches/16th | N | |
34 | FO | Fluid Ounce | Y | |
35 | FT | Feet | N | |
36 | G1 | 100 Gallons | N | |
37 | GA | Gallons | V | N |
38 | GM | Grams | W | N |
39 | GP | Potent Gallons | VP | N |
40 | GR | Gross | N | |
41 | H1 | Half Hour Calculations | N | |
42 | HA | Average Hourly Rate | N | |
43 | HE | Head Count | N | |
44 | HH | Hours X Hours Worked | N | |
45 | HL | Hectoliter | V | N |
46 | HQ | Hours per period (zero $) | N | |
47 | HR | Hour | N | |
48 | HT | Hectare | N | |
49 | HZ | Hours x Hrs worked (zero $) | N | |
50 | IC | Cubic Inches | V | N |
51 | IG | Imperial Gallons | V | N |
52 | IN | Inches | N | |
53 | JT | Joints | N | |
54 | KG | Kilograms | W | N |
55 | KL | Kiloliter . | N | |
56 | KM | Kilometers | N | |
57 | KT | Karat | N | |
58 | L3 | Pounds per square inch | N | |
59 | LB | Pounds | W | N |
60 | LC | Cubic Liters | V | N |
61 | LF | Linear Feet | N | |
62 | LG | Log | N | |
63 | LP | Potent Liters | VP | N |
64 | LS | Lump Sum | N | |
65 | LT | Liters | V | N |
66 | M3 | Cubic Meters | V | N |
67 | MF | Thousand Feet | N | |
68 | MG | Milligrams | W | N |
69 | MH | Man Hour | N | |
70 | MI | Miles | N | |
71 | MK | Micrograms | W | N |
72 | ML | Milliliter | V | N |
73 | MM | Millimeters . | N | |
74 | MN | Minutes | Y | |
75 | MO | Months | N | |
76 | MP | Thousand Pieces | N | |
77 | MS | Thousand Square Feet | N | |
78 | MT | Meters | N | |
79 | MW | Thousand Pounds | W | N |
80 | OP | Potent Ounces | P | N |
81 | OT | Troy Ounces | N | |
82 | OZ | Ounces | W | N |
83 | PC | Pieces | N | |
84 | PD | Pad | N | |
85 | PL | Pallet | N | |
86 | PR | Pair | N | |
87 | PT | Pint | V | N |
88 | QT | Quart | V | N |
89 | RD | Rental Deposit | N | |
90 | RL | Roll | N | |
91 | RM | Ream | N | |
92 | RT | $1000s of Salary | N | |
93 | SC | Square Centimeters | N | |
94 | SE | Seconds | Y | |
95 | SF | Square Feet | N | |
96 | SI | Square Inches | N | |
97 | SK | Skein | N | |
98 | SL | Sleeve | N | |
99 | SM | Square Meters | N | |
100 | SP | Spaces | ||
101 | SX | Six Pack | N | |
102 | SY | Square Yard | N | |
103 | TK | Tank | N | |
104 | TL | Long Ton (English) | W | N |
105 | TM | Metric Ton | W | N |
106 | TN | Ton (U.S.) | W | N |
107 | TS | Short Ton (U.S.) | W | N |
108 | UN | Units | N | |
109 | WK | Weeks | N | |
110 | WU | Weld Units | N | |
111 | XL | Excess Life | N | |
112 | YD | Yards | N | |
113 | YR | Year | N | |
114 | Z | Set (3-PW) | N |