APPOVNXREF – No description in the Lawson data dictionary

System
Accounts Payable (AP)
Prefix
AXV
Primary key
VENDOR-GROUP, VENDOR, XREF-VENDOR
Fields
5
Updated by
2 programs
Referenced by
2 programs

APPOVNXREF is a Lawson Accounts Payable table (prefix AXV); no description in the lawson data dictionary. It is indexed by VENDOR-GROUP, VENDOR, XREF-VENDOR (AXVSET1); alternate indexes: AXVSET2. It is updated by AP15.1 and AP300 and referenced by MA531 and PO520. The table has 5 fields, 2 indexes and 0 documented relations.

About APPOVNXREF

No description in the Lawson data dictionary.

Fields (5)

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

Field / columnTypeDescription & valuesUpdated by
AXV-VENDOR-GROUP PK
VENDOR_GROUP
Alpha 4A vendor group represents a group of vendors that can be shared by one or more companies.AP15.1
AXV-VENDOR PK
VENDOR
Alpha 9 (Right Justified)The vendor's identification code.AP15.1
AXV-XREF-VENDOR PK
XREF_VENDOR
Alpha 9 (Right Justified)This is a vendor that is supported on a system outside Lawson. When records are interfaces we will maintain this vendor on the file but we will use the Lawson vendor while in the lawson application.AP15.1
AXV-XREF-VEN-DESC
XREF_VEN_DESC
Alpha 30AP15.1
AXV-BUYER-CODE
BUYER_CODE
Alpha 3

Indexes (2)

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

IndexKeysFlagsConditionUsed in
AXVSET1VENDOR-GROUP, VENDOR, XREF-VENDORPrimaryAP15.1, AP300
AXVSET2VENDOR-GROUP, XREF-VENDORAP15.1, MA531, PO520

Programs

Updated by (2)

Referenced by (2)