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