EEEXPDTL – No description in the Lawson data dictionary
- System
- Accounts Payable (AP)
- Prefix
XPD- Primary key
COMPANY,EMPLOYEE,DOCUMENT,SEQ- Fields
- 42
- Updated by
- 4 programs
- Referenced by
- 0 programs
EEEXPDTL is a Lawson Accounts Payable table (prefix XPD); no description in the lawson data dictionary. It is indexed by COMPANY, EMPLOYEE, DOCUMENT, SEQ (XPDSET1); alternate indexes: XPDSET2, XPDSET3 and XPDSET4. It is updated by EX175, EX20.2, EX542 and EXXM.1. The table has 42 fields, 4 indexes and 0 documented relations.
About EEEXPDTL
No description in the Lawson data dictionary.
Fields (42)
Column = COBOL field name without the XPD- 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 |
|---|---|---|---|
#XPD-COMPANY PKCOMPANY | Numeric 4 | — | EX20.2, EXXM.1 |
#XPD-EMPLOYEE PKEMPLOYEE | Numeric 9 | — | EX20.2, EXXM.1 |
#XPD-DOCUMENT PKDOCUMENT | Alpha 22 | — | EX20.2, EXXM.1 |
#XPD-VENDORVENDOR | Alpha 9 (Right Justified) | — | EX20.2, EXXM.1 |
#XPD-SEQ PKSEQ | Numeric 4 | — | EX20.2, EXXM.1 |
#XPD-EXPENSE-CODEEXPENSE_CODE | Alpha 20 | — | EX20.2, EXXM.1 |
#XPD-EXPENSE-DATEEXPENSE_DATE | Numeric 8 (yyyymmdd) | — | EX20.2, EXXM.1 |
#XPD-EE-COMMENT1EE_COMMENT1 | Alpha 500 (Lower Case) | — | EXXM.1 |
#XPD-EE-COMMENT2EE_COMMENT2 | Alpha 500 (Lower Case) | — | EXXM.1 |
#XPD-EE-COMMENT3EE_COMMENT3 | Alpha 500 (Lower Case) | — | EXXM.1 |
#XPD-STATUS SET2STATUS | Numeric 1 | —
| EX175, EX20.2, EX542, EXXM.1 |
#XPD-SENT-DATESENT_DATE | Numeric 8 (yyyymmdd) | — | EX175, EX20.2, EX542, EXXM.1 |
#XPD-PAYMETHOD SET3PAYMETHOD | Numeric 4 | —
| EX20.2, EXXM.1 |
#XPD-TRAN-CURRENCYTRAN_CURRENCY | Alpha 5 | — | EX20.2, EXXM.1 |
#XPD-TRAN-AMTTRAN_AMT | Signed 18.2 | — | EX20.2, EXXM.1 |
#XPD-REIM-CURRENCYREIM_CURRENCY | Alpha 5 | — | EX175, EX20.2, EXXM.1 |
#XPD-REIM-AMTREIM_AMT | Signed 18.2 | — | EX175, EX20.2, EX542, EXXM.1 |
#XPD-REIMRATEREIMRATE | Signed 14.7 | — | EX20.2, EXXM.1 |
#XPD-BASE-CURRENCYBASE_CURRENCY | Alpha 5 | — | EX20.2, EX542, EXXM.1 |
#XPD-BASE-AMTBASE_AMT | Signed 18.2 | — | EX20.2, EXXM.1 |
#XPD-BASERATEBASERATE | Signed 14.7 | — | EX20.2, EXXM.1 |
#XPD-TRAN-PERS-AMTTRAN_PERS_AMT | Signed 18.2 | — | EXXM.1 |
#XPD-POST-COMPANYPOST_COMPANY | Numeric 4 | — | EX20.2, EXXM.1 |
#XPD-ACCT-UNITACCT_UNIT | Alpha 15 | — | EX20.2, EXXM.1 |
#XPD-ACCOUNTACCOUNT | Numeric 6 | — | EX20.2, EXXM.1 |
#XPD-SUB-ACCTSUB_ACCT | Numeric 4 | — | EX20.2, EXXM.1 |
#XPD-BILL-ACCOUNTBILL_ACCOUNT | Numeric 6 | — | EX20.2, EXXM.1 |
#XPD-BILL-SUB-ACCTBILL_SUB_ACCT | Numeric 4 | — | EX20.2, EXXM.1 |
#XPD-ACTIVITYACTIVITY | Alpha 15 | — | EX20.2, EXXM.1 |
#XPD-ACCT-CATACCT_CAT | Alpha 5 | — | EX20.2, EXXM.1 |
#XPD-TAX-CODE1TAX_CODE1 | Alpha 10 | — | EX20.2, EXXM.1 |
#XPD-TAX-AMT1TAX_AMT1 | Signed 18.2 | — | EX20.2, EX542, EXXM.1 |
#XPD-REIM-TAX-AMT1REIM_TAX_AMT1 | Signed 18.2 | — | EX175, EX20.2, EXXM.1 |
#XPD-TAX-CODE2TAX_CODE2 | Alpha 10 | — | EX20.2, EXXM.1 |
#XPD-TAX-AMT2TAX_AMT2 | Signed 18.2 | — | EX20.2, EX542, EXXM.1 |
#XPD-REIM-TAX-AMT2REIM_TAX_AMT2 | Signed 18.2 | — | EX175, EX20.2, EXXM.1 |
#XPD-RECEIPTRECEIPT | Numeric 4 | —
| EX20.2, EXXM.1 |
#XPD-PAY-CODEPAY_CODE | Alpha 4 | — | EX20.2, EXXM.1 |
#XPD-ERROR-TEXTERROR_TEXT | Alpha 70 | — | EX175, EX20.2, EX542, EXXM.1 |
#XPD-GLT-OBJ-IDGLT_OBJ_ID | Numeric 12 | — | EXXM.1 |
#XPD-ATN-OBJ-IDATN_OBJ_ID | Numeric 12 | — | EXXM.1 |
#XPD-BILLABLEBILLABLE | Alpha 1 | —
| EX20.2, EXXM.1 |
Indexes (4)
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 |
|---|---|---|---|---|
XPDSET1 |
| Primary | EX175, EX20.2, EX542 | |
XPDSET2 |
| KeyChange | EX175, EX542 | |
XPDSET3 |
| EX175 | ||
XPDSET4 |
| EX20.2 |