Billing – Lawson BL tables and programs
Billing (BL) in Lawson S3 v10 MSP6 has 43 tables, 3 online screens and 0 batch programs.
Tables (43)
| Table | Prefix | Description | Primary key | Fields |
|---|---|---|---|---|
| BLOEIUF | BIU | The Invoice User Fields file contains user fields that can be entered on Invoice headers. | COMPANY, INVC-PREFIX, INVC-NUMBER | 8 |
| BLOILUF | BDU | The Invoice Line User Fields file contains user fields that can be entered on Invoice lines. | COMPANY, INVC-PREFIX, INVC-NUMBER, LINE-NBR | 9 |
| BLRICCOMM | BUC | Cust. Recurring Invc Comment | COMPANY, RECUR-INVOICE, CUSTOMER, LINE-NBR, SEQ | 9 |
| BLRICLINE | BUL | Cust. Recurring Invc Item | COMPANY, RECUR-INVOICE, CUSTOMER, LINE-NBR | 51 |
| BLRICUST | BRC | Customer Recurring Invoice | COMPANY, RECUR-INVOICE, CUSTOMER | 43 |
| BLRIMCOMM | BMC | Recurring Invoice Comment | COMPANY, RECUR-INVOICE, LINE-NBR, SEQ | 7 |
| BLSHPUF | BSU | Ship To User Field | COMPANY, CUSTOMER, SHIP-TO | 11 |
| BLUSRFLDEF | BUD | The User Field Definition file defines user field types and user field data types. | USER-FLD-TYPE, COMPANY | 10 |
| CUSTEP | CEP | No description in the Lawson data dictionary | COMPANY, CUSTOMER, EP-TYPE, EP-ACCOUNT | 8 |
| EPBATCH | EPB | No description in the Lawson data dictionary | COMPANY, EP-BATCH-ID | 35 |
| EPTRANS | EPT | No description in the Lawson data dictionary | EP-TRANS-ID, COMPANY | 26 |
| EPTYPE | ETY | Electronic Payment Type | COMPANY, EP-TYPE | 14 |
| ITEMADDON | ITA | Item Add On Cost | COMPANY, ITEM, STATE, CUSTOMER, MISC | 5 |
| OEBASE | OEB | Base Price | COMPANY, LOCATION, BASE-NAME, CURRENCY-CODE, ITEM | 30 |
| OECOMMHDR | OCH | Order Entry Comment Header | COMPANY, STD-COMM | 4 |
| OECOMPANY | OEC | Order Entry Company | COMPANY | 94 |
| OECOMPREF | OEL | Company | COMPANY, PROCESS-LEVEL, TYPE | 5 |
| OECUSTCODE | OCD | Order Entry Customer Codes | COMPANY, CUSTOMER-CODE | 5 |
| OECUSTITEM | OCI | Customer Item Xref | COMPANY, CUSTOMER, ITEM, CUST-ITEM | 7 |
| OEDISCOUNT | OED | Discount Code | COMPANY, DISC-CODE | 28 |
| OEDIST | ODI | Order Entry GL Distribution | COMPANY, GL-DATE, ACCT-UNIT, ACCOUNT, SUB-ACCOUNT, INVC-PREFIX, INVC-NUMBER, AUTH-NO, LINE-NBR, SEQ, POSTING-TYPE | 21 |
| OEFRTCODE | OFR | Order Entry Freight Code | COMPANY, FRT-CODE | 11 |
| OEINVCCOMM | OIC | Invoice Comments | COMPANY, INVC-PREFIX, INVC-NUMBER, LINE-NBR, SEQ | 6 |
| OEINVCDTL | OID | Invoice Lot/Serial/Bin Dtls | COMPANY, INVC-PREFIX, INVC-NUMBER, LINE-NBR, UOM, LOT, SUBLOT, BIN, SERIAL | 17 |
| OEINVCLINE | OIL | Invoice Line | COMPANY, INVC-PREFIX, INVC-NUMBER, LINE-NBR | 109 |
| OEINVCMISC | OIM | Invoice Miscellaneous Charges | COMPANY, INVC-PREFIX, INVC-NUMBER, LINE-NBR, SEQ | 53 |
| OEINVCTAX | OIT | Invoice Taxes | COMPANY, INVC-PREFIX, INVC-NUMBER, LINE-NBR, SEQ, TAX-CODE, TAX-LEVEL | 17 |
| OEINVCTYPE | OIN | Invoice Type | COMPANY, INVC-TYPE | 15 |
| OEINVCUOM | OEU | Invoice Unit of Measures | COMPANY, INVC-PREFIX, INVC-NUMBER, LINE-NBR | 39 |
| OEINVHDR | OIH | Invoice Header | COMPANY, BATCH-NBR | 10 |
| OEINVOICE | OEI | Invoice | COMPANY, INVC-PREFIX, INVC-NUMBER | 150 |
| OEINVSGBLK | OSB | No description in the Lawson data dictionary | COMPANY, INVC-PREFIX, INVC-NUMBER, LINE-NBR, SEQ | 6 |
| OEMISC | OEM | Customer Order Misc Charges | COMPANY, MISC, CURRENCY-CODE | 31 |
| OEORDDISC | OOD | Order Discount | COMPANY, ORD-DISC-CODE, CURRENCY-CODE | 9 |
| OEPLCLASS | OPC | Price List Sales Class | COMPANY, CUSTOMER, LIST-NAME, PROMOTION, SALES-MAJCL, SALES-MINCL | 14 |
| OEPLITEM | OPI | Price List Item | COMPANY, CUSTOMER, LIST-NAME, PROMOTION, ITEM | 25 |
| OEPRCLIST | OPL | Price List | COMPANY, CUSTOMER, LIST-NAME, PROMOTION | 25 |
| OEPROCLEV | OEP | Order Entry Process Level | COMPANY, PROCESS-LEVEL | 73 |
| OEREASON | OER | Cancellation Reason Code | COMPANY, REASON-CODE | 8 |
| OESLSACCT | OSA | Sales Accounts | COMPANY, PROCESS-LEVEL, SALES-MAJCL, SALES-MINCL | 18 |
| OESTDCOMM | OSC | Order Entry Standard Comments | COMPANY, STD-COMM, LANGUAGE-CODE, SEQ | 8 |
| SHIPTO | SHP | Customer Ship To Address | COMPANY, CUSTOMER, SHIP-TO | 52 |
| SHPBOD | BBB | No description in the Lawson data dictionary | COMPANY, CUSTOMER, SHIP-TO | 9 |
Online screens (3)
Other tables used by Billing programs (6)
ARCOMMENT, COLINE, CUSTORDER, OEORDCMNT, RETURNHDR, RETURNLINE