Data Conversion Tables

======================

-------------------------------------------

table dcpinvce

Near mirror of stpinvce for importing data

Uses vend_code and inv_no for unique ID

because imported data may not have a doc_no

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

batch_id integer,

recurr_cnt integer,

orig_journal char(2),

trans_doc_no integer

create unique index "informix".i1cpinvce on "informix".dcpinvce

(vend_code,inv_no) ;

--------------------------------------------------------------------

table dcpinvcd

Near mirror of stpinvcd for importing data

Joins to stpinvcd by vend_code and inv_no

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

prod_order char(7),

prod_order_lot char(3),

element char(20)

create index "informix".i1cpinvcd on "informix".dcpinvcd (vend_code,

inv_no,line_no) ;

--------------------------------------------------------------------

table dcrinvce

Near mirror of strinvce for importing data

Uses inv_no as unique ID

Import data may not have doc_no

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

pay_method char(6),

card_name char(20),

card_number char(30),

auth_amt decimal(10,2),

auth_code char(8),

auth_date date,

decline_code char(8),

decline_message char(60),

settle_decl_code char(8),

settle_decl_mssg char(60),

cc_batch_id char(12),

cc_batch_name char(12),

settled char(1),

trans_ref_no char(40),

cc_s_batch_id char(12),

cc_s_batch_name char(12),

inv_printed char(1)

create unique index "informix".i1crinvce on "informix".dcrinvce

(inv_no) ;

--------------------------------------------------------------------

table dcrinvcd

near mirror of strinvcd for importing data

Joins dcrinvce by inv_no

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 "informix".i1crinvcd on "informix".dcrinvcd (inv_no)

;

--------------------------------------------------------------------

table 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),

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

route_code char(10),

resale_no char(15),

resale_expiry date

discount_level char(1),

ytd_sales decimal(14),

lifetime_sales decimal(14),

label1 char(10),

phone1 char(20),

label2 char(10),

phone2 char(20),

label3 char(10),

phone3 char(20),

label4 char(10),

phone4 char(20),

label5 char(10),

phone5 char(20),

label6 char(10),

phone6 char(20),

label7 char(10),

phone7 char(20),

label8 char(10),

phone8 char(20),

label9 char(10),

phone9 char(20),

label10 char(10),

phone10 char(20),

split_terms_code char(6),

account_type char(25),

account_source char(25),

warehouse_code char(10),

duns_no char(9),

active char(1),

acct_established date,

collection_contact char(30),

collection_phone char(20),

credit_check char(1),

over_credit_pct decimal(4,2),

credit_approve_dt date,

credit_approve_by char(8),

avg_pay_days smallint,

last_payment decimal(12,2),

open_orders decimal(12,2),

hold_code char(6)

);

create unique index "informix".i1crcustr on "informix".dcrcustr

(cust_code) ;

--------------------------------------------------------------------

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

create unique index "informix".i1cxchrtr on "informix".dcxchrtr

(acct_no) ;

--------------------------------------------------------------------

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

create unique index "informix".i1cxchrtd on "informix".dcxchrtd

(acct_no,department,period_year,period_month) ;

--------------------------------------------------------------------

table 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),

type_it char(1),

prod_type_it char(1),

abc_code_it char(1),

product_it char(3),

acctcd_it char(13),

department_it char(3),

low_level_it smallint,

revision_level_it char(3),

num_eng_change_it char(6),

date_eng_change_it date,

eng_drawing_it char(15),

bill_chng_date_it date,

rout_chng_date_it date,

standard_cost_it decimal(11),

date_last_cost_it date,

order_policy_it char(1),

cur_order_qty_it decimal(10),

eoq_order_qty_it decimal(10),

min_order_qty_it decimal(10),

max_order_qty_it decimal(10),

mult_order_qty_it decimal(10),

safety_stock_it decimal(10),

shrinkage_it decimal(10),

planner_it char(5),

buyer_it char(5),

component_count_it smallint,

routing_count_it smallint,

mfg_alloc_qty_it decimal(10),

mfg_order_qty_it decimal(10),

loc_control_it char(1),

fifo_control_it char(1),

lot_control_it char(1),

serial_control_it char(1),

group_it char(3),

cost_method_it char(3),

cur_suhr_std_it decimal(10),

cur_runhr_std_it decimal(10),

cur_machr_std_it decimal(10),

mrp_interval_it char(1),

