| 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 | APPLK | Application area | char | 1 | 0 | | | | Allow NULL? |
| 4 | INV_PROCESS | Invoicing Process | nvarchar | 2 | 0 | | | | Allow NULL? |
| 5 | INV_TYPE | Invoicing Type | nvarchar | 2 | 0 | | | | Allow NULL? |
| 6 | INV_CATEGORY | Invoicing Category | nvarchar | 4 | 0 | | | | Allow NULL? |
| 7 | TECHDOCTYPE | Type of Technical Billing/Invoicing Document | char | 1 | 0 | | | | Allow NULL? |
| 8 | TARGPROCESS | Target Process That Invoices the Source Document | nvarchar | 4 | 0 | | | | Allow NULL? |
| 9 | GPART | Business Partner Number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 10 | VKONT | Contract Account Number | nvarchar | 12 | 0 | | | | Allow NULL? |
| 11 | MDCAT | Type of Master Data for Billing and Invoicing | char | 1 | 0 | | | | Allow NULL? |
| 12 | ABWVK | Alternative contract account for collective bills | nvarchar | 12 | 0 | | | | Allow NULL? |
| 13 | ABWBL | Number of the substitute FI-CA document | nvarchar | 12 | 0 | | | | Allow NULL? |
| 14 | CRNAME | Created By | nvarchar | 12 | 0 | | | | Allow NULL? |
| 15 | CRDATE | Creation Date of Invoicing Document | nvarchar | 8 | 0 | | | | Allow NULL? |
| 16 | CRTIME | Time of Creation of Invoicing Document | nvarchar | 6 | 0 | | | | Allow NULL? |
| 17 | CRMODE | Creation Mode of Invoicing Document | char | 1 | 0 | | | | Allow NULL? |
| 18 | RECNUM | Total Number of Items of an Invoicing Document | int | 10 | 0 | | | | Allow NULL? |
| 19 | FIKEY | Reconciliation Key for General Ledger | nvarchar | 12 | 0 | | | | Allow NULL? |
| 20 | BUDAT | Posting Date in the Document | nvarchar | 8 | 0 | | | | Allow NULL? |
| 21 | BLDAT | Document Date in Document | nvarchar | 8 | 0 | | | | Allow NULL? |
| 22 | FAEDN | Due date for net payment | nvarchar | 8 | 0 | | | | Allow NULL? |
| 23 | FAEDS | Due Date for Cash Discount | nvarchar | 8 | 0 | | | | Allow NULL? |
| 24 | SKTPZ | Cash discount rate | decimal | 5 | 3 | | | | |
| 25 | TOTAL_CURR | Transaction Currency | nvarchar | 5 | 0 | | | | Allow NULL? |
| 26 | TOTAL_AMT | Amount in Transaction Currency with +/- Sign | decimal | 13 | 2 | | | | |
| 27 | INVOICED | Invoicing Document Posted | char | 1 | 0 | | | | Allow NULL? |
| 28 | SIMULATED | Invoicing Document Is Simulated | char | 1 | 0 | | | | Allow NULL? |
| 29 | PRELIMINARY | Preliminary Invoice | char | 1 | 0 | | | | Allow NULL? |
| 30 | PRLINV_CAT | Preliminary Invoice Category | nvarchar | 4 | 0 | | | | Allow NULL? |
| 31 | REVREASON | Reversal Reason of Invoicing Document | nvarchar | 2 | 0 | | | | Allow NULL? |
| 32 | REVERSALDOC | Number of Reversal Document for Invoicing Document | nvarchar | 12 | 0 | | | | Allow NULL? |
| 33 | REVERSEDDOC | Number of Reversed Invoicing Document | nvarchar | 12 | 0 | | | | Allow NULL? |
| 34 | CORRCAT | Category of Invoice Correction | nvarchar | 2 | 0 | | | | Allow NULL? |
| 35 | PRINTDATE | Print Date of Invoicing Document | nvarchar | 8 | 0 | | | | Allow NULL? |
| 36 | PRINTLOCK | Invoicing Document Locked for Printing | char | 1 | 0 | | | | Allow NULL? |
| 37 | PYMET | Payment Method | char | 1 | 0 | | | | Allow NULL? |
| 38 | NRZAS | Payment Form Number | nvarchar | 12 | 0 | | | | Allow NULL? |
| 39 | FORMKEY | Application form | nvarchar | 30 | 0 | | | | Allow NULL? |
| 40 | ZLSCH | Form ID for Attached Payment Medium | char | 1 | 0 | | | | Allow NULL? |
| 41 | DOCTYPE | Document Type | nvarchar | 2 | 0 | | | | Allow NULL? |
| 42 | EXKID | Key Identification | nvarchar | 2 | 0 | | | | Allow NULL? |
| 43 | EXBEL | Official Document Number | nvarchar | 16 | 0 | | | | Allow NULL? |
| 44 | PTSRL | Partner Settlement Rule | nvarchar | 4 | 0 | | | | Allow NULL? |
| 45 | BUKRS | Company Code | nvarchar | 4 | 0 | | | | Allow NULL? |
| 46 | BUPLA | Business Place | nvarchar | 4 | 0 | | | | Allow NULL? |
| 47 | INVOICE_BASEDATE | Baseline Date for Period Assignment in Invoicing | nvarchar | 8 | 0 | | | | Allow NULL? |
| 48 | INVPERCAT | Category of Invoicing Period | nvarchar | 2 | 0 | | | | Allow NULL? |
| 49 | INVPERIOD | Invoicing Period | nvarchar | 8 | 0 | | | | Allow NULL? |
| 50 | INVPERIOD_FROM | Start of Invoicing Period | nvarchar | 8 | 0 | | | | Allow NULL? |
| 51 | MAZAE | Counter for several dunning notices to a business partner | nvarchar | 6 | 0 | | | | Allow NULL? |
| 52 | CHGDOC_EX | Invoicing Document Contains Charge/Discount Items | char | 1 | 0 | | | | Allow NULL? |
| 53 | CFCSIMULATED | Control Document for Clarif. Case (Sim. Invoicing Document) | char | 1 | 0 | | | | Allow NULL? |
| 54 | BOLLOTAX | Stamp Tax Posted | char | 1 | 0 | | | | Allow NULL? |
| 55 | XSUBINV | Invoicing Document Is Single Document of Invoicing List | char | 1 | 0 | | | | Allow NULL? |
| 56 | XINVDOC_X | Invoicing Document Contains Object Relationships | char | 1 | 0 | | | | Allow NULL? |
| 57 | SEPA_PRENOT | Invoicing Document Contains SEPA Pre-Notification | char | 1 | 0 | | | | Allow NULL? |
| 58 | EXT_INVDOCNO | Number of Document from External Invoicing | nvarchar | 22 | 0 | | | | Allow NULL? |
