MYOB Exo Business Stock
List of relationships
Relationship details
Relationship: BILLOMAT_HDR_BILLOMAT_LINES
NameBILLOMAT_HDR_BILLOMAT_LINES
Comment
Relationship typeNon Identifying
CardinalityZero Or More
Parent with columnsBILLOMAT_HDR (BILLCODE)
Child with columnsBILLOMAT_LINES (BILLCODE)
Update ruleNone
Delete ruleNone


Relationship: BILLOMAT_HDR_BILLOMAT_TEMP
NameBILLOMAT_HDR_BILLOMAT_TEMP
Comment
Relationship typeNon Identifying
CardinalityZero Or More
Parent with columnsBILLOMAT_HDR (BILLCODE)
Child with columnsBILLOMAT_TEMP (BILLCODE)
Update ruleNone
Delete ruleNone


Relationship: GLACCS_STOCK_GROUPS
NameGLACCS_STOCK_GROUPS
Comment
Relationship typeNon Identifying
CardinalityZero Or More
Parent with columnsGLACCS (ACCNO)
Child with columnsSTOCK_GROUPS (SALES_GL_CODE)
Update ruleNone
Delete ruleNone


Relationship: GLACCS_STOCK_GROUPS_COS
NameGLACCS_STOCK_GROUPS_COS
Comment
Relationship typeNon Identifying
CardinalityZero Or More
Parent with columnsGLACCS (ACCNO)
Child with columnsSTOCK_GROUPS (COS_GL_CODE)
Update ruleNone
Delete ruleNone


Relationship: GLACCS_STOCK_GROUPS_P
NameGLACCS_STOCK_GROUPS_P
Comment
Relationship typeNon Identifying
CardinalityZero Or More
Parent with columnsGLACCS (ACCNO)
Child with columnsSTOCK_GROUPS (PURCH_GL_CODE)
Update ruleNone
Delete ruleNone


Relationship: GLACCS_STOCK_ITEMS
NameGLACCS_STOCK_ITEMS
Comment
Relationship typeNon Identifying
CardinalityZero Or More
Parent with columnsGLACCS (ACCNO)
Child with columnsSTOCK_ITEMS (SALES_GL_CODE)
Update ruleNone
Delete ruleNone


Relationship: GLACCS_STOCK_ITEMS_COS
NameGLACCS_STOCK_ITEMS_COS
Comment
Relationship typeNon Identifying
CardinalityZero Or More
Parent with columnsGLACCS (ACCNO)
Child with columnsSTOCK_ITEMS (COS_GL_CODE)
Update ruleNone
Delete ruleNone


Relationship: GLACCS_STOCK_TRANS
NameGLACCS_STOCK_TRANS
Comment
Relationship typeNon Identifying
CardinalityZero Or More
Parent with columnsGLACCS (ACCNO)
Child with columnsSTOCK_TRANS (GLACC)
Update ruleNone
Delete ruleNone


Relationship: GL_ACCS_STOCKITEMS_PO
NameGL_ACCS_STOCKITEMS_PO
Comment
Relationship typeNon Identifying
CardinalityZero Or More
Parent with columnsGLACCS (ACCNO)
Child with columnsSTOCK_ITEMS (PURCH_GL_CODE)
Update ruleNone
Delete ruleNone


Relationship: INWARDS_GOODS_INWARDS_GOODS_COSTS
NameINWARDS_GOODS_INWARDS_GOODS_COSTS
Comment
Relationship typeNon Identifying
CardinalityZero Or More
Parent with columnsINWARDS_GOODS (SEQNO)
Child with columnsINWARDS_GOODS_COSTS (INWARDS_GOODS_SEQNO)
Update ruleNone
Delete ruleNone


Relationship: INWARDS_GOODS_INWARDS_GOODS_LINES
NameINWARDS_GOODS_INWARDS_GOODS_LINES
Comment
Relationship typeNon Identifying
CardinalityZero Or More
Parent with columnsINWARDS_GOODS (SEQNO)
Child with columnsINWARDS_GOODS_LINES (HDR_SEQNO)
Update ruleNone
Delete ruleNone


Relationship: STAFF_BILLOMAT_TEMP
NameSTAFF_BILLOMAT_TEMP
Comment
Relationship typeNon Identifying
CardinalityZero Or More
Parent with columnsSTAFF (STAFFNO)
Child with columnsBILLOMAT_TEMP (STAFFNO)
Update ruleNone
Delete ruleNone


