Adjustment Site Override Upload
This integration uploads site adjustment overrides.
Connector Overview
|
Component |
Detail |
|---|---|
|
Company Type |
Buyer MSP Partner Supplier |
|
Version Type |
API-V1.0 |
|
Format |
CSV |
|
Prerequisites |
Company plug-ins must be turned on for Integration – Adjustment Site Override Upload. User role permission must be turned on for Upload Data and Download Data. |
|
Predecessors |
Sites Invoice Adjustments |
|
Related Connectors |
Adjustment Only Credit Debit Memo Upload |
File Formatting
Header
|
Component |
Required? |
Definition/Use |
Notes |
Value |
|---|---|---|---|---|
|
Type |
Yes |
Upload File Type |
If you have a custom connector name for a standard connector, you may use the exact same custom name for the Type header; otherwise, you must use the standard name shown in the Value field. |
Adjustment Site Override Upload |
|
Transaction |
No |
Only applicable for the API-V1.0 version. Transaction Type |
Transaction Type. The valid type names are:
If this field is not included in the header, the default value will be True. |
|
|
Number Format |
No |
Determines the number format to be used in the file. |
The valid values are:
The quotes are required even if the value does not have a comma in it. If this field is not included in the header, the default value will be "#,##9.99" (Example: "1,234,567.99") |
|
|
Date Format |
No |
Determines the date format to be used in the file. |
The valid values are:
If this field is not included in the header, the default value will be MM/DD/YYYY. |
|
|
Language |
No |
Determines the language to be used for values in the file, such as drop-down lists and radio buttons. Column headers will always default to the upload user's preferred language. |
The valid language values are: Arabic (Standard Arabic)
|
|
|
Comments |
No |
Upload Comments |
This is a comment field containing notes about the upload file. |
Immediately following the Header section of the upload is one blank line.
Detail
|
Field Header Name |
Data Type |
Length |
Required? |
Value(s)/Format |
Description/Use/Field Rules |
|---|---|---|---|---|---|
|
Modification Type |
Char |
1 |
Yes |
Valid values are:
|
Action to be performed: A = Add U = Update D = Delete |
|
Adjustment Name |
Text |
100 |
Yes |
Example: State Tax |
Adjustment name of an existing adjustment created for the company in which the upload is to be processed. |
|
Adjustment Type |
Text |
32 |
Yes |
Valid values are:
|
Type of adjustment. |
|
Site Code |
Text |
100 |
Yes |
Valid SAP Fieldglass Site Code |
Site code to which adjustment is applied. |
|
Default Value |
Decimal |
No |
Example: 6.500 |
Adjustment percentage to be applied to site. If field left blank, will default to 0.0. |
Unique Identifier
-
Combination of Adjustment Name, Adjustment Type, and Site Code fields
Configuration Considerations
|
# |
Item |
Notes |
|---|---|---|
|
1 |
Site Visibility |
A user's visibility will be affected, in part, by the sites to which they are associated. It is important to consider what sites a user should be able to have visibility into for this reason. |
|
2 |
Site Naming |
It is important to choose a meaningful and readable naming convention for your sites. Since users will need to select them from a list when creating different transactions in SAP Fieldglass, it is important that they can easily find them and know they are choosing the correct item. The same applies to Adjustment naming. |