Table Name edkbk_invat_dtl_tmp
| Table Column Name | Table Column Datatype | Table Column Comment | Table Column Is PK | Table Column Is FK |
|---|---|---|---|---|
| invat_guid | varchar(40) | Guid | No | No |
| invat_lineno | int | Line no. | ||
| invat_isurettype | varchar(5) | Issue / return type | ||
| invat_custordno | varchar(40) | Customer order no. | ||
| invat_aircraftregno | varchar(30) | Aircraft registration no. | ||
| invat_orderappl | varchar(5) | Order applicability | ||
| invat_worderno | varchar(40) | Work order no. | ||
| invat_aircraftmodel | varchar(20) | Aircraft model | ||
| invat_currency | varchar(5) | Currency | ||
| invat_custaddress | varchar(1024) | Customer address | ||
| invat_custcode | varchar(18) | Customer code | ||
| invat_disallowance | numeric(13) | Discount allowance | ||
| invat_issuecost | Issue cost | |||
| invat_matcost | Material cost | |||
| invat_partno | varchar(40) | Part no. | ||
| invat_quantity | int | Quantity | ||
| invat_refdocno | varchar(40) | Reference document no. | ||
| invat_refdoctype | Reference document type | |||
| invat_serialno | Serial no. | |||
| invat_transactiondate | datetime | Transaction date | ||
| invat_transactionno | varchar(40) | Transaction no. | ||
| invat_transactiontype | varchar(5) | Transaction type | ||
| invat_vatamount | numeric(13) | Vat amount | ||
| invat_vatdisallowed | Vat Discount allowed | |||
| invat_vatrate | VAT rate |