|
|
APAPPHIST FILE
REFERENCED BY
AP260 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 The company number represents an
established company and is entered on
all function codes.
AH3-VENDOR Alpha 9 (Right Justified) AP115 AP198
Element: Vendor ID The vendor's identification code.
AH3-INVOICE Alpha 22 AP115 AP198
Element: Invoice NumberUsed to identify the invoice.
AH3-SUFFIX Numeric 3 AP198
Element: Invoice SuffixThis is the suffix for the invoice.
AH3-CANCEL-SEQ Numeric 4 AP198
Element: Sequence Number
AH3-SEQ-NBR Numeric 4 AP198
Element: Sequence NumbeAn automatically assigned sequence
number.
AH3-VOID-SEQ Numeric 4 AP198
Element: Sequence Number
AH3-VOID-DATE Numeric 8 (yyyymmdd) AP198
Element: Date
AH3-INV-CURRENCY Alpha 5 AP198
To Company Base
Currency
AH3-PAY-VENDOR Alpha 9 (Right Justified) AP115 AP198
Element: Vendor ID
AH3-REMIT-TO-CODE Alpha 4 AP115 AP198
Purchase From
Location Code
AH3-PAY-COMPANY Numeric 4 AP198
Element: Company
AH3-CASH-CODE Alpha 4 AP115 AP198
Accounts Receivable
Code
AH3-DUE-DATE Numeric 8 (yyyymmdd) AP198
Element: Date The transaction due date.
AH3-ENCLOSURE Alpha 1 AP198
Element: All Flag
AH3-HOLD-FLAG Alpha 1 AP198
Element: 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
Element: Vendor Class A user-defined code representing a
subset of vendors within a vendor group.
AH3-VEN-PRIORITY Numeric 2 AP115 AP198
Element: Vendor PrioritThe payment priority of a vendor, where
1 = the highest priority and 99 = the
lowest.
AH3-PROC-GRP Alpha 4 (Lower Case) AP115 AP198
Element: 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
Element: Adj Amt
AH3-BASE-ACT-AMT Signed 15.2 AP198
Element: Adj Amt
AH3-BASE-ND Numeric 1 AP198
Account Currency
Code
AH3-TRAN-PMT-AMT Signed 15.2 AP198
Element: Adj Amt
AH3-TRAN-ND Numeric 1 AP198
Account Currency
Code
AH3-BANK-CHK-AMT Signed 15.2 AP198
Element: Adj Amt
AH3-BANK-ND Numeric 1 AP198
Account Currency
Code
AH3-BASE-DISC-AMT Signed 15.2 AP198
Element: Actual Disc
AH3-TRAN-DISC-AMT Signed 15.2 AP198
Element: Actual Disc
AH3-BASE-CHK-AMT Signed 15.2 AP198
Element: Adj Amt
AH3-TRAN-CHK-AMT Signed 15.2 AP198
Element: Adj Amt
AH3-BASE-INC-WH Signed 15.2 AP198
Element: Exchange Rate
AH3-TRAN-INC-WH Signed 15.2 AP198
Element: Actual Cost
AH3-TRAN-INC-AMT Signed 15.2 AP198
Element: Adj Amt
AH3-GAINLOS-AMT Signed 15.2 AP198
Element: Adj Amt
AH3-UNRL-REV-DATE Numeric 8 (yyyymmdd) AP198
Element: Date
AH3-ACT-CNV-RATE Signed 12.6 AP198
Element: Account Rate
AH3-DSC-ACCT-UNIT Alpha 15 AP198
Element: Accounting Unit
AH3-DSC-ACCOUNT Numeric 6 AP198
Element: Account
AH3-DSC-SUB-ACCT Numeric 4 AP198
Element: Subaccount
AH3-DISCOUNT-RT Percent 5.3 (Percent) AP198
Element: Cost Pct
AH3-DISC-DATE Numeric 8 (yyyymmdd) AP198
Element: Date
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
Accounts Receivable
Code
AH3-PROC-LEVEL Alpha 5 AP198
Element: Process Level
AH3-REC-STATUS Numeric 1 AP198
Element: Record 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: Transaction CoA transaction code represents a type of
cash payment, bill of exchange payment,
or bank service transaction.
AH3-CHECK-DATE Numeric 8 (yyyymmdd) AP198
Element: Date
AH3-INCOME-CODE Alpha 4 AP198
Accounts Receivable
Code
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: All 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
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
Element: Match Disc Tak
AH3-OPEN-BASE-PMT Derived
Open Base Invoice
Amount
AH3-OPEN-TRAN-PMT Derived
Element: Open Invoice Amount
AH3-BASE-NET-PMT Derived
Base Invoice Amount
Paid
AH3-TRAN-NET-PMT Derived
Element: Invoice Amount Paid
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
Bill of Exchange
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
APAPPHIST FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
AH3SET1 COMPANY AP115 AP180
VENDOR AP181 AP190
INVOICE AP260 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
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
|
