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.