|
|
ACSRVCLOC FILE
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.
REFERENCED BY
BR00.1 BR00.2 BR02.3 BR11.1 BR120 BR121
BR122 BR123 BR140 BR151 BR152 BR155
BR156 BR20.1 BR20.2 BR20.3 BR20.4 BR20.5
BR20.6 BR200 BR211 BR216 BR251 BR252
BR420 BR46.1 BR46.2 BR46.4 BR51.1 BR52.2
BR521 BR570 BR70.1 BRIP.1
UPDATED BY
BR16.1 BR180 TX140 TX40.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ASV-COMPANY Numeric 4 BR16.1
Element: Company The company number represents an
established AR company.
ASV-CUSTOMER Alpha 9 (Right Justified) BR16.1
Element: Customer This field contains the number that
represents a customer.
ASV-SERVICE-LOC Numeric 4 BR16.1
Element: Service Loc A user defined code identifying a
customer's service location.
ASV-NAME Alpha 30 (Lower Case) BR16.1
Element: Name This field maintains the service
location name.
ASV-ADDR1 Alpha 30 (Lower Case) BR16.1
Element: Addr1 This field contains the first line of
address information.
ASV-ADDR2 Alpha 30 (Lower Case) BR16.1
Element: Addr1 This field contains the first line of
address information.
ASV-ADDR3 Alpha 30 (Lower Case) BR16.1
Element: Addr1 This field contains the first line of
address information.
ASV-ADDR4 Alpha 30 (Lower Case) BR16.1
Element: Addr1 This field contains the first line of
address information.
ASV-CITY Alpha 18 (Lower Case) BR16.1
Element: City This field contains the city of the
address.
ASV-STATE Alpha 2 BR16.1
Element: State This field contains the two-character
state code of the address.
ASV-ZIP Alpha 10 BR16.1
Element: Zip This field contains the postal code of
the address.
ASV-COUNTY Alpha 25 (Lower Case) BR16.1 BR180
Element: County This field is the County name. TX140 TX40.1
ASV-COUNTRY-CODE Alpha 2 BR16.1
Element: Country Code The country code. Required for VAT and
intrastat reporting. Must be defined in
IN01.1 (Country Maintenance).
ASV-REGION Alpha 2 BR16.1
Element: Region The region code, if applicable for the
country. Used by Intrastat. Must be
defined in IN02.1 (Region Maintenance)
ASV-ACTIVE-FLAG Alpha 1 BR16.1
Element: Active Flag This flag indicates the active or
inactive status. A - Active, I -
Inactive
A = Active
I = Inactive
ASV-TAX-EXEMPT-CD Alpha 1 BR16.1
Element: Tax Exempt Cd Code indicating the taxing status. E -
Exempt, T - Taxable.
E = Exempt
T = Taxable
ASV-TAX-CODE Alpha 10 BR16.1 BR180
Element: Tax Code A user defined code representing the TX140 TX40.1
tax authorites tax is paid to. Tax
codes are set up in the Tax System.
ACSRVCLOC FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ASVSET1 COMPANY BR00.1 BR00.2
CUSTOMER BR02.3 BR11.1
SERVICE-LOC BR120 BR121
BR122 BR123
BR140 BR151
BR152 BR155
BR156 BR16.1
BR180 BR20.1
BR20.2 BR20.3
BR20.4 BR20.5
BR20.6 BR200
BR211 BR216
BR251 BR252
BR420 BR46.1
BR46.2 BR46.4
...
ACSRVCLOC FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
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
|
