| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /1RA/0SD030MI | Items for Class SD03 - Raw Data | 33 | INVOICE_TYPE | Invoice Type | nvarchar | 2 | 0 | | |
2 | /1RA/0SD032MI | Items for Class SD03 - Processable | 34 | INVOICE_TYPE | Invoice Type | nvarchar | 2 | 0 | | |
3 | /1RA/0SD034MI | Items for Class SD03 - Processed | 33 | INVOICE_TYPE | Invoice Type | nvarchar | 2 | 0 | | |
4 | /OPT/VIM_IDX_C_H | Maintain Characteristic Specific Index Header Fields | 5 | INVOICE_TYPE | Applicable Invoice Types | nvarchar | 1 | 0 | | |
5 | /OPT/VIM_IDX_C_I | Maintain Characteristic Specific Index Item Fields | 5 | INVOICE_TYPE | Applicable Invoice Types | nvarchar | 1 | 0 | | |
6 | /OPT/X002 | Configuration table for Coder & Approver options | 3 | INVOICE_TYPE | 5.1 Baseline: Invoice type | nvarchar | 4 | 0 | | |
7 | /OPT/X068 | Country Specific Process Types Confugration | 4 | INVOICE_TYPE | Applicable Invoice Types | nvarchar | 1 | 0 | | |
8 | /OPT/X143 | Reqisitioner Request table | 2 | INVOICE_TYPE | Reference Transaction | nvarchar | 5 | 0 | | |
9 | /OPT/X149 | OPENTEXT: Approval Diagnostic data | 3 | INVOICE_TYPE | Reference Transaction | nvarchar | 5 | 0 | | |
10 | /OPT/X150 | OPENTEXT: Approval Diagnostic Container | 2 | INVOICE_TYPE | Reference Transaction | nvarchar | 5 | 0 | | |
11 | /OPT/X151 | OPENTEXT: Approval Diagnostic Log Data | 2 | INVOICE_TYPE | Reference Transaction | nvarchar | 5 | 0 | | |
12 | /OPT/Y002 | Configuration table for Coder & Approver options | 3 | INVOICE_TYPE | 5.1 Baseline: Invoice type | nvarchar | 4 | 0 | | |
13 | /OPT/Y068 | Country Specific Process Types Confugration | 4 | INVOICE_TYPE | Applicable Invoice Types | nvarchar | 1 | 0 | | |
14 | /OPT/Y143 | Reqisitioner Request table | 2 | INVOICE_TYPE | Reference Transaction | nvarchar | 5 | 0 | | |
15 | /OPT/Y149 | OPENTEXT: Approval Diagnostic data | 3 | INVOICE_TYPE | Reference Transaction | nvarchar | 5 | 0 | | |
16 | /OPT/Y150 | OPENTEXT: Approval Diagnostic Container | 2 | INVOICE_TYPE | Reference Transaction | nvarchar | 5 | 0 | | |
17 | /OPT/Y151 | OPENTEXT: Approval Diagnostic Log Data | 2 | INVOICE_TYPE | Reference Transaction | nvarchar | 5 | 0 | | |
18 | /OPT/Z002 | Configuration table for Coder & Approver options | 3 | INVOICE_TYPE | 5.1 Baseline: Invoice type | nvarchar | 4 | 0 | | |
19 | /OPT/Z068 | Country Specific Process Types Confugration | 4 | INVOICE_TYPE | Applicable Invoice Types | nvarchar | 1 | 0 | | |
20 | /OPT/Z143 | Reqisitioner Request table | 2 | INVOICE_TYPE | Reference Transaction | nvarchar | 5 | 0 | | |
21 | /OPT/Z149 | OPENTEXT: Approval Diagnostic data | 3 | INVOICE_TYPE | Reference Transaction | nvarchar | 5 | 0 | | |
22 | /OPT/Z150 | OPENTEXT: Approval Diagnostic Container | 2 | INVOICE_TYPE | Reference Transaction | nvarchar | 5 | 0 | | |
23 | /OPT/Z151 | OPENTEXT: Approval Diagnostic Log Data | 2 | INVOICE_TYPE | Reference Transaction | nvarchar | 5 | 0 | | |
24 | /ORS/7_2_APB_REQ | Reqisitioner Request table | 2 | INVOICE_TYPE | Reference Transaction | nvarchar | 5 | 0 | | |
25 | /ORS/DIAGNOSTICS | OPENTEXT: Approval Diagnostic data | 3 | INVOICE_TYPE | Reference Transaction | nvarchar | 5 | 0 | | |
26 | /ORS/DIAG_CONT | OPENTEXT: Approval Diagnostic Container | 2 | INVOICE_TYPE | Reference Transaction | nvarchar | 5 | 0 | | |
27 | /ORS/DIAG_LOGS | OPENTEXT: Approval Diagnostic Log Data | 2 | INVOICE_TYPE | Reference Transaction | nvarchar | 5 | 0 | | |
28 | /ORS/INV_ADD | Invoice Add | 2 | INVOICE_TYPE | Reference Transaction | nvarchar | 5 | 0 | | |
29 | /ORS/INV_DATA | Additional Invoice Data Storage | 2 | INVOICE_TYPE | Reference Transaction | nvarchar | 5 | 0 | | |
30 | /ORS/INV_LOCK | Invoice Locking Table | 2 | INVOICE_TYPE | Reference Transaction | nvarchar | 5 | 0 | | |
31 | DFKKSAFTINV_H | SAF-T Source Document: Header | 21 | INVOICE_TYPE | Portugal: SAF-T Invoice type | nvarchar | 2 | 0 | | |
32 | FARR_D_INVOICE | Invoice Entries | 7 | INVOICE_TYPE | Invoice Type | nvarchar | 2 | 0 | | |
33 | FIEUD_SBINV_H | SAFT: Self Billing Invoices (Header)- (MM) | 25 | INVOICE_TYPE | SAFT: Invoice Type | nvarchar | 2 | 0 | | |
34 | FIEUD_SDINV_H | SAFT: Invoices from SD module(Header) | 23 | INVOICE_TYPE | SAFT: Invoice Type | nvarchar | 2 | 0 | | |
TOPCross-Application Components |
35 | /OPT/S_INV_HDR | VSS Staging Table: Invoice Header | 2 | INVOICE_TYPE | Invoice Type | nvarchar | 5 | 0 | | |
36 | /OPT/S_INV_LIN | VSS Staging Table: Invoice lines | 2 | INVOICE_TYPE | Invoice Type | nvarchar | 5 | 0 | | |
TOPFinancial Accounting |
37 | /OPT/BL_AP_CONF | Configuration table for Coder & Approver options | 3 | INVOICE_TYPE | 5.1 Baseline: Invoice type | nvarchar | 4 | 0 | | |
38 | /OPT/VIM_T005A | Characteristic Specific Process Types Confugration | 4 | INVOICE_TYPE | Applicable Invoice Types | nvarchar | 1 | 0 | | |
TOPFinancial Supply Chain Management |
39 | EDX_INBOUND | EDX: Inbound Messages (Processed Messages) | 19 | INVOICE_TYPE | EDX: Billing Category | nvarchar | 3 | 0 | | |
TOPIntercompany Data Exchange |
40 | TINV_C_DOCTLINET | Customizing: Permissability of Line Type per Bill Type | 2 | INVOICE_TYPE | Type of Bill / Type of Payment Advice Note | nvarchar | 3 | 0 | | |
41 | TINV_C_FM_ACTN | Customizing: Definition of Action Modules | 2 | INVOICE_TYPE | Type of Bill / Type of Payment Advice Note | nvarchar | 3 | 0 | | |
42 | TINV_C_FM_ACTNT | Customizing: Definition of Action Modules - TEXT | 2 | INVOICE_TYPE | Type of Bill / Type of Payment Advice Note | nvarchar | 3 | 0 | | |
43 | TINV_C_INCHCKA | Permitted Check Values for Bill/PAN Receipt | 3 | INVOICE_TYPE | Type of Bill / Type of Payment Advice Note | nvarchar | 3 | 0 | | |
44 | TINV_C_INCHCKG | Combination of PoD Group, Bill/PAN Type, Document Type | 3 | INVOICE_TYPE | Type of Bill / Type of Payment Advice Note | nvarchar | 3 | 0 | | |
45 | TINV_C_INCHCKSID | Combination: PoD Group, Bill/PAN Type, Document Type, ID | 3 | INVOICE_TYPE | Type of Bill / Type of Payment Advice Note | nvarchar | 3 | 0 | | |
46 | TINV_C_INVTYPE | Customizing: Bill Type | 2 | INVOICE_TYPE | Type of Bill / Type of Payment Advice Note | nvarchar | 3 | 0 | | |
47 | TINV_C_INVTYPET | Customizing: Bill Type - Text | 2 | INVOICE_TYPE | Type of Bill / Type of Payment Advice Note | nvarchar | 3 | 0 | | |
48 | TINV_C_ITYPEDOCT | Customizing: Permissibility of Document Type per Bill Type | 2 | INVOICE_TYPE | Type of Bill / Type of Payment Advice Note | nvarchar | 3 | 0 | | |
49 | TINV_C_PROCCNTR | Customizing: Definition of Processes for Each Bill | 2 | INVOICE_TYPE | Type of Bill / Type of Payment Advice Note | nvarchar | 3 | 0 | | |
50 | TINV_C_PROCCNTRA | Customizing: Definition of Permitted Processes per Bill | 2 | INVOICE_TYPE | Type of Bill / Type of Payment Advice Note | nvarchar | 3 | 0 | | |
51 | TINV_DOC_SHORT | Extract of Bill Receipt (Evaluation System): Bill Document | 18 | INVOICE_TYPE | Type of Bill / Type of Payment Advice Note | nvarchar | 3 | 0 | | |
52 | TINV_HEAD_SHORT | Extract of Bill Receipt (Evaluation System): Bill Header | 3 | INVOICE_TYPE | Type of Bill / Type of Payment Advice Note | nvarchar | 3 | 0 | | |
53 | TINV_INV_DOC | Billing Doc. Data | 29 | INVOICE_TYPE | Type of Bill / Type of Payment Advice Note | nvarchar | 3 | 0 | | |
54 | TINV_INV_HEAD | Bill Header | 5 | INVOICE_TYPE | Type of Bill / Type of Payment Advice Note | nvarchar | 3 | 0 | | |