APAPIHIST FILE
REFERENCED BY
POA3.1 AP00.4 AP00.5 AP01.1 AP125 AP126
AP131 AP20.1 AP20.2 AP20.3 AP20.4 AP20.5
AP20.6 AP20.7 AP212 AP23.1 AP245 AP25.1
AP25.2 AP255 AP26.1 AP27.1 AP270 AP275
AP32.1 AP520 AP91.1 AP93.2 AP93.1 AP96.1
AP96.2 AP96.3 APH1.1 API1.1 API2.1 AR48.3
EE20.1 EE20.2 EE20.4 IC28.1 MA180 MA41.2
MA43.2 MA43.9 MA530 MA531 MA540 MA60.2
MA60.3 MA60.5 MA61.1 MA66.3 MA67.1 MA67.2
MA70.1 MAI1.1 PO100 PO101 PO122 PO131
PO20.1 PO21.2 PO21.3 PO21.4 PO21.5 PO22.1
PO23.1 PO29.1 PO30.1 PO30.2 PO30.3 PO300
PO31.1 PO31.2 PO32.2 PO33.1 PO34.1 PO35.1
PO38.1 PO39.1 PO39.2 PO44.1 PO50.1 PO52.1
PO520 POI3.1 POIE.1 POII.1 POIJ.1 RQ10.1
RQ10.2 WH20.2 WH20.7 AP10.1 AP251
UPDATED BY
AP115 AP180 AP181 AP190 AP198 AP260
AP28.1 AP28.2 AP300 AP305 AP45.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
AH1-COMPANY Numeric 4 AP198 AP300
Company The company number represents an
established company and is entered on
all function codes.
AH1-VENDOR Alpha 9 (Right Justified) AP115 AP198
Vendor ID The vendor's identification code. AP300
AH1-INVOICE Alpha 22 AP115 AP198
Invoice Number Used to identify the invoice. AP300
AH1-SUFFIX Numeric 3 AP198 AP300
Invoice Suffix This is the suffix for the invoice.
AH1-CANCEL-SEQ Numeric 4 AP198 AP300
Cancel Sequence The sequence number assigned upon a
cancellation of a distributed invoice.
The first sequence assigned is 9999.
AH1-CANCEL-DATE Numeric 8 (yyyymmdd) AP198
Cancel Date The cancellation date.
AH1-BATCH-NUM Numeric 6 AP198
Batch Number This identifies the batch the entered
invoices, debit memos, and credit memos
are a part of.
AH1-BATCH-DATE Numeric 8 (yyyymmdd) AP198
Batch Date
AH1-VOUCHER-NBR Alpha 10 AP198
Voucher
AH1-AUTH-CODE Alpha 3 AP198
Authority Code A user-defined code representing a
person or department responsible for
approving a registered invoice.
AH1-PROC-LEVEL Alpha 5 AP198
Process Level The process level represents a
reporting level below company.
AH1-ACCR-CODE Alpha 4 AP198
Accrual Code A user-defined code representing a
general ledger accrual account.
AH1-INVOICE-TYPE Alpha 1 AP198
Invoice Type
AH1-INV-CURRENCY Alpha 5 AP198
Invoice Currency
AH1-PAY-CURRENCY Alpha 5 AP198
Payment Currency The currency the invoices were entered
in.
AH1-INVOICE-DTE Numeric 8 (yyyymmdd) AP198
Invoice Date
AH1-PURCH-FR-LOC Alpha 4 AP115 AP198
Purchase From The vendor's purchase from location.
Location Code
AH1-PO-NUMBER Alpha 14 (Right Justified) AP198
PO Number This field contains the number
representing the purchase order.
AH1-PO-RELEASE Numeric 4 AP198
PO Release Number Used to identify a purchase order
release (created from a Blanket or
Standing order).
AH1-PO-CODE Alpha 4 AP198
Po Code This is the purchase order code.
AH1-DESCRIPTION Alpha 30 (Lower Case) AP198
Description This field displays the description.
AH1-BASE-INV-AMT Signed 15.2 AP198
Base Invoice Amount
AH1-BASE-ACT-AMT Signed 15.2 AP198
Base Amount
AH1-BASE-ND Numeric 1 AP198
Base Number Of The number of decimal positions defined
Decimals for the company base currency.
AH1-TRAN-INV-AMT Signed 15.2 AP198
Invoice Amount
AH1-TRAN-ALOW-AMT Signed 15.2 AP198
Allowable Amount
AH1-TRAN-TXBL-AMT Signed 15.2 AP198
Taxable Amount
AH1-TRAN-ND Numeric 1 AP198
Transaction Number The number of decimal positions defined
of Decimals for the transaction currency.
AH1-TRAN-TAX-AMT Signed 15.2 AP198
Tax Amount The amount to be posted to the general
ledger for the tax distribution. The
transaction amount less the tax amount
will be posted to the selected general
ledger account.
AH1-BASE-DISC-AMT Signed 15.2 AP198
Base Discount Amount
AH1-TRAN-DISC-AMT Signed 15.2 AP198
Discount Amount
AH1-BASE-TOT-PMT Signed 15.2 AP198
Base Total Payment
AH1-TRAN-TOT-PMT Signed 15.2 AP198
Total Payment Amount
AH1-BASE-TOT-DIST Signed 15.2 AP198
Base Total
Distribution
AH1-TRAN-TOT-DIST Signed 15.2 AP198
Total Distribution
Amount
AH1-TRAN-TOT-TAX Signed 15.2 AP198
Total Tax Amount
AH1-TRAN-PAID-AMT Signed 15.2 AP198
Paid Amount
AH1-ORIG-CNV-RATE Signed 12.6 AP198
Exchange Rate Represents the currency exchange rate
the transaction was created with.
AH1-ANTICIPATION Alpha 1 AP198
Anticipation Flag The anticipation flag.
AH1-DISCOUNT-RT Percent 5.3 (Percent) AP198
Discount Rate
AH1-DISC-DATE Numeric 8 (yyyymmdd) AP198
Discount Date
AH1-DUE-DATE Numeric 8 (yyyymmdd) AP198
Due Date The transaction due date.
AH1-NBR-SPLIT-PMT Numeric 3 AP198
Number of Split
Payments
AH1-SPLIT-PMT-SCH Alpha 1 AP198
Split Payment
Schedule
AH1-NBR-RECUR-PMT Numeric 3 AP198
Number of
Recurrences
AH1-RECUR-FREQ Alpha 1 AP198
Recurring Frequency
AH1-REMIT-TO-CODE Alpha 4 AP115 AP198
Remit To Location A user-defined code that represents a
Code vendor's remittance address.
AH1-CASH-CODE Alpha 4 AP115 AP198
Cash Code 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.
AH1-BANK-INST-CODE Alpha 3 AP115 AP198
Transaction Code A transaction code represents a type of
cash payment, bill of exchange payment,
or bank service transaction.
AH1-CURR-RECALC Alpha 1 AP198
Currency
Recalculation Flag
AH1-TAX-CODE Alpha 10 AP198
Tax Code This field contains a code representing
specific tax information. This must be
valid Tax Code.
AH1-INCOME-CODE Alpha 4 AP198
Income Code A user-defined code that represents a
type of income withholding. Used to
track reportable income for reporting or
withholding.
AH1-DIST-CODE Alpha 9 AP198
Distribution Code 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.
AH1-REC-STATUS Numeric 1 AP198
Record Status The record status.
AH1-CREATE-DATE Numeric 8 (yyyymmdd) AP198
Creation Date The creation date.
AH1-DISTRIB-DATE Numeric 8 (yyyymmdd) AP198
Distribution Date The date used for posting the
transactions to the general ledger.
AH1-OPERATOR Alpha 10 AP198
Operator Code This field is used to store the login
id of the person who entered the record.
AH1-CREATION-TIME Numeric 6 (hhmmss) AP198
Creation Time The creation time.
AH1-VENDOR-GROUP Alpha 4 AP198
Vendor Group A vendor group represents a group of
vendors that can be shared by one or
more companies.
AH1-PAY-VENDOR Alpha 9 (Right Justified) AP115 AP198
Paid Vendor
AH1-PAY-GROUP Alpha 4 AP198
Pay Group 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.
AH1-INVOICE-GROUP Alpha 4 AP115 AP198
Invoice Group 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.
AH1-LAST-DIST-SEQ Numeric 4 AP198
Last Distribution Used by the system to track the last
Sequence Nbr payment record number used for the
invoice.
AH1-LAST-PMT-SEQ Numeric 4 AP198
Last Payment
Sequence
AH1-DISCOUNT-CODE Alpha 10 AP198
Discount Code A user-defined code that represents a
general ledger discount account.
AH1-INVOICE-SOURCE Alpha 1 AP198
Invoice Source Indicates the source for creation of the
invoice (manual, EDI, evaluated receipts
settlement).
AH1-INVC-REF-TYPE Alpha 2 AP198
Invoice Reference Indicates the type of number the vendor
Type is providing to reference the invoice.
AH1-APPROVED-FLAG Alpha 1 AP198
Approved
AH1-APPRV-OPERATOR Alpha 10 AP198
Approval Operator
AH1-RETURN-NUMBER Numeric 10 AP198
Return Number This is the number assigned to the
return for purposes of referencing the
return internally and with the customer
or vendor.
AH1-JRNL-BOOK-NBR Alpha 12 AP198
Journal Book The journal book assigned to the
transaction.
AH1-TAX-POINT Alpha 1 AP198
Tax Point
AH1-OBJ-ID Numeric 12 AP198
Object This is the object identifier. It is
Identification 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.
AH1-RECON-DATE Numeric 8 (yyyymmdd) AP198 AP260
Reconciliation or Represents the date the transaction
Void Date cleared the bank or was voided.
AH1-POD-PRINTED Numeric 1 AP198
Pod Printed
AH1-MATCH-REF-NBR Alpha 22 AP198
Match Ref Nbr
AH1-MATCH-FL Alpha 1 AP198
Match Fl This field determines whether a
transaction is considered to be a match
transaction.
AH1-TERMS-CD Alpha 5 AP198
Terms Code
AH1-RCPT-INV-DATE Numeric 8 (yyyymmdd) AP198
Rcpt Inv Date
AH1-RETAIL-AMT Signed 15.2 AP198
Retail Amt
AH1-MATCH-STATUS Numeric 1 AP198
Match Status
AH1-REASON-CODE Alpha 4 AP198
Reason Code This field contains the reason code,
which indicates the cause for credit
memos.
AH1-HANDLING-CODE Alpha 4 AP198
Handling Code
AH1-MATCH-AMT Signed 15.2 AP198
Match Amt
AH1-AOC-ALLOW-AMT Signed 15.2 AP198
Aoc Allow Amt
AH1-LOCATION Alpha 5 AP198
Location Code This field contains a valid stocking
location within the company inventory.
AH1-MATCH-OBJ-ID Numeric 12 AP198
Match Obj Id
AH1-CBPRINT-FL Alpha 1 AP198
Cbprint Fl
AH1-MATCH-TABLE Alpha 10 AP198
Match Table
AH1-TAX-CODE-CNTL Alpha 1 AP198
Tax Adjustment Code 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.
AH1-LAST-MATCH-LN Numeric 4 AP198
Last Match Ln
AH1-MATCH-LEVEL Alpha 3 AP198
Match Level
AH1-MATCH-DATE Numeric 8 (yyyymmdd) AP198
Match Date
AH1-PO-INV-TAX Signed 15.2 AP198
Po Inv Tax
AH1-BYPASS-MATCH Alpha 1 AP198
Bypass Match
AH1-SERVICE-FL Alpha 1 AP198
Service Fl This field indicates a transaction is a
Service only transaction.
AH1-SERVICE-AMT Signed 15.2 AP198
Service Amt
AH1-NOTC Alpha 2 AP198
Notc The Nature of Transaction code. Must
be a valid code defined in IN07.1 (NOTC
Maintenance).
AH1-STAT-PROC Alpha 6 AP198
Stat Proc The statistical procedure code applied
to the data. The code must be defined
in IN06.1. (Statistical Procedure
Maintenance).
AH1-SHIP-VIA Alpha 12 (Lower Case) AP198
Ship Via Description
AH1-UNLOADING-PORT Alpha 5 AP198
Unloading Port The prot where the goods are unloaded if
required. Must be defined in IN04.1
(Port Maintenance)
AH1-INTRASTAT-NBR Numeric 12 AP198
Intrastat Nbr The number assigned by the Intrastat
system to a transaction that involves
Intrastat reporting after it has been
added.
AH1-DROPSHIP-FL Alpha 1 AP198
Dropship Flag This flag indicates whether goods being
shipped by the vendor directly to a non
standard location need to have the
receiving process performed.
AH1-FOB-CODE Alpha 3 AP198
Shipping Term Code The user defined Free On Board Code.
AH1-TAX-OUT-BAL Derived
Tax Out of Balance
Amount
AH1-PMT-OUT-BAL Derived
Payment Out Of
Balance Amount
AH1-DIST-OUT-BAL Derived
Distrib. Out Of
Balance Amount
AH1-OUT-BAL-FLAG Derived
Out of Balance
Indicator
AH1-INV-STATUS Derived
Invoice Status
AH1-NET-PAYABLE Derived
Net Payable
AH1-REV-SIGN-AMT Derived
Rev Sign Amt
AH1-TYPE-SHORT-NME Derived
Type Short Nme
AH1-PO-RELEASE-3 Derived
Po Release 3 The PO release number converted to a
three-character field for purposes of
display and printing the shorter field.
AH1-JBK-SEQ-NBR Numeric 10 AP198
Journal Book The journal book sequence number
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).
APAPIHIST FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
AH1SET1 COMPANY AP00.4 AP00.5
VENDOR AP01.1 AP115
INVOICE AP125 AP126
SUFFIX AP131 AP180
CANCEL-SEQ AP181 AP190
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.6
AP20.7 AP212
AP23.1 AP245
AP25.1 AP25.2
AP255 AP26.1
AP260 AP27.1
AP270 AP275
AP28.1 AP28.2
...
AH1SET10 COMPANY KeyChange AP260
RECON-DATE
VENDOR
INVOICE
SUFFIX
CANCEL-SEQ
AH1SET11 COMPANY KeyChange, Subset
VENDOR Where MATCH-REF-NBR != Spaces
MATCH-REF-NBR
OBJ-ID
AH1SET12 COMPANY Subset AP131
CBPRINT-FL Where INVOICE-TYPE = "C"
VENDOR
INVOICE-DTE
INVOICE
SUFFIX
CANCEL-SEQ
AH1SET13 COMPANY KeyChange AP131
VENDOR
MATCH-OBJ-ID
INVOICE
SUFFIX
CANCEL-SEQ
AH1SET3 REC-STATUS KeyChange AP300
COMPANY
BATCH-NUM
AUTH-CODE
OPERATOR
CREATE-DATE
CREATION-TIME
VENDOR
INVOICE
SUFFIX
CANCEL-SEQ
AH1SET4 COMPANY KeyChange AP00.4 AP520
VOUCHER-NBR AP96.2
REC-STATUS
VENDOR
INVOICE
SUFFIX
CANCEL-SEQ
AH1SET5 VENDOR-GROUP KeyChange AP10.1 AP115
VENDOR AP251 AP91.1
INVOICE AP93.1
SUFFIX
CANCEL-SEQ
COMPANY
AH1SET6 COMPANY KeyChange AP251 AP300
VENDOR
INVOICE-DTE
INVOICE
SUFFIX
CANCEL-SEQ
AH1SET8 COMPANY Subset
DUE-DATE Where((MATCH-STATUS = Zeroes )
VENDOR Or (MATCH-STATUS = 1 ))
INVOICE And (MATCH-FL = "Y" )
SUFFIX And ((REC-STATUS = Zeroes )
CANCEL-SEQ Or (REC-STATUS = 1 ))
AH1SET9 COMPANY KeyChange AP96.3
VENDOR
PO-NUMBER
PO-RELEASE
PO-CODE
LOCATION
INVOICE
SUFFIX
CANCEL-SEQ
APAPIHIST FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME 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 RELATED
NAME 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
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
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
|
