Feature #490
openAMEX File Settings
Start date:
01/25/2025
Due date:
% Done:
70%
Estimated time:
Owner(Agency):
Travvise
Time Taken(HH):
Module:
AMEX File Settings
Tested By:
Code Reviewed By:
Subtasks
Related issues
Updated by Arathy PS about 2 months ago
AMEX File Settings ======================== =>Menu -> More -> AMEX-BTA =>GUI(Like company) *Left Side -> AMEX Corporate Card*R multiSelectbox(*Corporate Card->Provider == AMEX AND UCCF tick, Default Tick all, all tick then keep empty in table) -> Agent Code*R inputbox Title->Submission Agent Reference Code(The Travel Agent unique identifier specified by AEME) Send Period*R - Selectbox - Daily Created By: Modified By: *Right Side =>Tab1 - Time*R -> Time Add button in header (Ref Transfer Issue>pickup time widget) -> List-> # | Time | Delete icon =>Tab2 - Send Days*R -List -> # | Checkbox | Days =>Tab3 - Travel Office Code *List # | Branch | Office Code | Edit icon =>Tab3 - Custom data -> Header -> Add button # | Customer | Edit icon ->Add button popup Customer*R - Checkbox|Code | Name - OK button * Checkbox title-> General (Not select Customer) # | Custom Filed No | Custom data | Edit icon *Custom data->Corporate Custom files with Corporate cost centre also, Eg: {{TRIP_ID}}, Load from each Corporate customer Custom data - Ref Set Corporate Custom data modules * Showing 7 records default Eg:- 1 | 1 | | ... .... 7 | 7 | | * Print Not need => Table --------- *Travel->table.sql last CREATE SCHEMA IF NOT EXISTS amex; --@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ --@@@@@@@@@@@@@@@@@@@@@@@@@@@ AMEX @@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ --@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ --Use : --Ref : --Case: --Note: CREATE TABLE amex.tbl_amex_file_settings ( pk_amex_file_settings_id BIGSERIAL PRIMARY KEY, arb_fk_corporate_ac_ids BIGINT ARRAY, --Tick all then empty vhr_aeme_agent_code VARCHAR(500) NOT NULL, --Submission Agent Reference Code(The Travel Agent unique identifier specified by AEME) sin_send_period SMALLINT DEFAULT 1, -- 1=Daily arh_send_times TIME ARRAY, ars_send_days SMALLINT ARRAY, --Sunday=0, Monday=1, Saturday=6(Create a base data service) jsn_aeme_office_code JSON ARRAY, -- [{'BRANCH_ID' : , 'OFFICE_CODE' : }, ] jsn_custom_data JSON ARRAY -- [{{'CUSTOM_AC_ID' : , 'CUSTOM_FIELD_NO' : , 'CUSTOM_DATA' : }, ] ) INHERITS(tbl_action_user_and_date_time);
Updated by Anil KV about 2 months ago
- Status changed from New to Ready for Coding
- Assignee changed from travvise Admin to Greeshma S
- % Done changed from 0 to 20
Updated by Greeshma S about 2 months ago
- Assignee changed from Greeshma S to Junaid M
Updated by Arathy PS about 2 months ago
- Assignee changed from Junaid M to Greeshma S
Updated by Greeshma S about 2 months ago
- Status changed from Ready for Coding to Coding Started
- % Done changed from 20 to 30
Updated by Greeshma S about 1 month ago
- Status changed from Coding Started to Coding Done
- % Done changed from 30 to 60
Updated by Greeshma S 4 days ago
- Status changed from New Changes to New Changes Coding Done
- % Done changed from 50 to 70