APPAYMENT – Invoice Payment

System
Accounts Payable (AP)
Prefix
APP
Primary key
COMPANY, VENDOR, INVOICE, SUFFIX, CANCEL-SEQ, SEQ-NBR, VOID-SEQ
Fields
98
Updated by
93 programs
Referenced by
294 programs

APPAYMENT is the Invoice Payment table in Lawson Accounts Payable (prefix APP). It is indexed by COMPANY, VENDOR, INVOICE, SUFFIX, CANCEL-SEQ, SEQ-NBR, VOID-SEQ (APPSET1); alternate indexes: APPSET10, APPSET12, APPSET13, APPSET2, APPSET3, APPSET4, APPSET6 and APPSET8. It is related 1:1 to APCOMPANY, APDRAFTS, APINVOICE, APVENMAST, APPMTBOD, APPROCLEV, APVENCLASS, APVENBAL and 10 more and 1:M to APDISCACC, APDISTPAY, APHLDINV, APPAYMENT, APCOMMENTS, APVENDIV and CBSTMTDTL. It is updated by AP101, AP102, AP115, AP125, AP126, AP133, AP141, AP150 and 85 more and referenced by AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 and 286 more. The table has 98 fields, 9 indexes and 31 documented relations.

About APPAYMENT

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.

Fields (98)

Column = COBOL field name without the APP- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#APP-COMPANY PK
COMPANY		Numeric 4The company number associated with the invoice payment. Must be a valid record in the Accounts Payable Company file.AP180, AP181, AP190, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +28 more
#APP-VENDOR PK
VENDOR		Alpha 9 (Right Justified)The vendor number associated with the invoice payment. Must be a valid record in the Vendor file.AP115, AP180, AP181, AP190, AP20.1, AP20.2, AP20.3, AP20.4 +29 more
#APP-INVOICE PK
INVOICE		Alpha 22The invoice number. Must be a valid record in the Accounts Payable Invoice file.AP115, AP180, AP181, AP190, AP20.1, AP20.2, AP20.3, AP20.4 +29 more
#APP-SUFFIX PK
SUFFIX		Numeric 3The invoice suffix number. Represents the occurrence value of the invoice for recurring invoices, employee advances, and prepayment credit memos.AP170, AP180, AP181, AP190, AP193, AP20.8, AP25.1, AP25.2 +12 more
#APP-CANCEL-SEQ PK
CANCEL_SEQ		Numeric 4The sequence number assigned upon the cancellation of a distributed invoice. The first sequence assigned is 9999.AP180, AP181, AP190, AP28.1, AP28.2, AP30.4, AP32.1, AP45.1 +4 more
#APP-SEQ-NBR PK
SEQ_NBR		Numeric 4An automatically assigned sequence number.AP133, AP170, AP180, AP181, AP190, AP20.1, AP20.2, AP20.3 +31 more
#APP-VOID-SEQ PK
VOID_SEQ		Numeric 4The 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.AP180, AP181, AP190, AP28.1, AP28.2, AP32.1, AP45.1, MA61.1 +1 more
#APP-VOID-DATE
VOID_DATE		Numeric 8 (yyyymmdd)The date assigned to a voided payment associated with the invoice payment record.AP180, AP181, AP190, AP28.1, AP28.2, AP45.1, MA61.1, MAI1.1
#APP-INV-CURRENCY
INV_CURRENCY		Alpha 5The currency of the invoice. Must be a valid record in the Currency Code file.AP180, AP181, AP190, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +25 more
#APP-PAY-VENDOR
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.AP115, AP180, AP181, AP190, AP20.1, AP20.2, AP20.3, AP20.4 +30 more
#APP-REMIT-TO-CODE
REMIT_TO_CODE		Alpha 4The remit-to location associated with the invoice payment. Must be a valid record in the Vendor Location file.AP115, AP180, AP181, AP190, AP20.1, AP20.2, AP20.3, AP20.4 +33 more
#APP-PAY-COMPANY
PAY_COMPANY		Numeric 4The company associated with the pay vendor. Must be a valid record in the Accounts Payable Company file.AP151, AP180, AP181, AP190, AP20.1, AP20.2, AP20.3, AP20.4 +28 more
#APP-CASH-CODE SET8
CASH_CODE		Alpha 4The 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.AP115, AP150, AP151, AP160, AP161, AP180, AP181, AP190 +36 more
#APP-DUE-DATE
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.AP133, AP170, AP180, AP181, AP190, AP193, AP20.1, AP20.2 +30 more
#APP-ENCLOSURE
ENCLOSURE		Alpha 1Indicates whether the invoice payment requires an enclosure. Valid values are:
  • N No.
  • Y Yes.
