| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | CNVTDMSSCM_ODM | TDMS Header for VAS ,Final Shipment and Freight | 3 | ORDID | ODM: Order Document ID | varbinary | 16 | 0 | | |
TOPBusiness Information Collection |
2 | UIORD | Research Request (SEM Business Information Collection) | 2 | ORDID | ID of a BIC Research Request | nvarchar | 22 | 0 | | |
3 | UIORD_R_DELIV | Relation Research Request <-> Delivery Type (SEM-BIC) | 2 | ORDID | Global ID number for data sources | nvarchar | 22 | 0 | | |
4 | UIORD_R_FREQ | Relation Research Request <-> Frequency (SEM-BIC) | 2 | ORDID | Global ID number for data sources | nvarchar | 22 | 0 | | |
5 | UIORD_R_IUSR | Relation between Research Request and InfoUser (SEM-BIC) | 2 | ORDID | Global ID number for data sources | nvarchar | 22 | 0 | | |
6 | UIORD_R_KW | Relation Research Request <-> Keyword (SEM-BIC) | 2 | ORDID | Global ID number for data sources | nvarchar | 22 | 0 | | |
7 | UIORD_R_LANG | Relation Bet. Research Request and Result Langs (SEM-BIC) | 2 | ORDID | ID of a BIC Research Request | nvarchar | 22 | 0 | | |
8 | UIORD_R_SRC | Relation Between Research Request and Data Provider | 2 | ORDID | ID of a BIC Research Request | nvarchar | 22 | 0 | | |
9 | UIORD_T | Text (Short Description) on Research Request (SEM-BIC) | 2 | ORDID | Global ID number for data sources | nvarchar | 22 | 0 | | |
TOPliveCache Applications |
10 | /SAPAPO/ORDKEY | Key and descriptive data for order | 2 | ORDID | Internal Number (UID) for an Order in APO | nvarchar | 22 | 0 | | |
11 | /SAPAPO/ORDMAP | Order Mapping Table | 6 | ORDID | Internal Number (UID) for an Order in APO | nvarchar | 22 | 0 | | |
TOPMedia Product Sales and Distribution |
12 | JVSDORD | IS-M: Definition of Sort Criterion | 2 | ORDID | IS-M: Sort Criterion ID | nvarchar | 32 | 0 | | |
13 | JVSDVARIANTORD | IS-M: Assignment of Variant to Sort Criterion | 2 | ORDID | IS-M: Sort Criterion ID | nvarchar | 32 | 0 | | |
TOPProduct Safety |
14 | TCGREPVIEW | EHS: Entries for Report View Menu | 2 | ORDID | Sequence | nvarchar | 2 | 0 | | |
TOPSCM Basis |
15 | CAVEIBDOC | CAVE: Inbound Document Processing | 4 | ORDID | GUID for Order Headers | nvarchar | 22 | 0 | | |
16 | CIFORDMAP | Mapping Table Order No. <-> APO-GUID (Plan/Prod. Orders) | 4 | ORDID | GUID for Order Headers (RAW16) | varbinary | 16 | 0 | | |
17 | CIFPOMAP | Mapping Table NR/POS/ET <-> APO GUID (Purch. Ord. Docs) | 6 | ORDID | GUID for Order Headers (RAW16) | varbinary | 16 | 0 | | |
18 | CIFRVMAP | Mapping Table NR/POS/ET <-> APO GUID (Sales Orders) | 4 | ORDID | GUID for Order Headers (RAW16) | varbinary | 16 | 0 | | |
19 | CIFSLSMAP | Mapping Table NR/POS/ET <-> APO GUID (Sales Orders) | 5 | ORDID | GUID for Order Headers (RAW16) | varbinary | 16 | 0 | | |