FTTRANS FILE
EFT Transaction
The EFT Transaction file contains the records used in processing EFT
transactions.
UPDATED BY
AR100 AR105 AR110 AR115 AR300
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
FTT-CUST-GROUP Alpha 5 AR100 AR110
Customer Group Customer group. Used to identify a
group of customer associated with one or
more companies.
FTT-CR-COMPANY Numeric 4 AR100 AR110
EFT Company This is the company that owns the EFT
transaction.
FTT-COMPANY Numeric 4 AR100 AR110
Company The company that owns the open item.
FTT-TRANS-TYPE Alpha 1 AR100 AR110
Transaction Type Transaction type. Valid values are
C = Credit memo
D = Debit memo
I = Invoice
FTT-INVOICE Alpha 22 AR100 AR110
Invoice Number Used to identify the invoice.
FTT-PAYMENT-SEQ Numeric 6 AR100 AR110
Payment Sequence Payment Sequence. This is the generated
sequence number to separate individual
invoice payment requirements.
FTT-EFT-TYPE Alpha 1 AR100 AR110
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
EFT Sequence Number Used to keep EFT transaction records
unique.
FTT-CR-CUSTOMER Alpha 9 (Right Justified) AR100 AR110
EFT Customer The customer which owns the EFT
transaction.
FTT-PROCESS-DATE Numeric 8 (yyyymmdd) AR100 AR110
EFT Processing Date The date the EFT transaction was
generated.
FTT-EFT-DATE Numeric 8 (yyyymmdd) AR100 AR110
EFT Date The date the funds will be drawn from
the customer's bank account.
FTT-NET-AMT Signed 15.2 AR100 AR110
EFT Amount The amount of the EFT transaction.
FTT-BANK-ENTITY Alpha 15 AR100 AR110
Bank Represents a bank institution location.
FTT-BANK-ACCT-NBR Alpha 17 AR100 AR110
Bank Account Number The bank-assigned account number
identification to be used for the cash
code.
FTT-EFT-NOTE Numeric 1 AR100 AR105
EFT Note Status Indicates the status of the EFT note. AR110
Valid values are
0 = Prenote not sent
1 = Prenote sent
2 = Final note sent
9 = Not printed
FTT-EFT-EXTRACT Numeric 1 AR100 AR110
EFT Extract Status Indicates 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 This path is used for record uniqueness. AR105 AR110
CR-COMPANY AR300
COMPANY
TRANS-TYPE
INVOICE
PAYMENT-SEQ
EFT-TYPE
EFT-SEQ
FTTSET2 CUST-GROUP This path is used to select EFT records AR115
CR-COMPANY for a customer at a company level.
CR-CUSTOMER
COMPANY
TRANS-TYPE
INVOICE
PAYMENT-SEQ
EFT-TYPE
EFT-SEQ
|
