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. |