MAC-PAC Homecontact ussupport login 
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.