| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /OPT/VT_ATM_SRC | Source Table for the Aggregations of the ATM report | 17 | INV_TYPE | Invoice Type | nvarchar | 3 | 0 | | |
2 | /OPT/X005 | Approval COA Fields | 2 | INV_TYPE | Invoice Type | nvarchar | 1 | 0 | | |
3 | /OPT/X069 | Document Type Definition | 32 | INV_TYPE | Invoice Type | nvarchar | 3 | 0 | | |
4 | /OPT/Y005 | Approval COA Fields | 2 | INV_TYPE | Invoice Type | nvarchar | 1 | 0 | | |
5 | /OPT/Y069 | Document Type Definition | 32 | INV_TYPE | Invoice Type | nvarchar | 3 | 0 | | |
6 | /OPT/Z005 | Approval COA Fields | 2 | INV_TYPE | Invoice Type | nvarchar | 1 | 0 | | |
7 | /OPT/Z069 | Document Type Definition | 32 | INV_TYPE | Invoice Type | nvarchar | 3 | 0 | | |
8 | DFKKINVDOC_LOG | Log of Invoicing Runs | 7 | INV_TYPE | Invoicing Type | nvarchar | 2 | 0 | | |
9 | DFKKINVDOC_REV | Reversal Request for Invoicing Document | 7 | INV_TYPE | Invoicing Type | nvarchar | 2 | 0 | | |
10 | FIEUD_SBINV_H | SAFT: Self Billing Invoices (Header)- (MM) | 17 | INV_TYPE | SAFT: Invoice Type | nvarchar | 2 | 0 | | |
11 | FIEUD_SDINV_H | SAFT: Invoices from SD module(Header) | 15 | INV_TYPE | SAFT: Invoice Type | nvarchar | 2 | 0 | | |
12 | FIKZD_DEADJRNL | Invoice Journal Deadlines (Electronic Invoices) | 2 | INV_TYPE | Invoice Type | nvarchar | 1 | 0 | | |
13 | FIKZD_REGINV_IN | Incoming Invoice Registration Journal | 15 | INV_TYPE | Line Type | nvarchar | 1 | 0 | | |
14 | FIKZD_REGINV_OUT | Outgoing Invoice Registration Journal | 14 | INV_TYPE | Line Type | nvarchar | 1 | 0 | | |
15 | J_3RFDI_DEADJRNL | Invoice Journal Deadlines (Electronic Invoices) | 2 | INV_TYPE | Invoice Type | nvarchar | 1 | 0 | | |
16 | J_3RF_REGCUS_OUT | Customizing for Outgoing Invoice Registration Journal | 9 | INV_TYPE | Revision of Invoice or Corrective Invoice | nvarchar | 1 | 0 | | |
TOPBasis Components |
17 | /XFT/INV_C1 | Process type customizing | 2 | INV_TYPE | Invoice Receipt Type | nvarchar | 4 | 0 | | |
18 | /XFT/INV_C3 | Invoice Receipt: Outbound/Inbound Proxies | 2 | INV_TYPE | Invoice Receipt Type | nvarchar | 4 | 0 | | |
19 | /XFT/INV_C8 | Workflow Assignment IR | 2 | INV_TYPE | Invoice Receipt Type | nvarchar | 4 | 0 | | |
20 | /XFT/INV_Q | Invoice receipt queue: Header | 3 | INV_TYPE | Invoice Receipt Type | nvarchar | 4 | 0 | | |
21 | /XFT/INV_Q_S | Invoice receipt queue: Header | 3 | INV_TYPE | Invoice Receipt Type | nvarchar | 4 | 0 | | |
TOPCross-Application Components |
22 | /OPT/S_INV_HDR | VSS Staging Table: Invoice Header | 6 | INV_TYPE | Invoice Type | nvarchar | 1 | 0 | | |
23 | /OPT/VIM_HD_DP | VIM IE Monitor: Header Data for DP Invoices | 9 | INV_TYPE | Invoice Type | nvarchar | 3 | 0 | | |
TOPDSD Connector |
24 | /DSD/ME_COCI_ITM | DSD CN: Check-Out Check-In Items | 5 | INV_TYPE | DSD Connector: Inventory Type | nvarchar | 1 | 0 | | |
25 | /DSD/ME_COCI_PAY | DSD CN: Check-Out Check-In Payments | 5 | INV_TYPE | DSD Connector: Inventory Type | nvarchar | 1 | 0 | | |
26 | /DSD/ME_INVT_HD | DSD CN: Stock header data | 4 | INV_TYPE | DSD Connector: inventory type | nvarchar | 1 | 0 | | |
27 | /DSD/ME_OI_INV | DSD CN: Assign Invoice Types as Open Item Select. Criterias | 2 | INV_TYPE | DSD CN: Invoice Type | nvarchar | 15 | 0 | | |
TOPFinancial Accounting |
28 | /OPT/BL_T401 | Approval COA Fields | 2 | INV_TYPE | Invoice Type | nvarchar | 1 | 0 | | |
29 | /OPT/VIM_T100 | Document Type Definition | 33 | INV_TYPE | Invoice Type | nvarchar | 3 | 0 | | |
TOPInvoice Forecasting |
30 | IFW_C_STAT_OFF | IFW customizing: status offset | 3 | INV_TYPE | Invoice Reference Type | nvarchar | 2 | 0 | | |
31 | IFW_HEADER | Invoice forecasting header | 4 | INV_TYPE | Invoice Reference Type | nvarchar | 2 | 0 | | |
32 | IFW_ITEM | Invoice forecasting item | 5 | INV_TYPE | Invoice Reference Type | nvarchar | 2 | 0 | | |
TOPInvoicing in Contract Accounts Receivable and Payable |
33 | DFKKINVDOC_H | Invoicing Document Header | 5 | INV_TYPE | Invoicing Type | nvarchar | 2 | 0 | | |
34 | TFK2602 | Invoicing Processes | 4 | INV_TYPE | Invoicing Type | nvarchar | 2 | 0 | | |
35 | TFK2603 | Invoicing Types (Process-Specific) | 4 | INV_TYPE | Invoicing Type | nvarchar | 2 | 0 | | |
36 | TFK2603A | Invoicing Types | 3 | INV_TYPE | Invoicing Type | nvarchar | 2 | 0 | | |
37 | TFK2603AT | Invoicing Types (Texts) | 4 | INV_TYPE | Invoicing Type | nvarchar | 2 | 0 | | |
38 | TFK2603F | Invoicing Functions (Exceptions) | 4 | INV_TYPE | Invoicing Type | nvarchar | 2 | 0 | | |
39 | TFK2603T | Invoicing Type Texts (Process-Specific) | 5 | INV_TYPE | Invoicing Type | nvarchar | 2 | 0 | | |