Relationship: STAFF_STOCK_REQUESTS
NameSTAFF_STOCK_REQUESTS
Comment
Relationship typeNon Identifying
CardinalityZero Or More
Parent with columnsSTAFF (STAFFNO)
Child with columnsSTOCK_REQUESTS (STAFFNO)
Update ruleNone
Delete ruleNone


Relationship: STAFF_STOCK_TRANS_HDR
NameSTAFF_STOCK_TRANS_HDR
Comment
Relationship typeNon Identifying
CardinalityZero Or More
Parent with columnsSTAFF (STAFFNO)
Child with columnsSTOCK_TRANS_HDR (STAFFNO)
Update ruleNone
Delete ruleNone


Relationship: STOCK_CLASSIFICATIONS_STOCK_ITEMS
NameSTOCK_CLASSIFICATIONS_STOCK_ITEMS
Comment
Relationship typeNon Identifying
CardinalityZero Or More
Parent with columnsSTOCK_CLASSIFICATIONS (CLASSNO)
Child with columnsSTOCK_ITEMS (STOCK_CLASSIFICATION)
Update ruleNone
Delete ruleNone


Relationship: STOCK_GROUP2S_STOCKTAKE_TOTALS
NameSTOCK_GROUP2S_STOCKTAKE_TOTALS
Comment
Relationship typeNon Identifying
CardinalityZero Or More
Parent with columnsSTOCK_GROUP2S (GROUPNO)
Child with columnsSTOCKTAKE_TOTALS (STOCKGROUP2)
Update ruleNone
Delete ruleNone


Relationship: STOCK_GROUP2S_STOCKTAKE_TOTALS_REPCODE
NameSTOCK_GROUP2S_STOCKTAKE_TOTALS_REPCODE
Comment
Relationship typeNon Identifying
CardinalityZero Or More
Parent with columnsSTOCK_GROUP2S (REPORTCODE)
Child with columnsSTOCKTAKE_TOTALS (STOCKGROUP2_REPC)
Update ruleNone
Delete ruleNone


Relationship: STOCK_GROUP2S_STOCK_GROUPS
NameSTOCK_GROUP2S_STOCK_GROUPS
Comment
Relationship typeNon Identifying
CardinalityZero Or More
Parent with columnsSTOCK_GROUP2S (GROUPNO)
Child with columnsSTOCK_GROUPS (GROUP2_SEQNO)
Update ruleNone
Delete ruleNone


Relationship: STOCK_GROUP2S_STOCK_ITEMS
NameSTOCK_GROUP2S_STOCK_ITEMS
Comment
Relationship typeNon Identifying
CardinalityZero Or More
Parent with columnsSTOCK_GROUP2S (GROUPNO)
Child with columnsSTOCK_ITEMS (STOCKGROUP2)
Update ruleNone
Delete ruleNone


Relationship: STOCK_GROUPS_STOCKREQUIREMENT
NameSTOCK_GROUPS_STOCKREQUIREMENT
Comment
Relationship typeNon Identifying
CardinalityZero Or More
Parent with columnsSTOCK_GROUPS (GROUPNO)
Child with columnsSTOCKREQUIREMENT (STOCKGROUP)
Update ruleNone
Delete ruleNone


Relationship: STOCK_GROUPS_STOCKTAKE_TOTALS
NameSTOCK_GROUPS_STOCKTAKE_TOTALS
Comment
Relationship typeNon Identifying
CardinalityZero Or More
Parent with columnsSTOCK_GROUPS (GROUPNO)
Child with columnsSTOCKTAKE_TOTALS (STOCKGROUP)
Update ruleNone
Delete ruleNone


Relationship: STOCK_GROUPS_STOCKTAKE_TOTALS_REPCODE
NameSTOCK_GROUPS_STOCKTAKE_TOTALS_REPCODE
Comment
Relationship typeNon Identifying
CardinalityZero Or More
Parent with columnsSTOCK_GROUPS (REPORTCODE)
Child with columnsSTOCKTAKE_TOTALS (STOCKGROUP_REPC)
Update ruleNone
Delete ruleNone


Relationship: STOCK_GROUPS_STOCK_ITEMS
NameSTOCK_GROUPS_STOCK_ITEMS
Comment
Relationship typeNon Identifying
CardinalityZero Or More
Parent with columnsSTOCK_GROUPS (GROUPNO)
Child with columnsSTOCK_ITEMS (STOCKGROUP)
Update ruleNone
Delete ruleNone