issue_method_it char(1),

phantom_it char(1),

cur_last_roll_it date,

days_supply_it smallint,

mrp_qty_work_it decimal(10,3),

mfg_sched_rcp_it decimal(10,3),

cost_roll_sts_it smallint,

est_annual_usg_it decimal(10,3),

master_schedule_it char(1),

mps_group_it char(15),

mps_interval_it char(2),

interval_ofst_it smallint,

auto_rsc_build_it char(1),

rough_rsc_id_it char(10),

rough_conv_it decimal(8,4),

demand_source_it char(1),

forecast_it char(1),

fcst_group_it char(15),

fcst_interval_it char(2),

qty_or_amount_it char(1),

default_bom_it char(5),

default_rtg_it char(5),

last_rsc_gen_it date,

rev_prod_lt_it decimal(12,6),

fix_prod_lt_it decimal(12,6),

var_prod_lt_it decimal(12,6),

cumulative_lt_it decimal(12,6),

auto_msg_prod_it char(6),

pur_rel_type_it char(1),

configurable_it char(1),

config_group_it char(15),

td_disc_allowed char(1),

tax char(1),

upc_code char(15),

disc1 decimal(14,4),

disc2 decimal(14,4),

disc3 decimal(14,4),

disc4 decimal(14,4),

disc5 decimal(14,4),

handling_fee decimal(8,4),

special_order char(1),

uom_list_code char(10),

ext_desc varchar(255),

fmd_required char(1),

mfg_name char(25),

mfg_item char(25),

rohs_compliant char(1),

warr_days smallint

create unique index "informix".i1ciinvtr on "informix".dciinvtr

(item_code) ;

--------------------------------------------------------------------

table 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),

mfg_alloc_qty_iw decimal(10,3),

standard_cost_iw decimal(11),

mfg_sched_rcp_iw decimal(10,3),

type_iw char(1),

acctcd_iw char(13),

department_iw char(3),

stock_uom_iw char(2),

prod_type_iw char(1),

lead_time_iw smallint,

cuml_lead_time_iw smallint,

planner_iw char(5),

buyer_iw char(5),

order_policy_iw char(1),

cur_order_qty_iw decimal(10,3),

eoq_order_qty_iw decimal(10,3),

min_order_qty_iw decimal(10,3),

max_order_qty_iw decimal(10,3),

mult_order_qty_iw decimal(10,3),

safety_stock_iw decimal(10,3),

days_supply_iw smallint,

mrp_qty_work_iw decimal(10,3),

cost_method_iw char(3),

default_bom_iw char(5),

default_rtg_iw char(5),

issue_method_iw char(1),

mrp_interval_iw char(1),

est_annual_usg_iw decimal(10,3),

shrinkage_iw decimal(8,4),

master_schedule_iw char(1),

mps_group_iw char(15),

mps_interval_iw char(2),

interval_ofst_iw smallint,

auto_rsc_build_iw char(1),

rough_rsc_id_iw char(10),

rough_conv_iw decimal(8,4),

demand_source_iw char(1),

forecast_iw char(1),

fcst_group_iw char(15),

fcst_interval_iw char(2),

qty_or_amount_iw char(1),

last_rsc_gen_iw date,

rev_prod_lt_iw decimal(12,6),

fix_prod_lt_iw decimal(12,6),

var_prod_lt_iw decimal(12,6),

cumulative_lt_iw decimal(12,6),

pur_rel_type_iw char(1),

mrp_chg_flag_iw char(1),

configurable_iw char(1),

config_group_iw char(15),

prod_line_iw char(5),

loc_control_iw char(1),

lot_control_iw char(1),

serial_control_iw char(1),

fifo_control_iw char(1),

serial_auto_iw char(1),

next_serial_iw decimal(10,0),

lot_auto_iw char(1),

next_lot_iw decimal(10,0),

primary_bin char(15),

secondary_bin char(15)

date_added date,

added_by char(8)

create unique index "informix".i1cilocar on "informix".dcilocar

(item_code,warehouse_code) ;

--------------------------------------------------------------------

table dcxmape

Used with dcxmapd for mapping import data values.

table_name char(18),

col_name char(18),

description char(40)

create unique index "informix".i1cxmape on "informix".dcxmape

(table_name,col_name) ;

--------------------------------------------------------------------

table dcxmapd

Map data values to new values when importing data.

default_value indicates to use new_value if value in

