Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Global Autoincrement Problem

2 posts in General Discussion Last posting was on 2003-07-28 14:04:31.0Z
Mohammad Alhabibi Posted on 2003-07-27 12:06:57.0Z
From: "Mohammad Alhabibi" <mah@doubleclick.com.eg>
Newsgroups: ianywhere.public.general
Subject: Global Autoincrement Problem
Lines: 250
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
NNTP-Posting-Host: 212.122.226.168
X-Original-NNTP-Posting-Host: 212.122.226.168
Message-ID: <3f23c061@forums-1-dub>
Date: 27 Jul 2003 05:06:57 -0700
X-Trace: forums-1-dub 1059307617 212.122.226.168 (27 Jul 2003 05:06:57 -0700)
X-Original-Trace: 27 Jul 2003 05:06:57 -0700, 212.122.226.168
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:1471
Article PK: 3701

I'm using Sybase Adaptive Server Anywhere Version 7.0.4.2788

I've two databases replicating data using sqlremote.

Both DBs have "Global_database_id = 1 " and all primary keys in all tables
consists of one column of type bigint with gobal autoincrement (10000000)
so the start value should be 10000001.

in my case the Table "asa_invoice_header" has the column "header_serial"
primary key of type bigint with gobal autoincrement (10000000)
the values of this column starts from 10000001 until reaches 10001306 then
the next value becomes 1 and continue to increment until reaches 9 then it
backs to 10001307.

what cause the generated value to be 1 instead of 10001307?

the following is the output of sqlremote agent:

I. 07/16 20:06:38. INSERT INTO
dbo.asa_invoice_header(header_serial,period_id,invoice_type_id,

invoice_book_id,invoice_number,notes,invoice_date,site_id,salesrep_id,

manual_number,asc_serial,agl_serial,payment_date,currency_id,
exchange_rate)
VALUES
(10001300,4,10000013,10000005,272,NULL,'2003/07/02',10000642,NULL,114,NULL,N
ULL,'2003/07/15',NULL,NULL)

I. 07/16 20:06:39. INSERT INTO
dbo.asa_invoice_header(header_serial,period_id,invoice_type_id,

invoice_book_id,invoice_number,notes,invoice_date,site_id,salesrep_id,

manual_number,asc_serial,agl_serial,payment_date,currency_id,
exchange_rate)
VALUES
(10001303,4,10000013,10000005,273,NULL,'2003/07/16',10000309,NULL,NULL,NULL,
NULL,'2003/07/16',NULL,NULL)

I. 07/16 20:06:39. INSERT INTO
dbo.asa_invoice_header(header_serial,period_id,invoice_type_id,

invoice_book_id,invoice_number,notes,invoice_date,site_id,salesrep_id,

manual_number,asc_serial,agl_serial,payment_date,currency_id,
exchange_rate)
VALUES
(10001304,4,10000013,10000005,274,NULL,'2003/07/16',10000313,NULL,NULL,NULL,
NULL,'2003/07/16',NULL,NULL)

I. 07/16 20:06:39. INSERT INTO
dbo.asa_invoice_header(header_serial,period_id,invoice_type_id,

invoice_book_id,invoice_number,notes,invoice_date,site_id,salesrep_id,

manual_number,asc_serial,agl_serial,payment_date,currency_id,
exchange_rate)
VALUES
(10001305,4,10000013,10000005,275,NULL,'2003/07/16',10000526,NULL,NULL,NULL,
NULL,'2003/07/16',NULL,NULL)

I. 07/16 20:06:40. INSERT INTO
dbo.asa_invoice_header(header_serial,period_id,invoice_type_id,

invoice_book_id,invoice_number,notes,invoice_date,site_id,salesrep_id,

manual_number,asc_serial,agl_serial,payment_date,currency_id,
exchange_rate)
VALUES
(10001306,4,10000013,10000005,276,NULL,'2003/07/16',10000441,NULL,NULL,NULL,
NULL,'2003/07/16',NULL,NULL)

