Data Dictionary -- Release Slip

Srl. No.	Table Name	Comment
1	RSS_RAAUAD_AUTH_AUDIT_DTL	Used to store the Amended Audit Trails Details of the RSS Document
2	RSS_RADTCD_DOC_TCD_DTL	Used to store the Document Level Amendment History iformation of the RSS Document
3	RSS_RAHD_RELEASE_SLIP_HDR	Used To store the Amendment histroy information for the RSS Document
4	RSS_RAPTCD_PT_TCD_DTL	Used to store the Part Level TCD Details of the Amended RSS Document
5	RSS_RASCH_RS_SCHEDULE_DTL	This table is used to store the Schedule information of the RSS Document.
6	RSS_RAUAPC_AUTH_PC_DTL	This table is Used to maintain the information for the Purchase Committe Details of the Amended RSS History Information.
7	RSS_RAUAPD_AUTH_PROF_DTL	Used To store the Authorization Detils of the Amended RSS Document
8	RSS_RSAAD_AUTH_AUDIT_DTL	Used to Store the Authorization Audit Trail Information for the RSS Document
9	RSS_RSAINS_RS_INSPECT_DTL	Used To store the Parameter Informationfor History for the Amended Rss Document
10	RSS_RSAPC_AUTH_PC_DTL	User To Store the Authorization Details of the Purchase Committe
11	RSS_RSAPDT_PT_DTL	Used to store the Amended Part History Details of the RSS Document
12	RSS_RSAPD_AUTH_PROF_DTL	This Table is Used to Store Authorization Profile Information of the RSS Document
13	RSS_RSAPR_RS_PRBASED_DTL	This Table is used to store the Purchase Request related Amendment History information of the RSS Document
14	RSS_RSATC_RS_TERMS_CONDN	Used to store the Terms and Condition detaisl for the amended RSS Document History
15	RSS_RSAUI_USER_DEF_INFO	This Table is Used to Store Amended History of the RSS Document s User Defined Details
16	RSS_RSDTCD_DOC_TCD_DTL	Used to Store the Document Level TCD Details
17	RSS_RSHD_RELEASE_SLIP_HDR	This Table is Used to store the Release Slip Dcument Information With Latest Amemend Number.
18	RSS_RSINS_RS_INSPECT_DTL	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.
19	RSS_RSPDT_PT_DTL	Used to store the Part Level information of the Release Slip Document with the Line No
20	RSS_RSPRM_PARAMETER_DTL	Used to store the Parameter Values in the Rss Document
21	RSS_RSPR_RS_PRBASED_DTL	Used to store the Purchase Request based Information of the RSS Document
22	RSS_RSPTCD_PT_TCD_DTL	Used to Store the Part Level TCD Details of the RSS Document
23	RSS_RSSCH_RS_SCHEDULE_DTL	Used To store the Schedule Details of the Rss Document
24	RSS_RSSUI_USER_DEF_INFO	This Table is Used to Store User Defined Details of the RSS Document
25	RSS_RSTMCN_RS_TERMS_CONDNS	Used to store the Terms and Condition Information of the RSS Document (ie, Pay To supplier, Payterm )

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

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
RAAUAD_AUTH_LEVEL_PC	_varchar_25	Varchar(25)	Yes	This field is Used to store the Audit Trial Leavel or Purchase Committe code.	No
RAAUAD_RS_OUINSTANCE	_decimal_38_0	decimal(38)	No	Ouinstance	Yes
RAAUAD_RS_NO	_varchar_40	varchar(40)	No	Release slip no	Yes
RAAUAD_DATE_AND_TIME	_datetime_8	datetime(8)	Yes	This field is Used to store the Date and time of the Audit Trial performed.	No
RAAUAD_AMEND_NO	_decimal_38_0	decimal(38)	No	This field is Used to store the Amendment No of the Document.	Yes
RAAUAD_AUDIT_TRAIL_ID	_decimal_38_0	decimal(38)	No	This field is Used to store the Audit Trial running sequence No.	Yes
RAAUAD_REMARKS	_varchar_255	varchar(255)	Yes	This field is Used to store the Audit Trial Remarks.	No
RAAUAD_STATUS_FROM	_varchar_15	varchar(15)	Yes	This field is Used to store the from status when the Audit Trial is performed.	No
RAAUAD_STATUS_TO	_varchar_15	varchar(15)	Yes	This field is Used to store the To status when the Audit Trial is performed.	No
RAAUAD_USER_NAME	_varchar_30	varchar(30)	Yes	This field is Used to store the User who performed the Audit Trial.	No

Table Name :	RSS_RADTCD_DOC_TCD_DTL
Comment :	Used to store the Document Level Amendment History iformation of the RSS Document

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
RADTCD_RS_OUINSTANCE	_decimal_38_0	decimal(38)	No	This field is Used to store Release Slip Created OUInstance	Yes
RADTCD_RS_NO	_varchar_40	varchar(40)	No	This field is Used to store Release Slip No.	Yes
RADTCD_AMEND_NO	_decimal_38_0	decimal(38)	No	This field is Used to store Amendment No of the Release Slip.	Yes
RADTCD_TCD_CODE	_varchar_25	Varchar(25)	Yes	This field is Used to store Tcd Code of the current Tcd Line id.	No
RAPTCD_TCD_LINE_ID	_decimal_38_0	decimal(38)	No	This field is Used to store Tcd Line ID of the Release Slip Document.(running No)	Yes
RADTCD_TCD_OU	_decimal_38_0	decimal(38)	Yes	This field is Used to store Tcd Created OUInstance Of the current Tcd Line id.	No
RADTCD_TCD_AMOUNT	_decimal_28_8	decimal(28)	Yes	This field is Used to store amount of the Tcd Code.	No
RADTCD_TCD_RATE	_decimal_28_8	decimal(28)	Yes	This field is Used to store rate of the Tcd Code.	No
RADTCD_TCD_VARIANT_NO	_varchar_25	Varchar(25)	Yes	This field is Used to store Tcd Variant Code of the current Tcd Line id.	No
RADTCD_CREATEDDATE	_datetime_8	datetime(8)	No	This field is Used to store Tcd Line Id Created date.	No
RADTCD_CREATED_BY	_varchar_30	varchar(30)	No	This field is Used to store Tcd Line Id Created user.	No
RADTCD_MODIFIEDDATE	_datetime_8	datetime(8)	No	This field is Used to store last modified date of the Tcd Line Id.	No
RADTCD_MODIFIED_BY	_varchar_30	varchar(30)	No	This field is Used to store last modified user of the Tcd Line Id.	No
RADTCD_USER_SEQ_NO	_decimal_38_0	decimal(38)	Yes	stores user entered sequence number for the TCD code	No
RADTCD_CURRENCY	_varchar_20	varchar(20)	Yes	stores the currency chosen in the multiline for the TCD code	No
RADTCD_EXCHG_RATE	_decimal_28_8	decimal(28)	Yes	Holds the exchage rate between the document currency and the payment currency	No
RADTCD_PAY_TO_SUPP	_varchar_45	varchar(45)	Yes	stores the supplier code to whom the payment has to be made	No
RADTCD_PAYTOSUPP_OU	_decimal_38_0	decimal(38)	Yes	Stores the pay to supplier s OU	No
RADTCD_CHRG_TYPE	udd_designparamcode	varchar(5)	No	this field holds the Notional TCD charge type for the Document TCD after amendment	No
RADTCD_TCD_INCIDENCE	udd_taxinci	Varchar(40)	Yes	This field holds the TCD Incidence	No

