 |
Lawson Insight Technical Documentation |
|
APPAYMENT FILE
Invoice Payment
The Invoice Payment file contains invoice payment records. Each invoice in
the Accounts Payable Invoice file has one or more corresponding invoice
payment records in this file. A split invoice (partially paid invoice) has at
least two invoice payment records.
AP150 (Cash Requirements) and AP151 (Bill of Exchange Generation) access this
file to select invoices for payment.
REFERENCED BY
AC550 AC750 AP195 AP197 AP213 AP220
AP240 AP260 AP282 AP284 AP57.2 AR48.3
EE230 MAED.1 POIJ.1 PR277 AP00.5 AP145
AP146 AP230 AP245 AP250 AP270 AP10.1
AP92.2 API3.1 API4.1 EE30.1 AP156 AP265
AP255 AP90.5
UPDATED BY
AP101 AP102 AP115 AP141 AP150 AP151
AP155 AP160 AP161 AP170 AP180 AP181
AP190 AP191 AP193 AP198 AP28.1 AP28.2
AP30.1 AP30.3 AP30.4 AP300 AP32.1 AP32.2
AP35.1 AP36.1 AP40.1 AP45.1 AP520 AP55.1
AP55.2 AP56.1 AP56.2 API1.1 API2.1 CB06.2
CB191 EE135 EE35.1 EE35.2 EE520 MA310
MA65.1 AP305
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
APP-COMPANY Numeric 4 AP180 AP181
Company The company number associated with the AP190 AP260
invoice payment. Must be a valid record AP28.1 AP28.2
in the Accounts Payable Company file. AP30.3 AP32.1
AP35.1 AP45.1
AP520 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520
APP-VENDOR Alpha 9 (Right Justified) AP115 AP180
Vendor The vendor number associated with the AP181 AP190
invoice payment. Must be a valid record AP260 AP28.1
in the Vendor file. AP28.2 AP30.3
AP32.1 AP35.1
AP45.1 AP520
API1.1 API2.1
EE135 EE35.1
EE35.2 EE520
APP-INVOICE Alpha 22 AP115 AP180
Invoice Number The invoice number. Must be a valid AP181 AP190
record in the Accounts Payable Invoice AP260 AP28.1
file. AP28.2 AP30.3
AP32.1 AP35.1
AP45.1 AP520
API1.1 API2.1
EE135 EE35.1
EE35.2 EE520
APP-SUFFIX Numeric 3 AP170 AP180
Invoice Suffix The invoice suffix number. Represents AP181 AP190
the occurrence value of the invoice for AP193 AP260
recurring invoices, employee advances, AP28.1 AP28.2
and prepayment credit memos. AP30.3 AP32.1
AP35.1 AP45.1
AP520
APP-CANCEL-SEQ Numeric 4 AP180 AP181
Cancel Sequence The sequence number assigned upon the AP190 AP260
cancellation of a distributed invoice. AP28.1 AP28.2
The first sequence assigned is 9999. AP30.4 AP32.1
AP45.1
APP-SEQ-NBR Numeric 4 AP170 AP180
Sequence Number An automatically assigned sequence AP181 AP190
number. AP28.1 AP28.2
AP30.3 AP32.1
AP35.1 AP45.1
AP520 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520
APP-VOID-SEQ Numeric 4 AP180 AP181
Void Sequence The void sequence for the invoice AP190 AP28.1
payment. Used by the system to keep AP28.2 AP32.1
payment records unique each time a AP45.1
payment is voided and the invoice is
reinstated for payment.
APP-VOID-DATE Numeric 8 (yyyymmdd) AP180 AP181
Void Date The date assigned to a voided payment AP190 AP28.1
associated with the invoice payment AP28.2 AP45.1
record.
APP-INV-CURRENCY Alpha 5 AP180 AP181
Invoice Currency The currency of the invoice. Must be a AP190 AP28.1
valid record in the Currency Code file. AP28.2 AP30.3
AP35.1 AP45.1
AP520 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520
APP-PAY-VENDOR Alpha 9 (Right Justified) AP115 AP180
Pay Vendor The pay vendor associated with the AP181 AP190
invoice payment. Represents the vendor AP28.1 AP28.2
that will receive payment for the AP30.1 AP30.3
invoice. Must be a valid record in the AP35.1 AP45.1
Vendor file. AP520 AP55.2
AP56.2 API1.1
API2.1 CB06.2
EE135 EE35.1
EE35.2 EE520
APP-REMIT-TO-CODE Alpha 4 AP115 AP180
Remit To Location The remit-to location associated with AP181 AP190
Code the invoice payment. Must be a valid AP28.1 AP28.2
record in the Vendor Location file. AP30.1 AP30.3
AP35.1 AP45.1
AP520 AP55.1
AP55.2 AP56.2
API1.1 API2.1
CB06.2
APP-PAY-COMPANY Numeric 4 AP151 AP180
Pay Company The company associated with the pay AP181 AP190
vendor. Must be a valid record in the AP28.1 AP28.2
Accounts Payable Company file. AP30.3 AP45.1
AP520 AP55.1
AP55.2 API1.1
API2.1 CB06.2
EE135 EE35.1
EE35.2 EE520
APP-CASH-CODE Alpha 4 AP115 AP150
Cash Code The cash code assigned to the invoice. AP151 AP160
Represents the bank account the invoice AP161 AP180
payment is to be paid from. Must be a AP181 AP190
valid record in the Cash Code file. AP28.1 AP28.2
AP30.3 AP35.1
AP45.1 AP520
AP55.1 AP55.2
AP56.1 AP56.2
API1.1 API2.1
CB06.2 EE135
EE35.1 EE35.2
EE520
APP-DUE-DATE Numeric 8 (yyyymmdd) AP170 AP180
Due Date The invoice due date. AP150 and AP151 AP181 AP190
use this date to determine whether to AP193 AP28.1
schedule the invoice payment and whether AP28.2 AP30.3
to take a discount, if applicable. AP35.1 AP45.1
AP520 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520
APP-ENCLOSURE Alpha 1 AP180 AP181
Enclosure Indicates whether the invoice payment AP190 AP28.1
requires an enclosure. Valid values are: AP28.2 AP30.3
AP35.1 AP45.1
N = No. AP520 API1.1
Y = Yes. API2.1 EE135
EE35.1 EE35.2
EE520
APP-HOLD-FLAG Alpha 1 AP141 AP150
On Hold Flag Indicates whether the invoice payment AP170 AP180
is on hold. If this field is Yes, AP150 AP181 AP190
or AP151 will not select the invoice AP193 AP28.1
payment. Valid values are: AP28.2 AP30.3
AP30.4 AP32.1
Y = Yes. Invoice payment is on hold. AP35.1 AP36.1
Blank = Invoice payment is not on hold. AP40.1 AP45.1
AP520 AP55.2
AP56.2 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520 MA310
MA65.1
APP-VEN-CLASS Alpha 3 AP115 AP180
Vendor Class The vendor class associated with the AP181 AP190
invoice payment. Must be a valid record AP28.1 AP28.2
in the Vendor Class file. AP30.3 AP35.1
AP45.1 AP520
API1.1 API2.1
EE135 EE35.1
EE35.2 EE520
APP-VEN-PRIORITY Numeric 2 AP115 AP180
Vendor Priority The payment priority defined for the AP181 AP190
vendor. Valid values are 1 (highest AP28.1 AP28.2
priority) through 99 (lowest priority). AP30.3 AP35.1
00 AP45.1 AP520
99 API1.1 API2.1
EE135 EE35.1
EE35.2 EE520
APP-PROC-GRP Alpha 4 (Lower Case) AP102 AP115
Process Group The process group assigned to the AP180 AP181
payment. A process group is an AP190 AP28.1
identifier used for separating vendors AP28.2 AP30.3
into different groups to enable AP35.1 AP45.1
concurrent processing within the cash AP520 API1.1
payment cycle. Must be a valid record in API2.1 EE135
the Process Group file. EE35.1 EE35.2
EE520
APP-BASE-PMT-AMT Signed 15.2 AP170 AP180
Base Payment Amount The amount of the invoice payment in AP181 AP190
(at entry) the company base currency. This amount AP193 AP28.1
is calculated using the currency AP28.2 AP30.1
exchange rate in effect when the invoice AP30.3 AP35.1
payment was created. AP45.1 AP520
AP55.2 AP56.1
AP56.2 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520 MA310
MA65.1
APP-BASE-ACT-AMT Signed 15.2 AP170 AP180
Base Payment Amount The amount of the invoice payment in AP181 AP190
(revalued) the company base currency. For non-base AP191 AP193
currency invoices, this amount may be AP28.1 AP28.2
updated when currency revaluation takes AP30.1 AP30.3
place to account for exchange rate AP30.4 AP35.1
fluctuations. AP45.1 AP520
API1.1 API2.1
EE135 EE35.1
EE35.2 EE520
MA310 MA65.1
APP-BASE-ND Numeric 1 AP180 AP181
Base Number Of The number of decimal places defined AP190 AP28.1
Decimals for the company base currency. AP28.2 AP30.3
AP35.1 AP45.1
AP520 AP55.2
API1.1 API2.1
EE135 EE35.1
EE35.2 EE520
APP-TRAN-PMT-AMT Signed 15.2 AP180 AP181
Payment Amount The amount of the invoice payment in AP190 AP28.1
the currency of the invoice. AP28.2 AP30.1
AP30.3 AP30.4
AP35.1 AP45.1
AP520 AP55.2
AP56.1 AP56.2
API1.1 API2.1
EE135 EE35.1
EE35.2 EE520
MA310 MA65.1
APP-TRAN-ND Numeric 1 AP180 AP181
Transaction Number The number of decimal places defined AP190 AP28.1
of Decimals for the invoice currency. AP28.2 AP30.3
AP35.1 AP45.1
AP520 AP55.2
API1.1 API2.1
EE135 EE35.1
EE35.2 EE520
APP-BANK-CHK-AMT Signed 15.2 AP150 AP170
Bank Account The amount of the invoice payment in AP180 AP181
Currency Amount the currency of the bank account (cash AP190 AP28.1
code). AP28.2 AP45.1
AP520 AP55.1
AP55.2 CB06.2
APP-BANK-ND Numeric 1 AP150 AP170
Bank Account The number of decimal places defined AP180 AP181
Currency Decimals for the bank account currency. AP190 AP28.1
AP28.2 AP45.1
AP520 AP55.1
AP55.2
APP-BASE-DISC-AMT Signed 15.2 AP150 AP170
Base Discount Amount The amount of the available discount AP180 AP181
for the invoice payment in the company AP190 AP191
base currency. AP193 AP28.1
AP28.2 AP30.1
AP30.3 AP32.2
AP35.1 AP45.1
AP520 AP55.2
API1.1 API2.1
APP-TRAN-DISC-AMT Signed 15.2 AP150 AP180
Discount Amount The amount of the available discount AP181 AP190
for the invoice payment in the currency AP28.1 AP28.2
of the invoice. AP30.1 AP30.3
AP32.2 AP35.1
AP45.1 AP520
AP55.2 API1.1
API2.1
APP-BASE-CHK-AMT Signed 15.2 AP150 AP170
Base Payment Amount The net payment amount for the invoice AP180 AP181
in the company base currency. AP190 AP193
AP28.1 AP28.2
AP35.1 AP45.1
AP520 AP55.1
AP55.2 CB06.2
EE135 EE35.1
EE35.2 EE520
APP-TRAN-CHK-AMT Signed 15.2 AP150 AP170
Payment Amount The net payment amount for the invoice AP180 AP181
in the currency of the invoice. AP190 AP193
AP28.1 AP28.2
AP35.1 AP45.1
AP520 AP55.1
AP55.2 CB06.2
EE135 EE35.1
EE35.2 EE520
APP-BASE-INC-WH Signed 15.2 AP150 AP170
Base Income Withheld The reportable income withholding AP180 AP181
amount in the company base currency. AP190 AP193
AP28.1 AP28.2
AP35.1 AP45.1
APP-TRAN-INC-WH Signed 15.2 AP150 AP170
Income Withholding The reportable income withholding AP180 AP181
amount in the currency of the invoice. AP190 AP28.1
AP28.2 AP35.1
AP45.1 AP520
APP-TRAN-INC-AMT Signed 15.2 AP170 AP180
Income Amount The portion of the invoice amount AP181 AP190
classified as reportable income. AP193 AP28.1
AP28.2 AP35.1
AP45.1 AP520
API1.1 API2.1
APP-GAINLOS-AMT Signed 15.2 AP170 AP180
Gain or Loss Amount The currency gain or loss amount. This AP181 AP190
amount is calculated when the invoice is AP193 AP28.1
revalued to account for currency AP28.2 AP45.1
exchange rate fluctuations.
APP-UNRL-REV-DATE Numeric 8 (yyyymmdd) AP180 AP181
Last Revaluation The date of the last currency AP190 AP191
Date revaluation that resulted in the AP28.1 AP28.2
creation of an unrealized gain or loss AP45.1
transaction.
APP-ACT-CNV-RATE Signed 12.6 AP170 AP180
Currency Exchange The currency exchange rate used to AP181 AP190
Rate convert the invoice payment amount to AP191 AP193
the company base currency. This field AP28.1 AP28.2
may be updated when the invoice is AP30.3 AP35.1
revalued. AP45.1 AP520
AP55.1 AP55.2
API1.1 API2.1
CB06.2 EE135
EE35.1 EE35.2
EE520
APP-DSC-ACCT-UNIT Alpha 15 AP170 AP180
Discount Accounting The accounting unit used for posting AP181 AP190
Unit the discount amount to the general AP193 AP28.1
ledger. Must be a valid accounting unit AP28.2 AP30.3
in the Lawson General Ledger system. AP45.1 AP520
API1.1 API2.1
APP-DSC-ACCOUNT Numeric 6 AP170 AP180
Discount Account The account number used for posting the AP181 AP190
discount amount to the general ledger. AP193 AP28.1
Must be a valid account in the Lawson AP28.2 AP30.3
General Ledger system. AP45.1 AP520
API1.1 API2.1
APP-DSC-SUB-ACCT Numeric 4 AP170 AP180
Discount Subaccount The subaccount number used for posting AP181 AP190
Number the discount amount to the general AP193 AP28.1
ledger. Must be a valid subaccount in AP28.2 AP30.3
the Lawson General Ledger system. AP45.1 AP520
API1.1 API2.1
APP-DISCOUNT-RT Percent 5.3 (Percent) AP180 AP181
Discount Rate The rate used to calculate the discount AP190 AP28.1
amount of the invoice payment. AP28.2 AP45.1
AP520 API1.1
API2.1
APP-DISC-DATE Numeric 8 (yyyymmdd) AP150 AP170
Discount Date The date through which the available AP180 AP181
discount amount of the invoice can be AP190 AP193
taken. AP28.1 AP28.2
AP30.1 AP30.3
AP32.2 AP45.1
AP520 API1.1
API2.1
APP-TRANS-IDENT Numeric 10 AP150 AP151
Transaction ID A sequencing number created by AP150 AP170 AP180
(Cash Requirements) or AP151 (Bill of AP181 AP190
Exchange Generation) to sequence AP193 AP28.1
payments. Used to link the Invoice AP28.2 AP45.1
Payment record with the associated AP520 AP55.1
Accounts Payable Cash Payment record. AP55.2 AP56.1
AP56.2 CB06.2
EE135 EE35.1
EE35.2 EE520
APP-ACCR-CODE Alpha 4 AP180 AP181
Invoice Accrual Code The invoice accrual code assigned to AP190 AP28.1
the invoice. Used to default a general AP28.2 AP30.1
ledger accrual account to the invoice. AP30.3 AP35.1
Must be a valid record in the Invoice AP45.1 AP520
Accrual Code file. API1.1 API2.1
EE135 EE35.1
EE35.2 EE520
APP-PROC-LEVEL Alpha 5 AP180 AP181
Process Level The process level associated with the AP190 AP28.1
invoice. Must be a valid record in the AP28.2 AP30.1
Accounts Payable Process Level file. AP30.3 AP35.1
AP45.1 AP520
API1.1 API2.1
EE135 EE35.1
EE35.2 EE520
APP-REC-STATUS Numeric 1 AP150 AP151
Record Status The record status. Valid values are: AP155 AP160
AP161 AP170
0 = Unreleased AP180 AP181
1 = Released AP190 AP193
2 = Selected for Payment AP28.1 AP28.2
3 = Paid with a System Cash Payment AP30.3 AP35.1
4 = Paid with a Manual Payment AP45.1 AP520
5 = Paid with a Bill of Exchange Payment AP55.1 AP55.2
7 = Unreleased Manual Payment AP56.1 AP56.2
8 = Canceled (bill of exchange) API1.1 API2.1
9 = Historical CB06.2 CB191
EE135 EE35.1
Note: All void status invoice payment EE35.2 EE520
records should have a historical status.
APP-TRANS-NBR Alpha 10 (Right Justified) AP151 AP155
Payment Number The system or manual payment number AP160 AP161
used to pay the invoice payment. AP170 AP180
AP181 AP190
AP193 AP28.1
AP28.2 AP45.1
AP520 AP55.1
AP55.2 AP56.1
AP56.2 CB06.2
EE135 EE35.1
EE35.2 EE520
APP-CHK-SUFFIX Numeric 3 AP180 AP181
Payment Suffix The system or manual payment suffix AP190 AP28.1
Number number used to pay the invoice payment. AP28.2 AP45.1
AP56.1 AP56.2
APP-BANK-INST-CODE Alpha 3 AP115 AP150
Payment Code The payment code assigned to the AP160 AP161
invoice payment. Represents a type of AP180 AP181
cash or bill of exchange payment used to AP190 AP28.1
pay the invoice payment. Must be a valid AP28.2 AP30.3
cash payment or bill of exchange payment AP35.1 AP45.1
transaction code record in the Bank AP520 AP55.1
Transaction Code file. AP55.2 AP56.2
API1.1 API2.1
CB06.2 EE135
EE35.1 EE35.2
EE520
APP-CHECK-DATE Numeric 8 (yyyymmdd) AP155 AP160
Payment Date The date assigned to the system or AP161 AP170
manual payment associated with the AP180 AP181
invoice payment record. AP190 AP193
AP28.1 AP28.2
AP35.1 AP45.1
AP520 AP55.1
AP55.2 CB06.2
EE135 EE35.1
EE35.2 EE520
APP-INCOME-CODE Alpha 4 AP180 AP181
Income Code The income code assigned to the invoice AP190 AP28.1
payment record. Used to track vendor AP28.2 AP30.3
reportable income. Must be a valid AP35.1 AP45.1
record in the Income Code file. AP520 API1.1
API2.1
APP-SEP-CHK-FLAG Alpha 1 AP170 AP180
Separate Payment Indicates whether the payment should be AP181 AP190
made on a separate payment form from AP28.1 AP28.2
other payments to the same vendor. Valid AP30.3 AP35.1
values are: AP45.1 AP520
API1.1 API2.1
N = No. EE135 EE35.1
Y = Yes. EE35.2 EE520
APP-PAY-IMM-FLAG Alpha 1 AP170 AP180
Pay Immediately Indicates whether the invoice is to be AP181 AP190
paid immediately regardless of the AP28.1 AP28.2
invoice due date. Valid values are: AP30.3 AP35.1
AP40.1 AP45.1
N = No. AP520 API1.1
Y = Yes. API2.1 EE135
EE35.1 EE35.2
EE520
APP-DISC-LOST-FLG Alpha 1 AP150 AP170
Discount Lost Indicates whether the available AP180 AP181
discount for the invoice payment was AP190 AP193
lost. Valid values are: AP28.1 AP28.2
AP30.3 AP35.1
N = No. AP45.1 AP520
Y = Yes. AP55.1 AP55.2
API1.1 API2.1
CB06.2 EE135
EE35.1 EE35.2
EE520
APP-ANTICIPATION Alpha 1 AP180 AP181
Anticipation Indicates whether anticipation criteria AP190 AP28.1
Discount should be used to calculate the discount AP28.2 AP30.3
amount for the invoice payment. Valid AP35.1 AP45.1
values are: AP520 API1.1
API2.1 EE135
Y = Yes. EE35.1 EE35.2
N = No. EE520
APP-INVOICE-GROUP Alpha 4 AP115 AP170
Invoice Group The invoice group assigned to the AP180 AP181
invoice payment. An invoice group is a AP190 AP193
user-defined character expression that AP28.1 AP28.2
can be used to select invoices for AP30.3 AP35.1
payment. AP45.1 AP520
API1.1 API2.1
EE135 EE35.1
EE35.2 EE520
APP-VENDOR-GROUP Alpha 4 AP180 AP181
Vendor Group The vendor group associated with the AP190 AP28.1
invoice payment. Must be a valid record AP28.2 AP30.3
in the Vendor Group file. AP35.1 AP45.1
AP520 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520
APP-PAY-GROUP Alpha 4 AP101 AP180
Pay Group The pay group associated with the AP181 AP190
invoice payment. A pay group is used for AP28.1 AP28.2
processing accounts payable payments. AP30.1 AP30.3
Must be a valid record in the Pay Group AP35.1 AP45.1
file. AP520 AP55.2
AP56.2 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520
APP-DISCOUNT-CODE Alpha 10 AP180 AP181
Discount Code The discount code assigned to the AP190 AP28.1
invoice payment. Used to default a AP28.2 AP30.3
general ledger discount account to the AP45.1 AP520
invoice. Must be a valid record in the API1.1 API2.1
Discount Code file.
APP-INC-ACCR-CODE Alpha 10 AP180 AP181
Income Withholding The withholding code assigned to the AP190 AP28.1
Code invoice payment. Used to default a AP28.2 AP45.1
general ledger withholding accrual AP520 API1.1
account to the invoice. Must be a valid API2.1
record in the Income Withholding Code
file.
APP-RECON-STMT-NBR Numeric 12 AP180 AP181
Reconciliation The bank-assigned reconciliation AP190 AP28.1
Statement statement number. Used only for cash AP28.2 AP45.1
codes that require reconciliation CB06.2
statements.
APP-MATCH-DISC-TAK Alpha 1 AP180 AP181
Match Discount Taken Indicates if a discount was taken AP190 AP28.1
during the invoice matching process. AP28.2 AP45.1
" " AP520
Y = Yes
APP-OPEN-BASE-PMT Derived
Open Base Invoice The amount of the invoice remaining to
Amount be paid in the company base currency.
APP-OPEN-TRAN-PMT Derived
Open Invoice Amount The amount of the invoice remaining to
be paid in the currency of the invoice.
APP-BASE-NET-PMT Derived
Base Invoice Amount The net invoice amount paid in the
Paid company base currency.
APP-TRAN-NET-PMT Derived
Invoice Amount Paid The net invoice amount paid in the
currency of the invoice.
APP-PMT-STATUS Derived
Payment Status Displays the payment status when Drill
Around(TM) is used. Valid values are:
OPEN = The payment record has an open
status.
PAID = The payment record has a paid
status.
APP-BANK-STATUS Derived
Bank Status The reconciliation status of the
payment record associated with the
invoice payment.
APP-NO-REINSTATE Derived
Payment Not If the invoice payment was paid and the
Reinstated payment was voided, this field indicates
if the split invoice has not been
reinstated by AP190 (Invoice
Reinstatement).
APP-PAID-DOC-DATE Derived
Payment Document If the invoice payment was paid with a
Date cash payment, this field contains the
date assigned to the cash payment. If
the invoice payment was paid with a bill
of exchange payment, this field contains
the date the bill of exchange was
cashed.
APP-DRAFT-ACCRUED Derived
Bill of Exchange If the invoice payment was paid with a
Accrued bill of exchange, this field indicates
whether the bill of exchange has been
accrued in the general ledger.
APP-AP-INV-DATE Derived
Ap Inv Date
APP-AP-PO-NBR Derived
Ap Po Nbr
APP-AP-INV-TYPE Derived
Ap Inv Type
APP-AP-BASE-INV Derived
Ap Base Inv
APP-AP-FORMAT-NBR Derived
Ap Format Nbr
APPAYMENT FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
APPSET1 COMPANY This index is used to access payment AC550 AC750
VENDOR records for a specific invoice. AP115 AP141
INVOICE AP150 AP151
SUFFIX AP170 AP180
CANCEL-SEQ AP181 AP190
SEQ-NBR AP191 AP193
VOID-SEQ AP195 AP197
AP198 AP213
AP220 AP240
AP260 AP28.1
AP28.2 AP282
AP284 AP30.1
AP30.3 AP30.4
AP300 AP305
AP32.1 AP32.2
...
APPSET10 REC-STATUS This index is used to access payment AP00.5 AP101
COMPANY records by a specific status. AP145 AP146
PROC-LEVEL KeyChange AP230 AP245
VENDOR AP250 AP270
INVOICE
SUFFIX
CANCEL-SEQ
SEQ-NBR
VOID-SEQ
PAY-GROUP
APPSET12 PAY-GROUP This index is used for inquiring on AP55.2 AP56.2
VENDOR status 1 and 2 payment records by pay
INVOICE group and vendor.
SUFFIX KeyChange, Subset
CANCEL-SEQ Where (REC-STATUS = 1 )
SEQ-NBR Or (REC-STATUS = 2 )
VOID-SEQ
COMPANY
APPSET2 PAY-GROUP This index is used to access payment AP10.1 AP102
REC-STATUS records for a specific invoice by AP141 AP270
VENDOR payment status. AP40.1 AP92.2
INVOICE KeyChange API3.1 API4.1
SUFFIX
CANCEL-SEQ
SEQ-NBR
VOID-SEQ
COMPANY
APPSET3 PAY-GROUP This index is used to access open AP150 AP151
REC-STATUS payment records for cash requirements. AP170
PAY-IMM-FLAG The index is also used by AP170 (Payment
PROC-GRP Closing) to aid in concurrent
VENDOR processing.
INVOICE KeyChange
SUFFIX
CANCEL-SEQ
SEQ-NBR
VOID-SEQ
COMPANY
APPSET4 COMPANY This index is used to access open AP191 AP30.3
VENDOR payment records for a specific vendor AP35.1 EE30.1
INVOICE and/or invoice.
SUFFIX KeyChange, Subset
CANCEL-SEQ Where REC-STATUS = 1
SEQ-NBR Or REC-STATUS = 2
VOID-SEQ
APPSET6 PAY-GROUP This index is used to link the payment AP151 AP155
BANK-INST-CODErecord with associated check records. AP156 AP160
TRANS-IDENT The index accesses check records AP161 AP180
VENDOR associated with a specific transaction AP181 AP190
INVOICE ID by pay group and payment code. AP265 AP28.1
SUFFIX KeyChange, Subset AP28.2 AP32.1
CANCEL-SEQ Where TRANS-IDENT != Zeroes AP55.1 AP55.2
SEQ-NBR AP56.1 AP56.2
VOID-SEQ CB06.2 CB191
COMPANY
APPSET8 PAY-GROUP This index is used by AP255 (Bank AP255 AP90.5
CASH-CODE Account Payment History) to access
TRANS-NBR payment records by pay group, cash code,
BANK-INST-CODEand the payment number.
COMPANY KeyChange
VENDOR
INVOICE
SUFFIX
CANCEL-SEQ
SEQ-NBR
VOID-SEQ
APPAYMENT FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Apcompany APCOMPANY Required
APP-COMPANY -> CPY-COMPANY
Apdrafts APDRAFTS Not Required
APP-BANK-INST-CODE -> APT-BANK-INST-CODE
APP-TRANS-IDENT -> APT-TRANS-IDENT
Apinvoice APINVOICE Required
APP-COMPANY -> API-COMPANY
APP-VENDOR -> API-VENDOR
APP-INVOICE -> API-INVOICE
APP-SUFFIX -> API-SUFFIX
APP-CANCEL-SEQ -> API-CANCEL-SEQ
Appayvendor APVENMAST Required
CPY-VENDOR-GROUP -> VEN-VENDOR-GROUP
APP-PAY-VENDOR -> VEN-VENDOR
Approclev APPROCLEV Required
APP-COMPANY -> APR-COMPANY
APP-PROC-LEVEL -> APR-PROC-LEVEL
Apvenclass APVENCLASS Required
CPY-VENDOR-GROUP -> VCL-VENDOR-GROUP
APP-VEN-CLASS -> VCL-VEN-CLASS
Apvencurrbal APVENBAL Not Required
CPY-VENDOR-GROUP -> VBA-VENDOR-GROUP
APP-COMPANY -> VBA-COMPANY
APP-VENDOR -> VBA-VENDOR
APP-REMIT-TO-CODE -> VBA-LOCATION-CODE
Apvengroup APVENGROUP Required
CPY-VENDOR-GROUP -> VGP-VENDOR-GROUP
Apvenloc APVENLOC Not Required
CPY-VENDOR-GROUP -> VLO-VENDOR-GROUP
APP-PAY-VENDOR -> VLO-VENDOR
APP-REMIT-TO-CODE -> VLO-LOCATION-CODE
Apvenmast APVENMAST Required
CPY-VENDOR-GROUP -> VEN-VENDOR-GROUP
APP-VENDOR -> VEN-VENDOR
Cbbankinst CBBANKINST Required
APP-BANK-INST-CODE -> CBI-BANK-INST-CODE
Cbcashcode CBCASHCODE Required
APP-CASH-CODE -> CBC-CASH-CODE
Cbcashform CBCASHFORM Not Required
APP-CASH-CODE -> CCF-CASH-CODE
APP-BANK-INST-CODE -> CCF-BANK-INST-CODE
Cbcheck CBCHECK Required
APP-CASH-CODE -> CHK-CASH-CODE
APP-BANK-INST-CODE -> CHK-BANK-INST-CODE
APP-TRANS-IDENT -> CHK-TRANS-IDENT
Cbcpycach CBCPYCASH Required
APP-PAY-COMPANY -> CBY-COMPANY
APP-CASH-CODE -> CBY-CASH-CODE
Cbstatement CBSTATEMNT Not Required
APP-CASH-CODE -> CSM-CASH-CODE
APP-RECON-STMT-NBR -> CSM-RECON-STMT-NBR
Cbstmtdtl CBSTMTDTL Not Required
APP-BANK-INST-CODE -> CSD-BANK-INST-CODE
APP-RECON-STMT-NBR -> CSD-RECON-STMT-NBR
APP-TRANS-NBR -> CSD-PAYMENT-NBR
"V" -> CSD-TRANS-TYPE
Cbtrans CBTRANS Not Required
Valid When APP-SERIAL-NUM = Zeroes
APP-BANK-INST-CODE -> CBT-BANK-INST-CODE
APP-TRANS-IDENT -> CBT-TRANS-IDENT
Cbtrans Tape CBTRANS Not Required
Valid When APP- = APP-
And APP-REC-STATUS = 2
And APP-SERIAL-NUM != Zeroes
CHK-BANK-INST-CODE -> CBT-BANK-INST-CODE
CHK-SERIAL-NUM -> CBT-SERIAL-NUM
CHK-TRANS-IDENT -> CBT-TRANS-IDENT
Invcurrency CUCODES Required
APP-INV-CURRENCY -> CUC-CURRENCY-CODE
APPAYMENT FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Apdiscacc APDISCACC
APP-COMPANY -> DSK-COMPANY
APP-VENDOR -> DSK-VENDOR
APP-INVOICE -> DSK-INVOICE
APP-SUFFIX -> DSK-SUFFIX
APP-CANCEL-SEQ -> DSK-CANCEL-SEQ
APP-SEQ-NBR -> DSK-SEQ-NBR
DSK-VOID-SEQ
DSK-DISC-TYPE
Aphldinv APHLDINV Delete Cascades
Valid When (APP-HOLD-FLAG = "Y" )
"P" -> HLI-REC-TYPE
APP-VENDOR-GROUP -> HLI-VENDOR-GROUP
APP-COMPANY -> HLI-COMPANY
APP-VENDOR -> HLI-VENDOR
APP-INVOICE -> HLI-INVOICE
APP-SUFFIX -> HLI-SUFFIX
APP-CANCEL-SEQ -> HLI-CANCEL-SEQ
APP-SEQ-NBR -> HLI-SEQ-NBR
APP-VOID-SEQ -> HLI-VOID-SEQ
HLI-HLD-CODE
Appset6 APPAYMENT
APP-PAY-GROUP -> APP-PAY-GROUP
APP-BANK-INST-CODE -> APP-BANK-INST-CODE
APP-TRANS-IDENT -> APP-TRANS-IDENT
APP-VENDOR
APP-INVOICE
APP-SUFFIX
APP-CANCEL-SEQ
APP-SEQ-NBR
APP-VOID-SEQ
APP-COMPANY
Appset8 APPAYMENT
APP-PAY-GROUP -> APP-PAY-GROUP
APP-CASH-CODE -> APP-CASH-CODE
APP-TRANS-NBR -> APP-TRANS-NBR
APP-BANK-INST-CODE -> APP-BANK-INST-CODE
APP-COMPANY
APP-VENDOR
APP-INVOICE
APP-SUFFIX
APP-CANCEL-SEQ
APP-SEQ-NBR
APP-VOID-SEQ
Apvencomments APCOMMENTS
"V" -> APC-REC-TYPE
CPY-VENDOR-GROUP -> APC-VENDOR-GROUP
APP-VENDOR -> APC-VENDOR
Spaces -> APC-LOCATION-CODE
APP-COMPANY -> APC-COMPANY
APC-SEQ-NBR
|