id |
integer |
Yes |
Yes |
nextval('sales_order_batches_id_seq'::regclass) |
|
batch_no |
bigint |
No |
No |
|
Batch number |
type |
character varying(1) |
No |
No |
|
I = Invoice O = Order |
record_no |
character varying(10) |
No |
No |
|
Invoice number |
status |
character varying(1) |
No |
No |
|
C = Closed O= Open |
division |
character varying(3) |
No |
No |
|
Division payment posted to |
gl_trans_no |
character varying(10) |
No |
No |
|
GL transaction number |
create_user |
character varying(3) |
No |
No |
|
User initials that created payment |
post_user |
character varying(3) |
No |
No |
|
User that posted payment |
location |
character varying(24) |
No |
No |
|
Location - (if using Spire's location accounting) |
profit_centre |
character varying(24) |
No |
No |
|
Profit center if using Spire's profit centers. |
create_date |
timestamp without time zone |
No |
No |
|
Date created |
post_date |
timestamp without time zone |
No |
No |
|
Date posted |