[Home] [Help] [Dependency Information]
Object Name: | IGSFV_PARTY_CHARGES |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | IGS.IGSFV_PARTY_CHARGES |
Subobject Name: | |
Status: | VALID |
A Business Intelligence System view
Contains details of charges for a person
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PARTY_IDENTIFIER | NUMBER | (15) | Yes | Party Identifier |
INVOICE_IDENTIFIER | NUMBER | (15) | Yes | Invoice identifier |
INVOICE_LINE_IDENTIFIER | NUMBER | (15) | Yes | Invoice line Identifier |
INVOICE_NUMBER | VARCHAR2 | (60) | Invoice number | |
INVOICE_LINE_NUMBER | NUMBER | (15) | Yes | Invoice line number |
_LA:TRANSACTION_TYPE | CHAR | (63) | Transaction type | |
INVOICE_CREATION_DATE | DATE | Yes | Invoice creation date | |
INVOICE_DESCRIPTION | VARCHAR2 | (240) | Invoice description | |
INVOICE_LINE_DESCRIPTION | VARCHAR2 | (240) | Invoice line description | |
INVOICE_AMOUNT | NUMBER | Invoice amount | ||
INVOICE_LINE_AMOUNT | NUMBER | Invoice line amount | ||
INVOICE_AMOUNT_DUE | NUMBER | Yes | Invoice amount due | |
CURRENCY_CODE | VARCHAR2 | (15) | Yes | This will always be local currency |
EXCHANGE_RATE | NUMBER | Should be 1 | ||
EFFECTIVE_DATE | DATE | Effective date | ||
FEE_CALENDAR_TYPE | VARCHAR2 | (10) | Yes | The Calendar Type for the Fee Period |
FEE_CAL_INST_SEQUENCE_NUMBER | NUMBER | (6) | Yes | The Calendar Instance for the Fee Period |
DEBIT_ACCOUNT_CODE | VARCHAR2 | (40) | Debit account string | |
CREDIT_ACCOUNT_CODE | VARCHAR2 | (40) | Credit account string | |
DEBIT_ACCOUNT_GL_CCID | NUMBER | (15) | Debit Accounting Flex field | |
CREDIT_ACCOUNT_GL_CCID | NUMBER | (15) | Credit Accounting Flex field | |
FEE_TYPE | VARCHAR2 | (10) | Yes | Fee type |
FEE_CATEGORY | VARCHAR2 | (10) | Fee category | |
BILL_NUMBER | VARCHAR2 | (50) | Bill number | |
BILL_DATE | DATE | Bill date | ||
INVOICE_LINE_GL_DATE | DATE | The General Ledger Date of the charge line record | ||
GL_POSTED_DATE | DATE | The Date on which the invoice line record is posted to the interface | ||
REVERSAL_GL_DATE | DATE | The date on which this invoice is reversed | ||
ERROR_STRING | VARCHAR2 | (1000) | Error string that is generated by Build accounts process when it fails to generate account code. | |
ERROR_ACCOUNT | VARCHAR2 | (1) | Error Account Flag. Default value is 'N'. | |
WAIVER_FLAG | VARCHAR2 | (1) | Waiver flag, if this Transaction is waived | |
WAIVER_REASON | VARCHAR2 | (240) | Waiver reason, if this Transaction is waived | |
BILL_PAYMENT_DUE_DATE | DATE | This field would be updated by the Bill Process | ||
OPTIONAL_FEE_FLAG | VARCHAR2 | (1) | Decline optional fee status | |
_LA:CHARGE_METHOD | CHAR | (58) | Charge method type, if this is an assessment item | |
CHARGE_ELEMENTS | NUMBER | (7) | Number of charge elements, if this is an assessment item | |
EFTSU | NUMBER | (7) | Unit Effective Full Time Student Units | |
CREDIT_POINTS | NUMBER | (6) | Unit Credit Points | |
COURSE_CODE | VARCHAR2 | (6) | Program code | |
LOCATION_CODE | VARCHAR2 | (10) | The location to which the transaction belongs | |
ATTENDANCE_MODE | VARCHAR2 | (2) | Attendance mode | |
ATTENDANCE_TYPE | VARCHAR2 | (2) | Attendance Type | |
TAX_YEAR_CODE | VARCHAR2 | (30) | Indicates the calendar year, in which the charge is reported to the Internal Revenue Services | |
WAIVER_NAME | VARCHAR2 | (30) | Waiver Program Name attached to a Fee Calendar Instance for which waiver adjustment charge was created. | |
UNIT_ATTEMPT_STATUS | VARCHAR2 | (10) | Unit Attempt Status | |
ORG_UNIT_CODE | VARCHAR2 | (30) | Org unit code | |
PARTY_NUMBER | VARCHAR2 | (30) | Yes | Party number |
PARTY_NAME | VARCHAR2 | (360) | Yes | Party name |
DEBIT_ACC_DESCRIPTION | VARCHAR2 | (60) | Description of Debit Account | |
CREDIT_ACC_DESCRIPTION | VARCHAR2 | (60) | Description of Credit Account | |
_KF:ACCOUNT_NUMBER:DEBIT | CHAR | (18) | Debit Accounting Flex field | |
_KF:ACCOUNT_NUMBER:CREDIT | CHAR | (18) | Credit Accounting Flex field | |
BILL_CUT_OFF_DATE | DATE | The Cut Off Date until which the transactions were included in the Bill. | ||
POSTING_BATCH_NAME | VARCHAR2 | (30) | The Posting Batch Name - Can be used to locate a particular posting batch for subsequent processing | |
WAIVER_DESCRIPTION | VARCHAR2 | (240) | User defined description for waiver program | |
UNIT_PROGRAM_TYPE_LEVEL_CODE | VARCHAR2 | (10) | Unit Program Type Level Code | |
UNIT_PROGRAM_TYPE_LEVEL_DESC | VARCHAR2 | (80) | Unit Program Type Level Description | |
UNIT_LEVEL_DESC | VARCHAR2 | (60) | Unit Level Description | |
TAX_YEAR_NAME | VARCHAR2 | (30) | Indicates the 1098-T Reporting Tax Year, in which the charge is reported to the Internal Revenue Services | |
TAX_YEAR_EFFECTIVE_START_DATE | DATE | The 1098-T tax year effective start date. | ||
TAX_YEAR_EFFECTIVE_END_DATE | DATE | The 1098-T tax year effective end date. | ||
_DF | CHAR | (39) | Descriptive Flexfield | |
BILL_IDENTIFIER | NUMBER | Bill Identifier if this transaction is placed in any Bill | ||
UNIT_OFFER_OPTION_IDENTIFIER | NUMBER | (7) | The unit offering option to which the student is enrolled | |
POSTING_IDENTIFIER | NUMBER | (15) | Posting Identifier | |
POSTING_CONTROL_IDENTIFIER | NUMBER | (15) | The Posting Batch Identifier | |
UNIT_TYPE_IDENTIFIER | NUMBER | Unit Program Type Level Identifier | ||
UNIT_LEVEL_IDENTIFIER | VARCHAR2 | (10) | Unit Level Identifier | |
CREATED_BY | NUMBER | (15) | Yes | Standard Who column |
CREATION_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who column |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column |
Cut, paste (and edit) the following text to query this object:
SELECT PARTY_IDENTIFIER
, INVOICE_IDENTIFIER
, INVOICE_LINE_IDENTIFIER
, INVOICE_NUMBER
, INVOICE_LINE_NUMBER
, _LA:TRANSACTION_TYPE
, INVOICE_CREATION_DATE
, INVOICE_DESCRIPTION
, INVOICE_LINE_DESCRIPTION
, INVOICE_AMOUNT
, INVOICE_LINE_AMOUNT
, INVOICE_AMOUNT_DUE
, CURRENCY_CODE
, EXCHANGE_RATE
, EFFECTIVE_DATE
, FEE_CALENDAR_TYPE
, FEE_CAL_INST_SEQUENCE_NUMBER
, DEBIT_ACCOUNT_CODE
, CREDIT_ACCOUNT_CODE
, DEBIT_ACCOUNT_GL_CCID
, CREDIT_ACCOUNT_GL_CCID
, FEE_TYPE
, FEE_CATEGORY
, BILL_NUMBER
, BILL_DATE
, INVOICE_LINE_GL_DATE
, GL_POSTED_DATE
, REVERSAL_GL_DATE
, ERROR_STRING
, ERROR_ACCOUNT
, WAIVER_FLAG
, WAIVER_REASON
, BILL_PAYMENT_DUE_DATE
, OPTIONAL_FEE_FLAG
, _LA:CHARGE_METHOD
, CHARGE_ELEMENTS
, EFTSU
, CREDIT_POINTS
, COURSE_CODE
, LOCATION_CODE
, ATTENDANCE_MODE
, ATTENDANCE_TYPE
, TAX_YEAR_CODE
, WAIVER_NAME
, UNIT_ATTEMPT_STATUS
, ORG_UNIT_CODE
, PARTY_NUMBER
, PARTY_NAME
, DEBIT_ACC_DESCRIPTION
, CREDIT_ACC_DESCRIPTION
, _KF:ACCOUNT_NUMBER:DEBIT
, _KF:ACCOUNT_NUMBER:CREDIT
, BILL_CUT_OFF_DATE
, POSTING_BATCH_NAME
, WAIVER_DESCRIPTION
, UNIT_PROGRAM_TYPE_LEVEL_CODE
, UNIT_PROGRAM_TYPE_LEVEL_DESC
, UNIT_LEVEL_DESC
, TAX_YEAR_NAME
, TAX_YEAR_EFFECTIVE_START_DATE
, TAX_YEAR_EFFECTIVE_END_DATE
, _DF
, BILL_IDENTIFIER
, UNIT_OFFER_OPTION_IDENTIFIER
, POSTING_IDENTIFIER
, POSTING_CONTROL_IDENTIFIER
, UNIT_TYPE_IDENTIFIER
, UNIT_LEVEL_IDENTIFIER
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
FROM APPS.IGSFV_PARTY_CHARGES;
APPS.IGSFV_PARTY_CHARGES is not referenced by any database object
|
|
|