Data Dictionary - Rental Order |
|
| |||||
|
|
|||||||
|
Table Name Rnt_RntAdtcd_Rnt_Doc_Tcd |
|
||||||
|
|
|||||||
|
Table Comment This table holds the Document TCD details of an Amended Rental order. |
|
||||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
|
|
RntAdtcd_tcd_rate |
numeric(28,8) |
NULL |
This field holds the TCD rate for the TCD code and the variant . this should not be changed for TCD basis -- Percentage. |
No |
No |
|
|
|
RntAdtcd_tcd_amount |
numeric(28,8) |
NULL |
This field holds 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 |
|
|
|
RntAtcd_tcd_ou |
numeric |
NULL |
This field holds the TCD OU Instance |
No |
No |
|
|
|
RntAdtcd_user_seq |
numeric |
NULL |
This field holds the sequence number as entered by the user for the TCD |
No |
No |
|
|
|
RntAdtcd_pay_to_supp_ou |
numeric |
NULL |
This field holds the pay to supplier OU Instance |
No |
No |
|
|
|
RntAdtcd_pay_currency |
varchar(20) |
NULL |
This field holds the Transaction currency |
No |
No |
|
|
|
RntAdtcd_pay_to_supp |
varchar(45) |
NULL |
This field holds the 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 |
|
|
|
RntAdtcd_Exchg_Rate |
numeric(28,8) |
NULL |
This field holds the exchange rate between the document currency and the payment currency |
No |
No |
|
|
|
RntAdtcd_Rnt_No |
varchar(40) |
NOT NULL |
This field holds the rental order number |
Yes |
Yes |
|
|
|
RntAdtcd_Amend_No |
numeric(5) |
NOT NULL |
This field holds the rental order amendment number. if the RTO is not amended then 0 is stored |
Yes |
Yes |
|
|
|
RntAdtcd_Rnt_OUInstance |
numeric(4) |
NOT NULL |
This field holds the OU Instance where the rental order is created |
Yes |
Yes |
|
|
|
RntAdtcd_tcd_variant |
varchar(25) |
NOT NULL |
This field holds the TCD variant for the TCD code. |
No |
No |
|
|
|
RntAdtcd_tcd_code |
varchar(25) |
NOT NULL |
This field holds the Unique identifier for the TCD |
No |
No |
|
|
|
RntAdtcd_Tcd_Mode |
varchar(5) |
NOT NULL |
This field holds the mode for which the TCDs are captured. RP - Rental Price AC - Administrative Charges LC - Lease Charges RC - Rental Charges |
Yes |
No |
|
|
|
RntAdtcd_Line_no |
numeric |
NOT NULL |
This field holds the Unique identifier number for the TCD of the rental order |
Yes |
No |
|
|
|
|
|||||||
|
Table Name Rnt_RntAHdr_Rental_Order_Hdr |
|
||||||
|
|
|||||||
|
Table Comment This table holds the Amended Rental order information |
|
||||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
|
|
RntAHdr_Rnt_OUInstance |
numeric(4) |
NOT NULL |
This field holds the OU Instance where the rental order is created |
Yes |
Yes |
|
|
|
RntAHdr_Rnt_No |
varchar(40) |
NOT NULL |
This field holds the rental order number |
Yes |
Yes |
|
|
|
RntAHdr_Amend_No |
numeric(5) |
NOT NULL |
This field holds the rental order amendment number. |
Yes |
No |
|
|
|
RntAHdr_Rnt_Date |
datetime |
NULL |
This field holds the document date |
No |
No |
|
|
|
RntAHdr_Rnt_Status |
varchar(5) |
NULL |
This field holds 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 |
|
|
|
RntAHdr_Part_No |
varchar(40) |
NULL |
This field holds the part no on which the rental order is raised |
No |
No |
|
|
|
RntAHdr_Prt_Srl_No |
varchar(40) |
NULL |
This field holds the part serial no |
No |
No |
|
|
|
RntAHdr_Part_OUInstance |
numeric(4) |
NULL |
This field holds the part OUinstance |
No |
No |
|
|
|
RntAHdr_Cust_Code |
varchar(40) |
NULL |
This field holds the customer code |
No |
No |
|
|
|
RntAHdr_Cust_Created_OU |
numeric(4) |
NULL |
This field holds the OUInstance where the customer is created |
No |
No |
|
|
|
RntAHdr_Cust_OU |
numeric(4) |
NULL |
This field holds the customer OUinstance |
No |
No |
|
|
|
RntAHdr_Rnt_Currency |
varchar(20) |
NULL |
This field holds the document/order currency |
No |
No |
|
|
|
RntAHdr_Exchange_Rate |
numeric(28,8) |
NULL |
This field holds the exchange rate between the document currency and base currency |
No |
No |
|
|
|
RntAHdr_Base_Currency |
varchar(20) |
NULL |
This field holds the base currency |
No |
No |
|
|
|
RntAHdr_User_Status |
varchar(25) |
NULL |
This field holds the user defined status |
No |
No |
|
|
|
RntAHdr_Rnt_Cat |
varchar(25) |
NULL |
This field holds the rental order category defined in logistics common master |
No |
No |
|
|
|
RntAHdr_Rnt_Priority |
varchar(20) |
NULL |
This field holds the rental order priority |
No |
No |
|
|
|
RntAHdr_AC_RegNo |
varchar(30) |
NULL |
This field holds the Air craft registration number |
No |
No |
|
|
|
RntAHdr_Contact_Person |
varchar(80) |
NULL |
This field holds the contact person for the customer |
No |
No |
|
|
|
RntAHdr_Cust_Phone_No |
varchar(18) |
NULL |
This field holds the contact person’s phone no |
No |
No |
|
|
|
RntAHdr_Cust_Fax_No |
varchar(40) |
NULL |
This field holds the contact person’s fax no |
No |
No |
|
|
|
RntAHdr_Cust_Email |
varchar(60) |
NULL |
This field holds the contact person’s email ID |
No |
No |
|
|
|
RntAHdr_Cust_Address |
varchar(255) |
NULL |
This field holds the contact person’s address |
No |
No |
|
|
|
RntAHdr_Manf_PartNo |
varchar(40) |
NULL |
This field holds the manufacturer’s part number |
No |
No |
|
|
|
RntAHdr_Component_No |
varchar(90) |
NULL |
This field holds the component no |
No |
No |
|
|
|
RntAHdr_Prt_Condition |
varchar(25) |
NULL |
This field holds the condition of the manufacturer part number |
No |
No |
|
|
|
RntAHdr_Lot_No |
varchar(18) |
NULL |
This field holds the lot number of the manufacturer part number |
No |
No |
|
|
|
RntAHdr_Location |
varchar(256) |
NULL |
This field holds the location of the warehouse from where the part is to be rented |
No |
No |
|
|
|
RntAHdr_WH_No |
varchar(10) |
NULL |
This field holds the warehouse number from where the part is to be rented |
No |
No |
|
|
|
RntAHdr_Quantity |
numeric(28,8) |
NULL |
This field holds the order quantity |
No |
No |
|
|
|
RntAHdr_Recvd_Qty |
numeric(28,8) |
NULL |
This field holds the received quantity of rented out part updated by rental receipt |
No |
No |
|
|
|
RntAHdr_Agmt_No |
varchar(40) |
NULL |
This field holds the agreement number |
No |
No |
|
|
|
RntAHdr_OfferNo |
varchar(40) |
NULL |
This field holds the offer number |
No |
No |
|
|
|
RntAHdr_Ref_Doc |
varchar(25) |
NULL |
This field holds the reference document |
No |
No |
|
|
|
RntAHdr_Ref_Doc_No |
varchar(40) |
NULL |
This field holds the reference document number |
No |
No |
|
|
|
RntAHdr_Lease_Chrgs_On |
varchar(5) |
NULL |
This field holds the flag for Loan Charges On. List of values are: CB - Calendar Based PB - Parameter Based BH - Both NE - None |
No |
No |
|
|
|
RntAHdr_Penalty_Applicable |
varchar(5) |
NULL |
This field holds the flag whether penalty applicable or not. Values are: Y - Yes N - No |
No |
No |
|
|
|
RntAHdr_TCD_Applicable |
varchar(5) |
NULL |
This field holds the flag whether TCD applicable or not. Values are: Y - Yes N - No |
No |
No |
|
|
|
RntAHdr_Date_Reqd |
datetime |
NULL |
This field holds the date from when the lease begins |
No |
No |
|
|
|
RntAHdr_CalLeasePeriod_Val |
numeric(6) |
NULL |
This field holds the value of the calendar lease period |
No |
No |
|
|
|
RntAHdr_CalLeasPeriod_Units |
varchar(5) |
NULL |
This field holds the UOM of the calendar lease period. Allowed values are: D - Days W - Weeks M - Months |
No |
No |
|
|
|
RntAHdr_ParLeasePeriod_Val |
numeric(6) |
NULL |
This field holds the value of the parameter lease period |
No |
No |
|
|
|
RntAHdr_Lead_Param |
varchar(40) |
NULL |
stores the lead parameter of the rental order part number |
No |
No |
|
|
|
RntAHdr_Lead_Param_Uom |
varchar(10) |
NULL |
This field holds the UOM of the lead parameter |
No |
No |
|
|
|
RntAHdr_LP_TSN |
numeric(28,8) |
NULL |
This field holds the time since new value of the lead parameter for the rental part number |
No |
No |
|
|
|
RntAHdr_LP_TSO |
numeric(28,8) |
NULL |
This field holds the since overhaul value of the lead parameter for the rental part number |
No |
No |
|
|
|
RntAHdr_LP_TSR |
numeric(28,8) |
NULL |
This field holds the time since repair value of the lead parameter for the rental part number |
No |
No |
|
|
|
RntAHdr_LP_TSI |
numeric(28,8) |
NULL |
This field holds the time since inspection value of the lead parameter for the rental part number |
No |
No |
|
|
|
RntAHdr_LP_TSV |
numeric(28,8) |
NULL |
This field holds the time since shop visit value of the lead parameter for the rental part number |
No |
No |
|
|
|
RntAHdr_Admin_Chrgs_Policy |
varchar(5) |
NULL |
This field holds the administrative charges policy for the rental order. Allowed values are: F - Flat P - Percent |
No |
No |
|
|
|
RntAHdr_CBLC_Policy |
varchar(5) |
NULL |
This field holds the calendar based lease charges policy for the rental order. Allowed values are: F - Flat P - Percent |
No |
No |
|
|
|
RntAHdr_PBLC_Policy |
varchar(5) |
NULL |
This field holds the parameter based charges policy for the rental order. Allowed values are: F - Flat P - Percent |
No |
No |
|
|
|
RntAHdr_CBLC_Basis |
varchar(5) |
NULL |
This field holds the calendar based charges policy for the rental order. Allowed values are: C - Cumulative P - Period |
No |
No |
|
|
|
RntAHdr_PBLC_Basis |
varchar(5) |
NULL |
This field holds the parameter based charges policy for the rental order. Allowed values are: C - Cumulative P - Period |
No |
No |
|
|
|
RntAHdr_BasePrice |
numeric(28,8) |
NULL |
This field holds the base price of the part |
No |
No |
|
|
|
RntAHdr_Markup_Factor |
numeric(28,8) |
NULL |
This field holds the mark up factor |
No |
No |
|
|
|
RntAHdr_Admin_Chrgs_In_Perc |
numeric(28,8) |
NULL |
This field holds the percent value for the administrative charges to be applied on rental price |
No |
No |
|
|
|
RntAHdr_Admin_Charges |
numeric(28,8) |
NULL |
This field holds the user entered administrative charges. This will be considered only if percent value is not specified in the administrative charges percent field |
No |
No |
|
|
|
RntAHdr_Lease_Charges |
numeric(28,8) |
NULL |
This field holds the lease charges. it is either the sum of the calendar based lease charges or sum of parameter based lease charges or sum of both calendar and parameter based lease charges. |
No |
No |
|
|
|
RntAHdr_Addnl_Charges |
numeric(28,8) |
NULL |
This field holds the administrative charges. It is the total sum of the TCD amounts |
No |
No |
|
|
|
RntAHdr_Rnt_Detail1 |
varchar(25) |
NULL |
This field holds the user defined detail 1 |
No |
No |
|
|
|
RntAHdr_Rnt_Option1 |
varchar(30) |
NULL |
This field holds the user defined option 1 |
No |
No |
|
|
|
RntAHdr_Hdr_Remarks |
varchar(100) |
NULL |
This field holds the remarks for the rental order |
No |
No |
|
|
|
RntAHdr_Doc_Filename |
varchar(50) |
NULL |
This field holds the document file name attached to the rental order |
No |
No |
|
|
|
RntAHdr_TCD_Comments |
varchar(255) |
NULL |
This field holds the TCD comments for the rental order |
No |
No |
|
|
|
RntAHdr_RP_Tcd_Amt |
numeric(28,8) |
NULL |
This field holds the Tcd amount calculated on rental price |
No |
No |
|
|
|
RntAHdr_AC_Tcd_Amt |
numeric(28,8) |
NULL |
This field holds the Tcd amount calculated on administrative charges |
No |
No |
|
|
|
RntAHdr_LC_Tcd_Amt |
numeric(28,8) |
NULL |
This field holds the Tcd amount calculated on lease charges |
No |
No |
|
|
|
RntAHdr_RC_Tcd_Amt |
numeric(28,8) |
NULL |
This field holds the Tcd amount calculated on rental charges |
No |
No |
|
|
|
RntAHdr_Total_Rental_Val |
numeric(28,8) |
NULL |
This field holds the total rental value which the addition of Rental charges and Tcd Value |
No |
No |
|
|
|
RntAHdr_Canc_Reason |
varchar(255) |
NULL |
This field holds the reason for cancellation of rental order |
No |
No |
|
|
|
RntAHdr_Ret_Reason |
varchar(255) |
NULL |
This field holds the reason for returning a rental order |
No |
No |
|
|
|
RntAHdr_Num_Type_Num |
varchar(5) |
NULL |
This field holds the numbering type number for a rental order |
No |
No |
|
|
|
RntAHdr_Wf_Doc_Key |
varchar(128) |
NULL |
This field holds the doc key of a rental order for work flow purpose |
No |
No |
|
|
|
RntAHdr_Stage |
varchar(10) |
NULL |
This field holds the stage of the rental order. This is an intermediate state fetched from work flow while the document goes through different stages of authorization |
No |
No |
|
|
|
RntAHdr_Authorised_Date |
datetime |
NULL |
This field holds the rental order authorization date |
No |
No |
|
|
|
RntAHdr_Authorised_By |
varchar(30) |
NULL |
This field holds the user who authorized the rental order |
No |
No |
|
|
|
RntAHdr_Amendment_Date |
datetime |
NULL |
This field holds the rental order amendment date |
No |
No |
|
|
|
RntAHdr_Amendment_By |
varchar(30) |
NULL |
This field holds the user who amended the rental order |
No |
No |
|
|
|
RntAHdr_Created_By |
varchar(30) |
NULL |
This field holds the user who created the rental order |
No |
No |
|
|
|
RntAHdr_Created_Date |
datetime |
NULL |
This field holds the rental order created date |
No |
No |
|
|
|
RntAHdr_Modified_By |
varchar(30) |
NULL |
This field holds the user who modified the rental order |
No |
No |
|
|
|
RntAHdr_Modified_Date |
datetime |
NULL |
This field holds the rental order modified date |
No |
No |
|
|
|
RntAHdr_Timestamp |
numeric(20) |
NULL |
This field holds the timestamp. Initial value is 1. incremented by 1 every time the record is modified |
No |
No |
|
|
|
RntAHdr_Zone |
varchar(10) |
NULL |
This field holds the zone number corresponding to the warehouse number from where the part is to be rented. This is the outcome of picking priority logic |
No |
No |
|
|
|
RntAHdr_Bin |
varchar(10) |
NULL |
This field holds the bin number corresponding to the zone number from where the part is to be rented. This is the outcome of picking priority logic |
No |
No |
|
|
|
RntAHdr_Alt_PartNo |
varchar(40) |
NULL |
This field holds the alternate part no for rental order part |
No |
No |
|
|
|
RntAHdr_Pen_Isu_Qty |
numeric(28,2) |
NULL |
This field holds the pending quantity of rental order to be issued |
No |
No |
|
|
|
RntAHdr_Def_Fin_Book |
varchar(32) |
NULL |
This field holds the default finance book code |
No |
No |
|
|
|
RntAHdr_Account_code |
varchar(32) |
NULL |
This field holds the Account code |
No |
No |
|
|
|
RntAHdr_Account_Type |
char(5) |
NULL |
This field holds the Account type |
No |
No |
|
|
|
|
|||||||
|
Table Name Rnt_RntALC_Lease_Charges |
|
||||||
|
|
|||||||
|
Table Comment This Table holds the calendar based and parameter based lease charges for an Amended rental order document |
|||||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
|
|
RntALC_Rnt_OUInstance |
numeric(4) |
NOT NULL |
This field holds the OU Instance where the rental order is created |
Yes |
Yes |
|
|
|
RntALC_Rnt_No |
varchar(40) |
NOT NULL |
This field holds the rental order number |
Yes |
Yes |
|
|
|
RntALC_Amend_No |
numeric(5) |
NOT NULL |
This field holds the rental order amendment number. if the RTO is not amended then 0 is stored |
Yes |
Yes |
|
|
|
RntALC_MltLine_Flag |
varchar(5) |
NOT NULL |
This field 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 |
|
|
|
RntALC_Line_Id |
numeric |
NOT NULL |
This field holds the line id which is a generated serial number |
Yes |
No |
|
|
|
RntALC_From_Cal_Period |
numeric(28,8) |
NULL |
This field holds the from value of a period |
No |
No |
|
|
|
RntALC_To_Cal_Period |
numeric(28,8) |
NULL |
This field holds the to value of a period |
No |
No |
|
|
|
RntALC_From_ParamVal |
numeric(28,8) |
NULL |
This field holds the from value of a parameter value |
No |
No |
|
|
|
RntALC_To_ParamVal |
numeric(28,8) |
NULL |
This field holds the to value of a parameter value |
No |
No |
|
|
|
RntALC_Rate_Per_UOM |
numeric(28,8) |
NULL |
This field holds the flat rate per UOM of calendar period or the flat rate per UOM of parameter |
No |
No |
|
|
|
RntALC_Charge_Per_Unit |
numeric(28,8) |
NULL |
This field holds 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)) *rental price * percent value/100 |
No |
No |
|
|
|
RntALC_Charge_For_Period |
numeric(28,8) |
NULL |
This field holds the 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)) * rental price * percent value/100 |
No |
No |
|
|
|
RntALC_Remarks |
varchar(100) |
NULL |
This field holds the remarks |
No |
No |
|
|
|
|
|||||||
|
Table Name Rnt_RntAPCD_Penalty_Charges |
|
||||||
|
|
|||||||
|
Table Comment This table stores the penalty charges defined for an Amended Rental Order |
|
||||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
|
|
RntAPCD_To_ParamVal |
numeric(28,8) |
NULL |
stores the to value of a parameter value |
No |
No |
|
|
|
RntAPCD_From_ParamVal |
numeric(28,8) |
NULL |
stores the from value of a parameter value |
No |
No |
|
|
|
RntAPCD_To_Cal_Period |
numeric(28,8) |
NULL |
stores the to value of a period |
No |
No |
|
|
|
RntAPCD_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)) * rental price * percent value/100 |
No |
No |
|
|
|
RntAPCD_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 |
|
|
|
RntAPCD_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)) *rental price * percent value/100 |
No |
No |
|
|
|
RntAPCD_Remarks |
varchar(100) |
NULL |
stores the remarks |
No |
No |
|
|
|
RntAPCD_Rnt_No |
varchar(40) |
NOT NULL |
stores the rental order number |
Yes |
Yes |
|
|
|
RntAPCD_Rnt_OUInstance |
numeric(4) |
NOT NULL |
stores the OUInstance where the rental order is created |
Yes |
Yes |
|
|
|
RntAPCD_From_Cal_Period |
numeric(28,8) |
NULL |
stores the from value of a period |
No |
No |
|
|
|
RntAPCD_Line_Id |
numeric |
NOT NULL |
stores the line id which is a generated serial number |
Yes |
No |
|
|
|
RntAPCH_Amend_No |
numeric(5) |
NOT NULL |
stores the rental order amendment number. if the RTO is not amended then 0 is stored |
Yes |
Yes |
|
|
|
RntAPCD_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 Rnt_RntAPCH_PenaltyChrg_Hdr |
|
||||||
|
|
|||||||
|
Table Comment This table stores the penalty charges header details for an Amended Rental Order |
|
||||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
|
|
RntAPCH_CBPC_Policy |
varchar(5) |
NULL |
stores the calendar based lease charges policy for the rental order. Allowed values are: F - Flat P - Percent |
No |
No |
|
|
|
RntAPCH_Comments |
varchar(255) |
NULL |
stores the penalty comments |
No |
No |
|
|
|
RntAPCH_PrmPenltyPrd_Val |
numeric(28,8) |
NULL |
stores the value of the parameter penalty period |
No |
No |
|
|
|
RntAPCH_CBPC_Basis |
varchar(5) |
NULL |
stores the calendar based charges policy for the rental order. Allowed values are: C - Cumulative P - Period |
No |
No |
|
|
|
RntAPCH_PBPC_Policy |
varchar(5) |
NULL |
stores the parameter based charges policy for the rental order. Allowed values are: F - Flat P - Percent |
No |
No |
|
|
|
RntAPCH_PBPC_Basis |
varchar(5) |
NULL |
stores the parameter based charges policy for the rental order. Allowed values are: C - Cumulative P - Period |
No |
No |
|
|
|
RntAPCH_Rnt_No |
varchar(40) |
NOT NULL |
stores the rental order number |
Yes |
Yes |
|
|
|
RntAPCH_Rnt_OUInstance |
numeric(4) |
NOT NULL |
stores the OUInstance where the rental order is created |
Yes |
Yes |
|
|
|
RntAPCH_CalPenltyPrd_Units |
varchar(10) |
NULL |
stores the UOM of the calendar penalty period |
No |
No |
|
|
|
RntAPCH_Amend_No |
numeric(5) |
NOT NULL |
stores the rental order amendment number. if the RTO is not amended then 0 is stored |
Yes |
Yes |
|
|
|
RntAPCH_CalPenltyPrd_Val |
numeric(28,8) |
NULL |
stores the value of the calendar penalty period |
No |
No |
|
|
|
|
|||||||
|
Table Name Rnt_RntASi_Rnt_Ship_Info |
|
||||||
|
|
|||||||
|
Table Comment Stores the shipping and acknowledgement information for a Rental Order |
|
||||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
|
|
RntASi_Param_Based_Chrge |
numeric(28,8) |
NULL |
stores the parameter based lease charges |
No |
No |
|
|
|
RntASi_CBased_Penalty_Chrgs |
numeric(28,8) |
NULL |
stores the calendar based penalty charges |
No |
No |
|
|
|
RntASi_Cal_Based_Chrge |
numeric(28,8) |
NULL |
stores the calendar based lease charges |
No |
No |
|
|
|
RntASi_Act_Usage |
numeric(28,8) |
NULL |
stores the actual usage of the lead param value |
No |
No |
|
|
|
RntASi_UsDef_Dtl6 |
varchar(25) |
NULL |
Stores the user defined detail 6 defined as part of acknowledgement information |
No |
No |
|
|
|
RntASi_PBased_Penalty_Chrgs |
numeric(28,8) |
NULL |
stores the parameter based penalty charges |
No |
No |
|
|
|
RntASi_UsDef_Dtl5 |
varchar(25) |
NULL |
Stores the user defined detail 5 defined as part of acknowledgement information |
No |
No |
|
|
|
RntASi_Act_Order_Value |
numeric(28,8) |
NULL |
stores the actual order value |
No |
No |
|
|
|
RntASi_UsDef_Dtl7 |
varchar(25) |
NULL |
Stores the user defined detail 7 defined as part of acknowledgement information |
No |
No |
|
|
|
RntASi_Rnt_No |
varchar(40) |
NOT NULL |
stores the rental order number |
Yes |
Yes |
|
|
|
RntASi_Amend_No |
numeric(5) |
NOT NULL |
stores the rental order amendment number. if the RTO is not amended then 0 is stored |
Yes |
Yes |
|
|
|
RntASi_Rnt_OUInstance |
numeric(4) |
NOT NULL |
stores the OUInstance where the rental order is created |
Yes |
Yes |
|
|
|
RntASi_Act_Lease_Period |
numeric(28,8) |
NULL |
stores the actual lease period |
No |
No |
|
|
|
RntASi_Comments |
varchar(150) |
NULL |
stores the acknowledgement comments |
No |
No |
|
|
|
RntASi_Ackldgmnt_RefNo |
varchar(40) |
NULL |
stores the acknowledgement number |
No |
No |
|
|
|
RntASi_Rcpt_Satisfactory |
varchar(5) |
NULL |
stores the flag to identify whether receipt of the part at the customer site is satisfactory or not Y- Yes N - No |
No |
No |
|
|
|
RntASi_Ackldgmnt_Date |
datetime |
NULL |
stores acknowledgement date |
No |
No |
|
|
|
|
|||||||
|
Table Name Rnt_RntAtmcn_Rnt_Term_Condns |
|
||||||
|
|
|||||||
|
Table Comment This table holds the Terms and Condition of an Amended Rental order document |
|
|
|||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
|
|
RntAtmcn_Rnt_OUInstance |
numeric(4) |
NOT NULL |
stores the OUInstance where the rental order is created |
Yes |
Yes |
|
|
|
RntAtmcn_Rnt_No |
varchar(40) |
NOT NULL |
stores the rental order number |
Yes |
Yes |
|
|
|
RntAtmcn_Amend_No |
numeric(5) |
NOT NULL |
stores the rental order amendment number. if the RTO is not amended then 0 is stored |
Yes |
Yes |
|
|
|
RntAtmcn_gta_refdoc_no |
varchar(40) |
NULL |
This field holds the General Terms Agreement reference document no. |
No |
No |
|
|
|
RntAtmcn_refdoc_date |
datetime |
NULL |
This field holds the General Terms Agreement reference document Date |
No |
No |
|
|
|
RntAtmcn_gta_remarks |
varchar(100) |
NULL |
This field holds the General Terms Agreement remarks |
No |
No |
|
|
|
RntAtmcn_Doc_Filename |
varchar(50) |
NULL |
Stores the attached document file name |
No |
No |
|
|
|
RNTATMCN_BILL_TO_CUSTNO |
varchar(45) |
NULL |
A valid customer defined in the customer component |
No |
No |
|
|
|
RNTATMCN_BILL_TO_CUST_OU |
numeric |
NULL |
Bill to customer OUInstance |
No |
No |
|
|
|
RntAtmcn_Bill_To_Addr_Id |
varchar(40) |
NULL |
The address id of the Bill To Customer |
No |
No |
|
|
|
RntAtmcn_Bill_To_Address |
varchar(255) |
NULL |
The address of the Bill To Customer |
No |
No |
|
|
|
RntAtmcn_BTA_ContactPerson |
varchar(80) |
NULL |
The Contact person for the Bill To Customer |
No |
No |
|
|
|
RntAtmcn_BTA_PhoneNo |
varchar(40) |
NULL |
The Phone No for the Bill To Customer |
No |
No |
|
|
|
RntAtmcn_BTA_Email |
varchar(40) |
NULL |
The Email Id for the Bill To Customer |
No |
No |
|
|
|
RntAtmcn_BTA_FaxNo |
varchar(40) |
NULL |
The Fax No for the Bill To Customer |
No |
No |
|
|
|
RNTATMCN_ADV_APPLICABLE |
varchar(5) |
NULL |
This field holds the advance payable flag of the Rental order document. List of values (Y)es (N)o |
No |
No |
|
|
|
RntAtmcn_advance_paydate |
datetime |
NULL |
This field holds the advance payable date. If advance payable flag is ’yes’ then this is mandatory |
No |
No |
|
|
|
RntAtmcn_advance_perc |
numeric(28) |
NULL |
This field holds the advance percentage. |
No |
No |
|
|
|
RntAtmcn_advance_perc_on |
varchar(5) |
NULL |
This field holds the advance percentage on of the rental order document. List of values 1. Basic Value 2. Total Value |
No |
No |
|
|
|
RntAtmcn_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 |
|
|
|
RntAtmcn_advance_tol_perc |
numeric(28) |
NULL |
This field holds the advance tolerance percentage. |
No |
No |
|
|
|
RntAtmcn_payterm_code |
varchar(25) |
NULL |
This field holds the Unique identifier for the Pay term |
No |
No |
|
|
|
RntAtmcn_Exchg_Rate |
varchar(5) |
NULL |
stores the flag whether to consider the exchange rate as of order date or as of invoice date OD - As of order date ID - As of invoice date |
No |
No |
|
|
|
RntAtmcn_Rcpt_Mode |
varchar(5) |
NULL |
stores the various receipt modes fetched from Bank Cash Master |
No |
No |
|
|
|
RntAtmcn_Rcpt_Method |
varchar(5) |
NULL |
stores the flags for the receipt method. Allowed values are: REG - Regular ESR - ESR ESRP - ESR Plus LSV - LSV SB - Specific Bank |
No |
No |
|
|
|
RntAtmcn_Act_On_Nonpaymt |
varchar(5) |
NULL |
stores the flag for the action to be taken on non payment. values: HOP - Hold Order Processing HRP - Hold Release of Part RRP - Request Return of Part |
No |
No |
|
|
|
RntAtmcn_ddcharges_borneby |
varchar(5) |
NULL |
This field holds the DD charges borne by of the rental order document. List of values CU - customer SE - self N - None |
No |
No |
|
|
|
RNTATMCN_PAYMENT_NOTES |
varchar(2000) |
NULL |
This field holds the Payment notes of the rental order documents. |
No |
No |
|
|
|
RntAtmcn_insurance_liability |
varchar(5) |
NULL |
This field holds insurance liability of the RTO document List of values are CU - customer SE - self N - none |
No |
No |
|
|
|
RntAtmcn_insurance_amt |
numeric(28,8) |
NULL |
This field holds the insurance amount of the rental order document. |
No |
No |
|
|
|
RntAtmcn_insurance_terms |
varchar(150) |
NULL |
This field holds the insurance term of rental order document. |
No |
No |
|
|
|
RntAtmcn_ShipTo_CustNo |
varchar(45) |
NULL |
A valid customer defined in the customer component |
No |
No |
|
|
|
RntAtmcn_Ship_To_Cust_OU |
numeric |
NULL |
Ship to customer OUInstance |
No |
No |
|
|
|
RntAtmcn_Ship_To_Addr_Id |
varchar(40) |
NULL |
The address id of the Ship To Customer |
No |
No |
|
|
|
RntAtmcn_STA_ContactPerson |
varchar(80) |
NULL |
The Contact person for the Ship To Customer |
No |
No |
|
|
|
RntAtmcn_Ship_To_Address |
varchar(255) |
NULL |
The address of the Ship To Customer |
No |
No |
|
|
|
RntAtmcn_STA_PhoneNo |
varchar(40) |
NULL |
The Phone No for the Ship To Customer |
No |
No |
|
|
|
RntAtmcn_STA_Email |
varchar(40) |
NULL |
The Email No for the Ship To Customer |
No |
No |
|
|
|
RntAtmcn_STA_FaxNo |
varchar(80) |
NULL |
The Fax No for the Ship To Customer |
No |
No |
|
|
|
RntAtmcn_pkg_code |
varchar(25) |
NULL |
This field holds the packaging code defined for rental order in the logistics common master. |
No |
No |
|
|
|
RntAtmcn_packaging_notes |
varchar(2000) |
NULL |
This field holds the packaging notes |
No |
No |
|
|
|
RntAtmcn_inco_term |
varchar(150) |
NULL |
This field holds the INCO term of the rental order document defined in the logistics common master.. |
No |
No |
|
|
|
RntAtmcn_ship_by |
varchar(25) |
NULL |
This field holds the shipping methods of the rental order document defined in the logistics common master. |
No |
No |
|
|
|
RntAtmcn_port_of_dep |
varchar(32) |
NULL |
This field holds the port of departure |
No |
No |
|
|
|
RntAtmcn_delivery_point |
varchar(32) |
NULL |
This field holds the delivery point of the rental order document. |
No |
No |
|
|
|
RNTATMCN_CARRIER_NO |
varchar(20) |
NULL |
This field holds the Carrier number for Rental order |
No |
No |
|
|
|
RntAtmcn_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 |
|
|
|
RntAtmcn_freight_billable |
varchar(5) |
NULL |
holds the flag whether the freight is billable or not. Values : Y - Yes N - No |
No |
No |
|
|
|
RntAtmcn_freight_amount |
numeric(28,8) |
NULL |
holds the value of the freight amount |
No |
No |
|
|
|
RntAtmcn_shipping_notes |
varchar(2000) |
NULL |
This field holds the shipping notes |
No |
No |
|
|
|
RntAtmcn_Ret_To_Loc |
varchar(5) |
NULL |
stores the component admin OUs with which rental order is interacting |
No |
No |
|
|
|
RntAtmcn_Warehouse_No |
varchar(10) |
NULL |
stores the warehouse number |
No |
No |
|
|
|
RntAtmcn_Ret_Carrier_No |
varchar(20) |
NULL |
stores the carrier number by which the part will be returned |
No |
No |
|
|
|
RntAtmcn_Ret_ShipBy |
varchar(25) |
NULL |
This field holds the shipping methods of the rental order document defined in the logistics common master. |
No |
No |
|
|
|
RntAtmcn_RetFreightpayble |
varchar(5) |
NULL |
stores the flag whether freight is payable or not. Values: Y - Yes N - No |
No |
No |
|
|
|
RntAtmcn_Shipping_Payment |
varchar(25) |
NULL |
This field holds the shipping payment methods of the rental order document defined in the logistics common master. |
No |
No |
|
|
|
RntAtmcn_Ret_Pack_Notes |
varchar(2000) |
NULL |
stores the packaging notes |
No |
No |
|
|
|
RntAtmcn_Ret_Ship_Notes |
varchar(2000) |
NULL |
stores the shipping notes |
No |
No |
|
|
|
RntAtmcn_Rnt_Detail2 |
varchar(25) |
NULL |
stores the used defined details |
No |
No |
|
|
|
RntAtmcn_Rnt_Detail3 |
varchar(25) |
NULL |
stores the used defined details |
No |
No |
|
|
|
RntAtmcn_Rnt_Detail4 |
varchar(25) |
NULL |
stores the used defined details |
No |
No |
|
|
|
RntAtmcn_Rnt_Option2 |
varchar(25) |
NULL |
stores the user defined options defined in the logistics common master |
No |
No |
|
|
|
RntAtmcn_Rnt_Option3 |
varchar(25) |
NULL |
stores the user defined options defined in the logistics common master |
No |
No |
|
|
|
RntAtmcn_Rnt_Option4 |
varchar(25) |
NULL |
stores the user defined options defined in the logistics common master |
No |
No |
|
|
|
|
|||||||
|
Table Name Rnt_Rntdtcd_Rnt_Doc_Tcd |
|
||||||
|
|
|||||||
|
Table Comment This table holds the Document TCD details of Rental order. |
|
||||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
|
|
Rntdtcd_Rnt_OUInstance |
numeric(4) |
NOT NULL |
stores the OU Instance where the rental order is created |
Yes |
Yes |
|
|
|
Rntdtcd_Rnt_No |
varchar(40) |
NOT NULL |
stores the rental order number |
Yes |
Yes |
|
|
|
Rntdtcd_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 |
|
|
|
Rntdtcd_Line_no |
numeric |
NOT NULL |
This field holds the Unique identifier number for the TCD of the rental order |
Yes |
No |
|
|
|
Rntdtcd_tcd_code |
varchar(25) |
NOT NULL |
This field holds the Unique identifier for the TCD |
No |
No |
|
|
|
Rntdtcd_tcd_variant |
varchar(25) |
NOT NULL |
This field holds the TCD variant for the TCD code. |
No |
No |
|
|
|
Rntdtcd_user_seq |
numeric |
NULL |
holds the sequence number as entered by the user for the TCD |
No |
No |
|
|
|
Rntdtcd_tcd_ou |
numeric |
NULL |
stores the TCD OUInstance |
No |
No |
|
|
|
Rntdtcd_tcd_rate |
numeric(28,8) |
NULL |
TCD rate for the TCD code and the variant . this should not be changed for TCD basis -- Percentage. |
No |
No |
|
|
|
Rntdtcd_tcd_amount |
numeric(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 |
|
|
|
Rntdtcd_pay_currency |
varchar(20) |
NULL |
This field holds the Transaction currency |
No |
No |
|
|
|
Rntdtcd_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 |
|
|
|
Rntdtcd_pay_to_supp_ou |
numeric |
NULL |
Stores the pay to supplier OUInstance |
No |
No |
|
|
|
Rntdtcd_Exchg_Rate |
numeric(28,8) |
NULL |
Holds the exchange rate between the document currency and the payment currency |
No |
No |
|
|
|
|
|||||||
|
Table Name Rnt_RntHdr_Rental_Order_Hdr |
|
||||||
|
|
|||||||
|
Table Comment This table holds the Rental order information |
|
||||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
|
|
RntHdr_Rnt_OUInstance |
numeric(4) |
NOT NULL |
stores the OUInstance where the rental order is created |
Yes |
No |
|
|
|
RntHdr_Rnt_No |
varchar(40) |
NOT NULL |
stores the rental order number |
Yes |
No |
|
|
|
RntHdr_Amend_No |
numeric(5) |
NULL |
stores the rental order amendment number. if the RTO is not amended then 0 is stored |
No |
No |
|
|
|
RntHdr_Rnt_Date |
datetime |
NULL |
stores the document date |
No |
No |
|
|
|
RntHdr_Rnt_Status |
varchar(5) |
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 |
|
|
|
RntHdr_Part_No |
varchar(40) |
NULL |
stores the part no on which the rental order is raised |
No |
No |
|
|
|
RntHdr_Prt_Srl_No |
varchar(40) |
NULL |
stores the part serial no |
No |
No |
|
|
|
RntHdr_Part_OUInstance |
numeric(4) |
NULL |
stores the part OUinstance |
No |
No |
|
|
|
RntHdr_Cust_Code |
varchar(40) |
NULL |
stores the customer code |
No |
No |
|
|
|
RntHdr_Cust_Created_OU |
numeric(4) |
NULL |
stores the OUInstance where the customer is created |
No |
No |
|
|
|
RntHdr_Cust_OU |
numeric(4) |
NULL |
stores the customer OUinstance |
No |
No |
|
|
|
RntHdr_Rnt_Currency |
varchar(20) |
NULL |
stores the document/order currency |
No |
No |
|
|
|
RntHdr_Exchange_Rate |
numeric(28,8) |
NULL |
stores the exchange rate between the document currency and base currency |
No |
No |
|
|
|
RntHdr_Base_Currency |
varchar(20) |
NULL |
stores the base currency |
No |
No |
|
|
|
RntHdr_User_Status |
varchar(25) |
NULL |
stores the user defined status |
No |
No |
|
|
|
RntHdr_Rnt_Cat |
varchar(25) |
NULL |
stores the rental order category defined in logistics common master |
No |
No |
|
|
|
RntHdr_Rnt_Priority |
varchar(20) |
NULL |
stores the rental order priority |
No |
No |
|
|
|
RntHdr_AC_RegNo |
varchar(30) |
NULL |
stores the Air craft registration number |
No |
No |
|
|
|
RntHdr_Contact_Person |
varchar(80) |
NULL |
Stores the contact person for the customer |
No |
No |
|
|
|
RntHdr_Cust_Phone_No |
varchar(18) |
NULL |
stores the contact person’s phone no |
No |
No |
|
|
|
RntHdr_Cust_Fax_No |
varchar(40) |
NULL |
stores the contact person’s fax no |
No |
No |
|
|
|
RntHdr_Cust_Email |
varchar(60) |
NULL |
stores the contact person’s email ID |
No |
No |
|
|
|
RntHdr_Cust_Address |
varchar(255) |
NULL |
stores the contact person’s address |
No |
No |
|
|
|
RntHdr_Manf_PartNo |
varchar(40) |
NULL |
stores the manufacturer’s part number |
No |
No |
|
|
|
RntHdr_Component_No |
varchar(90) |
NULL |
stores the component no |
No |
No |
|
|
|
RntHdr_Prt_Condition |
varchar(25) |
NULL |
stores the condition of the manufacturer part number |
No |
No |
|
|
|
RntHdr_Lot_No |
varchar(18) |
NULL |
stores the lot number of the manuf. part number |
No |
No |
|
|
|
RntHdr_Location |
varchar(256) |
NULL |
stores the location of the warehouse from where the part is to be rented |
No |
No |
|
|
|
RntHdr_WH_No |
varchar(10) |
NULL |
stores the warehouse number from where the part is to be rented. This is the outcome of picking priority logic |
No |
No |
|
|
|
RntHdr_Quantity |
numeric(28,8) |
NULL |
stores the order quantity |
No |
No |
|
|
|
RntHdr_Recvd_Qty |
numeric(28,8) |
NULL |
stores the received quantity of rented out part updated by rental receipt |
No |
No |
|
|
|
RntHdr_Agmt_No |
varchar(40) |
NULL |
stores the agreement number |
No |
No |
|
|
|
RntHdr_OfferNo |
varchar(40) |
NULL |
stores the offer number |
No |
No |
|
|
|
RntHdr_Ref_Doc |
varchar(25) |
NULL |
stores the reference document |
No |
No |
|
|
|
RntHdr_Ref_Doc_No |
varchar(40) |
NULL |
stores the reference document number |
No |
No |
|
|
|
RntHdr_Lease_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 |
|
|
|
RntHdr_Penalty_Applicable |
varchar(5) |
NULL |
stores the flag whether penalty applicable or not. Values are: Y - Yes N - No |
No |
No |
|
|
|
RntHdr_TCD_Applicable |
varchar(5) |
NULL |
stores the flag whether TCD applicable or not. Values are: Y - Yes N - No |
No |
No |
|
|
|
RntHdr_Date_Reqd |
datetime |
NULL |
stores the date from when the lease begins |
No |
No |
|
|
|
RntHdr_CalLeasePeriod_Val |
numeric(6) |
NULL |
stores the value of the calendar lease period |
No |
No |
|
|
|
RntHdr_CalLeasPeriod_Units |
varchar(5) |
NULL |
stores the UOM of the calendar lease period. Allowed values are: D - Days W - Weeks M - Months |
No |
No |
|
|
|
RntHdr_ParLeasePeriod_Val |
numeric(6) |
NULL |
stores the value of the parameter lease period |
No |
No |
|
|
|
RntHdr_Lead_Param |
varchar(40) |
NULL |
stores the lead parameter of the rental order part number |
No |
No |
|
|
|
RntHdr_Lead_Param_Uom |
varchar(10) |
NULL |
stores the UOM of the lead parameter |
No |
No |
|
|
|
RntHdr_LP_TSN |
numeric(28,8) |
NULL |
stores the time since new value of the lead parameter for the rental part number |
No |
No |
|
|
|
RntHdr_LP_TSO |
numeric(28,8) |
NULL |
stores the time since overhaul value of the lead parameter for the rental part number |
No |
No |
|
|
|
RntHdr_LP_TSR |
numeric(28,8) |
NULL |
stores the time since repair value of the lead parameter for the rental part number |
No |
No |
|
|
|
RntHdr_LP_TSI |
numeric(28,8) |
NULL |
stores the time since inspection value of the lead parameter for the rental part number |
No |
No |
|
|
|
RntHdr_LP_TSV |
numeric(28,8) |
NULL |
stores the time since shop visit value of the lead parameter for the rental part number |
No |
No |
|
|
|
RntHdr_Admin_Chrgs_Policy |
varchar(5) |
NULL |
stores the administrative charges policy for the rental order. Allowed values are: F - Flat P - Percent |
No |
No |
|
|
|
RntHdr_CBLC_Policy |
varchar(5) |
NULL |
stores the calendar based lease charges policy for the rental order. Allowed values are: F - Flat P - Percent |
No |
No |
|
|
|
RntHdr_PBLC_Policy |
varchar(5) |
NULL |
stores the parameter based charges policy for the rental order. Allowed values are: F - Flat P - Percent |
No |
No |
|
|
|
RntHdr_CBLC_Basis |
varchar(5) |
NULL |
stores the calendar based charges policy for the rental order. Allowed values are: C - Cumulative P - Period |
No |
No |
|
|
|
RntHdr_PBLC_Basis |
varchar(5) |
NULL |
stores the parameter based charges policy for the rental order. Allowed values are: C - Cumulative P - Period |
No |
No |
|
|
|
RntHdr_BasePrice |
numeric(28,8) |
NULL |
stores the base price of the part |
No |
No |
|
|
|
RntHdr_Markup_Factor |
numeric(28,8) |
NULL |
stores the mark up factor |
No |
No |
|
|
|
RntHdr_Admin_Chrgs_In_Perc |
numeric(28,8) |
NULL |
stores the percent value for the administrative charges to be applied on rental price |
No |
No |
|
|
|
RntHdr_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 |
|
|
|
RntHdr_Lease_Charges |
numeric(28,8) |
NULL |
stores the lease charges. it is either the sum of the calendar based lease charges or sum of parameter based lease charges or sum of both calendar and parameter based lease charges. |
No |
No |
|
|
|
RntHdr_Addnl_Charges |
numeric(28,8) |
NULL |
stores the administrative charges. It is the total sum of the TCD amounts |
No |
No |
|
|
|
RntHdr_Rnt_Detail1 |
varchar(25) |
NULL |
stores the user defined detail 1 |
No |
No |
|
|
|
RntHdr_Rnt_Option1 |
varchar(30) |
NULL |
stores the user defined option 1 |
No |
No |
|
|
|
RntHdr_Hdr_Remarks |
varchar(100) |
NULL |
stores the remarks for the rental order |
No |
No |
|
|
|
RntHdr_Doc_Filename |
varchar(50) |
NULL |
stores the document file name attached to the rental order |
No |
No |
|
|
|
RntHdr_TCD_Comments |
varchar(255) |
NULL |
stores the TCD comments for the rental order |
No |
No |
|
|
|
RntHdr_RP_Tcd_Amt |
numeric(28,8) |
NULL |
stores the Tcd amount calculated on rental price |
No |
No |
|
|
|
RntHdr_AC_Tcd_Amt |
numeric(28,8) |
NULL |
stores the Tcd amount calculated on administrative charges |
No |
No |
|
|
|
RntHdr_LC_Tcd_Amt |
numeric(28,8) |
NULL |
stores the Tcd amount calculated on lease charges |
No |
No |
|
|
|
RntHdr_RC_Tcd_Amt |
numeric(28,8) |
NULL |
stores the Tcd amount calculated on rental charges |
No |
No |
|
|
|
RntHdr_Total_Rental_Val |
numeric(28,8) |
NULL |
stores the total rental value which the addition of Rental charges and Tcd Value |
No |
No |
|
|
|
RntHdr_Canc_Reason |
varchar(255) |
NULL |
stores the reason for cancellation of rental order |
No |
No |
|
|
|
RntHdr_Ret_Reason |
varchar(255) |
NULL |
stores the reason for returning a rental order |
No |
No |
|
|
|
RntHdr_Num_Type_Num |
varchar(5) |
NULL |
stores the numbering type number for a rental order |
No |
No |
|
|
|
RntHdr_Wf_Doc_Key |
varchar(128) |
NULL |
stores the doc key of a rental order for work flow purpose |
No |
No |
|
|
|
RntHdr_Stage |
varchar(10) |
NULL |
stores the stage of the rental order. This is an intermediate state fetched from work flow while the documnet goes through different stages of authorization |
No |
No |
|
|
|
RntHdr_Authorised_Date |
datetime |
NULL |
stores the rental order authorization date |
No |
No |
|
|
|
RntHdr_Authorised_By |
varchar(30) |
NULL |
stores the user who authorized the rental order |
No |
No |
|
|
|
RntHdr_Amendment_Date |
datetime |
NULL |
stores the rental order amendment date |
No |
No |
|
|
|
RntHdr_Amendment_By |
varchar(30) |
NULL |
stores the user who amended the rental order |
No |
No |
|
|
|
RntHdr_Created_By |
varchar(30) |
NULL |
stores the user who created the rental order |
No |
No |
|
|
|
RntHdr_Created_Date |
datetime |
NULL |
stores the rental order created date |
No |
No |
|
|
|
RntHdr_Modified_By |
varchar(30) |
NULL |
stores the user who modified the rental order |
No |
No |
|
|
|
RntHdr_Modified_Date |
datetime |
NULL |
stores the rental order modified date |
No |
No |
|
|
|
RntHdr_Timestamp |
numeric(20) |
NULL |
stores the timestamp. Initial value is 1. incremented by 1 everytime the record is modified |
No |
No |
|
|
|
RntHdr_Zone |
varchar(10) |
NULL |
stores the zone number corresponding to the warehouse number from where the part is to be rented. This is the outcome of picking priority logic |
No |
No |
|
|
|
RntHdr_Bin |
varchar(10) |
NULL |
stores the bin number corresponding to the zone number from where the part is to be rented. This is the outcome of picking priority logic |
No |
No |
|
|
|
RntHdr_Pen_Isu_Qty |
numeric(28,2) |
NULL |
Stores the pending quantity of rental order to be issued |
No |
No |
|
|
|
RntHdr_Alt_PartNo |
varchar(40) |
NULL |
Alternate part for the rental order part no. |
No |
No |
|
|
|
RNTHDR_MIN_ISSDT |
datetime |
NULL |
stores the issue document date |
No |
No |
|
|
|
RntHdr_Alt_PartNo_OU |
numeric(10) |
NULL |
stores the alternate part number’s created OUInstance |
No |
No |
|
|
|
RntHdr_Def_Fin_Book |
varchar(32) |
NULL |
Stores the default Finace Book. |
No |
No |
|
|
|
RntHdr_Account_code |
varchar(32) |
NULL |
To store the Loan Suspense Account. |
No |
No |
|
|
|
RntHdr_Account_Type |
char(5) |
NULL |
This field holds the Account type |
No |
No |
|
|
|
|
|||||||
|
Table Name Rnt_RntISD_Issue_Doc_Det |
|
||||||
|
|
|||||||
|
Table Comment stores the details of the issue documents issued against the Rental Order. |
|
||||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
|
|
RntISD_Rnt_OUInstance |
numeric(4) |
NOT NULL |
stores the OUInstance where the rental order is created |
No |
Yes |
|
|
|
RntISD_Rnt_No |
varchar(40) |
NOT NULL |
stores the rental order number |
No |
Yes |
|
|
|
RntISD_Line_Id |
numeric |
NOT NULL |
stores the serial no generated for each record |
No |
No |
|
|
|
RntISD_Issue_Doc_OU |
numeric |
NULL |
stores the Ou instance where the issue document is created |
No |
No |
|
|
|
RntISD_Issue_Doc_No |
varchar(40) |
NULL |
stores the issue document number |
No |
No |
|
|
|
RntISD_Issue_Date |
datetime |
NULL |
stores the issue document date |
No |
No |
|
|
|
RntISD_Ship_Date |
datetime |
NULL |
stores the shipment date |
No |
No |
|
|
|
RntISD_DelNote_Date |
datetime |
NULL |
stores the delivery note date |
No |
No |
|
|
|
RntISD_WayBill_Date |
datetime |
NULL |
stores the way bill date |
No |
No |
|
|
|
RntISD_Issue_Qty |
numeric |
NULL |
stores the quantity issued against the issue document |
No |
No |
|
|
|
RNTISD_PENDING_REC_QTY |
numeric |
NULL |
Stores the pending quantity of rental order to be received |
No |
No |
|
|
|
|
|||||||
|
Table Name Rnt_RntLC_Lease_Charges |
|
||||||
|
|
|||||||
|
Table Comment This Table holds the calendar based and parameter based lease charges for a rental order document |
| ||||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
|
|
RntLC_Rnt_OUInstance |
numeric(4) |
NOT NULL |
stores the OUInstance where the rental order is created |
Yes |
Yes |
|
|
|
RntLC_Rnt_No |
varchar(40) |
NOT NULL |
stores the rental order number |
Yes |
Yes |
|
|
|
RntLC_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 |
|
|
|
RntLC_Line_Id |
numeric(6) |
NOT NULL |
stores the line id which is a generated serial number |
Yes |
No |
|
|
|
RntLC_From_Cal_Period |
numeric(6) |
NULL |
stores the from value of a period |
No |
No |
|
|
|
RntLC_To_Cal_Period |
numeric(6) |
NULL |
stores the to value of a period |
No |
No |
|
|
|
RntLC_From_ParamVal |
numeric(6) |
NULL |
stores the from value of a parameter value |
No |
No |
|
|
|
RntLC_To_ParamVal |
numeric(6) |
NULL |
stores the to value of a parameter value |
No |
No |
|
|
|
RntLC_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 |
|
|
|
RntLC_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)) *rental price * percent value/100 |
No |
No |
|
|
|
RntLC_Charge_For_Period |
numeric(28,8) |
NULL |
stores the 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)) * rental price * percent value/100 |
No |
No |
|
|
|
RntLC_Remarks |
varchar(100) |
NULL |
stores the remarks |
No |
No |
|
|
|
|
|||||||
|
Table Name Rnt_RntPCD_Penalty_Charges |
|
||||||
|
|
|||||||
|
Table Comment This table stores the penalty charges defined for a Rental Order |
|
||||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
|
|
RntPCD_Rnt_OUInstance |
numeric(4) |
NOT NULL |
stores the OUInstance where the rental order is created |
Yes |
Yes |
|
|
|
RntPCD_Rnt_No |
varchar(40) |
NOT NULL |
stores the rental order number |
Yes |
Yes |
|
|
|
RntPCD_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 |
|
|
|
RntPCD_Line_Id |
numeric(6) |
NOT NULL |
stores the line id which is a generated serial number |
Yes |
No |
|
|
|
RntPCD_From_Cal_Period |
numeric(6) |
NULL |
stores the from value of a period |
No |
No |
|
|
|
RntPCD_To_Cal_Period |
numeric(6) |
NULL |
stores the to value of a period |
No |
No |
|
|
|
RntPCD_From_ParamVal |
numeric(6) |
NULL |
stores the from value of a parameter value |
No |
No |
|
|
|
RntPCD_To_ParamVal |
numeric(6) |
NULL |
stores the to value of a parameter value |
No |
No |
|
|
|
RntPCD_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 |
|
|
|
RntPCD_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)) *rental price * percent value/100 |
No |
No |
|
|
|
RntPCD_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)) * rental price * percent value/100 |
No |
No |
|
|
|
RntPCD_Remarks |
varchar(100) |
NULL |
stores the remarks |
No |
No |
|
|
|
|
|||||||
|
Table Name Rnt_RntPCH_Penalty_Chrg_Hdr |
|
||||||
|
|
|||||||
|
Table Comment This table stores the penalty charges header details for a Rental Order |
|
||||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
|
|
RntPCH_Rnt_OUInstance |
numeric(4) |
NOT NULL |
stores the OUInstance where the rental order is created |
Yes |
Yes |
|
|
|
RntPCH_Rnt_No |
varchar(40) |
NOT NULL |
stores the rental order number |
Yes |
Yes |
|
|
|
RntPCH_CalPenltyPrd_Val |
numeric(6) |
NULL |
stores the value of the calendar penalty period |
No |
No |
|
|
|
RntPCH_CalPenltyPrd_Units |
varchar(5) |
NULL |
stores the UOM of the calendar penalty period |
No |
No |
|
|
|
RntPCH_PrmPenltyPrd_Val |
numeric(6) |
NULL |
stores the value of the parameter penalty period |
No |
No |
|
|
|
RntPCH_Comments |
varchar(255) |
NULL |
stores the penalty comments |
No |
No |
|
|
|
RntPCH_CBPC_Policy |
varchar(5) |
NULL |
stores the calendar based lease charges policy for the rental order. Allowed values are: F - Flat P - Percent |
No |
No |
|
|
|
RntPCH_CBPC_Basis |
varchar(5) |
NULL |
stores the calendar based charges policy for the rental order. Allowed values are: C - Cumulative P - Period |
No |
No |
|
|
|
RntPCH_PBPC_Policy |
varchar(5) |
NULL |
stores the parameter based charges policy for the rental order. Allowed values are: F - Flat P - Percent |
No |
No |
|
|
|
RntPCH_PBPC_Basis |
varchar(5) |
NULL |
stores the parameter based charges policy for the rental order. Allowed values are: C - Cumulative P - Period |
No |
No |
|
|
|
|
|||||||
|
Table Name Rnt_RntPrm_Parameter_dtl |
|
||||||
|
|
|||||||
|
Table Comment This table is to hold Parameter Details for the Rental Order. |
|
||||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
|
|
RntPrm_Componentname |
varchar(80) |
NOT NULL |
This field holds the Name of the component. |
Yes |
No |
|
|
|
RntPrm_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 |
|
|
|
RntPrm_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 |
|
|
|
RntPrm_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 |
|
|
|
RntPrm_Langid |
numeric(4) |
NOT NULL |
Language id. This is the language id of the record. |
Yes |
No |
|
|
|
RntPrm_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 |
|
|
|
RntPrm_Sortby |
numeric(26) |
NULL |
This field holds the default sort by code |
No |
No |
|
|
|
RntPrm_Createddate |
datetime |
NULL |
This field holds the record created date for auditing purpose. |
No |
No |
|
|
|
|
|||||||
|
Table Name Rnt_RntSi_Rnt_Ship_Info |
|
||||||
|
|
|||||||
|
Table Comment Stores the shipping and acknowledgement information for a Rental Order |
|
||||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
|
|
RntSi_Rnt_OUInstance |
numeric(4) |
NOT NULL |
stores the OUInstance where the rental order is created |
Yes |
Yes |
|
|
|
RntSi_Rnt_No |
varchar(40) |
NOT NULL |
stores the rental order number |
Yes |
Yes |
|
|
|
RntSi_Ackldgmnt_RefNo |
|
NULL |
stores the acknowledgement number |
No |
No |
|
|
|
RntSi_Ackldgmnt_Date |
datetime |
NULL |
stores acknowledgement date |
No |
No |
|
|
|
RntSi_Rcpt_Satisfactory |
varchar(5) |
NULL |
stores the flag to identify whether receipt of the part at the customer site is satisfactory or not Y- Yes N - No |
No |
No |
|
|
|
RntSi_Comments |
varchar(150) |
NULL |
stores the acknowledgement comments |
No |
No |
|
|
|
RntSi_Act_Lease_Period |
numeric(6) |
NULL |
stores the actual lease period |
No |
No |
|
|
|
RntSi_Act_Usage |
numeric(6) |
NULL |
stores the actual usage of the lead param value |
No |
No |
|
|
|
RntSi_Cal_Based_Chrge |
numeric(28,8) |
NULL |
stores the calendar based lease charges |
No |
No |
|
|
|
RntSi_Param_Based_Chrge |
numeric(28,8) |
NULL |
stores the parameter based lease charges |
No |
No |
|
|
|
RntSi_CBased_Penalty_Chrgs |
numeric(28,8) |
NULL |
stores the calendar based penalty charges |
No |
No |
|
|
|
RntSi_PBased_Penalty_Chrgs |
numeric(28,8) |
NULL |
stores the parameter based penalty charges |
No |
No |
|
|
|
RntSi_Act_Order_Value |
numeric(28,8) |
NULL |
stores the actual order value |
No |
No |
|
|
|
RntSi_UsDef_Dtl5 |
varchar(25) |
NULL |
Stores the user defined detail 5 defined as part of acknowledgement information |
No |
No |
|
|
|
RntSi_UsDef_Dtl6 |
varchar(25) |
NULL |
Stores the user defined detail 6 defined as part of acknowledgement information |
No |
No |
|
|
|
RntSi_UsDef_Dtl7 |
varchar(25) |
NULL |
Stores the user defined detail 7 defined as part of acknowledgement information |
No |
No |
|
|
|
|
|||||||
|
Table Name Rnt_RntSopt_SetOptions_Info |
|
||||||
|
|
|||||||
|
Table Comment This table stores the set options information for Rental Order |
|
||||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
|
|
RntSopt_Rnt_OUInstance |
numeric(4) |
NOT NULL |
stores the OUInstance |
Yes |
No |
|
|
|
RntSopt_PrtMap_in_CustMst |
varchar(5) |
NULL |
Holds the flag whether rental part mapping in customer master is mandatory or not Allowed values: M - Mandatory N - NonMandatory |
No |
No |
|
|
|
RntSopt_PrtType_Allowed |
varchar(5) |
NULL |
This field stores the flag for part types allowed on which a rental order can be raised. There can be 3 values allowed: 1. Component - C 2. Others - O 3. All - A |
No |
No |
|
|
|
RntSopt_AllowRot_NHA_Rnt |
varchar(5) |
NULL |
Holds the flag whether to allow rotable in next higher assembly for rental order Allowed values: Y - Yes N - No |
No |
No |
|
|
|
RntSopt_Enf_MinStkRule |
varchar(5) |
NULL |
Holds the flag whether minimum stock rule is to be enforced or not Allowed values: Y - Yes N - No |
No |
No |
|
|
|
RntSopt_Allow_AltPrt_Issue |
varchar(5) |
NULL |
This field holds the flag whether it is allowed to issue an alternate part. The values are: Y - Yes N - No |
No |
No |
|
|
|
RntSopt_Allow_AltPrt_Cond |
varchar(5) |
NULL |
Holds the flag whether to allow alternate part condition or not. Allowed Values: Y - Yes N - No |
No |
No |
|
|
|
RntSopt_Allow_AltSrl_Issue |
varchar(5) |
NULL |
This field holds the flag whether it is allowed to issue an alternate serial number. The values are: Y - Yes N - No |
No |
No |
|
|
|
RntSopt_Charge_Calc_Prd |
varchar(5) |
NULL |
This field holds the value applicable as the period for charge calculation. Allowed values are: PD - Part Issue to Receipt Date CD - Customer Receipt to Ship Date |
No |
No |
|
|
|
RntSopt_Rnt_Baseprice |
varchar(5) |
NULL |
Holds the flags the for the basis for the rental order base price Allowed Values: SC - Standard Cost SSP - Standard Sales Price PPL - Part Price Lis ENT - Enterable |
No |
No |
|
|
|
RntSopt_Allow_Edit_BP |
varchar(5) |
NULL |
Holds the flag whether to allow editable base price or not Allowed Values: Y - Yes N - No |
No |
No |
|
|
|
RntSopt_Def_Markup_Fac |
numeric(28,8) |
NULL |
This field holds the default markup factor used to calculate rental price |
No |
No |
|
|
|
RntSopt_Allow_EditMfactor |
varchar(5) |
NULL |
Holds the flag whether to allow editable mark up facor or not Allowed Values: Y - Yes N - No |
No |
No |
|
|
|
RntSopt_Allow_Diff_RetLoc |
varchar(5) |
NULL |
This field holds the flag whether different return location is allowed or not. The values are: Y - Yes N - No |
No |
No |
|
|
|
RntSopt_Created_By |
varchar(30) |
NULL |
Holds the username who created the record |
No |
No |
|
|
|
RntSopt_Created_Date |
datetime |
NULL |
Holds the date on which the record is created |
No |
No |
|
|
|
RntSopt_Modified_By |
varchar(30) |
NULL |
Holds the username who modified the record |
No |
No |
|
|
|
RntSopt_Modified_Date |
datetime |
NULL |
Holds the date on which the record is modified |
No |
No |
|
|
|
RntSopt_Timestamp |
numeric(20) |
NULL |
stores the timestamp. Initial value is 1. Incremented by 1 every time a modification is done |
No |
No |
|
|
|
|
|||||||
|
Table Name Rnt_Rnttmcn_Rnt_Term_Condns |
|
||||||
|
|
|||||||
|
Table Comment This table holds the Terms and Condition of Rental order document |
|
||||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
|
|
Rnttmcn_Rnt_OUInstance |
numeric(4) |
NOT NULL |
stores the OUInstance where the rental order is created |
Yes |
Yes |
|
|
|
Rnttmcn_Rnt_No |
varchar(40) |
NOT NULL |
stores the rental order number |
Yes |
Yes |
|
|
|
Rnttmcn_gta_refdoc_no |
varchar(40) |
NULL |
This field holds the General Terms Agreement reference document no. |
No |
No |
|
|
|
Rnttmcn_refdoc_date |
datetime |
NULL |
This field holds the General Terms Agreement reference document Date |
No |
No |
|
|
|
Rnttmcn_gta_remarks |
varchar(100) |
NULL |
This field holds the General Terms Agreement remarks |
No |
No |
|
|
|
Rnttmcn_Doc_Filename |
varchar(50) |
NULL |
Stores the attached document file name |
No |
No |
|
|
|
Rnttmcn_Bill_To_CustNo |
varchar(45) |
NULL |
A valid customer defined in the customer component |
No |
No |
|
|
|
Rnttmcn_Bill_To_Cust_OU |
numeric |
NULL |
Bill to customer OUInstance |
No |
No |
|
|
|
Rnttmcn_Bill_To_Addr_Id |
varchar(40) |
NULL |
The address id of the Bill To Customer |
No |
No |
|
|
|
Rnttmcn_Bill_To_Address |
varchar(255) |
NULL |
The address of the Bill To Customer |
No |
No |
|
|
|
Rnttmcn_BTA_ContactPerson |
varchar(80) |
NULL |
The Contact person for the Bill To Customer |
No |
No |
|
|
|
Rnttmcn_BTA_PhoneNo |
varchar(40) |
NULL |
The Phone No for the Bill To Customer |
No |
No |
|
|
|
Rnttmcn_BTA_Email |
varchar(40) |
NULL |
The Email Id for the Bill To Customer |
No |
No |
|
|
|
Rnttmcn_BTA_FaxNo |
varchar(40) |
NULL |
The Fax No for the Bill To Customer |
No |
No |
|
|
|
Rnttmcn_adv_applicable |
varchar(5) |
NULL |
This field holds the advance payable flag of the Rental order document. List of values (Y)es (N)o |
No |
No |
|
|
|
Rnttmcn_advance_paydate |
datetime |
NULL |
This field holds the advance payable date. If advance payable flag is ’yes’ then this is mandatory |
No |
No |
|
|
|
Rnttmcn_advance_perc |
numeric(28) |
NULL |
This field holds the advance percentage. |
No |
No |
|
|
|
Rnttmcn_advance_perc_on |
varchar(5) |
NULL |
This field holds the advance percentage on of the rental order document. List of values |
No |
No |
|
|
|
Rnttmcn_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 |
|
|
|
Rnttmcn_advance_tol_perc |
numeric(28) |
NULL |
This field holds the advance tolerance percentage. |
No |
No |
|
|
|
Rnttmcn_payterm_code |
varchar(25) |
NULL |
This field holds the Unique identifier for the Payterm |
No |
No |
|
|
|
Rnttmcn_Exchg_Rate |
varchar(5) |
NULL |
stores the flag whether to consider the exchange rate as of order date or as of invoice date OD - As of order date ID - As of invoice date |
No |
No |
|
|
|
Rnttmcn_Rcpt_Mode |
varchar(5) |
NULL |
stores the various receipt modes fetched from Bank Cash Master |
No |
No |
|
|
|
Rnttmcn_Rcpt_Method |
varchar(5) |
NULL |
stores the flags for the receipt method. Allowed values are: REG - Regular ESR - ESR ESRP - ESR Plus LSV - LSV SB - Specific Bank |
No |
No |
|
|
|
Rnttmcn_Act_On_Nonpaymt |
varchar(5) |
NULL |
stores the flag for the action to be taken on non payment. values: HOP - Hold Order Processing HRP - Hold Release of Part RRP - Request Return of Part |
No |
No |
|
|
|
Rnttmcn_ddcharges_borneby |
varchar(5) |
NULL |
This field holds the DD charges borne by of the rental order document. List of values CU - customer SE - self N - None |
No |
No |
|
|
|
Rnttmcn_Payment_Notes |
varchar(2000) |
NULL |
This field holds the Payment notes of the rental order documen’ts terms and condition. |
No |
No |
|
|
|
Rnttmcn_insurance_liability |
varchar(5) |
NULL |
This field holds insurance liability of the RTO document List of values are CU - customer SE - self N - none |
No |
No |
|
|
|
Rnttmcn_insurance_amt |
numeric(28,8) |
NULL |
This field holds the insurance amount of the rental order document. |
No |
No |
|
|
|
Rnttmcn_insurance_terms |
varchar(150) |
NULL |
This field holds the insurance term of rental order document. |
No |
No |
|
|
|
Rnttmcn_ShipTo_CustNo |
varchar(45) |
NULL |
A valid customer defined in the customer component |
No |
No |
|
|
|
Rnttmcn_Ship_To_Cust_OU |
numeric |
NULL |
Ship to customer OUInstance |
No |
No |
|
|
|
Rnttmcn_Ship_To_Addr_Id |
varchar(40) |
NULL |
The address id of the Ship To Customer |
No |
No |
|
|
|
Rnttmcn_STA_ContactPerson |
varchar(80) |
NULL |
The Contact person for the Ship To Customer |
No |
No |
|
|
|
Rnttmcn_Ship_To_Address |
varchar(255) |
NULL |
The address of the Ship To Customer |
No |
No |
|
|
|
Rnttmcn_STA_PhoneNo |
varchar(40) |
NULL |
The Phone No for the Ship To Customer |
No |
No |
|
|
|
Rnttmcn_STA_Email |
varchar(40) |
NULL |
The Email No for the Ship To Customer |
No |
No |
|
|
|
Rnttmcn_STA_FaxNo |
varchar(80) |
NULL |
The Fax No for the Ship To Customer |
No |
No |
|
|
|
Rnttmcn_pkg_code |
varchar(25) |
NULL |
This field holds the packaging code defined for rental order in the logistics common master. |
No |
No |
|
|
|
Rnttmcn_packaging_notes |
varchar(2000) |
NULL |
This field holds the packaging notes |
No |
No |
|
|
|
Rnttmcn_inco_term |
varchar(150) |
NULL |
This field holds the INCO term of the rental order document defined in the logistics common master. |
No |
No |
|
|
|
Rnttmcn_ship_by |
varchar(25) |
NULL |
This field holds the shipping methods of the rental order document defined in the logistics common master. |
No |
No |
|
|
|
Rnttmcn_port_of_dep |
varchar(32) |
NULL |
This field holds the port of departure |
No |
No |
|
|
|
Rnttmcn_delivery_point |
varchar(32) |
NULL |
This field holds the delivery point of the rental order document. |
No |
No |
|
|
|
Rnttmcn_carrier_no |
varchar(20) |
NULL |
This field holds the list of carrier agencies |
No |
No |
|
|
|
Rnttmcn_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 |
|
|
|
Rnttmcn_freight_billable |
varchar(5) |
NULL |
holds the flag whether the freight is billable or not. Values : Y - Yes N - No |
No |
No |
|
|
|
Rnttmcn_freight_amount |
numeric(28,8) |
NULL |
holds the value of the freight amount |
No |
No |
|
|
|
Rnttmcn_shipping_notes |
varchar(2000) |
NULL |
This field holds the shipping notes |
No |
No |
|
|
|
Rnttmcn_Ret_To_Loc |
varchar(5) |
NULL |
stores the component admin OUs with which rental order is interacting |
No |
No |
|
|
|
Rnttmcn_Warehouse_No |
varchar(10) |
NULL |
stores the warehouse number |
No |
No |
|
|
|
Rnttmcn_Ret_Carrier_No |
varchar(20) |
NULL |
stores the carrier number by which the part will be returned |
No |
No |
|
|
|
Rnttmcn_Ret_ShipBy |
varchar(25) |
NULL |
This field holds the shipping methods of the rental order document defined in the logistics common master. |
No |
No |
|
|
|
Rnttmcn_RetFreightpayble |
varchar(5) |
NULL |
stores the flag whether freight is payable or not. Values: Y - Yes N - No |
No |
No |
|
|
|
Rnttmcn_Shipping_Payment |
varchar(25) |
NULL |
This field holds the shipping payment methods of the rental order document defined in the logistics common master. |
No |
No |
|
|
|
Rnttmcn_Ret_Pack_Notes |
varchar(2000) |
NULL |
stores the packaging notes |
No |
No |
|
|
|
Rnttmcn_Ret_Ship_Notes |
varchar(2000) |
NULL |
stores the shipping notes |
No |
No |
|
|
|
Rnttmcn_Rnt_Detail2 |
varchar(25) |
NULL |
stores the used defined details |
No |
No |
|
|
|
Rnttmcn_Rnt_Detail3 |
varchar(25) |
NULL |
stores the used defined details |
No |
No |
|
|
|
Rnttmcn_Rnt_Detail4 |
varchar(25) |
NULL |
stores the used defined details |
No |
No |
|
|
|
Rnttmcn_Rnt_Option2 |
varchar(25) |
NULL |
stores the userdefined options defined in the logistics common master |
No |
No |
|
|
|
Rnttmcn_Rnt_Option3 |
varchar(25) |
NULL |
stores the userdefined options defined in the logistics common master |
No |
No |
|
|
|
Rnttmcn_Rnt_Option4 |
varchar(25) |
NULL |
stores the userdefined options defined in the logistics common master |
No |
No |
|
|
|
|
|
|
|
|
|
|
|