FRISALES FILE
UPDATED BY
AR570
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
FRI-COMPANY Numeric 4 AR570
Company The company number represents an
established company and is entered on
all function codes.
FRI-CUSTOMER Alpha 9 (Right Justified) AR570
Customer Number This field contains the number that
represents a customer.
FRI-SHIP-TO Numeric 4 AR570
Ship-to Code This field contains the number
representing the ship to customer.
FRI-CONTR-NBR Numeric 6 AR570
Contr Nbr This field contains the contract number.
FRI-SALES-TYPE Alpha 1 AR570
Sales Type A = Actual Invoice
C = Call-In Estimated Invoice
S = Aggregate Sales
FRI-DATE Numeric 8 (yyyymmdd) AR570
Date This field displays the system date
when this was created.
FRI-ADJ-NBR Numeric 3 AR570
Adj Nbr
FRI-SALES-CLOSE Signed 15.2 AR570
Sales Close
FRI-SALES-TAX Signed 15.2
Sales Tax
FRI-ADJUSTMENTS Signed 15.2
Adjustments
FRI-SEGMENT-BLOCK Alpha 103
User Analysis This field identifies the user analysis
values included in the transaction.
You can either type up to four values
or use Define (F6) to open the User
Analysis Entry subform. Use this subform
to select the user analysis values you
want to include in the transaction. If
you choose to type values, use commas to
separate them. For example:
value1,value2,value3,value4
There are three conditions that affect
how you can select user analysis values.
See the User Analysis Entry form help or
the Strategic Ledger procedures manual
for additional information.
FRI-PROCESS-LEVEL Alpha 5
Process Level This field contains the process level,
which is the reporting hierarchy below
company.
FRI-POST-DATE Numeric 8 (yyyymmdd)
General Ledger The date general ledger entries for the
Posting Date transaction will be posted to the
general ledger.
FRI-FRL-USR-FLD-01 Alpha 20
Frl Usr Fld 01
FRI-FRL-USR-FLD-02 Alpha 20
Frl Usr Fld 02
FRI-FRL-USR-FLD-03 Alpha 20
Frl Usr Fld 03
FRI-FRL-USR-FLD-04 Alpha 20
Frl Usr Fld 04
FRI-FRL-USR-FLD-05 Alpha 20
Frl Usr Fld 05
FRISALES FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
FRISET1 COMPANY AR570
CUSTOMER
SHIP-TO
CONTR-NBR
SALES-TYPE
DATE
ADJ-NBR
FRISET2 COMPANY
CUSTOMER
SHIP-TO
CONTR-NBR
SALES-TYPE*
DATE
ADJ-NBR
|
