RALINEOUT FILE REFERENCED BY OE530 UPDATED BY OE130 OE30.1 OE30.2 OE30.3 OE30.4 OE30.5 OE30.6 OE30.7 OE30.9 OE830 OE950 FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY RLO-COMPANY Numeric 4 OE30.1 OE30.2 Company The company number represents an OE30.3 OE30.4 established company and is entered on OE30.5 OE30.6 all function codes. OE30.7 OE30.9 OE830 OE950 RLO-AUTH-NO Numeric 10 OE30.1 OE30.2 Auth No OE30.3 OE30.4 OE30.5 OE30.6 OE30.7 OE30.9 OE830 OE950 RLO-LINE-NBR Numeric 6 OE30.1 OE30.2 Line Number This field contains the line number. OE30.3 OE30.4 OE30.5 OE30.6 OE30.7 OE30.9 OE830 OE950 RLO-CREATION-DATE Numeric 8 (yyyymmdd) OE30.1 OE30.2 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 OE830 OE950 RLO-CREATION-TIME Numeric 6 (hhmmss) OE30.1 OE30.2 Creation Time The creation time. OE30.3 OE30.4 OE30.5 OE30.6 OE30.7 OE30.9 OE830 OE950 RLO-LOCATION Alpha 5 OE30.1 OE30.2 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 OE950 RLO-INTERFACE-STS Numeric 1 OE30.1 OE30.2 Interface Sts OE30.3 OE30.4 OE30.5 OE30.6 OE30.7 OE30.9 OE830 OE950 RLO-STATUS Numeric 1 OE30.1 OE30.2 Status This field contains the status of the OE30.3 OE30.4 transaction. OE30.5 OE30.6 OE30.7 OE30.9 OE530 OE830 OE950 RLO-CUSTOMER Alpha 9 (Right Justified) OE30.1 OE30.2 Customer Number This field contains the number that OE30.3 OE30.4 represents a customer. OE30.5 OE30.6 OE30.7 OE30.9 OE530 OE830 OE950 RLO-SHIP-TO Numeric 4 OE30.1 OE30.2 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 OE950 RLO-ORDER-NBR Numeric 8 OE30.1 OE30.2 Order Number This field contains the order number. OE30.3 OE30.4 OE30.5 OE30.6 OE30.7 OE30.9 OE530 OE830 OE950 RLO-ORIG-LINE-NBR Numeric 6 OE30.1 OE30.2 Original Line Number OE30.3 OE30.4 OE30.5 OE30.6 OE30.7 OE30.9 OE530 OE830 OE950 RLO-ITEM Alpha 32 OE30.1 OE30.2 Item Number This field contains the item OE30.3 OE30.4 identifier. OE30.5 OE30.6 OE30.7 OE30.9 OE530 OE830 OE950 RLO-DESCRIPTION Alpha 30 (Lower Case) OE30.1 OE30.2 Description This field contains the description. OE30.3 OE30.4 OE30.5 OE30.6 OE30.7 OE30.9 OE530 OE830 OE950 RLO-LINE-TYPE Alpha 1 OE30.1 OE30.2 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 OE950 RLO-REASON-CODE Alpha 4 OE30.1 OE30.2 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 OE950 RLO-QUANTITY Signed 13.4 OE30.1 OE30.2 Quantity This field contains the requested OE30.3 OE30.4 quantity. OE30.5 OE30.6 OE30.7 OE30.9 OE530 OE830 OE950 RLO-SELL-UOM Alpha 4 OE30.1 OE30.2 Sell Unit of Measure This field contains the stocking UOM OE30.3 OE30.4 for the item. OE30.5 OE30.6 OE30.7 OE30.9 OE530 OE830 OE950 RLO-STOCK-UOM Alpha 4 OE30.1 OE30.2 Stocking Unit of This is the stock unit of measure for OE30.3 OE30.4 Measure the item. OE30.5 OE30.6 OE30.7 OE30.9 OE830 OE950 RLO-SELL-TO-STOCK Signed 13.7 OE30.1 OE30.2 Sell to Stock OE30.3 OE30.4 OE30.5 OE30.6 OE30.7 OE30.9 OE530 OE830 OE950 RLO-INVC-CW-QTY Signed 13.4 OE30.1 OE30.2 Invc Cw Qty 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. OE950 RLO-INVEN-CW-QTY Signed 13.4 OE30.1 OE30.2 Inven Cw Qty Inventory Catch Weight Quantity. This OE30.3 OE30.4 field is used only for credit memo OE30.5 OE30.6 catch weight items, if the item is OE30.7 OE30.9 returned to inventory. This is defaulted OE530 OE830 from Invoice Catch Weight Quantity. OE950 RLO-ENTERED-PRICE Signed 13.5 OE30.1 OE30.2 Entered Price OE30.3 OE30.4 OE30.5 OE30.6 OE30.7 OE30.9 OE830 OE950 RLO-UNIT-PRICE Signed 13.5 OE30.1 OE30.2 Unit Price This field contains the unit price. OE30.3 OE30.4 OE30.5 OE30.6 OE30.7 OE30.9 OE830 OE950 RLO-BASE-PRICE Signed 13.5 OE30.1 OE30.2 Base Price OE30.3 OE30.4 OE30.5 OE30.6 OE30.7 OE30.9 OE830 OE950 RLO-SPR-UOM Alpha 4 OE30.1 OE30.2 Selling Price Unit OE30.3 OE30.4 of Measure OE30.5 OE30.6 OE30.7 OE30.9 OE830 OE950 RLO-SPR-TO-STOCK Signed 13.7 OE30.1 OE30.2 Spr to Stock OE30.3 OE30.4 OE30.5 OE30.6 OE30.7 OE30.9 OE830 OE950 RLO-STD-COST Signed 13.5 OE30.1 OE30.2 Standard Cost OE30.3 OE30.4 OE30.5 OE30.6 OE30.7 OE30.9 OE530 OE830 OE950 RLO-ORIG-UNIT-COST Signed 13.5 OE30.1 OE30.2 Orig Unit Cost OE30.3 OE30.4 OE30.5 OE30.6 OE30.7 OE30.9 OE530 OE830 OE950 RLO-ENT-UNIT-COST Signed 13.5 OE30.1 OE30.2 Ent Unit Cost OE30.3 OE30.4 OE30.5 OE30.6 OE30.7 OE30.9 OE530 OE830 OE950 RLO-UNIT-COST Signed 13.5 OE30.1 OE30.2 Unit Cost This field contains the unit cost. OE30.3 OE30.4 OE30.5 OE30.6 OE30.7 OE30.9 OE530 OE830 OE950 RLO-AVERAGE-COST Signed 13.5 OE30.1 OE30.2 Average Cost OE30.3 OE30.4 OE30.5 OE30.6 OE30.7 OE30.9 OE530 OE830 OE950 RLO-SOH-QTY Signed 13.4 OE30.1 OE30.2 Stock On Hand This field contains the quantity that OE30.3 OE30.4 Quantity is currently on hand in inventory. OE30.5 OE30.6 OE30.7 OE30.9 OE530 OE830 OE950 RLO-ACTIVITY Alpha 15 OE30.1 OE30.2 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 OE830 OE950 performing the activity. Activities and cost object activities are used synonymously in the 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 kinds 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-CATEGORY Alpha 5 OE30.1 OE30.2 Account Category Account 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 OE830 OE950 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-ACTIVITY-C Alpha 15 OE30.1 OE30.2 Activity for Cst of Activities are the processes or OE30.3 OE30.4 Goods Sold 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 OE950 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 Acct Categ (Cst of Account categories are groupings of OE30.3 OE30.4 Goods Sold) 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 OE950 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 AC System Object ID The system defined object id OE30.3 OE30.4 (Cost) representing the Activity Management OE30.5 OE30.6 committment. OE30.7 OE30.9 OE530 OE830 OE950 RLO-CUST-REQ-ACT Alpha 1 OE30.1 OE30.2 Cust Req Act OE30.3 OE30.4 OE30.5 OE30.6 OE30.7 OE30.9 OE830 OE950 RLO-RESTK-CHG-CODE Alpha 16 OE30.1 OE30.2 Restk Chg Code OE30.3 OE30.4 OE30.5 OE30.6 OE30.7 OE30.9 OE530 OE830 OE950 RLO-INV-DISP-CD Alpha 1 OE30.1 OE30.2 Inv Disp Cd OE30.3 OE30.4 OE30.5 OE30.6 OE30.7 OE30.9 OE530 OE830 OE950 RLO-CREATE-CM-CD Alpha 1 OE30.1 OE30.2 Create Cm Cd OE30.3 OE30.4 OE30.5 OE30.6 OE30.7 OE30.9 OE530 OE830 OE950 RLO-DETAIL-QTY Signed 13.4 OE30.1 OE30.2 Detail Qty 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. OE950 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 Dtl Cw Qty OE30.3 OE30.4 OE30.5 OE30.6 OE30.7 OE30.9 OE530 OE830 OE950 RLO-SLS-ACCT-UNIT Alpha 15 OE30.1 OE30.2 Sales Accounting OE30.3 OE30.4 Unit OE30.5 OE30.6 OE30.7 OE30.9 OE830 OE950 RLO-SLS-ACCOUNT Numeric 6 OE30.1 OE30.2 Sales Account OE30.3 OE30.4 OE30.5 OE30.6 OE30.7 OE30.9 OE830 OE950 RLO-SLS-SUB-ACCT Numeric 4 OE30.1 OE30.2 Sales Subaccount OE30.3 OE30.4 OE30.5 OE30.6 OE30.7 OE30.9 OE830 OE950 RLO-OFF-ACCT-UNIT Alpha 15 OE30.1 OE30.2 Offset Accounting OE30.3 OE30.4 Unit OE30.5 OE30.6 OE30.7 OE30.9 OE830 OE950 RLO-OFF-ACCOUNT Numeric 6 OE30.1 OE30.2 Offset Account OE30.3 OE30.4 OE30.5 OE30.6 OE30.7 OE30.9 OE830 OE950 RLO-OFF-SUB-ACCT Numeric 4 OE30.1 OE30.2 Offset Subaccount OE30.3 OE30.4 OE30.5 OE30.6 OE30.7 OE30.9 OE830 OE950 RLO-CGS-ACCT-UNIT Alpha 15 OE30.1 OE30.2 Cost Of Goods Sold OE30.3 OE30.4 Acct Unit OE30.5 OE30.6 OE30.7 OE30.9 OE830 OE950 RLO-CGS-ACCOUNT Numeric 6 OE30.1 OE30.2 Cost Of Goods Sold OE30.3 OE30.4 Account OE30.5 OE30.6 OE30.7 OE30.9 OE830 OE950 RLO-CGS-SUB-ACCT Numeric 4 OE30.1 OE30.2 Cost Of Goods Sold OE30.3 OE30.4 Subaccount OE30.5 OE30.6 OE30.7 OE30.9 OE830 OE950 RLO-CV-ACCT-UNIT Alpha 15 OE30.1 OE30.2 Cv Acct Unit OE30.3 OE30.4 OE30.5 OE30.6 OE30.7 OE30.9 OE830 OE950 RLO-CV-ACCOUNT Numeric 6 OE30.1 OE30.2 Cv Account OE30.3 OE30.4 OE30.5 OE30.6 OE30.7 OE30.9 OE830 OE950 RLO-CV-SUB-ACCT Numeric 4 OE30.1 OE30.2 Cv Sub Acct OE30.3 OE30.4 OE30.5 OE30.6 OE30.7 OE30.9 OE830 OE950 RLO-PO-NUMBER Alpha 7 (Right Justified) OE30.1 OE30.2 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 OE950 RLO-LAST-COMM-SEQ Numeric 3 OE30.1 OE30.2 Last Comment This is the sequence number of the last OE30.3 OE30.4 Sequence Number comment line entered for this OE30.5 OE30.6 requisition line. OE30.7 OE30.9 OE530 OE830 OE950 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 OE950 RLOSET2 COMPANY LOCATION INTERFACE-STS AUTH-NO LINE-NBR CREATION-DATE CREATION-TIME |