AP180, AP181, AP190, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +25 more
#APP-HOLD-FLAG
HOLD_FLAG		Alpha 1Indicates 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.
AP125, AP126, AP133, AP141, AP150, AP170, AP180, AP181 +52 more (list truncated in source)
#APP-VEN-CLASS
VEN_CLASS		Alpha 3The vendor class associated with the invoice payment. Must be a valid record in the Vendor Class file.AP115, AP180, AP181, AP190, AP20.1, AP20.2, AP20.3, AP20.4 +26 more
#APP-VEN-PRIORITY
VEN_PRIORITY		Numeric 2The payment priority defined for the vendor. Valid values are 1 (highest priority) through 99 (lowest priority). 00 99AP115, AP180, AP181, AP190, AP20.1, AP20.2, AP20.3, AP20.4 +27 more
#APP-PROC-GRP SET3
PROC_GRP		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.AP102, AP115, AP180, AP181, AP190, AP20.1, AP20.2, AP20.3 +27 more
#APP-BASE-PMT-AMT
BASE_PMT_AMT		Signed 18.2The 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.AP170, AP180, AP181, AP190, AP193, AP20.1, AP20.2, AP20.3 +45 more
#APP-BASE-ACT-AMT
BASE_ACT_AMT		Signed 18.2The 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.AP133, AP170, AP180, AP181, AP190, AP191, AP193, AP20.1 +46 more
#APP-BASE-ND
BASE_ND		Numeric 1The number of decimal places defined for the company base currency.AP180, AP181, AP190, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +26 more
#APP-TRAN-PMT-AMT
TRAN_PMT_AMT		Signed 18.2The amount of the invoice payment in the currency of the invoice.AP133, AP180, AP181, AP190, AP20.1, AP20.2, AP20.3, AP20.4 +46 more
#APP-TRAN-ND
TRAN_ND		Numeric 1The number of decimal places defined for the invoice currency.AP180, AP181, AP190, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +26 more
#APP-BANK-CHK-AMT
BANK_CHK_AMT		Signed 18.2The amount of the invoice payment in the currency of the bank account (cash code).AP150, AP170, AP180, AP181, AP190, AP20.1, AP20.2, AP20.3 +26 more
#APP-BANK-ND
BANK_ND		Numeric 1The number of decimal places defined for the bank account currency.AP150, AP170, AP180, AP181, AP190, AP20.1, AP20.2, AP20.3 +21 more
#APP-BASE-DISC-AMT
BASE_DISC_AMT		Signed 18.2The amount of the available discount for the invoice payment in the company base currency.AP150, AP170, AP180, AP181, AP190, AP191, AP193, AP20.1 +30 more
#APP-TRAN-DISC-AMT
TRAN_DISC_AMT		Signed 18.2The amount of the available discount for the invoice payment in the currency of the invoice.AP150, AP170, AP180, AP181, AP190, AP20.1, AP20.2, AP20.3 +28 more
#APP-BASE-CHK-AMT
BASE_CHK_AMT		Signed 18.2The net payment amount for the invoice in the company base currency.AP150, AP170, AP180, AP181, AP190, AP193, AP20.1, AP20.2 +33 more
#APP-TRAN-CHK-AMT
TRAN_CHK_AMT		Signed 18.2The net payment amount for the invoice in the currency of the invoice.AP150, AP170, AP180, AP181, AP190, AP193, AP20.1, AP20.2 +33 more
#APP-BASE-INC-WH
BASE_INC_WH		Signed 18.2The reportable income withholding amount in the company base currency.AP150, AP170, AP180, AP181, AP190, AP193, AP28.1, AP28.2 +7 more
#APP-TRAN-INC-WH
TRAN_INC_WH		Signed 18.2The reportable income withholding amount in the currency of the invoice.AP150, AP170, AP180, AP181, AP190, AP28.1, AP28.2, AP30.3 +7 more
#APP-TRAN-INC-AMT
TRAN_INC_AMT		Signed 18.2The portion of the invoice amount classified as reportable income.AP170, AP180, AP181, AP190, AP193, AP20.1, AP20.2, AP20.3 +24 more
#APP-GAINLOS-AMT
GAINLOS_AMT		Signed 18.2The currency gain or loss amount. This amount is calculated when the invoice is revalued to account for currency exchange rate fluctuations.AP170, AP180, AP181, AP190, AP193, AP28.1, AP28.2, AP45.1 +4 more
#APP-UNRL-REV-DATE
UNRL_REV_DATE		Numeric 8 (yyyymmdd)The date of the last currency revaluation that resulted in the creation of an unrealized gain or loss transaction.AP180, AP181, AP190, AP191, AP28.1, AP28.2, AP30.3, AP45.1
#APP-ACT-CNV-RATE
ACT_CNV_RATE		Signed 14.7The 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.AP170, AP180, AP181, AP190, AP191, AP193, AP20.1, AP20.2 +33 more
#APP-DSC-ACCT-UNIT
DSC_ACCT_UNIT		Alpha 15The accounting unit used for posting the discount amount to the general ledger. Must be a valid accounting unit in the Lawson General Ledger system.AP170, AP180, AP181, AP190, AP193, AP20.1, AP20.2, AP20.3 +22 more
#APP-DSC-ACCOUNT
DSC_ACCOUNT		Numeric 6The account number used for posting the discount amount to the general ledger. Must be a valid account in the Lawson General Ledger system.AP170, AP180, AP181, AP190, AP193, AP20.1, AP20.2, AP20.3 +22 more
#APP-DSC-SUB-ACCT
DSC_SUB_ACCT		Numeric 4The subaccount number used for posting the discount amount to the general ledger. Must be a valid subaccount in the Lawson General Ledger system.AP170, AP180, AP181, AP190, AP193, AP20.1, AP20.2, AP20.3 +22 more
#APP-DISCOUNT-RT
DISCOUNT_RT		Percent 5.3 (Percent)The rate used to calculate the discount amount of the invoice payment.AP150, AP180, AP181, AP190, AP20.1, AP20.2, AP20.3, AP20.4 +22 more
#APP-DISC-DATE
DISC_DATE		Numeric 8 (yyyymmdd)The date through which the available discount amount of the invoice can be taken.AP150, AP170, AP180, AP181, AP190, AP193, AP20.1, AP20.2 +25 more
#APP-TRANS-IDENT SET6
TRANS_IDENT		Numeric 10A 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.AP133, AP150, AP151, AP170, AP180, AP181, AP190, AP193 +34 more
#APP-TRANS-ID-CBT
TRANS_ID_CBT		Numeric 10——
#APP-ACCR-CODE
ACCR_CODE		Alpha 4The 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.AP180, AP181, AP190, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +28 more
#APP-PROC-LEVEL SET10
PROC_LEVEL		Alpha 5The process level associated with the invoice. Must be a valid record in the Accounts Payable Process Level file.AP180, AP181, AP190, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +26 more
#APP-REC-STATUS SET10 SET2 SET3
REC_STATUS		Numeric 1The record status. Valid values are: NOTE All void status invoice payment records should have a historical status.
  • 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
