Release Slip

Table Name RsS_RAAuAd_Auth_Audit_dtl

Table Comment Used to store the Amended Audit Trails Details of the RSS Document

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

RAAuAd_RS_OUInstance

decimal(38)

NOT NULL

OU instance

Yes

Yes

RAAuAd_RS_No

varchar(40)

NOT NULL

Release slip no

Yes

Yes

RAAuAd_Amend_No

decimal(38)

NOT NULL

This field is Used to store the Amendment No of the Document.

Yes

Yes

RAAuAd_Audit_Trail_Id

decimal(38)

NOT NULL

This field is Used to store the Audit Trial running sequence No.

Yes

No

RAAuAd_Auth_Level_PC

varchar(25)

NULL

This field is Used to store the Audit Trial Level or Purchase Committee code.

No

No

RAAuAd_Date_and_Time

datetime

NULL

This field is Used to store the Date and time of the Audit Trial performed.

No

No

RAAuAd_Remarks

varchar(255)

NULL

This field is Used to store the Audit Trial Remarks.

No

No

RAAuAd_Status_From

varchar(15)

NULL

This field is Used to store the from status when the Audit Trial is performed.

No

No

RAAuAd_Status_To

varchar(15)

NULL

This field is Used to store the To status when the Audit Trial is performed.

No

No

RAAuAd_User_Name

varchar(30)

NULL

This field is Used to store the User who performed the Audit Trial.

No

No

Table Name RsS_RADTcd_Doc_TCD_dtl

Table Comment Used to store the Document Level Amendment History information of the RSS Document

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

RADTcd_RS_OUInstance

decimal(38)

NOT NULL

This field is Used to store Release Slip Created OU Instance

Yes

Yes

RADTcd_RS_No

varchar(40)

NOT NULL

This field is Used to store Release Slip No.

Yes

Yes

RADTcd_Amend_No

decimal(38)

NOT NULL

This field is Used to store Amendment No of the Release Slip.

Yes

Yes

RAPTcd_TCD_Line_Id

decimal(38)

NOT NULL

This field is Used to store Tcd Line ID of the Release Slip Document.(running No)

Yes

No

RADTcd_TCD_OU

decimal(38)

NULL

This field is Used to store Tcd Created OUInstance Of the current Tcd Line id.

No

No

RADTcd_TCD_Code

varchar(25)

NULL

This field is Used to store Tcd Code of the current Tcd Line id.

No

No

RADTcd_TCD_Variant_No

varchar(25)

NULL

This field is Used to store Tcd Variant Code of the current Tcd Line id.

No

No

RADTcd_TCD_Rate

decimal(28,8)

NULL

This field is Used to store rate of the Tcd Code.

No

No

RADTcd_TCD_Amount

decimal(28,8)

NULL

This field is Used to store amount of the Tcd Code.

No

No

RADTcd_CreatedDate

datetime

NOT NULL

This field is Used to store Tcd Line Id Created date.

No

No

RADTcd_Created_By

varchar(30)

NOT NULL

This field is Used to store Tcd Line Id Created user.

No

No

RADTcd_ModifiedDate

datetime

NOT NULL

This field is Used to store last modified date of the Tcd Line Id.

No

No

RADTcd_Modified_By

varchar(30)

NOT NULL

This field is Used to store last modified user of the Tcd Line Id.

No

No

RADTcd_User_Seq_No

decimal(38)

NULL

stores user entered sequence number for the TCD code

No

No

RADTcd_Currency

varchar(20)

NULL

stores the currency chosen in the multiline for the TCD code

No

No

RADTcd_exchg_rate

numeric(28,8)

NULL

Holds the exchange rate between the document currency and the payment currency

No

No

RADTcd_Pay_To_Supp

varchar(45)

NULL

stores the supplier code to whom the payment has to be made

No

No

RADTcd_PayToSupp_OU

decimal(38)

NULL

Stores the pay to supplier’s OU

No

No

Table Name RsS_RAHd_Release_Slip_hdr

Table Comment Used To store the Amendment history information for the RSS Document

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

RSAHd_RS_OUInstance

decimal(38)

NOT NULL

This field is Used to store Release Slip Created OU Instance

Yes

No

RSAHd_Amend_No

decimal(38)

NOT NULL

This field is Used to store the amendment No of the Release Slip.

Yes

No

RSAHd_RS_No

varchar(40)

NOT NULL

This field is Used to store Release Slip No.

Yes

No

RSAHd_Tot_Line_TCD_Amt

decimal(28,8)

NULL

This field is Used to store sum of Part level TCD values of the release Slip in terms of the transaction Currency.

No

No

RSAHd_Auth_TerLevel

varchar(25)

NULL

This field is Used to store the Terminating Authorization level of the Release Slip.

No

No

RSAHd_BPO_Amend_No

decimal(38)

NOT NULL

This field is Used to store reference Blanket Purchase Order amendment No.

No

No

RSAHd_Auth_MinVal

decimal(28,8)

NULL

This field is Used to store the Minimum Authorization value of the Release Slip.

No

No

RSAHd_Auth_MaxVal

decimal(28,8)

NULL

This field is Used to store the Maximum Authorization value of the Release Slip.

No

No

RSAHd_Auth_NxtLvlPc

varchar(25)

NULL

This field is Used to store the Next Level Purchase Committee Information of the Release Slip.

No

No

RSAHd_Auth_Type

varchar(5)

NULL

This field is Used to store Authorization Type either Level, Purchase Committee.

No

No

RSAHd_RS_Buyer_Group_OU

decimal(38)

NULL

This field is Used to store the buyer Group OUInstance in which the Release Slip created user belongs to.

No

No

RSAHd_Auth_Stage

varchar(80)

NULL

This field is Used to store the current stages of the Authorization level.

No

No

RSAHd_RS_Supplier_OU

decimal(38)

NULL

This field is Used to store the Supplier OUInstance in the Release Slip

No

No

RSAHd_RS_Buyer_Group

varchar(25)

NULL

This field is Used to store the buyer Group No in which the Release Slip created user belongs to.

No

No

RSAHd_RS_Supplier_No

varchar(40)

NULL

This field is Used to store the Supplier code in the Release Slip

No

No

RSAHd_RS_Ac_Regn_No

varchar(30)

NULL

This field is Used to store the Aircraft Registration No if the priority is AOG, otherwise Null.

No

No

RSAHd_RS_Basic_Cur_Value

decimal(28,8)

NULL

This field is Used to store Basic Value of the release Slip in terms of the Basic (Company) Currency.

No

No

RSAHd_RS_Basic_Value

decimal(28,8)

NULL

This field is Used to store Basic Value of the release Slip in terms of the transaction Currency.

No

No

RSAHd_BPO_No

varchar(40)

NOT NULL

This field is Used to store reference Blanket Purchase Order No.

No

No

RSAHd_RS_Exchange_Rate_OU

decimal(38)

NULL

This field is Used to store Exchange rate created OUInstance.

No

No

RSAHd_BPO_OUInstance

decimal(38)

NOT NULL

This field is Used to store reference Blanket Purchase Order’s created OUInstance.

No

No

RSAHd_RS_Category

varchar(25)

NULL

This field is Used to store the Category information of the release Slip No. "B" - "Blank".

No

No

RSAHd_Tot_Doc_TCD_Amt

decimal(28,8)

NULL

This field is Used to store Document level TCD values of the release Slip in terms of the transaction Currency.

No

No

RSAHd_RS_Exchange_Rate

decimal(28,8)

NOT NULL

This field is Used to store Exchange rate between the transaction and the Basic Currency.

No

No

RSAHd_RS_Priority

varchar(20)

NULL

This field is Used to store the Priority No for the Release Slip No.

No

No

RSAHd_RS_Currency_OU

decimal(38)

NULL

This field is Used to store transaction Currency Ouinstance of the Release Slip.

No

No

RSAHd_RS_Auth_Reason

varchar(255)

NULL

This field is Used to store the reason for the Authorization of the Release Slip.

No

No

RSAHd_RS_Quality

varchar(5)

NULL

This field is Used to store Quality attribute of the Release Slip. "Y" - "Yes", "N" - "No".

No

No

RSAHd_RS_Currency

varchar(20)

NULL

This field is Used to srore transaction Currency of the Release Slip.

No

No

RSAHd_RS_Can_Reason

varchar(255)

NULL

This field is Used to store the reason for the Cancellation the Release Slip.

No

No

RSAHd_RS_Base_Currency

varchar(20)

NULL

This field is Used to store Basic Currency of the Release Slip.(ie Company currency)

No

No

RSAHd_RS_Scl_Reason

varchar(255)

NULL