Table Name :	RSS_RAHD_RELEASE_SLIP_HDR
Comment :	Used To store the Amendment histroy information for the RSS Document

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
RSAHD_RS_OUINSTANCE	_decimal_38_0	decimal(38)	No	This field is Used to store Release Slip Created OUInstance	Yes
RSAHD_TOT_LINE_TCD_AMT	_decimal_28_8	decimal(28)	Yes	This field is Used to store sum of Part level TCD values of the release Slip in terms of the trasaction Currency.	No
RSAHD_AMEND_NO	_decimal_38_0	decimal(38)	No	This field is Used to store the amendment No of the Release Slip.	Yes
RSAHD_AUTH_TERLEVEL	_varchar_25	Varchar(25)	Yes	This field is Used to store the Terminating Authorization leavel of the Release Slip.	No
RSAHD_BPO_AMEND_NO	_decimal_38_0	decimal(38)	No	This field is Used to store reference Blanket Purchase Order amendent No.	No
RSAHD_AUTH_MINVAL	_decimal_28_8	decimal(28)	Yes	This field is Used to store the Minimum Authorization value of the Release Slip.	No
RSAHD_AUTH_MAXVAL	_decimal_28_8	decimal(28)	Yes	This field is Used to store the Maximum Authorization value of the Release Slip.	No
RSAHD_AUTH_NXTLVLPC	_varchar_25	Varchar(25)	Yes	This field is Used to store the Next Leavel Purchase Commite Information of the Release Slip.	No
RSAHD_AUTH_TYPE	_varchar_5	varchar(5)	Yes	This field is Used to store Authorization Type either Leavel, Purchase Committe.	No
RSAHD_RS_BUYER_GROUP_OU	_decimal_38_0	decimal(38)	Yes	This field is Used to store the buyer Group OUInstance in which the Release Slip ctrated user belongs to.	No
RSAHD_AUTH_STAGE	_varchar_80	varchar(80)	Yes	This field is Used to store the current stages of the Authorization leavel.	No
RSAHD_RS_SUPPLIER_OU	_decimal_38_0	decimal(38)	Yes	This field is Used to store the Supplier OUInstance in the Release Slip	No
RSAHD_RS_BUYER_GROUP	_varchar_25	Varchar(25)	Yes	This field is Used to store the buyer Group No in which the Release Slip ctrated user belongs to.	No
RSAHD_RS_SUPPLIER_NO	_varchar_40	varchar(40)	Yes	This field is Used to store the Suppliercode in the Release Slip	No
RSAHD_RS_AC_REGN_NO	_varchar_30	varchar(30)	Yes	This field is Used to store the Aircraft Registration No if the priority is AOG, otherwise Null.	No
RSAHD_RS_BASIC_CUR_VALUE	_decimal_28_8	decimal(28)	Yes	This field is Used to store Basic Value of the release Slip in terms of the Basic(Company) Currency.	No
RSAHD_RS_BASIC_VALUE	_decimal_28_8	decimal(28)	Yes	This field is Used to store Basic Value of the release Slip in terms of the trasaction Currency.	No
RSAHD_BPO_NO	_varchar_40	varchar(40)	No	This field is Used to store reference Blanket Purchase Order No.	No
RSAHD_RS_EXCHANGE_RATE_OU	_decimal_38_0	decimal(38)	Yes	This field is Used to store Exchange rate creatd OUInstance.	No
RSAHD_BPO_OUINSTANCE	_decimal_38_0	decimal(38)	No	This field is Used to store reference Blanket Purchase Order s created OUInstance.	No
RSAHD_RS_CATEGORY	_varchar_25	Varchar(25)	Yes	This field is Used to store the Category information of the release Slip No. "B" - "Blank".	No
RSAHD_TOT_DOC_TCD_AMT	_decimal_28_8	decimal(28)	Yes	This field is Used to strore Document level TCD values of the release Slip in terms of the trasaction Currency.	No
RSAHD_RS_EXCHANGE_RATE	_decimal_28_8	decimal(28)	No	This field is Used to store Exchange rate between the transaction and the Basic Currency.	No
RSAHD_RS_PRIORITY	_varchar_20	varchar(20)	Yes	This field is Used to store the Priority No for the Release Slip No.	No
RSAHD_RS_CURRENCY_OU	_decimal_38_0	decimal(38)	Yes	This field is Used to strore trasaction Currency Ouinstance of the Release Slip.	No
RSAHD_RS_AUTH_REASON	_varchar_255	varchar(255)	Yes	This field is Used to store the reason for the Authorization of the Release Slip.	No
RSAHD_RS_QUALITY	_varchar_5	varchar(5)	Yes	This field is Used to store Quality attribute of the Release Slip. "Y" - "Yes", "N" - "No".	No
RSAHD_RS_CURRENCY	_varchar_20	varchar(20)	Yes	This field is Used to strore trasaction Currency of the Release Slip.	No
RSAHD_RS_CAN_REASON	_varchar_255	varchar(255)	Yes	This field is Used to store the reason for the Cancellation the Release Slip.	No
RSAHD_RS_BASE_CURRENCY	_varchar_20	varchar(20)	Yes	This field is Used to strore Basic Currency of the Release Slip.(ie Company currency)	No
RSAHD_RS_NO	_varchar_40	varchar(40)	No	This field is Used to store Release Slip No.	Yes
RSAHD_RS_SCL_REASON	_varchar_255	varchar(255)	Yes	This field is Used to store the reason for the Short Close the Release Slip.	No
RSAHD_RS_PART_TYPE	_varchar_5	varchar(5)	Yes	This field is Used to store Part Types in which the Release Slip Parts belongs to.	No
RSAHD_RS_DATE	_datetime_8	datetime(8)	Yes	This field is Used to store the Type of Release Slip No created Date.	No
RSAHD_RS_TYPE	_varchar_5	varchar(5)	Yes	This field is Used to store the Type of Release Slip No.	No
RSAHD_RS_HLD_REASON	_varchar_255	varchar(255)	Yes	This field is Used to store the reason for the Holding the Release Slip.	No
RSAHD_RS_REL_REASON	_varchar_255	varchar(255)	Yes	This field is Used to store the reason for the Releasing the Release Slip.	No
RSAHD_RS_STATUS	_varchar_15	varchar(15)	Yes	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
RSAHD_RS_USER_STATUS	_varchar_25	Varchar(25)	Yes	This field is Used to store the User Status information of the release Slip No. "B" - "Blank".	No
RSAHD_CREATEDDATE	_datetime_8	datetime(8)	No	This field is Used to store the Created Date of the Release Slip.	No
RSAHD_CREATED_BY	_varchar_30	varchar(30)	No	This field is Used to store the Created user of the Release Slip.	No
RSAHD_MODIFIEDDATE	_datetime_8	datetime(8)	No	This field is Used to store the last Modified date of the Release Slip.	No
RSAHD_MODIFIED_BY	_varchar_30	varchar(30)	No	This field is Used to store the last Modified user of the Release Slip.	No
RSAHD_TIMESTAMP	_decimal_38_0	decimal(38)	No	This field is Used to store the latest timestamp of the Release Slip No.	No
RSAHD_AUTHORISEDDATE	_datetime_8	datetime(8)	Yes	This field is Used to store the Authorization date of the Release Slip.	No
RSAHD_AUTHORISED_BY	_varchar_30	varchar(30)	Yes	This field is Used to store the user who authorized the Release Slip.	No
RSAHD_AMENDEDDATE	_datetime_8	datetime(8)	Yes	This field is Used to store the ameded date of the Release Slip.	No
RSAHD_AMENDED_BY	_varchar_30	varchar(30)	Yes	This field is Used to store the user who amended the Release Slip.	No
RSAHD_CONFIRMEDDATE	_datetime_8	datetime(8)	Yes	This field is Used to confirmation date of the Release Slip.	No
RSAHD_CONFIRMED_BY	_varchar_30	varchar(30)	Yes	This field is Used to store the used who performed the confirmation of the Release Slip.	No
RSAHD_WF_DOC_KEY	_varchar_80	varchar(80)	Yes	Stores the Dockey for the Document.	No

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

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
RAPTCD_RS_OUINSTANCE	_decimal_38_0	decimal(38)	No	This field is Used to store Release Slip Created OUInstance	Yes
RAPTCD_RS_NO	_varchar_40	varchar(40)	No	This field is Used to store Release Slip No.	Yes
RAPTCD_RS_LINE_ID	_decimal_38_0	decimal(38)	No	This field is Used to store Release Slip Part Line Id of the release Slip.	Yes
RAPTCD_TCD_CODE	_varchar_25	Varchar(25)	Yes	This field is Used to store Tcd Code Of the current Tcd line Id.	No
RAPTCD_AMEND_NO	_decimal_38_0	decimal(38)	No	This field is Used to store the Amendment No of the Release Slip Document.	Yes
RAPTCD_TCD_AMOUNT	_decimal_28_8	decimal(28)	Yes	This field is Used to store Tcd amount of the current Tcd line Id.	No
RAPTCD_TCD_OU	_decimal_38_0	decimal(38)	Yes	This field is Used to store Tcd Created OUInstance of the current TCD.	No
RAPTCD_TCD_LINE_ID	_decimal_38_0	decimal(38)	No	This field is Used to store Tcd Line ID of the Release Slip Document.(running No)	Yes
RAPTCD_TCD_RATE	_decimal_28_8	decimal(28)	Yes	This field is Used to store Tcd rate of the current Tcd line Id.	No
RAPTCD_TCD_VARIANT	_varchar_25	Varchar(25)	Yes	This field is Used to store Tcd Variant of the current Tcd line Id.	No
RAPTCD_CREATEDDATE	_datetime_8	datetime(8)	No	This field is Used to store Tcd Line created Date	No
RAPTCD_CREATED_BY	_varchar_30	varchar(30)	No	This field is Used to store Tcd Line created user	No
RAPTCD_MODIFIEDDATE	_datetime_8	datetime(8)	No	This field is Used to store last modified date of the current Tcd Lind Id.	No
RAPTCD_MODIFIED_BY	_varchar_30	varchar(30)	No	This field is Used to store last modified user of the current Tcd Lind Id.	No
RAPTCD_USER_SEQ_NO	_decimal_38_0	decimal(38)	Yes	stores the user entered sequence number for the TCD code	No
RAPTCD_CURRENCY	_varchar_20	varchar(20)	Yes	stores the currency chosen in the multiline	No
RAPTCD_EXCHG_RATE	_decimal_28_8	decimal(28)	Yes	Holds the exchage rate between the document currency and the payment currency	No
RAPTCD_CHRG_TYPE	udd_designparamcode	varchar(5)	Yes	Notional TCD charge type for the Part TCD after amendment	No
RAPTCD_TCD_INCIDENCE	udd_taxinci	Varchar(40)	Yes	This field holds the TCD Incidence	No

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

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
RSASCH_RS_OUINSTANCE	_decimal_38_0	decimal(38)	No	This field is Used to store Release Slip Created OUInstance	Yes
RSASCH_RS_NO	_varchar_40	varchar(40)	No	This field is Used to store Release Slip No.	Yes
RSASCH_AMEND_NO	_decimal_38_0	decimal(38)	No	This field is Used to store Amendment No s.	Yes
RSASCH_SCH_NO	_decimal_38_0	decimal(38)	Yes	This field is Used to store Schedule Line No of the Part line Id.(Display purpose)	No
RSASCH_RS_LINE_ID	_decimal_38_0	decimal(38)	No	This field is Used to store Part Line Id of the Release Slip No	Yes
RSASCH_SCH_DATE	_datetime_8	datetime(8)	Yes	This field is Used to store Schedule Date of the current Part line Id.	No
RSASCH_RS_SCH_ID	_decimal_38_0	decimal(38)	No	This field is Used to store Schedule Line Id of the Part line Id.(Running No)	Yes
RSASCH_SCH_QTY	_decimal_28_8	decimal(28)	Yes	This field is Used to store Schedule quantity of the current Part line Id.	No
RSASCH_WH_NO	_varchar_10	varchar(10)	Yes	This field is Used to store Warehouse No of the current schedule Line Id.	No
RSASCH_CREATEDDATE	_datetime_8	datetime(8)	No	This field is Used to store Created Date of the Current Schedule.	No
RSASCH_CREATED_BY	_varchar_30	varchar(30)	No	This field is Used to store Created User of the Current Schedule.	No
RSASCH_MODIFIEDDATE	_datetime_8	datetime(8)	No	This field is Used to store Last Modified Date of the Current Schedule.	No
RSASCH_MODIFIED_BY	_varchar_30	varchar(30)	No	This field is Used to store Last Modified User of the Current Schedule.	No

