Lawson Insight Technical Documentation |
|
APDRAFTS
APDRAFTS FILE
AP Bill of Exchange
The Accounts Payable Bill of Exchange file contains bill of exchange payment
records.
REFERENCED BY
AP198 AP213 AP230 AP260 AP284 AP250
AP266 AP300 AP91.2 AP91.1 AP214
UPDATED BY
AP125 AP126 AP151 AP156 AP166 AP167
AP180 AP181 AP20.1 AP20.2 AP20.3 AP20.4
AP20.5 AP20.7 AP20.8 AP23.1 AP25.1 AP25.2
AP26.1 AP27.1 AP28.1 AP28.2 AP305 AP56.1
AP56.2 AP80.1 API1.1 CB300 MA41.2 MA41.7
MA43.2 MA61.1 MAI1.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
APT-PAY-GROUP Alpha 4 AP125 AP126
Element: 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.3
payments. Must be a valid record in the AP20.4 AP20.5
Pay Group file. AP20.7 AP20.8
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP56.1
AP56.2 AP80.1
API1.1 MA41.2
MA41.7 MA43.2
MA61.1 MAI1.1
APT-COMPANY Numeric 4 AP125 AP126
Element: 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.3
AP20.4 AP20.5
AP20.7 AP20.8
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP56.1
AP56.2 AP80.1
API1.1 MA41.2
MA41.7 MA43.2
MA61.1 MAI1.1
APT-TRANS-IDENT Numeric 10 AP125 AP126
Element: Transaction IDA unique system-generated AP151 AP156
identification value assigned to the AP180 AP20.1
bill of exchange payment transaction to AP20.2 AP20.3
make this record unique. AP20.4 AP20.5
AP20.7 AP20.8
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP56.1
AP56.2 AP80.1
API1.1 MA41.2
MA41.7 MA43.2
MA61.1 MAI1.1
APT-VENDOR-GROUP Alpha 4 AP125 AP126
Element: 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.3
be shared by one or more companies. Must AP20.4 AP20.5
be a valid record in the Vendor Group AP20.7 AP20.8
file. AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP56.1
AP56.2 AP80.1
API1.1 MA41.2
MA41.7 MA43.2
MA61.1 MAI1.1
APT-VENDOR Alpha 9 (Right Justified) AP125 AP126
Element: Vendor ID The payment vendor number. Must be a AP151 AP156
valid record in the Vendor file. AP180 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP20.8
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP56.1
AP56.2 AP80.1
API1.1 MA41.2
MA41.7 MA43.2
MA61.1 MAI1.1
APT-VENDOR-VNAME Alpha 30 (Lower Case) AP125 AP126
Element: Name The vendor name or description. AP151 AP156
AP180 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP20.8
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP56.1
AP56.2 AP80.1
API1.1 MA41.2
MA41.7 MA43.2
MA61.1 MAI1.1
APT-BANK-INST-CODE Alpha 3 AP125 AP126
Element: 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.3
bill of exchange payment transaction AP20.4 AP20.5
code in the Bank Transaction Code file. AP20.7 AP20.8
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP56.1
AP56.2 AP80.1
API1.1 MA41.2
MA41.7 MA43.2
MA61.1 MAI1.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.3
AP20.4 AP20.5
AP20.7 AP20.8
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP56.1
AP56.2 AP80.1
API1.1 MA41.2
MA41.7 MA43.2
MA61.1 MAI1.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.3
AP20.4 AP20.5
AP20.7 AP20.8
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP56.1
AP56.2 AP80.1
API1.1 MA41.2
MA41.7 MA43.2
MA61.1 MAI1.1
APT-PROC-LEVEL Alpha 5 AP125 AP126
Element: 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.3
file. AP20.4 AP20.5
AP20.7 AP20.8
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP56.1
AP56.2 AP80.1
API1.1 MA41.2
MA41.7 MA43.2
MA61.1 MAI1.1
APT-REMIT-TO-CODE Alpha 4 AP125 AP126
Purchase From The remit-to location code associated AP151 AP156
Location Code with the bill of exchange. Represents an AP180 AP20.1
alternate remittance location for the AP20.2 AP20.3
vendor. Must be a valid record in the AP20.4 AP20.5
Vendor Location file. AP20.7 AP20.8
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP56.1
AP56.2 AP80.1
API1.1 MA41.2
MA41.7 MA43.2
MA61.1 MAI1.1
APT-PMT-DOC-ORIGIN Alpha 1 AP125 AP126
Element: Transaction OrThe bill of exchange payment origin. AP151 AP156
Indicates who created the bill of AP180 AP20.1
exchange document or transaction. Valid AP20.2 AP20.3
values are: AP20.4 AP20.5
AP20.7 AP20.8
P = Accounts Payable AP23.1 AP25.1
R = Accounts Receivable. AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP56.1
AP56.2 AP80.1
API1.1 MA41.2
MA41.7 MA43.2
MA61.1 MAI1.1
APT-CASH-CODE Alpha 4 AP125 AP126
Accounts Receivable The cash code assigned to the bill of AP151 AP156
Code exchange. Represents the bank account AP180 AP20.1
used to pay the bill of exchange. Must AP20.2 AP20.3
be a valid record in the Cash Code file. AP20.4 AP20.5
If left blank, the cash code assigned to AP20.7 AP20.8
the remit-to location, vendor, vendor AP23.1 AP25.1
class, process level, company, or pay AP25.2 AP26.1
group defaults. AP27.1 AP28.1
AP28.2 AP56.1
AP56.2 AP80.1
API1.1 MA41.2
MA41.7 MA43.2
MA61.1 MAI1.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.3
base currency defaults. AP20.4 AP20.5
AP20.7 AP20.8
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP56.1
AP56.2 AP80.1
API1.1 MA41.2
MA41.7 MA43.2
MA61.1 MAI1.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.3
AP20.4 AP20.5
AP20.7 AP20.8
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP56.1
AP56.2 AP80.1
API1.1 MA41.2
MA41.7 MA43.2
MA61.1 MAI1.1
APT-APPLIED-AMT Signed 15.2 AP125 AP126
Element: Adj Amt The total invoice amount that is AP151 AP156
applied to the bill of exchange. AP180 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP20.8
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP56.1
AP56.2 AP80.1
API1.1 MA41.2
MA41.7 MA43.2
MA61.1 MAI1.1
APT-TRAN-ND Numeric 1 AP125 AP126
Account Currency The number of decimal positions defined AP151 AP156
Code for the bill of exchange currency. AP180 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP20.8
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP56.1
AP56.2 AP80.1
API1.1 MA41.2
MA41.7 MA43.2
MA61.1 MAI1.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.3
the bill of exchange was created. AP20.4 AP20.5
AP20.7 AP20.8
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP56.1
AP56.2 AP80.1
API1.1 MA41.2
MA41.7 MA43.2
MA61.1 MAI1.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.3
exchange rate in effect at the time the AP20.4 AP20.5
bill of exchange was created. AP20.7 AP20.8
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP56.1
AP56.2 AP80.1
API1.1 MA41.2
MA41.7 MA43.2
MA61.1 MAI1.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.3
exchange rate in effect at the time the AP20.4 AP20.5
bill of exchange is cashed. AP20.7 AP20.8
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP56.1
AP56.2 AP80.1
API1.1 MA41.2
MA41.7 MA43.2
MA61.1 MAI1.1
APT-BASE-ND Numeric 1 AP125 AP126
Base Currency Nbr AP151 AP156
of Decimals AP180 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP20.8
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP56.1
AP56.2 AP80.1
API1.1 MA41.2
MA41.7 MA43.2
MA61.1 MAI1.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.3
the bill of exchange is cashed. AP20.4 AP20.5
AP20.7 AP20.8
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP56.1
AP56.2 AP80.1
API1.1 MA41.2
MA41.7 MA43.2
MA61.1 MAI1.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.3
AP20.4 AP20.5
AP20.7 AP20.8
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP56.1
AP56.2 AP80.1
API1.1 MA41.2
MA41.7 MA43.2
MA61.1 MAI1.1
APT-MATURITY-DATE Numeric 8 (yyyymmdd) AP125 AP126
Element: 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.3
AP20.4 AP20.5
AP20.7 AP20.8
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP56.1
AP56.2 AP80.1
API1.1 MA41.2
MA41.7 MA43.2
MA61.1 MAI1.1
APT-ACCEPT-DATE Numeric 8 (yyyymmdd) AP125 AP126
Element: Acceptance DatThe date the bill of exchange is AP151 AP156
accepted. If left blank, the system date AP180 AP20.1
defaults. AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP20.8
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP56.1
AP56.2 AP80.1
API1.1 MA41.2
MA41.7 MA43.2
MA61.1 MAI1.1
APT-CASH-DATE Numeric 8 (yyyymmdd) AP125 AP126
Element: Date The date the bill of exchange was AP151 AP156
cashed by the bank. AP180 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP20.8
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP56.1
AP56.2 AP80.1
API1.1 MA41.2
MA41.7 MA43.2
MA61.1 MAI1.1
APT-DISHONOR-DATE Numeric 8 (yyyymmdd) AP125 AP126
Element: Date The date the bill of exchange was AP151 AP156
dishonored by the bank. AP180 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP20.8
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP56.1
AP56.2 AP80.1
API1.1 MA41.2
MA41.7 MA43.2
MA61.1 MAI1.1
APT-CANCEL-DATE Numeric 8 (yyyymmdd) AP125 AP126
Element: Date The date the bill of exchange was AP151 AP156
canceled. AP180 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP20.8
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP56.1
AP56.2 AP80.1
API1.1 MA41.2
MA41.7 MA43.2
MA61.1 MAI1.1
APT-CASH-COMPANY Numeric 4 AP125 AP126
Element: Cashing CompanThe 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.3
Company file. AP20.4 AP20.5
AP20.7 AP20.8
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP56.1
AP56.2 AP80.1
API1.1 MA41.2
MA41.7 MA43.2
MA61.1 MAI1.1
APT-REC-STATUS Numeric 1 AP125 AP126
Element: Record Status The status of the bill of exchange AP151 AP156
payment. Valid values are: AP180 AP20.1
AP20.2 AP20.3
0 = Unreleased. AP20.4 AP20.5
1 = Released. AP20.7 AP20.8
2 = Accepted. AP23.1 AP25.1
3 = Cashed. AP25.2 AP26.1
4 = Dishonored. AP27.1 AP28.1
5 = Canceled. AP28.2 AP56.1
AP56.2 AP80.1
API1.1 MA41.2
MA41.7 MA43.2
MA61.1 MAI1.1
APT-PRINT-STATUS Alpha 1 AP125 AP126
Element: 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.3
AP20.4 AP20.5
N = No. AP20.7 AP20.8
Y = Yes. AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP56.1
AP56.2 AP80.1
API1.1 MA41.2
MA41.7 MA43.2
MA61.1 MAI1.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.3
accounting unit in the Lawson General AP20.4 AP20.5
Ledger system. AP20.7 AP20.8
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP56.1
AP56.2 AP80.1
API1.1 MA41.2
MA41.7 MA43.2
MA61.1 MAI1.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.3
Lawson General Ledger system. AP20.4 AP20.5
AP20.7 AP20.8
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP56.1
AP56.2 AP80.1
API1.1 MA41.2
MA41.7 MA43.2
MA61.1 MAI1.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.3
subaccount in the Lawson General Ledger AP20.4 AP20.5
system. AP20.7 AP20.8
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP56.1
AP56.2 AP80.1
API1.1 MA41.2
MA41.7 MA43.2
MA61.1 MAI1.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.3
account to the bill of exchange. Must be AP20.4 AP20.5
a valid record in the Bill of Exchange AP20.7 AP20.8
Accrual Code file. AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP56.1
AP56.2 AP80.1
API1.1 MA41.2
MA41.7 MA43.2
MA61.1 MAI1.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.3 AP20.4
Valid values are: AP20.5 AP20.7
AP20.8 AP23.1
N = No. AP25.1 AP25.2
Y = Yes. AP26.1 AP27.1
AP28.1 AP28.2
AP56.1 AP56.2
AP80.1 API1.1
MA41.2 MA41.7
MA43.2 MA61.1
MAI1.1
APT-POST-DATE Numeric 8 (yyyymmdd) AP125 AP126
Element: 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.3
AP20.4 AP20.5
AP20.7 AP20.8
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP56.1
AP56.2 AP80.1
API1.1 MA41.2
MA41.7 MA43.2
MA61.1 MAI1.1
APT-PAYER-REF Alpha 10 AP125 AP126
Payer Reference The reference number assigned to the AP151 AP156
Number bill of exchange payment. AP180 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP20.8
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP56.1
AP56.2 AP80.1
API1.1 MA41.2
MA41.7 MA43.2
MA61.1 MAI1.1
APT-STATEMENT-NBR Numeric 8 AP166 AP167
Element: Statement NumbThe statement number assigned to the
bill of exchange payment.
APT-JRNL-BOOK-NBR Alpha 12 AP125 AP126
Element: Journal Book The journal book assigned to the AP151 AP156
transaction. AP180 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP20.8
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP56.1
AP56.2 AP80.1
API1.1 MA41.2
MA41.7 MA43.2
MA61.1 MAI1.1
APT-DERIVED-STATUS Derived
Bill of Exchange The status of the bill of exchange
Status payment.
APT-VGROUP Derived
Element: 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
Element: Short Vendor NA short (20-character) name for the
vendor associated with the bill of
exchange payment.
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
AP198 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP20.8
AP213 AP23.1
AP230 AP25.1
AP25.2 AP26.1
AP260 AP27.1
AP28.1 AP28.2
AP284 AP56.1
AP56.2 AP80.1
API1.1 CB300
...
APTSET10 CASH-CODE Subset AP181
PAY-GROUP Where (STATEMENT-NBR != Zeroes )
STATEMENT-NBR
DRAFT-NBR
SUFFIX
APTSET2 CASH-CODE This file 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.3
DRAFT-NBR KeyChange, Subset AP20.4 AP20.5
SUFFIX Where REC-STATUS = 1 AP20.7 AP20.8
TRANS-IDENT Or REC-STATUS = 2 AP23.1 AP25.1
AP25.2 AP250
AP26.1 AP27.1
AP28.1 AP28.2
AP56.1 AP56.2
AP80.1 API1.1
MA41.2 MA41.7
MA43.2 MA61.1
MAI1.1
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
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.3
PAY-GROUP KeyChange, Subset AP20.4 AP20.5
Where REC-STATUS != 5 AP20.7 AP20.8
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP56.1
AP56.2 AP80.1
API1.1 MA41.2
MA41.7 MA43.2
MA61.1 MAI1.1
APTSET7 PAY-GROUP This index is used to sort all bill of AP125 AP126
BANK-INST-CODEexchange payment records for a company AP151 AP156
VENDOR by bill of exchange type. AP180 AP20.1
DRAFT-NBR KeyChange AP20.2 AP20.3
SUFFIX AP20.4 AP20.5
TRANS-IDENT AP20.7 AP20.8
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP305
AP56.1 AP56.2
AP80.1 AP91.2
API1.1 MA41.2
MA41.7 MA43.2
MA61.1 MAI1.1
APTSET8 VENDOR-GROUP KeyChange AP214 AP91.1
VENDOR
COMPANY
BANK-INST-CODE
TRANS-IDENT
APDRAFTS FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Apcompany APCOMPANY Required
APT-COMPANY -> CPY-COMPANY
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
Apapphist APAPPHIST
APT-PAY-GROUP -> AH3-PAY-GROUP
APT-BANK-INST-CODE -> AH3-BANK-INST-CODE
APT-TRANS-IDENT -> AH3-TRANS-IDENT
AH3-VENDOR
AH3-INVOICE
AH3-SUFFIX
AH3-CANCEL-SEQ
AH3-SEQ-NBR
AH3-VOID-SEQ
AH3-COMPANY
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
|