Lawson Insight Technical Documentation |
|
RALINEOUT
RALINEOUT FILE
UPDATED BY
OE130 OE30.1 OE30.2 OE30.3 OE30.4 OE30.5
OE30.6 OE30.7 OE30.9 OE530 OE830
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
RLO-COMPANY Numeric 4 OE30.1 OE30.2
Element: Company Identifies the AP company if the OE30.3 OE30.4
resource type = V. Identifies the HR OE30.5 OE30.6
company if the resource type = E. It is OE30.7 OE30.9
blank for type A, P or Q resources. OE530 OE830
RLO-AUTH-NO Numeric 10 OE30.1 OE30.2
Element: Auth No OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
RLO-LINE-NBR Numeric 6 OE30.1 OE30.2
Element: Line Number This field contains the line number. OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
RLO-CREATION-DATE Numeric 8 (yyyymmdd) OE30.1 OE30.2
Element: Creation Date This is the date that this line was OE30.3 OE30.4
added to the requisition. OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
RLO-CREATION-TIME Numeric 6 (hhmmss) OE30.1 OE30.2
Element: Creation Time The creation time. OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
RLO-LOCATION Alpha 5 OE30.1 OE30.2
Element: Location Code This field contains a valid stocking OE30.3 OE30.4
location within the company inventory. OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
RLO-INTERFACE-STS Numeric 1 OE30.1 OE30.2
Element: Interface Sts OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
RLO-STATUS Numeric 1 OE30.1 OE30.2
Element: Status This field displays the status of the OE30.3 OE30.4
transaction. OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
RLO-CUSTOMER Alpha 9 (Right Justified) OE30.1 OE30.2
Element: Customer NumbeThis field contains the number that OE30.3 OE30.4
represents a customer. OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
RLO-SHIP-TO Numeric 4 OE30.1 OE30.2
Element: Ship-to Code This field contains the number OE30.3 OE30.4
representing the ship to customer. OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
RLO-ORDER-NBR Numeric 8 OE30.1 OE30.2
Element: Order Number This field contains the order number. OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
RLO-ORIG-LINE-NBR Numeric 6 OE30.1 OE30.2
Element: Original Line Number OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
RLO-ITEM Alpha 32 OE30.1 OE30.2
Element: Item Number This field contains the item OE30.3 OE30.4
identifier. OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
RLO-DESCRIPTION Alpha 30 (Lower Case) OE30.1 OE30.2
Element: Description This field displays the description. OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
RLO-LINE-TYPE Alpha 1 OE30.1 OE30.2
Element: Line Type This field contains the type of OE30.3 OE30.4
inventory on this line. OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
RLO-REASON-CODE Alpha 4 OE30.1 OE30.2
Element: Reason Code This field contains the reason code, OE30.3 OE30.4
which indicates the cause for credit OE30.5 OE30.6
memos. OE30.7 OE30.9
OE530 OE830
RLO-QUANTITY Signed 13.4 OE30.1 OE30.2
Element: Quantity This field contains the desired OE30.3 OE30.4
quantity. OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
RLO-SELL-UOM Alpha 4 OE30.1 OE30.2
Element: Unit of MeasurThis field contains the stocking UOM OE30.3 OE30.4
for the item. OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
RLO-STOCK-UOM Alpha 4 OE30.1 OE30.2
Element: Unit of MeasurThis is the stock unit of measure for OE30.3 OE30.4
the item. OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
RLO-SELL-TO-STOCK Signed 13.7 OE30.1 OE30.2
Element: Sell To Stock OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
RLO-INVC-CW-QTY Signed 13.4 OE30.1 OE30.2
Element: Quantity Invoice Catch Weight Quantity. This OE30.3 OE30.4
field is valid only for catch weight OE30.5 OE30.6
items. This is used in extended price OE30.7 OE30.9
calculation, but quantity is used for OE530 OE830
pricing.
RLO-INVEN-CW-QTY Signed 13.4 OE30.1 OE30.2
Element: Quantity Inventory Catch Weight Quantity. This OE30.3 OE30.4
field is used only for credit memo catch OE30.5 OE30.6
weight items, if the item is returned to OE30.7 OE30.9
inventory. This is defaulted from OE530 OE830
Invoice Catch Weight Quantity.
RLO-ENTERED-PRICE Signed 18.5 OE30.1 OE30.2
Element: Intl Cost OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
RLO-UNIT-PRICE Signed 18.5 OE30.1 OE30.2
Element: Intl Cost This field contains the unit price. OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
RLO-BASE-PRICE Signed 18.5 OE30.1 OE30.2
Element: Intl Cost OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
RLO-SPR-UOM Alpha 4 OE30.1 OE30.2
Element: Unit of Measure OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
RLO-SPR-TO-STOCK Signed 13.7 OE30.1 OE30.2
Element: Sell To Stock OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
RLO-STD-COST Signed 18.5 OE30.1 OE30.2
Element: Intl Cost OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
RLO-ORIG-UNIT-COST Signed 18.5 OE30.1 OE30.2
Element: Intl Cost OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
RLO-ENT-UNIT-COST Signed 18.5 OE30.1 OE30.2
Element: Intl Cost OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
RLO-UNIT-COST Signed 18.5 OE30.1 OE30.2
Element: Intl Cost This field contains the unit cost. OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
RLO-AVERAGE-COST Signed 18.5 OE30.1 OE30.2
Element: Intl Cost OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
RLO-SOH-QTY Signed 13.4 OE30.1 OE30.2
Element: Quantity This field contains the quantity that OE30.3 OE30.4
is currently on hand in inventory. OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
RLO-ACTIVITY Alpha 15 OE30.1 OE30.2
Element: Activity Activities are the processes or OE30.3 OE30.4
procedures that produce work. Cost OE30.5 OE30.6
objects (products, services, customers, OE30.7 OE30.9
and so on) are the reasons for OE530 OE830
performing the activity.
RLO-ACCT-CATEGORY Alpha 5 OE30.1 OE30.2
Element: Account CategoAccount categories are groupings of OE30.3 OE30.4
costs, revenues, or a combination of OE30.5 OE30.6
both used for reporting and inquiries OE30.7 OE30.9
for activities in the Activity OE530 OE830
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.
Valid account category types are:
cost
revenue
accrual
pass thru
RLO-ACTIVITY-C Alpha 15 OE30.1 OE30.2
Element: Activity Activities are the processes or OE30.3 OE30.4
procedures that produce work. Cost OE30.5 OE30.6
objects (products, services, customers, OE30.7 OE30.9
and so on) are the reasons for OE530 OE830
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.
RLO-ACCT-CATEG-C Alpha 5 OE30.1 OE30.2
Element: Account CategoAccount categories are groupings of OE30.3 OE30.4
costs, revenues, or a combination of OE30.5 OE30.6
both used for reporting and inquiries OE30.7 OE30.9
for activities in the Lawson Activity OE530 OE830
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.
RLO-ATN-OBJ-ID-C Numeric 12 OE30.1 OE30.2
Object The system defined object id OE30.3 OE30.4
Identification representing the Activity Management OE30.5 OE30.6
committment. OE30.7 OE30.9
OE530 OE830
RLO-CUST-REQ-ACT Alpha 1 OE30.1 OE30.2
Element: Cust Req Act OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
RLO-RESTK-CHG-CODE Alpha 16 OE30.1 OE30.2
Element: Restk Chg Code OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
RLO-INV-DISP-CD Alpha 1 OE30.1 OE30.2
Element: Inv Disp Cd OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
RLO-CREATE-CM-CD Alpha 1 OE30.1 OE30.2
Element: All Flag OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
RLO-DETAIL-QTY Signed 13.4 OE30.1 OE30.2
Element: Quantity This field shows the total quantity of OE30.3 OE30.4
details defined for a detail tracked OE30.5 OE30.6
item. It is matched against the line OE30.7 OE30.9
quantity field to determine if details OE530 OE830
are in balance.
In the item detail screen, it is the
quantity for a particular lot or bin.
RLO-DTL-CW-QTY Signed 13.4 OE30.1 OE30.2
Element: Dtl Cw Qty OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
RLO-SLS-ACCT-UNIT Alpha 15 OE30.1 OE30.2
Element: Accounting Unit OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
RLO-SLS-ACCOUNT Numeric 6 OE30.1 OE30.2
Element: Account OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
RLO-SLS-SUB-ACCT Numeric 4 OE30.1 OE30.2
Element: Subaccount OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
RLO-OFF-ACCT-UNIT Alpha 15 OE30.1 OE30.2
Element: Accounting Unit OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
RLO-OFF-ACCOUNT Numeric 6 OE30.1 OE30.2
Element: Account OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
RLO-OFF-SUB-ACCT Numeric 4 OE30.1 OE30.2
Element: Subaccount OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
RLO-CGS-ACCT-UNIT Alpha 15 OE30.1 OE30.2
Element: Accounting Unit OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
RLO-CGS-ACCOUNT Numeric 6 OE30.1 OE30.2
Element: Account OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
RLO-CGS-SUB-ACCT Numeric 4 OE30.1 OE30.2
Element: Subaccount OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
RLO-CV-ACCT-UNIT Alpha 15 OE30.1 OE30.2
Element: Accounting Unit OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
RLO-CV-ACCOUNT Numeric 6 OE30.1 OE30.2
Element: Account OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
RLO-CV-SUB-ACCT Numeric 4 OE30.1 OE30.2
Element: Subaccount OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
RLO-PO-NUMBER Alpha 14 (Right Justified) OE30.1 OE30.2
Element: PO Number This field contains the number OE30.3 OE30.4
representing the purchase order. OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
RLO-LAST-COMM-SEQ Numeric 3 OE30.1 OE30.2
Element: Sequence NumbeThis is the sequence number of the last OE30.3 OE30.4
comment line entered for this OE30.5 OE30.6
requisition line. OE30.7 OE30.9
OE530 OE830
RALINEOUT FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
RLOSET1 COMPANY OE130 OE30.1
AUTH-NO OE30.2 OE30.3
LINE-NBR OE30.4 OE30.5
CREATION-DATE OE30.6 OE30.7
CREATION-TIME OE30.9 OE530
OE830
RLOSET2 COMPANY KeyChange
LOCATION
INTERFACE-STS
AUTH-NO
LINE-NBR
CREATION-DATE
CREATION-TIME
|