Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals | |
---|---|---|---|---|---|---|---|---|---|---|

40: Inventory/OP Base | ||||||||||

1 | F40320 | Preference Profile - Multi Shipping/Receiving Locations | 32 | LP | UWUM | Unit of Measure - Weight | String | UDC | 2 | 0 |

2 | F40320R | Preference Resolution Ledger - Multi ShiP/Rec Locations | 33 | LP | UWUM | Unit of Measure - Weight | String | UDC | 2 | 0 |

3 | F41001 | Inventory Constants | 75 | CI | UWUM | Unit of Measure - Weight | String | UDC | 2 | 0 |

40R: Demand Scheduling | ||||||||||

4 | F47UI002 | ASN Extract Packaging Work File | 54 | SP | UWUM | Unit of Measure - Weight | String | UDC | 2 | 0 |

41: Inventory Management | ||||||||||

5 | F4101 | Item Master | 50 | IM | UWUM | Unit of Measure - Weight | String | UDC | 2 | 0 |

6 | F4101A | Item File | 31 | IM | UWUM | Unit of Measure - Weight | String | UDC | 2 | 0 |

7 | F4101Z1 | F4101 Item Master Unedited Transaction Table | 65 | SZ | UWUM | Unit of Measure - Weight | String | UDC | 2 | 0 |

41F: Apparel Management | ||||||||||

8 | FCW09 | Item Revisions Work File | 42 | WR | UWUM | Unit of Measure - Weight | String | UDC | 2 | 0 |

46: Warehouse Management | ||||||||||

9 | F46011 | Item Unit Of Measure Definition | 12 | IQ | UWUM | Unit of Measure - Weight | String | UDC | 2 | 0 |

10 | F4602 | Location Detail Information | 75 | IF | UWUM | Unit of Measure - Weight | String | UDC | 2 | 0 |

11 | F46091 | Container and Carton Codes | 10 | ID | UWUM | Unit of Measure - Weight | String | UDC | 2 | 0 |

12 | F4611 | Warehouse Suggestions | 46 | R2 | UWUM | Unit of Measure - Weight | String | UDC | 2 | 0 |

13 | F4611PU | Warehouse Suggestions - Purged | 45 | R2 | UWUM | Unit of Measure - Weight | String | UDC | 2 | 0 |

14 | F4611Z1 | Unedited Suggestion Table | 58 | SZ | UWUM | Unit of Measure - Weight | String | UDC | 2 | 0 |

15 | F46130 | Putaway Reservations | 80 | R3 | UWUM | Unit of Measure - Weight | String | UDC | 2 | 0 |

16 | F46130PU | Putaway Reservations - Purged | 80 | R3 | UWUM | Unit of Measure - Weight | String | UDC | 2 | 0 |

17 | F4615 | Carton Recommendations | 14 | CR | UWUM | Unit of Measure - Weight | String | UDC | 2 | 0 |

18 | F4620 | Carton Detail Information | 38 | CD | UWUM | Unit of Measure - Weight | String | UDC | 2 | 0 |

19 | F46UI15 | Carton Recommendations - Work File | 14 | RC | UWUM | Unit of Measure - Weight | String | UDC | 2 | 0 |

46L: License Plating | ||||||||||

20 | F46L10 | License Plate Master | 15 | LM | UWUM | Unit of Measure - Weight | String | UDC | 2 | 0 |

21 | F46L30 | Location Capacity | 11 | LC | UWUM | Unit of Measure - Weight | String | UDC | 2 | 0 |

22 | F46L99 | License Plate History | 25 | LM | UWUM | Unit of Measure - Weight | String | UDC | 2 | 0 |

23 | F46LUI03 | Assign/Remove Child LP Work File | 12 | WF | UWUM | Unit of Measure - Weight | String | UDC | 2 | 0 |

47: Electronic Commerce | ||||||||||

24 | F470375 | EDI ASN Packaging Detail | 29 | AK | UWUM | Unit of Measure - Weight | String | UDC | 2 | 0 |

25 | F47082 | EDI Price Sales Catalog Detail - Inbound | 63 | FY | UWUM | Unit of Measure - Weight | String | UDC | 2 | 0 |

75I: India | ||||||||||

26 | F75I380 | Excise - RG-1 - Transaction File - IND | 33 | RG | UWUM | Unit of Measure - Weight | String | UDC | 2 | 0 |

F30L: DFM Line Design | ||||||||||

27 | FF30L501 | DFM Item Definition Master | 100 | IB | UWUM | Unit of Measure - Weight | 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 | . | Y | ||

2 | % | Percent | N | |

3 | 12 | Twelve Pack | N | |

4 | AC | Acre | N | |

5 | AS | Annual Salary(rounded)xmult. | N | |

6 | AT | Annual Salary(truncated)xmult. | N | |

7 | BA | Bar Absolute (Pressure) | N | |

