Purchase Order Receiving Tables in Oracle apps. Receiving Tables Technical Flow

Purchase Order Receiving Tables in Oracle apps. Receiving Tables Technical Flow 

 

RCV_SHIPMENT_HEADERS

(important columns SHIPMENT_HEADER_ID,VENDOR_ID,RECEIPT_NUM,EMPLOYEE_ID,org_id)

 

This Table Store all information’s about Purchase Order Receiving Data. This Table Stores all the Receiving information of Purchase Orders.

HERE We get Receipt Number, Receipt Date , supplier , Supplier Site Information.

 

RCV_SHIPMENT_LINES

(this table describes the whole receiving like   line1 we receive that line2 we receive that by this table using po_header_id,po_line_id we join with ap_invoioce_distribution table)

 

(important columns are SHIPMENT_LINE_ID,SHIPMENT_HEADER_ID,LINE_NUM,QUANTITY_SHIPPED,QUANTITY_RECEIVED,ITEM_DESCRIPTION,ITEM_ID,SHIPMENT_LINE_STATUS_CODE(full or half rec),PO_HEADER_ID,PO_LINE_ID,TO_ORGANIZATION_ID)

 

THIS TABLE Stores information about Receipt Lines. It means which are the items we have received under the one Receipt. In Shipment Lines table

we get information about Inventory Item Id , Qty Received and Value too.

 

RCV_TRASNACTIONS

this table joins with rcv_shipment_headers,rcv_shipment_lines

 THIS SHOWS ALL THE STATUS OF ONE RECEVING OR RECEIPT NO  LIKE When they are RECEIVE ,When they are DELIVER,CORECT. In this INVENTORY_ITEM_ID  links with mtl_system_items_b invetory_item_id)

 

('RECEIVE','CORRECT','RETURN TO VENDOR','RETURN TO RECEIVING') These are the Transaction types common in this table

 

(transaction_id,SHIPMENT_HEADER_ID,UNIT_OF_MEASURE,QUANTITY,TRANSACTION_DATE,PO_HEADER_ID,PO_LINE_ID,PO_LINE_LOCATION_ID,PO_DISTRIBUTION_ID,DESTINATION_TYPE_CODE(EXP,RCV,INV)

 

This Table Store all receiving information again Single Receipt Number. When we receive the Item, Them It creates 1st record for Action Type '

RECEIVE’, when we deliver this received item to Inventory then it creates Transaction Type 'DELIVER'

Purchase Order Receiving Accounting Tables in Oracle Apps

 

RCV_RECEIVING_SUB_LEDGER

 

 (THIS TABLE SHOW THE ACCOUNTING OF EACH TRANSACTION ID LIKE WHEN ITEM REC THEN WHICH ACCOUNT CR, DR)

 (IMPORTANT COLOUMNS -  RCV_TRANSACTION_ID (IT LINKS RCV_TRANSACTION TABLE TO THIS TABLE), SET_OF_BOOKS_ID,CODE_COMBINATION_ID,ACCOUNTING_DATE,ACCOUNTED_DR,CR,PERIOD_NAME,RCV_SUB_LEDGER_ID)

 

BUT THE LIMITATION OF ABOVE TABLE IS THAT IT SHOWS THE ACCOUNTING OF THOSE TRANSACTION WHICH ARE EXPENSE IF THEY ARE INVENTORY THEN IT SHOWS THE ACCOUNTING OF RECEVING TRANSACTION NOT SHOWING THE TRANSACTION OF DELIVER TYPE TRANSACTION)

 

FOR SHOWING THE ACCOUNTING OF DELVER TRANSACTION IN INVENTORY WE SHOULD USE THIS BELOW TABLE

 

MTL_TRANSACTION_ACCOUNTS

 

(REFRENCE ACCOUNT,BASE_TRANSACTION_VALUE)

  THIS TABLE STORE THE INFORMATION OF ACCOUNTING OF INVENTORI ITEM DELIVER.

 

MTL_TRANSACTION_ACCOUNTS  WE REACH TO THIS TABLE BY MTL_MATERIAL_TRANSACTIONS(TRANSACTION_ID)  AND WE REACH TO THIS TABLE BY RCV_TRANSACTIONS(RCV_TRANSACTION_ID)

 

MTL_TRANSACTION_ACCOUNTS HAS COLOUMN REFRENCE ACCOUNT WHICH ARE ACCOUNTING CODE, BASE_TRANSACTION_VALUE  AMOUNT

 

MTL_MATERIAL_TRANSACTIONS

 

This Table Store all information about Inventory transactions. when any transaction happens, which affect the Inventory Stock then system creates

record for this transaction in this table. For Purchase Order Receipt When we receive the Item then it did not create any record in this table, but when we deliver the

receipt qty to inventory then it create record for this delivery transation in this table. We can join this record by 'transaction_id' with 'rcv_transaction_id' in rcv_transactions.

FOR EXAMPLE

 

WHEN WE do purchase order receiving then MATERIAL RECEIVING ACCOUNT DEBT AND ACCRUAL CREDIT 

 

WHEN WE do deliver then MATERIAL RECEIVING ACCOUNT CREDIT AND DESTINATION ACCOUNT to which account belong DEBIT 

 

AND When we create the invoice against the Purchase Order Receipt then it DEBITS THE ACRUAL ACCOUNT)

 

JAI_RCV_JOURNAL_ENTRIES(TRANSACTION_ID) THIS IS USED FOR SHOWING THE TAX ACCOUNTING OF ONE MRN NO