EEEXPHDR – No description in the Lawson data dictionary

System
Accounts Payable (AP)
Prefix
XPH
Primary key
COMPANY, EMPLOYEE, DOCUMENT
Fields
43
Updated by
5 programs
Referenced by
0 programs

EEEXPHDR is a Lawson Accounts Payable table (prefix XPH); no description in the lawson data dictionary. It is indexed by COMPANY, EMPLOYEE, DOCUMENT (XPHSET1); alternate indexes: XPHSET2 and XPHSET3. It is updated by EX175, EX20.1, EX542, EX545 and EXXM.1. The table has 43 fields, 3 indexes and 0 documented relations.

About EEEXPHDR

No description in the Lawson data dictionary.

Fields (43)

Column = COBOL field name without the XPH- 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 / columnTypeDescription & valuesUpdated by
#XPH-COMPANY PK
COMPANY		Numeric 4—EX20.1, EXXM.1
#XPH-EMPLOYEE PK
EMPLOYEE		Numeric 9—EX20.1, EXXM.1
#XPH-DOCUMENT PK
DOCUMENT		Alpha 22—EX20.1, EXXM.1
#XPH-VENDOR
VENDOR		Alpha 9 (Right Justified)—EX20.1, EXXM.1
#XPH-AP-COMPANY
AP_COMPANY		Numeric 4—EX20.1, EXXM.1
#XPH-DEF-ACCT-UNIT
DEF_ACCT_UNIT		Alpha 15—EX20.1, EXXM.1
#XPH-ACCOUNT
ACCOUNT		Numeric 6—EXXM.1
#XPH-SUB-ACCT
SUB_ACCT		Numeric 4—EXXM.1
#XPH-BILLABLE
BILLABLE		Alpha 1—
  • Y Yes
  • N No
EXXM.1
#XPH-ADVANCE-NBR
ADVANCE_NBR		Alpha 22—EXXM.1
#XPH-CURRENCY-CODE
CURRENCY_CODE		Alpha 5—EX20.1, EXXM.1
#XPH-APPROVAL-CODE
APPROVAL_CODE		Alpha 3—EXXM.1
#XPH-DESC
DESC		Alpha 30 (Lower Case)—EX20.1, EXXM.1
#XPH-BEG-DATE
BEG_DATE		Numeric 8 (yyyymmdd)—EX20.1, EXXM.1
#XPH-END-DATE
END_DATE		Numeric 8 (yyyymmdd)—EX20.1, EXXM.1
#XPH-FIRSTNAME
FIRSTNAME		Alpha 30 (Lower Case)—EX20.1, EXXM.1
#XPH-LASTNAME
LASTNAME		Alpha 30 (Lower Case)—EX20.1, EXXM.1
#XPH-EE-STATUS SET2
EE_STATUS		Alpha 1—
  • 1 Not Processed
  • 2 In Error
  • 9 Sent for Reimbursement
EX175, EX20.1, EX542, EX545, EXXM.1
#XPH-SENT-DATE
SENT_DATE		Numeric 8 (yyyymmdd)—EX175, EX20.1, EX542, EX545, EXXM.1
#XPH-TRAN-AMT
TRAN_AMT		Signed 18.2—EX20.1, EXXM.1
#XPH-REIM-AMT
REIM_AMT		Signed 18.2—EX20.1, EXXM.1
#XPH-REIM-CURRENCY
REIM_CURRENCY		Alpha 5—EX20.1, EXXM.1
#XPH-ACTIVITY
ACTIVITY		Alpha 15—EX20.1, EXXM.1
#XPH-ACCT-CATEGORY
ACCT_CATEGORY		Alpha 5—EX20.1, EXXM.1
#XPH-RESOURCE-TYPE
RESOURCE_TYPE		Numeric 4—
  • 0010 Employee
  • 0020 Sub Contractor
EX20.1, EXXM.1
#XPH-PROC-LEVEL
PROC_LEVEL		Alpha 5—EX20.1, EXXM.1
#XPH-PAY-VENDOR
PAY_VENDOR		Alpha 9 (Right Justified)—EX20.1, EXXM.1
#XPH-REIM-SYSTEM
REIM_SYSTEM		Numeric 4—
  • 0010 Accounts Payable
  • 0020 Payroll
  • 0030 Non Lawson
EX20.1, EXXM.1
#XPH-HR-GROUP
HR_GROUP		Alpha 5—EXXM.1
#XPH-REC-TYPE SET2
REC_TYPE		Numeric 4—
  • 0010 Expense
  • 0020 Advance
  • 0030 Payback
EX20.1, EXXM.1
#XPH-ATN-OBJ-ID
ATN_OBJ_ID		Numeric 12—EXXM.1
#XPH-GLT-OBJ-ID
GLT_OBJ_ID		Numeric 12—EXXM.1
#XPH-PAY-CODE
PAY_CODE		Alpha 4—EX20.1, EXXM.1
#XPH-DOCUMENT-NUM
DOCUMENT_NUM		Numeric 12—EX20.1, EXXM.1
#XPH-REMIT-TO-CODE
REMIT_TO_CODE		Alpha 4—EX20.1, EXXM.1
#XPH-PAYMENT-REF
PAYMENT_REF		Alpha 15—EX20.1, EXXM.1
#XPH-CR-CARD-NUMBER
CR_CARD_NUMBER		Alpha 16—EXXM.1
#XPH-BOD-ACCT-ENT
BOD_ACCT_ENT		Alpha 22 (Lower Case)——
#XPH-BOD-LOCATION
BOD_LOCATION		Alpha 22 (Lower Case)——
#XPH-BOD-DOC-ID
BOD_DOC_ID		Alpha 100 (Lower Case)——
#XPH-BOD-SOR
BOD_SOR		Alpha 1——
#XPH-BOD-REVISION
BOD_REVISION		Alpha 22 (Lower Case)——
#XPH-BOD-VAR-ID
BOD_VAR_ID		Alpha 22 (Lower Case)——

Indexes (3)

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.

IndexKeysFlagsConditionUsed in
XPHSET1
  1. COMPANY
  2. EMPLOYEE
  3. DOCUMENT
PrimaryEX175, EX20.1, EX542, EX545
XPHSET2
  1. REC-TYPE
  2. EE-STATUS
  3. COMPANY
  4. EMPLOYEE
  5. DOCUMENT
KeyChangeEX545
XPHSET3
  1. DOCUMENT
  2. COMPANY
  3. EMPLOYEE
EX20.1, EXXM.1

Programs

Updated by (5)