CBFTTRANS – EFT Deposit Extract Data

System
Cash Ledger (CB)
Prefix
CFT
Primary key
CASH-CODE, BANK-INST-CODE, TRANS-IDENT
Fields
33
Updated by
8 programs
Referenced by
5 programs

CBFTTRANS is the EFT Deposit Extract Data table in Lawson Cash Ledger (prefix CFT). It is indexed by CASH-CODE, BANK-INST-CODE, TRANS-IDENT (CFTSET1); alternate indexes: CFTSET2, CFTSET3, CFTSET4 and CFTSET5. It is related 1:M to CBDISTRIB. It is updated by CB145, CB150, CB180, CB300, CB45.1, CB543, CB80.1 and CB85.1 and referenced by CB175, CB245, CB44.1, CB46.1 and CB544. The table has 33 fields, 5 indexes and 1 documented relation.

About CBFTTRANS

No description in the Lawson data dictionary.

Fields (33)

Column = COBOL field name without the CFT- 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
#CFT-CASH-CODE PK
CASH_CODE		Alpha 4A cash code represents a bank account. More than one company can use the same cash code. The cash code must be linked to a bank in the Lawson Cash Ledger system.CB45.1, CB543
#CFT-BANK-INST-CODE PK
BANK_INST_CODE		Alpha 3A transaction code represents a type of cash payment, bill of exchange payment, or bank service transaction.CB45.1, CB543
#CFT-TRANS-IDENT PK
TRANS_IDENT		Numeric 10A unique system-generated identification value assigned to the transaction to make this record unique.CB180, CB45.1, CB543
#CFT-COMPANY SET4
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.CB45.1, CB543
#CFT-TRANS-NBR SET3 SET5
TRANS_NBR		Alpha 10 (Right Justified)A unique, user-defined value used to identify the transaction.CB145, CB180
#CFT-REFERENCE-NO SET2 SET3 SET5
REFERENCE_NO		Alpha 10 (Right Justified)A unique, user-defined value used to identify the transaction.CB45.1, CB543
#CFT-REC-STATUS SET5
REC_STATUS		Numeric 1The record status.
  • 0 Unreleased
  • 1 Released
  • 2 EFT Created
  • 3 Void
  • 4 Stop Payment
  • 5 Tape Reject (Not Reinstated)
  • 6 Tape Reject (Reinstated)
CB145, CB150, CB180, CB45.1, CB543, CB85.1
#CFT-TRANS-DATE
TRANS_DATE		Numeric 8 (yyyymmdd)This field displays the system date when this was created.CB45.1, CB543
#CFT-EFT-DATE
EFT_DATE		Numeric 8 (yyyymmdd)This field displays the system date when this was created.CB145
#CFT-RECEIPT-AMOUNT
RECEIPT_AMOUNT		Signed 18.2—CB45.1, CB543
#CFT-BANK-ND
BANK_ND		Numeric 1The number of decimals assigned to a particular account as determined by the account currency.CB45.1, CB543
#CFT-BASE-RECPT-AMT
BASE_RECPT_AMT		Signed 18.2—CB45.1, CB543
#CFT-BASE-ND
BASE_ND		Numeric 1The number of decimals assigned to a particular account as determined by the account currency.CB45.1, CB543
#CFT-BASE-EFT-AMT
BASE_EFT_AMT		Signed 18.2—CB145
#CFT-EXCHANGE-RATE
EXCHANGE_RATE		Signed 14.7The currency rate.CB45.1, CB543
#CFT-CURRENCY-CODE SET4
CURRENCY_CODE		Alpha 5This field contains the bank account currency defined for the cash code.CB45.1, CB543
#CFT-DESCRIPTION
DESCRIPTION		Alpha 30 (Lower Case)This field displays the description.CB45.1, CB543
#CFT-CUST-NAME
CUST_NAME		Alpha 30—CB45.1, CB543
#CFT-CUST-BANK
CUST_BANK		Alpha 15Represents a bank institution location.CB45.1, CB543
#CFT-CUST-ACCOUNT
CUST_ACCOUNT		Alpha 35The bank-assigned account number identification to be used for the cash code.CB45.1, CB543
#CFT-VBANK-IDENT
VBANK_IDENT		Alpha 1" " = Standard Account Number
  • Y IBAN Account Number
