EFT Deposit Extract Data
REFERENCED BY
CB175 | CB245 | CB44.1 | CB46.1 | CB544 |
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. |
|
||||||
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. |
|
||||||
CFT-TRANS-IDENT Element: Trans Ident | Numeric 10 A unique system-generated identification value assigned to the transaction to make this record unique. |
|
||||||
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. |
|
||||||
CFT-TRANS-NBR Element: Trans Nbr | Alpha 10 (Right Justified) A unique, user-defined value used to identify the transaction. |
|
||||||
CFT-REFERENCE-NO Element: Trans Nbr | Alpha 10 (Right Justified) A unique, user-defined value used to identify the transaction. |
|
||||||
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) |
|
||||||
CFT-TRANS-DATE Element: Date | Numeric 8 (yyyymmdd) This field displays the system date when this was created. |
|
||||||
CFT-EFT-DATE Element: Date | Numeric 8 (yyyymmdd) This field displays the system date when this was created. |
|
||||||
CFT-RECEIPT-AMOUNT Element: Intl Amt | Signed 18.2 |
|
||||||
CFT-BANK-ND Element: Acct Nd | Numeric 1 The number of decimals assigned to a particular account as determined by the account currency. |
|
||||||
CFT-BASE-RECPT-AMT Element: Intl Amt | Signed 18.2 |
|
||||||
CFT-BASE-ND Element: Acct Nd | Numeric 1 The number of decimals assigned to a particular account as determined by the account currency. |
|
||||||
CFT-BASE-EFT-AMT Element: Intl Amt | Signed 18.2 |
|
||||||
CFT-EXCHANGE-RATE Element: Curr Rate | Signed 14.7 The currency rate. |
|
||||||
CFT-CURRENCY-CODE Element: Currency Code | Alpha 5 This field contains the bank account currency defined for the cash code. |
|
||||||
CFT-DESCRIPTION Element: Description | Alpha 30 (Lower Case) This field displays the description. |
|
||||||
CFT-CUST-NAME Element: Search Name | Alpha 30 |
|
||||||
CFT-CUST-BANK Element: Bank Entity | Alpha 15 Represents a bank institution location. |
|
||||||
CFT-CUST-ACCOUNT Element: Bank Acct Nbr | Alpha 35 The bank-assigned account number identification to be used for the cash code. |
|
||||||
CFT-VBANK-IDENT Element: Alphadata1 | Alpha 1 " " = Standard Account Number Y = IBAN Account Number |
|
||||||
CFT-ACH-PRENOTE Element: Ach Prenot | Alpha 1 N = Not Prenotified P = Penotified A = Accepted |
|
||||||
CFT-JRNL-BOOK-NBR Element: Jrnl Book Nbr | Alpha 12 The journal book assigned to the transaction. |
|
||||||
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). |
|
||||||
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. |
|
||||||
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. |
|
||||||
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. |
|
||||||
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. |
|
||||||
CFT-TAX-FLAG Element: All Flag | Alpha 1 " " = Not Interfaced I = Interfaced |
|
||||||
CFT-LAST-DIST-SEQ Element: Seq Nbr | Numeric 4 An automatically assigned sequence number. |
|
||||||
CFT-SOURCE-CODE Element: Source Code | Alpha 2 A two character code assigned to a transaction to identify where the transaction was created. |
|
||||||
CFT-TRANS-TYPE Element: Trans Type | Alpha 1 Determines if amounts or units are processed in each transaction. 2 = Credit Card 4 = EFT Extract |
|
||||||
CFT-VOID-DATE Element: Date | Numeric 8 (yyyymmdd) |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
CFTSET1 |
CASH-CODE BANK-INST-CODE TRANS-IDENT |
|
| ||||||||||||||||||||
CFTSET2 |
CASH-CODE BANK-INST-CODE REFERENCE-NO TRANS-IDENT |
|
| ||||||||||||||||||||
CFTSET3 |
CASH-CODE BANK-INST-CODE TRANS-NBR REFERENCE-NO TRANS-IDENT |
|
| ||||||||||||||||||||
CFTSET4 |
COMPANY CASH-CODE BANK-INST-CODE CURRENCY-CODE TRANS-IDENT |
|
| ||||||||||||||||||||
CFTSET5 |
REC-STATUS CASH-CODE BANK-INST-CODE TRANS-NBR REFERENCE-NO TRANS-IDENT |
|
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Cbdistrib | CBDISTRIB |
|
All trademarks and registered trademarks are the property of their
respective owners.