| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | OPBEL | Number of Contract Accts Rec. & Payable Doc. | nvarchar | 12 | 0 | | | | Allow NULL? |
| 3 | CTYPE | Cost Type/Revenue Type | nvarchar | 4 | 0 | | | | Allow NULL? |
| 4 | XGUID | UUID in X form (binary) | varbinary | 16 | 0 | | | | |
| 5 | OPUPZ | Subitem for Trigger Item | nvarchar | 3 | 0 | | | | Allow NULL? |
| 6 | OPUPK | Item number in contract account document | nvarchar | 4 | 0 | | | | Allow NULL? |
| 7 | PDATE | Transfer Posting Date for Delayed Revenues | nvarchar | 8 | 0 | | | | Allow NULL? |
| 8 | PDATR | Actual Transfer Posting Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 9 | BUKRS | Company Code | nvarchar | 4 | 0 | | | | Allow NULL? |
| 10 | BETRH | Amount In Local Currency With +/- Signs | decimal | 13 | 2 | | | | |
| 11 | BETRW | Amount in Transaction Currency with +/- Sign | decimal | 13 | 2 | | | | |
| 12 | BETR2 | Amount in second parallel currency with +/- sign | decimal | 13 | 2 | | | | |
| 13 | BETR3 | Amount in third parallel currency with +/- sign | decimal | 13 | 2 | | | | |
| 14 | BETRW_TRIG | Reported Amount in Transaction Currency with Sign (+/-) | decimal | 13 | 2 | | | | |
| 15 | BETRHA | Remaining Amount in Local Currency with Sign (+/-) | decimal | 13 | 2 | | | | |
| 16 | BETRA | Remaining Amount on Deferred Revenues Account | decimal | 13 | 2 | | | | |
| 17 | BETR2A | Remaining Amount in Second Parallel Currency with Sign (+/-) | decimal | 13 | 2 | | | | |
| 18 | BETR3A | Remaining Amount in Third Parallel Currency with Sign (+/-) | decimal | 13 | 2 | | | | |
| 19 | WAERS | Currency Key | nvarchar | 5 | 0 | | | | Allow NULL? |
| 20 | MENGE | Quantity | decimal | 13 | 3 | | | | |
| 21 | MENGE_TRIG | Reported Quantity | decimal | 13 | 3 | | | | |
| 22 | MEINS | Base Unit of Measure | nvarchar | 3 | 0 | | | | Allow NULL? |
| 23 | MWSKZ | Tax on sales/purchases code | nvarchar | 2 | 0 | | | | Allow NULL? |
| 24 | VBUND | Company ID | nvarchar | 6 | 0 | | | | Allow NULL? |
| 25 | HKONT_DR | G/L Account (Deferred Revenues) | nvarchar | 10 | 0 | | | | Allow NULL? |
| 26 | GSBER_DR | Business Area (Deferred Revenues) | nvarchar | 4 | 0 | | | | Allow NULL? |
| 27 | HKONT | General ledger account | nvarchar | 10 | 0 | | | | Allow NULL? |
| 28 | GSBER | Business Area | nvarchar | 4 | 0 | | | | Allow NULL? |
| 29 | SEGMENT | Segment for Segmental Reporting | nvarchar | 10 | 0 | | | | Allow NULL? |
| 30 | PRCTR | Profit Center | nvarchar | 10 | 0 | | | | Allow NULL? |
| 31 | KOSTL | Cost Center | nvarchar | 10 | 0 | | | | Allow NULL? |
| 32 | KDAUF | Sales Order Number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 33 | KDPOS | Item Number in Sales Order | nvarchar | 6 | 0 | | | | Allow NULL? |
| 34 | KDEIN | Delivery Schedule for Sales Order | nvarchar | 4 | 0 | | | | Allow NULL? |
| 35 | PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | nvarchar | 8 | 0 | | | | Allow NULL? |
| 36 | PAOBJNR | Profitability Segment Number (CO-PA) | nvarchar | 10 | 0 | | | | Allow NULL? |
| 37 | AUFNR | Order Number | nvarchar | 12 | 0 | | | | Allow NULL? |
| 38 | KONTL | Acct assnmnt string for industry-specific account assngments | nvarchar | 50 | 0 | | | | Allow NULL? |
| 39 | KONTT | Account Assignment Category | nvarchar | 2 | 0 | | | | Allow NULL? |
| 40 | BUPLA | Business Place | nvarchar | 4 | 0 | | | | Allow NULL? |
| 41 | NEGBU | Control Field for Negative Posting | char | 1 | 0 | | | | Allow NULL? |
| 42 | LAUFD | Date ID | nvarchar | 8 | 0 | | | | Allow NULL? |
| 43 | LAUFI | Additional Identification Characteristic | nvarchar | 6 | 0 | | | | Allow NULL? |
| 44 | FIKEY | Reconciliation Key for General Ledger | nvarchar | 12 | 0 | | | | Allow NULL? |
| 45 | STFLG | Reversal indicator for delayed revenue transfer postings | char | 1 | 0 | | | | Allow NULL? |
| 46 | POSTED | Trigger Transferred to General Ledger | char | 1 | 0 | | | | Allow NULL? |
| 47 | SATYP | Record Type of Trigger for Deferred Revenues | char | 1 | 0 | | | | Allow NULL? |
| 48 | ACCHG | General Ledger Account Swapped by Aperiodic Posting | char | 1 | 0 | | | | Allow NULL? |
| 49 | INVDOCNO | Number of Invoicing Document | nvarchar | 12 | 0 | | | | Allow NULL? |
| 50 | REF03 | Reference Key 3 (Event-Based Deferred Revenues) | nvarchar | 35 | 0 | | | | Allow NULL? |
| 51 | ORIGN | Origin of Information (Event-Based Deferred Revenues) | nvarchar | 2 | 0 | | | | Allow NULL? |
| 52 | EVDAT | Date of Event Message (Event-Based Deferred Revenues) | decimal | 15 | 0 | | | | |
| 53 | OPBEL_WOFF | Number of Write-Off Document | nvarchar | 12 | 0 | | | | Allow NULL? |
| 54 | ASSKY | Assignment Key | nvarchar | 30 | 0 | | | | Allow NULL? |
| 55 | VKONT | Contract Account Number | nvarchar | 12 | 0 | | | | Allow NULL? |
| 56 | HKONT_DR_FSTAT | Character Field Length = 10 | nvarchar | 10 | 0 | | | | Allow NULL? |
| 57 | TXJCD | Tax Jurisdiction | nvarchar | 15 | 0 | | | | Allow NULL? |
| 58 | QTY_UNIT | Base Unit of Measure | nvarchar | 3 | 0 | | | | Allow NULL? |
| 59 | QUANTITY | Billing Quantity | decimal | 31 | 14 | | | | |
| 60 | QUANTITY_REM | Billing Quantity of Remaining Billable Item | decimal | 31 | 14 | | | | |
| 61 | QUANTITY_TRIG | Billing Quantity | decimal | 31 | 14 | | | | |
| 62 | ACCDET_BY_EVENT | Event-Based Account Determination for Revenue Recognition | char | 1 | 0 | | | | Allow NULL? |
