Data Dictionary -- Purchase Order

Srl. No.	Table Name	Comment
1	PO_ADTcdAP_DocTcd_Apportioned	This table holds the Document TCD Apportioning details of Amended purchase order
2	PO_DTcdAP_DocTcd_Apportioned	This table holds the Document TCD Apportioning details of purchase order
3	PO_ExISuRCpt_SL_Reconcile_Dtl	This table holds the Exchange Purchase order information
4	po_fin_tcd_dtl	This table holds the TCD informations in PO Line Level
5	PO_POADSD_DROP_SHIP_DTL	This table holds the Dropship details of amended purchase order document
6	PO_POADTCD_PO_DOC_TCD	This table holds the Document TCD details of Amended purchase order.
7	PO_POAHDR_PO_HEADER	This table holds the Amended purchase order document details
8	PO_POAINS_PO_INSPECTION_DET	This table holds the item Inspection details of Amended purchase order document
9	PO_POAITCD_PO_ITEM_TCD	This table holds the Part TCD details of Amended purchase order document
10	PO_POAITM_PO_ITEM_DETAILS	This table holds the item details of Amended purchase order document
11	PO_POAPR_PO_PRBASED_DETAILS	This table holds the Amended purchase order document in which the purchase request are raised
12	PO_POAPR_PO_PRBASED_DTL	PO_POAPR_PO_PRBASED_DTL
13	PO_POAROD_REF_OBJ_DTL	This table is Used to store information for the reference object details for the Amended PO Document
14	PO_POASCH_PO_SCH_DETAILS	This table holds the item schedule details of Amended purchase order document
15	PO_POASC_SUP_CORR_DETAILS	This table holds supplier correspondence details for an amended PO document
16	PO_POATMCN_PO_TERMS_CONDNS	This table holds the Terms and Condition of Amended purchase order document
17	PO_POAUDI_USER_DEF_INFO	This table holds the User define information of Amended purchase order document
18	PO_PODSD_DROP_SHIP_DTL	This table holds the Dropship details of purchase order document
19	PO_PODTCD_PO_DOC_TCD	This table holds the Document TCD details of purchase order.
20	PO_POHDR_PO_HEADER	This table holds the purchase order document details
21	PO_POINS_PO_INSPECTION_DET	This table holds the item Inspection details of purchase order document
22	PO_POITCD_PO_ITEM_TCD	This table holds the Part TCD details of purchase order document
23	PO_POitmVar_Variance_Details	This table holds the purchase order variance information
24	PO_POITM_PO_ITEM_DETAILS	This table holds the item details of purchase order document
25	PO_POPRM_PARAMETER_DETAILS	Used to Store the Parameter Details of the PO Document
26	PO_POPR_PO_PRBASED_DETAILS	This table holds the purchase order document in which the purchase request are raised
27	PO_POPR_PO_PRBASED_DTL	PO_POPR_PO_PRBASED_DTL
28	PO_POROD_REF_OBJ_DTL	This table is Used to store information for the reference object details for the PO Document
29	PO_POSCH_PO_SCH_DETAILS	This table holds the item schedule details of purchase order document
30	PO_POSC_SUP_CORR_DETAILS	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.
31	PO_POSOPT_SETOPTION_INFO	This table holds the Set option for PO component
32	PO_POTMCN_PO_TERMS_CONDNS	This table holds the Terms and Condition of purchase order document
33	PO_POUDI_USER_DEF_INFO	This table holds the User define information of purchase order document

Table Name :	PO_ADTcdAP_DocTcd_Apportioned
Comment :	This table holds the Document TCD Apportioning details of Amended purchase order

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ADTcdAP_PartlineId	udd_seqno	int(4)	No	This field holds the Unique identifier for each item requested in the PO	No
ADTcdAP_DTcdlineid	udd_seqno	int(4)	No	This field holds the Unique identifier for each items TCD Line ID requested in the PO	No
ADTcdAP_tcdamount_bas	udd_amount	numeric(13)	Yes	This field holds Tcd amount that will be calculated from the TCD component for the TCD code ,variant TCD rate,Base currency supplied.	No
ADTcdAP_tcdamount_par	udd_amount	numeric(13)	Yes	This field holds Tcd amount that will be calculated from the TCD component for the TCD code ,variant TCD rate,Parellel currency supplied.	No
ADTcdAP_ApportVal_Bas	udd_amount	numeric(13)	Yes	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
ADTcdAP_ApportVal_Par	udd_amount	numeric(13)	Yes	This field holds Apportioning Tcd amount that will be calculated from the TCD component for the TCD code ,variant TCD rate,Parellel currency supplied.	No
ADTcdAP_Accrule	udd_designparamcode	varchar(5)	Yes	This field holds the Code of Accounting rule 1.ATS - Add to Stock 2. E - Expense	No
ADTcdAP_Recover_Bas	udd_amount	numeric(13)	Yes	The amount Recovered through TCD in base currecncy i.e if discount is tcd and wat is accual amount we recovered through that TCD	No
ADTcdAP_Recover_Par	udd_amount	numeric(13)	Yes	The amount Recovered through TCD in parallel base currecncy i.e if discount is tcd and what is actual amount	No
ADTcdAP_NonRecover_Bas	udd_amount	numeric(13)	Yes	The amount which not Recovered through TCD in base currecncy i.e if discount is tcd and what is actual amount	No
ADTcdAP_NonRecover_Par	udd_amount	numeric(13)	Yes	The amount which not Recovered through TCD in parallel base currecncy i.e if discount is tcd and what is actual amount	No
ADTCDAP_TCDAMOUNT_TRN	udd_amount	numeric(13)	Yes	TCD amount in TCD Transaction	No
ADTCDAP_APPORTVAL_TRN	udd_amount	numeric(13)	Yes	Approved TCD amount in TCD Transaction	No
ADTCDAP_NONRECOVER_TRN	udd_amount	numeric(13)	Yes	Non - recover TCD amount in TCD Transaction	No
ADTCDAP_RECOVER_TRN	udd_amount	numeric(13)	Yes	Recover TCD amount in TCD Transaction	No
ADTcdAP_PO_No	udd_documentno	varchar(40)	Yes	This field holds the Purchase order number	No
ADTcdAP_PO_Ou	udd_ctxt_ouinstance	int(4)	Yes	This field holds the ouinstance in which the Document level TCD of the PO have been created	No
ADTcdAP_TCD_CODE	_varchar_30	varchar(30)	Yes	This field holds the Unique identifier for the TCD	No
ADTcdAP_TCD_VARIANT	udd_txt255	varchar(255)	Yes	This field holds the TCD variant for the TCD code.	No
AdtcdAP_TCD_Diff	udd_amount	numeric(13)	Yes	This field holds the difference amount of TCD after amendment for doing postings	No
AdTcdAP_Amend_No	udd_seqno	int(4)	Yes	This field holds the purchase order amendment number.	No
REPLICATION_KEY	_bigint_8	Bigint(8)	No	Unique Number	Yes
ADTcdAP_TCD_INCIDENCE	udd_taxinci	Varchar(40)	Yes	This field holds the TCD Incidence	No

Table Name :	PO_DTcdAP_DocTcd_Apportioned
Comment :	This table holds the Document TCD Apportioning details of purchase order

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
DTcdAP_PartlineId	udd_seqno	int(4)	No	This field holds the Unique identifier for each item requested in the PO	No
DTcdAP_DTcdlineid	udd_seqno	int(4)	No	This field holds the Unique identifier for each items TCD Line ID requested in the PO	No
DTcdAP_tcdamount_bas	udd_amount	numeric(13)	Yes	This field holds Tcd amount that will be calculated from the TCD component for the TCD code ,variant TCD rate,Base currency supplied.	No
DTcdAP_tcdamount_par	udd_amount	numeric(13)	Yes	This field holds Tcd amount that will be calculated from the TCD component for the TCD code ,variant TCD rate,Parellel currency supplied.	No
DTcdAP_ApportVal_Bas	udd_amount	numeric(13)	Yes	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
DTcdAP_ApportVal_Par	udd_amount	numeric(13)	Yes	This field holds Apportioning Tcd amount that will be calculated from the TCD component for the TCD code ,variant TCD rate,Parellel currency supplied.	No
DTcdAP_Accrule	udd_designparamcode	varchar(5)	Yes	This field holds the Code of Accounting rule 1.ATS - Add to Stock 2. E - Expense	No
DTcdAP_Recover_Bas	udd_amount	numeric(13)	Yes	Recovered Basic Value	No
DTcdAP_Recover_Par	udd_amount	numeric(13)	Yes	Recovered Value	No
DTcdAP_NonRecover_Bas	udd_amount	numeric(13)	Yes	Non Recovered Amount	No
DTcdAP_NonRecover_Par	udd_amount	numeric(13)	Yes	Non Recovered Value	No
DTCDAP_TCDAMOUNT_TRN	udd_amount	numeric(13)	Yes	Transaction TCD Amount	No
DTCDAP_APPORTVAL_TRN	udd_amount	numeric(13)	Yes	Apportioning Value	No
DTCDAP_NONRECOVER_TRN	udd_amount	numeric(13)	Yes	Non Recovered Transaction Amount	No
DTCDAP_RECOVER_TRN	udd_amount	numeric(13)	Yes	Recovered Transaction Value	No
DTcdAP_PO_No	udd_documentno	varchar(40)	Yes	This field holds the Purchase order number	No
DTcdAP_PO_Ou	udd_ctxt_ouinstance	int(4)	Yes	This field holds the ouinstance in which the Document level TCD of the PO have been created	No
DTcdAP_TCD_CODE	_varchar_30	varchar(30)	Yes	This field holds the Unique identifier for the TCD	No
DTcdAP_TCD_VARIANT	udd_text255	varchar(255)	Yes	This field holds the TCD variant for the TCD code.	No
DtcdAP_TCD_Diff	udd_amount	numeric(13)	Yes	This field holds the TCD delta value beween previous amended value with currend values.	No
DTcdAP_Amend_No	udd_seqno	int(4)	Yes	This field holds the purchase order amendment number.	No
REPLICATION_KEY	_bigint_8	Bigint(8)	No	Unique Number	Yes
DTcdAP_TCD_INCIDENCE	udd_taxinci	Varchar(40)	Yes	This field holds the TCD Incidence	No

Table Name :	PO_ExISuRCpt_SL_Reconcile_Dtl
Comment :	This table holds the Exchange Purchase order information

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

Table Name :	po_fin_tcd_dtl
Comment :	This table holds the TCD informations in PO Line Level

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
potcd_poou	udd_ctxt_ouinstance	int(4)	No	Po OU	No
potcd_pono	udd_documentno	varchar(40)	No	PO number	No
potcd_poamendmentno	udd_seqno	int(4)	No	po Amendment number	No
potcd_polineno	udd_seqno	int(4)	No	po lineno	No
potcd_tcdcode	udd_quickcodes	varchar(25)	No	Tcd code	No
potcd_tcdvariant	udd_quickcodes	varchar(25)	No	Tcd variant	No
potcd_tcdversionno	udd_seqno	int(4)	No	Tcd version Number	No
potcd_currency	udd_currencycode	varchar(5)	No	Tcd Currency	No
potcd_suppliercode	udd_vendorcode	varchar(45)	No	Supplier code	No
potcd_exchangerate	udd_rate	numeric(13)	No	Exchange Rate	No
potcd_tcdamount	udd_amount	numeric(13)	No	TCD amount	No
REPLICATION_KEY	_bigint_8	Bigint(8)	No	REPLICATION KEY	No

Table Name :	PO_POADSD_DROP_SHIP_DTL
Comment :	This table holds the Dropship details of amended purchase order document

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
POADSD_OUINSTANCE	_decimal_10_0	decimal(10)	No	This field holds the ouinstance in which the dropship details for the line item of the PO have been created	Yes
POADSD_PO_NO	_varchar_40	varchar(40)	No	This field captures the Purchase order number.	Yes
POADSD_AMEND_NO	_decimal_10_0	decimal(10)	No	This field captures the amendment no of the PO documents.	Yes
POADSD_LINE_NO	_numeric_28_0	numeric(28)	No	Each item record requested in the purchase Order is associated with this key .	Yes
POADSD_COMP_NAME	_varchar_150	varchar(150)	Yes	This field holds the company name for the shipment	No
POADSD_ADDR_1	_varchar_255	varchar(255)	Yes	This field holds the company address1 for the shipment	No
POADSD_ADDR_2	_varchar_255	varchar(255)	Yes	This field holds the company address2 for the shipment	No
POADSD_ADDR_3	_varchar_255	varchar(255)	Yes	This field holds the company address3 for the shipment	No
POADSD_CITY	_varchar_32	varchar(32)	Yes	This field holds the city of the company for shipment	No
POADSD_ZIP_CODE	_varchar_15	varchar(15)	Yes	This field holds the zip code of the company for shipment	No
POADSD_STATE	_varchar_32	varchar(32)	Yes	This field holds the state of the company for shipment	No
POADSD_COUNTRY	_varchar_40	varchar(40)	Yes	This field holds the country of the company for shipment	No
POADSD_CONTACT_PERSON	_varchar_80	varchar(80)	Yes	This field holds the contact person of the company for shipment	No
POADSD_PHONE_NO	_varchar_70	varchar(70)	Yes	This field holds the phone no of the company for shipment	No
POADSD_FAX_NO	_varchar_70	varchar(70)	Yes	This field holds the fax details of the company for shipment	No
POADSD_EMAIL	_varchar_70	varchar(70)	Yes	This field holds the email id of the company for shipment	No
POADSD_SHIP_ALL_ITM	_varchar_5	varchar(5)	Yes	This field holds the flag whether Ship All Items to the same Location or not the values may be YES or NO	No
POADSD_REMARKS	_varchar_255	varchar(255)	Yes	This field holds the remarks of the shipment	No

