[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | OZF_SD_BATCH_LINES_INT_ALL |
|---|---|
| Object Type: | TABLE |
| Owner: | OZF |
| FND Design Data: |  OZF.OZF_SD_BATCH_LINES_INT_ALL
|
| Subobject Name: | |
| Status: | VALID |
interface table to receive data from vendor authorization transmission of Supplier Ship and Debit Batch in Oracle Trade Management
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| OZF_SD_BATCH_LINES_INT_ALL_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 BATCH_LINE_INT_ID
|
| OZF_SD_BATCH_LINES_INT_ALL_N1 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
SHIP_FRM_SD_CLAIM_REQUEST_ID
BATCH_LINE_NUMBER
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| BATCH_LINE_INT_ID | NUMBER | Yes | Interface record identifier | |
| FRM_CONTACT1_NAME | VARCHAR2 | (360) | Distributor Contact Name | |
| FRM_CONTACT1_EMAIL | VARCHAR2 | (2000) | Contact email of From Role | |
| FRM_CONTACT1_FAX | VARCHAR2 | (60) | Contact fax of From Role | |
| FRM_CONTACT1_PHONE | VARCHAR2 | (60) | Contact phone of From Role | |
| FRM_GBL_PTNR_ROLE_CLASS_CODE | VARCHAR2 | (30) | Partner classification code | |
| FRM_BUSINESS_NAME | VARCHAR2 | (360) | The name of a business entity sending feed | |
| FRM_GBL_BUSINESS_ID | VARCHAR2 | (360) | Business identifier. The DUNS number is specified by RosettaNet | |
| FRM_GBL_SUPPLY_CHAIN_CODE | VARCHAR2 | (60) | Global Supply Chain Code | |
| FRM_PROP_BUSINESS_ID | VARCHAR2 | (60) | Business identifier assigned and administered by a private authority | |
| FRM_PROP_DOMAIN_ID1 | VARCHAR2 | (60) | Descriptor used to categorize an organization or business entity in the Proprietary Business Identifier | |
| FRM_PROP_ID_AUTHORITY1 | VARCHAR2 | (60) | Identifies an organization or business entity responsible for managing one or more lists of identifiers | |
| FRM_GBL_PARTNER_CLASS_CODE | VARCHAR2 | (60) | Code identifying a partner's function in the supply chain | |
| FRM_CONTACT2_NAME | VARCHAR2 | (360) | Contact name of From Role | |
| FRM_CONTACT2_EMAIL | VARCHAR2 | (2000) | Contact email of From Role | |
| FRM_CONTACT2_FAX | VARCHAR2 | (60) | Contact fax of From Role | |
| FRM_CONTACT2_PHONE | VARCHAR2 | (60) | Contact phone of From Role | |
| FRM_GBL_LOCATION_ID | VARCHAR2 | (60) | Location Identifier | |
| FRM_PROP_DOMAIN_ID2 | VARCHAR2 | (60) | A descriptor used to categorize an organization or business entity in the Proprietary Business Identifier | |
| FRM_PROP_ID_AUTHORITY2 | VARCHAR2 | (60) | Identifies an organization or business entity responsible for managing one or more lists of identifiers | |
| FRM_PROP_LOCATION_ID | VARCHAR2 | (60) | Location identifier assigned and administered by a private authority | |
| FRM_ADDRESS_LINE1 | VARCHAR2 | (240) | First line of physical address | |
| FRM_ADDRESS_LINE2 | VARCHAR2 | (240) | Second line of physical address | |
| FRM_ADDRESS_LINE3 | VARCHAR2 | (240) | Third line of physical address | |
| FRM_CITY_NAME | VARCHAR2 | (60) | City name | |
| FRM_GBL_COUNTRY_CODE | VARCHAR2 | (2) | Country code | |
| FRM_NATIONAL_POSTAL_CODE | VARCHAR2 | (60) | Zip code | |
| FRM_POBOX_ID | VARCHAR2 | (60) | PO Box Identifier | |
| FRM_REGION_NAME | VARCHAR2 | (60) | Name of a state or province within a country | |
| GBL_DOC_FUNCTION_CODE | VARCHAR2 | (9) | Code identifying the function of a document as either a request or a response | |
| SHIP_FRM_SD_AUTHORIZATION_ID | VARCHAR2 | (255) | Identification number assigned to an approved Ship From Stock and Debit Authorization request by Vendor | |
| DIST_BY_BUSINESS_NAME | VARCHAR2 | (360) | Name of a business entity | |
| DIST_BY_GBL_BUSINESS_ID | VARCHAR2 | (360) | Business identifier. The DUNS number is specified by RosettaNet | |
| DIST_BY_GBL_SUPPLY_CHAIN_CODE | VARCHAR2 | (60) | Global Supply Chain Code | |
| DIST_BY_PROP_BUSINESS_ID | VARCHAR2 | (60) | Business identifier assigned and administered by a private authority | |
| DIST_BY_PROP_DOMAIN_ID1 | VARCHAR2 | (60) | Descriptor used to categorize an organization or business entity in the Proprietary Business Identifier | |
| DIST_BY_PROP_IDAUTHORITY1 | VARCHAR2 | (60) | Identifies an organization or business entity responsible for managing one or more lists of identifiers | |
| DIST_BY_GBL_PARTNER_CLASS_CODE | VARCHAR2 | (60) | Code identifying a partners function in the supply chain | |
| DIST_BY_CONTACT1_NAME | VARCHAR2 | (360) | Distributor contact name | |
| DIST_BY_CONTACT1_EMAIL | VARCHAR2 | (2000) | Distributor contact email | |
| DIST_BY_CONTACT1_FAX | VARCHAR2 | (60) | Distributor Contact Fax | |
| DIST_BY_CONTACT1_PHONE | VARCHAR2 | (60) | Distributor contact phone | |
| DIST_BY_GBL_LOCATION_ID | VARCHAR2 | (360) | Location Identifier | |
| DIST_BY_PROP_DOMAIN_ID2 | VARCHAR2 | (60) | Descriptor used to categorize an organization or business entity in the Proprietary Business Identifier | |
| DIST_BY_PROP_IDAUTHORITY2 | VARCHAR2 | (60) | Name that identifies an organization or business entity responsible for managing one or more lists of identifiers | |
| DIST_BY_PROP_LOCATION_ID | VARCHAR2 | (60) | Location identifier assigned and administered by a private authority | |
| DIST_BY_ADDRESS_LINE1 | VARCHAR2 | (240) | First line of physical address | |
| DIST_BY_ADDRESS_LINE2 | VARCHAR2 | (240) | Second line of physical address | |
| DIST_BY_ADDRESS_LINE3 | VARCHAR2 | (240) | Third line of physical address | |
| DIST_BY_CITY_NAME | VARCHAR2 | (60) | City name of the Distributor | |
| DIST_BY_GBL_COUNTRY_CODE | VARCHAR2 | (2) | Country code | |
| DIST_BY_NATIONAL_POSTAL_CODE | VARCHAR2 | (60) | Zip code | |
| DIST_BY_POBOX_ID | VARCHAR2 | (60) | Postbox number | |
| DIST_BY_REGION_NAME | VARCHAR2 | (60) | Name of a state or province within a country | |
| SHIP_TO_BUSINESS_NAME | VARCHAR2 | (360) | Name of a Business Entity | |
| SHIP_TO_GBL_BUSINESS_ID | VARCHAR2 | (360) | Business identifier. The DUNS number is specified by RosettaNet | |
| SHIP_TO_GBL_SUPPLY_CHAIN_CODE | VARCHAR2 | (60) | Global Supply chain code | |
| SHIP_TO_PROP_BUSINESS_ID | VARCHAR2 | (60) | Business identifier assigned and administered by a private authority | |
| SHIP_TO_PROP_DOMAIN_ID2 | VARCHAR2 | (60) | Descriptor used to categorize an organization or business entity in the Proprietary Business Identifier | |
| SHIP_TO_PROP_ID_AUTHORITY2 | VARCHAR2 | (60) | Identifies an organization or business entity responsible for managing one or more lists of identifiers | |
| SHIP_TO_GBL_PARTNER_CLASS_CODE | VARCHAR2 | (60) | Code identifying a partners function in the supply chain | |
| SHIP_TO_CONTACT1_NAME | VARCHAR2 | (360) | Ship to contact name | |
| SHIP_TO_CONTACT1_EMAIL | VARCHAR2 | (2000) | Ship to contact email | |
| SHIP_TO_CONTACT1_FAX | VARCHAR2 | (60) | Ship to contact fax | |
| SHIP_TO_CONTACT1_PHONE | VARCHAR2 | (60) | Ship to contact phone | |
| SHIP_TO_GBL_LOCATION_ID | VARCHAR2 | (360) | Location Identifier | |
| SHIP_TO_PROP_DOMAIN_ID1 | VARCHAR2 | (60) | Descriptor used to categorize an organization or business entity in the Proprietary Business Identifier | |
| SHIP_TO_PROP_ID_AUTHORITY1 | VARCHAR2 | (60) | Name that identifies an organization or business entity responsible for managing one or more lists of identifiers | |
| SHIP_TO_PROP_LOCATION_ID | VARCHAR2 | (60) | Location identifier assigned and administered by a private authority | |
| SHIP_TO_ADDRESS_LINE1 | VARCHAR2 | (240) | First line of physical address | |
| SHIP_TO_ADDRESS_LINE2 | VARCHAR2 | (240) | Second line of physical address | |
| SHIP_TO_ADDRESS_LINE3 | VARCHAR2 | (240) | Third line of physical address | |
| SHIP_TO_CITY_NAME | VARCHAR2 | (60) | City name | |
| SHIP_TO_GBL_COUNTRY_CODE | VARCHAR2 | (2) | Country code | |
| SHIP_TO_NATIONAL_POSTAL_CODE | VARCHAR2 | (60) | National Postal Code | |
| SHIP_TO_POBOX_ID | VARCHAR2 | (60) | Postbox number | |
| SHIP_TO_REGION_NAME | VARCHAR2 | (60) | Name of a state or province within a country | |
| SOLD_TO_BUSINESS_NAME | VARCHAR2 | (360) | Name of a business entity | |
| SOLD_TO_GBL_BUSINESS_ID | VARCHAR2 | (360) | Business identifier. The DUNS number is specified by RosettaNet | |
| SOLD_TO_GBL_SUPPLY_CHAIN_CODE | VARCHAR2 | (60) | Global Supply Chain Code | |
| SOLD_TO_PROP_BUSINESS_ID | VARCHAR2 | (60) | Business identifier assigned and administered by a private authority | |
| SOLD_TO_PROP_DOMAIN_ID2 | VARCHAR2 | (60) | Descriptor used to categorize an organization or business entity in the Proprietary Business Identifier | |
| SOLD_TO_PROP_ID_AUTHORITY2 | VARCHAR2 | (60) | Identifies an organization or business entity responsible for managing one or more lists of identifiers | |
| SOLD_TO_GBL_PARTNER_CLASS_CODE | VARCHAR2 | (60) | Code identifying a partners function in the supply chain | |
| SOLD_TO_CONTACT1_NAME | VARCHAR2 | (360) | Sold to contact name | |
| SOLD_TO_CONTACT1_EMAIL | VARCHAR2 | (2000) | Sold to contact email | |
| SOLD_TO_CONTACT1_FAX | VARCHAR2 | (60) | Sold to contact fax | |
| SOLD_TO_CONTACT1_PHONE | VARCHAR2 | (60) | Sold to contact phone | |
| SOLD_TO_GBL_LOCATION_ID | VARCHAR2 | (360) | Location Identifier | |
| SOLD_TO_PROP_DOMAIN_ID1 | VARCHAR2 | (60) | Descriptor used to categorize an organization or business entity in the Proprietary Business Identifier | |
| SOLD_TO_PROP_ID_AUTHORITY1 | VARCHAR2 | (60) | Name that identifies an organization or business entity responsible for managing one or more lists of identifiers | |
| SOLD_TO_PROP_LOCATION_ID | VARCHAR2 | (60) | Location identifier assigned and administered by a private authority | |
| SOLD_TO_ADDRESS_LINE1 | VARCHAR2 | (240) | First line of physical address | |
| SOLD_TO_ADDRESS_LINE2 | VARCHAR2 | (240) | Second line of physical address | |
| SOLD_TO_ADDRESS_LINE3 | VARCHAR2 | (240) | Third line of physical address | |
| SOLD_TO_CITY_NAME | VARCHAR2 | (60) | City name | |
| SOLD_TO_GBL_COUNTRY_CODE | VARCHAR2 | (2) | Country code | |
| SOLD_TO_NATIONAL_POSTAL_CODE | VARCHAR2 | (60) | Zip code | |
| SOLD_TO_POBOX_ID | VARCHAR2 | (60) | PO Box Identifier | |
| SOLD_TO_REGION_NAME | VARCHAR2 | (60) | Name of a state or province within a country | |
| USED_BY_BUSINESS_NAME | VARCHAR2 | (360) | Name of a business entity | |
| USED_BY_GBL_BUSINESS_ID | VARCHAR2 | (360) | Business identifier. The DUNS number is specified by RosettaNet | |
| USED_BY_GBL_SUPPLY_CHAIN_CODE | VARCHAR2 | (60) | Global Supply Chain Code | |
| USED_BY_PROP_BUSINESS_ID | VARCHAR2 | (60) | Business identifier assigned and administered by a private authority | |
| USED_BY_PROP_DOMAIN_ID1 | VARCHAR2 | (60) | Descriptor used to categorize an organization or business entity in the Proprietary Business Identifier | |
| USED_BY_PROP_ID_AUTHORITY1 | VARCHAR2 | (60) | Identifies an organization or business entity responsible for managing one or more lists of identifiers | |
| USED_BY_GBL_PARTNER_CLASS_CODE | VARCHAR2 | (60) | Code identifying a partners function in the supply chain | |
| USED_BY_CONTACT1_NAME | VARCHAR2 | (360) | End customer contact name | |
| USED_BY_CONTACT1_EMAIL | VARCHAR2 | (2000) | End customer contact email | |
| USED_BY_CONTACT1_FAX | VARCHAR2 | (60) | End Customer contact fax | |
| USED_BY_CONTACT1_PHONE | VARCHAR2 | (60) | End customer contact phone | |
| USED_BY_GBL_LOCATION_ID | VARCHAR2 | (360) | Location Identifier | |
| USED_BY_PROP_DOMAIN_ID2 | VARCHAR2 | (60) | Descriptor used to categorize an organization or business entity in the Proprietary Business Identifier | |
| USED_BY_PROP_ID_AUTHORITY2 | VARCHAR2 | (60) | Name that identifies an organization or business entity responsible for managing one or more lists of identifiers | |
| USED_BY_PROP_LOCATION_ID | VARCHAR2 | (60) | Location identifier assigned and administered by a private authority | |
| USED_BY_ADDRESS_LINE1 | VARCHAR2 | (240) | First line of physical address | |
| USED_BY_ADDRESS_LINE2 | VARCHAR2 | (240) | Second line of physical address | |
| USED_BY_ADDRESS_LINE3 | VARCHAR2 | (240) | Third line of physical address | |
| USED_BY_CITY_NAME | VARCHAR2 | (60) | City name | |
| USED_BY_GBL_COUNTRY_CODE | VARCHAR2 | (2) | Country code | |
| USED_BY_NATIONAL_POSTAL_CODE | VARCHAR2 | (60) | Zip code | |
| USED_BY_POBOX_ID | VARCHAR2 | (60) | Postbox number | |
| USED_BY_REGION_NAME | VARCHAR2 | (60) | Name of a state or province within a country | |
| SHIP_FRM_SD_CLAIM_REQUEST_DATE | DATE | Requesting Document transmission date | ||
| SHIP_FRM_SD_CLAIM_REQUEST_ID | VARCHAR2 | (50) | Requesting Document Identifier | |
| CREDIT_REFERENCE_ID | VARCHAR2 | (30) | Vendor assigned number. | |
| DEBIT_REFERENCE_ID | VARCHAR2 | (30) | Claim Number sent in request | |
| BATCH_LINE_NUMBER | NUMBER | Batch line number | ||
| ORDER_DATE | DATE | Order date | ||
| ORDER_LINE_NUMBER | VARCHAR2 | (30) | Order line number | |
| ORDER_NUMBER | VARCHAR2 | (50) | Order Number | |
| INVOICE_DATE | DATE | Invoice Date | ||
| INVOICE_LINE_NUMBER | VARCHAR2 | (30) | Invoice line number | |
| INVOICE_NUMBER | VARCHAR2 | (50) | Invoice number | |
| COST_CURRENCY_CODE | VARCHAR2 | (15) | Purchase Price Currency | |
| COST_MONETARY_AMOUNT | NUMBER | Purchase Price | ||
| AUTH_COST_CURRENCY_CODE | VARCHAR2 | (15) | Agreement Price Currency | |
| AUTH_COST_MONETARY_AMOUNT | NUMBER | Agreement Price | ||
| RESALE_CURRENCY_CODE | VARCHAR2 | (15) | Resale price currency code | |
| RESALE_MONETARY_AMOUNT | NUMBER | Resale Price | ||
| GBL_UOM | VARCHAR2 | (3) | Unit Of Measure | |
| GBL_CLAIM_DISPOSITION_CODE | VARCHAR2 | (30) | Line Status | |
| VENDOR_PRODUCT_ID | VARCHAR2 | (240) | Vendor product code | |
| DIST_PRODUCT_ID | VARCHAR2 | (240) | Distributo product code | |
| SHIP_DATE | DATE | Shipment date | ||
| SHIPPED_QUANTITY | NUMBER | Quantity Shipped | ||
| VENDOR_AUTH_LINEITEM_LINE_NBR | NUMBER | A unique Authorization number provided by the vendor for each line item | ||
| VENDOR_AUTH_COST_CURRENCY_CODE | VARCHAR2 | (15) | Vendor authorised amount currency | |
| VENDOR_AUTH_COST_MONETARY_AMT | NUMBER | Vendor authorised amount | ||
| THIS_DOC_GENERATION_DATE | DATE | Transmission date | ||
| THIS_DOCUMENT_ID | VARCHAR2 | (50) | Transmission indentifier | |
| TO_CONTACT1_NAME | VARCHAR2 | (360) | Transmission recipient contact name | |
| TO_CONTACT1_EMAIL | VARCHAR2 | (2000) | Transmission recipient contact email | |
| TO_CONTACT1_FAX | VARCHAR2 | (60) | Transmission recipient contact fax | |
| TO_CONTACT1_PHONE | VARCHAR2 | (60) | Transmission recipient contact phone | |
| TO_GBL_PARTNER_ROLE_CLASS_CODE | VARCHAR2 | (30) | Partner classification code | |
| TO_BUSINESS_NAME1 | VARCHAR2 | (360) | Business name | |
| TO_GBL_BUSINESS_ID | VARCHAR2 | (360) | Business identifier. The DUNS number is specified by RosettaNet | |
| TO_GBL_SUPPLY_CHAIN_CODE | VARCHAR2 | (60) | Global Supply Chain Code | |
| TO_PROP_BUSINESS_ID | VARCHAR2 | (60) | Business identifier assigned and administered by a private authority | |
| TO_PROP_DOMAIN_ID1 | VARCHAR2 | (60) | Descriptor used to categorize an organization or business entity in the Proprietary Business Identifier | |
| TO_PROP_ID_AUTHORITY1 | VARCHAR2 | (60) | Identifies an organization or business entity responsible for managing one or more lists of identifiers | |
| TO_GBL_PARTNER_CLASS_CODE | VARCHAR2 | (60) | Code identifying a partner's function in the supply chain | |
| TO_CONTACT2_NAME | VARCHAR2 | (360) | Contact name | |
| TO_CONTACT2_EMAIL | VARCHAR2 | (2000) | Contact email | |
| TO_CONTACT2_FAX | VARCHAR2 | (60) | Contact fax | |
| TO_CONTACT2_PHONE | VARCHAR2 | (60) | Contact phone | |
| TO_GBL_LOCATION_ID | VARCHAR2 | (60) | Location identifier | |
| TO_PROP_DOMAIN_ID2 | VARCHAR2 | (60) | Descriptor to categorize an organization or business entity in the Proprietary Business Identifier | |
| TO_PROP_ID_AUTHORITY2 | VARCHAR2 | (60) | Identifies an organization or business entity responsible for managing one or more lists of identifiers | |
| TO_PROP_LOCATION_ID | VARCHAR2 | (60) | Location identifier assigned and administered by a private authority | |
| TO_ADDRESS_LINE1 | VARCHAR2 | (240) | First line of physical address | |
| TO_ADDRESS_LINE2 | VARCHAR2 | (240) | Second line of physical address | |
| TO_ADDRESS_LINE3 | VARCHAR2 | (240) | Third line of physical address | |
| TO_CITY_NAME | VARCHAR2 | (60) | City name | |
| TO_GBL_COUNTRY_CODE | VARCHAR2 | (2) | Country code | |
| TO_NATIONAL_POSTAL_CODE | VARCHAR2 | (60) | Zip code | |
| TO_POBOX_ID | VARCHAR2 | (60) | Postbox number | |
| TO_REGION_NAME | VARCHAR2 | (60) | Name of a state or province within a country | |
| CREATION_DATE | DATE | Yes | Standard WHO column | |
| LAST_UPDATE_DATE | DATE | Yes | Standard WHO column | |
| LAST_UPDATED_BY | NUMBER | Yes | Standard WHO column | |
| REQUEST_ID | NUMBER | Standard WHO column | ||
| CREATED_BY | NUMBER | (15) | Yes | Standard WHO column |
| CREATED_FROM | VARCHAR2 | (30) | Standard WHO column | |
| LAST_UPDATE_LOGIN | NUMBER | (15) | Standard WHO column | |
| PROGRAM_APPLICATION_ID | NUMBER | Application identifier of last concurrent program to update record | ||
| PROGRAM_UPDATE_DATE | DATE | Last date concurrent program updated record | ||
| PROGRAM_ID | NUMBER | Identifier of last concurrent program to update record | ||
| HEADER_ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield structure definition column | |
| HEADER_ATTRIBUTE1 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| HEADER_ATTRIBUTE2 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| HEADER_ATTRIBUTE3 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| HEADER_ATTRIBUTE4 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| HEADER_ATTRIBUTE5 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| HEADER_ATTRIBUTE6 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| HEADER_ATTRIBUTE7 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| HEADER_ATTRIBUTE8 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| HEADER_ATTRIBUTE9 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| HEADER_ATTRIBUTE10 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| HEADER_ATTRIBUTE11 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| HEADER_ATTRIBUTE12 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| HEADER_ATTRIBUTE13 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| HEADER_ATTRIBUTE14 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| HEADER_ATTRIBUTE15 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| LINE_ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield structure definition column | |
| LINE_ATTRIBUTE1 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| LINE_ATTRIBUTE2 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| LINE_ATTRIBUTE3 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| LINE_ATTRIBUTE4 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| LINE_ATTRIBUTE5 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| LINE_ATTRIBUTE6 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| LINE_ATTRIBUTE7 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| LINE_ATTRIBUTE8 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| LINE_ATTRIBUTE9 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| LINE_ATTRIBUTE10 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| LINE_ATTRIBUTE11 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| LINE_ATTRIBUTE12 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| LINE_ATTRIBUTE13 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| LINE_ATTRIBUTE14 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| LINE_ATTRIBUTE15 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| PROCESSED_FLAG | VARCHAR2 | (1) | Yes | Indicates processing status of interface record |
| BATCH_ID | NUMBER | Reference to Batch | ||
| BATCH_LINE_ID | NUMBER | Reference to Batch Line | ||
| GBL_CLAIM_REJ_CODE1 | VARCHAR2 | (30) | Line Rejection code | |
| GBL_CLAIM_REJ_CODE2 | VARCHAR2 | (30) | Line Rejection code | |
| GBL_CLAIM_REJ_CODE3 | VARCHAR2 | (30) | Line Rejection code | |
| GBL_CLAIM_REJ_CODE4 | VARCHAR2 | (30) | Line Rejection code | |
| GBL_CLAIM_REJ_CODE5 | VARCHAR2 | (30) | Line Rejection code | |
| GBL_CLAIM_REJ_CODE6 | VARCHAR2 | (30) | Line Rejection code | |
| GBL_CLAIM_REJ_CODE7 | VARCHAR2 | (30) | Line Rejection code | |
| GBL_CLAIM_REJ_CODE8 | VARCHAR2 | (30) | Line Rejection code | |
| GBL_CLAIM_REJ_CODE9 | VARCHAR2 | (30) | Line Rejection code | |
| GBL_CLAIM_REJ_CODE10 | VARCHAR2 | (30) | Line Rejection code | |
| VALIDATION_TXT | VARCHAR2 | (2000) | Validation comments | |
| VENDOR_AUTH_QUANTITY | NUMBER | (22) | Quantity Approved by Vendor in batch inbound feed | |
| HEADER_ATTRIBUTE16 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| HEADER_ATTRIBUTE17 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| HEADER_ATTRIBUTE18 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| HEADER_ATTRIBUTE19 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| HEADER_ATTRIBUTE20 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| HEADER_ATTRIBUTE21 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| HEADER_ATTRIBUTE22 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| HEADER_ATTRIBUTE23 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| HEADER_ATTRIBUTE24 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| HEADER_ATTRIBUTE25 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| HEADER_ATTRIBUTE26 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| HEADER_ATTRIBUTE27 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| HEADER_ATTRIBUTE28 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| HEADER_ATTRIBUTE29 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| HEADER_ATTRIBUTE30 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| LINE_ATTRIBUTE16 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| LINE_ATTRIBUTE17 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| LINE_ATTRIBUTE18 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| LINE_ATTRIBUTE19 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| LINE_ATTRIBUTE20 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| LINE_ATTRIBUTE21 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| LINE_ATTRIBUTE22 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| LINE_ATTRIBUTE23 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| LINE_ATTRIBUTE24 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| LINE_ATTRIBUTE25 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| LINE_ATTRIBUTE26 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| LINE_ATTRIBUTE27 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| LINE_ATTRIBUTE28 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| LINE_ATTRIBUTE29 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| LINE_ATTRIBUTE30 | VARCHAR2 | (240) | Descriptive flexfield segment |
Cut, paste (and edit) the following text to query this object:
SELECT BATCH_LINE_INT_ID
, FRM_CONTACT1_NAME
, FRM_CONTACT1_EMAIL
, FRM_CONTACT1_FAX
, FRM_CONTACT1_PHONE
, FRM_GBL_PTNR_ROLE_CLASS_CODE
, FRM_BUSINESS_NAME
, FRM_GBL_BUSINESS_ID
, FRM_GBL_SUPPLY_CHAIN_CODE
, FRM_PROP_BUSINESS_ID
, FRM_PROP_DOMAIN_ID1
, FRM_PROP_ID_AUTHORITY1
, FRM_GBL_PARTNER_CLASS_CODE
, FRM_CONTACT2_NAME
, FRM_CONTACT2_EMAIL
, FRM_CONTACT2_FAX
, FRM_CONTACT2_PHONE
, FRM_GBL_LOCATION_ID
, FRM_PROP_DOMAIN_ID2
, FRM_PROP_ID_AUTHORITY2
, FRM_PROP_LOCATION_ID
, FRM_ADDRESS_LINE1
, FRM_ADDRESS_LINE2
, FRM_ADDRESS_LINE3
, FRM_CITY_NAME
, FRM_GBL_COUNTRY_CODE
, FRM_NATIONAL_POSTAL_CODE
, FRM_POBOX_ID
, FRM_REGION_NAME
, GBL_DOC_FUNCTION_CODE
, SHIP_FRM_SD_AUTHORIZATION_ID
, DIST_BY_BUSINESS_NAME
, DIST_BY_GBL_BUSINESS_ID
, DIST_BY_GBL_SUPPLY_CHAIN_CODE
, DIST_BY_PROP_BUSINESS_ID
, DIST_BY_PROP_DOMAIN_ID1
, DIST_BY_PROP_IDAUTHORITY1
, DIST_BY_GBL_PARTNER_CLASS_CODE
, DIST_BY_CONTACT1_NAME
, DIST_BY_CONTACT1_EMAIL
, DIST_BY_CONTACT1_FAX
, DIST_BY_CONTACT1_PHONE
, DIST_BY_GBL_LOCATION_ID
, DIST_BY_PROP_DOMAIN_ID2
, DIST_BY_PROP_IDAUTHORITY2
, DIST_BY_PROP_LOCATION_ID
, DIST_BY_ADDRESS_LINE1
, DIST_BY_ADDRESS_LINE2
, DIST_BY_ADDRESS_LINE3
, DIST_BY_CITY_NAME
, DIST_BY_GBL_COUNTRY_CODE
, DIST_BY_NATIONAL_POSTAL_CODE
, DIST_BY_POBOX_ID
, DIST_BY_REGION_NAME
, SHIP_TO_BUSINESS_NAME
, SHIP_TO_GBL_BUSINESS_ID
, SHIP_TO_GBL_SUPPLY_CHAIN_CODE
, SHIP_TO_PROP_BUSINESS_ID
, SHIP_TO_PROP_DOMAIN_ID2
, SHIP_TO_PROP_ID_AUTHORITY2
, SHIP_TO_GBL_PARTNER_CLASS_CODE
, SHIP_TO_CONTACT1_NAME
, SHIP_TO_CONTACT1_EMAIL
, SHIP_TO_CONTACT1_FAX
, SHIP_TO_CONTACT1_PHONE
, SHIP_TO_GBL_LOCATION_ID
, SHIP_TO_PROP_DOMAIN_ID1
, SHIP_TO_PROP_ID_AUTHORITY1
, SHIP_TO_PROP_LOCATION_ID
, SHIP_TO_ADDRESS_LINE1
, SHIP_TO_ADDRESS_LINE2
, SHIP_TO_ADDRESS_LINE3
, SHIP_TO_CITY_NAME
, SHIP_TO_GBL_COUNTRY_CODE
, SHIP_TO_NATIONAL_POSTAL_CODE
, SHIP_TO_POBOX_ID
, SHIP_TO_REGION_NAME
, SOLD_TO_BUSINESS_NAME
, SOLD_TO_GBL_BUSINESS_ID
, SOLD_TO_GBL_SUPPLY_CHAIN_CODE
, SOLD_TO_PROP_BUSINESS_ID
, SOLD_TO_PROP_DOMAIN_ID2
, SOLD_TO_PROP_ID_AUTHORITY2
, SOLD_TO_GBL_PARTNER_CLASS_CODE
, SOLD_TO_CONTACT1_NAME
, SOLD_TO_CONTACT1_EMAIL
, SOLD_TO_CONTACT1_FAX
, SOLD_TO_CONTACT1_PHONE
, SOLD_TO_GBL_LOCATION_ID
, SOLD_TO_PROP_DOMAIN_ID1
, SOLD_TO_PROP_ID_AUTHORITY1
, SOLD_TO_PROP_LOCATION_ID
, SOLD_TO_ADDRESS_LINE1
, SOLD_TO_ADDRESS_LINE2
, SOLD_TO_ADDRESS_LINE3
, SOLD_TO_CITY_NAME
, SOLD_TO_GBL_COUNTRY_CODE
, SOLD_TO_NATIONAL_POSTAL_CODE
, SOLD_TO_POBOX_ID
, SOLD_TO_REGION_NAME
, USED_BY_BUSINESS_NAME
, USED_BY_GBL_BUSINESS_ID
, USED_BY_GBL_SUPPLY_CHAIN_CODE
, USED_BY_PROP_BUSINESS_ID
, USED_BY_PROP_DOMAIN_ID1
, USED_BY_PROP_ID_AUTHORITY1
, USED_BY_GBL_PARTNER_CLASS_CODE
, USED_BY_CONTACT1_NAME
, USED_BY_CONTACT1_EMAIL
, USED_BY_CONTACT1_FAX
, USED_BY_CONTACT1_PHONE
, USED_BY_GBL_LOCATION_ID
, USED_BY_PROP_DOMAIN_ID2
, USED_BY_PROP_ID_AUTHORITY2
, USED_BY_PROP_LOCATION_ID
, USED_BY_ADDRESS_LINE1
, USED_BY_ADDRESS_LINE2
, USED_BY_ADDRESS_LINE3
, USED_BY_CITY_NAME
, USED_BY_GBL_COUNTRY_CODE
, USED_BY_NATIONAL_POSTAL_CODE
, USED_BY_POBOX_ID
, USED_BY_REGION_NAME
, SHIP_FRM_SD_CLAIM_REQUEST_DATE
, SHIP_FRM_SD_CLAIM_REQUEST_ID
, CREDIT_REFERENCE_ID
, DEBIT_REFERENCE_ID
, BATCH_LINE_NUMBER
, ORDER_DATE
, ORDER_LINE_NUMBER
, ORDER_NUMBER
, INVOICE_DATE
, INVOICE_LINE_NUMBER
, INVOICE_NUMBER
, COST_CURRENCY_CODE
, COST_MONETARY_AMOUNT
, AUTH_COST_CURRENCY_CODE
, AUTH_COST_MONETARY_AMOUNT
, RESALE_CURRENCY_CODE
, RESALE_MONETARY_AMOUNT
, GBL_UOM
, GBL_CLAIM_DISPOSITION_CODE
, VENDOR_PRODUCT_ID
, DIST_PRODUCT_ID
, SHIP_DATE
, SHIPPED_QUANTITY
, VENDOR_AUTH_LINEITEM_LINE_NBR
, VENDOR_AUTH_COST_CURRENCY_CODE
, VENDOR_AUTH_COST_MONETARY_AMT
, THIS_DOC_GENERATION_DATE
, THIS_DOCUMENT_ID
, TO_CONTACT1_NAME
, TO_CONTACT1_EMAIL
, TO_CONTACT1_FAX
, TO_CONTACT1_PHONE
, TO_GBL_PARTNER_ROLE_CLASS_CODE
, TO_BUSINESS_NAME1
, TO_GBL_BUSINESS_ID
, TO_GBL_SUPPLY_CHAIN_CODE
, TO_PROP_BUSINESS_ID
, TO_PROP_DOMAIN_ID1
, TO_PROP_ID_AUTHORITY1
, TO_GBL_PARTNER_CLASS_CODE
, TO_CONTACT2_NAME
, TO_CONTACT2_EMAIL
, TO_CONTACT2_FAX
, TO_CONTACT2_PHONE
, TO_GBL_LOCATION_ID
, TO_PROP_DOMAIN_ID2
, TO_PROP_ID_AUTHORITY2
, TO_PROP_LOCATION_ID
, TO_ADDRESS_LINE1
, TO_ADDRESS_LINE2
, TO_ADDRESS_LINE3
, TO_CITY_NAME
, TO_GBL_COUNTRY_CODE
, TO_NATIONAL_POSTAL_CODE
, TO_POBOX_ID
, TO_REGION_NAME
, CREATION_DATE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, REQUEST_ID
, CREATED_BY
, CREATED_FROM
, LAST_UPDATE_LOGIN
, PROGRAM_APPLICATION_ID
, PROGRAM_UPDATE_DATE
, PROGRAM_ID
, HEADER_ATTRIBUTE_CATEGORY
, HEADER_ATTRIBUTE1
, HEADER_ATTRIBUTE2
, HEADER_ATTRIBUTE3
, HEADER_ATTRIBUTE4
, HEADER_ATTRIBUTE5
, HEADER_ATTRIBUTE6
, HEADER_ATTRIBUTE7
, HEADER_ATTRIBUTE8
, HEADER_ATTRIBUTE9
, HEADER_ATTRIBUTE10
, HEADER_ATTRIBUTE11
, HEADER_ATTRIBUTE12
, HEADER_ATTRIBUTE13
, HEADER_ATTRIBUTE14
, HEADER_ATTRIBUTE15
, LINE_ATTRIBUTE_CATEGORY
, LINE_ATTRIBUTE1
, LINE_ATTRIBUTE2
, LINE_ATTRIBUTE3
, LINE_ATTRIBUTE4
, LINE_ATTRIBUTE5
, LINE_ATTRIBUTE6
, LINE_ATTRIBUTE7
, LINE_ATTRIBUTE8
, LINE_ATTRIBUTE9
, LINE_ATTRIBUTE10
, LINE_ATTRIBUTE11
, LINE_ATTRIBUTE12
, LINE_ATTRIBUTE13
, LINE_ATTRIBUTE14
, LINE_ATTRIBUTE15
, PROCESSED_FLAG
, BATCH_ID
, BATCH_LINE_ID
, GBL_CLAIM_REJ_CODE1
, GBL_CLAIM_REJ_CODE2
, GBL_CLAIM_REJ_CODE3
, GBL_CLAIM_REJ_CODE4
, GBL_CLAIM_REJ_CODE5
, GBL_CLAIM_REJ_CODE6
, GBL_CLAIM_REJ_CODE7
, GBL_CLAIM_REJ_CODE8
, GBL_CLAIM_REJ_CODE9
, GBL_CLAIM_REJ_CODE10
, VALIDATION_TXT
, VENDOR_AUTH_QUANTITY
, HEADER_ATTRIBUTE16
, HEADER_ATTRIBUTE17
, HEADER_ATTRIBUTE18
, HEADER_ATTRIBUTE19
, HEADER_ATTRIBUTE20
, HEADER_ATTRIBUTE21
, HEADER_ATTRIBUTE22
, HEADER_ATTRIBUTE23
, HEADER_ATTRIBUTE24
, HEADER_ATTRIBUTE25
, HEADER_ATTRIBUTE26
, HEADER_ATTRIBUTE27
, HEADER_ATTRIBUTE28
, HEADER_ATTRIBUTE29
, HEADER_ATTRIBUTE30
, LINE_ATTRIBUTE16
, LINE_ATTRIBUTE17
, LINE_ATTRIBUTE18
, LINE_ATTRIBUTE19
, LINE_ATTRIBUTE20
, LINE_ATTRIBUTE21
, LINE_ATTRIBUTE22
, LINE_ATTRIBUTE23
, LINE_ATTRIBUTE24
, LINE_ATTRIBUTE25
, LINE_ATTRIBUTE26
, LINE_ATTRIBUTE27
, LINE_ATTRIBUTE28
, LINE_ATTRIBUTE29
, LINE_ATTRIBUTE30
FROM OZF.OZF_SD_BATCH_LINES_INT_ALL;
OZF.OZF_SD_BATCH_LINES_INT_ALL does not reference any database object
OZF.OZF_SD_BATCH_LINES_INT_ALL is referenced by following:
OZF
OZF_SD_BATCH_LINES_INT_ALL#
|
|
|
|