TD_ALLOW_MASTER

(SQL Table)
Index Back

National allowance master

National allowance master table

# 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
Set Control Field: SETID

3 PROMO_GROUP Character(10) VARCHAR2(10) NOT NULL Promotional Group
4 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID
5 SHIP_UNIT_PL Number(16,4) DECIMAL(15,4) NOT NULL Planned Ship Qty
6 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage

Default Value: TD_SETID_TBL.UNIT_OF_MEASURE

Prompt Table: UNITS_TBL

7 TD_NODE_ID Character(8) VARCHAR2(8) NOT NULL Node ID
8 TD_TREE_ID Character(8) VARCHAR2(8) NOT NULL Tree ID

Default Value: PPRC_PROMO_TBL.TD_TREE_ID_PROD

Prompt Table: TD_TREE_HDR

9 EFFDT Date(10) DATE NOT NULL Effective Date

Default Value: PPRC_PROMO_TBL.TD_TREE_EFFDT_PROD

10 DESCR254_MIXED Character(254) VARCHAR2(254) NOT NULL Description