| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPGoods Receipt Process |
1 | BORGR_EVENTS | Table for Dialog Sychronization Two-Step GR Automotive | 1 | EVENT_NR | Number of an Event for Dialog Synchronization | int | 10 | 0 | | |
TOPRemaining Beverage - Obsolete Objects |
2 | /BEV3/CH1030BKPF | Header Data for CH Event Ledger 00001030 | 3 | EVENT_NR | CH BTE Sequence Number of Event Receipt | nvarchar | 16 | 0 | | |
3 | /BEV3/CH1030BSG1 | Document Segment CH Event Ledger Part1 | 3 | EVENT_NR | CH BTE Sequence Number of Event Receipt | nvarchar | 16 | 0 | | |
4 | /BEV3/CH1030BSG2 | Document Segment CH Event Ledger Part2 | 3 | EVENT_NR | CH BTE Sequence Number of Event Receipt | nvarchar | 16 | 0 | | |
5 | /BEV3/CH1030PROT | Logging Assignment Trigger (Document) - Event Number | 3 | EVENT_NR | CH BTE Sequence Number of Event Receipt | nvarchar | 16 | 0 | | |
6 | /BEV3/CHABRSTZ_P | CH Settlement Items - With Translations | 105 | EVENT_NR | CH BTE Sequence Number of Event Receipt | nvarchar | 16 | 0 | | |
7 | /BEV3/CHBDMDHST | History of Condit. Modifications from Temp. Settlement Items | 106 | EVENT_NR | CH BTE Sequence Number of Event Receipt | nvarchar | 16 | 0 | | |
8 | /BEV3/CHERGSTZ_P | CH Settlement Items - With Translations | 105 | EVENT_NR | CH BTE Sequence Number of Event Receipt | nvarchar | 16 | 0 | | |
9 | /BEV3/CHERGSTZ_S | CH Settlement Statistics | 106 | EVENT_NR | CH BTE Sequence Number of Event Receipt | nvarchar | 16 | 0 | | |
10 | /BEV3/CHEVENTDEC | To Delete Event Addressee, BTEs used in CH with EvLiCl | 2 | EVENT_NR | CH BTE Sequence Number of Event Receipt | nvarchar | 16 | 0 | | |
11 | /BEV3/CHEVENTDEL | To Delete Event Addressee, BTEs used in CH without EvLiCl | 2 | EVENT_NR | CH BTE Sequence Number of Event Receipt | nvarchar | 16 | 0 | | |
12 | /BEV3/CHEVENTRCP | Processed Event Recipient of BTEs Used by CH | 2 | EVENT_NR | CH BTE Sequence Number of Event Receipt | nvarchar | 16 | 0 | | |
13 | /BEV3/CHEVENTREC | Event Recipient of BTEs Used by CH | 2 | EVENT_NR | CH BTE Sequence Number of Event Receipt | nvarchar | 16 | 0 | | |
14 | /BEV3/CHEVENTREL | Reserved Event Recipient of BTEs Used by CH with EVLICL | 2 | EVENT_NR | CH BTE Sequence Number of Event Receipt | nvarchar | 16 | 0 | | |
15 | /BEV3/CHEVENTRES | Reserved Event Recipient of BTEs Used by CH without EVLICL | 2 | EVENT_NR | CH BTE Sequence Number of Event Receipt | nvarchar | 16 | 0 | | |
16 | /BEV3/CHEVLASFPR | CH BTE Event Listener ASSESSMENT FI Processed | 2 | EVENT_NR | CH BTE Sequence Number of Event Receipt | nvarchar | 16 | 0 | | |
17 | /BEV3/CHEVLIACBP | CH BTE Event Listener ACCOUNT Before Processed | 6 | EVENT_NR | CH BTE Sequence Number of Event Receipt | nvarchar | 16 | 0 | | |
18 | /BEV3/CHEVLIACEL | CH BTE Event Listener ACCOUNT | 6 | EVENT_NR | CH BTE Sequence Number of Event Receipt | nvarchar | 16 | 0 | | |
19 | /BEV3/CHEVLIACFL | CH BTE Event Listener ACCOUNT Fault | 2 | EVENT_NR | CH BTE Sequence Number of Event Receipt | nvarchar | 16 | 0 | | |
20 | /BEV3/CHEVLIACNT | CH BTE Event Listener ACCOUNT Date | 6 | EVENT_NR | CH BTE Sequence Number of Event Receipt | nvarchar | 16 | 0 | | |
21 | /BEV3/CHEVLIACPR | CH BTE Event Listener ACCOUNT Processed | 2 | EVENT_NR | CH BTE Sequence Number of Event Receipt | nvarchar | 16 | 0 | | |
22 | /BEV3/CHEVLIASFB | CH BTE Event Listener Assessment FI Before Processed | 2 | EVENT_NR | CH BTE Sequence Number of Event Receipt | nvarchar | 16 | 0 | | |
23 | /BEV3/CHEVLIASFI | CH BTE Event Listener Assessment FI | 2 | EVENT_NR | CH BTE Sequence Number of Event Receipt | nvarchar | 16 | 0 | | |
24 | /BEV3/CHEVLI_VV | CH BTE Event Listener Default / Contract Handling | 2 | EVENT_NR | CH BTE Sequence Number of Event Receipt | nvarchar | 16 | 0 | | |
25 | /BEV3/CHEXCSTZ_P | CH Settlement Items/Non-Posted Docs w/o Date Statistics | 105 | EVENT_NR | CH BTE Sequence Number of Event Receipt | nvarchar | 16 | 0 | | |
26 | /BEV3/CHRESSTZ_P | CH Settlement Items - Reset Documents (2/Transaction) | 105 | EVENT_NR | CH BTE Sequence Number of Event Receipt | nvarchar | 16 | 0 | | |
27 | /BEV3/CHSHTSTZ_P | CH Settlement Item | 105 | EVENT_NR | CH BTE Sequence Number of Event Receipt | nvarchar | 16 | 0 | | |
28 | /BEV3/CHSIMBDMDH | CH simulation history of modifications caused by conditions | 106 | EVENT_NR | CH BTE Sequence Number of Event Receipt | nvarchar | 16 | 0 | | |
29 | /BEV3/CHSIMSTZ_P | CH Simulation Items | 105 | EVENT_NR | CH BTE Sequence Number of Event Receipt | nvarchar | 16 | 0 | | |
30 | /BEV3/CHSIMSTZ_S | CH Simulation Statistics | 106 | EVENT_NR | CH BTE Sequence Number of Event Receipt | nvarchar | 16 | 0 | | |
31 | /BEV3/CHTM1030 | Date Transaction / BTE 1030 | 7 | EVENT_NR | CH BTE Sequence Number of Event Receipt | nvarchar | 16 | 0 | | |
32 | /BEV3/CHTMP0200 | Link Type 0200 Temporary Data from Settlement | 8 | EVENT_NR | CH BTE Sequence Number of Event Receipt | nvarchar | 16 | 0 | | |
33 | /BEV3/CHTMPMDHST | Temp. history of cond. modifications from temp. settle. item | 106 | EVENT_NR | CH BTE Sequence Number of Event Receipt | nvarchar | 16 | 0 | | |
34 | /BEV3/CHTRMSTZ_P | CH Date Item | 105 | EVENT_NR | CH BTE Sequence Number of Event Receipt | nvarchar | 16 | 0 | | |
35 | /BEV3/CHTRMSTZ_S | CH Date Statistics | 106 | EVENT_NR | CH BTE Sequence Number of Event Receipt | nvarchar | 16 | 0 | | |
36 | /BEV3/CHVABRSTZS | CH Settlement Statistics | 106 | EVENT_NR | CH BTE Sequence Number of Event Receipt | nvarchar | 16 | 0 | | |
TOPTraders and Schedulers Workbench |
37 | OIJEC | TD-Transport Unit Master Data Events | 4 | EVENT_NR | Master Data Event number | nvarchar | 8 | 0 | | |
38 | OIJEV | TD-Vehicle ~ Berth Master Data Events | 4 | EVENT_NR | Master Data Event number | nvarchar | 8 | 0 | | |
39 | OIJNE | Nomination Events | 4 | EVENT_NR | TD - event number | nvarchar | 4 | 0 | | |
40 | OIJSUBITEMEVENTS | Nomination Sub Item Events | 5 | EVENT_NR | TD - event number | nvarchar | 4 | 0 | | |
41 | OIJTE | TSW Ticket Events | 6 | EVENT_NR | TD - event number | nvarchar | 4 | 0 | | |
42 | OIJ_TKT_TMST_PR | Ticket Timestamp Transfer Control Table | 5 | EVENT_NR | TD - event number | nvarchar | 4 | 0 | | |
TOPTransportation and Distribution |
43 | OIGSE | TD Events | 3 | EVENT_NR | TD - event number | nvarchar | 4 | 0 | | |