Jump to

• Request
• Response
• Examples

Get all joint venture general ledger transactions

get

/fscmRestApi/resources/11.13.18.05/jointVentureGLTransactions

Request

Query Parameters

• 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: Finds the joint venture transaction that matches the primary key criteria specified.
    Finder Variables:
    • transactionId; integer; The unique identifier of the joint venture transaction.
  • findByStatusNotComplete: Finds all joint venture transactions where status is not set to Process Complete.
    Finder Variables:
  • jointVentureTransactionFinder: Finds all joint venture transactions originating from the general ledger.
    Finder Variables:
    • assignmentRule; string.
    • carriedInterestAgreement; string.
    • carriedInterestAgreementDescription; string.
    • carriedInterestSourceOwnerDefinition; string.
    • createdBy; string; The user who created the joint venture transaction.
    • jointVentureDescription; string; The joint venture description.
    • jointVentureShortName; string; The unique name of the joint venture, which is stored as the short name.
    • journalDescription; string; The description of the journal line.
    • lastUpdatedBy; string; The user who last updated the joint venture transaction.
    • ledgerName; string; The name of the ledger.
    • originalOwnerDefinitionShortName; string; The short name of the original ownership definition assigned to the joint venture transaction.
    • originalStakeholderDescription; string; The description of the original stakeholder.
    • originalStakeholderShortName; string; The short name of the original stakeholder assigned to the joint venture transaction.
    • ownerDefinitionShortName; string; The short name of the ownership definition assigned to the transaction as an override.
    • periodName; string; The accounting period name in a calendar.
    • searchAllText; string; A search value to identify joint venture transactions that contain the specified text in any of the string attributes.
    • stakeholderDescription; string; The description of the override joint venture stakeholder.
    • stakeholderShortName; string; The short name of the joint venture stakeholder assigned to the transaction as an override.
    • transactionStatus; string; The joint venture transaction status.
• 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:
  

  • account; string; The combination of the values of the account segments assigned to the transaction.
  • accountedCreditAmount; number; The transaction credit amount in accounting currency.
  • accountedDebitAmount; number; The transaction debit amount in accounting currency.
  • assignmentRule; string; The name of the ownership definition assignment rule used to assign the ownership definition or direct billed stakeholder.
  • batchId; integer; The unique identifier of the batch.
  • carriedInterestAgreement; string; The name of the carried interest agreement associated with the joint venture transaction.
  • carriedInterestAgreementDescription; string; The description of the carried interest agreement associated with the joint venture transaction.
  • carriedInterestSourceOwnerDefinition; string; The name of the ownership definition used as the basis for creating the carried interest ownership definition assigned to the transaction.
  • chartOfAccountsId; integer; The unique identifier of the chart of accounts structure instance.
  • createdBy; string; The user who created the joint venture transaction.
  • creationDate; string; The date and time when the joint venture transaction was created.
  • currencyCode; string; The currency of the transaction amount.
  • distributionOnlyFlag; boolean; Indicates whether the transaction is for distribution only, not for invoicing.
  • effectiveDate; string; The accounting date of the journal.
  • enteredCreditAmount; number; The transaction credit amount in the entered currency.
  • enteredCurrencyCode; string; The currency code entered on the original transaction.
  • enteredDebitAmount; number; The transaction debit amount in the entered currency.
  • headerId; integer; The unique identifier of the journal.
  • jointVentureDescription; string; The description of the joint venture.
  • jointVentureShortName; string; The unique name of the joint venture.
  • journalDescription; string; The description of the general ledger journal entry line.
  • journalStatus; string; The journal entry line status code.
  • lastUpdateDate; string; The date and time when the joint venture transaction was last updated.
  • lastUpdatedBy; string; The user who last updated the joint venture transaction.
  • ledgerName; string; The name of the ledger.
  • lineNumber; integer; The number of the journal line.
  • originalOwnerDefinitionShortName; string; The original ownership definition assigned to the joint venture transaction.
  • originalStakeholderDescription; string; The description of the original stakeholder.
  • originalStakeholderShortName; string; The original stakeholder assigned to the joint venture transaction.
  • ownerDefinitionShortName; string; The short name of the ownership definition assigned to the transaction as an override.
  • periodName; string; The accounting period name in a calendar.
  • stakeholderDescription; string; The description of the override joint venture stakeholder.
  • stakeholderShortName; string; The name of the joint venture stakeholder assigned to the transaction as an override.
  • statisticalAmount; number; The statistical unit of measure of the journal entry line.
  • transactionDate; string; The date when the transaction occurred, which may be different from the journal entry effective date or subledger accounting date.
  • transactionId; integer; The unique identifier of the joint venture transaction.
  • transactionStatus; string; The status of the joint venture transaction.
• 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".

Header Parameters

• 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 Top

Response

Supported Media Types

• application/json

Default Response

The following table describes the default response for this task.

Headers

• Metadata-Context(required):
  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(required):
  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.

Body ()

Root Schema : jointVentureGLTransactions

Type: object

Show Source

• 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.

{
    "required":[
        "count",
        "hasMore",
        "limit",
        "links",
        "offset"
    ],
    "type":"object",
    "properties":{
        "totalResults":{
            "type":"integer",
            "description":"The estimated row count when \"?totalResults=true\", otherwise the count is not included."
        },
        "offset":{
            "type":"integer",
            "description":"The offset value used in the current page."
        },
        "count":{
            "type":"integer",
            "description":"The number of resource instances returned in the current range."
        },
        "hasMore":{
            "type":"boolean",
            "description":"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."
        },
        "limit":{
            "type":"integer",
            "description":"The actual paging size used by the server."
        },
        "links":{
            "title":"Links",
            "type":"array",
            "description":"The link relations associated with the resource instance.",
            "items":{
                "$ref":"#/components/schemas/link"
            }
        },
        "items":{
            "title":"Items",
            "type":"array",
            "description":"The items in the collection.",
            "items":{
                "$ref":"#/components/schemas/jointVentureGLTransactions-item-response"
            }
        }
    },
    "x-hints":{
        "usage":"BusinessObject"
    }
}

Nested Schema : Items

Type: array

Title: Items

The items in the collection.

Show Source

• Array of: object jointVentureGLTransactions-item-response

{
    "title":"Items",
    "type":"array",
    "description":"The items in the collection.",
    "items":{
        "$ref":"#/components/schemas/jointVentureGLTransactions-item-response"
    }
}

Nested Schema : Links

Type: array

Title: Links

The link relations associated with the resource instance.

Show Source

• Array of: object link

{
    "title":"Links",
    "type":"array",
    "description":"The link relations associated with the resource instance.",
    "items":{
        "$ref":"#/components/schemas/link"
    }
}

Nested Schema : jointVentureGLTransactions-item-response

Type: object

Show Source

• account: string
  Title: Account

  Read Only: true

  The combination of the values of the account segments assigned to the transaction.
• accountedCreditAmount: number
  Title: Accounted Credit

  Read Only: true

  The transaction credit amount in accounting currency.
• accountedDebitAmount: number
  Title: Accounted Debit

  Read Only: true

  The transaction debit amount in accounting currency.
• assignmentRule: string
  Title: Assignment Rule

  Read Only: true

  Maximum Length: 30

  The name of the ownership definition assignment rule used to assign the ownership definition or direct billed stakeholder.
• batchId: integer (int64)
  Title: Batch ID

  Read Only: true

  The unique identifier of the batch.
• carriedInterestAgreement: string
  Title: Agreement

  Read Only: true

  Maximum Length: 30

  The name of the carried interest agreement associated with the joint venture transaction.
