EFT Deposit Extract Data

REFERENCED BY

CB175

UPDATED BY

CB145	CB150	CB180	CB300	CB45.1	CB543
CB85.1	CB245	CB44.1	CB46.1	CB544

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) Represents the date the transaction was either voided, stop paid or tape rejected.	CB85.1

CBFTTRANS FILE INDEX

CBFTTRANS FILE RELATIONS

ONE TO MANY RELATIONS

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