Relationship: BILLOMAT_HDR_BILLOMAT_LINES
Name | BILLOMAT_HDR_BILLOMAT_LINES |
Comment | |
Relationship type | Non Identifying |
Cardinality | Zero Or More |
Parent with columns | BILLOMAT_HDR (BILLCODE) |
Child with columns | BILLOMAT_LINES (BILLCODE) |
Update rule | None |
Delete rule | None |
Relationship: BILLOMAT_HDR_BILLOMAT_TEMP
Name | BILLOMAT_HDR_BILLOMAT_TEMP |
Comment | |
Relationship type | Non Identifying |
Cardinality | Zero Or More |
Parent with columns | BILLOMAT_HDR (BILLCODE) |
Child with columns | BILLOMAT_TEMP (BILLCODE) |
Update rule | None |
Delete rule | None |
Relationship: GLACCS_STOCK_GROUPS
Name | GLACCS_STOCK_GROUPS |
Comment | |
Relationship type | Non Identifying |
Cardinality | Zero Or More |
Parent with columns | GLACCS (ACCNO) |
Child with columns | STOCK_GROUPS (SALES_GL_CODE) |
Update rule | None |
Delete rule | None |
Relationship: GLACCS_STOCK_GROUPS_COS
Name | GLACCS_STOCK_GROUPS_COS |
Comment | |
Relationship type | Non Identifying |
Cardinality | Zero Or More |
Parent with columns | GLACCS (ACCNO) |
Child with columns | STOCK_GROUPS (COS_GL_CODE) |
Update rule | None |
Delete rule | None |
Relationship: GLACCS_STOCK_GROUPS_P
Name | GLACCS_STOCK_GROUPS_P |
Comment | |
Relationship type | Non Identifying |
Cardinality | Zero Or More |
Parent with columns | GLACCS (ACCNO) |
Child with columns | STOCK_GROUPS (PURCH_GL_CODE) |
Update rule | None |
Delete rule | None |
Relationship: GLACCS_STOCK_ITEMS
Name | GLACCS_STOCK_ITEMS |
Comment | |
Relationship type | Non Identifying |
Cardinality | Zero Or More |
Parent with columns | GLACCS (ACCNO) |
Child with columns | STOCK_ITEMS (SALES_GL_CODE) |
Update rule | None |
Delete rule | None |
Relationship: GLACCS_STOCK_ITEMS_COS
Name | GLACCS_STOCK_ITEMS_COS |
Comment | |
Relationship type | Non Identifying |
Cardinality | Zero Or More |
Parent with columns | GLACCS (ACCNO) |
Child with columns | STOCK_ITEMS (COS_GL_CODE) |
Update rule | None |
Delete rule | None |
Relationship: GLACCS_STOCK_TRANS
Name | GLACCS_STOCK_TRANS |
Comment | |
Relationship type | Non Identifying |
Cardinality | Zero Or More |
Parent with columns | GLACCS (ACCNO) |
Child with columns | STOCK_TRANS (GLACC) |
Update rule | None |
Delete rule | None |
Relationship: GL_ACCS_STOCKITEMS_PO
Name | GL_ACCS_STOCKITEMS_PO |
Comment | |
Relationship type | Non Identifying |
Cardinality | Zero Or More |
Parent with columns | GLACCS (ACCNO) |
Child with columns | STOCK_ITEMS (PURCH_GL_CODE) |
Update rule | None |
Delete rule | None |
Relationship: INWARDS_GOODS_INWARDS_GOODS_COSTS
Name | INWARDS_GOODS_INWARDS_GOODS_COSTS |
Comment | |
Relationship type | Non Identifying |
Cardinality | Zero Or More |
Parent with columns | INWARDS_GOODS (SEQNO) |
Child with columns | INWARDS_GOODS_COSTS (INWARDS_GOODS_SEQNO) |
Update rule | None |
Delete rule | None |
Relationship: INWARDS_GOODS_INWARDS_GOODS_LINES
Name | INWARDS_GOODS_INWARDS_GOODS_LINES |
Comment | |
Relationship type | Non Identifying |
Cardinality | Zero Or More |
Parent with columns | INWARDS_GOODS (SEQNO) |
Child with columns | INWARDS_GOODS_LINES (HDR_SEQNO) |
Update rule | None |
Delete rule | None |
Relationship: STAFF_BILLOMAT_TEMP
Name | STAFF_BILLOMAT_TEMP |
Comment | |
Relationship type | Non Identifying |
Cardinality | Zero Or More |
Parent with columns | STAFF (STAFFNO) |
Child with columns | BILLOMAT_TEMP (STAFFNO) |
Update rule | None |
Delete rule | None |
Relationship: STAFF_STOCK_REQUESTS
Name | STAFF_STOCK_REQUESTS |
Comment | |
Relationship type | Non Identifying |
Cardinality | Zero Or More |
Parent with columns | STAFF (STAFFNO) |
Child with columns | STOCK_REQUESTS (STAFFNO) |
Update rule | None |
Delete rule | None |
Relationship: STAFF_STOCK_TRANS_HDR
Name | STAFF_STOCK_TRANS_HDR |
Comment | |
Relationship type | Non Identifying |
Cardinality | Zero Or More |
Parent with columns | STAFF (STAFFNO) |
Child with columns | STOCK_TRANS_HDR (STAFFNO) |
Update rule | None |
Delete rule | None |
Relationship: STOCK_CLASSIFICATIONS_STOCK_ITEMS
Name | STOCK_CLASSIFICATIONS_STOCK_ITEMS |
Comment | |
Relationship type | Non Identifying |
Cardinality | Zero Or More |
Parent with columns | STOCK_CLASSIFICATIONS (CLASSNO) |
Child with columns | STOCK_ITEMS (STOCK_CLASSIFICATION) |
Update rule | None |
Delete rule | None |
Relationship: STOCK_GROUP2S_STOCKTAKE_TOTALS
Name | STOCK_GROUP2S_STOCKTAKE_TOTALS |
Comment | |
Relationship type | Non Identifying |
Cardinality | Zero Or More |
Parent with columns | STOCK_GROUP2S (GROUPNO) |
Child with columns | STOCKTAKE_TOTALS (STOCKGROUP2) |
Update rule | None |
Delete rule | None |
Relationship: STOCK_GROUP2S_STOCKTAKE_TOTALS_REPCODE
Name | STOCK_GROUP2S_STOCKTAKE_TOTALS_REPCODE |
Comment | |
Relationship type | Non Identifying |
Cardinality | Zero Or More |
Parent with columns | STOCK_GROUP2S (REPORTCODE) |
Child with columns | STOCKTAKE_TOTALS (STOCKGROUP2_REPC) |
Update rule | None |
Delete rule | None |
Relationship: STOCK_GROUP2S_STOCK_GROUPS
Name | STOCK_GROUP2S_STOCK_GROUPS |
Comment | |
Relationship type | Non Identifying |
Cardinality | Zero Or More |
Parent with columns | STOCK_GROUP2S (GROUPNO) |
Child with columns | STOCK_GROUPS (GROUP2_SEQNO) |
Update rule | None |
Delete rule | None |
Relationship: STOCK_GROUP2S_STOCK_ITEMS
Name | STOCK_GROUP2S_STOCK_ITEMS |
Comment | |
Relationship type | Non Identifying |
Cardinality | Zero Or More |
Parent with columns | STOCK_GROUP2S (GROUPNO) |
Child with columns | STOCK_ITEMS (STOCKGROUP2) |
Update rule | None |
Delete rule | None |
Relationship: STOCK_GROUPS_STOCKREQUIREMENT
Name | STOCK_GROUPS_STOCKREQUIREMENT |
Comment | |
Relationship type | Non Identifying |
Cardinality | Zero Or More |
Parent with columns | STOCK_GROUPS (GROUPNO) |
Child with columns | STOCKREQUIREMENT (STOCKGROUP) |
Update rule | None |
Delete rule | None |
Relationship: STOCK_GROUPS_STOCKTAKE_TOTALS
Name | STOCK_GROUPS_STOCKTAKE_TOTALS |
Comment | |
Relationship type | Non Identifying |
Cardinality | Zero Or More |
Parent with columns | STOCK_GROUPS (GROUPNO) |
Child with columns | STOCKTAKE_TOTALS (STOCKGROUP) |
Update rule | None |
Delete rule | None |
Relationship: STOCK_GROUPS_STOCKTAKE_TOTALS_REPCODE
Name | STOCK_GROUPS_STOCKTAKE_TOTALS_REPCODE |
Comment | |
Relationship type | Non Identifying |
Cardinality | Zero Or More |
Parent with columns | STOCK_GROUPS (REPORTCODE) |
Child with columns | STOCKTAKE_TOTALS (STOCKGROUP_REPC) |
Update rule | None |
Delete rule | None |
Relationship: STOCK_GROUPS_STOCK_ITEMS
Name | STOCK_GROUPS_STOCK_ITEMS |
Comment | |
Relationship type | Non Identifying |
Cardinality | Zero Or More |
Parent with columns | STOCK_GROUPS (GROUPNO) |
Child with columns | STOCK_ITEMS (STOCKGROUP) |
Update rule | None |
Delete rule | None |
Relationship: STOCK_ITEMS_BILLOMAT_LINES
Name | STOCK_ITEMS_BILLOMAT_LINES |
Comment | |
Relationship type | Non Identifying |
Cardinality | Zero Or More |
Parent with columns | STOCK_ITEMS (STOCKCODE) |
Child with columns | BILLOMAT_LINES (STOCKCODE) |
Update rule | None |
Delete rule | None |
Relationship: STOCK_ITEMS_BILLOMAT_TEMP
Name | STOCK_ITEMS_BILLOMAT_TEMP |
Comment | |
Relationship type | Non Identifying |
Cardinality | Zero Or More |
Parent with columns | STOCK_ITEMS (STOCKCODE) |
Child with columns | BILLOMAT_TEMP (STOCKCODE) |
Update rule | None |
Delete rule | None |
Relationship: STOCK_ITEMS_CR_INVLINES
Name | STOCK_ITEMS_CR_INVLINES |
Comment | |
Relationship type | Non Identifying |
Cardinality | Zero Or More |
Parent with columns | STOCK_ITEMS (STOCKCODE) |
Child with columns | CR_INVLINES (STOCKCODE) |
Update rule | None |
Delete rule | None |
Relationship: STOCK_ITEMS_DR_INVLINES
Name | STOCK_ITEMS_DR_INVLINES |
Comment | |
Relationship type | Non Identifying |
Cardinality | Zero Or More |
Parent with columns | STOCK_ITEMS (STOCKCODE) |
Child with columns | DR_INVLINES (STOCKCODE) |
Update rule | None |
Delete rule | None |
Relationship: STOCK_ITEMS_INWARDS_GOODS_LINES
Name | STOCK_ITEMS_INWARDS_GOODS_LINES |
Comment | |
Relationship type | Non Identifying |
Cardinality | Zero Or More |
Parent with columns | STOCK_ITEMS (STOCKCODE) |
Child with columns | INWARDS_GOODS_LINES (STOCKCODE) |
Update rule | None |
Delete rule | None |
Relationship: STOCK_ITEMS_STOCKREQUIREMENT
Name | STOCK_ITEMS_STOCKREQUIREMENT |
Comment | |
Relationship type | Non Identifying |
Cardinality | Zero Or More |
Parent with columns | STOCK_ITEMS (STOCKCODE) |
Child with columns | STOCKREQUIREMENT (STOCKCODE) |
Update rule | None |
Delete rule | None |
Relationship: STOCK_ITEMS_STOCKTAKE_TOTALS
Name | STOCK_ITEMS_STOCKTAKE_TOTALS |
Comment | |
Relationship type | Non Identifying |
Cardinality | Zero Or More |
Parent with columns | STOCK_ITEMS (STOCKCODE) |
Child with columns | STOCKTAKE_TOTALS (STOCKCODE) |
Update rule | None |
Delete rule | None |
Relationship: STOCK_ITEMS_STOCKTAKE_TOTALS_BN
Name | STOCK_ITEMS_STOCKTAKE_TOTALS_BN |
Comment | |
Relationship type | Non Identifying |
Cardinality | Zero Or More |
Parent with columns | STOCK_ITEMS (HAS_BN) |
Child with columns | STOCKTAKE_TOTALS (HAS_BN) |
Update rule | None |
Delete rule | None |
Relationship: STOCK_ITEMS_STOCKTAKE_TOTALS_EXPDAYS
Name | STOCK_ITEMS_STOCKTAKE_TOTALS_EXPDAYS |
Comment | |
Relationship type | Non Identifying |
Cardinality | Zero Or More |
Parent with columns | STOCK_ITEMS (EXPIRY_DAYS) |
Child with columns | STOCKTAKE_TOTALS (EXPIRY_DAYS) |
Update rule | None |
Delete rule | None |
Relationship: STOCK_ITEMS_STOCKTAKE_TOTALS_EXPIRY
Name | STOCK_ITEMS_STOCKTAKE_TOTALS_EXPIRY |
Comment | |
Relationship type | Non Identifying |
Cardinality | Zero Or More |
Parent with columns | STOCK_ITEMS (HAS_EXPIRY) |
Child with columns | STOCKTAKE_TOTALS (HAS_EXPIRY) |
Update rule | None |
Delete rule | None |
Relationship: STOCK_ITEMS_STOCKTAKE_TOTALS_SERIAL
Name | STOCK_ITEMS_STOCKTAKE_TOTALS_SERIAL |
Comment | |
Relationship type | Non Identifying |
Cardinality | Zero Or More |
Parent with columns | STOCK_ITEMS (SERIALNO_TYPE) |
Child with columns | STOCKTAKE_TOTALS (SERIALNO_TYPE) |
Update rule | None |
Delete rule | None |
Relationship: STOCK_ITEMS_STOCK_LOC_INFO
Name | STOCK_ITEMS_STOCK_LOC_INFO |
Comment | |
Relationship type | Identifying |
Cardinality | Zero Or More |
Parent with columns | STOCK_ITEMS (STOCKCODE) |
Child with columns | STOCK_LOC_INFO (STOCKCODE) |
Update rule | None |
Delete rule | None |
Relationship: STOCK_ITEMS_STOCK_REQUESTLINES
Name | STOCK_ITEMS_STOCK_REQUESTLINES |
Comment | |
Relationship type | Non Identifying |
Cardinality | Zero Or More |
Parent with columns | STOCK_ITEMS (STOCKCODE) |
Child with columns | STOCK_REQUESTLINES (STOCKCODE) |
Update rule | None |
Delete rule | None |
Relationship: STOCK_ITEMS_STOCK_REQUESTLINES_DESC
Name | STOCK_ITEMS_STOCK_REQUESTLINES_DESC |
Comment | |
Relationship type | Non Identifying |
Cardinality | Zero Or More |
Parent with columns | STOCK_ITEMS (DESCRIPTION) |
Child with columns | STOCK_REQUESTLINES (DESCRIPTION) |
Update rule | None |
Delete rule | None |
Relationship: STOCK_ITEMS_STOCK_SERIALNOS
Name | STOCK_ITEMS_STOCK_SERIALNOS |
Comment | |
Relationship type | Non Identifying |
Cardinality | Zero Or More |
Parent with columns | STOCK_ITEMS (STOCKCODE) |
Child with columns | STOCK_SERIALNOS (STOCKCODE) |
Update rule | None |
Delete rule | None |
Relationship: STOCK_ITEMS_STOCK_TRANS
Name | STOCK_ITEMS_STOCK_TRANS |
Comment | |
Relationship type | Non Identifying |
Cardinality | Zero Or More |
Parent with columns | STOCK_ITEMS (STOCKCODE) |
Child with columns | STOCK_TRANS (STOCKCODE) |
Update rule | None |
Delete rule | None |
Relationship: STOCK_ITEMS_STOCK_WEB
Name | STOCK_ITEMS_STOCK_WEB |
Comment | |
Relationship type | Non Identifying |
Cardinality | Zero Or More |
Parent with columns | STOCK_ITEMS (STOCKCODE) |
Child with columns | STOCK_WEB (STOCKCODE) |
Update rule | None |
Delete rule | None |
Relationship: STOCK_ITEMS_SUPPLIER_STOCK_ITEMS
Name | STOCK_ITEMS_SUPPLIER_STOCK_ITEMS |
Comment | |
Relationship type | Non Identifying |
Cardinality | Zero Or More |
Parent with columns | STOCK_ITEMS (STOCKCODE) |
Child with columns | SUPPLIER_STOCK_ITEMS (STOCKCODE) |
Update rule | None |
Delete rule | None |
Relationship: STOCK_LOCATIONS_BILLOMAT_TEMP
Name | STOCK_LOCATIONS_BILLOMAT_TEMP |
Comment | |
Relationship type | Non Identifying |
Cardinality | Zero Or More |
Parent with columns | STOCK_LOCATIONS (LOCNO) |
Child with columns | BILLOMAT_TEMP (COMPONENTLOCATION) |
Update rule | None |
Delete rule | None |
Relationship: STOCK_LOCATIONS_BILLOMAT_TEMP_PROD
Name | STOCK_LOCATIONS_BILLOMAT_TEMP_PROD |
Comment | |
Relationship type | Non Identifying |
Cardinality | Zero Or More |
Parent with columns | STOCK_LOCATIONS (LOCNO) |
Child with columns | BILLOMAT_TEMP (PRODUCTLOCATION) |
Update rule | None |
Delete rule | None |
Relationship: STOCK_LOCATIONS_INWARDS_GOODS
Name | STOCK_LOCATIONS_INWARDS_GOODS |
Comment | |
Relationship type | Non Identifying |
Cardinality | Zero Or More |
Parent with columns | STOCK_LOCATIONS (LOCNO) |
Child with columns | INWARDS_GOODS (LOCNO) |
Update rule | None |
Delete rule | None |
Relationship: STOCK_LOCATIONS_INWARDS_GOODS_LINES
Name | STOCK_LOCATIONS_INWARDS_GOODS_LINES |
Comment | |
Relationship type | Non Identifying |
Cardinality | Zero Or More |
Parent with columns | STOCK_LOCATIONS (LOCNO) |
Child with columns | INWARDS_GOODS_LINES (LOCNO) |
Update rule | None |
Delete rule | None |
Relationship: STOCK_LOCATIONS_STOCKREQUIREMENT
Name | STOCK_LOCATIONS_STOCKREQUIREMENT |
Comment | |
Relationship type | Non Identifying |
Cardinality | Zero Or More |
Parent with columns | STOCK_LOCATIONS (LOCNO) |
Child with columns | STOCKREQUIREMENT (LOCNO) |
Update rule | None |
Delete rule | None |
Relationship: STOCK_LOCATIONS_STOCKTAKE_CTRL
Name | STOCK_LOCATIONS_STOCKTAKE_CTRL |
Comment | |
Relationship type | Identifying |
Cardinality | Zero Or More |
Parent with columns | STOCK_LOCATIONS (LOCNO) |
Child with columns | STOCKTAKE_CTRL (LOCNO) |
Update rule | None |
Delete rule | None |
Relationship: STOCK_LOCATIONS_STOCKTAKE_TOTALS
Name | STOCK_LOCATIONS_STOCKTAKE_TOTALS |
Comment | |
Relationship type | Non Identifying |
Cardinality | Zero Or More |
Parent with columns | STOCK_LOCATIONS (LOCNO) |
Child with columns | STOCKTAKE_TOTALS (LOCATION) |
Update rule | None |
Delete rule | None |
Relationship: STOCK_LOCATIONS_STOCK_LOC_INFO
Name | STOCK_LOCATIONS_STOCK_LOC_INFO |
Comment | |
Relationship type | Non Identifying |
Cardinality | Zero Or More |
Parent with columns | STOCK_LOCATIONS (LOCNO) |
Child with columns | STOCK_LOC_INFO (LOCATION) |
Update rule | None |
Delete rule | None |
Relationship: STOCK_LOCATIONS_STOCK_SERIALNOS
Name | STOCK_LOCATIONS_STOCK_SERIALNOS |
Comment | |
Relationship type | Non Identifying |
Cardinality | Zero Or More |
Parent with columns | STOCK_LOCATIONS (LOCNO) |
Child with columns | STOCK_SERIALNOS (LOCNO) |
Update rule | None |
Delete rule | None |
Relationship: STOCK_LOCATIONS_STOCK_TRANS
Name | STOCK_LOCATIONS_STOCK_TRANS |
Comment | |
Relationship type | Non Identifying |
Cardinality | Zero Or More |
Parent with columns | STOCK_LOCATIONS (LOCNO) |
Child with columns | STOCK_TRANS (LOCATION) |
Update rule | None |
Delete rule | None |
Relationship: STOCK_LOCATIONS_STOCK_TRANS_TO
Name | STOCK_LOCATIONS_STOCK_TRANS_TO |
Comment | |
Relationship type | Non Identifying |
Cardinality | Zero Or More |
Parent with columns | STOCK_LOCATIONS (LOCNO) |
Child with columns | STOCK_TRANS (TOLOCATION) |
Update rule | None |
Delete rule | None |
Relationship: STOCK_PRICEGROUPS_STOCK_GROUPS
Name | STOCK_PRICEGROUPS_STOCK_GROUPS |
Comment | |
Relationship type | Non Identifying |
Cardinality | Zero Or More |
Parent with columns | STOCK_PRICEGROUPS (GROUPNO) |
Child with columns | STOCK_GROUPS (X_PRICEGROUP) |
Update rule | None |
Delete rule | None |
Relationship: STOCK_PRICEGROUPS_STOCK_ITEMS
Name | STOCK_PRICEGROUPS_STOCK_ITEMS |
Comment | |
Relationship type | Non Identifying |
Cardinality | Zero Or More |
Parent with columns | STOCK_PRICEGROUPS (GROUPNO) |
Child with columns | STOCK_ITEMS (STOCKPRICEGROUP) |
Update rule | None |
Delete rule | None |
Relationship: STOCK_REQUESTS_STOCK_REQUESTLINES
Name | STOCK_REQUESTS_STOCK_REQUESTLINES |
Comment | |
Relationship type | Non Identifying |
Cardinality | Zero Or More |
Parent with columns | STOCK_REQUESTS (SEQNO) |
Child with columns | STOCK_REQUESTLINES (HDR_SEQNO) |
Update rule | None |
Delete rule | None |
Relationship: STOCK_REQUESTTYPES_STOCK_REQUESTS
Name | STOCK_REQUESTTYPES_STOCK_REQUESTS |
Comment | |
Relationship type | Non Identifying |
Cardinality | Zero Or More |
Parent with columns | STOCK_REQUESTTYPES (SEQNO) |
Child with columns | STOCK_REQUESTS (TRANSTYPE) |
Update rule | None |
Delete rule | None |
|