ATG Business Commerce Invoice Tables

ATG Business Commerce Invoice Tables

The following tables contain information related to ATG Business 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
`id`	VARCHAR(40)	NOT NULL
(primary key)	The repository id of this `deliveryInfo` item.
`version`	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.
`type`	INT	NOT NULL
	The subtype code for the `deliveryInfo` repository item represented by this row. (See the GSA docs on item descriptor subtypes for more info.)
`prefix`	WVARCHAR(40)	NULL
	An optional prefix (“Mr.”, “Ms.”, etc.) that appears as part of this invoice recipient’s name.
`first_name`	WVARCHAR(40)	NULL
	The first name of the recipient of this invoice.
`middle_name`	WVARCHAR(40)	NULL
	The middle name of the recipient of this invoice.
`last_name`	WVARCHAR(40)	NULL
	The last name of the recipient of this invoice.
`suffix`	WVARCHAR(40)	NULL
	An optional suffix (“Jr.”, etc) that appears as part of this invoice recipient’s name.
`job_title`	WVARCHAR(80)	NULL
	The invoice recipient’s job title, which an application might choose to use when constructing a mailing address for this invoice.
`company_name`	WVARCHAR(40)	NULL
	The invoice recipient’s company name, which an application might choose to use when constructing a mailing address for this invoice.
`address1`	WVARCHAR(80)	NULL
	The first line of the delivery address for this invoice.
`address2`	WVARCHAR(80)	NULL
	The second line of the delivery address.
`address3`	WVARCHAR(80)	NULL
	The third line of the delivery address.
`city`	WVARCHAR(40)	NULL
	The city part of the delivery address.
`county`	WVARCHAR(40)	NULL
	The county part of the delivery address.
`state`	WVARCHAR(40)	NULL
	The state part of the delivery address.
`postal_code`	WVARCHAR(10)	NULL
	The postal code of the delivery address.
`country`	WVARCHAR(40)	NULL
	The country of the delivery address.
`phone_number`	WVARCHAR(40)	NULL
	The invoice recipient’s telephone number.
`fax_number`	WVARCHAR(40)	NULL
	The invoice recipient’s FAX number.
`email_addr`	WVARCHAR(40)	NULL
	The invoice recipient’s e-mail address.
`format`	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.
`delivery_mode`	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
`id`	VARCHAR(40)	NOT NULL
(primary key)	The repository id of this `paymentTerms` item.
`version`	INT	NOT NULL
	The version number of the data in this row. (See the GSA docs on automatic version numbering for more info.)
`type`	INT	NOT NULL
	The subtype code for the `paymentTerms` repository item represented by this row. (See the GSA docs on item descriptor subtypes for more info.)
`disc_percent`	NUMERIC(19, 7)	NULL
	The `discountPercent` field of the payment terms item. This typically specifies a percentage discount on the price that is offered if the invoice is paid in full within a certain number of days (the `discountDays`”field).
`disc_days`	INT	NULL
	The `discountDays` field of the payment terms item. Specifies the number of days within which the invoice must be paid to qualify for the discount percentage.
`net_days`	INT	NULL
	The `netDays` field of the payment terms item. Specifies the number of days within which the invoice must be paid in full.

dbc_invoice

The following table contains information related to invoices. Each row represents one invoice repository item.

Column	Data Type	Constraint
`id`	VARCHAR(40)	NOT NULL
(primary key)	The unique repository id of this invoice.
`version`	INT	NOT NULL
	The version number of the data in this row. (See the GSA docs on automatic version numbering for more info.)
`type`	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.)
`creation_date`	TIMESTAMP	NULL
	The date this invoice was created.
`last_mod_date`	TIMESTAMP	NULL
	The date this invoice was last modified. This field is maintained automatically when you use the `InvoiceManager` API to create and modify invoices.
`invoice_number`	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.
`po_number`	VARCHAR(40)	NULL
	The purchase order number the buyer specified when paying for all or part of an order by invoice.
`req_number`	VARCHAR(40)	NULL
	The requisition number the buyer specified when paying for all or part of an order by invoice.
`delivery_info`	VARCHAR(40)	NULL
	References `dbc_inv_delivery(id)`. Identifies the `deliveryInfo` object that describes where and how to deliver this invoice.
`balance_due`	NUMERIC(19, 7)	NULL
	The balance due on this invoice.
`pmt_due_date`	TIMESTAMP	NULL
	The date on which payment for this invoice is due.
`pmt_terms`	VARCHAR(40)	NULL
	References `dbc_inv_pmt_terms(id`). Identifies the `paymentTerms` object that describes the payment terms for this invoice.
`order_id`	VARCHAR(40)	NULL
	The order ID of the order being paid for with this invoice.
`pmt_group_id`	VARCHAR(40)	NULL
	The payment group ID of the specific payment group being paid for with this invoice.

Contents
Search

loading table of contents...