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. |
|
||||
AFX-VENDOR Element: Vendor | Alpha 9 (Right Justified) The vendor's identification code. |
|
||||
AFX-INVOICE Element: Invoice | Alpha 22 Used to identify the invoice. |
|
||||
AFX-SUFFIX Element: Suffix | Numeric 3 This is the suffix for the invoice. |
|
||||
AFX-CANCEL-SEQ Element: Seq Nbr | Numeric 4 An automatically assigned sequence number. |
|
||||
AFX-APP-SEQ-NBR Element: Seq Nbr | Numeric 4 An automatically assigned sequence number. |
|
||||
AFX-SEQ-NBR Element: Seq Nbr | Numeric 4 An automatically assigned sequence number. |
|
||||
AFX-VOID-SEQ Element: Seq Nbr | Numeric 4 An automatically assigned sequence number. |
|
||||
AFX-DISC-TYPE Element: Disc Type | Alpha 1 |
|
||||
AFX-DIST-SEQ-NBR Element: Dist Seq Nbr | Numeric 6 A unique sequence number. |
|
||||
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. |
|
||||
AFX-ORIG-TRAN-AMT Element: Intl Amt | Signed 18.2 |
|
||||
AFX-ORIG-BASE-AMT Element: Intl Amt | Signed 18.2 |
|
||||
AFX-TO-BASE-AMT Element: Intl Amt | Signed 18.2 |
|
||||
AFX-TO-BASE-ND Element: Acct Nd | Numeric 1 The number of decimals assigned to a particular account as determined by the account currency. |
|
||||
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. |
|
||||
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. |
|
||||
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. |
|
||||
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. |
|
||||
AFX-DISTRIB-DATE Element: Date | Numeric 8 (yyyymmdd) This field displays the system date when this was created. |
|
||||
AFX-PROC-LEVEL Element: Process Level | Alpha 5 This field contains the process level, which is the reporting hierarchy below company. |
|
||||
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. |
|
||||
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 |
|
||||
AFX-BILL-CATEGORY Element: Bill Category | Alpha 32 |
|
||||
AFX-PO-AOC-CODE Element: Aoc Code | Alpha 2 This field contains the identifier for the add on cost associated with this line item. |
|
||||
AFX-REC-STATUS Element: Rec Status | Numeric 1 The record status. |
|
||||
AFX-USR-FLD-01 Element: Usr Fld 01 | Alpha 20 |
|
||||
AFX-USR-FLD-02 Element: Usr Fld 02 | Alpha 20 |
|
||||
AFX-USR-FLD-03 Element: Usr Fld 03 | Alpha 20 |
|
||||
AFX-USR-FLD-04 Element: Usr Fld 04 | Alpha 20 |
|
||||
AFX-USR-FLD-05 Element: Usr Fld 05 | Alpha 20 |
|
||||
AFX-CREATE-DATE Element: Create Date | Numeric 8 (yyyymmdd) The creation date. |
|
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 |
|
|
All trademarks and registered trademarks are the property of their
respective owners.