Transmission Statuses

At a glance

• TransmissionStatus is the lookup table; TransmissionMaster.Status stores the code on each queued message (N New, C Completed, E Error, H Hold, X Acceptable Error, R Resent, q Not Needed).
• 95% of rows you’ll see in the wild are N (waiting) or C (done). E is the row that needs your attention.
• TransmissionPaymentStatus mirrors BC’s payment status back to SMART (used by TransmissionBillPayment / TransmissionCheckPayment).
• TransmissionLotStatus is a snapshot of the Lot status at the time a transmission was sent — useful in reports.

TransmissionStatus

Used by TransmissionMaster (column Status, FK to TransmissionStatus.TransmissionStatusID). Child Transmission* tables inherit queue state through TransmissionMasterSysID. The two codes you’ll see most are N (new, waiting) and C (completed).

All 7 TransmissionStatus codes (with what to do for each)

Code	Name	What to do
N	New	Wait — the BC worker will pick it up within 5 minutes.
C	Completed	Done. No action needed.
H	Hold	Manually held. Released by an admin.
E	Error	Inspect TransmissionError / TransmissionMasterErrorLog; fix data; reset to N.
X	Error is Acceptable	Marked OK by an admin; the row stays out of retry.
R	Resent New Transmission	Superseded by a newer row.
q	BC – Not Needed	Skipped because BC doesn't need this entity.

TransmissionPaymentStatus

Used by TransmissionBillPayment / TransmissionCheckPayment to mirror BC’s payment status back into SMART. Values come from BC; the lookup table holds the latest mapping.

TransmissionLotStatus

A copy of the relevant Lot status flag at the time of transmission, so reports can show “this lot was Production Inventory when this PO went out.”