Vendor Invoice History
REFERENCED BY
AP115 | AP136 | AP180 | AP181 | AP190 | AP198 |
AP232 | AP28.1 | AP28.2 | AP300 | AP305 | AP45.1 |
API1.1 | MA540 |
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. |
|
||||
AH1-VENDOR Element: Vendor | Alpha 9 (Right Justified) The vendor's identification code. |
|
||||
AH1-INVOICE Element: Invoice | Alpha 22 Used to identify the invoice. |
|
||||
AH1-SUFFIX Element: Suffix | Numeric 3 This is the suffix for the invoice. |
|
||||
AH1-CANCEL-SEQ Element: Seq Nbr | Numeric 4 An automatically assigned sequence number. |
|
||||
AH1-CANCEL-DATE Element: Cancel Date | Numeric 8 (yyyymmdd) The cancellation date. |
|
||||
AH1-BATCH-NUM Element: Batch Nbr | Numeric 6 This identifies the batch the entered invoices, debit memos, and credit memos are a part of. |
|
||||
AH1-BATCH-DATE Element: Batch Date | Numeric 8 (yyyymmdd) |
|
||||
AH1-VOUCHER-NBR Element: Voucher Nbr | Alpha 10 |
|
||||
AH1-AUTH-CODE Element: Auth Code | Alpha 3 A user-defined code representing a person or department responsible for approving a registered invoice. |
|
||||
AH1-PROC-LEVEL Element: Process Level | Alpha 5 This field contains the process level, which is the reporting hierarchy below company. |
|
||||
AH1-ACCR-CODE Element: Accr Code | Alpha 4 A user-defined code representing a general ledger accrual account. |
|
||||
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. |
|
||||
AH1-INV-CURRENCY Element: To Base Curr | Alpha 5 |
|
||||
AH1-PAY-CURRENCY Element: To Base Curr | Alpha 5 |
|
||||
AH1-INVOICE-DTE Element: Invoice Dte | Numeric 8 (yyyymmdd) |
|
||||
AH1-PURCH-FR-LOC Element: Purch Fr Loc | Alpha 4 The vendor's purchase from location. |
|
||||
AH1-PO-NUMBER Element: Po Number | Alpha 14 (Right Justified) This field contains the number representing the purchase order. |
|
||||
AH1-PO-RELEASE Element: Po Release | Numeric 4 Used to identify a purchase order release (created from a Blanket or Standing order). |
|
||||
AH1-PO-CODE Element: Po Code | Alpha 4 This is the purchase order code. |
|
||||
AH1-DESCRIPTION Element: Description | Alpha 30 (Lower Case) This field displays the description. |
|
||||
AH1-BASE-INV-AMT Element: Intl Amt | Signed 18.2 |
|
||||
AH1-BASE-ACT-AMT Element: Intl Amt | Signed 18.2 |
|
||||
AH1-BASE-ND Element: Base Nd | Numeric 1 The number of decimal positions defined for the company base currency. |
|
||||
AH1-TRAN-INV-AMT Element: Intl Amt | Signed 18.2 |
|
||||
AH1-TRAN-ALOW-AMT Element: Intl Amt | Signed 18.2 |
|
||||
AH1-TRAN-TXBL-AMT Element: Intl Amt | Signed 18.2 |
|
||||
AH1-TRAN-TOT-TXBL Element: Intl Amt | Signed 18.2 |
|
||||
AH1-TRAN-ND Element: Acct Nd | Numeric 1 The number of decimals assigned to a particular account as determined by the account currency. |
|
||||
AH1-TRAN-TAX-AMT Element: Intl Amt | Signed 18.2 |
|
||||
AH1-BASE-DISC-AMT Element: Intl Amt | Signed 18.2 |
|
||||
AH1-TRAN-DISC-AMT Element: Intl Amt | Signed 18.2 |
|
||||
AH1-BASE-TOT-PMT Element: Intl Amt | Signed 18.2 |
|
||||
AH1-TRAN-TOT-PMT Element: Intl Amt | Signed 18.2 |
|
||||
AH1-BASE-TOT-DIST Element: Intl Amt | Signed 18.2 |
|
||||
AH1-TRAN-TOT-DIST Element: Intl Amt | Signed 18.2 |
|
||||
AH1-TRAN-TOT-TAX Element: Intl Amt | Signed 18.2 |
|
||||
AH1-TRAN-PAID-AMT Element: Intl Amt | Signed 18.2 |
|
||||
AH1-ORIG-CNV-RATE Element: Acct Rate | Signed 14.7 |
|
||||
AH1-ANTICIPATION Element: Anticipation | Alpha 1 The anticipation flag. |
|
||||
AH1-DISCOUNT-RT Element: Discount Rt | Percent 5.3 (Percent) |
|
||||
AH1-DISC-DATE Element: Date | Numeric 8 (yyyymmdd) This field displays the system date when this was created. |
|
||||
AH1-DUE-DATE Element: Due Date | Numeric 8 (yyyymmdd) The transaction due date. |
|
||||
AH1-NBR-SPLIT-PMT Element: Nbr Of Invcs | Numeric 3 |
|
||||
AH1-SPLIT-PMT-SCH Element: Split Pmt Sch | Alpha 1 |
|
||||
AH1-NBR-RECUR-PMT Element: Nbr Of Invcs | Numeric 3 |
|
||||
AH1-RECUR-FREQ Element: Recur Freq | Alpha 1 |
|
||||
AH1-REMIT-TO-CODE Element: Remit To Code | Alpha 4 A user-defined code that represents a vendor's remittance address. |
|
||||
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. |
|
||||
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. |
|
||||
AH1-CURR-RECALC Element: All Flag | Alpha 1 |
|
||||
AH1-TAX-CODE Element: Tax Code | Alpha 10 This field contains a code representing specific tax information. This must be valid Tax Code. |
|
||||
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. |
|
||||
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. |
|
||||
AH1-REC-STATUS Element: Rec Status | Numeric 1 The record status. |
|
||||
AH1-CREATE-DATE Element: Create Date | Numeric 8 (yyyymmdd) The creation date. |
|
||||
AH1-DISTRIB-DATE Element: Date | Numeric 8 (yyyymmdd) This field displays the system date when this was created. |
|
||||
AH1-OPERATOR Element: Operator | Alpha 10 This field is used to store the login id of the person who entered the record. |
|
||||
AH1-CREATION-TIME Element: Creation Time | Numeric 6 (hhmmss) The creation time. |
|
||||
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. |
|
||||
AH1-PAY-VENDOR Element: Vendor | Alpha 9 (Right Justified) The vendor's identification code. |
|
||||
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. |
|
||||
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. |
|
||||
AH1-LAST-DIST-SEQ Element: Dist Seq Nbr | Numeric 6 A unique sequence number. |
|
||||
AH1-LAST-PMT-SEQ Element: Seq Nbr | Numeric 4 An automatically assigned sequence number. |
|
||||
AH1-DISCOUNT-CODE Element: Discount Code | Alpha 10 A user-defined code that represents a general ledger discount account. |
|
||||
AH1-INVOICE-SOURCE Element: Invoice Source | Alpha 1 Indicates the source for creation of the invoice (manual, EDI, evaluated receipts settlement). |
|
||||
AH1-INVC-REF-TYPE Element: Invc Ref Type | Alpha 2 Indicates the type of number the vendor is providing to reference the invoice. |
|
||||
AH1-APPROVED-FLAG Element: Approved Flag | Alpha 1 |
|
||||
AH1-APPRV-OPERATOR Element: Operator | Alpha 10 This field is used to store the login id of the person who entered the record. |
|
||||
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. |
|
||||
AH1-JRNL-BOOK-NBR Element: Jrnl Book Nbr | Alpha 12 The journal book assigned to the transaction. |
|
||||
AH1-TAX-POINT Element: Tax Point | Alpha 1 |
|
||||
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. |
|
||||
AH1-RECON-DATE Element: Recon Date | Numeric 8 (yyyymmdd) Represents the date the transaction cleared the bank or was voided. |
|
||||
AH1-POD-PRINTED Element: Au Flag | Numeric 1 |
|
||||
AH1-MATCH-REF-NBR Element: Match Ref Nbr | Alpha 22 |
|
||||
AH1-MATCH-FL Element: Match Fl | Alpha 1 This field determines whether a transaction is considered to be a match transaction. |
|
||||
AH1-TERMS-CD Element: Term Code | Alpha 5 A user-defined code representing a method of determining invoice due and discount dates. |
|
||||
AH1-RCPT-INV-DATE Element: Date | Numeric 8 (yyyymmdd) This field displays the system date when this was created. |
|
||||
AH1-RETAIL-AMT Element: Intl Amt | Signed 18.2 |
|
||||
AH1-MATCH-STATUS Element: Match Status | Numeric 1 |
|
||||
AH1-REASON-CODE Element: Reason Code | Alpha 4 This field contains the reason code, which indicates the cause for credit memos. |
|
||||
AH1-HANDLING-CODE Element: Handling Code | Alpha 4 |
|
||||
AH1-MATCH-AMT Element: Intl Amt | Signed 18.2 |
|
||||
AH1-AOC-ALLOW-AMT Element: Intl Amt | Signed 18.2 |
|
||||
AH1-LOCATION Element: Location | Alpha 5 This field contains a valid stocking location within the company inventory. |
|
||||
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. |
|
||||
AH1-CBPRINT-FL Element: Cbprint Fl | Alpha 1 |
|
||||
AH1-MATCH-TABLE Element: Match Table | Alpha 10 |
|
||||
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. |
|
||||
AH1-LAST-MATCH-LN Element: Orig Line | Numeric 4 |
|
||||
AH1-MATCH-LEVEL Element: Match Level | Alpha 3 |
|
||||
AH1-MATCH-DATE Element: Date | Numeric 8 (yyyymmdd) This field displays the system date when this was created. |
|
||||
AH1-PO-INV-TAX Element: Intl Amt | Signed 18.2 |
|
||||
AH1-BYPASS-MATCH Element: All Flag | Alpha 1 |
|
||||
AH1-SERVICE-FL Element: Service Fl | Alpha 1 This field indicates a transaction is a Service only transaction. |
|
||||
AH1-SERVICE-AMT Element: Intl Amt | Signed 18.2 |
|
||||
AH1-NOTC Element: Notc | Alpha 2 The Nature of Transaction code. Must be a valid code defined in IN07.1 (NOTC Maintenance). |
|
||||
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). |
|
||||
AH1-SHIP-VIA Element: Ship Via | Alpha 12 (Lower Case) |
|
||||
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) |
|
||||
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. |
|
||||
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. |
|
||||
AH1-FOB-CODE Element: Fob Code | Alpha 3 The user defined Free On Board Code. |
|
||||
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). |
|
||||
AH1-DIVERSE-CODE Element: Diverse Code | Alpha 5 Diversity Code for Account Payable Vendors |
|
||||
AH1-FLEX-FLAG Element: Flex Flag | Alpha 1 |
|
||||
AH1-RULE-GROUP Element: Rule Group | Alpha 10 |
|
||||
AH1-FLOAT-DAYS Element: Float Days | Numeric 3 |
|
||||
AH1-MTCH-PREPAY-FL Element: Mtch Prepay Fl | Alpha 1 |
|
||||
AH1-MTCH-PREPAY-MT Element: Mtch Prepay Mt | Numeric 1 |
|
||||
AH1-PREPAY-DATE Element: Prepay Date | Numeric 8 (yyyymmdd) |
|
||||
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) |
|
||||
AH1-MATCH-AOC Element: Intl Amt | Signed 18.2 |
|
||||
AH1-HASH-QTY Element: Hash Qty | Signed 15.4 |
|
||||
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. |
|
||||
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 |
|
||||
AH1-BT-AMT Element: Intl Amt | Signed 18.2 |
|
||||
AH1-DISC-POINT Element: Disc Point | Numeric 1 |
|
||||
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 |
|
||||
AH1-RET-ACCR-CODE Element: Accr Code | Alpha 4 |
|
||||
AH1-RET-TRAN-AMT Element: Intl Amt | Signed 18.2 |
|
||||
AH1-RET-BASE-AMT Element: Intl Amt | Signed 18.2 |
|
||||
AH1-RET-TRAN-PMT Element: Intl Amt | Signed 18.2 |
|
||||
AH1-RET-BASE-PMT Element: Intl Amt | Signed 18.2 |
|
||||
AH1-CONTRACT-GROUP Element: Enterprise Grp | Alpha 4 |
|
||||
AH1-CM-CONTRACT Element: Cm Contract | Numeric 15 |
|
||||
AH1-REBATE-TYPE Element: Rebate Type | Alpha 25 |
|
||||
AH1-REBATE-DUE-DTE Element: Date | Numeric 8 (yyyymmdd) |
|
||||
AH1-TAX-TYPE Element: Tax Type | Alpha 1 I = Invoiced A = Accrued |
|
||||
AH1-SEC-WITHHOLD Element: Sec Withhold | Alpha 1 Y = Yes N = No |
|
||||
AH1-FOR-ECON-CODE Element: Code | Alpha 10 |
|
||||
AH1-REFERENCE-NO Element: Upn2 Nbr | Alpha 25 (Right Justified) |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
AH1SET1 |
COMPANY VENDOR INVOICE SUFFIX CANCEL-SEQ |
|
| ||||||||||||||||||||||||||||||||||||
AH1SET10 |
COMPANY RECON-DATE ACCR-CODE INV-CURRENCY VENDOR INVOICE SUFFIX CANCEL-SEQ REC-STATUS |
|
| ||||||||||||||||||||||||||||||||||||
AH1SET11 |
COMPANY VENDOR MATCH-REF-NBR OBJ-ID |
|
|||||||||||||||||||||||||||||||||||||
AH1SET12 |
COMPANY CBPRINT-FL VENDOR INVOICE-DTE INVOICE SUFFIX CANCEL-SEQ |
|
| ||||||||||||||||||||||||||||||||||||
AH1SET13 |
COMPANY VENDOR MATCH-OBJ-ID INVOICE SUFFIX CANCEL-SEQ |
|
| ||||||||||||||||||||||||||||||||||||
AH1SET3 |
REC-STATUS COMPANY BATCH-NUM AUTH-CODE OPERATOR CREATE-DATE CREATION-TIME VENDOR INVOICE SUFFIX CANCEL-SEQ |
|
| ||||||||||||||||||||||||||||||||||||
AH1SET4 |
COMPANY VOUCHER-NBR REC-STATUS VENDOR INVOICE SUFFIX CANCEL-SEQ |
|
| ||||||||||||||||||||||||||||||||||||
AH1SET5 |
VENDOR-GROUP VENDOR INVOICE SUFFIX CANCEL-SEQ COMPANY |
|
|||||||||||||||||||||||||||||||||||||
AH1SET6 |
COMPANY VENDOR INVOICE-DTE INVOICE SUFFIX CANCEL-SEQ |
|
| ||||||||||||||||||||||||||||||||||||
AH1SET9 |
COMPANY VENDOR PO-NUMBER PO-RELEASE PO-CODE LOCATION INVOICE SUFFIX CANCEL-SEQ |
|
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Apcompany | APCOMPANY |
Required
| |||||||||||||||
Apinccode | APINCCODE |
Not Required
| |||||||||||||||
Appayvenmast | APVENMAST |
Required
| |||||||||||||||
Approclev | APPROCLEV |
Required
| |||||||||||||||
Apvenlocpurch | APVENLOC |
Required
| |||||||||||||||
Apvenlocremit | APVENLOC |
Required
| |||||||||||||||
Apvenmast | APVENMAST |
Required
| |||||||||||||||
Eeadvance A | EEADVANCE |
Required
| |||||||||||||||
Eeadvance M | EEADVANCE |
Required
| |||||||||||||||
Eeexpense | EEEXPENSE |
Required
| |||||||||||||||
Invusrfld | APISRHIST |
Not Required
| |||||||||||||||
Reasoncd | MAREASONCD |
Not Required
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Apapdhist | APAPDHIST |
Delete Cascades
| ||||||||||||||||||||||||||||||
Apapphist | APAPPHIST |
Delete Cascades
| ||||||||||||||||||||||||||||||
Apdistpay | APDISTPAY |
| ||||||||||||||||||||||||||||||
Maaoihist | MAAOIHIST |
Delete Restricted
| ||||||||||||||||||||||||||||||
Mamaahist | MAMAAHIST |
| ||||||||||||||||||||||||||||||
Mamaahist 2 | MAMAAHIST |
| ||||||||||||||||||||||||||||||
Mamadhist | MAMADHIST |
| ||||||||||||||||||||||||||||||
Mamadhist 2 | MAMADHIST |
| ||||||||||||||||||||||||||||||
Match Trans | APAPIHIST |
| ||||||||||||||||||||||||||||||
Por Match Ref | PORECEIVE |
| ||||||||||||||||||||||||||||||
Porecline | PORECLINE |
|
All trademarks and registered trademarks are the property of their
respective owners.