Data Dictionary -- Loan Order

Srl. No.	Table Name	Comment
1	LORD_LO_RCPT_DET	Stores the details of the receipts that are confirmed against the Loan Order
2	LO_LOADTCD_LO_DOC_TCD	This table holds the Document TCD details of an amended Loan order.
3	LO_LOAHDR_LOAN_ORDER_HDR	This table holds the information of the amended loan order
4	LO_LOALC_LEASE_CHARGES	This Table holds the calendar based and parameter based lease charges for an amended loan order document
5	LO_LOAPCD_PENALTY_CHARGES	This table stores the penalty charges of an amended Loan Order
6	LO_LOAPCH_PENALTY_CHRGS_HDR	This table stores the penalty charges header details for an amended Loan Order
7	LO_LOASOPT_SETOPTIONS_INFO	This table stores the set options information change history for Loan Order
8	LO_LOATMCN_LO_TERMS_CONDNS	This table holds the Terms and Condition of an amended Loan order document
9	LO_LOCD_LOANORDER_CLOSE_DET	This table stores the shipping and closing details of Loan order document
10	LO_LODTCD_LO_DOC_TCD	This table holds the Document TCD details of Loan order.
11	LO_LOHDR_LOAN_ORDER_HDR	This table holds the Loan order information
12	LO_LOLC_LEASE_CHARGES	This Table holds the calendar based and parameter based lease charges for a loan order document
13	LO_LOPCD_PENALTY_CHARGES	This table stores the penalty charges defined for a Loan Order
14	LO_LOPCH_PENALTY_CHRGS_HDR	This table stores the penalty charges header details for a Loan Order
15	LO_LOPRM_PARAMETER_DTL	This table is to hold Parameter Details for the Loan Order.
16	LO_LOSC_SUP_CORR_DETAILS	This table holds supplier correspondence details for a LO document subsequent to the authorization of the LO and the document is received by the Supplier
17	LO_LOSOPT_SETOPTIONS_INFO	This table stores the set options information for Loan Order
18	LO_LOTMCN_LO_TERMS_CONDNS	This table holds the Terms and Condition of Loan order document

Table Name :	LORD_LO_RCPT_DET
Comment :	Stores the details of the receipts that are confirmed against the Loan Order

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
LORD_LO_OUINSTANCE	_decimal_4_0	decimal(4)	No	stores the OUInstance where the loan order is created	Yes
LORD_LO_NO	_varchar_40	varchar(40)	No	stores the loan order number	Yes
LORD_LRCPT_NO	_varchar_40	varchar(40)	No	stores the loan receipt document number	Yes
LORD_LRCPT_DATE	_datetime_8	datetime(8)	Yes	stores the loan receipt document date	No
LORD_LRCPT_QTY	_decimal_28_8	decimal(28)	Yes	stores the loan receipt quantity	No
LORD_LRCPT_PARTNO	_varchar_40	varchar(40)	Yes	stores the part number received through the loan receipt	No
LORD_LRCPT_PARTOU	_decimal_4_0	decimal(4)	Yes	stores the OUInstance of the Loan receipt part	No
LORD_LRCPT_SERIALNO	_varchar_40	varchar(40)	Yes	stores the serial number generated for the part received through the loan receipt	No
LORD_LRCPT_COMPID	_varchar_90	varchar(90)	Yes	stores the component ID generated for the part received through the loan receipt	No
LORD_LRCPT_WH	_varchar_10	varchar(10)	Yes	stores the warehouse where the qty is received against loan order	No
LORD_LRCPT_PEND_ISS_QTY	_decimal_28_8	decimal(28)	Yes	stores the receipt qty received against loan order	No
LORD_LRCPT_STOCK_STATUS	_varchar_40	varchar(40)	Yes	stores the stock status of the loaned part	No
LORD_LRCPT_ZONE	_varchar_10	varchar(10)	Yes	stores the zone into which the loaned part is received	No
LORD_LRCPT_BIN	_varchar_10	varchar(10)	Yes	stores the bin into which the loaned part is received	No
LORD_LRCPT_LOTNO	_varchar_18	varchar(18)	Yes	stores the lot number for the loaned part	No
LORD_LRCPT_CONDITION	_varchar_25	Varchar(25)	Yes	stores the condition in which the loaned part is received	No

Table Name :	LO_LOADTCD_LO_DOC_TCD
Comment :	This table holds the Document TCD details of an amended Loan order.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
LOADTCD_LO_OUINSTANCE	_decimal_4_0	decimal(4)	No	stores the OUInstance where the loan order is created	Yes
LOADTCD_LO_NO	_varchar_40	varchar(40)	No	stores the loan order number	Yes
LOADTCD_TCD_MODE	_varchar_5	varchar(5)	No	stores the mode for which the TCDs are captured. RP - Rental Price AC - Administrative Charges LC - Lease Charges RC - Rental Charges	Yes
LOADTCD_LINE_NO	_decimal_6_0	decimal(6)	No	This field holds the Unique identifier number for the TCD	Yes
LOADTCD_AMEND_NO	_decimal_6_0	decimal(6)	No	stores the amendment no of loan order	Yes
LOADTCD_TCD_CODE	_varchar_25	Varchar(25)	No	This field holds the Unique identifier for the TCD	No
LOADTCD_TCD_VARIANT	_varchar_25	Varchar(25)	No	This field holds the TCD variant for the TCD code.	No
LOADTCD_USER_SEQ	_decimal_6_0	decimal(6)	Yes	holds the sequenc number as entered by the user for the TCD	No
LOADTCD_TCD_OU	_decimal_4_0	decimal(4)	Yes	stores the TCD OUInstance	No
LOADTCD_TCD_RATE	_decimal_28_8	decimal(28)	Yes	TCD rate for the TCD code and the variant . this should not be changed for TCD basis -- Percentage.	No
LOADTCD_TCD_AMOUNT	_decimal_28_8	decimal(28)	Yes	The Tcd amount that will be calculated from the TCD component for the TCD code and the variant and the TCD rate supplied	No
LOADTCD_PAY_CURRENCY	_varchar_20	varchar(20)	Yes	This field holds the Transaction currency	No
LOADTCD_PAY_TO_SUPP	_varchar_45	varchar(45)	Yes	A valid supplier defined in the Supplier component and mapped to the Supplier (who supplies the services requested )as pay to supplier ( to whom the payment can be made)	No
LOADTCD_PAY_TO_SUPP_OU	_decimal_4_0	decimal(4)	Yes	Stores the pay to supplier OUInstance	No
LOADTCD_EXCHG_RATE	_decimal_28_8	decimal(28)	Yes	Holds the exchage rate between the document currency and the payment currency	No
LOATCD_COST_DIFF	udd_amount	numeric(13)	Yes	Column to store cost diff between the last amendment no and current amendment no	No

