OE – Lawson tables and programs
OE in Lawson S3 v10 MSP6 has 18 tables, 0 online screens and 0 batch programs. The source library does not name this system; the folder code is used.
Tables (18)
| Table | Prefix | Description | Primary key | Fields |
|---|---|---|---|---|
| COLINE | COL | Customer Order Line | COMPANY, ORDER-NBR, LINE-NBR | 168 |
| COLINEUOM | COU | Order Line Pricing UOM's | COMPANY, ORDER-NBR, LINE-NBR | 39 |
| COMISC | CMC | Customer Order Miscellaneous | COMPANY, ORDER-NBR, LINE-NBR, SEQ | 65 |
| COSGBLK | OSG | No description in the Lawson data dictionary | COMPANY, ORDER-NBR, LINE-NBR, SEQ | 5 |
| CUSTORDER | COR | Customer Order File | COMPANY, ORDER-NBR | 205 |
| OEAUDIT | OEA | Order Entry Audit | COMPANY, ORDER-NBR, LINE-NBR, FLD-NBR, UPDATE-DATE, UPDATE-TIME | 11 |
| OECOLUF | OLU | The Order Line User Fields file contains user fields that can be entered on order lines. | COMPANY, ORDER-NBR, LINE-NBR | 8 |
| OECORUF | OCU | The Order User Fields file contains user fields that can be entered on orders. | COMPANY, ORDER-NBR | 7 |
| OEOPEUF | OOU | Operator User Field | DEF-COMPANY, OPR-CODE | 7 |
| OEORDCMNT | OOC | Customer Order Comments | COMPANY, CUSTOMER, STD-ORDER-NBR, ORDER-NBR, LINE-NBR, SEQ | 10 |
| OEROUTE | ORT | Order Entry Route | COMPANY, LOCATION, DAY-OF-WEEK, ROUTE, STOP | 7 |
| OESOURCE | OSR | Order Entry Order Source | COMPANY, ORDER-SOURCE | 5 |
| OEUSRFLDEF | OUD | The User Field Definition file defines user field types and user field data types. | USER-FLD-TYPE, COMPANY | 7 |
| OPERATOR | OPE | Operator | OPR-CODE, DEF-COMPANY | 14 |
| ORDERTYPE | OTP | Order Type | COMPANY, ORDER-TYPE | 16 |
| RETURNHDR | RTN | Return Header | COMPANY, AUTH-NO | 44 |
| RETURNLINE | RTL | Return Line | COMPANY, AUTH-NO, LINE-NBR | 59 |
| RETURNMISC | RMC | OE Returns | COMPANY, AUTH-NO, LINE-NBR, SEQ | 31 |