CBFTTRANS

EFT Deposit Extract Data

REFERENCED BY
CB175 CB245 CB44.1 CB46.1 CB544


UPDATED BY
CB145 CB150 CB180 CB300 CB45.1 CB543
CB85.1 CB80.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CFT-CASH-CODE
Element: Cash Code
Alpha 4
A 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
Element: Bank Inst Code
Alpha 3
A transaction code represents a type of cash payment, bill of exchange payment, or bank service transaction.
CB45.1 CB543
CFT-TRANS-IDENT
Element: Trans Ident
Numeric 10
A unique system-generated identification value assigned to the transaction to make this record unique.
CB180 CB45.1
CB543
CFT-COMPANY
Element: Company
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.
CB45.1 CB543
CFT-TRANS-NBR
Element: Trans Nbr
Alpha 10 (Right Justified)
A unique, user-defined value used to identify the transaction.
CB145 CB180
CFT-REFERENCE-NO
Element: Trans Nbr
Alpha 10 (Right Justified)
A unique, user-defined value used to identify the transaction.
CB45.1 CB543
CFT-REC-STATUS
Element: Rec Status
Numeric 1
The 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
Element: Date
Numeric 8 (yyyymmdd)
This field displays the system date when this was created.
CB45.1 CB543
CFT-EFT-DATE
Element: Date
Numeric 8 (yyyymmdd)
This field displays the system date when this was created.
CB145
CFT-RECEIPT-AMOUNT
Element: Intl Amt
Signed 18.2
CB45.1 CB543
CFT-BANK-ND
Element: Acct Nd
Numeric 1
The number of decimals assigned to a particular account as determined by the account currency.
CB45.1 CB543
CFT-BASE-RECPT-AMT
Element: Intl Amt
Signed 18.2
CB45.1 CB543
CFT-BASE-ND
Element: Acct Nd
Numeric 1
The number of decimals assigned to a particular account as determined by the account currency.
CB45.1 CB543
CFT-BASE-EFT-AMT
Element: Intl Amt
Signed 18.2
CB145
CFT-EXCHANGE-RATE
Element: Curr Rate
Signed 14.7
The currency rate.
CB45.1 CB543
CFT-CURRENCY-CODE
Element: Currency Code
Alpha 5
This field contains the bank account currency defined for the cash code.
CB45.1 CB543
CFT-DESCRIPTION
Element: Description
Alpha 30 (Lower Case)
This field displays the description.
CB45.1 CB543
CFT-CUST-NAME
Element: Search Name
Alpha 30
CB45.1 CB543
CFT-CUST-BANK
Element: Bank Entity
Alpha 15
Represents a bank institution location.
CB45.1 CB543
CFT-CUST-ACCOUNT
Element: Bank Acct Nbr
Alpha 35
The bank-assigned account number identification to be used for the cash code.
CB45.1 CB543
CFT-VBANK-IDENT
Element: Alphadata1
Alpha 1

" " = Standard Account Number
Y = IBAN Account Number
CB45.1 CB543
CFT-ACH-PRENOTE
Element: Ach Prenot
Alpha 1

N = Not Prenotified
P = Penotified
A = Accepted
CB145 CB150
CB45.1 CB543
CFT-JRNL-BOOK-NBR
Element: Jrnl Book Nbr
Alpha 12
The journal book assigned to the transaction.
CB45.1 CB543
CFT-JBK-SEQ-NBR
Element: Jbk Seq Nbr
Numeric 10
The 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
Element: User Field1
Alpha 30
This 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
Element: User Field2
Alpha 30
This 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
Element: User Field1
Alpha 30
This 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
Element: User Field2
Alpha 30
This 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
Element: All Flag
Alpha 1

" " = Not Interfaced
I = Interfaced
CB45.1 CB543
CFT-LAST-DIST-SEQ
Element: Seq Nbr
Numeric 4
An automatically assigned sequence number.
CB150 CB180
CB45.1 CB543
CFT-SOURCE-CODE
Element: Source Code
Alpha 2
A two character code assigned to a transaction to identify where the transaction was created.
CB45.1 CB543
CFT-TRANS-TYPE
Element: Trans Type
Alpha 1
Determines if amounts or units are processed in each transaction.
2 = Credit Card
4 = EFT Extract
CB45.1 CB543
CFT-VOID-DATE
Element: Date
Numeric 8 (yyyymmdd)
CB85.1


CBFTTRANS FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CFTSET1 CASH-CODE
BANK-INST-CODE
TRANS-IDENT
CB175 CB180
CB245 CB300
CB543
CFTSET2 CASH-CODE
BANK-INST-CODE
REFERENCE-NO
TRANS-IDENT
CB150 CB44.1
CB45.1 CB46.1
CB544
CFTSET3 CASH-CODE
BANK-INST-CODE
TRANS-NBR
REFERENCE-NO
TRANS-IDENT
KeyChange
CB180 CB80.1
CB85.1
CFTSET4 COMPANY
CASH-CODE
BANK-INST-CODE
CURRENCY-CODE
TRANS-IDENT
KeyChange, Subset
WhereREC-STATUS =1
OrACH-PRENOTE ="N"
CB145
CFTSET5 REC-STATUS
CASH-CODE
BANK-INST-CODE
TRANS-NBR
REFERENCE-NO
TRANS-IDENT
KeyChange
CB180


CBFTTRANS FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Cbdistrib CBDISTRIB
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


File created: Thu Jun 09 02:12:05 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.