DBA Data[Home] [Help] [Dependency Information]

TYPE: APPS.AR_EBI_RA_INT_LINES_ALL_TYPE

Object Details
Object Name: AR_EBI_RA_INT_LINES_ALL_TYPE
Object Type: TYPE
Owner: APPS
Subobject Name:
Status: VALID
Type Details
Type Code: OBJECT
Predefined: NO
Incomplete: NO
Attributes
Name Datatype Length Prcn
INTERFACE_LINE_ID NUMBER
15
INTERFACE_LINE_CONTEXT VARCHAR2 (30)
INTERFACE_LINE_ATTRIBUTE1 VARCHAR2 (30)
INTERFACE_LINE_ATTRIBUTE2 VARCHAR2 (30)
INTERFACE_LINE_ATTRIBUTE3 VARCHAR2 (30)
INTERFACE_LINE_ATTRIBUTE4 VARCHAR2 (30)
INTERFACE_LINE_ATTRIBUTE5 VARCHAR2 (30)
INTERFACE_LINE_ATTRIBUTE6 VARCHAR2 (30)
INTERFACE_LINE_ATTRIBUTE7 VARCHAR2 (30)
INTERFACE_LINE_ATTRIBUTE8 VARCHAR2 (30)
BATCH_SOURCE_NAME VARCHAR2 (50)
SET_OF_BOOKS_ID NUMBER
15
LINE_TYPE VARCHAR2 (20)
DESCRIPTION VARCHAR2 (240)
CURRENCY_CODE VARCHAR2 (15)
AMOUNT NUMBER

CUST_TRX_TYPE_NAME VARCHAR2 (20)
CUST_TRX_TYPE_ID NUMBER
15
TERM_NAME VARCHAR2 (15)
TERM_ID NUMBER
15
ORIG_SYSTEM_BATCH_NAME VARCHAR2 (40)
ORIG_SYSTEM_BILL_CUSTOMER_REF VARCHAR2 (240)
ORIG_SYSTEM_BILL_CUSTOMER_ID NUMBER
15
ORIG_SYSTEM_BILL_ADDRESS_REF VARCHAR2 (240)
ORIG_SYSTEM_BILL_ADDRESS_ID NUMBER
15
ORIG_SYSTEM_BILL_CONTACT_REF VARCHAR2 (240)
ORIG_SYSTEM_BILL_CONTACT_ID NUMBER
15
ORIG_SYSTEM_SHIP_CUSTOMER_REF VARCHAR2 (240)
ORIG_SYSTEM_SHIP_CUSTOMER_ID NUMBER
15
ORIG_SYSTEM_SHIP_ADDRESS_REF VARCHAR2 (240)
ORIG_SYSTEM_SHIP_ADDRESS_ID NUMBER
15
ORIG_SYSTEM_SHIP_CONTACT_REF VARCHAR2 (240)
ORIG_SYSTEM_SHIP_CONTACT_ID NUMBER
15
ORIG_SYSTEM_SOLD_CUSTOMER_REF VARCHAR2 (240)
ORIG_SYSTEM_SOLD_CUSTOMER_ID NUMBER
15
LINK_TO_LINE_ID NUMBER
15
LINK_TO_LINE_CONTEXT VARCHAR2 (30)
LINK_TO_LINE_ATTRIBUTE1 VARCHAR2 (30)
LINK_TO_LINE_ATTRIBUTE2 VARCHAR2 (30)
LINK_TO_LINE_ATTRIBUTE3 VARCHAR2 (30)
LINK_TO_LINE_ATTRIBUTE4 VARCHAR2 (30)
LINK_TO_LINE_ATTRIBUTE5 VARCHAR2 (30)
LINK_TO_LINE_ATTRIBUTE6 VARCHAR2 (30)
LINK_TO_LINE_ATTRIBUTE7 VARCHAR2 (30)
RECEIPT_METHOD_NAME VARCHAR2 (30)
RECEIPT_METHOD_ID NUMBER
15
CONVERSION_TYPE VARCHAR2 (30)
CONVERSION_DATE DATE

CONVERSION_RATE NUMBER

CUSTOMER_TRX_ID NUMBER
15
TRX_DATE DATE

GL_DATE DATE

DOCUMENT_NUMBER NUMBER
15
TRX_NUMBER VARCHAR2 (20)
LINE_NUMBER NUMBER
15
QUANTITY NUMBER

QUANTITY_ORDERED NUMBER

UNIT_SELLING_PRICE NUMBER

UNIT_STANDARD_PRICE NUMBER

