LaborDtlSeq Blank Title 128457

Yahoo Archive
1
#ygrps-yiv-1273269980 P.ygrps-yiv-1273269980c366dae8-2371-40b4-9e76-fe7790caf4bc { MARGIN:0cm 0cm 0pt;} #ygrps-yiv-1273269980 LI.ygrps-yiv-1273269980c366dae8-2371-40b4-9e76-fe7790caf4bc { MARGIN:0cm 0cm 0pt;} #ygrps-yiv-1273269980 DIV.ygrps-yiv-1273269980c366dae8-2371-40b4-9e76-fe7790caf4bc { MARGIN:0cm 0cm 0pt;} #ygrps-yiv-1273269980 TABLE.ygrps-yiv-1273269980c366dae8-2371-40b4-9e76-fe7790caf4bcTable { MARGIN:0cm 0cm 0pt;} #ygrps-yiv-1273269980 DIV.ygrps-yiv-1273269980Section1 { }

This is implemented as a Sequence.

 

In a progress database sequences are first class citizens one can read the value, set and increment the value they are not a table.

In a SQL database sequences are normally handled in another way, but to keep consistency with how progress works it is implemented as Calvin mentioned in the _SEQT tables.

 

This is not something you should be manipulating.

If you do have an issue with sequences i.e. you cannot create a record because the sequence is out of sync with the data say after a dump and load, you run the conversion to reset sequences which can be run at any point in time (but outside of business hours really).

 

Regards,

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of mvissuet@...
Sent: 19 February 2014 00:47
To: vantage@yahoogroups.com
Subject: [Vantage] LaborDtlSeq

 

 

In what data table is the LaborDtlSeq kept?

Or how does Epicor know which one to use next?

 

Epicor 9.05.606

Progress



Stephen Edginton (Beng) | Technical Director

Mobile:  +44 7734 858415
Main:  +44 (0) 121 314 1170
Web:  www.dotnetit.co.uk

Dot Net IT Limited, One St Kenelm Court, Steel Park Road, Halesowen, B62 8HD, United Kingdom.

DotNetIT

Epicor Platinum Partner

Epicor Alliance Partner

2

In what data table is the LaborDtlSeq kept?

Or how does Epicor know which one to use next?

 

Epicor 9.05.606

Progress

3
The LaborDtl table has a field LaborDtlSeq. In my 905 db it is the 4th column in the table. I believe it is maintained by a sequence table: SEQT_LaborDtlSeq


HTH,
Calvin Dekker
[cid:image001.jpg@01CF2CE0.61C48800]<http://www.codabears.com/>
630-672-7688 x1484
[cid:image002.png@01CF2CE0.61C48800] <https://www.facebook.com/CodaBearsInc> [cid:image003.png@01CF2CE0.61C48800] <http://www.linkedin.com/company/codabears-inc> [cid:image004.png@01CF2CE0.61C48800] <https://twitter.com/CodaBearsInc>

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of mvissuet@...
Sent: Tuesday, February 18, 2014 6:47 PM
To: vantage@yahoogroups.com
Subject: [Vantage] LaborDtlSeq



In what data table is the LaborDtlSeq kept?

Or how does Epicor know which one to use next?



Epicor 9.05.606

Progress



[Non-text portions of this message have been removed]
4
LaborDtl table. I believe this field is auto incremented by 1 each time a new LaborDtl record is created.

From: "mvissuet@..." <mvissuet@...>
To: vantage@yahoogroups.com
Sent: Tuesday, February 18, 2014 7:46 PM
Subject: [Vantage] LaborDtlSeq



In what data table is the LaborDtlSeq kept?
Or how does Epicor know which one to use next?
 
Epicor 9.05.606
Progress




5

How does Epicor know what number to use next?

 

 

Marco Vissuet

Systems Engineer

Pacific Contours Corporation

Cell (619)507-2311

Anaheim Office (714) 693-1260

San Diego Office (619)670-3900

Fax (714) 693-1252

mvissuet@...

http://www.pacificcontours.com/

 

"The information contained herein may be subject to the International Traffic in Arms Regulations (ITAR) Warning: - This document contains data whose export is restricted by the Arms Export Control Act (Title 22, U.S.C., Sec 2751, et seq.) as amended, or the Export Administration Act (Title 50, U.S.C., App 2401 et seq.) as amended. Violations of these export laws are subject to severe criminal and civil penalties.  Disseminate in accordance with provisions of DoD Directive 5230.25.

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Ted Koch
Sent: Wednesday, February 19, 2014 7:29 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] LaborDtlSeq

 

 

LaborDtl table. I believe this field is auto incremented by 1 each time a new LaborDtl record is created.

 

From: "mvissuet@..." <mvissuet@...>
To: vantage@yahoogroups.com
Sent: Tuesday, February 18, 2014 7:46 PM
Subject: [Vantage] LaborDtlSeq

 

 

In what data table is the LaborDtlSeq kept?

Or how does Epicor know which one to use next?

 

Epicor 9.05.606

Progress

 

 

 

__________ Information from ESET NOD32 Antivirus, version of virus signature database 9443 (20140219) __________

 

The message was checked by ESET NOD32 Antivirus.

 

http://www.eset.com

6

I don’t think there is a way to set it manually. It is autogenerated and it is more like a record number.

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Marco Vissuet
Sent: Wednesday, February 19, 2014 8:52 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] LaborDtlSeq

 

 

How does Epicor know what number to use next?

 

 

Marco Vissuet

Systems Engineer

Pacific Contours Corporation

Cell (619)507-2311

Anaheim Office (714) 693-1260

San Diego Office (619)670-3900

Fax (714) 693-1252

mvissuet@...

http://www.pacificcontours.com/

 

"The information contained herein may be subject to the International Traffic in Arms Regulations (ITAR) Warning: - This document contains data whose export is restricted by the Arms Export Control Act (Title 22, U.S.C., Sec 2751, et seq.) as amended, or the Export Administration Act (Title 50, U.S.C., App 2401 et seq.) as amended. Violations of these export laws are subject to severe criminal and civil penalties.  Disseminate in accordance with provisions of DoD Directive 5230.25.

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Ted Koch
Sent: Wednesday, February 19, 2014 7:29 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] LaborDtlSeq

 

 

LaborDtl table. I believe this field is auto incremented by 1 each time a new LaborDtl record is created.

 

From: "mvissuet@..." <mvissuet@...>
To: vantage@yahoogroups.com
Sent: Tuesday, February 18, 2014 7:46 PM
Subject: [Vantage] LaborDtlSeq

 

 

In what data table is the LaborDtlSeq kept?

Or how does Epicor know which one to use next?

 

Epicor 9.05.606

Progress

 

 

 

__________ Information from ESET NOD32 Antivirus, version of virus signature database 9443 (20140219) __________

 

The message was checked by ESET NOD32 Antivirus.

 

http://www.eset.com