Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ACBILLTO


                             ACBILLTO FILE

                            Activity Bill To

This file maintains a bill-to group for customer invoicing.  A bill to group
can be assigned to each customer invoice option.  A bill to group is added and
maintained via BR17 (Bill-to Group).  The ACBILLTO file maintains the AR
company, customer, group name and description.  The ACBILLTOX file maintains
the bill to's associated with the group.  A bill-to group is made up of
multiple bill-to addresses, which are defined in the AR Bill-To from (AR09.4).
 A bill-to group  listing can be printed  by running BR217 (Bill-To Group
Listing).

REFERENCED BY

BR11.1    BR20.7    BR211     BR217

UPDATED BY

BR17.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

ABL-COMPANY            Numeric 4                                 BR17.1
Element: Company       The company number represents an
                       established AR company. The Bill to
                       Group Company is maintained on Bill To
                       Group (BR17.1).

ABL-CUSTOMER           Alpha 9  (Right Justified)                BR17.1
Element: Customer NumbeThis field contains the number that
                       represents a customer.  The customer for
                       the Bill To Group is maintained on Bill
                       To Group (BR17.1)

ABL-BILL-TO-GRP        Numeric 4                                 BR17.1
Element: Bill To Grp   Used to identify a group of AR bill-to
                       addresses used for customer invoicing in
                       the BR system.  The Bill to Group is
                       maintained on Bill To Group (BR17.1) and
                       associated with the Customer(BR11.1).

ABL-DESCRIPTION        Alpha 30  (Lower Case)                    BR17.1
Element: Description   This field displays the description of
                       the Bill to Group maintained on Bill To
                       Group (BR17.1).

                         ACBILLTO FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

ABLSET1   COMPANY                                                BR11.1  BR17.1
          CUSTOMER                                               BR20.7  BR211
          BILL-TO-GRP                                            BR217

                         ACBILLTO FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Acbilltox      ACBILLTOX

                            ABL-COMPANY        -> ABO-COMPANY
                            ABL-CUSTOMER       -> ABO-CUSTOMER
                            ABL-BILL-TO-GRP    -> ABO-BILL-TO-GRP
                                                  ABO-BILL-TO