EPTRANS – No description in the Lawson data dictionary

System
Billing (BL)
Prefix
EPT
Primary key
EP-TRANS-ID, COMPANY
Fields
26
Updated by
1 program
Referenced by
99 programs

EPTRANS is a Lawson Billing table (prefix EPT); no description in the lawson data dictionary. It is indexed by EP-TRANS-ID, COMPANY (EPTSET1); alternate indexes: EPTSET2, EPTSET3, EPTSET4, EPTSET5, EPTSET6 and EPTSET7. It is updated by WH20.7 and referenced by AC56.1, AC560, AR08.1, AR09.1, AR10.1, AR10.5, AR210, AR301 and 91 more. The table has 26 fields, 7 indexes and 0 documented relations.

About EPTRANS

No description in the Lawson data dictionary.

Fields (26)

Column = COBOL field name without the EPT- 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
#EPT-EP-TRANS-ID PK
EP_TRANS_ID		Numeric 12—WH20.7
#EPT-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.WH20.7
#EPT-ORDER-NBR SET3
ORDER_NBR		Numeric 8This field contains the order number.WH20.7
#EPT-CUSTOMER SET2
CUSTOMER		Alpha 9 (Right Justified)This field contains the number that represents a customer.WH20.7
#EPT-INVC-PREFIX SET4
INVC_PREFIX		Alpha 2This field contains the invoice prefix that is assigned from either the company or process level, depending on the invoice-level option chosen.WH20.7
#EPT-INVC-NUMBER SET4
INVC_NUMBER		Numeric 8This field contains the invoice number assigned by the system. Invoice numbers are assigned at the company or process level, depending on an invoice-level option on the company file.WH20.7
#EPT-EP-TYPE SET5
EP_TYPE		Alpha 5—WH20.7
#EPT-EP-TYPE-DESC
EP_TYPE_DESC		Alpha 30—WH20.7
#EPT-EP-ACCOUNT
EP_ACCOUNT		Alpha 32—WH20.7
#EPT-EP-TRANS-STS
EP_TRANS_STS		Numeric 1—
  • 1 New Transaction
  • 2 Authorizaton Pending
  • 3 Authorization Failed
  • 4 Authorization Granted
  • 6 Settlement Pending
  • 7 Settlement Failed
  • 8 Settlement Failed-Auth Failed
  • 9 Settlement Successful
WH20.7
#EPT-EP-ERROR-CODE
EP_ERROR_CODE		Alpha 10—WH20.7
#EPT-TRANS-TTL-CURR
TRANS_TTL_CURR		Signed 18.2—WH20.7
#EPT-TRANS-TTL-BASE
TRANS_TTL_BASE		Signed 18.2—WH20.7
#EPT-CURRENCY-CODE
CURRENCY_CODE		Alpha 5This field contains the company base currency code established in Company (GL10.1 ).WH20.7
#EPT-ORDER-REF-NBR
ORDER_REF_NBR		Numeric 8This field contains the order reference number. This number can be filled with extra order number information.—
#EPT-REF-NBR-FLAG
REF_NBR_FLAG		Alpha 1This field contains a flag to indicate whether the Order reference number is being used. This could be used to flag whether we use the order-ref-nbr in place of our order number.—
#EPT-EP-AUTH-EXPDTE
EP_AUTH_EXPDTE		Numeric 8 (yyyymmdd)—WH20.7
#EPT-EP-AUTH-DATE
EP_AUTH_DATE		Numeric 8 (yyyymmdd)—WH20.7
#EPT-EP-AUTH-BATCH
EP_AUTH_BATCH		Numeric 12—WH20.7
#EPT-EP-AVS-RET-CD
EP_AVS_RET_CD		Alpha 1—WH20.7
#EPT-EP-AUTH-AMT
EP_AUTH_AMT		Signed 18.2—WH20.7
#EPT-EP-AUTH-CODE
EP_AUTH_CODE		Alpha 20—WH20.7
#EPT-EP-STTL-AMT
EP_STTL_AMT		Signed 18.2—WH20.7
#EPT-EP-STTL-FEE
EP_STTL_FEE		Signed 18.2—WH20.7
#EPT-EP-STTL-DATE SET7
EP_STTL_DATE		Numeric 8 (yyyymmdd)—WH20.7
#EPT-EP-STTL-BATCH
EP_STTL_BATCH		Numeric 12—WH20.7

Indexes (7)

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
EPTSET1
  1. EP-TRANS-ID
  2. COMPANY
PrimaryAC56.1, AC560, AR08.1, AR09.1, AR10.1, AR10.5, AR210, AR301 +22 more (list truncated in source)
EPTSET2
  1. COMPANY
  2. CUSTOMER
  3. EP-TRANS-ID
—
EPTSET3
  1. COMPANY
  2. ORDER-NBR
  3. EP-TRANS-ID
—
EPTSET4
  1. COMPANY
  2. INVC-PREFIX
  3. INVC-NUMBER
  4. EP-TRANS-ID
—
EPTSET5
  1. COMPANY
  2. EP-TYPE
  3. EP-TRANS-ID
—
EPTSET6
  1. COMPANY
  2. EP-TRANS-ID
—
EPTSET7
  1. COMPANY
  2. EP-STTL-DATE
  3. EP-TRANS-ID
—

Programs

Updated by (1)

Referenced by (99)