APDRAFTS FILE
AP Bill of Exchange
The Accounts Payable Bill of Exchange file contains bill of exchange payment
records.
REFERENCED BY
AP213 AP260 AP284 AP230 AP250 AP266
AP300 AP214 AP91.2 AP91.1
UPDATED BY
AP125 AP126 AP151 AP156 AP166 AP167
AP180 AP181 AP20.1 AP20.2 AP20.5 AP20.7
AP20.8 AP23.1 AP25.1 AP25.2 AP26.1 AP28.1
AP28.2 AP305 AP56.1 AP56.2 AP80.1 AP954
CB300 MA40.1 MA40.2 MA41.1 MA41.2 MA41.4
MA41.5 MA41.6 MA43.1 MA43.2 MA43.3 MA43.4
MA52.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
APT-PAY-GROUP Alpha 4 AP125 AP126
Pay Group The pay group associated with the bill AP151 AP156
of exchange payment. A pay group is used AP180 AP20.1
for processing accounts payable AP20.2 AP20.5
payments. Must be a valid record in the AP20.7 AP20.8
Pay Group file. AP23.1 AP25.1
AP25.2 AP26.1
AP28.1 AP28.2
AP56.1 AP56.2
AP80.1 AP954
MA40.1 MA40.2
MA41.1 MA41.2
MA41.4 MA41.5
MA41.6 MA43.1
MA43.2 MA43.3
MA43.4 MA52.1
APT-COMPANY Numeric 4 AP125 AP126
Company The company associated with the bill of AP151 AP156
exchange payment. Must be a valid record AP180 AP20.1
in the Accounts Payable Company file. AP20.2 AP20.5
AP20.7 AP20.8
AP23.1 AP25.1
AP25.2 AP26.1
AP28.1 AP28.2
AP56.1 AP56.2
AP80.1 AP954
MA40.1 MA40.2
MA41.1 MA41.2
MA41.4 MA41.5
MA41.6 MA43.1
MA43.2 MA43.3
MA43.4 MA52.1
APT-TRANS-IDENT Numeric 10 AP125 AP126
Transaction ID A unique system-generated AP151 AP156
identification value assigned to the AP180 AP20.1
bill of exchange payment transaction to AP20.2 AP20.5
make this record unique. AP20.7 AP20.8
AP23.1 AP25.1
AP25.2 AP26.1
AP28.1 AP28.2
AP56.1 AP56.2
AP80.1 AP954
MA40.1 MA40.2
MA41.1 MA41.2
MA41.4 MA41.5
MA41.6 MA43.1
MA43.2 MA43.3
MA43.4 MA52.1
APT-VENDOR-GROUP Alpha 4 AP125 AP126
Vendor Group The vendor group associated with the AP151 AP156
bill of exchange payment. A vendor group AP180 AP20.1
represents a group of vendors that can AP20.2 AP20.5
be shared by one or more companies. Must AP20.7 AP20.8
be a valid record in the Vendor Group AP23.1 AP25.1
file. AP25.2 AP26.1
AP28.1 AP28.2
AP56.1 AP56.2
AP80.1 AP954
MA40.1 MA40.2
MA41.1 MA41.2
MA41.4 MA41.5
MA41.6 MA43.1
MA43.2 MA43.3
MA43.4 MA52.1
APT-VENDOR Alpha 9 AP125 AP126
Vendor ID The payment vendor number. Must be a AP151 AP156
valid record in the Vendor file. AP180 AP20.1
AP20.2 AP20.5
AP20.7 AP20.8
AP23.1 AP25.1
AP25.2 AP26.1
AP28.1 AP28.2
AP56.1 AP56.2
AP80.1 AP954
MA40.1 MA40.2
MA41.1 MA41.2
MA41.4 MA41.5
MA41.6 MA43.1
MA43.2 MA43.3
MA43.4 MA52.1
APT-VENDOR-VNAME Alpha 30 (Lower Case) AP125 AP126
Vendor Name The vendor name or description. AP151 AP156
AP180 AP20.1
AP20.2 AP20.5
AP20.7 AP20.8
AP23.1 AP25.1
AP25.2 AP26.1
AP28.1 AP28.2
AP56.1 AP56.2
AP80.1 AP954
MA40.1 MA40.2
MA41.1 MA41.2
MA41.4 MA41.5
MA41.6 MA43.1
MA43.2 MA43.3
MA43.4 MA52.1
APT-BANK-INST-CODE Alpha 3 AP125 AP126
Payment Code The payment code assigned to the bill AP151 AP156
of exchange. Represents the type of bill AP180 AP20.1
of exchange payment. Must be a valid AP20.2 AP20.5
bill of exchange payment transaction AP20.7 AP20.8
code in the Bank Transaction Code file. AP23.1 AP25.1
AP25.2 AP26.1
AP28.1 AP28.2
AP56.1 AP56.2
AP80.1 AP954
MA40.1 MA40.2
MA41.1 MA41.2
MA41.4 MA41.5
MA41.6 MA43.1
MA43.2 MA43.3
MA43.4 MA52.1
APT-DRAFT-NBR Alpha 10 (Right Justified) AP125 AP126
Bill of Exchange The bill of exchange number. AP151 AP156
Number AP180 AP20.1
AP20.2 AP20.5
AP20.7 AP20.8
AP23.1 AP25.1
AP25.2 AP26.1
AP28.1 AP28.2
AP56.1 AP56.2
AP80.1 AP954
MA40.1 MA40.2
MA41.1 MA41.2
MA41.4 MA41.5
MA41.6 MA43.1
MA43.2 MA43.3
MA43.4 MA52.1
APT-SUFFIX Numeric 3 AP125 AP126
Bill of Exchange The bill of exchange suffix number. AP151 AP156
Suffix AP180 AP20.1
AP20.2 AP20.5
AP20.7 AP20.8
AP23.1 AP25.1
AP25.2 AP26.1
AP28.1 AP28.2
AP56.1 AP56.2
AP80.1 AP954
MA40.1 MA40.2
MA41.1 MA41.2
MA41.4 MA41.5
MA41.6 MA43.1
MA43.2 MA43.3
MA43.4 MA52.1
APT-PROC-LEVEL Alpha 5 AP125 AP126
Process Level The process level associated with the AP151 AP156
bill of exchange. Must be a valid record AP180 AP20.1
in the Accounts Payable Process Level AP20.2 AP20.5
file. AP20.7 AP20.8
AP23.1 AP25.1
AP25.2 AP26.1
AP28.1 AP28.2
AP56.1 AP56.2
AP80.1 AP954
MA40.1 MA40.2
MA41.1 MA41.2
MA41.4 MA41.5
MA41.6 MA43.1
MA43.2 MA43.3
MA43.4 MA52.1
APT-REMIT-TO-CODE Alpha 4 AP125 AP126
Remit To Location The remit-to location code associated AP151 AP156
Code with the bill of exchange. Represents an AP180 AP20.1
alternate remittance location for the AP20.2 AP20.5
vendor. Must be a valid record in the AP20.7 AP20.8
Vendor Location file. AP23.1 AP25.1
AP25.2 AP26.1
AP28.1 AP28.2
AP56.1 AP56.2
AP80.1 AP954
MA40.1 MA40.2
MA41.1 MA41.2
MA41.4 MA41.5
MA41.6 MA43.1
MA43.2 MA43.3
MA43.4 MA52.1
APT-PMT-DOC-ORIGIN Alpha 1 AP125 AP126
Transaction Origin The bill of exchange payment origin. AP151 AP156
Indicates who created the bill of AP180 AP20.1
exchange document or transaction. Valid AP20.2 AP20.5
values are: AP20.7 AP20.8
AP23.1 AP25.1
P = Accounts Payable AP25.2 AP26.1
R = Accounts Receivable. AP28.1 AP28.2
AP56.1 AP56.2
AP80.1 AP954
MA40.1 MA40.2
MA41.1 MA41.2
MA41.4 MA41.5
MA41.6 MA43.1
MA43.2 MA43.3
MA43.4 MA52.1
APT-CASH-CODE Alpha 4 AP125 AP126
Cash Code The cash code assigned to the bill of AP151 AP156
exchange. Represents the bank account AP180 AP20.1
used to pay the bill of exchange. Must AP20.2 AP20.5
be a valid record in the Cash Code file. AP20.7 AP20.8
If left blank, the cash code assigned to AP23.1 AP25.1
the remit-to location, vendor, vendor AP25.2 AP26.1
class, process level, company, or pay AP28.1 AP28.2
group defaults. AP56.1 AP56.2
AP80.1 AP954
MA40.1 MA40.2
MA41.1 MA41.2
MA41.4 MA41.5
MA41.6 MA43.1
MA43.2 MA43.3
MA43.4 MA52.1
APT-CURRENCY-CODE Alpha 5 AP125 AP126
Bill of Exchange The currency of the bill of exchange. AP151 AP156
Currency Must be a valid record in the Currency AP180 AP20.1
Code file. If left blank, the company AP20.2 AP20.5
base currency defaults. AP20.7 AP20.8
AP23.1 AP25.1
AP25.2 AP26.1
AP28.1 AP28.2
AP56.1 AP56.2
AP80.1 AP954
MA40.1 MA40.2
MA41.1 MA41.2
MA41.4 MA41.5
MA41.6 MA43.1
MA43.2 MA43.3
MA43.4 MA52.1
APT-DRAFT-AMOUNT Signed 15.2 AP125 AP126
Bill of Exchange The amount of the bill of exchange AP151 AP156
Amount payment in the currency of the bill of AP180 AP20.1
exchange. AP20.2 AP20.5
AP20.7 AP20.8
AP23.1 AP25.1
AP25.2 AP26.1
AP28.1 AP28.2
AP56.1 AP56.2
AP80.1 AP954
MA40.1 MA40.2
MA41.1 MA41.2
MA41.4 MA41.5
MA41.6 MA43.1
MA43.2 MA43.3
MA43.4 MA52.1
APT-APPLIED-AMT Signed 15.2 AP125 AP126
Applied Amount The total invoice amount that is AP151 AP156
applied to the bill of exchange. AP180 AP20.1
AP20.2 AP20.5
AP20.7 AP20.8
AP23.1 AP25.1
AP25.2 AP26.1
AP28.1 AP28.2
AP56.1 AP56.2
AP80.1 AP954
MA40.1 MA40.2
MA41.1 MA41.2
MA41.4 MA41.5
MA41.6 MA43.1
MA43.2 MA43.3
MA43.4 MA52.1
APT-TRAN-ND Numeric 1 AP125 AP126
Transaction Number The number of decimal positions defined AP151 AP156
of Decimals for the bill of exchange currency. AP180 AP20.1
AP20.2 AP20.5
AP20.7 AP20.8
AP23.1 AP25.1
AP25.2 AP26.1
AP28.1 AP28.2
AP56.1 AP56.2
AP80.1 AP954
MA40.1 MA40.2
MA41.1 MA41.2
MA41.4 MA41.5
MA41.6 MA43.1
MA43.2 MA43.3
MA43.4 MA52.1
APT-ORIG-RATE Signed 12.6 AP125 AP126
Exchange Rate at The currency exchange rate used to AP151 AP156
Creation convert the bill of exchange amount to AP180 AP20.1
the company base currency at the time AP20.2 AP20.5
the bill of exchange was created. AP20.7 AP20.8
AP23.1 AP25.1
AP25.2 AP26.1
AP28.1 AP28.2
AP56.1 AP56.2
AP80.1 AP954
MA40.1 MA40.2
MA41.1 MA41.2
MA41.4 MA41.5
MA41.6 MA43.1
MA43.2 MA43.3
MA43.4 MA52.1
APT-BASE-ORIG-AMT Signed 15.2 AP125 AP126
Base BOE Amount - The amount of the bill of exchange AP151 AP156
At Creation payment in the company base currency. AP180 AP20.1
This amount is based on the currency AP20.2 AP20.5
exchange rate in effect at the time the AP20.7 AP20.8
bill of exchange was created. AP23.1 AP25.1
AP25.2 AP26.1
AP28.1 AP28.2
AP56.1 AP56.2
AP80.1 AP954
MA40.1 MA40.2
MA41.1 MA41.2
MA41.4 MA41.5
MA41.6 MA43.1
MA43.2 MA43.3
MA43.4 MA52.1
APT-BASE-ACT-AMT Signed 15.2 AP125 AP126
Base BOE Amount - The amount of the bill of exchange AP151 AP156
At Cashing payment in the company base currency. AP180 AP20.1
This amount is based on the currency AP20.2 AP20.5
exchange rate in effect at the time the AP20.7 AP20.8
bill of exchange is cashed. AP23.1 AP25.1
AP25.2 AP26.1
AP28.1 AP28.2
AP56.1 AP56.2
AP80.1 AP954
MA40.1 MA40.2
MA41.1 MA41.2
MA41.4 MA41.5
MA41.6 MA43.1
MA43.2 MA43.3
MA43.4 MA52.1
APT-BASE-ND Numeric 1 AP125 AP126
Base Currency Nbr The number of decimal positions defined AP151 AP156
of Decimals for the company base currency. AP180 AP20.1
AP20.2 AP20.5
AP20.7 AP20.8
AP23.1 AP25.1
AP25.2 AP26.1
AP28.1 AP28.2
AP56.1 AP56.2
AP80.1 AP954
MA40.1 MA40.2
MA41.1 MA41.2
MA41.4 MA41.5
MA41.6 MA43.1
MA43.2 MA43.3
MA43.4 MA52.1
APT-ACT-RATE Signed 12.6 AP125 AP126
Exchange Rate at The currency exchange rate used to AP151 AP156
Cashing convert the bill of exchange amount to AP180 AP20.1
the company base currency at the time AP20.2 AP20.5
the bill of exchange is cashed. AP20.7 AP20.8
AP23.1 AP25.1
AP25.2 AP26.1
AP28.1 AP28.2
AP56.1 AP56.2
AP80.1 AP954
MA40.1 MA40.2
MA41.1 MA41.2
MA41.4 MA41.5
MA41.6 MA43.1
MA43.2 MA43.3
MA43.4 MA52.1
APT-DRAFT-DATE Numeric 8 (yyyymmdd) AP125 AP126
Bill of Exchange The creation date of the bill of AP151 AP156
Date exchange. If left blank, the system date AP180 AP20.1
defaults. AP20.2 AP20.5
AP20.7 AP20.8
AP23.1 AP25.1
AP25.2 AP26.1
AP28.1 AP28.2
AP56.1 AP56.2
AP80.1 AP954
MA40.1 MA40.2
MA41.1 MA41.2
MA41.4 MA41.5
MA41.6 MA43.1
MA43.2 MA43.3
MA43.4 MA52.1
APT-MATURITY-DATE Numeric 8 (yyyymmdd) AP125 AP126
Due Date The date the bill of exchange is due AP151 AP156
for payment. If left blank, the system AP180 AP20.1
date defaults. AP20.2 AP20.5
AP20.7 AP20.8
AP23.1 AP25.1
AP25.2 AP26.1
AP28.1 AP28.2
AP56.1 AP56.2
AP80.1 AP954
MA40.1 MA40.2
MA41.1 MA41.2
MA41.4 MA41.5
MA41.6 MA43.1
MA43.2 MA43.3
MA43.4 MA52.1
APT-ACCEPT-DATE Numeric 8 (yyyymmdd) AP125 AP126
Acceptance Date The date the bill of exchange is AP151 AP156
accepted. If left blank, the system date AP180 AP20.1
defaults. AP20.2 AP20.5
AP20.7 AP20.8
AP23.1 AP25.1
AP25.2 AP26.1
AP28.1 AP28.2
AP56.1 AP56.2
AP80.1 AP954
MA40.1 MA40.2
MA41.1 MA41.2
MA41.4 MA41.5
MA41.6 MA43.1
MA43.2 MA43.3
MA43.4 MA52.1
APT-CASH-DATE Numeric 8 (yyyymmdd) AP125 AP126
Cash Date The date the bill of exchange was AP151 AP156
cashed by the bank. AP180 AP20.1
AP20.2 AP20.5
AP20.7 AP20.8
AP23.1 AP25.1
AP25.2 AP26.1
AP28.1 AP28.2
AP56.1 AP56.2
AP80.1 AP954
MA40.1 MA40.2
MA41.1 MA41.2
MA41.4 MA41.5
MA41.6 MA43.1
MA43.2 MA43.3
MA43.4 MA52.1
APT-DISHONOR-DATE Numeric 8 (yyyymmdd) AP125 AP126
Dishonor Date The date the bill of exchange was AP151 AP156
dishonored by the bank. AP180 AP20.1
AP20.2 AP20.5
AP20.7 AP20.8
AP23.1 AP25.1
AP25.2 AP26.1
AP28.1 AP28.2
AP56.1 AP56.2
AP80.1 AP954
MA40.1 MA40.2
MA41.1 MA41.2
MA41.4 MA41.5
MA41.6 MA43.1
MA43.2 MA43.3
MA43.4 MA52.1
APT-CANCEL-DATE Numeric 8 (yyyymmdd) AP125 AP126
Cancel Date The date the bill of exchange was AP151 AP156
canceled. AP180 AP20.1
AP20.2 AP20.5
AP20.7 AP20.8
AP23.1 AP25.1
AP25.2 AP26.1
AP28.1 AP28.2
AP56.1 AP56.2
AP80.1 AP954
MA40.1 MA40.2
MA41.1 MA41.2
MA41.4 MA41.5
MA41.6 MA43.1
MA43.2 MA43.3
MA43.4 MA52.1
APT-CASH-COMPANY Numeric 4 AP125 AP126
Cashing Company The company associated with cashing the AP151 AP156
bill of exchange payment. Must be a AP180 AP20.1
valid record in the Accounts Payable AP20.2 AP20.5
Company file. AP20.7 AP20.8
AP23.1 AP25.1
AP25.2 AP26.1
AP28.1 AP28.2
AP56.1 AP56.2
AP80.1 AP954
MA40.1 MA40.2
MA41.1 MA41.2
MA41.4 MA41.5
MA41.6 MA43.1
MA43.2 MA43.3
MA43.4 MA52.1
APT-REC-STATUS Numeric 1 AP125 AP126
Record Status The status of the bill of exchange AP151 AP156
payment. Valid values are: AP180 AP20.1
AP20.2 AP20.5
0 = Unreleased. AP20.7 AP20.8
1 = Released. AP23.1 AP25.1
2 = Accepted. AP25.2 AP26.1
3 = Cashed. AP28.1 AP28.2
4 = Dishonored. AP56.1 AP56.2
5 = Canceled. AP80.1 AP954
MA40.1 MA40.2
MA41.1 MA41.2
MA41.4 MA41.5
MA41.6 MA43.1
MA43.2 MA43.3
MA43.4 MA52.1
APT-PRINT-STATUS Alpha 1 AP125 AP126
Print Status Indicates whether the bill of exchange AP151 AP156
payment has been printed by AP156 (Bill AP180 AP20.1
of Exchange Printing). Valid values are: AP20.2 AP20.5
AP20.7 AP20.8
AP23.1 AP25.1
N = No. AP25.2 AP26.1
Y = Yes. AP28.1 AP28.2
AP56.1 AP56.2
AP80.1 AP954
MA40.1 MA40.2
MA41.1 MA41.2
MA41.4 MA41.5
MA41.6 MA43.1
MA43.2 MA43.3
MA43.4 MA52.1
APT-ACPT-ACCT-UNIT Alpha 15 AP125 AP126
Acceptance The general ledger acceptance AP151 AP156
Accounting Unit accounting unit assigned to the bill of AP180 AP20.1
exchange payment. Must be a valid AP20.2 AP20.5
accounting unit in the Lawson General AP20.7 AP20.8
Ledger system. AP23.1 AP25.1
AP25.2 AP26.1
AP28.1 AP28.2
AP56.1 AP56.2
AP80.1 AP954
MA40.1 MA40.2
MA41.1 MA41.2
MA41.4 MA41.5
MA41.6 MA43.1
MA43.2 MA43.3
MA43.4 MA52.1
APT-ACPT-ACCOUNT Numeric 6 AP125 AP126
Acceptance Account The general ledger acceptance account AP151 AP156
Number number assigned to the bill of exchange AP180 AP20.1
payment. Must be a valid account in the AP20.2 AP20.5
Lawson General Ledger system. AP20.7 AP20.8
AP23.1 AP25.1
AP25.2 AP26.1
AP28.1 AP28.2
AP56.1 AP56.2
AP80.1 AP954
MA40.1 MA40.2
MA41.1 MA41.2
MA41.4 MA41.5
MA41.6 MA43.1
MA43.2 MA43.3
MA43.4 MA52.1
APT-ACPT-SUB-ACCT Numeric 4 AP125 AP126
Acceptance The general ledger acceptance AP151 AP156
Subaccount Number subaccount number assigned to the bill AP180 AP20.1
of exchange payment. Must be a valid AP20.2 AP20.5
subaccount in the Lawson General Ledger AP20.7 AP20.8
system. AP23.1 AP25.1
AP25.2 AP26.1
AP28.1 AP28.2
AP56.1 AP56.2
AP80.1 AP954
MA40.1 MA40.2
MA41.1 MA41.2
MA41.4 MA41.5
MA41.6 MA43.1
MA43.2 MA43.3
MA43.4 MA52.1
APT-DRAFT-CODE Alpha 4 AP125 AP126
Bill of Exchange The bill of exchange accrual code AP151 AP156
Accrual Code assigned to the bill of exchange AP180 AP20.1
payment. Used to default an acceptance AP20.2 AP20.5
account to the bill of exchange. Must be AP20.7 AP20.8
a valid record in the Bill of Exchange AP23.1 AP25.1
Accrual Code file. AP25.2 AP26.1
AP28.1 AP28.2
AP56.1 AP56.2
AP80.1 AP954
MA40.1 MA40.2
MA41.1 MA41.2
MA41.4 MA41.5
MA41.6 MA43.1
MA43.2 MA43.3
MA43.4 MA52.1
APT-GL-UPDATE-FL Alpha 1 AP125 AP126
General Ledger Indicates whether the cashed or AP151 AP156
Update Flag dishonored bill of exchange has been AP180 AP181
updated to the general ledger by AP185 AP20.1 AP20.2
(Bill of Exchange Distribution Posting). AP20.5 AP20.7
Valid values are: AP20.8 AP23.1
AP25.1 AP25.2
N = No. AP26.1 AP28.1
Y = Yes. AP28.2 AP56.1
AP56.2 AP80.1
AP954 MA40.1
MA40.2 MA41.1
MA41.2 MA41.4
MA41.5 MA41.6
MA43.1 MA43.2
MA43.3 MA43.4
MA52.1
APT-POST-DATE Numeric 8 (yyyymmdd) AP125 AP126
Post Date The date used for posting the cashed or AP151 AP156
dishonored bill of exchange payment to AP180 AP20.1
the general ledger. AP20.2 AP20.5
AP20.7 AP20.8
AP23.1 AP25.1
AP25.2 AP26.1
AP28.1 AP28.2
AP56.1 AP56.2
AP80.1 AP954
MA40.1 MA40.2
MA41.1 MA41.2
MA41.4 MA41.5
MA41.6 MA43.1
MA43.2 MA43.3
MA43.4 MA52.1
APT-PAYER-REF Alpha 10 AP125 AP126
Payer Reference Contains bank reference information for AP151 AP156
manually created bills of exchange. AP180 AP20.1
AP20.2 AP20.5
AP20.7 AP20.8
AP23.1 AP25.1
AP25.2 AP26.1
AP28.1 AP28.2
AP56.1 AP56.2
AP80.1 AP954
MA40.1 MA40.2
MA41.1 MA41.2
MA41.4 MA41.5
MA41.6 MA43.1
MA43.2 MA43.3
MA43.4 MA52.1
APT-STATEMENT-NBR Numeric 8 AP166 AP167
Statement Number The statement number assigned to a set AP954
of bills of exchange cashed by a bank on
a single day.
APT-DERIVED-STATUS Derived
Derived Status The status of the bill of exchange
payment.
APT-VGROUP Derived
Vendor Group The vendor group associated with the
bill of exchange payment. Must be a
valid record in the Vendor Group file.
APT-SHORT-DFT-NAME Derived
Short Vendor Name A short (20-character) name for the
vendor associated with the bill of
exchange payment.
APT-JRNL-BOOK-NBR Alpha 12 AP125 AP126
Journal Book The journal book assigned to the AP151 AP156
transaction. AP180 AP20.1
AP20.2 AP20.5
AP20.7 AP20.8
AP23.1 AP25.1
AP25.2 AP26.1
AP28.1 AP28.2
AP56.1 AP56.2
AP80.1 AP954
MA40.1 MA40.2
MA41.1 MA41.2
MA41.4 MA41.5
MA41.6 MA43.1
MA43.2 MA43.3
MA43.4 MA52.1
APDRAFTS FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
APTSET1 BANK-INST-CODEThis index provides the elements which AP125 AP126
TRANS-IDENT keep a record in this file unique. AP151 AP156
AP166 AP180
AP20.1 AP20.2
AP20.5 AP20.7
AP20.8 AP213
AP23.1 AP25.1
AP25.2 AP26.1
AP260 AP28.1
AP28.2 AP284
AP56.1 AP56.2
AP80.1 AP954
CB300 MA40.1
MA40.2 MA41.1
MA41.2 MA41.4
...
APTSET10 CASH-CODE This index is used to access bill of AP181
PAY-GROUP exchange payment records for a company
STATEMENT-NBR and pay group by assigned draft
DRAFT-NBR statement number.
SUFFIX Subset
Where STATEMENT-NBR != Zeroes
APTSET2 CASH-CODE This index is used to access bill of AP167 AP181
REC-STATUS exchange payment records by assigned
BANK-INST-CODEcash code.
DRAFT-NBR KeyChange
SUFFIX
TRANS-IDENT
COMPANY
VENDOR
APTSET3 PAY-GROUP This index is used to display all bill AP125 AP126
REC-STATUS of exchange payment records that require AP151 AP156
DRAFT-DATE acceptance or that have been accepted AP180 AP20.1
BANK-INST-CODEfor a company. AP20.2 AP20.5
DRAFT-NBR KeyChange, Subset AP20.7 AP20.8
SUFFIX Where REC-STATUS = 1 AP23.1 AP230
TRANS-IDENT Or REC-STATUS = 2 AP25.1 AP25.2
AP250 AP26.1
AP28.1 AP28.2
AP56.1 AP56.2
AP80.1 MA40.1
MA40.2 MA41.1
MA41.2 MA41.4
MA41.5 MA41.6
MA43.1 MA43.2
...
APTSET4 PAY-GROUP This index is used to sort all bill of AP266 AP28.1
VENDOR exchange payment records for a vendor. AP28.2 AP300
REC-STATUS KeyChange, Duplicates
DRAFT-NBR
SUFFIX
BANK-INST-CODE
TRANS-IDENT
APTSET5 CASH-CODE This index is used to display all bill AP180 AP80.1
MATURITY-DATE of exchange payment records that are
PAY-GROUP available to be maintained for cashing
BANK-INST-CODEor dishonoring.
DRAFT-NBR KeyChange, Subset
SUFFIX Where GL-UPDATE-FL = "N"
TRANS-IDENT And REC-STATUS > 1
And REC-STATUS < 5
APTSET6 BANK-INST-CODEThis index is used to omit canceled AP125 AP126
DRAFT-NBR bill of exchange payments and is used to AP151 AP156
SUFFIX edit for duplicate bill of exchange AP180 AP20.1
VENDOR numbers. AP20.2 AP20.5
PAY-GROUP KeyChange, Duplicates, Subset AP20.7 AP20.8
Where REC-STATUS != 5 AP23.1 AP25.1
AP25.2 AP26.1
AP28.1 AP28.2
AP56.1 AP56.2
AP80.1 MA40.1
MA40.2 MA41.1
MA41.2 MA41.4
MA41.5 MA41.6
MA43.1 MA43.2
MA43.3 MA43.4
...
APTSET7 PAY-GROUP This index is used to sort all bill of AP125 AP126
BANK-INST-CODEexchange payment records for a pay group AP151 AP156
VENDOR by bill of exchange type. AP180 AP20.1
DRAFT-NBR KeyChange, Duplicates AP20.2 AP20.5
SUFFIX AP20.7 AP20.8
AP214 AP23.1
AP25.1 AP25.2
AP26.1 AP28.1
AP28.2 AP305
AP56.1 AP56.2
AP80.1 AP91.2
MA40.1 MA40.2
MA41.1 MA41.2
MA41.4 MA41.5
MA41.6 MA43.1
...
APTSET8 VENDOR-GROUP This path is used to display bill of AP91.1
VENDOR exchange payment records for a vendor in
COMPANY AP91.1 (Vendor Activity).
BANK-INST-CODEKeyChange
TRANS-IDENT
APTSET9 CASH-CODE This index is used to access bill of
COMPANY exchange payment records for a cash code
STATEMENT-NBR and company by assigned statement
DRAFT-NBR number.
SUFFIX Subset
Where STATEMENT-NBR != Zeroes
APDRAFTS FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Apcompany APCOMPANY Required
APT-COMPANY -> CPY-COMPANY (CPYSET1)
Appaygroup APPAYGROUP Required
APT-PAY-GROUP -> PAY-PAY-GROUP
Approclev APPROCLEV Not Required
APT-COMPANY -> APR-COMPANY
APT-PROC-LEVEL -> APR-PROC-LEVEL
Apvenbal APVENBAL Required
CPY-VENDOR-GROUP -> VBA-VENDOR-GROUP
APT-COMPANY -> VBA-COMPANY
APT-VENDOR -> VBA-VENDOR
APT-REMIT-TO-CODE -> VBA-LOCATION-CODE
Apvenclass APVENMAST Not Required
CPY-VENDOR-GROUP -> VEN-VENDOR-GROUP
APT-VENDOR -> VEN-VENDOR
Apvenloc APVENLOC Not Required
CPY-VENDOR-GROUP -> VLO-VENDOR-GROUP
APT-VENDOR -> VLO-VENDOR
APT-REMIT-TO-CODE -> VLO-LOCATION-CODE
Apvenmast APVENMAST Not Required
CPY-VENDOR-GROUP -> VEN-VENDOR-GROUP
APT-VENDOR -> VEN-VENDOR
Cbbankent CBBANKENT Required
CBC-BANK-ENTITY -> CBE-BANK-ENTITY
Cbbankinst CBBANKINST Required
APT-BANK-INST-CODE -> CBI-BANK-INST-CODE
Cbcashcode CBCASHCODE Required
APT-CASH-CODE -> CBC-CASH-CODE
Cbcpycash CBCPYCASH Not Required
APT-COMPANY -> CBY-COMPANY
APT-CASH-CODE -> CBY-CASH-CODE
Cbtrans CBTRANS Not Required
APT-BANK-INST-CODE -> CBT-BANK-INST-CODE
APT-TRANS-IDENT -> CBT-TRANS-IDENT
APDRAFTS FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Apdrftdist APDRFTDIST
APT-BANK-INST-CODE -> DDT-BANK-INST-CODE
APT-TRANS-IDENT -> DDT-TRANS-IDENT
DDT-SEQ-NBR
Appayment APPAYMENT
APT-PAY-GROUP -> APP-PAY-GROUP
APT-BANK-INST-CODE -> APP-BANK-INST-CODE
APT-TRANS-IDENT -> APP-TRANS-IDENT
APP-VENDOR
APP-INVOICE
APP-SUFFIX
APP-CANCEL-SEQ
APP-SEQ-NBR
APP-VOID-SEQ
APP-COMPANY
|