APVENLCBOD – No description in the Lawson data dictionary
- System
- Accounts Payable (AP)
- Prefix
YBB- Primary key
VENDOR-GROUP,VENDOR,LOCATION-CODE- Fields
- 9
- Updated by
- 1 program
- Referenced by
- 89 programs
APVENLCBOD is a Lawson Accounts Payable table (prefix YBB); no description in the lawson data dictionary. It is indexed by VENDOR-GROUP, VENDOR, LOCATION-CODE (YBBSET1); alternate indexes: YBBSET2. It is related 1:1 to APVENLOC. It is updated by APBD.1 and referenced by AP10.1, AP10.2, AP100, AP109, AP110, AP111, AP115, AP125 and 81 more. The table has 9 fields, 2 indexes and 1 documented relation.
About APVENLCBOD
No description in the Lawson data dictionary.
Fields (9)
Column = COBOL field name without the YBB- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
YBB-VENDOR-GROUP PKVENDOR_GROUP | Alpha 4 | — | APBD.1 |
YBB-VENDOR PKVENDOR | Alpha 9 (Right Justified) | — | APBD.1 |
YBB-LOCATION-CODE PKLOCATION_CODE | Alpha 4 | — | APBD.1 |
YBB-BOD-ACCT-ENTBOD_ACCT_ENT | Alpha 22 (Lower Case) | — | APBD.1 |
YBB-BOD-LOCATIONBOD_LOCATION | Alpha 22 (Lower Case) | — | APBD.1 |
YBB-BOD-DOC-IDBOD_DOC_ID | Alpha 100 (Lower Case) | — | APBD.1 |
YBB-BOD-SORBOD_SOR | Alpha 1 | — | APBD.1 |
YBB-BOD-REVISIONBOD_REVISION | Alpha 22 (Lower Case) | — | APBD.1 |
YBB-BOD-VAR-IDBOD_VAR_ID | Alpha 22 (Lower Case) | — | APBD.1 |
Indexes (2)
Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
YBBSET1 | VENDOR-GROUP, VENDOR, LOCATION-CODE | Primary | AP10.1, AP10.2, AP100, AP109, AP110, AP111, AP115, AP125 +22 more (list truncated in source) | |
YBBSET2 | BOD-DOC-ID, BOD-ACCT-ENT, BOD-LOCATION, BOD-REVISION | APBD.1, APBD.2 |
Relations
One to one (1) — lookups and parents
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Apvenloc | APVENLOC | Required | YBB-VENDOR-GROUP → VLO-VENDOR-GROUP, YBB-VENDOR → VLO-VENDOR, YBB-LOCATION-CODE → VLO-LOCATION-CODE |
Programs
Updated by (1)
- APBD.1 AP BOD Maintenance
Referenced by (89)
- AP10.1 Vendor
- AP10.2 Vendor Location
- AP100 Vendor Group Copy
- AP109 Vendor Current Address Update
- AP110 Mass Vendor Update
- AP111 Vendor Deletion
- AP115 Vendor Merge
- AP125 Batch Release
- AP126 Mass Invoice Release
- AP14.1 Vendor Contact
- AP14.2 Vendor Contact Address
- AP14.5 1099 Tax Identification Information
- AP150 Cash Requirements
- AP151 Bill of Exchange Generation
- AP16.1 Vendor Bank
- AP16.2 Vendor Location Bank
- AP160 Payment Tape Creation
- AP161 Electronic Payment File Creation
- AP170 Payment Closing
- AP180 Bill of Exchange Cashing Update
- AP181 Bill of Exchange Statement Update
- AP190 Invoice Reinstatement
- AP193 Recurring Invoice Update
- AP20.1 Basic Invoice
- AP20.2 Taxed Invoice
- AP20.3 Detail Invoice
- AP20.4 Invoice Line Detail
- AP20.5 Multiple Invoice
- AP20.6 Prepayment
- AP20.7 Distributions
- AP21.1 View Distributions
- AP23.1 Transit Invoice Entry
- AP25.1 Batch Control
- AP25.2 Batch Review
- AP26.1 Invoice Release
- AP27.1 Single Invoice Release
- AP28.1 Bill of Exchange Acceptance by Vendor
- AP28.2 Bill of Exchange Acceptance by Date
- AP30.1 Invoice Maintenance
- AP30.2 Distribution Adjustments
- AP30.4 Invoice Cancel
- AP300 Invoice and Vendor History Purge
- AP305 Accounts Payable Company Purge
- AP510 Vendor Conversion
- AP520 Invoice Interface
- AP590 AP Vendor CSV
- AP750 AP shell program for FIN BOD
- API1.1 Add Invoice
- API2.1 Add Invoice
- CB00.1 Bank
- CB10.1 Cash Receipt Deposit
- CB150 Mass Release
- EE135 Mass Employee Release
- EE20.1 Employee Advance
- EE20.2 Employee Expense
- EE35.1 Advance Release
- EE35.2 Expense Release
- EE520 Expense Interface
- IC64.6 Global Location Number Assignment Vendor
- MA41.1 Add-On Cost Detail - Purchase Order
- MA41.2 Add On Cost Lookup
- MA41.4 Miscellaneous Add-On Cost
- MA41.7 AOC Approval Entry
- MA42.1 Memo Line Detail - Purchase Order
- MA42.2 Memo Line AOC Detail
- MA43.1 Invoice Line Detail - Purchase Order
- MA43.2 Purchase Order Lookup
- MA43.3 Invoice Line Detail - Receipt
- MA43.4 Invoice Line Detail - Service
- MA43.6 Service Agreement Detail
- MA44.1 Invoice Line Detail - Purchase Order
- MA44.2 Invoice Line Detail- Service
- MA60.2 Invoice Level Match
- MA60.3 Detail Level Match
- MA60.4 Invoice Match Reference Adjustment
- MA61.1 Match Invoice Approval
- MA64.6 Message Detail by Invoice
- MA64.9 PO Cost Message Accept Upload
- MA65.1 Invoice Line Adjustment
- MA66.1 Review Invoice Message
- MA66.2 Invoice Message - Details
- MA66.3 Purchase Order Cost Review Message
- MA67.3 Detail Match from frontend
- MA68.2 Invoice Level Match - Prepaid
- MA68.4 Invoice Match Reference Adjustment
- MA70.1 Invoice Unmatch
- MA75.1 PO Invoice Cancel
- MAED.1 Vendor
- MAI1.1 Invoke for MAMATCH Object