Subject Problem with query - very long query
Author Jonathan L
Post date 2001-10-25T02:42:22Z
> Hello all,
>
> can anyone help me with this query problem :
>
> The following SQL can be run successfully :
>
> SELECT SUM( GL_AMOUNT.AMOUNT ) AS SUM_OF_AMOUNT,
> ORAFINAR.ARID,
> ORAFINAR.ACCOUNTING_RULE_DURATION
> FROM ORAFINAR
> RIGHT OUTER JOIN ORAFINARITEM ON (ORAFINAR.ARID = ORAFINARITEM.ARID)
> LEFT OUTER JOIN GL_AMOUNT ON (ORAFINARITEM.GL_ITEM_ID =
> GL_AMOUNT.GL_ITEM_ID)
> WHERE
> (
> (GL_AMOUNT.GL_MONTH = '200108')
> )
> GROUP BY ORAFINAR.ARID, ORAFINAR.ACCOUNTING_RULE_DURATION
> ORDER BY ORAFINAR.ARID
>
> but when I try to include ALL COLUMNS of ORAFINAR, error occurs :
>
> Invalid token.
> invalid request BLR at offset 2289
> BLR syntax error: expected blr_map at offset 2289, encountered 24.
>
> TIA
>
> Jonathan L
>
>
>
> P. S :
>
> Query is run in IBConsole, the error query is :
> SELECT SUM( GL_AMOUNT.AMOUNT ) AS SUM_OF_AMOUNT,
> ORAFINAR.ARID,
> ORAFINAR.ACCOUNTING_RULE_DURATION,
> ORAFINAR.ACCOUNTING_RULE_ID,
> ORAFINAR.ACCOUNTING_RULE_NAME,
> ORAFINAR.ACCTD_AMOUNT,
> ORAFINAR.ADDRESS_VERIFICATION_CODE,
> ORAFINAR.AGREEMENT_ID,
> ORAFINAR.AGREEMENT_NAME,
> ORAFINAR.AMOUNT,
> ORAFINAR.AMOUNT_INCLUDE_TAX_FLAG,
> ORAFINAR.APPROVAL_CODE,
> ORAFINAR.ATTRIBUTE_CATEGORY,
> ORAFINAR.ATTRIBUTE1,
> ORAFINAR.ATTRIBUTE2,
> ORAFINAR.ATTRIBUTE3,
> ORAFINAR.ATTRIBUTE4,
> ORAFINAR.ATTRIBUTE5,
> ORAFINAR.ATTRIBUTE6,
> ORAFINAR.ATTRIBUTE7,
> ORAFINAR.ATTRIBUTE8,
> ORAFINAR.ATTRIBUTE9,
> ORAFINAR.ATTRIBUTE10,
> ORAFINAR.ATTRIBUTE11,
> ORAFINAR.ATTRIBUTE12,
> ORAFINAR.ATTRIBUTE13,
> ORAFINAR.ATTRIBUTE14,
> ORAFINAR.ATTRIBUTE15,
> ORAFINAR.BATCH_SOURCE_NAME,
> ORAFINAR.COMMENTS,
> ORAFINAR.CONS_BILLING_NUMBER,
> ORAFINAR.CONVERSION_DATE,
> ORAFINAR.CONVERSION_RATE,
> ORAFINAR.CONVERSION_TYPE,
> ORAFINAR.CREATED_BY,
> ORAFINAR.CREATION_DATE,
> ORAFINAR.CREDIT_METHOD_FOR_ACCT_RULE,
> ORAFINAR.CREDIT_METHOD_FOR_INSTALLMENTS,
> ORAFINAR.CURRENCY_CODE,
> ORAFINAR.CUST_TRX_TYPE_ID,
> ORAFINAR.CUST_TRX_TYPE_NAME,
> ORAFINAR.CUSTOMER_BANK_ACCOUNT_ID,
> ORAFINAR.CUSTOMER_BANK_ACCOUNT_NAME,
> ORAFINAR.CUSTOMER_TRX_ID,
> ORAFINAR.DESCRIPTION,
> ORAFINAR.DOCUMENT_NUMBER,
> ORAFINAR.DOCUMENT_NUMBER_SEQUENCE_ID,
> ORAFINAR.EXCEPTION_ID,
> ORAFINAR.EXEMPTION_ID,
> ORAFINAR.FOB_POINT,
> ORAFINAR.GL_DATE,
> ORAFINAR.HEADER_ATTRIBUTE_CATEGORY,
> ORAFINAR.HEADER_ATTRIBUTE1,
> ORAFINAR.HEADER_ATTRIBUTE2,
> ORAFINAR.HEADER_ATTRIBUTE3,
> ORAFINAR.HEADER_ATTRIBUTE4,
> ORAFINAR.HEADER_ATTRIBUTE5,
> ORAFINAR.HEADER_ATTRIBUTE6,
> ORAFINAR.HEADER_ATTRIBUTE7,
> ORAFINAR.HEADER_ATTRIBUTE8,
> ORAFINAR.HEADER_ATTRIBUTE9,
> ORAFINAR.HEADER_ATTRIBUTE10,
> ORAFINAR.HEADER_ATTRIBUTE11,
> ORAFINAR.HEADER_ATTRIBUTE12,
> ORAFINAR.HEADER_ATTRIBUTE13,
> ORAFINAR.HEADER_ATTRIBUTE14,
> ORAFINAR.HEADER_ATTRIBUTE15,
> ORAFINAR.HEADER_GDF_ATTR_CATEGORY,
> ORAFINAR.HEADER_GDF_ATTRIBUTE1,
> ORAFINAR.HEADER_GDF_ATTRIBUTE2,
> ORAFINAR.HEADER_GDF_ATTRIBUTE3,
> ORAFINAR.HEADER_GDF_ATTRIBUTE4,
> ORAFINAR.HEADER_GDF_ATTRIBUTE5,
> ORAFINAR.HEADER_GDF_ATTRIBUTE6,
> ORAFINAR.HEADER_GDF_ATTRIBUTE7,
> ORAFINAR.HEADER_GDF_ATTRIBUTE8,
> ORAFINAR.HEADER_GDF_ATTRIBUTE9,
> ORAFINAR.HEADER_GDF_ATTRIBUTE10,
> ORAFINAR.HEADER_GDF_ATTRIBUTE11,
> ORAFINAR.HEADER_GDF_ATTRIBUTE12,
> ORAFINAR.HEADER_GDF_ATTRIBUTE13,
> ORAFINAR.HEADER_GDF_ATTRIBUTE14,
> ORAFINAR.HEADER_GDF_ATTRIBUTE15,
> ORAFINAR.HEADER_GDF_ATTRIBUTE16,
> ORAFINAR.HEADER_GDF_ATTRIBUTE17,
> ORAFINAR.HEADER_GDF_ATTRIBUTE18,
> ORAFINAR.HEADER_GDF_ATTRIBUTE19,
> ORAFINAR.HEADER_GDF_ATTRIBUTE20,
> ORAFINAR.HEADER_GDF_ATTRIBUTE21,
> ORAFINAR.HEADER_GDF_ATTRIBUTE22,
> ORAFINAR.HEADER_GDF_ATTRIBUTE23,
> ORAFINAR.HEADER_GDF_ATTRIBUTE24,
> ORAFINAR.HEADER_GDF_ATTRIBUTE25,
> ORAFINAR.HEADER_GDF_ATTRIBUTE26,
> ORAFINAR.HEADER_GDF_ATTRIBUTE27,
> ORAFINAR.HEADER_GDF_ATTRIBUTE28,
> ORAFINAR.HEADER_GDF_ATTRIBUTE29,
> ORAFINAR.HEADER_GDF_ATTRIBUTE30,
> ORAFINAR.INITIAL_CUSTOMER_TRX_ID,
> ORAFINAR.INTERFACE_LINE_ATTRIBUTE1,
> ORAFINAR.INTERFACE_LINE_ATTRIBUTE2,
> ORAFINAR.INTERFACE_LINE_ATTRIBUTE3,
> ORAFINAR.INTERFACE_LINE_ATTRIBUTE4,
> ORAFINAR.INTERFACE_LINE_ATTRIBUTE5,
> ORAFINAR.INTERFACE_LINE_ATTRIBUTE6,
> ORAFINAR.INTERFACE_LINE_ATTRIBUTE7,
> ORAFINAR.INTERFACE_LINE_ATTRIBUTE8,
> ORAFINAR.INTERFACE_LINE_ATTRIBUTE9,
> ORAFINAR.INTERFACE_LINE_ATTRIBUTE10,
> ORAFINAR.INTERFACE_LINE_ATTRIBUTE11,
> ORAFINAR.INTERFACE_LINE_ATTRIBUTE12,
> ORAFINAR.INTERFACE_LINE_ATTRIBUTE13,
> ORAFINAR.INTERFACE_LINE_ATTRIBUTE14,
> ORAFINAR.INTERFACE_LINE_ATTRIBUTE15,
> ORAFINAR.INTERFACE_LINE_CONTEXT,
> ORAFINAR.INTERFACE_LINE_ID,
> ORAFINAR.INTERFACE_STATUS,
> ORAFINAR.INTERNAL_NOTES,
> ORAFINAR.INVENTORY_ITEM_ID,
> ORAFINAR.INVOICING_RULE_ID,
> ORAFINAR.INVOICING_RULE_NAME,
> ORAFINAR.LAST_PERIOD_TO_CREDIT,
> ORAFINAR.LAST_UPDATE_DATE,
> ORAFINAR.LAST_UPDATE_LOGIN,
> ORAFINAR.LAST_UPDATED_BY,
> ORAFINAR.LINE_GDF_ATTR_CATEGORY,
> ORAFINAR.LINE_GDF_ATTRIBUTE1,
> ORAFINAR.LINE_GDF_ATTRIBUTE2,
> ORAFINAR.LINE_GDF_ATTRIBUTE3,
> ORAFINAR.LINE_GDF_ATTRIBUTE4,
> ORAFINAR.LINE_GDF_ATTRIBUTE5,
> ORAFINAR.LINE_GDF_ATTRIBUTE6,
> ORAFINAR.LINE_GDF_ATTRIBUTE7,
> ORAFINAR.LINE_GDF_ATTRIBUTE8,
> ORAFINAR.LINE_GDF_ATTRIBUTE9,
> ORAFINAR.LINE_GDF_ATTRIBUTE10,
> ORAFINAR.LINE_GDF_ATTRIBUTE11,
> ORAFINAR.LINE_GDF_ATTRIBUTE12,
> ORAFINAR.LINE_GDF_ATTRIBUTE13,
> ORAFINAR.LINE_GDF_ATTRIBUTE14,
> ORAFINAR.LINE_GDF_ATTRIBUTE15,
> ORAFINAR.LINE_GDF_ATTRIBUTE16,
> ORAFINAR.LINE_GDF_ATTRIBUTE17,
> ORAFINAR.LINE_GDF_ATTRIBUTE18,
> ORAFINAR.LINE_GDF_ATTRIBUTE19,
> ORAFINAR.LINE_GDF_ATTRIBUTE20,
> ORAFINAR.LINE_NUMBER,
> ORAFINAR.LINE_TYPE,
> ORAFINAR.LINK_TO_LINE_ATTRIBUTE1,
> ORAFINAR.LINK_TO_LINE_ATTRIBUTE2,
> ORAFINAR.LINK_TO_LINE_ATTRIBUTE3,
> ORAFINAR.LINK_TO_LINE_ATTRIBUTE4,
> ORAFINAR.LINK_TO_LINE_ATTRIBUTE5,
> ORAFINAR.LINK_TO_LINE_ATTRIBUTE6,
> ORAFINAR.LINK_TO_LINE_ATTRIBUTE7,
> ORAFINAR.LINK_TO_LINE_ATTRIBUTE8,
> ORAFINAR.LINK_TO_LINE_ATTRIBUTE9,
> ORAFINAR.LINK_TO_LINE_ATTRIBUTE10,
> ORAFINAR.LINK_TO_LINE_ATTRIBUTE11,
> ORAFINAR.LINK_TO_LINE_ATTRIBUTE12,
> ORAFINAR.LINK_TO_LINE_ATTRIBUTE13,
> ORAFINAR.LINK_TO_LINE_ATTRIBUTE14,
> ORAFINAR.LINK_TO_LINE_ATTRIBUTE15,
> ORAFINAR.LINK_TO_LINE_CONTEXT,
> ORAFINAR.LINK_TO_LINE_ID,
> ORAFINAR.LOCATION_SEGMENT_ID,
> ORAFINAR.MEMO_LINE_ID,
> ORAFINAR.MEMO_LINE_NAME,
> ORAFINAR.MOVEMENT_ID,
> ORAFINAR.MTL_SYSTEM_ITEMS_SEG1,
> ORAFINAR.MTL_SYSTEM_ITEMS_SEG2,
> ORAFINAR.MTL_SYSTEM_ITEMS_SEG3,
> ORAFINAR.MTL_SYSTEM_ITEMS_SEG4,
> ORAFINAR.MTL_SYSTEM_ITEMS_SEG5,
> ORAFINAR.MTL_SYSTEM_ITEMS_SEG6,
> ORAFINAR.MTL_SYSTEM_ITEMS_SEG7,
> ORAFINAR.MTL_SYSTEM_ITEMS_SEG8,
> ORAFINAR.MTL_SYSTEM_ITEMS_SEG9,
> ORAFINAR.MTL_SYSTEM_ITEMS_SEG10,
> ORAFINAR.MTL_SYSTEM_ITEMS_SEG11,
> ORAFINAR.MTL_SYSTEM_ITEMS_SEG12,
> ORAFINAR.MTL_SYSTEM_ITEMS_SEG13,
> ORAFINAR.MTL_SYSTEM_ITEMS_SEG14,
> ORAFINAR.MTL_SYSTEM_ITEMS_SEG15,
> ORAFINAR.MTL_SYSTEM_ITEMS_SEG16,
> ORAFINAR.MTL_SYSTEM_ITEMS_SEG17,
> ORAFINAR.MTL_SYSTEM_ITEMS_SEG18,
> ORAFINAR.MTL_SYSTEM_ITEMS_SEG19,
> ORAFINAR.MTL_SYSTEM_ITEMS_SEG20,
> ORAFINAR.ORG_ID,
> ORAFINAR.ORIG_SYSTEM_BATCH_NAME,
> ORAFINAR.ORIG_SYSTEM_BILL_ADDRESS_ID,
> ORAFINAR.ORIG_SYSTEM_BILL_ADDRESS_REF,
> ORAFINAR.ORIG_SYSTEM_BILL_CONTACT_ID,
> ORAFINAR.ORIG_SYSTEM_BILL_CONTACT_REF,
> ORAFINAR.ORIG_SYSTEM_BILL_CUSTOMER_ID,
> ORAFINAR.ORIG_SYSTEM_BILL_CUSTOMER_REF,
> ORAFINAR.ORIG_SYSTEM_SHIP_ADDRESS_ID,
> ORAFINAR.ORIG_SYSTEM_SHIP_ADDRESS_REF,
> ORAFINAR.ORIG_SYSTEM_SHIP_CONTACT_ID,
> ORAFINAR.ORIG_SYSTEM_SHIP_CONTACT_REF,
> ORAFINAR.ORIG_SYSTEM_SHIP_CUSTOMER_ID,
> ORAFINAR.ORIG_SYSTEM_SHIP_CUSTOMER_REF,
> ORAFINAR.ORIG_SYSTEM_SOLD_CUSTOMER_ID,
> ORAFINAR.ORIG_SYSTEM_SOLD_CUSTOMER_REF,
> ORAFINAR.PAYING_CUSTOMER_ID,
> ORAFINAR.PAYING_SITE_USE_ID,
> ORAFINAR.PAYMENT_SERVER_ORDER_NUM,
> ORAFINAR.PREVIOUS_CUSTOMER_TRX_ID,
> ORAFINAR.PRIMARY_SALESREP_ID,
> ORAFINAR.PRIMARY_SALESREP_NUMBER,
> ORAFINAR.PRINTING_OPTION,
> ORAFINAR.PURCHASE_ORDER,
> ORAFINAR.PURCHASE_ORDER_DATE,
> ORAFINAR.PURCHASE_ORDER_REVISION,
> ORAFINAR.QUANTITY,
> ORAFINAR.QUANTITY_ORDERED,
> ORAFINAR.REASON_CODE,
> ORAFINAR.REASON_CODE_MEANING,
> ORAFINAR.RECEIPT_METHOD_ID,
> ORAFINAR.RECEIPT_METHOD_NAME,
> ORAFINAR.REFERENCE_LINE_ATTRIBUTE1,
> ORAFINAR.REFERENCE_LINE_ATTRIBUTE2,
> ORAFINAR.REFERENCE_LINE_ATTRIBUTE3,
> ORAFINAR.REFERENCE_LINE_ATTRIBUTE4,
> ORAFINAR.REFERENCE_LINE_ATTRIBUTE5,
> ORAFINAR.REFERENCE_LINE_ATTRIBUTE6,
> ORAFINAR.REFERENCE_LINE_ATTRIBUTE7,
> ORAFINAR.REFERENCE_LINE_ATTRIBUTE8,
> ORAFINAR.REFERENCE_LINE_ATTRIBUTE9,
> ORAFINAR.REFERENCE_LINE_ATTRIBUTE10,
> ORAFINAR.REFERENCE_LINE_ATTRIBUTE11,
> ORAFINAR.REFERENCE_LINE_ATTRIBUTE12,
> ORAFINAR.REFERENCE_LINE_ATTRIBUTE13,
> ORAFINAR.REFERENCE_LINE_ATTRIBUTE14,
> ORAFINAR.REFERENCE_LINE_ATTRIBUTE15,
> ORAFINAR.REFERENCE_LINE_CONTEXT,
> ORAFINAR.REFERENCE_LINE_ID,
> ORAFINAR.RELATED_BATCH_SOURCE_NAME,
> ORAFINAR.RELATED_CUSTOMER_TRX_ID,
> ORAFINAR.RELATED_TRX_NUMBER,
> ORAFINAR.REQUEST_ID,
> ORAFINAR.RESET_TRX_DATE_FLAG,
> ORAFINAR.RULE_START_DATE,
> ORAFINAR.SALES_ORDER,
> ORAFINAR.SALES_ORDER_DATE,
> ORAFINAR.SALES_ORDER_LINE,
> ORAFINAR.SALES_ORDER_REVISION,
> ORAFINAR.SALES_ORDER_SOURCE,
> ORAFINAR.SALES_TAX_ID,
> ORAFINAR.SET_OF_BOOKS_ID,
> ORAFINAR.SHIP_DATE_ACTUAL,
> ORAFINAR.SHIP_VIA,
> ORAFINAR.TAX_CODE,
> ORAFINAR.TAX_EXEMPT_FLAG,
> ORAFINAR.TAX_EXEMPT_NUMBER,
> ORAFINAR.TAX_EXEMPT_REASON_CODE,
> ORAFINAR.TAX_EXEMPT_REASON_CODE_MEANING,
> ORAFINAR.TAX_PRECEDENCE,
> ORAFINAR.TAX_RATE,
> ORAFINAR.TERM_ID,
> ORAFINAR.TERM_NAME,
> ORAFINAR.TERRITORY_ID,
> ORAFINAR.TERRITORY_SEGMENT1,
> ORAFINAR.TERRITORY_SEGMENT2,
> ORAFINAR.TERRITORY_SEGMENT3,
> ORAFINAR.TERRITORY_SEGMENT4,
> ORAFINAR.TERRITORY_SEGMENT5,
> ORAFINAR.TERRITORY_SEGMENT6,
> ORAFINAR.TERRITORY_SEGMENT7,
> ORAFINAR.TERRITORY_SEGMENT8,
> ORAFINAR.TERRITORY_SEGMENT9,
> ORAFINAR.TERRITORY_SEGMENT10,
> ORAFINAR.TERRITORY_SEGMENT11,
> ORAFINAR.TERRITORY_SEGMENT12,
> ORAFINAR.TERRITORY_SEGMENT13,
> ORAFINAR.TERRITORY_SEGMENT14,
> ORAFINAR.TERRITORY_SEGMENT15,
> ORAFINAR.TERRITORY_SEGMENT16,
> ORAFINAR.TERRITORY_SEGMENT17,
> ORAFINAR.TERRITORY_SEGMENT18,
> ORAFINAR.TERRITORY_SEGMENT19,
> ORAFINAR.TERRITORY_SEGMENT20,
> ORAFINAR.TRANSLATED_DESCRIPTION,
> ORAFINAR.TRX_DATE,
> ORAFINAR.TRX_NUMBER,
> ORAFINAR.UNIT_SELLING_PRICE,
> ORAFINAR.UNIT_STANDARD_PRICE,
> ORAFINAR.UOM_CODE,
> ORAFINAR.UOM_NAME,
> ORAFINAR.USSGL_TRANSACTION_CODE,
> ORAFINAR.USSGL_TRANSACTION_CODE_CONTEXT,
> ORAFINAR.VAT_TAX_ID,
> ORAFINAR.WAREHOUSE_ID,
> ORAFINAR.WAYBILL_NUMBER
> FROM ORAFINAR
> RIGHT OUTER JOIN ORAFINARITEM ON (ORAFINAR.ARID = ORAFINARITEM.ARID)
> LEFT OUTER JOIN GL_AMOUNT ON (ORAFINARITEM.GL_ITEM_ID =
> GL_AMOUNT.GL_ITEM_ID)
> WHERE
> (
> (GL_AMOUNT.GL_MONTH = '200108')
> )
> GROUP BY ORAFINAR.ARID,
> ORAFINAR.ACCOUNTING_RULE_DURATION,
> ORAFINAR.ACCOUNTING_RULE_ID,
> ORAFINAR.ACCOUNTING_RULE_NAME,
> ORAFINAR.ACCTD_AMOUNT,
> ORAFINAR.ADDRESS_VERIFICATION_CODE,
> ORAFINAR.AGREEMENT_ID,
> ORAFINAR.AGREEMENT_NAME,
> ORAFINAR.AMOUNT,
> ORAFINAR.AMOUNT_INCLUDE_TAX_FLAG,
> ORAFINAR.APPROVAL_CODE,
> ORAFINAR.ATTRIBUTE_CATEGORY,
> ORAFINAR.ATTRIBUTE1,
> ORAFINAR.ATTRIBUTE2,
> ORAFINAR.ATTRIBUTE3,
> ORAFINAR.ATTRIBUTE4,
> ORAFINAR.ATTRIBUTE5,
> ORAFINAR.ATTRIBUTE6,
> ORAFINAR.ATTRIBUTE7,
> ORAFINAR.ATTRIBUTE8,
> ORAFINAR.ATTRIBUTE9,
> ORAFINAR.ATTRIBUTE10,
> ORAFINAR.ATTRIBUTE11,
> ORAFINAR.ATTRIBUTE12,
> ORAFINAR.ATTRIBUTE13,
> ORAFINAR.ATTRIBUTE14,
> ORAFINAR.ATTRIBUTE15,
> ORAFINAR.BATCH_SOURCE_NAME,
> ORAFINAR.COMMENTS,
> ORAFINAR.CONS_BILLING_NUMBER,
> ORAFINAR.CONVERSION_DATE,
> ORAFINAR.CONVERSION_RATE,
> ORAFINAR.CONVERSION_TYPE,
> ORAFINAR.CREATED_BY,
> ORAFINAR.CREATION_DATE,
> ORAFINAR.CREDIT_METHOD_FOR_ACCT_RULE,
> ORAFINAR.CREDIT_METHOD_FOR_INSTALLMENTS,
> ORAFINAR.CURRENCY_CODE,
> ORAFINAR.CUST_TRX_TYPE_ID,
> ORAFINAR.CUST_TRX_TYPE_NAME,
> ORAFINAR.CUSTOMER_BANK_ACCOUNT_ID,
> ORAFINAR.CUSTOMER_BANK_ACCOUNT_NAME,
> ORAFINAR.CUSTOMER_TRX_ID,
> ORAFINAR.DESCRIPTION,
> ORAFINAR.DOCUMENT_NUMBER,
> ORAFINAR.DOCUMENT_NUMBER_SEQUENCE_ID,
> ORAFINAR.EXCEPTION_ID,
> ORAFINAR.EXEMPTION_ID,
> ORAFINAR.FOB_POINT,
> ORAFINAR.GL_DATE,
> ORAFINAR.HEADER_ATTRIBUTE_CATEGORY,
> ORAFINAR.HEADER_ATTRIBUTE1,
> ORAFINAR.HEADER_ATTRIBUTE2,
> ORAFINAR.HEADER_ATTRIBUTE3,
> ORAFINAR.HEADER_ATTRIBUTE4,
> ORAFINAR.HEADER_ATTRIBUTE5,
> ORAFINAR.HEADER_ATTRIBUTE6,
> ORAFINAR.HEADER_ATTRIBUTE7,
> ORAFINAR.HEADER_ATTRIBUTE8,
> ORAFINAR.HEADER_ATTRIBUTE9,
> ORAFINAR.HEADER_ATTRIBUTE10,
> ORAFINAR.HEADER_ATTRIBUTE11,
> ORAFINAR.HEADER_ATTRIBUTE12,
> ORAFINAR.HEADER_ATTRIBUTE13,
> ORAFINAR.HEADER_ATTRIBUTE14,
> ORAFINAR.HEADER_ATTRIBUTE15,
> ORAFINAR.HEADER_GDF_ATTR_CATEGORY,
> ORAFINAR.HEADER_GDF_ATTRIBUTE1,
> ORAFINAR.HEADER_GDF_ATTRIBUTE2,
> ORAFINAR.HEADER_GDF_ATTRIBUTE3,
> ORAFINAR.HEADER_GDF_ATTRIBUTE4,
> ORAFINAR.HEADER_GDF_ATTRIBUTE5,
> ORAFINAR.HEADER_GDF_ATTRIBUTE6,
> ORAFINAR.HEADER_GDF_ATTRIBUTE7,
> ORAFINAR.HEADER_GDF_ATTRIBUTE8,
> ORAFINAR.HEADER_GDF_ATTRIBUTE9,
> ORAFINAR.HEADER_GDF_ATTRIBUTE10,
> ORAFINAR.HEADER_GDF_ATTRIBUTE11,
> ORAFINAR.HEADER_GDF_ATTRIBUTE12,
> ORAFINAR.HEADER_GDF_ATTRIBUTE13,
> ORAFINAR.HEADER_GDF_ATTRIBUTE14,
> ORAFINAR.HEADER_GDF_ATTRIBUTE15,
> ORAFINAR.HEADER_GDF_ATTRIBUTE16,
> ORAFINAR.HEADER_GDF_ATTRIBUTE17,
> ORAFINAR.HEADER_GDF_ATTRIBUTE18,
> ORAFINAR.HEADER_GDF_ATTRIBUTE19,
> ORAFINAR.HEADER_GDF_ATTRIBUTE20,
> ORAFINAR.HEADER_GDF_ATTRIBUTE21,
> ORAFINAR.HEADER_GDF_ATTRIBUTE22,
> ORAFINAR.HEADER_GDF_ATTRIBUTE23,
> ORAFINAR.HEADER_GDF_ATTRIBUTE24,
> ORAFINAR.HEADER_GDF_ATTRIBUTE25,
> ORAFINAR.HEADER_GDF_ATTRIBUTE26,
> ORAFINAR.HEADER_GDF_ATTRIBUTE27,
> ORAFINAR.HEADER_GDF_ATTRIBUTE28,
> ORAFINAR.HEADER_GDF_ATTRIBUTE29,
> ORAFINAR.HEADER_GDF_ATTRIBUTE30,
> ORAFINAR.INITIAL_CUSTOMER_TRX_ID,
> ORAFINAR.INTERFACE_LINE_ATTRIBUTE1,
> ORAFINAR.INTERFACE_LINE_ATTRIBUTE2,
> ORAFINAR.INTERFACE_LINE_ATTRIBUTE3,
> ORAFINAR.INTERFACE_LINE_ATTRIBUTE4,
> ORAFINAR.INTERFACE_LINE_ATTRIBUTE5,
> ORAFINAR.INTERFACE_LINE_ATTRIBUTE6,
> ORAFINAR.INTERFACE_LINE_ATTRIBUTE7,
> ORAFINAR.INTERFACE_LINE_ATTRIBUTE8,
> ORAFINAR.INTERFACE_LINE_ATTRIBUTE9,
> ORAFINAR.INTERFACE_LINE_ATTRIBUTE10,
> ORAFINAR.INTERFACE_LINE_ATTRIBUTE11,
> ORAFINAR.INTERFACE_LINE_ATTRIBUTE12,
> ORAFINAR.INTERFACE_LINE_ATTRIBUTE13,
> ORAFINAR.INTERFACE_LINE_ATTRIBUTE14,
> ORAFINAR.INTERFACE_LINE_ATTRIBUTE15,
> ORAFINAR.INTERFACE_LINE_CONTEXT,
> ORAFINAR.INTERFACE_LINE_ID,
> ORAFINAR.INTERFACE_STATUS,
> ORAFINAR.INTERNAL_NOTES,
> ORAFINAR.INVENTORY_ITEM_ID,
> ORAFINAR.INVOICING_RULE_ID,
> ORAFINAR.INVOICING_RULE_NAME,
> ORAFINAR.LAST_PERIOD_TO_CREDIT,
> ORAFINAR.LAST_UPDATE_DATE,
> ORAFINAR.LAST_UPDATE_LOGIN,
> ORAFINAR.LAST_UPDATED_BY,
> ORAFINAR.LINE_GDF_ATTR_CATEGORY,
> ORAFINAR.LINE_GDF_ATTRIBUTE1,
> ORAFINAR.LINE_GDF_ATTRIBUTE2,
> ORAFINAR.LINE_GDF_ATTRIBUTE3,
> ORAFINAR.LINE_GDF_ATTRIBUTE4,
> ORAFINAR.LINE_GDF_ATTRIBUTE5,
> ORAFINAR.LINE_GDF_ATTRIBUTE6,
> ORAFINAR.LINE_GDF_ATTRIBUTE7,
> ORAFINAR.LINE_GDF_ATTRIBUTE8,
> ORAFINAR.LINE_GDF_ATTRIBUTE9,
> ORAFINAR.LINE_GDF_ATTRIBUTE10,
> ORAFINAR.LINE_GDF_ATTRIBUTE11,
> ORAFINAR.LINE_GDF_ATTRIBUTE12,
> ORAFINAR.LINE_GDF_ATTRIBUTE13,
> ORAFINAR.LINE_GDF_ATTRIBUTE14,
> ORAFINAR.LINE_GDF_ATTRIBUTE15,
> ORAFINAR.LINE_GDF_ATTRIBUTE16,
> ORAFINAR.LINE_GDF_ATTRIBUTE17,
> ORAFINAR.LINE_GDF_ATTRIBUTE18,
> ORAFINAR.LINE_GDF_ATTRIBUTE19,
> ORAFINAR.LINE_GDF_ATTRIBUTE20,
> ORAFINAR.LINE_NUMBER,
> ORAFINAR.LINE_TYPE,
> ORAFINAR.LINK_TO_LINE_ATTRIBUTE1,
> ORAFINAR.LINK_TO_LINE_ATTRIBUTE2,
> ORAFINAR.LINK_TO_LINE_ATTRIBUTE3,
> ORAFINAR.LINK_TO_LINE_ATTRIBUTE4,
> ORAFINAR.LINK_TO_LINE_ATTRIBUTE5,
> ORAFINAR.LINK_TO_LINE_ATTRIBUTE6,
> ORAFINAR.LINK_TO_LINE_ATTRIBUTE7,
> ORAFINAR.LINK_TO_LINE_ATTRIBUTE8,
> ORAFINAR.LINK_TO_LINE_ATTRIBUTE9,
> ORAFINAR.LINK_TO_LINE_ATTRIBUTE10,
> ORAFINAR.LINK_TO_LINE_ATTRIBUTE11,
> ORAFINAR.LINK_TO_LINE_ATTRIBUTE12,
> ORAFINAR.LINK_TO_LINE_ATTRIBUTE13,
> ORAFINAR.LINK_TO_LINE_ATTRIBUTE14,
> ORAFINAR.LINK_TO_LINE_ATTRIBUTE15,
> ORAFINAR.LINK_TO_LINE_CONTEXT,
> ORAFINAR.LINK_TO_LINE_ID,
> ORAFINAR.LOCATION_SEGMENT_ID,
> ORAFINAR.MEMO_LINE_ID,
> ORAFINAR.MEMO_LINE_NAME,
> ORAFINAR.MOVEMENT_ID,
> ORAFINAR.MTL_SYSTEM_ITEMS_SEG1,
> ORAFINAR.MTL_SYSTEM_ITEMS_SEG2,
> ORAFINAR.MTL_SYSTEM_ITEMS_SEG3,
> ORAFINAR.MTL_SYSTEM_ITEMS_SEG4,
> ORAFINAR.MTL_SYSTEM_ITEMS_SEG5,
> ORAFINAR.MTL_SYSTEM_ITEMS_SEG6,
> ORAFINAR.MTL_SYSTEM_ITEMS_SEG7,
> ORAFINAR.MTL_SYSTEM_ITEMS_SEG8,
> ORAFINAR.MTL_SYSTEM_ITEMS_SEG9,
> ORAFINAR.MTL_SYSTEM_ITEMS_SEG10,
> ORAFINAR.MTL_SYSTEM_ITEMS_SEG11,
> ORAFINAR.MTL_SYSTEM_ITEMS_SEG12,
> ORAFINAR.MTL_SYSTEM_ITEMS_SEG13,
> ORAFINAR.MTL_SYSTEM_ITEMS_SEG14,
> ORAFINAR.MTL_SYSTEM_ITEMS_SEG15,
> ORAFINAR.MTL_SYSTEM_ITEMS_SEG16,
> ORAFINAR.MTL_SYSTEM_ITEMS_SEG17,
> ORAFINAR.MTL_SYSTEM_ITEMS_SEG18,
> ORAFINAR.MTL_SYSTEM_ITEMS_SEG19,
> ORAFINAR.MTL_SYSTEM_ITEMS_SEG20,
> ORAFINAR.ORG_ID,
> ORAFINAR.ORIG_SYSTEM_BATCH_NAME,
> ORAFINAR.ORIG_SYSTEM_BILL_ADDRESS_ID,
> ORAFINAR.ORIG_SYSTEM_BILL_ADDRESS_REF,
> ORAFINAR.ORIG_SYSTEM_BILL_CONTACT_ID,
> ORAFINAR.ORIG_SYSTEM_BILL_CONTACT_REF,
> ORAFINAR.ORIG_SYSTEM_BILL_CUSTOMER_ID,
> ORAFINAR.ORIG_SYSTEM_BILL_CUSTOMER_REF,
> ORAFINAR.ORIG_SYSTEM_SHIP_ADDRESS_ID,
> ORAFINAR.ORIG_SYSTEM_SHIP_ADDRESS_REF,
> ORAFINAR.ORIG_SYSTEM_SHIP_CONTACT_ID,
> ORAFINAR.ORIG_SYSTEM_SHIP_CONTACT_REF,
> ORAFINAR.ORIG_SYSTEM_SHIP_CUSTOMER_ID,
> ORAFINAR.ORIG_SYSTEM_SHIP_CUSTOMER_REF,
> ORAFINAR.ORIG_SYSTEM_SOLD_CUSTOMER_ID,
> ORAFINAR.ORIG_SYSTEM_SOLD_CUSTOMER_REF,
> ORAFINAR.PAYING_CUSTOMER_ID,
> ORAFINAR.PAYING_SITE_USE_ID,
> ORAFINAR.PAYMENT_SERVER_ORDER_NUM,
> ORAFINAR.PREVIOUS_CUSTOMER_TRX_ID,
> ORAFINAR.PRIMARY_SALESREP_ID,
> ORAFINAR.PRIMARY_SALESREP_NUMBER,
> ORAFINAR.PRINTING_OPTION,
> ORAFINAR.PURCHASE_ORDER,
> ORAFINAR.PURCHASE_ORDER_DATE,
> ORAFINAR.PURCHASE_ORDER_REVISION,
> ORAFINAR.QUANTITY,
> ORAFINAR.QUANTITY_ORDERED,
> ORAFINAR.REASON_CODE,
> ORAFINAR.REASON_CODE_MEANING,
> ORAFINAR.RECEIPT_METHOD_ID,
> ORAFINAR.RECEIPT_METHOD_NAME,
> ORAFINAR.REFERENCE_LINE_ATTRIBUTE1,
> ORAFINAR.REFERENCE_LINE_ATTRIBUTE2,
> ORAFINAR.REFERENCE_LINE_ATTRIBUTE3,
> ORAFINAR.REFERENCE_LINE_ATTRIBUTE4,
> ORAFINAR.REFERENCE_LINE_ATTRIBUTE5,
> ORAFINAR.REFERENCE_LINE_ATTRIBUTE6,
> ORAFINAR.REFERENCE_LINE_ATTRIBUTE7,
> ORAFINAR.REFERENCE_LINE_ATTRIBUTE8,
> ORAFINAR.REFERENCE_LINE_ATTRIBUTE9,
> ORAFINAR.REFERENCE_LINE_ATTRIBUTE10,
> ORAFINAR.REFERENCE_LINE_ATTRIBUTE11,
> ORAFINAR.REFERENCE_LINE_ATTRIBUTE12,
> ORAFINAR.REFERENCE_LINE_ATTRIBUTE13,
> ORAFINAR.REFERENCE_LINE_ATTRIBUTE14,
> ORAFINAR.REFERENCE_LINE_ATTRIBUTE15,
> ORAFINAR.REFERENCE_LINE_CONTEXT,
> ORAFINAR.REFERENCE_LINE_ID,
> ORAFINAR.RELATED_BATCH_SOURCE_NAME,
> ORAFINAR.RELATED_CUSTOMER_TRX_ID,
> ORAFINAR.RELATED_TRX_NUMBER,
> ORAFINAR.REQUEST_ID,
> ORAFINAR.RESET_TRX_DATE_FLAG,
> ORAFINAR.RULE_START_DATE,
> ORAFINAR.SALES_ORDER,
> ORAFINAR.SALES_ORDER_DATE,
> ORAFINAR.SALES_ORDER_LINE,
> ORAFINAR.SALES_ORDER_REVISION,
> ORAFINAR.SALES_ORDER_SOURCE,
> ORAFINAR.SALES_TAX_ID,
> ORAFINAR.SET_OF_BOOKS_ID,
> ORAFINAR.SHIP_DATE_ACTUAL,
> ORAFINAR.SHIP_VIA,
> ORAFINAR.TAX_CODE,
> ORAFINAR.TAX_EXEMPT_FLAG,
> ORAFINAR.TAX_EXEMPT_NUMBER,
> ORAFINAR.TAX_EXEMPT_REASON_CODE,
> ORAFINAR.TAX_EXEMPT_REASON_CODE_MEANING,
> ORAFINAR.TAX_PRECEDENCE,
> ORAFINAR.TAX_RATE,
> ORAFINAR.TERM_ID,
> ORAFINAR.TERM_NAME,
> ORAFINAR.TERRITORY_ID,
> ORAFINAR.TERRITORY_SEGMENT1,
> ORAFINAR.TERRITORY_SEGMENT2,
> ORAFINAR.TERRITORY_SEGMENT3,
> ORAFINAR.TERRITORY_SEGMENT4,
> ORAFINAR.TERRITORY_SEGMENT5,
> ORAFINAR.TERRITORY_SEGMENT6,
> ORAFINAR.TERRITORY_SEGMENT7,
> ORAFINAR.TERRITORY_SEGMENT8,
> ORAFINAR.TERRITORY_SEGMENT9,
> ORAFINAR.TERRITORY_SEGMENT10,
> ORAFINAR.TERRITORY_SEGMENT11,
> ORAFINAR.TERRITORY_SEGMENT12,
> ORAFINAR.TERRITORY_SEGMENT13,
> ORAFINAR.TERRITORY_SEGMENT14,
> ORAFINAR.TERRITORY_SEGMENT15,
> ORAFINAR.TERRITORY_SEGMENT16,
> ORAFINAR.TERRITORY_SEGMENT17,
> ORAFINAR.TERRITORY_SEGMENT18,
> ORAFINAR.TERRITORY_SEGMENT19,
> ORAFINAR.TERRITORY_SEGMENT20,
> ORAFINAR.TRANSLATED_DESCRIPTION,
> ORAFINAR.TRX_DATE,
> ORAFINAR.TRX_NUMBER,
> ORAFINAR.UNIT_SELLING_PRICE,
> ORAFINAR.UNIT_STANDARD_PRICE,
> ORAFINAR.UOM_CODE,
> ORAFINAR.UOM_NAME,
> ORAFINAR.USSGL_TRANSACTION_CODE,
> ORAFINAR.USSGL_TRANSACTION_CODE_CONTEXT,
> ORAFINAR.VAT_TAX_ID,
> ORAFINAR.WAREHOUSE_ID,
> ORAFINAR.WAYBILL_NUMBER
> ORDER BY ORAFINAR.ARID
>
>
>
> **********************************************************************
> Extracted table structure :
>
>
/*------------------------------------------------------------------------*/
> /* Table: ORAFINAR */
>
> CREATE TABLE ORAFINAR (
> ARID INTEGER NOT NULL,
> ACCOUNTING_RULE_DURATION VARCHAR (150),
> ACCOUNTING_RULE_ID VARCHAR (150),
> ACCOUNTING_RULE_NAME VARCHAR (150),
> ACCTD_AMOUNT VARCHAR (150),
> ADDRESS_VERIFICATION_CODE VARCHAR (150),
> AGREEMENT_ID VARCHAR (150),
> AGREEMENT_NAME VARCHAR (150),
> AMOUNT VARCHAR (150),
> AMOUNT_INCLUDE_TAX_FLAG VARCHAR (150),
> APPROVAL_CODE VARCHAR (150),
> ATTRIBUTE_CATEGORY VARCHAR (150),
> ATTRIBUTE1 VARCHAR (150),
> ATTRIBUTE2 VARCHAR (150),
> ATTRIBUTE3 VARCHAR (150),
> ATTRIBUTE4 VARCHAR (150),
> ATTRIBUTE5 VARCHAR (150),
> ATTRIBUTE6 VARCHAR (150),
> ATTRIBUTE7 VARCHAR (150),
> ATTRIBUTE8 VARCHAR (150),
> ATTRIBUTE9 VARCHAR (150),
> ATTRIBUTE10 VARCHAR (150),
> ATTRIBUTE11 VARCHAR (150),
> ATTRIBUTE12 VARCHAR (150),
> ATTRIBUTE13 VARCHAR (150),
> ATTRIBUTE14 VARCHAR (150),
> ATTRIBUTE15 VARCHAR (150),
> BATCH_SOURCE_NAME VARCHAR (150),
> COMMENTS VARCHAR (150),
> CONS_BILLING_NUMBER VARCHAR (150),
> CONVERSION_DATE VARCHAR (150),
> CONVERSION_RATE VARCHAR (150),
> CONVERSION_TYPE VARCHAR (150),
> CREATED_BY VARCHAR (150),
> CREATION_DATE VARCHAR (150),
> CREDIT_METHOD_FOR_ACCT_RULE VARCHAR (150),
> CREDIT_METHOD_FOR_INSTALLMENTS VARCHAR (150),
> CURRENCY_CODE VARCHAR (150),
> CUST_TRX_TYPE_ID VARCHAR (150),
> CUST_TRX_TYPE_NAME VARCHAR (150),
> CUSTOMER_BANK_ACCOUNT_ID VARCHAR (150),
> CUSTOMER_BANK_ACCOUNT_NAME VARCHAR (150),
> CUSTOMER_TRX_ID VARCHAR (150),
> DESCRIPTION VARCHAR (150),
> DOCUMENT_NUMBER VARCHAR (150),
> DOCUMENT_NUMBER_SEQUENCE_ID VARCHAR (150),
> EXCEPTION_ID VARCHAR (150),
> EXEMPTION_ID VARCHAR (150),
> FOB_POINT VARCHAR (150),
> GL_DATE VARCHAR (150),
> HEADER_ATTRIBUTE_CATEGORY VARCHAR (150),
> HEADER_ATTRIBUTE1 VARCHAR (150),
> HEADER_ATTRIBUTE2 VARCHAR (150),
> HEADER_ATTRIBUTE3 VARCHAR (150),
> HEADER_ATTRIBUTE4 VARCHAR (150),
> HEADER_ATTRIBUTE5 VARCHAR (150),
> HEADER_ATTRIBUTE6 VARCHAR (150),
> HEADER_ATTRIBUTE7 VARCHAR (150),
> HEADER_ATTRIBUTE8 VARCHAR (150),
> HEADER_ATTRIBUTE9 VARCHAR (150),
> HEADER_ATTRIBUTE10 VARCHAR (150),
> HEADER_ATTRIBUTE11 VARCHAR (150),
> HEADER_ATTRIBUTE12 VARCHAR (150),
> HEADER_ATTRIBUTE13 VARCHAR (150),
> HEADER_ATTRIBUTE14 VARCHAR (150),
> HEADER_ATTRIBUTE15 VARCHAR (150),
> HEADER_GDF_ATTR_CATEGORY VARCHAR (150),
> HEADER_GDF_ATTRIBUTE1 VARCHAR (150),
> HEADER_GDF_ATTRIBUTE2 VARCHAR (150),
> HEADER_GDF_ATTRIBUTE3 VARCHAR (150),
> HEADER_GDF_ATTRIBUTE4 VARCHAR (150),
> HEADER_GDF_ATTRIBUTE5 VARCHAR (150),
> HEADER_GDF_ATTRIBUTE6 VARCHAR (150),
> HEADER_GDF_ATTRIBUTE7 VARCHAR (150),
> HEADER_GDF_ATTRIBUTE8 VARCHAR (150),
> HEADER_GDF_ATTRIBUTE9 VARCHAR (150),
> HEADER_GDF_ATTRIBUTE10 VARCHAR (150),
> HEADER_GDF_ATTRIBUTE11 VARCHAR (150),
> HEADER_GDF_ATTRIBUTE12 VARCHAR (150),
> HEADER_GDF_ATTRIBUTE13 VARCHAR (150),
> HEADER_GDF_ATTRIBUTE14 VARCHAR (150),
> HEADER_GDF_ATTRIBUTE15 VARCHAR (150),
> HEADER_GDF_ATTRIBUTE16 VARCHAR (150),
> HEADER_GDF_ATTRIBUTE17 VARCHAR (150),
> HEADER_GDF_ATTRIBUTE18 VARCHAR (150),
> HEADER_GDF_ATTRIBUTE19 VARCHAR (150),
> HEADER_GDF_ATTRIBUTE20 VARCHAR (150),
> HEADER_GDF_ATTRIBUTE21 VARCHAR (150),
> HEADER_GDF_ATTRIBUTE22 VARCHAR (150),
> HEADER_GDF_ATTRIBUTE23 VARCHAR (150),
> HEADER_GDF_ATTRIBUTE24 VARCHAR (150),
> HEADER_GDF_ATTRIBUTE25 VARCHAR (150),
> HEADER_GDF_ATTRIBUTE26 VARCHAR (150),
> HEADER_GDF_ATTRIBUTE27 VARCHAR (150),
> HEADER_GDF_ATTRIBUTE28 VARCHAR (150),
> HEADER_GDF_ATTRIBUTE29 VARCHAR (150),
> HEADER_GDF_ATTRIBUTE30 VARCHAR (150),
> INITIAL_CUSTOMER_TRX_ID VARCHAR (150),
> INTERFACE_LINE_ATTRIBUTE1 VARCHAR (150),
> INTERFACE_LINE_ATTRIBUTE2 VARCHAR (150),
> INTERFACE_LINE_ATTRIBUTE3 VARCHAR (150),
> INTERFACE_LINE_ATTRIBUTE4 VARCHAR (150),
> INTERFACE_LINE_ATTRIBUTE5 VARCHAR (150),
> INTERFACE_LINE_ATTRIBUTE6 VARCHAR (150),
> INTERFACE_LINE_ATTRIBUTE7 VARCHAR (150),
> INTERFACE_LINE_ATTRIBUTE8 VARCHAR (150),
> INTERFACE_LINE_ATTRIBUTE9 VARCHAR (150),
> INTERFACE_LINE_ATTRIBUTE10 VARCHAR (150),
> INTERFACE_LINE_ATTRIBUTE11 VARCHAR (150),
> INTERFACE_LINE_ATTRIBUTE12 VARCHAR (150),
> INTERFACE_LINE_ATTRIBUTE13 VARCHAR (150),
> INTERFACE_LINE_ATTRIBUTE14 VARCHAR (150),
> INTERFACE_LINE_ATTRIBUTE15 VARCHAR (150),
> INTERFACE_LINE_CONTEXT VARCHAR (150),
> INTERFACE_LINE_ID VARCHAR (150),
> INTERFACE_STATUS VARCHAR (150),
> INTERNAL_NOTES VARCHAR (150),
> INVENTORY_ITEM_ID VARCHAR (150),
> INVOICING_RULE_ID VARCHAR (150),
> INVOICING_RULE_NAME VARCHAR (150),
> LAST_PERIOD_TO_CREDIT VARCHAR (150),
> LAST_UPDATE_DATE VARCHAR (150),
> LAST_UPDATE_LOGIN VARCHAR (150),
> LAST_UPDATED_BY VARCHAR (150),
> LINE_GDF_ATTR_CATEGORY VARCHAR (150),
> LINE_GDF_ATTRIBUTE1 VARCHAR (150),
> LINE_GDF_ATTRIBUTE2 VARCHAR (150),
> LINE_GDF_ATTRIBUTE3 VARCHAR (150),
> LINE_GDF_ATTRIBUTE4 VARCHAR (150),
> LINE_GDF_ATTRIBUTE5 VARCHAR (150),
> LINE_GDF_ATTRIBUTE6 VARCHAR (150),
> LINE_GDF_ATTRIBUTE7 VARCHAR (150),
> LINE_GDF_ATTRIBUTE8 VARCHAR (150),
> LINE_GDF_ATTRIBUTE9 VARCHAR (150),
> LINE_GDF_ATTRIBUTE10 VARCHAR (150),
> LINE_GDF_ATTRIBUTE11 VARCHAR (150),
> LINE_GDF_ATTRIBUTE12 VARCHAR (150),
> LINE_GDF_ATTRIBUTE13 VARCHAR (150),
> LINE_GDF_ATTRIBUTE14 VARCHAR (150),
> LINE_GDF_ATTRIBUTE15 VARCHAR (150),
> LINE_GDF_ATTRIBUTE16 VARCHAR (150),
> LINE_GDF_ATTRIBUTE17 VARCHAR (150),
> LINE_GDF_ATTRIBUTE18 VARCHAR (150),
> LINE_GDF_ATTRIBUTE19 VARCHAR (150),
> LINE_GDF_ATTRIBUTE20 VARCHAR (150),
> LINE_NUMBER VARCHAR (150),
> LINE_TYPE VARCHAR (150),
> LINK_TO_LINE_ATTRIBUTE1 VARCHAR (150),
> LINK_TO_LINE_ATTRIBUTE2 VARCHAR (150),
> LINK_TO_LINE_ATTRIBUTE3 VARCHAR (150),
> LINK_TO_LINE_ATTRIBUTE4 VARCHAR (150),
> LINK_TO_LINE_ATTRIBUTE5 VARCHAR (150),
> LINK_TO_LINE_ATTRIBUTE6 VARCHAR (150),
> LINK_TO_LINE_ATTRIBUTE7 VARCHAR (150),
> LINK_TO_LINE_ATTRIBUTE8 VARCHAR (150),
> LINK_TO_LINE_ATTRIBUTE9 VARCHAR (150),
> LINK_TO_LINE_ATTRIBUTE10 VARCHAR (150),
> LINK_TO_LINE_ATTRIBUTE11 VARCHAR (150),
> LINK_TO_LINE_ATTRIBUTE12 VARCHAR (150),
> LINK_TO_LINE_ATTRIBUTE13 VARCHAR (150),
> LINK_TO_LINE_ATTRIBUTE14 VARCHAR (150),
> LINK_TO_LINE_ATTRIBUTE15 VARCHAR (150),
> LINK_TO_LINE_CONTEXT VARCHAR (150),
> LINK_TO_LINE_ID VARCHAR (150),
> LOCATION_SEGMENT_ID VARCHAR (150),
> MEMO_LINE_ID VARCHAR (150),
> MEMO_LINE_NAME VARCHAR (150),
> MOVEMENT_ID VARCHAR (150),
> MTL_SYSTEM_ITEMS_SEG1 VARCHAR (150),
> MTL_SYSTEM_ITEMS_SEG2 VARCHAR (150),
> MTL_SYSTEM_ITEMS_SEG3 VARCHAR (150),
> MTL_SYSTEM_ITEMS_SEG4 VARCHAR (150),
> MTL_SYSTEM_ITEMS_SEG5 VARCHAR (150),
> MTL_SYSTEM_ITEMS_SEG6 VARCHAR (150),
> MTL_SYSTEM_ITEMS_SEG7 VARCHAR (150),
> MTL_SYSTEM_ITEMS_SEG8 VARCHAR (150),
> MTL_SYSTEM_ITEMS_SEG9 VARCHAR (150),
> MTL_SYSTEM_ITEMS_SEG10 VARCHAR (150),
> MTL_SYSTEM_ITEMS_SEG11 VARCHAR (150),
> MTL_SYSTEM_ITEMS_SEG12 VARCHAR (150),
> MTL_SYSTEM_ITEMS_SEG13 VARCHAR (150),
> MTL_SYSTEM_ITEMS_SEG14 VARCHAR (150),
> MTL_SYSTEM_ITEMS_SEG15 VARCHAR (150),
> MTL_SYSTEM_ITEMS_SEG16 VARCHAR (150),
> MTL_SYSTEM_ITEMS_SEG17 VARCHAR (150),
> MTL_SYSTEM_ITEMS_SEG18 VARCHAR (150),
> MTL_SYSTEM_ITEMS_SEG19 VARCHAR (150),
> MTL_SYSTEM_ITEMS_SEG20 VARCHAR (150),
> ORG_ID VARCHAR (150),
> ORIG_SYSTEM_BATCH_NAME VARCHAR (150),
> ORIG_SYSTEM_BILL_ADDRESS_ID VARCHAR (150),
> ORIG_SYSTEM_BILL_ADDRESS_REF VARCHAR (150),
> ORIG_SYSTEM_BILL_CONTACT_ID VARCHAR (150),
> ORIG_SYSTEM_BILL_CONTACT_REF VARCHAR (150),
> ORIG_SYSTEM_BILL_CUSTOMER_ID VARCHAR (150),
> ORIG_SYSTEM_BILL_CUSTOMER_REF VARCHAR (150),
> ORIG_SYSTEM_SHIP_ADDRESS_ID VARCHAR (150),
> ORIG_SYSTEM_SHIP_ADDRESS_REF VARCHAR (150),
> ORIG_SYSTEM_SHIP_CONTACT_ID VARCHAR (150),
> ORIG_SYSTEM_SHIP_CONTACT_REF VARCHAR (150),
> ORIG_SYSTEM_SHIP_CUSTOMER_ID VARCHAR (150),
> ORIG_SYSTEM_SHIP_CUSTOMER_REF VARCHAR (150),
> ORIG_SYSTEM_SOLD_CUSTOMER_ID VARCHAR (150),
> ORIG_SYSTEM_SOLD_CUSTOMER_REF VARCHAR (150),
> PAYING_CUSTOMER_ID VARCHAR (150),
> PAYING_SITE_USE_ID VARCHAR (150),
> PAYMENT_SERVER_ORDER_NUM VARCHAR (150),
> PREVIOUS_CUSTOMER_TRX_ID VARCHAR (150),
> PRIMARY_SALESREP_ID VARCHAR (150),
> PRIMARY_SALESREP_NUMBER VARCHAR (150),
> PRINTING_OPTION VARCHAR (150),
> PURCHASE_ORDER VARCHAR (150),
> PURCHASE_ORDER_DATE VARCHAR (150),
> PURCHASE_ORDER_REVISION VARCHAR (150),
> QUANTITY VARCHAR (150),
> QUANTITY_ORDERED VARCHAR (150),
> REASON_CODE VARCHAR (150),
> REASON_CODE_MEANING VARCHAR (150),
> RECEIPT_METHOD_ID VARCHAR (150),
> RECEIPT_METHOD_NAME VARCHAR (150),
> REFERENCE_LINE_ATTRIBUTE1 VARCHAR (150),
> REFERENCE_LINE_ATTRIBUTE2 VARCHAR (150),
> REFERENCE_LINE_ATTRIBUTE3 VARCHAR (150),
> REFERENCE_LINE_ATTRIBUTE4 VARCHAR (150),
> REFERENCE_LINE_ATTRIBUTE5 VARCHAR (150),
> REFERENCE_LINE_ATTRIBUTE6 VARCHAR (150),
> REFERENCE_LINE_ATTRIBUTE7 VARCHAR (150),
> REFERENCE_LINE_ATTRIBUTE8 VARCHAR (150),
> REFERENCE_LINE_ATTRIBUTE9 VARCHAR (150),
> REFERENCE_LINE_ATTRIBUTE10 VARCHAR (150),
> REFERENCE_LINE_ATTRIBUTE11 VARCHAR (150),
> REFERENCE_LINE_ATTRIBUTE12 VARCHAR (150),
> REFERENCE_LINE_ATTRIBUTE13 VARCHAR (150),
> REFERENCE_LINE_ATTRIBUTE14 VARCHAR (150),
> REFERENCE_LINE_ATTRIBUTE15 VARCHAR (150),
> REFERENCE_LINE_CONTEXT VARCHAR (150),
> REFERENCE_LINE_ID VARCHAR (150),
> RELATED_BATCH_SOURCE_NAME VARCHAR (150),
> RELATED_CUSTOMER_TRX_ID VARCHAR (150),
> RELATED_TRX_NUMBER VARCHAR (150),
> REQUEST_ID VARCHAR (150),
> RESET_TRX_DATE_FLAG VARCHAR (150),
> RULE_START_DATE VARCHAR (150),
> SALES_ORDER VARCHAR (150),
> SALES_ORDER_DATE VARCHAR (150),
> SALES_ORDER_LINE VARCHAR (150),
> SALES_ORDER_REVISION VARCHAR (150),
> SALES_ORDER_SOURCE VARCHAR (150),
> SALES_TAX_ID VARCHAR (150),
> SET_OF_BOOKS_ID VARCHAR (150),
> SHIP_DATE_ACTUAL VARCHAR (150),
> SHIP_VIA VARCHAR (150),
> TAX_CODE VARCHAR (150),
> TAX_EXEMPT_FLAG VARCHAR (150),
> TAX_EXEMPT_NUMBER VARCHAR (150),
> TAX_EXEMPT_REASON_CODE VARCHAR (150),
> TAX_EXEMPT_REASON_CODE_MEANING VARCHAR (150),
> TAX_PRECEDENCE VARCHAR (150),
> TAX_RATE VARCHAR (150),
> TERM_ID VARCHAR (150),
> TERM_NAME VARCHAR (150),
> TERRITORY_ID VARCHAR (150),
> TERRITORY_SEGMENT1 VARCHAR (150),
> TERRITORY_SEGMENT2 VARCHAR (150),
> TERRITORY_SEGMENT3 VARCHAR (150),
> TERRITORY_SEGMENT4 VARCHAR (150),
> TERRITORY_SEGMENT5 VARCHAR (150),
> TERRITORY_SEGMENT6 VARCHAR (150),
> TERRITORY_SEGMENT7 VARCHAR (150),
> TERRITORY_SEGMENT8 VARCHAR (150),
> TERRITORY_SEGMENT9 VARCHAR (150),
> TERRITORY_SEGMENT10 VARCHAR (150),
> TERRITORY_SEGMENT11 VARCHAR (150),
> TERRITORY_SEGMENT12 VARCHAR (150),
> TERRITORY_SEGMENT13 VARCHAR (150),
> TERRITORY_SEGMENT14 VARCHAR (150),
> TERRITORY_SEGMENT15 VARCHAR (150),
> TERRITORY_SEGMENT16 VARCHAR (150),
> TERRITORY_SEGMENT17 VARCHAR (150),
> TERRITORY_SEGMENT18 VARCHAR (150),
> TERRITORY_SEGMENT19 VARCHAR (150),
> TERRITORY_SEGMENT20 VARCHAR (150),
> TRANSLATED_DESCRIPTION VARCHAR (150),
> TRX_DATE VARCHAR (150),
> TRX_NUMBER VARCHAR (150),
> UNIT_SELLING_PRICE VARCHAR (150),
> UNIT_STANDARD_PRICE VARCHAR (150),
> UOM_CODE VARCHAR (150),
> UOM_NAME VARCHAR (150),
> USSGL_TRANSACTION_CODE VARCHAR (150),
> USSGL_TRANSACTION_CODE_CONTEXT VARCHAR (150),
> VAT_TAX_ID VARCHAR (150),
> WAREHOUSE_ID VARCHAR (150),
> WAYBILL_NUMBER VARCHAR (150));
>
>
>
> /* Unique keys definition */
>
> ALTER TABLE ORAFINAR ADD CONSTRAINT PK_ORAFINAR PRIMARY KEY (ARID);
>
>
>
/*------------------------------------------------------------------------*/
> /* Table: ORAFINARITEM */
>
> CREATE TABLE ORAFINARITEM (
> ARID INTEGER NOT NULL,
> GL_ITEM_ID INTEGER NOT NULL);
>
>
>
> /* Unique keys definition */
>
> ALTER TABLE ORAFINARITEM ADD CONSTRAINT PK_ORAFINARITEM PRIMARY KEY (ARID,
> GL_ITEM_ID);
>
>
> /* Foreign keys definition */
>
> ALTER TABLE ORAFINARITEM ADD CONSTRAINT FK_ORAFINAR_GLIARI_GL_ITEM
FOREIGN
> KEY (GL_ITEM_ID) REFERENCES GL_ITEM (GL_ITEM_ID);
> ALTER TABLE ORAFINARITEM ADD CONSTRAINT FK_ORAFINAR_OARARI_ORAFINAR
FOREIGN
> KEY (ARID) REFERENCES ORAFINAR (ARID);
>
>
/*------------------------------------------------------------------------*/
> /* Table: GL_AMOUNT */
>
> CREATE TABLE GL_AMOUNT (
> GL_ITEM_ID INTEGER NOT NULL,
> GL_MONTH VARCHAR (6) NOT NULL,
> AMOUNT DOUBLE PRECISION);
>
>
>
> /* Unique keys definition */
>
> ALTER TABLE GL_AMOUNT ADD PRIMARY KEY (GL_ITEM_ID, GL_MONTH);
>
>
> /* Indices definition */
>
> CREATE INDEX GLIGLA_FK3 ON GL_AMOUNT (GL_ITEM_ID);
>
>
>
>
>
>