| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPInterface to Terminal Automation System |
1 | OIK01 | IS-OIL/TAS: LID Document Data | 69 | SOLDTO | Sold-to party | nvarchar | 10 | 0 | | |
2 | OIK01D | IS-OIL/TAS: deactivated LID Document Data | 70 | SOLDTO | Sold-to party | nvarchar | 10 | 0 | | |
3 | OIKCF | TAS - Control Field Data | 5 | SOLDTO | Sold-to party | nvarchar | 10 | 0 | | |
4 | OIKCFW | TAS - Control Field Data | 5 | SOLDTO | Sold-to party | nvarchar | 10 | 0 | | |
5 | OIKLID | TAS active LIDs(NOTE:keep eq to DB OIKLIDW->append includes) | 36 | SOLDTO | Sold-to party | nvarchar | 10 | 0 | | |
6 | OIKLIDR | TD - TAS Reference Table | 36 | SOLDTO | Sold-to party | nvarchar | 10 | 0 | | |
7 | OIKLIDW | TAS LID Working version (NOTE: keep DB eq to DB OIKLID) | 36 | SOLDTO | Sold-to party | nvarchar | 10 | 0 | | |
TOPLease Accounting |
8 | LAE_CRM_ITEMS | LAE: Contract Items | 33 | SOLDTO | Sold-to party | nvarchar | 10 | 0 | | |
TOPMedia Product Sales and Distribution |
9 | JKSDORDERINDEX | Index Table for IS-M Orders | 6 | SOLDTO | IS-M: Sold-to Party | nvarchar | 10 | 0 | | |
10 | JKSECONTRINDEX | Index Table for IS-M Contracts | 14 | SOLDTO | IS-M: Sold-to Party | nvarchar | 10 | 0 | | |
TOPTraders and Schedulers Workbench |
11 | OIJNOMC | OIL-TSW: Nomination copy table | 71 | SOLDTO | Customer Sold-to or Vendor | nvarchar | 10 | 0 | | |
12 | OIJNOMI | Nomination Item | 71 | SOLDTO | Customer Sold-to or Vendor | nvarchar | 10 | 0 | | |
13 | OIJNOMIVERS | Nomination Item Version Table | 73 | SOLDTO | Customer Sold-to or Vendor | nvarchar | 10 | 0 | | |
14 | OIJ_EL_DOC_I_REF | Document item reference to nomination | 42 | SOLDTO | Customer Sold-to or Vendor | nvarchar | 10 | 0 | | |
15 | OIJ_SCHED | Planned Schedule Lines | 122 | SOLDTO | Customer Sold-to or Vendor | nvarchar | 10 | 0 | | |
16 | S430 | SIS: (OIL-TSW) Sales document statistics by TSW object | 41 | SOLDTO | Customer Sold-to or Vendor | nvarchar | 10 | 0 | | |
17 | S431 | PURCHIS: (OIL-TSW) Purchasing document stats by TSW object | 46 | SOLDTO | Customer Sold-to or Vendor | nvarchar | 10 | 0 | | |