APFRIEXP

AP Financial Reporting Export
UPDATED BY
AP170 AP177 AP190

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
AFX-COMPANY
Element: Company
Numeric 4
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.
AP170 AP177
AP190
AFX-VENDOR
Element: Vendor
Alpha 9 (Right Justified)
The vendor's identification code.
AP170 AP177
AP190
AFX-INVOICE
Element: Invoice
Alpha 22
Used to identify the invoice.
AP170 AP177
AP190
AFX-SUFFIX
Element: Suffix
Numeric 3
This is the suffix for the invoice.
AP170 AP177
AP190
AFX-CANCEL-SEQ
Element: Seq Nbr
Numeric 4
An automatically assigned sequence number.
AP170 AP177
AP190
AFX-APP-SEQ-NBR
Element: Seq Nbr
Numeric 4
An automatically assigned sequence number.
AP170 AP190
AFX-SEQ-NBR
Element: Seq Nbr
Numeric 4
An automatically assigned sequence number.
AP170 AP177
AP190
AFX-VOID-SEQ
Element: Seq Nbr
Numeric 4
An automatically assigned sequence number.
AP170 AP177
AP190
AFX-DISC-TYPE
Element: Disc Type
Alpha 1
AP170 AP177
AP190
AFX-DIST-SEQ-NBR
Element: Dist Seq Nbr
Numeric 6
A unique sequence number.
AP170 AP177
AP190
AFX-OBJ-ID
Element: Obj Id
Numeric 12
This is the object identifier. It is 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.
AP170 AP177
AP190
AFX-ORIG-TRAN-AMT
Element: Intl Amt
Signed 18.2
AP170 AP177
AP190
AFX-ORIG-BASE-AMT
Element: Intl Amt
Signed 18.2
AP170 AP177
AP190
AFX-TO-BASE-AMT
Element: Intl Amt
Signed 18.2
AP170 AP177
AP190
AFX-TO-BASE-ND
Element: Acct Nd
Numeric 1
The number of decimals assigned to a particular account as determined by the account currency.
AP170 AP177
AP190
AFX-DIST-COMPANY
Element: Company
Numeric 4
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.
AP170 AP177
AP190
AFX-DIS-ACCT-UNIT
Element: Acct Unit
Alpha 15
The accounting unit is a shorthand 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.
AP170 AP177
AP190
AFX-DIS-ACCOUNT
Element: Account
Numeric 6
This field along with the accounting unit and subaccount make up the location (account) where amounts and other account information is stored.
AP170 AP177
AP190
AFX-DIS-SUB-ACCT
Element: Sub Acct
Numeric 4
This field contains the subaccount from your general ledger chart of accounts that was charged with the amount carried on this record.
AP170 AP177
AP190
AFX-DISTRIB-DATE
Element: Date
Numeric 8 (yyyymmdd)
This field displays the system date when this was created.
AP177
AFX-PROC-LEVEL
Element: Process Level
Alpha 5
This field contains the process level, which is the reporting hierarchy below company.
AP170 AP177
AP190
AFX-ACTIVITY
Element: Activity
Alpha 15
Activities are the processes or procedures that produce work. Cost objects (products, services, customers, and so on) are the reasons for performing the activity.
AP170 AP177
AP190
AFX-ACCT-CATEGORY
Element: Acct Category
Alpha 5
Account categories are groupings of 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
AP170 AP177
AP190
AFX-BILL-CATEGORY
Element: Bill Category
Alpha 32
AP177
AFX-PO-AOC-CODE
Element: Aoc Code
Alpha 2
This field contains the identifier for the add on cost associated with this line item.
AP170 AP177
AP190
AFX-REC-STATUS
Element: Rec Status
Numeric 1
The record status.
AP170 AP177
AP190
AFX-USR-FLD-01
Element: Usr Fld 01
Alpha 20
AP170 AP177
AP190
AFX-USR-FLD-02
Element: Usr Fld 02
Alpha 20
AP170 AP177
AP190
AFX-USR-FLD-03
Element: Usr Fld 03
Alpha 20
AP170 AP177
AP190
AFX-USR-FLD-04
Element: Usr Fld 04
Alpha 20
AP170 AP177
AP190
AFX-USR-FLD-05
Element: Usr Fld 05
Alpha 20
AP170 AP177
AP190
AFX-CREATE-DATE
Element: Create Date
Numeric 8 (yyyymmdd)
The creation date.
AP170 AP177
AP190


APFRIEXP FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
AFXSET1 COMPANY
VENDOR
INVOICE
SUFFIX
CANCEL-SEQ
APP-SEQ-NBR
VOID-SEQ
DISC-TYPE
DIST-SEQ-NBR
SEQ-NBR
AP170 AP190


File created: Wed Jun 08 20:47:31 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.