• carriedInterestAgreementDescription: string
  Title: Description

  Read Only: true

  Maximum Length: 240

  The description of the carried interest agreement associated with the joint venture transaction.
• carriedInterestSourceOwnerDefinition: string
  Title: Source Ownership Definition

  Read Only: true

  Maximum Length: 30

  The name of the ownership definition used as the basis for creating the carried interest ownership definition assigned to the transaction.
• changeReason: string
  Title: Change Reason

  The reason for the manual change to the joint venture transaction.
• changeReasonDetails: string
  Title: Change Reason Details

  Additional text to describe the reason the joint venture transaction was manually changed.
• chartOfAccountsId: integer (int64)
  Title: Chart of Accounts

  Read Only: true

  The unique identifier of the chart of accounts structure instance.
• createdBy: string
  Title: Created By

  Read Only: true

  Maximum Length: 64

  The user who created the joint venture transaction.
• creationDate: string (date-time)
  Title: Creation Date

  Read Only: true

  The date and time when the joint venture transaction was created.
• currencyCode: string
  Title: Accounting Currency

  Read Only: true

  Maximum Length: 15

  The currency of the transaction amount.
• distributionOnlyFlag: boolean
  Title: Distribution Only

  Maximum Length: 1

  Default Value: false

  Indicates whether the transaction is for distribution only, not for invoicing.
• effectiveDate: string (date)
  Title: Accounting Date

  Read Only: true

  The accounting date of the journal.
• enteredCreditAmount: number
  Title: Entered Credit

  Read Only: true

  The transaction credit amount in the entered currency.
• enteredCurrencyCode: string
  Title: Entered Currency

  Read Only: true

  Maximum Length: 15

  The currency code entered on the original transaction.
• enteredDebitAmount: number
  Title: Entered Debit

  Read Only: true

  The transaction debit amount in the entered currency.
• headerId: integer (int64)
  Title: Header ID

  Read Only: true

  The unique identifier of the journal.
• jointVentureDescription: string
  Title: Joint Venture Description

  Read Only: true

  Maximum Length: 240

  The description of the joint venture.
• jointVentureShortName: string
  Title: Joint Venture

  Read Only: true

  Maximum Length: 30

  The unique name of the joint venture.
• journalDescription: string
  Title: Transaction Description

  Read Only: true

  Maximum Length: 240

  The description of the general ledger journal entry line.
• journalStatus: string
  Title: Journal Status

  Read Only: true

  Maximum Length: 1

  The journal entry line status code.
• lastUpdateDate: string (date-time)
  Title: Last Updated Date

  Read Only: true

  The date and time when the joint venture transaction was last updated.
• lastUpdatedBy: string
  Title: Last Updated By

  Read Only: true

  Maximum Length: 64

  The user who last updated the joint venture transaction.
• ledgerName: string
  Title: Ledger Name

  Read Only: true

  Maximum Length: 30

  The name of the ledger.
• lineNumber: integer (int64)
  Title: Line Number

  Read Only: true

  The number of the journal line.
• links: array Links
  Title: Links

  The link relations associated with the resource instance.
• originalOwnerDefinitionShortName: string
  Title: Original Ownership Definition

  Read Only: true

  Maximum Length: 20

  The original ownership definition assigned to the joint venture transaction.
• originalStakeholderDescription: string
  Title: Original Stakeholder Description

  Read Only: true

  Maximum Length: 240

  The description of the original stakeholder.
• originalStakeholderShortName: string
  Title: Original Direct Billed Stakeholder

  Read Only: true

  Maximum Length: 30

  The original stakeholder assigned to the joint venture transaction.
• ownerDefinitionShortName: string
  Title: Ownership Definition

  Maximum Length: 30

  The short name of the ownership definition assigned to the transaction as an override.
• periodName: string
  Title: Period Name

  Read Only: true

  Maximum Length: 15

  The accounting period name in a calendar.
• stakeholderDescription: string
  Title: Stakeholder Description

  Maximum Length: 255

  The description of the override joint venture stakeholder.
• stakeholderShortName: string
  Title: Direct Billed Stakeholder

  Maximum Length: 30

  The name of the joint venture stakeholder assigned to the transaction as an override.
• statisticalAmount: number
  Title: Units

  Read Only: true

  The statistical unit of measure of the journal entry line.
• transactionAccount: array Account Key Flexfields
  Title: Account Key Flexfields

  The code identifying the general ledger account against which amounts are recorded. These represent assets, liabilities, revenues, expenses, and fund balances.
• transactionChanges: array Joint Venture Transaction Changes
  Title: Joint Venture Transaction Changes

  The joint venture transaction changes resource is used to view the history of manual changes to joint venture transactions.
• transactionChangesExistFlag: boolean
  Title: Transaction Changes Exist

  Read Only: true

  Maximum Length: 255

  Indicates whether manual changes have been made to a transaction.
• transactionDate: string (date)
  Title: Transaction Date

  The date when the transaction occurred, which may be different from the journal entry effective date or subledger accounting date.
• transactionDFF: array transactionDFF
• transactionId: integer (int64)
  Title: Transaction ID

  Read Only: true

  The unique identifier of the joint venture transaction.
• transactionStatus: string
  Title: Transaction Status

  Maximum Length: 80

  The status of the joint venture transaction.

