|
|
APAPIHIST FILE
REFERENCED BY
POA3.1 AP00.4 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 AP30.4
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
MA41.7 MA43.1 MA43.2 MA43.3 MA43.9 MA530
MA531 MA540 MA60.2 MA60.3 MA60.5 MA61.1
MA66.2 MA66.3 MA67.1 MA67.2 MA70.1 MA75.1
MA80.1 MAI1.1 PO100 PO101 PO122 PO131
PO20.1 PO21.1 PO21.2 PO21.3 PO21.4 PO21.5
PO22.1 PO23.1 PO25.1 PO25.5 PO25.6 PO25.7
PO27.2 PO29.1 PO30.1 PO30.2 PO30.3 PO300
PO31.1 PO31.2 PO32.2 PO33.1 PO34.1 PO35.1
PO36.1 PO36.2 PO38.1 PO39.1 PO39.2 PO44.1
PO50.1 PO52.1 PO520 PO536 POI3.1 POII.1
POIJ.1 RQ10.1 RQ10.2 RQ10.3 RQIE.1 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
Element: Company The company number represents an
established company and is entered on
all function codes.
AH1-VENDOR Alpha 9 (Right Justified) AP115 AP198
Element: Vendor ID The vendor's identification code. AP300
AH1-INVOICE Alpha 22 AP115 AP198
Element: Invoice NumberUsed to identify the invoice. AP300
AH1-SUFFIX Numeric 3 AP198 AP300
Element: Invoice SuffixThis is the suffix for the invoice.
AH1-CANCEL-SEQ Numeric 4 AP198 AP300
Element: Sequence Number
AH1-CANCEL-DATE Numeric 8 (yyyymmdd) AP198
Element: Date
AH1-BATCH-NUM Numeric 6 AP198
Element: Batch Number
AH1-BATCH-DATE Numeric 8 (yyyymmdd) AP198
Element: Date
AH1-VOUCHER-NBR Alpha 10 AP198
Element: Voucher
AH1-AUTH-CODE Alpha 3 AP198
Element: Authority CodeA user-defined code representing a
person or department responsible for
approving a registered invoice.
AH1-PROC-LEVEL Alpha 5 AP198
Element: Process Level
AH1-ACCR-CODE Alpha 4 AP198
Accounts Receivable
Code
AH1-INVOICE-TYPE Alpha 1 AP198
Element: Invoice Type
AH1-INV-CURRENCY Alpha 5 AP198
To Company Base
Currency
AH1-PAY-CURRENCY Alpha 5 AP198
To Company Base
Currency
AH1-INVOICE-DTE Numeric 8 (yyyymmdd) AP198
Element: 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
Element: PO Number This field contains the number
representing the purchase order.
AH1-PO-RELEASE Numeric 4 AP198
Element: PO Release NumUsed to identify a purchase order
release (created from a Blanket or
Standing order).
AH1-PO-CODE Alpha 4 AP198
Element: Po Code This is the purchase order code.
AH1-DESCRIPTION Alpha 30 (Lower Case) AP198
Element: Description This field displays the description.
AH1-BASE-INV-AMT Signed 15.2 AP198
Element: Adj Amt
AH1-BASE-ACT-AMT Signed 15.2 AP198
Element: Adj Amt
AH1-BASE-ND Numeric 1 AP198
Account Currency
Code
AH1-TRAN-INV-AMT Signed 15.2 AP198
Element: Invoice Amount
AH1-TRAN-ALOW-AMT Signed 15.2 AP198
Element: Adj Amt
AH1-TRAN-TXBL-AMT Signed 15.2 AP198
Element: Adj Amt
AH1-TRAN-TOT-TXBL Signed 15.2 AP198
Element: Total Taxable The total taxable amount for the invoice
distributions in currency of invoice.
AH1-TRAN-ND Numeric 1 AP198
Account Currency
Code
AH1-TRAN-TAX-AMT Signed 15.2 AP198
Element: Adj Amt
AH1-BASE-DISC-AMT Signed 15.2 AP198
Element: Actual Disc
AH1-TRAN-DISC-AMT Signed 15.2 AP198
Element: Actual Disc
AH1-BASE-TOT-PMT Signed 15.2 AP198
Element: Detail Total
AH1-TRAN-TOT-PMT Signed 15.2 AP198
Element: Detail Total
AH1-BASE-TOT-DIST Signed 15.2 AP198
Element: Detail Total
AH1-TRAN-TOT-DIST Signed 15.2 AP198
Element: Detail Total
AH1-TRAN-TOT-TAX Signed 15.2 AP198
Element: Detail Total
AH1-TRAN-PAID-AMT Signed 15.2 AP198
Element: Adj Amt
AH1-ORIG-CNV-RATE Signed 12.6 AP198
Element: Account Rate
AH1-ANTICIPATION Alpha 1 AP198
Element: All Flag
AH1-DISCOUNT-RT Percent 5.3 (Percent) AP198
Element: Cost Pct
AH1-DISC-DATE Numeric 8 (yyyymmdd) AP198
Element: Date
AH1-DUE-DATE Numeric 8 (yyyymmdd) AP198
Element: Date The transaction due date.
AH1-NBR-SPLIT-PMT Numeric 3 AP198
Element: Nbr Of Invcs
AH1-SPLIT-PMT-SCH Alpha 1 AP198
Split Payment
Schedule
AH1-NBR-RECUR-PMT Numeric 3 AP198
Element: Nbr Of Invcs
AH1-RECUR-FREQ Alpha 1 AP198
Element: Recurring Frequency
AH1-REMIT-TO-CODE Alpha 4 AP115 AP198
Purchase From
Location Code
AH1-CASH-CODE Alpha 4 AP115 AP198
Accounts Receivable
Code
AH1-BANK-INST-CODE Alpha 3 AP115 AP198
Element: Transaction CoA transaction code represents a type of
cash payment, bill of exchange payment,
or bank service transaction.
AH1-CURR-RECALC Alpha 1 AP198
Element: All Flag
AH1-TAX-CODE Alpha 10 AP198
Element: Tax Code This field contains a code representing
specific tax information. This must be
valid Tax Code.
AH1-INCOME-CODE Alpha 4 AP198
Accounts Receivable
Code
AH1-DIST-CODE Alpha 9 AP198
Element: Distribution CA 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
Element: Record Status The record status.
AH1-CREATE-DATE Numeric 8 (yyyymmdd) AP198
Element: Date
AH1-DISTRIB-DATE Numeric 8 (yyyymmdd) AP198
Element: Date
AH1-OPERATOR Alpha 10 AP198
Element: 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
Element: Sys Time
AH1-VENDOR-GROUP Alpha 4 AP198
Element: 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
Element: Vendor ID
AH1-PAY-GROUP Alpha 4 AP198
Element: 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
Element: 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
Element: Sequence Number
AH1-LAST-PMT-SEQ Numeric 4 AP198
Element: Sequence Number
AH1-DISCOUNT-CODE Alpha 10 AP198
Element: Discount Code A user-defined code that represents a
general ledger discount account.
AH1-INVOICE-SOURCE Alpha 1 AP198
Element: Invoice SourceIndicates 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
Element: Approved
AH1-APPRV-OPERATOR Alpha 10 AP198
Element: Operator Code
AH1-RETURN-NUMBER Numeric 10 AP198
Element: 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
Element: Journal Book The journal book assigned to the
transaction.
AH1-TAX-POINT Alpha 1 AP198
Element: 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
Element: Au Flag
AH1-MATCH-REF-NBR Alpha 22 AP198
Element: Match Ref Nbr
AH1-MATCH-FL Alpha 1 AP198
Element: Match Fl This field determines whether a
transaction is considered to be a match
transaction.
AH1-TERMS-CD Alpha 5 AP198
Element: Terms Code
AH1-RCPT-INV-DATE Numeric 8 (yyyymmdd) AP198
Element: Date
AH1-RETAIL-AMT Signed 15.2 AP198
Element: Adj Amt
AH1-MATCH-STATUS Numeric 1 AP198
Element: Match Status
AH1-REASON-CODE Alpha 4 AP198
Accounts Receivable This field contains the reason code,
Code which indicates the cause for credit
memos.
AH1-HANDLING-CODE Alpha 4 AP198
Element: Handling Code
AH1-MATCH-AMT Signed 15.2 AP198
Element: Adj Amt
AH1-AOC-ALLOW-AMT Signed 15.2 AP198
Element: Adj Amt
AH1-LOCATION Alpha 5 AP198
Element: Location Code This field contains a valid stocking
location within the company inventory.
AH1-MATCH-OBJ-ID Numeric 12 AP198
Object
Identification
AH1-CBPRINT-FL Alpha 1 AP198
Element: Cbprint Fl
AH1-MATCH-TABLE Alpha 10 AP198
Element: Match Table
AH1-TAX-CODE-CNTL Alpha 1 AP198
Element: Tax AdjustmentThis 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
Element: Original Line Number
AH1-MATCH-LEVEL Alpha 3 AP198
Element: Match Level
AH1-MATCH-DATE Numeric 8 (yyyymmdd) AP198
Element: Date
AH1-PO-INV-TAX Signed 15.2 AP198
Element: Item Tax
AH1-BYPASS-MATCH Alpha 1 AP198
Element: All Flag
AH1-SERVICE-FL Alpha 1 AP198
Element: Service Fl This field indicates a transaction is a
Service only transaction.
AH1-SERVICE-AMT Signed 15.2 AP198
Element: Adj Amt
AH1-NOTC Alpha 2 AP198
Element: Notc The Nature of Transaction code. Must
be a valid code defined in IN07.1 (NOTC
Maintenance).
AH1-STAT-PROC Alpha 6 AP198
Element: 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
Element: Ship Via Description
AH1-UNLOADING-PORT Alpha 5 AP198
Element: Unloading PortThe prot where the goods are unloaded if
required. Must be defined in IN04.1
(Port Maintenance)
AH1-INTRASTAT-NBR Numeric 12 AP198
Element: 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
Element: 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
Element: Shipping Term The user defined Free On Board Code.
AH1-TAX-OUT-BAL Derived
Tax Out of Balance
Amount
AH1-TXB-OUT-BAL Derived
Element: Txb Out Bal Derived field to show difference between
header taxable input and total taxable
amount from distributions.
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
Element: Invoice Status
AH1-NET-PAYABLE Derived
Element: Net Payable
AH1-REV-SIGN-AMT Derived
Element: Rev Sign Amt
AH1-TYPE-SHORT-NME Derived
Element: Type Short Nme
AH1-PO-RELEASE-3 Derived
Element: 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 AP01.1
VENDOR AP115 AP125
INVOICE AP126 AP131
SUFFIX AP180 AP181
CANCEL-SEQ 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 AP30.4
...
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
|
