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 2 Next »

 Overview
 
 

Description

 

 Design : Techinical


 

Design Technical

The technical design document shall lay out the high level design of how the receiving an item process is to be implemented. The details laid out shall include the Wire-frames for User Interface design, Data Element Layout, including the logical Database Design, Component Specifications including artifacts such as Class Diagram, State Chart Diagrams, OJB.xml specifications and  Rules  information.

Service Design and Implementation
Screen Flow Diagram

Layout use cases based on the screen flows indicating navigation between different screens. 

Security
  • Roles – list of roles to be defined
  • Permissions – list of permissions to be defined
  • User Profiles – user profiles that may be applied roles/permissions (also for test/mock purposes)

Component Design
  • OBJ.xml
  • State Chart Diagram
Service Contracts
Service Implementation
 Process Diagram


  Work-flow Diagram

 Wireframes


 UI Wire-frames Design

 

Create/Update Serial Receiving Record



 Data Model

Data Model

User Story : Many Purchase Orders to One Invoice

Entity: OLE_AP_INV_T

Name

Length

Data type

Default Value

Input type

Action event

Validation type

Tab Index

Remarks

INV_RQST_ID

9,0

decimal

0

 

 

 

 

 

OBJ_ID

36

varchar

 

 

 

 

 

 

INV_RQST_STAT_CD

4

varchar

 

 

 

 

 

 

FDOC_NBR

14

varchar

 

 

 

 

 

 

INV_PD_DT

 

datetime

 

 

 

 

 

 

INV_DT

 

datetime

 

 

 

 

 

invoice date

INV_NBR

25

varchar

 

 

 

 

 

invoice number

VNDR_INV_AMT

19,2

decimal

 

 

 

 

 

vendor invoice amount

INV_RQST_PAY_DT

 

datetime

 

 

 

 

 

 

INV_RQST_CST_SRC_CD 

4

varchar

 

 

 

 

 

 

VNDR_HDR_GNRTD_ID

10,0

decimal

 

 

 

 

 

 

VNDR_DTL_ASND_ID

10,0

decimal

 

 

 

 

 

 

VNDR_NM

45

varchar

 

 

 

 

 

 

OLE_VNDR_CURR_ID

10,0

decimal

 

 

 

 

 

 

OLE_VNDR_FOR_CURR_INV_AMT

19,2

decimal

 

 

 

 

 

 

OLE_INV_TYP_ID

10,0

decimal

 

 

 

 

 

 

OLE_INV_SUB_TYP_ID

10,0

decimal

 

 

 

 

 

 

OLE_INV_MTHD_ID

10,0

decimal

 

 

 

 

 

 

INV_NTE_LN1_TXT

90

varchar

 

 

 

 

 

 

INV_NTE_LN2_TXT

90

varchar

 

 

 

 

 

 

INV_NTE_LN3_TXT

90

varchar

 

 

 

 

 

 

 

INV_SPCL_HANDLG_INSTRC_LN1_TXT

90

varchar

 

 

 

 

 

 

INV_SPCL_HANDLG_INSTRC_LN2_TXT

90

varchar

 

 

 

 

 

 

INV_SPCL_HANDLG_INSTRC_LN3_TXT

90

varchar

 

 

 

 

 

 

 

Entity: OLE_AP_INV_PO_ITM_T

 

Name

Length

Data type

Default Value

Input type

Action event

Validation type

Tab Index

Remarks

INV_PO_ITM_ID

9,0

decimal

0

 

 

 

 

 

INV_RQST_ID

9,0

decimal

0

 

 

 

 

 

PO_ID

9,0

decimal

 

 

 

 

 

 

PO_ENCUM_FSCL_YR

4,0

decimal

 

 

 

 

 

To identify the purchase order number

AP_PUR_DOC_LNK_ID

10,0

decimal

 

 

 

 

 

 

CLOSE_PO_IND

1

varchar

NULL

 

 

 

 

 

REOPEN_PO_IND

1

varchar

NULL

 

 

 

 

 

PO_LN_NBR

3,0

decimal

NULL

 

 

 

 

 

ITM_TYP_CD

4

 varchar

 

 

 

 

 

 

ITM_LN_NBR

3,0

decimal

 

 

 

 

 

 

