BUSINESS_UNITDISTR_TMPLEFFDTINTEGRATION_MODULE1=Purchasing/Payables
2=Inventory
3=Expenses
4=Project Costing
Default Value: 1
RSRC_TYPE1=Labor
2=Tools
3=Material
A=Amount
Q=Quantity
Prompt Table: CM_DISTR_TYPE
WM_DIST_TMPL_MD(SQL Table) |
Index Back |
|---|---|
Distribution Template Eff Dt |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | DISTR_TMPL |
Character(10) | VARCHAR2(10) NOT NULL | Distribution Template Field |
| 3 | EFFDT |
Date(10) | DATE | Effective Date |
| 4 | INTEGRATION_MODULE |
Character(1) | VARCHAR2(1) NOT NULL |
This field is used to define integration modules that a product integrates with. This field has translate values.
1=Purchasing/Payables 2=Inventory 3=Expenses 4=Project Costing Default Value: 1 |
| 5 | RSRC_TYPE |
Character(1) | VARCHAR2(1) NOT NULL |
Work Order Management Resource Types
1=Labor 2=Tools 3=Material |
| 6 | LAST_SEQ_NUM | Number(5,0) | INTEGER NOT NULL | Last Sequence Number |
| 7 | DISTRIB_MTHD_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Distribute by
A=Amount Q=Quantity |
| 8 | TRANSACTION_GROUP | Character(3) | VARCHAR2(3) NOT NULL | 11/7/02 LLR - Added the new (600's) transactions groups for 8.8. |
| 9 | DISTRIB_TYPE | Character(10) | VARCHAR2(10) NOT NULL |
Distrib. Type
Prompt Table: CM_DISTR_TYPE |