CMR_PO_ACCRUAL_AMTS_RPT
This table stores accrual amounts for each run, for each period, for all purchase order distributions for report.
Details
-
Schema: FUSION
-
Object owner: CMR
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
CMR_PO_ACCRUAL_AMTS_RPT_PK |
CMR_PO_DISTRIBUTION_ID, PERIOD_START_DATE |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| CMR_PO_DISTRIBUTION_ID | NUMBER | 18 | Yes | Internal identifier of the purchase order distribution. | |
| PERIOD_START_DATE | DATE | Yes | Date when the accounting period begins. | ||
| PERIOD_END_DATE | DATE | Date when the accounting period ends. | |||
| BILL_TO_BU_ID | NUMBER | 18 | Yes | Business unit that will create the invoice for the purchase. | |
| PO_NUMBER | VARCHAR2 | 40 | User specified number for the purchase order. | ||
| VENDOR_ID | NUMBER | 18 | Identifies the Supplier and {References PO_VENDORS.vendor_id}. | ||
| LINE_NUMBER | VARCHAR2 | 40 | User specified number for the purchase order line. | ||
| LINE_TYPE | VARCHAR2 | 30 | Identifies whether the PO line is for Goods or Services. Valid values are 'GOODS' and 'SERVICES'. However, for Service PO of Payment Type RATE, this will be GOODS. | ||
| INVENTORY_ITEM_ID | NUMBER | 18 | Inventory Item Identifier and References {EGP_SYSTEM_ITEMS_B.inventory_item_id}. | ||
| INVENTORY_ORG_ID | NUMBER | 18 | Inventory organization where the material scheduled for receiving. | ||
| CATEGORY_ID | NUMBER | 18 | Purchasing category of the inventory item. | ||
| CURRENCY_CODE | VARCHAR2 | 15 | Identifies currency of the purchase order price. | ||
| FUNC_CURRENCY_CODE | VARCHAR2 | 15 | Identifies general ledger currency code. | ||
| CURRENCY_CONVERSION_RATE | NUMBER | Optional user specified currency conversion rate. | |||
| CURRENCY_CONVERSION_TYPE | VARCHAR2 | 30 | Conversion type used for currency conversion. | ||
| CURRENCY_CONVERSION_DATE | TIMESTAMP | The date used to determine the exchange rates for currency conversion. | |||
| PO_PRICE | NUMBER | Purchase price (per unit) specified by the buyer on the purchase order. | |||
| UOM_CODE | VARCHAR2 | 3 | Unit of measure for purchase order quantity. | ||
| PO_QUANTITY | NUMBER | Quantity of the material ordered for this distribution. | |||
| PO_AMOUNT | NUMBER | Amount ordered for the service based purchase order distribution. | |||
| RECEIVED_AMT | NUMBER | Transaction amount for service line items. | |||
| INVOICED_AMT | NUMBER | Amount on the invoice distribution. | |||
| RECEIVED_QTY | NUMBER | Receiving transaction qty. Sign of transaction - for Receive +ve, Return to Vendor -ve, Receipt Correction +ve/-ve. For Deliver +ve, Correction to Deliver +ve/-ve, Return to Receive -ve. | |||
| INVOICED_QTY | NUMBER | Invoice quantity in unit of measure code. | |||
| ACCRUAL_QTY | NUMBER | Uninvoiced accrual quantity of Purchase order distribution for a specific run. | |||
| ACCRUAL_AMT | NUMBER | Uninvoiced accrual amount of Purchase order distribution for a specific run. | |||
| INVOICE_VARIANCE_AMT | NUMBER | Invoice variance amount on the invoice distribution in functional currency. | |||
| INVOICE_AMT_FUNC_CURR | NUMBER | Amount on the invoice distribution in functional currency. | |||
| VENDOR_SITE_ID | NUMBER | 18 | Identifies the Supplier Site and References {PO_VENDOR_SITES_ALL.vendor_site_id}. | ||
| SHIPMENT_NUMBER | VARCHAR2 | 40 | User specified number for the purchase order shipment. | ||
| DISTRIBUTION_NUMBER | VARCHAR2 | 40 | User specified number for the purchase order distribution. | ||
| ITEM_DESCRIPTION | VARCHAR2 | 240 | Item description. Especially needed for POs involving non-inventory items. | ||
| 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. | ||
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or 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. | ||
| CHARGE_ACCOUNT_ID | NUMBER | 18 | Code combination identifier of the charge account. | ||
| ACCRUAL_ACCOUNT_ID | NUMBER | 18 | Code combination identifier of the accrual account. | ||
| PRIMARY_LEDGER_ID | NUMBER | 18 | Primary Ledger identifier for bill to business unit. | ||
| AGENT_ID | NUMBER | 18 | Unique person identifier of the Buyer. | ||
| BUSINESS_UNIT_ID | NUMBER | 18 | Business unit of the inventory organization. | ||
| PO_HEADER_ID | NUMBER | 18 | Purchase Order header identifier. | ||
| PO_LINE_ID | NUMBER | 18 | Purchase Order Line identifier and refers to table {PO_LINES_ALL.PO_LINE_ID}. | ||
| PO_LINE_LOCATION_ID | NUMBER | 18 | Purchase order shipment schedule identifier. | ||
| PO_LINE_DISTRIBUTION_ID | VARCHAR2 | 30 | Purchase order distribution line identifier. | ||
| PERIOD_NAME | VARCHAR2 | 15 | Fiscal period a company uses to report financial results, such as a calendar month or fiscal period. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| CMR_PO_ACCRUAL_AMTS_RPT_N1 | Non Unique | Default | PERIOD_START_DATE, BILL_TO_BU_ID |
| CMR_PO_ACCRUAL_AMTS_RPT_U1 | Unique | Default | CMR_PO_DISTRIBUTION_ID, PERIOD_START_DATE |