ARCUSTFLDS – AR Customer User Fields

System: Accounts Receivable (AR)
Prefix: ACF
Primary key: COMPANY, CUSTOMER
Fields: 12
Updated by: 6 programs
Referenced by: 101 programs

ARCUSTFLDS is the AR Customer User Fields table in Lawson Accounts Receivable (prefix ACF). It is indexed by COMPANY, CUSTOMER (ACFSET1). It is related 1:1 to ARCUSTOMER. It is updated by AR09.1, AR10.1, AR301, AR501, AR550 and TX140 and referenced by AC56.1, AC560, AR11.1, AR12.1, AR12.2, AR13.1, AR13.2, AR210 and 93 more. The table has 12 fields, 1 index and 1 documented relation.

About ARCUSTFLDS

The AR Customer User Fields file carries ten user-defined field information for each customer. User-defined field information consists of ten fields at the company customer level. These fields serve as reference fields only.

Fields (12)

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

Field / column	Type	Description & values	Updated by
`ACF-COMPANY` PK COMPANY	Numeric 4	The number representing an AR company.	AR09.1, AR10.1, AR301, AR501, AR550, TX140
`ACF-CUSTOMER` PK CUSTOMER	Alpha 9 (Right Justified)	Customer number.	AR09.1, AR10.1, AR301, AR501, AR550, TX140
`ACF-CUST-USER1` CUST_USER1	Alpha 10	Customer user-defined field 1. The data is optionally maintained in AR10.1 (Customer).	AR09.1, AR10.1, AR301, AR501, AR550, TX140
`ACF-CUST-USER2` CUST_USER2	Alpha 18	Customer user-defined field 2. This data is optionally maintained in AR10.1 (Customer).	AR09.1, AR10.1, AR301, AR501, AR550, TX140
`ACF-CUST-USER3` CUST_USER3	Signed 18.2	Customer user-defined field 3. This data is optionally maintained in AR10.1 (Customer).	AR09.1, AR10.1, AR301, AR501, AR550, TX140
`ACF-CUST-USER4` CUST_USER4	Signed 18.2	Customer user-defined field 4. This data is optionally maintained in AR10.1 (Customer).	AR09.1, AR10.1, AR301, AR501, AR550, TX140
`ACF-CUST-USER5` CUST_USER5	Numeric 9	Customer user-defined field 5. This data is optionally maintained in AR10.1 (Customer).	AR09.1, AR10.1, AR301, AR501, AR550, TX140
`ACF-CUST-USER6` CUST_USER6	Alpha 30	Customer user-defined field 6. This data is optionally maintained in AR10.1 (Customer).	AR09.1, AR10.1, AR301, AR501, AR550, TX140
`ACF-CUST-USER7` CUST_USER7	Alpha 30	Customer user-defined field 7. This data is optionally maintained in AR10.1 (Customer).	AR09.1, AR10.1, AR301, AR501, AR550, TX140
`ACF-CUST-USER8` CUST_USER8	Numeric 8 (yyyymmdd)	Customer user-defined field 8. This data is optionally maintained in AR10.1 (Customer).	AR09.1, AR10.1, AR301, AR501, AR550, TX140
`ACF-CUST-USER9` CUST_USER9	Numeric 3	Customer user-defined field 9. This data is optionally maintained in AR10.1 (Customer).	AR09.1, AR10.1, AR301, AR501, AR550, TX140
`ACF-CUST-USER10` CUST_USER10	Alpha 3	Customer user-defined field 10. This data is optionally maintained in AR10.1 (Customer).	AR09.1, AR10.1, AR301, AR501, AR550, TX140

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
`ACFSET1`	`COMPANY`, `CUSTOMER`	Primary		AC56.1, AC560, AR09.1, AR09.4, AR10.1, AR11.1, AR12.1, AR12.2 +22 more (list truncated in source)

Relations

One to one (1) — lookups and parents

Relation	Table	Rules	Condition	Field map
Arcustomer	ARCUSTOMER	Required		`ACF-COMPANY` → `ACM-COMPANY`, `ACF-CUSTOMER` → `ACM-CUSTOMER`

