1. Tables and Views for Financials
  2. JL_BR_AR_REC_MET_ACCTS_EXT_R_V

JL_BR_AR_REC_MET_ACCTS_EXT_R_V

Details

  • Schema: FUSION

  • Object owner: JL

  • Object type: VIEW

Columns

Name

ORG_ID

JLBR_RECEIPT_METHOD_ID

JLBR_BANK_ACCT_USE_ID

JLBR_BILLS_UNDER_DISCNT_CCID

JLBR_DISCNT_ENDORSEMENT_CCID

JLBR_BANK_CHARGES_CCID

JLBR_FACTORING_CHARGES_CCID

JLBR_COLLCTN_ENDORSEMENT_CCID

JLBR_BILLS_UNDER_COLLCTN_CCID

REC_MET_ACCTS_EXT_ID

PRINT_COLL_DOC_FOR_CUST_FLAG

COLL_DOC_CUST_PRINT_PGM_ID

BANK_SERVICE_CODE

Query

SQL_Statement

SELECT

jlrecmet.ORG_ID ORG_ID,

jlrecmet.RECEIPT_METHOD_ID JLBR_RECEIPT_METHOD_ID,

jlrecmet.BANK_ACCT_USE_ID JLBR_BANK_ACCT_USE_ID,

jlrecmet.BILLS_DISCOUNT_CCID JLBR_BILLS_UNDER_DISCNT_CCID,

jlrecmet.DISC_ENDORSEMENT_CCID JLBR_DISCNT_ENDORSEMENT_CCID,

jlrecmet.BANK_CHARGES_CCID JLBR_BANK_CHARGES_CCID,

jlrecmet.FACTORING_INTEREST_CCID JLBR_FACTORING_CHARGES_CCID,

jlrecmet.COLL_ENDORSEMENT_CCID JLBR_COLLCTN_ENDORSEMENT_CCID,

jlrecmet.BILLS_COLLECTION_CCID JLBR_BILLS_UNDER_COLLCTN_CCID,

jlrecmet.REC_MET_ACCTS_EXT_ID REC_MET_ACCTS_EXT_ID,

jlrecmet.PRINT_COLL_DOC_FOR_CUST_FLAG PRINT_COLL_DOC_FOR_CUST_FLAG,

jlrecmet.COLL_DOC_CUST_PRINT_PGM_ID COLL_DOC_CUST_PRINT_PGM_ID,

jlrecmet.BANK_SERVICE_CODE BANK_SERVICE_CODE

FROM

JL_BR_AR_REC_MET_ACCTS_EXT jlrecmet