| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | CNVTDMS_05_INTDO | Billing Doc. Data - ISU for TDMS | 3 | INT_INV_DOC_NO | NUMC18 for TDMS | nvarchar | 18 | 0 | | |
TOPIntercompany Data Exchange |
2 | ETAXTINVDOC | Index Table for Tax Storage for Incoming Bill, Documents | 3 | INT_INV_DOC_NO | Internal Number of Bill Document/Payment Advice Document | nvarchar | 18 | 0 | | |
3 | TINV_DOC_SHORT | Extract of Bill Receipt (Evaluation System): Bill Document | 2 | INT_INV_DOC_NO | Internal Number of Bill Document/Payment Advice Document | nvarchar | 18 | 0 | | |
4 | TINV_INV_DOC | Billing Doc. Data | 2 | INT_INV_DOC_NO | Internal Number of Bill Document/Payment Advice Document | nvarchar | 18 | 0 | | |
5 | TINV_INV_DOCPROC | Bill Document: Executed Processes | 2 | INT_INV_DOC_NO | Internal Number of Bill Document/Payment Advice Document | nvarchar | 18 | 0 | | |
6 | TINV_INV_DOCREF | Bill Document: Reference Information - Header/Document | 3 | INT_INV_DOC_NO | Internal Number of Bill Document/Payment Advice Document | nvarchar | 18 | 0 | | |
7 | TINV_INV_DOCREL | Release Information for Bill Document | 2 | INT_INV_DOC_NO | Internal Number of Bill Document/Payment Advice Document | nvarchar | 18 | 0 | | |
8 | TINV_INV_EXTID | Bill Document: External Identification Characteristics | 4 | INT_INV_DOC_NO | Internal Number of Bill Document/Payment Advice Document | nvarchar | 18 | 0 | | |
9 | TINV_INV_LINE_A | Payment Advice Line | 2 | INT_INV_DOC_NO | Internal Number of Bill Document/Payment Advice Document | nvarchar | 18 | 0 | | |
10 | TINV_INV_LINE_B | Bill Line with Posting Information | 2 | INT_INV_DOC_NO | Internal Number of Bill Document/Payment Advice Document | nvarchar | 18 | 0 | | |
11 | TINV_INV_LINE_I | Bill Line Item with Information (Not Relevant to Posting) | 2 | INT_INV_DOC_NO | Internal Number of Bill Document/Payment Advice Document | nvarchar | 18 | 0 | | |
12 | TINV_INV_LOGHD | Log Table - HEAD - for Bill Receipt Processing | 4 | INT_INV_DOC_NO | Internal Number of Bill Document/Payment Advice Document | nvarchar | 18 | 0 | | |
13 | TINV_INV_PRCSUPP | Subprocesses of Suppressed Documents | 3 | INT_INV_DOC_NO | Internal Number of Bill Document/Payment Advice Document | nvarchar | 18 | 0 | | |
14 | TINV_INV_STS | Sales Tax Statement - Control Table | 6 | INT_INV_DOC_NO | Internal Number of Bill Document/Payment Advice Document | nvarchar | 18 | 0 | | |
15 | TINV_INV_TMPLT | Bill Document: Template | 4 | INT_INV_DOC_NO | Internal Number of Bill Document/Payment Advice Document | nvarchar | 18 | 0 | | |
16 | TINV_INV_TRANSF | Transfer Table for Bill Data to FI-CA | 3 | INT_INV_DOC_NO | Internal Number of Bill Document/Payment Advice Document | nvarchar | 18 | 0 | | |
17 | TINV_LINEB_SHORT | Extract of Bill Receipt (Evaluation System): Bill Lines | 2 | INT_INV_DOC_NO | Internal Number of Bill Document/Payment Advice Document | nvarchar | 18 | 0 | | |
18 | TINV_TRANSF_HST | Reversal: Historical TINV_INV_TRANSF Entries | 4 | INT_INV_DOC_NO | Internal Number of Bill Document/Payment Advice Document | nvarchar | 18 | 0 | | |
19 | TINV_TRNSF_SHORT | Extract of Bill Receipt (Eval. System): FI-CA Transfer Data | 3 | INT_INV_DOC_NO | Internal Number of Bill Document/Payment Advice Document | nvarchar | 18 | 0 | | |