AP125, AP126, AP133, AP150, AP151, AP155, AP160, AP161 +52 more (list truncated in source)
#APP-TRANS-NBR SET8
TRANS_NBR		Alpha 10 (Right Justified)The system or manual payment number used to pay the invoice payment.AP151, AP155, AP160, AP161, AP170, AP180, AP181, AP190 +35 more
#APP-CHK-SUFFIX
CHK_SUFFIX		Numeric 3The system or manual payment suffix number used to pay the invoice payment.AP180, AP181, AP190, AP20.8, AP28.1, AP28.2, AP45.1, AP56.1 +3 more
#APP-BANK-INST-CODE SET6 SET8
BANK_INST_CODE		Alpha 3The 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.AP115, AP150, AP160, AP161, AP180, AP181, AP190, AP20.1 +34 more
#APP-CHECK-DATE SET13
CHECK_DATE		Numeric 8 (yyyymmdd)The date assigned to the system or manual payment associated with the invoice payment record.AP155, AP160, AP161, AP170, AP180, AP181, AP190, AP193 +34 more
#APP-INCOME-CODE
INCOME_CODE		Alpha 4The income code assigned to the invoice payment record. Used to track vendor reportable income. Must be a valid record in the Income Code file.AP180, AP181, AP190, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +21 more
#APP-SEP-CHK-FLAG
SEP_CHK_FLAG		Alpha 1Indicates 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.
AP170, AP180, AP181, AP190, AP20.1, AP20.2, AP20.3, AP20.4 +26 more
#APP-PAY-IMM-FLAG SET3
PAY_IMM_FLAG		Alpha 1Indicates whether the invoice is to be paid immediately regardless of the invoice due date. Valid values are:
  • N No.
  • Y Yes.
