FROPTIONS

FR Company Options

This file contains certain company options that are required for interfacing with the Lawson Billing system.

REFERENCED BY
AC56.1 AC560 AR01.1 ARLL.1 BR11.1 BR48.1
WH20.2 WH20.7

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
FRO-COMPANY
Element: Company
Numeric 4
This field contains the company number defined in the General Ledger, Account Receivable, and Billing systems.
FRO-CASH-CODE
Element: Cash Code
Alpha 4
This field contaiins the cash code defined in the Accounts Receivable system, which determines the cash account used when entering a note prepayment.
FRO-PROCESS-LEVEL
Element: Process Level
Alpha 5
This field contains the process level, which is the reporting hierarchy below company.
FRO-INVC-TYPE
Element: Invc Type
Alpha 4
This field contains the default invoice type used when interfacing the actual charges into the Billng system.
FRO-LOCATION
Element: Location
Alpha 5
This field contains a valid stocking location within the company inventory.
FRO-UOM
Element: Uom
Alpha 4
This field contains the valid stock unit of measure for this item.
FRO-CURRENT-YEAR
Element: Current Year
Numeric 4
This field contains the value for the current fiscal year. For example, the current year might be 1999.
FRO-PREVIOUS-YEAR
Element: Previous Year
Numeric 4
This field contains the value for the previous fiscal year. For example, if the current year is 1999, the previous year would be 1998.
FRO-NEXT-YEAR
Element: Next Year
Numeric 4
This field contains the next fiscal year. For example, if the current year is 1999, the next year would be 2000.
FRO-LST-INVC-NBR
Element: Invc Number
Numeric 8
This field contains the last invoice number for invoices generated from the Franchise Management System. This counter is used if Franchise Management processing occurs at the company level.
FRO-INVC-PREFIX
Element: Invc Prefix
Alpha 2
This field contains the invoice prefix that is assigned from either the company or process level, depending on the invoice-level option chosen.
FRO-CR-INVC-TYPE
Element: Cr Invc Type
Alpha 4
FRO-CR-INVC-PREFIX
Element: Cr Invc Prefix
Alpha 2
FRO-LST-CR-NBR
Element: Lst Cr Nbr
Numeric 8
FRO-REASON-CODE
Element: Reason Code
Alpha 4
This field contains the reason code, which indicates the cause for credit memos.
FRO-SALES-FL
Element: Sales Fl
Alpha 1

Y = Yes
N = No
FRO-CALENDAR-ID
Element: Calendar Id
Alpha 10
FRO-SALES-BY-DATE
Element: Sales By Date
Alpha 1

Y = Yes
N = No


FROPTIONS FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
FROSET1 COMPANY
AC56.1 AC560
AR01.1 ARLL.1
BR11.1 BR48.1
WH20.2 WH20.7


FROPTIONS FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Arcomp ARCOMP Required
FRO-COMPANY->-COMPANY
Iccompany ICCOMPANY Required
FRO-COMPANY->ICC-COMPANY
Iclocation ICLOCATION Required
FRO-COMPANY->ICL-COMPANY
FRO-LOCATION->ICL-LOCATION
Icvaluom ICVALUOM Required
ICC-ITEM-GROUP->ICV-ITEM-GROUP
FRO-UOM->ICV-VALID-UOM
Oecompany OECOMPANY Required
FRO-COMPANY->OEC-COMPANY
Oeinvctype OEINVCTYPE Required
FRO-COMPANY->OIN-COMPANY
FRO-INVC-TYPE->OIN-INVC-TYPE
Oeproclev OEPROCLEV Required
FRO-COMPANY->OEP-COMPANY
FRO-PROCESS-LEVEL->OEP-PROCESS-LEVEL


File created: Thu Jun 09 11:12:51 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.