Purchase Order

BasPO

Table Name PO_ADTcdAP_DocTcd_Apportioned

Table Comment This table holds the Document TCD Apportioning details of Amended purchase order
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
ADTcdAP_PartlineId	int	NOT NULL	This field holds the Unique identifier for each item requested in the PO	No	No
ADTcdAP_DTcdlineid	int	NOT NULL	This field holds the Unique identifier for each item’s TCD Line ID requested in the PO	No	No
ADTcdAP_tcdamount_bas	decimal(28,8)	NULL	This field holds Tcd amount that will be calculated from the TCD component for the TCD code ,variant TCD rate,Base currency supplied.	No	No
ADTcdAP_tcdamount_par	decimal(28,8)	NULL	This field holds Tcd amount that will be calculated from the TCD component for the TCD code ,variant TCD rate, Parallel currency supplied.	No	No
ADTcdAP_ApportVal_Bas	decimal(28,8)	NULL	This field holds Apportioning Tcd amount that will be calculated from the TCD component for the TCD code ,variant TCD rate,Base currency supplied.	No	No
ADTcdAP_ApportVal_Par	decimal(28,8)	NULL	This field holds Apportioning Tcd amount that will be calculated from the TCD component for the TCD code ,variant &nbspTCD rate,Parellel currency &nbspsupplied.	No	No
ADTcdAP_Accrule	char	NULL	This field holds the Code of Accounting rule 1.ATS - Add to Stock 2. E - Expense	No	No
ADTcdAP_Recover_Bas	decimal(28,8)	NULL	The amount Recovered through TCD in base currency ( i.e if discount is tcd and wat is accrual amount we recovered through that tcd)	No	No
ADTcdAP_Recover_Par	decimal(28,8)	NULL	The amount Recovered through TCD in parallel base currency ( i.e if discount is tcd and wat is accrual amount	No	No
ADTcdAP_NonRecover_Bas	decimal(28,8)	NULL	The amount which not Recovered through TCD in base currency ( i.e &nbspif discount is tcd and wat is accrual amount )	No	No
ADTcdAP_NonRecover_Par	decimal(28,8)	NULL	The amount which not Recovered through TCD in parallel base currency ( i.e if discount is tcd and wat is accrual amount )	No	No
ADTCDAP_TCDAMOUNT_TRN	decimal(28,8)	NULL	TCD amount in Transaction	No	No
ADTCDAP_APPORTVAL_TRN	decimal(28,8)	NULL	Approved TCD amount in Transaction	No	No
ADTCDAP_NONRECOVER_TRN	decimal(28,8)	NULL	Non - recover TCD amount in Transaction	No	No
ADTCDAP_RECOVER_TRN	decimal(28,8)	NULL	Recover TCD amount in Transaction	No	No
ADTcdAP_PO_No	varchar	NULL	This field holds the Purchase order number	No	No
ADTcdAP_PO_Ou	decimal(10)	NULL	This field holds the ou instance in which the Document level TCD &nbspof the PO have been created	No	No
ADTcdAP_TCD_CODE	varchar(30)	NOT NULL	This field holds the Unique identifier for the TCD	No	No
ADTcdAP_TCD_VARIANT	sql_variant	NULL	This field holds the TCD variant for the TCD code.	No	No
AdtcdAP_TCD_Diff	decimal(28,8)	NULL	This field holds the difference amount of TCD after amendment for doing postings	No	No
AdTcdAP_Amend_No	int	NULL	This field holds the purchase order amendment number.	No	No

Table Name PO_DTcdAP_DocTcd_Apportioned

Table Comment This table holds the Document TCD Apportioning details of purchase order
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
DTcdAP_PartlineId	int	NOT NULL	This field holds the Unique identifier for each item requested in the PO	No	No
DTcdAP_DTcdlineid	int	NOT NULL	This field holds the Unique identifier for each item’s TCD Line ID requested in the PO	No	No
DTcdAP_tcdamount_bas	bigint	NULL	This field holds Tcd amount that will be calculated from the TCD component for the TCD code ,variant TCD rate,Base currency &nbspsupplied.	No	No
DTcdAP_tcdamount_par	bigint	NULL	This field holds Tcd amount that will be calculated from the TCD component for the TCD code ,variant TCD rate, Parallel currency &nbspsupplied.	No	No
DTcdAP_ApportVal_Bas	bigint	NULL	This field holds Apportioning Tcd amount that will be calculated from the TCD component for the TCD code ,variant TCD rate,Base currency &nbspsupplied.	No	No
DTcdAP_ApportVal_Par	bigint	NULL	This field holds Apportioning Tcd amount that will be calculated from the TCD component for the TCD code ,variant TCD rate,Parellel currency &nbspsupplied.	No	No
DTcdAP_Accrule	char()	NULL	This field holds the Code of Accounting rule 1.ATS - Add to Stock 2. E - Expense	No	No
DTcdAP_Recover_Bas	bigint	NULL	This field holds the Code of Accounting rule 1.ATS - Add to Stock 2. E - Expense	No	No
DTcdAP_Recover_Par	bigint	NULL	This field holds the Code of Accounting rule 1.ATS - Add to Stock 2. E - Expense	No	No
DTcdAP_NonRecover_Bas	bigint	NULL	This field holds the Code of Accounting rule 1.ATS - Add to Stock 2. E - Expense	No	No
DTcdAP_NonRecover_Par	bigint	NULL	This field holds the Code of Accounting rule 1.ATS - Add to Stock 2. E - Expense	No	No
DTCDAP_TCDAMOUNT_TRN	bigint	NULL	This field holds the Code of Accounting rule 1.ATS - Add to Stock 2. E - Expense	No	No
DTCDAP_APPORTVAL_TRN	bigint	NULL	This field holds the Code of Accounting rule 1.ATS - Add to Stock 2. E - Expense	No	No
DTCDAP_NONRECOVER_TRN	bigint	NULL	This field holds the Code of Accounting rule 1.ATS - Add to Stock 2. E - Expense	No	No
DTCDAP_RECOVER_TRN	bigint	NULL	This field holds the Code of Accounting rule 1.ATS - Add to Stock 2. E - Expense	No	No
DTcdAP_PO_No	sql_variant	NULL	This field holds the Purchase order number	No	No
DTcdAP_PO_Ou	int	NULL	This field holds the ou instance in which the Document level TCD of the PO have been created	No	No
DTcdAP_TCD_CODE	sql_variant	NOT NULL	This field holds the Unique identifier for the TCD	No	No
DTcdAP_TCD_VARIANT	sql_variant	NULL	This field holds the TCD variant for the TCD code.	No	No
DtcdAP_TCD_Diff	bigint	NULL	This field holds the TCD variant for the TCD code.	No	No
DTcdAP_Amend_No	int	NULL	This field holds the purchase order amendment number.	No	No

Table Name po_poadsd_drop_ship_dtl

Table Comment This table holds the Dropship details of &nbspamended purchase order document
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
poadsd_country	varchar(40)	NULL	This field holds the country of the company for shipment	No	No
poadsd_contact_person	varchar(80)	NULL	This field holds the contact person of the company for shipment	No	No
poadsd_state	varchar(32)	NULL	This field holds the state of the company for shipment	No	No
poadsd_zip_code	varchar(15)	NULL	This field holds the zip code of the company for shipment	No	No
poadsd_ship_all_itm	varchar(5)	NULL	This field holds the flag whether Ship All Items to the same Location or not the values may be YES or NO	No	No
poadsd_phone_no	varchar(70)	NULL	This field holds the phone no of the company for shipment	No	No
poadsd_email	varchar(70)	NULL	This field holds the email id of the company for shipment	No	No
poadsd_fax_no	varchar(70)	NULL	This field holds the fax details of the company for shipment	No	No
poadsd_remarks	varchar(255)	NULL	This field holds the remarks of the shipment	No	No
poadsd_amend_no	numeric(10)	NOT NULL	This field captures the amendment no of the PO documents.	Yes	Yes
poadsd_line_no	numeric(10)	NOT NULL	Each item (record) requested in the purchase Order is associated with this key .	Yes	Yes
poadsd_po_no	varchar(40)	NOT NULL	This field captures the Purchase order number.	Yes	Yes
poadsd_ouinstance	decimal(10)	NOT NULL	This field holds the ou instance in which the drop ship details for the line item of the PO have been created	Yes	Yes
poadsd_city	varchar(32)	NULL	This field holds the city of the company for shipment	No	No
poadsd_addr_3	varchar(255)	NULL	This field holds the company address for the shipment	No	No
poadsd_comp_name	varchar(150)	NULL	This field holds the company name for the shipment	No	No
poadsd_addr_2	varchar(255)	NULL	This field holds the company address for the shipment	No	No
poadsd_addr_1	varchar(255)	NULL	This field holds the company address for the shipment	No	No

Table Name po_poadtcd_po_doc_tcd

Table Comment This table holds the Document TCD details of Amended purchase order.
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
poadtcd_created_by	varchar(30)	NULL	This field holds the user who created the PO Doc TCD	No	No
poadtcd_modifieddate	datetime	NULL	This field holds the date when the PO Doc TCD is modified in the system	No	No
poadtcd_createddate	datetime	NULL	This field holds the date when the PO Doc TCD is created in the system	No	No
poadtcd_pay_to_supp	varchar(45)	NULL	A valid supplier defined in the Supplier component and mapped to the Supplier (who supplies the goods requested )as pay to supplier ( to whom the payment can be made)	No	No
poadtcd_user_seqno	numeric(10)	NULL	holds the sequence number entered for the TCD by the user	No	No
poadtcd_modified_by	varchar(30)	NULL	This field holds the user who modified the PO Doc TCD	No	No
POADTCD_CURRENCY	varchar(20)	NULL	This field holds the Transaction currency	No	No
poadtcd_tcd_ou	numeric(10)	NULL	This field holds the tcd ou instance	No	No
poadtcd_exchg_rate	numeric(28,8)	NULL	Holds the exchange rate between the document currency and the payment currency	No	No
poadtcd_po_no	varchar(40)	NOT NULL	This field holds the Purchase order number	Yes	Yes
poadtcd_amend_no	numeric(10)	NOT NULL	This field holds the purchase order amendment number.	Yes	Yes
poadtcd_ouinstance	decimal(10)	NOT NULL	This field holds the ou instance in which the Document level TCD of the PO have been created	Yes	Yes
poadtcd_tcd_amount	decimal(28,8)	NULL	The Tcd amount that will be calculated from the TCD component for the TCD code and the variant and the TCD rate supplied.	No	No
poadtcd_tcd_rate	decimal(28,8)		TCD rate for the TCD code and the variant . this should not be changed for TCD basis -- Percentage.	No	No
poadtcd_serial_no	numeric(10)	NOT NULL	This field holds the Unique identifier number for the TCD of the PO.	Yes	No
poadtcd_tcd_variant	varchar(25)	NOT NULL	This field holds the TCD variant for the TCD code.	No	No
poadtcd_tcd_code	varchar(25)	NOT NULL	This field holds the Unique identifier for the TCD	No	No

Table Name po_poahdr_po_header

Table Comment This table holds the Amended purchase order document details
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
poahdr_ouinstance	decimal(10)	NOT NULL	This field holds the Purchase order created ou instance	Yes	Yes
poahdr_po_no	varchar(40)	NOT NULL	This field holds the Purchase order number	Yes	Yes
poahdr_amend_no	numeric(10)	NOT NULL	This field holds the purchase order amendment number.	Yes	No
poahdr_po_date	datetime	NOT NULL	This field holds the Purchase order creation date .	No	No
poahdr_po_status	varchar(5)	NOT NULL	This field holds the various PO statuses maintained are (F)resh -- Before authorization and if the schedule quantity and the order quantity are equal. (D)raft - before authorization , when the schedule quantity and the order quantity are not equal. (O)pen - Authorized (U)nder Authorization (A)mended --after authorization ,any changes made and &nbspwhen the schedule quantity and the order quantity are equal. (H)eld -- temporarily PO is stopped. (S)hortclose -- Permanently PO is stopped. (CA)ncelled (Cl)osed -- all the goods requested in PO have been delivered &nbspfrom the supplier(either equal to or more than the ordered quantity but within the tolerance &nbsplimit). (NT)closed (P) Under Amendment (B)lank (R)evised (RET)urn	No	No
poahdr_po_type	varchar(5)	NULL	This field holds the Po Types Following are the Po Types 1. (G)eneral 2. (D)ropShip 3. (S)ample -- Cost is not mandatory as it can be a sample item from the supplier 4. (E)xpress -- Supplier to Part mapping is not mandatory 5.(CONSI)gnment 6.(EXCHG) --- Exchange 7.(PBH) 8.(PBHEX)change 9.(B)lank 10. (Ser)vice 11. (Adh)oc 12.(C)ustomer (G)oods	No	No
poahdr_supp_code	varchar(45)	NULL	This field holds the Supplier code from the supplier component who has raise the purchase order.	No	No
poahdr_supplier_ou	numeric(10)	NULL	This field holds the Supplier OU instance from the supplier component	No	No
poahdr_supp_created_ou	numeric(10)	NULL	This field holds the Supplier OU instance from the supplier component where the supplier code is created.	No	No
poahdr_quotationno	varchar(40)	NULL	It is the Quotation # (from the RFQ component) for which the po is created.	No	No
poahdr_quot_amend_no	varchar(40)	NULL	It is the latest quotation amendment no.	No	No
poahdr_quotationou	numeric(10)	NULL	This field holds the Quotation created ou.	No	No
POAHDR_SUPPLIEROFFNO	varchar(40)	NULL	This field holds the supplier reference quotation no	No	No
poahdr_amendmentrefno	varchar(40)	NULL	Supplier reference amendment no	No	No
poahdr_remarks	varchar(255)	NULL	This field holds the remarks	No	No
poahdr_part_type	varchar(5)	NULL	This field holds the Part type. The Part types maintained are 1) Tool (Tool) 2) Component ( Cmpnt ) 3) Consumable (Cnsmb) 4) Kit (Kit) 5) Spare Part (Sprpt) 6) Raw Material (Rwmtr)	No	No
poahdr_po_cat	varchar(25)	NULL	This field holds the Po Category - All active quick codes under quick code type Category	No	No
poahdr_user_status	varchar(25)	NULL	This field holds the User status - All active quick codes under quick code type User Status	No	No
poahdr_po_currency	varchar(20)	NULL	This field holds any one of the Currency mapped to the supplier.	No	No
poahdr_total_basic_val	decimal(28,8)	NULL	This field holds the PO basic value. PO basic value= sum of all basic value of line #. (Basic value of a line #= Order qty multiplied by (cost divided by cost per )which is stored in the item details table)	No	No
poahdr_total_tcd_POval	decimal(28,8)	NULL	This field holds the TCD Total Amount ( Doc Level). TCD Total Amount = sum of all tcd amount of the document	No	No
poahdr_total_tcd_partval	decimal(28,8)	NULL	This field holds the TCD Total Amount ( part Level). part level TCD Total Amount = sum of all Po line # (item level)	No	No
poahdr_addln_charges	decimal(28,8)	NULL	This field holds the additional charges of the PO document Add ln charges = TCD Total amount for all Po line # (item level) + TCD Total Amount ( Doc Level)	No	No
poahdr_total_value	decimal(28,8)	NULL	This field holds the Po total value . Po total value =PO Basic Value + Addln charges	No	No
poahdr_exchange_rate	decimal(28,8)	NULL	This field holds the TCD Total amount for all Po line # (item level)	No	No
poahdr_basic_currency_val	decimal(28,8)	NULL	This field holds the exchange rate for the PO currency to Base currency from the Exchange rate component	No	No
poahdr_reason	varchar(2000)	NULL	This field holds the Reason for why this status change have been made.	No	No
poahdr_buyer_group	varchar(25)	NULL	This field holds the buyer group of the Login user from the Buyer group component.	No	No
poahdr_buygrp_ou	numeric(10)	NULL	This field holds the buyer group OU instance of the Login user from the Buyer group component.	No	No
poahdr_createddate	datetime	NULL	This field holds the date when the PO is created in the system	No	No
poahdr_auth_terlevel	varchar(25)	NULL	This field holds Level Applicable for the PO Total value	No	No
poahdr_created_by	varchar(30)	NULL	This field holds the user who created the PO	No	No
poahdr_auth_minval	decimal(28,8)	NULL	This field holds the Min Value for the given level /PC	No	No
poahdr_modifieddate	datetime	NULL	This field holds the date when the PO is modified in the system	No	No
poahdr_auth_maxval	decimal(28,8)	NULL	This field holds Max Value for the given level /PC	No	No
poahdr_modified_by	varchar(30)	NULL	This field holds the user who modified the PO	No	No
poahdr_auth_nxtlvlpc	varchar(25)	NULL	This field holds the Next Level / PC to be Authorized.	No	No
poahdr_approveddate	datetime	NULL	This field captures the date when the PO is approved in the system	No	No
poahdr_auth_type	varchar(5)	NULL	This field holds the Next level Authorization type [Lvl OR PC]	No	No
poahdr_approved_by	varchar(30)	NULL	This field captures the user who approved the PO	No	No
poahdr_auth_stage	varchar(25)	NULL	This field holds the PO Dynamic status	No	No
poahdr_amendmentdate	datetime	NULL	This field captures the date when the PO is amended in the system	No	No
poahdr_amendment_by	varchar(30)	NULL	This field captures the user who amended the PO	No	No
poahdr_timestamp	numeric(10)	NULL	This field captures the integer value which identifies if any change has been made to the record. -- the first time the PO is created , the timestamp value is 1, -- the next time any change is made to the record ,increment it by 1.	No	No
poahdr_authorised_by	varchar(30)	NULL	This field captures the user who authorised the PO	No	No
poahdr_authoriseddate	datetime	NULL	This field captures the date when the PO is authorised in the system	No	No
poahdr_ac_regn_no	varchar(30)	NULL	This field holds the aircraft registration number	No	No
poahdr_priority	varchar(20)	NULL	This field holds the PO Priority Following are the PO Priority 1.(A)OG 2.(C)ritical 3.(E)xpedite 4.(R)outine	No	No
poahdr_quality_flg	varchar(5)	NULL	This fields holds the Quality Flag The List of values are 1.(Y)es 2.(N)o	No	No
poahdr_num_type_no	varchar(5)	NULL	stores the numbering type no of the purchase order defined in document numbering class	No	No
poahdr_wf_doc_key	varchar(128)	NULL	stores the document key used for work flow purpose	No	No
poahdr_po_core_status	varchar(5)	NULL	This field holds the Purchase Order Core Status - ’Open’, ’Core Due’, ’Rcpt Due’ or ’Closed’	No	No
poahdr_issue_doc_ou	numeric(10,0)	NULL	OUInstance of Issue Document which is updating the core status - applicable for PO Types - Exchange and PBH-Exchange	No	No
poahdr_issue_doc_no	varchar(40)	NULL	Issue Document Number which is updating the core status - applicable for PO Types - Exchange and PBH-Exchange	No	No
poahdr_gr_doc_ou	numeric(10,0)	NULL	OUInstance of Goods Receipt Document which is updating the core status - applicable for PO Types - Exchange and PBH-Exchange	No	No
poahdr_gr_doc_no	varchar(40)	NULL	Goods Receipt Number which is updating the core status - applicable for PO Types - Exchange and PBH-Exchange	No	No
POAHDR_COMPONENT_OU	numeric(10)	NULL	This field holds the PBH Component OU	No	No
POAHDR_COMPONENT_ID	varchar(90)	NULL	This field holds the PBH Component ID	No	No
POAHDR_EXP_TYPE	varchar(5)	NULL	This field holds the PO Expense type of following values 1. C - Capital 2.R - Revenue	No	No
POAHDR_RCP_RCD_OPT	varchar(5)	NULL	This field hold the Receipt Recording option of PO document, Possible values are 1. NOGR - No GR 2 GRMOV- GR Movement 3.GRACC - GR Acceptance	No	No
POAHDR_WARRCLAIM_APP	char(5)	NULL	To save the Warranty applicable "Yes" or "No" from the PO header details	No	No
POAHDR_WARRCLAIM_NO	varchar(40)	NULL	To save the Warranty claim # entered by the user	No	No
POAHDR_REFAGREE_NO	varchar(40)	NULL	To save the Reference agreement # entered by the user	No	No
POAHDR_REFAGREE_DATE	datetime	NULL	To save the Reference agreement date entered by the user	No	No
POAHDR_CLAIM_REMARKS	varchar(255)	NULL	To save the Claim remarks entered by the user	No	No
POAHDR_PUR_UNIT	sql_variant	NULL	To populate the combo ’Purchasing Unit’ with all the Posting Finance Book codes available for the Company and are mapped to the Login OU.	No	No
POAHDR_PUR_REMARKS	sql_variant	NULL	To capture the Purchase Remarks at PO document level	No	No

