| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | CNVTDMS_05_INTIN | Internal Bill/Payment Advice Number ISU for TDMS | 3 | INT_INV_NO | NUMC18 for TDMS | nvarchar | 18 | 0 | | |
TOPIntercompany Data Exchange |
2 | TINV_DOC_SHORT | Extract of Bill Receipt (Evaluation System): Bill Document | 3 | INT_INV_NO | Internal Bill/Payment Advice Number | nvarchar | 18 | 0 | | |
3 | TINV_HEAD_SHORT | Extract of Bill Receipt (Evaluation System): Bill Header | 2 | INT_INV_NO | Internal Bill/Payment Advice Number | nvarchar | 18 | 0 | | |
4 | TINV_INV_DOC | Billing Doc. Data | 3 | INT_INV_NO | Internal Bill/Payment Advice Number | nvarchar | 18 | 0 | | |
5 | TINV_INV_DOCREF | Bill Document: Reference Information - Header/Document | 2 | INT_INV_NO | Internal Bill/Payment Advice Number | nvarchar | 18 | 0 | | |
6 | TINV_INV_EXTID | Bill Document: External Identification Characteristics | 3 | INT_INV_NO | Internal Bill/Payment Advice Number | nvarchar | 18 | 0 | | |
7 | TINV_INV_HEAD | Bill Header | 2 | INT_INV_NO | Internal Bill/Payment Advice Number | nvarchar | 18 | 0 | | |
8 | TINV_INV_LOGHD | Log Table - HEAD - for Bill Receipt Processing | 3 | INT_INV_NO | Internal Bill/Payment Advice Number | nvarchar | 18 | 0 | | |
9 | TINV_INV_PRCSUPP | Subprocesses of Suppressed Documents | 2 | INT_INV_NO | Internal Bill/Payment Advice Number | nvarchar | 18 | 0 | | |
10 | TINV_INV_STS | Sales Tax Statement - Control Table | 5 | INT_INV_NO | Internal Bill/Payment Advice Number | nvarchar | 18 | 0 | | |
11 | TINV_INV_TMPLT | Bill Document: Template | 3 | INT_INV_NO | Internal Bill/Payment Advice Number | nvarchar | 18 | 0 | | |