APFRIEXP FILE
UPDATED BY
AP170 AP177 AP190
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
AFX-COMPANY Numeric 4 AP170 AP177
Company The company number represents an AP190
established company and is entered on
all function codes.
AFX-VENDOR Alpha 9 (Right Justified) AP170 AP177
Vendor ID The vendor's identification code. AP190
AFX-INVOICE Alpha 22 AP170 AP177
Invoice Number Used to identify the invoice. AP190
AFX-SUFFIX Numeric 3 AP170 AP177
Invoice Suffix This is the suffix for the invoice. AP190
AFX-CANCEL-SEQ Numeric 4 AP170 AP177
Cancel Sequence The sequence number assigned upon a AP190
cancellation of a distributed invoice.
The first sequence assigned is 9999.
AFX-APP-SEQ-NBR Numeric 4 AP170 AP190
App Seq Nbr
AFX-SEQ-NBR Numeric 4 AP170 AP177
Sequence Number An automatically assigned sequence AP190
number.
AFX-VOID-SEQ Numeric 4 AP170 AP177
Void Sequence AP190
AFX-DISC-TYPE Alpha 1 AP170 AP177
Disc Type AP190
AFX-DIST-SEQ-NBR Numeric 4 AP170 AP177
Distribution A unique sequence number. AP190
Sequence Number
AFX-OBJ-ID Numeric 12 AP170 AP177
Object This is the object identifier. It is AP190
Identification used to relate commitments or posted
transactions back to the originating
subsystems. Each subsystem record that
is updated as a commitment or posted
transaction is assigned an object
identifier. The object identifier is
maintained in the subsystem files and in
the Activity Commitments Detail and
Activity Transaction files. The object
identifier is a unique key used to drill
back from Activity Management to the
subsystems.
AFX-ORIG-TRAN-AMT Signed 15.2 AP170 AP177
Distribution Amount AP190
AFX-ORIG-BASE-AMT Signed 15.2 AP170 AP177
Original Base Amount AP190
AFX-TO-BASE-AMT Signed 15.2 AP170 AP177
To Company Base AP190
Amount
AFX-TO-BASE-ND Numeric 1 AP170 AP177
To Base Number Of AP190
Decimals
AFX-DIST-COMPANY Numeric 4 AP170 AP177
Distribution Company The company number used for posting the AP190
transaction. A valid intercompany
relationship must be defined in the
Lawson General Ledger system.
AFX-DIS-ACCT-UNIT Alpha 15 AP170 AP177
Accounting Unit The general ledger distribution AP190
accounting unit. Select a valid
accounting unit if you want the
interface program to create general
ledger transactions for transaction with
a record status of '1' and '2' only. A
transaction will be created to this
account and an offset transaction to the
cash account will occur.
AFX-DIS-ACCOUNT Numeric 6 AP170 AP177
Account Number Required if the distribution accounting AP190
unit field is not blank. The general
ledger distribution account.
AFX-DIS-SUB-ACCT Numeric 4 AP170 AP177
Subaccount Number The general ledger distribution AP190
subaccount.
AFX-DISTRIB-DATE Numeric 8 (yyyymmdd)
Distribution Date The date used for posting the
transactions to the general ledger.
AFX-PROC-LEVEL Alpha 5 AP170 AP177
Process Level The process level represents a AP190
reporting level below company.
AFX-ACTIVITY Alpha 15 AP170 AP177
Activity Activities are the processes or AP190
procedures that produce work. Cost
objects (products, services, customers,
and so on) are the reasons for
performing the activity.
AFX-ACCT-CATEGORY Alpha 5 AP170 AP177
Account Category Account categories are groupings of AP190
costs, revenues, or a combination of
both used for reporting and inquiries
for activities in the Activity
Management system. All transactions are
posted to an account category within an
activity. You can assign a specific
General Ledger account or range of
accounts (company, accounting unit,
account, and subaccount) that make up
the transactions posted to an account
category using AC07.1 (Account
Assignment).
Period-to-date, year-to-date, and
life-to-date balances are maintained by
account category for activities. Account
categories must be assigned to
activities before you do any budgeting
or transaction processing.
AFX-PO-AOC-CODE Alpha 2 AP170 AP177
Purchase Order Add AP190
On Cost Flg
AFX-REC-STATUS Numeric 1 AP170 AP177
Record Status The record status. AP190
AFX-USR-FLD-01 Alpha 20 AP170 AP177
Usr Fld 01 AP190
AFX-USR-FLD-02 Alpha 20 AP170 AP177
Usr Fld 02 AP190
AFX-USR-FLD-03 Alpha 20 AP170 AP177
Usr Fld 03 AP190
AFX-USR-FLD-04 Alpha 20 AP170 AP177
Usr Fld 04 AP190
AFX-USR-FLD-05 Alpha 20 AP170 AP177
Usr Fld 05 AP190
AFX-CREATE-DATE Numeric 8 (yyyymmdd) AP170 AP177
Creation Date The creation date. AP190
APFRIEXP FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
AFXSET1 COMPANY AP170 AP190
VENDOR
INVOICE
SUFFIX
CANCEL-SEQ
APP-SEQ-NBR
VOID-SEQ
DISC-TYPE
DIST-SEQ-NBR
SEQ-NBR
AFXSET2 COMPANY KeyChange
REC-STATUS
VENDOR
INVOICE
SUFFIX
CANCEL-SEQ
APP-SEQ-NBR
VOID-SEQ
DISC-TYPE
DIST-SEQ-NBR
SEQ-NBR
|