Table Name :	LO_LOAHDR_LOAN_ORDER_HDR
Comment :	This table holds the information of the amended loan order

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
LOAHDR_LO_OUINSTANCE	_decimal_4_0	decimal(4)	No	stores the OUInstance where the loan order is created	Yes
LOAHDR_LO_NO	_varchar_40	varchar(40)	No	stores the loan order number	Yes
LOAHDR_AMEND_NO	_decimal_6_0	decimal(6)	No	stores the loan order amendment number.	Yes
LOAHDR_LO_DATE	_datetime_8	datetime(8)	No	stores the document date	No
LOAHDR_LO_STATUS	_varchar_5	varchar(5)	No	stores the document status. allowed values are: "FR" - " Fresh", "DR" - " Draft", "AUT" - "Authorized", "RET"- "Returned", "UAT"- " Under Authorization", "AMD" - "Amended", "SHD"- "Shipped", "CLS" - "Closed", "CAN"- "Cancelled", "REV" - "Revised",	No
LOAHDR_PART_NO	_varchar_40	varchar(40)	No	stores the part no on which the loan order is raised	No
LOAHDR_PRT_SRL_NO	_varchar_40	varchar(40)	Yes	stores the part serial no	No
LOAHDR_PART_OUINSTANCE	_decimal_4_0	decimal(4)	Yes	stores the part OUinstance	No
LOAHDR_SUPP_CODE	_varchar_45	varchar(45)	No	stores the supplier code	No
LOAHDR_SUPP_CREATED_OU	_decimal_4_0	decimal(4)	Yes	stores the OUInstance where the supplier is created	No
LOAHDR_SUPP_OU	_decimal_4_0	decimal(4)	Yes	stores the supplier OUinstance	No
LOAHDR_LO_CURRENCY	_varchar_20	varchar(20)	Yes	stores the document/order currency	No
LOAHDR_EXCHANGE_RATE	_decimal_28_8	decimal(28)	Yes	stores the exchange rate between the document currency and base currency	No
LOAHDR_BASE_CURRENCY	_varchar_20	varchar(20)	Yes	stores the base currency	No
LOAHDR_USER_STATUS	_varchar_25	Varchar(25)	Yes	stores the user defined status	No
LOAHDR_LO_CAT	_varchar_25	Varchar(25)	Yes	stores the loan order category defined in logistics common master	No
LOAHDR_LO_PRIORITY	_varchar_20	varchar(20)	Yes	stores the loan order priority	No
LOAHDR_AC_REGNO	_varchar_30	varchar(30)	Yes	Aircraft Registration number	No
LOAHDR_LO_REASON	_varchar_2000	varchar(2000)	Yes	stores the reason	No
LOAHDR_CONTACT_PERSON	_varchar_80	varchar(80)	Yes	stores the contact person name for the supplier	No
LOAHDR_SUPP_ADDR_ID	_decimal_6_0	decimal(6)	Yes	stores the supplier s address id	No
LOAHDR_QUANTITY	_decimal_28_8	decimal(28)	Yes	stores the quantity of the loaned part	No
LOAHDR_RECVD_QTY	_decimal_28_8	decimal(28)	Yes	stores the received quantity of the loaned part	No
LOAHDR_PART_CONDN	_varchar_5	varchar(5)	Yes	stores the condition of the loaned part	No
LOAHDR_CERT_TYPE	_varchar_25	Varchar(25)	Yes	stores the certification type defined in logistics common master	No
LOAHDR_SHIP_TO	_decimal_4_0	decimal(4)	Yes	stores the ship to location	No
LOAHDR_WH_NO	_varchar_10	varchar(10)	Yes	stores the warehouse number	No
LOAHDR_LOAN_AGMT_NO	_varchar_40	varchar(40)	Yes	stores the loan agreement number	No
LOAHDR_SUPP_OFFERNO	_varchar_40	varchar(40)	Yes	stores the supplier offer number	No
LOAHDR_REF_DOC	_varchar_25	Varchar(25)	Yes	stores the user entered reference document	No
LOAHDR_REF_DOC_NO	_varchar_40	varchar(40)	Yes	stores the user entered reference document number	No
LOAHDR_LOAN_CHRGS_ON	_varchar_5	varchar(5)	Yes	stores the flag for Loan Charges On. List of values are: CB - Calendar Based PB - Parameter Based BH - Both NE - None	No
LOAHDR_PENALTY_APPLICABLE	_varchar_5	varchar(5)	Yes	stores the flag whether penalty applicable or not. Values are: Y - Yes N - No	No
LOAHDR_TCD_APPLICABLE	_varchar_5	varchar(5)	Yes	stores the flag whether TCD applicable or not. Values are: Y - Yes N - No	No
LOAHDR_DATE_REQD	_datetime_8	datetime(8)	Yes	stores the date from when the loan begins	No
LOAHDR_LOAN_PERIOD_VALUE	_decimal_28_0	decimal(28)	Yes	stores the value of the loan period	No
LOAHDR_LOAN_PERIOD_UNITS	_varchar_5	varchar(5)	Yes	stores the UOM of the loan period. Allowed values are: D - Days W - Weeks M - Months	No
LOAHDR_LEAD_PARAM	_varchar_40	varchar(40)	Yes	stores the lead parameter of the laon order part number	No
LOAHDR_LEAD_PARAM_UOM	_varchar_10	varchar(10)	Yes	stores the UOM of the lead parameter	No
LOAHDR_EXPECTED_USAGE	_decimal_28_0	decimal(28)	Yes	stores the expected usage of the lead parameter	No
LOAHDR_ADMIN_CHRGS_POLICY	_varchar_5	varchar(5)	Yes	stores the administrative charges policy for the loan order. Allowed values are: F - Flat P - Percent	No
LOAHDR_CBLC_POLICY	_varchar_5	varchar(5)	Yes	stores the calendar based lease charges policy for the loan order. Allowed values are: F - Flat P - Percent	No
LOAHDR_PBLC_POLICY	_varchar_5	varchar(5)	Yes	stores the parameter based charges policy for the loan order. Allowed values are: F - Flat P - Percent	No
LOAHDR_CBLC_BASIS	_varchar_5	varchar(5)	Yes	stores the calendar based charges basis for the laon order. Allowed values are: C - Cumulative P - Period	No
LOAHDR_PBLC_BASIS	_varchar_5	varchar(5)	Yes	stores the parameter based charges basis for the loan order. Allowed values are: C - Cumulative P - Period	No
LOAHDR_PART_BASECOST	_decimal_28_8	decimal(28)	Yes	stores the base cost of the loaned part	No
LOAHDR_ADMIN_CHRGS_IN_PERC	_decimal_28_8	decimal(28)	Yes	stores the percent value for the administrative charges to be applied on part base cost	No
LOAHDR_ADMIN_CHARGES	_decimal_28_8	decimal(28)	Yes	stores the user enterd administrative charges. This will be considered only if percent value is not specified in the administrative charges percent field	No
LOAHDR_BASIC_LOAN_CHARGES	_decimal_28_8	decimal(28)	Yes	stores the basic loan charges which is the combination of calendar based and parameter based lease charges captured in the multiline	No
LOAHDR_ADDNL_CHARGES	_decimal_28_8	decimal(28)	Yes	stores the administrative charges. It is the total sum of the TCD amounts	No
LOAHDR_BASE_CURR_VAL	_decimal_28_8	decimal(28)	Yes	stores the loan order value in base currency	No
LOAHDR_EMPLOYEENO	_varchar_20	varchar(20)	Yes	stores the employee number	No
LOAHDR_EMPLOYEE_NAME	_varchar_77	varchar(77)	Yes	stores the employee name	No
LOAHDR_LO_DETAIL1	_varchar_30	varchar(30)	Yes	stores the user defined detail 1	No
LOAHDR_LO_OPTION1	_varchar_30	varchar(30)	Yes	stores the user defined option 1	No
LOAHDR_HDR_COMMENTS	_varchar_255	varchar(255)	Yes	stores the comments for the loan order	No
LOAHDR_DOC_FILENAME	_varchar_50	varchar(50)	Yes	stores the document file name attached to the loan order	No
LOAHDR_TCD_COMMENTS	_varchar_255	varchar(255)	Yes	stores the TCD comments for the loan order	No
LOAHDR_AC_TCD_AMT	_decimal_28_8	decimal(28)	Yes	stores the TCD amount calculated based on Administrative Charges	No
LOAHDR_BLC_TCD_AMT	_decimal_28_8	decimal(28)	Yes	stores the TCD amount calculated based on Basic Loan Charges	No
LOAHDR_TLC_TCD_AMT	_decimal_28_8	decimal(28)	Yes	stores the TCD amount calculated based on Total Loan Charges	No
LOAHDR_PBC_TCD_AMT	_decimal_28_8	decimal(28)	Yes	stores the TCD amount calculated based on Part base cost	No
LOAHDR_TOTAL_LOAN_CHARGES	_decimal_28_8	decimal(28)	Yes	stores the total loan charges which is the sum of administrative and basic loan charges	No
LOAHDR_CREATED_BY	_varchar_30	varchar(30)	Yes	stores the user who created the loan order	No
LOAHDR_CREATED_DATE	_datetime_8	datetime(8)	Yes	stores the loan order created date	No
LOAHDR_MODIFIED_BY	_varchar_30	varchar(30)	Yes	stores the user who modified the loan order	No
LOAHDR_MODIFIED_DATE	_datetime_8	datetime(8)	Yes	stores the loan order modified date	No
LOAHDR_AUTHORISED_DATE	_datetime_8	datetime(8)	Yes	stores the loan order authorization date	No
LOAHDR_AUTHORISED_BY	_varchar_30	varchar(30)	Yes	stores the user who authorized the loan order	No
LOAHDR_AMENDMENT_DATE	_datetime_8	datetime(8)	Yes	stores the loan order amendment date	No
LOAHDR_AMENDMENT_BY	_varchar_30	varchar(30)	Yes	stores the user who amended the loan order	No
LOAHDR_COMMENTS	_varchar_255	varchar(255)	Yes	stores the comments for cancellation	No
LOAHDR_NUM_TYPE_NUM	_varchar_5	varchar(5)	Yes	stores the numbering type number for a loan order	No
LOAHDR_WF_DOC_KEY	_varchar_128	varchar(128)	Yes	stores the doc key of a loan order for work flow purpose	No
LOAHDR_STAGE	_varchar_10	varchar(10)	Yes	stores the stage of the loan order. This is an intermediate state fetched from work flow while the documnet goes through different stages of authorization	No
LOAHDR_TIMESTAMP	_decimal_20_0	decimal(20)	Yes	Timestamp which is internally used to check if user works on the latest record set	No
LOAHDR_ISS_LOC	_decimal_4_0	decimal(4)	Yes	Stores the location from where the issue can happen for returning the loaned part	No
LOAHDR_ISS_WH	_varchar_10	varchar(10)	Yes	Stores the warehouse from where the issue can happen for returning the loaned part	No
LOAHDR_PENDING_ISS_QTY	_decimal_28_8	decimal(28)	Yes	Stores the pending quantity of rental order to be issued	No
LOAHDR_LORDER_TYPE	udd_designparamcode	varchar(5)	Yes	This field captures the Loan order type	No
LOAHDR_PURCHASE_COST	udd_amount	numeric(13)	Yes	This field captures the Loan Order purchase cost	No
LOAHDR_INTSTK_STATUS	udd_partstatus	varchar(40)	Yes	This field captures the internal stock status of the Loan Order	No
loahdr_below_threshold	udd_partstatus	varchar(40)	Yes	Threshhold	No
LOAHDR_VALUE_DIFF	udd_amount	numeric(13)	Yes	Column to store value diff between the previous amendment No and current Amendment No	No
LOAHDR_ACTUAL_LOAN_CHARGES	udd_amount	numeric(13)	Yes	Column to store the actual loan order charges for the actual usage period.	No

