|
|
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
Element: Company This field contains the company number
defined in the General Ledger, Accounts
Receivable, and Billing systems.
FRL-CUSTOMER Alpha 9 (Right Justified)
Element: Customer NumbeThis field contains the customer number
defined in the Accounts receivable
system.
FRL-SHIP-TO Numeric 4
Element: Ship-to Code This field contains the customer ship
to number defined in the Billing system.
FRL-CONTR-NBR Numeric 6
Element: Contract NumbeThis field contains the number
representing the business agreement and
terms between the franchiser and
franchisee.
FRL-SALES-TYPE Alpha 1
Element: 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
S = Aggregate Sales
FRL-DATE Numeric 8 (yyyymmdd)
Element: Date This date must match a valid cycle date
specified in FR00.1 (Calendar).
FRL-ADJ-NBR Numeric 3
Element: Adj Nbr
FRL-FISCAL-YEAR Numeric 4
Element: Last Closed YeThis is the current fiscal year. This
field is updated by Period Closing
(GL199).
FRL-FISCAL-MONTH Numeric 2
Element: Fiscal Month This field contains the number for the
fiscal month.
FRL-CYCLE-NBR Numeric 2
Element: 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
Element: Status This field displays the status of the
transaction.
0 = Unreleased
1 = Released
2 = Invoiced
9 = Closed
FRL-REGISTER-CLOSE Signed 15.2
Element: Closing RegistThis field contains the closing register
amount.
FRL-SALES-TAX Signed 15.2
Element: Sales Tax This field contains the submitted sales
tax amount from the franchisee.
FRL-ADJUSTMENTS Signed 15.2
Element: Adjustments This field allows entry of adjustments
such as overrings.
FRL-NET-SALES Signed 15.2
Element: Net Sales This field contains the submitted net
sales figure from the franchisee.
FRL-TTL-REG-CLOSE Signed 15.2
Element: Ttl Reg Close
FRL-TTL-SALES-TAX Signed 15.2
Element: Ttl Sales Tax
FRL-TTL-ADJUSTMENT Signed 15.2
Element: Ttl Adjustment
FRL-TTL-NET-SALES Signed 15.2
Element: Ttl Net Sales
FRL-TTL-CHARGES Signed 15.2
Element: Total Charges This field contains the total of the
calculated charges for the invoice.
FRL-TTL-DUE Signed 15.2
Element: 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
Element: Total VarianceThis field contains the calculated
difference between the total subnmitted
charges and the total calculated
charges.
FRL-INVC-PREFIX Alpha 2
Element: Invoice PrefixThis 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
Element: Invoice NumberThis 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-ENTER-CHG-FL Alpha 1
Element: Enter Charge FThis field indicates whether the user
must define submitted charges for the
remittance.
Y = Yes
N = No
FRL-PROCESS-LEVEL Alpha 5
Element: Process Level This field contains the process level,
which is the reporting hierarchy below
company.
FRL-POST-DATE Numeric 8 (yyyymmdd)
Element: Date
FRSALES FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
FRLSET1 COMPANY
CUSTOMER
SHIP-TO
CONTR-NBR
SALES-TYPE
DATE
ADJ-NBR
FRLSET2 COMPANY KeyChange, Subset AR150
CUSTOMER Where SALES-TYPE != "A"
SHIP-TO And STATUS = 1
CONTR-NBR
DATE
SALES-TYPE
ADJ-NBR
FRLSET3 COMPANY KeyChange, Subset
CUSTOMER Where SALES-TYPE != "E"
SHIP-TO And STATUS > Zeroes
CONTR-NBR*
DATE*
SALES-TYPE
ADJ-NBR
FRLSET4 COMPANY KeyChange, Subset
CUSTOMER Where SALES-TYPE = "A"
SHIP-TO And STATUS = 1
CONTR-NBR
DATE
SALES-TYPE
ADJ-NBR
FRLSET5 COMPANY KeyChange, Subset
CUSTOMER Where SALES-TYPE = "A"
SHIP-TO And STATUS < 2
CONTR-NBR
DATE
SALES-TYPE
ADJ-NBR
FRLSET6 COMPANY Subset
CUSTOMER Where SALES-TYPE = "S"
SHIP-TO
CONTR-NBR
DATE
ADJ-NBR
SALES-TYPE
FRLSET7 COMPANY KeyChange, Subset
CUSTOMER Where STATUS < 2
SHIP-TO
CONTR-NBR
DATE
SALES-TYPE
ADJ-NBR
FRLSET9 COMPANY
CUSTOMER
SHIP-TO
CONTR-NBR
DATE
SALES-TYPE
ADJ-NBR
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
|
