| 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 |