1.

What Are The Base Tables That Are Affected When You Create A P.o?

Answer»

PO_HEADERS_ALL (SEGMENT1 column in this table represents the Document number)

This table stores header information of a Purchasing Document. You need one row for each document you create.

PO_LINES_ALL:

This table stores the line information of a Purchasing Document

PO_LINE_LOCATIONS_ALL:

This table contains the information related to purchase order shipment schedules and blanket agreement price breaks. You need one row for each schedule or price break you attach to a document line.

PO_DISTRIBUTIONS_ALL:

This table contains the information related to ACCOUNTING distribution of a purchase order shipment line. You need one row for each distribution line you attach to a purchase order shipment

VENDORS_ALL:

This table stores the general information about the suppliers

PO_VENDOR_SITES_ALL:

This table stores information about the supplier sites. Each row includes the site address, supplier reference, purchasing, payment, bank, and general information.

PO_RELEASES_ALL:

This table stores information related to PLANNED and blanket Purchase Order releases. Each row includes the buyer, DATE, release status, and release number. Each release must have at least one purchase order shipment.

PO_VENDOR_CONTACTS:

This table stores information about contacts related to Supplier site. Each row includes contact NAME and site.

PO_ACTION_HISTORY:

This table stores information about the approval and control HISTORY of a Purchasing Document. This table stores one record for each approval or control action an employee takes on a purchase order, purchase agreement, release or requisition.

PO_HEADERS_ALL (SEGMENT1 column in this table represents the Document number)

This table stores header information of a Purchasing Document. You need one row for each document you create.

PO_LINES_ALL:

This table stores the line information of a Purchasing Document

PO_LINE_LOCATIONS_ALL:

This table contains the information related to purchase order shipment schedules and blanket agreement price breaks. You need one row for each schedule or price break you attach to a document line.

PO_DISTRIBUTIONS_ALL:

This table contains the information related to accounting distribution of a purchase order shipment line. You need one row for each distribution line you attach to a purchase order shipment

VENDORS_ALL:

This table stores the general information about the suppliers

PO_VENDOR_SITES_ALL:

This table stores information about the supplier sites. Each row includes the site address, supplier reference, purchasing, payment, bank, and general information.

PO_RELEASES_ALL:

This table stores information related to planned and blanket Purchase Order releases. Each row includes the buyer, date, release status, and release number. Each release must have at least one purchase order shipment.

PO_VENDOR_CONTACTS:

This table stores information about contacts related to Supplier site. Each row includes contact name and site.

PO_ACTION_HISTORY:

This table stores information about the approval and control history of a Purchasing Document. This table stores one record for each approval or control action an employee takes on a purchase order, purchase agreement, release or requisition.



Discussion

No Comment Found