VIEW: AR.RA_CUST_TRX_TYPES_ALL#

Source

View Text - Preformatted

select CUST_TRX_TYPE_ID CUST_TRX_TYPE_ID, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, POST_TO_GL POST_TO_GL, ACCOUNTING_AFFECT_FLAG ACCOUNTING_AFFECT_FLAG, CREDIT_MEMO_TYPE_ID CREDIT_MEMO_TYPE_ID, STATUS STATUS, NAME NAME, DESCRIPTION DESCRIPTION, TYPE TYPE, DEFAULT_TERM DEFAULT_TERM, DEFAULT_PRINTING_OPTION DEFAULT_PRINTING_OPTION, DEFAULT_STATUS DEFAULT_STATUS, GL_ID_REV GL_ID_REV, GL_ID_FREIGHT GL_ID_FREIGHT, GL_ID_REC GL_ID_REC, SUBSEQUENT_TRX_TYPE_ID SUBSEQUENT_TRX_TYPE_ID, SET_OF_BOOKS_ID SET_OF_BOOKS_ID, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ALLOW_FREIGHT_FLAG ALLOW_FREIGHT_FLAG, ALLOW_OVERAPPLICATION_FLAG ALLOW_OVERAPPLICATION_FLAG, CREATION_SIGN CREATION_SIGN, END_DATE END_DATE, GL_ID_CLEARING GL_ID_CLEARING, GL_ID_TAX GL_ID_TAX, GL_ID_UNBILLED GL_ID_UNBILLED, GL_ID_UNEARNED GL_ID_UNEARNED, START_DATE START_DATE, TAX_CALCULATION_FLAG TAX_CALCULATION_FLAG, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, NATURAL_APPLICATION_ONLY_FLAG NATURAL_APPLICATION_ONLY_FLAG, ORG_ID ORG_ID, GLOBAL_ATTRIBUTE1 GLOBAL_ATTRIBUTE1, GLOBAL_ATTRIBUTE2 GLOBAL_ATTRIBUTE2, GLOBAL_ATTRIBUTE3 GLOBAL_ATTRIBUTE3, GLOBAL_ATTRIBUTE4 GLOBAL_ATTRIBUTE4, GLOBAL_ATTRIBUTE5 GLOBAL_ATTRIBUTE5, GLOBAL_ATTRIBUTE6 GLOBAL_ATTRIBUTE6, GLOBAL_ATTRIBUTE7 GLOBAL_ATTRIBUTE7, GLOBAL_ATTRIBUTE8 GLOBAL_ATTRIBUTE8, GLOBAL_ATTRIBUTE9 GLOBAL_ATTRIBUTE9, GLOBAL_ATTRIBUTE10 GLOBAL_ATTRIBUTE10, GLOBAL_ATTRIBUTE11 GLOBAL_ATTRIBUTE11, GLOBAL_ATTRIBUTE12 GLOBAL_ATTRIBUTE12, GLOBAL_ATTRIBUTE13 GLOBAL_ATTRIBUTE13, GLOBAL_ATTRIBUTE14 GLOBAL_ATTRIBUTE14, GLOBAL_ATTRIBUTE15 GLOBAL_ATTRIBUTE15, GLOBAL_ATTRIBUTE16 GLOBAL_ATTRIBUTE16, GLOBAL_ATTRIBUTE17 GLOBAL_ATTRIBUTE17, GLOBAL_ATTRIBUTE18 GLOBAL_ATTRIBUTE18, GLOBAL_ATTRIBUTE19 GLOBAL_ATTRIBUTE19, GLOBAL_ATTRIBUTE20 GLOBAL_ATTRIBUTE20, GLOBAL_ATTRIBUTE_CATEGORY GLOBAL_ATTRIBUTE_CATEGORY, RULE_SET_ID RULE_SET_ID, SIGNED_FLAG SIGNED_FLAG, DRAWEE_ISSUED_FLAG DRAWEE_ISSUED_FLAG, MAGNETIC_FORMAT_CODE MAGNETIC_FORMAT_CODE, FORMAT_PROGRAM_ID FORMAT_PROGRAM_ID, GL_ID_UNPAID_REC GL_ID_UNPAID_REC, GL_ID_REMITTANCE GL_ID_REMITTANCE, GL_ID_FACTOR GL_ID_FACTOR, ALLOCATE_TAX_FREIGHT ALLOCATE_TAX_FREIGHT, LEGAL_ENTITY_ID LEGAL_ENTITY_ID, EXCLUDE_FROM_LATE_CHARGES EXCLUDE_FROM_LATE_CHARGES, ADJ_POST_TO_GL ADJ_POST_TO_GL, ZD_EDITION_NAME ZD_EDITION_NAME from "AR"."RA_CUST_TRX_TYPES_ALL"

