Data Dictionary -- Supplier

Srl. No.	Table Name	Comment
1	SP_ADDLOPTPV_PARAM_VALUES	This table is used to store parameter values and description of supplier additional option
2	SP_ADDLOPTPV_PERMITTED_VALUES	This table is used to store permitted values of supplier additional option
3	Sp_DAI_Delivery_Address_Info	Delivery Address Info
4	SP_LOCCP_CONTACT_INFO	Contact info
5	SP_LOCDT_SUPP_LOC	This is the Location Detail table for the Location master containing information about the location addresses etc.
6	SP_LOCMS_SUPP_LOC	Loc table is OU specific. Each supplier can have zero or more locations
7	SP_LOCPT_PART_LEVEL_TCD	This contains TC & D attached to Parts at location level
8	sp_locpy_bill_supp_info	Contains information about which Supplier has to be billed for a particular location. This is at the Location level
9	SP_LOCPY_PAY_SUPP_INFO	Contains information about which Supplier has to be Paid for a particular location. This is at the Location level
10	SP_MPPRT_PRTS_SERV	THis table contains Mapping Parts to Services with Ceritifcations
11	SP_PARAMETER_DETAILS	This field holds the supplier parameter details
12	SP_RPRSP_SP_RSP_MAP	Repair Shop Mapping Services - Certification Details
13	SP_SBank_Sup_Bank_Info	This contains supplier bank information
14	SP_SETPRT_AUTOEXTREPAIR	SP_SETPRT_AUTOEXTREPAIR
15	SP_SPADDLOPT_Addl_Options	This table is used to store additional option of supplier
16	SP_SPAGR_PBHAGREE_DTLS	This Supplier table contains the information about the Agreement Details of the Supplier.
17	SP_SPPBH_PBH_ACMAP	This Table Contains the PBH Mapping for an Agreement of a particular Supplier.
18	SP_SPPBH_PBH_PRTMAP	To Store the Supplier Part and Agreement Details.
19	SP_SPROD_REF_OBJ_DTL	This table holds the supplier reference object details
20	SP_SPRTM_PARTS_MAP	This contains the Supplier - Part Mapping infos
21	SP_SQTPB_QTYPRCBRK_DET	To maintain price break up information for parts
22	SP_STCDM_TCD_MAP	This contains information about TC&Ds attached to Suppliers
23	SP_STDD_Tax_Default_Dtl	Default Tax # / Tax Variant # will be used for Invoicing. This has been maintained as a seperate table for future enhancements.
24	SP_STRD_Tax_Registration_Dtl	To store the address id, Tax Type and Registration # details for Invoicing reports
25	SP_SUPBNK_BANK_DTL	Bank details
26	SP_SUPCT_CERTIFICATE	This contains the certification issued for a supplier
27	SP_SUPDT_CTRL_REF	This is the Supplier Detail table for the Supplier master containing information about the Supplier addresses etc.
28	SP_SUPMS_CTRL_REF_MSTR	This is the Supplier Main table. It is control reference. It holds all the information about the Supplier
29	SP_Supplier_Logo_info	Table to store supplier Logo information
30	SP_SUPQC_QUICK_CODE	This table holds the quick code of the supplier
31	SP_TATDT_RECEIPT_INFO	SP_TATDT_RECEIPT_INFO

Table Name :	SP_ADDLOPTPV_PARAM_VALUES
Comment :	This table is used to store parameter values and description of supplier additional option

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ADDLOPTPV_OPTKEYCODE	udd_documentno	varchar(40)	No	Manage additional option Key code	Yes
ADDLOPTPV_Createddate	udd_paramcode	varchar(30)	Yes	Manage additional option Created Date	No
ADDLOPTPV_SortBy	udd_paramcode	varchar(30)	Yes	Manage additional option Sort by value	No
ADDLOPTPV_Mandatory_Check	udd_txt255	varchar(255)	Yes	Manage additional option mandatory check	No
ADDLOPTPV_ParamDesc	udd_designparamcode	varchar(5)	Yes	Manage additional option parameter description	No
ADDLOPTPV_Category	udd_seqno	int(4)	Yes	Manage additional option Category	No
ADDLOPTPV_ParameterCode	udd_time	datetime(8)	Yes	Manage additional option parameter code	No

Table Name :	SP_ADDLOPTPV_PERMITTED_VALUES
Comment :	This table is used to store permitted values of supplier additional option

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ADDLOPTPV_OPTKEYCODE	udd_documentno	varchar(40)	No	Manage additional option OPTkey code values	Yes
ADDLOPTPV_PermittedValue	udd_txt150	varchar(150)	Yes	Manage additional option permitted values	No
ADDLOPTPV_PermittedValue_Desc	udd_txt255	varchar(255)	Yes	Manage additional option permitted Description	No

Table Name :	Sp_DAI_Delivery_Address_Info
Comment :	Delivery Address Info

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
DAI_Seqno	_int_0	int(0)	No	Sequence no	Yes
DAI_Created_Ouinstance	udd_ctxt_ouinstance	int(4)	Yes	OU Instance	No
DAI_Supplier_id	udd_vendorcode	varchar(45)	Yes	Vendor code	No
DAI_order_priority	udd_txt20	varchar(20)	Yes	Priority codes	No
DAI_Hazmat_prts	udd_designparamcode	varchar(5)	Yes	Hazmat Parts-Metadata Yes,No	No
DAI_Delivertocode	udd_documentno	varchar(40)	Yes	Delivery to code	No
DAI_Remarks	udd_txt255	varchar(255)	Yes	Remarks	No
DAI_Createdby	udd_ctxt_user	varchar(30)	Yes	created user Name will be captured	No
DAI_Createddate	udd_datetime1	datetime(8)	Yes	created Date will be captured	No
DAI_modifiedby	udd_ctxt_user	varchar(30)	Yes	modified User Name will be captured	No
DAI_modifieddate	udd_datetime1	datetime(8)	Yes	modified Date will be captured	No
DAI_Timestamp	udd_timestamp	int(4)	Yes	Timestamp	No

Table Name :	SP_LOCCP_CONTACT_INFO
Comment :	Contact info

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
LOCCP_OUINSTANCE	_decimal_10_0	decimal(10)	No	This field is to define location code unique at Organization unit level	Yes
LOCCP_SUPPLIER_ID	_varchar_45	varchar(45)	No	To define supplier code unique at Company level or Organization unit level	Yes
LOCCP_ADDRESSID	_decimal_10_0	decimal(10)	Yes	This field holds the Address Id as specified in the Supplier Master Table	No
LOCCP_CREATED_OUINSTANCE	_decimal_10_0	decimal(10)	No	To specify the OU instance at which the Supplier was created.	Yes
LOCCP_LINE_NO	_decimal_10_0	decimal(10)	No	This field holds the line no of the supplier	Yes
LOCCP_CONTACT_PERSON	_varchar_80	varchar(80)	Yes	This field holds the contact person as specified in the Supplier Master Table	No
LOCCP_CONTACT_PERSON_UP	_varchar_80	varchar(80)	Yes	This field holds the contact person in upper case as specified in the Supplier Master Table	No
LOCCP_EMAIL_ID	_varchar_70	varchar(70)	Yes	Thsi field holds the Contact Persons email id	No
LOCCP_FAX	_varchar_70	varchar(70)	Yes	This field holds the Contact Persons Fax No.	No
LOCCP_MOBILE_NO	_varchar_70	varchar(70)	Yes	This field is to capture Contact Persons Mobile No.	No
LOCCP_PHONE_NO	_varchar_70	varchar(70)	Yes	This field is to capture Contact Persons Phone NO.	No
LOCCP_CREATED_BY	_varchar_30	varchar(30)	Yes	This field is to capture the user who created the record	No
LOCCP_CREATED_DATE	_datetime_8	datetime(8)	Yes	This field holds the created date of the record	No
LOCCP_MODIFIED_BY	_varchar_30	varchar(30)	Yes	This field is to capture the user who modified the record	No
LOCCP_MODIFIED_DATE	_datetime_8	datetime(8)	Yes	This field is to capture the modified dateof the record	No

Table Name :	SP_LOCDT_SUPP_LOC
Comment :	This is the Location Detail table for the Location master containing information about the location addresses etc.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
LOCDT_OUINSTANCE	_decimal_10_0	decimal(10)	No	This field is to define location code unique at Organization unit level	Yes
LOCDT_SUPPLIER_ID	_varchar_45	varchar(45)	No	To define supplier code unique at Company level or Organization unit level	Yes
LOCDT_CREATED_OUINSTANCE	_decimal_10_0	decimal(10)	No	To specify the OU instance at which the Supplier was created.	Yes
LOCDT_ADDRESSID	_decimal_10_0	decimal(10)	No	This field is to capture the Address Id of the supplier - corresponding to this Location	Yes
LOCDT_PREF_SEQ	_decimal_10_0	decimal(10)	Yes	This field holds the Preferred Seq of addresses of the supplier at location level	No
LOCDT_CREATED_BY	_varchar_30	varchar(30)	Yes	This field holds the User who has created the record.	No
LOCDT_CREATED_DATE	_datetime_8	datetime(8)	Yes	This field is to capture the created date of the record	No
LOCDT_MODIFIED_BY	_varchar_30	varchar(30)	Yes	This field holds the User who has modified the record.	No
LOCDT_MODIFIED_DATE	_datetime_8	datetime(8)	Yes	This field holds the modified date of the record	No
LOCDT_ADDR_CATEGORY	udd_address	varchar(40)	Yes	This field is to capture the Address category of user defined quick code type Address category.	No

