C2IPAYMENT – No description in the Lawson data dictionary

System
C2 (C2)
Prefix
C2P
Primary key
COMPANY, TRANS-NBR, CUSTOMER, SEQ-NBR
Fields
17
Updated by
0 programs
Referenced by
0 programs

C2IPAYMENT is a Lawson C2 table (prefix C2P); no description in the lawson data dictionary. It is indexed by COMPANY, TRANS-NBR, CUSTOMER, SEQ-NBR (C2PSET1); alternate indexes: C2PSET2. The table has 17 fields, 2 indexes and 0 documented relations.

About C2IPAYMENT

No description in the Lawson data dictionary.

Fields (17)

Column = COBOL field name without the C2P- 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
#C2P-COMPANY PK
COMPANY		Numeric 4——
#C2P-TRANS-NBR PK
TRANS_NBR		Alpha 10 (Right Justified)——
#C2P-CUSTOMER PK
CUSTOMER		Alpha 9 (Right Justified)——
#C2P-SEQ-NBR PK
SEQ_NBR		Numeric 4——
#C2P-REFERENCE
REFERENCE		Alpha 25——
#C2P-POSTING-DATE
POSTING_DATE		Numeric 8 (yyyymmdd)——
#C2P-SENDER
SENDER		Numeric 10——
#C2P-NAME
NAME		Alpha 30 (Lower Case)——
#C2P-ADDR1
ADDR1		Alpha 30 (Lower Case)——
#C2P-ADDR2
ADDR2		Alpha 30 (Lower Case)——
#C2P-POSTAL-CODE
POSTAL_CODE		Alpha 10 (Lower Case)——
#C2P-ADDR5
ADDR5		Alpha 18 (Lower Case)——
#C2P-INFO-STRING
INFO_STRING		Alpha 50——
#C2P-CASH-CODE
CASH_CODE		Alpha 4——
#C2P-CORP-ID-NBR
CORP_ID_NBR		Numeric 12——
#C2P-ELEC-TRANS-ID
ELEC_TRANS_ID		Alpha 18——
#C2P-BATCH-NBR SET2
BATCH_NBR		Numeric 6——

Indexes (2)

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
C2PSET1
  1. COMPANY
  2. TRANS-NBR
  3. CUSTOMER
  4. SEQ-NBR
Primary—
C2PSET2
  1. COMPANY
  2. BATCH-NBR
  3. SEQ-NBR
  4. TRANS-NBR
  5. CUSTOMER
CB191

Programs

No Lawson programs are documented as updating or referencing this table.