Versions Compared

Version Old Version 5 New Version 6
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
labelWorkflow
  Image RemovedImage Removed Card
labelWireframes
 InvoiceProcessScreen

Image Removed

DocumentOverview Tab

Image Removed

 

VendorTab

Image Removed

InvoiceInfoTab

Image Removed

InvoiceProcessItemsTab

Image Removed

Add Item Tab

Image Removed

Accounting lines

Image Removed

AccountSummaryTab

Image Removed

RelatedDocuments

Image Removed

PaymentHistory

Image Removed

 

 

Card
labelData Model

Entity:OLE_DLVR_CIRC_RECORD

Name

Max
Len

Data Type

Default Value

Input Type

Action Event

Validation
Type

Tab Index

Remarks

CIR_HIS_REC_ID

40

varchar

 

 

 

 

 

System Generated

LOAN_TRAN_ID

40

varchar

 

 

 

 

 

Foreign Key from Loan Record

CIRCULATION_POLICY_ID

40

varchar

 

 

 

 

 

Foreign Key from Rules Record

OLE_PTRN_ID

40

varchar

 

 

 

 

 

Foreign Key from Patron Record

PTRN_TYP_ID

40

varchar

 

 

 

 

 

Foreign Key from Patron Type Record

AFFILIATION_ID

40

varchar

 

 

 

 

 

Foreign Key from Affiliation Type Record

DEPARTMENT_ID

40

varchar

 

 

 

 

 

Foreign Key from Department Record

OTHER_AFFILIATION

40

varchar

 

 

 

 

 

 

STATISTICAL_CATEGORY

40

varchar

 

 

 

 

 

 

ITM_ID

40

varchar

 

 

 

 

 

 

BIB_TIT

500

varchar

 

 

 

 

 

 

BIB_AUTH

500

varchar

 

 

 

 

 

 

BIB_EDITION

500

varchar

 

 

 

 

 

 

BIB_PUB

500

varchar

 

 

 

 

 

 

BIB_PUB_DT

 

DATE

 

 

 

 

 

 

BIB_ISBN

50

varchar

 

 

 

 

 

 

PROXY_PTRN_ID

40

varchar

 

 

 

 

 

 

DUE_DT_TIME

 

DATETIME

 

 

 

 

 

 

PAST_DUE_DT_TIME

 

DATETIME

 

 

 

 

 

 

CRTE_DT_TIME

 

DATETIME

 

 

 

 

 

 

MODI_DT_TIME

 

DATETIME

 

 

 

 

 

 

CIRC_LOC_ID

40

varchar

 

 

 

 

 

 

OPTR_CRTE_ID

40

varchar

 

 

 

 

 

 

OPTR_MODI_ID

40

varchar

 

 

 

 

 

 

MACH_ID

100

varchar

 

 

 

 

 

 

OVRR_OPTR_ID

40

varchar

 

 

 

 

 

 

NUM_RENEWALS

3

varchar

 

 

 

 

 

 

NUM_OVERDUE_NOTICES_SENT

3

varchar

 

 

 

 

 

 

OVERDUE_NOTICE_DATE

 

DATE

 

 

 

 

 

 

OLE_RQST_ID

40

varchar

 

 

 

 

 

 

REPMNT_FEE_PTRN_BILL_ID

40

varchar

 

 

 

 

 

 

CHECK_IN_DT_TIME

 

DATETIME

 

 

 

 

 

 

CHECK_IN_OPTR_ID

40

varchar

 

 

 

 

 

 

CHECK_IN_MACH_ID

100

varchar

 

 

 

 

 

 

 

Entity : OLE_DLVR_TEMP_CIRC_RECORD

Name

Max
Len

Data Type

Default Value

Input Type

Action Event

Validation
Type

Tab Index

Remarks

TMP_CIR_HIS_REC_ID

40

varchar

 

 

 

 

 

System Generated

OLE_PTRN_ID

40

varchar

 

 

 

 

 

 

ITM_ID

40

varchar

 

 

 

 

 

 

CIRC_LOC_ID

40

varchar

 

 

 

 

 

 

CHECK_IN_DT_TIME

 

