FARR_D_CONTRACT - Contracts

Contracts information is stored in SAP table FARR_D_CONTRACT.
It is part of development package FARR_CONTRACT_DB in software component FI-RA. This development package consists of objects that can be grouped under "Revenue Accounting: Contract Management Persistence".

Fields for table FARR_D_CONTRACT

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
CLIENT	Client	X	MANDT	CLNT	6
CONTRACT_ID	Revenue Accounting Contract ID	X	FARR_CONTRACT_ID	CHAR	28
.INCLUDE				FARR_S_CONTRACT_ATTR	0
.INCLUDE				FARR_S_CONTRACT_MAIN	0
CONTRACT_CAT	Contract Category		FARR_CONTRACT_CATEGORY	CHAR	8
CUSTOMER_GRP	Group key		KONZS	CHAR	20
ACCT_PRINCIPLE	Accounting Principle		ACCOUNTING_PRINCIPLE	CHAR	8	*
DESCRIPTION	Description of Revenue Accounting Items		FARR_DESCRIPTION	CHAR	120
CONTR_CREATED_ON	The datetime for contract created		FARR_CONTR_CREATED_ON	DEC	8
.INCLUDE	ENH_CONTR_HDR			INCL_EEW_FARR_CONTRACT	0
CONTR_EEW_DUMMY	Custom Fields: Dummy for Use in Extension Includes		CFD_DUMMY	CHAR	2
IS_BLOCKED	Is Blocked		FARR_DPP_IS_BLOCKED	CHAR	2
.INCLUDE				FARR_S_CONTRACT_ATTR_EX	0
NUM_OF_POB	Number of Performance Obligations		FARR_NUM_OF_POB	INT4	4
CUSTOMER_ID	Customer Number		KUNNR	CHAR	20
PARTNER	Business Partner Number		BU_PARTNER	CHAR	20
VALOBJTYPE	Type of the Financial Valuation Object		VAL_OBJ_TYPE	CHAR	8	*
TRX_PRICE	Contractual Price		FARR_TRANSACTION_PRICE	CURR	13
TRX_PRICE_CURK	Currency Key		WAERS	CUKY	10	*
STATUS	Contract Status		FARR_CONTRACT_STATUS	CHAR	2
VALIDATE_RESULT	Validation Result		FARR_VALIDATE_RESULT	CHAR	2
MANUAL_CREATED	Manually Created		FARR_MANUAL_CREATED	CHAR	2
MANUAL_CHANGED	Manually Changed		FARR_MANUAL_CHANGED	CHAR	2
MANUAL_DELETED	Manually Deleted		FARR_MANUAL_DELETED	CHAR	2
MANUAL_ALLOCATED	Price was allocated manually on the Contract		FARR_MANUAL_PRICE_ALLOC	CHAR	2
SOFT_DELETED	Soft Deleted		FARR_SOFT_DELETED	CHAR	2
PRICE_ADJUSTED	Allocation Effect Exists in the Contract		FARR_PRICE_ADJUST_FLAG	CHAR	2
COMPANY_CODE	Company Code		BUKRS	CHAR	8
SALES_ORG	Sales Organization for Revenue Accounting		FARR_SALES_ORG	CHAR	40
ALLOC_DIFFER	Contract Allocation Effect		FARR_ALLOC_DIFFERENCE	CURR	12
MANUAL_PRICE_ALLOC_CONFLICT	Contract has manual price allocation conflict		FARR_MNL_PRICE_ALLOC_CONFLICT	CHAR	2
PENDING_CONFLICT	Pending Conflict Resolution		FARR_PENDING_CONFLICT	CHAR	2
RECEIVABLE_ACCOUNT	Receivables Account		FARR_RECEIV_ACCOUNT	CHAR	20
RECEI_ADJ_ACCOUNT	Receivable Adjustment Account		FARR_RECE_ADJ_ACCT	CHAR	20	*
ASSET_ACCOUNT	Contract Asset Account		FARR_ASSET_ACCOUNT	CHAR	20	*
LIABILITY_ACCOUNT	Contract Liability Account		FARR_LIABILITY_ACCOUNT	CHAR	20	*
REFUND_LIABILITY_ACCT	Refund Liability Account		FARR_REFUND_LIABILITY	CHAR	20
REFUND_ASSET_ACCOUNT	Refund Asset Account		FARR_REFUND_ASSET_ACCOUNT	CHAR	20
ASSET_IMPAIRMENT_ACCOUNT	Contract Termination Expense (Loss) Account		FARR_ASSET_IMPAIRMENT_ACCOUNT	CHAR	20	*
HAS_TM_POB	With Time-Based POB or Event-based POB with Rights of Return		FARR_HAS_TM_POB	CHAR	2
COMPLETION_DATE	Completion Date		FARR_COMPLETION_DATE	DATS	16
LIABILITY_POST_MODE	Level for Posting Liabilities and Assets to Posting Table		FARR_LIABILITY_POST_MODE	CHAR	2
LC_CALC_METHOD	Local Currency Calculation Method		FARR_LC_CALC_METHOD	CHAR	2
ROUNDING_TS	Timestemp for calculating rounding		FARR_ROUNDING_TS	DEC	8
FIXED_EX_RATE_DATE	The date is used to fix exchange rate		FARR_FIXED_EX_RATE_DATE	DATS	16
LIAB_METHOD	Contract Balance Presentation		FARR_CREATE_LIABILITY_METHOD	CHAR	2
ASSET_IMPAIRMENT_DATE	Date on which the contract was terminated early		FARR_ASSET_IMPAIRMENT_DATE	DATS	16
RAR_VERSION_CODE	RAR version code		FARR_RAR_VERSION_CODE	CHAR	2
CCM_OCM_RECON_KEY	Reconciliation Key for a Contract in a Revenue Acctg. Period		FARR_RECON_KEY	CHAR	28
LAST_SAVED_ON	UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)		TIMESTAMPL	DEC	11
POSTING_MODE	Posting Mode		FARR_POSTING_MODE	CHAR	2
.INCLUDE				FARR_S_EXCHANGE_RATES	0
EXCHANGE_RATE	Exchange rate		KURSF	DEC	5
EXCHANGE_RATE2	Exchange Rate for the Second Local Currency		KURS2	DEC	5
EXCHANGE_RATE3	Exchange Rate for the Third Local Currency		KURS3	DEC	5
.INCLUDE				FARR_S_ADMIN	0
.INCLUDE				FARR_S_ADMIN_CREATE	0
CREATED_BY	Name of Person Responsible for Creating the Object		ERNAM	CHAR	24
CREATED_ON	Date on which the record was created		ERDAT	DATS	16
.INCLUDE				FARR_S_ADMIN_CHANGE	0
LAST_CHANGED_BY	Name of Person Who Changed Object		AENAM	CHAR	24
LAST_CHANGED_ON	Last Changed On		FARR_LAST_CHANGE_ON	DATS	16