Get all invoices
/fscmRestApi/resources/11.13.18.05/invoicesForLandedCostCharges
Request
-
expand: string
When this parameter is provided, the specified children are included in the resource payload (instead of just a link). The value of this query parameter is "all" or "". More than one child can be specified using comma as a separator. Example: ?expand=Employees,Localizations. Nested children can also be provided following the format "Child.NestedChild" (Example: ?expand=Employees.Managers). If a nested child is provided (Example: Employees.Managers), the missing children will be processed implicitly. For example, "?expand=Employees.Managers" is the same as "?expand=Employees,Employees.Managers" (which will expand Employees and Managers).
-
fields: string
This parameter filters the resource fields. Only the specified fields are returned, which means that if no fields are specified, no fields are returned (useful to get only the links). If an indirect child resource is provided (Example: Employees.Managers), the missing children will be processed implicitly. For example, "?fields=Employees.Managers:Empname" is the same as "?fields=;Employees:;Employees.Managers:Empname" (which will only return the "Empname" field for Managers). the value of this query parameter is a list of resource fields. The attribute can be a direct (Example: Employees) or indirect (Example: Employees.Managers) child. It cannot be combined with expand query parameter. If both are provided, only fields will be considered.
Format: ?fields=Attribute1,Attribute2
Format for fields in child resource: ?fields=Accessor1:Attribute1,Attribute2 -
finder: string
Used as a predefined finder to search the collection.
Format: ?finder=<finderName>;<variableName>=<variableValue>,<variableName2>=<variableValue2>
The following are the available finder names and corresponding finder variables:- PrimaryKey: Find invoices for landed cost charges according to the primary key.
Finder Variables:- InvoiceId; integer; Value that uniquely identifies an invoice. This values is a composite key.
- InvoiceLineNumber; string; Number that uniquely identifies an invoice. This values is a composite key.
- findInvoicesForCharges: Find invoices for landed cost charges according to the specified attributes.
Finder Variables:- bindAssociationMode; string; Mode of association of invoice to a trade operation charge.
- bindAssociationStatus; string; Status of the invoice association to the charge.
- bindChargeBU; string; Business unit of charge associated with an invoice.
- bindChargeName; string; Name of the charge associated with an invoice.
- bindChargeReferenceName; string; Name of the charge reference type.
- bindChargeReferencePredefined; string; Value that indicates whether a charge has a predefined charge reference or not.
- bindInvoiceAmount; number; Amount incurred on the invoice.
- bindInvoiceCreationDate; string; Date when the invoice was created.
- bindInvoiceCurrency; string; Currency on the invoice amount.
- bindInvoiceLineNumber; string; Number that identifies a line on the invoice.
- bindInvoiceNrTaxAmount; number; Amount of non-recoverable tax incurred on the invoice.
- bindInvoiceNumber; string; Number that identifies the invoice.
- bindMissingChargeNames; string; Value that indicates the missing charge names on the invoice.
- bindMissingChargeReferences; string; Value to show missing charge references on the invoice.
- bindProcurementBU; string; Name of the procurement business unit on the invoice.
- bindReferenceValueDate; string; Date value of the charge reference.
- bindReferenceValueNumber; number; Number that identifies the charge reference.
- bindReferenceValueText; string; Text of the charge reference.
- bindSupplier; string; Name of the supplier on the invoice.
- bindSupplierSite; string; Name of the supplier site on the invoice.
- bindTradeOperationName; string; Name of the trade operation.
- bindTradeOperationNumber; string; Number that identifies the trade operation within a procurement business unit.
- PrimaryKey: Find invoices for landed cost charges according to the primary key.
-
limit: integer
This parameter restricts the number of resources returned inside the resource collection. If the limit exceeds the resource count then the framework will only return the available resources.
-
links: string
This parameter can be used to show only certain links while accessing a singular resource or a resource collection. The parameter value format is a comma-separated list of : <link_relation>
Example:
self,canonical -
offset: integer
Used to define the starting position of the resource collection. If offset exceeds the resource count then no resources are returned. Default value is 0.
-
onlyData: boolean
The resource item payload will be filtered in order to contain only data (no links section, for example).
-
orderBy: string
This parameter orders a resource collection based on the specified fields. The parameter value is a comma-separated string of attribute names, each optionally followed by a colon and "asc" or "desc". Specify "asc" for ascending and "desc" for descending. The default value is "asc". For example, ?orderBy=field1:asc,field2:desc
-
q: string
This query parameter defines the where clause. The resource collection will be queried using the provided expressions. The value of this query parameter is one or more expressions. Example: ?q=Deptno>=10 and <= 30;Loc!=NY
Format: ?q=expression1;expression2
You can use these queryable attributes to filter this collection resource using the q query parameter:- AssociationMode; string; Mode by which the invoice line is associated with the charge line. Valid values include Automatic and Manual.
- AssociationModeCode; number; Value that identifies the mode of invoice association.
- AssociationStatus; string; Abbreviation that uniquely identifies the status of the invoice association with the charge line. Valid values include Needs Review, Deleted, Rejected, and Associated.
- ChargeBU; string; Value that indicates the requisitioning business unit that incurs the charge.
- ChargeBUId; integer; Value that uniquely identifies the business unit associated with the trade operation charge.
- ChargeCode; string; Abbreviation that identifies the landed cost charge.
- ChargeId; integer; Value that uniquely identifies the trade operation charge.
- ChargeName; string; Name of the charge given on the invoice line.
- InvoiceAmount; number; Amount on the invoice distribution.
- InvoiceCreationDate; string; Date when the supplier raised the invoice.
- InvoiceCurrency; string; Currency on the invoice.
- InvoiceCurrencyCode; string; Abbreviation that identifies the invoice currency.
- InvoiceId; integer; Value that uniquely identifies the invoice.
- InvoiceLineNumber; string; Number that identifies a line on the invoice.
- InvoiceLineType; string; Value that identifies the type of invoice such as Standard Invoice, Credit memo, Debit memo, and so on.
- InvoiceNonrecoverableTaxAmount; number; Amount of non-recoverable tax on the invoice distribution.
- InvoiceNumber; string; Number that identifies the invoice.
- MissingChargeReferences; string; Contains one of the following values: true or false. If true, then invoice lines are missing charge references. If false, then invoice lines contain charge references. The default value is null.
- ProcurementBU; string; Value that indicates the procurement business unit on the invoice line.
- ProcurementBUId; integer; Value that uniquely identifies the procurement business unit.
- Supplier; string; Value that indicates the supplier on the invoice.
- SupplierId; integer; Value that uniquely identifies the supplier rendering the service.
- SupplierSite; string; Value that indicates the supplier site on the charge line.
- SupplierSiteId; integer; Value that uniquely identifies the supplier site rendering the service.
- TradeOperationName; string; Name of the trade operation associated with the charge invoice.
- TradeOperationNumber; string; Number that indicates the trade operation associated with the charge invoice.
-
totalResults: boolean
The resource collection representation will include the "estimated row count" when "?totalResults=true", otherwise the count is not included. The default value is "false".
-
Metadata-Context:
If the REST API supports runtime customizations, the shape of the service may change during runtime. The REST client may isolate itself from these changes or choose to interact with the latest version of the API by specifying this header. For example: Metadata-Context:sandbox="TrackEmployeeFeature".
-
REST-Framework-Version:
The protocol version between a REST client and service. If the client does not specify this header in the request the server will pick a default version for the API.
There's no request body for this operation.
Back to TopResponse
- application/json
Default Response
-
Metadata-Context:
If the REST API supports runtime customizations, the shape of the service may change during runtime. The REST client may isolate itself from these changes or choose to interact with the latest version of the API by specifying this header. For example: Metadata-Context:sandbox="TrackEmployeeFeature".
-
REST-Framework-Version:
The protocol version between a REST client and service. If the client does not specify this header in the request the server will pick a default version for the API.
object
-
count(required): integer
The number of resource instances returned in the current range.
-
hasMore(required): boolean
Indicates whether more resources are available on the server than the subset returned in the response. If the value is true, then there are more resources to retrieve from the server. The default value is false.
-
items: array
Items
Title:
Items
The items in the collection. -
limit(required): integer
The actual paging size used by the server.
-
links(required): array
Links
Title:
Links
The link relations associated with the resource instance. -
offset(required): integer
The offset value used in the current page.
-
totalResults: integer
The estimated row count when "?totalResults=true", otherwise the count is not included.
array
Links
object
-
AssociationMode: string
Title:
Association Mode
Read Only:true
Maximum Length:255
Mode by which the invoice line is associated with the charge line. Valid values include Automatic and Manual. -
AssociationModeCode: number
Title:
Association Mode Code
Read Only:true
Value that identifies the mode of invoice association. -
AssociationStatus: string
Title:
Association Status
Read Only:true
Maximum Length:80
Abbreviation that uniquely identifies the status of the invoice association with the charge line. Valid values include Needs Review, Deleted, Rejected, and Associated. -
ChargeBU: string
Title:
Charge BU
Read Only:true
Maximum Length:240
Value that indicates the requisitioning business unit that incurs the charge. -
ChargeBUId: integer
(int64)
Title:
Charge Business Unit ID
Value that uniquely identifies the business unit associated with the trade operation charge. -
ChargeCode: string
Title:
Charge Code
Read Only:true
Maximum Length:30
Abbreviation that identifies the landed cost charge. -
ChargeId: integer
(int64)
Title:
Charge ID
Value that uniquely identifies the trade operation charge. -
ChargeName: string
Title:
Charge Name
Read Only:true
Maximum Length:80
Name of the charge given on the invoice line. -
InvoiceAmount: number
Title:
Amount
Read Only:true
Amount on the invoice distribution. -
InvoiceCreationDate: string
(date-time)
Title:
Invoice Date
Read Only:true
Date when the supplier raised the invoice. -
InvoiceCurrency: string
Title:
Currency Name
Read Only:true
Maximum Length:80
Currency on the invoice. -
InvoiceCurrencyCode: string
Title:
Currency Code
Read Only:true
Maximum Length:15
Abbreviation that identifies the invoice currency. -
InvoiceId: integer
(int64)
Title:
Invoice ID
Read Only:true
Value that uniquely identifies the invoice. -
InvoiceLineNumber: string
Title:
Invoice Line Number
Read Only:true
Maximum Length:40
Number that identifies a line on the invoice. -
InvoiceLineType: string
Title:
Line Type
Read Only:true
Maximum Length:30
Value that identifies the type of invoice such as Standard Invoice, Credit memo, Debit memo, and so on. -
InvoiceNonrecoverableTaxAmount: number
Title:
Nonrecoverable Tax
Read Only:true
Amount of non-recoverable tax on the invoice distribution. -
InvoiceNumber: string
Title:
Invoice Number
Read Only:true
Maximum Length:50
Number that identifies the invoice. -
landedCostChargeReferencesForInvoiceLines: array
References
Title:
References
The References for Landed Cost Charges manages the charge references on the charge used for invoice association. -
links: array
Links
Title:
Links
The link relations associated with the resource instance. -
MissingChargeReferences: string
Title:
Show Only Invoices Missing Reference Types
Read Only:true
Maximum Length:255
Contains one of the following values: true or false. If true, then invoice lines are missing charge references. If false, then invoice lines contain charge references. The default value is null. -
ProcurementBU: string
Title:
Procurement BU
Read Only:true
Maximum Length:240
Value that indicates the procurement business unit on the invoice line. -
ProcurementBUId: integer
(int64)
Title:
Procurement Business Unit ID
Read Only:true
Value that uniquely identifies the procurement business unit. -
Supplier: string
Title:
Supplier
Read Only:true
Maximum Length:360
Value that indicates the supplier on the invoice. -
SupplierId: integer
(int64)
Title:
Supplier ID
Read Only:true
Value that uniquely identifies the supplier rendering the service. -
SupplierSite: string
Title:
Supplier Site
Read Only:true
Maximum Length:240
Value that indicates the supplier site on the charge line. -
SupplierSiteId: integer
(int64)
Title:
Supplier Site ID
Read Only:true
Value that uniquely identifies the supplier site rendering the service. -
TradeOperationName: string
Title:
Trade Operation Name
Read Only:true
Maximum Length:80
Name of the trade operation associated with the charge invoice. -
TradeOperationNumber: string
Title:
Trade Operation Number
Read Only:true
Maximum Length:40
Number that indicates the trade operation associated with the charge invoice.
array
References
array
Links
object
-
ChargeReferenceDataType: string
Title:
Reference Data Type
Value that identifies the type of input data for charge references. -
ChargeReferenceName: string
Title:
Charge Reference Name
Name of the charge reference type. -
ChargeReferencePredefined: string
Title:
Predefined
Read Only:true
Maximum Length:255
Contains one of the following values: true or false. If true, then the reference type is predefined in the default charge references setup. If false, then the reference type is not predefined. The default value is false. -
ChargeReferenceTypeId: integer
(int64)
Title:
Charge Reference Type ID
Value that uniquely identifies the type of charge reference. -
ChargeReferenceValueDataType: string
Title:
Reference Data Type
Read Only:true
Maximum Length:80
Value that identifies the type of input data for charge references. -
InvoiceChargeReferenceId: integer
(int64)
Title:
Invoice Charge Reference ID
Value that uniquely identifies the invoice charge reference. -
links: array
Links
Title:
Links
The link relations associated with the resource instance. -
ProcurementBU: string
Title:
Procurement BU
Read Only:true
Maximum Length:240
Value that indicates the procurement business unit on the charge reference. -
ProcurementBUId: integer
(int64)
Title:
Procurement Business Unit ID
Value that uniquely identifies the procurement business unit. -
ReferenceValueDate: string
(date-time)
Title:
Date Reference
Date value of the charge reference. -
ReferenceValueNumber: number
Title:
Numeric Reference
Number that identifies the charge reference. -
ReferenceValueText: string
Title:
Alphanumeric Reference
Maximum Length:64
Text of the charge reference. -
UserComment: string
Title:
Comments
Maximum Length:240
Comments added by the user for the charge reference.
array
Links
object
-
href: string
Title:
hyperlink reference
The URI to the related resource. -
kind: string
Title:
kind
Allowed Values:[ "collection", "item", "describe", "other" ]
The kind of the related resource. -
name: string
Title:
name
The name of the link to the related resource. -
properties: object
properties
-
rel: string
Title:
relation
Allowed Values:[ "self", "lov", "parent", "canonical", "child", "enclosure", "action", "custom" ]
The name of the relation to the resource instance. Example: self.
object
-
changeIndicator: string
Change indicator or the ETag value of the resource instance.
Examples
This example describes how to get all invoices.
Example 1 cURL Command
Use the following cURL command to submit a request on the REST resource:
curl -u username:password "https://servername/fscmRestApi/resources/version/invoicesForLandedCostCharges"
Example 1 Response Body
The following shows an example of the response body in JSON format.
{ "items":[ { "AssociationMode": "Automatic", "AssociationModeCode": 1, "AssociationStatus": "Associated", "ChargeName": "SS_Handling", "ChargeCode": "SS_Handling", "ChargeID": 300100071793255, "ChargeBU": "Vision Operations", "ChargeBUID": 204, "MissingChargeReferences": "false", "InvoiceNumber": "SS007", "InvoiceID": 300100089897318, "InvoiceLineNumber": "1", "InvoiceLineType": "ITEM", "InvoiceAmount": 75, "InvoiceNonrecoverableTaxAmount": 0, "InvoiceCurrency": "US Dollar", "InvoiceCurrencyCode": "USD", "InvoiceCreationDate": "02/23/17", "ProcurementBU": "Vision Operations", "ProcurementBUID": 204, "Supplier": "PennyPack Systems", "SupplierID": 21, "SupplierSite": "03", "SupplierSiteID": 1712, "TradeOperationName": "Exp Dest", "TradeOperationNumber": "7", ... }, ... ] ... }
Example 2 cURL Command
Use the following cURL command to submit a request on the REST resource to get all landed cost charge references associated with a landed cost charge:
curl -u username:password "https://servername/fscmRestApi/resources/version/invoicesForLandedCostCharges/00040000000EACED00057708000110F07F41616600000001310000000EACED00057708000110F07F4161660000000EACED000577080000000000000001/child/landedCostChargeReferencesForInvoiceLines"
Example 2 Response Body
The following shows an example of the response body in JSON format.
{ "items":[ { "ChargeReferenceName": "Freight_Ref", "ChargeReferenceTypeID": 300100071793244, "ChargeReferencePredefined": true, "ChargeReferenceValueDataType": "Date", "ChargeRefValueDataTypeCode": null, "ReferenceValueNumber": null, "ReferenceValueDate": null, "ReferenceValueText": null, "InvoiceChargeReferenceID": null, "ProcurementBU": null, "ProcurementBUID": null, "ChargeReferenceName": null, "UserComment": null, "InvalidAttributeDerivation": null, "ChargeRefDataType": null, ... }, ... ] ... }
Example 3 cURL Command
Use the following cURL command to submit a request on the REST resource to get all invoices for landed cost with charge references:
curl -u username:password "https://servername/fscmRestApi/resources/version/invoicesForLandedCostCharges?finder=findInvoicesForCharges;bindMissingChargeReferences=false"
Example 3 Response Body
The following shows an example of the response body in JSON format.
{ "items":[ { "AssociationMode": "Automatic", "AssociationModeCode": 1, "AssociationStatus": "Associated", "ChargeName": "SS_Handling", "ChargeCode": "SS_Handling", "ChargeID": 300100071793255, "ChargeBU": "Vision Operations", "ChargeBUID": 204, "MissingChargeReferences": "false", "InvoiceNumber": "SS007", "InvoiceID": 300100089897318, "InvoiceLineNumber": "1", "InvoiceLineType": "ITEM", "InvoiceAmount": 75, "InvoiceNonrecoverableTaxAmount": 0, "InvoiceCurrency": "US Dollar", "InvoiceCurrencyCode": "USD", "InvoiceCreationDate": "02/23/17", "ProcurementBU": "Vision Operations", "ProcurementBUID": 204, "Supplier": "PennyPack Systems", "SupplierID": 21, "SupplierSite": "03", "SupplierSiteID": 1712, "TradeOperationName": "Exp Dest", "TradeOperationNumber": "7", ... }, ... ] ... }
Example 4 cURL Command
Use the following cURL command to submit a request on the REST resource to get invoices for landed cost by procurement business unit and invoice status:
curl -u username:password "https://servername/fscmRestApi/resources/version/invoicesForLandedCostCharges?finder=findInvoicesForCharges;bindProcurementBU=Vision Operations;bindAssociationStatus=New"
Example 4 Response Body
The following shows an example of the response body in JSON format.
{ "items":[ { "AssociationMode": "Automatic", "AssociationModeCode": 1, "AssociationStatus": "Associated", "ChargeName": "SS_Handling", "ChargeCode": "SS_Handling", "ChargeID": 300100071793255, "ChargeBU": "Vision Operations", "ChargeBUID": 204, "MissingChargeReferences": "false", "InvoiceNumber": "SS007", "InvoiceID": 300100089897318, "InvoiceLineNumber": "1", "InvoiceLineType": "ITEM", "InvoiceAmount": 75, "InvoiceNonrecoverableTaxAmount": 0, "InvoiceCurrency": "US Dollar", "InvoiceCurrencyCode": "USD", "InvoiceCreationDate": "02/23/17", "ProcurementBU": "Vision Operations", "ProcurementBUID": 204, "Supplier": "PennyPack Systems", "SupplierID": 21, "SupplierSite": "03", "SupplierSiteID": 1712, "TradeOperationName": "Exp Dest", "TradeOperationNumber": "7", ... }, ... ] ... }
Example 5 cURL Command
Use the following cURL command to submit a request on the REST resource to get invoices for landed cost by association mode:
curl -u username:password "https://servername/fscmRestApi/resources/version/invoicesForLandedCostCharges?finder=findInvoicesForCharges;bindAssociationMode=Automatic"
Example 5 Response Body
The following shows an example of the response body in JSON format.
{ "items":[ { "AssociationMode": "Automatic", "AssociationModeCode": 1, "AssociationStatus": "Associated", "ChargeName": "SS_Freight", "ChargeCode": "SS_Freight", "ChargeID": 300100071793249, "ChargeBU": "Vision Operations", "ChargeBUID": 204, "MissingChargeReferences": "false", "InvoiceNumber": "zR13OTBI_P2P_LCM_001", "InvoiceID": 300100100238973, "InvoiceLineNumber": "1", "InvoiceLineType": "ITEM", "InvoiceAmount": 75, "InvoiceNonrecoverableTaxAmount": 0, "InvoiceCurrency": "US Dollar", "InvoiceCurrencyCode": "USD", "InvoiceCreationDate": "02/27/17", "ProcurementBU": "Vision Operations", "ProcurementBUID": 204, "Supplier": "zBIA_Supplier_02", "SupplierID": 300100000344256, "SupplierSite": "zBIA_Supplier_0", "SupplierSiteID": 300100000344273, "TradeOperationName": "zR13OTBI_TR003", "TradeOperationNumber": "8", ... }, ... ] ... }
Example 6 cURL Command
Use the following cURL command to submit a request on the REST resource to get invoices for landed cost by charge name:
curl -u username:password "https://servername/fscmRestApi/resources/version/invoicesForLandedCostCharges?finder=findInvoicesForCharges;bindChargeName=SS_Freight"
Example 6 Response Body
The following shows an example of the response body in JSON format.
{ "items":[ { "AssociationMode": "Automatic", "AssociationModeCode": 1, "AssociationStatus": "Associated", "ChargeName": "SS_Freight", "ChargeCode": "SS_Freight", "ChargeID": 300100071793249, "ChargeBU": "Vision Operations", "ChargeBUID": 204, "MissingChargeReferences": "false", "InvoiceNumber": "zR13OTBI_P2P_LCM_001", "InvoiceID": 300100100238973, "InvoiceLineNumber": "1", "InvoiceLineType": "ITEM", "InvoiceAmount": 75, "InvoiceNonrecoverableTaxAmount": 0, "InvoiceCurrency": "US Dollar", "InvoiceCurrencyCode": "USD", "InvoiceCreationDate": "02/27/17", "ProcurementBU": "Vision Operations", "ProcurementBUID": 204, "Supplier": "zBIA_Supplier_02", "SupplierID": 300100000344256, "SupplierSite": "zBIA_Supplier_0", "SupplierSiteID": 300100000344273, "TradeOperationName": "zR13OTBI_TR003", "TradeOperationNumber": "8", ... }, ... ] ... }
Example 7 cURL Command
Use the following cURL command to submit a request on the REST resource to get invoices for landed cost by invoice currency:
curl -u username:password "https://servername/fscmRestApi/resources/version/invoicesForLandedCostCharges?finder=findInvoicesForCharges;bindInvoiceCurrency=US Dollar"
Example 7 Response Body
The following shows an example of the response body in JSON format.
{ "items":[ { "AssociationMode": "Automatic", "AssociationModeCode": 1, "AssociationStatus": "Associated", "ChargeName": "SS_Freight", "ChargeCode": "SS_Freight", "ChargeID": 300100071793249, "ChargeBU": "Vision Operations", "ChargeBUID": 204, "MissingChargeReferences": "false", "InvoiceNumber": "zR13OTBI_P2P_LCM_001", "InvoiceID": 300100100238973, "InvoiceLineNumber": "1", "InvoiceLineType": "ITEM", "InvoiceAmount": 75, "InvoiceNonrecoverableTaxAmount": 0, "InvoiceCurrency": "US Dollar", "InvoiceCurrencyCode": "USD", "InvoiceCreationDate": "02/27/17", "ProcurementBU": "Vision Operations", "ProcurementBUID": 204, "Supplier": "zBIA_Supplier_02", "SupplierID": 300100000344256, "SupplierSite": "zBIA_Supplier_0", "SupplierSiteID": 300100000344273, "TradeOperationName": "zR13OTBI_TR003", "TradeOperationNumber": "8", ... }, ... ] ... }
Example 8 cURL Command
Use the following cURL command to submit a request on the REST resource to get invoices for landed cost by invoice number and invoice line number:
curl -u username:password "https://servername/fscmRestApi/resources/version/invoicesForLandedCostCharges?finder=findInvoicesForCharges;bindInvoiceNumber=SS002,bindInvoiceLineNumber=1"
Example 8 Response Body
The following shows an example of the response body in JSON format.
{ "items":[ { "AssociationMode": null, "AssociationModeCode": null, "AssociationStatus": "No match", "ChargeName": "SS_Handling", "ChargeCode": "SS_Handling", "ChargeID": 300100071793255, "ChargeBU": "Vision Operations", "ChargeBUID": 204, "MissingChargeReferences": "true", "InvoiceNumber": "SS002", "InvoiceID": 300100071634153, "InvoiceLineNumber": "1", "InvoiceLineType": "ITEM", "InvoiceAmount": 2000, "InvoiceNonrecoverableTaxAmount": 0, "InvoiceCurrency": "US Dollar", "InvoiceCurrencyCode": "USD", "InvoiceCreationDate": "03/12/15", "ProcurementBU": "Vision Operations", "ProcurementBUID": 204, "Supplier": "PennyPack Systems", "SupplierID": 21, "SupplierSite": "FRESNO", "SupplierSiteID": 1969, "TradeOperationName": null, "TradeOperationNumber": null, "links":[ { "rel": "self", "href": "https://servername/fscmRestApi/resources/version/invoicesForLandedCostCharges/00040000000EACED00057708000110F07E2AB4ED00000001310000000EACED00057708000110F07E2AB4ED0000000EACED000577080000000000000001", "name": "invoicesForLandedCostCharges", "kind": "item", }, {"rel": "canonical", "href": "https://servername/fscmRestApi/resources/version/invoicesForLandedCostCharges/00040000000EACED00057708000110F07E2AB4ED00000001310000000EACED00057708000110F07E2AB4ED0000000EACED000577080000000000000001",...}, { "rel": "child", "href": "https://servername/fscmRestApi/resources/version/invoicesForLandedCostCharges/00040000000EACED00057708000110F07E2AB4ED00000001310000000EACED00057708000110F07E2AB4ED0000000EACED000577080000000000000001/child/landedCostChargeReferencesForInvoiceLines", "name": "landedCostChargeReferencesForInvoiceLines", "kind": "collection" } ] } ], "count": 1, "hasMore": false, "limit": 25, "offset": 0, }
Example 9 cURL Command
Use the following cURL command to submit a request on the REST resource to get invoices for landed cost by invoice non-recoverable tax amount:
curl -u username:password "https://servername/fscmRestApi/resources/version/invoicesForLandedCostCharges?finder=findInvoicesForCharges;bindInvoiceNonrecoverableTaxAmount=67.54"
Example 9 Response Body
The following shows an example of the response body in JSON format.
{ "items":[ { "AssociationMode": null, "AssociationModeCode": null, "AssociationStatus": "No match", "ChargeName": "SS_Handling", "ChargeCode": "SS_Handling", "ChargeID": 300100071793255, "ChargeBU": "Vision Operations", "ChargeBUID": 204, "MissingChargeReferences": "true", "InvoiceNumber": "SS002", "InvoiceID": 300100071634153, "InvoiceLineNumber": "1", "InvoiceLineType": "ITEM", "InvoiceAmount": 2000, "InvoiceNonrecoverableTaxAmount": "67.54 ""InvoiceCurrency": "US Dollar", "InvoiceCurrencyCode": "USD", "InvoiceCreationDate": "03/12/15", "ProcurementBU": "Vision Operations", "ProcurementBUID": 204, "Supplier": "PennyPack Systems", "SupplierID": 21, "SupplierSite": "FRESNO", "SupplierSiteID": 1969, "TradeOperationName": null, "TradeOperationNumber": null, "links":[ { "rel": "self", "href": "https://servername/fscmRestApi/resources/version/invoicesForLandedCostCharges/00040000000EACED00057708000110F07E2AB4ED00000001310000000EACED00057708000110F07E2AB4ED0000000EACED000577080000000000000001", "name": "invoicesForLandedCostCharges", "kind": "item", }, {"rel": "canonical", "href": "https://servername/fscmRestApi/resources/version/invoicesForLandedCostCharges/00040000000EACED00057708000110F07E2AB4ED00000001310000000EACED00057708000110F07E2AB4ED0000000EACED000577080000000000000001",...}, { "rel": "child", "href": "https://servername/fscmRestApi/resources/version/invoicesForLandedCostCharges/00040000000EACED00057708000110F07E2AB4ED00000001310000000EACED00057708000110F07E2AB4ED0000000EACED000577080000000000000001/child/landedCostChargeReferencesForInvoiceLines", "name": "landedCostChargeReferencesForInvoiceLines", "kind": "collection" } ] } ], "count": 1, "hasMore": false, "limit": 25, "offset": 0, }
Example 10 cURL Command
Use the following cURL command to submit a request on the REST resource get invoices for landed cost by supplier and supplier site:
curl -u username:password "https://servername/fscmRestApi/resources/version/invoicesForLandedCostCharges?finder=findInvoicesForCharges;bindSupplier=PennyPack Systems,bindSupplierSite=FRESNO"
Example 10 Response Body
The following shows an example of the response body in JSON format.
{ "items":[ { "AssociationMode": null, "AssociationModeCode": null, "AssociationStatus": "No match", "ChargeName": "SS_Handling", "ChargeCode": "SS_Handling", "ChargeID": 300100071793255, "ChargeBU": "Vision Operations", "ChargeBUID": 204, "MissingChargeReferences": "true", "InvoiceNumber": "SS002", "InvoiceID": 300100071634153, "InvoiceLineNumber": "1", "InvoiceLineType": "ITEM", "InvoiceAmount": 2000, "InvoiceNonrecoverableTaxAmount": "67.54" "InvoiceCurrency": "US Dollar", "InvoiceCurrencyCode": "USD", "InvoiceCreationDate": "03/12/15", "ProcurementBU": "Vision Operations", "ProcurementBUID": 204, "Supplier": "PennyPack Systems", "SupplierID": 21, "SupplierSite": "FRESNO", "SupplierSiteID": 1969, "TradeOperationName": null, "TradeOperationNumber": null, "links":[ { "rel": "self", "href": "https://servername/fscmRestApi/resources/version/invoicesForLandedCostCharges/00040000000EACED00057708000110F07E2AB4ED00000001310000000EACED00057708000110F07E2AB4ED0000000EACED000577080000000000000001", "name": "invoicesForLandedCostCharges", "kind": "item", }, {"rel": "canonical", "href": "https://servername/fscmRestApi/resources/version/invoicesForLandedCostCharges/00040000000EACED00057708000110F07E2AB4ED00000001310000000EACED00057708000110F07E2AB4ED0000000EACED000577080000000000000001",...}, { "rel": "child", "href": "https://servername/fscmRestApi/resources/version/invoicesForLandedCostCharges/00040000000EACED00057708000110F07E2AB4ED00000001310000000EACED00057708000110F07E2AB4ED0000000EACED000577080000000000000001/child/landedCostChargeReferencesForInvoiceLines", "name": "landedCostChargeReferencesForInvoiceLines", "kind": "collection" } ] } ], "count": 1, "hasMore": false, "limit": 25, "offset": 0, }
Example 11 cURL Command
Use the following cURL command to submit a request on the REST resource to get invoices for landed cost by charge reference name:
curl -u username:password "https://servername/fscmRestApi/resources/version/invoicesForLandedCostCharges?finder=findInvoicesForCharges;bindChargeReferenceName=Handling_Ref"
Example 11 Response Body
The following shows an example of the response body in JSON format.
{ "items":[ { "AssociationMode": "Automatic", "AssociationModeCode": 1, "AssociationStatus": "Associated", "ChargeName": "SS_Handling", "ChargeCode": "SS_Handling", "ChargeID": 300100071793255, "ChargeBU": "Vision Operations", "ChargeBUID": 204, "MissingChargeReferences": "false", "InvoiceNumber": "SS007", "InvoiceID": 300100089897318, "InvoiceLineNumber": "1", "InvoiceLineType": "ITEM", "InvoiceAmount": 75, "InvoiceNonrecoverableTaxAmount": 0, "InvoiceCurrency": "US Dollar", "InvoiceCurrencyCode": "USD", "InvoiceCreationDate": "-2/23/17", "ProcurementBU": "Vision Operations", "ProcurementBUID": 204, "Supplier": "PennyPack Systems", "SupplierID": 21, "SupplierSite": "03", "SupplierSiteID": 1712, "TradeOperationName": "Exp Dest", "TradeOperationNumber": "7", "links":[ { "rel": "self", "href": "https://servername/fscmRestApi/resources/version/invoicesForLandedCostCharges/00040000000EACED00057708000110F07E2AB4ED00000001310000000EACED00057708000110F07E2AB4ED0000000EACED000577080000000000000001", "name": "invoicesForLandedCostCharges", "kind": "item", }, {"rel": "canonical", "href": "https://servername/fscmRestApi/resources/version/invoicesForLandedCostCharges/00040000000EACED00057708000110F07E2AB4ED00000001310000000EACED00057708000110F07E2AB4ED0000000EACED000577080000000000000001",...}, { "rel": "child", "href": "https://servername/fscmRestApi/resources/version/invoicesForLandedCostCharges/00040000000EACED00057708000110F07E2AB4ED00000001310000000EACED00057708000110F07E2AB4ED0000000EACED000577080000000000000001/child/landedCostChargeReferencesForInvoiceLines", "name": "landedCostChargeReferencesForInvoiceLines", "kind": "collection" } ] } ], "count": :4 "hasMore": false, "limit": 25, "offset": 0, }
Example 12 cURL Command
Use the following cURL command to submit a request on the REST resource get invoices for landed cost by reference value text:
curl -u username:password "https://servername/fscmRestApi/resources/version/invoicesForLandedCostCharges?finder=findInvoicesForCharges;bindRefValueText=SS1510"
Example 12 Response Body
The following shows an example of the response body in JSON format.
{ "items":[ { "AssociationMode": null, "AssociationModeCode": null, "AssociationStatus": "New", "ChargeName": "SS_Discount", "ChargeCode": "SS_Discount", "ChargeID": 300100071793246, "ChargeBU": "Vision Operations", "ChargeBUID": 204, "MissingChargeReferences": "false", "InvoiceNumber": "SS003", "InvoiceID": 300100071634155, "InvoiceLineNumber": "1", "InvoiceLineType": "ITEM", "InvoiceAmount": 100, "InvoiceNonrecoverableTaxAmount": 0, "InvoiceCurrency": "US Dollar", "InvoiceCurrencyCode": "USD", "InvoiceCreationDate": "03/12/15", "ProcurementBU": "Vision Operations", "ProcurementBUID": 204, "Supplier": "PennyPack Systems", "SupplierID": 21, "SupplierSite": "FRESNO", "SupplierSiteID": 1969, "TradeOperationName": null, "TradeOperationNumber": null, "links":[ { "rel": "self", "href": "https://servername/fscmRestApi/resources/version/invoicesForLandedCostCharges/00040000000EACED00057708000110F07E2AB4ED00000001310000000EACED00057708000110F07E2AB4ED0000000EACED000577080000000000000001", "name": "invoicesForLandedCostCharges", "kind": "item", }, {"rel": "canonical", "href": "https://servername/fscmRestApi/resources/version/invoicesForLandedCostCharges/00040000000EACED00057708000110F07E2AB4ED00000001310000000EACED00057708000110F07E2AB4ED0000000EACED000577080000000000000001",...}, { "rel": "child", "href": "https://servername/fscmRestApi/resources/version/invoicesForLandedCostCharges/00040000000EACED00057708000110F07E2AB4ED00000001310000000EACED00057708000110F07E2AB4ED0000000EACED000577080000000000000001/child/landedCostChargeReferencesForInvoiceLines", "name": "landedCostChargeReferencesForInvoiceLines", "kind": "collection" } ] } ], "count": :1 "hasMore": false, "limit": 25, "offset": 0, }
Example 13 cURL Command
Use the following cURL command to submit a request on the REST resource to get invoices for landed cost by predefined flag:
curl -u username:password "https://servername/fscmRestApi/resources/version/invoicesForLandedCostCharges?finder=findInvoicesForCharges;bindChargeRefPredefined=true"
Example 13 Response Body
The following shows an example of the response body in JSON format.
{ "items":[ { "AssociationMode": "Automatic", "AssociationModeCode": 1, "AssociationStatus": "Associated", "ChargeName": "SS_Handling", "ChargeCode": "SS_Handling", "ChargeID": 300100071793255, "ChargeBU": "Vision Operations", "ChargeBUID": 204, "MissingChargeReferences": "false", "InvoiceNumber": "SS007", "InvoiceID": 300100089897318, "InvoiceLineNumber": "1", "InvoiceLineType": "ITEM", "InvoiceAmount": 75, "InvoiceNonrecoverableTaxAmount": 0, "InvoiceCurrency": "US Dollar", "InvoiceCurrencyCode": "USD", "InvoiceCreationDate": "02/23/17", "ProcurementBU": "Vision Operations", "ProcurementBUID": 204, "Supplier": "PennyPack Systems", "SupplierID": 21, "SupplierSite": "03", "SupplierSiteID": 1712, "TradeOperationName": "Exp Dest", "TradeOperationNumber": "7", "links":[ { "rel": "self", "href": "https://servername/fscmRestApi/resources/version/invoicesForLandedCostCharges/00040000000EACED00057708000110F07E2AB4ED00000001310000000EACED00057708000110F07E2AB4ED0000000EACED000577080000000000000001", "name": "invoicesForLandedCostCharges", "kind": "item", }, {"rel": "canonical", "href": "https://servername/fscmRestApi/resources/version/invoicesForLandedCostCharges/00040000000EACED00057708000110F07E2AB4ED00000001310000000EACED00057708000110F07E2AB4ED0000000EACED000577080000000000000001",...}, { "rel": "child", "href": "https://servername/fscmRestApi/resources/version/invoicesForLandedCostCharges/00040000000EACED00057708000110F07E2AB4ED00000001310000000EACED00057708000110F07E2AB4ED0000000EACED000577080000000000000001/child/landedCostChargeReferencesForInvoiceLines", "name": "landedCostChargeReferencesForInvoiceLines", "kind": "collection" } ] } ], "count": :4 "hasMore": false, "limit": 25, "offset": 0, }
Example 14 cURL Command
Use the following cURL command to submit a request on the REST resource to get invoices for landed cost by procurement business unit and shows only invoices missing charge names:
curl -u username:password "https://servername/fscmRestApi/resources/version/invoicesForLandedCostCharges?finder=findInvoicesForCharges;bindProcurementBU=Vision Operations,bindMissingChargeNames=true"
Example 14 Response Body
The following shows an example of the response body in JSON format.
{ "items":[ { "AssociationMode": null, "AssociationModeCode": null, "AssociationStatus": "New", "ChargeName": null, "ChargeCode": null, "ChargeID": null, "ChargeBU": null, "ChargeBUID": null, "MissingChargeReferences": "true", "InvoiceNumber": "LCMINVREL12CDRM001", "InvoiceID": 300100089904233, "InvoiceLineNumber": "1", "InvoiceLineType": "ITEM", "InvoiceAmount": 150, "InvoiceNonrecoverableTaxAmount": 0, "InvoiceCurrency": "US Dollar", "InvoiceCurrencyCode": "USD", "InvoiceCreationDate": "02/23/17", "ProcurementBU": "Vision Operations", "ProcurementBUID": 204, "Supplier": "PennyPack Systems", "SupplierID": 21, "SupplierSite": "FRESNO", "SupplierSiteID": 1969, "TradeOperationName": null, "TradeOperationNumber": null, "links":[ { "rel": "self", "href": "https://servername/fscmRestApi/resources/version/invoicesForLandedCostCharges/00040000000EACED00057708000110F07E2AB4ED00000001310000000EACED00057708000110F07E2AB4ED0000000EACED000577080000000000000001", "name": "invoicesForLandedCostCharges", "kind": "item", }, {"rel": "canonical", "href": "https://servername/fscmRestApi/resources/version/invoicesForLandedCostCharges/00040000000EACED00057708000110F07E2AB4ED00000001310000000EACED00057708000110F07E2AB4ED0000000EACED000577080000000000000001",...}, { "rel": "child", "href": "https://servername/fscmRestApi/resources/version/invoicesForLandedCostCharges/00040000000EACED00057708000110F07E2AB4ED00000001310000000EACED00057708000110F07E2AB4ED0000000EACED000577080000000000000001/child/landedCostChargeReferencesForInvoiceLines", "name": "landedCostChargeReferencesForInvoiceLines", "kind": "collection" } ] } ], "count": :1 "hasMore": false, "limit": 25, "offset": 0, }
Example 15 cURL Command
Use the following cURL command to submit a request on the REST resource to get invoices for landed cost by procurement business unit and shows only invoices missing reference types:
curl -u username:password "https://servername/fscmRestApi/resources/version/invoicesForLandedCostCharges?finder=findInvoicesForCharges;bindProcurementBU=Vision Operations,bindMissingChargeReferences=true"
Example 15 Response Body
The following shows an example of the response body in JSON format.
{ "items":[ { "AssociationMode": null, "AssociationModeCode": null, "AssociationStatus": "No match", "ChargeName": "SS_Handling", "ChargeCode": "SS_Handling", "ChargeID": 300100071793255, "ChargeBU": "Vision Operations", "ChargeBUID": 204, "MissingChargeReferences": "true", "InvoiceNumber": "SS002", "InvoiceID": 300100071634153, "InvoiceLineNumber": "1", "InvoiceLineType": "ITEM", "InvoiceAmount": 2000, "InvoiceNonrecoverableTaxAmount": 0, "InvoiceCurrency": "US Dollar", "InvoiceCurrencyCode": "USD", "InvoiceCreationDate": "03/12/15", "ProcurementBU": "Vision Operations", "ProcurementBUID": 204, "Supplier": "PennyPack Systems", "SupplierID": 21, "SupplierSite": "FRESNO", "SupplierSiteID": 1969, "TradeOperationName": null, "TradeOperationNumber": null, "links":[ { "rel": "self", "href": "https://servername/fscmRestApi/resources/version/invoicesForLandedCostCharges/00040000000EACED00057708000110F07E2AB4ED00000001310000000EACED00057708000110F07E2AB4ED0000000EACED000577080000000000000001", "name": "invoicesForLandedCostCharges", "kind": "item", }, {"rel": "canonical", "href": "https://servername/fscmRestApi/resources/version/invoicesForLandedCostCharges/00040000000EACED00057708000110F07E2AB4ED00000001310000000EACED00057708000110F07E2AB4ED0000000EACED000577080000000000000001",...}, { "rel": "child", "href": "https://servername/fscmRestApi/resources/version/invoicesForLandedCostCharges/00040000000EACED00057708000110F07E2AB4ED00000001310000000EACED00057708000110F07E2AB4ED0000000EACED000577080000000000000001/child/landedCostChargeReferencesForInvoiceLines", "name": "landedCostChargeReferencesForInvoiceLines", "kind": "collection" } ] } ], "count": :2 "hasMore": false, "limit": 25, "offset": 0, }
Example 16 cURL Command
Use the following cURL command to submit a request on the REST resource to get invoices for landed cost by invoice creation date that is in the mm/dd/yy format:
curl -u username:password "https://servername/fscmRestApi/resources/version/invoicesForLandedCostCharges?finder=findInvoicesForCharges;bindInvoiceCreationDate=02/23/17"
Example 16 Response Body
The following shows an example of the response body in JSON format.
{ "items":[ { "AssociationMode": null, "AssociationModeCode": null, "AssociationStatus": "No match", "ChargeName": "SS_Handling", "ChargeCode": "SS_Handling", "ChargeID": 300100071793255, "ChargeBU": "Vision Operations", "ChargeBUID": 204, "MissingChargeReferences": "true", "InvoiceNumber": "SS002", "InvoiceID": 300100071634153, "InvoiceLineNumber": "1", "InvoiceLineType": "ITEM", "InvoiceAmount": 2000, "InvoiceNonrecoverableTaxAmount": 0, "InvoiceCurrency": "US Dollar", "InvoiceCurrencyCode": "USD", "InvoiceCreationDate": "02/23/17", "ProcurementBU": "Vision Operations", "ProcurementBUID": 204, "Supplier": "PennyPack Systems", "SupplierID": 21, "SupplierSite": "FRESNO", "SupplierSiteID": 1969, "TradeOperationName": null, "TradeOperationNumber": null, "links":[ { "rel": "self", "href": "https://servername/fscmRestApi/resources/version/invoicesForLandedCostCharges/00040000000EACED00057708000110F07E2AB4ED00000001310000000EACED00057708000110F07E2AB4ED0000000EACED000577080000000000000001", "name": "invoicesForLandedCostCharges", "kind": "item", }, {"rel": "canonical", "href": "https://servername/fscmRestApi/resources/version/invoicesForLandedCostCharges/00040000000EACED00057708000110F07E2AB4ED00000001310000000EACED00057708000110F07E2AB4ED0000000EACED000577080000000000000001",...}, { "rel": "child", "href": "https://servername/fscmRestApi/resources/version/invoicesForLandedCostCharges/00040000000EACED00057708000110F07E2AB4ED00000001310000000EACED00057708000110F07E2AB4ED0000000EACED000577080000000000000001/child/landedCostChargeReferencesForInvoiceLines", "name": "landedCostChargeReferencesForInvoiceLines", "kind": "collection" } ] } ], "count": :2 "hasMore": false, "limit": 25, "offset": 0, }