| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPDownstream |
1 | S414BIW1 | S414BIW1 * SSR DTF statistics | 14 | CHOBJ | SSR PC: Clearing house | nvarchar | 6 | 0 | | |
2 | S414BIW2 | S414BIW2 * SSR DTF statistics | 14 | CHOBJ | SSR PC: Clearing house | nvarchar | 6 | 0 | | |
TOPInventory Management |
3 | RESB | Reservation/dependent requirements | 141 | CHOBJ | Internal object number of the batch classification | nvarchar | 18 | 0 | | |
TOPService Station Retailing |
4 | OIRADBT | Document base table | 18 | CHOBJ | SSR PC: Clearing house | nvarchar | 6 | 0 | | |
5 | OIRECH | SSR PC: Clearing House table (IS-Oil SSR) | 2 | CHOBJ | SSR PC: Clearing house | nvarchar | 6 | 0 | | |
6 | OIRECHBPA | Clearing house bus. partner role assignments (IS-Oil MRN) | 2 | CHOBJ | SSR PC: Clearing house | nvarchar | 6 | 0 | | |
7 | OIRECHT | SSR PC: Clearing House Texts (IS-Oil SSR) | 3 | CHOBJ | SSR PC: Clearing house | nvarchar | 6 | 0 | | |
8 | OIRECH_APPL | SSR PC: Clearing House application data (IS-Oil SSR) | 2 | CHOBJ | SSR PC: Clearing house | nvarchar | 6 | 0 | | |
9 | OIRECH_RECON | SSR PC Reconciliation Cusotmizing by Clearing House | 2 | CHOBJ | SSR PC: Clearing house | nvarchar | 6 | 0 | | |
10 | OIREDISC | SSR PC: Clearing house discounts by cardtype/co code/CH | 2 | CHOBJ | SSR PC: Clearing house | nvarchar | 6 | 0 | | |
11 | OIRESETT_HEAD | Payment Cards: Settlement Run Log | 3 | CHOBJ | SSR PC: Clearing house | nvarchar | 6 | 0 | | |
12 | OIREUPLKXXXX | SSR PC: Template for generated DTF tables (header) | 59 | CHOBJ | SSR PC: Clearing house | nvarchar | 6 | 0 | | |
13 | OIRE_RECON_ADM | Administration data for the reconciliation files | 5 | CHOBJ | SSR PC: Clearing house | nvarchar | 6 | 0 | | |
14 | OIRE_RECON_CUS | SSR PC Reconciliation Customizing by Cl. House & Card Type | 2 | CHOBJ | SSR PC: Clearing house | nvarchar | 6 | 0 | | |
15 | OIRE_RECON_RUN | Reconciliation run results | 8 | CHOBJ | SSR PC: Clearing house | nvarchar | 6 | 0 | | |
16 | OIRHCHSTRNSMN | Clearing House Transmission-Message log(IS-OIL, SSR) | 3 | CHOBJ | SSR PC: Clearing house | nvarchar | 6 | 0 | | |
17 | Q000 | Condition Table for Acct.Determination: $ | 5 | CHOBJ | SSR PC: Clearing house | nvarchar | 6 | 0 | | |
18 | Q001 | Company/Card Type/Split Result | 7 | CHOBJ | SSR PC: Clearing house | nvarchar | 6 | 0 | | |
19 | Q002 | Company/Card Type | 6 | CHOBJ | SSR PC: Clearing house | nvarchar | 6 | 0 | | |
20 | S414 | SSR DTF statistics | 14 | CHOBJ | SSR PC: Clearing house | nvarchar | 6 | 0 | | |
21 | S414E | S414 - Structural information | 9 | CHOBJ | SSR PC: Clearing house | nvarchar | 6 | 0 | | |
TOPSimulation |
22 | VSRESB_CN | Version: Reservation/Dependent requirements | 142 | CHOBJ | Internal object number of the batch classification | nvarchar | 18 | 0 | | |
TOPWork Clearance Management |
23 | WCACM | WCM: Current Operational Condition/Type | 9 | CHOBJ | Last Changed By (Object Number) | nvarchar | 22 | 0 | | |