View Text - HTML Formatted

SELECT CUST_TRX_TYPE_ID CUST_TRX_TYPE_ID
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, POST_TO_GL POST_TO_GL
, ACCOUNTING_AFFECT_FLAG ACCOUNTING_AFFECT_FLAG
, CREDIT_MEMO_TYPE_ID CREDIT_MEMO_TYPE_ID
, STATUS STATUS
, NAME NAME
, DESCRIPTION DESCRIPTION
, TYPE TYPE
, DEFAULT_TERM DEFAULT_TERM
, DEFAULT_PRINTING_OPTION DEFAULT_PRINTING_OPTION
, DEFAULT_STATUS DEFAULT_STATUS
, GL_ID_REV GL_ID_REV
, GL_ID_FREIGHT GL_ID_FREIGHT
, GL_ID_REC GL_ID_REC
, SUBSEQUENT_TRX_TYPE_ID SUBSEQUENT_TRX_TYPE_ID
, SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ALLOW_FREIGHT_FLAG ALLOW_FREIGHT_FLAG
, ALLOW_OVERAPPLICATION_FLAG ALLOW_OVERAPPLICATION_FLAG
, CREATION_SIGN CREATION_SIGN
, END_DATE END_DATE
, GL_ID_CLEARING GL_ID_CLEARING
, GL_ID_TAX GL_ID_TAX
, GL_ID_UNBILLED GL_ID_UNBILLED
, GL_ID_UNEARNED GL_ID_UNEARNED
, START_DATE START_DATE
, TAX_CALCULATION_FLAG TAX_CALCULATION_FLAG
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, NATURAL_APPLICATION_ONLY_FLAG NATURAL_APPLICATION_ONLY_FLAG
, ORG_ID ORG_ID
, GLOBAL_ATTRIBUTE1 GLOBAL_ATTRIBUTE1
, GLOBAL_ATTRIBUTE2 GLOBAL_ATTRIBUTE2
, GLOBAL_ATTRIBUTE3 GLOBAL_ATTRIBUTE3
, GLOBAL_ATTRIBUTE4 GLOBAL_ATTRIBUTE4
, GLOBAL_ATTRIBUTE5 GLOBAL_ATTRIBUTE5
, GLOBAL_ATTRIBUTE6 GLOBAL_ATTRIBUTE6
, GLOBAL_ATTRIBUTE7 GLOBAL_ATTRIBUTE7
, GLOBAL_ATTRIBUTE8 GLOBAL_ATTRIBUTE8
, GLOBAL_ATTRIBUTE9 GLOBAL_ATTRIBUTE9
, GLOBAL_ATTRIBUTE10 GLOBAL_ATTRIBUTE10
, GLOBAL_ATTRIBUTE11 GLOBAL_ATTRIBUTE11
, GLOBAL_ATTRIBUTE12 GLOBAL_ATTRIBUTE12
, GLOBAL_ATTRIBUTE13 GLOBAL_ATTRIBUTE13
, GLOBAL_ATTRIBUTE14 GLOBAL_ATTRIBUTE14
, GLOBAL_ATTRIBUTE15 GLOBAL_ATTRIBUTE15
, GLOBAL_ATTRIBUTE16 GLOBAL_ATTRIBUTE16
, GLOBAL_ATTRIBUTE17 GLOBAL_ATTRIBUTE17
, GLOBAL_ATTRIBUTE18 GLOBAL_ATTRIBUTE18
, GLOBAL_ATTRIBUTE19 GLOBAL_ATTRIBUTE19
, GLOBAL_ATTRIBUTE20 GLOBAL_ATTRIBUTE20
, GLOBAL_ATTRIBUTE_CATEGORY GLOBAL_ATTRIBUTE_CATEGORY
, RULE_SET_ID RULE_SET_ID
, SIGNED_FLAG SIGNED_FLAG
, DRAWEE_ISSUED_FLAG DRAWEE_ISSUED_FLAG
, MAGNETIC_FORMAT_CODE MAGNETIC_FORMAT_CODE
, FORMAT_PROGRAM_ID FORMAT_PROGRAM_ID
, GL_ID_UNPAID_REC GL_ID_UNPAID_REC
, GL_ID_REMITTANCE GL_ID_REMITTANCE
, GL_ID_FACTOR GL_ID_FACTOR
, ALLOCATE_TAX_FREIGHT ALLOCATE_TAX_FREIGHT
, LEGAL_ENTITY_ID LEGAL_ENTITY_ID
, EXCLUDE_FROM_LATE_CHARGES EXCLUDE_FROM_LATE_CHARGES
, ADJ_POST_TO_GL ADJ_POST_TO_GL
, ZD_EDITION_NAME ZD_EDITION_NAME
FROM "AR"."RA_CUST_TRX_TYPES_ALL"