|
|
ARIAPPLIED FILE
AR Application Conversion
The AR Application Conversion file contains conversion application records
loaded from an external source for use by AR504 (Application Conversion).
Field data in this file can be accessed and maintained in AR99 (Conversion
Maintenance).
UPDATED BY
AR504 AR99.4
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
IAP-CR-COMPANY Numeric 4 AR99.4
Element: Payment CompanCompany number identifying the payment
company.
IAP-CR-CUSTOMER Alpha 9 (Right Justified) AR99.4
Element: Payment CustomCustomer number representing the
payment customer.
IAP-COMPANY Numeric 4 AR99.4
Element: Company Required. Transaction company number.
IAP-CUSTOMER Alpha 9 (Right Justified) AR99.4
Element: Customer Required. Transaction customer number.
IAP-CR-TYPE Alpha 1 AR99.4
Element: Payment Type Indicates payment type. If blank all
credit key fields must be blank. Valid
values are:
Blank = Non payment (write-off)
P = Payment
C = Credit memo
IAP-CR-NBR Alpha 22 AR99.4
Element: Credit Memo NuPayment or credit memo number of the
application.
IAP-CR-PYMNT-SEQ Numeric 6 AR504 AR99.4
Element: Application SePayment sequence number.
IAP-CR-ORIG-AP-AMT Signed 18.2 AR504 AR99.4
Element: Intl Amt The amount of the application in the
currency of the payment.
IAP-CR-APP-AMT Signed 18.2 AR504 AR99.4
Element: Intl Amt The amount of the application in the
payment company base.
IAP-TRANS-TYPE Alpha 1 AR99.4
Element: Transaction TyRequired. Transaction type indicator.
Valid values are:
D = Debit Memo
I = Invoice
C = Credit Memo
P = Payment
IAP-INVOICE Alpha 22 AR99.4
Element: Invoice NumberUsed to identify the invoice.
IAP-PAYMENT-SEQ Numeric 6 AR504 AR99.4
Element: Payment SequenRequired. Payment obligation sequence
number of the invoice, debit memo, or
credit memo. Entry sequence within
payment batch.
IAP-APP-SEQ Numeric 7 AR99.4
Element: Application SeRequired. Application sequence of the
invoice, credit memo, debit memo or
payment.
IAP-APPLD-AMT Signed 18.2 AR99.4
Element: Application AmApplication amount. Required field.
IAP-BASE-APP-AMT Signed 18.2
Element: Adj Amt
IAP-GL-DATE Numeric 8 (yyyymmdd) AR99.4
Element: General LedgerGeneral Ledger posting date of
application. Required field.
IAP-OPR-CODE Alpha 10 (Lower Case) AR99.4
Element: Operator Code Operator code. This is set to the user
ID of the user who last maintained this
record.
ARIAPPLIED FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
IAPSET1 CR-COMPANY The path is used to keep the records AR504 AR99.4
CR-CUSTOMER unique.
COMPANY
CUSTOMER
CR-TYPE
CR-NBR
CR-PYMNT-SEQ
TRANS-TYPE
INVOICE
PAYMENT-SEQ
APP-SEQ
|
