Source language: Translate to:

Two grid with diferent info linked.

Questions about our Advanced Database plug-in

Moderator: Neosoft Support

Two grid with diferent info linked.

Postby RigmaishRaict » Thu Jul 12, 2012 12:40 pm

Hi
I am new in NeoBook and NeoBookDBPro. I have an mssql database and there is a table with clients and a second table with invoices.

Now, I have made one grid showing the clients and one second grid showing the invoices.

How can I link these two grids so that when I select a client from the first grid the second grid will show the invoices of that client?

Can I have an example?

Thank you.
RigmaishRaict
 
Posts: 7
Joined: Tue Oct 23, 2012 4:39 pm

Postby Leos » Fri Jul 13, 2012 6:08 am

Hi, and welcome to the forum

You have many ways:

1. with this command:

dbpDefineRelationship "DATABASE" "Clientes" "AutoId" "Produtos" "AutoId" ""

in the help of the command you can learn more.

2.
When you use

dbpOpenTable "Table" "QProdutos" "Subroutine"

You can define a Subroutine to do what you want

Best regards
User avatar
Leos
 
Posts: 178
Joined: Mon Apr 04, 2005 11:13 am
Location: Coimbra, Portugal

Postby RigmaishRaict » Fri Jul 13, 2012 12:38 pm

Thanks for the quick reply.

I try the fist way using the dbpDefineRelationship command.

But when I run the app and make a klick on the first - master grid I get a error message saying invalid column name 'a value here' and nathing else hapens.

The link is made with the right fields
RigmaishRaict
 
Posts: 7
Joined: Tue Oct 23, 2012 4:39 pm

Postby RigmaishRaict » Mon Jul 16, 2012 1:31 am

Any sugestion ???
RigmaishRaict
 
Posts: 7
Joined: Tue Oct 23, 2012 4:39 pm

Postby Leos » Mon Jul 16, 2012 4:52 am

Can you send me aq copy of your database?

It seems that you do the relashionships with the wrong fields
User avatar
Leos
 
Posts: 178
Joined: Mon Apr 04, 2005 11:13 am
Location: Coimbra, Portugal

Postby Gaev » Mon Jul 16, 2012 4:59 am

makis_best:

In general, if you need someone to assist you, you need to provide them with as much details of your application as possible.

In this case, start by posting ...

1) the results of dbpGetFieldDefs ... for both your Tables

2) the exact syntax of the dbpDefineRelationship command

3) the exact error message you get ... when you say "... invalid column name 'a value here' and nathing else hapens" ... what is 'a value here' ?
User avatar
Gaev
 
Posts: 3734
Joined: Fri Apr 01, 2005 7:48 am
Location: Toronto, Canada

Postby RigmaishRaict » Tue Jul 17, 2012 1:03 am

Hi.

My database is almost 16GB big.

The first table Client has a field with name pid - varchar(25) and other fields.
The second table invoices has a field with name pid - varchar(25) and other fields.
I create two grids one with the clients and one with the invoices.
Both of the grids show the info correct.

Then I use the command

dbpDefineRelationship "jordansa" "Client" "pid" "invoices" "pid" ""

to link these two grids, but when I run the app and make a click on a row or a field in the client grid,
I get an error saying invalid column name '000001' and nothing happens.
The 000001 is the value of the pid of the client grid.

If i make a click on another row (client) with pid 000125 the error message will be
invalid column name '000125' and nothing will happen.

But it's wrong because the column name is pid not '000125' or '000001'

Image

Thank you
RigmaishRaict
 
Posts: 7
Joined: Tue Oct 23, 2012 4:39 pm

Postby Gaev » Tue Jul 17, 2012 6:30 am

makis_best:

Please provide the EXACT text of the result of running dbpGetFieldDefs ... for both your Tables.

It looks like it does not think that the column name is valid ... so you might also provide the result of doing dbpGetTableNames ... so we can see that the Table names (Client and invoices) are correct ... singular/plural and same case.

Also, it might be getting confused with the field name of pid ... I googled it ... and found that SQL Server considers it to be the ProcessID.

Finally, try the same with a (much smaller) copy of the Database ... not sure how the 16 GB might be affecting things.

If all else fails, consider Leos's second suggested method ... i.e. use the subroutine (specified in the dbpOpenTable command for the Client Table) to show a filtered list of invoices records in the second grid (using dbpQuery).
User avatar
Gaev
 
Posts: 3734
Joined: Fri Apr 01, 2005 7:48 am
Location: Toronto, Canada

Postby RigmaishRaict » Wed Jul 18, 2012 12:56 am

The names I use are examples.
The real names of the fields are PersonID and the table name for the clients is Client and for the invoices is DocHdSal

dbpGetFieldDefs for the Client table:

