APAPIHIST

REFERENCED BY
AP197 AP245 AP255 AP270 AP32.1 MA540
AP01.1 AP275 APH1.1


UPDATED BY
AC160 AM115 AM117 AM15.1 AM15.2 AM15.3
AM15.4 AM19.1 AM19.2 AM20.1 AM20.3 AM21.1
AM21.3 AM22.1 AM500 AM51.1 AM551 AM97.1
AP00.4 AP03.3 AP10.1 AP110 AP115 AP125
AP126 AP131 AP136 AP150 AP180 AP181
AP190 AP198 AP20.1 AP20.2 AP20.3 AP20.4
AP20.5 AP20.6 AP20.7 AP21.1 AP210 AP212
AP220 AP23.1 AP25.1 AP25.2 AP251 AP26.1
AP27.1 AP271 AP28.1 AP28.2 AP30.2 AP30.4
AP300 AP305 AP45.1 AP510 AP520 AP90.1
AP91.1 AP93.1 AP96.1 AP96.2 AP96.3 API1.1
API2.1 API3.1 API4.1 CX100 CX20.1 CX20.2
CX20.4 CX20.5 CX220 CX30.1 CX300 CX506
CXCP.1 EE20.1 EE20.2 EE20.4 DR100 IC140
IC142 IC64.1 IC64.2 IC64.3 IC64.4 IC64.5
IC64.6 IC64.7 IC64.8 IC64.9 IC66.1 IC83.1
IC840 MX123 MX500 MA180 MA279 MA41.1
MA41.2 MA41.4 MA41.7 MA42.1 MA42.2 MA43.1
MA43.2 MA43.3 MA43.4 MA43.6 MA43.7 MA44.1
MA44.2 MA530 MA531 MA60.2 MA60.3 MA60.5
MA61.1 MA63.1 MA65.1 MA66.2 MA67.2 MA67.3
MA68.2 MA68.3 MA68.5 MA69.1 MA70.1 MA75.1
MA80.1 MAI1.1 PD10.1 PD10.2 PD130 PD20.1
PD20.2 PD20.3 PD235 PO10.1 PO100 PO101
PO120 PO122 PO131 PO136 PO150 PO190
PO20.1 PO20.6 PO20.9 PO21.1 PO21.2 PO21.3
PO21.4 PO21.5 PO22.1 PO22.2 PO22.3 PO22.4
PO22.5 PO220 PO223 PO23.1 PO233 PO24.1
PO25.1 PO25.5 PO25.6 PO25.7 PO253 PO254
PO27.2 PO278 PO28.2 PO29.1 PO30.1 PO30.2
PO30.3 PO30.4 PO300 PO31.1 PO31.2 PO32.2
PO32.4 PO33.1 PO34.1 PO35.1 PO36.1 PO36.2
PO38.1 PO39.1 PO39.2 PO44.1 PO50.1 PO52.1
PO520 PO536 PO54.1 PO54.2 PO54.3 PO54.4
PO54.5 POA3.1 POCP.1 POI3.1 POID.1 POII.1
POIJ.1 PR05.1 PR05.3 PR226 PR247 PR26.1
PR47.1 PR514 UK47.1 RQ10.1 RQ10.2 RQ10.4
RQ12.1 RQ13.1 RQ13.2 RQ260 RQ35.1 RQ500
RQIF.1 WH130 WH132 WH190 WH20.2 WH20.7
WH222 WH30.1 WH30.2 WH30.3 WH30.4 WH31.1
WH31.2 WH31.3 WH31.4 WH32.1 WH32.2 WH32.3
WH32.4 WH32.5 WH33.1 WH33.2 WH33.3 WH33.4
WH33.5 WH33.6 WH33.8 WH33.9 WH34.1 WH34.2
WH34.3 WH34.4 WH40.1 WH40.2 WH520 WH830
ZW130

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
AH1-COMPANY
Element: Company
Numeric 4
Identifies 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
Element: Vendor
Alpha 9 (Right Justified)
The vendor's identification code.
AP115 AP198
AP300
AH1-INVOICE
Element: Invoice
Alpha 22
Used to identify the invoice.
AP115 AP198
AP300
AH1-SUFFIX
Element: Suffix
Numeric 3
This is the suffix for the invoice.
AP198 AP300
AH1-CANCEL-SEQ
Element: Seq Nbr
Numeric 4
An automatically assigned sequence number.
AP198 AP300
AH1-CANCEL-DATE
Element: Cancel Date
Numeric 8 (yyyymmdd)
The cancellation date.
AP198
AH1-BATCH-NUM
Element: Batch Nbr
Numeric 6
This identifies the batch the entered invoices, debit memos, and credit memos are a part of.
AP198
AH1-BATCH-DATE
Element: Batch Date
Numeric 8 (yyyymmdd)
AP198
AH1-VOUCHER-NBR
Element: Voucher Nbr
Alpha 10
AP198
AH1-AUTH-CODE
Element: Auth Code
Alpha 3
A user-defined code representing a person or department responsible for approving a registered invoice.
AP198
AH1-PROC-LEVEL
Element: Process Level
Alpha 5
This field contains the process level, which is the reporting hierarchy below company.
AP198
AH1-ACCR-CODE
Element: Accr Code
Alpha 4
A user-defined code representing a general ledger accrual account.
AP198
AH1-INVOICE-TYPE
Element: Invoice Type
Alpha 1
THis 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
Element: To Base Curr
Alpha 5
AP198
AH1-PAY-CURRENCY
Element: To Base Curr
Alpha 5
AP198
AH1-INVOICE-DTE
Element: Invoice Dte
Numeric 8 (yyyymmdd)
AP198
AH1-PURCH-FR-LOC
Element: Purch Fr Loc
Alpha 4
The vendor's purchase from location.
AP115 AP198
AH1-PO-NUMBER
Element: Po Number
Alpha 14 (Right Justified)
This field contains the number representing the purchase order.
AP198
AH1-PO-RELEASE
Element: Po Release
Numeric 4
Used to identify a purchase order release (created from a Blanket or Standing order).
AP198
AH1-PO-CODE
Element: Po Code
Alpha 4
This is the purchase order code.
AP198
AH1-DESCRIPTION
Element: Description
Alpha 30 (Lower Case)
This field displays the description.
AP198
AH1-BASE-INV-AMT
Element: Intl Amt
Signed 18.2
AP198
AH1-BASE-ACT-AMT
Element: Intl Amt
Signed 18.2
AP198
AH1-BASE-ND
Element: Base Nd
Numeric 1
The number of decimal positions defined for the company base currency.
AP198
AH1-TRAN-INV-AMT
Element: Intl Amt
Signed 18.2
AP198
AH1-TRAN-ALOW-AMT
Element: Intl Amt
Signed 18.2
AP198
AH1-TRAN-TXBL-AMT
Element: Intl Amt
Signed 18.2
AP198
AH1-TRAN-TOT-TXBL
Element: Intl Amt
Signed 18.2
AP198
AH1-TRAN-ND
Element: Acct Nd
Numeric 1
The number of decimals assigned to a particular account as determined by the account currency.
AP198
AH1-TRAN-TAX-AMT
Element: Intl Amt
Signed 18.2
AP198
AH1-BASE-DISC-AMT
Element: Intl Amt
Signed 18.2
AP198
AH1-TRAN-DISC-AMT
Element: Intl Amt
Signed 18.2
AP198
AH1-BASE-TOT-PMT
Element: Intl Amt
Signed 18.2
AP198
AH1-TRAN-TOT-PMT
Element: Intl Amt
Signed 18.2
AP198
AH1-BASE-TOT-DIST
Element: Intl Amt
Signed 18.2
AP198
AH1-TRAN-TOT-DIST
Element: Intl Amt
Signed 18.2
AP198
AH1-TRAN-TOT-TAX
Element: Intl Amt
Signed 18.2
AP198
AH1-TRAN-PAID-AMT
Element: Intl Amt
Signed 18.2
AP198
AH1-ORIG-CNV-RATE
Element: Acct Rate
Signed 14.7
AP198
AH1-ANTICIPATION
Element: Anticipation
Alpha 1
The anticipation flag.
AP198
AH1-DISCOUNT-RT
Element: Discount Rt
Percent 5.3 (Percent)
AP198
AH1-DISC-DATE
Element: Date
Numeric 8 (yyyymmdd)
This field displays the system date when this was created.
AP198
AH1-DUE-DATE
Element: Due Date
Numeric 8 (yyyymmdd)
The transaction due date.
AP198
AH1-NBR-SPLIT-PMT
Element: Nbr Of Invcs
Numeric 3
AP198
AH1-SPLIT-PMT-SCH
Element: Split Pmt Sch
Alpha 1
AP198
AH1-NBR-RECUR-PMT
Element: Nbr Of Invcs
Numeric 3
AP198
AH1-RECUR-FREQ
Element: Recur Freq
Alpha 1
AP198
AH1-REMIT-TO-CODE
Element: Remit To Code
Alpha 4
A user-defined code that represents a vendor's remittance address.
AP115 AP198
AH1-CASH-CODE
Element: Cash Code
Alpha 4
A 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
Element: Bank Inst Code
Alpha 3
A transaction code represents a type of cash payment, bill of exchange payment, or bank service transaction.
AP115 AP198
AH1-CURR-RECALC
Element: All Flag
Alpha 1
AP198
AH1-TAX-CODE
Element: Tax Code
Alpha 10
This field contains a code representing specific tax information. This must be valid Tax Code.
AP198
AH1-INCOME-CODE
Element: Income Code
Alpha 4
A user-defined code that represents a type of income withholding. Used to track reportable income for reporting or withholding.
AP198
AH1-DIST-CODE
Element: Dist Code
Alpha 9
A 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
Element: Rec Status
Numeric 1
The record status.
AP198
AH1-CREATE-DATE
Element: Create Date
Numeric 8 (yyyymmdd)
The creation date.
AP198
AH1-DISTRIB-DATE
Element: Date
Numeric 8 (yyyymmdd)
This field displays the system date when this was created.
AP198
AH1-OPERATOR
Element: Operator
Alpha 10
This field is used to store the login id of the person who entered the record.
AP198
AH1-CREATION-TIME
Element: Creation Time
Numeric 6 (hhmmss)
The creation time.
AP198
AH1-VENDOR-GROUP
Element: Vendor Group
Alpha 4
A vendor group represents a group of vendors that can be shared by one or more companies.
AP198
AH1-PAY-VENDOR
Element: Vendor
Alpha 9 (Right Justified)
The vendor's identification code.
AP115 AP198
AH1-PAY-GROUP
Element: Pay Group
Alpha 4
A 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
Element: Invoice Group
Alpha 4
A 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
Element: Dist Seq Nbr
Numeric 6
A unique sequence number.
AP198
AH1-LAST-PMT-SEQ
Element: Seq Nbr
Numeric 4
An automatically assigned sequence number.
AP198
AH1-DISCOUNT-CODE
Element: Discount Code
Alpha 10
A user-defined code that represents a general ledger discount account.
AP198
AH1-INVOICE-SOURCE
Element: Invoice Source
Alpha 1
Indicates the source for creation of the invoice (manual, EDI, evaluated receipts settlement).
AP198
AH1-INVC-REF-TYPE
Element: Invc Ref Type
Alpha 2
Indicates the type of number the vendor is providing to reference the invoice.
AP198
AH1-APPROVED-FLAG
Element: Approved Flag
Alpha 1
AP198
AH1-APPRV-OPERATOR
Element: Operator
Alpha 10
This field is used to store the login id of the person who entered the record.
AP198
AH1-RETURN-NUMBER
Element: Return Number
Numeric 10
This 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
Element: Jrnl Book Nbr
Alpha 12
The journal book assigned to the transaction.
AP198
AH1-TAX-POINT
Element: Tax Point
Alpha 1
AP198
AH1-OBJ-ID
Element: Obj Id
Numeric 12
This 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
Element: Recon Date
Numeric 8 (yyyymmdd)
Represents the date the transaction cleared the bank or was voided.
AP136 AP198
AH1-POD-PRINTED
Element: Au Flag
Numeric 1
AP198
AH1-MATCH-REF-NBR
Element: Match Ref Nbr
Alpha 22
AP198
AH1-MATCH-FL
Element: Match Fl
Alpha 1
This field determines whether a transaction is considered to be a match transaction.
AP198
AH1-TERMS-CD
Element: Term Code
Alpha 5
A user-defined code representing a method of determining invoice due and discount dates.
AP198
AH1-RCPT-INV-DATE
Element: Date
Numeric 8 (yyyymmdd)
This field displays the system date when this was created.
AP198
AH1-RETAIL-AMT
Element: Intl Amt
Signed 18.2
AP198
AH1-MATCH-STATUS
Element: Match Status
Numeric 1
AP198
AH1-REASON-CODE
Element: Reason Code
Alpha 4
This field contains the reason code, which indicates the cause for credit memos.
AP198
AH1-HANDLING-CODE
Element: Handling Code
Alpha 4
AP198
AH1-MATCH-AMT
Element: Intl Amt
Signed 18.2
AP198
AH1-AOC-ALLOW-AMT
Element: Intl Amt
Signed 18.2
AP198
AH1-LOCATION
Element: Location
Alpha 5
This field contains a valid stocking location within the company inventory.
AP198
AH1-MATCH-OBJ-ID
Element: Obj Id
Numeric 12
This 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
Element: Cbprint Fl
Alpha 1
AP198
AH1-MATCH-TABLE
Element: Match Table
Alpha 10
AP198
AH1-TAX-CODE-CNTL
Element: Tax Code Cntl
Alpha 1
This 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
Element: Orig Line
Numeric 4
AP198
AH1-MATCH-LEVEL
Element: Match Level
Alpha 3
AP198
AH1-MATCH-DATE
Element: Date
Numeric 8 (yyyymmdd)
This field displays the system date when this was created.
AP198
AH1-PO-INV-TAX
Element: Intl Amt
Signed 18.2
AP198
AH1-BYPASS-MATCH
Element: All Flag
Alpha 1
AP198
AH1-SERVICE-FL
Element: Service Fl
Alpha 1
This field indicates a transaction is a Service only transaction.
AP198
AH1-SERVICE-AMT
Element: Intl Amt
Signed 18.2
AP198
AH1-NOTC
Element: Notc
Alpha 2
The Nature of Transaction code. Must be a valid code defined in IN07.1 (NOTC Maintenance).
AP198
AH1-STAT-PROC
Element: Stat Proc
Alpha 6
The statistical procedure code applied to the data. The code must be defined in IN06.1. (Statistical Procedure Maintenance).
AP198
AH1-SHIP-VIA
Element: Ship Via
Alpha 12 (Lower Case)
AP198
AH1-UNLOADING-PORT
Element: Unloading Port
Alpha 5
The prot where the goods are unloaded if required. Must be defined in IN04.1 (Port Maintenance)
AP198
AH1-INTRASTAT-NBR
Element: Intrastat Nbr
Numeric 12
The number assigned by the Intrastat system to a transaction that involves Intrastat reporting after it has been added.
AP198
AH1-DROPSHIP-FL
Element: Dropship Fl
Alpha 1
This 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
Element: Fob Code
Alpha 3
The user defined Free On Board Code.
AP198
AH1-TAX-OUT-BAL
Element: Tax Out Bal
Derived
AH1-TXB-OUT-BAL
Element: Txb Out Bal
Derived
Derived field to show difference between header taxable input and total taxable amount from distributions.
AH1-PMT-OUT-BAL
Element: Pmt Out Bal
Derived
AH1-DIST-OUT-BAL
Element: Dist Out Bal
Derived
AH1-OUT-BAL-FLAG
Element: Out Bal Flag
Derived
AH1-INV-STATUS
Element: Inv Status
Derived
AH1-NET-PAYABLE
Element: Net Payable
Derived
AH1-REV-SIGN-AMT
Element: Rev Sign Amt
Derived
AH1-TYPE-SHORT-NME
Element: Type Short Nme
Derived
AH1-PO-RELEASE-3
Element: Po Release 3
Derived
The PO release number converted to a three-character field for purposes of display and printing the shorter field.
AH1-JBK-SEQ-NBR
Element: Jbk Seq Nbr
Numeric 10
The 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
Element: Diverse Code
Alpha 5
Diversity Code for Account Payable Vendors
AP115 AP198
AH1-FLEX-FLAG
Element: Flex Flag
Alpha 1
AP198
AH1-RULE-GROUP
Element: Rule Group
Alpha 10
AP198
AH1-FLOAT-DAYS
Element: Float Days
Numeric 3
AP198
AH1-MTCH-PREPAY-FL
Element: Mtch Prepay Fl
Alpha 1
AP198
AH1-MTCH-PREPAY-MT
Element: Mtch Prepay Mt
Numeric 1
AP198
AH1-PREPAY-DATE
Element: Prepay Date
Numeric 8 (yyyymmdd)
AP198
AH1-COCO-FL
Element: Coco Fl
Numeric 1
This 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
Element: Intl Amt
Signed 18.2
AP198
AH1-HASH-QTY
Element: Hash Qty
Signed 15.4
AP198
AH1-XREF-VENDOR
Element: 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
Element: Mtch Err Type
Numeric 2
This 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
Element: Intl Amt
Signed 18.2
AP198
AH1-DISC-POINT
Element: Disc Point
Numeric 1
AP198
AH1-BUYER
Element: Buyer
Alpha 3
AH1-FINAL-DST-FLAG
Element: Final Dst Flag
Alpha 1
AH1-PRPY-DISC-CODE
Element: Prpy Disc Code
Alpha 10
AH1-PRPY-REF-NBR
Element: Prpy Ref Nbr
Alpha 22
AH1-PRPY-RTL-AMT
Element: Intl Amt
Signed 18.2
AH1-PRPY-AMT
Element: Intl Amt
Signed 18.2
AH1-PRPY-AOC-AMT
Element: Intl Amt
Signed 18.2
AH1-PRPY-TAX-AMT
Element: Intl Amt
Signed 18.2
AH1-PRPY-SERV-AMT
Element: Intl Amt
Signed 18.2
AH1-TAX-FLAG
Element: Tax Flag
Alpha 1
AH1-STATEMENT
Element: Invoice
Alpha 22
Used to identify the invoice.
AH1-MTCH-PROC-TYPE
Element: 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
Element: Accr Code
Alpha 4
AP198
AH1-RET-TRAN-AMT
Element: Intl Amt
Signed 18.2
AP198
AH1-RET-BASE-AMT
Element: Intl Amt
Signed 18.2
AP198
AH1-RET-TRAN-PMT
Element: Intl Amt
Signed 18.2
AP198
AH1-RET-BASE-PMT
Element: Intl Amt
Signed 18.2
AP198
AH1-CONTRACT-GROUP
Element: Enterprise Grp
Alpha 4
AP198
AH1-CM-CONTRACT
Element: Cm Contract
Numeric 15
AP198
AH1-REBATE-TYPE
Element: Rebate Type
Alpha 25
AP198
AH1-REBATE-DUE-DTE
Element: Date
Numeric 8 (yyyymmdd)
AP198
AH1-TAX-TYPE
Element: Tax Type
Alpha 1