Table Name :	RSS_RAUAPC_AUTH_PC_DTL
Comment :	This table is Used to maintain the information for the Purchase Committe Details of the Amended RSS History Information.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
RAUAPC_RS_OUINSTANCE	_decimal_38_0	decimal(38)	No	This field is Used to store Release Slip Created OUInstance	Yes
RAUAPC_PC_CODE	_varchar_25	Varchar(25)	No	This field is Used to store Authorization Code.	Yes
RAUAPC_RS_NO	_varchar_40	varchar(40)	No	This field is Used to store Release Slip No.	Yes
RAUAPC_EMP_CODE	_varchar_20	varchar(20)	No	This field is Used to store Employee Code who authorize the document.	Yes
RAUAPC_AMEND_NO	_decimal_38_0	decimal(38)	No	This field is Used to store Amended Date.	Yes
RAUAPC_MEMBER_AUTH_STATUS	_varchar_5	varchar(5)	Yes	This field is Used to store the Memebers authorised Status.	No
RAUAPC_AUTH_BY	_varchar_30	varchar(30)	Yes	This field is Used to store Authorized By user.	No
RAUAPC_AUTH_DATE	_datetime_8	datetime(8)	Yes	This field is Used to store Authorized date.	No

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

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
RAUAPD_RS_OUINSTANCE	_decimal_38_0	decimal(38)	No	This field is Used to store Release Slip Created OUInstance	Yes
RAUAPD_LVL_PC_CODE	_varchar_25	Varchar(25)	No	This field is Used to store Level or Purchase Comitte Code.	Yes
RAUAPD_RS_NO	_varchar_40	varchar(40)	No	This field is Used to store Release Slip No.	Yes
RAUAPD_SEQ_NO	_decimal_38_0	decimal(38)	No	This field is Used to store the running sequence No.	Yes
RAUAPD_AMEND_NO	_decimal_38_0	decimal(38)	No	This field is Used to store Last Amended No.	Yes
RAUAPD_TYPE	_varchar_5	varchar(5)	Yes	This field is Used to store the authorization Type.	No
RAUAPD_NO_MEMBERS	_decimal_38_0	decimal(38)	Yes	This field is Used to store no of members who are authorize the document.	No
RAUAPD_PC_TYPE	_varchar_5	varchar(5)	Yes	This field is Used to store the Authorization type (leavel/Purchase Committe)	No
RAUAPD_PC_QUROUM	_decimal_38_0	decimal(38)	Yes	This field is Used to store the Authorization quroum information.	No
RAUAPD_MEMBERS_AUTHORIZED	_decimal_38_0	decimal(38)	Yes	This field is Used to store the total no of the members who are already authorized.	No
RAUAPD_LVL_PC_AUTH_STATUS	_varchar_5	varchar(5)	Yes	This field is Used to store the current authorization status of the Release Slip.	No
RAUAPD_LAST_AUTHORIZED_BY	_varchar_30	varchar(30)	Yes	This field is Used to store the last member who authorized the document.	No
RAUAPD_LAST_AUTH_DATE	_datetime_8	datetime(8)	Yes	This field is Used to store the date of last member who authorized the document.	No

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

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
RSAAD_RS_OUINSTANCE	_decimal_38_0	decimal(38)	No	This field is Used to store Release Slip Created OUInstance	Yes
RSAAD_AUTH_LEVEL_PC	_varchar_25	Varchar(25)	No	This field is Used to store the Audit Trial Leavel or Purchase Committe code.	No
RSAAD_RS_NO	_varchar_40	varchar(40)	No	This field is Used to store Release Slip No.	Yes
RSAAD_DATE_AND_TIME	_datetime_8	datetime(8)	Yes	This field is Used to store the Date and time of the Audit Trial performed.	No
RSAAD_AUDIT_TRAIL_ID	_decimal_38_0	decimal(38)	No	This field is Used to store the Audit Trial running sequence No.	Yes
RSAAD_REMARKS	_varchar_255	varchar(255)	Yes	This field is Used to store the Audit Trial Remarks.	No
RSAAD_STATUS_FROM	_varchar_15	varchar(15)	Yes	This field is Used to store the from status when the Audit Trial is performed.	No
RSAAD_STATUS_TO	_varchar_15	varchar(15)	Yes	This field is Used to store the To status when the Audit Trial is performed.	No
RSAAD_USER_NAME	_varchar_30	varchar(30)	Yes	This field is Used to store the User who performed the Audit Trial.	No

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

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
RSAINS_ATTRIBUTE_CODE	_varchar_40	varchar(40)	No	This field is Used to store Attribute code of the Current Part Line Id (Display Only)	No
RSAINS_RS_OUINSTANCE	_decimal_38_0	decimal(38)	No	This field is Used to store Release Slip Created OUInstance	Yes
RSAINS_RS_NO	_varchar_40	varchar(40)	No	This field is Used to store Release Slip No.	Yes
RSAINS_AMEND_NO	_decimal_38_0	decimal(38)	No	This field is Used to store the Amendment No of the Release Slip.	Yes
RSAINS_ATTRIBUTE_TYPE	_varchar_5	varchar(5)	Yes	This field is Used to store Attribute type of the Current attribute.	No
RSAINS_RS_ATTRIBUTE_ID	_varchar_40	varchar(40)	No	This field is Used to store Attribute Id of the Current Part Line Id(Running No)	Yes
RSAINS_RS_LINE_ID	_decimal_38_0	decimal(38)	No	This field is Used to store Release Slip Part Line Id.	Yes
RSAINS_MAXIMUM_VALUE	_decimal_28_8	decimal(28)	Yes	This field is Used to store Maximum Attribute value of the Current attribute.	No
RSAINS_ATTRIBUTE_OU	_decimal_38_0	decimal(38)	Yes	This field is Used to store Attribute Created OUInstance.	No
RSAINS_MINIMUM_VALUE	_decimal_28_8	decimal(28)	Yes	This field is Used to store Minimum Attribute value of the Current attribute.	No
RSAINS_REMARKS	_varchar_255	varchar(255)	Yes	This field is Used to store Remarks Information of the Current attribute. .	No
RSAINS_STANDARD_VALUE	_decimal_28_8	decimal(28)	Yes	This field is Used to store standatd Attribute value of the Current attribute.	No
RSAINS_STD_QUAL_VALUE	_varchar_80	varchar(80)	Yes	This field is Used to store standatd Quality value of the Current attribute.	No
RSAINS_TRACKABLE	_varchar_5	varchar(5)	Yes	This field is Used to store Trackable Information of the Current attribute. "Y" - "Yes", "N" - "No".	No
RSAINS_STD_MIN_VALUE	_decimal_28_8	decimal(28)	Yes	This field is Used to store standatd Minimum Attribute value of the Current attribute.	No
RSAINS_STD_MAX_VALUE	_decimal_28_8	decimal(28)	Yes	This field is Used to store standatd Maximum Attribute value of the Current attribute.	No
RSAINS_CREATEDDATE	_datetime_8	datetime(8)	No	This field is Used to store Created Date of the Current attribute.	No
RSAINS_CREATED_BY	_varchar_30	varchar(30)	No	This field is Used to store Created User of the Current attribute.	No
RSAINS_MODIFIEDDATE	_datetime_8	datetime(8)	No	This field is Used to store Last Modified Date of the Current attribute.	No
RSAINS_MODIFIED_BY	_varchar_30	varchar(30)	No	This field is Used to store Last Modified User of the Current attribute.	No

