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