IN_WTVOL_AET(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | DUMMY_FIELD | Character(1) | VARCHAR2(1) NOT NULL | Dummy Field for Hiding Groups |
| 3 | WT_VOL_OPTION | Character(1) | VARCHAR2(1) NOT NULL |
Weight and Volume Options
B=Weight and Volume V=Volume Only W=Weight Only |
| 4 | GET_LBS_CUF | Character(1) | VARCHAR2(1) NOT NULL |
Get Pounds and Cubic Feet
B=Get Pounds and Cubic Feet C=Get Cubic Feet L=Get Pounds |
| 5 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 6 | RECNAME | Character(15) | VARCHAR2(15) NOT NULL | Record (Table) Name (see PSRECDEFN). |
| 7 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 8 | SETID_BU_ATTRIBUTE | Character(5) | VARCHAR2(5) NOT NULL | SetID BU Attributes |
| 9 | SETID_INV_ITEMS | Character(5) | VARCHAR2(5) NOT NULL | Inv Items SETID |
| 10 | SETID_ITEM_UOM | Character(5) | VARCHAR2(5) NOT NULL | SetID Item UOM |
| 11 | PERCENT_OR_STATIC | Character(1) | VARCHAR2(1) NOT NULL | Percent or Static |
| 12 | WHERE_CLAUSE | Character(254) | VARCHAR2(254) NOT NULL | Where Clause |
| 13 | UNIT_MEASURE_VOL | Character(3) | VARCHAR2(3) NOT NULL | Volume UOM |
| 14 | UNIT_MEASURE_WT | Character(3) | VARCHAR2(3) NOT NULL | Weight UOM |
| 15 | PERCENT_CLAUSE | Character(254) | VARCHAR2(254) NOT NULL | Where Clause |
| 16 | FINAL_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Final Bill Option |
| 17 | CHG_VALUE | Signed Number(17,2) | DECIMAL(15,2) NOT NULL |
Change value
Default Value: 0 |
| 18 | SIGN_ADJUSTER | Signed Number(2,0) | DECIMAL(1) NOT NULL | Used to adjust sign for AM trn |