PRINTING_OPTION VARCHAR2 (20)
INTERFACE_STATUS VARCHAR2 (1)
REQUEST_ID NUMBER
15
RELATED_BATCH_SOURCE_NAME VARCHAR2 (50)
RELATED_TRX_NUMBER VARCHAR2 (20)
RELATED_CUSTOMER_TRX_ID NUMBER
15
PREVIOUS_CUSTOMER_TRX_ID NUMBER
15
CREDIT_METHOD_FOR_ACCT_RULE VARCHAR2 (30)
CREDIT_METHOD_FOR_INSTALLMENTS VARCHAR2 (30)
REASON_CODE VARCHAR2 (30)
TAX_RATE NUMBER

TAX_CODE VARCHAR2 (50)
TAX_PRECEDENCE NUMBER

EXCEPTION_ID NUMBER
15
EXEMPTION_ID NUMBER
15
SHIP_DATE_ACTUAL DATE

FOB_POINT VARCHAR2 (30)
SHIP_VIA VARCHAR2 (25)
WAYBILL_NUMBER VARCHAR2 (50)
INVOICING_RULE_NAME VARCHAR2 (30)
INVOICING_RULE_ID NUMBER
15
ACCOUNTING_RULE_NAME VARCHAR2 (30)
ACCOUNTING_RULE_ID NUMBER
15
ACCOUNTING_RULE_DURATION NUMBER
15
RULE_START_DATE DATE

PRIMARY_SALESREP_NUMBER VARCHAR2 (30)
PRIMARY_SALESREP_ID NUMBER
15
SALES_ORDER VARCHAR2 (50)
SALES_ORDER_LINE VARCHAR2 (30)
SALES_ORDER_DATE DATE

SALES_ORDER_SOURCE VARCHAR2 (50)
SALES_ORDER_REVISION NUMBER

PURCHASE_ORDER VARCHAR2 (50)
PURCHASE_ORDER_REVISION VARCHAR2 (50)
PURCHASE_ORDER_DATE DATE