Table Name po_poains_po_inspection_det

Table Comment This table holds the item Inspection details of Amended purchase order document
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
poains_std_qual_value	varchar(80)	NULL	This field holds the standard qualitative value	No	No
poains_trackable_flag	varchar(5)	NULL	This field is set when the trackable option is allowed. Allowed values are 1.YES 2.NO	No	No
poains_std_max_value	numeric(28,8)	NULL	This field holds the standard maximum value	No	No
poains_std_min_value	numeric(28,8)	NULL	This field holds the standard minimum value	No	No
poains_std_value	numeric(28,8)	NULL	This field holds the standard value	No	No
poains_created_by	varchar(30)	NULL	This field holds the user who created the PO inspection detail	No	No
poains_modifieddate	datetime	NULL	This field captures the date when the PO inspection detail is modified in the system	No	No
poains_inspection_remarks	varchar(255)	NULL	This field holds the inspection remarks for each line item	No	No
poains_createddate	datetime	NULL	This field holds the date when the PO inspection detail is created in the system	No	No
poains_uom	varchar(10)	NULL	This field holds the unit of measurement	No	No
poains_modified_by	varchar(30)	NULL	This field captures the user who modified the PO inspection detail	No	No
poains_amend_no	numeric(10)	NOT NULL	This field holds the amendment no of the PO documents.	Yes	Yes
poains_line_no	numeric(10)	NOT NULL	Each item (record) requested in the purchase Order is associated with this key .	Yes	Yes
poains_po_no	varchar(40)	NOT NULL	This field holds the Purchase order number.	Yes	Yes
poains_ouinstance	decimal(10)	NOT NULL	This field holds the ou instance in which the Inspection details for the line item of the PO have been created	Yes	Yes
poains_minimum_value	numeric(28,8)	NULL	This field holds the minimum value of the attribute.	No	No
poains_attribute_type	varchar(5)	NULL	This field holds the attribute type	No	No
poains_maximum_value	numeric(28,8)	NULL	This field holds the maximum value of the attribute.	No	No
poains_po_attribute_id	varchar(40)	NOT NULL	This field holds the unique identifying running no	Yes	No
poains_attribute_code	varchar(10)	NULL	This field holds the attribute code for the part from the part admin component.	No	No
poains_attribute_ou	numeric(10)	NULL	This filed holds the attribute created ou	No	No

Table Name po_poaitcd_po_item_tcd