AP133, AP170, AP180, AP181, AP190, AP20.1, AP20.2, AP20.3 +29 more
#APP-DISC-LOST-FLG
DISC_LOST_FLG		Alpha 1Indicates whether the available discount for the invoice payment was lost. Valid values are:
  • N No.
  • Y Yes.
AP150, AP170, AP180, AP181, AP190, AP193, AP20.1, AP20.2 +31 more
#APP-ANTICIPATION
ANTICIPATION		Alpha 1Indicates whether anticipation criteria should be used to calculate the discount amount for the invoice payment. Valid values are:
  • Y Yes.
  • N No.
AP180, AP181, AP190, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +25 more
#APP-INVOICE-GROUP
INVOICE_GROUP		Alpha 4The 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.AP115, AP170, AP180, AP181, AP190, AP20.1, AP20.2, AP20.3 +26 more
#APP-VENDOR-GROUP
VENDOR_GROUP		Alpha 4The vendor group associated with the invoice payment. Must be a valid record in the Vendor Group file.AP180, AP181, AP190, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +25 more
#APP-PAY-GROUP SET10 SET12 SET2 SET3 SET6 SET8
PAY_GROUP		Alpha 4The 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.AP101, AP180, AP181, AP190, AP20.1, AP20.2, AP20.3, AP20.4 +29 more
#APP-DISCOUNT-CODE
DISCOUNT_CODE		Alpha 10The 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.AP180, AP181, AP190, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +20 more
#APP-INC-ACCR-CODE
INC_ACCR_CODE		Alpha 10The 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.AP150, AP180, AP181, AP190, AP20.1, AP20.2, AP20.3, AP20.4 +21 more
#APP-RECON-STMT-NBR
RECON_STMT_NBR		Numeric 12The bank-assigned reconciliation statement number. Used only for cash codes that require reconciliation statements.AP180, AP181, AP190, AP28.1, AP28.2, AP45.1, CB06.2
#APP-MATCH-DISC-TAK
MATCH_DISC_TAK		Alpha 1Indicates if a discount was taken during the invoice matching process. " "
  • Y Yes
AP180, AP181, AP190, AP28.1, AP28.2, AP45.1, AP520, MA61.1 +4 more
#APP-OPEN-BASE-PMT
OPEN_BASE_PMT		DerivedThe amount of the invoice remaining to be paid in the company base currency.—
#APP-OPEN-TRAN-PMT
OPEN_TRAN_PMT		DerivedThe amount of the invoice remaining to be paid in the currency of the invoice.—
#APP-BASE-NET-PMT
BASE_NET_PMT		DerivedThe net invoice amount paid in the company base currency.—
#APP-TRAN-NET-PMT
TRAN_NET_PMT		DerivedThe net invoice amount paid in the currency of the invoice.—
#APP-PMT-STATUS
PMT_STATUS		DerivedDisplays the payment status when Drill Around(TM) is used. Valid values are: status. status.
  • OPEN The payment record has an open
  • PAID The payment record has a paid
—
#APP-BANK-STATUS
BANK_STATUS		DerivedThe reconciliation status of the payment record associated with the invoice payment.—
#APP-NO-REINSTATE
NO_REINSTATE		DerivedIf 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
PAID_DOC_DATE		DerivedIf 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
DRAFT_ACCRUED		DerivedIf 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
AP_INV_DATE		Derived——
#APP-AP-PO-NBR
AP_PO_NBR		Derived——
#APP-AP-INV-TYPE
AP_INV_TYPE		Derived——
#APP-AP-BASE-INV
AP_BASE_INV		Derived——
#APP-AP-FORMAT-NBR
AP_FORMAT_NBR		Derived——
#APP-STATEMENT
STATEMENT		Alpha 22Used to identify the invoice.API1.1
#APP-RETAINAGE-PMT
RETAINAGE_PMT		Numeric 1—
  • 0 No
  • 1 Yes
