Project

General

Profile

Edit Copy Actions

Feature #490

open

AMEX File Settings

Added by Arathy PS about 2 months ago. Updated 4 days ago.

Status:
New Changes Coding Done
Priority:
Normal
Assignee:
Target version:
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:

Add

Subtasks


Add

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);
Actions #2

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
Actions #3

Updated by Greeshma S about 2 months ago

  • Assignee changed from Greeshma S to Junaid M
Actions #4

Updated by Arathy PS about 2 months ago

  • Assignee changed from Junaid M to Greeshma S
Actions #5

Updated by Greeshma S about 2 months ago

  • Status changed from Ready for Coding to Coding Started
  • % Done changed from 20 to 30
Actions #6

Updated by Greeshma S about 1 month ago

  • Status changed from Coding Started to Coding Done
  • % Done changed from 30 to 60

Updated by Arathy PS 6 days ago

  • Status changed from Coding Done to New Changes
  • % Done changed from 60 to 50

NEW CHANGE
-------------------------
The custom fields that are set for a customer in set corporate custom field should be the one showing as the label in amex file setting custom field label.

Actions #8

Updated by Greeshma S 4 days ago

  • Status changed from New Changes to New Changes Coding Done
  • % Done changed from 50 to 70
Edit Copy Actions

Also available in: Atom PDF