Data Dictionary -- Purchase Requisition

Srl. No.	Table Name	Comment
1	PRA_PRHDR_PUR_REQUEST_HDR	Purchase Requst amendment header table
2	PRA_PRITM_PR_ITEM_DETAILS	Purchase Requst amendment item table
3	PRA_PRQUA_PR_QUALITY_DTL	Purchase Requst amendment quality details table
4	PRA_PRSCH_PR_SCH_DETAILS	Purchase Requst amendment item schedule table
5	PRA_PRUDI_USER_DEF_INFO	Purchase Requst amendment item user definition table
6	PR_AUTHMAIL_SENT_DTL	Purchase Requst authorize mailflag table
7	pr_op_column_metadata	PR metadata table
8	PR_PARAMETER_DETAILS	This table used to Store the Parameter Details of the Purchase request Document
9	PR_PRAAD_AUTH_AUDIT_DTL	This table used to Store All the Status Changes that have been made to the Purchase request Document
10	PR_PRAPD_AUTH_PROFILE_DTL	This table holds the authorisation profile Purchase Commitee details of purchase request
11	PR_PRAPH_AUTH_PROFILE_HDR	This table holds the authorisation profile details of purchase request
12	PR_PRHDR_PUR_REQUEST_HDR	This table holds the purchase request document details
13	PR_PRITM_PR_ITEM_DETAILS	This table holds the purchase request item details
14	PR_PRQC_QUICK_CODE	This table maintains the Quick Code information.
15	PR_PRQUA_PR_QUALITY_DTL	This table is Used To store the Parameter Information which was captured from the Aircraft Component and the Present Value for the related Part No associated with the PR Document.
16	PR_PRSCH_PR_SCH_DETAILS	This table holds the purchase request schedule details
17	PR_PRSCRP_PUR_SCRAP_COVERAGE_DTL	Table holds the coverage between the purchase request document and the scrap note document at quantity leve
18	PR_PRSOPT_SETOPTION_INFO	This table is used to store numbering type options for Automatic PR creation.
19	PR_PRSTATUS_HIS_DTL	PR status history table
20	PR_PRUDI_USER_DEF_INFO	This table holds the user defined info of purchase request document

Table Name :	PRA_PRHDR_PUR_REQUEST_HDR
Comment :	Purchase Requst amendment header table

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
PRAHDR_OUINSTANCE	udd_ctxt_ouinstance	int(4)	No	This is the ouinstance in which purchase request is created	Yes
PRAHDR_PR_NO	udd_documentno	varchar(40)	No	This field holds the purchase request number	Yes
PRAHDR_AMEND_NO	udd_documentno	varchar(40)	No	Amendment # of the document is stored here	Yes
PRAHDR_PR_STATUS	udd_designparamcode	varchar(5)	Yes	This field holds the purchase request status . Allowed values A Active I Inactive	No
PRAHDR_PR_DATE	udd_time	datetime(8)	Yes	This field holds the purchase request date	No
PRAHDR_NUM_TYPE_NO	udd_designparamcode	varchar(5)	Yes	This field holds the numbering type number of purchase request document	No
PRAHDR_NEED_DATE	udd_time	datetime(8)	Yes	This field holds the need date for the purchase request document	No
PRAHDR_PR_CATEGORY	udd_quickcodes	varchar(25)	Yes	This field holds the category of purchase request document	No
PRAHDR_ORDERING_OU	udd_ctxt_ouinstance	int(4)	Yes	This field contains the ouinstance where the purchase order is going to be raised	No
PRAHDR_RECEIVING_OU	udd_ctxt_ouinstance	int(4)	Yes	This field contains the ouinstance where the goods receipt is going to be raised	No
PRAHDR_PR_TYPE	udd_designparamcode	varchar(5)	Yes	This field holds the type of the purchase request document	No
PRAHDR_REMARKS	udd_remarks	varchar(255)	Yes	This field holds the remarks of the purchase request document	No
PRAHDR_USER_STATUS	udd_quickcodes	varchar(25)	Yes	This field holds the user status of the purchase request document	No
PRAHDR_APPROVEDDATE	udd_time	datetime(8)	Yes	This field holds the approved date of the purchase request document	No
PRAHDR_APPROVED_BY	udd_ctxt_user	varchar(30)	Yes	This field holds the user who approved the document	No
PRAHDR_PART_TYPE	udd_parttype	varchar(25)	Yes	This field holds the part type of the purchase request document	No
PRAHDR_PR_VALUE	udd_amount	numeric(13)	Yes	This field holds the value of the purchase request document	No
PRAHDR_BASECURRENCY	udd_currency	varchar(20)	Yes	This field holds the base currency of the purchase request document	No
PRAHDR_AUTH_TYPE	udd_designparamcode	varchar(5)	Yes	This field holds the authorisation type whether it Purchase Committee or not	No
PRAHDR_STAGE	udd_quickcodes	varchar(25)	Yes	This field holds the stage of the authorisation process	No
PRAHDR_CREATIONDATE	udd_time	datetime(8)	Yes	This field holds the created date of the record	No
PRAHDR_CREATED_BY	udd_ctxt_user	varchar(30)	Yes	This field holds the user who created the record	No
PRAHDR_MODIFIEDDATE	udd_time	datetime(8)	Yes	This field holds the modified date of the record	No
PRAHDR_MODIFIED_BY	udd_ctxt_user	varchar(30)	Yes	This field holds the user who modified the record	No
PRAHDR_TIMESTAMP	udd_timestamp	int(4)	Yes	This field holds the timestamp of the purchase request document	No
PRAHDR_REASON_FOR_CANC	udd_txt2000	varchar(2000)	Yes	Stores the reason for cancellation of purchase request	No
PRAHDR_WF_DOC_KEY	udd_wfdockey	varchar(128)	Yes	stores the document key which is stored for work flow purpose	No
PRAHDR__REPLENISHMENT_FLAG	udd_chkflag	varchar(1)	Yes	This field holds whether this PR is created through Replenishment.	No
PRAHDR_PRIORITY	udd_designparamcode	varchar(5)	Yes	This field holds the priority of PR to be created. Allowed values are N Normal, A AOG, C Critical and E Expedite.	No
PRAHDR_EXPENSE_TYPE	udd_designparamcode	varchar(5)	Yes	This field holds the expense type of purchase request doc . Allowed values C Capital R Revenue	No
PRAHDR_REQUNIT	udd_financebookid	varchar(20)	Yes	This column is used to hold the requesting unit value	No
PRAHDR_BUYER_GROUP	udd_group	varchar(25)	Yes	Save the Created Buyer Group Code in this column, If Buyer Group Needed for PR Set Option in LogCM is set as Required .	No
PRAHDR_BUYGRP_OU	udd_ctxt_ouinstance	int(4)	Yes	Save the Created Buyer Group OU in this column, If Buyer Group Needed for PR Set Option in LogCM is set as Required .	No
PRAHDR_AMENDED_BY	udd_ctxt_user	varchar(30)	Yes	User who has amended the document is stored here	No
PRAHDR_AMENDED_DATE	udd_time	datetime(8)	Yes	Date on which the amendment is done is stored here	No

