Data Dictionary -- Manage Sales RFQ

Srl. No.	Table Name	Comment
1	RFQ_COREPART_DTL	RFQ_COREPART_DTL
2	RFQ_PARTINFO_DTL	RFQ_PARTINFO_DTL
3	RFQ_REQ_QUOT_HDR	RFQ_REQ_QUOT_HDR
4	RFQ_RFQPRM_PARAMETER_DETAILS	RFQ_RFQPRM_PARAMETER_DETAILS
5	RFQ_WORKSCOPE_DTL	RFQ_WORKSCOPE_DTL

Table Name :	RFQ_COREPART_DTL
Comment :	RFQ_COREPART_DTL

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
RFQ_COREPRT_NO	_fin_documentno_40	fin_documentno(40)	No	Customer Request Number	Yes
RFQ_COREPRT_OU	_fin_ctxt_ouinstance_4	fin_ctxt_ouinstance(4)	No	Ouinstance	Yes
RFQ_COREPRT_LINENO	_fin_seqno_4	fin_seqno(4)	Yes	Part info reference lineno	No
RFQ_COREPRT_CORELINENO	_fin_seqno_4	fin_seqno(4)	No	core part info reference lineno	Yes
RFQ_COREPRT_COREPART	_fin_partno_40	fin_partno(40)	Yes	Part Number	No
RFQ_COREPRT_MFRPARTNO	_fin_partno_40	fin_partno(40)	Yes	MFR part no	No
RFQ_COREPRT_MFRNO	_fin_partno_40	fin_partno(40)	Yes	MFR no	No
RFQ_COREPRT_PARTSLNO	_fin_partserialnumber_40	fin_partserialnumber(40)	Yes	Serial no	No
RFQ_COREPRT_MSNNO	_fin_partserialnumber_40	fin_partserialnumber(40)	Yes	MSN no	No
RFQ_COREPRT_LOTNO	_fin_lotno_18	fin_lotno(18)	Yes	Lot Number	No
RFQ_COREPRT_MFRLOTNO	_fin_lotno_18	fin_lotno(18)	Yes	Mfrlot no	No
RFQ_COREPRT_APPL	_fin_application_40	fin_application(40)	Yes	Applicability(part/aircraft)	No
RFQ_COREPRT_AC_REGNO	_fin_acregno_30	fin_acregno(30)	Yes	Aircraft no	No
RFQ_COREPRT_ACMSN	_fin_msnno_40	fin_msnno(40)	Yes	AC MSN no	No
RFQ_COREPRT_EXPRCPTDT	_fin_date_8	fin_date(8)	Yes	Expected Receipt Date	No
RFQ_COREPRT_COREQTY	_fin_quantity_17	fin_quantity(17)	Yes	Core Quantity	No
RFQ_COREPRT_UOM	_fin_uom_15	fin_uom(15)	Yes	Core UOM	No
RFQ_COREPRT_PRTCOND	_fin_quickcodes_25	fin_quickcodes(25)	Yes	Part condition	No
RFQ_COREPRT_NOTES	_fin_notes_2000	fin_notes(2000)	Yes	Core part notes	No
RFQ_COREPRT_RAC_ACREGNO	_fin_acregno_30	fin_acregno(30)	Yes	Removed From A/C Reg. #	No
RFQ_COREPRT_RAC_MSN	_fin_msnno_40	fin_msnno(40)	Yes	Removed From A/C MSN	No
RFQ_COREPRT_RAC_PRT	_fin_partno_40	fin_partno(40)	Yes	Removed From part no	No
RFQ_COREPRT_RAC_MFRNO	_fin_vendorcode_45	fin_vendorcode(45)	Yes	Removed Mfr. #	No
RFQ_COREPRT_RAC_SLNO	_fin_partserialnumber_40	fin_partserialnumber(40)	Yes	Removed Serial #	No
RFQ_COREPRT_RAC_DTTI	_fin_datetime_8	fin_datetime(8)	Yes	DeliveryInstruction	No
RFQ_COREPRT_RAC_REMRES	_fin_notes_2000	fin_notes(2000)	Yes	Removel remarks	No
RFQ_COREPRT_RAC_MODINS	_fin_notes_2000	fin_notes(2000)	Yes	MOD Instructions	No
RFQ_COREPRT_RAC_CUSTREF	_fin_notes_2000	fin_notes(2000)	Yes	Cust. Maint. References	No
RFQ_COREPRT_RAC_JOBREF	_fin_notes_2000	fin_notes(2000)	Yes	Job Card References	No
RFQ_COREPRT_RAC_DSCREF	_fin_notes_2000	fin_notes(2000)	Yes	Discrepancy Reference	No
RFQ_COREPRT_RAC_RCPTCOM	_fin_notes_2000	fin_notes(2000)	Yes	Receipt Comments	No
RFQ_COREPRT_FLNAME	_fin_documentno_40	fin_documentno(40)	Yes	File Name	No
RFQ_COREPRT_CONTRACT	_fin_documentno_40	fin_documentno(40)	Yes	Contract No	No
RFQ_COREPRT_QUOTREM	_fin_notes_2000	fin_notes(2000)	Yes	Quote Remarks	No
RFQ_COREPRT_PQUOT_NO	_fin_documentno_40	fin_documentno(40)	Yes	Prequote no	No
RFQ_COREPRT_PQUOT_REVNO	_fin_revno_3	fin_revno(3)	Yes	Prequote revision no	No
RFQ_COREPRT_PROCRMKS	_fin_notes_2000	fin_notes(2000)	Yes	Processing remarks	No
RFQ_COREPRT_OBJEFFCD	_fin_effectivitycode_40	fin_effectivitycode(40)	Yes	Object reference no	No
RFQ_COREPRT_CON_LINENO	_fin_lineno_4	fin_lineno(4)	Yes	Contract lineNo	No
RFQ_COREPRT_CREATEDBY	_fin_ctxt_user_30	fin_ctxt_user(30)	Yes	Created BY	No
RFQ_COREPRT_CREATEDDT	_fin_date_8	fin_date(8)	Yes	Created Date	No
RFQ_COREPRT_MODIFYBY	_fin_ctxt_user_30	fin_ctxt_user(30)	Yes	Modified By	No
RFQ_COREPRT_MODIFYDT	_fin_date_8	fin_date(8)	Yes	Modified Date	No
RFQ_COREPRT_ERRORMSG	_fin_notes_2000	fin_notes(2000)	Yes	Error message	No
RFQ_COREPRT_REMO_STAT	_fin_station_40	fin_station(40)	Yes	Removel Station	No
RFQ_COREPRT_cono	_fin_documentno_40	fin_documentno(40)	Yes	Customer order No	No
RFQ_COREPRT_LNSTS	fin_status	varchar(25)	Yes	Line Status	No

