CUSTEP – No description in the Lawson data dictionary

System
Billing (BL)
Prefix
CEP
Primary key
COMPANY, CUSTOMER, EP-TYPE, EP-ACCOUNT
Fields
8
Updated by
101 programs
Referenced by
0 programs

CUSTEP is a Lawson Billing table (prefix CEP); no description in the lawson data dictionary. It is indexed by COMPANY, CUSTOMER, EP-TYPE, EP-ACCOUNT (CEPSET1). It is updated by AC56.1, AC560, AR08.1, AR09.1, AR10.1, AR10.5, AR210, AR301 and 93 more. The table has 8 fields, 1 index and 0 documented relations.

About CUSTEP

No description in the Lawson data dictionary.

Fields (8)

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

Field / columnTypeDescription & valuesUpdated by
CEP-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.AC56.1, AC560, AR08.1, AR09.1, AR10.1, AR10.5, AR210, AR301 +52 more (list truncated in source)
CEP-CUSTOMER PK
CUSTOMER
Alpha 9 (Right Justified)This field contains the number that represents a customer.AC56.1, AC560, AR08.1, AR09.1, AR10.1, AR10.5, AR210, AR301 +52 more (list truncated in source)
CEP-EP-TYPE PK
EP_TYPE
Alpha 5AC56.1, AC560, AR08.1, AR09.1, AR10.1, AR10.5, AR210, AR301 +52 more (list truncated in source)
CEP-EP-ACCOUNT PK
EP_ACCOUNT
Alpha 32AC56.1, AC560, AR08.1, AR09.1, AR10.1, AR10.5, AR210, AR301 +52 more (list truncated in source)
CEP-EP-EXP-DATE
EP_EXP_DATE
Numeric 8 (yyyymmdd)AC56.1, AC560, AR08.1, AR09.1, AR10.1, AR10.5, AR210, AR301 +52 more (list truncated in source)
CEP-EP-STATUS
EP_STATUS
Alpha 1
  • A Active
  • I Inactive
AC56.1, AC560, AR08.1, AR09.1, AR10.1, AR10.5, AR210, AR301 +52 more (list truncated in source)
CEP-DEFAULT-PMT
DEFAULT_PMT
Alpha 1AC56.1, AC560, AR08.1, AR09.1, AR10.1, AR10.5, AR210, AR301 +52 more (list truncated in source)
CEP-EP-CSC
EP_CSC
Alpha 4

Indexes (1)

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

IndexKeysFlagsConditionUsed in
CEPSET1COMPANY, CUSTOMER, EP-TYPE, EP-ACCOUNTPrimaryAC56.1, AC560, AR08.1, AR09.1, AR10.1, AR10.5, AR210, AR301 +22 more (list truncated in source)

Programs

Updated by (101)