Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

OIINVCCOMM


                            OIINVCCOMM FILE

                       Interface Invoice Comments

This is an invoice comment batch interface file that can be used (in
conjunction with the Invoice Interface file) to interface invoice comments
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

OIW-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.

OIW-INVC-PREFIX        Alpha 2                                   BL98.1  BL98.2
Element: Invoice PrefixInvoice or credit memo prefix must be
                       entered here for every invoice/credit
                       interfaced into the Billing system. If
                       this were on an invoice created online
                       or by 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.

OIW-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 Invoice
                       Comment record interfaced into the
                       system. This value indicates what
                       invoice/credit memo the comment is
                       attached to.

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

OIW-SEQ                Numeric 3                                 BL98.1  BL98.2
Element: Sequence NumbeThis sequence number identifies the
                       number of the comment this record is
                       among the rest of the comments attached
                       to the invoice line or invoice.

OIW-COMMENT            Alpha 40  (Lower Case)                    BL98.1  BL98.2
Element: Comment Line  The comment narrative.

OIW-PRINT-CODE         Alpha 1                                   BL98.1  BL98.2
Element: Print Code    This field contains the print code,
                       which defines where comments are
                       displayed or printed.

                         OIINVCCOMM FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

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