| |
| |
Field Mapping--Open AP Aging
| Author: Reference Number: AA-01344 Created: 2011-03-01 09:46 Last Updated: 2011-11-03 16:25 |
0 Rating/ Voters
|
 |
Field Mapping Notes (for the OneSource Field Mapping Spreadsheet – AP Aging file)
|
Field Mapping Spreadsheet
Column Name |
OneSource
Field Type |
Field length or Numeric Range |
Sample Values |
Default Value |
Additional Notes |
|
|
|
|
|
|
|
|
Bill ID |
Long Integer (Auto Number) |
Between -2,000,000,000 and 2,000,000,000 |
12345678 |
(Will be auto generated by OneSource if left empty) |
This is the unique identifier (Primary Key) for the AP Bill. |
|
Supplier Number |
Text |
50 |
12345 or ABC12345 |
|
*** REQUIRED *** This is the unique Supplier Number of the Supplier or Vendor you intend to pay. If Supplier Numbers will be regenerated when the data is imported, this will need to be the new Supplier Number generated by OneSource. |
|
Amount |
Currency |
15 |
$100.00 |
$0.00 |
*** REQUIRED *** This is the unique Supplier Number of the Supplier or Vendor you intend to pay. If Supplier Numbers will be regenerated when the data is imported, this will need to be the new Supplier Number generated by OneSource. |
|
Purchase Order Number |
Text |
50 |
12345 or ABC12345 |
|
|
|
Invoice Number |
Text |
20 |
12345 or ABC12345 |
|
|
|
Account ID |
Long Integer |
+ or - 2,000,000,000 |
123456 |
(The OneSource GL Account ID will be used here) |
Note: In order to keep the GL Balance with the Beginning Balance Journal Entry, this account will be set to the GL ID of the OneSource Accounts Payable GL account. No GL Account is necessary here. |
|
Invoice Date |
Date |
Short Date |
8/01/07 |
Import Date |
|
|
Due Date |
Date |
NA |
8/01/07 |
Import Date |
|
|
Terms |
Text |
50 |
1% 10 Net 30 |
Unknown |
|
|
Purpose of Expense |
Text |
50 |
Needed a company car |
|
Internal notes about this expense. |
|
Comments |
Text |
255 |
For x item. |
|
Comments printed on AP Check. |
|
Discount Taken |
Currency |
15 |
$30.00 |
$0.00 |
When the Bill is later paid, this amount will be subtracted off of the amount paid for the Bill for paying bill early. |
|
Tax Deductible |
Yes/No |
Yes / No
-1 / 0 |
No |
No |
|
|
1099 |
Yes/No |
Yes / No
-1 / 0 |
Yes |
No |
Do you want this Bill to be included on year end 1099’s? |
|
Items Received |
Yes/No |
Yes / No
-1 / 0 |
Yes |
Yes |
Have the items for this bill been received yet? |
|
|
|
|
|
|
|
|
| |
|
