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 |