Table Name :	RFQ_PARTINFO_DTL
Comment :	RFQ_PARTINFO_DTL

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
RFQ_PRTINF_NO	_fin_documentno_40	fin_documentno(40)	No	Customer Request Number	Yes
RFQ_PRTINF_OU	_fin_ctxt_ouinstance_4	fin_ctxt_ouinstance(4)	No	Ouinstance	Yes
RFQ_PRTINF_LINENO	_fin_seqno_4	fin_seqno(4)	No	Part info reference lineno	Yes
RFQ_PRTINF_LNSTS	_fin_status_25	fin_status(25)	Yes	Line Status	No
RFQ_PRTINF_PARTNO	_fin_partno_40	fin_partno(40)	Yes	Part no	No
RFQ_PRTINF_PARTDESC	_fin_partdesc_150	fin_partdesc(150)	Yes	Part Description	No
RFQ_PRTINF_MFRPARTNO	_fin_partno_40	fin_partno(40)	Yes	MFR part no	No
RFQ_PRTINF_MFRNO	_fin_vendorcode_45	fin_vendorcode(45)	Yes	Mfr no	No
RFQ_PRTINF_REQQTY	_fin_quantity_17	fin_quantity(17)	Yes	Required Quantity	No
RFQ_PRTINF_UOM	_fin_uom_15	fin_uom(15)	Yes	Uom	No
RFQ_PRTINF_NEEDDT	_fin_date_8	fin_date(8)	Yes	Need Date	No
RFQ_PRTINF_PRTCOND	_fin_designparamcode_5	fin_designparamcode(5)	Yes	Part condition	No
RFQ_PRTINF_ALTPRT	_fin_designparamcode_5	fin_designparamcode(5)	Yes	Allow Alternate Part	No
RFQ_PRTINF_QUOTREM	_fin_notes_2000	fin_notes(2000)	Yes	Quote Remarks	No
RFQ_PRTINF_CERTTYP	_fin_documentno_40	fin_documentno(40)	Yes	Certificate Type	No
RFQ_PRTINF_NOTES	_fin_notes_2000	fin_notes(2000)	Yes	Part info Note	No
RFQ_PRTINF_SPECINST	_fin_notes_2000	fin_notes(2000)	Yes	Specks Restrictions	No
RFQ_PRTINF_DELINST	_fin_notes_2000	fin_notes(2000)	Yes	Delivery Instructions	No
RFQ_PRTINF_SHIPID	_fin_addressid_12	fin_addressid(12)	Yes	Ship To Address ID	No
RFQ_PRTINF_NEWPRT	_fin_flag_25	fin_flag(25)	Yes	New Part	No
RFQ_PRTINF_FILENAME	_fin_quickcodes_25	fin_quickcodes(25)	Yes	File Name	No
RFQ_PRTINF_PQUOT_NO	_fin_documentno_40	fin_documentno(40)	Yes	Prequote no	No
RFQ_PRTINF_PQUOT_REVNO	_fin_revno_3	fin_revno(3)	Yes	Prequote revision no	No
RFQ_PRTINF_PROCRMKS	_fin_notes_2000	fin_notes(2000)	Yes	Processing Remarks	No
RFQ_PRTINF_CREATEDBY	_fin_ctxt_user_30	fin_ctxt_user(30)	Yes	Created By	No
RFQ_PRTINF_CREATEDDT	_fin_date_8	fin_date(8)	Yes	Created Date	No
RFQ_PRTINF_MODIFYBY	_fin_ctxt_user_30	fin_ctxt_user(30)	Yes	Modified By	No
RFQ_PRTINF_MODIFYDT	_fin_date_8	fin_date(8)	Yes	Modified Date	No
RFQ_PRTINF_ERRORMSG	_fin_notes_2000	fin_notes(2000)	Yes	Error message	No
RFQ_PRTINF_Consumed	_fin_designparamcode_5	fin_designparamcode(5)	Yes	Home based stock consumption	No
RFQ_PRTINF_SrlNo	_fin_partserial_100	fin_partserial(100)	Yes	Serial no	No

