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. PK = primary key (present in every index); SETn = leading/alternate key of that index.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
#EPB-COMPANY PKCOMPANY | Numeric 4 | Identifies 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 PKEP_BATCH_ID | Numeric 12 | — | — |
#EPB-OPR-CODEOPR_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-DATEDATE | Numeric 8 (yyyymmdd) | This field displays the system date when this was created. | — |
#EPB-TIMETIME | Numeric 8 | This field is updated automatically to indicate the time that the GL entry was created. It is system-maintained. | — |
#EPB-RNBR-STTLRNBR_STTL | Numeric 5 | — | WH20.7 |
#EPB-RSTTL-BASERSTTL_BASE | Signed 18.2 | — | WH20.7 |
#EPB-RSTTL-CURRRSTTL_CURR | Signed 18.2 | — | WH20.7 |
#EPB-ANBR-STTLANBR_STTL | Numeric 5 | — | — |
#EPB-ASTTL-BASEASTTL_BASE | Signed 18.2 | — | — |
#EPB-ASTTL-CURRASTTL_CURR | Signed 18.2 | — | — |
#EPB-RNBR-AUTHRNBR_AUTH | Numeric 5 | — | WH20.7 |
#EPB-RAUTH-BASERAUTH_BASE | Signed 18.2 | — | WH20.7 |
#EPB-RAUTH-CURRRAUTH_CURR | Signed 18.2 | — | WH20.7 |
#EPB-ANBR-AUTHANBR_AUTH | Numeric 5 | — | — |
#EPB-AAUTH-BASEAAUTH_BASE | Signed 18.2 | — | — |
#EPB-AAUTH-CURRAAUTH_CURR | Signed 18.2 | — | — |
#EPB-RNBR-VOIDRNBR_VOID | Numeric 5 | — | — |
#EPB-RVOID-BASERVOID_BASE | Signed 18.2 | — | — |
#EPB-RVOID-CURRRVOID_CURR | Signed 18.2 | — | — |
#EPB-ANBR-VOIDANBR_VOID | Numeric 5 | — | — |
#EPB-AVOID-BASEAVOID_BASE | Signed 18.2 | — | — |
#EPB-AVOID-CURRAVOID_CURR | Signed 18.2 | — | — |
#EPB-RNBR-RETNRNBR_RETN | Numeric 5 | — | WH20.7 |
#EPB-RRETN-BASERRETN_BASE | Signed 18.2 | — | WH20.7 |
#EPB-RRETN-CURRRRETN_CURR | Signed 18.2 | — | WH20.7 |
#EPB-ANBR-RETNANBR_RETN | Numeric 5 | — | — |
#EPB-ARETN-BASEARETN_BASE | Signed 18.2 | — | — |
#EPB-ARETN-CURRARETN_CURR | Signed 18.2 | — | — |
#EPB-RNBR-ADJRNBR_ADJ | Numeric 5 | — | — |
#EPB-RADJ-BASERADJ_BASE | Signed 18.2 | — | — |
#EPB-RADJ-CURRRADJ_CURR | Signed 18.2 | — | — |
#EPB-ANBR-ADJANBR_ADJ | Numeric 5 | — | — |
#EPB-AADJ-BASEAADJ_BASE | Signed 18.2 | — | — |
#EPB-AADJ-CURRAADJ_CURR | Signed 18.2 | — | — |
Indexes (1)
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 |
|---|---|---|---|---|
EPBSET1 |
| Primary | WH20.7 |
Programs
Updated by (1)
- WH20.7 Substitute Location