Mohammed Nazeeruddin

[TNSS-7884] (v.4.15.00.00) DB file changes for new branch.
    • ?
    /branches/b_4_15_00_00/Database/DBUnload/DB_RELEASE.dat
[TNSS-7806] Made code changes after code merge for DB version number to match TAMSII app version number.

Fixed errors occurred during execution of test_and_compare_vx_script.sh

[TNSS-7758] (v.4.13.02.00) Made code changes for re-build.

[TNSS-7758] (v.4.13.01.00) Made code changes after code merge for DB version number to match TAMSII app version number.

[EOD-193] Lock flag in TAMS to prevent on hand change.

Adding constraint CHECK (PREVENT_ON_HAND_CHANGE IN (0,1,10,11)) in CLASSIFICATION_PROFILE table.

[EOD-188] Add Security Option for Auto EOD SQL.
[EOD-192] Add Column 'EXPORT_ORDER_AS_CSV' to Table 'VENDOR' for export ordering for UAP.
[SPP-200] Data - Build Pricing Job Status table.

Adding new table: "PRICING_JOB_STATUS".

[TNSS-7701] (v.4.12.03.00) Incremented Upgrade_v.4.11.04.00_to_v.4.12.03.00
[SPP-201] Data - Build Product Level pricing table

Adding new table: 'PRODUCT_LEVEL_PRICING' and related FK's, Index and Triggers.

[SPP-245] Data - Fix to 'sp_drop_object' stored procedure as it's failing for table name with size greater than 36.

[SPP-196] Data - Build CUSTOMER_SEGMENT_TO_PRODUCT_SEGMENT_PRICING table.

Adding new table: 'CUSTOMER_SEGMENT_TO_PRODUCT_SEGMENT_PRICING' and related FK's, Index and Triggers.

    • ?
    /branches/b_4_14_00_00/Database/DBUnload/SYS_TABLE.dat
[TNSS-7806] (v.4.14.00.00) DB file changes for new branch.
    • ?
    /branches/b_4_14_00_00/Database/DBUnload/DB_RELEASE.dat
[TNSS-7758] (v.4.13.00.00) DB file changes after code merge.
[TNSS-7701] (v.4.12.02.00) Made code changes after code merge for DB version number to match TAMSII app version number.
[EOD-168] Add new DB Tables for Days Closed and hours of operation.
[TNSS-7783] (v.4.11.04.00) Two paths for rebuild:

1. Upgrade_v.4.10.03.00_to_v.4.11.04.00.sql

2. Upgrade_v.4.11.03.00_to_v.4.11.04.00.sql

[TNSS-7701] (v.4.12.01.00) Incremented Upgrade_v.4.11.03.00_to_v.4.12.01.00
[SPP-199] Data - Build Customer to Product Segment pricing table.

Created new table: 'CUSTOMER_TO_PRODUCT_SEGMENT_PRICING' and related FK's, Index, Triggers and Permissions.

[SPP-197] Data - Build Customer to Customer Segment table.

Adding new table: 'CUSTOMER_TO_CUSTOMER_SEGMENT' and related Index and Triggers.

[TNSS-7753] Increase the length of the password column in EMPLOYEE and PASSWORD_HISTORY to 60 characters.
[SPP-198] Data - Build Customer to Item pricing table.

Adding new table: 'CUSTOMER_TO_ITEM_PRICING' and related FK's, Index and Triggers.

    • ?
    /branches/b_4_13_00_00/Database/DBUnload/SYS_TABLE.dat
[TNSS-7758] (v.4.13.00.00) DB file changes for new branch.
    • ?
    /branches/b_4_13_00_00/Database/DBUnload/DB_RELEASE.dat
[STEL-2627] Adding entry in REF_AR_TRANSACTION_TYPE.
[TNSS-7701] (v.4.12.00.00) Remove old DB script file.

[TNSS-7648] (v.4.11.03.00) Incremented DB version number match for re-build.
[TNSS-7648] (v.4.11.02.00) Make DB version number match TAMSII app version number.
[TNSS-7637] IPC - DB - UUID will be used to track the transaction in the new PAV.

The IPC_JOURNEY_KEY column size in INVOICE_PAYMENT table increase to 36.

[TNSS-7577] Changes MULTI_STORE_PROFILE.PAUSE_TMS from Y/N to utilize GETDATE().
[TNSS-7648] (v.4.11.01.00) Make DB version number match TAMSII app version number.
[TNSS-7702] (v.4.10.03.00) Two paths for rebuild:

1. Upgrade_v.4.09.03.00_to_v.4.10.03.00.sql

2. Upgrade_v.4.10.02.00_to_v.4.10.03.00.sql