| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
PRE_INTFC_LINE_NUM |
Number(8,0) |
INTEGER NOT NULL |
Pre-Interface Line Number
|
| 3 |
DTTM_STAMP |
DateTime(26) |
TIMESTAMP |
Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
|
| 4 |
QUANTITY |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Qty Interface
|
| 5 |
COST |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Total Cost
|
| 6 |
TXN_COST |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Transaction Cost
|
| 7 |
MERCHANDISE_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Merchandise Amt
F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label
|
| 8 |
MERCH_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Base Merchandise Amount
|
| 9 |
DSCNT_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Discount Amount
|
| 10 |
DSCNT_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Base Discount Amount
|
| 11 |
CSD_NRCVRY_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Custom Duty NonRecovery Amount
|
| 12 |
CSD_NRCVRY_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Custom Duty NonRecovery Amount
|
| 13 |
CSD_RCVRY_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Custom Duty Recovery Amount
|
| 14 |
CSD_RCVRY_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Custom Duty Recovery Amount
|
| 15 |
EXD_NRCVRY_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Excise NonRcvry Amount
|
| 16 |
EXD_NRCVRY_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Excise Non Recovery
|
| 17 |
EXD_RCVRY_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Excise Recovery Amount
|
| 18 |
EXD_RCVRY_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Excise Recovery Amount
|
| 19 |
FREIGHT_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Freight Amount
|
| 20 |
FREIGHT_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Base Freight Amount
|
| 21 |
FREIGHT_AMT_NP |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Freight Amount
|
| 22 |
FREIGHT_AMT_NP_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Base Freight Amount
|
| 23 |
MISC_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Misc. Amount
|
| 24 |
MISC_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Base Misc. Amount
|
| 25 |
MISC_AMT_NP |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Misc. Amount
|
| 26 |
MISC_AMT_NP_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Base Misc. Amount
|
| 27 |
SALETX_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Sales Tax Amount
|
| 28 |
SALETX_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Base Sales Tax Amount
|
| 29 |
SALETX_AMT_NP |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Sales Tax Amount
|
| 30 |
SALETX_AMT_NP_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Base Sales Tax Amount
|
| 31 |
STX_NRCVRY_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Tax Nonrecovery
|
| 32 |
STX_NRCVRY_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Tx Amt NonRecovery in Bse Curr
|
| 33 |
STX_RCVRY_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Tax Recovery Amount
|
| 34 |
STX_RCVRY_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Tax Recovery Amt in Base Curr
|
| 35 |
USETAX_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Amount
|
| 36 |
USETAX_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Base Use Tax Amount
|
| 37 |
USETAX_AMT_NP |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Base Use Tax Amount
|
| 38 |
USETAX_AMT_NP_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Base Use Tax Amount
|
| 39 |
VAT_INV_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
VAT Invoice Amount
|
| 40 |
VAT_INV_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
VAT Invoice Amt Base Curr
|
| 41 |
VAT_RCVRY_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
VAT Recovery Amt
|
| 42 |
VAT_RCVRY_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
VAT Recovery Amt in Base Curr
|
| 43 |
VAT_NRCVR_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
VAT Non Recoverable
|
| 44 |
VAT_NRCVR_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
VAT NonRecoverable Amount
|