VIEW: CN.CN_TRX_SALES_LINES_ALL#

Source

View Text - Preformatted

select ORG_ID ORG_ID, COLLECTION_RUN_ID COLLECTION_RUN_ID, TRANSFER_RUN_ID TRANSFER_RUN_ID, SALES_LINE_BATCH_ID SALES_LINE_BATCH_ID, SOURCE_TRX_SALES_LINE_ID SOURCE_TRX_SALES_LINE_ID, COL_SYSTEM_ID COL_SYSTEM_ID, COL_SYSTEM_TRX_SALES_LINE_ID COL_SYSTEM_TRX_SALES_LINE_ID, TRX_LINE_ID TRX_LINE_ID, TRX_ID TRX_ID, TRX_SALES_LINE_ID TRX_SALES_LINE_ID, SALES_LINE_STATUS SALES_LINE_STATUS, CLASSIFICATION_RUN_ID CLASSIFICATION_RUN_ID, ROLLUP_DATE ROLLUP_DATE, PROCESSED_DATE PROCESSED_DATE, ROLLUP_PERIOD_ID ROLLUP_PERIOD_ID, PROCESSED_PERIOD_ID PROCESSED_PERIOD_ID, SALESREP_ID SALESREP_ID, NON_REVENUE_AMOUNT_SPLIT NON_REVENUE_AMOUNT_SPLIT, REVENUE_AMOUNT_SPLIT REVENUE_AMOUNT_SPLIT, REV_NON_REV_FLAG REV_NON_REV_FLAG, COST_CENTER COST_CENTER, AMOUNT AMOUNT, QUANTITY QUANTITY, PROGRAM_ID PROGRAM_ID, SOURCE_PARENT_LINE_SALESREP_ID SOURCE_PARENT_LINE_SALESREP_ID, ORIG_LINE_SALESREP_ID ORIG_LINE_SALESREP_ID, NON_REVENUE_AMOUNT_PERCENT NON_REVENUE_AMOUNT_PERCENT, REVENUE_AMOUNT_PERCENT REVENUE_AMOUNT_PERCENT, REVENUE_CLASS_ID REVENUE_CLASS_ID, SOURCE_TRX_LINE_ID SOURCE_TRX_LINE_ID, SOURCE_TRX_ID SOURCE_TRX_ID, EVENT_ID EVENT_ID, TRX_TYPE TRX_TYPE, ADJUSTMENT_LINE_ID ADJUSTMENT_LINE_ID, ADJUSTMENT_HEADER_ID ADJUSTMENT_HEADER_ID, ADJUSTMENT_TRX_SALES_LINE_ID ADJUSTMENT_TRX_SALES_LINE_ID, ADJUSTMENT_STATUS_CODE ADJUSTMENT_STATUS_CODE, CLASSIFICATION_STATUS CLASSIFICATION_STATUS, ADJUSTMENT_FLAG ADJUSTMENT_FLAG, 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, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, SECURITY_GROUP_ID SECURITY_GROUP_ID, ADJ_COLLECTION_RUN_ID ADJ_COLLECTION_RUN_ID from "CN"."CN_TRX_SALES_LINES_ALL"

View Text - HTML Formatted

SELECT ORG_ID ORG_ID
, COLLECTION_RUN_ID COLLECTION_RUN_ID
, TRANSFER_RUN_ID TRANSFER_RUN_ID
, SALES_LINE_BATCH_ID SALES_LINE_BATCH_ID
, SOURCE_TRX_SALES_LINE_ID SOURCE_TRX_SALES_LINE_ID
, COL_SYSTEM_ID COL_SYSTEM_ID
, COL_SYSTEM_TRX_SALES_LINE_ID COL_SYSTEM_TRX_SALES_LINE_ID
, TRX_LINE_ID TRX_LINE_ID
, TRX_ID TRX_ID
, TRX_SALES_LINE_ID TRX_SALES_LINE_ID
, SALES_LINE_STATUS SALES_LINE_STATUS
, CLASSIFICATION_RUN_ID CLASSIFICATION_RUN_ID
, ROLLUP_DATE ROLLUP_DATE
, PROCESSED_DATE PROCESSED_DATE
, ROLLUP_PERIOD_ID ROLLUP_PERIOD_ID
, PROCESSED_PERIOD_ID PROCESSED_PERIOD_ID
, SALESREP_ID SALESREP_ID
, NON_REVENUE_AMOUNT_SPLIT NON_REVENUE_AMOUNT_SPLIT
, REVENUE_AMOUNT_SPLIT REVENUE_AMOUNT_SPLIT
, REV_NON_REV_FLAG REV_NON_REV_FLAG
, COST_CENTER COST_CENTER
, AMOUNT AMOUNT
, QUANTITY QUANTITY
, PROGRAM_ID PROGRAM_ID
, SOURCE_PARENT_LINE_SALESREP_ID SOURCE_PARENT_LINE_SALESREP_ID
, ORIG_LINE_SALESREP_ID ORIG_LINE_SALESREP_ID
, NON_REVENUE_AMOUNT_PERCENT NON_REVENUE_AMOUNT_PERCENT
, REVENUE_AMOUNT_PERCENT REVENUE_AMOUNT_PERCENT
, REVENUE_CLASS_ID REVENUE_CLASS_ID
, SOURCE_TRX_LINE_ID SOURCE_TRX_LINE_ID
, SOURCE_TRX_ID SOURCE_TRX_ID
, EVENT_ID EVENT_ID
, TRX_TYPE TRX_TYPE
, ADJUSTMENT_LINE_ID ADJUSTMENT_LINE_ID
, ADJUSTMENT_HEADER_ID ADJUSTMENT_HEADER_ID
, ADJUSTMENT_TRX_SALES_LINE_ID ADJUSTMENT_TRX_SALES_LINE_ID
, ADJUSTMENT_STATUS_CODE ADJUSTMENT_STATUS_CODE
, CLASSIFICATION_STATUS CLASSIFICATION_STATUS
, ADJUSTMENT_FLAG ADJUSTMENT_FLAG
, 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
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, SECURITY_GROUP_ID SECURITY_GROUP_ID
, ADJ_COLLECTION_RUN_ID ADJ_COLLECTION_RUN_ID
FROM "CN"."CN_TRX_SALES_LINES_ALL"