InvoiceDetail object

Name

Data type (in C#)

NewInvoiceDetail

N/A

0 = successful

1000 = errors occurred

Creates a new InvoiceDetail object in memory

NewInvoiceDetails

total

int

0 = successful

1000 = errors occurred

Creates the specified number of new InvoiceDetail objects in memory

RetrieveInvoiceDetail

criteria

InvoiceDetail.Criteria

0 = successful

100 = no records found

1000 = errors occurred

Returns all InvoiceDetail objects that meet the provided criteria

SaveInvoiceDetail

invoiceDetails

List<InvoiceDetail>

0 = successful

100 = validation errors occurred and updates prevented

500 = update proceeded with warnings

1000 = error occurred and updates prevented

Saves the provided InvoiceDetail objects and updates the database if requested, then returns the saved objects if the save was successful

updateDB

bool

DeleteInvoiceDetail

ivd_number

InvoiceDetail.Criteria

0 = successful

100 = no records found

1000 = errors occurred

Deletes all InvoiceDetail objects with the provided ivd_number

Name

Data Type (in C#)

Name

Data Type

1

Basis

string

Read only

Calculated

2

cht_basisunit

string

i.cht_basisunit

varchar(6)

Insert/Update

3

cht_class

string

i.cht_class

varchar(6)

Insert/Update

4

cht_itemcode

string

i.cht_itemcode

varchar(6)

Insert/Update

5

cht_lh_min

bool

i.cht_lh_min

char(1)

Insert/Update

6

cht_lh_prn

bool

i.cht_lh_prn

char(1)

Insert/Update

7

cht_lh_rev

bool

i.cht_lh_rev

char(1)

Insert/Update

8

cht_lh_rpt

bool

i.cht_lh_rpt

char(1)

Insert/Update

9

cht_lh_stl

bool

i.cht_lh_stl

char(1)

Insert/Update

10

cht_rollintolh

bool

i.cht_rollintolh

int

Insert/Update

11

CityName

string

Insert/Update

Calculated

12

cmd_code

string

i.cmd_code

varchar(8)

Insert/Update

13

cmp_id

string

i.cmp_id

varchar(8)

Insert/Update

14

CompanyName

string

Insert/Update

Calculated

15

cur_code

string

i.cur_code

varchar(6)

Insert/Update

16

DataSourceID

string

N/A

Not mapped

17

evt_number

int

i.evt_number

int

Insert/Update

18

fakestatus

bool

Read only

Not mapped

19

fgt_number

int

fgt_number

int

Insert/Update

20

fgt_supplier

string

i.fgt_supplier

varchar(8)

Insert/Update

21

HeaderCurrency

string

Insert/Update

Not mapped

22

HeaderStatus

string

Insert/Update

Not mapped

23

InvoiceNumber

string

Insert/Update

Not mapped

24

IsDirty

bool

N/A

Not mapped or used in service

25

IsNew

bool

N/A

Not mapped, set to false during save to update

26

IsValid

bool

N/A

Not mapped or used in service

27

ivd_actual_quantity

float

i.ivd_actual_quantity

float

Insert/Update

28

ivd_actual_unit

string

i.ivd_actual_unit

varchar(6)

Insert/Update

29

ivd_allocatedrevenue

decimal

i.ivd_allocatedrev

money

Insert/Update

30

ivd_ARTaxAuth

string

i.ivd_ARTaxAuth

varchar(6)

Insert/Update

31

ivd_baserate

decimal

i.ivd_baserate

decimal(19,4)

Insert/Update

32

ivd_billable_flag

string

i.ivd_billable_flag

varchar(1)

Insert/Update

33

ivd_billto

string

i.ivd_billto

varchar(8)

Insert/Update

34

ivd_bolid

int

i.ivd_bolid

int

Insert/Update

35

ivd_branch

string

i.ivd_branch

varchar(12)

Insert/Update

36

ivd_car_key

int

i.ivd_car_key

int

Insert/Update

37

ivd_cbadjustment

decimal

i.ivd_cbadjustment

decimal(19,4)

Insert/Update

38

ivd_charge

decimal

i.ivd_charge

money

Insert/Update

39

ivd_charge_type

bool

i.ivd_charge_type

smallint

Insert/Update

40

ivd_comment

string

i.ivd_comment

varchar(255)

Insert/Update

41

ivd_count

float

i.ivd_count

decimal(10,2)

Insert/Update

42

ivd_countunit

string

i.ivd_countunit

varchar(6)

Insert/Update

43

ivd_currencydate

DateTime

i.ivd_currencydate

datetime

Insert/Update

44

ivd_delays

string

i.ivd_delays

varchar(6)

Insert/Update

45

ivd_description

string

i.ivd_description

varchar(60)

Insert/Update

46

ivd_distance

float

i.ivd_distance

float

Insert/Update

47

ivd_distunit

string

i.ivd_distunit

varchar(6)

Insert/Update

48

ivd_empty_distance

float

i.ivd_empty_distance

float

Insert/Update

49

ivd_exportstatus

string

i.ivd_exportstatus

char(6)

Insert/Update

50

ivd_fromord

string

i.ivd_fromord

char(1)

Insert/Update

51

ivd_fsc

decimal

i.ivd_fsc

decimal(19,4)

Insert/Update

52

ivd_glnum

string

i.ivd_glnum

char(32)

Insert/Update

53

ivd_height

float

i.ivd_height

money

Insert/Update

54

ivd_heightunit

string

i.ivd_heightunit

varchar(6)

Insert/Update

55

ivd_hide

string

i.ivd_hide

char(1)

Insert/Update

56

ivd_invoicestatus

string

i.ivd_invoicestatus

varchar(6)

Insert/Update

57

ivd_leaseassetid

int

i.ivd_leaseassetid

int

Insert/Update

58

ivd_length

float

i.ivd_length

money

Insert/Update

59

ivd_lengthunit

string

i.ivd_lengthunit

varchar(6)

Insert/Update

60

ivd_loaded_distance

float

i.ivd_loaded_distance

float

Insert/Update

61

ivd_loadingmeters

float

i.ivd_loadingmeters

decimal(18,0)

Insert/Update

62

ivd_loadingmeters_unit

string

i.ivd_loadingmeters_unit

varchar(6)

Insert/Update

63

ivd_MaskFromRating

string

i.ivd_MaskFromRating

char(1)

Insert/Update

64

ivd_mileagetable

string

i.ivd_mileagetable

varchar(2)

Insert/Update

65

ivd_miscmoney1

decimal

i.ivd_miscmoney1

money

Insert/Update

66

ivd_number

int

i.ivd_number

int

Insert/Update

67

ivd_oradjustment

decimal

i.ivd_oradjustment

decimal(19,4)

Insert/Update

68

ivd_ord_number

string

i.ivd_ord_number

varchar(13)

Insert/Update

69

ivd_ordered_count

decimal

i.ivd_ordered_count

decimal(18,0)

Insert/Update

70

ivd_ordered_loadingmeters

decimal

i.ivd_ordered_loadingmeters

decimal(18,0)

Insert/Update

71

ivd_ordered_volume

decimal

i.ivd_ordered_volume

decimal(18,0)

Insert/Update

72

ivd_ordered_weight

decimal

i.ivd_ordered_weight

decimal(18,0)

Insert/Update

73

ivd_orig_cmpid

string

i.ivd_orig_cmpid

varchar(8)

Insert/Update

74

ivd_paid_amount

decimal

i.ivd_paid_amount

money

Insert/Update

75

ivd_paid_indicator

string

i.ivd_paid_indicator

char(1)

Insert/Update

76

ivd_paylgh_number

int

i.ivd_paylgh_number

int

Insert/Update

77

ivd_payrevenue

decimal

i.ivd_payrevenue

money

Insert/Update

78

ivd_post_invoice

string

i.ivd_post_invoice

char(1)

Insert/Update

79

ivd_quantity

decimal

i.ivd_quantity

float

Insert/Update

80

ivd_quantity_type

int

i.ivd_quantity_type

smallint

Insert/Update

81

ivd_rate

decimal

i.ivd_rate

money

Insert/Update

82

ivd_rate_type

bool

i.ivd_rate_type

smallint

Insert/Update

83

ivd_rateunit

string

i.ivd_rateunit

varchar(6)

Insert/Update

84

ivd_rawcharge

decimal

i.ivd_rawcharge

decimal(19,4)

Insert/Update

85

ivd_refnum

string

i.ivd_refnum

varchar(30)

Insert/Update

86

ivd_reftype

string

i.ivd_reftype

varchar(6)

Insert/Update

87

ivd_remark

string

i.ivd_remark

varchar(255)

Insert/Update

88

ivd_revtype1

string

i.ivd_revtype1

varchar(6)

Insert/Update

89

ivd_sequence

int

i.ivd_sequence

int

Insert/Update

90

ivd_shared_wgt

decimal

i.ivd_shared_wgt

decimal(19,4)

Insert/Update

91

ivd_showas_cmpid

string

i.ivd_showas_cmpid

varchar(8)

Insert/Update

92

ivd_sign

short

i.ivd_sign

smallint

Insert/Update

93

ivd_splitbillratetype

string

i.ivd_splitbillratetype

varchar(10)

Insert/Update

94

ivd_subtotalptr

int

i.ivd_subtotalptr

int

Insert/Update

95

ivd_tariff_type

string

i.ivd_tariff_type

char(1)

Insert/Update

96

ivd_tax_basis

decimal

i.ivd_tax_basis

money

Insert/Update

97

ivd_taxable1

bool

i.ivd_taxable1

char(1)

Insert/Update

98

ivd_taxable2

bool

i.ivd_taxable2

char(1)

Insert/Update

99

ivd_taxable3

bool

i.ivd_taxable3

char(1)

Insert/Update

100

ivd_taxable4

bool

i.ivd_taxable4

char(1)

Insert/Update

101

ivd_taxid

string

i.ivd_taxid

varchar(15)

Insert/Update

102

ivd_tollcost

decimal

i.ivd_tollcost

money

Insert/Update

103

ivd_transdate

DateTime

i.ivd_transdate

datetime

Insert/Update

104

ivd_trl_rent

string

i.ivd_trl_rent

varchar(13)

Insert/Update

105

ivd_trl_rent_end

DateTime

i.ivd_trl_rent_end

datetime

Insert/Update

106

ivd_trl_rent_start

DateTime

i.ivd_trl_rent_start

datetime

Insert/Update

107

ivd_type

string

i.ivd_type

varchar(6)

Insert/Update

108

ivd_unit

string

i.ivd_unit

varchar(6)

Insert/Update

109

ivd_volume

float

i.ivd_volume

float

Insert/Update

110

ivd_volunit

string

i.ivd_volunit

varchar(6)

Insert/Update

111

ivd_wgt

float

i.ivd_wgt

float

Insert/Update

112

ivd_wgtunit

string

i.ivd_wgtunit

varchar(6)

Insert/Update

113

ivd_width

float

i.ivd_width

money

Insert/Update

114

ivd_widthunit

string

i.ivd_widthunit

varchar(6)

Insert/Update

115

ivd_zipcode

string

i.ivd_zipcode

varchar(10)

Insert/Update

116

ivh_hdrnumber

int

i.ivh_hdrnumber

int

Insert/Update

117

last_updateby

string

i.last_updateby

varchar(256)

Insert/Update

118

last_updatedate

DateTime

i.last_updatedate

datetime

Insert/Update

119

mfh_hdrnumber

int

i.mfh_hdrnumber

int

Insert/Update

120

ord_hdrnumber

int

i.ord_hdrnumber

int

Insert/Update

121

Primary

bool

Insert/Update

122

stp_number

int

i.stp_number

int

Insert/Update

123

tar_number

int

i.tar_number

int

Insert/Update

124

tar_tariffitem

string

i.tar_tariffitem

varchar(12)

Insert/Update

125

tar_tariffnumber

string

i.tar_tariffnumber

varchar(12)

Insert/Update

126

UpdateableProperties

InvoiceDetailUpdateInfo

N/A

Not mapped

127

ValidationError

string

Insert/Update

Not mapped

1

cht_basisunit

29

ivd_charge_type

57

ivd_oradjustment

85

ivd_tariff_type

2

cht_class

30

ivd_comment

58

ivd_ord_number

86

ivd_tax_basis

3

cht_itemcode

31

ivd_count

59

ivd_ordered_count

87

ivd_taxable1

4

cht_lh_min

32

ivd_countunit

60

ivd_ordered_loadingmeters

88

ivd_taxable2

5

cht_lh_prn

33

ivd_currencydate

61

ivd_ordered_volume

89

ivd_taxable3

6

cht_lh_rev

34

ivd_delays

62

ivd_ordered_weight

90

ivd_taxable4

7

cht_lh_rpt

35

ivd_description

63

ivd_orig_cmpid

91

ivd_taxid

8

cht_lh_stl

36

ivd_distance

64

ivd_paid_amount

92

ivd_tollcost

9

cht_rollintolh

37

ivd_distunit

65

ivd_paid_indicator

93

ivd_transdate

10

cmd_code

38

ivd_empty_distance

66

ivd_paylgh_number

94

ivd_trl_rent

11

cmp_id

39

ivd_exportstatus

67

ivd_payrevenue

95

ivd_trl_rent_end

12

cur_code

40

ivd_fromord

68

ivd_post_invoice

96

ivd_trl_rent_start

13

evt_number

41

ivd_fsc

69

ivd_quantity

97

ivd_type

14

fakestatus

42

ivd_glnum

70

ivd_quantity_type

98

ivd_unit

15

fgt_number

43

ivd_height

71

ivd_rate

99

ivd_volume

16

fgt_supplier

44

ivd_heightunit

72

ivd_rate_type

100

ivd_volunit

17

ivd_actual_quantity

45

ivd_hide

73

ivd_rateunit

101

ivd_wgt

18

ivd_actual_unit

46

ivd_invoicestatus

74

ivd_rawcharge

102

ivd_wgtunit

19

ivd_allocatedrevenue

47

ivd_leaseassetid

75

ivd_refnum

103

ivd_width

20

ivd_ARTaxAuth

48

ivd_length

76

ivd_reftype

104

ivd_widthunit

21

ivd_baserate

49

ivd_lengthunit

77

ivd_remark

105

ivd_zipcode

22

ivd_billable_flag

50

ivd_loaded_distance

78

ivd_revtype1

106

ivh_hdrnumber

23

ivd_billto

51

ivd_loadingmeters

79

ivd_sequence

107

mfh_hdrnumber

24

ivd_bolid

52

ivd_loadingmeters_unit

80

ivd_shared_wgt

108

ord_hdrnumber

25

ivd_branch

53

ivd_MaskFromRating

81

ivd_showas_cmpid

109

stp_number

26

ivd_car_key

54

ivd_mileagetable

82

ivd_sign

110

tar_number

27

ivd_cbadjustment

55

ivd_miscmoney1

83

ivd_splitbillratetype

111

tar_tariffitem

28

ivd_charge

56

ivd_number

84

ivd_subtotalptr

112

tar_tariffnumber

1

cht_itemcode

i.cht_itemcode

string

2

ivd_charge

i.ivd_charge

decimal?

3

ivd_distance

i.ivd_distance

float?

4

ivd_fromord

i.ivd_fromord

string

5

ivd_number

i.ivd_number

int?

6

ivh_hdrnumber

i.ivh_hdrnumber

int?

7

mfh_hdrnumber

i.mfh_hdrnumber

int?

8

ord_hdrnumber

i.ord_hdrnumber

int?

9

stp_number

i.stp_number

int?