the import data is null.

table_name char(18),

col_name char(18),

old_value char(40),

new_value char(40),

default_value char(1)

create index "informix".i1cxmapd on "informix".dcxmapd (table_name,

col_name) ;

--------------------------------------------------------------------

table dcppytor

mirror of stppytor for import of data

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

cc_ap_acct_no integer,

cc_ap_department char(3)

create unique index "informix".i1cppytor on "informix".dcppytor

(vend_code,pay_to_code) ;

--------------------------------------------------------------------

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

route_code char(10),

warehouse_code char(10)

create unique index "informix".i1crshipr on "informix".dcrshipr

(cust_code,ship_to_code) ;

--------------------------------------------------------------------

table dcpvendr

mirror of stpvendor

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

acct_bal decimal(12),

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)

account_no char(20),

ytd_purchases decimal(14),

lifetime_purchases decimal(14),

open_po_amt decimal(14)

reb_recv_acct_no integer,

cc_template char(20)

create unique index "informix".i1cpvendr on "informix".dcpvendr

(vend_code) ;

create index "informix".i2cpvendr on "informix".dcpvendr (bus_name)

;

--------------------------------------------------------------------

table dcropend

mirror of stropend except doc_no

cust_code char(20),

inv_no char(10),

inv_desc char(30),

inv_date date,

orig_amount decimal(12),

disc_amt decimal(12),

balance decimal(12),

disc_bal decimal(12),

due_date date,

disc_date date,

ar_acct_no integer,

ar_department char(3),

po_no char(10),

po_date date,

item_type char(2),

currency_code char(3),

curr_ex_rate decimal(16),

home_curr_amount decimal(12),

last_pay_date date,

sls_psn_code char(6)

order_doc_no integer

create index "informix".i1dcropend on "informix".dcropend (cust_code)

;

create index "informix".i2dcropend on "informix".dcropend (inv_no)

;

--------------------------------------------------------------------

table dcpopend

mirror of stropend except doc_no

vend_code char(20),

pay_to_code char(6),

inv_no char(20),

inv_desc char(30),

inv_date date,

orig_amount decimal(12),

disc_amt decimal(12),

balance decimal(12),

disc_bal decimal(12),

due_date date,

disc_date date,

ap_acct_no integer,

ap_department char(3),

po_no char(10),

po_date date,

to_pay_amt decimal(12),

to_take_disc decimal(12),

to_pay_date date,

cash_acct_no integer,

cash_department char(3),

currency_code char(3),

curr_ex_rate decimal(16),

home_curr_amount decimal(12),

last_pay_date date

create index "informix".i1dcpopend on "informix".dcpopend (vend_code)

;

create index "informix".i2dcpopend on "informix".dcpopend (inv_no)

;

-------------------------------------------------------------------------

--- MR1416 - extend dcxmapd old_value, new_value

dcxmapd.old_value char(100),

dcxmapd.new_value char(100)

--------------------------------------------------------------------------

--- 2nd phase release:

dc:Makefile.fix

dc:i_glactv.4gs

dc:i_oeordd.4gs

dc:i_oeorde.4gs

dc:i_oserle.4gs

dc:i_otrckd.4gs

dc:i_puordd.4gs

dc:i_puorde.4gs

dc:p_glactv.4gs

dc:p_oeord.4gs

dc:p_otrckd.4gs

dc:p_puord.4gs

--------------------------------------------------------------------

Table dcgactvd - To populate GL Activity tables

(

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

);

--------------------------------------------------------------------

dcuordre - Mirror of stuordre

(

vend_code char(20),

po_no char(20),

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

pay_to_code char(6),

bus_name char(30),

order_no char(20),

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

create_date date,

create_time char(8),

create_id char(8),

l_mod_date date,

l_mod_time char(8),

l_mod_id char(8),

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,

multiple_orders char(1),

contract_no char(20),

container_no char(20),

orig_order_doc_no integer,

contact_name char(20)

order_ref_no char(20),

return_reason char(10),

prod_order char(7)

);

--------------------------------------------------------------------

Table dcuordrd - Mirror of stuordrd

(

vend_code char(20),

po_no char(20),

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(8,3),

staging_area char(6),

order_no char(20),

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,

volume decimal(8,3)

return_reason char(10),

comp_sequence char(10)

);

--------------------------------------------------------------------

Table dcoordre - Mirror of stoordre

