Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

OERETCMTIN


                            OERETCMTIN FILE

UPDATED BY

OE530     OE56.2

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

RCI-COMPANY            Numeric 4                                 OE56.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.

RCI-AUTH-NO            Numeric 10                                OE56.2
Element: Auth No

RCI-LINE-NBR           Numeric 6                                 OE56.2
Element: Line Number   This field contains the line number.

RCI-SEQ                Numeric 3                                 OE56.2
Element: Sequence NumbeThis field contains the record sequence
                       number.

RCI-RET-REF-NBR        Alpha 20                                  OE56.2
Element: Ret Ref Nbr

RCI-LOCATION           Alpha 5                                   OE56.2
Element: Location Code This field contains a valid stocking
                       location within the company inventory.

RCI-RTN-DATE           Numeric 8  (yyyymmdd)                     OE56.2
Element: Rtn Date

RCI-UPDATE-TIME        Numeric 6                                 OE56.2
Element: Update Time   This field contains the system time
                       when the record was updated.

RCI-COMMENT            Alpha 40  (Lower Case)                    OE56.2
Element: Comment Line  This field contains the comment
                       narrative.

RCI-INVC-FL            Alpha 1                                   OE56.2
Element: All Flag      This indicates if the comment prints on
                       the invoice.

RCI-RECORD-ERROR       Alpha 1                                   OE56.2
Element: Record Error

                         OERETCMTIN FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

RCISET1   COMPANY                                                OE530   OE56.2
          AUTH-NO
          LINE-NBR
          SEQ

RCISET2   COMPANY                                                OE530   OE56.2
          RET-REF-NBR
          LINE-NBR
          SEQ

RCISET3   COMPANY                                                OE56.2
          LOCATION
          RTN-DATE
          AUTH-NO
          LINE-NBR
          SEQ