| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | FCBELNR | Document Number for Earmarked Funds | nvarchar | 10 | 0 | | | | Allow NULL? |
| 3 | FCBLPOS | Earmarked Funds: Document Item | nvarchar | 3 | 0 | | | | Allow NULL? |
| 4 | RFIPOS | Receiver commitment item for payments | nvarchar | 14 | 0 | | | | Allow NULL? |
| 5 | RFICTR | Receiver funds center for payments | nvarchar | 16 | 0 | | | | Allow NULL? |
| 6 | RFONDS | Receiver fund for payments | nvarchar | 10 | 0 | | | | Allow NULL? |
| 7 | RFAREA | Functional Area | nvarchar | 16 | 0 | | | | Allow NULL? |
| 8 | RESTHMK | Checkbox | char | 1 | 0 | | | | Allow NULL? |
| 9 | BUART | Value Type | nvarchar | 2 | 0 | | | | Allow NULL? |
| 10 | FIKRS | Financial Management Area | nvarchar | 4 | 0 | | | | Allow NULL? |
| 11 | BGGJAHR | Fiscal Year | nvarchar | 4 | 0 | | | | Allow NULL? |
| 12 | BGPERIO | Period | nvarchar | 3 | 0 | | | | Allow NULL? |
| 13 | INCFIPOS | Sender commitment item | nvarchar | 14 | 0 | | | | Allow NULL? |
| 14 | INCFICTR | Sender funds center | nvarchar | 16 | 0 | | | | Allow NULL? |
| 15 | INCFONDS | Sender fund | nvarchar | 10 | 0 | | | | Allow NULL? |
| 16 | INCFAREA | Functional Area | nvarchar | 16 | 0 | | | | Allow NULL? |
| 17 | ERHPROZ | % of a Revenue Allotted to Expenditure FM Account Assignment | decimal | 5 | 2 | | | | |
| 18 | ERHBTR | Amount of increase in expenditure budget | decimal | 15 | 2 | | | | |
| 19 | SUMBGBTR | Amount in FM area currency | decimal | 13 | 2 | | | | |
| 20 | OLDFIPOS | Old commitment item initiating | nvarchar | 14 | 0 | | | | Allow NULL? |
| 21 | OLDFICTR | Old funds center originating | nvarchar | 16 | 0 | | | | Allow NULL? |
| 22 | OLDFONDS | Old fund initiating | nvarchar | 10 | 0 | | | | Allow NULL? |
| 23 | STATUS | Document Status: Revenues Increasing the Budget | char | 1 | 0 | | | | Allow NULL? |
| 24 | DATAB | Number that clearly identifies the line key in database | nvarchar | 16 | 0 | | | | Allow NULL? |
| 25 | TWAER | Transaction Currency | nvarchar | 5 | 0 | | | | Allow NULL? |
| 26 | OLDFAREA | Pegged Old Functional Area | nvarchar | 16 | 0 | | | | Allow NULL? |