|
|
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
Element: Company This field contains the company number
defined in the General Ledger, Accounts
Receivable, and Billing systems.
FRM-CUSTOMER Alpha 9 (Right Justified)
Element: Customer NumbeThis field contains the customer number
defined in the Accounts Receivable
system.
FRM-SHIP-TO Numeric 4
Element: Ship-to Code This field contains the customer ship-to
number defined in the Billing system.
FRM-CONTR-NBR Numeric 6
Element: Contr Nbr This field contains the number
representing the business agreement and
terms between the franchiser and
franchisee.
FRM-ACTIVE-FLAG Alpha 1
Element: Status This determines if the contract is
active or inactive.
A = Active
I = Inactive
FRM-CONTRACT-DATE Numeric 8 (yyyymmdd)
Element: 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)
Element: Date If entered, defines the end date of the
contract. Charges will not be processed
beyond the termination date.
FRM-GROUP-CODE Alpha 4
Element: 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
Element: Tax Code This field contains a code representing
specific tax information. This must be
valid Tax Code.
FRM-LAST-ACT-DATE Numeric 8 (yyyymmdd)
Element: Last Account DThis field contains the date of the last
release for an estimate, call-in
estimate, or actual sales record.
FRM-TTL-ESTIMATES Signed 18.2
Element: Intl Amt This field contains the total of the
outstanding estimates.
FRM-LAST-SEQ Numeric 3
Element: Sequence NumbeThis field contains the last sequence
number defined for a contract.
FRM-CURRENCY-CODE Alpha 5
Element: Currency Code This field contains the company base
currency code established in Company
(GL10.1 ).
FRM-VARIANCE-LIMIT Signed 18.2
Element: Variance LimitThis 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
Element: Process Level This field contains the process level,
which is the reporting hierarchy below
company.
FRM-CALENDAR-ID Alpha 10
Element: Calendar Id
FRM-SALES-FL Alpha 1
Element: Sales Fl Y = Yes
N = No
FRM-SALES-BY-DATE Alpha 1
Element: Sales By Date
FRM-BUDGET-ID Alpha 10
Element: Budget Id
FRM-ESTIMATES-FL Alpha 1
Element: 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
|