Table Name :	PRA_PRITM_PR_ITEM_DETAILS
Comment :	Purchase Requst amendment item table

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
PRAITM_OUINSTANCE	udd_ctxt_ouinstance	int(4)	No	This is the ouinstance in which purchase request is created	No
PRAITM_PR_NO	udd_documentno	varchar(40)	No	This field holds the purchase request number	No
PRAITM_AMEND_NO	udd_seqno	int(4)	No	Amendment # of the document is stored here	No
PRAITM_PR_SERIAL_NO	udd_seqno	int(4)	No	This field capures the Unique identifier number for the part of the PR	No
PRAITM_PART_NO	udd_partno	varchar(40)	No	This field captures the Part number requested in the PR	No
PRAITM_PART_OU	udd_ctxt_ouinstance	int(4)	Yes	This field captures the Part created ouinstance	No
PRAITM_REQUIRED_QTY	udd_quantity	numeric(13)	Yes	This field captures the request qty of each line item of the PR	No
PRAITM_ORDER_QTY	udd_quantity	numeric(13)	Yes	This field captures the PO Covered quantity updated from PO component	No
PRAITM_PENDING_QTY	udd_quantity	numeric(13)	Yes	when create the PR, pending qty is same as required qty when update the ordered quantity from PO Pending quantity = required quantity - order quantity	No
PRAITM_COST	udd_amount	numeric(13)	Yes	This field captures the Cost of the part, depending on cost per, it can be either cost of 1 part or more.	No
PRAITM_COSTPER	udd_quantity	numeric(13)	Yes	This field captures the Unit cost of the part	No
PRAITM_DELIVERY_TYPE	udd_type	varchar(25)	Yes	This field captures the purchase request s delivery type List of values are S ingle all the requested qty will be delivered in a single schedule. M ultiple the requested qty will be delivered in a staggered schedule dates.	No
PRAITM_NEED_DATE	udd_time	datetime(8)	Yes	This field captures the date in which the ordered qty has to be delivered.	No
PRAITM_WH_CODE	udd_warehouse	varchar(10)	Yes	This field captures the warehoouse code	No
PRAITM_WH_OU	udd_ctxt_ouinstance	int(4)	Yes	stores the warehouse OU instance	No
PRAITM_SUPP_CODE	udd_vendorcode	varchar(45)	Yes	This field captures the Supplier code from the supplier component who has raise the purchase request.	No
PRAITM_COMMENTS	udd_remarks	varchar(255)	Yes	This field captures the comments,	No
PRAITM_REF_DOC_NO	udd_documentno	varchar(40)	Yes	This field captures the reference document no this used to find from where the request is raised.	No
PRAITM_PART_UOM	udd_uom	varchar(15)	Yes	This field captures Any valid UOM from the UOM component in which the goods can be purchased .	No
PRAITM_CONDITION	udd_condition	varchar(15)	Yes	This field captures the part condition List of values are New New Surplus Overhaul Servicable Unservicable	No
PRAITM_REF_DOC_REVNO	udd_seqno	int(4)	Yes	stores the revision no of reference document for this PR	No
PRAITM_QUALITY_ATTRIBUTE	udd_designparamcode	varchar(5)	Yes	This fields captures the Quality Attribute with the following values 1. S tandard 2. C ustom 3. N one	No
PRAITM_CREATEDDATE	udd_time	datetime(8)	Yes	This field captures the date when the PR item details are created in the system	No
PRAITM_CREATED_BY	udd_ctxt_user	varchar(30)	Yes	This field captures the user who created the PR item details	No
PRAITM_MODIFIEDDATE	udd_time	datetime(8)	Yes	This field captures the date when the PR item details are modified in the system	No
PRAITM_MODIFIED_BY	udd_ctxt_user	varchar(30)	Yes	This field captures the user who modified the PR item details	No
PRAITM_WORK_CENTER	udd_workunitcode	varchar(30)	Yes	This field captures the work center.	No
PRAITM_REF_DOC_LINE_NO	udd_workunitcode	varchar(30)	Yes	This field captures the reference document line no .	No
PRAITM_REF_DOC_OU	udd_ctxt_ouinstance	int(4)	Yes	This is the ouinstance in which reference document for this purchase request  is created.	No
PRAITM_SHORTCLS_QTY	udd_quantity	numeric(13)	Yes	This field captures short close quantity	No
PRAITM_CAPEX_NO	UDD_DefaultCapexProposalNo	varchar(20)	Yes	This field captures the capex no of the part.	No
PRAITM_ALTERNATE_TYPE	udd_designparamcode	varchar(5)	Yes	This field captures alternate type	No
PRAITM_ALTERNATE_PART_NO	udd_partno	varchar(40)	Yes	This field captures alternate part no	No
PRAITM_SCL_COMMENTS	udd_remarks	varchar(255)	Yes	This field captures short close comments	No
PRAITM_LINE_STATUS	udd_designparamcode	varchar(5)	Yes	This field captures line status	No
PRAITM_REF_DOC_TYPE	udd_designparamcode	varchar(5)	Yes	reference document type of the PR is stored here	No
PRAITM_TASK_NO	udd_workunitcode	varchar(30)	Yes	PR history of Reference document Task Number	No
PRAITM_INTSEQ_NO	udd_seqno	int(4)	Yes	PR history of Reference document Task internal sequnce Number	No
PRAITM_COST_BASIS	udd_txt20	varchar(20)	Yes	This column holds the cost basis value	No
PRAITM_ACC_USAGE	udd_txt20	varchar(20)	Yes	This column holds the accounting usage value	No
PRAITM_CST_USAGE	udd_txt20	varchar(20)	Yes	This column holds the costing usage value	No
PRAITM_ANLY_CODE	udd_txt20	varchar(20)	Yes	This column holds the analysis code value	No
PRAITM_SUBANLY_CODE	udd_txt20	varchar(20)	Yes	Thsi column holds the subanalysis code value	No
PRAITM_MR_LINENO	udd_ctxt_ouinstance	int(4)	Yes	This column holds the MR line No	No
PRAITM_MRPRCOV_QTY	udd_quantity	numeric(13)	Yes	This column holds the MR PR covered quantity maintained only at the backend level	No
PRAITM_KNOCKOFF_PRQTY_INSTKUOM	udd_quantity	numeric(13)	Yes	This column holds the MR knock off quantity from PR PO maintained only at the backend level. To update the pending Demand table	No
PRAITM_REP_FLAG	udd_flag	varchar(25)	Yes	Replenishment Flag of the pr document is stored here	No
PRAITM_REP_WH	udd_warehouse	varchar(10)	Yes	Warehouse in which the replenishment should happen is stored here	No
PRAITM_REP_WHQTY	udd_quantity	numeric(13)	Yes	Replenishment Quantity is stored here	No
REPLICATION_KEY	_bigint_8	Bigint(8)	No	Unique Number	Yes

