| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| 1 | IDCN_ODN_TR | Prenumbered ODN for multiple print pages | 3 | LOTNO | Internal Lot Number | nvarchar | 4 | 0 | | |
| 2 | TNF12 | Relationship Between Printer and Lot Number | 4 | LOTNO | Internal Lot Number | nvarchar | 4 | 0 | | |
| 3 | TNF13 | Relationship Between User and Lot Number | 5 | LOTNO | Internal Lot Number | nvarchar | 4 | 0 | | |
| TOPCheck Write |
| 4 | OIUCW_BANK | Bank Details | 7 | LOTNO | Check Lot Number | nvarchar | 6 | 0 | | |
| 5 | OIUCW_CHECKLOT | Check Lot Details for Payments | 2 | LOTNO | Check Lot Number | nvarchar | 6 | 0 | | |
| 6 | OIUCW_LOTCONTROL | Check Lot Control Master | 2 | LOTNO | Check Lot Number | nvarchar | 6 | 0 | | |
| 7 | OIUCW_LOTDESC | Check Lot Control - Description | 2 | LOTNO | Check Lot Number | nvarchar | 6 | 0 | | |
| TOPClinical System |
| 8 | N1MEEVENT | IS-H*MED: Medication, Medication Event | 41 | LOTNO | Medication: Lot Number - OBSOLETE | nvarchar | 30 | 0 | | |
| TOPDistributor-Reseller-Management |
| 9 | /SAPHT/DRMDETL | DRM Audit Trail | 2 | LOTNO | DRM lot number | nvarchar | 10 | 0 | | |
| 10 | /SAPHT/DRMFIFINV | DRM Inventory Reconciliation FIFO Inventory | 3 | LOTNO | DRM lot number | nvarchar | 10 | 0 | | |
| 11 | /SAPHT/DRMHEAD | DRM FIFO Header | 2 | LOTNO | DRM lot number | nvarchar | 10 | 0 | | |
| 12 | /SAPHT/DRMPPDL | Price Protection Due List | 3 | LOTNO | DRM lot number | nvarchar | 10 | 0 | | |
| TOPSales and Distribution |
| 13 | IDCN_BOMA | Books for Prenumbered Documents | 3 | LOTNO | Internal Lot Number | nvarchar | 4 | 0 | | |
| 14 | IDCN_BOMAT | Books for Prenumbered Documents - Texts | 4 | LOTNO | Internal Lot Number | nvarchar | 4 | 0 | | |
| 15 | IDCN_EXCP | Errors for Prenumbered Documents | 3 | LOTNO | Internal Lot Number | nvarchar | 4 | 0 | | |
| 16 | IDCN_LOMA | Lots for Prenumbered Documents | 3 | LOTNO | Internal Lot Number | nvarchar | 4 | 0 | | |
| 17 | IDCN_LOMAT | Lots for Prenumbered Documents - Texts | 4 | LOTNO | Internal Lot Number | nvarchar | 4 | 0 | | |