Table Name :	PO_POADTCD_PO_DOC_TCD
Comment :	This table holds the Document TCD details of Amended purchase order.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
POADTCD_OUINSTANCE	_decimal_10_0	decimal(10)	No	This field holds the ouinstance in which the Document level TCD of the PO have been created	Yes
POADTCD_PO_NO	_varchar_40	varchar(40)	No	This field holds the Purchase order number	Yes
POADTCD_AMEND_NO	_decimal_10_0	decimal(10)	No	This field holds the purchase order amendment number.	Yes
POADTCD_TCD_CODE	_varchar_25	Varchar(25)	No	This field holds the Unique identifier for the TCD	No
POADTCD_SERIAL_NO	_decimal_10_0	decimal(10)	No	This field holds the Unique identifier number for the TCD of the PO.	Yes
POADTCD_TCD_VARIANT	_varchar_25	Varchar(25)	No	This field holds the TCD variant for the TCD code.	No
POADTCD_TCD_RATE	_decimal_28_8	decimal(28)	Yes	TCD rate for the TCD code and the variant . this should not be changed for TCD basis -- Percentage.	No
POADTCD_TCD_AMOUNT	_decimal_28_8	decimal(28)	Yes	The Tcd amount that will be calculated from the TCD component for the TCD code and the variant and the TCD rate supplied.	No
POADTCD_PAY_TO_SUPP	_varchar_45	varchar(45)	Yes	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
POADTCD_CREATEDDATE	_datetime_8	datetime(8)	Yes	This field holds the date when the PO Doc TCD is created in the system	No
POADTCD_CREATED_BY	_varchar_30	varchar(30)	Yes	This field holds the user who created the PO Doc TCD	No
POADTCD_MODIFIEDDATE	_datetime_8	datetime(8)	Yes	This field holds the date when the PO Doc TCD is modified in the system	No
POADTCD_MODIFIED_BY	_varchar_30	varchar(30)	Yes	This field holds the user who modified the PO Doc TCD	No
POADTCD_TCD_OU	_decimal_10_0	decimal(10)	Yes	This field holds the tcd ouinstance	No
POADTCD_CURRENCY	_varchar_20	varchar(20)	Yes	This field holds the Transaction currency	No
POADTCD_USER_SEQNO	_decimal_10_0	decimal(10)	Yes	holds the sequence number entered for the TCD by the user	No
POADTCD_EXCHG_RATE	_decimal_28_8	decimal(28)	Yes	Holds the exchage rate between the document currency and the payment currency	No
POADTCD_CHRG_TYPE	udd_designparamcode	varchar(5)	Yes	To store values of Document   tcd charge type either  Payable or negotable	No
POADTCD_TCD_INCIDENCE	udd_taxinci	Varchar(40)	Yes	This field holds the TCD Incidence	No

Table Name :	PO_POAHDR_PO_HEADER
Comment :	This table holds the Amended purchase order document details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
POAHDR_OUINSTANCE	_decimal_10_0	decimal(10)	No	This field holds the Purchase order created ouinstance	Yes
POAHDR_PO_NO	_varchar_40	varchar(40)	No	This field holds the Purchase order number	Yes
POAHDR_AMEND_NO	_decimal_10_0	decimal(10)	No	This field holds the purchase order amendment number.	Yes
POAHDR_PO_DATE	_datetime_8	datetime(8)	No	This field holds the Purchase order creation date .	No
POAHDR_PO_STATUS	_varchar_5	varchar(5)	No	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	No
POAHDR_PO_TYPE	_varchar_5	varchar(5)	Yes	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 gnme	No
POAHDR_SUPP_CODE	_varchar_45	varchar(45)	Yes	This field holds the Supplier code from the supplier component who has raise the purchase order.	No
POAHDR_SUPPLIER_OU	_decimal_10_0	decimal(10)	Yes	This field holds the Supplier OUinstance from the supplier component	No
POAHDR_SUPP_CREATED_OU	_decimal_10_0	decimal(10)	Yes	This field holds the Supplier OUinstance from the supplier component where the supplier code is created.	No
POAHDR_QUOTATIONNO	_varchar_40	varchar(40)	Yes	It is the Quotation no from the RFQ component for which the po is created.	No
POAHDR_QUOT_AMEND_NO	_varchar_40	varchar(40)	Yes	It is the latest quotation amentment no.	No
POAHDR_QUOTATIONOU	_decimal_10_0	decimal(10)	Yes	This field holds the Quotation created ou.	No
POAHDR_SUPPLIEROFFNO	_varchar_40	varchar(40)	Yes	This field holds the supplier reference quotation no	No
POAHDR_AMENDMENTREFNO	_varchar_40	varchar(40)	Yes	Supplier reference amendment no	No
POAHDR_REMARKS	_varchar_255	varchar(255)	Yes	This field holds the remarks	No
POAHDR_PART_TYPE	_varchar_5	varchar(5)	Yes	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 Rwmt	No
POAHDR_PO_CAT	_varchar_25	Varchar(25)	Yes	This field holds the Po Category - All active quick codes under quick code type Category	No
POAHDR_USER_STATUS	_varchar_25	Varchar(25)	Yes	This field holds the User status - All active quick codes under quick code type User Status	No
POAHDR_PO_CURRENCY	_varchar_20	varchar(20)	Yes	This field holds any one of the Currency mapped to the supplier.	No
POAHDR_TOTAL_BASIC_VAL	_decimal_28_8	decimal(28)	Yes	This field holds the PO basic value. PO basic value= sum of all basic value of line no . Basic value of a line no = Order qty multiplied by cost divided by cost per which is stored in the item details table	No
POAHDR_TOTAL_TCD_POVAL	_decimal_28_8	decimal(28)	Yes	This field holds the TCD Total Amount Doc Level . TCD Total Amount = sum of all tcd amount of the document	No
POAHDR_TOTAL_TCD_PARTVAL	_decimal_28_8	decimal(28)	Yes	This field holds the TCD Total Amount part Level . part level TCD Total Amount = sum of all Po line no item level	No
POAHDR_ADDLN_CHARGES	_decimal_28_8	decimal(28)	Yes	This field holds the additional charges of the PO document Addln charges = TCD Total amount for all Po line no item level + TCD Total Amount Doc Level	No
POAHDR_TOTAL_VALUE	_decimal_28_8	decimal(28)	Yes	This field holds the Po total value . Po total value =PO Basic Value + Addln charges	No
POAHDR_EXCHANGE_RATE	_decimal_28_8	decimal(28)	Yes	This field holds the TCD Total amount for all Po line no item level	No
POAHDR_BASIC_CURRENCY_VAL	_decimal_28_8	decimal(28)	Yes	This field holds the exchange rate for the PO currency to Base currency from the Exchange rate component	No
POAHDR_REASON	_varchar_2000	varchar(2000)	Yes	This field holds the Reason for why this status change have been made.	No
POAHDR_BUYER_GROUP	_varchar_25	Varchar(25)	Yes	This field holds the buyer group of the Login user from the Buyer group component.	No
POAHDR_BUYGRP_OU	_decimal_10_0	decimal(10)	Yes	This field holds the buyer group OUinstance of the Login user from the Buyer group component.	No
POAHDR_CREATEDDATE	_datetime_8	datetime(8)	Yes	This field holds the date when the PO is created in the system	No
POAHDR_AUTH_TERLEVEL	_varchar_25	Varchar(25)	Yes	This field holds Level Applicable for the PO Total value	No
POAHDR_CREATED_BY	_varchar_30	varchar(30)	Yes	This field holds the user who created the PO	No
POAHDR_AUTH_MINVAL	_decimal_28_8	decimal(28)	Yes	This field holds the Min Value for the given level /PC	No
POAHDR_MODIFIEDDATE	_datetime_8	datetime(8)	Yes	This field holds the date when the PO is modified in the system	No
POAHDR_AUTH_MAXVAL	_decimal_28_8	decimal(28)	Yes	This field holds Max Value for the given level /PC	No
POAHDR_MODIFIED_BY	_varchar_30	varchar(30)	Yes	This field holds the user who modified the PO	No
POAHDR_AUTH_NXTLVLPC	_varchar_25	Varchar(25)	Yes	This field holds the Next Level / PC to be Authorized.	No
POAHDR_APPROVEDDATE	_datetime_8	datetime(8)	Yes	This field captures the date when the PO is approved in the system	No
POAHDR_AUTH_TYPE	_varchar_5	varchar(5)	Yes	This field holds the Next level Authorization type Lvl OR PC	No
POAHDR_APPROVED_BY	_varchar_30	varchar(30)	Yes	This field captures the user who approved the PO	No
POAHDR_AUTH_STAGE	_varchar_25	Varchar(25)	Yes	This field holds the PO Dynamic status	No
POAHDR_AMENDMENTDATE	_datetime_8	datetime(8)	Yes	This field captures the date when the PO is amended in the system	No
POAHDR_AMENDMENT_BY	_varchar_30	varchar(30)	Yes	This field captures the user who amended the PO	No
POAHDR_TIMESTAMP	_decimal_10_0	decimal(10)	Yes	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
POAHDR_AUTHORISED_BY	_varchar_30	varchar(30)	Yes	This field captures the user who authorised the PO	No
POAHDR_AUTHORISEDDATE	_datetime_8	datetime(8)	Yes	This field captures the date when the PO is authorised in the system	No
POAHDR_AC_REGN_NO	_varchar_30	varchar(30)	Yes	This field holds the aircraft registration number	No
POAHDR_PRIORITY	_varchar_20	varchar(20)	Yes	This field holds the PO Priority Following are the PO Priority 1. A OG 2. C ritical 3. E xpedite 4. R outine	No
POAHDR_QUALITY_FLG	_varchar_5	varchar(5)	Yes	This fields holds the Quality Flag The List of values are 1. Y es 2. N o	No
POAHDR_NUM_TYPE_NO	_varchar_5	varchar(5)	Yes	stores the numbering type no of the purchase order defined in document numbering class	No
POAHDR_WF_DOC_KEY	_varchar_128	varchar(128)	Yes	stores the document key used for work flow purpose	No
POAHDR_PO_CORE_STATUS	_varchar_5	varchar(5)	Yes	This field holds the Purchase Order Core Status - Open, Core Due, Rcpt Due or Closed	No
POAHDR_ISSUE_DOC_OU	_decimal_10_0	decimal(10)	Yes	OUInstance of Issue Document which is updating the core status - applicable for PO Types - Exchange and PBH-Exchange	No
POAHDR_ISSUE_DOC_NO	_varchar_40	varchar(40)	Yes	Issue Document Number which is updating the core status - applicable for PO Types - Exchange and PBH-Exchange	No
POAHDR_GR_DOC_OU	_decimal_10_0	decimal(10)	Yes	OUInstance of Goods Receipt Document which is updating the core status - applicable for PO Types - Exchange and PBH-Exchange	No
POAHDR_GR_DOC_NO	_varchar_40	varchar(40)	Yes	Goods Receipt Number which is updating the core status - applicable for PO Types - Exchange and PBH-Exchange	No
POAHDR_COMPONENT_OU	_decimal_10_0	decimal(10)	Yes	This field holds the PBH Component OU	No
POAHDR_COMPONENT_ID	_varchar_90	varchar(90)	Yes	This field holds the PBH Component ID	No
POAHDR_EXP_TYPE	udd_designparamcode	varchar(5)	Yes	This field holds the PO Expense type of following values 1. C - Capital 2.R - Revenue	No
POAHDR_RCP_RCD_OPT	udd_designparamcode	varchar(5)	Yes	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
POAHDR_WARRCLAIM_APP	udd_designparamcode	varchar(5)	Yes	To save the Warranty applicable Yes or No from the PO header details	No
POAHDR_WARRCLAIM_NO	udd_documentno	varchar(40)	Yes	To save the Warranty claimno entered by the user	No
POAHDR_REFAGREE_NO	udd_refdocumentno	varchar(40)	Yes	To save the Reference agreement no entered by the user	No
POAHDR_REFAGREE_DATE	udd_time	datetime(8)	Yes	To save the Reference agreement date entered by the user	No
POAHDR_CLAIM_REMARKS	udd_remarks	varchar(255)	Yes	To save the Claim remarks entered by the user	No
POAHDR_PUR_UNIT	fin_financebookid	varchar(20)	Yes	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
POAHDR_PUR_REMARKS	udd_remarks	varchar(255)	Yes	To capture the Purchase Remarks at PO document level	No
POAHDR_EDI_FLAG	udd_designparamcode	varchar(5)	Yes	Amend Flag	No
POAHDR_AddressID	udd_seqno	int(4)	Yes	Address ID	No
POAHDR_BaseCurrency	udd_currency	varchar(20)	Yes	PO base currency	No
POAHDR_ContactPerson	udd_contactperson	varchar(80)	Yes	contact person	No
POAHDR_PO_MODE	udd_chkflag	varchar(1)	Yes	PO mode	No
POAHDR_PoInvOrg	udd_companycode	varchar(10)	Yes	PO Company code	No
POAHDR_Pur_Oucode	udd_ctxt_ouinstance	int(4)	Yes	Purchase OU	No
POAHDR_Pur_TradingPartner	udd_vendorcode	varchar(45)	Yes	Purchase trading partner	No
POAHDR_Purchase_For	udd_designparamcode	varchar(5)	Yes	Purchase for type	No
POAHDR_SRCDOCNO	udd_documentno	varchar(40)	Yes	Source document no	No
POAHDR_SRCDOCOU	udd_sequence	numeric(9)	Yes	Source document Ou	No
POAHDR_WARRAPP_FLAG	udd_chkflag	varchar(1)	Yes	WARRAPP FLAG	No
POAHDR_PURPOSE	udd_desc40	varchar(40)	Yes	Purpose	No
POAHDR_Status_Amd_Aftr_CL_Flag	udd_designparamcode	varchar(5)	Yes	Status amendment after CL flag	No

Table Name :	PO_POAINS_PO_INSPECTION_DET
Comment :	This table holds the item Inspection details of Amended purchase order document

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
POAINS_OUINSTANCE	_decimal_10_0	decimal(10)	No	This field holds the ouinstance in which the Inspection details for the line item of the PO have been created	Yes
POAINS_PO_NO	_varchar_40	varchar(40)	No	This field holds the Purchase order number.	Yes
POAINS_AMEND_NO	_decimal_10_0	decimal(10)	No	This field holds the amendment no of the PO documents.	Yes
POAINS_LINE_NO	_decimal_10_0	decimal(10)	No	Each item record requested in the purchase Order is associated with this key .	Yes
POAINS_PO_ATTRIBUTE_ID	_varchar_40	varchar(40)	No	This field holds the unique identifing runing no	Yes
POAINS_ATTRIBUTE_OU	_decimal_10_0	decimal(10)	Yes	This filed holds the attribute created ou	No
POAINS_ATTRIBUTE_CODE	_varchar_10	varchar(10)	Yes	This field holds the attribute code for the part from the part admin component.	No
POAINS_ATTRIBUTE_TYPE	_varchar_5	varchar(5)	Yes	This field holds the attribute type	No
POAINS_MAXIMUM_VALUE	_decimal_28_8	decimal(28)	Yes	This field holds the maximum value of the attribute.	No
POAINS_MINIMUM_VALUE	_decimal_28_8	decimal(28)	Yes	This field holds the minimum value of the attribute.	No
POAINS_STD_VALUE	_decimal_28_8	decimal(28)	Yes	This field holds the standard value	No
POAINS_STD_MIN_VALUE	_decimal_28_8	decimal(28)	Yes	This field holds the standard minimum value	No
POAINS_STD_MAX_VALUE	_decimal_28_8	decimal(28)	Yes	This field holds the standard maximum value	No
POAINS_STD_QUAL_VALUE	_varchar_80	varchar(80)	Yes	This field holds the standard qualitative value	No
POAINS_TRACKABLE_FLAG	_varchar_5	varchar(5)	Yes	This field is set when the trackable option is allowed. Allowed values are 1.YES 2.NO	No
POAINS_INSPECTION_REMARKS	_varchar_255	varchar(255)	Yes	This field holds the inspection remarks for each line item	No
POAINS_UOM	_varchar_10	varchar(10)	Yes	This field holds the unit of measurement	No
POAINS_CREATEDDATE	_datetime_8	datetime(8)	Yes	This field holds the date when the PO inspection detail is created in the system	No
POAINS_CREATED_BY	_varchar_30	varchar(30)	Yes	This field holds the user who created the PO inspection detail	No
POAINS_MODIFIEDDATE	_datetime_8	datetime(8)	Yes	This field captures the date when the PO inspection detail ismodified in the system	No
POAINS_MODIFIED_BY	_varchar_30	varchar(30)	Yes	This field captures the user who modified the PO inspection detail	No

