Data Conversion Tables
                    ======================

------------------------------------------------------------------------
dcpinvce - mirror of stpinvce
    inv_no char(20),
    department char(3),
    file_type char(1),
    ref_no integer,
    inv_desc char(30),
    doc_date date,
    vend_code char(20),
    pay_to_code char(6),
    posted char(1),
    recurring char(1),
    terms_code char(6),
    inv_date date,
    to_pay_date date,
    due_date date,
    disc_date date,
    disc_pct decimal(6),
    po_date date,
    po_no char(10),
    disc_acct_no integer,
   
disc_department char(3),
    disc_amount decimal(12),
    disc_debit_credit char(2),
    ap_acct_no integer,
    ap_department char(3),
    ap_amount decimal(12),
    ap_debit_credit char(2),
    ok_to_post char(1),
    cash_acct_no integer,
    cash_department char(3),
    recurr_ref char(10),
    def_mtaxcd char(6),
    gross_entry char(1),
    currency_code char(3),
    curr_ex_rate decimal(16),
    home_curr_amount decimal(12),
    fix_date_flag char(1),
    recurr_cnt integer,
    orig_journal char(2),
    trans_doc_no integer

create unique index i1cpinvce on dcpinvce (vend_code, inv_no);

------------------------------------------------------------------------
dcpinvcd - mirror of stpinvcd
    vend_code char(20),
    inv_no char(20),
    line_no smallint,
    acct_no integer,
    department char(3),
    amount decimal(12),
    debit_credit char(2),
    mtax_code char(6),
    goods_amt decimal(12)

create index i1cpinvcd on dcpinvcd (vend_code,inv_no,line_no);

------------------------------------------------------------------------
dcrinvce - mirror of strinvce
    inv_no char(10),
    department char(3),
    file_type char(1),
    ref_no char(10),
    tax char(6),
    inv_desc char(30),
    inv_date date,
    inv_note char(30),
    cust_code char(20),
    ship_to_code char(6),
    posted char(1),
    recurring char(1),
    terms_code char(6),
    due_date date,
    disc_date date,
    disc_pct decimal(6),
    po_no char(10),
   
po_date date,
    disc_acct_no integer,
    disc_department char(3),
    disc_amount decimal(12),
    disc_debit_credit char(2),
    tax_acct_no integer,
    tax_department char(3),
    tax_amount decimal(12),
    tax_debit_credit char(2),
    frght_acct_no integer,
    frght_department char(3),
    frght_amount decimal(12),
    frght_debit_credit char(2),
    misc_acct_no integer,
    misc_department char(3),
    misc_amount decimal(12),
    misc_debit_credit char(2),
    ar_acct_no integer,
    ar_department char(3),
    ar_amount decimal(12),
    ar_debit_credit char(2),
    ok_to_post char(1),
    recurr_ref char(10),
    gross_entry char(1),
    currency_code char(3),
    curr_ex_rate decimal(16),
    home_curr_amount decimal(12),
    batch_id integer,
    orig_journal char(2),
    trans_doc_no integer,
    doc_date date

create unique index i1crinvce on dcrinvce (inv_no);

------------------------------------------------------------------------
dcrinvcd - mirror of strinvcd
    inv_no char(10),
    line_no smallint,
    acct_no integer,
    department char(3),
    amount decimal(12),
    debit_credit char(2),
    item_no char(8),
    quantity float,
    pack char(6),
    description char(20),
    price decimal(12),
    mtax_code char(6)

create index i1crinvcd on dcrinvcd (inv_no);

