| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPGeneral |
1 | OBVL | Serial Numbers and Batch Valuation Log | 7 | AccumType | Accumulator Type | Int | 11 | 0 | 0 | 0=ACCUM_EMPTY, 1=ACCUM_ON_HAND, 2=ACCUM_COMMITTED, 3=ACCUM_ON_ORDER, 4=ACCUM_CONSIGNATION, 5=ACCUM_COUNTED |
2 | UBVL | Serial Numbers and Batch Valuation Log | 7 | AccumType | Accumulator Type | Int | 11 | 0 | 0 | 0=ACCUM_EMPTY, 1=ACCUM_ON_HAND, 2=ACCUM_COMMITTED, 3=ACCUM_ON_ORDER, 4=ACCUM_CONSIGNATION, 5=ACCUM_COUNTED |
TOPInventory and Production |
3 | OAIM | Archive Inventory Message | 14 | AccumType | Accumulator Type | Int | 11 | 0 | 0 | 0=ACCUM_EMPTY, 1=ACCUM_ON_HAND, 2=ACCUM_COMMITTED, 3=ACCUM_ON_ORDER, 4=ACCUM_CONSIGNATION, 5=ACCUM_COUNTED |
4 | OILM | Inventory Log Message | 16 | AccumType | Accumulator Type | Int | 11 | 0 | 0 | 0=ACCUM_EMPTY, 1=ACCUM_ON_HAND, 2=ACCUM_COMMITTED, 3=ACCUM_ON_ORDER, 4=ACCUM_CONSIGNATION, 5=ACCUM_COUNTED |
5 | UILM | IVI Inventory Log Message | 16 | AccumType | Accumulator Type | Int | 11 | 0 | 0 | 0=ACCUM_EMPTY, 1=ACCUM_ON_HAND, 2=ACCUM_COMMITTED, 3=ACCUM_ON_ORDER, 4=ACCUM_CONSIGNATION, 5=ACCUM_COUNTED |