The Item Number Fields and Item Fields custom fields are available for the Gift Certificates table.
Related Links:
Linking Gift Certificates to Transaction Line Items
| Name | Type | Length | Precision | Scale | References | In | Description |
|---|---|---|---|---|---|---|---|
| amount | NUMBER | 39 | 0 | Original amount | |||
| amount_available | NUMBER | 39 | 0 | Amount remaining | |||
| amount_available_billed | NUMBER | 39 | 0 | Amount billed | |||
| create_date | TIMESTAMP | Date created | |||||
| date_last_modified | TIMESTAMP | Date Last Modified | |||||
| expiration_date | TIMESTAMP | Expiration date | |||||
| from_name | VARCHAR2 | 600 | From | ||||
| gift_certificate_code | VARCHAR2 | 50 | Code | ||||
| gift_certificate_id | VARCHAR2 | 50 | Gift certificate ID | ||||
| gift_message | VARCHAR2 | 4000 | Gift message | ||||
| include_child_subsidiaries | VARCHAR2 | 3 | Include child subsidiaries | ||||
| income_account_id | NUMBER | 39 | 0 | Income account | |||
| is_active | VARCHAR2 | 3 | Active | ||||
| item_id | NUMBER | 39 | 0 | Item name/number | |||
| item_name | VARCHAR2 | 250 | Display name/code | ||||
| liability_account_id | NUMBER | 39 | 0 | Liability account | |||
| purchase_date | TIMESTAMP | Purchase date | |||||
| to_email | VARCHAR2 | 300 | Recipient email | ||||
| to_name | VARCHAR2 | 600 | Recipient name |