This field is Used to store the reason for the Short Close the Release Slip.

No

No

RSAHd_RS_Part_Type

varchar(5)

NULL

This field is Used to store Part Types in which the Release Slip Parts belongs to.

No

No

RSAHd_RS_Date

datetime

NULL

This field is Used to store the Type of Release Slip No created Date.

No

No

RSAHd_RS_Type

varchar(5)

NULL

This field is Used to store the Type of Release Slip No.

No

No

RSAHd_RS_Hld_Reason

varchar(255)

NULL

This field is Used to store the reason for the Holding the Release Slip.

No

No

RSAHd_RS_Rel_Reason

varchar(255)

NULL

This field is Used to store the reason for the Releasing the Release Slip.

No

No

RSAHd_RS_Status

varchar(15)

NULL

This field is Used to store the current status of the Release Slip. "B" - "Blank", "O" - "Open", "H" - "Held", "N" - "NT Closed", "D" - "Draft", "F" - "Fresh" "S" - "Short Closed".

No

No

RSAHd_RS_User_Status

varchar(25)

NULL

This field is Used to store the User Status information of the release Slip No. "B" - "Blank".

No

No

RSAHd_CreatedDate

datetime

NOT NULL

This field is Used to store the Created Date of the Release Slip.

No

No

RSAHd_Created_By

varchar(30)

NOT NULL

This field is Used to store the Created user of the Release Slip.

No

No

RSAHd_ModifiedDate

datetime

NOT NULL

This field is Used to store the last Modified date of the Release Slip.

No

No

RSAHd_Modified_By

varchar(30)

NOT NULL

This field is Used to store the last Modified user of the Release Slip.

No

No

RSAHd_Timestamp

decimal(38)

NOT NULL

This field is Used to store the latest timestamp of the Release Slip No.

No

No

RSAHd_AuthorisedDate

datetime

NULL

This field is Used to store the Authorization date of the Release Slip.

No

No

RSAHd_Authorised_By

varchar(30)

NULL

This field is Used to store the user who authorized the Release Slip.

No

No

RSAHd_AmendedDate

datetime

NULL

This field is Used to store the amended date of the Release Slip.

No

No

RSAHd_Amended_By

varchar(30)

NULL

This field is Used to store the user who amended the Release Slip.

No

No

RSAHd_ConfirmedDate

datetime

NULL

This field is Used to confirmation date of the Release Slip.

No

No

RSAHd_Confirmed_By

varchar(30)

NULL

This field is Used to store the used who performed the confirmation of the Release Slip.

No

No

RSAHD_WF_DOC_KEY

varchar(80)

NULL

Stores the Dockey for the Document.

No

No

Table Name RsS_RAPTcd_Pt_TCD_dtl

Table Comment Used to store the Part Level TCD Details of the Amended RSS Document

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

RAPTcd_RS_OUInstance

decimal(38)

NOT NULL

This field is Used to store Release Slip Created OUInstance

Yes

Yes

RAPTcd_RS_No

varchar(40)

NOT NULL

This field is Used to store Release Slip No.

Yes

Yes

RAPTcd_RS_Line_Id

decimal(38)

NOT NULL

This field is Used to store Release Slip Part Line Id of the release Slip.

Yes

Yes

RAPTcd_Amend_No

decimal(38)

NOT NULL

This field is Used to store the Amendment No of the Release Slip Document.

Yes

Yes

RAPTcd_TCD_Line_Id

decimal(38)

NOT NULL

This field is Used to store Part Level Tcd Line id of the release Slip (running No)

Yes

No

RAPTcd_TCD_OU

decimal(38)

NULL

This field is Used to store Tcd Created OUInstance of the current TCD.

No

No

RAPTcd_TCD_Code

varchar(25)

NULL

This field is Used to store Tcd Code Of the current Tcd line Id.

No

No

RAPTcd_TCD_Variant

varchar(25)

NULL

This field is Used to store Tcd Variant of the current Tcd line Id.

No

No

RAPTcd_TCD_Rate

decimal(28,8)

NULL

This field is Used to store Tcd rate of the current Tcd line Id.

No

No

RAPTcd_TCD_Amount

decimal(28,8)

NULL

This field is Used to store Tcd amount of the current Tcd line Id.

No

No

RAPTcd_CreatedDate

datetime

NOT NULL

This field is Used to store Tcd Line created Date

No

No

RAPTcd_Created_By

varchar(30)

NOT NULL

This field is Used to store Tcd Line created user

No

No

RAPTcd_ModifiedDate

datetime

NOT NULL

This field is Used to store last modified date of the current Tcd Lind Id.

No

No

RAPTcd_Modified_By

varchar(30)

NOT NULL

This field is Used to store last modified user of the current Tcd Lind Id.

No

No

RAPTcd_User_Seq_No

decimal(38)

NULL

stores the user entered sequence number for the TCD code

No

No

RAPTcd_Currency

varchar(20)

NULL

stores the currency chosen in the multiline

No

No

RAPTcd_exchg_rate

numeric(28,8)

NULL

Holds the exchange rate between the document currency and the payment currency

No

No

Table Name RsS_RASch_Rs_Schedule_dtl

Table Comment This table is used to store the Schedule information of the RSS Document.

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

RSASch_RS_OUInstance

decimal(38)

NOT NULL

This field is Used to store Release Slip Created OUInstance

Yes

Yes

RSASch_RS_No

varchar(40)

NOT NULL

This field is Used to store Release Slip No.

Yes

Yes

RSASch_Amend_No

decimal(38)

NOT NULL

This field is Used to store Amendment No’s.

Yes

Yes

RSASch_RS_Line_Id

decimal(38)

NOT NULL

This field is Used to store Part Line Id of the Release Slip No

Yes

Yes

RSASch_RS_Sch_Id

decimal(38)

NOT NULL

This field is Used to store Schedule Line Id of the Part line Id.(Running No)

Yes

No

RSASch_Sch_No

decimal(38)

NULL

This field is Used to store Schedule Line No of the Part line Id.(Display purpose)

No

No

RSASch_Sch_Qty

decimal(28,8)

NULL

This field is Used to store Schedule quantity of the current Part line Id.

No

No

RSASch_Sch_Date

datetime

NULL

This field is Used to store Schedule Date of the current Part line Id.

No

No

RSASch_Wh_No

varchar(10)

NULL

This field is Used to store Warehouse No of the current schedule Line Id.

No

No

RsASch_CreatedDate

datetime

NOT NULL

This field is Used to store Created Date of the Current Schedule.

No

No

RsASch_Created_By

varchar(30)

NOT NULL

This field is Used to store Created User of the Current Schedule.

No

No

RsASch_ModifiedDate

datetime

NOT NULL

This field is Used to store Last Modified Date of the Current Schedule.

No

No

RsASch_Modified_By

varchar(30)

NOT NULL

This field is Used to store Last Modified User of the Current Schedule.

No

No

Table Name RsS_RAuApc_Auth_Pc_Dtl

Table Comment This table is Used to maintain the information for the Purchase Committee Details of the Amended RSS History Information.

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

RAuApc_RS_OUInstance

decimal(38)

NOT NULL

This field is Used to store Release Slip Created OUInstance

Yes

Yes

RAuApc_RS_No

varchar(40)

NOT NULL

This field is Used to store Release Slip No.

Yes

Yes

RAuApc_Amend_No

decimal(38)

NOT NULL

This field is Used to store Amended Date.

Yes

Yes

RAuApc_Pc_Code

varchar(25)

NOT NULL

This field is Used to store Authorization Code.

Yes

No

RAuApc_Emp_Code

varchar(20)

NOT NULL

This field is Used to store Employee Code who authorize the document.

Yes

No

RAuApc_Member_Auth_Status

varchar(5)

NULL

This field is Used to store the Members authorised Status.

No

No

RAuApc_Auth_By

varchar(30)

NULL

This field is Used to store Authorized By user.

No

No

RAuApc_Auth_Date

datetime

NULL

This field is Used to store Authorized date.

No

No

Table Name RsS_RAuApd_Auth_Prof_dtl

Table Comment Used To store the Authorization Detils of the Amended RSS Document

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

RAuApd_RS_OUInstance

decimal(38)

NOT NULL

This field is Used to store Release Slip Created OUInstance

Yes

Yes

RAuApd_RS_No

varchar(40)

NOT NULL

This field is Used to store Release Slip No.

Yes

Yes

RAuApd_Amend_No

decimal(38)

NOT NULL

This field is Used to store Last Amended No.

Yes

Yes

RAuApd_Lvl_Pc_Code

varchar(25)

NOT NULL

This field is Used to store Level or Purchase Committee Code.

Yes

No

