| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
---|
| 1 | CLIENT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | FM_AREA | Financial Management Area | nvarchar | 4 | 0 | | | | Allow NULL? |
| 3 | CRTUSER | Author of the Session Variant | nvarchar | 12 | 0 | | | | Allow NULL? |
| 4 | DOCNR | Sesion variant name for Multiple Budget Entry | nvarchar | 10 | 0 | | | | Allow NULL? |
| 5 | PROCESS_UI | Budgeting Process | nvarchar | 4 | 0 | | | | Allow NULL? |
| 6 | FISCYEAR | Fiscal Year | nvarchar | 4 | 0 | | | | Allow NULL? |
| 7 | VERSION | Budget version | nvarchar | 3 | 0 | | | | Allow NULL? |
| 8 | CRTDATE | Date on which the object was created or updated | nvarchar | 8 | 0 | | | | Allow NULL? |
| 9 | CRTTIME | Time at which the object was created or updated | nvarchar | 6 | 0 | | | | Allow NULL? |
| 10 | DOCDATE | Document Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 11 | POSTDATE | Posting Date in the Document | nvarchar | 8 | 0 | | | | Allow NULL? |
| 12 | RESPPERS | Person Responsible for Planning/Budgeting | nvarchar | 20 | 0 | | | | Allow NULL? |
| 13 | TEXT50 | Header Text for Budget Entry Document | nvarchar | 50 | 0 | | | | Allow NULL? |
| 14 | TEXTNAME | Text Name | nvarchar | 32 | 0 | | | | Allow NULL? |
| 15 | LTXT_IND | Long Text Exists | char | 1 | 0 | | | | Allow NULL? |
| 16 | LAYOUTVAR | Layout Variant ID | nvarchar | 6 | 0 | | | | Allow NULL? |
| 17 | DOCTYPE | Budget entry document type | nvarchar | 4 | 0 | | | | Allow NULL? |
| 18 | COHORT | Reporting Year for Cohort | nvarchar | 4 | 0 | | | | Allow NULL? |
| 19 | PUBLAW | Public Law Cited | nvarchar | 20 | 0 | | | | Allow NULL? |
| 20 | LEGIS | Type of Legislation | char | 1 | 0 | | | | Allow NULL? |
| 21 | TRANSFER_AGENCY | Transfer Agency | nvarchar | 2 | 0 | | | | Allow NULL? |
| 22 | TRANSFER_ACCOUNT | Transfer Account | nvarchar | 4 | 0 | | | | Allow NULL? |
| 23 | RCOMP | Company ID of trading partner | nvarchar | 6 | 0 | | | | Allow NULL? |
| 24 | BUDTYPE | Budget Type | nvarchar | 4 | 0 | | | | Allow NULL? |
| 25 | VALTYPE | BCS Value Type | nvarchar | 2 | 0 | | | | Allow NULL? |
| 26 | DISTKEY | Distribution Key | nvarchar | 4 | 0 | | | | Allow NULL? |
| 27 | ADDITIVE_MODE | Additive mode On / Off | nvarchar | 3 | 0 | | | | Allow NULL? |
| 28 | DOCSTATE | Status of a budget entry document | char | 1 | 0 | | | | Allow NULL? |
| 29 | ALV_LAYOUT | Layout | nvarchar | 12 | 0 | | | | Allow NULL? |
| 30 | CRTUSER_MASTER | Creator of the Template for Easy Mutliple Budget Entry | nvarchar | 12 | 0 | | | | Allow NULL? |
| 31 | SESSION_MASTER | Template Name for Easy Multiple Budget Entry | nvarchar | 10 | 0 | | | | Allow NULL? |
| 32 | FMFGUS_KEY | United States Federal Government Fields | nvarchar | 22 | 0 | | | | Allow NULL? |