APDRAFTS FILE
AP Bill of Exchange
The Accounts Payable Bill of Exchange file contains bill of exchange payment
records.
REFERENCED BY
AP213 AP260 AP284 AP230 AP250 AP198
AP266 AP300 AP91.2 AP91.1 AP214
UPDATED BY
AP151 AP156 AP166 AP167 AP180 AP181
AP28.1 AP28.2 AP305 AP56.1 AP56.2 AP80.1
CB300
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
APT-PAY-GROUP Alpha 4 AP151 AP156
Pay Group The pay group associated with the bill AP180 AP28.1
of exchange payment. A pay group is used AP28.2 AP56.1
for processing accounts payable AP56.2 AP80.1
payments. Must be a valid record in the
Pay Group file.
APT-COMPANY Numeric 4 AP151 AP156
Company The company associated with the bill of AP180 AP28.1
exchange payment. Must be a valid record AP28.2 AP56.1
in the Accounts Payable Company file. AP56.2 AP80.1
APT-TRANS-IDENT Numeric 10 AP151 AP156
Transaction ID A unique system-generated AP180 AP28.1
identification value assigned to the AP28.2 AP56.1
bill of exchange payment transaction to AP56.2 AP80.1
make this record unique.
APT-VENDOR-GROUP Alpha 4 AP151 AP156
Vendor Group The vendor group associated with the AP180 AP28.1
bill of exchange payment. A vendor group AP28.2 AP56.1
represents a group of vendors that can AP56.2 AP80.1
be shared by one or more companies. Must
be a valid record in the Vendor Group
file.
APT-VENDOR Alpha 9 (Right Justified) AP151 AP156
Vendor ID The payment vendor number. Must be a AP180 AP28.1
valid record in the Vendor file. AP28.2 AP56.1
AP56.2 AP80.1
APT-VENDOR-VNAME Alpha 30 (Lower Case) AP151 AP156
Vendor Name The vendor name or description. AP180 AP28.1
AP28.2 AP56.1
AP56.2 AP80.1
APT-BANK-INST-CODE Alpha 3 AP151 AP156
Payment Code The payment code assigned to the bill AP180 AP28.1
of exchange. Represents the type of bill AP28.2 AP56.1
of exchange payment. Must be a valid AP56.2 AP80.1
bill of exchange payment transaction
code in the Bank Transaction Code file.
APT-DRAFT-NBR Alpha 10 (Right Justified) AP151 AP156
Bill of Exchange The bill of exchange number. AP180 AP28.1
Number AP28.2 AP56.1
AP56.2 AP80.1
APT-SUFFIX Numeric 3 AP151 AP156
Bill of Exchange The bill of exchange suffix number. AP180 AP28.1
Suffix AP28.2 AP56.1
AP56.2 AP80.1
APT-PROC-LEVEL Alpha 5 AP151 AP156
Process Level The process level associated with the AP180 AP28.1
bill of exchange. Must be a valid record AP28.2 AP56.1
in the Accounts Payable Process Level AP56.2 AP80.1
file.
APT-REMIT-TO-CODE Alpha 4 AP151 AP156
Remit To Location The remit-to location code associated AP180 AP28.1
Code with the bill of exchange. Represents an AP28.2 AP56.1
alternate remittance location for the AP56.2 AP80.1
vendor. Must be a valid record in the
Vendor Location file.
APT-PMT-DOC-ORIGIN Alpha 1 AP151 AP156
Transaction Origin The bill of exchange payment origin. AP180 AP28.1
Indicates who created the bill of AP28.2 AP56.1
exchange document or transaction. Valid AP56.2 AP80.1
values are:
P = Accounts Payable
R = Accounts Receivable.
APT-CASH-CODE Alpha 4 AP151 AP156
Cash Code The cash code assigned to the bill of AP180 AP28.1
exchange. Represents the bank account AP28.2 AP56.1
used to pay the bill of exchange. Must AP56.2 AP80.1
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 Alpha 5 AP151 AP156
Bill of Exchange The currency of the bill of exchange. AP180 AP28.1
Currency Must be a valid record in the Currency AP28.2 AP56.1
Code file. If left blank, the company AP56.2 AP80.1
base currency defaults.
APT-DRAFT-AMOUNT Signed 15.2 AP151 AP156
Bill of Exchange The amount of the bill of exchange AP180 AP28.1
Amount payment in the currency of the bill of AP28.2 AP56.1
exchange. AP56.2 AP80.1
APT-APPLIED-AMT Signed 15.2 AP151 AP156
Applied Amount The total invoice amount that is AP180 AP28.1
applied to the bill of exchange. AP28.2 AP56.1
AP56.2 AP80.1
APT-TRAN-ND Numeric 1 AP151 AP156
Transaction Number The number of decimal positions defined AP180 AP28.1
of Decimals for the bill of exchange currency. AP28.2 AP56.1
AP56.2 AP80.1
APT-ORIG-RATE Signed 12.6 AP151 AP156
Exchange Rate at The currency exchange rate used to AP180 AP28.1
Creation convert the bill of exchange amount to AP28.2 AP56.1
the company base currency at the time AP56.2 AP80.1
the bill of exchange was created.
APT-BASE-ORIG-AMT Signed 15.2 AP151 AP156
Base BOE Amount - The amount of the bill of exchange AP180 AP28.1
At Creation payment in the company base currency. AP28.2 AP56.1
This amount is based on the currency AP56.2 AP80.1
exchange rate in effect at the time the
bill of exchange was created.
APT-BASE-ACT-AMT Signed 15.2 AP151 AP156
Base BOE Amount - The amount of the bill of exchange AP180 AP28.1
At Cashing payment in the company base currency. AP28.2 AP56.1
This amount is based on the currency AP56.2 AP80.1
exchange rate in effect at the time the
bill of exchange is cashed.
APT-BASE-ND Numeric 1 AP151 AP156
Base Currency Nbr The number of decimal positions defined AP180 AP28.1
of Decimals for the company base currency. AP28.2 AP56.1
AP56.2 AP80.1
APT-ACT-RATE Signed 12.6 AP151 AP156
Exchange Rate at The currency exchange rate used to AP180 AP28.1
Cashing convert the bill of exchange amount to AP28.2 AP56.1
the company base currency at the time AP56.2 AP80.1
the bill of exchange is cashed.
APT-DRAFT-DATE Numeric 8 (yyyymmdd) AP151 AP156
Bill of Exchange The creation date of the bill of AP180 AP28.1
Date exchange. If left blank, the system date AP28.2 AP56.1
defaults. AP56.2 AP80.1
APT-MATURITY-DATE Numeric 8 (yyyymmdd) AP151 AP156
Due Date The date the bill of exchange is due AP180 AP28.1
for payment. If left blank, the system AP28.2 AP56.1
date defaults. AP56.2 AP80.1
APT-ACCEPT-DATE Numeric 8 (yyyymmdd) AP151 AP156
Acceptance Date The date the bill of exchange is AP180 AP28.1
accepted. If left blank, the system date AP28.2 AP56.1
defaults. AP56.2 AP80.1
APT-CASH-DATE Numeric 8 (yyyymmdd) AP151 AP156
Cash Date The date the bill of exchange was AP180 AP28.1
cashed by the bank. AP28.2 AP56.1
AP56.2 AP80.1
APT-DISHONOR-DATE Numeric 8 (yyyymmdd) AP151 AP156
Dishonor Date The date the bill of exchange was AP180 AP28.1
dishonored by the bank. AP28.2 AP56.1
AP56.2 AP80.1
APT-CANCEL-DATE Numeric 8 (yyyymmdd) AP151 AP156
Cancel Date The date the bill of exchange was AP180 AP28.1
canceled. AP28.2 AP56.1
AP56.2 AP80.1
APT-CASH-COMPANY Numeric 4 AP151 AP156
Cashing Company The company associated with cashing the AP180 AP28.1
bill of exchange payment. Must be a AP28.2 AP56.1
valid record in the Accounts Payable AP56.2 AP80.1
Company file.
APT-REC-STATUS Numeric 1 AP151 AP156
Record Status The status of the bill of exchange AP180 AP28.1
payment. Valid values are: AP28.2 AP56.1
AP56.2 AP80.1
0 = Unreleased.
1 = Released.
2 = Accepted.
3 = Cashed.
4 = Dishonored.
5 = Canceled.
APT-PRINT-STATUS Alpha 1 AP151 AP156
Print Status Indicates whether the bill of exchange AP180 AP28.1
payment has been printed by AP156 (Bill AP28.2 AP56.1
of Exchange Printing). Valid values are: AP56.2 AP80.1
N = No.
Y = Yes.
APT-ACPT-ACCT-UNIT Alpha 15 AP151 AP156
Acceptance The general ledger acceptance AP180 AP28.1
Accounting Unit accounting unit assigned to the bill of AP28.2 AP56.1
exchange payment. Must be a valid AP56.2 AP80.1
accounting unit in the Lawson General
Ledger system.
APT-ACPT-ACCOUNT Numeric 6 AP151 AP156
Acceptance Account The general ledger acceptance account AP180 AP28.1
Number number assigned to the bill of exchange AP28.2 AP56.1
payment. Must be a valid account in the AP56.2 AP80.1
Lawson General Ledger system.
APT-ACPT-SUB-ACCT Numeric 4 AP151 AP156
Acceptance The general ledger acceptance AP180 AP28.1
Subaccount Number subaccount number assigned to the bill AP28.2 AP56.1
of exchange payment. Must be a valid AP56.2 AP80.1
subaccount in the Lawson General Ledger
system.
APT-DRAFT-CODE Alpha 4 AP151 AP156
Bill of Exchange The bill of exchange accrual code AP180 AP28.1
Accrual Code assigned to the bill of exchange AP28.2 AP56.1
payment. Used to default an acceptance AP56.2 AP80.1
account to the bill of exchange. Must be
a valid record in the Bill of Exchange
Accrual Code file.
APT-GL-UPDATE-FL Alpha 1 AP151 AP156
General Ledger Indicates whether the cashed or AP180 AP181
Update Flag dishonored bill of exchange has been AP28.1 AP28.2
updated to the general ledger by AP185 AP56.1 AP56.2
(Bill of Exchange Distribution Posting). AP80.1
Valid values are:
N = No.
Y = Yes.
APT-POST-DATE Numeric 8 (yyyymmdd) AP151 AP156
Post Date The date used for posting the cashed or AP180 AP28.1
dishonored bill of exchange payment to AP28.2 AP56.1
the general ledger. AP56.2 AP80.1
APT-PAYER-REF Alpha 10 AP151 AP156
Payer Reference The reference number assigned to the AP180 AP28.1
Number bill of exchange payment. AP28.2 AP56.1
AP56.2 AP80.1
APT-STATEMENT-NBR Numeric 8 AP166 AP167
Statement Number The statement number assigned to the
bill of exchange payment.
APT-JRNL-BOOK-NBR Alpha 12
Journal Book The journal book assigned to the
transaction.
APT-DERIVED-STATUS Derived
Bill of Exchange The status of the bill of exchange
Status payment.
APT-VGROUP Derived
Vendor Group The vendor group associated with the
bill of exchange payment. Must be a
valid record in the Vendor Group file.
APT-SHORT-DFT-NAME Derived
Short Vendor Name 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-CODEThis index provides the elements which AP151 AP156
TRANS-IDENT keep a record in this file unique. AP166 AP180
AP213 AP260
AP28.1 AP28.2
AP284 AP56.1
AP56.2 AP80.1
CB300
APTSET10 CASH-CODE Subset AP181
PAY-GROUP Where (STATEMENT-NBR != Zeroes )
STATEMENT-NBR
DRAFT-NBR
SUFFIX
APTSET2 CASH-CODE This file is used to access bill of AP167 AP181
REC-STATUS exchange payment records by assigned
BANK-INST-CODEcash code.
DRAFT-NBR KeyChange
SUFFIX
TRANS-IDENT
COMPANY
VENDOR
APTSET3 PAY-GROUP This index is used to display all bill AP151 AP156
REC-STATUS of exchange payment records that require AP180 AP230
DRAFT-DATE acceptance or that have been accepted AP250 AP28.1
BANK-INST-CODEfor a company. AP28.2 AP56.1
DRAFT-NBR KeyChange, Subset AP56.2 AP80.1
SUFFIX Where REC-STATUS = 1
TRANS-IDENT Or REC-STATUS = 2
APTSET4 PAY-GROUP This index is used to sort all bill of AP198 AP266
VENDOR exchange payment records for a vendor. AP28.1 AP28.2
REC-STATUS KeyChange AP300
DRAFT-NBR
SUFFIX
BANK-INST-CODE
TRANS-IDENT
APTSET5 CASH-CODE This index is used to display all bill AP180 AP80.1
MATURITY-DATE of exchange payment records that are
PAY-GROUP available to be maintained for cashing
BANK-INST-CODEor dishonoring.
DRAFT-NBR KeyChange, Subset
SUFFIX Where GL-UPDATE-FL = "N"
TRANS-IDENT And REC-STATUS > 1
And REC-STATUS < 5
APTSET6 BANK-INST-CODEThis index is used to omit canceled AP151 AP156
DRAFT-NBR bill of exchange payments and is used to AP180 AP28.1
SUFFIX edit for duplicate bill of exchange AP28.2 AP56.1
VENDOR numbers. AP56.2 AP80.1
PAY-GROUP KeyChange, Subset
Where REC-STATUS != 5
APTSET7 PAY-GROUP This index is used to sort all bill of AP151 AP156
BANK-INST-CODEexchange payment records for a company AP180 AP28.1
VENDOR by bill of exchange type. AP28.2 AP305
DRAFT-NBR KeyChange AP56.1 AP56.2
SUFFIX AP80.1 AP91.2
TRANS-IDENT
APTSET8 VENDOR-GROUP KeyChange AP214 AP91.1
VENDOR
COMPANY
BANK-INST-CODE
TRANS-IDENT
APDRAFTS FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME 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 RELATED
NAME 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
|