{
    "type":"object",
    "properties":{
        "assignmentRule":{
            "title":"Assignment Rule",
            "maxLength":30,
            "type":"string",
            "description":"The name of the ownership definition assignment rule used to assign the ownership definition or direct billed stakeholder.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "ledgerName":{
            "title":"Ledger Name",
            "maxLength":30,
            "type":"string",
            "description":"The name of the ledger.",
            "nullable":false,
            "readOnly":true,
            "x-queryable":true
        },
        "originalOwnerDefinitionShortName":{
            "title":"Original Ownership Definition",
            "maxLength":20,
            "type":"string",
            "description":"The original ownership definition assigned to the joint venture transaction.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "lastUpdateDate":{
            "title":"Last Updated Date",
            "type":"string",
            "description":"The date and time when the joint venture transaction was last updated.",
            "format":"date-time",
            "nullable":false,
            "readOnly":true,
            "x-queryable":true
        },
        "journalStatus":{
            "title":"Journal Status",
            "maxLength":1,
            "type":"string",
            "description":"The journal entry line status code.",
            "nullable":false,
            "readOnly":true,
            "x-queryable":true
        },
        "carriedInterestAgreement":{
            "title":"Agreement",
            "maxLength":30,
            "type":"string",
            "description":"The name of the carried interest agreement associated with the joint venture transaction.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "periodName":{
            "title":"Period Name",
            "maxLength":15,
            "type":"string",
            "description":"The accounting period name in a calendar.",
            "nullable":false,
            "readOnly":true,
            "x-queryable":true
        },
        "batchId":{
            "title":"Batch ID",
            "type":"integer",
            "description":"The unique identifier of the batch.",
            "format":"int64",
            "nullable":false,
            "readOnly":true,
            "x-hints":{
                "precision":18
            },
            "x-queryable":true
        },
        "chartOfAccountsId":{
            "title":"Chart of Accounts",
            "type":"integer",
            "description":"The unique identifier of the chart of accounts structure instance.",
            "format":"int64",
            "nullable":false,
            "readOnly":true,
            "x-hints":{
                "FND_ACFF_FlexfieldCode":"GL#",
                "FND_ACFF_StructureID":"transactionAccount",
                "precision":18,
                "FND_ACFF_ApplicationID":"101",
                "FND_ACFF_StructureLookupRequired":"false",
                "FND_ACFF_ModelID":"KFF_GL_GL_23_GL_23_GL_5FCODE_5FCOMBINATIONS",
                "FND_ACFF_ApplicationShortName":"GL"
            },
            "x-queryable":true
        },
        "headerId":{
            "title":"Header ID",
            "type":"integer",
            "description":"The unique identifier of the journal.",
            "format":"int64",
            "nullable":false,
            "readOnly":true,
            "x-hints":{
                "precision":18
            },
            "x-queryable":true
        },
        "ownerDefinitionShortName":{
            "title":"Ownership Definition",
            "maxLength":30,
            "type":"string",
            "description":"The short name of the ownership definition assigned to the transaction as an override.",
            "nullable":true,
            "x-queryable":true
        },
        "transactionAccount":{
            "title":"Account Key Flexfields",
            "type":"array",
            "description":"The code identifying the general ledger account against which amounts are recorded. These represent assets, liabilities, revenues, expenses, and fund balances.",
            "items":{
                "$ref":"#/components/schemas/jointVentureGLTransactions-transactionAccount-item-response"
            },
            "x-cardinality":"1"
        },
        "stakeholderShortName":{
            "title":"Direct Billed Stakeholder",
            "maxLength":30,
            "type":"string",
            "description":"The name of the joint venture stakeholder assigned to the transaction as an override.",
            "nullable":true,
            "x-queryable":true
        },
        "jointVentureDescription":{
            "title":"Joint Venture Description",
            "maxLength":240,
            "type":"string",
            "description":"The description of the joint venture.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "links":{
            "title":"Links",
            "type":"array",
            "description":"The link relations associated with the resource instance.",
            "items":{
                "$ref":"#/components/schemas/link"
            }
        },
        "carriedInterestSourceOwnerDefinition":{
            "title":"Source Ownership Definition",
            "maxLength":30,
            "type":"string",
            "description":"The name of the ownership definition used as the basis for creating the carried interest ownership definition assigned to the transaction.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "transactionDFF":{
            "type":"array",
            "items":{
                "$ref":"#/components/schemas/jointVentureGLTransactions-transactionDFF-item-response"
            },
            "x-cardinality":"1"
        },
        "lastUpdatedBy":{
            "title":"Last Updated By",
            "maxLength":64,
            "type":"string",
            "description":"The user who last updated the joint venture transaction.",
            "nullable":false,
            "readOnly":true,
            "x-queryable":true
        },
        "enteredCreditAmount":{
            "title":"Entered Credit",
            "type":"number",
            "description":"The transaction credit amount in the entered currency.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "changeReasonDetails":{
            "title":"Change Reason Details",
            "type":"string",
            "description":"Additional text to describe the reason the joint venture transaction was manually changed.",
            "nullable":true,
            "x-queryable":false
        },
        "changeReason":{
            "title":"Change Reason",
            "type":"string",
            "description":"The reason for the manual change to the joint venture transaction.",
            "nullable":true,
            "x-queryable":false
        },
        "enteredDebitAmount":{
            "title":"Entered Debit",
            "type":"number",
            "description":"The transaction debit amount in the entered currency.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "transactionStatus":{
            "title":"Transaction Status",
            "maxLength":80,
            "type":"string",
            "description":"The status of the joint venture transaction.",
            "nullable":true,
            "x-queryable":true
        },
        "jointVentureShortName":{
            "title":"Joint Venture",
            "maxLength":30,
            "type":"string",
            "description":"The unique name of the joint venture.",
            "nullable":false,
            "readOnly":true,
            "x-queryable":true
        },
        "creationDate":{
            "title":"Creation Date",
            "type":"string",
            "description":"The date and time when the joint venture transaction was created.",
            "format":"date-time",
            "nullable":false,
            "readOnly":true,
            "x-queryable":true
        },
        "transactionChangesExistFlag":{
            "title":"Transaction Changes Exist",
            "maxLength":255,
            "type":"boolean",
            "description":"Indicates whether manual changes have been made to a transaction.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":false
        },
        "stakeholderDescription":{
            "title":"Stakeholder Description",
            "maxLength":255,
            "type":"string",
            "description":"The description of the override joint venture stakeholder.",
            "nullable":true,
            "x-queryable":true
        },
        "transactionDate":{
            "title":"Transaction Date",
            "type":"string",
            "description":"The date when the transaction occurred, which may be different from the journal entry effective date or subledger accounting date.",
            "format":"date",
            "nullable":true,
            "x-queryable":true
        },
        "statisticalAmount":{
            "title":"Units",
            "type":"number",
            "description":"The statistical unit of measure of the journal entry line.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "transactionId":{
            "title":"Transaction ID",
            "type":"integer",
            "description":"The unique identifier of the joint venture transaction.",
            "format":"int64",
            "nullable":false,
            "readOnly":true,
            "x-hints":{
                "precision":18,
                "fnd:GLOBALLY_UNIQUE":"true"
            },
            "x-queryable":true
        },
        "accountedCreditAmount":{
            "title":"Accounted Credit",
            "type":"number",
            "description":"The transaction credit amount in accounting currency.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "originalStakeholderDescription":{
            "title":"Original Stakeholder Description",
            "maxLength":240,
            "type":"string",
            "description":"The description of the original stakeholder.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "accountedDebitAmount":{
            "title":"Accounted Debit",
            "type":"number",
            "description":"The transaction debit amount in accounting currency.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "transactionChanges":{
            "title":"Joint Venture Transaction Changes",
            "type":"array",
            "description":"The joint venture transaction changes resource is used to view the history of manual changes to joint venture transactions.",
            "items":{
                "$ref":"#/components/schemas/jointVentureGLTransactions-transactionChanges-item-response"
            }
        },
        "journalDescription":{
            "title":"Transaction Description",
            "maxLength":240,
            "type":"string",
            "description":"The description of the general ledger journal entry line.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "createdBy":{
            "title":"Created By",
            "maxLength":64,
            "type":"string",
            "description":"The user who created the joint venture transaction.",
            "nullable":false,
            "readOnly":true,
            "x-queryable":true
        },
        "enteredCurrencyCode":{
            "title":"Entered Currency",
            "maxLength":15,
            "type":"string",
            "description":"The currency code entered on the original transaction.",
            "nullable":false,
            "readOnly":true,
            "x-queryable":true
        },
        "originalStakeholderShortName":{
            "title":"Original Direct Billed Stakeholder",
            "maxLength":30,
            "type":"string",
            "description":"The original stakeholder assigned to the joint venture transaction.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "lineNumber":{
            "title":"Line Number",
            "type":"integer",
            "description":"The number of the journal line.",
            "format":"int64",
            "nullable":false,
            "readOnly":true,
            "x-hints":{
                "precision":18
            },
            "x-queryable":true
        },
        "carriedInterestAgreementDescription":{
            "title":"Description",
            "maxLength":240,
            "type":"string",
            "description":"The description of the carried interest agreement associated with the joint venture transaction.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "currencyCode":{
            "title":"Accounting Currency",
            "maxLength":15,
            "type":"string",
            "description":"The currency of the transaction amount.",
            "nullable":false,
            "readOnly":true,
            "x-queryable":true
        },
        "effectiveDate":{
            "title":"Accounting Date",
            "type":"string",
            "description":"The accounting date of the journal.",
            "format":"date",
            "nullable":false,
            "readOnly":true,
            "x-queryable":true
        },
        "account":{
            "title":"Account",
            "type":"string",
            "description":"The combination of the values of the account segments assigned to the transaction.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "distributionOnlyFlag":{
            "title":"Distribution Only",
            "maxLength":1,
            "type":"boolean",
            "description":"Indicates whether the transaction is for distribution only, not for invoicing.",
            "nullable":true,
            "default":false,
            "x-queryable":true
        }
    }
}

