Requisition
po_requisition_headers_all
po_requisition_lines_all ( segment1 ========== requisition number)
po_req_distributions_all
Note: requisition_header_id is the link between po_requisition_headers_all and po_requisition_lines_all
requisition_line_id is the link between po_requisition_lines_all and po_req_distributions_all
Purchase order
po_headers_all
po_lines_all
po_distributions_all
po_line_locations_all
Note: po_header_id is the link between all these tables
Receipt
rcv_shipment_headers
rcv_shipment_lines
rcv_transactions
quality result stored in qa_results table
Note: shipment_header_id is the link between rcv_shipment_headers and rcv_shipment_lines
po_header_id is the link between rcv_shipment_headers and rcv_transaction
Invoices
ap_invoices_all
ap_invoice_distributions_all
Note: invoice_id is the link between ap_invoices_all and ap_invoice_distributions_all
Payments
ap_checks_all
ap_invoice_payments_all
ap_payment_schedules_all
Payment Reconcillation
ap_banks
ap_bank_branches
GL Transfer
gl_periods
gl_period_status
gl_set_of_books
glfv_charts_of_accounts
Subscribe to:
Post Comments (Atom)
5 comments:
Hi Sunil
very good site in one roof.
but i confused with "po_header_id is the link between rcv_shipment_headers and rcv_transaction"
as no po_header_id column is avalaible in rcv_shipment_headers
Hi Sunil,
Nice 2 see this post which i was searching for a while. can u tell me if we need to create the items as assets , what needs to be done in this processs
Thanks and regards,
Sunil Dutt.S
Hi sunil,
what we are differing from the standard functionality is we are creating the received items as assets , now i need to automate it
. please help me.
http://sravan20apps.blogspot.in/
Post a Comment