Table Data dictionary report - sales_order_payments

Generated: 2018-10-18 8:04:38 AM
Server: PostgreSQL 9.3 (localhost:5432)
Database: datadict_donotremove
Schema: public
Notes:

Table for Deposits and Payments made on Sales Orders

Columns

Name Data type Not Null? Primary key? Default Comment
id integer Yes Yes nextval('sales_order_payments_id_seq'::regclass) Unique identifier
order_no character varying(10) No No Sales Order number that payment was for - link to sales_orders.order_no
sequence smallint No No Sequential number for payments, used when more than one payment exists on a Sales Order
payment_method integer Yes No Payment method for this record - links to payment_methods.id
currency character varying(3) Yes No ''::character varying Payment method currency; blank = base currency - links to currencies.code
division character varying(3) Yes No ''::character varying General Ledger Division for payment
gl_account character varying(24) Yes No ''::character varying General Ledger account for payment
amount numeric(15,2) Yes No Payment amount
auth_code character varying(20) No No Credit card authorization recorded at payment time
ccard_postal_code character varying(16) No No Credit card postal code
cust_no character varying(20) No No Customer numberfor payment - links to customers.cust_no
payment_date date No No Date payment was made
layaway_flag boolean No No This payment is a deposit on the Sales Order; FALSE = No TRUE = Yes
trans_no character varying(10) No No General Ledger transaction number for payment - links to gl_transactions.trans_no
_dbversion integer No No Program version that last modified this record
_created timestamp without time zone No No UTC Date and time record was created
_created_by character varying(3) No No User initials that created this record
_modified timestamp without time zone No No UTC Date and time this record was last modified
_modified_by character varying(3) No No User initials that last modified this record
change numeric(15,2) Yes No Change given on payment
last_four character varying(4) No No Last four characters of the credit card number
_deleted timestamp without time zone No No UTC Date and time this record was deleted by user, blank if not deleted
_deleted_by character varying(3) No No User initials that deleted this Sales Order, blank if not deleted

Constraints

Name Type Definition Comment
bve_order_pmt_pkey Primary key (id)
sales_order_payments_order_no_sequence_key Unique (order_no, sequence) DEFERRABLE INITIALLY IMMEDIATE

Report generated by pgAdmin3 LTS by BigSQL