Table Name :	RFQ_REQ_QUOT_HDR
Comment :	RFQ_REQ_QUOT_HDR

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
RFQ_HDR_NO	_fin_documentno_40	fin_documentno(40)	No	Customer Request Number	Yes
RFQ_HDR_OU	_fin_ctxt_ouinstance_4	fin_ctxt_ouinstance(4)	No	Ouinstance	Yes
RFQ_HDR_REQTYPE	_fin_doctype_40	fin_doctype(40)	Yes	Request Type	No
RFQ_HDR_REQFOR	_fin_quickcodes_25	fin_quickcodes(25)	Yes	Request For	No
RFQ_HDR_DOCSTS	_fin_status_25	fin_status(25)	Yes	Document Status	No
RFQ_HDR_PRSTS	_fin_desc40_40	fin_desc40(40)	Yes	Processing Status	No
RFQ_HDR_DATE	_fin_date_8	fin_date(8)	Yes	Request Date	No
RFQ_HDR_CAT	_fin_status_25	fin_status(25)	Yes	Category	No
RFQ_HDR_DESC	_fin_notes_2000	fin_notes(2000)	Yes	Description	No
RFQ_HDR_PRIORITY	_fin_desc40_40	fin_desc40(40)	Yes	Priority	No
RFQ_HDR_EXPDATE	_fin_date_8	fin_date(8)	Yes	Expected Reply Date	No
RFQ_HDR_CUSTREF	_fin_documentno_40	fin_documentno(40)	Yes	Customer Ref. #	No
RFQ_HDR_QREM	_fin_notes_2000	fin_notes(2000)	Yes	Quote Remarks	No
RFQ_HDR_DELNOTE	_fin_notes_2000	fin_notes(2000)	Yes	Delivery Notes	No
RFQ_HDR_USSTS	_fin_quickcodes_25	fin_quickcodes(25)	Yes	User Status	No
RFQ_HDR_NEEDDATE	_fin_date_8	fin_date(8)	Yes	Need Date	No
RFQ_HDR_FILENAME	_fin_quickcodes_25	fin_quickcodes(25)	Yes	File Name	No
RFQ_HDR_SHIPID	_fin_addressid_12	fin_addressid(12)	Yes	Ship Address ID	No
RFQ_HDR_CUSTNO	_fin_documentno_40	fin_documentno(40)	Yes	Customer #	No
RFQ_HDR_CUSID	_fin_addressid_12	fin_addressid(12)	Yes	Customer Address ID	No
RFQ_HDR_COMMENTS	_fin_notes_2000	fin_notes(2000)	Yes	Comments	No
RFQ_HDR_APPL	_fin_application_40	fin_application(40)	Yes	Applicability(part/aircraft)	No
RFQ_HDR_AC_REGNO	_fin_acregno_30	fin_acregno(30)	Yes	Aircraft Reg no	No
RFQ_HDR_ACMSN	_fin_msnno_40	fin_msnno(40)	Yes	MSN no	No
RFQ_HDR_EXPRCPTDT	_fin_date_8	fin_date(8)	Yes	Expected Receipt Date	No
RFQ_HDR_TIMESTAMP	_fin_int_4	fin_int(4)	Yes	Timestamp	No
RFQ_HDR_CREATEDBY	_fin_ctxt_user_30	fin_ctxt_user(30)	Yes	Created By	No
RFQ_HDR_CREATEDDT	_fin_date_8	fin_date(8)	Yes	Created Date	No
RFQ_HDR_MODIFYBY	_fin_ctxt_user_30	fin_ctxt_user(30)	Yes	Modified By	No
RFQ_HDR_MODIFYDT	_fin_date_8	fin_date(8)	Yes	Modified Date	No
RFQ_HDR_CONFIRMEDBY	_fin_ctxt_user_30	fin_ctxt_user(30)	Yes	Confirmed By	No
RFQ_HDR_CONFIRMEDDT	_fin_date_8	fin_date(8)	Yes	Confirmed Date	No
rfq_pr_sts	_fin_status_25	fin_status(25)	Yes	Process Status	No
RFQ_HDR_EVT_STS	_fin_description_100	fin_description(100)	Yes	NA	No
RFQ_HDR_FUL_DT	_fin_datetime_8	fin_datetime(8)	Yes	NA-	No
RFQ_HDR_SHIP_CONT_PER	fin_custname	varchar(40)	Yes	Ship to Contact Person	No
rfq_hdr_flag	fin_flag	varchar(25)	Yes	Flag	No
RFQ_HDR_CONT_PER	fin_custname	varchar(40)	Yes	Contact Person	No

