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
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
FTT-CUST-GROUP Alpha 5 AR100 AR110
Element: Customer Group
FTT-CR-COMPANY Numeric 4 AR100 AR110
Element: EFT Company This is the company that owns the EFT
transaction.
FTT-COMPANY Numeric 4 AR100 AR110
Element: Company The company that owns the open item.
FTT-TRANS-TYPE Alpha 1 AR100 AR110
Element: Transaction TyTransaction type. Valid values are
C = Credit memo
D = Debit memo
I = Invoice
FTT-INVOICE Alpha 22 AR100 AR110
Element: Invoice NumberUsed to identify the invoice.
FTT-PAYMENT-SEQ Numeric 6 AR100 AR110
Element: Payment Sequence
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 15.2 AR100 AR110
Element: EFT Amount The amount of the EFT transaction.
FTT-BANK-ENTITY Alpha 15 AR100 AR110
Element: Bank Represents a bank institution location.
FTT-BANK-ACCT-NBR Alpha 17 AR100 AR110
Element: Bank Account NThe 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
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 This path is used for record uniqueness. AR105 AR110
CR-COMPANY AR180 AR25.1
COMPANY AR300 AR37.1
TRANS-TYPE AR37.2 AR37.3
INVOICE AR37.4 AR37.5
PAYMENT-SEQ AR37.6 AR37.7
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
|