AGREEMENT_NAME VARCHAR2 (30)
AGREEMENT_ID NUMBER
15
MEMO_LINE_NAME VARCHAR2 (50)
MEMO_LINE_ID NUMBER
15
INVENTORY_ITEM_ID NUMBER
15
MTL_SYSTEM_ITEMS_SEG1 VARCHAR2 (40)
MTL_SYSTEM_ITEMS_SEG2 VARCHAR2 (40)
MTL_SYSTEM_ITEMS_SEG3 VARCHAR2 (40)
MTL_SYSTEM_ITEMS_SEG4 VARCHAR2 (40)
MTL_SYSTEM_ITEMS_SEG5 VARCHAR2 (40)
MTL_SYSTEM_ITEMS_SEG6 VARCHAR2 (40)
MTL_SYSTEM_ITEMS_SEG7 VARCHAR2 (40)
MTL_SYSTEM_ITEMS_SEG8 VARCHAR2 (40)
MTL_SYSTEM_ITEMS_SEG9 VARCHAR2 (40)
MTL_SYSTEM_ITEMS_SEG10 VARCHAR2 (40)
MTL_SYSTEM_ITEMS_SEG11 VARCHAR2 (40)
MTL_SYSTEM_ITEMS_SEG12 VARCHAR2 (40)
MTL_SYSTEM_ITEMS_SEG13 VARCHAR2 (40)
MTL_SYSTEM_ITEMS_SEG14 VARCHAR2 (40)
MTL_SYSTEM_ITEMS_SEG15 VARCHAR2 (40)
MTL_SYSTEM_ITEMS_SEG16 VARCHAR2 (40)
MTL_SYSTEM_ITEMS_SEG17 VARCHAR2 (40)
MTL_SYSTEM_ITEMS_SEG18 VARCHAR2 (40)
MTL_SYSTEM_ITEMS_SEG19 VARCHAR2 (40)
MTL_SYSTEM_ITEMS_SEG20 VARCHAR2 (40)
REFERENCE_LINE_ID NUMBER
15
REFERENCE_LINE_CONTEXT VARCHAR2 (30)
REFERENCE_LINE_ATTRIBUTE1 VARCHAR2 (30)
REFERENCE_LINE_ATTRIBUTE2 VARCHAR2 (30)
REFERENCE_LINE_ATTRIBUTE3 VARCHAR2 (30)
REFERENCE_LINE_ATTRIBUTE4 VARCHAR2 (30)
REFERENCE_LINE_ATTRIBUTE5 VARCHAR2 (30)
REFERENCE_LINE_ATTRIBUTE6 VARCHAR2 (30)
REFERENCE_LINE_ATTRIBUTE7 VARCHAR2 (30)
TERRITORY_ID NUMBER
15
TERRITORY_SEGMENT1 VARCHAR2 (25)
TERRITORY_SEGMENT2 VARCHAR2 (25)
TERRITORY_SEGMENT3 VARCHAR2 (25)
TERRITORY_SEGMENT4 VARCHAR2 (25)
TERRITORY_SEGMENT5 VARCHAR2 (25)
TERRITORY_SEGMENT6 VARCHAR2 (25)
TERRITORY_SEGMENT7 VARCHAR2 (25)
TERRITORY_SEGMENT8 VARCHAR2 (25)
TERRITORY_SEGMENT9 VARCHAR2 (25)
TERRITORY_SEGMENT10 VARCHAR2 (25)
TERRITORY_SEGMENT11 VARCHAR2 (25)
TERRITORY_SEGMENT12 VARCHAR2 (25)
TERRITORY_SEGMENT13 VARCHAR2 (25)
TERRITORY_SEGMENT14 VARCHAR2 (25)
TERRITORY_SEGMENT15 VARCHAR2 (25)
TERRITORY_SEGMENT16 VARCHAR2 (25)
TERRITORY_SEGMENT17 VARCHAR2 (25)
TERRITORY_SEGMENT18 VARCHAR2 (25)
TERRITORY_SEGMENT19 VARCHAR2 (25)
TERRITORY_SEGMENT20 VARCHAR2 (25)
ATTRIBUTE_CATEGORY VARCHAR2 (30)
ATTRIBUTE1 VARCHAR2 (150)
ATTRIBUTE2 VARCHAR2 (150)
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)
HEADER_ATTRIBUTE_CATEGORY VARCHAR2 (30)
HEADER_ATTRIBUTE1 VARCHAR2 (150)
HEADER_ATTRIBUTE2 VARCHAR2 (150)
HEADER_ATTRIBUTE3 VARCHAR2 (150)
HEADER_ATTRIBUTE4 VARCHAR2 (150)
HEADER_ATTRIBUTE5 VARCHAR2 (150)
HEADER_ATTRIBUTE6 VARCHAR2 (150)
HEADER_ATTRIBUTE7 VARCHAR2 (150)
HEADER_ATTRIBUTE8 VARCHAR2 (150)
HEADER_ATTRIBUTE9 VARCHAR2 (150)
HEADER_ATTRIBUTE10 VARCHAR2 (150)
HEADER_ATTRIBUTE11 VARCHAR2 (150)
HEADER_ATTRIBUTE12 VARCHAR2 (150)
HEADER_ATTRIBUTE13 VARCHAR2 (150)
HEADER_ATTRIBUTE14 VARCHAR2 (150)
HEADER_ATTRIBUTE15 VARCHAR2 (150)
COMMENTS VARCHAR2 (240)
INTERNAL_NOTES VARCHAR2 (240)
INITIAL_CUSTOMER_TRX_ID NUMBER
15
USSGL_TRANSACTION_CODE_CONTEXT VARCHAR2 (30)
USSGL_TRANSACTION_CODE VARCHAR2 (30)
ACCTD_AMOUNT NUMBER

CUSTOMER_BANK_ACCOUNT_ID NUMBER
15
CUSTOMER_BANK_ACCOUNT_NAME VARCHAR2 (80)
UOM_CODE VARCHAR2 (3)
UOM_NAME VARCHAR2 (25)
DOCUMENT_NUMBER_SEQUENCE_ID NUMBER
15
LINK_TO_LINE_ATTRIBUTE10 VARCHAR2 (30)
LINK_TO_LINE_ATTRIBUTE11 VARCHAR2 (30)
LINK_TO_LINE_ATTRIBUTE12 VARCHAR2 (30)
LINK_TO_LINE_ATTRIBUTE13 VARCHAR2 (30)
LINK_TO_LINE_ATTRIBUTE14 VARCHAR2 (30)
LINK_TO_LINE_ATTRIBUTE15 VARCHAR2 (30)
LINK_TO_LINE_ATTRIBUTE8 VARCHAR2 (30)
LINK_TO_LINE_ATTRIBUTE9 VARCHAR2 (30)
REFERENCE_LINE_ATTRIBUTE10 VARCHAR2 (30)
REFERENCE_LINE_ATTRIBUTE11 VARCHAR2 (30)
REFERENCE_LINE_ATTRIBUTE12 VARCHAR2 (30)
REFERENCE_LINE_ATTRIBUTE13 VARCHAR2 (30)
REFERENCE_LINE_ATTRIBUTE14 VARCHAR2 (30)
REFERENCE_LINE_ATTRIBUTE15 VARCHAR2 (30)
REFERENCE_LINE_ATTRIBUTE8 VARCHAR2 (30)
REFERENCE_LINE_ATTRIBUTE9 VARCHAR2 (30)
INTERFACE_LINE_ATTRIBUTE10 VARCHAR2 (30)
INTERFACE_LINE_ATTRIBUTE11 VARCHAR2 (30)
INTERFACE_LINE_ATTRIBUTE12 VARCHAR2 (30)
INTERFACE_LINE_ATTRIBUTE13 VARCHAR2 (30)
INTERFACE_LINE_ATTRIBUTE14 VARCHAR2 (30)
INTERFACE_LINE_ATTRIBUTE15 VARCHAR2 (30)
INTERFACE_LINE_ATTRIBUTE9 VARCHAR2 (30)
VAT_TAX_ID NUMBER
15
REASON_CODE_MEANING VARCHAR2 (80)
LAST_PERIOD_TO_CREDIT NUMBER

