| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 SHEET_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Report ID
|
| 2 |
NONPREFMERCH_JUST |
Character(10) |
VARCHAR2(10) NOT NULL |
Non-Preferred Justification
Prompt Table:
EX_NONPREFMERCH
|
| 3 |
LINE_NBR |
Number(5,0) |
INTEGER NOT NULL |
Line Number:
11/24/08 - Added TARGET label [PC product]
Default Value: 1
|
| 4 |
TRANSPORT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Transportation ID
Prompt Table:
EX_EE_TRNSPT_VW
|
| 5 |
MOBILE_POPWKEY |
Character(50) |
VARCHAR2(50) NOT NULL |
Mobile Id
|
| 6 |
EX_LINE_STATUS |
Character(3) |
VARCHAR2(3) NOT NULL |
The Line Status of an Expenses transaction (i.e. Expense Report, Cash Advance, Travel Authorization, Time Report)
ADJ=Adjusted
APR=Approved
APY=Approved for Payment
CLS=Closed
DEN=Denied
DNA=Denied by Approver
DNC=Denied
DNU=Denied by Auditor
ESC=Escheated Payment
HDA=Hold by Approver
HDU=Hold by Auditor
HLD=Hold
MFS=Marked For Submit
OPN=Open
PAR=Approvals in Process
PD=Paid
PND=Pending
PRO=In Process
RAP=Approved
STG=Staged
SUB=Submitted
XML=Submitted, Pending Validation
Default Value: PND
|
| 7 |
SHEET_RCPT_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Receipt Number
|
| 8 |
SHEET_RCPT_TOTAL |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Total Local Amount
|
| 9 |
ARRIVAL_DATE |
Date(10) |
DATE |
Arrival Date
|
| 10 |
DEPARTURE_DATE |
Date(10) |
DATE |
Departure Date
|
| 11 |
EXPENSE_TYPE |
Character(7) |
VARCHAR2(7) NOT NULL |
Expense Type
Prompt Table:
EX_TYPES_PT_DVW
|
| 12 |
TRANS_DT |
Date(10) |
DATE |
Transaction Date
|
| 13 |
REIMBURSEMENT_CD |
Character(1) |
VARCHAR2(1) NOT NULL |
Deny
N=Nonreimburseable
P=Prepaid
R=Reimburseable
Default Value: R
|
| 14 |
PERSONAL_EXPENSE |
Character(1) |
VARCHAR2(1) NOT NULL |
Personal Expense
N=No
Y=Yes
Y/N Table Edit
Default Value: N
|
| 15 |
REIMB_ACTION |
Character(5) |
VARCHAR2(5) NOT NULL |
Reason
Prompt Table:
EX_ACTION_TBL
|
| 16 |
MONETARY_AMOUNT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Specifies the monetary amount of a debit or credit in the business unit base currency. Debit entries are positive and credit entries are negative. This amount is only zero if associated with a statistical account.
|
| 17 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
Default Value: BUS_UNIT_TBL_EX.BASE_CURRENCY
Prompt Table:
CURRENCY_CD_TBL
|
| 18 |
TXN_AMOUNT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Transaction Amount
|
| 19 |
TXN_CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Transaction Currency
Default Value: BUS_UNIT_TBL_EX.BASE_CURRENCY
Prompt Table:
CURRENCY_CD_TBL
|
| 20 |
TXN_AMOUNT_OVR |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Transaction Amount
|
| 21 |
RATE_USR_DFN |
Character(1) |
VARCHAR2(1) NOT NULL |
The field indicates the type of Exchange rate to be used. User defined or system default
D=Custom - Direct
I=Custom - Indirect
S=System Default
Default Value: S
|
| 22 |
RATE_MULT |
Signed Number(17,8) |
DECIMAL(15,8) NOT NULL |
Rate Multiplier
|
| 23 |
RATE_DIV |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
Rate Divisor
Default Value: 1
|
| 24 |
RT_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.
Default Value: BUS_UNIT_OPT_EX.RT_TYPE
Prompt Table:
RT_TYPE_TBL
|
| 25 |
GROSS_UP_EST_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Gross Up Estimated Amount
|
| 26 |
TXN_LOCATION |
Character(5) |
VARCHAR2(5) NOT NULL |
Expense Location
Prompt Table:
EX_LOCATION_VW6
|
| 27 |
EXPEND_MTHD |
Character(3) |
VARCHAR2(3) NOT NULL |
Payment Type
Prompt Table:
EX_EXP_MTHD_TBL
Set Control Field: BUSINESS_UNIT_GL
|
| 28 |
PREF_MRCHNT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Preferred Merchant
N=No
Y=Yes
Y/N Table Edit
Default Value: N
|
| 29 |
MERCHANT_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
Preferred Merchant
Prompt Table:
EX_MERCHANT_VW1
|
| 30 |
MERCHANT |
Character(40) |
VARCHAR2(40) NOT NULL |
Merchant
|
| 31 |
DESCR60 |
Character(60) |
VARCHAR2(60) NOT NULL |
Description
|
| 32 |
DESCR254 |
Character(254) |
VARCHAR2(254) NOT NULL |
Description of length 254
|
| 33 |
AIRFARE_RCPT_NBR |
Character(16) |
VARCHAR2(16) NOT NULL |
Airfare Receipt Number
|
| 34 |
DISTANCE |
Number(8,2) |
DECIMAL(7,2) NOT NULL |
Distance Traveled
|
| 35 |
DISTANCE_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Distance Type
3=Metres
K=Kilometers
M=Miles
|
| 36 |
DISTANCE_RT |
Number(9,4) |
DECIMAL(8,4) NOT NULL |
Standard Distance Rate
|
| 37 |
NBR_NIGHTS |
Number(3,0) |
SMALLINT NOT NULL |
Number of Nights
|
| 38 |
EE_LOCAMT_COMMENT |
Character(60) |
VARCHAR2(60) NOT NULL |
Location Amount Comment
|
| 39 |
EE_LOCAMT_GRP_CMMT |
Character(60) |
VARCHAR2(60) NOT NULL |
Location Amount Comment
|
| 40 |
EE_NORCPT_COMMENT |
Character(60) |
VARCHAR2(60) NOT NULL |
No Receipt Comment
|
| 41 |
EE_PRFMRC_COMMENT |
Character(60) |
VARCHAR2(60) NOT NULL |
Preferred Vendor Comment
|
| 42 |
EE_DPLCAT_COMMENT |
Character(80) |
VARCHAR2(80) NOT NULL |
Duplicate Comment
|
| 43 |
EE_OLDTXN_COMMENT |
Character(60) |
VARCHAR2(60) NOT NULL |
Older Transactions Comment
|
| 44 |
RECEIPT_VERIFIED |
Character(1) |
VARCHAR2(1) NOT NULL |
Receipt Verified
Y/N Table Edit
Default Value: N
|
| 45 |
OUT_OF_POLICY |
Character(1) |
VARCHAR2(1) NOT NULL |
Authorized Amount Exceeded
Y/N Table Edit
Default Value: N
|
| 46 |
OUT_OF_POLICY_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Type of Out of Poclicy
BOTH=Both
GRP=Group
INDV=Individual
|
| 47 |
NO_RECEIPT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
No Receipt
Y/N Table Edit
Default Value: N
|
| 48 |
PREF_MRCH_NOT_USED |
Character(1) |
VARCHAR2(1) NOT NULL |
Non-Preferred Merchant
Y/N Table Edit
Default Value: N
|
| 49 |
TAX_IMPLICATIONS |
Character(1) |
VARCHAR2(1) NOT NULL |
Items with Tax Implications
Y/N Table Edit
Default Value: N
|
| 50 |
DUPLICATES_EXIST |
Character(1) |
VARCHAR2(1) NOT NULL |
Duplicates Exist
Y/N Table Edit
Default Value: N
|
| 51 |
OLDER_TRANSACTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Older Transactions
Y/N Table Edit
Default Value: N
|
| 52 |
CC_FEED_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Field used to indicate whether a credit card feed was used to populate an expense sheet or not.
Y/N Table Edit
Default Value: N
|
| 53 |
BILL_CODE_EX |
Character(3) |
VARCHAR2(3) NOT NULL |
Expense Billing Code
Prompt Table:
EX_BILL_CD_TBL
|
| 54 |
BILLING_ACTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Billing Action
B=Billable
I=Internal
P=Personal
U=Nonbillable
|
| 55 |
OVRRIDE_SPLT_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Override Accounting Split
Y/N Table Edit
Default Value: N
|
| 56 |
TRAVEL_AUTH_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Travel Authorization Identification. Number used to define travel authorizations. Key field on most travel authorization records and exists at level 0 for travel authorization panels.
|
| 57 |
GROSSUP |
Character(1) |
VARCHAR2(1) NOT NULL |
Gross Up Indicator
Y/N Table Edit
Default Value: N
|
| 58 |
SEPCHK |
Number(1,0) |
SMALLINT NOT NULL |
Separate Check Indicator
|
| 59 |
EX_CREDIT_REF |
Character(60) |
VARCHAR2(60) NOT NULL |
Informational field used for reference when a credit line
is entered in an expense sheet.
|
| 60 |
TRANS_DT_JULIAN |
Number(3,0) |
SMALLINT NOT NULL |
Julian Transaction Date
|
| 61 |
STARTTM_PERDIEM |
Time(15) |
TIMESTAMP |
Start Time (HH:MI)
|
| 62 |
ENDTM_PERDIEM |
Time(15) |
TIMESTAMP |
End Time (HH:MI)
|
| 63 |
CRDMEM_ACCT_NBR |
Character(44) |
VARCHAR2(44) NOT NULL |
Cardmember Number
|
| 64 |
BREAKFAST_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Breakfast Provided
Y/N Table Edit
Default Value: N
|
| 65 |
LUNCH_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Lunch Provided
Y/N Table Edit
Default Value: N
|
| 66 |
DINNER_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Dinner Provided
Y/N Table Edit
Default Value: N
|
| 67 |
COUNTRY |
Character(3) |
VARCHAR2(3) NOT NULL |
Country
Prompt Table:
COUNTRY_TBL
|
| 68 |
STATE |
Character(6) |
VARCHAR2(6) NOT NULL |
State
Prompt Table:
STATE_TBL
|
| 69 |
VAT_RECEIPT |
Character(1) |
VARCHAR2(1) NOT NULL |
No VAT Receipt
Y/N Table Edit
Default Value: N
|
| 70 |
VAT_ENTRD_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Entered VAT Amount
|
| 71 |
VAT_NRCVR_PRO_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Prorate Non-Recoverable VAT
Y/N Table Edit
|
| 72 |
VAT_NRCVR_ALL_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Allocate Non-Recoverable VAT
Y/N Table Edit
|
| 73 |
TAX_CD_VAT |
Character(8) |
VARCHAR2(8) NOT NULL |
Defines the VAT (Value Added Tax) percentage (via link to the Tax Authority) and is used to retrieve VAT accounting ChartFields. The VAT code determines how the VAT amount is calculated on a transaction and how that amount is accounted and reported for.
Prompt Table:
VAT_HEADER_VW
|
| 74 |
TAX_CD_VAT_PCT |
Signed Number(9,4) |
DECIMAL(7,4) NOT NULL |
Specifies the tax percentage that corresponds to the VAT code. If more than one VAT authority is linked to a VAT code this will represent an aggregate percentage.
|
| 75 |
VAT_TREATMENT |
Character(4) |
VARCHAR2(4) NOT NULL |
VAT Treatment
|
| 76 |
VAT_TXN_TYPE_CD |
Character(4) |
VARCHAR2(4) NOT NULL |
Specifies a user-defined category of business transaction that is subject to VAT accounting and reporting. The VAT code and the VAT transaction type are used in conjunction with the VAT account type to obtain the ChartFields for accounting entries. Some examples of VAT Transaction Types are Exempt Sales Exempt Purchases Triangulation EU Sales and Domestic Sales.
Prompt Table:
VAT_TXN_CD
|
| 77 |
VAT_RECOVERY_PCT |
Signed Number(7,2) |
DECIMAL(5,2) NOT NULL |
VAT Recovery Percent
|
| 78 |
VAT_REBATE_PCT |
Signed Number(7,2) |
DECIMAL(5,2) NOT NULL |
VAT Rebate Percent
|
| 79 |
VAT_ROUND_RULE |
Character(1) |
VARCHAR2(1) NOT NULL |
" Rounding rule to be applied to VAT calculations. Options are 'Natural'
D=Round Down
N=Natural Round
U=Round Up
|
| 80 |
VAT_APPLICABILITY |
Character(1) |
VARCHAR2(1) NOT NULL |
A flag that indicates whether or not a transaction is eligible for VAT (Value Added Tax) taxation or why it is not eligible.
E=Exempt
N=Not Applicable
O=Outside of Scope of VAT
S=Suspended
T=Taxable
V=VAT Only
X=Exonerated
|
| 81 |
VAT_USE_ID |
Character(6) |
VARCHAR2(6) NOT NULL |
VAT Use Type
Prompt Table:
VAT_USE_TBL
|
| 82 |
VAT_RECLAIM_PCT |
Signed Number(7,2) |
DECIMAL(5,2) NOT NULL |
VAT Reclaim Percent
|
| 83 |
VAT_RCLM_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
VAT Reclaim Amount
|
| 84 |
VAT_RCLM_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Base VAT Reclaim Amount
|
| 85 |
VAT_NONTX_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Non-Taxable Amount
|
| 86 |
VAT_NONTX_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Base Non-Taxable Amount
|
| 87 |
VAT_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Specifies the amount of VAT associated with a transaction such as an invoice or a purchase order. In PeopleSoft Receivables this field is populated when the VAT declaration point is set to Invoice.
|
| 88 |
VAT_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
VAT Amount in Base Curr
|
| 89 |
VAT_AUTO_CALC_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Automatically Calculate VAT
N=No
Y=Yes
Y/N Table Edit
|
| 90 |
TXN_CURRENCY_CD1 |
Character(3) |
VARCHAR2(3) NOT NULL |
Transaction Currency Display
|
| 91 |
CURRENCY_CD1 |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
|
| 92 |
AIR_TKT_RECON_STAT |
Character(1) |
VARCHAR2(1) NOT NULL |
Airline Ticket Reconciliation Status
C=Cancelled
N=Not Reconciled
R=Reconciled
Default Value: N
|
| 93 |
TRAVEL_FROM |
Character(5) |
VARCHAR2(5) NOT NULL |
Used to indicate the starting point of travel for a travel authorization for airline expenditures. Defined on the EX_TAUTH_LINE record and used on various travel auth line panels. Used in conjunction with the TRAVEL_TO field to track the cost of flights to and from various locals.
Prompt Table:
EX_LOCATION_VW5
|
| 94 |
NBR_PASSENGERS |
Number(2,0) |
SMALLINT NOT NULL |
Number of Passengers
|
| 95 |
TRANSPORT_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Transportation Type
|
| 96 |
RANGE_SEQ |
Number(3,0) |
SMALLINT NOT NULL |
Per Diem Range
Prompt Table:
EX_DUR_VW
|
| 97 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
|
| 98 |
PHYSICAL_NATURE |
Character(1) |
VARCHAR2(1) NOT NULL |
Physical Nature
G=Goods
S=Services
|
| 99 |
VAT_DFLT_DONE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
VAT Defaulting Done
N=Awaiting Defaulting
X=Do not default
Y=Defaulting Done
Default Value: N
|
| 100 |
APPROVE_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Approve Flag
Default Value: Y
|
| 101 |
APPROVER_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Approver Oprid
|
| 102 |
APPROVER_ACTN_DT |
Date(10) |
DATE |
The Date on which the approver takes necessary action
|
| 103 |
APPROVER_ADD_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
New Approver Add Flag
Default Value: N
|
| 104 |
UNDENY_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Undeny Flag
|
| 105 |
ITINERARY_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Itinerary ID for Travel Reservations
|
| 106 |
RESERVATION_NBR |
Number(3,0) |
SMALLINT NOT NULL |
reservation sequence number
|
| 107 |
ISCHANGED_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Record has been changed
Y/N Table Edit
Default Value: N
|
| 108 |
EX_TYPE_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Expense Type Flag
Y/N Table Edit
Default Value: N
|
| 109 |
LASTUPDDTTM |
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.
Default Value: %datetime
|
| 110 |
RECEIPT_REQ_EX |
Character(1) |
VARCHAR2(1) NOT NULL |
Receipt Required
Y/N Table Edit
Default Value: N
|
| 111 |
GST_EXEMPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Tax Exempt
Y/N Table Edit
Default Value: N
|
| 112 |
TXN_LOCATION_STATE |
Character(6) |
VARCHAR2(6) NOT NULL |
Transaction location state.
|
| 113 |
SHIPTO_LOCATION |
Character(5) |
VARCHAR2(5) NOT NULL |
Ship-To Location
Prompt Table:
EX_LOCATION_VW6
|
| 114 |
SHIPTO_LOC_STATE |
Character(6) |
VARCHAR2(6) NOT NULL |
Ship-to location state.
|
| 115 |
MERCHANT_REG_NUM |
Character(30) |
VARCHAR2(30) NOT NULL |
Merchant Registration Number
|
| 116 |
MERCHANT_LOCATION |
Character(5) |
VARCHAR2(5) NOT NULL |
Merchant Location
Prompt Table:
EX_LOCATION_VW6
|
| 117 |
MERCHANT_LOC_STATE |
Character(6) |
VARCHAR2(6) NOT NULL |
Merchant location state.
|
| 118 |
RECEIPT_NUMBER |
Character(30) |
VARCHAR2(30) NOT NULL |
Receipt Number
|
| 119 |
TAX_AUTHORITY |
Character(8) |
VARCHAR2(8) NOT NULL |
Tax Authority
|
| 120 |
TAX_CODE |
Character(10) |
VARCHAR2(10) NOT NULL |
Tax code
|
| 121 |
TAX_JURISDICTION_L |
Character(10) |
VARCHAR2(10) NOT NULL |
Tax Jurisdiction
|
| 122 |
HSN_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
HSN Code
Prompt Table:
GST_HSN
|
| 123 |
SAC_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
SAC Code
Prompt Table:
GST_SAC
|
| 124 |
TAXABLE_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Cost of Good(s) or Service(s)
|
| 125 |
CGST_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
CGST Tax Amount
|
| 126 |
SGST_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
SGST Tax Amount
|
| 127 |
IGST_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
IGST Tax Amount
|
| 128 |
IGST_RATE |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
IGST Tax Rate
|
| 129 |
SGST_RATE |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
SGST Tax Rate
|
| 130 |
CGST_RATE |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
CGST Tax Rate
|
| 131 |
TAXABLE_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Cost of Good(s) or Service(s)
|
| 132 |
CGST_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
CGST Tax Amount
|
| 133 |
IGST_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
IGST Tax Amount
|
| 134 |
SGST_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
SGST Tax Amount
|
| 135 |
CGST_ENTERED_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Entered CGST Tax Amount
|
| 136 |
IGST_ENTERED_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Entered IGST Tax Amount
|
| 137 |
SGST_ENTERED_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Entered SGST Tax Amount
|
| 138 |
EE_GST_COMMENT |
Character(80) |
VARCHAR2(80) NOT NULL |
Override GST Amounts Comments
|
| 139 |
CGST_CALC_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Calculated CGST Tax Amount
|
| 140 |
IGST_CALC_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Calculated IGST Tax Amount
|
| 141 |
SGST_CALC_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Calculated SGST Tax Amount
|
| 142 |
CGST_CALC_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Calculated CGST Tax Amount
|
| 143 |
IGST_CALC_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Calculated IGST Tax Amount
|
| 144 |
SGST_CALC_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Calculated SGST Tax Amount
|
| 145 |
EE_GPS_AMT_COMMENT |
Character(60) |
VARCHAR2(60) NOT NULL |
GPS amount override exception comment
|
| 146 |
DISTANCE_CALC |
Number(8,2) |
DECIMAL(7,2) NOT NULL |
Calculated Distance
|
| 147 |
STARTING_POINT |
Character(254) |
VARCHAR2(254) NOT NULL |
Starting Point
|
| 148 |
ENDING_POINT |
Character(254) |
VARCHAR2(254) NOT NULL |
Ending Point
|
| 149 |
LATITUDE1 |
Signed Number(12,7) |
DECIMAL(10,7) NOT NULL |
Latitude
|
| 150 |
LONGITUDE1 |
Signed Number(12,7) |
DECIMAL(10,7) NOT NULL |
Longitude
|
| 151 |
START_POINT_SELECT |
Character(254) |
VARCHAR2(254) NOT NULL |
Selected Start Point
|
| 152 |
LATITUDE2 |
Signed Number(12,7) |
DECIMAL(10,7) NOT NULL |
Latitude
|
| 153 |
LONGITUDE2 |
Signed Number(12,7) |
DECIMAL(10,7) NOT NULL |
Longitude
|
| 154 |
END_POINT_SELECT |
Character(254) |
VARCHAR2(254) NOT NULL |
Selected End Point
|
| 155 |
DISTANCE_SELECT |
Number(8,2) |
DECIMAL(7,2) NOT NULL |
Distance
|