MAC-PAC Homecontact ussupport login 
Documentation > MAC-PAC Reference Library > Distribution > Purchasing > Reports > File Reorganization

File Reorganization

PO020A

 

File Reorganization - Item\Vendor Relationship File (PO020A)

 

DATE    3/15/93                          ITEM/VENDOR RELATIONSHIP FILE REORGANIZATION                                   PAGE       1

TIME   17:33:21

REPORT PO020A

                            VENDOR                                   PU/SKU    IVR  VAT      RC  ISP  EXP  EXP NOT BYR  REF QUOT

 CO  WHS   PART NUMBER      NUMBER   VENDOR ITEM DESCRIPTION   PUM   FACTOR    STS  CDE  TC  TY  REQ  NOT    L/T   CDE   VENDOR

 --- ---  ---------------  -------- -------------------------  --- ----- ----- ---  ---  --  --  ---  ---  ------- ---  --------

 001 BEL  BOLT-100         V04      PURCHASING PART            DZ  00012 00001  *   V2       NC  NO   PR     2.00  B1

                                    REF QUOTATION   H    PLANNED QTY    MINIMUM

                                    ITEM NUMBER     C    THIS YEAR      ORDER QTY

                                   ---------------  -   ------------   ------------

                                                    N           .000           .000

                                    CMT                                                      PR

                                    SEQ               COMMENT TEXT                           CD

                                    --  --------------------------------------------------   --

                                     1  PURGE COMMENTS                                       3

                                     2  TEST REQUIREMENTS                                    3

                                     3  TOP QUALITY                                          0

                                     4  NOTIFY E. MARTIN                                     0

                            VENDOR                                   PU/SKU    IVR  VAT      RC  ISP  EXP  EXP NOT BYR  REF QUOT

 CO  WHS   PART NUMBER      NUMBER   VENDOR ITEM DESCRIPTION   PUM   FACTOR    STS  CDE  TC  TY  REQ  NOT    L/T   CDE   VENDOR

 --- ---  ---------------  -------- -------------------------  --- ----- ----- ---  ---  --  --  ---  ---  ------- ---  --------

 001 DW1  ED200            EDVEND02 EDI TESTPART 200 DW1       EA  00001 00001  *   V1       NC  NO   PR     2.00  PBB

                                    REF QUOTATION   H    PLANNED QTY    MINIMUM

                                    ITEM NUMBER     C    THIS YEAR      ORDER QTY

                                   ---------------  -   ------------   ------------

                                                    N           .000           .000

                            VENDOR                                   PU/SKU    IVR  VAT      RC  ISP  EXP  EXP NOT BYR  REF QUOT

 CO  WHS   PART NUMBER      NUMBER   VENDOR ITEM DESCRIPTION   PUM   FACTOR    STS  CDE  TC  TY  REQ  NOT    L/T   CDE   VENDOR

 --- ---  ---------------  -------- -------------------------  --- ----- ----- ---  ---  --  --  ---  ---  ------- ---  --------

 001 DW1  ED300            EDVEND02 EDI TESTPART 300 DW1       DZ  00002 00001  *   V1       NC  NO   PR     2.00  PBB

                                    REF QUOTATION   H    PLANNED QTY    MINIMUM

                                    ITEM NUMBER     C    THIS YEAR      ORDER QTY

                                   ---------------  -   ------------   ------------

                                                    N           .000           .000

File Reorganization - Requisition File (PO020A)

 

 

DATE    3/15/93                            REQUISITION FILE REORGANIZATION                                              PAGE       1

TIME   15:37:46

