Blanket Purchase Order

Table Name BPO_BAAllD_Allotment_Dtl

Table Comment Used to store the Amended Bpo Document’s Allotment Details

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

BAAllD_BPO_Balance_Value

decimal(28,8)

NULL

This field holds the BPO balance value

No

No

BAAllD_BPO_Balance_Qty

decimal(28,8)

NULL

This field holds the BPO balance quantity

No

No

BAAllD_Allotment_Qty

decimal(28,8)

NOT NULL

This field holds the Maximum BPO quantity that can be allocated to RS and OU with which it is interacting

No

No

BAAllD_ModifiedDate

datetime

NOT NULL

This field holds the modified date of the record

No

No

BAAllD_CreatedDate

datetime

NOT NULL

This field holds the created date of the record

No

No

BAAllD_Created_By

varchar(30)

NOT NULL

This field holds the user who created the record

No

No

BAAllD_Modified_By

varchar(30)

NOT NULL

This field holds the user who modified the record

No

No

BAAllD_BPO_No

varchar(40)

NOT NULL

This field holds the BPO document no generated based on Numbering type

Yes

Yes

BAAllD_BPO_OUInstance

numeric(10)

NOT NULL

This field holds the OU instance in which BPO is created

Yes

Yes

BAAllD_RS_Ord_OUInstance

numeric(10)

NOT NULL

This field holds the release slip OUInstance which is interacting with BPO OU

No

No

BAAllD_RS_Allot_Id

numeric(10)

NOT NULL

This field holds the allotment id to identify uniquely the RS allotment

Yes

No

BAAllD_BPO_Amend_No

numeric(10)

NOT NULL

This field holds the amendment No history of the blanket purchase order

Yes

Yes

BAAllD_BPO_Line_Id

numeric(10)

NOT NULL

This field holds the id used to uniquely identify the BPO part number

Yes

Yes

Table Name BPO_BAAuAD_Auth_Audit_dtl

Table Comment Used to Store the Authorization Audit Trail Information for the Amended history of the BPO Document

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

BAAuAD_BPO_Auth_Remarks

varchar(255)

NULL

This field holds the authorization remarks of blanket purchase order document

No

No

BAAuAD_BPO_Date_and_Time

datetime

NULL

This field holds the date and time of blanket purchase order document

No

No

BAAuAD_BPO_Status_To

varchar(15)

NULL

The field holds the level status after authorization

No

No

BAAuAD_ModifiedDate

datetime

NOT NULL

This field holds the modified date of the record

No

No

BAAuAD_CreatedDate

datetime

NOT NULL

This field holds the created date of the record

No

No

BAAuAD_Created_By

varchar(30)

NOT NULL

This field holds the user who created the record

No

No

BAAuAD_Modified_By

varchar(30)

NOT NULL

This field holds the user who modified the record

No

No

BAAuAD_BPO_No

varchar(40)

NOT NULL

The field holds the document no of blanket purchase order component

Yes

Yes

BAAuAD_BPO_Amend_No

numeric(10)

NOT NULL

This field holds the amendment No history of the blanket purchase order

Yes

Yes

BAAuAD_BPO_OUInstance

numeric(10)

NOT NULL

This field holds the ou instance in which BPO is created

Yes

Yes

BAAuAD_BPO_Status_From

varchar(15)

NULL

The field holds the level status before authorization

No

No

BAAuAD_BPO_Auth_Level_PC

varchar(25)

NULL

This field holds the authorization level/Purchase committee of the document

No

No

BAAuAD_BPO_Audit_Trail_Id

numeric(10)

NOT NULL

This field holds the audit trail id of the record

Yes

No

BAAuAD_BPO_User_Name

varchar(30)

NULL

This field holds the user name of the blanket purchase order document

No

No

Table Name BPO_BAAUPC_AUTH_PC_DTL

Table Comment This table is Used to store information for the Amended Purchase Committee Details.

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

BAAUPC_BPO_OUINSTANCE

numeric(10)

NOT NULL

This field holds the member authorization status of Blanket purchase order document

Yes

Yes

BAAUPC_BPO_NO

varchar(40)

NOT NULL

This field holds the Blanket purchase order number

Yes

Yes

BAAUPC_BPO_AMEND_NO

numeric(10)

NOT NULL

This field holds the Blanket purchase order Amendment number

Yes

Yes

BAAUPC_PC_CODE

varchar(25)

NOT NULL

This field holds the purchase committee code of blanket purchase order document

Yes

No

BAAUPC_EMP_CODE

varchar(20)

NOT NULL

This field holds the employee code of the blanket purchase order document

Yes

No

BAAUPC_MEMBER_AUTH_STATUS

varchar(5)

NOT NULL

This field holds the Authorization status

No

No

BAAUPC_AUTH_BY

varchar(30)

NULL

This field holds the user who authorised the record

No

No

BAAUPC_AUTH_DATE

datetime

NULL

This field holds the authorization date of blanket purchase order document

No

No

Table Name BPO_BAAuPD_Auth_Prof_dtl

Table Comment This Table is Used to Store Authorization Profile Information for the Amended History of Bpo Document

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

BAAuPD_Pc_Quroum

numeric(10)

NULL

This field holds the purchase committee quorum of blanket purchase order

No

No

BAAuPD_Pc_Type

varchar(5)

NULL

This field holds the Purchase committee type of blanket purchase order

No

No

BAAuPD_No_Members

numeric(10)

NULL

This field holds the no of members in the authorization profile details of blanket purchase order

No

No

BAAuPD_Last_Authorized_By

varchar(30)

NULL

This field holds the last authorised by detail

No

No

BAAuPD_Members_Authorized

numeric(10)

NULL

The field holds the no. of members authorised for blanket purchase order document

No

No

BAAuPD_Lvl_Pc_Auth_Status

varchar(5)

NULL

This field holds the level/purchase committee authorization status

No

No

BAAuPD_Last_Auth_Date

datetime

NULL

This field holds the last authorization date

No

No

BAAuPD_BPO_No

varchar(40)

NOT NULL

This field holds the blanket purchase order number

Yes

Yes

BAAuPD_BPO_OUInstance

numeric(10)

NOT NULL

This field holds the ou instance in which blanket purchase order document is created

Yes

Yes

BAAuPD_Type

varchar(5)

NULL

This field holds the type of blanket purchase order

No

No

BAAuPD_Seq_No

numeric(10)

NOT NULL

This field holds the sequence number of blanket purchase order document

Yes

No

BAAuPD_BPO_Amend_No

numeric(10)

NOT NULL

This field holds the latest amendment no History of the blanket purchase order

Yes

Yes

BAAuPD_Lvl_Pc_Code

varchar(25)

NOT NULL

This field holds the level/purchase committee code

Yes

No

Table Name BPO_BAAuPI_Auth_Pc_Dtl

Table Comment This table is Used to store information for the Purchase Committee Details for the Amended BPO Document .

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

BAAuPI_Member_Auth_Status

sql_variant

NULL

This field holds the member authorization status of Blanket purchase order document

No

No

BAAuPI_Emp_Code

sql_variant

NOT NULL

This field holds the employee code of the blanket purchase order document

Yes

No

BAAuPI_Auth_By

sql_variant

NULL

This field holds the user who authorised the record

No

No

BAAuPI_Auth_Date

datetime

NULL

This field holds the authorization date of blanket purchase order document

No

No

BAAuPI_BPO_OUInstance

numeric(10)

NOT NULL

This field is to hold the ou instance of blanket purchase order document

Yes

Yes

BAAuPI_Pc_Code

sql_variant

NOT NULL

This field holds the purchase committee code of blanket purchase order document

Yes

No

BAAuPI_BPO_No

varchar(40)

NOT NULL

This field holds the blanket purchase order number

Yes

Yes

BAAuPC_BPO_Amend_No

numeric(10)

NOT NULL

This field holds the latest amendment no History of the blanket purchase order

Yes

Yes

Table Name BPO_BADTcd_BPO_Doc_TCD_dtl

