Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ACBILLTOX


                             ACBILLTOX FILE

                        Activity Bill To Detail

This file maintains the bill-to group detail for customer invoicing.  A bill
to  group can be assigned to each customer invoice option. A bill to group is
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

BR217     BRIP.1    BR00.1    BR00.2    BR02.3    BR120
BR121     BR122     BR140     BR19.1    BR20.1    BR20.2
BR20.3    BR20.4    BR20.5    BR21.1    BR420     BR46.1
BR46.2    BR46.4    BR521

UPDATED BY

BR17.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

ABO-COMPANY            Numeric 4                                 BR17.1
Element: Company       The company number represents an
                       established AR company.  The company for
                       the bill to group is  maintained on the
                       Bill to Group  (BR17.1).

ABO-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).

ABO-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)

ABO-BILL-TO            Numeric 4                                 BR17.1
Element: Bill To       This field contains the mailing address
                       for the invoice.  Bill to addresses are
                       maintained in the Accounts Receviable
                       Bill To (AR09.4) and added in Bill To
                       Group (BR17.1).

ABO-PRIMARY-FLAG       Alpha 1                                   BR17.1
Element: Primary Flag  This flag identifies which bill-to
                       address within a bill-to group should be
                       used for invoicing and to send to the
                       subsystems. This flag is  maintained in
                       Bill To  Group (BR17.1)

                         ACBILLTOX FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

ABOSET1   COMPANY                                                BR17.1  BR217
          CUSTOMER                                               BRIP.1
          BILL-TO-GRP
          BILL-TO

ABOSET2   COMPANY       Subset                                   BR00.1  BR00.2
          CUSTOMER      Where PRIMARY-FLAG = "Y"                 BR02.3  BR120
          BILL-TO-GRP                                            BR121   BR122
          BILL-TO                                                BR140   BR17.1
                                                                 BR19.1  BR20.1
                                                                 BR20.2  BR20.3
                                                                 BR20.4  BR20.5
                                                                 BR21.1  BR420
                                                                 BR46.1  BR46.2
                                                                 BR46.4  BR521

                         ACBILLTOX FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Acbillto       ACBILLTO     Required

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

Arcomp         ARCOMP       Required

                            ABO-COMPANY        -> ACO-COMPANY

Billto         BILLTO       Required

                            ACO-CUST-GROUP     -> ABS-CUST-GROUP
                            ABO-CUSTOMER       -> ABS-CUSTOMER
                            ABO-BILL-TO        -> ABS-BILL-TO