Table Name :	PRA_PRQUA_PR_QUALITY_DTL
Comment :	Purchase Requst amendment quality details table

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
PRAQUA_OUINSTANCE	udd_ctxt_ouinstance	int(4)	No	This is the ouinstance in which purchase request is created	No
PRAQUA_PR_NO	udd_documentno	varchar(40)	No	This field holds the purchase request number	No
PRAQUA_AMEND_NO	udd_seqno	int(4)	No	Amendment # of the document is stored here	No
PRAQUA_PR_SERIAL_NO	udd_seqno	int(4)	No	This field holds the uniquely generated id of PR document	No
PRAQUA_PR_ATTRIBUTE_ID	udd_documentno	varchar(40)	No	This field holds the attribute id of PR document	No
PRAQUA_ATTRIBUTE_OU	udd_ctxt_ouinstance	int(4)	Yes	This field holds the ouinstance of attribute component with which PR is created.	No
PRAQUA_ATTRIBUTE_CODE	udd_quickcodes	varchar(25)	Yes	This field is to capture the attribute code of the PR document	No
PRAQUA_ATTRIBUTE_TYPE	udd_designparamcode	varchar(5)	Yes	This field is to capture the attribute type of PR document	No
PRAQUA_MAXIMUM_VALUE	udd_amount	numeric(13)	Yes	This field holds the maximum value of PR document	No
PRAQUA_MINIMUM_VALUE	udd_amount	numeric(13)	Yes	This field holds the minimum value of PR document	No
PRAQUA_STD_VALUE	udd_amount	numeric(13)	Yes	This field holds the standard value of PR document	No
PRAQUA_STD_MIN_VALUE	udd_amount	numeric(13)	Yes	This field holds the standard minimum value of PR document	No
PRAQUA_STD_MAX_VALUE	udd_amount	numeric(13)	Yes	This field holds the standard maximum value of PR document	No
PRAQUA_STD_QUAL_VALUE	udd_txt80	varchar(80)	Yes	This field holds the standard qualitative value	No
PRAQUA_TRACKABLE	udd_designparamcode	varchar(5)	Yes	This field is set when the trackable option is allowed. Allowed values are 1.YES 2.NO	No
PRAQUA_REMARKS	udd_remarks	varchar(255)	Yes	This field holds the inspect remarks of PR component	No
PRAQUA_CREATEDDATE	udd_time	datetime(8)	Yes	This field holds the created date of the record	No
PRAQUA_CREATED_BY	udd_ctxt_user	varchar(30)	Yes	This field holds the user who created the record	No
PRAQUA_MODIFIEDDATE	udd_time	datetime(8)	Yes	This field holds the modified date of the record	No
PRAQUA_MODIFIED_BY	udd_ctxt_user	varchar(30)	Yes	This field holds the user who modified the record	No
REPLICATION_KEY	_bigint_8	Bigint(8)	No	Unique Number	Yes

Table Name :	PRA_PRSCH_PR_SCH_DETAILS
Comment :	Purchase Requst amendment item schedule table

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
PRSCH_OUINSTANCE	udd_ctxt_ouinstance	int(4)	No	This is the ouinstance in which purchase request schedule details is created	No
PRSCH_PR_NO	udd_documentno	varchar(40)	No	This field holds the purchase request number	No
PRSCH_PR_SERIAL_NO	udd_seqno	int(4)	No	This field capures the Unique identifier number for the part of the PR	No
PRSCH_SCH_NO	udd_seqno	int(4)	No	This field captures the schedule number	No
PRSCH_SCH_QTY	udd_quantity	numeric(13)	Yes	This field captures the schedule quantity of the part	No
PRSCH_SCH_DATE	udd_time	datetime(8)	Yes	This field captures the date in which the schedule qty has to be delivered.	No
PRSCH_PENDING_SCH_QTY	udd_quantity	numeric(13)	Yes	stores the pending schedule quantity	No
PRSCH_CREATEDDATE	udd_time	datetime(8)	Yes	This field captures the date when the PR Schedule details are created in the system	No
PRSCH_CREATED_BY	udd_ctxt_user	varchar(30)	Yes	This field captures the user who created the PR schedule details	No
PRSCH_MODIFIEDDATE	udd_time	datetime(8)	Yes	This field captures the date when the PR Schedule details are modified in the system	No
PRSCH_MODIFIED_BY	udd_ctxt_user	varchar(30)	Yes	This field captures the user who modified the PR schedule details	No
REPLICATION_KEY	_bigint_8	Bigint(8)	No	Unique Number	Yes

