|
|
FROPTIONS FILE
FR Company Options
This file contains certain company options that are required for interfacing
with the Lawson Billing system.
REFERENCED BY
AR150 AR42.2 AR42.7 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
BR11.1 OE10.1 OE10.2 OE10.3 OE10.4 OE10.5
OE10.6 OE10.7 OE10.8 OE11.1 OE11.4 OE11.8
OE11.9 OE110 OE111 OE113 OE114 OE116
OE129 OE13.2 OE13.3 OE13.5 OE13.6 OE14.4
OE30.1 OE30.2 OE30.3 OE30.4 OE30.5 OE30.6
OE30.7 OE30.9 OE510 OE530 OE810 OE830
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: Invoice Type This field contains the default invoice
type used when interfacing the actual
charges into the Billng system.
FRO-LOCATION Alpha 5
Element: Location Code This field contains a valid stocking
location within the company inventory.
FRO-UOM Alpha 4
Element: Unit of MeasurThis 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: Invoice PrefixThis 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 AR150 AR42.2
AR42.7 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
BR11.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
...
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
|
