|
|
FRCHARGE FILE
FR Charges
This file contains the charges, defined in FR05.1 (Stardard Sales Based
Charge), FR06.1 (Standard Note Based Charge), or FR07.1 (Stardard Special
Charge) and assigned to the contract. Use those forms to delete charges from
this file.
Through the use of the Charge Type field, this record handles sales-based,
note-based, and special charges.
UPDATED BY
AR150
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
FRG-COMPANY Numeric 4
Element: Company This field contains the company number
defined in the General Ledger, Accounts
Receivable, and Billing systems.
FRG-CUSTOMER Alpha 9 (Right Justified)
Element: Customer This field contains the customer number
defined in the Accounts Receivable
system.
FRG-SHIP-TO Numeric 4
Element: Ship To This field contains the customer ship-to
number defined in the Billing system.
FRG-CONTR-NBR Numeric 6
Element: Contract NumbeThis field contains the number
representing the business agreement and
terms between the franchiser and
franchisee.
FRG-CHARGE Alpha 8
Element: Charge This field contains a valid charge in
the Franchise Management system.
FRG-SEQ Numeric 3
Element: Sequence This field contains the record sequence
number. For a given contract, each
charge must have a unique sequence
number. This field contains the sort
order in FR20.1 (Sales Remittance).
FRG-DESC Alpha 30 (Lower Case)
Element: Description This field contains the charge
description.
FRG-CHARGE-TYPE Numeric 1
Element: Charge Type This field value indicates whether the
charge is a sales-based, note-based, or
special charge.
1 = Sales-Based
2 = Note-Based
3 = Special
FRG-BEGIN-DATE Numeric 8 (yyyymmdd)
Element: Begin Date This field contains the beginning date
of the charge. Charges are processed
only after the cycle date is greater
than the beginning date.
FRG-END-DATE Numeric 8 (yyyymmdd)
Element: End Date This field contains the ending date of
the charge. Charges are not processed
if the cycle date is greater than the
ending date, and the ending date is not
zeros.
FRG-NEXT-CYC-DATE Numeric 8 (yyyymmdd)
Element: Next Cycle DatThis field contains the next date that
a charge will be processed. The
frequency of the charge determines this
date.
FRG-ACTIVE-FLAG Alpha 1
Element: Status This field indicates whether the charge
is active or inactive.
A = Active
I = Inactive
FRG-FREQUENCY Alpha 1
Element: Frequency This field indicates the charge
frequency. When an estimate is created,
the next charge date is incremented
based on this value.
W = Weekly
M = Monthly
Q = Quarterly
Y = Yearly
FRG-CURRENCY-CODE Alpha 5
Element: Currency This field contains the company base
currency code established in Company
(GL10.1 ).
FRG-INTEREST-RATE Signed 7.5
Element: Interest Rate This field contains the annual interest
rate assiciated with a note-based
charge.
FRG-NOTE-AMOUNT Signed 18.2
Element: Note Amount This field contains the original amount
of a note-based charge.
FRG-CURRENT-BAL Signed 18.2
Element: Current BalancThis field contains the current balance
of a note-based charge.
FRG-CHARGE-TO-DATE Signed 18.2
Element: Charges To DatThis field contains the cumulative
charges to date accrued against a
note-based charge. This reflects both
principal and interest.
FRG-PAYMNT-AMT Signed 18.2
Element: Payment Amount
FRG-NBR-OF-PMTS Numeric 4
Element: Number of PaymThis field contains the original number
of payments contracted for a note-based
charge.
FRG-REMAINING-PMTS Numeric 4
Element: Remaining PaymThis field contains the remaining number
of payments for a note-based charge.
This value is decremented as a cycle is
processed.
FRG-CALC-TYPE Alpha 1
Element: Calculation TyThis field contains the calculation
type.
FRG-TAXABLE-FLAG Alpha 1
Element: Taxable Flag Defines if Taxable.
E = Exempt
T = Taxable
FRG-TAX-CODE Alpha 10
Element: Tax Code This field contains a code representing
specific tax information. This must be
a valid Tax Code.
FRG-MIN-AMOUNT Signed 18.2
Element: Minimum AmountThis field contains the minimum amount
of a sales-based charge.
FRG-MAX-AMOUNT Signed 18.2
Element: Maximum AmountThis field contains the upper limit of a
sales-based charge.
FRG-PERC-OF-SALES Percent 5.3 (Percent)
Element: Perc Of Sales This field contains the base percentage
of sales for a sales-based charge. It
can be overridden with the sliding-scale
percentage.
FRG-BASE-AMOUNT Signed 18.2
Element: Base Amount This field contains the base amount to
be posted to the General Ledger Account
Master file.
FRG-STEP-OPERAND Numeric 1
Element: Scale Optioin This field indicates whether the charge
is computed using the percentage defined
for the upper limit or using the
appropriate step of the sliding scale.
0 = Use Highest Step Pct
1 = Add Step Values
FRG-STEP-LIMIT Signed 18.2 Occurs 10 Times
Element: Step Limit This field contains the upper limit of
revenue for a sliding scale.
FRG-STEP-PCT Percent 5.2 (Percent) Occurs 10 Times
Element: Step PercentagThis field contains the percentage of
sales associated with the step of the
sliding scale.
FRG-BALANCE-FL Alpha 1 AR150
Element: Balance Flag This field determines whether or not to
print the note balance on the franchisee
statement when FR150 (Statement Report)
is run.
N = No
Y = Yes
FRG-ACTIVITY Alpha 15
Element: Activity This field contains the activity
identifier defined in the Activity
Management system.
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 tranaactions. Summary activities
or macro activities combine information
and balances from lower level activities
for reporting and inquiries.
FRG-ACCT-CATEGORY Alpha 5
Element: Account CategoThis field contains a valid account
category defined in the Activity
Management system.
FRG-ACC-ACCT-UNIT Alpha 15
Element: Accrual - AcctThis field contains the accrual
accounting unit.
FRG-ACC-ACCOUNT Numeric 6
Element: Accrual - AccoThis field contains the accrual account.
FRG-ACC-SUB-ACCT Numeric 4
Element: Accrual - SubaThis field contains the accrual
subaccount.
FRG-ACO-ACCT-UNIT Alpha 15
Accrual Offset - This field contains the accrual offset
Acct Unit accounting unit.
FRG-ACO-ACCOUNT Numeric 6
Accrual Offset - This field contains the accrual offset
Account account.
FRG-ACO-SUB-ACCT Numeric 4
Accrual Offset - This field contains the accrual offset
Subaccount subaccount.
FRG-NAC-ACCT-UNIT Alpha 15
Note Accrual - Acct This field contains the note accrual
Unit accounting unit.
FRG-NAC-ACCOUNT Numeric 6
Note Accrual - This field contains the note accrual
Account account.
FRG-NAC-SUB-ACCT Numeric 4
Note Accrual - This field contains the note accrual
Subaccount subaccount.
FRG-NAO-ACCT-UNIT Alpha 15
Note Accr Offset - This field contains the note accrual
Acct Unit offset accounting unit.
FRG-NAO-ACCOUNT Numeric 6
Note Accr Offset - This field contains the note accrual
Account offset account.
FRG-NAO-SUB-ACCT Numeric 4
Note Accr Offset - This field contains the note accrual
Subaccount offset subaccount.
FRG-REV-ACCT-UNIT Alpha 15
Element: Sales - Acct UThis field contains the revenue
accounting unit.
FRG-REV-ACCOUNT Numeric 6
Element: Sales - AccounThis field contains the revenue account.
FRG-REV-SUB-ACCT Numeric 4
Element: Sales - SubaccThis field contains the revenue
subaccount.
FRG-NOTE-ACCT-UNIT Alpha 15
Note Asset - Acct This field contains the note asset
Unit accounting unit.
FRG-NOTE-ACCOUNT Numeric 6
Element: Note Asset - AThis field contains the note asset
account.
FRG-NOTE-SUB-ACCT Numeric 4
Note Asset - This field contains the note asset
Subaccount subaccount.
FRG-PROCESS-LEVEL Alpha 5
Element: Process Level This field contains the process level,
which is the reporting hierarchy below
company.
FRCHARGE FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
FRGSET1 COMPANY
CUSTOMER
SHIP-TO
CONTR-NBR
SEQ
FRGSET2 COMPANY KeyChange, Subset AR150
CUSTOMER Where CHARGE-TYPE = 2
SHIP-TO And BALANCE-FL = "Y"
CONTR-NBR
SEQ
FRCHARGE FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Arcomp ARCOMP Required
FRG-COMPANY -> ACO-COMPANY
Arcustomer ARCUSTOMER Required
FRG-COMPANY -> ACM-COMPANY
FRG-CUSTOMER -> ACM-CUSTOMER
Custdesc CUSTDESC Required
ACO-CUST-GROUP -> CUD-CUST-GROUP
FRG-CUSTOMER -> CUD-CUSTOMER
Froptions FROPTIONS Required
FRG-COMPANY -> FRO-COMPANY
Oecompany OECOMPANY Required
FRG-COMPANY -> OEC-COMPANY
Shipto SHIPTO Required
FRG-COMPANY -> SHP-COMPANY
FRG-CUSTOMER -> SHP-CUSTOMER
FRG-SHIP-TO -> SHP-SHIP-TO
FRCHARGE FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Frcontmast FRCONTMAST
FRG-COMPANY -> FRM-COMPANY
FRG-CUSTOMER -> FRM-CUSTOMER
FRG-SHIP-TO -> FRM-SHIP-TO
FRM-CONTR-NBR
|