I = Invoiced
A = Accrued


APAPIHIST FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
AH1SET1 COMPANY
VENDOR
INVOICE
SUFFIX
CANCEL-SEQ
...
AP00.4 AP01.1
AP115 AP125
AP126 AP131
AP136 AP180
AP181 AP190
AP197 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.6 AP20.7
AP21.1 AP212
AP23.1 AP245
AP25.1 AP25.2
AP255 AP26.1
AP27.1 AP270
AP271 AP275
AH1SET10 COMPANY
RECON-DATE
ACCR-CODE
INV-CURRENCY
VENDOR
INVOICE
SUFFIX
CANCEL-SEQ
REC-STATUS
KeyChange
AP136
AH1SET11 COMPANY
VENDOR
MATCH-REF-NBR
OBJ-ID
KeyChange, Subset
WhereMATCH-REF-NBR !=Spaces
AH1SET12 COMPANY
CBPRINT-FL
VENDOR
INVOICE-DTE
INVOICE
SUFFIX
CANCEL-SEQ
Subset
WhereINVOICE-TYPE ="C"
AP131
AH1SET13 COMPANY
VENDOR
MATCH-OBJ-ID
INVOICE
SUFFIX
CANCEL-SEQ
KeyChange
AP131 AP136
AH1SET3 REC-STATUS
COMPANY
BATCH-NUM
AUTH-CODE
OPERATOR
CREATE-DATE
CREATION-TIME
VENDOR
INVOICE
SUFFIX
CANCEL-SEQ
KeyChange
AP300
AH1SET4 COMPANY
VOUCHER-NBR
REC-STATUS
VENDOR
INVOICE
SUFFIX
CANCEL-SEQ
KeyChange
AP00.4 AP520
AP96.2
AH1SET5 VENDOR-GROUP
VENDOR
INVOICE
SUFFIX
CANCEL-SEQ
COMPANY
KeyChange
...
AC160 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
AM500 AM51.1
AM551 AM97.1
AP03.3 AP10.1
AP110 AP115
AP125 AP126
AP131 AP150
AP20.1 AP20.2
AP20.3 AP20.4
AH1SET6 COMPANY
VENDOR
INVOICE-DTE
INVOICE
SUFFIX
CANCEL-SEQ
KeyChange
AP251 AP300
AH1SET9 COMPANY
VENDOR
PO-NUMBER
PO-RELEASE
PO-CODE
LOCATION
INVOICE
SUFFIX
CANCEL-SEQ
KeyChange
AP96.3