Relationship: STOCK_ITEMS_BILLOMAT_LINES
NameSTOCK_ITEMS_BILLOMAT_LINES
Comment
Relationship typeNon Identifying
CardinalityZero Or More
Parent with columnsSTOCK_ITEMS (STOCKCODE)
Child with columnsBILLOMAT_LINES (STOCKCODE)
Update ruleNone
Delete ruleNone


Relationship: STOCK_ITEMS_BILLOMAT_TEMP
NameSTOCK_ITEMS_BILLOMAT_TEMP
Comment
Relationship typeNon Identifying
CardinalityZero Or More
Parent with columnsSTOCK_ITEMS (STOCKCODE)
Child with columnsBILLOMAT_TEMP (STOCKCODE)
Update ruleNone
Delete ruleNone


Relationship: STOCK_ITEMS_CR_INVLINES
NameSTOCK_ITEMS_CR_INVLINES
Comment
Relationship typeNon Identifying
CardinalityZero Or More
Parent with columnsSTOCK_ITEMS (STOCKCODE)
Child with columnsCR_INVLINES (STOCKCODE)
Update ruleNone
Delete ruleNone


Relationship: STOCK_ITEMS_DR_INVLINES
NameSTOCK_ITEMS_DR_INVLINES
Comment
Relationship typeNon Identifying
CardinalityZero Or More
Parent with columnsSTOCK_ITEMS (STOCKCODE)
Child with columnsDR_INVLINES (STOCKCODE)
Update ruleNone
Delete ruleNone


Relationship: STOCK_ITEMS_INWARDS_GOODS_LINES
NameSTOCK_ITEMS_INWARDS_GOODS_LINES
Comment
Relationship typeNon Identifying
CardinalityZero Or More
Parent with columnsSTOCK_ITEMS (STOCKCODE)
Child with columnsINWARDS_GOODS_LINES (STOCKCODE)
Update ruleNone
Delete ruleNone


Relationship: STOCK_ITEMS_STOCKREQUIREMENT
NameSTOCK_ITEMS_STOCKREQUIREMENT
Comment
Relationship typeNon Identifying
CardinalityZero Or More
Parent with columnsSTOCK_ITEMS (STOCKCODE)
Child with columnsSTOCKREQUIREMENT (STOCKCODE)
Update ruleNone
Delete ruleNone


Relationship: STOCK_ITEMS_STOCKTAKE_TOTALS
NameSTOCK_ITEMS_STOCKTAKE_TOTALS
Comment
Relationship typeNon Identifying
CardinalityZero Or More
Parent with columnsSTOCK_ITEMS (STOCKCODE)
Child with columnsSTOCKTAKE_TOTALS (STOCKCODE)
Update ruleNone
Delete ruleNone


Relationship: STOCK_ITEMS_STOCKTAKE_TOTALS_BN
NameSTOCK_ITEMS_STOCKTAKE_TOTALS_BN
Comment
Relationship typeNon Identifying
CardinalityZero Or More
Parent with columnsSTOCK_ITEMS (HAS_BN)
Child with columnsSTOCKTAKE_TOTALS (HAS_BN)
Update ruleNone
Delete ruleNone


Relationship: STOCK_ITEMS_STOCKTAKE_TOTALS_EXPDAYS
NameSTOCK_ITEMS_STOCKTAKE_TOTALS_EXPDAYS
Comment
Relationship typeNon Identifying
CardinalityZero Or More
Parent with columnsSTOCK_ITEMS (EXPIRY_DAYS)
Child with columnsSTOCKTAKE_TOTALS (EXPIRY_DAYS)
Update ruleNone
Delete ruleNone


Relationship: STOCK_ITEMS_STOCKTAKE_TOTALS_EXPIRY
NameSTOCK_ITEMS_STOCKTAKE_TOTALS_EXPIRY
Comment
Relationship typeNon Identifying
CardinalityZero Or More
Parent with columnsSTOCK_ITEMS (HAS_EXPIRY)
Child with columnsSTOCKTAKE_TOTALS (HAS_EXPIRY)
Update ruleNone
Delete ruleNone


Relationship: STOCK_ITEMS_STOCKTAKE_TOTALS_SERIAL
NameSTOCK_ITEMS_STOCKTAKE_TOTALS_SERIAL
Comment
Relationship typeNon Identifying
CardinalityZero Or More
Parent with columnsSTOCK_ITEMS (SERIALNO_TYPE)
Child with columnsSTOCKTAKE_TOTALS (SERIALNO_TYPE)
Update ruleNone
Delete ruleNone


