|
|
ARIAPPLIED FILE
AR Application Conversion
AR Application Conversion
UPDATED BY
AR504 AR99.4
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
IAP-CR-COMPANY Numeric 4 AR99.4
Payment Company Company number identifying the payment
company.
IAP-CR-CUSTOMER Alpha 9 (Right Justified) AR99.4
Payment Customer Customer number representing the
payment customer.
IAP-COMPANY Numeric 4 AR99.4
Company Required. Transaction company number.
IAP-CUSTOMER Alpha 9 (Right Justified) AR99.4
Customer Required. Transaction customer number.
IAP-CR-TYPE Alpha 1 AR99.4
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 10 AR99.4
Credit Memo Number Payment or credit memo number of the
application.
IAP-CR-PYMNT-SEQ Numeric 6 AR504 AR99.4
Application Sequence Payment sequence number.
IAP-CR-ORIG-AP-AMT Signed 15.2 AR504 AR99.4
Credit Application The amount of the application in the
Orig Amt currency of the payment.
IAP-CR-APP-AMT Signed 15.2 AR504 AR99.4
Credit Application The amount of the application in the
Amount payment company base.
IAP-TRANS-TYPE Alpha 1 AR99.4
Transaction Type Required. Transaction type indicator.
Valid values are:
D = Debit Memo
I = Invoice
C = Credit Memo
P = Payment
IAP-TRANS-NBR Alpha 10 (Right Justified) AR99.4
Transaction Type Required. Transaction number of the
invoice, credit memo, debit memo, or
payment.
IAP-PAYMENT-SEQ Numeric 6 AR504 AR99.4
Payment Sequence Required. Payment obligation sequence
number of the invoice, debit memo, or
credit memo. Entry sequence within
payment batch.
IAP-APP-SEQ Numeric 5 AR99.4
Application Sequence Required. Application sequence of the
invoice, credit memo, debit memo or
payment.
IAP-APPLD-AMT Signed 15.2 AR99.4
Application Amount Application amount. Required field.
IAP-GL-DATE Numeric 8 (yyyymmdd) AR99.4
General Ledger Date General Ledger posting date of
application. Required field.
IAP-OPR-CODE Alpha 10 (Lower Case) AR99.4
Operator Code Operator code. This is set to the user
ID of the user who last maintained this
record.
IAP-APP-CURR-CD Alpha 5 AR504 AR99.4
Application Currency Currency code representing the currency
of the application.
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
TRANS-TYPE
TRANS-NBR
PAYMENT-SEQ
APP-SEQ
|