Vendor_Payment table

Payment_Id

String

Vendor_Id

String

Date

String

Exchange_Rate

Number

Amount

Number

Paid_Through_Account_Id

String

Payment_Mode

String

Description

String

Reference_Number

String

Is_Paid_Via_Print_Check

Boolean

Purpose_Code

String

Payment_Number

String

Last_Modified_Time

Timestamp

Tax_Account_Name

String

Credit_Account_Id

String

Is_Online_Payment

Boolean

Payment_Number_Suffix

String

Submitted_By_Name

String

Vendor_Name

String

Tax_Amount_Withheld

Number

Status

String

Currency_Id

String

Transfer_Type

String

Payment_Number_Prefix

String

Created_By_Id

String

Billing_Address_Address

String

Billing_Address_Street2

String

Billing_Address_City

String

Billing_Address_Attention

String

Billing_Address_Phone

String

Billing_Address_State

String

Billing_Address_Country

String

Billing_Address_Zip

String

Billing_Address_Fax

String

Submitted_By_Photo_Url

String

Offset_Account_Name

String

Ach_Payment_Status

String

Is_Tds_Amount_In_Percent

Boolean

Tds_Tax_Id

String

Tds_Calculation_Type

String

Tax_Account_Id

String

Currency_Code

String

Created_Time

Timestamp

Balance

Number

Currency_Symbol

String

Created_By_Name

String

Paid_Through_Account_Name

String

Paid_Through_Account_Type

String

Offset_Account_Id

String

Tax_Treatment

String

Reverse_Charge_Tax_Id

String

Is_Reverse_Charge_Applied

String

Bank_Charges

String

Check_Details_Check_Id

String

Check_Details_Check_Number

String

Check_Details_Template_Id

String

Check_Details_Check_Status

String

Check_Details_Memo

String

Check_Details_Amount_In_Words

String

Check_Details_Is_New_Check_Voucher

String

Check_Details_Is_New_Check_Voucher_Early_Access

String

Is_Ach_Payment

Boolean

Submitted_Date

Date

Submitted_By

String

Submitted_By_Email

String

Submitter_Id

String

Approver_Id

String

Total_Payment_Amount

String

Indirect_Tcs_Tax_Amount

String

Txn_Posting_Date

Date

Gst_No

String

Indirect_Tcs_Tax_Id

String

Gst_Return_Details_Return_Period

String

Gst_Return_Details_Status

String

Indirect_Tds_Tax_Id

String

Indirect_Tds_Tax_Amount

String

Tds_Override_Preference

String

Product_Description

String

Is_Advance_Payment

String

Destination_Of_Supply

String

Is_Pre_Gst

String

Source_Of_Supply

String

Gst_Treatment

String

Place_Of_Supply

String

Ach_Gw_Transaction_Id

String

Bill_Numbers

String

Bcy_Amount

Number

Bcy_Balance

Number

Has_Attachment

Boolean

Bills

Array

Check_Detail

String

Documents

Array

Approvers_List

Array

Comments

Array

Vendorpayment_Refunds

Array

Imported_Transactions

Array

Indirect_Tcs_Tax_Details

String

Indirect_Tds_Tax_Details

String

Tds_Summary

String