Lawson Insight Technical Documentation |
|
APPAYMENT
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
AP131 AP178 AP195 AP197 AP213 AP220
AP240 AP260 AP282 AP284 AP57.2 AR48.3
BL120 BL122 BL130 BL20.1 BL20.3 BL21.2
BL21.5 BL29.1 BL29.2 BL520 BL820 BL92.1
EE230 IC28.1 MA180 MA530 MA531 MA67.1
MA67.2 MA80.1 MAED.1 OE10.1 OE10.2 OE10.3
OE10.4 OE10.5 OE10.6 OE10.7 OE10.8 OE11.1
OE11.4 OE11.8 OE11.9 OE110 OE111 OE113
OE114 OE116 OE129 OE13.2 OE13.3 OE13.5
OE13.6 OE14.4 OE30.1 OE30.2 OE30.3 OE30.4
OE30.5 OE30.6 OE30.7 OE30.9 OE510 OE530
OE81.1 OE810 OE830 OE90.1 OE90.2 PO100
PO101 PO122 PO131 PO20.1 PO21.2 PO21.3
PO21.4 PO21.5 PO22.1 PO23.1 PO29.1 PO30.1
PO30.2 PO30.3 PO300 PO31.1 PO31.2 PO32.2
PO33.1 PO34.1 PO35.1 PO38.1 PO39.1 PO39.2
PO44.1 PO50.1 PO52.1 PO520 POI3.1 POIE.1
POII.1 POIJ.1 PR277 UK277 RQ10.1 RQ10.2
WH20.2 WH20.7 AP00.5 AP145 AP146 AP230
AP245 AP250 AP270 AM115 AM117 AM15.1
AM15.2 AM15.3 AM15.4 AM20.1 AM20.3 AM21.1
AM21.3 AM500 AM51.1 AM551 AM97.1 AP10.1
AP92.2 API3.1 API4.1 IC840 PR05.1 PR05.3
PR226 PR247 PR26.1 PR47.1 UK47.1 EE30.1
AP156 AP265 AP255 AP90.5
UPDATED BY
AP101 AP102 AP115 AP125 AP126 AP141
AP150 AP151 AP155 AP160 AP161 AP170
AP180 AP181 AP190 AP191 AP193 AP198
AP25.1 AP25.2 AP26.1 AP27.1 AP28.1 AP28.2
AP30.1 AP30.3 AP30.4 AP300 AP32.1 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 MA60.2
MA60.4 MA61.1 MA65.1 MA66.3 MA70.1 MA75.1
MAI1.1 AP305
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
APP-COMPANY Numeric 4 AP180 AP181
Element: Company The company number associated with the AP190 AP28.1
invoice payment. Must be a valid record AP28.2 AP30.3
in the Accounts Payable Company file. 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
Element: Vendor The vendor number associated with the AP181 AP190
invoice payment. Must be a valid record AP28.1 AP28.2
in the Vendor file. 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
Element: Invoice NumberThe invoice number. Must be a valid AP181 AP190
record in the Accounts Payable Invoice AP28.1 AP28.2
file. AP30.3 AP32.1
AP35.1 AP45.1
AP520 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520
APP-SUFFIX Numeric 3 AP125 AP126
Element: Invoice SuffixThe invoice suffix number. Represents AP170 AP180
the occurrence value of the invoice for AP181 AP190
recurring invoices, employee advances, AP193 AP25.1
and prepayment credit memos. AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.3
AP32.1 AP35.1
AP45.1 AP520
MA70.1 MA75.1
APP-CANCEL-SEQ Numeric 4 AP180 AP181
Element: Sequence NumbeThe sequence number assigned upon the AP190 AP28.1
cancellation of a distributed invoice. AP28.2 AP30.4
The first sequence assigned is 9999. AP32.1 AP45.1
APP-SEQ-NBR Numeric 4 AP170 AP180
Element: Sequence NumbeAn 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
Element: Sequence NumbeThe 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
Element: 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
To Company Base The currency of the invoice. Must be a AP190 AP28.1
Currency 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
Element: 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 EE135
EE35.1 EE35.2
EE520 MA61.1
MAI1.1
APP-PAY-COMPANY Numeric 4 AP151 AP180
Element: 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
Element: 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
Element: 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 MA61.1
MAI1.1
APP-ENCLOSURE Alpha 1 AP180 AP181
Element: All Flag 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
Element: 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 AP26.1
payment. Valid values are: AP27.1 AP28.1
AP28.2 AP30.3
Y = Yes. Invoice payment is on hold. AP30.4 AP32.1
Blank = Invoice payment is not on hold. AP35.1 AP36.1
AP40.1 AP45.1
AP520 AP55.2
AP56.2 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520 MA310
MA60.2 MA60.4
MA61.1 MA65.1
MAI1.1
APP-VEN-CLASS Alpha 3 AP115 AP180
Element: 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
Element: Vendor PrioritThe 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
Element: 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 18.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.2
API1.1 API2.1
EE135 EE35.1
EE35.2 EE520
MA310 MA60.2
MA60.4 MA61.1
MA65.1 MAI1.1
APP-BASE-ACT-AMT Signed 18.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 MA60.2
MA60.4 MA61.1
MA65.1 MAI1.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 18.2 AP180 AP181
Element: Intl Amt 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.2 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520 MA310
MA60.2 MA60.4
MA61.1 MA65.1
MAI1.1
APP-TRAN-ND Numeric 1 AP180 AP181
Account Currency The number of decimal places defined AP190 AP28.1
Code 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 18.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
MA70.1 MA75.1
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 18.2 AP150 AP170
Element: Intl Amt 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 AP35.1
AP45.1 AP520
AP55.2 API1.1
API2.1 MA61.1
MAI1.1
APP-TRAN-DISC-AMT Signed 18.2 AP150 AP180
Element: Intl Amt 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
AP35.1 AP45.1
AP520 AP55.2
API1.1 API2.1
MA61.1 MAI1.1
APP-BASE-CHK-AMT Signed 18.2 AP150 AP170
Element: Intl Amt 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
MA70.1 MA75.1
APP-TRAN-CHK-AMT Signed 18.2 AP150 AP170
Element: Intl Amt 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
MA70.1 MA75.1
APP-BASE-INC-WH Signed 18.2 AP150 AP170
Element: Intl Amt 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 18.2 AP150 AP170
Element: Intl Amt 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 18.2 AP170 AP180
Element: Intl Amt 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 18.2 AP170 AP180
Element: Gain or Loss AThe 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. MA70.1 MA75.1
APP-UNRL-REV-DATE Numeric 8 (yyyymmdd) AP180 AP181
Element: Date The date of the last currency AP190 AP191
revaluation that resulted in the AP28.1 AP28.2
creation of an unrealized gain or loss AP30.3 AP45.1
transaction.
APP-ACT-CNV-RATE Signed 14.7 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
Element: Accounting UniThe accounting unit used for posting AP181 AP190
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
Element: 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
Element: Subaccount The subaccount number used for posting AP181 AP190
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
Element: 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 MA61.1
MAI1.1
APP-DISC-DATE Numeric 8 (yyyymmdd) AP150 AP170
Element: 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
AP45.1 AP520
API1.1 API2.1
MA61.1 MAI1.1
APP-TRANS-IDENT Numeric 10 AP150 AP151
Element: Transaction IDA 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
MA70.1 MA75.1
APP-ACCR-CODE Alpha 4 AP180 AP181
Element: Invoice AccruaThe 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
Element: 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 AP125 AP126
Element: Record Status The record status. Valid values are: AP150 AP151
AP155 AP160
0 = Unreleased AP161 AP170
1 = Released AP180 AP181
2 = Selected for Payment AP190 AP193
3 = Paid with a System Cash Payment AP25.1 AP25.2
4 = Paid with a Manual Payment AP26.1 AP27.1
5 = Paid with a Bill of Exchange Payment AP28.1 AP28.2
7 = Unreleased Manual Payment AP30.3 AP35.1
8 = Canceled (bill of exchange) AP45.1 AP520
9 = Historical AP55.1 AP55.2
AP56.1 AP56.2
Note: All void status invoice payment API1.1 API2.1
records should have a historical status. CB06.2 CB191
EE135 EE35.1
EE35.2 EE520
MA61.1 MA66.3
MA70.1 MA75.1
MAI1.1
APP-TRANS-NBR Alpha 10 (Right Justified) AP151 AP155
Element: Payment NumberThe 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
MA70.1 MA75.1
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
MA70.1 MA75.1
APP-BANK-INST-CODE Alpha 3 AP115 AP150
Element: 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
Element: 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
MA70.1 MA75.1
APP-INCOME-CODE Alpha 4 AP180 AP181
Element: 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
Element: Separate PaymeIndicates 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
Element: Pay ImmediatelIndicates 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
Element: 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
Element: 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
Element: 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
Element: 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
Element: 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 AP30.3
general ledger withholding accrual AP45.1 AP520
account to the invoice. Must be a valid API1.1 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
Element: Match DiscountIndicates if a discount was taken AP190 AP28.1
during the invoice matching process. AP28.2 AP45.1
" " AP520 MA61.1
Y = Yes MA70.1 MA75.1
MAI1.1
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
Element: Open Invoice AThe 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
Element: Invoice AmountThe net invoice amount paid in the
currency of the invoice.
APP-PMT-STATUS Derived
Element: Payment StatusDisplays 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
Element: 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
Element: Ap Inv Date
APP-AP-PO-NBR Derived
Element: Ap Po Nbr
APP-AP-INV-TYPE Derived
Element: Ap Inv Type
APP-AP-BASE-INV Derived
Element: Ap Base Inv
APP-AP-FORMAT-NBR Derived
Element: Ap Format Nbr
APPAYMENT FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
APPSET1 COMPANY This index is used to access payment AP115 AP125
VENDOR records for a specific invoice. AP126 AP131
INVOICE AP141 AP150
SUFFIX AP151 AP170
CANCEL-SEQ AP178 AP180
SEQ-NBR AP181 AP190
VOID-SEQ AP191 AP193
AP195 AP197
AP198 AP213
AP220 AP240
AP25.1 AP25.2
AP26.1 AP260
AP27.1 AP28.1
AP28.2 AP282
AP284 AP30.1
...
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 AM115 AM117
REC-STATUS records for a specific invoice by AM15.1 AM15.2
VENDOR payment status. AM15.3 AM15.4
INVOICE KeyChange AM20.1 AM20.3
SUFFIX AM21.1 AM21.3
CANCEL-SEQ AM500 AM51.1
SEQ-NBR AM551 AM97.1
VOID-SEQ AP10.1 AP102
COMPANY AP141 AP40.1
AP92.2 API3.1
API4.1 IC840
PR05.1 PR05.3
PR226 PR247
PR26.1 PR47.1
UK47.1
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 AP125 AP126
BANK-INST-CODErecord with associated check records. AP151 AP155
TRANS-IDENT The index accesses check records AP156 AP160
VENDOR associated with a specific transaction AP161 AP180
INVOICE ID by pay group and payment code. AP181 AP190
SUFFIX KeyChange, Subset AP25.1 AP25.2
CANCEL-SEQ Where TRANS-IDENT != Zeroes AP26.1 AP265
SEQ-NBR AP27.1 AP28.1
VOID-SEQ AP28.2 AP32.1
COMPANY AP55.1 AP55.2
AP56.1 AP56.2
CB06.2 CB191
MA61.1 MAI1.1
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-PAY-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
APP-PROC-GRP -> CCF-PROC-GRP
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
Cbtrans CBTRANS Not Required
Valid When CHK-SERIAL-NUM = Zeroes
APP-BANK-INST-CODE -> CBT-BANK-INST-CODE
APP-TRANS-IDENT -> CBT-TRANS-IDENT
Cbtrans Tape CBTRANS Not Required
Valid When CHK- = APP-
And CHK-REC-STATUS = 2
And CHK-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
Cbstmtdtl CBSTMTDTL
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
APP-CASH-CODE -> CSD-CASH-CODE
CSD-LINE-NBR
|