| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | ZEIM_VBAP | Sales Document: Item Data | 254 | OIHANTYP | Excise Duty Handling Type | nvarchar | 2 | 0 | | |
TOPInterface to Terminal Automation System |
2 | OIK01 | IS-OIL/TAS: LID Document Data | 77 | OIHANTYP | Excise Duty Handling Type | nvarchar | 2 | 0 | | |
3 | OIK01D | IS-OIL/TAS: deactivated LID Document Data | 78 | OIHANTYP | Excise Duty Handling Type | nvarchar | 2 | 0 | | |
4 | OIKCF | TAS - Control Field Data | 13 | OIHANTYP | Excise Duty Handling Type | nvarchar | 2 | 0 | | |
5 | OIKCFW | TAS - Control Field Data | 13 | OIHANTYP | Excise Duty Handling Type | nvarchar | 2 | 0 | | |
6 | OIKLID | TAS active LIDs(NOTE:keep eq to DB OIKLIDW->append includes) | 44 | OIHANTYP | Excise Duty Handling Type | nvarchar | 2 | 0 | | |
7 | OIKLIDR | TD - TAS Reference Table | 44 | OIHANTYP | Excise Duty Handling Type | nvarchar | 2 | 0 | | |
8 | OIKLIDW | TAS LID Working version (NOTE: keep DB eq to DB OIKLID) | 44 | OIHANTYP | Excise Duty Handling Type | nvarchar | 2 | 0 | | |
TOPInventory Management |
9 | MSEG | Document Segment: Material | 279 | OIHANTYP | Excise Duty Handling Type | nvarchar | 2 | 0 | | |
TOPProduction Orders |
10 | AFKO | Order Header Data PP Orders | 161 | OIHANTYP | Excise Duty Handling Type | nvarchar | 2 | 0 | | |
11 | T399X | Parameters dependent on order type | 81 | OIHANTYP | Excise Duty Handling Type | nvarchar | 2 | 0 | | |
TOPPurchasing |
12 | EKPO | Purchasing Document Item | 284 | OIHANTYP | Excise Duty Handling Type | nvarchar | 2 | 0 | | |
TOPSales |
13 | VBAP | Sales Document: Item Data | 261 | OIHANTYP | Excise Duty Handling Type | nvarchar | 2 | 0 | | |
TOPSimulation |
14 | VSAFKO_CN | Version: Order header data for PP orders | 164 | OIHANTYP | Excise Duty Handling Type | nvarchar | 2 | 0 | | |
TOPTariffs, Duties and Permits |
15 | A419 | ED pricing/Origin/Tax Group/Handl.Type/Orig.reg. | 7 | OIHANTYP | Excise Duty Handling Type | nvarchar | 2 | 0 | | |
16 | A443 | Red Rate Exc Duty Comp/Plant/Tax Group/Handling Type | 7 | OIHANTYP | Excise Duty Handling Type | nvarchar | 2 | 0 | | |
17 | OIH09 | Excise duty defaults for Stock Transfers | 5 | OIHANTYP | Excise Duty Handling Type | nvarchar | 2 | 0 | | |
18 | OIH40 | Excise Duty defaulting table GI/GR for production orders | 7 | OIHANTYP | Excise Duty Handling Type | nvarchar | 2 | 0 | | |
19 | OIHEDO | Object table 1, IS-OIL Excise Duty Special Ledger | 12 | OIHANTYP | Excise Duty Handling Type | nvarchar | 2 | 0 | | |
20 | OIHSLO | TDP (excise duty) special ledger object table | 11 | OIHANTYP | Excise Duty Handling Type | nvarchar | 2 | 0 | | |
21 | OIH_MIGO_HTDP | Store the TDP-GOITEM for MIGOs hold/restore feature | 10 | OIHANTYP | Excise Duty Handling Type | nvarchar | 2 | 0 | | |
22 | OIH_TAX_REV | Excise Duty Revaluation Documents | 29 | OIHANTYP | Excise Duty Handling Type | nvarchar | 2 | 0 | | |
TOPTraders and Schedulers Workbench |
23 | OIJNOMI | Nomination Item | 117 | OIHANTYP | Excise Duty Handling Type | nvarchar | 2 | 0 | | |
TOPTransportation and Distribution |
24 | TOIGS3 | TD Intransit Batch/Handling Type Determination | 8 | OIHANTYP | TD handling type bulk shipment load | nvarchar | 2 | 0 | | |