Table Name :	SP_LOCMS_SUPP_LOC
Comment :	Loc table is OU specific. Each supplier can have zero or more locations

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
LOCMS_OUINSTANCE	_decimal_10_0	decimal(10)	No	This field is to define location code unique at Organization unit level	Yes
LOCMS_SUPPLIER_ID	_varchar_45	varchar(45)	No	To define supplier code unique at Company level or Organization unit level	Yes
LOCMS_CREATED_OUINSTANCE	_decimal_10_0	decimal(10)	No	To specify the OU instance at which the Supplier was created.	Yes
LOCMS_SUPP_NAME	_varchar_150	varchar(150)	Yes	This field holds the Supplier Name for other components easy access to this field .	No
LOCMS_SUPP_NAME_UP	_varchar_150	varchar(150)	Yes	This field holds the Supplier Name in upper case	No
LOCMS_SUPP_STATUS	_varchar_25	Varchar(25)	Yes	This field holds the Supplier status - various across locations. values 1.A - "Active", 2.I - InActive, 3.HP Hold Pay 4. HB Hold Buy 3.B -	No
LOCMS_PAYMODE	_varchar_25	Varchar(25)	Yes	This field holds the Agreed Pay mode between the supplier and purchaser will be defined for the Supplier at the OU level. Allowed Values are - 1. CS - "Cash", 2.CQ - "Check", 3.O - "Others" and 4.DD - "Demand Draft" 5. E, EFT 6.CC , Credit Card 7	No
LOCMS_PAY_PRIORITY	_varchar_25	Varchar(25)	Yes	This field holds the values H - "High", N - "Normal" and L - "Low"	No
LOCMS_PAYTERM_OU	_decimal_10_0	decimal(10)	Yes	This field holds the OU Instance of the Pay Term Component	No
LOCMS_PAYTERM_CODE	_varchar_25	Varchar(25)	Yes	This field holds the Agreed pay terms between the Supplier and Purchaser which will be defined for the Supplier at the ordering OU level. The code that identifies the payment term - Quick codes	No
LOCMS_CURRENCY	_varchar_20	varchar(20)	Yes	This field holds the Currency for this location	No
LOCMS_INV_OU_ID	_decimal_10_0	decimal(10)	Yes	This field Corresponds to OUInstanceID in the invoicing component.	No
LOCMS_IN_SHIP_BY	_varchar_25	Varchar(25)	Yes	This field holds the Inbound shipping method of supplier registered in the location	No
LOCMS_IN_SHIP_COST	_varchar_25	Varchar(25)	Yes	this field holds the inbound shipping cost of the supplier registered in the location	No
LOCMS_IN_PKG_CODE	_varchar_25	Varchar(25)	Yes	This field holds the inbound packaging code of the supplier registered in the location	No
LOCMS_IN_INS_LTY	_varchar_5	varchar(5)	Yes	This field holds Inbound shipping info insurance liability of the supplier registered in the location with the values 1. N - None, 2. S - Self, 3. SP - Suppliers.	No
LOCMS_OUT_SHIP_BY	_varchar_25	Varchar(25)	Yes	This field holds the Outbound shipping method of supplier registered in the location	No
LOCMS_OUT_SHIP_COST	_varchar_25	Varchar(25)	Yes	this field holds the outbound shipping cost of the supplier registered in the location	No
LOCMS_OUT_PKG_CODE	_varchar_25	Varchar(25)	Yes	This field holds the outbound packaging code of the supplier registered in the location	No
LOCMS_OUT_INS_LTY	_varchar_5	varchar(5)	Yes	This field holds the outbound insurance liability of the supplier registered in the location	No
LOCMS_CREATED_BY	_varchar_30	varchar(30)	Yes	This field holds the User who has created the record.	No
LOCMS_CREATED_DATE	_datetime_8	datetime(8)	Yes	This field holds the created date of the record	No
LOCMS_MODIFIED_BY	_varchar_30	varchar(30)	Yes	This field holds the User who modified the record.	No
LOCMS_MODIFIED_DATE	_datetime_8	datetime(8)	Yes	This field holds the modified date of the user record	No
LOCMS_TIMESTAMP	_decimal_10_0	decimal(10)	Yes	This field holds the Timestamp of a record.	No
LOCMS_USER_ID	_varchar_30	varchar(30)	Yes	This field holds stores the User name captured	No
Locms_HoldBuy	udd_chkflag	varchar(1)	Yes	To save the value for Hold Buy.	No
Locms_HoldPay	udd_chkflag	varchar(1)	Yes	To save the value for Hold Pay.	No
Locms_HoldRepair	udd_chkflag	varchar(1)	Yes	To save the value for Hold Repair	No
LOCMS_PAYEE_NAME	fin_txt150	varchar(150)	Yes	The field holds the payee name	No

Table Name :	SP_LOCPT_PART_LEVEL_TCD
Comment :	This contains TC & D attached to Parts at location level

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
LOCPT_OUINSTANCE	_decimal_10_0	decimal(10)	No	This field is to define location code unique at Organization unit level	Yes
LOCPT_SUPPLIER_ID	_varchar_45	varchar(45)	No	To define supplier code unique at Company level or Organization unit level	Yes
LOCPT_PART_NO	_varchar_40	varchar(40)	No	This field holds the part no mapped to supplier	Yes
LOCPT_CREATED_OUINSTANCE	_decimal_10_0	decimal(10)	No	To specify the OU instance at which the Supplier was created.	Yes
LOCPT_TCD_OUINSTANCE	_decimal_10_0	decimal(10)	Yes	Ths field is to capture OU instance of TCD component	No
LOCPT_PRT_OUINSTANCE	_decimal_10_0	decimal(10)	Yes	THis field is to capture OU instance of Part admin component	No
LOCPT_TCD_NO	_varchar_25	Varchar(25)	Yes	This field holds the TCD Number associated to part of supplier	No
LOCPT_TCD_VAR_NO	_varchar_25	Varchar(25)	Yes	This field holds the TCD Variant Number associated to part of supplier	No
LOCPT_CREATED_BY	_varchar_30	varchar(30)	Yes	This field holds the user who created the record	No
LOCPT_CREATED_DATE	_datetime_8	datetime(8)	Yes	This field holds the Created Date of the record	No
LOCPT_MODIFIED_BY	_varchar_30	varchar(30)	Yes	This field holds the user who Modified the record	No
LOCPT_MODIFIED_DATE	_datetime_8	datetime(8)	Yes	This field holds the Modified Date of the record	No
LOCPT_LINE_NO	_decimal_10_0	decimal(10)	No	This field holds the line no of the record	Yes
LOCPT_CHRG_TYPE	udd_designparamcode	varchar(5)	No	This field holds the Charge Type of the record	Yes

Table Name :	sp_locpy_bill_supp_info
Comment :	Contains information about which Supplier has to be billed for a particular location. This is at the Location level

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
locpy_ouinstance	fin_ouinstid	int(4)	Yes	This field is to define location code unique at Organization unit level	No
locpy_supplier_id	fin_suppliercode	varchar(16)	Yes	To define supplier code unique at Company level or Organization unit level	No
locpy_created_ouinstance	fin_ouinstid	int(4)	Yes	To specify the OU instance at which the Supplier was created.	No
locpy_bill_supp_id	fin_suppliercode	varchar(16)	Yes	The supplier created the bill	No
locpy_line_no	fin_lineno	int(4)	Yes	Thsi field holds the Line Number of pay-to-supplier id	No
locpy_default_supp	fin_suppliercode	varchar(16)	Yes	This field is to state Whether the pay to Supplier is the Default one or not	No
locpy_created_by	fin_ctxt_user	varchar(30)	Yes	This field holds the user who created the record	No
locpy_created_date	fin_date	datetime(8)	Yes	This field holds the created date of the record	No
locpy_modified_by	fin_ctxt_user	varchar(30)	Yes	This field holds the user who modified the record	No
locpy_modified_date	fin_date	datetime(8)	Yes	This field holds the Modified Date of the record	No
locpy_timestamp	fin_int	int(4)	Yes	This field holds the timestamp so that more than one user cant modified same record in the same time	No

