| id |
integer |
Yes |
Yes |
nextval('sales_order_batches_id_seq'::regclass) |
Unique identifier |
| batch_no |
bigint |
No |
No |
|
Batch number created when Invoice is Posted (Live Invoice mode) or when Invoice batch is created by user (Batch Invoice mode) |
| type |
character varying(1) |
No |
No |
|
Record type; I = Invoice posted to Sales History O = Order exists in Sales Order List |
| record_no |
character varying(10) |
No |
No |
|
Invoice number (type = 'I') or Sales Order number (type = 'O') |
| status |
character varying(1) |
No |
No |
|
Batch record status; C = Closed, records posted to Sales History O = Open, records in Sales Order List |
| division |
character varying(3) |
No |
No |
|
General Ledger division for batch |
| gl_trans_no |
character varying(10) |
No |
No |
|
General Ledger transaction number for posted Invoice - links to gl_transactions.trans_no |
| create_user |
character varying(3) |
No |
No |
|
User initials that created the batch (Batch Invoice mode) or posted the Invoice (Live Invoice mode) |
| post_user |
character varying(3) |
No |
No |
|
User initials that posted the batch (Batch Invoice mode) or posted the Invoice (Live Invoice mode) |
| location |
character varying(24) |
No |
No |
|
General Ledger Location segment for companies using Location accounting |
| profit_center |
character varying(24) |
No |
No |
|
General Ledger Profit Center segment for companies using Profit Center accounting |
| create_date |
timestamp without time zone |
No |
No |
|
UTC Date and time record was created |
| post_date |
timestamp without time zone |
No |
No |
|
UTC Date and time record was posted |