Table Name :	PRA_PRUDI_USER_DEF_INFO
Comment :	Purchase Requst amendment item user definition table

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
PRAUDI_OUINSTANCE	udd_ctxt_ouinstance	int(4)	No	This is the ouinstance in which purchase request is created	No
PRAUDI_PR_NO	udd_documentno	varchar(40)	No	This field holds the purchase request number	No
PRAUDI_AMEND_NO	udd_seqno	int(4)	No	Amendment # of the document is stored here	No
PRAUDI_USER_DEF_DESC1	udd_description	varchar(40)	Yes	This field holds the first user defined description	No
PRAUDI_USER_DEF_OPT1	udd_description	varchar(40)	Yes	This field holds the first user defined option	No
PRAUDI_USER_DEF_DESC2	udd_description	varchar(40)	Yes	This field holds the second user defined description	No
PRAUDI_USER_DEF_OPT2	udd_description	varchar(40)	Yes	This field holds the second user defined option	No
PRAUDI_USER_DEF_DESC3	udd_description	varchar(40)	Yes	This field holds the third user defined description	No
PRAUDI_USER_DEF_OPT3	udd_description	varchar(40)	Yes	This field holds the third user defined option	No
PRAUDI_USER_DEF_DESC4	udd_description	varchar(40)	Yes	This field holds the fourth user defined description	No
PRAUDI_USER_DEF_OPT4	udd_description	varchar(40)	Yes	This field holds the fourth user defined option	No
PRAUDI_USER_DEF_REMARKS	udd_remarks	varchar(255)	Yes	This field holds the user defined remarks	No
PRAUDI_CREATED_DATE	udd_time	datetime(8)	Yes	This field holds the created date of the record	No
PRAUDI_CREATED_BY	udd_description	varchar(40)	Yes	This field holds the user who created the record	No
PRAUDI_MODIFIED_DATE	udd_time	datetime(8)	Yes	This field holds the modified date of the record	No
PRAUDI_MODIFIED_BY	udd_description	varchar(40)	Yes	This field holds the user who modified the record	No
REPLICATION_KEY	_bigint_8	Bigint(8)	No	Unique Number	Yes

Table Name :	PR_AUTHMAIL_SENT_DTL
Comment :	Purchase Requst authorize mailflag table

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
AUTHMAIL_OU	_numeric_28_0	numeric(28)	Yes	This is the ouinstance in which purchase request is created	No
AUTHMAIL_PRNO	_varchar_40	varchar(40)	Yes	purchase request number is stored in this field	No
AUTHMAIL_AUTHTYPE	_varchar_5	varchar(5)	Yes	Authorization type of the pr document is stored here	No
AUTHMAIL_LEVELPC	_varchar_40	varchar(40)	Yes	Authorization level of the pr document is stored here	No
AUTHMAIL_ROWNUM	_numeric_28_0	numeric(28)	Yes	Authorization row number	No
AUTHMAIL_USER	_varchar_30	varchar(30)	Yes	User who has authorized the document is stored here	No
AUTHMAIL_MAILFLAG	_varchar_5	varchar(5)	Yes	Authorization mail flag of the PR Document is stored here	No
REPLICATION_KEY	_bigint_8	Bigint(8)	No	Unique Number	Yes

Table Name :	pr_op_column_metadata
Comment :	PR metadata table

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
op_param_code	udd_optioncode	varchar(8)	Yes	PR parameter code	No
op_param_name	udd_name	varchar(60)	Yes	PR parameter name	No
REPLICATION_KEY	_bigint_8	Bigint(8)	No	Unique Number	Yes

Table Name :	PR_PARAMETER_DETAILS
Comment :	This table used to Store the Parameter Details of the Purchase request Document

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
COMPONENTNAME	_varchar_20	varchar(20)	No	This field holds the Name of the component.	Yes
PARAMCATEGORY	_varchar_10	varchar(10)	No	This field will capture the category of the static value. The static values could be to fill up combo, text field, guidance text, combo default etc.	Yes
PARAMTYPE	_varchar_25	Varchar(25)	No	Normally param type is the name of the control. This will allow us to store all the possible values for a combo in multiple rows.	Yes
PARAMCODE	_varchar_5	varchar(5)	No	This is the code that may be used for data storage. This is valid only incase of combo boxes. Here the short code that will be stored as data in the transaction could be maintained.	Yes
PARAMDESC	_varchar_80	varchar(80)	No	Param description is the values to be filled in the combo box or guidance text. This is actually the meta data of this component	Yes
LANGID	_decimal_10_0	decimal(10)	No	Language id. This is the language id of the record.	Yes
SORTBY	_decimal_10_0	decimal(10)	Yes	This field holds the default sort by code	No
CREATIONDATE	_datetime_8	datetime(8)	Yes	This field holds the record created date for auditing purpose.	No

Table Name :	PR_PRAAD_AUTH_AUDIT_DTL
Comment :	This table used to Store All the Status Changes that have been made to the Purchase request Document

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
PRAAD_PR_OUINSTANCE	_numeric_28_0	numeric(28)	No	The Login Ouinstance	Yes
PRAAD_AUTH_LEVEL_PC	_varchar_25	Varchar(25)	No	The Level or PC code of the user who is responsible for changing the status.	No
PRAAD_PR_NO	_varchar_40	varchar(40)	No	purchase request no	Yes
PRAAD_DATE_AND_TIME	_datetime_8	datetime(8)	Yes	date and time on which the audit record gets posted	No
PRAAD_AUDIT_TRAIL_ID	_numeric_28_0	numeric(28)	No	Audit trail record id	Yes
PRAAD_STATUS_FROM	_varchar_15	varchar(15)	Yes	THe status of the PR Document currently in before changing to be changed from	No
PRAAD_STATUS_TO	_varchar_15	varchar(15)	Yes	THe status of the PR Document currently in after changing changed to	No
PRAAD_USER_NAME	_varchar_30	varchar(30)	Yes	The user who has been mapped to the Level or PC. It is the same user who has logged in.	No

Table Name :	PR_PRAPD_AUTH_PROFILE_DTL
Comment :	This table holds the authorisation profile Purchase Commitee details of purchase request

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
PRAPD_OUINSTANCE	_decimal_10_0	decimal(10)	No	This field captures the Purchase request created ouinstance	Yes
PRAPD_PR_NO	_varchar_40	varchar(40)	No	This field holds the purchase request number	Yes
PRAPD_PC_CODE	_varchar_25	Varchar(25)	No	This field holds the Purchase commitee who authorised the purchase request document	Yes
PRAPD_EMP_CODE	_varchar_20	varchar(20)	No	This field captures the Employee code	Yes
PRAPD_MEMBER_AUTH_STATUS	_varchar_5	varchar(5)	Yes	This field captures the Authorised status 1. YES 2. NO	No
PRAPD_AUTH_BY	_varchar_30	varchar(30)	Yes	The user who authorized the PO	No
PRAPD_AUTH_DATE	_datetime_8	datetime(8)	Yes	The date when the PO is authorised.	No

