| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | VMP_EXPLODED_MAT | VMP Planning scope expanded materials | 2 | DOCUMENTID | Planning Scope Document ID | nvarchar | 33 | 0 | | |
2 | VMP_PLNSCP_HDR | Document and BOM Links | 2 | DOCUMENTID | Planning Scope Document ID | nvarchar | 33 | 0 | | |
3 | VMP_PLNSCP_MBOM | Document Mbom links | 2 | DOCUMENTID | Planning Scope Document ID | nvarchar | 33 | 0 | | |
4 | VMP_PLSCP_LOGH | VMP Planning Scope Sync log history header table | 3 | DOCUMENTID | Planning Scope Document ID | nvarchar | 33 | 0 | | |
5 | VMP_PS_HDR_TXT | To store Planning scope header description for the Matchcode | 3 | DOCUMENTID | Planning Scope Document ID | nvarchar | 33 | 0 | | |
TOPLoans Management |
6 | TRLET_BUSTRANS | OBSOLETE: Previous Solution: BOs Transferred from Loans Area | 7 | DOCUMENTID | Distributor Document ID | varbinary | 16 | 0 | | |
7 | TRLET_LOAN_FLOW | OBSOLETE: Previous Solution: Loans Flows Transferred | 6 | DOCUMENTID | Distributor Document ID | varbinary | 16 | 0 | | |
TOPMetadata Repository |
8 | RSO_MMR_MIMES | BI Metadata Repository: Documents Calculated in Background | 4 | DOCUMENTID | Object Name in Object Directory | nvarchar | 40 | 0 | | |
TOPProduct Configurator |
9 | COMM_CFGDOCKEY | Ref. table between documentation and object | 5 | DOCUMENTID | Global Identifier | nvarchar | 32 | 0 | | |
TOPRecords and Case Management |
10 | RMPS_OCSP_HEADER | Digital Signature Header: Mixed Data for each Verfctn Run | 2 | DOCUMENTID | Document ID | nvarchar | 42 | 0 | | |
11 | RMPS_OCSP_ITEM | Digital Signature Item: Signatory Details for Each Ver. Run | 2 | DOCUMENTID | Document ID | nvarchar | 42 | 0 | | |
12 | RMPS_OCSP_QUEUE | Digital Signature: OCSP Signature Worklist (List) | 2 | DOCUMENTID | Document ID | nvarchar | 42 | 0 | | |
TOPTransaction Manager |
13 | TRDT_TRDDOCUMENT | (Obsolete as of CFM 1.0) Distributor Documents | 7 | DOCUMENTID | Distributor Document ID | varbinary | 16 | 0 | | |
TOPTransfer to Financial Accounting |
14 | TRACT_DOCUMENT | Treasury: Accounting Adaptor Document | 4 | DOCUMENTID | Distributor Document ID | varbinary | 16 | 0 | | |
15 | TRLT_BACKUPVORAB | Backup Flow Table from Preliminary Solution - Pos. Mgmt Sol. | 31 | DOCUMENTID | Distributor Document ID | varbinary | 16 | 0 | | |
16 | TRLT_DOCUMENT | Treasury Ledger Documents | 3 | DOCUMENTID | Distributor Document ID | varbinary | 16 | 0 | | |
17 | TRLT_FLOW | Treasury Ledger Flows | 33 | DOCUMENTID | Distributor Document ID | varbinary | 16 | 0 | | |
18 | TRSET_BUSTRANS | OLD! Preliminary Solution: Transferred Sec. Bus.Transactions | 7 | DOCUMENTID | Distributor Document ID | varbinary | 16 | 0 | | |
19 | TRSET_FLOW | OLD: Prelim. Solution: Transferred Security Flows | 6 | DOCUMENTID | Distributor Document ID | varbinary | 16 | 0 | | |