------------------------------------------------------------------------
dcrcustr - mirror of strcustr
    cust_code char(20),
    bridge_code char(20),
    bus_name char(30),
    taxable char(6),
    contact char(20),
    phone char(20),
    fax_phone char(20),
    address1 char(30),
    address2 char(30),
    city char(20),
    state char(2),
    zip char(10),
    country char(20),
    ar_type char(1),
    preferred char(1),
    frequent char(1),
    stmt_cycle smallint,
    fin_chg char(1),
    credit_limit decimal(12),
    order_limit decimal(12),
    terms_code char(6),
    act_grp char(6),
    ar_acct_dflt integer,
    ar_department_dflt char(3),
    stmt_date date,
    stmt_amount decimal(12),
    obtained_date date,
    last_order_date date,
    last_pay_date date,
    inactive_date date,
    on_acct_amt decimal(12),
    arch_bal decimal(12),
    sls_psn_code char(6),
    trd_ds_code char(6),
    st_tx_code char(6),
    co_tx_code char(6),
    ci_tx_code char(6),
    comm_code char(6),
    pay_method char(6),
    card_no char(20),
    exp_date char(5),
    card_holder char(20),
    cc_method char(6),
    mtax_fc char(6),
    currency_code char(3),
    mtax_freight char(6),
    mtax_misc char(6),
    ship_via_cd char(3),
    ship_terms char(15),
    ups_account char(10),
    email char(50),
    web_address char(50),
    cell_phone char(20),
    credit_hold char(1),
    credit_manager char(8),
    credit_letter char(1),
    credit_hold_date date,
    residential_cust char(1),
    ship_complete char(1),
    loaded smallint

create unique index i1crcustr on dcrcustr (cust_code);

------------------------------------------------------------------------
dcgactvd - mirror of stgactvd/stgtranr/stxtranr
    reference char(20),
    description char(30),
    orig_journal char(2) not null ,
    doc_no integer not null ,
    acct_no integer not null ,
    department char(3) not null ,
    amount decimal(12) not null ,
    date date not null ,
    debit_credit char(1) not null ,
    loaded smallint

create index i1cgactvd on dcgactvd (orig_journal, doc_no);

------------------------------------------------------------------------
dcxchrtr - mirror of stxchrtr
    acct_no integer not null ,
    acct_type char(15),
    acct_desc char(30),
    acct_cat char(1),
    processing_seq char(1),
    incr_with_crdt char(1),
    subtotal_group char(30),
    manual_journal char(1),
    loaded smallint

create unique index i1cxchrtr on dcxchrtr (acct_no);

------------------------------------------------------------------------
dcxchrtd - mirror of stxchrtd
    acct_no integer,
    department char(3),
    period_month char(2),
    period_year char(4),
    activity decimal(12),
    balance decimal(12),
    this_month decimal(12),
    budget decimal(12),
    loaded smallint

create unique index i1cxchrtd on dcxchrtd
    (acct_no, department,period_year,period_month);

------------------------------------------------------------------------
dciinvtr - mirror of stiinvtr
    item_code char(20),
    item_type char(1),
    item_class char(6),
    price_group char(6),
    desc1 char(30),
    desc2 char(30),
    weight decimal(8,3),
    weight_unit char(2),
    volume decimal(8,3),
    inv_acct_no integer,
   
cog_acct_no integer,
    sales_acct_no integer,
    sell_unit char(2),
    bill_unit char(2),
    stock_unit char(2),
    purch_unit char(2),
    sell_factor decimal(6),
    bill_factor decimal(6),
    purch_factor decimal(6),
    serialized char(1),
    market_price char(1),
    commodity_code char(10),
    vend_code char(20),
    incr_sell_unit decimal(10),
    incr_purch_unit decimal(10),
    comm_code char(6),
    loaded smallint

create unique index i1ciinvtr on dciinvtr (item_code);