ITM_DESC

4000

 varchar

 

 

 

 

 

 

ITM_CATLG_NBR

30

varchar

 

 

 

 

 

 

ITM_AUX_PART_ID

300

varchar

 

 

 

 

 

 

ITM_UOM_CD

4

varchar

 

 

 

 

 

 

ITM_INV_QTY

11,2

decimal

 

 

 

 

 

 

ITM_UNIT_PRC

19,4

decimal

 

 

 

 

 

 

PO_ITM_UNIT_PRC

19,4

decimal

 

 

 

 

 

 

ITM_OSTND_INV_QTY

11,2

decimal

 

 

 

 

 

 

ITM_OSTND_INV_AMT

19,2

decimal

 

 

 

 

 

 

ITM_TAX_AMT

19,

decimal

 

 

 

 

 

 

ITM_EXTND_PRC

19,2

decimal

 

 

 

 

 

 

OLE_ITM_OSTND_INV_PRTS

11,2

decimal

 

 

 

 

 

 

OLE_ITM_INV_PRTS

11,2

decimal

 

 

 

 

 

 

OLE_PO_ITM_ID

10,0

 decimal

 

 

 

 

 

 

OLE_LST_PRC

 

19,4

decimal

 

 

 

 

 

 

OLE_DOCUMENT_UUID

50

varchar

 

 

 

 

 

 

OLE_ADDL_CHRG_USD

1

varchar

N

 

 

 

 

 

ITM_ASND_TO_TRADE_IN_IND

1

varchar

 

 

 

 

 

 

OLE_DISCNT

19,4

decimal

 

 

 

 

 

 

OLE_DISCNT_TYP

1

varchar

 

 

 

 

 

 

Entity: OLE_AP_INV_ACCT_T

 

Name

Length

Data type

Default Value

Input type

Action event

Validation type

Tab Index

Remarks

INV_ACCT_ID

10,0

decimal

 

 

 

 

 

 

INV_PO_ITM_ID

8,0

decimal

 

 

 

 

 

 

FIN_COA_CD

2

varchar

 

 

 

 

 

 

ACCOUNT_NBR

7

varchar

 

 

 

 

 

 

SUB_ACCT_NBR

5

varchar

 

 

 

 

 

 

FIN_SUB_OBJ_CD

3

varchar

 

 

 

 

 

 

FIN_OBJECT_CD

4

varchar

 

 

 

 

 

 

ITM_ACCT_TOT_AMT

19,2

decimal

 

 

 

 

 

 

DISENC_AMT`

19,2

decimal

 

 

 

 

 

 

 

Entity: OLE_AP_INV_SUM_ACCT_T


Name

Length

Data type

Default Value

Input type

Action event

Validation type

Tab Index

Remarks

SUM_ACCT_ID

10,0

decimal

 

 

 

 

 

 

INV_RQST_ID

9,0

decimal

 

 

 

 

 

 

FIN_COA_CD

2

varchar

 

 

 

 

 

 

ACCOUNT_NBR

7

varchar

 

 

 

 

 

 

SUB_ACCT_NBR

5

varchar

 

 

 

 

 

 

FIN_SUB_OBJ_CD

3

varchar

 

 

 

 

 

 

FIN_OBJECT_CD

4

varchar

 

 

 

 

 

 

ITM_ACCT_TOT_AMT

19,2

decimal

 

 

 

 

 

 

CRDT_MEMO_ID

9,0

decimal

 

 

 

 

 

 

 

Entity: OLE_AP_INV_PO_ITM_USE_TAX_T

 

Name

Length

Data type

Default Value

Input type

Action event

Validation type

Tab Index

Remarks

INV_PO_ITM_USE_TAX_ID

10,0

decimal

 

 

 

 

 

 

INV_PO_ITM_ID

10,0

decimal

 

 

 

 

 

 

FIN_COA_CD

2

varchar

 

 

 

 

 

 

ACCOUNT_NBR

7

varchar

 

 

 

 

 

 

FIN_OBJECT_CD

4

varchar

 

 

 

 

 

 

RATE_CD

10

varchar

 

 

 

 

 

 

TAX_AMT

19,4

decimal

 

 

 

 

 

 

  • No labels