CMR_RCV_TAX_GT
Temporary table to hold receiving transaction to be passed for Tax API call
Details
-
Schema: FUSION
-
Object owner: CMR
-
Object type: TABLE
-
Tablespace: Default
Columns
Name | Datatype | Length | Precision | Comments |
---|---|---|---|---|
CMR_RCV_TRANSACTION_ID | NUMBER | 18 | Receipt accounting receiving transaction identifier | |
PO_LINE_LOCATION_ID | NUMBER | 18 | Purchase order Schedule Identifier | |
PARENT_TRANSACTION_ID | NUMBER | 18 | Parent Receiving Transaction identifier | |
PARENT_PO_LINE_LOCATION_ID | NUMBER | 18 | Parent Purchase Order Line Location Identifier | |
PARENT_TRANSACTION_DATE | DATE | Parent Transaction Date of receipt transaction. | ||
SHIP_TO_ORGANIZATION_ID | NUMBER | 18 | Ship To Organization Identifier where goods are delivered. | |
BILL_TO_BUSINESS_UNIT_ID | NUMBER | 18 | Bill to business unit identifier and called invoicing business unit. | |
INVENTORY_ITEM_ID | NUMBER | 18 | Inventory Item Identifier and References {EGP_SYSTEM_ITEMS_B.inventory_item_id}. | |
TRANSACTION_TYPE | VARCHAR2 | 40 | Fusion Receiving Transaction Type. | |
TRANSACTION_AMT | NUMBER | Transaction Amount - Service type POs net received amount. GOODS types of POs quantity * unit price. | ||
OLD_TRANSACTION_AMT | NUMBER | Old Transaction Amount - Service type POs net received amount. GOODS types of POs quantity * unit price. | ||
TRANSACTION_DATE | TIMESTAMP | Transaction Date on which day user indicates the goods are received. | ||
SOURCE_DOC_QTY | NUMBER | Source document quantity in Purchase Order UOM. | ||
OLD_SOURCE_DOC_QTY | NUMBER | Original source doc quantity in Purchase Order UOM. | ||
PARENT_TRANSACTION_TYPE | VARCHAR2 | 40 | Parent Transaction Type - Fusion Receiving Transaction Type. | |
SOURCE_DOC_UOM_CODE | VARCHAR2 | 3 | Source document uom code - Purchase Order UOM. | |
PO_UNIT_PRICE | NUMBER | Purchase Order Unit Price defined on PO line. | ||
PURCHASE_BASIS | VARCHAR2 | 30 | Purchase Basis - GOODS or SERVICES | |
MATCH_OPTION | VARCHAR2 | 25 | Match Option - Indicator of whether the invoice for the shipment should be matched to the purchase order or the receipt | |
DESTINATION_TYPE_CODE | VARCHAR2 | 30 | Destination Type - INVENTORY or EXPENSE or MANUFACTER | |
CURRENCY_CODE | VARCHAR2 | 15 | Purchase Order Currency Code indicates goods receiving currency. | |
CURRENCY_CONVERSION_TYPE | VARCHAR2 | 30 | Currency conversion type - Purchase order currency type indicates goods receiving currency. | |
CURRENCY_CONVERSION_RATE | NUMBER | Currency conversion rate - Purchase order currency rate indicates goods receiving currency. | ||
CURRENCY_CONVERSION_DATE | TIMESTAMP | Currency conversion date - Purchase order currency date indicates goods receiving currency. | ||
RCV_TRANSACTION_ID | NUMBER | 18 | Receiving transaction identifier - maps to {RCV_TRANSACTIONS.TRANSACTION_ID} | |
VENDOR_ID | NUMBER | 18 | Supplier identifier - Identifies the Supplier and {References PO_VENDORS.vendor_id} | |
VENDOR_SITE_ID | NUMBER | 18 | Supplier Site Identifier - Identifies the Supplier Site and References {PO_VENDOR_SITES_ALL.vendor_site_id} | |
DEFAULT_TAXATION_COUNTRY | VARCHAR2 | 2 | Default taxation country where received goods taxes are paid. | |
RECEIPT_NUMBER | VARCHAR2 | 50 | Receipt Number - defined by user while receiving purchase orders. | |
DOCUMENT_FISCAL_CLASSIFICATION | VARCHAR2 | 240 | Document fiscal classification - one of the TAX API call attribute and defined on while performing receipt. | |
FIRST_PARTY_REG_ID | NUMBER | 18 | First Party Tax Registration Id - one of the TAX API call attribute and defined on while performing receipt. | |
THIRD_PARTY_REG_ID | NUMBER | 18 | Third Party Tax Registration Id -one of the TAX API call attribute and defined on while performing receipt. | |
TRX_BUSINESS_CATEGORY | VARCHAR2 | 240 | Transaction business category - one of the TAX API call attribute and defined on while performing receipt. | |
USER_DEFINED_FISC_CLASS | VARCHAR2 | 30 | User defined fiscal classification- one of the TAX API call attribute and defined on while performing receipt. | |
PRODUCT_FISC_CLASS_ID | NUMBER | 18 | Product fiscal classification id- one of the TAX API call attribute and defined on while performing receipt. | |
PRODUCT_TYPE | VARCHAR2 | 240 | Product type- one of the TAX API call attribute and defined on while performing receipt. | |
PRODUCT_CATEGORY | VARCHAR2 | 240 | Product category - one of the TAX API call attribute and defined on while performing receipt. | |
FISCAL_DOC_HEADER_ID | NUMBER | 18 | Fiscal Document Header Identifier - Fiscal document purchase orders. | |
FISCAL_DOCUMENT_DETAIL_ID | NUMBER | 18 | Fiscal Document Details Identifier purchase order. | |
FISCAL_DOC_LINE_ID | NUMBER | 18 | Fiscal Document Line Identifier purchase order. | |
FISCAL_DOC_SCHEDULE_ID | NUMBER | 18 | Fiscal Document Schedule Identifier purchase order. | |
SHIP_FROM_LOCATION_ID | NUMBER | 18 | Ship from location identifier - indicates the location from where goods are shipped. | |
SHIP_TO_LOCATION_ID | NUMBER | 18 | Ship to Location identifier - indicates the goods receiving location | |
PO_HEADER_ID | NUMBER | 18 | PO header Identifier and maps to {PO_HEADERS_ALL.PO_HEADER_ID} | |
SHIPMENT_NUMBER | VARCHAR2 | 30 | Shipment Number - indicates the document number of PO schedule. | |
ASSESSABLE_VALUE | NUMBER | Assessable Value - TAX API call attribute and passed by receiving | ||
TAX_CLASSIFICATION_CODE | VARCHAR2 | 50 | Tax classification code - TAX API call attribute and passed by receiving | |
INTENDED_USE_CLASSIF_ID | NUMBER | 18 | Intended Use classification Id - TAX API call attribute and passed by receiving | |
TAX_INVOICE_NUMBER | VARCHAR2 | 150 | Tax Invoice Number - TAX API call attribute and passed by receiving | |
TAX_INVOICE_DATE | DATE | Tax invoice date - TAX API call attribute and passed by receiving | ||
CATEGORY_ID | NUMBER | 18 | Purchasing category identifier defined on purchase order. | |
CONSIGNED_FLAG | VARCHAR2 | 1 | Consigned flag - indicates consigned purchase order or not. | |
FINAL_DISCHARGE_LOCATION_ID | NUMBER | 18 | Final discharge location identifier - - TAX API call attribute and passed by receiving | |
COUNTRY_OF_ORIGIN_CODE | VARCHAR2 | 2 | Country of origin code- TAX API call attribute and passed by receiving | |
DOC_EVENT_STATUS | VARCHAR2 | 30 | Doc event status on Tax - TAX API call attribute . | |
TRADE_EVENT_ID | NUMBER | 18 | Trade Event Identifier - passed for global consigned purchase orders | |
TRANSACTION_ID | NUMBER | 18 | Reference to CMR_TRANSACTIONS table TRANSACTION_ID column. | |
PO_DISTRIBUTION_ID | NUMBER | 18 | PO Distribution identifier and maps to PO_DISTRIBUTIONS_ALL. | |
DISTRIBUTION_NUMBER | VARCHAR2 | 30 | PO Distribution Number defined on purchase order. | |
EVENT_DATE | TIMESTAMP | Purchase Order Event Date indicates the date PO status changed. | ||
TO_LINE_ID | NUMBER | Transfer order line identifier - maps to {CST_TRANSFER_ORDER_LINES.EXTERNAL_SYSTEM_REF_ID} | ||
SHIP_FROM_ORGANIZATION_ID | NUMBER | 18 | Shipment Transaction Source's inventory organization identifier | |
BILL_TO_LOCATION_ID | NUMBER | 18 | Purchase order goods billing location identifier |