Table stores the accounting distributions for adjustments and few adjustment attributes
Module: Receivables
LINE_ID
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
---|---|---|---|---|---|---|---|
LINE_ID | NUMBER | 38 | 0 | True | Uniquely identifier for rows in this table - primarily when these rows are passed to General Ledger | ||
SOURCE_RECORD_ID | VARCHAR2 | 256 | Uniquely identifier for rows in this table - primarily when these rows are passed to General Ledger | ||||
SUBLEDGER_LINKAGE_DST_ENTITY_ID | VARCHAR2 | 256 | Subledger linkage distribution entity ID | ||||
CODE_COMBINATION_ID | NUMBER | 38 | 0 | Foreign key to GL_CODE_COMBINATIONS.CODE_COMBINATION_ID. It is the account to create the journals for. | |||
AMOUNT_DR | NUMBER | Distribution accounted debit amount. | |||||
AMOUNT_CR | NUMBER | Distribution accounted credit amount. | |||||
ACCTD_AMOUNT_DR | NUMBER | Journal entry accounted debit amount | |||||
ACCTD_AMOUNT_CR | NUMBER | Journal entry accounted credit amount | |||||
SOURCE_TYPE | VARCHAR2 | 32 | Account type of transaction for which distribution is posted. | ||||
FROM_AMOUNT_DR | NUMBER | Debit amount in the currency of the cash receipt | |||||
FROM_AMOUNT_CR | NUMBER | credit amount in the currency of the cash receipt | |||||
SOURCE_TABLE | VARCHAR2 | 32 | Possible values are CRH for the AR_CASH_RECEIPT_HISTORY_ALL table, RA for the AR_RECEIVABLE_APPLICATIONS_ALL table, ADJ for the AR_ADJUSTMENTS_ALL table, MCD for the AR_MISC_CASH_DISTRIBUTIONS_ALL table, or TH for the AR_TRANSACTION_HISTORY_ALL table. | ||||
SOURCE_ID | NUMBER | 38 | 0 | Identifier for record in SOURCE_TABLE that created this distribution. | |||
CURRENCY_CODE | VARCHAR2 | 32 | Code defined for a currency | ||||
CREATION_DATE | TIMESTAMP | Who column: indicates the date and time of the creation of the row. | |||||
LAST_UPDATE_DATE | TIMESTAMP | Who column: indicates the date and time of the last update of the row. | |||||
REF_CUST_TRX_LINE_GL_DIST_ID | NUMBER | 38 | 0 | transaction line distribution identifyer | |||
H_ADJUSTMENT_ID | NUMBER | 38 | 0 | Adjustment identifier | |||
H_ADJUSTMENT_NUMBER | VARCHAR2 | 128 | Adjustment number automatically generated from AR_ADJUSTMENT_NUMBER_S | ||||
H_COMMENTS | VARCHAR2 | 2048 | User-entered comments about the adjustment. | ||||
H_STATUS | VARCHAR2 | 128 | Approval status, A for approve, U for unaccrued adjustments, R for rejected, and any other code for unapproved | ||||
H_REASON_CODE | VARCHAR2 | 128 | Identifier of reason for this adjustment | ||||
H_ORG_ID | NUMBER | 38 | 0 | Indicates the identifier of the business unit associated to the row. | |||
H_GL_DATE | DATE | Accounting date | |||||
H_APPLY_DATE | DATE | Date adjustment applied to payment | |||||
H_TYPE | VARCHAR2 | 64 | Lookup code for adjustment type in AR_LOOKUPS | ||||
H_APPROVED_BY | VARCHAR2 | 128 | Identifier of user approving the adjustment | ||||
H_GL_POSTED_DATE | DATE | Date adjustment posted to General Ledger | |||||
H_PAYMENT_SCHEDULE_ID | NUMBER | 38 | 0 | Identifies the payment schedule | |||
H_CUSTOMER_TRX_ID | NUMBER | 38 | 0 | Transaction identifier. |