WikiAdmin: 1 revision imported

2023-07-14T12:58:48Z

1 revision imported

← Older revision

Revision as of 12:58, 14 July 2023

Intra>User: 1 revision imported

2017-01-10T00:01:33Z

1 revision imported

New page

==Material Receipts==

Incoming Material system that:

* Tracks Incoming Material by Invoice or Ticket
* Scale House Operation to handle Gross/Tare similar to Outgoing system
* Tracks Cost of material similar to A/R Pricing System
** Vendor specific
** Job and/or PO Specific
* Links to
** Inventory
** A/P
** P/O
* A/P integration requires ability to
** Rollup several tickets into an invoice
** Match Quantity to Vendor Invoice
*** Accept/Reject based on variation
** Match Cost to Vendor Invoice
*** Accept/Reject based on variation
* P/O integration
** Invoice above will be tied to invoice
** Costs can be derived from PO
* Inventory
** Soft/Firm Inventory similar to A/R system
*** MatRect Tickets get counted like a/r tickets
*** Once moved to A/P invoice, inventory trx created.

===Design Decisions===

* Material Receipts Tickets:
** Store with ARTCK tickets with I/O flag
** Create MRTCKHD/DT table
* Should special costs be recorded in CCTJOB tables or just a PO table
** PO only … simplifies
** JOB gives special cost source when no PO reqd.Allows for

====ARTTCKHD====

