HP RPG/iX Utilities Reference Manual (30318-90006)

8- 81
A breakdown of the files to be sorted and their contents precedes the discussion.
Record Format for Weekly Sales File
Record Format for Weekly Bookings File
Files Records in File Fields Used in Sorts
Weekly Sales Detail sales records. Date, customer, product, quantity
Weekly Bookings Detail booking records. Date, customer, product, quantity
Sales and Bookings Summary sales and history Date, customer, product, bookings. quantity.
Field
Names
Contents
Record
Positions
RECCDE Record "WS" 1 -2
INVNUM Invoice Number 3 -8
INVDAY Invoice data - day 9 -10
INVMON Invoice data - month 11 -12
INVYR Invoice data - year 13 -14
CUSTNO Customer number 15 -24
CUSTTY Customer type 25 -25
MRCHLN Merchandise line 26 -27
PRODCO Product code 28 -37
UNITS5 Sales units 38 -42
STACDE State code 43 -44
SLSTER Sales territory 45 -47
SLSNMl Sales number 48 -49
TRANCD Sales type 50 -50
Field
Names
Contents
Record
Positions
RECCDE Record code "WB" 1 -2
CUSTNO Customer numbe 3 -12
CUSTTY Customer type 13 -13
ORDRNO Order number 14 -19
ORTYCD Order type 20 -20