 |
Lawson Insight Technical Documentation |
|
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 DA90.1 DA91.1
DT95.1
UPDATED BY
AR129 AR130 AR131 AR135 AR30.3 AR31.6
AR42.1 AR42.2 AR42.6 AR42.7 AR43.1 AR44.3
AR48.3 AR502 AR560 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
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
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
Ar Draft Nbr AR42.6 AR42.7
AR43.1 AR44.3
AR502 AR560
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 DT150 DT155
of a multiple payment invoice. 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
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 DT150 DT155
record in the AR Company Customer file. 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
Cancel Sequence The sequence number assigned upon a AR42.6 AR42.7
cancellation of a distributed invoice. AR43.1 AR44.3
The first sequence assigned is 9999. AR502 AR560
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 DT150 DT155
was created by the vendor (accounts DT160 DT165
receivable). DT166 DT180
DT30.1 DT30.2
P = Payable. The bill of exchange was DT40.1 DT42.1
created by the customer (accounts DT45.1 DT520
payable). DT60.1 DT60.2
DT70.1 DT70.3
I = Interfaced. The bill of exchange DT80.1 DT85.1
was created by an interfacing system, DT85.2 DT92.1
such as an order entry system.
ARD-APP-SEQ Numeric 5 AR129 AR130
Application Sequence The counter for the number of AR131 AR135
applications used in the Accounts AR30.3 AR31.6
Receivable Application file. AR42.1 AR42.2
AR42.6 AR42.7
AR43.1 AR44.3
AR48.3 AR502
AR560 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
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
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
Payment Code The bill of exchange payment AR42.6 AR42.7
transaction code assigned to the bill of AR43.1 AR44.3
exchange. Represents the type of bill of AR502 AR560
exchange payment. Must be a valid record DT150 DT155
in the Cash Ledger Bank Transaction Code DT160 DT161
file. 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
Remittance 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. 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
Remittance Process This field contains remittance process AR42.6 AR42.7
Level 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 DT150 DT155
file. 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
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. 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
Remittance 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
DT150 DT155
D = Discounted remittance DT160 DT161
DT165 DT166
E = Encashed remittance; full value DT180 DT30.1
upon due date DT30.2 DT40.1
DT45.1 DT520
Blank = Not included in a remittance 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
Remittance 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. 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 12.6 AR42.1 AR42.2
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
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
Group The multiplier or divisor indicator for AR42.6 AR42.7
Multiply/Divide the group rate. AR43.1 AR44.3
AR502 AR560
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
Transaction Currency The 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
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
Currency The multiplier or divisor indicator AR42.6 AR42.7
Multiply/Divide used to convert the transaction currency AR43.1 AR44.3
amount to the company base currency. AR502 AR560
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
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 12.6 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
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 12.6 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
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 15.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 DA90.1
DA91.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
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 15.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 DA90.1
DA91.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
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
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
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
Acceptance Date The 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
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. 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
Remittance 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 DT150 DT155
bank for cashing. 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
Cash Date The date the bill of exchange was AR42.6 AR42.7
cashed. AR43.1 AR44.3
AR502 AR560
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
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
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
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
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
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
Status Indicates the status of the bill of AR42.6 AR42.7
exchange. Valid values are: AR43.1 AR44.3
AR502 AR560
0 = Created DT150 DT155
1 = Accepted DT160 DT161
2 = Selected for Remittance DT165 DT166
3 = Included in Remittance DT170 DT180
4 = Presented DT181 DT30.1
6 = Cashed DT30.2 DT40.1
7 = Dishonored DT42.1 DT45.1
8 = Canceled DT520 DT60.1
9 = Historical DT60.2 DT70.1
5 = Created/unrel DT70.3 DT80.1
DT85.1 DT85.2
DT90.1 DT92.1
ARD-PRINT-FLAG Alpha 1 AR42.1 AR42.2
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: DT150 DT155
DT160 DT165
N = No DT166 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-POSTAL-CODE Alpha 10 (Lower Case) AR42.1 AR42.2
Postal Code The postal code of the customer's AR42.6 AR42.7
payment bank. AR43.1 AR44.3
AR502 AR560
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
Bank The bank location the customer is AR42.6 AR42.7
paying the bill of exchange from. AR43.1 AR44.3
AR502 AR560
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 17 AR42.1 AR42.2
Bank Account Number 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
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 15.2 AR42.1 AR42.2
Revenue Amount The 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. 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 15.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. 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
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
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
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 15.2 AR42.1 AR42.2
Bank Expense Amount The 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. 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 15.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
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
Bank Expense The accounting unit used for posting AR42.6 AR42.7
Accounting Unit the bank expenses. AR43.1 AR44.3
AR502 AR560
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
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
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 15.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. 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 15.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. 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
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
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
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 DT150 DT155
Accounts Receivable to Bill of Exchange DT160 DT165
Receivable. 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
Cashing Update Flag Indicates 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: DT150 DT155
DT160 DT165
N = No DT166 DT180
Y = Yes 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
Accounts Receivable The accounts receivable code assigned AR42.6 AR42.7
Code 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 DT150 DT155
assigned to the invoice is used. If the DT160 DT165
bill of exchange is for more than one DT166 DT180
invoice, the accounts receivable code DT30.1 DT30.2
assigned to the process level is used. 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
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
Dishonored Code The general ledger code used in the AR42.6 AR42.7
dishonoring of a bill of exchange. AR43.1 AR44.3
AR502 AR560
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
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 DT150 DT155
are: DT160 DT165
DT166 DT170
N = No DT180 DT30.1
Y = Yes 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: DT150 DT155
DT160 DT165
Blank = Not dishonored DT166 DT180
P = Post presented BOE DT185 DT30.1
R = Post cash at risk BOE 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: DT150 DT155
DT160 DT165
N = No DT166 DT180
Y = Yes 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: DT150 DT155
DT160 DT165
Blank = Not resolved DT166 DT180
1 = Cashed DT30.1 DT30.2
2 = Written Off DT40.1 DT45.1
3 = Renegotiated 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
Comment Code 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
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
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
Resolved Status This derived field indicates the type
of resolution associated with a
dishonored bill of exchange.
ARD-JRNL-BOOK-NBR Alpha 12 AR42.1 AR42.2
Journal Book The journal book assigned to the bill AR42.6 AR42.7
of exchange. AR43.1 AR44.3
AR502 AR560
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
Payer's Reference Contains bank reference information for AR42.6 AR42.7
manually entered bills of exchange. AR43.1 AR44.3
AR502 AR560
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
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
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 15.2 AR129 AR130
Original Payment AR131 AR135
Amount AR30.3 AR31.6
AR42.1 AR42.2
AR42.6 AR42.7
AR43.1 AR44.3
AR48.3 AR502
AR560 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 15.2 AR129 AR130
Applied Amount AR131 AR135
AR30.3 AR31.6
AR42.1 AR42.2
AR42.6 AR42.7
AR43.1 AR44.3
AR48.3 AR502
AR560 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 This is the primary path for accessing AR258 AR37.6
AR-DRAFT-NBR records. AR37.8 AR42.1
SUFFIX AR42.2 AR42.6
CUSTOMER AR42.7 AR43.1
CANCEL-SEQ AR44.3 AR502
DRAFT-SOURCE AR560 AR80.2
DT150 DT155
DT160 DT161
DT165 DT166
DT17.1 DT170
DT180 DT185
DT190 DT220
DT270 DT280
DT30.1 DT30.2
DT40.1 DT42.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 DT150 DT155
DRAFT-SOURCE DT160 DT165
BANK-INST-CODE 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 This path is used in the acceptance AR42.1 AR42.2
CUSTOMER process. AR42.6 AR42.7
MATURITY-DATE Subset AR43.1 AR44.3
AR-DRAFT-NBR Where STATUS = Zeroes AR502 AR560
SUFFIX Or STATUS = 1 AR72.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 This path is used in the remittance AR42.1 AR42.2
REMIT-PROC-LEVselection process. This path spans AR42.6 AR42.7
CASH-CODE records that are ready for selection (in AR43.1 AR44.3
REMIT-TYPE accepted status) and those already AR502 AR560
MATURITY-DATE selected. DT150 DT155
CUSTOMER Subset DT160 DT161
AR-DRAFT-NBR Where STATUS = 1 DT165 DT166
SUFFIX Or STATUS = 2 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 This path is used in the remittance AR42.1 AR42.2
REMIT-PROC-LEVselection process. This path spans AR42.6 AR42.7
CASH-CODE records that are ready for selection (in AR43.1 AR44.3
REMIT-TYPE accepted status) and those already AR502 AR560
AR-DRAFT-NBR selected. DT150 DT155
SUFFIX Subset DT160 DT165
CUSTOMER Where STATUS = 1 DT166 DT180
MATURITY-DATE Or STATUS = 2 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 This path is used in the presentation AR42.1 AR42.2
REMIT-PROC-LEVprocess of all remittances and the AR42.6 AR42.7
REMIT-NBR cashing process of discounted AR43.1 AR44.3
CUSTOMER remittances. AR502 AR560
AR-DRAFT-NBR Subset DT150 DT155
SUFFIX Where REMIT-NBR != Zeroes DT160 DT165
COMPANY DT166 DT180
CANCEL-SEQ DT181 DT30.1
DRAFT-SOURCE 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 This path is used in the automatic AR271 AR275
CUSTOMER cashing process. AR72.1 DT180
AR-DRAFT-NBR Subset
SUFFIX Where STATUS < 7
CANCEL-SEQ Or (STATUS = 7
DRAFT-SOURCE And RESOLUTION-FL = Spaces )
ARDSET7 COMPANY This path is used to validate a bill of DT40.1
CUSTOMER exchange in the re-creation process.
AR-DRAFT-NBR KeyChange, Subset
SUFFIX Where STATUS < 7
Or STATUS = 6
And RISK-FL = "Y"
ARDSET8 COMPANY This path is used in the dishonor DT92.1
CUSTOMER resolution process. This path spans
AR-DRAFT-NBR records that are dishonored and can be
SUFFIX resolved.
MATURITY-DATE Subset
Where STATUS = 7
And RESOLUTION-FL != "1"
And RESOLUTION-FL != "2"
And RESOLUTION-FL != "3"
ARDSET9 COMPANY This is an alternate path used to span AR129 AR130
CUSTOMER records in customer order. AR131 AR135
AR-DRAFT-NBR AR150 AR161
SUFFIX AR194 AR250
CANCEL-SEQ AR251 AR252
DRAFT-SOURCE AR253 AR255
AR256 AR286
AR287 AR294
AR30.3 AR31.6
AR48.3 AR50.1
AR505 AR53.1
AR90.1 DA90.1
DA91.1 DT180
DT185 DT270
DT280 DT40.1
...
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
|