Table Name :	SP_LOCPY_PAY_SUPP_INFO
Comment :	Contains information about which Supplier has to be Paid for a particular location. This is at the Location level

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
LOCPY_OUINSTANCE	_decimal_10_0	decimal(10)	No	This field is to define location code unique at Organization unit level	Yes
LOCPY_SUPPLIER_ID	_varchar_45	varchar(45)	No	To define supplier code unique at Company level or Organization unit level	Yes
LOCPY_CREATED_OUINSTANCE	_decimal_10_0	decimal(10)	No	To specify the OU instance at which the Supplier was created.	Yes
LOCPY_PAY_SUPP_ID	_varchar_45	varchar(45)	Yes	This field holds the Supplier ID to whom the payment is going to be made	No
LOCPY_LINE_NO	_decimal_10_0	decimal(10)	No	Thsi field holds the Line Number of pay-to-supplier id	Yes
LOCPY_DEFAULT_SUPP	_varchar_25	Varchar(25)	Yes	This field is to state Whether the pay to Supplier is the Default one or not	No
LOCPY_CREATED_BY	_varchar_30	varchar(30)	Yes	This field holds the user who created the record	No
LOCPY_CREATED_DATE	_datetime_8	datetime(8)	Yes	This field holds the created date of the record	No
LOCPY_MODIFIED_BY	_varchar_30	varchar(30)	Yes	This field holds the user who modified the record	No
LOCPY_MODIFIED_DATE	_datetime_8	datetime(8)	Yes	This field holds the Modified Date of the record	No
LOCPY_TIMESTAMP	_decimal_10_0	decimal(10)	Yes	This field holds the timestamp so that more than one user cant modified same record in the same time	No

Table Name :	SP_MPPRT_PRTS_SERV
Comment :	THis table contains Mapping Parts to Services with Ceritifcations

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
MPPRT_SUPPLIER_ID	_varchar_45	varchar(45)	No	To define supplier code unique at Company level or Organization unit level	No
MPPRT_CERTI_NO	_varchar_20	varchar(20)	Yes	This field holds the Certificate Number	No
MPPRT_CREATED_OUINSTANCE	_decimal_10_0	decimal(10)	No	To specify the OU instance at which the Supplier was created.	No
MPPRT_PART_ID	_decimal_10_0	decimal(10)	No	This field holds the uniquely generated part id	No
MPPRT_RPR_PRCS_NO	_varchar_25	Varchar(25)	No	THis field holds Repair Process Code of the part for the supplier	No
MPPRT_PART_NO	_varchar_40	varchar(40)	Yes	This field holds the Part No	No
MPPRT_STD_COST	_decimal_28_8	decimal(28)	Yes	This field holds the Standard Cost	No
MPPRT_AVG_LDTIME	_decimal_28_8	decimal(28)	Yes	This field holds the Average Lead Time	No
MPPRT_LDTIME_UOM	_varchar_10	varchar(10)	Yes	This field holds theLead Time Unit of measure with the values 1.D - Days, 2 W - Weeks, 3.M - Months and 4.B -	No
MPPRT_CREATED_BY	_varchar_30	varchar(30)	Yes	This field holds the user who created the record	No
MPPRT_CREATED_DATE	_datetime_8	datetime(8)	Yes	This field holds the created date of the record	No
MPPRT_MODIFIED_BY	_varchar_30	varchar(30)	Yes	This field holds the user who modified the record	No
MPPRT_MODIFIED_DATE	_datetime_8	datetime(8)	Yes	This field holds the modified date of the record	No
MPPRT_Under_CONTRACT	udd_desc40	varchar(40)	Yes	The flag holds the value whether the part is under contract or not	No
MPPRT_ContractNo	udd_documentno	varchar(40)	Yes	The contract no if the part is under contract	No
MPPRT_ContractDate	udd_datetime1	datetime(8)	Yes	This field holds the Contract Date of the part for the supplier.	No
MPPRT_CERTI_TYPE	udd_flag1	varchar(25)	Yes	This field holds the Certificate type of the part for the supplier.	No
MPPRT_EFFECT_FRMDATE	udd_time	datetime(8)	Yes	This field holds the Effective from date of the part for the supplier.	No
MPPRT_EFFECT_TODATE	udd_time	datetime(8)	Yes	This field holds the Effective To date of the part for the supplier.	No
MPPRT_CONTRACT_INFO	udd_remarks	varchar(255)	Yes	This field holds the Contract info of the part for the supplier.	No
MPPRT_REMARKS	udd_remarks	varchar(255)	Yes	This field holds the Contract info of the part for the supplier..	No
MPPRT_FILE_NAME	udd_filename	varchar(50)	Yes	This field holds the File name of the part for the supplier.	No
MPPRT_SHIP_LEAD_TIME	udd_duration	numeric(13)	Yes	This field holds the Ship lead time of the part for the supplier.	No
REPLICATION_KEY	_bigint_8	Bigint(8)	No	Unique Number	Yes

Table Name :	SP_PARAMETER_DETAILS
Comment :	This field holds the supplier parameter details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
SP_COMPONENTNAME	_varchar_20	varchar(20)	No	This field holds the Name of the component.	Yes
SP_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
SP_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
SP_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
SP_LANGID	_decimal_10_0	decimal(10)	No	Language id. This is the language id of the record.	Yes
SP_PARAMDESC	_varchar_80	varchar(80)	Yes	Param description is the values to be filled in the combo box or guidance text. This is actually the meta data of this component	No
SP_SORTBY	_decimal_10_0	decimal(10)	Yes	This field holds the default sort by code	No
SP_CREATIONDATE	_datetime_8	datetime(8)	Yes	This field holds the record created date for auditing purpose.	No

Table Name :	SP_RPRSP_SP_RSP_MAP
Comment :	Repair Shop Mapping Services - Certification Details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
RPRSP_SUPPLIER_ID	_varchar_45	varchar(45)	No	To define supplier code unique at Company level or Organization unit level	Yes
RPRSP_CREATED_OUINSTANCE	_decimal_10_0	decimal(10)	No	To specify the OU instance at which the Supplier was created.	Yes
RPRSP_RPR_PRCS_NO	_varchar_25	Varchar(25)	No	THis field holds Repair Process Code of the part for the supplier	Yes
RPRSP_CERTIFIED	_varchar_25	Varchar(25)	Yes	This field is set to yes if certified else no	No
RPRSP_CREATED_BY	_varchar_30	varchar(30)	Yes	This field holds the user who created the record	No
RPRSP_CREATED_DATE	_datetime_8	datetime(8)	Yes	This field holds the Created date of the record	No
RPRSP_MODIFIED_BY	_varchar_30	varchar(30)	Yes	This field is to store the user who modified the record	No
RPRSP_MODIFIED_DATE	_datetime_8	datetime(8)	Yes	This field is to store the Modified date	No
SP_SORTBY	_decimal_10_0	decimal(10)	Yes	This field holds the default sort by code	No

Table Name :	SP_SBank_Sup_Bank_Info
Comment :	This contains supplier bank information

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
SBank_OUINSTANCE	_decimal_10_0	decimal(10)	No	This field is to define location code unique at Organization unit level	No
SBank_SUPPLIER_ID	udd_vendorcode	varchar(45)	No	To define supplier code unique at Company level or Organization unit level	Yes
SBank_CREATED_OUINSTANCE	_decimal_10_0	decimal(10)	No	To specify the OU instance at which the Supplier was created.	Yes
SBank_Line_No	udd_seqno	int(4)	No	This field holds Line Number of the Bank information attached to supplier	Yes
SBank_Pay_Ref_id	udd_documentno	varchar(40)	Yes	This field holds Preference id of the bank information	No
SBank_Pay_Mode	udd_designparamcode	varchar(5)	Yes	This field holds Pay mode of the Bank	No
SBank_Bank_Type	udd_type	varchar(25)	Yes	This field holds Type of the Bank	No
SBank_Currency	udd_currency	varchar(20)	Yes	This field holds Currency which used for the bank transaction	No
SBank_Bank_AC_No	udd_banknumber	varchar(20)	Yes	This field holds Payee a/c no	No
SBank_IBAN_No	UDD_paycodes	varchar(45)	Yes	This field holds IBAN No	No
SBank_Swift_No	UDD_paycodes	varchar(45)	Yes	This field holds swift No	No
SBank_Nat_Clear_Code	udd_banknumber	varchar(20)	Yes	This field holds national clearence code.	No
SBank_Bank_Name	udd_bankname	varchar(40)	Yes	This field holds the bank name	No
SBank_Bank_Address1	udd_txt255	varchar(255)	Yes	This field holds the bank address1	No
SBank_Bank_Address2	udd_txt255	varchar(255)	Yes	This field holds the bank address2	No
SBank_Bank_Address3	udd_txt255	varchar(255)	Yes	This field holds the bank address3	No
SBank_Eff_Date_From	_datetime_8	datetime(8)	Yes	This field holds the effective from date of the bank information	No
SBank_Eff_Date_To	_datetime_8	datetime(8)	Yes	This field holds the effective to date of the bank information	No
SBank_Comments	udd_txt255	varchar(255)	Yes	This field holds the additional information/ comments regarding the bank information	No
SBank_Timestamp	udd_timestampint	int(4)	Yes	This field holds Timestamp of a record.	No
Sbank_created_by	udd_ctxt_user	varchar(30)	Yes	created by	No
STKCRMN_CREATED_DATETIME	udd_time	datetime(8)	Yes	created datetime	No
STKCRMN_MODIFIED_BY	udd_ctxt_user	varchar(30)	Yes	modified by	No
STKCRMN_MODIFIED_DATETIME	udd_time	datetime(8)	Yes	modified datetime	No
SBank_BICcode	fin_viewbyenum	varchar(15)	Yes	BIC CODE	No
SBank_BSBnumber	fin_bankcode	varchar(32)	Yes	BSB NUMBER	No
SBank_City	fin_city	Char(40)	Yes	CITY	No
SBank_CompanyBankCode	fin_bankcode	varchar(32)	Yes	Company Bank Code	No
SBank_CompanyBankType	fin_type	varchar(25)	Yes	Company Bank Type	No
SBank_ContactPerson	contactperson	Char(30)	Yes	Contact Person	No
SBank_ContractReference	fin_banknumber	varchar(20)	Yes	Contract Reference	No
SBank_Country	fin_country	varchar(40)	Yes	Country	No
SBank_Email	fin_email	Char(60)	Yes	Email	No
SBank_Fax	communicationid	varchar(30)	Yes	Fax	No
SBank_IntermediaryBankReference	fin_bankname	Char(40)	Yes	Intermediary Bank Reference	No
SBank_Phone	fin_banknumber	varchar(20)	Yes	Phone	No
SBank_RemitterID	fin_identifiervalue	Char(40)	Yes	Remitter ID	No
sbank_routing_no	fin_state	Char(40)	Yes	Routing Number	No
SBank_RoutingABAfedWire	udd_denomination	decimal(9)	Yes	Routing ABA fed Wire	No
SBank_RtgsIFSCcode	fin_vendorcode	Varchar(45)	Yes	RTGS IFSC code	No
SBank_SortCode	fin_bankcode	varchar(32)	Yes	Sort Code	No
SBank_State	fin_bankcode	varchar(32)	Yes	State	No
SBank_TransitNumber	fin_bankcode	varchar(32)	Yes	Transit Number	No
SBank_UserDefined1	fin_description	varchar(100)	Yes	User Defined1	No
SBank_UserDefined2	fin_description	varchar(100)	Yes	User Defined2	No
SBank_UserDefined3	fin_description	varchar(100)	Yes	User Defined3	No
SBank_UserDefined4	fin_description	varchar(100)	Yes	User Defined4	No
SBank_UserDefined5	fin_description	varchar(100)	Yes	User Defined5	No
SBank_Zip	fin_zip	Char(20)	Yes	Zip	No

