|
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| LRRHD_CREATED_OUINSTANCE | _decimal_10_0 | decimal(10) | No | This field holds the OUInstance of the LRR | Yes |
| LRRHD_LRR_NO | _varchar_40 | varchar(40) | No | This field holds the LRR number | Yes |
| LRRHD_RECEIPT_DATE | _datetime_8 | datetime(8) | Yes | This field holds the receipt date of the loaned part | No |
| LRRHD_USER_STATUS | _varchar_25 | Varchar(25) | Yes | This field holds the user status | No |
| LRRHD_DOC_STATUS | _varchar_15 | varchar(15) | Yes | This field holds the document status R - Received RE - Rejected CA - Cancelled C - Confirmed | No |
| LRRHD_CATEGORY | _varchar_25 | Varchar(25) | Yes | This field holds the category of the LRR | No |
| LRRHD_LO_RTO_DOC_FLAG | _varchar_15 | varchar(15) | Yes | This field holds the flag to distinguish whether the receipt has been raised on a Loan order or Rental order LO - Loan order RTO - Rental order | No |
| LRRHD_LO_RTO_DOC_NO | _varchar_40 | varchar(40) | Yes | This field holds the reference document number | No |
| LRRHD_LO_RTO_OUINSTANCE | _decimal_10_0 | decimal(10) | Yes | This field holds the OUInstance of the ref doc no | No |
| LRRHD_LO_RTO_AMEND_NO | _decimal_5_0 | decimal(5) | Yes | This field holds the amendment no of the ref doc no | No |
| LRRHD_LO_RTO_DOC_DATE | _datetime_8 | datetime(8) | Yes | This field holds the document date of the ref doc no | No |
| LRRHD_TRADING_PARTNER | _varchar_40 | varchar(40) | Yes | This field holds the trading partner..Possible values 1. SUPPLIER 2. CUSTOMER | No |
| LRRHD_TRDG_PARTNER_NO | _varchar_40 | varchar(40) | Yes | This field holds the Supplier ID/ Customer ID | No |
| LRRHD_TP_OUINSTANCE | _decimal_10_0 | decimal(10) | Yes | This field holds the OUInstance of the Supplier no/ Customer No | No |
| LRRHD_DELIVERY_NOTE_NO | _varchar_40 | varchar(40) | Yes | This field holds the delivery note no | No |
| LRRHD_DELIVERY_NOTE_DATE | _datetime_8 | datetime(8) | Yes | This field holds the delivery note date | No |
| LRRHD_WAY_BILL_NO | _varchar_40 | varchar(40) | Yes | This field holds the way bill no | No |
| LRRHD_WAY_BILL_DATE | _datetime_8 | datetime(8) | Yes | This field holds the way bill date | No |
| LRRHD_GATE_PASS_NO | _varchar_40 | varchar(40) | Yes | This field holds the gate pass no | No |
| LRRHD_GATE_PASS_DATE | _datetime_8 | datetime(8) | Yes | This field holds the gate pass date | No |
| LRRHD_COMMENTS | _varchar_255 | varchar(255) | Yes | This field holds the comments | No |
| LRRHD_LO_RTO_PART_NO | _varchar_40 | varchar(40) | Yes | This field holds the LO/RTO part no | No |
| LRRHD_LRR_PART_NO | _varchar_40 | varchar(40) | Yes | This field holds the LRR part no | No |
| LRRHD_LRR_PART_OUINSTANCE | _decimal_10_0 | decimal(10) | Yes | This field holds the LRR part OUInstance | No |
| LRRHD_LRR_SERIAL_NO | _varchar_40 | varchar(40) | Yes | This field holds the LRR part serial no | No |
| LRRHD_LRR_LOT_NO | _varchar_18 | varchar(18) | Yes | This field holds the LRR part Lot no | No |
| LRRHD_LRR_COMPONENT_NO | _varchar_90 | varchar(90) | Yes | This field holds the LRR part's component no | No |
| LRRHD_RECEIPT_QTY | _decimal_28_8 | decimal(28) | Yes | This field holds the receipt quantity | No |
| LRRHD_CERTIFICATE_TYPE | _varchar_25 | Varchar(25) | Yes | This field holds the certification type defined in logistics common master | No |
| LRRHD_CERTIFICATE_DATE | _datetime_8 | datetime(8) | Yes | This field holds the certificate date | No |
| LRRHD_CERTIFICATE_NO | _varchar_40 | varchar(40) | Yes | This field holds the certification no | No |
| LRRHD_AUTHORIZATION_NO | _varchar_40 | varchar(40) | Yes | This field holds the authorization no | No |
| LRRHD_SYS_TRACK_REF_NO | _varchar_40 | varchar(40) | Yes | This field holds the system tracking reference no | No |
| LRRHD_WARRANTY_LAPSE_DATE | _datetime_8 | datetime(8) | Yes | This field holds the warranty lapse date of the loaned part no | No |
| LRRHD_TAG_DETAILS | _varchar_16 | varchar(16) | Yes | This field holds the tag details | No |
| LRRHD_ACCEPTED_QTY | _decimal_28_8 | decimal(28) | Yes | This field holds the accepted of the loaned part | No |
| LRRHD_REJECTED_QTY | _decimal_28_8 | decimal(28) | Yes | This field holds the rejected quantity of the loaned part | No |
| LRRHD_QUARANTINED_QTY | _decimal_28_8 | decimal(28) | Yes | This field holds the quarantined quantity of the loaned part | No |
| LRRHD_CONDITION | _varchar_25 | Varchar(25) | Yes | This field holds the loaned part condition | No |
| LRRHD_INSPECTED_BY | _varchar_30 | varchar(30) | Yes | This field holds the user name who inspects the loaned part | No |
| LRRHD_INSPECTED_DATE | _datetime_8 | datetime(8) | Yes | This field holds the nspected date | No |
| LRRHD_REASON | _varchar_255 | varchar(255) | Yes | This field holds the reason | No |
| LRRHD_WH_NO | _varchar_10 | varchar(10) | Yes | This field holds the warhouse no to which this loaned part will be moved | No |
| LRRHD_WH_OUINSTANCE | _decimal_10_0 | decimal(10) | Yes | This field holds the warehouse OUInstance | No |
| LRRHD_STOCK_STATUS | _varchar_40 | varchar(40) | Yes | This field holds the stock status loaded from the used defined stock status component | No |
| LRRHD_WHZONE_NO | _varchar_10 | varchar(10) | Yes | This field holds the zone no for the corresponding warehouse | No |
| LRRHD_ZONEBIN_NO | _varchar_10 | varchar(10) | Yes | This field holds the bin no for the corresponding zone no | No |
| LRRHD_USERDEF_DET1 | _varchar_25 | Varchar(25) | Yes | This field holds the used defined detail 1 | No |
| LRRHD_USERDEF_OPT1 | _varchar_25 | Varchar(25) | Yes | This field holds the used defined option 1 | No |
| LRRHD_REMARKS | _varchar_255 | varchar(255) | Yes | This field holds the remarks | No |
| LRRHD_REFDOC_FILE_NAME | _varchar_50 | varchar(50) | Yes | This field holds the document file name attached to the loan/rental receipt | No |
| LRRHD_DOC_TCD_AMT | _decimal_28_8 | decimal(28) | Yes | This field holds the TCD amount | No |
| LRRHD_TIMESTAMP | _decimal_38_0 | decimal(38) | Yes | This field holds the timestamp | No |
| LRRHD_CREATED_DATE | _datetime_8 | datetime(8) | Yes | This field holds the loan/rental receipt created date | No |
| LRRHD_CREATED_BY | _varchar_30 | varchar(30) | Yes | This field holds the user who created the loan/rental receipt | No |
| LRRHD_MODIFIED_DATE | _datetime_8 | datetime(8) | Yes | This field holds the loan/rental receipt modified date | No |
| LRRHD_MODIFIED_BY | _varchar_30 | varchar(30) | Yes | This field holds the user who modified the loan/rental receipt | No |
| LRRHD_AUTHORIZED_DATE | _datetime_8 | datetime(8) | Yes | This field holds the loan/rental rcpt authorization date | No |
| LRRHD_AUTHORIZED_BY | _varchar_30 | varchar(30) | Yes | This field holds the loan/rental rcpt authorized By | No |
| LRRHD_CANC_REASON | _varchar_255 | varchar(255) | Yes | This field holds the reason for cancellation of the loan/rental receipt | No |
| LRRHD_LRR_MANFSERIAL_NO | _varchar_40 | varchar(40) | Yes | This field holds the Manufacturer Serial Number. | No |
| LRRHD_LRR_MANFLOT_NO | _varchar_18 | varchar(18) | Yes | This field holds the Manufacturer Lot Number. | No |
| LRRHD_DEF_FIN_BOOK | _varchar_20 | varchar(20) | Yes | This field holds the finance book for the Document. | No |
| LRRHD_COMPANY_CODE | _varchar_32 | varchar(32) | Yes | This field holds the Company code. | No |
| LRRHD_BUSINESS_UNIT | _varchar_32 | varchar(32) | Yes | This field holds the Business Unit Name. | No |
| LRRHD_CONTROL_ACC_TYPE | _varchar_32 | varchar(32) | Yes | This field holds the Control account Type. | No |
| LRRHD_AUTO_POST_ACC_TYPE | _varchar_32 | varchar(32) | Yes | This field holds the Auto Posting Account Type. | No |
| LRRHD_ACCT_CURR_CODE | _varchar_32 | varchar(32) | Yes | This field holds the Account Code's Currency. | No |
| LRRHD_RENTACCOUNT_CODE | _varchar_32 | varchar(32) | Yes | This field holds the Rent Account Code | No |
| LRRHD_RENTACCOUNT_TYPE | _varchar_32 | varchar(32) | Yes | This field holds the Rent Account Type | No |
| LRRHD_STKACCOUNT_CODE | _varchar_32 | varchar(32) | Yes | This field holds the Stock Account Code | No |
| LRRHD_STKACCOUNT_TYPE | _varchar_32 | varchar(32) | Yes | This field holds the Rent Account Type. | No |
| LRRHD_WH_FIN_BOOK | _varchar_20 | varchar(20) | Yes | This field holds the Warehouse finance book id | No |
| LRRHD_RECEIPT_COST | fin_amount | numeric(13) | Yes | This field holds the Receipt cost value | No |
| LRRHD_TRAN_COST | fin_amount | numeric(13) | Yes | This field holds the tran cost value | No |
| LRRHD_EXPIRY_DATE | udd_time | datetime(8) | Yes | To capture the Expiry Date | No |
| LRRHD_LRR_TRAN_UOM | udd_unitofmeasurement | varchar(10) | Yes | This field holds the Transaction Unit of measurement | No |
| LRRHd_LR_CNTRLTYPE | udd_flag | varchar(25) | Yes | Control type of the part | No |
| LRRHd_LR_EXPENSETYPE | udd_flag | varchar(25) | Yes | Expense type of the part | No |
| LRRHd_LR_EXPENSING_POLICY | udd_designparamcode | varchar(5) | Yes | Expensing policy of the part | No |
| LRRHd_LR_ISSUEBASIS | udd_designparamcode | varchar(5) | Yes | Issue basis of the part | No |
| LRRHd_LR_NONSTOCKABLE_FLAG | udd_flag | varchar(25) | Yes | Non stockable attribute of the part | No |
| LRRHd_LR_PARTTYPE | udd_parttype | varchar(25) | Yes | Part type of the part | No |
| LRRHd_LR_VALUATION_METHOD | udd_designparamcode | varchar(5) | Yes | Valuation Method of the Part | No |
| LRRHD_MFR_DATE | udd_datetime1 | datetime(8) | Yes | This stores the MFR date for loan rental receipts part | No | |
| Table Name : | LRR_LRRPI_PARAMETER_INFO |
| Comment : | This table stores the various values of the parameters defined for a part of type component |
|
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| LRRPI_CREATED_OUINSTANCE | _decimal_10_0 | decimal(10) | No | This field holds the OUInstance of the LRR | Yes |
| LRRPI_LRR_NO | _varchar_40 | varchar(40) | No | This field holds the loan/rental receipt number | Yes |
| LRRPI_PARAM_LINEID | _decimal_5_0 | decimal(5) | No | This field holds the line id which is sequentially generated number | Yes |
| LRRPI_PARAM_CODE | _varchar_40 | varchar(40) | Yes | This field holds the lead parameter code | No |
| LRRPI_SINCE_NEW | _decimal_28_8 | decimal(28) | Yes | This field holds the since new value of the lead parameter | No |
| LRRPI_SINCE_OVERHAUL | _decimal_28_8 | decimal(28) | Yes | This field holds the since overhaul value of the lead parameter | No |
| LRRPI_SINCE_REPAIR | _decimal_28_8 | decimal(28) | Yes | This field holds the since repair value of the lead parameter | No |
| LRRPI_SINCE_INSPECTION | _decimal_28_8 | decimal(28) | Yes | This field holds the since inspection value of the lead parameter | No |
| LRRPI_SINCE_SHOP_VISIT | _decimal_28_8 | decimal(28) | Yes | This field holds the since shop visit value of the lead parameter | No |
| LRRPI_WARRANTY_VALUE | _decimal_28_8 | decimal(28) | Yes | This field holds the flag for the warranty value Y - Yes N - No | No |
| LRRPI_UNKNOW_FLAG | udd_designparamcode | varchar(5) | Yes | This field holds the flag for the Unknown value Y - Yes N - No | No | |
| Table Name : | LRR_LRRPRM_PARAMETER_DTL |
| Comment : | This table stores the parameter details of a Loan/rental Receipt document |
|
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| LRRPRM_COMPONENTNAME | _varchar_80 | varchar(80) | No | This field holds the Name of the component. | Yes |
| LRRPRM_PARAMCATEGORY | _varchar_10 | varchar(10) | No | This field will capture the category of the static value. The static values could be to fill up combo, text field, guidance text, combo default etc. | Yes |
| LRRPRM_PARAMTYPE | _varchar_25 | Varchar(25) | No | Normally param type is the name of the control. This will allow us to store all the possible values for a combo in multiple rows. | Yes |
| LRRPRM_PARAMCODE | _varchar_5 | varchar(5) | No | This is the code that may be used for data storage. This is valid only incase of combo boxes. Here the short code that will be stored as data in the transaction could be maintained. | Yes |
| LRRPRM_LANGID | _decimal_10_0 | decimal(10) | No | Language id. This is the language id of the record. | Yes |
| LRRPRM_PARAMDESC | _varchar_80 | varchar(80) | Yes | Param description is the values to be filled in the combo box or guidance text. This is actually the meta data of this component | No |
| LRRPRM_SORTBY | _decimal_10_0 | decimal(10) | Yes | This field holds the default sort by code | No |
| LRRPRM_CREATEDDATE | _datetime_8 | datetime(8) | Yes | This field holds the record created date for auditing purpose. | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| LRRSOPT_OUINSTANCE | _decimal_10_0 | decimal(10) | No | This field holds the OUInstance of the LRR | Yes |
| LRRSOPT_ALLOWDIFF_RCPTWH | _varchar_15 | varchar(15) | Yes | This field holds the flag whether to allow different receipt warehouse | No |
| LRRSOPT_CREATED_BY | _varchar_30 | varchar(30) | Yes | This field holds the user who created the record | No |
| LRRSOPT_CREATED_DATE | _datetime_8 | datetime(8) | Yes | This field holds the created date | No |
| LRRSOPT_MODIFIED_BY | _varchar_30 | varchar(30) | Yes | This field holds the user who modified the record | No |
| LRRSOPT_MODIFIED_DATE | _datetime_8 | datetime(8) | Yes | This field holds the modified date | No |
| LRRSOPT_TIMESTAMP | _decimal_38_0 | decimal(38) | Yes | This field holds the timestamp of the record | No |
| LRRSOPT_EXTWHMAP_FLAG | udd_designparamcode | varchar(5) | Yes | If set as No then will not validate for External stock allocation mapping | No |