Table Name :	PO_POAITCD_PO_ITEM_TCD
Comment :	This table holds the Part TCD details of Amended purchase order document

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
POAITCD_OUINSTANCE	_decimal_10_0	decimal(10)	No	This field holds the ouinstance in which the TCD details for the line item of the PO have been created	Yes
POAITCD_PO_NO	_varchar_40	varchar(40)	No	This field holds the Purchase order number.	Yes
POAITCD_AMEND_NO	_decimal_10_0	decimal(10)	No	This field holds the amendment no of the PO documents.	Yes
POAITCD_LINE_NO	_decimal_10_0	decimal(10)	No	Each item record requested in the purchase Order is associated with this key .	Yes
POAITCD_TCD_CODE	_varchar_25	Varchar(25)	No	This field holds the Unique identifier for the TCD	No
POAITCD_SERIAL_NO	_decimal_10_0	decimal(10)	No	This field holds the TCD sequence no Runing NO	Yes
POAITCD_TCD_VARIANT	_varchar_25	Varchar(25)	No	This field holds the TCD variant for the TCD code.	No
POAITCD_TCD_OU	_decimal_10_0	decimal(10)	Yes	This field holds the tcd ouinstance	No
POAITCD_TCD_RATE	_decimal_28_8	decimal(28)	Yes	TCT rate for the TCD code and the variant . this should not be changed for TCD basis -- Percentage.	No
POAITCD_TCD_AMOUNT	_decimal_28_8	decimal(28)	Yes	The Tcd amount that will be calculated from the TCD component for the TCD code and the variant and the TCD rate supplied	No
POAITCD_CREATEDDATE	_datetime_8	datetime(8)	Yes	This field holds the date when the PO Part level TCD is created in the system	No
POAITCD_CREATED_BY	_varchar_30	varchar(30)	Yes	This field holds the user who created the PO part level TCD	No
POAITCD_MODIFIEDDATE	_datetime_8	datetime(8)	Yes	This field holds the date when the PO Part level TCD is modified in the system	No
POAITCD_MODIFIED_BY	_varchar_30	varchar(30)	Yes	This field holds the user who modified the PO part level TCD	No
POAITCD_CURRENCY	_varchar_20	varchar(20)	Yes	This field holds the Transaction currency	No
POAITCD_USER_SEQNO	_decimal_10_0	decimal(10)	Yes	holds the sequenc number as entered by the user for the TCD	No
POAITCD_EXCHG_RATE	_decimal_28_8	decimal(28)	Yes	Holds the exchage rate between the document currency and the payment currency	No
POAITCD_COST_DIFF	_numeric_28_8	numeric(28)	Yes	This field holds the TCD Cost difference of a PO document before and after amendment	No
POAITCD_CHRG_TYPE	udd_designparamcode	varchar(5)	No	To store values of Part  tcd charge type either  Payable or negotable	No
POAITCD_TCD_INCIDENCE	udd_taxinci	Varchar(40)	Yes	This field holds the TCD Incidence	No

Table Name :	PO_POAITM_PO_ITEM_DETAILS
Comment :	This table holds the item details of Amended purchase order document

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
POAITM_OUINSTANCE	_decimal_10_0	decimal(10)	No	This field holds the OUinstance in which the PO is Amended.	Yes
POAITM_PO_NO	_varchar_40	varchar(40)	No	This field captures the Purchase order number.	Yes
POAITM_AMEND_NO	_decimal_10_0	decimal(10)	No	This field holds the amendment no of the PO documents.	Yes
POAITM_LINE_NO	_decimal_10_0	decimal(10)	No	Each item record requested in the purchase Order is associated with this key .	Yes
POAITM_QUOT_LINE_NO	_decimal_10_0	decimal(10)	Yes	This is the quotation line no of the quotation for which the PO is raised.	No
POAITM_PART_NO	_varchar_40	varchar(40)	Yes	This field holds the Part number requested in the PO	No
POAITM_PART_OU	_decimal_10_0	decimal(10)	Yes	This field holds the Part number OUinstance requested in the PO	No
POAITM_PART_CONDITION	_varchar_5	varchar(5)	Yes	This field holds the part condition, the values are N ew Ns New Surplus O verhaul S erviceable U nserviceable	No
POAITM_ORDER_QTY_PUOM	_decimal_28_8	decimal(28)	Yes	This field holds the Ordered qty of each line item of the PO	No
POAITM_PURCHASE_UOM	_varchar_10	varchar(10)	Yes	This field holds Any valid UOM from the UOM component in which the goods can be purchased .	No
POAITM_COST	_decimal_28_8	decimal(28)	Yes	This field holds the Cost of the part, depending on cost per, it can be either cost of 1 part or more.	No
POAITM_COST_PER	_decimal_28_8	decimal(28)	Yes	This field holds the Unit cost of the part	No
POAITM_SHIP_TO_OU	_decimal_10_0	decimal(10)	Yes	This field holds OU instance	No
POAITM_SCH_TYPE	_varchar_5	varchar(5)	Yes	This field holds the purchase orders schedule type List of values are S ingle -- all the requested qty will be delivered in a single schedule in the same warehouse. M ultiple -- the requested qty will be delivered in a staggered schedul	No
POAITM_STOCKADMN_OU	_decimal_10_0	decimal(10)	Yes	This field holds the stock admin OUinstance	No
POAITM_ALTERNATE_PART	_varchar_5	varchar(5)	Yes	This field holds the alternate part of the line item	No
POAITM_INSPECTION_TYPE	_varchar_5	varchar(5)	Yes	This field holds the Inspection types. List of values are N one S elf I By Inspector	No
POAITM_MATCHING_TYPE	_varchar_5	varchar(5)	Yes	This field holds 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
POAITM_TOLERANCE_TYPE	_varchar_5	varchar(5)	Yes	This field holds the tolerance types. list of values are V alue Q uantity B oth	No
POAITM_TOLERANCE_PERCENT	_decimal_28_8	decimal(28)	Yes	This field holds the tolerance limit within which we can accept the ordered quantity from the supplier	No
POAITM_BASIC_VALUE	_decimal_28_8	decimal(28)	Yes	This field holds the basic value. basic value = order qty * Cost / cost per	No
POAITM_TOTAL_TCD_PART_VAL	_decimal_28_8	decimal(28)	Yes	This field holds the Sum of all TCD values of the line item.	No
POAITM_RECEIVED_QTY_PUOM	_decimal_28_8	decimal(28)	Yes	This field holds the Quantity received from the supplier	No
POAITM_ACCEPTED_QTY_PUOM	_decimal_28_8	decimal(28)	Yes	This field holds the Qty Received from the Supplier and have been inspected	No
POAITM_QUALITY_ATTRIBUTE	_varchar_5	varchar(5)	Yes	This fields holds the Quality Attribute with the following values 1. S tandard 2. C ustom 3. N one	No
POAITM_REF_DOC_OU	_decimal_10_0	decimal(10)	Yes	This field captures the referance document ou that where the document is created	No
POAITM_REF_DOC_NO	_varchar_40	varchar(40)	Yes	This field captures the referance document no this used to find from where the order is raised.	No
POAITM_REF_DOC_TYPE	_varchar_5	varchar(5)	Yes	This field captures the referance document Type	No
POAITM_DOC_ATTACH	_varchar_5	varchar(5)	Yes	This field holds the Flag whether the documenta are attached or not for the given part List of values are Y es N o	No
POAITM_RCPT_POS_TOL	_decimal_28_8	decimal(28)	Yes	This field holds the positive tolerance limit within which we can accept the ordered quantity from the supplier	No
POAITM_RCPT_NEG_TOL	_decimal_28_8	decimal(28)	Yes	This field holds the negative tolerance limit within which we can accept the ordered quantity from the supplier	No
POAITM_INSPECTION_WO	_char_18	char(18)	Yes	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 Req	No
POAITM_CERT_TYPE	udd_documentno	varchar(40)	Yes	This field holds the value of Certificate type	No
POAITM_CAPEX_PROP_NO	UDD_DefaultCapexProposalNo	varchar(20)	Yes	This field holds the Capex Proposal Number	No
POAITM_ACC_USG	udd_accountcode	varchar(32)	Yes	This field holds the Accounting Usage	No
POAITM_CSTG_USG	udd_accountcode	varchar(32)	Yes	This field holds the Costing Usage	No
POAITM_ANAL_CODE	udd_analysiscode	varchar(5)	Yes	This field holds the Analysis code	No
POAITM_SUBANAL_CODE	udd_subanalysiscode	varchar(5)	Yes	This field holds the Subanalysis code	No
POAITM_PART_DESC	udd_txt150	varchar(150)	Yes	This field holds the Part Description	No
POAITM_REMARKS	udd_remarks	varchar(255)	Yes	This field holds the Remarks of each line item	No
POAITM_SUPP_ESTM_ARRV_DT	udd_datetime	varchar(30)	Yes	This field holds the Estimate arrival date	No
POAITM_ALTERNATE_PART_NO	_varchar_40	varchar(40)	Yes	This field holds the alternate partno of each line item of po document	No
POAITM_ALTERNATE_TYPE	_varchar_5	varchar(5)	Yes	This field holds the Flag whether the alternate part is allowed or not for the given part Possible values.. SA -Specific Alternate A-Allowed NA-Not Allowed	No
POAITM_WORKCENTER_CODE	_varchar_30	varchar(30)	Yes	This field holds the workcenter code for the part	No
POAITM_VALUE_DIFF	_numeric_28_8	numeric(28)	Yes	This field holds the difference in PO part item value for the each part after amendment	No
POAITM_TASKNO	udd_taskcode	varchar(30)	Yes	To save the Taskno entered by the user	No
POAITM_TASK_DISPSEQNO	udd_taskseqno	int(4)	Yes	To save the Task Sequenceno entered by the user	No
POAITM_TASK_KEYSEQNO	udd_taskseqno	int(4)	Yes	To save the INternal sequence no for the task Sequence no for the Referecne documentno given in the PO multiline	No
POAITM_CORE_PARTNO	udd_partno	varchar(40)	Yes	To save the core partno entered by the user	No
POAITM_CORE_SERIALNO	udd_partserialnumber	varchar(40)	Yes	To save the Core serialno entered by the user	No
POAITM_CORE_LOTNO	udd_lotno	varchar(18)	Yes	To save the Core Lotno entered by the user	No
POAITM_CAP_THRSHOLD_AMT	fin_amount	numeric(13)	Yes	To Capture the threshold amount	No
POAITM_RCP_RCD_OPT	udd_designparamcode	varchar(5)	Yes	To capture the Receipt record option	No
POAITM_THRSHOLD_FAIL	udd_chkflag	varchar(1)	Yes	To capture, Flag value Y, If value of POCost is lesser then or equal to thrshold amount mentioned in CPS component.	No
POAITM_EXCHANGE_RATE	fin_exchangerate	numeric(9)	Yes	PO Exchange rate maintained in Part level	No
POAITM_CUSORDNO	udd_documentno	varchar(40)	Yes	Customer order number	No
POAITM_LINE_STATUS	udd_flag	varchar(25)	Yes	PO line status	No
POAITM_PART_EXPOLICY	udd_designparamcode	varchar(5)	Yes	part expense policy	No
POAITM_PART_EXPTYPE	udd_designparamcode	varchar(5)	Yes	expense Type	No
POAITM_PART_NONSTKFLG	udd_model	varchar(20)	Yes	non stock flag	No
POAITM_PART_TYPE	udd_designparamcode	varchar(5)	Yes	PO part type	No
POAITM_PROPOSAL_FB_CODE	udd_financebookid	varchar(20)	Yes	PROPOSAL Finance book CODE	No
POAITM_REJ_QTY_PUOM	udd_quantity	numeric(13)	Yes	Rejection quantity UOM	No
POAITM_REP_WHID	udd_warehouse	varchar(10)	Yes	Warehouse ID	No
POAITM_REPLENISHMENT_FLAG	udd_designparamcode	varchar(5)	Yes	REPLENISHMENT FLAG	No
POAITM_REPLENISHMENT_QTY	udd_quantity	numeric(13)	Yes	REPLENISHMENT quantity	No
POAITM_Adj_Isu_Cost	udd_amount	numeric(13)	Yes	Persist the Adjusted Issue Cost for amended Purchase Order	No
POAITM_Adj_Isu_Qty	udd_quantity	numeric(13)	Yes	Exchange & PBH Exchange PO Adjusted Issue Quantity	No
POAITM_Adj_Rcpt_Cost	udd_amount	numeric(13)	Yes	Stores  Exchange & PBH Exchange PO Adjusted Receipt value	No
POAITM_Adj_Rcpt_Qty	udd_quantity	numeric(13)	Yes	Stores  Exchange & PBH Exchange PO Adjusted Receipt Quantity	No
POAITM_Ass_Cost_BasCurr	udd_cost	numeric(13)	Yes	Assessed Cost In Base Currency for Amended purchase order	No
POAITM_CONFIRMED_ISSUED_QTY_PUOM	udd_quantity	numeric(13)	Yes	used to persist the Issued quantity out of Ordered Quantity	No
POAITM_CostCal_Method	udd_designparamcode	varchar(5)	Yes	Cost calculation method before amendment	No
POAITM_LINE_CORE_STATUS	udd_documentno	varchar(40)	Yes	Line level core status before amendment of Purchase Order	No
POAITM_POCLOSED_DATE	udd_time	datetime(8)	Yes	PO closed date before amendment of purchase order	No
POAITM_UOM_CON_FCTR	udd_convfactor	numeric(13)	Yes	Purchase Uom conversion factor before amendment	No
POAITM_Variance_BasCurr	udd_cost	numeric(13)	Yes	Variance value in base currency at amendment of PO	No

