| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | OBJGUID | Reference Within Results Tables | varbinary | 16 | 0 | | | | |
| 3 | INTRENO | Internal Key of Real Estate Object | nvarchar | 13 | 0 | | | | Allow NULL? |
| 4 | TERMTYPE | Term Category | nvarchar | 4 | 0 | | | | Allow NULL? |
| 5 | TERMNO | Term Number | nvarchar | 4 | 0 | | | | Allow NULL? |
| 6 | RHYTHMTYPE | Type of Frequency | nvarchar | 4 | 0 | | | | Allow NULL? |
| 7 | PFROM | Period Start Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 8 | PTO | Period End Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 9 | VERSION | Version of Calculation | nvarchar | 3 | 0 | | | | Allow NULL? |
| 10 | PROCESSGUID | Generic Key of Process | varbinary | 16 | 0 | | | | |
| 11 | PARTNER | Business Partner Number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 12 | PARTNEROBJNR | Object Number for Internal Use | nvarchar | 22 | 0 | | | | Allow NULL? |
| 13 | CONDTYPE | Condition Type | nvarchar | 4 | 0 | | | | Allow NULL? |
| 14 | FLOWTYPE | Flow Type | nvarchar | 4 | 0 | | | | Allow NULL? |
| 15 | CREDITPAYBACK | Credits Withing Cumulative Settlement Are Paid | char | 1 | 0 | | | | Allow NULL? |
| 16 | SALESCURR | Currency Key | nvarchar | 5 | 0 | | | | Allow NULL? |
| 17 | TERMNOPY | Term Number of Posting Rule | nvarchar | 4 | 0 | | | | Allow NULL? |
| 18 | TAXTYPE | Tax Type | nvarchar | 4 | 0 | | | | Allow NULL? |
| 19 | TAXGROUP | Tax Group | nvarchar | 20 | 0 | | | | Allow NULL? |
| 20 | TXJCD | Tax Jurisdiction | nvarchar | 15 | 0 | | | | Allow NULL? |
| 21 | TAXDATE | Date for defining tax rates | nvarchar | 8 | 0 | | | | Allow NULL? |
| 22 | SALESRENTNET | Net Amount of Sales-Based Rent | decimal | 15 | 2 | | | | |
| 23 | SALESRENTTAX | Tax Amount of Sales-Based Rent | decimal | 15 | 2 | | | | |
| 24 | ADVPAYNET | Net Amount of Advanced Payment | decimal | 15 | 2 | | | | |
| 25 | ADVPAYTAX | Tax Amount of Advance Payment | decimal | 15 | 2 | | | | |
| 26 | PAYNET | Net Amount of Payments Already Made | decimal | 15 | 2 | | | | |
| 27 | PAYTAX | Tax Amount from Payments Already Made | decimal | 15 | 2 | | | | |
| 28 | MINRENTNET | Net Amount of Minimum Rent for Sales-Based Rent Contracts | decimal | 15 | 2 | | | | |
| 29 | MINRENTTAX | Tax Amount of Minimum Rent for Sales-Based Rent Contracts | decimal | 15 | 2 | | | | |
| 30 | MAXRENTNET | Net Amount of Maximum Rent for Sales-Based Rent Contracts | decimal | 15 | 2 | | | | |
| 31 | MAXRENTTAX | Tax Amount of Maximum Rent for Sales-Based Rent Contracts | decimal | 15 | 2 | | | | |
| 32 | RECEIVABLENET | Net Amount of Receivable | decimal | 15 | 2 | | | | |
| 33 | RECEIVABLETAX | Tax Amount of Receivable | decimal | 15 | 2 | | | | |
| 34 | BALANCENET | Net Amount of Balance | decimal | 15 | 2 | | | | |
| 35 | BALANCETAX | Tax Amount of Balance | decimal | 15 | 2 | | | | |
| 36 | PREVBALANCENET | Net Amount of Balance from Prior Settlement | decimal | 15 | 2 | | | | |
| 37 | PREVBALANCETAX | Tax Amount of Balance from Prior Settlement | decimal | 15 | 2 | | | | |
| 38 | PREVPAYNET | Net Amount of Payment from Previous Period | decimal | 15 | 2 | | | | |
| 39 | PREVPAYTAX | Tax Amount of Payment from Previous Period | decimal | 15 | 2 | | | | |
| 40 | PREVADVPAYNET | Net Amount of Advance Payments from Previous Period | decimal | 15 | 2 | | | | |
| 41 | PREVADVPAYTAX | Tax Amount of Advance Payments from Previous Period | decimal | 15 | 2 | | | | |
| 42 | PREVMINRENTNET | Net Amount of Minimum Rent from Previous Period | decimal | 15 | 2 | | | | |
| 43 | PREVMINRENTTAX | Tax Amount of Minimum Rent from Previous Period | decimal | 15 | 2 | | | | |
| 44 | PREVMAXRENTNET | Net Amount of Maximum Rent from Previous Period | decimal | 15 | 2 | | | | |
| 45 | PREVMAXRENTTAX | Tax Amount of Maximum Rent from Previous Period | decimal | 15 | 2 | | | | |
| 46 | ISCDSPLIT | Condition Split | char | 1 | 0 | | | | Allow NULL? |
| 47 | INFOCOND | Statistical or Informational Condition | char | 1 | 0 | | | | Allow NULL? |
| 48 | ISGROSS | Condition Amount Is Gross Amount | char | 1 | 0 | | | | Allow NULL? |
| 49 | CTLCGROSSAMOUNT | Gross Amount in Local Currency | decimal | 15 | 2 | | | | |
| 50 | CTLCNETAMOUNT | Net Amount in Local Currency | decimal | 15 | 2 | | | | |
| 51 | CTLCTAXAMOUNT | Tax Amount in Local Currency | decimal | 15 | 2 | | | | |
| 52 | CTLCCURRKEY | Local Currency | nvarchar | 5 | 0 | | | | Allow NULL? |
| 53 | CTRULE | Currency Translation Rule | nvarchar | 20 | 0 | | | | Allow NULL? |
| 54 | CTRATE | Exchange Rate | decimal | 9 | 5 | | | | |
| 55 | CTDATEACT | Actual Translation Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 56 | CTLCPOST | Post in Local Currency | char | 1 | 0 | | | | Allow NULL? |
| 57 | POSTCDCURR | Post in Condition Currency | char | 1 | 0 | | | | Allow NULL? |
| 58 | CONDGUID | GUID (RAW16) for Conditions | varbinary | 16 | 0 | | | | |
| 59 | USECF4POST | Use Periodic Posting Run for Posting | char | 1 | 0 | | | | Allow NULL? |
| 60 | BASICFEENET | Net Amount of Base Fee | decimal | 15 | 2 | | | | |
| 61 | BASICFEETAX | Tax Amount of Base Fee | decimal | 15 | 2 | | | | |
| 62 | PREVBASICFEENET | Net Amount of Base Fee from Previous Period | decimal | 15 | 2 | | | | |
| 63 | PREVBASICFEETAX | Tax Amount of Base Fee from Previous Period | decimal | 15 | 2 | | | | |
