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

17: Customer Service Management | ||||||||||

1 | F1721 | Contract Detail | 63 | CD | UOM4 | Unit of Measure - Pricing | String | UDC | 2 | 0 |

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

2 | F4011Z | Batch Receiver File - Order Details | 158 | SZ | UOM4 | Unit of Measure - Pricing | String | UDC | 2 | 0 |

3 | F4012ZW | WF - Destination Quantity | 34 | SP | UOM4 | Unit of Measure - Pricing | String | UDC | 2 | 0 |

4 | F4013Z | Kit Components Batch File | 15 | KS | UOM4 | Unit of Measure - Pricing | String | UDC | 2 | 0 |

5 | F40302 | Preference Profile - Unit of Measure | 12 | PU | UOM4 | Unit of Measure - Pricing | String | UDC | 2 | 0 |

6 | F40302R | Preference Resolution Ledger - Pricing Unit Of Measure | 14 | PU | UOM4 | Unit of Measure - Pricing | String | UDC | 2 | 0 |

7 | F40347 | Preference Profile - Pricing UOM (Branch) | 14 | RI | UOM4 | Unit of Measure - Pricing | String | UDC | 2 | 0 |

8 | F40347R | Preference Resolution Ledger - Pricing UOM (Branch) | 16 | RI | UOM4 | Unit of Measure - Pricing | String | UDC | 2 | 0 |

9 | F4211Z1 | Sales Order Detail Unedited Transaction File | 145 | SZ | UOM4 | Unit of Measure - Pricing | String | UDC | 2 | 0 |

40G: Grower Management | ||||||||||

10 | F40G02 | Grower Block | 63 | GB | UOM4 | Unit of Measure - Pricing | String | UDC | 2 | 0 |

11 | F40G0200 | Grower Block Update Profile | 144 | BU | UOM4 | Unit of Measure - Pricing | String | UDC | 2 | 0 |

12 | F40G03 | Grower Harvest | 71 | GH | UOM4 | Unit of Measure - Pricing | String | UDC | 2 | 0 |

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

13 | F4101 | Item Master | 46 | IM | UOM4 | Unit of Measure - Pricing | String | UDC | 2 | 0 |

14 | F4101A | Item File | 27 | IM | UOM4 | Unit of Measure - Pricing | String | UDC | 2 | 0 |

15 | F4101Z1 | F4101 Item Master Unedited Transaction Table | 61 | SZ | UOM4 | Unit of Measure - Pricing | String | UDC | 2 | 0 |

42: Sales Management | ||||||||||

16 | F4211 | Sales Order Detail File | 132 | SD | UOM4 | Unit of Measure - Pricing | String | UDC | 2 | 0 |

17 | F42119 | Sales Order History File | 132 | SD | UOM4 | Unit of Measure - Pricing | String | UDC | 2 | 0 |

18 | F42199 | S.O. Detail Ledger File | 132 | SL | UOM4 | Unit of Measure - Pricing | String | UDC | 2 | 0 |

19 | F42565 | Invoice Print File | 22 | IW | UOM4 | Unit of Measure - Pricing | String | UDC | 2 | 0 |

20 | F42UI11 | SO Detail Cache File (MBF) | 92 | ZD | UOM4 | Unit of Measure - Pricing | String | UDC | 2 | 0 |

21 | F42UI521 | Pick Slips Detail File | 103 | S9 | UOM4 | Unit of Measure - Pricing | String | UDC | 2 | 0 |

42B: Sales Order Entry | ||||||||||

22 | F42420 | Audit Log Transaction | 29 | AL | UOM4 | Unit of Measure - Pricing | String | UDC | 2 | 0 |

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

23 | F47012 | EDI Purchase Order Detail - Inbound | 159 | SZ | UOM4 | Unit of Measure - Pricing | String | UDC | 2 | 0 |

24 | F47027 | EDI P.O. Acknowledgment Detail - Outbound | 159 | SZ | UOM4 | Unit of Measure - Pricing | String | UDC | 2 | 0 |

25 | F47037 | EDI Shipping Notice Detail - Outbound | 141 | SZ | UOM4 | Unit of Measure - Pricing | String | UDC | 2 | 0 |

26 | F470371 | EDI Shipping Notice Detail - Outbound | 162 | SZ | UOM4 | Unit of Measure - Pricing | String | UDC | 2 | 0 |

27 | F47047 | EDI Invoice Detail (Sales) - Outbound | 159 | SZ | UOM4 | Unit of Measure - Pricing | String | UDC | 2 | 0 |

28 | F47082 | EDI Price Sales Catalog Detail - Inbound | 62 | FY | UOM4 | Unit of Measure - Pricing | String | UDC | 2 | 0 |

29 | F47092 | EDI Request for Quote Detail - Inbound | 159 | SZ | UOM4 | Unit of Measure - Pricing | String | UDC | 2 | 0 |

30 | F47107 | EDI Response to RFQ Detail - Outbound | 159 | SZ | UOM4 | Unit of Measure - Pricing | String | UDC | 2 | 0 |

31 | F47132 | EDI Purchase Order Change Detail - Inbound | 160 | SZ | UOM4 | Unit of Measure - Pricing | String | UDC | 2 | 0 |

32 | F47147 | EDI P.O. Change Acknowledgment Detail - Outbound | 161 | SZ | UOM4 | Unit of Measure - Pricing | String | UDC | 2 | 0 |

74: EMEA Localization | ||||||||||

33 | F7420033 | Sales Document Line (Print Info) - COMM - 42 | 15 | PI | UOM4 | Unit of Measure - Pricing | String | UDC | 2 | 0 |

34 | F7420034 | Price Adjustment (Print Info) - COMM - 42 | 10 | PI | UOM4 | Unit of Measure - Pricing | String | UDC | 2 | 0 |

75C: China - Reporting System Only | ||||||||||

35 | F75C4106 | Chinese Free Goods VAT base price - F75C4106 | 2 | IB | UOM4 | Unit of Measure - Pricing | String | UDC | 2 | 0 |

76A: Argentina | ||||||||||

36 | F76A0219 | Detail Lines Invoice/ShipmentNote History WF - ARG - - 76A | 18 | DL | UOM4 | Unit of Measure - Pricing | String | UDC | 2 | 0 |

37 | F76A021P | Detail Lines Inv./ShipmentNote History WF Purge - ARG - 76A | 18 | DL | UOM4 | Unit of Measure - Pricing | String | UDC | 2 | 0 |

38 | F76AUI21 | Detail Lines Invoice/ShipmentNote Workfile - ARG - 00 - 00 | 18 | DL | UOM4 | Unit of Measure - Pricing | String | UDC | 2 | 0 |

76B: Brazil - Reporting System Only | ||||||||||

39 | F7611B | Nota Fiscal Detail - Brazil | 36 | FD | UOM4 | Unit of Measure - Pricing | String | UDC | 2 | 0 |

76H: Chile | ||||||||||

40 | F76H3B34 | Sales Document Line (Print Info) - CHI - 03B - 76H | 13 | PI | UOM4 | Unit of Measure - Pricing | String | UDC | 2 | 0 |

41 | F76H3B35 | Price Adjustment (Print Info) - CHI - 03B - 76H | 10 | PI | UOM4 | Unit of Measure - Pricing | String | UDC | 2 | 0 |

42 | F76H3B38 | Shipment Guide Line (Print Info) - CHI - 03B - 76H | 12 | PI | UOM4 | Unit of Measure - Pricing | String | UDC | 2 | 0 |

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

43 | FF30L501 | DFM Item Definition Master | 96 | IB | UOM4 | Unit of Measure - Pricing | 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 |