| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | FIPEX | Commitment item (No longer in use -> FM_FIPEX) | nvarchar | 24 | 0 | | | | Allow NULL? |
| 3 | FICTR | Funds Center | nvarchar | 16 | 0 | | | | Allow NULL? |
| 4 | FONDS | Fund | nvarchar | 10 | 0 | | | | Allow NULL? |
| 5 | FAREA | Functional Area | nvarchar | 16 | 0 | | | | Allow NULL? |
| 6 | GJAHR | Fiscal Year | nvarchar | 4 | 0 | | | | Allow NULL? |
| 7 | FIKRS | Financial Management Area | nvarchar | 4 | 0 | | | | Allow NULL? |
| 8 | DATBIS | Number that clearly identifies the line key in database | nvarchar | 16 | 0 | | | | Allow NULL? |
| 9 | DATAB | Number that clearly identifies the line key in database | nvarchar | 16 | 0 | | | | Allow NULL? |
| 10 | DBACTION | Time Interval Handler (CO): Identifier for database activity | char | 1 | 0 | | | | Allow NULL? |
| 11 | TACTION | Time Interval Handler (CO): Identifier for database activity | char | 1 | 0 | | | | Allow NULL? |
| 12 | AENNAME | FIFM: Name of Last Person to Make a Change | nvarchar | 12 | 0 | | | | Allow NULL? |
| 13 | UDECK | Type of revenue increasing budget | char | 1 | 0 | | | | Allow NULL? |
| 14 | EHVMTNR | Budget memo | nvarchar | 10 | 0 | | | | Allow NULL? |
| 15 | AHVMTNR | Budget memo | nvarchar | 10 | 0 | | | | Allow NULL? |
| 16 | UDMETHODE | Process for increasing budget | char | 1 | 0 | | | | Allow NULL? |
| 17 | INCHECK | In budget transfers, check for existing additional revenue | char | 1 | 0 | | | | Allow NULL? |
| 18 | DEAKTIV | Deactivation Indicator | char | 1 | 0 | | | | Allow NULL? |
| 19 | UDPAY | Revenues increasing the payment budget | char | 1 | 0 | | | | Allow NULL? |
| 20 | UDINCTI | Event leading to budget increase | char | 1 | 0 | | | | Allow NULL? |
| 21 | PAYUDINCTI61 | Budget increase by down payment | char | 1 | 0 | | | | Allow NULL? |
| 22 | PAYUDINCTI66 | Budget increase through revenue transfer posting | char | 1 | 0 | | | | Allow NULL? |
| 23 | PAYPROZ83 | % of a Revenue Allotted to Expenditure FM Account Assignment | decimal | 5 | 2 | | | | |
| 24 | PAYPROZ54 | % of a Revenue Allotted to Expenditure FM Account Assignment | decimal | 5 | 2 | | | | |
| 25 | PAYPROZ57 | % of a Revenue Allotted to Expenditure FM Account Assignment | decimal | 5 | 2 | | | | |
| 26 | MINBDGT | Minimum revenue, dependent on current budget | char | 1 | 0 | | | | Allow NULL? |
| 27 | MINPROZ | Minimum revenue in % of current budget | decimal | 5 | 2 | | | | |
| 28 | MININC | Minimum revenue from which the budget is increased | decimal | 15 | 2 | | | | |
| 29 | MAXBDGT | Upper limit dependent on current budget | char | 1 | 0 | | | | Allow NULL? |
| 30 | MAXPROZ | Upper limit in % of current budget | decimal | 5 | 2 | | | | |
| 31 | MAXINC | Maximum to which the budget is increased | decimal | 15 | 2 | | | | |
| 32 | ABSINT | Maximum Difference Between Minimum Revenue and Upper Tol. L | decimal | 15 | 2 | | | | |
| 33 | TOTLINC | Act.revenues increasing the budget for an FM acct assignment | decimal | 15 | 2 | | | | |
| 34 | OVFIPEX | Commitment item (No longer in use -> FM_FIPEX) | nvarchar | 24 | 0 | | | | Allow NULL? |
| 35 | OVFICTR | Funds Center | nvarchar | 16 | 0 | | | | Allow NULL? |
| 36 | OVFONDS | Fund | nvarchar | 10 | 0 | | | | Allow NULL? |
| 37 | OVFAREA | Functional Area | nvarchar | 16 | 0 | | | | Allow NULL? |
| 38 | OVPROZ | % of a Revenue Allotted to Expenditure FM Account Assignment | decimal | 5 | 2 | | | | |
| 39 | UDCOM | Revenues increase commitment budget | char | 1 | 0 | | | | Allow NULL? |
| 40 | COMUDINCTI | Event leading to budget increase | char | 1 | 0 | | | | Allow NULL? |
| 41 | COMUDINCTI61 | Budget increase by down payment | char | 1 | 0 | | | | Allow NULL? |
| 42 | COMUDINCTI66 | Budget increase through revenue transfer posting | char | 1 | 0 | | | | Allow NULL? |
| 43 | COMPROZ83 | % of a Revenue Allotted to Expenditure FM Account Assignment | decimal | 5 | 2 | | | | |
| 44 | COMPROZ54 | % of a Revenue Allotted to Expenditure FM Account Assignment | decimal | 5 | 2 | | | | |
| 45 | COMPROZ57 | % of a Revenue Allotted to Expenditure FM Account Assignment | decimal | 5 | 2 | | | | |
| 46 | COMMINBDGT | Minimum revenue, dependent on current budget | char | 1 | 0 | | | | Allow NULL? |
| 47 | COMMINPROZ | Minimum revenue in % of current budget | decimal | 5 | 2 | | | | |
| 48 | COMMININC | Minimum revenue from which the budget is increased | decimal | 15 | 2 | | | | |
| 49 | COMMAXBDGT | Upper limit dependent on current budget | char | 1 | 0 | | | | Allow NULL? |
| 50 | COMMAXPROZ | Upper limit in % of current budget | decimal | 5 | 2 | | | | |
| 51 | COMMAXINC | Maximum to which the budget is increased | decimal | 15 | 2 | | | | |
| 52 | COMABSINT | Maximum Difference Between Minimum Revenue and Upper Tol. L | decimal | 15 | 2 | | | | |
| 53 | COMTOTLINC | Act.revenues increasing the budget for an FM acct assignment | decimal | 15 | 2 | | | | |
| 54 | COMOVFIPEX | Commitment item (No longer in use -> FM_FIPEX) | nvarchar | 24 | 0 | | | | Allow NULL? |
| 55 | COMOVFICTR | Funds Center | nvarchar | 16 | 0 | | | | Allow NULL? |
| 56 | COMOVFONDS | Fund | nvarchar | 10 | 0 | | | | Allow NULL? |
| 57 | COMOVPROZ | % of a Revenue Allotted to Expenditure FM Account Assignment | decimal | 5 | 2 | | | | |
| 58 | COMOVFAREA | Functional Area | nvarchar | 16 | 0 | | | | Allow NULL? |
| 59 | UDUPD | Usage of increase rule | char | 1 | 0 | | | | Allow NULL? |
| 60 | UDMIN | Minimum revenue increases budget | char | 1 | 0 | | | | Allow NULL? |