Table Name :	PO_POAPR_PO_PRBASED_DETAILS
Comment :	This table holds the Amended purchase order document in which the purchase request are raised

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
POAPR_OUINSTANCE	_decimal_10_0	decimal(10)	No	This field holds the OUinstance in which the PO is created	Yes
POAPR_PO_NO	_varchar_40	varchar(40)	No	This field holds the Purchase order number.	Yes
POAPR_AMEND_NO	_decimal_10_0	decimal(10)	No	This field holds the amendment no of the PO documents.	Yes
POAPR_LINE_NO	_decimal_10_0	decimal(10)	No	This field holds the Unique identifier for each item requested in the Purchase order	Yes
POAPR_SCH_NO	_decimal_10_0	decimal(10)	No	stores the schedule no of the PO line item	Yes
POAPR_SERIAL_NO	_decimal_10_0	decimal(10)	No	stores the serial no which is an unique sequential number generated	Yes
POAPR_PR_NO	_varchar_40	varchar(40)	Yes	This field holds the Purchase Request no	No
POAPR_PR_OUINSTANCE	_decimal_10_0	decimal(10)	Yes	This field holds the OUinstance in which the PR is created	No
POAPR_PRLINE_NO	_decimal_10_0	decimal(10)	Yes	stores the PR line item no	No
POAPR_COVERED_QTY	_decimal_28_8	decimal(28)	Yes	This field holds the PR covered quantity PR covered quantity = PR covered quantity - PR order quantity	No
POAPR_PR_SCH_NO	_decimal_10_0	decimal(10)	Yes	stores the schedule no of the the PR line item	No
POAPR_GR_MVD_QTY	udd_quantity	numeric(13)	Yes	GR Moved Quantity	No

Table Name :	PO_POAPR_PO_PRBASED_DTL
Comment :	PO_POAPR_PO_PRBASED_DTL

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
POAPR_OUINSTANCE	_decimal_10_0	decimal(10)	Yes	PR based PO OUINSTANCE	No
POAPR_PO_NO	_varchar_40	varchar(40)	No	PO number	No
POAPR_LINE_NO	_decimal_10_0	decimal(10)	Yes	Line number	No
POAHDR_AMEND_NO	_decimal_10_0	decimal(10)	Yes	Amendment Number	No
POAPR_SCH_NO	_decimal_10_0	decimal(10)	Yes	schedule Number	No
POAPR_PR_OUINSTANCE	_decimal_10_0	decimal(10)	Yes	OU in which the document was created	No
POAPR_PR_NO	_varchar_40	varchar(40)	Yes	Document No	No
POAPR_PR_LINE_NO	_decimal_10_0	decimal(10)	Yes	Line number of the part details	No
POAPR_PR_SCH_NO	_decimal_10_0	decimal(10)	Yes	PR schedule Number	No
POAPR_PO_COVERED_QTY	udd_quantity	numeric(13)	Yes	No. of qty of PR covered in this PO document	No
POAPR_CREATED_DATE	_datetime_8	datetime(8)	Yes	Date on when the document was created	No
POAPR_CREATED_BY	_varchar_40	varchar(40)	Yes	User who has created the document	No
POAPR_MODIFIED_DATE	_datetime_8	datetime(8)	Yes	Date on which the record has got modified	No
POAPR_MODIFIED_BY	_varchar_40	varchar(40)	Yes	User who has modified the record	No
REPLICATION_KEY	_bigint_8	Bigint(8)	No	Unique Number	Yes

Table Name :	PO_POAROD_REF_OBJ_DTL
Comment :	This table is Used to store information for the reference object details for the Amended PO Document

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
POAROD_CREATED_OUINSTANCE	_decimal_10_0	decimal(10)	No	This field holds the ouinstance in which the the refernce object details for the Purchase order created	Yes
POAROD_PO_NO	_varchar_40	varchar(40)	No	This field holds the Purchase order number	Yes
POAROD_AMEND_NO	_decimal_10_0	decimal(10)	No	This field holds the amendment no of the PO	Yes
POAROD_DOC_LINE_ID	_decimal_10_0	decimal(10)	No	This is just a unique running number for identifying a record for each PO document .	Yes
POAROD_PO_LINE_NO	_decimal_10_0	decimal(10)	No	This field holds the Unique identifier for each part requested in the PO	No
POAROD_REF_DOC_TYPE	_varchar_25	Varchar(25)	Yes	This field hold the list of Reference document types defined in the Common Master component	No
POAROD_REF_DOC_ID	_varchar_40	varchar(40)	Yes	This field hold the Reference documentid	No
POAROD_REF_DOC_FILE_NAME	_varchar_50	varchar(50)	Yes	This field hold the Reference document file name	No
POAROD_CREATED_DATE	_datetime_8	datetime(8)	Yes	This field holds the date when the PO refererce object detail is created in the system	No
POAROD_CREATED_BY	_varchar_30	varchar(30)	Yes	This field holds the user who created the PO refererce object detail	No
POAROD_MODIFIED_DATE	_datetime_8	datetime(8)	Yes	This field holds the date when the PO refererce object detail is modified in the system	No
POAROD_MODIFIED_BY	_varchar_30	varchar(30)	Yes	This field holds the user who modified the PO refererce object detail	No

Table Name :	PO_POASCH_PO_SCH_DETAILS
Comment :	This table holds the item schedule details of Amended purchase order document

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
POASCH_OUINSTANCE	_decimal_10_0	decimal(10)	No	This field holds the ouinstance in which the schedule details for the line item of the PO have been created	Yes
POASCH_PO_NO	_varchar_40	varchar(40)	No	This field holds the Purchase order number.	Yes
POASCH_AMEND_NO	_decimal_10_0	decimal(10)	No	This field holds the amendment number of PO document.	Yes
POASCH_LINE_NO	_decimal_10_0	decimal(10)	No	Each item record requested in the purchase Order is associated with this key .	Yes
POASCH_SCH_NO	_decimal_10_0	decimal(10)	No	This field holds the Unique identifier for each schedule of the line item	Yes
POASCH_SCH_QTY_PUOM	_decimal_28_8	decimal(28)	Yes	This field holds the Schedule quantity.	No
POASCH_SCH_DATE	_datetime_8	datetime(8)	Yes	This field holds the date in which the schedule qty has to be delivered.	No
POASCH_WH_CODE	_varchar_10	varchar(10)	Yes	This field holds the Warehouse in which the schedule qty has to be moved	No
POASCH_MOVED_QTY_PUOM	_decimal_28_8	decimal(28)	Yes	This field holds the qty that has been received from the supplier and moved to the warehouse	No
POASCH_CREATEDDATE	_datetime_8	datetime(8)	Yes	This field holds the date when the PO schedule details created in the system	No
POASCH_CREATED_BY	_varchar_30	varchar(30)	Yes	This field holds the user who created the PO schedule details	No
POASCH_MODIFIEDDATE	_datetime_8	datetime(8)	Yes	This field holds the date when the PO schedule details modified in the system	No
POASCH_MODIFIED_BY	_varchar_30	varchar(30)	Yes	This field holds the user who modified the PO schedule details	No
POASCH_SCH_STATUS	udd_flag	varchar(25)	Yes	This field holds the Schedule Status	No

Table Name :	PO_POASC_SUP_CORR_DETAILS
Comment :	This table holds supplier correspondence details for an amended PO document

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
POASC_OUINSTANCE	_decimal_10_0	decimal(10)	No	This field holds the OUinstance in which the PO is Amended.	Yes
POASC_PO_NO	_varchar_40	varchar(40)	No	This field captures the Purchase order number.	Yes
POASC_PO_LINE_NO	_decimal_10_0	decimal(10)	No	Each item record requested in the purchase Order is associated with this key .	Yes
POASC_PO_AMEND_NO	_decimal_10_0	decimal(10)	No	This field holds the amendment no of the PO documents.	Yes
POASC_LINE_NO	_decimal_10_0	decimal(10)	No	This field holds the line nos for the remarks entered for the combination of POno , Amendmentno and PO line itemno	Yes
POASC_DATE	_datetime_8	datetime(8)	Yes	This field holds the date on which the correspodence details are entered	No
POASC_SUPP_REMARKS	_varchar_255	varchar(255)	Yes	This field holds the supplier remarks	No
POASC_BUYER_REMARKS	_varchar_255	varchar(255)	Yes	This field holds the buyer remarks	No
POASC_CREATEDDATE	_datetime_8	datetime(8)	Yes	This field holds the date on which the supplier correspondence details for a PO line item is created	No
POASC_CREATED_BY	_varchar_30	varchar(30)	Yes	This field holds the user id by whom the supplier correspondence details for a PO line item is created	No
POASC_MODIFIEDDATE	_datetime_8	datetime(8)	Yes	This field holds the date on which the supplier correspondence details for a PO line item is modified	No
POASC_MODIFIED_BY	_varchar_30	varchar(30)	Yes	This field holds the user id by whom the supplier correspondence details for a PO line item is modified	No
poasc_correspondencetype	udd_documentno	varchar(40)	Yes	This field holds the correspondence type	No
poasc_supp_refno	udd_documentno	varchar(40)	Yes	This field holds supplier referece	No

Table Name :	PO_POATMCN_PO_TERMS_CONDNS
Comment :	This table holds the Terms and Condition of Amended purchase order document

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
POATMCN_OUINSTANCE	_decimal_10_0	decimal(10)	No	This field holds the ouinstance in which the Purchase order is created	Yes
POATMCN_PO_NO	_varchar_40	varchar(40)	No	This field holds the Purchase order number	Yes
POATMCN_AMEND_NO	_decimal_10_0	decimal(10)	No	This field holds the purchase order amendment number.	Yes
POATMCN_PAYTERM_CODE	_varchar_25	Varchar(25)	Yes	This field holds the Unique identifier for the Payterm	No
POATMCN_PAYTERM_OU	_decimal_10_0	decimal(10)	Yes	This field holds the OUinstance for the Payterm	No
POATMCN_PAY_TO_SUPP	_varchar_45	varchar(45)	Yes	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
POATMCN_PAY_TO_SUPP_OU	_decimal_10_0	decimal(10)	Yes	Holds the Ouinstance of the supplier component to whom payment has to be made	No
POATMCN_PAYMENT_MODE	_varchar_5	varchar(5)	Yes	This field holds varous payment mode. list of values are Cq Check Cs Cash DD Demand Draft P ay order O rder CC Credit Card	No
POATMCN_INSURANCE_TERMS	_varchar_150	varchar(150)	Yes	This field holds the insurence term of purchase order document.	No
POATMCN_INSURANCE_LIABILITY	_varchar_25	Varchar(25)	Yes	This field holds insurance liability of the PO document List of values are O urs S upplier Ot her	No
POATMCN_INSURANCE_AMT	_decimal_28_8	decimal(28)	Yes	This field holds the insurence amount of the purchase order document.	No
POATMCN_INCO_TERM	_varchar_150	varchar(150)	Yes	This field holds the INCO term of the purchase order document.	No
POATMCN_DELIVERY_POINT	_varchar_255	varchar(255)	Yes	This field holds the delivery point of the purchase order document.	No
POATMCN_TRANS_SHIPMENT	_varchar_5	varchar(5)	Yes	This field holds the transshipment of the purchase order document. List of values Y es N o	No
POATMCN_SHIP_PARTIAL	_varchar_5	varchar(5)	Yes	This field holds the ship partial of the purchase order document. List of values Y es N o	No
POATMCN_PAY_PRIORITY	_varchar_5	varchar(5)	Yes	This field holds the pay priority of the purchase order document. List of values are 1.High, 2.Normal 3.Low	No
POATMCN_SHIP_BY	_varchar_25	Varchar(25)	Yes	This field holds the mode of transport of the purchase order document. Mode of transports are 1. AIR 2.LAND	No
POATMCN_PKG_CODE	_varchar_25	Varchar(25)	Yes	This field holds the packaging terms of the purchase order document. List of values 1. Bottle 2. Box	No
POATMCN_SHIP_PAYMENT	_varchar_25	Varchar(25)	Yes	This field holds the list of shipping payment methods in active status defined in the Logistics common master component.	No
POATMCN_REMARKS	_varchar_255	varchar(255)	Yes	This field holds the remarks of the purchase order documens terms and condition.	No
POATMCN_CREATEDDATE	_datetime_8	datetime(8)	Yes	This field holds the date when the PO term and condition created in the system	No
POATMCN_CREATED_BY	_varchar_30	varchar(30)	Yes	This field holds the user who created the PO terms and cond	No
POATMCN_MODIFIEDDATE	_datetime_8	datetime(8)	Yes	This field holds the date when the PO term and condition modified in the system	No
POATMCN_MODIFIED_BY	_varchar_30	varchar(30)	Yes	This field holds the user who modified the PO terms and cond	No
POATMCN_GTA_REFDOC_NO	_varchar_40	varchar(40)	Yes	This field holds the General Terms Agreement reference documentno	No
POATMCN_REFDOC_DATE	_datetime_8	datetime(8)	Yes	This field holds the General Terms Agreement reference document Date	No
POATMCN_GTA_REMARKS	_varchar_255	varchar(255)	Yes	This field holds the General Terms Agreement remarks	No
POATMCN_WARRANTY	_varchar_5	varchar(5)	Yes	This field holds the warranty flag of the purchase order document. List of values Y es N o	No
POATMCN_WARR_BASIS	_varchar_25	Varchar(25)	Yes	This field holds the Warranty basis of the purchase order document. List of values 1. Both 2. calender 3. Usage	No
POATMCN_WARR_AGREEMENT_NO	_varchar_40	varchar(40)	Yes	This field holds the Warranty agreement no . if warrant flag is yes then warranty agreement no is mandatory	No
POATMCN_ADVANCE_PAY_AMT	udd_quantity	numeric(13)	Yes	This field holds the advance payable amount. If advance payable flag is yes then this is mandatory	No
POATMCN_ADVANCE_PAYDATE	_datetime_8	datetime(8)	Yes	This field holds the advance payable date. If advance payable flag is yes then this is mandatory	No
POATMCN_ADVANCE_PERC	udd_quantity	numeric(13)	Yes	This field holds the advance percentage.	No
POATMCN_ADVANCE_PERC_ON	_varchar_25	Varchar(25)	Yes	This field holds the advance percentage on of the purchase order document. List of values 1. Basic Value 2. Total Value	No
POATMCN_ADVANCE_PAYABLE	_varchar_5	varchar(5)	Yes	This field holds the Advance Payable..Loads the quick code which defined in common logistics master	No
POATMCN_ADVANCE_TOL_PERC	udd_quantity	numeric(13)	Yes	This field holds the advance tolerence percentage.	No
POATMCN_DDCHARGES_BORNEBY	_varchar_25	Varchar(25)	Yes	This field holds the DD charges brone by of the purchase order document. List of values 1. self 2.supplier	No
POATMCN_PAY_TO_SUPP_ID	_decimal_10_0	decimal(10)	Yes	This field holds the pay to supplier address ids	No
POATMCN_PAYMENT_NOTES	_varchar_2000	varchar(2000)	Yes	This field holds the payment notes	No
POATMCN_PACKAGING_NOTES	_varchar_2000	varchar(2000)	Yes	This field holds the packaging notes	No
POATMCN_PORT_OF_DEP	_varchar_32	varchar(32)	Yes	This field holds the port of depature	No
POATMCN_CARRIERAGENCY	_varchar_20	varchar(20)	Yes	This field holds the list of carrier agencies	No
POATMCN_SHIPPING_NOTES	_varchar_2000	varchar(2000)	Yes	This field holds the shipping notes	No
POATMCN_FWD_CVR_RATE	udd_amount	numeric(13)	Yes	This field holds the forward Cover rate	No
POATMCN_INV_AT	udd_txt150	varchar(150)	Yes	This field holds the Invoice At	No
POATMCN_FWD_CVR_APPL	udd_txt150	varchar(150)	Yes	This field holds the forward cover applicable	No
POTAMCN_ADV_PAID	udd_amount	numeric(13)	Yes	This field holds the Advance Paid by the supplier for that part	No
POATMCN_WARRBEGINS	udd_flag	varchar(25)	Yes	To save the Warranty begins on values	No
POATMCN_DURATION	udd_duration	numeric(13)	Yes	To save the warrarnty duration	No
POATMCN_DURPERIOD	udd_flag	varchar(25)	Yes	To save the warranty duration period	No
POATMCN_FLIGHTHRS	udd_duration	numeric(13)	Yes	To save the Flight hours	No
POATMCN_FLIGHTCYCLES	udd_duration	numeric(13)	Yes	To save the Flight cycles	No
POATMCN_TERMS_REFERENCE	udd_remarks	varchar(255)	Yes	To save the Terms and references	No
POATMCN_RMANO	udd_documentno	varchar(40)	Yes	To capture the RMA Number	No
POATMCN_RMADATE	udd_time	datetime(8)	Yes	To capture the RMA Date	No
POATMCN_RET_SUPP_ID	udd_vendorcode	varchar(45)	Yes	To populate the Pay To Supplier Address ID combo with all the Address Id of the supplier	No
POATMCN_DELIVERTOCODE	udd_documentno	varchar(40)	Yes	To capture the Delivery code	No

