| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /OPT/AT_APPR_HIS | Approval History for Level Based Approvals | 4 | ITEMID | Document Item Id | nvarchar | 5 | 0 | | |
2 | /OPT/AT_LBA_LOG | Approval History for Level Based Approvals | 4 | ITEMID | Document Item Id | nvarchar | 5 | 0 | | |
3 | /OPT/VIM_1ITEM_S | Document Item | 3 | ITEMID | Document Item Id | nvarchar | 5 | 0 | | |
4 | /OPT/VIM_1PROC | Workflow Information for VIM Processes | 5 | ITEMID | Document Item in Invoice Document | nvarchar | 6 | 0 | | |
5 | /OPT/VIM_CUSTOMS | Customs data for imported goods | 3 | ITEMID | Document Item Id | nvarchar | 5 | 0 | | |
6 | /OPT/VIM_TITEM | Document Item | 3 | ITEMID | Document Item Id | nvarchar | 5 | 0 | | |
7 | /ORS/PS_ITEM | Profitability Segment Fields and Values | 3 | ITEMID | Document Item Id | nvarchar | 5 | 0 | | |
8 | PPHMRPLOGITEM | MRP Live Log Item | 3 | ITEMID | Natural Number | int | 10 | 0 | | |
9 | PPHMRPPPLOGITEM | MRP Live Postprocessing Log Item | 3 | ITEMID | Natural Number | int | 10 | 0 | | |
10 | YVIM_1ITEM | Document Item | 3 | ITEMID | Document Item Id | nvarchar | 5 | 0 | | |
TOPCollectionsDisbursements |
11 | VVSCPOSICDR | Payment Plan Item: Data for ICDR Service | 7 | ITEMID | Item ID of an InsuranceCollectionDisbursementRequest | nvarchar | 15 | 0 | | |
TOPEnd User Technology |
12 | RSZW30ITEMSREUSE | Conversion of Chart Settings from BW 3.0 to BW 3.5 | 1 | ITEMID | Technical Name of an Item | nvarchar | 30 | 0 | | |
13 | RSZWITEM | Header Table for BW Web Items | 1 | ITEMID | Technical Name of an Item | nvarchar | 30 | 0 | | |
14 | RSZWITEMATTR | Attribute Table of the Items (Contains Search Attributes) | 1 | ITEMID | Technical Name of an Item | nvarchar | 30 | 0 | | |
15 | RSZWITEMDATA | BW Web Item Data (7.0)+ | 1 | ITEMID | Technical Name of an Item | nvarchar | 30 | 0 | | |
16 | RSZW_WBITEMS | Table of Deleted BDS Items and Views | 4 | ITEMID | Short description | nvarchar | 20 | 0 | | |
TOPFinancial Accounting |
17 | /OPT/VIM_1ITEM | Document Item | 3 | ITEMID | Document Item Id | nvarchar | 5 | 0 | | |
TOPLease Accounting |
18 | /LSIERP/TRIG_NA | Leases Not Set to Non-Accrual | 2 | ITEMID | GUID of Item of CRM Contract | varbinary | 16 | 0 | | |
19 | FILA_MIG_SYNC | Synchronization of CRM and LAE Legacy Data | 6 | ITEMID | GUID of Item of CRM Contract | varbinary | 16 | 0 | | |
20 | LAE_BILLING_DAT | Payment Schedule | 4 | ITEMID | Object Number | varbinary | 16 | 0 | | |
21 | LAE_CRM_LNK | Link between LAE and CRM Contract Items | 3 | ITEMID | GUID of Item of CRM Contract | varbinary | 16 | 0 | | |
TOPNetwork Operations |
22 | GHO_NETVER_ITM | Items of a Production Network Version | 4 | ITEMID | GHO Production Network Version Item Identification | nvarchar | 8 | 0 | | |
TOPPerformance Assessment Workbench |
23 | SLS_CRITEM | PAW - Comments for an item from a participant | 3 | ITEMID | PAW identifier | nvarchar | 8 | 0 | | |
24 | SLS_IESS1 | PAW - Item Essay 1 | 2 | ITEMID | PAW identifier | nvarchar | 8 | 0 | | |
25 | SLS_IESS2 | PAW - Item Essay 2 | 2 | ITEMID | PAW identifier | nvarchar | 8 | 0 | | |
26 | SLS_IEVAL | PAW - Item Evaluation | 2 | ITEMID | PAW identifier | nvarchar | 8 | 0 | | |
27 | SLS_IFILL | PAW - Item Fillin | 2 | ITEMID | PAW identifier | nvarchar | 8 | 0 | | |
28 | SLS_ILC1 | PAW - Item LC1 | 2 | ITEMID | PAW identifier | nvarchar | 8 | 0 | | |
29 | SLS_ILC2 | PAW - Item LC2 | 2 | ITEMID | PAW identifier | nvarchar | 8 | 0 | | |
30 | SLS_IMC | PAW - Item Multiple Choice | 2 | ITEMID | PAW identifier | nvarchar | 8 | 0 | | |
31 | SLS_IRATE | PAW - Item Rate | 2 | ITEMID | PAW identifier | nvarchar | 8 | 0 | | |
32 | SLS_ITEM | PAW - Item Description | 2 | ITEMID | PAW identifier | nvarchar | 8 | 0 | | |
33 | SLS_RESS1 | PAW - Result for Item Essay 1 | 3 | ITEMID | PAW identifier | nvarchar | 8 | 0 | | |
34 | SLS_RESS2 | PAW - Result for Item Essay 2 | 3 | ITEMID | PAW identifier | nvarchar | 8 | 0 | | |
35 | SLS_RFILL | PAW - Result Item Fillin | 3 | ITEMID | PAW identifier | nvarchar | 8 | 0 | | |
36 | SLS_RITEM | PAW - Result on Item | 3 | ITEMID | PAW identifier | nvarchar | 8 | 0 | | |
37 | SLS_RLC | PAW - Result for Item Listchoice | 3 | ITEMID | PAW identifier | nvarchar | 8 | 0 | | |
38 | SLS_RMC | PAW - Result for Item Multiple Choice | 3 | ITEMID | PAW identifier | nvarchar | 8 | 0 | | |
39 | SLS_RRATE | PAW - Result for Item RATE | 3 | ITEMID | PAW identifier | nvarchar | 8 | 0 | | |
40 | SLS_TSTRU | PAW - Test Structure | 6 | ITEMID | PAW identifier | nvarchar | 8 | 0 | | |
41 | SLS_YESS1 | PAW - Result for Item Essay 1 | 3 | ITEMID | PAW identifier | nvarchar | 8 | 0 | | |
42 | SLS_YESS2 | PAW - Result for Item Essay 2 | 3 | ITEMID | PAW identifier | nvarchar | 8 | 0 | | |
43 | SLS_YFILL | PAW - Result Item Fillin | 3 | ITEMID | PAW identifier | nvarchar | 8 | 0 | | |
44 | SLS_YITEM | PAW - Result on Item | 3 | ITEMID | PAW identifier | nvarchar | 8 | 0 | | |
45 | SLS_YLC | PAW - Result for Item Listchoice | 3 | ITEMID | PAW identifier | nvarchar | 8 | 0 | | |
46 | SLS_YMC | PAW - Result for Item Multiple Choice | 3 | ITEMID | PAW identifier | nvarchar | 8 | 0 | | |
47 | SLS_YRATE | PAW - Result for Item RATE | 3 | ITEMID | PAW identifier | nvarchar | 8 | 0 | | |
TOPProcess Management |
48 | TCOOPC_ITEM | OPC: Plant-Specific Custom. Table for OPC Item Definition | 5 | ITEMID | OPC: Fully Qualified OPC Item ID | nvarchar | 255 | 0 | | |
TOPSocial Services and Social Security |
49 | PSSCD_GEDITEM | Gross Entitlement Determination Item Data | 3 | ITEMID | Social Services Business Object Item ID | nvarchar | 32 | 0 | | |
50 | PSSCD_GPDITEM | Gross Payment Docment Item Data | 3 | ITEMID | Social Services Business Object Item ID | nvarchar | 32 | 0 | | |
51 | PSSCD_NCDITEM | Net Calculation Document Item | 3 | ITEMID | Social Services Business Object Item ID | nvarchar | 32 | 0 | | |
52 | PSSCD_SXPITEM | SXP Item Data | 3 | ITEMID | Social Services Business Object Item ID | varbinary | 16 | 0 | | |
53 | PSSCD_SXP_APPT | SXP Appointment | 3 | ITEMID | Social Services Business Object Item ID | varbinary | 16 | 0 | | |
54 | PSSCD_SXP_CUST_I | SXP Customer Include (Item) | 3 | ITEMID | Social Services Business Object Item ID | varbinary | 16 | 0 | | |
55 | PSSCD_SXP_PARTNR | SXP Partner | 3 | ITEMID | Social Services Business Object Item ID | varbinary | 16 | 0 | | |
56 | PSSCD_SXP_PAYM_R | SXP Additional Payment Recipients | 3 | ITEMID | Social Services Business Object Item ID | varbinary | 16 | 0 | | |
57 | PSSCD_SXP_STATUS | SXP Status | 3 | ITEMID | Social Services Business Object Item ID | varbinary | 16 | 0 | | |
TOPTransaction Tax Engine |
58 | TTED_ANALYS_COM | Output Trace | 4 | ITEMID | Item Identifier | nvarchar | 32 | 0 | | |
59 | TTED_INITEM_COM | Input item | 5 | ITEMID | Item Identifier | nvarchar | 32 | 0 | | |
60 | TTED_OUTITEM_COM | Output Item | 5 | ITEMID | Item Identifier | nvarchar | 32 | 0 | | |
61 | TTEPD3_ITEM | Item | 5 | ITEMID | Item Identifier | nvarchar | 32 | 0 | | |
62 | TTEPD3_USITEM | Persistency TTE Document UsItem | 3 | ITEMID | Item Identifier | nvarchar | 32 | 0 | | |
63 | TTEPDT_ITEM | Persistency TTE Document Item | 3 | ITEMID | Item Identifier | nvarchar | 32 | 0 | | |
64 | TTEPDT_ITEMPART | Persistency TTE Document item partner | 3 | ITEMID | Item Identifier | nvarchar | 32 | 0 | | |
65 | TTEPDT_ORGUNIT | Persistency TTE Document org unit | 3 | ITEMID | Item Identifier | nvarchar | 32 | 0 | | |
66 | TTEPDT_PRICEL | Persistency TTE Document / Item pricing element | 3 | ITEMID | Item Identifier | nvarchar | 32 | 0 | | |
67 | TTEPDT_TAXCODVA | Document / Item TaxCode Value | 4 | ITEMID | Item Identifier | nvarchar | 32 | 0 | | |
68 | TTEPDT_TAXDATE | Persistemcy TTE Document tax date | 3 | ITEMID | Item Identifier | nvarchar | 32 | 0 | | |
69 | TTEPDT_TAXEL | Persistency TTE Document / Item tax element | 4 | ITEMID | Item Identifier | nvarchar | 32 | 0 | | |
70 | TTEPDT_TAXEVENT | Persistency TTE Document / Item tax event | 4 | ITEMID | Item Identifier | nvarchar | 32 | 0 | | |
71 | TTEPDT_TAXVALUE | Persistency TTE Document / Item tax value | 4 | ITEMID | Item Identifier | nvarchar | 32 | 0 | | |
72 | TTEPDT_TRANPROP | Persistency TTE Document transaction property | 3 | ITEMID | Item Identifier | nvarchar | 32 | 0 | | |
73 | TTEPDT_USITEM | Persistency TTE Document UsItem | 3 | ITEMID | Item Identifier | nvarchar | 32 | 0 | | |
74 | TTESDT_ANALYSYS | Pricing Trace from Tax Calculation | 3 | ITEMID | Item Identifier | nvarchar | 32 | 0 | | |
75 | TTESDT_ITEM | Item | 3 | ITEMID | Item Identifier | varbinary | 16 | 0 | | |
76 | TTESDT_ITEMPART | Document item partner | 3 | ITEMID | Item Identifier | varbinary | 16 | 0 | | |
77 | TTESDT_ORGUNIT | Document org unit | 3 | ITEMID | Item Identifier | varbinary | 16 | 0 | | |
78 | TTESDT_PRICEL | Document / Item pricing element | 3 | ITEMID | Item Identifier | varbinary | 16 | 0 | | |
79 | TTESDT_TAXCODVA | Document / Item pricing element | 4 | ITEMID | Item Identifier | varbinary | 16 | 0 | | |
80 | TTESDT_TAXDATE | Document tax date | 3 | ITEMID | Item Identifier | varbinary | 16 | 0 | | |
81 | TTESDT_TAXEL | Document / Item tax element | 4 | ITEMID | Item Identifier | varbinary | 16 | 0 | | |
82 | TTESDT_TAXEVENT | Document / Item tax event | 4 | ITEMID | Item Identifier | varbinary | 16 | 0 | | |
83 | TTESDT_TAXVALUE | Document / Item tax value | 4 | ITEMID | Item Identifier | varbinary | 16 | 0 | | |
84 | TTESDT_TRANPROP | Document transaction property | 3 | ITEMID | Item Identifier | varbinary | 16 | 0 | | |
85 | TTESDT_USITEM | Output Exemptions | 3 | ITEMID | Item Identifier | nvarchar | 32 | 0 | | |
TOPWorkplace Server |
86 | TCBRCUSTOM | Customer Branding Parameter Table | 2 | ITEMID | ParameterID | nvarchar | 40 | 0 | | |
87 | TWPCUSTMCT | Text Table for Customer System Settings for Workplace | 4 | ITEMID | Entry ID for System Settings | nvarchar | 10 | 0 | | |
88 | TWPCUSTOM | System Setting for the Workplace | 2 | ITEMID | Entry ID for System Settings | nvarchar | 10 | 0 | | |
89 | TWPCUSTOMC | Customer-Defined System Setting for the Workplace | 3 | ITEMID | Entry ID for System Settings | nvarchar | 10 | 0 | | |
90 | TWPCUSTOMT | Text Table for System Settings for the Workplace | 3 | ITEMID | Entry ID for System Settings | nvarchar | 10 | 0 | | |
91 | USRGENPRS | Table for General Workplace Personalization Data | 4 | ITEMID | Entry ID for System Settings | nvarchar | 10 | 0 | | |