Re: Line #s Order Invoice

Al,

You are correct that sil.ilseq equals ecl.lline.

As far as rar.rseq it is a sequence number that is defined by the
activity from the cash posting program.

If the invoice is not a credit against an original invoice then rar.rseq
will be equal to zero (0).

-----Original Message-----
From: bpcs-l-bounces+dsweeney=phoenixbcinc.com@xxxxxxxxxxxx
[mailto:bpcs-l-bounces+dsweeney=phoenixbcinc.com@xxxxxxxxxxxx] On Behalf
Of Al Mac Wheel
Sent: Friday, May 30, 2008 10:12 AM
To: BPCS ERP Discussion List
Subject: [BPCS-L] Line #s Order Invoice

I'm working on a modification in 405 CD which involves a report
generated
off of invoices hitting RAR in which I need to get at line #s in SIL
invoice and original ECL order.

Am I correct that SIL.ILSEQ points at ECL.LLINE?
What does RAR.RSEQ point at?
Regardless of the # of lines on SIL invoice, does the whole invoice end
up
being a single record of RAR?

As orders get satisfied, the order lines & orders get coded complete,
ready
to purge.
When does this purge normally occur ... during end fiscal month, or as
soon
as an order has been completely filled shipped billed?

Orders have a description which defaults to item description from item
master, but for some customers, we substitute info, specific to the line
#s
of the customer purchase order, which shows up on billing invoice, and I

need to go back to the ECL to access in later reports, so I'm interested
in
how long the customer order remains in the system.
-
Al Mac