Table Name :	PO_POAUDI_USER_DEF_INFO
Comment :	This table holds the User define information of Amended purchase order document

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
POAUDI_OUINSTANCE	_decimal_10_0	decimal(10)	No	This field holds the ouinstance in which the the user define information for the Purchase order created	Yes
POAUDI_PO_NO	_varchar_40	varchar(40)	No	This field holds the Purchase order number	Yes
POAUDI_AMEND_NO	_decimal_10_0	decimal(10)	No	This field holds the amendment no of the PO	Yes
POAUDI_USER_DEF_DESC1	_varchar_30	varchar(30)	Yes	This field holds the first user defined option	No
POAUDI_USER_DEF_OPT1	_varchar_30	varchar(30)	Yes	This field holds the first description of user defined options.	No
POAUDI_USER_DEF_DESC2	_varchar_30	varchar(30)	Yes	This field holds the second user defined option	No
POAUDI_USER_DEF_OPT2	_varchar_30	varchar(30)	Yes	This field holds the second description of user defined options.	No
POAUDI_USER_DEF_DESC3	_varchar_30	varchar(30)	Yes	This field holds the thirdt user defined option	No
POAUDI_USER_DEF_OPT3	_varchar_30	varchar(30)	Yes	This field holds the third description of user defined options.	No
POAUDI_USER_DEF_DESC4	_varchar_30	varchar(30)	Yes	This field holds the fourth user defined option	No
POAUDI_USER_DEF_OPT4	_varchar_30	varchar(30)	Yes	This field holds the fourth description of user defined options.	No
POAUDI_USER_DEF_REMARKS	_varchar_255	varchar(255)	Yes	This field holds the user defined remarks	No
POAUDI_CREATED_DATE	_datetime_8	datetime(8)	Yes	This field holds the date when the PO user define information is created in the system	No
POAUDI_CREATED_BY	_varchar_30	varchar(30)	Yes	This field holds the user who created the PO user define information	No
POAUDI_MODIFIED_DATE	_datetime_8	datetime(8)	Yes	This field holds the date when the PO user define information is modified in the system	No
POAUDI_MODIFIED_BY	_varchar_30	varchar(30)	Yes	This field holds the user who modified the PO user define informatio	No

Table Name :	PO_PODSD_DROP_SHIP_DTL
Comment :	This table holds the Dropship details of purchase order document

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
PODSD_OUINSTANCE	_numeric_28_0	numeric(28)	No	This field holds the ouinstance in which the dropship details for the line item of the PO have been created.	Yes
PODSD_PO_NO	_varchar_40	varchar(40)	No	This field holds the Purchase order number.	Yes
PODSD_LINE_NO	_numeric_28_0	numeric(28)	No	Each item record requested in the purchase Order is associated with this key .	Yes
PODSD_COMP_NAME	_varchar_150	varchar(150)	Yes	This field holds the company name for the shipment.	No
PODSD_ADDR_1	_varchar_255	varchar(255)	Yes	This field holds the company address for the shipment.	No
PODSD_ADDR_2	_varchar_255	varchar(255)	Yes	This field holds the company address for the shipment.	No
PODSD_ADDR_3	_varchar_255	varchar(255)	Yes	This field holds the company address for the shipment.	No
PODSD_CITY	_varchar_32	varchar(32)	Yes	This field holds the city of the company for shipment.	No
PODSD_ZIP_CODE	_varchar_15	varchar(15)	Yes	This field holds the zip code of the company for shipment.	No
PODSD_STATE	_varchar_32	varchar(32)	Yes	This field holds the state of the company for shipment.	No
PODSD_COUNTRY	_varchar_40	varchar(40)	Yes	This field holds the country of the company for shipment.	No
PODSD_CONTACT_PERSON	_varchar_80	varchar(80)	Yes	This field holds the contact person of the company for shipment.	No
PODSD_PHONE_NO	_varchar_70	varchar(70)	Yes	This field holds the phone no of the company for shipment	No
PODSD_FAX_NO	_varchar_70	varchar(70)	Yes	This field holds the fax details of the company for shipment	No
PODSD_EMAIL	_varchar_70	varchar(70)	Yes	This field holds the email id of the company for shipment	No
PODSD_SHIP_ALL_ITM	_varchar_5	varchar(5)	Yes	This field holds the flag whether Ship All Items to the same Location or not the values may be YES or NO	No
PODSD_REMARKS	_varchar_255	varchar(255)	Yes	This field holds the remarks of the shipment	No

Table Name :	PO_PODTCD_PO_DOC_TCD
Comment :	This table holds the Document TCD details of purchase order.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
PODTCD_OUINSTANCE	_decimal_10_0	decimal(10)	No	This field holds the ouinstance in which the Document level TCD of the PO have been created	Yes
PODTCD_PO_NO	_varchar_40	varchar(40)	No	This field holds the Purchase order number	Yes
PODTCD_SERIAL_NO	_decimal_10_0	decimal(10)	No	This field holds the Unique identifier number for the TCD of the PO.	Yes
PODTCD_TCD_VARIANT	_varchar_25	Varchar(25)	No	This field holds the TCD variant for the TCD code.	No
PODTCD_TCD_CODE	_varchar_25	Varchar(25)	No	This field holds the Unique identifier for the TCD	No
PODTCD_TCD_OU	_decimal_10_0	decimal(10)	Yes	This field holds the tcd ouinstance	No
PODTCD_TCD_RATE	_decimal_28_8	decimal(28)	Yes	TCD rate for the TCD code and the variant . this should not be changed for TCD basis -- Percentage.	No
PODTCD_TCD_AMOUNT	_decimal_28_8	decimal(28)	Yes	The Tcd amount that will be calculated from the TCD component for the TCD code and the variant and the TCD rate supplied	No
PODTCD_PAY_TO_SUPP	_varchar_45	varchar(45)	Yes	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
PODTCD_CREATEDDATE	_datetime_8	datetime(8)	Yes	This field holds the date when the PO Doc TCD is created in the system	No
PODTCD_CREATED_BY	_varchar_30	varchar(30)	Yes	This field holds the user who created the PO Doc TCD	No
PODTCD_MODIFIEDDATE	_datetime_8	datetime(8)	Yes	This field holds the date when the PO Doc TCD is modified in the system	No
PODTCD_MODIFIED_BY	_varchar_30	varchar(30)	Yes	This field holds the user who modified the PO Doc TCD	No
PODTCD_CURRENCY	_varchar_20	varchar(20)	Yes	This field holds the Transaction currency	No
PODTCD_USER_SEQNO	_decimal_10_0	decimal(10)	Yes	holds the sequenc number as entered by the user for the TCD	No
PODTCD_EXCHG_RATE	_decimal_28_8	decimal(28)	Yes	Holds the exchage rate between the document currency and the payment currency	No
PODTCD_CHRG_TYPE	udd_designparamcode	varchar(5)	Yes	Charge type in document level tcd eighther payable or notional	No
PODTCD_TCD_INCIDENCE	udd_taxinci	Varchar(40)	Yes	This field holds the TCD Incidence	No

