FRCONTMAST FILE
FR Contract Master
This is the contract master. It is specific to a customer and ship-to.
REFERENCED BY
AR150
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
FRM-COMPANY Numeric 4
Company This field contains the company number
defined in the General Ledger, Accounts
Receivable, and Billing systems.
FRM-CUSTOMER Alpha 9 (Right Justified)
Customer Number This field contains the customer number
defined in the Accounts Receivable
system.
FRM-SHIP-TO Numeric 4
Ship-to Code This field contains the customer ship-to
number defined in the Billing system.
FRM-CONTR-NBR Numeric 6
Contr Nbr This field contains the number
representing the business agreement and
terms between the franchiser and
franchisee.
FRM-ACTIVE-FLAG Alpha 1
Status This determines if the contract is
active or inactive.
A = Active
I = Inactive
FRM-CONTRACT-DATE Numeric 8 (yyyymmdd)
Contract Date This field contains the beginning date
for the contract. Charges are processed
only after the cycle date is greater
than this date.
FRM-TERMINATE-DATE Numeric 8 (yyyymmdd)
Terminate Date If entered, defines the end date of the
contract. Charges will not be processed
beyond the termination date.
FRM-GROUP-CODE Alpha 4
Group Code This field contains a free-form grouping
code, which allows users to run reports
for certain sub-groups of contracts.
FRM-TAXABLE-FLAG Alpha 1
Taxable or Defines if Taxable.
Non-Taxable Flag E = Exempt
T = Taxable
FRM-TAX-CODE Alpha 10
Tax Code This field contains a code representing
specific tax information. This must be
valid Tax Code.
FRM-LAST-ACT-DATE Numeric 8 (yyyymmdd)
Last Account Date This field contains the date of the last
release for an estimate, call-in
estimate, or actual sales record.
FRM-TTL-ESTIMATES Signed 15.2
Ttl Estimates This field contains the total of the
outstanding estimates.
FRM-LAST-SEQ Numeric 3
Last Sequence This field contains the last sequence
number defined for a contract.
FRM-CURRENCY-CODE Alpha 5
Currency Code This field contains the company base
currency code established in Company
(GL10.1 ).
FRM-VARIANCE-LIMIT Signed 15.2
Variance Limit This field contains the monetary value
for the maximum variance allowed between
the submitted and calculated sales
remittances.
The Franchise Management system compares
this variance limit with the sum total
of all line variances of a remittance.
If remittance variance totals are over
this limit, the remittance cannot be
released when you run FR121 (Release
Sales Remittances). The report
generated by FR121 lists each remittance
total variance and the contract variance
limit stored in this field.
FRM-PROCESS-LEVEL Alpha 5
Process Level This field contains the process level,
which is the reporting hierarchy below
company.
FRM-CALENDAR-ID Alpha 10
Calendar Id
FRM-SALES-FL Alpha 1
Sales Fl Y = Yes
N = No
FRM-SALES-BY-DATE Alpha 1
Sales By Date
FRM-LIC-NAME Alpha 30 (Lower Case)
Lic Name
FRM-LIC-ADDR1 Alpha 30 (Lower Case)
Lic Addr1
FRM-LIC-ADDR2 Alpha 30 (Lower Case)
Lic Addr2
FRM-LIC-ADDR3 Alpha 30 (Lower Case)
Lic Addr3
FRM-LIC-ADDR4 Alpha 30 (Lower Case)
Lic Addr4
FRM-LIC-CITY Alpha 18 (Lower Case)
Lic City
FRM-LIC-STATE Alpha 2
License State
FRM-LIC-ZIP Alpha 10
Lic Zip
FRM-LICENS-COUNTRY Alpha 30 (Lower Case)
Licens Country
FRM-LIC-TYPE Alpha 1
Lic Type
FRM-LIC-AGREE-NBR Numeric 12
Lic Agree Nbr
FRM-LIC-STATUS Alpha 1
Lic Status
FRM-LOC-NAME Alpha 30 (Lower Case)
Loc Name
FRM-LOC-ADDR1 Alpha 30 (Lower Case)
Loc Addr1
FRM-LOC-ADDR2 Alpha 30 (Lower Case)
Loc Addr2
FRM-LOC-ADDR3 Alpha 30 (Lower Case)
Loc Addr3
FRM-LOC-ADDR4 Alpha 30 (Lower Case)
Loc Addr4
FRM-LOC-CITY Alpha 18 (Lower Case)
Loc City
FRM-LOC-STATE Alpha 2
Loc State
FRM-LOC-ZIP Alpha 10
Loc Zip
FRM-LOC-COUNTRY Alpha 30 (Lower Case)
Loc Country
FRM-MALL-NAME Alpha 30 (Lower Case)
Mall Name
FRM-PERIODS-OPEN Numeric 2
Periods Open
FRM-DIR-MKTG-AREA Alpha 30 (Lower Case)
Dir Mktg Area
FRM-SQUARE-FOOTAGE Numeric 9
Square Footage
FRM-DATE-CLOSED Numeric 8 (yyyymmdd)
Date Closed
FRM-BUDGET-ID Alpha 10
Budget Id
FRM-ESTIMATES-FL Alpha 1
Estimates Fl A = Estimates from actuals
B = Estimates from budget
FRCONTMAST FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
FRMSET1 COMPANY AR150
CUSTOMER
SHIP-TO
CONTR-NBR
FRMSET2 COMPANY KeyChange, Subset
GROUP-CODE Where ACTIVE-FLAG = "A"
CUSTOMER
SHIP-TO
CONTR-NBR
FRMSET3 COMPANY Subset
CUSTOMER Where SALES-FL = "Y"
SHIP-TO
CONTR-NBR
SALES-FL
FRCONTMAST FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Arcomp ARCOMP Required
FRM-COMPANY -> ACO-COMPANY (ACOSET1)
Arcustomer ARCUSTOMER Required
FRM-COMPANY -> ACM-COMPANY
FRM-CUSTOMER -> ACM-CUSTOMER
Custdesc CUSTDESC Required
ACO-CUST-GROUP -> CUD-CUST-GROUP
FRM-CUSTOMER -> CUD-CUSTOMER
Oecompany OECOMPANY Required
FRM-COMPANY -> OEC-COMPANY
Shipto SHIPTO Required
FRM-COMPANY -> SHP-COMPANY
FRM-CUSTOMER -> SHP-CUSTOMER
FRM-SHIP-TO -> SHP-SHIP-TO
FRCONTMAST FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Frcharge FRCHARGE
FRM-COMPANY -> FRG-COMPANY
FRM-CUSTOMER -> FRG-CUSTOMER
FRM-SHIP-TO -> FRG-SHIP-TO
FRM-CONTR-NBR -> FRG-CONTR-NBR
FRG-SEQ
Frsales FRSALES
FRM-COMPANY -> FRL-COMPANY
FRM-CUSTOMER -> FRL-CUSTOMER
FRM-SHIP-TO -> FRL-SHIP-TO
FRM-CONTR-NBR -> FRL-CONTR-NBR
FRL-DATE
FRL-SALES-TYPE
FRL-ADJ-NBR
|