Table Name :	RFQ_RFQPRM_PARAMETER_DETAILS
Comment :	RFQ_RFQPRM_PARAMETER_DETAILS

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
RFQPRM_COMPONENTNAME	udd_txt150	varchar(150)	Yes	Component Name	No
RFQPRM_PARAMCATEGORY	udd_paramcategory	varchar(10)	Yes	Paremeter Category	No
RFQPRM_PARAMTYPE	udd_paramtype	varchar(25)	Yes	Parameter Type	No
RFQPRM_PARAMCODE	udd_designparamcode	varchar(5)	Yes	Paremeter code	No
RFQPRM_LANGID	udd_languageid	int(4)	Yes	Language	No
RFQPRM_PARAMDESC	udd_txt80	varchar(80)	Yes	Parameter description	No
RFQPRM_SORTBY	udd_sortby	numeric(9)	Yes	Sort By no	No
RFQPRM_CREATEDDATE	datetime	Datetime(8)	Yes	Created Date	No
replication_key	uniqueidentifier	Varchar(160)	Yes	Replication key	No
seqno	bigint	Bigint(8)	No	Sequence no	Yes

Table Name :	RFQ_WORKSCOPE_DTL
Comment :	RFQ_WORKSCOPE_DTL

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
RFQ_WRKSCOP_NO	_fin_documentno_40	fin_documentno(40)	No	Customer Request Number	Yes
RFQ_WRKSCOP_OU	_fin_ctxt_ouinstance_4	fin_ctxt_ouinstance(4)	No	Ouinstance	Yes
RFQ_WRKSCOP_REFLINENO	_fin_seqno_4	fin_seqno(4)	No	Reference line no	No
RFQ_WRKSCOP_WCLINENO	_fin_seqno_4	fin_seqno(4)	No	Workscope Reference Lineno	Yes
RFQ_WRKSCOP_REPPROCCD	_fin_documentno_40	fin_documentno(40)	Yes	Repair Process Code	No
RFQ_WRKSCOP_TASKNO	_fin_taskno_40	fin_taskno(40)	Yes	Task No	No
RFQ_WRKSCOP_AMMREF	_fin_notes_2000	fin_notes(2000)	Yes	AMM Reference	No
RFQ_WRKSCOP_TSKCARDREF	_fin_notes_2000	fin_notes(2000)	Yes	Customer Task Card Reference	No
RFQ_WRKSCOP_WARREQ	_fin_designparamcode_5	fin_designparamcode(5)	Yes	Warranty Requested	No
RFQ_WRKSCOP_NOTES	_fin_notes_2000	fin_notes(2000)	Yes	Notes	No
RFQ_WRKSCOP_WORKENUMERATION	_fin_notes_2000	fin_notes(2000)	Yes	Work Enumeration	No
RFQ_WRKSCOP_CUSTREQDT	_fin_date_8	fin_date(8)	Yes	Cust. Required Date	No
RFQ_WRKSCOP_TASKREVNO	_fin_revisionno_40	fin_revisionno(40)	Yes	Task revision no	No
RFQ_WRKSCOP_TSKSQNO	_fin_seqno_4	fin_seqno(4)	Yes	Task Sequence No	No
RFQ_WRKSCOP_TSKTRACKID	_fin_tasktrackid_8	fin_tasktrackid(8)	Yes	Task track id	No
RFQ_WRKSCOP_TSK_PARTNO	_fin_partno_40	fin_partno(40)	Yes	Part no	No
RFQ_WRKSCOP_TSK_PRTSRLNO	_fin_documentno_40	fin_documentno(40)	Yes	Serial no	No
RFQ_WRKSCOP_CREATEDBY	_fin_ctxt_user_30	fin_ctxt_user(30)	Yes	Created By	No
RFQ_WRKSCOP_CREATEDDT	_fin_date_8	fin_date(8)	Yes	Created Date	No
RFQ_WRKSCOP_MODIFYBY	_fin_ctxt_user_30	fin_ctxt_user(30)	Yes	Modified By	No
RFQ_WRKSCOP_MODIFYDT	_fin_date_8	fin_date(8)	Yes	Modified Date	No
RFQ_WRKSCOP_ERRORMSG	_fin_notes_2000	fin_notes(2000)	Yes	Error message	No