Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

OIINVCMISC


                            OIINVCMISC FILE

                         Interface Invoice AOC

This is an invoice add-on charge batch interface file that can be used (in
conjunction with the Invoice Interface file) to interface add-on charges tied
to invoices and invoice lines from a source outside of the Lawson Order Entry
and Billing systems.  Once the records have been loaded to this file, BL520
(Billing Interface) can be run to load the records into the Lawson Billing
system.

UPDATED BY

BL520     BL98.1    BL98.2

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

OIX-COMPANY            Numeric 4                                 BL98.1  BL98.2
Element: Company       Identifies the AP company if the
                       resource type = V.  Identifies the HR
                       company if the resource type = E.  It is
                       blank for type A, P or Q resources.

OIX-INVC-PREFIX        Alpha 2                                   BL98.1  BL98.2
Element: Invc Prefix   Invoice or credit memo prefix must be
                       entered here for every invoice or credit
                       memo interfaced into the Billing system.
                       If this were an invoice created online
                       or by running OE129 (Daily Shipment
                       Journal), the system would assign the
                       prefix defined at either the company or
                       process level, depending on the invoice
                       level option chosen.

OIX-INVC-NUMBER        Numeric 8                                 BL98.1  BL98.2
Element: Invc Number   Invoice/credit memo number must be
                       unique within your company and must be
                       entered on this field for every add-on
                       charge record interfaced into the
                       system. This value indicates what
                       invoice or credit memo the add-on charge
                       is attached to.

OIX-LINE-NBR           Numeric 6                                 BL98.1  BL98.2
Element: Line Nbr      Displays the system-assigned number of
                       the line on the invoice to which the
                       add-on charge is attached if it is a
                       line add-on charge.

OIX-SEQ                Numeric 3                                 BL98.1  BL98.2
Element: Seq           This sequence number identifies the
                       number of the add-on charge this record
                       is among the rest of the add-on charges
                       attached to the invoice line or invoice.

OIX-MISC               Alpha 16                                  BL98.1  BL98.2
Element: Misc          Enter the add-on charge code (set up on
                       Add-on Charge (BL09.1)) that identifies
                       which add-on charge this record will be.

OIX-TAX-EXEMPT-CD      Alpha 1                                   BL98.1  BL98.2
Element: Tax Exempt Cd This value indicates whether the add-on
                       charge is tax exempt or not.
                       E = Exempt
                       T = Taxable

OIX-ENT-PRICE          Signed 18.2                               BL98.1  BL98.2
Element: Intl Amt      This is the price of the add-on charge.
                       If left blank, Billing Interface (BL520)
                       will price the add-on charge based on
                       the parameters tied to the add-on charge
                       on BL09.1 (Add-on Charge).

OIX-PRICE-PCT          Percent 5.3  (Percent)                    BL98.1  BL98.2
Element: Cost Pct      Price percent. This is the percent
                       applied to price to arrive at the add-on
                       charge.

OIX-COST               Signed 18.5                               BL98.1  BL98.2
Element: Intl Cost     Cost of the add-on charge as it is
                       entered on this field or defaulted onto
                       this field when the add-on charge record
                       is interfaced into Billing.

OIX-COST-PCT           Percent 5.3  (Percent)                    BL98.1  BL98.2
Element: Cost Pct      The cost percent. The percent to apply
                       to the unit cost of the item to arrive
                       at the add-on charge cost.

OIX-ORD-DISC-FL        Alpha 1                                   BL98.1  BL98.2
Element: Ord Disc Fl   Flag indicating whether or not the
                       add-on charge is to be included in tax
                       calculations. If any one of the
                       following are tax exempt, the exempt
                       flag will default onto this field:
                       Customer Ship to, Customer Master, or
                       Add-on Charge Code (setup on BL09.1).

OIX-ACTIVITY           Alpha 15                                  BL98.1  BL98.2
Element: Activity      In this file the Activity field is used
                       for revenue (sales) postings 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 Project Accounting.
                       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.

OIX-ACCT-CATEGORY      Alpha 5                                   BL98.1  BL98.2
Element: Acct Category In this file the Acct-Category field is
                       used for revenue (sales) postings
                       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 Project Accounting.
                       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 Account Assignment
                       (AC07.1).

                       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.

OIX-ACTIVITY-C         Alpha 15                                  BL98.1  BL98.2
Element: Activity      In this file the Activity-C field is
                       used for Cost (COGS) postings whereas
                       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 Project Accounting.
                       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.

OIX-ACCT-CATEG-C       Alpha 5                                   BL98.1  BL98.2
Element: Acct Category In this file the Acct-Categ-C field is
                       used for Cost (COGS) postings whereas
                       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 Project Accounting.
                       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 Account Assignment
                       (AC07.1).

                       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.

OIX-ENT-UNIT-PRC       Signed 18.5                               BL98.1  BL98.2
Element: Intl Cost     Price of add-on charge in original
                       currency.  Defaults from the add-on
                       charge set up on Add-on Charges
                       (BL09.1).

OIX-UNIT-COST          Signed 18.5                               BL98.1  BL98.2
Element: Intl Cost     The unit cost of the add-on charges in
                       base currency.

                         OIINVCMISC FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

OIXSET1   COMPANY                                                BL520   BL98.1
          INVC-PREFIX                                            BL98.2
          INVC-NUMBER
          LINE-NBR
          SEQ