AP Bill of Exchange
The Accounts Payable Bill of Exchange file contains bill of exchange payment records.
REFERENCED BY
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. |
|||
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. |
|||
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. |
|||
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. |
|||
APT-VENDOR Element: Vendor | Alpha 9 (Right Justified) The payment vendor number. Must be a valid record in the Vendor file. |
|||
APT-VENDOR-VNAME Element: Name | Alpha 30 (Lower Case) The vendor name or description. |
|||
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. |
|||
APT-DRAFT-NBR Bill of Exchange Number | Alpha 10 (Right Justified) The bill of exchange number. |
|||
APT-SUFFIX Bill of Exchange Suffix | Numeric 3 The bill of exchange suffix number. |
|||
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. |
|||
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. |
|||
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. |
|||
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. |
|||
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. |
|||
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. |
|||
APT-APPLIED-AMT Element: Intl Amt | Signed 18.2 The total invoice amount that is applied to the bill of exchange. |
|||
APT-TRAN-ND Element: Acct Nd | Numeric 1 The number of decimal positions defined for the bill of exchange currency. |
|||
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. |
|||
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. |
|||
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. |
|||
APT-BASE-ND Base Currency Nbr of Decimals | Numeric 1 The number of decimal positions defined for the company base currency. |
|||
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. |
|||
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. |
|||
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. |
|||
APT-ACCEPT-DATE Element: Acceptance Date | Numeric 8 (yyyymmdd) The date the bill of exchange is accepted. If left blank, the system date defaults. |
|||
APT-CASH-DATE Element: Date | Numeric 8 (yyyymmdd) The date the bill of exchange was cashed by the bank. |
|||
APT-DISHONOR-DATE Element: Dishonor Date | Numeric 8 (yyyymmdd) The date the bill of exchange was dishonored by the bank. |
|||
APT-CANCEL-DATE Element: Cancel Date | Numeric 8 (yyyymmdd) The date the bill of exchange was canceled. |
|||
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. |
|||
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. |
|||
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. |
|||
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. |
|||
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. |
|||
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. |
|||
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. |
|||
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. |
|||
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. |
|||
APT-PAYER-REF Payer Reference Number | Alpha 10 The reference number assigned to the bill of exchange payment. |
|||
APT-STATEMENT-NBR Element: Statement Number | Numeric 8 The statement number assigned to the bill of exchange payment. |
|
||
APT-JRNL-BOOK-NBR Element: Jrnl Book Nbr | Alpha 12 The journal book assigned to the transaction. |
|||
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. |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
APTSET1 |
BANK-INST-CODE TRANS-IDENT |
|
| ||||||||||||||||||||||||||||||||||||
APTSET10 |
CASH-CODE PAY-GROUP STATEMENT-NBR DRAFT-NBR SUFFIX |
|
| ||||||||||||||||||||||||||||||||||||
APTSET2 |
CASH-CODE REC-STATUS BANK-INST-CODE DRAFT-NBR SUFFIX TRANS-IDENT COMPANY VENDOR |
|
| ||||||||||||||||||||||||||||||||||||
APTSET3 |
PAY-GROUP REC-STATUS DRAFT-DATE BANK-INST-CODE DRAFT-NBR SUFFIX TRANS-IDENT |
|
|||||||||||||||||||||||||||||||||||||
APTSET4 |
PAY-GROUP VENDOR REC-STATUS DRAFT-NBR SUFFIX BANK-INST-CODE TRANS-IDENT |
|
| ||||||||||||||||||||||||||||||||||||
APTSET5 |
CASH-CODE MATURITY-DATE PAY-GROUP BANK-INST-CODE DRAFT-NBR SUFFIX TRANS-IDENT |
|
| ||||||||||||||||||||||||||||||||||||
APTSET6 |
BANK-INST-CODE DRAFT-NBR SUFFIX VENDOR PAY-GROUP |
|
|||||||||||||||||||||||||||||||||||||
APTSET7 |
PAY-GROUP BANK-INST-CODE VENDOR DRAFT-NBR SUFFIX TRANS-IDENT |
|
|||||||||||||||||||||||||||||||||||||
APTSET8 |
VENDOR-GROUP VENDOR COMPANY BANK-INST-CODE TRANS-IDENT |
|
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Apcompany | APCOMPANY |
Required
| ||||||||||||
Appaygroup | APPAYGROUP |
Required
| ||||||||||||
Approclev | APPROCLEV |
Not Required
| ||||||||||||
Apvenbal | APVENBAL |
Required
| ||||||||||||
Apvenclass | APVENMAST |
Not Required
| ||||||||||||
Apvenloc | APVENLOC |
Not Required
| ||||||||||||
Apvenmast | APVENMAST |
Not Required
| ||||||||||||
Cbbankent | CBBANKENT |
Required
| ||||||||||||
Cbbankinst | CBBANKINST |
Required
| ||||||||||||
Cbcashcode | CBCASHCODE |
Required
| ||||||||||||
Cbcpycash | CBCPYCASH |
Not Required
| ||||||||||||
Cbtrans | CBTRANS |
Not Required
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Apapphist | APAPPHIST |
| ||||||||||||||||||||||||||||||
Apdrftdist | APDRFTDIST |
| ||||||||||||||||||||||||||||||
Appayment | APPAYMENT |
|
All trademarks and registered trademarks are the property of their
respective owners.