RCV_GAPLESS_INVOICE_NUMBERS

RCV_GAPLESS_INVOICE_NUMBERS hold the list of existing gapless invoice numbers that have already been created. The combination of PREFIX + BUYING_COMPANY_CODE + SELLING_COMPANY_CODE needs to be unique. The column NEXT_SEQUENCE_NUMBER is the next sequence number expected.

Details

• Schema: FUSION

• Object owner: RCV

• Object type: TABLE

• Tablespace: APPS_TS_TX_DATA

Primary Key

Name	Columns
RCV_GAPLESS_INVOICE_NUMBERS_PK	PREFIX, BUYING_COMPANY_CODE, SELLING_COMPANY_CODE, INVOICE_TYPE

Columns

Name	Datatype	Length	Precision	Not-null	Comments
PREFIX	VARCHAR2	3		Yes	Prefix that will be used in the invoice number.
BUYING_COMPANY_CODE	VARCHAR2	10		Yes	Buying company code that is associated with the legal entity.
SELLING_COMPANY_CODE	VARCHAR2	10		Yes	Selling company code that is associated with the legal entity.
INVOICE_TYPE	VARCHAR2	3		Yes	Invoice type for which the gapless invoice is being generated.
NEXT_SEQUENCE_NUMBER	NUMBER		18	Yes	Next Sequence Number for the gapless invoice number.
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.
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of the row.
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created the row.
LAST_UPDATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the last update of the row.
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.

Indexes

Index	Uniqueness	Tablespace	Columns
RCV_GAPLESS_INVOICE_NUMBERS_U1	Unique	Default	PREFIX, BUYING_COMPANY_CODE, SELLING_COMPANY_CODE, INVOICE_TYPE