|
|
ARITRANS FILE
AR Interface Transaction
AR Interface Transaction
REFERENCED BY
AC115 AR42.2 AR42.7
UPDATED BY
AR502 AR560 AR97.1 AR99.1 BL123 PBIP.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
AIT-COMPANY Numeric 4 AR97.1 AR99.1
Company Required. Transaction company number. BL123 PBIP.1
AIT-TRANS-TYPE Alpha 1 AR97.1 AR99.1
Transaction Type Required. Transaction type of open item BL123 PBIP.1
record. Valid values are:
C = Credit Memo
D = Debit Memo
I = Invoice
AIT-TRANS-NBR Alpha 10 (Right Justified) AR97.1 AR99.1
Transaction Number Required. Transaction number. BL123 PBIP.1
AIT-PAYMENT-SEQ Numeric 6 AR99.1
Payment Sequence Payment Sequence. This is the generated
Number sequence number to separate individual
payment requirements.
AIT-CUSTOMER Alpha 9 (Right Justified) AR97.1 AR99.1
Customer Required. Customer number. BL123 PBIP.1
AIT-STATUS Numeric 1 AR97.1 AR99.1
Status Required. Status indicating where this BL123 PBIP.1
record is in the processing flow. Valid
values are:
1 = Open
7 = Fully applied
8 = Closed
9 = Historical
AIT-GL-STATUS Numeric 1 AR97.1 AR99.1
General Ledger Required. Specifies if distribution BL123 PBIP.1
Status records are to be posted to general
ledger. Valid values are:
2 = Not posted
9 = Posted
AIT-LAST-STA-DATE Numeric 8 (yyyymmdd) AR97.1 AR99.1
Last Statement Date Date of last statement that this record BL123 PBIP.1
was selected for. YYYYMMDD format.
AIT-BATCH-NBR Numeric 6 AR97.1 AR99.1
Batch Number Required. Identifies the batch the BL123 PBIP.1
entered transaction belongs to.
AIT-PROCESS-LEVEL Alpha 5 AR97.1 AR99.1
Process Level Required. The process level of this BL123 PBIP.1
invoice, debit memo or credit memo. Must
be an active process level and not
restricted for this customer's
invoice.
AIT-TRANS-DATE Numeric 8 (yyyymmdd) AR97.1 AR99.1
Transaction Date Required. Date of the transaction. BL123 PBIP.1
YYYYMMDD format.
AIT-GL-DATE Numeric 8 (yyyymmdd) AR97.1 AR99.1
General Ledger Date Required. General Ledger posting date. BL123 PBIP.1
AIT-APPLIED-SEQ Numeric 5 AR99.1 BL123
Application Sequence Application sequence for interfaced PBIP.1
invoice, debit memo or credit memo.
AIT-LAST-FC-DATE Numeric 8 (yyyymmdd) AR99.1 BL123
Last Finance Charge Last finance charge date for this PBIP.1
Date invoice or debit memo. YYYYMMDD format.
AIT-CUST-PO-NBR Alpha 20 AR97.1 AR99.1
Customer PO Number Customer purchase order number that BL123 PBIP.1
relates to this credit memo, debit memo,
or invoice.
AIT-XREF-COMPANY Numeric 4 AR502 AR560
Cross Reference Cross reference company number. AR97.1 AR99.1
Company BL123 PBIP.1
AIT-XREF-TYPE Alpha 1 AR97.1 AR99.1
Cross Reference Type Cross reference type indicator. This BL123 PBIP.1
field is used with the cross reference
number field. Valid values are:
D = Debit memo
I = Invoice
O = Other - Order processing
AIT-XREF-NBR Alpha 10 AR97.1 AR99.1
Cross Reference Cross reference number that this BL123 PBIP.1
Number invoice, debit memo or credit memo
relates to. This field is used with the
cross reference type field.
AIT-XREF-SEQ Numeric 3 AR502
Cross Reference Sequence number representing cross
Sequence referenced open item payment obligation
occurrence.
AIT-DESC Alpha 30 (Lower Case) AR97.1 AR99.1
Description Description of invoice or reason for BL123 PBIP.1
credit or debit memo.
AIT-AR-CODE Alpha 4 AR97.1 AR99.1
Accounts Receivable Accounts Receivable general ledger BL123 PBIP.1
Code account code. The account specified by
this code will be credited during cash
application.
AIT-SALESMAN Numeric 4 AR97.1 AR99.1
Sales Rep The sales representative for this BL123 PBIP.1
invoice, debit memo or credit memo.
AIT-TRANS-USER1 Alpha 10 AR97.1 AR99.1
Transaction User 1 First user field. This field is used in BL123 PBIP.1
record selection and record sorting.
AIT-TRANS-USER2 Alpha 15 AR97.1 AR99.1
Transaction User 2 Second user field. BL123 PBIP.1
AIT-TRANS-USER3 Numeric 8 (yyyymmdd) AR97.1 AR99.1
Transaction User 3 Third user field. BL123 PBIP.1
AIT-TRANS-USER4 Numeric 9 AR97.1 AR99.1
Transaction User 4 Fourth user field. BL123 PBIP.1
AIT-TRANS-USER5 Signed 13.2 AR97.1 AR99.1
Transaction User 5 Fifth user field. BL123 PBIP.1
AIT-ORIG-CURRENCY Alpha 5 AR560 AR97.1
Transaction Currency Currency in which the credit memo, AR99.1 BL123
debit memo, or invoice was entered. PBIP.1
AIT-ORIG-RATE Signed 12.6 AR560 AR97.1
Exchange Rate The rate used to convert a transaction AR99.1 BL123
amount from a non-base currency to the PBIP.1
company base currency.
AIT-CURR-MUDV Alpha 1 AR560 AR97.1
Currency Currency Multiplier or Divider. This is AR99.1 BL123
Multiply/Divide used along with the currency rate to PBIP.1
compute the company base transaction
amount. Valid values are:
D = Divide
M = Multiply
AIT-ORIG-AMT Signed 15.2 AR97.1 AR99.1
Transaction Amount Required. Transaction amount in BL123 PBIP.1
transaction currency of invoice, debit
memo or credit memo.
AIT-GROUP-RATE Signed 12.6 AR560 AR97.1
Group Rate The group rate used to calculate AR99.1 BL123
customer group balance updates. PBIP.1
AIT-GROUP-MUDV Alpha 1 AR560 AR97.1
Group The group currency multiplier or AR99.1 BL123
Multiply/Divide divider. Valid values are: PBIP.1
D = Divide
M = Multiply
AIT-ORIG-APP-AMT Signed 15.2 AR97.1 AR99.1
Transaction Applied Amount, if any, of all applications for BL123 PBIP.1
Amount this credit memo, debit memo, or invoice
in transaction currency.
AIT-ORIG-ADJ-AMT Signed 15.2 AR97.1 AR99.1
Transaction Amount, if any, of all adjustments for BL123 PBIP.1
Adjustment Amount this credit memo, debit memo, or invoice
in transaction currency.
AIT-REVALUE-FL Alpha 1 AR560 AR97.1
Revalue This flag indicates whether this credit AR99.1 BL123
memo, debit memo, or invoice is subject PBIP.1
to revaluation if its currency differs
from the company base currency. Valid
values are:
N = No; do not revalue
Y = Yes; revalue
AIT-ORIG-ND Numeric 1 AR97.1 AR99.1
Number of Decimals Currency decimal indicator. BL123 PBIP.1
AIT-TERMS-CD Alpha 5 AR97.1 AR99.1
Terms Code Terms code for the credit memo, debit BL123 PBIP.1
memo, or invoice.
AIT-BANK-INST-CODE Alpha 3 AR97.1 AR99.1
Payment Code This is a user-defined value BL123 PBIP.1
representing a specific banking
transaction. There are three categories
of bank transactions: cash payments,
bill of exchange payments, and
miscellaneous non-payment bank
transactions. Specify the cash payment
value.
AIT-OPEN-ORDS Signed 15.2 AR97.1 AR99.1
Open Order Amount Order amount of an invoice, credit or BL123 PBIP.1
debit memo. This amount will be
subtracted from the customer's open
order amount.
AIT-DISC-DATE Numeric 8 (yyyymmdd) AR97.1 AR99.1
Discount Date Discount date of invoice. If entered it BL123 PBIP.1
will override the calculated discount
date of terms code.
AIT-DISC-PCT Percent 5.3 (Percent) AR97.1 AR99.1
Discount Percent Discount percent. If entered it will BL123 PBIP.1
override the discount percent of terms
code.
AIT-DUE-DATE Numeric 8 (yyyymmdd) AR97.1 AR99.1
Due Date The due date of the credit memo, debit BL123 PBIP.1
memo, or invoice. If entered it will
override the calculated due date of
terms code.
AIT-DISC-AMT Signed 15.2 AR97.1 AR99.1
Discount Amount Discount amount. If entered will BL123 PBIP.1
override the calculated discount amount
of terms code.
AIT-BILL-TO Numeric 4 AR97.1 AR99.1
Bill To The bill to location for the open item. BL123 PBIP.1
AIT-JRNL-BOOK-NBR Alpha 12 AR97.1 AR99.1
Journal Book Number The journal book assigned to the BL123 PBIP.1
transaction.
AIT-AUTO-APP-FL Alpha 1 AR97.1 AR99.1
Automatic Indicates if the credit memo is BL123 PBIP.1
Application Flag eligible for automatic memo application.
Valid values are:
N = No
Y = Yes
AIT-ACTIVITY Alpha 15 AR560 AR97.1
Activity The activity assigned to the AR99.1 BL123
transaction. PBIP.1
AIT-ACCT-CATEGORY Alpha 5 AR560 AR97.1
Account Category The account category assigned to the AR99.1 BL123
activity. PBIP.1
AIT-SUM-LINE Alpha 1 AR97.1
Summarize Open Item The field will determine if line items
Line Items are displayed in detail or summary.
N = No
Y = Yes
AIT-INTRASTAT-FL Alpha 1 AR97.1 BL123
Intrastat Flag Specifies whether the transaction is PBIP.1
subject to Intrastat reporting. (Yes or
No).
AIT-SHIP-TO-CTRY Alpha 2 AR97.1
Ship To Country The ship to country code. Must be a
valid Intrastat country code, defined in
IN01.1 (Country Maintenance)
AIT-SHIP-TO-REGION Alpha 2 AR97.1
Ship To Region The region to which the goods are
shipped. Must be a valid region for the
country, defined in IN02.1 (Region
Maintenance)
AIT-SHIP-FR-CTRY Alpha 2 AR97.1
Ship From Country The ship-from country code. Must be a
valid Intrastat country code defined in
IN01.1 (Country Maintenance)
AIT-SHIP-FR-REGION Alpha 2 AR97.1
Ship From Region The ship-from region code. Used for
Intrastat reporting only. Must be a
valid region for the country in IN02.1
(Region Maintenance).
AIT-LOADING-PORT Alpha 5
Port of Loading The port where the goods are loaded, if
required. The port code must be defined
in IN04.1 (Port Maintenance)
AIT-NOTC Alpha 2 AR97.1
Nature Of The Nature Of Transaction Code. This
Transaction Code code must be defined in IN07.1 (NOTC
Maintenance).
AIT-DLVRY-TRMS Alpha 1 AR97.1
Delivery Terms The terms of delivery. Valid values are:
1 = EXW 4 = DDU 9 = XXX
2 = FDB 5 = CFR
3 = CIF 6 = CIP
7
8
AIT-TRANSPORT-MODE Alpha 1
Transport Mode The mode of transportation at the border
crossing. Code 7 is used for the
Channel Tunnel.
1 Sea 4 Air 8 Inland Waterway
2 Rail 5 Post 9 Own Propulsion
3 Road 7 Fixed Installation
AIT-DROP-SHIP-IND Alpha 1
Drop Ship Indicator Specifies whether the shipment is a
drop (triangulated) shipment, that is a
shipment where goods are shipped from
one EC country to another, but a
principal in the transaction is based
elsewhere.
AIT-STAT-PROC Alpha 6 AR97.1
Statistical The statistical procedure code applied
Procedure to the data. The code must be defined
in IN06.1 (Statistical Procedure
Maintenance).
AIT-BOE-CODE Alpha 2 AR97.1
BOE Code A 2-digit term referring to energy,
required in some countries.
AIT-AFFILIATION-CD Alpha 1 AR97.1
Affiliation Code Specifies whether there is a
affiliation between the declarnt and
vendor or customer. No is the default.
AIT-CSA-CODE Alpha 1 AR97.1
CSA Code Required in some countries for energy
transactions. Select Yes if the
transactions is under contractual
agreement. No is the default.
ARITRANS FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
AITSET1 COMPANY This path is used for record uniqueness AR502 AR560
CUSTOMER with customer being an access method for
TRANS-TYPE processing.
TRANS-NBR
PAYMENT-SEQ
AITSET2 COMPANY This path is used for record AC115 AR42.2
TRANS-TYPE uniqueness. AR42.7 AR560
TRANS-NBR AR97.1 AR97.2
PAYMENT-SEQ AR99.1 BL123
PBIP.1
|