APAPIHIST – Vendor Invoice History

System
Accounts Payable (AP)
Prefix
AH1
Primary key
COMPANY, VENDOR, INVOICE, SUFFIX, CANCEL-SEQ
Fields
155
Updated by
14 programs
Referenced by
308 programs

APAPIHIST is the Vendor Invoice History table in Lawson Accounts Payable (prefix AH1). It is indexed by COMPANY, VENDOR, INVOICE, SUFFIX, CANCEL-SEQ (AH1SET1); alternate indexes: AH1SET10, AH1SET11, AH1SET12, AH1SET13, AH1SET3, AH1SET4, AH1SET5, AH1SET6 and 1 more. It is related 1:1 to APCOMPANY, APINCCODE, APVENMAST, APPROCLEV, APVENLOC, EEADVANCE, EEEXPENSE, APISRHIST and 1 more and 1:M to APAPDHIST, APAPPHIST, APDISTPAY, MAAOIHIST, MAMAAHIST, MAMADHIST, APAPIHIST, PORECEIVE and 1 more. It is updated by AP115, AP136, AP180, AP181, AP190, AP198, AP232, AP28.1 and 6 more and referenced by AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 and 300 more. The table has 155 fields, 10 indexes and 23 documented relations.

About APAPIHIST

No description in the Lawson data dictionary.

Fields (155)

