Tuesday, 30 January 2018

Oracle Apps R12 Receiving Module Complete Details of the Tables and its Details


Oracle Apps R12 Receiving Module Complete Details of the Tables and its Details


RCV_VRC_TXS_V

RCH_SHIPMENT_HEADERS  (important coloumns SHIPMENT_HEADER_ID,VENDOR_ID,RECEIPT_NUM,EMPLOYEE_ID,org_id)
 
shipment_header_id relates this table to RCV_TRANSACTIONS table )

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_INVOICE_DISTRIBUTIONS_ALL table)
 (important cloumns 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)


RCV_TRANSACTIONS---(this table joins with rcv_shipment_headers,rcv_shipment_lines THIS SHOWS ALL THE STATUS OF ONE RECEVING OR RECEIPT NO  LIKE NOW THEY R RECEIVE ,NOW THER ARE DELIVER,CORECT,INVENTORY_ITEM_ID  links with MTL_SYSTEM_ITEMS_B invetory_item_id)
('RECEIVE','CORRECT','RETURN TO VENDOR','RETURN TO RECEIVING') THESE ARE THE TYPES COMMON

(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)


RCV_RECEIVING_SUB_LEDGER  (THIS TABLE SHOWS THE ACCOUNTING OF EACH TRANSACTION ID LIKE WHEN ITEM RECEIVED THEN WHICH ACCOUNT CR AND DR)
 (IMPORTANT COLOUMNS -  RCV_TRANSACTION_ID(IT LINKS RCV_TRANSACTIONS 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 ONLY RECEVING TRANSACTION NOT SHOWING THE TRANSACTION OF DELIVER TYPE TRANSACTION )

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

MTL_TRANSACTION_ACCOUNTS(REFRENCE ACCOUNT,BASE_TRANSACTION_VALUE)

THIS TABLE STORE THE INFORMATION OF ACCOUNTING OF INVENTORI ITEM DELIVER.
LIKE TWO LINES FOR 1 TRANSCTION 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


EXAMPLE (WHEN WE RECEIVE THE MATERIAL RECEIVING ACCOUNT DEBIT AND ACCRUAL ACCOUNT CREDIT 

WHEN WE DELIVER THE MATERIAL  RECEIVING ACCOUNT CREDIT AND DESTINATION ACCOUNT TO WHICH ITEM BELONG DEBIT 

AND WEN WE PASS THE BILL OF THIS MATERIAL IT DEBITS THE ACRUAL ACCOUNT)

if you found this post helpful and you liked it then follow this blog to get notifications for the upcoming posts.

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




 

0 comments:

Post a Comment