I assume you are using some packaged application suite. What packaged application suite are you using and what application within that suite are you using?
Commented Sep 18, 2009 at 19:56These tables ARE the base tables. You should not normaly write directly to them.
The open interfaces of the Purchasing module (for EBS 11.5.10) are described in Metalink note 359295.1. Review the documentation carefully before using the interfaces. Don't write directly to the base tables -- this could void your support.
answered Sep 21, 2009 at 9:26 Vincent Malgrat Vincent Malgrat 67.6k 9 9 gold badges 121 121 silver badges 174 174 bronze badges1)DOCUMENT_TYPE_CODE = This column will accept any of the following string. STANDARD BLANKET PLANNED CONTRACT
2)VENDOR_NAME =It will accept valid vendor name . by using PO_VENDORS Table we can findout wether vendorname is valid or not.
6)SHIPTO = HR_LOCATIONS table will be use to find the location is valid or not.
7)BILLTO = HR_LOCATIONS table will be use to find the location is valid or not.
8)CREATION_DATE =It should be in the Date Format.And also
9)AGENT_ID = it should be valid agentID(Buyer ID) .By using PO_AGENTS table we can find out wether agent_id is valid or not.
10)ORG_ID =It should be Valid OrgID. By using hr_operating_units table we can find wether it is valid or not.
11)AUTHORIZATION_STATUS = Valid status either APPROVED,INCOMPLETE,CANCELLED 12)CURRENCY_CODE = Valid Currency Code from FND_CURRENCIES table
we can find wether valid currency code or not.
LINE_NUM = Will accept only unique values.
LINE_TYPE = Should be a Valid Line type. By using PO_LINE_TYPES we can findout wether it is valid or not.
ITEM =It should be a valid Item by using MTL_SYSTEM_ITEMS_B table we can find wether valid Item or not.
ItemDesc = Item Desc also should be valid description
UOM_Code =Should be valid UOM by using MTL_UNITS_OF_MEASURES table we can find wether it is valid or not.
QUANTItY =Will accept any Positive Number
unit_Price = Will accept any Positive Number
NEED_BY_DATE = date Format and >= PO creation Date(from PO Headers Interface table)
PROMISED_DATE = date Format and >= PO creation Date(from PO Headers Interface table)
ORG_ID =It should be Valid OrgID. By using hr_operating_units table we can find wether it is valid or not.
SHIP_TO_ORG =Valid ORg_ID
ShipTo_Loc = Valid Shiping Location
set_of_books_id :valid Set of Books ID : Gl_sets_of_books
org_id :Valid OrgID : HR_OPERATING_UNITS
destination_organization_id : Valid Organization ID : ORG_ORGANIZATION_ID
quantity_ordered : Positive Numer (as per the shippment level total)