| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| 1 | FARR_D_CONTRACT | Contract | 2 | CONTRACT_ID | Revenue Recognition Contract ID | nvarchar | 14 | 0 | | |
| 2 | FARR_D_CONT_ERR | Log Message of Contract Error | 2 | CONTRACT_ID | Revenue Recognition Contract ID | nvarchar | 14 | 0 | | |
| 3 | FARR_D_DEFITEM | Deferral item table | 6 | CONTRACT_ID | Revenue Recognition Contract ID | nvarchar | 14 | 0 | | |
| 4 | FARR_D_EV_CONTR | Contract Table with Event Occuring | 5 | CONTRACT_ID | Revenue Recognition Contract ID | nvarchar | 14 | 0 | | |
| 5 | FARR_D_MAPPING | Mapping Table to map source document to POBs of RA-Contracts | 8 | CONTRACT_ID | Revenue Recognition Contract ID | nvarchar | 14 | 0 | | |
| 6 | FARR_D_POB | Performance Obligation | 44 | CONTRACT_ID | Revenue Recognition Contract ID | nvarchar | 14 | 0 | | |
| 7 | FARR_D_POB_HIS | History table for POB/Contract Structure Change | 5 | CONTRACT_ID | Revenue Recognition Contract ID | nvarchar | 14 | 0 | | |
| 8 | FARR_D_POSTING | Posting table | 18 | CONTRACT_ID | Revenue Recognition Contract ID | nvarchar | 14 | 0 | | |
| 9 | T7UNPF_HR_CNTRC | Contract details | 8 | CONTRACT_ID | Contarct ID | nvarchar | 15 | 0 | | |
| TOPBank |
| 10 | SEPA_MANDATE | SEPA Mandate | 71 | CONTRACT_ID | BKK: SEPA Mandate Contract ID | nvarchar | 50 | 0 | | |
| TOPBusiness Partner |
| 11 | BPTC03 | Contract - Role Category Link in Total Commitment | 6 | CONTRACT_ID | Contract Number | nvarchar | 70 | 0 | | |
| TOPIncentive and Commission Management ICM |
| 12 | CACS_CONTR | Standard/Individual (or Obsolete) Commission Contracts | 4 | CONTRACT_ID | Contract identification key | nvarchar | 20 | 0 | | |
| TOPPerishables Procurement |
| 13 | FIP_D_CONTR | Contract Data | 5 | CONTRACT_ID | Purchasing Document Number | nvarchar | 10 | 0 | | |
| TOPSAP Business Partner |
| 14 | HRPADIC | Additional Data PADD2 | 5 | CONTRACT_ID | Contract identification key | nvarchar | 20 | 0 | | |
| 15 | ISIS_CNT_DUMMY | Dummy Table for Search Help ISIS_CONTRACT_F4_INCL | 5 | CONTRACT_ID | Contract identification key | nvarchar | 20 | 0 | | |
