|
|
FRISALES FILE
UPDATED BY
AR570
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
FRI-COMPANY Numeric 4 AR570
Element: Company Identifies the AP company if the
resource type = V. Identifies the HR
company if the resource type = E. It is
blank for type A, P or Q resources.
FRI-CUSTOMER Alpha 9 (Right Justified) AR570
Element: Customer This field contains the number that
represents a customer.
FRI-SHIP-TO Numeric 4 AR570
Element: Ship To This field contains the number
representing the ship to customer.
FRI-CONTR-NBR Numeric 6 AR570
Element: Contr Nbr This field contains the contract number.
FRI-SALES-TYPE Alpha 1 AR570
Element: Sales Type A = Actual Invoice
C = Call-In Estimated Invoice
S = Aggregate Sales
FRI-DATE Numeric 8 (yyyymmdd) AR570
Element: Date This field displays the system date
when this was created.
FRI-ADJ-NBR Numeric 3 AR570
Element: Adj Nbr
FRI-SALES-CLOSE Signed 18.2 AR570
Element: Intl Amt
FRI-SALES-TAX Signed 18.2
Element: Intl Amt
FRI-ADJUSTMENTS Signed 18.2
Element: Intl Amt
FRI-SEGMENT-BLOCK Alpha 103
Element: Segment Block 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
Element: Process Level This field contains the process level,
which is the reporting hierarchy below
company.
FRI-POST-DATE Numeric 8 (yyyymmdd)
Element: Post Date The date general ledger entries for the
transaction will be posted to the
general ledger.
FRI-FRL-USR-FLD-01 Alpha 20
Element: Frl Usr Fld 01
FRI-FRL-USR-FLD-02 Alpha 20
Element: Frl Usr Fld 02
FRI-FRL-USR-FLD-03 Alpha 20
Element: Frl Usr Fld 03
FRI-FRL-USR-FLD-04 Alpha 20
Element: Frl Usr Fld 04
FRI-FRL-USR-FLD-05 Alpha 20
Element: 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
|