AP133, MA61.1, MAI1.1
#APP-SEC-WTH-CODE1
SEC_WTH_CODE1		Alpha 10—AP180, AP181, AP190, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +19 more
#APP-SEC-WTH-PCT1
SEC_WTH_PCT1		Percent 5.3 (Percent)—AP150, AP180, AP181, AP190, AP28.1, AP28.2, AP30.3, AP45.1
#APP-BASE-SEC-WTH1
BASE_SEC_WTH1		Signed 18.2—AP150, AP170, AP180, AP181, AP190, AP28.1, AP28.2, AP30.3 +1 more
#APP-TRAN-SEC-WTH1
TRAN_SEC_WTH1		Signed 18.2—AP150, AP170, AP180, AP181, AP190, AP28.1, AP28.2, AP30.3 +1 more
#APP-SEC-WTH-CODE2
SEC_WTH_CODE2		Alpha 10—AP180, AP181, AP190, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +19 more
#APP-SEC-WTH-PCT2
SEC_WTH_PCT2		Percent 5.3 (Percent)—AP150, AP180, AP181, AP190, AP28.1, AP28.2, AP30.3, AP45.1
#APP-BASE-SEC-WTH2
BASE_SEC_WTH2		Signed 18.2—AP150, AP170, AP180, AP181, AP190, AP28.1, AP28.2, AP30.3 +1 more
#APP-TRAN-SEC-WTH2
TRAN_SEC_WTH2		Signed 18.2—AP150, AP170, AP180, AP181, AP190, AP28.1, AP28.2, AP30.3 +1 more
#APP-SEC-WTH-CODE3
SEC_WTH_CODE3		Alpha 10—AP180, AP181, AP190, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +19 more
#APP-SEC-WTH-PCT3
SEC_WTH_PCT3		Percent 5.3 (Percent)—AP150, AP180, AP181, AP190, AP28.1, AP28.2, AP30.3, AP45.1
#APP-BASE-SEC-WTH3
BASE_SEC_WTH3		Signed 18.2—AP150, AP170, AP180, AP181, AP190, AP28.1, AP28.2, AP30.3 +1 more
#APP-TRAN-SEC-WTH3
TRAN_SEC_WTH3		Signed 18.2—AP150, AP170, AP180, AP181, AP190, AP28.1, AP28.2, AP30.3 +1 more
#APP-CREATED-BY
CREATED_BY		Alpha 10—AP180, AP181, AP190, AP193, AP20.1, AP20.2, AP20.3, AP20.4 +31 more
#APP-LAST-UPDATE-BY
LAST_UPDATE_BY		Alpha 10—AP101, AP102, AP115, AP125, AP126, AP133, AP141, AP150 +52 more (list truncated in source)
#APP-LAST-UPDT-DATE SET13
LAST_UPDT_DATE		Numeric 8 (yyyymmdd)—AP101, AP102, AP115, AP125, AP126, AP133, AP141, AP150 +52 more (list truncated in source)
#APP-LAST-UPDT-TIME
LAST_UPDT_TIME		Numeric 8—AP101, AP102, AP115, AP125, AP126, AP133, AP141, AP150 +52 more (list truncated in source)
#APP-TEMP-HOLD
TEMP_HOLD		Alpha 1—
  • S Sent for Approval
  • A Approved by Engine
AP141, AP150, AP30.3, AP40.1
#APP-FATCA-BASE-INC
FATCA_BASE_INC		Signed 18.2—AP150, AP170, AP190
#APP-FATCA-INC-CODE
FATCA_INC_CODE		Alpha 4—AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7, AP21.1, AP23.1 +8 more
#APP-FATCA-TRAN-INC
FATCA_TRAN_INC		Signed 18.2—AP150, AP170, AP190

Indexes (9)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
APPSET1
  1. COMPANY
  2. VENDOR
  3. INVOICE
  4. SUFFIX
  5. CANCEL-SEQ
  6. SEQ-NBR
  7. VOID-SEQ
PrimaryAM19.1, AM19.2, AM19.4, AP10.1, AP10.2, AP100, AP109, AP110 +22 more (list truncated in source)
APPSET10
  1. REC-STATUS
  2. COMPANY
  3. PROC-LEVEL
  4. VENDOR
  5. INVOICE
  6. SUFFIX
  7. CANCEL-SEQ
  8. SEQ-NBR
  9. VOID-SEQ
  10. PAY-GROUP