8 | BC | Bag | N | |

9 | BG | Bar Gauge (Pressure) | N | |

10 | BK | Bucket | N | |

11 | BL | Barrels | N | |

12 | BT | Bottles | N | |

13 | BU | Bushel | N | |

14 | BX | Box | N | |

15 | CA | Case | N | |

16 | CC | Cubic Centimeter | V | N |

17 | CF | Hundred Feet | N | |

18 | CI | Cubic Inches | V | N |

19 | CL | Centiliters | V | N |

20 | CM | Centimeters | N | |

21 | CN | Can | N | |

22 | CO | Container | N | |

23 | CR | Carton | N | |

24 | CS | Hundred Square Feet | N | |

25 | CT | Carat | Y | |

26 | CU | Cubic Meter | Y | |

27 | CW | Hundredweight | W | N |

28 | CY | Cubic Yard | V | N |

29 | DC | Decimeters | N | |

30 | DL | Deciliter | N | |

31 | DR | drums | N | |

32 | DW | Penny Weight | ||

33 | DY | Days | N | |

34 | DZ | Dozen | N | |

35 | EA | Each | N | |

36 | FC | Cubic Feet | V | N |

37 | FF | Feet/Inches/16th | N | |

38 | FO | Fluid Ounce | Y | |

39 | FT | Feet | N | |

40 | G1 | 100 Gallons | N | |

41 | GA | Gallons | V | N |

42 | GJ | Giga Joule | Y | |

43 | GM | Grams | W | N |

44 | GP | Potent Gallons | VP | N |

45 | GR | Gross | N | |

46 | H1 | Half Hour Calculations | N | |

47 | HA | Average Hourly Rate | N | |

48 | HE | Head Count | N | |

49 | HH | Hours X Hours Worked | N | |

50 | HL | Hectoliter | V | N |

51 | HQ | Hours per period (zero $) | N | |

52 | HR | Hour | N | |

53 | HT | Hectare | N | |

54 | HZ | Hours x Hrs worked (zero $) | N | |

55 | IC | Cubic Inches | V | N |

56 | IG | Imperial Gallons | V | N |

57 | IN | Inches | N | |

58 | JT | Joints | N | |

59 | KG | Kilograms | W | N |

60 | KL | Kiloliter . | N | |

61 | KM | Kilometers | N | |

62 | KT | Karat | N | |

63 | KW | Kilowatt Hour | Y | |

64 | L3 | Pounds per square inch | N | |

65 | LB | Pounds | W | N |

66 | LC | Cubic Liters | V | N |

67 | LF | Linear Feet | N | |

68 | LG | Log | N | |

69 | LP | Potent Liters | VP | N |

70 | LS | Lump Sum | N | |

71 | LT | Liters | V | N |

72 | M3 | Cubic Meters | V | N |

73 | MF | Thousand Feet | N | |

74 | MG | Milligrams | W | N |

75 | MH | Man Hour | N | |

76 | MI | Miles | N | |

77 | MK | Micrograms | W | N |

78 | ML | Milliliter | V | N |

79 | MM | Millimeters . | N | |

80 | MN | Minutes | Y | |

81 | MO | Months | N | |

82 | MP | Thousand Pieces | N | |

83 | MS | Thousand Square Feet | N | |

84 | MT | Meters | N | |

85 | MW | Thousand Pounds | W | N |

86 | OP | Potent Ounces | P | N |

87 | OT | Troy Ounces | N | |

88 | OZ | Ounces | W | N |

89 | PC | Pieces | N | |

90 | PD | Pad | N | |

91 | PK | Package | N | |

92 | PL | Pallet | N | |

93 | PR | Pair | N | |

94 | PT | Pint | V | N |

95 | QT | Quart | V | N |

96 | RD | Rental Deposit | N | |

97 | RL | Roll | N | |

98 | RM | Ream | N | |

99 | RT | $1000s of Salary | N | |

100 | SC | Square Centimeters | N | |

101 | SE | Seconds | Y | |

102 | SF | Square Feet | N | |

103 | SI | Square Inches | N | |

104 | SK | Skein | N | |

105 | SL | Sleeve | N | |

106 | SM | Square Meters | N | |

107 | SP | Spaces | ||

108 | ST | Eaches | N | |

109 | SX | Six Pack | N | |

110 | SY | Square Yard | N | |

111 | TK | Tank | N | |

112 | TL | Long Ton (English) | W | N |

113 | TM | Metric Ton | W | N |

114 | TN | Ton (U.S.) | W | N |

115 | TS | Short Ton (U.S.) | W | N |

116 | UN | Units | N | |

117 | WK | Weeks | N | |

118 | WU | Weld Units | N | |

119 | XL | Excess Life | N | |

120 | YD | Yards | N | |

121 | YR | Year | N | |

122 | Z | Set (3-PW) | N |