aurora_standard.sturecte

Field Type Null Default Key Extra Comment
rec_doc_no int(11) YES UNI
receipt_date date YES
receipt_ref varchar(10) YES
po_no varchar(10) YES
po_doc_no int(11) YES
ok_post varchar(1) YES
ship_via varchar(10) YES
received_by varchar(10) YES
received_date date YES
received_time varchar(10) YES
chs_rowID bigint(20) unsigned NO PRI auto_increment

References

Local Column References
received_date
TableColumn
_1.inventoryinv_received_date
_1188.inventoryinv_received_date
_1218.inventoryinv_received_date
_1548.inventoryinv_received_date
_435.inventoryinv_received_date
_436.inventoryinv_received_date
_436_archive_testing.inventoryinv_received_date
_437.inventoryinv_received_date
_8.inventoryinv_received_date
_81.inventoryinv_received_date
_999.inventoryinv_received_date
common.clients_contract_dataccd_churn_letter_received_date
received_by
TableColumn
_1.patients_referralspref_received_by
_1188.patients_referralspref_received_by
_1218.patients_referralspref_received_by
_1548.patients_referralspref_received_by
_435.patients_referralspref_received_by
_436.patients_referralspref_received_by
_436_archive_testing.patients_referralspref_received_by
_437.patients_referralspref_received_by
_8.patients_referralspref_received_by
_81.patients_referralspref_received_by
_999.patients_referralspref_received_by
po_no
TableColumn
aurora_standard.stoordrdour_po_no
aurora_standard.stpinchdold_po_no
aurora_standard.stpinchdnew_po_no
aurora_standard.stuabcdpart_po_no
aurora_standard.stuabcdfull_po_no