| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | INVDOCNO | Number of Invoicing Document | nvarchar | 12 | 0 | | | | Allow NULL? |
| 3 | REVTASK | Reversal Task | nvarchar | 12 | 0 | | | | Allow NULL? |
| 4 | STATUS | Status of Reversal Request | char | 1 | 0 | | | | Allow NULL? |
| 5 | REVREASON | Reversal Reason of Invoicing Document | nvarchar | 2 | 0 | | | | Allow NULL? |
| 6 | STODT | Reversal Document Posting Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 7 | INV_TYPE | Invoicing Type | nvarchar | 2 | 0 | | | | Allow NULL? |
| 8 | INV_PROCESS | Invoicing Process | nvarchar | 2 | 0 | | | | Allow NULL? |
| 9 | INV_CATEGORY | Invoicing Category | nvarchar | 4 | 0 | | | | Allow NULL? |
| 10 | GPART | Business Partner Number for Billing and Invoicing | nvarchar | 10 | 0 | | | | Allow NULL? |
| 11 | GPART_SEL | Business Partners Relevant for Document Selection | nvarchar | 10 | 0 | | | | Allow NULL? |
| 12 | VKONT | Contract Account Number for Billing and Invoicing | nvarchar | 12 | 0 | | | | Allow NULL? |
| 13 | VKONT_SEL | Contract Account Relevant for Document Selection | nvarchar | 12 | 0 | | | | Allow NULL? |
| 14 | MDCAT | Type of Master Data for Billing and Invoicing | char | 1 | 0 | | | | Allow NULL? |
| 15 | INVDOC_CRDATE | Creation Date of Invoicing Document | nvarchar | 8 | 0 | | | | Allow NULL? |
| 16 | INVDOC_CRTIME | Time of Creation of Invoicing Document | nvarchar | 6 | 0 | | | | Allow NULL? |
| 17 | INVPERCAT | Category of Invoicing Period | nvarchar | 2 | 0 | | | | Allow NULL? |
| 18 | INVPERIOD | Invoicing Period | nvarchar | 8 | 0 | | | | Allow NULL? |
| 19 | FAEDN | Due date for net payment | nvarchar | 8 | 0 | | | | Allow NULL? |
| 20 | TOTAL_CURR | Transaction Currency | nvarchar | 5 | 0 | | | | Allow NULL? |
| 21 | TOTAL_AMT | Amount in Transaction Currency with +/- Sign | decimal | 13 | 2 | | | | |
| 22 | CRNAME | User Who Created the Reversal Request | nvarchar | 12 | 0 | | | | Allow NULL? |
| 23 | CRDATE | Date Reversal Request Was Created | nvarchar | 8 | 0 | | | | Allow NULL? |
| 24 | CRTIME | Time at Which Reversal Request Was Created | nvarchar | 6 | 0 | | | | Allow NULL? |
| 25 | LOEDT | Date on which the entry can be deleted again | nvarchar | 8 | 0 | | | | Allow NULL? |