Field Sizes
The JD Edwards EnterpriseOne system maintains a list of field names and corresponding alias examples that represent commonly used data types that appear in a form. The Bs represent the number of characters that alphabetical fields can contain. For example, the field MCU (Cost Center) enables you to enter ABCDEFGHIJKL. The number of 8s represents the same thing for numeric fields. For example, the field ICU (Batch Number) enables you to enter 12345678.
The size column that precedes the B column refers to the size that the field should be in design so that you have enough room to enter and display the data correctly. For example, 133 is the correct size for the Cost Center Details field.
This table provides guidelines for placing and sizing controls:
Category |
Alias |
Description |
Application Field Location |
B's |
8's |
|---|---|---|---|---|---|
Branch/Plant |
*MCU* |
Any branch/plant field |
Top-right corner |
12 |
|
Address Number |
AN8 |
Any Address Number field, including internal and external numbers |
88 |
8 |
|
Date |
DATE |
Any date field |
88/88/8888 |
||
Time |
TIME |
Any time field |
88:88:88 |
||
UDC |
UDC |
1 - Character |
1 |
||
UDC |
UDC |
10 - Character |
10 |
||
UDC |
UDC |
2 - Character |
2 |
||
UDC |
UDC |
3 - Character |
3 |
||
UDC |
UDC |
4 - Character |
4 |
||
UDC |
UDC |
8 - Character |
8 |
||
Amount |
AEXP |
Extended Cost |
After Unit Cost |
15 |
|
Company |
CO |
Company |
5 |
||
Amount |
CRR |
Currency Exchange Rate |
15 |
||
Document |
DOC* |
Document Number |
8 |
||
Document |
DCT* |
Document Type |
After Doc Number/No desc. |
2 |
|
Document |
KCO* |
Key Company |
After Doc Type/No desc. |
5 |
|
Location |
LOCN |
Location |
20 |
||
Location |
LOTN |
Lot Number |
After LOCN |
30 |
|
Location |
TKID |
Bulk - Tank ID |
8 |
||
Quantity |
TRQT |
Quantity |
15 |
||
Item Number |
UITM |
Item Number - Unknown |
Left with desc. after |
26 |
|
Amount |
UNCS |
Unit Cost |
Before Extended Amount |
15 |
|
Density |
DEND |
Density |
After TEMP |
8 |
|
Density Type |
DNTP |
Density Type |
After DEND/No desc. |
1 |
|
Pressure |
VAPP |
Vapor Pressure |
After DETP |
15 |
|
Unit of Measure |
PREU |
Pressure UOM |
After VAPP/No desc. |
2 |
|
Temperature |
DETP |
Density Temperature |
After DEND |
8 |
|
Temperature Type |
DTPU |
Density Temperature Type |
After DETP/No desc. |
1 |
|
Temperature |
LPGV |
LPG Vapor Temperature |
After VAPP |
8 |
|
Temperature Type |
TPU1 |
Temperature Type |
After LPGV/No desc. |
1 |
|
Temperature |
TEMP |
Temperature |
8 |
||
Temperature Type |
STPU |
Temperature Type |
After TEMP/No desc. |
1 |
|
Volume |
LIQV |
Liquid Volume |
15 |
||
Unit of Measure |
BUMx |
UOM |
After Vol/ No desc. |
2 |
|
Correction Factor |
VCF |
Volume Correction Factor |
7 |
||
Weight |
LIQW |
Liquid Weight |
15 |
||
Volume |
AMBR |
Ambient Volume |
15 |
||
Volume |
VAPV |
Vapor Volume |
15 |
||
Volume |
OVOL |
Other Volume |
15 |
||
Quantity |
STUM |
Stock Total |
Not normally on a form |
15 |
|
Quantity |
STOK |
Stock Volume |
After AMBR |
15 |
|
Weight |
WGTR |
Weight Result |
After STOK |
15 |
|
Line Number |
JELN |
Journal Entry Line Number |
7 |
||
Batch Number |
ICU |
Batch Number |
8 |
||
User ID |
USER |
User ID |
10 |
||
Program ID |
PID |
Program ID |
10 |