Table Comment Used to Store the Document Level TCD Details for the Amended BPO Document

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

BADTcd_ModifiedDate

datetime

NOT NULL

This field holds the Last Modified Date of the record.

No

No

BADTcd_Modified_By

varchar(30)

NOT NULL

This field holds the Last Modified User of the record.

No

No

BADTcd_Created_By

varchar(30)

NOT NULL

This field holds the created user of the record

No

No

BADTcd_CreatedDate

datetime

NOT NULL

This field holds the created date of the record

No

No

BADTcd_TCD_Amount

decimal(28,8)

NULL

This field holds the Total Tcd amount for the Current Tcd.

No

No

BADTcd_Pay_To_Supp

varchar(45)

NULL

This fields holds the supplier code to whom the payment has to be made

No

No

BADTcd_User_Seq_No

decimal(38)

NULL

This fields holds user entered sequence number for the TCD code

No

No

BADTcd_exchg_rate

numeric(28,8)

NULL

This fields holds the exchange rate between the document currency and the payment currency

No

No

BADTcd_Currency

varchar(20)

NULL

This fields holds the currency chosen in the multiline for the TCD code

No

No

BADTcd_PayToSupp_OU

decimal(38)

NULL

This fields holds the pay to supplier’s OU

No

No

BADTcd_BPO_No

varchar(40)

NOT NULL

The field holds the blanket purchase order number

Yes

Yes

BADTcd_TCD_Line_Id

numeric(10)

NOT NULL

The field holds the  TCD Line Id information (Running No)

Yes

No

BADTcd_BPO_OUInstance

numeric(10)

NOT NULL

This field holds the ou instance in which blanket purchase order is created

Yes

Yes

BADTcd_BPO_Amend_No

numeric(10)

NOT NULL

This field holds the amendment No history of the blanket purchase order

Yes

Yes

BADTcd_TCD_OU

numeric(10)

NOT NULL

This field holds the ou instance in which TCD code is created.

No

No

BADTCD_TCD_TYPE

varchar(5)

NULL

This fields holds TCD type of following values T-  tax C - charge D - discount

No

No

BADTcd_TCD_Rate

decimal(28,8)

NULL

This field holds the TCD Code’s unit Rate.

No

No

BADTcd_TCD_Code

varchar(25)

NOT NULL

This field holds the ou instance in which the TCD Code was created.

No

No

BADTCD_TCD_BASIS

varchar(5)

NULL

This field stores the basis for TCD P - percentage F - flat UR - unit rate

No

No

BADTcd_TCD_Variant_Code

varchar(25)

NOT NULL

This field holds the TCD Variant Code for the current TCD Line No.

No

No

Table Name BPO_BAInsD_Inspect_dtl

Table Comment 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 BPO amendment History Document.

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

BAInsD_Std_Qual_Value

varchar(80)

NULL

This field holds the standard qualitative value

No

No

BAInsD_Trackable

varchar(5)

NULL

This field is set when the trackable option is allowed. Allowed values are 1.YES 2.NO

No

No

BAInsD_Maximum_Value

decimal(28,8)

NULL

This field holds the maximum value of blanket purchase order document

No

No

BAInsD_Minimum_Value

decimal(28,8)

NULL

This field holds the minimum value of blanket purchase order document

No

No

BAInsD_Std_Value

decimal(28,8)

NULL

This field holds the standard value of blanket purchase order document

No

No

BAInsD_Created_By

varchar(30)

NOT NULL

This field holds the user who created the record

No

No

BAInsD_ModifiedDate

datetime

NOT NULL

This field holds the modified date of the record

No

No

BAInsD_Inspect_Remarks

varchar(255)

NULL

This field holds the inspect remarks of blanket purchase order component

No

No

BAInsD_CreatedDate

datetime

NOT NULL

This field holds the created date of the record

No

No

BAINSD_BPO_UOM

varchar(20)

NULL

This field holds the stores Unit of measurement

No

No

BAInsD_Modified_By

varchar(30)

NOT NULL

This field holds the user who modified the record

No

No

BAInsD_BPO_Line_Id

numeric(10)

NOT NULL

This field holds the uniquely generated id of blanket purchase order document

Yes

Yes

BAInsD_BPO_Attribute_Id

varchar(40)

NOT NULL

This field holds the attribute id of blanket purchase order document

Yes

No

BAInsD_BPO_No

varchar(40)

NOT NULL

This field holds the document no of blanket purchase order

Yes

Yes

BAInsD_BPO_OUInstance

numeric(10)

NOT NULL

This field holds the ou instance in which BPO is created

Yes

Yes

BAInsD_Attribute_Type

varchar(5)

NULL

this field is to capture the attribute type of blanket purchase order document

No

No

BAInsD_Std_Min_Value

decimal(28,8)

NULL

This field holds the standard minimum value of blanket purchase order document

No

No

BAInsD_Std_Max_Value

decimal(28,8)

NULL

This field holds the standard maximum value of blanket purchase order document

No

No

BAInsD_BPO_Amend_No

numeric(10)

NOT NULL

This field holds the amendment No history of the blanket purchase order

Yes

Yes

BAInsD_Attribute_OU

numeric(10)

NULL

This field holds the ou instance of attribute component with which blanket purchase order is created.

No

No

BAInsD_Attribute_Code

varchar(10)

NOT NULL

this field is to capture the attribute code of blanket purchase order document

No

No

Table Name BPO_BAPTcd_BPO_Part_TCD_dtl

Table Comment Used to store the Part Level information for the Amended History of the Blanket Purchase Order Document with the Line No

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

BAPTcd_CreatedDate

datetime

NOT NULL

This field holds the created date of the record

No

No

BAPTcd_Created_By

varchar(30)

NOT NULL

This field holds the created user of the record

No

No

BAPTcd_TCD_OU

numeric(10)

NOT NULL

This field holds the Tcd Code Created OUInstance.

No

No

BAPTcd_TCD_Amount

decimal(28,8)

NULL

This field holds the total amount &nbspthe Tcd Code of the current Tcd Line Id.

No

No

BAPTcd_TCD_Rate

decimal(28,8)

NULL

This field holds the Rate for the Tcd Code of the current Tcd Line Id.

No

No

BAPTcd_Currency

varchar(20)

NULL

This field stores the currency chosen in the multiline

No

No

BAPTcd_ModifiedDate

datetime

NOT NULL

This field holds the Last Modified Date of the record.

No

No

BAPTcd_User_Seq_No

decimal(38)

NULL

This field stores the user entered sequence number for the TCD code

No

No

BAPTcd_Modified_By

varchar(30)

NOT NULL

This field holds the Last Modified User of the record.

No

No

BAPTcd_exchg_rate

numeric(28,8)

NULL

This field holds the exchange rate between the document currency and the payment currency

No

No

BAPTcd_BPO_Amend_No

numeric(10)

NOT NULL

This field holds the amendment No history of the blanket purchase order

Yes

Yes

BAPTcd_BPO_Line_Id

numeric(10)

NOT NULL

This field holds the blanket purchase order Part Line Id (Running No)

Yes

Yes

BAPTcd_BPO_No

varchar(40)

NOT NULL

This field holds the blanket purchase order No.

Yes

Yes

BAPTcd_BPO_OUInstance

numeric(10)

NOT NULL

This field holds the ou instance in which blanket purchase order is created

Yes

Yes

BAPTCD_TCD_TYPE

varchar(5)

NULL

This field stores the TCD type T- tax C - charge D - discount

No

No

BAPTCD_TCD_BASIS

varchar(5)

NULL

This field stores the basis for TCD P - percentage F - flat UR - unit rate

No

No

BAPTcd_TCD_Line_Id

numeric(10)

NOT NULL

This field holds the blanket purchase order Part Tcd Line Id (Running No).

Yes

No

BAPTcd_TCD_Variant_Code

varchar(25)

NOT NULL

This field holds the Tcd Variant for the current Tcd Line id.

No

No

BAPTcd_TCD_Code

varchar(25)

NOT NULL

This field holds the Tcd Code for the current Tcd Line id.

No

No

