APAPPHIST

AP Payment History

REFERENCED BY
AP136 AP197 AP232 AP271 AP00.5 AP145
AP146 AP245 AP246 AP93.2 CB186 CB286
AP255


UPDATED BY
AP115 AP180 AP181 AP190 AP198 AP28.1
AP28.2 AP45.1 AP300 AP305 AP270 AP265

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
AH3-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
AH3-VENDOR
Element: Vendor		Alpha 9 (Right Justified)
The vendor's identification code.
AP115 AP198
AH3-INVOICE
Element: Invoice		Alpha 22
Used to identify the invoice.
AP115 AP198
AH3-SUFFIX
Element: Suffix		Numeric 3
This is the suffix for the invoice.
AP198
AH3-CANCEL-SEQ
Element: Seq Nbr		Numeric 4
An automatically assigned sequence number.
AP198
AH3-SEQ-NBR
Element: Seq Nbr		Numeric 4
An automatically assigned sequence number.
AP198
AH3-VOID-SEQ
Element: Seq Nbr		Numeric 4
An automatically assigned sequence number.
AP198
AH3-VOID-DATE
Element: Date		Numeric 8 (yyyymmdd)
This field displays the system date when this was created.
AP198
AH3-INV-CURRENCY
Element: To Base Curr		Alpha 5
AP198
AH3-PAY-VENDOR
Element: Vendor		Alpha 9 (Right Justified)
The vendor's identification code.
AP115 AP198
AH3-REMIT-TO-CODE
Element: Remit To Code		Alpha 4
A user-defined code that represents a vendor's remittance address.
AP115 AP198
AH3-PAY-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
AH3-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
AH3-DUE-DATE
Element: Due Date		Numeric 8 (yyyymmdd)
The transaction due date.
AP198
AH3-ENCLOSURE
Element: All Flag		Alpha 1
AP198
AH3-HOLD-FLAG
Element: Hold Flag		Alpha 1
This field enables this entire lot to be put on hold, not allowing any issues or transfers to be made for this lot.
AP198
AH3-VEN-CLASS
Element: Ven Class		Alpha 3
A user-defined code representing a subset of vendors within a vendor group.
AP115 AP198
AH3-VEN-PRIORITY
Element: Ven Priority		Numeric 2
The payment priority of a vendor, where 1 = the highest priority and 99 = the lowest.
AP115 AP198
AH3-PROC-GRP
Element: Proc Grp		Alpha 4 (Lower Case)
A process group is an identifier used for separating vendors into different groups to enable concurrent processing within the cash payment cycle.
AP115 AP198
AH3-BASE-PMT-AMT
Element: Intl Amt		Signed 18.2
AP198
AH3-BASE-ACT-AMT
Element: Intl Amt		Signed 18.2
AP198
AH3-BASE-ND
Element: Base Nd		Numeric 1
The number of decimal positions defined for the company base currency.
AP198
AH3-TRAN-PMT-AMT
Element: Intl Amt		Signed 18.2
AP198
AH3-TRAN-ND
Element: Acct Nd		Numeric 1
The number of decimals assigned to a particular account as determined by the account currency.
AP198
AH3-BANK-CHK-AMT
Element: Intl Amt		Signed 18.2
AP198
AH3-BANK-ND
Element: Acct Nd		Numeric 1
The number of decimals assigned to a particular account as determined by the account currency.
AP198
AH3-BASE-DISC-AMT
Element: Intl Amt		Signed 18.2
AP198
AH3-TRAN-DISC-AMT
Element: Intl Amt		Signed 18.2
AP198
AH3-BASE-CHK-AMT
Element: Intl Amt		Signed 18.2
AP198
AH3-TRAN-CHK-AMT
Element: Intl Amt		Signed 18.2
AP198
AH3-BASE-INC-WH
Element: Intl Amt		Signed 18.2
AP198
AH3-TRAN-INC-WH
Element: Intl Amt		Signed 18.2
AP198
AH3-TRAN-INC-AMT
Element: Intl Amt		Signed 18.2
AP198
AH3-GAINLOS-AMT
Element: Intl Amt		Signed 18.2
AP198
AH3-UNRL-REV-DATE
Element: Date		Numeric 8 (yyyymmdd)
This field displays the system date when this was created.
AP198
AH3-ACT-CNV-RATE
Element: Cnv Rate		Signed 14.7
AP198
AH3-DSC-ACCT-UNIT
Element: Acct Unit		Alpha 15
The accounting unit is a shorthand notation representing the variable level number. When used in the General Ledger Account Master file, the accounting unit must be defined in the General Ledger Names file as a posting accounting unit.
AP198
AH3-DSC-ACCOUNT
Element: Account		Numeric 6
This field along with the accounting unit and subaccount make up the location (account) where amounts and other account information is stored.
AP198
AH3-DSC-SUB-ACCT
Element: Sub Acct		Numeric 4
This field contains the subaccount from your general ledger chart of accounts that was charged with the amount carried on this record.
AP198
AH3-DISCOUNT-RT
Element: Discount Rt		Percent 5.3 (Percent)
AP198
AH3-DISC-DATE
Element: Date		Numeric 8 (yyyymmdd)
This field displays the system date when this was created.
AP198
AH3-TRANS-IDENT
Element: Trans Ident		Numeric 10
A unique system-generated identification value assigned to the transaction to make this record unique.
AP198
AH3-ACCR-CODE
Element: Accr Code		Alpha 4
A user-defined code representing a general ledger accrual account.
AP198
AH3-PROC-LEVEL
Element: Process Level		Alpha 5
This field contains the process level, which is the reporting hierarchy below company.
AP198
AH3-REC-STATUS
Element: Rec Status		Numeric 1
The record status.
AP198
AH3-TRANS-NBR
Element: Trans Nbr		Alpha 10 (Right Justified)
A unique, user-defined value used to identify the transaction.
AP198
AH3-CHK-SUFFIX
Element: Chk Suffix		Numeric 3
AP198
AH3-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
AH3-CHECK-DATE
Element: Check Date		Numeric 8 (yyyymmdd)
The payment date.
AP198
AH3-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
AH3-SEP-CHK-FLAG
Element: All Flag		Alpha 1
AP198
AH3-PAY-IMM-FLAG
Element: All Flag		Alpha 1
AP198
AH3-DISC-LOST-FLG
Element: All Flag		Alpha 1
AP198
AH3-ANTICIPATION
Element: Anticipation		Alpha 1
The anticipation flag.
AP198
AH3-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
AH3-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
AH3-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
AH3-DISCOUNT-CODE
Element: Discount Code		Alpha 10
A user-defined code that represents a general ledger discount account.
AP198
AH3-INC-ACCR-CODE
Element: Inc Accr Code		Alpha 10
A user-defined code representing a general ledger income withholding accrual account.
AP198
AH3-RECON-STMT-NBR
Element: Recon Stmt Nbr		Numeric 12
The bank-assigned reconciliation statement number. Used only for cash codes that require reconciliation statements.
AP198
AH3-MATCH-DISC-TAK
Element: Match Disc Tak		Alpha 1
AP198
AH3-OPEN-BASE-PMT
Element: Open Base Pmt		Derived
AH3-OPEN-TRAN-PMT
Element: Open Tran Pmt		Derived
AH3-BASE-NET-PMT
Element: Base Net Pmt		Derived
AH3-TRAN-NET-PMT
Element: Tran Net Pmt		Derived
AH3-PMT-STATUS
Element: Pmt Status		Derived
AH3-BANK-STATUS
Element: Bank Status		Derived
AH3-NO-REINSTATE
Element: No Reinstate		Derived
AH3-PAID-DOC-DATE
Element: Paid Doc Date		Derived
AH3-DRAFT-ACCRUED
Element: Draft Accrued		Derived
AH3-AP-INV-DATE
Element: Ap Inv Date		Derived
AH3-AP-PO-NBR
Element: Ap Po Nbr		Derived
AH3-AP-INV-TYPE
Element: Ap Inv Type		Derived
AH3-AP-BASE-INV
Element: Ap Base Inv		Derived
AH3-AP-FORMAT-NBR
Element: Ap Format Nbr		Derived
AH3-STATEMENT
Element: Invoice		Alpha 22
Used to identify the invoice.
AH3-RETAINAGE-PMT
Element: Flag Num		Numeric 1