Table Name :	PR_PRAPH_AUTH_PROFILE_HDR
Comment :	This table holds the authorisation profile details of purchase request

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
PRAPH_OUINSTANCE	_decimal_10_0	decimal(10)	No	This is the ouinstance in which purchase request is created	Yes
PRAPH_PR_NO	_varchar_40	varchar(40)	No	This field holds the purchase request number	Yes
PRAPH_LVL_PC_CODE	_varchar_25	Varchar(25)	No	This field holds the Authorise Level code or Purchase commitee who authorised the purchase request document	Yes
PRAPH_SEQNO	_decimal_10_0	decimal(10)	No	The sequence in which the PC or the LEVEL has to be authorised	Yes
PRAPH_TYPE	_varchar_5	varchar(5)	Yes	This field holds the Authorise type may be 1.LVL 2.PC	No
PRAPH_NO_MEMBERS	_decimal_10_0	decimal(10)	Yes	This fields captures the Number of person in the PC. if the authorised type is PC	No
PRAPH_PC_TYPE	_varchar_5	varchar(5)	Yes	This field catures the PC type may be 1. ANY Atlease one person should be authorise the document 2. ALL all person should be authorise the document 3. Quroum	No
PRAPH_PC_QUROUM	_decimal_10_0	decimal(10)	Yes	This field captures atleast How many person should be authorised the Document If the PC type is Quroum.	No
PRAPH_MEMBERS_AUTHORIZED	_decimal_10_0	decimal(10)	Yes	This field capture that Till how many members are authorised the document.	No
PRAPH_LVL_PC_AUTH_STATUS	_varchar_5	varchar(5)	Yes	this field captures the Authorise status may be 1. YES 2. NO	No
PRAPH_LAST_AUTHORIZED_BY	_varchar_30	varchar(30)	Yes	This field holds the user who authorised the document	No
PRAPH_LAST_AUTH_DATE	_datetime_8	datetime(8)	Yes	This field holds the authorised date of the purchase request document	No

Table Name :	PR_PRHDR_PUR_REQUEST_HDR
Comment :	This table holds the purchase request document details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
PRHDR_OUINSTANCE	_decimal_10_0	decimal(10)	No	This is the ouinstance in which purchase request is created	Yes
PRHDR_PR_NO	_varchar_40	varchar(40)	No	This field holds the purchase request number	Yes
PRHDR_PR_STATUS	_varchar_5	varchar(5)	Yes	This field holds the purchase request status . Allowed values A Active I Inactive	No
PRHDR_PR_DATE	_datetime_8	datetime(8)	Yes	This field holds the purchase request date	No
PRHDR_NUM_TYPE_NO	_varchar_5	varchar(5)	Yes	This field holds the numbering type number of purchase request document	No
PRHDR_NEED_DATE	_datetime_8	datetime(8)	Yes	This field holds the need date for the purchase request document	No
PRHDR_PR_CATEGORY	_varchar_25	Varchar(25)	Yes	This field holds the category of purchase request document	No
PRHDR_ORDERING_OU	_decimal_10_0	decimal(10)	Yes	This field contains the ouinstance where the purchase order is going to be raised	No
PRHDR_RECEIVING_OU	_decimal_10_0	decimal(10)	Yes	This field contains the ouinstance where the goods receipt is going to be raised	No
PRHDR_PR_TYPE	_varchar_5	varchar(5)	Yes	This field holds the type of the purchase request document	No
PRHDR_REMARKS	_varchar_255	varchar(255)	Yes	This field holds the remarks of the purchase request document	No
PRHDR_USER_STATUS	_varchar_25	Varchar(25)	Yes	This field holds the user status of the purchase request document	No
PRHDR_APPROVEDDATE	_datetime_8	datetime(8)	Yes	This field holds the approved date of the purchase request document	No
PRHDR_APPROVED_BY	_varchar_30	varchar(30)	Yes	This field holds the user who approved the document	No
PRHDR_PART_TYPE	_varchar_25	Varchar(25)	Yes	This field holds the part type of the purchase request document	No
PRHDR_PR_VALUE	_decimal_28_8	decimal(28)	Yes	This field holds the value of the purchase request document	No
PRHDR_BASECURRENCY	_varchar_20	varchar(20)	Yes	This field holds the base currency of the purchase request document	No
PRHDR_AUTH_TERLEVEL	_varchar_25	Varchar(25)	Yes	This field holds the terminating level in the authorisation profile of purchase request document	No
PRHDR_AUTH_MINVAL	_decimal_28_8	decimal(28)	Yes	This field holds the minimum document value for authorisation of purchase request document can be made for the given user	No
PRHDR_AUTH_MAXVAL	_decimal_28_8	decimal(28)	Yes	This field holds the maximum document value for authorisation of purchase request document can be made for the given user	No
PRHDR_AUTH_NXTLVLPC	_varchar_25	Varchar(25)	Yes	This field holds the next level in the authorisation profile of purchase request document	No
PRHDR_AUTH_TYPE	_varchar_5	varchar(5)	Yes	This field holds the authorisation type whether it Purchase Committee or not	No
PRHDR_STAGE	_varchar_25	Varchar(25)	Yes	This field holds the stage of the authorisation process	No
PRHDR_CREATIONDATE	_datetime_8	datetime(8)	Yes	This field holds the created date of the record	No
PRHDR_CREATED_BY	_varchar_30	varchar(30)	Yes	This field holds the user who created the record	No
PRHDR_MODIFIEDDATE	_datetime_8	datetime(8)	Yes	This field holds the modified date of the record	No
PRHDR_MODIFIED_BY	_varchar_30	varchar(30)	Yes	This field holds the user who modified the record	No
PRHDR_TIMESTAMP	_decimal_10_0	decimal(10)	Yes	This field holds the timestamp of the purchase request document	No
PRHDR_REASON_FOR_CANC	_varchar_2000	varchar(2000)	Yes	Stores the reason for cancellation of purchase request	No
PRHDR_WF_DOC_KEY	_varchar_128	varchar(128)	Yes	stores the document key which is stored for work flow purpose	No
PRHDR__REPLENISHMENT_FLAG	_varchar_1	varchar(1)	Yes	This field holds whether this PR is created through Replenishment.	No
PRHDR_PRIORITY	_varchar_5	varchar(5)	Yes	This field holds the priority of PR to be created. Allowed values are N Normal, A AOG, C Critical and E Expedite.	No
PRHDR_EXPENSE_TYPE	_varchar_5	varchar(5)	Yes	This field holds the expense type of purchase request doc . Allowed values C Capital R Revenue	No
PRHDR_REQUNIT	udd_txt20	varchar(20)	Yes	This column is used to hold the requesting unit value	No
PRHDR_BUYER_GROUP	udd_regaucode	varchar(25)	Yes	Save the Created Buyer Group Code in this column, If Buyer Group Needed for PR Set Option in LogCM is set as Required .	No
PRHDR_BUYGRP_OU	udd_ctxt_ouinstance	int(4)	Yes	Save the Created Buyer Group OU in this column, If Buyer Group Needed for PR Set Option in LogCM is set as Required .	No
PRHDR_AMEND_NO	udd_seqno	int(4)	Yes	Amendment # of the document is stored here	No
PRHDR_AMENDED_BY	udd_ctxt_user	varchar(30)	Yes	User who has amended the document is stored here	No
PRHDR_AMENDED_DATE	udd_time	datetime(8)	Yes	Date on which the amendment is done is stored here	No
PRHDR_REASON_FOR_RETURN	udd_txt255	varchar(255)	Yes	Reason for returning the PR document is stored here	No
PRHDR_RETURN_NOTES_ID	udd_guid	varchar(40)	Yes	Unique ID for PR reason for retrun notes	No
created_area_code	_VARCHAR_40	varchar(40)	Yes	This column will have value only if the application is used in offline. This will have the offline area id where the record was created	No

