tt_generate_return_note_return_purch_invoice

CREATE TABLE tt_generate_return_note_return_purch_invoice
(
    type_data   character varying(30), --berisi sat/midi
    sales_invoice_no character varying(50),
    sales_invoice_date character varying(8),
    lpb_no  character varying(100),
    nrb_no  character varying(50),
    draft_ref_no character varying(100),
    product_code character varying(100),
    product_id bigint default -99,
    qty_return  numeric,
    dpp_price   numeric,
    tax_price   numeric,
    doc_date    character varying(8),
    tax_date    character varying(8),

    product_balance_id bigint default -99,
    base_uom_id bigint default -99,
    so_id       bigint default -99,
    do_id       bigint default -99,
    do_item_id  bigint default -99,
    po_id       bigint default -99,
    receive_goods_id bigint default -99,
    receive_goods_item_id bigint default -99,
    si_id       bigint default -99,
    curr_code   character varying(5) default '',
    si_partner_id bigint default -99,
    si_ou_id bigint default -99,
    purch_invoice_id bigint default -99,
    purch_invoice_ou_id bigint default -99,
    purch_invoice_partner_id bigint default -99,
    return_note_id bigint default -99,
    return_note_item_id bigint default -99,
    rsi_id  bigint default -99,
    si_tax_no character varying(50),
    claim_note_id bigint default -99,
    claim_note_item_id bigint default -99,
    rpi_id  bigint default -99,
    purch_invoice_tax_no character varying(50),
    flg_process_return_note character varying(1) default 'N',
    flg_process_claim_note character varying(1) default 'N',
    flg_process_rsi character varying(1) default 'N',
    flg_process_rpi character varying(1) default 'N'
)
WITH (
  OIDS=FALSE
);