oracle 填充采购订单接口表？
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/1446191/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
Populating purchase order interface tables?
提问by Orapps
What are the mandatory fields in the following tables that I need to populate in order that they can pass validation and can be imported in the respective base tables
我需要填充下表中的哪些必填字段才能通过验证并可以导入到相应的基表中
- PO_HEADERS_ALL (Purchasing documents open interface)
- PO_LINES_ALL (Purchasing documents open interface)
- PO_LINE_LOCATIONS_ALL (Purchasing documents open interface)
- PO_DISTRIBUTIONS_ALL (Purchasing documents open interface)
- PO_HEADERS_ALL（采购文件开放接口）
- PO_LINES_ALL（采购文件开放接口）
- PO_LINE_LOCATIONS_ALL（采购文件开放界面）
- PO_DISTRIBUTIONS_ALL（采购文件开放接口）
回答by Vincent Malgrat
These tables AREthe 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.
采购模块的开放接口（适用于 EBS 11.5.10）在 Metalink 注释359295.1 中进行了描述。在使用接口之前仔细查看文档。不要直接写入基表——这可能会使您的支持无效。
回答by dheeru
PO_HEADERS_INTERFACE
PO_HEADERS_INTERFACE
1)DOCUMENT_TYPE_CODE = This column will accept any of the following string. STANDARD BLANKET PLANNED CONTRACT
1)DOCUMENT_TYPE_CODE = 此列将接受以下任何字符串。标准一揽子计划合同
2)VENDOR_NAME =It will accept valid vendor name . by using PO_VENDORS Table we can findout wether vendorname is valid or not.
2)VENDOR_NAME =它将接受有效的供应商名称。通过使用 PO_VENDORS 表，我们可以找出供应商名称是否有效。
4)VENDOR_SITE_NAME = PO_VENDOR_SITES_ALL
4)VENDOR_SITE_NAME = PO_VENDOR_SITES_ALL
5)VENDOR_CONTACT_NAME = PO_VENDOR_CONTACTS
5)VENDOR_CONTACT_NAME = PO_VENDOR_CONTACTS
6)SHIPTO = HR_LOCATIONS table will be use to find the location is valid or not.
6)SHIPTO = HR_LOCATIONS 表将用于查找位置是否有效。
7)BILLTO = HR_LOCATIONS table will be use to find the location is valid or not.
7)BILLTO = HR_LOCATIONS 表将用于查找位置是否有效。
8)CREATION_DATE =It should be in the Date Format.And also <=SYSDATE
8)CREATION_DATE =它应该是日期格式。而且<=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.
9)AGENT_ID = 它应该是有效的 agentID(Buyer ID) 。通过使用 PO_AGENTS 表我们可以找出 agent_id 是否有效。
10)ORG_ID =It should be Valid OrgID. By using hr_operating_units table we can find wether it is valid or not.
10)ORG_ID =它应该是有效的OrgID。通过使用 hr_operating_units 表，我们可以找到它是否有效。
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.
11)AUTHORIZATION_STATUS = 有效状态批准、不完整、取消 12)CURRENCY_CODE = FND_CURRENCIES 表中的
有效货币代码我们可以找到有效的货币代码与否。
PO_LINES_INTERFACE:
PO_LINES_接口：
LINE_NUM = Will accept only unique values.
LINE_NUM = 将只接受唯一值。
LINE_TYPE = Should be a Valid Line type. By using PO_LINE_TYPES we can findout wether it is valid or not.
LINE_TYPE = 应该是有效的线型。通过使用 PO_LINE_TYPES 我们可以找出它是否有效。
ITEM =It should be a valid Item by using MTL_SYSTEM_ITEMS_B table we can find wether valid Item or not.
ITEM =通过使用 MTL_SYSTEM_ITEMS_B 表我们可以找到是否有效的项目，它应该是一个有效的项目。
ItemDesc = Item Desc also should be valid description
ItemDesc = Item Desc 也应该是有效的描述
UOM_Code =Should be valid UOM by using MTL_UNITS_OF_MEASURES table we can find wether it is valid or not.
UOM_Code = 应该是有效的 UOM 通过使用 MTL_UNITS_OF_MEASURES 表我们可以找到它是否有效。
QUANTItY =Will accept any Positive Number
QUANTItY = 接受任何正数
unit_Price = Will accept any Positive Number
unit_Price = 将接受任何正数
NEED_BY_DATE = date Format and >= PO creation Date(from PO Headers Interface table)
NEED_BY_DATE = 日期格式和 >= PO 创建日期（来自 PO 标题接口表）
PROMISED_DATE = date Format and >= PO creation Date(from PO Headers Interface table)
PROMISED_DATE = 日期格式和 >= PO 创建日期（来自 PO 标题接口表）
ORG_ID =It should be Valid OrgID. By using hr_operating_units table we can find wether it is valid or not.
ORG_ID = 它应该是有效的 OrgID。通过使用 hr_operating_units 表，我们可以找到它是否有效。
SHIP_TO_ORG =Valid ORg_ID
SHIP_TO_ORG = 有效的 ORg_ID
ShipTo_Loc = Valid Shiping Location
ShipTo_Loc = 有效的发货地点
PO_DISTRIBUTIONS_INTERFACE:
PO_DISTRIBUTIONS_INTERFACE：
interface_header_id
interface_header_id
interface_line_id
interface_line_id
interface_distribution_id
interface_distribution_id
set_of_books_id :valid Set of Books ID : Gl_sets_of_books
set_of_books_id ：有效的书籍集 ID ：Gl_sets_of_books
org_id :Valid OrgID : HR_OPERATING_UNITS
org_id : 有效的 OrgID : HR_OPERATING_UNITS
destination_organization_id : Valid Organization ID : ORG_ORGANIZATION_ID
destination_organization_id：有效的组织 ID：ORG_ORGANIZATION_ID
quantity_ordered : Positive Numer (as per the shippment level total)
quantity_ordered ：正数（根据装运水平总计）
回答by APC
You're using Oracle Apps right? Well, that's a complicated schema. But you should be able to DESCribethe table in SQL*Plus or whatever IDE you're using. In which case, the minmim set of columns you have to populate are the ones which are declared NOT NULL.
您在使用 Oracle Apps 对吗？嗯，这是一个复杂的模式。但是您应该能够DESCribe在 SQL*Plus 或您使用的任何 IDE 中访问该表。在这种情况下，您必须填充的最小列集是声明为 NOT NULL 的列。
