|
APFRIEXP FILE
AP Financial Reporting Export
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 The vendor's identification code. AP190
AFX-INVOICE Alpha 22 AP170 AP177
Element: Invoice Used to identify the invoice. AP190
AFX-SUFFIX Numeric 3 AP170 AP177
Element: Suffix This is the suffix for the invoice. AP190
AFX-CANCEL-SEQ Numeric 4 AP170 AP177
Element: Seq Nbr An automatically assigned sequence AP190
number.
AFX-APP-SEQ-NBR Numeric 4 AP170 AP190
Element: Seq Nbr An automatically assigned sequence
number.
AFX-SEQ-NBR Numeric 4 AP170 AP177
Element: Seq Nbr An automatically assigned sequence AP190
number.
AFX-VOID-SEQ Numeric 4 AP170 AP177
Element: Seq Nbr An automatically assigned sequence AP190
number.
AFX-DISC-TYPE Alpha 1 AP170 AP177
Element: Disc Type AP190
AFX-DIST-SEQ-NBR Numeric 6 AP170 AP177
Element: Dist Seq Nbr A unique sequence number. AP190
AFX-OBJ-ID Numeric 12 AP170 AP177
Element: Obj Id This is the object identifier. It is AP190
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
Element: Acct Nd The number of decimals assigned to a AP190
particular account as determined by the
account currency.
AFX-DIST-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-DIS-ACCT-UNIT Alpha 15 AP170 AP177
Element: Acct Unit The accounting unit is a shorthand AP190
notation representing the variable level
number. When used in the General Ledger
Account Master file, the accounting unit
must be defined in the General Ledger
Names file as a posting accounting unit.
AFX-DIS-ACCOUNT Numeric 6 AP170 AP177
Element: Account This field along with the accounting AP190
unit and subaccount make up the location
(account) where amounts and other
account information is stored.
AFX-DIS-SUB-ACCT Numeric 4 AP170 AP177
Element: Sub Acct This field contains the subaccount from AP190
your general ledger chart of accounts
that was charged with the amount carried
on this record.
AFX-DISTRIB-DATE Numeric 8 (yyyymmdd) AP177
Element: Date This field displays the system date
when this was created.
AFX-PROC-LEVEL Alpha 5 AP170 AP177
Element: Process Level This field contains the process level, AP190
which is the reporting hierarchy 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: Acct 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.
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: Aoc Code This field contains the identifier for AP190
the add on cost associated with this
line item.
AFX-REC-STATUS Numeric 1 AP170 AP177
Element: Rec 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: Create 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
|