TD_PROMO_CUS_TR(SQL Table) |
Index Back |
|---|---|
Promotion customer work recordThis table is used to display trees |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: PPRC_PROMO_TBL.SETID Prompt Table: SP_SETTD_NONVW |
| 2 | PPRC_PROMO_CD |
Character(20) | VARCHAR2(20) NOT NULL |
Price Promotion Code
Default Value: PPRC_PROMO_TBL.PPRC_PROMO_CD Prompt Table: PPRC_PROMO_TBL |
| 3 | TD_NODE_ID |
Character(8) | VARCHAR2(8) NOT NULL | Node ID |
| 4 | TD_SEQNO |
Number(15,4) | DECIMAL(14,4) NOT NULL | Sequence Number |
| 5 | 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.
Prompt Table: TD_CUST_OPRVW |
| 6 | TD_TREE_ID | Character(8) | VARCHAR2(8) NOT NULL |
Tree ID
Default Value: PPRC_PROMO_TBL.TD_TREE_ID_CUST Prompt Table: TD_TREE_HDR |
| 7 | EFFDT | Date(10) | DATE NOT NULL |
Effective Date
Default Value: PPRC_PROMO_TBL.EFFDT_CUST |
| 8 | TD_SELECTED_NODE | Character(1) | VARCHAR2(1) NOT NULL | Node Selected |