RAuApd_Seq_No

decimal(38)

NOT NULL

This field is Used to store the running sequence No.

Yes

No

RAuApd_Type

varchar(5)

NULL

This field is Used to store the authorization Type.

No

No

RAuApd_No_Members

decimal(38)

NULL

This field is Used to store no of members who are authorize the document.

No

No

RAuApd_Pc_Type

varchar(5)

NULL

This field is Used to store the Authorization type (leavel/Purchase Committe)

No

No

RAuApd_Pc_Quroum

decimal(38)

NULL

This field is Used to store the Authorization quroum information.

No

No

RAuApd_Members_Authorized

decimal(38)

NULL

This field is Used to store the total no of the members who are already authorized.

No

No

RAuApd_Lvl_Pc_Auth_Status

varchar(5)

NULL

This field is Used to store the current authorization status of the Release Slip.

No

No

RAuApd_Last_Authorized_By

varchar(30)

NULL

This field is Used to store the last member who authorized the document.

No

No

RAuApd_Last_Auth_Date

datetime

NULL

This field is Used to store the date of last member who authorized the document.

No

No

Table Name RsS_RSAAd_Auth_Audit_dtl

Table Comment Used to Store the Authorization Audit Trail Information for the RSS Document

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

RSAAd_RS_OUInstance

decimal(38)

NOT NULL

This field is Used to store Release Slip Created OUInstance

Yes

Yes

RSAAd_RS_No

varchar(40)

NOT NULL

This field is Used to store Release Slip No.

Yes

Yes

RSAAd_Audit_Trail_Id

decimal(38)

NOT NULL

This field is Used to store the Audit Trial running sequence No.

Yes

No

RSAAd_Auth_Level_PC

varchar(25)

NOT NULL

This field is Used to store the Audit Trial Leavel or Purchase Committee code.

No

No

RSAAd_Date_and_Time

datetime

NULL

This field is Used to store the Date and time of the Audit Trial performed.

No

No

RSAAd_Remarks

varchar(255)

NULL

This field is Used to store the Audit Trial Remarks.

No

No

RSAAd_Status_From

varchar(15)

NULL

This field is Used to store the from status when the Audit Trial is performed.

No

No

RSAAd_Status_To

varchar(15)

NULL

This field is Used to store the To status when the Audit Trial is performed.

No

No

RSAAd_User_Name

varchar(30)

NULL

This field is Used to store the User who performed the Audit Trial.

No

No

Table Name RsS_RsAIns_Rs_Inspect_dtl

Table Comment Used To store the Parameter Informationfor History for the Amended Rss Document

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

RsAIns_RS_OUInstance

decimal(38)

NOT NULL

This field is Used to store Release Slip Created OUInstance

Yes

Yes

RsAIns_RS_No

varchar(40)

NOT NULL

This field is Used to store Release Slip No.

Yes

Yes

RsAIns_Amend_No

decimal(38)

NOT NULL

This field is Used to store the Amendment No of the Release Slip.

Yes

Yes

RsAIns_RS_Attribute_Id

varchar(40)

NOT NULL

This field is Used to store Attribute Id of the Current Part Line Id(Running No)

Yes

No

RsAIns_RS_Line_Id

decimal(38)

NOT NULL

This field is Used to store Release Slip Part Line Id.

Yes

Yes

RsAIns_Attribute_OU

decimal(38)

NULL

This field is Used to store Attribute Created OUInstance.

No

No

RsAIns_Attribute_Code

varchar(40)

NOT NULL

This field is Used to store Attribute code of the Current Part Line Id (Display Only)

No

No

RsAIns_Attribute_Type

varchar(5)

NULL

This field is Used to store Attribute type of the Current attribute.

No

No

RsAIns_Maximum_Value

decimal(28,8)

NULL

This field is Used to store Maximum Attribute value of the Current attribute.

No

No

RsAIns_Minimum_Value

decimal(28,8)

NULL

This field is Used to store Minimum Attribute value of the Current attribute.

No

No

RsAIns_Standard_Value

decimal(28,8)

NULL

This field is Used to store standard Attribute value of the Current attribute.

No

No

RsAIns_Std_Qual_Value

varchar(80)

NULL

This field is Used to store standard Quality value of the Current attribute.

No

No

RsAIns_Trackable

varchar(5)

NULL

This field is Used to store Trackable Information of the Current attribute. "Y" - "Yes", "N" - "No".

No

No

RsAIns_Remarks

varchar(255)

NULL

This field is Used to store Remarks Information of the Current attribute. .

No

No

RsAIns_CreatedDate

datetime

NOT NULL

This field is Used to store Created Date of the Current attribute.

No

No

RsAIns_Created_By

varchar(30)

NOT NULL

This field is Used to store Created User of the Current attribute.

No

No

RsAIns_ModifiedDate

datetime

NOT NULL

This field is Used to store Last Modified Date of the Current attribute.

No

No

RsAIns_Modified_By

varchar(30)

NOT NULL

This field is Used to store Last Modified User of the Current attribute.

No

No

RsAIns_Std_Min_Value

decimal(28,8)

NULL

This field is Used to store standard Minimum Attribute value of the Current attribute.

No

No

RsAIns_Std_Max_Value

decimal(28,8)

NULL

This field is Used to store standard Maximum Attribute value of the Current attribute.

No

No

Table Name RsS_RsApc_Auth_Pc_Dtl

Table Comment User To Store the Authorization Details of the Purchase Committe

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

RsApc_RS_OUInstance

decimal(38)

NOT NULL

This field is Used to store Release Slip Created OUInstance

Yes

Yes

RsApc_RS_No

varchar(40)

NOT NULL

This field is Used to store Release Slip No.

Yes

Yes

RsApc_Pc_Code

varchar(25)

NOT NULL

This field is Used to store Authorization Code.

Yes

No

RsApc_Emp_Code

varchar(20)

NOT NULL

This field is Used to store Employee Code who authorize the document.

Yes

No

RsApc_Member_Auth_Status

varchar(5)

NULL

This field is Used to store the Members authorised Status.

No

No

RsApc_Auth_By

varchar(30)

NULL

This field is Used to store Authorized By user.

No

No

RsApc_Auth_Date

datetime

NULL

This field is Used to store Authorized date.

No

No

Table Name RsS_RsApd_Auth_Prof_dtl

Table Comment This Table is Used to Store Authorization Profile Information of the RSS Document

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

RSApd_RS_OUInstance

decimal(38)

NOT NULL

This field is Used to store Release Slip Created OUInstance

Yes

Yes

RSApd_RS_No

varchar(40)

NOT NULL

This field is Used to store Release Slip No.

Yes

Yes

RsApd_Lvl_Pc_Code

varchar(25)

NOT NULL

This field is Used to store Level or Purchase Committee Code. .

Yes

No

RsApd_Seq_No

decimal(38)

NOT NULL

This field is Used to store the running sequence No.

Yes

No

RsApd_Type

varchar(5)

NULL

This field is Used to store the authorization Type.

No

No

RsApd_No_Members

decimal(38)

NULL

This field is Used to store no of members who are authorize the document.

No

No

RsApd_Pc_Type

varchar(5)

NULL

This field is Used to store the Authorization type (leavel/Purchase Committe)

No

No

RsApd_Pc_Quroum

decimal(38)

NULL

This field is Used to store the Authorization quroum information.

No

No

RsApd_Members_Authorized

decimal(38)

NULL

This field is Used to store the total no of the members who are already authorized.

No

No

RsApd_Lvl_Pc_Auth_Status

varchar(5)

NULL

This field is Used to store the current authorization status of the Release Slip.

No

No

RsApd_Last_Authorized_By

varchar(30)

NULL

This field is Used to store the last member who authorized the document.

No

No

RsApd_Last_Auth_Date

datetime

NULL

This field is Used to store the date of last member who authorized the document.

No

No

Table Name RsS_RSAPdt_Pt_dtl

Table Comment Used to store the Amended Part History Details of the RSS Document

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

RSAPdt_RS_OUInstance

decimal(38)

NOT NULL

This field is Used to store Release Slip Created OUInstance

Yes

Yes

RSAPdt_RS_No

varchar(40)

NOT NULL

This field is Used to store Release Slip No.

Yes

Yes

RSAPdt_Amend_No

decimal(38)

NOT NULL

This field is Used to store Amended No.

Yes

Yes

RSAPdt_RS_Line_Id

decimal(38)

NOT NULL

This field is Used to store Part Line No of the Release Slip No.(display Purpose)

Yes

No

RSAPdt_Alternate_Part_No

varchar(40)

NULL

This field is Used to store Alternate part No of the current Line Id’s part No.

No

No

