| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /OPT/VT_DOC_HEA1 | Document Header - copy of /opt/vt_doc_head | 28 | POST_DATE | Psting Date | nvarchar | 8 | 0 | | |
2 | /OPT/VT_DOC_HEAD | Document Header | 28 | POST_DATE | Psting Date | nvarchar | 8 | 0 | | |
3 | /RCFUIX/FLT_IDS | Job Filter Bookmarks | 4 | POST_DATE | Field of type DATS | nvarchar | 8 | 0 | | |
4 | BKK_OPD_IT_EXT | External Item Selection Table - Outgoing Payment Dispatcher | 7 | POST_DATE | Posting date | nvarchar | 8 | 0 | | |
5 | BKK_PXPO_ORDER | Collective Payment Order | 5 | POST_DATE | Posting date | nvarchar | 8 | 0 | | |
6 | FIEUD_SBINV_H | SAFT: Self Billing Invoices (Header)- (MM) | 10 | POST_DATE | Posting Date in the Document | nvarchar | 8 | 0 | | |
7 | REQHEADS | Temporary Header Data: Requirement Coverage Request (Limit) | 61 | POST_DATE | Posting Date in the Document | nvarchar | 8 | 0 | | |
TOPAccounting Interface |
8 | GLE_ECS_ITEM | ECS: Error Correction Items | 19 | POST_DATE | Posting Date of Posted FI Document | nvarchar | 8 | 0 | | |
TOPAutomatic Payments |
9 | PAYRQ | Payment Requests | 147 | POST_DATE | Day on Which Payment Request was Posted | nvarchar | 8 | 0 | | |
TOPBasic Functions |
10 | TTXU | External tax interface: Audit file update information | 8 | POST_DATE | Posting Date in the Document | nvarchar | 8 | 0 | | |
TOPCommunication Channel |
11 | ICI_CCS_POSTING | CCS Simulator - Chat Posting | 4 | POST_DATE | CCS CHAR32 | nvarchar | 32 | 0 | | |
TOPContract Accounts Receivable and Payable |
12 | DFKKORDER | Requests: Header Data | 9 | POST_DATE | Posting Date in the Document | nvarchar | 8 | 0 | | |
13 | DFKKORDERAPPROVE | Requests to be Approved | 6 | POST_DATE | Posting Date in the Document | nvarchar | 8 | 0 | | |
14 | DFKKORDER_S | Request Templates: Header Data | 9 | POST_DATE | Posting Date in the Document | nvarchar | 8 | 0 | | |
TOPCross-Application Components |
15 | /OPT/S_PO_HIST | VSS Staging Table: PO history | 14 | POST_DATE | Posting Date in the Document | nvarchar | 8 | 0 | | |
16 | /OPT/VIM_HD_DP | VIM IE Monitor: Header Data for DP Invoices | 32 | POST_DATE | Psting Date | nvarchar | 8 | 0 | | |
17 | /OPT/VIM_HD_NPO | VIM IE Monitor: Header Data for Parked NPO Invoices | 11 | POST_DATE | Psting Date | nvarchar | 8 | 0 | | |
18 | /OPT/VIM_HD_PO | VIM IE Monitor: Header Data for Parked PO Invoices | 14 | POST_DATE | Psting Date | nvarchar | 8 | 0 | | |
TOPIncentive and Commission Management ICM |
19 | CACS00_B_VAR_CAS | Variants for Commission Case | 20 | POST_DATE | Posting Date in Commission Case/Comm Doc. (Acknowledgement) | nvarchar | 8 | 0 | | |
20 | CACS00_CAS | Commission Case | 16 | POST_DATE | Posting Date in Commission Case/Comm Doc. (Acknowledgement) | nvarchar | 8 | 0 | | |
21 | CACS00_DOCFI_H | Data Transfer: FI Documents (Header Data) | 6 | POST_DATE | Posting Date in the Document | nvarchar | 8 | 0 | | |
22 | CACS00_DOCHD | Commission Document Header | 8 | POST_DATE | Posting Date in Commission Case/Comm Doc. (Acknowledgement) | nvarchar | 8 | 0 | | |
23 | CACSFI_DOCFI_HD | Settlement to FI: Reference Document Header | 6 | POST_DATE | Posting Date in the Document | nvarchar | 8 | 0 | | |
24 | CACSHR_DOCHR_HD | Settlement to PY: Reference Document Header | 5 | POST_DATE | Posting Date | nvarchar | 8 | 0 | | |
25 | YCRM01_B_VAR_CAS | Variants for Commission Case | 28 | POST_DATE | Posting Date in Commission Case/Comm Doc. (Acknowledgement) | nvarchar | 8 | 0 | | |
26 | YCRM01_CAS | Commission Case | 16 | POST_DATE | Posting Date in Commission Case/Comm Doc. (Acknowledgement) | nvarchar | 8 | 0 | | |
27 | YCRM01_DOCFI_H | Data Transfer: FI Documents Header Data | 8 | POST_DATE | Posting Date in the Document | nvarchar | 8 | 0 | | |
28 | YCRM01_DOCHD | Commission Document Header | 8 | POST_DATE | Posting Date in Commission Case/Comm Doc. (Acknowledgement) | nvarchar | 8 | 0 | | |
29 | YHITEC_B_VAR_CAS | Variants for Commission Case | 13 | POST_DATE | Posting Date in Commission Case/Comm Doc. (Acknowledgement) | nvarchar | 8 | 0 | | |
30 | YHITEC_CAS | Commission Case | 9 | POST_DATE | Posting Date in Commission Case/Comm Doc. (Acknowledgement) | nvarchar | 8 | 0 | | |
31 | YHITEC_DOCFI_H | Data Transfer: FI Documents Header Data | 6 | POST_DATE | Posting Date in the Document | nvarchar | 8 | 0 | | |
32 | YHITEC_DOCHD | Commission Document Header | 6 | POST_DATE | Posting Date in Commission Case/Comm Doc. (Acknowledgement) | nvarchar | 8 | 0 | | |
33 | YSVMA_B_VAR_CAS | Variants for Commission Case | 28 | POST_DATE | Posting Date in Commission Case/Comm Doc. (Acknowledgement) | nvarchar | 8 | 0 | | |
34 | YSVMA_CAS | Commission Case | 24 | POST_DATE | Posting Date in Commission Case/Comm Doc. (Acknowledgement) | nvarchar | 8 | 0 | | |
35 | YSVMA_DOCFI_H | Data Transfer: FI Documents (Header Data) | 6 | POST_DATE | Posting Date in the Document | nvarchar | 8 | 0 | | |
36 | YSVMA_DOCHD | Commission Document Header | 16 | POST_DATE | Posting Date in Commission Case/Comm Doc. (Acknowledgement) | nvarchar | 8 | 0 | | |
37 | YTEL01_B_VAR_CAS | Variants for Commission Case | 13 | POST_DATE | Posting Date in Commission Case/Comm Doc. (Acknowledgement) | nvarchar | 8 | 0 | | |
38 | YTEL01_CAS | Commission Case | 9 | POST_DATE | Posting Date in Commission Case/Comm Doc. (Acknowledgement) | nvarchar | 8 | 0 | | |
39 | YTEL01_DOCFI_H | Data Transfer: FI Documents Header Data | 6 | POST_DATE | Posting Date in the Document | nvarchar | 8 | 0 | | |
40 | YTEL01_DOCHD | Commission Document Header | 6 | POST_DATE | Posting Date in Commission Case/Comm Doc. (Acknowledgement) | nvarchar | 8 | 0 | | |
41 | YTEL05_B_VAR_CAS | Variants for Commission Case | 28 | POST_DATE | Posting Date in Commission Case/Comm Doc. (Acknowledgement) | nvarchar | 8 | 0 | | |
42 | YTEL05_CAS | Commission Case | 24 | POST_DATE | Posting Date in Commission Case/Comm Doc. (Acknowledgement) | nvarchar | 8 | 0 | | |
43 | YTEL05_DOCFI_H | Data Transfer: FI Documents (Header Data) | 6 | POST_DATE | Posting Date in the Document | nvarchar | 8 | 0 | | |
44 | YTEL05_DOCHD | Commission Document Header | 16 | POST_DATE | Posting Date in Commission Case/Comm Doc. (Acknowledgement) | nvarchar | 8 | 0 | | |
45 | ZICMAG_B_VAR_CAS | Variants for Commission Case | 13 | POST_DATE | Posting Date in Commission Case/Comm Doc. (Acknowledgement) | nvarchar | 8 | 0 | | |
46 | ZICMAG_CAS | Commission Case | 9 | POST_DATE | Posting Date in Commission Case/Comm Doc. (Acknowledgement) | nvarchar | 8 | 0 | | |
47 | ZICMAG_DOCFI_H | Data Transfer: FI Documents (Header Data) | 6 | POST_DATE | Posting Date in the Document | nvarchar | 8 | 0 | | |
48 | ZICMAG_DOCHD | Commission Document Header | 6 | POST_DATE | Posting Date in Commission Case/Comm Doc. (Acknowledgement) | nvarchar | 8 | 0 | | |
TOPJoint Venture und Production Sharing Accounting |
49 | T8JFRM | Farm In/Out & Re-Determination (Farm) Main Table | 11 | POST_DATE | Posting Date in the Document | nvarchar | 8 | 0 | | |
50 | T8JFRM_STP | Farm In/Out & Re-Determination (Farm) Main Table | 7 | POST_DATE | Posting Date in the Document | nvarchar | 8 | 0 | | |
TOPPayment Item |
51 | BKKPAYMEX_HD | Header Table of EFT Management: Outgoing Payt Transactions | 17 | POST_DATE | Posting date | nvarchar | 8 | 0 | | |
TOPProduction Backflush |
52 | PPC_ACT_REPROC | Reprocessing Records for Activities | 8 | POST_DATE | Posting Date in the Document | nvarchar | 8 | 0 | | |
53 | PPC_STEP2 | Goods Movements Table for New PPCGO Logic (2 Steps) | 4 | POST_DATE | Posting Date in the Document | nvarchar | 8 | 0 | | |
TOPTransaction Data Pool |
54 | JBDVTTO | Variable Transaction - Turnovers | 6 | POST_DATE | Posting Date for Turnover | nvarchar | 8 | 0 | | |