| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | DIAN_A_XRUN | DIAN Extraction Runs | 6 | CREATIME | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | | |
2 | ISM_PT_JFRK | Portugal: Digital Signature for Billing Document | 17 | CREATIME | Signature PT: Creation Time | nvarchar | 6 | 0 | | |
3 | ISM_PT_JHTFK | Portugal: Digital Signature for M/AM Billing Document | 17 | CREATIME | Signature PT: Creation Time | nvarchar | 6 | 0 | | |
4 | SIPT_LIKP | Portugal: Digital Signature for Delivery Document | 18 | CREATIME | Signature PT: Creation Time | nvarchar | 6 | 0 | | |
5 | TBTCY | Table for Jobs in Status "Ready" | 22 | CREATIME | Planned start time for background Job | nvarchar | 6 | 0 | | |
6 | TOAAT | Table to store the File attributes | 6 | CREATIME | TIME Data Element for SYST | nvarchar | 6 | 0 | | |
TOPAlert Framework |
7 | SALRT | Alert: Instance Table | 4 | CREATIME | Time Stamp for Triggering an Alert | decimal | 15 | 0 | | |
TOPBackground Processing |
8 | FAVSELS | User-Specific Favorite Selection Criteria | 4 | CREATIME | System Time | nvarchar | 6 | 0 | | |
TOPCanada |
9 | PCERH | History of Payroll Posting Runs | 11 | CREATIME | Created at | nvarchar | 6 | 0 | | |
10 | T5KR0 | Record of Employment (ROE) History | 17 | CREATIME | Created at | nvarchar | 6 | 0 | | |
TOPCollectionsDisbursements |
11 | IBROSTMACT | ISCD: Broker Report - Activities Executed for Item | 9 | CREATIME | Time at which the object was created | nvarchar | 6 | 0 | | |
12 | IBROSTMH | ISCD: Broker Report - Header Data | 44 | CREATIME | Time at which the object was created | nvarchar | 6 | 0 | | |
13 | ITAGCYCOINSADD | Agency Collections: Addtl Specification Coinsurance Shares | 4 | CREATIME | Time | nvarchar | 6 | 0 | | |
TOPData Transfer |
14 | PEVSH | History of Payroll Posting Runs | 9 | CREATIME | Created at | nvarchar | 6 | 0 | | |
15 | PPDSH | Payroll Posting Document: Status History | 9 | CREATIME | Created at | nvarchar | 6 | 0 | | |
TOPDB2 Universal Database for UNIX NT |
16 | DB6GSDTBS | DB6: Cumulated Table-Specific Snapshot Data | 5 | CREATIME | DB6: Timestamp (Format: YYYYMMDDHHMMSS) | nvarchar | 14 | 0 | | |
17 | DB6HISTBS | DB6: Cumulated Table-Specific Snapshot Data | 5 | CREATIME | DB6: Timestamp (Format: YYYYMMDDHHMMSS) | nvarchar | 14 | 0 | | |
TOPInterface to Terminal Automation System |
18 | OIKLID | TAS active LIDs(NOTE:keep eq to DB OIKLIDW->append includes) | 32 | CREATIME | Calendar: Creation or change time | nvarchar | 6 | 0 | | |
19 | OIKLIDW | TAS LID Working version (NOTE: keep DB eq to DB OIKLID) | 32 | CREATIME | Calendar: Creation or change time | nvarchar | 6 | 0 | | |
20 | OIKLOG01 | Log Table for Shipment planning | 8 | CREATIME | Calendar: Creation or change time | nvarchar | 6 | 0 | | |
TOPLocalization |
21 | ISJPINVSUMHD | Invoice Summary Header | 27 | CREATIME | Creation Time | nvarchar | 6 | 0 | | |
22 | ISJPINVSUMIT | Line items for invoice summary | 22 | CREATIME | Creation Time | nvarchar | 6 | 0 | | |
23 | ISJPVIRTACCT | Virtual accounts | 7 | CREATIME | Creation Time | nvarchar | 6 | 0 | | |
24 | SIPT_BKPF | Portugal: Digital Signature for Accounting Documents | 19 | CREATIME | Signature PT: Creation Time | nvarchar | 6 | 0 | | |
25 | SIPT_RBKP | Portugal: Digital Signature for Self Billing Document | 21 | CREATIME | Signature PT: Creation Time | nvarchar | 6 | 0 | | |
26 | SIPT_VBRK | Portugal: Digital Signature for Billing Document | 17 | CREATIME | Signature PT: Creation Time | nvarchar | 6 | 0 | | |
27 | VIXCPTSIPT | Digital Signature for Invoices | 20 | CREATIME | Signature PT: Creation Time | nvarchar | 6 | 0 | | |
TOPPrint and Output Management |
28 | TSP02F | List of frontend printing to be executed | 6 | CREATIME | System log time stamp | nvarchar | 16 | 0 | | |
29 | TSP02FX | List of Front-End Printing to Be Printed (Replaces TSP02F) | 6 | CREATIME | System log time stamp | nvarchar | 16 | 0 | | |
TOPProcess Monitoring Infrastructure |
30 | SSPICSPRHD | SPI: Assembled Process Instances | 4 | CREATIME | SPI: Inbound Time Stamp Central Store | decimal | 21 | 7 | | |
31 | SSPICSPRST | SPI: Steps of Assembled Process Instances | 9 | CREATIME | SPI: Inbound Time Stamp Central Store | decimal | 21 | 7 | | |
TOPReporting |
32 | T5KR4 | Record of Employment (ROE) History for Concurrent Employment | 16 | CREATIME | Created at | nvarchar | 6 | 0 | | |
TOPRuntime WorkbenchMonitoring |
33 | SXIPMIDEST | PMI Component and Destination for XI Component | 13 | CREATIME | System Time | nvarchar | 6 | 0 | | |
34 | SXIPMIPROCID | XI Process Type of PMI Monitoring | 6 | CREATIME | System Time | nvarchar | 6 | 0 | | |
TOPSAP Business Workflow |
35 | SWFDEXPVER | Test and Verification of Expression Package SWF_EXP | 26 | CREATIME | System Time | nvarchar | 6 | 0 | | |
TOPSAP Records Management |
36 | SRMWFPATH | Workflow Process Route | 8 | CREATIME | Time Process Route Created | nvarchar | 6 | 0 | | |
37 | SRMWFPTHPS | Process Route Item for Workflow | 13 | CREATIME | Time Process Route Item Created | nvarchar | 6 | 0 | | |
TOPThird Party Remittance |
38 | T51R5_HIST | Remittance accumulated posting data history | 12 | CREATIME | Created at | nvarchar | 6 | 0 | | |
TOPTranslation Tools |
39 | TPM_DIR | Translation performance monitor header | 5 | CREATIME | Time Created | nvarchar | 6 | 0 | | |