Lawson Insight Technical Documentation |
|
ARDRAFTS
ARDRAFTS FILE
AR Bill of Exchange
The AR Bills of Exchange file contains all system-generated bills of exchange
and released customer-generated bills of exchange.
REFERENCED BY
AR258 AR37.6 AR37.8 AR80.2 DT17.1 DT190
DT220 DT270 DT280 AR72.1 AR271 AR275
AR150 AR161 AR194 AR250 AR251 AR252
AR253 AR255 AR256 AR286 AR287 AR294
AR50.1 AR505 AR53.1 AR90.1 DT95.1
UPDATED BY
AR129 AR130 AR131 AR135 AR30.1 AR33.1
AR33.6 AR39.1 AR39.2 AR42.1 AR42.2 AR42.6
AR42.7 AR43.1 AR44.3 AR48.3 AR502 AR560
ARLL.1 DT150 DT155 DT160 DT161 DT165
DT166 DT170 DT180 DT181 DT185 DT30.1
DT30.2 DT40.1 DT42.1 DT45.1 DT520 DT60.1
DT60.2 DT70.1 DT70.3 DT80.1 DT85.1 DT85.2
DT90.1 DT92.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ARD-COMPANY Numeric 4 AR42.1 AR42.2
Element: Company The company number represents an AR42.6 AR42.7
established company. Must be a valid AR43.1 AR44.3
record in the AR Company file. AR502 AR560
ARLL.1 DT150
DT155 DT160
DT165 DT166
DT180 DT30.1
DT30.2 DT40.1
DT42.1 DT45.1
DT520 DT60.1
DT60.2 DT70.1
DT70.3 DT80.1
DT85.1 DT85.2
DT92.1
ARD-AR-DRAFT-NBR Alpha 22 AR42.1 AR42.2
Element: Ar Draft Nbr AR42.6 AR42.7
AR43.1 AR44.3
AR502 AR560
ARLL.1 DT150
DT155 DT160
DT165 DT166
DT180 DT30.1
DT30.2 DT40.1
DT42.1 DT45.1
DT520 DT60.1
DT60.2 DT70.1
DT70.3 DT80.1
DT85.1 DT85.2
DT92.1
ARD-SUFFIX Numeric 3 AR42.1 AR42.2
Bill of Exchange The bill of exchange suffix number. AR42.6 AR42.7
Suffix Represents the occurrence value of the AR43.1 AR44.3
bill of exchange. Used if a bill of AR502 AR560
exchange is created for a single payment ARLL.1 DT150
of a multiple payment invoice. DT155 DT160
DT165 DT166
DT180 DT30.1
DT30.2 DT40.1
DT42.1 DT45.1
DT520 DT60.1
DT60.2 DT70.1
DT70.3 DT80.1
DT85.1 DT85.2
DT92.1
ARD-CUSTOMER Alpha 9 (Right Justified) AR42.1 AR42.2
Element: Customer The customer assigned to the bill of AR42.6 AR42.7
exchange. Represents the customer AR43.1 AR44.3
responsible for paying the bill of AR502 AR560
exchange obligation. Must be a valid ARLL.1 DT150
record in the AR Company Customer file. DT155 DT160
DT165 DT166
DT180 DT30.1
DT30.2 DT40.1
DT42.1 DT45.1
DT520 DT60.1
DT60.2 DT70.1
DT70.3 DT80.1
DT85.1 DT85.2
DT92.1
ARD-CANCEL-SEQ Numeric 4 AR42.1 AR42.2
Element: Seq Nbr An automatically assigned sequence AR42.6 AR42.7
number. AR43.1 AR44.3
AR502 AR560
ARLL.1 DT150
DT155 DT160
DT165 DT166
DT180 DT30.1
DT30.2 DT40.1
DT42.1 DT45.1
DT520 DT60.1
DT60.2 DT70.1
DT70.3 DT80.1
DT85.1 DT85.2
DT92.1
ARD-DRAFT-SOURCE Alpha 1 AR42.1 AR42.2
Bill of Exchange Indicates where the bill of exchange AR42.6 AR42.7
Source originated. Valid values are: AR43.1 AR44.3
AR502 AR560
R = Receivable. The bill of exchange ARLL.1 DT150
was created by the vendor (accounts DT155 DT160
receivable). DT165 DT166
DT180 DT30.1
P = Payable. The bill of exchange was DT30.2 DT40.1
created by the customer (accounts DT42.1 DT45.1
payable). DT520 DT60.1
DT60.2 DT70.1
I = Interfaced. The bill of exchange DT70.3 DT80.1
was created by an interfacing system, DT85.1 DT85.2
such as an order entry system. DT92.1
ARD-APP-SEQ Numeric 7 AR129 AR130
Element: Application SeThe counter for the number of AR131 AR135
applications used in the Accounts AR30.1 AR33.1
Receivable Application file. AR33.6 AR39.1
AR39.2 AR42.1
AR42.2 AR42.6
AR42.7 AR43.1
AR44.3 AR48.3
AR502 AR560
ARLL.1 DT150
DT155 DT160
DT165 DT166
DT180 DT30.1
DT30.2 DT40.1
DT45.1 DT520
DT60.1 DT60.2
DT70.1 DT70.3
DT80.1 DT85.1
DT85.2 DT92.1
ARD-PROCESS-LEVEL Alpha 5 AR42.1 AR42.2
Element: Process Level The process level assigned to the bill AR42.6 AR42.7
of exchange. Must be a valid record in AR43.1 AR44.3
the AR Process Level file. AR502 AR560
ARLL.1 DT150
DT155 DT160
DT165 DT166
DT180 DT30.1
DT30.2 DT40.1
DT45.1 DT520
DT60.1 DT60.2
DT70.1 DT70.3
DT80.1 DT85.1
DT85.2 DT92.1
ARD-BANK-INST-CODE Alpha 3 AR42.1 AR42.2
Element: Payment Code A transaction code representing a type AR42.6 AR42.7
of cash payment (with atributes for AR43.1 AR44.3
either receiving AP payments, or AR502 AR560
creating EFT payments), bill of exchange ARLL.1 DT150
payment, or bank service transaction. DT155 DT160
DT161 DT165
DT166 DT180
DT30.1 DT30.2
DT40.1 DT45.1
DT520 DT60.1
DT60.2 DT70.1
DT70.3 DT80.1
DT85.1 DT85.2
DT92.1
ARD-REMIT-COMPANY Numeric 4 AR42.1 AR42.2
Element: Company This field contains the remittance AR42.6 AR42.7
company once the bill of exchange is AR43.1 AR44.3
included in a remittance. Must be a AR502 AR560
valid record in the AR Company file. ARLL.1 DT150
DT155 DT160
DT161 DT165
DT166 DT180
DT30.1 DT30.2
DT40.1 DT45.1
DT520 DT60.1
DT60.2 DT70.1
DT70.3 DT80.1
DT85.1 DT85.2
DT92.1
ARD-REMIT-PROC-LEV Alpha 5 AR42.1 AR42.2
Element: Process Level This field contains remittance process AR42.6 AR42.7
level once the bill of exchange is AR43.1 AR44.3
included in a remittance. Must be a AR502 AR560
valid record in the AR Process Level ARLL.1 DT150
file. DT155 DT160
DT161 DT165
DT166 DT180
DT30.1 DT30.2
DT40.1 DT45.1
DT520 DT60.1
DT60.2 DT70.1
DT70.3 DT80.1
DT85.1 DT85.2
DT92.1
ARD-CASH-CODE Alpha 4 AR42.1 AR42.2
Element: Cash Code The cash code (bank account) used for AR42.6 AR42.7
depositing the bill of exchange. Must be AR43.1 AR44.3
a valid record in the Cash Ledger Cash AR502 AR560
Code file. ARLL.1 DT150
DT155 DT160
DT161 DT165
DT166 DT180
DT30.1 DT30.2
DT40.1 DT45.1
DT520 DT60.1
DT60.2 DT70.1
DT70.3 DT80.1
DT85.1 DT85.2
DT92.1
ARD-REMIT-TYPE Alpha 1 AR42.1 AR42.2
Element: Remit Type Indicates the type of remittance AR42.6 AR42.7
associated with the bill of exchange. AR43.1 AR44.3
Valid values are: AR502 AR560
ARLL.1 DT150
D = Discounted remittance DT155 DT160
DT161 DT165
E = Encashed remittance; full value DT166 DT180
upon due date DT30.1 DT30.2
DT40.1 DT45.1
Blank = Not included in a remittance DT520 DT60.1
DT60.2 DT70.1
DT70.3 DT80.1
DT85.1 DT85.2
DT92.1
ARD-REMIT-NBR Numeric 7 AR42.1 AR42.2
Element: Remit Number The remittance number assigned to the AR42.6 AR42.7
bill of exchange when it is presented to AR43.1 AR44.3
the bank for cashing as part of a AR502 AR560
remittance. ARLL.1 DT150
DT155 DT160
DT161 DT165
DT166 DT180
DT30.1 DT30.2
DT40.1 DT45.1
DT520 DT60.1
DT60.2 DT70.1
DT70.3 DT80.1
DT85.1 DT85.2
DT92.1
ARD-GROUP-RATE Signed 14.7 AR42.1 AR42.2
Element: Group Rate The exchange rate used to convert a AR42.6 AR42.7
company base currency amount to the AR43.1 AR44.3
customer group currency. AR502 AR560
ARLL.1 DT150
DT155 DT160
DT165 DT166
DT180 DT30.1
DT30.2 DT40.1
DT45.1 DT520
DT60.1 DT60.2
DT70.1 DT70.3
DT80.1 DT85.1
DT85.2 DT92.1
ARD-GROUP-MUDV Alpha 1 AR42.1 AR42.2
Element: Group Mudv The multiplier or divisor indicator for AR42.6 AR42.7
the group rate. AR43.1 AR44.3
AR502 AR560
ARLL.1 DT150
DT155 DT160
DT165 DT166
DT180 DT30.1
DT30.2 DT40.1
DT45.1 DT520
DT60.1 DT60.2
DT70.1 DT70.3
DT80.1 DT85.1
DT85.2 DT92.1
ARD-ORIG-CURRENCY Alpha 5 AR42.1 AR42.2
Element: Transaction CuThe currency code assigned to the bill AR42.6 AR42.7
of exchange. Represents the currency AR43.1 AR44.3
that will be received upon cashing. AR502 AR560
ARLL.1 DT150
DT155 DT160
DT165 DT166
DT180 DT30.1
DT30.2 DT40.1
DT45.1 DT520
DT60.1 DT60.2
DT70.1 DT70.3
DT80.1 DT85.1
DT85.2 DT92.1
ARD-CURR-MUDV Alpha 1 AR42.1 AR42.2
Element: Curr Mudv The multiplier or divisor indicator AR42.6 AR42.7
used to convert the transaction currency AR43.1 AR44.3
amount to the company base currency. AR502 AR560
ARLL.1 DT150
DT155 DT160
DT165 DT166
DT180 DT30.1
DT30.2 DT40.1
DT45.1 DT520
DT60.1 DT60.2
DT70.1 DT70.3
DT80.1 DT85.1
DT85.2 DT92.1
ARD-ORIG-ND Numeric 1 AR42.1 AR42.2
Trans Currency Nbr The number of decimals defined for the AR42.6 AR42.7
of Decimals bill of exchange currency. AR43.1 AR44.3
AR502 AR560
ARLL.1 DT150
DT155 DT160
DT165 DT166
DT180 DT30.1
DT30.2 DT40.1
DT45.1 DT520
DT60.1 DT60.2
DT70.1 DT70.3
DT80.1 DT85.1
DT85.2 DT92.1
ARD-ORIG-RATE Signed 14.7 AR42.1 AR42.2
Trans Currency The exchange rate used to convert the AR42.6 AR42.7
Exchange Rate bill of exchange currency to the company AR43.1 AR44.3
base currency. AR502 AR560
ARLL.1 DT150
DT155 DT160
DT165 DT166
DT180 DT30.1
DT30.2 DT40.1
DT45.1 DT520
DT60.1 DT60.2
DT70.1 DT70.3
DT80.1 DT85.1
DT85.2 DT92.1
ARD-CASH-RATE Signed 14.7 AR42.1 AR42.2
Cashing Exchange The currency exchange rate in effect AR42.6 AR42.7
Rate when the bill of exchange was cashed. AR43.1 AR44.3
AR502 AR560
ARLL.1 DT150
DT155 DT160
DT165 DT166
DT180 DT181
DT30.1 DT30.2
DT40.1 DT45.1
DT520 DT60.1
DT60.2 DT70.1
DT70.3 DT80.1
DT85.1 DT85.2
DT92.1
ARD-ORIG-AMT Signed 18.2 AR42.1 AR42.2
Bill of Exchange The amount of the bill of exchange in AR42.6 AR42.7
Amount the currency of the bill of exchange. AR43.1 AR44.3
AR502 AR560
AR90.1 ARLL.1
DT150 DT155
DT160 DT165
DT166 DT180
DT30.1 DT30.2
DT40.1 DT45.1
DT520 DT60.1
DT60.2 DT70.1
DT70.3 DT80.1
DT85.1 DT85.2
DT90.1 DT92.1
ARD-TRAN-ND Numeric 1 AR42.1 AR42.2
Base Currency Nbr The number of decimals defined for the AR42.6 AR42.7
of Decimals company base currency. AR43.1 AR44.3
AR502 AR560
ARLL.1 DT150
DT155 DT160
DT165 DT166
DT180 DT30.1
DT30.2 DT40.1
DT45.1 DT520
DT60.1 DT60.2
DT70.1 DT70.3
DT80.1 DT85.1
DT85.2 DT92.1
ARD-TRAN-AMT Signed 18.2 AR42.1 AR42.2
Base Currency BOE The amount of the bill of exchange in AR42.6 AR42.7
Amount the company base currency. AR43.1 AR44.3
AR502 AR560
AR90.1 ARLL.1
DT150 DT155
DT160 DT165
DT166 DT180
DT30.1 DT30.2
DT40.1 DT45.1
DT520 DT60.1
DT60.2 DT70.1
DT70.3 DT80.1
DT85.1 DT85.2
DT90.1 DT92.1
ARD-DRAFT-DATE Numeric 8 (yyyymmdd) AR42.1 AR42.2
Bill of Exchange The date assigned to the bill of AR42.6 AR42.7
Date exchange. Represents the date the bill AR43.1 AR44.3
of exchange was created. AR502 AR560
ARLL.1 DT150
DT155 DT160
DT165 DT166
DT180 DT30.1
DT30.2 DT40.1
DT42.1 DT45.1
DT520 DT60.1
DT60.2 DT70.1
DT70.3 DT80.1
DT85.1 DT85.2
DT92.1
ARD-MATURITY-DATE Numeric 8 (yyyymmdd) AR42.1 AR42.2
Element: Due Date The bill of exchange due date. AR42.6 AR42.7
Indicates when the bill of exchange is AR43.1 AR44.3
due to be paid in full. AR502 AR560
ARLL.1 DT150
DT155 DT160
DT165 DT166
DT180 DT30.1
DT30.2 DT40.1
DT42.1 DT45.1
DT520 DT60.1
DT60.2 DT70.1
DT70.3 DT80.1
DT85.1 DT85.2
DT92.1
ARD-ACCEPT-DATE Numeric 8 (yyyymmdd) AR42.1 AR42.2
Element: Acceptance DatThe acceptance date assigned to the AR42.6 AR42.7
bill of exchange. Used only for bills of AR43.1 AR44.3
exchange that require acceptance. AR502 AR560
ARLL.1 DT150
DT155 DT160
DT165 DT166
DT180 DT30.1
DT30.2 DT40.1
DT45.1 DT520
DT60.1 DT60.2
DT70.1 DT70.3
DT80.1 DT85.1
DT85.2 DT92.1
ARD-ACCEPT-GL-DATE Numeric 8 (yyyymmdd) AR42.1 AR42.2
Acceptance General The date used for posting the AR42.6 AR42.7
Ledger Date acceptance of a bill of exchange to the AR43.1 AR44.3
general ledger. Used only for bills of AR502 AR560
exchange that require acceptance. ARLL.1 DT150
DT155 DT160
DT165 DT166
DT180 DT30.1
DT30.2 DT40.1
DT45.1 DT520
DT60.1 DT60.2
DT70.1 DT70.3
DT80.1 DT85.1
DT85.2 DT92.1
ARD-REMIT-DATE Numeric 8 (yyyymmdd) AR42.1 AR42.2
Element: Remit Date The remittance creation date for the AR42.6 AR42.7
remittance associated with the bill of AR43.1 AR44.3
exchange. Bills of exchange are grouped AR502 AR560
into remittances to be presented to the ARLL.1 DT150
bank for cashing. DT155 DT160
DT165 DT166
DT180 DT30.1
DT30.2 DT40.1
DT45.1 DT520
DT60.1 DT60.2
DT70.1 DT70.3
DT80.1 DT85.1
DT85.2 DT92.1
ARD-CASH-DATE Numeric 8 (yyyymmdd) AR42.1 AR42.2
Element: Date The date the bill of exchange was AR42.6 AR42.7
cashed. AR43.1 AR44.3
AR502 AR560
ARLL.1 DT150
DT155 DT160
DT165 DT166
DT180 DT181
DT30.1 DT30.2
DT40.1 DT45.1
DT520 DT60.1
DT60.2 DT70.1
DT70.3 DT80.1
DT85.1 DT85.2
DT92.1
ARD-DISHONOR-DATE Numeric 8 (yyyymmdd) AR42.1 AR42.2
Element: Dishonor Date If the bill of exchange was dishonored, AR42.6 AR42.7
this field contains the dishonor date AR43.1 AR44.3
assigned to the bill of exchange. AR502 AR560
ARLL.1 DT150
DT155 DT160
DT165 DT166
DT180 DT30.1
DT30.2 DT40.1
DT45.1 DT520
DT60.1 DT60.2
DT70.1 DT70.3
DT80.1 DT85.1
DT85.2 DT90.1
DT92.1
ARD-CANCEL-DATE Numeric 8 (yyyymmdd) AR42.1 AR42.2
Element: Cancel Date If the bill of exchange was canceled, AR42.6 AR42.7
this field contains the cancel date AR43.1 AR44.3
assigned to the bill of exchange. AR502 AR560
ARLL.1 DT150
DT155 DT160
DT165 DT166
DT180 DT30.1
DT30.2 DT40.1
DT45.1 DT520
DT60.1 DT60.2
DT70.1 DT70.3
DT80.1 DT85.1
DT85.2 DT92.1
ARD-RESOLVED-DATE Numeric 8 (yyyymmdd) DT40.1 DT92.1
Element: Resolved Date If the bill of exchange was dishonored,
this field contains the date the
dishonored bill of exchange was
resolved.
ARD-STATUS Numeric 1 AR42.1 AR42.2
Element: Status Indicates the status of the bill of AR42.6 AR42.7
exchange. Valid values are: AR43.1 AR44.3
AR502 AR560
0 = Created ARLL.1 DT150
1 = Accepted DT155 DT160
2 = Selected for Remittance DT161 DT165
3 = Included in Remittance DT166 DT170
4 = Presented DT180 DT181
6 = Cashed DT30.1 DT30.2
7 = Dishonored DT40.1 DT42.1
8 = Canceled DT45.1 DT520
9 = Historical DT60.1 DT60.2
5 = Created/unrel DT70.1 DT70.3
DT80.1 DT85.1
DT85.2 DT90.1
DT92.1
ARD-PRINT-FLAG Alpha 1 AR42.1 AR42.2
Element: Print Flag Indicates whether the bill of exchange AR42.6 AR42.7
has been created by DT155 (Bill of AR43.1 AR44.3
Exchange Print - Tape Create). Valid AR502 AR560
values are: ARLL.1 DT150
DT155 DT160
N = No DT165 DT166
Y = Yes DT180 DT30.1
DT30.2 DT40.1
DT45.1 DT520
DT60.1 DT60.2
DT70.1 DT70.3
DT80.1 DT85.1
DT85.2 DT92.1
ARD-POSTAL-CODE Alpha 10 (Lower Case) AR42.1 AR42.2
Element: Postal Code The postal code of the customer's AR42.6 AR42.7
payment bank. AR43.1 AR44.3
AR502 AR560
ARLL.1 DT150
DT155 DT160
DT165 DT166
DT180 DT30.1
DT30.2 DT40.1
DT42.1 DT45.1
DT520 DT60.1
DT60.2 DT70.1
DT70.3 DT80.1
DT85.1 DT85.2
DT92.1
ARD-BANK-ENTITY Alpha 15 AR42.1 AR42.2
Element: Bank The bank location the customer is AR42.6 AR42.7
paying the bill of exchange from. AR43.1 AR44.3
AR502 AR560
ARLL.1 DT150
DT155 DT160
DT165 DT166
DT180 DT30.1
DT30.2 DT40.1
DT42.1 DT45.1
DT520 DT60.1
DT60.2 DT70.1
DT70.3 DT80.1
DT85.1 DT85.2
DT92.1
ARD-BANK-ACCT-NBR Alpha 35 AR42.1 AR42.2
Element: Bank Acct Nbr The bank account within the bank AR42.6 AR42.7
location that the customer will be AR43.1 AR44.3
paying the bill of exchange from. AR502 AR560
ARLL.1 DT150
DT155 DT160
DT165 DT166
DT180 DT30.1
DT30.2 DT40.1
DT42.1 DT45.1
DT520 DT60.1
DT60.2 DT70.1
DT70.3 DT80.1
DT85.1 DT85.2
DT92.1
ARD-ORIG-REV-AMT Signed 18.2 AR42.1 AR42.2
Element: Revenue AmountThe amount of additional revenue AR42.6 AR42.7
charged to a customer for processing the AR43.1 AR44.3
bill of exchange. This amount is in the AR502 AR560
company base currency. ARLL.1 DT150
DT155 DT160
DT165 DT166
DT180 DT30.1
DT30.2 DT40.1
DT45.1 DT520
DT60.1 DT60.2
DT70.1 DT70.3
DT80.1 DT85.1
DT85.2 DT92.1
ARD-REVENUE-AMT Signed 18.2 AR42.1 AR42.2
Base Currency The amount of additional revenue AR42.6 AR42.7
Revenue Amount charged to customer for processing the AR43.1 AR44.3
bill of exchange. This amount is in the AR502 AR560
currency of the bill of exchange. ARLL.1 DT150
DT155 DT160
DT165 DT166
DT180 DT30.1
DT30.2 DT40.1
DT45.1 DT520
DT60.1 DT60.2
DT70.1 DT70.3
DT80.1 DT85.1
DT85.2 DT92.1
ARD-REV-ACCT-UNIT Alpha 15 AR42.1 AR42.2
Revenue Accounting The general ledger revenue accounting AR42.6 AR42.7
Unit unit for the additional revenue charged. AR43.1 AR44.3
AR502 AR560
ARLL.1 DT150
DT155 DT160
DT165 DT166
DT180 DT30.1
DT30.2 DT40.1
DT45.1 DT520
DT60.1 DT60.2
DT70.1 DT70.3
DT80.1 DT85.1
DT85.2 DT92.1
ARD-REV-ACCOUNT Numeric 6 AR42.1 AR42.2
Revenue Account The general ledger revenue account AR42.6 AR42.7
Number number for the additional revenue AR43.1 AR44.3
charged. AR502 AR560
ARLL.1 DT150
DT155 DT160
DT165 DT166
DT180 DT30.1
DT30.2 DT40.1
DT45.1 DT520
DT60.1 DT60.2
DT70.1 DT70.3
DT80.1 DT85.1
DT85.2 DT92.1
ARD-REV-SUB-ACCT Numeric 4 AR42.1 AR42.2
Revenue Subaccount The general ledger revenue subaccount AR42.6 AR42.7
Number number for the additional revenue AR43.1 AR44.3
charged. AR502 AR560
ARLL.1 DT150
DT155 DT160
DT165 DT166
DT180 DT30.1
DT30.2 DT40.1
DT45.1 DT520
DT60.1 DT60.2
DT70.1 DT70.3
DT80.1 DT85.1
DT85.2 DT92.1
ARD-ORIG-BNK-EXP Signed 18.2 AR42.1 AR42.2
Element: Bank Expense AThe expense incurred in the process of AR42.6 AR42.7
cashing the bill of exchange. This AR43.1 AR44.3
amount is in the currency of the bill of AR502 AR560
exchange. ARLL.1 DT150
DT155 DT160
DT165 DT166
DT180 DT30.1
DT30.2 DT40.1
DT45.1 DT520
DT60.1 DT60.2
DT70.1 DT70.3
DT80.1 DT85.1
DT85.2 DT92.1
ARD-BNK-EXP-AMT Signed 18.2 AR42.1 AR42.2
Base Currency Bank The expense incurred in the process of AR42.6 AR42.7
Expense Amt cashing the bill of exchange. This AR43.1 AR44.3
amount is in the company base currency. AR502 AR560
ARLL.1 DT150
DT155 DT160
DT165 DT166
DT180 DT30.1
DT30.2 DT40.1
DT45.1 DT520
DT60.1 DT60.2
DT70.1 DT70.3
DT80.1 DT85.1
DT85.2 DT92.1
ARD-BEXP-ACCT-UNIT Alpha 15 AR42.1 AR42.2
Element: Acct Unit The accounting unit used for posting AR42.6 AR42.7
the bank expenses. AR43.1 AR44.3
AR502 AR560
ARLL.1 DT150
DT155 DT160
DT165 DT166
DT180 DT30.1
DT30.2 DT40.1
DT45.1 DT520
DT60.1 DT60.2
DT70.1 DT70.3
DT80.1 DT85.1
DT85.2 DT92.1
ARD-BEXP-ACCOUNT Numeric 6 AR42.1 AR42.2
Bank Expense The account number used for posting the AR42.6 AR42.7
Account Number bank expenses. AR43.1 AR44.3
AR502 AR560
ARLL.1 DT150
DT155 DT160
DT165 DT166
DT180 DT30.1
DT30.2 DT40.1
DT45.1 DT520
DT60.1 DT60.2
DT70.1 DT70.3
DT80.1 DT85.1
DT85.2 DT92.1
ARD-BEXP-SUB-ACCT Numeric 4 AR42.1 AR42.2
Bank Expense The subaccount number used for posting AR42.6 AR42.7
Subaccount Number the bank expenses. AR43.1 AR44.3
AR502 AR560
ARLL.1 DT150
DT155 DT160
DT165 DT166
DT180 DT30.1
DT30.2 DT40.1
DT45.1 DT520
DT60.1 DT60.2
DT70.1 DT70.3
DT80.1 DT85.1
DT85.2 DT92.1
ARD-ORIG-DIS-EXP Signed 18.2 AR42.1 AR42.2
Dishonor Expense The amount of expense incurred during AR42.6 AR42.7
Amount the dishonoring of the bill of exchange. AR43.1 AR44.3
This amount is in the currency of the AR502 AR560
bill of exchange. ARLL.1 DT150
DT155 DT160
DT165 DT166
DT180 DT30.1
DT30.2 DT40.1
DT45.1 DT520
DT60.1 DT60.2
DT70.1 DT70.3
DT80.1 DT85.1
DT85.2 DT90.1
DT92.1
ARD-DIS-EXP-AMT Signed 18.2 AR42.1 AR42.2
Base Curr Dishonor The amount of the expense incurred AR42.6 AR42.7
Expense Amt during the dishonoring of the bill of AR43.1 AR44.3
exchange. This amount is in the company AR502 AR560
base currency. ARLL.1 DT150
DT155 DT160
DT165 DT166
DT180 DT30.1
DT30.2 DT40.1
DT45.1 DT520
DT60.1 DT60.2
DT70.1 DT70.3
DT80.1 DT85.1
DT85.2 DT90.1
DT92.1
ARD-DEXP-ACCT-UNIT Alpha 15 AR42.1 AR42.2
Dishonor Expense The accounting unit used for posting AR42.6 AR42.7
Accounting Un the dishonor expense. AR43.1 AR44.3
AR502 AR560
ARLL.1 DT150
DT155 DT160
DT165 DT166
DT180 DT30.1
DT30.2 DT40.1
DT45.1 DT520
DT60.1 DT60.2
DT70.1 DT70.3
DT80.1 DT85.1
DT85.2 DT90.1
DT92.1
ARD-DEXP-ACCOUNT Numeric 6 AR42.1 AR42.2
Dishonor Expense The account number used for posting the AR42.6 AR42.7
Account dishonor expense. AR43.1 AR44.3
AR502 AR560
ARLL.1 DT150
DT155 DT160
DT165 DT166
DT180 DT30.1
DT30.2 DT40.1
DT45.1 DT520
DT60.1 DT60.2
DT70.1 DT70.3
DT80.1 DT85.1
DT85.2 DT90.1
DT92.1
ARD-DEXP-SUB-ACCT Numeric 4 AR42.1 AR42.2
Dishonor Expense The subaccount number used for posting AR42.6 AR42.7
Subaccount the dishonor expense. AR43.1 AR44.3
AR502 AR560
ARLL.1 DT150
DT155 DT160
DT165 DT166
DT180 DT30.1
DT30.2 DT40.1
DT45.1 DT520
DT60.1 DT60.2
DT70.1 DT70.3
DT80.1 DT85.1
DT85.2 DT90.1
DT92.1
ARD-DRAFT-CODE Alpha 4 AR42.1 AR42.2
Bill of Exchange The bill of exchange receivable code AR42.6 AR42.7
Code used for posting the bill of exchange to AR43.1 AR44.3
the general ledger. This will be filled AR502 AR560
if the asset has been transferred from ARLL.1 DT150
Accounts Receivable to Bill of Exchange DT155 DT160
Receivable. DT165 DT166
DT180 DT30.1
DT30.2 DT40.1
DT45.1 DT520
DT60.1 DT60.2
DT70.1 DT70.3
DT80.1 DT85.1
DT85.2 DT92.1
ARD-CASH-UPDATE-FL Alpha 1 AR42.1 AR42.2
Element: Cashing UpdateIndicates whether the bill of exchange AR42.6 AR42.7
has been processed through DT180 (Bank AR43.1 AR44.3
Presentation, Cashing Update). Valid AR502 AR560
values are: ARLL.1 DT150
DT155 DT160
N = No DT165 DT166
Y = Yes DT180 DT181
DT30.1 DT30.2
DT40.1 DT45.1
DT520 DT60.1
DT60.2 DT70.1
DT70.3 DT80.1
DT85.1 DT85.2
DT92.1
ARD-AR-CODE Alpha 4 AR42.1 AR42.2
Element: Ar Code The accounts receivable code assigned AR42.6 AR42.7
to the bill of exchange during creation. AR43.1 AR44.3
If the bill of exchange is for one AR502 AR560
invoice, the account receivable code ARLL.1 DT150
assigned to the invoice is used. If the DT155 DT160
bill of exchange is for more than one DT165 DT166
invoice, the accounts receivable code DT180 DT30.1
assigned to the process level is used. DT30.2 DT40.1
DT45.1 DT520
DT60.1 DT60.2
DT70.1 DT70.3
DT80.1 DT85.1
DT85.2 DT92.1
ARD-DRAFT-REF Numeric 10 AR42.1 AR42.2
Bill of Exchange An optional reference number assigned AR42.6 AR42.7
Reference Nbr to the bill of exchange. AR43.1 AR44.3
AR502 AR560
ARLL.1 DT150
DT155 DT160
DT165 DT166
DT180 DT30.1
DT30.2 DT40.1
DT45.1 DT520
DT60.1 DT60.2
DT70.1 DT70.3
DT80.1 DT85.1
DT85.2 DT92.1
ARD-UNPAYMENT-CODE Alpha 4 AR42.1 AR42.2
Element: Dishonored CodThe general ledger code used in the AR42.6 AR42.7
dishonoring of a bill of exchange. AR43.1 AR44.3
AR502 AR560
ARLL.1 DT150
DT155 DT160
DT165 DT166
DT180 DT30.1
DT30.2 DT40.1
DT45.1 DT520
DT60.1 DT60.2
DT70.1 DT70.3
DT80.1 DT85.1
DT85.2 DT90.1
DT92.1
ARD-RISK-FL Alpha 1 AR42.1 AR42.2
Element: Risk Flag Indicates whether the bill of exchange AR42.6 AR42.7
is at risk with the bank (cashed at a AR43.1 AR44.3
discount before its due date and has not AR502 AR560
yet reached its due date). Valid values ARLL.1 DT150
are: DT155 DT160
DT165 DT166
N = No DT170 DT180
Y = Yes DT30.1 DT30.2
DT40.1 DT45.1
DT520 DT60.1
DT60.2 DT70.1
DT70.3 DT80.1
DT85.1 DT85.2
DT92.1
ARD-DIS-UPDATE-FL Alpha 1 AR42.1 AR42.2
Dishonored Update Indicates whether a dishonored bill of AR42.6 AR42.7
Flag exchange has been processed by DT180 AR43.1 AR44.3
(Bank Presentation, Cashing Update). AR502 AR560
Valid values are: ARLL.1 DT150
DT155 DT160
Blank = Not dishonored DT165 DT166
P = Post presented BOE DT180 DT185
R = Post cash at risk BOE DT30.1 DT30.2
DT40.1 DT45.1
DT520 DT60.1
DT60.2 DT70.1
DT70.3 DT80.1
DT85.1 DT85.2
DT90.1 DT92.1
ARD-PRES-UPDATE-FL Alpha 1 AR42.1 AR42.2
Presentation Update Indicates whether the bill of exchange AR42.6 AR42.7
Flag presentation has been processed by DT180 AR43.1 AR44.3
(Bank Presentation, Cashing Update). AR502 AR560
Valid values are: ARLL.1 DT150
DT155 DT160
N = No DT165 DT166
Y = Yes DT180 DT181
DT30.1 DT30.2
DT40.1 DT45.1
DT520 DT60.1
DT60.2 DT70.1
DT70.3 DT80.1
DT85.1 DT85.2
DT92.1
ARD-RESOLUTION-FL Alpha 1 AR42.1 AR42.2
Dishonored If the bill of exchange has been AR42.6 AR42.7
Resolution Flag dishonored, this field indicates how the AR43.1 AR44.3
dishonored bill of exchange was AR502 AR560
resolved. Valid values are: ARLL.1 DT150
DT155 DT160
Blank = Not resolved DT165 DT166
1 = Cashed DT180 DT30.1
2 = Written Off DT30.2 DT40.1
3 = Renegotiated DT45.1 DT520
DT60.1 DT60.2
DT70.1 DT70.3
DT80.1 DT85.1
DT85.2 DT92.1
ARD-COMMENT-CD Numeric 3 AR42.1 AR42.2
Element: Comment Cd Indicates the number of comment lines AR42.6 AR42.7
that have been created for a bill of AR43.1 AR44.3
exchange. AR502 AR560
ARLL.1 DT150
DT155 DT160
DT165 DT166
DT180 DT30.1
DT30.2 DT40.1
DT42.1 DT45.1
DT520 DT60.1
DT60.2 DT70.1
DT70.3 DT80.1
DT85.1 DT85.2
DT92.1
ARD-STATUS-DATE Derived
Element: Status Date This derived field indicates the date
the system assigned the bill of exchange
its current status. This field changes
each time the bill of exchange status
changes as it proceeds along its cycle.
ARD-RESOLVED-STS Derived
Element: Resolved StatuThis derived field indicates the type
of resolution associated with a
dishonored bill of exchange.
ARD-JRNL-BOOK-NBR Alpha 12 AR42.1 AR42.2
Element: Jrnl Book Nbr The journal book assigned to the bill AR42.6 AR42.7
of exchange. AR43.1 AR44.3
AR502 AR560
ARLL.1 DT150
DT155 DT160
DT165 DT166
DT180 DT30.1
DT30.2 DT40.1
DT45.1 DT520
DT60.1 DT60.2
DT70.1 DT70.3
DT80.1 DT85.1
DT85.2 DT92.1
ARD-PAYER-REF Alpha 10 AR42.1 AR42.2
Element: Payer's RefereContains bank reference information for AR42.6 AR42.7
manually entered bills of exchange. AR43.1 AR44.3
AR502 AR560
ARLL.1 DT150
DT155 DT160
DT165 DT166
DT180 DT30.1
DT30.2 DT40.1
DT42.1 DT45.1
DT520 DT60.1
DT60.2 DT70.1
DT70.3 DT80.1
DT85.1 DT85.2
DT92.1
ARD-PMT-BATCH-NBR Numeric 6 AR42.1 AR42.2
Element: Pmt Batch Nbr The draft batch number which is also AR42.6 AR42.7
used as the batch number when creating AR43.1 AR44.3
payment records. AR502 AR560
ARLL.1 DT150
DT155 DT160
DT165 DT166
DT180 DT30.1
DT30.2 DT40.1
DT45.1 DT520
DT60.1 DT60.2
DT70.1 DT70.3
DT80.1 DT85.1
DT85.2 DT92.1
ARD-ORIG-APP-AMT Signed 18.2 AR129 AR130
Element: Intl Amt AR131 AR135
AR30.1 AR33.1
AR33.6 AR39.1
AR39.2 AR42.1
AR42.2 AR42.6
AR42.7 AR43.1
AR44.3 AR48.3
AR502 AR560
ARLL.1 DT150
DT155 DT160
DT165 DT166
DT180 DT30.1
DT30.2 DT40.1
DT45.1 DT520
DT60.1 DT60.2
DT70.1 DT70.3
DT80.1 DT85.1
DT85.2 DT92.1
ARD-APPLD-AMT Signed 18.2 AR129 AR130
Element: Intl Amt AR131 AR135
AR30.1 AR33.1
AR33.6 AR39.1
AR39.2 AR42.1
AR42.2 AR42.6
AR42.7 AR43.1
AR44.3 AR48.3
AR502 AR560
ARLL.1 DT150
DT155 DT160
DT165 DT166
DT180 DT30.1
DT30.2 DT40.1
DT45.1 DT520
DT60.1 DT60.2
DT70.1 DT70.3
DT80.1 DT85.1
DT85.2 DT92.1
ARDRAFTS FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ARDSET1 COMPANY AR258 AR37.6
AR-DRAFT-NBR AR37.8 AR42.1
SUFFIX AR42.2 AR42.6
CUSTOMER AR42.7 AR43.1
CANCEL-SEQ AR44.3 AR502
DRAFT-SOURCE AR560 AR80.2
ARLL.1 DT150
DT155 DT160
DT161 DT165
DT166 DT17.1
DT170 DT180
DT185 DT190
DT220 DT270
DT280 DT30.1
DT30.2 DT40.1
...
ARDSET10 COMPANY Subset AR42.1 AR42.2
AR-DRAFT-NBR Where BANK-INST-CODE != Spaces AR42.6 AR42.7
SUFFIX AR43.1 AR44.3
CUSTOMER AR502 AR560
CANCEL-SEQ ARLL.1 DT150
DRAFT-SOURCE DT155 DT160
BANK-INST-CODE DT165 DT166
DT180 DT30.1
DT30.2 DT40.1
DT45.1 DT520
DT60.1 DT60.2
DT70.1 DT70.3
DT80.1 DT85.1
DT85.2 DT92.1
ARDSET2 COMPANY Subset AR42.1 AR42.2
CUSTOMER Where STATUS = Zeroes AR42.6 AR42.7
MATURITY-DATE Or STATUS = 1 AR43.1 AR44.3
AR-DRAFT-NBR AR502 AR560
SUFFIX AR72.1 ARLL.1
DT150 DT155
DT160 DT165
DT166 DT180
DT30.1 DT30.2
DT40.1 DT45.1
DT520 DT60.1
DT60.2 DT70.1
DT70.3 DT80.1
DT85.1 DT85.2
DT92.1
ARDSET3 REMIT-COMPANY Subset AR42.1 AR42.2
REMIT-PROC-LEVWhere STATUS = 1 AR42.6 AR42.7
CASH-CODE Or STATUS = 2 AR43.1 AR44.3
REMIT-TYPE AR502 AR560
MATURITY-DATE ARLL.1 DT150
CUSTOMER DT155 DT160
AR-DRAFT-NBR DT161 DT165
SUFFIX DT166 DT180
DT30.1 DT30.2
DT40.1 DT45.1
DT520 DT60.1
DT60.2 DT70.1
DT70.3 DT80.1
DT85.1 DT85.2
DT92.1
ARDSET4 REMIT-COMPANY Subset AR42.1 AR42.2
REMIT-PROC-LEVWhere STATUS = 1 AR42.6 AR42.7
CASH-CODE Or STATUS = 2 AR43.1 AR44.3
REMIT-TYPE AR502 AR560
AR-DRAFT-NBR ARLL.1 DT150
SUFFIX DT155 DT160
CUSTOMER DT165 DT166
MATURITY-DATE DT180 DT30.1
DT30.2 DT40.1
DT45.1 DT520
DT60.1 DT60.2
DT70.1 DT70.3
DT80.1 DT85.1
DT85.2 DT92.1
ARDSET5 REMIT-COMPANY Subset AR42.1 AR42.2
REMIT-PROC-LEVWhere REMIT-NBR != Zeroes AR42.6 AR42.7
REMIT-NBR AR43.1 AR44.3
CUSTOMER AR502 AR560
AR-DRAFT-NBR ARLL.1 DT150
SUFFIX DT155 DT160
COMPANY DT165 DT166
CANCEL-SEQ DT180 DT181
DRAFT-SOURCE DT30.1 DT30.2
DT40.1 DT45.1
DT520 DT60.1
DT60.2 DT70.1
DT70.3 DT80.1
DT85.1 DT85.2
DT92.1
ARDSET6 COMPANY Subset AR271 AR275
CUSTOMER Where STATUS < 7 DT180
AR-DRAFT-NBR Or (STATUS = 7
SUFFIX And RESOLUTION-FL = Spaces )
CANCEL-SEQ
DRAFT-SOURCE
ARDSET7 COMPANY KeyChange, Subset DT40.1
CUSTOMER Where STATUS < 7
AR-DRAFT-NBR Or STATUS = 6
SUFFIX And RISK-FL = "Y"
ARDSET8 COMPANY Subset DT92.1
CUSTOMER Where STATUS = 7
AR-DRAFT-NBR And RESOLUTION-FL != "1"
SUFFIX And RESOLUTION-FL != "2"
MATURITY-DATE And RESOLUTION-FL != "3"
ARDSET9 COMPANY AR129 AR130
CUSTOMER AR131 AR135
AR-DRAFT-NBR AR150 AR161
SUFFIX AR194 AR250
CANCEL-SEQ AR251 AR252
DRAFT-SOURCE AR253 AR255
AR256 AR286
AR287 AR294
AR30.1 AR33.1
AR33.6 AR39.1
AR39.2 AR48.3
AR50.1 AR505
AR53.1 AR90.1
DT180 DT185
DT270 DT280
...
ARDRAFTS FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Arcomp ARCOMP Required
ARD-COMPANY -> ACO-COMPANY
Arcustgrp ARCUSTGRP Required
ACO-CUST-GROUP -> ACG-CUST-GROUP
Arcustomer ARCUSTOMER Required
ARD-COMPANY -> ACM-COMPANY
ARD-CUSTOMER -> ACM-CUSTOMER
Cbbankinst CBBANKINST Required
ARD-BANK-INST-CODE -> CBI-BANK-INST-CODE
Cbcpycash CBCPYCASH Required
When ARD-STATUS > 2
And ARD-STATUS != 8
ARD-COMPANY -> CBY-COMPANY
ARD-CASH-CODE -> CBY-CASH-CODE
Cust Bankent CBBANKENT Required
DTB-BANK-ENTITY -> CBE-BANK-ENTITY
Custdesc CUSTDESC Required
ACO-CUST-GROUP -> CUD-CUST-GROUP
ARD-CUSTOMER -> CUD-CUSTOMER
Dtcustbank DTCUSTBANK Required
ACO-CUST-GROUP -> DTB-CUST-GROUP
ARD-COMPANY -> DTB-COMPANY
ARD-CUSTOMER -> DTB-CUSTOMER
Dtremit DTREMIT Required
When ARD-REMIT-NBR != Zeroes
ARD-REMIT-COMPANY -> DRM-COMPANY
ARD-REMIT-PROC-LEV -> DRM-PROCESS-LEVEL
ARD-CASH-CODE -> DRM-CASH-CODE
ARD-REMIT-TYPE -> DRM-REMIT-TYPE
ARD-REMIT-NBR -> DRM-REMIT-NBR
ARD-MATURITY-DATE -> DRM-MATURITY-DATE
Glsystem GLSYSTEM Required
ARD-COMPANY -> GLS-COMPANY
ARDRAFTS FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Arapplied ARAPPLIED Delete Restricted
ARD-COMPANY -> ARA-CR-COMPANY
ARD-CUSTOMER -> ARA-CR-CUSTOMER
"B" -> ARA-CR-TYPE
ARD-AR-DRAFT-NBR -> ARA-CR-NBR
Zeroes -> ARA-CR-PYMNT-SEQ
Zeroes -> ARA-CR-BATCH
ARD-SUFFIX -> ARA-CR-SUFFIX
ARD-CANCEL-SEQ -> ARA-CR-CANCEL-SEQ
ARA-CR-APP-SEQ
Dtcomment DTCOMMENT Delete Cascades
ARD-COMPANY -> DMT-COMPANY
ARD-CUSTOMER -> DMT-CUSTOMER
ARD-AR-DRAFT-NBR -> DMT-AR-DRAFT-NBR
ARD-SUFFIX -> DMT-SUFFIX
ARD-DRAFT-SOURCE -> DMT-DRAFT-SOURCE
DMT-SEQ-NBR
Dtcredit DTCREDIT
ARD-COMPANY -> DTX-COMPANY
ARD-AR-DRAFT-NBR -> DTX-AR-DRAFT-NBR
ARD-SUFFIX -> DTX-SUFFIX
ARD-CUSTOMER -> DTX-CUSTOMER
ARD-CANCEL-SEQ -> DTX-CANCEL-SEQ
ARD-DRAFT-SOURCE -> DTX-DRAFT-SOURCE
DTX-APP-SEQ
|