Table Name :	RSS_RSAPC_AUTH_PC_DTL
Comment :	User To Store the Authorization Details of the Purchase Committe

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
RSAPC_RS_OUINSTANCE	_decimal_38_0	decimal(38)	No	This field is Used to store Release Slip Created OUInstance	Yes
RSAPC_RS_NO	_varchar_40	varchar(40)	No	This field is Used to store Release Slip No.	Yes
RSAPC_PC_CODE	_varchar_25	Varchar(25)	No	This field is Used to store Authorization Code.	Yes
RSAPC_EMP_CODE	_varchar_20	varchar(20)	No	This field is Used to store Employee Code who authorize the document.	Yes
RSAPC_MEMBER_AUTH_STATUS	_varchar_5	varchar(5)	Yes	This field is Used to store the Memebers authorised Status.	No
RSAPC_AUTH_BY	_varchar_30	varchar(30)	Yes	This field is Used to store Authorized By user.	No
RSAPC_AUTH_DATE	_datetime_8	datetime(8)	Yes	This field is Used to store Authorized date.	No

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

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
RSAPDT_RS_OUINSTANCE	_decimal_38_0	decimal(38)	No	This field is Used to store Release Slip Created OUInstance	Yes
RSAPDT_ALTERNATE_PART_NO	_varchar_40	varchar(40)	Yes	This field is Used to store Alternate part No of the current Line Id s part No.	No
RSAPDT_RS_NO	_varchar_40	varchar(40)	No	This field is Used to store Release Slip No.	Yes
RSAPDT_AMEND_NO	_decimal_38_0	decimal(38)	No	This field is Used to store Amended No.	Yes
RSAPDT_BPO_LINE_NO	_decimal_38_0	decimal(38)	No	This field is Used to store Part Line id of the reference Blanket Purchase Order.	No
RSAPDT_COST_PER	_decimal_28_8	decimal(28)	No	This field is Used to store the Basic costper of the part in the current Line No.	No
RSAPDT_BPO_LINE_ID	_decimal_38_0	decimal(38)	No	This field is Used to store Part Line No of the reference Blanket Purchase Order.	No
RSAPDT_RS_LINE_ID	_decimal_38_0	decimal(38)	No	This field is Used to store Part Line No of the Release Slip No.(display Purpose)	Yes
RSAPDT_EARLIEST_DUE_DATE	_datetime_8	datetime(8)	Yes	This field is Used to store Earliest Due date of the Part if it belongs to the Single schedule otherwise Null.	No
RSAPDT_INSPECTION_TYPE	_varchar_5	varchar(5)	Yes	This field is Used to store Inspection Type of the current part Line Id.	No
RSAPDT_PART_OUINSTANCE	_decimal_38_0	decimal(38)	No	This field is Used to store Part Created OUInstance of the reference Part.	No
RSAPDT_LINE_NO	_decimal_38_0	decimal(38)	No	release slip line no	No
RSAPDT_LINE_ITEM_COST	_decimal_28_8	decimal(28)	No	This field is Used to store the Basic cost of the part in the current Line No.	No
RSAPDT_LINE_ITEM_VALUE	_decimal_28_8	decimal(28)	No	This field is Used to store the Basic amount of the part in the current Line No.	No
RSAPDT_MATCHING_TYPE	_varchar_5	varchar(5)	Yes	This field is Used to store Matching Type of the current part Line Id.	No
RSAPDT_ORDER_QUANTITY	_decimal_28_8	decimal(28)	No	This field is Used to store Part Level order Quantity of the Release Slip.	No
RSAPDT_LINE_TCD_AMT	_decimal_28_8	decimal(28)	Yes	This field is Used to store the Part Level TCD amount of the current Line No.	No
RSAPDT_PART_NO	_varchar_40	varchar(40)	No	This field is Used to store Part No of the Release Slip Document.	No
RSAPDT_WH_OUINSTANCE	_decimal_38_0	decimal(38)	Yes	This field is Used to store the storage Location OUInstance Informationo of the current Part.	No
RSAPDT_PART_CONDITION	_varchar_5	varchar(5)	Yes	This field is Used to store Part Condition of the Release Slip Document.	No
RSAPDT_PURCHASE_UOM	_varchar_10	varchar(10)	No	This field is Used to store the Purchase Unit Of measurment of the Part line Id.	No
RSAPDT_QUALITY_ATTRIBUTE	_varchar_5	varchar(5)	Yes	This field is Used to store Quantity Attribute of the current part Line Id.(Yes/No)	No
RSAPDT_SCHEDULE_TYPE	_varchar_25	Varchar(25)	No	This field is Used to store Schedule Information of the Part Line id. "S" - "Single", "M" - "Multiple".	No
RSAPDT_SHIP_TO_OUINSTANCE	_decimal_38_0	decimal(38)	No	This field is Used to store the ship to OUInstance information of the part in the current Line No.	No
RSAPDT_TOLERANCE_PERC	_decimal_28_8	decimal(28)	Yes	This field is Used to store Tolerance percentage of the current part Line Id if the tolerance type other than None.	No
RSAPDT_TOLERANCE_TYPE	_varchar_5	varchar(5)	Yes	This field is Used to store Tolerance Type of the current part Line Id.	No
RSAPDT_GR_ACCPT_QTY	_decimal_28_8	decimal(28)	Yes	GR accepted quantity	No
RSAPDT_GR_RECD_QTY	_decimal_28_8	decimal(28)	Yes	GR received quantity	No
RSAPDT_REMARKS	_varchar_255	varchar(255)	Yes	This field is Used to store Remarks of the current part Line Id.	No
RSAPDT_CREATEDDATE	_datetime_8	datetime(8)	No	This field is Used to store Created Date of the current part Line Id.	No
RSAPDT_CREATED_BY	_varchar_30	varchar(30)	No	This field is Used to store Created user of the current part Line Id.	No
RSAPDT_MODIFIEDDATE	_datetime_8	datetime(8)	No	This field is Used to store Last Modified date of the current part Line Id.	No
RSAPDT_MODIFIED_BY	_varchar_30	varchar(30)	No	This field is Used to store Last Modified user of the current part Line Id.	No
RSAPDT_RCPT_POS_TOL	_decimal_28_8	decimal(28)	Yes	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
RSAPDT_RCPT_NEG_TOL	_decimal_28_8	decimal(28)	Yes	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

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

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
RSAPD_RS_OUINSTANCE	_decimal_38_0	decimal(38)	No	This field is Used to store Release Slip Created OUInstance	Yes
RSAPD_RS_NO	_varchar_40	varchar(40)	No	This field is Used to store Release Slip No.	Yes
RSAPD_LVL_PC_CODE	_varchar_25	Varchar(25)	No	This field is Used to store Level or Purchase Comitte Code. .	Yes
RSAPD_SEQ_NO	_decimal_38_0	decimal(38)	No	This field is Used to store the running sequence No.	Yes
RSAPD_TYPE	_varchar_5	varchar(5)	Yes	This field is Used to store the authorization Type.	No
RSAPD_NO_MEMBERS	_decimal_38_0	decimal(38)	Yes	This field is Used to store no of members who are authorize the document.	No
RSAPD_PC_TYPE	_varchar_5	varchar(5)	Yes	This field is Used to store the Authorization type (leavel/Purchase Committe)	No
RSAPD_PC_QUROUM	_decimal_38_0	decimal(38)	Yes	This field is Used to store the Authorization quroum information.	No
RSAPD_MEMBERS_AUTHORIZED	_decimal_38_0	decimal(38)	Yes	This field is Used to store the total no of the members who are already authorized.	No
RSAPD_LVL_PC_AUTH_STATUS	_varchar_5	varchar(5)	Yes	This field is Used to store the current authorization status of the Release Slip.	No
RSAPD_LAST_AUTHORIZED_BY	_varchar_30	varchar(30)	Yes	This field is Used to store the last member who authorized the document.	No
RSAPD_LAST_AUTH_DATE	_datetime_8	datetime(8)	Yes	This field is Used to store the date of last member who authorized the document.	No

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

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
RSAPR_RS_OUINSTANCE	_decimal_38_0	decimal(38)	No	This field is Used to store Release Slip Created OUInstance	Yes
RSAPR_RS_NO	_varchar_40	varchar(40)	No	This field is Used to store Release Slip No.	Yes
RSAPR_AMEND_NO	_decimal_38_0	decimal(38)	No	This field is Used to store Amendment no of the Release Slip No.	Yes
RSAPR_RS_LINE_ID	_decimal_38_0	decimal(38)	No	This field is Used to store Part Line Id of the Release Slip No	Yes
RSAPR_RS_SEQNO	_decimal_38_0	decimal(38)	No	Holds the running serial number to differentiate each record	Yes
RSAPR_RS_COVERED_QTY	_decimal_28_8	decimal(28)	Yes	This field is Used to store Covered PR Quantity in the Release Slip Component.	No
RSAPR_RS_SCH_ID	_decimal_38_0	decimal(38)	No	This field is Used to store Schedule Id of the Part Line ID.	Yes
RSAPR_PR_NO	_varchar_40	varchar(40)	No	This field is Used to store Reference Purchase Request Document.	No
RSAPR_PR_LINE_NO	_decimal_38_0	decimal(38)	No	This field is Used to store Reference Purchase Request Document Part Line Id.	No
RSAPR_PR_OUINSTANCE	_decimal_38_0	decimal(38)	No	This field is Used to store PR Created OUInstance.	No
RSAPR_PR_SCHEDULE_NO	_decimal_38_0	decimal(38)	No	purchase request schedule no	No
RSAPR_CREATEDDATE	_datetime_8	datetime(8)	No	This field is Used to store PR Based Rss Schedule created Date	No
RSAPR_CREATED_BY	_varchar_30	varchar(30)	No	This field is Used to store PR Based Rss Schedule created User	No
RSAPR_MODIFIEDDATE	_datetime_8	datetime(8)	No	This field is Used to store Laet Modified PR Based Rss Schedule Date	No
RSAPR_MODIFIED_BY	_varchar_30	varchar(30)	No	This field is Used to store Laet Modified PR Based Rss Schedule User.	No