RSAPdt_BPO_Line_No

decimal(38)

NULL

This field is Used to store Part Line id of the reference Blanket Purchase Order.

No

No

RSAPdt_Cost_Per

decimal(28,8)

NOT NULL

This field is Used to store the Basic cost per of the part in the current Line No.

No

No

RSAPdt_BPO_Line_Id

decimal(38)

NOT NULL

This field is Used to store Part Line No of the reference Blanket Purchase Order.

No

No

RSAPdt_Earliest_Due_Date

datetime

NULL

This field is Used to store Earliest Due date of the Part if it belongs to the Single schedule otherwise Null.

No

No

RSAPdt_Inspection_Type

varchar(5)

NULL

This field is Used to store Inspection Type of the current part Line Id.

No

No

RSAPdt_Part_OUInstance

decimal(38)

NOT NULL

This field is Used to store Part Created OUInstance of the reference Part.

No

No

RSAPdt_Line_No

decimal(38)

NOT NULL

release slip line no

No

No

RSAPdt_Line_Item_Cost

decimal(28,8)

NOT NULL

This field is Used to store the Basic cost of the part in the current Line No.

No

No

RSAPdt_Line_Item_Value

decimal(28,8)

NOT NULL

This field is Used to store the Basic amount of the part in the current Line No.

No

No

RSAPdt_Matching_Type

varchar(5)

NULL

This field is Used to store Matching Type of the current part Line Id.

No

No

RSAPdt_Order_Quantity

decimal(28,8)

NOT NULL

This field is Used to store Part Level order Quantity of the Release Slip.

No

No

RSAPdt_Line_TCD_Amt

decimal(28,8)

NULL

This field is Used to store the Part Level TCD amount of the current Line No.

No

No

RSAPdt_Part_No

varchar(40)

NOT NULL

This field is Used to store Part No of the Release Slip Document.

No

No

RSAPdt_Wh_OUInstance

decimal(38)

NULL

This field is Used to store the storage Location OUInstance Informationo of the current Part.

No

No

RSAPdt_Part_Condition

varchar(5)

NULL

This field is Used to store Part Condition of the Release Slip Document.

No

No

RSAPdt_Purchase_UOM

varchar(10)

NOT NULL

This field is Used to store the Purchase Unit Of measurement of the Part line Id.

No

No

RSAPdt_Quality_Attribute

varchar(5)

NULL

This field is Used to store Quantity Attribute  of the current part Line Id.(Yes/No)

No

No

RSAPdt_Schedule_Type

varchar(25)

NOT NULL

This field is Used to store Schedule Information of the Part Line id. "S" - "Single", "M"  - "Multiple".

No

No

RSAPdt_Ship_To_OUInstance

decimal(38)

NOT NULL

This field is Used to store the ship to OUInstance information of the part in the current Line No.

No

No

RSAPdt_Tolerance_Perc

decimal(28,8)

NULL

This field is Used to store Tolerance percentage of the current part Line Id if the tolerance type other than None.

No

No

RSAPdt_Tolerance_Type

varchar(5)

NULL

This field is Used to store Tolerance Type of the current part Line Id.

No

No

RSAPDT_GR_ACCPT_QTY

numeric(28,8)

NULL

GR accepted quantity

No

No

RSAPDT_GR_RECD_QTY

numeric(28,8)

NULL

GR received quantity

No

No

RSAPdt_Remarks

varchar(255)

NULL

This field is Used to store Remarks of the current part Line Id.

No

No

RSAPdt_CreatedDate

datetime

NOT NULL

This field is Used to store Created Date of the current part Line Id.

No

No

RSAPdt_Created_By

varchar(30)

NOT NULL

This field is Used to store Created user of the current part Line Id.

No

No

RSAPdt_ModifiedDate

datetime

NOT NULL

This field is Used to store Last Modified date of the current part Line Id.

No

No

RSAPdt_Modified_By

varchar(30)

NOT NULL

This field is Used to store Last Modified user of the current part Line Id.

No

No

RSAPdt_Rcpt_Pos_Tol

numeric(28,8)

NULL

Stores the percentage positive tolerance value. The qty of the part number of a RS can exceed by this specified percentage during goods receipt

No

No

RSAPdt_Rcpt_Neg_Tol

numeric(28,8)

NULL

Stores the percentage negative tolerance value. The qty of the part number of a RS can be less by this specified percentage during goods receipt

No

No

Table Name RsS_RsAPr_Rs_PrBased_dtl

Table Comment This Table is used to store the Purchase Request related Amendment History information of the RSS Document

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

RSAPr_RS_OUInstance

decimal(38)

NOT NULL

This field is Used to store Release Slip Created OUInstance

Yes

Yes

RSAPr_RS_No

varchar(40)

NOT NULL

This field is Used to store Release Slip No.

Yes

Yes

RSAPr_Amend_No

decimal(38)

NOT NULL

This field is Used to store Amendment no of the Release Slip No.

Yes

Yes

RSAPr_RS_Line_Id

decimal(38)

NOT NULL

This field is Used to store Part Line Id of the Release Slip No

Yes

Yes

RSAPr_RS_Sch_Id

decimal(38)

NOT NULL

This field is Used to store Schedule Id of the Part Line ID.

Yes

Yes

RsAPr_RS_SeqNo

decimal(38)

NOT NULL

Holds the running serial number to differentiate each record

Yes

No

RsAPr_PR_No

varchar(40)

NOT NULL

This field is Used to store Reference Purchase Request Document.

No

No

RSAPr_PR_Line_No

decimal(38)

NOT NULL

This field is Used to store Reference Purchase Request Document Part Line Id.

No

No

RSAPr_PR_OUInstance

decimal(38)

NOT NULL

This field is Used to store PR Created OUInstance.

No

No

RSAPr_PR_Schedule_No

decimal(38)

NOT NULL

purchase request schedule no

No

No

RSAPr_RS_Covered_Qty

decimal(28,8)

NULL

This field is Used to store Covered PR Quantity in the Release Slip Component.

No

No

RSAPr_CreatedDate

datetime

NOT NULL

This field is Used to store PR Based Rss Schedule created Date

No

No

RSAPr_Created_By

varchar(30)

NOT NULL

This field is Used to store PR Based Rss Schedule created User

No

No

RSAPr_ModifiedDate

datetime

NOT NULL

This field is Used to store Laet Modified PR Based Rss Schedule Date

No

No

RSAPr_Modified_By

varchar(30)

NOT NULL

This field is Used to store Laet Modified PR Based Rss Schedule User.

No

No

Table Name RsS_RsATC_Rs_Terms_Condn

Table Comment Used to store the Terms and Condition details for the amended RSS Document History

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

RSATC_RS_OUInstance

decimal(38)

NOT NULL

This field is Used to store Release Slip Created OUInstance

Yes

Yes

RSATC_RS_No

varchar(40)

NOT NULL

This field is Used to store Release Slip No.

Yes

Yes

RSATC_Amend_No

decimal(38)

NOT NULL

release slip amendment no

Yes

Yes

RSATC_Delivery_Point

varchar(255)

NULL

This field is Used to store the Delivery Point of the Release Slip Document.

No

No

RSATC_INCO_Term

varchar(150)

NULL

This field is Used to store the INCO of the Release Slip Document.

No

No

RSATC_Insur_Amount

decimal(28,8)

NULL

This field is Used to store the Insurance Amount  of the Release Slip Document.

No

No

RSATC_Insur_Liability

varchar(5)

NULL

This field is Used to store the Insurance Liability of the Release Slip Document. "SF" - "Self", "B" - "None", "SS" - "Suppliers".

No

No

RSATC_Insur_Terms

varchar(150)

NULL

This field is Used to store the Insurance Terms  of the Release Slip Document.

No

No

RSATC_Pay_Term_OU

decimal(38)

NULL

This field is Used to store associated Pay Term Created OUInstance of the Release Slip Document.

No

No

RSATC_Mode_of_Transport

varchar(150)

NULL

This field is Used to store the Transport Mode

No

No

RSATC_Packaging_Terms

varchar(150)

NULL

This field is Used to store the Packaging Code of the Release Slip Document.

No

No

RSATC_Pay_Term

varchar(25)

NULL

This field is Used to store associated Pay Term of the Release Slip Document.

No

No

RSATC_Pay_to_Supplier_No

varchar(45)

NULL

This field is Used to store the Pay to Supplier Created OUInstance of the Release Slip Document.

No

No

RSATC_Payment_Mode

varchar(5)

NULL

This field is Used to store Pay Mode of the Release Slip Document.

No

No

RSATC_Payment_Priority

varchar(25)

NULL

