| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /PICM/C_APPL_FRM | PICM: Application print form | 4 | MEDIUM | Output | nvarchar | 1 | 0 | | |
2 | BBP_TMP_VEN | Obsolete from 2.0C Onwards. Was Never used Before | 12 | MEDIUM | Transmission Medium (Printer, Fax, EDI, XML, and so on) | nvarchar | 3 | 0 | | |
3 | BBP_TMP_VEN000 | Temporary: Request 'Bidder', Purchasing Data | 12 | MEDIUM | Transmission Medium (Printer, Fax, EDI, XML, and so on) | nvarchar | 3 | 0 | | |
4 | BKK_OPD_RCN_AC | Reconciliation Accounts for Outgoing Payment Dispatcher | 12 | MEDIUM | Medium | nvarchar | 4 | 0 | | |
5 | GHO_ALC_SRC_FORM | Formula Source data for Allocation results invalidation | 5 | MEDIUM | Product on Which Allocation is Performed (Oil, Gas, Water) | nvarchar | 6 | 0 | | |
6 | GHO_ALC_SRC_NDRL | Source Table for Node Rule | 6 | MEDIUM | Product on Which Allocation is Performed (Oil, Gas, Water) | nvarchar | 6 | 0 | | |
7 | GHO_ALC_SRC_NRUL | Source Table for Network Rule | 6 | MEDIUM | Product on Which Allocation is Performed (Oil, Gas, Water) | nvarchar | 6 | 0 | | |
8 | GHO_ALC_SRC_TR | Theoretical Source data for Allocation results invalidation | 6 | MEDIUM | Product on Which Allocation is Performed (Oil, Gas, Water) | nvarchar | 6 | 0 | | |
9 | GHO_ALC_SRC_UOMR | Source Table for UOM Rule | 5 | MEDIUM | Product on Which Allocation is Performed (Oil, Gas, Water) | nvarchar | 6 | 0 | | |
10 | GHO_ALERT | Store Network Alerts | 4 | MEDIUM | Medium | nvarchar | 6 | 0 | | |
11 | GHO_ALLOC_PREP | Allocation Results Header | 5 | MEDIUM | Product on Which Allocation is Performed (Oil, Gas, Water) | nvarchar | 6 | 0 | | |
12 | GHO_ALLOC_RUN_JB | Allocation Results Header | 5 | MEDIUM | Product on Which Allocation is Performed (Oil, Gas, Water) | nvarchar | 6 | 0 | | |
13 | GHO_DM_ALLOC_RES | Allocation Results | 6 | MEDIUM | Medium | nvarchar | 6 | 0 | | |
14 | GHO_DM_RESULTS | Deferment Results | 9 | MEDIUM | Medium | nvarchar | 6 | 0 | | |
15 | GHO_FORM_MEAS_H | Allocation Formula Measurements Header | 6 | MEDIUM | Product on Which Allocation is Performed (Oil, Gas, Water) | nvarchar | 6 | 0 | | |
16 | GHO_MEAS_MEDIUM | Measurements mapped with mediums | 2 | MEDIUM | Medium | nvarchar | 6 | 0 | | |
17 | GHO_MEAS_PRIO_H | Allocation Rules Measurement Priority Header | 5 | MEDIUM | Product on Which Allocation is Performed (Oil, Gas, Water) | nvarchar | 6 | 0 | | |
18 | GHO_PPA_DATA | PPA request details | 22 | MEDIUM | Product on Which Allocation is Performed (Oil, Gas, Water) | nvarchar | 6 | 0 | | |
19 | T160I | Control of Intrastat Reports | 4 | MEDIUM | Transport medium for Intrastat data | nvarchar | 1 | 0 | | |
20 | T160J | Text Table for Intrastat Reports | 5 | MEDIUM | Transport medium for Intrastat data | nvarchar | 1 | 0 | | |
21 | VEN000 | Business Partner: General Vendor Data | 12 | MEDIUM | Transmission Medium (Printer, Fax, EDI, XML, and so on) | nvarchar | 3 | 0 | | |
22 | VIXCESM180DEC | Modelo 180 - Witholding Tax Declarer Line 01 | 8 | MEDIUM | Type of output medium | nvarchar | 1 | 0 | | |
23 | ZEIMMARA | USING FOR STORING EIM MARA DATAS | 163 | MEDIUM | Medium | nvarchar | 6 | 0 | | |
TOPBank Customer Accounts |
24 | BKKCORRITEM | Auxiliary Table: Payment Items for Adjustments | 33 | MEDIUM | Medium | nvarchar | 4 | 0 | | |
25 | BKKSO | BCA: Standing Orders | 24 | MEDIUM | Medium | nvarchar | 4 | 0 | | |
26 | BKK_PRENOTE | Prenotes | 17 | MEDIUM | Medium | nvarchar | 4 | 0 | | |
TOPBasic Data |
27 | NC301A | IS-HCM: EDI - Obsolete! (Documentation Archive Transfers) | 9 | MEDIUM | IS-HCM: Medium for data exchange (data carrier type) | nvarchar | 2 | 0 | | |
28 | NC301D | IS-HCM: EDI - Documentation Archive Transfers | 11 | MEDIUM | IS-HCM: Medium for data exchange (data carrier type) | nvarchar | 2 | 0 | | |
TOPCondition |
29 | BKK97 | Acct Balancing: Posting Data (Temporary Data)(for Deletion) | 25 | MEDIUM | Medium | nvarchar | 4 | 0 | | |
30 | TBKK8C | Categorization Medium (Item Counter) | 3 | MEDIUM | Medium | nvarchar | 4 | 0 | | |
TOPCross-Application Components |
31 | MMARA | General material data | 163 | MEDIUM | Medium | nvarchar | 6 | 0 | | |
TOPDay-to-Day Activities |
32 | HRT5048 | Table Section Infotype 5048 | 7 | MEDIUM | Output Medium | nvarchar | 4 | 0 | | |
33 | LSOCRPCNTXTPRTCL | LSO Correspondence: Log Area | 28 | MEDIUM | Output Medium | nvarchar | 4 | 0 | | |
34 | LSOCRPCNTXTSTAGE | LSO Correspondence: Staging Area | 28 | MEDIUM | Output Medium | nvarchar | 4 | 0 | | |
35 | LSOCRPCONTROL | Output Control: Delivery Method-Specific | 6 | MEDIUM | Output Medium | nvarchar | 4 | 0 | | |
36 | LSOCRPMEDIUM | Output Media Supported | 1 | MEDIUM | Output Medium | nvarchar | 4 | 0 | | |
37 | LSOCRPMEDIUMT | Output Media Supported: Texts | 1 | MEDIUM | Output Medium | nvarchar | 4 | 0 | | |
TOPFSCM In-House Cash |
38 | IHC_DB_CL_TYPES | Technical Settings for AMS Update | 7 | MEDIUM | Medium | nvarchar | 4 | 0 | | |
TOPGL transfer |
39 | BKKCNOITGL | Table of Items not Updated on the Account | 15 | MEDIUM | Medium | nvarchar | 4 | 0 | | |
TOPMaterial Master |
40 | MARA | General Material Data | 163 | MEDIUM | Medium | nvarchar | 6 | 0 | | |
41 | MARA_TMP | File for Incorrect Data in Direct Input | 170 | MEDIUM | Medium | nvarchar | 6 | 0 | | |
42 | MVRA | Cross-version fields for MARA | 163 | MEDIUM | Medium | nvarchar | 6 | 0 | | |
TOPNetwork Operations |
43 | GHO_OTS_MAT | GHO Order Template Structure Materials | 12 | MEDIUM | Product on Which Allocation is Performed (Oil, Gas, Water) | nvarchar | 6 | 0 | | |
44 | GHO_PP_PTABLE_IT | Item Table for Results of GHO Planning Table | 6 | MEDIUM | Product on Which Allocation is Performed (Oil, Gas, Water) | nvarchar | 6 | 0 | | |
TOPOwnership |
45 | GHO_OWNDOI_HDRCK | DOI Header Details work tabel | 8 | MEDIUM | Medium | nvarchar | 6 | 0 | | |
46 | GHO_OWN_DOI_HDR | DOI Header Details | 8 | MEDIUM | Medium | nvarchar | 6 | 0 | | |
47 | GHO_OWN_NET_ASG | Ownership (DOI) assignment to Network Objects | 6 | MEDIUM | Medium | nvarchar | 6 | 0 | | |
TOPPayment Item |
48 | BKKIT | Payment Item | 33 | MEDIUM | Medium | nvarchar | 4 | 0 | | |
49 | BKKITAI | Info Items for Interest Penalty at Balancing | 13 | MEDIUM | Medium | nvarchar | 4 | 0 | | |
50 | BKKITENQ | Blocked Payment Items | 33 | MEDIUM | Medium | nvarchar | 4 | 0 | | |
51 | BKKITREL | Payment Item | 33 | MEDIUM | Medium | nvarchar | 4 | 0 | | |
52 | BKKITRETREL | Payment Item Return to be released | 5 | MEDIUM | Medium | nvarchar | 4 | 0 | | |
53 | BKKITTMP | Planned Payment Items | 34 | MEDIUM | Medium | nvarchar | 4 | 0 | | |
54 | BKKITTMP_DEL | Planned Payment Items - Completed | 34 | MEDIUM | Medium | nvarchar | 4 | 0 | | |
55 | BKKPAYMEX_IT | EFT Management: Items in Outgoing Payment Transactions | 28 | MEDIUM | Medium | nvarchar | 4 | 0 | | |
56 | BKKPAYMIN_HD | Header Table of EFT Management Imported Items | 12 | MEDIUM | Medium | nvarchar | 4 | 0 | | |
57 | BKKPAYMIN_IT | Table of Imported Items | 23 | MEDIUM | Medium | nvarchar | 4 | 0 | | |
58 | TBKKI1 | Assignment Medium/Payment Method to Processes | 3 | MEDIUM | Medium | nvarchar | 4 | 0 | | |
59 | TBKKIDF | BCA: Defaults for Transaction | 4 | MEDIUM | Medium | nvarchar | 4 | 0 | | |
TOPPayment Order |
60 | BKKPOHD | Payment Order, Header Data | 7 | MEDIUM | Medium | nvarchar | 4 | 0 | | |
61 | BKKPOHD_TMP | Planned Payment Order, Header Data | 8 | MEDIUM | Medium | nvarchar | 4 | 0 | | |
62 | BKKPOHD_TMP_DEL | Planned Payment Order, Header Data | 8 | MEDIUM | Medium | nvarchar | 4 | 0 | | |
63 | BKKPOIT | Item in Payment Order | 17 | MEDIUM | Medium | nvarchar | 4 | 0 | | |
64 | BKKPOIT_TMP | Items in Planned Payment Order | 18 | MEDIUM | Medium | nvarchar | 4 | 0 | | |
65 | BKKPOIT_TMP_DEL | Items in Planned Payment Order | 16 | MEDIUM | Medium | nvarchar | 4 | 0 | | |
TOPPayment Transactions |
66 | BUSPROC_FCT_FIEB | FIEB: Function Modules for Business Process | 1 | MEDIUM | Standard for Payment Transactions | nvarchar | 10 | 0 | | |
67 | GENERAL_EB_FIEB | General Customizing Table for Electronic Banking | 1 | MEDIUM | Standard for Payment Transactions | nvarchar | 10 | 0 | | |
TOPPlant Maintenance |
68 | EAMS_SL_NM_LINKS | Network Modelor Links customization table | 2 | MEDIUM | Medium | nvarchar | 6 | 0 | | |
TOPProcess Controls |
69 | GRPCEVENT1AGGR | Event Monitoring Aggregation | 8 | MEDIUM | Total Deficiency Medium | int | 10 | 0 | | |
70 | GRPCEVENTAGGR | OBSOLETE Event Monitoring Aggregation | 9 | MEDIUM | Total Deficiency Medium | int | 10 | 0 | | |
71 | GRPCVIOLATION | Event Monitoring: Violations | 12 | MEDIUM | Total Deficiency Medium | int | 10 | 0 | | |
TOPProduct definition |
72 | TBKKG1 | Media | 2 | MEDIUM | Medium | nvarchar | 4 | 0 | | |
73 | TBKKG1T | Text Table for Media | 3 | MEDIUM | Medium | nvarchar | 4 | 0 | | |
74 | TBKKG1_TCODE | Assignment Transaction to Medium | 3 | MEDIUM | Medium | nvarchar | 4 | 0 | | |
75 | TBKKG5 | Assignment Functions Group - Medium, Transaction Type | 3 | MEDIUM | Medium | nvarchar | 4 | 0 | | |
76 | TBKKG7 | Assignment Blocking Reason - Medium, Transaction Type | 3 | MEDIUM | Medium | nvarchar | 4 | 0 | | |
TOPProduction Allocation |
77 | GHO_ALLOCRES_H | Allocation Results Header | 4 | MEDIUM | Product on Which Allocation is Performed (Oil, Gas, Water) | nvarchar | 6 | 0 | | |
78 | GHO_ALLOC_FIN_PP | Table to hold PP related final allocation results | 8 | MEDIUM | Product on Which Allocation is Performed (Oil, Gas, Water) | nvarchar | 6 | 0 | | |
79 | GHO_ALLOC_OVR | OBSOLETE - GHO Allocation Theoratical Override | 6 | MEDIUM | Product on Which Allocation is Performed (Oil, Gas, Water) | nvarchar | 6 | 0 | | |
80 | GHO_ALLOC_RES_H | OBSOLETE - Table for storing allocation results (Header) | 4 | MEDIUM | Product on Which Allocation is Performed (Oil, Gas, Water) | nvarchar | 6 | 0 | | |
81 | GHO_ALLOC_RES_PP | Table to hold PP related allocation results | 8 | MEDIUM | Product on Which Allocation is Performed (Oil, Gas, Water) | nvarchar | 6 | 0 | | |
82 | GHO_COM_WC_H | Commingled Well Completion Header | 5 | MEDIUM | Product on Which Allocation is Performed (Oil, Gas, Water) | nvarchar | 6 | 0 | | |
83 | GHO_NODERULE_H | Node Allocation Rules Header | 4 | MEDIUM | Product on Which Allocation is Performed (Oil, Gas, Water) | nvarchar | 6 | 0 | | |
84 | GHO_NODE_DS_SP_H | Node Down Stream Split header table | 5 | MEDIUM | Product on Which Allocation is Performed (Oil, Gas, Water) | nvarchar | 6 | 0 | | |
85 | GHO_NODE_RULE_H | OBSOLETE - Node Allocation Rules Header | 3 | MEDIUM | Product on Which Allocation is Performed (Oil, Gas, Water) | nvarchar | 6 | 0 | | |
86 | GHO_NWRULE_H | Network Allocation Rules Header | 4 | MEDIUM | Product on Which Allocation is Performed (Oil, Gas, Water) | nvarchar | 6 | 0 | | |
87 | GHO_NW_RULE_H | OBSOLETE - Production Flow Network Allocation Rules Header | 3 | MEDIUM | Product on Which Allocation is Performed (Oil, Gas, Water) | nvarchar | 6 | 0 | | |
88 | GHO_NW_UOM_RULE | OBSOLETE - UoM Rule for Network | 3 | MEDIUM | Product on Which Allocation is Performed (Oil, Gas, Water) | nvarchar | 6 | 0 | | |
89 | GHO_REP_MAT | Reproduced Material details table | 4 | MEDIUM | Product on Which Allocation is Performed (Oil, Gas, Water) | nvarchar | 6 | 0 | | |
90 | GHO_RULE_LOG_H | Allocation Rule Log Header | 7 | MEDIUM | Product on Which Allocation is Performed (Oil, Gas, Water) | nvarchar | 6 | 0 | | |
91 | GHO_SIMU_CAP | Simulation: Modified network object capacities | 5 | MEDIUM | Product on Which Allocation is Performed (Oil, Gas, Water) | nvarchar | 6 | 0 | | |
92 | GHO_SIMU_DS_SP_H | Simulation: Node Down Stream Split rules header | 6 | MEDIUM | Product on Which Allocation is Performed (Oil, Gas, Water) | nvarchar | 6 | 0 | | |
93 | GHO_SIMU_FLRT_I | Simulation: Flow Rate Item | 3 | MEDIUM | Product on Which Allocation is Performed (Oil, Gas, Water) | nvarchar | 6 | 0 | | |
94 | GHO_SIMU_NDRH | Simulation: Node Allocation Rules Header | 5 | MEDIUM | Product on Which Allocation is Performed (Oil, Gas, Water) | nvarchar | 6 | 0 | | |
95 | GHO_SIMU_NWRH | Simulation: Network Allocation Rules Header | 5 | MEDIUM | Product on Which Allocation is Performed (Oil, Gas, Water) | nvarchar | 6 | 0 | | |
96 | GHO_SIMU_REP_MAT | Simulation: Reproduced Material details table | 4 | MEDIUM | Product on Which Allocation is Performed (Oil, Gas, Water) | nvarchar | 6 | 0 | | |
97 | GHO_SIMU_TOR_H | Simulation: Theoretical Override Header | 7 | MEDIUM | Product on Which Allocation is Performed (Oil, Gas, Water) | nvarchar | 6 | 0 | | |
98 | GHO_SIMU_UOMRH | Simulation: Network UoM Rule Header | 5 | MEDIUM | Product on Which Allocation is Performed (Oil, Gas, Water) | nvarchar | 6 | 0 | | |
99 | GHO_SIMU_WCOM_H | Simulation: Commingled Well Completion Header | 6 | MEDIUM | Product on Which Allocation is Performed (Oil, Gas, Water) | nvarchar | 6 | 0 | | |
100 | GHO_SIMU_WC_OVR | Simulation: Well Completion Override Details Table | 5 | MEDIUM | Product on Which Allocation is Performed (Oil, Gas, Water) | nvarchar | 6 | 0 | | |
101 | GHO_THEO_OVR_H | Allocation Theoretical Override Header | 6 | MEDIUM | Product on Which Allocation is Performed (Oil, Gas, Water) | nvarchar | 6 | 0 | | |
102 | GHO_UOM_RULE_H | Network UoM Rule Header | 4 | MEDIUM | Product on Which Allocation is Performed (Oil, Gas, Water) | nvarchar | 6 | 0 | | |
103 | GHO_WC_OVR | Well Completion Override Details Table | 5 | MEDIUM | Product on Which Allocation is Performed (Oil, Gas, Water) | nvarchar | 6 | 0 | | |
104 | GHO_WC_RULE_LOG | Log table for Well Completion Override, Reproduce material | 5 | MEDIUM | Product on Which Allocation is Performed (Oil, Gas, Water) | nvarchar | 6 | 0 | | |
TOPPromotion |
105 | RDMT_MEDIUM | Promotion Media | 3 | MEDIUM | Promotion Medium | nvarchar | 2 | 0 | | |
106 | RDMT_MEDIUMT | Promotion Media Texts | 4 | MEDIUM | Promotion Medium | nvarchar | 2 | 0 | | |
TOPRecords and Case Management |
107 | RMPS_DISELEMS | Retention Elements (Data Record Descriptions) | 21 | MEDIUM | Paper Form or Electronic Form | nvarchar | 1 | 0 | | |
TOPSoftware Agent Framework |
108 | CRMD_EI_SOL_CART | EI: Persist user selected solution out of SDB | 13 | MEDIUM | Channel for Delivering Solution | nvarchar | 12 | 0 | | |
109 | CRMD_SAF_KB_STAT | SAF: Knowledge entity access statistics | 8 | MEDIUM | Channel for Delivering Solution | nvarchar | 12 | 0 | | |