{|
|-
| |SESSION_NO
|style="background:#f6f6f6" |INTEGER NOT NULL
|-
| |TRANS_NO
|style="background:#f6f6f6" |INTEGER NOT NULL
|-
| |CUST_NO
|style="background:#f6f6f6" |VARCHAR(10)
|-
| |TICKET_NO
|style="background:#f6f6f6" |INTEGER DEFAULT 0
|-
| |TICKET_DATE
|style="background:#f6f6f6" |DATE NOT NULL
|-
| |SLUMP
|style="background:#f6f6f6" |NUMERIC(9 2)
|-
| |MILES
|style="background:#f6f6f6" |NUMERIC(9 2) DEFAULT 0
|-
| |TICKET_TIME
| |SMALLINT
|-
| |SALESPERSON
|style="background:#f6f6f6" |VARCHAR(2)
|-
| |SYS_LOC
|style="background:#f6f6f6" |INTEGER DEFAULT 0 NOT NULL
|-
| |PLANT_NO
|style="background:#f6f6f6" |VARCHAR(3)
|-
| |TAX_AUTHORITY
|style="background:#f6f6f6" |VARCHAR(4)
|-
| |JOB_PO_LOC
|style="background:#f6f6f6" |VARCHAR(18)
|-
| |JOB_LOT
|style="background:#f6f6f6" |VARCHAR(18)
|-
| |JOB_BLOCK
|style="background:#f6f6f6" |VARCHAR(18)
|-
| |JOB_CLASS
|style="background:#f6f6f6" |VARCHAR(2)
|-
| |ORDER_CODE
|style="background:#f6f6f6" |VARCHAR(18)
|-
| |ORDER_SESSION_NO
|style="background:#f6f6f6" |INTEGER
|-
| |ORDER_TRANS_NO
|style="background:#f6f6f6" |INTEGER
|-
| |ORDER_LOAD_NO
|style="background:#f6f6f6" |INTEGER
|-
| |USAGE_TYPE
|style="background:#f6f6f6" |VARCHAR(2)
|-
| |TRUCK_NO
|style="background:#f6f6f6" |VARCHAR(5)
|-
| |TRUCK_BROKER (OWNER)
| |VARCHAR(10)
| |
|-
| |TRUCK_PMT_METHOD
| |CHAR(1)
| |
|-
| |TRUCK_PMT_DUE(????)
| |NUMERIC(15,2)
| |
|-
| |TRAILER_1
|style="background:#f6f6f6" |VARCHAR(5)
|-
| |TRAILER_2
|style="background:#f6f6f6" |VARCHAR(5)
|-
| |SOURCE_FLAG
|style="background:#f6f6f6" |CHAR(1) DEFAULT 'M' NOT NULL
|-
| |VOID_FLAG
|style=“background:#f6f6f6” |CHAR(1) DEFAULT 'N' NOT NULL
|-
| |VOID_LOC
|style=“background:#f6f6f6” |INTEGER
|-
| |VOID_SESSION_NO
|style=“background:#f6f6f6” |INTEGER
|-
| |VOID_REASON
|style=“background:#f6f6f6” |VARCHAR(80)
|-
| |PRICED_FLAG
|style=“background:#f6f6f6” |CHAR(1) DEFAULT 'N' NOT NULL
|-
| |OFFICE_PRICE_FLAG
|style=“background:#f6f6f6” |CHAR(1) DEFAULT 'N' NOT NULL
|-
| |ZONE
|style=“background:#f6f6f6” |VARCHAR(6)
|-
| |COD_FLAG
|style=“background:#f6f6f6” |CHAR(1) DEFAULT 'N' NOT NULL
|-
| |ELAPSED_TIME
| |SMALLINT
|-
| |BATCH_START_DT
|style=“background:#f6f6f6” |TIMESTAMP
|-
| |BATCH_END_DT
|style=“background:#f6f6f6” |TIMESTAMP
|-
| |LEAVE_PLANT_DT
|style=“background:#f6f6f6” |TIMESTAMP
|-
| |ARRIVE_JOB_DT
|style=“background:#f6f6f6” |TIMESTAMP
|-
| |BEGIN_POUR_DT
|style=“background:#f6f6f6” |TIMESTAMP
|-
| |END_POUR_DT
|style=“background:#f6f6f6” |TIMESTAMP
|-
| |LEAVE_JOB_DT
|style=“background:#f6f6f6” |TIMESTAMP
|-
| |RETURN_PLANT_DT
|style=“background:#f6f6f6” |TIMESTAMP
|-
| |TGT_BATCH_START_DT
|style=“background:#f6f6f6” |TIMESTAMP
|-
| |TGT_BATCH_END_DT
|style=“background:#f6f6f6” |TIMESTAMP
|-
| |TGT_LEAVE_PLANT_DT
|style=“background:#f6f6f6” |TIMESTAMP
|-
| |TGT_ARRIVE_JOB_DT
|style=“background:#f6f6f6” |TIMESTAMP
|-
| |TGT_BEGIN_POUR_DT
|style=“background:#f6f6f6” |TIMESTAMP
|-
| |TGT_END_POUR_DT
|style=“background:#f6f6f6” |TIMESTAMP
|-
| |TGT_LEAVE_JOB_DT
|style=“background:#f6f6f6” |TIMESTAMP
|-
| |TGT_RETURN_PLANT_DT
|style=“background:#f6f6f6” |TIMESTAMP
|-
| |CUSTOMER_PO
|style=“background:#f6f6f6” |VARCHAR(20)
|-
| |DRIVER
|style=“background:#f6f6f6” |VARCHAR(10)
|-
| |PAYMENT_AMOUNT
| |NUMERIC(15 2) DEFAULT 0
|-
| |CHECK_DATE
|style=“background:#f6f6f6” |DATE
|-
| |CHECK_NO
|style=“background:#f6f6f6” |VARCHAR(10)
|-
| |BANK_NO
|style=“background:#f6f6f6” |VARCHAR(10)
|-
| |SHIP_TO_1
|style=“background:#f6f6f6” |VARCHAR(30)
|-
| |SHIP_TO_2
|style=“background:#f6f6f6” |VARCHAR(30)
|-
| |SHIP_TO_3
|style=“background:#f6f6f6” |VARCHAR(30)
|-
| |SHIP_TO_4
|style=“background:#f6f6f6” |VARCHAR(30)
|-
| |DELV_INST_1
|style=“background:#f6f6f6” |VARCHAR(30)
|-
| |DELV_INST_2
|style=“background:#f6f6f6” |VARCHAR(30)
|-
| |DELV_INST_3
|style=“background:#f6f6f6” |VARCHAR(30)
|-
| |DELV_INST_4
|style=“background:#f6f6f6” |VARCHAR(30)
|-
| |WEATHER
|style=“background:#f6f6f6” |VARCHAR(20)
|-
| |WEIGHMASTER
|style=“background:#f6f6f6” |VARCHAR(20)
|-
| |VEND_ID
|style=“background:#f6f6f6” |VARCHAR(12)
| |
|-
| |SOURCE_LOC_ID
|style=“background:#f6f6f6” |
| |
|-
| |SOURCE_TICKET_NO
|style=“background:#f6f6f6” |VARCHAR(12)
| |Handle possibilitiy of source with Alph tkt Nos.
|-
| |SOURCE_TICKET_DATE
|style=“background:#f6f6f6” |DATE
| |
|-
| |SOURCE_TICKET_TIME
|style=“background:#f6f6f6” |SHORTINT
| |HHMM
|-
| |SOURCE_GROSS
|style=“background:#f6f6f6” |NUMERIC(15,2)
| |
|-
| |SOURCE_TARE
|style=“background:#f6f6f6” |NUMERIC(15,2)

| |
|-
| |SOURCE_WEIGHT_UMS
|style=“background:#f6f6f6” |
| |
|-
| |SOURCE_WEIGHT_FLAG
|style=“background:#f6f6f6” |CHAR(1)
| |
|-
| |CUSTOM_1
|style=“background:#f6f6f6” |VARCHAR(20)
|-
| |CUSTOM_2
|style=“background:#f6f6f6” |VARCHAR(20)
|-
| |INV_ADJUST_FLAG
|style=“background:#f6f6f6” |CHAR(1) DEFAULT 'N' NOT NULL
|-
| |HOLD_FLAG
|style=“background:#f6f6f6” |CHAR(1) DEFAULT 'N' NOT NULL
|-
| |INTRA_CO_FLAG
|style=“background:#f6f6f6” |CHAR(1) y/n
| |
|-
| |INV_SESSION_NO
|style="background:#f6f6f6" |INTEGER
| |
|-
| |IMPORTED_FLAG
|style="background:#f6f6f6" |CHAR(1) DEFAULT 'N' NOT NULL
| |
|-
| |MEMO
|style="background:#f6f6f6" |BLOB SUB_TYPE TEXT SEGMENT SIZE 80
| |
|-
| |LAST_CHANGE_DATETIME
|style="background:#f6f6f6" |TIMESTAMP
|-
| |LAST_CHANGE_USER
|style="background:#f6f6f6" |VARCHAR(10)
|}
CONSTRAINT ARTTCKHD_KEY PRIMARY KEY (SESSION_NO, TRANS_NO));

See Also:
:[[Development]]
:[[Dev: Purchase Order System Design]]

Dev: Material Receipts System Design - Revision history

WikiAdmin: 1 revision imported

Intra>User: 1 revision imported