http://in.compucrete.com/index.php?action=history&feed=atom&title=Dev%3A_Purchase_Order_System_Design
Dev: Purchase Order System Design - Revision history
2026-05-15T16:29:59Z
Revision history for this page on the wiki
MediaWiki 1.40.0
http://in.compucrete.com/index.php?title=Dev:_Purchase_Order_System_Design&diff=130&oldid=prev
WikiAdmin: 1 revision imported
2023-07-14T12:58:49Z
<p>1 revision imported</p>
<table style="background-color: #fff; color: #202122;" data-mw="interface">
<col class="diff-marker" />
<col class="diff-content" />
<col class="diff-marker" />
<col class="diff-content" />
<tr class="diff-title" lang="en">
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td>
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 12:58, 14 July 2023</td>
</tr>
<!-- diff cache key my_wiki:diff::1.12:old-129:rev-130 -->
</table>
WikiAdmin
http://in.compucrete.com/index.php?title=Dev:_Purchase_Order_System_Design&diff=129&oldid=prev
Intra>User: 1 revision imported
2017-01-10T00:01:33Z
<p>1 revision imported</p>
<p><b>New page</b></p><div>==Integration==<br />
===Account Payable===<br />
Invoice records (APTINVHD) will be tied to Purchase Orders rocords.<br />
<br />
<br />
===Bill of Lading===<br />
Bill of Lading records act as the detail for material received on a Purchase Order Detail records.<br />
<br />
<br />
<br />
<br />
==Table Layout==<br />
===POTPOHD===<br />
<br />
{| <br />
|- <br />
| |SESSION_NO<br />
|style="background:#f6f6f6" |INTEGER<br />
|-<br />
| |TRANS_NO<br />
|style="background:#f6f6f6" |INTEGER<br />
|-<br />
| |VENDOR_ID<br />
|style="background:#f6f6f6" |VARCHAR(10)<br />
|-<br />
| |PO_NO<br />
|style="background:#f6f6f6" |INTEGER<br />
|-<br />
| |PO_AMOUNT<br />
|style="background:#f6f6f6" |NUMERIC(15,4)<br />
| |(Recalced as needed)<br />
|-<br />
| |STATUS<br />
|style="background:#f6f6f6" |CHAR(1)<br />
| |New /order Placed/Complete/Cancelled/BackOrder??<br />
|-<br />
| |CONTACT<br />
|style="background:#f6f6f6" |VARCHAR(20)<br />
| |(LINK TO CCTCONTACT??)<br />
|-<br />
| |PHONE_NO<br />
|style="background:#f6f6f6" |VARCHAR(30)<br />
|-<br />
| |PAYMENT_TERMS<br />
|style="background:#f6f6f6" |VARCHAR(2)<br />
| |(Default: APTVEND)<br />
|-<br />
| |ORDER_DATE<br />
|style="background:#f6f6f6" |DATE<br />
| |(Default: Today)<br />
|-<br />
| |EXPECTED_DATE<br />
|style="background:#f6f6f6" |DATE<br />
|-<br />
| |TAX_AUTHORITY<br />
|style="background:#f6f6f6" |VARCHAR(4)<br />
| |(Default: ARTPLANT)<br />
|-<br />
| |EXPIRATION_DATE<br />
|style="background:#f6f6f6" |DATE<br />
|-<br />
| |ORDERED_BY<br />
|style="background:#f6f6f6" |VARCHAR(10)<br />
|-<br />
| |AUTHORIZED_BY<br />
|style="background:#f6f6f6" |VARCHAR(10)<br />
|-<br />
| |????BUDGET_DATE<br />
|style="background:#f6f6f6" |DATE<br />
| |(Warns if attempt to post trx on any other date)<br />
|-<br />
| |-- also consider<br />
|-<br />
| |JOB info<br />
|-<br />
| |SHIP_TO (1-4)<br />
| |<br />
| |<br />
|-<br />
| |SHIP VIA<br />
| |<br />
| |<br />
|-<br />
| |CONDITION_1<br />
|style="background:#f6f6f6" |VARCHAR(40)<br />
|-<br />
| |CONDITION_2<br />
|style="background:#f6f6f6" |VARCHAR(40)<br />
|-<br />
| |CONDITION_3<br />
|style="background:#f6f6f6" |VARCHAR(40)<br />
|-<br />
| |CONDITION_4<br />
|style="background:#f6f6f6" |VARCHAR(40)<br />
|-<br />
| |INSTRUCTION_1<br />
|style="background:#f6f6f6" |VARCHAR(40)<br />
|-<br />
| |INSTRUCTION_2<br />
|style="background:#f6f6f6" |VARCHAR(40)<br />
|-<br />
| |INSTRUCTION_3<br />
|style="background:#f6f6f6" |VARCHAR(40)<br />
|- <br />
| |INSTRUCTION_4<br />
|style="background:#f6f6f6" |VARCHAR(40)<br />
|}<br />
<br />
===POTPODET===<br />
<br />
{| <br />
|- <br />
| |SESSION_NO<br />
|style="background:#f6f6f6" |INTEGER<br />
|-<br />
| |TRANS_NO<br />
|style="background:#f6f6f6" |INTEGER<br />
|-<br />
| |LINE_NO<br />
|style="background:#f6f6f6" |SMALLINT<br />
|-<br />
| |PRODUCT_CODE<br />
|style="background:#f6f6f6" |VARCHAR(20)<br />
|-<br />
| |DESCRIPTION<br />
|style="background:#f6f6f6" |VARCHAR(35)<br />
|-<br />
| |ORDER_UM<br />
|style="background:#f6f6f6" |VARCHAR(2)<br />
|-<br />
| |STOCK_UM<br />
|style="background:#f6f6f6" |VARCHAR(2)<br />
| |(Default: ARTPROD)<br />
|-<br />
| |QTY_ORDERED<br />
|style="background:#f6f6f6" |NUMERIC(15,4)<br />
|-<br />
| |QTY_DELIVERED<br />
|style="background:#f6f6f6" |NUMERIC(15,4)<br />
|-<br />
| |UNIT_PRICE<br />
|style="background:#f6f6f6" |NUMERIC(15,4)<br />
|-<br />
| |TAXABLE<br />
|style="background:#f6f6f6" |CHAR(1)<br />
|-<br />
|}<br />
<br />
==PO issues to consider….==<br />
<br />
* Header / Detail Possibilities<br />
** PLANT_NO / TAX_AUTHORITY<br />
** ALLOW_BACKORDER<br />
* Freight Handling – by detail line?Flat / per Unit?Require separate detail entry?<br />
* PO # range by plant / prefixing / masking?<br />
<br />
<br />
*PO Items may be…<br />
<br />
**Resalable or not<br />
**Stocked or non-stocked<br />
**uncoded??? Items<br />
**Misc Items<br />
**Services<br />
*Linking to Assets (future)<br />
*Parts for trucks<br />
*Plants<br />
*After the fact linking to parts/plants<br />
*INVENTORY ITEMS VS PRODUCTS - Place all in ARTPROD?<br />
*Material Receipts Integration<br />
*Security<br />
<br />
<br />
==Strategy options for tracking incoming material==<br />
<br />
*Bill of Lading Header Detail<br />
*Tickets flagged in inbound<br />
*$$$ only from AP (where inventory tracking is not needed) (To be considered)<br />
<br />
<br />
===APTINVDT===<br />
<br />
Preliminary --- Most Changes Unlikely<br />
{| <br />
|- <br />
||PO_SESSION_NO<br />
||INTEGER<br />
|- <br />
||PO_TRANS_NO<br />
||INTEGER<br />
|- <br />
||PO_LINE_NO<br />
||SMALLINT<br />
|}<br />
<br />
<br />
See Also:<br />
:[[Development]] Development Home Page<br />
:[[DEV: Bill of Lading]]<br />
:[[Dev: Material Receipts System Design]]</div>
Intra>User