Table Name BPO_BDTcd_BPO_Doc_TCD_dtl

Table Comment Used to Store the Document Level TCD Details

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

BDTcd_ModifiedDate

datetime

NOT NULL

This field holds the Last Modified Date of the record.

No

No

BDTcd_Modified_By

varchar(30)

NOT NULL

This field holds the Last Modified User of the record.

No

No

BDTcd_Created_By

varchar(30)

NOT NULL

This field holds the created user of the record

No

No

BDTcd_CreatedDate

datetime

NOT NULL

This field holds the created date of the record

No

No

BDTcd_Pay_To_Supp

varchar(45)

NULL

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

No

No

BDTcd_User_Seq_No

decimal(38)

NULL

This field holds user entered sequence number for the TCD code

No

No

BDTcd_exchg_rate

numeric(28,8)

NULL

This field holds the exchange rate between the document currency and the payment currency

No

No

BDTcd_Currency

varchar(20)

NULL

This field holds the currency chosen in the multiline for the TCD code

No

No

BDTcd_PayToSupp_OU

decimal(38)

NULL

This field stores the pay to supplier’s OU

No

No

BDTcd_BPO_No

varchar(40)

NOT NULL

The field holds the blanket purchase order number

Yes

Yes

BDTcd_TCD_Line_Id

numeric(10)

NOT NULL

The field holds the the TCD Line Id information (Running No)

Yes

No

BDTcd_BPO_OUInstance

numeric(10)

NOT NULL

This field holds the ou instance in which blanket purchase order is created

Yes

Yes

BDTcd_TCD_Amount

decimal(28,8)

NULL

This field holds the Total Tcd amount for the Current Tcd.

No

No

BDTcd_TCD_Rate

decimal(28,8)

NOT NULL

This field holds the TCD Code’s unit Rate.

No

No

BDTcd_TCD_OU

numeric(10)

NULL

This field holds the ou instance in which TCD code is created.

No

No

BDTcd_TCD_Variant_Code

varchar(25)

NOT NULL

This field holds the TCD Variant Code for the current TCD Line No.

No

No

BDTcd_TCD_Code

varchar(25)

NOT NULL

This field holds the ou instance in which the TCD Code was created.

No

No

Table Name BPO_BPAROD_REF_OBJ_DTL

Table Comment This tables stores the specify document references that are applicable for the BPO.

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

BPAROD_CREATED_OUINSTANCE

decimal(38)

NOT NULL

This field holds the Organization unit of the create BPO document

Yes

No

BPAROD_BPO_NO

varchar(40)

NOT NULL

This field holds the generated BPO number

Yes

No

BPAROD_BPO_AMEND_NO

decimal(38)

NOT NULL

This field holds the BPO Amendment number

Yes

No

BPAROD_DOC_LINE_ID

decimal(38)

NOT NULL

This field holds the line number of the part information

Yes

No

BPAROD_REF_DOC_TYPE

varchar(25)

NULL

This field holds the reference document. The system lists all the reference document types that are defined in the Common Masters business component, that are in the Active status

No

No

BPAROD_REF_DOC_ID

varchar(40)

NULL

This field stores the number that identifies the reference document

No

No

BPAROD_REF_DOC_FILE_NAME

varchar(50)

NULL

This field holds the file name of the reference document

No

No

BPAROD_CREATED_DATE

datetime

NULL

This field holds the created date of Reference document to a BPO

No

No

BPAROD_CREATED_BY

varchar(30)

NOT NULL

This field holds the created user of Reference document to a BPO

No

No

BPAROD_MODIFIED_DATE

datetime

NULL

his field holds the modified date of Reference document to a BPO

No

No

BPAROD_MODIFIED_BY

varchar(30)

NOT NULL

his field holds the modified user of Reference document to a BPO

No

No

Table Name Bpo_BpAUI_User_Def_Info

Table Comment This table is used to capture the Amended Bpo Document’s User Defined Information History

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

BpAUI_User_Def_Opt4

varchar(30)

NULL

This field holds the fourth user defined option

No

No

BpAUI_User_Def_Remarks

varchar(255)

NULL

This field holds the user defined remarks

No

No

BpAUI_User_Def_Desc4

varchar(30)

NULL

This field holds the fourth description of user defined options.

No

No

BpAUI_User_Def_Opt3

varchar(30)

NULL

This field holds the third user defined option

No

No

BpAUI_Modified_Date

datetime

NOT NULL

This field holds the modified date of the record

No

No

BpAUI_Created_Date

datetime

NOT NULL

This field holds the created date of the record

No

No

BpAUI_Created_By

varchar(30)

NOT NULL

This field holds the user who created the record

No

No

BpAUI_Modified_By

varchar(30)

NOT NULL

This field holds the user who modified the record

No

No

BpAUI_BPO_No

varchar(40)

NOT NULL

This field holds the blanket purchase order number

Yes

Yes

BpAUI_BPO_Amend_No

numeric(10)

NOT NULL

This field holds the amendment No history of the blanket purchase order

Yes

Yes

BpAUI_BPO_OUInstance

numeric(10)

NOT NULL

This is the ou instance in which blanket purchase order document is created

Yes

Yes

BpAUI_User_Def_Desc3

varchar(30)

NULL

This field holds the third description of user defined options.

No

No

BpAUI_User_Def_Opt2

varchar(30)

NULL

This field holds the Second user defined option

No

No

BpAUI_User_Def_Desc1

varchar(30)

NULL

This field holds the first description of user defined options.

No

No

BpAUI_User_Def_Desc2

varchar(30)

NULL

This field holds the second description of user defined options.

No

No

BpAUI_User_Def_Opt1

varchar(30)

NULL

This field holds the first user defined option

No

No

Table Name BPO_BPOAAd_Auth_Audit_dtl

Table Comment Used to Store the Authorization Audit Trial Information for the BPO Document

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

BPOAAd_BPO_Auth_Remarks

varchar(255)

NULL

This field holds the authorization remarks of blanket purchase order document

No

No

BPOAAd_BPO_Date_and_Time

datetime

NULL

This field holds the date and time of blanket purchase order document

No

No

BPOAAd_BPO_Status_To

varchar(15)

NULL

The field holds the level status after authorization

No

No

BPOAAd_ModifiedDate

datetime

NOT NULL

This field holds the modified date of the record

No

No

BPOAAd_CreatedDate

datetime

NOT NULL

This field holds the created date of the record

No

No

BPOAAd_Created_By

varchar(30)

NOT NULL

This field holds the user who created the record

No

No

BPOAAd_Modified_By

varchar(30)

NOT NULL

This field holds the user who modified the record

No

No

BPOAAd_BPO_No

varchar(40)

NOT NULL

The field holds the document no of blanket purchase order component

Yes

Yes

BPOAAd_BPO_OUInstance

numeric(10)

NOT NULL

This field holds the ou instance in which BPO is created

Yes

Yes

BPOAAd_BPO_Status_From

varchar(15)

NULL

The field holds the level status before authorization

No

No

BPOAAd_BPO_Auth_Level_PC

varchar(25)

NULL

This field holds the authorization level/Purchase committee of the document

No

No

BPOAAd_BPO_Audit_Trail_Id

numeric(10)

NOT NULL

This field holds the audit trail id of the record

Yes

No

BPOAAd_BPO_User_Name

varchar(30)

NULL

This field holds the user name of the blanket purchase order document

No

No

Table Name BPO_BPOADt_Allotment_Dtl

Table Comment This table is to allot the BPO QTY to RS ous through which they are interacting. The allotment is based on Number (or) Percentage.

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

BPOADt_BPO_Balance_Value

decimal(28,8)

NULL

This field holds the BPO balance value

No

No

BPOADt_BPO_Balance_Qty

decimal(28,8)

NULL

This field holds the BPO balance quantity

No

No

BPOADT_RS_ALLOTMENT_VALUE

numeric(28,8)

NULL

This field holds the Maximum BPO value that can be allocated to RS OU with which it is interacting

No

No

BPOADt_ModifiedDate

datetime

