Lawson Insight Technical Documentation


ERDs Tables Elements Libraries App Forms

                             SABOOKAOC FILE

                               Booked AOC

The Booked Add-On Charges file stores booked add-on charges.  Charges can be
associated with an order or with a specific order line.  The line number will
be zero for charges associated with the entire order.

UPDATED BY

SA100     SA101     SA110     SA300     SA990

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

SAA-COMPANY          Numeric 4                                   SA100   SA110
Company              The company number represents the           SA300
                     highest organizational level and is
                     required on all form action codes.

SAA-ORDER-NBR        Numeric 8                                   SA100   SA110
Order Number         Each order is assigned a unique number.     SA300
                     Order numbers are either manually
                     assigned or system assigned based on a
                     company-level option.

SAA-LINE-NBR         Numeric 6                                   SA100   SA110
Line Number          This field contains the line number.        SA300

SAA-SEQ              Numeric 3                                   SA100   SA110
Sequence             This field contains the record sequence     SA300
                     number.

SAA-MISC             Alpha 16                                    SA100   SA110
Miscellaneous        Booked add-on charge code.  Add-on          SA300
                     charges are created/updated using BL09
                     (Add-on Charges).

SAA-YEAR             Numeric 4                                   SA100   SA110
Year                 Contains the fiscal year for the data       SA300   SA990
                     stored on this record.

SAA-PERIOD           Numeric 2                                   SA100   SA110
Period               Contains period when booked or actual       SA300   SA990
                     sales occurred.

SAA-SALES-MAJCL      Alpha 4                                     SA100   SA110
Major Sales Class    Major sales class for this add-on           SA300
                     charge.  Used for summarization.

SAA-SALES-MINCL      Alpha 4                                     SA100   SA110
Minor Sales Class    Minor sales class for this add-on           SA300
                     charge.  Used for summarization.

SAA-TOTAL-SALE       Signed 15.2                                 SA100   SA110
Total Sale           Total dollar amount booked for this         SA300
                     add-on charge.

SAA-TOTAL-COST       Signed 15.2                                 SA100   SA110
Total Cost           Total cost booked for this add-on           SA300
                     charge.

SAA-ACTIVITY         Alpha 15                                    SA100   SA110
Activity             Used for Revenue (Sales) postings           SA300
                     whereas the Activity-C field is used for
                     Cost (COGS) postings.

                     Activities are the processes or
                     procedures that produce work. Cost
                     objects (products, services, customers,
                     and so on) are the reasons for
                     performing the activity. Activities and
                     cost object activities are used
                     synonymously in the Lawson Activity
                     Management system. Direct costs are
                     posted to activities, and indirect costs
                     are allocated to activities based on
                     activity drivers.

                     Activities are grouped or organized by
                     activity levels. There are two types of
                     activities: "posting allowed" and
                     "summary only." Use posting level
                     activities to budget and maintain all
                     posted transactions. Summary activities
                     or macro activities combine information
                     and balances from lower level activities
                     for reporting and inquiries.

SAA-ACCT-CATEGORY    Alpha 5                                     SA100   SA110
Account Category     Used for Revenue (Sales) postings           SA300
                     whereas the Acct-Categ-C field is used
                     for Cost (COGS) postings.

                     Account categories are groupings of
                     costs, revenues, or a combination of
                     both used for reporting and inquiries
                     for activities in the Lawson Activity
                     Management system. All transactions are
                     posted to an account category within an
                     activity. You can assign a specific
                     General Ledger account or range of
                     accounts (company, accounting unit,
                     account, and subaccount) that make up
                     the transactions posted to an account
                     category using AC07.1 (Account
                     Assignment).

                     Period-to-date, year-to-date, and
                     life-to-date balances are maintained by
                     account category for activities. Account
                     categories must be assigned to
                     activities before you do any budgeting
                     or transaction processing.

SAA-ACTIVITY-C       Alpha 15                                    SA100   SA110
Activity C           Used for Cost (COGS) postings whereas       SA300
                     the Activity field is used for Revenue
                     (Sales) postings.

                     Activities are the processes or
                     procedures that produce work. Cost
                     objects (products, services, customers,
                     and so on) are the reasons for
                     performing the activity. Activities and
                     cost object activities are used
                     synonymously in the Lawson Activity
                     Management system. Direct costs are
                     posted to activities, and indirect costs
                     are allocated to activities based on
                     activity drivers.

                     Activities are grouped or organized by
                     activity levels. There are two types of
                     activities: "posting allowed" and
                     "summary only." Use posting level
                     activities to budget and maintain all
                     posted transactions. Summary activities
                     or macro activities combine information
                     and balances from lower level activities
                     for reporting and inquiries.

SAA-ACCT-CATEG-C     Alpha 5                                     SA100   SA110
Account Category C   Used for Cost (COGS) postings whereas       SA300
                     the Acct-Category field is used for
                     Revenue (Sales) postings.

                     Account categories are groupings of
                     costs, revenues, or a combination of
                     both used for reporting and inquiries
                     for activities in the Lawson Activity
                     Management system. All transactions are
                     posted to an account category within an
                     activity. You can assign a specific
                     General Ledger account or range of
                     accounts (company, accounting unit,
                     account, and subaccount) that make up
                     the transactions posted to an account
                     category using AC07.1 (Account
                     Assignment).

                     Period-to-date, year-to-date, and
                     life-to-date balances are maintained by
                     account category for activities. Account
                     categories must be assigned to
                     activities before you do any budgeting
                     or transaction processing.

                         SABOOKAOC FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

SAASET1   COMPANY                                                SA100   SA101
          ORDER-NBR                                              SA110   SA300
          LINE-NBR                                               SA990
          SEQ

SAASET2   COMPANY       Duplicates
          YEAR
          PERIOD
          MISC

                         SABOOKAOC FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Iccompany      ICCOMPANY    Required

                            SAA-COMPANY        -> ICC-COMPANY  (ICCSET1)

Majorcl        MAJORCL      Required

                            ICC-ITEM-GROUP     -> MAJ-ITEM-GROUP
                            "S"                -> MAJ-CLASS-TYPE
                            SAA-SALES-MAJCL    -> MAJ-MAJOR-CLASS

Minorcl        MINORCL      Required

                            ICC-ITEM-GROUP     -> MIN-ITEM-GROUP
                            "S"                -> MIN-CLASS-TYPE
                            SAA-SALES-MAJCL    -> MIN-MAJOR-CLASS
                            SAA-SALES-MINCL    -> MIN-MINOR-CLASS

Sabooked       SABOOKED     Required

                            SAA-COMPANY        -> SAB-COMPANY
                            SAA-ORDER-NBR      -> SAB-ORDER-NBR

Sabookline     SABOOKLINE   Required
                            When SAA-LINE-NBR != Zeroes

                            SAA-COMPANY        -> SAL-COMPANY
                            SAA-ORDER-NBR      -> SAL-ORDER-NBR
                            SAA-LINE-NBR       -> SAL-LINE-NBR