LOCATIONS Data Table ColumnsΒΆ
| REQ | SM | COLUMN NAME | TYPE | UC | VALIDATE | DEFAULT | JUST | NOTE |
|---|---|---|---|---|---|---|---|---|
| – – – – – – – – – – – – Keys | ||||||||
| M | S | BUILDING | A | U | VT=ADDRESSES*B | L8 | ||
| M | S | LOCATIONCODE | A | U | L12 | |||
| – – – – – – – – – – – – Dimensional Entries | ||||||||
| M | S | PLAN | N.0 | U | (MD0) | R4 | ||
| M | S | STACK | N.0 | U | (MD0) | R4 | ||
| M | S | VARIANCE | N.0 | U | (MD0) | R4 | ||
| O | S | SPACE | N.0 | (MD0) | R4 | |||
| – – – – – – – – – – – – Descriptive Entries | ||||||||
| O | T | ZONE | LC | U | Storage Zone | L4 | ||
| O | S | ACCESS | LC | U | Location Access Code | L4 | ||
| O | T | ABC | LC | U | Product Turnover Rate | L4 | ||
| O | S | MIX | LC | U | Unit / Location Mixing | L4 | ||
LEGEND:
| REQ | O = optional
M = mandatory
P = pair required
C = conditional
|
| SM | S = single valued
M = multiple values
A = associated (array member)
|
| COLUMN NAME | (not case specific) |
| TYPE | A = alpha
N.n = numeric with decimals
B = boolean
D = datetime
U = UUID
LC = list of codes
SK = key sequence
S = sequence
|
| U | Key values and codes are uppercase |
| VALIDATE | links refer to code validation lists
Tablenames (uppercase) refer to verifiles
(‘values’) list allowed entries
|
| DEFAULT | a value default |
| JUST | Justify (L)eft, (C)enter, (R)ight, (T)ext
n = characters to show
|
Note
- Entries of type list code (TYPE=LC) are validated against the associated linked code option list.
- Entries with a paired requirement (REQ=P) are required when the associated paired entry or code is specified.