table design

5
Table Name : Original Data PRIMARY KEY-ORIGINAL KEY, FOREIGN KEY-INVOICE NO ,DC_NO Table Name : Watermark Data PRIMARY KEY-WATERMARK KEY,FOREIGN KEY- ORIGINAL KEY

Upload: anandgsoft3603

Post on 18-Dec-2015

212 views

Category:

Documents


0 download

DESCRIPTION

nil

TRANSCRIPT

Table Name : Original DataPRIMARY KEY-ORIGINAL KEY, FOREIGN KEY-INVOICE NO ,DC_NO

Table Name : Watermark DataPRIMARY KEY-WATERMARK KEY,FOREIGN KEY-ORIGINAL KEY

Table Name : Decoding KeyFOREIGN KEY-ORIGINAL KEY,WATERMARK KEY

Table Name : Invoice MainPrimary Key : Inv_No

Table Name : Invoice MainPrimary Key : Inv_No

VAT_CHKVARCHAR15NULL

CST_CHKVARCHAR15NULL

TAX_PNUMBER15NULL

TAX_AMTNUMBER15NULL

CHK_1VARCHAR15NULL

1_TXTVARCHAR15NULL

1_AMTNUMBER15NULL

CHK_2VARCHAR15NULL

2_TXTNUMBER15NULL

2_AMTNUMBER15NULL

NET_AMTNUMBER15NULL

CST_NOVARCHAR15NULL

INV_CANVARCHAR15NULL