APDSUSRFLD – Accounts Payable User Fields
- System
- Accounts Payable (AP)
- Prefix
DFL- Primary key
API-OBJ-ID,DIST-SEQ-NBR- Fields
- 7
- Updated by
- 33 programs
- Referenced by
- 2 programs
APDSUSRFLD is the Accounts Payable User Fields table in Lawson Accounts Payable (prefix DFL). It is indexed by API-OBJ-ID, DIST-SEQ-NBR (DFLSET1). It is updated by AP170, AP180, AP181, AP190, AP198, AP20.1, AP20.2, AP20.3 and 25 more and referenced by AP175 and AP36.2. The table has 7 fields, 1 index and 0 documented relations.
About APDSUSRFLD
The Distribution User Fields file contains user fields that you can enter on distributions.
Fields (7)
Column = COBOL field name without the DFL- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
DFL-API-OBJ-ID PKAPI_OBJ_ID | Numeric 12 | A subsystem object interface identifier. | AP170, AP180, AP181, AP190, AP20.1, AP20.2, AP20.3, AP20.4 +19 more |
DFL-DIST-SEQ-NBR PKDIST_SEQ_NBR | Numeric 6 | Sequence number to keep the distribution unique. | AP170, AP180, AP181, AP190, AP20.1, AP20.2, AP20.3, AP20.4 +22 more |
DFL-DST-USR-FLD-01DST_USR_FLD_01 | Alpha 20 | Distribution user field number 1. | AP180, AP181, AP190, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +18 more |
DFL-DST-USR-FLD-02DST_USR_FLD_02 | Alpha 20 | Distribution user field number 2. | AP180, AP181, AP190, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +18 more |
DFL-DST-USR-FLD-03DST_USR_FLD_03 | Alpha 20 | Distribution user field number 3. | AP170, AP180, AP181, AP190, AP20.1, AP20.2, AP20.3, AP20.4 +19 more |
DFL-DST-USR-FLD-04DST_USR_FLD_04 | Alpha 20 | Distribution user field number 4. | AP170, AP180, AP181, AP190, AP20.1, AP20.2, AP20.3, AP20.4 +19 more |
DFL-DST-USR-FLD-05DST_USR_FLD_05 | Alpha 20 | Distribution user field number 5. | AP170, AP180, AP181, AP190, AP20.1, AP20.2, AP20.3, AP20.4 +19 more |
Indexes (1)
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 |
|---|---|---|---|---|
DFLSET1 | API-OBJ-ID, DIST-SEQ-NBR | Primary | AP175, AP190, AP198, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +18 more |
Programs
Updated by (33)
- AP170 Payment Closing
- AP180 Bill of Exchange Cashing Update
- AP181 Bill of Exchange Statement Update
- AP190 Invoice Reinstatement
- AP198 Invoice Data Archival
- AP20.1 Basic Invoice
- AP20.2 Taxed Invoice
- AP20.3 Detail Invoice
- AP20.4 Invoice Line Detail
- AP20.5 Multiple Invoice
- AP20.7 Distributions
- AP21.1 View Distributions
- AP23.1 Transit Invoice Entry
- AP28.1 Bill of Exchange Acceptance by Vendor
- AP28.2 Bill of Exchange Acceptance by Date
- AP30.2 Distribution Adjustments
- AP30.4 Invoice Cancel
- AP300 Invoice and Vendor History Purge
- AP305 Accounts Payable Company Purge
- AP45.1 Reportable Income Adjustment
- AP520 Invoice Interface
- API1.1 Add Invoice
- API2.1 Add Invoice
- 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.2 Memo Line AOC Detail
- MA43.2 Purchase Order Lookup
- MA44.1 Invoice Line Detail - Purchase Order
- MA44.2 Invoice Line Detail- Service
- MA70.1 Invoice Unmatch
- MA75.1 PO Invoice Cancel