------------------------------------------------------------------------
dcilocar - mirror of stilocar
    item_code char(20),
    warehouse_code char(10),
    line_no smallint,
    count_cycle char(1),
    purchase_date date,
    count_date date,
    sold_date date,
    obsolete char(1),
    inactive_date date,
    lst_act_date date,
    loc_aisle char(4),
    loc_row char(3),
    loc_bin char(3),
    stock_location char(12),
    avg_unit_cost decimal(12),
    purch_unit_cost decimal(12),
    last_cost decimal(12),
    comm_code char(6),
    price decimal(12),
    allow_bo char(1),
    taxable char(1),
    terms_disc char(1),
    trade_disc char(1),
    vend_code char(20),
    vend_prod_no char(20),
    abc_code char(1),
    reorder_point decimal(10),
    qty_reorder decimal(10),
    safety_stock decimal(10),
    safety_factor decimal(6),
    qty_on_hand decimal(10),
    last_qty decimal(10),
    stk_out_date date,
    seasonal char(1),
    avg_ld_tm decimal(5,2),
    lst_ld_tm smallint,
    pri_ld_tm smallint,
    freez_flag char(1),
    freez_date date,
    freez_expir date,
    min_sell_qty decimal(10),
    usage_rate decimal(10),
    req_profit_pct decimal(6),
    loaded smallint

create unique index i1cilocar on dcilocar (item_code, warehouse_code);

------------------------------------------------------------------------
dcxmape - Column mapping header table
    table_name char(18),
    col_name char(18),
    description char(40)

create unique index i1cxmape on dcxmape (table_name, col_name);

------------------------------------------------------------------------
dcxmapd - Column mapping detail table
    table_name char(18),
    col_name char(18),
    old_value char(40),
    new_value char(40),
    default_value char(1)

create index i1cxmapd on dcxmapd (table_name, col_name);

------------------------------------------------------------------------
dcoordre - mirror of stoordre
    order_no char(10),
    inv_no char(10),
    po_no char(24),
   
ack_printed char(1),
    order_type char(3),
    like_type char(3),
    order_date date,
    to_ship_date date,
    alloc_date date,
    warehouse_code char(10),
    department char(3),
    sls_psn_code char(6),
    cust_code char(20),
    ship_to_code char(6),
    bill_to_code char(20),
    terms_code char(6),
    pay_method char(6),
    payment char(1),
    card_no char(20),
    exp_date char(5),
    card_holder char(20),
    check_no char(8),
    trd_ds_code char(6),
    trd_ds_type char(1),
    trd_ds_rate decimal(6),
    mtaxg_code char(6),
    fob_point char(15),
    ship_via char(15),
    currency_code char(3),
    curr_rate_type char(6),
    currency_rate decimal(16),
    ship_terms char(15),
    residential_cust char(1),
    email char(50),
    ups_account char(10),
    mtax_freight char(6),
    auth_amt decimal(10,2),
    auth_code char(8),
    auth_date date,
    decline_code char(8),
    decline_message char(60),
    ship_complete char(1),
    loaded smallint

create unique index i1coordre on dcoordre (order_no);

------------------------------------------------------------------------
dcoordrd - mirror of stoordrd
    order_no char(10),
    line_no smallint,
    kit_group smallint,
    kit_line_no smallint,
    price_lock char(1),
    line_type char(3),
    like_type char(3),
    cm_dm_reason char(3),
    our_po_no char(10),
    sls_psn_code char(6),
    warehouse_code char(10),
    item_code char(20),
    desc1 char(30),
    desc2 char(30),
    alias_code char(20),
   
vend_code char(20),
    interchanged char(1),
    serialized char(1),
    td_disc_allowed char(1),
    tax char(1),
    ordr_qty decimal(10),
   
price decimal(12),
    price_code integer,
    inv_acct integer,
    inv_dept char(3),
    sls_acct integer,
    sls_dept char(3),
    cog_acct integer,
    cog_dept char(3),
    intl_lic_no char(30),
    release_qty decimal(10),
    resale_price decimal(18),
   
mtaxg_code char(6)

create unique index i1coordrd on dcoordrd (order_no, line_no);