KeyChangeAP00.5, AP101, AP145, AP146, AP195, AP230, AP245, AP246 +3 more
APPSET12
  1. PAY-GROUP
  2. VENDOR
  3. INVOICE
  4. SUFFIX
  5. CANCEL-SEQ
  6. SEQ-NBR
  7. VOID-SEQ
  8. COMPANY
KeyChange, SubsetWhere (REC-STATUS = 1) Or (REC-STATUS = 2)AP55.2, AP56.2
APPSET13
  1. COMPANY
  2. CHECK-DATE
  3. LAST-UPDT-DATE
  4. VENDOR
  5. INVOICE
  6. SUFFIX
  7. CANCEL-SEQ
  8. SEQ-NBR
  9. VOID-SEQ
KeyChange—
APPSET2
  1. PAY-GROUP
  2. REC-STATUS
  3. VENDOR
  4. INVOICE
  5. SUFFIX
  6. CANCEL-SEQ
  7. SEQ-NBR
  8. VOID-SEQ
  9. COMPANY
KeyChangeAC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +22 more (list truncated in source)
APPSET3
  1. PAY-GROUP
  2. REC-STATUS
  3. PAY-IMM-FLAG
  4. PROC-GRP
  5. VENDOR
  6. INVOICE
  7. SUFFIX
  8. CANCEL-SEQ
  9. SEQ-NBR
  10. VOID-SEQ
  11. COMPANY
KeyChangeAP150, AP151, AP170
APPSET4
  1. COMPANY
  2. VENDOR
  3. INVOICE
  4. SUFFIX
  5. CANCEL-SEQ
  6. SEQ-NBR
  7. VOID-SEQ
KeyChange, SubsetWhere REC-STATUS = 1 Or REC-STATUS = 2AP191, AP30.3, AP35.1, EE30.1
APPSET6
  1. PAY-GROUP
  2. BANK-INST-CODE
  3. TRANS-IDENT
  4. VENDOR
  5. INVOICE
  6. SUFFIX
  7. CANCEL-SEQ
  8. SEQ-NBR
  9. VOID-SEQ
  10. COMPANY
KeyChange, SubsetWhere TRANS-IDENT != ZeroesAP125, AP126, AP151, AP155, AP156, AP160, AP161, AP180 +22 more (list truncated in source)
APPSET8
  1. PAY-GROUP
  2. CASH-CODE
  3. TRANS-NBR
  4. BANK-INST-CODE
  5. COMPANY
  6. VENDOR
  7. INVOICE
  8. SUFFIX
  9. CANCEL-SEQ
  10. SEQ-NBR
  11. VOID-SEQ
KeyChangeAP255, AP90.5

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
APCOMPANYAPDRAFTSAPINVOICEAPVENMASTAPPMTBODAPPROCLEVAPVENCLASSAPVENBALAPVENGROUPAPVENLOCCBBANKINSTCBCASHCODECBCASHFORMCBCHECK+4 more belowAPDISCACCAPDISTPAYAPHLDINVAPPAYMENTAPCOMMENTSAPVENDIVCBSTMTDTLAPPAYMENT

One to one (23) — lookups and parents