DATETIME

 

 

 

 

 

 

Entity : OLE_DLVR_LOAN_T

Name

Max
Len

Data Type

Default Value

Input Type

Action Event

Validation
Type

Tab Index

Remarks

LOAN_TRAN_ID

40

varchar

 

 

 

 

 

System Generated

CIRCULATION_POLICY_ID

40

varchar

 

 

 

 

 

Foreign Key from Rules Record

OLE_PTRN_ID

40

varchar

 

 

 

 

 

Foreign Key from Patron Record

ITM_ID

40

varchar

 

 

 

 

 

Foreign Key from Item Record

PROXY_PTRN_ID

40

varchar

 

 

 

 

 

Foreign Key from Patron Record

CURR_DUE_DT_TIME

 

DATETIME

 

 

 

 

 

 

PAST_DUE_DT_TIME

 

DATETIME

 

 

 

 

 

 

CRTE_DT_TIME

 

DATETIME

 

 

 

 

 

 

MODI_DT_TIME

 

DATETIME

 

 

 

 

 

 

CIRC_LOC_ID

40

varchar

 

 

 

 

 

Foreign Key from Circulation Location Record

OPTR_CRTE_ID

40

varchar

 

 

 

 

 

 

OPTR_MODI_ID

40

varchar

 

 

 

 

 

 

MACH_ID

100

varchar

 

 

 

 

 

 

OVRR_OPTR_ID

40

varchar

 

 

 

 

 

 

NUM_RENEWALS

3

varchar

 

 

 

 

 

 

NUM_OVERDUE_NOTICES_SENT

3

varchar

 

 

 

 

 

 

N_OVERDUE_NOTICE

3

varchar

 

 

 

 

 

 

OVERDUE_NOTICE_DATE

 

DATE

 

 

 

 

 

 

OLE_RQST_ID

40

varchar

 

 

 

 

 

Foreign Key from Request Record

REPMNT_FEE_PTRN_BILL_ID

40

varchar

 

 

 

 

 

Foreign Key from Patron Bill Payment Record

CLAIMS_RET_IND

1

varchar

 

 

 

 

 

 

Entity : OLE_PTRN_BILL_T

Name

Max
Len

Data Type

Default Value

Input Type

Action Event

Validation
Type

Tab Index

Remarks

PTRN_BILL_ID

40

varchar

 

 

 

 

 

 

OLE_PTRN_ID

40

varchar

 

 

 

 

 

 

PROXY_PTRN_ID

40

varchar

 

 

 

 

 

 

ITM_ID

40

varchar

 

 

 

 

 

 

ITM_BARCODE

100

varchar

 

 

 

 

 

 

FEE_TYP_ID

40

varchar

 

 

 

 

 

 

FEE_TYP_AMT

8,2

decimal

 

 

 

 

 

 

TOT_AMT_DUE

8,2

Decimal

 

 

 

 

 

 

UNPAID_BAL

8,2

Decimal

 

 

 

 

 

 

PAY_STATUS_ID

40

varchar

 

 

 

 

 

 

PAY_METHOD_ID

40

varchar

 

 

 

 

 

 

PAY_AMT

8,2

Decimal

 

 

 

 

 

 

PAY_DT

 

DATE

 

 

 

 

 

 

PAY_OPTR_ID

40

varchar

 

 

 

 

 

 

PAY_MACH_ID

80

varchar

 

 

 

 

 

 

CRTE_DT_TIME

 

DATETIME

 

 

 

 

 

 

OPTR_CRTE_ID

40

varchar

 

 

 

 

 

 

MACH_ID

80

varchar

 

 

 

 

 

 

NOTE

500

varchar

 

 

 

 

 

 

Entity : OLE_PTRN_FEE_TYPE_T

Name

Max
Len

Data Type

Default Value

Input Type

Action Event

Validation
Type

Tab Index

Remarks

FEE_TYP_ID

40

varchar

 

 

 

 

 

 

FEE_TYP_CD

40

varchar

 

 

 

 

 

 

FEE_TYP_NM

100

varchar

 

 

 

 

 

 

Entity : OLE_PTRN_SYS_GEN_BILL_T

Name

Max
Len

