Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

IM Distribution File (IMDISFIL_SQL) 2

Status
Not open for further replies.

zedsded

IS-IT--Management
Jun 9, 2002
68
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!
 
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
 
Tom,
Thank you very much!
 
Hi Tom?
Can you tell me which table can get START_JNL_HIST_NO ?
 
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.
 
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.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top