Table Comment This table holds the Part TCD details of Amended purchase order document
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
poaitcd_created_by	varchar(30)	NULL	This field holds the user who created the PO part level TCD	No	No
poaitcd_modifieddate	datetime	NULL	This field holds the date when the PO Part level TCD is modified in the system	No	No
poaitcd_createddate	datetime	NULL	This field holds the date when the PO Part level TCD is created in the system	No	No
poaitcd_tcd_amount	decimal(28,8)	NULL	The Tcd amount that will be calculated from the TCD component for the TCD code and the variant and the TCD rate supplied	No	No
poaitcd_exchg_rate	numeric(28,8)	NULL	Holds the exchange rate between the document currency and the payment currency	No	No
poaitcd_modified_by	varchar(30)	NULL	This field holds the user who modified the PO part level TCD	No	No
poaitcd_user_seqno	numeric(10)	NULL	holds the sequence number as entered by the user for the TCD	No	No
POAITCD_CURRENCY	varchar(20)	NULL	This field holds the Transaction currency	No	No
Poaitcd_Cost_Diff	numeric(28,8)	NULL	This field holds the TCD Cost difference of a PO document before and after amendment	No	No
poaitcd_amend_no	numeric(10)	NOT NULL	This field holds the amendment no of the PO documents.	Yes	Yes
poaitcd_line_no	numeric(10)	NOT NULL	Each item(record) requested in the purchase Order is associated with this key .	Yes	Yes
poaitcd_po_no	varchar(40)	NOT NULL	This field holds the Purchase order number.	Yes	Yes
poaitcd_ouinstance	decimal(10)	NOT NULL	This field holds the ouinstance in which the TCD details for the line item of the PO have been created	Yes	Yes
poaitcd_tcd_rate	decimal(28,8)	NULL	TCT rate for the TCD code and the variant . this should not be changed for TCD basis -- Percentage.	No	No
poaitcd_tcd_ou	numeric(10)	NULL	This field holds the tcd ouinstance	No	No
poaitcd_serial_no	numeric(10)	NOT NULL	This field holds the TCD sequence no (Runing NO)	Yes	No
poaitcd_tcd_variant	varchar(25)	NOT NULL	This field holds the TCD variant for the TCD code.	No	No
poaitcd_tcd_code	varchar(25)	NOT NULL	This field holds the Unique identifier for the TCD	No	No

Table Name po_poaitm_po_item_details

Table Comment This table holds the item details of Amended purchase order document
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
poaitm_ouinstance	decimal(10)	NOT NULL	This field holds the OUinstance in which the PO is Amended.	Yes	Yes
poaitm_po_no	varchar(40)	NOT NULL	This field captures the Purchase order number.	Yes	Yes
poaitm_amend_no	numeric(10)	NOT NULL	This field holds the amendment no of the PO documents.	Yes	Yes
poaitm_line_no	numeric(10)	NOT NULL	Each item(record) requested in the purchase Order is associated with this key .	Yes	No
poaitm_quot_line_no	numeric(10)	NULL	This is the quotation line no of the quotation for which the PO is raised.	No	No
poaitm_part_no	varchar(40)	NULL	This field holds the Part number requested in the PO	No	No
poaitm_part_ou	numeric(10)	NULL	This field holds the Part number OUinstance requested in the PO	No	No
poaitm_part_condition	varchar(5)	NULL	This field holds the part condition, the values are (N)ew (Ns)New Surplus (O)verhaul (S)erviceable (U)nserviceable	No	No
poaitm_order_qty_puom	decimal(28,8)	NULL	This field holds the Ordered qty of each line item of the PO	No	No
poaitm_purchase_uom	varchar(10)	NULL	This field holds Any valid UOM from the UOM component in which the goods can be purchased .	No	No
poaitm_cost	decimal(28,8)	NULL	This field holds the Cost of the part, depending on cost per, it can be either cost of 1 part or more.	No	No
poaitm_cost_per		NULL	This field holds the Unit cost of the part	No	No
poaitm_ship_to_ou	numeric(10)	NULL	This field holds OU instance	No	No
poaitm_sch_type	varchar(5)	NULL	This field &nbspholds &nbspthe &nbsppurchase order’s schedule type List of values are (S)ingle -- all the requested qty will be delivered in a single &nbspschedule in the same warehouse. (M)ultiple -- the requested qty will be delivered in a staggered schedule dates and stocked in single or separate warehouses.	No	No
poaitm_stockadmn_ou	numeric(10)	NULL	This field holds the stock admin OUinstance	No	No
POAITM_ALTERNATE_PART	varchar(40)	NULL	This field holds the alternate part of the line item	No	No
poaitm_inspection_type	varchar(5)	NULL	This field &nbspholds &nbspthe &nbspInspection types. List of values are (N)one (S)elf (I)By Inspector	No	No
poaitm_matching_type	varchar(5)	NULL	This field holds &nbspthe matching types. List of values are (Tw)Two Way (Tp)Three way at PO (Tg)Three way at GR (Fp)Four Way at PO (Fg)Four Way at GR	No	No
poaitm_tolerance_type	varchar(5)	NULL	This field &nbspholds &nbspthe tolerance types. list of values are (V)alue (Q)uantity (B)oth	No	No
poaitm_tolerance_percent	decimal(28,8)	NULL	This field &nbspholds &nbspthe tolerance limit within which we can accept the ordered quantity from the supplier	No	No
poaitm_basic_value	decimal(28,8)	NULL	This field &nbspholds &nbspthe basic value. basic value = order qty * &nbspCost / cost per	No	No
poaitm_total_tcd_part_val	decimal(28,8)	NULL	This field &nbspholds &nbspthe Sum of all TCD values of the line item.	No	No
poaitm_received_qty_puom	decimal(28,8)	NULL	This field holds &nbspthe Quantity received from the supplier	No	No
poaitm_accepted_qty_puom	decimal(28,8)	NULL	This field &nbspholds &nbspthe Qty Received from the Supplier and have been inspected	No	No
poaitm_quality_attribute	varchar(5)	NULL	This fields &nbspholds the Quality Attribute &nbspwith the following values 1. (S)tandard 2. (C)ustom 3. (N)one	No	No
POAITM_REF_DOC_OU	numeric(10)	NULL	This field &nbspcaptures the referance document ou that &nbspwhere the document &nbspis created	No	No
POAITM_REF_DOC_NO	varchar(40)	NULL	This field &nbspcaptures the referance document no this used to find from &nbspwhere the &nbsporder &nbspis raised.	No	No
POAITM_REF_DOC_TYPE	varchar(5)	NULL	This field &nbspcaptures the referance document Type	No	No
POAITM_DOC_ATTACH	varchar(5)	NULL	This field &nbspholds the &nbspFlag whether the documenta are attached or not for the given part List of values are (Y)es (N)o	No	No
POAITM_RCPT_POS_TOL	numeric(28)	NULL	This field &nbspholds the positive tolerance limit within which we can accept the ordered quantity from the supplier	No	No
POAITM_RCPT_NEG_TOL	numeric(28)	NULL	This field &nbspholds the negative tolerance limit within which we can accept the ordered quantity from the supplier	No	No
POAITM_INSPECTION_WO	char(18)	NULL	This field holds the following values (R) -- Required, (NR) -- Not Required, (AR) -- As Required If the user sets the Inspection Type for the line item as Reqd., it is must that he should create a Inspection WO. If he sets it as ’As Reqd.’, then during GR - Edit Inspection Information, he can decide to go for Inspection WO creation or not.	No	No
POAITM_CERT_TYPE	sql_variant	NULL	This field holds the value of Certificate type	No	No
POAITM_CAPEX_PROP_NO	sql_variant	NULL	This field holds the Capex Proposal Number	No	No
POAITM_ACC_USG	sql_variant	NULL	This field holds the Accounting Usage	No	No
POAITM_CSTG_USG	sql_variant	NULL	This field holds the Costing Usage	No	No
POAITM_ANAL_CODE	sql_variant	NULL	This field holds the Analysis code	No	No
POAITM_SUBANAL_CODE	sql_variant	NULL	This field holds the Subanalysis code	No	No
POAITM_PART_DESC	sql_variant	NULL	This field holds the Part Description	No	No
POAITM_REMARKS	sql_variant	NULL	This field holds the Remarks of each line item	No	No
POAITM_SUPP_ESTM_ARRV_DT	sql_variant	NULL	This field holds the Estimate arrival date	No	No
POAITM_ALTERNATE_PART_NO	varchar(40)	NULL	This field holds the alternate partno of each line item of po document	No	No
POAITM_ALTERNATE_TYPE	varchar(5)	NOT NULL	This field &nbspholds &nbspthe &nbspFlag whether the alternate part is allowed or not for the given part Possible values.. SA -Specific Alternate A-Allowed NA-Not Allowed	No	No
POAITM_WORKCENTER_CODE	varchar(30)	NULL	This field holds the workcenter code for the part	No	No
Poaitm_Value_Diff	numeric(28,8)	NULL	This field holds the difference in PO part item value for the each part after amendment	No	No
POAITM_TASKNO	char(18)	NULL	To save the Task# entered by the user	No	No
POAITM_TASK_DISPSEQNO	char(18)	NULL	To save the Task Sequence# entered by the user	No	No
POAITM_TASK_KEYSEQNO	char(18)	NULL	To save the INternal sequence # for the task Sequence # for the Referecne document# given in the PO multiline	No	No
POAITM_CORE_PARTNO	varchar(40)	NULL	To save the core part# entered by the user	No	No
POAITM_CORE_SERIALNO	varchar(40)	NULL	To save the Core serial# entered by the user	No	No
POAITM_CORE_LOTNO	varchar(40)	NULL	To save the Core Lot# entered by the user	No	No
POAITM_CAP_THRSHOLD_AMT	bigint	NULL	To Capture the threshold amount	No	No
POAITM_RCP_RCD_OPT	char()	NULL	To capture the Receipt record option	No	No
POAITM_THRSHOLD_FAIL	sql_variant	NULL	To capture, Flag value ’Y’, If value of POCost is lesser then or equal to thrshold amount mentioned in CPS component.	No	No

Table Name po_poapr_po_prbased_details

Table Comment This table holds the &nbspAmended &nbsppurchase order document in which the purchase request are raised
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
poapr_pr_ouinstance	numeric(10)	NULL	This field &nbspholds &nbspthe &nbspOUinstance in which the PR is created	No	No
poapr_pr_no	varchar(40)	NULL	This field &nbspholds &nbspthe Purchase Request #	No	No
poapr_serial_no	numeric(10)	NOT NULL	stores the serial no which is an unique sequential number generated	Yes	No
poapr_prline_no	numeric(10)	NULL	stores the PR line item no	No	No
poapr_covered_qty	decimal(28,8)	NULL	This field &nbspholds the PR covered quantity PR covered quantity = &nbspPR covered quantity - PR order quantity	No	No
poapr_pr_sch_no	numeric(10)	NULL	stores the schedule no of the the PR line item	No	No
poapr_po_no	varchar(40)	NOT NULL	This field &nbspholds the Purchase order number.	Yes	Yes
poapr_ouinstance	decimal(10)	NOT NULL	This field &nbspholds the OUinstance in which the PO is created	Yes	Yes
poapr_sch_no	numeric(10)	NOT NULL	stores the schedule no of the PO line item	Yes	No
poapr_amend_no	numeric(10)	NOT NULL	This field &nbspholds the amendment no of the PO documents.	Yes	Yes
poapr_line_no	numeric(10)	NOT NULL	This field &nbspholds the Unique identifier for each item requested in the Purchase order	Yes	Yes

Table Name Po_PoAROd_Ref_Obj_dtl

Table Comment xThis table is Used to store information for the reference object details for the Amended PO Document
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
poarod_created_by	varchar(30)	NULL	This field &nbspholds the user who created &nbspthe PO refererce object detail	No	No
poarod_created_date	datetime	NULL	This field &nbspholds the date when the PO refererce object detail is created in the system	No	No
poarod_ref_doc_file_name	varchar(50)	NULL	This field hold the Reference document file name	No	No
poarod_modified_date	datetime	NULL	This field &nbspholds the date when the PO refererce object detail is modified &nbspin the system	No	No
poarod_modified_by	varchar(30)	NULL	This field &nbspholds the user who modified &nbspthe PO refererce object detail	No	No
POAROD_PO_LINE_NO	numeric(10)	NOT NULL	This field holds the Unique identifier for each part &nbsprequested in the PO	No	No
poarod_po_no	varchar(40)	NOT NULL	This field &nbspholds the Purchase order number	Yes	Yes
poarod_created_ouinstance	decimal(10)	NOT NULL	This field holds the ouinstance in which the the refernce object details for the Purchase order &nbspcreated	Yes	Yes
poarod_ref_doc_id	varchar(40)	NULL	This field hold the Reference documentid	No	No
poarod_ref_doc_type	varchar(25)	NULL	This field hold the list of Reference document types defined in the Common Master component	No	No
poarod_amend_no	numeric(10)	NOT NULL	This field holds the amendment no of the PO	Yes	Yes
poarod_doc_line_id	numeric(10)	NOT NULL	This is just a unique &nbsprunning number for identifying a record for each PO document .	Yes	No