Data Type

Default Value

Input Type

Action Event

Validation
Type

Tab Index

Remarks

OLE_PTRN_SYS_GEN_BILL_ID

40

varchar

 

 

 

 

 

 

PTRN_BILL_ID

40

varchar

 

 

 

 

 

 

CRTE_DT_TIME

 

datetime

 

 

 

 

 

 

OPTR_ID

40

varchar

 

 

 

 

 

 

MACH_ID

80

varchar

 

 

 

 

 

 

 Entity : OLE_DLVR_RQST_T

Name

Max
Len

Data Type

Default Value

Input Type

Action Event

Validation
Type

Tab Index

Remarks

OLE_RQST_ID

40

varchar

 

 

 

 

 

System Generated

PO_LN_ITM_NO

20

varchar

 

 

 

 

 

 

ITM_ID

40

varchar

 

 

 

 

 

 

OLE_PTRN_ID

40

varchar

 

 

 

 

 

 

PTRN_Q_POS

20

varchar

 

 

 

 

 

 

PROXY_PTRN_ID

40

varchar

 

 

 

 

 

 

OLE_RQST_TYP_ID

40

varchar 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
labelWorkflow


  Image AddedImage Added

Card
labelWireframes


 

InvoiceProcessScreen

Image Added



DocumentOverview Tab

Image Added

 

VendorTab

Image Added

InvoiceInfoTab

Image Added

InvoiceProcessItemsTab

Image Added


Add Item Tab

Image Added

Accounting lines

Image Added

AccountSummaryTab

Image Added

RelatedDocuments

Image Added

PaymentHistory

Image Added

varchar

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

 

 

 

 

 

 

CNTNTOBJ_DESCID

80036

varchar

 

 

 

 

 

 

CPY_FRMT

80INV_RQST_STAT_CD

4

varchar

 

 

 

 

 

 

RQST_EXPIR_DT_TIME

 

DATETIMEFDOC_NBR

14

varchar

 

 

 

 

 

 

RCALINV_NTC_SNTPD_DT

 

DATEdatetime

 

 

 

 

 

 

ONHLD_NTCINV_SNT_DT

 

DATEdatetime

 

 

 

 

 

 

LOANINV_TRAN_IDNBR

4025

varchar

 

 

 

 

 

 

PCKUPVNDR_LOCINV_IDAMT

4019,2

varchardecimal

 

 

 

 

 

 

CRTEINV_RQST_PAY_DT_TIME

 

DATETIMEdatetime

 

 

 

 

 

 

MODI_DT_TIME

 

DATETIMEINV_RQST_CST_SRC_CD 

4

varchar

 

 

 

 

 

 

OPTRVNDR_HDR_CRTEGNRTD_ID

4010,0

varchardecimal

 

 

 

 

 

 

OPTRVNDR_DTL_MODIASND_ID40

10,0

varchar

decimal

 

 

 

 

 

 

MACHVNDR_IDNM100

45

varchar

 

 

 

 

 

 

CIRCOLE_VNDR_LOCCURR_ID

4010,0varchar

decimal

 

 

 

 

 

 

Entity :

OLE_

DLVR_RQST_TYP_T

Name

Max
Len

Data Type

Default Value

Input Type

Action Event

Validation
Type

Tab Index

Remarks

OLE_RQST_TYP_ID

40

varcharVNDR_FOR_CURR_INV_AMT

19,2

decimal

 

 

 

 

 

 

OLE_RQSTINV_TYP_CDID

4010,0varchar

decimal

 

 

 

 

 

 

OLE_INV_RQSTSUB_TYP_DESCID

10010,0varchar

decimal

 

 

 

 

 

 

Entity :

OLE_

DLVR

INV_

RQST_HSTRY_REC_T

Name

Max
Len

Data Type

Default Value

Input Type

Action Event

Validation
Type

Tab Index

Remarks

OLE_RQST_HSTRY_REC_ID

40MTHD_ID

10,0

decimal

 

 

 

 

 

 

INV_NTE_LN1_TXT

90

varchar

 

 

 

 

 

 

OLEINV_NTE_RQSTLN2_IDTXT

4090

