Documentation >
MAC-PAC Reference Library >
Manufacturing >
Design Engineering >
Reports >
Data Base Audit
Data Base Audit
DE530
DATE 1/28/93 STEVENS SUPPLY PAGE 1
TIME 9:47:49 DATA BASE AUDIT - PART MASTER FILE PLANT BEL
REPORT DE530E
PART OPTION LINE PRINT OPTION REQUIRED DATA AUDIT OPTION
------------- ------------------------------------------------- -------------------------------------
ALL PRTS IN PRT NO SYS USER INV COST SLS PROD PURC BILL OF PLN F PROD
PRTS ERROR DESC DATA DATA DATA DATA DATA DATA DATA MATERIAL ROUTING COST POL V INFO
OPTION - ID 1 2 3 4 5 6 7 8 1 2 3 4 5 6
---- ------- ------ ---- ---- ---- ---- ---- ---- ---- -------- ------- ---- --- - ----
OPTION SELECTED A 1 2 3 4 5 6 7 8 1 2 3 4 5 6
|
DATE 1/28/93 STEVENS SUPPLY PAGE 2
TIME 9:47:49 PLANT BEL
REPORT DE530E
DATA BASE AUDIT - PART MASTER FILE
************************************************************************************************************************************
PART NUMBER/ ACT RA PM C S I AVERAGE PM CST MS LOAD DRAWING DATA
DESCRIPTION CDE LLC CN NEXT PART IN CH QTY WORK FLAG E E E ORDER QTY EFF DT QUANTITY NUMBER REQD
------------------------- - -- --- --------------- ------------ -------- - - - ---------- ------ ---------- ---------------------
BDS 1 1 0000 .000 0000000 1.000 999999 1.000
JKH
PART COMM PRD REV ENG A SCRAP/ ANL/ I D PLN PLAN POL/ PLAN POL SET F FIX LT DY/ SETUP RUN TRAN F YIELD CUM N
UM TYPE CODE TYP GEN REV C VAR OPT PLT C C POL BATCH QTY INCR COST V MAX MO QTY DAYS UNITS DAYS P FACTR L/T C
-- - --- - - --- -- ------- --- - - - ---------- ---------- ---- - ---------- ------ ---------- ------ - -- ------ -
EA 1 GOL 1 N 001 FG 1 AAA S S 5 .000 .000 .0 V .0000 .000 .0000 .000 N .00 0 2
1 1.000 .000
PU/ PUR/SUPP UM SL SELLING UM PRD SUB SEARCH/ PART WGT/ PART REFERENCE 1/ SELLING DESCRIPTION 1/ MSG/CDE USER S
SUP CONV FACTOR UM CONV FACTOR CLS CLS SUBSTITUTE PART PART VOL PART REFERENCE 2 SELLING DESCRIPTION 2 PUR SLS SEQ C
-- ------------- -- ------------- -- -- --------------- ---------- -------------------- ------------------------- --- --- ----- -
EA 00001 / 00001 EA 00001 / 00001 JKH .000 JKH N
EA 00001 / 00001 .000
PREV STANDARD DT LAST AVL PREV PREV PREV-P PREV-A PRIMARY SIR LOT SAFETY TARG MIX VOL CUSTOMS POT STD
UNIT COST COST ACT CDE UM IAC ON-HAND ON-HAND LOC LOC CTL STOCK INV FNC FNC COMM CDE CTL POT
----------------- -------- - -- -- ------------ ------------ ------- ------- - ------------ -- -- -- -------- - ------
.0000000 1/24/93 0 .000 .000 PBMLOC PRIM001 N .000 00 00 00 N 100.00
PROD CBC CON CONTAINER AUTHORIZED DAYS RLF PRODUC RELIEF CON BON INV FIRM
GROUP TECHNOLOGY NUMBER FAMILY CENTER CODE CODE QUANTITY QUANTITY OUT Q OPT LOCATION LOCATION CARDS CARDS NET HORIZON
------------------------- ----- ------- - -- ---------- ---------- ----- - ------- ------- ----- ----- - --------
MOLDING 2 .000 1.000 .0 1 0 0 Y 0/00/00
---------- CURRENT / STANDARD COST - TOTAL ---------- --------- CURRENT / STANDARD COST - THIS LEVEL -------- -PCS-
MATERIAL LABOR OVERHEAD MATERIAL LABOR OVERHEAD C S I
----------------- ----------------- ----------------- ----------------- ----------------- ----------------- - - -
.0000000 .0000000 .0000000 .0000000 .0000000 .0000000 1
.0000000 .0000000 .0000000 .0000000 .0000000 .0000000
MB SB AUTO I/V ISP PUR PUR D-S P.O
PURCHASING DESCRIPTION CD CD GEN REL REQ GRP S-G L/T MSG/CDE
------------------------- --- --- - - -- -- -- ------ --- -
JKH 9 ABC N Y 01 BB .00
|
Purpose
Two reports are printed as a result of the data base audit options. The first report prints the data base audit options found on the System Control File. The second report provides a complete list of all specified fields on the Part Master File. On the second report, the Line Print Option provides for any or all of the following lines to be printed:
· Part number and description only
· System fields
· User fields
· Distribution fields
· Inventory fields
· Productivity fields
· Cost fields
· Purchasing fields
This report also indicates critical data fields that are missing according to the required data audit options. All parts or only those parts missing data are printed, according to the Part Print Option. Both reports are printed when a data base audit run is submitted. These reports are used by data processing and user personnel to assist in system testing and data base maintenance.
Report Sequence
Part Number.