Nested Schema : Links

Type: array

Title: Links

The link relations associated with the resource instance.

Show Source

• Array of: object link

{
    "title":"Links",
    "type":"array",
    "description":"The link relations associated with the resource instance.",
    "items":{
        "$ref":"#/components/schemas/link"
    }
}

Nested Schema : Account Key Flexfields

Type: array

Title: Account Key Flexfields

The code identifying the general ledger account against which amounts are recorded. These represent assets, liabilities, revenues, expenses, and fund balances.

Show Source

• Array of: object jointVentureGLTransactions-transactionAccount-item-response

{
    "title":"Account Key Flexfields",
    "type":"array",
    "description":"The code identifying the general ledger account against which amounts are recorded. These represent assets, liabilities, revenues, expenses, and fund balances.",
    "items":{
        "$ref":"#/components/schemas/jointVentureGLTransactions-transactionAccount-item-response"
    },
    "x-cardinality":"1"
}

Nested Schema : Joint Venture Transaction Changes

Type: array

Title: Joint Venture Transaction Changes

The joint venture transaction changes resource is used to view the history of manual changes to joint venture transactions.

Show Source

• Array of: object jointVentureGLTransactions-transactionChanges-item-response

{
    "title":"Joint Venture Transaction Changes",
    "type":"array",
    "description":"The joint venture transaction changes resource is used to view the history of manual changes to joint venture transactions.",
    "items":{
        "$ref":"#/components/schemas/jointVentureGLTransactions-transactionChanges-item-response"
    }
}

Nested Schema : transactionDFF

Type: array

Show Source

• Array of: object jointVentureGLTransactions-transactionDFF-item-response

{
    "type":"array",
    "items":{
        "$ref":"#/components/schemas/jointVentureGLTransactions-transactionDFF-item-response"
    },
    "x-cardinality":"1"
}

Nested Schema : link

Type: object

Show Source

• 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.

{
    "type":"object",
    "properties":{
        "kind":{
            "title":"kind",
            "type":"string",
            "description":"The kind of the related resource.",
            "enum":[
                "collection",
                "item",
                "describe",
                "other"
            ]
        },
        "rel":{
            "title":"relation",
            "type":"string",
            "description":"The name of the relation to the resource instance.  Example: self.",
            "enum":[
                "self",
                "lov",
                "parent",
                "canonical",
                "child",
                "enclosure",
                "action",
                "custom"
            ]
        },
        "name":{
            "title":"name",
            "type":"string",
            "description":"The name of the link to the related resource."
        },
        "href":{
            "title":"hyperlink reference",
            "type":"string",
            "description":"The URI to the related resource."
        },
        "properties":{
            "type":"object",
            "properties":{
                "changeIndicator":{
                    "type":"string",
                    "description":"Change indicator or the ETag value of the resource instance."
                }
            }
        }
    }
}

Nested Schema : properties

Type: object

Show Source

• changeIndicator: string
  Change indicator or the ETag value of the resource instance.

{
    "type":"object",
    "properties":{
        "changeIndicator":{
            "type":"string",
            "description":"Change indicator or the ETag value of the resource instance."
        }
    }
}

Nested Schema : jointVentureGLTransactions-transactionAccount-item-response

Type: object

Show Source

• _CHART_OF_ACCOUNTS_ID: integer (int64)
  Title: Chart of Accounts

  Key flexfield structure identifier.
• _CODE_COMBINATION_ID: integer (int64)
  Title: Account

  Key flexfield combination identifier.
• EnabledFlag: string
  Title: Enabled

  Maximum Length: 1

  Key flexfield enabled flag.
• EndDateActive: string (date)
  Title: To Date

  Date after which key flexfield combination is invalid.
• links: array Links
  Title: Links

  The link relations associated with the resource instance.
• StartDateActive: string (date)
  Title: From Date

  Date before which key flexfield combination is invalid.

{
    "type":"object",
    "properties":{
        "StartDateActive":{
            "title":"From Date",
            "type":"string",
            "description":"Date before which key flexfield combination is invalid.",
            "format":"date",
            "nullable":true,
            "x-hints":{
                "DISPLAYHINT":"Hide"
            },
            "x-queryable":true
        },
        "links":{
            "title":"Links",
            "type":"array",
            "description":"The link relations associated with the resource instance.",
            "items":{
                "$ref":"#/components/schemas/link"
            }
        },
        "EndDateActive":{
            "title":"To Date",
            "type":"string",
            "description":"Date after which key flexfield combination is invalid.",
            "format":"date",
            "nullable":true,
            "x-hints":{
                "DISPLAYHINT":"Hide"
            },
            "x-queryable":true
        },
        "EnabledFlag":{
            "title":"Enabled",
            "maxLength":1,
            "type":"string",
            "description":"Key flexfield enabled flag.",
            "nullable":false,
            "x-hints":{
                "DISPLAYHINT":"Hide"
            },
            "x-queryable":true
        },
        "_CHART_OF_ACCOUNTS_ID":{
            "title":"Chart of Accounts",
            "type":"integer",
            "description":"Key flexfield structure identifier.",
            "format":"int64",
            "nullable":false,
            "x-hints":{
                "DISPLAYHINT":"Hide",
                "precision":18,
                "FND_ACFF_IsStructureID":"true",
                "FND_ACFF_JavaType":"java.lang.Long",
                "FND_ACFF_StructureLookupRequired":"false"
            },
            "x-queryable":true
        },
        "_CODE_COMBINATION_ID":{
            "title":"Account",
            "type":"integer",
            "description":"Key flexfield combination identifier.",
            "format":"int64",
            "nullable":false,
            "x-hints":{
                "DISPLAYHINT":"Hide",
                "precision":18,
                "FND_ACFF_JavaType":"java.lang.Long",
                "FND_ACFF_IsCCID":"true"
            },
            "x-queryable":true
        }
    }
}

Nested Schema : Links

Type: array

Title: Links

The link relations associated with the resource instance.

Show Source

• Array of: object link

{
    "title":"Links",
    "type":"array",
    "description":"The link relations associated with the resource instance.",
    "items":{
        "$ref":"#/components/schemas/link"
    }
}

Nested Schema : jointVentureGLTransactions-transactionChanges-item-response

Type: object

Show Source

• afterAssignmentRule: string
  Title: After Assignment Rule

  Read Only: true

  Maximum Length: 30

  The new ownership definition assignment rule assigned to the transaction.
• afterDistributionOnlyFlag: boolean
  Title: After Distribution Only

  Read Only: true

  Maximum Length: 1

  The new distribution only value assigned to the transaction.
• afterOwnershipDefinition: string
  Title: After Ownership Definition

  Read Only: true

  Maximum Length: 30

  The new ownership definition assigned to the transaction.
• afterStakeholder: string
  Title: After Direct Billed Stakeholder

  Read Only: true

  Maximum Length: 30

  The new name of the direct billed stakeholder assigned to the transaction.
• afterStakeholderDescription: string
  Title: After Direct Billed Stakeholder Description

  Read Only: true

  Maximum Length: 240

  The new description of the direct billed stakeholder assigned to the transaction.
• afterStatus: string
  Title: After Status

  Read Only: true

  Maximum Length: 80

  The new status assigned to the transaction.
• afterTransactionDate: string (date)
  Title: After Transaction Date

  Read Only: true

  The new transaction date assigned to the transaction.
