CBCREDRISK – Credit Risk

System
Cash Ledger (CB)
Prefix
CCR
Primary key
BANK-ENTITY, CREDIT-LINE
Fields
9
Updated by
1 program
Referenced by
5 programs

CBCREDRISK is the Credit Risk table in Lawson Cash Ledger (prefix CCR). It is indexed by BANK-ENTITY, CREDIT-LINE (CCRSET1). It is updated by CB01.1 and referenced by AC110, CB00.1, CB00.2, CB00.3 and CB07.1. The table has 9 fields, 1 index and 0 documented relations.

About CBCREDRISK

The Credit Risk file contains credit line records for a bank. Credit lines are used for remitting bills of exchange at a discount by Lawson Accounts Receivable system companies that perform risk processing.

Fields (9)

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

Field / columnTypeDescription & valuesUpdated by
CCR-BANK-ENTITY PK
BANK_ENTITY
Alpha 15The bank identification number. Represents a bank location. Must be a valid record in the Bank file.CB01.1
CCR-CREDIT-LINE PK
CREDIT_LINE
Alpha 4A user-defined code representing a unique line of credit with the bank location.CB01.1
CCR-ACTIVE-STATUS
ACTIVE_STATUS
Alpha 1The status of the credit line. No posting can be done for a credit line with an Inactive status. Valid values are:
  • A Active.
  • I Inactive.
CB01.1
CCR-CREDIT-LMT
CREDIT_LMT
Signed 18.2The amount of available credit for the credit line.CB01.1
CCR-ACTUAL
ACTUAL
Signed 18.2The current amount of outstanding credit for the credit line.CB01.1
CCR-CURRENCY-CODE
CURRENCY_CODE
Alpha 5The currency of the credit line. Must be a valid record in the Currency Code file.CB01.1
CCR-DUE-FROM
DUE_FROM
Numeric 3The beginning day of a range of bill of exchange due days for the credit line. Used to select bills of exchange for discounted remittance.CB01.1
CCR-DUE-TO
DUE_TO
Numeric 3The ending day of a range of bill of exchange due days for the credit line. Used to select bills of exchange for discounted remittance.CB01.1
CCR-MARGIN-DAYS
MARGIN_DAYS
Numeric 3The number of days to be added to the bill of exchange due date before a bill of exchange is considered cashed by the bank and no longer a credit risk. If left blank, no margin days are used.CB01.1

Indexes (1)

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

IndexKeysFlagsConditionUsed in
CCRSET1BANK-ENTITY, CREDIT-LINEPrimaryAC110, CB00.1, CB00.2, CB00.3, CB01.1, CB07.1

Programs

Updated by (1)

Referenced by (5)