Skip to main content
Skip table of contents

Interface to Order Entry - SIUTIN

This utility is an interface that will insert new warehouse orders directly into the SI Create/Update Orders (SIOEUB) page. The utility reads a data file with the assistance of a driver file. Typically, the driver file is named SIFLDRVR and is highly configurable and customizable. The driver file can be loaded via the Remote lookup functionality. The system will process data formatted as a .prn delimited file (per the driver file). While the driver file may be considered static, because it is not accessible to the average user, the SIUTIN template may be updated, accessed remotely, and used repeatedly.

The data file will typically start as an Excel file with columns defined to match the driver file configuration settings. Save the file with the desired extension, such as .prn (modify the driver file to define other delimited file types).

Running the process in Trial mode will verify the definitions. Uncheck the Trial Run box to commit to run. On successful uploads, the tail sheet will state the order number with a message, "Creating order # [order number]." Then view the order in SIOEUB. If all looks well, update record(s) and process as usual. If the record is not as expected, use the menu option "Delete Record," update the data file, and resubmit the file.

File Layout                                                                                                                                                            

 

SecCd

 
 

ApprCd

 
 

Whse

 
 

PriceCalc

 
 

PEID

 
 

PO

 
 

PEAddrCd

 
 

Qty

 
 

ProdID

 
 

GLKey

 
 

GLKey

 
 

GlObj

 
 

JLKey

 
 

JLKey

 
 

JLObj

 
 

PriceCd

 
                                               
 

5001

 
 

APRV

 
 

0001

 
  

JRP

 
   

1

 
 

000010

 
 

GL

 
 

161119

 
 

1000

 
 

JL

 
           

ANNE KHALER

 
          

PR

 
         

AP

 
           

02072002

 
  

P

 
       0000 #END#  
 

5001

 
 

APRV

 
 

0001

 
  

JRP

 
   

2

 
 

000010

 
 

GL

 
 

144490

 
 

2500

 
 

JL

 
           

BRT GOLDEN

 
          

PR

 
         

AP

 
           

02072002

 
  

P

 
       0000 #END#  
 

5001

 
 

APRV

 
 

0001

 
  

JRP

 
   

3

 
 

000010

 
 

GL

 
 

145458

 
 

2000

 
 

JL

 
           

CELDES S R L

 
          

PR

 
         

AP

 
           

02072002

 
  

P

 
       0000 #END#  
 

5001

 
 

APRV

 
 

0001

 
  

JRP

 
   

1

 
 

000010

 
 

GL

 
 

122454

 
 

2000

 
 

JL

 
           

D A INFORMATION SERVICES PTY

 
          

PR

 
         

AP

 
           

02072002

 
  

P

 
       0000 #END#  
 

5001

 
 

APRV

 
 

0001

 
  

JRP

 
   

2

 
 

000010

 
 

GL

 
 

121181

 
 

2000

 
 

JL

 
           

EBSCO SUBSCRIPTION SERVICES

 
          

PR

 
         

AP

 
           

02072002

 
  

P

 
       0000 #END#  
 

5001

 
 

APRV

 
 

0001

 
  

JRP

 
   

1

 
 

000010

 
 

GL

 
 

121846

 
 

2500

 
 

JL

 
           

EBSCO SUBSCRIPTION SERVICES

 
          

PR

 
         

AP

 
           

02072002

 
  

P

 
       0000 #END#  
 

5001

 
 

APRV

 
 

0001

 
  

JRP

 
   

2

 
 

000010

 
 

GL

 
 

112909

 
 

2500

 
 

JL

 
           

EBSCO SUBSCRIPTION SERVICES

 
          

PR

 
         

AP

 
           

02072002

 
  

P

 
       0000 #END#  
 

5001

 
 

APRV

 
 

0001

 
  

JRP

 
   

3

 
 

000010

 
 

GL

 
 

121182

 
 

2500

 
 

JL

 
           

EBSCO SUBSCRIPTION SERVICES

 
          

PR

 
         

AP

 
           

02072002

 
  

P

 
       0000 #END#  
 

5001

 
 

APRV

 
 

0001

 
  

JRP

 
   

4

 
 

000010

 
 

GL

 
 

123067

 
 

2500

 
 

JL

 
           

EBSCO SUBSCRIPTION SERVICES

 
          

PR

 
         

AP

 
           

02072002

 
  

P

 
       0000 #END#  

 

 

 

 

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.