SERVICES Codes Data ColumnsΒΆ
| REQ | SM | COLUMN NAME | TYPE | UC | VALIDATE | DEFAULT | JUST | NOTE |
|---|---|---|---|---|---|---|---|---|
| – – – – – – – – – – – – Keys | ||||||||
| M | S | SERVICE | A | U | L8 | |||
| – – – – – – – – – – – – Configuration Entries | ||||||||
| O | S | DESCRIPTION | A | T40 | ||||
| M | S | APPLY | LC | U | Rate Application Codes | O | L2 | |
| O | M | ACTIVITY | A | U | Transaction Activity Codes | L15 | ||
| – – – – – – – – – – – – Accounting Entries | ||||||||
| M | S | CATEGORY | LC | U | Charge Category Codes | L2 | ||
| O | S | LEDGER | A | L12 | ||||
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.