The following tables contain information related to Oracle ATG Web Commerce invoice functionality:
dbc_inv_delivery
The following table contains information about the delivery information associated with an invoice. Each row represents one deliveryInfo
repository item.
Column | Data Type | Constraint |
---|---|---|
| VARCHAR(40) | NOT NULL |
(primary key) | The repository id of this | |
| INT | NOT NULL |
The version number of the data in this row. See the SQL Repository Item Properties chapter of the ATG Repository Guide for information on automatic version numbering. | ||
| INT | NOT NULL |
The subtype code for the | ||
| WVARCHAR(40) | NULL |
An optional prefix (“Mr.”, “Ms.”, etc.) that appears as part of this invoice recipient’s name. | ||
| WVARCHAR(40) | NULL |
The first name of the recipient of this invoice. | ||
| WVARCHAR(40) | NULL |
The middle name of the recipient of this invoice. | ||
| WVARCHAR(40) | NULL |
The last name of the recipient of this invoice. | ||
| WVARCHAR(40) | NULL |
An optional suffix (“Jr.”, etc) that appears as part of this invoice recipient’s name. | ||
| WVARCHAR(80) | NULL |
The invoice recipient’s job title, which an application might choose to use when constructing a mailing address for this invoice. | ||
| WVARCHAR(40) | NULL |
The invoice recipient’s company name, which an application might choose to use when constructing a mailing address for this invoice. | ||
| WVARCHAR(80) | NULL |
The first line of the delivery address for this invoice. | ||
| WVARCHAR(80) | NULL |
The second line of the delivery address. | ||
| WVARCHAR(80) | NULL |
The third line of the delivery address. | ||
| WVARCHAR(40) | NULL |
The city part of the delivery address. | ||
| WVARCHAR(40) | NULL |
The county part of the delivery address. | ||
| WVARCHAR(40) | NULL |
The state part of the delivery address. | ||
| WVARCHAR(10) | NULL |
The postal code of the delivery address. | ||
| WVARCHAR(40) | NULL |
The country of the delivery address. | ||
| WVARCHAR(40) | NULL |
The invoice recipient’s telephone number. | ||
| WVARCHAR(40) | NULL |
The invoice recipient’s FAX number. | ||
| WVARCHAR(40) | NULL |
The invoice recipient’s e-mail address. | ||
| INT | NULL |
An enumerated type code indicating the format in which the recipient prefers to receive this invoice. This field is not used by default, but is provided as a placeholder for applications that want to present a list of available formats (text, HTML, EDI, XML, etc) and attempt to deliver the invoice in a preferred format. | ||
| INT | NULL |
An enumerated type code indicating the means by which the recipient prefers to receive this invoice. This field is not used by default, but is provided as a placeholder for applications that want to present a list of available delivery methods (postal, fax, electronic, etc) and attempt to deliver the invoice using the preferred means. |
dbc_inv_pmt_terms
The following table contains information related to the payment terms for an invoice. Each row represents one paymentTerms
repository item.
Column | Data Type | Constraint |
---|---|---|
| VARCHAR(40) | NOT NULL |
(primary key) | The repository id of this | |
| INT | NOT NULL |
The version number of the data in this row. (See the GSA docs on automatic version numbering for more info.) | ||
| INT | NOT NULL |
The subtype code for the | ||
| NUMERIC(19, 7) | NULL |
The | ||
| INT | NULL |
The | ||
| INT | NULL |
The |
dbc_invoice
The following table contains information related to invoices. Each row represents one invoice repository item.
Column | Data Type | Constraint |
---|---|---|
| VARCHAR(40) | NOT NULL |
(primary key) | The unique repository id of this invoice. | |
| INT | NOT NULL |
The version number of the data in this row. (See the GSA docs on automatic version numbering for more info.) | ||
| INT | NOT NULL |
The subtype code for the invoice repository item represented by this row. (For more information on item descriptor subtypes, see the Item Descriptor Inheritance section of the SQL Repository Data Models chapter in the ATG Repository Guide.) | ||
| TIMESTAMP | NULL |
The date this invoice was created. | ||
| TIMESTAMP | NULL |
The date this invoice was last modified. This field is maintained automatically when you use the | ||
| VARCHAR(40) | NULL |
An application-generated invoice number that identifies this invoice for both the buyer and the seller. The invoice number is different from the repository id, and has no meaning other than as a way to identify a particular invoice. | ||
| VARCHAR(40) | NULL |
The purchase order number the buyer specified when paying for all or part of an order by invoice. | ||
| VARCHAR(40) | NULL |
The requisition number the buyer specified when paying for all or part of an order by invoice. | ||
| VARCHAR(40) | NULL |
References | ||
| NUMERIC(19, 7) | NULL |
The balance due on this invoice. | ||
| TIMESTAMP | NULL |
The date on which payment for this invoice is due. | ||
| VARCHAR(40) | NULL |
References | ||
| VARCHAR(40) | NULL |
The order ID of the order being paid for with this invoice. | ||
| VARCHAR(40) | NULL |
The payment group ID of the specific payment group being paid for with this invoice. |