Programs

Updated by (6)

AR09.1 Customer Group Address
AR10.1 Customer
AR301 Customer Purge
AR501 Customer Conversion
AR550 Customer Interface
TX140 Vertex Geocode Update

Referenced by (101)

AC56.1 Setup Interface Adjustment
AC560 Setup Interface
AR11.1 Customer Contacts
AR12.1 National Account
AR12.2 National Account Speed Entry
AR13.1 MICR Customer
AR13.2 Customer MICR
AR210 Customer Listing
AR211 Customer Optional Fields Listing
ARLL.1 AR Transaction Interface
BR00.1 Activity Billing
BR00.2 Billing Detail
BR02.3 Retainer Invoice Entry
BR10.1 Contract Parameters
BR10.9 Product Contract Parameters
BR11.1 Customer
BR120 Invoice Calculation
BR121 Invoice Print and Interface
BR122 Online batch invoice process
BR123 Product Invoice Cancel
BR140 Billing and Revenue Backout
BR151 Product Invoicing
BR152 Maintenance Invoicing
BR155 Maintenance Schedule Copy
BR156 Maintenance Quote
BR16.1 Service Location
BR16.2 Customer Maintenance Renew Date
BR17.1 Bill To Group
BR180 Location Vertex Geocode Update
BR19.1 Single Invoice Calculation
BR20.1 Invoice Edit Contract
BR20.2 Invoice Edit Line
BR20.3 Invoice Edit Activity
BR20.4 Invoice Edit Activity and Account Category
BR20.5 Invoice Edit Transaction
BR20.7 Invoice Header
BR21.2 Filter
BR210 Contract Listing
BR211 Activity Customer Listing
BR216 Service Location Listing
BR217 Bill To Group Listing
BR220 Invoice Audit Listing
BR251 Product Contract Listing
BR252 Maintenance Schedule Listing
BR253 Deferred Revenue Listing
BR400 Invoice History
BR420 Billing Invoice Report
BR45.1 Invoice Control
BR450 Activity Aging
BR46.1 Bill in Advance
BR46.2 Transfer Invoice Transaction
BR46.4 Split Transfer
BR49.1 Invoice Adjustment Maintenance
BR51.1 Product Contract
BR51.2 Product Cost of Goods Sold
BR52.1 Maintenance Schedule
BR52.2 New Maintenance Schedule
BR521 Billing Import
BR53.1 Product Deferred Revenue Schedule
BR55.2 Filter
BR70.1 Product Contract Interface Adjustment
BR70.2 Product Interface Cost of Goods Sold
BR91.1 Contract By Customer Inquiry
BRIP.1 Invoice Print Program
CB06.2 Bank Statement Detail Entry
CB191 Bank Statement Close
IC02.1 Location
TX40.1 Tax Inquiry for Vertex
WH110 Batch Allocation
WH120 Route Creation
WH130 Pick List Print
WH132 Batch Feedback
WH190 Shipment Release
WH20.1 Inventoried Allocation
WH20.2 Nonstock and Special Allocation
WH20.7 Substitute Location
WH21.2 Stops
WH224 Packing List Print
WH226 Items on Backorder Report
WH30.1 Picking Feedback by Document
WH30.2 Picking Feedback by Shipment
WH30.3 Picking by Batch
WH30.4 Bin Sequence Picking Feedback
WH31.1 Packing Feedback by Document
WH31.2 Packing Feedback by Shipment
WH31.3 Packing by Batch
WH31.4 Bin Sequence Packing Feedback
WH32.1 Shipping Feedback by Document
WH32.2 Shipping Feedback by Shipment
WH32.3 Shipping by Batch
WH32.4 Bin Sequence Shipping Feedback
WH32.5 Shipping Line Feedback
WH33.5 Additional Shipment Information
WH34.1 Component Bins
WH34.2 Component Lots
WH34.3 Component Serials
WH34.4 Component UOMs
WH40.1 Bill of Lading
WH40.2 Bill of Lading Feedback
WH520 Batch Feedback Interface
WH830 Shipment Load Program