| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | * | MANDT | Allow NULL? |
| 2 | RECCH01GUID | Generic Key of Adjustment Record for CH01 | varbinary | 16 | 0 | RAW | | No | | REXCAJRECCH01GUID | |
| 3 | PROCESSGUID | Generic Key of Process | varbinary | 16 | 0 | RAW | | Yes | | RECAPROCESSGUID | |
| 4 | INTRENO | Internal Key of Real Estate Object | nvarchar | 13 | 0 | CHAR | (N' ') | Yes | | RECAINTRENO | Allow NULL? |
| 5 | CONDCURR | Currency of condition item | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | RECDCONDCURR | Allow NULL? |
| 6 | MGRBASEREF | Base Value: Reference Interest Rate | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | T056R | REXCAJMGRBASEREF | Allow NULL? |
| 7 | MGRBASEDATE | Base Date for Reference Interest Rate | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | REXCAJMGRBASEDATE | Allow NULL? |
| 8 | MGRBASERATE | Reference Interest Rate for Adjustment | decimal | 10 | 7 | DEC | ((0)) | Yes | | REXCAJMGRBASERATE | |
| 9 | MGRADJMDATE | Adjustment Date of Reference Interest Rate | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | REXCAJMGRADJMDATE | Allow NULL? |
| 10 | MGRADJMRATE | New Reference Interest Rate | decimal | 10 | 7 | DEC | ((0)) | Yes | | REXCAJMGRADJMRATE | |
| 11 | MGRADJMPERCENT | Percentage Rate of Adjustment of Reference Interest Rate | decimal | 5 | 2 | DEC | ((0)) | Yes | | REXCAJMGRADJMPERCENT | |
| 12 | MGRADJMAMOUNT | Absolute Value of Adjustment of Reference Interest Rate | decimal | 15 | 2 | CURR | ((0)) | Yes | | REXCAJMGRADJMAMOUNT | |
| 13 | MOCPERCENTTYPE | Maintenance and Operating Costs Type of Percentage | char | 1 | 0 | CHAR | (N' ') | Yes | | REXCAJMOCPERCENTTYPE | Allow NULL? |
| 14 | MOCBASEINDX | Base Value: Maintenance and Operating Costs as Percentage | decimal | 7 | 4 | DEC | ((0)) | Yes | | REXCAJMOCBASEINDX | |
| 15 | MOCBASEDATE | Base Date for Maintenance and Operating Costs | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | REXCAJMOCBASEDATE | Allow NULL? |
| 16 | MOCBASEPPCINDX | Maintenance and Operating Costs as per LKP: Base Index Level | decimal | 10 | 7 | DEC | ((0)) | Yes | | REXCAJMOCBASEPPCINDX | |
| 17 | MOCADJMDATE | Adjustment Date for Maintenance and Operating Costs | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | REXCAJMOCADJMDATE | Allow NULL? |
| 18 | MOCADJNBMONTH | Number of Months | smallint | 5 | 0 | INT2 | ((0)) | Yes | | REXCAJNUMBERMONTH | |
| 19 | MOCADJMPERCENT | Percentage of Adjustment from Maint. and Operating Costs | decimal | 5 | 2 | DEC | ((0)) | Yes | | REXCAJMOCADJMPERCENT | |
| 20 | MOCADJMPPCINDX | Maintenance and Operating Costs from LKP: New Index Level | decimal | 10 | 7 | DEC | ((0)) | Yes | | REXCAJMOCADJMPPCINDX | |
| 21 | MOCADJMAMOUNT | Absolute Value of Maintenance and Operating Costs Adjustment | decimal | 15 | 2 | CURR | ((0)) | Yes | | REXCAJMOCADJMAMOUNT | |
| 22 | PPCBASESERIES | Base Value: Index Series for Purchasing Power Protection | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | * | REXCAJPPCBASESERIES | Allow NULL? |
| 23 | PPCBASEYEAR | Base Year for Purchasing Power Protection | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | * | REXCAJPPCBASEYEAR | Allow NULL? |
| 24 | PPCBASEDATE | Base Date, Purchasing Power Protection | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | REXCAJPPCBASEDATE | Allow NULL? |
| 25 | PPCBASEINDX | Base Index Level: Purchasing Power Protection | decimal | 10 | 7 | DEC | ((0)) | Yes | | REXCAJPPCBASEINDX | |
| 26 | PPCPRCTPASS | Percentage Passed on of Adj. Based on Purchasing Power Prot. | decimal | 5 | 2 | DEC | ((0)) | Yes | | REXCAJPPCPRCTPASS | |
| 27 | PPCADJMDATE | Adjustment Date for Purchasing Power Protection | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | REXCAJPPCADJMDATE | Allow NULL? |
| 28 | PPCADJMINDX | New Index Level for Purchasing Power Protection | decimal | 10 | 7 | DEC | ((0)) | Yes | | REXCAJPPCADJMINDX | |
| 29 | PPCADJMPERCENT | Percentage of Adjustment from Purchasing Power Protection | decimal | 5 | 2 | DEC | ((0)) | Yes | | REXCAJPPCADJMPERCENT | |
| 30 | PPCADJMAMOUNT | Absolute Val. of Adjustment from Purchasing Power Protection | decimal | 15 | 2 | CURR | ((0)) | Yes | | REXCAJPPCADJMAMOUNT | |
| 31 | RELADJMPERCENT | Effective Adjustment from Relative Factors: Percentage | decimal | 5 | 2 | DEC | ((0)) | Yes | | REXCAJRELADJMPERCENT | |
| 32 | RELADJMAMOUNT | Effective Adjustment from Relative Factors: Absolute Value | decimal | 15 | 2 | CURR | ((0)) | Yes | | REXCAJRELADJMAMOUNT | |
| 33 | ACCOMCONDTYPE | Absolute Factors, Condition Category | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | REXCAJABSBASECONDTYPE | Allow NULL? |
| 34 | ACCOMBASEUPRICE | Absolute Factors, Currency Amount (Gross) Condition Item | decimal | 19 | 6 | DEC | ((0)) | Yes | | REXCAJABSBASEUNITPRICE | |
| 35 | ACCOMVALIDFROM | Date from when condition is valid | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | RECDVALIDFROM | Allow NULL? |
| 36 | YIELDCONDTYPE | Absolute Factors, Condition Category | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | REXCAJABSBASECONDTYPE | Allow NULL? |
| 37 | YIELDBASEUPRICE | Absolute Factors, Currency Amount (Gross) Condition Item | decimal | 19 | 6 | DEC | ((0)) | Yes | | REXCAJABSBASEUNITPRICE | |
| 38 | YIELDVALIDFROM | Date from when condition is valid | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | RECDVALIDFROM | Allow NULL? |
| 39 | WOIINCONDTYPE | Absolute Factors, Condition Category | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | REXCAJABSBASECONDTYPE | Allow NULL? |
| 40 | WOIINBASEUPRICE | Absolute Factors, Currency Amount (Gross) Condition Item | decimal | 19 | 6 | DEC | ((0)) | Yes | | REXCAJABSBASEUNITPRICE | |
| 41 | WOIINVALIDFROM | Date from when condition is valid | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | RECDVALIDFROM | Allow NULL? |
| 42 | ABSREASCOND | Absolute Factors, Adjustment Reason for Condition Category | char | 1 | 0 | NUMC | (N'0') | Yes | | REXCAJABSREASCOND | Allow NULL? |
| 43 | ABSREASAMOUNT | Absolute Method, Adjustment by an Absolute Amount | decimal | 15 | 2 | CURR | ((0)) | Yes | | REXCAJABSREASAMOUNT | |
| 44 | ABSREASPERCENT | Absolute Factors, Adjustment Reason as Percentage | decimal | 5 | 2 | DEC | ((0)) | Yes | | REXCAJABSREASPERCENT | |
| 45 | ABSADJOPTION | Option for an Adjustment Based on Absolute Factors | char | 1 | 0 | CHAR | (N' ') | Yes | | REXCAJABSADJOPTION | Allow NULL? |
| 46 | ABSADJMPERCENT | Absolute Factors, Percentage Rate of Adjustment | decimal | 5 | 2 | DEC | ((0)) | Yes | | REXCAJABSADJPERCENT | |
| 47 | ABSADJMAMOUNT | Absolute Factors, Absolute Value of Adjustment | decimal | 15 | 2 | CURR | ((0)) | Yes | | REXCAJABSADJAMOUNT | |
| 48 | WOIREASCOND | Added Benefits, Adjustment Reason Condition Type | char | 1 | 0 | NUMC | (N'0') | Yes | | REXCAJWOIREASCOND | Allow NULL? |
| 49 | WOIREASAMOUNT | Added Benefits, Adjustment Reason as Absolute Value | decimal | 15 | 2 | CURR | ((0)) | Yes | | REXCAJWOIREASAMOUNT | |
| 50 | WOIREASPERCENT | Added Benefits, Adjustment Reason as Percentage | decimal | 5 | 2 | DEC | ((0)) | Yes | | REXCAJWOIREASPERCENT | |
| 51 | WOIADJMPERCENT | Added Benefits, Percentage of Adjustment | decimal | 5 | 2 | DEC | ((0)) | Yes | | REXCAJWOIADJPERCENT | |
| 52 | WOIADJMAMOUNT | Added Benefits, Absolute Value of Adjustment | decimal | 15 | 2 | CURR | ((0)) | Yes | | REXCAJWOIADJAMOUNT | |
| 53 | ADJCONDABS | Adj.Parameter REL: Adj. Condition Amount for Absolute Method | char | 1 | 0 | NUMC | (N'0') | Yes | | REXCAJADJCONDABS | Allow NULL? |
| 54 | ACCOMADJMUPRICE | Absolute Factors, Currency Amount (Adjust.) Condition Item | decimal | 19 | 6 | DEC | ((0)) | Yes | | REXCAJABSADJMUNITPRICE | |
| 55 | YIELDADJMUPRICE | Absolute Factors, Currency Amount (Adjust.) Condition Item | decimal | 19 | 6 | DEC | ((0)) | Yes | | REXCAJABSADJMUNITPRICE | |
| 56 | WOIINADJMUPRICE | Absolute Factors, Currency Amount (Adjust.) Condition Item | decimal | 19 | 6 | DEC | ((0)) | Yes | | REXCAJABSADJMUNITPRICE | |
| 57 | PARMRELLOW | Handling of Reserve: Option When Net Rent Reduced | char | 1 | 0 | NUMC | (N'0') | Yes | | REXCAJPARMRELLOW | Allow NULL? |
| 58 | PARMRELLOWPRIO1 | Handling of Reserve: Priority When Reducing Net Rent | char | 1 | 0 | NUMC | (N'0') | Yes | | REXCAJPARMRELLOWPRIO | Allow NULL? |
| 59 | PARMRELLOWPRIO2 | Handling of Reserve: Priority When Reducing Net Rent | char | 1 | 0 | NUMC | (N'0') | Yes | | REXCAJPARMRELLOWPRIO | Allow NULL? |
| 60 | RESVAMOUNTPRIO1 | Reserve, Absolute Value Based on Absolute Factors | decimal | 15 | 2 | CURR | ((0)) | Yes | | REXCAJABSRESVAMOUNT | |
| 61 | BASEADJMPRIO1 | Effective Adjustment from Relative Factors: Absolute Value | decimal | 15 | 2 | CURR | ((0)) | Yes | | REXCAJRELADJMAMOUNT | |
| 62 | ADJMPRIO1 | Effective Adjustment from Relative Factors: Absolute Value | decimal | 15 | 2 | CURR | ((0)) | Yes | | REXCAJRELADJMAMOUNT | |
| 63 | RESVAMOUNTPRIO2 | Reserve, Absolute Value Based on Absolute Factors | decimal | 15 | 2 | CURR | ((0)) | Yes | | REXCAJABSRESVAMOUNT | |
| 64 | ADJMPRIO2 | Effective Adjustment from Relative Factors: Absolute Value | decimal | 15 | 2 | CURR | ((0)) | Yes | | REXCAJRELADJMAMOUNT | |
| 65 | FREEVALUEABSINC | Absolute Increase of the Unit Price | decimal | 19 | 6 | DEC | ((0)) | Yes | | REXCAJFREEVALUEABSINC | |
| 66 | FREEVALUEPERCENT | Relative Increase of Unit Price | decimal | 7 | 2 | DEC | ((0)) | Yes | | REXCAJFREEVALUEPERCENT | |
| 67 | FREEADJMPERCENT | Effective Adjustment from Custom Adjustment: Percentage | decimal | 5 | 2 | DEC | ((0)) | Yes | | REXCAJFREEADJMPERCENT | |
| 68 | FREEADJMAMOUNT | Effective Adjustment from Custom Adjustmt: Absolute Value | decimal | 15 | 2 | CURR | ((0)) | Yes | | REXCAJFREEADJMAMOUNT | |
| 69 | FREEADJMTXT | Explanatory Text for Custom Adjustment | nvarchar | 70 | 0 | CHAR | (N' ') | Yes | | REXCAJFREEADJMTXT | Allow NULL? |
| 70 | ADJMTXTDESCRIPT | Explanatory Text 'Description of Change' | nvarchar | 70 | 0 | CHAR | (N' ') | Yes | | REXCAJADJMTXTDESCRIPT | Allow NULL? |
| 71 | ADJMTXTMOMENT | Explanatory Text 'Time at Which Took Effect' | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | REXCAJADJMTXTMOMENT | Allow NULL? |
| 72 | ADJMTXTREASON | Explanatory Text 'Reason for Change' | nvarchar | 70 | 0 | CHAR | (N' ') | Yes | | REXCAJADJMTXTREASON | Allow NULL? |
| 73 | ADJMTXTGUID | GUID (RAW16) | varbinary | 16 | 0 | RAW | | Yes | | RECAGUID | |
