| Data element |
Definition |
ACCOUNT_CODE
Indexed - yes
Format - varchar2(20)
May be null? yes |
Account code to be charged with the amount. |
ACCOUNT_CODE_TYPE
Indexed - no
Format - char(1)
May be null? yes |
|
ALLOC_KEY
Indexed - yes
Format - number
May be null? yes |
Unique system-assigned key identifying an allocation record. |
AMOUNT
Indexed - no
Format - number
May be null? yes |
Amount to be posted. Negative amounts represent a credit; positive amounts represent a debit.. |
CA_KEY
Indexed - yes
Format - number
May be null? yes |
Unique system-assigned key that identifies a cash advance. |
DEBIT_OR_CREDIT
Indexed - no
Format - char(2)
May be null? yes |
Indicates whether the journal is a debit or credit transaction. |
ENTRY_TYPE
Indexed - no
Format - char(1)
May be null? yes |
|
EXTRACT_CCT_KEY
Indexed - yes
Format - number
May be null? yes |
|
JR_KEY
Indexed - yes
Format - number
May be null? yes |
Unique system-assigned key that identifies the journal entry. |
PAYEE_PAT_KEY
Indexed - yes
Format - char(4)
May be null? yes |
Unique system-assigned key that identifies the payment type representing the entity receiving the journal amount. |
PAYER_PAT_KEY
Indexed - yes
Format - char(4)
May be null? yes |
Unique system-assigned key that identifies the payment type representing the entity responsible for issuing the journal amount . |
RPE_KEY
Indexed - yes
Format - number
May be null? yes |
Unique system-assigned key that identifies the report entry from which the journal entry originates. |
RPJ_KEY
Indexed - yes
Format - number
May be null? no |
Unique system-assigned key that identifies the journal entry. |
RPT_KEY
Indexed - yes
Format - number
May be null? yes |
Unique system-assigned key that identifies the expense report from which the journal entry originates. |
