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