|
|
FRCHARGE FILE
FR Charges
This file contains the charges, defined in FR05.1 (Standard Sales Based
Charge), FR06.1 (Standard Note Based Charge), or FR07.1 (Standard 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
Company This field contains the company number
defined in the General Ledger, Accounts
Receivable, and Billing systems.
FRG-CUSTOMER Alpha 9 (Right Justified)
Customer This field contains the customer number
defined in the Accounts Receivable
system.
FRG-SHIP-TO Numeric 4
Ship To This field contains the customer
ship-to number defined in the Billing
system.
FRG-CONTR-NBR Numeric 6
Contract Number This field contains the number
representing the business agreement and
terms between the franchiser and
franchisee.
FRG-CHARGE Alpha 8
Charge This field contains a valid charge in
the Franchise Management system.
FRG-SEQ Numeric 3
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)
Description This field contains the charge
description.
FRG-CHARGE-TYPE Numeric 1
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)
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)
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)
Next Cycle Date This field contains the next date that
a charge will be processed. The
frequency of the charge determines this
date.
FRG-ACTIVE-FLAG Alpha 1
Status This field indicates whether the charge
is active or inactive.
A = Active
I = Inactive
FRG-FREQUENCY Alpha 1
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
Currency This field contains the company base
currency code defined in GL10.1
(Company).
FRG-INTEREST-RATE Percent 7.5 (Percent)
Interest Rate This field contains the annual interest
rate associated with a note-based
charge.
FRG-NOTE-AMOUNT Signed 15.2
Note Amount This field contains the original amount
of a note-based charge.
FRG-CURRENT-BAL Signed 15.2
Current Balance This field contains the current balance
of a note-based charge.
FRG-CHARGE-TO-DATE Signed 15.2
Charges To Date This field contains the cumulative
charges to date accrued against a
note-based charge. This reflects both
principal and interest.
FRG-PAYMNT-AMT Signed 15.2
Payment Amount This field contains the charge amount
in currency.
FRG-NBR-OF-PMTS Numeric 4
Number of Payments This field contains the original number
of payments contracted for a note-based
charge.
FRG-REMAINING-PMTS Numeric 4
Remaining Payments This 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
Calculation Type This field contains the calculation
type.
FRG-TAXABLE-FLAG Alpha 1
Taxable Flag Defines if Taxable.
E = Exempt
T = Taxable
FRG-TAX-CODE Alpha 10
Tax Code This field contains a code representing
specific tax information. This must be
a valid Tax Code.
FRG-MIN-AMOUNT Signed 15.2
Minimum Amount This field contains the minimum amount
of a sales-based charge.
FRG-MAX-AMOUNT Signed 15.2
Maximum Amount This field contains the upper limit of
a sales-based charge.
FRG-PERC-OF-SALES Percent 5.2 (Percent)
Percentage 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 15.2
Base Amount This field contains the base amount to
be posted to the General Ledger Account
Master file.
FRG-STEP-OPERAND Numeric 1
Scale Option 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 15.2 Occurs 10 Times
Step Limit This field contains the upper limit of
revenue for a sliding scale.
FRG-STEP-PCT Percent 5.2 (Percent) Occurs 10 Times
Step Percentage This field contains the percentage of
sales associated with the step of the
sliding scale.
FRG-BALANCE-FL Alpha 1 AR150
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
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 transactions. Summary activities
or macro activities combine information
and balances from lower level activities
for reporting and inquiries.
FRG-ACCT-CATEGORY Alpha 5
Account Category This field contains a valid account
category defined in the Activity
Management system.
FRG-ACC-ACCT-UNIT Alpha 15
Accrual - Acct Unit This field contains the accrual
accounting unit.
FRG-ACC-ACCOUNT Numeric 6
Accrual - Account This field contains the accrual account.
FRG-ACC-SUB-ACCT Numeric 4
Accrual - Subaccount This 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
Sales - Acct Unit This field contains the revenue
accounting unit.
FRG-REV-ACCOUNT Numeric 6
Sales - Account This field contains the revenue account.
FRG-REV-SUB-ACCT Numeric 4
Sales - Subaccount This 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
Note Asset - Account This field contains the note asset
account.
FRG-NOTE-SUB-ACCT Numeric 4
Note Asset - This field contains the note asset
Subaccount subaccount.
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
|