FTTRANS FILE
EFT Transaction
The EFT Transaction file contains the records used in processing EFT
transactions.
UPDATED BY
AR100 AR105 AR110 AR115 AR180 AR25.1
AR300 AR37.1 AR37.2 AR37.3 AR37.4 AR37.5
AR37.6 AR37.7 AR80.1 AR80.2
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
FTT-CUST-GROUP Alpha 5 AR100 AR110
Element: Customer GroupCustomer group. Used to identify a
group of customer associated with one or
more companies.
FTT-CR-COMPANY Numeric 4 AR100 AR110
Element: EFT Company This is the company number that
represents the processing company of an
EFT transaction.
FTT-COMPANY Numeric 4 AR100 AR110
Element: Company The company that owns the open item
transaction.
FTT-TRANS-TYPE Alpha 1 AR100 AR110
Element: Trans Type Transaction type. Valid values are
C = Credit memo
D = Debit memo
I = Invoice
FTT-INVOICE Alpha 22 AR100 AR110
Element: Invoice Used to identify the invoice.
FTT-PAYMENT-SEQ Numeric 6 AR100 AR110
Element: Payment SequenA unique number assigned to each
transaction to be interfaced into the
Lawson system.
FTT-EFT-TYPE Alpha 1 AR100 AR110
Element: EFT Type This is the type of EFT transaction.
Valid values are
A = Adjusted
D = Extracted
N = Final Note
P = Prenote
FTT-EFT-SEQ Numeric 6 AR100 AR110
Element: EFT Sequence NUsed to keep EFT transaction records
unique.
FTT-CR-CUSTOMER Alpha 9 (Right Justified) AR100 AR110
Element: EFT Customer The customer which owns the EFT
transaction.
FTT-PROCESS-DATE Numeric 8 (yyyymmdd) AR100 AR110
Element: EFT ProcessingThe date the EFT transaction was
generated.
FTT-EFT-DATE Numeric 8 (yyyymmdd) AR100 AR110
Element: EFT Date The date the funds will be drawn from
the customer's bank account.
FTT-NET-AMT Signed 18.2 AR100 AR110
Element: EFT Amount The amount of the EFT transaction.
FTT-BANK-ENTITY Alpha 15 AR100 AR110
Element: Bank Entity Represents a bank institution location.
FTT-BANK-ACCT-NBR Alpha 35 AR100 AR110
Element: Bank Acct Nbr The bank-assigned account number
identification to be used for the cash
code.
FTT-EFT-NOTE Numeric 1 AR100 AR105
Element: EFT Note StatuIndicates the status of the EFT note. AR110 AR115
Valid values are
0 = Prenote not sent
1 = Prenote sent
2 = Final note sent
9 = Not printed
FTT-EFT-EXTRACT Numeric 1 AR100 AR110
Element: EFT Extract StIndicates the status of the EFT
extraction. Valid values are
0 = Not extracted
8 = Adjustment made
9 = Extracted
FTT-EFT-ACTION Alpha 1 AR100 AR110
EFT Transaction Indicates the status of the EFT
Status transaction. Valid values are
Blank = Not in due date range
0 = Eligible
1 = Added
2 = Postponed
3 = Deleted
5 = Added Postponed
6 = Hold
FTT-EFT-CREATED Alpha 1 AR100 AR110
EFT Generation Indicates if the EFT transaction has AR115
Status been generated. Valid values are
N = EFT not created
Y = EFT created
FTTRANS FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
FTTSET1 CUST-GROUP AR105 AR110
CR-COMPANY AR115 AR180
COMPANY AR25.1 AR300
TRANS-TYPE AR37.1 AR37.2
INVOICE AR37.3 AR37.4
PAYMENT-SEQ AR37.5 AR37.6
EFT-TYPE AR37.7 AR80.1
EFT-SEQ AR80.2
FTTSET2 CUST-GROUP AR105 AR115
CR-COMPANY
CR-CUSTOMER
COMPANY
TRANS-TYPE
INVOICE
PAYMENT-SEQ
EFT-TYPE
EFT-SEQ
|
