TAAS

=>Menu -> More -> AMEX-BTA
=>GUI
-> Date*R
-> OK button
=>Right side main buttons
->I-File -> Title->Invoice File - Corporate Card Pay to Supplier -> <i class="fa fa-file-o" aria-hidden="true"></i> Download file
->C-File -> Title->Charge File - Corporate Card Pay to Travel Agency -> <i class="fa fa-file-o" aria-hidden="true"></i> Download File
-> Send -> <i class="fa fa-share-square-o" aria-hidden="true"></i>
->New
->Reset
-------------------------------
->Tab1 -> Invoice File
->List
-Grouping No Grouping, Sale/Refund, Sale/Refund/Conjunction, Sent/Not Sent/Error, Service
* Ref AMEX document(Junide) + | Status(Sent or Not Sent) | Sent Date & Time | Last Modified Date & Time | redirect icon - document history

->Tab2 -> Charge File
->List
-Grouping No Grouping, Sale/Refund, Sale/Refund/Conjunction, Sent/Not Sent/Error, Service
* Ref AMEX document(Junide) + | Status(Sent or Not Sent) | Sent Date & Time | Last Modified Date & Time | redirect icon - document history

->Tab3 -> Other Documents 
->List
- Date | Document No | Debit | Credit | Reference | Narration 

=> Table
---------
CREATE TABLE amex.tbl_amex_file_generation (
    pk_amex_file_generation_id BIGSERIAL PRIMARY KEY,

    dat_transaction DATE,
    sin_file_type SMALLINT DEFAULT 1, --1=Invoice File, 2=Charge File
    vhr_file_name VARCHAR(500) DEFAULT '',

    bin_sale_item_count BIGINT DEFAULT 0,
    bin_sale_conjunction_count BIGINT DEFAULT 0,
    bin_refund_item_count BIGINT DEFAULT 0,
    bin_refund_conjunction_count BIGINT DEFAULT 0,
    sin_status SMALLINT DEFAULT 1,--1=Sent, 0=Not Sent, -1=Error

    txt_sys_error TEXT DEFAULT '',
    txt_error TEXT DEFAULT ''

) INHERITS(tbl_action_user_and_date_time);

CREATE TABLE amex.tbl_amex_file_gen_details (
    pk_amex_file_gen_details_id BIGSERIAL PRIMARY KEY,
    fk_amex_file_generation_id BIGINT NOT NULL REFERENCES amex.tbl_amex_file_generation(pk_amex_file_generation_id),

    sin_sale_or_refund SMALLINT DEFAULT 1, --1=Sale, -1=Refund
    fk_supp_doc_no_id BIGINT NOT NULL REFERENCES service.tbl_supp_doc_no(pk_supp_doc_no_id),
    dbl_amount DOUBLE PRECISION DEFAULT 0.0,
    int_current_doc_sys_action_id INT DEFAULT 0 NOT NULL -- Edit or not after File gen
);