Relationship: STOCK_ITEMS_STOCK_LOC_INFO
NameSTOCK_ITEMS_STOCK_LOC_INFO
Comment
Relationship typeIdentifying
CardinalityZero Or More
Parent with columnsSTOCK_ITEMS (STOCKCODE)
Child with columnsSTOCK_LOC_INFO (STOCKCODE)
Update ruleNone
Delete ruleNone


Relationship: STOCK_ITEMS_STOCK_REQUESTLINES
NameSTOCK_ITEMS_STOCK_REQUESTLINES
Comment
Relationship typeNon Identifying
CardinalityZero Or More
Parent with columnsSTOCK_ITEMS (STOCKCODE)
Child with columnsSTOCK_REQUESTLINES (STOCKCODE)
Update ruleNone
Delete ruleNone


Relationship: STOCK_ITEMS_STOCK_REQUESTLINES_DESC
NameSTOCK_ITEMS_STOCK_REQUESTLINES_DESC
Comment
Relationship typeNon Identifying
CardinalityZero Or More
Parent with columnsSTOCK_ITEMS (DESCRIPTION)
Child with columnsSTOCK_REQUESTLINES (DESCRIPTION)
Update ruleNone
Delete ruleNone


Relationship: STOCK_ITEMS_STOCK_SERIALNOS
NameSTOCK_ITEMS_STOCK_SERIALNOS
Comment
Relationship typeNon Identifying
CardinalityZero Or More
Parent with columnsSTOCK_ITEMS (STOCKCODE)
Child with columnsSTOCK_SERIALNOS (STOCKCODE)
Update ruleNone
Delete ruleNone


Relationship: STOCK_ITEMS_STOCK_TRANS
NameSTOCK_ITEMS_STOCK_TRANS
Comment
Relationship typeNon Identifying
CardinalityZero Or More
Parent with columnsSTOCK_ITEMS (STOCKCODE)
Child with columnsSTOCK_TRANS (STOCKCODE)
Update ruleNone
Delete ruleNone


Relationship: STOCK_ITEMS_STOCK_WEB
NameSTOCK_ITEMS_STOCK_WEB
Comment
Relationship typeNon Identifying
CardinalityZero Or More
Parent with columnsSTOCK_ITEMS (STOCKCODE)
Child with columnsSTOCK_WEB (STOCKCODE)
Update ruleNone
Delete ruleNone


Relationship: STOCK_ITEMS_SUPPLIER_STOCK_ITEMS
NameSTOCK_ITEMS_SUPPLIER_STOCK_ITEMS
Comment
Relationship typeNon Identifying
CardinalityZero Or More
Parent with columnsSTOCK_ITEMS (STOCKCODE)
Child with columnsSUPPLIER_STOCK_ITEMS (STOCKCODE)
Update ruleNone
Delete ruleNone


Relationship: STOCK_LOCATIONS_BILLOMAT_TEMP
NameSTOCK_LOCATIONS_BILLOMAT_TEMP
Comment
Relationship typeNon Identifying
CardinalityZero Or More
Parent with columnsSTOCK_LOCATIONS (LOCNO)
Child with columnsBILLOMAT_TEMP (COMPONENTLOCATION)
Update ruleNone
Delete ruleNone


Relationship: STOCK_LOCATIONS_BILLOMAT_TEMP_PROD
NameSTOCK_LOCATIONS_BILLOMAT_TEMP_PROD
Comment
Relationship typeNon Identifying
CardinalityZero Or More
Parent with columnsSTOCK_LOCATIONS (LOCNO)
Child with columnsBILLOMAT_TEMP (PRODUCTLOCATION)
Update ruleNone
Delete ruleNone


Relationship: STOCK_LOCATIONS_INWARDS_GOODS
NameSTOCK_LOCATIONS_INWARDS_GOODS
Comment
Relationship typeNon Identifying
CardinalityZero Or More
Parent with columnsSTOCK_LOCATIONS (LOCNO)
Child with columnsINWARDS_GOODS (LOCNO)
Update ruleNone
Delete ruleNone


Relationship: STOCK_LOCATIONS_INWARDS_GOODS_LINES
NameSTOCK_LOCATIONS_INWARDS_GOODS_LINES
Comment
Relationship typeNon Identifying
CardinalityZero Or More
Parent with columnsSTOCK_LOCATIONS (LOCNO)
Child with columnsINWARDS_GOODS_LINES (LOCNO)
Update ruleNone
Delete ruleNone