Iosif_test.$Status=Connected
Iosif_test.Client.$State=Browse
Iosif_test.Client.PersonID=ÁÈ/18/031
Iosif_test.Client.Name=ÐÅÍÔÅ Á.Å.
Iosif_test.Client.CmpTypeID=060
Iosif_test.Client.Address1=ËÅÍÏÑÌÁÍ 129
Iosif_test.Client.Address2=ÊÏËÙÍÏÓ
Iosif_test.Client.City=ÁÈÇÍÁ
Iosif_test.Client.CntrID=ÅËËÁÄÁ
Iosif_test.Client.ZipCode=104 42
Iosif_test.Client.Telephone1=210 5147028
Iosif_test.Client.Telephone2=210 5144214-ëïãéóôçñ
Iosif_test.Client.Telex=210 5143610 ÌÁÑÁÃÊÏÕ
Iosif_test.Client.Fax=210 5146123
Iosif_test.Client.Place=01
Iosif_test.Client.DoyID=1118
Iosif_test.Client.AFM=094116278
Iosif_test.Client.ACode=30.00.18031
Iosif_test.Client.TaxCat=0
Iosif_test.Client.DebOpenVal=5486,5
Iosif_test.Client.OtherDeb=0
Iosif_test.Client.CreOpenVal=0
Iosif_test.Client.OtherCred=301,06
Iosif_test.Client.SalesPurch=42882,74
Iosif_test.Client.CancSalPurc=226,11
Iosif_test.Client.RecPaym=43000
Iosif_test.Client.CancRecPay=0
Iosif_test.Client.Turnover=34680,67
Iosif_test.Client.OpenNotes=0
Iosif_test.Client.OpenCheques=15000
Iosif_test.Client.InKEPYO=1
Iosif_test.Client.NeedForm=1
Iosif_test.Client.Zoom1=05
Iosif_test.Client.Zoom2=1
Iosif_test.Client.Zoom3=1
Iosif_test.Client.Zoom5=180
Iosif_test.Client.Value1=17768,7276
Iosif_test.Client.Value2=0
Iosif_test.Client.Value3=0
Iosif_test.Client.Value4=0
Iosif_test.Client.Value5=0
Iosif_test.Client.Value6=0
Iosif_test.Client.Value7=0
Iosif_test.Client.Value8=0
Iosif_test.Client.Value9=0
Iosif_test.Client.Value10=0
Iosif_test.Client.PersType=2
Iosif_test.Client.CurrIDP=ÅUR
Iosif_test.Client.DebOpValueP=5486,5
Iosif_test.Client.OtherDebP=0
Iosif_test.Client.CredOpValP=0
Iosif_test.Client.OtherCredP=301,06
Iosif_test.Client.SalesPurchP=42882,74
Iosif_test.Client.CancSalPurP=226,11
Iosif_test.Client.RecPaymP=43000
Iosif_test.Client.CancRecPayP=0
Iosif_test.Client.TurnoverP=34680,67
Iosif_test.Client.Telephone3=210 5149658
Iosif_test.Client.Telephone4=êá Ìáñáãêïõ -ëïãéóôç
Iosif_test.Client.TrdPersStat=0
Iosif_test.Client.OpNoteLimit=0
Iosif_test.Client.Related=1
Iosif_test.Client.Category=1
Iosif_test.Client.RecCrD=12/02/2007 11:20:25 ðì
Iosif_test.Client.RecCrU=USÅR4
Iosif_test.Client.RecModD=24/05/2012 10:27:06 ðì
Iosif_test.Client.RecModU=USÅR7
Iosif_test.Client.CretitLimit=19389,6585
Iosif_test.Client.WareHouseAA=1
Iosif_test.Client.Discount=0
Iosif_test.Client.DelMethID=01
Iosif_test.Client.IntMemo=93CC726D-D6BA-DB11-95C7-00104BAF7CC3
Iosif_test.Client.PriceListAA=17
Iosif_test.Client.GroupDocs=0
Iosif_test.Client.SalesmanAA=14
Iosif_test.Client.LegalType=Á.Å.
Iosif_test.Client.NotIssueLim=0
Iosif_test.Client.IssuedLim=0
Iosif_test.Client.RecPrivg=0
Iosif_test.Client.ComisionPer=0
Iosif_test.Client.CharID=99
Iosif_test.Client.CategID=04
Iosif_test.Client.CheckPlafon=0
Iosif_test.Client.IntForecasP=0
Iosif_test.Client.IntForecast=0
Iosif_test.Client.Group1=0
Iosif_test.Client.Flag1=0
Iosif_test.Client.Flag2=0
Iosif_test.Client.Flag3=0
Iosif_test.Client.RecPerCent=3
Iosif_test.Client.Flag4=0
Iosif_test.Client.Flag5=0
Iosif_test.Client.Flag6=0
Iosif_test.Client.Flag7=0
Iosif_test.Client.Flag8=0
Iosif_test.Client.OpenDbNotes=0
Iosif_test.Client.OpenDbCheq=0
Iosif_test.Client.Guarantees=0
Iosif_test.Client.GuaranteesP=0
Iosif_test.Client.PropertyTp=0
Iosif_test.Client.TrnOvGrpID=10000+
Iosif_test.Client.GothCrDocs=0
Iosif_test.Client.KEPYOType=0
Iosif_test.Client.UpdatesRetail=0
Iosif_test.Client.DiscDocTurnOver=1
Iosif_test.Client.UpdatesWebShop=0
Iosif_test.Client.UpdatesESales=0
Iosif_test.Client.DelivPurp=ÐÙËÇÓÇ
Iosif_test.Client.DelivPlace=ÅÄÑÁ ÌÁÓ
Iosif_test.Client.TaxCat_1=0
Iosif_test.Client.NetValue=41,11
Iosif_test.Client.VATValue=9,46
Iosif_test.Client.Address1_1=ËÅÍÏÑÌÁÍ 129
Iosif_test.Client.Address2_1=ÊÏËÙÍÏÓ
Iosif_test.Client.ZipCode_1=104 42
Iosif_test.Client.City_1=ÁÈÇÍÁ
Iosif_test.Client.PlaceID=01
Iosif_test.Client.CountryID=ÅËËÁÄÁ
Iosif_test.Client.Telephone=210 5147028
Iosif_test.Client.AddrName=ÊÁÔ/ÌÁ ËÁÌÉÁÓ Í° 1
Iosif_test.Client.DelAddress1=1° ÷ëì ËÁÌÉÁÓ ÊÁÑÐÅÍÇÓÉÏÕ
Iosif_test.Client.DelAddress2=ÑÅÂÅÍÉÁ
Iosif_test.Client.DelZipCode=351 00
Iosif_test.Client.DelCity=ËÁÌÉÁ
Iosif_test.Client.DelPlaceID=01
Iosif_test.Client.DelCntrID=ÅËËÁÄÁ
Iosif_test.Client.DelTel=210 5147028
Iosif_test.Client.Zoom1_1=106
Iosif_test.Client.Zoom2_1=28
Iosif_test.Client.Value1_1=0
Iosif_test.Client.Value2_1=0
Iosif_test.Client.Value3_1=0
Iosif_test.Client.Value4_1=0
Iosif_test.Client.Value5_1=0
Iosif_test.Client.Quantity=14
Iosif_test.Client.OpenQnt=14
Iosif_test.Client.Zoom6_1=01
Iosif_test.Client.NetValueP=41,11
Iosif_test.Client.CurrIDS=ÅUR
Iosif_test.Client.CurrRateS=1
Iosif_test.Client.NetValueS=41,11
Iosif_test.Client.LtgCurrID=0
Iosif_test.Client.PersonID_1=ÁÈ/18/031
Iosif_test.Client.CurrIDP_1=ÅUR
Iosif_test.Client.CurrRateP=1
Iosif_test.Client.AA=309745
Iosif_test.Client.ID=ÔÉÌ000180931
Iosif_test.Client.SeriesCode=ÔÉÌ0
Iosif_test.Client.Type1=0
Iosif_test.Client.InsDate=01/07/2010
Iosif_test.Client.Date1_1=01/07/2010
Iosif_test.Client.ExpDate=01/07/2010
Iosif_test.Client.SpecComm1=ÐÅÍÔÅ Á.Å.
Iosif_test.Client.AltDocDate=01/07/2010
Iosif_test.Client.FlagAcc=1
Iosif_test.Client.FlagPrint=1
Iosif_test.Client.Category_1=0
Iosif_test.Client.TotalValue=50,57
Iosif_test.Client.ParamsCode=ÅÎÁ.Ð&Á
Iosif_test.Client.Temp1=0
Iosif_test.Client.FlagAppl=1
Iosif_test.Client.DocCounter=63
Iosif_test.Client.FlagTrans=0
Iosif_test.Client.RecCrD_1=01/07/2010 12:11:48 ìì
Iosif_test.Client.RecCrU_1=USÅR9
Iosif_test.Client.RecModD_1=21/07/2010 10:44:49 ðì
Iosif_test.Client.RecModU_1=USÅR7
Iosif_test.Client.DelivDate=01/07/2010
Iosif_test.Client.DelMethID_1=05
Iosif_test.Client.DiscPerc=0
Iosif_test.Client.WareHouseAA_1=1
Iosif_test.Client.TransCtgr=0
Iosif_test.Client.LocalChrg=0
Iosif_test.Client.AlterQnt=0
Iosif_test.Client.PriceListAA_1=17
Iosif_test.Client.DeducVal1=0
Iosif_test.Client.DeducVal2=0
Iosif_test.Client.DeducVal3=0
Iosif_test.Client.SChargeVal1=0
Iosif_test.Client.SChargeVal2=0
Iosif_test.Client.SChargeVal3=0
Iosif_test.Client.ValCorrect=0
Iosif_test.Client.IsLocked=0
Iosif_test.Client.SalesmanAA_1=14
Iosif_test.Client.TotalValueP=50,57
Iosif_test.Client.VatValueP=9,46
Iosif_test.Client.TotalValueS=50,57
Iosif_test.Client.VatValueS=9,46
Iosif_test.Client.Retail=0
Iosif_test.Client.InKEPYO_1=1
Iosif_test.Client.RecPrivg_1=0
Iosif_test.Client.ExtraTaxP=0
Iosif_test.Client.ExtraTaxS=0
Iosif_test.Client.ExtraTax=0
Iosif_test.Client.CashDiscP=0
Iosif_test.Client.CashDiscS=0
Iosif_test.Client.CashDisc=0
Iosif_test.Client.SChargVal1P=0
Iosif_test.Client.SChargVal3S=0
Iosif_test.Client.SChargVal2S=0
Iosif_test.Client.SChargVal1S=0
Iosif_test.Client.DeducVal3P=0
Iosif_test.Client.DeducVal2P=0
Iosif_test.Client.DeducVal1P=0
Iosif_test.Client.DeducVal3S=0
Iosif_test.Client.DeducVal2S=0
Iosif_test.Client.DeducVal1S=0
Iosif_test.Client.SChargVal3P=0
Iosif_test.Client.SChargVal2P=0
Iosif_test.Client.SalPurType=2
Iosif_test.Client.GenCorrect=0
Iosif_test.Client.DelPersonID=ÁÈ/18/031
Iosif_test.Client.DelPersType=0
Iosif_test.Client.Flag1_1=0
Iosif_test.Client.Flag2_1=0
Iosif_test.Client.Flag3_1=0
Iosif_test.Client.ActvDiscPol=0
Iosif_test.Client.InRetailArt=0
Iosif_test.Client.ActvPrm=0
Iosif_test.Client.CorDocCat=2
Iosif_test.Client.PropertyTp_1=0
Iosif_test.Client.Value10_1=0
Iosif_test.Client.Value6_1=0
Iosif_test.Client.Value7_1=0
Iosif_test.Client.Value8_1=0
Iosif_test.Client.Value9_1=0
Iosif_test.Client.RetailSystem=0
Iosif_test.Client.ExtraTaxVat=0
Iosif_test.Client.ExtraTaxVatS=0
Iosif_test.Client.ExtraTaxVatP=0
Iosif_test.Client.OilDoc=0
Iosif_test.Client.OilRec=0
Iosif_test.Client.TotalAdvValue=0
Iosif_test.Client.TotalAdvValueP=0
Iosif_test.Client.TotalAdvValueS=0
Iosif_test.Client.$RecNum=1
Iosif_test.Client.$RecCount=1000
Iosif_test.dochdsal.$State=Browse
Iosif_test.dochdsal.DelivPurp=ÐÙËÇÓÇ
Iosif_test.dochdsal.DelivPlace=ÅÄÑÁ ÌÁÓ
Iosif_test.dochdsal.TaxCat=0
Iosif_test.dochdsal.NetValue=217,17
Iosif_test.dochdsal.VATValue=49,95
Iosif_test.dochdsal.Address1=ÃÁËÁÔÉÍÇ
Iosif_test.dochdsal.ZipCode=503 00
Iosif_test.dochdsal.City=ÃÁËÁÔÉÍÇ-ÊÏÆÁÍÇÓ
Iosif_test.dochdsal.PlaceID=07
Iosif_test.dochdsal.CountryID=ÅËËÁÄÁ
Iosif_test.dochdsal.Telephone=2465-041643
Iosif_test.dochdsal.AddrName=ÃÁËÁÔÉÍÇ
Iosif_test.dochdsal.DelAddress1=ÃÁËÁÔÉÍÇ
Iosif_test.dochdsal.DelZipCode=503 00
Iosif_test.dochdsal.DelCity=ÃÁËÁÔÉÍÇ-ÊÏÆÁÍÇÓ
Iosif_test.dochdsal.DelPlaceID=07
Iosif_test.dochdsal.DelCntrID=ÅËËÁÄÁ
Iosif_test.dochdsal.DelTel=2465-041643
Iosif_test.dochdsal.PayAgrmtID=ÅÐÉ ÐÉÓÔÙÓÅÉ
Iosif_test.dochdsal.Zoom1=106
Iosif_test.dochdsal.Zoom2=04
Iosif_test.dochdsal.Value1=0
Iosif_test.dochdsal.Value2=0
Iosif_test.dochdsal.Value3=0
Iosif_test.dochdsal.Value4=0
Iosif_test.dochdsal.Value5=0
Iosif_test.dochdsal.Quantity=2
Iosif_test.dochdsal.OpenQnt=2
Iosif_test.dochdsal.Zoom6=01
Iosif_test.dochdsal.NetValueP=217,17
Iosif_test.dochdsal.CurrIDS=ÅUR
Iosif_test.dochdsal.CurrRateS=1
Iosif_test.dochdsal.NetValueS=217,17
Iosif_test.dochdsal.LtgCurrID=0
Iosif_test.dochdsal.PersonID=ÄÌ/01/019
Iosif_test.dochdsal.CurrIDP=ÅUR
Iosif_test.dochdsal.CurrRateP=1
Iosif_test.dochdsal.AA=309701
Iosif_test.dochdsal.ID=ÔÉÌ000180916
Iosif_test.dochdsal.SeriesCode=ÔÉÌ0
Iosif_test.dochdsal.Type1=0
Iosif_test.dochdsal.InsDate=01/07/2010
Iosif_test.dochdsal.Date1=01/07/2010
Iosif_test.dochdsal.ExpDate=01/07/2010
Iosif_test.dochdsal.SpecComm1=ÔÓÏÊÁÓ Ä. ÌÉ×ÁÇË
Iosif_test.dochdsal.AltDocDate=01/07/2010
Iosif_test.dochdsal.FlagAcc=1
Iosif_test.dochdsal.FlagPrint=1
Iosif_test.dochdsal.Category=0
Iosif_test.dochdsal.TotalValue=267,12
Iosif_test.dochdsal.ParamsCode=ÅÎÁ.Ð&Á
Iosif_test.dochdsal.Temp1=0
Iosif_test.dochdsal.FlagAppl=1
Iosif_test.dochdsal.DocCounter=63
Iosif_test.dochdsal.FlagTrans=0
Iosif_test.dochdsal.RecCrD=01/07/2010 11:26:06 ðì
Iosif_test.dochdsal.RecCrU=USÅR9
Iosif_test.dochdsal.RecModD=21/07/2010 12:32:19 ìì
Iosif_test.dochdsal.RecModU=USÅR7
Iosif_test.dochdsal.DelivDate=01/07/2010
Iosif_test.dochdsal.DelMethID=07
Iosif_test.dochdsal.TrsportID=291
Iosif_test.dochdsal.DiscPerc=0
Iosif_test.dochdsal.WareHouseAA=1
Iosif_test.dochdsal.TransCtgr=0
Iosif_test.dochdsal.LocalChrg=0
Iosif_test.dochdsal.AlterQnt=0
Iosif_test.dochdsal.DeducVal1=0
Iosif_test.dochdsal.DeducVal2=0
Iosif_test.dochdsal.DeducVal3=0
Iosif_test.dochdsal.SChargeVal1=0
Iosif_test.dochdsal.SChargeVal2=0
Iosif_test.dochdsal.SChargeVal3=0
Iosif_test.dochdsal.ValCorrect=0
Iosif_test.dochdsal.IsLocked=0
Iosif_test.dochdsal.SalesmanAA=25
Iosif_test.dochdsal.TotalValueP=267,12
Iosif_test.dochdsal.VatValueP=49,95
Iosif_test.dochdsal.TotalValueS=267,12
Iosif_test.dochdsal.VatValueS=49,95
Iosif_test.dochdsal.Retail=0
Iosif_test.dochdsal.InKEPYO=1
Iosif_test.dochdsal.RecPrivg=0
Iosif_test.dochdsal.ExtraTaxP=0
Iosif_test.dochdsal.ExtraTaxS=0
Iosif_test.dochdsal.ExtraTax=0
Iosif_test.dochdsal.CashDiscP=0
Iosif_test.dochdsal.CashDiscS=0
Iosif_test.dochdsal.CashDisc=0
Iosif_test.dochdsal.SChargVal1P=0
Iosif_test.dochdsal.SChargVal3S=0
Iosif_test.dochdsal.SChargVal2S=0
Iosif_test.dochdsal.SChargVal1S=0
Iosif_test.dochdsal.DeducVal3P=0
Iosif_test.dochdsal.DeducVal2P=0
Iosif_test.dochdsal.DeducVal1P=0
Iosif_test.dochdsal.DeducVal3S=0
Iosif_test.dochdsal.DeducVal2S=0
Iosif_test.dochdsal.DeducVal1S=0
Iosif_test.dochdsal.SChargVal3P=0
Iosif_test.dochdsal.SChargVal2P=0
Iosif_test.dochdsal.SalPurType=2
Iosif_test.dochdsal.GenCorrect=0
Iosif_test.dochdsal.DelPersonID=ÄÌ/01/019
Iosif_test.dochdsal.DelPersType=0
Iosif_test.dochdsal.Flag1=0
Iosif_test.dochdsal.Flag2=1
Iosif_test.dochdsal.Flag3=0
Iosif_test.dochdsal.ActvDiscPol=0
Iosif_test.dochdsal.InRetailArt=0
Iosif_test.dochdsal.ActvPrm=0
Iosif_test.dochdsal.CorDocCat=2
Iosif_test.dochdsal.PropertyTp=0
Iosif_test.dochdsal.Value10=0
Iosif_test.dochdsal.Value6=0
Iosif_test.dochdsal.Value7=0
Iosif_test.dochdsal.Value8=0
Iosif_test.dochdsal.Value9=0
Iosif_test.dochdsal.RetailSystem=0
Iosif_test.dochdsal.ExtraTaxVat=0
Iosif_test.dochdsal.ExtraTaxVatS=0
Iosif_test.dochdsal.ExtraTaxVatP=0
Iosif_test.dochdsal.OilDoc=0
Iosif_test.dochdsal.OilRec=0
Iosif_test.dochdsal.TotalAdvValue=0
Iosif_test.dochdsal.TotalAdvValueP=0
Iosif_test.dochdsal.TotalAdvValueS=0
Iosif_test.dochdsal.$RecNum=1
Iosif_test.dochdsal.$RecCount=1000
Iosif_test.LItmSale.$State=Browse
Iosif_test.LItmSale.$RecNum=1
Iosif_test.LItmSale.$RecCount=2
Iosif_test.LItmSale.Price=217,168
Iosif_test.LItmSale.NetValue=217,17
Iosif_test.LItmSale.VATValue=49,95
Iosif_test.LItmSale.TotalValue=267,12
Iosif_test.LItmSale.CurrIDP=ÅUR
Iosif_test.LItmSale.CurrRateP=1
Iosif_test.LItmSale.NetValueP=217,17
Iosif_test.LItmSale.CurrIDS=ÅUR
Iosif_test.LItmSale.CurrRateS=1
Iosif_test.LItmSale.NetValueS=217,17
Iosif_test.LItmSale.Quantity=1
Iosif_test.LItmSale.OpenQnt=1
Iosif_test.LItmSale.ActualQnt=1
Iosif_test.LItmSale.AA=3058753
Iosif_test.LItmSale.DocumentAA=309701
Iosif_test.LItmSale.LineNum=0
Iosif_test.LItmSale.LineType=1
Iosif_test.LItmSale.Cmmnt=ÐÁËÅÔÏÖÏÑÁ 2,5 tn ÁÈÏÑ.55cmX110cm
Iosif_test.LItmSale.LinkID=ÕÃ2404
Iosif_test.LItmSale.CharID=07
Iosif_test.LItmSale.CategID=29
Iosif_test.LItmSale.LinkIDNum=4209
Iosif_test.LItmSale.SalOrdPh=0
Iosif_test.LItmSale.StrgLocAA=4518
Iosif_test.LItmSale.MUnitAA=8724
Iosif_test.LItmSale.VATCtgr=0
Iosif_test.LItmSale.DiscVal=0
Iosif_test.LItmSale.DiscPrc=0
Iosif_test.LItmSale.DelivDate=02/07/2010
Iosif_test.LItmSale.Value1=0
Iosif_test.LItmSale.Value2=217,168
Iosif_test.LItmSale.String2=TEST
Iosif_test.LItmSale.AlterQnt=0
Iosif_test.LItmSale.MatPrprt=0
Iosif_test.LItmSale.FictValue=217,17
Iosif_test.LItmSale.TotalValueP=267,12
Iosif_test.LItmSale.VatValueP=49,95
Iosif_test.LItmSale.TotalValueS=267,12
Iosif_test.LItmSale.VatValueS=49,95
Iosif_test.LItmSale.Charge=0
Iosif_test.LItmSale.ExtraTaxP=0
Iosif_test.LItmSale.ExtraTaxS=0
Iosif_test.LItmSale.ExtraTax=0
Iosif_test.LItmSale.ComisionPer=0
Iosif_test.LItmSale.SalesmanAA=25
Iosif_test.LItmSale.ComisionVal=0
Iosif_test.LItmSale.SecDiscPrc=0
Iosif_test.LItmSale.ThrdDiscPrc=0
Iosif_test.LItmSale.SrtmntQnt=0
Iosif_test.LItmSale.Val3=0
Iosif_test.LItmSale.Val4=0
Iosif_test.LItmSale.Val5=0
Iosif_test.LItmSale.LineCharact=0
Iosif_test.LItmSale.Val6=0
Iosif_test.LItmSale.Val7=0
Iosif_test.LItmSale.Val8=0
Iosif_test.LItmSale.Val10=0
Iosif_test.LItmSale.Val9=0
Iosif_test.LItmSale.Val11=0
Iosif_test.LItmSale.Val12=0
Iosif_test.LItmSale.Val13=0
Iosif_test.LItmSale.ExtraTaxVat=0
Iosif_test.LItmSale.ExtraTaxVatS=0
Iosif_test.LItmSale.ExtraTaxVatP=0
Iosif_test.LItmSale.OilSubsidyVal=0
Iosif_test.LItmSale.OilRec=0
Iosif_test.LItmSale.MUDimQnt=0
Iosif_test.LItmSale.MUDim1Qnt=0
Iosif_test.LItmSale.MUDim2Qnt=0
Iosif_test.LItmSale.MUDim3Qnt=0
Iosif_test.LItmSale.ExtraTax2P=0
Iosif_test.LItmSale.ExtraTax2S=0
Iosif_test.LItmSale.ExtraTax2=0
Iosif_test.LItmSale.ExtraTax3P=0
Iosif_test.LItmSale.ExtraTax3S=0
Iosif_test.LItmSale.ExtraTax3=0
Iosif_test.LItmSale.ExtraTax2VatP=0
Iosif_test.LItmSale.ExtraTax2VatS=0
Iosif_test.LItmSale.ExtraTax2Vat=0
Iosif_test.LItmSale.ExtraTax3VatP=0
Iosif_test.LItmSale.ExtraTax3VatS=0
Iosif_test.LItmSale.ExtraTax3Vat=0
GetFielclien=IntRateGrID Char(13)|SalBdgtID Char(50)|PersonID Char(20) Required PrimaryKey|Name Char(80)|CompTitle Char(50)|Supervisor Char(50)|CmpTypeID Char(10)|Address1 Char(50)|Address2 Char(50)|City Char(30)|CntrID Char(10)|ZipCode Char(10)|Telephone1 Char(20)|Telephone2 Char(20)|Telex Char(20)|Fax Char(20)|AccSuperv Char(15)|Introducer Char(15)|Place Char(15)|DoyID Char(15)|Gen2 Char(10)|Gen3 Char(10)|AFM Char(15) Required|ACode Char(20)|AccCodeDoy Char(20)|DelivAddr1 Char(50)|DelivAddr2 Char(50)|City2 Char(30)|Place2 Char(15)|DelivTeleph Char(20)|Fax2 Char(20)|PostCode2 Char(10)|TaxCat Word Default=(0)|DebOpenVal Float Default=(0)|OtherDeb Float Default=(0)|CreOpenVal Float Default=(0)|OtherCred Float Default=(0)|SalesPurch Float Default=(0)|CancSalPurc Float Default=(0)|RecPaym Float Default=(0)|CancRecPay Float Default=(0)|Turnover Float Default=(0)|OpenNotes Float Default=(0)|OpenCheques Float Default=(0)|Cmmnt Char(80)|Memo Memo|InKEPYO Word Required Default=(1)|NeedForm Word Required Default=(1)|Zoom1 Char(10)|Zoom2 Char(10)|Zoom3 Char(17)|Zoom4 Char(10)|Zoom5 Char(10)|Zoom6 Char(10)|Zoom7 Char(10)|Zoom8 Char(10)|String1 Char(30)|String2 Char(30)|String3 Char(30)|String4 Char(30)|String5 Char(30)|Value1 Float Default=(0)|Value2 Float Default=(0)|Value3 Float Default=(0)|Value4 Float Default=(0)|Value5 Float Default=(0)|Value6 Float Default=(0)|Value7 Float Default=(0)|Value8 Float Default=(0)|Value9 Float Default=(0)|Value10 Float Default=(0)|Date1 DateTime|Date2 DateTime|Date3 DateTime|Date4 DateTime|Date5 DateTime|PersType Word Required Default=(0)|PayAgrmtID Char(13)|CurrIDP Char(10) Required|DebOpValueP Float Default=(0)|OtherDebP Float Default=(0)|CredOpValP Float Default=(0)|OtherCredP Float Default=(0)|SalesPurchP Float Default=(0)|CancSalPurP Float Default=(0)|RecPaymP Float Default=(0)|CancRecPayP Float Default=(0)|TurnoverP Float Default=(0)|Telephone3 Char(20)|Telephone4 Char(20)|TrdPersStat Word Required Default=(0)|TPPermMovAA Integer|OpNoteLimit Float Default=(0)|Related Word Required Default=(1)|Category Char(50)|RecCrD DateTime Default=(getdate())|RecCrU Char(15)|RecModD DateTime|RecModU Char(15)|CretitLimit Float Required Default=(0)|WareHouseAA Integer|TrsportID Char(10)|Discount Float Required Default=(0)|AlternCode Char(80)|DelMethID Char(10)|IntMemo Memo|PriceListAA Integer|DeductID Char(10)|SChargeID Char(10)|MemoDoc Char(80)|GroupDocs Word Required Default=(0)|AccModelID Char(13)|SalesmanAA Integer|GrOfDocsID Char(10)|CmpLocation Char(80)|LegalType Char(80)|CmpActivity Memo|CntrID2 Char(10)|RetailPrLAA Integer|NotIssueLim Float Default=(0)|IssuedLim Float Default=(0)|Email Char(80)|WebSite Char(80)|RecPrivg Integer Default=(0)|ComisionPer Float Required Default=(0)|CharID Char(10)|ArtDataGrp Char(10)|CategID Char(50)|ArtDataTyp Char(10)|ExchDifDate DateTime|CheckPlafon Word Required Default=(1)|IntForecasP Float Required Default=(0)|LastRunDate DateTime|IntForecast Float Required Default=(0)|CollectDate DateTime|Group1 Word Required Default=(0)|Flag1 Word Required Default=(0)|Flag2 Word Required Default=(0)|Flag3 Word Required Default=(0)|TrnOvAgrAA Integer|RelCode Char(10)|DiscGrpID Char(10)|RecPerCent Float Required Default=(0)|Zoom9 Char(10)|Zoom10 Char(10)|Zoom11 Char(10)|Zoom12 Char(10)|Zoom13 Char(10)|Zoom14 Char(10)|Zoom15 Char(10)|Zoom16 Char(10)|Zoom17 Char(10)|Zoom18 Char(10)|Flag4 Word Required Default=(0)|Flag5 Word Required Default=(0)|Flag6 Word Required Default=(0)|Flag7 Word Required Default=(0)|Flag8 Word Required Default=(0)|InvoiceMsg Char(80)|DocModelAA Integer|IDIssuer Char(80)|IDNumber Char(10)|IDIssueDate DateTime|OpenDbNotes Float Default=(0)|OpenDbCheq Float Default=(0)|PromGrpID Char(10)|Guarantees Float Required Default=(0)|GuaranteesP Float Required Default=(0)|PrsRelID Char(10)|DelNameID Char(30)|Relation Char(10)|PropertyTp Word Required Default=(0)|TrnOvGrpID Char(10)|GothCrDocs Word Required Default=(0)|KEPYOType Word Required Default=(0)|crmDate DateTime|RevNumber Integer Default=((0))|UpdatesRetail Word Required Default=((0))|DEHCode Char(20)|HFACode Char(20)|DiscDocTurnOver Word Required Default=((0))|ReferenceID Char(50)|UpdatesWebShop Word Required Default=((0))|UpdatesESales Word Required Default=((0))|ExtraTaxGroupID Char(50)|OrderFldrAA Integer|IntRateJAA Integer|DelivPurp Char(10)|DelivPlace Char(30)|TaxCat_1 Word|NetValue Float|VATValue Float|Address1_1 Char(50)|Address2_1 Char(50)|ZipCode_1 Char(10)|City_1 Char(30)|PlaceID Char(15)|CountryID Char(10)|Telephone Char(20)|AddrName Char(50)|DelAddress1 Char(50)|DelAddress2 Char(50)|DelZipCode Char(10)|DelCity Char(30)|DelPlaceID Char(15)|DelCntrID Char(10)|DelTel Char(20)|PayAgrmtID_1 Char(13)|Zoom1_1 Char(10)|Zoom2_1 Char(10)|Zoom3_1 Char(10)|Zoom4_1 Char(10)|Zoom5_1 Char(10)|Value1_1 Float|Value2_1 Float|Value3_1 Float|Value4_1 Float|Value5_1 Float|UDate1 DateTime|UDate2 DateTime|UDate3 DateTime|UDate4 DateTime|UDate5 DateTime|String1_1 Char(80)|String2_1 Char(80)|String3_1 Char(80)|String4_1 Char(80)|String5_1 Char(80)|Memo1 Memo|Quantity Float|OpenQnt Float|Zoom6_1 Char(10)|Zoom7_1 Char(10)|DlvTermsID Char(10)|NetValueP Float|DRXDate DateTime|DRXDoc Char(80)|CurrIDS Char(10)|CurrRateS Float|NetValueS Float|LtgCurrID Word|PayMethodID Char(13)|PersonID_1 Char(20)|ContrItemID Char(15)|CurrIDP_1 Char(10)|CurrRateP Float|AA AutoInc|ID Char(13)|SeriesCode Char(5)|Type1 Word|InsDate DateTime|Date1_1 DateTime|ExpDate DateTime|Cmmnt_1 Memo|SpecComm1 Char(80)|SpecComm2 Char(80)|AlterDoc Char(80)|AltDocDate DateTime|FlagAcc Word|FlagPrint Word|Category_1 Word|TotalValue Float|CharID_1 Char(10)|CategID_1 Char(50)|ParamsCode Char(10)|Temp1 Word|FlagAppl Word|DocCounter Integer|RelatedDoc Char(13)|TransSerDoc Char(5)|TransDocAA Integer|TransDoc Char(13)|FlagTrans Word|RecCrD_1 DateTime|RecCrU_1 Char(15)|RecModD_1 DateTime|RecModU_1 Char(15)|ReceiverID Char(10)|DelivDate DateTime|DelMethID_1 Char(10)|TrsportID_1 Char(10)|DiscPerc Float|WareHouseAA_1 Integer|MemoDoc_1 Char(80)|TransTypeID Char(2)|TransCtgr Word|Harbour Char(40)|CurrRateFPA Float|LocalChrg Float|AlterQnt Float|PriceListAA_1 Integer|DeductionID Char(10)|DeducVal1 Float|DeducVal2 Float|DeducVal3 Float|SChargeID_1 Char(10)|SChargeVal1 Float|SChargeVal2 Float|SChargeVal3 Float|VersionID Char(80)|ValCorrect Word|ValCorDocAA Integer|ToDate DateTime|FromDate DateTime|IsLocked Word|GrOfDocsID_1 Char(10)|SalesmanAA_1 Integer|ArtDataGrp_1 Char(10)|ArtDataTyp_1 Char(10)|TotalValueP Float|VatValueP Float|TotalValueS Float|VatValueS Float|Retail Word|InKEPYO_1 Word|CourseID Char(10)|RecPrivg_1 Integer|ExtraTaxP Float|ExtraTaxS Float|ExtraTax Float|CashDiscP Float|CashDiscS Float|CashDisc Float|SChargVal1P Float|SChargVal3S Float|SChargVal2S Float|SChargVal1S Float|DeducVal3P Float|DeducVal2P Float|DeducVal1P Float|DeducVal3S Float|DeducVal2S Float|DeducVal1S Float|SChargVal3P Float|SChargVal2P Float|SalPurType Word|GenCorrect Word|String6 Char(80)|String7 Char(80)|String8 Char(80)|String9 Char(80)|String10 Char(80)|DelPersonID Char(15)|DelPersType Word|Flag1_1 Word|Flag2_1 Word|Flag3_1 Word|ActvDiscPol Word|InRetailArt Word|ActvPrm Word|PrsRelID_1 Char(10)|DelNameID_1 Char(30)|CorDocCat Word|PropertyTp_1 Word|TrnOvAgrAA_1 Integer|crmDate_1 DateTime|String11 Char(80)|UDate6 DateTime|String12 Char(80)|UDate7 DateTime|String13 Char(80)|UDate10 DateTime|UDate8 DateTime|String14 Char(80)|UDate9 DateTime|String15 Char(80)|IVZoom8 Char(10)|IVZoom9 Char(10)|Value10_1 Float|Value6_1 Float|Value7_1 Float|Value8_1 Float|Value9_1 Float|IVZoom10 Char(10)|IVZoom11 Char(10)|IVZoom12 Char(10)|RetailSystem Word|RetailTransID Char(50)|RetailPOSID Char(50)|ExtSysDocID Char(50)|ExtraTaxVat Float|ExtraTaxVatS Float|ExtraTaxVatP Float|DEHCode_1 Char(20)|OilDoc Word|OilRec Word|VenusID Char(50)|TotalAdvValue Float|TotalAdvValueP Float|TotalAdvValueS Float
getfiedochdsal=OrderFldrAA Integer|IntRateJAA Integer|DelivPurp Char(10)|DelivPlace Char(30)|TaxCat Word Required Default=(0)|NetValue Float Default=(0)|VATValue Float Default=(0)|Address1 Char(50)|Address2 Char(50)|ZipCode Char(10)|City Char(30)|PlaceID Char(15)|CountryID Char(10)|Telephone Char(20)|AddrName Char(50)|DelAddress1 Char(50)|DelAddress2 Char(50)|DelZipCode Char(10)|DelCity Char(30)|DelPlaceID Char(15)|DelCntrID Char(10)|DelTel Char(20)|PayAgrmtID Char(13)|Zoom1 Char(10)|Zoom2 Char(10)|Zoom3 Char(10)|Zoom4 Char(10)|Zoom5 Char(10)|Value1 Float Default=(0)|Value2 Float Default=(0)|Value3 Float Default=(0)|Value4 Float Default=(0)|Value5 Float Default=(0)|UDate1 DateTime|UDate2 DateTime|UDate3 DateTime|UDate4 DateTime|UDate5 DateTime|String1 Char(80)|String2 Char(80)|String3 Char(80)|String4 Char(80)|String5 Char(80)|Memo1 Memo|Quantity Float Required|OpenQnt Float Required Default=(0)|Zoom6 Char(10)|Zoom7 Char(10)|DlvTermsID Char(10)|NetValueP Float Default=(0)|DRXDate DateTime|DRXDoc Char(80)|CurrIDS Char(10)|CurrRateS Float|NetValueS Float Default=(0)|LtgCurrID Word Default=(0)|PayMethodID Char(13)|PersonID Char(20) Required|ContrItemID Char(15)|CurrIDP Char(10)|CurrRateP Float|AA AutoInc PrimaryKey|ID Char(13) Required|SeriesCode Char(5) Required|Type1 Word Required|InsDate DateTime Required|Date1 DateTime Required|ExpDate DateTime Required|Cmmnt Memo|SpecComm1 Char(80)|SpecComm2 Char(80)|AlterDoc Char(80)|AltDocDate DateTime|FlagAcc Word Default=(0)|FlagPrint Word Default=(0)|Category Word Required Default=(0)|TotalValue Float Default=(0)|CharID Char(10)|CategID Char(50)|ParamsCode Char(10)|Temp1 Word Required|FlagAppl Word Required Default=(0)|DocCounter Integer|RelatedDoc Char(13)|TransSerDoc Char(5)|TransDocAA Integer|TransDoc Char(13)|FlagTrans Word Default=(0)|RecCrD DateTime Default=(getdate())|RecCrU Char(15)|RecModD DateTime|RecModU Char(15)|ReceiverID Char(10)|DelivDate DateTime|DelMethID Char(10)|TrsportID Char(10)|DiscPerc Float Required Default=(0)|WareHouseAA Integer|MemoDoc Char(80)|TransTypeID Char(2)|TransCtgr Word Required Default=(0)|Harbour Char(40)|CurrRateFPA Float|LocalChrg Float Default=(0)|AlterQnt Float Default=(0)|PriceListAA Integer|DeductionID Char(10)|DeducVal1 Float Required Default=(0)|DeducVal2 Float Required Default=(0)|DeducVal3 Float Required Default=(0)|SChargeID Char(10)|SChargeVal1 Float Required Default=(0)|SChargeVal2 Float Required Default=(0)|SChargeVal3 Float Required Default=(0)|VersionID Char(80)|ValCorrect Word Required Default=(0)|ValCorDocAA Integer|ToDate DateTime|FromDate DateTime|IsLocked Word Required Default=(0)|GrOfDocsID Char(10)|SalesmanAA Integer|ArtDataGrp Char(10)|ArtDataTyp Char(10)|TotalValueP Float Default=(0)|VatValueP Float Default=(0)|TotalValueS Float Default=(0)|VatValueS Float Default=(0)|Retail Word Required Default=(0)|InKEPYO Word Required Default=(0)|CourseID Char(10)|RecPrivg Integer Default=(0)|ExtraTaxP Float Required Default=(0)|ExtraTaxS Float Required Default=(0)|ExtraTax Float Required Default=(0)|CashDiscP Float Required Default=(0)|CashDiscS Float Required Default=(0)|CashDisc Float Required Default=(0)|SChargVal1P Float Required Default=(0)|SChargVal3S Float Required Default=(0)|SChargVal2S Float Required Default=(0)|SChargVal1S Float Required Default=(0)|DeducVal3P Float Required Default=(0)|DeducVal2P Float Required Default=(0)|DeducVal1P Float Required Default=(0)|DeducVal3S Float Required Default=(0)|DeducVal2S Float Required Default=(0)|DeducVal1S Float Required Default=(0)|SChargVal3P Float Required Default=(0)|SChargVal2P Float Required Default=(0)|SalPurType Word|GenCorrect Word Required Default=(0)|String6 Char(80)|String7 Char(80)|String8 Char(80)|String9 Char(80)|String10 Char(80)|DelPersonID Char(15)|DelPersType Word Default=(0)|Flag1 Word Required Default=(0)|Flag2 Word Required Default=(0)|Flag3 Word Required Default=(0)|ActvDiscPol Word Required Default=(0)|InRetailArt Word Required Default=(0)|ActvPrm Word Required Default=(0)|PrsRelID Char(10)|DelNameID Char(30)|CorDocCat Word Required Default=(2)|PropertyTp Word Required Default=(0)|TrnOvAgrAA Integer|crmDate DateTime|String11 Char(80)|UDate6 DateTime|String12 Char(80)|UDate7 DateTime|String13 Char(80)|UDate10 DateTime|UDate8 DateTime|String14 Char(80)|UDate9 DateTime|String15 Char(80)|IVZoom8 Char(10)|IVZoom9 Char(10)|Value10 Float Default=(0)|Value6 Float Default=(0)|Value7 Float Default=(0)|Value8 Float Default=(0)|Value9 Float Default=(0)|IVZoom10 Char(10)|IVZoom11 Char(10)|IVZoom12 Char(10)|RetailSystem Word Required Default=((0))|RetailTransID Char(50)|RetailPOSID Char(50)|ExtSysDocID Char(50)|ExtraTaxVat Float Default=((0))|ExtraTaxVatS Float Default=((0))|ExtraTaxVatP Float Default=((0))|DEHCode Char(20)|OilDoc Word Required Default=((0))|OilRec Word Required Default=((0))|VenusID Char(50)|TotalAdvValue Float Required Default=((0))|TotalAdvValueP Float Required Default=((0))|TotalAdvValueS Float Required Default=((0))
GetTab=_mike1|_mike3|ACAcZm1|ACAcZm2|ACAcZm3|ACAcZm4|ACAcZm5|ACAcZm6|ACArticlePar|ACArtZm1|ACArtZm2|ACArtZm3|ACArtZm4|ACArtZm5|ACArtZm6|ACBakBudgChg|ACBakBudget|ACBakPerio|ACBdgChgBs|ACBdgScn|ACBnkExt|ACBnkLnk|ACBnkRec|ACBudgetBs|AccArCas|AccCLStg|AccCntry|AccHier|AccMvCat|AccMvChc|Account|AccountantType|AccountDiff|AccVAT|ACDoc|ACDocMov|ACDocTpM|ACDocTyp|ACErrDsc|ACInvMov|ACMovesPar|ACMvCumPar|ACMvZm1|ACMvZm2|ACMvZm3|ACMvZm4|ACMvZm5|ACMvZm6|ACMvZm7|ACMvZm8|ACOilMove|ACPeriodBs|ACPrsRelt|ActList|ACTmpAcc|ACTmpArtDel|ACTmpArtInv|ACTmpArtInvErA|ACTmpCmArt|ACTmpCmArtJrn|ACTmpCmErArt|ACTmpCmErArtA|ACTmpCmJrn|ACTmpDiffLink|ACTmpDistrLink|ACTmpDsAcc|ACTmpDsAccMod|ACTmpDsAccModMov|ACTmpDsDblMod|ACTmpDsDiff|ACTmpDsModCalc|ACTmpDsMov|ACTmpImArt|ACTmpImEr|ACTmpImErA|ACTmpImGrp|ACTmpImMov|ACTmpImMovF|ACTmpMvPl|ACTmpMvPlAnal|ACTmpMvPlDiff|ACTmpOilMove|ACTmpOilMoveErA|ACTmpPPGroupIDLock|ACTmpUnCmArt|ACTmpUnCmJrn|ACTmpVarCalc|ACTmpVarRef|ACTmpVlErArt|ACTmpVlErArtA|ACUse|ACVar|ACVarDef|ACVarGrp|ACVarRes|AddCost|AllowWH|AllTrans|AltAddCl|AltAdSup|AltGroup|AltSalesman|AltSupVi|AnalCoData|APAccMdl|APAccTyp|APGAcTyp|APMdlAcs|APMdlLns|APModel|ArtDGrp|ArtDTyp|ArtModel|ArtSerie|ArtStdtoArtDf|AuditInfo|AuxAcc|AuxAcCat|AuxAccZm1|AuxAccZm10|AuxAccZm11|AuxAccZm12|AuxAccZm13|AuxAccZm14|AuxAccZm15|AuxAccZm2|AuxAccZm3|AuxAccZm4|AuxAccZm5|AuxAccZm6|AuxAccZm7|AuxAccZm8|AuxAccZm9|AuxAcRef|AuxBdgSc|AuxMdFld|AuxMdGrp|AuxModel|AuxModMv|AuxMoves|AuxMvGrp|AuxMvPrePost|AuxMvTyp|AuxMvZm1|AuxMvZm2|AuxMvZm3|AuxMvZm4|AuxMvZm5|AuxPerio|AuxPrdSt|AuxTmpAuxAcMv|AuxTmpCrtEr|AuxTmpCrtErB|AuxTmpCrtErC|AuxTmpDiffAmnt|AuxTmpDiffQnt|AuxTmpImEr|AuxTmpImErA|AuxTmpMdlMv|AuxTmpMvPl|BankAccount|BankBranch|BdgtSen|BgtLines|BOM|BomDimens|BOMLnItm|Browsers|BrwV|CalcID|CalcInter|CardType|Cash|CashInvent|CashMove|CashOpClMv|CatZ|CheqBank|CLBlobData|CLCalDay|CLCalDT|CLCalendar|CLCalMobDt|CLCost|ClDiscGroup|CLGCNT|CLGroup|Client|ClientCnt|ClientCu|ClientMo|CLLog|CLLogCst|CLLogSQL|CloseDat|CLPrivgs|CLPrivIt|ClPromGroup|ClTrnOvGroup|CmpParam|CNTClient|CNTPrepPostGroupID|CNTRetailClient|CNTRetailMaterial|CNTRetailSupplier|CntrItem|CntrLine|CNTSupplier|CNTThdPers|COCumul|CodePhas|Colour|ColourComb|ColourPallet|ColourPalletLn|Columns|ComPerio|CompPar|CompType|ConObjTp|CostCat|Course|CreditCard|CreditCardAnal|CrnCoin|Crncy|CrnGroup|CstFldAc|CstFolde|Ctgry1|Ctgry2|Ctgry3|Ctgry4|DasmClas|DataRule|DCntZoom1|DCntZoom2|Deduct|DefectCategory|DefObj|DefTerm|DelResUZm1|DelResUZm2|DelResZoom1|DelResZoom2|DelWSZoom1|DelWSZoom2|Departm|DeptZ|DiscountPolicy|DiscPolZm1|DiscPolZm2|DistrLev|DlvTerms|DocCoData|DocCount|DocHdCMo|DocHdCsh|DocHdNP|DocHdNR|DocHdPay|DocHdPur|DocHdRec|DocHdSal|DocHdSMo|DocModel|DocModLn|DocParam|DocPayAg|DocSer|DocSerZoom1|DocSerZoom2|DocSerZoom3|DocSerZoom4|DocSerZoom5|DocSerZoom6|DocSerZoom7|DOY|DrvBOM|DrvLine|DRVLINETOGROUP|DrvLnCat|DrvPlan|DrvPlnTp|Employee|ExchRate|ExclDate|ExDatTyp|ExDIntMo|ExpirDue|ExtraTax|ExtraTaxTrdPGroup|FAAllowOrg|FAApos|FAChange|FACommit|FADimn|FAItem|FAItmAllow|FAItmComt|FAItmDim|FAModel|FAModelDim|FAMov|FAMvDim|FAMvMap|FARedCoe|FARedRul|FATmpGroupMap|FATmpImpGrp|FATmpItemDim|FATmpMoveMap|FATmpPrepPost|FFields|Filters|Fixed|fscrmCriteria|fscrmExportedSaleDocs|fscrmFieldMaps|fscrmImportedOrders|Gen2|Gen3|Generat|GrntAnalysis|GroupOfDocs|HdPrZm1|HdPrZm2|HdPrZm3|HdPrZm4|HdPrZm5|HdStZm1|HdStZm2|HdStZm3|HdStZm4|HdStZm5|HistDocHdSal|HistLnItmSal|Historic|History|history_store|InRateGr|InRatJob|IntrasMv|IntRate|Introduc|InvPrC|InvVAT|Item|ItemCtrg|ItemPrc|ItemRlsn|ItPrCtgr|IVAltAdrZoom1|IVAltAdrZoom2|IVCheqBook|IVDhPrMoZm1|IVDhPrMoZm2|IVDhPrMoZm3|IVDhPrMoZm4|IVDhPrMoZm5|IVDhTZm1|IVDhTZm2|IVDhTZm3|IVDhTZm4|IVDhTZm5|IVDhZm1|IVDhZm10|IVDhZm11|IVDhZm12|IVDhZm2|IVDhZm3|IVDhZm4|IVDhZm5|IVDhZm6|IVDhZm7|IVDhZm8|IVDhZm9|IVLnTamZm3|IVLnZm1|IVLnZm2|IVLnZm3|IVLnZm4|IVLnZm5|IVLnZm6|IVLnZm7|IVLnZm8|IVLnZm9|IVOFZm1|IVOFZm10|IVOFZm11|IVOFZm12|IVOFZm13|IVOFZm14|IVOFZm15|IVOFZm2|IVOFZm3|IVOFZm4|IVOFZm5|IVOFZm6|IVOFZm7|IVOFZm8|IVOFZm9|IVPeriod|IVPrsRelHZm1|IVPrsRelTpHZm1|IVPrsRelTpZm1|IVPrsRelTpZm2|IVPrsRelZm1|IVPsrRelZM2|IVSalRptMH|IVSalStRpt|IVShift|IVYear|Journal|LangData|lgn_dfclientmo|lgn_f_max_date_xreosisT|Lgn_PistTz|LItmCash|LItmClMo|LItmNPay|LItmNRec|LItmPaym|LItmPurc|LItmRece|LItmSale|LItmSuMo|LnPrMoZm1|LnPrMoZm2|LnPrMoZm3|LnPrMoZm4|LnPrZm1|LnPrZm2|LnPrZm3|LnPrZm4|LnStZm1|LnStZm2|LnStZm3|LnStZm4|LnTamZm1|LnTamZm2|LnTamZm4|Lots|LotsMove|LotSNCount|LotStLoc|LotZoom1|LotZoom2|LtgClCls|LtgClOpn|LtgClRel|LtgDocRel|LtgQnt|LtgSpCls|LtgSpOpn|LtgSpRel|LUTAssoc|LUTHdr|LUTVals|MaClient|MaFlType|MainData|MatBarCodes|MatBgtGr|MatCodSO|MatCost|MatCstWH|MatCstWHG|Material|materialhelp|MatFItem|MatHrZm1|MatList|MatListRel|MatPrmMv|MatRelCode|MatrlMV|MatSize|MatZoom10|MatZoom11|MatZoom12|MatZoom13|MatZoom14|MatZoom15|MatZoom5|MatZoom6|MatZoom7|MatZoom8|MatZoom9|MCArtCnt|MDSVer|MeasUnit|MFIMoves|MMCoData|MMCoDataH|MMCoLoData|MntItem|ModelGrp|ModMove|mpc_web_material|MRPItem|MRPRun|Mserial|MtrlMUnt|MTSResult|MTSRun|MTSRunZm1|MTSRunZm2|MTSRunZm3|MTSRunZm4|MTSXGpToStLn|MTSXGroup|MTSXGrpToSlLn|MTSXRel|MTSXResToSlLn|MTSXResToStLn|MTSXResult|MTSXRnToSlLn|MTSXRnToStLn|MTSXRun|MTSXRUNDOCSERIES|MTSXRUNFROMWHOUSES|MTSXRUNLOGWHOUSES|MTSXRUNWIPWHOUSES|MTSXSalesLine|MTSXStockLine|MvToPlan|MvType|MVTYPETOWHOUSE|NetProfCoef|NotePay|NoteRec|NoteZoom1|NoteZoom2|NoteZoom3|NoteZoom4|NoteZoom5|NotPayMo|NotRecMo|ObjTpLUT|ObjType|OFActionList|OldUsesBs|OldVenusDocs|OperZoom1|OperZoom2|Opration|OrdCount|OrderCat|OrderFld|OrdFldAc|PAccSpec|Package|PackMove|Params|PayAgrLn|PayAgrmt|PayMethLim|PayMetho|PayMethodRetail|PayPlan|PayPlLines|PBPrdScp|PBPrdSDim|PCostDet|PCostObj|PCPeriod|PDelayTp|PDelWStat|Periodic|PersPlac|PExpType|PgBakApos|PgBakChng|PgBakCrn|PgBakCrnChn|PgBakItem|PGFAZm1|PgFAZm2|PgFAZm3|PgFAZm4|PgFAZm5|PgFAZm6|PHPFZm1|PHPFZm2|PhysInvDocs|PhysInvFolder|PhysInvItemBarCodes|PhysInvItems|PlaceZ|Plant|POprType|POrdCanc|Position|PPCDirect|PPCDirectLine|PPCIndirect|PPCIndirectBOM|PPCProduct|PPCScenario|PPCSCENARIO2RESOURCE|PPCService|PPCSKLine|PPostCst|Pprogram|PRAlter|prbalwst|PRBLinDim|PRBOM|PRBOMEx|PRBOMLin|PRBOMLineZoom1|PRBOMLineZoom2|PRBOMLineZoom3|PRBOMLineZoom4|PRBOMLineZoom5|PRBOMLineZoom6|PRBOMPlanEx|PRBOMPlanZoom1|PRBOMPlanZoom2|PRBOMPlanZoom3|PRBOMZoom1|PRBOMZoom2|PRBOMZoom3|PRBOMZoom4|PRBPlan|PRBPlDim|PRCCostDetWIP|PRCCostObjHier|PRCETCC|PRCInput|PRCInputWIP|PRCLevDepend|PRCLevTemp|PRCOutput|PRCParam|PRCRealInput|PRCSMCostDet|PRCSMInput|PRCSMOutput|PRCSumInput|PrdMovSt|PrdOrder|PRDriverPlanZoom1|PRDrvRes|PRDrvRs2|PRDrvRs3|PRDrvRs4|PRDrvRs5|PRDrvRs6|PrdSched|PrdShift|PrepPay|PrepPost|PrepRec|Prequest|Presourc|PricList|PrLLines|PRLMOVETYPEPROMOVESTATUS|PRLMOVETYPEPRWSTORES|PRLOPERATIONPRLMOVETYPE|PRLParam|PRLPrdLn|PRLResOper|PRLSchdGrp|PRLSection|PRLShiftTypeZoom1|PRLShiftTypeZoom2|PRLWSTATPRLOPER|PRMActionType|PRMActionZoom1|PRMActionZoom2|PRMActionZoom3|PRMActionZoom4|PRMDelayList|PRMDelayType|PRMEigStr|PRMExpendable|PRMItem|PRMItemMaintType|PRMItemZoom1|PRMItemZoom2|PRMItemZoom3|PRMItemZoom4|PRMMaintType|PRMMaintTypeZoom1|PRMMaintTypeZoom2|PRMMaintTypeZoom3|PRMMaintTypeZoom4|PRMMtTypeActType|PRMOrdActZoom1|PRMOrdActZoom2|PRMOrdActZoom3|PRMOrdActZoom4|PRMOrder|PRMOrderAction|PRMORDERACTIONPRMEXPENDABLE|PRMOrderZoom1|PRMOrderZoom2|PRMOrderZoom3|PRMOrderZoom4|PRMPriorityZoom|PRMReqDeptZoom|PRMRequest|PRMRequestZoom1|PRMRequestZoom2|PRMRequestZoom3|PRMRequestZoom4|PRMResource|PRMResourceUse|PRMTypeCatZoom|PRMTypeEigStr|PRMTypeExpend|PRMTypeRes|PRMZoomActTypeAct|PRODelay|PRODelayResUsed|PRODelayTypeZoom1|PRODelRes|PRODelZoom1|PRODelZoom2|ProdRate|PROLotWIP|Promotion|PROMove|PROMoveCtr|ProMoveDefect|PROMoveZoom1|PROMoveZoom2|PromScen|PROProductList|PROResList|PROResUsedZoom1|PROResUsedZoom2|PROResUsedZoom3|PROResUsedZoom4|PRORoutShift|PrptDef|Prquisit|PRROrBankZoom1|PRRoutingZoom1|PRRoutingZoom2|PRRoutingZoom3|PRRoutingZoom4|PrShiftZoom1|PrsPelCode|PRSRelation|PRSRelType|PRTask|PRTaskByProduct|PRWMaterial|PRWMove|PRWStore|PrZhiftZoom2|PrZoom1|PrZoom2|PSContr|PSInpMatSNLot|PSInput|PSInputDimD|PSInputMat|PSInputRun|PSLUTDef|PSPeriod|PSPrintD|PSRptDef|PSRptDes|PSYear|PurBdgGr|PurDiscGrp|PUReqItmZm1|PUReqItmZm2|PurPromGrp|PurPromRule|PurPromScenLn|QCMove|QCMoveField|QCMoveType|QCMoveZoom1|QCMoveZoom10|QCMoveZoom2|QCMoveZoom3|QCMoveZoom4|QCMoveZoom5|QCMoveZoom6|QCMoveZoom7|QCMoveZoom8|QCMoveZoom9|QCPoint|QCPOINTPRWSTORES|QCPOINTQCMOVETYPE|QCPOINTUSERS|RawNeed|RawNeedRel|Rdetails|RecalcBdg|RecalcVal|RecalcValDiff|Receiver|RELQCMOVETYPE|RelType|ReqItems|ReqItLin|ReqZm1|ReqZm2|ResTp|Results|ResUs|ResZoom1|ResZoom2|Routing|RoutOrItBank|SalDiscGrp|Salesman|SalesmanExtSys|SalesmGroup|SalPromGrp|SalPromRule|SalPromScenLn|SchedProgram|SchedSenario|SeriesRetail|ServZ|SetBOM|SetBOMLn|SetBomLnZm1|SetBomLnZm2|SetBomLnZm3|SetBomZm1|SetBomZm2|SetBomZm3|ShiftTyp|SizeComb|SizePallet|SizePalletLn|SKBillMatHrZoom1|SKBillMatZoom1|SKBillMatZoom2|SKBillMatZoom3|SKBillMatZoom4|SKBillMatZoom5|SKCFZm1|SKCFZm2|SKCFZm3|SKCFZm4|SKCntrLnZoom1|SKCntrLnZoom2|SKCntrZoom1|SKCntrZoom10|SKCntrZoom2|SKCntrZoom3|SKCntrZoom4|SKCntrZoom5|SKCntrZoom6|SKCntrZoom7|SKCntrZoom8|SKCntrZoom9|SKDelMet|SKDHPro|SKDHProd|SKDHStoc|SKLinePromDet|SKLIProd|SKLIStoc|SKLotZoom3|SKLotZoom4|SKLotZoom5|SKLotZoom6|SKMatBarCodeTempl|SKMatSGrp|SKMeasUnitDim|SKSNHrZm1|SKSNMove|SKSnZm1|SKSnZm10|SKSnZm2|SKSnZm3|SKSnZm4|SKSnZm5|SKSnZm6|SKSnZm7|SKSnZm8|SKSnZm9|SKZoom1|SKZoom2|SKZoom3|SKZoom4|SlBdgtGr|SLCACHE|SlCharact|SLCUSTOMIZATION|SLDBINFO|SLManZm1|SLManZm2|SLManZm3|SlmnBdgGroup|SlPosition|SLSCHEMA|Snumber|SNUse|SOrItBnk|Sortment|SortmentLines|Specialities|SpTrnOvGroup|SRVZoom1|SRVZoom10|SRVZoom11|SRVZoom12|SRVZoom13|SRVZoom14|SRVZoom15|SRVZoom2|SRVZoom3|SRVZoom4|SRVZoom5|SRVZoom6|SRVZoom7|SRVZoom8|SRVZoom9|StatClSu|STI|StLcCuml|StrgLocT|StrgLocT_dokimi|SuCharge|SupDiscGroup|Supervis|SuplieCu|SuplierM|Supplier|SupPromGroup|syntages_epikefalides|syntages_grammes|TaskResource|tblCustomTargets|tblWarehousePositions_P|tblWarehousePositionsAndItems_P|TEACTIONS|TEBARCODEMASKS|TEBARCODES|TEBOM|TEBUTTONGROUPS|TECASH|TECOLORS|TECURRENCIES|TECUSTGROUPS|TECUSTOMCONTROLS|TECUSTOMERS|TECUSTOMERSPERPOS|TEDISCOUNTS|TEDOCTYPES|TEDOCTYPESANALYSIS|TEELEMENTS|TEERRORLOG|TEEXTERNALINTERFACES|TEEXTRAPRINTING|TEINTERFACES|TEITEMGROUPS|TEITEMS|TEITEMSNOTES|TEITEMSPERPOS|TELAYOUTLINES|TELAYOUTS|temp123|TEOPENDAYS|TEOPENSHIFTS|TEOPERATIONS|TEPERMISSIONS|TEPREDEFINEDNOTES|TEPRICES|TEPROFILELAYOUTS|TEQUICKACTIONS|TEREPORTS|TEREVISIONS|Term|TermCat|TermCon|TermLUT|TermPar|TermZoom|TESCHEDULERPOLICY|TESECPROFILES|TESIZES|TESTORES|TESTYLES|TETAXES|TETAXOFFICES|TETENDERTYPES|TETERMINALS|TETRANSACTIONS|TETRANSAPPROVALS|TETRANSITEMS|TETRANSLINEELEMENTS|TETRANSLINES|TETRANSPAYMENTS|TETRANSREVNUM|TEUNITS|TEUSERS|TEUSERSTORAGE|TEVARIANTS|TEVATS|ThdPers|ThrdPrsnZoom1|ThrdPrsnZoom2|ThrdPrsnZoom3|TimeUnit|TmpPrd|TotalInter|TPCatego|Transpor|TrdPersExtraTaxGr|TrnOvAgrLn|TrnOvCredit|TrnsType|TrPPermM|TurnOverAgr|TypeZ|UICompnt|UICustom|UIGroup|USERGROUP|Users|WareHous|WhZm1|WhZm2|WhZm3|WhZm4|WorkRegion|WorkStat|WrkStTyp|WSSTATUS|WStatZoom1|WStatZoom2|ZDlvrPur|ZHeatOilCodes|ZMoveGr|Zoom1|Zoom10|Zoom11|Zoom12|Zoom13|Zoom14|Zoom15|Zoom16|Zoom17|Zoom18|Zoom2|Zoom3|Zoom4|Zoom5|Zoom6|Zoom7|Zoom8|Zoom9|ZSrvItem|CREXPORT|Material_SpecCode|Material_Test|pbcatcol|pbcatedt|pbcatfmt|pbcattbl|pbcatvld|promithies|Query|sysdiagrams|_Lgn_FID3_epit|_Lgn_FID3_metr|_Lgn_FID4_epit2|_Lgn_FID4_metr|_Lgn_Pay2b|_Lgn_Payb|ACArtInvCheck|ACArtInvValExpNonVATAuto|ACArtInvValExpVATAuto|ACArtInvValNoVAT|ACBudget|ACCOUNTA|AccountBs|AccountDiffBs|AccPerio|ACCsInvM|ACMvCum|AcMvCumDiff|ACOilMoveCheck|ACOilMoveVal|ACSpInvM|ACTmpPrdAll|AlertLtg|Article|ARTICLEA|ARTICLEDIFFG|ARTICLEG|ARTMODDS|ArtModTm|AuxAcc0|AuxAcc1|AuxAcc2|AuxAcc3|AuxAcc4|AuxAcMov|AuxBdgMv|AuxExpMv|AuxMdlNumAuxAccAA|AuxMvImpBdgPeriods|AuxMvImpGetBdgPrdError|AVAYAPersonView|BankAccountCompany|bardies_rout|BOMByProdBasic|BudgChg|CAPROMove|EGM_ClientRest|EGM_Katalogos_kathe_eidous|EGM_Material_Kila|EGM_monades_metrisis_ana_idos|EGM_Openqnt|EGM_sampania|EGM_Warehouse_material_picking|FAAddOnItm|FADeprMv|FAInactMv|FAItmMv|FAMainItm|FARepriceNormLines|GetCurUseEndDate|GetCurUseNumOfPeriods|GetCurUseStartDate|GetUnusedClientMovesAA|GetUnusedSupplierMovesAA|ImpGetErrorsAmount|ImpGetErrorsArtParGrpID1|ImpGetErrorsArtParGrpID2|ImpGetErrorsDate1|ImpGetErrorsDate2|ImpGetErrorsIsInventory1|ImpGetErrorsIsInventory2|ImpGetErrorsJrn1|ImpGetErrorsJrn2|ImpGetErrorsJrnArtParGrpID|IVACCsInvM|IVACInvMov|IVACSpInvM|LtgQntEvaluation|LtgQntWebShop|MaintMv|MatFinData|MatrCuml|MatrCumlPerGr|MatrlMVEvaluation|MIS_StatCliSupByDate|MOVES|MOVESDIFF|MTSOrigin|MTSXSalesLineSel|MTSXStockLineSel|OldUses|OldUsesV|OrdMovTo|OrdOutTo|OrItBank|OrItDoc|PCostObjAnyOuts|PCostObjByOuts|PCostObjCOOuts|PCostObjMainOuts|PCostObjOtherOuts|PCPeriodAccPeriods|pdMMUnt|PgApos|PgChng|PgCrn|PgCrnChn|PgItem|PgItemAd|PgItemFA|PMaterial|PRBOMBasic|PRBOMLinBasic|PRLStockLine|ProdMV|ProdRateBasic|PROMoveBasic|PROMoveBasic0|PRRoutBasic|PurchProm|PurDiscPolicy|QCParentMove|Recalc_ValuesDiffSum|Recalc_ValuesSum|RedemNormLines|RoutingAndTotals|RoutingMixedTime|RoutingShifts|RoutingTotals|routshifts|SalDiscPolicy|SalPromotion|ShMovTot|SKAltSalesman|SKBDGTSEN|SKBgtLns|SKDocSeries|SKOrdFolder|StLcCumlPerGr|StrgLocPerGroup|Vld_Article_PrdId1|Vld_ArticleCnt|Vld_ArticleCom_AA1|Vld_ArticleCom_AA2|Vld_ArticleLegNum1|Vld_ArticleLegNum2|Vld_ArticleMoves_Distrib_Amn1|Vld_ArticleMoves_OrderId1|Vld_ArticleMoves_OrderId2|Vld_ArticleMoves1|Vld_Get_GenClientAFM|Vld_Get_GenSupplierAFM|vStrgLoc|AccountstoCRM|Alagh status|DIAGRAFH ÔÃÁ|EGM_material|ISOTIMIA APA FAKELON|KATASTASH APA|KATASTASH APOTHIKIS|KATASTASH FAKELON FISIKIS APOGRAFIS|KATASTASH FAKELOY KLISTH APA ANIXTH|KATASTASH PA|KATASTASH PA01|KATASTASH PEA|PivotWareHouses|VIEW1|VIEW2|VIEW3|vwCubeERPSales|vwCubeERPTargets|vwCubeERPTargets2|vwInvoiceDetail|vwSTI|vwSTP|WareHouses|