Table Name po_poasc_sup_corr_details

Table Comment This table holds supplier correspondence details for an amended PO document
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
poasc_createddate	datetime	NULL	This field holds the date on which the supplier correspondence details for a PO line item is created	No	No
poasc_buyer_remarks	varchar(255)	NULL	This field holds the buyer remarks	No	No
poasc_supp_remarks	varchar(255)	NULL	This field holds the supplier remarks	No	No
poasc_created_by	varchar(30)	NULL	This field holds the user id by whom the supplier correspondence details for a PO line item is created	No	No
poasc_modifieddate	datetime	NULL	This field holds the date on which the supplier correspondence details for a PO line item is modified	No	No
poasc_modified_by	varchar(30)	NULL	This field holds the user id by whom the supplier correspondence details for a PO line item is modified	No	No
poasc_po_no	varchar(40)	NOT NULL	This field &nbspcaptures the Purchase order number.	Yes	Yes
poasc_ouinstance	decimal(10)	NOT NULL	This field &nbspholds the OUinstance in which the PO is Amended.	Yes	Yes
poasc_date	datetime	NULL	This field holds the date on which the correspodence details are entered	No	No
poasc_line_no	numeric(10)	NOT NULL	This field holds the line nos for the remarks entered for the combination of PO#, Amendment# and PO line item#	Yes	No
poasc_po_amend_no	numeric(10)	NOT NULL	This field &nbspholds the amendment no of the PO documents.	Yes	Yes
poasc_po_line_no	numeric(10)	NOT NULL	Each item(record) requested in the purchase Order is associated with this key .	Yes	Yes

Table Name po_poasch_po_sch_details

Table Comment This table holds the item schedule details of &nbspAmended purchase order document
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
poasch_moved_qty_puom	decimal(28,8)	NULL	This field &nbspholds the qty that has been received from the supplier and moved to the warehouse	No	No
poasch_wh_code	varchar(10)	NULL	This field &nbspholds the Warehouse in which the schedule qty has to be moved	No	No
poasch_sch_date	datetime	NULL	This field &nbspholds the date in which the schedule qty has to be delivered.	No	No
poasch_modifieddate	datetime	NULL	This field &nbspholds &nbspthe date when the PO schedule details modified &nbspin the system	No	No
poasch_createddate	datetime	NULL	This field &nbspholds the date when the PO schedule details created in the system	No	No
poasch_created_by	varchar(30)	NULL	This field &nbspholds the user who created the PO schedule details	No	No
poasch_modified_by	varchar(30)	NULL	This field &nbspholds the user who modified the PO schedule details	No	No
poasch_po_no	varchar(40)	NOT NULL	This field &nbspholds the Purchase order number.	Yes	Yes
poasch_ouinstance	decimal(10)	NOT NULL	This field &nbspholds the &nbspouinstance in which the schedule details for the line item of the PO have been created	Yes	Yes
poasch_sch_qty_puom	decimal(28,8)	NULL	This field &nbspholds the Schedule quantity.	No	No
poasch_sch_no	numeric(10)	NOT NULL	This field &nbspholds the Unique identifier for each schedule of the line item	Yes	No
poasch_amend_no	numeric(10)	NOT NULL	This field &nbspholds the amendment number of PO document.	Yes	Yes
poasch_line_no	numeric(10)	NOT NULL	Each item(record) requested in the purchase Order is associated with this key .	Yes	Yes

Table Name po_poatmcn_po_terms_condns

Table Comment This table holds the Terms and Condition of &nbspAmended purchase order document
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
poatmcn_ouinstance	decimal(10)	NOT NULL	This field &nbspholds the &nbspouinstance in which the &nbspPurchase order &nbspis created	Yes	Yes
poatmcn_po_no	varchar(40)	NOT NULL	This field &nbspholds the Purchase order number	Yes	Yes
poatmcn_amend_no	numeric(10)	NOT NULL	This field &nbspholds the purchase order amendment number.	Yes	Yes
poatmcn_payterm_code	varchar(25)	NULL	This field &nbspholds the Unique identifier for the Payterm	No	No
poatmcn_payterm_ou	numeric(10)	NULL	This field &nbspholds the OUinstance for the Payterm	No	No
poatmcn_pay_to_supp	varchar(45)	NULL	A valid supplier defined in the Supplier component &nbspand mapped to the Supplier (who supplies the &nbspgoods requested )as pay to supplier ( to whom the payment can be made)	No	No
poatmcn_pay_to_supp_ou	numeric(10)	NULL	Holds the Ouinstance of the supplier component to whom payment has to be made	No	No
poatmcn_payment_mode	varchar(5)	NULL	This field &nbspholds &nbspvarous payment mode. list of values are (Cq)Check (Cs)Cash (DD)Demand Draft (P)ay order (O)rder (CC)Credit Card	No	No
poatmcn_insurance_terms	varchar(150)	NULL	This field holds the insurence term of &nbsppurchase order document.	No	No
poatmcn_insurance_liability	varchar(25)	NULL	This field &nbspholds &nbspinsurance liability of the PO document List of values are (O)urs (S)upplier (Ot)her	No	No
poatmcn_insurance_amt	decimal(28,8)	NULL	This field holds the insurence amount of &nbspthe purchase order document.	No	No
poatmcn_inco_term	varchar(150)	NULL	This field holds the &nbspINCO term of &nbspthe purchase order document.	No	No
poatmcn_delivery_point	varchar(255)	NULL	This field holds the delivery point &nbspof &nbspthe purchase order document.	No	No
poatmcn_trans_shipment	varchar(5)	NULL	This field holds the transshipment of &nbspthe purchase order document. List of values (Y)es (N)o	No	No
poatmcn_ship_partial	varchar(5)	NULL	This field holds the ship partial of &nbspthe purchase order document. List of values (Y)es (N)o	No	No
poatmcn_pay_priority	varchar(5)	NULL	This field holds the pay priority of &nbspthe purchase order document. List of values are 1.High, 2.Normal 3.Low	No	No
poatmcn_ship_by	varchar(25)	NULL	This field holds the mode of transport &nbspof &nbspthe purchase order document. Mode of transports are 1. AIR 2.LAND	No	No
poatmcn_pkg_code	varchar(25)	NULL	This field holds the packaging terms &nbspof &nbspthe purchase order document. List of values 1. Bottle 2. Box	No	No
poatmcn_ship_payment	varchar(25)	NULL	This field holds the list of shipping payment methods in active status defined in the Logistics common master component.	No	No
poatmcn_remarks	varchar(255)	NULL	This field holds the remarks &nbspof &nbspthe purchase order documen’s terms and condition.	No	No
poatmcn_createddate	datetime	NULL	This field &nbspholds the date when the PO term and condition created in the system	No	No
poatmcn_created_by	varchar(30)	NULL	This field &nbspholds the user who created the PO &nbspterms and cond	No	No
poatmcn_modifieddate	datetime	NULL	This field &nbspholds the date when the PO term and condition modified in the system	No	No
poatmcn_modified_by	varchar(30)	NULL	This field &nbspholds the user who modified the PO &nbspterms and cond	No	No
POATMCN_GTA_REFDOC_NO	varchar(40)	NULL	This field &nbspholds the General Terms Agreement &nbspreference documentno	No	No
POATMCN_REFDOC_DATE	datetime	NULL	This field &nbspholds the General Terms Agreement &nbspreference document Date	No	No
POATMCN_GTA_REMARKS	varchar(255)	NULL	This field &nbspholds the General Terms Agreement &nbspremarks	No	No
POATMCN_WARRANTY	varchar(5)	NULL	This field holds the warranty flag &nbspof &nbspthe purchase order document. List of values (Y)es (N)o	No	No
POATMCN_WARR_BASIS	varchar(25)	NULL	This field holds the Warranty basis &nbspof &nbspthe purchase order document. List of values 1. Both 2. calender 3. Usage	No	No
POATMCN_WARR_AGREEMENT_NO	varchar(40)	NULL	This field holds the Warranty agreement no . if warrant flag is ’yes’ then warranty agreement no is mandatory	No	No
POATMCN_ADVANCE_PAY_AMT	numeric(28)	NULL	This field holds the advance payable amount. If advance payable flag is ’yes’ then this is mandatory	No	No
POATMCN_ADVANCE_PAYDATE	datetime	NULL	This field holds the advance payable date. If advance payable flag is ’yes’ then this is mandatory	No	No
POATMCN_ADVANCE_PERC	numeric(28)	NULL	This field holds the advance percentage.	No	No
POATMCN_ADVANCE_PERC_ON	varchar(25)	NULL	This field holds the advance percentage on &nbspof &nbspthe purchase order document. List of values 1. Basic Value 2. Total Value	No	No
POATMCN_ADVANCE_PAYABLE	varchar(5)	NULL	This field holds the Advance Payable..Loads the quick code which defined in common logistics master	No	No
POATMCN_ADVANCE_TOL_PERC	numeric(28)	NULL	This field holds the advance tolerence &nbsppercentage.	No	No
POATMCN_DDCHARGES_BORNEBY	varchar(25)	NULL	This field holds the DD charges brone by &nbspof &nbspthe purchase order document. List of values 1. self 2.supplier	No	No
POATMCN_PAY_TO_SUPP_ID	numeric(10)	NULL	This field &nbspholds the &nbsppay to supplier address ids	No	No
POATMCN_PAYMENT_NOTES	varchar(2000)	NULL	This field &nbspholds the &nbsppayment notes	No	No
POATMCN_PACKAGING_NOTES	varchar(2000)	NULL	This field &nbspholds the packaging notes	No	No
POATMCN_PORT_OF_DEP	varchar(32)	NULL	This field &nbspholds the port of depature	No	No
POATMCN_CARRIERAGENCY	varchar(20)	NULL	This field &nbspholds the list of carrier agencies	No	No
POATMCN_SHIPPING_NOTES	varchar(2000)	NULL	This field &nbspholds the &nbspshipping notes	No	No
POATMCN_FWD_CVR_RATE	bigint	NULL	This field holds the forward Cover rate	No	No
POATMCN_INV_AT	sql_variant	NULL	This field holds the Invoice At	No	No
POATMCN_FWD_CVR_APPL	sql_variant	NULL	This field holds the forward cover applicable	No	No
POTAMCN_ADV_PAID	decimal(28,8)	NULL	This field holds the Advance Paid by the supplier for that part	No	No
POATMCN_WARRBEGINS	char(18)	NULL	To save the Warranty begins on values	No	No
POATMCN_DURATION	int	NULL	To save the warrarnty duration	No	No
POATMCN_DURPERIOD	char(18)	NULL	To save the warranty duration period	No	No
POATMCN_FLIGHTHRS	int	NULL	To save the Flight hours	No	No
POATMCN_FLIGHTCYCLES	char(18)	NULL	To save the Flight cycles	No	No
POATMCN_TERMS_REFERENCE	char(18)	NULL	To save the Terms and references	No	No
POATMCN_RMANO	sql_variant	NULL	To capture the RMA Number	No	No
POATMCN_RMADATE	datetime	NULL	To capture the RMA Date	No	No
POATMCN_RET_SUPP_ID	sql_variant	NULL	To populate the ’Pay To Supplier Address ID’ combo with all the ’Address Id’ of the supplier	No	No

Table Name PO_POAUdi_User_Def_Info