(

orig_doc_no integer,

order_no char(20),

inv_doc_no integer,

inv_no char(10),

po_no char(24),

pic_ticket_no smallint,

next_kit_group smallint,

ack_printed char(1),

order_type char(3) not null ,

like_type char(3) not null ,

order_status char(3) not null ,

hi_stage char(3) not null ,

lo_stage char(3) not null ,

bo_allowed char(1),

recur_unit char(1),

recur_every smallint,

recur_times smallint,

recur_through date,

prev_recur date,

next_recur date,

num_releases smallint,

release_type char(3),

order_date date,

to_ship_date date,

alloc_date date,

ship_date date,

complete_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),

bus_name char(30),

contact char(20),

address1 char(30),

address2 char(30),

city char(20),

state char(2),

zip char(10),

country char(20),

terms_code char(6),

terms_approval 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),

multi_shipto char(1),

tax_rate decimal(6),

staging_area char(6),

fob_point char(15),

ship_via char(15),

ship_weight decimal(14),

item_amount decimal(14),

discountable decimal(12),

trd_ds_amount decimal(14),

taxable decimal(12),

tax_amount decimal(14),

frght_amount decimal(14),

total_amount decimal(14),

create_date date,

create_time char(8),

create_id char(8),

l_mod_date date,

l_mod_time char(8),

l_mod_id char(8),

system_order char(1),

spr_no char(7),

cust_ord_date date,

cust_po_date date,

fact_ack_date date,

fact_rec_date date,

moto_rec_date date,

sent_to_wwop char(1),

mtaxg_code char(6),

intl_order char(1),

intl_lic_no char(30),

currency_code char(3),

curr_rate_type char(6),

currency_rate decimal(16),

edi_sent char(1),

blo_exp_date date,

dpas_rating char(2),

resale_cust char(6),

resale_po char(30),

actual_frght_amt decimal(12),

orig_frght_amt decimal(12),

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

contract_no char(20),

multiple_orders char(1),

deposit decimal(10,2),

docs_sent date,

destination char(30),

consignee_name char(20),

consignee_addr1 char(30),

consignee_addr2 char(30),

consignee_city char(20),

consignee_state char(2),

consignee_zip char(10),

consignee_country char(20),

notify_name char(20),

notify_info char(240),

truck_bol char(20)

route_code char(10),

resale_no char(15),

resale_expiry date

rma_reason char(6),

base_doc_no integer,

rma_doc_no integer,

order_description char(80),

ready_to_invoice char(1),

required_date date,

default_rma_type char(3),

restock_fee decimal(8,2),

ship_to_name char(30),

one_time_cust char(1),

ship_type char(6),

restock_percent decimal(6,2),

restock_amount decimal(8,2),

rma_status_code char(20),

handling_fee decimal(8,4),

split_terms_code char(6),

phone char(12)

contact_name char(20),

contact_phone char(20),

fixed_price char(1),

rlse_no integer,

hold_code char(6),

credit_approved char(1),

approved_by char(8),

date_approved date

);

create unique index "informix".i1coordre on "informix".dcoordre

(order_no) using btree ;

--------------------------------------------------------------------

Table dcoordrd - Mirror of stoordrd

(

order_no char(20),

line_no smallint,

ship_no smallint,

kit_group smallint,

kit_line_no smallint,

price_lock char(1),

line_type char(3),

like_type char(3),

stage 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),

ship_qty decimal(10),

sell_unit char(2),

unit_factor decimal(6),

price decimal(12),

price_code integer,

net_amount decimal(14),

ship_weight decimal(14),

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

new_date date,

bko_date date,

ord_date date,

pic_date date,

shp_date date,

inv_date date,

pst_date date,

can_date date,

po_no char(20)

item_cost decimal(12),

blanket_doc_no integer,

lost_reason char(6),

lost_reason_qty decimal(14)

);

create unique index "informix".i1coordrd on "informix".dcoordrd

(order_no,line_no,ship_no) using btree ;

--------------------------------------------------------------------

Table dcoserle - Mirror of stiserle

(

order_no char(20),

line_no smallint,

ship_no smallint,

lot_no char(20),

serial_no char(20),

lot_qty decimal(10)

bin_location char(15)

cost decimal(14,4),

seq_no integer

);

--------------------------------------------------------------------

Table dcotrckd - Mirror of stotrckd

