Scribd Logo
Upload

Welcome to Scribd!

  • 223 views

    Table Name: Original Data Primary Key-Original Key, Foreign Key-Invoice No, DC - No

    Uploaded by

    anand_gsoft3603
    The document describes four database tables - Original Data, Watermark Data, Decoding Key, and Invoice Main. The Original Data table contains a primary key and foreign keys linking to other tables. The Watermark Data table links to the Original Data table. The Decoding Key table links the Original and Watermark tables. The Invoice Main table is the primary table for invoices and contains fields for taxes, amounts, and identifiers.

    Copyright:

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

    Table Name: Original Data Primary Key-Original Key, Foreign Key-Invoice No, DC - No

    Uploaded by

    anand_gsoft3603
    223 views4 pages
    The document describes four database tables - Original Data, Watermark Data, Decoding Key, and Invoice Main. The Original Data table contains a primary key and foreign keys linking to other tables. The Watermark Data table links to the Original Data table. The Decoding Key table links the Original and Watermark tables. The Invoice Main table is the primary table for invoices and contains fields for taxes, amounts, and identifiers.

    Original Description:

    nil

    Original Title

    Table Design

    Copyright

    © © All Rights Reserved

    Available Formats

    DOCX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document describes four database tables - Original Data, Watermark Data, Decoding Key, and Invoice Main. The Original Data table contains a primary key and foreign keys linking to other tables. The Watermark Data table links to the Original Data table. The Decoding Key table links the Original and Watermark tables. The Invoice Main table is the primary table for invoices and contains fields for taxes, amounts, and identifiers.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    223 views4 pages

    Table Name: Original Data Primary Key-Original Key, Foreign Key-Invoice No, DC - No

    Uploaded by

    anand_gsoft3603
    The document describes four database tables - Original Data, Watermark Data, Decoding Key, and Invoice Main. The Original Data table contains a primary key and foreign keys linking to other tables. The Watermark Data table links to the Original Data table. The Decoding Key table links the Original and Watermark tables. The Invoice Main table is the primary table for invoices and contains fields for taxes, amounts, and identifiers.

    Copyright:

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

    Table Name : Original Data

    PRIMARY KEY-ORIGINAL KEY,


    FOREIGN KEY-INVOICE NO ,DC_NO

    Table Name : Watermark Data


    PRIMARY KEY-WATERMARK KEY,FOREIGN KEYORIGINAL KEY

    Table Name : Decoding Key


    FOREIGN KEY-ORIGINAL KEY,WATERMARK KEY

    Table Name : Invoice Main


    Primary Key : Inv_No

    Table Name : Invoice Main


    Primary Key : Inv_No

    VAT_CHK

    VARCHAR

    15

    NULL

    CST_CHK

    VARCHAR

    15

    NULL

    TAX_P

    NUMBER

    15

    NULL

    TAX_AMT

    NUMBER

    15

    NULL

    CHK_1

    VARCHAR

    15

    NULL

    1_TXT

    VARCHAR

    15

    NULL

    1_AMT

    NUMBER

    15

    NULL

    CHK_2

    VARCHAR

    15

    NULL

    2_TXT

    NUMBER

    15

    NULL

    2_AMT

    NUMBER

    15

    NULL

    NET_AMT

    NUMBER

    15

    NULL

    CST_NO

    VARCHAR

    15

    NULL

    INV_CAN

    VARCHAR

    15

    NULL

    You might also like