------------------------------------------------------------------------
dcppytor - mirror of stppytor
    vend_code char(20),
    pay_to_code char(6),
    pay_to_name char(30),
    contact char(20),
    phone char(20),
    address1 char(30),
    address2 char(30),
    city char(20),
    state char(2),
    zip char(10),
    country char(20),
    take_dscnt char(1),
    spec_billing char(50),
    taxable char(6),
    bo_allowed char(1),
    pay_method char(6),
    buyer_code char(6),
    trd_ds_code char(6),
    eta_days smallint,
    st_tx_code char(6),
    co_tx_code char(6),
    ci_tx_code char(6),
    email char(50),
    web_address char(50),
    cell_phone char(20),
    fax_phone char(20),
    loaded smallint

create unique index i1cppytor on dcppytor (vend_code, pay_to_code);

------------------------------------------------------------------------
dcuinvce - mirror of stuinvce
    po_no char(10),
    inv_no char(20),
    pay_to_code char(6),
    description char(30),
    inv_date date,
    terms_code char(6),
    pay_date date,
    due_date date,
    discount_date date,
    discount_percent decimal(10),
    misc_amount decimal(10),
    frght_amount decimal(10),
    goods_total decimal(10),
    tax_total decimal(10),
    inv_total decimal(10),
   
diff_total decimal(10),
    ok_to_post char(1),
    currency_code char(3),
    curr_rate_type char(6),
    currency_rate decimal(16),
    batch_id integer,
    po_doc_no integer,
    inv_doc_no integer not null ,
    inv_post_no integer,
    inv_post_date date,
    loaded smallint

create index i1cuinvce on dcuinvce (po_no, inv_no);

------------------------------------------------------------------------
dcuinvcd - mirror of stuinvcd
    po_no char(10),
    inv_no char(20),
    inv_line_no smallint,
    po_line_no smallint,
    cost_qty decimal(10),
    cost decimal(12,3),
    net_price decimal(10),
    gl_acct_no integer,
    department char(3),
    mtaxg_code char(6),
    exp_tax_amt decimal(10),
    exp_tax_frz char(1)

create index i1cuinvcd on dcuinvcd (po_no, inv_no, inv_line_no);

------------------------------------------------------------------------
dcuordre - mirror of stuordre
    doc_no integer,
    orig_doc_no integer,
    po_no char(10),
    buyer_code char(6),
    po_type char(3),
    po_date date,
    po_status char(3),
    po_stage char(3),
    complete_date date,
    required_date date,
    whse_billto char(10),
    whse_shipto char(10),
    department char(3),
    mtaxg_code char(6),
    vend_code char(20),
   
pay_to_code char(6),
    bus_name char(30),
    order_doc_no integer,
    cust_code char(20),
    order_no_vnd char(10),
    order_reference char(13),
    currency_code char(3),
    ord_printed char(1),
    total_weight decimal(12),
    item_amount decimal(12),
    discountable decimal(12),
    trd_ds_amount decimal(12),
    tax_amount decimal(12),
    frght_amount decimal(12),
    misc_amount decimal(12),
    goods_amount decimal(12),
    total_amount decimal(12),
    prepay_amount decimal(12),
    freight_terms char(6),
    ship_via char(15),
    fob_point char(15),
    reprint_no smallint,
    confirmed_to char(20),
    curr_rate_type char(6),
    currency_rate decimal(16),
    terms_code char(6),
    frght_tax_code char(6),
    frght_acct_no integer,
    frght_department char(3),
    misc_tax_code char(6),
    misc_acct_no integer,
   
misc_department char(3),
    confirm_date date,
    on_board_date date,
    loaded smallint

create unique index i1cuordre on dcuordre (doc_no);

------------------------------------------------------------------------
dcuordrd - mirror of stuordrd
    doc_no integer,
    line_no smallint,
    cm_dm_reason char(3),
    mtaxg_code char(6),
    line_type char(3),
    line_stage char(3),
    receiver_printed smallint,
    request_date date,
    po_date date,
    rcpt_date date,
    inv_date date,
    required_date date,
    whse_shipto char(10),
    whse_billto char(10),
    item_code char(20),
    desc1 char(30),
    desc2 char(30),
    td_disc_allowed char(1),
    bo_allowed char(1),
    ordr_qty decimal(10),
    rlse_qty decimal(10),
    rjct_qty decimal(10),
    recv_qty decimal(10),
    cost_qty decimal(10),
    acpt_qty decimal(10),
    exp_rec_qty decimal(10),
   
