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.

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
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
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
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
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
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
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
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
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
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
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 10AP180, 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.2AP150, AP170, AP180, AP181, AP190, AP28.1, AP28.2, AP30.3 +1 more
APP-TRAN-SEC-WTH1
TRAN_SEC_WTH1
Signed 18.2AP150, AP170, AP180, AP181, AP190, AP28.1, AP28.2, AP30.3 +1 more
APP-SEC-WTH-CODE2
SEC_WTH_CODE2
Alpha 10AP180, 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.2AP150, AP170, AP180, AP181, AP190, AP28.1, AP28.2, AP30.3 +1 more
APP-TRAN-SEC-WTH2
TRAN_SEC_WTH2
Signed 18.2AP150, AP170, AP180, AP181, AP190, AP28.1, AP28.2, AP30.3 +1 more
APP-SEC-WTH-CODE3
SEC_WTH_CODE3
Alpha 10AP180, 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.2AP150, AP170, AP180, AP181, AP190, AP28.1, AP28.2, AP30.3 +1 more
APP-TRAN-SEC-WTH3
TRAN_SEC_WTH3
Signed 18.2AP150, AP170, AP180, AP181, AP190, AP28.1, AP28.2, AP30.3 +1 more
APP-CREATED-BY
CREATED_BY
Alpha 10AP180, AP181, AP190, AP193, AP20.1, AP20.2, AP20.3, AP20.4 +31 more
APP-LAST-UPDATE-BY
LAST_UPDATE_BY
Alpha 10AP101, AP102, AP115, AP125, AP126, AP133, AP141, AP150 +52 more (list truncated in source)
APP-LAST-UPDT-DATE
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 8AP101, 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.2AP150, AP170, AP190
APP-FATCA-INC-CODE
FATCA_INC_CODE
Alpha 4AP20.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.2AP150, AP170, AP190

Indexes (9)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
APPSET1COMPANY, VENDOR, INVOICE, SUFFIX, CANCEL-SEQ, SEQ-NBR, VOID-SEQPrimaryAM19.1, AM19.2, AM19.4, AP10.1, AP10.2, AP100, AP109, AP110 +22 more (list truncated in source)
APPSET10REC-STATUS, COMPANY, PROC-LEVEL, VENDOR, INVOICE, SUFFIX, CANCEL-SEQ, SEQ-NBR, VOID-SEQ, PAY-GROUPKeyChangeAP00.5, AP101, AP145, AP146, AP195, AP230, AP245, AP246 +3 more
APPSET12PAY-GROUP, VENDOR, INVOICE, SUFFIX, CANCEL-SEQ, SEQ-NBR, VOID-SEQ, COMPANYKeyChange, SubsetWhere (REC-STATUS = 1) Or (REC-STATUS = 2)AP55.2, AP56.2
APPSET13COMPANY, CHECK-DATE, LAST-UPDT-DATE, VENDOR, INVOICE, SUFFIX, CANCEL-SEQ, SEQ-NBR, VOID-SEQKeyChange
APPSET2PAY-GROUP, REC-STATUS, VENDOR, INVOICE, SUFFIX, CANCEL-SEQ, SEQ-NBR, VOID-SEQ, COMPANYKeyChangeAC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +22 more (list truncated in source)
APPSET3PAY-GROUP, REC-STATUS, PAY-IMM-FLAG, PROC-GRP, VENDOR, INVOICE, SUFFIX, CANCEL-SEQ, SEQ-NBR, VOID-SEQ, COMPANYKeyChangeAP150, AP151, AP170
APPSET4COMPANY, VENDOR, INVOICE, SUFFIX, CANCEL-SEQ, SEQ-NBR, VOID-SEQKeyChange, SubsetWhere REC-STATUS = 1 Or REC-STATUS = 2AP191, AP30.3, AP35.1, EE30.1
APPSET6PAY-GROUP, BANK-INST-CODE, TRANS-IDENT, VENDOR, INVOICE, SUFFIX, CANCEL-SEQ, SEQ-NBR, VOID-SEQ, COMPANYKeyChange, SubsetWhere TRANS-IDENT != ZeroesAP125, AP126, AP151, AP155, AP156, AP160, AP161, AP180 +22 more (list truncated in source)
APPSET8PAY-GROUP, CASH-CODE, TRANS-NBR, BANK-INST-CODE, COMPANY, VENDOR, INVOICE, SUFFIX, CANCEL-SEQ, SEQ-NBR, VOID-SEQKeyChangeAP255, AP90.5