NOT NULL

This field holds the modified date of the record

No

No

BPOADt_CreatedDate

datetime

NOT NULL

This field holds the created date of the record

No

No

BPOADt_Created_By

varchar(30)

NOT NULL

This field holds the user who created the record

No

No

BPOADt_Modified_By

varchar(30)

NOT NULL

This field holds the user who modified the record

No

No

BPOADt_BPO_No

varchar(40)

NOT NULL

This is the BPO document no generated based on Numbering type

Yes

Yes

BPOADt_BPO_OUInstance

numeric(10)

NOT NULL

This is the ou instance in which BPO is created

Yes

Yes

BPOADt_RS_Allotment_Qty

decimal(28,8)

NULL

This field holds the Maximum BPO quantity that can be allocated to RS OU with which it is interacting

No

No

BPOADt_RS_Ord_OUInstance

numeric(10)

NOT NULL

This is the release slip OU Instance which is interacting with BPO OU

No

No

BPOADt_BPO_Line_Id

numeric(10)

NOT NULL

This is the id used to uniquely identify the BPO part number

Yes

Yes

BPOADt_RS_Allot_Id

numeric(10)

NOT NULL

This is the allotment id to idnentify uniquely the RS allotment

Yes

No

Table Name BPO_BPOAHd_BlkPurOrd_hdr

Table Comment This Table is Used to store the Blanket Puchase Order With Amended History Information

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

BPOAHd_Auth_NxtLvlPc

varchar(25)

NULL

This field holds the next level in authorization profile of Blanket purchase order document

No

No

BPOAHd_Auth_MaxVal

decimal(28,8)

NULL

This field holds the maximum value for which BPO document is authorised

No

No

BPOAHd_Auth_MinVal

decimal(28,8)

NULL

This field holds the minimum value for which BPO document is authorised

No

No

BPOAHd_Auth_Type

varchar(5)

NULL

This field holds the authorization Allowed values are 1.Level 2.PC

No

No

BPOAHd_Auth_Stage

varchar(25)

NULL

This field captures the stage of authorization

No

No

BPOAHd_CreatedDate

datetime

NOT NULL

This field holds the created date of the record

No

No

BPOAHd_BPO_Scl_Reason

varchar(255)

NULL

This field holds the reason for the short close of blanket purchase order

No

No

BPOAHd_BPO_Base_Currency

varchar(20)

NULL

This field holds the base currency code of blanket purchase order document

No

No

BPOAHd_Auth_TerLevel

varchar(25)

NULL

This field holds the terminating level in authorization profile

No

No

BPOAHd_BPO_Status

varchar(15)

NULL

This field holds the status of the blanket purchase order document. Allowed values are 1.A- Active 2.I- Inactive

No

No

BPOAHd_BPO_Hld_Reason

varchar(255)

NULL

This field holds the reason for the held blanket purchase order

No

No

BPOAHd_BPO_Rel_Reason

varchar(255)

NULL

This field holds the reason for the releases blanket purchase order

No

No

BPOAHd_BPO_Auth_Reason

varchar(255)

NULL

This field holds the reason for the authorization of blanket purchase order

No

No

BPOAHd_TimeStamp

numeric(10)

NOT NULL

This field holds the timestamp value

No

No

BPOAHd_Confirmed_By

varchar(30)

NULL

This field holds the user who confirmed the record

No

No

BPOAHd_ConfirmedDate

datetime

NULL

This field holds the confirmed date of the record.

No

No

BPOAHd_BPO_Ret_Reason

varchar(255)

NULL

stores the reason for returning a document

No

No

BPOAHd_BPO_wfdoc_key

varchar(2000)

NULL

This field holds the doc key which is a combination of document number, OU Instance. This is passed as an input to work flow service

No

No

BPOAHd_Created_By

varchar(30)

NOT NULL

This field holds the user who created the record

No

No

BPOAHd_Modified_By

varchar(30)

NOT NULL

This field holds the user who modified the record

No

No

BPOAHd_ModifiedDate

datetime

NOT NULL

This field holds the modified date of the record

No

No

BPOAHd_Authorised_By

varchar(30)

NULL

This field holds the user who authorised this record

No

No

BPOAHd_AuthorisedDate

datetime

NULL

This field holds the authorization date of blanket purchase order

No

No

BPOAHd_AmendedDate

datetime

NULL

This field holds the amended date of the record

No

No

BPOAHd_Amended_By

varchar(30)

NULL

This field holds the user who amended the record

No

No

BPOAHd_BPO_numtype

varchar(5)

NULL

This field holds the numbering type number to be sent as an input to work flow

No

No

BPOAHd_BPO_Buyer_Group

varchar(25)

NULL

This field holds the Buyer group code of blanket purchase order

No

No

BPOAHd_BPO_Part_Type

varchar(5)

NOT NULL

This field holds the part type of the blanket purchase order

No

No

BPOAHd_BPO_Supplier_OU

numeric(10)

NOT NULL

This field holds the supplier ou instance of the blanket purchase order

No

No

BPOAHd_BPO_Agreement_No

varchar(40)

NOT NULL

This field holds the agreement no of blanket purchase order

No

No

BPOAHd_BPO_Buyer_Group_OU

numeric(10)

NULL

This field holds the ou instance of Buyer group component interacting with blanket purchase order

No

No

BPOAHd_BPO_Exch_Rate

decimal(28,8)

NULL

This field holds the exchange rate of blanket purchase order

No

No

BPOAHd_BPO_Amend_No

numeric(10)

NOT NULL

This field holds the amendment No history of the blanket purchase order

Yes

No

BPOAHd_BPO_OUInstance

numeric(10)

NOT NULL

This field holds ou instance in which BPO document is created

Yes

Yes

BPOAHd_BPO_Supplier_No

varchar(45)

NOT NULL

This field holds the supplier number of the blanket purchase order

No

No

BPOAHd_BPO_User_Status

varchar(25)

NULL

This field holds the user status of the blanket purchase order

No

No

BPOAHd_BPO_No

varchar(40)

NOT NULL

This field holds the Blanket purchase order number

Yes

Yes

BPOAHd_BPO_Date

datetime

NOT NULL

This field holds the Blanket purchase order date

No

No

BPOAHD_BPO_TOTAL_VALUE

numeric(28,8)

NULL

This field holds the BPO total value

No

No

BPOAHd_BPO_Doc_TCD_Amt

decimal(28,8)

NULL

This field holds the sum of all Tax/Charges/Discount amount at Blanket purchase order document level.

No

No

BPOAHd_BPO_Line_TCD_Amt

decimal(28,8)

NULL

This field holds the Tax/Charges/Discount amount at Blanket purchase order line level.

No

No

BPOAHd_BPO_Basic_Value

decimal(28,8)

NULL

This field holds the basic value of the blanket purchase order document

No

No

BPOAHd_Basic_Cur_Value

decimal(28,8)

NULL

This field holds the value of BPO in basic currency

No

No

BPOAHD_BPO_ADDLN_CHARGES

numeric(28,8)

NULL

This field holds the additional charges on the Blanket Purchase Order

No

No

BPOAHd_BPO_Currency_OU

numeric(10)

NOT NULL

This field holds the ou instance of currency component interacting with blanket purchase order

No

No

BPOAHd_BPO_Valid_From

datetime

NULL

This field holds the date from which the blanket purchase order document is valid

No

No

BPOAHd_BPO_Exch_Rate_OU

numeric(10)

NULL

This field holds the ou instance of exchange rate component interacting with blanket purchase order

No

No

BPOAHd_BPO_Valid_To

datetime

NULL

This field holds the date to which the blanket purchase order document is valid

No

No

BPOAHd_BPO_Quality

varchar(5)

NULL

This field holds the flag is set when the quality attributes are allowed. Allowed values are 1.Y- Yes 2.N-No

No

No

BPOAHd_BPO_Currency

varchar(20)

NOT NULL

This field holds the currency code of blanket purchase order document

No

No

BPOAHd_BPO_Type

varchar(5)

NOT NULL

This field holds the type of blanket purchase order document

