CMR_PO_ACCRUAL_AMTS_GT
This table stores accrual amounts for current run and previous run for same period for all PO distirbutions
Details
-
Schema: FUSION
-
Object owner: CMR
-
Object type: TABLE
-
Tablespace: TRANSACTION_TABLES
Columns
Name | Datatype | Precision | Not-null | Comments | Status |
---|---|---|---|---|---|
RUN_ID | NUMBER | 18 | Yes | Process run identifier and it is surrogate key column. | Active |
RUN_PERIOD_ID | NUMBER | 18 | Yes | Period identifier of the GL period and refers to {GL_PERIOD_STATUSES.EFFECTIVE_PERIOD_NUM} | Active |
CMR_PO_DISTRIBUTION_ID | NUMBER | 18 | Yes | Single column FK: Identifies entity in Receipt accounting PO Distributions. This value will exist for match to PO as well as match to Receipt cases. | |
BUSINESS_UNIT_ID | NUMBER | 18 | business unit identifier where invoice is created and accrual is accounted | ||
ACCRUAL_QTY | NUMBER | uninvoiced accrual quantity of Purchase order distribution for a specific run. | Active | ||
ACCRUAL_AMT | NUMBER | uninvoiced accrual amount of Purchase order distribution for a specific run. | Active | ||
NONRECOVERABLE_TAX | NUMBER | Stores the non-recoverable tax amount for a purchase order distribution | |||
TAX_EXCLUDE_ACCRUAL_AMOUNT | NUMBER | Accrual amount without any taxes | |||
ENCUMBRANCE_REVERSAL_ENTR_AMT | NUMBER | Encumbrance Reversal Amount for purchase order and used for encumbrance accounting only. |