|
FTWORK FILE
EFT Work
The EFT Work file is the work file used during EFT adjustment processing.
Records in this file have been created by actions within AR25 EFT Adjustments.
UPDATED BY
AR115 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 This is the company number that
represents the processing company of an
EFT transaction.
FTW-COMPANY Numeric 4 AR25.1
Element: Company The company which owns the open item
transaction.
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 Used to identify the invoice.
FTW-PAYMENT-SEQ Numeric 6 AR25.1
Element: Payment SequenA unique number assigned to each
transaction to be interfaced into the
Lawson system.
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: Tran Date The 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 AR115 AR25.1
CR-COMPANY
COMPANY
TRANS-TYPE
INVOICE
PAYMENT-SEQ
|