CMR_ACCRUAL_ADJ_POS_GT
This table stores purchase orders cleared using adjust accrual and used in accounting event reation
Details
-
Schema: FUSION
-
Object owner: CMR
-
Object type: TABLE
-
Tablespace: Default
Columns
| Name | Datatype | Length | Precision | Comments |
|---|---|---|---|---|
| CMR_PO_DISTRIBUTION_ID | NUMBER | 18 | Receipt Accounting Purchase Order distribution identifier | |
| CMR_PO_LINE_LOCATION_ID | NUMBER | 18 | Receipt Accounting Purchase Order schedule identifier | |
| BUSINESS_UNIT_ID | NUMBER | 18 | profit center business unit on accrual clearing transaction. | |
| BILL_TO_BUSINESS_UNIT_ID | NUMBER | 18 | Bill to business unit identifier | |
| INVENTORY_ORG_ID | NUMBER | 18 | Inventory Organization Identifier | |
| ACCRUAL_CLEARED_USER | VARCHAR2 | 64 | User performing the accrual clearing transactions. This is to avoid same user doing accrual clearing at same time. | |
| ACCRUAL_CLR_REASON_DESC | VARCHAR2 | 100 | User entered accrual clearing reason description while performing clearing transaction. | |
| ACCRUAL_CLR_AMT | NUMBER | Accrual amount cleared by user at the time transaction creation. | ||
| TRANSACTION_DATE | TIMESTAMP | Latest transaction date on purchase order distribution or schedule. | ||
| LATEST_ACCOUNTING_EVENT_ID | NUMBER | 18 | Latest Accounting Event Identifier | |
| ACCRUAL_CLR_ID | NUMBER | 18 | Stores the accrual clear identifier during reversal | |
| ACCRUAL_GROUP_ID | NUMBER | 18 | Accrual clearing or reversal group identifier | |
| LATEST_CMR_AP_INVOICE_DIST_ID | NUMBER | 18 | Receipt accounting latest invoice distribution Identifier | |
| EVENT_CREATION_DATE | TIMESTAMP | receipt accounting event creation date | ||
| INVOICE_INTF_DATE | TIMESTAMP | Invoice interface date if any invoice exists on this PO distribution | ||
| CMR_ACCRUAL_AMT | NUMBER | Receipt accounting accrual amount and it is sum of all CMR accounted values for Accrual line type. | ||
| CMR_NR_TAX_AMT | NUMBER | Receipt accounting non recoverable tax amount and it is sum of all CMR accounted values for Accrual line type. | ||
| AP_ACCRUAL_AMT | NUMBER | Accrual Amount on Invoice distribution. | ||
| AP_NR_TAX_AMT | NUMBER | Non recoverable tax amount on invoice distribution. | ||
| INVOICED_QTY | NUMBER | Net Invoiced quantity on the PO distribution at the time of accrual clearing transaction. | ||
| RECEIVED_QTY | NUMBER | Total received quantity or trade quantity | ||
| ERROR_CODE | VARCHAR2 | 60 | Error code identifier to indicate the error on accrual clearing transaction. | |
| CMR_REC_TAX_AMT | NUMBER | Receipt accounting recoverable tax amount and it is sum of all CMR accounted values for Accrual line type. | ||
| AP_REC_TAX_AMT | NUMBER | Recoverable tax amount on invoice distribution. |