Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                             POMESSAGE FILE

                             Buyer Messages

This file contains information about purchase order receiving and approval
tolerance exceptions and adhoc manually entered buyer messages. The receiving
and approvals messages must be processed before their related receiving or
approval can be released.

REFERENCED BY

PO251     POID.1

UPDATED BY

POIJ.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

POM-COMPANY          Numeric 4                                   POIJ.1
Company              The company number.

POM-BUYER-CODE       Alpha 3                                     POIJ.1
Buyer Code           The user defined buyer identifier.

POM-MSG-DATE         Numeric 8  (yyyymmdd)                       POIJ.1
Message Date         The date the message was created.

POM-MSG-TIME         Numeric 6                                   POIJ.1
Message Time         The time the message was created.

POM-MSG-SEQ          Numeric 6                                   POIJ.1
Message Sequence     The message sequence number.
Number

POM-MESSAGE-TYPE     Alpha 1                                     POIJ.1
Message Type         The message type.
                     I = Invoice
                     M = Manual
                     R = Receiving

POM-DOCUMENT         Alpha 10  (Right Justified)
Document ID          This field identifies the document from
                     which this transaction record was
                     created.

POM-REC-NUMBER       Numeric 10                                  POIJ.1
Receiver Number      The receiver number.  Assigned when
                     this receiving information was added.

POM-DOC-NBR-NUM      Numeric 10                                  POIJ.1
Doc Nbr Num

POM-LINE-NBR         Numeric 6                                   POIJ.1
Line Number          This field contains the line number.

POM-PO-NUMBER        Alpha 14  (Right Justified)                 POIJ.1
PO Number            This field contains the number
                     representing the purchase order.

POM-PO-RELEASE       Numeric 4                                   POIJ.1
PO Release Number    Used to identify a purchase order
                     release (created from a Blanket or
                     Standing order).

POM-PO-CODE          Alpha 4                                     POIJ.1
Po Code              This is the purchase order code.

POM-RETURN-QTY       Signed 13.4
Quantity Returned    This is the quantity to be returned to
                     the vendor using Vendor Returns when an
                     over receiving buyer message is
                     released.

POM-LOCATION         Alpha 5                                     POIJ.1
Location Code        This field contains a valid stock
                     location within the company inventory.

POM-BATCH-NBR        Numeric 6
Batch Number         This identifies the batch the entered
                     invoices, debit memos, and credit memos
                     are a part of.

POM-VENDOR           Alpha 9  (Right Justified)                  POIJ.1
Vendor ID            The vendor's identification code.



POM-INVOICE          Alpha 22                                    POIJ.1
Invoice Number       Used to identify the invoice.

POM-SUFFIX           Numeric 3                                   POIJ.1
Invoice Suffix       This is the suffix for the invoice.

POM-COMMENT          Alpha 40  (Lower Case)                      POIJ.1
Comment Line         Occurs 4 Times
                     This field contains the comment
                     narrative.

POM-STATUS           Numeric 1                                   POIJ.1
Status               Status of record.
                     1 = Unreleased
                     2 = Released

                         POMESSAGE FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

POMSET1   COMPANY                                                PO251
          BUYER-CODE
          MSG-DATE
          MSG-TIME
          MSG-SEQ

POMSET2   COMPANY       Subset
          BUYER-CODE    Where MESSAGE-TYPE = "M"
          DOCUMENT

POMSET3   COMPANY       Subset                                   POIJ.1
          REC-NUMBER    Where (MESSAGE-TYPE = "R" )
          LINE-NBR      And   (DOC-NBR-NUM  = Zeroes )

POMSET4   COMPANY       Subset
          BATCH-NBR     Where MESSAGE-TYPE = "I"
          VENDOR
          INVOICE
          SUFFIX
          PO-NUMBER
          PO-RELEASE
          LINE-NBR

POMSET5   COMPANY       Subset                                   POID.1  POIJ.1
          REC-NUMBER    Where MESSAGE-TYPE = "R"
          LINE-NBR
          DOC-NBR-NUM

                         POMESSAGE FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Apcompany      APCOMPANY    Required

                            POM-COMPANY          -> CPY-COMPANY

Apinvoice      APINVOICE    Required

                            POM-COMPANY          -> API-COMPANY
                            PCR-VENDOR           -> API-VENDOR
                            POM-INVOICE          -> API-INVOICE
                            Zeroes               -> API-SUFFIX
                            Zeroes               -> API-CANCEL-SEQ

Apvenmast      APVENMAST    Required

                            CPY-VENDOR-GROUP     -> VEN-VENDOR-GROUP
                            POM-VENDOR           -> VEN-VENDOR

Buyer          BUYER        Required

                            PCY-PROCURE-GROUP    -> BUY-PROCURE-GROUP
                            POM-BUYER-CODE       -> BUY-BUYER-CODE

Iccompany      ICCOMPANY    Required

                            POM-COMPANY          -> ICC-COMPANY

Itemloc        ITEMLOC      Not Required

                            POM-COMPANY          -> ITL-COMPANY
                            PRL-LOCATION         -> ITL-LOCATION
                            PRL-ITEM             -> ITL-ITEM

Itemmast       ITEMMAST     Required
                            When   POM-PO-NUMBER != Spaces
                            And  ((POM-ITEM-TYPE =  "I" )
                            Or    (POM-ITEM-TYPE =  "N" ))

                            ICC-ITEM-GROUP       -> ITE-ITEM-GROUP
                            PLI-ITEM             -> ITE-ITEM

Po Company     POCOMPANY    Required

                            POM-COMPANY          -> PCY-COMPANY

Poline         POLINE       Required
                            When POM-LINE-NBR != Zeroes

                            POM-COMPANY          -> PLI-COMPANY
                            POM-PO-NUMBER        -> PLI-PO-NUMBER
                            POM-PO-RELEASE       -> PLI-PO-RELEASE
                            POM-PO-CODE          -> PLI-PO-CODE
                            POM-LINE-NBR         -> PLI-LINE-NBR

Porecline      PORECLINE    Required
                            When POM-MESSAGE-TYPE = "R"

                            POM-COMPANY          -> PRL-COMPANY
                            POM-DOCUMENT         -> PRL-REC-NUMBER
                            POM-LINE-NBR         -> PRL-LINE-NBR

Purchorder     PURCHORDER   Required
                            When POM-PO-NUMBER != Spaces

                            POM-COMPANY          -> PCR-COMPANY
                            POM-PO-CODE          -> PCR-PO-CODE
                            POM-PO-NUMBER        -> PCR-PO-NUMBER
                            POM-PO-RELEASE       -> PCR-PO-RELEASE

Receiver       PORECEIVE    Required
                            When POM-REC-NUMBER != Zeroes

                            POM-COMPANY          -> POR-COMPANY
                            POM-REC-NUMBER       -> POR-REC-NUMBER