Versions Compared

Version Old Version 14 New Version 15
Changes made by

Sheik Salahudeen Meera Sahib

Sheik Salahudeen Meera Sahib

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Deck
idKuali OLE
Card
labelOverview
Section
 
Column
width50%
 

Description

The technical design document shall lay out the high level design of how the Many Purchase Orders to One Invoice. 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 other relevant information.

Card
labelDesign : Techinical


 

Design Technical
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
Component Design
  • OBJ.xml
  • State Chart Diagram
Service Contracts
Service Implementation
Card
labelWorkflow


  Work-flow Diagram

Card
labelWireframes


 UI Wire-frames Design

InvoiceProcessScreen




DocumentOverview Tab

 

VendorTab

InvoiceInfoTab

InvoiceProcessItemsTab


Add Item Tab


Accounting lines


AccountSummaryTab

RelatedDocuments

PaymentHistory

General Ledger Pending Entries


Card
labelData 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