Purchase Order inbound staging table
The Purchase Order inbound [sn_fcms_intg_imp_order] staging table temporarily stores important data about purchase orders before this data is sent to the primary table.
The following table lists fields for the Purchase Order inbound [sn_fcms_intg_imp_order] staging table.
| Field | Data type | Description |
|---|---|---|
| Blanket order end date | String | Date on which the blanket order is expected to end.If you're unsure of the delivery date of the product, you can provide an estimated time frame, which then creates a blanket order. |
| Blanket order start date | String | Date on which the blanket order is expected to start.If you're unsure of the delivery date of the product, you can provide an estimated time frame, which then creates a blanket order. |
| Business owner | String | The user who placed the order. |
| Cost center | String | Cost center that incurs the expense of the order. |
| ERP PO number | String | Purchase order number from the ERP system. This is a mandatory field. |
| ERP source | String | ERP source from which data is imported. For purchase order, receipt, and invoice integrations, the ERP source is determined through the legal entity associated with these records.This is a mandatory field. |
| Legal entity | String | Legal entity corresponding to a purchase. |
| Order type | String | Type of the purchase order- Standard or Blanket. |
| Payment term | String | The agreed upon time and conditions under which a payment to a supplier is made. |
| PO amount | String | Total amount of the purchase order. |
| PO amount currency | String | Currency of the purchase order. |
| PO status | String | Status of the purchase order. |
| Purchasing organization | String | The organization making the purchase order. |
| Supplier company name | String | Supplier company name for which the purchase order is generated. |
Parent Topic:Inbound staging tables for Sourcing and Procurement Operations
Related topics
CMDB Model Category Stage inbound staging table
CMDB Service Model Stage inbound staging table
CMN Location Stage inbound staging table
Cost Center Stage inbound staging table
Department Stage inbound staging table
ERP Plant Address Mapping Stage inbound staging table
FX Currency Stage inbound staging table
FX Rate Stage inbound staging table
Fixed asset details stage inbound table
GL Account Stage inbound staging table
Import Availability Updates inbound staging table
Availability Error staging table
Cost Allocation inbound staging table (Deprecated)
Purchase Order Line inbound staging table
Legal Entity Stage inbound staging table
Office Location Stage inbound staging table
Order Acknowledgement staging table
Order Acknowledgement Error staging table
Payment Terms Stage inbound staging table
Price Error outbound staging table
Product Model Stage inbound staging table
Purchase Entity Stage inbound staging table
Purchase Line Stage inbound staging table
Purchase Requisition staging table
Spend Shipment Import inbound staging table
Supplier Product Stage inbound staging table
Third Party Sourcing Registration staging table
Third Party Unit Mapping staging table