APDRAFTS

AP Bill of Exchange

The Accounts Payable Bill of Exchange file contains bill of exchange payment records.

REFERENCED BY
AP136 AP213 AP230 AP284


UPDATED BY
AP125 AP126 AP151 AP156 AP166 AP167
AP180 AP181 AP20.1 AP20.2 AP20.3 AP20.4
AP20.5 AP20.7 AP20.8 AP21.1 AP23.1 AP25.1
AP25.2 AP26.1 AP27.1 AP28.1 AP28.2 AP305
AP56.1 AP56.2 AP80.1 CB300 MA41.1 MA41.2
MA41.4 MA41.7 MA43.1 MA43.2 MA43.3 MA43.4
MA43.6 MAI1.1 AP250 AP266 AP91.2 AP91.1
AP214

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
APT-PAY-GROUP
Element: Pay Group
Alpha 4
The pay group associated with the bill of exchange payment. A pay group is used for processing accounts payable payments. Must be a valid record in the Pay Group file.
AP125 AP126
AP151 AP156
AP180 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP20.8
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP56.1 AP56.2
AP80.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MAI1.1
APT-COMPANY
Element: Company
Numeric 4
The company associated with the bill of exchange payment. Must be a valid record in the Accounts Payable Company file.
AP125 AP126
AP151 AP156
AP180 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP20.8
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP56.1 AP56.2
AP80.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MAI1.1
APT-TRANS-IDENT
Element: Transaction ID
Numeric 10
A unique system-generated identification value assigned to the bill of exchange payment transaction to make this record unique.
AP125 AP126
AP151 AP156
AP180 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP20.8
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP56.1 AP56.2
AP80.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MAI1.1
APT-VENDOR-GROUP
Element: Vendor Group
Alpha 4
The vendor group associated with the bill of exchange payment. A vendor group represents a group of vendors that can be shared by one or more companies. Must be a valid record in the Vendor Group file.
AP125 AP126
AP151 AP156
AP180 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP20.8
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP56.1 AP56.2
AP80.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MAI1.1
APT-VENDOR
Element: Vendor
Alpha 9 (Right Justified)
The payment vendor number. Must be a valid record in the Vendor file.
AP125 AP126
AP151 AP156
AP180 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP20.8
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP56.1 AP56.2
AP80.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MAI1.1
APT-VENDOR-VNAME
Element: Name
Alpha 30 (Lower Case)
The vendor name or description.
AP125 AP126
AP151 AP156
AP180 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP20.8
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP56.1 AP56.2
AP80.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MAI1.1
APT-BANK-INST-CODE
Element: Payment Code
Alpha 3
The payment code assigned to the bill of exchange. Represents the type of bill of exchange payment. Must be a valid bill of exchange payment transaction code in the Bank Transaction Code file.
AP125 AP126
AP151 AP156
AP180 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP20.8
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP56.1 AP56.2
AP80.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MAI1.1
APT-DRAFT-NBR
Bill of Exchange
Number
Alpha 10 (Right Justified)
The bill of exchange number.
AP125 AP126
AP151 AP156
AP180 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP20.8
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP56.1 AP56.2
AP80.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MAI1.1
APT-SUFFIX
Bill of Exchange
Suffix
Numeric 3
The bill of exchange suffix number.
AP125 AP126
AP151 AP156
AP180 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP20.8
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP56.1 AP56.2
AP80.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MAI1.1
APT-PROC-LEVEL
Element: Process Level
Alpha 5
The process level associated with the bill of exchange. Must be a valid record in the Accounts Payable Process Level file.
AP125 AP126
AP151 AP156
AP180 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP20.8
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP56.1 AP56.2
AP80.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MAI1.1
APT-REMIT-TO-CODE
Element: Remit To Code
Alpha 4
The remit-to location code associated with the bill of exchange. Represents an alternate remittance location for the vendor. Must be a valid record in the Vendor Location file.
AP125 AP126
AP151 AP156
AP180 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP20.8
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP56.1 AP56.2
AP80.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MAI1.1
APT-PMT-DOC-ORIGIN
Element: Transaction Origin
Alpha 1
The bill of exchange payment origin. Indicates who created the bill of exchange document or transaction. Valid values are: P = Accounts Payable R = Accounts Receivable.
AP125 AP126
AP151 AP156
AP180 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP20.8
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP56.1 AP56.2
AP80.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MAI1.1
APT-CASH-CODE
Element: Cash Code
Alpha 4
The cash code assigned to the bill of exchange. Represents the bank account used to pay the bill of exchange. Must be a valid record in the Cash Code file. If left blank, the cash code assigned to the remit-to location, vendor, vendor class, process level, company, or pay group defaults.
AP125 AP126
AP151 AP156
AP180 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP20.8
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP56.1 AP56.2
AP80.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MAI1.1
APT-CURRENCY-CODE
Bill of Exchange
Currency
Alpha 5
The currency of the bill of exchange. Must be a valid record in the Currency Code file. If left blank, the company base currency defaults.
AP125 AP126
AP151 AP156
AP180 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP20.8
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP56.1 AP56.2
AP80.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MAI1.1
APT-DRAFT-AMOUNT
Bill of Exchange
Amount
Signed 18.2
The amount of the bill of exchange payment in the currency of the bill of exchange.
AP125 AP126
AP151 AP156
AP180 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP20.8
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP56.1 AP56.2
AP80.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MAI1.1
APT-APPLIED-AMT
Element: Intl Amt
Signed 18.2
The total invoice amount that is applied to the bill of exchange.
AP125 AP126
AP151 AP156
AP180 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP20.8
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP56.1 AP56.2
AP80.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MAI1.1
APT-TRAN-ND
Element: Acct Nd
Numeric 1
The number of decimal positions defined for the bill of exchange currency.
AP125 AP126
AP151 AP156
AP180 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP20.8
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP56.1 AP56.2
AP80.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MAI1.1
APT-ORIG-RATE
Exchange Rate at
Creation
Signed 14.7
The currency exchange rate used to convert the bill of exchange amount to the company base currency at the time the bill of exchange was created.
AP125 AP126
AP151 AP156
AP180 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP20.8
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP56.1 AP56.2
AP80.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MAI1.1
APT-BASE-ORIG-AMT
Base BOE Amount -
At Creation
Signed 18.2
The amount of the bill of exchange payment in the company base currency. This amount is based on the currency exchange rate in effect at the time the bill of exchange was created.
AP125 AP126
AP151 AP156
AP180 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP20.8
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP56.1 AP56.2
AP80.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MAI1.1
APT-BASE-ACT-AMT
Base BOE Amount -
At Cashing
Signed 18.2
The amount of the bill of exchange payment in the company base currency. This amount is based on the currency exchange rate in effect at the time the bill of exchange is cashed.
AP125 AP126
AP151 AP156
AP180 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP20.8
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP56.1 AP56.2
AP80.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MAI1.1
APT-BASE-ND
Base Currency Nbr
of Decimals
Numeric 1
The number of decimal positions defined for the company base currency.
AP125 AP126
AP151 AP156
AP180 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP20.8
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP56.1 AP56.2
AP80.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MAI1.1
APT-ACT-RATE
Exchange Rate at
Cashing
Signed 14.7
The currency exchange rate used to convert the bill of exchange amount to the company base currency at the time the bill of exchange is cashed.
AP125 AP126
AP151 AP156
AP180 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP20.8
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP56.1 AP56.2
AP80.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MAI1.1
APT-DRAFT-DATE
Bill of Exchange
Date
Numeric 8 (yyyymmdd)
The creation date of the bill of exchange. If left blank, the system date defaults.
AP125 AP126
AP151 AP156
AP180 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP20.8
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP56.1 AP56.2
AP80.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MAI1.1
APT-MATURITY-DATE
Element: Due Date
Numeric 8 (yyyymmdd)
The date the bill of exchange is due for payment. If left blank, the system date defaults.
AP125 AP126
AP151 AP156
AP180 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP20.8
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP56.1 AP56.2
AP80.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MAI1.1
APT-ACCEPT-DATE
Element: Acceptance Date
Numeric 8 (yyyymmdd)
The date the bill of exchange is accepted. If left blank, the system date defaults.
AP125 AP126
AP151 AP156
AP180 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP20.8
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP56.1 AP56.2
AP80.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MAI1.1
APT-CASH-DATE
Element: Date
Numeric 8 (yyyymmdd)
The date the bill of exchange was cashed by the bank.
AP125 AP126
AP151 AP156
AP180 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP20.8
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP56.1 AP56.2
AP80.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MAI1.1
APT-DISHONOR-DATE
Element: Dishonor Date
Numeric 8 (yyyymmdd)
The date the bill of exchange was dishonored by the bank.
AP125 AP126
AP151 AP156
AP180 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP20.8
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP56.1 AP56.2
AP80.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MAI1.1
APT-CANCEL-DATE
Element: Cancel Date
Numeric 8 (yyyymmdd)
The date the bill of exchange was canceled.
AP125 AP126
AP151 AP156
AP180 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP20.8
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP56.1 AP56.2
AP80.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MAI1.1
APT-CASH-COMPANY
Element: Cashing Company
Numeric 4
The company associated with cashing the bill of exchange payment. Must be a valid record in the Accounts Payable Company file.
AP125 AP126
AP151 AP156
AP180 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP20.8
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP56.1 AP56.2
AP80.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MAI1.1
APT-REC-STATUS
Element: Rec Status
Numeric 1
The status of the bill of exchange payment. Valid values are: 0 = Unreleased. 1 = Released. 2 = Accepted. 3 = Cashed. 4 = Dishonored. 5 = Canceled.
AP125 AP126
AP151 AP156
AP180 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP20.8
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP56.1 AP56.2
AP80.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MAI1.1
APT-PRINT-STATUS
Element: Print Status
Alpha 1
Indicates whether the bill of exchange payment has been printed by AP156 (Bill of Exchange Printing). Valid values are: N = No. Y = Yes.
AP125 AP126
AP151 AP156
AP180 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP20.8
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP56.1 AP56.2
AP80.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MAI1.1
APT-ACPT-ACCT-UNIT
Acceptance
Accounting Unit
Alpha 15
The general ledger acceptance accounting unit assigned to the bill of exchange payment. Must be a valid accounting unit in the Lawson General Ledger system.
AP125 AP126
AP151 AP156
AP180 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP20.8
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP56.1 AP56.2
AP80.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MAI1.1
APT-ACPT-ACCOUNT
Acceptance Account
Number
Numeric 6
The general ledger acceptance account number assigned to the bill of exchange payment. Must be a valid account in the Lawson General Ledger system.
AP125 AP126
AP151 AP156
AP180 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP20.8
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP56.1 AP56.2
AP80.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MAI1.1
APT-ACPT-SUB-ACCT
Acceptance
Subaccount Number
Numeric 4
The general ledger acceptance subaccount number assigned to the bill of exchange payment. Must be a valid subaccount in the Lawson General Ledger system.
AP125 AP126
AP151 AP156
AP180 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP20.8
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP56.1 AP56.2
AP80.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MAI1.1
APT-DRAFT-CODE
Bill of Exchange
Accrual Code
Alpha 4
The bill of exchange accrual code assigned to the bill of exchange payment. Used to default an acceptance account to the bill of exchange. Must be a valid record in the Bill of Exchange Accrual Code file.
AP125 AP126
AP151 AP156
AP180 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP20.8
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP56.1 AP56.2
AP80.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MAI1.1
APT-GL-UPDATE-FL
General Ledger
Update Flag
Alpha 1
Indicates whether the cashed or dishonored bill of exchange has been updated to the general ledger by AP185 (Bill of Exchange Distribution Posting). Valid values are: N = No. Y = Yes.
AP125 AP126
AP151 AP156
AP180 AP181
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP20.8 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP56.1
AP56.2 AP80.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MAI1.1
APT-POST-DATE
Element: Post Date
Numeric 8 (yyyymmdd)
The date used for posting the cashed or dishonored bill of exchange payment to the general ledger.
AP125 AP126
AP151 AP156
AP180 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP20.8
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP56.1 AP56.2
AP80.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MAI1.1
APT-PAYER-REF
Payer Reference
Number
Alpha 10
The reference number assigned to the bill of exchange payment.
AP125 AP126
AP151 AP156
AP180 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP20.8
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP56.1 AP56.2
AP80.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MAI1.1
APT-STATEMENT-NBR
Element: Statement Number
Numeric 8
The statement number assigned to the bill of exchange payment.
AP166 AP167
APT-JRNL-BOOK-NBR
Element: Jrnl Book Nbr
Alpha 12
The journal book assigned to the transaction.
AP125 AP126
AP151 AP156
AP180 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP20.8
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP56.1 AP56.2
AP80.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MAI1.1
APT-DERIVED-STATUS
Bill of Exchange
Status
Derived
The status of the bill of exchange payment.
APT-VGROUP
Element: Vendor Group
Derived
The vendor group associated with the bill of exchange payment. Must be a valid record in the Vendor Group file.
APT-SHORT-DFT-NAME
Element: Short Vendor Name
Derived
A short (20-character) name for the vendor associated with the bill of exchange payment.


