| Card |
|---|
| 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 |
|---|
|
Design TechnicalThe 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 |
|---|
label | Design : Techinical | Design TechnicalService Design and ImplementationScreen Flow DiagramLayout 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 ContractsService Implementation |
| Card |
|---|
|
Work-flow Diagram
 
|
| Card |
|---|
|
UI Wire-frames Design
InvoiceProcessScreen 
DocumentOverview Tab 
VendorTab 
InvoiceInfoTab 
InvoiceProcessItemsTab 
Add Item Tab 
Accounting lines 
AccountSummaryTab 
RelatedDocuments 
PaymentHistory 
General Ledger Pending Entries 
|
| Card |
|---|
| 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 | | | | | | |
|
|