Table Name :	SP_SETPRT_AUTOEXTREPAIR
Comment :	SP_SETPRT_AUTOEXTREPAIR

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
SETPRT_OU	udd_ctxt_ouinstance	int(4)	Yes	Part OU	No
SETPRT_SEQNO	udd_seqno	int(4)	No	Set paer seq number	Yes
SETPRT_PARTNO	udd_partno	varchar(40)	No	SET part number	No
SETPRT_PARTOU	udd_ctxt_ouinstance	int(4)	No	SET Part OU	No
SETPRT_INCALT	_bit_1	Bit(1)	Yes	Include alternate	No
SETPRT_WHAPP	udd_designparamcode	varchar(5)	Yes	Warehouse values	No
SETPRT_FROMWH	udd_warehouse	varchar(10)	Yes	Set part From Warehouse	No
SETPRT_REPAIRSHOP	udd_vendorcode	varchar(45)	No	SET PART REPAIR SHOP	No
SETPRT_ADDRESSID	udd_seqno	int(4)	Yes	Set part address ID	No
SETPRT_RTNTOWH	udd_warehouse	varchar(10)	No	Part return Warehouse	No
SETPRT_ROSTATUS	udd_status	varchar(25)	No	Ro status	No
SETPRT_ROCATEGORY	udd_quickcodes	varchar(25)	No	Part RO category	No
SETPRT_REPAIR_PROCESS_CODE	udd_quickcodes	varchar(25)	No	Repair process code	No
SETPRT_MAINT_TYPE	udd_designparamcode	varchar(5)	No	Part Maintain type	No
SETPRT_TASKNO	udd_documentno	varchar(40)	No	TASK number	No
SETPRT_ROREMARKS	udd_notes	varchar(2000)	Yes	Ro REMARKS	No
SETPRT_LEADTIME	udd_seqno	int(4)	Yes	LEAD TIME	No
SETPRT_CREATEDBY	udd_ctxt_user	varchar(30)	Yes	CREATED BY	No
SETPRT_CREATEDDATE	udd_datetime1	datetime(8)	Yes	CREATED DATE	No
SETPRT_LASTMODIFIEDBY	udd_ctxt_user	varchar(30)	Yes	LAST MODIFIED BY	No
SETPRT_LASTMODIFIEDDATE	udd_datetime1	datetime(8)	Yes	LAST MODIFIED DATE	No

Table Name :	SP_SPADDLOPT_Addl_Options
Comment :	This table is used to store additional option of supplier

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
SPADDLOPT_OUINSTANCE	udd_ctxt_ouinstance	int(4)	No	ouinstance	Yes
SPADDLOPT_Supplier	udd_vendorcode	varchar(45)	No	supplier	Yes
SPADDLOPT_OPtKeyCode	udd_documentno	varchar(40)	No	option key code	Yes
SPADDLOPT_Status	udd_designparamcode	varchar(5)	Yes	status	No
SPADDLOPT_Value	udd_txt255	varchar(255)	Yes	value	No
SPADDLOPT_Modifiedby	udd_ctxt_user	varchar(30)	Yes	modified by	No
SPADDLOPT_MODIFIEDDATE	udd_time	datetime(8)	Yes	modified date	No
CREATED_Area_Code	varchar	Char(10)	Yes	area code	No
SPADDLOPT_Timestamp	udd_timestampint	int(4)	Yes	time stamp	No
SPADDLOPT_Createdby	udd_ctxt_user	varchar(30)	Yes	created by	No
SPADDLOPT_CreatedDATE	udd_datetime	varchar(30)	Yes	created date	No

Table Name :	SP_SPAGR_PBHAGREE_DTLS
Comment :	This Supplier table contains the information about the Agreement Details of the Supplier.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
SPAGR_SUPPLIER_ID	_varchar_45	varchar(45)	No	To define supplier code unique at Company level or Organization unit level	Yes
SPAGR_CREATED_OUINSTANCE	_decimal_10_0	decimal(10)	No	To specify the OU instance at which the Supplier was created.	Yes
SPAGR_AGREE_SEQ_NO	_decimal_38_0	decimal(38)	No	This field holds the Sequence number of the agreements mapped to the supplier.	Yes
SPAGR_AGREEMENT_NO	_varchar_40	varchar(40)	No	To hold the Agreement number for a particular supplier.	Yes
SPAGR_AGREEMENT_DATE	_datetime_8	datetime(8)	Yes	The field holds the agreement date of the agreement number for a particular supplier.	No
SPAGR_EFFROM_DATE	_datetime_8	datetime(8)	Yes	The field holds the date from which the Agreement is applicable for a Supplier.	No
SPAGR_EFTO_DATE	_datetime_8	datetime(8)	Yes	This field holds the To date of the agreement number for a particular supplier.	No
SPAGR_PBH_ON	_varchar_25	Varchar(25)	Yes	The field holds if the agreement is power by hour on the supplier.	No
SPAGR_CONTRT_DEDUCTIBLE	_numeric_28_0	numeric(28)	No	This field holds the contract amount of the agreement for a particular supplier	No
SPAGR_CURRENCY	_varchar_18	varchar(18)	Yes	This field holds specifies the contract amount currency for an agreement.	No
SPAGR_REV_NO	udd_revisionno	varchar(40)	Yes	This field holds specifies the Revision number of the Agreement for a particular supplier.	No
SPAGR_REV_DATE	_datetime_8	datetime(8)	Yes	This fields holds the Revision date of the Agreement for a particular supplier.	No
SPAGR_CREATED_BY	udd_ctxt_user	varchar(30)	Yes	This field holds the user who created the record	No
SPAGR_CREATED_DATE	_datetime_8	datetime(8)	Yes	This field holds the created date of the record	No
SPAGR_MODIFIED_BY	udd_ctxt_user	varchar(30)	Yes	This field holds the user who modified the record	No
SPAGR_MODIFIED_DATE	_datetime_8	datetime(8)	Yes	This field holds the modified date of the record	No

Table Name :	SP_SPPBH_PBH_ACMAP
Comment :	This Table Contains the PBH Mapping for an Agreement of a particular Supplier.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
SPACPBH_SUPPLIER_ID	_varchar_45	varchar(45)	No	To define supplier code unique at Company level or Organization unit level	Yes
SPACPBH_CREATED_OUINSTANCE	_decimal_10_0	decimal(10)	No	To specify the OU instance at which the Supplier was created.	Yes
SPACPBH_AGREEMENT_NO	_varchar_40	varchar(40)	No	To hold the Agreement number for a particular supplier.	Yes
SPACPBH_PBH_ON	_varchar_25	Varchar(25)	Yes	This field holds the Power by hour as Aircraft.	No
SPACPBH_MODEL_NO	_varchar_20	varchar(20)	No	This field holds the model number of the Aircraft.	Yes
SPACPBH_LINE_ID	_decimal_38_0	decimal(38)	Yes	This field holds the unique line id for the various Aircraft information.	No
SPACPBH_MANU_SRL_NO	_varchar_30	varchar(30)	Yes	This field holds the Manufacturer Serial no of the Aircraft.	No
SPACPBH_AC_REG_NO	_varchar_20	varchar(20)	No	This holds the Aircraft Registartion number.	Yes
SPACPBH_AC_UNDER_PBH	_varchar_5	varchar(5)	Yes	This field holds the value Y --Yes and N-- No which indicates whether the Aircraft is under PBH or not	No
SPACPBH_CREATED_BY	udd_ctxt_user	varchar(30)	Yes	This field holds the created user information of the Aircraft PBH.	No
SPACPBH_CREATED_DT	_datetime_8	datetime(8)	Yes	This field holds created Date information of the Aircraft PBH.	No
SPACPBH_MODIFIED_BY	udd_ctxt_user	varchar(30)	Yes	This field holds the modified user information.	No
SPACPBH_MODIFIED_DT	_datetime_8	datetime(8)	Yes	This field holds the modified date information of the Aircraft PBH.	No

