APDFTSTMT – No description in the Lawson data dictionary
- System
- Accounts Payable (AP)
- Prefix
ADF- Primary key
CASH-CODE,PAY-GROUP,STATEMENT-NBR,COMPANY- Fields
- 9
- Updated by
- 2 programs
- Referenced by
- 0 programs
APDFTSTMT is a Lawson Accounts Payable table (prefix ADF); no description in the lawson data dictionary. It is indexed by CASH-CODE, PAY-GROUP, STATEMENT-NBR, COMPANY (ADFSET1). It is updated by AP167 and AP181. The table has 9 fields, 1 index and 0 documented relations.
About APDFTSTMT
No description in the Lawson data dictionary.
Fields (9)
Column = COBOL field name without the ADF- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
#ADF-CASH-CODE PKCASH_CODE | Alpha 4 | A cash code represents a bank account. More than one company can use the same cash code. The cash code must be linked to a bank in the Lawson Cash Ledger system. | AP167 |
#ADF-PAY-GROUP PKPAY_GROUP | Alpha 4 | A pay group is used for processing accounts payable payments. A pay group lets you create a single payment for a vendor to pay invoices received by all company process levels assigned to the pay group. | AP167 |
#ADF-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. | AP167 |
#ADF-STATUSSTATUS | Numeric 1 | This field displays the status of the transaction.
| AP167, AP181 |
#ADF-STATEMENT-NBR PKSTATEMENT_NBR | Numeric 8 | — | AP167 |
#ADF-BANK-INST-CODEBANK_INST_CODE | Alpha 3 | A transaction code represents a type of cash payment, bill of exchange payment, or bank service transaction. | AP167 |
#ADF-STATEMENT-DATESTATEMENT_DATE | Numeric 8 (yyyymmdd) | This field displays the system date when this was created. | AP167 |
#ADF-STMT-TRAN-AMTSTMT_TRAN_AMT | Signed 18.2 | — | AP167 |
#ADF-STMT-BASE-AMTSTMT_BASE_AMT | Signed 18.2 | — | AP167 |
Indexes (1)
Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
ADFSET1 |
| Primary | AP181 |