SETIDPrompt Table: SETID_TBL
COST_ELEMENTATC=Addl Trans
COH=Con Ovhd
CON=Conversion
INB=Inbound
LND=Landed
MAT=Material
OTH=Other
OUB=Outbound
Y/N Table Edit
Default Value: N
CM_ELEMENT(SQL Table) |
Index Back |
|---|---|
Cost ElementsSXK 10/7/97 : Made Changes for Related Language Display |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Prompt Table: SETID_TBL |
| 2 | COST_ELEMENT |
Character(4) | VARCHAR2(4) NOT NULL | Cost Element |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 4 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |
| 5 | COST_CATEGORY | Character(3) | VARCHAR2(3) NOT NULL |
1/12/99 ebn CN#CM800-2.0 : Added Landed Cost translate value
ATC=Addl Trans COH=Con Ovhd CON=Conversion INB=Inbound LND=Landed MAT=Material OTH=Other OUB=Outbound |
| 6 | ALLOW_OVERRIDE_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Allow ChartField Overrides
Y/N Table Edit Default Value: N |