| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | CONDGUID | GUID (RAW16) for Conditions | varbinary | 16 | 0 | | | | |
| 3 | INTRENO | Internal Key of Real Estate Object | nvarchar | 13 | 0 | | | | Allow NULL? |
| 4 | OBJNR | Object Number for Calculation | nvarchar | 22 | 0 | | | | Allow NULL? |
| 5 | RERF | Entered by | nvarchar | 12 | 0 | | | | Allow NULL? |
| 6 | DERF | First Entered on | nvarchar | 8 | 0 | | | | Allow NULL? |
| 7 | TERF | Time of Initial Entry | nvarchar | 6 | 0 | | | | Allow NULL? |
| 8 | REHER | Source of initial entry | nvarchar | 10 | 0 | | | | Allow NULL? |
| 9 | RBEAR | Employee ID | nvarchar | 12 | 0 | | | | Allow NULL? |
| 10 | DBEAR | Last Edited on | nvarchar | 8 | 0 | | | | Allow NULL? |
| 11 | TBEAR | Last Edited at | nvarchar | 6 | 0 | | | | Allow NULL? |
| 12 | RBHER | Editing Source | nvarchar | 10 | 0 | | | | Allow NULL? |
| 13 | CONDCURR | Currency of condition item | nvarchar | 5 | 0 | | | | Allow NULL? |
| 14 | EXDUEDATE | Different Due Date of One-Time Condition | nvarchar | 8 | 0 | | | | Allow NULL? |
| 15 | DUEDATEUP | Due Date for Follow-Up Postings | nvarchar | 8 | 0 | | | | Allow NULL? |
| 16 | OBJNRDIST | Object Number for Distribution | nvarchar | 22 | 0 | | | | Allow NULL? |
| 17 | INVALIDCALC | Calculation Invalid | char | 1 | 0 | | | | Allow NULL? |
| 18 | INVALIDDIST | Distribution Is Invalid | char | 1 | 0 | | | | Allow NULL? |
| 19 | TERMNOPY | Number of Posting Term | nvarchar | 4 | 0 | | | | Allow NULL? |
| 20 | TERMNORH | Number of Frequency Term | nvarchar | 4 | 0 | | | | Allow NULL? |
| 21 | TERMNOAJ | Number of Adjustment Term | nvarchar | 4 | 0 | | | | Allow NULL? |
| 22 | TERMNOOA | Number of Organizational Assignment Term | nvarchar | 4 | 0 | | | | Allow NULL? |
| 23 | TERMNOSR | Number of Sales Term | nvarchar | 4 | 0 | | | | Allow NULL? |
| 24 | TERMNOMR | Number of Peak Sales Term | nvarchar | 4 | 0 | | | | Allow NULL? |
| 25 | TERMNOWT | Number of Withholding Tax Term | nvarchar | 4 | 0 | | | | Allow NULL? |
| 26 | TERMNOPYSCS | Service Charge Settlement Posting Term | nvarchar | 4 | 0 | | | | Allow NULL? |
| 27 | TERMNOPYSCSACT | Posting Term for Service Charge Settlement Is Active | char | 1 | 0 | | | | Allow NULL? |
| 28 | DUEDATECORR | Total Number of Days Due Date Is Corrected | int | 10 | 0 | | | | Allow NULL? |
| 29 | DUEDATECORRDAY | Number of Days for Correcting Due Date | int | 10 | 0 | | | | Allow NULL? |
| 30 | DUEDATECORRMONTH | Number of Months for Correcting Due Date | int | 10 | 0 | | | | Allow NULL? |
| 31 | CONDDELETE | Deletion Indicator for Condition | char | 1 | 0 | | | | Allow NULL? |
| 32 | CFPOSTINGFROM | First Posting From | nvarchar | 8 | 0 | | | | Allow NULL? |
| 33 | CONDTYPE | Condition Type | nvarchar | 4 | 0 | | | | Allow NULL? |
| 34 | CONDVALIDFROM | Date from when condition is valid | nvarchar | 8 | 0 | | | | Allow NULL? |
| 35 | CONDVALIDTO | Date up to when condition is valid | nvarchar | 8 | 0 | | | | Allow NULL? |
| 36 | UNIQUECOND | Condition Is One-Time Condition | char | 1 | 0 | | | | Allow NULL? |
| 37 | INFOCOND | Statistical or Informational Condition | char | 1 | 0 | | | | Allow NULL? |
| 38 | UNITPRICE | Unit Price | decimal | 19 | 6 | | | | |
| 39 | CALCRULE | Calculation Formula | nvarchar | 4 | 0 | | | | Allow NULL? |
| 40 | CALCRULEPARA1 | Untypified Parameter for a Calculation Formula | nvarchar | 70 | 0 | | | | Allow NULL? |
| 41 | CALCRULEPARA2 | Untypified Parameter for a Calculation Formula | nvarchar | 70 | 0 | | | | Allow NULL? |
| 42 | DISTRULE | Distribution Formula | nvarchar | 4 | 0 | | | | Allow NULL? |
| 43 | DISTRULEPARA1 | Untypified Parameter for a Distribution Formula | nvarchar | 70 | 0 | | | | Allow NULL? |
| 44 | DISTRULEPARA2 | Untypified Parameter for a Distribution Formula | nvarchar | 70 | 0 | | | | Allow NULL? |
| 45 | OBJTYPEDISTDIST | Object Type for Distribution | char | 1 | 0 | | | | Allow NULL? |
| 46 | OBJTYPEDISTPOST | Object Type for Posting | char | 1 | 0 | | | | Allow NULL? |
| 47 | CONDPURPOSEEXT | Conditions - External Purpose | nvarchar | 4 | 0 | | | | Allow NULL? |
| 48 | CHGREASON | Reason for Change | nvarchar | 10 | 0 | | | | Allow NULL? |
| 49 | OBJNRCALCPARA | Object Number in Calculation/Distribution Parameter | nvarchar | 22 | 0 | | | | Allow NULL? |
| 50 | OBJNRDISTPARA | Object Number in Calculation/Distribution Parameter | nvarchar | 22 | 0 | | | | Allow NULL? |