Table Comment This table holds the User define information &nbspof Amended &nbsppurchase order document
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
poaudi_user_def_opt4	varchar(30)	NULL	This field holds the fourth &nbspdescription of user defined options.	No	No
poaudi_user_def_remarks	varchar(255)	NULL	This field holds the user defined remarks	No	No
poaudi_user_def_desc4	varchar(30)	NULL	This field holds the &nbspfourth user defined option	No	No
poaudi_user_def_opt3	varchar(30)	NULL	This field holds the third description of user defined options.	No	No
poaudi_modified_date	datetime	NULL	This field &nbspholds the date when the PO user define information is modified in the system	No	No
poaudi_created_date	datetime	NULL	This field &nbspholds the date when the PO user define information is created in the system	No	No
poaudi_created_by	varchar(30)	NULL	This field &nbspholds the user who created &nbspthe PO user define information	No	No
poaudi_modified_by	varchar(30)	NULL	This field &nbspholds the user who modified &nbspthe PO user define informatio	No	No
poaudi_amend_no	numeric(10)	NOT NULL	This field holds the amendment no of the PO	Yes	Yes
poaudi_po_no	varchar(40)	NOT NULL	This field &nbspholds the Purchase order number	Yes	Yes
poaudi_ouinstance	decimal(10)	NOT NULL	This field holds the ouinstance in which the the user define information for the Purchase order &nbspcreated	Yes	Yes
poaudi_user_def_desc3	varchar(30)	NULL	This field holds the thirdt user defined option	No	No
poaudi_user_def_opt2	varchar(30)	NULL	This field holds the second description of user defined options.	No	No
poaudi_user_def_desc1	varchar(30)	NULL	This field holds the first user defined option	No	No
poaudi_user_def_desc2	varchar(30)	NULL	This field holds the second user defined option	No	No
poaudi_user_def_opt1	varchar(30)	NULL	This field holds the first description of user defined options.	No	No

Table Name po_podsd_drop_ship_dtl

Table Comment This table holds the Dropship details of &nbsppurchase order document
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
podsd_country	varchar(40)	NULL	This field &nbspholds the country of the company for shipment.	No	No
podsd_contact_person	varchar(80)	NULL	This field &nbspholds the contact person of the company for shipment.	No	No
podsd_state	varchar(32)	NULL	This field &nbspholds the state of the company for shipment.	No	No
podsd_zip_code	varchar(15)	NULL	This field &nbspholds the zip code of the company for shipment.	No	No
podsd_ship_all_itm	varchar(5)	NULL	This field &nbspholds the flag whether Ship All Items to the same Location or not the values may be YES or NO	No	No
podsd_phone_no	varchar(70)	NULL	This field &nbspholds the phone no of the company for shipment	No	No
podsd_email	varchar(70)	NULL	This field &nbspholds the email id of the company for shipment	No	No
podsd_fax_no	varchar(70)	NULL	This field &nbspholds the fax details of the company for shipment	No	No
podsd_remarks	varchar(255)	NULL	This field &nbspholds &nbspthe remarks of the shipment	No	No
podsd_po_no	varchar(40)	NOT NULL	This field &nbspholds the Purchase order number.	Yes	Yes
podsd_line_no	numeric(10)	NOT NULL	Each item(record) requested in the purchase Order is associated with this key .	Yes	Yes
podsd_ouinstance	float()	NOT NULL	This field &nbspholds the &nbspouinstance in which the dropship details for the line item of the PO have been created.	Yes	Yes
podsd_city	varchar(32)	NULL	This field &nbspholds the city of the company for shipment.	No	No
podsd_addr_3	varchar(255)	NULL	This field &nbspholds the company address for the shipment.	No	No
podsd_comp_name	varchar(150)	NULL	This field &nbspholds the company name for the shipment.	No	No
podsd_addr_2	varchar(255)	NULL	This field holds the company address for the shipment.	No	No
podsd_addr_1	varchar(255)	NULL	This field &nbspholds the company address for the shipment.	No	No

Table Name po_podtcd_po_doc_tcd

Table Comment This table holds the Document TCD details of &nbsppurchase order.
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
podtcd_created_by	varchar(30)	NULL	This field &nbspholds the user who created the PO Doc TCD	No	No
podtcd_modifieddate	datetime	NULL	This field &nbspholds the date when the PO Doc TCD is modified in the system	No	No
podtcd_createddate	datetime	NULL	This field &nbspholds the date when the PO Doc TCD is created in the system	No	No
podtcd_pay_to_supp	varchar(45)	NULL	A valid supplier defined in the Supplier component &nbspand mapped to the Supplier (who supplies the &nbspgoods requested )as pay to supplier ( to whom the payment can be made)	No	No
podtcd_user_seqno	numeric(10)	NULL	holds the sequenc number as entered by the user for the TCD	No	No
podtcd_modified_by	varchar(30)	NULL	This field &nbspholds the user who modified the PO Doc TCD	No	No
PODTCD_CURRENCY	varchar(20)	NULL	This field &nbspholds the Transaction currency	No	No
podtcd_exchg_rate	numeric(28,8)	NULL	Holds the exchage rate between the document currency and the payment currency	No	No
podtcd_po_no	varchar(40)	NOT NULL	This field &nbspholds the Purchase order number	Yes	Yes
podtcd_serial_no	numeric(10)	NOT NULL	This field holds the Unique identifier number for the TCD of the PO.	Yes	No
podtcd_ouinstance	decimal(10)	NOT NULL	This field &nbspholds the &nbspouinstance in which the Document level TCD &nbspof the PO have been created	Yes	Yes
podtcd_tcd_amount	decimal(28,8)	NULL	The Tcd amount that will be calculated from the TCD component for the TCD code and the variant and the &nbspTCD rate &nbspsupplied	No	No
podtcd_tcd_rate	decimal(28,8)	NULL	TCD rate for the TCD code and the variant . this should not be changed for TCD basis -- Percentage.	No	No
podtcd_tcd_variant	varchar(25)	NOT NULL	This field holds the TCD variant &nbspfor the TCD code.	No	No
podtcd_tcd_ou	numeric(10)	NULL	This field &nbspholds the tcd ouinstance	No	No
podtcd_tcd_code	varchar(25)	NOT NULL	This field holds the Unique identifier for the TCD	No	No

Table Name po_pohdr_po_header

Table Comment This table holds the purchase order document details
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
pohdr_ouinstance	decimal(10)	NOT NULL	This field holds the Purchase order &nbspcreated ouinstance	Yes	No
pohdr_po_no	varchar(40)	NOT NULL	This field &nbspholds the Purchase order number	Yes	No
pohdr_amend_no	numeric(10)	NOT NULL	This field &nbspholds the purchase order amendment number. --The first time PO is created , amendment # is set to 0.. . --The next time any change is made to the PO after authorization ,will increment the amendment# &nbspby 1.	No	No
pohdr_po_date	datetime	NOT NULL	This field &nbspholds &nbspthe Purchase order creation date .	No	No
pohdr_po_status	varchar(5)	NOT NULL	This field &nbspholds the various PO statuses maintained are (F)resh -- Before authorization and if the schedule quantity and the order quantity are equal. (D)raft - before authorization , when the schedule quantity and the order quantity are not equal. (O)pen - Authorized (U)nder Authorization (A)mended --after authorization ,any changes made and &nbspwhen the schedule quantity and the order quantity are equal. (H)eld -- temporarily PO is stopped. (S)hortclose -- Permanently PO is stopped. (CA)ncelled (Cl)osed -- all the goods requested in PO have been delivered &nbspfrom the supplier(either equal to or more than the ordered quantity but within the tolerance &nbsplimit). (NT)closed (P) Under Amendment (B)lank (R)evised (RET)urn	No	No
pohdr_po_type	varchar(5)	NULL	This field &nbspholds the Po Types Following are the Po Types 1. (G)eneral 2. (D)ropShip 3. (S)ample -- Cost is not mandatory as it can be a sample item from the supplier 4. (E)xpress -- Supplier to Part mapping is not mandatory 5.(CONSI)gnment 6.(EXCHG) --- Exchange 7.(PBH) 8.(PBHEX)change 9.(B)lank 10.Service, 11.Adhoc	No	No
pohdr_supp_code	varchar(45)	NULL	This field &nbspholds the Supplier code from the supplier component who has raise the purchase order.	No	No
pohdr_supplier_ou	numeric(10)	NULL	This field &nbspholds the supplier Ouinstance where the supplier is registered.	No	No
pohdr_supp_created_ou	numeric(10)	NULL	This field &nbspholds the supplier created Ouinstance	No	No
pohdr_quotationno	varchar(40)	NULL	It is the Quotation # (from the RFQ component) for which the po is created.	No	No
pohdr_quot_amend_no	varchar(40)	NULL	It is the latest quotation amentment no	No	No
pohdr_quotationou	numeric(10)	NULL	This field holds the Quotation created ou	No	No
pohdr_supplieroffno	varchar(40)	NULL	This field holds the supplier reference quotation no	No	No
pohdr_amendmentrefno	varchar(40)	NULL	supplier reference amendment no	No	No
pohdr_remarks	varchar(255)	NULL	this field holds the remarks	No	No
pohdr_part_type	varchar(5)	NULL	This field &nbspholds the Part type. The Part types maintained are 1) Tool (Tool) 2) Component ( Cmpnt ) 3) Consumable (Cnsmb) 4) Kit (Kit) 5) Spare Part (Sprpt) 6) Raw Material (Rwmtr) 7) All (All)	No	No
pohdr_po_cat	varchar(25)	NULL	This field &nbspholds the Po Category - &nbspAll active quick codes under quick code type &nbspCategory	No	No
pohdr_user_status	varchar(25)	NULL	This field &nbspholds the User status - &nbspAll active quick codes under quick code type User Status	No	No
pohdr_po_currency	varchar(20)	NULL	This field &nbspholds any one of the Currency &nbspmapped to the supplier.	No	No
pohdr_total_basic_val	decimal(28,8)	NULL	This field &nbspholds the PO basic value. PO basic value= sum of all basic value of line #. (Basic value of a line #= Order qty multiplied by (cost divided by cost per )which is stored in the item details table)	No	No
pohdr_total_tcd_POval	decimal(28,8)	NULL	This field &nbspholds the TCD Total Amount ( Doc Level). TCD Total Amount = sum of all tcd amount of the document	No	No
pohdr_total_tcd_partval	decimal(28,8)	NULL	This field &nbspholds the TCD Total amount for all Po line # (item level)	No	No
pohdr_exchange_rate	decimal(28,8)	NULL	This field &nbspholds th exchange rate for the PO currency to Base currency from the Exchange rate component	No	No
pohdr_reason	varchar(2000)	NULL	This field &nbspholds the Reason &nbspfor why this status change have been made.	No	No
pohdr_buyer_group	varchar(25)	NULL	This field &nbspholds the buyer group of the Login user from the Buyer group component.	No	No
pohdr_buygrp_ou	numeric(10)	NULL	This field &nbspholds the buyer group ouinstance where the &nbspbuyer group is registered.	No	No
pohdr_auth_terlevel	varchar(25)	NULL	This field &nbspholds Level Applicable for the PO Total value	No	No
pohdr_auth_minval	decimal(28,8)	NULL	This field &nbspholds &nbspthe Min Value for the given level /PC	No	No
pohdr_auth_maxval	decimal(28,8)	NULL	This field &nbspholds &nbspMax Value for the given level /PC	No	No
pohdr_auth_nxtlvlpc	varchar(25)	NULL	This field &nbspholds the Next Level / PC to be Authorized.	No	No
pohdr_auth_type	varchar(5)	NULL	This field &nbspholds &nbspthe Next level Authorization type [Lvl OR PC]	No	No
pohdr_auth_stage	varchar(25)	NULL	This field &nbspholds &nbspthe PO Dynamic status	No	No
pohdr_createddate	datetime	NULL	This field &nbspholds the date when the PO is created in the system	No	No
pohdr_created_by	varchar(30)	NULL	This field &nbspholds the user who created the PO	No	No
pohdr_modifieddate	datetime	NULL	This field &nbspholds the date when the PO is modified.	No	No
pohdr_modified_by	varchar(30)	NULL	This field &nbspholds &nbspthe user who modified the PO	No	No
pohdr_approveddate	datetime	NULL	This field &nbspholds &nbspthe date when the PO is approved.	No	No
pohdr_approved_by	varchar(30)	NULL	This field &nbspholds the user who approved the PO	No	No
pohdr_authoriseddate	datetime	NULL	This field &nbspholds &nbspthe date when the PO is authorised.	No	No
pohdr_authorised_by	varchar(30)	NULL	This field &nbspholds the user who authorized the PO	No	No
pohdr_amendmentdate	datetime	NULL	This field &nbspholds &nbspthe date when the PO is amended.	No	No
pohdr_amendment_by	varchar(30)	NULL	This field &nbspholds &nbspthe user who &nbspamended &nbspthe PO	No	No
pohdr_timestamp	numeric(10)	NULL	This field &nbspholds the &nbspinteger value which identifies if any change has been made to the record. -- the first time the PO &nbspis created , the timestamp value is 1, -- the next time any change is made &nbspto the record ,increment it by 1.	No	No
pohdr_Quality_Flg	varchar(5)	NULL	This fields &nbspholds the Quality Flag The List of values are 1.(Y)es 2.(N)o	No	No
pohdr_priority	varchar(20)	NULL	This field &nbspholds &nbspthe PO Priority Following are the PO Priority 1.(A)OG 2.(C)ritical 3.(E)xpedite 4.(R)outine	No	No
pohdr_ac_regn_no	varchar(30)	NULL	This field &nbspholds the aircraft registration number	No	No
pohdr_num_type_no	varchar(5)	NULL	stores the numbering type no for the PO	No	No
pohdr_wf_doc_key	varchar(128)	NULL	stores the document key for the purpose of work flow	No	No
pohdr_po_core_status	varchar(5)	NULL	Purchase Order Core Status - ’Open’, ’Core Due’, ’Rcpt Due’ &nbspor ’Closed’	No	No
pohdr_Issue_Doc_OU	numeric(10,0)	NULL	OUInstance of Issue Document which is updating the core status - applicable for PO Types - Exchange and PBH-Exchange	No	No
Pohdr_Issue_Doc_No	varchar(40)	NULL	Issue Document Number which is updating the core status - applicable for PO Types - Exchange and PBH-Exchange	No	No
Pohdr_GR_Doc_OU	numeric(10,0)	NULL	OUInstance of Goods Receipt which is updating the core status - applicable for PO Types - Exchange and PBH-Exchange	No	No
Pohdr_GR_Doc_No	varchar(40)	NULL	Goods Receipt Number which is updating the core status - applicable for PO Types - Exchange and PBH-Exchange	No	No
POHDR_COMPONENT_OU	numeric(10)	NULL	PBH Component OU	No	No
POHDR_COMPONENT_ID	varchar(90)	NULL	PBH Component ID	No	No
POHDR_EXP_TYPE	char()	NULL	This field holds following values for Expense type selected for the Purchase# Revenue Capital	No	No
POHDR_RCP_RCD_OPT	char()	NULL	This field holds following value ’No GR’, ’GR Acceptance’, ’GR Movement’.	No	No
POHDR_WARRCLAIM_APP	char(1)	NULL	To save Warranty clajm applicable "Yes" or "No"	No	No
POHDR_WARRCLAIM_NO	varchar(40)	NULL	To Save the Warranty claim#	No	No
POHDR_REFAGREE_NO	Varchar(40)	NULL	To Save the reference document number	No	No
POHDR_REFAGREE_DATE	datetime	NULL	To save the reference agerement date	No	No
POHDR_CLAIM_REMARKS	varchar(255)	NULL	To save the claim remarks	No	No
POHDR_SRCDOCOU	int	NULL	To save the source document OU from where the PO get created	No	No
POHDR_SRCDOCNO	varchar(40)	NULL	To save the source document number from where the PO get created.	No	No
POHDR_PO_MODE	char(5)	NULL	To save "A" or "M". A - Po is created automatically M- Po is created manually	No	No
POHDR_WARRAPP_FLAG	char(18)	NULL	In PO Edit terms & conditions if Under warranty is set as "Yes" then save the value as "Y". If the Under warranty value is set as "No" then save the value as "N"	No	No
POHDR_PUR_UNIT	sql_variant	NOT NULL	To populate the combo ’Purchasing Unit’ with all the Posting Finance Book codes available for the Company and are mapped to the Login OU.	No	No
POHDR_PUR_REMARKS	sql_variant	NULL	To populate the combo ’Default PR Remarks’ &nbspbased on the set option ’Copy PR Remarks to PO’ &nbspin the interacting &nbspLogistics Common master.	No	No

