14/06/21 16:24:20 PROGRESS Report Database: qaddb (PROGRESS) ============================================================================ =============================== Table: so_mstr ============================= Table Flags: "f"=frozen, "s"=a SQL table Table Table Field Index Table Name Flags Count Count Label -------------------------------- ----- ----- ----- ------------------------ so_mstr f 182 13 ? Dump Name: so_mstr Description: Sales Order Master Storage Area: MFG Trigger Event Trigger Procedure Overridable? Check CRC? ------------- -------------------- ------------ ---------- CREATE soc.t no no REPLICATION-D sord.t no no REPLICATION-W sorw.t no no Write sow.t no no =============================== FIELD SUMMARY ============================== =============================== Table: so_mstr ============================= Flags: ase sensitive, ndex component, andatory, iew component Order Field Name Data Type Flags ----- -------------------------------- ----------- ----- 10 so_nbr char im 20 so_cust char i 30 so_ship char i 40 so_ord_date date i 50 so_req_date date 60 so_due_date date 70 so_rmks char 80 so_cr_terms char 90 so_fob char 100 so_po char i 110 so_shipvia char 120 so_partial logi 130 so_print_so logi 140 so_inv_nbr char i 150 so_pr_list char 160 so_xslspsn char[2] 170 so_source char 180 so_xcomm_pct deci-10[2] 190 so_cr_card char 200 so_print_pl logi 210 so_cr_init char 220 so_stat char 230 so__qad01 deci-10 240 so__qad02 deci-10 250 so__qad03 deci-10 260 so_disc_pct deci-10 270 so_tax_pct deci-10[3] 280 so_prepaid deci-10 290 so_to_inv logi i 300 so_invoiced logi 310 so_ar_acct char 320 so_ar_cc char 330 so_inv_date date 340 so_ship_date date 350 so_taxable logi 360 so_cmtindx inte 370 so__qad04 inte 380 so_user1 char 390 so_user2 char 400 so_curr char 410 so_ex_rate deci-10 420 so_lang char 430 so_type char 440 so_conf_date date 450 so_rev inte 460 so_bol char 470 so__qad05 deci-10[2] 480 so_pst logi 490 so_fst_id char 500 so_trl1_amt deci-10 510 so_trl1_cd char 520 so_trl2_amt deci-10 530 so_trl2_cd char 540 so_trl3_amt deci-10 550 so_trl3_cd char 560 so_weight deci-10 570 so_weight_um char 580 so_size deci-10 590 so_size_um char 600 so_cartons inte 610 so_site char 620 so_pst_id char 630 so_cncl_date date 640 so_quote char i 650 so_taxc char 660 so__chr01 char 670 so__chr02 char 680 so__chr03 char 690 so__chr04 char 700 so__chr05 char 710 so__chr06 char 720 so__chr07 char 730 so__chr08 char 740 so__chr09 char 750 so__chr10 char 760 so__dte01 date 770 so__dte02 date 780 so__dec01 deci-10 790 so__dec02 deci-10 800 so__log01 logi 810 so_credit logi 820 so_inv_cr char 830 so_project char 840 so_channel char 850 so_pst_pct deci-10 860 so_fr_list char 870 so_fr_terms char 880 so_slspsn char[4] 890 so_comm_pct deci-10[4] 900 so_inv_mthd char 910 so_fix_rate logi 920 so_ent_ex deci-10 930 so_bill char i 940 so_print_bl logi 950 so_tax_date date 960 so_fsm_type char i 970 so_userid char 980 so_conrep char 990 so_bank char 1000 so_tax_env char 1010 so_sched logi 1020 so_fr_min_wt deci-10 1030 so_pr_list2 char 1040 so_tax_usage char 1050 so_sa_nbr char 1060 so_fix_pr logi 1070 so_sch_mthd char 1080 so_eng_code char 1090 so_ship_eng logi 1100 so_pricing_dt date 1110 so_priced_dt date 1120 so_ca_nbr char i 1130 so_fcg_code char 1140 so_crprlist char 1150 so__qadc01 char 1160 so__qadc02 char 1170 so__qadc03 char 1180 so__qadc04 char 1190 so__qadc05 char 1200 so__qadl01 logi 1210 so__qadl02 logi 1220 so_incl_iss logi 1230 so__qadi01 inte 1240 so__qadi02 inte 1250 so__qadi03 inte 1260 so__qadd01 deci-10 1270 so__qadd02 deci-10 1280 so__qadd03 deci-10 1290 so__qadt01 date 1300 so__qadt02 date 1310 so__qadt03 date 1320 so_auth_days inte 1330 so_cum_acct logi 1340 so_merge_rss logi 1350 so_ship_cmplt inte 1360 so_bump_all logi 1370 so_primary logi m 1380 so_cust_po char im 1390 so_secondary logi 1400 so_ship_po char 1410 so_ex_rate2 deci-10 m 1420 so_ex_ratetype char m 1430 so_div char 1440 so_exru_seq inte m 1450 so_app_owner char 1460 so_ar_sub char 1470 so_seq_order logi 1480 so_inc_in_rss logi 1490 so_firm_seq_days inte 1500 so_prep_tax deci-10 m 1510 so__qadl04 logi 1520 so_custref_val logi m 1530 so_consignment logi m 1540 so_max_aging_days inte m 1550 so_consign_loc char m 1560 so_intrans_loc char m 1570 so_auto_replenish logi m 1580 so_revenue char m 1590 so_fsaccr_acct char m 1600 so_fsaccr_sub char m 1610 so_fsaccr_cc char m 1620 so_fsdef_acct char m 1630 so_fsdef_sub char m 1640 so_fsdef_cc char m 1650 so_manual_fr_terms logi m 1660 so_domain char im 1670 oid_so_mstr deci-10 im 1680 so_rss_cal_option inte m 1690 so_trade_sale logi m 1700 so_daybookset char m 1710 so_reviewed logi m 1720 so_req_time char m 1730 so_nrm char m 1740 so_compl_stat char im 1750 so_compl_date date 1760 so_hold_stat char m 1770 so_promise_date date 1780 so_per_date date 1790 so_tax_in logi m 1800 so_consume logi m 1810 so_reprice logi m 1820 so_calc_fr logi m Field Name Format -------------------------------- ----------------------------- so_nbr x(8) so_cust x(8) so_ship x(8) so_ord_date 99/99/99 so_req_date 99/99/99 so_due_date 99/99/99 so_rmks x(40) so_cr_terms x(8) so_fob x(20) so_po x(22) so_shipvia x(20) so_partial yes/no so_print_so yes/no so_inv_nbr x(22) so_pr_list x(8) so_xslspsn x(8) so_source x(8) so_xcomm_pct >>9.99% so_cr_card x(2) so_print_pl yes/no so_cr_init x(3) so_stat x(2) so__qad01 -z,zzz,zzz,zz9.99 so__qad02 -z,zzz,zzz,zz9.99 so__qad03 -z,zzz,zzz,zz9.99 so_disc_pct ->>9.99% so_tax_pct ->9.99<% so_prepaid -z,zzz,zzz,zz9.99 so_to_inv yes/no so_invoiced yes/no so_ar_acct x(8) so_ar_cc x(4) so_inv_date 99/99/99 so_ship_date 99/99/99 so_taxable yes/no so_cmtindx >>>>>>>9 so__qad04 > so_user1 x(8) so_user2 x(8) so_curr x(3) so_ex_rate >>>>,>>>,>>9.9<<<<<<<<< so_lang x(2) so_type x(8) so_conf_date 99/99/99 so_rev >>9 so_bol x(18) so__qad05 >>9.9<< so_pst yes/no so_fst_id x(18) so_trl1_amt -zzzz,zzz,zz9.99 so_trl1_cd x(2) so_trl2_amt -zzzz,zzz,zz9.99 so_trl2_cd x(2) so_trl3_amt -zzzz,zzz,zz9.99 so_trl3_cd x(2) so_weight ->>>,>>>,>>9.9999 so_weight_um x(2) so_size ->,>>>,>>9.9<<<<<<<< so_size_um x(2) so_cartons ->,>>>,>>9 so_site x(8) so_pst_id x(18) so_cncl_date 99/99/99 so_quote x(8) so_taxc x(3) so__chr01 x(8) so__chr02 x(8) so__chr03 x(8) so__chr04 x(8) so__chr05 x(8) so__chr06 x(8) so__chr07 x(8) so__chr08 x(8) so__chr09 x(8) so__chr10 x(8) so__dte01 99/99/99 so__dte02 99/99/99 so__dec01 >>>,>>>,>>9.99 so__dec02 >>>,>>>,>>9.99 so__log01 yes/no so_credit yes/no so_inv_cr x(8) so_project x(8) so_channel x(8) so_pst_pct ->9.99<% so_fr_list x(8) so_fr_terms x(8) so_slspsn x(8) so_comm_pct >>9.99% so_inv_mthd x(1) so_fix_rate yes/no so_ent_ex >>,>>9.99999<<<<< so_bill x(8) so_print_bl yes/no so_tax_date 99/99/99 so_fsm_type x(8) so_userid x(8) so_conrep x(1) so_bank x(2) so_tax_env x(16) so_sched yes/no so_fr_min_wt ->>>,>>>,>>9 so_pr_list2 x(8) so_tax_usage x(8) so_sa_nbr x(8) so_fix_pr yes/no so_sch_mthd x(1) so_eng_code x(8) so_ship_eng yes/no so_pricing_dt 99/99/99 so_priced_dt 99/99/99 so_ca_nbr x(8) so_fcg_code x(8) so_crprlist X(8) so__qadc01 X(8) so__qadc02 X(8) so__qadc03 X(8) so__qadc04 X(8) so__qadc05 X(8) so__qadl01 yes/no so__qadl02 yes/no so_incl_iss yes/no so__qadi01 ->,>>>,>>9 so__qadi02 ->,>>>,>>9 so__qadi03 ->,>>>,>>9 so__qadd01 ->>>>,>>>,>>9.99<<< so__qadd02 ->>>>,>>>,>>9.99<<< so__qadd03 ->>>>,>>>,>>9.99<<< so__qadt01 99/99/99 so__qadt02 99/99/99 so__qadt03 99/99/99 so_auth_days >>9 so_cum_acct Cum/Req so_merge_rss yes/no so_ship_cmplt >>9 so_bump_all yes/no so_primary yes/no so_cust_po x(22) so_secondary yes/no so_ship_po x(22) so_ex_rate2 >>>>,>>>,>>9.9<<<<<<<<< so_ex_ratetype x(8) so_div x(8) so_exru_seq >>>>>>>>9 so_app_owner x(12) so_ar_sub x(8) so_seq_order yes/no so_inc_in_rss yes/no so_firm_seq_days >>9 so_prep_tax ->>>>,>>>,>>9.99<<< so__qadl04 yes/no so_custref_val yes/no so_consignment yes/no so_max_aging_days >>9 so_consign_loc x(8) so_intrans_loc x(8) so_auto_replenish yes/no so_revenue x(1) so_fsaccr_acct x(8) so_fsaccr_sub x(8) so_fsaccr_cc x(4) so_fsdef_acct x(8) so_fsdef_sub x(8) so_fsdef_cc x(4) so_manual_fr_terms yes/no so_domain x(8) oid_so_mstr >>>>>>>>>>>>>>>>>>>>>>>>>>>9. so_rss_cal_option >>9 so_trade_sale yes/no so_daybookset x(8) so_reviewed yes/no so_req_time 99:99 so_nrm x(8) so_compl_stat x(8) so_compl_date 99/99/99 so_hold_stat x(8) so_promise_date 99/99/99 so_per_date 99/99/99 so_tax_in yes/no so_consume yes/no so_reprice yes/no so_calc_fr yes/no Field Name Initial -------------------------------- ----------------------------- so_nbr so_cust so_ship so_ord_date ? so_req_date ? so_due_date ? so_rmks so_cr_terms so_fob so_po so_shipvia so_partial yes so_print_so no so_inv_nbr so_pr_list so_xslspsn so_source so_xcomm_pct 0 so_cr_card so_print_pl yes so_cr_init so_stat so__qad01 0 so__qad02 0 so__qad03 0 so_disc_pct 0 so_tax_pct 0 so_prepaid 0 so_to_inv no so_invoiced no so_ar_acct so_ar_cc so_inv_date ? so_ship_date ? so_taxable no so_cmtindx 0 so__qad04 0 so_user1 so_user2 so_curr so_ex_rate 1 so_lang so_type so_conf_date ? so_rev 0 so_bol so__qad05 0 so_pst no so_fst_id so_trl1_amt 0 so_trl1_cd so_trl2_amt 0 so_trl2_cd so_trl3_amt 0 so_trl3_cd so_weight 0 so_weight_um so_size 0 so_size_um so_cartons 0 so_site so_pst_id so_cncl_date ? so_quote so_taxc so__chr01 so__chr02 so__chr03 so__chr04 so__chr05 so__chr06 so__chr07 so__chr08 so__chr09 so__chr10 so__dte01 ? so__dte02 ? so__dec01 0 so__dec02 0 so__log01 no so_credit no so_inv_cr so_project so_channel so_pst_pct 0 so_fr_list so_fr_terms so_slspsn so_comm_pct 0 so_inv_mthd so_fix_rate no so_ent_ex 1 so_bill so_print_bl no so_tax_date ? so_fsm_type so_userid so_conrep so_bank so_tax_env so_sched no so_fr_min_wt 0 so_pr_list2 so_tax_usage so_sa_nbr so_fix_pr y so_sch_mthd so_eng_code so_ship_eng no so_pricing_dt ? so_priced_dt ? so_ca_nbr so_fcg_code so_crprlist so__qadc01 so__qadc02 so__qadc03 so__qadc04 so__qadc05 so__qadl01 no so__qadl02 no so_incl_iss yes so__qadi01 0 so__qadi02 0 so__qadi03 0 so__qadd01 0 so__qadd02 0 so__qadd03 0 so__qadt01 ? so__qadt02 ? so__qadt03 ? so_auth_days 0 so_cum_acct yes so_merge_rss no so_ship_cmplt 0 so_bump_all no so_primary yes so_cust_po so_secondary no so_ship_po so_ex_rate2 1 so_ex_ratetype so_div so_exru_seq 0 so_app_owner so_ar_sub so_seq_order no so_inc_in_rss yes so_firm_seq_days 0 so_prep_tax 0 so__qadl04 no so_custref_val no so_consignment no so_max_aging_days 0 so_consign_loc so_intrans_loc so_auto_replenish no so_revenue so_fsaccr_acct so_fsaccr_sub so_fsaccr_cc so_fsdef_acct so_fsdef_sub so_fsdef_cc so_manual_fr_terms no so_domain oid_so_mstr 0 so_rss_cal_option 1 so_trade_sale no so_daybookset so_reviewed no so_req_time so_nrm so_compl_stat so_compl_date ? so_hold_stat so_promise_date ? so_per_date ? so_tax_in no so_consume yes so_reprice no so_calc_fr no Field Name Label Column Label ------------------------------ ---------------------- ---------------------- so_nbr Sales Order Order so_cust Sold-To ? so_ship Ship-To ? so_ord_date Order Date Ord Date so_req_date Required Date Required so_due_date Due Date Due so_rmks Remarks ? so_cr_terms Credit Terms Terms so_fob FOB Point ? so_po Purchase Order ? so_shipvia Ship Via ? so_partial Partial OK Partial so_print_so Print Sales Order Print SO so_inv_nbr Invoice Number Invoice so_pr_list Manual Disc Tbl so_xslspsn Salesperson Salespsn so_source Order Source Source so_xcomm_pct Commission Comm% so_cr_card Credit Card Card so_print_pl Print Pack List Print Pack so_cr_init Cr Initials Initials so_stat Action Status St so__qad01 ? ? so__qad02 ? ? so__qad03 ? ? so_disc_pct Disc % ? so_tax_pct Tax ? so_prepaid Prepaid ? so_to_inv Ready to Invoice Invoice so_invoiced Invoiced ? so_ar_acct AR Account AR so_ar_cc Cost Ctr CC so_inv_date Invoice Date Inv Date so_ship_date Ship Date ? so_taxable Taxable Tax so_cmtindx Comment Index Comment so__qad04 ? ? so_user1 Ufld1 ? so_user2 Ufld2 ? so_curr Currency Cur so_ex_rate Exch Rate ? so_lang Language ? so_type Type ? so_conf_date Confirmed Date Confirmed so_rev Revision Rev so_bol BOL ? so__qad05 ? ? so_pst PST ? so_fst_id FST ID ? so_trl1_amt Trailer Amt 1 ? so_trl1_cd Trailer 1 Trl1 so_trl2_amt Trailer Amt 2 ? so_trl2_cd Trailer 2 Trl2 so_trl3_amt Trailer Amt 3 ? so_trl3_cd Trailer 3 Trl3 so_weight Weight ? so_weight_um Weight UM UM so_size Size ? so_size_um Size UM UM so_cartons Cartons ? so_site Site ? so_pst_id PST ID ? so_cncl_date Cancel Date Cancel so_quote Quote ? so_taxc Tax Class TxC so__chr01 ? ? so__chr02 ? ? so__chr03 ? ? so__chr04 ? ? so__chr05 ? ? so__chr06 ? ? so__chr07 ? ? so__chr08 ? ? so__chr09 ? ? so__chr10 ? ? so__dte01 ? ? so__dte02 ? ? so__dec01 ? ? so__dec02 ? ? so__log01 ? ? so_credit Credit Cr so_inv_cr Invoice To Credit Cr Invoice so_project Project ? so_channel Channel ? so_pst_pct PST Pct ? so_fr_list Freight List Frt List so_fr_terms Freight Terms Fr Terms so_slspsn Salesperson Salespsn so_comm_pct Commission Comm% so_inv_mthd Invoices Via ? so_fix_rate Fixed Rate Fixed so_ent_ex Exch Rate ? so_bill Bill-To ? so_print_bl Print Bill of Lading Print BOL so_tax_date Tax Date ? so_fsm_type FSM Type ? so_userid User ID ? so_conrep Netting Logic C/R so_bank Bank ? so_tax_env Tax Environment Tax Env so_sched Scheduled ? so_fr_min_wt Frt Min Wt ? so_pr_list2 Price Tbl Pr Tbl so_tax_usage Tax Usage TaxUsage so_sa_nbr Contract ? so_fix_pr Fixed Price ? so_sch_mthd Schedules Via ? so_eng_code Engineer ? so_ship_eng Ship-To Engineer ? so_pricing_dt Pricing Date Price Dt so_priced_dt Last Price Dt Last Pri so_ca_nbr Call ? so_fcg_code Charge Code ? so_crprlist Credit Price List ? so__qadc01 QAD Field ? so__qadc02 QAD Field ? so__qadc03 QAD Field ? so__qadc04 QAD Field ? so__qadc05 QAD Field ? so__qadl01 QAD Field ? so__qadl02 Exclude Planning Data ? so_incl_iss Include Saturday/Sunda ? so__qadi01 QAD Field ? so__qadi02 QAD Field ? so__qadi03 QAD Field ? so__qadd01 QAD Field ? so__qadd02 QAD Field ? so__qadd03 QAD Field ? so__qadt01 QAD Field ? so__qadt02 QAD Field ? so__qadt03 QAD Field ? so_auth_days AUTHNBR Unique Days ? so_cum_acct Cumulative Accounting ? so_merge_rss Merge RSS ? so_ship_cmplt Ship Complete ? so_bump_all Unpeg ? so_primary Primary SO Pr SO so_cust_po End Customer PO End Cust PO so_secondary Secondary EMT Order Sec EMT so_ship_po Ship To PO ? so_ex_rate2 Exch Rate 2 ? so_ex_ratetype Rate Type ? so_div Division ? so_exru_seq Sequence ? so_app_owner Owner Application ? so_ar_sub AR Sub-Account Sub-Acct so_seq_order Sequenced Partial so_inc_in_rss Include Seq in Req Shi ? so_firm_seq_days Firm Days ? so_prep_tax Prepaid Tax ? so__qadl04 ? ? so_custref_val Customer Ref Is Custom ? so_consignment Consignment ? so_max_aging_days Maximum Aging Days Maximum!Aging Days so_consign_loc Consignment Location Consignment!Location so_intrans_loc In-Transit Location In-Transit!Location so_auto_replenish Auto Replenish Auto!Replenish so_revenue Revenue Type ? so_fsaccr_acct Accrued Revenue Accrued so_fsaccr_sub Accrued Revenue Sub-Ac ? so_fsaccr_cc Accrued Revenue CC ? so_fsdef_acct Deferred Revenue Deferred so_fsdef_sub Deferred Revenue Sub-A ? so_fsdef_cc Deferred Revenue CC ? so_manual_fr_terms Manual Fr Terms ? so_domain Domain ? oid_so_mstr ? ? so_rss_cal_option RSS Calendar Option ? so_trade_sale Trade Sales Contract ? so_daybookset Daybook Set Dybk Set so_reviewed Reviewed ? so_req_time Required Time ? so_nrm Sequence ID Seq ID so_compl_stat Complete Status Status so_compl_date Status Date Stat Date so_hold_stat Hold Status ? so_promise_date Promise Date Promise so_per_date Perform ? so_tax_in Tax In ? so_consume Consume Forecast Consume Fcst so_reprice Reprice/Edit ? so_calc_fr Calculate Freight ? =============================== INDEX SUMMARY ============================== =============================== Table: so_mstr ============================= Flags:
rimary, nique, ord, bbreviated, nactive, + asc, - desc Flags Index Name Cnt Field Name ----- -------------------------------- --- --------------------------------- u oid_so_mstr 1 + oid_so_mstr so_bill 5 + so_domain + so_bill + so_compl_stat + so_nbr + so_ord_date so_ca_nbr 2 + so_domain + so_ca_nbr u so_complete 3 + so_domain + so_compl_stat + so_nbr so_cust 3 + so_domain + so_cust + so_compl_stat so_cust_po 4 + so_domain + so_cust_po + so_cust + so_nbr so_fsm_type 3 + so_domain + so_fsm_type + so_nbr so_invoice 2 + so_domain + so_inv_nbr pu so_nbr 2 + so_domain + so_nbr so_po_nbr 4 + so_domain + so_po + so_cust + so_nbr so_quote 3 + so_domain + so_quote + so_nbr so_ship 3 + so_domain + so_ship + so_compl_stat u so_to_inv 3 + so_domain + so_to_inv + so_nbr ** Index Name: oid_so_mstr Storage Area: MFG_IDX ** Index Name: so_bill Storage Area: MFG_IDX ** Index Name: so_ca_nbr Storage Area: MFG_IDX ** Index Name: so_complete Storage Area: MFG_IDX ** Index Name: so_cust Storage Area: MFG_IDX ** Index Name: so_cust_po Storage Area: MFG_IDX ** Index Name: so_fsm_type Storage Area: MFG_IDX ** Index Name: so_invoice Storage Area: MFG_IDX ** Index Name: so_nbr Storage Area: MFG_IDX ** Index Name: so_po_nbr Storage Area: MFG_IDX ** Index Name: so_quote Storage Area: MFG_IDX ** Index Name: so_ship Storage Area: MFG_IDX ** Index Name: so_to_inv Storage Area: MFG_IDX =============================== FIELD DETAILS ============================== =============================== Table: so_mstr ============================= ** Field Name: so_nbr Description: A unique code used to identify a specific sales order. ** Field Name: so_cust Description: The address code for the customer placing the order. ** Field Name: so_ship Description: The address code for the customer's shipping address. ** Field Name: so_ord_date Description: The date the order was entered into the system. Val-Msg: ERROR: USER DOES NOT HAVE ACCESS TO THIS FIELD. Please re-enter. Val-Exp: {gppswd.v &field = "so_ord_date"} ** Field Name: so_req_date Description: The date the customer wants to receive the order. ** Field Name: so_due_date Description: The date the order is to be shipped. Default is today plus LT. ** Field Name: so_rmks Description: The user's remarks regarding this sales order. ** Field Name: so_cr_terms Description: A code indicating the credit terms. (defaults to customer terms). Val-Msg: ERROR: USER DOES NOT HAVE ACCESS TO THIS FIELD. Please re-enter. Val-Exp: {gppswd.v &field = "so_cr_terms"} ** Field Name: so_fob Description: The point at which legal title to the shipped goods changes hands. Val-Msg: ERROR: VALUE MUST EXIST IN GENERALIZED CODES. Please re-enter. Val-Exp: {gpcode.v so_fob } ** Field Name: so_po Description: The customer purchase order number associated with the sales order. ** Field Name: so_shipvia Description: A note indicating how this order should be shipped. Val-Msg: ERROR: VALUE MUST EXIST IN GENERALIZED CODES. Please re-enter. Val-Exp: {gpcode.v so_shipvia } ** Field Name: so_partial Description: Not used. ** Field Name: so_print_so Description: A flag indicating if the sales order is to be printed. ** Field Name: so_inv_nbr Description: The invoice number that is associated with this sales order. Val-Msg: ERROR: USER DOES NOT HAVE ACCESS TO THIS FIELD. Please re-enter. Val-Exp: {gppswd.v &field = "so_inv_nbr"} ** Field Name: so_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 = "so_pr_list"} ** Field Name: so_xslspsn Description: Obsolete. Replaced by so_slspsn (extent 4). ** Field Name: so_source Description: A code indicating the source of the order. (ie. Telephone, Mail). Val-Msg: ERROR: VALUE MUST EXIST IN GENERALIZED CODES. Please re-enter. Val-Exp: {gpcode.v so_source } ** Field Name: so_xcomm_pct Description: Obsolete. Replaced by so_comm_pct (extent 4). ** Field Name: so_cr_card Description: A code indicating the credit card used to pay for the order. Val-Msg: ERROR: VALUE MUST EXIST IN GENERALIZED CODES. Please re-enter. Val-Exp: {gpcode.v so_cr_card } ** Field Name: so_print_pl Description: A flag indicating if a packing list should be printed. ** Field Name: so_cr_init Description: The initials of the person who approved credit for this order. Val-Msg: ERROR: VALUE MUST EXIST IN GENERALIZED CODES. Please re-enter. Val-Exp: {gpcode.v so_cr_init } ** Field Name: so_stat Description: A code indicating the status of this order. (Hold is HU or HC). Val-Msg: ERROR: VALUE MUST EXIST IN GENERALIZED CODES. Please re-enter. Val-Exp: {gpcode.v so_stat } ** Field Name: so__qad01 Description: Not used, reserved for qad use. ** Field Name: so__qad02 Description: Not used, reserved for qad use. ** Field Name: so__qad03 Description: Not used, reserved for qad use. ** Field Name: so_disc_pct Description: The discount percentage to be applied to the entire order. Val-Msg: ERROR: USER DOES NOT HAVE ACCESS TO THIS FIELD. Please re-enter. Val-Exp: {gppswd.v &field = "so_disc_pct"} ** Field Name: so_tax_pct Description: The percentage tax to be applied to all taxable order line items. ** Field Name: so_prepaid Description: The amount of prepayment. A cash receipt must also be entered. ** Field Name: so_to_inv Description: A flag indicating that uninvoiced shipments against the order exist. ** Field Name: so_invoiced Description: A flag indicating an invoice has been printed for this order. ** Field Name: so_ar_acct Description: The general ledger accounts receivable account for this order. Val-Msg: ERROR: USER DOES NOT HAVE ACCESS TO THIS FIELD. Please re-enter. Val-Exp: {gppswd.v &field = "so_ar_acct"} ** Field Name: so_ar_cc Description: The cost center for the Accounts Receivable account. Val-Msg: ERROR: USER DOES NOT HAVE ACCESS TO THIS FIELD. Please re-enter. Val-Exp: {gppswd.v &field = "so_ar_cc"} ** Field Name: so_inv_date Description: The date that the invoice for this sales order was generated. ** Field Name: so_ship_date Description: The date when this order was shipped to the customer. ** Field Name: so_taxable Description: A flag specifying if tax should be applied to this order. Val-Msg: ERROR: USER DOES NOT HAVE ACCESS TO THIS FIELD. Please re-enter. Val-Exp: {gppswd.v &field = "so_taxable"} ** Field Name: so_cmtindx Description: A pointer to the comments associated with the sales order. ** Field Name: so__qad04 Description: Not used, reserved for qad use. ** Field Name: so_user1 Description: User field #1. ** Field Name: so_user2 Description: User field #2. ** Field Name: so_curr Description: The currency in which to pay for the order. Val-Msg: ERROR: USER DOES NOT HAVE ACCESS TO THIS FIELD. Please re-enter. Val-Exp: {gppswd.v &field = "so_curr"} ** Field Name: so_ex_rate Description: Number of transaction currency units related to base currency units. ** Field Name: so_lang Description: The language for the order. Val-Msg: ERROR: LANGUAGE MUST EXIST. Please re-enter. Val-Exp: {gplang.v so_lang} ** Field Name: so_type Description: Code to distinguish normal, quote, closed, ....orders. ** Field Name: so_conf_date Description: The date the sales order was confirmed. ** Field Name: so_rev Description: Sales order print revision number. ** Field Name: so_bol Description: The bill of lading number given by the carrier. ** Field Name: so__qad05 Description: Not used, reserved for qad use. ** Field Name: so_pst Description: A flag indicating whether Canadian Provincial tax is to be charged. ** Field Name: so_fst_id Description: The Canadian Federal Tax Exemption License number. ** Field Name: so_trl1_amt Description: The amount associated with the first trailer item. ** Field Name: so_trl1_cd Description: The code for the first trailer item (defaults from soc_ctrl). ** Field Name: so_trl2_amt Description: The amount associated with the second trailer item. ** Field Name: so_trl2_cd Description: The code for the second trailer item (defaults from soc_ctrl). ** Field Name: so_trl3_amt Description: The amount associated with the third trailer item. ** Field Name: so_trl3_cd Description: The code for the third trailer item (defaults from soc_ctrl). ** Field Name: so_weight Description: Not used. Formerly the weight of the sales order shipment. ** Field Name: so_weight_um Description: Not used. Formerly the unit of measure for weight of the SO shipment. Val-Msg: ERROR: VALUE MUST EXIST IN GENERALIZED CODES. Please re-enter. Val-Exp: {gpcode.v so_weight_um } ** Field Name: so_size Description: Not used. Formerly the volume of the sales order shipment. ** Field Name: so_size_um Description: Not used. Formerly the unit of measure the the SO shipment volumne. Val-Msg: ERROR: VALUE MUST EXIST IN GENERALIZED CODES. Please re-enter. Val-Exp: {gpcode.v so_size_um } ** Field Name: so_cartons Description: Not used. Formerly the number of cartons in the sales order shipment. ** Field Name: so_site Description: The default inventory site for allocations and shipments. Val-Msg: ERROR: INVALID SITE. Please re-enter. Val-Exp: {gpsite.v &field = so_site &blank_ok = yes} ** Field Name: so_pst_id Description: The Canadian Provincial Sales Tax Exemption License number. ** Field Name: so_cncl_date Description: Not used. The date the sales order was cancelled. ** Field Name: so_quote Description: The number of the quote the sales order was created from (if any). ** Field Name: so_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 = "so_taxc"} ** Field Name: so__chr01 Description: User custom character field #1. ** Field Name: so__chr02 Description: User custom character field #2. ** Field Name: so__chr03 Description: User custom character field #3. ** Field Name: so__chr04 Description: User custom character field #4. ** Field Name: so__chr05 Description: User custom character field #5. ** Field Name: so__chr06 Description: User custom character field #6. ** Field Name: so__chr07 Description: User custom character field #7. ** Field Name: so__chr08 Description: User custom character field #8. ** Field Name: so__chr09 Description: User custom character field #9. ** Field Name: so__chr10 Description: User custom character field #10. ** Field Name: so__dte01 Description: User custom date field #1. ** Field Name: so__dte02 Description: User custom date field #2. ** Field Name: so__dec01 Description: User custom decimal field #1. ** Field Name: so__dec02 Description: User custom decimal field #2. ** Field Name: so__log01 Description: User custom logical field #1. ** Field Name: so_credit Description: Determines if the Sales Order/Invoice is a Credit Memo ** Field Name: so_inv_cr Description: The Invoice to be credit by this credit ** Field Name: so_project Description: Project number Val-Msg: ERROR: INVALID PROJECT. Please re-enter. Val-Exp: {gpglproj.v so_project} ** Field Name: so_channel Description: A Code indicating what channel a Sales Order was sold into. Val-Msg: ERROR: VALUE MUST EXIST IN GENERALIZED CODES. Please re-enter. Val-Exp: {gpcode.v so_channel} ** Field Name: so_pst_pct Description: The Provincial Sales Tax rate for this Canadian sales order. ** Field Name: so_fr_list Description: Name of the Freight List to be used for shipping this order. ** Field Name: so_fr_terms Description: Freight Terms that apply to this order. ** Field Name: so_slspsn Description: The address codes of the salespersons for this order. Val-Msg: ERROR: SALESPERSON MUST EXIST. Please re-enter. Val-Exp: can-find(sp_mstr where sp_domain = global_domain and sp_addr = so_slspsn) or so_slspsn = "" ** Field Name: so_comm_pct Description: The commission percentage to be received by the salesperson. ** Field Name: so_inv_mthd Description: The method for invoicing: EDI, Paper, Both, None. ** Field Name: so_ent_ex Description: The exchange rate as entered by the user (may be base/foreign). Val-Msg: ERROR: USER DOES NOT HAVE ACCESS TO THIS FIELD. Please re-enter. Val-Exp: {gppswd.v &field = "so_ent_ex"} ** Field Name: so_bill Description: The address code for the customer paying for the order. ** Field Name: so_print_bl Description: A flag indicating if a Bill of Lading should be printed. ** Field Name: so_tax_date Description: The Date used for finding Tax Rates. ** Field Name: so_fsm_type Description: mod ** Field Name: so_userid Description: The person who entered this transaction. ** Field Name: so_conrep Description: Indicates how planning and/or shipping schedules are to be combined. ** Field Name: so_bank Description: The code identifying the bank through which payment should be received ** Field Name: so_tax_env Description: A code to determine taxation method for this order. ** Field Name: so_sched Description: Indicates if the order is scheduled. ** Field Name: so_fr_min_wt Description: Minimum weight for freight charge calculations. ** Field Name: so_pr_list2 Description: A code indicating the list 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 = "so_pr_list2"} ** Field Name: so_tax_usage Description: A code which defines taxation based on intended usage of the order. ** Field Name: so_sa_nbr Description: contract number ** Field Name: so_fix_pr Description: Default for whether prices are affected by price updates. Val-Msg: ERROR: USER DOES NOT HAVE ACCESS TO THIS FIELD. Please re-enter. Val-Exp: {gppswd.v &field = "so_fix_pr"} ** Field Name: so_sch_mthd Description: The method of communicating schedules: EDI, Paper, Both. ** Field Name: so_eng_code Description: Engineer who entered this order Val-Msg: ERROR: ENGINEER MUST EXIST. Please re-enter. Val-Exp: {fseng.v &field=so_eng_code &blank_ok=yes} ** Field Name: so_ship_eng Description: Indication that ship-to engineer code (emp_mstr) ** Field Name: so_pricing_dt Description: Default date for Pricing effectivity. ** Field Name: so_priced_dt Description: Last date SO was priced (by Maint or reprice utility). ** Field Name: so_ca_nbr Val-Msg: ERROR: ORDER MUST EXIST. Please re-enter. Val-Exp: {fspjca.v &field = so_ca_nbr &blank_ok = yes} ** Field Name: so_fcg_code Description: The charge code for the MO (only if own consumption) ** Field Name: so_crprlist Description: Credit price list to be used for RMA returns. ** Field Name: so_incl_iss Description: Logical indicating whether to include weekend days ** Field Name: so_auth_days Description: The number of days an authorization number must be unique. ** Field Name: so_cum_acct Description: Cumulative quantity accounting sales order identifier. ** Field Name: so_merge_rss Description: Identifier for merging existing required ship schedule requiremen ts. ** Field Name: so_ship_cmplt Description: The percentage shipped before a requirement is considered complet e. Val-Msg: Value must be between 0 and 100. Val-Exp: so_ship_cmplt >= 0 and so_ship_cmplt <= 100 ** Field Name: so_bump_all Description: Dynamic unpegging of requirements for newly pegged requirements. ** Field Name: so_primary Description: Indicates whether this SO is Primary or not. ** Field Name: so_cust_po Description: Customer PO number from primary SO. ** Field Name: so_secondary Description: Indicates whether a sales order is a BTB order at a SBU ** Field Name: so_ship_po Description: The PO to be referenced during shipping ** Field Name: so_ex_rate2 Description: Number of base currency units related to transaction currency units. ** Field Name: so_ex_ratetype Description: Exchange rate type. ** Field Name: so_div Description: The APM division. ** Field Name: so_exru_seq Description: Sequence number of exchange rate usage. ** Field Name: so_app_owner Description: Identifies the external application that created and will maintain information about the sales order, and that will be informed of MFG/PRO order fulfillment activity. ** Field Name: so_ar_sub Description: The general ledger accounts receivable sub-account for this order. Val-Msg: ERROR: USER DOES NOT HAVE ACCESS TO THIS FIELD. Please re-enter. Val-Exp: {gppswd.v &field = "so_ar_sub"} ** Field Name: so_seq_order Description: Flag used to indicate if the order will be referenced on customer sequence schedules. ** Field Name: so_inc_in_rss Description: Flag used to determine if sequence schedules are to be included in the Required Ship Schedule Update routine. ** Field Name: so_firm_seq_days Description: The number of days of the sequence schedule to be used for planning. A value of 0 (default) indicates the entire schedule is used as the horizon. ** Field Name: so_prep_tax Description: The amount of tax that was prepaid Val-Msg: ERROR: USER DOES NOT HAVE ACCESS TO THIS FIELD. Please re-enter Val-Exp: {gppswd.v &field = "so_prep_tax"} ** Field Name: so__qadl04 Description: QAD reserved field. ** Field Name: so_custref_val Description: Yes indicates that Customer Ref must always contain a valid customer item. If No, it can contain anything. ** Field Name: so_consignment Description: Indicates that the Sales contract is for consigned mateial. The value is defaulted to the Sales Order Line. ** Field Name: so_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. The value is defaulted to the Sales Order Line. ** Field Name: so_consign_loc Description: The location used to represent consigned inventory at the customer's facility. The value is defaulted to the Sales Order Line. ** Field Name: so_intrans_loc Description: The location used to represent consigned material in-transit. the value is defaulted to the Sales Order Line. ** Field Name: so_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: so_revenue Description: Service contract revenue type, such as cash, accrued, deferred ** Field Name: so_fsaccr_acct Description: Service contract accrued revenue account ** Field Name: so_fsaccr_sub Description: Service contract accrued revenue sub-account ** Field Name: so_fsaccr_cc Description: Service contract accrued revenue cost center ** Field Name: so_fsdef_acct Description: Service contract deferred revenue account ** Field Name: so_fsdef_sub Description: Service contract deferred revenue sub-account ** Field Name: so_fsdef_cc Description: Service contract deferred revenue cost center ** Field Name: so_manual_fr_terms Description: Indicates whether Freight Terms has been manually updated. ** Field Name: so_domain Description: The business domain for this data. ** Field Name: oid_so_mstr Description: Unique application generated record identifier. ** Field Name: so_rss_cal_option Description: Controls which calendars are used to adjust dates on a Required Ship Schedule. ** Field Name: so_trade_sale Description: Indicates whether this is a Trade Sale Contract. ** Field Name: so_daybookset Description: The daybook set assigned to the order that is used to generate the invoice number. Val-Msg: ERROR: USER DOES NOT HAVE ACCESS TO THIS FIELD. Please re-enter. Val-Exp: {gppswd.v &field = "so_daybookset"} ** Field Name: so_reviewed Description: Flag indicating if the sales order has been credit reviewed. ** Field Name: so_req_time Description: The required time for the order. Val-Msg: ERROR: TIME MUST BE HH:MM FORMAT. Please re-enter. Val-Exp: {fstime.v so_req_time} ** Field Name: so_nrm Description: The NRM Sequence used for numbering this Sales Order ** Field Name: so_compl_stat Description: Order Line Complete Status (ex. Invoiced, Cancelled) ** Field Name: so_compl_date Description: The date the current Complete status was set ** Field Name: so_hold_stat Description: Order Line Hold Status (ex. Credit, Drawing) ** Field Name: so_promise_date Description: Date promised to customer to receive goods at their location. ** Field Name: so_per_date Description: The date which will be used to evaluate performance. ** Field Name: so_tax_in Description: A flag indicating whether the price includes tax. ** Field Name: so_consume Description: Flag indicating if this order should reduce net sales forecast. ** Field Name: so_reprice Description: Flag that controls if existing line(s) on this order will be repriced and if the pricing fields are editable. The setting in the header defaults to the line items and can be changed. ** Field Name: so_calc_fr Description: Flag indicating if freight should be calculated on this order.