This field is Used to store Payment priority of the Release Slip Document "H" - "High", "L" -  "Low", "N" -  "Normal".

No

No

RSATC_Ship_By

varchar(25)

NULL

This field is Used to store the Ship By Mode Of the Release Slip Document.

No

No

RSATC_Ship_Payment

varchar(25)

NULL

This field is Used to store Pay Mode of the Release Slip Document.

No

No

RSATC_REMARKS

varchar(255)

NULL

This field holds the terms and condition Remarks

No

No

RSATC_Ship_Partial

varchar(5)

NULL

This field is Used to store the Packaging Code of the Release Slip Document. "Y" - "Yes", "N" - "No".

No

No

RSATC_TransShipment

varchar(5)

NULL

This field is Used to store the Trans Shipment of the Release Slip Document. "Y" - "Yes", "N" - "No".

No

No

RSATC_CreatedDate

datetime

NOT NULL

This field is Used to store the Terms and condition created Date

No

No

RSATC_Created_By

varchar(30)

NOT NULL

This field is Used to store the Terms and condition created user.

No

No

RSATC_ModifiedDate

datetime

NOT NULL

This field is Used to store the Terms and condition last Modified Date.

No

No

RSATC_Modified_By

varchar(30)

NOT NULL

This field is Used to store the Terms and condition last Modified User.

No

No

RSATC_Adv_Payable

varchar(5)

NULL

stores the flag whether advance is payable or not. "Y" - "Yes", "N" - "No".

No

No

RSATC_Adv_Pay_ByDate

datetime

NULL

stores the date by which advance is payable

No

No

RSATC_Adv_Percent

numeric(28,8)

NULL

stores the value of advance percentage

No

No

RSATC_Adv_Per_On

varchar(5)

NULL

stores the flag to identify whether the advance percent to be applied on Basic Value or Total Value. "B" - "Blank", "BV" - "Basic Value", "TV" - "Total Value".

No

No

RSATC_Adv_Payable_Val

numeric(28,8)

NULL

stores the advance payable value

No

No

RSATC_Adv_Tol_Perc

numeric(28,8)

NULL

stores the advance tolerance percentage

No

No

RSATC_Pay_Mode

varchar(5)

NULL

stores the flag for the payment mode CS - Cash CQ - Cheque DD - Demand Draft P - Pay Order

No

No

RSATC_DDChrgs_BorneBy

varchar(5)

NULL

stores the flag which identifies that the DD charges will be borne by whom "SE" - "Self", "SU"- "Supplier".

No

No

RSATC_Payto_Supp_AddrID

decimal(38)

NULL

stores the pay to supplier’s address id.

No

No

RSATC_Payment_Notes

varchar(2000)

NULL

stores the payment notes

No

No

RSATC_Warranty

varchar(5)

NULL

stores the flag whether warranty is yes or no Y- Yes N - No B - Blank

No

No

RSATC_Warranty_Basis

varchar(5)

NULL

stores the flag to indicate the warranty basis "C"- "Calendar", "U" - "Usage" "BH" - "Both".

No

No

RSATC_Warr_Agrmt_No

varchar(40)

NULL

stores the warranty agreement number

No

No

RSATC_Packaging_Notes

varchar(2000)

NULL

stores the packaging notes

No

No

RSATC_Port_Of_Departure

varchar(40)

NULL

stores the port of departure

No

No

RSATC_Carrier_Agency_No

varchar(40)

NULL

stores the carrier/agency number

No

No

RSATC_SHIPPING_PAYMENT

varchar(40)

NULL

Stores the Shipping Payment mode.

No

No

RSATC_Shipping_Notes

varchar(2000)

NULL

stores the shipping notes

No

No

RSATC_GTA_RefNo

varchar(40)

NULL

stores the General terms and agreement reference number

No

No

RSATC_Ref_Doc_Date

datetime

NULL

stores the reference document date

No

No

RSATC_GTA_Remarks

varchar(255)

NULL

stores the General terms and agreement Remarks

No

No

RSATC_Pay_to_Supplier_OU

decimal(38)

NULL

stores the OU instance of the pay to supplier

No

No

Table Name RsS_RsAUI_User_Def_Info

Table Comment This Table is Used to Store Amended History of the RSS Document’s User Defined Details

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

RsAUI_RS_OUInstance

decimal(38)

NOT NULL

This field is Used to store Release Slip Created OUInstance

Yes

Yes

RSAHd_RS_No

varchar(40)

NOT NULL

This field is Used to store Release Slip No.

Yes

Yes

RsAUI_Amend_No

decimal(38)

NOT NULL

This field is Used to store Last amended No.

Yes

Yes

RsAUI_User_Def_Desc1

varchar(30)

NULL

This field is Used to store User Defined Description -1 of the Release Slip

No

No

RsAUI_User_Def_Opt1

varchar(30)

NULL

This field is Used to store User Defined Option-1 of the Release Slip

No

No

RsAUI_User_Def_Desc2

varchar(30)

NULL

This field is Used to store User Defined Description -2 of the Release Slip

No

No

RsAUI_User_Def_Opt2

varchar(30)

NULL

This field is Used to store User Defined Option-2 of the Release Slip

No

No

RsAUI_User_Def_Desc3

varchar(30)

NULL

This field is Used to store User Defined Description -3 of the Release Slip

No

No

RsAUI_User_Def_Opt3

varchar(30)

NULL

This field is Used to store User Defined Option-3 of the Release Slip

No

No

RsAUI_User_Def_Desc4

varchar(30)

NULL

This field is Used to store User Defined Description -4 of the Release Slip

No

No

RsAUI_User_Def_Opt4

varchar(30)

NULL

This field is Used to store User Defined Option-4 of the Release Slip

No

No

RsAUI_User_Def_Remarks

varchar(255)

NULL

This field is Used to store the remarks of the User Defined information.

No

No

RsAUI_Created_Date

datetime

NOT NULL

This field is Used to store User defined Information Created Date of the release Slip.

No

No

RsAUI_Created_By

varchar(30)

NOT NULL

This field is Used to store User defined Information Created user

No

No

RsAUI_Modified_Date

datetime

NOT NULL

This field is Used to store last modified date of the User defined Information.

No

No

RsAUI_Modified_By

varchar(30)

NOT NULL

This field is Used to store last modified user of the User defined Information.

No

No

Table Name RsS_RsDTcd_Doc_TCD_dtl

Table Comment Used to Store the Document Level TCD Details

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

RSDTcd_RS_OUInstance

decimal(38)

NOT NULL

This field is Used to store Release Slip Created OUInstance

Yes

Yes

RSDTcd_RS_No

varchar(40)

NOT NULL

This field is Used to store Release Slip No.

Yes

Yes

RSDTcd_TCD_Line_Id

decimal(38)

NOT NULL

This field is Used to store Tcd Line ID of the Release Slip Document.(running No)

Yes

No

RsDTcd_TCD_OU

decimal(38)

NULL

This field is Used to store Tcd Created OUInstance Of the current Tcd Line id.

No

No

RsDTcd_TCD_Code

varchar(25)

NULL

This field is Used to store Tcd Code of the current Tcd Line id.

No

No

RsDTcd_TCD_Variant

varchar(25)

NULL

This field is Used to store Tcd Variant Code of the current Tcd Line id.

No

No

RsDTcd_TCD_Rate

decimal(28,8)

NULL

This field is Used to store rate of the Tcd Code.

No

No

RsDTcd_TCD_Amount

decimal(28,8)

NULL

This field is Used to store amount of the Tcd Code.

No

No

RsDTcd_CreatedDate

datetime

NOT NULL

This field is Used to store Tcd Line Id Created date.

No

No

RsDTcd_Created_By

varchar(30)

NOT NULL

This field is Used to store Tcd Line Id Created user.

No

No

RsDTcd_ModifiedDate

datetime

NOT NULL

This field is Used to store last modified date of the Tcd Line Id.

No

No

RsDTcd_Modified_By

varchar(30)

NOT NULL

This field is Used to store last modified user of the Tcd Line Id.

No

No

RsDTcd_User_Seq_No

decimal(38)

NULL

stores user entered sequence number for the TCD code

No

No

RsDTcd_Currency

varchar(20)

NULL

stores the currency chosen in the multiline for the TCD code

No

No

RsDTcd_exchg_rate

numeric(28,8)

NULL

Holds the exchange rate between the document currency and the payment currency

No

No

RsDTcd_Pay_To_Supp

varchar(45)

NULL

stores the supplier code to whom the payment has to be made

No

No

RsDTcd_PayToSupp_OU

decimal(38)

NULL

Stores the pay to supplier’s OU

No

No

Table Name RsS_RSHd_Release_Slip_hdr

