Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

POCMMDIST


                             POCMMDIST FILE

UPDATED BY

PO520     PO53.3    PO53.4    PO53.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

CMS-PROCURE-GROUP      Alpha 4                                   PO520   PO53.3
Element: Procure Group This field contains the identifier for a  PO53.4
                       group of companies that share a common
                       procurement effort. They buy items and
                       services together.

CMS-COMPANY            Numeric 4                                 PO520   PO53.3
Element: Company       Identifies the AP company if the          PO53.4
                       resource type = V.  Identifies the HR
                       company if the resource type = E.  It is
                       blank for type A, P or Q resources.

CMS-PO-NUMBER          Alpha 14  (Right Justified)               PO520   PO53.3
Element: PO Number     This field contains the number            PO53.4
                       representing the purchase order.

CMS-PO-RELEASE         Numeric 4                                 PO520   PO53.3
Element: PO Release NumUsed to identify a purchase order         PO53.4
                       release (created from a Blanket or
                       Standing order).

CMS-PO-CODE            Alpha 4                                   PO520   PO53.3
Element: Po Code       This is the purchase order code.          PO53.4

CMS-LINE-NBR           Numeric 6                                 PO520   PO53.3
Element: Line Number   This field contains the line number.      PO53.4

CMS-LINE-SEQ           Numeric 3                                 PO520   PO53.3
Element: Sequence Number                                         PO53.4

CMS-AOC-CODE           Alpha 2                                   PO520   PO53.3
Element: Add On Cost CoThis field contains the identifier for    PO53.4
                       the add on cost associated with this
                       line item.

CMS-REC-TYP            Numeric 2                                 PO520   PO53.3
Element: Rec Typ       14 = MMDIST record                        PO53.4

CMS-ACCT-UNIT          Alpha 15                                  PO520   PO53.3
Element: Accounting UniThe accounting unit is a shorthand        PO53.4
                       notation representing the variable level
                       number. When used in the General Ledger
                       Account Master file, the accounting unit
                       must be defined in the General Ledger
                       Names file as a posting accounting unit.


CMS-ACCOUNT            Numeric 6                                 PO520   PO53.3
Element: Account       This field along with the accounting      PO53.4
                       unit and subaccount make up the location
                       (account) where amounts and other
                       account information is stored.

CMS-SUB-ACCT           Numeric 4                                 PO520   PO53.3
Element: Subaccount    This field contains the subaccount from   PO53.4
                       your general ledger chart of accounts
                       that was charged with the amount carried
                       on this record.

CMS-DIST-COMPANY       Numeric 4                                 PO520   PO53.3
Element: Company       The company number used for posting the   PO53.4
                       transaction. A valid intercompany
                       relationship must be defined in the
                       Lawson General Ledger system.

CMS-ACTIVITY           Alpha 15                                  PO520   PO53.3
Element: Activity      Activities are the processes or           PO53.4
                       procedures that produce work. Cost
                       objects (products, services, customers,
                       and so on) are the reasons for
                       performing the activity.


CMS-ACCT-CATEGORY      Alpha 5                                   PO520   PO53.3
Element: Account CategoAccount categories are groupings of       PO53.4
                       costs, revenues, or a combination of
                       both used for reporting and inquiries
                       for activities in the 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.

                       Valid account category types are:
                       cost
                       revenue
                       accrual
                       pass thru

CMS-BILL-CATEGORY      Alpha 32                                  PO520   PO53.3
Element: Bill Category                                           PO53.4

CMS-ASSET-TEMPLATE     Alpha 10                                  PO520   PO53.3
Element: Asset TemplateA user-defined asset template             PO53.4
                       identifies general asset creation
                       parameters that you can use to quickly
                       add assets with minimal keying. Using a
                       template lets you default many data
                       items associated with a new asset.

                       You can use an asset template to
                       process quick asset additions in AM20.1
                       (Quick Addition) and to create assets
                       and asset books from Accounts Payable
                       and Activity Management interface
                       information. Asset templates are
                       required if you define new assets as a
                       result of transactions interfaced from
                       the Lawson Purchase Order or Accounts
                       Payable systems.

CMS-ASSET              Numeric 10                                PO520   PO53.3
Element: Asset Number  The asset number contains up to ten       PO53.4
                       numeric characters that uniquely
                       identify an asset. Assets are
                       automatically numbered system-wide.

CMS-DIST-PERCENT       Signed 6.3                                PO520   PO53.3
Element: Total Percent This field indicates the percent of the   PO53.4
                       extended value of the line that is
                       associated with this account, if the
                       breakdown is by percent.

CMS-DIST-QTY           Signed 13.4                               PO520   PO53.3
Element: Quantity      This field indicates the quantity from    PO53.4
                       the line that is to be posted to this
                       account, if distributed by quantity. The
                       total amount distributed would be
                       quantity times unit cost.

                         POCMMDIST FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

CMSSET1   PROCURE-GROUP                                          PO520   PO53.1
          COMPANY                                                PO53.3  PO53.4
          PO-NUMBER
          PO-RELEASE
          PO-CODE
          LINE-NBR
          AOC-CODE
          LINE-SEQ