| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
ASSET_COUNT |
Number(5,0) |
INTEGER NOT NULL |
Count Work Field
|
| 3 |
UNIT_COST_REM4 |
Signed Number(28,4) |
DECIMAL(26,4) NOT NULL |
Total Cost
|
| 4 |
UNIT_MERC_BSE_REM4 |
Signed Number(28,4) |
DECIMAL(26,4) NOT NULL |
Base Merchandise Amount
|
| 5 |
UNIT_STX_BSE_REM4 |
Signed Number(28,4) |
DECIMAL(26,4) NOT NULL |
Base Sales Tax Amount
|
| 6 |
UNIT_UTX_BSE_REM4 |
Signed Number(28,4) |
DECIMAL(26,4) NOT NULL |
Base Use Tax Amount
|
| 7 |
UNIT_FRT_BSE_REM4 |
Signed Number(28,4) |
DECIMAL(26,4) NOT NULL |
Base Freight Amount
|
| 8 |
UNIT_VINV_BSE_REM4 |
Signed Number(28,4) |
DECIMAL(26,4) NOT NULL |
VAT Invoice Amt Base Curr
|
| 9 |
UNIT_VNR_BSE_REM4 |
Signed Number(28,4) |
DECIMAL(26,4) NOT NULL |
VAT NonRecoverable Amount
|
| 10 |
UNIT_VRC_BSE_REM4 |
Signed Number(28,4) |
DECIMAL(26,4) NOT NULL |
VAT Recovery Amt in Base Curr
|
| 11 |
UNIT_MISC_BSE_REM4 |
Signed Number(28,4) |
DECIMAL(26,4) NOT NULL |
Base Misc. Amount
|
| 12 |
UNIT_DSCN_BSE_REM4 |
Signed Number(28,4) |
DECIMAL(26,4) NOT NULL |
Base Discount Amount
|
| 13 |
UNIT_TXN_COST_REM4 |
Signed Number(28,4) |
DECIMAL(26,4) NOT NULL |
Transaction Cost
|
| 14 |
UNIT_MERC_REM4 |
Signed Number(28,4) |
DECIMAL(26,4) NOT NULL |
Merchandise Amt
|
| 15 |
UNIT_TXN_STX_REM4 |
Signed Number(28,4) |
DECIMAL(26,4) NOT NULL |
Sales Tax Amount
|
| 16 |
UNIT_TXN_UTX_REM4 |
Signed Number(28,4) |
DECIMAL(26,4) NOT NULL |
Amount
|
| 17 |
UNIT_TXN_FRT_REM4 |
Signed Number(28,4) |
DECIMAL(26,4) NOT NULL |
Freight Amount
|
| 18 |
UNIT_TXN_VINV_REM4 |
Signed Number(28,4) |
DECIMAL(26,4) NOT NULL |
VAT Invoice Amount
|
| 19 |
UNIT_TXN_VNR_REM4 |
Signed Number(28,4) |
DECIMAL(26,4) NOT NULL |
VAT Non Recoverable
|
| 20 |
UNIT_TXN_VRC_REM4 |
Signed Number(28,4) |
DECIMAL(26,4) NOT NULL |
VAT Recovery Amt
|
| 21 |
UNIT_TXN_MISC_REM4 |
Signed Number(28,4) |
DECIMAL(26,4) NOT NULL |
Misc. Amount
|
| 22 |
UNIT_TXN_DSCN_REM4 |
Signed Number(28,4) |
DECIMAL(26,4) NOT NULL |
Discount Amount
|
| 23 |
TOT_COST_REM2 |
Signed Number(28,4) |
DECIMAL(26,4) NOT NULL |
Total Cost
|
| 24 |
TOT_MERC_BSE_REM2 |
Signed Number(28,4) |
DECIMAL(26,4) NOT NULL |
Base Merchandise Amount
|
| 25 |
TOT_STX_BSE_REM2 |
Signed Number(28,4) |
DECIMAL(26,4) NOT NULL |
Base Sales Tax Amount
|
| 26 |
TOT_UTX_BSE_REM2 |
Signed Number(28,4) |
DECIMAL(26,4) NOT NULL |
Base Use Tax Amount
|
| 27 |
TOT_FRT_BSE_REM2 |
Signed Number(28,4) |
DECIMAL(26,4) NOT NULL |
Base Freight Amount
|
| 28 |
TOT_VINV_BSE_REM2 |
Signed Number(28,4) |
DECIMAL(26,4) NOT NULL |
VAT Invoice Amt Base Curr
|
| 29 |
TOT_VNR_BSE_REM2 |
Signed Number(28,4) |
DECIMAL(26,4) NOT NULL |
VAT NonRecoverable Amount
|
| 30 |
TOT_VRC_BSE_REM2 |
Signed Number(28,4) |
DECIMAL(26,4) NOT NULL |
VAT Recovery Amt in Base Curr
|
| 31 |
TOT_MISC_BSE_REM2 |
Signed Number(28,4) |
DECIMAL(26,4) NOT NULL |
Base Misc. Amount
|
| 32 |
TOT_DSCN_BSE_REM2 |
Signed Number(28,4) |
DECIMAL(26,4) NOT NULL |
Base Discount Amount
|
| 33 |
TOT_TXN_COST_REM2 |
Signed Number(28,4) |
DECIMAL(26,4) NOT NULL |
Transaction Cost
|
| 34 |
TOT_MERC_REM2 |
Signed Number(28,4) |
DECIMAL(26,4) NOT NULL |
Merchandise Amt
|
| 35 |
TOT_TXN_STX_REM2 |
Signed Number(28,4) |
DECIMAL(26,4) NOT NULL |
Sales Tax Amount
|
| 36 |
TOT_TXN_UTX_REM2 |
Signed Number(28,4) |
DECIMAL(26,4) NOT NULL |
Amount
|
| 37 |
TOT_TXN_FRT_REM2 |
Signed Number(28,4) |
DECIMAL(26,4) NOT NULL |
Freight Amount
|
| 38 |
TOT_TXN_VINV_REM2 |
Signed Number(28,4) |
DECIMAL(26,4) NOT NULL |
VAT Invoice Amount
|
| 39 |
TOT_TXN_VNR_REM2 |
Signed Number(28,4) |
DECIMAL(26,4) NOT NULL |
VAT Non Recoverable
|
| 40 |
TOT_TXN_VRC_REM2 |
Signed Number(28,4) |
DECIMAL(26,4) NOT NULL |
VAT Recovery Amt
|
| 41 |
TOT_TXN_MISC_REM2 |
Signed Number(28,4) |
DECIMAL(26,4) NOT NULL |
Misc. Amount
|
| 42 |
TOT_TXN_DSCN_REM2 |
Signed Number(28,4) |
DECIMAL(26,4) NOT NULL |
Discount Amount
|
| 43 |
BUCK_COST_REM |
Signed Number(28,4) |
DECIMAL(26,4) NOT NULL |
Total Cost
|
| 44 |
BUCK_MERC_BSE_REM |
Signed Number(28,4) |
DECIMAL(26,4) NOT NULL |
Base Merchandise Amount
|
| 45 |
BUCK_STX_BSE_REM |
Signed Number(28,4) |
DECIMAL(26,4) NOT NULL |
Base Sales Tax Amount
|
| 46 |
BUCK_UTX_BSE_REM |
Signed Number(28,4) |
DECIMAL(26,4) NOT NULL |
Base Use Tax Amount
|
| 47 |
BUCK_FRT_BSE_REM |
Signed Number(28,4) |
DECIMAL(26,4) NOT NULL |
Base Freight Amount
|
| 48 |
BUCK_VINV_BSE_REM |
Signed Number(28,4) |
DECIMAL(26,4) NOT NULL |
VAT Invoice Amt Base Curr
|
| 49 |
BUCK_VNR_BSE_REM |
Signed Number(28,4) |
DECIMAL(26,4) NOT NULL |
VAT NonRecoverable Amount
|
| 50 |
BUCK_VRC_BSE_REM |
Signed Number(28,4) |
DECIMAL(26,4) NOT NULL |
VAT Recovery Amt in Base Curr
|
| 51 |
BUCK_MISC_BSE_REM |
Signed Number(28,4) |
DECIMAL(26,4) NOT NULL |
Base Misc. Amount
|
| 52 |
BUCK_DSCN_BSE_REM |
Signed Number(28,4) |
DECIMAL(26,4) NOT NULL |
Base Discount Amount
|
| 53 |
BUCK_TXN_COST_REM |
Signed Number(28,4) |
DECIMAL(26,4) NOT NULL |
Transaction Cost
|
| 54 |
BUCK_MERC_REM |
Signed Number(28,4) |
DECIMAL(26,4) NOT NULL |
Merchandise Amt
|
| 55 |
BUCK_TXN_STX_REM |
Signed Number(28,4) |
DECIMAL(26,4) NOT NULL |
Sales Tax Amount
|
| 56 |
BUCK_TXN_UTX_REM |
Signed Number(28,4) |
DECIMAL(26,4) NOT NULL |
Amount
|
| 57 |
BUCK_TXN_FRT_REM |
Signed Number(28,4) |
DECIMAL(26,4) NOT NULL |
Freight Amount
|
| 58 |
BUCK_TXN_VINV_REM |
Signed Number(28,4) |
DECIMAL(26,4) NOT NULL |
VAT Invoice Amount
|
| 59 |
BUCK_TXN_VNR_REM |
Signed Number(28,4) |
DECIMAL(26,4) NOT NULL |
VAT Non Recoverable
|
| 60 |
BUCK_TXN_VRC_REM |
Signed Number(28,4) |
DECIMAL(26,4) NOT NULL |
VAT Recovery Amt
|
| 61 |
BUCK_TXN_MISC_REM |
Signed Number(28,4) |
DECIMAL(26,4) NOT NULL |
Misc. Amount
|
| 62 |
BUCK_TXN_DSCN_REM |
Signed Number(28,4) |
DECIMAL(26,4) NOT NULL |
Discount Amount
|