Table Name :	PO_POHDR_PO_HEADER
Comment :	This table holds the purchase order document details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
POHDR_OUINSTANCE	_decimal_10_0	decimal(10)	No	This field holds the Purchase order created ouinstance	Yes
POHDR_PO_NO	_varchar_40	varchar(40)	No	This field holds the Purchase order number	Yes
POHDR_AMEND_NO	_decimal_10_0	decimal(10)	No	This field holds the purchase order amendment number. --The first time PO is created , amendment no is set to 0.. . --The next time any change is made to the PO after authorization ,will increment the amendmentno by 1.	No
POHDR_PO_DATE	_datetime_8	datetime(8)	No	This field holds the Purchase order creation date .	No
POHDR_PO_STATUS	_varchar_5	varchar(5)	No	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	No
POHDR_PO_TYPE	_varchar_5	varchar(5)	Yes	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 gnme	No
POHDR_SUPP_CODE	_varchar_45	varchar(45)	Yes	This field holds the Supplier code from the supplier component who has raise the purchase order.	No
POHDR_SUPPLIER_OU	_decimal_10_0	decimal(10)	Yes	This field holds the supplier Ouinstance where the supplier is registered.	No
POHDR_SUPP_CREATED_OU	_decimal_10_0	decimal(10)	Yes	This field holds the supplier created Ouinstance	No
POHDR_QUOTATIONNO	_varchar_40	varchar(40)	Yes	It is the Quotation no from the RFQ component for which the po is created.	No
POHDR_QUOT_AMEND_NO	_varchar_40	varchar(40)	Yes	It is the latest quotation amentment no	No
POHDR_QUOTATIONOU	_decimal_10_0	decimal(10)	Yes	This field holds the Quotation created ou	No
POHDR_SUPPLIEROFFNO	_varchar_40	varchar(40)	Yes	This field holds the supplier reference quotation no	No
POHDR_AMENDMENTREFNO	_varchar_40	varchar(40)	Yes	supplier reference amendment no	No
POHDR_REMARKS	_varchar_255	varchar(255)	Yes	this field holds the remarks	No
POHDR_PART_TYPE	_varchar_5	varchar(5)	Yes	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	No
POHDR_PO_CAT	_varchar_25	Varchar(25)	Yes	This field holds the Po Category - All active quick codes under quick code type Category	No
POHDR_USER_STATUS	_varchar_25	Varchar(25)	Yes	This field holds the User status - All active quick codes under quick code type User Status	No
POHDR_PO_CURRENCY	_varchar_20	varchar(20)	Yes	This field holds any one of the Currency mapped to the supplier.	No
POHDR_TOTAL_BASIC_VAL	_decimal_28_8	decimal(28)	Yes	This field holds the PO basic value. PO basic value= sum of all basic value of line no . Basic value of a line no = Order qty multiplied by cost divided by cost per which is stored in the item details table	No
POHDR_TOTAL_TCD_POVAL	_decimal_28_8	decimal(28)	Yes	This field holds the TCD Total Amount Doc Level . TCD Total Amount = sum of all tcd amount of the document	No
POHDR_TOTAL_TCD_PARTVAL	_decimal_28_8	decimal(28)	Yes	This field holds the TCD Total amount for all Po line no item level	No
POHDR_EXCHANGE_RATE	_decimal_28_8	decimal(28)	Yes	This field holds th exchange rate for the PO currency to Base currency from the Exchange rate component	No
POHDR_REASON	_varchar_2000	varchar(2000)	Yes	This field holds the Reason for why this status change have been made.	No
POHDR_BUYER_GROUP	_varchar_25	Varchar(25)	Yes	This field holds the buyer group of the Login user from the Buyer group component.	No
POHDR_BUYGRP_OU	_decimal_10_0	decimal(10)	Yes	This field holds the buyer group ouinstance where the buyer group is registered.	No
POHDR_AUTH_TERLEVEL	_varchar_25	Varchar(25)	Yes	This field holds Level Applicable for the PO Total value	No
POHDR_AUTH_MINVAL	_decimal_28_8	decimal(28)	Yes	This field holds the Min Value for the given level /PC	No
POHDR_AUTH_MAXVAL	_decimal_28_8	decimal(28)	Yes	This field holds Max Value for the given level /PC	No
POHDR_AUTH_NXTLVLPC	_varchar_25	Varchar(25)	Yes	This field holds the Next Level / PC to be Authorized.	No
POHDR_AUTH_TYPE	_varchar_5	varchar(5)	Yes	This field holds the Next level Authorization type Lvl OR PC	No
POHDR_AUTH_STAGE	_varchar_25	Varchar(25)	Yes	This field holds the PO Dynamic status	No
POHDR_CREATEDDATE	_datetime_8	datetime(8)	Yes	This field holds the date when the PO is created in the system	No
POHDR_CREATED_BY	_varchar_30	varchar(30)	Yes	This field holds the user who created the PO	No
POHDR_MODIFIEDDATE	_datetime_8	datetime(8)	Yes	This field holds the date when the PO is modified.	No
POHDR_MODIFIED_BY	_varchar_30	varchar(30)	Yes	This field holds the user who modified the PO	No
POHDR_APPROVEDDATE	_datetime_8	datetime(8)	Yes	This field holds the date when the PO is approved.	No
POHDR_APPROVED_BY	_varchar_30	varchar(30)	Yes	This field holds the user who approved the PO	No
POHDR_AUTHORISEDDATE	_datetime_8	datetime(8)	Yes	This field holds the date when the PO is authorised.	No
POHDR_AUTHORISED_BY	_varchar_30	varchar(30)	Yes	This field holds the user who authorized the PO	No
POHDR_AMENDMENTDATE	_datetime_8	datetime(8)	Yes	This field holds the date when the PO is amended.	No
POHDR_AMENDMENT_BY	_varchar_30	varchar(30)	Yes	This field holds the user who amended the PO	No
POHDR_TIMESTAMP	_decimal_10_0	decimal(10)	Yes	This field holds 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
POHDR_QUALITY_FLG	_varchar_5	varchar(5)	Yes	This fields holds the Quality Flag The List of values are 1. Y es 2. N o	No
POHDR_PRIORITY	_varchar_20	varchar(20)	Yes	This field holds the PO Priority Following are the PO Priority 1. A OG 2. C ritical 3. E xpedite 4. R outine	No
POHDR_AC_REGN_NO	_varchar_30	varchar(30)	Yes	This field holds the aircraft registration number	No
POHDR_NUM_TYPE_NO	_varchar_5	varchar(5)	Yes	stores the numbering type no for the PO	No
POHDR_WF_DOC_KEY	_varchar_128	varchar(128)	Yes	stores the document key for the purpose of work flow	No
POHDR_PO_CORE_STATUS	_varchar_5	varchar(5)	Yes	Purchase Order Core Status - Open, Core Due, Rcpt Due or Closed	No
POHDR_ISSUE_DOC_OU	_decimal_10_0	decimal(10)	Yes	OUInstance of Issue Document which is updating the core status - applicable for PO Types - Exchange and PBH-Exchange	No
POHDR_ISSUE_DOC_NO	_varchar_40	varchar(40)	Yes	Issue Document Number which is updating the core status - applicable for PO Types - Exchange and PBH-Exchange	No
POHDR_GR_DOC_OU	_decimal_10_0	decimal(10)	Yes	OUInstance of Goods Receipt which is updating the core status - applicable for PO Types - Exchange and PBH-Exchange	No
POHDR_GR_DOC_NO	_varchar_40	varchar(40)	Yes	Goods Receipt Number which is updating the core status - applicable for PO Types - Exchange and PBH-Exchange	No
POHDR_COMPONENT_OU	_decimal_10_0	decimal(10)	Yes	PBH Component OU	No
POHDR_COMPONENT_ID	_varchar_90	varchar(90)	Yes	PBH Component ID	No
POHDR_EXP_TYPE	udd_designparamcode	varchar(5)	Yes	This field holds following values for Expense type selected for the Purchaseno Revenue Capital	No
POHDR_RCP_RCD_OPT	udd_designparamcode	varchar(5)	Yes	This field holds following value No GR, GR Acceptance, GR Movement.	No
POHDR_WARRCLAIM_APP	udd_designparamcode	varchar(5)	Yes	To save Warranty clajm applicable Yes or No	No
POHDR_WARRCLAIM_NO	udd_documentno	varchar(40)	Yes	To Save the Warranty claimno	No
POHDR_REFAGREE_NO	udd_refdocumentno	varchar(40)	Yes	To Save the reference document number	No
POHDR_REFAGREE_DATE	udd_time	datetime(8)	Yes	To save the reference agerement date	No
POHDR_CLAIM_REMARKS	udd_remarks	varchar(255)	Yes	To save the claim remarks	No
POHDR_SRCDOCOU	udd_ctxt_ouinstance	int(4)	Yes	To save the source document OU from where the PO get created	No
POHDR_SRCDOCNO	udd_refdocumentno	varchar(40)	Yes	To save the source document number from where the PO get created.	No
POHDR_PO_MODE	udd_chkflag	varchar(1)	Yes	To save A or M . A - Po is created automatically M- Po is created manually	No
POHDR_WARRAPP_FLAG	udd_chkflag	varchar(1)	Yes	In PO Edit terms and 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
POHDR_PUR_UNIT	fin_financebookid	varchar(20)	Yes	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
POHDR_PUR_REMARKS	udd_remarks	varchar(255)	Yes	To populate the combo Default PR Remarks based on the set option Copy PR Remarks to PO in the interacting Logistics Common master.	No
POHDR_EDI_Flag	udd_designparamcode	varchar(5)	Yes	EDI Flag provided by the user is stored in this field	No
POHDR_AddressID	udd_seqno	int(4)	Yes	Address ID	No
POHDR_BaseCurrency	udd_currency	varchar(20)	Yes	PO base currency	No
POHDR_ContactPerson	udd_contactperson	varchar(80)	Yes	contact person	No
POHDR_PoInvOrg	udd_companycode	varchar(10)	Yes	PO Company code	No
POHDR_Pur_Oucode	udd_chkflag	varchar(1)	Yes	Purchase OU	No
POHDR_Pur_TradingPartner	udd_vendorcode	varchar(45)	Yes	Purchase trading partner	No
POHDR_Purchase_For	udd_designparamcode	varchar(5)	Yes	Purchase for type	No
POHDR_PURPOSE	udd_desc40	varchar(40)	Yes	Purpose	No
POHDR_Status_Amd_Aftr_CL_Flag	udd_designparamcode	varchar(5)	Yes	This field holds the amended status after CL flag	No

Table Name :	PO_POINS_PO_INSPECTION_DET
Comment :	This table holds the item Inspection details of purchase order document

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
POINS_OUINSTANCE	_decimal_10_0	decimal(10)	No	This field holds the ouinstance in which the Inspection details for the line item of the PO have been created	Yes
POINS_PO_NO	_varchar_40	varchar(40)	No	This field holds the Purchase order number	Yes
POINS_LINE_NO	_decimal_10_0	decimal(10)	No	This field holds the Unique identifier for each item requested in the PO	Yes
POINS_PO_ATTRIBUTE_ID	_varchar_40	varchar(40)	No	This field holds the unique identifing runing no	Yes
POINS_ATTRIBUTE_OU	_decimal_10_0	decimal(10)	Yes	This field holds the Organisation unit of the part attribute in which attribute mapped to the part	No
POINS_ATTRIBUTE_CODE	_varchar_10	varchar(10)	Yes	This field holds the attribute code for the part from the part admin component.	No
POINS_ATTRIBUTE_TYPE	_varchar_5	varchar(5)	Yes	This field holds the attribute type	No
POINS_MAXIMUM_VALUE	_decimal_28_8	decimal(28)	Yes	This field holds the maximum value of the attribute.	No
POINS_MINIMUM_VALUE	_decimal_28_8	decimal(28)	Yes	This field holds the minimum value of the attribute.	No
POINS_STD_VALUE	_decimal_28_8	decimal(28)	Yes	This field holds the standard value of the attribute.	No
POINS_STD_MIN_VALUE	_decimal_28_8	decimal(28)	Yes	This field holds the standard minimum value of the attribute.	No
POINS_STD_MAX_VALUE	_decimal_28_8	decimal(28)	Yes	This field holds the standard maximum value of the attribute.	No
POINS_STD_QUAL_VALUE	_varchar_80	varchar(80)	Yes	This field holds the standard qualitative value	No
POINS_TRACKABLE_FLAG	_varchar_5	varchar(5)	Yes	This field is set when the trackable option is allowed. Allowed values are 1.YES 2.NO	No
POINS_INSPECTION_REMARKS	_varchar_255	varchar(255)	Yes	This field holds the inspection details for each line item	No
POINS_UOM	_varchar_10	varchar(10)	Yes	This field holds the unit of measurement	No
POINS_CREATEDDATE	_datetime_8	datetime(8)	Yes	This field holds the date when the PO inspection detail is created in the system	No
POINS_CREATED_BY	_varchar_30	varchar(30)	Yes	This field holds the user who created the PO inspection detail	No
POINS_MODIFIEDDATE	_datetime_8	datetime(8)	Yes	This field holds the date when the PO inspection detail is modified in the system	No
POINS_MODIFIED_BY	_varchar_30	varchar(30)	Yes	This field holds the user who modified the PO inspection detail	No

Table Name :	PO_POITCD_PO_ITEM_TCD
Comment :	This table holds the Part TCD details of purchase order document

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
POITCD_OUINSTANCE	_decimal_10_0	decimal(10)	No	This field holds the ouinstance in which the TCD details for the line item of the PO have been created	Yes
POITCD_PO_NO	_varchar_40	varchar(40)	No	This field holds the Purchase order number	Yes
POITCD_LINE_NO	_decimal_10_0	decimal(10)	No	This field holds the Unique identifier for each item requested in the PO	Yes
POITCD_SERIAL_NO	_decimal_10_0	decimal(10)	No	This field holds the TCD sequence no Runing NO	Yes
POITCD_TCD_CODE	_varchar_25	Varchar(25)	No	This field holds the Unique identifier for the TCD	No
POITCD_TCD_VARIANT	_varchar_25	Varchar(25)	No	This field holds the TCD variant for the TCD code.	No
POITCD_TCD_OU	_decimal_10_0	decimal(10)	Yes	This field holds the tcd ouinstance	No
POITCD_TCD_RATE	_decimal_28_8	decimal(28)	Yes	TCT rate for the TCD code and the variant . this should not be changed for TCD basis -- Percentage.	No
POITCD_TCD_AMOUNT	_decimal_28_8	decimal(28)	Yes	The Tcd amount that will be calculated from the TCD component for the TCD code and the variant and the TCD rate supplied	No
POITCD_CREATEDDATE	_datetime_8	datetime(8)	Yes	This field holds the date when the PO Part level TCD is created in the system	No
POITCD_CREATED_BY	_varchar_30	varchar(30)	Yes	This field holds the user who created the PO part level TCD	No
POITCD_MODIFIEDDATE	_datetime_8	datetime(8)	Yes	This field holds the date when the PO Part level TCD is modified in the system	No
POITCD_MODIFIED_BY	_varchar_30	varchar(30)	Yes	This field holds the user who modified the PO part level TCD	No
POITCD_CURRENCY	_varchar_20	varchar(20)	Yes	This field holds the Transaction currency	No
POITCD_USER_SEQNO	_decimal_10_0	decimal(10)	Yes	holds the sequenc number as entered by the user for the TCD	No
POITCD_EXCHG_RATE	_decimal_28_8	decimal(28)	Yes	Holds the exchage rate between the document currency and the payment currency	No
POITCD_COST_DIFF	_numeric_28_8	numeric(28)	Yes	This field holds the cost difference of the part after amendement	No
POITCD_CHRG_TYPE	udd_designparamcode	varchar(5)	Yes	Charge type in part level tcd	No
POITCD_TCD_INCIDENCE	udd_taxinci	Varchar(40)	Yes	This field holds the TCD Incidence	No

Table Name :	PO_POitmVar_Variance_Details
Comment :	This table holds the purchase order variance information

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