Column = COBOL field name without the AH1- 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
#AH1-COMPANY PK
COMPANY		Numeric 4Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources.AP198, AP300
#AH1-VENDOR PK
VENDOR		Alpha 9 (Right Justified)The vendor's identification code.AP115, AP198, AP300
#AH1-INVOICE PK
INVOICE		Alpha 22Used to identify the invoice.AP115, AP198, AP300
#AH1-SUFFIX PK
SUFFIX		Numeric 3This is the suffix for the invoice.AP198, AP300
#AH1-CANCEL-SEQ PK
CANCEL_SEQ		Numeric 4An automatically assigned sequence number.AP198, AP300
#AH1-CANCEL-DATE
CANCEL_DATE		Numeric 8 (yyyymmdd)The cancellation date.AP198
#AH1-BATCH-NUM SET3
BATCH_NUM		Numeric 6This identifies the batch the entered invoices, debit memos, and credit memos are a part of.AP198
#AH1-BATCH-DATE
BATCH_DATE		Numeric 8 (yyyymmdd)—AP198
#AH1-VOUCHER-NBR SET4
VOUCHER_NBR		Alpha 10—AP198
#AH1-AUTH-CODE SET3
AUTH_CODE		Alpha 3A user-defined code representing a person or department responsible for approving a registered invoice.AP198
#AH1-PROC-LEVEL
PROC_LEVEL		Alpha 5This field contains the process level, which is the reporting hierarchy below company.AP198
#AH1-ACCR-CODE SET10
ACCR_CODE		Alpha 4A user-defined code representing a general ledger accrual account.AP198
#AH1-INVOICE-TYPE
INVOICE_TYPE		Alpha 1THis field will be filled in from the Invoice based on PO number. This is a carrier for the field. The PORECEIVE file will have to be updated with this field.AP198
#AH1-INV-CURRENCY SET10
INV_CURRENCY		Alpha 5—AP198
#AH1-PAY-CURRENCY
PAY_CURRENCY		Alpha 5—AP198
#AH1-INVOICE-DTE SET12 SET6
INVOICE_DTE		Numeric 8 (yyyymmdd)—AP198
#AH1-PURCH-FR-LOC
PURCH_FR_LOC		Alpha 4The vendor's purchase from location.AP115, AP198
#AH1-PO-NUMBER SET9
PO_NUMBER		Alpha 14 (Right Justified)This field contains the number representing the purchase order.AP198
#AH1-PO-RELEASE SET9
PO_RELEASE		Numeric 4Used to identify a purchase order release (created from a Blanket or Standing order).AP198
#AH1-PO-CODE SET9
PO_CODE		Alpha 4This is the purchase order code.AP198
#AH1-DESCRIPTION
DESCRIPTION		Alpha 30 (Lower Case)This field displays the description.AP198
#AH1-BASE-INV-AMT
BASE_INV_AMT		Signed 18.2—AP198
#AH1-BASE-ACT-AMT
BASE_ACT_AMT		Signed 18.2—AP198
#AH1-BASE-ND
BASE_ND		Numeric 1The number of decimal positions defined for the company base currency.AP198
#AH1-TRAN-INV-AMT
TRAN_INV_AMT		Signed 18.2—AP198
#AH1-TRAN-ALOW-AMT
TRAN_ALOW_AMT		Signed 18.2—AP198
#AH1-TRAN-TXBL-AMT
TRAN_TXBL_AMT		Signed 18.2—AP198
#AH1-TRAN-TOT-TXBL
TRAN_TOT_TXBL		Signed 18.2—AP198
#AH1-TRAN-ND
TRAN_ND		Numeric 1The number of decimals assigned to a particular account as determined by the account currency.AP198
#AH1-TRAN-TAX-AMT
TRAN_TAX_AMT		Signed 18.2—AP198
#AH1-BASE-DISC-AMT
BASE_DISC_AMT		Signed 18.2—AP198
#AH1-TRAN-DISC-AMT
TRAN_DISC_AMT		Signed 18.2—AP198
#AH1-BASE-TOT-PMT
BASE_TOT_PMT		Signed 18.2—AP198
#AH1-TRAN-TOT-PMT
TRAN_TOT_PMT		Signed 18.2—AP198
#AH1-BASE-TOT-DIST
BASE_TOT_DIST		Signed 18.2—AP198
#AH1-TRAN-TOT-DIST
TRAN_TOT_DIST		Signed 18.2—AP198
#AH1-TRAN-TOT-TAX
TRAN_TOT_TAX		Signed 18.2—AP198
#AH1-TRAN-PAID-AMT
TRAN_PAID_AMT		Signed 18.2—AP198
#AH1-ORIG-CNV-RATE
ORIG_CNV_RATE		Signed 14.7—AP198
#AH1-ANTICIPATION
ANTICIPATION		Alpha 1The anticipation flag.AP198
#AH1-DISCOUNT-RT
DISCOUNT_RT		Percent 5.3 (Percent)—AP198
#AH1-DISC-DATE
DISC_DATE		Numeric 8 (yyyymmdd)This field displays the system date when this was created.AP198
#AH1-DUE-DATE
DUE_DATE		Numeric 8 (yyyymmdd)The transaction due date.AP198
#AH1-NBR-SPLIT-PMT
NBR_SPLIT_PMT		Numeric 3—AP198
#AH1-SPLIT-PMT-SCH
SPLIT_PMT_SCH		Alpha 1—AP198
#AH1-NBR-RECUR-PMT
NBR_RECUR_PMT		Numeric 3—AP198
#AH1-RECUR-FREQ
RECUR_FREQ		Alpha 1—AP198
#AH1-REMIT-TO-CODE
REMIT_TO_CODE		Alpha 4A user-defined code that represents a vendor's remittance address.AP115, AP198
#AH1-CASH-CODE
CASH_CODE		Alpha 4A cash code represents a bank account. More than one company can use the same cash code. The cash code must be linked to a bank in the Lawson Cash Ledger system.AP115, AP198
#AH1-BANK-INST-CODE
BANK_INST_CODE		Alpha 3A transaction code represents a type of cash payment, bill of exchange payment, or bank service transaction.AP115, AP198
#AH1-CURR-RECALC
CURR_RECALC		Alpha 1—AP198
#AH1-TAX-CODE
TAX_CODE		Alpha 10This field contains a code representing specific tax information. This must be valid Tax Code.AP198
#AH1-INCOME-CODE
INCOME_CODE		Alpha 4A user-defined code that represents a type of income withholding. Used to track reportable income for reporting or withholding.AP198
#AH1-DIST-CODE
DIST_CODE		Alpha 9A user-defined code used to automatically create expense distributions or expense distribution "shells" for invoices or to split an invoice distribution into multiple distributions.AP198
#AH1-REC-STATUS SET10 SET3 SET4
REC_STATUS		Numeric 1The record status.AP198
#AH1-CREATE-DATE SET3
CREATE_DATE		Numeric 8 (yyyymmdd)The creation date.AP198
#AH1-DISTRIB-DATE
DISTRIB_DATE		Numeric 8 (yyyymmdd)This field displays the system date when this was created.AP198
#AH1-OPERATOR SET3
OPERATOR		Alpha 10This field is used to store the login id of the person who entered the record.AP198
#AH1-CREATION-TIME SET3
CREATION_TIME		Numeric 6 (hhmmss)The creation time.AP198
#AH1-VENDOR-GROUP SET5
VENDOR_GROUP		Alpha 4A vendor group represents a group of vendors that can be shared by one or more companies.AP198
#AH1-PAY-VENDOR
PAY_VENDOR		Alpha 9 (Right Justified)The vendor's identification code.AP115, AP198
#AH1-PAY-GROUP
PAY_GROUP		Alpha 4A pay group is used for processing accounts payable payments. A pay group lets you create a single payment for a vendor to pay invoices received by all company process levels assigned to the pay group.AP198
#AH1-INVOICE-GROUP
INVOICE_GROUP		Alpha 4A user-defined character expression. An invoice group can be assigned to one more invoices. AP150 (Cash Requirements) has an option to select all invoices assigned the same invoice group.AP115, AP198
#AH1-LAST-DIST-SEQ
LAST_DIST_SEQ		Numeric 6A unique sequence number.AP198
#AH1-LAST-PMT-SEQ
LAST_PMT_SEQ		Numeric 4An automatically assigned sequence number.AP198
#AH1-DISCOUNT-CODE
DISCOUNT_CODE		Alpha 10A user-defined code that represents a general ledger discount account.AP198
#AH1-INVOICE-SOURCE
INVOICE_SOURCE		Alpha 1Indicates the source for creation of the invoice (manual, EDI, evaluated receipts settlement).AP198
#AH1-INVC-REF-TYPE
INVC_REF_TYPE		Alpha 2Indicates the type of number the vendor is providing to reference the invoice.AP198
#AH1-APPROVED-FLAG
APPROVED_FLAG		Alpha 1—AP198
#AH1-APPRV-OPERATOR
APPRV_OPERATOR		Alpha 10This field is used to store the login id of the person who entered the record.AP198
#AH1-RETURN-NUMBER
RETURN_NUMBER		Numeric 10This is the number assigned to the return for purposes of referencing the return internally and with the customer or vendor.AP198
#AH1-JRNL-BOOK-NBR
JRNL_BOOK_NBR		Alpha 12The journal book assigned to the transaction.AP198
#AH1-TAX-POINT
TAX_POINT		Alpha 1—AP198
#AH1-OBJ-ID SET11
OBJ_ID		Numeric 12This is the object identifier. It is used to relate commitments or posted transactions back to the originating subsystems. Each subsystem record that is updated as a commitment or posted transaction is assigned an object identifier. The object identifier is maintained in the subsystem files and in the Activity Commitments Detail and Activity Transaction files. The object identifier is a unique key used to drill back from Activity Management to the subsystems.AP198
#AH1-RECON-DATE SET10
RECON_DATE		Numeric 8 (yyyymmdd)Represents the date the transaction cleared the bank or was voided.AP136, AP198, AP232
#AH1-POD-PRINTED
POD_PRINTED		Numeric 1—AP198
#AH1-MATCH-REF-NBR SET11
MATCH_REF_NBR		Alpha 22—AP198
#AH1-MATCH-FL
MATCH_FL		Alpha 1This field determines whether a transaction is considered to be a match transaction.AP198
#AH1-TERMS-CD
TERMS_CD		Alpha 5A user-defined code representing a method of determining invoice due and discount dates.AP198
#AH1-RCPT-INV-DATE
RCPT_INV_DATE		Numeric 8 (yyyymmdd)This field displays the system date when this was created.AP198
#AH1-RETAIL-AMT
RETAIL_AMT		Signed 18.2—AP198
#AH1-MATCH-STATUS
MATCH_STATUS		Numeric 1—AP198
#AH1-REASON-CODE
REASON_CODE		Alpha 4This field contains the reason code, which indicates the cause for credit memos.AP198
#AH1-HANDLING-CODE
HANDLING_CODE		Alpha 4—AP198
#AH1-MATCH-AMT
MATCH_AMT		Signed 18.2—AP198
#AH1-AOC-ALLOW-AMT
AOC_ALLOW_AMT		Signed 18.2—AP198
#AH1-LOCATION SET9
LOCATION		Alpha 5This field contains a valid stocking location within the company inventory.AP198
#AH1-MATCH-OBJ-ID SET13
MATCH_OBJ_ID		Numeric 12This is the object identifier. It is used to relate commitments or posted transactions back to the originating subsystems. Each subsystem record that is updated as a commitment or posted transaction is assigned an object identifier. The object identifier is maintained in the subsystem files and in the Activity Commitments Detail and Activity Transaction files. The object identifier is a unique key used to drill back from Activity Management to the subsystems.AP198
#AH1-CBPRINT-FL SET12
CBPRINT_FL		Alpha 1—AP198
#AH1-MATCH-TABLE
MATCH_TABLE		Alpha 10—AP198
#AH1-TAX-CODE-CNTL
TAX_CODE_CNTL		Alpha 1This control field defines the tax code usage in invoicing and approving taxes. For PO Invoices, if set to O (Override) all lines approved for payment will use the tax code defined for the whole invoice. If set to I (Ignore) no PO lines approved for payment will be taxed.AP198
#AH1-LAST-MATCH-LN
LAST_MATCH_LN		Numeric 4—AP198
#AH1-MATCH-LEVEL
MATCH_LEVEL		Alpha 3—AP198
#AH1-MATCH-DATE
MATCH_DATE		Numeric 8 (yyyymmdd)This field displays the system date when this was created.AP198
#AH1-PO-INV-TAX
PO_INV_TAX		Signed 18.2—AP198
#AH1-BYPASS-MATCH
BYPASS_MATCH		Alpha 1—AP198
#AH1-SERVICE-FL
SERVICE_FL		Alpha 1This field indicates a transaction is a Service only transaction.AP198
#AH1-SERVICE-AMT
SERVICE_AMT		Signed 18.2—AP198
#AH1-NOTC
NOTC		Alpha 2The Nature of Transaction code. Must be a valid code defined in IN07.1 (NOTC Maintenance).AP198
#AH1-STAT-PROC
STAT_PROC		Alpha 6The statistical procedure code applied to the data. The code must be defined in IN06.1. (Statistical Procedure Maintenance).AP198
#AH1-SHIP-VIA
SHIP_VIA		Alpha 12 (Lower Case)—AP198
#AH1-UNLOADING-PORT
UNLOADING_PORT		Alpha 5The prot where the goods are unloaded if required. Must be defined in IN04.1 (Port Maintenance)AP198
#AH1-INTRASTAT-NBR
INTRASTAT_NBR		Numeric 12The number assigned by the Intrastat system to a transaction that involves Intrastat reporting after it has been added.AP198
#AH1-DROPSHIP-FL
DROPSHIP_FL		Alpha 1This flag indicates whether goods being shipped by the vendor directly to a non standard location need to have the receiving process performed.AP198
#AH1-FOB-CODE
FOB_CODE		Alpha 3The user defined Free On Board Code.AP198
#AH1-TAX-OUT-BAL
TAX_OUT_BAL		Derived——
#AH1-TXB-OUT-BAL
TXB_OUT_BAL		DerivedDerived field to show difference between header taxable input and total taxable amount from distributions.—
#AH1-PMT-OUT-BAL
PMT_OUT_BAL		Derived——
#AH1-DIST-OUT-BAL
DIST_OUT_BAL		Derived——
#AH1-OUT-BAL-FLAG
OUT_BAL_FLAG		Derived——
#AH1-INV-STATUS
INV_STATUS		Derived——
#AH1-NET-PAYABLE
NET_PAYABLE		Derived——
#AH1-REV-SIGN-AMT
REV_SIGN_AMT		Derived——
#AH1-TYPE-SHORT-NME
TYPE_SHORT_NME		Derived——
#AH1-PO-RELEASE-3
PO_RELEASE_3		DerivedThe PO release number converted to a three-character field for purposes of display and printing the shorter field.—
#AH1-JBK-SEQ-NBR
JBK_SEQ_NBR		Numeric 10The journal book sequence number assigned to a journal book transaction when it is added or interfaced to the Lawson system. Used only when Auto Journal Book Seq Nbr is set to Yes in GL10.1 (Company).AP198
#AH1-DIVERSE-CODE
DIVERSE_CODE		Alpha 5Diversity Code for Account Payable VendorsAP115, AP198
#AH1-FLEX-FLAG
FLEX_FLAG		Alpha 1—AP198
#AH1-RULE-GROUP
RULE_GROUP		Alpha 10—AP198
#AH1-FLOAT-DAYS
FLOAT_DAYS		Numeric 3—AP198
#AH1-MTCH-PREPAY-FL
MTCH_PREPAY_FL		Alpha 1—AP198
#AH1-MTCH-PREPAY-MT
MTCH_PREPAY_MT		Numeric 1—AP198
#AH1-PREPAY-DATE
PREPAY_DATE		Numeric 8 (yyyymmdd)—AP198
#AH1-COCO-FL
COCO_FL		Numeric 1This is the flag when added to the handling code denotes that the invoice will be reviewed for match based on header, line, and Cost components (AOC)AP198
#AH1-MATCH-AOC
MATCH_AOC		Signed 18.2—AP198
#AH1-HASH-QTY
HASH_QTY		Signed 15.4—AP198
#AH1-XREF-VENDOR
XREF_VENDOR		Alpha 9 (Right Justified)This is a vendor that is supported on a system outside Lawson. When records are interfaces we will maintain this vendor on the file but we will use the Lawson vendor while in the lawson application.AP198
#AH1-MTCH-ERR-TYPE
MTCH_ERR_TYPE		Numeric 2This is the reason the match was not successful for Invoice Match.
  • 01 Match Invoice
  • 02 Cost error
  • 03 No receipt information
  • 04 Hash quantity error
  • 05 No AOC on purchase order
  • 06 No AOC cost
