...
Copies Subsection (CORR)
ER Diagram
Data Model (logical)
...
UserStory: Line Item Receiving Enhancement - Copy Subsection
Entity : OLE_COPY_T
Name | Max Len | Data Type | Default Value | Input Type | Action Event | Validation Type | Tab Index | Remarks |
OLE_COPY_ID | 40 | varchar |
|
|
|
|
| System Generated |
FDOC_NBR | 40 | varchar |
|
|
|
|
| Foreign Key of Purchase Order Item |
PO_ITM_ID | 40 | varchar |
|
|
|
|
| Foreign Key of Purchase Order Item |
REQ_ITM_ID | 40 | varchar |
|
|
|
|
| References requisition line item |
LOC | 40 | varchar |
|
|
|
|
| Identifies the shelving location |
COPY_NUM | 40 | varchar |
|
|
|
|
| Identifies the copy number |
RCPT_STAT | 40 | varchar |
|
|
|
|
| Identifies the receipt status to confirm whether it is received or not |
ITEM_UUID | 40 | varchar |
|
|
|
|
| Retrieves item details using item uuid |