Internal ID |
Type |
nlapiSubmitField |
Label |
Required |
Help |
billedamount |
currency |
|
Amount |
true |
This is the total charged amount for this imported employee expense. |
billedcurrency |
select |
|
Currency |
true |
This is the currency of the location where the transaction occurred. |
billedtaxamount |
currency |
|
Tax Amount |
false |
This is the tax amount in the account's base currency. Tax amounts do not appear on expense reports. |
cardcurrency |
select |
|
Card Currency |
true |
This is the base currency for this corporate credit card. |
cardmemberembossedname |
text |
|
Card Member Embossed Name |
false |
The employee name as it appears on the credit card. Enter cardholder names on employee records on the Human Resources subtab, under Corporate Cards. |
category |
select |
|
Expense Category |
false |
|
chargedate |
date |
|
Date |
true |
|
corporatecard |
checkbox |
|
Corporate Card |
false |
This box indicates if the transaction was imported from a corporate card. If this transaction was imported through an automatic import, this box is checked by default. |
costcenter |
text |
|
Cost Center |
false |
This is your cost center with the issuing credit card company. |
currencyexchangerate |
currency2 |
|
Exchange Rate |
false |
This is the currency exchange rate between the account's base currency and the transaction's local currency at the time the transaction occurred. |
customform |
select |
|
Custom Form |
false |
|
employee |
select |
|
Employee |
false |
|
externalid |
text |
|
External ID |
false |
|
formatprofile |
select |
|
Import Type |
false |
|
id |
integer |
|
Internal ID |
false |
This is the unique NetSuite expense id. |
internalid |
integer |
|
Internal ID |
false |
|
localchargeamount |
currency |
|
Foreign Amount |
false |
This is the total charge in the currency where the transaction took place. |
localtaxamount |
currency |
|
Local Tax Amount |
false |
This is the tax amount in the currency of the location where the transaction took place. Tax amounts do not appear on expense reports. |
memo |
text |
|
Memo |
false |
This is a description of the transaction from the credit card company. |
sourcetype |
select |
|
Source Type |
true |
|
status |
select |
|
Status |
true |
The following statuses are available for imported employee expenses:
* Failed - Failed expenses have not been imported properly.
* Ignored - Ignored expenses have previously been marked as ignored by the employee or an administrator. Ignored expenses don't appear when adding imported expenses directly to an expense report.
* Pending - Pending expenses don't have an associated employee. You can manually associate the correct employee for this expense.
* Processed - Processed expenses have been added to an expense report.
* Ready - Expenses are available to add to expenses reports. |
transactionid |
text |
|
Transaction ID |
true |
This is a unique transaction id for this imported employee expense provided by the credit card company. |