Table Name :	PR_PRITM_PR_ITEM_DETAILS
Comment :	This table holds the purchase request item details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
PRITM_OUINSTANCE	_decimal_10_0	decimal(10)	No	This is the ouinstance in which purchase request is created	Yes
PRITM_PR_NO	_varchar_40	varchar(40)	No	This field holds the purchase request number	Yes
PRITM_PR_SERIAL_NO	_decimal_10_0	decimal(10)	No	This field capures the Unique identifier number for the part of the PR	Yes
PRITM_PART_NO	_varchar_40	varchar(40)	No	This field captures the Part number requested in the PR	Yes
PRITM_PART_OU	_decimal_10_0	decimal(10)	Yes	This field captures the Part created ouinstance	No
PRITM_REQUIRED_QTY	_decimal_28_8	decimal(28)	Yes	This field captures the request qty of each line item of the PR	No
PRITM_ORDER_QTY	_decimal_28_8	decimal(28)	Yes	This field captures the PO Covered quantity updated from PO component	No
PRITM_PENDING_QTY	_decimal_28_8	decimal(28)	Yes	when create the PR, pending qty is same as required qty when update the ordered quantity from PO Pending quantity = required quantity order quantity	No
PRITM_COST	_decimal_28_8	decimal(28)	Yes	This field captures the Cost of the part, depending on cost per, it can be either cost of 1 part or more.	No
PRITM_COSTPER	_decimal_28_8	decimal(28)	Yes	This field captures the Unit cost of the part	No
PRITM_DELIVERY_TYPE	_varchar_25	Varchar(25)	Yes	This field captures the purchase request s delivery type List of values are S ingle all the requested qty will be delivered in a single schedule. M ultiple the requested qty will be delivered in a staggered schedule dates.	No
PRITM_NEED_DATE	_datetime_8	datetime(8)	Yes	This field captures the date in which the ordered qty has to be delivered.	No
PRITM_WH_CODE	_varchar_10	varchar(10)	Yes	This field captures the warehoouse code	No
PRITM_WH_OU	_decimal_10_0	decimal(10)	Yes	stores the warehouse OU instance	No
PRITM_SUPP_CODE	_varchar_45	varchar(45)	Yes	This field captures the Supplier code from the supplier component who has raise the purchase request.	No
PRITM_COMMENTS	_varchar_255	varchar(255)	Yes	This field captures the comments	No
PRITM_REF_DOC_NO	_varchar_40	varchar(40)	Yes	This field captures the reference document no this used to find from where the request is raised.	No
PRITM_PART_UOM	_varchar_10	varchar(10)	Yes	This field captures Any valid UOM from the UOM component in which the goods can be purchased .	No
PRITM_CONDITION	_varchar_25	Varchar(25)	Yes	This field captures the part condition List of values are New New Surplus Overhaul Servicable Unservicable	No
PRITM_REF_DOC_REVNO	_varchar_40	varchar(40)	Yes	stores the revision no of reference document for this PR	No
PRITM_QUALITY_ATTRIBUTE	_varchar_5	varchar(5)	Yes	This fields captures the Quality Attribute with the following values 1. S tandard 2. C ustom 3. N one	No
PRITM_CREATEDDATE	_datetime_8	datetime(8)	Yes	This field captures the date when the PR item details are created in the system	No
PRITM_CREATED_BY	_varchar_30	varchar(30)	Yes	This field captures the user who created the PR item details	No
PRITM_MODIFIEDDATE	_datetime_8	datetime(8)	Yes	This field captures the date when the PR item details are modified in the system	No
PRITM_MODIFIED_BY	_varchar_30	varchar(30)	Yes	This field captures the user who modified the PR item details	No
PRITM_WORK_CENTER	_varchar_30	varchar(30)	Yes	This field captures the work center.	No
PRITM_REF_DOC_LINE_NO	_decimal_10_0	decimal(10)	Yes	This field captures the reference document line no .	No
PRITM_REF_DOC_OU	_decimal_10_0	decimal(10)	Yes	This is the ouinstance in which reference document for this purchase request  is created.	No
PRITM_SHORTCLS_QTY	_decimal_28_8	decimal(28)	Yes	This field captures short close quantity	No
PRITM_CAPEX_NO	_varchar_18	varchar(18)	Yes	This field captures the capex no of the part.	No
PRITM_ALTERNATE_TYPE	_varchar_5	varchar(5)	Yes	This field captures alternate type	No
PRITM_ALTERNATE_PART_NO	_varchar_40	varchar(40)	Yes	This field captures alternate part no	No
PRITM_SCL_COMMENTS	_varchar_255	varchar(255)	Yes	This field captures short close comments	No
PRITM_LINE_STATUS	_varchar_5	varchar(5)	Yes	This field captures line status	No
PRITM_REF_DOC_TYPE	_varchar_5	varchar(5)	Yes	column to store reference document type	No
PRITM_TASK_NO	udd_workunitcode	varchar(30)	Yes	PR reference document task no	No
PRITM_INTSEQ_NO	udd_seqno	int(4)	Yes	PR reference document task internal sequence Number	No
PRITM_COST_BASIS	udd_txt20	varchar(20)	Yes	This column holds the cost basis value	No
PRITM_ACC_USAGE	udd_txt20	varchar(20)	Yes	This column holds the accounting usage value	No
PRITM_CST_USAGE	udd_txt20	varchar(20)	Yes	This column holds the costing usage value	No
PRITM_ANLY_CODE	udd_txt20	varchar(20)	Yes	This column holds the analysis code value	No
PRITM_SUBANLY_CODE	udd_txt20	varchar(20)	Yes	Thsi column holds the subanalysis code value	No
PRITM_MR_LINENO	udd_ctxt_ouinstance	int(4)	Yes	This column holds the MR line No	No
PRITM_MRPRCOV_QTY	udd_quantity	numeric(13)	Yes	This column holds the MR PR covered quantity maintained only at the backend level	No
PRITM_KNOCKOFF_PRQTY_INSTKUOM	udd_quantity	numeric(13)	Yes	This column holds the MR knock off quantity from PR PO maintained only at the backend level. To update the pending Demand table	No
PRITM_REP_FLAG	udd_flag	varchar(25)	Yes	Replenishment Flag of the pr document is stored here	No
PRITM_REP_WH	udd_warehouse	varchar(10)	Yes	Warehouse in which the replenishment should happen is stored here	No
PRITM_REP_WHQTY	udd_quantity	numeric(13)	Yes	Replenishment Quantity is stored here	No
PRITM_HARD_PEG_FLAG	udd_designparamcode	varchar(5)	Yes	PR Hard pegging flag , added for Exchange functionality	No

