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

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 30—AP15.1
#AXV-BUYER-CODE
BUYER_CODE		Alpha 3——

Indexes (2)

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
AXVSET1
  1. VENDOR-GROUP
  2. VENDOR
  3. XREF-VENDOR
PrimaryAP15.1, AP300
AXVSET2
  1. VENDOR-GROUP
  2. XREF-VENDOR
AP15.1, MA531, PO520

Programs

Updated by (2)

Referenced by (2)