DEV: Bill of Lading
NOTE - This is an old concept page --- PO Receipts handles this for Purchases. Matl Recpts for ticketing still in consideration.
The Bill of Lading system is the key subsystem to track incoming materials and interface with Inventory, Accounts Receivable and other parts of keystone.
Integration with application
Accounts Payable
Multiple Bills of Lading can be connected to one Invoice Header record (APTINVHD). BOLs can be created independently of Account Payable or on the fly in invoice vouchering.
Inventory
Bills of Lading will be processed as Purchase Receipts to inventory.
Job Cost
Potentially In the future ... Job Cost will support Bills of Lading as detail to backup cost on a Job.
Material Receipts
The Material Receipts system will create Bills of Lading from incoming Material tickets.
Bill of Lading
BLTBLHD
| SESSION_NO | INTEGER | |
| TRANS_NO | INTEGER | |
| VENDOR_ID | VARCHAR | |
| BL_NO | INTEGER | (AUTOMATICALLY ASSIGEND) |
| PO_SESSION_NO | INTEGER | |
| PO_TRANS_NO | INTEGER | |
| AP_SESSION_NO | INTEGER | |
| AP_TRANS_NO | INTEGER | |
| RECEIVED_DT | TIMESTAMP | |
| VEND_BL_NO | VARCHAR(12) |
BLTBLDT
Option 1: New Bill of Lading Detail Table
| SESSION_NO | INTEGER | |
| TRANS_NO | INTEGER | |
| LINE_NO | SMALLINT | |
| PRODUCT_CODE | VARCHAR(20) | |
| DESCRIPTION | VARCHAR(35) | |
| RECEIVED_UM | VARCHAR(2) | |
| STOCK_UM | VARCHAR(2) | (Default: ARTPROD) |
| QTY_DELIVERED | NUMERIC(15,4) | |
| UNIT_PRICE | NUMERIC(15,4) | |
| TAXABLE | CHAR(1) |
ARTRPRTRX
Option 2:Existing Product Transaction Table
| SESSION_NO | INTEGER NOT NULL |
| TRANS_NO | INTEGER NOT NULL |
| PRODUCT_CODE | VARCHAR(20) NOT NULL |
| UNIT_OF_MEASURE | VARCHAR(2) |
| QTY_CHANGE | NUMERIC(15, 4) DEFAULT 0 |
| COST | NUMERIC(15, 4) DEFAULT 0 |
| TRX_TYPE | CHAR(1) NOT NULL |
| TRX_DATE | DATE NOT NULL |
| TRX_TIME | SMALLINT NOT NULL |
| SRC_SESSION_NO | INTEGER |
| SRC_TRANS_NO | INTEGER |
| SRC_LINE_NO | INTEGER |
| RECONCILED_FLAG | CHAR(1) DEFAULT 'N' NOT NULL |
| INVENTORY_GL | VARCHAR(20) |
| OFFSET_GL | VARCHAR(20) |
| RECON_SESSION_NO | INTEGER |
| RECON_TRANS_NO | INTEGER |