|
|
CBFTTRANS FILE
EFT Deposit Extract Data
REFERENCED BY
CB175 CB245 CB44.1 CB46.1 CB544
UPDATED BY
CB145 CB150 CB300 CB45.1 CB543
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CFT-CASH-CODE Alpha 4 CB45.1 CB543
Element: Cash Code 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 Alpha 3 CB45.1 CB543
Element: Bank Inst CodeA transaction code represents a type of
cash payment, bill of exchange payment,
or bank service transaction.
CFT-TRANS-IDENT Numeric 10 CB45.1 CB543
Element: Trans Ident A unique system-generated
identification value assigned to the
transaction to make this record unique.
CFT-COMPANY Numeric 4 CB45.1 CB543
Element: Company 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 Alpha 10 (Right Justified) CB145
Element: Trans Nbr A unique, user-defined value used to
identify the transaction.
CFT-REFERENCE-NO Alpha 10 (Right Justified) CB45.1 CB543
Element: Trans Nbr A unique, user-defined value used to
identify the transaction.
CFT-REC-STATUS Numeric 1 CB145 CB150
Element: Rec Status The record status. CB45.1 CB543
0 = Unreleased
1 = Released
2 = EFT Created
CFT-TRANS-DATE Numeric 8 (yyyymmdd) CB45.1 CB543
Element: Date This field displays the system date
when this was created.
CFT-EFT-DATE Numeric 8 (yyyymmdd) CB145
Element: Date This field displays the system date
when this was created.
CFT-RECEIPT-AMOUNT Signed 18.2 CB45.1 CB543
Element: Intl Amt
CFT-BANK-ND Numeric 1 CB45.1 CB543
Element: Acct Nd The number of decimals assigned to a
particular account as determined by the
account currency.
CFT-BASE-RECPT-AMT Signed 18.2 CB45.1 CB543
Element: Intl Amt
CFT-BASE-ND Numeric 1 CB45.1 CB543
Element: Acct Nd The number of decimals assigned to a
particular account as determined by the
account currency.
CFT-BASE-EFT-AMT Signed 18.2 CB145
Element: Intl Amt
CFT-EXCHANGE-RATE Signed 14.7 CB45.1 CB543
Element: Curr Rate The currency rate.
CFT-CURRENCY-CODE Alpha 5 CB45.1 CB543
Element: Currency Code This field contains the bank account
currency defined for the cash code.
CFT-DESCRIPTION Alpha 30 (Lower Case) CB45.1 CB543
Element: Description This field displays the description.
CFT-CUST-NAME Alpha 30 CB45.1 CB543
Element: Search Name
CFT-CUST-BANK Alpha 15 CB45.1 CB543
Element: Bank Entity Represents a bank institution location.
CFT-CUST-ACCOUNT Alpha 35 CB45.1 CB543
Element: Bank Acct Nbr The bank-assigned account number
identification to be used for the cash
code.
CFT-VBANK-IDENT Alpha 1 CB45.1 CB543
Element: Alphadata1 " " = Standard Account Number
Y = IBAN Account Number
CFT-ACH-PRENOTE Alpha 1 CB145 CB150
Element: Ach Prenot N = Not Prenotified CB45.1 CB543
P = Penotified
A = Accepted
CFT-JRNL-BOOK-NBR Alpha 12 CB45.1 CB543
Element: Jrnl Book Nbr The journal book assigned to the
transaction.
CFT-JBK-SEQ-NBR Numeric 10 CB45.1 CB543
Element: Jbk Seq Nbr 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 Alpha 30 CB45.1 CB543
Element: User Field1 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 Alpha 30 CB45.1 CB543
Element: User Field2 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 Alpha 30 CB45.1 CB543
Element: User Field1 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 Alpha 30 CB45.1 CB543
Element: User Field2 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 Alpha 1 CB45.1 CB543
Element: All Flag " " = Not Interfaced
I = Interfaced
CFT-LAST-DIST-SEQ Numeric 4 CB150 CB45.1
Element: Seq Nbr An automatically assigned sequence CB543
number.
CFT-SOURCE-CODE Alpha 2 CB45.1 CB543
Element: Source Code A two character code assigned to a
transaction to identify where the
transaction was created.
CFT-TRANS-TYPE Alpha 1 CB45.1 CB543
Element: Trans Type Determines if amounts or units are
processed in each transaction.
2 = Credit Card
4 = EFT Extract
CBFTTRANS FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CFTSET1 CASH-CODE CB175 CB245
BANK-INST-CODE CB300 CB543
TRANS-IDENT
CFTSET2 CASH-CODE CB150 CB44.1
BANK-INST-CODE CB45.1 CB46.1
REFERENCE-NO CB544
TRANS-IDENT
CFTSET3 CASH-CODE KeyChange
BANK-INST-CODE
TRANS-NBR
REFERENCE-NO
TRANS-IDENT
CFTSET4 COMPANY KeyChange, Subset CB145
CASH-CODE Where REC-STATUS = 1
BANK-INST-CODEOr ACH-PRENOTE = "N"
CURRENCY-CODE
TRANS-IDENT
CBFTTRANS FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME 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
|