• beforeAssignmentRule: string
  Title: Before Assignment Rule

  Read Only: true

  Maximum Length: 30

  The previous ownership definition assignment rule assigned to the transaction.
• beforeDistributionOnlyFlag: boolean
  Title: Before Distribution Only

  Read Only: true

  Maximum Length: 1

  The previous distribution only value assigned to the transaction.
• beforeOwnershipDefinition: string
  Title: Before Ownership Definition

  Read Only: true

  Maximum Length: 30

  The previous ownership definition assigned to the transaction.
• beforeStakeholder: string
  Title: Before Direct Billed Stakeholder

  Read Only: true

  Maximum Length: 30

  The previous name of the direct billed stakeholder assigned to the transaction.
• beforeStakeholderDescription: string
  Title: Before Direct Billed Stakeholder Description

  Read Only: true

  Maximum Length: 240

  The previous description of the direct billed stakeholder assigned to the transaction.
• beforeStatus: string
  Title: Before Status

  Read Only: true

  Maximum Length: 80

  The previous status assigned to the transaction.
• beforeTransactionDate: string (date)
  Title: Before Transaction Date

  Read Only: true

  The previous transaction date assigned to the transaction.
• changeReason: string
  Title: Change Reason

  Read Only: true

  Maximum Length: 80

  The reason for the manual change to the joint venture transaction.
• changeReasonDetails: string
  Title: Change Reason Details

  Read Only: true

  Maximum Length: 240

  Additional text to describe the reason the joint venture transaction was manually changed.
• createdBy: string
  Title: Created By

  Read Only: true

  Maximum Length: 64

  The user who created the joint venture transaction change.
• creationDate: string (date-time)
  Title: Creation Date

  Read Only: true

  The date and time when the joint venture transaction change was created.
• links: array Links
  Title: Links

  The link relations associated with the resource instance.
• transactionChangeId: integer (int64)
  Title: Transaction Change ID

  Read Only: true

  The unique identifier of the joint venture transaction change.

