Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 10 Next »

UI Wire-frames Design

Requisition Screen

Copies Subsection

 

ER Diagram

 

Data Model (logical)

 

User Story : 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

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
  • No labels