14/06/21 16:24:46 PROGRESS Report Database: qaddb (PROGRESS) ============================================================================ =============================== Table: sod_det ============================= Table Flags: "f"=frozen, "s"=a SQL table Table Table Field Index Table Name Flags Count Count Label -------------------------------- ----- ----- ----- ------------------------ sod_det f 211 6 ? Dump Name: sod_det Description: Sales Order Detail Storage Area: MFG Trigger Event Trigger Procedure Overridable? Check CRC? ------------- -------------------- ------------ ---------- CREATE sodc.t no no Delete sodd.t no no REPLICATION-D sodrd.t no no REPLICATION-W sodrw.t no no Write sodw.t no no =============================== FIELD SUMMARY ============================== =============================== Table: sod_det ============================= Flags: ase sensitive, ndex component, andatory, iew component Order Field Name Data Type Flags ----- -------------------------------- ----------- ----- 10 sod_nbr char im 20 sod_due_date date 30 sod_per_date date 40 sod_req_date date 50 sod_line inte i 60 sod_part char i 70 sod_qty_ord deci-10 80 sod_qty_all deci-10 90 sod_qty_pick deci-10 100 sod_qty_ship deci-10 110 sod_qty_inv deci-10 120 sod_loc char 130 sod_type char 140 sod_price deci-10 150 sod_std_cost deci-10 160 sod_qty_chg deci-10 170 sod_bo_chg deci-10 180 sod_acct char 190 sod_abnormal logi 200 sod_taxable logi 210 sod_serial char i 220 sod_desc char 230 sod_um char 240 sod_cc char 250 sod_comment char[5] 260 sod_lot char 270 sod_um_conv deci-10 280 sod_fa_nbr char 290 sod_disc_pct deci-10 300 sod_project char 310 sod_cmtindx inte 320 sod_custpart char 330 sod__qad01 inte 340 sod_status char 350 sod_xslspsn char[3] 360 sod_xcomm_pct deci-10[2] 370 sod_dsc_acct char 380 sod_dsc_cc char 390 sod_list_pr deci-10 400 sod_user1 char 410 sod_user2 char 420 sod_sob_rev date 430 sod_sob_std logi 440 sod_qty_qote deci-10 450 sod_consume logi 460 sod_expire date 470 sod__qad02 logi 480 sod_taxc char 490 sod_inv_nbr char 500 sod_partial logi 510 sod_site char 520 sod_prodline char 530 sod_tax_in logi 540 sod_fst_list logi 550 sod_pst logi 560 sod__chr01 char 570 sod__chr02 char 580 sod__chr03 char 590 sod__chr04 char 600 sod__chr05 char 610 sod__chr06 char 620 sod__chr07 char 630 sod__chr08 char 640 sod__chr09 char 650 sod__chr10 char 660 sod__dte01 date 670 sod__dte02 date 680 sod__dec01 deci-10 690 sod__dec02 deci-10 700 sod__log01 logi 710 sod_calc_isb logi 720 sod_owner char 730 sod_rma_type char 740 sod_qty_item deci-10 750 sod_qty_per deci-10 760 sod_ref inte 770 sod_for char 780 sod_tax_max deci-10 790 sod_contr_id char 800 sod_pickdate date 810 sod_confirm logi 820 sod_cum_qty deci-10[4] 830 sod_cum_date date[4] 840 sod_fr_rate deci-10 850 sod_slspsn char[4] 860 sod_comm_pct deci-10[4] 870 sod_ord_mult deci-0 880 sod_pkg_code char 890 sod_curr_rlse_id char[3] 900 sod_sched logi 910 sod_sch_data char 920 sod_sch_mrp logi 930 sod_rlse_nbr inte 940 sod_translt_days deci-10 950 sod_fsm_type char i 960 sod_conrep char 970 sod_start_eff date[4] 980 sod_end_eff date[4] 990 sod_dock char 1000 sod_pr_list char 1010 sod_translt_hrs deci-10 1020 sod_out_po char 1030 sod_raw_days inte 1040 sod_fab_days inte 1050 sod_tax_usage char 1060 sod_rbkt_days inte 1070 sod_rbkt_weeks inte 1080 sod_rbkt_mths inte 1090 sod_sched_chgd logi 1100 sod_pastdue char 1110 sod_fix_pr logi 1120 sod_fr_wt deci-10 1130 sod_fr_wt_um char 1140 sod_fr_class char 1150 sod_fr_chg deci-10 1160 sod_sa_nbr char 1170 sod_isb_loc char 1180 sod_ship char 1190 sod_auto_ins logi 1200 sod_drp_ref char 1210 sod_tax_env char 1220 sod_upd_isb logi 1230 sod_isb_ref inte 1240 sod_enduser char 1250 sod_crt_int deci-10 1260 sod_fr_list char i 1270 sod_pricing_dt date 1280 sod_act_price deci-10 1290 sod_covered_amt deci-10 1300 sod_ca_nbr char i 1310 sod_fixed_price deci-10 1320 sod_inv_cost deci-10 1330 sod_car_load logi 1340 sod_ca_line inte i 1350 sod_qty_cons deci-10 1360 sod_qty_ret deci-10 1370 sod_qty_pend deci-10 1380 sod_to_loc char 1390 sod_to_site char 1400 sod_to_ref char 1410 sod_ln_ref char 1420 sod_qty_exch deci-10 1430 sod_sad_line inte 1440 sod_warr_start date 1450 sod_mod_userid char 1460 sod_mod_date date 1470 sod_sv_code char 1480 sod_alt_pkg logi 1490 sod_for_serial char 1500 sod_override_lmt logi 1510 sod__qadc01 char 1520 sod__qadc02 char 1530 sod__qadc03 char 1540 sod__qadc04 char 1550 sod__qadt01 date 1560 sod__qadt02 date 1570 sod__qadt03 date 1580 sod__qadt04 date 1590 sod__qadd01 deci-10 1600 sod__qadd02 deci-10 1610 sod__qadd03 deci-10 1620 sod__qadl01 logi 1630 sod__qadl02 logi 1640 sod__qadl03 logi 1650 sod__qadi01 inte 1660 sod__qadi02 inte 1670 sod_bonus logi m 1680 sod_btb_type char m 1690 sod_btb_po char m 1700 sod_btb_pod_line inte m 1710 sod_btb_vend char m 1720 sod_exp_del date 1730 sod_dir_all logi m 1740 sod_cfg_type char 1750 sod_div char 1760 sod_pl_priority inte 1770 sod_prig1 char 1780 sod_prig2 char 1790 sod__qadd04 deci-10 1800 sod_sub char 1810 sod_dsc_sub char 1820 sod_dsc_project char 1830 sod_qty_ivcd deci-10 1840 sod_cum_time inte[4] 1850 sod_ship_part char 1860 sod_promise_date date 1870 sod_charge_type char 1880 sod_order_category char m 1890 sod_modelyr char m 1900 sod_custref char m 1910 sod_consignment logi m 1920 sod_max_aging_days inte m 1930 sod_consign_loc char m 1940 sod_intrans_loc char m 1950 sod_auto_replenish logi m 1960 sod_manual_fr_list logi m 1970 sod_domain char im 1980 oid_sod_det deci-10 im 1990 sod_trade_sale_po char m 2000 sod_trade_sale_po_line inte m 2010 sod_trade_sale_vend char m 2020 sod_fsrev_acct char m 2030 sod_fsrev_sub char m 2040 sod_fsrev_cc char m 2050 sod_req_time char m 2060 sod_shipvia char m 2070 sod_compl_stat char m 2080 sod_compl_date date 2090 sod_hold_stat char m 2100 sod_unadjust_cum_qty deci-10 m 2110 sod_config_id char m Field Name Format -------------------------------- ----------------------------- sod_nbr x(8) sod_due_date 99/99/99 sod_per_date 99/99/99 sod_req_date 99/99/99 sod_line >>9 sod_part x(18) sod_qty_ord ->,>>>,>>9.9<<<<<<<< sod_qty_all ->,>>>,>>9.9<<<<<<<< sod_qty_pick ->,>>>,>>9.9<<<<<<<< sod_qty_ship ->,>>>,>>9.9<<<<<<<< sod_qty_inv ->,>>>,>>9.9<<<<<<<< sod_loc x(8) sod_type x(1) sod_price >>>>,>>>,>>9.99<<< sod_std_cost ->>>,>>>,>>9.99<<< sod_qty_chg ->,>>>,>>9.9<<<<<<<< sod_bo_chg ->,>>>,>>9.9<<<<<<<< sod_acct x(8) sod_abnormal yes/no sod_taxable yes/no sod_serial x(18) sod_desc x(24) sod_um x(2) sod_cc x(4) sod_comment x(40) sod_lot x(8) sod_um_conv >>>>9.9999<<<< sod_fa_nbr x(18) sod_disc_pct ->>9.99% sod_project x(8) sod_cmtindx >>>>>>>9 sod_custpart x(30) sod__qad01 ->>>>,>>>,>>9 sod_status x(8) sod_xslspsn x(8) sod_xcomm_pct >>9.99% sod_dsc_acct x(8) sod_dsc_cc x(4) sod_list_pr >>>>,>>>,>>9.99<<< sod_user1 x(8) sod_user2 x(8) sod_sob_rev 99/99/99 sod_sob_std yes/no sod_qty_qote ->,>>>,>>9.9<<<<<<<< sod_consume yes/no sod_expire 99/99/99 sod__qad02 yes/no sod_taxc x(3) sod_inv_nbr x(22) sod_partial yes/no sod_site x(8) sod_prodline x(4) sod_tax_in yes/no sod_fst_list yes/no sod_pst yes/no sod__chr01 x(8) sod__chr02 x(8) sod__chr03 x(8) sod__chr04 x(8) sod__chr05 x(8) sod__chr06 x(8) sod__chr07 x(8) sod__chr08 x(8) sod__chr09 x(8) sod__chr10 x(8) sod__dte01 99/99/99 sod__dte02 99/99/99 sod__dec01 >>>,>>>,>>9.99 sod__dec02 >>>,>>>,>>9.99 sod__log01 yes/no sod_calc_isb yes/no sod_owner x(8) sod_rma_type x(1) sod_qty_item ->>,>>9.9<<<< sod_qty_per ->>>9.9<<< sod_ref >>>>>>>9 sod_for x(18) sod_tax_max ->>>,>>>,>>9.99 sod_contr_id x(30) sod_pickdate 99/99/99 sod_confirm yes/no sod_cum_qty ->>>>,>>>,>>9.9<<<<<<<< sod_cum_date 99/99/99 sod_fr_rate >>>,>>>,>>9.99<< sod_slspsn x(8) sod_comm_pct >>9.99% sod_ord_mult >>,>>>,>>9 sod_pkg_code x(18) sod_curr_rlse_id x(30) sod_sched yes/no sod_sch_data x(8) sod_sch_mrp yes/no sod_rlse_nbr 99999999 sod_translt_days >>9.99 sod_fsm_type x(8) sod_conrep x(1) sod_start_eff 99/99/99 sod_end_eff 99/99/99 sod_dock x(8) sod_pr_list x(8) sod_translt_hrs >>9.99 sod_out_po x(30) sod_raw_days >,>>9 sod_fab_days >,>>9 sod_tax_usage x(8) sod_rbkt_days >>9 sod_rbkt_weeks >>9 sod_rbkt_mths >>9 sod_sched_chgd yes/no sod_pastdue x(1) sod_fix_pr yes/no sod_fr_wt ->,>>>,>>9.<<<<<< sod_fr_wt_um x(2) sod_fr_class x(8) sod_fr_chg ->>>,>>>,>>9.99 sod_sa_nbr x(8) sod_isb_loc x(22) sod_ship x(8) sod_auto_ins yes/no sod_drp_ref x(8) sod_tax_env x(16) sod_upd_isb yes/no sod_isb_ref >>>>>>>9 sod_enduser x(8) sod_crt_int ->>>9.99 sod_fr_list x(8) sod_pricing_dt 99/99/99 sod_act_price ->>>>,>>>,>>9.99<<< sod_covered_amt >>>>,>>>,>>9.99<<< sod_ca_nbr x(8) sod_fixed_price >>>>,>>>,>>9.99<<< sod_inv_cost ->>>,>>>,>>9.99<<< sod_car_load yes/no sod_ca_line >>9 sod_qty_cons ->,>>>,>>9.9<<<<<<<< sod_qty_ret ->,>>>,>>9.9<<<<<<<< sod_qty_pend ->,>>>,>>9.9<<<<<<<< sod_to_loc x(8) sod_to_site x(8) sod_to_ref x(8) sod_ln_ref x(8) sod_qty_exch ->,>>>,>>9.9<<<<<<<< sod_sad_line >>>>>>>9 sod_warr_start 99/99/99 sod_mod_userid X(8) sod_mod_date 99/99/99 sod_sv_code X(8) sod_alt_pkg yes/no sod_for_serial X(18) sod_override_lmt yes/no sod__qadc01 X(8) sod__qadc02 X(8) sod__qadc03 X(8) sod__qadc04 X(8) sod__qadt01 99/99/99 sod__qadt02 99/99/99 sod__qadt03 99/99/99 sod__qadt04 99/99/99 sod__qadd01 ->>>>,>>>,>>9.99<<< sod__qadd02 ->>>>,>>>,>>9.99<<< sod__qadd03 ->>>>,>>>,>>9.99<<< sod__qadl01 yes/no sod__qadl02 yes/no sod__qadl03 yes/no sod__qadi01 ->,>>>,>>9 sod__qadi02 ->,>>>,>>9 sod_bonus yes/no sod_btb_type xx sod_btb_po x(8) sod_btb_pod_line >>9 sod_btb_vend x(8) sod_exp_del 99/99/99 sod_dir_all yes/no sod_cfg_type x(1) sod_div x(8) sod_pl_priority >9 sod_prig1 x(8) sod_prig2 x(8) sod__qadd04 ->,>>>,>>9.9<<<<<<<< sod_sub x(8) sod_dsc_sub x(8) sod_dsc_project x(8) sod_qty_ivcd ->,>>>,>>9.9<<<<<<<< sod_cum_time >>,>>>,>>9 sod_ship_part x(30) sod_promise_date 99/99/99 sod_charge_type x(8) sod_order_category x(8) sod_modelyr x(4) sod_custref x(30) sod_consignment yes/no sod_max_aging_days >>9 sod_consign_loc x(8) sod_intrans_loc x(8) sod_auto_replenish yes/no sod_manual_fr_list yes/no sod_domain x(8) oid_sod_det >>>>>>>>>>>>>>>>>>>>>>>>>>>9. sod_trade_sale_po x(8) sod_trade_sale_po_line >>9 sod_trade_sale_vend x(8) sod_fsrev_acct x(8) sod_fsrev_sub x(8) sod_fsrev_cc x(4) sod_req_time 99:99 sod_shipvia x(20) sod_compl_stat x(8) sod_compl_date 99/99/99 sod_hold_stat x(8) sod_unadjust_cum_qty >,>>>,>>>,>>9.9<<<<<<<< sod_config_id x(8) Field Name Initial -------------------------------- ----------------------------- sod_nbr sod_due_date ? sod_per_date ? sod_req_date ? sod_line 0 sod_part sod_qty_ord 0 sod_qty_all 0 sod_qty_pick 0 sod_qty_ship 0 sod_qty_inv 0 sod_loc sod_type sod_price 0 sod_std_cost 0 sod_qty_chg 0 sod_bo_chg 0 sod_acct sod_abnormal no sod_taxable no sod_serial sod_desc sod_um sod_cc sod_comment sod_lot sod_um_conv 1 sod_fa_nbr sod_disc_pct 0 sod_project sod_cmtindx 0 sod_custpart sod__qad01 0 sod_status sod_xslspsn sod_xcomm_pct 0 sod_dsc_acct sod_dsc_cc sod_list_pr 0 sod_user1 sod_user2 sod_sob_rev ? sod_sob_std yes sod_qty_qote 0 sod_consume y sod_expire ? sod__qad02 no sod_taxc sod_inv_nbr sod_partial yes sod_site sod_prodline sod_tax_in no sod_fst_list no sod_pst no sod__chr01 sod__chr02 sod__chr03 sod__chr04 sod__chr05 sod__chr06 sod__chr07 sod__chr08 sod__chr09 sod__chr10 sod__dte01 ? sod__dte02 ? sod__dec01 0 sod__dec02 0 sod__log01 no sod_calc_isb no sod_owner sod_rma_type sod_qty_item 0 sod_qty_per 0 sod_ref 0 sod_for sod_tax_max 0 sod_contr_id sod_pickdate ? sod_confirm yes sod_cum_qty 0 sod_cum_date ? sod_fr_rate 0 sod_slspsn sod_comm_pct 0 sod_ord_mult 0 sod_pkg_code sod_curr_rlse_id sod_sched no sod_sch_data sod_sch_mrp no sod_rlse_nbr 0 sod_translt_days 0 sod_fsm_type sod_conrep sod_start_eff ? sod_end_eff ? sod_dock sod_pr_list sod_translt_hrs 0 sod_out_po sod_raw_days 0 sod_fab_days 0 sod_tax_usage sod_rbkt_days 0 sod_rbkt_weeks 0 sod_rbkt_mths 0 sod_sched_chgd yes sod_pastdue sod_fix_pr y sod_fr_wt 0 sod_fr_wt_um sod_fr_class sod_fr_chg 0 sod_sa_nbr sod_isb_loc sod_ship sod_auto_ins no sod_drp_ref sod_tax_env sod_upd_isb no sod_isb_ref ? sod_enduser sod_crt_int 0 sod_fr_list sod_pricing_dt ? sod_act_price 0 sod_covered_amt 0 sod_ca_nbr sod_fixed_price 0 sod_inv_cost 0 sod_car_load no sod_ca_line 0 sod_qty_cons 0 sod_qty_ret 0 sod_qty_pend 0 sod_to_loc sod_to_site sod_to_ref sod_ln_ref sod_qty_exch 0 sod_sad_line 0 sod_warr_start ? sod_mod_userid sod_mod_date ? sod_sv_code sod_alt_pkg no sod_for_serial sod_override_lmt no sod__qadc01 sod__qadc02 sod__qadc03 sod__qadc04 sod__qadt01 ? sod__qadt02 ? sod__qadt03 ? sod__qadt04 ? sod__qadd01 0 sod__qadd02 0 sod__qadd03 0 sod__qadl01 no sod__qadl02 no sod__qadl03 no sod__qadi01 0 sod__qadi02 0 sod_bonus no sod_btb_type 01 sod_btb_po sod_btb_pod_line 0 sod_btb_vend sod_exp_del ? sod_dir_all no sod_cfg_type sod_div sod_pl_priority 0 sod_prig1 sod_prig2 sod__qadd04 0 sod_sub sod_dsc_sub sod_dsc_project sod_qty_ivcd 0 sod_cum_time 0 sod_ship_part sod_promise_date ? sod_charge_type sod_order_category sod_modelyr sod_custref sod_consignment no sod_max_aging_days 0 sod_consign_loc sod_intrans_loc sod_auto_replenish no sod_manual_fr_list no sod_domain oid_sod_det 0 sod_trade_sale_po sod_trade_sale_po_line 0 sod_trade_sale_vend sod_fsrev_acct sod_fsrev_sub sod_fsrev_cc sod_req_time sod_shipvia sod_compl_stat sod_compl_date ? sod_hold_stat sod_unadjust_cum_qty 0 sod_config_id Field Name Label Column Label ------------------------------ ---------------------- ---------------------- sod_nbr Sales Order Order sod_due_date Due Date Due sod_per_date Perform ? sod_req_date Required Date Required sod_line Line Ln sod_part Item Number ? sod_qty_ord Qty Ordered ? sod_qty_all Qty Allocated ? sod_qty_pick Qty Picked ? sod_qty_ship Qty Shipped ? sod_qty_inv Qty to Invoice ? sod_loc Location ? sod_type Ship Type T sod_price Price ? sod_std_cost Cost ? sod_qty_chg Qty To Ship ? sod_bo_chg Qty Backord ? sod_acct Sales Acct Sales sod_abnormal Abnormal Demand Abnormal sod_taxable Taxable Tax sod_serial Lot/Serial ? sod_desc Description ? sod_um UM ? sod_cc Cost Ctr CC sod_comment Comments ? sod_lot ID ? sod_um_conv UM Conversion UM Conv sod_fa_nbr FAS W/O Final Assembly W/O sod_disc_pct Disc % ? sod_project Project ? sod_cmtindx Comment Index Comment sod_custpart Customer Item ? sod__qad01 ? ? sod_status Status ? sod_xslspsn Salesperson Salespsn sod_xcomm_pct Commission Comm% sod_dsc_acct Disc Acct ? sod_dsc_cc Disc CC CC sod_list_pr List Price ? sod_user1 Ufld1 ? sod_user2 Ufld2 ? sod_sob_rev Revised Date Revised sod_sob_std Standard Bill Std BOM sod_qty_qote Qty Quoted ? sod_consume Consume Forecast Consume Fcst sod_expire Expires ? sod__qad02 ? ? sod_taxc Tax Class TxC sod_inv_nbr Invoice ? sod_partial Partial OK Partial sod_site Site ? sod_prodline Product Line Line sod_tax_in Tax In ? sod_fst_list FST on List ? sod_pst PST Taxable ? sod__chr01 ? ? sod__chr02 ? ? sod__chr03 ? ? sod__chr04 ? ? sod__chr05 ? ? sod__chr06 ? ? sod__chr07 ? ? sod__chr08 ? ? sod__chr09 ? ? sod__chr10 ? ? sod__dte01 ? ? sod__dte02 ? ? sod__dec01 ? ? sod__dec02 ? ? sod__log01 ? ? sod_calc_isb Calculate Isb ? sod_owner Ownership ? sod_rma_type RMA Type ? sod_qty_item Item Quantity Item Qty sod_qty_per Duration ? sod_ref Ref ? sod_for For ? sod_tax_max Max Taxable Amount Max Amount sod_contr_id PO Number ? sod_pickdate Pick Date ? sod_confirm Confirmed ? sod_cum_qty Cum Shipped ? sod_cum_date Cum Start ? sod_fr_rate Freight Rate ? sod_slspsn Salesperson Salespsn sod_comm_pct Commission Comm% sod_ord_mult Std Pack Qty Mult sod_pkg_code Pkg Code ? sod_curr_rlse_id Active Rlse ID ? sod_sched Scheduled ? sod_sch_data Schedule Data ? sod_sch_mrp Sched MRP Req ? sod_rlse_nbr Next Release ID ? sod_translt_days Transport Days ? sod_fsm_type FSM Type ? sod_conrep Netting Logic C/R sod_start_eff Start Effective ? sod_end_eff End Effective ? sod_dock Dock ? sod_pr_list Price List List sod_translt_hrs Transport Hours ? sod_out_po Display PO Number ? sod_raw_days Raw Auth Days ? sod_fab_days Fab Auth Days ? sod_tax_usage Tax Usage TaxUsage sod_rbkt_days Req Schedule Days ? sod_rbkt_weeks Req Schedule Weeks ? sod_rbkt_mths Req Schedule Months ? sod_sched_chgd Schedule Changed ? sod_pastdue Past Due Logic C/R sod_fix_pr Fixed Price Fix sod_fr_wt Unit Ship Weight ? sod_fr_wt_um UM ? sod_fr_class Freight Class ? sod_fr_chg Unit Freight Charge ? sod_sa_nbr Service Contract ? sod_isb_loc Installed Base Locatio ? sod_ship Ship-To ? sod_auto_ins Installation Call ? sod_drp_ref DRP Ref ? sod_tax_env Tax Environment Tax Env sod_upd_isb Update Installed Base ? sod_isb_ref ISB Ref ? sod_enduser End User ? sod_crt_int Credit Terms Int CRT Int sod_fr_list Freight List Frt List sod_pricing_dt Pricing Date Price Dt sod_act_price Total List Price ? sod_covered_amt Covered Amount ? sod_ca_nbr Call ? sod_fixed_price Fixed Price ? sod_inv_cost Invoice Cost ? sod_car_load Call Act. Rec. Load ? sod_ca_line Call Line ? sod_qty_cons Qty Consumed ? sod_qty_ret Qty Returned ? sod_qty_pend Qty Pending ? sod_to_loc Location ? sod_to_site Site ? sod_to_ref Kit Ref ? sod_ln_ref Line Ref ? sod_qty_exch Qty Exchanged ? sod_sad_line Contract Line ? sod_warr_start Warranty Start Date ? sod_mod_userid User ID ? sod_mod_date Modified Date Mod Date sod_sv_code Warranty Code ? sod_alt_pkg Alternates ? sod_for_serial Parent Item Serial ? sod_override_lmt Override Limits Lmt sod__qadc01 QAD Field ? sod__qadc02 QAD Field ? sod__qadc03 QAD Field ? sod__qadc04 QAD Field ? sod__qadt01 QAD Field ? sod__qadt02 QAD Field ? sod__qadt03 QAD Field ? sod__qadt04 QAD Field ? sod__qadd01 QAD Field ? sod__qadd02 QAD Field ? sod__qadd03 QAD Field ? sod__qadl01 QAD Field ? sod__qadl02 QAD Field ? sod__qadl03 QAD Field ? sod__qadi01 QAD Field ? sod__qadi02 QAD Field ? sod_bonus Bonus Stock Line ? sod_btb_type EMT Type ? sod_btb_po EMT PO Nbr EMT PO sod_btb_pod_line EMT PO Line EMT PO Ln sod_btb_vend EMT Supplier EMT Supp sod_exp_del Exp Delivery Date Exp Date sod_dir_all Allocated Direct Alloc Dir sod_cfg_type Configuration Config sod_div Division ? sod_pl_priority P/L Priority ? sod_prig1 Pricing Group 1 ? sod_prig2 Pricing Group 2 ? sod__qadd04 ? ? sod_sub Sales Sub-Acct Sub-Acct sod_dsc_sub Disc Sub-Acct Sub-Acct sod_dsc_project Disc Project ? sod_qty_ivcd Quantity Invoiced ? sod_cum_time Time ? sod_ship_part End Customer Shipping ? sod_promise_date Promise Date Promise sod_charge_type Charge Type Charge!Type sod_order_category Category ? sod_modelyr Model Year ? sod_custref Customer Ref ? sod_consignment Consignment ? sod_max_aging_days Maximum Aging Days Maximum!Aging Days sod_consign_loc Consignment Location Consignment!Location sod_intrans_loc In-Transit Location In-Transit!Location sod_auto_replenish Auto Replenish Auto!Replenish sod_manual_fr_list Manual Fr List ? sod_domain Domain ? oid_sod_det ? ? sod_trade_sale_po Trade Sales PO TS PO sod_trade_sale_po_line Trade Sales PO Line Nu Line sod_trade_sale_vend Trade Sales Supplier TS Supplier sod_fsrev_acct Revenue Acct Revenue Acct sod_fsrev_sub Revenue Sub-Acct Sub-Acct sod_fsrev_cc Revenue CC CC sod_req_time Required Time ? sod_shipvia Ship Via ? sod_compl_stat Complete Status Status sod_compl_date Status Date Stat Date sod_hold_stat Hold Status ? sod_unadjust_cum_qty Shipped quantity ? sod_config_id Configuration ID ? =============================== INDEX SUMMARY ============================== =============================== Table: sod_det ============================= Flags:
rimary, nique, ord, bbreviated, nactive, + asc, - desc Flags Index Name Cnt Field Name ----- -------------------------------- --- --------------------------------- u oid_sod_det 1 + oid_sod_det sod_call 5 + sod_domain + sod_ca_nbr + sod_ca_line + sod_part + sod_serial sod_fr_list 3 + sod_domain + sod_nbr + sod_fr_list sod_fsm_type 4 + sod_domain + sod_fsm_type + sod_nbr + sod_line pu sod_nbrln 3 + sod_domain + sod_nbr + sod_line u sod_part 4 + sod_domain + sod_part + sod_nbr + sod_line ** Index Name: oid_sod_det Storage Area: MFG_IDX ** Index Name: sod_call Storage Area: MFG_IDX ** Index Name: sod_fr_list Storage Area: MFG_IDX ** Index Name: sod_fsm_type Storage Area: MFG_IDX ** Index Name: sod_nbrln Storage Area: MFG_IDX ** Index Name: sod_part Storage Area: MFG_IDX =============================== FIELD DETAILS ============================== =============================== Table: sod_det ============================= ** Field Name: sod_nbr Description: A unique code used to identify a specific sales order. Val-Msg: ERROR: SALES ORDER MUST EXIST. Please re-enter. Val-Exp: can-find(so_mstr where so_domain = global_domain and so_nbr = sod_nbr) ** Field Name: sod_due_date Description: The date when this line item is due to be shipped. ** Field Name: sod_per_date Description: The date which will be used to evaluate performance. ** Field Name: sod_req_date Description: The date when the customer wants to receive the items. ** Field Name: sod_line Description: The number to be used as a reference for this line item. ** Field Name: sod_part Description: The code for the item or product being ordered on this line. ** Field Name: sod_qty_ord Description: The number of items being ordered on this sales order line. ** Field Name: sod_qty_all Description: The number of items in stock allocated to this sales order line. Val-Msg: ERROR: USER DOES NOT HAVE ACCESS TO THIS FIELD. Please re-enter. Val-Exp: {gppswd.v &field = "sod_qty_all"} ** Field Name: sod_qty_pick Description: The number of items on an outstanding picklist for this line. ** Field Name: sod_qty_ship Description: The number of items that have been shipped to the customer. ** Field Name: sod_qty_inv Description: The number of items that have been shipped but not invoiced. ** Field Name: sod_loc Description: The location from which this item is to be shipped. ** Field Name: sod_type Description: A code specifying the type of shipment: D, M, F, or blank. Val-Msg: ERROR: VALUE MUST EXIST IN GENERALIZED CODES. Please re-enter. Val-Exp: {gpcode.v sod_type } ** Field Name: sod_price Description: The unit selling price for the item. Val-Msg: ERROR: USER DOES NOT HAVE ACCESS TO THIS FIELD. Please re-enter. Val-Exp: {gppswd.v &field = "sod_price"} ** Field Name: sod_std_cost Description: The standard cost per unit for this item. Val-Msg: ERROR: USER DOES NOT HAVE ACCESS TO THIS FIELD. Please re-enter. Val-Exp: {gppswd.v &field = "sod_std_cost"} ** Field Name: sod_qty_chg Description: Shipped quantity (used within shipping command). ** Field Name: sod_bo_chg Description: Remaining backorder quantity on line (used within shipping program). ** Field Name: sod_acct Description: The general ledger account used for sales. Val-Msg: ERROR: USER DOES NOT HAVE ACCESS TO THIS FIELD. Please re-enter. Val-Exp: {gppswd.v &field = "sod_acct"} ** Field Name: sod_abnormal Description: A flag indicating if this order represents an abnormal demand. ** Field Name: sod_taxable Description: A flag specifying if tax is to be charged on this line item. Val-Msg: ERROR: USER DOES NOT HAVE ACCESS TO THIS FIELD. Please re-enter. Val-Exp: {gppswd.v &field = "sod_taxable"} ** Field Name: sod_serial Description: The lot/serial number of the items shipped. ** Field Name: sod_desc Description: The description of the item ordered. ** Field Name: sod_um Description: The unit of measure for the line item. Val-Msg: ERROR: VALUE MUST EXIST IN GENERALIZED CODES. Please re-enter. Val-Exp: {gpcode.v sod_um } ** Field Name: sod_cc Description: The cost center for the sales account. Val-Msg: ERROR: USER DOES NOT HAVE ACCESS TO THIS FIELD. Please re-enter. Val-Exp: {gppswd.v &field = "sod_cc"} ** Field Name: sod_comment Description: The user's comments regarding this order line item. ** Field Name: sod_lot Description: The work order lot number generated by Final Assembly Scheduling. ** Field Name: sod_um_conv Description: The conversion factor for the Unit of Measure for this line. Val-Msg: ERROR: UM CONVERSION MAY NOT EQUAL 0. Please re-enter. Val-Exp: sod_um_conv <> 0 ** Field Name: sod_fa_nbr Description: The work order generated by Final Assembly Scheduling. ** Field Name: sod_disc_pct Description: The percentage discount to be applied to this line item. Val-Msg: ERROR: USER DOES NOT HAVE ACCESS TO THIS FIELD. Please re-enter. Val-Exp: {gppswd.v &field = "sod_disc_pct"} ** Field Name: sod_project Description: The project to which this sales order applies. Val-Msg: ERROR: INVALID PROJECT. Please re-enter. Val-Exp: {gpglproj.v sod_project} ** Field Name: sod_cmtindx Description: A pointer to the comments associated with this sales order line. ** Field Name: sod_custpart Description: The code used by the customer to identify this item. ** Field Name: sod__qad01 Description: Not used, reserved for qad use. ** Field Name: sod_status Description: Used to indicate FAS, closed, ... ** Field Name: sod_xslspsn Description: Obsolete. Replaced by sod_slspsn (extent 4). ** Field Name: sod_xcomm_pct Description: Obsolete. Replaced by sod_comm_pct (extent 4). ** Field Name: sod_dsc_acct Description: Not used. Val-Msg: ERROR: USER DOES NOT HAVE ACCESS TO THIS FIELD. Please re-enter. Val-Exp: {gppswd.v &field = "sod_dsc_acct"} ** Field Name: sod_dsc_cc Description: Not used. Val-Msg: ERROR: USER DOES NOT HAVE ACCESS TO THIS FIELD. Please re-enter. Val-Exp: {gppswd.v &field = "sod_dsc_cc"} ** Field Name: sod_list_pr Description: The list price of this sales order line item. Val-Msg: ERROR: USER DOES NOT HAVE ACCESS TO THIS FIELD. Please re-enter. Val-Exp: {gppswd.v &field = "sod_list_pr"} ** Field Name: sod_user1 Description: User field #1. ** Field Name: sod_user2 Description: User field #2. ** Field Name: sod_sob_rev Description: Date the sales order bill last modified. ** Field Name: sod_sob_std Description: Flag indicating standard options selected for features. ** Field Name: sod_qty_qote Description: Total quantity quoted to customer for this sales order line. ** Field Name: sod_consume Description: Flag indicating if this order should reduce net sales forecast. ** Field Name: sod_expire Description: Expiration date of quotation. ** Field Name: sod__qad02 Description: Not used, reserved for qad use. ** Field Name: sod_taxc Description: The VAT class if VAT, GST class if Canadian, tax exempt code if U.S. Val-Msg: ERROR: USER DOES NOT HAVE ACCESS TO THIS FIELD. Please re-enter. Val-Exp: {gppswd.v &field = "sod_taxc"} ** Field Name: sod_inv_nbr Description: secondary invoice used by field service ** Field Name: sod_partial Description: Not used. ** Field Name: sod_site Description: The inventory site from which this item is due to be shipped. Val-Msg: ERROR: INVALID SITE. Please re-enter. Val-Exp: {gpsite.v &field = sod_site &blank_ok = no} ** Field Name: sod_prodline Description: The product line of the part on this order. ** Field Name: sod_tax_in Description: A flag indicating whether the price includes tax. ** Field Name: sod_fst_list Description: A flag indicating whether Canadian Federal Sales Tax is charged. ** Field Name: sod_pst Description: A flag indicating whether Canadian Provincial Sales Tax is charged. ** Field Name: sod__chr01 Description: User custom character field #1. ** Field Name: sod__chr02 Description: User custom character field #2. ** Field Name: sod__chr03 Description: User custom character field #3. ** Field Name: sod__chr04 Description: User custom character field #4. ** Field Name: sod__chr05 Description: User custom character field #5. ** Field Name: sod__chr06 Description: User custom character field #6. ** Field Name: sod__chr07 Description: User custom character field #7. ** Field Name: sod__chr08 Description: User custom character field #8. ** Field Name: sod__chr09 Description: User custom character field #9. ** Field Name: sod__chr10 Description: User custom character field #10. ** Field Name: sod__dte01 Description: User custom date field #1. ** Field Name: sod__dte02 Description: User custom date field #2. ** Field Name: sod__dec01 Description: User custom decimal field #1. ** Field Name: sod__dec02 Description: User custom decimal field #2. ** Field Name: sod__log01 Description: User custom logical field #1. ** Field Name: sod_owner Val-Msg: ERROR: VALUE MUST EXIST IN GENERALIZED CODES. Please re-enter. Val-Exp: {gpcode.v sod_owner isb_owner} ** Field Name: sod_qty_item Description: The number of items being ordered on this sales order line. ** Field Name: sod_qty_per Description: Number of periods of contract. ** Field Name: sod_ref Description: Ref is used to make an item unique if serial is blank ** Field Name: sod_for Description: Actual hardware item this service is for. ** Field Name: sod_tax_max Description: The Max Taxable Value for a single item. ** Field Name: sod_contr_id Description: The customer's purchase order number ** Field Name: sod_pickdate Description: The date this line was printed on a pick list (if one exists) ** Field Name: sod_confirm Description: Indicates whether line has been booked and recorded as demand. Val-Msg: ERROR: USER DOES NOT HAVE ACCESS TO THIS FIELD. Please re-enter. Val-Exp: {gppswd.v &field = "sod_confirm"} ** Field Name: sod_cum_qty Description: The cumulative shipped as of the corresponding cumulative start date. ** Field Name: sod_cum_date Description: The starting date of the corresponding cumulative shipped quantity. ** Field Name: sod_fr_rate Description: Accrued freight per UM (total freight / sod_qty_ord) ** Field Name: sod_slspsn Description: The address codes of the sales agents for this sales order line. ** Field Name: sod_comm_pct Description: The commission percentages to pay on this sales order line. ** Field Name: sod_ord_mult Description: The standard pack quantity used to calculate shipment quantities. ** Field Name: sod_pkg_code Description: A code, item number or description of packaging requirements. ** Field Name: sod_curr_rlse_id Description: The active release identifier of the plan, ship or required schedule. ** Field Name: sod_sched Description: Indicates if Customer Schedules apply to this line item. ** Field Name: sod_sch_data Description: Reserved for future schedule use. ** Field Name: sod_sch_mrp Description: Indicates if any schedule quantity changes were made that affect MRP. ** Field Name: sod_rlse_nbr Description: A system maintained number to be assigned to the next release ID. ** Field Name: sod_translt_days Description: The transportation leadtime in days. ** Field Name: sod_conrep Description: Indicates how planning and/or shipping schedules are to be combined. ** Field Name: sod_start_eff Description: The starting effective date for this scheduled order line. ** Field Name: sod_end_eff Description: The ending effective date for this scheduled order line. ** Field Name: sod_dock Description: The dock address identifier. ** Field Name: sod_pr_list Description: A code indicating the price list to be used for this order. Val-Msg: ERROR: USER DOES NOT HAVE ACCESS TO THIS FIELD. Please re-enter. Val-Exp: {gppswd.v &field = "sod_pr_list"} ** Field Name: sod_translt_hrs Description: The transportation leadtime in hours. ** Field Name: sod_out_po Description: The PO number to be displayed in customer paperwork. ** Field Name: sod_raw_days Description: The number of days in which raw material purchases are authorized. ** Field Name: sod_fab_days Description: The number of days in which fabrication is authorized. ** Field Name: sod_tax_usage Description: A code which defines taxation based on the intended usage of the item. ** Field Name: sod_rbkt_days Description: The number of days to be placed into the required ship schedule. ** Field Name: sod_rbkt_weeks Description: The number of months to be placed into the required ship schedule. ** Field Name: sod_rbkt_mths Description: The number of weeks to be placed into the required ship schedule. ** Field Name: sod_sched_chgd Description: Indicates if any schedule has changed since last req schedule update. ** Field Name: sod_pastdue Description: Indicates (1) customer uses past due quantities, (2) if not. ** Field Name: sod_fix_pr Description: Indicates whether prices are affected by automatic price updates Val-Msg: ERROR: USER DOES NOT HAVE ACCESS TO THIS FIELD. Please re-enter. Val-Exp: {gppswd.v &field = "sod_fix_pr"} ** Field Name: sod_fr_wt Description: Actual unit weight of item at shipment. ** Field Name: sod_fr_wt_um Description: Unit of measure for the unit ship weight. Val-Msg: ERROR: VALUE MUST EXIST IN GENERALIZED CODES. Please re-enter. Val-Exp: {gpcode.v sod_fr_wt_um um_um} ** Field Name: sod_fr_class Description: Item Freight classification. ** Field Name: sod_fr_chg Description: The actual amount of freight charged per unit for this line. ** Field Name: sod_ship Description: The address code for this line's shipping address. ** Field Name: sod_auto_ins Description: FSM automatic installation call ** Field Name: sod_drp_ref Description: Reference number of the DRP Requisition/Inter-site Request ** Field Name: sod_tax_env Description: A code to determine the taxation method that applies to this line. ** Field Name: sod_upd_isb Description: Update Installed base by shipment of this line item. ** Field Name: sod_isb_ref Description: Installed base reference for contract billing ** Field Name: sod_enduser Description: mod ** Field Name: sod_crt_int Description: Credit Terms interest included in List Price of this Sales Order line. Val-Msg: ERROR: USER DOES NOT HAVE ACCESS TO THIS FIELD. Please re-enter. Val-Exp: {gppswd.v &field = "sod_crt_int"} ** Field Name: sod_fr_list Description: Name of the Freight List to be used for calculation of freight charges ** Field Name: sod_pricing_dt Description: Date for pricing effectivity. ** Field Name: sod_act_price Description: The total list price of all labor/components/expenses for this repair item Val-Msg: ERROR: USER DOES NOT HAVE ACCESS TO THIS FIELD. Please re-enter. Val-Exp: {gppswd.v &field = "sod_act_price"} ** Field Name: sod_covered_amt Description: The covered amount under an FSM contract. Val-Msg: ERROR: USER DOES NOT HAVE ACCESS TO THIS FIELD. Please re-enter. Val-Exp: {gppswd.v &field = "sod_covered_amt"} ** Field Name: sod_ca_nbr Description: The Call number this SO-line is attached to (MO) ** Field Name: sod_fixed_price Description: The fixed price if any for repair of this item Val-Msg: ERROR: USER DOES NOT HAVE ACCESS TO THIS FIELD. Please re-enter Val-Exp: {gppswd.v &field = "sod_fixed_price"} ** Field Name: sod_inv_cost Description: The invoice cost (transaction curr) for this line Val-Msg: ERROR: USER DOES NOT HAVE ACCESS TO THIS FIELD. Please re-enter Val-Exp: {gppswd.v &field = "sod_inv_cost"} ** Field Name: sod_car_load Description: Indication this line is loaded in Call Activity Recording (MO) ** Field Name: sod_ca_line Description: Line number of the call item ** Field Name: sod_qty_cons Description: Qty of the line that is consumed against a call (MO) ** Field Name: sod_qty_ret Description: Qty of the line that is returned (MO) ** Field Name: sod_qty_pend Description: Qty of the line that is pending to be returned (MO) ** Field Name: sod_to_loc Description: The location to which this item is to be shipped (MO). ** Field Name: sod_to_site Description: The inventory site to which this item is due to be shipped (MO). Val-Msg: ERROR: INVALID SITE. Please re-enter. Val-Exp: {gpsite.v &field = sod_to_site &blank_ok = yes} ** Field Name: sod_to_ref Description: Used to link Service kit components to parent kit via kit serial #. ** Field Name: sod_ln_ref Description: Line Reference ** Field Name: sod_qty_exch Description: Qty of the line that has been exchanged (MO) ** Field Name: sod_sad_line Description: The number of the contract-line used for this line item (SSM). ** Field Name: sod_warr_start Description: For items updating the installed base, date warranty calculation should start from. ** Field Name: sod_sv_code Description: Warranty code to attach to this item in the installed base ** Field Name: sod_for_serial Description: Serial number of the parent item (Installed Base) where this part will be installed ** Field Name: sod_override_lmt Description: override contract limits for this item ** Field Name: sod_bonus Description: Indicates whether this is a bonus stock line ** Field Name: sod_btb_type Description: Default Back To Back designation for SO line. ** Field Name: sod_btb_po Description: Back To Back PO number associated with this SO line. ** Field Name: sod_btb_pod_line Description: BTB PO line number associated with this SO line. ** Field Name: sod_btb_vend Description: Supplier Code for this order line. ** Field Name: sod_exp_del Description: System Caluclated expected date of delivery to the customer. ** Field Name: sod_dir_all Description: Tells if item has been direct allocated. ** Field Name: sod_cfg_type Description: Configuration Type: 1-Assembly, 2-Kit ** Field Name: sod_div Description: The APM division. ** Field Name: sod_pl_priority Description: The APM pricing priority. ** Field Name: sod_prig1 Description: APM pricing group 1. ** Field Name: sod_prig2 Description: APM pricing group 2. ** Field Name: sod_sub Description: The general ledger sub-account used for sales. Val-Msg: ERROR: USER DOES NOT HAVE ACCESS TO THIS FIELD. Please re-enter. Val-Exp: {gppswd.v &field = "sod_sub"} ** Field Name: sod_dsc_sub Description: Not used. Val-Msg: ERROR: USER DOES NOT HAVE ACCESS TO THIS FIELD. Please re-enter. Val-Exp: {gppswd.v &field = "sod_dsc_sub"} ** Field Name: sod_dsc_project Description: The project associated with the sales discount. Val-Msg: ERROR: INVALID PROJECT. Please re-enter. Val-Exp: {gpglproj.v sod_dsc_project} ** Field Name: sod_qty_ivcd Description: The total quantity of the sales order line that has been invoiced. ** Field Name: sod_cum_time Description: The starting time of the corresponding cumulative shipped quantity. ** Field Name: sod_ship_part Description: End customer's shipping item number when EMT direct shipment is used ** Field Name: sod_promise_date Description: Date promised to customer to receive goods at their location. ** Field Name: sod_charge_type Description: Identifies the method to use in calculating the charges for this item. ** Field Name: sod_order_category Description: Describes the type of sales order line this is. ** Field Name: sod_modelyr Description: An optional model year identifier for the order line. ** Field Name: sod_custref Description: An optional customer item identifier for the order line. ** Field Name: sod_consignment Description: Indicates that the Sales contract is for consigned mateial. The value is defaulted to the Sales Order Line. ** Field Name: sod_max_aging_days Description: The maximum number of days consigned material is allowed to age at the customer's facility. Zero indicates the material can age indefinitely. ** Field Name: sod_consign_loc Description: The location used to represent consigned inventory at the customer's facility. ** Field Name: sod_intrans_loc Description: The location used to represent consigned material in-transit. ** Field Name: sod_auto_replenish Description: Indicates whether a scheduled order replenishment line should automatically be added to the active schedule for the amount of the consumed quantity. ** Field Name: sod_manual_fr_list Description: Indicates whether Freight List has been manually updated. ** Field Name: sod_domain Description: The business domain for this data. ** Field Name: oid_sod_det Description: Unique application generated record identifier. ** Field Name: sod_trade_sale_po Description: Trade Sale PO number associated with this SO line. ** Field Name: sod_trade_sale_po_line Description: Trade Sale PO line number associated with this sales order line. ** Field Name: sod_trade_sale_vend Description: Trade Sales supplier code for this sales order line. ** Field Name: sod_fsrev_acct Description: The general ledger account used for deferred and accrued revenue. ** Field Name: sod_fsrev_sub Description: The general ledger sub-account used for deferred and accrued revenue. ** Field Name: sod_fsrev_cc Description: The cost center for the deferred and accrued Revenue account. ** Field Name: sod_req_time Description: The required time for the order line. Val-Msg: ERROR: TIME MUST BE HH:MM FORMAT. Please re-enter. Val-Exp: {fstime.v sod_req_time} ** Field Name: sod_shipvia Description: A note indicating how this order line should be shipped. ** Field Name: sod_compl_stat Description: Order Line Complete Status (ex. Invoiced, Cancelled) ** Field Name: sod_compl_date Description: The date the current Complete status was set ** Field Name: sod_hold_stat Description: Order Line Hold Status (ex. Credit, Drawing) ** Field Name: sod_unadjust_cum_qty Description: The cum quantity for the order line. ** Field Name: sod_config_id Description: The configuration id associated with the line item when the line item is a configurable item