CB45.1, CB543
#CFT-ACH-PRENOTE
ACH_PRENOTE		Alpha 1—
  • N Not Prenotified
  • P Penotified
  • A Accepted
CB145, CB150, CB45.1, CB543
#CFT-JRNL-BOOK-NBR
JRNL_BOOK_NBR		Alpha 12The journal book assigned to the transaction.CB45.1, CB543
#CFT-JBK-SEQ-NBR
JBK_SEQ_NBR		Numeric 10The journal book sequence number assigned to a journal book transaction when it is added or interfaced to the Lawson system. Used only when Auto Journal Book Seq Nbr is set to Yes in GL10.1 (Company).CB180, CB45.1, CB543
#CFT-USER-FIELD1
USER_FIELD1		Alpha 30This is the first user definable field. It can be used to capture any data that the user wants. The title of the field is setup in IC00.CB45.1, CB543
#CFT-USER-FIELD2
USER_FIELD2		Alpha 30This is the second user definable field. This field can be used to enter any data that the user wants to capture for this item. The title of the field is setup in IC00.CB45.1, CB543
#CFT-USER-FIELD3
USER_FIELD3		Alpha 30This is the first user definable field. It can be used to capture any data that the user wants. The title of the field is setup in IC00.CB45.1, CB543
#CFT-USER-FIELD4
USER_FIELD4		Alpha 30This is the second user definable field. This field can be used to enter any data that the user wants to capture for this item. The title of the field is setup in IC00.CB45.1, CB543
#CFT-TAX-FLAG
TAX_FLAG		Alpha 1" " = Not Interfaced
  • I Interfaced
CB45.1, CB543
#CFT-LAST-DIST-SEQ
LAST_DIST_SEQ		Numeric 4An automatically assigned sequence number.CB150, CB180, CB45.1, CB543
#CFT-SOURCE-CODE
SOURCE_CODE		Alpha 2A two character code assigned to a transaction to identify where the transaction was created.CB45.1, CB543
#CFT-TRANS-TYPE
TRANS_TYPE		Alpha 1Determines if amounts or units are processed in each transaction.
  • 2 Credit Card
  • 4 EFT Extract
CB45.1, CB543
#CFT-VOID-DATE
VOID_DATE		Numeric 8 (yyyymmdd)—CB85.1

Indexes (5)

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
CFTSET1
  1. CASH-CODE
  2. BANK-INST-CODE
  3. TRANS-IDENT
PrimaryCB175, CB180, CB245, CB300, CB543
CFTSET2
  1. CASH-CODE
  2. BANK-INST-CODE
  3. REFERENCE-NO
  4. TRANS-IDENT
CB150, CB44.1, CB45.1, CB46.1, CB544
CFTSET3
  1. CASH-CODE
  2. BANK-INST-CODE
  3. TRANS-NBR
  4. REFERENCE-NO
  5. TRANS-IDENT
KeyChangeCB180, CB80.1, CB85.1
CFTSET4
  1. COMPANY
  2. CASH-CODE
  3. BANK-INST-CODE
  4. CURRENCY-CODE
  5. TRANS-IDENT
KeyChange, SubsetWhere REC-STATUS = 1 Or ACH-PRENOTE = "N"CB145
CFTSET5
  1. REC-STATUS
  2. CASH-CODE
  3. BANK-INST-CODE
  4. TRANS-NBR
  5. REFERENCE-NO
  6. TRANS-IDENT
KeyChangeCB180

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
CBDISTRIBCBFTTRANS

One to many (1) — child tables

RelationTableRulesConditionField map
CbdistribCBDISTRIB
CFT-CASH-CODE→CBD-CASH-CODE
CFT-BANK-INST-CODE→CBD-BANK-INST-CODE
CFT-TRANS-IDENT→CBD-TRANS-IDENT
—→CBD-DIST-TYPE
—→CBD-SEQ-NBR

Programs

Updated by (8)

Referenced by (5)