No

No

BPOAHd_BPO_Category

varchar(25)

NULL

This field holds the category of the blanket purchase order document

No

No

Table Name BPO_BPOApc_Auth_Pc_Dtl

Table Comment This table is Used to store information for the Purchase Committee Details.

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

BPOApc_Member_Auth_Status

varchar(5)

NULL

This field holds the member authorization status of Blanket purchase order document

No

No

BPOApc_Emp_Code

varchar(20)

NOT NULL

This field holds the employee code of the blanket purchase order document

Yes

No

BPOApc_Auth_By

varchar(30)

NULL

This field holds the user who authorised the record

No

No

BPOApc_Auth_Date

datetime

NULL

This field holds the authorization date of blanket purchase order document

No

No

BPOApc_BPO_OUInstance

numeric(10)

NOT NULL

This is the ou instance in which BPO document is created

Yes

Yes

BPOApc_Pc_Code

varchar(25)

NOT NULL

This field holds the purchase committee code of blanket purchase order document

Yes

No

BPOApc_BPO_No

varchar(40)

NOT NULL

This field holds the Blanket purchase order number

Yes

Yes

Table Name BPO_BPOApd_Auth_Prof_dtl

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

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

BPOApd_Members_Authorized

numeric(10)

NULL

The field holds the no. of members authorised for blanket purchase order document

No

No

BPOApd_Pc_Quroum

numeric(10)

NULL

This field holds the purchase committee quorum of blanket purchase order

No

No

BPOApd_Pc_Type

varchar(5)

NULL

This field holds the Purchase committee type of blanket purchase order

No

No

BPOApd_Lvl_Pc_Auth_Status

varchar(5)

NULL

This field holds the level/purchase committee authorization status

No

No

BPOApd_Last_Authorized_By

varchar(30)

NULL

This field holds the last authorised by detail

No

No

BPOApd_Last_Auth_Date

datetime

NULL

This field holds the last authorisation date

No

No

BPOApd_BPO_No

varchar(40)

NOT NULL

This field holds the blanket purchase order number

Yes

Yes

BPOApd_BPO_OUInstance

numeric(10)

NOT NULL

This field holds the ou instance in which blanket purchase order document is created

Yes

Yes

BPOApd_No_Members

numeric(10)

NULL

This field holds the no of members in the authorization profile details of blanket purchase order

No

No

BPOApd_Type

varchar(5)

NULL

This field holds the type of blanket purchase order

No

No

BPOApd_Lvl_Pc_Code

varchar(25)

NOT NULL

This field holds the level/purchase committee code

Yes

No

BPOApd_Seq_No

numeric(10)

NOT NULL

This field holds the sequence number of blanket purchase order document

Yes

No

Table Name BPO_BPOAPd_Part_dtl

Table Comment Used to capture the Part Level Tcd Information for the Amended history of the BPO Document

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

BPOAPd_Tolerance_Type

varchar(5)

NULL

This field holds the tolerance type of blanket purchase order document

No

No

BPOAPd_Tolerance_Perc

decimal(28,8)

NULL

This field holds the tolerance percentage of blanket purchase order document

No

No

BPOAPd_Quality_Attribute

varchar(5)

NULL

This field holds the quality attribute of blanket purchase order document Allowed values are 1.Y- Yes 2.N-No

No

No

BPOAPd_Alternate_Part_No

varchar(40)

NULL

This field is to capture the alternate part no of blanket purchase order document

No

No

BPOAPd_Matching_Type

varchar(5)

NULL

This field holds the matching type of blanket purchase order document

No

No

BPOAPd_Inspection_Type

varchar(5)

NULL

This field holds the inspection type of blanket purchase order document

No

No

BPOAPd_Line_Item_Value

decimal(28,8)

NULL

This field holds the line Item amount associated with blanket purchase order document

No

No

BPOAPd_Modified_By

varchar(30)

NOT NULL

This field holds the user who modified the record.

No

No

BPOAPd_ModifiedDate

datetime

NOT NULL

This field holds the modified date of the record

No

No

BPOAPd_Rcpt_Pos_Tol

numeric(28,8)

NULL

This fields holds the percentage positive tolerance value. The qty of the part number of a BPO can exceed by this specified percentage during goods receipt

No

No

BPOAPd_Line_Remarks

varchar(255)

NULL

This field is to capture the remarks of the part associated with blanket purchase order

No

No

BPOAPd_Allotment_Mode

varchar(5)

NULL

This field holds the allotment mode of blanket purchase order. 1.Quantity 2.Rate 3.Value

No

No

BPOAPd_Created_By

varchar(30)

NOT NULL

This field holds the user who created the record

No

No

BPOAPd_CreatedDate

datetime

NOT NULL

This field holds the created date of the record

No

No

BPOAPd_Rcpt_Neg_Tol

numeric(28,8)

NULL

This fields holds the percentage negative tolerance value. The qty of the part number of a BPO can be less by this specified percentage during goods receipt

No

No

BPOAPd_Line_No

numeric(10)

NOT NULL

This field holds the part line no of the blanket purchase order

No

No

BPOAPd_BPO_Line_Id

numeric(10)

NOT NULL

This field holds the line id of blanket purchase order

Yes

No

BPOAPd_Part_OU

numeric(10)

NOT NULL

This is the part admin ou instance which interacts with the BPO component

No

No

BPOAPd_Part_No

varchar(40)

NOT NULL

This field holds the part no associated with the bpo document

No

No

BPOAPd_BPO_OUInstance

numeric(10)

NOT NULL

This is the ou instance in which blanket purchase order document is created

Yes

Yes

BPOAPd_BPO_Amend_No

numeric(10)

NOT NULL

This field holds the amendment No history of the blanket purchase order

Yes

Yes

BPOAPd_BPO_No

varchar(40)

NOT NULL

This field holds the blanket purchase order number

Yes

Yes

BPOAPd_Line_TCD_Amt

decimal(28,8)

NULL

This field holds the line TCD amount associated with blanket purchase order document

No

No

BPOAPd_Cost

decimal(28,8)

NOT NULL

This field holds the cost for the part associated with blanket purchase order document

No

No

BPOAPd_Purchase_UOM

varchar(10)

NOT NULL

This field holds the purchase UOM for the part associated with blanket purchase order document

No

No

BPOAPd_Cost_Per

decimal(28,8)

NOT NULL

This field holds the cost per for the part associated with blanket purchase order document

No

No

BPOAPd_Part_Condition

varchar(5)

NULL

This field holds the part condition associated with BPO document

No

No

BPOAPd_Order_Qty

decimal(28,8)

NULL

This field holds the part order quantity for blanket purchase order document

No

No

BPOAPd_BPO_Balance_Value

decimal(28,8)

NULL

This field holds the balance value of the blanket purchase order

No

No

BPOAPd_BPO_Balance_Qty

decimal(28,8)

NULL

This field holds the balance quantity of the blanket purchase order

No

No

Table Name BPO_BPOATC_Terms_Condns

Table Comment Used to store the Terms and Condition Information for the Amended History of the BPO Document

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

BPOATC_Payto_Supp_AddrID

decimal(38)

NULL

This field holds the pay to supplier’s address id.

No

No

BPOATC_DDChrgs_BorneBy

varchar(5)

NULL

This field holds the flag which identifies that the DD charges will be borne by whom B- blank SF - Self RS - Supplier

No

No

BPOATC_Pay_Mode

varchar(5)

NULL

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

No

No

BPOATC_Payment_Notes

varchar(2000)

NULL

This field holds the payment notes

No

No

BPOATC_Warranty

varchar(5)

NULL

This field holds the flag whether warranty is yes or no Y- Yes N - No B - Blank

No

No

BPOATC_Warranty_Basis

varchar(5)

NULL

This field holds the flag to indicate the warranty basis C- Calendar U - Usage BH - Both B - Blank

No

No

BPOATC_Adv_Per_On

varchar(5)

NULL

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

No

No

BPOATC_Adv_Percent

numeric(28)

NULL

This field holds the value of advance percentage

