|
|
FROPTIONS FILE
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 AR150 AR33.5 AR42.2
AR42.7 AR44.3 AR502 AR560 AR90.1 ARLL.1
BL00.1 BL01.1 BL120 BL121 BL122 BL123
BL130 BL20.1 BL20.3 BL200 BL201 BL21.2
BL21.5 BL29.1 BL29.2 BL520 BL820 BL92.1
BL98.1 BR11.1 BR48.1 WH20.7
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
FRO-COMPANY Numeric 4
Element: Company This field contains the company number
defined in the General Ledger, Account
Receivable, and Billing systems.
FRO-CASH-CODE Alpha 4
Element: Cash Code 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 Alpha 5
Element: Process Level This field contains the process level,
which is the reporting hierarchy below
company.
FRO-INVC-TYPE Alpha 4
Element: Invc Type This field contains the default invoice
type used when interfacing the actual
charges into the Billng system.
FRO-LOCATION Alpha 5
Element: Location This field contains a valid stocking
location within the company inventory.
FRO-UOM Alpha 4
Element: Uom This field contains the valid stock
unit of measure for this item.
FRO-CURRENT-YEAR Numeric 4
Element: Current Year This field contains the value for the
current fiscal year. For example, the
current year might be 1999.
FRO-PREVIOUS-YEAR Numeric 4
Element: Previous Year 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 Numeric 4
Element: Next Year 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 Numeric 8
Element: Invc Number 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 Alpha 2
Element: Invc Prefix 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 Alpha 4
Element: Cr Invc Type
FRO-CR-INVC-PREFIX Alpha 2
Element: Cr Invc Prefix
FRO-LST-CR-NBR Numeric 8
Element: Lst Cr Nbr
FRO-REASON-CODE Alpha 4
Element: Reason Code This field contains the reason code,
which indicates the cause for credit
memos.
FRO-SALES-FL Alpha 1
Element: Sales Fl Y = Yes
N = No
FRO-CALENDAR-ID Alpha 10
Element: Calendar Id
FRO-SALES-BY-DATE Alpha 1
Element: Sales By Date Y = Yes
N = No
FROPTIONS FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
FROSET1 COMPANY AC56.1 AC560
AR01.1 AR150
AR33.5 AR42.2
AR42.7 AR44.3
AR502 AR560
AR90.1 ARLL.1
BL00.1 BL01.1
BL120 BL121
BL122 BL123
BL130 BL20.1
BL20.3 BL200
BL201 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
...
FROPTIONS FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME 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
|
