VIEW: AR.RA_INTERFACE_LINES_ALL#

Source

View Text - Preformatted

select INTERFACE_LINE_ID INTERFACE_LINE_ID, INTERFACE_LINE_CONTEXT INTERFACE_LINE_CONTEXT, INTERFACE_LINE_ATTRIBUTE1 INTERFACE_LINE_ATTRIBUTE1, INTERFACE_LINE_ATTRIBUTE2 INTERFACE_LINE_ATTRIBUTE2, INTERFACE_LINE_ATTRIBUTE3 INTERFACE_LINE_ATTRIBUTE3, INTERFACE_LINE_ATTRIBUTE4 INTERFACE_LINE_ATTRIBUTE4, INTERFACE_LINE_ATTRIBUTE5 INTERFACE_LINE_ATTRIBUTE5, INTERFACE_LINE_ATTRIBUTE6 INTERFACE_LINE_ATTRIBUTE6, INTERFACE_LINE_ATTRIBUTE7 INTERFACE_LINE_ATTRIBUTE7, INTERFACE_LINE_ATTRIBUTE8 INTERFACE_LINE_ATTRIBUTE8, BATCH_SOURCE_NAME BATCH_SOURCE_NAME, SET_OF_BOOKS_ID SET_OF_BOOKS_ID, LINE_TYPE LINE_TYPE, DESCRIPTION DESCRIPTION, CURRENCY_CODE CURRENCY_CODE, AMOUNT AMOUNT, CUST_TRX_TYPE_NAME CUST_TRX_TYPE_NAME, CUST_TRX_TYPE_ID CUST_TRX_TYPE_ID, TERM_NAME TERM_NAME, TERM_ID TERM_ID, ORIG_SYSTEM_BATCH_NAME ORIG_SYSTEM_BATCH_NAME, ORIG_SYSTEM_BILL_CUSTOMER_REF ORIG_SYSTEM_BILL_CUSTOMER_REF, ORIG_SYSTEM_BILL_CUSTOMER_ID ORIG_SYSTEM_BILL_CUSTOMER_ID, ORIG_SYSTEM_BILL_ADDRESS_REF ORIG_SYSTEM_BILL_ADDRESS_REF, ORIG_SYSTEM_BILL_ADDRESS_ID ORIG_SYSTEM_BILL_ADDRESS_ID, ORIG_SYSTEM_BILL_CONTACT_REF ORIG_SYSTEM_BILL_CONTACT_REF, ORIG_SYSTEM_BILL_CONTACT_ID ORIG_SYSTEM_BILL_CONTACT_ID, ORIG_SYSTEM_SHIP_CUSTOMER_REF ORIG_SYSTEM_SHIP_CUSTOMER_REF, ORIG_SYSTEM_SHIP_CUSTOMER_ID ORIG_SYSTEM_SHIP_CUSTOMER_ID, ORIG_SYSTEM_SHIP_ADDRESS_REF ORIG_SYSTEM_SHIP_ADDRESS_REF, ORIG_SYSTEM_SHIP_ADDRESS_ID ORIG_SYSTEM_SHIP_ADDRESS_ID, ORIG_SYSTEM_SHIP_CONTACT_REF ORIG_SYSTEM_SHIP_CONTACT_REF, ORIG_SYSTEM_SHIP_CONTACT_ID ORIG_SYSTEM_SHIP_CONTACT_ID, ORIG_SYSTEM_SOLD_CUSTOMER_REF ORIG_SYSTEM_SOLD_CUSTOMER_REF, ORIG_SYSTEM_SOLD_CUSTOMER_ID ORIG_SYSTEM_SOLD_CUSTOMER_ID, LINK_TO_LINE_ID LINK_TO_LINE_ID, LINK_TO_LINE_CONTEXT LINK_TO_LINE_CONTEXT, LINK_TO_LINE_ATTRIBUTE1 LINK_TO_LINE_ATTRIBUTE1, LINK_TO_LINE_ATTRIBUTE2 LINK_TO_LINE_ATTRIBUTE2, LINK_TO_LINE_ATTRIBUTE3 LINK_TO_LINE_ATTRIBUTE3, LINK_TO_LINE_ATTRIBUTE4 LINK_TO_LINE_ATTRIBUTE4, LINK_TO_LINE_ATTRIBUTE5 LINK_TO_LINE_ATTRIBUTE5, LINK_TO_LINE_ATTRIBUTE6 LINK_TO_LINE_ATTRIBUTE6, LINK_TO_LINE_ATTRIBUTE7 LINK_TO_LINE_ATTRIBUTE7, RECEIPT_METHOD_NAME RECEIPT_METHOD_NAME, RECEIPT_METHOD_ID RECEIPT_METHOD_ID, CONVERSION_TYPE CONVERSION_TYPE, CONVERSION_DATE CONVERSION_DATE, CONVERSION_RATE CONVERSION_RATE, CUSTOMER_TRX_ID CUSTOMER_TRX_ID, TRX_DATE TRX_DATE, GL_DATE GL_DATE, DOCUMENT_NUMBER DOCUMENT_NUMBER, TRX_NUMBER TRX_NUMBER, LINE_NUMBER LINE_NUMBER, QUANTITY QUANTITY, QUANTITY_ORDERED QUANTITY_ORDERED, UNIT_SELLING_PRICE UNIT_SELLING_PRICE, UNIT_STANDARD_PRICE UNIT_STANDARD_PRICE, PRINTING_OPTION PRINTING_OPTION, INTERFACE_STATUS INTERFACE_STATUS, REQUEST_ID REQUEST_ID, RELATED_BATCH_SOURCE_NAME RELATED_BATCH_SOURCE_NAME, RELATED_TRX_NUMBER RELATED_TRX_NUMBER, RELATED_CUSTOMER_TRX_ID RELATED_CUSTOMER_TRX_ID, PREVIOUS_CUSTOMER_TRX_ID PREVIOUS_CUSTOMER_TRX_ID, CREDIT_METHOD_FOR_ACCT_RULE CREDIT_METHOD_FOR_ACCT_RULE, CREDIT_METHOD_FOR_INSTALLMENTS CREDIT_METHOD_FOR_INSTALLMENTS, REASON_CODE REASON_CODE, TAX_RATE TAX_RATE, TAX_CODE TAX_CODE, TAX_PRECEDENCE TAX_PRECEDENCE, EXCEPTION_ID EXCEPTION_ID, EXEMPTION_ID EXEMPTION_ID, SHIP_DATE_ACTUAL SHIP_DATE_ACTUAL, FOB_POINT FOB_POINT, SHIP_VIA SHIP_VIA, WAYBILL_NUMBER WAYBILL_NUMBER, INVOICING_RULE_NAME INVOICING_RULE_NAME, INVOICING_RULE_ID INVOICING_RULE_ID, ACCOUNTING_RULE_NAME ACCOUNTING_RULE_NAME, ACCOUNTING_RULE_ID ACCOUNTING_RULE_ID, ACCOUNTING_RULE_DURATION ACCOUNTING_RULE_DURATION, RULE_START_DATE RULE_START_DATE, PRIMARY_SALESREP_NUMBER PRIMARY_SALESREP_NUMBER, PRIMARY_SALESREP_ID PRIMARY_SALESREP_ID, SALES_ORDER SALES_ORDER, SALES_ORDER_LINE SALES_ORDER_LINE, SALES_ORDER_DATE SALES_ORDER_DATE, SALES_ORDER_SOURCE SALES_ORDER_SOURCE, SALES_ORDER_REVISION SALES_ORDER_REVISION, PURCHASE_ORDER PURCHASE_ORDER, PURCHASE_ORDER_REVISION PURCHASE_ORDER_REVISION, PURCHASE_ORDER_DATE PURCHASE_ORDER_DATE, AGREEMENT_NAME AGREEMENT_NAME, AGREEMENT_ID AGREEMENT_ID, MEMO_LINE_NAME MEMO_LINE_NAME, MEMO_LINE_ID MEMO_LINE_ID, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, MTL_SYSTEM_ITEMS_SEG1 MTL_SYSTEM_ITEMS_SEG1, MTL_SYSTEM_ITEMS_SEG2 MTL_SYSTEM_ITEMS_SEG2, MTL_SYSTEM_ITEMS_SEG3 MTL_SYSTEM_ITEMS_SEG3, MTL_SYSTEM_ITEMS_SEG4 MTL_SYSTEM_ITEMS_SEG4, MTL_SYSTEM_ITEMS_SEG5 MTL_SYSTEM_ITEMS_SEG5, MTL_SYSTEM_ITEMS_SEG6 MTL_SYSTEM_ITEMS_SEG6, MTL_SYSTEM_ITEMS_SEG7 MTL_SYSTEM_ITEMS_SEG7, MTL_SYSTEM_ITEMS_SEG8 MTL_SYSTEM_ITEMS_SEG8, MTL_SYSTEM_ITEMS_SEG9 MTL_SYSTEM_ITEMS_SEG9, MTL_SYSTEM_ITEMS_SEG10 MTL_SYSTEM_ITEMS_SEG10, MTL_SYSTEM_ITEMS_SEG11 MTL_SYSTEM_ITEMS_SEG11, MTL_SYSTEM_ITEMS_SEG12 MTL_SYSTEM_ITEMS_SEG12, MTL_SYSTEM_ITEMS_SEG13 MTL_SYSTEM_ITEMS_SEG13, MTL_SYSTEM_ITEMS_SEG14 MTL_SYSTEM_ITEMS_SEG14, MTL_SYSTEM_ITEMS_SEG15 MTL_SYSTEM_ITEMS_SEG15, MTL_SYSTEM_ITEMS_SEG16 MTL_SYSTEM_ITEMS_SEG16, MTL_SYSTEM_ITEMS_SEG17 MTL_SYSTEM_ITEMS_SEG17, MTL_SYSTEM_ITEMS_SEG18 MTL_SYSTEM_ITEMS_SEG18, MTL_SYSTEM_ITEMS_SEG19 MTL_SYSTEM_ITEMS_SEG19, MTL_SYSTEM_ITEMS_SEG20 MTL_SYSTEM_ITEMS_SEG20, REFERENCE_LINE_ID REFERENCE_LINE_ID, REFERENCE_LINE_CONTEXT REFERENCE_LINE_CONTEXT, REFERENCE_LINE_ATTRIBUTE1 REFERENCE_LINE_ATTRIBUTE1, REFERENCE_LINE_ATTRIBUTE2 REFERENCE_LINE_ATTRIBUTE2, REFERENCE_LINE_ATTRIBUTE3 REFERENCE_LINE_ATTRIBUTE3, REFERENCE_LINE_ATTRIBUTE4 REFERENCE_LINE_ATTRIBUTE4, REFERENCE_LINE_ATTRIBUTE5 REFERENCE_LINE_ATTRIBUTE5, REFERENCE_LINE_ATTRIBUTE6 REFERENCE_LINE_ATTRIBUTE6, REFERENCE_LINE_ATTRIBUTE7 REFERENCE_LINE_ATTRIBUTE7, TERRITORY_ID TERRITORY_ID, TERRITORY_SEGMENT1 TERRITORY_SEGMENT1, TERRITORY_SEGMENT2 TERRITORY_SEGMENT2, TERRITORY_SEGMENT3 TERRITORY_SEGMENT3, TERRITORY_SEGMENT4 TERRITORY_SEGMENT4, TERRITORY_SEGMENT5 TERRITORY_SEGMENT5, TERRITORY_SEGMENT6 TERRITORY_SEGMENT6, TERRITORY_SEGMENT7 TERRITORY_SEGMENT7, TERRITORY_SEGMENT8 TERRITORY_SEGMENT8, TERRITORY_SEGMENT9 TERRITORY_SEGMENT9, TERRITORY_SEGMENT10 TERRITORY_SEGMENT10, TERRITORY_SEGMENT11 TERRITORY_SEGMENT11, TERRITORY_SEGMENT12 TERRITORY_SEGMENT12, TERRITORY_SEGMENT13 TERRITORY_SEGMENT13, TERRITORY_SEGMENT14 TERRITORY_SEGMENT14, TERRITORY_SEGMENT15 TERRITORY_SEGMENT15, TERRITORY_SEGMENT16 TERRITORY_SEGMENT16, TERRITORY_SEGMENT17 TERRITORY_SEGMENT17, TERRITORY_SEGMENT18 TERRITORY_SEGMENT18, TERRITORY_SEGMENT19 TERRITORY_SEGMENT19, TERRITORY_SEGMENT20 TERRITORY_SEGMENT20, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, HEADER_ATTRIBUTE_CATEGORY HEADER_ATTRIBUTE_CATEGORY, HEADER_ATTRIBUTE1 HEADER_ATTRIBUTE1, HEADER_ATTRIBUTE2 HEADER_ATTRIBUTE2, HEADER_ATTRIBUTE3 HEADER_ATTRIBUTE3, HEADER_ATTRIBUTE4 HEADER_ATTRIBUTE4, HEADER_ATTRIBUTE5 HEADER_ATTRIBUTE5, HEADER_ATTRIBUTE6 HEADER_ATTRIBUTE6, HEADER_ATTRIBUTE7 HEADER_ATTRIBUTE7, HEADER_ATTRIBUTE8 HEADER_ATTRIBUTE8, HEADER_ATTRIBUTE9 HEADER_ATTRIBUTE9, HEADER_ATTRIBUTE10 HEADER_ATTRIBUTE10, HEADER_ATTRIBUTE11 HEADER_ATTRIBUTE11, HEADER_ATTRIBUTE12 HEADER_ATTRIBUTE12, HEADER_ATTRIBUTE13 HEADER_ATTRIBUTE13, HEADER_ATTRIBUTE14 HEADER_ATTRIBUTE14, HEADER_ATTRIBUTE15 HEADER_ATTRIBUTE15, COMMENTS COMMENTS, INTERNAL_NOTES INTERNAL_NOTES, INITIAL_CUSTOMER_TRX_ID INITIAL_CUSTOMER_TRX_ID, USSGL_TRANSACTION_CODE_CONTEXT USSGL_TRANSACTION_CODE_CONTEXT, USSGL_TRANSACTION_CODE USSGL_TRANSACTION_CODE, ACCTD_AMOUNT ACCTD_AMOUNT, CUSTOMER_BANK_ACCOUNT_ID CUSTOMER_BANK_ACCOUNT_ID, CUSTOMER_BANK_ACCOUNT_NAME CUSTOMER_BANK_ACCOUNT_NAME, UOM_CODE UOM_CODE, UOM_NAME UOM_NAME, DOCUMENT_NUMBER_SEQUENCE_ID DOCUMENT_NUMBER_SEQUENCE_ID, LINK_TO_LINE_ATTRIBUTE10 LINK_TO_LINE_ATTRIBUTE10, LINK_TO_LINE_ATTRIBUTE11 LINK_TO_LINE_ATTRIBUTE11, LINK_TO_LINE_ATTRIBUTE12 LINK_TO_LINE_ATTRIBUTE12, LINK_TO_LINE_ATTRIBUTE13 LINK_TO_LINE_ATTRIBUTE13, LINK_TO_LINE_ATTRIBUTE14 LINK_TO_LINE_ATTRIBUTE14, LINK_TO_LINE_ATTRIBUTE15 LINK_TO_LINE_ATTRIBUTE15, LINK_TO_LINE_ATTRIBUTE8 LINK_TO_LINE_ATTRIBUTE8, LINK_TO_LINE_ATTRIBUTE9 LINK_TO_LINE_ATTRIBUTE9, REFERENCE_LINE_ATTRIBUTE10 REFERENCE_LINE_ATTRIBUTE10, REFERENCE_LINE_ATTRIBUTE11 REFERENCE_LINE_ATTRIBUTE11, REFERENCE_LINE_ATTRIBUTE12 REFERENCE_LINE_ATTRIBUTE12, REFERENCE_LINE_ATTRIBUTE13 REFERENCE_LINE_ATTRIBUTE13, REFERENCE_LINE_ATTRIBUTE14 REFERENCE_LINE_ATTRIBUTE14, REFERENCE_LINE_ATTRIBUTE15 REFERENCE_LINE_ATTRIBUTE15, REFERENCE_LINE_ATTRIBUTE8 REFERENCE_LINE_ATTRIBUTE8, REFERENCE_LINE_ATTRIBUTE9 REFERENCE_LINE_ATTRIBUTE9, INTERFACE_LINE_ATTRIBUTE10 INTERFACE_LINE_ATTRIBUTE10, INTERFACE_LINE_ATTRIBUTE11 INTERFACE_LINE_ATTRIBUTE11, INTERFACE_LINE_ATTRIBUTE12 INTERFACE_LINE_ATTRIBUTE12, INTERFACE_LINE_ATTRIBUTE13 INTERFACE_LINE_ATTRIBUTE13, INTERFACE_LINE_ATTRIBUTE14 INTERFACE_LINE_ATTRIBUTE14, INTERFACE_LINE_ATTRIBUTE15 INTERFACE_LINE_ATTRIBUTE15, INTERFACE_LINE_ATTRIBUTE9 INTERFACE_LINE_ATTRIBUTE9, VAT_TAX_ID VAT_TAX_ID, REASON_CODE_MEANING REASON_CODE_MEANING, LAST_PERIOD_TO_CREDIT LAST_PERIOD_TO_CREDIT, PAYING_CUSTOMER_ID PAYING_CUSTOMER_ID, PAYING_SITE_USE_ID PAYING_SITE_USE_ID, TAX_EXEMPT_FLAG TAX_EXEMPT_FLAG, TAX_EXEMPT_REASON_CODE TAX_EXEMPT_REASON_CODE, TAX_EXEMPT_REASON_CODE_MEANING TAX_EXEMPT_REASON_CODE_MEANING, TAX_EXEMPT_NUMBER TAX_EXEMPT_NUMBER, SALES_TAX_ID SALES_TAX_ID, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, LOCATION_SEGMENT_ID LOCATION_SEGMENT_ID, MOVEMENT_ID MOVEMENT_ID, ORG_ID ORG_ID, AMOUNT_INCLUDES_TAX_FLAG AMOUNT_INCLUDES_TAX_FLAG, HEADER_GDF_ATTR_CATEGORY HEADER_GDF_ATTR_CATEGORY, HEADER_GDF_ATTRIBUTE1 HEADER_GDF_ATTRIBUTE1, HEADER_GDF_ATTRIBUTE2 HEADER_GDF_ATTRIBUTE2, HEADER_GDF_ATTRIBUTE3 HEADER_GDF_ATTRIBUTE3, HEADER_GDF_ATTRIBUTE4 HEADER_GDF_ATTRIBUTE4, HEADER_GDF_ATTRIBUTE5 HEADER_GDF_ATTRIBUTE5, HEADER_GDF_ATTRIBUTE6 HEADER_GDF_ATTRIBUTE6, HEADER_GDF_ATTRIBUTE7 HEADER_GDF_ATTRIBUTE7, HEADER_GDF_ATTRIBUTE8 HEADER_GDF_ATTRIBUTE8, HEADER_GDF_ATTRIBUTE9 HEADER_GDF_ATTRIBUTE9, HEADER_GDF_ATTRIBUTE10 HEADER_GDF_ATTRIBUTE10, HEADER_GDF_ATTRIBUTE11 HEADER_GDF_ATTRIBUTE11, HEADER_GDF_ATTRIBUTE12 HEADER_GDF_ATTRIBUTE12, HEADER_GDF_ATTRIBUTE13 HEADER_GDF_ATTRIBUTE13, HEADER_GDF_ATTRIBUTE14 HEADER_GDF_ATTRIBUTE14, HEADER_GDF_ATTRIBUTE15 HEADER_GDF_ATTRIBUTE15, HEADER_GDF_ATTRIBUTE16 HEADER_GDF_ATTRIBUTE16, HEADER_GDF_ATTRIBUTE17 HEADER_GDF_ATTRIBUTE17, HEADER_GDF_ATTRIBUTE18 HEADER_GDF_ATTRIBUTE18, HEADER_GDF_ATTRIBUTE19 HEADER_GDF_ATTRIBUTE19, HEADER_GDF_ATTRIBUTE20 HEADER_GDF_ATTRIBUTE20, HEADER_GDF_ATTRIBUTE21 HEADER_GDF_ATTRIBUTE21, HEADER_GDF_ATTRIBUTE22 HEADER_GDF_ATTRIBUTE22, HEADER_GDF_ATTRIBUTE23 HEADER_GDF_ATTRIBUTE23, HEADER_GDF_ATTRIBUTE24 HEADER_GDF_ATTRIBUTE24, HEADER_GDF_ATTRIBUTE25 HEADER_GDF_ATTRIBUTE25, HEADER_GDF_ATTRIBUTE26 HEADER_GDF_ATTRIBUTE26, HEADER_GDF_ATTRIBUTE27 HEADER_GDF_ATTRIBUTE27, HEADER_GDF_ATTRIBUTE28 HEADER_GDF_ATTRIBUTE28, HEADER_GDF_ATTRIBUTE29 HEADER_GDF_ATTRIBUTE29, HEADER_GDF_ATTRIBUTE30 HEADER_GDF_ATTRIBUTE30, LINE_GDF_ATTR_CATEGORY LINE_GDF_ATTR_CATEGORY, LINE_GDF_ATTRIBUTE1 LINE_GDF_ATTRIBUTE1, LINE_GDF_ATTRIBUTE2 LINE_GDF_ATTRIBUTE2, LINE_GDF_ATTRIBUTE3 LINE_GDF_ATTRIBUTE3, LINE_GDF_ATTRIBUTE4 LINE_GDF_ATTRIBUTE4, LINE_GDF_ATTRIBUTE5 LINE_GDF_ATTRIBUTE5, LINE_GDF_ATTRIBUTE6 LINE_GDF_ATTRIBUTE6, LINE_GDF_ATTRIBUTE7 LINE_GDF_ATTRIBUTE7, LINE_GDF_ATTRIBUTE8 LINE_GDF_ATTRIBUTE8, LINE_GDF_ATTRIBUTE9 LINE_GDF_ATTRIBUTE9, LINE_GDF_ATTRIBUTE10 LINE_GDF_ATTRIBUTE10, LINE_GDF_ATTRIBUTE11 LINE_GDF_ATTRIBUTE11, LINE_GDF_ATTRIBUTE12 LINE_GDF_ATTRIBUTE12, LINE_GDF_ATTRIBUTE13 LINE_GDF_ATTRIBUTE13, LINE_GDF_ATTRIBUTE14 LINE_GDF_ATTRIBUTE14, LINE_GDF_ATTRIBUTE15 LINE_GDF_ATTRIBUTE15, LINE_GDF_ATTRIBUTE16 LINE_GDF_ATTRIBUTE16, LINE_GDF_ATTRIBUTE17 LINE_GDF_ATTRIBUTE17, LINE_GDF_ATTRIBUTE18 LINE_GDF_ATTRIBUTE18, LINE_GDF_ATTRIBUTE19 LINE_GDF_ATTRIBUTE19, LINE_GDF_ATTRIBUTE20 LINE_GDF_ATTRIBUTE20, RESET_TRX_DATE_FLAG RESET_TRX_DATE_FLAG, PAYMENT_SERVER_ORDER_NUM PAYMENT_SERVER_ORDER_NUM, APPROVAL_CODE APPROVAL_CODE, ADDRESS_VERIFICATION_CODE ADDRESS_VERIFICATION_CODE, WAREHOUSE_ID WAREHOUSE_ID, TRANSLATED_DESCRIPTION TRANSLATED_DESCRIPTION, CONS_BILLING_NUMBER CONS_BILLING_NUMBER, PROMISED_COMMITMENT_AMOUNT PROMISED_COMMITMENT_AMOUNT, PAYMENT_SET_ID PAYMENT_SET_ID, ORIGINAL_GL_DATE ORIGINAL_GL_DATE, CONTRACT_LINE_ID CONTRACT_LINE_ID, CONTRACT_ID CONTRACT_ID, SOURCE_DATA_KEY1 SOURCE_DATA_KEY1, SOURCE_DATA_KEY2 SOURCE_DATA_KEY2, SOURCE_DATA_KEY3 SOURCE_DATA_KEY3, SOURCE_DATA_KEY4 SOURCE_DATA_KEY4, SOURCE_DATA_KEY5 SOURCE_DATA_KEY5, INVOICED_LINE_ACCTG_LEVEL INVOICED_LINE_ACCTG_LEVEL, OVERRIDE_AUTO_ACCOUNTING_FLAG OVERRIDE_AUTO_ACCOUNTING_FLAG, SOURCE_APPLICATION_ID SOURCE_APPLICATION_ID, SOURCE_EVENT_CLASS_CODE SOURCE_EVENT_CLASS_CODE, SOURCE_ENTITY_CODE SOURCE_ENTITY_CODE, SOURCE_TRX_ID SOURCE_TRX_ID, SOURCE_TRX_LINE_ID SOURCE_TRX_LINE_ID, SOURCE_TRX_LINE_TYPE SOURCE_TRX_LINE_TYPE, SOURCE_TRX_DETAIL_TAX_LINE_ID SOURCE_TRX_DETAIL_TAX_LINE_ID, HISTORICAL_FLAG HISTORICAL_FLAG, TAX_REGIME_CODE TAX_REGIME_CODE, TAX TAX, TAX_STATUS_CODE TAX_STATUS_CODE, TAX_RATE_CODE TAX_RATE_CODE, TAX_JURISDICTION_CODE TAX_JURISDICTION_CODE, TAXABLE_AMOUNT TAXABLE_AMOUNT, TAXABLE_FLAG TAXABLE_FLAG, LEGAL_ENTITY_ID LEGAL_ENTITY_ID, PARENT_LINE_ID PARENT_LINE_ID, DEFERRAL_EXCLUSION_FLAG DEFERRAL_EXCLUSION_FLAG, PAYMENT_TRXN_EXTENSION_ID PAYMENT_TRXN_EXTENSION_ID, RULE_END_DATE RULE_END_DATE, PAYMENT_ATTRIBUTES PAYMENT_ATTRIBUTES, APPLICATION_ID APPLICATION_ID, BILLING_DATE BILLING_DATE, TRX_BUSINESS_CATEGORY TRX_BUSINESS_CATEGORY, PRODUCT_FISC_CLASSIFICATION PRODUCT_FISC_CLASSIFICATION, PRODUCT_CATEGORY PRODUCT_CATEGORY, PRODUCT_TYPE PRODUCT_TYPE, LINE_INTENDED_USE LINE_INTENDED_USE, ASSESSABLE_VALUE ASSESSABLE_VALUE, DOCUMENT_SUB_TYPE DOCUMENT_SUB_TYPE, DEFAULT_TAXATION_COUNTRY DEFAULT_TAXATION_COUNTRY, USER_DEFINED_FISC_CLASS USER_DEFINED_FISC_CLASS, TAXED_UPSTREAM_FLAG TAXED_UPSTREAM_FLAG, TAX_INVOICE_DATE TAX_INVOICE_DATE, TAX_INVOICE_NUMBER TAX_INVOICE_NUMBER, PAYMENT_TYPE_CODE PAYMENT_TYPE_CODE, MANDATE_LAST_TRX_FLAG MANDATE_LAST_TRX_FLAG from "AR"."RA_INTERFACE_LINES_ALL"

