PON_SFO_PARAMETERS_GT
Table PON_SFO_PARAMETERS_GT is a temporary table which is being used to hold Sourcing PO data to generate SFO parameters in Draft Purchase Order Creation Flow
Details
-
Schema: FUSION
-
Object owner: PON
-
Object type: TABLE
-
Tablespace: Default
Columns
| Name | Datatype | Length | Precision | Not-null | Comments | Status |
|---|---|---|---|---|---|---|
| AUCTION_HEADER_ID | NUMBER | 18 | Yes | Auction Header Identifier | ||
| SFO_AGREEMENT_LINE_NUMBER | NUMBER | 18 | Orchestration Agreement Line Number. | |||
| SFO_PTR_ID | NUMBER | 18 | Unique identifier of a Primary Trade Relationship in an Orchestration Agreement. | |||
| SFO_AGREEMENT_NUMBER | VARCHAR2 | 100 | Indicates the orchestration agreement entered into between the legal entities, business units and trade organizations establishing a trade relationship. | |||
| PO_TRADING_ORGANIZATION_ID | NUMBER | 18 | Purchasing Trading Organization unique identifier. Indicates the inventory organization where the trade buy-sell transaction defined by the orchestration agreement is cost accounted. | |||
| SOLDTO_LE_ID | NUMBER | 18 | Sold to Legal Entity unique identifier. Indicates the party which is financially responsible for the purchases on a purchase order. | |||
| BILLTO_BU_ID | NUMBER | 18 | Bill-to Business Unit unique identifier. This captures the business unit which vouches the supplier invoices received for a purchase order. | |||
| BILL_TO_LOCATION_ID | NUMBER | 18 | Ship-to location unique identifier (References HR_LOCATIONS_ALL.location_id). | |||
| BID_NUMBER | NUMBER | 18 | Yes | Bid Number | ||
| PRC_BU_ID | NUMBER | 18 | Procurement BU id | |||
| REQ_BU_ID | NUMBER | 18 | Req Bu Id | |||
| TRADING_PARTNER_ID | NUMBER | 18 | Identifier for bidder trading partner | |||
| SUPPLIER_NUMBER | VARCHAR2 | 30 | Key Flexfield: segment of the key flexfield. | |||
| VENDOR_SITE_ID | NUMBER | 18 | stores vendor site id used to create the po | |||
| VENDOR_SITE_CODE | VARCHAR2 | 240 | Stores the vendor_site_code of the supplier. | |||
| DESTINATION_TYPE_CODE | VARCHAR2 | 25 | DESTINATION TYPE CODE (INVENTORY OR EXPENSE) | |||
| AGREEMENT_HEADER_ID | NUMBER | 18 | AGREEMENT_HEADER_ID | |||
| INVENTORY_ITEM_ID | VARCHAR2 | 25 | INVENTORY ITEM ID | |||
| ITEM_NUMBER | VARCHAR2 | 300 | ITEM NUMBER | |||
| CATEGORY_ID | NUMBER | 18 | Unique Identifier for category | |||
| PURCHASING_CATEGORY | VARCHAR2 | 2000 | PURCHASING_CATEGORY | Obsolete | ||
| RECEIVING_ORGANIZATION_ID | NUMBER | 18 | RECEIVING_ORGANIZATION_ID | |||
| RECEIVING_ORGANIZATION_CODE | VARCHAR2 | 18 | RECEIVING_ORGANIZATION_CODE | |||
| DEFAULT_LEGAL_ENTITY | NUMBER | 18 | DEFAULT_LEGAL_ENTITY |