Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                            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

BL98.1    BL98.2

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

OIW-COMPANY          Numeric 4                                   BL98.1  BL98.2
Company              The company number represents an
                     established company and is entered on
                     all function codes.

OIW-INVC-PREFIX      Alpha 2                                     BL98.1  BL98.2
Invoice Prefix       Invoice 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
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
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
Sequence Number      This 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
Comment Line         The comment narrative.

OIW-PRINT-CODE       Alpha 1                                     BL98.1  BL98.2
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                                                BL98.1  BL98.2
          INVC-PREFIX
          INVC-NUMBER
          LINE-NBR
          SEQ