AR_MFAR_CM_PRO_GT
AR_MFAR_CM_PRO_GT is a temporary table that contains multi-fund proration accounting data for credit memos. This table is truncated on commit.
Details
-
Schema: FUSION
-
Object owner: AR
-
Object type: TABLE
-
Tablespace: Default
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| ENTITY_ID | NUMBER | 18 | Entity identifier. | ||
| RECEIVABLE_APPLICATION_ID | NUMBER | 18 | Yes | Receivable application identifier. | |
| LINE_ID | NUMBER | 18 | Yes | Unique identifier for rows in table AR_DISTRIBUTIONS_ALL - primarily when these rows are passed to general ledger. | |
| AMOUNT | NUMBER | Amount in the entered currency. | |||
| ACCTD_AMOUNT | NUMBER | Amount in the ledger currency. | |||
| FROM_AMOUNT | NUMBER | Distribution amount in the entered currency. | |||
| FROM_ACCTD_AMOUNT | NUMBER | Distribution amount in the ledger currency. | |||
| THIRD_PARTY_ID | NUMBER | 18 | Bill-to customer identifier for transactions; paid-from customer ID for receipts. | ||
| THIRD_PARTY_SUB_ID | NUMBER | 18 | Bill-to site use identifier for transactions; customer site use ID for receipts. | ||
| THIRD_PARTY_TYPE | VARCHAR2 | 1 | Third party classification code. | ||
| CURRENCY_CODE | VARCHAR2 | 15 | Currency code. | ||
| EXCHANGE_RATE | NUMBER | Conversion rate used to convert foreign currency amounts to the ledger currency. | |||
| EXCHANGE_TYPE | VARCHAR2 | 30 | Conversion rate type. | ||
| EXCHANGE_DATE | DATE | Conversion rate date. | |||
| REF_CUSTOMER_TRX_LINE_ID | NUMBER | 18 | Transaction line identifier. | ||
| REF_CUST_TRX_LINE_GL_DIST_ID | NUMBER | 18 | Transaction line distribution identifier. | ||
| CODE_COMBINATION_ID | NUMBER | 18 | Yes | General ledger account identifier. | |
| REF_DIST_CCID | NUMBER | 18 | Account code combination identifier at the time of application. Optimizes performance when CCID comes from a distribution outside Receivables. | ||
| ACTIVITY_BUCKET | VARCHAR2 | 30 | Activity associated to this distribution. | ||
| SOURCE_TYPE | VARCHAR2 | 30 | Yes | Account type of the transaction for which the distribution is posted. | |
| SOURCE_TABLE | VARCHAR2 | 10 | Yes | Identifier of the source table. Valid values are CRH for the AR_CASH_RECEIPT_HISTORY_ALL table, RA for the AR_RECEIVABLE_APPLICATIONS_ALL table, ADJ for the AR_ADJUSTMENTS_ALL table, MCD for the AR_MISC_CASH_DISTRIBUTIONS_ALL table, or TH for the AR_TRANSACTION_HISTORY_ALL table. | |
| RA_POST_INDICATOR | VARCHAR2 | 1 | Receivables posting batch identifier. Valid values are Y for posted and N for not posted. | ||
| CUSTOMER_TRX_ID | NUMBER | 18 | Identifier of the debit item or credit memo being applied. | ||
| INVENTORY_ITEM_ID | NUMBER | 18 | Inventory item identifier. | ||
| SALES_TAX_ID | NUMBER | 18 | Sales tax identifier. | ||
| TAX_LINE_ID | NUMBER | 18 | Tax line identifier. | ||
| BILL_TO_CUSTOMER_ID | NUMBER | 18 | Bill to customer identifier. | ||
| BILL_TO_SITE_USE_ID | NUMBER | 18 | Bill-to customer account site use identifier. | ||
| SOLD_TO_CUSTOMER_ID | NUMBER | 18 | Sold to customer identifier. | ||
| SOLD_TO_SITE_USE_ID | NUMBER | 18 | Sold-to customer account site use identifier. | ||
| SHIP_TO_CUSTOMER_ID | NUMBER | 18 | Ship to customer identifier. | ||
| SHIP_TO_SITE_USE_ID | NUMBER | 18 | Ship-to customer account site use identifier. |