CML_RCV_CHARGE_ESTIMATES_GT
This global temporary table will be used to store the receipt estimates while the system calculates the unit amount at receipt level. Once the calculation is over these rows will be stored in CML_RCV_CHARGE_ESTIMATES_GT
Details
-
Schema: FUSION
-
Object owner: CML
-
Object type: TABLE
-
Tablespace: Default
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| CMR_RCV_TRANSACTION_ID | NUMBER | 18 | Yes | Surrogate ID that identifies a PO receipt in Receipt Accounting. | |
| TRADE_OPERATION_ID | NUMBER | 18 | Yes | Single column FK: Identifies the trade operation associated with this charge. | |
| TRADE_OPERATION_CHARGE_ID | NUMBER | 18 | Yes | Single column FK: Identifies the trade operation charge line associated with this charge. | |
| CHARGE_LINE_NUMBER | NUMBER | 9 | Yes | Trade Operation Charge Line Number | |
| REQ_BU_ID | NUMBER | 18 | Yes | Charge Requisitioning Business Unit. | |
| CHARGE_ID | NUMBER | 18 | Yes | Single column FK: Identifies the charge name for this charge. | |
| CMR_PO_LINE_LOCATION_ID | NUMBER | 18 | Yes | Single column FK: Identifies the material PO schedule associated with this charge. | |
| UNIT_AMOUNT | NUMBER | Yes | Per Unit Estimated amount | ||
| UNIT_TAX | NUMBER | Yes | Per Unit Tax | ||
| SOURCE_DOC_UOM_CODE | VARCHAR2 | 3 | Yes | Source document UOM code on the Receipt Transaction. Per unit amounts are stored in this UOM. | |
| TRACKED_UOM_CODE | VARCHAR2 | 3 | Tracked UOM code on the trade operation material PO schedule association. | ||
| UOM_CONVERSION_FACTOR | NUMBER | UOM conversion factor from tracked UOM to source doc UOM | |||
| CURRENCY_CODE | VARCHAR2 | 15 | Yes | Charge Requisitioning BU currency. Amounts in this table are stored in this currency. | |
| ESTIMATE_ENTERED_DATE | TIMESTAMP | Yes | Effective date of the estimate. | ||
| ACCRUAL_OPTION | VARCHAR2 | 30 | Yes | Accrual option for the charge line. For charge lines associated to service Pos this will be set to NO_ACCRUAL. For other cases it is set to MATERIAL_RECEIPT | |
| CMR_SRV_PO_LINE_LOCATION_ID | NUMBER | 18 | Single column FK: Identifies the service PO schedule to which this charge is associated. | ||
| SHIP_TO_ORGANIZATION_ID | NUMBER | 18 | Yes | This column stores receiving organization unique identifier where the receiving transaction is created. |