Relations

One to one (23) — lookups and parents

RelationTableRulesConditionField map
ApcompanyAPCOMPANYRequiredAPP-COMPANYCPY-COMPANY
ApdraftsAPDRAFTSNot RequiredAPP-BANK-INST-CODEAPT-BANK-INST-CODE, APP-TRANS-IDENTAPT-TRANS-IDENT
ApinvoiceAPINVOICERequiredAPP-COMPANYAPI-COMPANY, APP-VENDORAPI-VENDOR, APP-INVOICEAPI-INVOICE, APP-SUFFIXAPI-SUFFIX, APP-CANCEL-SEQAPI-CANCEL-SEQ
AppayvendorAPVENMASTRequiredCPY-VENDOR-GROUPVEN-VENDOR-GROUP, APP-PAY-VENDORVEN-VENDOR
AppmtbodAPPMTBODNot Required, Delete CascadesAPP-COMPANYYBA-COMPANY, APP-VENDORYBA-VENDOR, APP-INVOICEYBA-INVOICE, APP-SUFFIXYBA-SUFFIX, APP-CANCEL-SEQYBA-CANCEL-SEQ, APP-SEQ-NBRYBA-SEQ-NBR, APP-VOID-SEQYBA-VOID-SEQ
ApproclevAPPROCLEVRequiredAPP-COMPANYAPR-COMPANY, APP-PROC-LEVELAPR-PROC-LEVEL
ApvenclassAPVENCLASSRequiredCPY-VENDOR-GROUPVCL-VENDOR-GROUP, APP-VEN-CLASSVCL-VEN-CLASS
ApvencurrbalAPVENBALNot RequiredCPY-VENDOR-GROUPVBA-VENDOR-GROUP, APP-COMPANYVBA-COMPANY, APP-VENDORVBA-VENDOR, APP-REMIT-TO-CODEVBA-LOCATION-CODE
ApvengroupAPVENGROUPRequiredCPY-VENDOR-GROUPVGP-VENDOR-GROUP
ApvenlocAPVENLOCNot RequiredCPY-VENDOR-GROUPVLO-VENDOR-GROUP, APP-PAY-VENDORVLO-VENDOR, APP-REMIT-TO-CODEVLO-LOCATION-CODE
ApvenmastAPVENMASTRequiredCPY-VENDOR-GROUPVEN-VENDOR-GROUP, APP-VENDORVEN-VENDOR
CbbankinstCBBANKINSTRequiredAPP-BANK-INST-CODECBI-BANK-INST-CODE
CbcashcodeCBCASHCODERequiredAPP-CASH-CODECBC-CASH-CODE
CbcashformCBCASHFORMNot RequiredAPP-CASH-CODECCF-CASH-CODE, APP-BANK-INST-CODECCF-BANK-INST-CODE, APP-PROC-GRPCCF-PROC-GRP
CbcheckCBCHECKRequiredAPP-CASH-CODECHK-CASH-CODE, APP-BANK-INST-CODECHK-BANK-INST-CODE, APP-TRANS-IDENTCHK-TRANS-IDENT
Cbcheck DrillCBCHECKRequiredAPP-CASH-CODECHK-CASH-CODE, APP-BANK-INST-CODECHK-BANK-INST-CODE, APP-TRANS-IDENTCHK-TRANS-IDENT, APP-TRANS-ID-CBTCHK-TRANS-ID-CBT
CbcpycachCBCPYCASHRequiredAPP-PAY-COMPANYCBY-COMPANY, APP-CASH-CODECBY-CASH-CODE
CbstatementCBSTATEMNTNot RequiredAPP-CASH-CODECSM-CASH-CODE, APP-RECON-STMT-NBRCSM-RECON-STMT-NBR
CbtransCBTRANSNot RequiredValid When CBI-TAPE-PMT-SUMM != "S"APP-BANK-INST-CODECBT-BANK-INST-CODE, APP-TRANS-IDENTCBT-TRANS-IDENT
Cbtrans DrillCBTRANSNot RequiredAPP-BANK-INST-CODECBT-BANK-INST-CODE, APP-TRANS-ID-CBTCBT-TRANS-IDENT
Cbtrans DrlCBTRANSNot RequiredAPP-BANK-INST-CODECBT-BANK-INST-CODE, APP-TRANS-IDENTCBT-TRANS-IDENT
Cbtrans TapeCBTRANSNot RequiredValid When CHK- = APP- And CHK-REC-STATUS = 2 And CHK-SERIAL-NUM != ZeroesCHK-BANK-INST-CODECBT-BANK-INST-CODE, CHK-SERIAL-NUMCBT-SERIAL-NUM, CHK-TRANS-IDENTCBT-TRANS-IDENT
InvcurrencyCUCODESRequiredAPP-INV-CURRENCYCUC-CURRENCY-CODE