exp_inv_qty decimal(10),
    sell_unit char(2),
    purch_unit char(2),
    stock_unit char(2),
    unit_factor decimal(6),
    cost decimal(12),
    gl_acct_no integer,
    net_price decimal(10),
    department char(3),
    instruct_code char(6),
    authorization_code char(6),
    inspection_code char(6),
    alias_code char(20),
   
weight decimal(9),
    staging_area char(6),
    order_doc_no integer,
    order_line_no integer,
    order_ship_no integer,
    note_flag char(1),
    unit_tax decimal(12),
    confirm_date date,
    on_board_date date,
    loaded smallint

create unique index i1cuordrd on dcuordrd (doc_no, line_no);

------------------------------------------------------------------------
dcurecte - mirror of sturecte
    po_no char(10),
    rec_doc_no integer,
    receipt_date date,
    receipt_ref char(10),
    ok_post char(1),
    ship_via char(10),
    batch_id integer,
    ship_date date

create index i1curecte on dcurecte (po_no);

------------------------------------------------------------------------
dcurectd - mirror of sturectd
    po_no char(10),
    rec_doc_no integer,
    po_line_no smallint,
    recv_qty decimal(10),
    rjct_qty decimal(10),
    rjct_code char(10)

create index i1curectd on dcurectd (po_no);

------------------------------------------------------------------------
dcrshipr - mirror of strshipr
    cust_code char(20),
    ship_to_code char(6),
    bus_name char(30),
    taxable char(6),
    contact char(20),
    phone char(20),
    address1 char(30),
    address2 char(30),
    city char(20),
    state char(2),
    zip char(10),
    country char(20),
    sls_psn_code char(6),
    trd_ds_code char(6),
    st_tx_code char(6),
    co_tx_code char(6),
    ci_tx_code char(6),
    comm_code char(6),
    mtax_freight char(6),
    mtax_misc char(6),
    ship_via_cd char(3),
    ship_terms char(15),
    email char(50),
    web_address char(50),
    cell_phone char(20),
    fax_phone char(20),
    residential_cust char(1),
    loaded smallint

create unique index i1crshipr on dcrshipr (cust_code, ship_to_code);

------------------------------------------------------------------------
dcpvendr - mirror of stpvendr
    vend_code char(20),
    bus_name char(30),
    contact char(20),
    phone char(20),
    address1 char(30),
    address2 char(30),
    city char(20),
    state char(2),
    zip char(10),
    country char(20),
    credit_limit decimal(12),
    terms_code char(6),
    act_grp char(6),
    spec_billing char(50),
    ap_acct_dflt integer,
    ap_department_dflt char(3),
    last_pay_date date,
    hold_pymnt char(1),
    take_dscnt char(1),
    on_acct_amt decimal(12),
    arch_bal decimal(12),
    spec_shipping char(50),
    taxable char(6),
    bo_allowed char(1),
    pay_method char(6),
    buyer_code char(6),
    trd_ds_code char(6),
    eta_days smallint,
    st_tx_code char(6),
    co_tx_code char(6),
    ci_tx_code char(6),
    cash_acct_no integer,
    cash_department char(3),
    exp_acct_no integer,
    exp_department char(3),
    print_1099 char(1),
    federal_tax_id char(11),
    currency_code char(3),
    acct_bal_date date,
    on_acct_date date,
    sdb_code char(10),
    vendor_rating smallint,
    fax_phone char(20),
    telex_no char(20),
    mtax_frght char(6),
    mtax_misc char(6),
    email char(50),
    web_address char(50),
    cell_phone char(20),
    loaded smallint

create unique index i1cpvendr on dcpvendr (vend_code);
create index i2cpvendr on dcpvendr (bus_name);
------------------------------------------------------------------------