| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | DIAN_A_1001_08 | Cached Data of DIAN Format 1001 version 08 | 3 | LINE_ID | Globally Unique Identifier | varbinary | 16 | 0 | | |
2 | DIAN_A_1003_07 | Cached Data of DIAN Format 1003 version 07 | 3 | LINE_ID | Globally Unique Identifier | varbinary | 16 | 0 | | |
3 | DIAN_A_1005_07 | Cached Data of DIAN Format 1005 version 07 | 3 | LINE_ID | Globally Unique Identifier | varbinary | 16 | 0 | | |
4 | DIAN_A_1006_07 | Cached Data of DIAN Format 1006 version 07 | 3 | LINE_ID | Globally Unique Identifier | varbinary | 16 | 0 | | |
5 | DIAN_A_1007_08 | Cached Data of DIAN Format 1007 version 08 | 3 | LINE_ID | Globally Unique Identifier | varbinary | 16 | 0 | | |
6 | DIAN_A_1008_07 | Cached Data of DIAN Format 1003 version 07 | 3 | LINE_ID | Globally Unique Identifier | varbinary | 16 | 0 | | |
7 | DIAN_A_1009_07 | Cached Data of DIAN Format 1009 version 07 | 3 | LINE_ID | Globally Unique Identifier | varbinary | 16 | 0 | | |
8 | DIAN_A_EXTRACT | Cached Extraction of DIAN Report | 5 | LINE_ID | Globally Unique Identifier | varbinary | 16 | 0 | | |
9 | DIAN_A_EXTR_INFO | Documents information related to the extracted DIAN data | 2 | LINE_ID | Globally Unique Identifier | varbinary | 16 | 0 | | |
10 | DIAN_A_TFORMAT | Testing table for Cached Data of DIAN Formats | 3 | LINE_ID | Globally Unique Identifier | varbinary | 16 | 0 | | |
11 | DIAN_C_ACCOUNTS | DIAN Accounts | 5 | LINE_ID | Globally Unique Identifier | varbinary | 16 | 0 | | |
12 | DIAN_C_VAT_1001 | Additional VAT Settings for Format 1001 | 5 | LINE_ID | Globally Unique Identifier | varbinary | 16 | 0 | | |
13 | DIAN_C_VAT_CONST | VAT Concept Settings | 5 | LINE_ID | Globally Unique Identifier | varbinary | 16 | 0 | | |
14 | DIAN_C_VAT_FORST | DIAN VAT Format Settings | 4 | LINE_ID | Globally Unique Identifier | varbinary | 16 | 0 | | |
15 | DIAN_C_WTH | DIAN Withholding Tax | 5 | LINE_ID | Globally Unique Identifier | varbinary | 16 | 0 | | |
16 | DIAN_C_WTH_1001 | Additional Withholding Settings for Format 1001 | 5 | LINE_ID | Globally Unique Identifier | varbinary | 16 | 0 | | |
17 | DVM_BOF_STATS | Business Objects Footprint statistics | 3 | LINE_ID | GUID in 'RAW' format | varbinary | 16 | 0 | | |
18 | J_3RFIMCD_MOVE | Cross company transfer. Import Customs Declaration | 5 | LINE_ID | Cross-Company Movement ID for Import Customs Declaration | nvarchar | 5 | 0 | | |
TOPAccounting Engine |
19 | /EACC/CONFIGS_LI | Configurations | 6 | LINE_ID | Field Name | nvarchar | 30 | 0 | | |
TOPBasic Functions |
20 | EMMAC_CCAT_CND | Conditions for Case Determination or Priority | 5 | LINE_ID | Condition Editor: Line Number in Internal Display | nvarchar | 3 | 0 | | |
TOPBusiness Process Engine |
21 | SWFBRULECOM | BAM: Client-Specific Conditions | 7 | LINE_ID | Condition Editor: Line Number in Internal Display | nvarchar | 3 | 0 | | |
22 | SWFBRULECOU | BAM: Cross-Client Condition | 6 | LINE_ID | Condition Editor: Line Number in Internal Display | nvarchar | 3 | 0 | | |
TOPClassification System New |
23 | CHARACTERTEXT | DML Text Object | 23 | LINE_ID | Row Key | nvarchar | 5 | 0 | | |
24 | CHARACTERTEXTH | DML Text Object | 23 | LINE_ID | Row Key | nvarchar | 5 | 0 | | |
25 | CME_ST_R3_DEP | CME Characteristic: Object Dependencies for R/3 Characterstc | 14 | LINE_ID | Row Key | nvarchar | 5 | 0 | | |
26 | CME_ST_R3_DEPH | CME Characteristic: Object Dependencies for R/3 Characterstc | 14 | LINE_ID | Row Key | nvarchar | 5 | 0 | | |
27 | CME_ST_REF | Characteristic: Data Reference | 17 | LINE_ID | Row Key | nvarchar | 5 | 0 | | |
28 | CME_ST_REFH | Characteristic: Data Reference | 17 | LINE_ID | Row Key | nvarchar | 5 | 0 | | |
29 | CME_ST_VALUE | CME Data Type: Values | 3 | LINE_ID | Row Key | nvarchar | 5 | 0 | | |
30 | CME_ST_VALUEH | CME Data Type: Values | 4 | LINE_ID | Row Key | nvarchar | 5 | 0 | | |
31 | CME_ST_VAL_TXT | DML Text Object | 23 | LINE_ID | Row Key | nvarchar | 5 | 0 | | |
32 | CME_ST_VAL_TXTH | DML Text Object | 23 | LINE_ID | Row Key | nvarchar | 5 | 0 | | |
33 | DEFSCOPETEXT | DML Text Object | 23 | LINE_ID | Row Key | nvarchar | 5 | 0 | | |
34 | DEFSCOPETEXTH | DML Text Object | 23 | LINE_ID | Row Key | nvarchar | 5 | 0 | | |
35 | DTYPETEXT | DML Text Object | 23 | LINE_ID | Row Key | nvarchar | 5 | 0 | | |
36 | DTYPETEXTH | DML Text Object | 23 | LINE_ID | Row Key | nvarchar | 5 | 0 | | |
TOPConfirmations |
37 | AFFW | Goods Movements with Errors from Confirmations | 75 | LINE_ID | Unique identification of document line | nvarchar | 6 | 0 | | |
TOPEvent Management |
38 | /SAPTRX/CONDDATA | Condition data table | 5 | LINE_ID | Condition Editor: Line Number in Internal Display | nvarchar | 3 | 0 | | |
TOPFunds Management |
39 | FMFGF2EDPRF | Edit 8- SF 133 Proof Edit (FACTS II) | 2 | LINE_ID | SF 133 Line ID | nvarchar | 4 | 0 | | |
TOPHydrocarbon Product Management |
40 | MSEGO1 | Quantity Conversion Parameters for Material Documents | 5 | LINE_ID | Unique identification of document line | nvarchar | 6 | 0 | | |
41 | MSEGO2 | Material Document Quantities in Additional Units of Measure | 6 | LINE_ID | Unique identification of document line | nvarchar | 6 | 0 | | |
42 | OIB_MIGO_HQCI | Store the QCI-GOITEM for MIGOs hold/restore feature | 2 | LINE_ID | Unique identification of document line | nvarchar | 6 | 0 | | |
43 | OIB_MIGO_HQCI_E | Store the QCI-GOITEM-Bapiret for MIGOs hold/restore feature | 2 | LINE_ID | Unique identification of document line | nvarchar | 6 | 0 | | |
44 | OIB_MIGO_HQCI_P | Store the QCI-GOITEM-Parameter for MIGOs hold/restore featur | 2 | LINE_ID | Unique identification of document line | nvarchar | 6 | 0 | | |
45 | OIB_MIGO_HQCI_Q | Store the QCI-GOITEM-Quantity for MIGOs hold/restore feature | 2 | LINE_ID | Unique identification of document line | nvarchar | 6 | 0 | | |
46 | OIB_MIGO_HTST | Store the TST-GOITEM for MIGOs hold/restore feature | 2 | LINE_ID | Unique identification of document line | nvarchar | 6 | 0 | | |
TOPInventory Management |
47 | MSEG | Document Segment: Material | 5 | LINE_ID | Unique identification of document line | nvarchar | 6 | 0 | | |
48 | MWXMSEG | ZMSEG: Interface for Posting of Value | 5 | LINE_ID | Unique identification of document line | nvarchar | 6 | 0 | | |
49 | MWZMSEG | ZMSEG:Interface for Posting of Value | 5 | LINE_ID | Unique identification of document line | nvarchar | 6 | 0 | | |
TOPLocal Event Infrastructure |
50 | SLEI_CONDITION | LEI conditions - Cross client | 3 | LINE_ID | Condition Editor: Line Number in Internal Display | nvarchar | 3 | 0 | | |
51 | SLEI_CONDITION_C | LEI conditions - Client specific | 4 | LINE_ID | Condition Editor: Line Number in Internal Display | nvarchar | 3 | 0 | | |
TOPMaintenance Orders |
52 | /MRSS/D_RSBUFDAT | Resource Buffering Data | 3 | LINE_ID | Numc3, internal use | nvarchar | 3 | 0 | | |
TOPManufacturer Part Number |
53 | ADPIC_HOLD_MIGO | Store BADI goitem for MIGO hold / restore functionality | 2 | LINE_ID | Unique identification of document line | nvarchar | 6 | 0 | | |
54 | ADPIC_HOLD_MPN | Store MPN subitems for MIGO hold / restore functionality | 2 | LINE_ID | Unique identification of document line | nvarchar | 6 | 0 | | |
TOPMaster Data Framework |
55 | DML_DELIVERY_TXT | MDF Text Object | 19 | LINE_ID | Row Key | nvarchar | 5 | 0 | | |
56 | DML_ST_TEXT | DML Text Object | 23 | LINE_ID | Row Key | nvarchar | 5 | 0 | | |
57 | DML_ST_TEXTH | DML Text Object | 23 | LINE_ID | Row Key | nvarchar | 5 | 0 | | |
TOPPurchasing |
58 | EKBE_SC | Component Consumption History for Subcontracting | 7 | LINE_ID | Unique identification of document line | nvarchar | 6 | 0 | | |
TOPRepetitive Manufacturing |
59 | COMPMOVE | Goods Movement of Components | 4 | LINE_ID | Unique identification of document line | nvarchar | 6 | 0 | | |
TOPSAP Business Workflow |
60 | SWBRULEBIN | WF: Runtime Representation of a Rule | 6 | LINE_ID | Condition Editor: Line Number in Internal Display | nvarchar | 3 | 0 | | |
61 | SWBRULECOM | WF: Client-specific start conditions | 8 | LINE_ID | Condition Editor: Line Number in Internal Display | nvarchar | 3 | 0 | | |
62 | SWBRULECOU | WF: Connecting Condition/Context to Event Linkage | 7 | LINE_ID | Condition Editor: Line Number in Internal Display | nvarchar | 3 | 0 | | |
63 | SWDSCONDEF | WF Definition: Conditions | 8 | LINE_ID | Condition Editor: Line Number in Internal Display | nvarchar | 3 | 0 | | |
64 | SWD_CONDEF | WF Definition/Runtime: Conditions | 9 | LINE_ID | Condition Editor: Line Number in Internal Display | nvarchar | 3 | 0 | | |
65 | SWECDFIELD | Combined field restrictions for change document | 4 | LINE_ID | Condition Editor: Line Number in Internal Display | nvarchar | 3 | 0 | | |
66 | SWJPCOND | Parameter Condition (Parsed) | 4 | LINE_ID | Condition Editor: Line Number in Internal Display | nvarchar | 3 | 0 | | |
TOPTariffs, Duties and Permits |
67 | OIH_MIGO_HTDP | Store the TDP-GOITEM for MIGOs hold/restore feature | 2 | LINE_ID | Unique identification of document line | nvarchar | 6 | 0 | | |