|
|
APFRIEXP FILE
UPDATED BY
AP170 AP177 AP190
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
AFX-COMPANY Numeric 4 AP170 AP177
Element: Company Identifies the AP company if the AP190
resource type = V. Identifies the HR
company if the resource type = E. It is
blank for type A, P or Q resources.
AFX-VENDOR Alpha 9 (Right Justified) AP170 AP177
Element: Vendor ID The vendor's identification code. AP190
AFX-INVOICE Alpha 22 AP170 AP177
Element: Invoice NumberUsed to identify the invoice. AP190
AFX-SUFFIX Numeric 3 AP170 AP177
Element: Invoice SuffixThis is the suffix for the invoice. AP190
AFX-CANCEL-SEQ Numeric 4 AP170 AP177
Element: Sequence NumbeThe 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
Element: Sequence Number
AFX-SEQ-NBR Numeric 4 AP170 AP177
Element: Sequence NumbeAn automatically assigned sequence AP190
number.
AFX-VOID-SEQ Numeric 4 AP170 AP177
Element: Sequence Number AP190
AFX-DISC-TYPE Alpha 1 AP170 AP177
Element: 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 18.2 AP170 AP177
Element: Intl Amt AP190
AFX-ORIG-BASE-AMT Signed 18.2 AP170 AP177
Element: Intl Amt AP190
AFX-TO-BASE-AMT Signed 18.2 AP170 AP177
Element: Intl Amt AP190
AFX-TO-BASE-ND Numeric 1 AP170 AP177
Account Currency AP190
Code
AFX-DIST-COMPANY Numeric 4 AP170 AP177
Element: 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
Element: Accounting UniThe 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
Element: Account Required if the distribution accounting AP190
unit field is not blank. The general
ledger distribution account.
AFX-DIS-SUB-ACCT Numeric 4 AP170 AP177
Element: Subaccount The general ledger distribution AP190
subaccount.
AFX-DISTRIB-DATE Numeric 8 (yyyymmdd)
Element: Date The date used for posting the
transactions to the general ledger.
AFX-PROC-LEVEL Alpha 5 AP170 AP177
Element: Process Level The process level represents a AP190
reporting level below company.
AFX-ACTIVITY Alpha 15 AP170 AP177
Element: 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
Element: Account CategoAccount 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.
Valid account category types are:
cost
revenue
accrual
pass thru
AFX-BILL-CATEGORY Alpha 32 AP177
Element: Bill Category
AFX-PO-AOC-CODE Alpha 2 AP170 AP177
Element: Add On Cost Code AP190
AFX-REC-STATUS Numeric 1 AP170 AP177
Element: Record Status The record status. AP190
AFX-USR-FLD-01 Alpha 20 AP170 AP177
Element: Usr Fld 01 AP190
AFX-USR-FLD-02 Alpha 20 AP170 AP177
Element: Usr Fld 02 AP190
AFX-USR-FLD-03 Alpha 20 AP170 AP177
Element: Usr Fld 03 AP190
AFX-USR-FLD-04 Alpha 20 AP170 AP177
Element: Usr Fld 04 AP190
AFX-USR-FLD-05 Alpha 20 AP170 AP177
Element: Usr Fld 05 AP190
AFX-CREATE-DATE Numeric 8 (yyyymmdd) AP170 AP177
Element: 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
|