Table Name :	SP_SPPBH_PBH_PRTMAP
Comment :	To Store the Supplier Part and Agreement Details.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
SPPRTPBH_SUPPLIER_ID	_varchar_45	varchar(45)	No	To define supplier code unique at Company level or Organization unit level	Yes
SPPRTPBH_CREATED_OUINSTANCE	_decimal_10_0	decimal(10)	No	To specify the OU instance at which the Supplier was created.	Yes
SPPRTPBH_AGREEMENT_NO	_varchar_40	varchar(40)	No	To hold the Agreement number for a particular supplier.	Yes
SPPRTPBH_PBH_ON	_varchar_5	varchar(5)	Yes	This hold the Pbh value as E--Engine or A -- Aircraft or O--Others to show whether the Power by hour is for an engine or for others.	No
SPPRTPBH_PRT_OU	_decimal_10_0	decimal(10)	Yes	This field holds the Part OU of the Part mapped to the supplier	No
SPPRTPBH_PRT_LINE_ID	_decimal_10_0	decimal(10)	Yes	This holds the sequence of the Part Numbers	No
SPPRTPBH_PRT_NO	_varchar_32	varchar(32)	No	This holds the Part no on which the PbH is enforced.	Yes
SPPRTPBH_PRT_SRL_NO	_varchar_40	varchar(40)	No	This hold the Part Serial Number information.	Yes
SPPRTPBH_COMP_OU	_decimal_10_0	decimal(10)	Yes	This field holds the Component OU of the Component mapped to the supplier	No
SPPRTPBH_COMP_ID	_varchar_90	varchar(90)	Yes	This field holds the Component ID of the Component mapped to the supplier	No
SPPRTPBH_PRT_CONDT	_varchar_20	varchar(20)	Yes	This has the Part condition on which the PBH is enforced.	No
SPPRTPBH_STCK_STATUS	_varchar_60	varchar(60)	Yes	This has the Stock Status of the Part.	No
SPPRTPBH_PRT_AC_NO	_varchar_20	varchar(20)	Yes	This has the Part, Aircraft Registration Number	No
SPPRTPBH_PRT_WAREHOUSE	_varchar_20	varchar(20)	Yes	This has the Warehouse of the Part.	No
SPPRTPBH_PRT_UNDER_PBH	_varchar_5	varchar(5)	Yes	This has the Under PBH value as Y--Yes and N --No for enforcing the PBH on Part.	No
SPPRTPBH_CREATED_BY	_varchar_30	varchar(30)	Yes	This has the created user information.	No
SPPRTPBH_CREATED_DT	_datetime_8	datetime(8)	Yes	This has the created date information.	No
SPPRTPBH_MODIFIED_BY	_varchar_30	varchar(30)	Yes	This field has the modified User information.	No
SPPRTPBH_MODIFIED_DT	_datetime_8	datetime(8)	Yes	This field has the modified date information.	No

Table Name :	SP_SPROD_REF_OBJ_DTL
Comment :	This table holds the supplier reference object details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
SPROD_SUPPLIER_ID	_varchar_45	varchar(45)	No	To define supplier code unique at Company level or Organization unit level	Yes
SPROD_CREATED_OUINSTANCE	_decimal_10_0	decimal(10)	No	To specify the OU instance at which the Supplier was created.	Yes
SPROD_DOC_LINE_ID	_decimal_10_0	decimal(10)	No	This is uniquely generated document line id	Yes
SPROD_REF_DOC_TYPE	_varchar_25	Varchar(25)	Yes	This field holds the reference document type of the supplier	No
SPROD_REF_DOC_ID	_varchar_20	varchar(20)	Yes	The field holds the reference document id of the supplier	No
SPROD_REF_DOC_FILE_NAME	_varchar_50	varchar(50)	Yes	This field holds the reference document file name	No
SPROD_CREATED_DATE	_datetime_8	datetime(8)	Yes	This field holds the created date of the record	No
SPROD_CREATED_BY	_varchar_30	varchar(30)	Yes	This field holds the user who created the record	No
SPROD_MODIFIED_DATE	_datetime_8	datetime(8)	Yes	This field holds the modified date of the record	No
SPROD_MODIFIED_BY	_varchar_30	varchar(30)	Yes	This field holds the user who modified the record	No

Table Name :	SP_SPRTM_PARTS_MAP
Comment :	This contains the Supplier - Part Mapping infos

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
SPRTM_SUPPLIER_ID	_varchar_45	varchar(45)	No	To define supplier code unique at Company level or Organization unit level	Yes
SPRTM_PRT_NO	_varchar_40	varchar(40)	No	This field holds the Part No mapped to the supplier	Yes
SPRTM_CREATED_OUINSTANCE	_decimal_10_0	decimal(10)	No	To specify the OU instance at which the Supplier was created.	Yes
SPRTM_PRT_OUINSTANCE	_decimal_10_0	decimal(10)	No	This field is to specify the OU Instance of Part mapped to the supplier	No
SPRTM_PRT_SEQNO	_decimal_10_0	decimal(10)	No	This field holds the Sequence Number of the parts mapped to the supplier	No
SPRTM_PRT_PURC_UOM	_varchar_10	varchar(10)	No	This field holds the purchase UOM of the part mapped to the supplier	No
SPRTM_PRT_COST	_decimal_28_8	decimal(28)	Yes	This field is to capture the Cost of part mapped to the supplier	No
SPRTM_PRT_COSTPER	_decimal_28_8	decimal(28)	Yes	This field is to capture the cost per of the part mapped to the supplier	No
SPRTM_PRT_INSPEC_TYPE	_varchar_25	Varchar(25)	No	This field holds the Inspection type of the part mapped to the supplier Values stored will be Blank None Self By Inspector	No
SPRTM_PRT_MATCH_TYPE	_varchar_25	Varchar(25)	Yes	This field holds the matching type of the part mapped to the supplier Values stored will be Blank Four Way at GR Four Way at PO Three Way at GR Three Way at PO Two Way	No
SPRTM_PRT_TOLREN_TYPE	_varchar_25	Varchar(25)	No	This field holds the tolerance type of the part mapped to the supplier Values stored will be None Quantity Value Both	No
SPRTM_TOLREN_PERC	_decimal_28_8	decimal(28)	Yes	This field holds the tolerance percentage of the part mapped to the supplier	No
SPRTM_PRT_SUPP_REF	_varchar_40	varchar(40)	Yes	This field holds the reference of the part mapped to the supplier	No
SPRTM_PRT_SUPP_DESC	_varchar_150	varchar(150)	Yes	This field holds the reference of the part description mapped to the supplier	No
SPRTM_DIS_PUR_LEAD_TIME	_decimal_28_8	decimal(28)	Yes	This field holds the Purchase lead time - for display only	No
SPRTM_PUR_LEAD_TIME	_decimal_28_8	decimal(28)	Yes	This field holds the Purchase lead time	No
SPRTM_PRT_LEAD_UOM	_varchar_10	varchar(10)	Yes	This field holds the Purchase lead UOM	No
SPRTM_CREATED_BY	_varchar_30	varchar(30)	No	This field holds the user who created the record	No
SPRTM_CREATED_DATE	_datetime_8	datetime(8)	Yes	Thsi field holds the created date of the record	No
SPRTM_MODIFIED_DATE	_datetime_8	datetime(8)	Yes	This field holds the modified date of the record	No
SPRTM_MODIFIED_BY	_varchar_30	varchar(30)	No	This field holds the user who modified the record	No
SPRTM_UNDER_PBH	_varchar_25	Varchar(25)	Yes	This field holds the flag for Supplier-part PBH Y - Yes N - No	No
SPRTM_MIN_ORD_Qty	udd_quantity	numeric(13)	Yes	This field is to capture the Minimum order qty of part in the supplier.	No
SPRTM_MIN_ORD_VALUE	udd_value	numeric(13)	Yes	This field is to capture the Minimum order value of the part in the supplier.	No
SPRTM_EXCHG_CONTRACT	udd_designparamcode	varchar(5)	Yes	This field is to capture the Exchange contract information for a part for a supplier.	No
SPRTM_PBOREP_MODE	udd_designparamcode	varchar(5)	Yes	This field is to capture the the mode of replenishment desired for a PBH part for a supplier. This combo is loaded with 1.blank 2.PBH PO 3.PBH Exchange PO	No
SPRTM_PBOREP_ACTION	udd_designparamcode	varchar(5)	Yes	This field is to capture the replenishment action desired for a PBH part for a supplier. This combo is loaded with 1.Manual	No
SPRTM_COST_BASIS	udd_description	varchar(40)	Yes	This field is to capture the cost basis for a supplier part. This combo is loaded with 1.Blank 2.User defined Quick Code.	No
SPRTM_EFFECT_FRMDATE	udd_time	datetime(8)	Yes	This field is to capture the Effective from date of a part for a supplier.	No
SPRTM_EFFECT_TODATE	udd_time	datetime(8)	Yes	This field is to capture the Effective to date of a part for a supplier.	No
SPRTM_REMARKS	udd_remarks	varchar(255)	Yes	This field is to capture the remarks of a part information for a supplier.	No
SPRTM_QTYPRCBRK	udd_designparamcode	varchar(5)	Yes	this field holds the flag quantity price break is done for a part or not	No

