|
Relationship: CAMPAIGN_WAVE_CONTACTS
| Name | CAMPAIGN_WAVE_CONTACTS |
| Comment | |
| Relationship type | Non Identifying |
| Cardinality | Zero Or More |
| Parent with columns | CAMPAIGN_WAVE (SEQNO) |
| Child with columns | CONTACTS (CAMPAIGN_WAVE_SEQNO) |
| Update rule | None |
| Delete rule | None |
Relationship: CAMPAIGN_WAVE_DR_PRICES
| Name | CAMPAIGN_WAVE_DR_PRICES |
| Comment | |
| Relationship type | Non Identifying |
| Cardinality | Zero Or More |
| Parent with columns | CAMPAIGN_WAVE (SEQNO) |
| Child with columns | DR_PRICES (CAMPAIGN_WAVE_SEQNO) |
| Update rule | None |
| Delete rule | None |
Relationship: CAMPAIGN_WAVE_DR_PRICE_POLICY
| Name | CAMPAIGN_WAVE_DR_PRICE_POLICY |
| Comment | |
| Relationship type | Non Identifying |
| Cardinality | Zero Or More |
| Parent with columns | CAMPAIGN_WAVE (SEQNO) |
| Child with columns | DR_PRICE_POLICY (CAMPAIGN_WAVE_SEQNO) |
| Update rule | None |
| Delete rule | None |
Relationship: CAMPAIGN_WAVE_DR_TRANS
| Name | CAMPAIGN_WAVE_DR_TRANS |
| Comment | |
| Relationship type | Non Identifying |
| Cardinality | Zero Or More |
| Parent with columns | CAMPAIGN_WAVE (SEQNO) |
| Child with columns | DR_TRANS (CAMPAIGN_WAVE_SEQNO) |
| Update rule | None |
| Delete rule | None |
Relationship: CAMPAIGN_WAVE_OPPORTUNITY
| Name | CAMPAIGN_WAVE_OPPORTUNITY |
| Comment | |
| Relationship type | Non Identifying |
| Cardinality | Zero Or More |
| Parent with columns | CAMPAIGN_WAVE (SEQNO) |
| Child with columns | OPPORTUNITY (CAMPAIGN_WAVE_SEQNO) |
| Update rule | None |
| Delete rule | None |
Relationship: CAMPAIGN_WAVE_SALESORD_HDR
| Name | CAMPAIGN_WAVE_SALESORD_HDR |
| Comment | |
| Relationship type | Non Identifying |
| Cardinality | Zero Or More |
| Parent with columns | CAMPAIGN_WAVE (SEQNO) |
| Child with columns | SALESORD_HDR (CAMPAIGN_WAVE_SEQNO) |
| Update rule | None |
| Delete rule | None |
Relationship: CONTACTS_DR_CONTACTS
| Name | CONTACTS_DR_CONTACTS |
| Comment | |
| Relationship type | Non Identifying |
| Cardinality | Zero Or More |
| Parent with columns | CONTACTS (SEQNO) |
| Child with columns | DR_CONTACTS (CONTACT_SEQNO) |
| Update rule | None |
| Delete rule | None |
Relationship: CURRENCIES_DR_ALLOCATIONS
| Name | CURRENCIES_DR_ALLOCATIONS |
| Comment | |
| Relationship type | Non Identifying |
| Cardinality | Zero Or More |
| Parent with columns | CURRENCIES (CURRENCYNO) |
| Child with columns | DR_ALLOCATIONS (CURRENCY) |
| Update rule | None |
| Delete rule | None |
Relationship: CURRENCIES_DR_INVLINES
| Name | CURRENCIES_DR_INVLINES |
| Comment | |
| Relationship type | Non Identifying |
| Cardinality | Zero Or More |
| Parent with columns | CURRENCIES (CURRENCYNO) |
| Child with columns | DR_INVLINES (CURRENCYNO) |
| Update rule | None |
| Delete rule | None |
Relationship: CURRENCIES_DR_TRANS
| Name | CURRENCIES_DR_TRANS |
| Comment | |
| Relationship type | Non Identifying |
| Cardinality | Zero Or More |
| Parent with columns | CURRENCIES (CURRENCYNO) |
| Child with columns | DR_TRANS (CURRENCYNO) |
| Update rule | None |
| Delete rule | None |
Relationship: CURRENCIES_GLACCS
| Name | CURRENCIES_GLACCS |
| Comment | |
| Relationship type | Non Identifying |
| Cardinality | Zero Or More |
| Parent with columns | CURRENCIES (CURRENCYNO) |
| Child with columns | GLACCS (CURRENCYNO) |
| Update rule | None |
| Delete rule | None |
Relationship: DR_ACCGROUP2S_DR_ACCS
| Name | DR_ACCGROUP2S_DR_ACCS |
| Comment | |
| Relationship type | Non Identifying |
| Cardinality | Zero Or More |
| Parent with columns | DR_ACCGROUP2S (ACCGROUP) |
| Child with columns | DR_ACCS (ACCGROUP2) |
| Update rule | None |
| Delete rule | None |
Relationship: DR_ACCGROUPS_DR_ACCS
| Name | DR_ACCGROUPS_DR_ACCS |
| Comment | |
| Relationship type | Non Identifying |
| Cardinality | One Or More |
| Parent with columns | DR_ACCGROUPS (ACCGROUP) |
| Child with columns | DR_ACCS (ACCGROUP) |
| Update rule | None |
| Delete rule | None |
Relationship: DR_ACCGROUPS_DR_PRICES
| Name | DR_ACCGROUPS_DR_PRICES |
| Comment | |
| Relationship type | Non Identifying |
| Cardinality | One Or More |
| Parent with columns | DR_ACCGROUPS (ACCGROUP) |
| Child with columns | DR_PRICES (ACCGROUP) |
| Update rule | None |
| Delete rule | None |
Relationship: DR_ACCGROUPS_DR_PRICE_POLICY_ACC
| Name | DR_ACCGROUPS_DR_PRICE_POLICY_ACC |
| Comment | |
| Relationship type | Non Identifying |
| Cardinality | One Or More |
| Parent with columns | DR_ACCGROUPS (ACCGROUP) |
| Child with columns | DR_PRICE_POLICY_ACC (ACCGROUP) |
| Update rule | None |
| Delete rule | None |
Relationship: DR_ACCS_DR_ADDRESSES
| Name | DR_ACCS_DR_ADDRESSES |
| Comment | |
| Relationship type | Non Identifying |
| Cardinality | One Or More |
| Parent with columns | DR_ACCS (ACCNO) |
| Child with columns | DR_ADDRESSES (ACCNO) |
| Update rule | None |
| Delete rule | None |
Relationship: DR_ACCS_DR_CONTACTS
| Name | DR_ACCS_DR_CONTACTS |
| Comment | |
| Relationship type | Non Identifying |
| Cardinality | Zero Or More |
| Parent with columns | DR_ACCS (ACCNO) |
| Child with columns | DR_CONTACTS (ACCNO) |
| Update rule | None |
| Delete rule | None |
Relationship: DR_ACCS_DR_CONT_HIST
| Name | DR_ACCS_DR_CONT_HIST |
| Comment | |
| Relationship type | Non Identifying |
| Cardinality | Zero Or More |
| Parent with columns | DR_ACCS (ACCNO) |
| Child with columns | DR_CONT_HIST (ACCNO) |
| Update rule | None |
| Delete rule | None |
Relationship: DR_ACCS_DR_PRICES
| Name | DR_ACCS_DR_PRICES |
| Comment | |
| Relationship type | Non Identifying |
| Cardinality | One Or More |
| Parent with columns | DR_ACCS (ACCNO) |
| Child with columns | DR_PRICES (ACCNO) |
| Update rule | None |
| Delete rule | None |
Relationship: DR_ACCS_DR_PRICE_POLICY_ACC
| Name | DR_ACCS_DR_PRICE_POLICY_ACC |
| Comment | |
| Relationship type | Non Identifying |
| Cardinality | One Or More |
| Parent with columns | DR_ACCS (ACCNO) |
| Child with columns | DR_PRICE_POLICY_ACC (ACCNO) |
| Update rule | None |
| Delete rule | None |
Relationship: DR_ACCS_DR_TRANS
| Name | DR_ACCS_DR_TRANS |
| Comment | |
| Relationship type | Non Identifying |
| Cardinality | Zero Or More |
| Parent with columns | DR_ACCS (ACCNO) |
| Child with columns | DR_TRANS (ACCNO) |
| Update rule | None |
| Delete rule | None |
Relationship: DR_CONTACTS_DR_CONT_HIST
| Name | DR_CONTACTS_DR_CONT_HIST |
| Comment | |
| Relationship type | Non Identifying |
| Cardinality | One Or More |
| Parent with columns | DR_CONTACTS (CONTACT_SEQNO) |
| Child with columns | DR_CONT_HIST (CONTACT_SEQNO) |
| Update rule | None |
| Delete rule | None |
Relationship: DR_INVLINES_DR_INVLINES_SERIALS
| Name | DR_INVLINES_DR_INVLINES_SERIALS |
| Comment | |
| Relationship type | Non Identifying |
| Cardinality | Zero Or More |
| Parent with columns | DR_INVLINES (DRINVLINEID) |
| Child with columns | DR_INVLINES_SERIALS (INVLINEID) |
| Update rule | None |
| Delete rule | None |
Relationship: DR_INVLINES_SALESORD_HDR
| Name | DR_INVLINES_SALESORD_HDR |
| Comment | |
| Relationship type | Non Identifying |
| Cardinality | Zero Or More |
| Parent with columns | DR_INVLINES (ACCNO) |
| Child with columns | SALESORD_HDR (ACCNO) |
| Update rule | None |
| Delete rule | None |
Relationship: DR_PRICEGROUPS_DR_ACCS
| Name | DR_PRICEGROUPS_DR_ACCS |
| Comment | |
| Relationship type | Non Identifying |
| Cardinality | One Or More |
| Parent with columns | DR_PRICEGROUPS (GROUPNO) |
| Child with columns | DR_ACCS (PRICEGROUP) |
| Update rule | None |
| Delete rule | None |
Relationship: DR_PRICE_POLICY_DR_PRICES
| Name | DR_PRICE_POLICY_DR_PRICES |
| Comment | |
| Relationship type | Non Identifying |
| Cardinality | One Or More |
| Parent with columns | DR_PRICE_POLICY (POLICY_HDR) |
| Child with columns | DR_PRICES (POLICY_HDR) |
| Update rule | None |
| Delete rule | None |
Relationship: DR_PRICE_POLICY_DR_PRICE_POLICY_ACC
| Name | DR_PRICE_POLICY_DR_PRICE_POLICY_ACC |
| Comment | |
| Relationship type | Non Identifying |
| Cardinality | One Or More |
| Parent with columns | DR_PRICE_POLICY (POLICY_HDR) |
| Child with columns | DR_PRICE_POLICY_ACC (POLICY_HDR) |
| Update rule | None |
| Delete rule | None |
Relationship: DR_TRANS_DR_ALLOCATIONS
| Name | DR_TRANS_DR_ALLOCATIONS |
| Comment | |
| Relationship type | Non Identifying |
| Cardinality | Zero Or More |
| Parent with columns | DR_TRANS (SEQNO) |
| Child with columns | DR_ALLOCATIONS (TRANS_SEQNO) |
| Update rule | None |
| Delete rule | None |
Relationship: DR_TRANS_DR_INVLINES_ACCNO
| Name | DR_TRANS_DR_INVLINES_ACCNO |
| Comment | |
| Relationship type | Non Identifying |
| Cardinality | Zero Or More |
| Parent with columns | DR_TRANS (ACCNO) |
| Child with columns | DR_INVLINES (ACCNO) |
| Update rule | None |
| Delete rule | None |
Relationship: DR_TRANS_DR_INVLINES_SEQNO
| Name | DR_TRANS_DR_INVLINES_SEQNO |
| Comment | |
| Relationship type | Non Identifying |
| Cardinality | Zero Or More |
| Parent with columns | DR_TRANS (SEQNO) |
| Child with columns | DR_INVLINES (HDR_SEQNO) |
| Update rule | None |
| Delete rule | None |
Relationship: GLACCS_DR_TRANS
| Name | GLACCS_DR_TRANS |
| Comment | |
| Relationship type | Non Identifying |
| Cardinality | Zero Or More |
| Parent with columns | GLACCS (ACCNO) |
| Child with columns | DR_TRANS (GLCODE) |
| 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: 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: NARRATIVES_DR_INVLINES
| Name | NARRATIVES_DR_INVLINES |
| Comment | |
| Relationship type | Non Identifying |
| Cardinality | Zero Or More |
| Parent with columns | NARRATIVES (SEQNO) |
| Child with columns | DR_INVLINES (SEQNO) |
| Update rule | None |
| Delete rule | None |
Relationship: NARRATIVES_DR_TRANS
| Name | NARRATIVES_DR_TRANS |
| Comment | |
| Relationship type | Non Identifying |
| Cardinality | Zero Or More |
| Parent with columns | NARRATIVES (SEQNO) |
| Child with columns | DR_TRANS (NARRATIVE_SEQNO) |
| Update rule | None |
| Delete rule | None |
Relationship: NARRATIVES_SALESORD_HDR
| Name | NARRATIVES_SALESORD_HDR |
| Comment | |
| Relationship type | Non Identifying |
| Cardinality | Zero Or More |
| Parent with columns | NARRATIVES (SEQNO) |
| Child with columns | SALESORD_HDR (NARRATIVE_SEQNO) |
| Update rule | None |
| Delete rule | None |
Relationship: OPPORTUNITY_DR_TRANS
| Name | OPPORTUNITY_DR_TRANS |
| Comment | |
| Relationship type | Non Identifying |
| Cardinality | Zero Or More |
| Parent with columns | OPPORTUNITY (SEQNO) |
| Child with columns | DR_TRANS (OPPORTUNITY_SEQNO) |
| Update rule | None |
| Delete rule | None |
Relationship: OPPORTUNITY_SALESORD_HDR
| Name | OPPORTUNITY_SALESORD_HDR |
| Comment | |
| Relationship type | Non Identifying |
| Cardinality | Zero Or More |
| Parent with columns | OPPORTUNITY (SEQNO) |
| Child with columns | SALESORD_HDR (OPPORTUNITY_SEQNO) |
| Update rule | None |
| Delete rule | None |
Relationship: PAYMENT_TYPES_DR_TRANS
| Name | PAYMENT_TYPES_DR_TRANS |
| Comment | |
| Relationship type | Non Identifying |
| Cardinality | Zero Or More |
| Parent with columns | PAYMENT_TYPES (PTNO) |
| Child with columns | DR_TRANS (PTNO) |
| Update rule | None |
| Delete rule | None |
Relationship: PERIOD_STATUS_DR_ALLOCATIONS
| Name | PERIOD_STATUS_DR_ALLOCATIONS |
| Comment | |
| Relationship type | Non Identifying |
| Cardinality | Zero Or More |
| Parent with columns | PERIOD_STATUS (PERIOD_SEQNO) |
| Child with columns | DR_ALLOCATIONS (SEQNO) |
| Update rule | None |
| Delete rule | None |
Relationship: PERIOD_STATUS_DR_TRANS
| Name | PERIOD_STATUS_DR_TRANS |
| Comment | |
| Relationship type | Non Identifying |
| Cardinality | Zero Or More |
| Parent with columns | PERIOD_STATUS (SEQNO) |
| Child with columns | DR_TRANS (PERIOD_SEQNO) |
| Update rule | None |
| Delete rule | None |
Relationship: STAFF_CONTACTS
| Name | STAFF_CONTACTS |
| Comment | |
| Relationship type | Non Identifying |
| Cardinality | Zero Or More |
| Parent with columns | STAFF (STAFFNO) |
| Child with columns | CONTACTS (SALESNO) |
| Update rule | None |
| Delete rule | None |
Relationship: STAFF_DR_ACCS
| Name | STAFF_DR_ACCS |
| Comment | |
| Relationship type | Non Identifying |
| Cardinality | One Or More |
| Parent with columns | STAFF (STAFFNO) |
| Child with columns | DR_ACCS (SALESNO) |
| Update rule | None |
| Delete rule | None |
Relationship: STAFF_DR_CONT_HIST
| Name | STAFF_DR_CONT_HIST |
| Comment | |
| Relationship type | Non Identifying |
| Cardinality | One Or More |
| Parent with columns | STAFF (STAFFNO) |
| Child with columns | DR_CONT_HIST (SALESNO) |
| Update rule | None |
| Delete rule | None |
Relationship: STAFF_DR_TRANS
| Name | STAFF_DR_TRANS |
| Comment | |
| Relationship type | Non Identifying |
| Cardinality | Zero Or More |
| Parent with columns | STAFF (STAFFNO) |
| Child with columns | DR_TRANS (SALESNO) |
| 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_DR_PRICES
| Name | STOCK_ITEMS_DR_PRICES |
| Comment | |
| Relationship type | Non Identifying |
| Cardinality | Zero Or More |
| Parent with columns | STOCK_ITEMS (STOCKCODE) |
| Child with columns | DR_PRICES (STOCKCODE) |
| Update rule | None |
| Delete rule | None |
Relationship: TAX_RATES_DR_INVLINES
| Name | TAX_RATES_DR_INVLINES |
| Comment | |
| Relationship type | Non Identifying |
| Cardinality | Zero Or More |
| Parent with columns | TAX_RATES (SEQNO) |
| Child with columns | DR_INVLINES (TAXRATE_NO) |
| Update rule | None |
| Delete rule | None |
Relationship: TAX_RATES_DR_TRANS
| Name | TAX_RATES_DR_TRANS |
| Comment | |
| Relationship type | Non Identifying |
| Cardinality | Zero Or More |
| Parent with columns | TAX_RATES (SEQNO) |
| Child with columns | DR_TRANS (TAXRATE_NO) |
| Update rule | None |
| Delete rule | None |
|