AP198
#AH1-BT-AMT
BT_AMT		Signed 18.2—AP198
#AH1-DISC-POINT
DISC_POINT		Numeric 1—AP198
#AH1-BUYER
BUYER		Alpha 3——
#AH1-FINAL-DST-FLAG
FINAL_DST_FLAG		Alpha 1——
#AH1-PRPY-DISC-CODE
PRPY_DISC_CODE		Alpha 10——
#AH1-PRPY-REF-NBR
PRPY_REF_NBR		Alpha 22——
#AH1-PRPY-RTL-AMT
PRPY_RTL_AMT		Signed 18.2——
#AH1-PRPY-AMT
PRPY_AMT		Signed 18.2——
#AH1-PRPY-AOC-AMT
PRPY_AOC_AMT		Signed 18.2——
#AH1-PRPY-TAX-AMT
PRPY_TAX_AMT		Signed 18.2——
#AH1-PRPY-SERV-AMT
PRPY_SERV_AMT		Signed 18.2——
#AH1-TAX-FLAG
TAX_FLAG		Alpha 1——
#AH1-STATEMENT
STATEMENT		Alpha 22Used to identify the invoice.—
#AH1-MTCH-PROC-TYPE
MTCH_PROC_TYPE		Alpha 2—
  • R Receipt Match
  • S Service
  • A AOC only
  • D Drop Ship
  • V Vendor Agreement
  • E Expense
