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 / column | Type | Description & values | Updated by |
|---|---|---|---|
CEP-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. | AC56.1, AC560, AR08.1, AR09.1, AR10.1, AR10.5, AR210, AR301 +52 more (list truncated in source) |
CEP-CUSTOMER PKCUSTOMER | 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 PKEP_TYPE | Alpha 5 | — | AC56.1, AC560, AR08.1, AR09.1, AR10.1, AR10.5, AR210, AR301 +52 more (list truncated in source) |
CEP-EP-ACCOUNT PKEP_ACCOUNT | Alpha 32 | — | AC56.1, AC560, AR08.1, AR09.1, AR10.1, AR10.5, AR210, AR301 +52 more (list truncated in source) |
CEP-EP-EXP-DATEEP_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-STATUSEP_STATUS | Alpha 1 | —
| AC56.1, AC560, AR08.1, AR09.1, AR10.1, AR10.5, AR210, AR301 +52 more (list truncated in source) |
CEP-DEFAULT-PMTDEFAULT_PMT | Alpha 1 | — | AC56.1, AC560, AR08.1, AR09.1, AR10.1, AR10.5, AR210, AR301 +52 more (list truncated in source) |
CEP-EP-CSCEP_CSC | Alpha 4 | — | — |
Indexes (1)
Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
CEPSET1 | COMPANY, CUSTOMER, EP-TYPE, EP-ACCOUNT | Primary | AC56.1, AC560, AR08.1, AR09.1, AR10.1, AR10.5, AR210, AR301 +22 more (list truncated in source) |
Programs
Updated by (101)
- AC56.1 Setup Interface Adjustment
- AC560 Setup Interface
- AR08.1 Customer Defaults
- AR09.1 Customer Group Address
- AR10.1 Customer
- AR10.5 Customer Electronic Payments
- AR210 Customer Listing
- AR301 Customer Purge
- AR501 Customer Conversion
- AR550 Customer Interface
- BR00.1 Activity Billing
- BR00.2 Billing Detail
- BR02.3 Retainer Invoice Entry
- BR10.1 Contract Parameters
- BR10.9 Product Contract Parameters
- BR11.1 Customer
- BR120 Invoice Calculation
- BR121 Invoice Print and Interface
- BR122 Online batch invoice process
- BR123 Product Invoice Cancel
- BR140 Billing and Revenue Backout
- BR151 Product Invoicing
- BR152 Maintenance Invoicing
- BR155 Maintenance Schedule Copy
- BR156 Maintenance Quote
- BR16.1 Service Location
- BR16.2 Customer Maintenance Renew Date
- BR17.1 Bill To Group
- BR180 Location Vertex Geocode Update
- BR19.1 Single Invoice Calculation
- BR20.1 Invoice Edit Contract
- BR20.2 Invoice Edit Line
- BR20.3 Invoice Edit Activity
- BR20.4 Invoice Edit Activity and Account Category
- BR20.5 Invoice Edit Transaction
- BR20.7 Invoice Header
- BR21.2 Filter
- BR210 Contract Listing
- BR211 Activity Customer Listing
- BR216 Service Location Listing
- BR217 Bill To Group Listing
- BR220 Invoice Audit Listing
- BR251 Product Contract Listing
- BR252 Maintenance Schedule Listing
- BR253 Deferred Revenue Listing
- BR400 Invoice History
- BR420 Billing Invoice Report
- BR45.1 Invoice Control
- BR450 Activity Aging
- BR46.1 Bill in Advance
- BR46.2 Transfer Invoice Transaction
- BR46.4 Split Transfer
- BR49.1 Invoice Adjustment Maintenance
- BR51.1 Product Contract
- BR51.2 Product Cost of Goods Sold
- BR52.1 Maintenance Schedule
- BR52.2 New Maintenance Schedule
- BR521 Billing Import
- BR53.1 Product Deferred Revenue Schedule
- BR55.2 Filter
- BR70.1 Product Contract Interface Adjustment
- BR70.2 Product Interface Cost of Goods Sold
- BR91.1 Contract By Customer Inquiry
- BRIP.1 Invoice Print Program
- CB06.2 Bank Statement Detail Entry
- IC02.1 Location
- TX140 Vertex Geocode Update
- TX40.1 Tax Inquiry for Vertex
- WH110 Batch Allocation
- WH120 Route Creation
- WH130 Pick List Print
- WH132 Batch Feedback
- WH190 Shipment Release
- WH20.1 Inventoried Allocation
- WH20.2 Nonstock and Special Allocation
- WH20.7 Substitute Location
- WH21.2 Stops
- WH224 Packing List Print
- WH226 Items on Backorder Report
- WH30.1 Picking Feedback by Document
- WH30.2 Picking Feedback by Shipment
- WH30.3 Picking by Batch
- WH30.4 Bin Sequence Picking Feedback
- WH31.1 Packing Feedback by Document
- WH31.2 Packing Feedback by Shipment
- WH31.3 Packing by Batch
- WH31.4 Bin Sequence Packing Feedback
- WH32.1 Shipping Feedback by Document
- WH32.2 Shipping Feedback by Shipment
- WH32.3 Shipping by Batch
- WH32.4 Bin Sequence Shipping Feedback
- WH32.5 Shipping Line Feedback
- WH33.5 Additional Shipment Information
- WH34.1 Component Bins
- WH34.2 Component Lots
- WH34.3 Component Serials
- WH34.4 Component UOMs
- WH40.1 Bill of Lading
- WH40.2 Bill of Lading Feedback
- WH520 Batch Feedback Interface
- WH830 Shipment Load Program