APDRAFTS – AP Bill of Exchange

System: Accounts Payable (AP)
Prefix: APT
Primary key: BANK-INST-CODE, TRANS-IDENT
Fields: 43
Updated by: 38 programs
Referenced by: 62 programs

APDRAFTS is the AP Bill of Exchange table in Lawson Accounts Payable (prefix APT). It is indexed by BANK-INST-CODE, TRANS-IDENT (APTSET1); alternate indexes: APTSET10, APTSET2, APTSET3, APTSET4, APTSET5, APTSET6, APTSET7 and APTSET8. It is related 1:1 to APCOMPANY, APPAYGROUP, APPROCLEV, APVENBAL, APVENMAST, APVENLOC, CBBANKENT, CBBANKINST and 3 more and 1:M to APAPPHIST, APDRFTDIST and APPAYMENT. It is updated by AP125, AP126, AP151, AP156, AP166, AP167, AP180, AP181 and 30 more and referenced by AP10.1, AP10.2, AP100, AP109, AP110, AP111, AP115, AP136 and 54 more. The table has 43 fields, 9 indexes and 15 documented relations.

About APDRAFTS

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

Fields (43)

Column = COBOL field name without the APT- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / column	Type	Description & values	Updated by
`APT-PAY-GROUP` 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 +25 more
`APT-COMPANY` 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 +25 more
`APT-TRANS-IDENT` PK TRANS_IDENT	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 +25 more
`APT-VENDOR-GROUP` 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 +25 more
`APT-VENDOR` 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 +25 more
`APT-VENDOR-VNAME` VENDOR_VNAME	Alpha 30 (Lower Case)	The vendor name or description.	AP125, AP126, AP151, AP156, AP180, AP20.1, AP20.2, AP20.3 +25 more
`APT-BANK-INST-CODE` PK BANK_INST_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 +25 more
`APT-DRAFT-NBR` DRAFT_NBR	Alpha 10 (Right Justified)	The bill of exchange number.	AP125, AP126, AP151, AP156, AP180, AP20.1, AP20.2, AP20.3 +25 more
`APT-SUFFIX` SUFFIX	Numeric 3	The bill of exchange suffix number.	AP125, AP126, AP151, AP156, AP180, AP20.1, AP20.2, AP20.3 +25 more
`APT-PROC-LEVEL` PROC_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 +25 more
`APT-REMIT-TO-CODE` 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 +25 more
`APT-PMT-DOC-ORIGIN` PMT_DOC_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 +25 more
`APT-CASH-CODE` 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 +25 more
`APT-CURRENCY-CODE` CURRENCY_CODE	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 +25 more
`APT-DRAFT-AMOUNT` DRAFT_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 +25 more
`APT-APPLIED-AMT` APPLIED_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 +25 more
`APT-TRAN-ND` TRAN_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 +25 more
`APT-ORIG-RATE` ORIG_RATE	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 +25 more
`APT-BASE-ORIG-AMT` BASE_ORIG_AMT	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 +25 more
`APT-BASE-ACT-AMT` BASE_ACT_AMT	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 +25 more
`APT-BASE-ND` BASE_ND	Numeric 1	The number of decimal positions defined for the company base currency.	AP125, AP126, AP151, AP156, AP180, AP20.1, AP20.2, AP20.3 +25 more
`APT-ACT-RATE` ACT_RATE	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 +25 more
`APT-DRAFT-DATE` DRAFT_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 +25 more
`APT-MATURITY-DATE` MATURITY_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 +25 more
`APT-ACCEPT-DATE` ACCEPT_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 +25 more
`APT-CASH-DATE` CASH_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 +25 more
`APT-DISHONOR-DATE` 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 +25 more
`APT-CANCEL-DATE` CANCEL_DATE	Numeric 8 (yyyymmdd)	The date the bill of exchange was canceled.	AP125, AP126, AP151, AP156, AP180, AP20.1, AP20.2, AP20.3 +25 more
`APT-CASH-COMPANY` CASH_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 +25 more
`APT-REC-STATUS` 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 +25 more
`APT-PRINT-STATUS` 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 +25 more
`APT-ACPT-ACCT-UNIT` ACPT_ACCT_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 +25 more
`APT-ACPT-ACCOUNT` ACPT_ACCOUNT	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 +25 more
`APT-ACPT-SUB-ACCT` ACPT_SUB_ACCT	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 +25 more
`APT-DRAFT-CODE` DRAFT_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 +25 more
`APT-GL-UPDATE-FL` GL_UPDATE_FL	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 +26 more
`APT-POST-DATE` 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 +25 more
`APT-PAYER-REF` PAYER_REF	Alpha 10	The reference number assigned to the bill of exchange payment.	AP125, AP126, AP151, AP156, AP180, AP20.1, AP20.2, AP20.3 +25 more
`APT-STATEMENT-NBR` STATEMENT_NBR	Numeric 8	The statement number assigned to the bill of exchange payment.	AP166, AP167
`APT-JRNL-BOOK-NBR` JRNL_BOOK_NBR	Alpha 12	The journal book assigned to the transaction.	AP125, AP126, AP151, AP156, AP180, AP20.1, AP20.2, AP20.3 +25 more
`APT-DERIVED-STATUS` DERIVED_STATUS	Derived	The status of the bill of exchange payment.	—
`APT-VGROUP` VGROUP	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` SHORT_DFT_NAME	Derived	A short (20-character) name for the vendor associated with the bill of exchange payment.	—

Indexes (9)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

Index	Keys	Flags	Condition	Used in
`APTSET1`	`BANK-INST-CODE`, `TRANS-IDENT`	Primary		AP10.1, AP10.2, AP100, AP109, AP110, AP111, AP115, AP125 +22 more (list truncated in source)
`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	Where REC-STATUS = 1 Or REC-STATUS = 2	AP125, AP126, AP151, AP156, AP180, AP20.1, AP20.2, AP20.3 +22 more (list truncated in source)
`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	Where GL-UPDATE-FL = "N" And REC-STATUS > 1 And REC-STATUS < 5	AP180, AP80.1
`APTSET6`	`BANK-INST-CODE`, `DRAFT-NBR`, `SUFFIX`, `VENDOR`, `PAY-GROUP`	KeyChange, Subset	Where REC-STATUS != 5	AP125, AP126, AP151, AP156, AP180, AP20.1, AP20.2, AP20.3 +22 more (list truncated in source)
`APTSET7`	`PAY-GROUP`, `BANK-INST-CODE`, `VENDOR`, `DRAFT-NBR`, `SUFFIX`, `TRANS-IDENT`	KeyChange		AP125, AP126, AP151, AP156, AP180, AP20.1, AP20.2, AP20.3 +22 more (list truncated in source)
`APTSET8`	`VENDOR-GROUP`, `VENDOR`, `COMPANY`, `BANK-INST-CODE`, `TRANS-IDENT`	KeyChange		AP214, AP91.1

Relations

One to one (12) — lookups and parents

Relation	Table	Rules	Field map
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`