APAPIHIST FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Apcompany APCOMPANY Required
AH1-COMPANY->CPY-COMPANY
Apinccode APINCCODE Not Required
AH1-INCOME-CODE->TYP-INCOME-CODE
Appayvenmast APVENMAST Required
CPY-VENDOR-GROUP->VEN-VENDOR-GROUP
AH1-PAY-VENDOR->VEN-VENDOR
Approclev APPROCLEV Required
AH1-COMPANY->APR-COMPANY
AH1-PROC-LEVEL->APR-PROC-LEVEL
Apvenlocpurch APVENLOC Required
When AH1-PURCH-FR-LOC !=Spaces
AH1-VENDOR-GROUP->VLO-VENDOR-GROUP
AH1-VENDOR->VLO-VENDOR
AH1-PURCH-FR-LOC->VLO-LOCATION-CODE
Apvenlocremit APVENLOC Required
When AH1-REMIT-TO-CODE !=Spaces
AH1-VENDOR-GROUP->VLO-VENDOR-GROUP
AH1-PAY-VENDOR->VLO-VENDOR
AH1-REMIT-TO-CODE->VLO-LOCATION-CODE
Apvenmast APVENMAST Required
CPY-VENDOR-GROUP->VEN-VENDOR-GROUP
AH1-VENDOR->VEN-VENDOR
Eeadvance A EEADVANCE Required
When AH1-INVOICE-TYPE ="A"
AH1-COMPANY->EEA-COMPANY
AH1-VENDOR->EEA-VENDOR
AH1-INVOICE->EEA-ADVANCE-NBR
Eeadvance M EEADVANCE Required
When AH1-INVOICE-TYPE ="M"
AH1-COMPANY->EEA-COMPANY
AH1-VENDOR->EEA-VENDOR
AH1-INVOICE->EEA-ADVANCE-NBR
Eeexpense EEEXPENSE Required
When AH1-INVOICE-TYPE ="E"
AH1-COMPANY->EXP-COMPANY
AH1-VENDOR->EXP-VENDOR
AH1-INVOICE->EXP-EXPENSE-NBR
Invusrfld APISRHIST Not Required
AH1-OBJ-ID->AH9-OBJ-ID
Reasoncd MAREASONCD Not Required
AH1-REASON-CODE->MAR-REASON-CODE


APAPIHIST FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Apapdhist APAPDHIST Delete Cascades
AH1-OBJ-ID->AH2-API-OBJ-ID
  AH2-DIST-SEQ-NBR
Apapphist APAPPHIST Delete 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
Apdistpay APDISTPAY
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
Maaoihist MAAOIHIST Delete 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
Mamaahist MAMAAHIST
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 2 MAMAAHIST
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
Mamadhist MAMADHIST
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 2 MAMADHIST
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 Trans APAPIHIST
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 Ref PORECEIVE
AH1-COMPANY->POR-COMPANY
AH1-VENDOR->POR-VENDOR
AH1-MATCH-REF-NBR->POR-MATCH-REF-NBR
  POR-REC-NUMBER
Porecline PORECLINE
AH1-COMPANY->PRL-COMPANY
AH1-MATCH-OBJ-ID->PRL-MATCH-OBJ-ID
  PRL-MATCH-SEQ-NBR
  PRL-REC-NUMBER
  PRL-LINE-NBR


File created: Thu Jun 09 11:07:10 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.