REPORT PO020A

         REQUISITION  L  PART                                               DUE     P  ANL BYR CLS  REQ  PREF

 CO  WHS NUMBER   LN  S  TYPE  PART NUMBER       RQS QTY    UM  RQS DATE    DATE    C  CDE CDE RSN  DPT  VENDOR

 --- --- -------  --  -   -    ---------------  ----------  --  --------  --------  -  --- --- --   ---  --------

 001 BEL RQ266    1   K   2    BOLT-200             10.000  EA   1/29/93   1/29/93  B  A                 V01

         REQUISITION  L  PART                                               DUE     P  ANL BYR CLS  REQ  PREF

 CO  WHS NUMBER   LN  S  TYPE  PART NUMBER       RQS QTY    UM  RQS DATE    DATE    C  CDE CDE RSN  DPT  VENDOR

 --- --- -------  --  -   -    ---------------  ----------  --  --------  --------  -  --- --- --   ---  --------

 001 BEL 0000003  1   C   2    BOLT-200            400.000  EA   1/21/93   1/21/93  B  B   B1  SO

         REQUISITION  L  PART                                               DUE     P  ANL BYR CLS  REQ  PREF

 CO  WHS NUMBER   LN  S  TYPE  PART NUMBER       RQS QTY    UM  RQS DATE    DATE    C  CDE CDE RSN  DPT  VENDOR

 --- --- -------  --  -   -    ---------------  ----------  --  --------  --------  -  --- --- --   ---  --------

 001 BEL 0000005  1   C   2    BOLT-200            200.000  EA   1/22/93   1/22/93  B  B   B1  SO

         REQUISITION  L  PART                                               DUE     P  ANL BYR CLS  REQ  PREF

 CO  WHS NUMBER   LN  S  TYPE  PART NUMBER       RQS QTY    UM  RQS DATE    DATE    C  CDE CDE RSN  DPT  VENDOR

 --- --- -------  --  -   -    ---------------  ----------  --  --------  --------  -  --- --- --   ---  --------

 001 DW1 0000056  1   C   1    ED100                  .833  BX   2/03/93   2/04/93  B  PBP PBB SO

         REQUISITION  L  PART                                               DUE     P  ANL BYR CLS  REQ  PREF

 CO  WHS NUMBER   LN  S  TYPE  PART NUMBER       RQS QTY    UM  RQS DATE    DATE    C  CDE CDE RSN  DPT  VENDOR

 --- --- -------  --  -   -    ---------------  ----------  --  --------  --------  -  --- --- --   ---  --------

 001 DW1 0000057  1   C   1    ED100                 2.500  BX   2/03/93   2/04/94  B  PBP PBB SO

File Reorganization - Purchase Order File (PO020A)

 

 

DATE    3/15/93                             PURCHASE ORDER FILE REORGANIZATION                                          PAGE       1

TIME   22:45:26

REPORT PO020A

          ORDER   BYR O O H  PO  ACK PRE   EFF      EXP    ORDER     PR       PR       PR       PR

 CO  WHS  NO      CDE T S C  TYP STS MOD   DATE     DATE   DATE      CD MSG1  CD MSG2  CD MSG3  CD        CUSTOM MESSAGE

 --- --- -------  --- - - -   -   -   -  -------- -------- --------  -  ---   -  ---   -  ---   -  -------------------------

 001 DW1 0000077  PBB W C     S   N   M   0/00/00  0/00/00  2/15/93

                 PAY CR  DISC   D/D DIS  EOM  NET EOM FROM  DEL CURR FOB SHIP FR  TAX  TAX                     P REL AP

                 TYP TR  PCT    CDE DAY  DISC DAY NET  DTE  DAY CODE     TERM TR  CDE  PT      TAX AMOUNT      F FLG CD

                 --  --  -----  -   ---  -    ---  -   -    --  ---- --   --  --  -  ------    --------------  -  -  --

                 CK  C1   3.00  1    10  N    030  N   2         DEM F1   F1  S1       .00000             .00  I N    AP

                   VENDOR

                   NUMBER             VENDOR  NAME                  VENDOR ADDRESS 1                  VENDOR ADDRESS 2

                  --------   ------------------------------   ------------------------------   ------------------------------

                  001GES     ANDERSEN CONSULTING APPL.,INC.   GERMAN MANUFACTURING SITE        ALEXANDERPLATZ

                                   CITY         STATE      ZIP CODE  COUNTRY                          VENDOR ADDRESS 3

                             -----------------    --     ---------     ---                     ------------------------------

                                                                       GER                     D-2000 BERLIN, GERMANY

                                     SHIP-TO NAME                   SHIP-TO ADDRESS 1                SHIP-TO ADDRESS 2

                             ------------------------------   ------------------------------   ------------------------------

                             DISTRIBUTION WAREHOUSE 1         RUE DE PETIT PONT, 34            B-1040 BRUXELLES, BELGIUM

                                   CITY         STATE      ZIP CODE  COUNTRY                         SHIP-TO ADDRESS 3

                             -----------------    --     ---------     ---                     ------------------------------

                                                                       BEL

                                     BILL-TO NAME                   BILL-TO ADDRESS 1                BILL-TO ADDRESS 2

                             ------------------------------   ------------------------------   ------------------------------

                             DISTRIBUTION WAREHOUSE 1         RUE DE PETIT PONT, 34            B-1040 BRUXELLES, BELGIUM

                                   CITY         STATE      ZIP CODE  COUNTRY                         BILL-TO ADDRESS 3

                             -----------------    --     ---------     ---                     ------------------------------

                                                                       BEL


 