Table Name :	PR_PRQC_QUICK_CODE
Comment :	This table maintains the Quick Code information.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
PRQC_OUINSTANCE	_decimal_10_0	decimal(10)	No	This is the ouinstance in which the quick code is created is stored here	Yes
PRQC_QUICK_CODE	_varchar_25	Varchar(25)	No	Quick Code number stored here.	Yes
PRQC_TYPE	_varchar_25	Varchar(25)	No	Quick Code Type	Yes
PRQC_DESCRIPTION	_varchar_150	varchar(150)	No	Quick Code Description	No
PRQC_STATUS	_varchar_25	Varchar(25)	Yes	Quick Code Status is stored here. A Active I Inactive	No
PRQC_CREATED_BY	_varchar_30	varchar(30)	Yes	User who has created the quick code	No
PRQC_CREATEDDATE	_datetime_8	datetime(8)	Yes	Date on which quick code got created	No
PRQC_MODIFIED_BY	_varchar_30	varchar(30)	Yes	User who has modified the quick code.	No
PRQC_MODIFIEDDATE	_datetime_8	datetime(8)	Yes	Date on which quick code got modified.	No
PRQC_TIMESTAMP	_decimal_10_0	decimal(10)	Yes	Quick code Time stamp details.	No

Table Name :	PR_PRQUA_PR_QUALITY_DTL
Comment :	This table is Used To store the Parameter Information which was captured from the Aircraft Component and the Present Value for the related Part No associated with the PR Document.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
PRQUA_OUINSTANCE	_decimal_10_0	decimal(10)	No	This is the ouinstance in which purchase request is created	Yes
PRQUA_PR_NO	_varchar_40	varchar(40)	No	This field holds the purchase request number	Yes
PRQUA_PR_SERIAL_NO	_decimal_10_0	decimal(10)	No	This field holds the uniquely generated id of PR document	Yes
PRQUA_PR_ATTRIBUTE_ID	_varchar_40	varchar(40)	No	This field holds the attribute id of PR document	Yes
PRQUA_ATTRIBUTE_OU	_decimal_10_0	decimal(10)	Yes	This field holds the ouinstance of attribute component with which PR is created.	No
PRQUA_ATTRIBUTE_CODE	_varchar_10	varchar(10)	Yes	This field is to capture the attribute code of the PR document	No
PRQUA_ATTRIBUTE_TYPE	_varchar_5	varchar(5)	Yes	This field is to capture the attribute type of PR document	No
PRQUA_MAXIMUM_VALUE	_decimal_28_8	decimal(28)	Yes	This field holds the maximum value of PR document	No
PRQUA_MINIMUM_VALUE	_decimal_28_8	decimal(28)	Yes	This field holds the minimum value of PR document	No
PRQUA_STD_VALUE	_decimal_28_8	decimal(28)	Yes	This field holds the standard value of PR document	No
PRQUA_STD_MIN_VALUE	_decimal_28_8	decimal(28)	Yes	This field holds the standard minimum value of PR document	No
PRQUA_STD_MAX_VALUE	_decimal_28_8	decimal(28)	Yes	This field holds the standard maximum value of PR document	No
PRQUA_STD_QUAL_VALUE	_varchar_80	varchar(80)	Yes	This field holds the standard qualitative value	No
PRQUA_TRACKABLE	_varchar_5	varchar(5)	Yes	This field is set when the trackable option is allowed. Allowed values are 1.YES 2.NO	No
PRQUA_REMARKS	_varchar_255	varchar(255)	Yes	This field holds the inspect remarks of PR component	No
PRQUA_CREATEDDATE	_datetime_8	datetime(8)	Yes	This field holds the created date of the record	No
PRQUA_CREATED_BY	_varchar_30	varchar(30)	Yes	This field holds the user who created the record	No
PRQUA_MODIFIEDDATE	_datetime_8	datetime(8)	Yes	This field holds the modified date of the record	No
PRQUA_MODIFIED_BY	_varchar_30	varchar(30)	Yes	This field holds the user who modified the record	No

Table Name :	PR_PRSCH_PR_SCH_DETAILS
Comment :	This table holds the purchase request schedule details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
PRSCH_OUINSTANCE	_decimal_10_0	decimal(10)	No	This is the ouinstance in which purchase request schedule details is created	Yes
PRSCH_PR_NO	_varchar_40	varchar(40)	No	This field holds the purchase request number	Yes
PRSCH_PR_SERIAL_NO	_decimal_10_0	decimal(10)	No	This field capures the Unique identifier number for the part of the PR	Yes
PRSCH_SCH_NO	_decimal_10_0	decimal(10)	No	This field captures the schedule number	Yes
PRSCH_SCH_QTY	_decimal_28_8	decimal(28)	Yes	This field captures the schedule quantity of the part	No
PRSCH_SCH_DATE	_datetime_8	datetime(8)	Yes	This field captures the date in which the schedule qty has to be delivered.	No
PRSCH_PENDING_SCH_QTY	_decimal_28_8	decimal(28)	Yes	stores the pending schedule quantity	No
PRSCH_CREATEDDATE	_datetime_8	datetime(8)	Yes	This field captures the date when the PR Schedule details are created in the system	No
PRSCH_CREATED_BY	_varchar_30	varchar(30)	Yes	This field captures the user who created the PR schedule details	No
PRSCH_MODIFIEDDATE	_datetime_8	datetime(8)	Yes	This field captures the date when the PR Schedule details are modified in the system	No
PRSCH_MODIFIED_BY	_varchar_30	varchar(30)	Yes	This field captures the user who modified the PR schedule details	No

