CST_PO_RCPT_TAX_BREAKUP_GT
This table will hold the PO Price and tax details for PO receipts with match options as 'R'. This table will be used in downstrem queries to fetch the price and tax details for match to receipt cases.
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: Default
Columns
Name | Datatype | Precision | Not-null | Comments |
---|---|---|---|---|
CMR_PO_DISTRIBUTION_ID | NUMBER | 18 | Yes | Single column FK: Identifies the PO distribution whose acquisition cost is being computed. |
CMR_RCV_TRANSACTION_ID | NUMBER | 18 | Yes | Identifies the root receipt transaction whose acquisition cost is being computed |
PO_PRICE | NUMBER | Purchase Order price from CMR_PURCHASE_ORDER_DTLS table. | ||
INCLUSIVE_NR_TAX | NUMBER | Sum of all nonrecoverable, inclusive per unit taxes from CMR_TRANSACTION_TAXES | ||
INCLUSIVE_REC_TAX | NUMBER | Sum of all recoverable, inclusive per unit taxes from CMR_TRANSACTION_TAXES | ||
EXCL_EST_NR_TAX | NUMBER | Sum of all nonrecoverable, non self assessed per unit taxes from CMR_TRANSACTION_TAXES | ||
SELF_ASSESSED_NR_TAX | NUMBER | Sum of all nonrecoverable, self assessed per unit taxes from CMR_TRANSACTION_TAXES. | ||
ENTERED_PO_PRICE | NUMBER | Purchase order price in entered PO currency. | ||
ENTERED_INCL_NR_TAX | NUMBER | Sum of all nonrecoverable, inclusive per unit taxes from CMR_TRANSACTION_TAXES in PO currency. | ||
ENTERED_INCL_REC_TAX | NUMBER | Sum of all recoverable, inclusive per unit taxes from CMR_TRANSACTION_TAXES in PO entered currency. | ||
ENTERED_EXCL_EST_NR_TAX | NUMBER | Sum of all nonrecoverable, non self assessed per unit taxes from CMR_TRANSACTION_TAXES in PO currency. | ||
ENTERED_SELF_ASD_NR_TAX | NUMBER | Sum of all nonrecoverable, self assessed per unit taxes from CMR_TRANSACTION_TAXES in PO currency. | ||
PO_EVENT_DATE | TIMESTAMP | Event date from CMR_PURCHASE_ORDER_DTLS | ||
TAX_EVENT_DATE | TIMESTAMP | Event date from CMR_TRANSACTION_TAXES | ||
INCLUSIVE_TAX_RATE | NUMBER | Indicates the percentage of included tax as a proportion of the after-tax value. | ||
NONRECOVERABLE_TAX_RATE | NUMBER | Indicates the percentage of non-recoverable tax as a proportion of the taxable amount. |