0 = No
1 = Yes
AP198
AH3-SEC-WTH-CODE1
Element: Sec Wth Code		Alpha 10
AP198
AH3-SEC-WTH-PCT1
Element: Withhold Pct		Percent 5.3 (Percent)
AP198
AH3-BASE-SEC-WTH1
Element: Intl Amt		Signed 18.2
AP198
AH3-TRAN-SEC-WTH1
Element: Intl Amt		Signed 18.2
AP198
AH3-SEC-WTH-CODE2
Element: Sec Wth Code		Alpha 10
AP198
AH3-SEC-WTH-PCT2
Element: Withhold Pct		Percent 5.3 (Percent)
AP198
AH3-BASE-SEC-WTH2
Element: Intl Amt		Signed 18.2
AP198
AH3-TRAN-SEC-WTH2
Element: Intl Amt		Signed 18.2
AP198
AH3-SEC-WTH-CODE3
Element: Sec Wth Code		Alpha 10
AP198
AH3-SEC-WTH-PCT3
Element: Withhold Pct		Percent 5.3 (Percent)
AP198
AH3-BASE-SEC-WTH3
Element: Intl Amt		Signed 18.2
AP198
AH3-TRAN-SEC-WTH3
Element: Intl Amt		Signed 18.2
AP198


APAPPHIST FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
AH3SET1 COMPANY
VENDOR
INVOICE
SUFFIX
CANCEL-SEQ
SEQ-NBR
VOID-SEQ
AP115 AP136
AP180 AP181
AP190 AP197
AP232 AP271
AP28.1 AP28.2
AP300 AP305
AP45.1
AH3SET10 REC-STATUS
COMPANY
PROC-LEVEL
VENDOR
INVOICE
SUFFIX
CANCEL-SEQ
SEQ-NBR
VOID-SEQ
PAY-GROUP
KeyChange
AP00.5 AP145
AP146 AP245
AP246 AP270
AH3SET2 PAY-GROUP
REC-STATUS
VENDOR
INVOICE
SUFFIX
CANCEL-SEQ
SEQ-NBR
VOID-SEQ
COMPANY
KeyChange
AP93.2
AH3SET6 PAY-GROUP
BANK-INST-CODE
TRANS-IDENT
VENDOR
INVOICE
SUFFIX
CANCEL-SEQ
SEQ-NBR
VOID-SEQ
COMPANY
KeyChange, Subset
WhereTRANS-IDENT !=Zeroes
AP180 AP181
AP190 AP265
AP28.1 AP28.2
CB186 CB286
AH3SET8 PAY-GROUP
CASH-CODE
TRANS-NBR
BANK-INST-CODE
COMPANY
VENDOR
INVOICE
SUFFIX
CANCEL-SEQ
SEQ-NBR
VOID-SEQ
KeyChange
AP255


APAPPHIST FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED 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
Appayvendor APVENMAST Required
AH3-VENDOR-GROUP->VEN-VENDOR-GROUP
AH3-PAY-VENDOR->VEN-VENDOR
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
AH3-PROC-GRP->CCF-PROC-GRP
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 CHK-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
NAME		 RELATED 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
Apdistpay APDISTPAY
AH3-COMPANY->DTY-COMPANY
AH3-VENDOR->DTY-VENDOR
AH3-INVOICE->DTY-INVOICE
AH3-SUFFIX->DTY-SUFFIX
AH3-SEQ-NBR->DTY-PMT-SEQ-NBR
  DTY-LINE-NBR
  DTY-MAD-SEQ-NBR
  DTY-DIST-SEQ-NBR
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

File created: Thu Jun 09 02:06:49 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.