AP198
#AH1-RET-ACCR-CODE
RET_ACCR_CODE		Alpha 4—AP198
#AH1-RET-TRAN-AMT
RET_TRAN_AMT		Signed 18.2—AP198
#AH1-RET-BASE-AMT
RET_BASE_AMT		Signed 18.2—AP198
#AH1-RET-TRAN-PMT
RET_TRAN_PMT		Signed 18.2—AP198
#AH1-RET-BASE-PMT
RET_BASE_PMT		Signed 18.2—AP198
#AH1-CONTRACT-GROUP
CONTRACT_GROUP		Alpha 4—AP198
#AH1-CM-CONTRACT
CM_CONTRACT		Numeric 15—AP198
#AH1-REBATE-TYPE
REBATE_TYPE		Alpha 25—AP198
#AH1-REBATE-DUE-DTE
REBATE_DUE_DTE		Numeric 8 (yyyymmdd)—AP198
#AH1-TAX-TYPE
TAX_TYPE		Alpha 1—
  • I Invoiced
  • A Accrued
—
#AH1-SEC-WITHHOLD
SEC_WITHHOLD		Alpha 1—
  • Y Yes
  • N No
AP198
#AH1-FOR-ECON-CODE
FOR_ECON_CODE		Alpha 10——
#AH1-REFERENCE-NO
REFERENCE_NO		Alpha 25 (Right Justified)—AP198