dbpGetFieldDefs for the DocHdSal table:

Iosif_test.$Status=Connected
Iosif_test.Client.$State=Browse
Iosif_test.Client.PersonID=ÁÈ/18/031
Iosif_test.Client.Name=ÐÅÍÔÅ Á.Å.
Iosif_test.Client.CmpTypeID=060
Iosif_test.Client.Address1=ËÅÍÏÑÌÁÍ 129
Iosif_test.Client.Address2=ÊÏËÙÍÏÓ
Iosif_test.Client.City=ÁÈÇÍÁ
Iosif_test.Client.CntrID=ÅËËÁÄÁ
Iosif_test.Client.ZipCode=104 42
Iosif_test.Client.Telephone1=210 5147028
Iosif_test.Client.Telephone2=210 5144214-ëïãéóôçñ
Iosif_test.Client.Telex=210 5143610 ÌÁÑÁÃÊÏÕ
Iosif_test.Client.Fax=210 5146123
Iosif_test.Client.Place=01
Iosif_test.Client.DoyID=1118
Iosif_test.Client.AFM=094116278
Iosif_test.Client.ACode=30.00.18031
Iosif_test.Client.TaxCat=0
Iosif_test.Client.DebOpenVal=5486,5
Iosif_test.Client.OtherDeb=0
Iosif_test.Client.CreOpenVal=0
Iosif_test.Client.OtherCred=301,06
Iosif_test.Client.SalesPurch=42882,74
Iosif_test.Client.CancSalPurc=226,11
Iosif_test.Client.RecPaym=43000
Iosif_test.Client.CancRecPay=0
Iosif_test.Client.Turnover=34680,67
Iosif_test.Client.OpenNotes=0
Iosif_test.Client.OpenCheques=15000
Iosif_test.Client.InKEPYO=1
Iosif_test.Client.NeedForm=1
Iosif_test.Client.Zoom1=05
Iosif_test.Client.Zoom2=1
Iosif_test.Client.Zoom3=1
Iosif_test.Client.Zoom5=180
Iosif_test.Client.Value1=17768,7276
Iosif_test.Client.Value2=0
Iosif_test.Client.Value3=0
Iosif_test.Client.Value4=0
Iosif_test.Client.Value5=0
Iosif_test.Client.Value6=0
Iosif_test.Client.Value7=0
Iosif_test.Client.Value8=0
Iosif_test.Client.Value9=0
Iosif_test.Client.Value10=0
Iosif_test.Client.PersType=2
Iosif_test.Client.CurrIDP=ÅUR
Iosif_test.Client.DebOpValueP=5486,5
Iosif_test.Client.OtherDebP=0
Iosif_test.Client.CredOpValP=0
Iosif_test.Client.OtherCredP=301,06
Iosif_test.Client.SalesPurchP=42882,74
Iosif_test.Client.CancSalPurP=226,11
Iosif_test.Client.RecPaymP=43000
Iosif_test.Client.CancRecPayP=0
Iosif_test.Client.TurnoverP=34680,67
Iosif_test.Client.Telephone3=210 5149658
Iosif_test.Client.Telephone4=êá Ìáñáãêïõ -ëïãéóôç
Iosif_test.Client.TrdPersStat=0
Iosif_test.Client.OpNoteLimit=0
Iosif_test.Client.Related=1
Iosif_test.Client.Category=1
Iosif_test.Client.RecCrD=12/02/2007 11:20:25 ðì
Iosif_test.Client.RecCrU=USÅR4
Iosif_test.Client.RecModD=24/05/2012 10:27:06 ðì
Iosif_test.Client.RecModU=USÅR7
Iosif_test.Client.CretitLimit=19389,6585
Iosif_test.Client.WareHouseAA=1
Iosif_test.Client.Discount=0
Iosif_test.Client.DelMethID=01
Iosif_test.Client.IntMemo=93CC726D-D6BA-DB11-95C7-00104BAF7CC3
Iosif_test.Client.PriceListAA=17
Iosif_test.Client.GroupDocs=0
Iosif_test.Client.SalesmanAA=14
Iosif_test.Client.LegalType=Á.Å.
Iosif_test.Client.NotIssueLim=0
Iosif_test.Client.IssuedLim=0
Iosif_test.Client.RecPrivg=0
Iosif_test.Client.ComisionPer=0
Iosif_test.Client.CharID=99
Iosif_test.Client.CategID=04
Iosif_test.Client.CheckPlafon=0
Iosif_test.Client.IntForecasP=0
Iosif_test.Client.IntForecast=0
Iosif_test.Client.Group1=0
Iosif_test.Client.Flag1=0
Iosif_test.Client.Flag2=0
Iosif_test.Client.Flag3=0
Iosif_test.Client.RecPerCent=3
Iosif_test.Client.Flag4=0
Iosif_test.Client.Flag5=0
Iosif_test.Client.Flag6=0
Iosif_test.Client.Flag7=0
Iosif_test.Client.Flag8=0
Iosif_test.Client.OpenDbNotes=0
Iosif_test.Client.OpenDbCheq=0
Iosif_test.Client.Guarantees=0
Iosif_test.Client.GuaranteesP=0
Iosif_test.Client.PropertyTp=0
Iosif_test.Client.TrnOvGrpID=10000+
Iosif_test.Client.GothCrDocs=0
Iosif_test.Client.KEPYOType=0
Iosif_test.Client.UpdatesRetail=0
Iosif_test.Client.DiscDocTurnOver=1
Iosif_test.Client.UpdatesWebShop=0
Iosif_test.Client.UpdatesESales=0
Iosif_test.Client.DelivPurp=ÐÙËÇÓÇ
Iosif_test.Client.DelivPlace=ÅÄÑÁ ÌÁÓ
Iosif_test.Client.TaxCat_1=0
Iosif_test.Client.NetValue=41,11
Iosif_test.Client.VATValue=9,46
Iosif_test.Client.Address1_1=ËÅÍÏÑÌÁÍ 129
Iosif_test.Client.Address2_1=ÊÏËÙÍÏÓ
Iosif_test.Client.ZipCode_1=104 42
Iosif_test.Client.City_1=ÁÈÇÍÁ
Iosif_test.Client.PlaceID=01
Iosif_test.Client.CountryID=ÅËËÁÄÁ
Iosif_test.Client.Telephone=210 5147028
Iosif_test.Client.AddrName=ÊÁÔ/ÌÁ ËÁÌÉÁÓ Í° 1
Iosif_test.Client.DelAddress1=1° ÷ëì ËÁÌÉÁÓ ÊÁÑÐÅÍÇÓÉÏÕ
Iosif_test.Client.DelAddress2=ÑÅÂÅÍÉÁ
Iosif_test.Client.DelZipCode=351 00
Iosif_test.Client.DelCity=ËÁÌÉÁ
Iosif_test.Client.DelPlaceID=01
Iosif_test.Client.DelCntrID=ÅËËÁÄÁ
Iosif_test.Client.DelTel=210 5147028
Iosif_test.Client.Zoom1_1=106
Iosif_test.Client.Zoom2_1=28
Iosif_test.Client.Value1_1=0
Iosif_test.Client.Value2_1=0
Iosif_test.Client.Value3_1=0
Iosif_test.Client.Value4_1=0
Iosif_test.Client.Value5_1=0
Iosif_test.Client.Quantity=14
Iosif_test.Client.OpenQnt=14
Iosif_test.Client.Zoom6_1=01
Iosif_test.Client.NetValueP=41,11
Iosif_test.Client.CurrIDS=ÅUR
Iosif_test.Client.CurrRateS=1
Iosif_test.Client.NetValueS=41,11
Iosif_test.Client.LtgCurrID=0
Iosif_test.Client.PersonID_1=ÁÈ/18/031
Iosif_test.Client.CurrIDP_1=ÅUR
Iosif_test.Client.CurrRateP=1
Iosif_test.Client.AA=309745
Iosif_test.Client.ID=ÔÉÌ000180931
Iosif_test.Client.SeriesCode=ÔÉÌ0
Iosif_test.Client.Type1=0
Iosif_test.Client.InsDate=01/07/2010
Iosif_test.Client.Date1_1=01/07/2010
Iosif_test.Client.ExpDate=01/07/2010
Iosif_test.Client.SpecComm1=ÐÅÍÔÅ Á.Å.
Iosif_test.Client.AltDocDate=01/07/2010
Iosif_test.Client.FlagAcc=1
Iosif_test.Client.FlagPrint=1
Iosif_test.Client.Category_1=0
Iosif_test.Client.TotalValue=50,57
Iosif_test.Client.ParamsCode=ÅÎÁ.Ð&Á
Iosif_test.Client.Temp1=0
Iosif_test.Client.FlagAppl=1
Iosif_test.Client.DocCounter=63
Iosif_test.Client.FlagTrans=0
Iosif_test.Client.RecCrD_1=01/07/2010 12:11:48 ìì
Iosif_test.Client.RecCrU_1=USÅR9
Iosif_test.Client.RecModD_1=21/07/2010 10:44:49 ðì
Iosif_test.Client.RecModU_1=USÅR7
Iosif_test.Client.DelivDate=01/07/2010
Iosif_test.Client.DelMethID_1=05
Iosif_test.Client.DiscPerc=0
Iosif_test.Client.WareHouseAA_1=1
Iosif_test.Client.TransCtgr=0
Iosif_test.Client.LocalChrg=0
Iosif_test.Client.AlterQnt=0
Iosif_test.Client.PriceListAA_1=17
Iosif_test.Client.DeducVal1=0
Iosif_test.Client.DeducVal2=0
Iosif_test.Client.DeducVal3=0
Iosif_test.Client.SChargeVal1=0
Iosif_test.Client.SChargeVal2=0
Iosif_test.Client.SChargeVal3=0
Iosif_test.Client.ValCorrect=0
Iosif_test.Client.IsLocked=0
Iosif_test.Client.SalesmanAA_1=14
Iosif_test.Client.TotalValueP=50,57
Iosif_test.Client.VatValueP=9,46
Iosif_test.Client.TotalValueS=50,57
Iosif_test.Client.VatValueS=9,46
Iosif_test.Client.Retail=0
Iosif_test.Client.InKEPYO_1=1
Iosif_test.Client.RecPrivg_1=0
Iosif_test.Client.ExtraTaxP=0
Iosif_test.Client.ExtraTaxS=0
Iosif_test.Client.ExtraTax=0
Iosif_test.Client.CashDiscP=0
Iosif_test.Client.CashDiscS=0
Iosif_test.Client.CashDisc=0
Iosif_test.Client.SChargVal1P=0
Iosif_test.Client.SChargVal3S=0
Iosif_test.Client.SChargVal2S=0
Iosif_test.Client.SChargVal1S=0
Iosif_test.Client.DeducVal3P=0
Iosif_test.Client.DeducVal2P=0
Iosif_test.Client.DeducVal1P=0
Iosif_test.Client.DeducVal3S=0
Iosif_test.Client.DeducVal2S=0
Iosif_test.Client.DeducVal1S=0
Iosif_test.Client.SChargVal3P=0
Iosif_test.Client.SChargVal2P=0
Iosif_test.Client.SalPurType=2
Iosif_test.Client.GenCorrect=0
Iosif_test.Client.DelPersonID=ÁÈ/18/031
Iosif_test.Client.DelPersType=0
Iosif_test.Client.Flag1_1=0
Iosif_test.Client.Flag2_1=0
Iosif_test.Client.Flag3_1=0
Iosif_test.Client.ActvDiscPol=0
Iosif_test.Client.InRetailArt=0
Iosif_test.Client.ActvPrm=0
Iosif_test.Client.CorDocCat=2
Iosif_test.Client.PropertyTp_1=0
Iosif_test.Client.Value10_1=0
Iosif_test.Client.Value6_1=0
Iosif_test.Client.Value7_1=0
Iosif_test.Client.Value8_1=0
Iosif_test.Client.Value9_1=0
Iosif_test.Client.RetailSystem=0
Iosif_test.Client.ExtraTaxVat=0
Iosif_test.Client.ExtraTaxVatS=0
Iosif_test.Client.ExtraTaxVatP=0
Iosif_test.Client.OilDoc=0
Iosif_test.Client.OilRec=0
Iosif_test.Client.TotalAdvValue=0
Iosif_test.Client.TotalAdvValueP=0
Iosif_test.Client.TotalAdvValueS=0
Iosif_test.Client.$RecNum=1
Iosif_test.Client.$RecCount=1000
Iosif_test.dochdsal.$State=Browse
Iosif_test.dochdsal.DelivPurp=ÐÙËÇÓÇ
Iosif_test.dochdsal.DelivPlace=ÅÄÑÁ ÌÁÓ
Iosif_test.dochdsal.TaxCat=0
Iosif_test.dochdsal.NetValue=217,17
Iosif_test.dochdsal.VATValue=49,95
Iosif_test.dochdsal.Address1=ÃÁËÁÔÉÍÇ
Iosif_test.dochdsal.ZipCode=503 00
Iosif_test.dochdsal.City=ÃÁËÁÔÉÍÇ-ÊÏÆÁÍÇÓ
Iosif_test.dochdsal.PlaceID=07
Iosif_test.dochdsal.CountryID=ÅËËÁÄÁ
Iosif_test.dochdsal.Telephone=2465-041643
Iosif_test.dochdsal.AddrName=ÃÁËÁÔÉÍÇ
Iosif_test.dochdsal.DelAddress1=ÃÁËÁÔÉÍÇ
Iosif_test.dochdsal.DelZipCode=503 00
Iosif_test.dochdsal.DelCity=ÃÁËÁÔÉÍÇ-ÊÏÆÁÍÇÓ
Iosif_test.dochdsal.DelPlaceID=07
Iosif_test.dochdsal.DelCntrID=ÅËËÁÄÁ
Iosif_test.dochdsal.DelTel=2465-041643
Iosif_test.dochdsal.PayAgrmtID=ÅÐÉ ÐÉÓÔÙÓÅÉ
Iosif_test.dochdsal.Zoom1=106
Iosif_test.dochdsal.Zoom2=04
Iosif_test.dochdsal.Value1=0
Iosif_test.dochdsal.Value2=0
Iosif_test.dochdsal.Value3=0
Iosif_test.dochdsal.Value4=0
Iosif_test.dochdsal.Value5=0
Iosif_test.dochdsal.Quantity=2
Iosif_test.dochdsal.OpenQnt=2
Iosif_test.dochdsal.Zoom6=01
Iosif_test.dochdsal.NetValueP=217,17
Iosif_test.dochdsal.CurrIDS=ÅUR
Iosif_test.dochdsal.CurrRateS=1
Iosif_test.dochdsal.NetValueS=217,17
Iosif_test.dochdsal.LtgCurrID=0
Iosif_test.dochdsal.PersonID=ÄÌ/01/019
Iosif_test.dochdsal.CurrIDP=ÅUR
Iosif_test.dochdsal.CurrRateP=1
Iosif_test.dochdsal.AA=309701
Iosif_test.dochdsal.ID=ÔÉÌ000180916
Iosif_test.dochdsal.SeriesCode=ÔÉÌ0
Iosif_test.dochdsal.Type1=0
Iosif_test.dochdsal.InsDate=01/07/2010
Iosif_test.dochdsal.Date1=01/07/2010
Iosif_test.dochdsal.ExpDate=01/07/2010
Iosif_test.dochdsal.SpecComm1=ÔÓÏÊÁÓ Ä. ÌÉ×ÁÇË
Iosif_test.dochdsal.AltDocDate=01/07/2010
Iosif_test.dochdsal.FlagAcc=1
Iosif_test.dochdsal.FlagPrint=1
Iosif_test.dochdsal.Category=0
Iosif_test.dochdsal.TotalValue=267,12
Iosif_test.dochdsal.ParamsCode=ÅÎÁ.Ð&Á
Iosif_test.dochdsal.Temp1=0
Iosif_test.dochdsal.FlagAppl=1
Iosif_test.dochdsal.DocCounter=63
Iosif_test.dochdsal.FlagTrans=0
Iosif_test.dochdsal.RecCrD=01/07/2010 11:26:06 ðì
Iosif_test.dochdsal.RecCrU=USÅR9
Iosif_test.dochdsal.RecModD=21/07/2010 12:32:19 ìì
Iosif_test.dochdsal.RecModU=USÅR7
Iosif_test.dochdsal.DelivDate=01/07/2010
Iosif_test.dochdsal.DelMethID=07
Iosif_test.dochdsal.TrsportID=291
Iosif_test.dochdsal.DiscPerc=0
Iosif_test.dochdsal.WareHouseAA=1
Iosif_test.dochdsal.TransCtgr=0
Iosif_test.dochdsal.LocalChrg=0
Iosif_test.dochdsal.AlterQnt=0
Iosif_test.dochdsal.DeducVal1=0
Iosif_test.dochdsal.DeducVal2=0
Iosif_test.dochdsal.DeducVal3=0
Iosif_test.dochdsal.SChargeVal1=0
Iosif_test.dochdsal.SChargeVal2=0
Iosif_test.dochdsal.SChargeVal3=0
Iosif_test.dochdsal.ValCorrect=0
Iosif_test.dochdsal.IsLocked=0
Iosif_test.dochdsal.SalesmanAA=25
Iosif_test.dochdsal.TotalValueP=267,12
Iosif_test.dochdsal.VatValueP=49,95
Iosif_test.dochdsal.TotalValueS=267,12
Iosif_test.dochdsal.VatValueS=49,95
Iosif_test.dochdsal.Retail=0
Iosif_test.dochdsal.InKEPYO=1
Iosif_test.dochdsal.RecPrivg=0
Iosif_test.dochdsal.ExtraTaxP=0
Iosif_test.dochdsal.ExtraTaxS=0
Iosif_test.dochdsal.ExtraTax=0
Iosif_test.dochdsal.CashDiscP=0
Iosif_test.dochdsal.CashDiscS=0
Iosif_test.dochdsal.CashDisc=0
Iosif_test.dochdsal.SChargVal1P=0
Iosif_test.dochdsal.SChargVal3S=0
Iosif_test.dochdsal.SChargVal2S=0
Iosif_test.dochdsal.SChargVal1S=0
Iosif_test.dochdsal.DeducVal3P=0
Iosif_test.dochdsal.DeducVal2P=0
Iosif_test.dochdsal.DeducVal1P=0
Iosif_test.dochdsal.DeducVal3S=0
Iosif_test.dochdsal.DeducVal2S=0
Iosif_test.dochdsal.DeducVal1S=0
Iosif_test.dochdsal.SChargVal3P=0
Iosif_test.dochdsal.SChargVal2P=0
Iosif_test.dochdsal.SalPurType=2
Iosif_test.dochdsal.GenCorrect=0
Iosif_test.dochdsal.DelPersonID=ÄÌ/01/019
Iosif_test.dochdsal.DelPersType=0
Iosif_test.dochdsal.Flag1=0
Iosif_test.dochdsal.Flag2=1
Iosif_test.dochdsal.Flag3=0
Iosif_test.dochdsal.ActvDiscPol=0
Iosif_test.dochdsal.InRetailArt=0
Iosif_test.dochdsal.ActvPrm=0
Iosif_test.dochdsal.CorDocCat=2
Iosif_test.dochdsal.PropertyTp=0
Iosif_test.dochdsal.Value10=0
Iosif_test.dochdsal.Value6=0
Iosif_test.dochdsal.Value7=0
Iosif_test.dochdsal.Value8=0
Iosif_test.dochdsal.Value9=0
Iosif_test.dochdsal.RetailSystem=0
Iosif_test.dochdsal.ExtraTaxVat=0
Iosif_test.dochdsal.ExtraTaxVatS=0
Iosif_test.dochdsal.ExtraTaxVatP=0
Iosif_test.dochdsal.OilDoc=0
Iosif_test.dochdsal.OilRec=0
Iosif_test.dochdsal.TotalAdvValue=0
Iosif_test.dochdsal.TotalAdvValueP=0
Iosif_test.dochdsal.TotalAdvValueS=0
Iosif_test.dochdsal.$RecNum=1
Iosif_test.dochdsal.$RecCount=1000
Iosif_test.LItmSale.$State=Browse
Iosif_test.LItmSale.$RecNum=1
Iosif_test.LItmSale.$RecCount=2
Iosif_test.LItmSale.Price=217,168
Iosif_test.LItmSale.NetValue=217,17
Iosif_test.LItmSale.VATValue=49,95
Iosif_test.LItmSale.TotalValue=267,12
Iosif_test.LItmSale.CurrIDP=ÅUR
Iosif_test.LItmSale.CurrRateP=1
Iosif_test.LItmSale.NetValueP=217,17
Iosif_test.LItmSale.CurrIDS=ÅUR
Iosif_test.LItmSale.CurrRateS=1
Iosif_test.LItmSale.NetValueS=217,17
Iosif_test.LItmSale.Quantity=1
Iosif_test.LItmSale.OpenQnt=1
Iosif_test.LItmSale.ActualQnt=1
Iosif_test.LItmSale.AA=3058753
Iosif_test.LItmSale.DocumentAA=309701
Iosif_test.LItmSale.LineNum=0
Iosif_test.LItmSale.LineType=1
Iosif_test.LItmSale.Cmmnt=ÐÁËÅÔÏÖÏÑÁ 2,5 tn ÁÈÏÑ.55cmX110cm
Iosif_test.LItmSale.LinkID=ÕÃ2404
Iosif_test.LItmSale.CharID=07
Iosif_test.LItmSale.CategID=29
Iosif_test.LItmSale.LinkIDNum=4209
Iosif_test.LItmSale.SalOrdPh=0
Iosif_test.LItmSale.StrgLocAA=4518
Iosif_test.LItmSale.MUnitAA=8724
Iosif_test.LItmSale.VATCtgr=0
Iosif_test.LItmSale.DiscVal=0
Iosif_test.LItmSale.DiscPrc=0
Iosif_test.LItmSale.DelivDate=02/07/2010
Iosif_test.LItmSale.Value1=0
Iosif_test.LItmSale.Value2=217,168
Iosif_test.LItmSale.String2=TEST
Iosif_test.LItmSale.AlterQnt=0
Iosif_test.LItmSale.MatPrprt=0
Iosif_test.LItmSale.FictValue=217,17
Iosif_test.LItmSale.TotalValueP=267,12
Iosif_test.LItmSale.VatValueP=49,95
Iosif_test.LItmSale.TotalValueS=267,12
Iosif_test.LItmSale.VatValueS=49,95
Iosif_test.LItmSale.Charge=0
Iosif_test.LItmSale.ExtraTaxP=0
Iosif_test.LItmSale.ExtraTaxS=0
Iosif_test.LItmSale.ExtraTax=0
Iosif_test.LItmSale.ComisionPer=0
Iosif_test.LItmSale.SalesmanAA=25
Iosif_test.LItmSale.ComisionVal=0
Iosif_test.LItmSale.SecDiscPrc=0
Iosif_test.LItmSale.ThrdDiscPrc=0
Iosif_test.LItmSale.SrtmntQnt=0
Iosif_test.LItmSale.Val3=0
Iosif_test.LItmSale.Val4=0
Iosif_test.LItmSale.Val5=0
Iosif_test.LItmSale.LineCharact=0
Iosif_test.LItmSale.Val6=0
Iosif_test.LItmSale.Val7=0
Iosif_test.LItmSale.Val8=0
Iosif_test.LItmSale.Val10=0
Iosif_test.LItmSale.Val9=0
Iosif_test.LItmSale.Val11=0
Iosif_test.LItmSale.Val12=0
Iosif_test.LItmSale.Val13=0
Iosif_test.LItmSale.ExtraTaxVat=0
Iosif_test.LItmSale.ExtraTaxVatS=0
Iosif_test.LItmSale.ExtraTaxVatP=0
Iosif_test.LItmSale.OilSubsidyVal=0
Iosif_test.LItmSale.OilRec=0
Iosif_test.LItmSale.MUDimQnt=0
Iosif_test.LItmSale.MUDim1Qnt=0
Iosif_test.LItmSale.MUDim2Qnt=0
Iosif_test.LItmSale.MUDim3Qnt=0
Iosif_test.LItmSale.ExtraTax2P=0
Iosif_test.LItmSale.ExtraTax2S=0
Iosif_test.LItmSale.ExtraTax2=0
Iosif_test.LItmSale.ExtraTax3P=0
Iosif_test.LItmSale.ExtraTax3S=0
Iosif_test.LItmSale.ExtraTax3=0
Iosif_test.LItmSale.ExtraTax2VatP=0
Iosif_test.LItmSale.ExtraTax2VatS=0
Iosif_test.LItmSale.ExtraTax2Vat=0
Iosif_test.LItmSale.ExtraTax3VatP=0
Iosif_test.LItmSale.ExtraTax3VatS=0
Iosif_test.LItmSale.ExtraTax3Vat=0
GetFielclien=IntRateGrID Char(13)|SalBdgtID Char(50)|PersonID Char(20) Required PrimaryKey|Name Char(80)|CompTitle Char(50)|Supervisor Char(50)|CmpTypeID Char(10)|Address1 Char(50)|Address2 Char(50)|City Char(30)|CntrID Char(10)|ZipCode Char(10)|Telephone1 Char(20)|Telephone2 Char(20)|Telex Char(20)|Fax Char(20)|AccSuperv Char(15)|Introducer Char(15)|Place Char(15)|DoyID Char(15)|Gen2 Char(10)|Gen3 Char(10)|AFM Char(15) Required|ACode Char(20)|AccCodeDoy Char(20)|DelivAddr1 Char(50)|DelivAddr2 Char(50)|City2 Char(30)|Place2 Char(15)|DelivTeleph Char(20)|Fax2 Char(20)|PostCode2 Char(10)|TaxCat Word Default=(0)|DebOpenVal Float Default=(0)|OtherDeb Float Default=(0)|CreOpenVal Float Default=(0)|OtherCred Float Default=(0)|SalesPurch Float Default=(0)|CancSalPurc Float Default=(0)|RecPaym Float Default=(0)|CancRecPay Float Default=(0)|Turnover Float Default=(0)|OpenNotes Float Default=(0)|OpenCheques Float Default=(0)|Cmmnt Char(80)|Memo Memo|InKEPYO Word Required Default=(1)|NeedForm Word Required Default=(1)|Zoom1 Char(10)|Zoom2 Char(10)|Zoom3 Char(17)|Zoom4 Char(10)|Zoom5 Char(10)|Zoom6 Char(10)|Zoom7 Char(10)|Zoom8 Char(10)|String1 Char(30)|String2 Char(30)|String3 Char(30)|String4 Char(30)|String5 Char(30)|Value1 Float Default=(0)|Value2 Float Default=(0)|Value3 Float Default=(0)|Value4 Float Default=(0)|Value5 Float Default=(0)|Value6 Float Default=(0)|Value7 Float Default=(0)|Value8 Float Default=(0)|Value9 Float Default=(0)|Value10 Float Default=(0)|Date1 DateTime|Date2 DateTime|Date3 DateTime|Date4 DateTime|Date5 DateTime|PersType Word Required Default=(0)|PayAgrmtID Char(13)|CurrIDP Char(10) Required|DebOpValueP Float Default=(0)|OtherDebP Float Default=(0)|CredOpValP Float Default=(0)|OtherCredP Float Default=(0)|SalesPurchP Float Default=(0)|CancSalPurP Float Default=(0)|RecPaymP Float Default=(0)|CancRecPayP Float Default=(0)|TurnoverP Float Default=(0)|Telephone3 Char(20)|Telephone4 Char(20)|TrdPersStat Word Required Default=(0)|TPPermMovAA Integer|OpNoteLimit Float Default=(0)|Related Word Required Default=(1)|Category Char(50)|RecCrD DateTime Default=(getdate())|RecCrU Char(15)|RecModD DateTime|RecModU Char(15)|CretitLimit Float Required Default=(0)|WareHouseAA Integer|TrsportID Char(10)|Discount Float Required Default=(0)|AlternCode Char(80)|DelMethID Char(10)|IntMemo Memo|PriceListAA Integer|DeductID Char(10)|SChargeID Char(10)|MemoDoc Char(80)|GroupDocs Word Required Default=(0)|AccModelID Char(13)|SalesmanAA Integer|GrOfDocsID Char(10)|CmpLocation Char(80)|LegalType Char(80)|CmpActivity Memo|CntrID2 Char(10)|RetailPrLAA Integer|NotIssueLim Float Default=(0)|IssuedLim Float Default=(0)|Email Char(80)|WebSite Char(80)|RecPrivg Integer Default=(0)|ComisionPer Float Required Default=(0)|CharID Char(10)|ArtDataGrp Char(10)|CategID Char(50)|ArtDataTyp Char(10)|ExchDifDate DateTime|CheckPlafon Word Required Default=(1)|IntForecasP Float Required Default=(0)|LastRunDate DateTime|IntForecast Float Required Default=(0)|CollectDate DateTime|Group1 Word Required Default=(0)|Flag1 Word Required Default=(0)|Flag2 Word Required Default=(0)|Flag3 Word Required Default=(0)|TrnOvAgrAA Integer|RelCode Char(10)|DiscGrpID Char(10)|RecPerCent Float Required Default=(0)|Zoom9 Char(10)|Zoom10 Char(10)|Zoom11 Char(10)|Zoom12 Char(10)|Zoom13 Char(10)|Zoom14 Char(10)|Zoom15 Char(10)|Zoom16 Char(10)|Zoom17 Char(10)|Zoom18 Char(10)|Flag4 Word Required Default=(0)|Flag5 Word Required Default=(0)|Flag6 Word Required Default=(0)|Flag7 Word Required Default=(0)|Flag8 Word Required Default=(0)|InvoiceMsg Char(80)|DocModelAA Integer|IDIssuer Char(80)|IDNumber Char(10)|IDIssueDate DateTime|OpenDbNotes Float Default=(0)|OpenDbCheq Float Default=(0)|PromGrpID Char(10)|Guarantees Float Required Default=(0)|GuaranteesP Float Required Default=(0)|PrsRelID Char(10)|DelNameID Char(30)|Relation Char(10)|PropertyTp Word Required Default=(0)|TrnOvGrpID Char(10)|GothCrDocs Word Required Default=(0)|KEPYOType Word Required Default=(0)|crmDate DateTime|RevNumber Integer Default=((0))|UpdatesRetail Word Required Default=((0))|DEHCode Char(20)|HFACode Char(20)|DiscDocTurnOver Word Required Default=((0))|ReferenceID Char(50)|UpdatesWebShop Word Required Default=((0))|UpdatesESales Word Required Default=((0))|ExtraTaxGroupID Char(50)|OrderFldrAA Integer|IntRateJAA Integer|DelivPurp Char(10)|DelivPlace Char(30)|TaxCat_1 Word|NetValue Float|VATValue Float|Address1_1 Char(50)|Address2_1 Char(50)|ZipCode_1 Char(10)|City_1 Char(30)|PlaceID Char(15)|CountryID Char(10)|Telephone Char(20)|AddrName Char(50)|DelAddress1 Char(50)|DelAddress2 Char(50)|DelZipCode Char(10)|DelCity Char(30)|DelPlaceID Char(15)|DelCntrID Char(10)|DelTel Char(20)|PayAgrmtID_1 Char(13)|Zoom1_1 Char(10)|Zoom2_1 Char(10)|Zoom3_1 Char(10)|Zoom4_1 Char(10)|Zoom5_1 Char(10)|Value1_1 Float|Value2_1 Float|Value3_1 Float|Value4_1 Float|Value5_1 Float|UDate1 DateTime|UDate2 DateTime|UDate3 DateTime|UDate4 DateTime|UDate5 DateTime|String1_1 Char(80)|String2_1 Char(80)|String3_1 Char(80)|String4_1 Char(80)|String5_1 Char(80)|Memo1 Memo|Quantity Float|OpenQnt Float|Zoom6_1 Char(10)|Zoom7_1 Char(10)|DlvTermsID Char(10)|NetValueP Float|DRXDate DateTime|DRXDoc Char(80)|CurrIDS Char(10)|CurrRateS Float|NetValueS Float|LtgCurrID Word|PayMethodID Char(13)|PersonID_1 Char(20)|ContrItemID Char(15)|CurrIDP_1 Char(10)|CurrRateP Float|AA AutoInc|ID Char(13)|SeriesCode Char(5)|Type1 Word|InsDate DateTime|Date1_1 DateTime|ExpDate DateTime|Cmmnt_1 Memo|SpecComm1 Char(80)|SpecComm2 Char(80)|AlterDoc Char(80)|AltDocDate DateTime|FlagAcc Word|FlagPrint Word|Category_1 Word|TotalValue Float|CharID_1 Char(10)|CategID_1 Char(50)|ParamsCode Char(10)|Temp1 Word|FlagAppl Word|DocCounter Integer|RelatedDoc Char(13)|TransSerDoc Char(5)|TransDocAA Integer|TransDoc Char(13)|FlagTrans Word|RecCrD_1 DateTime|RecCrU_1 Char(15)|RecModD_1 DateTime|RecModU_1 Char(15)|ReceiverID Char(10)|DelivDate DateTime|DelMethID_1 Char(10)|TrsportID_1 Char(10)|DiscPerc Float|WareHouseAA_1 Integer|MemoDoc_1 Char(80)|TransTypeID Char(2)|TransCtgr Word|Harbour Char(40)|CurrRateFPA Float|LocalChrg Float|AlterQnt Float|PriceListAA_1 Integer|DeductionID Char(10)|DeducVal1 Float|DeducVal2 Float|DeducVal3 Float|SChargeID_1 Char(10)|SChargeVal1 Float|SChargeVal2 Float|SChargeVal3 Float|VersionID Char(80)|ValCorrect Word|ValCorDocAA Integer|ToDate DateTime|FromDate DateTime|IsLocked Word|GrOfDocsID_1 Char(10)|SalesmanAA_1 Integer|ArtDataGrp_1 Char(10)|ArtDataTyp_1 Char(10)|TotalValueP Float|VatValueP Float|TotalValueS Float|VatValueS Float|Retail Word|InKEPYO_1 Word|CourseID Char(10)|RecPrivg_1 Integer|ExtraTaxP Float|ExtraTaxS Float|ExtraTax Float|CashDiscP Float|CashDiscS Float|CashDisc Float|SChargVal1P Float|SChargVal3S Float|SChargVal2S Float|SChargVal1S Float|DeducVal3P Float|DeducVal2P Float|DeducVal1P Float|DeducVal3S Float|DeducVal2S Float|DeducVal1S Float|SChargVal3P Float|SChargVal2P Float|SalPurType Word|GenCorrect Word|String6 Char(80)|String7 Char(80)|String8 Char(80)|String9 Char(80)|String10 Char(80)|DelPersonID Char(15)|DelPersType Word|Flag1_1 Word|Flag2_1 Word|Flag3_1 Word|ActvDiscPol Word|InRetailArt Word|ActvPrm Word|PrsRelID_1 Char(10)|DelNameID_1 Char(30)|CorDocCat Word|PropertyTp_1 Word|TrnOvAgrAA_1 Integer|crmDate_1 DateTime|String11 Char(80)|UDate6 DateTime|String12 Char(80)|UDate7 DateTime|String13 Char(80)|UDate10 DateTime|UDate8 DateTime|String14 Char(80)|UDate9 DateTime|String15 Char(80)|IVZoom8 Char(10)|IVZoom9 Char(10)|Value10_1 Float|Value6_1 Float|Value7_1 Float|Value8_1 Float|Value9_1 Float|IVZoom10 Char(10)|IVZoom11 Char(10)|IVZoom12 Char(10)|RetailSystem Word|RetailTransID Char(50)|RetailPOSID Char(50)|ExtSysDocID Char(50)|ExtraTaxVat Float|ExtraTaxVatS Float|ExtraTaxVatP Float|DEHCode_1 Char(20)|OilDoc Word|OilRec Word|VenusID Char(50)|TotalAdvValue Float|TotalAdvValueP Float|TotalAdvValueS Float
getfiedochdsal=OrderFldrAA Integer|IntRateJAA Integer|DelivPurp Char(10)|DelivPlace Cha
RigmaishRaict
 
