Scribd Logo
Upload

Welcome to Scribd!

  • 213 views

    r121 Auto Cash App Erd

    Uploaded by

    Lam Tran
    The document describes the relationships between various tables in an accounts receivable database design. There are tables for cash receipt recommendations and lines, cash receipts and remittance references, auto-matching rules and details, lockboxes, and customer profile classes and profiles. The tables are connected through foreign keys to link related data across the various AR tables.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd

    r121 Auto Cash App Erd

    Uploaded by

    Lam Tran
    213 views2 pages
    The document describes the relationships between various tables in an accounts receivable database design. There are tables for cash receipt recommendations and lines, cash receipts and remittance references, auto-matching rules and details, lockboxes, and customer profile classes and profiles. The tables are connected through foreign keys to link related data across the various AR tables.

    Original Description:

    r121 Auto Cash App Erd

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document describes the relationships between various tables in an accounts receivable database design. There are tables for cash receipt recommendations and lines, cash receipts and remittance references, auto-matching rules and details, lockboxes, and customer profile classes and profiles. The tables are connected through foreign keys to link related data across the various AR tables.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    213 views2 pages

    r121 Auto Cash App Erd

    Uploaded by

    Lam Tran
    The document describes the relationships between various tables in an accounts receivable database design. There are tables for cash receipt recommendations and lines, cash receipts and remittance references, auto-matching rules and details, lockboxes, and customer profile classes and profiles. The tables are connected through foreign keys to link related data across the various AR tables.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    of 2

    AR_CASH_RECO_LINES_ALL (apps/ar/D

    AR_CASH_RECOS_ALL (apps/ar/Database Objects/AR Design)

    AR_CASH_RECO_LINES_ALL_FK1 RECOMMENDATION_ID
    RECOMMENDATION_ID LINE_NUMBER
    REMIT_REFERENCE_ID CUSTOMER_TRX_ID
    PAY_FROM_CUSTOMER
    RESOLVED_MATCHING_NUMBER
    RESOLVED_MATCHING_DATE
    AR_CASH_RECOS_ALL_FK1

    AR_CASH_REMIT_REFS_ALL_FK1
    AR_CASH_RECEIPTS_ALL (apps/ar/Database Objects/AR Design) AR_CASH_REMIT_REFS_ALL (apps/ar/D

    CASH_RECEIPT_ID REMIT_REFERENCE_ID
    LAST_UPDATED_BY AUTOMATCH_SET_ID
    LAST_UPDATE_DATE CASH_RECEIPT_ID
    LAST_UPDATE_LOGIN LINE_NUMBER
    CREATED_BY
    CREATION_DATE

    AR_CASH_AUTOMATCHES (apps/ar/Database Objects/AR Design)

    AUTOMATCH_ID
    MATCHING_OPTION
    AR_CASH_AUTOMATCH_RULE_MAP_FK2
    AUTO_MATCH_THRESHOLD
    SUGG_MATCH_THRESHOLD
    _REMIT_REFS_ALL_FK2

    AR_CASH_AUTOMATCH_RULE_MAP (apps/ar/Database Obj


    MATCH_DTLS_FK1

    AUTOMATCH_RULE_SET_MAP_ID
    AUTOMATCH_SET_ID
    AUTOMATCH_ID
    _FK1
    AR_CASH_AUTOMATCH_RULE_MAP_FK
    AR_CASH_R
    AR_CASH_AUTOMA

    AR_CASH_AUTOMATCH_DTLS (apps/ar/Database Objects/AR Design)

    AUTOMATCH_DTL_ID
    AUTOMATCH_ID
    PADDING_SEQUENCE
    AR_CASH_AUTO_RULE_SETS (apps/ar

    AUTOMATCH_SET_ID
    START_DATE
    AR_SYSTEM_PARAMETERS_ALL_FK1 END_DATE
    ACTIVE_FLAG
    EXCEPTION_REASON
    CREATED_BY
    CREATION_DATE
    LAST_UPDATED_BY
    AR_SYSTEM_PARAMETERS_ALL (apps/ar/Database Objects/AR Design) LAST_UPDATE_DATE
    LAST_UPDATE_LOGIN
    AR_CASH_RULE_SETS_ALL_PK1
    SET_OF_BOOKS_ID
    CREATED_BY
    CREATION_DATE
    HZ_CUST_PROFILE_CLASSES_FK1

    AR_LOCKBOXES_ALL_FK1
    AR_LOCKBOXES_ALL (apps/ar/Database Objects/AR Design) AR_CUSTOMER_PROFILE_FK2

    LOCKBOX_ID
    CREATED_BY
    CREATION_DATE

    HZ_CUST_PROFILE_CLASSES (apps/ar/Database Objects/AR Design)

    PROFILE_CLASS_ID
    HZ_CUSTOMER_PROFILES_FK3
    LAST_UPDATED_BY
    HZ_CUSTOMER_PROFILES (apps/ar/Data
    LAST_UPDATE_DATE

    CUST_ACCOUNT_PROFILE_ID
    LAST_UPDATED_BY
    LAST_UPDATE_DATE
    LAST_UPDATE_LOGIN

    You might also like