Table Name :	PO_POITM_PO_ITEM_DETAILS
Comment :	This table holds the item details of purchase order document

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
POITM_OUINSTANCE	_decimal_10_0	decimal(10)	No	This field holds the OUinstance in which the PO is created	Yes
POITM_PO_NO	_varchar_40	varchar(40)	No	This field holds the Purchase order number	Yes
POITM_LINE_NO	_decimal_10_0	decimal(10)	No	Each item record requested in the purchase Order is associated with this key .	Yes
POITM_QUOT_LINE_NO	_decimal_10_0	decimal(10)	Yes	This is the quotation line no of the quotation for which the PO is raised.	No
POITM_PART_NO	_varchar_40	varchar(40)	Yes	This field holds the Part number requested in the PO	No
POITM_PART_OU	_decimal_10_0	decimal(10)	Yes	This field holds the created ouinstance of the part	No
POITM_PART_CONDITION	_varchar_5	varchar(5)	Yes	This field captures the part condition, the values are N ew Ns New Surplus O verhaul S erviceable U nserviceable	No
POITM_ORDER_QTY_PUOM	_decimal_28_8	decimal(28)	Yes	This field holds the Ordered qty of each line item of the PO	No
POITM_PURCHASE_UOM	_varchar_10	varchar(10)	Yes	This field holds Any valid UOM from the UOM component in which the goods can be purchased .	No
POITM_COST	_decimal_28_8	decimal(28)	Yes	This field holds the Cost of the part, depending on cost per, it can be either cost of 1 part or more.	No
POITM_COST_PER	_decimal_28_8	decimal(28)	Yes	This field holds the Unit cost of the part	No
POITM_SHIP_TO_OU	_decimal_10_0	decimal(10)	Yes	This field holds the Goods receipt OU mapped to the PO OU	No
POITM_SCH_TYPE	_varchar_5	varchar(5)	Yes	This field holds the purchase orders schedule type List of values are S ingle -- all the requested qty will be delivered in a single schedule in the same warehouse. M ultiple -- the requested qty will be delivered in a staggered schedul	No
POITM_STOCKADMN_OU	_decimal_10_0	decimal(10)	Yes	This field holds the stockadmn Ouinstance where the Stock is registered.	No
POITM_ALTERNATE_PART	_varchar_5	varchar(5)	Yes	Alternate Part information	No
POITM_INSPECTION_TYPE	_varchar_5	varchar(5)	Yes	This field holds the Inspection types. List of values are N one S elf I By Inspector	No
POITM_MATCHING_TYPE	_varchar_5	varchar(5)	Yes	This field holds 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
POITM_TOLERANCE_TYPE	_varchar_5	varchar(5)	Yes	This field holds the tolerance types. list of values are V alue Q uantity B oth N one	No
POITM_TOLERANCE_PERCENT	_decimal_28_8	decimal(28)	Yes	This field holds the tolerance limit within which we can accept the ordered quantity from the supplier	No
POITM_BASIC_VALUE	_decimal_28_8	decimal(28)	Yes	This field holds the basic value. basic value = order qty * Cost / cost per	No
POITM_TOTAL_TCD_PART_VAL	_decimal_28_8	decimal(28)	Yes	This field holds the Sum of all TCD values of the line item.	No
POITM_RECEIVED_QTY_PUOM	_decimal_28_8	decimal(28)	Yes	This field holds the Quantity received from the supplier	No
POITM_ACCEPTED_QTY_PUOM	_decimal_28_8	decimal(28)	Yes	This field holds the Qty Received from the Supplier and have been inspected	No
POITM_LINE_STATUS	_varchar_5	varchar(5)	Yes	This field holds the various line statuses maintained are 1. O pen 2. N egative Tolerance closed 3. Cl osed	No
POITM_QUALITY_ATTRIBUTE	_varchar_5	varchar(5)	Yes	This fields holds the Quality Attribute with the following values 1. S tandard 2. C ustom 3. N one	No
POITM_REF_DOC_OU	_decimal_10_0	decimal(10)	Yes	This field captures the referance document ou that where the document is created	No
POITM_REF_DOC_NO	_varchar_40	varchar(40)	Yes	This field captures the referance document no this used to find from where the order is raised.	No
POITM_REF_DOC_TYPE	_varchar_5	varchar(5)	Yes	This field captures the referance document Type	No
POITM_DOC_ATTACH	_varchar_5	varchar(5)	Yes	This field holds the Flag whether the documents are attached or not for the given part List of values are Y es N o	No
POITM_RCPT_POS_TOL	_decimal_28_8	decimal(28)	Yes	This field holds the positive tolerance limit within which we can accept the ordered quantity from the supplier	No
POITM_RCPT_NEG_TOL	_decimal_28_8	decimal(28)	Yes	This field holds the negative tolerance limit within which we can accept the ordered quantity from the supplier	No
POITM_REPLENISHMENT_FLAG	_varchar_1	varchar(1)	Yes	This field holds the Replenishment flag Yes or No	No
POITM_REPLENISHMENT_QTY	_decimal_28_8	decimal(28)	Yes	This field holds the Replenishment Qty	No
POITM_INSPECTION_WO	_varchar_20	varchar(20)	Yes	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 Req	No
POITM_CERT_TYPE	udd_documentno	varchar(40)	Yes	This field holds the Certificate type values	No
POITM_CAPEX_PROP_NO	_varchar_40	varchar(40)	Yes	This field holds the Capex Proposal No. values	No
POITM_ACC_USG	udd_accountcode	varchar(32)	Yes	This field holds the AccountCodes values	No
POITM_CSTG_USG	udd_accountcode	varchar(32)	Yes	This field holds the Costing Usage Code values	No
POITM_ANAL_CODE	udd_analysiscode	varchar(5)	Yes	This field holds the Analysis Code values	No
POITM_SUBANAL_CODE	udd_subanalysiscode	varchar(5)	Yes	This field holds the Sub Analysis code	No
POITM_PART_DESC	udd_txt150	varchar(150)	Yes	This field holds the Part Description of the part No	No
POITM_REMARKS	udd_remarks	varchar(255)	Yes	This field holds the Remarks	No
POITM_SUPP_ESTM_ARRV_DT	udd_datetime	varchar(30)	Yes	This field holds the Estimated Arrival date of PO line item	No
POITM_PROPOSAL_FB_CODE	udd_financebookid	varchar(20)	Yes	This field holds the Finance Book code of PO line item	No
POITM_ALTERNATE_PART_NO	_varchar_40	varchar(40)	Yes	This field holds the alternate partno of each line item of po document	No
POITM_ALTERNATE_TYPE	_varchar_5	varchar(5)	Yes	This field holds the alternate part type Possible values.. SA -Specific Alternate A-Allowed NA-Not Allowed	No
POITM_WORKCENTER_CODE	_varchar_30	varchar(30)	Yes	This field holds the column to store workcenter code	No
POITM_VALUE_DIFF	_numeric_28_8	numeric(28)	Yes	This field holds the difference in PO part item value for the each part after amendment	No
POITM_TASKNO	udd_taskcode	varchar(30)	Yes	To save the Task no enterd by the used	No
POITM_TASK_DISPSEQNO	udd_taskseqno	int(4)	Yes	To save the Task Seqno column values enetered by the user	No
POITM_TASK_KEYSEQNO	udd_taskseqno	int(4)	Yes	To Store the internal sequence no for the Task Sequence no which is availlabe in that reference documentno gven in PO multiline	No
POITM_CORE_PARTNO	udd_partno	varchar(40)	Yes	To save the Core Partno entered by the user	No
POITM_CORE_SERIALNO	udd_partserialnumber	varchar(40)	Yes	To save the core serial no entered by the user	No
POITM_CORE_LOTNO	udd_lotno	varchar(18)	Yes	To save the Core lotno entered by the user	No
POITM_CUSORDNO	udd_documentno	varchar(40)	Yes	To save the customer Order no for the reference documentno in the PO multiline details.	No
POITM_CAP_THRSHOLD_AMT	fin_amount	numeric(13)	Yes	To capture the Threshold Amount from CPS Component while creating PO	No
POITM_RCP_RCD_OPT	udd_designparamcode	varchar(5)	Yes	To maintain the Receipt Recording Option at the line level.	No
POITM_THRSHOLD_FAIL	udd_chkflag	varchar(1)	Yes	To capture, Flag value Y, If value of POCost is lesser then or equal to thrshold amount mentioned in CPS component.	No
POITM_EXCHANGE_RATE	fin_exchangerate	numeric(9)	Yes	This column holds the exchange rate.	No
POITM_REP_WHID	udd_warehouse	varchar(10)	Yes	This column holds the replenishment warehouse	No
POITM_PART_TYPE	udd_designparamcode	varchar(5)	No	This field corresponds to the part type defined in part master.	No
POITM_PART_EXPTYPE	udd_type	varchar(25)	No	This field corresponds to the control type of the part.	No
POITM_PART_NONSTKFLG	udd_model	varchar(20)	No	This field corresponds to the part expence policy as defined in part master.	No
POITM_PART_EXPOLICY	udd_designparamcode	varchar(5)	No	This field corresponds to the expence type of the part as defined in part master.	No
POITM_REJ_QTY_PUOM	udd_quantity	numeric(13)	Yes	Rejected Quantity in the transaction uom	No
POITM_Adj_Isu_Cost	udd_amount	numeric(13)	Yes	Persist the Adjusted Issue Cost for  Purchase Order	No
POITM_Adj_Isu_Qty	udd_quantity	numeric(13)	Yes	Exchange & PBH Exchange PO Adjusted Issue Quantity	No
POITM_Adj_Rcpt_Cost	udd_amount	numeric(13)	Yes	Stores  Exchange & PBH Exchange PO Adjusted Receipt value	No
POITM_Adj_Rcpt_Qty	udd_quantity	numeric(13)	Yes	Stores  Exchange & PBH Exchange PO Adjusted Receipt Quantity	No
POITM_Ass_Cost_BasCurr	udd_cost	numeric(13)	Yes	Assessed Cost In Base Currency for  purchase order	No
POITM_CONFIRMED_ISSUED_QTY_PUOM	udd_quantity	numeric(13)	Yes	used to persist the Issue quantity out of Ordered Quantity	No
POITM_CostCal_Method	udd_designparamcode	varchar(5)	Yes	Cost calculation method before amendment	No
POITM_LINE_CORE_STATUS	udd_documentno	varchar(40)	Yes	Line level core status	No
POITM_POclosed_date	udd_time	datetime(8)	Yes	This field stores the PO header status closed Date	No
POITM_UOM_CON_FCTR	udd_convfactor	numeric(13)	Yes	Uom conversion factor at part level	No
POITM_Variance_BasCurr	udd_cost	numeric(13)	Yes	Variance value in base currency	No

Table Name :	PO_POPRM_PARAMETER_DETAILS
Comment :	Used to Store the Parameter Details of the PO Document

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
POPRM_COMPONENTNAME	_varchar_150	varchar(150)	No	This field holds the Name of the component.	No
POPRM_PARAMCATEGORY	_varchar_10	varchar(10)	No	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.	No
POPRM_PARAMTYPE	_varchar_25	Varchar(25)	No	Normally param type is the name of the control. This will allow us to store all the possible values for a combo in multiple rows.	No
POPRM_PARAMCODE	_varchar_5	varchar(5)	No	This is the code that may be used for data storage. This is valid only incase of combo boxes. Here the short code that will be stored as data in the transaction could be maintained.	No
POPRM_LANGID	_decimal_10_0	decimal(10)	No	Language id. This is the language id of the record.	No
POPRM_PARAMDESC	_varchar_80	varchar(80)	No	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
POPRM_SORTBY	_decimal_10_0	decimal(10)	Yes	This field holds the default sort by code	No
POPRM_CREATEDDATE	_datetime_8	datetime(8)	Yes	This field holds the record created date for auditing purpose	No
REPLICATION_KEY	_bigint_8	Bigint(8)	No	Unique Number	Yes

Table Name :	PO_POPR_PO_PRBASED_DETAILS
Comment :	This table holds the purchase order document in which the purchase request are raised

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
POPR_OUINSTANCE	_decimal_10_0	decimal(10)	No	This field holds the OUinstance in which the PO is created	Yes
POPR_PO_NO	_varchar_40	varchar(40)	No	This field holds the Purchase order number	Yes
POPR_AMEND_NO	_decimal_10_0	decimal(10)	No	This field holds the latest Amendment no	No
POPR_LINE_NO	_decimal_10_0	decimal(10)	No	Each item record requested in the purchase Order is associated with this key .	Yes
POPR_SCH_NO	_decimal_10_0	decimal(10)	No	This field holds the PO sch id specific to each line item	Yes
POPR_SERIAL_NO	_decimal_10_0	decimal(10)	No	This item holds PR Serial No	Yes
POPR_PR_NO	_varchar_40	varchar(40)	Yes	This field holds the Purchase Request no	No
POPR_PR_OUISTANCE	_decimal_10_0	decimal(10)	Yes	This field holds the OUinstance in which the PR is created	No
POPR_PRLINE_NO	_decimal_10_0	decimal(10)	Yes	This field holds the Unique identifier for each item requested in the Purchase request	No
POPR_COVERED_QTY	_decimal_28_8	decimal(28)	Yes	This field holds the PR covered quantity PR covered quantity = PR covered quantity - PR order quantity	No
POPR_PR_SCH_NO	_decimal_10_0	decimal(10)	Yes	This field holds the corrsponding covered PR sch id	No
POPR_GR_MVD_QTY	_decimal_28_8	decimal(28)	Yes	This field holds the GR moved quantity when GR movment happen	No
POPR_PRGR_MVD_QTY	udd_quantity	numeric(13)	Yes	This field holds the GR moved quantity when GR movment happen only applicable for if the GR has created against any PR reference	No

Table Name :	PO_POPR_PO_PRBASED_DTL
Comment :	PO_POPR_PO_PRBASED_DTL

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
POPR_OUINSTANCE	_decimal_10_0	decimal(10)	Yes	PO based PR details OU	No
POPR_PO_NO	_varchar_40	varchar(40)	No	PO based PR details number	No
POPR_LINE_NO	_decimal_10_0	decimal(10)	Yes	PO based PR line number	No
POPR_SCH_NO	_decimal_10_0	decimal(10)	Yes	PO based PR schedule number	No
POPR_PR_OUINSTANCE	_decimal_10_0	decimal(10)	Yes	PR ou	No
POPR_PR_NO	_varchar_40	varchar(40)	Yes	PR based PO PR number	No
POPR_PR_LINE_NO	_decimal_10_0	decimal(10)	Yes	PR based PO PR line number	No
POPR_PR_SCH_NO	_decimal_10_0	decimal(10)	Yes	PR based PO PR schedule number	No
POPR_PO_COVERED_QTY	udd_quantity	numeric(13)	Yes	PR based PO covered quantity	No
POPR_CREATED_DATE	_datetime_8	datetime(8)	Yes	PO based PR CREATED_DATE	No
POPR_CREATED_BY	_varchar_40	varchar(40)	Yes	PO based PR CREATED By	No
POPR_MODIFIED_DATE	_datetime_8	datetime(8)	Yes	PO based PR MODIFIED_DATE	No
POPR_MODIFIED_BY	_varchar_40	varchar(40)	Yes	PO based PR MODIFIED_BY	No
REPLICATION_KEY	_bigint_8	Bigint(8)	No	PO based PR REPLICATION KEY	Yes

Table Name :	PO_POROD_REF_OBJ_DTL
Comment :	This table is Used to store information for the reference object details for the PO Document

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
POROD_CREATED_OUINSTANCE	_decimal_10_0	decimal(10)	No	This field holds the ouinstance of the PO have been created	Yes
POROD_PO_NO	_varchar_40	varchar(40)	No	This field holds the Purchase order number	Yes
POROD_DOC_LINE_ID	_decimal_10_0	decimal(10)	No	This is just a unique running number for identifying a record for each PO document .	Yes
POROD_PO_LINE_NO	_decimal_10_0	decimal(10)	No	This field holds the Unique identifier for each part requested in the PO	No
POROD_REF_DOC_TYPE	_varchar_25	Varchar(25)	Yes	This field hold the list of Reference document types defined in the Common Master component	No
POROD_REF_DOC_ID	_varchar_40	varchar(40)	Yes	This field hold the Reference documentid	No
POROD_REF_DOC_FILE_NAME	_varchar_50	varchar(50)	Yes	This field hold the Reference document file name	No
POROD_CREATED_DATE	_datetime_8	datetime(8)	Yes	This field holds the date when the PO refererce object detail is created in the system	No
POROD_CREATED_BY	_varchar_30	varchar(30)	Yes	This field holds the user who created the PO refererce object detail	No
POROD_MODIFIED_DATE	_datetime_8	datetime(8)	Yes	This field holds the date when the PO refererce object detail is modified in the system	No
POROD_MODIFIED_BY	_varchar_30	varchar(30)	Yes	This field holds the user who modified the PO refererce object detail	No

Table Name :	PO_POSCH_PO_SCH_DETAILS
Comment :	This table holds the item schedule details of purchase order document

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
POSCH_OUINSTANCE	_decimal_10_0	decimal(10)	No	This field holds the ouinstance in which the schedule details for the line item of the PO have been created	Yes
POSCH_PO_NO	_varchar_40	varchar(40)	No	This field holds the Purchase order number	Yes
POSCH_LINE_NO	_decimal_10_0	decimal(10)	No	This field holds the Unique identifier for each item requested in the PO	Yes
POSCH_SCH_NO	_decimal_10_0	decimal(10)	No	This field holds the Unique identifier for each schedule of the line item	Yes
POSCH_SCH_QTY_PUOM	_decimal_28_8	decimal(28)	Yes	This field holds the Schedule quantity	No
POSCH_SCH_DATE	_datetime_8	datetime(8)	Yes	This field holds the date in which the schedule qty has to be delivered.	No
POSCH_WH_CODE	_varchar_10	varchar(10)	Yes	This field holds the Warehouse in which the schedule qty has to be moved	No
POSCH_MOVED_QTY_PUOM	_decimal_28_8	decimal(28)	Yes	This field holds the qty that has been received from the supplier and moved to the warehouse	No
POSCH_SCH_STATUS	_varchar_5	varchar(5)	Yes	This field holds the schedule status.	No
POSCH_CREATEDDATE	_datetime_8	datetime(8)	Yes	This field holds the date when the PO schedule details created in the system	No
POSCH_CREATED_BY	_varchar_30	varchar(30)	Yes	This field holds the user who created the PO schedule details	No
POSCH_MODIFIEDDATE	_datetime_8	datetime(8)	Yes	This field holds the date when the PO schedule details modified in the system	No
POSCH_MODIFIED_BY	_varchar_30	varchar(30)	Yes	This field holds the user who modified the PO schedule details	No