Table Name :	LO_LOALC_LEASE_CHARGES
Comment :	This Table holds the calendar based and parameter based lease charges for an amended loan order document

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
LOALC_LO_OUINSTANCE	_decimal_4_0	decimal(4)	No	stores the OUInstance where the loan order is created	Yes
LOALC_LO_NO	_varchar_40	varchar(40)	No	stores the loan order number	Yes
LOALC_AMEND_NO	_decimal_6_0	decimal(6)	No	stortes the amemdment number	Yes
LOALC_MLTLINE_FLAG	_varchar_5	varchar(5)	No	Holds the multiline flag which differentiates whether the record is from calendar based multiline or parameter based multiline Allowed values: 1. CB - calendar based 2. PB - parameter based	Yes
LOALC_LINE_ID	_decimal_6_0	decimal(6)	No	stores the line id which is a generated serial number	Yes
LOALC_FROM_CAL_PERIOD	_decimal_28_8	decimal(28)	Yes	stores the from value of a period	No
LOALC_TO_CAL_PERIOD	_decimal_28_8	decimal(28)	Yes	stores the to value of a period	No
LOALC_FROM_PARAMVAL	_decimal_28_8	decimal(28)	Yes	stores the from value of a parameter value	No
LOALC_TO_PARAMVAL	_decimal_28_8	decimal(28)	Yes	stores the to value of a parameter value	No
LOALC_RATE_PER_UOM	_decimal_28_8	decimal(28)	Yes	stores the flat rate per UOM of caledar period or the flat rate per UOM of parameter	No
LOALC_CHARGE_PER_UNIT	_decimal_28_8	decimal(28)	Yes	stores the charge per unit. If the charges ploicy is flat, it is calculated as (To value - (From value - 1)) * flat rate per UOM. If the charges policy is percent, it is calculated as (To value - (From value - 1)) * base part cost * percent valu	No
LOALC_CHARGE_FOR_PERIOD	_decimal_28_8	decimal(28)	Yes	If the charges ploicy is flat, it is calculated as (To period - (From period - 1)) * flat rate per UOM. If the charges policy is percent, it is calculated as (To period - (From period - 1)) *base part cost * percent value/100	No
LOALC_REMARKS	_varchar_255	varchar(255)	Yes	stores the remarks	No

Table Name :	LO_LOAPCD_PENALTY_CHARGES
Comment :	This table stores the penalty charges of an amended Loan Order

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
LOAPCD_LO_OUINSTANCE	_decimal_4_0	decimal(4)	No	stores the OUInstance where the loan order is created	Yes
LOAPCD_LO_NO	_varchar_40	varchar(40)	No	stores the loan order number	Yes
LOAPCD_AMEND_NO	_decimal_6_0	decimal(6)	No	stores the amendment number of the loan order	Yes
LOAPCD_MLTLINE_FLAG	_varchar_5	varchar(5)	No	Holds the multiline flag which differentiates whether the record is from calendar based multiline or parameter based multiline Allowed values: 1. CB - calendar based 2. PB - parameter based	Yes
LOAPCD_LINE_ID	_decimal_6_0	decimal(6)	No	stores the line id which is a generated serial number	Yes
LOAPCD_FROM_CAL_PERIOD	_decimal_28_8	decimal(28)	Yes	stores the from value of a period	No
LOAPCD_TO_CAL_PERIOD	_decimal_28_8	decimal(28)	Yes	This field holds the To value of a period	No
LOAPCD_FROM_PARAMVAL	_decimal_28_8	decimal(28)	Yes	stores the from value of a parameter value	No
LOAPCD_TO_PARAMVAL	_decimal_28_8	decimal(28)	Yes	stores the to value of a parameter value	No
LOAPCD_RATE_PER_UOM	_decimal_28_8	decimal(28)	Yes	stores the flat rate per UOM of caledar period or the flat rate per UOM of parameter	No
LOAPCD_CHARGE_PER_UNIT	_decimal_28_8	decimal(28)	Yes	stores the penalty charge per unit. If the charges ploicy is flat, it is calculated as (To value - (From value - 1)) * flat rate per UOM. If the charges policy is percent, it is calculated as (To value - (From value - 1)) *base part cost * perce	No
LOAPCD_CHARGE_FOR_PERIOD	_decimal_28_8	decimal(28)	Yes	stores the penalty charge per period If the charges ploicy is flat, it is calculated as (To period - (From period - 1)) * flat rate per UOM. If the charges policy is percent, it is calculated as (To period - (From period - 1)) * base part cost * pe	No
LOAPCD_REMARKS	_varchar_255	varchar(255)	Yes	stores the remarks	No

Table Name :	LO_LOAPCH_PENALTY_CHRGS_HDR
Comment :	This table stores the penalty charges header details for an amended Loan Order

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
LOAPCH_LO_OUINSTANCE	_decimal_4_0	decimal(4)	No	This field holds the OUInstance where the loan order is created	Yes
LOAPCH_LO_NO	_varchar_40	varchar(40)	No	This field holds the loan order number	Yes
LOAPCH_AMEND_NO	_decimal_6_0	decimal(6)	No	This field holds the amendment number for the loan order	Yes
LOAPCH_FIX_PENALTY_CHRGS	_decimal_28_8	decimal(28)	Yes	This field holds the fix penalty charges for the loan order	No
LOAPCH_COMMENTS	_varchar_255	varchar(255)	Yes	This field holds the comments	No
LOAPCH_CBPC_POLICY	_varchar_5	varchar(5)	Yes	This field holds the calendar based lease charges policy for the loan order. Allowed values are: F - Flat P - Percent	No
LOAPCH_CBPC_BASIS	_varchar_5	varchar(5)	Yes	This field holds the calendar based charges policy for the loan order. Allowed values are: C - Cumulative P - Period	No
LOAPCH_PBPC_POLICY	_varchar_5	varchar(5)	Yes	This field holds the parameter based charges policy for the loan order. Allowed values are: F - Flat P - Percent	No
LOAPCH_PBPC_BASIS	_varchar_5	varchar(5)	Yes	This field holds the parameter based charges policy for the loan order. Allowed values are: C - Cumulative P - Period	No