No

No

BPOATC_Payment_Priority

varchar(5)

NULL

This field holds the flag for payment priority H - High N - Normal L - Low

No

No

BPOATC_Adv_Payable_Val

numeric(28)

NULL

This field holds the advance payable value

No

No

BPOATC_Adv_Tol_Perc

numeric(28)

NULL

This field holds the advance tolerance percentage

No

No

BPOATC_Adv_Pay_ByDate

datetime

NULL

This field holds the date by which advance is payable

No

No

BPOATC_Ref_Doc_Date

datetime

NULL

This field holds the reference document date

No

No

BPOATC_GTA_RefNo

varchar(40)

NULL

This field holds the General terms and agreement reference number

No

No

BPOATC_Shipping_Notes

varchar(2000)

NULL

This field holds the shipping notes

No

No

BPOATC_GTA_Remarks

varchar(255)

NULL

This field holds the General terms and agreement Remarks

No

No

BPOATC_Pay_to_Supplier_OU

decimal(38)

NULL

This field holds the OU instance of the Supplier to whom payment has to be made

No

No

BPOATC_Warr_Agrmt_No

varchar(40)

NULL

This field holds the warranty agreement number

No

No

BPOATC_Packaging_Notes

varchar(2000)

NULL

This field holds the packaging notes

No

No

BPOATC_Packaging_Code

varchar(25)

NULL

This field holds the packaging code

No

No

BPOATC_Shipping_Payment

varchar(25)

NULL

This field holds the payment method defined in logistics common master BPOTC_Shipping_Notes

No

No

BPOATC_Port_Of_Departure

varchar(32)

NULL

This field holds the port of departure

No

No

BPOATC_Carrier_Agency_No

varchar(20)

NULL

This field holds the carrier/agency number

No

No

BPOATC_Pay_Term_Code

varchar(25)

NULL

This field holds the pay term code of the blanket purchase order document

No

No

BPOATC_Pay_to_Supplier_No

varchar(45)

NOT NULL

This field holds the pay to supplier number of blanket purchase order document

No

No

BPOATC_Payment_Mode

varchar(5)

NOT NULL

This field holds the payment mode of the blanket purchase order document

No

No

BPOATC_PAY_TERM

varchar(25)

NULL

This field holds the Pay term of the BPO mapped

No

No

BPOATC_Insur_Terms

varchar(150)

NULL

This field holds the insurance terms of the blanket purchase order document

No

No

BPOATC_Insur_Liability

varchar(5)

NULL

This field holds the insurance liability of blanket purchase order document

No

No

BPOATC_Insur_Amount

decimal(28,8)

NULL

This field holds the insurance amount of blanket purchase order document

No

No

BPOATC_BPO_No

varchar(40)

NOT NULL

The field holds the blanket purchase order number

Yes

Yes

BPOATC_BPO_OUInstance

numeric(10)

NOT NULL

This field holds the ou instance in which blanket purchase order is created

Yes

Yes

BPOATC_PAY_TERM_OU

numeric(10)

NULL

This field holds the OU instance id where the pay term has been created

No

No

BPOATC_BPO_Amend_No

numeric(10)

NOT NULL

This field holds the amendment No history of the blanket purchase order

Yes

Yes

BPOATC_BPO_TYPE

varchar(5)

NULL

This field holds the BPO type RT- rate QTY - quantity VAL - value

No

No

BPOATC_Adv_Payable

varchar(5)

NULL

This field holds the flag whether advance is payable or not. Y - yes N - No

No

No

BPOATC_Created_By

varchar(30)

NOT NULL

This field holds the user who created the record

No

No

BPOATC_CreatedDate

datetime

NOT NULL

This field holds the created date of the record

No

No

BPOATC_TMCN_REMARKS

varchar(255)

NULL

This field holds the remarks of the BPO document

No

No

BPOATC_ModifiedDate

datetime

NOT NULL

This field holds the modified date of the record

No

No

BPOATC_Modified_By

varchar(30)

NOT NULL

This field holds the user who modified the record

No

No

BPOATC_INCO_Term

varchar(150)

NULL

This field holds the INCO term of blanket purchase order document.

No

No

BPOATC_Delivery_Point

varchar(255)

NULL

This field holds the delivery point of the blanket purchase order document

No

No

BPOATC_Mode_of_Transport

varchar(150)

NULL

This field holds the mode of transport of blanket purchase order document

No

No

BPOATC_Ship_Partial

varchar(5)

NULL

This field holds the ship partial of blanket purchase order document

No

No

BPOATC_TransShipment

varchar(5)

NULL

This field holds the transshipment of blanket purchase order document

No

No

BPOATC_Packaging_Terms

varchar(150)

NULL

This field holds the packaging terms of blanket purchase order document.

No

No

Table Name BPO_BPOHd_BlkPurOrd_hdr

Table Comment This table is used to Store the Information Of the BPO Document

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

BPOHd_BPO_OUInstance

numeric(10)

NOT NULL

This field holds the ou instance in which BPO document is created

Yes

No

BPOHd_BPO_No

varchar(40)

NOT NULL

This field holds the Blanket purchase order number

Yes

No

BPOHd_BPO_Lat_Amend_No

numeric(10)

NOT NULL

This field holds the latest amendment no of the blanket purchase order

No

No

BPOHd_BPO_Date

datetime

NULL

This field holds the Blanket purchase order date

No

No

BPOHd_BPO_User_Status

varchar(25)

NULL

This field holds the user status of the blanket purchase order

No

No

BPOHd_BPO_Supplier_OU

numeric(10)

NULL

This field holds the supplier ou instance of the blanket purchase order

No

No

BPOHd_BPO_Supplier_No

varchar(45)

NOT NULL

This field holds the supplier number of the blanket purchase order

No

No

BPOHd_BPO_Part_Type

varchar(5)

NOT NULL

This field holds the part type of the blanket purchase order

No

No

BPOHd_BPO_Buyer_Group_OU

numeric(10)

NULL

This field holds the ou instance of Buyer group component interacting with blanket purchase order

No

No

BPOHd_BPO_Buyer_Group

varchar(25)

NULL

This field holds the Buyer group code of blanket purchase order

No

No

BPOHd_BPO_Agreement_No

varchar(40)

NOT NULL

This field holds the agreement no of blanket purchase order

No

No

BPOHd_BPO_Exch_Rate_OU

numeric(10)

NULL

This field holds the  ou instance of exchange rate component interacting with blanket purchase order

No

No

BPOHd_BPO_Exch_Rate

decimal(28,8)

NULL

This field holds the exchange rate of blanket purchase order

No

No

BPOHd_BPO_Valid_From

datetime

NULL

This field holds the date from which the blanket purchase order document is valid

No

No

BPOHd_BPO_Valid_To

datetime

NULL

This field holds the date to which the blanket purchase order document is valid

No

No

BPOHd_BPO_Type

varchar(5)

NULL

This field holds the type of blanket purchase order document

No

No

BPOHd_BPO_Category

varchar(25)

NULL

This field holds the category of the blanket purchase order document

No

No

BPOHd_BPO_Currency_OU

numeric(10)

NULL

This field holds the ou instance of currency component interacting with blanket purchase order

No

No

BPOHd_BPO_Currency

varchar(20)

NOT NULL

This field holds the currency code of blanket purchase order document

No

No

BPOHd_BPO_Base_Currency

varchar(20)

NOT NULL

This field holds the base currency code of blanket purchase order document

No

No

BPOHd_BPO_Quality

varchar(5)

NULL

This field holds the flag is set when the quality attributes are allowed. Allowed values are 1.Y- Yes 2.N-No

No

No

BPOHd_BPO_Basic_Value

decimal(28,8)

NULL

This field holds the basic value of the blanket purchase order document

No

No

BPOHd_BPO_Doc_TCD_Amt

decimal(28,8)

NULL

This field holds the Tax/Charges/Discount amount at Blanket purchase order document level.

No

No

BPOHd_BPO_Line_TCD_Amt

decimal(28,8)

NULL

