CMR_ACCR_RECONC_SUMMARY

This table stores net accrual amount balance for CMR and Accounts Payable posted to SLA for an accrual account, bill to business unit and profit center business unit combination. Also, this table maintains the net accrual balance for less than and greater than 90 days range.

Details

• Schema: FUSION

• Object owner: CMR

• Object type: TABLE

• Tablespace: DEFAULT

Primary Key

Name	Columns
CMR_ACCR_RECONC_SUMMARY_PK	ACCRUAL_ACCOUNT_ID, BILL_TO_BUSINESS_UNIT_ID, BUSINESS_UNIT_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
ACCRUAL_ACCOUNT_ID	NUMBER		18	Yes	Accrual account identifier - this account is from SLA table where user posted accrual against this account.
BILL_TO_BUSINESS_UNIT_ID	NUMBER		18	Yes	Bill to business unit identifier where invoice is created.
BUSINESS_UNIT_ID	NUMBER		18	Yes	Profit center business unit where accounting entry will be created.
CHART_OF_ACCOUNTS_ID	NUMBER		18	Yes	Key flex field structure instance defining column, foreign key to GL_CODE_COMBINATIONS table.
ACCRUAL_BALANCE	NUMBER				Total accrual clearing amount. Net difference between total receipt and total invoice accrual amounts.
CURRENCY_CODE	VARCHAR2	15			Indicates the general ledger currency code of the accrual account.
RECEIPT_BALANCE	NUMBER				Net posted accrual amount by CMR to SLA.
INVOICE_BALANCE	NUMBER				Net posted accrual amount by Account Payables to SLA.
AGE_RANGE1_BALANCE	NUMBER				Net accrual balance less than 90 days.
AGE_RANGE2_BALANCE	NUMBER				Net accrual balance greater than 90 days.
LAST_PROCESS_RUN_DATE	TIMESTAMP				Indicates last run date of the Match Receipt Accruals process.
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created the row.
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of the row.
LAST_UPDATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the last update of the row.
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.
JOB_DEFINITION_NAME	VARCHAR2	100			Enterprise Service Scheduler: indicates the name of the job that created or last updated the row.
JOB_DEFINITION_PACKAGE	VARCHAR2	900			Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row.
REQUEST_ID	NUMBER		18		Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.

Indexes

Index	Uniqueness	Tablespace	Columns
CMR_ACCR_RECONC_SUMMARY_U1	Unique	DEFAULT	ACCRUAL_ACCOUNT_ID, BILL_TO_BUSINESS_UNIT_ID, BUSINESS_UNIT_ID