|
|
APAPPHIST FILE
REFERENCED BY
AP136 AP00.5 AP145 AP146 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
Element: Company 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.
AH3-VENDOR Alpha 9 (Right Justified) AP115 AP198
Element: Vendor The vendor's identification code.
AH3-INVOICE Alpha 22 AP115 AP198
Element: Invoice Used to identify the invoice.
AH3-SUFFIX Numeric 3 AP198
Element: Suffix This is the suffix for the invoice.
AH3-CANCEL-SEQ Numeric 4 AP198
Element: Seq Nbr An automatically assigned sequence
number.
AH3-SEQ-NBR Numeric 4 AP198
Element: Seq Nbr An automatically assigned sequence
number.
AH3-VOID-SEQ Numeric 4 AP198
Element: Seq Nbr An automatically assigned sequence
number.
AH3-VOID-DATE Numeric 8 (yyyymmdd) AP198
Element: Date This field displays the system date
when this was created.
AH3-INV-CURRENCY Alpha 5 AP198
Element: To Base Curr
AH3-PAY-VENDOR Alpha 9 (Right Justified) AP115 AP198
Element: Vendor The vendor's identification code.
AH3-REMIT-TO-CODE Alpha 4 AP115 AP198
Element: Remit To Code A user-defined code that represents a
vendor's remittance address.
AH3-PAY-COMPANY Numeric 4 AP198
Element: Company 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.
AH3-CASH-CODE Alpha 4 AP115 AP198
Element: 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
Element: Due Date The transaction due date.
AH3-ENCLOSURE Alpha 1 AP198
Element: All Flag
AH3-HOLD-FLAG Alpha 1 AP198
Element: 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
Element: Ven Class A user-defined code representing a
subset of vendors within a vendor group.
AH3-VEN-PRIORITY Numeric 2 AP115 AP198
Element: Ven 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
Element: Proc Grp 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 18.2 AP198
Element: Intl Amt
AH3-BASE-ACT-AMT Signed 18.2 AP198
Element: Intl Amt
AH3-BASE-ND Numeric 1 AP198
Element: Base Nd The number of decimal positions defined
for the company base currency.
AH3-TRAN-PMT-AMT Signed 18.2 AP198
Element: Intl Amt
AH3-TRAN-ND Numeric 1 AP198
Element: Acct Nd The number of decimals assigned to a
particular account as determined by the
account currency.
AH3-BANK-CHK-AMT Signed 18.2 AP198
Element: Intl Amt
AH3-BANK-ND Numeric 1 AP198
Element: Acct Nd The number of decimals assigned to a
particular account as determined by the
account currency.
AH3-BASE-DISC-AMT Signed 18.2 AP198
Element: Intl Amt
AH3-TRAN-DISC-AMT Signed 18.2 AP198
Element: Intl Amt
AH3-BASE-CHK-AMT Signed 18.2 AP198
Element: Intl Amt
AH3-TRAN-CHK-AMT Signed 18.2 AP198
Element: Intl Amt
AH3-BASE-INC-WH Signed 18.2 AP198
Element: Intl Amt
AH3-TRAN-INC-WH Signed 18.2 AP198
Element: Intl Amt
AH3-TRAN-INC-AMT Signed 18.2 AP198
Element: Intl Amt
AH3-GAINLOS-AMT Signed 18.2 AP198
Element: Intl Amt
AH3-UNRL-REV-DATE Numeric 8 (yyyymmdd) AP198
Element: Date This field displays the system date
when this was created.
AH3-ACT-CNV-RATE Signed 14.7 AP198
Element: Cnv Rate
AH3-DSC-ACCT-UNIT Alpha 15 AP198
Element: Acct Unit 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.
AH3-DSC-ACCOUNT Numeric 6 AP198
Element: Account This field along with the accounting
unit and subaccount make up the location
(account) where amounts and other
account information is stored.
AH3-DSC-SUB-ACCT Numeric 4 AP198
Element: Sub Acct This field contains the subaccount from
your general ledger chart of accounts
that was charged with the amount carried
on this record.
AH3-DISCOUNT-RT Percent 5.3 (Percent) AP198
Element: Discount Rt
AH3-DISC-DATE Numeric 8 (yyyymmdd) AP198
Element: Date This field displays the system date
when this was created.
AH3-TRANS-IDENT Numeric 10 AP198
Element: Trans Ident A unique system-generated
identification value assigned to the
transaction to make this record unique.
AH3-ACCR-CODE Alpha 4 AP198
Element: Accr Code A user-defined code representing a
general ledger accrual account.
AH3-PROC-LEVEL Alpha 5 AP198
Element: Process Level This field contains the process level,
which is the reporting hierarchy below
company.
AH3-REC-STATUS Numeric 1 AP198
Element: Rec Status The record status.
AH3-TRANS-NBR Alpha 10 (Right Justified) AP198
Element: Trans Nbr A unique, user-defined value used to
identify the transaction.
AH3-CHK-SUFFIX Numeric 3 AP198
Element: Chk Suffix
AH3-BANK-INST-CODE Alpha 3 AP115 AP198
Element: Bank Inst CodeA transaction code represents a type of
cash payment, bill of exchange payment,
or bank service transaction.
AH3-CHECK-DATE Numeric 8 (yyyymmdd) AP198
Element: Check Date The payment date.
AH3-INCOME-CODE Alpha 4 AP198
Element: 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
Element: All Flag
AH3-PAY-IMM-FLAG Alpha 1 AP198
Element: All Flag
AH3-DISC-LOST-FLG Alpha 1 AP198
Element: All Flag
AH3-ANTICIPATION Alpha 1 AP198
Element: Anticipation The anticipation flag.
AH3-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.
AH3-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.
AH3-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.
AH3-DISCOUNT-CODE Alpha 10 AP198
Element: Discount Code A user-defined code that represents a
general ledger discount account.
AH3-INC-ACCR-CODE Alpha 10 AP198
Element: Inc Accr Code A user-defined code representing a
general ledger income withholding
accrual account.
AH3-RECON-STMT-NBR Numeric 12 AP198
Element: Recon Stmt NbrThe bank-assigned reconciliation
statement number. Used only for cash
codes that require reconciliation
statements.
AH3-MATCH-DISC-TAK Alpha 1 AP198
Element: Match Disc Tak
AH3-OPEN-BASE-PMT Derived
Element: Open Base Pmt
AH3-OPEN-TRAN-PMT Derived
Element: Open Tran Pmt
AH3-BASE-NET-PMT Derived
Element: Base Net Pmt
AH3-TRAN-NET-PMT Derived
Element: Tran Net Pmt
AH3-PMT-STATUS Derived
Element: Pmt Status
AH3-BANK-STATUS Derived
Element: Bank Status
AH3-NO-REINSTATE Derived
Element: No Reinstate
AH3-PAID-DOC-DATE Derived
Element: Paid Doc Date
AH3-DRAFT-ACCRUED Derived
Element: Draft Accrued
AH3-AP-INV-DATE Derived
Element: Ap Inv Date
AH3-AP-PO-NBR Derived
Element: Ap Po Nbr
AH3-AP-INV-TYPE Derived
Element: Ap Inv Type
AH3-AP-BASE-INV Derived
Element: Ap Base Inv
AH3-AP-FORMAT-NBR Derived
Element: Ap Format Nbr
AH3-STATEMENT Alpha 22
Element: Invoice Used to identify the invoice.
APAPPHIST FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
AH3SET1 COMPANY AP115 AP136
VENDOR AP180 AP181
INVOICE AP190 AP28.1
SUFFIX AP28.2 AP300
CANCEL-SEQ AP305 AP45.1
SEQ-NBR
VOID-SEQ
AH3SET10 REC-STATUS KeyChange AP00.5 AP145
COMPANY AP146 AP245
PROC-LEVEL AP270
VENDOR
INVOICE
SUFFIX
CANCEL-SEQ
SEQ-NBR
VOID-SEQ
PAY-GROUP
AH3SET2 PAY-GROUP KeyChange 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
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 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
|