Table Name :	RSS_RSATC_RS_TERMS_CONDN
Comment :	Used to store the Terms and Condition detaisl for the amended RSS Document History

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
RSATC_RS_OUINSTANCE	_decimal_38_0	decimal(38)	No	This field is Used to store Release Slip Created OUInstance	Yes
RSATC_DELIVERY_POINT	_varchar_255	varchar(255)	Yes	This field is Used to store the Delivery Point of the Release Slip Document.	No
RSATC_RS_NO	_varchar_40	varchar(40)	No	This field is Used to store Release Slip No.	Yes
RSATC_INCO_TERM	_varchar_150	varchar(150)	Yes	This field is Used to store the INCO of the Release Slip Document.	No
RSATC_AMEND_NO	_decimal_38_0	decimal(38)	No	release slip amendmant no	Yes
RSATC_INSUR_AMOUNT	_decimal_28_8	decimal(28)	Yes	This field is Used to store the Insurance Amount of the Release Slip Document.	No
RSATC_INSUR_LIABILITY	_varchar_5	varchar(5)	Yes	This field is Used to store the Insurance Liability of the Release Slip Document. "SF" - "Self", "B" - "None", "SS" - "Suppliers".	No
RSATC_INSUR_TERMS	_varchar_150	varchar(150)	Yes	This field is Used to store the Insurance Terms of the Release Slip Document.	No
RSATC_PAY_TERM_OU	_decimal_38_0	decimal(38)	Yes	This field is Used to store associated Pay Term Created OUInstance of the Release Slip Document.	No
RSATC_MODE_OF_TRANSPORT	_varchar_150	varchar(150)	Yes	This field is Used to store the Transport Mode	No
RSATC_PACKAGING_TERMS	_varchar_150	varchar(150)	Yes	This field is Used to store the Packaging Code of the Release Slip Document.	No
RSATC_PAY_TERM	_varchar_25	Varchar(25)	Yes	This field is Used to store associated Pay Term of the Release Slip Document.	No
RSATC_PAY_TO_SUPPLIER_NO	_varchar_45	varchar(45)	Yes	This field is Used to store the Pay to Supplier Created OUInstance of the Release Slip Document.	No
RSATC_PAYMENT_MODE	_varchar_5	varchar(5)	Yes	This field is Used to store Pay Mode of the Release Slip Document.	No
RSATC_PAYMENT_PRIORITY	_varchar_25	Varchar(25)	Yes	This field is Used to store Payment priority of the Release Slip Document "H" - "High", "L" - "Low", "N" - "Normal".	No
RSATC_SHIP_BY	_varchar_25	Varchar(25)	Yes	This field is Used to store the Ship By Mode Of the Release Slip Document.	No
RSATC_SHIP_PAYMENT	_varchar_25	Varchar(25)	Yes	This field is Used to store Pay Mode of the Release Slip Document	No
RSATC_REMARKS	_varchar_255	varchar(255)	Yes	this field is used to store the remarks comments	No
RSATC_SHIP_PARTIAL	_varchar_5	varchar(5)	Yes	This field is Used to store the Packaging Code of the Release Slip Document. "Y" - "Yes", "N" - "No".	No
RSATC_TRANSSHIPMENT	_varchar_5	varchar(5)	Yes	This field is Used to store the Trans Shipment of the Release Slip Document. "Y" - "Yes", "N" - "No".	No
RSATC_CREATEDDATE	_datetime_8	datetime(8)	No	This field is Used to store the Terms and codition created Date	No
RSATC_CREATED_BY	_varchar_30	varchar(30)	No	This field is Used to store the Terms and codition created user.	No
RSATC_MODIFIEDDATE	_datetime_8	datetime(8)	No	This field is Used to store the Terms and codition last Modifed Date.	No
RSATC_MODIFIED_BY	_varchar_30	varchar(30)	No	This field is Used to store the Terms and codition last Modifed User.	No
RSATC_ADV_PAYABLE	_varchar_5	varchar(5)	Yes	stores ths flag whether advance is payable or not. "Y" - "Yes", "N" - "No".	No
RSATC_ADV_PAY_BYDATE	_datetime_8	datetime(8)	Yes	stores the date by which advance is payable	No
RSATC_ADV_PERCENT	_decimal_28_8	decimal(28)	Yes	stores the value of advance percentage.	No
RSATC_ADV_PER_ON	_varchar_5	varchar(5)	Yes	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
RSATC_ADV_PAYABLE_VAL	_decimal_28_8	decimal(28)	Yes	stores the advance payable value	No
RSATC_ADV_TOL_PERC	_decimal_28_8	decimal(28)	Yes	stores the advance tolerance percentage	No
RSATC_PAY_MODE	_varchar_5	varchar(5)	Yes	stores the flag for the payment mode CS - Cash CQ - Cheque DD - Demand Draft P - Pay Order	No
RSATC_DDCHRGS_BORNEBY	_varchar_5	varchar(5)	Yes	stores the flag which identifies that the DD charges will be borne by whom "SE" - "Self", "SU"- "Supplier".	No
RSATC_PAYTO_SUPP_ADDRID	_decimal_38_0	decimal(38)	Yes	stores the pay to supplier s address id.	No
RSATC_PAYMENT_NOTES	_varchar_2000	varchar(2000)	Yes	stores the payment notes	No
RSATC_WARRANTY	_varchar_5	varchar(5)	Yes	stores the flag whether warranty is yes or no Y- Yes N - No B - Blank	No
RSATC_WARRANTY_BASIS	_varchar_5	varchar(5)	Yes	stores the flag to indicate the warranty basis "C"- "Calendar", "U" - "Usage" "BH" - "Both".	No
RSATC_WARR_AGRMT_NO	_varchar_40	varchar(40)	Yes	stores the warrany agreement number	No
RSATC_PACKAGING_NOTES	_varchar_2000	varchar(2000)	Yes	stores the packaging notes	No
RSATC_PORT_OF_DEPARTURE	_varchar_40	varchar(40)	Yes	stores the port of departure	No
RSATC_CARRIER_AGENCY_NO	_varchar_40	varchar(40)	Yes	stores the carrier/agency number	No
RSATC_SHIPPING_PAYMENT	_varchar_40	varchar(40)	Yes	stores the shipping payment detail	No
RSATC_SHIPPING_NOTES	_varchar_2000	varchar(2000)	Yes	stores the shipping notes	No
RSATC_GTA_REFNO	_varchar_40	varchar(40)	Yes	stores the General terms and agreement reference number	No
RSATC_REF_DOC_DATE	_datetime_8	datetime(8)	Yes	stores the reference document date	No
RSATC_GTA_REMARKS	_varchar_255	varchar(255)	Yes	stores the General terms and agreement Remarks	No
RSATC_PAY_TO_SUPPLIER_OU	_decimal_38_0	decimal(38)	Yes	stores the OU instance of the pay to supplier	No

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

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
RSAUI_RS_OUINSTANCE	_decimal_38_0	decimal(38)	No	This field is Used to store Release Slip Created OUInstance	Yes
RSAHD_RS_NO	_varchar_40	varchar(40)	No	This field is Used to store Release Slip No.	Yes
RSAUI_AMEND_NO	_decimal_38_0	decimal(38)	No	This field is Used to store Last amended No.	Yes
RSAUI_USER_DEF_DESC1	_varchar_30	varchar(30)	Yes	This field is Used to store USer Defined Desctiption -1 of the Release Slip	No
RSAUI_USER_DEF_OPT1	_varchar_30	varchar(30)	Yes	This field is Used to store USer Defined Option-1 of the Release Slip	No
RSAUI_USER_DEF_DESC2	_varchar_30	varchar(30)	Yes	This field is Used to store USer Defined Desctiption -2 of the Release Slip	No
RSAUI_USER_DEF_OPT2	_varchar_30	varchar(30)	Yes	This field is Used to store USer Defined Option-2 of the Release Slip	No
RSAUI_USER_DEF_DESC3	_varchar_30	varchar(30)	Yes	This field is Used to store USer Defined Desctiption -3 of the Release Slip	No
RSAUI_USER_DEF_OPT3	_varchar_30	varchar(30)	Yes	This field is Used to store USer Defined Option-3 of the Release Slip	No
RSAUI_USER_DEF_DESC4	_varchar_30	varchar(30)	Yes	This field is Used to store USer Defined Desctiption -4 of the Release Slip	No
RSAUI_USER_DEF_OPT4	_varchar_30	varchar(30)	Yes	This field is Used to store USer Defined Option-4 of the Release Slip	No
RSAUI_USER_DEF_REMARKS	_varchar_255	varchar(255)	Yes	This field is Used to store the remarks of the User Defined information.	No
RSAUI_CREATED_DATE	_datetime_8	datetime(8)	No	This field is Used to store User defined Information Created Date of the release Slip.	No
RSAUI_CREATED_BY	_varchar_30	varchar(30)	No	This field is Used to store User defined Information Created user	No
RSAUI_MODIFIED_DATE	_datetime_8	datetime(8)	No	This field is Used to store last modified date of the User defined Information.	No
RSAUI_MODIFIED_BY	_varchar_30	varchar(30)	No	This field is Used to store last modified user of the User defined Information.	No

Table Name :	RSS_RSDTCD_DOC_TCD_DTL
Comment :	Used to Store the Document Level TCD Details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
RSDTCD_RS_OUINSTANCE	_decimal_38_0	decimal(38)	No	This field is Used to store Release Slip Created OUInstance	Yes
RSDTCD_TCD_OU	_decimal_38_0	decimal(38)	Yes	This field is Used to store Tcd Created OUInstance Of the current Tcd Line id.	No
RSDTCD_RS_NO	_varchar_40	varchar(40)	No	This field is Used to store Release Slip No.	Yes
RSDTCD_TCD_LINE_ID	_decimal_38_0	decimal(38)	No	This field is Used to store Tcd Line ID of the Release Slip Document.(running No)	Yes
RSDTCD_TCD_CODE	_varchar_25	Varchar(25)	Yes	This field is Used to store Tcd Code of the current Tcd Line id.	No
RSDTCD_TCD_AMOUNT	_decimal_28_8	decimal(28)	Yes	This field is Used to store amount of the Tcd Code.	No
RSDTCD_TCD_RATE	_decimal_28_8	decimal(28)	Yes	This field is Used to store rate of the Tcd Code.	No
RSDTCD_TCD_VARIANT	_varchar_25	Varchar(25)	Yes	This field is Used to store Tcd Variant Code of the current Tcd Line id.	No
RSDTCD_CREATEDDATE	_datetime_8	datetime(8)	No	This field is Used to store Tcd Line Id Created date.	No
RSDTCD_CREATED_BY	_varchar_30	varchar(30)	No	This field is Used to store Tcd Line Id Created user.	No
RSDTCD_MODIFIEDDATE	_datetime_8	datetime(8)	No	This field is Used to store last modified date of the Tcd Line Id.	No
RSDTCD_MODIFIED_BY	_varchar_30	varchar(30)	No	This field is Used to store last modified user of the Tcd Line Id.	No
RSDTCD_USER_SEQ_NO	_decimal_38_0	decimal(38)	Yes	stores user entered sequence number for the TCD code	No
RSDTCD_CURRENCY	_varchar_20	varchar(20)	Yes	stores the currency chosen in the multiline for the TCD code	No
RSDTCD_EXCHG_RATE	_decimal_28_8	decimal(28)	Yes	Holds the exchage rate between the document currency and the payment currency	No
RSDTCD_PAY_TO_SUPP	_varchar_45	varchar(45)	Yes	stores the supplier code to whom the payment has to be made	No
RSDTCD_PAYTOSUPP_OU	_decimal_38_0	decimal(38)	Yes	Stores the pay to supplier s OU	No
RSDTCD_CHRG_TYPE	udd_designparamcode	varchar(5)	No	this field holds the Notional TCD charge type for the Document TCD	No
RSDTCD_TCD_INCIDENCE	udd_taxinci	Varchar(40)	Yes	This field holds the TCD Incidence	No

