AR_BR_BATCH_GT

AR_BR_BATCH_GT is a global temporary table used to store transactions selected for bills receivable creation. The table also keeps track of the bills receivable applications against these transactions.

Details

• Schema: FUSION

• Object owner: AR

• Object type: TABLE

• Tablespace: Default

Columns

Name	Datatype	Length	Precision	Not-null	Comments
PAYMENT_SCHEDULE_ID	NUMBER		18	Yes	Payment schedule identifier of a transaction added to a bills receivable batch.
CUSTOMER_TRX_ID	NUMBER		18	Yes	Customer transaction identifier of a transaction added to a bills receivable batch.
CUST_TRX_TYPE_SEQ_ID	NUMBER		18	Yes	Customer transaction type sequence identifier of a transaction added to a bills receivable batch.
CUSTOMER_ID	NUMBER		18	Yes	Customer identifier of a transaction added to a bills receivable batch.
CUSTOMER_SITE_USE_ID	NUMBER		18	Yes	Customer site use identifier of a transaction added to a bills receivable batch.
TRX_NUMBER	VARCHAR2	30		Yes	Transaction number of a transaction added to a bills receivable batch.
DUE_DATE	DATE			Yes	Due date of a transaction added to a bills receivable batch.
AMOUNT_DUE_REMAINING	NUMBER				Remaining amount due on a transaction added to a bills receivable batch.
AMOUNT_ASSIGNED	NUMBER				Applied amount of a transaction added to a bills receivable batch.
EXCLUDE_FLAG	VARCHAR2	1			Option to exclude a transaction from bills receivable application.
IMMEDIATE_FLAG	VARCHAR2	1			Option to indicate that a transaction is assigned immediate payment terms.
ASSIGNED_FLAG	VARCHAR2	1			Option to indicate that a bill receivable is already applied to the transaction.

Indexes

Index	Uniqueness	Columns
AR_BR_BATCH_GT_N1	Non Unique	CUSTOMER_TRX_ID, AMOUNT_DUE_REMAINING