EPTYPE – Electronic Payment Type

System
Billing (BL)
Prefix
ETY
Primary key
COMPANY, EP-TYPE
Fields
14
Updated by
4 programs
Referenced by
1 program

EPTYPE is the Electronic Payment Type table in Lawson Billing (prefix ETY). It is indexed by COMPANY, EP-TYPE (ETYSET1). It is updated by AR10.5, WF01.1, WH20.2 and WH20.7 and referenced by ARLL.1. The table has 14 fields, 1 index and 0 documented relations.

About EPTYPE

No description in the Lawson data dictionary.

Fields (14)

Column = COBOL field name without the ETY- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
ETY-COMPANY PK
COMPANY
Numeric 4Identifies 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.AR10.5, WF01.1, WH20.2, WH20.7
ETY-EP-TYPE PK
EP_TYPE
Alpha 5AR10.5, WF01.1, WH20.2, WH20.7
ETY-EP-DESC
EP_DESC
Alpha 30AR10.5, WF01.1, WH20.2, WH20.7
ETY-EP-ACTIVE-FLAG
EP_ACTIVE_FLAG
Alpha 1AR10.5, WF01.1, WH20.2, WH20.7
ETY-REQ-EP-AUTH
REQ_EP_AUTH
Alpha 1AR10.5, WF01.1, WH20.2, WH20.7
ETY-PEND-AUTH-HLD
PEND_AUTH_HLD
Alpha 4AR10.5, WF01.1, WH20.2, WH20.7
ETY-FAIL-AUTH-HLD
FAIL_AUTH_HLD
Alpha 4AR10.5, WF01.1, WH20.2, WH20.7
ETY-REQ-EP-STTL
REQ_EP_STTL
Alpha 1AR10.5, WF01.1, WH20.2, WH20.7
ETY-PEND-STTL-HLD
PEND_STTL_HLD
Alpha 4AR10.5, WF01.1, WH20.2, WH20.7
ETY-FAIL-STTL-HLD
FAIL_STTL_HLD
Alpha 4AR10.5, WF01.1, WH20.2, WH20.7
ETY-FAIL-STTLA-HLD
FAIL_STTLA_HLD
Alpha 4AR10.5, WF01.1, WH20.2, WH20.7
ETY-AR-CODE
AR_CODE
Alpha 4AR10.5, WF01.1, WH20.2, WH20.7
ETY-EP-MARGIN-MIN
EP_MARGIN_MIN
Signed 7.2AR10.5, WF01.1, WH20.2, WH20.7
ETY-EP-MARGIN-PCT
EP_MARGIN_PCT
Percent 8.5 (Percent)AR10.5, WF01.1, WH20.2, WH20.7

Indexes (1)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
ETYSET1COMPANY, EP-TYPEPrimaryAR10.5, ARLL.1, WF01.1, WH20.2, WH20.7

Programs

Updated by (4)

Referenced by (1)