You are here: File Descriptions > Sales Order > SOTB - SO Tables File

# SOTB - SO Tables File

Each application has its own General Table file to hold the tables needed by its programs. The file is named xxTB, where xx is the two-character program prefix. (This is passed to the programs by the menu program in the variable T$).

See the Sales Order User's Manual for a description of the tables used by this application.

There is one record for each table.

| Template: | DIM SOTB:"TBID:C(8*), COLS:N(1*), TYPE:C(1*), HEAD:C(77*), ENT:C(504*), DESCR:C(40*), WIDTH:N(2*)"
| IOLIST: | 0999 SOTB: IOLIST TB0$, TB0, TB1$, TB2$, TB3$, TB4$, TB1
| String Sizes: | DIM TB0$(8), TB1$(1), TB2$(77), TB3$(504), TB4$(40)

Key Definitions

| Key Number | Field | Description
| 0 | [1:1:8] | Table ID
|  | __________ |
|  | 1 segments |

SO Tables File

| File Name: | SOTB | Record Size: | 640(640)
| File Type: | Mkeyed - Dynamic | Number of Keys: | 1

| Field | Field Name | Variable | Description | A/N | Length | Note
| 1 | TBID | TB0$ | Table ID | A | 8 |
| 2 | COLS | TB0 | Number of Columns | N | 1 |
| 3 | TYPE | TB1$ | Table type | A | 1 | A = Alpha
|  |  |  |  |  |  | N = Numeric
|  |  |  |  |  |  | (-########.00)
|  |  |  |  |  |  | 3 = Numeric
|  |  |  |  |  |  | (-#######.000)
|  |  |  |  |  |  | 4 = Numeric
|  |  |  |  |  |  | (-######.0000)
| 4 | HEAD | TB2$ | Column Headings | A | 77 |
| 5 | ENT | TB3$ | Table Entries | A | 504 |
| 6 | DESCR | TB4$ | Table Description | A | 40 |
| 7 | WIDTH | TB1 | Column Width | N | 2 |