Versions Compared

Key

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

https://jira.kuali.org/browse/OLE-2657 and related linked tasks

Description

Library vendors routinely send invoices billing for multiple Purchase Orders (POs). In many cases, the cost of additional charges (freight, shipping, etc) needs to be split among the accounts on these POs. Instead of manually creating one Payment Request (PREQ) for each PO referenced on the Invoice, users need a way to process the Invoice on one screen in order to avoid having to create individual PREQs and to distribute the cost of additional charges.

Card
labelDesign : Techinical


 

Design Technical

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.

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
    • OLE-PURAP Accounts Payable Processor
    • OLE-PURAP Purchasing Processor
    • OLE-SYS Tax Manager
    • OLE-PURAP Accounts Payable Document Reviewer
    • KR-WKFLW Approve Request Recipient
    • OLE-SYS Accounts Payable Manager
    • OLE-PURAP Payment Request Hold / Cancel Initiator
    • OLE-SYS System User
    • OLE-SYS Manager
    • OLE-SELECT Accounting-AQ2
    • OLE-SELECT Accounting-AQ3
    • OLE-SELECT Accounting-AQ4
    • OLE-SELECT OLE-Receive-Mgr
    • OLE-SELECT Receiving-AQ3
    • OLE-SELECT OLE-Invoicing
    • OLE-SELECT Receiving-AQ4
    • OLE-SELECT OLE_Prepayment
    • OLE-SELECT OLE_RCV
    • OLE-SELECT OLE-Payment
    • OLE-SYS Fiscal Officer
    • KR-SYS Document Initiator
    • OLE-SYS Workflow Administrator
    • OLE-SYS Treasury Manager
    • OLE-SYS User
    • KR-WKFLW Initiator or Reviewer
    • KR-NS Document Editor
    • OLE-SYS Active Faculty or Staff
    • Recall Document (KR-WKFLW)     
    • Recall Document OLE (OLE-SYS)
    • OLE-SELECT OLE_User
    • KR-WKFLW Initiator
    • KR-WKFLW Non-Ad Hoc Approve Request Recipient
    • KR-NS Document Opener
    • OLE-PURAP Budget Reviewer
    • OLE-PURAP Sub-Account Reviewer
    • OLE-SYS Accounting Reviewer
    • OLE-SYS Tax Manager
    • OLE-SELECT OLE-Payment
    • OLE-SELECT OLE_Prepayment
    • OLE-SELECT OLE-Invoicing
  • Permissions – list of permissions to be defined
    • Add Note / Attachment PREQ Invoice Image (OLE-PURAP)
    • View Note / Attachment PREQ Invoice Image (OLE-PURAP)
    • Edit Document PREQ R (OLE-PURAP)
    • Use Transactional Document PREQ requestPaymentRequestCancel (OLE-PURAP)
    • Use Transactional Document PREQ paymentRequestHoldCancelRemoval (OLE-PURAP)
    • Use Transactional Document PREQ requestPaymentRequestHold (OLE-PURAP)
    • Edit Document PREQ P (OLE-PURAP)
    • Edit Document PREQ F (OLE-PURAP)
    • Edit Bank Code PREQ (OLE-PURAP)
    • Blanket Approve Document PREQ (OLE-PURAP)
    • Initiate Document PREQ (OLE-PURAP)
    • Edit ENROUTE Payment Request Document (OLE-SELECT)
    • Edit PROCESSED Payment Request Document (OLE-SELECT)
    • Edit FINAL Payment Request Document (OLE-SELECT)
    • Modify PREQ Account Accounting Lines (OLE-SELECT)
    • Cancel Payment Request (OLE-SELECT)
    • Edit Payment Request Document (OLE-SELECT)
    • Edit Document AP PreRoute (OLE-PURAP)
    • Modify Accounting Lines AP Account items.sourceAccountingLines (OLE-PURAP)
    • Use Transactional Document AP editPreExtract (OLE-PURAP)
    • Modify Accounting Lines AP PreRoute items.sourceAccountingLines (OLE-PURAP)
    • Use Transactional Document AP managerCancel (OLE-PURAP)
    • Use Transactional Document AP processorCancel (OLE-PURAP)
    • Open Document PRAP (OLE-PURAP)     
    • Error Correct Document KFST (OLE-SYS)
    • Administer Routing for Document KFST (OLE-SYS)
    • Edit Bank Code OpenLibraryEnvironmentTransactionalDocument (OLE-SYS)
    • Administer Routing for Document KFS (OLE-SYS)
    • Blanket Approve Document KFS (OLE-SYS)
    • Initiate Document KFS (OLE-SYS)
    • Open Document KFS (OLE-SYS)
    • save Document KFS (OLE-SYS)
    • Delete Note / Attachment OLE FALSE (OLE-SYS)
    • Ad Hoc Review Document KFS A (OLE-SYS)
    • Ad Hoc Review Document KFS F (OLE-SYS)
    • Ad Hoc Review Document KFS K (OLE-SYS)
    • Copy Document KFS (OLE-SYS)
    • Add Message to Route Log KFS (OLE-SYS)
    • Super User Approve Single Action Request OLE (OLE-SYS)     
    • Super User Approve Document OLE (OLE-SYS)
    • Super User Disapprove Document OLE (OLE-SYS)
    • Open Document (OLE-SELECT)
    • Initiate OLE Documents (OLE-SELECT)
    • Cancel Document (KUALI)
    • Route Document (KUALI)
    • Edit Kuali ENROUTE Document Node Name PreRoute (KUALI)
    • Edit Kuali ENROUTE Document Route Status Code R (KUALI)
    • Add Note / Attachment Kuali Document (KUALI)
    • View Note / Attachment Kuali Document (KUALI)
    • Send FYI Request Kuali Document (KR-SYS)
    • Send Acknowledge Request Kuali Document (KR-SYS)
    • Send Approve Request Kuali Document (KR-SYS)
    • Add Message to Route Log (KUALI)
    • Send Complete Request Kuali Document (KR-SYS)

 

 

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


  Work-flow Diagram