Relationship: STOCK_LOCATIONS_STOCKREQUIREMENT
NameSTOCK_LOCATIONS_STOCKREQUIREMENT
Comment
Relationship typeNon Identifying
CardinalityZero Or More
Parent with columnsSTOCK_LOCATIONS (LOCNO)
Child with columnsSTOCKREQUIREMENT (LOCNO)
Update ruleNone
Delete ruleNone


Relationship: STOCK_LOCATIONS_STOCKTAKE_CTRL
NameSTOCK_LOCATIONS_STOCKTAKE_CTRL
Comment
Relationship typeIdentifying
CardinalityZero Or More
Parent with columnsSTOCK_LOCATIONS (LOCNO)
Child with columnsSTOCKTAKE_CTRL (LOCNO)
Update ruleNone
Delete ruleNone


Relationship: STOCK_LOCATIONS_STOCKTAKE_TOTALS
NameSTOCK_LOCATIONS_STOCKTAKE_TOTALS
Comment
Relationship typeNon Identifying
CardinalityZero Or More
Parent with columnsSTOCK_LOCATIONS (LOCNO)
Child with columnsSTOCKTAKE_TOTALS (LOCATION)
Update ruleNone
Delete ruleNone


Relationship: STOCK_LOCATIONS_STOCK_LOC_INFO
NameSTOCK_LOCATIONS_STOCK_LOC_INFO
Comment
Relationship typeNon Identifying
CardinalityZero Or More
Parent with columnsSTOCK_LOCATIONS (LOCNO)
Child with columnsSTOCK_LOC_INFO (LOCATION)
Update ruleNone
Delete ruleNone


Relationship: STOCK_LOCATIONS_STOCK_SERIALNOS
NameSTOCK_LOCATIONS_STOCK_SERIALNOS
Comment
Relationship typeNon Identifying
CardinalityZero Or More
Parent with columnsSTOCK_LOCATIONS (LOCNO)
Child with columnsSTOCK_SERIALNOS (LOCNO)
Update ruleNone
Delete ruleNone


Relationship: STOCK_LOCATIONS_STOCK_TRANS
NameSTOCK_LOCATIONS_STOCK_TRANS
Comment
Relationship typeNon Identifying
CardinalityZero Or More
Parent with columnsSTOCK_LOCATIONS (LOCNO)
Child with columnsSTOCK_TRANS (LOCATION)
Update ruleNone
Delete ruleNone


Relationship: STOCK_LOCATIONS_STOCK_TRANS_TO
NameSTOCK_LOCATIONS_STOCK_TRANS_TO
Comment
Relationship typeNon Identifying
CardinalityZero Or More
Parent with columnsSTOCK_LOCATIONS (LOCNO)
Child with columnsSTOCK_TRANS (TOLOCATION)
Update ruleNone
Delete ruleNone


Relationship: STOCK_PRICEGROUPS_STOCK_GROUPS
NameSTOCK_PRICEGROUPS_STOCK_GROUPS
Comment
Relationship typeNon Identifying
CardinalityZero Or More
Parent with columnsSTOCK_PRICEGROUPS (GROUPNO)
Child with columnsSTOCK_GROUPS (X_PRICEGROUP)
Update ruleNone
Delete ruleNone


Relationship: STOCK_PRICEGROUPS_STOCK_ITEMS
NameSTOCK_PRICEGROUPS_STOCK_ITEMS
Comment
Relationship typeNon Identifying
CardinalityZero Or More
Parent with columnsSTOCK_PRICEGROUPS (GROUPNO)
Child with columnsSTOCK_ITEMS (STOCKPRICEGROUP)
Update ruleNone
Delete ruleNone


Relationship: STOCK_REQUESTS_STOCK_REQUESTLINES
NameSTOCK_REQUESTS_STOCK_REQUESTLINES
Comment
Relationship typeNon Identifying
CardinalityZero Or More
Parent with columnsSTOCK_REQUESTS (SEQNO)
Child with columnsSTOCK_REQUESTLINES (HDR_SEQNO)
Update ruleNone
Delete ruleNone


Relationship: STOCK_REQUESTTYPES_STOCK_REQUESTS
NameSTOCK_REQUESTTYPES_STOCK_REQUESTS
Comment
Relationship typeNon Identifying
CardinalityZero Or More
Parent with columnsSTOCK_REQUESTTYPES (SEQNO)
Child with columnsSTOCK_REQUESTS (TRANSTYPE)
Update ruleNone
Delete ruleNone