Table Name po_poins_po_inspection_det

Table Comment This table holds the item Inspection details of &nbsppurchase order document
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
poins_trackable_flag	varchar(5)	NULL	This field is set when the trackable option is allowed. Allowed values are 1.YES 2.NO	No	No
poins_inspection_remarks	varchar(255)	NULL	This field &nbspholds the inspection details for each line item	No	No
poins_std_qual_value	varchar(80)	NULL	This field holds the standard qualitative value	No	No
poins_std_max_value	numeric(28,8)	NULL	This field holds the standard maximum value of the &nbspattribute.	No	No
poins_std_min_value	numeric(28,8)	NULL	This field holds the standard minimum value of the &nbspattribute.	No	No
poins_modifieddate	datetime	NULL	This field &nbspholds the date when the PO inspection detail is modified in the system	No	No
poins_uom	varchar(10)	NULL	This field holds the unit of measurement	No	No
poins_created_by	varchar(30)	NULL	This field &nbspholds the user who created the PO inspection detail	No	No
poins_createddate	datetime	NULL	This field &nbspholds the date when the PO inspection detail is created in the system	No	No
poins_modified_by	varchar(30)	NULL	This field &nbspholds the user who modified the PO inspection detail	No	No
poins_line_no	numeric(10)	NOT NULL	This field holds the Unique identifier for each item requested in the PO	Yes	Yes
poins_po_attribute_id	varchar(40)	NOT NULL	This field holds the unique identifing runing no	Yes	No
poins_po_no	varchar(40)	NOT NULL	This field &nbspholds the Purchase order number	Yes	Yes
poins_ouinstance	float()	NOT NULL	This field holds the &nbspouinstance in which the Inspection details for the line item of the PO have been created	Yes	Yes
poins_std_value	numeric(28,8)	NULL	This field holds the standard value of the &nbspattribute.	No	No
poins_maximum_value	numeric(28,8)	NULL	This field holds the maximum value of the &nbspattribute.	No	No
poins_minimum_value	numeric(28,8)	NULL	This field holds the minimum value of the &nbspattribute.	No	No
poins_attribute_ou	numeric(10)	NULL	This field holds the Organisation unit of the part attribute in which attribute mapped to the part	No	No
poins_attribute_type	varchar(5)	NULL	This field holds the attribute type	No	No
poins_attribute_code	varchar(10)	NULL	This field holds the attribute code for the part &nbspfrom the part admin component.	No	No

Table Name po_poitcd_po_item_tcd

Table Comment This table holds the Part TCD details of &nbsppurchase order document
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
poitcd_created_by	varchar(30)	NULL	This field &nbspholds the user who created the PO part level &nbspTCD	No	No
poitcd_modifieddate	datetime	NULL	This field &nbspholds the date when the PO Part level &nbspTCD is modified in the system	No	No
poitcd_createddate	datetime	NULL	This field &nbspholds the date when the PO Part level &nbspTCD is created in the system	No	No
poitcd_tcd_amount	decimal(28,8)	NULL	The Tcd amount that will be calculated from the TCD component for the TCD code and the variant and the &nbspTCD rate &nbspsupplied	No	No
poitcd_exchg_rate	numeric(28,8)	NULL	Holds the exchage rate between the document currency and the payment currency	No	No
poitcd_modified_by	varchar(30)	NULL	This field &nbspholds the user who modified the PO part level &nbspTCD	No	No
poitcd_user_seqno	numeric(10)	NULL	holds the sequenc number as entered by the user for the TCD	No	No
POITCD_CURRENCY	varchar(20)	NULL	This field &nbspholds the Transaction currency	No	No
Poitcd_Cost_Diff	numeric(28,8)	NULL	This field holds the cost difference of the part after amendement	No	No
poitcd_po_no	varchar(40)	NOT NULL	This field &nbspholds the Purchase order number	Yes	Yes
poitcd_line_no	numeric(10)	NOT NULL	This field holds the Unique identifier for each item requested in the PO	Yes	Yes
poitcd_ouinstance	float()	NOT NULL	This field &nbspholds the &nbspouinstance in which the TCD details for the line item of the PO have been created	Yes	Yes
poitcd_tcd_rate	decimal(28,8)	NULL	TCT rate for the TCD code and the variant . this should not be changed for TCD basis -- Percentage.	No	No
poitcd_tcd_ou	numeric(10)	NULL	This field &nbspholds the tcd ouinstance	No	No
poitcd_serial_no	numeric(10)	NOT NULL	This field &nbspholds the TCD sequence &nbspno (Runing NO)	Yes	No
poitcd_tcd_variant	varchar(25)	NOT NULL	This field &nbspholds the TCD variant &nbspfor the TCD code.	No	No
poitcd_tcd_code	varchar(25)	NOT NULL	This field &nbspholds the Unique identifier for the TCD	No	No

Table Name po_poitm_po_item_details