Table Name :	LO_LOASOPT_SETOPTIONS_INFO
Comment :	This table stores the set options information change history for Loan Order

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
LOASOPT_LO_OUINSTANCE	_decimal_4_0	decimal(4)	No	stores the OUInstance	Yes
LOASOPT_SET_OPT_ID	_decimal_6_0	decimal(6)	No	stores the option id which is running serial number	Yes
LOASOPT_PRTTYPE_ALLOWED	_varchar_40	varchar(40)	No	This field stores the flag for part types allowed on which a loan order can be raised. There can be 3 values alloed: 1. Component - C 2. Others - O 3. All - A	No
LOASOPT_ALLOW_ALTPRT_RCPT	_varchar_5	varchar(5)	Yes	This field holds the flag whether it is allowed to receive an alternate part. The values are: Y - Yes N - No	No
LOASOPT_CHARGE_CALC_PRD	_varchar_5	varchar(5)	Yes	This field holds the value applicable as the period for charge calculation. Allowed values are: SD - Supplier Ship To Receipt Date PD - Part Receipt To Ship Date	No
LOASOPT_LOAN_CHARGES	_varchar_5	varchar(5)	Yes	This field holds the flag whether Loan charges is enterable or Non enterable. Allowed values are: "E" - "Enterable", "N" - "Non Enterable"	No
LOASOPT_CREATED_BY	_varchar_30	varchar(30)	Yes	Holds the username who created the record	No
LOASOPT_CREATED_DATE	_datetime_8	datetime(8)	Yes	Holds the date on which the record is created	No
LOASOPT_MODIFIED_BY	_varchar_30	varchar(30)	Yes	Holds the username who modified the record	No
LOASOPT_MODIFIED_DATE	_datetime_8	datetime(8)	Yes	Holds the date on which the record is modified	No

Table Name :	LO_LOATMCN_LO_TERMS_CONDNS
Comment :	This table holds the Terms and Condition of an amended Loan order document

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
LOATMCN_LO_OUINSTANCE	_decimal_4_0	decimal(4)	No	stores the OUInstance where the loan order is created	Yes
LOATMCN_LO_NO	_varchar_40	varchar(40)	No	stores the loan order number	Yes
LOATMCN_GTA_REFDOC_NO	_varchar_40	varchar(40)	Yes	This field holds the General Terms Agreement reference documentno	No
LOATMCN_AMEND_NO	_decimal_6_0	decimal(6)	No	stores the amendment no of the loan order	Yes
LOATMCN_REFDOC_DATE	_datetime_8	datetime(8)	Yes	This field holds the General Terms Agreement reference document Date	No
LOATMCN_GTA_REMARKS	_varchar_255	varchar(255)	Yes	This field holds the General Terms Agreement remarks	No
LOATMCN_ADVANCE_PAYABLE	_varchar_5	varchar(5)	Yes	This field holds the advance payable flag of the purchase order document. List of values "Y" - "Yes", "N" - "No".	No
LOATMCN_ADVANCE_PERC_ON	_varchar_5	varchar(5)	Yes	This field holds the advance percentage on of the purchase order document. List of values "PBC" - "Part Base Cost", "BLC" - "Basic Loan Charges", "OV" - "Order Value".	No
LOATMCN_ADVANCE_PERC	_decimal_28_8	decimal(28)	Yes	This field holds the advance percentage.	No
LOATMCN_ADVANCE_PAY_AMT	_decimal_28_8	decimal(28)	Yes	This field holds the advance payable amount. If advance payable flag is yes then this is mandatory	No
LOATMCN_ADVANCE_TOL_PERC	_decimal_28_8	decimal(28)	Yes	This field holds the advance tolerence percentage.	No
LOATMCN_ADVANCE_PAYDATE	_datetime_8	datetime(8)	Yes	This field holds the advance payable date. If advance payable flag is yes then this is mandatory	No
LOATMCN_PAY_TO_SUPP	_varchar_45	varchar(45)	Yes	A valid supplier defined in the Supplier component and mapped to the Supplier (who supplies the goods requested )as pay to supplier ( to whom the payment can be made)	No
LOATMCN_PAY_TO_SUPP_OU	_decimal_4_0	decimal(4)	Yes	stores the OUInstance of the supplier defined as the pay to supplier for the base supplier	No
LOATMCN_PAYTERM_CODE	_varchar_25	Varchar(25)	Yes	This field holds the Unique identifier for the Payterm	No
LOATMCN_PAY_PRIORITY	_varchar_5	varchar(5)	Yes	This field holds the payment priority of the PO doument List of values are " H" - "High", "N" - "Normal", "L" - "Low".	No
LOATMCN_PAYMENT_MODE	_varchar_5	varchar(5)	Yes	This field holds varous payment mode. list of values are (Cq)Cheque (Cs)Cash (D)raft (P)ay order	No
LOATMCN_DDCHARGES_BORNEBY	_varchar_5	varchar(5)	Yes	This field holds the DD charges brone by of the purchase order document. List of values "SU" - "Supplier", "SE" - "Self".	No
LOATMCN_TOLERANCE_TYPE	_varchar_5	varchar(5)	Yes	stores the flag for tolerance type Values: "V" - "Value".	No
LOATMCN_TOLERANCE_PERC	_decimal_28_8	decimal(28)	Yes	stores the tolerance percentage	No
LOATMCN_PAY_TO_SUPP_ID	_decimal_6_0	decimal(6)	Yes	This field holds the pay to supplier address ids	No
LOATMCN_REMARKS	_varchar_255	varchar(255)	Yes	This field holds the remarks of the purchase order documen s terms and condition.	No
LOATMCN_SHIP_BY	_varchar_25	Varchar(25)	Yes	This field holds the mode of transport of the purchase order document. Mode of transports are 1. AIR 2.LAND	No
LOATMCN_SHIP_PAYMENT	_varchar_25	Varchar(25)	Yes	This field holds the list of shipping payment methods in active status defined in the Logistics common master component.	No
LOATMCN_PKG_CODE	_varchar_25	Varchar(25)	Yes	This field holds the packaging terms of the purchase order document. List of values 1. Bottle 2. Box	No
LOATMCN_INSPECTION_TYPE	_varchar_5	varchar(5)	Yes	stores the flag for inspection type "S" - "Self", "BI" - "By Inspector", "N" - " None".	No
LOATMCN_INCO_TERM	_varchar_150	varchar(150)	Yes	This field holds the INCO term of the purchase order document.	No
LOATMCN_CARRIERAGENCY	_varchar_20	varchar(20)	Yes	This field holds the list of carrier agencies	No
LOATMCN_PORT_OF_DEP	_varchar_32	varchar(32)	Yes	This field holds the port of depature	No
LOATMCN_DELIVERY_POINT	_varchar_32	varchar(32)	Yes	This field holds the delivery point of the purchase order document.	No
LOATMCN_PACKAGING_NOTES	_varchar_2000	varchar(2000)	Yes	This field holds the packaging notes	No
LOATMCN_SHIPPING_NOTES	_varchar_2000	varchar(2000)	Yes	This field holds the shipping notes	No
LOATMCN_INSURANCE_LIABILITY	_varchar_150	varchar(150)	Yes	This field holds insurance liability of the PO document List of values are "SU" - "Supplier", "SE" - "Self", "O" - "Others".	No
LOATMCN_INSURANCE_AMT	_decimal_28_8	decimal(28)	Yes	This field holds the insurence amount of the purchase order document.	No
LOATMCN_INSURANCE_TERMS	_varchar_150	varchar(150)	Yes	This field holds the insurence term of purchase order document.	No
LOATMCN_LO_DETAIL2	_varchar_20	varchar(20)	Yes	stores the used defined detail	No
LOATMCN_LO_DETAIL3	_varchar_20	varchar(20)	Yes	stores the used defined detail3	No
LOATMCN_LO_DETAIL4	_varchar_20	varchar(20)	Yes	stores the used defined detail4	No
LOATMCN_LO_OPTION2	_varchar_20	varchar(20)	Yes	stores the used defined option	No
LOATMCN_LO_OPTION3	_varchar_20	varchar(20)	Yes	stores the used defined option3	No
LOATMCN_LO_OPTION4	_varchar_20	varchar(20)	Yes	stores the used defined option4	No
LOATMCN_RMANO	udd_documentno	varchar(40)	Yes	Column to store RMA No	No
LOATMCN_RMADATE	udd_time	datetime(8)	Yes	Column to store RMA Date	No
LOATMCN_RET_SUPP_ID	udd_vendorcode	varchar(45)	Yes	Column to Store Supplier ID	No