RelationTableRulesConditionField map
ApcompanyAPCOMPANYRequired
APP-COMPANY→CPY-COMPANY
ApdraftsAPDRAFTSNot Required
APP-BANK-INST-CODE→APT-BANK-INST-CODE
APP-TRANS-IDENT→APT-TRANS-IDENT
ApinvoiceAPINVOICERequired
APP-COMPANY→API-COMPANY
APP-VENDOR→API-VENDOR
APP-INVOICE→API-INVOICE
APP-SUFFIX→API-SUFFIX
APP-CANCEL-SEQ→API-CANCEL-SEQ
AppayvendorAPVENMASTRequired
CPY-VENDOR-GROUP→VEN-VENDOR-GROUP
APP-PAY-VENDOR→VEN-VENDOR
AppmtbodAPPMTBODNot Required, Delete Cascades
APP-COMPANY→YBA-COMPANY
APP-VENDOR→YBA-VENDOR
APP-INVOICE→YBA-INVOICE
APP-SUFFIX→YBA-SUFFIX
APP-CANCEL-SEQ→YBA-CANCEL-SEQ
APP-SEQ-NBR→YBA-SEQ-NBR
APP-VOID-SEQ→YBA-VOID-SEQ
ApproclevAPPROCLEVRequired
APP-COMPANY→APR-COMPANY
APP-PROC-LEVEL→APR-PROC-LEVEL
ApvenclassAPVENCLASSRequired
CPY-VENDOR-GROUP→VCL-VENDOR-GROUP
APP-VEN-CLASS→VCL-VEN-CLASS
ApvencurrbalAPVENBALNot Required
CPY-VENDOR-GROUP→VBA-VENDOR-GROUP
APP-COMPANY→VBA-COMPANY
APP-VENDOR→VBA-VENDOR
APP-REMIT-TO-CODE→VBA-LOCATION-CODE
ApvengroupAPVENGROUPRequired
CPY-VENDOR-GROUP→VGP-VENDOR-GROUP
ApvenlocAPVENLOCNot Required
CPY-VENDOR-GROUP→VLO-VENDOR-GROUP
APP-PAY-VENDOR→VLO-VENDOR
APP-REMIT-TO-CODE→VLO-LOCATION-CODE
ApvenmastAPVENMASTRequired
CPY-VENDOR-GROUP→VEN-VENDOR-GROUP
APP-VENDOR→VEN-VENDOR
CbbankinstCBBANKINSTRequired
APP-BANK-INST-CODE→CBI-BANK-INST-CODE
CbcashcodeCBCASHCODERequired
APP-CASH-CODE→CBC-CASH-CODE
CbcashformCBCASHFORMNot Required
APP-CASH-CODE→CCF-CASH-CODE
APP-BANK-INST-CODE→CCF-BANK-INST-CODE
APP-PROC-GRP→CCF-PROC-GRP
CbcheckCBCHECKRequired
APP-CASH-CODE→CHK-CASH-CODE
APP-BANK-INST-CODE→CHK-BANK-INST-CODE
APP-TRANS-IDENT→CHK-TRANS-IDENT
Cbcheck DrillCBCHECKRequired
APP-CASH-CODE→CHK-CASH-CODE
APP-BANK-INST-CODE→CHK-BANK-INST-CODE
APP-TRANS-IDENT→CHK-TRANS-IDENT
APP-TRANS-ID-CBT→CHK-TRANS-ID-CBT
CbcpycachCBCPYCASHRequired
APP-PAY-COMPANY→CBY-COMPANY
APP-CASH-CODE→CBY-CASH-CODE
CbstatementCBSTATEMNTNot Required
APP-CASH-CODE→CSM-CASH-CODE
APP-RECON-STMT-NBR→CSM-RECON-STMT-NBR
CbtransCBTRANSNot RequiredValid When CBI-TAPE-PMT-SUMM != "S"
APP-BANK-INST-CODE→CBT-BANK-INST-CODE
APP-TRANS-IDENT→CBT-TRANS-IDENT
Cbtrans DrillCBTRANSNot Required
APP-BANK-INST-CODE→CBT-BANK-INST-CODE
APP-TRANS-ID-CBT→CBT-TRANS-IDENT
Cbtrans DrlCBTRANSNot Required
APP-BANK-INST-CODE→CBT-BANK-INST-CODE
APP-TRANS-IDENT→CBT-TRANS-IDENT
Cbtrans TapeCBTRANSNot RequiredValid 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
InvcurrencyCUCODESRequired
APP-INV-CURRENCY→CUC-CURRENCY-CODE

One to many (8) — child tables

RelationTableRulesConditionField map
ApdiscaccAPDISCACC
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
ApdistpayAPDISTPAY
APP-COMPANY→DTY-COMPANY
APP-VENDOR→DTY-VENDOR
APP-INVOICE→DTY-INVOICE
APP-SUFFIX→DTY-SUFFIX
APP-SEQ-NBR→DTY-PMT-SEQ-NBR
—→DTY-LINE-NBR
—→DTY-MAD-SEQ-NBR
—→DTY-DIST-SEQ-NBR
AphldinvAPHLDINVDelete CascadesValid 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
Appset6APPAYMENT
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
Appset8APPAYMENT
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
ApvencommentsAPCOMMENTS
"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
ApvendivAPVENDIV
APP-VENDOR-GROUP→VDC-VENDOR-GROUP
APP-VENDOR→VDC-VENDOR
API-LOCATION→VDC-LOCATION-CODE
—→VDC-DIVERSE-CODE
—→VDC-DCERT-DATE
CbstmtdtlCBSTMTDTL
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

Programs

Updated by (93)

Referenced by (294)