Table Comment This Table is Used to store the Release Slip Document Information With Latest Amendment Number.

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

RSHd_RS_OUInstance

decimal(38)

NOT NULL

This field is Used to store Release Slip Created OUInstance

Yes

No

RSHd_RS_No

varchar(40)

NOT NULL

This field is Used to store Release Slip No.

Yes

No

RsHd_Lat_Amend_No

decimal(38)

NOT NULL

This field is Used to store the Latest amendment No of the Release Slip if any Otherwise 0.

No

No

RSHd_BPO_OUInstance

decimal(38)

NOT NULL

This field is Used to store reference Blanket Purchase Order’s created OUInstance.

No

No

RSHd_BPO_No

varchar(40)

NOT NULL

This field is Used to store reference Blanket Purchase Order No.

No

No

RSHd_BPO_Amend_No

decimal(38)

NULL

This field is Used to store reference Blanket Purchase Order amendment No.

No

No

RSHd_RS_Type

varchar(5)

NOT NULL

This field is Used to store the Type of Release Slip No. "B" - " Blank", "N" - "Normal", "E" - "Express".

No

No

RSHd_RS_Date

datetime

NOT NULL

This field is Used to store the Type of Release Slip No created Date.

No

No

RSHd_RS_Buyer_Group_OU

decimal(38)

NULL

This field is Used to store the buyer Group OUInstance in which the Release Slip created user belongs to.

No

No

RSHd_RS_Buyer_Group

varchar(25)

NULL

This field is Used to store the buyer Group No in which the Release Slip created user belongs to.

No

No

RSHd_RS_Supplier_OU

decimal(38)

NOT NULL

This field is Used to store the Supplier OUInstance in the Release Slip

No

No

RSHd_RS_Supplier_No

varchar(40)

NOT NULL

This field is Used to store the Supplier code in the Release Slip

No

No

RSHd_RS_Priority

varchar(20)

NULL

This field is Used to store the Priority No for the Release Slip No.

No

No

RSHd_RS_Ac_Regn_No

varchar(30)

NULL

This field is Used to store the Aircraft Registration No if the priority is AOG, otherwise Null.

No

No

RSHD_RS_USER_STATUS

varchar(25)

NULL

release slip user status. "B" - "Blank".

No

No

RSHd_RS_Category

varchar(25)

NULL

This field is Used to store the Category information of the release Slip No. "B" - "Blank".

No

No

RSHd_RS_Basic_Value

decimal(28,8)

NULL

This field is Used to store Basic Value of the release Slip in terms of the transaction Currency.

No

No

RSHd_Tot_Line_TCD_Amt

decimal(28,8)

NULL

This field is Used to store sum of Part level TCD values of the release Slip in terms of the transaction Currency.

No

No

RSHd_Tot_Doc_TCD_Amt

decimal(28,8)

NULL

This field is Used to store  Document level TCD values of the release Slip in terms of the transaction Currency.

No

No

RSHd_RS_Currency_OU

decimal(38)

NOT NULL

This field is Used to store  transaction Currency OU instance of the Release Slip.

No

No

RSHd_RS_Currency

varchar(20)

NOT NULL

This field is Used to store  transaction Currency of the Release Slip.

No

No

RSHd_RS_Base_Currency

varchar(20)

NOT NULL

This field is Used to store  Basic Currency of the Release Slip.(ie Company currency)

No

No

RSHd_RS_Exchange_Rate_OU

decimal(38)

NOT NULL

This field is Used to store Exchange rate created OUInstance.

No

No

RSHd_RS_Exchange_Rate

decimal(28,8)

NOT NULL

This field is Used to store Exchange rate between the transaction and the Basic Currency.

No

No

RSHd_RS_Basic_Cur_Value

decimal(28,8)

NULL

This field is Used to store Basic Value of the release Slip in terms of the Basic(Company) Currency.

No

No

RSHd_RS_Part_Type

varchar(5)

NOT NULL

This field is Used to store Part Types in which the Release Slip Parts belongs to.

No

No

RSHd_RS_Quality

varchar(5)

NOT NULL

This field is Used to store Quality attribute of the Release Slip. "Y" - "Yes", "N" - "No".

No

No

RsHd_Auth_TerLevel

varchar(25)

NULL

This field is Used to store the Terminating Authorization leavel of the Release Slip.

No

No

RsHd_Auth_MinVal

decimal(28,8)

NULL

This field is Used to store the Minimum Authorization value of the Release Slip.

No

No

RsHd_Auth_MaxVal

decimal(28,8)

NULL

This field is Used to store the Maximum Authorization value of the Release Slip.

No

No

RsHd_Auth_NxtLvlPc

varchar(25)

NULL

This field is Used to store the Next Leavel Purchase Committee Information of the Release Slip.

No

No

RsHd_Auth_Type

varchar(5)

NULL

This field is Used to store Authorization Type either Leavel, Purchase Committee.

No

No

RsHd_Auth_Stage

varchar(80)

NULL

This field is Used to store the current stages of the Authorization level.

No

No

RSHd_RS_Auth_Reason

varchar(255)

NULL

This field is Used to store the reason for the Authorization of the Release Slip.

No

No

RSHd_RS_Can_Reason

varchar(255)

NULL

This field is Used to store the reason for the Cancellation the Release Slip.

No

No

RSHd_RS_Scl_Reason

varchar(255)

NULL

This field is Used to store the reason for the Short Close the Release Slip.

No

No

RSHd_RS_Hld_Reason

varchar(255)

NULL

This field is Used to store the reason for the Holding the Release Slip.

No

No

RSHd_RS_Rel_Reason

varchar(255)

NULL

This field is Used to store the reason for the Releasing the Release Slip.

No

No

RSHd_RS_Status

varchar(15)

NULL

This field is Used to store the current status of the Release Slip. "B" - "Blank", "O" - "Open", "H" - "Held", "N" - "NT Closed", "D" - "Draft", "F" - "Fresh" "S" - "Short Closed", "A" - "Amended", "U" - "Under Amendment", "AU" - "Authorized", "UA" - "Under Authorization", "CL" - "Closed", "CF" - "Confirmed", "C" - "Cancelled", "R" - "Revised", "RT" - "Returned".

No

No

RSHd_CreatedDate

datetime

NOT NULL

This field is Used to store the Created Date of the Release Slip.

No

No

RSHd_Created_By

varchar(30)

NOT NULL

This field is Used to store the Created user of the Release Slip.

No

No

RSHd_ModifiedDate

datetime

NULL

This field is Used to store the last Modified date of the Release Slip.

No

No

RSHd_Modified_By

varchar(30)

NULL

This field is Used to store the last Modified user of the Release Slip.

No

No

RSHd_AuthorisedDate

datetime

NULL

This field is Used to store the Authorization date of the Release Slip.

No

No

RSHd_Authorised_By

varchar(30)

NULL

This field is Used to store the user who authorized the Release Slip.

No

No

RSHd_AmendedDate

datetime

NULL

This field is Used to store the amended date of the Release Slip.

No

No

RSHd_Amended_By

varchar(30)

NULL

This field is Used to store the user who amended the Release Slip.

No

No

RSHd_ConfirmedDate

datetime

NULL

This field is Used to confirmation date of the Release Slip.

No

No

RSHd_Confirmed_By

varchar(30)

NULL

This field is Used to store the used who performed the confirmation of the Release Slip.

No

No

RSHd_Timestamp

decimal(38)

NOT NULL

This field is Used to store the latest timestamp of the Release Slip No.

No

No

RsHd_RS_Numtype

varchar(5)

NULL

stores the numbering type number of release slip transaction

No

No

RSHD_WF_DOC_KEY

varchar(80)

NULL

Stores the Dockey for the Document.

No

No

Table Name RsS_RsIns_Rs_Inspect_dtl

Table Comment Used To store the Parameter Information which was captured from the Reference Document and the Present Value for the related Part No associated with the RSS Document.

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

RSIns_RS_OUInstance

decimal(38)

NOT NULL

This field is Used to store Release Slip Created OUInstance

Yes

Yes

RSIns_RS_No

varchar(40)

NOT NULL

This field is Used to store Release Slip No.

Yes

Yes

RSIns_RS_Line_Id

decimal(38)

NOT NULL

This field is Used to store Release Slip Part Line Id.

Yes

Yes

RSIns_RS_Attribute_Id

varchar(40)

NOT NULL

This field is Used to store Attribute Id of the Current Part Line Id(Running No)

Yes

No

RsIns_Attribute_OU

decimal(38)

NULL

This field is Used to store Attribute Created OUInstance.

No

No

RsIns_Attribute_Code

varchar(40)