Table Name :	LO_LOCD_LOANORDER_CLOSE_DET
Comment :	This table stores the shipping and closing details of Loan order document

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
LOCD_LO_OUINSTANCE	_decimal_4_0	decimal(4)	No	stores the OUInstance where the loan order is created	Yes
LOCD_LO_NO	_varchar_40	varchar(40)	No	stores the loan order number	Yes
LOCD_ACKLDGE_REF_NO	_varchar_40	varchar(40)	Yes	stores the acknowledgement number	No
LOCD_ACKLDGE_DATE	_datetime_8	datetime(8)	Yes	stores acknowledgement date	No
LOCD_RCPT_SATISFACTORY	_varchar_5	varchar(5)	Yes	stores the flag to identify whether receipt of the part at the supplier site is satisfactory or not "Y"- "Yes", "N" - "No".	No
LOCD_COMMENTS	_varchar_255	varchar(255)	Yes	stores the acknowledgement comments	No
LOCD_ACT_LOAN_PERIOD	_decimal_28_0	decimal(28)	Yes	stores the actual loan period	No
LOCD_ACT_USAGE	_decimal_28_0	decimal(28)	Yes	stores the actual usage of the lead param value	No
LOCD_CAL_BASED_CHRGE	_decimal_28_8	decimal(28)	Yes	stores the calendar based lease charges	No
LOCD_PARAM_BASED_CHRGS	_decimal_28_8	decimal(28)	Yes	stores the parameter based lease charges	No
LOCD_FIX_PENALTY_CHRGS	_decimal_28_8	decimal(28)	Yes	stores the fixed penalty charges	No
LOCD_CBASED_PENALTY_CHRGS	_decimal_28_8	decimal(28)	Yes	stores the calendar based penalty charges	No
LOCD_PBASED_PENALTY_CHRGS	_decimal_28_8	decimal(28)	Yes	stores the parameter based penalty charges	No
LOCD_ACT_ORDER_VALUE	_decimal_28_8	decimal(28)	Yes	stores the actual order value	No
LOCD_USDEF_DTL5	_varchar_40	varchar(40)	Yes	Stores the user defined detail 5 defined as part of acknowledgement information	No
LOCD_USDEF_DTL6	_varchar_40	varchar(40)	Yes	Stores the user defined detail 6 defined as part of acknowledgement information	No
LOCD_USDEF_DTL7	_varchar_40	varchar(40)	Yes	Stores the user defined detail 7 defined as part of acknowledgement information	No

Table Name :	LO_LODTCD_LO_DOC_TCD
Comment :	This table holds the Document TCD details of Loan order.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
LODTCD_LO_OUINSTANCE	_decimal_4_0	decimal(4)	No	stores the OUInstance where the loan order is created	Yes
LODTCD_LO_NO	_varchar_40	varchar(40)	No	stores the loan order number	Yes
LODTCD_TCD_MODE	_varchar_5	varchar(5)	No	stores the mode for which the TCDs are captured. "AC" - "Administrative Charges", "BLC" - "Basic Loan Charges", "TLC" - "Total Loan Charges", "PBC" - "Part Base Cost".	Yes
LODTCD_LINE_NO	_decimal_6_0	decimal(6)	No	This field holds the Unique identifier number for the TCD of the loan order	Yes
LODTCD_TCD_CODE	_varchar_25	Varchar(25)	No	This field holds the Unique identifier for the TCD	No
LODTCD_TCD_VARIANT	_varchar_25	Varchar(25)	No	This field holds the TCD variant for the TCD code.	No
LODTCD_USER_SEQ	_decimal_6_0	decimal(6)	Yes	holds the sequence number as entered by the user for the TCD	No
LODTCD_TCD_OU	_decimal_4_0	decimal(4)	Yes	stores the TCD OUInstance	No
LODTCD_TCD_RATE	_decimal_28_8	decimal(28)	Yes	TCD rate for the TCD code and the variant . this should not be changed for TCD basis -- Percentage.	No
LODTCD_TCD_AMOUNT	_decimal_28_8	decimal(28)	Yes	The Tcd amount that will be calculated from the TCD component for the TCD code and the variant and the TCD rate supplied	No
LODTCD_PAY_CURRENCY	_varchar_20	varchar(20)	Yes	This field holds the Transaction currency	No
LODTCD_PAY_TO_SUPP	_varchar_45	varchar(45)	Yes	A valid supplier defined in the Supplier component and mapped to the Supplier (who supplies the services requested )as pay to supplier ( to whom the payment can be made)	No
LODTCD_PAY_TO_SUPP_OU	_decimal_4_0	decimal(4)	Yes	Stores the pay to supplier OUInstance	No
LODTCD_EXCHG_RATE	_decimal_28_8	decimal(28)	Yes	Holds the exchage rate between the document currency and the payment currency	No
LOTCD_COST_DIFF	udd_amount	numeric(13)	Yes	Column to capture the cost diff between the previous amendment and current amendment	No
lodtcd_tax_incid	udd_taxinci	Varchar(40)	Yes	Ths field holds the Tax Incidence details	No

