M:1 PO to Invoice 1.0

Overview

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.

Design : 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
Permissions – list of permissions to be defined

Component Design

OBJ.xml
State Chart Diagram

Service Contracts

Service Implementation

Workflow

Work-flow Diagram

Wireframes

UI Wire-frames Design

Invoice Process Screen

Document Overview Tab

Vendor Tab

Invoice Info Tab

Invoice Process Items Tab

Add Item Tab

Accounting lines

Account Summary Tab

Related Documents

Payment History

General Ledger Pending Entries

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