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.