FTWORK FILE
EFT Work
The EFT Work file is the work file used during EFT adjustment processing.
UPDATED BY
AR25.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
FTW-CUST-GROUP Alpha 5 AR25.1
Customer Group Customer group. Used to identify a
group of customer associated with one or
more companies.
FTW-CR-COMPANY Numeric 4 AR25.1
EFT Company The company which will own the EFT
transaction.
FTW-COMPANY Numeric 4 AR25.1
Company The company which owns the open item.
FTW-TRANS-TYPE Alpha 1 AR25.1
Transaction Type Indicates the transaction type. Valid
values are:
C = Credit memo
D = Debit memo
I = Invoice
FTW-INVOICE Alpha 22 AR25.1
Invoice Number Used to identify the invoice.
FTW-PAYMENT-SEQ Numeric 6 AR25.1
Payment Sequence Payment Sequence. This is the generated
sequence number to separate individual
invoice payment requirements.
FTW-CUST-PO-NBR Alpha 22 AR25.1
Customer PO Number Customer purchase order number.
FTW-TRANS-USER1 Alpha 10 AR25.1
Trans User1 This the customer defined user one
field from the open item header file.
FTW-NET-AMT Signed 15.2 AR25.1
EFT Amount The net amount of the EFT transaction.
FTW-PROCESS-LEVEL Alpha 5 AR25.1
Process Level This field contains the process level,
which is the reporting hierarchy below
company.
FTW-TRAN-DATE Numeric 8 (yyyymmdd) AR25.1
Transaction Date The date of the transaction.
FTW-DISC-DATE Numeric 8 (yyyymmdd) AR25.1
Discount Date The discount date of the transaction.
FTW-DUE-DATE Numeric 8 (yyyymmdd) AR25.1
Due Date The due date of the transaction.
FTW-EFT-ACTION Alpha 1 AR25.1
EFT Action The EFT action taken on the
transaction. Valid values are:
Blank = Not within due date range
0 = Eligible
1 = Added
2 = Postponed
3 = Deleted
5 = Added Postponed
6 = Hold
FTW-EFT-NOTE Numeric 1 AR25.1
EFT Notification Indicates if the prenote or the final
Status note has been sent. Valid values are:
1 = Prenote sent
2 = Final note sent
FTW-WORK-ACTION Alpha 1 AR25.1
Work Record Action The action that will be taken with this
work record. Valid values are:
A = Add
C = Hold
D = Delete
P = Postpone
FTWORK FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
FTWSET1 CUST-GROUP This is the primary index for the file. AR25.1
CR-COMPANY
COMPANY
TRANS-TYPE
INVOICE
PAYMENT-SEQ
|
