WikiAdmin: 1 revision imported

2023-07-14T12:58:48Z

1 revision imported

← Older revision

Revision as of 12:58, 14 July 2023

Chanson at 15:55, 23 February 2021

2021-02-23T15:55:40Z

New page

'''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
|style="background:#f6f6f6" |INTEGER
|-
| |TRANS_NO
|style="background:#f6f6f6" |INTEGER
|-
| |LINE_NO
|style="background:#f6f6f6" |SMALLINT
|-
| |PRODUCT_CODE
|style="background:#f6f6f6" |VARCHAR(20)
|-
| |DESCRIPTION
|style="background:#f6f6f6" |VARCHAR(35)
|-
| |RECEIVED_UM
|style="background:#f6f6f6" |VARCHAR(2)
|-
| |STOCK_UM
|style="background:#f6f6f6" |VARCHAR(2)
| |(Default: ARTPROD)
|-
| |QTY_DELIVERED
|style="background:#f6f6f6" |NUMERIC(15,4)
|-
| |UNIT_PRICE
|style="background:#f6f6f6" |NUMERIC(15,4)
|-
| |TAXABLE
|style="background:#f6f6f6" |CHAR(1)
|-
|}

===ARTRPRTRX===
Option 2:Existing Product Transaction Table
{|
|-
| |SESSION_NO
|style=“background:#f6f6f6” |INTEGER NOT NULL
|-
| |TRANS_NO
|style=“background:#f6f6f6” |INTEGER NOT NULL
|-
| |PRODUCT_CODE
|style=“background:#f6f6f6” |VARCHAR(20) NOT NULL
|-
| |UNIT_OF_MEASURE
|style=“background:#f6f6f6” |VARCHAR(2)
|-
| |QTY_CHANGE
|style=“background:#f6f6f6” |NUMERIC(15, 4) DEFAULT 0
|-
| |COST
|style=“background:#f6f6f6” |NUMERIC(15, 4) DEFAULT 0
|-
| |TRX_TYPE
|style=“background:#f6f6f6” |CHAR(1) NOT NULL
|-
| |TRX_DATE
|style=“background:#f6f6f6” |DATE NOT NULL
|-
| |TRX_TIME
|style=“background:#f6f6f6” |SMALLINT NOT NULL
|-
| |SRC_SESSION_NO
|style=“background:#f6f6f6” |INTEGER
|-
| |SRC_TRANS_NO
|style=“background:#f6f6f6” |INTEGER
|-
| |SRC_LINE_NO
|style=“background:#f6f6f6” |INTEGER
|-
| |RECONCILED_FLAG
|style=“background:#f6f6f6” |CHAR(1) DEFAULT 'N' NOT NULL
|-
| |INVENTORY_GL
|style=“background:#f6f6f6” |VARCHAR(20)
|-
| |OFFSET_GL
|style=“background:#f6f6f6” |VARCHAR(20)
|-
| |RECON_SESSION_NO
|style=“background:#f6f6f6” |INTEGER
|-
| |RECON_TRANS_NO
|style=“background:#f6f6f6” |INTEGER
|-
|}

==See Also:==
:[[Development]]
:[[Dev: Material Receipts System Design]]
:[[Dev: Purchase Order System Design]]

DEV: Bill of Lading - Revision history

WikiAdmin: 1 revision imported

Chanson at 15:55, 23 February 2021