Table Name :	LO_LOHDR_LOAN_ORDER_HDR
Comment :	This table holds the Loan order information

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
LOHDR_LO_OUINSTANCE	_decimal_4_0	decimal(4)	No	stores the OUInstance where the loan order is created	Yes
LOHDR_LO_NO	_varchar_40	varchar(40)	No	stores the loan order number	Yes
LOHDR_AMEND_NO	_decimal_6_0	decimal(6)	No	stores the loan order amendment number. if the LO is not amended then 0 is stored	No
LOHDR_LO_DATE	_datetime_8	datetime(8)	No	stores the document date	No
LOHDR_LO_STATUS	_varchar_5	varchar(5)	No	stores the document status. allowed values are: "FR" - " Fresh", "DR" - " Draft", "AUT" - "Authorized", "RET"- "Returned", "UAT"- " Under Authorization", "AMD" - "Amended", "SHD"- "Shipped", "CLS" - "Closed", "CAN"- "Cancelled", "REV" - "Revised",	No
LOHDR_PART_NO	_varchar_40	varchar(40)	No	stores the part no on which the loan order is raised	No
LOHDR_PRT_SRL_NO	_varchar_40	varchar(40)	Yes	stores the part serial no	No
LOHDR_PART_OUINSTANCE	_decimal_4_0	decimal(4)	Yes	stores the part OUinstance	No
LOHDR_SUPP_CODE	_varchar_45	varchar(45)	No	stores the supplier code	No
LOHDR_SUPP_CREATED_OU	_decimal_4_0	decimal(4)	Yes	stores the OUInstance where the supplier is created	No
LOHDR_SUPP_OU	_decimal_4_0	decimal(4)	Yes	stores the supplier OUinstance	No
LOHDR_LO_CURRENCY	_varchar_20	varchar(20)	Yes	stores the document/order currency	No
LOHDR_EXCHANGE_RATE	_decimal_28_8	decimal(28)	Yes	stores the exchange rate between the document currency and base currency	No
LOHDR_BASE_CURRENCY	_varchar_20	varchar(20)	Yes	stores the base currency	No
LOHDR_USER_STATUS	_varchar_25	Varchar(25)	Yes	stores the user defined status	No
LOHDR_LO_CAT	_varchar_25	Varchar(25)	Yes	stores the loan order category defined in logistics common master	No
LOHDR_LO_PRIORITY	_varchar_20	varchar(20)	Yes	stores the loan order priority	No
LOHDR_AC_REGNO	_varchar_30	varchar(30)	Yes	stores the Air craft registration number	No
LOHDR_LO_REASON	_varchar_2000	varchar(2000)	Yes	stores the reason	No
LOHDR_CONTACT_PERSON	_varchar_80	varchar(80)	Yes	stores the contact person name for the supplier	No
LOHDR_SUPP_ADDR_ID	_decimal_6_0	decimal(6)	Yes	stores the supplier s address id	No
LOHDR_QUANTITY	_decimal_28_8	decimal(28)	Yes	stores the quantity of the loaned part	No
LOHDR_RECVD_QTY	_decimal_28_8	decimal(28)	Yes	stores the received quantity of the loaned part	No
LOHDR_PART_CONDN	_varchar_5	varchar(5)	Yes	stores the condition of the loaned part	No
LOHDR_CERT_TYPE	_varchar_25	Varchar(25)	Yes	stores the certification type defined in logistics common master	No
LOHDR_SHIP_TO	_decimal_4_0	decimal(4)	Yes	stores the ship to location	No
LOHDR_WH_NO	_varchar_10	varchar(10)	Yes	stores the warehouse number	No
LOHDR_LOAN_AGMT_NO	_varchar_40	varchar(40)	Yes	stores the loan agreement number	No
LOHDR_SUPP_OFFERNO	_varchar_40	varchar(40)	Yes	stores the supplier offer number	No
LOHDR_REF_DOC	_varchar_25	Varchar(25)	Yes	stores the user entered reference document	No
LOHDR_REF_DOC_NO	_varchar_40	varchar(40)	Yes	stores the user entered reference document number	No
LOHDR_LOAN_CHRGS_ON	_varchar_5	varchar(5)	Yes	stores the flag for Loan Charges On. List of values are: CB - Calendar Based PB - Parameter Based BH - Both NE - None	No
LOHDR_PENALTY_APPLICABLE	_varchar_5	varchar(5)	Yes	stores the flag whether penalty applicable or not. Values are: Y - Yes N - No	No
LOHDR_TCD_APPLICABLE	_varchar_5	varchar(5)	Yes	stores the flag whether TCD applicable or not. Values are: Y - Yes N - No	No
LOHDR_DATE_REQD	_datetime_8	datetime(8)	Yes	stores the date from when the loan begins	No
LOHDR_LOAN_PERIOD_VALUE	udd_quantity	numeric(13)	Yes	stores the value of the loan period	No
LOHDR_LOAN_PERIOD_UNITS	_varchar_5	varchar(5)	Yes	stores the UOM of the loan period. Allowed values are: "D" - "Days", "W" - "Weeks", "M"- "Months", "B" - "Blank".	No
LOHDR_LEAD_PARAM	_varchar_40	varchar(40)	Yes	stores the lead parameter of the laon order part number	No
LOHDR_LEAD_PARAM_UOM	_varchar_10	varchar(10)	Yes	stores the UOM of the lead parameter	No
LOHDR_EXPECTED_USAGE	udd_quantity	numeric(13)	Yes	stores the expected usage of the lead parameter	No
LOHDR_ADMIN_CHRGS_POLICY	_varchar_5	varchar(5)	Yes	stores the administrative charges policy for the loan order. Allowed values are: F - Flat P - Percent	No
LOHDR_CBLC_POLICY	_varchar_5	varchar(5)	Yes	stores the calendar based lease charges policy for the loan order. Allowed values are: F - Flat P - Percent	No
LOHDR_PBLC_POLICY	_varchar_5	varchar(5)	Yes	stores the parameter based charges policy for the loan order. Allowed values are: F - Flat P - Percent	No
LOHDR_CBLC_BASIS	_varchar_5	varchar(5)	Yes	stores the calendar based charges basis for the loan order. Allowed values are: C - Cumulative P - Period	No
LOHDR_PBLC_BASIS	_varchar_5	varchar(5)	Yes	stores the parameter based charges basis for the loan order. Allowed values are: C - Cumulative P - Period	No
LOHDR_PART_BASECOST	_decimal_28_8	decimal(28)	Yes	stores the base cost of the loaned part	No
LOHDR_ADMIN_CHRGS_IN_PERC	_decimal_28_8	decimal(28)	Yes	stores the percent value for the administrative charges to be applied on part base cost	No
LOHDR_ADMIN_CHARGES	_decimal_28_8	decimal(28)	Yes	stores the user enterd administrative charges. This will be considered only if percent value is not specified in the administrative charges percent field	No
LOHDR_BASIC_LOAN_CHARGES	_decimal_28_8	decimal(28)	Yes	stores the basic loan charges which is the combination of calendar based and parameter based lease charges captured in the multiline	No
LOHDR_ADDNL_CHARGES	_decimal_28_8	decimal(28)	Yes	stores the administrative charges. It is the total sum of the TCD amounts	No
LOHDR_BASE_CURR_VAL	_decimal_28_8	decimal(28)	Yes	stores the loan order value in base currency	No
LOHDR_EMPLOYEENO	_varchar_20	varchar(20)	Yes	stores the employee number	No
LOHDR_EMPLOYEE_NAME	_varchar_77	varchar(77)	Yes	stores the employee name	No
LOHDR_LO_DETAIL1	_varchar_30	varchar(30)	Yes	stores the user defined detail 1	No
LOHDR_LO_OPTION1	_varchar_30	varchar(30)	Yes	stores the user defined option 1	No
LOHDR_HDR_COMMENTS	_varchar_255	varchar(255)	Yes	stores the comments for the loan order	No
LOHDR_DOC_FILENAME	_varchar_50	varchar(50)	Yes	stores the document file name attached to the loan order	No
LOHDR_TCD_COMMENTS	_varchar_255	varchar(255)	Yes	stores the TCD comments for the loan order	No
LOHDR_AC_TCD_AMT	_decimal_28_8	decimal(28)	Yes	stores the TCD amount calculated based on Administrative Charges	No
LOHDR_BLC_TCD_AMT	_decimal_28_8	decimal(28)	Yes	stores the TCD amount calculated based on Basic Loan Charges	No
LOHDR_TLC_TCD_AMT	_decimal_28_8	decimal(28)	Yes	stores the TCD amount calculated based on Total Loan Charges	No
LOHDR_PBC_TCD_AMT	_decimal_28_8	decimal(28)	Yes	stores the TCD amount calculated based on Part base cost	No
LOHDR_TOTAL_LOAN_CHARGES	_decimal_28_8	decimal(28)	Yes	stores the total loan charges which is the sum of administrative and basic loan charges	No
LOHDR_CREATED_BY	_varchar_30	varchar(30)	Yes	stores the user who created the loan order	No
LOHDR_CREATED_DATE	_datetime_8	datetime(8)	Yes	stores the loan order created date	No
LOHDR_MODIFIED_BY	_varchar_30	varchar(30)	Yes	stores the user who modified the loan order	No
LOHDR_MODIFIED_DATE	_datetime_8	datetime(8)	Yes	stores the loan order modified date	No
LOHDR_TIMESTAMP	_decimal_20_0	decimal(20)	Yes	stores the timestamp. Initial value is 1. incremented by 1 everytime the record is modified	No
LOHDR_AUTHORISED_DATE	_datetime_8	datetime(8)	Yes	stores the loan order authorization date	No
LOHDR_AUTHORISED_BY	_varchar_30	varchar(30)	Yes	stores the user who authorized the loan order	No
LOHDR_AMENDMENT_DATE	_datetime_8	datetime(8)	Yes	stores the loan order amendment date	No
LOHDR_AMENDMENT_BY	_varchar_30	varchar(30)	Yes	stores the user who amended the loan order	No
LOHDR_COMMENTS	_varchar_255	varchar(255)	Yes	stores the comments for cancellation	No
LOHDR_NUM_TYPE_NUM	_varchar_5	varchar(5)	Yes	stores the numbering type number for a loan order	No
LOHDR_WF_DOC_KEY	_varchar_128	varchar(128)	Yes	stores the doc key of a loan order for work flow purpose	No
LOHDR_STAGE	_varchar_10	varchar(10)	Yes	stores the stage of the loan order. This is an intermediate state fetched from work flow while the documnet goes through different stages of authorization	No
LOHDR_ISS_LOC	_decimal_4_0	decimal(4)	Yes	Stores the location from where the issue can happen for returning the loaned part	No
LOHDR_ISS_WH	_varchar_10	varchar(10)	Yes	Stores the warehouse from where the issue can happen for returning the loaned part	No
LOHDR_PENDING_ISS_QTY	_decimal_28_8	decimal(28)	Yes	Stores the pending quantity of loan order to be issued	No
LOHDR_LORDER_TYPE	udd_designparamcode	varchar(5)	Yes	This field captures the Loan Order type	No
LOHDR_PURCHASE_COST	udd_amount	numeric(13)	Yes	This field captures the purchase cost of the loan Order	No
LOHDR_INTSTK_STATUS	udd_partstatus	varchar(40)	Yes	This field holds the internal stock status of the Loan Order	No
LOHDR_LO_STATUSFLAG	udd_designparamcode	varchar(5)	Yes	When the loan order is created this flag will get updated as O and once the part is issued will get updated as R. If it is purchased then this will be R	No
lohdr_below_threshold	udd_partstatus	varchar(40)	Yes	If the loan order value is below then the threshhold value defined in cps_processparam_sys then Y else N	No
LOHDR_VALUE_DIFF	udd_amount	numeric(13)	Yes	Column to capture the difference in amount between the previous Amendment and current amendment	No
LOHDR_ACTUAL_LOAN_CHARGES	udd_amount	numeric(13)	Yes	Column to capture the Actual Loan Charges for the actual usage period.	No
LOHDR_PSC_NO	udd_documentno	varchar(40)	Yes	partserial change	No