NOT NULL

This field is Used to store Attribute code of the Current Part Line Id (Display Only)

No

No

RsIns_Attribute_Type

varchar(5)

NULL

This field is Used to store Attribute type of the Current attribute.

No

No

RsIns_Maximum_Value

decimal(28,8)

NULL

This field is Used to store Maximum Attribute value of the Current attribute.

No

No

RsIns_Minimum_Value

decimal(28,8)

NULL

This field is Used to store Minimum Attribute value of the Current attribute.

No

No

RsIns_Std_Value

decimal(28,8)

NULL

This field is Used to store standard Attribute value of the Current attribute.

No

No

RsIns_Std_Min_Value

decimal(28,8)

NULL

This field is Used to store standard Minimum Attribute value of the Current attribute.

No

No

RsIns_Std_Max_Value

decimal(28,8)

NULL

This field is Used to store standard Maximum Attribute value of the Current attribute.

No

No

RsIns_Std_Qual_Value

varchar(80)

NULL

This field is Used to store standard Quality value of the Current attribute.

No

No

RsIns_Trackable

varchar(5)

NULL

This field is Used to store Trackable Information of the Current attribute. "Y" - "Yes", "N" - "No".

No

No

RsIns_Remarks

varchar(255)

NULL

This field is Used to store Remarks Information of the Current attribute. .

No

No

RsIns_CreatedDate

datetime

NOT NULL

This field is Used to store Created Date of the Current attribute.

No

No

RsIns_Created_By

varchar(30)

NOT NULL

This field is Used to store Created User of the Current attribute.

No

No

RsIns_ModifiedDate

datetime

NOT NULL

This field is Used to store Last Modified Date of the Current attribute.

No

No

RsIns_Modified_By

varchar(30)

NOT NULL

This field is Used to store Last Modified User of the Current attribute.

No

No

Table Name RsS_RSPdt_Pt_dtl

Table Comment Used to store the Part Level information of the Release Slip Document with the Line No

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

RSPdt_RS_OUInstance

decimal(38)

NOT NULL

This field is Used to store Release Slip Created OUInstance

Yes

Yes

RSPdt_RS_No

varchar(40)

NOT NULL

This field is Used to store Release Slip No.

Yes

Yes

RSPdt_RS_Line_Id

decimal(38)

NOT NULL

This field is Used to store Part Line Id of the Release Slip No.(running No)

Yes

No

RSPdt_RS_Line_No

decimal(38)

NOT NULL

This field is Used to store Part Line No of the Release Slip No.(display Purpose)

No

No

RSPdt_BPO_Line_Id

decimal(38)

NOT NULL

This field is Used to store Part Line id of the reference Blanket Purchase Order.

No

No

RSPdt_BPO_Line_No

decimal(38)

NULL

This field is Used to store Part Line No of the reference Blanket Purchase Order.

No

No

RSPdt_Part_OUInstance

decimal(38)

NOT NULL

This field is Used to store Part Created OUInstance of the reference Part.

No

No

RSPdt_Part_No

varchar(40)

NOT NULL

This field is Used to store Part No of the Release Slip Document.

No

No

RSPdt_Part_Condition

varchar(5)

NOT NULL

This field is Used to store Part Condition of the Release Slip Document. "B" - "Blank:, "N" - "New", "NS" - "New Surplus", "SER" - "Servicable".

No

No

RSPdt_RS_Order_Qty

decimal(28,8)

NOT NULL

This field is Used to store Part Level order Quantity of the Release Slip.

No

No

RSPdt_GR_Recd_Qty

decimal(28,8)

NULL

This field is Used to store Quantity which received in the Goods Receipt against the Release Slip Part Line id.

No

No

RSPdt_GR_Accpt_Qty

decimal(28,8)

NULL

This field is Used to store Quantity which Accepted in the Goods Receipt against the Release Slip Part Line id.

No

No

RSPdt_Purchase_UOM

varchar(10)

NOT NULL

This field is Used to store the Purchase Unit Of measurement of the Part line Id.

No

No

RSPdt_Line_TCD_Amt

decimal(28,8)

NULL

This field is Used to store the Part Level TCD amount of the current Line No.

No

No

RSPdt_Line_Item_Cost

decimal(28,8)

NOT NULL

This field is Used to store the Basic cost of the part in the current Line No.

No

No

RSPdt_Cost_Per

decimal(28,8)

NOT NULL

This field is Used to store the Basic cost per of the part in the current Line No.

No

No

RSPdt_Line_Item_Value

decimal(28,8)

NOT NULL

This field is Used to store the Basic amount of the part in the current Line No.

No

No

RSPdt_Ship_To_OUInstance

decimal(38)

NOT NULL

This field is Used to store the ship to OUInstance information of the part in the current Line No.

No

No

RsPdt_Wh_OUInstance

decimal(38)

NULL

This field is Used to store the storage Location OUInstance Information of the current Part.

No

No

RSPdt_Line_Status

varchar(5)

NOT NULL

This field is Used to store latest status of the current part Line Id.

No

No

RSPdt_Schedule_Type

varchar(25)

NOT NULL

This field is Used to store Schedule Information of the Part Line id. "S" - "Single", "M" - "Multiple".

No

No

RSPdt_Earliest_Due_Date

datetime

NULL

This field is Used to store Earliest Due date of the Part if it belongs to the Single schedule otherwise Null.

No

No

RSPdt_Alternate_Part_No

varchar(40)

NULL

This field is Used to store Alternate part No of the current Line Id’s part No.

No

No

RSPdt_Inspection_Type

varchar(5)

NULL

This field is Used to store Inspection Type of the current part Line Id. "N" - "None", "SL" - "Self", "BI" - "By Inspector".

No

No

RSPdt_Matching_Type

varchar(5)

NULL

This field is Used to store Matching Type of the current part Line Id. "3WRS" - "Three Way at RS", "3WGR" - "Three Way at GR", "4WRS" - "Four Way at RS", "4WGR" - "Four Way at GR".

No

No

RSPdt_Tolerance_Type

varchar(5)

NULL

This field is Used to store Tolerance Type of the current part Line Id. "N" - "None", "VAL" - "Value", "QNTY" - "Quantity", "BT" - "Both".

No

No

RSPdt_Tolerance_Perc

decimal(28,8)

NULL

This field is Used to store Tolerance percentage of the current part Line Id if the tolerance type other than None.

No

No

RSPDT_RCPT_POS_TOL

numeric(28,8)

NULL

Stores the percentage positive tolerance value. The qty of the part number of a RS can exceed by this specified percentage during goods receipt

No

No

RSPDT_RCPT_NEG_TOL

numeric(28,8)

NULL

Stores the percentage negative tolerance value. The qty of the part number of a RS can be less by this specified percentage during goods receipt

No

No

RSPdt_Quality_Attribute

varchar(5)

NULL

This field is Used to store Quality Attribute  of the current part Line Id "CUST" - "Customised", "N" - "None", "STD" - "Standard".

No

No

RSPdt_Remarks

varchar(255)

NULL

This field is Used to store Remarks of the current part Line Id.

No

No

RSPdt_CreatedDate

datetime

NOT NULL

This field is Used to store Created Date of the current part Line Id.

No

No

RSPdt_Created_By

varchar(30)

NOT NULL

This field is Used to store Created user of the current part Line Id.

No

No

RSPdt_ModifiedDate

datetime

NOT NULL

This field is Used to store Last Modified date of the current part Line Id.

No

No

RSPdt_Modified_By

varchar(30)

NOT NULL

This field is Used to store Last Modified user of the current part Line Id.

No

No

Table Name RsS_RsPr_Rs_PrBased_dtl

Table Comment Used to store the Purchase Request based Information of the RSS Document

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

RsPr_RS_OUInstance

decimal(38)

NOT NULL

This field is Used to store Release Slip Created OUInstance

Yes

Yes

RSPr_RS_No

varchar(40)

NOT NULL

This field is Used to store Release Slip No.

Yes

Yes

RsPr_RS_Line_Id

decimal(38)

NOT NULL

This field is Used to store Part Line Id of the Release Slip No

Yes

Yes

RsPr_RS_Sch_Id

decimal(38)

NOT NULL

This field is Used to store Schedule Id of the Part Line ID.

Yes

Yes

RsPr_RS_SeqNo

decimal(38)

NOT NULL

Holds the running serial number to differentiate each record

Yes

No

RsPr_PR_OUInstance

decimal(38)

NULL

This field is Used to store Reference Purchase Request Document Created OUInstance.

No

No

RsPr_PR_No

varchar(40)

NULL

This field is Used to store Reference Purchase Request Document.

No

No

RsPr_PR_Line_No

