ARIEFT FILE
This customer conversion table contains EFT bank and notification attributes
for EFT processing within the Accounts Receivable system. Each ARCCUST record
(conversion customer record) may be associated with one ARIEFT record.
UPDATED BY
AR501 AR98.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
AIF-COMPANY Numeric 4 AR98.1
Element: Company The company number. Must be a valid AR
company.
AIF-CUSTOMER Alpha 9 (Right Justified) AR98.1
Element: Customer NumbeThis field contains the number that
represents a customer.
AIF-BANK-ENTITY Alpha 15 AR98.1
Element: Bank Represents a bank institution location.
AIF-BANK-ACCT-NBR Alpha 35 AR98.1
Element: Bank Account NThe bank-assigned account number
identification.
AIF-START-DATE Numeric 8 (yyyymmdd) AR98.1
Element: Start Date The start date for EFT selection for the
associated bank account.
AIF-END-DATE Numeric 8 (yyyymmdd) AR98.1
Element: Ending Date The end date for EFT selection for the
associated bank account.
AIF-PRENOTE Numeric 8 (yyyymmdd) AR98.1
Element: Prenote This is the date the prenotification was
sent to the customer for EFT processing.
AIF-FT-TYPE Alpha 1 AR98.1
Element: Ft Type The type of bank account. Valid values
are:
Blank = Debit and credit account
C = Credit account
D = Debit account
AIF-PRE-NOTE Alpha 1 AR98.1
Element: Pre Note Indicates if sending a prenote for this
bank account is required.
AIF-PRENOTE-STATUS Numeric 1 AR98.1
Element: Prenote StatusStatus of the prenote for this bank
account. Valid values are:
0 = Not Prenoted (default)
1 = Printed
9 = EFT record sent
AIF-CUST-ACCT-TYPE Alpha 1 AR98.1
Element: Cust Acct TypeThe type of account the customer has:
C = Check
S = Savings
AIF-RIBKEY Numeric 2 AR98.1
Element: Ribkey
AIF-CUST-PRE-NOTE Alpha 1 AR98.1
Element: Cust Pre Note Indicates if customers are prenotified
of EFT transactions. Valid values are:
N = No
Y = Yes
AIF-CUST-NOTE-METH Alpha 1 AR98.1
Element: Cust Note MethIndicates the method used to deliver pre
or final EFT notification to a customer.
Valid values are:
A = Alternate EDI
E = EDI
F = Fax
AIF-ADJ-NOTE-METH Alpha 1 AR98.1
Element: Adj Note Meth The method used to deliver the EFT
adjustment notification to the customer.
Valid values are:
A = Alternate EDI
E = EDI
F = Fax
AIF-USER1-FIELD Alpha 5 AR98.1
Element: User1 Field User1 defined field.
AIF-USER2-FIELD Alpha 10 AR98.1
Element: User2 Field User2 defined field.
AIF-PAYMENT-FORMAT Alpha 1 AR98.1
Element: Payment FormatDetermines the payment format of the
file output for EFT transactions. Valid
values are:
A = ACH format
B = BACS
N = Non formatted
AIF-VBANK-IDENT Alpha 1 AR98.1
Element: Alphadata1 This field indicates if the account
number is an IBAN number that requires
an account validation check.
AIF-BANK-TRAN-CD Alpha 2 AR98.1
Element: Bank Tran Cd The value used for bank accunt edit
verification.
ARIEFT FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
AIFSET1 COMPANY AR501 AR98.1
CUSTOMER
|