Indexes (10)

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
AH1SET1
  1. COMPANY
  2. VENDOR
  3. INVOICE
  4. SUFFIX
  5. CANCEL-SEQ
PrimaryAP00.4, AP01.1, AP115, AP125, AP126, AP131, AP136, AP180 +22 more (list truncated in source)
AH1SET10
  1. COMPANY
  2. RECON-DATE
  3. ACCR-CODE
  4. INV-CURRENCY
  5. VENDOR
  6. INVOICE
  7. SUFFIX
  8. CANCEL-SEQ
  9. REC-STATUS
KeyChangeAP136, AP232
AH1SET11
  1. COMPANY
  2. VENDOR
  3. MATCH-REF-NBR
  4. OBJ-ID
KeyChange, SubsetWhere MATCH-REF-NBR != Spaces—
AH1SET12
  1. COMPANY
  2. CBPRINT-FL
  3. VENDOR
  4. INVOICE-DTE
  5. INVOICE
  6. SUFFIX
  7. CANCEL-SEQ
SubsetWhere INVOICE-TYPE = "C"AP131
AH1SET13
  1. COMPANY
  2. VENDOR
  3. MATCH-OBJ-ID
  4. INVOICE
  5. SUFFIX
  6. CANCEL-SEQ
KeyChangeAP131, AP136, AP232
AH1SET3
  1. REC-STATUS
  2. COMPANY
  3. BATCH-NUM
  4. AUTH-CODE
  5. OPERATOR
  6. CREATE-DATE
  7. CREATION-TIME
  8. VENDOR
  9. INVOICE
  10. SUFFIX
  11. CANCEL-SEQ