Table Name :	RSS_RSHD_RELEASE_SLIP_HDR
Comment :	This Table is Used to store the Release Slip Dcument Information With Latest Amemend Number.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
RSHD_RS_OUINSTANCE	_decimal_38_0	decimal(38)	No	This field is Used to store Release Slip Created OUInstance	Yes
RSHD_RS_NO	_varchar_40	varchar(40)	No	This field is Used to store Release Slip No.	Yes
RSHD_LAT_AMEND_NO	_decimal_38_0	decimal(38)	No	This field is Used to store the Latest amendment No of the Release Slip if any Otherwise 0.	No
RSHD_BPO_OUINSTANCE	_decimal_38_0	decimal(38)	No	This field is Used to store reference Blanket Purchase Order s created OUInstance.	No
RSHD_BPO_NO	_varchar_40	varchar(40)	No	This field is Used to store reference Blanket Purchase Order No.	No
RSHD_BPO_AMEND_NO	_decimal_38_0	decimal(38)	No	This field is Used to store reference Blanket Purchase Order amendent No.	No
RSHD_RS_TYPE	_varchar_5	varchar(5)	No	This field is Used to store the Type of Release Slip No. "B" - " Blank", "N" - "Normal", "E" - "Express".	No
RSHD_RS_DATE	_datetime_8	datetime(8)	No	This field is Used to store the Type of Release Slip No created Date.	No
RSHD_RS_BUYER_GROUP_OU	_decimal_38_0	decimal(38)	Yes	This field is Used to store the buyer Group OUInstance in which the Release Slip ctrated user belongs to.	No
RSHD_RS_BUYER_GROUP	_varchar_25	Varchar(25)	Yes	This field is Used to store the buyer Group No in which the Release Slip ctrated user belongs to.	No
RSHD_RS_SUPPLIER_OU	_decimal_38_0	decimal(38)	No	This field is Used to store the Supplier OUInstance in the Release Slip	No
RSHD_RS_SUPPLIER_NO	_varchar_40	varchar(40)	No	This field is Used to store the Suppliercode in the Release Slip	No
RSHD_RS_PRIORITY	_varchar_20	varchar(20)	Yes	This field is Used to store the Priority No for the Release Slip No.	No
RSHD_RS_AC_REGN_NO	_varchar_30	varchar(30)	Yes	This field is Used to store the Aircraft Registration No if the priority is AOG, otherwise Null.	No
RSHD_RS_USER_STATUS	_varchar_25	Varchar(25)	Yes	release slip user status. "B" - "Blank".	No
RSHD_RS_CATEGORY	_varchar_25	Varchar(25)	Yes	This field is Used to store the Category information of the release Slip No. "B" - "Blank".	No
RSHD_RS_BASIC_VALUE	_decimal_28_8	decimal(28)	Yes	This field is Used to store Basic Value of the release Slip in terms of the trasaction Currency.	No
RSHD_TOT_LINE_TCD_AMT	_decimal_28_8	decimal(28)	Yes	This field is Used to store sum of Part level TCD values of the release Slip in terms of the trasaction Currency.	No
RSHD_TOT_DOC_TCD_AMT	_decimal_28_8	decimal(28)	Yes	This field is Used to strore Document level TCD values of the release Slip in terms of the trasaction Currency.	No
RSHD_RS_CURRENCY_OU	_decimal_38_0	decimal(38)	No	This field is Used to strore trasaction Currency Ouinstance of the Release Slip.	No
RSHD_RS_CURRENCY	_varchar_20	varchar(20)	No	This field is Used to strore trasaction Currency of the Release Slip.	No
RSHD_RS_BASE_CURRENCY	_varchar_20	varchar(20)	No	This field is Used to strore Basic Currency of the Release Slip.(ie Company currency)	No
RSHD_RS_EXCHANGE_RATE_OU	_decimal_38_0	decimal(38)	No	This field is Used to store Exchange rate creatd OUInstance.	No
RSHD_RS_EXCHANGE_RATE	_decimal_28_8	decimal(28)	No	This field is Used to store Exchange rate between the transaction and the Basic Currency.	No
RSHD_RS_BASIC_CUR_VALUE	_decimal_28_8	decimal(28)	Yes	This field is Used to store Basic Value of the release Slip in terms of the Basic(Company) Currency.	No
RSHD_RS_PART_TYPE	_varchar_5	varchar(5)	No	This field is Used to store Part Types in which the Release Slip Parts belongs to.	No
RSHD_RS_QUALITY	_varchar_5	varchar(5)	No	This field is Used to store Quality attribute of the Release Slip. "Y" - "Yes", "N" - "No".	No
RSHD_AUTH_TERLEVEL	_varchar_25	Varchar(25)	Yes	This field is Used to store the Terminating Authorization leavel of the Release Slip.	No
RSHD_AUTH_MINVAL	_decimal_28_8	decimal(28)	Yes	This field is Used to store the Minimum Authorization value of the Release Slip.	No
RSHD_AUTH_MAXVAL	_decimal_28_8	decimal(28)	Yes	This field is Used to store the Maximum Authorization value of the Release Slip.	No
RSHD_AUTH_NXTLVLPC	_varchar_25	Varchar(25)	Yes	This field is Used to store the Next Leavel Purchase Commite Information of the Release Slip.	No
RSHD_AUTH_TYPE	_varchar_5	varchar(5)	Yes	This field is Used to store Authorization Type either Leavel, Purchase Committe.	No
RSHD_AUTH_STAGE	_varchar_80	varchar(80)	Yes	This field is Used to store the current stages of the Authorization leavel.	No
RSHD_RS_AUTH_REASON	_varchar_255	varchar(255)	Yes	This field is Used to store the reason for the Authorization of the Release Slip.	No
RSHD_RS_CAN_REASON	_varchar_255	varchar(255)	Yes	This field is Used to store the reason for the Cancellation the Release Slip.	No
RSHD_RS_SCL_REASON	_varchar_255	varchar(255)	Yes	This field is Used to store the reason for the Short Close the Release Slip.	No
RSHD_RS_HLD_REASON	_varchar_255	varchar(255)	Yes	This field is Used to store the reason for the Holding the Release Slip.	No
RSHD_RS_REL_REASON	_varchar_255	varchar(255)	Yes	This field is Used to store the reason for the Releasing the Release Slip.	No
RSHD_RS_STATUS	_varchar_15	varchar(15)	Yes	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" -	No
RSHD_CREATEDDATE	_datetime_8	datetime(8)	No	This field is Used to store the Created Date of the Release Slip.	No
RSHD_CREATED_BY	_varchar_30	varchar(30)	No	This field is Used to store the Created user of the Release Slip.	No
RSHD_MODIFIEDDATE	_datetime_8	datetime(8)	Yes	This field is Used to store the last Modified date of the Release Slip.	No
RSHD_MODIFIED_BY	_varchar_30	varchar(30)	Yes	This field is Used to store the last Modified user of the Release Slip.	No
RSHD_AUTHORISEDDATE	_datetime_8	datetime(8)	Yes	This field is Used to store the Authorization date of the Release Slip.	No
RSHD_AUTHORISED_BY	_varchar_30	varchar(30)	Yes	This field is Used to store the user who authorized the Release Slip.	No
RSHD_AMENDEDDATE	_datetime_8	datetime(8)	Yes	This field is Used to store the ameded date of the Release Slip.	No
RSHD_AMENDED_BY	_varchar_30	varchar(30)	Yes	This field is Used to store the user who amended the Release Slip.	No
RSHD_CONFIRMEDDATE	_datetime_8	datetime(8)	Yes	This field is Used to confirmation date of the Release Slip.	No
RSHD_CONFIRMED_BY	_varchar_30	varchar(30)	Yes	This field is Used to store the used who performed the confirmation of the Release Slip.	No
RSHD_TIMESTAMP	_decimal_38_0	decimal(38)	No	This field is Used to store the latest timestamp of the Release Slip No.	No
RSHD_RS_NUMTYPE	_varchar_5	varchar(5)	Yes	stores the numbering type number of release slip transaction	No
RSHD_WF_DOC_KEY	_varchar_80	varchar(80)	Yes	this field is used to store the work flow Release Slip No	No

Table Name :	RSS_RSINS_RS_INSPECT_DTL
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.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
RSINS_RS_OUINSTANCE	_decimal_38_0	decimal(38)	No	This field is Used to store Release Slip Created OUInstance	Yes
RSINS_ATTRIBUTE_CODE	_varchar_40	varchar(40)	No	This field is Used to store Attribute code of the Current Part Line Id (Display Only)	No
RSINS_RS_NO	_varchar_40	varchar(40)	No	This field is Used to store Release Slip No.	Yes
RSINS_RS_LINE_ID	_decimal_38_0	decimal(38)	No	This field is Used to store Release Slip Part Line Id.	Yes
RSINS_ATTRIBUTE_TYPE	_varchar_5	varchar(5)	Yes	This field is Used to store Attribute type of the Current attribute.	No
RSINS_ATTRIBUTE_OU	_decimal_38_0	decimal(38)	Yes	This field is Used to store Attribute Created OUInstance.	No
RSINS_RS_ATTRIBUTE_ID	_varchar_40	varchar(40)	No	This field is Used to store Attribute Id of the Current Part Line Id(Running No)	Yes
RSINS_MAXIMUM_VALUE	_decimal_28_8	decimal(28)	Yes	This field is Used to store Maximum Attribute value of the Current attribute.	No
RSINS_MINIMUM_VALUE	_decimal_28_8	decimal(28)	Yes	This field is Used to store Minimum Attribute value of the Current attribute.	No
RSINS_REMARKS	_varchar_255	varchar(255)	Yes	This field is Used to store Remarks Information of the Current attribute. .	No
RSINS_STD_VALUE	_decimal_28_8	decimal(28)	Yes	This field is Used to store standatd Attribute value of the Current attribute.	No
RSINS_STD_MIN_VALUE	_decimal_28_8	decimal(28)	Yes	This field is Used to store standatd Minimum Attribute value of the Current attribute.	No
RSINS_STD_MAX_VALUE	_decimal_28_8	decimal(28)	Yes	This field is Used to store standatd Maximum Attribute value of the Current attribute.	No
RSINS_STD_QUAL_VALUE	_varchar_80	varchar(80)	Yes	This field is Used to store standatd Quality value of the Current attribute.	No
RSINS_TRACKABLE	_varchar_5	varchar(5)	Yes	This field is Used to store Trackable Information of the Current attribute. "Y" - "Yes", "N" - "No".	No
RSINS_CREATEDDATE	_datetime_8	datetime(8)	No	This field is Used to store Created Date of the Current attribute.	No
RSINS_CREATED_BY	_varchar_30	varchar(30)	No	This field is Used to store Created User of the Current attribute.	No
RSINS_MODIFIEDDATE	_datetime_8	datetime(8)	No	This field is Used to store Last Modified Date of the Current attribute.	No
RSINS_MODIFIED_BY	_varchar_30	varchar(30)	No	This field is Used to store Last Modified User of the Current attribute.	No

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

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
RSPDT_RS_OUINSTANCE	_decimal_38_0	decimal(38)	No	This field is Used to store Release Slip Created OUInstance	Yes
RSPDT_RS_NO	_varchar_40	varchar(40)	No	This field is Used to store Release Slip No.	Yes
RSPDT_RS_LINE_ID	_decimal_38_0	decimal(38)	No	This field is Used to store Part Line Id of the Release Slip No.(runnign No)	Yes
RSPDT_RS_LINE_NO	_decimal_38_0	decimal(38)	No	This field is Used to store Part Line No of the Release Slip No.(display Purpose)	No
RSPDT_BPO_LINE_ID	_decimal_38_0	decimal(38)	No	This field is Used to store Part Line id of the reference Blanket Purchase Order.	No
RSPDT_BPO_LINE_NO	_decimal_38_0	decimal(38)	No	This field is Used to store Part Line No of the reference Blanket Purchase Order.	No
RSPDT_PART_OUINSTANCE	_decimal_38_0	decimal(38)	No	This field is Used to store Part Created OUInstance of the reference Part.	No
RSPDT_PART_NO	_varchar_40	varchar(40)	No	This field is Used to store Part No of the Release Slip Document.	No
RSPDT_PART_CONDITION	_varchar_5	varchar(5)	No	This field is Used to store Part Condition of the Release Slip Document. "B" - "Blank:, "N" - "New", "NS" - "New Surplus", "SER" - "Servicable".	No
RSPDT_RS_ORDER_QTY	_decimal_28_8	decimal(28)	No	This field is Used to store Part Level order Quantity of the Release Slip.	No
RSPDT_GR_RECD_QTY	_decimal_28_8	decimal(28)	Yes	This field is Used to store Quantity which received in the Goods Receipt against the Release Slip Part Line id.	No
RSPDT_GR_ACCPT_QTY	_decimal_28_8	decimal(28)	Yes	This field is Used to store Quantity which Accecpted in the Goods Receipt against the Release Slip Part Line id.	No
RSPDT_PURCHASE_UOM	_varchar_10	varchar(10)	No	This field is Used to store the Purchase Unit Of measurment of the Part line Id.	No
RSPDT_LINE_TCD_AMT	_decimal_28_8	decimal(28)	Yes	This field is Used to store the Part Level TCD amount of the current Line No.	No
RSPDT_LINE_ITEM_COST	_decimal_28_8	decimal(28)	No	This field is Used to store the Basic cost of the part in the current Line No.	No
RSPDT_COST_PER	_decimal_28_8	decimal(28)	No	This field is Used to store the Basic costper of the part in the current Line No.	No
RSPDT_LINE_ITEM_VALUE	_decimal_28_8	decimal(28)	No	This field is Used to store the Basic amount of the part in the current Line No.	No
RSPDT_SHIP_TO_OUINSTANCE	_decimal_38_0	decimal(38)	No	This field is Used to store the ship to OUInstance information of the part in the current Line No.	No
RSPDT_WH_OUINSTANCE	_decimal_38_0	decimal(38)	Yes	This field is Used to store the storage Location OUInstance Informationo of the current Part.	No
RSPDT_LINE_STATUS	_varchar_5	varchar(5)	No	This field is Used to store latest status of the current part Line Id.	No
RSPDT_SCHEDULE_TYPE	_varchar_25	Varchar(25)	No	This field is Used to store Schedule Information of the Part Line id. "S" - "Single", "M" - "Multiple".	No
RSPDT_EARLIEST_DUE_DATE	_datetime_8	datetime(8)	Yes	This field is Used to store Earliest Due date of the Part if it belongs to the Single schedule otherwise Null.	No
RSPDT_ALTERNATE_PART_NO	_varchar_40	varchar(40)	Yes	This field is Used to store Alternate part No of the current Line Id s part No.	No
RSPDT_INSPECTION_TYPE	_varchar_5	varchar(5)	Yes	This field is Used to store Inspection Type of the current part Line Id. "N" - "None", "SL" - "Self", "BI" - "By Inspector".	No
RSPDT_MATCHING_TYPE	_varchar_5	varchar(5)	Yes	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
RSPDT_TOLERANCE_TYPE	_varchar_5	varchar(5)	Yes	This field is Used to store Tolerance Type of the current part Line Id. "N" - "None", "VAL" - "Value", "QNTY" - "Quantity", "BT" - "Both".	No
RSPDT_TOLERANCE_PERC	_decimal_28_8	decimal(28)	Yes	This field is Used to store Tolerance percentage of the current part Line Id if the tolerance type other than None.	No
RSPDT_RCPT_POS_TOL	_decimal_28_8	decimal(28)	Yes	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
RSPDT_RCPT_NEG_TOL	_decimal_28_8	decimal(28)	Yes	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
RSPDT_QUALITY_ATTRIBUTE	_varchar_5	varchar(5)	Yes	This field is Used to store Quality Attribute of the current part Line Id "CUST" - "Customised", "N" - "None", "STD" - "Standard".	No
RSPDT_REMARKS	_varchar_255	varchar(255)	Yes	This field is Used to store Remarks of the current part Line Id.	No
RSPDT_CREATEDDATE	_datetime_8	datetime(8)	No	This field is Used to store Created Date of the current part Line Id.	No
RSPDT_CREATED_BY	_varchar_30	varchar(30)	No	This field is Used to store Created user of the current part Line Id.	No
RSPDT_MODIFIEDDATE	_datetime_8	datetime(8)	No	This field is Used to store Last Modified date of the current part Line Id.	No
RSPDT_MODIFIED_BY	_varchar_30	varchar(30)	No	This field is Used to store Last Modified user of the current part Line Id.	No
RSPDT_GR_REJ_QTY	udd_quantity	numeric(13)	Yes	This field is Used to store Quantity which rejected in the Goods Receipt against the Release Slip Part Line id.	No