Table Name :	LO_LOLC_LEASE_CHARGES
Comment :	This Table holds the calendar based and parameter based lease charges for a loan order document

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
LOLC_LO_OUINSTANCE	_decimal_4_0	decimal(4)	No	stores the OUInstance where the loan order is created	Yes
LOLC_LO_NO	_varchar_40	varchar(40)	No	stores the loan order number	Yes
LOLC_MLTLINE_FLAG	_varchar_5	varchar(5)	No	Holds the multiline flag which differentiates whether the record is from calendar based multiline or parameter based multiline Allowed values: 1. CB - calendar based 2. PB - parameter based	Yes
LOLC_LINE_ID	_decimal_6_0	decimal(6)	No	stores the line id which is a generated serial number	Yes
LOLC_FROM_CAL_PERIOD	_decimal_28_8	decimal(28)	Yes	stores the from value of a period	No
LOLC_TO_CAL_PERIOD	_decimal_28_8	decimal(28)	Yes	stores the to value of a period	No
LOLC_FROM_PARAMVAL	_decimal_28_8	decimal(28)	Yes	stores the from value of a parameter value	No
LOLC_TO_PARAMVAL	_decimal_28_8	decimal(28)	Yes	stores the to value of a parameter value	No
LOLC_RATE_PER_UOM	_decimal_28_8	decimal(28)	Yes	stores the flat rate per UOM of caledar period or the flat rate per UOM of parameter	No
LOLC_CHARGE_PER_UNIT	_decimal_28_8	decimal(28)	Yes	stores the charge per unit. If the charges ploicy is flat, it is calculated as (To value - (From value - 1)) * flat rate per UOM. If the charges policy is percent, it is calculated as (To value - (From value - 1)) * base part cost * percent valu	No
LOLC_CHARGE_FOR_PERIOD	_decimal_28_8	decimal(28)	Yes	If the charges ploicy is flat, it is calculated as (To period - (From period - 1)) * flat rate per UOM. If the charges policy is percent, it is calculated as (To period - (From period - 1)) *base part cost * percent value/100	No
LOLC_REMARKS	_varchar_255	varchar(255)	Yes	stores the remarks	No

Table Name :	LO_LOPCD_PENALTY_CHARGES
Comment :	This table stores the penalty charges defined for a Loan Order

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
LOPCD_LO_OUINSTANCE	_decimal_4_0	decimal(4)	No	stores the OUInstance where the loan order is created	Yes
LOPCD_LO_NO	_varchar_40	varchar(40)	No	stores the loan order number	Yes
LOPCD_MLTLINE_FLAG	_varchar_5	varchar(5)	No	Holds the multiline flag which differentiates whether the record is from calendar based multiline or parameter based multiline Allowed values: 1. CB - calendar based 2. PB - parameter based	Yes
LOPCD_LINE_ID	_decimal_6_0	decimal(6)	No	stores the line id which is a generated serial number	Yes
LOPCD_FROM_CAL_PERIOD	_decimal_28_8	decimal(28)	Yes	stores the from value of a period	No
LOPCD_TO_CAL_PERIOD	_decimal_28_8	decimal(28)	Yes	stores the to value of a period	No
LOPCD_FROM_PARAMVAL	_decimal_28_8	decimal(28)	Yes	stores the from value of a parameter value	No
LOPCD_TO_PARAMVAL	_decimal_28_8	decimal(28)	Yes	stores the to value of a parameter value	No
LOPCD_RATE_PER_UOM	_decimal_28_8	decimal(28)	Yes	stores the flat rate per UOM of caledar period or the flat rate per UOM of parameter	No
LOPCD_CHARGE_PER_UNIT	_decimal_28_8	decimal(28)	Yes	stores the penalty charge per unit. If the charges ploicy is flat, it is calculated as (To value - (From value - 1)) * flat rate per UOM. If the charges policy is percent, it is calculated as (To value - (From value - 1)) *base part cost * perce	No
LOPCD_CHARGE_FOR_PERIOD	_decimal_28_8	decimal(28)	Yes	stores the penalty charge per period If the charges ploicy is flat, it is calculated as (To period - (From period - 1)) * flat rate per UOM. If the charges policy is percent, it is calculated as (To period - (From period - 1)) * base part cost * pe	No
LOPCD_REMARKS	_varchar_255	varchar(255)	Yes	stores the remarks	No

Table Name :	LO_LOPCH_PENALTY_CHRGS_HDR
Comment :	This table stores the penalty charges header details for a Loan Order

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
LOPCH_LO_OUINSTANCE	_decimal_4_0	decimal(4)	No	stores the OUInstance where the loan order is created	Yes
LOPCH_LO_NO	_varchar_40	varchar(40)	No	stores the loan order number	Yes
LOPCH_FIX_PENALTY_CHRGS	_decimal_28_8	decimal(28)	Yes	stores the fix penalty charges for the loan order	No
LOPCH_COMMENTS	_varchar_255	varchar(255)	Yes	stores the comments	No
LOPCH_CBPC_POLICY	_varchar_5	varchar(5)	Yes	stores the calendar based lease charges policy for the loan order. Allowed values are: F - Flat P - Percent	No
LOPCH_CBPC_BASIS	_varchar_5	varchar(5)	Yes	stores the calendar based charges policy for the loan order. Allowed values are: C - Cumulative P - Period	No
LOPCH_PBPC_POLICY	_varchar_5	varchar(5)	Yes	stores the parameter based charges policy for the loan order. Allowed values are: F - Flat P - Percent	No
LOPCH_PBPC_BASIS	_varchar_5	varchar(5)	Yes	stores the parameter based charges policy for the loan order. Allowed values are: C - Cumulative P - Period	No

Table Name :	LO_LOPRM_PARAMETER_DTL
Comment :	This table is to hold Parameter Details for the Loan Order.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
LOPRM_COMPONENTNAME	_varchar_80	varchar(80)	No	This field holds the Name of the component.	Yes
LOPRM_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
LOPRM_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
LOPRM_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
LOPRM_LANGID	_decimal_4_0	decimal(4)	No	Language id. This is the language id of the record.	Yes
LOPRM_PARAMDESC	_varchar_80	varchar(80)	No	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
LOPRM_SORTBY	_decimal_26_0	decimal(26)	Yes	This field holds the default sort by code	No
LOPRM_CREATEDDATE	_datetime_8	datetime(8)	Yes	This field holds the record created date for auditing purpose.	No

Table Name :	LO_LOSC_SUP_CORR_DETAILS
Comment :	This table holds supplier correspondence details for a LO document subsequent to the authorization of the LO and the document is received by the Supplier

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
LOSC_OUINSTANCE	_decimal_10_0	decimal(10)	No	stores the OUInstance where the loan order is created	Yes
LOSC_LO_NO	_varchar_40	varchar(40)	No	stores the loan order number	Yes
LOSC_LINE_NO	_decimal_10_0	decimal(10)	No	Holds the line no for all correspondence detail	Yes
LOSC_AMEND_NO	_decimal_6_0	decimal(6)	No	stores the amendment number of the Loan order	Yes
LOSC_DATE	_datetime_8	datetime(8)	Yes	stores the date on which the supplier comment or buyer comment is recorded	No
LOSC_SUPP_REMARKS	_varchar_255	varchar(255)	Yes	stores the remarks sent by the supplier	No
LOSC_BUYER_REMARKS	_varchar_255	varchar(255)	Yes	stores the remarks entered by buyer	No
LOSC_CREATEDDATE	_datetime_8	datetime(8)	Yes	stores the created date	No
LOSC_CREATED_BY	_varchar_30	varchar(30)	Yes	stores the user name who created the record	No
LOSC_MODIFIEDDATE	_datetime_8	datetime(8)	Yes	stores the modified date	No
LOSC_MODIFIED_BY	_varchar_30	varchar(30)	Yes	stores the user name who modified the record	No

