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.
| 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-STATUSSTATUS | Numeric 1 | —
| EX175, EX20.2, EX542, EXXM.1 |
XPD-SENT-DATESENT_DATE | Numeric 8 (yyyymmdd) | — | EX175, EX20.2, EX542, EXXM.1 |
XPD-PAYMETHODPAYMETHOD | 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 marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
XPDSET1 | COMPANY, EMPLOYEE, DOCUMENT, SEQ | Primary | EX175, EX20.2, EX542 | |
XPDSET2 | STATUS, COMPANY, EMPLOYEE, DOCUMENT, SEQ | KeyChange | EX175, EX542 | |
XPDSET3 | PAYMETHOD, COMPANY, EMPLOYEE, DOCUMENT, SEQ | EX175 | ||
XPDSET4 | DOCUMENT, COMPANY, EMPLOYEE, SEQ | EX20.2 |