This field holds the sum of all Tax/Charges/Discount amount at Blanket purchase order line level.

No

No

BPOHd_BPO_Auth_Reason

varchar(255)

NULL

This field holds the reason for the authorization of blanket purchase order

No

No

BPOHd_BPO_Can_Reason

varchar(255)

NULL

This field holds the reason for the cancellation of blanket purchase order

No

No

BPOHd_BPO_Scl_Reason

varchar(255)

NULL

This field holds the reason for the short close of blanket purchase order

No

No

BPOHd_BPO_Hld_Reason

varchar(255)

NULL

This field holds the reason for the held blanket purchase order

No

No

BPOHd_BPO_Rel_Reason

varchar(255)

NULL

This field holds the reason for the releases blanket purchase order

No

No

BPOHd_BPO_Status

varchar(15)

NOT NULL

This field holds the status of the blanket purchase order document. Allowed values are 1.A- Active 2.I- Inactive

No

No

BPOHd_Auth_TerLevel

varchar(25)

NULL

This field holds the terminating level in authorization profile

No

No

BPOHd_Auth_MinVal

decimal(28,8)

NULL

This field holds the minimum value for which BPO document is authorised

No

No

BPOHd_Auth_MaxVal

decimal(28,8)

NULL

This field holds the maximum value for which BPO document is authorised

No

No

BPOHd_Auth_NxtLvlPc

varchar(25)

NULL

This field holds the next level in authorization profile of Blanket purchase order document

No

No

BPOHd_Auth_Type

varchar(5)

NULL

This field holds the authorization Allowed values are 1.Level 2.PC

No

No

BPOHd_Auth_Stage

varchar(25)

NULL

This field captures the stage of authorization

No

No

BPOHd_CreatedDate

datetime

NOT NULL

This field holds the created date of the record

No

No

BPOHd_Created_By

varchar(30)

NOT NULL

This field holds the user who created the record

No

No

BPOHd_ModifiedDate

datetime

NOT NULL

This field holds the modified date of the record

No

No

BPOHd_Modified_By

varchar(30)

NOT NULL

This field holds the user who modified the record

No

No

BPOHd_AmendedDate

datetime

NULL

This field holds the amended date of the record

No

No

BPOHd_Amended_By

varchar(30)

NULL

This field holds the user who amended the record

No

No

BPOHd_AuthorisedDate

datetime

NULL

This field holds the authorization date of blanket purchase order

No

No

BPOHd_Authorised_By

varchar(30)

NULL

This field holds the user who authorised this record

No

No

BPOHd_ConfirmedDate

datetime

NULL

This field holds the confirmed date of the record.

No

No

BPOHd_Confirmed_By

varchar(30)

NULL

This field holds the user who confirmed the record

No

No

BPOHd_TimeStamp

numeric(10)

NOT NULL

This field holds the timestamp value

No

No

BPOHd_BPO_Ret_Reason

varchar(255)

NULL

This field holds the reason for returning a document

No

No

BPOHD_BPO_wfdoc_key

varchar(2000)

NULL

This field holds the doc key which is a combination of document number, OU Instance. This is passed as an input to work flow service

No

No

BPOHD_BPO_numtype

varchar(5)

NULL

This field holds the numbering type number to be sent as an input to work flow

No

No

Table Name BPO_BPOIns_Inspect_dtl

Table 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 BPO Document.

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

BPOIns_Trackable

varchar(5)

NULL

This field holds when the trackable option is allowed. Allowed values are 1.YES 2.NO

No

No

BPOINS_BPO_UOM

varchar(20)

NULL

This field holds the unit of measurement

No

No

BPOIns_Std_Qual_Value

varchar(80)

NULL

This field holds the standard qualitative value

No

No

BPOIns_Maximum_Value

decimal(28,8)

NULL

This field holds the maximum value of blanket purchase order document

No

No

BPOIns_Minimum_Value

decimal(28,8)

NULL

This field holds the minimum value of blanket purchase order document

No

No

BPOIns_ModifiedDate

datetime

NOT NULL

This field holds the modified date of the record

No

No

BPOIns_Inspect_Remarks

varchar(255)

NULL

This field holds the inspect remarks of blanket purchase order component

No

No

BPOIns_Created_By

varchar(30)

NOT NULL

This field holds the user who created the record

No

No

BPOIns_CreatedDate

datetime

NOT NULL

This field holds the created date of the record

No

No

BPOIns_Modified_By

varchar(30)

NOT NULL

This field holds the user who modified the record

No

No

BPOIns_BPO_Line_Id

numeric(10)

NOT NULL

This field holds the uniquely generated id of blanket purchase order document

Yes

Yes

BPOIns_BPO_Attribute_Id

varchar(40)

NOT NULL

This field holds the attribute id of blanket purchase order document

Yes

No

BPOIns_BPO_No

varchar(40)

NOT NULL

This field holds the document no of blanket purchase order

Yes

Yes

BPOIns_BPO_OUInstance

numeric(10)

NOT NULL

This field holds the ou instance in which BPO is created

Yes

Yes

BPOIns_Std_Value

decimal(28,8)

NULL

This field holds the standard value of blanket purchase order document

No

No

BPOIns_Attribute_Type

varchar(5)

NULL

this field is to capture the attribute type of blanket purchase order document

No

No

BPOIns_Std_Max_Value

decimal(28,8)

NULL

This field holds the standard maximum value of blanket purchase order document

No

No

BPOIns_Attribute_Code

varchar(10)

NULL

this field is to capture the attribute code of blanket purchase order document

No

No

BPOIns_Std_Min_Value

decimal(28,8)

NULL

This field holds the standard minimum value of blanket purchase order document

No

No

BPOIns_Attribute_OU

numeric(10)

NULL

This field holds the ou instance of attribute component with which blanket purchase order is created.

No

No

Table Name BPO_BPOPdt_Part_dtl

Table Comment This table is Used to store the Part Level information of the Blanket Purchase Order Document with the Line No

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

BPOPdt_BPO_OUInstance

numeric(10)

NOT NULL

This field holds the ou instance in which blanket purchase order document is created

Yes

Yes

BPOPdt_BPO_No

varchar(40)

NOT NULL

This field holds the blanket purchase order number

Yes

Yes

BPOPdt_BPO_Line_Id

numeric(10)

NOT NULL

This field holds the line id of blanket purchase order

Yes

No

BPOPdt_Line_No

numeric(10)

NOT NULL

This field holds the part line no of the blanket purchase order

No

No

BPOPdt_Part_OU

numeric(10)

NULL

This field holds the part admin ou instance which interacts with the BPO component

No

No

BPOPdt_Part_No

varchar(40)

NOT NULL

This field holds the part no associated with the bpo document

No

No

BPOPdt_Part_Condition

varchar(5)

NULL

This field holds the part condition associated with BPO document

No

No

BPOPdt_Order_Qty

decimal(28,8)

NULL

This field holds the part order quantity for blanket purchase order document

No

No

BPOPdt_BPO_Balance_Qty

decimal(28,8)

NULL

This field holds the balance quantity of the blanket purchase order

No

No

BPOPdt_BPO_Balance_Value

decimal(28,8)

NULL

This field holds the balance value of the blanket purchase order

No

No

BPOPdt_Purchase_UOM

varchar(10)

NOT NULL

This field holds the purchase UOM for the part associated with blanket purchase order document

No

No

BPOPdt_Cost

decimal(28,8)

NULL

This field holds the cost for the part associated with blanket purchase order document

No

No

BPOPdt_Cost_Per

decimal(28,8)

NULL

This field holds the cost per for the part associated with blanket purchase order document

No

No

BPOPdt_Line_TCD_Amt

decimal(28,8)

NULL

This field holds the line TCD amount associated with blanket purchase order document

No

No

BPOPdt_Line_Item_Value

decimal(28,8)

NULL

This field holds the line Item amount associated with blanket purchase order document

No

No

BPOPdt_Alternate_Part_No

varchar(5)

NULL

This field is to capture the alternate part no of blanket purchase order document

No

No

BPOPdt_Inspection_Type

