Purchase
The table below describes the Purchase table.
This table contains the following virtual tables:
This table contains the following foldable columns:
- Id
- Document_Number
- Transaction_Date
The primary key columns in this table are returnable.
| Column Name | SQL Type | Updatable | Nullable |
|---|---|---|---|
|
Id Primary Key |
SQL_VARCHAR(255) | False | False |
|
AccountRef_Name |
SQL_VARCHAR(255) | True | True |
|
AccountRef_Value |
SQL_VARCHAR(255) | True | True |
|
Create_Time |
SQL_TIMESTAMP | False | True |
|
Credit |
SQL_BIT | True | True |
|
CurrencyRef_Name |
SQL_VARCHAR(255) | False | True |
|
CurrencyRef_Value |
SQL_VARCHAR(255) | False | True |
|
DepartmentRef_Name |
SQL_VARCHAR(255) | True | True |
|
DepartmentRef_Value |
SQL_VARCHAR(255) | True | True |
|
Document_Number |
SQL_VARCHAR(255) | True | True |
|
EntityRef_Name |
SQL_VARCHAR(255) | True | True |
|
EntityRef_Value |
SQL_VARCHAR(255) | True | True |
|
Exchange_Rate |
SQL_NUMERIC(15,2) | True | True |
|
Global_Tax_Calculation |
SQL_VARCHAR(255) | True | True |
|
Last_Updated_Time |
SQL_TIMESTAMP | False | True |
|
PaymentMethodRef_Name |
SQL_VARCHAR(255) | True | True |
|
PaymentMethodRef_Value |
SQL_VARCHAR(255) | True | True |
|
Payment_Type |
SQL_VARCHAR(255) | True | True |
|
Print_Status |
SQL_VARCHAR(255) | True | True |
|
Private_Note |
SQL_VARCHAR(4000) | True | True |
|
Remit_To_Address_City |
SQL_VARCHAR(255) | True | True |
|
Remit_To_Address_Country |
SQL_VARCHAR(255) | True | True |
|
Remit_To_Address_Country_SubDivision_Code |
SQL_VARCHAR(255) | True | True |
|
Remit_To_Address_Id |
SQL_VARCHAR(255) | False | True |
|
Remit_To_Address_Lat |
SQL_VARCHAR(255) | True | True |
|
Remit_To_Address_Line1 |
SQL_VARCHAR(500) | True | True |
|
Remit_To_Address_Line2 |
SQL_VARCHAR(500) | True | True |
|
Remit_To_Address_Line3 |
SQL_VARCHAR(500) | True | True |
|
Remit_To_Address_Line4 |
SQL_VARCHAR(500) | True | True |
|
Remit_To_Address_Line5 |
SQL_VARCHAR(500) | True | True |
|
Remit_To_Address_Long |
SQL_VARCHAR(255) | True | True |
|
Remit_To_Address_Note |
SQL_VARCHAR(255) | True | True |
|
Remit_To_Address_Postal_Code |
SQL_VARCHAR(255) | True | True |
|
SyncToken |
SQL_VARCHAR(255) | True | True |
|
Total_Amount |
SQL_NUMERIC(15,2) | True | True |
|
Transaction_Date |
SQL_DATE | True | True |
|
Transaction_Location_Type |
SQL_VARCHAR(255) | True | True |
|
Transaction_Source |
SQL_VARCHAR(255) | True | True |
|
TxnTaxDetail_TotalTax |
SQL_NUMERIC(15,2) | True | True |
|
TxnTaxDetail_TxnTaxCodeRef_Name |
SQL_VARCHAR(255) | True | True |
|
TxnTaxDetail_TxnTaxCodeRef_Value |
SQL_VARCHAR(255) | True | True |