OMBI_DSTSET_TMP

(SQL Table)
Index Back

OMBILL temp table

This table is a working table for SQR OMBILL. It holds potential distribution sets for an invoice line.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
3 DST_RULE_CD Character(10) VARCHAR2(10) NOT NULL Dist Rule Code
4 SEQUENCE_NBR Number(2,0) SMALLINT NOT NULL Sequence Number
5 DISTRIB_SET_ID Character(10) VARCHAR2(10) NOT NULL Distribution Set ID
6 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID
7 PRODUCT_GROUP Character(10) VARCHAR2(10) NOT NULL Product Group
8 CUST_ID Character(15) VARCHAR2(15) NOT NULL Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.
9 CUSTOMER_GROUP Character(10) VARCHAR2(10) NOT NULL Customer Group
10 REGION_CD Character(10) VARCHAR2(10) NOT NULL Identifies the Sales Region. Populated on the Item Table to identify the Sales Region the Item is applied to.
11 ORDER_GRP Character(6) VARCHAR2(6) NOT NULL Order Group
12 BUSINESS_UNIT_IN Character(5) VARCHAR2(5) NOT NULL Inventory Unit
13 EFFDT Date(10) DATE Effective Date

Default Value: %date

14 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive