|
|
FRCONTMAST FILE
FR Contract Master
This file contains 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
Contract Number This field contains the number
representing the business agreement and
terms between the franchiser and
franchisee.
FRM-FRANCHISE-FL Alpha 1
Franchise Flag This field indicates whether the store
is a franchise store or corporately
owned. Only franchise stores are
processed by the Franchise Management
system.
Y = Yes
N = No
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)
Termination 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 Flag Defines if Taxable.
E = Excempt
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 actual invoice processed in the
system.
FRM-TTL-ESTIMATES Signed 15.2
Total 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 GL10.1
(Company).
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.
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 ACTIVE-FLAG = "A"
SHIP-TO And FRANCHISE-FL = "Y"
CONTR-NBR
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
|