|
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| BPOAHD_BPO_OUINSTANCE | _decimal_10_0 | decimal(10) | No | This field holds ouinstance in which BPO document is created | Yes |
| BPOAHD_BPO_AMEND_NO | _decimal_10_0 | decimal(10) | No | This field holds the amendment No history of the blanket purchase order | Yes |
| BPOAHD_BPO_NO | _varchar_40 | varchar(40) | No | This field holds the Blanket purchase order number | Yes |
| BPOAHD_BPO_DATE | _datetime_8 | datetime(8) | No | This field holds the Blanket purchase order date | No |
| BPOAHD_BPO_USER_STATUS | _varchar_25 | Varchar(25) | Yes | This field holds the user status of the blanket purchase order | No |
| BPOAHD_BPO_SUPPLIER_NO | _varchar_45 | varchar(45) | No | This field holds the supplier number of the blanket purchase order | No |
| BPOAHD_BPO_SUPPLIER_OU | _decimal_10_0 | decimal(10) | No | This field holds the supplier ouinstance of the blanket purchase order | No |
| BPOAHD_BPO_PART_TYPE | _varchar_5 | varchar(5) | No | This field holds the part type of the blanket purchase order | No |
| BPOAHD_BPO_BUYER_GROUP | _varchar_25 | Varchar(25) | Yes | This field holds the Buyer group code of blanket purchase order | No |
| BPOAHD_BPO_AGREEMENT_NO | _varchar_40 | varchar(40) | No | This field holds the agreement no of blanket purchase order | No |
| BPOAHD_BPO_BUYER_GROUP_OU | _decimal_10_0 | decimal(10) | Yes | This field holds the ouinstance of Buyer group component interacting with blanket purchase order | No |
| BPOAHD_BPO_EXCH_RATE | _decimal_28_8 | decimal(28) | Yes | This field holds the exchange rate of blanket purchase order | No |
| BPOAHD_BPO_VALID_FROM | _datetime_8 | datetime(8) | Yes | This field holds the date from which the blanket purchase order document is valid | No |
| BPOAHD_BPO_VALID_TO | _datetime_8 | datetime(8) | Yes | This field holds the date to which the blanket purchase order document is valid | No |
| BPOAHD_BPO_EXCH_RATE_OU | _decimal_10_0 | decimal(10) | Yes | This field holds the ouinstance of exchange rate component interacting with blanket purchase order | No |
| BPOAHD_BPO_TYPE | _varchar_5 | varchar(5) | No | This field holds the type of blanket purchase order document | No |
| BPOAHD_BPO_CATEGORY | _varchar_25 | Varchar(25) | Yes | This field holds the category of the blanket purchase order document | No |
| BPOAHD_BPO_CURRENCY | _varchar_20 | varchar(20) | No | This field holds the currency code of blanket purchase order document | No |
| BPOAHD_BPO_QUALITY | _varchar_5 | varchar(5) | Yes | This field holds the flag is set when the quality attributes are allowed. Allowed values are 1.Y- Yes 2.N-No | No |
| BPOAHD_BPO_BASIC_VALUE | _decimal_28_8 | decimal(28) | Yes | This field holds the basic value of the blanket purchase order document | No |
| BPOAHD_BPO_LINE_TCD_AMT | _decimal_28_8 | decimal(28) | Yes | This field holds the Tax/Charges/Discount amount at Blanket purchase order line level. | No |
| BPOAHD_BPO_DOC_TCD_AMT | _decimal_28_8 | decimal(28) | Yes | This field holds the sum of all Tax/Charges/Discount amount at Blanket purchase order document level. | No |
| BPOAHD_BPO_ADDLN_CHARGES | _decimal_28_8 | decimal(28) | Yes | This field holds the additional charges on the Blanket Purchase Order | No |
| BPOAHD_BPO_CURRENCY_OU | _decimal_10_0 | decimal(10) | No | This field holds the ouinstance of currency component interacting with blanket purchase order | No |
| BPOAHD_BASIC_CUR_VALUE | _decimal_28_8 | decimal(28) | Yes | This field holds the value of BPO in basic currency | No |
| BPOAHD_BPO_TOTAL_VALUE | _decimal_28_8 | decimal(28) | Yes | This field holds the BPO total value | No |
| BPOAHD_BPO_AUTH_REASON | _varchar_255 | varchar(255) | Yes | This field holds the reason for the authorisation of blanket purchase order | No |
| BPOAHD_BPO_BASE_CURRENCY | _varchar_20 | varchar(20) | Yes | This field holds the base currency code of blanket purchase order document | No |
| BPOAHD_BPO_SCL_REASON | _varchar_255 | varchar(255) | Yes | This field holds the reason for the shortclose of blanket purchase order | No |
| BPOAHD_BPO_HLD_REASON | _varchar_255 | varchar(255) | Yes | This field holds the reason for the held blanket purchase order | No |
| BPOAHD_BPO_REL_REASON | _varchar_255 | varchar(255) | Yes | This field holds the reason for the releases blanket purchase order | No |
| BPOAHD_BPO_STATUS | _varchar_15 | varchar(15) | Yes | This field holds the status of the blanket purchase order document.Allowed values are 1.A- Active 2.I- Inactive | No |
| BPOAHD_AUTH_TERLEVEL | _varchar_25 | Varchar(25) | Yes | This field holds the terminating level in authorisation profile | No |
| BPOAHD_AUTH_MINVAL | _decimal_28_8 | decimal(28) | Yes | This field holds the minimum value for which BPO document is authorised | No |
| BPOAHD_AUTH_MAXVAL | _decimal_28_8 | decimal(28) | Yes | This field holds the maximum value for which BPO document is authorised | No |
| BPOAHD_AUTH_NXTLVLPC | _varchar_25 | Varchar(25) | Yes | This field holds the next level in authoristaion profile of Blanket purchase order document | No |
| BPOAHD_AUTH_TYPE | _varchar_5 | varchar(5) | Yes | This field holds the authorisation Allowed values are 1.Level 2.PC | No |
| BPOAHD_AUTH_STAGE | _varchar_25 | Varchar(25) | Yes | This field captures the stage of authorisation | No |
| BPOAHD_CREATEDDATE | _datetime_8 | datetime(8) | No | This field holds the created date of the record | No |
| BPOAHD_CREATED_BY | _varchar_30 | varchar(30) | No | This field holds the user who created the record | No |
| BPOAHD_MODIFIEDDATE | _datetime_8 | datetime(8) | No | This field holds the modified date of the record | No |
| BPOAHD_MODIFIED_BY | _varchar_30 | varchar(30) | No | This field holds the user who modified the record | No |
| BPOAHD_AMENDEDDATE | _datetime_8 | datetime(8) | Yes | This field holds the amended date of the record | No |
| BPOAHD_AMENDED_BY | _varchar_30 | varchar(30) | Yes | Thsi field holds the user who amended the record | No |
| BPOAHD_AUTHORISEDDATE | _datetime_8 | datetime(8) | Yes | This field holds the authorisation date of blanket purchase order | No |
| BPOAHD_AUTHORISED_BY | _varchar_30 | varchar(30) | Yes | This field holds the user who authorised this record | No |
| BPOAHD_CONFIRMEDDATE | _datetime_8 | datetime(8) | Yes | This field holds the confirmed date of the record. | No |
| BPOAHD_CONFIRMED_BY | _varchar_30 | varchar(30) | Yes | This field holds the user who confirmed the record | No |
| BPOAHD_TIMESTAMP | _decimal_10_0 | decimal(10) | No | This field holds the timestamp value | No |
| BPOAHD_BPO_RET_REASON | _varchar_255 | varchar(255) | Yes | stores the reason for returning a document | No |
| BPOAHD_BPO_WFDOC_KEY | _varchar_2000 | varchar(2000) | Yes | This field holds the doc key which is a combination of document number, OUInstance. This is passed as an input to work flow service | No |
| BPOAHD_BPO_NUMTYPE | _varchar_5 | varchar(5) | Yes | This field holds the numbering type number to be sent as an input to workflow | No | |
| Table Name : | BPO_BPOAPC_AUTH_PC_DTL |
| Comment : | This table is Used to store information for the Purchase Committe Details. |
|
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| BPOAPC_BPO_OUINSTANCE | _decimal_10_0 | decimal(10) | No | This is the ouinstance in which BPO document is created | Yes |
| BPOAPC_BPO_NO | _varchar_40 | varchar(40) | No | This field holds the Blanket purchase order number | Yes |
| BPOAPC_PC_CODE | _varchar_25 | Varchar(25) | No | This field holds the purchase commitee code of blanket purchase order document | Yes |
| BPOAPC_EMP_CODE | _varchar_20 | varchar(20) | No | This field holds the employee code of the blanket purchase order document | Yes |
| BPOAPC_MEMBER_AUTH_STATUS | _varchar_5 | varchar(5) | Yes | This field holds the member authorisation status of Blanket purchase order document | No |
| BPOAPC_AUTH_BY | _varchar_30 | varchar(30) | Yes | This field holds the user who authorised the record | No |
| BPOAPC_AUTH_DATE | _datetime_8 | datetime(8) | Yes | This field holds the authorisation date of blanket purchase order document | No | |
| Table Name : | BPO_BPOAPD_AUTH_PROF_DTL |
| Comment : | This Table is Used to Store Authorization Profile Information of the Bpo Document |
|
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| BPOAPD_BPO_OUINSTANCE | _decimal_10_0 | decimal(10) | No | This is the ouinstance in which blanket purchase order document is created | Yes |
| BPOAPD_BPO_NO | _varchar_40 | varchar(40) | No | This field holds the blanket purchase order number | Yes |
| BPOAPD_LVL_PC_CODE | _varchar_25 | Varchar(25) | No | This field holds the level/purchase commitee code | Yes |
| BPOAPD_SEQ_NO | _decimal_10_0 | decimal(10) | No | This field holds the sequence number of blanket purchase order document | Yes |
| BPOAPD_TYPE | _varchar_5 | varchar(5) | Yes | This field holds the type of blanket purchase order | No |
| BPOAPD_NO_MEMBERS | _decimal_10_0 | decimal(10) | Yes | This field holds the no of members in the authorisation profile details of blanket purchase order | No |
| BPOAPD_PC_TYPE | _varchar_5 | varchar(5) | Yes | This field holds the Purchase commitee type of blanket purchase order | No |
| BPOAPD_PC_QUROUM | _decimal_10_0 | decimal(10) | Yes | THis field holds the purchase committee quorum of blanket purchase order | No |
| BPOAPD_MEMBERS_AUTHORIZED | _decimal_10_0 | decimal(10) | Yes | The field holds the no.of members authorised for blanket purchase order document | No |
| BPOAPD_LVL_PC_AUTH_STATUS | _varchar_5 | varchar(5) | Yes | This field holds the level/purchase commitee authorisation status | No |
| BPOAPD_LAST_AUTHORIZED_BY | _varchar_30 | varchar(30) | Yes | This field holds the last authorised by detail | No |
| BPOAPD_LAST_AUTH_DATE | _datetime_8 | datetime(8) | Yes | This field holds the last authorisation date | No | |
| Table Name : | BPO_BPOAPD_PART_DTL |
| Comment : | Used to scapture the Part Level Tcd Information for the Amended history of the BPO Document |
|
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| BPOAPD_LINE_NO | _decimal_10_0 | decimal(10) | No | This field holds the part line no of the blanket purchase order | No |
| BPOAPD_BPO_OUINSTANCE | _decimal_10_0 | decimal(10) | No | This is the ouinstance in which blanket purchase order document is created | Yes |
| BPOAPD_PART_NO | _varchar_40 | varchar(40) | No | This field holds the part no associated with the bpo document | No |
| BPOAPD_BPO_NO | _varchar_40 | varchar(40) | No | This field holds the blanket purchase order number | Yes |
| BPOAPD_BPO_AMEND_NO | _decimal_10_0 | decimal(10) | No | This field holds the amendment No history of the blanket purchase order | Yes |
| BPOAPD_PART_CONDITION | _varchar_5 | varchar(5) | Yes | This field holds the part condition associated with BPO document | No |
| BPOAPD_ORDER_QTY | _decimal_28_8 | decimal(28) | Yes | This field holds the part order quantity for blanket purchase order document | No |
| BPOAPD_BPO_LINE_ID | _decimal_10_0 | decimal(10) | No | This field holds the line id of blanket purchase order | Yes |
| BPOAPD_PURCHASE_UOM | _varchar_10 | varchar(10) | No | This field holds the purchase UOM for the part associated with blanket purchase order document | No |
| BPOAPD_COST | _decimal_28_8 | decimal(28) | No | This field holds the cost for the part associated with blanket purchase order document | No |
| BPOAPD_PART_OU | _decimal_10_0 | decimal(10) | No | This is the part admin ouinstance which interacts with the BPO component | No |
| BPOAPD_COST_PER | _decimal_28_8 | decimal(28) | No | This field holds the cost per for the part associated with blanket purchase order document | No |
| BPOAPD_LINE_TCD_AMT | _decimal_28_8 | decimal(28) | Yes | This field holds the line TCD amount associated with blanket purchase order document | No |
| BPOAPD_LINE_ITEM_VALUE | _decimal_28_8 | decimal(28) | Yes | This field holds the line Item amount associated with blanket purchase order document | No |
| BPOAPD_ALTERNATE_PART_NO | _varchar_40 | varchar(40) | Yes | This field is to capture the alternate part no of blanket purchase order document | No |
| BPOAPD_INSPECTION_TYPE | _varchar_5 | varchar(5) | Yes | This field holds the inspection type of blanket purchase order document | No |
| BPOAPD_MATCHING_TYPE | _varchar_5 | varchar(5) | Yes | This field holds the matching type of blanket purchase order document | No |
| BPOAPD_TOLERANCE_TYPE | _varchar_5 | varchar(5) | Yes | This field holds the tolerance type of blanket purchase order document | No |
| BPOAPD_TOLERANCE_PERC | _decimal_28_8 | decimal(28) | Yes | This field holds the tolerance percentage of blanket purchase order document | No |
| BPOAPD_QUALITY_ATTRIBUTE | _varchar_5 | varchar(5) | Yes | This field holds the quality attribute of blanket purchase order document Allowed values are 1.Y- Yes 2.N-No | No |
| BPOAPD_LINE_REMARKS | _varchar_255 | varchar(255) | Yes | This field is to capture the remarks of the part associated with blanket purchase order | No |
| BPOAPD_ALLOTMENT_MODE | _varchar_5 | varchar(5) | Yes | This field holds the allotment mode of blanket purchse order. 1.Quantity 2.Rate 3.Value | No |
| BPOAPD_CREATEDDATE | _datetime_8 | datetime(8) | No | This field holds the created date of the record | No |
| BPOAPD_CREATED_BY | _varchar_30 | varchar(30) | No | This field holds the user who created the record | No |
| BPOAPD_MODIFIEDDATE | _datetime_8 | datetime(8) | No | This field holds the modified date of the record | No |
| BPOAPD_MODIFIED_BY | _varchar_30 | varchar(30) | No | This field holds the user who modified the record. | No |
| BPOAPD_BPO_BALANCE_QTY | _decimal_28_8 | decimal(28) | Yes | This field holds the balance quantity of the blanket purchase order | No |
| BPOAPD_BPO_BALANCE_VALUE | _decimal_28_8 | decimal(28) | Yes | This field holds the balance value of the blanket purchase order | No |
| BPOAPD_RCPT_POS_TOL | _decimal_28_8 | decimal(28) | Yes | 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 |
| BPOAPD_RCPT_NEG_TOL | _decimal_28_8 | decimal(28) | Yes | 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 | |
| Table Name : | BPO_BPOATC_TERMS_CONDNS |
| Comment : | Used to store the Terms and Condition Information for the Amended Hstory of the BPO Document |
|
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| BPOATC_BPO_OUINSTANCE | _decimal_10_0 | decimal(10) | No | This field holds the ouinstance in which blanket purchase order is created | Yes |
| BPOATC_BPO_NO | _varchar_40 | varchar(40) | No | The field holds the blanket purchase order number | Yes |
| BPOATC_BPO_TYPE | _varchar_5 | varchar(5) | Yes | This field holds the BPO type RT- rate QTY - quantity VAL - value | No |
| BPOATC_PAY_TERM_OU | _decimal_10_0 | decimal(10) | Yes | This field holds the OU instance id where the pay term has been created | No |
| BPOATC_BPO_AMEND_NO | _decimal_10_0 | decimal(10) | No | This field holds the amendment No history of the blanket purchase order | Yes |
| BPOATC_PAY_TERM | _varchar_25 | Varchar(25) | Yes | This field holds the Pay term of the BPO mapped | No |
| BPOATC_PAYMENT_MODE | _varchar_5 | varchar(5) | No | This field holds the payment mode of the blanket purchase order document | No |
| BPOATC_PAY_TO_SUPPLIER_NO | _varchar_45 | varchar(45) | No | This field holds the pay to supplier number of blanket purchase order document | No |
| BPOATC_INSUR_TERMS | _varchar_150 | varchar(150) | Yes | This field holds the insurance terms of the blanket purchase order document | No |
| BPOATC_INSUR_LIABILITY | _varchar_5 | varchar(5) | Yes | This field holds the insurance liability of blanket purchase order document | No |
| BPOATC_INSUR_AMOUNT | _decimal_28_8 | decimal(28) | Yes | This field holds the insurance amount of blanket purchase order document | No |
| BPOATC_INCO_TERM | _varchar_150 | varchar(150) | Yes | This field holds the INCO term of blanket purchase order document. | No |
| BPOATC_MODE_OF_TRANSPORT | _varchar_150 | varchar(150) | Yes | This field holds the mode of transport of blanket purchase order document | No |
| BPOATC_DELIVERY_POINT | _varchar_255 | varchar(255) | Yes | This field holds the delivery point of the blanket purchase order document | No |
| BPOATC_TRANSSHIPMENT | _varchar_5 | varchar(5) | Yes | This field holds the transhipment of blanket purchase order document | No |
| BPOATC_PACKAGING_TERMS | _varchar_150 | varchar(150) | Yes | This field holds the packaging terms of blanket purchase order document. | No |
| BPOATC_SHIP_PARTIAL | _varchar_5 | varchar(5) | Yes | This field holds the ship partial of blanket purchase order document | No |
| BPOATC_TMCN_REMARKS | _varchar_255 | varchar(255) | Yes | This field holds the remarks of the BPO document | No |
| BPOATC_CREATEDDATE | _datetime_8 | datetime(8) | No | This field holds the created date of the record | No |
| BPOATC_CREATED_BY | _varchar_30 | varchar(30) | No | This field holds the user who created the record | No |
| BPOATC_MODIFIEDDATE | _datetime_8 | datetime(8) | No | This field holds the modified date of the record | No |
| BPOATC_MODIFIED_BY | _varchar_30 | varchar(30) | No | This field holds the user who modified the record | No |
| BPOATC_ADV_PAYABLE | _varchar_5 | varchar(5) | Yes | This field holds ths flag whether advance is payable or not. Y - yes N - No | No |
| BPOATC_ADV_PAY_BYDATE | _datetime_8 | datetime(8) | Yes | This field holds the date by which advance is payable | No |
| BPOATC_ADV_PERCENT | _decimal_28_8 | decimal(28) | Yes | This field holds the value of advance percentage | No |
| BPOATC_ADV_PER_ON | _varchar_5 | varchar(5) | Yes | stores the flag to identify whether the advance percent to be applied on Basic Value or Total Value. B - Blank BV - Basic Value TV - Total Value | No |
| BPOATC_ADV_PAYABLE_VAL | _decimal_28_8 | decimal(28) | Yes | This field holds the advance payable value | No |
| BPOATC_ADV_TOL_PERC | _decimal_28_8 | decimal(28) | Yes | This field holds the advance tolerance percentage | No |
| BPOATC_PAYMENT_PRIORITY | _varchar_5 | varchar(5) | Yes | This field holds the flag for payment priority H - High N - Normal L - Low | No |
| BPOATC_PAY_MODE | _varchar_5 | varchar(5) | Yes | This field holds the flag for the payment mode CS - Cash CQ - Cheque DD - Demand Draft P - Pay Order | No |
| BPOATC_DDCHRGS_BORNEBY | _varchar_5 | varchar(5) | Yes | This field holds the flag which identifies that the DD charges will be borne by whom B- blank SF - Self RS - Supplier | No |
| BPOATC_PAYTO_SUPP_ADDRID | _decimal_38_0 | decimal(38) | Yes | This field holds the pay to supplier s address id. | No |
| BPOATC_PAYMENT_NOTES | _varchar_2000 | varchar(2000) | Yes | This field holds the payment notes | No |
| BPOATC_WARRANTY | _varchar_5 | varchar(5) | Yes | This field holds the flag whether warranty is yes or no Y- Yes N - No B - Blank | No |
| BPOATC_WARRANTY_BASIS | _varchar_5 | varchar(5) | Yes | This field holds the flag to indicate the warranty basis C- Calendar U - Usage BH - Both B - Blank | No |
| BPOATC_WARR_AGRMT_NO | _varchar_40 | varchar(40) | Yes | This field holds the warrany agreement number | No |
| BPOATC_PACKAGING_CODE | _varchar_25 | Varchar(25) | Yes | This field holds the packaging code | No |
| BPOATC_PACKAGING_NOTES | _varchar_2000 | varchar(2000) | Yes | This field holds the packaging notes | No |
| BPOATC_PORT_OF_DEPARTURE | _varchar_32 | varchar(32) | Yes | This field holds the port of departure | No |
| BPOATC_CARRIER_AGENCY_NO | _varchar_20 | varchar(20) | Yes | This field holds the carrier/agency number | No |
| BPOATC_SHIPPING_PAYMENT | _varchar_25 | Varchar(25) | Yes | This field holds the payment method defined in logistics common masterBPOTC_Shipping_Notes | No |
| BPOATC_SHIPPING_NOTES | _varchar_2000 | varchar(2000) | Yes | This field holds the shipping notes | No |
| BPOATC_GTA_REFNO | _varchar_40 | varchar(40) | Yes | This field holds the General terms and agreement reference number | No |
| BPOATC_REF_DOC_DATE | _datetime_8 | datetime(8) | Yes | This field holds the reference document date | No |
| BPOATC_GTA_REMARKS | _varchar_255 | varchar(255) | Yes | This field holds the General terms and agreement Remarks | No |
| BPOATC_PAY_TO_SUPPLIER_OU | _decimal_38_0 | decimal(38) | Yes | This field holds the OUinstance of the Supplier to whom payment has to be made | No |
| BPOATC_PAY_TERM_CODE | _varchar_25 | Varchar(25) | Yes | This field holds the pay term code of the blanket purchase order document | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| BPOHD_BPO_OUINSTANCE | _decimal_10_0 | decimal(10) | No | This field holds the ouinstance in which BPO document is created | Yes |
| BPOHD_BPO_NO | _varchar_40 | varchar(40) | No | This field holds the Blanket purchase order number | Yes |
| BPOHD_BPO_LAT_AMEND_NO | _decimal_10_0 | decimal(10) | No | This field holds the latest amendment no of the blanket purchase order | No |
| BPOHD_BPO_DATE | _datetime_8 | datetime(8) | Yes | This field holds the Blanket purchase order date | No |
| BPOHD_BPO_TYPE | _varchar_5 | varchar(5) | Yes | This field holds the type of blanket purchase order document | No |
| BPOHD_BPO_SUPPLIER_NO | _varchar_45 | varchar(45) | No | This field holds the supplier number of the blanket purchase order | No |
| BPOHD_BPO_SUPPLIER_OU | _decimal_10_0 | decimal(10) | No | This field holds the supplier ouinstance of the blanket purchase order | No |
| BPOHD_BPO_PART_TYPE | _varchar_5 | varchar(5) | No | This field holds the part type of the blanket purchase order | No |
| BPOHD_BPO_BUYER_GROUP | _varchar_25 | Varchar(25) | Yes | This field holds the Buyer group code of blanket purchase order | No |
| BPOHD_BPO_BUYER_GROUP_OU | _decimal_10_0 | decimal(10) | Yes | This field holds the ouinstance of Buyer group component interacting with blanket purchase order | No |
| BPOHD_BPO_AGREEMENT_NO | _varchar_40 | varchar(40) | No | This field holds the agreement no of blanket purchase order | No |
| BPOHD_BPO_CURRENCY | _varchar_20 | varchar(20) | No | This field holds the currency code of blanket purchase order document | No |
| BPOHD_BPO_CURRENCY_OU | _decimal_10_0 | decimal(10) | No | This field holds the ouinstance of currency component interacting with blanket purchase order | No |
| BPOHD_BPO_BASE_CURRENCY | _varchar_20 | varchar(20) | No | This field holds the base currency code of blanket purchase order document | No |
| BPOHD_BPO_EXCH_RATE | _decimal_28_8 | decimal(28) | Yes | This field holds the exchange rate of blanket purchase order | No |
| BPOHD_BPO_EXCH_RATE_OU | _decimal_10_0 | decimal(10) | Yes | This field holds the ouinstance of exchange rate component interacting with blanket purchase order | No |
| BPOHD_BPO_VALID_FROM | _datetime_8 | datetime(8) | Yes | This field holds the date from which the blanket purchase order document is valid | No |
| BPOHD_BPO_VALID_TO | _datetime_8 | datetime(8) | Yes | This field holds the date to which the blanket purchase order document is valid | No |
| BPOHD_BPO_CATEGORY | _varchar_25 | Varchar(25) | Yes | This field holds the category of the blanket purchase order document | No |
| BPOHD_BPO_USER_STATUS | _varchar_25 | Varchar(25) | Yes | This field holds the user status of the blanket purchase order | No |
| BPOHD_BPO_QUALITY | _varchar_5 | varchar(5) | Yes | This field holds the flag is set when the quality attributes are allowed. Allowed values are 1.Y- Yes 2.N-No | No |
| BPOHD_BPO_BASIC_VALUE | _decimal_28_8 | decimal(28) | Yes | This field holds the basic value of the blanket purchase order document | No |
| BPOHD_BPO_DOC_TCD_AMT | _decimal_28_8 | decimal(28) | Yes | This field holds the Tax/Charges/Discount amount at Blanket purchase order document level. | No |
| BPOHD_BPO_LINE_TCD_AMT | _decimal_28_8 | decimal(28) | Yes | This field holds the sum of all Tax/Charges/Discount amount at Blanket purchase order line level. | No |
| BPOHD_BPO_AUTH_REASON | _varchar_255 | varchar(255) | Yes | This field holds the reason for the authorisation of blanket purchase order | No |
| BPOHD_BPO_SCL_REASON | _varchar_255 | varchar(255) | Yes | This field holds the reason for the shortclose of blanket purchase order | No |
| BPOHD_BPO_CAN_REASON | _varchar_255 | varchar(255) | Yes | This field holds the reason for the cancellation of blanket purchase order | No |
| BPOHD_BPO_HLD_REASON | _varchar_255 | varchar(255) | Yes | This field holds the reason for the held blanket purchase order | No |
| BPOHD_BPO_REL_REASON | _varchar_255 | varchar(255) | Yes | This field holds the reason for the releases blanket purchase order | No |
| BPOHD_BPO_STATUS | _varchar_15 | varchar(15) | No | This field holds the status of the blanket purchase order document.Allowed values are 1.A- Active 2.I- Inactive | No |
| BPOHD_AUTH_TERLEVEL | _varchar_25 | Varchar(25) | Yes | This field holds the terminating level in authorisation profile | No |
| BPOHD_AUTH_MINVAL | _decimal_28_8 | decimal(28) | Yes | This field holds the minimum value for which BPO document is authorised | No |
| BPOHD_AUTH_MAXVAL | _decimal_28_8 | decimal(28) | Yes | This field holds the maximum value for which BPO document is authorised | No |
| BPOHD_AUTH_NXTLVLPC | _varchar_25 | Varchar(25) | Yes | This field holds the next level in authoristaion profile of Blanket purchase order document | No |
| BPOHD_AUTH_TYPE | _varchar_5 | varchar(5) | Yes | This field holds the authorisation Allowed values are 1.Level 2.PC | No |
| BPOHD_AUTH_STAGE | _varchar_25 | Varchar(25) | Yes | This field captures the stage of authorisation | No |
| BPOHD_CREATEDDATE | _datetime_8 | datetime(8) | No | This field holds the created date of the record | No |
| BPOHD_CREATED_BY | _varchar_30 | varchar(30) | No | This field holds the user who created the record | No |
| BPOHD_MODIFIEDDATE | _datetime_8 | datetime(8) | No | This field holds the modified date of the record | No |
| BPOHD_MODIFIED_BY | _varchar_30 | varchar(30) | No | This field holds the user who modified the record | No |
| BPOHD_AMENDEDDATE | _datetime_8 | datetime(8) | Yes | This field holds the amended date of the record | No |
| BPOHD_AMENDED_BY | _varchar_30 | varchar(30) | Yes | Thsi field holds the user who amended the record | No |
| BPOHD_AUTHORISEDDATE | _datetime_8 | datetime(8) | Yes | This field holds the authorisation date of blanket purchase order | No |
| BPOHD_AUTHORISED_BY | _varchar_30 | varchar(30) | Yes | This field holds the user who authorised this record | No |
| BPOHD_CONFIRMEDDATE | _datetime_8 | datetime(8) | Yes | This field holds the confirmed date of the record. | No |
| BPOHD_CONFIRMED_BY | _varchar_30 | varchar(30) | Yes | This field holds the user who confirmed the record | No |
| BPOHD_TIMESTAMP | _decimal_10_0 | decimal(10) | No | This field holds the timestamp value | No |
| BPOHD_BPO_RET_REASON | _varchar_255 | varchar(255) | Yes | This field holds the reason for returning a document | No |
| BPOHD_BPO_WFDOC_KEY | _varchar_2000 | varchar(2000) | Yes | This field holds the doc key which is a combination of document number, OUInstance. This is passed as an input to work flow service | No |
| BPOHD_BPO_NUMTYPE | _varchar_5 | varchar(5) | Yes | This field holds the numbering type number to be sent as an input to workflow | No | |
| Table Name : | BPO_BPOINS_INSPECT_DTL |
| Comment : | This table is Used To store the Parameter Information which was captured from the Aircraft Component and the Present Value for the related Part No associated with the BPO Document. |
|
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| BPOINS_BPO_OUINSTANCE | _decimal_10_0 | decimal(10) | No | This field holds the ouinstance in which BPO is created | Yes |
| BPOINS_BPO_NO | _varchar_40 | varchar(40) | No | This field holds the document no of blanket purchase order | Yes |
| BPOINS_BPO_LINE_ID | _decimal_10_0 | decimal(10) | No | This field holds the uniquely generated id of blanket purchase order document | Yes |
| BPOINS_BPO_ATTRIBUTE_ID | _varchar_40 | varchar(40) | No | This field holds the attribute id of blanket purchase order document | Yes |
| BPOINS_ATTRIBUTE_CODE | _varchar_10 | varchar(10) | Yes | this field is tocapture the attribute code of blanket purchase order document | No |
| BPOINS_ATTRIBUTE_OU | _decimal_10_0 | decimal(10) | Yes | This field holds the ouinstance of attribute component with which blanket purchase order is created. | No |
| BPOINS_STD_MIN_VALUE | _decimal_28_8 | decimal(28) | Yes | This field holds the standard minimum value of blanket purchase order document | No |
| BPOINS_ATTRIBUTE_TYPE | _varchar_5 | varchar(5) | Yes | this field is tocapture the attribute type of blanket purchase order document | No |
| BPOINS_STD_MAX_VALUE | _decimal_28_8 | decimal(28) | Yes | This field holds the standard maximum value of blanket purchase order document | No |
| BPOINS_STD_VALUE | _decimal_28_8 | decimal(28) | Yes | This field holds the standard value of blanket purchase order document | No |
| BPOINS_MINIMUM_VALUE | _decimal_28_8 | decimal(28) | Yes | This field holds the minimum value of blanket purchase order document | No |
| BPOINS_MAXIMUM_VALUE | _decimal_28_8 | decimal(28) | Yes | This field holds the maximum value of blanket purchase order document | No |
| BPOINS_STD_QUAL_VALUE | _varchar_80 | varchar(80) | Yes | This field holds the standard qualitative value | No |
| BPOINS_TRACKABLE | _varchar_5 | varchar(5) | Yes | This field holds when the trackable option is allowed. Allowed values are 1.YES 2.NO | No |
| BPOINS_BPO_UOM | _varchar_20 | varchar(20) | Yes | This field holds the unit of measurement | No |
| BPOINS_INSPECT_REMARKS | _varchar_255 | varchar(255) | Yes | This field holds the inspect remarks of blanket purchase order component | No |
| BPOINS_CREATEDDATE | _datetime_8 | datetime(8) | No | This field holds the created date of the record | No |
| BPOINS_CREATED_BY | _varchar_30 | varchar(30) | No | This field holds the user who created the record | No |
| BPOINS_MODIFIEDDATE | _datetime_8 | datetime(8) | No | This field holds the modified date of the record | No |
| BPOINS_MODIFIED_BY | _varchar_30 | varchar(30) | No | This field holds the user who modified the record | No | |
| Table Name : | BPO_BPOPDT_PART_DTL |
| Comment : | This table is Used to store the Part Level information of the Blanket Purchase Order Dcument with the Line No |
|
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| BPOPDT_BPO_OUINSTANCE | _decimal_10_0 | decimal(10) | No | This field holds the ouinstance in which blanket purchase order document is created | Yes |
| BPOPDT_LINE_NO | _decimal_10_0 | decimal(10) | No | This field holds the part line no of the blanket purchase order | No |
| BPOPDT_BPO_NO | _varchar_40 | varchar(40) | No | This field holds the blanket purchase order number | Yes |
| BPOPDT_PART_NO | _varchar_40 | varchar(40) | No | This field holds the part no associated with the bpo document | No |
| BPOPDT_BPO_LINE_ID | _decimal_10_0 | decimal(10) | No | This field holds the line id of blanket purchase order | Yes |
| BPOPDT_PART_CONDITION | _varchar_5 | varchar(5) | Yes | This field holds the part condition associated with BPO document | No |
| BPOPDT_ORDER_QTY | _decimal_28_8 | decimal(28) | Yes | This field holds the part order quantity for blanket purchase order document | No |
| BPOPDT_BPO_BALANCE_QTY | _decimal_28_8 | decimal(28) | Yes | This field holds the balance quantity of the blanket purchase order | No |
| BPOPDT_BPO_BALANCE_VALUE | _decimal_28_8 | decimal(28) | Yes | This field holds the balance value of the blanket purchase order | No |
| BPOPDT_PART_OU | _decimal_10_0 | decimal(10) | No | This field holds the part admin ouinstance which interacts with the BPO component | No |
| BPOPDT_PURCHASE_UOM | _varchar_10 | varchar(10) | No | This field holds the purchase UOM for the part associated with blanket purchase order document | No |
| BPOPDT_COST | _decimal_28_8 | decimal(28) | Yes | This field holds the cost for the part associated with blanket purchase order document | No |
| BPOPDT_COST_PER | _decimal_28_8 | decimal(28) | Yes | This field holds the cost per for the part associated with blanket purchase order document | No |
| BPOPDT_LINE_ITEM_VALUE | _decimal_28_8 | decimal(28) | Yes | This field holds the line Item amount associated with blanket purchase order document | No |
| BPOPDT_LINE_TCD_AMT | _decimal_28_8 | decimal(28) | Yes | This field holds the line TCD amount associated with blanket purchase order document | No |
| BPOPDT_ALTERNATE_PART_NO | _varchar_5 | varchar(5) | Yes | This field is to capture the alternate part no of blanket purchase order document | No |
| BPOPDT_INSPECTION_TYPE | _varchar_5 | varchar(5) | Yes | This field holds the inspection type of blanket purchase order document | No |
| BPOPDT_MATCHING_TYPE | _varchar_5 | varchar(5) | Yes | This field holds the matching type of blanket purchase order document | No |
| BPOPDT_TOLERANCE_TYPE | _varchar_5 | varchar(5) | Yes | This field holds the tolerance type of blanket purchase order document | No |
| BPOPDT_TOLERANCE_PERC | _decimal_28_8 | decimal(28) | Yes | This field holds the tolerance percentage of blanket purchase order document | No |
| BPOPDT_QUALITY_ATTRIBUTE | _varchar_5 | varchar(5) | Yes | This field holds the quality attribute of blanket purchase order document Allowed values are 1.Y- Yes 2.N-No | No |
| BPOPDT_LINE_REMARKS | _varchar_255 | varchar(255) | Yes | This field is to capture the remarks of the part associated with blanket purchase order | No |
| BPOPDT_ALLOTMENT_MODE | _varchar_5 | varchar(5) | Yes | This field holds the allotment mode of blanket purchse order. 1.Quantity 2.Rate 3.Value | No |
| BPOPDT_CREATEDDATE | _datetime_8 | datetime(8) | Yes | This field holds the created date of the record | No |
| BPOPDT_CREATED_BY | _varchar_30 | varchar(30) | Yes | This field holds the user who created the record | No |
| BPOPDT_MODIFIEDDATE | _datetime_8 | datetime(8) | Yes | This field holds the modified date of the record | No |
| BPOPDT_MODIFIED_BY | _varchar_30 | varchar(30) | Yes | This field holds the user who modified the record. | No |
| BPOPDT_RCPT_POS_TOL | _decimal_28_8 | decimal(28) | Yes | 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 |
| BPOPDT_RCPT_NEG_TOL | _decimal_28_8 | decimal(28) | Yes | 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 | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| BPOPRM_COMPONENTNAME | _varchar_20 | varchar(20) | No | This field holds the Name of the component. | Yes |
| BPOPRM_PARAMCATEGORY | _varchar_10 | varchar(10) | No | 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 |
| BPOPRM_PARAMTYPE | _varchar_25 | Varchar(25) | No | 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 |
| BPOPRM_PARAMCODE | _varchar_5 | varchar(5) | No | 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 |
| BPOPRM_LANGID | _decimal_10_0 | decimal(10) | No | This fields holds the language id. This is the language id of the record. | Yes |
| BPOPRM_PARAMDESC | _varchar_80 | varchar(80) | Yes | 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 |
| BPOPRM_SORTBY | _decimal_10_0 | decimal(10) | Yes | This field holds the default sort by code | No |
| BPOPRM_CREATEDDATE | _datetime_8 | datetime(8) | Yes | This field holds the record created date for auditing purpose. | No | |
| Table Name : | BPO_BPOROD_REF_OBJ_DTL |
| Comment : | This tables stores the specify document references that are applicable for the BPO |
|
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| BPOROD_CREATED_OUINSTANCE | _decimal_38_0 | decimal(38) | No | This field holds the Organisation unit of the create BPO document | Yes |
| BPOROD_BPO_NO | _varchar_40 | varchar(40) | No | This field holds the generated BPO number | Yes |
| BPOROD_DOC_LINE_ID | _decimal_38_0 | decimal(38) | No | This field holds the line number of the part information | Yes |
| BPOROD_REF_DOC_TYPE | _varchar_25 | Varchar(25) | Yes | 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 |
| BPOROD_REF_DOC_ID | _varchar_40 | varchar(40) | Yes | This field stores the number that identifies the reference document | No |
| BPOROD_REF_DOC_FILE_NAME | _varchar_50 | varchar(50) | Yes | This field holds the file name of the reference document | No |
| BPOROD_CREATED_DATE | _datetime_8 | datetime(8) | Yes | This field holds the created date of Reference document to a BPO | No |
| BPOROD_CREATED_BY | _varchar_30 | varchar(30) | No | This field holds the created user of Reference document to a BPO | No |
| BPOROD_MODIFIED_DATE | _datetime_8 | datetime(8) | Yes | This field holds the modified date of Reference document to a BPO | No |
| BPOROD_MODIFIED_BY | _varchar_30 | varchar(30) | No | This field holds the modified user of Reference document to a BPO | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| BPOSOPT_OUINSTANCE | _decimal_38_0 | decimal(38) | Yes | This fields holds the OUInstance where the set option record is created | No |
| BPOSOPT_MULTIPRTTYP_ALLOW | _varchar_5 | varchar(5) | Yes | This fields holds the flag whether Multple Part types are allowed or not. Y - Yes N - No | No |
| BPOSOPT_DEF_RCPT_TOL | _varchar_5 | varchar(5) | Yes | 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 |
| BPOSOPT_CREATED_DATE | _datetime_8 | datetime(8) | Yes | This fields holds the created date of the record | No |
| BPOSOPT_CREATED_BY | udd_ctxt_user | varchar(30) | Yes | This fields holds the username who created the record | No |
| BPOSOPT_MODIFIED_DATE | _datetime_8 | datetime(8) | Yes | This fields holds the modified date of the record | No |
| BPOSOPT_MODIFIED_BY | udd_ctxt_user | varchar(30) | Yes | This fields holds the username who modified the record | No |
| BPOSOPT_TIMESTAMP | _decimal_38_0 | decimal(38) | Yes | This fields holds the timestamp of the record | No |
| REPLICATION_KEY | _bigint_8 | Bigint(8) | No | Unique Number | Yes | |
| Table Name : | BPO_BPOTC_TERMS_CONDNS |
| Comment : | Used to store the Terms and Condition Information of the BPO Document (ie, Pay To supplier, Payterm ) |
|
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| BPOTC_BPO_OUINSTANCE | _decimal_10_0 | decimal(10) | No | This field holds the ouinstance in which blanket purchase order is created | Yes |
| BPOTC_BPO_NO | _varchar_40 | varchar(40) | No | The field holds the blanket purchase order number | Yes |
| BPOTC_PAY_TERM_OU | _decimal_10_0 | decimal(10) | Yes | This field holds the ouinstance of payterm component with which BPO is interacting | No |
| BPOTC_PAY_TERM_CODE | _varchar_25 | Varchar(25) | Yes | This field holds the pay term code of the blanket purchase order document | No |
| BPOTC_PAYMENT_MODE | _varchar_5 | varchar(5) | No | This field holds the payment mode of the blanket purchase order document | No |
| BPOTC_PAY_TO_SUPPLIER_NO | _varchar_45 | varchar(45) | No | This field holds the pay to supplier number of blanket purchase order document | No |
| BPOTC_INSUR_TERMS | _varchar_150 | varchar(150) | Yes | This field holds the insurance terms of the blanket purchase order document | No |
| BPOTC_INSUR_LIABILITY | _varchar_5 | varchar(5) | Yes | This field holds the insurance liability of blanket purchase order document | No |
| BPOTC_INSUR_AMOUNT | _decimal_28_8 | decimal(28) | Yes | This field holds the insurance amount of blanket purchase order document | No |
| BPOTC_INCO_TERM | _varchar_150 | varchar(150) | Yes | This field holds the INCO term of blanket purchase order document. | No |
| BPOTC_MODE_OF_TRANSPORT | _varchar_150 | varchar(150) | Yes | This field holds the mode of transport of blanket purchase order document | No |
| BPOTC_DELIVERY_POINT | _varchar_255 | varchar(255) | Yes | This field holds the delivery point of the blanket purchase order document | No |
| BPOTC_TRANSSHIPMENT | _varchar_5 | varchar(5) | Yes | This field holds the transhipment of blanket purchase order document | No |
| BPOTC_PACKAGING_TERMS | _varchar_150 | varchar(150) | Yes | This field holds the packaging terms of blanket purchase order document. | No |
| BPOTC_SHIP_PARTIAL | _varchar_5 | varchar(5) | Yes | This field holds the ship partial of blanket purchase order document | No |
| BPOTC_TERM_CONDN_REMARKS | _varchar_255 | varchar(255) | Yes | This field holds the the Terms and condition remarks of the BPO document | No |
| BPOTC_CREATEDDATE | _datetime_8 | datetime(8) | No | This field holds the created date of the record | No |
| BPOTC_CREATED_BY | _varchar_30 | varchar(30) | No | This field holds the user who created the record | No |
| BPOTC_MODIFIEDDATE | _datetime_8 | datetime(8) | No | This field holds the modified date of the record | No |
| BPOTC_MODIFIED_BY | _varchar_30 | varchar(30) | No | This field holds the user who modified the record | No |
| BPOTC_ADV_PAYABLE | _varchar_5 | varchar(5) | Yes | This field holds the flag whether advance is payable or not. Y - yes N - No | No |
| BPOTC_ADV_PAY_BYDATE | _datetime_8 | datetime(8) | Yes | This field holds the date by which advance is payable | No |
| BPOTC_ADV_PERCENT | _decimal_28_8 | decimal(28) | Yes | This field holds the value of advance percentage | No |
| BPOTC_ADV_PER_ON | _varchar_5 | varchar(5) | Yes | This field holds 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 |
| BPOTC_ADV_PAYABLE_VAL | _decimal_28_8 | decimal(28) | Yes | This field holds the advance payable value | No |
| BPOTC_ADV_TOL_PERC | _decimal_28_8 | decimal(28) | Yes | This field holds the advance tolerance percentage | No |
| BPOTC_PAYMENT_PRIORITY | _varchar_5 | varchar(5) | Yes | This field holds the flag for payment priority H - High N - Normal L - Low | No |
| BPOTC_PAY_MODE | _varchar_5 | varchar(5) | Yes | This field holds the flag for the payment mode CS - Cash CQ - Cheque DD - Demand Draft P - Pay Order | No |
| BPOTC_DDCHRGS_BORNEBY | _varchar_5 | varchar(5) | Yes | This field holds the flag which identifies that the DD charges will be borne by whom B- blank SF - Self RS - Supplier | No |
| BPOTC_PAYTO_SUPP_ADDRID | _decimal_38_0 | decimal(38) | Yes | This field holds the pay to supplier s address id. | No |
| BPOTC_PAYMENT_NOTES | _varchar_2000 | varchar(2000) | Yes | This field holds the payment notes of the BPO document | No |
| BPOTC_WARRANTY | _varchar_5 | varchar(5) | Yes | This field holds the flag whether warranty is yes or no Y- Yes N - No B - Blank | No |
| BPOTC_WARRANTY_BASIS | _varchar_5 | varchar(5) | Yes | This field holds the flag to indicate the warranty basis C- Calendar U - Usage BH - Both B - Blank | No |
| BPOTC_WARR_AGRMT_NO | _varchar_40 | varchar(40) | Yes | This field holds the warrany agreement number | No |
| BPOTC_PACKAGING_CODE | _varchar_25 | Varchar(25) | Yes | This field holds the packaging code | No |
| BPOTC_PACKAGING_NOTES | _varchar_2000 | varchar(2000) | Yes | This field holds thepackaging notes | No |
| BPOTC_PORT_OF_DEPARTURE | _varchar_32 | varchar(32) | Yes | This field holds the port of departure | No |
| BPOTC_CARRIER_AGENCY_NO | _varchar_20 | varchar(20) | Yes | This field holds the carrier/agency number | No |
| BPOTC_SHIPPING_PAYMENT | _varchar_25 | Varchar(25) | Yes | This field holds the payment method defined in logistics common master | No |
| BPOTC_SHIPPING_NOTES | _varchar_2000 | varchar(2000) | Yes | This field holds the shipping notes | No |
| BPOTC_GTA_REFNO | _varchar_40 | varchar(40) | Yes | This field holds the General terms and agreement reference number | No |
| BPOTC_REF_DOC_DATE | _datetime_8 | datetime(8) | Yes | This field holds the reference document date | No |
| BPOTC_GTA_REMARKS | _varchar_255 | varchar(255) | Yes | This field holds the General terms and agreement Remarks | No |
| BPOTC_PAY_TO_SUPPLIER_OU | _decimal_38_0 | decimal(38) | Yes | This field holds the OUinstance of the Supplier to whom payment has to be made | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| BPOUI_BPO_OUINSTANCE | _decimal_38_0 | decimal(38) | No | This fields holds the ouinstance in which blanket purchase order document is created | Yes |
| BPOUI_BPO_NO | _varchar_40 | varchar(40) | No | This field holds the blanket purchase order number | Yes |
| BPOUI_USER_DEF_DESC1 | _varchar_30 | varchar(30) | Yes | This field holds the first description of user defined options. | No |
| BPOUI_USER_DEF_OPT1 | _varchar_30 | varchar(30) | Yes | This field holds the first user defined option | No |
| BPOUI_USER_DEF_DESC2 | _varchar_30 | varchar(30) | Yes | This field holds the second description of user defined options. | No |
| BPOUI_USER_DEF_OPT2 | _varchar_30 | varchar(30) | Yes | This field holds the second user defined option | No |
| BPOUI_USER_DEF_DESC3 | _varchar_30 | varchar(30) | Yes | This field holds the third description of user defined options. | No |
| BPOUI_USER_DEF_OPT3 | _varchar_30 | varchar(30) | Yes | This field holds the third user defined option | No |
| BPOUI_USER_DEF_DESC4 | _varchar_30 | varchar(30) | Yes | This field holds the fourth description of user defined options. | No |
| BPOUI_USER_DEF_OPT4 | _varchar_30 | varchar(30) | Yes | This field holds the fourth user defined option | No |
| BPOUI_USER_DEF_REMARKS | _varchar_255 | varchar(255) | Yes | This field holds the user defined remarks | No |
| BPOUI_CREATED_DATE | _datetime_8 | datetime(8) | No | This field holds the created date of the record | No |
| BPOUI_CREATED_BY | _varchar_30 | varchar(30) | No | This field holds the user who created the record | No |
| BPOUI_MODIFIED_DATE | _datetime_8 | datetime(8) | No | This field holds the modified date of the record | No |
| BPOUI_MODIFIED_BY | _varchar_30 | varchar(30) | No | This field holds the user who modified the record | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| BPTCD_BPO_OUINSTANCE | _decimal_10_0 | decimal(10) | No | This field holds the ouinstance in which blanket purchase order is created | Yes |
| BPTCD_TCD_CODE | _varchar_25 | Varchar(25) | No | This field holds the Tcd Code for the current Tcd Line id. | No |
| BPTCD_BPO_NO | _varchar_40 | varchar(40) | No | This field holds the blanket purchase order No. | Yes |
| BPTCD_TCD_VARIANT_CODE | _varchar_25 | Varchar(25) | No | This field holds the Tcd Variant for the current Tcd Line id. | No |
| BPTCD_BPO_LINE_ID | _decimal_10_0 | decimal(10) | No | This field holds the blanket purchase order Part Line Id (Running No) | Yes |
| BPTCD_TCD_LINE_ID | _decimal_10_0 | decimal(10) | No | This field holds the blanket purchase order Part Tcd Line Id (Running No). | Yes |
| BPTCD_TCD_OU | _decimal_10_0 | decimal(10) | No | This field holds the Tcd Code Created OUInstance. | No |
| BPTCD_TCD_RATE | _decimal_28_8 | decimal(28) | Yes | This field holds the Rate for the Tcd Code of the current Tcd Line Id. | No |
| BPTCD_TCD_AMOUNT | _decimal_28_8 | decimal(28) | Yes | This field holds the total amount the Tcd Code of the current Tcd Line Id. | No |
| BPTCD_CREATEDDATE | _datetime_8 | datetime(8) | No | This field holds the created date of the record | No |
| BPTCD_CREATED_BY | _varchar_30 | varchar(30) | No | This field holds the created user of the record | No |
| BPTCD_MODIFIEDDATE | _datetime_8 | datetime(8) | No | This field holds the Last Modified Date of the record. | No |
| BPTCD_MODIFIED_BY | _varchar_30 | varchar(30) | No | This field holds the Last Modified User of the record. | No |
| BPTCD_USER_SEQ_NO | _decimal_38_0 | decimal(38) | Yes | This field holds the user entered sequence number for the TCD code | No |
| BPTCD_CURRENCY | _varchar_20 | varchar(20) | Yes | The field holds the currency chosen in the multiline | No |
| BPTCD_EXCHG_RATE | _decimal_28_8 | decimal(28) | Yes | The field holds the exchage rate between the document currency and the payment currency | No |