Posts: 7
Joined: Tue Oct 23, 2012 4:39 pm

Postby RigmaishRaict » Wed Jul 18, 2012 1:00 am

I think that the problem is the Greek characters.
Neobook can't recognize them.
RigmaishRaict
 
Posts: 7
Joined: Tue Oct 23, 2012 4:39 pm

Postby Gaev » Wed Jul 18, 2012 5:06 am

makis_best:
I think that the problem is the Greek characters.
Try a test with some records where the contents of the fields are not special Greek characters ... and not something that looks like a date ... e.g. "MakisBest"

When you display the two Grids separately, how does NeoBook handle this particular field ?

If NeoBook only has a problem with Greek characters in the dbpDefineRelationship command, consider Leos's second suggested method ... i.e. use the subroutine (specified in the dbpOpenTable command for the Client Table) to show a filtered list of invoices records in the second grid (using dbpQuery).
User avatar
Gaev
 
Posts: 3734
Joined: Fri Apr 01, 2005 7:48 am
Location: Toronto, Canada

Postby RigmaishRaict » Thu Jul 19, 2012 12:53 am

When I display the two Grids separately the records show fine.

When I try to use the dbpDefineRelationship with other tables works fine.
I can't understand why that happens with only this two tables.

The point is that I can't link them with a different relation.