KeyChangeAP300
AH1SET4
  1. COMPANY
  2. VOUCHER-NBR
  3. REC-STATUS
  4. VENDOR
  5. INVOICE
  6. SUFFIX
  7. CANCEL-SEQ
KeyChangeAP00.4, AP520, AP96.2
AH1SET5
  1. VENDOR-GROUP
  2. VENDOR
  3. INVOICE
  4. SUFFIX
  5. CANCEL-SEQ
  6. COMPANY
KeyChangeAC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +22 more (list truncated in source)
AH1SET6
  1. COMPANY
  2. VENDOR
  3. INVOICE-DTE
  4. INVOICE
  5. SUFFIX
  6. CANCEL-SEQ
KeyChangeAP251, AP300
AH1SET9
  1. COMPANY
  2. VENDOR
  3. PO-NUMBER
  4. PO-RELEASE
  5. PO-CODE
  6. LOCATION
  7. INVOICE
  8. SUFFIX
  9. CANCEL-SEQ
KeyChangeAP96.3

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
APCOMPANYAPINCCODEAPVENMASTAPPROCLEVAPVENLOCEEADVANCEEEEXPENSEAPISRHISTMAREASONCDAPAPDHISTAPAPPHISTAPDISTPAYMAAOIHISTMAMAAHISTMAMADHISTAPAPIHISTPORECEIVEPORECLINEAPAPIHIST

