- Created by Prem Kumar Balu , last modified by Sheik Salahudeen Meera Sahib on Jun 24, 2013
You are viewing an old version of this page. View the current version.
Compare with Current View Page History
« Previous Version 5 Next »
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.
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
Entity:OLE_DLVR_CIRC_RECORD
Name | Max | Data Type | Default Value | Input Type | Action Event | Validation | 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 | Data Type | Default Value | Input Type | Action Event | Validation | 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 | Data Type | Default Value | Input Type | Action Event | Validation | 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 | Data Type | Default Value | Input Type | Action Event | Validation | 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 | Data Type | Default Value | Input Type | Action Event | Validation | 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 | Data Type | Default Value | Input Type | Action Event | Validation | 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 | Data Type | Default Value | Input Type | Action Event | Validation | 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 |
|
|
|
|
|
|
CNTNT_DESC | 800 | varchar |
|
|
|
|
|
|
CPY_FRMT | 80 | varchar |
|
|
|
|
|
|
RQST_EXPIR_DT_TIME |
| DATETIME |
|
|
|
|
|
|
RCAL_NTC_SNT_DT |
| DATE |
|
|
|
|
|
|
ONHLD_NTC_SNT_DT |
| DATE |
|
|
|
|
|
|
LOAN_TRAN_ID | 40 | varchar |
|
|
|
|
|
|
PCKUP_LOC_ID | 40 | varchar |
|
|
|
|
|
|
CRTE_DT_TIME |
| DATETIME |
|
|
|
|
|
|
MODI_DT_TIME |
| DATETIME |
|
|
|
|
|
|
OPTR_CRTE_ID | 40 | varchar |
|
|
|
|
|
|
OPTR_MODI_ID | 40 | varchar |
|
|
|
|
|
|
MACH_ID | 100 | varchar |
|
|
|
|
|
|
CIRC_LOC_ID | 40 | varchar |
|
|
|
|
|
|
Entity : OLE_DLVR_RQST_TYP_T
Name | Max | Data Type | Default Value | Input Type | Action Event | Validation | Tab Index | Remarks |
OLE_RQST_TYP_ID | 40 | varchar |
|
|
|
|
|
|
OLE_RQST_TYP_CD | 40 | varchar |
|
|
|
|
|
|
OLE_RQST_TYP_DESC | 100 | varchar |
|
|
|
|
|
|
Entity : OLE_DLVR_RQST_HSTRY_REC_T
Name | Max | Data Type | Default Value | Input Type | Action Event | Validation | Tab Index | Remarks |
OLE_RQST_HSTRY_REC_ID | 40 | varchar |
|
|
|
|
|
|
OLE_RQST_ID | 40 | varchar |
|
|
|
|
|
|
ITM_ID | 40 | varchar |
|
|
|
|
|
|
PO_LN_ITM_NO | 40 | varchar |
|
|
|
|
|
|
OLE_RQST_TYP_ID | 40 | varchar |
|
|
|
|
|
|
PCKUP_LOC_ID | 40 | varchar |
|
|
|
|
|
|
RQST_CRTE_OPTR_ID | 40 | varchar |
|
|
|
|
|
|
RQST_MODI_OPTR_ID | 40 | varchar |
|
|
|
|
|
|
RQST_MACH_ID | 80 | varchar |
|
|
|
|
|
|
RQST_CRTE_DT_TIME |
| DATETIME |
|
|
|
|
|
|
RQST_MODI_DT_TIME |
| DATETIME |
|
|
|
|
|
|
CRTE_DT_TIME |
| DATETIME |
|
|
|
|
|
|
OPTR_ID | 40 | varchar |
|
|
|
|
|
|
MACH_ID | 80 | varchar |
|
|
|
|
|
|
Entity : OLE_CRCL_DSK_T
Name | Max | Data Type | Default Value | Input Type | Action Event | Validation | Tab Index | Remarks |
Circ_loc_desk_ID | 40 | varchar |
|
|
|
|
|
|
Circ_loc_desk_Code | 40 | varchar |
|
|
|
|
|
|
Circ_loc_desk_Name | 100 | varchar |
|
|
|
|
|
|
Circ_loc_desk_Desc | 400 | varchar |
|
|
|
|
|
|
Active | 1 | varchar |
|
|
|
|
|
|
Circ_loc_ID | 40 | varchar |
|
|
|
|
| Reference key for Location table |
Entity : OLE_MAP_CRCLDSK_OPTR
Name | Max | Data Type | Default Value | Input Type | Action Event | Validation | Tab Index | Remarks |
Cir_Desk_Optr_ID | 40 | varchar |
|
|
|
|
| System Generated |
Person_ID | 40 | varchar |
|
|
|
|
| Reference key for Person record |
Circ_loc_desk_ID | 40 | varchar |
|
|
|
|
| Reference key for Circulation desk record |
Cir_Desk_Optr_Date |
| DATE |
|
|
|
|
|
|
Entity : OLE_PTRN_T
Name | Max | Data Type | Default Value | Input Type | Action Event | Validation | Tab Index | Remarks |
OLE_PTRN_ID | 40 | varchar |
|
|
|
|
| System Generated |
OLE_PROXY_PTRN_REF_ID | 40 | varchar |
|
|
|
|
|
|
BORR_TYP | 40 | varchar |
|
|
|
|
|
|
GENERAL_BLOCK | 1 | varchar |
|
|
|
|
|
|
GENERAL_BLOCK_NOTE | 1000 | varchar |
|
|
|
|
|
|
PHOTOGRAPH |
| BLOG |
|
|
|
|
|
|
DELIVERY_PRIVILEGE | 1 | varchar |
|
|
|
|
|
|
PAGING_PRIVILEGE | 1 | varchar |
|
|
|
|
|
|
ACTIVATION_DATE |
| DATE |
|
|
|
|
|
|
EXPIRATION_DATE |
| DATE |
|
|
|
|
|
|
SOURCE | 40 | varchar |
|
|
|
|
|
|
AFFILIATION_ID | 40 | varchar |
|
|
|
|
|
|
DEPARTMENT_ID | 40 | varchar |
|
|
|
|
|
|
OTHER_AFFILIATION | 40 | varchar |
|
|
|
|
|
|
STATISTICAL_CATEGORY | 40 | varchar |
|
|
|
|
|
|
BARCODE | 100 | varchar |
|
|
|
|
|
|
PASSWORD | 50 | varchar |
|
|
|
|
|
|
AUTHENTICATION_ID | 50 | varchar |
|
|
|
|
|
|
OTHER_ID | 50 | varchar |
|
|
|
|
|
|
LOST_INVD_BARCODE | 20 | varchar |
|
|
|
|
|
|
LOST_INVD_BARCODE_EFF_DT |
| DATE |
|
|
|
|
|
|
STAFF_NOTE | 10001 | varchar |
|
|
|
|
|
|
COURTESY_NOTICE_PREF | 1 | varchar |
|
|
|
|
|
|
ACTV_IND | 1 | varchar |
|
|
|
|
|
|
CRTE_DT_TIME |
| DATETIME |
|
|
|
|
|
|
MODI_DT_TIME |
| DATETIME |
|
|
|
|
|
|
OPTR_CRTE_ID | 40 | varchar |
|
|
|
|
|
|
OPTR_MODI_ID | 40 | varchar |
|
|
|
|
|
|
MACH_ID | 80 | varchar |
|
|
|
|
|
|
Entity : OLE_DLVR_PTRN_ADDR_T
Name | Max | Data Type | Default Value | Input Type | Action Event | Validation | Tab Index | Remarks |
OLE_DLVR_PTRN_ADDR_ID | 40 | varchar |
|
|
|
|
| System Generated |
OLE_PTRN_ID | 40 | varchar |
|
|
|
|
|
|
ENTITY_ADDR_ID | 40 | varchar |
|
|
|
|
|
|
TEXT_ADDR | 1000 | varchar |
|
|
|
|
|
|
ADDR_SOURCE | 40 | varchar |
|
|
|
|
|
|
ADDR_VERIFIED | 1 | varchar |
|
|
|
|
|
|
ADDR_VALID_FROM |
| DATE |
|
|
|
|
|
|
ADDR_VALID_TO |
| DATE |
|
|
|
|
|
|
- No labels