| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
---|
TOPF31: Lean Transactions |
1 | FF31011 | TransactionID Master File | 4 | EH | MTID | Master Transaction ID | Numeric | Generic Edit | 15 | 0 |
2 | FF31011S | Purge - TransactionID Master File | 4 | ER | MTID | Master Transaction ID | Numeric | Generic Edit | 15 | 0 |
3 | FF31111 | Lean Transaction Parts List | 2 | PL | MTID | Master Transaction ID | Numeric | Generic Edit | 15 | 0 |
4 | FF311114 | Related Purchase Orders for Lean Pay on Consumption Issues | 2 | PC | MTID | Master Transaction ID | Numeric | Generic Edit | 15 | 0 |
5 | FF31111S | Purge - Lean Transaction Parts List | 2 | PR | MTID | Master Transaction ID | Numeric | Generic Edit | 15 | 0 |
6 | FF31112 | Routing Transaction Table | 4 | EH | MTID | Master Transaction ID | Numeric | Generic Edit | 15 | 0 |
7 | FF31112S | Purge - Routing Transaction Table | 4 | ET | MTID | Master Transaction ID | Numeric | Generic Edit | 15 | 0 |
8 | FF31113 | Lean Transaction Labor Detail | 5 | LD | MTID | Master Transaction ID | Numeric | Generic Edit | 15 | 0 |
9 | FF31113S | Purge - Lean Transaction Labor Detail | 5 | LR | MTID | Master Transaction ID | Numeric | Generic Edit | 15 | 0 |