One to one (12) — lookups and parents

RelationTableRulesConditionField map
ApcompanyAPCOMPANYRequired
AH1-COMPANY→CPY-COMPANY
ApinccodeAPINCCODENot Required
AH1-INCOME-CODE→TYP-INCOME-CODE
AppayvenmastAPVENMASTRequired
CPY-VENDOR-GROUP→VEN-VENDOR-GROUP
AH1-PAY-VENDOR→VEN-VENDOR
ApproclevAPPROCLEVRequired
AH1-COMPANY→APR-COMPANY
AH1-PROC-LEVEL→APR-PROC-LEVEL
ApvenlocpurchAPVENLOCRequiredWhen AH1-PURCH-FR-LOC != Spaces
AH1-VENDOR-GROUP→VLO-VENDOR-GROUP
AH1-VENDOR→VLO-VENDOR
AH1-PURCH-FR-LOC→VLO-LOCATION-CODE
ApvenlocremitAPVENLOCRequiredWhen AH1-REMIT-TO-CODE != Spaces
AH1-VENDOR-GROUP→VLO-VENDOR-GROUP
AH1-PAY-VENDOR→VLO-VENDOR
AH1-REMIT-TO-CODE→VLO-LOCATION-CODE
ApvenmastAPVENMASTRequired
CPY-VENDOR-GROUP→VEN-VENDOR-GROUP
AH1-VENDOR→VEN-VENDOR
Eeadvance AEEADVANCERequiredWhen AH1-INVOICE-TYPE = "A"
AH1-COMPANY→EEA-COMPANY
AH1-VENDOR→EEA-VENDOR
AH1-INVOICE→EEA-ADVANCE-NBR
Eeadvance MEEADVANCERequiredWhen AH1-INVOICE-TYPE = "M"
AH1-COMPANY→EEA-COMPANY
AH1-VENDOR→EEA-VENDOR
AH1-INVOICE→EEA-ADVANCE-NBR
EeexpenseEEEXPENSERequiredWhen AH1-INVOICE-TYPE = "E"
AH1-COMPANY→EXP-COMPANY
AH1-VENDOR→EXP-VENDOR
AH1-INVOICE→EXP-EXPENSE-NBR
InvusrfldAPISRHISTNot Required
AH1-OBJ-ID→AH9-OBJ-ID
ReasoncdMAREASONCDNot Required
AH1-REASON-CODE→MAR-REASON-CODE

One to many (11) — child tables

