|
|
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
Element: Customer GroupCustomer group. Used to identify a
group of customer associated with one or
more companies.
FTW-CR-COMPANY Numeric 4 AR25.1
Element: EFT Company The company which will own the EFT
transaction.
FTW-COMPANY Numeric 4 AR25.1
Element: Company The company which owns the open item.
FTW-TRANS-TYPE Alpha 1 AR25.1
Element: Transaction TyIndicates the transaction type. Valid
values are:
C = Credit memo
D = Debit memo
I = Invoice
FTW-INVOICE Alpha 22 AR25.1
Element: Invoice NumberUsed to identify the invoice.
FTW-PAYMENT-SEQ Numeric 6 AR25.1
Element: Payment SequenPayment Sequence. This is the generated
sequence number to separate individual
invoice payment requirements.
FTW-CUST-PO-NBR Alpha 22 AR25.1
Element: Customer PO NuCustomer purchase order number.
FTW-TRANS-USER1 Alpha 10 AR25.1
Element: Trans User1 This the customer defined user one
field from the open item header file.
FTW-NET-AMT Signed 18.2 AR25.1
Element: EFT Amount The net amount of the EFT transaction.
FTW-PROCESS-LEVEL Alpha 5 AR25.1
Element: Process Level This field contains the process level,
which is the reporting hierarchy below
company.
FTW-TRAN-DATE Numeric 8 (yyyymmdd) AR25.1
Element: Transaction DaThe date of the transaction.
FTW-DISC-DATE Numeric 8 (yyyymmdd) AR25.1
Element: Date The discount date of the transaction.
FTW-DUE-DATE Numeric 8 (yyyymmdd) AR25.1
Element: Due Date The due date of the transaction.
FTW-EFT-ACTION Alpha 1 AR25.1
Element: 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
Element: Work Record AcThe 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
|
