APFRIEXP – No description in the Lawson data dictionary
- System
- Accounts Payable (AP)
- Prefix
AFX- Primary key
COMPANY,VENDOR,INVOICE,SUFFIX,CANCEL-SEQ,APP-SEQ-NBR,VOID-SEQ,DISC-TYPE,DIST-SEQ-NBR,SEQ-NBR- Fields
- 32
- Updated by
- 3 programs
- Referenced by
- 0 programs
APFRIEXP is a Lawson Accounts Payable table (prefix AFX); no description in the lawson data dictionary. It is indexed by COMPANY, VENDOR, INVOICE, SUFFIX, CANCEL-SEQ, APP-SEQ-NBR, VOID-SEQ, DISC-TYPE, DIST-SEQ-NBR, SEQ-NBR (AFXSET1). It is updated by AP170, AP177 and AP190. The table has 32 fields, 1 index and 0 documented relations.
About APFRIEXP
No description in the Lawson data dictionary.
Fields (32)
Column = COBOL field name without the AFX- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
AFX-COMPANY PKCOMPANY | 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 PKVENDOR | Alpha 9 (Right Justified) | The vendor's identification code. | AP170, AP177, AP190 |
AFX-INVOICE PKINVOICE | Alpha 22 | Used to identify the invoice. | AP170, AP177, AP190 |
AFX-SUFFIX PKSUFFIX | Numeric 3 | This is the suffix for the invoice. | AP170, AP177, AP190 |
AFX-CANCEL-SEQ PKCANCEL_SEQ | Numeric 4 | An automatically assigned sequence number. | AP170, AP177, AP190 |
AFX-APP-SEQ-NBR PKAPP_SEQ_NBR | Numeric 4 | An automatically assigned sequence number. | AP170, AP190 |
AFX-SEQ-NBR PKSEQ_NBR | Numeric 4 | An automatically assigned sequence number. | AP170, AP177, AP190 |
AFX-VOID-SEQ PKVOID_SEQ | Numeric 4 | An automatically assigned sequence number. | AP170, AP177, AP190 |
AFX-DISC-TYPE PKDISC_TYPE | Alpha 1 | — | AP170, AP177, AP190 |
AFX-DIST-SEQ-NBR PKDIST_SEQ_NBR | Numeric 6 | A unique sequence number. | AP170, AP177, AP190 |
AFX-OBJ-IDOBJ_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-AMTORIG_TRAN_AMT | Signed 18.2 | — | AP170, AP177, AP190 |
AFX-ORIG-BASE-AMTORIG_BASE_AMT | Signed 18.2 | — | AP170, AP177, AP190 |
AFX-TO-BASE-AMTTO_BASE_AMT | Signed 18.2 | — | AP170, AP177, AP190 |
AFX-TO-BASE-NDTO_BASE_ND | Numeric 1 | The number of decimals assigned to a particular account as determined by the account currency. | AP170, AP177, AP190 |
AFX-DIST-COMPANYDIST_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-UNITDIS_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-ACCOUNTDIS_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-ACCTDIS_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-DATEDISTRIB_DATE | Numeric 8 (yyyymmdd) | This field displays the system date when this was created. | AP177 |
AFX-PROC-LEVELPROC_LEVEL | Alpha 5 | This field contains the process level, which is the reporting hierarchy below company. | AP170, AP177, AP190 |
AFX-ACTIVITYACTIVITY | 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-CATEGORYACCT_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-CATEGORYBILL_CATEGORY | Alpha 32 | — | AP177 |
AFX-PO-AOC-CODEPO_AOC_CODE | Alpha 2 | This field contains the identifier for the add on cost associated with this line item. | AP170, AP177, AP190 |
AFX-REC-STATUSREC_STATUS | Numeric 1 | The record status. | AP170, AP177, AP190 |
AFX-USR-FLD-01USR_FLD_01 | Alpha 20 | — | AP170, AP177, AP190 |
AFX-USR-FLD-02USR_FLD_02 | Alpha 20 | — | AP170, AP177, AP190 |
AFX-USR-FLD-03USR_FLD_03 | Alpha 20 | — | AP170, AP177, AP190 |
AFX-USR-FLD-04USR_FLD_04 | Alpha 20 | — | AP170, AP177, AP190 |
AFX-USR-FLD-05USR_FLD_05 | Alpha 20 | — | AP170, AP177, AP190 |
AFX-CREATE-DATECREATE_DATE | Numeric 8 (yyyymmdd) | The creation date. | AP170, AP177, AP190 |
Indexes (1)
Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
AFXSET1 | COMPANY, VENDOR, INVOICE, SUFFIX, CANCEL-SEQ, APP-SEQ-NBR, VOID-SEQ, DISC-TYPE, DIST-SEQ-NBR, SEQ-NBR | Primary | AP170, AP190 |