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. PK = primary key (present in every index); SETn = leading/alternate key of that index.

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 3—AP125, 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 SET2
DOCUMENT		Alpha 10 (Right Justified)This field identifies the document from which this transaction record was created.PO50.1
#POM-REC-NUMBER SET3 SET5
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 SET5
DOC_NBR_NUM		Numeric 10—AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#POM-LINE-NBR SET3 SET4 SET5
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 SET4
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 SET4
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 SET4
BATCH_NBR		Numeric 6This identifies the batch the entered invoices, debit memos, and credit memos are a part of.—
#POM-VENDOR SET4
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 SET4
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 SET4
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 are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
POMSET1
  1. COMPANY
  2. BUYER-CODE
  3. MSG-DATE
  4. MSG-TIME
  5. MSG-SEQ
PrimaryPO251
POMSET2
  1. COMPANY
  2. BUYER-CODE
  3. DOCUMENT
SubsetWhere MESSAGE-TYPE = "M"PO50.1
POMSET3
  1. COMPANY
  2. REC-NUMBER
  3. LINE-NBR
SubsetWhere (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)
POMSET4
  1. COMPANY
  2. BATCH-NBR
  3. VENDOR
  4. INVOICE
  5. SUFFIX
  6. PO-NUMBER
  7. PO-RELEASE
  8. LINE-NBR
SubsetWhere MESSAGE-TYPE = "I"MA41.4
POMSET5
  1. COMPANY
  2. REC-NUMBER
  3. LINE-NBR
  4. DOC-NBR-NUM
SubsetWhere MESSAGE-TYPE = "R"AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
APCOMPANYAPINVOICEAPVENMASTBUYERICCOMPANYITEMLOCITEMMASTPOCOMPANYPOLINEPORECLINEPURCHORDERPORECEIVEPOMESSAGE

One to one (12) — lookups and parents

RelationTableRulesConditionField map
ApcompanyAPCOMPANYRequired
POM-COMPANY→CPY-COMPANY
ApinvoiceAPINVOICERequired
POM-COMPANY→API-COMPANY
PCR-VENDOR→API-VENDOR
POM-INVOICE→API-INVOICE
Zeroes→API-SUFFIX
Zeroes→API-CANCEL-SEQ
ApvenmastAPVENMASTRequired
CPY-VENDOR-GROUP→VEN-VENDOR-GROUP
POM-VENDOR→VEN-VENDOR
BuyerBUYERRequired
PCY-PROCURE-GROUP→BUY-PROCURE-GROUP
POM-BUYER-CODE→BUY-BUYER-CODE
IccompanyICCOMPANYRequired
POM-COMPANY→ICC-COMPANY
ItemlocITEMLOCNot Required
POM-COMPANY→ITL-COMPANY
PRL-LOCATION→ITL-LOCATION
PRL-ITEM→ITL-ITEM
ItemmastITEMMASTRequiredWhen POM-PO-NUMBER != Spaces And ((PLI-ITEM-TYPE = "I") Or (PLI-ITEM-TYPE = "N"))
ICC-ITEM-GROUP→ITE-ITEM-GROUP
PLI-ITEM→ITE-ITEM
Po CompanyPOCOMPANYRequired
POM-COMPANY→PCY-COMPANY
PolinePOLINERequiredWhen 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
PoreclinePORECLINERequiredWhen POM-MESSAGE-TYPE = "R"
POM-COMPANY→PRL-COMPANY
POM-REC-NUMBER→PRL-REC-NUMBER
POM-LINE-NBR→PRL-LINE-NBR
PurchorderPURCHORDERRequiredWhen 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
ReceiverPORECEIVERequiredWhen POM-REC-NUMBER != Zeroes
POM-COMPANY→POR-COMPANY
POM-REC-NUMBER→POR-REC-NUMBER

Programs

Updated by (221)