Table Name :	SP_SQTPB_QTYPRCBRK_DET
Comment :	To maintain price break up information for parts

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
SQTPB_SEQNO	_int_0	int(0)	No	the quantity price break up sequence no	No
SQTPB_SUPOU	udd_ctxt_ouinstance	int(4)	Yes	supplier OU instance	No
SQTPB_SUPNO	udd_vendorcode	varchar(45)	Yes	Supplier ID	No
SQTPB_PARTOU	udd_ctxt_ouinstance	int(4)	Yes	part OU	No
SQTPB_PARTNO	udd_partno	varchar(40)	Yes	Part NO	No
SQTPB_FROMQTY	udd_quantity	numeric(13)	Yes	The from quantity of the part for which quanity price break up is done	No
SQTPB_TOQTY	udd_quantity	numeric(13)	Yes	The To quantity of the part for which quanity price break up is done	No
SQTPB_COST	udd_amount	numeric(13)	Yes	The cost for the part supplied by the supplier	No
SQTPB_COSTPER	udd_seqno	int(4)	Yes	The number of parts for which the cost is stated	No

Table Name :	SP_STCDM_TCD_MAP
Comment :	This contains information about TC&Ds attached to Suppliers

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
STCDM_SUPPLIER_ID	_varchar_45	varchar(45)	No	Supplier ID	Yes
STCDM_CREATED_OUINSTANCE	_decimal_10_0	decimal(10)	No	OU Instance	Yes
STCDM_LINE_NO	_decimal_10_0	decimal(10)	No	Line No	Yes
STCDM_TCD_CODE	_varchar_25	Varchar(25)	No	TCD code	No
STCDM_TCD_OUINSTANCE	_decimal_10_0	decimal(10)	No	TCD code OU instance	No
STCDM_TCD_DESC	_varchar_80	varchar(80)	No	TCD code description	No
STCDM_TCD_VAR	_varchar_25	Varchar(25)	No	TCD variant	No
STCDM_CREATED_BY	_varchar_30	varchar(30)	No	the person who created supplier TCD record	No
STCDM_MODIFIED_BY	_varchar_30	varchar(30)	No	the person who modified supplier TCD record	No
STCDM_TIMESTAMP	_decimal_10_0	decimal(10)	No	timestamp for supplier TCD record	No
STCDM_CREATED_DATE	_datetime_8	datetime(8)	Yes	the date on which supplier TCD is created	No
STCDM_MODIFIED_DATE	_datetime_8	datetime(8)	Yes	the date on which supplier TCD is modified	No
STCDM_CHRG_TYPE	udd_designparamcode	varchar(5)	No	Charge type	No

Table Name :	SP_STDD_Tax_Default_Dtl
Comment :	Default Tax # / Tax Variant # will be used for Invoicing. This has been maintained as a seperate table for future enhancements.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
STDD_OUInstance	_decimal_10_0	decimal(10)	No	OU Instance	No
STDD_Supplier_ID	_varchar_45	varchar(45)	No	Supplier ID	No
STDD_Tax_Code	_varchar_25	Varchar(25)	No	TCD code	No
STDD_TaxVariant_No	_varchar_30	varchar(30)	Yes	TCD variant	No
STDD_Created_Date	_datetime_8	datetime(8)	Yes	the date on which supplier TCD is created	No
STDD_Created_By	udd_ctxt_user	varchar(30)	Yes	the person who created supplier TCD record	No
STDD_Modified_Date	_datetime_8	datetime(8)	Yes	the date on which supplier TCD is modified	No
STDD_Modified_By	udd_ctxt_user	varchar(30)	Yes	the person who modified supplier TCD record	No
REPLICATION_KEY	_bigint_8	Bigint(8)	No	Unique Number	Yes

Table Name :	SP_STRD_Tax_Registration_Dtl
Comment :	To store the address id, Tax Type and Registration # details for Invoicing reports

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
STRD_OUInstance	_decimal_10_0	decimal(10)	No	OU Instance	No
STRD_Line_No	_decimal_10_0	decimal(10)	No	Line No	No
STRD_Supplier_ID	_varchar_45	varchar(45)	No	Supplier ID	No
STRD_Address_ID	_decimal_10_0	decimal(10)	Yes	Address ID	No
STRD_Tax_Type	_varchar_25	Varchar(25)	No	Tax Type	No
STRD_Reg_No	_varchar_25	Varchar(25)	No	Registration No	No
REPLICATION_KEY	_bigint_8	Bigint(8)	No	Unique Number	Yes

Table Name :	SP_SUPBNK_BANK_DTL
Comment :	Bank details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
SUPBKD_SUPPLIER_ID	udd_vendorcode	varchar(45)	No	Supplier ID	Yes
SUPBKD_CREATED_OUINSTANCE	udd_ctxt_ouinstance	int(4)	No	OU Instance	Yes
SUPBKD_LINE_NO	udd_seqno	int(4)	No	Line No	Yes
SUPBKD_PAY_MODE	udd_paymode	varchar(25)	Yes	payment mode	No
SUPBKD_COMP_BANK_ID	udd_bankid	varchar(20)	Yes	Bank ID	No
SUPBKD_COMP_PTT_ID	udd_bankid	varchar(20)	Yes	payterm ID	No
SUPBKD_SUPP_BANK	udd_accountcode	varchar(32)	Yes	Bank code	No
SUPBKD_SUPP_BANK_NAME	udd_txt150	varchar(150)	Yes	Bank name	No
SUPBKD_SUPP_BANK_TYPE	udd_type	varchar(25)	Yes	Bank type	No
SUPBKD_BANK_CLEAR_NO	udd_accountcode	varchar(32)	Yes	A number allotted to a bank by the central bank of the country	No
SUPBKD_BANK_ACC	udd_accountcode	varchar(32)	Yes	Bank Account no of supplier	No
SUPBKD_SWIFT_ID	udd_banknumber	varchar(20)	Yes	A unique number, used for transacting with international banks	No
SUPBKD_PAY_TO_BANK_ACC	udd_accountcode	varchar(32)	Yes	PAY TO BANK ACC	No
SUPBKD_SUPP_PTT_ID	udd_bankid	varchar(20)	Yes	Supplier PTT ID	No
SUPBKD_SUPP_PTT_NAME	udd_txt150	varchar(150)	Yes	PTT name	No
SUPBKD_SUPP_PTT_TYPE	udd_type	varchar(25)	Yes	PTT Type	No
SUPBKD_PTT_CLEAR_NO	udd_banknumber	varchar(20)	Yes	PTT clear no	No
SUPBKD_SUPP_PTT_ACC	udd_banknumber	varchar(20)	Yes	PTT account no	No
SUPBKD_LSV_CONTRACT_ID	udd_participationid	varchar(30)	Yes	LSV contract id	No
SUPBKD_CONTRACT_REF	udd_documentnumber	varchar(18)	Yes	contract reference	No
SUPBKD_LSV_FROM_DATE	_datetime_8	datetime(8)	Yes	LSV contract effective from date	No
SUPBKD_LSV_TO_DATE	_datetime_8	datetime(8)	Yes	LSV contract effective to date	No
SUPBKD_CONTESTATION_ALLOWED	udd_designparamcode	varchar(5)	Yes	flag for contestation allowable	No
SUPBKD_ESR_TYPE	udd_type	varchar(25)	Yes	ESR Type	No
SUPBKD_ESR_PARTICIPATION_NO	udd_identificaitonnumber	varchar(10)	Yes	ESR Participation No	No
SUPBKD_SUPP_PARTICIPATION_NO	udd_identificaitonnumber	varchar(10)	Yes	ESR Supplier Participation No	No
SUPBKD_CONTACT_PERSON	udd_contactperson	varchar(80)	Yes	Contact person	No
SUPBKD_ADDRESS1	udd_address	varchar(40)	Yes	The complete address 1 of the bank	No
SUPBKD_ADDRESS2	udd_address	varchar(40)	Yes	The complete address 2 of the bank	No
SUPBKD_ADDRESS3	udd_address	varchar(40)	Yes	The complete address 3 of the bank	No
SUPBKD_CITY	udd_city	varchar(32)	Yes	CITY	No
SUPBKD_STATE	udd_state	varchar(32)	Yes	STATE	No
SUPBKD_COUNTRY	udd_country	varchar(40)	Yes	COUNTRY	No
SUPBKD_ZIP	udd_zip	varchar(15)	Yes	Zipcode	No
SUPBKD_FAX	udd_communicationid	varchar(70)	Yes	Fax no	No
SUPBKD_PHONE	udd_phone	varchar(18)	Yes	Phone No	No
SUPBKD_EMAIL	udd_email	varchar(60)	Yes	Email id	No

