TAAS

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);