|
|
OERETLNIN FILE
UPDATED BY
OE530 OE56.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
RLI-COMPANY Numeric 4 OE56.1
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.
RLI-AUTH-NO Numeric 10 OE56.1
Element: Auth No
RLI-LINE-NBR Numeric 6 OE56.1
Element: Line Number This field contains the line number.
RLI-RET-REF-NBR Alpha 20 OE56.1
Element: Ret Ref Nbr
RLI-LOCATION Alpha 5 OE56.1
Element: Location Code This field contains a valid stocking
location within the company inventory.
RLI-RTN-DATE Numeric 8 (yyyymmdd) OE56.1
Element: Rtn Date
RLI-UPDATE-TIME Numeric 6 OE56.1
Element: Update Time This field contains the system time
when the record was updated.
RLI-CUSTOMER Alpha 9 (Right Justified) OE56.1
Element: Customer NumbeThis field contains the number that
represents a customer.
RLI-SHIP-TO Numeric 4 OE56.1
Element: Ship-to Code This field contains the number
representing the ship to customer.
RLI-ORDER-NBR Numeric 8 OE56.1
Element: Order Number This field contains the order number.
RLI-ORIG-LINE-NBR Numeric 6
Element: Original Line Number
RLI-ITEM Alpha 32 OE56.1
Element: Item Number This field contains the item
identifier.
RLI-DESCRIPTION Alpha 30 (Lower Case)
Element: Description This field displays the description.
RLI-LINE-TYPE Alpha 1 OE56.1
Element: Line Type This field contains the type of
inventory on this line.
RLI-REASON-CODE Alpha 4 OE56.1
Element: Reason Code This field contains the reason code,
which indicates the cause for credit
memos.
RLI-QUANTITY Signed 13.4 OE56.1
Element: Quantity This field contains the desired
quantity.
RLI-SELL-UOM Alpha 4 OE56.1
Element: Unit of MeasurThis field contains the stocking UOM
for the item.
RLI-INVC-CW-QTY Signed 13.4 OE56.1
Element: Quantity Invoice Catch Weight Quantity. This
field is valid only for catch weight
items. This is used in extended price
calculation, but quantity is used for
pricing.
RLI-INVEN-CW-QTY Signed 13.4 OE56.1
Element: Quantity Inventory Catch Weight Quantity. This
field is used only for credit memo catch
weight items, if the item is returned to
inventory. This is defaulted from
Invoice Catch Weight Quantity.
RLI-STD-COST Signed 18.5 OE56.1
Element: Intl Cost
RLI-SELL-TO-STOCK Signed 13.7 OE56.1
Element: Sell To Stock
RLI-ORIG-UNIT-COST Signed 18.5 OE56.1
Element: Intl Cost
RLI-ENT-UNIT-COST Signed 18.5 OE56.1
Element: Intl Cost
RLI-UNIT-COST Signed 18.5 OE56.1
Element: Intl Cost This field contains the unit cost.
RLI-CUST-REQ-ACT Alpha 1 OE56.1
Element: Cust Req Act
RLI-RESTK-CHG-CODE Alpha 16 OE56.1
Element: Restk Chg Code
RLI-INV-DISP-CD Alpha 1 OE56.1
Element: Inv Disp Cd
RLI-CREATE-CM-CD Alpha 1 OE56.1
Element: All Flag
RLI-DETAIL-QTY Signed 13.4 OE56.1
Element: Quantity This field shows the total quantity of
details defined for a detail tracked
item. It is matched against the line
quantity field to determine if details
are in balance.
In the item detail screen, it is the
quantity for a particular lot or bin.
RLI-DTL-CW-QTY Signed 13.4 OE56.1
Element: Dtl Cw Qty
RLI-PO-NUMBER Alpha 14 (Right Justified) OE56.1
Element: PO Number This field contains the number
representing the purchase order.
RLI-LAST-COMM-SEQ Numeric 3
Element: Sequence NumbeThis is the sequence number of the last
comment line entered for this
requisition line.
RLI-STATUS Numeric 1 OE56.1
Element: Status This field displays the status of the
transaction.
RLI-AVERAGE-COST Signed 18.5 OE56.1
Element: Intl Cost
RLI-SOH-QTY Signed 13.4 OE56.1
Element: Quantity This field contains the quantity that
is currently on hand in inventory.
RLI-ACTIVITY-C Alpha 15 OE56.1
Element: Activity 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 the Lawson Activity
Management system. 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.
RLI-ACCT-CATEG-C Alpha 5 OE56.1
Element: Account CategoAccount categories are groupings of
costs, revenues, or a combination of
both used for reporting and inquiries
for activities in the Lawson 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.
RLI-ATN-OBJ-ID-C Numeric 12
Object The system defined object id
Identification representing the Activity Management
committment.
RLI-STOCK-UOM Alpha 4 OE56.1
Element: Unit of MeasurThis is the stock unit of measure for
the item.
OERETLNIN FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
RLISET1 COMPANY OE530 OE56.1
AUTH-NO
LINE-NBR
RLISET2 COMPANY
RET-REF-NBR
AUTH-NO
LINE-NBR
RLISET3 COMPANY
LOCATION
RTN-DATE
AUTH-NO
LINE-NBR
|