One to many (8) — child tables

RelationTableRulesConditionField map
ApdiscaccAPDISCACCAPP-COMPANYDSK-COMPANY, APP-VENDORDSK-VENDOR, APP-INVOICEDSK-INVOICE, APP-SUFFIXDSK-SUFFIX, APP-CANCEL-SEQDSK-CANCEL-SEQ, APP-SEQ-NBRDSK-SEQ-NBR, DSK-VOID-SEQ, DSK-DISC-TYPE
ApdistpayAPDISTPAYAPP-COMPANYDTY-COMPANY, APP-VENDORDTY-VENDOR, APP-INVOICEDTY-INVOICE, APP-SUFFIXDTY-SUFFIX, APP-SEQ-NBRDTY-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-GROUPHLI-VENDOR-GROUP, APP-COMPANYHLI-COMPANY, APP-VENDORHLI-VENDOR, APP-INVOICEHLI-INVOICE, APP-SUFFIXHLI-SUFFIX, APP-CANCEL-SEQHLI-CANCEL-SEQ, APP-SEQ-NBRHLI-SEQ-NBR, APP-VOID-SEQHLI-VOID-SEQ, HLI-HLD-CODE
Appset6APPAYMENTAPP-PAY-GROUPAPP-PAY-GROUP, APP-BANK-INST-CODEAPP-BANK-INST-CODE, APP-TRANS-IDENTAPP-TRANS-IDENT, APP-VENDOR, APP-INVOICE, APP-SUFFIX, APP-CANCEL-SEQ, APP-SEQ-NBR, APP-VOID-SEQ, APP-COMPANY
Appset8APPAYMENTAPP-PAY-GROUPAPP-PAY-GROUP, APP-CASH-CODEAPP-CASH-CODE, APP-TRANS-NBRAPP-TRANS-NBR, APP-BANK-INST-CODEAPP-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-GROUPAPC-VENDOR-GROUP, APP-VENDORAPC-VENDOR, SpacesAPC-LOCATION-CODE, APP-COMPANYAPC-COMPANY, APC-SEQ-NBR
ApvendivAPVENDIVAPP-VENDOR-GROUPVDC-VENDOR-GROUP, APP-VENDORVDC-VENDOR, API-LOCATIONVDC-LOCATION-CODE, VDC-DIVERSE-CODE, VDC-DCERT-DATE
CbstmtdtlCBSTMTDTLAPP-BANK-INST-CODECSD-BANK-INST-CODE, APP-RECON-STMT-NBRCSD-RECON-STMT-NBR, APP-TRANS-NBRCSD-PAYMENT-NBR, "V"CSD-TRANS-TYPE, APP-CASH-CODECSD-CASH-CODE, CSD-LINE-NBR

Programs

Updated by (93)

Referenced by (294)