Stores Format Definition - SIUPFO

The Stores/Inventory (SI) Stores Format Definition (SIUPFO) page is used to define the print layout of Pick Tickets and Packing Slips. The Detail portion of this form is used to define the repetitive format ("the body") of the form.  Line Numbers ("Line No"), on the lower portion of the page, are used to define items – header or footer information, etc. – to be printed on the part of the form that is not involved with repetitive detail.

Format ID: A two-character code identifying the form defined.
Description: A description of the form being defined using up to 30 characters
Ledger: Select the ledger code from the drop-down list for which the Format ID relates.
Continuation Format: If the second and following pages of the form are of a different format, an additional format can be created for the text. The two-character Format ID for the continuation format is to be entered in this field.
Detail Start Line: Enter the line number for the first printable detail line number on the form.  Note that while the field will accept a 5-digit number, the average page may hold about 28 lines and then less the number of lines used for the form's reporting features, e.g., Customer ID, purchase order number, order total, etc.
Number of Detail Lines: The total number of detail lines to appear on the form. 
Pick Ticket? Check this box if this is the format for a Pick Ticket. If the Pick Ticket number is blank on the order, a checkmark in this field will cause the Pick Ticket number to be generated.  Leaving this box blank indicates that this is a Packing Slip format.  Pick Tickets may only be printed for orders that are not completely filled (status "FL") and Packing Slips may only be printed if the order has been filled (status in not "NW" or "PN").
Detail: The Detail portion of this form is used to define how the repetitive item detail, "the body" of the form, will be printed.
Item: Enter the Item ID of the field to place on this "Line No". Below are lists of the fields that may be printed on a form and their corresponding ID.
Start: Enter the starting position on the line (001 - 132) for the "Item" field on the form.
Len: Enter the length of the field (number of characters) to be printed for the "Item" on this "Line No".
Line No: For the form being defined, enter the line number on which to place the "Item." Items – such as header or footer information, etc. – to be printed on the part of the form that is not involved with repetitive detail.
Item: Enter the Item ID of the field to place on this "Line No". Below are lists of the fields that may be printed on a form and their corresponding ID.
Start: Enter the starting position on the line (001 - 132) for the "Item" field on the form.
Len: Enter the length of the field (number of characters) to be printed for the "Item" on this "Line No".

Field Item IDs and Names

Order Information
01 - Order Number
02 - Pick ticket Number
03 - Customer ID
04 - Customer Name
05 - Customer Address line 1
06 - Customer Address Line 2
07 - Customer Address Line 3
08 - Customer Address Line 4
09 - Customer Address Line 5
10 - Customer Contact Person
11 - Order Status
12 - Order Status Description
13 - Security Code
14 - Security Description
15 - Requested By
16 - Requested By Date
17 - Approved By
18 - Approved By Date
19 - Approval Code
20 - Order Description
21 - Contact Person on Order
22 - End Use
23 - Required Date
24 - Prep ID
25 - Customer Type
26 - Customer PO #
27 - Misc Code
28 - Purchase PR #

Order Item Information
29 - Order Item Number
30 - Units
31 - Quantity Ordered
32 - Quantity Shipped
33 - Product ID
34 - Description
35 - Warehouse ID
36 - Warehouse Desc
37 - Unit Price
38 - Charge Amount (Item Tot)
39 - Tax Rate
40 - Tax Amount (Item Total)
41 - Discount Rate
42 - Discount Amount (Item Tot)
43 - Item Total
44 - Item Balance
45 - Posting Code
46 - Work Order #
47 - GL Ledger Code
48 - JL Ledger Code
49 - GL Account Key
50 - JL Account Key
51 - GL Object Code
52 - JL Object Code
53 - Fully Qualified GL Account
54 - Fully Qualified JL Account
55 - Bin Number
56 - Floor Number
57 - Row Number
58 - Shelf Number
98 - Quantity Backordered
99 - Quantity on-hand (Uncommitted)
100- Pick Quantity
101 - Quantity in Stock

Product Information
59 - Commodity Code
60 - Class
61 - Primary Vendor ID
62 - Primary Vendor Name
63 - Buyer ID
64 - Buyer Name
65 - Unit Size
66 - Unit Weight
67 - Retail Price
68 - Product Status
69 - Carrying Cost %
70 - Ordering Cost

Additional Information
71 - Comment Line One
72 - Comment Line Two
73 - Current Date
74 - Current Time Hr:Mn (AM or PM)
75 - Page Number
76 - Work Order Description
77 - GL Key Description
78 - GL Object Description
79 - JL Key Description
80 - JL Object Description
81 - Terminal Device Number
82 - Client Name
83 - Warehouse Name
84 - Warehouse Address Line 1
85 - Warehouse Address Line 2
86 - Warehouse Address Line 3
87 - Warehouse Office Phone
88 - Warehouse Floor Phone

Total Information
89 - Total Discount on Order
90 - Total Tax Amount on Order
91 - Total Charges on Order
92 - Total Item Total
93 - Total Item Balance
94 - Total Units on Order
95 - Total Product Weight (Lbs.)
96 - Total Weight of Order (Lbs.)
97 - Subtotal
201-250 Order Code Descriptions (Common Code Category SIOC)
251-300 Global Printing Definitions (Common Code Category SIPT)