varchar(5)

NULL

This field holds the inspection type of blanket purchase order document

No

No

BPOPdt_Matching_Type

varchar(5)

NULL

This field holds the matching type of blanket purchase order document

No

No

BPOPdt_Tolerance_Type

varchar(5)

NULL

This field holds the tolerance type of blanket purchase order document

No

No

BPOPdt_Tolerance_Perc

decimal(28,8)

NULL

This field holds the tolerance percentage of blanket purchase order document

No

No

BPOPdt_Quality_Attribute

varchar(5)

NULL

This field holds the quality attribute of blanket purchase order document Allowed values are 1.Y- Yes 2.N-No

No

No

BPOPdt_Line_Remarks

varchar(255)

NULL

This field is to capture the remarks of the part associated with blanket purchase order

No

No

BPOPdt_Allotment_Mode

varchar(5)

NULL

This field holds the allotment mode of blanket purchase order. 1.Quantity 2.Rate 3.Value

No

No

BPOPdt_CreatedDate

datetime

NULL

This field holds the created date of the record

No

No

BPOPdt_Created_By

varchar(30)

NULL

This field holds the user who created the record

No

No

BPOPdt_ModifiedDate

datetime

NULL

This field holds the modified date of the record

No

No

BPOPdt_Modified_By

varchar(30)

NULL

This field holds the user who modified the record.

No

No

BPOPdt_Rcpt_Pos_Tol

numeric(28,8)

NULL

This field holds the percentage positive tolerance value. The qty of the part number of a BPO can exceed by this specified percentage during goods receipt

No

No

BPOPdt_Rcpt_Neg_Tol

numeric(28,8)

NULL

This field holds the percentage negative tolerance value. The qty of the part number of a BPO can be less by this specified percentage during goods receipt

No

No

Table Name BPO_BPOPrm_parameter_dtl

Table Comment Used to Store the Parameter Details of the BPO Document

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

BPOPrm_Componentname

varchar(20)

NOT NULL

This field holds the Name of the component.

Yes

No

BPOPrm_Paramcategory

varchar(10)

NOT NULL

This field holds the category of the static value. The static values could be to fill up combo, text field, guidance text, combo default etc.

Yes

No

BPOPrm_Paramtype

varchar(25)

NOT NULL

This fields holds the 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

No

BPOPrm_Paramcode

varchar(5)

NOT NULL

This fields holds 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

No

BPOPrm_Langid

numeric(10)

NOT NULL

This fields holds the language id. This is the language id of the record.

Yes

No

BPOPrm_Paramdesc

varchar(80)

NULL

This fields holds the 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

No

BPOPrm_Sortby

numeric(10)

NULL

This field holds the default sort by code

No

No

BPOPrm_Createddate

datetime

NULL

This field holds the record created date for auditing purpose.

No

No

Table Name BPO_BPOROD_REF_OBJ_DTL

Table Comment This tables stores the specify document references that are applicable for the BPO.

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

BPOROD_CREATED_OUINSTANCE

decimal(38)

NOT NULL

This field holds the Organization unit of the create BPO document

Yes

No

BPOROD_BPO_NO

varchar(40)

NOT NULL

This field holds the generated BPO number

Yes

No

BPOROD_DOC_LINE_ID

decimal(38)

NOT NULL

This field holds the line number of the part information

Yes

No

BPOROD_REF_DOC_TYPE

varchar(25)

NULL

This field holds the reference document. The system lists all the reference document types that are defined in the Common Masters business component, that are in the Active status

No

No

BPOROD_REF_DOC_ID

varchar(40)

NULL

This field stores the number that identifies the reference document

No

No

BPOROD_REF_DOC_FILE_NAME

varchar(50)

NULL

This field holds the file name of the reference document

No

No

BPOROD_CREATED_DATE

datetime

NULL

This field holds the created date of Reference document to a BPO

No

No

BPOROD_CREATED_BY

varchar(30)

NOT NULL

This field holds the created user of Reference document to a BPO

No

No

BPOROD_MODIFIED_DATE

datetime

NULL

This field holds the modified date of Reference document to a BPO

No

No

BPOROD_MODIFIED_BY

varchar(30)

NOT NULL

This field holds the modified user of Reference document to a BPO

No

No

Table Name BPO_BpoSopt_Setoption_Info

Table Comment Stores the set option details defined for the Blanket Purchase Order

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

BpoSopt_OUInstance

decimal(38)

NULL

This fields holds the OU Instance where the set option record is created

No

No

BpoSopt_MultiPrtTyp_Allow

varchar(5)

NULL

This fields holds the flag whether Multiple Part types are allowed or not. Y - Yes N - No

No

No

BpoSopt_Def_Rcpt_Tol

varchar(5)

NULL

This fields holds the flag whether the receipt tolerance value has to be defaulted from Part Admin or not be defaulted from Part Admin

No

No

BpoSopt_Created_Date

datetime

NULL

This fields holds the created date of the record

No

No

BpoSopt_Created_By

varchar(25)

NULL

This fields holds the user name who created the record

No

No

BpoSopt_Modified_Date

datetime

NULL

This fields holds the modified date of the record

No

No

BpoSopt_Modified_By

varchar(25)

NULL

This fields holds the user name who modified the record

No

No

BPOSOPT_TIMESTAMP

decimal(38)

NULL

This fields holds the timestamp of the record

No

No

Table Name BPO_BPOTC_Terms_Condns

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

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

BPOTC_BPO_OUInstance

numeric(10)

NOT NULL

This field holds the ou instance in which blanket purchase order is created

Yes

Yes

BPOTC_BPO_No

varchar(40)

NOT NULL

The field holds the blanket purchase order number

Yes

Yes

BPOTC_Pay_term_OU

numeric(10)

NULL

This field holds the ou instance of pay term component with which BPO is interacting

No

No

BPOTC_Pay_Term_Code

varchar(25)

NULL

This field holds the pay term code of the blanket purchase order document

No

No

BPOTC_Payment_Mode

varchar(5)

NOT NULL

This field holds the payment mode of the blanket purchase order document

No

No

BPOTC_Pay_to_Supplier_No

varchar(45)

NOT NULL

This field holds the pay to supplier number of blanket purchase order document

No

No

BPOTC_Insur_Terms

varchar(150)

NULL

This field holds the insurance terms of the blanket purchase order document

No

No

BPOTC_Insur_Liability

varchar(5)

NULL

This field holds the insurance liability of blanket purchase order document

No

No

BPOTC_Insur_Amount

decimal(28,8)

NULL

This field holds the insurance amount of blanket purchase order document

No

No

BPOTC_INCO_Term

varchar(150)

NULL

This field holds the INCO term of blanket purchase order document.

No

No

BPOTC_Mode_of_Transport

varchar(150)

NULL

This field holds the mode of transport of blanket purchase order document

No

No

BPOTC_Delivery_Point

varchar(255)

NULL

This field holds the delivery point of the blanket purchase order document

No

No

BPOTC_TransShipment

varchar(5)

NULL

This field holds the transshipment of blanket purchase order document

No

No

BPOTC_Packaging_Terms

varchar(150)

NULL

This field holds the packaging terms of blanket purchase order document.

No

No

BPOTC_Ship_Partial

varchar(5)

NULL

This field holds the ship partial of blanket purchase order document

No

No

BPOTC_TERM_CONDN_REMARKS

varchar(255)

NULL

This field holds the  Terms and condition remarks of the BPO document

No

No

BPOTC_CreatedDate

datetime

NOT NULL

This field holds the created date of the record

No

No

BPOTC_Created_By

varchar(30)

NOT NULL

This field holds the user who created the record

No

No

BPOTC_ModifiedDate

datetime

NOT NULL

This field holds the modified date of the record

No

No

BPOTC_Modified_By

varchar(30)

NOT NULL

This field holds the user who modified the record

No

No

BPOTC_Adv_Payable

varchar(5)

NULL

This field holds the flag whether advance is payable or not. Y - yes N - No

No

No

BPOTC_Adv_Pay_ByDate