|
|
FRSALES FILE
FR Sales Remittance
This file contains the sales remittance header data. Individual charges are
defined to the FRCYCCHG file.
REFERENCED BY
AR150
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
FRL-COMPANY Numeric 4
Company This field contains the company number
defined in the General Ledger, Accounts
Receivable, and Billing systems.
FRL-CUSTOMER Alpha 9 (Right Justified)
Customer Number This field contains the customer number
defined in the Accounts Receivable
system.
FRL-SHIP-TO Numeric 4
Ship-to Code This field contains the customer
ship-to number defined in the Billing
system.
FRL-CONTR-NBR Numeric 6
Contract Number This field contains the number
representing the business agreement and
terms between the franchiser and
franchisee.
FRL-SALES-TYPE Alpha 1
Sales Type This field contains the type of
invoice. An invoice can exist for all
three types for a given period, however,
only one can be active.
A = Actual Invoice
C = Call-in Estimate
E = Estimated Invoice
FRL-DATE Numeric 8 (yyyymmdd)
Date This date must match a valid cycle date
specified in FR00.1 (Calendar).
FRL-FISCAL-YEAR Numeric 4
Fiscal Year This is the current fiscal year. This
field is updated by GL199 (Period
Closing).
FRL-FISCAL-MONTH Numeric 2
Fiscal Month This field contains the number for the
fiscal month.
FRL-CYCLE-NBR Numeric 2
Cycle Number This field contains the number of the
cycle. A cycle number displays in FR00.1
(Calendar) for each cycle date field.
FRL-STATUS Numeric 1
Status This field contains the status of the
transaction.
0 = Unreleased
1 = Released
9 = Closed
FRL-REGISTER-CLOSE Signed 15.2
Closing Register This field contains the closing
register amount.
FRL-REGISTER-OPEN Signed 15.2
Opening Register This field contains the opening
register amount.
FRL-GROSS-SALES Signed 15.2
Gross Sales Gross Sales is the difference between
the opening and closing register
amounts.
FRL-SALES-TAX Signed 15.2
Sales Tax This field contains the submitted sales
tax amount from the franchisee.
FRL-ADJUSTMENTS Signed 15.2
Adjustments This field allows entry of adjustments
such as overrings.
FRL-NET-SALES Signed 15.2
Net Sales This field contains the submitted net
sales figure from the franchisee.
FRL-TTL-CHARGES Signed 15.2
Total Charges This field contains the total of the
calculated charges for the invoice.
FRL-TTL-DUE Signed 15.2
Total Due This field contains the amount due for
the invoice. It will equal the total
charges, unless a line was overridden.
FRL-TTL-VARIANCE Signed 15.2
Total Variance This field contains the calculated
difference between the total submitted
charges and the total calculated
charges.
FRL-INVC-PREFIX Alpha 2
Invoice Prefix This field contains the invoice prefix
that is assigned from either the company
or process level, depending on the
invoice-level option chosen.
FRL-INVC-NUMBER Numeric 8
Invoice Number This field contains the invoice number
assigned by the system. Invoice numbers
are assigned at the company or process
level, depending on an invoice-level
option on the company file.
FRL-LAST-SEQ Numeric 3
Last Sequence This field contains the last sequence
number used for the sales remittance.
FRL-ENTER-CHG-FL Alpha 1
Enter Charge Flag This field indicates whether the user
must define submitted charges for the
remittance.
Y = Yes
N = No
FRL-ACCRUAL-ENABLE Alpha 1
Accrual Enable Flag This field indicates whether or not to
allow period-end accruals.
Y = Enabled for Period-End Accrual
N = Not Enabled for Accrual
FRSALES FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
FRLSET1 COMPANY
CUSTOMER
SHIP-TO
CONTR-NBR
SALES-TYPE
DATE
FRLSET10 COMPANY KeyChange, Subset
CUSTOMER Where STATUS < 9
SHIP-TO
CONTR-NBR
SALES-TYPE
DATE
FRLSET2 COMPANY KeyChange, Subset AR150
CUSTOMER Where SALES-TYPE != "A"
SHIP-TO And STATUS = 1
CONTR-NBR
DATE
SALES-TYPE
FRLSET3 COMPANY KeyChange, Subset
CUSTOMER Where SALES-TYPE != "E"
SHIP-TO And STATUS > Zeroes
CONTR-NBR*
DATE*
SALES-TYPE
FRLSET4 COMPANY KeyChange, Subset
CUSTOMER Where SALES-TYPE = "A"
SHIP-TO And STATUS = 1
CONTR-NBR
DATE
SALES-TYPE
FRLSET5 COMPANY KeyChange, Subset
CUSTOMER Where SALES-TYPE = "A"
SHIP-TO And STATUS < 2
CONTR-NBR
DATE
SALES-TYPE
FRLSET6 COMPANY KeyChange, Subset
CUSTOMER Where STATUS = 1
SHIP-TO
CONTR-NBR*
DATE*
SALES-TYPE
FRLSET7 COMPANY KeyChange, Subset
CUSTOMER Where STATUS < 2
SHIP-TO
CONTR-NBR
DATE
SALES-TYPE
FRLSET8 COMPANY KeyChange, Subset
CUSTOMER Where STATUS = 1
SHIP-TO
CONTR-NBR
SALES-TYPE
DATE
FRLSET9 COMPANY
CUSTOMER
SHIP-TO
CONTR-NBR
DATE
SALES-TYPE
FRSALES FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Arcomp ARCOMP Required
FRL-COMPANY -> ACO-COMPANY (ACOSET1)
Custdesc CUSTDESC Required
ACO-CUST-GROUP -> CUD-CUST-GROUP
FRL-CUSTOMER -> CUD-CUSTOMER
Frcontmast FRCONTMAST Required
FRL-COMPANY -> FRM-COMPANY
FRL-CUSTOMER -> FRM-CUSTOMER
FRL-SHIP-TO -> FRM-SHIP-TO
FRL-CONTR-NBR -> FRM-CONTR-NBR
Froptions FROPTIONS Required
FRL-COMPANY -> FRO-COMPANY
Oecompany OECOMPANY Required
FRL-COMPANY -> OEC-COMPANY
Shipto SHIPTO Required
FRL-COMPANY -> SHP-COMPANY
FRL-CUSTOMER -> SHP-CUSTOMER
FRL-SHIP-TO -> SHP-SHIP-TO
|