I. 07/16 20:06:40. INSERT INTO
dbo.asa_invoice_header(header_serial,period_id,invoice_type_id,

invoice_book_id,invoice_number,notes,invoice_date,site_id,salesrep_id,

manual_number,asc_serial,agl_serial,payment_date,currency_id,
exchange_rate)
VALUES
(1,4,10000013,10000005,277,NULL,'2003/07/16',10000621,NULL,NULL,NULL,NULL,'2
003/07/16',NULL,NULL)

I. 07/16 20:06:41. INSERT INTO
dbo.asa_invoice_header(header_serial,period_id,invoice_type_id,

invoice_book_id,invoice_number,notes,invoice_date,site_id,salesrep_id,

manual_number,asc_serial,agl_serial,payment_date,currency_id,
exchange_rate)
VALUES
(2,4,10000013,10000005,278,NULL,'2003/07/16',10000344,NULL,NULL,NULL,NULL,'2
003/07/16',NULL,NULL)

I. 07/16 20:06:41. INSERT INTO
dbo.asa_invoice_header(header_serial,period_id,invoice_type_id,

invoice_book_id,invoice_number,notes,invoice_date,site_id,salesrep_id,

manual_number,asc_serial,agl_serial,payment_date,currency_id,
exchange_rate)
VALUES
(3,4,10000013,10000005,279,NULL,'2003/07/16',10000499,NULL,NULL,NULL,NULL,'2
003/07/16',NULL,NULL)

I. 07/16 20:06:41. INSERT INTO
dbo.asa_invoice_header(header_serial,period_id,invoice_type_id,

invoice_book_id,invoice_number,notes,invoice_date,site_id,salesrep_id,

manual_number,asc_serial,agl_serial,payment_date,currency_id,
exchange_rate)
VALUES
(4,4,10000012,10000004,165,NULL,'2003/07/15',10000600,10000013,NULL,NULL,NUL
L,'2003/07/16',NULL,NULL)

I. 07/16 20:07:42. INSERT INTO
dbo.asa_invoice_header(header_serial,period_id,invoice_type_id,

invoice_book_id,invoice_number,notes,invoice_date,site_id,salesrep_id,

manual_number,asc_serial,agl_serial,payment_date,currency_id,
exchange_rate)
VALUES
(5,4,10000013,10000005,280,NULL,'2003/07/16',10000543,NULL,NULL,NULL,NULL,'2
003/07/16',NULL,NULL)

I. 07/16 20:07:43. INSERT INTO
dbo.asa_invoice_header(header_serial,period_id,invoice_type_id,

invoice_book_id,invoice_number,notes,invoice_date,site_id,salesrep_id,

manual_number,asc_serial,agl_serial,payment_date,currency_id,
exchange_rate)
VALUES
(6,4,10000012,10000005,281,NULL,'2003/07/16',10000465,NULL,NULL,NULL,NULL,'2
003/07/16',NULL,NULL)

I. 07/16 20:07:43. INSERT INTO
dbo.asa_invoice_header(header_serial,period_id,invoice_type_id,

invoice_book_id,invoice_number,notes,invoice_date,site_id,salesrep_id,

manual_number,asc_serial,agl_serial,payment_date,currency_id,
exchange_rate)
VALUES
(7,4,10000013,10000005,282,NULL,'2003/07/17',10000306,NULL,NULL,NULL,NULL,'2
003/07/17',NULL,NULL)

I. 07/16 20:07:43. INSERT INTO
dbo.asa_invoice_header(header_serial,period_id,invoice_type_id,

invoice_book_id,invoice_number,notes,invoice_date,site_id,salesrep_id,

manual_number,asc_serial,agl_serial,payment_date,currency_id,
exchange_rate)
VALUES
(8,4,10000013,10000005,282,NULL,'2003/07/12',10000306,NULL,NULL,NULL,NULL,'2
003/07/12',NULL,NULL)

I. 07/16 20:07:43. INSERT INTO
dbo.asa_invoice_header(header_serial,period_id,invoice_type_id,

invoice_book_id,invoice_number,notes,invoice_date,site_id,salesrep_id,

manual_number,asc_serial,agl_serial,payment_date,currency_id,
exchange_rate)
VALUES
(9,4,10000013,10000005,283,NULL,'2003/07/13',10000647,NULL,NULL,NULL,NULL,'2
003/07/13',NULL,NULL)

I. 07/21 17:42:57. INSERT INTO
dbo.asa_invoice_header(header_serial,period_id,invoice_type_id,

invoice_book_id,invoice_number,notes,invoice_date,site_id,salesrep_id,

manual_number,asc_serial,agl_serial,payment_date,currency_id,
exchange_rate)
VALUES
(10001307,4,10000012,10000004,166,NULL,'2003/07/15',10000600,10000013,NULL,N
ULL,NULL,'2003/07/17',NULL,NULL)

I. 07/21 17:43:05. INSERT INTO
dbo.asa_invoice_header(header_serial,period_id,invoice_type_id,

invoice_book_id,invoice_number,notes,invoice_date,site_id,salesrep_id,

manual_number,asc_serial,agl_serial,payment_date,currency_id,
exchange_rate)
VALUES
(10001308,4,10000013,10000005,284,NULL,'2003/07/17',10000579,NULL,NULL,NULL,
NULL,'2003/07/17',NULL,NULL)

I. 07/21 17:43:05. INSERT INTO
dbo.asa_invoice_header(header_serial,period_id,invoice_type_id,

invoice_book_id,invoice_number,notes,invoice_date,site_id,salesrep_id,

manual_number,asc_serial,agl_serial,payment_date,currency_id,
exchange_rate)
VALUES
(10001309,4,10000013,10000005,285,NULL,'2003/07/17',10000578,NULL,NULL,NULL,
NULL,'2003/07/17',NULL,NULL)

I. 07/21 17:43:06. INSERT INTO
dbo.asa_invoice_header(header_serial,period_id,invoice_type_id,

invoice_book_id,invoice_number,notes,invoice_date,site_id,salesrep_id,

manual_number,asc_serial,agl_serial,payment_date,currency_id,
exchange_rate)
VALUES
(10001310,4,10000012,10000004,167,NULL,'2003/07/15',10000600,10000013,NULL,N
ULL,NULL,'2003/07/17',NULL,NULL)

I. 07/21 17:43:07. INSERT INTO
dbo.asa_invoice_header(header_serial,period_id,invoice_type_id,

invoice_book_id,invoice_number,notes,invoice_date,site_id,salesrep_id,

manual_number,asc_serial,agl_serial,payment_date,currency_id,
exchange_rate)
VALUES
(10001311,4,10000012,10000004,168,NULL,'2003/07/15',10000600,10000013,NULL,N
ULL,NULL,'2003/07/17',NULL,NULL)

I. 07/21 17:43:08. INSERT INTO
dbo.asa_invoice_header(header_serial,period_id,invoice_type_id,

invoice_book_id,invoice_number,notes,invoice_date,site_id,salesrep_id,

manual_number,asc_serial,agl_serial,payment_date,currency_id,
exchange_rate)
VALUES
(10001312,4,10000013,10000005,286,NULL,'2003/07/17',10000544,NULL,NULL,NULL,
NULL,'2003/07/17',NULL,NULL)

I. 07/21 17:43:09. INSERT INTO
dbo.asa_invoice_header(header_serial,period_id,invoice_type_id,

invoice_book_id,invoice_number,notes,invoice_date,site_id,salesrep_id,

manual_number,asc_serial,agl_serial,payment_date,currency_id,
exchange_rate)
VALUES
(10001313,4,10000012,10000004,169,NULL,'2003/07/15',10000600,10000015,NULL,N
ULL,NULL,'2003/07/17',NULL,NULL)


Robert Waywell Posted on 2003-07-28 14:04:31.0Z
From: "Robert Waywell" <nospam_rwaywell@ianywhere.com>
Newsgroups: ianywhere.public.general
References: <3f23c061@forums-1-dub>
Subject: Re: Global Autoincrement Problem
Lines: 319
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
NNTP-Posting-Host: rwaywell-pc.sybase.com
X-Original-NNTP-Posting-Host: rwaywell-pc.sybase.com
Message-ID: <3f252d6f@forums-1-dub>
Date: 28 Jul 2003 07:04:31 -0700
X-Trace: forums-1-dub 1059401071 172.31.143.74 (28 Jul 2003 07:04:31 -0700)
X-Original-Trace: 28 Jul 2003 07:04:31 -0700, rwaywell-pc.sybase.com
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:1472
Article PK: 3702

1) If you have 2 separate databases, both using Global_database_id = 1, then
you have broken the system. This will result in duplicate key values. Each
database in the system needs to have a unique value for Global_database_id.

2) Are there only 2 databases, or is that 2 remotes plus 1 consolidated db?

3) Which database is the dbremote output from?

You are showing the dbremote output which simply indicates that someone,
somewhere inserted records with PK values of 1, 2, 3, ... and which
qualified to be published to the database that dbremote is running against
at the time this output is shown. A possible scenario would be for the
consolidated database to have a Global_database_id = 0, in which case the
values generated would start at 1. Another possible scenario would be for
the application/user to explicitly provide values for the PK column, in
which case the default will not override the provided value.

--
-----------------------------------------------
Robert Waywell
Sybase Adaptive Server Anywhere Developer - Version 8
Sybase Certified Professional

Sybase's iAnywhere Solutions

Please respond ONLY to newsgroup

Sybase TechWave User Training and Solutions conference -- August 4 - 8, 2003
in Orlando, FL. -- A great place for education and in-depth discussions
on all our technology, future trends in the market, not to mention getting
time with the engineers who create the products! For more information,
visit http://www.ianywhere.com/techwave2003

EBF's and Patches: http://downloads.sybase.com
choose SQL Anywhere Studio >> change 'time frame' to all

To Submit Bug Reports: http://casexpress.sybase.com/cx/cx.stm

SQL Anywhere Studio Supported Platforms and Support Status
http://my.sybase.com/detail?id=1002288

Whitepapers, TechDocs, and bug fixes are all available through the iAnywhere
Developer Community at www.ianywhere.com/developer

"Mohammad Alhabibi" <mah@doubleclick.com.eg> wrote in message
news:3f23c061@forums-1-dub...
> I'm using Sybase Adaptive Server Anywhere Version 7.0.4.2788
>
> I've two databases replicating data using sqlremote.
>
> Both DBs have "Global_database_id = 1 " and all primary keys in all tables
> consists of one column of type bigint with gobal autoincrement (10000000)
> so the start value should be 10000001.
>
> in my case the Table "asa_invoice_header" has the column "header_serial"
> primary key of type bigint with gobal autoincrement (10000000)
> the values of this column starts from 10000001 until reaches 10001306 then
> the next value becomes 1 and continue to increment until reaches 9 then it
> backs to 10001307.
>
> what cause the generated value to be 1 instead of 10001307?
>
> the following is the output of sqlremote agent:
>
> I. 07/16 20:06:38. INSERT INTO
> dbo.asa_invoice_header(header_serial,period_id,invoice_type_id,
>
> invoice_book_id,invoice_number,notes,invoice_date,site_id,salesrep_id,
>
> manual_number,asc_serial,agl_serial,payment_date,currency_id,
> exchange_rate)
> VALUES
>
(10001300,4,10000013,10000005,272,NULL,'2003/07/02',10000642,NULL,114,NULL,N
> ULL,'2003/07/15',NULL,NULL)
>
> I. 07/16 20:06:39. INSERT INTO
> dbo.asa_invoice_header(header_serial,period_id,invoice_type_id,
>
> invoice_book_id,invoice_number,notes,invoice_date,site_id,salesrep_id,
>
> manual_number,asc_serial,agl_serial,payment_date,currency_id,
> exchange_rate)
> VALUES
>
(10001303,4,10000013,10000005,273,NULL,'2003/07/16',10000309,NULL,NULL,NULL,
> NULL,'2003/07/16',NULL,NULL)
>
> I. 07/16 20:06:39. INSERT INTO
> dbo.asa_invoice_header(header_serial,period_id,invoice_type_id,
>
> invoice_book_id,invoice_number,notes,invoice_date,site_id,salesrep_id,
>
> manual_number,asc_serial,agl_serial,payment_date,currency_id,
> exchange_rate)
> VALUES
>
(10001304,4,10000013,10000005,274,NULL,'2003/07/16',10000313,NULL,NULL,NULL,
> NULL,'2003/07/16',NULL,NULL)
>
> I. 07/16 20:06:39. INSERT INTO
> dbo.asa_invoice_header(header_serial,period_id,invoice_type_id,
>
> invoice_book_id,invoice_number,notes,invoice_date,site_id,salesrep_id,
>
> manual_number,asc_serial,agl_serial,payment_date,currency_id,
> exchange_rate)
> VALUES
>
(10001305,4,10000013,10000005,275,NULL,'2003/07/16',10000526,NULL,NULL,NULL,
> NULL,'2003/07/16',NULL,NULL)
>
> I. 07/16 20:06:40. INSERT INTO
> dbo.asa_invoice_header(header_serial,period_id,invoice_type_id,
>
> invoice_book_id,invoice_number,notes,invoice_date,site_id,salesrep_id,
>
> manual_number,asc_serial,agl_serial,payment_date,currency_id,
> exchange_rate)
> VALUES
>
(10001306,4,10000013,10000005,276,NULL,'2003/07/16',10000441,NULL,NULL,NULL,
> NULL,'2003/07/16',NULL,NULL)
>
> I. 07/16 20:06:40. INSERT INTO
> dbo.asa_invoice_header(header_serial,period_id,invoice_type_id,
>
> invoice_book_id,invoice_number,notes,invoice_date,site_id,salesrep_id,
>
> manual_number,asc_serial,agl_serial,payment_date,currency_id,
> exchange_rate)
> VALUES
>
(1,4,10000013,10000005,277,NULL,'2003/07/16',10000621,NULL,NULL,NULL,NULL,'2
> 003/07/16',NULL,NULL)
>
> I. 07/16 20:06:41. INSERT INTO
> dbo.asa_invoice_header(header_serial,period_id,invoice_type_id,
>
> invoice_book_id,invoice_number,notes,invoice_date,site_id,salesrep_id,
>
> manual_number,asc_serial,agl_serial,payment_date,currency_id,
> exchange_rate)
> VALUES
>
(2,4,10000013,10000005,278,NULL,'2003/07/16',10000344,NULL,NULL,NULL,NULL,'2
> 003/07/16',NULL,NULL)
>
> I. 07/16 20:06:41. INSERT INTO
> dbo.asa_invoice_header(header_serial,period_id,invoice_type_id,
>
> invoice_book_id,invoice_number,notes,invoice_date,site_id,salesrep_id,
>
> manual_number,asc_serial,agl_serial,payment_date,currency_id,
> exchange_rate)
> VALUES
>
(3,4,10000013,10000005,279,NULL,'2003/07/16',10000499,NULL,NULL,NULL,NULL,'2
> 003/07/16',NULL,NULL)
>
> I. 07/16 20:06:41. INSERT INTO
> dbo.asa_invoice_header(header_serial,period_id,invoice_type_id,
>
> invoice_book_id,invoice_number,notes,invoice_date,site_id,salesrep_id,
>
> manual_number,asc_serial,agl_serial,payment_date,currency_id,
> exchange_rate)
> VALUES
>
(4,4,10000012,10000004,165,NULL,'2003/07/15',10000600,10000013,NULL,NULL,NUL
> L,'2003/07/16',NULL,NULL)
>
> I. 07/16 20:07:42. INSERT INTO
> dbo.asa_invoice_header(header_serial,period_id,invoice_type_id,
>
> invoice_book_id,invoice_number,notes,invoice_date,site_id,salesrep_id,
>
> manual_number,asc_serial,agl_serial,payment_date,currency_id,
> exchange_rate)
> VALUES
>
(5,4,10000013,10000005,280,NULL,'2003/07/16',10000543,NULL,NULL,NULL,NULL,'2
> 003/07/16',NULL,NULL)
>
> I. 07/16 20:07:43. INSERT INTO
> dbo.asa_invoice_header(header_serial,period_id,invoice_type_id,
>
> invoice_book_id,invoice_number,notes,invoice_date,site_id,salesrep_id,
>
> manual_number,asc_serial,agl_serial,payment_date,currency_id,
> exchange_rate)
> VALUES
>
(6,4,10000012,10000005,281,NULL,'2003/07/16',10000465,NULL,NULL,NULL,NULL,'2
> 003/07/16',NULL,NULL)
>
> I. 07/16 20:07:43. INSERT INTO
> dbo.asa_invoice_header(header_serial,period_id,invoice_type_id,
>
> invoice_book_id,invoice_number,notes,invoice_date,site_id,salesrep_id,
>
> manual_number,asc_serial,agl_serial,payment_date,currency_id,
> exchange_rate)
> VALUES
>
(7,4,10000013,10000005,282,NULL,'2003/07/17',10000306,NULL,NULL,NULL,NULL,'2
> 003/07/17',NULL,NULL)
>
> I. 07/16 20:07:43. INSERT INTO
> dbo.asa_invoice_header(header_serial,period_id,invoice_type_id,
>
> invoice_book_id,invoice_number,notes,invoice_date,site_id,salesrep_id,
>
> manual_number,asc_serial,agl_serial,payment_date,currency_id,
> exchange_rate)
> VALUES
>
(8,4,10000013,10000005,282,NULL,'2003/07/12',10000306,NULL,NULL,NULL,NULL,'2
> 003/07/12',NULL,NULL)
>
> I. 07/16 20:07:43. INSERT INTO
> dbo.asa_invoice_header(header_serial,period_id,invoice_type_id,
>
> invoice_book_id,invoice_number,notes,invoice_date,site_id,salesrep_id,
>
> manual_number,asc_serial,agl_serial,payment_date,currency_id,
> exchange_rate)
> VALUES
>
(9,4,10000013,10000005,283,NULL,'2003/07/13',10000647,NULL,NULL,NULL,NULL,'2
> 003/07/13',NULL,NULL)
>
> I. 07/21 17:42:57. INSERT INTO
> dbo.asa_invoice_header(header_serial,period_id,invoice_type_id,
>
> invoice_book_id,invoice_number,notes,invoice_date,site_id,salesrep_id,
>
> manual_number,asc_serial,agl_serial,payment_date,currency_id,
> exchange_rate)
> VALUES
>
(10001307,4,10000012,10000004,166,NULL,'2003/07/15',10000600,10000013,NULL,N
> ULL,NULL,'2003/07/17',NULL,NULL)
>
> I. 07/21 17:43:05. INSERT INTO
> dbo.asa_invoice_header(header_serial,period_id,invoice_type_id,
>
> invoice_book_id,invoice_number,notes,invoice_date,site_id,salesrep_id,
>
> manual_number,asc_serial,agl_serial,payment_date,currency_id,
> exchange_rate)
> VALUES
>
(10001308,4,10000013,10000005,284,NULL,'2003/07/17',10000579,NULL,NULL,NULL,
> NULL,'2003/07/17',NULL,NULL)
>
> I. 07/21 17:43:05. INSERT INTO
> dbo.asa_invoice_header(header_serial,period_id,invoice_type_id,
>
> invoice_book_id,invoice_number,notes,invoice_date,site_id,salesrep_id,
>
> manual_number,asc_serial,agl_serial,payment_date,currency_id,
> exchange_rate)
> VALUES
>
(10001309,4,10000013,10000005,285,NULL,'2003/07/17',10000578,NULL,NULL,NULL,
> NULL,'2003/07/17',NULL,NULL)
>
> I. 07/21 17:43:06. INSERT INTO
> dbo.asa_invoice_header(header_serial,period_id,invoice_type_id,
>
> invoice_book_id,invoice_number,notes,invoice_date,site_id,salesrep_id,
>
> manual_number,asc_serial,agl_serial,payment_date,currency_id,
> exchange_rate)
> VALUES
>
(10001310,4,10000012,10000004,167,NULL,'2003/07/15',10000600,10000013,NULL,N
> ULL,NULL,'2003/07/17',NULL,NULL)
>
> I. 07/21 17:43:07. INSERT INTO
> dbo.asa_invoice_header(header_serial,period_id,invoice_type_id,
>
> invoice_book_id,invoice_number,notes,invoice_date,site_id,salesrep_id,
>
> manual_number,asc_serial,agl_serial,payment_date,currency_id,
> exchange_rate)
> VALUES
>
(10001311,4,10000012,10000004,168,NULL,'2003/07/15',10000600,10000013,NULL,N
> ULL,NULL,'2003/07/17',NULL,NULL)
>
> I. 07/21 17:43:08. INSERT INTO
> dbo.asa_invoice_header(header_serial,period_id,invoice_type_id,
>
> invoice_book_id,invoice_number,notes,invoice_date,site_id,salesrep_id,
>
> manual_number,asc_serial,agl_serial,payment_date,currency_id,
> exchange_rate)
> VALUES
>
(10001312,4,10000013,10000005,286,NULL,'2003/07/17',10000544,NULL,NULL,NULL,
> NULL,'2003/07/17',NULL,NULL)
>
> I. 07/21 17:43:09. INSERT INTO
> dbo.asa_invoice_header(header_serial,period_id,invoice_type_id,
>
> invoice_book_id,invoice_number,notes,invoice_date,site_id,salesrep_id,
>
> manual_number,asc_serial,agl_serial,payment_date,currency_id,
> exchange_rate)
> VALUES
>
(10001313,4,10000012,10000004,169,NULL,'2003/07/15',10000600,10000015,NULL,N
> ULL,NULL,'2003/07/17',NULL,NULL)
>
>