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
AP136 AP213 AP230 AP284 AP250 AP266
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 AP21.1 AP23.1 AP25.1
AP25.2 AP26.1 AP27.1 AP28.1 AP28.2 AP305
AP56.1 AP56.2 AP80.1 CB300 MA41.1 MA41.2
MA41.4 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
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP56.1 AP56.2
AP80.1 MA41.1
MA41.2 MA41.4
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
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP56.1 AP56.2
AP80.1 MA41.1
MA41.2 MA41.4
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
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP56.1 AP56.2
AP80.1 MA41.1
MA41.2 MA41.4
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. AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP56.1 AP56.2
AP80.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.2
MA61.1 MAI1.1
APT-VENDOR Alpha 9 (Right Justified) AP125 AP126
Element: Vendor 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
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP56.1 AP56.2
AP80.1 MA41.1
MA41.2 MA41.4
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
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP56.1 AP56.2
AP80.1 MA41.1
MA41.2 MA41.4
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
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP56.1 AP56.2
AP80.1 MA41.1
MA41.2 MA41.4
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
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP56.1 AP56.2
AP80.1 MA41.1
MA41.2 MA41.4
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
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP56.1 AP56.2
AP80.1 MA41.1
MA41.2 MA41.4
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
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP56.1 AP56.2
AP80.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.2
MA61.1 MAI1.1
APT-REMIT-TO-CODE Alpha 4 AP125 AP126
Element: Remit To Code The remit-to location code associated AP151 AP156
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
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP56.1 AP56.2
AP80.1 MA41.1
MA41.2 MA41.4
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 AP21.1 AP23.1
R = Accounts Receivable. AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP56.1 AP56.2
AP80.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.2
MA61.1 MAI1.1
APT-CASH-CODE Alpha 4 AP125 AP126
Element: 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.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 AP21.1 AP23.1
class, process level, company, or pay AP25.1 AP25.2
group defaults. AP26.1 AP27.1
AP28.1 AP28.2
AP56.1 AP56.2
AP80.1 MA41.1
MA41.2 MA41.4
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
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP56.1 AP56.2
AP80.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.2
MA61.1 MAI1.1
APT-DRAFT-AMOUNT Signed 18.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
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP56.1 AP56.2
AP80.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.2
MA61.1 MAI1.1
APT-APPLIED-AMT Signed 18.2 AP125 AP126
Element: Intl 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
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP56.1 AP56.2
AP80.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.2
MA61.1 MAI1.1
APT-TRAN-ND Numeric 1 AP125 AP126
Element: Acct Nd The number of decimal positions defined AP151 AP156
for the bill of exchange currency. AP180 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP20.8
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP56.1 AP56.2
AP80.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.2
MA61.1 MAI1.1
APT-ORIG-RATE Signed 14.7 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
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP56.1 AP56.2
AP80.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.2
MA61.1 MAI1.1
APT-BASE-ORIG-AMT Signed 18.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
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP56.1 AP56.2
AP80.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.2
MA61.1 MAI1.1
APT-BASE-ACT-AMT Signed 18.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
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP56.1 AP56.2
AP80.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.2
MA61.1 MAI1.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.3
AP20.4 AP20.5
AP20.7 AP20.8
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP56.1 AP56.2
AP80.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.2
MA61.1 MAI1.1
APT-ACT-RATE Signed 14.7 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
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP56.1 AP56.2
AP80.1 MA41.1
MA41.2 MA41.4
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
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP56.1 AP56.2
AP80.1 MA41.1
MA41.2 MA41.4
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
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP56.1 AP56.2
AP80.1 MA41.1
MA41.2 MA41.4
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
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP56.1 AP56.2
AP80.1 MA41.1
MA41.2 MA41.4
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
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP56.1 AP56.2
AP80.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.2
MA61.1 MAI1.1
APT-DISHONOR-DATE Numeric 8 (yyyymmdd) AP125 AP126
Element: Dishonor 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
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP56.1 AP56.2
AP80.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.2
MA61.1 MAI1.1
APT-CANCEL-DATE Numeric 8 (yyyymmdd) AP125 AP126
Element: Cancel 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
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP56.1 AP56.2
AP80.1 MA41.1
MA41.2 MA41.4
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
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP56.1 AP56.2
AP80.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.2
MA61.1 MAI1.1
APT-REC-STATUS Numeric 1 AP125 AP126
Element: Rec 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. AP21.1 AP23.1
3 = Cashed. AP25.1 AP25.2
4 = Dishonored. AP26.1 AP27.1
5 = Canceled. AP28.1 AP28.2
AP56.1 AP56.2
AP80.1 MA41.1
MA41.2 MA41.4
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. AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP56.1 AP56.2
AP80.1 MA41.1
MA41.2 MA41.4
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
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP56.1 AP56.2
AP80.1 MA41.1
MA41.2 MA41.4
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
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP56.1 AP56.2
AP80.1 MA41.1
MA41.2 MA41.4
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
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP56.1 AP56.2
AP80.1 MA41.1
MA41.2 MA41.4
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. AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP56.1 AP56.2
AP80.1 MA41.1
MA41.2 MA41.4
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 AP21.1
N = No. AP23.1 AP25.1
Y = Yes. AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP56.1
AP56.2 AP80.1
MA41.1 MA41.2
MA41.4 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
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP56.1 AP56.2
AP80.1 MA41.1
MA41.2 MA41.4
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
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP56.1 AP56.2
AP80.1 MA41.1
MA41.2 MA41.4
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: Jrnl Book Nbr The journal book assigned to the AP151 AP156
transaction. AP180 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP20.8
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP56.1 AP56.2
AP80.1 MA41.1
MA41.2 MA41.4
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-CODE AP125 AP126
TRANS-IDENT AP136 AP151
AP156 AP166
AP180 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP20.8
AP21.1 AP213
AP23.1 AP230
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP284 AP56.1
AP56.2 AP80.1
CB300 MA41.1
...
APTSET10 CASH-CODE Subset AP181
PAY-GROUP Where (STATEMENT-NBR != Zeroes )
STATEMENT-NBR
DRAFT-NBR
SUFFIX
APTSET2 CASH-CODE KeyChange AP167 AP181
REC-STATUS
BANK-INST-CODE
DRAFT-NBR
SUFFIX
TRANS-IDENT
COMPANY
VENDOR
APTSET3 PAY-GROUP KeyChange, Subset AP125 AP126
REC-STATUS Where REC-STATUS = 1 AP151 AP156
DRAFT-DATE Or REC-STATUS = 2 AP180 AP20.1
BANK-INST-CODE AP20.2 AP20.3
DRAFT-NBR AP20.4 AP20.5
SUFFIX AP20.7 AP20.8
TRANS-IDENT AP21.1 AP23.1
AP25.1 AP25.2
AP250 AP26.1
AP27.1 AP28.1
AP28.2 AP56.1
AP56.2 AP80.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.2 MA61.1
...
APTSET4 PAY-GROUP KeyChange AP266 AP28.1
VENDOR AP28.2
REC-STATUS
DRAFT-NBR
SUFFIX
BANK-INST-CODE
TRANS-IDENT
APTSET5 CASH-CODE KeyChange, Subset AP180 AP80.1
MATURITY-DATE Where GL-UPDATE-FL = "N"
PAY-GROUP And REC-STATUS > 1
BANK-INST-CODEAnd REC-STATUS < 5
DRAFT-NBR
SUFFIX
TRANS-IDENT
APTSET6 BANK-INST-CODEKeyChange, Subset AP125 AP126
DRAFT-NBR Where REC-STATUS != 5 AP151 AP156
SUFFIX AP180 AP20.1
VENDOR AP20.2 AP20.3
PAY-GROUP AP20.4 AP20.5
AP20.7 AP20.8
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP56.1 AP56.2
AP80.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.2
MA61.1 MAI1.1
APTSET7 PAY-GROUP KeyChange AP125 AP126
BANK-INST-CODE AP151 AP156
VENDOR AP180 AP20.1
DRAFT-NBR AP20.2 AP20.3
SUFFIX AP20.4 AP20.5
TRANS-IDENT AP20.7 AP20.8
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP305 AP56.1
AP56.2 AP80.1
AP91.2 MA41.1
MA41.2 MA41.4
MA41.7 MA43.2
...
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
|