Table Name :	RSS_RSPRM_PARAMETER_DTL
Comment :	Used to store the Parameter Values in the Rss Document

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
RSPRM_COMPONENTNAME	_varchar_20	varchar(20)	No	This field is Used to store Component Name Information.	Yes
RSPRM_PARAMCATEGORY	_varchar_10	varchar(10)	No	This field is Used to store Parameter Category.	Yes
RSPRM_PARAMTYPE	_varchar_25	Varchar(25)	No	This field is Used to store Parameter Type.	Yes
RSPRM_PARAMCODE	_varchar_5	varchar(5)	No	This field is Used to store Parameter Code.	Yes
RSPRM_LANGID	_decimal_38_0	decimal(38)	No	This field is Used to store Language Id Information.	Yes
RSPRM_PARAMDESC	_varchar_80	varchar(80)	Yes	This field is Used to store Parameter Description.	No
RSPRM_SORTBY	_decimal_38_0	decimal(38)	Yes	This field is Used to store sort By interms of the records.	No
RSPRM_CREATEDDATE	_datetime_8	datetime(8)	No	This field is Used to store Parameter Cretated Date.	No

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

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
RSPR_RS_OUINSTANCE	_decimal_38_0	decimal(38)	No	This field is Used to store Release Slip Created OUInstance	Yes
RSPR_RS_COVERED_QTY	_decimal_28_8	decimal(28)	No	This field is Used to store Covered PR Quantity in the Release Slip Component.	No
RSPR_RS_NO	_varchar_40	varchar(40)	No	This field is Used to store Release Slip No.	Yes
RSPR_RS_LINE_ID	_decimal_38_0	decimal(38)	No	This field is Used to store Part Line Id of the Release Slip No	Yes
RSPR_RS_SEQNO	_decimal_38_0	decimal(38)	No	Holds the running serial number to differentiate each record	Yes
RSPR_RS_SCH_ID	_decimal_38_0	decimal(38)	No	This field is Used to store Schedule Id of the Part Line ID.	Yes
RSPR_PR_NO	_varchar_40	varchar(40)	Yes	This field is Used to store Reference Purchase Request Document.	No
RSPR_PR_LINE_NO	_decimal_38_0	decimal(38)	Yes	This field is Used to store Reference Purchase Request Document Part Line Id.	No
RSPR_PR_OUINSTANCE	_decimal_38_0	decimal(38)	Yes	This field is Used to store Reference Purchase Request Document Created OUInstance.	No
RSPR_PR_SCHEDULE_NO	_decimal_38_0	decimal(38)	Yes	This field is Used to store Reference Purchase Request Document Schedule Id.	No
RSPR_CREATEDDATE	_datetime_8	datetime(8)	No	This field is Used to store PR Based Rss Schedule created Date	No
RSPR_CREATED_BY	_varchar_30	varchar(30)	No	This field is Used to store PR Based Rss Schedule created User	No
RSPR_MODIFIEDDATE	_datetime_8	datetime(8)	No	This field is Used to store Laet Modified PR Based Rss Schedule Date	No
RSPR_MODIFIED_BY	_varchar_30	varchar(30)	No	This field is Used to store Laet Modified PR Based Rss Schedule User.	No
RSPR_RS_GRMOVED_QTY	udd_quantity	numeric(13)	Yes	This field is Used to store GR moved quantity against covered PR in the Release Slip Component.	No

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

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
RSPTCD_RS_OUINSTANCE	_decimal_38_0	decimal(38)	No	This field is Used to store Release Slip Created OUInstance	Yes
RSPTCD_RS_NO	_varchar_40	varchar(40)	No	This field is Used to store Release Slip No.	Yes
RSPTCD_RS_LINE_ID	_decimal_38_0	decimal(38)	No	This field is Used to store Release Slip Part Line Id of the release Slip.	Yes
RSPTCD_TCD_OU	_decimal_38_0	decimal(38)	Yes	This field is Used to store Tcd Created OUInstance of the current TCD.	No
RSPTCD_TCD_CODE	_varchar_25	Varchar(25)	Yes	This field is Used to store Tcd Code Of the current Tcd line Id.	No
RSPTCD_TCD_AMOUNT	_decimal_28_8	decimal(28)	Yes	This field is Used to store Tcd amount of the current Tcd line Id.	No
RSPTCD_TCD_LINE_ID	_decimal_38_0	decimal(38)	No	This field is Used to store Part Level Tcd Line id of the release Slip (running No)	Yes
RSPTCD_TCD_RATE	_decimal_28_8	decimal(28)	Yes	This field is Used to store Tcd rate of the current Tcd line Id.	No
RSPTCD_TCD_VARIANT	_varchar_25	Varchar(25)	Yes	This field is Used to store Tcd Variant of the current Tcd line Id.	No
RSPTCD_CREATEDDATE	_datetime_8	datetime(8)	No	This field is Used to store Tcd Line created Date	No
RSPTCD_CREATED_BY	_varchar_30	varchar(30)	No	This field is Used to store Tcd Line created user	No
RSPTCD_MODIFIEDDATE	_datetime_8	datetime(8)	No	This field is Used to store last modified date of the current Tcd Lind Id.	No
RSPTCD_MODIFIED_BY	_varchar_30	varchar(30)	No	This field is Used to store last modified user of the current Tcd Lind Id.	No
RSPTCD_USER_SEQ_NO	_decimal_38_0	decimal(38)	Yes	stores the user entered sequence number for the TCD code	No
RSPTCD_CURRENCY	_varchar_20	varchar(20)	Yes	stores the currency chosen in the multiline	No
RSPTCD_EXCHG_RATE	_decimal_28_8	decimal(28)	Yes	Holds the exchage rate between the document currency and the payment currency	No
RSPTCD_CHRG_TYPE	udd_designparamcode	varchar(5)	No	Notional TCD charge type for the Part TCD	No
RSPTCD_TCD_INCIDENCE	udd_taxinci	Varchar(40)	Yes	This field holds the TCD Incidence	No

