| 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 | | |