Table Comment This table holds the item details &nbspof &nbsppurchase order document
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
poitm_ouinstance	float()	NOT NULL	This field &nbspholds the OUinstance in which the PO is created	Yes	Yes
poitm_po_no	varchar(40)	NOT NULL	This field &nbspholds the Purchase order number	Yes	Yes
poitm_line_no	numeric(10)	NOT NULL	Each item(record) requested in the purchase Order is associated with this key .	Yes	No
poitm_quot_line_no	numeric(10)	NULL	This is the quotation line no of the quotation for which the PO is raised.	No	No
poitm_part_no	varchar(40)	NULL	This field &nbspholds the Part number requested in the PO	No	No
poitm_part_ou	numeric(10)	NULL	This field &nbspholds the &nbspcreated ouinstance of the part	No	No
poitm_part_condition	varchar(5)	NULL	This field &nbspcaptures the &nbsppart condition, the values are (N)ew (Ns)New Surplus (O)verhaul (S)erviceable (U)nserviceable	No	No
poitm_order_qty_puom	decimal(28,8)	NULL	This field &nbspholds the Ordered qty of each line item of the PO	No	No
poitm_purchase_uom	varchar(10)	NULL	This field holds &nbspAny valid UOM from the UOM component in which the goods can be purchased .	No	No
poitm_cost	decimal(28,8)	NULL	This field &nbspholds the Cost of the part, depending on cost per, it can be either cost of 1 part or more.	No	No
poitm_cost_per	decimal(28,8)	NULL	This field &nbspholds the Unit cost of the part	No	No
poitm_ship_to_ou	numeric(10)	NULL	This field &nbspholds the &nbspGoods receipt OU mapped to the PO OU	No	No
poitm_sch_type	varchar(5)	NULL	This field &nbspholds the &nbsppurchase order’s schedule type List of values are (S)ingle -- all the requested qty will be delivered in a single &nbspschedule in the same warehouse. (M)ultiple -- the requested qty will be delivered in a staggered schedule dates and stocked in single or separate warehouses.	No	No
poitm_stockadmn_ou	numeric(10)	NULL	This field &nbspholds the stockadmn Ouinstance where the Stock &nbspis registered.	No	No
POITM_ALTERNATE_PART	varchar(5)	NULL		No	No
poitm_inspection_type	varchar(5)	NULL	This field &nbspholds the &nbspInspection types. List of values are (N)one (S)elf (I)By Inspector	No	No
poitm_matching_type	varchar(5)	NULL	This field &nbspholds the matching types. List of values are (Tw)Two Way (Tp)Three way at PO (Tg)Three way at GR (Fp)Four Way at PO (Fg)Four Way at GR	No	No
poitm_tolerance_type	varchar(5)	NULL	This field &nbspholds the tolerance types. list of values are (V)alue (Q)uantity (B)oth (N)one	No	No
poitm_tolerance_percent	decimal(28,8)	NULL	This field &nbspholds the tolerance limit within which we can accept the ordered quantity from the supplier	No	No
poitm_basic_value	decimal(28,8)	NULL	This field holds the basic value. basic value = order qty * &nbspCost / cost per	No	No
poitm_total_tcd_part_val	decimal(28,8)	NULL	This field &nbspholds the Sum of all TCD values of the line item.	No	No
poitm_received_qty_puom	decimal(28,8)	NULL	This field &nbspholds the Quantity received from the supplier	No	No
poitm_accepted_qty_puom	decimal(28,8)	NULL	This field &nbspholds the Qty Received from the Supplier and have been inspected	No	No
poitm_line_status	varchar(5)	NULL	This field &nbspholds the various line &nbspstatuses maintained are 1.(O)pen 2.(N)egative Tolerance closed 3.(Cl)osed	No	No
poitm_quality_attribute		NULL	This fields &nbspholds the Quality Attribute &nbspwith the following values 1. (S)tandard 2. (C)ustom 3. (N)one	No	No
POITM_REF_DOC_OU	numeric(10)	NULL	This field &nbspcaptures the referance document ou that &nbspwhere the document &nbspis created	No	No
POITM_REF_DOC_NO	varchar(40)	NULL	This field &nbspcaptures the referance document no this used to find from &nbspwhere the &nbsporder &nbspis raised.	No	No
POITM_REF_DOC_TYPE	varchar(5)	NULL	This field &nbspcaptures the referance document Type	No	No
POITM_DOC_ATTACH	varchar(5)	NULL	This field &nbspholds the &nbspFlag whether the documents are attached or not for the given part List of values are (Y)es (N)o	No	No
POITM_RCPT_POS_TOL	numeric(28)	NULL	This field &nbspholds the positive tolerance limit within which we can accept the ordered quantity from the supplier	No	No
POITM_RCPT_NEG_TOL		NULL	This field &nbspholds the negative tolerance limit within which we can accept the ordered quantity from the supplier	No	No
POITM_REPLENISHMENT_FLAG	varchar(1)	NULL	This field &nbspholds the Replenishment flag Yes or No	No	No
POITM_REPLENISHMENT_QTY	decimal(28,8)	NULL	This field &nbspholds the Replenishment Qty	No	No
POITM_INSPECTION_WO	varchar(20)	NULL	This field holds the following values (R) -- Required, (NR) -- Not Required, (AR) -- As Required If the user sets the Inspection Type for the line item as Reqd., it is must that he should create a Inspection WO. If he sets it as ’As Reqd.’, then during GR - Edit Inspection Information, he can decide to go for Inspection WO creation or not.	No	No
POITM_CERT_TYPE	sql_variant	NULL	This field holds the Certificate type values	No	No
POITM_CAPEX_PROP_NO	sql_variant	NULL	This field holds the Capex Proposal No. values	No	No
POITM_ACC_USG	sql_variant	NULL	This field holds the AccountCodes values	No	No
POITM_CSTG_USG	sql_variant	NULL	This field holds the Costing Usage Code values	No	No
POITM_ANAL_CODE	sql_variant	NULL	This field holds the Analysis Code values	No	No
POITM_SUBANAL_CODE	sql_variant	NULL	This field holds the Sub Analysis code	No	No
POITM_PART_DESC	sql_variant	NULL	This field holds the Part Description of the part No	No	No
POITM_REMARKS	sql_variant	NULL	This field holds the Remarks	No	No
POITM_SUPP_ESTM_ARRV_DT	sql_variant	NULL	This field holds the Estimated Arrival date of PO line item	No	No
POITM_PROPOSAL_FB_CODE	sql_variant	NULL	This field holds the Finance Book code &nbspof PO line item	No	No
POITM_ALTERNATE_PART_NO	varchar(40)	NULL	This field holds the alternate partno of each line item of po document	No	No
POITM_ALTERNATE_TYPE	varchar(5)	NOT NULL	This field holds the alternate part type Possible values.. SA -Specific Alternate A-Allowed NA-Not Allowed	No	No
POITM_WORKCENTER_CODE	varchar(30)	NULL	This field holds the column to store workcenter code	No	No
Poitm_Value_Diff	numeric(28,8)	NULL	This field holds the difference in PO part item value for the each part after amendment	No	No
POITM_TASKNO	char(18)	NULL	To save the Task # enterd by the used	No	No
POITM_TASK_DISPSEQNO	char(18)	NULL	To save the Task Seq# column values enetered by the user	No	No
POITM_TASK_KEYSEQNO	char(18)	NULL	To Store the internal sequence # for the Task Sequence # which is availlabe in that reference document# gven in PO multiline	No	No
POITM_CORE_PARTNO	varchar(40)	NULL	To save the Core Part# entered by the user	No	No
POITM_CORE_SERIALNO	varchar(40)	NULL	To save the core serial # entered by the user	No	No
POITM_CORE_LOTNO	varchar(40)	NULL	To save the Core lot# entered by the user	No	No
POITM_CUSORDNO	varchar(40)	NULL	To save the customer Order # for the reference document# in the PO multiline details.	No	No
POITM_RCP_RCD_OPT	char()	NULL	To maintain the Receipt Recording Option at the line level.	No	No
POITM_CAP_THRSHOLD_AMT	bigint	NULL	To capture the Threshold Amount from CPS Component while creating PO	No	No
POITM_THRSHOLD_FAIL	sql_variant	NULL	To capture, Flag value ’Y’, If value of POCost is lesser then or equal to thrshold amount mentioned in CPS component.	No	No
POITM_EXCHANGE_RATE	numeric(9,15)	NULL	This column holds the exchange rate	No	No
POITM_REP_WHID	varchar(10)	NULL	This column holds the replenishment warehouse	No	No
POITM_PART_TYPE	varchar(5)	NULL	This field corresponds to the part type defined in part master.	No	No
POITM_PART_EXPTYPE	varchar(25)	NULL	This field corresponds to the control type of the part.	No	No
POITM_PART_NONSTKFLG	varchar(20)	NULL	This field corresponds to the part expence policy as defined in part master.	No	No
POITM_PART_EXPOLICY	varchar(5)	NULL	This field corresponds to the expence type of the part as defined in part master.	No	No

Table Name po_popr_po_prbased_details

Table Comment This table holds the &nbsppurchase order document in which the purchase request are raised
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
popr_prline_no	numeric(10)	NULL	This field &nbspholds the Unique identifier for each item requested in the Purchase request	No	No
popr_pr_ouistance	numeric(10)	NULL	This field &nbspholds the &nbspOUinstance in which the PR is created	No	No
popr_pr_no	varchar(40)	NULL	This field &nbspholds the Purchase Request #	No	No
popr_covered_qty	decimal(28,8)	NULL	This field &nbspholds the PR covered quantity PR covered quantity = &nbspPR covered quantity - PR order quantity	No	No
popr_pr_sch_no	numeric(10)	NULL	This field holds the corrsponding covered PR sch id	No	No
POPR_GR_MVD_QTY	decimal(28,8)	NULL	This field holds the GR moved quantity when GR movment happen	No	No
popr_po_no	varchar(40)	NOT NULL	This field &nbspholds the Purchase order number	Yes	Yes
popr_ouinstance	float()	NOT NULL	This field &nbspholds the OUinstance in which the PO is created	Yes	Yes
popr_amend_no	numeric(10)	NOT NULL	This field holds the latest Amendment #	No	No
popr_serial_no	numeric(10)	NOT NULL	This item holds PR Serial No	Yes	No
popr_line_no	numeric(10)	NOT NULL	Each item(record) requested in the purchase Order is associated with this key .	Yes	Yes
popr_sch_no	numeric(10)	NOT NULL	This field holds the PO sch id specific to each line item	Yes	No
POPR_PRGR_MVD_QTY	decimal(28,8)	NULL	This field holds the GR moved quantity when GR movment happen	No	No

Table Name PO_POPrm_parameter_details

Table Comment Used to Store the Parameter Details of the PO Document
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
PoPrm_Componentname	varchar(150)	NOT NULL	This field holds the Name of the component.	Yes	No
PoPrm_Paramcategory	varchar(10)	NOT NULL	This field will 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
PoPrm_Paramtype	varchar(25)	NOT NULL	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
PoPrm_Paramcode	varchar(5)	NOT NULL	This is the code that may be used for data storage. This is valid only incase of combo boxes. Here the short code that will be stored as data in the transaction could be maintained.	Yes	No
PoPrm_Langid	numeric(10)	NOT NULL	Language id. This is the language id of the record.	Yes	No
PoPrm_Paramdesc	varchar(80)	NOT NULL	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
PoPrm_Sortby	numeric(10)	NULL	This field holds the default sort by code	No	No
PoPrm_Createddate	datetime	NULL	This field holds the record created date for auditing purpose	No	No

Table Name Po_PoROd_Ref_Obj_dtl

Table Comment This table is Used to store information for the reference object details for the PO Document
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
porod_created_date	datetime	NULL	This field &nbspholds the date when the PO refererce object detail is created in the system	No	No
porod_ref_doc_file_Name	varchar(50)	NULL	This field hold the Reference document file name	No	No
porod_ref_doc_id	varchar(40)	NULL	This field hold the Reference documentid	No	No
porod_created_by	varchar(30)	NULL	This field &nbspholds the user who created &nbspthe PO refererce object detail	No	No
porod_modified_date	datetime	NULL	This field &nbspholds the date when the PO refererce object detail is modified in the system	No	No
porod_modified_by	varchar(30)	NULL	This field &nbspholds the user who modified &nbspthe PO refererce object detail	No	No
porod_po_no	varchar(40)	NOT NULL	This field &nbspholds the Purchase order number	Yes	Yes
porod_created_ouinstance	decimal(10)	NOT NULL	This field &nbspholds the &nbspouinstance &nbspof the PO have been created	Yes	Yes
porod_ref_doc_type	varchar(25)	NULL	This field hold the list of Reference document types defined in the Common Master component	No	No
porod_doc_line_id	numeric(10)	NOT NULL	This is just a unique &nbsprunning number for identifying a record for each PO document .	Yes	No
POROD_PO_LINE_NO	numeric(10)	NOT NULL	This field holds the Unique identifier for each part &nbsprequested in the PO	No	No

Table Name po_posc_sup_corr_details

Table Comment This table holds supplier correspondence details for a PO document subsequent to the authorization of the PO and the document is received by the supplier.
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
posc_createddate	datetime	NULL	This field holds the date on which the supplier correspondence details for a PO line item is created	No	No
posc_buyer_remarks	varchar(255)	NULL	This field holds the buyer remarks	No	No
posc_supp_remarks		NULL	This field holds the supplier remarks	No	No
posc_created_by	varchar(30)	NULL	This field holds the user id by whom the supplier correspondence details for a PO line item is created	No	No
posc_modifieddate	datetime	NULL	This field holds the date on which the supplier correspondence details for a PO line item is modified	No	No
posc_modified_by	varchar(30)	NULL	This field holds the user id by whom the supplier correspondence details for a PO line item is modified	No	No
posc_po_no	varchar(40)	NOT NULL	This field &nbspholds the Purchase order number	Yes	Yes
posc_ouinstance	float()	NOT NULL	This field &nbspholds the OUinstance in which the supplier/buyer remarks details for the PO are created
posc_date	datetime	NULL	This field holds the date on which the correspodence details are entered	No	No
posc_po_line_no	numeric(10)	NOT NULL	Each item(record) requested in the purchase Order is associated with this key .	Yes	Yes
posc_line_no	numeric(10)	NOT NULL	This field holds the line nos for the remarks entered for the combination of PO#, Amendment# and PO line item#		No

Table Name po_posch_po_sch_details

Table Comment This table holds the item schedule details of &nbsppurchase order document
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
posch_sch_status	varchar(5)	NULL	This field &nbspholds &nbspthe &nbspschedule &nbspstatus.	No	No
posch_moved_qty_puom	decimal(28,8)	NULL	This field holds &nbspthe qty that has been received from the supplier and moved to the warehouse	No	No
posch_wh_code	varchar(10)	NULL	This field &nbspholds the Warehouse in which the schedule qty has to be moved	No	No
posch_modifieddate	datetime	NULL	This field &nbspholds the date when the PO schedule details modified in the system	No	No
posch_createddate	datetime	NULL	This field &nbspholds &nbspthe date when the PO schedule details created in the system	No	No
posch_created_by	varchar(30)	NULL	This field &nbspholds &nbspthe user who created the PO schedule details	No	No
posch_modified_by	varchar(30)	NULL	This field &nbspholds the user who modified the PO schedule details	No	No
posch_po_no	varchar(40)	NOT NULL	This field &nbspholds the Purchase order number	Yes	Yes
posch_ouinstance	float()	NOT NULL	This field &nbspholds the &nbspouinstance in which the schedule details for the line item of the PO have been created	Yes	Yes
posch_sch_date	datetime	NULL	This field &nbspholds the date in which the schedule qty has to be delivered.	No	No
posch_sch_qty_puom	decimal(28,8)	NULL	This field &nbspholds the Schedule quantity	No	No
posch_line_no	numeric(10)	NOT NULL	This field &nbspholds the Unique identifier for each item requested in the PO	Yes	Yes
posch_sch_no	numeric(10)	NOT NULL	This field holds the Unique identifier for each schedule of the line item	Yes	No