(

contract_no char(20),

order_no char(20),

po_no char(20),

fwdr_invoice char(20),

sales_basis char(5),

loadg_location char(30),

port_of_exit char(30),

gross_weight decimal(10),

net_weight decimal(10),

tare_weight decimal(10),

container_no char(20),

bill_lading char(20),

ocean_bol char(20),

booking_no char(20),

vessel char(25),

voyage char(25),

cutoff_date date,

loadg_date date,

release_date date,

est_depart date,

est_arrive date,

pymt_due_date date,

est_demurrage decimal(10,2),

insurance decimal(10,2),

relse_rqstd date,

relse_recvd date,

draft_obl_rcvd date,

consignee_name char(20),

consignee_addr1 char(30),

consignee_addr2 char(30),

consignee_city char(20),

consignee_state char(2),

consignee_zip char(10),

consignee_country char(20),

notify_name char(20),

notify_info char(240),

gross_mt decimal(8,2),

net_mt decimal(8,2),

tare_mt decimal(8,2),

forwarder_name char(20),

carrier char(20),

send_docs char(20),

container_size char(20),

transhipment1 char(20),

vessel1 char(20),

voyage1 char(10),

eta1 date,

etd1 date,

transhipment2 char(20),

vessel2 char(20),

voyage2 char(10),

eta2 date,

etd2 date,

transhipment3 char(20),

vessel3 char(20),

voyage3 char(10),

eta3 date,

etd3 date,

transhipment4 char(20),

vessel4 char(20),

voyage4 char(10),

eta4 date,

etd4 date,

transhipment5 char(20),

vessel5 char(20),

voyage5 char(10),

eta5 date,

etd5 date,

port1 char(10),

port2 char(10),

port3 char(10),

port4 char(10),

port5 char(10),

seal_no char(10)

);

--------------------------------------------------------------------

Table dcoinvce - Mirror of stoinvce

doc_no integer,

order_no char(20),

bill_to_code char(20),

sell_to_code char(20),

ship_to_code char(6),

inv_doc_no integer,

stage char(3),

inv_no char(10),

inv_date date,

inv_printed char(1),

ok_to_post char(1) not null ,

terms_code char(6),

terms_approval char(6),

pay_method char(6),

payment char(1),

card_no char(20),

exp_date char(5),

check_no char(8),

fob_point char(15),

ship_via char(15),

ship_weight decimal(10),

freight_doc char(15),

st_tx_code char(6),

co_tx_code char(6),

ci_tx_code char(6),

st_tx_rate decimal(6),

co_tx_rate decimal(6),

ci_tx_rate decimal(6),

tax_rate decimal(6),

trd_ds_rate decimal(6),

item_amount decimal(12),

discountable decimal(12),

trd_ds_amount decimal(12),

taxable decimal(12),

st_tx_amount decimal(12),

co_tx_amount decimal(12),

ci_tx_amount decimal(12),

frght_amount decimal(12),

total_amount decimal(12),

td_ds_acct integer,

st_tx_acct integer,

co_tx_acct integer,

ci_tx_acct integer,

freight_acct integer,

asset_acct integer,

td_ds_dept char(3),

st_tx_dept char(3),

co_tx_dept char(3),

ci_tx_dept char(3),

freight_dept char(3),

asset_dept char(3),

mtaxg_code char(6),

tax_amount decimal(12),

currency_code char(3),

curr_rate_type char(6),

currency_rate decimal(16),

batch_id integer,

ship_terms char(15),

mtax_freight char(6),

settle_decl_code char(8),

decline_message char(60),

settled char(1),

cc_batch_id char(12),

deposit_applied decimal(12,2)

restock_fee decimal(8,2),

handling_fee decimal(8,4),

split_terms_code char(6),

balance decimal(12)

);

--------------------------------------------------------------------

Table dcoinvcd - Table to populate stoinvce

(

inv_no char(10),

order_no char(20),

line_no smallint,

ship_no smallint

);

--------------------------------------------------------------------

Table dciserld - Mirror of stiserld

(

item_code char(20),

warehouse_code char(10),

seq_no integer,

lot_no char(20),

serial_no char(20),

lot_qty decimal(10),

cost decimal(14,4),

vend_code char(20),

expiry_date date,

po_no char(20),

rec_doc_no integer,

receipt_date date,

recv_qty decimal(10),

recv_cost decimal(14,4),

bin_location char(15)

);