11 Understanding Field Sizes

This chapter contains the following topics:

11.1 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