Table Name :	LO_LOSOPT_SETOPTIONS_INFO
Comment :	This table stores the set options information for Loan Order

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
LOSOPT_LO_OUINSTANCE	_decimal_4_0	decimal(4)	No	stores the OUInstance	Yes
LOSOPT_PRTTYPE_ALLOWED	_varchar_40	varchar(40)	No	This field stores the flag for part types allowed on which a loan order can be raised. There can be 3 values alloed: "C" - "Component ", "O" - "Others" "A"- "All ".	No
LOSOPT_ALLOW_ALTPRT_RCPT	_varchar_5	varchar(5)	Yes	This field holds the flag whether it is allowed to receive an alternate part. The values are: "Y" - "Yes", "N" - "No".	No
LOSOPT_CHARGE_CALC_PRD	_varchar_5	varchar(5)	Yes	This field holds the value applicable as the period for charge calculation. Allowed values are: "SR"- "Supplier Ship To Receipt Date", "PS" - "Part Receipt To Ship Date".	No
LOSOPT_LOAN_CHARGES	_varchar_5	varchar(5)	Yes	This field holds the flag whether Loan charges is enterable or Non enterable. Allowed values are: "E"- "Enterable", "N"- Non Enterable .	No
LOSOPT_CREATED_BY	_varchar_30	varchar(30)	Yes	Holds the username who created the record	No
LOSOPT_CREATED_DATE	_datetime_8	datetime(8)	Yes	Holds the date on which the record is created	No
LOSOPT_MODIFIED_BY	_varchar_30	varchar(30)	Yes	Holds the username who modified the record	No
LOSOPT_MODIFIED_DATE	_datetime_8	datetime(8)	Yes	Holds the date on which the record is modified	No
LOSOPT_TIMESTAMP	_decimal_20_0	decimal(20)	Yes	stores the timestamp. Initial value is 1. Incremented by 1 every time a modification is done	No
LOSOPT_STKCRR_NUM_TYPE	udd_type	varchar(25)	Yes	This field holds the Auto numbering type for Stock correction option	No
LOSOPT_SSC_NUM_TYPE	udd_type	varchar(25)	Yes	This field holds the Auto numbering type for Stock status conversion option	No

Table Name :	LO_LOTMCN_LO_TERMS_CONDNS
Comment :	This table holds the Terms and Condition of Loan order document

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
LOTMCN_LO_OUINSTANCE	_decimal_4_0	decimal(4)	No	stores the OUInstance where the loan order is created	Yes
LOTMCN_LO_NO	_varchar_40	varchar(40)	No	stores the loan order number	Yes
LOTMCN_GTA_REFDOC_NO	_varchar_40	varchar(40)	Yes	This field holds the General Terms Agreement reference documentno	No
LOTMCN_REFDOC_DATE	_datetime_8	datetime(8)	Yes	This field holds the General Terms Agreement reference document Date	No
LOTMCN_GTA_REMARKS	_varchar_255	varchar(255)	Yes	This field holds the General Terms Agreement remarks	No
LOTMCN_ADVANCE_PAYABLE	_varchar_5	varchar(5)	Yes	This field holds the advance payable flag of the purchase order document. List of values (Y)es (N)o	No
LOTMCN_ADVANCE_PERC_ON	_varchar_5	varchar(5)	Yes	This field holds the advance percentage on of the purchase order document. List of values "PBC" - "Part Base Cost", "BLC" - "Basic Loan Charges", "OV" - "Order Value".	No
LOTMCN_ADVANCE_PERC	_decimal_28_8	decimal(28)	Yes	This field holds the advance percentage.	No
LOTMCN_ADVANCE_PAY_AMT	_decimal_28_8	decimal(28)	Yes	This field holds the advance payable amount. If advance payable flag is yes then this is mandatory	No
LOTMCN_ADVANCE_TOL_PERC	_decimal_28_8	decimal(28)	Yes	This field holds the advance tolerence percentage.	No
LOTMCN_ADVANCE_PAYDATE	_datetime_8	datetime(8)	Yes	This field holds the advance payable date. If advance payable flag is yes then this is mandatory	No
LOTMCN_PAY_TO_SUPP	_varchar_45	varchar(45)	Yes	A valid supplier defined in the Supplier component and mapped to the Supplier (who supplies the goods requested )as pay to supplier ( to whom the payment can be made)	No
LOTMCN_PAY_TO_SUPP_OU	_decimal_4_0	decimal(4)	Yes	stores the OUInstance of the supplier defined as the pay to supplier for the base supplier	No
LOTMCN_PAYTERM_CODE	_varchar_25	Varchar(25)	Yes	This field holds the Unique identifier for the Payterm	No
LOTMCN_PAY_PRIORITY	_varchar_5	varchar(5)	Yes	This field holds the payment priority of the PO doument List of values are " H" - "High", "N" - "Normal", "L" - "Low".	No
LOTMCN_PAYMENT_MODE	_varchar_5	varchar(5)	Yes	This field holds varous payment mode. list of values are (Cq)Cheque (Cs)Cash (D)raft (P)ay order	No
LOTMCN_DDCHARGES_BORNEBY	_varchar_5	varchar(5)	Yes	This field holds the DD charges brone by of the purchase order document. List of values "SU" - "Supplier", "SE" - "Self".	No
LOTMCN_TOLERANCE_TYPE	_varchar_5	varchar(5)	Yes	stores the flag for tolerance type Values: "V" - "Value".	No
LOTMCN_TOLERANCE_PERC	_decimal_28_8	decimal(28)	Yes	stores the tolerance percentage	No
LOTMCN_PAY_TO_SUPP_ID	_decimal_6_0	decimal(6)	Yes	This field holds the pay to supplier address ids	No
LOTMCN_REMARKS	_varchar_255	varchar(255)	Yes	This field holds the remarks of the purchase order document s terms and condition.	No
LOTMCN_SHIP_BY	_varchar_25	Varchar(25)	Yes	This field holds the mode of transport of the purchase order document. Mode of transports are 1. AIR 2.LAND	No
LOTMCN_SHIP_PAYMENT	_varchar_25	Varchar(25)	Yes	This field holds the list of shipping payment methods in active status defined in the Logistics common master component.	No
LOTMCN_PKG_CODE	_varchar_25	Varchar(25)	Yes	This field holds the packaging terms of the purchase order document. List of values 1. Bottle 2. Box	No
LOTMCN_INSPECTION_TYPE	_varchar_5	varchar(5)	Yes	stores the flag for inspection type "S" - "Self", "BI" - "By Inspector", "N" - " None".	No
LOTMCN_INCO_TERM	_varchar_150	varchar(150)	Yes	This field holds the INCO term of the purchase order document.	No
LOTMCN_CARRIERAGENCY	_varchar_20	varchar(20)	Yes	This field holds the list of carrier agencies	No
LOTMCN_PORT_OF_DEP	_varchar_32	varchar(32)	Yes	This field holds the port of depature	No
LOTMCN_DELIVERY_POINT	_varchar_32	varchar(32)	Yes	This field holds the delivery point of the purchase order document.	No
LOTMCN_PACKAGING_NOTES	_varchar_2000	varchar(2000)	Yes	This field holds the packaging notes	No
LOTMCN_SHIPPING_NOTES	_varchar_2000	varchar(2000)	Yes	This field holds the shipping notes	No
LOTMCN_INSURANCE_LIABILITY	_varchar_150	varchar(150)	Yes	This field holds insurance liability of the PO document List of values are "SU" - "Supplier", "SE" - "Self", "O" - "Others".	No
LOTMCN_INSURANCE_AMT	_decimal_28_8	decimal(28)	Yes	This field holds the insurence amount of the purchase order document.	No
LOTMCN_INSURANCE_TERMS	_varchar_150	varchar(150)	Yes	This field holds the insurence term of purchase order document.	No
LOTMCN_LO_DETAIL2	_varchar_30	varchar(30)	Yes	stores the used defined details	No
LOTMCN_LO_DETAIL3	_varchar_30	varchar(30)	Yes	stores the used defined detail 3	No
LOTMCN_LO_DETAIL4	_varchar_30	varchar(30)	Yes	stores the used defined detail 4	No
LOTMCN_LO_OPTION2	_varchar_30	varchar(30)	Yes	stores the used defined option	No
LOTMCN_LO_OPTION3	_varchar_30	varchar(30)	Yes	stores the used defined option 3	No
LOTMCN_LO_OPTION4	_varchar_30	varchar(30)	Yes	stores the used defined option 4	No
LOTMCN_RMANO	udd_documentno	varchar(40)	Yes	Column to store RMA no.	No
LOTMCN_RMADATE	udd_time	datetime(8)	Yes	Column to stoer RMA date	No
LOTMCN_RET_SUPP_ID	udd_vendorcode	varchar(45)	Yes	Coumn to store Supplier ID	No