Data Dictionary - Loan order |
|
| |||||
|
|
|||||||
|
Table Name LO_LOadtcd_LO_doc_tcd |
|
||||||
|
|
|||||||
|
Table Comment This table holds the Document TCD details of an amended Loan order. |
|
||||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
|
|
LOadtcd_tcd_rate |
decimal(28,8) |
NULL |
TCD rate for the TCD code and the variant . this should not be changed for TCD basis -- Percentage. |
No |
No |
|
|
|
LOadtcd_tcd_amount |
decimal(28,8) |
NULL |
The Tcd amount that will be calculated from the TCD component for the TCD code and the variant and the TCD rate supplied |
No |
No |
|
|
|
LOadtcd_tcd_ou |
numeric(4) |
NULL |
stores the TCD OUInstance |
No |
No |
|
|
|
LOadtcd_user_seq |
numeric(6) |
NULL |
holds the sequence number as entered by the user for the TCD |
No |
No |
|
|
|
LOadtcd_pay_to_supp_ou |
numeric(4) |
NULL |
Stores the pay to supplier OUInstance |
No |
No |
|
|
|
LOadtcd_pay_currency |
varchar(20) |
NULL |
This field holds the Transaction currency |
No |
No |
|
|
|
LOadtcd_pay_to_supp |
varchar(45) |
NULL |
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 |
No |
|
|
|
LOadtcd_Exchg_Rate |
numeric(28,8) |
NULL |
Holds the exchange rate between the document currency and the payment currency |
No |
No |
|
|
|
LOadtcd_LO_No |
varchar(40) |
NOT NULL |
stores the loan order number |
Yes |
Yes |
|
|
|
LOadtcd_Tcd_Mode |
varchar(5) |
NOT NULL |
stores the mode for which the TCDs are captured. RP - Rental Price AC - Administrative Charges LC - Lease Charges RC - Rental Charges |
Yes |
No |
|
|
|
LOadtcd_LO_OUInstance |
numeric(4) |
NOT NULL |
stores the OUInstance where the loan order is created |
Yes |
Yes |
|
|
|
LOadtcd_tcd_variant |
varchar(25) |
NOT NULL |
This field holds the TCD variant for the TCD code. |
No |
No |
|
|
|
LOadtcd_tcd_code |
varchar(25) |
NOT NULL |
This field holds the Unique identifier for the TCD |
No |
No |
|
|
|
LOadtcd_Line_no |
numeric(6) |
NOT NULL |
This field holds the Unique identifier number for the TCD |
Yes |
No |
|
|
|
LOadtcd_Amend_No |
numeric(6) |
NOT NULL |
stores the amendment no of loan order |
Yes |
Yes |
|
|
|
LOATCD_COST_DIFF |
numeric(28,8) |
NULL |
Column to store cost diff. between the last amendment no and current amendment no |
No |
No |
|
|
|
|
|||||||
|
Table Name LO_LOAHdr_Loan_Order_Hdr |
|
||||||
|
|
|||||||
|
Table Comment This table holds the information of the amended loan order |
|
||||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
|
|
LOAHdr_LO_Option1 |
varchar(30) |
NULL |
stores the user defined option 1 |
No |
No |
|
|
|
LOAHdr_Hdr_Comments |
varchar(255) |
NULL |
stores the comments for the loan order |
No |
No |
|
|
|
LOAHdr_LO_Detail1 |
varchar(30) |
NULL |
stores the user defined detail 1 |
No |
No |
|
|
|
LOAHdr_Employee_Name |
varchar(77) |
NULL |
stores the employee name |
No |
No |
|
|
|
LOAHdr_EmployeeNo |
varchar(20) |
NULL |
stores the employee number |
No |
No |
|
|
|
LOAHdr_BLC_Tcd_Amt |
numeric(28,8) |
NULL |
stores the TCD amount calculated based on Basic Loan Charges |
No |
No |
|
|
|
LOAHdr_Doc_Filename |
varchar(50) |
NULL |
stores the document file name attached to the loan order |
No |
No |
|
|
|
LOAHdr_AC_Tcd_Amt |
numeric(28,8) |
NULL |
stores the TCD amount calculated based on Administrative Charges |
No |
No |
|
|
|
LOAHdr_TCD_Comments |
varchar(255) |
NULL |
stores the TCD comments for the loan order |
No |
No |
|
|
|
LOAHdr_TLC_Tcd_Amt |
numeric(28,8) |
NULL |
stores the TCD amount calculated based on Total Loan Charges |
No |
No |
|
|
|
LOAHdr_PBLC_Basis |
varchar(5) |
NULL |
stores the parameter based charges basis for the loan order. Allowed values are: C - Cumulative P - Period |
No |
No |
|
|
|
LOAHdr_Part_BaseCost |
numeric(28,8) |
NULL |
stores the base cost of the loaned part |
No |
No |
|
|
|
LOAHdr_CBLC_Basis |
varchar(5) |
NULL |
stores the calendar based charges basis for the loan order. Allowed values are: C - Cumulative P - Period |
No |
No |
|
|
|
LOAHdr_PBLC_Policy |
varchar(5) |
NULL |
stores the parameter based charges policy for the loan order. Allowed values are: F - Flat P - Percent |
No |
No |
|
|
|
LOAHdr_Base_Curr_Val |
numeric(28,8) |
NULL |
stores the loan order value in base currency |
No |
No |
|
|
|
LOAHdr_Addnl_Charges |
numeric(28,8) |
NULL |
stores the administrative charges. It is the total sum of the TCD amounts |
No |
No |
|
|
|
LOAHdr_Admin_Chrgs_In_Perc |
numeric(28,8) |
NULL |
stores the percent value for the administrative charges to be applied on part base cost |
No |
No |
|
|
|
LOAHdr_Basic_Loan_Charges |
numeric(28,8) |
NULL |
stores the basic loan charges which is the combination of calendar based and parameter based lease charges captured in the multiline |
No |
No |
|
|
|
LOAHdr_Admin_Charges |
numeric(28,8) |
NULL |
stores the user entered administrative charges. This will be considered only if percent value is not specified in the administrative charges percent field |
No |
No |
|
|
|
LOAHdr_CBLC_Policy |
varchar(5) |
NULL |
stores the calendar based lease charges policy for the loan order. Allowed values are: F - Flat P - Percent |
No |
No |
|
|
|
LOAHDR_TIMESTAMP |
numeric(20) |
NULL |
stores the timestamp. Initial value is 1. Incremented by 1 every time a modification is done |
No |
No |
|
|
|
LOAHdr_Iss_Loc |
numeric(4) |
NULL |
Stores the location from where the issue can happen for returning the loaned part |
No |
No |
|
|
|
LOAHdr_Stage |
varchar(10) |
NULL |
stores the stage of the loan order. This is an intermediate state fetched from work flow while the document goes through different stages of authorization |
No |
No |
|
|
|
LOAHdr_Wf_Doc_Key |
varchar(128) |
NULL |
stores the doc key of a loan order for work flow purpose |
No |
No |
|
|
|
LOAHdr_Num_Type_Num |
varchar(5) |
NULL |
stores the numbering type number for a loan order |
No |
No |
|
|
|
LOAHDR_PURCHASE_COST |
numeric(28,8) |
NULL |
This field captures the Loan Order purchase cost |
No |
No |
|
|
|
LOAHdr_Iss_WH |
varchar(10) |
NULL |
Stores the warehouse from where the issue can happen for returning the loaned part |
No |
No |
|
|
|
LOAHDR_LORDER_TYPE |
char(5) |
NULL |
This field captures the Loan order type |
No |
No |
|
|
|
LOAHdr_Pending_Iss_Qty |
numeric(28,8) |
NULL |
Stores the pending quantity of rental order to be issued |
No |
No |
|
|
|
LOAHdr_PBC_Tcd_Amt |
numeric(28,8) |
NULL |
stores the TCD amount calculated based on Part base cost |
No |
No |
|
|
|
LOAHdr_Created_Date |
datetime |
NULL |
stores the loan order created date |
No |
No |
|
|
|
LOAHdr_Modified_By |
varchar(30) |
NULL |
stores the user who modified the loan order |
No |
No |
|
|
|
LOAHdr_Created_By |
varchar(30) |
NULL |
stores the user who created the loan order |
No |
No |
|
|
|
LOAHdr_Total_Loan_Charges |
numeric(28,8) |
NULL |
stores the total loan charges which is the sum of administrative and basic loan charges |
No |
No |
|
|
|
LOAHdr_Comments |
varchar(255) |
NULL |
stores the comments for cancellation |
No |
No |
|
|
|
LOAHdr_Amendment_Date |
datetime |
NULL |
stores the loan order amendment date |
No |
No |
|
|
|
LOAHdr_Amendment_By |
varchar(30) |
NULL |
stores the user who amended the loan order |
No |
No |
|
|
|
LOAHdr_Modified_Date |
datetime |
NULL |
stores the loan order modified date |
No |
No |
|
|
|
LOAHdr_Authorised_By |
varchar(30) |
NULL |
stores the user who authorized the loan order |
No |
No |
|
|
|
LOAHdr_Authorised_Date |
datetime |
NULL |
stores the loan order authorization date |
No |
No |
|
|
|
LOAHDR_INTSTK_STATUS |
char(18) |
NULL |
This field captures the internal stock status of the Loan Order |
No |
No |
|
|
|
LOAHdr_Base_Currency |
varchar(20) |
NULL |
stores the base currency |
No |
No |
|
|
|
LOAHdr_User_Status |
varchar(25) |
NULL |
stores the user defined status |
No |
No |
|
|
|
LOAHdr_Exchange_Rate |
numeric(28,8) |
NULL |
stores the exchange rate between the document currency and base currency |
No |
No |
|
|
|
LOAHdr_LO_Currency |
varchar(20) |
NULL |
stores the document/order currency |
No |
No |
|
|
|
LOAHdr_Supp_OU |
numeric(4) |
NULL |
stores the supplier OUinstance |
No |
No |
|
|
|
LOAHdr_LO_Reason |
varchar(2000) |
NULL |
stores the reason |
No |
No |
|
|
|
LOAHdr_LO_Cat |
varchar(25) |
NULL |
stores the loan order category defined in logistics common master |
No |
No |
|
|
|
LOAHdr_AC_RegNo |
varchar(30) |
NULL |
This field holds the aircraft registration number. |
No |
No |
|
|
|
LOAHdr_LO_Priority |
varchar(20) |
NULL |
stores the loan order priority |
No |
No |
|
|
|
LOAHdr_Contact_Person |
varchar(80) |
NULL |
stores the contact person name for the supplier |
No |
No |
|
|
|
LOAHdr_Amend_No |
numeric(6) |
NOT NULL |
stores the loan order amendment number. |
Yes |
No |
|
|
|
LOAHdr_LO_Date |
datetime |
NOT NULL |
stores the document date |
No |
No |
|
|
|
LOAHdr_LO_No |
varchar(40) |
NOT NULL |
stores the loan order number |
Yes |
Yes |
|
|
|
LOAHdr_LO_OUInstance |
numeric(4) |
NOT NULL |
stores the OUInstance where the loan order is created |
Yes |
Yes |
|
|
|
LOAHdr_Supp_Created_OU |
numeric(4) |
NULL |
stores the OUInstance where the supplier is created |
No |
No |
|
|
|
LOAHdr_Part_OUInstance |
numeric(4) |
NULL |
stores the part OUinstance |
No |
No |
|
|
|
LOAHdr_Supp_Code |
varchar(45) |
NOT NULL |
stores the supplier code |
No |
No |
|
|
|
LOAHdr_LO_Status |
varchar(5) |
NOT NULL |
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", "RVD" - "Received", "UAM" - "Under Amendment". |
No |
No |
|
|
|
LOAHdr_Prt_Srl_No |
varchar(40) |
NULL |
stores the part serial no |
No |
No |
|
|
|
LOAHdr_Part_No |
varchar(40) |
NOT NULL |
stores the part no on which the loan order is raised |
No |
No |
|
|
|
LOAHdr_Admin_Chrgs_Policy |
varchar(5) |
NULL |
stores the administrative charges policy for the loan order. Allowed values are: F - Flat P - Percent |
No |
No |
|
|
|
LOAHdr_Date_Reqd |
datetime |
NULL |
stores the date from when the loan begins |
No |
No |
|
|
|
LOAHdr_Loan_Period_Value |
numeric(28) |
NULL |
stores the value of the loan period |
No |
No |
|
|
|
LOAHdr_TCD_Applicable |
varchar(5) |
NULL |
stores the flag whether TCD applicable or not. Values are: Y - Yes N - No |
No |
No |
|
|
|
LOAHdr_Penalty_Applicable |
varchar(5) |
NULL |
stores the flag whether penalty applicable or not. Values are: Y - Yes N - No |
No |
No |
|
|
|
LOAHdr_Loan_Chrgs_On |
varchar(5) |
NULL |
stores the flag for Loan Charges On. List of values are: CB - Calendar Based PB - Parameter Based BH - Both NE - None |
No |
No |
|
|
|
LOAHdr_Expected_Usage |
numeric(28) |
NULL |
stores the expected usage of the lead parameter |
No |
No |
|
|
|
LOAHdr_Loan_Period_Units |
varchar(5) |
NULL |
stores the UOM of the loan period. Allowed values are: D - Days W - Weeks M - Months |
No |
No |
|
|
|
LOAHdr_Lead_Param_Uom |
varchar(10) |
NULL |
stores the UOM of the lead parameter |
No |
No |
|
|
|
LOAHdr_Lead_Param |
varchar(40) |
NULL |
stores the lead parameter of the loan order part number |
No |
No |
|
|
|
LOAHdr_Supp_Addr_Id |
numeric(6) |
NULL |
stores the supplier’s address id |
No |
No |
|
|
|
LOAHdr_Part_Condn |
varchar(5) |
NULL |
stores the condition of the loaned part |
No |
No |
|
|
|
LOAHdr_Cert_Type |
varchar(25) |
NULL |
stores the certification type defined in logistics common master |
No |
No |
|
|
|
LOAHdr_Recvd_Qty |
numeric(28,8) |
NULL |
stores the received quantity of the loaned part |
No |
No |
|
|
|
LOAHdr_Quantity |
numeric(28,8) |
NULL |
stores the quantity of the loaned part |
No |
No |
|
|
|
LOAHdr_Ref_Doc_No |
varchar(40) |
NULL |
stores the user entered reference document number |
No |
No |
|
|
|
LOAHdr_Supp_OfferNo |
varchar(40) |
NULL |
stores the supplier offer number |
No |
No |
|
|
|
LOAHdr_Ref_Doc |
varchar(25) |
NULL |
stores the user entered reference document |
No |
No |
|
|
|
LOAHdr_Ship_To |
numeric(4) |
NULL |
stores the ship to location |
No |
No |
|
|
|
LOAHdr_Loan_Agmt_No |
varchar(40) |
NULL |
stores the loan agreement number |
No |
No |
|
|
|
LOAHdr_WH_No |
varchar(10) |
NULL |
stores the warehouse number |
No |
No |
|
|
|
loahdr_below_threshold |
varchar(40) |
NULL |
stores the threshold value |
No |
No |
|
|
|
LOAHDR_VALUE_DIFF |
numeric(28,8) |
NULL |
Column to store value diff between the previous amendment No and current Amendment No |
No |
No |
|
|
|
LOAHDR_ACTUAL_LOAN_CHARGES |
numeric(28,8) |
NULL |
Column to capture the actual loan order charges computed based on the actual usage period. |
No |
No |
|
|
|
|
|||||||
|
Table Name LO_Loalc_Lease_Charges |
|
||||||
|
|
|||||||
|
Table Comment This Table holds the calendar based and parameter based lease charges for an amended loan order document |
|||||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
|
|
Loalc_To_ParamVal |
numeric(28,8) |
NULL |
stores the to value of a parameter value |
No |
No |
|
|
|
Loalc_From_ParamVal |
numeric(28,8) |
NULL |
stores the from value of a parameter value |
No |
No |
|
|
|
Loalc_To_Cal_Period |
numeric(28,8) |
NULL |
stores the to value of a period |
No |
No |
|
|
|
Loalc_Charge_For_Period |
numeric(28,8) |
NULL |
If the charges policy 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 |
No |
|
|
|
Loalc_Rate_Per_UOM |
numeric(28,8) |
NULL |
stores the flat rate per UOM of calendar period or the flat rate per UOM of parameter |
No |
No |
|
|
|
Loalc_Charge_Per_Unit |
numeric(28,8) |
NULL |
stores the charge per unit. If the charges policy 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 value/100 |
No |
No |
|
|
|
Loalc_Remarks |
varchar(255) |
NULL |
stores the remarks |
No |
No |
|
|
|
Loalc_LO_No |
varchar(40) |
NOT NULL |
stores the loan order number |
Yes |
Yes |
|
|
|
Loalc_LO_OUInstance |
numeric(4) |
NOT NULL |
stores the OUInstance where the loan order is created |
Yes |
Yes |
|
|
|
Loalc_From_Cal_Period |
numeric(28,8) |
NULL |
stores the from value of a period |
No |
No |
|
|
|
Loalc_Line_Id |
numeric(6) |
NOT NULL |
stores the line id which is a generated serial number |
Yes |
No |
|
|
|
Loalc_Amend_No |
numeric(6) |
NOT NULL |
stores the amendment number |
Yes |
Yes |
|
|
|
Loalc_MltLine_Flag |
varchar(5) |
NOT NULL |
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 |
No |
|
|
|
|
|||||||
|
Table Name LO_Loapcd_Penalty_Charges |
|
||||||
|
|
|||||||
|
Table Comment This table stores the penalty charges of an amended Loan Order |
|
||||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
|
|
Loapcd_To_ParamVal |
numeric(28,8) |
NULL |
stores the to value of a parameter value |
No |
No |
|
|
|
Loapcd_From_ParamVal |
numeric(28,8) |
NULL |
stores the from value of a parameter value |
No |
No |
|
|
|
Loapcd_To_Cal_Period |
numeric(28,8) |
NULL |
This field holds the To value of a period |
No |
No |
|
|
|
Loapcd_Charge_For_Period |
numeric(28,8) |
NULL |
stores the penalty charge per period If the charges policy 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 |
No |
|
|
|
Loapcd_Rate_Per_UOM |
numeric(28,8) |
NULL |
stores the flat rate per UOM of calendar period or the flat rate per UOM of parameter |
No |
No |
|
|
|
Loapcd_Charge_Per_Unit |
numeric(28,8) |
NULL |
stores the penalty charge per unit. If the charges policy 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 value/100 |
No |
No |
|
|
|
Loapcd_Remarks |
varchar(255) |
NULL |
stores the remarks |
No |
No |
|
|
|
Loapcd_LO_No |
varchar(40) |
NOT NULL |
stores the loan order number |
Yes |
Yes |
|
|
|
Loapcd_LO_OUInstance |
numeric(4) |
NOT NULL |
stores the OUInstance where the loan order is created |
Yes |
Yes |
|
|
|
Loapcd_From_Cal_Period |
numeric(28,8) |
NULL |
stores the from value of a period |
No |
No |
|
|
|
Loapcd_Line_Id |
numeric(6) |
NOT NULL |
stores the line id which is a generated serial number |
Yes |
No |
|
|
|
Loapcd_Amend_No |
numeric(6) |
NOT NULL |
stores the amendment number of the loan order |
Yes |
Yes |
|
|
|
Loapcd_MltLine_Flag |
varchar(5) |
NOT NULL |
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 |
No |
|
|
|
|
|||||||
|
Table Name LO_Loapch_Penalty_Chrgs_Hdr |
|
||||||
|
|
|||||||
|
Table Comment This table stores the penalty charges header details for an amended Loan Order |
|
||||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
|
|
Loapch_CBPC_Policy |
varchar(5) |
NULL |
This field holds the calendar based lease charges policy for the loan order. Allowed values are: F - Flat P - Percent |
No |
No |
|
|
|
Loapch_Comments |
varchar(255) |
NULL |
This field holds the comments |
No |
No |
|
|
|
Loapch_CBPC_Basis |
varchar(5) |
NULL |
This field holds the calendar based charges policy for the loan order. Allowed values are: C - Cumulative P - Period |
No |
No |
|
|
|
Loapch_PBPC_Policy |
varchar(5) |
NULL |
This field holds the parameter based charges policy for the loan order. Allowed values are: F - Flat P - Percent |
No |
No |
|
|
|
Loapch_PBPC_Basis |
varchar(5) |
NULL |
This field holds the parameter based charges policy for the loan order. Allowed values are: C - Cumulative P - Period |
No |
No |
|
|
|
Loapch_LO_OUInstance |
numeric(4) |
NOT NULL |
This field holds the OUInstance where the loan order is created |
Yes |
Yes |
|
|
|
Loapch_Fix_Penalty_Chrgs |
numeric(28,8) |
NULL |
This field holds the fix penalty charges for the loan order |
No |
No |
|
|
|
Loapch_LO_No |
varchar(40) |
NOT NULL |
This field holds the loan order number |
Yes |
Yes |
|
|
|
Loapch_Amend_No |
numeric(6) |
NOT NULL |
This field holds the amendment number for the loan order |
Yes |
Yes |
|
|
|
|
|||||||
|
Table Name LO_LOASopt_SetOptions_Info |
|
||||||
|
|
|||||||
|
Table Comment This table stores the set options information change history for Loan Order |
|
||||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
|
|
LOASopt_LO_OUInstance |
numeric(4) |
NOT NULL |
stores the OUInstance |
Yes |
No |
|
|
|
LOASopt_Set_Opt_Id |
numeric(6) |
NOT NULL |
stores the option id which is running serial number |
Yes |
No |
|
|
|
LOASopt_PrtType_Allowed |
varchar(40) |
NOT NULL |
This field stores the flag for part types allowed on which a loan order can be raised. There can be 3 values allowed: 1. Component - C 2. Others - O 3. All - A |
No |
No |
|
|
|
LOASopt_Allow_AltPrt_Rcpt |
varchar(5) |
NULL |
This field holds the flag whether it is allowed to receive an alternate part. The values are: Y - Yes N - No |
No |
No |
|
|
|
LOASopt_Charge_Calc_Prd |
varchar(5) |
NULL |
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 |
No |
|
|
|
LOASopt_Loan_Charges |
varchar(5) |
NULL |
This field holds the flag whether Loan charges is enterable or Non enterable. Allowed values are: "E" - "Enterable", "N" - "Non Enterable" |
No |
No |
|
|
|
LOASopt_Created_By |
varchar(30) |
NULL |
Holds the username who created the record |
No |
No |
|
|
|
LOASopt_Created_Date |
datetime |
NULL |
Holds the date on which the record is created |
No |
No |
|
|
|
LOASopt_Modified_By |
varchar(30) |
NULL |
Holds the username who modified the record |
No |
No |
|
|
|
LOASopt_Modified_Date |
datetime |
NULL |
Holds the date on which the record is modified |
No |
No |
|
|
|
|
|||||||
|
Table Name LO_LOatmcn_LO_Terms_Condns |
|
||||||
|
|
|||||||
|
Table Comment This table holds the Terms and Condition of an amended Loan order document |
|
||||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
|
|
LOatmcn_inco_term |
varchar(150) |
NULL |
This field holds the INCO term of the purchase order document. |
No |
No |
|
|
|
LOatmcn_Inspection_Type |
varchar(5) |
NULL |
stores the flag for inspection type "S" - "Self", "BI" - "By Inspector", "N" - " None". |
No |
No |
|
|
|
LOatmcn_carrieragency |
varchar(20) |
NULL |
This field holds the list of carrier agencies |
No |
No |
|
|
|
LOatmcn_port_of_dep |
varchar(32) |
NULL |
This field holds the port of departure |
No |
No |
|
|
|
LOatmcn_delivery_point |
varchar(32) |
NULL |
This field holds the delivery point of the purchase order document. |
No |
No |
|
|
|
LOatmcn_remarks |
varchar(255) |
NULL |
This field holds the remarks of the purchase order documents terms and condition. |
No |
No |
|
|
|
LOatmcn_pkg_code |
varchar(25) |
NULL |
This field holds the packaging terms of the purchase order document. List of values 1. Bottle 2. Box |
No |
No |
|
|
|
LOatmcn_ship_by |
varchar(25) |
NULL |
This field holds the mode of transport of the purchase order document. Mode of transports are 1. AIR 2.LAND |
No |
No |
|
|
|
LOatmcn_ship_payment |
varchar(25) |
NULL |
This field holds the list of shipping payment methods in active status defined in the Logistics common master component. |
No |
No |
|
|
|
LOatmcn_pay_to_supp_id |
numeric(6) |
NULL |
This field holds the pay to supplier address ids |
No |
No |
|
|
|
LOatmcn_LO_Detail4 |
varchar(20) |
NULL |
stores the used defined detail |
No |
No |
|
|
|
LOatmcn_LO_Detail3 |
varchar(20) |
NULL |
stores the used defined detail |
No |
No |
|
|
|
LOatmcn_LO_Option2 |
varchar(20) |
NULL |
stores the used defined option |
No |
No |
|
|
|
LOatmcn_LO_Option3 |
varchar(20) |
NULL |
stores the used defined option |
No |
No |
|
|
|
LOatmcn_packaging_notes |
varchar(2000) |
NULL |
This field holds the packaging notes |
No |
No |
|
|
|
LOatmcn_insurance_liability |
varchar(150) |
NULL |
This field holds insurance liability of the PO document List of values are "SU" - "Supplier", "SE" - "Self", "O" - "Others". |
No |
No |
|
|
|
LOatmcn_shipping_notes |
varchar(2000) |
NULL |
This field holds the shipping notes |
No |
No |
|
|
|
LOatmcn_LO_Detail2 |
varchar(20) |
NULL |
stores the used defined detail |
No |
No |
|
|
|
LOatmcn_insurance_amt |
decimal(28,8) |
NULL |
This field holds the insurance amount of the purchase order document. |
No |
No |
|
|
|
LOatmcn_insurance_terms |
varchar(150) |
NULL |
This field holds the insurance term of purchase order document. |
No |
No |
|
|
|
LOatmcn_LO_Option4 |
varchar(20) |
NULL |
stores the used defined option |
No |
No |
|
|
|
LOatmcn_gta_remarks |
varchar(255) |
NULL |
This field holds the General Terms Agreement remarks |
No |
No |
|
|
|
LOatmcn_refdoc_date |
datetime |
NULL |
This field holds the General Terms Agreement reference document Date |
No |
No |
|
|
|
LOatmcn_advance_payable |
varchar(5) |
NULL |
This field holds the advance payable flag of the purchase order document. List of values "Y" - "Yes", "N" - "No". |
No |
No |
|
|
|
LOatmcn_advance_perc_on |
varchar(5) |
NULL |
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 |
No |
|
|
|
LOatmcn_advance_perc |
numeric(28) |
NULL |
This field holds the advance percentage. |
No |
No |
|
|
|
LOatmcn_LO_OUInstance |
numeric(4) |
NOT NULL |
stores the OUInstance where the loan order is created |
Yes |
Yes |
|
|
|
LOatmcn_gta_refdoc_no |
varchar(40) |
NULL |
This field holds the General Terms Agreement reference document no. |
No |
No |
|
|
|
LOatmcn_LO_No |
varchar(40) |
NOT NULL |
stores the loan order number |
Yes |
Yes |
|
|
|
LOatmcn_Amend_No |
numeric(6) |
NOT NULL |
stores the amendment no of the loan order |
Yes |
Yes |
|
|
|
LOatmcn_Tolerance_Perc |
numeric(28,8) |
NULL |
stores the tolerance percentage |
No |
No |
|
|
|
LOatmcn_payment_mode |
varchar(5) |
NULL |
This field holds various payment mode. list of values are (Cq)Cheque (Cs)Cash (D)raft (P)ay order |
No |
No |
|
|
|
LOatmcn_pay_priority |
varchar(5) |
NULL |
This field holds the payment priority of the PO document List of values are "’H" - "High", "N" - "Normal", "L" - "Low". |
No |
No |
|
|
|
LOatmcn_ddcharges_borneby |
varchar(5) |
NULL |
This field holds the DD charges borne by of the purchase order document. List of values "SU" - "Supplier", "SE" - "Self". |
No |
No |
|
|
|
LOatmcn_Tolerance_Type |
varchar(5) |
NULL |
stores the flag for tolerance type Values: "V" - "Value". |
No |
No |
|
|
|
LOatmcn_advance_pay_amt |
numeric(28) |
NULL |
This field holds the advance payable amount. If advance payable flag is ’yes’ then this is mandatory |
No |
No |
|
|
|
LOatmcn_advance_paydate |
datetime |
NULL |
This field holds the advance payable date. If advance payable flag is ’yes’ then this is mandatory |
No |
No |
|
|
|
LOatmcn_advance_tol_perc |
numeric(28) |
NULL |
This field holds the advance tolerance percentage. |
No |
No |
|
|
|
LOatmcn_payterm_code |
varchar(25) |
NULL |
This field holds the Unique identifier for the Payterm |
No |
No |
|
|
|
LOatmcn_pay_to_supp |
varchar(45) |
NULL |
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 |
No |
|
|
|
LOatmcn_pay_to_supp_ou |
numeric(4) |
NULL |
stores the OUInstance of the supplier defined as the pay to supplier for the base supplier |
No |
No |
|
|
|
LOATMCN_RMANO |
varchar(40) |
NULL |
Column to store RMA No |
No |
No |
|
|
|
LOATMCN_RMADATE |
datetime |
NULL |
Column to store RMA Date |
No |
No |
|
|
|
LOATMCN_RET_SUPP_ID |
varchar(45) |
NULL |
Column to Store Supplier ID |
No |
No |
|
|
|
|
|||||||
|
Table Name LO_LOCD_LoanOrder_Close_Det |
|
||||||
|
|
|||||||
|
Table Comment This table stores the shipping and closing details of Loan order document |
|
||||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
|
|
LOCD_Fix_Penalty_Chrgs |
numeric(28,8) |
NULL |
stores the fixed penalty charges |
No |
No |
|
|
|
LOCD_CBased_Penalty_Chrgs |
numeric(28,8) |
NULL |
stores the calendar based penalty charges |
No |
No |
|
|
|
LOCD_Param_Based_Chrgs |
numeric(28,8) |
NULL |
stores the parameter based lease charges |
No |
No |
|
|
|
LOCD_CAL_BASED_CHRGE |
numeric(28,8) |
NULL |
stores the calendar based lease charges |
No |
No |
|
|
|
LOCD_USDEF_Dtl6 |
varchar(40) |
NULL |
Stores the user defined detail 6 defined as part of acknowledgement information |
No |
No |
|
|
|
LOCD_PBased_Penalty_Chrgs |
numeric(28,8) |
NULL |
stores the parameter based penalty charges |
No |
No |
|
|
|
LOCD_USDEF_Dtl5 |
varchar(40) |
NULL |
Stores the user defined detail 5 defined as part of acknowledgement information |
No |
No |
|
|
|
LOCD_Act_Order_Value |
numeric(28,8) |
NULL |
stores the actual order value |
No |
No |
|
|
|
LOCD_USDEF_Dtl7 |
varchar(40) |
NULL |
Stores the user defined detail 7 defined as part of acknowledgement information |
No |
No |
|
|
|
LOCD_LO_No |
varchar(40) |
NOT NULL |
stores the loan order number |
Yes |
Yes |
|
|
|
LOCD_Ackldge_Ref_No |
varchar(40) |
NULL |
stores the acknowledgement number |
No |
No |
|
|
|
LOCD_LO_OUInstance |
numeric(4) |
NOT NULL |
stores the OUInstance where the loan order is created |
Yes |
Yes |
|
|
|
LOCD_Act_Usage |
numeric(28) |
NULL |
stores the actual usage of the lead param value |
No |
No |
|
|
|
LOCD_Act_Loan_Period |
numeric(28) |
NULL |
stores the actual loan period |
No |
No |
|
|
|
LOCD_Ackldge_Date |
datetime |
NULL |
stores acknowledgement date |
No |
No |
|
|
|
LOCD_Comments |
varchar(255) |
NULL |
stores the acknowledgement comments |
No |
No |
|
|
|
LOCD_Rcpt_Satisfactory |
varchar(5) |
NULL |
stores the flag to identify whether receipt of the part at the supplier site is satisfactory or not "Y"- "Yes", "N" - "No". |
No |
No |
|
|
|
|
|||||||
|
Table Name LO_LOdtcd_LO_doc_tcd |
|
||||||
|
|
|||||||
|
Table Comment This table holds the Document TCD details of Loan order. |
|
||||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
|
|
LOdtcd_tcd_amount |
decimal(28,8) |
NULL |
The Tcd amount that will be calculated from the TCD component for the TCD code and the variant and the TCD rate supplied |
No |
No |
|
|
|
LOdtcd_tcd_rate |
decimal(28,8) |
NULL |
TCD rate for the TCD code and the variant . this should not be changed for TCD basis -- Percentage. |
No |
No |
|
|
|
LOdtcd_tcd_ou |
numeric(4) |
NULL |
stores the TCD OUInstance |
No |
No |
|
|
|
LOdtcd_pay_to_supp_ou |
numeric(4) |
NULL |
Stores the pay to supplier OUInstance |
No |
No |
|
|
|
LOdtcd_pay_currency |
varchar(20) |
NULL |
This field holds the Transaction currency |
No |
No |
|
|
|
LOdtcd_pay_to_supp |
varchar(45) |
NULL |
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 |
No |
|
|
|
LOdtcd_Exchg_Rate |
numeric(28,8) |
NULL |
Holds the exchange rate between the document currency and the payment currency |
No |
No |
|
|
|
LOdtcd_LO_No |
varchar(40) |
NOT NULL |
stores the loan order number |
Yes |
Yes |
|
|
|
LOdtcd_Tcd_Mode |
varchar(5) |
NOT NULL |
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 |
No |
|
|
|
LOdtcd_LO_OUInstance |
numeric(4) |
NOT NULL |
stores the OUInstance where the loan order is created |
Yes |
Yes |
|
|
|
LOdtcd_user_seq |
numeric(6) |
NULL |
holds the sequence number as entered by the user for the TCD |
No |
No |
|
|
|
LOdtcd_tcd_variant |
varchar(25) |
NOT NULL |
This field holds the TCD variant for the TCD code. |
No |
No |
|
|
|
LOdtcd_Line_no |
numeric(6) |
NOT NULL |
This field holds the Unique identifier number for the TCD of the loan order |
Yes |
No |
|
|
|
LOdtcd_tcd_code |
varchar(25) |
NOT NULL |
This field holds the Unique identifier for the TCD |
No |
No |
|
|
|
LOTCD_COST_DIFF |
numeric(28,8) |
NULL |
Column to capture the cost diff between the previous amendment and current amendment |
No |
No |
|
|
|
|
|||||||
|
Table Name LO_LOHdr_Loan_Order_Hdr |
|
||||||
|
|
|||||||
|
Table Comment This table holds the Loan order information |
|
||||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
|
|
LOHdr_LO_OUInstance |
numeric(4) |
NOT NULL |
stores the OUInstance where the loan order is created |
Yes |
No |
|
|
|
LOHdr_LO_No |
varchar(40) |
NOT NULL |
stores the loan order number |
Yes |
No |
|
|
|
LOHdr_Amend_No |
numeric(6) |
NOT NULL |
stores the loan order amendment number. if the LO is not amended then 0 is stored |
No |
No |
|
|
|
LOHdr_LO_Date |
datetime |
NOT NULL |
stores the document date |
No |
No |
|
|
|
LOHdr_LO_Status |
varchar(5) |
NOT NULL |
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", "RVD" - "Received", "UAM" - "Under Amendment". |
No |
No |
|
|
|
LOHdr_Part_No |
varchar(40) |
NOT NULL |
stores the part no on which the loan order is raised |
No |
No |
|
|
|
LOHdr_Prt_Srl_No |
|
NULL |
stores the part serial no |
No |
No |
|
|
|
LOHdr_Part_OUInstance |
numeric(4) |
NULL |
stores the part OUinstance |
No |
No |
|
|
|
LOHdr_Supp_Code |
varchar(45) |
NOT NULL |
stores the supplier code |
No |
No |
|
|
|
LOHdr_Supp_Created_OU |
numeric(4) |
NULL |
stores the OUInstance where the supplier is created |
No |
No |
|
|
|
LOHdr_Supp_OU |
numeric(4) |
NULL |
stores the supplier OUinstance |
No |
No |
|
|
|
LOHdr_LO_Currency |
varchar(20) |
NULL |
stores the document/order currency |
No |
No |
|
|
|
LOHdr_Exchange_Rate |
numeric(28,8) |
NULL |
stores the exchange rate between the document currency and base currency |
No |
No |
|
|
|
LOHdr_Base_Currency |
varchar(20) |
NULL |
stores the base currency |
No |
No |
|
|
|
LOHdr_User_Status |
varchar(25) |
NULL |
stores the user defined status |
No |
No |
|
|
|
LOHdr_LO_Cat |
varchar(25) |
NULL |
stores the loan order category defined in logistics common master |
No |
No |
|
|
|
LOHdr_LO_Priority |
varchar(20) |
NULL |
stores the loan order priority |
No |
No |
|
|
|
LOHdr_AC_RegNo |
varchar(30) |
NULL |
stores the Air craft registration number |
No |
No |
|
|
|
LOHdr_LO_Reason |
varchar(2000) |
NULL |
stores the reason |
No |
No |
|
|
|
LOHdr_Contact_Person |
varchar(80) |
NULL |
stores the contact person name for the supplier |
No |
No |
|
|
|
LOHdr_Supp_Addr_Id |
numeric(6) |
NULL |
stores the supplier’s address id |
No |
No |
|
|
|
LOHdr_Quantity |
numeric(28,8) |
NULL |
stores the quantity of the loaned part |
No |
No |
|
|
|
LOHdr_Recvd_Qty |
numeric(28,8) |
NULL |
stores the received quantity of the loaned part |
No |
No |
|
|
|
LOHdr_Part_Condn |
varchar(5) |
NULL |
stores the condition of the loaned part |
No |
No |
|
|
|
LOHdr_Cert_Type |
varchar(25) |
NULL |
stores the certification type defined in logistics common master |
No |
No |
|
|
|
LOHdr_Ship_To |
numeric(4) |
NULL |
stores the ship to location |
No |
No |
|
|
|
LOHdr_WH_No |
varchar(10) |
NULL |
stores the warehouse number |
No |
No |
|
|
|
LOHdr_Loan_Agmt_No |
varchar(40) |
NULL |
stores the loan agreement number |
No |
No |
|
|
|
LOHdr_Supp_OfferNo |
varchar(40) |
NULL |
stores the supplier offer number |
No |
No |
|
|
|
LOHdr_Ref_Doc |
varchar(25) |
NULL |
stores the user entered reference document |
No |
No |
|
|
|
LOHdr_Ref_Doc_No |
varchar(40) |
NULL |
stores the user entered reference document number |
No |
No |
|
|
|
LOHdr_Loan_Chrgs_On |
varchar(5) |
NULL |
stores the flag for Loan Charges On. List of values are: CB - Calendar Based PB - Parameter Based BH - Both NE - None |
No |
No |
|
|
|
LOHdr_Penalty_Applicable |
varchar(5) |
NULL |
stores the flag whether penalty applicable or not. Values are: Y - Yes N - No |
No |
No |
|
|
|
LOHdr_TCD_Applicable |
varchar(5) |
NULL |
stores the flag whether TCD applicable or not. Values are: Y - Yes N - No |
No |
No |
|
|
|
LOHdr_Date_Reqd |
datetime |
NULL |
stores the date from when the loan begins |
No |
No |
|
|
|
LOHdr_Loan_Period_Value |
numeric(28) |
NULL |
stores the value of the loan period |
No |
No |
|
|
|
LOHdr_Loan_Period_Units |
varchar(5) |
NULL |
stores the UOM of the loan period. Allowed values are: "D" - "Days", "W" - "Weeks", "M"- "Months", "B" - "Blank". |
No |
No |
|
|
|
LOHdr_Lead_Param |
varchar(40) |
NULL |
stores the lead parameter of the loan order part number |
No |
No |
|
|
|
LOHdr_Lead_Param_Uom |
varchar(10) |
NULL |
stores the UOM of the lead parameter |
No |
No |
|
|
|
LOHdr_Expected_Usage |
numeric(28) |
NULL |
stores the expected usage of the lead parameter |
No |
No |
|
|
|
LOHdr_Admin_Chrgs_Policy |
varchar(5) |
NULL |
stores the administrative charges policy for the loan order. Allowed values are: F - Flat P - Percent |
No |
No |
|
|
|
LOHdr_CBLC_Policy |
varchar(5) |
NULL |
stores the calendar based lease charges policy for the loan order. Allowed values are: F - Flat P - Percent |
No |
No |
|
|
|
LOHdr_PBLC_Policy |
varchar(5) |
NULL |
stores the parameter based charges policy for the loan order. Allowed values are: F - Flat P - Percent |
No |
No |
|
|
|
LOHdr_CBLC_Basis |
varchar(5) |
NULL |
stores the calendar based charges basis for the loan order. Allowed values are: C - Cumulative P - Period |
No |
No |
|
|
|
LOHdr_PBLC_Basis |
varchar(5) |
NULL |
stores the parameter based charges basis for the loan order. Allowed values are: C - Cumulative P - Period |
No |
No |
|
|
|
LOHdr_Part_BaseCost |
numeric(28,8) |
NULL |
stores the base cost of the loaned part |
No |
No |
|
|
|
LOHdr_Admin_Chrgs_In_Perc |
numeric(28,8) |
NULL |
stores the percent value for the administrative charges to be applied on part base cost |
No |
No |
|
|
|
LOHdr_Admin_Charges |
numeric(28,8) |
NULL |
stores the user entered administrative charges. This will be considered only if percent value is not specified in the administrative charges percent field |
No |
No |
|
|
|
LOHdr_Basic_Loan_Charges |
numeric(28,8) |
NULL |
stores the basic loan charges which is the combination of calendar based and parameter based lease charges captured in the multiline |
No |
No |
|
|
|
LOHdr_Addnl_Charges |
numeric(28,8) |
NULL |
stores the administrative charges. It is the total sum of the TCD amounts |
No |
No |
|
|
|
LOHdr_Base_Curr_Val |
numeric(28,8) |
NULL |
stores the loan order value in base currency |
No |
No |
|
|
|
LOHdr_EmployeeNo |
varchar(20) |
NULL |
stores the employee number |
No |
No |
|
|
|
LOHdr_Employee_Name |
varchar(77) |
NULL |
stores the employee name |
No |
No |
|
|
|
LOHdr_LO_Detail1 |
varchar(30) |
NULL |
stores the user defined detail 1 |
No |
No |
|
|
|
LOHdr_LO_Option1 |
varchar(30) |
NULL |
stores the user defined option 1 |
No |
No |
|
|
|
LOHdr_Hdr_Comments |
varchar(255) |
NULL |
stores the comments for the loan order |
No |
No |
|
|
|
LOHdr_Doc_Filename |
varchar(50) |
NULL |
stores the document file name attached to the loan order |
No |
No |
|
|
|
LOHdr_TCD_Comments |
varchar(255) |
NULL |
stores the TCD comments for the loan order |
No |
No |
|
|
|
LOHdr_AC_Tcd_Amt |
numeric(28,8) |
NULL |
stores the TCD amount calculated based on Administrative Charges |
No |
No |
|
|
|
LOHdr_BLC_Tcd_Amt |
numeric(28,8) |
NULL |
stores the TCD amount calculated based on Basic Loan Charges |
No |
No |
|
|
|
LOHdr_TLC_Tcd_Amt |
numeric(28,8) |
NULL |
stores the TCD amount calculated based on Total Loan Charges |
No |
No |
|
|
|
LOHdr_PBC_Tcd_Amt |
numeric(28,8) |
NULL |
stores the TCD amount calculated based on Part base cost |
No |
No |
|
|
|
LOHdr_Total_Loan_Charges |
numeric(28,8) |
NULL |
stores the total loan charges which is the sum of administrative and basic loan charges |
No |
No |
|
|
|
LOHdr_Created_By |
varchar(30) |
NULL |
stores the user who created the loan order |
No |
No |
|
|
|
LOHdr_Created_Date |
datetime |
NULL |
stores the loan order created date |
No |
No |
|
|
|
LOHdr_Modified_By |
varchar(30) |
NULL |
stores the user who modified the loan order |
No |
No |
|
|
|
LOHdr_Modified_Date |
datetime |
NULL |
stores the loan order modified date |
No |
No |
|
|
|
LOHdr_Timestamp |
numeric(20) |
NULL |
stores the timestamp. Initial value is 1. incremented by 1 everytime the record is modified |
No |
No |
|
|
|
LOHdr_Authorised_Date |
datetime |
NULL |
stores the loan order authorization date |
No |
No |
|
|
|
LOHdr_Authorised_By |
varchar(30) |
NULL |
stores the user who authorized the loan order |
No |
No |
|
|
|
LOHdr_Amendment_Date |
datetime |
NULL |
stores the loan order amendment date |
No |
No |
|
|
|
LOHdr_Amendment_By |
varchar(30) |
NULL |
stores the user who amended the loan order |
No |
No |
|
|
|
LOHdr_Comments |
varchar(255) |
NULL |
stores the comments for cancellation |
No |
No |
|
|
|
LOHdr_Num_Type_Num |
varchar(5) |
NULL |
stores the numbering type number for a loan order |
No |
No |
|
|
|
LOHdr_Wf_Doc_Key |
varchar(128) |
NULL |
stores the doc key of a loan order for work flow purpose |
No |
No |
|
|
|
LOHdr_Stage |
varchar(10) |
NULL |
stores the stage of the loan order. This is an intermediate state fetched from work flow while the document goes through different stages of authorization |
No |
No |
|
|
|
LOHdr_Iss_Loc |
numeric(4) |
NULL |
Stores the location from where the issue can happen for returning the loaned part |
No |
No |
|
|
|
LOHdr_Iss_WH |
varchar(10) |
NULL |
Stores the warehouse from where the issue can happen for returning the loaned part |
No |
No |
|
|
|
LOHdr_Pending_Iss_Qty |
numeric(28,8) |
NULL |
Stores the pending quantity of loan order to be issued |
No |
No |
|
|
|
LOHDR_LORDER_TYPE |
char(5) |
NULL |
This field captures the Loan Order type |
No |
No |
|
|
|
LOHDR_PURCHASE_COST |
numeric(28,8) |
NULL |
This field captures the purchase cost of the loan Order |
No |
No |
|
|
|
LOHDR_INTSTK_STATUS |
char(18) |
NULL |
This field holds the internal stock status of the Loan Order |
No |
No |
|
|
|
LOHDR_LO_STATUSFLAG |
varchar(5) |
NULL |
This field holds the status |
No |
No |
|
|
|
lohdr_below_threshold |
varchar(40) |
NULL |
This field holds the threshold value |
No |
No |
|
|
|
LOHDR_VALUE_DIFF |
numeric(28,8) |
NULL |
Column to capture the difference in amount between the previous Amendment and current amendment |
No |
No |
|
|
|
LOHDR_ACTUAL_LOAN_CHARGES |
numeric(28,8) |
NULL |
Column to capture the actual loan order charges computed based on the actual usage period. |
No |
No |
|
|
|
|
|||||||
|
Table Name LO_Lolc_Lease_Charges |
|
||||||
|
|
|||||||
|
Table Comment This Table holds the calendar based and parameter based lease charges for a loan order document |
| ||||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
|
|
LOLC_Rate_Per_UOM |
numeric(28,8) |
NULL |
stores the flat rate per UOM of calendar period or the flat rate per UOM of parameter |
No |
No |
|
|
|
LOLC_To_ParamVal |
numeric(28,8) |
NULL |
stores the to value of a parameter value |
No |
No |
|
|
|
LOLC_From_ParamVal |
numeric(28,8) |
NULL |
stores the from value of a parameter value |
No |
No |
|
|
|
LOLC_Charge_Per_Unit |
numeric(28,8) |
NULL |
stores the charge per unit. If the charges policy 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 value/100 |
No |
No |
|
|
|
LOLC_Charge_For_Period |
numeric(28,8) |
NULL |
If the charges policy 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 |
No |
|
|
|
LOLC_Remarks |
varchar(255) |
NULL |
stores the remarks |
No |
No |
|
|
|
LOLC_LO_No |
varchar(40) |
NOT NULL |
stores the loan order number |
Yes |
Yes |
|
|
|
LOLC_LO_OUInstance |
numeric(4) |
|
stores the OUInstance where the loan order is created |
Yes |
Yes |
|
|
|
LOLC_To_Cal_Period |
numeric(28,8) |
NULL |
stores the to value of a period |
No |
No |
|
|
|
LOLC_From_Cal_Period |
numeric(28,8) |
NULL |
stores the from value of a period |
No |
No |
|
|
|
LOLC_MltLine_Flag |
varchar(5) |
NOT NULL |
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 |
No |
|
|
|
LOLC_Line_Id |
numeric(6) |
NOT NULL |
stores the line id which is a generated serial number |
Yes |
No |
|
|
|
|
|||||||
|
Table Name LO_Lopcd_Penalty_Charges |
|
||||||
|
|
|||||||
|
Table Comment This table stores the penalty charges defined for a Loan Order |
|
||||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
|
|
Lopcd_Rate_Per_UOM |
numeric(28,8) |
NULL |
stores the flat rate per UOM of calendar period or the flat rate per UOM of parameter |
No |
No |
|
|
|
Lopcd_To_ParamVal |
numeric(28,8) |
NULL |
stores the to value of a parameter value |
No |
No |
|
|
|
Lopcd_From_ParamVal |
numeric(28,8) |
NULL |
stores the from value of a parameter value |
No |
No |
|
|
|
Lopcd_Charge_Per_Unit |
numeric(28,8) |
NULL |
stores the penalty charge per unit. If the charges policy 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 value/100 |
No |
No |
|
|
|
Lopcd_Charge_For_Period |
numeric(28,8) |
NULL |
stores the penalty charge per period If the charges policy 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 |
No |
|
|
|
Lopcd_Remarks |
varchar(255) |
NULL |
stores the remarks |
No |
No |
|
|
|
Lopcd_LO_No |
varchar(40) |
NOT NULL |
stores the loan order number |
Yes |
Yes |
|
|
|
Lopcd_LO_OUInstance |
numeric(4) |
NOT NULL |
stores the OUInstance where the loan order is created |
Yes |
Yes |
|
|
|
Lopcd_To_Cal_Period |
numeric(28,8) |
NULL |
stores the to value of a period |
No |
No |
|
|
|
Lopcd_From_Cal_Period |
numeric(28,8) |
NULL |
stores the from value of a period |
No |
No |
|
|
|
Lopcd_MltLine_Flag |
varchar(5) |
NOT NULL |
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 |
No |
|
|
|
Lopcd_Line_Id |
numeric(6) |
NOT NULL |
stores the line id which is a generated serial number |
Yes |
No |
|
|
|
|
|||||||
|
Table Name LO_Lopch_Penalty_Chrgs_Hdr |
|
||||||
|
|
|||||||
|
Table Comment This table stores the penalty charges header details for a Loan Order |
|
||||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
|
|
Lopch_CBPC_Basis |
varchar(5) |
NULL |
stores the calendar based charges policy for the loan order. Allowed values are: C - Cumulative P - Period |
No |
No |
|
|
|
Lopch_CBPC_Policy |
varchar(5) |
NULL |
stores the calendar based lease charges policy for the loan order. Allowed values are: F - Flat P - Percent |
No |
No |
|
|
|
Lopch_PBPC_Policy |
varchar(5) |
NULL |
stores the parameter based charges policy for the loan order. Allowed values are: F - Flat P - Percent |
No |
No |
|
|
|
Lopch_PBPC_Basis |
varchar(5) |
NULL |
stores the parameter based charges policy for the loan order. Allowed values are: C - Cumulative P - Period |
No |
No |
|
|
|
Lopch_LO_OUInstance |
numeric(4) |
NOT NULL |
stores the OUInstance where the loan order is created |
Yes |
Yes |
|
|
|
Lopch_Comments |
varchar(255) |
NULL |
stores the comments |
No |
No |
|
|
|
Lopch_LO_No |
varchar(40) |
NOT NULL |
stores the loan order number |
Yes |
Yes |
|
|
|
Lopch_Fix_Penalty_Chrgs |
numeric(28,8) |
NULL |
stores the fix penalty charges for the loan order |
No |
No |
|
|
|
|
|||||||
|
Table Name LO_LOPrm_Parameter_dtl |
|
||||||
|
|
|||||||
|
Table Comment This table is to hold Parameter Details for the Loan Order. |
|
||||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
|
|
LOPrm_Componentname |
varchar(80) |
NOT NULL |
This field holds the Name of the component. |
Yes |
No |
|
|
|
LOPrm_Paramcategory |
varchar(10) |
NOT NULL |
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 |
No |
|
|
|
LOPrm_Paramtype |
varchar(25) |
NOT NULL |
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 |
No |
|
|
|
LOPrm_Paramcode |
varchar(5) |
NOT NULL |
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 |
No |
|
|
|
LOPrm_Langid |
numeric(4) |
NOT NULL |
Language id. This is the language id of the record. |
Yes |
No |
|
|
|
LOPrm_Paramdesc |
varchar(80) |
NOT NULL |
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 |
No |
|
|
|
LOPrm_Sortby |
numeric(26) |
NULL |
This field holds the default sort by code |
No |
No |
|
|
|
LOPrm_Createddate |
datetime |
NULL |
This field holds the record created date for auditing purpose. |
No |
No |
|
|
|
|
|||||||
|
Table Name LO_LOSC_Sup_Corr_Details |
|
||||||
|
|
|||||||
|
Table 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 |
|
||||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
|
|
LOSC_Createddate |
datetime |
NULL |
stores the created date |
No |
No |
|
|
|
LOSC_Buyer_Remarks |
varchar(255) |
NULL |
stores the remarks entered by buyer |
No |
No |
|
|
|
LOSC_Supp_Remarks |
varchar(255) |
NULL |
stores the remarks sent by the supplier |
No |
No |
|
|
|
LOSC_Created_By |
varchar(30) |
NULL |
stores the user name who created the record |
No |
No |
|
|
|
LOSC_ModifiedDate |
datetime |
NULL |
stores the modified date |
No |
No |
|
|
|
LOSC_Modified_By |
varchar(30) |
NULL |
stores the user name who modified the record |
No |
No |
|
|
|
LOSC_LO_No |
varchar(40) |
NOT NULL |
stores the loan order number |
Yes |
Yes |
|
|
|
LOSC_OUInstance |
numeric(4) |
NOT NULL |
stores the OUInstance where the loan order is created |
Yes |
Yes |
|
|
|
LOSC_Date |
datetime |
NULL |
stores the date on which the supplier comment or buyer comment is recorded |
No |
No |
|
|
|
LOSC_Line_No |
numeric(10) |
NOT NULL |
Holds the line no for all correspondence detail |
Yes |
No |
|
|
|
LOSC_Amend_NO |
numeric(6) |
NOT NULL |
stores the amendment number of the Loan order |
Yes |
No |
|
|
|
|
|||||||
|
Table Name LO_LOSopt_SetOptions_Info |
|
||||||
|
|
|||||||
|
Table Comment This table stores the set options information for Loan Order |
|
||||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
|
|
LOSopt_LO_OUInstance |
numeric(4) |
NOT NULL |
stores the OUInstance |
Yes |
No |
|
|
|
LOSopt_PrtType_Allowed |
varchar(40) |
NOT NULL |
This field stores the flag for part types allowed on which a loan order can be raised. There can be 3 values allowed: "C" - "Component ", "O" - "Others"’ "A"- "All ". |
No |
No |
|
|
|
LOSopt_Allow_AltPrt_Rcpt |
varchar(5) |
NULL |
This field holds the flag whether it is allowed to receive an alternate part. The values are: "Y" - "Yes", "N" - "No". |
No |
No |
|
|
|
LOSopt_Charge_Calc_Prd |
varchar(5) |
NULL |
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 |
No |
|
|
|
LOSopt_Loan_Charges |
varchar(5) |
NULL |
This field holds the flag whether Loan charges is enterable or Non enterable. Allowed values are: "E"- "Enterable", "N"- Non Enterable . |
No |
No |
|
|
|
LOSopt_Created_By |
varchar(30) |
NULL |
Holds the username who created the record |
No |
No |
|
|
|
LOSopt_Created_Date |
datetime |
NULL |
Holds the date on which the record is created |
No |
No |
|
|
|
LOSopt_Modified_By |
varchar(30) |
NULL |
Holds the username who modified the record |
No |
No |
|
|
|
LOSopt_Modified_Date |
datetime |
NULL |
Holds the date on which the record is modified |
No |
No |
|
|
|
LOSopt_Timestamp |
numeric(20) |
NULL |
stores the timestamp. Initial value is 1. Incremented by 1 every time a modification is done |
No |
No |
|
|
|
LOSOPT_STKCRR_NUM_TYPE |
char(18) |
NULL |
This field holds the Auto numbering type for Stock correction option |
No |
No |
|
|
|
LOSOPT_SSC_NUM_TYPE |
char(18) |
NULL |
This field holds the Auto numbering type for Stock status conversion option |
No |
No |
|
|
|
|
|||||||
|
Table Name LO_LOtmcn_LO_Terms_Condns |
|
||||||
|
|
|||||||
|
Table Comment This table holds the Terms and Condition of Loan order document |
|
||||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
|
|
LOtmcn_carrieragency |
varchar(20) |
NULL |
This field holds the list of carrier agencies |
No |
No |
|
|
|
LOtmcn_inco_term |
varchar(150) |
NULL |
This field holds the INCO term of the purchase order document. |
No |
No |
|
|
|
LOtmcn_port_of_dep |
varchar(32) |
NULL |
This field holds the port of departure |
No |
No |
|
|
|
LOtmcn_delivery_point |
varchar(32) |
NULL |
This field holds the delivery point of the purchase order document. |
No |
No |
|
|
|
LOtmcn_packaging_notes |
varchar(2000) |
NULL |
This field holds the packaging notes |
No |
No |
|
|
|
LOtmcn_ship_by |
varchar(25) |
NULL |
This field holds the mode of transport of the purchase order document. Mode of transports are 1. AIR 2.LAND |
No |
No |
|
|
|
LOtmcn_Inspection_Type |
varchar(5) |
NULL |
stores the flag for inspection type "S" - "Self", "BI" - "By Inspector", "N" - " None". |
No |
No |
|
|
|
LOtmcn_ship_payment |
varchar(25) |
NULL |
This field holds the list of shipping payment methods in active status defined in the Logistics common master component. |
No |
No |
|
|
|
LOtmcn_pkg_code |
varchar(25) |
NULL |
This field holds the packaging terms of the purchase order document. List of values 1. Bottle 2. Box |
No |
No |
|
|
|
LOtmcn_remarks |
varchar(255) |
NULL |
This field holds the remarks of the purchase order document’s terms and condition. |
No |
No |
|
|
|
LOtmcn_LO_Detail4 |
varchar(30) |
NULL |
stores the used defined details |
No |
No |
|
|
|
LOtmcn_LO_Detail3 |
varchar(30) |
NULL |
stores the used defined details |
No |
No |
|
|
|
LOtmcn_LO_Option2 |
varchar(30) |
NULL |
stores the used defined option |
No |
No |
|
|
|
LOtmcn_LO_Option3 |
varchar(30) |
NULL |
stores the used defined option |
No |
No |
|
|
|
LOtmcn_shipping_notes |
varchar(2000) |
NULL |
This field holds the shipping notes |
No |
No |
|
|
|
LOtmcn_insurance_liability |
varchar(150) |
NULL |
This field holds insurance liability of the PO document List of values are "SU" - "Supplier", "SE" - "Self", "O" - "Others". |
No |
No |
|
|
|
LOtmcn_LO_Detail2 |
varchar(30) |
NULL |
stores the used defined details |
No |
No |
|
|
|
LOtmcn_insurance_amt |
decimal(28,8) |
NULL |
This field holds the insurance amount of the purchase order document. |
No |
No |
|
|
|
LOtmcn_insurance_terms |
varchar(150) |
NULL |
This field holds the insurance term of purchase order document. |
No |
No |
|
|
|
LOtmcn_LO_Option4 |
varchar(30) |
NULL |
stores the used defined option |
No |
No |
|
|
|
LOtmcn_advance_payable |
varchar(5) |
NULL |
This field holds the advance payable flag of the purchase order document. List of values (Y)es (N)o |
No |
No |
|
|
|
LOtmcn_gta_remarks |
varchar(255) |
NULL |
This field holds the General Terms Agreement remarks |
No |
No |
|
|
|
LOtmcn_advance_perc_on |
varchar(5) |
NULL |
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 |
No |
|
|
|
LOtmcn_advance_perc |
numeric(28) |
NULL |
This field holds the advance percentage. |
No |
No |
|
|
|
LOtmcn_advance_pay_amt |
numeric(28) |
NULL |
This field holds the advance payable amount. If advance payable flag is ’yes’ then this is mandatory |
No |
No |
|
|
|
LOtmcn_LO_OUInstance |
numeric(4) |
NOT NULL |
stores the OUInstance where the loan order is created |
Yes |
Yes |
|
|
|
LOtmcn_refdoc_date |
datetime |
NULL |
This field holds the General Terms Agreement reference document Date |
No |
No |
|
|
|
LOtmcn_LO_No |
varchar(40) |
NOT NULL |
stores the loan order number |
Yes |
Yes |
|
|
|
LOtmcn_gta_refdoc_no |
varchar(40) |
NULL |
This field holds the General Terms Agreement reference document no. |
No |
No |
|
|
|
LOtmcn_pay_to_supp_id |
numeric(6) |
NULL |
This field holds the pay to supplier address ids |
No |
No |
|
|
|
LOtmcn_ddcharges_borneby |
varchar(5) |
NULL |
This field holds the DD charges borne by of the purchase order document. List of values "SU" - "Supplier", "SE" - "Self". |
No |
No |
|
|
|
LOtmcn_payment_mode |
varchar(5) |
NULL |
This field holds various payment mode. list of values are (Cq)Cheque (Cs)Cash (D)raft (P)ay order |
No |
No |
|
|
|
LOtmcn_Tolerance_Type |
varchar(5) |
NULL |
stores the flag for tolerance type Values: "V" - "Value". |
No |
No |
|
|
|
LOtmcn_Tolerance_Perc |
numeric(28,8) |
NULL |
stores the tolerance percentage |
No |
No |
|
|
|
LOtmcn_advance_tol_perc |
numeric(28) |
NULL |
This field holds the advance tolerance percentage. |
No |
No |
|
|
|
LOtmcn_pay_to_supp |
varchar(45) |
NULL |
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 |
No |
|
|
|
LOtmcn_advance_paydate |
datetime |
NULL |
This field holds the advance payable date. If advance payable flag is ’yes’ then this is mandatory |
No |
No |
|
|
|
LOtmcn_pay_priority |
varchar(5) |
NULL |
This field holds the payment priority of the PO document List of values are "’H" - "High", "N" - "Normal", "L" - "Low". |
No |
No |
|
|
|
LOtmcn_pay_to_supp_ou |
numeric(4) |
NULL |
stores the OUInstance of the supplier defined as the pay to supplier for the base supplier |
No |
No |
|
|
|
LOtmcn_payterm_code |
varchar(25) |
NULL |
This field holds the Unique identifier for the Payterm |
No |
No |
|
|
|
LOTMCN_RMANO |
varchar(40) |
NULL |
Column to store RMA no. |
No |
No |
|
|
|
LOTMCN_RMADATE |
datetime |
NULL |
Column to store RMA date |
No |
No |
|
|
|
LOTMCN_RET_SUPP_ID |
char(45) |
NULL |
Coumn to store Supplier ID |
No |
No |
|
|
|
|
|||||||
|
Table Name LORD_LO_Rcpt_det |
|
||||||
|
|
|||||||
|
Table Comment Stores the details of the receipts that are confirmed against the Loan Order |
|
||||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
|
|
LORD_LRcpt_Pend_Iss_Qty |
numeric(28,8) |
NULL |
stores the receipt qty received against loan order |
No |
No |
|
|
|
LORD_LRcpt_stock_status |
varchar(40) |
NULL |
stores the stock status of the loaned part |
No |
No |
|
|
|
LORD_LRcpt_WH |
varchar(10) |
NULL |
stores the warehouse where the qty is received against loan order |
No |
No |
|
|
|
LORD_LRcpt_CompID |
varchar(90) |
NULL |
stores the component ID generated for the part received through the loan receipt |
No |
No |
|
|
|
LORD_LRcpt_lotno |
varchar(18) |
NULL |
stores the lot number for the loaned part |
No |
No |
|
|
|
LORD_LRcpt_zone |
varchar(10) |
NULL |
stores the zone into which the loaned part is received |
No |
No |
|
|
|
LORD_LRcpt_bin |
varchar(10) |
NULL |
stores the bin into which the loaned part is received |
No |
No |
|
|
|
LORD_LRcpt_condition |
varchar(25) |
NULL |
stores the condition in which the loaned part is received |
No |
No |
|
|
|
LORD_LO_No |
varchar(40) |
NOT NULL |
stores the loan order number |
Yes |
Yes |
|
|
|
LORD_LRcpt_No |
varchar(40) |
NOT NULL |
stores the loan receipt document number |
Yes |
No |
|
|
|
LORD_LO_OUInstance |
numeric(4) |
NOT NULL |
stores the OUInstance where the loan order is created |
Yes |
Yes |
|
|
|
LORD_LRcpt_SerialNo |
varchar(40) |
NULL |
stores the serial number generated for the part received through the loan receipt |
No |
No |
|
|
|
LORD_LRcpt_PartOU |
numeric(4) |
NULL |
stores the OUInstance of the Loan receipt part |
No |
No |
|
|
|
LORD_LRcpt_Date |
datetime |
NULL |
stores the loan receipt document date |
No |
No |
|
|
|
LORD_LRcpt_PartNo |
varchar(40) |
NULL |
stores the part number received through the loan receipt |
No |
No |
|
|
|
LORD_LRcpt_Qty |
numeric(28,8) |
NULL |
stores the loan receipt quantity |
No |
No |
|
|
|
|
|
|
|
|
|
|
|