receipt
- Last UpdatedNov 20, 2024
- 2 minute read
Note: This table is currently not used.
The receipt table contains receipts from vendors. Its design is the result of wanting to be able to receive goods without having the PO for them predefined; thus there is no required relation between this table and PO. It is assumed that the PO "number" would be referenced on the paperwork accompanying the shipment, so that it can be correctly entered initially, and thus is part of the primary key. It is also assumed that the vendor if known is defined before the shipment arrives, and thus has an ID number. All the non-key fields which are not auditing-related are nullable so records can be entered with incomplete knowledge of the circumstances, rather than forcing the entry of arbitrary, and probably incorrect, information.
|
Field |
Datatype |
PK |
Nulls? |
Description |
|---|---|---|---|---|
|
po_id |
string40 |
Y |
N |
Identify PO |
|
po_line_no |
int32 |
N |
Y |
Which line in PO |
|
date_rcvd_utc |
tdatetime |
Y |
N |
When received in UTC |
|
date_rcvd_local |
tdatetime |
N |
N |
When received in local time |
|
item_id |
string40 |
Y |
N |
What was received |
|
vend_id |
string40 |
N |
Y |
Identify vendor |
|
invoice |
string40 |
N |
Y |
Invoice or bill of lading "number" |
|
rcvd_by |
string40 |
N |
Y |
Who received this |
|
rcvd_at |
int32 |
N |
Y |
Where shipment was received |
|
spare1 |
string1000 |
N |
Y |
Use defined by language term 1196 |
|
spare2 |
string1000 |
N |
Y |
Use defined by language term 1201 |
|
spare3 |
string1000 |
N |
Y |
Use defined by language term 1210 |
|
spare4 |
string1000 |
N |
Y |
Use defined by language term 1262 |
|
last_edit_comment |
string254 |
N |
Y |
Reserved for internal use to indicate why this record was changed |
|
last_edit_by |
string40 |
N |
N |
Who last changed this record |
|
last_edit_at |
tdatetime |
N |
N |
When this record was last changed |
|
row_id |
ID 1 |
N |
N |
Unique row identifier, for audit trail. |
FK from po_id, po_line_no to po_line (Inhibit delete)
FK from rcvd_at to ent (Set null)