Table Name PO_POSOPT_SETOPTION_INFO

Table Comment This table holds the Set option for PO component
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
POSOPT_PO_OUINSTANCE	decimal(10)	NULL	This field &nbspholds the &nbspouinstance in which the PO Options had set	No	No
POSOPT_AUTO_PO_NUM_TYPE	varchar(25)	NULL	This field holds the Numbering type for Auto Po generation	No	No
POSOPT_MULTI_PRT_TYP_ALLOWED	varchar(5)	NULL	This field holds the flag Yes or No for Multi part type allowed	No	No
POSOPT_ALLOW_UNSRVCBLE_PRTS	varchar(5)	NULL	This field holds Yes or No flag to allow unservicable parts	No	No
POSOPT_DEF_RCPT_TOL	varchar(5)	NULL	This field holds whether the positive and negative receipt tolerance value must be defaulted from Part Administration business component or not. Select "Default from Part Admin" to default the value from Part Administration business component. Select "Do not Default from Part Admin", if the value must not be defaulted.	No	No
POSOPT_CREATED_DATE	datetime	NULL	This field &nbspholds &nbspthe date when the PO Set option details created in the system	No	No
POSOPT_CREATED_BY	varchar(40)	NULL	This field &nbspholds &nbspthe user who created the PO Set option details	No	No
POSOPT_MODIFIED_DATE	datetime	NULL	This field &nbspholds the date when the PO Set option details modified in the system	No	No
POSOPT_MODIFIED_BY	varchar(40)	NULL		No	No
POSOPT_ALLOW_ORDG_REV_CAP_PO	sql_variant	NULL	This field holds Yes or No flag to allow ordering revenue under capital PO	No	No
POSOPT_PO_COST_AMD_ALLOWED	varchar(5)	NULL	This field holds Yes(Y) or No(N) &nbspflag to allow cost amendment for Exchange, Service and Adhoc PO’s	No	No
POSOPT_PO_POPARTCOST	sql_variant	NULL		No	No
POSOPT_PO_PRTLDTIME	sql_variant	NULL		No	No
POSOPT_ALLOW_CLOSE_PO	sql_variant	NULL	To save the value selected in the field ’Allow amendment of Closed PO’	No	No

Table Name po_potmcn_po_terms_condns

Table Comment This table holds the Terms and Condition of &nbsppurchase order document
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
potmcn_ouinstance	decimal(10)	NOT NULL	This field &nbspholds the &nbspouinstance in which the Term and condition &nbspdetails of the PO have been created	Yes	Yes
potmcn_po_no	varchar(40)	NOT NULL	This field &nbspholds the Purchase order number	Yes	Yes
potmcn_payterm_code	varchar(25)	NULL	This field &nbspholds the Unique identifier for the Payterm	No	No
potmcn_pay_to_supp	varchar(45)	NULL	A valid supplier defined in the Supplier component &nbspand mapped to the Supplier (who supplies the &nbspgoods requested )as pay to supplier ( to whom the payment can be made)	No	No
potmcn_pay_to_supp_ou	numeric(10)	NULL	This field &nbspholds the pay to &nbspsupplier Ouinstance where the supplier is registered.	No	No
potmcn_payment_mode	varchar(5)	NULL	This field &nbspholds &nbspvarous payment mode. list of values are (Cq)Check (Cs)Cash (DD)Demand Draft (P)ay order (O)rder (CC)Credit Card	No	No
potmcn_insurance_terms	varchar(150)	NULL	This field holds the insurence term of &nbsppurchase order document.	No	No
potmcn_insurance_liability	varchar(25)	NULL	This field &nbspholds &nbspinsurance liability of the PO document List of values are (O)urs (S)upplier (Ot)her	No	No
potmcn_insurance_amt	decimal(28,8)	NULL	This field holds the insurence amount of &nbspthe purchase order document.	No	No
potmcn_inco_term	varchar(150)	NULL	This field holds the &nbspINCO term of &nbspthe purchase order document.	No	No
potmcn_delivery_point	varchar(255)	NULL	This field holds the delivery point &nbspof &nbspthe purchase order document.	No	No
potmcn_trans_shipment	varchar(5)	NULL	This field holds the transshipment of &nbspthe purchase order document. List of values (Y)es (N)o	No	No
potmcn_ship_partial	varchar(5)	NULL	This field holds the ship partial of &nbspthe purchase order document. List of values (Y)es (N)o	No	No
potmcn_pay_priority	varchar(5)	NULL	This field holds the &nbsppayment priority of the PO doument List of values are 1.High, 2.Normal 3.Low	No	No
potmcn_ship_by	varchar(25)	NULL	Populate the ship by combo with the list of shipping methods in active status defined in the Logistics common master component.	No	No
potmcn_pkg_code	varchar(25)	NULL	Populate the packaging code combo with the list of packaging codes in active status defined in the Logistics common master component.	No	No
potmcn_ship_payment	varchar(25)	NULL	This field holds the list of shipping payment methods in active status defined in the Logistics common master component.	No	No
potmcn_remarks	varchar(255)	NULL	This field holds the remarks &nbspof &nbspthe purchase order documen’s terms and condition.	No	No
potmcn_createddate	datetime	NULL	This field &nbspholds the date when the PO term and condition created in the system	No	No
potmcn_created_by	varchar(30)	NULL	This field &nbspholds the user who created the PO &nbspterms and conditions	No	No
potmcn_modifieddate	datetime	NULL	This field &nbspholds the date when the PO term and condition modified in the system	No	No
potmcn_modified_by	varchar(30)	NULL	This field &nbspholds the user who modified the PO &nbspterms and conditions	No	No
POTMCN_GTA_REFDOC_NO	varchar(40)	NULL	This field &nbspholds the General Terms Agreement &nbspreference documentno	No	No
POTMCN_REFDOC_DATE	datetime	NULL	This field &nbspholds the General Terms Agreement &nbspreference document Date	No	No
POTMCN_GTA_REMARKS	varchar(255)	NULL	This field &nbspholds the General Terms Agreement &nbspremarks	No	No
POTMCN_WARRANTY	varchar(5)	NULL	This field holds the warranty flag &nbspof &nbspthe purchase order document. List of values (Y)es (N)o	No	No
POTMCN_WARR_BASIS	varchar(25)	NULL	This field holds the Warranty basis &nbspof &nbspthe purchase order document. List of values 1. Both 2. calender 3. Usage	No	No
POTMCN_WARR_AGREEMENT_NO	varchar(40)	NULL	This field holds the Warranty agreement no . if warrant flag is ’yes’ then warranty agreement no is mandatory	No	No
POTMCN_ADVANCE_PAY_AMT	numeric(28)	NULL	This field holds the advance payable amount. If advance payable flag is ’yes’ then this is mandatory	No	No
POTMCN_ADVANCE_PAYDATE	datetime	NULL	This field holds the advance payable date. If advance payable flag is ’yes’ then this is mandatory	No	No
POTMCN_ADVANCE_PERC	numeric(28)	NULL	This field holds the advance percentage.	No	No
POTMCN_ADVANCE_PERC_ON	varchar(25)	NULL	This field holds the advance percentage on &nbspof &nbspthe purchase order document. List of values 1. Basic Value 2. Total Value	No	No
POTMCN_ADVANCE_PAYABLE	varchar(5)	NULL	This field holds the advance payable &nbspflag &nbspof &nbspthe purchase order document. List of values (Y)es (N)o	No	No
POTMCN_ADVANCE_TOL_PERC	numeric(28)	NULL	This field holds the advance tolerence &nbsppercentage.	No	No
POTMCN_DDCHARGES_BORNEBY	varchar(25)	NULL	This field holds the DD charges brone by &nbspof &nbspthe purchase order document. List of values 1. self 2.supplier	No	No
POTMCN_PAY_TO_SUPP_ID	numeric(10)	NULL	This field &nbspholds the &nbsppay to supplier address ids	No	No
POTMCN_PAYMENT_NOTES	varchar(2000)	NULL	This field &nbspholds the &nbsppayment notes	No	No
POTMCN_PACKAGING_NOTES	varchar(2000)	NULL	This field &nbspholds the packaging notes	No	No
POTMCN_PORT_OF_DEP	varchar(32)	NULL	This field &nbspholds the port of depature	No	No
POTMCN_CARRIERAGENCY	varchar(20)	NULL	This field &nbspholds the list of carrier agencies	No	No
POTMCN_SHIPPING_NOTES	varchar(2000)	NULL	This field &nbspholds the &nbspshipping notes	No	No
POTMCN_FWD_CVR_RATE	bigint	NULL	This field &nbspholds the &nbspForward Covering Rate	No	No
POTMCN_INV_AT	sql_variant	NULL	This field &nbspholds the Invoice At	No	No
POTMCN_FWD_CVR_APPL	sql_variant	NULL	This field &nbspholds the Forward Cover Applicable	No	No
POTMCN_ADV_PAID	bigint	NULL		No	No
POTMCN_WARRBEGINS	char(18)	NULL	To save the Warranty begni on combo valued from PO Terms and conditions page	No	No
POTMCN_DURATION	int	NULL	To save the Warranty duration details entered by the user	No	No
POTMCN_DURPERIOD	char(18)	NULL	To save the warranty duration period combo values selected by the user.	No	No
POTMCN_FLIGHTHRS	int	NULL	To save the Floght Hours entered by the user	No	No
POTMCN_FLIGHTCYCLES	int	NULL	To save the Flight cycles entered by the user	No	No
POTMCN_TERMS_REFERENCE	varchar(255)	NULL	To save the Terms and reference enterd by the user in PO terms and condtions details page.	No	No
POTMCN_RMANO	sql_variant	NULL	To capture the RMA Number	No	No
POTMCN_RMADATE	datetime	NULL	To capture the RMA date for the given RMA No	No	No
POTMCN_RET_SUPP_ID	sql_variant	NULL	To populate the ’Pay To Supplier Address ID’ combo with all the ’Address Id’ of the supplier	No	No

Table Name PO_POUdi_User_Def_Info

Table Comment This table holds the User define information &nbspof &nbsppurchase order document
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
poudi_user_def_opt4	varchar(30)	NULL	This field holds the fourth user defined option	No	No
poudi_user_def_remarks	varchar(255)	NULL	This field holds the user defined remarks	No	No
poudi_user_def_desc4	varchar(30)	NULL	This field holds the fourth description of user defined options.	No	No
poudi_user_def_opt3	varchar(30)	NULL	This field holds the third user defined option	No	No
poudi_modified_date	datetime	NULL	This field &nbspholds the date when the PO inspection detail is modified in the system	No	No
poudi_created_date	datetime	NULL	This field &nbspholds the date when the PO user define information is created in the system	No	No
poudi_created_by	varchar(30)	NULL	This field &nbspholds the user who created &nbspthe PO user define information	No	No
poudi_modified_by	varchar(30)	NULL	This field &nbspholds the user who modified &nbspthe PO user define information	No	No
poudi_po_no	varchar(40)	NOT NULL	This field &nbspholds the Purchase order number	Yes	Yes
poudi_user_def_desc1	varchar(30)	NULL	This field holds the first description of user defined options.	No	No
poudi_ouinstance	decimal(10)	NOT NULL	This field holds the ouinstance in which the the user define information for the Purchase order &nbspcreated	Yes	Yes
poudi_user_def_desc3	varchar(30)	NULL	This field holds the third description of user defined options.	No	No
poudi_user_def_opt2	varchar(30)	NULL	This field holds the second user defined option	No	No
poudi_user_def_opt1	varchar(30)	NULL	This field holds the first user defined option	No	No
poudi_user_def_desc2	varchar(30)	NULL	This field holds the second description of user defined options.	No	No

BasPO