Table Name :	SP_SUPCT_CERTIFICATE
Comment :	This contains the certification issued for a supplier

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
SUPCT_SUPPLIER_ID	_varchar_45	varchar(45)	No	To define supplier code unique at Company level or Organization unit level	Yes
SUPCT_CERTI_NO	_varchar_40	varchar(40)	No	This field holds the Certificate Number	Yes
SUPCT_CREATED_OUINSTANCE	_decimal_10_0	decimal(10)	No	To specify the OU instance at which the Supplier was created.	Yes
SUPCT_CERTI_OUINSTANCE	_decimal_10_0	decimal(10)	No	This field is to specify the OU Instance of Certificate	No
SUPCT_CERTI_AUCODE	_varchar_25	Varchar(25)	No	This field is to specify the Certificate authentication code	No
SUPCT_CERTI_TYPE	_varchar_25	Varchar(25)	No	This field holds the Type of Certificate	No
SUPCT_CREATED_BY	_varchar_30	varchar(30)	No	This field holds the user who created the record	No
SUPCT_MODIFIED_BY	_varchar_30	varchar(30)	Yes	This field holds the user who modified the record	No
SUPCT_TIMESTAMP	_decimal_10_0	decimal(10)	No	This field holds the timestamp so that more than one user cant modified same record in the same time	No
SUPCT_CERTI_TO_DATE	_datetime_8	datetime(8)	Yes	This field holds the Certificate Valid To Date	No
SUPCT_CERTI_FROM_DATE	_datetime_8	datetime(8)	Yes	This field holds the Certificate Valid From Date	No
SUPCT_CREATED_DATE	_datetime_8	datetime(8)	Yes	This field holds the created date of the record	No
SUPCT_MODIFIED_DATE	_datetime_8	datetime(8)	Yes	This field holds the modified date of the record	No
SUPCT_CERT_ISSUE_DATE	_datetime_8	datetime(8)	Yes	holds the certificate issue date for the supplier	No
SUPCT_SEQUENCE_NO	udd_number	int(4)	Yes	sequence no	No

Table Name :	SP_SUPDT_CTRL_REF
Comment :	This is the Supplier Detail table for the Supplier master containing information about the Supplier addresses etc.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
SUPDT_SUPPLIER_ID	_varchar_45	varchar(45)	No	To define supplier code unique at Company level or Organization unit level	Yes
SUPDT_CREATED_OUINSTANCE	_decimal_10_0	decimal(10)	No	To specify the OU instance at which the Supplier was created.	Yes
SUPDT_ADDRESSID	_decimal_10_0	decimal(10)	No	This field holds the address id of the each address	Yes
SUPDT_PHONE_NO	_varchar_70	varchar(70)	Yes	Thsi field holds the Phone no of the supplier	No
SUPDT_FAX	_varchar_70	varchar(70)	Yes	This field holds the fax of the supplier	No
SUPDT_EMAILID	_varchar_70	varchar(70)	Yes	This field holds the email id of the supplier	No
SUPDT_ADDRESS1	_varchar_255	varchar(255)	No	This field holds the address 1 of the supplier	No
SUPDT_ADDRESS1_UP	_varchar_255	varchar(255)	No	This field holds the address 1 of the supplier in upper case	No
SUPDT_ADDRESS2	_varchar_255	varchar(255)	Yes	This field holds the address 2 of the supplier	No
SUPDT_ADDRESS3	_varchar_255	varchar(255)	Yes	This field holds the address 3 of the supplier	No
SUPDT_CITY	_varchar_32	varchar(32)	No	This field holds the city of the supplier	No
SUPDT_CITY_UP	_varchar_32	varchar(32)	No	This field holds the city of the supplier in upper case	No
SUPDT_STATE	_varchar_32	varchar(32)	No	This field holds the state of the supplier	No
SUPDT_STATE_UP	_varchar_32	varchar(32)	No	This field holds the state of the supplier in upper case	No
SUPDT_COUNTRY	_varchar_40	varchar(40)	No	This field holds the country of the supplier	No
SUPDT_COUNTRY_UP	_varchar_40	varchar(40)	No	This field holds the country of the supplier in upper case	No
SUPDT_SPEC2KCODE	_varchar_5	varchar(5)	Yes	This field holds the spec2kcode of the supplier	No
SUPDT_SITA_ARINCCODE	_varchar_45	varchar(45)	Yes	This field holds the SITA/ARINC code of the supplier	No
SUPDT_ZIPCODE	_varchar_15	varchar(15)	No	This field holds the zip code of the supplier	No
SUPDT_ZIPCODE_UP	_varchar_15	varchar(15)	No	This field holds the zip code of the supplier in upper case	No
SUPDT_CREATED_BY	_varchar_30	varchar(30)	No	This field holds the User who has created the record.	No
SUPDT_MODIFIED_BY	_varchar_30	varchar(30)	Yes	This field holds the User who has modified the record.	No
SUPDT_CREATED_DATE	_datetime_8	datetime(8)	Yes	This field holds the created date of the record	No
SUPDT_MODIFIED_DATE	_datetime_8	datetime(8)	Yes	This field is to store the modified date of the supplier	No

