|
ACSRVCLOC FILE
Activity Service Location
REFERENCED BY
BR123 BR151 BR152 BR155 BR156 BR251
BR252 BR51.1 BR52.2 BRPI.1
UPDATED BY
BR16.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ASV-COMPANY Numeric 4 BR16.1
Element: Company The company number represents an
established company and is entered on
all function codes.
ASV-CUSTOMER Alpha 9 (Right Justified) BR16.1
Element: Customer NumbeThis field contains the number that
represents a customer.
ASV-SERVICE-LOC Numeric 4 BR16.1
Element: Service Loc
ASV-NAME Alpha 30 (Lower Case) BR16.1
Element: Name Displays the company description.
ASV-ADDR1 Alpha 30 (Lower Case) BR16.1
Element: Address 1 This field contains the first line of
address information.
ASV-ADDR2 Alpha 30 (Lower Case) BR16.1
Element: Address 1
ASV-ADDR3 Alpha 30 (Lower Case) BR16.1
Element: Address 1
ASV-ADDR4 Alpha 30 (Lower Case) BR16.1
Element: Address 1
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 or ProviThis field contains the two-character
state code of the address.
ASV-ZIP Alpha 10 BR16.1
Element: Postal Code This field contains the postal code of
the address.
ASV-COUNTY Alpha 25 (Lower Case) BR16.1
Element: County The county for the company address.
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 Code 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: Status The Active flag of the credit card
type.
A = Active
I = Inactive
ASV-TAX-EXEMPT-CD Alpha 1 BR16.1
Element: Tax Exempt CodE = Exempt
T = Taxable
ASV-TAX-CODE Alpha 10 BR16.1
Element: Tax Code This field contains a code representing
specific tax information. This must be
valid Tax Code.
ACSRVCLOC FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ASVSET1 COMPANY BR123 BR151
CUSTOMER BR152 BR155
SERVICE-LOC BR156 BR16.1
BR251 BR252
BR51.1 BR52.2
BRPI.1
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
|