Table Name :	PO_POSC_SUP_CORR_DETAILS
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.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
POSC_OUINSTANCE	_decimal_10_0	decimal(10)	No	This field holds the OUinstance in which the supplier/buyer remarks details for the PO are created	Yes
POSC_PO_NO	_varchar_40	varchar(40)	No	This field holds the Purchase order number	Yes
POSC_PO_LINE_NO	_decimal_10_0	decimal(10)	No	Each item record requested in the purchase Order is associated with this key .	Yes
POSC_LINE_NO	_decimal_10_0	decimal(10)	No	This field holds the line nos for the remarks entered for the combination of POno , Amendmentno and PO line itemno	Yes
POSC_DATE	_datetime_8	datetime(8)	Yes	This field holds the date on which the correspodence details are entered	No
POSC_SUPP_REMARKS	_varchar_255	varchar(255)	Yes	This field holds the supplier remarks	No
POSC_BUYER_REMARKS	_varchar_255	varchar(255)	Yes	This field holds the buyer remarks	No
POSC_CREATEDDATE	_datetime_8	datetime(8)	Yes	This field holds the date on which the supplier correspondence details for a PO line item is created	No
POSC_CREATED_BY	_varchar_30	varchar(30)	Yes	This field holds the user id by whom the supplier correspondence details for a PO line item is created	No
POSC_MODIFIEDDATE	_datetime_8	datetime(8)	Yes	This field holds the date on which the supplier correspondence details for a PO line item is modified	No
POSC_MODIFIED_BY	_varchar_30	varchar(30)	Yes	This field holds the user id by whom the supplier correspondence details for a PO line item is modified	No
posc_correspondencetype	udd_documentno	varchar(40)	Yes	Supplier correspondence type information is stored here	No
posc_supp_refno	udd_documentno	varchar(40)	Yes	Supplier reference # is stored here	No

Table Name :	PO_POSOPT_SETOPTION_INFO
Comment :	This table holds the Set option for PO component

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
POSOPT_PO_OUINSTANCE	_decimal_10_0	decimal(10)	Yes	This field holds the ouinstance in which the PO Options had set	No
POSOPT_AUTO_PO_NUM_TYPE	_varchar_25	Varchar(25)	Yes	This field holds the Numbering type for Auto Po generation	No
POSOPT_MULTI_PRT_TYP_ALLOWED	_varchar_5	varchar(5)	Yes	This field holds the flag Yes or No for Multi part type allowed	No
POSOPT_ALLOW_UNSRVCBLE_PRTS	_varchar_5	varchar(5)	Yes	This field holds Yes or No flag to allow unservicable parts	No
POSOPT_DEF_RCPT_TOL	_varchar_5	varchar(5)	Yes	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	No
POSOPT_CREATED_DATE	_datetime_8	datetime(8)	Yes	This field holds the date when the PO Set option details created in the system	No
POSOPT_CREATED_BY	_varchar_40	varchar(40)	Yes	This field holds the user who created the PO Set option details	No
POSOPT_MODIFIED_DATE	_datetime_8	datetime(8)	Yes	Date in which the option setting was modified is stored here	No
POSOPT_MODIFIED_BY	_varchar_40	varchar(40)	Yes	This field holds the date when the PO Set option details modified in the system	No
POSOPT_ALLOW_ORDG_REV_CAP_PO	UDD_PosOpt_Allow_Ord	varchar(20)	Yes	This field holds Yes or No flag to allow ordering revenue under capital PO	No
POSOPT_PO_COST_AMD_ALLOWED	_varchar_5	varchar(5)	Yes	This field holds Yes Y or No N flag to allow cost amendment for Exchange, Service and Adhoc POs	No
POSOPT_PO_POPARTCOST	udd_txt255	varchar(255)	Yes	This field holds PO part cost arriving values	No
POSOPT_PO_PRTLDTIME	udd_txt255	varchar(255)	Yes	Maximum lead time of the part	No
POSOPT_QC_Clrnce_Chk	_varchar_20	varchar(20)	Yes	Quality clearance check	No
POSOPT_ALLOW_CLOSE_PO	udd_txt5	varchar(5)	Yes	To save the value selected in the field Allow amendment of Closed PO	No
REPLICATION_KEY	_bigint_8	Bigint(8)	No	Unique Number	Yes

Table Name :	PO_POTMCN_PO_TERMS_CONDNS
Comment :	This table holds the Terms and Condition of purchase order document

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
POTMCN_OUINSTANCE	_decimal_10_0	decimal(10)	No	This field holds the ouinstance in which the Term and condition details of the PO have been created	Yes
POTMCN_PO_NO	_varchar_40	varchar(40)	No	This field holds the Purchase order number	Yes
POTMCN_PAYTERM_CODE	_varchar_25	Varchar(25)	Yes	This field holds the Unique identifier for the Payterm	No
POTMCN_PAY_TO_SUPP	_varchar_45	varchar(45)	Yes	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
POTMCN_PAY_TO_SUPP_OU	_decimal_10_0	decimal(10)	Yes	This field holds the pay to supplier Ouinstance where the supplier is registered.	No
POTMCN_PAYMENT_MODE	_varchar_5	varchar(5)	Yes	This field holds varous payment mode. list of values are Cq Check Cs Cash DD Demand Draft P ay order O rder CC Credit Card	No
POTMCN_INSURANCE_TERMS	_varchar_150	varchar(150)	Yes	This field holds the insurence term of purchase order document.	No
POTMCN_INSURANCE_LIABILITY	_varchar_25	Varchar(25)	Yes	This field holds insurance liability of the PO document List of values are O urs S upplier Ot her	No
POTMCN_INSURANCE_AMT	_decimal_28_8	decimal(28)	Yes	This field holds the insurence amount of the purchase order document.	No
POTMCN_INCO_TERM	_varchar_150	varchar(150)	Yes	This field holds the INCO term of the purchase order document.	No
POTMCN_DELIVERY_POINT	_varchar_255	varchar(255)	Yes	This field holds the delivery point of the purchase order document.	No
POTMCN_TRANS_SHIPMENT	_varchar_5	varchar(5)	Yes	This field holds the transshipment of the purchase order document. List of values Y es N o	No
POTMCN_SHIP_PARTIAL	_varchar_5	varchar(5)	Yes	This field holds the ship partial of the purchase order document. List of values Y es N o	No
POTMCN_PAY_PRIORITY	_varchar_5	varchar(5)	Yes	This field holds the payment priority of the PO doument List of values are 1.High, 2.Normal 3.Low	No
POTMCN_SHIP_BY	_varchar_25	Varchar(25)	Yes	Populate the ship by combo with the list of shipping methods in active status defined in the Logistics common master component.	No
POTMCN_PKG_CODE	_varchar_25	Varchar(25)	Yes	Populate the packaging code combo with the list of packaging codes in active status defined in the Logistics common master component.	No
POTMCN_SHIP_PAYMENT	_varchar_25	Varchar(25)	Yes	This field holds the list of shipping payment methods in active status defined in the Logistics common master component.	No
POTMCN_REMARKS	_varchar_255	varchar(255)	Yes	This field holds the remarks of the purchase order documens terms and condition.	No
POTMCN_CREATEDDATE	_datetime_8	datetime(8)	Yes	This field holds the date when the PO term and condition created in the system	No
POTMCN_CREATED_BY	_varchar_30	varchar(30)	Yes	This field holds the user who created the PO terms and conditions	No
POTMCN_MODIFIEDDATE	_datetime_8	datetime(8)	Yes	This field holds the date when the PO term and condition modified in the system	No
POTMCN_MODIFIED_BY	_varchar_30	varchar(30)	Yes	This field holds the user who modified the PO terms and conditions	No
POTMCN_GTA_REFDOC_NO	_varchar_40	varchar(40)	Yes	This field holds the General Terms Agreement reference documentno	No
POTMCN_REFDOC_DATE	_datetime_8	datetime(8)	Yes	This field holds the General Terms Agreement reference document Date	No
POTMCN_GTA_REMARKS	_varchar_255	varchar(255)	Yes	This field holds the General Terms Agreement remarks	No
POTMCN_WARRANTY	_varchar_5	varchar(5)	Yes	This field holds the warranty flag of the purchase order document. List of values Y es N o	No
POTMCN_WARR_BASIS	_varchar_25	Varchar(25)	Yes	This field holds the Warranty basis of the purchase order document. List of values 1. Both 2. calender 3. Usage	No
POTMCN_WARR_AGREEMENT_NO	_varchar_40	varchar(40)	Yes	This field holds the Warranty agreement no . if warrant flag is yes then warranty agreement no is mandatory	No
POTMCN_ADVANCE_PAY_AMT	udd_quantity	numeric(13)	Yes	This field holds the advance payable amount. If advance payable flag is yes then this is mandatory	No
POTMCN_ADVANCE_PAYDATE	_datetime_8	datetime(8)	Yes	This field holds the advance payable date. If advance payable flag is yes then this is mandatory	No
POTMCN_ADVANCE_PERC	udd_quantity	numeric(13)	Yes	This field holds the advance percentage.	No
POTMCN_ADVANCE_PERC_ON	_varchar_25	Varchar(25)	Yes	This field holds the advance percentage on of the purchase order document. List of values 1. Basic Value 2. Total Value	No
POTMCN_ADVANCE_PAYABLE	_varchar_5	varchar(5)	Yes	This field holds the advance payable flag of the purchase order document. List of values Y es N o	No
POTMCN_ADVANCE_TOL_PERC	udd_quantity	numeric(13)	Yes	This field holds the advance tolerence percentage.	No
POTMCN_DDCHARGES_BORNEBY	_varchar_25	Varchar(25)	Yes	This field holds the DD charges brone by of the purchase order document. List of values 1. self 2.supplier	No
POTMCN_PAY_TO_SUPP_ID	_decimal_10_0	decimal(10)	Yes	This field holds the pay to supplier address ids	No
POTMCN_PAYMENT_NOTES	_varchar_2000	varchar(2000)	Yes	This field holds the payment notes	No
POTMCN_PACKAGING_NOTES	_varchar_2000	varchar(2000)	Yes	This field holds the packaging notes	No
POTMCN_PORT_OF_DEP	_varchar_32	varchar(32)	Yes	This field holds the port of depature	No
POTMCN_CARRIERAGENCY	_varchar_20	varchar(20)	Yes	This field holds the list of carrier agencies	No
POTMCN_SHIPPING_NOTES	_varchar_2000	varchar(2000)	Yes	This field holds the shipping notes	No
POTMCN_FWD_CVR_RATE	udd_amount	numeric(13)	Yes	This field holds the Forward Covering Rate	No
POTMCN_INV_AT	udd_txt150	varchar(150)	Yes	This field holds the Invoice At	No
POTMCN_FWD_CVR_APPL	udd_txt150	varchar(150)	Yes	This field holds the Forward Cover Applicable	No
POTMCN_ADV_PAID	udd_amount	numeric(13)	Yes	Advance paid Flag	No
POTMCN_WARRBEGINS	udd_flag	varchar(25)	Yes	To save the Warranty begni on combo valued from PO Terms and conditions page	No
POTMCN_DURATION	udd_duration	numeric(13)	Yes	To save the Warranty duration details entered by the user	No
POTMCN_DURPERIOD	udd_flag	varchar(25)	Yes	To save the warranty duration period combo values selected by the user.	No
POTMCN_FLIGHTHRS	udd_duration	numeric(13)	Yes	To save the Floght Hours entered by the user	No
POTMCN_FLIGHTCYCLES	udd_duration	numeric(13)	Yes	To save the Flight cycles entered by the user	No
POTMCN_TERMS_REFERENCE	udd_remarks	varchar(255)	Yes	To save the Terms and reference enterd by the user in PO terms and condtions details page.	No
POTMCN_RMANO	udd_documentno	varchar(40)	Yes	To capture the RMA Number	No
POTMCN_RMADATE	udd_time	datetime(8)	Yes	To capture the RMA date for the given RMA No	No
POTMCN_RET_SUPP_ID	udd_vendorcode	varchar(45)	Yes	To populate the Pay To Supplier Address ID combo with all the Address Id of the supplier	No
POTMCN_DELIVERTOCODE	udd_documentno	varchar(40)	Yes	This field holds the values of Delivery code	No

Table Name :	PO_POUDI_USER_DEF_INFO
Comment :	This table holds the User define information of purchase order document

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
POUDI_OUINSTANCE	_decimal_10_0	decimal(10)	No	This field holds the ouinstance in which the the user define information for the Purchase order created	Yes
POUDI_PO_NO	_varchar_40	varchar(40)	No	This field holds the Purchase order number	Yes
POUDI_USER_DEF_DESC1	_varchar_30	varchar(30)	Yes	This field holds the first description of user defined options.	No
POUDI_USER_DEF_OPT1	_varchar_30	varchar(30)	Yes	This field holds the first user defined option	No
POUDI_USER_DEF_DESC2	_varchar_30	varchar(30)	Yes	This field holds the second description of user defined options.	No
POUDI_USER_DEF_OPT2	_varchar_30	varchar(30)	Yes	This field holds the second user defined option	No
POUDI_USER_DEF_DESC3	_varchar_30	varchar(30)	Yes	This field holds the third description of user defined options.	No
POUDI_USER_DEF_OPT3	_varchar_30	varchar(30)	Yes	This field holds the third user defined option	No
POUDI_USER_DEF_DESC4	_varchar_30	varchar(30)	Yes	This field holds the fourth description of user defined options.	No
POUDI_USER_DEF_OPT4	_varchar_30	varchar(30)	Yes	This field holds the fourth user defined option	No
POUDI_USER_DEF_REMARKS	_varchar_255	varchar(255)	Yes	This field holds the user defined remarks	No
POUDI_CREATED_DATE	_datetime_8	datetime(8)	Yes	This field holds the date when the PO user define information is created in the system	No
POUDI_CREATED_BY	_varchar_30	varchar(30)	Yes	This field holds the user who created the PO user define information	No
POUDI_MODIFIED_DATE	_datetime_8	datetime(8)	Yes	This field holds the date when the PO inspection detail is modified in the system	No
POUDI_MODIFIED_BY	_varchar_30	varchar(30)	Yes	This field holds the user who modified the PO user define information	No