decimal(38)

NULL

This field is Used to store Reference Purchase Request Document Part Line Id.

No

No

RsPr_PR_Schedule_No

decimal(38)

NULL

This field is Used to store Reference Purchase Request Document Schedule Id.

No

No

RsPr_RS_Covered_Qty

decimal(28,8)

NOT NULL

This field is Used to store Covered PR Quantity in the Release Slip Component.

No

No

RsPr_CreatedDate

datetime

NOT NULL

This field is Used to store PR Based Rss Schedule created Date

No

No

RsPr_Created_By

varchar(30)

NOT NULL

This field is Used to store PR Based Rss Schedule created User

No

No

RsPr_ModifiedDate

datetime

NOT NULL

This field is Used to store Last Modified PR Based Rss Schedule Date

No

No

RsPr_Modified_By

varchar(30)

NOT NULL

This field is Used to store Last Modified PR Based Rss Schedule User.

No

No

RSPR_RS_GRMOVED_QTY

decimal(28,8)

NULL

This field is Used to store GR moved quantity against covered PR in the Release Slip Component.

No

No

Table Name RsS_RSPrm_Parameter_dtl

Table Comment Used to store the Parameter Values in the Rss Document

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

RSPrm_Componentname

varchar(20)

NOT NULL

This field is Used to store Component Name Information.

Yes

No

RSPrm_Paramcategory

varchar(10)

NOT NULL

This field is Used to store Parameter Category.

Yes

No

RSPrm_Paramtype

varchar(25)

NOT NULL

This field is Used to store Parameter Type.

Yes

No

RSPrm_Paramcode

varchar(5)

NOT NULL

This field is Used to store Parameter Code.

Yes

No

RSPrm_Langid

decimal(38)

NOT NULL

This field is Used to store Language Id Information.

Yes

No

RSPrm_Paramdesc

varchar(80)

NULL

This field is Used to store Parameter Description.

No

No

RSPrm_Sortby

decimal(38)

NULL

This field is Used to store sort By in terms of the records.

No

No

RSPrm_Createddate

datetime

NOT NULL

This field is Used to store Parameter Created Date.

No

No

Table Name RsS_RsPTcd_Pt_TCD_dtl

Table Comment Used to Store the Part Level TCD Details of the RSS Document

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

RSPTcd_RS_OUInstance

decimal(38)

NOT NULL

This field is Used to store Release Slip Created OUInstance

Yes

Yes

RSPTcd_RS_No

varchar(40)

NOT NULL

This field is Used to store Release Slip No.

Yes

Yes

RSPTcd_RS_Line_Id

decimal(38)

NOT NULL

This field is Used to store Release Slip Part Line Id of the release Slip.

Yes

Yes

RSPTcd_TCD_Line_Id

decimal(38)

NOT NULL

This field is Used to store Part Level Tcd Line id of the release Slip (running No)

Yes

No

RsPTcd_TCD_OU

decimal(38)

NULL

This field is Used to store Tcd Created OUInstance of the current TCD.

No

No

RsPTcd_TCD_Code

varchar(25)

NULL

This field is Used to store Tcd Code Of the current Tcd line Id.

No

No

RsPTcd_TCD_Variant

varchar(25)

NULL

This field is Used to store Tcd Variant of the current Tcd line Id.

No

No

RsPTcd_TCD_Rate

decimal(28,8)

NULL

This field is Used to store Tcd rate of the current Tcd line Id.

No

No

RsPTcd_TCD_Amount

decimal(28,8)

NULL

This field is Used to store Tcd amount of the current Tcd line Id.

No

No

RsPTcd_CreatedDate

datetime

NOT NULL

This field is Used to store Tcd Line created Date

No

No

RsPTcd_Created_By

varchar(30)

NOT NULL

This field is Used to store Tcd Line created user

No

No

RsPTcd_ModifiedDate

datetime

NOT NULL

This field is Used to store last modified date of the current Tcd Lind Id.

No

No

RsPTcd_Modified_By

varchar(30)

NOT NULL

This field is Used to store last modified user of the current Tcd Lind Id.

No

No

RsPTcd_User_Seq_No

decimal(38)

NULL

stores the user entered sequence number for the TCD code

No

No

RsPTcd_Currency

varchar(20)

NULL

stores the currency chosen in the multiline

No

No

RsPTcd_exchg_rate

numeric(28,8)

NULL

Holds the exchange rate between the document currency and the payment currency

No

No

Table Name RsS_RsSch_Rs_Schedule_dtl

Table Comment Used To store the Schedule Details of the Rss Document

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

RSSch_RS_OUInstance

decimal(38)

NOT NULL

This field is Used to store Release Slip Created OUInstance

Yes

Yes

RSSch_RS_No

varchar(40)

NOT NULL

This field is Used to store Release Slip No.

Yes

Yes

RSSch_RS_Line_Id

decimal(38)

NOT NULL

This field is Used to store Part Line Id of the Release Slip No

Yes

Yes

RsSch_RS_Sch_Id

decimal(38)

NOT NULL

This field is Used to store Schedule Line Id of the Part line Id.(Running No)

Yes

No

RsSch_Sch_No

decimal(38)

NULL

This field is Used to store Schedule Line No of the Part line Id.(Display purpose)

No

No

RsSch_Sch_Date

datetime

NULL

This field is Used to store Schedule Date of the current Part line Id.

No

No

RsSch_Sch_Qty

decimal(28,8)

NULL

This field is Used to store Schedule quantity of the current Part line Id.

No

No

RsSch_Sch_Move_Qty

decimal(28,8)

NULL

This field is Used to store Gr Moved quantity of the current schedule of the Part Line Id.

No

No

RsSch_Wh_No

varchar(10)

NULL

This field is Used to store Warehouse No of the current schedule Line Id.

No

No

RSSCH_SCH_STATUS

varchar(5)

NULL

release slip schedule status

No

No

RsSch_CreatedDate

datetime

NOT NULL

This field is Used to store Created Date of the Current Schedule.

No

No

RsSch_Created_By

varchar(30)

NOT NULL

This field is Used to store Created User of the Current Schedule.

No

No

RsSch_ModifiedDate

datetime

NOT NULL

This field is Used to store Last Modified Date of the Current Schedule.

No

No

RsSch_Modified_By

varchar(30)

NOT NULL

This field is Used to store Last Modified User of the Current Schedule.

No

No

Table Name RsS_RsSUI_User_Def_Info

Table Comment This Table is Used to Store User Defined Details of the RSS Document

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

RsSUI_RS_OUInstance

decimal(38)

NOT NULL

This field is Used to store Release Slip Created OUInstance

Yes

Yes

RsSUI_RS_No

varchar(40)

NOT NULL

This field is Used to store Release Slip No.

Yes

Yes

RsSUI_User_Def_Desc1

varchar(30)

NULL

This field is Used to store User Defined Description -1 of the Release Slip

No

No

RsSUI_User_Def_Opt1

varchar(30)

NULL

This field is Used to store User Defined Option-1 of the Release Slip

No

No

RsSUI_User_Def_Desc2

varchar(30)

NULL

This field is Used to store User Defined Description -2 of the Release Slip

No

No

RsSUI_User_Def_Opt2

varchar(30)

NULL

This field is Used to store User Defined Option-2 of the Release Slip

No

No

RsSUI_User_Def_Desc3

varchar(30)

NULL

This field is Used to store User Defined Description -3 of the Release Slip

No

No

RsSUI_User_Def_Opt3

varchar(30)

NULL

This field is Used to store User Defined Option-3 of the Release Slip

No

No

RsSUI_User_Def_Desc4

varchar(30)

NULL

This field is Used to store User Defined Description -4 of the Release Slip

No

No

RsSUI_User_Def_Opt4

varchar(30)

NULL

This field is Used to store User Defined Option-4 of the Release Slip

No

No

RsSUI_User_Def_Remarks

varchar(255)

NULL

This field is Used to store the remarks of the User Defined information.

No

No

RsSUI_Created_Date

datetime

NOT NULL

This field is Used to store User defined Information Created Date of the release Slip.

No

No

RsSUI_Created_By

varchar(30)

NOT NULL

This field is Used to store User defined Information Created user

No

No

RsSUI_Modified_Date

datetime

NOT NULL

This field is Used to store last modified date of the User defined Information.

No

No

RsSUI_Modified_By

varchar(30)

NOT NULL

This field is Used to store last modified user of the User defined Information.

No

No

Table Name RsS_RsTmCn_Rs_Terms_Condns

Table Comment Used to store the Terms and Condition Information of the RSS Document (ie, Pay To supplier, Payterm )

Table Column Name

Table Column Datatype