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
| AP111 | AP14.5 | AP16.1 | AP233 | AP97.1 | AP97.2 |
| AP97.3 | AP97.5 | EE20.1 | EE20.2 | PR277 | UK277 |
| FIELD NAME | DESCRIPTION/VALID VALUES | UPDATED BY | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| APP-COMPANY Element: Company | Numeric 4 The company number associated with the invoice payment. Must be a valid record in the Accounts Payable Company file. |
|||||||||||||||||||||||||||||||
| APP-VENDOR Element: Vendor | Alpha 9 (Right Justified) The vendor number associated with the invoice payment. Must be a valid record in the Vendor file. |
|||||||||||||||||||||||||||||||
| APP-INVOICE Element: Invoice | Alpha 22 The invoice number. Must be a valid record in the Accounts Payable Invoice file. |
|||||||||||||||||||||||||||||||
| APP-SUFFIX Element: Suffix | Numeric 3 The invoice suffix number. Represents the occurrence value of the invoice for recurring invoices, employee advances, and prepayment credit memos. |
|
||||||||||||||||||||||||||||||
| APP-CANCEL-SEQ Element: Seq Nbr | Numeric 4 The sequence number assigned upon the cancellation of a distributed invoice. The first sequence assigned is 9999. |
|
||||||||||||||||||||||||||||||
| APP-SEQ-NBR Element: Seq Nbr | Numeric 4 An automatically assigned sequence number. |
|||||||||||||||||||||||||||||||
| APP-VOID-SEQ Element: Seq Nbr | Numeric 4 The void sequence for the invoice payment. Used by the system to keep payment records unique each time a payment is voided and the invoice is reinstated for payment. |
|
||||||||||||||||||||||||||||||
| APP-VOID-DATE Element: Date | Numeric 8 (yyyymmdd) The date assigned to a voided payment associated with the invoice payment record. |
|
||||||||||||||||||||||||||||||
| APP-INV-CURRENCY Element: To Base Curr | Alpha 5 The currency of the invoice. Must be a valid record in the Currency Code file. |
|||||||||||||||||||||||||||||||
| APP-PAY-VENDOR Element: Pay Vendor | Alpha 9 (Right Justified) The pay vendor associated with the invoice payment. Represents the vendor that will receive payment for the invoice. Must be a valid record in the Vendor file. |
|||||||||||||||||||||||||||||||
| APP-REMIT-TO-CODE Element: Remit To Code | Alpha 4 The remit-to location associated with the invoice payment. Must be a valid record in the Vendor Location file. |
|||||||||||||||||||||||||||||||
| APP-PAY-COMPANY Element: Pay Company | Numeric 4 The company associated with the pay vendor. Must be a valid record in the Accounts Payable Company file. |
|||||||||||||||||||||||||||||||
| APP-CASH-CODE Element: Cash Code | Alpha 4 The cash code assigned to the invoice. Represents the bank account the invoice payment is to be paid from. Must be a valid record in the Cash Code file. |
|||||||||||||||||||||||||||||||
| APP-DUE-DATE Element: Due Date | Numeric 8 (yyyymmdd) The invoice due date. AP150 and AP151 use this date to determine whether to schedule the invoice payment and whether to take a discount, if applicable. |
|||||||||||||||||||||||||||||||
| APP-ENCLOSURE Element: All Flag | Alpha 1 Indicates whether the invoice payment requires an enclosure. Valid values are: N = No. Y = Yes. |
|||||||||||||||||||||||||||||||
| APP-HOLD-FLAG Element: Hold Flag | Alpha 1 Indicates whether the invoice payment is on hold. If this field is Yes, AP150 or AP151 will not select the invoice payment. Valid values are: Y = Yes. Invoice payment is on hold. Blank = Invoice payment is not on hold. |
|||||||||||||||||||||||||||||||
| APP-VEN-CLASS Element: Ven Class | Alpha 3 The vendor class associated with the invoice payment. Must be a valid record in the Vendor Class file. |
|||||||||||||||||||||||||||||||
| APP-VEN-PRIORITY Element: Ven Priority | Numeric 2 The payment priority defined for the vendor. Valid values are 1 (highest priority) through 99 (lowest priority). 00 99 |
|||||||||||||||||||||||||||||||
| APP-PROC-GRP Element: Process Group | Alpha 4 (Lower Case) The process group assigned to the payment. A process group is an identifier used for separating vendors into different groups to enable concurrent processing within the cash payment cycle. Must be a valid record in the Process Group file. |
|||||||||||||||||||||||||||||||
| APP-BASE-PMT-AMT Base Payment Amount (at entry) | Signed 18.2 The amount of the invoice payment in the company base currency. This amount is calculated using the currency exchange rate in effect when the invoice payment was created. |
|||||||||||||||||||||||||||||||
| APP-BASE-ACT-AMT Base Payment Amount (revalued) | Signed 18.2 The amount of the invoice payment in the company base currency. For non-base currency invoices, this amount may be updated when currency revaluation takes place to account for exchange rate fluctuations. |
|||||||||||||||||||||||||||||||
| APP-BASE-ND Element: Base Nd | Numeric 1 The number of decimal places defined for the company base currency. |
|||||||||||||||||||||||||||||||
| APP-TRAN-PMT-AMT Element: Intl Amt | Signed 18.2 The amount of the invoice payment in the currency of the invoice. |
|||||||||||||||||||||||||||||||
| APP-TRAN-ND Element: Acct Nd | Numeric 1 The number of decimal places defined for the invoice currency. |
|||||||||||||||||||||||||||||||
| APP-BANK-CHK-AMT Bank Account Currency Amount | Signed 18.2 The amount of the invoice payment in the currency of the bank account (cash code). |
|||||||||||||||||||||||||||||||
| APP-BANK-ND Bank Account Currency Decimals | Numeric 1 The number of decimal places defined for the bank account currency. |
|
||||||||||||||||||||||||||||||
| APP-BASE-DISC-AMT Element: Intl Amt | Signed 18.2 The amount of the available discount for the invoice payment in the company base currency. |
|||||||||||||||||||||||||||||||
| APP-TRAN-DISC-AMT Element: Intl Amt | Signed 18.2 The amount of the available discount for the invoice payment in the currency of the invoice. |
|||||||||||||||||||||||||||||||
| APP-BASE-CHK-AMT Element: Intl Amt | Signed 18.2 The net payment amount for the invoice in the company base currency. |
|||||||||||||||||||||||||||||||
| APP-TRAN-CHK-AMT Element: Intl Amt | Signed 18.2 The net payment amount for the invoice in the currency of the invoice. |
|||||||||||||||||||||||||||||||
| APP-BASE-INC-WH Element: Intl Amt | Signed 18.2 The reportable income withholding amount in the company base currency. |
|
||||||||||||||||||||||||||||||
| APP-TRAN-INC-WH Element: Intl Amt | Signed 18.2 The reportable income withholding amount in the currency of the invoice. |
|
||||||||||||||||||||||||||||||
| APP-TRAN-INC-AMT Element: Intl Amt | Signed 18.2 The portion of the invoice amount classified as reportable income. |
|||||||||||||||||||||||||||||||
| APP-GAINLOS-AMT Element: Gain or Loss Amount | Signed 18.2 The currency gain or loss amount. This amount is calculated when the invoice is revalued to account for currency exchange rate fluctuations. |
|
||||||||||||||||||||||||||||||
| APP-UNRL-REV-DATE Element: Date | Numeric 8 (yyyymmdd) The date of the last currency revaluation that resulted in the creation of an unrealized gain or loss transaction. |
|
||||||||||||||||||||||||||||||
| APP-ACT-CNV-RATE Currency Exchange Rate | Signed 14.7 The currency exchange rate used to convert the invoice payment amount to the company base currency. This field may be updated when the invoice is revalued. |
|||||||||||||||||||||||||||||||
| APP-DSC-ACCT-UNIT Element: Acct Unit | Alpha 15 The accounting unit used for posting the discount amount to the general ledger. Must be a valid accounting unit in the Lawson General Ledger system. |
|||||||||||||||||||||||||||||||
| APP-DSC-ACCOUNT Element: Account | Numeric 6 The account number used for posting the discount amount to the general ledger. Must be a valid account in the Lawson General Ledger system. |
|||||||||||||||||||||||||||||||
| APP-DSC-SUB-ACCT Element: Sub Acct | Numeric 4 The subaccount number used for posting the discount amount to the general ledger. Must be a valid subaccount in the Lawson General Ledger system. |
|||||||||||||||||||||||||||||||
| APP-DISCOUNT-RT Element: Discount Rt | Percent 5.3 (Percent) The rate used to calculate the discount amount of the invoice payment. |
|
||||||||||||||||||||||||||||||
| APP-DISC-DATE Element: Date | Numeric 8 (yyyymmdd) The date through which the available discount amount of the invoice can be taken. |
|||||||||||||||||||||||||||||||
| APP-TRANS-IDENT Element: Transaction ID | Numeric 10 A sequencing number created by AP150 (Cash Requirements) or AP151 (Bill of Exchange Generation) to sequence payments. Used to link the Invoice Payment record with the associated Accounts Payable Cash Payment record. |
|||||||||||||||||||||||||||||||
| APP-ACCR-CODE Element: Invoice Accrual Code | Alpha 4 The invoice accrual code assigned to the invoice. Used to default a general ledger accrual account to the invoice. Must be a valid record in the Invoice Accrual Code file. |
|||||||||||||||||||||||||||||||
| APP-PROC-LEVEL Element: Process Level | Alpha 5 The process level associated with the invoice. Must be a valid record in the Accounts Payable Process Level file. |
|||||||||||||||||||||||||||||||
| APP-REC-STATUS Element: Rec Status | Numeric 1 The record status. Valid values are: 0 = Unreleased 1 = Released 2 = Selected for Payment 3 = Paid with a System Cash Payment 4 = Paid with a Manual Payment 5 = Paid with a Bill of Exchange Payment 7 = Unreleased Manual Payment 8 = Canceled (bill of exchange) 9 = Historical NOTE All void status invoice payment records should have a historical status. |
|||||||||||||||||||||||||||||||
| APP-TRANS-NBR Element: Payment Number | Alpha 10 (Right Justified) The system or manual payment number used to pay the invoice payment. |
|||||||||||||||||||||||||||||||
| APP-CHK-SUFFIX Payment Suffix Number | Numeric 3 The system or manual payment suffix number used to pay the invoice payment. |
|
||||||||||||||||||||||||||||||
| APP-BANK-INST-CODE Element: Payment Code | Alpha 3 The payment code assigned to the invoice payment. Represents a type of cash or bill of exchange payment used to pay the invoice payment. Must be a valid cash payment or bill of exchange payment transaction code record in the Bank Transaction Code file. |
|||||||||||||||||||||||||||||||
| APP-CHECK-DATE Element: Payment Date | Numeric 8 (yyyymmdd) The date assigned to the system or manual payment associated with the invoice payment record. |
|||||||||||||||||||||||||||||||
| APP-INCOME-CODE Element: Income Code | Alpha 4 The income code assigned to the invoice payment record. Used to track vendor reportable income. Must be a valid record in the Income Code file. |
|
||||||||||||||||||||||||||||||
| APP-SEP-CHK-FLAG Element: Separate Payment | Alpha 1 Indicates whether the payment should be made on a separate payment form from other payments to the same vendor. Valid values are: N = No. Y = Yes. |
|||||||||||||||||||||||||||||||
| APP-PAY-IMM-FLAG Element: Pay Immediately | Alpha 1 Indicates whether the invoice is to be paid immediately regardless of the invoice due date. Valid values are: N = No. Y = Yes. |
|||||||||||||||||||||||||||||||
| APP-DISC-LOST-FLG Element: Discount Lost | Alpha 1 Indicates whether the available discount for the invoice payment was lost. Valid values are: N = No. Y = Yes. |
|||||||||||||||||||||||||||||||
| APP-ANTICIPATION Anticipation Discount | Alpha 1 Indicates whether anticipation criteria should be used to calculate the discount amount for the invoice payment. Valid values are: Y = Yes. N = No. |
|||||||||||||||||||||||||||||||
| APP-INVOICE-GROUP Element: Invoice Group | Alpha 4 The invoice group assigned to the invoice payment. An invoice group is a user-defined character expression that can be used to select invoices for payment. |
|||||||||||||||||||||||||||||||
| APP-VENDOR-GROUP Element: Vendor Group | Alpha 4 The vendor group associated with the invoice payment. Must be a valid record in the Vendor Group file. |
|||||||||||||||||||||||||||||||
| APP-PAY-GROUP Element: Pay Group | Alpha 4 The pay group associated with the invoice payment. A pay group is used for processing accounts payable payments. Must be a valid record in the Pay Group file. |
|||||||||||||||||||||||||||||||
| APP-DISCOUNT-CODE Element: Discount Code | Alpha 10 The discount code assigned to the invoice payment. Used to default a general ledger discount account to the invoice. Must be a valid record in the Discount Code file. |
|
||||||||||||||||||||||||||||||
| APP-INC-ACCR-CODE Element: Inc Accr Code | Alpha 10 The withholding code assigned to the invoice payment. Used to default a general ledger withholding accrual account to the invoice. Must be a valid record in the Income Withholding Code file. |
|
||||||||||||||||||||||||||||||
| APP-RECON-STMT-NBR Element: Recon Stmt Nbr | Numeric 12 The bank-assigned reconciliation statement number. Used only for cash codes that require reconciliation statements. |
|
||||||||||||||||||||||||||||||
| APP-MATCH-DISC-TAK Element: Match Discount Taken | Alpha 1 Indicates if a discount was taken during the invoice matching process. " " Y = Yes |
|
||||||||||||||||||||||||||||||
| APP-OPEN-BASE-PMT Element: Open Base Pmt | Derived The amount of the invoice remaining to be paid in the company base currency. |
|
||||||||||||||||||||||||||||||
| APP-OPEN-TRAN-PMT Element: Open Tran Pmt | Derived The amount of the invoice remaining to be paid in the currency of the invoice. |
|
||||||||||||||||||||||||||||||
| APP-BASE-NET-PMT Element: Base Net Pmt | Derived The net invoice amount paid in the company base currency. |
|
||||||||||||||||||||||||||||||
| APP-TRAN-NET-PMT Element: Tran Net Pmt | Derived The net invoice amount paid in the currency of the invoice. |
|
||||||||||||||||||||||||||||||
| APP-PMT-STATUS Element: Payment Status | Derived 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 Element: Bank Status | Derived The reconciliation status of the payment record associated with the invoice payment. |
|
||||||||||||||||||||||||||||||
| APP-NO-REINSTATE Payment Not Reinstated | Derived If the invoice payment was paid and the payment was voided, this field indicates if the split invoice has not been reinstated by AP190 (Invoice Reinstatement). |
|
||||||||||||||||||||||||||||||
| APP-PAID-DOC-DATE Payment Document Date | Derived If the invoice payment was paid with a 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 Bill of Exchange Accrued | Derived If the invoice payment was paid with a bill of exchange, this field indicates whether the bill of exchange has been accrued in the general ledger. |
|
||||||||||||||||||||||||||||||
| APP-AP-INV-DATE Element: Ap Inv Date | Derived |
|
||||||||||||||||||||||||||||||
| APP-AP-PO-NBR Element: Ap Po Nbr | Derived |
|
||||||||||||||||||||||||||||||
| APP-AP-INV-TYPE Element: Ap Inv Type | Derived |
|
||||||||||||||||||||||||||||||
| APP-AP-BASE-INV Element: Ap Base Inv | Derived |
|
||||||||||||||||||||||||||||||
| APP-AP-FORMAT-NBR Element: Ap Format Nbr | Derived |
|
||||||||||||||||||||||||||||||
| APP-STATEMENT Element: Invoice | Alpha 22 Used to identify the invoice. |
|
||||||||||||||||||||||||||||||
| APP-RETAINAGE-PMT Element: Flag Num | Numeric 1 0 = No 1 = Yes |
|
||||||||||||||||||||||||||||||
| APP-FATCA-BASE-INC Element: Intl Amt | Signed 18.2 |
|
||||||||||||||||||||||||||||||
| APP-FATCA-INC-CODE Element: Income Code | Alpha 4 |
|
||||||||||||||||||||||||||||||
| APP-FATCA-TRAN-INC Element: Intl Amt | Signed 18.2 |
|
| NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| APPSET1 |
COMPANY VENDOR INVOICE SUFFIX CANCEL-SEQ SEQ-NBR VOID-SEQ |
|
| ||||||||||||||||||||||||||||||||||||||||||
| APPSET10 |
REC-STATUS COMPANY PROC-LEVEL VENDOR INVOICE SUFFIX CANCEL-SEQ SEQ-NBR VOID-SEQ PAY-GROUP |
|
| ||||||||||||||||||||||||||||||||||||||||||
| APPSET12 |
PAY-GROUP VENDOR INVOICE SUFFIX CANCEL-SEQ SEQ-NBR VOID-SEQ COMPANY |
|
| ||||||||||||||||||||||||||||||||||||||||||
| APPSET2 |
PAY-GROUP REC-STATUS VENDOR INVOICE SUFFIX CANCEL-SEQ SEQ-NBR VOID-SEQ COMPANY |
|
|||||||||||||||||||||||||||||||||||||||||||
| APPSET3 |
PAY-GROUP REC-STATUS PAY-IMM-FLAG PROC-GRP VENDOR INVOICE SUFFIX CANCEL-SEQ SEQ-NBR VOID-SEQ COMPANY |
|
| ||||||||||||||||||||||||||||||||||||||||||
| APPSET4 |
COMPANY VENDOR INVOICE SUFFIX CANCEL-SEQ SEQ-NBR VOID-SEQ |
|
| ||||||||||||||||||||||||||||||||||||||||||
| APPSET6 |
PAY-GROUP BANK-INST-CODE TRANS-IDENT VENDOR INVOICE SUFFIX CANCEL-SEQ SEQ-NBR VOID-SEQ COMPANY |
|
| ||||||||||||||||||||||||||||||||||||||||||
| APPSET8 |
PAY-GROUP CASH-CODE TRANS-NBR BANK-INST-CODE COMPANY VENDOR INVOICE SUFFIX CANCEL-SEQ SEQ-NBR VOID-SEQ |
|
| ||||||||||||||||||||||||||||||||||||||||||
| RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Apcompany | APCOMPANY |
Required
| |||||||||||||||||||||||||||
| Apdrafts | APDRAFTS |
Not Required
| |||||||||||||||||||||||||||
| Apinvoice | APINVOICE |
Required
| |||||||||||||||||||||||||||
| Appayvendor | APVENMAST |
Required
| |||||||||||||||||||||||||||
| Approclev | APPROCLEV |
Required
| |||||||||||||||||||||||||||
| Apvenclass | APVENCLASS |
Required
| |||||||||||||||||||||||||||
| Apvencurrbal | APVENBAL |
Not Required
| |||||||||||||||||||||||||||
| Apvengroup | APVENGROUP |
Required
| |||||||||||||||||||||||||||
| Apvenloc | APVENLOC |
Not Required
| |||||||||||||||||||||||||||
| Apvenmast | APVENMAST |
Required
| |||||||||||||||||||||||||||
| Cbbankinst | CBBANKINST |
Required
| |||||||||||||||||||||||||||
| Cbcashcode | CBCASHCODE |
Required
| |||||||||||||||||||||||||||
| Cbcashform | CBCASHFORM |
Not Required
| |||||||||||||||||||||||||||
| Cbcheck | CBCHECK |
Required
| |||||||||||||||||||||||||||
| Cbcpycach | CBCPYCASH |
Required
| |||||||||||||||||||||||||||
| Cbstatement | CBSTATEMNT |
Not Required
| |||||||||||||||||||||||||||
| Cbtrans | CBTRANS |
Not Required
| |||||||||||||||||||||||||||
| Cbtrans Tape | CBTRANS |
Not Required
| |||||||||||||||||||||||||||
| Invcurrency | CUCODES |
Required
|
| RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Apdiscacc | APDISCACC |
| ||||||||||||||||||||||||||||||||||||
| Apdistpay | APDISTPAY |
| ||||||||||||||||||||||||||||||||||||
| Aphldinv | APHLDINV |
Delete Cascades
| ||||||||||||||||||||||||||||||||||||
| Appset6 | APPAYMENT |
| ||||||||||||||||||||||||||||||||||||
| Appset8 | APPAYMENT |
| ||||||||||||||||||||||||||||||||||||
| Apvencomments | APCOMMENTS |
| ||||||||||||||||||||||||||||||||||||
| Apvendiv | APVENDIV |
| ||||||||||||||||||||||||||||||||||||
| Cbstmtdtl | CBSTMTDTL |
|
All trademarks and registered trademarks are the property of their
respective owners.