APAPPHIST FILE
REFERENCED BY
AP260 AP245 AP270 AP93.2 AP265 AP255
UPDATED BY
AP115 AP180 AP181 AP190 AP198 AP28.1
AP28.2 AP300 AP45.1 AP305
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
AH3-COMPANY Numeric 4 AP198 AP260
Company The company number represents an
established company and is entered on
all function codes.
AH3-VENDOR Alpha 9 (Right Justified) AP115 AP198
Vendor ID The vendor's identification code. AP260
AH3-INVOICE Alpha 22 AP115 AP198
Invoice Number Used to identify the invoice. AP260
AH3-SUFFIX Numeric 3 AP198 AP260
Invoice Suffix This is the suffix for the invoice.
AH3-CANCEL-SEQ Numeric 4 AP198 AP260
Cancel Sequence The sequence number assigned upon a
cancellation of a distributed invoice.
The first sequence assigned is 9999.
AH3-SEQ-NBR Numeric 4 AP198
Sequence Number An automatically assigned sequence
number.
AH3-VOID-SEQ Numeric 4 AP198
Void Sequence
AH3-VOID-DATE Numeric 8 (yyyymmdd) AP198
Void Date
AH3-INV-CURRENCY Alpha 5 AP198
Invoice Currency
AH3-PAY-VENDOR Alpha 9 (Right Justified) AP115 AP198
Paid Vendor
AH3-REMIT-TO-CODE Alpha 4 AP115 AP198
Remit To Location A user-defined code that represents a
Code vendor's remittance address.
AH3-PAY-COMPANY Numeric 4 AP198
Pay Company
AH3-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.
AH3-DUE-DATE Numeric 8 (yyyymmdd) AP198
Due Date The transaction due date.
AH3-ENCLOSURE Alpha 1 AP198
Enclosure
AH3-HOLD-FLAG Alpha 1 AP198
On Hold Flag This field enables this entire lot to
be put on hold, not allowing any issues
or transfers to be made for this lot.
AH3-VEN-CLASS Alpha 3 AP115 AP198
Vendor Class A user-defined code representing a
subset of vendors within a vendor group.
AH3-VEN-PRIORITY Numeric 2 AP115 AP198
Vendor Priority The payment priority of a vendor, where
1 = the highest priority and 99 = the
lowest.
AH3-PROC-GRP Alpha 4 (Lower Case) AP115 AP198
Process Group A process group is an identifier used
for separating vendors into different
groups to enable concurrent processing
within the cash payment cycle.
AH3-BASE-PMT-AMT Signed 15.2 AP198
Base Payment Amount Company base currency payment amount.
AH3-BASE-ACT-AMT Signed 15.2 AP198
Base Amount
AH3-BASE-ND Numeric 1 AP198
Base Number Of The number of decimal positions defined
Decimals for the company base currency.
AH3-TRAN-PMT-AMT Signed 15.2 AP198
Payment Amount Transaction amount of invoices paid in
the currency of the invoice.
AH3-TRAN-ND Numeric 1 AP198
Transaction Number The number of decimal positions defined
of Decimals for the transaction currency.
AH3-BANK-CHK-AMT Signed 15.2 AP198
Bank Payment Amount
AH3-BANK-ND Numeric 1 AP198
Bank Currency Nbr
of Decimals
AH3-BASE-DISC-AMT Signed 15.2 AP198
Base Discount Amount
AH3-TRAN-DISC-AMT Signed 15.2 AP198
Discount Amount
AH3-BASE-CHK-AMT Signed 15.2 AP198
Base Payment Amount
AH3-TRAN-CHK-AMT Signed 15.2 AP198
Payment Amount
AH3-BASE-INC-WH Signed 15.2 AP198
Base Income Withheld
AH3-TRAN-INC-WH Signed 15.2 AP198
Income Withholding
AH3-TRAN-INC-AMT Signed 15.2 AP198
Income Amount
AH3-GAINLOS-AMT Signed 15.2 AP198
Gain/Loss Amount
AH3-UNRL-REV-DATE Numeric 8 (yyyymmdd) AP198
Last Revaluation
Date
AH3-ACT-CNV-RATE Signed 12.6 AP198
Actual Exchange Rate The currency exchange rate of the
transaction.
AH3-DSC-ACCT-UNIT Alpha 15 AP198
Discount Accounting
Unit
AH3-DSC-ACCOUNT Numeric 6 AP198
Discount Account
AH3-DSC-SUB-ACCT Numeric 4 AP198
Discount Subaccount
Number
AH3-DISCOUNT-RT Percent 5.3 (Percent) AP198
Discount Rate
AH3-DISC-DATE Numeric 8 (yyyymmdd) AP198
Discount Date
AH3-TRANS-IDENT Numeric 10 AP198
Trans Ident A unique system-generated
identification value assigned to the
transaction to make this record unique.
AH3-ACCR-CODE Alpha 4 AP198
Accrual Code A user-defined code representing a
general ledger accrual account.
AH3-PROC-LEVEL Alpha 5 AP198
Process Level The process level represents a
reporting level below company.
AH3-REC-STATUS Numeric 1 AP198
Record Status The record status.
AH3-TRANS-NBR Alpha 10 (Right Justified) AP198
Trans Nbr A unique, user-defined value used to
identify the transaction.
AH3-CHK-SUFFIX Numeric 3 AP198
Chk Suffix
AH3-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.
AH3-CHECK-DATE Numeric 8 (yyyymmdd) AP198
Payment Date The payment date.
AH3-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.
AH3-SEP-CHK-FLAG Alpha 1 AP198
Separate Payment
Flag
AH3-PAY-IMM-FLAG Alpha 1 AP198
Pay Immediately Flag
AH3-DISC-LOST-FLG Alpha 1 AP198
Discount Lost Flag
AH3-ANTICIPATION Alpha 1 AP198
Anticipation Flag The anticipation flag.
AH3-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.
AH3-VENDOR-GROUP Alpha 4 AP198
Vendor Group A vendor group represents a group of
vendors that can be shared by one or
more companies.
AH3-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.
AH3-DISCOUNT-CODE Alpha 10 AP198
Discount Code A user-defined code that represents a
general ledger discount account.
AH3-INC-ACCR-CODE Alpha 10 AP198
Income Withholding A user-defined code representing a
Code general ledger income withholding
accrual account.
AH3-RECON-STMT-NBR Numeric 12 AP198
Reconciliation The bank-assigned reconciliation
Statement statement number. Used only for cash
codes that require reconciliation
statements.
AH3-MATCH-DISC-TAK Alpha 1 AP198
Match Disc Tak
AH3-OPEN-BASE-PMT Derived
Open Base Invoice
Amount
AH3-OPEN-TRAN-PMT Derived
Open Invoice Amount
AH3-BASE-NET-PMT Derived
Base Invoice Amount
Paid
AH3-TRAN-NET-PMT Derived
Invoice Amount Paid
AH3-PMT-STATUS Derived
Pmt Status
AH3-BANK-STATUS Derived
Bank Status
AH3-NO-REINSTATE Derived
No Reinstate
AH3-PAID-DOC-DATE Derived
Paid Doc Date
AH3-DRAFT-ACCRUED Derived
Bill of Exchange
Accrued
AH3-AP-INV-DATE Derived
Ap Inv Date
AH3-AP-PO-NBR Derived
Ap Po Nbr
AH3-AP-INV-TYPE Derived
Ap Inv Type
AH3-AP-BASE-INV Derived
Ap Base Inv
AH3-AP-FORMAT-NBR Derived
Ap Format Nbr
APAPPHIST FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
AH3SET1 COMPANY AP115 AP260
VENDOR AP300 AP305
INVOICE AP45.1
SUFFIX
CANCEL-SEQ
SEQ-NBR
VOID-SEQ
AH3SET10 REC-STATUS KeyChange AP245 AP270
COMPANY
PROC-LEVEL
VENDOR
INVOICE
SUFFIX
CANCEL-SEQ
SEQ-NBR
VOID-SEQ
PAY-GROUP
AH3SET2 PAY-GROUP KeyChange AP270 AP93.2
REC-STATUS
VENDOR
INVOICE
SUFFIX
CANCEL-SEQ
SEQ-NBR
VOID-SEQ
COMPANY
AH3SET6 PAY-GROUP KeyChange, Subset AP180 AP181
BANK-INST-CODEWhere TRANS-IDENT != Zeroes AP190 AP265
TRANS-IDENT AP28.1 AP28.2
VENDOR
INVOICE
SUFFIX
CANCEL-SEQ
SEQ-NBR
VOID-SEQ
COMPANY
AH3SET8 PAY-GROUP KeyChange AP255
CASH-CODE
TRANS-NBR
BANK-INST-CODE
COMPANY
VENDOR
INVOICE
SUFFIX
CANCEL-SEQ
SEQ-NBR
VOID-SEQ
APAPPHIST FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Apapihist APAPIHIST Required
AH3-COMPANY -> AH1-COMPANY
AH3-VENDOR -> AH1-VENDOR
AH3-INVOICE -> AH1-INVOICE
AH3-SUFFIX -> AH1-SUFFIX
AH3-CANCEL-SEQ -> AH1-CANCEL-SEQ
Apcompany APCOMPANY Required
AH3-COMPANY -> CPY-COMPANY
Apdrafts APDRAFTS Not Required
AH3-BANK-INST-CODE -> APT-BANK-INST-CODE
AH3-TRANS-IDENT -> APT-TRANS-IDENT
Apvenmast APVENMAST Required
AH3-VENDOR-GROUP -> VEN-VENDOR-GROUP
AH3-VENDOR -> VEN-VENDOR
Cbbankinst CBBANKINST Required
AH3-BANK-INST-CODE -> CBI-BANK-INST-CODE
Cbcashcode CBCASHCODE Required
AH3-CASH-CODE -> CBC-CASH-CODE
Cbcashform CBCASHFORM Not Required
AH3-CASH-CODE -> CCF-CASH-CODE
AH3-BANK-INST-CODE -> CCF-BANK-INST-CODE
Cbcheck CBCHECK Required
AH3-CASH-CODE -> CHK-CASH-CODE
AH3-BANK-INST-CODE -> CHK-BANK-INST-CODE
AH3-TRANS-IDENT -> CHK-TRANS-IDENT
Cbtrans CBTRANS Not Required
Valid When AH3-SERIAL-NUM = Zeroes
AH3-BANK-INST-CODE -> CBT-BANK-INST-CODE
AH3-TRANS-IDENT -> CBT-TRANS-IDENT
APAPPHIST FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Ah3set6 APAPPHIST
AH3-PAY-GROUP -> AH3-PAY-GROUP
AH3-BANK-INST-CODE -> AH3-BANK-INST-CODE
AH3-TRANS-IDENT -> AH3-TRANS-IDENT
AH3-VENDOR
AH3-INVOICE
AH3-SUFFIX
AH3-CANCEL-SEQ
AH3-SEQ-NBR
AH3-VOID-SEQ
AH3-COMPANY
Apdskhist APDSKHIST
AH3-COMPANY -> AH8-COMPANY
AH3-VENDOR -> AH8-VENDOR
AH3-INVOICE -> AH8-INVOICE
AH3-SUFFIX -> AH8-SUFFIX
AH3-CANCEL-SEQ -> AH8-CANCEL-SEQ
AH3-SEQ-NBR -> AH8-SEQ-NBR
AH8-VOID-SEQ
AH8-DISC-TYPE
Aphldinv APHLDINV Delete Cascades
Valid When AH3-HOLD-FLAG = "Y"
"P" -> HLI-REC-TYPE
AH3-VENDOR-GROUP -> HLI-VENDOR-GROUP
AH3-COMPANY -> HLI-COMPANY
AH3-VENDOR -> HLI-VENDOR
AH3-INVOICE -> HLI-INVOICE
AH3-SUFFIX -> HLI-SUFFIX
AH3-CANCEL-SEQ -> HLI-CANCEL-SEQ
AH3-SEQ-NBR -> HLI-SEQ-NBR
AH3-VOID-SEQ -> HLI-VOID-SEQ
HLI-HLD-CODE
|
