-
Notifications
You must be signed in to change notification settings - Fork 8
Finance Batch Load Columns and procedures
Owen Stephens edited this page Sep 30, 2015
·
1 revision
Finance files contain columns such as the ones listed at the bottom of this page.
The procedure for importing a file such as this::
-
Pass 1
- Syntactic Checking
- Semantic Checking
- Resolve References
- Subscription - extract any subscription references, decide if they map to an existing sub, a new one or should not be mapped
- Others
-
Pass 2
- Reload data with references resolved
Cols
| Source | Column | Import Column |
|---|---|---|
| SWETS | CID | costItemReference |
| SWETS | Title Name | titleName |
| SWETS | ti_id | titleId.provider |
| SWETS | ISSN | titleId.issn |
| SWETS | Subscription Number | subscriptionId.provider |
| SWETS | Subscription Status | subscriptionStatus |
| SWETS | Your reference 1 | ref.1 |
| SWETS | Your reference 2 | ref.2 |
| SWETS | Your reference 3 | ref.3 |
| SWETS | Your reference 4 | ref.4 |
| SWETS | Expiry Date | expiryDate |
| SWETS | Publisher Name and Country | publisherName |
| SWETS | Supplier Name | supplierName |
| SWETS | Subscription Supply Type | supplyType |
| SWETS | Publisher Reference Number | publisherReference |
| SWETS | Ordered from Date | |
| SWETS | Ordered from Volume | |
| SWETS | Ordered from Issue | |
| SWETS | Cancelled after Date | |
| SWETS | Cancelled after Volume | |
| SWETS | Cancelled after Issue | |
| SWETS | Subscription access - provider name | |
| SWETS | Subscription access - start date | |
| SWETS | Subscription access - end date | |
| SWETS | Access activation date | |
| SWETS | Electronic publisher reference | |
| SWETS | User id & password | |
| SWETS | Frequency | |
| SWETS | Subject Name | |
| SWETS | Language | |
| SWETS | First Published Date | |
| SWETS | Country of publication | |
| SWETS | Publication Type | |
| SWETS | Title access provider name | |
| SWETS | Publisher URL | |
| SWETS | Shipping Address Name | |
| SWETS | Shipping Address Line 1 | |
| SWETS | Shipping Address Line 2 | |
| SWETS | Shipping Address Line 3 | |
| SWETS | Country of Shipping Address | |
| SWETS | Billing Address Name | |
| SWETS | Billing Address Line 1 | |
| SWETS | Billing Address Line 2 | |
| SWETS | Billing Address Line 3 | |
| SWETS | Country of Billing Address | |
| SWETS | Invoice number | |
| SWETS | Invoice Date | |
| SWETS | Invoice Amount | |
| SWETS | Invoice Currency | |
| SWETS | Period charged from | |
| SWETS | Volume charged from | |
| SWETS | Issue charged from | |
| SWETS | Part charged from | |
| SWETS | Period charged to | |
| SWETS | Volume charged to | |
| SWETS | Issue charged to | |
| SWETS | Part charged to |