aurora_standard.icactvv
| Field | Type | Null | Default | Key | Extra | Comment |
|---|---|---|---|---|---|---|
| doc_no | int(11) | YES | ||||
| line_no | int(11) | YES | ||||
| item_code | char(20) | YES | ||||
| department | char(3) | YES | ||||
| doc_date | date | YES | ||||
| vend_item_code | char(20) | YES | ||||
| vend_code | char(6) | YES |
| Field | Type | Null | Default | Key | Extra | Comment |
|---|---|---|---|---|---|---|
| doc_no | int(11) | YES | ||||
| line_no | int(11) | YES | ||||
| item_code | char(20) | YES | ||||
| department | char(3) | YES | ||||
| doc_date | date | YES | ||||
| vend_item_code | char(20) | YES | ||||
| vend_code | char(6) | YES |