DATE    3/15/93                             PURCHASE ORDER FILE REORGANIZATION                                          PAGE       2

TIME   22:45:26

REPORT PO020A

         ORDER   PART NUMBER     LN  L                               EFF      EXP     RC PAY ISP EXP VAT TAX QUOT REQ

CO  WHS  NO                      NO  S  VENDOR ITEM DESCRIPTION      DATE     DATE    TY TYP REQ NOT CDE FLG NO   DPT

--- ---  ------- --------------- --- - -------------------------   -------- --------  -- --  --  --  --  -   ---- ---

001 DW1  0000077 ED300           001 O EDI TESTPART 300 DW1         0/00/00  0/00/00  NC FP  NO  PR  V1      ED03

              PU/SKU     MAXIMUM      LINE TARGET                   P                 REF QUOTATION    REF QUOT

              FACTOR     LINE QTY     QUANTITY      PART UNIT COST  C  MSG  CO   WHS  ITEM NUMBER      VENDOR

            ----- ----- ------------  ------------  --------------- -  ---  ---  ---  ---------------  --------

            00002 00001        1.000         1.000        1.3072000         001  DW1  ED300            001GES

        ORDER   LN                  REL R RELEASE  COVERED RQ   REF ORD OP  OP  AR P  PROMISED DELIVERY EXP NOT

CO  WHS NO      NO  PART NUMBER     NO  S DUE DATE NUMBER  LN   NUMBER  NO  LN  CD F  DATE     DATE     DATE

--- --- ------- --- --------------- --- - -------- ------- --   ------- --- --  -  -  -------- -------- --------

001 DW1 0000077 001 ED300           001 C  2/16/93 0000237 01                      Y   2/16/93  2/16/93  2/14/93

                   RELEASE     RELEASE     PURCH RCV   RCV RELEASE    BALANCE    BALANCE       ACT

                   QTY  -  PU  QTY - SKU   QTY  -  PU  QTY - SKU      DUE - PU   DUE - SKU     CDE

                   ----------  ----------  ----------  ----------   ---------- ----------      ---

                         .000        .000        .000        .000         .000       .000       02

         ORDER   PART NUMBER     LN  L                               EFF      EXP     RC PAY ISP EXP VAT TAX QUOT REQ

CO  WHS  NO                      NO  S  VENDOR ITEM DESCRIPTION      DATE     DATE    TY TYP REQ NOT CDE FLG NO   DPT

--- ---  ------- --------------- --- - -------------------------   -------- --------  -- --  --  --  --  -   ---- ---

001 DW1  0000077 ED400           002 O EDI TESTPART 400 DW1         2/16/93  2/16/93  NC FP  NO  PR  V1      ED10

              PU/SKU     MAXIMUM      LINE TARGET                   P                 REF QUOTATION    REF QUOT

              FACTOR     LINE QTY     QUANTITY      PART UNIT COST  C  MSG  CO   WHS  ITEM NUMBER      VENDOR

            ----- ----- ------------  ------------  --------------- -  ---  ---  ---  ---------------  --------

            00001 00001       20.000        20.000        1.1300000         001  DW1  ED400            001GES

        ORDER   LN                  REL R RELEASE  COVERED RQ   REF ORD OP  OP  AR P  PROMISED DELIVERY EXP NOT

