| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | IDCN_ODN_TR | Prenumbered ODN for multiple print pages | 5 | INVNO | Official Document Number | nvarchar | 8 | 0 | | |
TOPDistributor-Reseller-Management |
2 | /SAPHT/DRMDETL | DRM Audit Trail | 17 | INVNO | Inventory record number | nvarchar | 10 | 0 | | |
3 | /SAPHT/DRMFIFINV | DRM Inventory Reconciliation FIFO Inventory | 2 | INVNO | Inventory record number | nvarchar | 10 | 0 | | |
4 | /SAPHT/DRMINVSUM | DRM Inventory Summary | 2 | INVNO | Inventory record number | nvarchar | 10 | 0 | | |
5 | /SAPHT/DRMREPINV | DRM Inventory Reconciliation Reported Inventory | 2 | INVNO | Inventory record number | nvarchar | 10 | 0 | | |
TOPExcise Duty |
6 | /BEV2/CS_HD | EMCS Process: Header Data | 20 | INVNO | EMCS: Invoice Number | nvarchar | 40 | 0 | | |
7 | /BEV2/CS_HD_H | EMCS Process: Header Data - History | 21 | INVNO | EMCS: Invoice Number | nvarchar | 40 | 0 | | |
TOPFinancials Basis |
8 | UBC_TB_INVH | Bill (Header) | 5 | INVNO | Biller's Bill Number | nvarchar | 16 | 0 | | |
TOPGlobal Trade Services |
9 | /SAPSLL/CUSWLA | Worklist for Quantity Comparison Goods Issue/Customs Doc. | 20 | INVNO | Number of Originating Feeder System Document | nvarchar | 40 | 0 | | |
10 | /SAPSLL/CUSWLB | Customs Worklist: Qty Adjustment - Completed Transactions | 24 | INVNO | Number of Originating Feeder System Document | nvarchar | 40 | 0 | | |
TOPLocalization |
11 | VIXCCORRVIIR | Invoice Item Reference for Corr/Rev Invoices | 14 | INVNO | Number of Correction/Reversal Invoice | nvarchar | 10 | 0 | | |
12 | VIXCPTSIPT | Digital Signature for Invoices | 4 | INVNO | Invoice Number | nvarchar | 10 | 0 | | |
TOPRental Accounting |
13 | VIRAINV | RE Invoice Header | 4 | INVNO | Invoice Number | nvarchar | 10 | 0 | | |
TOPSales and Distribution |
14 | IDCN_EXCP | Errors for Prenumbered Documents | 5 | INVNO | Official Document Number | nvarchar | 8 | 0 | | |