Lawson Insight Technical Documentation |
|
APVENCERT
APVENCERT FILE
REFERENCED BY
AP210 PO240 AP13.3
UPDATED BY
AP14.3 AP510 AM115 AM117 AM15.1 AM15.2
AM15.3 AM15.4 AM20.1 AM20.3 AM21.1 AM21.3
AM500 AM51.1 AM551 AM97.1 API3.1 API4.1
IC840 PR05.1 PR05.3 PR226 PR247 PR26.1
PR47.1 UK47.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
AVT-VENDOR-GROUP Alpha 4 AP14.3 AP510
Element: Vendor Group A vendor group represents a group of
vendors that can be shared by one or
more companies.
AVT-VENDOR Alpha 9 (Right Justified) AP14.3 AP510
Element: Vendor ID The vendor's identification code.
AVT-LOCATION-CODE Alpha 4 AP14.3 AP510
Element: Location Code A user-defined code that represents an
alternate purchasing or remittance
location for the vendor.
AVT-CERTIF-CODE Alpha 10 AP14.3 AP510
Element: Certif Code User defined code representing
certifications.
AVT-CERTIF-DESC Alpha 30 AP14.3 AP510
Element: Certif Desc Description of the Certification Code.
AVT-CERTIF-EFF-DT Numeric 8 (yyyymmdd) AP14.3 AP510
Element: Effective Date
AVT-CERTIF-EXP-DT Numeric 8 (yyyymmdd) AP14.3 AP510
Element: Effective Date
APVENCERT FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
AVTSET1 VENDOR-GROUP AM115 AM117
VENDOR AM15.1 AM15.2
LOCATION-CODE AM15.3 AM15.4
CERTIF-CODE AM20.1 AM20.3
CERTIF-EFF-DT* AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP14.3 AP210
API3.1 API4.1
IC840 PO240
PR05.1 PR05.3
PR226 PR247
PR26.1 PR47.1
UK47.1
AVTSET2 CERTIF-CODE AP13.3
VENDOR-GROUP
VENDOR
LOCATION-CODE
CERTIF-EFF-DT*
APVENCERT FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Apcertcode APCERTCODE Required
AVT-CERTIF-CODE -> CER-CERTIF-CODE
Apvenloc APVENLOC Not Required
AVT-VENDOR-GROUP -> VLO-VENDOR-GROUP
AVT-VENDOR -> VLO-VENDOR
AVT-LOCATION-CODE -> VLO-LOCATION-CODE
Apvenmast APVENMAST Required
AVT-VENDOR-GROUP -> VEN-VENDOR-GROUP
AVT-VENDOR -> VEN-VENDOR
|