Download - Spalding Software

Transcript
203855,PTL,MEET,,,,.50,0,0
OR
PROREP 4,11,30,2007,1,ELAPSED TIMES,,,,,,,,,,,
203855,PTL,CL,,,,6.75,0,4,SLOTS,85,PIECES,103,CARTONS,28,REACHES,94
203855,PTL,MEET,,,,.50,0,0,,,,,,,,
OR
PROREP 4,11,30,2007,1,ELAPSED TIMES,,,,,,,,,,,
203855,PTL,CL,,,,6.75,0,4,SLOTS,85,PIECES,103,CARTONS,28,REACHES,94
203855,PTL,MEET,,,,.50,0,4,,,,,,,,
Quality Sheet Files
A quality sheet import file can contain data for only one day’s quality sheet. The file
consists of one Header Record and any number of Detail Records. The Header
Record specifies the date of the quality sheet into which the data is to be imported
and the disposition of existing records in the quality sheet file. Each Detail Record
corresponds to a line or record on an associate’s quality sheet.
Header Record
Each header record must contain the following fields:
RecType, Month, Day, Year, MergeFlag, ImportType
RecType is always “PROREP 4”
ImportType is always “QUALITY”
MergeFlag - A “0” deletes all records in the quality sheet file before importing.
Either a “1” or a ”-1” appends or adds the records in the import file to the quality
sheet file without deleting any existing records in the quality sheet file.
The Header Record can contain additional blank fields (commas) at the end of the
record. They are ignored.
Header Record Examples:
PROREP 4,7,23,2007,-1,QUALITY
“PROREP 4”,07,23,2007,1,“QUALITY”
PROREP 4,7,23,2007,0,QUALITY,,,,,,,,,,,,
Detail Records
AuditorID, AssociateID, WorkCenter, TypeofWorkCode, AllocationCode,
Document, ErrorType, AuditedUnits, FailedUnits, NumberOfMistakes,
User’s Guide to ProRep
Appendix G: Production and Quality Sheet Import File Formats • 319