varchar

 

 

 

 

 

 

ITM_ID

40INV_NTE_LN3_TXT

90

varchar

 

 

 

 

 

 

 

PO_LN_ITM_NO

40

INV_SPCL_HANDLG_INSTRC_LN1_TXT

90

varchar

 

 

 

 

 

 

OLE_RQST_TYP_ID

40INV_SPCL_HANDLG_INSTRC_LN2_TXT

90

varchar

 

 

 

 

 

 

PCKUP_LOC_ID

40

varcharINV_SPCL_HANDLG_INSTRC_LN3_TXT

90

varchar

 

 

 

 

 

 

 

RQST_CRTE_OPTR

Entity: OLE_AP_INV_PO_ITM_T

 

INV_PO_ITM_ID

409,0varchar

decimal

 

0

 

 

 

 

 

INV_RQST_MODI_OPTR_ID

409,0varchar

decimal

 

0

 

 

 

 

 

RQST_MACHPO_ID

809,0

varchardecimal

 

 

 

 

 

 

RQSTPO_CRTEENCUM_DTFSCL_TIMEYR

 4,0

DATETIMEdecimal

 

 

 

 

 

 

RQSTAP_PUR_MODIDOC_DTLNK_TIMEID 

10,0

DATETIMEdecimal

 

 

 

 

 

 

CRTECLOSE_DTPO_TIMEIND 

1

DATETIME

varchar

 

NULL

 

 

 

 

 

OPTRREOPEN_PO_IDIND40

1

varchar

 

NULL

 

 

 

 

 

MACH

PO_LN_

ID

NBR

80

3,0

varchar

decimal

 

NULL

 

 

 

 

 

Entity : OLE_CRCL_DSK_T

Name

Max
Len

Data Type

Default Value

Input Type

Action Event

Validation
Type

Tab Index

Remarks

Circ_loc_desk_ID

40

varchar

ITM_TYP_CD

4

 varchar

 

 

 

 

 

 

ITM_LN_NBR

3,0

decimal

 

 

 

 

 

 

Circ_loc_desk_Code

40

varcharITM_DESC

4000

 varchar

 

 

 

 

 

 

Circ_locITM_deskCATLG_NameNBR

10030

varchar

 

 

 

 

 

 

CircITM_locAUX_deskPART_DescID

400300

varchar

 

 

 

 

 

 

Active

1ITM_UOM_CD

4

varchar

 

 

 

 

 

 

CircITM_locINV_IDQTY

4011,2

varchardecimal

 

 

 

 

 

Reference key for Location table

Entity : OLE_MAP_CRCLDSK_OPTR

Name

Max
Len

Data Type

Default Value

Input Type

Action Event

Validation
Type

Tab Index

Remarks

Cir_Desk_Optr_ID

40

varchar

 

ITM_UNIT_PRC

19,4

decimal

 

 

 

 

 

 

PO_ITM_UNIT_PRC

19,4

decimal

 

 

 

 

 

System Generated

Person_ID

40

varchar

 

ITM_OSTND_INV_QTY

11,2

decimal

 

 

 

 

 

Reference key for Person record

Circ_loc_desk_ID

40

varchar

 

ITM_OSTND_INV_AMT

19,2

decimal

 

 

 

 

 

Reference key for Circulation desk record

Cir_Desk_Optr_Date

 

DATE

 

ITM_TAX_AMT

19,

decimal

 

 

 

 

 

 

Entity : OLE

ITM_

PTRN

EXTND_

T

PRC

Name

Max
Len

Data Type

Default Value

Input Type

Action Event

Validation
Type

Tab Index

Remarks

OLE_PTRN_ID

40

varchar19,2

decimal

 

 

 

 

 

 

OLE_ITM_OSTND_INV_PRTS

11,2

decimal

 

 

 

 

 

System Generated

 

OLE_PROXYITM_PTRNINV_REF_ID

40

varcharPRTS

11,2

decimal

 

 

 

 

 

 

BORR_TYP

40

varcharOLE_PO_ITM_ID

10,0

 decimal

 

 

 

 

 

 

GENERAL_BLOCK

1

varcharOLE_LST_PRC

 

