JL_BR_AR_RET_INTERFACE_EXT_ALL
This interface table contains erroneous bank return records.
Details
-
Schema: FUSION
-
Object owner: JL
-
Object type: TABLE
-
Tablespace: TRANSACTION_TABLES
Primary Key
Name | Columns |
---|---|
JL_BR_AR_RET_INTER_EXT_ALL_PK |
FILE_CONTROL, ENTRY_SEQUENTIAL_NUMBER |
Columns
Name | Datatype | Length | Precision | Not-null | Comments | Status |
---|---|---|---|---|---|---|
FILE_CONTROL | VARCHAR2 | 20 | Yes | Bank control file name received from the bank. | Active | |
ENTRY_SEQUENTIAL_NUMBER | NUMBER | 6 | Yes | Register sequence number on electronic file received from the bank. | Active | |
COMPANY_CODE | NUMBER | Company code provided by the bank at the time of contract for services associated with the remittance and return of a collection document. | Active | |||
COMPANY_NAME | VARCHAR2 | 80 | Company name of the first party associated with the company code provided by the bank. | Active | ||
GENERATION_DATE | DATE | Yes | Date on which the interface records were generated. | Active | ||
REMITTANCE_CODE | NUMBER | 1 | Yes | Bank remittance code in electronic file from the original line sent by the company. | Active | |
BANK_NUMBER | VARCHAR2 | 30 | Unique numeric identifier for a bank. | Active | ||
BANK_OCCURRENCE_CODE | VARCHAR2 | 30 | Yes | Occurrence code returned by the bank related to a bank occurrence. | Active | |
OCCURRENCE_DATE | DATE | Yes | Correction date for a bank occurrence received from the bank. | Active | ||
PROCESSING_DATE | DATE | Yes | Date on which the interface records were processed. | Active | ||
LAST_VALIDATION_DATE | DATE | Yes | Date on which the interface records were last validated. | Active | ||
INSCRIPTION_NUMBER | VARCHAR2 | 50 | Company registration number in electronic file received from the bank. | Active | ||
COMPANY_USE | NUMBER | Yes | Collection document unique identifier for matching purposes. | Active | ||
OUR_NUMBER | VARCHAR2 | 20 | Collection document identifier generated by the bank or the company responsible for the collection document printing. | Active | ||
PORTFOLIO_CODE | NUMBER | Portfolio code in electronic file received from the bank. | Active | |||
YOUR_NUMBER | VARCHAR2 | 46 | Collection document number related to the document given by the company. | Active | ||
DUE_DATE | DATE | Due date for a collection document received from the bank. | Active | |||
TRADE_NOTE_AMOUNT | NUMBER | Amount due remaining on a collection document received from the bank. | Active | |||
COLLECTOR_BANK_NUMBER | VARCHAR2 | 30 | Numeric identifier for collecting bank. | Active | ||
COLLECTOR_BRANCH_NUMBER | VARCHAR2 | 25 | Numeric identifier for collecting bank branch. | Active | ||
TRADE_NOTE_TYPE | VARCHAR2 | 3 | Oracle internal use only. | Active | ||
BANK_CHARGE_AMOUNT | NUMBER | No longer used. | Active | |||
ABATEMENT_AMOUNT | NUMBER | Abatement amount for a bank collection document received from the bank. | Active | |||
DISCOUNT_AMOUNT | NUMBER | Discount amount for a bank collection document received from the bank. | Active | |||
CREDIT_AMOUNT | NUMBER | Credit amount for a collection document received from the bank. | Active | |||
INTEREST_AMOUNT_RECEIVED | NUMBER | Paid interest amount for a collection document received from the bank. | Active | |||
CUSTOMER_NAME | VARCHAR2 | 50 | Customer name on a collection document received from the bank. | Active | ||
RETURN_INFO | VARCHAR2 | 50 | Return information comment on a bank occurrence. | Active | ||
BANK_USE | VARCHAR2 | 25 | Operation identifier by bank on electronic file received from the bank. | Active | ||
ERROR_CODE | VARCHAR2 | 30 | Validation interface error code. | Active | ||
CANCELLATION_CODE | VARCHAR2 | 1 | Code associated with the cancellation of a transaction. | Active | ||
ORG_ID | NUMBER | 18 | Indicates the identifier of the business unit associated to the row. | Active | ||
LAST_UPDATE_DATE | TIMESTAMP | Who column: indicates the date and time of the last update of the row. | Active | |||
LAST_UPDATED_BY | VARCHAR2 | 64 | Who column: indicates the user who last updated the row. | Active | ||
CREATION_DATE | TIMESTAMP | Who column: indicates the date and time of the creation of the row. | Active | |||
CREATED_BY | VARCHAR2 | 64 | Who column: indicates the user who created the row. | Active | ||
LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | Active | ||
BANK_PARTY_ID | NUMBER | 18 | Yes | Party identifier for the bank associated with the first party. | Active | |
COLLECTOR_BANK_PARTY_ID | NUMBER | 18 | Party identifier for collecting bank. | Active | ||
COLLECTOR_BRANCH_PARTY_ID | NUMBER | 18 | Party identifier for collecting bank branch. | Active | ||
OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | ||
PIX_QR_CODE_EMV | VARCHAR2 | 600 | QR Code in smart payment format returned by the bank that's associated with a collection document. | |||
PIX_QR_CODE_URL | VARCHAR2 | 120 | QR Code URL returned by the bank that's associated with a collection document. |
Foreign Keys
Table | Foreign Table | Foreign Key Column |
---|---|---|
JL_BR_AR_RET_INTERFACE_EXT_ALL | hz_parties | BANK_PARTY_ID |
JL_BR_AR_RET_INTERFACE_EXT_ALL | hz_parties | COLLECTOR_BANK_PARTY_ID |
JL_BR_AR_RET_INTERFACE_EXT_ALL | hz_parties | COLLECTOR_BRANCH_PARTY_ID |
Indexes
Index | Uniqueness | Tablespace | Columns | Status |
---|---|---|---|---|
JL_BR_AR_RET_INTERFACE_EXT_U1 | Unique | FUSION_TS_TX_DATA | FILE_CONTROL, ENTRY_SEQUENTIAL_NUMBER | Active |