Table Name :	PR_PRSCRP_PUR_SCRAP_COVERAGE_DTL
Comment :	Table holds the coverage between the purchase request document and the scrap note document at quantity leve

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
PRSCRP_UNIQUE_NO	udd_unique_id	bigint(8)	No	Unique No for the details	Yes
PRSCRP_OUINSTANCE	udd_ctxt_ouinstance	int(4)	No	Ouinstance in which the transaction is happening	No
PRSCRP_PR_NO	udd_documentno	varchar(40)	No	purchase request no	No
PPSCRP_PR_SERIAL_NO	udd_seqno	int(4)	No	Purchase request line no	No
PRSCRP_PR_SCRAP_LINENO	udd_seqno	int(4)	No	Scrap line no	No
PRSCRP_PART_NO	udd_partno	varchar(40)	No	Part No	No
PRSCRP_SCRAP_OUINSTANCE	udd_ctxt_ouinstance	int(4)	No	Ouinstance of the scrap note document	No
PRSCRP_SCRAP_note_no	udd_documentno	varchar(40)	No	Scrap note document	No
PRSCRP_SCRAP_Part_Unique_no	udd_unique_id	bigint(8)	No	Scrap part unique id	No
PRSCRP_COVERED_QTY	udd_quantity	numeric(13)	No	Covered Qty	No
PRSCRP_CREATED_DATE	udd_datetime1	datetime(8)	No	Date on which the coverage has happened	No
PRSCRP_CREATED_BY	udd_ctxt_user	varchar(30)	No	User by whom the coverage has happened	No
PRSCRP_MODIFIED_DATE	udd_datetime1	datetime(8)	No	Date on which the coverage details has been modifed	No
PRSCRP_MODIFIED_BY	udd_ctxt_user	varchar(30)	No	User by whom the coverage details are modified	No
PRSCRP_COVERED_STKUOM_QTY	udd_quantity	numeric(13)	No	Covered Qty in stock uom	No

Table Name :	PR_PRSOPT_SETOPTION_INFO
Comment :	This table is used to store numbering type options for Automatic PR creation.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
PRSOPT_PR_OUINSTANCE	_decimal_10_0	decimal(10)	No	This is the ouinstance in which Automatic purchase request is created	Yes
PRSOPT_NUMTYP_FOR_AUTOPR	_varchar_5	varchar(5)	No	This the default numbering type defined for Automatic PR creation.	Yes
PRSOPT_CREATED_DATE	_datetime_8	datetime(8)	Yes	This field  captures the date when the default numbering type details are created for Automatic PR created in the system	No
PRSOPT_CREATED_BY	_varchar_30	varchar(30)	Yes	This field  captures the user who created the default numbering type for Automatic PR created.	No
PRSOPT_MODIFIED_DATE	_datetime_8	datetime(8)	Yes	This field  captures the date when the Set Options for Default numbering type for Automatic PR is modified in the system	No
PRSOPT_MODIFIED_BY	_varchar_30	varchar(30)	Yes	This field  captures the user who modified the default numbering type for Automatic PR Creation.	No
PRSOPT_DefStdNote	udd_designparamcode	varchar(5)	Yes	This field captures the default standard note setting	No

Table Name :	PR_PRSTATUS_HIS_DTL
Comment :	PR status history table

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
PR_PRNO	udd_documentno	varchar(40)	Yes	PR # for which the status change was done is stored here	No
PR_PROU	udd_ctxt_ouinstance	int(4)	Yes	Login Ouinstance in which the status change is done is stored here	No
PR_FROMSTATUS	udd_designparamcode	varchar(5)	Yes	Status from which the PR document is modified is stored here	No
PR_TOSTATUS	udd_designparamcode	varchar(5)	Yes	Status of the document to which it was modified is stored here	No
PR_MODIFIEDDATE	udd_time	datetime(8)	Yes	User who has modified the status is stored here	No
PR_MODIFIEDBY	udd_ctxt_user	varchar(30)	Yes	Date on which the status is modified is stored here	No
PR_REMARKS	udd_txt2000	varchar(2000)	Yes	Remarks provided for the status change is stored here	No
REPLICATION_KEY	_bigint_8	Bigint(8)	No	Unique Number	Yes

Table Name :	PR_PRUDI_USER_DEF_INFO
Comment :	This table holds the user defined info of purchase request document

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
PRUDI_OUINSTANCE	_decimal_10_0	decimal(10)	No	This is the ouinstance in which purchase request document is created	Yes
PRUDI_PR_NO	_varchar_40	varchar(40)	No	This field holds the document number of purchase request component	Yes
PRUDI_USER_DEF_DESC1	_varchar_30	varchar(30)	Yes	This field holds the first user defined description	No
PRUDI_USER_DEF_OPT1	_varchar_30	varchar(30)	Yes	This field holds the first user defined option	No
PRUDI_USER_DEF_DESC2	_varchar_30	varchar(30)	Yes	This field holds the second user defined description	No
PRUDI_USER_DEF_OPT2	_varchar_30	varchar(30)	Yes	This field holds the second user defined option	No
PRUDI_USER_DEF_DESC3	_varchar_30	varchar(30)	Yes	This field holds the third user defined description	No
PRUDI_USER_DEF_OPT3	_varchar_30	varchar(30)	Yes	This field holds the third user defined option	No
PRUDI_USER_DEF_DESC4	_varchar_30	varchar(30)	Yes	This field holds the fourth user defined description	No
PRUDI_USER_DEF_OPT4	_varchar_30	varchar(30)	Yes	This field holds the fourth user defined option	No
PRUDI_USER_DEF_REMARKS	_varchar_255	varchar(255)	Yes	This field holds the user defined remarks	No
PRUDI_CREATED_DATE	_datetime_8	datetime(8)	Yes	This field holds the created date of the record	No
PRUDI_CREATED_BY	_varchar_30	varchar(30)	Yes	This field holds the user who created the record	No
PRUDI_MODIFIED_DATE	_datetime_8	datetime(8)	Yes	This field holds the modified date of the record	No
PRUDI_MODIFIED_BY	_varchar_30	varchar(30)	Yes	This field holds the user who modified the record	No