What are the advantages or disadvantages of either as the back end?
Thanks!
Thanks!
Alpha Software Mobile Development Tools: Alpha Anywhere | Alpha TransForm |
TABLES ------------------------ Structure: Index Name -- Sort Order -- Filter -- Options AGENTS -- e:\a5v7\trak-it_sp\app\ Indexes: Agent_Nam_ -- AGENT_NAMF -- -- Agent_Nof -- AGENT_NOF -- -- U Agent_No_ -- AGENT_NOF -- -- Agnt_Phon_ -- AGENT_NAMF+BILL_PHONF -- -- Bill_Phon_ -- BILL_PHONF -- -- Client_No_ -- CLIENT_NOF -- -- P_S_Phon_ -- P_S_PHONF -- -- BROKERS -- e:\a5v7\trak-it_sp\app\ Indexes: Broker_Nof -- BROKER_NOF -- -- U Broker_No_ -- BROKER_NOF -- -- CITIES -- e:\a5v7\trak-it_sp\app\ Indexes: City_Name_ -- CITY_NAMEF -- -- CLIENT_MEMO -- e:\a5v7\trak-it_sp\app\ Indexes: Client_No_ -- CLIENT_NOF -- -- CLIENTS -- e:\a5v7\trak-it_sp\app\ Indexes: Client_Dcf -- CLIENT_NOF -- DISCONTF=.F. -- Client_Nof -- CLIENT_NOF -- -- U Client_No_ -- CLIENT_NOF -- -- Phone_ -- PHONEF -- -- Realtorf -- REALTORF -- DISCONTF=.F. -- Realtor_ -- REALTORF -- -- Sign_Phon_ -- DEF_SN_PHF -- -- Stld_Ffff6b25 -- BROKER_NOF -- -- INSTALLERS -- e:\a5v7\trak-it_sp\app\ Indexes: Inst_Name_ -- NAMEF -- -- Namef -- NAMEF -- ACTIVEF -- INV_HEAD -- e:\a5v7\trak-it_sp\app\ Indexes: Bill_Phon_ -- BILL_PHONF -- -- Client_No_ -- CLIENT_NOF -- -- Inv_Cldt_ -- CLIENT_NOF+INVERT(CDATE(INV_DATEF)+INV_NUMBF) -- -- Inv_Date_ -- INV_DATEF -- -- Inv_Dtph_ -- CDATE(INV_DATEF)+BILL_PHONF -- -- Inv_Numbf -- INV_NUMBF -- -- U Inv_Numb_ -- INV_NUMBF -- -- Inv_Phdt_ -- BILL_PHONF+INVERT(CDATE(INV_DATEF)) -- -- Nvrt_Clnu_ -- CLIENT_NOF+INVERT(INV_NUMBF) -- -- INV_NEW_LIST -- e:\a5v7\trak-it_sp\app\ Indexes: Bill_Phone -- BILL_PHONF -- -- Client_Nof -- CLIENT_NOF -- -- INV_PAY -- e:\a5v7\trak-it_sp\app\ Indexes: Client_No_ -- CLIENT_NOF -- -- Clnt_Date_ -- CLIENT_NOF+CDATE(DATE_PAIDF) -- -- Inv_Numbf -- INV_NUMBF -- -- U Inv_Numb_ -- INV_NUMBF -- -- Paymt_Nof -- PAYMT_NOF -- -- U INVOICE_DETAIL -- e:\a5v7\trak-it_sp\app\ Indexes: Client_Nof -- CLIENT_NOF+WORK_ORDF -- INV_NUMBF=\"\" -- Client_Nof1 -- CLIENT_NOF+WORK_ORDF -- LEFT(CHARGESF,6)=\"Refund\" .AND. INV_NUMBF=\"\" -- Client_No_ -- CLIENT_NOF -- -- Clnt_Rev_ -- CLIENT_NOF + INVERT(CDATE(COMP_DATEF)) -- -- Clt_Noinv_ -- CLIENT_NOF -- INV_NUMBF=\"\" -- Comp_Date_ -- COMP_DATEF -- -- Inv_Numb_ -- INV_NUMBF -- -- Master_No_ -- MASTER_NOF -- -- Stld_Ffff2 -- INV_NUMBF+WORK_ORDF -- -- Work_Ord_ -- WORK_ORDF -- -- ORD_HEAD -- e:\a5v7\trak-it_sp\app\ Indexes: Agnt_Name_ -- AGNT_NAMEF -- -- Bill_Ph_ -- PHON_BILLF -- -- Client_No_ -- CLIENT_NOF -- -- Master_No_ -- MASTER_NOF -- -- Prop_Addr_ -- PROP_ADDRF -- -- Rltr_Name_ -- REALTORF -- -- Sign_Ph_ -- PHON_SIGNF -- -- ORD_HEAD_MEMO -- e:\a5v7\trak-it_sp\app\ Indexes: Master_No_ -- MASTER_NOF -- -- ORD_HEAD_UP_ORDS -- e:\a5v7\trak-it_sp\app\ Indexes: Agnt_Namef -- AGNT_NAMEF -- -- Client_Nof -- CLIENT_NOF -- -- Master_Nof -- MASTER_NOF -- -- Phon_Billf -- PHON_BILLF -- -- Phon_Signf -- PHON_SIGNF -- -- Prop_Addrf -- PROP_ADDRF -- -- Realtorf -- REALTORF -- -- Up_Qtyf -- UP_QTYF -- -- ORD_ITEM -- e:\a5v7\trak-it_sp\app\ Indexes: Comp_On_ -- COMP_ONF -- -- Master_No_ -- MASTER_NOF -- -- Mast_Date_ -- MASTER_NOF+CDATE(WO_DATEF) -- -- Prt_Dtrev_ -- INVERT(CDATE(PRINT_DTF)) -- -- U Req_Date_ -- RQST_DATEF -- -- Work_Ord_ -- WORK_ORDF -- -- Wo_Date_ -- WO_DATEF -- -- ORD_ITEM_MEMO -- e:\a5v7\trak-it_sp\app\ Indexes: Work_Ordf -- WORK_ORDF -- -- OTHER_CHARGES -- e:\a5v7\trak-it_sp\app\ Indexes: Work_Ord_ -- WORK_ORDF -- -- PAST_DUE_REPORTS -- e:\a5v7\trak-it_sp\app\ Indexes: Client_No_ -- CLIENT_NOF -- -- Phone_ -- PHONEF -- -- Realtor_ -- REALTORF -- -- POST_ARM_LIST -- e:\a5v7\trak-it_sp\app\ Indexes: Descript_ -- DESCRIPTF -- -- POST_COLOR_LIST -- e:\a5v7\trak-it_sp\app\ Indexes: Descript_ -- DESCRIPTF -- -- POST_RENT_WARNINGS -- e:\a5v7\trak-it_sp\app\ Indexes: Client_No_ -- CLIENT_NOF -- -- POST_TYPE_LIST -- e:\a5v7\trak-it_sp\app\ Indexes: Descript_ -- DESCRIPTF -- -- PRICES_ORD_TYPE -- e:\a5v7\trak-it_sp\app\ Indexes: Price_Codef -- PRIC_CODEF -- -- U Pric_Desc_ -- PRIC_DESCF -- -- PRICES_OTHER -- e:\a5v7\trak-it_sp\app\ Indexes: Price_Codef -- PRIC_CODEF -- -- U Pric_Desc_ -- PRIC_DESCF -- -- REPLACE_LIST -- e:\a5v7\trak-it_sp\app\ Indexes: Descript_ -- DESCRIPTF -- -- RIDERS_AGENT -- e:\a5v7\trak-it_sp\app\ Indexes: Riders_ -- RIDERSF -- -- RIDERS_STCK -- e:\a5v7\trak-it_sp\app\ Indexes: Riders_ -- RIDERSF -- -- SIGNTYPE -- e:\a5v7\trak-it_sp\app\ Indexes: Sign_Type_ -- SIGN_TYPEF -- -- SUB_CONTRACTORS -- e:\a5v7\trak-it_sp\app\ Indexes: Contractr_ -- SUB_NAMEF -- -- Sub_Numbf -- SUB_NUMBF -- -- U TRAK_IT_CONFIRMATION_OUTBOX -- e:\a5v7\trak-it_sp\app\ Indexes: Date_ -- RECEIVE_DATE -- -- TRAK_IT_GENERAL_OUTBOX -- e:\a5v7\trak-it_sp\app\ Indexes: Date_ -- RECEIVE_DATE -- -- Folder -- FOLDER -- -- Msg_Id -- MSG_ID -- -- UNIT_TYPE -- e:\a5v7\trak-it_sp\app\ Indexes: Unit_Typef -- UNIT_TYPEF -- -- ZIPCODE -- e:\a5v7\trak-it_sp\app\ Indexes: Zip_ -- ZIPF -- --
Comment