I don't know how I can use this method "use the subroutine (specified in the
dbpOpenTable command for the Client Table) to show a
filtered list of invoices records in the second grid (using dbpQuery)"
any example?
RigmaishRaict
 
Posts: 7
Joined: Tue Oct 23, 2012 4:39 pm

Postby Gaev » Thu Jul 19, 2012 5:24 am

makis_best:
When I display the two Grids separately the records show fine.

When I try to use the dbpDefineRelationship with other tables works fine.
I can't understand why that happens with only this two tables.
So, either there is a problem with the dbpDefineRelationship command when used with special characters or NeoBookDBPro does not support these special characters.

In any case, you should try the alternate method.

I don't know how I can use this method "use the subroutine (specified in the dbpOpenTable command for the Client Table) to show a filtered list of invoices records in the second grid (using dbpQuery)"
any example?
Take a look (in the Help file) about the dbpOpenTable command ... especially the "subroutine" parameter.

So, in this specified "subroutine" for the clients Table you would ...

- extract the value of the PersonID field (e.g. SetVar "[thisPersonID]" "[yourDBNameHere.clients.PersonID]")

- use this extracted value to do a dbpQuery on the DocHdSal Table i.e. in the "filter" parameter, specify "PersonID = [thisPersonID]"

Try this first on a test Database with small number of records that do not contain special (Greek) characters ... that way, you can separate your/NeoBook issues from those caused by the use of special characters, large databases and even MSSQL.
User avatar
Gaev
 
Posts: 3734
Joined: Fri Apr 01, 2005 7:48 am
Location: Toronto, Canada


Return to NeoBookDBPro

Who is online

Users browsing this forum: No registered users and 2 guests