CO  WHS NO      NO  PART NUMBER     NO  S DUE DATE NUMBER  LN   NUMBER  NO  LN  CD F  DATE     DATE     DATE

--- --- ------- --- --------------- --- - -------- ------- --   ------- --- --  -  -  -------- -------- --------

001 DW1 0000077 002 ED400           001 C  2/16/93 0000238 01                      Y   2/16/93  2/16/93  0/00/00

                   RELEASE     RELEASE     PURCH RCV   RCV RELEASE    BALANCE    BALANCE       ACT

                   QTY  -  PU  QTY - SKU   QTY  -  PU  QTY - SKU      DUE - PU   DUE - SKU     CDE

                   ----------  ----------  ----------  ----------   ---------- ----------      ---

                         .000        .000        .000        .000         .000       .000       02

File Reorganization - Receipt File (PO020A)

 

DATE    3/15/93                                RECEIPT FILE REORGANIZATION                                              PAGE       1

TIME   20:22:10

REPORT PO020A

        RECEIPT REL RECEIPT  BILL OF LADING                            NOT       PR  ID

CO  WHS NO      STS DATE     NUMBER                  CARRIER NAME      REL  COP  CD  REL

--- --- ------- --- -------- --------------- ------------------------- ---  ---  --  ---

001 BEL IAR-001  O   9/10/92                                                         I

        RECEIPT LN  L RC                                                   STOCK   LOT FIFO                           LOT

CO  WHS NO      NO  S TY   PART NUMBER    VENDOR ITEM DESCRIPTION  SKU PUM LOC     NUMBER       VENDOR LOT NO         FIFO DT

--- --- ------- --  - -- --------------- ------------------------- --- --- ------- ------------ --------------------  --------

001 BEL IAR-001 001 C NC IA-CA-PUR-STD   IA-CA-PUR-STD             EA  EA  IALOC01                                     0/00/00

                   CONTROL STS  APPROVAL STS   QTY VAR    QLY CTL

                   QTY     QLY  QTY      QLY   NOT NUMBER NOT NUMBER

                   ---     ---  ---      ---   ---------- ----------

                     C     C       A     D

                    LISTED      LISTED      ACCEPTED     REWORK      REJECT      RETURN     COUNTED     NON DISP

                    QTY - PU    QTY - SKU   QUANTITY     QUANTITY    QUANTITY    QUANTITY   QUANTITY    QUANTITY

                   ----------  ----------  ----------  ----------  ----------  ----------  ----------  ----------

                     1100.000    1100.000     900.000        .000     200.000        .000    1100.000        .000

        RECEIPT  LN   PAR  NO   QTY PER     REL             OP   OP

CO  WHS NO       NO   LN   PAR  PARCEL      NO   MO NUMBER  NO   LN

--- --- -------  ---  ---  ---  ----------  ---  -------    ---  --

001 BEL IAR-001  001  001  001    1100.000  000

File Reorganization - File Control Summary (PO020A)

 

 

DATE    3/15/93                             PURCHASE ORDER FILE REORGANIZATION                                          PAGE       10

TIME   22:45:26                                    FILE CONTROL SUMMARY

REPORT PO020A

                                                      FILE                 DELETION

                                     ----------------------------------   -----------

                                     ITEM/VENDOR RELATIONSHIP                     0

                                     ITEM/VENDOR RELATIONSHIP COMMENTS            0

                                     REQUISITION                                  0

                                     REQUISITION COMMENTS                         0

                                     PURCHASE ORDER HEADER                        7

                                     PURCHASE ORDER LINES                         6

                                     PURCHASE ORDER RELEASES                      5

                                     PURCHASE ORDER COMMENTS                      9

                                     RECEIPT HEADER                               0

                                     RECEIPT LINE                                 0

                                     RECEIPT PARCEL                               0

                                     RECEIPT COMMENT                              0

                                     AUDIT TRAILS                                 0

                                     EDI RECEIPT                                  0

                                                                           ** END OF REPORT **

Purpose

This report prints a detail line for every record deleted during the Purchasing Master File Reorganization Program (PO020E).  A summary total of the number of each type of record deleted is printed at the end of each PO020A report.

Report Sequence

None.