Card
labelWireframes


 UI Wire-frames Design

InvoiceProcessScreen




DocumentOverview Tab

 

VendorTab

InvoiceInfoTab

InvoiceProcessItemsTab



 




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

DATE TYPE

DEFAULT VALUE

INPUT TYPE

ACTION EVENT

VALIDATION TYPE

TAB INDEX

REMARKS

INV_RQST_ID

9,0

decimalDECIMAL

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

decimalDECIMAL

 

 

 

 

 

vendor invoice amount

INV_RQST_PAY_DT

 

datetime

 

 

 

 

 

 

INV_RQST_CST_SRC_CD 

4

varchar

 

 

 

 

 

 

VNDR_HDR_GNRTD_ID

10,0

decimalDECIMAL

 

 

 

 

 

 

VNDR_DTL_ASND_ID

10,0

decimalDECIMAL

 

 

 

 

 

 

VNDR_NM

45

varchar

 

 

 

 

 

 

OLE_VNDR_CURR_ID

10,0

decimalDECIMAL

 

 

 

 

 

 

OLE_VNDR_FOR_CURR_INV_AMT

19,2

decimalDECIMAL

 

 

 

 

 

 

OLE_INV_TYP_ID

10,0

decimalDECIMAL

 

 

 

 

 

 

OLE_INV_SUB_TYP_ID

10,0

decimalDECIMAL

 

 

 

 

 

 

OLE_INV_MTHD_ID

10,0

decimalDECIMAL

 

 

 

 

 

 

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

decimalDECIMAL

0

 

 

 

 

 

INV_RQST_ID

9,0

decimalDECIMAL

0

 

 

 

 

 

PO_ID

9,0

decimalDECIMAL

 

 

 

 

 

 

PO_ENCUM_FSCL_YR

4,0

decimalDECIMAL

 

 

 

 

 

To identify the purchase order number

AP_PUR_DOC_LNK_ID

10,0

decimalDECIMAL

 

 

 

 

 

 

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

decimalDECIMAL

 

 

 

 

 

 

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

decimalDECIMAL

 

 

 

 

 

 

ITM_UNIT_PRC

19,4

decimalDECIMAL

 

 

 

 

 

 

PO_ITM_UNIT_PRC

19,4

decimalDECIMAL

 

 

 

 

 

 

ITM_OSTND_INV_QTY

11,2

decimalDECIMAL

 

 

 

 

 

 

ITM_OSTND_INV_AMT

19,2

decimalDECIMAL

 

 

 

 

 

 

ITM_TAX_AMT

19,

decimalDECIMAL

 

 

 

 

 

 

ITM_EXTND_PRC

19,2

decimalDECIMAL

 

 

 

 

 

 

OLE_ITM_OSTND_INV_PRTS

11,2

decimalDECIMAL

 

 

 

 

 

 

OLE_ITM_INV_PRTS

11,2

decimalDECIMAL

 

 

 

 

 

 

OLE_PO_ITM_ID

10,0

 decimal DECIMAL

 

 

 

 

 

 

OLE_LST_PRC

 

19,4

decimalDECIMAL

 

 

 

 

 

 

OLE_DOCUMENT_UUID

50

varchar

 

 

 

 

 

 

OLE_ADDL_CHRG_USD

1

varchar

N

 

 

 

 

 

ITM_ASND_TO_TRADE_IN_IND

1

varchar

 

 

 

 

 

 

OLE_DISCNT

19,4

decimalDECIMAL

 

 

 

 

 

 

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

decimalDECIMAL

 

 

 

 

 

 

INV_PO_ITM_ID

8,0

decimalDECIMAL

 

 

 

 

 

 

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

decimalDECIMAL

 

 

 

 

 

 

DISENC_AMT`

19,2

decimalDECIMAL

 

 

 

 

 

 

 

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

decimalDECIMAL

 

 

 

 

 

 

INV_RQST_ID

9,0

decimalDECIMAL

 

 

 

 

 

 

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

decimalDECIMAL

 

 

 

 

 

 

CRDT_MEMO_ID

9,0

decimalDECIMAL

 

 

 

 

 

 

 

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

decimalDECIMAL

 

 

 

 

 

 

INV_PO_ITM_ID

10,0

decimalDECIMAL

 

 

 

 

 

 

FIN_COA_CD

2

varchar

 

 

 

 

 

 

ACCOUNT_NBR

7

varchar

 

 

 

 

 

 

FIN_OBJECT_CD

4

varchar

 

 

 

 

 

 

RATE_CD

10

varchar

 

 

 

 

 

 

TAX_AMT

19,4

decimalDECIMAL