Table Name :	SP_SUPMS_CTRL_REF_MSTR
Comment :	This is the Supplier Main table. It is control reference. It holds all the information about the Supplier

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
SUPMS_SUPPLIER_ID	udd_vendorcode	varchar(45)	No	To define supplier code unique at Company level or Organization unit level	Yes
SUPMS_CREATED_OUINSTANCE	udd_ctxt_ouinstance	int(4)	No	To specify the OU instance at which the Supplier was created.	Yes
SUPMS_SUPP_NAME	udd_txt150	varchar(150)	No	This column is used for storing the Description of a supplier	No
SUPMS_SUPP_TYPE	udd_flag1	varchar(25)	No	The type of the Supplier. Either Purchase Vendor or Misc Vendor. N - Normal M - Miscellaneous B -	No
SUPMS_CATEGORY	udd_quickcodes	varchar(25)	Yes	This field holds quick codes of the type category SC - Supplier Category	No
SUPMS_PAYMODE	udd_flag1	varchar(25)	No	Agreed Pay mode between the supplier and purchaser will be defined for the Supplier at the company level. The mode of payment.Values - C - "Cash", CQ - "Check", O - "Others", DD - "Demand Draft" and P - Pay Order E - EFT C -- Cre	No
SUPMS_PAY_PRIORITY	udd_flag1	varchar(25)	No	This field holds the pay priority values 1. H - "High", 2. N - "Normal" and 3. L - "Low"	No
SUPMS_PAYTERM_CODE	udd_quickcodes	varchar(25)	No	Agreed pay terms between the Supplier and Purchaser will be defined for the Supplier at the company level. The code that identifies the payment term - Quick codes	No
SUPMS_PAYTERM_OU	udd_ctxt_ouinstance	int(4)	No	This field holds the OU of the payterm Component	No
SUPMS_CURRENCY	udd_currency	varchar(20)	No	This field holds the Currency of the supplier	No
SUPMS_SPEC2KCODE	udd_spec2kmfgcode	varchar(5)	Yes	This field hodls the SPEC 2000 code	No
SUPMS_SITAARIN	udd_vendorcode	varchar(45)	Yes	This field holds the SITA/ARINC code	No
SUPMS_MANUFACT	udd_supplierrole	varchar(25)	Yes	This field is set when the supplier id is of Manfacturer type	No
SUPMS_REPAIR_AGCY	udd_supplierrole	varchar(25)	Yes	This field is set when the supplier id is of Repair agency type	No
SUPMS_DISTRIBUTOR	udd_supplierrole	varchar(25)	Yes	This field is set when the supplier id is of distributor type	No
SUPMS_CREAT_BY	udd_ctxt_user	varchar(30)	No	This field holds user who has created the record.	No
SUPMS_MOD_BY	udd_ctxt_user	varchar(30)	Yes	This field holds the user who has modified the record.	No
SUPMS_TIMESTAMP	udd_timestamp	int(4)	No	This field holds the timestamp of a record.	No
SUPMS_CREAT_DATE	_datetime_8	datetime(8)	Yes	This field holds user created date the record	No
SUPMS_MOD_DATE	_datetime_8	datetime(8)	Yes	This field holds the user modified date of the record	No
SUPMS_SUPP_NAME_UP	udd_txt150	varchar(150)	Yes	This column is used for storing the description of a supplier in upper case	No
SUPMS_CURRENCY_UP	udd_currency	varchar(20)	Yes	This field holds the Currency of the supplier in upper case	No
SUPMS_SPEC2KCODE_UP	udd_spec2kmfgcode	varchar(5)	Yes	This field hodls the SPEC 2000 code in upper case	No
SUPMS_SITAARIN_UP	udd_vendorcode	varchar(45)	Yes	This field holds the SITA/ARICC code in upper case	No
SUPMS_IN_SHIP_BY	udd_quickcodes	varchar(25)	Yes	This field holds the Inbound shipping method	No
SUPMS_IN_SHIP_COST	udd_flag1	varchar(25)	Yes	this field holds the inbound shipping cost	No
SUPMS_IN_PKG_CODE	udd_quickcodes	varchar(25)	Yes	This field holds the inbound packaging code	No
SUPMS_IN_INS_LTY	udd_flag1	varchar(25)	Yes	This field holds inbound insurance liability with the following values 1. N - None, 2. S - Self, 3. SP - Supplier s.	No
SUPMS_OUT_SHIP_BY	udd_quickcodes	varchar(25)	Yes	This field holds the Outbound shipping method	No
SUPMS_OUT_SHIP_COST	udd_flag1	varchar(25)	Yes	This field holds the outbound shipping cost	No
SUPMS_OUT_PKG_CODE	udd_quickcodes	varchar(25)	Yes	this field holds the outbound packaging code	No
SUPMS_OUT_INS_LTY	udd_flag1	varchar(25)	Yes	This field holds outbound insurance liability with the following values 1. N - None, 2. S - Self, 3. SP - Supplier s.	No
SUPMS_OPERATOR	udd_supplierrole	varchar(25)	Yes	This field holds the value whether the supplier is an operator or not Y - yes N - no	No
SUPMS_OTHERS	udd_supplierrole	varchar(25)	Yes	This field holds the value whether the supplier is of type others or not Y - yes N - no	No
SUPMS_PID_ATA_CAGE	udd_spec2kmfgcode	varchar(5)	Yes	This field holds the primary identification details of the supplier like ata/cage #	No
SUPMS_PID_DUNS	udd_dunscode	varchar(25)	Yes	This field holds the primary identification details of the supplier like duns #	No
SUPMS_PID_FSCM	udd_spec2kmfgcode	varchar(5)	Yes	This field holds the primary identification details of the supplier like fscm #	No
SUPMS_PID_NSCM	udd_spec2kmfgcode	varchar(5)	Yes	This field holds the primary identification details of the supplier like nscm #	No
SUPMS_PID_COL_ID_AGCY	udd_desc40	varchar(40)	Yes	This field holds the primary identification details of the supplier like agency #	No
SUPMS_PID_IDNO	udd_desc40	varchar(40)	Yes	This field holds the primary identification details of the supplier like IDNO #	No
SUPMS_CUSTOMER	udd_vendorcode	varchar(45)	Yes	This is field holds the customer code for a supplier	No
SUPMS_SERV_PROV	udd_designparamcode	varchar(5)	Yes	This field holds the flag whether the supplier is service provider or not	No
SUPMS_SRVC_PROVIDER	udd_supplierrole	varchar(25)	Yes	This field holds the value whether the supplier is an service provider or not Y - yes N - no	No
SUPMS_SUPPLIER_ACC_GRP	udd_suppliergroup	varchar(20)	Yes	This field stores the account group mapped to a supplier	No
SUPMS_CUSTOMERNO	udd_customer_id	varchar(18)	Yes	This field stores the customer no	No
SUPMS_PBH	udd_flag2	varchar(25)	Yes	This field holds the value whether the supplier is PBH or not Y - yes N - no	No
SUPMS_Remarks	udd_txt255	varchar(255)	Yes	This field holds the additional information of the supplier	No
SUPMS_FILE_NAME	udd_filename	varchar(50)	Yes	file name	No
SUPMS_RecPO	udd_chkflag	varchar(1)	Yes	The EDI capability of supplier for Receive PO	No
SUPMS_RecMltPO	udd_chkflag	varchar(1)	Yes	The EDI capability of supplier for Receive Multi linePO	No
SUPMS_SendPOAck	udd_chkflag	varchar(1)	Yes	The EDI capability of supplier for Send PO Acknowledgement	No
SUPMS_RecPOChng	udd_chkflag	varchar(1)	Yes	The EDI capability of supplier for Receive PO change	No
SUPMS_SendPOChng	udd_chkflag	varchar(1)	Yes	The EDI capability of supplier to Send PO change	No
SUPMS_SendShpNot	udd_chkflag	varchar(1)	Yes	The EDI capability of supplier to Send ship note	No
SUPMS_SendInv	udd_chkflag	varchar(1)	Yes	The EDI capability of supplier to Send Invioce	No
SUPMS_RecInvExp	udd_chkflag	varchar(1)	Yes	The EDI capability of supplier for Receive Incoice Exception	No
SUPMS_ReceiveRQF	udd_chkflag	varchar(1)	Yes	Supplier Receive RQF	No
SUPMS_SendQuotation	udd_chkflag	varchar(1)	Yes	Supplier send Qutation	No
created_area_code	_varchar_40	varchar(40)	Yes	created area code	No
SUPMS_NATOFSUP	udd_designparamcode	varchar(5)	Yes	nature of supplier	No
SUPMS_COMPANYCODE	udd_flag	varchar(25)	Yes	company code	No
SUPMS_PARTNERID	udd_txt255	varchar(255)	Yes	trading partner id	No

Table Name :	SP_Supplier_Logo_info
Comment :	Table to store supplier Logo information

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?

Table Name :	SP_SUPQC_QUICK_CODE
Comment :	This table holds the quick code of the supplier

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
SUPQC_OUINSTANCE	_varchar_30	varchar(30)	No	OU Instance	Yes
SUPQC_QUICK_CODE	_varchar_25	Varchar(25)	No	Supplier quick code	Yes
SUPQC_TYPE	_varchar_25	Varchar(25)	No	Supplier quick code type	Yes
SUPQC_DESC	_varchar_80	varchar(80)	No	Supplier quick code description	No
SUPQC_DOCSTATUS	_varchar_15	varchar(15)	No	Supplier quick code status, A-Active.IA-Inactive	No
SUPQC_CREATEDDATE	_datetime_8	datetime(8)	Yes	the date on which supplier quick code created	No
SUPQC_CREATED_BY	_varchar_30	varchar(30)	Yes	the person who created the supplier quick code	No
SUPQC_MODIFIEDDATE	_datetime_8	datetime(8)	Yes	the date on which the supplier quick code is modified	No
SUPQC_MODIFIED_BY	_varchar_30	varchar(30)	Yes	the person who modified the supplier quick code	No
SUPQC_TIMESTAMP	_decimal_10_0	decimal(10)	Yes	timestamp for suppliet quick code	No

Table Name :	SP_TATDT_RECEIPT_INFO
Comment :	SP_TATDT_RECEIPT_INFO

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
TATDT_UNIQUEID	udd_seqno	int(4)	No	UNIQUE KEY	Yes
TATDT_SUPPLIER_OU	udd_ctxt_ouinstance	int(4)	Yes	TAT SUPPLIER_OU	No
TATDT_SUPPLIER_NO	udd_vendorcode	varchar(45)	Yes	TAT Detail SUPPLIER_NO	No
TATDT_TATTYPE	udd_flag	varchar(25)	Yes	TAT Detail TYPE	No
TATDT_REF_DOC_OU	udd_ctxt_ouinstance	int(4)	Yes	TAT Detail REF DOC OU	No
TATDT_REF_DOC_NO	udd_documentno	varchar(40)	Yes	TAT Detail REF DOC NO	No
TATDT_REF_DOC_PART_OU	udd_ctxt_ouinstance	int(4)	Yes	TAT Detail REFDOC Part OU	No
TATDT_REF_DOC_PARTNO	udd_partno	varchar(40)	Yes	TAT Detail REFDOC Part #	No
TATDT_REF_DOC_LINE_NO	udd_lineno	int(4)	Yes	TAT Detail REF_DOC LINE Number	No
TATDT_REF_DOC_TYPE	udd_flag	varchar(25)	Yes	TAT Detail REFDOC TYPE	No
TATDT_REF_DOC_SUBTYPE	udd_flag	varchar(25)	Yes	TAT Detail REFDOC SUBTYPE	No
TATDT_REF_DOC_PRIORITY	udd_flag	varchar(25)	Yes	TAT Detail REFDOCPRIORITY	No
TATDT_REF_DATE	udd_time	datetime(8)	Yes	TAT Detail Reference DATE	No
TATDT_RECEIPT_OU	udd_ctxt_ouinstance	int(4)	Yes	TAT Detail RECEIPT OU	No
TATDT_RECEIPT_NO	udd_documentno	varchar(40)	Yes	TAT Detail RECEIPT Number	No
TATDT_RECEIPT_PART_OU	udd_ctxt_ouinstance	int(4)	Yes	TAT Detail RECEIPT PART OU	No
TATDT_RECEIPT_PART_NO	udd_partno	varchar(40)	Yes	TAT Detail RECEIPT PART NO	No
TATDT_RECEIPT_LINE_NO	udd_lineno	int(4)	Yes	TAT Detail RECEIPT LINE Number	No
TATDT_RECEIPT_DATE	udd_time	datetime(8)	Yes	TAT Detail RECEIPT Date	No
TATDT_TAT_DAYS	udd_quantity	numeric(13)	Yes	TAT Detail TAT DAYS	No
TATDT_CREATEDBY	udd_ctxt_user	varchar(30)	Yes	TAT Detail CREATEDBY	No
TATDT_CREATED_DATE	udd_time	datetime(8)	Yes	TAT Detail CREATED DATE	No
TATDT_PRIORITY_FLAG	_Bit_1	Bit(1)	Yes	TAT Detail PRIORITY FLAG	No
TATDT_RECEIPT_WAREHOUSENO	udd_warehouse	varchar(10)	Yes	TAT Detail RECEIPT Warehouse	No