POMESSAGE – Buyer Messages

System
Purchase Order (PO)
Prefix
POM
Primary key
COMPANY, BUYER-CODE, MSG-DATE, MSG-TIME, MSG-SEQ
Fields
25
Updated by
221 programs
Referenced by
0 programs

POMESSAGE is the Buyer Messages table in Lawson Purchase Order (prefix POM). It is indexed by COMPANY, BUYER-CODE, MSG-DATE, MSG-TIME, MSG-SEQ (POMSET1); alternate indexes: POMSET2, POMSET3, POMSET4 and POMSET5. It is related 1:1 to APCOMPANY, APINVOICE, APVENMAST, BUYER, ICCOMPANY, ITEMLOC, ITEMMAST, POCOMPANY and 4 more. It is updated by AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 and 213 more. The table has 25 fields, 5 indexes and 12 documented relations.

About POMESSAGE

No description in the Lawson data dictionary.

Fields (25)

Column = COBOL field name without the POM- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
POM-COMPANY PK
COMPANY
Numeric 4The company number.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
POM-BUYER-CODE PK
BUYER_CODE
Alpha 3AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
POM-MSG-DATE PK
MSG_DATE
Numeric 8 (yyyymmdd)The date the message was created.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
POM-MSG-TIME PK
MSG_TIME
Numeric 6The time the message was created.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
POM-MSG-SEQ PK
MSG_SEQ
Numeric 6The message sequence number.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
POM-MESSAGE-TYPE
MESSAGE_TYPE
Alpha 1The message type.
  • M Manual
  • R Receiving
AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
POM-DOCUMENT
DOCUMENT
Alpha 10 (Right Justified)This field identifies the document from which this transaction record was created.PO50.1
POM-REC-NUMBER
REC_NUMBER
Numeric 10The receiver number. Assigned when this receiving information was added.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
POM-DOC-NBR-NUM
DOC_NBR_NUM
Numeric 10AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
POM-LINE-NBR
LINE_NBR
Numeric 6This field contains the line number.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
POM-PO-NUMBER
PO_NUMBER
Alpha 14 (Right Justified)This field contains the number representing the purchase order.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
POM-PO-RELEASE
PO_RELEASE
Numeric 4Used to identify a purchase order release (created from a Blanket or Standing order).AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
POM-PO-CODE
PO_CODE
Alpha 4This is the purchase order code.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
POM-RETURN-QTY
RETURN_QTY
Signed 13.4This is the quantity to be returned to the vendor using Vendor Return (PO31.1) when an over receiving buyer message is released.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
POM-LOCATION
LOCATION
Alpha 5This field contains a valid stock location within the company inventory.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
POM-BATCH-NBR
BATCH_NBR
Numeric 6This identifies the batch the entered invoices, debit memos, and credit memos are a part of.
POM-VENDOR
VENDOR
Alpha 9 (Right Justified)The vendor's identification code.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
POM-INVOICE
INVOICE
Alpha 22Used to identify the invoice.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
POM-SUFFIX
SUFFIX
Numeric 3This is the suffix for the invoice.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
POM-COMMENT
COMMENT
Alpha 40 (Lower Case)Occurs 4 Times This field contains the comment narrative.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
POM-STATUS
STATUS
Numeric 1Status of record.
  • 1 Unreleased
  • 2 Released
AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
POM-SUBST-FLAG
SUBST_FLAG
Numeric 1
  • 0 Not a Substitute Item Message
  • 1 Substitute Item Message
AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
POM-OVERRECVD-FLAG
OVERRECVD_FLAG
Numeric 1
  • 0 Not a Overreceiving Message
  • 1 Overreceiving Message
AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
POM-UNIT-COST-FLAG
UNIT_COST_FLAG
Numeric 1
  • 0 Not a Vendor Unit Cost Message
  • 1 Vendor Unit Cost Message
AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
POM-REFERENCE-NO
REFERENCE_NO
Alpha 25 (Right Justified)

Indexes (5)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
POMSET1COMPANY, BUYER-CODE, MSG-DATE, MSG-TIME, MSG-SEQPrimaryPO251
POMSET2COMPANY, BUYER-CODE, DOCUMENTSubsetWhere MESSAGE-TYPE = "M"PO50.1
POMSET3COMPANY, REC-NUMBER, LINE-NBRSubsetWhere (MESSAGE-TYPE = "R") And (DOC-NBR-NUM = Zeroes)AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)
POMSET4COMPANY, BATCH-NBR, VENDOR, INVOICE, SUFFIX, PO-NUMBER, PO-RELEASE, LINE-NBRSubsetWhere MESSAGE-TYPE = "I"MA41.4
POMSET5COMPANY, REC-NUMBER, LINE-NBR, DOC-NBR-NUMSubsetWhere MESSAGE-TYPE = "R"AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)

Relations

One to one (12) — lookups and parents

RelationTableRulesConditionField map
ApcompanyAPCOMPANYRequiredPOM-COMPANYCPY-COMPANY
ApinvoiceAPINVOICERequiredPOM-COMPANYAPI-COMPANY, PCR-VENDORAPI-VENDOR, POM-INVOICEAPI-INVOICE, ZeroesAPI-SUFFIX, ZeroesAPI-CANCEL-SEQ
ApvenmastAPVENMASTRequiredCPY-VENDOR-GROUPVEN-VENDOR-GROUP, POM-VENDORVEN-VENDOR
BuyerBUYERRequiredPCY-PROCURE-GROUPBUY-PROCURE-GROUP, POM-BUYER-CODEBUY-BUYER-CODE
IccompanyICCOMPANYRequiredPOM-COMPANYICC-COMPANY
ItemlocITEMLOCNot RequiredPOM-COMPANYITL-COMPANY, PRL-LOCATIONITL-LOCATION, PRL-ITEMITL-ITEM
ItemmastITEMMASTRequiredWhen POM-PO-NUMBER != Spaces And ((PLI-ITEM-TYPE = "I") Or (PLI-ITEM-TYPE = "N"))ICC-ITEM-GROUPITE-ITEM-GROUP, PLI-ITEMITE-ITEM
Po CompanyPOCOMPANYRequiredPOM-COMPANYPCY-COMPANY
PolinePOLINERequiredWhen POM-LINE-NBR != ZeroesPOM-COMPANYPLI-COMPANY, POM-PO-NUMBERPLI-PO-NUMBER, POM-PO-RELEASEPLI-PO-RELEASE, POM-PO-CODEPLI-PO-CODE, POM-LINE-NBRPLI-LINE-NBR
PoreclinePORECLINERequiredWhen POM-MESSAGE-TYPE = "R"POM-COMPANYPRL-COMPANY, POM-REC-NUMBERPRL-REC-NUMBER, POM-LINE-NBRPRL-LINE-NBR
PurchorderPURCHORDERRequiredWhen POM-PO-NUMBER != SpacesPOM-COMPANYPCR-COMPANY, POM-PO-CODEPCR-PO-CODE, POM-PO-NUMBERPCR-PO-NUMBER, POM-PO-RELEASEPCR-PO-RELEASE
ReceiverPORECEIVERequiredWhen POM-REC-NUMBER != ZeroesPOM-COMPANYPOR-COMPANY, POM-REC-NUMBERPOR-REC-NUMBER

Programs

Updated by (221)