Mandatory Field in Purchase Order Interface Tables

PO_HEADERS_INTERFACE

1)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.

4)VENDOR_SITE_NAME = PO_VENDOR_SITES_ALL

5)VENDOR_CONTACT_NAME = PO_VENDOR_CONTACTS

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 <=SYSDATE

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.

PO_LINES_INTERFACE:

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 

PO_DISTRIBUTIONS_INTERFACE:

interface_header_id

interface_line_id

interface_distribution_id

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)