| Name | Description | Type | Additional information |
|---|---|---|---|
| SEQ_NO | integer |
None. |
|
| TRANS_DATE | date |
None. |
|
| TRANS_NO | string |
String length: inclusive between 0 and 15 |
|
| USER_SEQ | integer |
None. |
|
| STONE_COUNT | integer |
None. |
|
| NET_RATE | decimal number |
None. |
|
| NET_VALUE | decimal number |
None. |
|
| DELIVERY_STATUS | boolean |
None. |
|
| TERMS_SEQ | integer |
None. |
|
| TOTAL_CARAT | decimal number |
None. |
|
| SHIPPING_CHARGE | decimal number |
None. |
|
| PAYABLE_AMOUNT | decimal number |
None. |
|
| AVG_DISCOUNT | decimal number |
None. |
|
| SALESMAN_DATE | date |
None. |
|
| SALESMAN_ALLOW | boolean |
None. |
|
| ADMIN_DATE | date |
None. |
|
| ADMIN_ALLOW | boolean |
None. |
|
| ADMIN_COMMENT | string |
String length: inclusive between 0 and 250 |
|
| STATUS | integer |
None. |
|
| BOOK_SEQ | integer |
None. |
|
| AC_YEAR_SEQ | integer |
None. |
|
| IS_CANCEL | boolean |
None. |
|
| LOGIN_USER_SEQ | integer |
None. |
|
| RAP_LESS | decimal number |
None. |
|
| VALUE_LESS | decimal number |
None. |
|
| RAP_LESS_AMOUNT | decimal number |
None. |
|
| VALUE_LESS_AMOUNT | decimal number |
None. |
|
| FINAL_NET_VALUE | decimal number |
None. |
|
| SPECIAL_OFF | decimal number |
None. |
|
| ONLINE_OFF | decimal number |
None. |
|
| SPECIAL_OFF_AMOUNT | decimal number |
None. |
|
| ONLINE_OFF_AMOUNT | decimal number |
None. |
|
| BPD | decimal number |
None. |
|
| CURRENCY | string |
String length: inclusive between 0 and 10 |
|
| COMP_SEQ | integer |
None. |
|
| LEDGER_SEQ | integer |
None. |
|
| CHARGES_AC_SEQ | integer |
None. |
|
| DUE_DATE | date |
None. |
|
| PAYMENT_BANK_SEQ | integer |
None. |
|
| SGST_PER | decimal number |
None. |
|
| CGST_PER | decimal number |
None. |
|
| IGST_PER | decimal number |
None. |
|
| SGST_AMOUNT | decimal number |
None. |
|
| CGST_AMOUNT | decimal number |
None. |
|
| IGST_AMOUNT | decimal number |
None. |
|
| PICKEDUP_BY | string |
String length: inclusive between 0 and 250 |
|
| HK_EXCH_RATE | decimal number |
None. |
|
| IND_EXCH_RATE | decimal number |
None. |
|
| REMARK | string |
String length: inclusive between 0 and 250 |
|
| ONLINE_DISC_OFF | decimal number |
None. |
|
| INV_LOCK | string |
String length: inclusive between 0 and 7 |
|
| DELIVERY_LOCATION | string |
String length: inclusive between 0 and 15 |
|
| AC_YEAR | AC_YEAR |
None. |
|
| BOOK_MAS | BOOK_MAS |
None. |
|
| COMP_BANK_MAS | COMP_BANK_MAS |
None. |
|
| COMP_MAS | COMP_MAS |
None. |
|
| LEDGER_MAS | LEDGER_MAS |
None. |
|
| TERMS_MAS | TERMS_MAS |
None. |
|
| TRANS_DET | Collection of TRANS_DET |
None. |
|
| USER_MAS | USER_MAS |
None. |
|
| TRANS_RET_MAS | Collection of TRANS_RET_MAS |
None. |