19,4

decimal

 

 

 

 

 

 

GENERALOLE_BLOCKDOCUMENT_NOTEUUID

100050

varchar

 

 

 

 

 

 

PHOTOGRAPH

 

BLOG

 OLE_ADDL_CHRG_USD

1

varchar

N

 

 

 

 

 

DELIVERY_PRIVILEGEITM_ASND_TO_TRADE_IN_IND

1

varchar

 

 

 

 

 

 

PAGINGOLE_PRIVILEGEDISCNT

119,4

varchardecimal

 

 

 

 

 

 

ACTIVATIONOLE_DISCNT_DATETYP

 1

DATEvarchar

 

 

 

 

 

 

EXPIRATION_DATE
Entity: OLE_AP_INV_ACCT_T

 

DATE

 

 

 

 

 

 

SOURCE

40

Name

Length

Data type

Default Value

Input type

Action event

Validation type

Tab Index

Remarks

INV_ACCT_ID

10,0

decimal

 

 

 

 

 

 

AFFILIATIONINV_PO_ITM_ID40

8,0

varchar

decimal

 

 

 

 

 

 

DEPARTMENTFIN_COA_IDCD40

2

varchar

 

 

 

 

 

 

OTHERACCOUNT_AFFILIATIONNBR40

7

varchar

 

 

 

 

 

 

STATISTICALSUB_ACCT_CATEGORYNBR40

5

varchar

 

 

 

 

 

 

BARCODE

100FIN_SUB_OBJ_CD

3

varchar

 

 

 

 

 

 

PASSWORD

50FIN_OBJECT_CD

4

varchar

 

 

 

 

 

 

AUTHENTICATION_ID

50

varcharITM_ACCT_TOT_AMT

19,2

decimal

 

 

 

 

 

 

OTHER_ID

50

varcharDISENC_AMT`

19,2

decimal

 

 

 

 

 

 

 

LOST_INVD_BARCODE

20

varchar

 

 

 

 

 

 

LOST_INVD_BARCODE_EFF_DT

 

DATE
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

 

 

 

 

 

 

STAFFINV_RQST_NOTEID

100019,0varchar

decimal

 

 

 

 

 

 

COURTESYFIN_NOTICECOA_PREFCD1

2

varchar

 

 

 

 

 

 

ACTVACCOUNT_INDNBR1

7

varchar

 

 

 

 

 

 

CRTESUB_DTACCT_TIMENBR 

5

DATETIME

varchar

 

 

 

 

 

 

MODI_DT_TIME

 

DATETIME

FIN_SUB_OBJ_CD

3

varchar

 

 

 

 

 

 

OPTRFIN_CRTEOBJECT_IDCD40

4

varchar

 

 

 

 

 

 

OPTRITM_ACCT_MODITOT_IDAMT40

19,2

varchar

decimal

 

 

 

 

 

 

MACHCRDT_MEMO_ID

80

varchar

9,0

decimal

 

 

 

 

 

 

 

Entity: OLE
_DLVR_PTRN_ADDR_T
_AP_INV_PO_ITM_USE_TAX_T

 

Image Removed

Name

Max
Len

Length

Data

Type

type

Default Value

Input

Type

type

Action

Event

event

Validation type

Type

Tab Index

Remarks

OLEINV_DLVRPO_PTRNITM_ADDR_ID

40

varchar

 

 

 

 

 

System Generated

OLE_PTRN_ID

40

varcharUSE_TAX_ID

10,0

decimal

 

 

 

 

 

 

ENTITYINV_PO_ADDRITM_ID

4010,0varchar

decimal

 

 

 

 

 

 

TEXTFIN_COA_ADDRCD1000

2

varchar

 

 

 

 

 

 

ADDRACCOUNT_SOURCENBR40

7

varchar

 

 

 

 

 

 

ADDRFIN_OBJECT_VERIFIEDCD1

4

varchar

 

 

 

 

 

 

ADDRRATE_VALID_FROMCD 

10

DATE

varchar

 

 

 

 

 

 

ADDRTAX_VALID_TO

 

DATEAMT

19,4

decimal

 

 

 

 

 

 

Card
labelERD