| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
|---|
| TOP43: Procurement |
| 1 | F43121Z1 | Receipts Unedited Transaction Table | 15 | SZ | LSTS | Line Item Status Code | String | UDC | 2 | 0 |
| TOP47: Electronic Commerce |
| 2 | F47022 | EDI P.O. Acknowledgment Detail - Inbound | 205 | SZ | LSTS | Line Item Status Code | String | UDC | 2 | 0 |
| 3 | F47072 | EDI Receiving Advice Detail - Inbound | 15 | SZ | LSTS | Line Item Status Code | String | UDC | 2 | 0 |
| 4 | F47077 | EDI Receiving Advice Detail - Outbound | 15 | SZ | LSTS | Line Item Status Code | String | UDC | 2 | 0 |
| 5 | F47142 | EDI P.O. Change Acknowledgment Detail - Inbound | 16 | SZ | LSTS | Line Item Status Code | String | UDC | 2 | 0 |
| 6 | F47147 | EDI P.O. Change Acknowledgment Detail - Outbound | 16 | SZ | LSTS | Line Item Status Code | String | UDC | 2 | 0 |
User Defined Codes are, by design, customisable and thus will differ from system to system depending on the business requirements.
TOPUDC 47 / LS (Line Item Status Code) stock values
| Value | Description | Special Handling Code | Hard Coded |
|---|
| 1 | 1 | Process | | N |
| 2 | 7 | Close | | N |
| 3 | 9 | Cancel | | N |
| 4 | AC | Item Accepted & Shipped | | N |
| 5 | AR | Item Accepted&Released to Ship | | N |
| 6 | BP | Item Accepted/Part ship/BO | | N |
| 7 | DR | Item Accepted-Date Rescheduled | | N |
| 8 | I | Informational only | | N |
| 9 | IA | Item Accepted | | N |
| 10 | IB | Item Backorderd | | N |
| 11 | IC | Item Accepted - Chgs made | | N |
| 12 | ID | Item Deleted | | N |
| 13 | IE | Item Accepted, Price Pending | | N |
| 14 | IF | Item on Hold, no desc. | | N |
| 15 | IH | Item on Hold | | N |
| 16 | IP | Item Accepted, price changed | | N |
| 17 | IQ | Item Accepted, Qty Changed | | N |
| 18 | IR | Item Rejected | | N |
| 19 | IS | Item Accepted - Substituion | | N |
| 20 | IW | Item on hold - waiver required | | N |
| 21 | SP | Item Accepted - sch.date pend | | N |
