MYOB Exo Business Stock
Project details
ER diagram
Entities
Attributes
Relationships
List of relationships
Relationship details
Name
Relationship type
Parent
Child
Cardinality
BILLOMAT_HDR_BILLOMAT_LINES
Non Identifying
BILLOMAT_HDR
BILLOMAT_LINES
Zero Or More
BILLOMAT_HDR_BILLOMAT_TEMP
Non Identifying
BILLOMAT_HDR
BILLOMAT_TEMP
Zero Or More
GLACCS_STOCK_GROUPS
Non Identifying
GLACCS
STOCK_GROUPS
Zero Or More
GLACCS_STOCK_GROUPS_COS
Non Identifying
GLACCS
STOCK_GROUPS
Zero Or More
GLACCS_STOCK_GROUPS_P
Non Identifying
GLACCS
STOCK_GROUPS
Zero Or More
GLACCS_STOCK_ITEMS
Non Identifying
GLACCS
STOCK_ITEMS
Zero Or More
GLACCS_STOCK_ITEMS_COS
Non Identifying
GLACCS
STOCK_ITEMS
Zero Or More
GLACCS_STOCK_TRANS
Non Identifying
GLACCS
STOCK_TRANS
Zero Or More
GL_ACCS_STOCKITEMS_PO
Non Identifying
GLACCS
STOCK_ITEMS
Zero Or More
INWARDS_GOODS_INWARDS_GOODS_COSTS
Non Identifying
INWARDS_GOODS
INWARDS_GOODS_COSTS
Zero Or More
INWARDS_GOODS_INWARDS_GOODS_LINES
Non Identifying
INWARDS_GOODS
INWARDS_GOODS_LINES
Zero Or More
STAFF_BILLOMAT_TEMP
Non Identifying
STAFF
BILLOMAT_TEMP
Zero Or More
STAFF_STOCK_REQUESTS
Non Identifying
STAFF
STOCK_REQUESTS
Zero Or More
STAFF_STOCK_TRANS_HDR
Non Identifying
STAFF
STOCK_TRANS_HDR
Zero Or More
STOCK_CLASSIFICATIONS_STOCK_ITEMS
Non Identifying
STOCK_CLASSIFICATIONS
STOCK_ITEMS
Zero Or More
STOCK_GROUP2S_STOCKTAKE_TOTALS
Non Identifying
STOCK_GROUP2S
STOCKTAKE_TOTALS
Zero Or More
STOCK_GROUP2S_STOCKTAKE_TOTALS_REPCODE
Non Identifying
STOCK_GROUP2S
STOCKTAKE_TOTALS
Zero Or More
STOCK_GROUP2S_STOCK_GROUPS
Non Identifying
STOCK_GROUP2S
STOCK_GROUPS
Zero Or More
STOCK_GROUP2S_STOCK_ITEMS
Non Identifying
STOCK_GROUP2S
STOCK_ITEMS
Zero Or More
STOCK_GROUPS_STOCKREQUIREMENT
Non Identifying
STOCK_GROUPS
STOCKREQUIREMENT
Zero Or More
STOCK_GROUPS_STOCKTAKE_TOTALS
Non Identifying
STOCK_GROUPS
STOCKTAKE_TOTALS
Zero Or More
STOCK_GROUPS_STOCKTAKE_TOTALS_REPCODE
Non Identifying
STOCK_GROUPS
STOCKTAKE_TOTALS
Zero Or More
STOCK_GROUPS_STOCK_ITEMS
Non Identifying
STOCK_GROUPS
STOCK_ITEMS
Zero Or More
STOCK_ITEMS_BILLOMAT_LINES
Non Identifying
STOCK_ITEMS
BILLOMAT_LINES
Zero Or More
STOCK_ITEMS_BILLOMAT_TEMP
Non Identifying
STOCK_ITEMS
BILLOMAT_TEMP
Zero Or More
STOCK_ITEMS_CR_INVLINES
Non Identifying
STOCK_ITEMS
CR_INVLINES
Zero Or More
STOCK_ITEMS_DR_INVLINES
Non Identifying
STOCK_ITEMS
DR_INVLINES
Zero Or More
STOCK_ITEMS_INWARDS_GOODS_LINES
Non Identifying
STOCK_ITEMS
INWARDS_GOODS_LINES
Zero Or More
STOCK_ITEMS_STOCKREQUIREMENT
Non Identifying
STOCK_ITEMS
STOCKREQUIREMENT
Zero Or More
STOCK_ITEMS_STOCKTAKE_TOTALS
Non Identifying
STOCK_ITEMS
STOCKTAKE_TOTALS
Zero Or More
STOCK_ITEMS_STOCKTAKE_TOTALS_BN
Non Identifying
STOCK_ITEMS
STOCKTAKE_TOTALS
Zero Or More
STOCK_ITEMS_STOCKTAKE_TOTALS_EXPDAYS
Non Identifying
STOCK_ITEMS
STOCKTAKE_TOTALS
Zero Or More
STOCK_ITEMS_STOCKTAKE_TOTALS_EXPIRY
Non Identifying
STOCK_ITEMS
STOCKTAKE_TOTALS
Zero Or More
STOCK_ITEMS_STOCKTAKE_TOTALS_SERIAL
Non Identifying
STOCK_ITEMS
STOCKTAKE_TOTALS
Zero Or More
STOCK_ITEMS_STOCK_LOC_INFO
Identifying
STOCK_ITEMS
STOCK_LOC_INFO
Zero Or More
STOCK_ITEMS_STOCK_REQUESTLINES
Non Identifying
STOCK_ITEMS
STOCK_REQUESTLINES
Zero Or More
STOCK_ITEMS_STOCK_REQUESTLINES_DESC
Non Identifying
STOCK_ITEMS
STOCK_REQUESTLINES
Zero Or More
STOCK_ITEMS_STOCK_SERIALNOS
Non Identifying
STOCK_ITEMS
STOCK_SERIALNOS
Zero Or More
STOCK_ITEMS_STOCK_TRANS
Non Identifying
STOCK_ITEMS
STOCK_TRANS
Zero Or More
STOCK_ITEMS_STOCK_WEB
Non Identifying
STOCK_ITEMS
STOCK_WEB
Zero Or More
STOCK_ITEMS_SUPPLIER_STOCK_ITEMS
Non Identifying
STOCK_ITEMS
SUPPLIER_STOCK_ITEMS
Zero Or More
STOCK_LOCATIONS_BILLOMAT_TEMP
Non Identifying
STOCK_LOCATIONS
BILLOMAT_TEMP
Zero Or More
STOCK_LOCATIONS_BILLOMAT_TEMP_PROD
Non Identifying
STOCK_LOCATIONS
BILLOMAT_TEMP
Zero Or More
STOCK_LOCATIONS_INWARDS_GOODS
Non Identifying
STOCK_LOCATIONS
INWARDS_GOODS
Zero Or More
STOCK_LOCATIONS_INWARDS_GOODS_LINES
Non Identifying
STOCK_LOCATIONS
INWARDS_GOODS_LINES
Zero Or More
STOCK_LOCATIONS_STOCKREQUIREMENT
Non Identifying
STOCK_LOCATIONS
STOCKREQUIREMENT
Zero Or More
STOCK_LOCATIONS_STOCKTAKE_CTRL
Identifying
STOCK_LOCATIONS
STOCKTAKE_CTRL
Zero Or More
STOCK_LOCATIONS_STOCKTAKE_TOTALS
Non Identifying
STOCK_LOCATIONS
STOCKTAKE_TOTALS
Zero Or More
STOCK_LOCATIONS_STOCK_LOC_INFO
Non Identifying
STOCK_LOCATIONS
STOCK_LOC_INFO
Zero Or More
STOCK_LOCATIONS_STOCK_SERIALNOS
Non Identifying
STOCK_LOCATIONS
STOCK_SERIALNOS
Zero Or More
STOCK_LOCATIONS_STOCK_TRANS
Non Identifying
STOCK_LOCATIONS
STOCK_TRANS
Zero Or More
STOCK_LOCATIONS_STOCK_TRANS_TO
Non Identifying
STOCK_LOCATIONS
STOCK_TRANS
Zero Or More
STOCK_PRICEGROUPS_STOCK_GROUPS
Non Identifying
STOCK_PRICEGROUPS
STOCK_GROUPS
Zero Or More
STOCK_PRICEGROUPS_STOCK_ITEMS
Non Identifying
STOCK_PRICEGROUPS
STOCK_ITEMS
Zero Or More
STOCK_REQUESTS_STOCK_REQUESTLINES
Non Identifying
STOCK_REQUESTS
STOCK_REQUESTLINES
Zero Or More
STOCK_REQUESTTYPES_STOCK_REQUESTS
Non Identifying
STOCK_REQUESTTYPES
STOCK_REQUESTS
Zero Or More