RelationTableRulesConditionField map
ApapdhistAPAPDHISTDelete Cascades
AH1-OBJ-ID→AH2-API-OBJ-ID
—→AH2-DIST-SEQ-NBR
ApapphistAPAPPHISTDelete Cascades
AH1-COMPANY→AH3-COMPANY
AH1-VENDOR→AH3-VENDOR
AH1-INVOICE→AH3-INVOICE
AH1-SUFFIX→AH3-SUFFIX
AH1-CANCEL-SEQ→AH3-CANCEL-SEQ
—→AH3-SEQ-NBR
—→AH3-VOID-SEQ
ApdistpayAPDISTPAY
AH1-COMPANY→DTY-COMPANY
AH1-VENDOR→DTY-VENDOR
AH1-INVOICE→DTY-INVOICE
AH1-SUFFIX→DTY-SUFFIX
—→DTY-PMT-SEQ-NBR
—→DTY-LINE-NBR
—→DTY-MAD-SEQ-NBR
—→DTY-DIST-SEQ-NBR
MaaoihistMAAOIHISTDelete Restricted
AH1-COMPANY→MH2-COMPANY
AH1-VENDOR→MH2-VENDOR
AH1-INVOICE→MH2-INVOICE
AH1-SUFFIX→MH2-SUFFIX
—→MH2-PO-NUMBER
—→MH2-PO-RELEASE
—→MH2-PO-CODE
MamaahistMAMAAHIST
AH1-COMPANY→MMH-COMPANY
AH1-VENDOR→MMH-VENDOR
AH1-INVOICE→MMH-INVOICE
AH1-SUFFIX→MMH-SUFFIX
AH1-PO-NUMBER→MMH-PO-NUMBER
AH1-PO-RELEASE→MMH-PO-RELEASE
AH1-PO-CODE→MMH-PO-CODE
—→MMH-LINE-NBR
—→MMH-AOC-CODE
—→MMH-SEQ-NBR
Mamaahist 2MAMAAHIST
AH1-COMPANY→MMH-COMPANY
AH1-VENDOR→MMH-VENDOR
AH1-INVOICE→MMH-INVOICE
AH1-SUFFIX→MMH-SUFFIX
—→MMH-PO-NUMBER
—→MMH-PO-RELEASE
—→MMH-PO-CODE
—→MMH-LINE-NBR
—→MMH-AOC-CODE
—→MMH-SEQ-NBR
MamadhistMAMADHIST
AH1-COMPANY→MH1-COMPANY
AH1-VENDOR→MH1-VENDOR
AH1-INVOICE→MH1-INVOICE
AH1-SUFFIX→MH1-SUFFIX
AH1-PO-NUMBER→MH1-PO-NUMBER
AH1-PO-RELEASE→MH1-PO-RELEASE
AH1-PO-CODE→MH1-PO-CODE
—→MH1-LINE-NBR
—→MH1-AOC-CODE
—→MH1-SEQ-NBR
Mamadhist 2MAMADHIST
AH1-COMPANY→MH1-COMPANY
AH1-VENDOR→MH1-VENDOR
AH1-INVOICE→MH1-INVOICE
AH1-SUFFIX→MH1-SUFFIX
—→MH1-PO-NUMBER
—→MH1-PO-RELEASE
—→MH1-PO-CODE
—→MH1-LINE-NBR
—→MH1-AOC-CODE
—→MH1-SEQ-NBR
Match TransAPAPIHIST
AH1-COMPANY→AH1-COMPANY
AH1-VENDOR→AH1-VENDOR
AH1-MATCH-OBJ-ID→AH1-MATCH-OBJ-ID
—→AH1-INVOICE
—→AH1-SUFFIX
—→AH1-CANCEL-SEQ
Por Match RefPORECEIVE
AH1-COMPANY→POR-COMPANY
AH1-VENDOR→POR-VENDOR
AH1-MATCH-REF-NBR→POR-MATCH-REF-NBR
—→POR-REC-NUMBER
PoreclinePORECLINE
AH1-COMPANY→PRL-COMPANY
AH1-MATCH-OBJ-ID→PRL-MATCH-OBJ-ID
—→PRL-MATCH-SEQ-NBR
—→PRL-REC-NUMBER
—→PRL-LINE-NBR

Programs

Updated by (14)

Referenced by (308)