1. Tables and Views for SCM
  2. CMR_RCV_TAX_GT

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