{
    "type":"object",
    "properties":{
        "beforeAssignmentRule":{
            "title":"Before Assignment Rule",
            "maxLength":30,
            "type":"string",
            "description":"The previous ownership definition assignment rule assigned to the transaction.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "changeReasonDetails":{
            "title":"Change Reason Details",
            "maxLength":240,
            "type":"string",
            "description":"Additional text to describe the reason the joint venture transaction was manually changed.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "changeReason":{
            "title":"Change Reason",
            "maxLength":80,
            "type":"string",
            "description":"The reason for the manual change to the joint venture transaction.",
            "nullable":false,
            "readOnly":true,
            "x-queryable":true
        },
        "afterOwnershipDefinition":{
            "title":"After Ownership Definition",
            "maxLength":30,
            "type":"string",
            "description":"The new ownership definition assigned to the transaction.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "beforeStatus":{
            "title":"Before Status",
            "maxLength":80,
            "type":"string",
            "description":"The previous status assigned to the transaction.",
            "nullable":false,
            "readOnly":true,
            "x-queryable":true
        },
        "beforeStakeholder":{
            "title":"Before Direct Billed Stakeholder",
            "maxLength":30,
            "type":"string",
            "description":"The previous name of the direct billed stakeholder assigned to the transaction.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "transactionChangeId":{
            "title":"Transaction Change ID",
            "type":"integer",
            "description":"The unique identifier of the joint venture transaction change.",
            "format":"int64",
            "nullable":false,
            "readOnly":true,
            "x-hints":{
                "precision":18,
                "fnd:GLOBALLY_UNIQUE":"true"
            },
            "x-queryable":true
        },
        "afterTransactionDate":{
            "title":"After Transaction Date",
            "type":"string",
            "description":"The new transaction date assigned to the transaction.",
            "format":"date",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "creationDate":{
            "title":"Creation Date",
            "type":"string",
            "description":"The date and time when the joint venture transaction change was created.",
            "format":"date-time",
            "nullable":false,
            "readOnly":true,
            "x-queryable":true
        },
        "afterStatus":{
            "title":"After Status",
            "maxLength":80,
            "type":"string",
            "description":"The new status assigned to the transaction.",
            "nullable":false,
            "readOnly":true,
            "x-queryable":true
        },
        "beforeDistributionOnlyFlag":{
            "title":"Before Distribution Only",
            "maxLength":1,
            "type":"boolean",
            "description":"The previous distribution only value assigned to the transaction.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "beforeOwnershipDefinition":{
            "title":"Before Ownership Definition",
            "maxLength":30,
            "type":"string",
            "description":"The previous ownership definition assigned to the transaction.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "createdBy":{
            "title":"Created By",
            "maxLength":64,
            "type":"string",
            "description":"The user who created the joint venture transaction change.",
            "nullable":false,
            "readOnly":true,
            "x-queryable":true
        },
        "afterDistributionOnlyFlag":{
            "title":"After Distribution Only",
            "maxLength":1,
            "type":"boolean",
            "description":"The new distribution only value assigned to the transaction.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "afterStakeholder":{
            "title":"After Direct Billed Stakeholder",
            "maxLength":30,
            "type":"string",
            "description":"The new name of the direct billed stakeholder assigned to the transaction.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "links":{
            "title":"Links",
            "type":"array",
            "description":"The link relations associated with the resource instance.",
            "items":{
                "$ref":"#/components/schemas/link"
            }
        },
        "beforeStakeholderDescription":{
            "title":"Before Direct Billed Stakeholder Description",
            "maxLength":240,
            "type":"string",
            "description":"The previous description of the direct billed stakeholder assigned to the transaction.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "afterStakeholderDescription":{
            "title":"After Direct Billed Stakeholder Description",
            "maxLength":240,
            "type":"string",
            "description":"The new description of the direct billed stakeholder assigned to the transaction.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "beforeTransactionDate":{
            "title":"Before Transaction Date",
            "type":"string",
            "description":"The previous transaction date assigned to the transaction.",
            "format":"date",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "afterAssignmentRule":{
            "title":"After Assignment Rule",
            "maxLength":30,
            "type":"string",
            "description":"The new ownership definition assignment rule assigned to the transaction.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        }
    }
}

Nested Schema : Links

Type: array

Title: Links

The link relations associated with the resource instance.

Show Source

• Array of: object link

{
    "title":"Links",
    "type":"array",
    "description":"The link relations associated with the resource instance.",
    "items":{
        "$ref":"#/components/schemas/link"
    }
}

Nested Schema : jointVentureGLTransactions-transactionDFF-item-response

Type: object

Show Source

• __FLEX_Context: string
  Title: Context Segment

  Maximum Length: 150
• __FLEX_Context_DisplayValue: string
  Title: Context Segment
• links: array Links
  Title: Links

  The link relations associated with the resource instance.
• TransactionId: integer (int64)
  Title: Transaction ID

  Read Only: true

{
    "type":"object",
    "properties":{
        "links":{
            "title":"Links",
            "type":"array",
            "description":"The link relations associated with the resource instance.",
            "items":{
                "$ref":"#/components/schemas/link"
            }
        },
        "__FLEX_Context_DisplayValue":{
            "title":"Context Segment",
            "type":"string",
            "nullable":true,
            "x-hints":{
                "updateable":"false",
                "DISPLAYHINT":"Hide",
                "FND_ACFF_IsReadOnly":"true",
                "FND_ACFF_AkaRealSegmentAttrName":"__FLEX_Context",
                "FND_ACFF_JavaType":"java.lang.String",
                "FND_ACFF_ListDisplayAttrName":"Name",
                "FND_ACFF_MaximumLength":"1024",
                "FND_ACFF_PreferredDisplayType":"LOV"
            },
            "x-oj":{
                "transform":{
                    "path":"oj-sp/common-util/flex-util",
                    "name":"transformFlexUIHints"
                }
            },
            "x-queryable":true
        },
        "TransactionId":{
            "title":"Transaction ID",
            "type":"integer",
            "format":"int64",
            "nullable":false,
            "readOnly":true,
            "x-hints":{
                "DISPLAYHINT":"Hide",
                "includeInCompactView":true,
                "precision":18,
                "fnd:GLOBALLY_UNIQUE":"true"
            },
            "x-queryable":true
        },
        "__FLEX_Context":{
            "title":"Context Segment",
            "maxLength":150,
            "type":"string",
            "nullable":true,
            "x-hints":{
                "FND_ACFF_ValueSetInfo":"_FLEX_ContextValueSet_Internal#INDEPENDENT",
                "controlType":"choice",
                "FND_ACFF_AkaAttrName":"__FLEX_Context_DisplayValue",
                "includeInCompactView":true,
                "FND_ACFF_JavaType":"java.lang.String",
                "FND_ACFF_MaximumLength":"1024",
                "FND_ACFF_PreferredDisplayType":"LOV"
            },
            "x-oj":{
                "transform":{
                    "path":"oj-sp/common-util/flex-util",
                    "name":"transformFlexUIHints"
                }
            },
            "x-queryable":true
        }
    }
}

Nested Schema : Links

Type: array

Title: Links

The link relations associated with the resource instance.

Show Source

• Array of: object link

{
    "title":"Links",
    "type":"array",
    "description":"The link relations associated with the resource instance.",
    "items":{
        "$ref":"#/components/schemas/link"
    }
}

Back to Top

Examples

The following example shows how to retrieve all general ledger transactions identified by Joint Venture Management by submitting a GET request on the REST resource using cURL.

curl -i -u "username:password" -H "Content-Type: application/vnd.oracle.adf.resourcecollection+json" -X GET https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/jointVentureGLTransactions

Response Body Example

The following shows an example of the response body in JSON format.

{
  "items" : [ {
    "transactionId" : 100100132693415,
    "batchId" : 1633798,
    "headerId" : 1907291,
    "lineNumber" : 1,
    "jointVentureShortName" : "JVMESS01",
    "jointVentureDescription" : "Jade Valley Mesa Project\nParcel S01,  Lot#34TY6",
    "transactionStatus" : "Available to process",
    "ownerDefinitionShortName" : "JVMESSOPD1",
    "originalOwnerDefinitionShortName" : "JVMESSOPD1",
    "stakeholderShortName" : null,
    "stakeholderDescription" : null,
    "originalStakeholderShortName" : null,
    "originalStakeholderDescription" : null,
    "ledgerName" : "Vision Operations (USA)",
    "periodName" : "Apr-18",
    "effectiveDate" : "2018-04-30",
    "journalStatus" : "P",
    "accountedDebitAmount" : 1500,
    "accountedCreditAmount" : null,
    "currencyCode" : "USD",
    "statisticalAmount" : null,
    "journalDescription" : null,
    "chartOfAccountsId" : 101,
    "account" : "01-110-1110-0000-000",
    "createdBy" : "username",
    "creationDate" : "2020-02-21T08:33:14.001+00:00",
    "lastUpdatedBy" : "username",
    "lastUpdateDate" : "2020-02-21T08:33:14.001+00:00",
    "transactionDate" : "2018-04-30",
   }, {
    "transactionId" : 100100132693412,
    "batchId" : 1633798,
    "headerId" : 1907291,
    "lineNumber" : 3,
    "jointVentureShortName" : "JVMESS01",
    "jointVentureDescription" : "Jade Valley Mesa Project\nParcel S01,  Lot#34TY6",
    "transactionStatus" : "Available to process",
    "ownerDefinitionShortName" : "JVMESSOPD1",
    "originalOwnerDefinitionShortName" : "JVMESSOPD1",
    "stakeholderShortName" : null,
    "stakeholderDescription" : null,
    "originalStakeholderShortName" : null,
    "originalStakeholderDescription" : null,
    "ledgerName" : "Vision Operations (USA)",
    "periodName" : "Apr-18",
    "effectiveDate" : "2018-04-30",
    "journalStatus" : "P",
    "accountedDebitAmount" : 1198.11,
    "accountedCreditAmount" : null,
    "currencyCode" : "USD",
    "statisticalAmount" : null,
    "journalDescription" : null,
    "chartOfAccountsId" : 101,
    "account" : "01-110-1110-0000-000",
    "createdBy" : "username",
    "creationDate" : "2020-02-21T08:33:14.001+00:00",
    "lastUpdatedBy" : "username",
    "lastUpdateDate" : "2020-02-21T08:33:14.001+00:00",
    "transactionDate" : "2018-04-30",
  }, {
    "transactionId" : 100100132693410,
    "batchId" : 1633798,
    "headerId" : 1907291,
    "lineNumber" : 5,
    "jointVentureShortName" : "JVMESS01",
    "jointVentureDescription" : "Jade Valley Mesa Project\nParcel S01,  Lot#34TY6",
    "transactionStatus" : "Available to process",
    "ownerDefinitionShortName" : "JVMESSOPD1",
    "originalOwnerDefinitionShortName" : "JVMESSOPD1",
    "stakeholderShortName" : null,
    "stakeholderDescription" : null,
    "originalStakeholderShortName" : null,
    "originalStakeholderDescription" : null,
    "ledgerName" : "Vision Operations (USA)",
    "periodName" : "Apr-18",
    "effectiveDate" : "2018-04-30",
    "journalStatus" : "P",
    "accountedDebitAmount" : 2770.68,
    "accountedCreditAmount" : null,
    "currencyCode" : "USD",
    "statisticalAmount" : null,
    "journalDescription" : null,
    "chartOfAccountsId" : 101,
    "account" : "01-110-1110-0000-000",
    "createdBy" : "username",
    "creationDate" : "2020-02-21T08:33:14.001+00:00",
    "lastUpdatedBy" : "username",
    "lastUpdateDate" : "2020-02-21T08:33:14.001+00:00",
    "transactionDate" : "2018-04-30",
  }, {
    "transactionId" : 100100132693419,
    "batchId" : 1633798,
    "headerId" : 1907291,
    "lineNumber" : 7,
    "jointVentureShortName" : "JVMESS01",
    "jointVentureDescription" : "Jade Valley Mesa Project\nParcel S01,  Lot#34TY6",
    "transactionStatus" : "Available to process",
    "ownerDefinitionShortName" : "JVMESSOPD1",
    "originalOwnerDefinitionShortName" : "JVMESSOPD1",
    "stakeholderShortName" : null,
    "stakeholderDescription" : null,
    "originalStakeholderShortName" : null,
    "originalStakeholderDescription" : null,
    "ledgerName" : "Vision Operations (USA)",
    "periodName" : "Apr-18",
    "effectiveDate" : "2018-04-30",
    "journalStatus" : "P",
    "accountedDebitAmount" : 18.45,
    "accountedCreditAmount" : null,
    "currencyCode" : "USD",
    "statisticalAmount" : null,
    "journalDescription" : null,
    "chartOfAccountsId" : 101,
    "account" : "01-110-1110-0000-000",
    "createdBy" : "username",
    "creationDate" : "2020-02-21T08:33:14.001+00:00",
    "lastUpdatedBy" : "username",
    "lastUpdateDate" : "2020-02-21T08:33:14.001+00:00",
    "transactionDate" : "2018-04-30",
  }, {
    "transactionId" : 100100132693432,
    "batchId" : 1635802,
    "headerId" : 1909295,
    "lineNumber" : 1,
    "jointVentureShortName" : "JVMESS01",
    "jointVentureDescription" : "Jade Valley Mesa Project\nParcel S01,  Lot#34TY6",
    "transactionStatus" : "Available to process",
    "ownerDefinitionShortName" : "JVMESSOPD1",
    "originalOwnerDefinitionShortName" : "JVMESSOPD1",
    "stakeholderShortName" : null,
    "stakeholderDescription" : null,
    "originalStakeholderShortName" : null,
    "originalStakeholderDescription" : null,
    "ledgerName" : "Vision Operations (USA)",
    "periodName" : "Apr-18",
    "effectiveDate" : "2018-04-30",
    "journalStatus" : "P",
    "accountedDebitAmount" : 6214,
    "accountedCreditAmount" : null,
    "currencyCode" : "USD",
    "statisticalAmount" : null,
    "journalDescription" : null,
    "chartOfAccountsId" : 101,
    "account" : "01-110-1110-0000-000",
    "createdBy" : "username",
    "creationDate" : "2020-02-21T08:33:14.001+00:00",
    "lastUpdatedBy" : "username",
    "lastUpdateDate" : "2020-02-21T08:33:14.001+00:00",
    "transactionDate" : "2018-04-30",
  }, {
    "transactionId" : 100100132693433,
    "batchId" : 1635802,
    "headerId" : 1909295,
    "lineNumber" : 2,
    "jointVentureShortName" : "JVMESS01",
    "jointVentureDescription" : "Jade Valley Mesa Project\nParcel S01,  Lot#34TY6",
    "transactionStatus" : "Available to process",
    "ownerDefinitionShortName" : "JVMESSOPD1",
    "originalOwnerDefinitionShortName" : "JVMESSOPD1",
    "stakeholderShortName" : null,
    "stakeholderDescription" : null,
    "originalStakeholderShortName" : null,
    "originalStakeholderDescription" : null,
    "ledgerName" : "Vision Operations (USA)",
    "periodName" : "Apr-18",
    "effectiveDate" : "2018-04-30",
    "journalStatus" : "P",
    "accountedDebitAmount" : 6876,
    "accountedCreditAmount" : null,
    "currencyCode" : "USD",
    "statisticalAmount" : null,
    "journalDescription" : null,
    "chartOfAccountsId" : 101,
    "account" : "01-110-1110-0000-000",
    "createdBy" : "username",
    "creationDate" : "2020-02-21T08:33:14.001+00:00",
    "lastUpdatedBy" : "username",
    "lastUpdateDate" : "2020-02-21T08:33:14.001+00:00",
    "transactionDate" : "2018-04-30",
  }, {
    "transactionId" : 100100132693411,
    "batchId" : 1635802,
    "headerId" : 1909295,
    "lineNumber" : 3,
    "jointVentureShortName" : "JVMESS01",
    "jointVentureDescription" : "Jade Valley Mesa Project\nParcel S01,  Lot#34TY6",
    "transactionStatus" : "Available to process",
    "ownerDefinitionShortName" : "JVMESSOPD1",
    "originalOwnerDefinitionShortName" : "JVMESSOPD1",
    "stakeholderShortName" : null,
    "stakeholderDescription" : null,
    "originalStakeholderShortName" : null,
    "originalStakeholderDescription" : null,
    "ledgerName" : "Vision Operations (USA)",
    "periodName" : "Apr-18",
    "effectiveDate" : "2018-04-30",
    "journalStatus" : "P",
    "accountedDebitAmount" : 8875,
    "accountedCreditAmount" : null,
    "currencyCode" : "USD",
    "statisticalAmount" : null,
    "journalDescription" : null,
    "chartOfAccountsId" : 101,
    "account" : "01-110-1110-0000-000",
    "createdBy" : "username",
    "creationDate" : "2020-02-21T08:33:14.001+00:00",
    "lastUpdatedBy" : "username",
    "lastUpdateDate" : "2020-02-21T08:33:14.001+00:00",
    "transactionDate" : "2018-04-30",
  }, {
    "transactionId" : 100100132693431,
    "batchId" : 1635802,
    "headerId" : 1909295,
    "lineNumber" : 4,
    "jointVentureShortName" : "JVMESS01",
    "jointVentureDescription" : "Jade Valley Mesa Project\nParcel S01,  Lot#34TY6",
    "transactionStatus" : "Available to process",
    "ownerDefinitionShortName" : "JVMESSOPD1",
    "originalOwnerDefinitionShortName" : "JVMESSOPD1",
    "stakeholderShortName" : null,
    "stakeholderDescription" : null,
    "originalStakeholderShortName" : null,
    "originalStakeholderDescription" : null,
    "ledgerName" : "Vision Operations (USA)",
    "periodName" : "Apr-18",
    "effectiveDate" : "2018-04-30",
    "journalStatus" : "P",
    "accountedDebitAmount" : 9968,
    "accountedCreditAmount" : null,
    "currencyCode" : "USD",
    "statisticalAmount" : null,
    "journalDescription" : null,
    "chartOfAccountsId" : 101,
    "account" : "01-110-1110-0000-000",
    "createdBy" : "username",
    "creationDate" : "2020-02-21T08:33:14.001+00:00",
    "lastUpdatedBy" : "username",
    "lastUpdateDate" : "2020-02-21T08:33:14.001+00:00",
    "transactionDate" : "2018-04-30",
  }, {
    "transactionId" : 100100132693422,
    "batchId" : 1635802,
    "headerId" : 1909295,
    "lineNumber" : 5,
    "jointVentureShortName" : "JVMESS01",
    "jointVentureDescription" : "Jade Valley Mesa Project\nParcel S01,  Lot#34TY6",
    "transactionStatus" : "Available to process",
    "ownerDefinitionShortName" : "JVMESSOPD1",
    "originalOwnerDefinitionShortName" : "JVMESSOPD1",
    "stakeholderShortName" : null,
    "stakeholderDescription" : null,
    "originalStakeholderShortName" : null,
    "originalStakeholderDescription" : null,
    "ledgerName" : "Vision Operations (USA)",
    "periodName" : "Apr-18",
    "effectiveDate" : "2018-04-30",
    "journalStatus" : "P",
    "accountedDebitAmount" : 5569,
    "accountedCreditAmount" : null,
    "currencyCode" : "USD",
    "statisticalAmount" : null,
    "journalDescription" : null,
    "chartOfAccountsId" : 101,
    "account" : "01-110-1110-0000-000",
    "createdBy" : "username",
    "creationDate" : "2020-02-21T08:33:14.001+00:00",
    "lastUpdatedBy" : "username",
    "lastUpdateDate" : "2020-02-21T08:33:14.001+00:00",
    "transactionDate" : "2018-04-30",
  }, {
    "transactionId" : 100100132693418,
    "batchId" : 1635802,
    "headerId" : 1909295,
    "lineNumber" : 6,
    "jointVentureShortName" : "JVMESS01",
    "jointVentureDescription" : "Jade Valley Mesa Project\nParcel S01,  Lot#34TY6",
    "transactionStatus" : "Available to process",
    "ownerDefinitionShortName" : "JVMESSOPD1",
    "originalOwnerDefinitionShortName" : "JVMESSOPD1",
    "stakeholderShortName" : null,
    "stakeholderDescription" : null,
    "originalStakeholderShortName" : null,
    "originalStakeholderDescription" : null,
    "ledgerName" : "Vision Operations (USA)",
    "periodName" : "Apr-18",
    "effectiveDate" : "2018-04-30",
    "journalStatus" : "P",
    "accountedDebitAmount" : 6635,
    "accountedCreditAmount" : null,
    "currencyCode" : "USD",
    "statisticalAmount" : null,
    "journalDescription" : null,
    "chartOfAccountsId" : 101,
    "account" : "01-110-1110-0000-000",
    "createdBy" : "username",
    "creationDate" : "2020-02-21T08:33:14.001+00:00",
    "lastUpdatedBy" : "username",
    "lastUpdateDate" : "2020-02-21T08:33:14.001+00:00",
    "transactionDate" : "2018-04-30",
  }, {
    "transactionId" : 100100132693425,
    "batchId" : 1635802,
    "headerId" : 1909295,
    "lineNumber" : 7,
    "jointVentureShortName" : "JVMESS01",
    "jointVentureDescription" : "Jade Valley Mesa Project\nParcel S01,  Lot#34TY6",
    "transactionStatus" : "Available to process",
    "ownerDefinitionShortName" : "JVMESSOPD1",
    "originalOwnerDefinitionShortName" : "JVMESSOPD1",
    "stakeholderShortName" : null,
    "stakeholderDescription" : null,
    "originalStakeholderShortName" : null,
    "originalStakeholderDescription" : null,
    "ledgerName" : "Vision Operations (USA)",
    "periodName" : "Apr-18",
    "effectiveDate" : "2018-04-30",
    "journalStatus" : "P",
    "accountedDebitAmount" : 22652,
    "accountedCreditAmount" : null,
    "currencyCode" : "USD",
    "statisticalAmount" : null,
    "journalDescription" : null,
    "chartOfAccountsId" : 101,
    "account" : "01-110-1110-0000-000",
    "createdBy" : "username",
    "creationDate" : "2020-02-21T08:33:14.001+00:00",
    "lastUpdatedBy" : "username",
    "lastUpdateDate" : "2020-02-21T08:33:14.001+00:00",
    "transactionDate" : "2018-04-30",
  }, {
    "transactionId" : 100100132693423,
    "batchId" : 1635802,
    "headerId" : 1909295,
    "lineNumber" : 8,
    "jointVentureShortName" : "JVMESS01",
    "jointVentureDescription" : "Jade Valley Mesa Project\nParcel S01,  Lot#34TY6",
    "transactionStatus" : "Available to process",
    "ownerDefinitionShortName" : "JVMESSOPD1",
    "originalOwnerDefinitionShortName" : "JVMESSOPD1",
    "stakeholderShortName" : null,
    "stakeholderDescription" : null,
    "originalStakeholderShortName" : null,
    "originalStakeholderDescription" : null,
    "ledgerName" : "Vision Operations (USA)",
    "periodName" : "Apr-18",
    "effectiveDate" : "2018-04-30",
    "journalStatus" : "P",
    "accountedDebitAmount" : 33654,
    "accountedCreditAmount" : null,
    "currencyCode" : "USD",
    "statisticalAmount" : null,
    "journalDescription" : null,
    "chartOfAccountsId" : 101,
    "account" : "01-110-1110-0000-000",
    "createdBy" : "username",
    "creationDate" : "2020-02-21T08:33:14.001+00:00",
    "lastUpdatedBy" : "username",
    "lastUpdateDate" : "2020-02-21T08:33:14.001+00:00",
    "transactionDate" : "2018-04-30",
  }, {
    "transactionId" : 100100132693430,
    "batchId" : 1635802,
    "headerId" : 1909295,
    "lineNumber" : 9,
    "jointVentureShortName" : "JVMESS01",
    "jointVentureDescription" : "Jade Valley Mesa Project\nParcel S01,  Lot#34TY6",
    "transactionStatus" : "Available to process",
    "ownerDefinitionShortName" : "JVMESSOPD1",
    "originalOwnerDefinitionShortName" : "JVMESSOPD1",
    "stakeholderShortName" : null,
    "stakeholderDescription" : null,
    "originalStakeholderShortName" : null,
    "originalStakeholderDescription" : null,
    "ledgerName" : "Vision Operations (USA)",
    "periodName" : "Apr-18",
    "effectiveDate" : "2018-04-30",
    "journalStatus" : "P",
    "accountedDebitAmount" : 1254,
    "accountedCreditAmount" : null,
    "currencyCode" : "USD",
    "statisticalAmount" : null,
    "journalDescription" : null,
    "chartOfAccountsId" : 101,
    "account" : "01-110-1110-0000-000",
    "createdBy" : "username",
    "creationDate" : "2020-02-21T08:33:14.001+00:00",
    "lastUpdatedBy" : "username",
    "lastUpdateDate" : "2020-02-21T08:33:14.001+00:00",
    "transactionDate" : "2018-04-30",
  }, {
    "transactionId" : 100100132693420,
    "batchId" : 1635802,
    "headerId" : 1909295,
    "lineNumber" : 10,
    "jointVentureShortName" : "JVMESS01",
    "jointVentureDescription" : "Jade Valley Mesa Project\nParcel S01,  Lot#34TY6",
    "transactionStatus" : "Available to process",
    "ownerDefinitionShortName" : "JVMESSOPD1",
    "originalOwnerDefinitionShortName" : "JVMESSOPD1",
    "stakeholderShortName" : null,
    "stakeholderDescription" : null,
    "originalStakeholderShortName" : null,
    "originalStakeholderDescription" : null,
    "ledgerName" : "Vision Operations (USA)",
    "periodName" : "Apr-18",
    "effectiveDate" : "2018-04-30",
    "journalStatus" : "P",
    "accountedDebitAmount" : 6896,
    "accountedCreditAmount" : null,
    "currencyCode" : "USD",
    "statisticalAmount" : null,
    "journalDescription" : null,
    "chartOfAccountsId" : 101,
    "account" : "01-110-1110-0000-000",
    "createdBy" : "username",
    "creationDate" : "2020-02-21T08:33:14.001+00:00",
    "lastUpdatedBy" : "username",
    "lastUpdateDate" : "2020-02-21T08:33:14.001+00:00",
    "transactionDate" : "2018-04-30",
  }, {
    "transactionId" : 100100132693414,
    "batchId" : 1636797,
    "headerId" : 1910290,
    "lineNumber" : 1,
    "jointVentureShortName" : "JVMESS01",
    "jointVentureDescription" : "Jade Valley Mesa Project\nParcel S01,  Lot#34TY6",
    "transactionStatus" : "Available to process",
    "ownerDefinitionShortName" : "JVMESSOPD1",
    "originalOwnerDefinitionShortName" : "JVMESSOPD1",
    "stakeholderShortName" : null,
    "stakeholderDescription" : null,
    "originalStakeholderShortName" : null,
    "originalStakeholderDescription" : null,
    "ledgerName" : "Vision Operations (USA)",
    "periodName" : "Apr-18",
    "effectiveDate" : "2018-04-30",
    "journalStatus" : "P",
    "accountedDebitAmount" : 19017,
    "accountedCreditAmount" : null,
    "currencyCode" : "USD",
    "statisticalAmount" : null,
    "journalDescription" : null,
    "chartOfAccountsId" : 101,
    "account" : "01-110-1110-0000-000",
    "createdBy" : "username",
    "creationDate" : "2020-02-21T08:33:14.001+00:00",
    "lastUpdatedBy" : "username",
    "lastUpdateDate" : "2020-02-21T08:33:14.001+00:00",
    "transactionDate" : "2018-04-30",
  },

Back to Top