Jaya is correct. But Party could be the super type that has all the data the other three share in common. All the common data goes in Party, the individually specific data goes in the other three.

supplier_id - is the party referred as, in payables AP
Vendor_id - is the party refereed as, in PO
customer_id and party_id is party referred as, in AR

I will refer predominantly to Relational DBMS. In a file system, data is contained in a flattened structure that is often a variable length structure. For example, a shipment received could contain th...

 An aggregate table is a table that contains data that is summarized somehow, for example, it contains a summary of Customer by Product by Week. A more granular level of detail would be the transactio...

Aggregate table is a generic term to represent the summaries built in a warehouse. MAterilaized view is the technical implementation of these aggregate tables. Though, Materialized views come with the...

Incremental aggregation concept is required in incremental loading. For example, lets say we receive sales data weekly and the same data is stored in some fact table with monthly granularity. We might...

Ill answer the first three. An incremental aggregation (I think because I have not exactly used the term) is an aggregate in which the new aggregate rows are appended (added to the back of) previous a...