CMF_VALIDATION_RESULTSET_GT
This table will get the appropriate tolerance rule id for eligible records
Details
-
Schema: FUSION
-
Object owner: CMF
-
Object type: TABLE
-
Tablespace: Default
Columns
| Name | Datatype | Length | Precision | Comments |
|---|---|---|---|---|
| TOLERANCE_RULE_ID | NUMBER | 18 | The choosen Tolerance Rule id | |
| SOURCE_DOC_SCHEDULEID | NUMBER | 18 | Scheduleid of Source document | |
| ITEM_ID | NUMBER | 18 | Fiscal document Item id | |
| ISSUER_PARTY_ID | NUMBER | 18 | Fiscal document Issuer party Id | |
| PO_QTY | NUMBER | Quantity of the item in Purchse Order Schedule. | ||
| PO_PRICE | NUMBER | Unit price of the item in Purchase Order Line. | ||
| DOCUMENT_HEADER_ID | NUMBER | 18 | Fiscal Document Header Id | |
| DOCUMENT_LINE_ID | NUMBER | 18 | Line Id for Fiscal Document | |
| FD_SCHEDULE_ID | NUMBER | 18 | Fiscal Document Schedule Id | |
| FD_PRICE | NUMBER | Fiscal Document Price | ||
| FD_QUANTITY | NUMBER | Fiscal Document Quantity | ||
| PHYSICAL_RECEIPT_QUANTITY | NUMBER | Fiscal Document Physical Receipt Qty | ||
| PRICE_HOLD | VARCHAR2 | 20 | This indicates if we need to raise hold for Price | |
| SD_HOLD | VARCHAR2 | 20 | This indicates if we need to raise hold for Source Document and FD qty discrepancy | |
| FD_HOLD | VARCHAR2 | 20 | This indicates if we need to raise hold for physical delivered qty and FD qty discrepancy | |
| FISCAL_PROC_OPTIONS_ID | NUMBER | 18 | Fiscal process options id | |
| UOM_CONV_RATE | NUMBER | Indicates the quantity conversion rate from fiscal document schedules UOM to fiscal document lines UOM. | ||
| PRICING_UOM | VARCHAR2 | 5 | Indicates the UOM in which pricing is done. The Pricing UOM is derived as per the fiscal flow from source documents like Purchase Order, Transfer Order etc. | |
| PRICING_QTY | NUMBER | Indicates the quantity in pricing UOM allocated from source document in fiscal document schedule. |