PAYING_CUSTOMER_ID NUMBER
15
PAYING_SITE_USE_ID NUMBER
15
TAX_EXEMPT_FLAG VARCHAR2 (1)
TAX_EXEMPT_REASON_CODE VARCHAR2 (30)
TAX_EXEMPT_REASON_CODE_MEANING VARCHAR2 (80)
TAX_EXEMPT_NUMBER VARCHAR2 (80)
SALES_TAX_ID NUMBER
15
CREATED_BY NUMBER
15
CREATION_DATE DATE

LAST_UPDATED_BY NUMBER
15
LAST_UPDATE_DATE DATE

LAST_UPDATE_LOGIN NUMBER
15
LOCATION_SEGMENT_ID NUMBER
15
MOVEMENT_ID NUMBER
15
ORG_ID NUMBER
15
AMOUNT_INCLUDES_TAX_FLAG VARCHAR2 (1)
HEADER_GDF_ATTR_CATEGORY VARCHAR2 (30)
HEADER_GDF_ATTRIBUTE1 VARCHAR2 (150)
HEADER_GDF_ATTRIBUTE2 VARCHAR2 (150)
HEADER_GDF_ATTRIBUTE3 VARCHAR2 (150)
HEADER_GDF_ATTRIBUTE4 VARCHAR2 (150)
HEADER_GDF_ATTRIBUTE5 VARCHAR2 (150)
HEADER_GDF_ATTRIBUTE6 VARCHAR2 (150)
HEADER_GDF_ATTRIBUTE7 VARCHAR2 (150)
HEADER_GDF_ATTRIBUTE8 VARCHAR2 (150)
HEADER_GDF_ATTRIBUTE9 VARCHAR2 (150)
HEADER_GDF_ATTRIBUTE10 VARCHAR2 (150)
HEADER_GDF_ATTRIBUTE11 VARCHAR2 (150)
HEADER_GDF_ATTRIBUTE12 VARCHAR2 (150)
HEADER_GDF_ATTRIBUTE13 VARCHAR2 (150)
HEADER_GDF_ATTRIBUTE14 VARCHAR2 (150)
HEADER_GDF_ATTRIBUTE15 VARCHAR2 (150)
HEADER_GDF_ATTRIBUTE16 VARCHAR2 (150)
HEADER_GDF_ATTRIBUTE17 VARCHAR2 (150)
HEADER_GDF_ATTRIBUTE18 VARCHAR2 (150)
HEADER_GDF_ATTRIBUTE19 VARCHAR2 (150)
HEADER_GDF_ATTRIBUTE20 VARCHAR2 (150)
HEADER_GDF_ATTRIBUTE21 VARCHAR2 (150)
HEADER_GDF_ATTRIBUTE22 VARCHAR2 (150)
HEADER_GDF_ATTRIBUTE23 VARCHAR2 (150)
HEADER_GDF_ATTRIBUTE24 VARCHAR2 (150)
HEADER_GDF_ATTRIBUTE25 VARCHAR2 (150)
HEADER_GDF_ATTRIBUTE26 VARCHAR2 (150)
HEADER_GDF_ATTRIBUTE27 VARCHAR2 (150)
HEADER_GDF_ATTRIBUTE28 VARCHAR2 (150)
HEADER_GDF_ATTRIBUTE29 VARCHAR2 (150)
HEADER_GDF_ATTRIBUTE30 VARCHAR2 (150)
LINE_GDF_ATTR_CATEGORY VARCHAR2 (30)
LINE_GDF_ATTRIBUTE1 VARCHAR2 (150)
LINE_GDF_ATTRIBUTE2 VARCHAR2 (150)
LINE_GDF_ATTRIBUTE3 VARCHAR2 (150)
LINE_GDF_ATTRIBUTE4 VARCHAR2 (150)
LINE_GDF_ATTRIBUTE5 VARCHAR2 (150)
LINE_GDF_ATTRIBUTE6 VARCHAR2 (150)
LINE_GDF_ATTRIBUTE7 VARCHAR2 (150)
LINE_GDF_ATTRIBUTE8 VARCHAR2 (150)
LINE_GDF_ATTRIBUTE9 VARCHAR2 (150)
LINE_GDF_ATTRIBUTE10 VARCHAR2 (150)
LINE_GDF_ATTRIBUTE11 VARCHAR2 (150)
LINE_GDF_ATTRIBUTE12 VARCHAR2 (150)
LINE_GDF_ATTRIBUTE13 VARCHAR2 (150)
LINE_GDF_ATTRIBUTE14 VARCHAR2 (150)
LINE_GDF_ATTRIBUTE15 VARCHAR2 (150)
LINE_GDF_ATTRIBUTE16 VARCHAR2 (150)
LINE_GDF_ATTRIBUTE17 VARCHAR2 (150)
LINE_GDF_ATTRIBUTE18 VARCHAR2 (150)
LINE_GDF_ATTRIBUTE19 VARCHAR2 (150)
LINE_GDF_ATTRIBUTE20 VARCHAR2 (150)
RESET_TRX_DATE_FLAG VARCHAR2 (1)
PAYMENT_SERVER_ORDER_NUM VARCHAR2 (80)
APPROVAL_CODE VARCHAR2 (80)
ADDRESS_VERIFICATION_CODE VARCHAR2 (80)
WAREHOUSE_ID NUMBER
15
TRANSLATED_DESCRIPTION VARCHAR2 (1000)
CONS_BILLING_NUMBER VARCHAR2 (30)
PROMISED_COMMITMENT_AMOUNT NUMBER

