|
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 | One 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 |
|