EPBATCH – No description in the Lawson data dictionary

System
Billing (BL)
Prefix
EPB
Primary key
COMPANY, EP-BATCH-ID
Fields
35
Updated by
1 program
Referenced by
0 programs

EPBATCH is a Lawson Billing table (prefix EPB); no description in the lawson data dictionary. It is indexed by COMPANY, EP-BATCH-ID (EPBSET1). It is updated by WH20.7. The table has 35 fields, 1 index and 0 documented relations.

About EPBATCH

No description in the Lawson data dictionary.

Fields (35)

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

Field / columnTypeDescription & valuesUpdated by
EPB-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.
EPB-EP-BATCH-ID PK
EP_BATCH_ID
Numeric 12
EPB-OPR-CODE
OPR_CODE
Alpha 10 (Lower Case)This field contains the operator code. This is the user ID of the person who last maintained this record.
EPB-DATE
DATE
Numeric 8 (yyyymmdd)This field displays the system date when this was created.
EPB-TIME
TIME
Numeric 8This field is updated automatically to indicate the time that the GL entry was created. It is system-maintained.
EPB-RNBR-STTL
RNBR_STTL
Numeric 5WH20.7
EPB-RSTTL-BASE
RSTTL_BASE
Signed 18.2WH20.7
EPB-RSTTL-CURR
RSTTL_CURR
Signed 18.2WH20.7
EPB-ANBR-STTL
ANBR_STTL
Numeric 5
EPB-ASTTL-BASE
ASTTL_BASE
Signed 18.2
EPB-ASTTL-CURR
ASTTL_CURR
Signed 18.2
EPB-RNBR-AUTH
RNBR_AUTH
Numeric 5WH20.7
EPB-RAUTH-BASE
RAUTH_BASE
Signed 18.2WH20.7
EPB-RAUTH-CURR
RAUTH_CURR
Signed 18.2WH20.7
EPB-ANBR-AUTH
ANBR_AUTH
Numeric 5
EPB-AAUTH-BASE
AAUTH_BASE
Signed 18.2
EPB-AAUTH-CURR
AAUTH_CURR
Signed 18.2
EPB-RNBR-VOID
RNBR_VOID
Numeric 5
EPB-RVOID-BASE
RVOID_BASE
Signed 18.2
EPB-RVOID-CURR
RVOID_CURR
Signed 18.2
EPB-ANBR-VOID
ANBR_VOID
Numeric 5
EPB-AVOID-BASE
AVOID_BASE
Signed 18.2
EPB-AVOID-CURR
AVOID_CURR
Signed 18.2
EPB-RNBR-RETN
RNBR_RETN
Numeric 5WH20.7
EPB-RRETN-BASE
RRETN_BASE
Signed 18.2WH20.7
EPB-RRETN-CURR
RRETN_CURR
Signed 18.2WH20.7
EPB-ANBR-RETN
ANBR_RETN
Numeric 5
EPB-ARETN-BASE
ARETN_BASE
Signed 18.2
EPB-ARETN-CURR
ARETN_CURR
Signed 18.2
EPB-RNBR-ADJ
RNBR_ADJ
Numeric 5
EPB-RADJ-BASE
RADJ_BASE
Signed 18.2
EPB-RADJ-CURR
RADJ_CURR
Signed 18.2
EPB-ANBR-ADJ
ANBR_ADJ
Numeric 5
EPB-AADJ-BASE
AADJ_BASE
Signed 18.2
EPB-AADJ-CURR
AADJ_CURR
Signed 18.2

Indexes (1)

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

IndexKeysFlagsConditionUsed in
EPBSET1COMPANY, EP-BATCH-IDPrimaryWH20.7

Programs

Updated by (1)