One to many (3) — child tables

Relation	Table	Field map
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`

Programs

Updated by (38)

AP125 Batch Release
AP126 Mass Invoice Release
AP151 Bill of Exchange Generation
AP156 Bill of Exchange Creation
AP166 Bill of Exchange Bank Statement
AP167 Bill of Exchange Cashing Statement
AP180 Bill of Exchange Cashing Update
AP181 Bill of Exchange Statement Update
AP20.1 Basic Invoice
AP20.2 Taxed Invoice
AP20.3 Detail Invoice
AP20.4 Invoice Line Detail
AP20.5 Multiple Invoice
AP20.7 Distributions
AP20.8 Payment Schedule
AP21.1 View Distributions
AP23.1 Transit Invoice Entry
AP25.1 Batch Control
AP25.2 Batch Review
AP26.1 Invoice Release
AP27.1 Single Invoice Release
AP28.1 Bill of Exchange Acceptance by Vendor
AP28.2 Bill of Exchange Acceptance by Date
AP305 Accounts Payable Company Purge
AP56.1 Bill of Exchange Entry
AP56.2 Bill of Exchange Invoice Application
AP80.1 Bill of Exchange Cashing Selection
CB300 History Purge
MA41.1 Add-On Cost Detail - Purchase Order
MA41.2 Add On Cost Lookup
MA41.4 Miscellaneous Add-On Cost
MA41.7 AOC Approval Entry
MA42.2 Memo Line AOC Detail
MA43.2 Purchase Order Lookup
MA44.1 Invoice Line Detail - Purchase Order
MA44.2 Invoice Line Detail- Service
MA61.1 Match Invoice Approval
MAI1.1 Invoke for MAMATCH Object

Referenced by (62)

AP10.1 Vendor
AP10.2 Vendor Location
AP100 Vendor Group Copy
AP109 Vendor Current Address Update
AP110 Mass Vendor Update
AP111 Vendor Deletion
AP115 Vendor Merge
AP136 Invoice Accrual Reconciliation
AP14.1 Vendor Contact
AP14.2 Vendor Contact Address
AP14.5 1099 Tax Identification Information
AP150 Cash Requirements
AP16.1 Vendor Bank
AP16.2 Vendor Location Bank
AP160 Payment Tape Creation
AP161 Electronic Payment File Creation
AP170 Payment Closing
AP190 Invoice Reinstatement
AP193 Recurring Invoice Update
AP213 Vendor Account Balance
AP214 Bill of Exchange Maturity List
AP230 Open Payables Report
AP232 Invoice Accrual Reconciliation Report
AP250 Cash Forecasting
AP266 Bill of Exchange Report
AP284 Vendor Grand Livre
AP30.1 Invoice Maintenance
AP30.2 Distribution Adjustments
AP30.4 Invoice Cancel
AP300 Invoice and Vendor History Purge
AP510 Vendor Conversion
AP520 Invoice Interface
AP590 AP Vendor CSV
AP91.1 Vendor Activity
AP91.2 Bill of Exchange Inquiry
API1.1 Add Invoice
API2.1 Add Invoice
CB00.1 Bank
CB10.1 Cash Receipt Deposit
CB150 Mass Release
EE135 Mass Employee Release
EE20.1 Employee Advance
EE20.2 Employee Expense
EE35.1 Advance Release
EE35.2 Expense Release
EE520 Expense Interface
IC64.6 Global Location Number Assignment Vendor
MA60.2 Invoice Level Match
MA60.3 Detail Level Match
MA60.4 Invoice Match Reference Adjustment
MA64.6 Message Detail by Invoice
MA64.9 PO Cost Message Accept Upload
MA65.1 Invoice Line Adjustment
MA66.1 Review Invoice Message
MA66.2 Invoice Message - Details
MA66.3 Purchase Order Cost Review Message
MA67.3 Detail Match from frontend
MA68.2 Invoice Level Match - Prepaid
MA68.4 Invoice Match Reference Adjustment
MA70.1 Invoice Unmatch
MA75.1 PO Invoice Cancel
MAED.1 Vendor