PAYMENT_SET_ID NUMBER
15
ORIGINAL_GL_DATE DATE

CONTRACT_LINE_ID NUMBER

CONTRACT_ID NUMBER

SOURCE_DATA_KEY1 VARCHAR2 (150)
SOURCE_DATA_KEY2 VARCHAR2 (150)
SOURCE_DATA_KEY3 VARCHAR2 (150)
SOURCE_DATA_KEY4 VARCHAR2 (150)
SOURCE_DATA_KEY5 VARCHAR2 (150)
INVOICED_LINE_ACCTG_LEVEL VARCHAR2 (15)
OVERRIDE_AUTO_ACCOUNTING_FLAG VARCHAR2 (1)
SOURCE_APPLICATION_ID NUMBER
15
SOURCE_EVENT_CLASS_CODE VARCHAR2 (30)
SOURCE_ENTITY_CODE VARCHAR2 (30)
SOURCE_TRX_ID NUMBER
15
SOURCE_TRX_LINE_ID NUMBER
15
SOURCE_TRX_LINE_TYPE VARCHAR2 (30)
SOURCE_TRX_DETAIL_TAX_LINE_ID NUMBER
15
HISTORICAL_FLAG VARCHAR2 (1)
TAX_REGIME_CODE VARCHAR2 (30)
TAX VARCHAR2 (30)
TAX_STATUS_CODE VARCHAR2 (30)
TAX_RATE_CODE VARCHAR2 (30)
TAX_JURISDICTION_CODE VARCHAR2 (30)
TAXABLE_AMOUNT NUMBER

TAXABLE_FLAG VARCHAR2 (1)
LEGAL_ENTITY_ID NUMBER
15
PARENT_LINE_ID NUMBER
15
DEFERRAL_EXCLUSION_FLAG VARCHAR2 (1)
PAYMENT_TRXN_EXTENSION_ID NUMBER
15
RULE_END_DATE DATE

PAYMENT_ATTRIBUTES VARCHAR2 (1000)
APPLICATION_ID NUMBER
15
BILLING_DATE DATE

Dependencies

[top of page]

APPS.AR_EBI_RA_INT_LINES_ALL_TYPE references the following:

SchemaSYS
PL/SQL PackageSTANDARD - show dependent code
APPS.AR_EBI_RA_INT_LINES_ALL_TYPE is referenced by following:

SchemaAPPS
TYPEAR_EBI_RA_INT_LINES_ALL_LIST