RBTOM_DST_TMP

(SQL Table)
Index Back

OMRBTINT TEMP TABLE

# 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 CUSTOMER_GROUP Character(10) VARCHAR2(10) NOT NULL Customer Group
9 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.
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 EFFDT Date(10) DATE Effective Date

Default Value: %date

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