APDRAFTS FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
APTSET1 BANK-INST-CODE
TRANS-IDENT
...
AP125 AP126
AP136 AP151
AP156 AP166
AP180 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP20.8
AP21.1 AP213
AP23.1 AP230
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP284 AP56.1
AP56.2 AP80.1
CB300 MA41.1
APTSET10 CASH-CODE
PAY-GROUP
STATEMENT-NBR
DRAFT-NBR
SUFFIX
Subset
Where(STATEMENT-NBR !=Zeroes)
AP181
APTSET2 CASH-CODE
REC-STATUS
BANK-INST-CODE
DRAFT-NBR
SUFFIX
TRANS-IDENT
COMPANY
VENDOR
KeyChange
AP167 AP181
APTSET3 PAY-GROUP
REC-STATUS
DRAFT-DATE
BANK-INST-CODE
DRAFT-NBR
SUFFIX
TRANS-IDENT
KeyChange, Subset
WhereREC-STATUS =1
OrREC-STATUS =2
...
AP125 AP126
AP151 AP156
AP180 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP20.8
AP21.1 AP23.1
AP25.1 AP25.2
AP250 AP26.1
AP27.1 AP28.1
AP28.2 AP56.1
AP56.2 AP80.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
APTSET4 PAY-GROUP
VENDOR
REC-STATUS
DRAFT-NBR
SUFFIX
BANK-INST-CODE
TRANS-IDENT
KeyChange
AP266 AP28.1
AP28.2
APTSET5 CASH-CODE
MATURITY-DATE
PAY-GROUP
BANK-INST-CODE
DRAFT-NBR
SUFFIX
TRANS-IDENT
KeyChange, Subset
WhereGL-UPDATE-FL ="N"
AndREC-STATUS >1
AndREC-STATUS <5
AP180 AP80.1
APTSET6 BANK-INST-CODE
DRAFT-NBR
SUFFIX
VENDOR
PAY-GROUP
KeyChange, Subset
WhereREC-STATUS !=5
...
AP125 AP126
AP151 AP156
AP180 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP20.8
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP56.1 AP56.2
AP80.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
APTSET7 PAY-GROUP
BANK-INST-CODE
VENDOR
DRAFT-NBR
SUFFIX
TRANS-IDENT
KeyChange
...
AP125 AP126
AP151 AP156
AP180 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP20.8
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP305 AP56.1
AP56.2 AP80.1
AP91.2 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
APTSET8 VENDOR-GROUP
VENDOR
COMPANY
BANK-INST-CODE
TRANS-IDENT
KeyChange
AP214 AP91.1


APDRAFTS FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Apcompany APCOMPANY Required
APT-COMPANY->CPY-COMPANY
Appaygroup APPAYGROUP Required
APT-PAY-GROUP->PAY-PAY-GROUP
Approclev APPROCLEV Not Required
APT-COMPANY->APR-COMPANY
APT-PROC-LEVEL->APR-PROC-LEVEL
Apvenbal APVENBAL Required
CPY-VENDOR-GROUP->VBA-VENDOR-GROUP
APT-COMPANY->VBA-COMPANY
APT-VENDOR->VBA-VENDOR
APT-REMIT-TO-CODE->VBA-LOCATION-CODE
Apvenclass APVENMAST Not Required
CPY-VENDOR-GROUP->VEN-VENDOR-GROUP
APT-VENDOR->VEN-VENDOR
Apvenloc APVENLOC Not Required
CPY-VENDOR-GROUP->VLO-VENDOR-GROUP
APT-VENDOR->VLO-VENDOR
APT-REMIT-TO-CODE->VLO-LOCATION-CODE
Apvenmast APVENMAST Not Required
CPY-VENDOR-GROUP->VEN-VENDOR-GROUP
APT-VENDOR->VEN-VENDOR
Cbbankent CBBANKENT Required
CBC-BANK-ENTITY->CBE-BANK-ENTITY
Cbbankinst CBBANKINST Required
APT-BANK-INST-CODE->CBI-BANK-INST-CODE
Cbcashcode CBCASHCODE Required
APT-CASH-CODE->CBC-CASH-CODE
Cbcpycash CBCPYCASH Not Required
APT-COMPANY->CBY-COMPANY
APT-CASH-CODE->CBY-CASH-CODE
Cbtrans CBTRANS Not Required
APT-BANK-INST-CODE->CBT-BANK-INST-CODE
APT-TRANS-IDENT->CBT-TRANS-IDENT


APDRAFTS FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Apapphist APAPPHIST
APT-PAY-GROUP->AH3-PAY-GROUP
APT-BANK-INST-CODE->AH3-BANK-INST-CODE
APT-TRANS-IDENT->AH3-TRANS-IDENT
  AH3-VENDOR
  AH3-INVOICE
  AH3-SUFFIX
  AH3-CANCEL-SEQ
  AH3-SEQ-NBR
  AH3-VOID-SEQ
  AH3-COMPANY
Apdrftdist APDRFTDIST
APT-BANK-INST-CODE->DDT-BANK-INST-CODE
APT-TRANS-IDENT->DDT-TRANS-IDENT
  DDT-SEQ-NBR
Appayment APPAYMENT
APT-PAY-GROUP->APP-PAY-GROUP
APT-BANK-INST-CODE->APP-BANK-INST-CODE
APT-TRANS-IDENT->APP-TRANS-IDENT
  APP-VENDOR
  APP-INVOICE
  APP-SUFFIX
  APP-CANCEL-SEQ
  APP-SEQ-NBR
  APP-VOID-SEQ
  APP-COMPANY


File created: Wed Jun 08 20:47:30 2016

Home
Contact Us



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