ACSRVCLOC – This file maintains a service location for tax purposes.
- System
- AC Billing Revenue (BR)
- Prefix
ASV- Primary key
COMPANY,CUSTOMER,SERVICE-LOC- Fields
- 17
- Updated by
- 4 programs
- Referenced by
- 34 programs
ACSRVCLOC is the This file maintains a service location for tax purposes. table in Lawson AC Billing Revenue (prefix ASV). It is indexed by COMPANY, CUSTOMER, SERVICE-LOC (ASVSET1). It is related 1:1 to ARCOMP, CUSTDESC, INSTCTRYCD and INSTREGN. It is updated by BR16.1, BR180, TX140 and TX40.1 and referenced by BR00.1, BR00.2, BR02.3, BR11.1, BR120, BR121, BR122, BR123 and 26 more. The table has 17 fields, 1 index and 4 documented relations.
About ACSRVCLOC
This file maintains a service location for tax purposes. The service location allows you to define address parameters and tax rules at a level lower than the customer. If the Vertex system is used, the address parameters will be used in the invoice tax calculations. A customer can have multiple service locations associated with it. The defined service location can be attached at the customer/contract, activity, or account category billing parameter levels. The customer service location can be maintained via BR16 (Service Location). A service location listing can be produced by running BR216.
Fields (17)
Column = COBOL field name without the ASV- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
ASV-COMPANY PKCOMPANY | Numeric 4 | The company number represents an established AR company. | BR16.1 |
ASV-CUSTOMER PKCUSTOMER | Alpha 9 (Right Justified) | This field contains the number that represents a customer. | BR16.1 |
ASV-SERVICE-LOC PKSERVICE_LOC | Numeric 4 | A user defined code identifying a customer's service location. | BR16.1 |
ASV-NAMENAME | Alpha 30 (Lower Case) | This field maintains the service location name. | BR16.1 |
ASV-ADDR1ADDR1 | Alpha 30 (Lower Case) | This field contains the first line of address information. | BR16.1 |
ASV-ADDR2ADDR2 | Alpha 30 (Lower Case) | This field contains the first line of address information. | BR16.1 |
ASV-ADDR3ADDR3 | Alpha 30 (Lower Case) | This field contains the first line of address information. | BR16.1 |
ASV-ADDR4ADDR4 | Alpha 30 (Lower Case) | This field contains the first line of address information. | BR16.1 |
ASV-CITYCITY | Alpha 18 (Lower Case) | This field contains the city of the address. | BR16.1 |
ASV-STATESTATE | Alpha 2 | This field contains the two-character state code of the address. | BR16.1 |
ASV-ZIPZIP | Alpha 10 | This field contains the postal code of the address. | BR16.1 |
ASV-COUNTYCOUNTY | Alpha 25 (Lower Case) | This field is the County name. | BR16.1, BR180, TX140, TX40.1 |
ASV-COUNTRY-CODECOUNTRY_CODE | Alpha 2 | The country code. Required for VAT and intrastat reporting. Must be defined in IN01.1 (Country Maintenance). | BR16.1 |
ASV-REGIONREGION | Alpha 2 | The region code, if applicable for the country. Used by Intrastat. Must be defined in IN02.1 (Region Maintenance) | BR16.1 |
ASV-ACTIVE-FLAGACTIVE_FLAG | Alpha 1 | This flag indicates the active or inactive status. A - Active, I - Inactive
| BR16.1 |
ASV-TAX-EXEMPT-CDTAX_EXEMPT_CD | Alpha 1 | Code indicating the taxing status. E - Exempt, T - Taxable.
| BR16.1 |
ASV-TAX-CODETAX_CODE | Alpha 10 | A user defined code representing the tax authorites tax is paid to. Tax codes are set up in the Tax System. | BR16.1, BR180, TX140, TX40.1 |
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 |
|---|---|---|---|---|
ASVSET1 | COMPANY, CUSTOMER, SERVICE-LOC | Primary | BR00.1, BR00.2, BR02.3, BR11.1, BR120, BR121, BR122, BR123 +22 more (list truncated in source) |
Relations
One to one (4) — lookups and parents
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Arcomp | ARCOMP | Required | ASV-COMPANY → ACO-COMPANY | |
| Custdesc | CUSTDESC | Required | ACO-CUST-GROUP → CUD-CUST-GROUP, ASV-CUSTOMER → CUD-CUSTOMER | |
| Instctrycd | INSTCTRYCD | Not Required | ASV-COUNTRY-CODE → INT-COUNTRY-CODE | |
| Instregn | INSTREGN | Not Required | ASV-COUNTRY-CODE → INR-COUNTRY-CODE, ASV-REGION → INR-REGION |
Programs
Updated by (4)
- BR16.1 Service Location
- BR180 Location Vertex Geocode Update
- TX140 Vertex Geocode Update
- TX40.1 Tax Inquiry for Vertex
Referenced by (34)
- BR00.1 Activity Billing
- BR00.2 Billing Detail
- BR02.3 Retainer Invoice Entry
- 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
- 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.6 Invoice Edit Detail
- BR200 Billing Listing
- BR211 Activity Customer Listing
- BR216 Service Location Listing
- BR251 Product Contract Listing
- BR252 Maintenance Schedule Listing
- BR420 Billing Invoice Report
- BR46.1 Bill in Advance
- BR46.2 Transfer Invoice Transaction
- BR46.4 Split Transfer
- BR51.1 Product Contract
- BR52.2 New Maintenance Schedule
- BR521 Billing Import
- BR570 Product Contract Interface
- BR70.1 Product Contract Interface Adjustment
- BRIP.1 Invoice Print Program