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 number representing an AR company.
AIF-CUSTOMER Alpha 9 (Right Justified) AR98.1
Element: Customer This field contains the number that
represents a customer.
AIF-BANK-ENTITY Alpha 15 AR98.1
Element: Bank Entity Represents a bank institution location.
AIF-BANK-ACCT-NBR Alpha 35 AR98.1
Element: Bank Acct Nbr The 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: End 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 The bank account RIBKEY value.
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
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
|
