Purchase Data Model

The Purchase Entity is the main entity in this area and it is a complex entity - it is constructed from many different tables and relations.

The main table in this data model, is the bPurchase table - every bPurchase record is related to one and only one bBusinessDocument record.

This is done with a one to one relation between the bBusinessDocument record and a bPurchase record - here the PK is the bBusinessDocument.sBusinessDocumentPK field and the FK is the bPurchase.sBusinessDocumentFK field.

To implement this type of relation in the Analysis:

• we have used a [0,n]->[1,1] link between the bBusinessDocument table and the bPurchase table, and
• we assign the bPurchase.sBusinessDocumentFK as a PK of the bPurchase table - making it unique (see the image below).

This data model is built from the Universal Business Document Model

A general and simplified graph of the Purchase Data Model

The bPurchase table

The bPurchase has the following important data:

• bPurchase.sBusinessDocumentFK - the PK of the bPurchase table and the FK for the relation with the bBusinessDocument table
• bPurchase.sPartyFK - the FK for the [1,1]->[0,n] relation to the gParty table (list of Parties)
• bPurchase.sPartyBranchFK - the FK for the [1,1]->[0,n] relation to the gPartyBranch table (list of Branches for Parties)
• bPurchase.sPartyAddressFK - the FK for the [1,1]->[0,n] relation to the gPartyAddress table (list of Addresses for Parties)
• bPurchase.sPartyPostingFK - the FK for the [1,1]->[0,n] relation to the gPartyPosting table (list of Party Postings) - it controls the posting to GL.
• bPurchase.sCompanyInventoryPeriodFK - the FK for the [1,1]->[0,n] relation to the gCompanyInventoryPeriod table (list of inventory periods)
• bPurchase.cAmountCurrency - the amount, in the documents original currency- before any taxes
• bPurchase.cTAXAmountCurrency - the TAX amount, in the documents original currency
• bPurchase.cTOTALAmountCurrency - the TOTAL amount, in the documents original currency
• bPurchase.cAmount - the amount, in the local currency- before any taxes (note: the exchange rate is in the bBusinessDocument related record)
• bPurchase.cTAXAmountCurrency - the TAX amount, in the local currency
• bPurchase.cTOTALAmountCurrency - the TOTAL amount, in the local currency

The bBusinessDocument table

The bBusinessDocument has the following important data:

• bBusinessDocument.sBusinessDocumentPK - the PK
• bBusinessDocument.sBusinessObjectFK - the FK for the [1,1]->[0,n] relation to the bBusinessObject table (list of Business Objects)
• bBusinessDocument.sCompanyFiscalYearFK - the FK for the [1,1]->[0,n] relation to the gCompanyFiscalYear table (list of fiscal years)
• bBusinessDocument.sCompanyBranchFK - the FK for the [1,1]->[0,n] relation to the gCompanyBranch table (list of company branches)
• bBusinessDocument.sCompanyDepartmentFK - the FK for the [1,1]->[0,n] relation to the gCompanyDepartment table (list of company departments)
• bBusinessDocument.sCurrencyFK - the FK for the [1,1]->[0,n] relation to the gCurrency table (list of currencies) - the documents Original Currency
• bBusinessDocument.cExchangeCurrency - the Exchange rate between the documents Original Currency and the LOCAL currency of the company
• bBusinessDocument.sDocumentID - a unicode string
• bBusinessDocument.dDocumentDate - the documents date
• bBusinessDocument.dTransactionDate - the documents transaction date (can be different from the DocumentDate)
• bBusinessDocument.bPosted - Post/Unpost flag
• bBusinessDocument.bPostedGL - Post/Unpost to General Ledger flag
• bBusinessDocument.bCanceled - Cancel flag

The bBusinessObject table

Every bBusinessDocument record has a [1,1]->[0,n] relation to a bBusinessObject record.

At the end, this record - the bBusinessObject record - gives the bPurchase record all its functionality (numbering, defaults, print forms) including its specific Business Object Role.

The bPurchase table currently supports the following Business Objects Roles:

• Purchase Quote
• Purchase Order
• Purchase Shipment (and Return Shipment)
• Purchase Invoice (and Credit Invoice)
• Purchase InvoiceShipment

The bBusinessDocument_ProductLine

This is where alpha360 stores records for all products that belong to the Purchase Document - note here that each record is related to the bBusinessDocument record.

The bBusinessDocument_TAXLine

This is where alpha360 stores records for the TAXES that belong to the Purchase Document - note here that each record is related to the bBusinessDocument record.