Table Name :	RSS_RSSCH_RS_SCHEDULE_DTL
Comment :	Used To store the Schedule Details of the Rss Document

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
RSSCH_RS_OUINSTANCE	_decimal_38_0	decimal(38)	No	This field is Used to store Release Slip Created OUInstance	Yes
RSSCH_RS_NO	_varchar_40	varchar(40)	No	This field is Used to store Release Slip No.	Yes
RSSCH_SCH_NO	_decimal_38_0	decimal(38)	Yes	This field is Used to store Schedule Line No of the Part line Id.(Display purpose)	No
RSSCH_RS_LINE_ID	_decimal_38_0	decimal(38)	No	This field is Used to store Part Line Id of the Release Slip No	Yes
RSSCH_SCH_DATE	_datetime_8	datetime(8)	Yes	This field is Used to store Schedule Date of the current Part line Id.	No
RSSCH_RS_SCH_ID	_decimal_38_0	decimal(38)	No	This field is Used to store Schedule Line Id of the Part line Id.(Running No)	Yes
RSSCH_SCH_QTY	_decimal_28_8	decimal(28)	Yes	This field is Used to store Schedule quantity of the current Part line Id.	No
RSSCH_SCH_MOVE_QTY	_decimal_28_8	decimal(28)	Yes	This field is Used to store Gr Moved quantity of the current schedule of the Part Line Id.	No
RSSCH_WH_NO	_varchar_10	varchar(10)	Yes	This field is Used to store Warehouse No of the current schedule Line Id.	No
RSSCH_SCH_STATUS	_varchar_5	varchar(5)	Yes	release slip schedule status	No
RSSCH_CREATEDDATE	_datetime_8	datetime(8)	No	This field is Used to store Created Date of the Current Schedule.	No
RSSCH_CREATED_BY	_varchar_30	varchar(30)	No	This field is Used to store Created User of the Current Schedule.	No
RSSCH_MODIFIEDDATE	_datetime_8	datetime(8)	No	This field is Used to store Last Modified Date of the Current Schedule.	No
RSSCH_MODIFIED_BY	_varchar_30	varchar(30)	No	This field is Used to store Last Modified User of the Current Schedule.	No

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

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
RSSUI_RS_OUINSTANCE	_decimal_38_0	decimal(38)	No	This field is Used to store Release Slip Created OUInstance	Yes
RSSUI_RS_NO	_varchar_40	varchar(40)	No	This field is Used to store Release Slip No.	Yes
RSSUI_USER_DEF_DESC1	_varchar_30	varchar(30)	Yes	This field is Used to store USer Defined Desctiption -1 of the Release Slip	No
RSSUI_USER_DEF_OPT1	_varchar_30	varchar(30)	Yes	This field is Used to store USer Defined Option-1 of the Release Slip	No
RSSUI_USER_DEF_DESC2	_varchar_30	varchar(30)	Yes	This field is Used to store USer Defined Desctiption -2 of the Release Slip	No
RSSUI_USER_DEF_OPT2	_varchar_30	varchar(30)	Yes	This field is Used to store USer Defined Option-2 of the Release Slip	No
RSSUI_USER_DEF_DESC3	_varchar_30	varchar(30)	Yes	This field is Used to store USer Defined Desctiption -3 of the Release Slip	No
RSSUI_USER_DEF_OPT3	_varchar_30	varchar(30)	Yes	This field is Used to store USer Defined Option-3 of the Release Slip	No
RSSUI_USER_DEF_DESC4	_varchar_30	varchar(30)	Yes	This field is Used to store USer Defined Desctiption -4 of the Release Slip	No
RSSUI_USER_DEF_OPT4	_varchar_30	varchar(30)	Yes	This field is Used to store USer Defined Option-4 of the Release Slip	No
RSSUI_USER_DEF_REMARKS	_varchar_255	varchar(255)	Yes	This field is Used to store the remarks of the User Defined information.	No
RSSUI_CREATED_DATE	_datetime_8	datetime(8)	No	This field is Used to store User defined Information Created Date of the release Slip.	No
RSSUI_CREATED_BY	_varchar_30	varchar(30)	No	This field is Used to store User defined Information Created user	No
RSSUI_MODIFIED_DATE	_datetime_8	datetime(8)	No	This field is Used to store last modified date of the User defined Information.	No
RSSUI_MODIFIED_BY	_varchar_30	varchar(30)	No	This field is Used to store last modified user of the User defined Information.	No

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

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
RSTMCN_RS_OUINSTANCE	_decimal_38_0	decimal(38)	No	This field is Used to store Release Slip Created OUInstance	Yes
RSTMCN_RS_NO	_varchar_40	varchar(40)	No	This field is Used to store Release Slip No.	Yes
RSTMCN_PAY_TERM_OU	_decimal_38_0	decimal(38)	Yes	This field is Used to store associated Pay Term Created OUInstance of the Release Slip Document.	No
RSTMCN_PAY_TERM	_varchar_25	Varchar(25)	Yes	This field is Used to store associated Pay Term of the Release Slip Document.	No
RSTMCN_PAYMENT_MODE	_varchar_5	varchar(5)	Yes	This field is Used to store Pay Mode of the Release Slip Document.	No
RSTMCN_PAYMENT_PRIORITY	_varchar_25	Varchar(25)	Yes	This field is Used to store Payment priority of the Release Slip Document "H" - "High", "L" - "Low", "N" - "Normal".	No
RSTMCN_PAY_TO_SUPPLIER_NO	_varchar_45	varchar(45)	Yes	This field is Used to store the Pay to Supplier Created OUInstance of the Release Slip Document.	No
RSTMCN_INSUR_TERMS	_varchar_150	varchar(150)	Yes	This field is Used to store the Insurance Terms of the Release Slip Document.	No
RSTMCN_INSUR_LIABILITY	_varchar_5	varchar(5)	Yes	This field is Used to store the Insurance Liability of the Release Slip Document. "SF" - "Self", "B" - "None", "SS" - "Suppliers".	No
RSTMCN_INSUR_AMOUNT	_decimal_28_8	decimal(28)	Yes	This field is Used to store the Insurance Amount of the Release Slip Document.	No
RSTMCN_INCO_TERM	_varchar_150	varchar(150)	Yes	This field is Used to store the INCO of the Release Slip Document.	No
RSTMCN_SHIP_BY	_varchar_25	Varchar(25)	Yes	This field is Used to store the Ship By Mode Of the Release Slip Document.	No
RSTMCN_DELIVERY_POINT	_varchar_255	varchar(255)	Yes	This field is Used to store the Delivery Point of the Release Slip Document.	No
RSTMCN_TRANSSHIPMENT	_varchar_5	varchar(5)	Yes	This field is Used to store the Trans Shipment of the Release Slip Document. "Y" - "Yes", "N" - "No".	No
RSTMCN_PACKAGING_CODE	_varchar_150	varchar(150)	Yes	This field is Used to store the Packaging Code of the Release Slip Document.	No
RSTMCN_SHIP_PARTIAL	_varchar_5	varchar(5)	Yes	This field is Used to store the Ship Partial of the Release Slip Document. "Y" - "Yes", "N" - "No".	No
RSTMCN_SHIP_PAYMENT	_varchar_15	varchar(15)	Yes	This field is Used to store the Ship Payment of the Release Slip Document.	No
RSTMCN_REMARKS	_varchar_255	varchar(255)	Yes	This field is Used to store the remarks for the Terms and codition of the release Slip Document.	No
RSTMCN_CREATEDDATE	_datetime_8	datetime(8)	No	This field is Used to store the Terms and codition created Date	No
RSTMCN_CREATED_BY	_varchar_30	varchar(30)	No	This field is Used to store the Terms and codition created user.	No
RSTMCN_MODIFIEDDATE	_datetime_8	datetime(8)	No	This field is Used to store the Terms and codition last Modifed Date.	No
RSTMCN_MODIFIED_BY	_varchar_30	varchar(30)	No	This field is Used to store the Terms and codition last Modifed User.	No
RSTMCN_ADV_PAYABLE	_varchar_5	varchar(5)	Yes	stores ths flag whether advance is payable or not. "Y" - "Yes", "N" - "No".	No
RSTMCN_ADV_PAY_BYDATE	_datetime_8	datetime(8)	Yes	stores the date by which advance is payable	No
RSTMCN_ADV_PERCENT	_decimal_28_8	decimal(28)	Yes	stores the value of advance percentage	No
RSTMCN_ADV_PER_ON	_varchar_5	varchar(5)	Yes	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
RSTMCN_ADV_PAYABLE_VAL	_decimal_28_8	decimal(28)	Yes	stores the advance payable value	No
RSTMCN_ADV_TOL_PERC	_decimal_28_8	decimal(28)	Yes	stores the advance tolerance percentage	No
RSTMCN_PAY_MODE	_varchar_5	varchar(5)	Yes	stores the flag for the payment mode CS - Cash CQ - Cheque DD - Demand Draft P - Pay Order	No
RSTMCN_DDCHRGS_BORNEBY	_varchar_5	varchar(5)	Yes	stores the flag which identifies that the DD charges will be borne by whom "SE" - "Self", "SU"- "Supplier".	No
RSTMCN_PAYTO_SUPP_ADDRID	_decimal_38_0	decimal(38)	Yes	stores the pay to supplier s address id.	No
RSTMCN_PAYMENT_NOTES	_varchar_2000	varchar(2000)	Yes	stores the payment notes	No
RSTMCN_WARRANTY	_varchar_5	varchar(5)	Yes	stores the flag whether warranty is yes or no Y- Yes N - No B - Blank	No
RSTMCN_WARRANTY_BASIS	_varchar_5	varchar(5)	Yes	stores the flag to indicate the warranty basis "C"- "Calendar", "U" - "Usage" "BH" - "Both".	No
RSTMCN_WARR_AGRMT_NO	_varchar_40	varchar(40)	Yes	stores the warrany agreement number	No
RSTMCN_PACKAGING_NOTES	_varchar_2000	varchar(2000)	Yes	stores the packaging notes	No
RSTMCN_PORT_OF_DEPARTURE	_varchar_40	varchar(40)	Yes	stores the port of departure	No
RSTMCN_CARRIER_AGENCY_NO	_varchar_40	varchar(40)	Yes	stores the carrier/agency number	No
RSTMCN_SHIPPING_PAYMENT	_varchar_40	varchar(40)	Yes	Stores the Shipping Payment mode.	No
RSTMCN_SHIPPING_NOTES	_varchar_2000	varchar(2000)	Yes	stores the shipping notes	No
RSTMCN_GTA_REFNO	_varchar_2000	varchar(2000)	Yes	stores the General terms and agreement reference number	No
RSTMCN_REF_DOC_DATE	_datetime_8	datetime(8)	Yes	stores the reference document date	No
RSTMCN_GTA_REMARKS	_varchar_255	varchar(255)	Yes	stores the General terms and agreement Remarks	No
RSTMCN_PAY_TO_SUPPLIER_OU	_decimal_38_0	decimal(38)	Yes	stores the OU instance of the pay to supplier	No