View Text - HTML Formatted

SELECT INTERFACE_LINE_ID INTERFACE_LINE_ID
, INTERFACE_LINE_CONTEXT INTERFACE_LINE_CONTEXT
, INTERFACE_LINE_ATTRIBUTE1 INTERFACE_LINE_ATTRIBUTE1
, INTERFACE_LINE_ATTRIBUTE2 INTERFACE_LINE_ATTRIBUTE2
, INTERFACE_LINE_ATTRIBUTE3 INTERFACE_LINE_ATTRIBUTE3
, INTERFACE_LINE_ATTRIBUTE4 INTERFACE_LINE_ATTRIBUTE4
, INTERFACE_LINE_ATTRIBUTE5 INTERFACE_LINE_ATTRIBUTE5
, INTERFACE_LINE_ATTRIBUTE6 INTERFACE_LINE_ATTRIBUTE6
, INTERFACE_LINE_ATTRIBUTE7 INTERFACE_LINE_ATTRIBUTE7
, INTERFACE_LINE_ATTRIBUTE8 INTERFACE_LINE_ATTRIBUTE8
, BATCH_SOURCE_NAME BATCH_SOURCE_NAME
, SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, LINE_TYPE LINE_TYPE
, DESCRIPTION DESCRIPTION
, CURRENCY_CODE CURRENCY_CODE
, AMOUNT AMOUNT
, CUST_TRX_TYPE_NAME CUST_TRX_TYPE_NAME
, CUST_TRX_TYPE_ID CUST_TRX_TYPE_ID
, TERM_NAME TERM_NAME
, TERM_ID TERM_ID
, ORIG_SYSTEM_BATCH_NAME ORIG_SYSTEM_BATCH_NAME
, ORIG_SYSTEM_BILL_CUSTOMER_REF ORIG_SYSTEM_BILL_CUSTOMER_REF
, ORIG_SYSTEM_BILL_CUSTOMER_ID ORIG_SYSTEM_BILL_CUSTOMER_ID
, ORIG_SYSTEM_BILL_ADDRESS_REF ORIG_SYSTEM_BILL_ADDRESS_REF
, ORIG_SYSTEM_BILL_ADDRESS_ID ORIG_SYSTEM_BILL_ADDRESS_ID
, ORIG_SYSTEM_BILL_CONTACT_REF ORIG_SYSTEM_BILL_CONTACT_REF
, ORIG_SYSTEM_BILL_CONTACT_ID ORIG_SYSTEM_BILL_CONTACT_ID
, ORIG_SYSTEM_SHIP_CUSTOMER_REF ORIG_SYSTEM_SHIP_CUSTOMER_REF
, ORIG_SYSTEM_SHIP_CUSTOMER_ID ORIG_SYSTEM_SHIP_CUSTOMER_ID
, ORIG_SYSTEM_SHIP_ADDRESS_REF ORIG_SYSTEM_SHIP_ADDRESS_REF
, ORIG_SYSTEM_SHIP_ADDRESS_ID ORIG_SYSTEM_SHIP_ADDRESS_ID
, ORIG_SYSTEM_SHIP_CONTACT_REF ORIG_SYSTEM_SHIP_CONTACT_REF
, ORIG_SYSTEM_SHIP_CONTACT_ID ORIG_SYSTEM_SHIP_CONTACT_ID
, ORIG_SYSTEM_SOLD_CUSTOMER_REF ORIG_SYSTEM_SOLD_CUSTOMER_REF
, ORIG_SYSTEM_SOLD_CUSTOMER_ID ORIG_SYSTEM_SOLD_CUSTOMER_ID
, LINK_TO_LINE_ID LINK_TO_LINE_ID
, LINK_TO_LINE_CONTEXT LINK_TO_LINE_CONTEXT
, LINK_TO_LINE_ATTRIBUTE1 LINK_TO_LINE_ATTRIBUTE1
, LINK_TO_LINE_ATTRIBUTE2 LINK_TO_LINE_ATTRIBUTE2
, LINK_TO_LINE_ATTRIBUTE3 LINK_TO_LINE_ATTRIBUTE3
, LINK_TO_LINE_ATTRIBUTE4 LINK_TO_LINE_ATTRIBUTE4
, LINK_TO_LINE_ATTRIBUTE5 LINK_TO_LINE_ATTRIBUTE5
, LINK_TO_LINE_ATTRIBUTE6 LINK_TO_LINE_ATTRIBUTE6
, LINK_TO_LINE_ATTRIBUTE7 LINK_TO_LINE_ATTRIBUTE7
, RECEIPT_METHOD_NAME RECEIPT_METHOD_NAME
, RECEIPT_METHOD_ID RECEIPT_METHOD_ID
, CONVERSION_TYPE CONVERSION_TYPE
, CONVERSION_DATE CONVERSION_DATE
, CONVERSION_RATE CONVERSION_RATE
, CUSTOMER_TRX_ID CUSTOMER_TRX_ID
, TRX_DATE TRX_DATE
, GL_DATE GL_DATE
, DOCUMENT_NUMBER DOCUMENT_NUMBER
, TRX_NUMBER TRX_NUMBER
, LINE_NUMBER LINE_NUMBER
, QUANTITY QUANTITY
, QUANTITY_ORDERED QUANTITY_ORDERED
, UNIT_SELLING_PRICE UNIT_SELLING_PRICE
, UNIT_STANDARD_PRICE UNIT_STANDARD_PRICE
, PRINTING_OPTION PRINTING_OPTION
, INTERFACE_STATUS INTERFACE_STATUS
, REQUEST_ID REQUEST_ID
, RELATED_BATCH_SOURCE_NAME RELATED_BATCH_SOURCE_NAME
, RELATED_TRX_NUMBER RELATED_TRX_NUMBER
, RELATED_CUSTOMER_TRX_ID RELATED_CUSTOMER_TRX_ID
, PREVIOUS_CUSTOMER_TRX_ID PREVIOUS_CUSTOMER_TRX_ID
, CREDIT_METHOD_FOR_ACCT_RULE CREDIT_METHOD_FOR_ACCT_RULE
, CREDIT_METHOD_FOR_INSTALLMENTS CREDIT_METHOD_FOR_INSTALLMENTS
, REASON_CODE REASON_CODE
, TAX_RATE TAX_RATE
, TAX_CODE TAX_CODE
, TAX_PRECEDENCE TAX_PRECEDENCE
, EXCEPTION_ID EXCEPTION_ID
, EXEMPTION_ID EXEMPTION_ID
, SHIP_DATE_ACTUAL SHIP_DATE_ACTUAL
, FOB_POINT FOB_POINT
, SHIP_VIA SHIP_VIA
, WAYBILL_NUMBER WAYBILL_NUMBER
, INVOICING_RULE_NAME INVOICING_RULE_NAME
, INVOICING_RULE_ID INVOICING_RULE_ID
, ACCOUNTING_RULE_NAME ACCOUNTING_RULE_NAME
, ACCOUNTING_RULE_ID ACCOUNTING_RULE_ID
, ACCOUNTING_RULE_DURATION ACCOUNTING_RULE_DURATION
, RULE_START_DATE RULE_START_DATE
, PRIMARY_SALESREP_NUMBER PRIMARY_SALESREP_NUMBER
, PRIMARY_SALESREP_ID PRIMARY_SALESREP_ID
, SALES_ORDER SALES_ORDER
, SALES_ORDER_LINE SALES_ORDER_LINE
, SALES_ORDER_DATE SALES_ORDER_DATE
, SALES_ORDER_SOURCE SALES_ORDER_SOURCE
, SALES_ORDER_REVISION SALES_ORDER_REVISION
, PURCHASE_ORDER PURCHASE_ORDER
, PURCHASE_ORDER_REVISION PURCHASE_ORDER_REVISION
, PURCHASE_ORDER_DATE PURCHASE_ORDER_DATE
, AGREEMENT_NAME AGREEMENT_NAME
, AGREEMENT_ID AGREEMENT_ID
, MEMO_LINE_NAME MEMO_LINE_NAME
, MEMO_LINE_ID MEMO_LINE_ID
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, MTL_SYSTEM_ITEMS_SEG1 MTL_SYSTEM_ITEMS_SEG1
, MTL_SYSTEM_ITEMS_SEG2 MTL_SYSTEM_ITEMS_SEG2
, MTL_SYSTEM_ITEMS_SEG3 MTL_SYSTEM_ITEMS_SEG3
, MTL_SYSTEM_ITEMS_SEG4 MTL_SYSTEM_ITEMS_SEG4
, MTL_SYSTEM_ITEMS_SEG5 MTL_SYSTEM_ITEMS_SEG5
, MTL_SYSTEM_ITEMS_SEG6 MTL_SYSTEM_ITEMS_SEG6
, MTL_SYSTEM_ITEMS_SEG7 MTL_SYSTEM_ITEMS_SEG7
, MTL_SYSTEM_ITEMS_SEG8 MTL_SYSTEM_ITEMS_SEG8
, MTL_SYSTEM_ITEMS_SEG9 MTL_SYSTEM_ITEMS_SEG9
, MTL_SYSTEM_ITEMS_SEG10 MTL_SYSTEM_ITEMS_SEG10
, MTL_SYSTEM_ITEMS_SEG11 MTL_SYSTEM_ITEMS_SEG11
, MTL_SYSTEM_ITEMS_SEG12 MTL_SYSTEM_ITEMS_SEG12
, MTL_SYSTEM_ITEMS_SEG13 MTL_SYSTEM_ITEMS_SEG13
, MTL_SYSTEM_ITEMS_SEG14 MTL_SYSTEM_ITEMS_SEG14
, MTL_SYSTEM_ITEMS_SEG15 MTL_SYSTEM_ITEMS_SEG15
, MTL_SYSTEM_ITEMS_SEG16 MTL_SYSTEM_ITEMS_SEG16
, MTL_SYSTEM_ITEMS_SEG17 MTL_SYSTEM_ITEMS_SEG17
, MTL_SYSTEM_ITEMS_SEG18 MTL_SYSTEM_ITEMS_SEG18
, MTL_SYSTEM_ITEMS_SEG19 MTL_SYSTEM_ITEMS_SEG19
, MTL_SYSTEM_ITEMS_SEG20 MTL_SYSTEM_ITEMS_SEG20
, REFERENCE_LINE_ID REFERENCE_LINE_ID
, REFERENCE_LINE_CONTEXT REFERENCE_LINE_CONTEXT
, REFERENCE_LINE_ATTRIBUTE1 REFERENCE_LINE_ATTRIBUTE1
, REFERENCE_LINE_ATTRIBUTE2 REFERENCE_LINE_ATTRIBUTE2
, REFERENCE_LINE_ATTRIBUTE3 REFERENCE_LINE_ATTRIBUTE3
, REFERENCE_LINE_ATTRIBUTE4 REFERENCE_LINE_ATTRIBUTE4
, REFERENCE_LINE_ATTRIBUTE5 REFERENCE_LINE_ATTRIBUTE5
, REFERENCE_LINE_ATTRIBUTE6 REFERENCE_LINE_ATTRIBUTE6
, REFERENCE_LINE_ATTRIBUTE7 REFERENCE_LINE_ATTRIBUTE7
, TERRITORY_ID TERRITORY_ID
, TERRITORY_SEGMENT1 TERRITORY_SEGMENT1
, TERRITORY_SEGMENT2 TERRITORY_SEGMENT2
, TERRITORY_SEGMENT3 TERRITORY_SEGMENT3
, TERRITORY_SEGMENT4 TERRITORY_SEGMENT4
, TERRITORY_SEGMENT5 TERRITORY_SEGMENT5
, TERRITORY_SEGMENT6 TERRITORY_SEGMENT6
, TERRITORY_SEGMENT7 TERRITORY_SEGMENT7
, TERRITORY_SEGMENT8 TERRITORY_SEGMENT8
, TERRITORY_SEGMENT9 TERRITORY_SEGMENT9
, TERRITORY_SEGMENT10 TERRITORY_SEGMENT10
, TERRITORY_SEGMENT11 TERRITORY_SEGMENT11
, TERRITORY_SEGMENT12 TERRITORY_SEGMENT12
, TERRITORY_SEGMENT13 TERRITORY_SEGMENT13
, TERRITORY_SEGMENT14 TERRITORY_SEGMENT14
, TERRITORY_SEGMENT15 TERRITORY_SEGMENT15
, TERRITORY_SEGMENT16 TERRITORY_SEGMENT16
, TERRITORY_SEGMENT17 TERRITORY_SEGMENT17
, TERRITORY_SEGMENT18 TERRITORY_SEGMENT18
, TERRITORY_SEGMENT19 TERRITORY_SEGMENT19
, TERRITORY_SEGMENT20 TERRITORY_SEGMENT20
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, HEADER_ATTRIBUTE_CATEGORY HEADER_ATTRIBUTE_CATEGORY
, HEADER_ATTRIBUTE1 HEADER_ATTRIBUTE1
, HEADER_ATTRIBUTE2 HEADER_ATTRIBUTE2
, HEADER_ATTRIBUTE3 HEADER_ATTRIBUTE3
, HEADER_ATTRIBUTE4 HEADER_ATTRIBUTE4
, HEADER_ATTRIBUTE5 HEADER_ATTRIBUTE5
, HEADER_ATTRIBUTE6 HEADER_ATTRIBUTE6
, HEADER_ATTRIBUTE7 HEADER_ATTRIBUTE7
, HEADER_ATTRIBUTE8 HEADER_ATTRIBUTE8
, HEADER_ATTRIBUTE9 HEADER_ATTRIBUTE9
, HEADER_ATTRIBUTE10 HEADER_ATTRIBUTE10
, HEADER_ATTRIBUTE11 HEADER_ATTRIBUTE11
, HEADER_ATTRIBUTE12 HEADER_ATTRIBUTE12
, HEADER_ATTRIBUTE13 HEADER_ATTRIBUTE13
, HEADER_ATTRIBUTE14 HEADER_ATTRIBUTE14
, HEADER_ATTRIBUTE15 HEADER_ATTRIBUTE15
, COMMENTS COMMENTS
, INTERNAL_NOTES INTERNAL_NOTES
, INITIAL_CUSTOMER_TRX_ID INITIAL_CUSTOMER_TRX_ID
, USSGL_TRANSACTION_CODE_CONTEXT USSGL_TRANSACTION_CODE_CONTEXT
, USSGL_TRANSACTION_CODE USSGL_TRANSACTION_CODE
, ACCTD_AMOUNT ACCTD_AMOUNT
, CUSTOMER_BANK_ACCOUNT_ID CUSTOMER_BANK_ACCOUNT_ID
, CUSTOMER_BANK_ACCOUNT_NAME CUSTOMER_BANK_ACCOUNT_NAME
, UOM_CODE UOM_CODE
, UOM_NAME UOM_NAME
, DOCUMENT_NUMBER_SEQUENCE_ID DOCUMENT_NUMBER_SEQUENCE_ID
, LINK_TO_LINE_ATTRIBUTE10 LINK_TO_LINE_ATTRIBUTE10
, LINK_TO_LINE_ATTRIBUTE11 LINK_TO_LINE_ATTRIBUTE11
, LINK_TO_LINE_ATTRIBUTE12 LINK_TO_LINE_ATTRIBUTE12
, LINK_TO_LINE_ATTRIBUTE13 LINK_TO_LINE_ATTRIBUTE13
, LINK_TO_LINE_ATTRIBUTE14 LINK_TO_LINE_ATTRIBUTE14
, LINK_TO_LINE_ATTRIBUTE15 LINK_TO_LINE_ATTRIBUTE15
, LINK_TO_LINE_ATTRIBUTE8 LINK_TO_LINE_ATTRIBUTE8
, LINK_TO_LINE_ATTRIBUTE9 LINK_TO_LINE_ATTRIBUTE9
, REFERENCE_LINE_ATTRIBUTE10 REFERENCE_LINE_ATTRIBUTE10
, REFERENCE_LINE_ATTRIBUTE11 REFERENCE_LINE_ATTRIBUTE11
, REFERENCE_LINE_ATTRIBUTE12 REFERENCE_LINE_ATTRIBUTE12
, REFERENCE_LINE_ATTRIBUTE13 REFERENCE_LINE_ATTRIBUTE13
, REFERENCE_LINE_ATTRIBUTE14 REFERENCE_LINE_ATTRIBUTE14
, REFERENCE_LINE_ATTRIBUTE15 REFERENCE_LINE_ATTRIBUTE15
, REFERENCE_LINE_ATTRIBUTE8 REFERENCE_LINE_ATTRIBUTE8
, REFERENCE_LINE_ATTRIBUTE9 REFERENCE_LINE_ATTRIBUTE9
, INTERFACE_LINE_ATTRIBUTE10 INTERFACE_LINE_ATTRIBUTE10
, INTERFACE_LINE_ATTRIBUTE11 INTERFACE_LINE_ATTRIBUTE11
, INTERFACE_LINE_ATTRIBUTE12 INTERFACE_LINE_ATTRIBUTE12
, INTERFACE_LINE_ATTRIBUTE13 INTERFACE_LINE_ATTRIBUTE13
, INTERFACE_LINE_ATTRIBUTE14 INTERFACE_LINE_ATTRIBUTE14
, INTERFACE_LINE_ATTRIBUTE15 INTERFACE_LINE_ATTRIBUTE15
, INTERFACE_LINE_ATTRIBUTE9 INTERFACE_LINE_ATTRIBUTE9
, VAT_TAX_ID VAT_TAX_ID
, REASON_CODE_MEANING REASON_CODE_MEANING
, LAST_PERIOD_TO_CREDIT LAST_PERIOD_TO_CREDIT
, PAYING_CUSTOMER_ID PAYING_CUSTOMER_ID
, PAYING_SITE_USE_ID PAYING_SITE_USE_ID
, TAX_EXEMPT_FLAG TAX_EXEMPT_FLAG
, TAX_EXEMPT_REASON_CODE TAX_EXEMPT_REASON_CODE
, TAX_EXEMPT_REASON_CODE_MEANING TAX_EXEMPT_REASON_CODE_MEANING
, TAX_EXEMPT_NUMBER TAX_EXEMPT_NUMBER
, SALES_TAX_ID SALES_TAX_ID
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, LOCATION_SEGMENT_ID LOCATION_SEGMENT_ID
, MOVEMENT_ID MOVEMENT_ID
, ORG_ID ORG_ID
, AMOUNT_INCLUDES_TAX_FLAG AMOUNT_INCLUDES_TAX_FLAG
, HEADER_GDF_ATTR_CATEGORY HEADER_GDF_ATTR_CATEGORY
, HEADER_GDF_ATTRIBUTE1 HEADER_GDF_ATTRIBUTE1
, HEADER_GDF_ATTRIBUTE2 HEADER_GDF_ATTRIBUTE2
, HEADER_GDF_ATTRIBUTE3 HEADER_GDF_ATTRIBUTE3
, HEADER_GDF_ATTRIBUTE4 HEADER_GDF_ATTRIBUTE4
, HEADER_GDF_ATTRIBUTE5 HEADER_GDF_ATTRIBUTE5
, HEADER_GDF_ATTRIBUTE6 HEADER_GDF_ATTRIBUTE6
, HEADER_GDF_ATTRIBUTE7 HEADER_GDF_ATTRIBUTE7
, HEADER_GDF_ATTRIBUTE8 HEADER_GDF_ATTRIBUTE8
, HEADER_GDF_ATTRIBUTE9 HEADER_GDF_ATTRIBUTE9
, HEADER_GDF_ATTRIBUTE10 HEADER_GDF_ATTRIBUTE10
, HEADER_GDF_ATTRIBUTE11 HEADER_GDF_ATTRIBUTE11
, HEADER_GDF_ATTRIBUTE12 HEADER_GDF_ATTRIBUTE12
, HEADER_GDF_ATTRIBUTE13 HEADER_GDF_ATTRIBUTE13
, HEADER_GDF_ATTRIBUTE14 HEADER_GDF_ATTRIBUTE14
, HEADER_GDF_ATTRIBUTE15 HEADER_GDF_ATTRIBUTE15
, HEADER_GDF_ATTRIBUTE16 HEADER_GDF_ATTRIBUTE16
, HEADER_GDF_ATTRIBUTE17 HEADER_GDF_ATTRIBUTE17
, HEADER_GDF_ATTRIBUTE18 HEADER_GDF_ATTRIBUTE18
, HEADER_GDF_ATTRIBUTE19 HEADER_GDF_ATTRIBUTE19
, HEADER_GDF_ATTRIBUTE20 HEADER_GDF_ATTRIBUTE20
, HEADER_GDF_ATTRIBUTE21 HEADER_GDF_ATTRIBUTE21
, HEADER_GDF_ATTRIBUTE22 HEADER_GDF_ATTRIBUTE22
, HEADER_GDF_ATTRIBUTE23 HEADER_GDF_ATTRIBUTE23
, HEADER_GDF_ATTRIBUTE24 HEADER_GDF_ATTRIBUTE24
, HEADER_GDF_ATTRIBUTE25 HEADER_GDF_ATTRIBUTE25
, HEADER_GDF_ATTRIBUTE26 HEADER_GDF_ATTRIBUTE26
, HEADER_GDF_ATTRIBUTE27 HEADER_GDF_ATTRIBUTE27
, HEADER_GDF_ATTRIBUTE28 HEADER_GDF_ATTRIBUTE28
, HEADER_GDF_ATTRIBUTE29 HEADER_GDF_ATTRIBUTE29
, HEADER_GDF_ATTRIBUTE30 HEADER_GDF_ATTRIBUTE30
, LINE_GDF_ATTR_CATEGORY LINE_GDF_ATTR_CATEGORY
, LINE_GDF_ATTRIBUTE1 LINE_GDF_ATTRIBUTE1
, LINE_GDF_ATTRIBUTE2 LINE_GDF_ATTRIBUTE2
, LINE_GDF_ATTRIBUTE3 LINE_GDF_ATTRIBUTE3
, LINE_GDF_ATTRIBUTE4 LINE_GDF_ATTRIBUTE4
, LINE_GDF_ATTRIBUTE5 LINE_GDF_ATTRIBUTE5
, LINE_GDF_ATTRIBUTE6 LINE_GDF_ATTRIBUTE6
, LINE_GDF_ATTRIBUTE7 LINE_GDF_ATTRIBUTE7
, LINE_GDF_ATTRIBUTE8 LINE_GDF_ATTRIBUTE8
, LINE_GDF_ATTRIBUTE9 LINE_GDF_ATTRIBUTE9
, LINE_GDF_ATTRIBUTE10 LINE_GDF_ATTRIBUTE10
, LINE_GDF_ATTRIBUTE11 LINE_GDF_ATTRIBUTE11
, LINE_GDF_ATTRIBUTE12 LINE_GDF_ATTRIBUTE12
, LINE_GDF_ATTRIBUTE13 LINE_GDF_ATTRIBUTE13
, LINE_GDF_ATTRIBUTE14 LINE_GDF_ATTRIBUTE14
, LINE_GDF_ATTRIBUTE15 LINE_GDF_ATTRIBUTE15
, LINE_GDF_ATTRIBUTE16 LINE_GDF_ATTRIBUTE16
, LINE_GDF_ATTRIBUTE17 LINE_GDF_ATTRIBUTE17
, LINE_GDF_ATTRIBUTE18 LINE_GDF_ATTRIBUTE18
, LINE_GDF_ATTRIBUTE19 LINE_GDF_ATTRIBUTE19
, LINE_GDF_ATTRIBUTE20 LINE_GDF_ATTRIBUTE20
, RESET_TRX_DATE_FLAG RESET_TRX_DATE_FLAG
, PAYMENT_SERVER_ORDER_NUM PAYMENT_SERVER_ORDER_NUM
, APPROVAL_CODE APPROVAL_CODE
, ADDRESS_VERIFICATION_CODE ADDRESS_VERIFICATION_CODE
, WAREHOUSE_ID WAREHOUSE_ID
, TRANSLATED_DESCRIPTION TRANSLATED_DESCRIPTION
, CONS_BILLING_NUMBER CONS_BILLING_NUMBER
, PROMISED_COMMITMENT_AMOUNT PROMISED_COMMITMENT_AMOUNT
, PAYMENT_SET_ID PAYMENT_SET_ID
, ORIGINAL_GL_DATE ORIGINAL_GL_DATE
, CONTRACT_LINE_ID CONTRACT_LINE_ID
, CONTRACT_ID CONTRACT_ID
, SOURCE_DATA_KEY1 SOURCE_DATA_KEY1
, SOURCE_DATA_KEY2 SOURCE_DATA_KEY2
, SOURCE_DATA_KEY3 SOURCE_DATA_KEY3
, SOURCE_DATA_KEY4 SOURCE_DATA_KEY4
, SOURCE_DATA_KEY5 SOURCE_DATA_KEY5
, INVOICED_LINE_ACCTG_LEVEL INVOICED_LINE_ACCTG_LEVEL
, OVERRIDE_AUTO_ACCOUNTING_FLAG OVERRIDE_AUTO_ACCOUNTING_FLAG
, SOURCE_APPLICATION_ID SOURCE_APPLICATION_ID
, SOURCE_EVENT_CLASS_CODE SOURCE_EVENT_CLASS_CODE
, SOURCE_ENTITY_CODE SOURCE_ENTITY_CODE
, SOURCE_TRX_ID SOURCE_TRX_ID
, SOURCE_TRX_LINE_ID SOURCE_TRX_LINE_ID
, SOURCE_TRX_LINE_TYPE SOURCE_TRX_LINE_TYPE
, SOURCE_TRX_DETAIL_TAX_LINE_ID SOURCE_TRX_DETAIL_TAX_LINE_ID
, HISTORICAL_FLAG HISTORICAL_FLAG
, TAX_REGIME_CODE TAX_REGIME_CODE
, TAX TAX
, TAX_STATUS_CODE TAX_STATUS_CODE
, TAX_RATE_CODE TAX_RATE_CODE
, TAX_JURISDICTION_CODE TAX_JURISDICTION_CODE
, TAXABLE_AMOUNT TAXABLE_AMOUNT
, TAXABLE_FLAG TAXABLE_FLAG
, LEGAL_ENTITY_ID LEGAL_ENTITY_ID
, PARENT_LINE_ID PARENT_LINE_ID
, DEFERRAL_EXCLUSION_FLAG DEFERRAL_EXCLUSION_FLAG
, PAYMENT_TRXN_EXTENSION_ID PAYMENT_TRXN_EXTENSION_ID
, RULE_END_DATE RULE_END_DATE
, PAYMENT_ATTRIBUTES PAYMENT_ATTRIBUTES
, APPLICATION_ID APPLICATION_ID
, BILLING_DATE BILLING_DATE
, TRX_BUSINESS_CATEGORY TRX_BUSINESS_CATEGORY
, PRODUCT_FISC_CLASSIFICATION PRODUCT_FISC_CLASSIFICATION
, PRODUCT_CATEGORY PRODUCT_CATEGORY
, PRODUCT_TYPE PRODUCT_TYPE
, LINE_INTENDED_USE LINE_INTENDED_USE
, ASSESSABLE_VALUE ASSESSABLE_VALUE
, DOCUMENT_SUB_TYPE DOCUMENT_SUB_TYPE
, DEFAULT_TAXATION_COUNTRY DEFAULT_TAXATION_COUNTRY
, USER_DEFINED_FISC_CLASS USER_DEFINED_FISC_CLASS
, TAXED_UPSTREAM_FLAG TAXED_UPSTREAM_FLAG
, TAX_INVOICE_DATE TAX_INVOICE_DATE
, TAX_INVOICE_NUMBER TAX_INVOICE_NUMBER
, PAYMENT_TYPE_CODE PAYMENT_TYPE_CODE
, MANDATE_LAST_TRX_FLAG MANDATE_LAST_TRX_FLAG
FROM "AR"."RA_INTERFACE_LINES_ALL"