IM Distribution File (IMDISFIL_SQL) 2

[zedsded]

Hello!
Macola 7.6.400a - SQL
Does anyone know what reference numbers or from which field/table is being used to populate the following fields in IMDISFIL?
1. id_no
2. jnl_src

Thanks a bunch!

 

[TomWG]

The id_no is the index(key) from a transaction file which ties to the IM Dist record. Made up of (Source)+(Order_No)+(Control_No)+(Line_No)+(Level_No)+(Seq_No)

The jnl_src is a combination of a source pkg prefix(ie IM) and a sequential journal number START_JNL_HIST_NO which it get from the company control file COMPFIL.BTR

 

[zedsded]

Tom,
Thank you very much!

 

[MTracer]

Hi Tom?
Can you tell me which table can get START_JNL_HIST_NO ?

 

[dgillz]

Compfile_sql

Software Sales, Training, Implementation and Support for Macola, Synergy, and Crystal Reports. Check out our Macola tools:

http://www.gainfocus.biz/exceladdin.html

 

[MTracer]

Hi dgillz,
Thank you very much.Do you know which table and field I can get source pkg prefix?I checked imctlfil_sql table and found nothing.

 

[dgillz]

Rain,

There are several tables with this info. What are you trying to do?

Software Sales, Training, Implementation and Support for Macola, Synergy, and Crystal Reports. Check out our Macola tools:

http://www.gainfocus.biz/exceladdin.html

 

[MTracer]

I traced the Confirm shipping and set oe order status to 7.I need to insert data to the table imdisfil_sql.So I want to konw where the fields come from.Thanks.