InvoiceDetail object :: SystemsLink

InvoiceDetail properties and column mapping

To condense the information in this table, the Database Column Name uses the following abbreviations for database tables:

i =invoicedetail

	Property	Database Column
	Name	Data Type (in C#)	Name	Data Type	Modifiable	Comments
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	cmd_code	string	i.cmd_code	varchar(8)	Insert/Update
12	cmp_id	string	i.cmp_id	varchar(8)	Insert/Update
13	cur_code	string	i.cur_code	varchar(6)	Insert/Update
14	DataSourceID	string			N/A	Not mapped
15	evt_number	int	i.evt_number	int	Insert/Update
16	fakestatus	bool			Read-only	Not mapped
17	fgt_number	int	fgt_number	int	Insert/Update
18	fgt_supplier	string	i.fgt_supplier	varchar(8)	Insert/Update
19	IsDirty	bool			N/A	Not mapped or used in service
20	IsNew	bool			N/A	Not mapped, set to false during save to update
21	IsValid	bool			N/A	Not mapped or used in service
22	ivd_actual_quantity	float	i.ivd_actual_quantity	float	Insert/Update
23	ivd_actual_unit	string	i.ivd_actual_unit	varchar(6)	Insert/Update
24	ivd_allocatedrevenue	decimal	i.ivd_allocatedrev	money	Insert/Update
25	ivd_ARTaxAuth	string	i.ivd_ARTaxAuth	varchar(6)	Insert/Update
26	ivd_baserate	decimal	i.ivd_baserate	decimal(19,4)	Insert/Update
27	ivd_billable_flag	string	i.ivd_billable_flag	varchar(1)	Insert/Update
28	ivd_billto	string	i.ivd_billto	varchar(8)	Insert/Update
29	ivd_bolid	int	i.ivd_bolid	int	Insert/Update
30	ivd_car_key	int	i.ivd_car_key	int	Insert/Update
31	ivd_cbadjustment	decimal	i.ivd_cbadjustment	decimal(19,4)	Insert/Update
32	ivd_charge	decimal	i.ivd_charge	money	Insert/Update
33	ivd_charge_type	int	i.ivd_charge_type	smallint	Insert/Update
34	ivd_comment	string	i.ivd_comment	varchar(255)	Insert/Update
35	ivd_count	float	i.ivd_count	decimal(10,2)	Insert/Update
36	ivd_countunit	string	i.ivd_countunit	varchar(6)	Insert/Update
37	ivd_currencydate	DateTime	i.ivd_currencydate	datetime	Insert/Update
38	ivd_description	string	i.ivd_description	varchar(60)	Insert/Update
39	ivd_distance	float	i.ivd_distance	float	Insert/Update
40	ivd_distunit	string	i.ivd_distunit	varchar(6)	Insert/Update
41	ivd_empty_distance	float	i.ivd_empty_distance	float	Insert/Update
42	ivd_exportstatus	string	i.ivd_exportstatus	char(6)	Insert/Update
43	ivd_fromord	string	i.ivd_fromord	char(1)	Insert/Update
44	ivd_fsc	decimal	i.ivd_fsc	decimal(19,4)	Insert/Update
45	ivd_glnum	string	i.ivd_glnum	char(32)	Insert/Update
46	ivd_height	float	i.ivd_height	money	Insert/Update
47	ivd_heightunit	string	i.ivd_heightunit	varchar(6)	Insert/Update
48	ivd_hide	string	i.ivd_hide	char(1)	Insert/Update
49	ivd_invoicestatus	string	i.ivd_invoicestatus	varchar(6)	Insert/Update
50	ivd_leaseassetid	int	i.ivd_leaseassetid	int	Insert/Update
51	ivd_length	float	i.ivd_length	money	Insert/Update
52	ivd_lengthunit	string	i.ivd_lengthunit	varchar(6)	Insert/Update
53	ivd_loaded_distance	float	i.ivd_loaded_distance	float	Insert/Update
54	ivd_loadingmeters	float	i.ivd_loadingmeters	decimal(18,0)	Insert/Update
55	ivd_loadingmeters_unit	string	i.ivd_loadingmeters_unit	varchar(6)	Insert/Update
56	ivd_MaskFromRating	string	i.ivd_MaskFromRating	char(1)	Insert/Update
57	ivd_mileagetable	string	i.ivd_mileagetable	varchar(2)	Insert/Update
58	ivd_miscmoney1	decimal	i.ivd_miscmoney1	money	Insert/Update
59	ivd_number	int	i.ivd_number	int	Insert/Update	Required for update
60	ivd_oradjustment	decimal	i.ivd_oradjustment	decimal(19,4)	Insert/Update
61	ivd_ord_number	string	i.ivd_ord_number	varchar(13)	Insert/Update
62	ivd_ordered_count	decimal	i.ivd_ordered_count	decimal(18,0)	Insert/Update
63	ivd_ordered_loadingmeters	decimal	i.ivd_ordered_loadingmeters	decimal(18,0)	Insert/Update
64	ivd_ordered_volume	decimal	i.ivd_ordered_volume	decimal(18,0)	Insert/Update
65	ivd_ordered_weight	decimal	i.ivd_ordered_weight	decimal(18,0)	Insert/Update
66	ivd_orig_cmpid	string	i.ivd_orig_cmpid	varchar(8)	Insert/Update
67	ivd_paid_amount	decimal	i.ivd_paid_amount	money	Insert/Update
68	ivd_paid_indicator	string	i.ivd_paid_indicator	char(1)	Insert/Update
69	ivd_paylgh_number	int	i.ivd_paylgh_number	int	Insert/Update
70	ivd_payrevenue	decimal	i.ivd_payrevenue	money	Insert/Update
71	ivd_post_invoice	string	i.ivd_post_invoice	char(1)	Insert/Update
72	ivd_quantity	decimal	i.ivd_quantity	float	Insert/Update
73	ivd_quantity_type	int	i.ivd_quantity_type	smallint	Insert/Update
74	ivd_rate	decimal	i.ivd_rate	money	Insert/Update
75	ivd_rate_type	int	i.ivd_rate_type	smallint	Insert/Update
76	ivd_rateunit	string	i.ivd_rateunit	varchar(6)	Insert/Update
77	ivd_rawcharge	decimal	i.ivd_rawcharge	decimal(19,4)	Insert/Update
78	ivd_refnum	string	i.ivd_refnum	varchar(30)	Insert/Update
79	ivd_reftype	string	i.ivd_reftype	varchar(6)	Insert/Update
80	ivd_remark	string	i.ivd_remark	varchar(255)	Insert/Update
81	ivd_revtype1	string	i.ivd_revtype1	varchar(6)	Insert/Update
82	ivd_sequence	int	i.ivd_sequence	int	Insert/Update
83	ivd_shared_wgt	decimal	i.ivd_shared_wgt	decimal(19,4)	Insert/Update
84	ivd_showas_cmpid	string	i.ivd_showas_cmpid	varchar(8)	Insert/Update
85	ivd_sign	short	i.ivd_sign	smallint	Insert/Update
86	ivd_splitbillratetype	string	i.ivd_splitbillratetype	varchar(10)	Insert/Update
87	ivd_subtotalptr	int	i.ivd_subtotalptr	int	Insert/Update
88	ivd_tariff_type	string	i.ivd_tariff_type	char(1)	Insert/Update
89	ivd_tax_basis	decimal	i.ivd_tax_basis	money	Insert/Update
90	ivd_taxable1	bool	i.ivd_taxable1	char(1)	Insert/Update
91	ivd_taxable2	bool	i.ivd_taxable2	char(1)	Insert/Update
92	ivd_taxable3	bool	i.ivd_taxable3	char(1)	Insert/Update
93	ivd_taxable4	bool	i.ivd_taxable4	char(1)	Insert/Update
94	ivd_taxid	string	i.ivd_taxid	varchar(15)	Insert/Update
95	ivd_tollcost	decimal	i.ivd_tollcost	money	Insert/Update
96	ivd_transdate	DateTime	i.ivd_transdate	datetime	Insert/Update
97	ivd_trl_rent	string	i.ivd_trl_rent	varchar(13)	Insert/Update
98	ivd_trl_rent_end	DateTime	i.ivd_trl_rent_end	datetime	Insert/Update
99	ivd_trl_rent_start	DateTime	i.ivd_trl_rent_start	datetime	Insert/Update
100	ivd_type	string	i.ivd_type	varchar(6)	Insert/Update
101	ivd_unit	string	i.ivd_unit	varchar(6)	Insert/Update
102	ivd_volume	float	i.ivd_volume	float	Insert/Update
103	ivd_volunit	string	i.ivd_volunit	varchar(6)	Insert/Update
104	ivd_wgt	float	i.ivd_wgt	float	Insert/Update
105	ivd_wgtunit	string	i.ivd_wgtunit	varchar(6)	Insert/Update
106	ivd_width	float	i.ivd_width	money	Insert/Update
107	ivd_widthunit	string	i.ivd_widthunit	varchar(6)	Insert/Update
108	ivd_zipcode	string	i.ivd_zipcode	varchar(10)	Insert/Update
109	ivh_hdrnumber	int	i.ivh_hdrnumber	int	Insert/Update
110	last_updateby	string	i.last_updateby	varchar(256)	Insert/Update
111	last_updatedate	DateTime	i.last_updatedate	datetime	Insert/Update
112	mfh_hdrnumber	int	i.mfh_hdrnumber	int	Insert/Update
113	ord_hdrnumber	int	i.ord_hdrnumber	int	Insert/Update
114	stp_number	int	i.stp_number	int	Insert/Update
115	tar_number	int	i.tar_number	int	Insert/Update
116	tar_tariffitem	string	i.tar_tariffitem	varchar(12)	Insert/Update
117	tar_tariffnumber	string	i.tar_tariffnumber	varchar(12)	Insert/Update
118	UpdateableProperties	InvoiceDetailUpdateInfo			N/A	Not mapped

Property

Database Column

Name

Data Type (in C#)

Name

Data Type

Modifiable

Comments

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

cmd_code

string

i.cmd_code

varchar(8)

Insert/Update

12

cmp_id

string

i.cmp_id

varchar(8)

Insert/Update

13

cur_code

string

i.cur_code

varchar(6)

Insert/Update

14

DataSourceID

string

N/A

Not mapped

15

evt_number

int

i.evt_number

int

Insert/Update

16

fakestatus

bool

Read-only

Not mapped

17

fgt_number

int

fgt_number

int

Insert/Update

18

fgt_supplier

string

i.fgt_supplier

varchar(8)

Insert/Update

19

IsDirty

bool

N/A

Not mapped or used in service

20

IsNew

bool

N/A

Not mapped, set to false during save to update

21

IsValid

bool

N/A

Not mapped or used in service

22

ivd_actual_quantity

float

i.ivd_actual_quantity

float

Insert/Update

23

ivd_actual_unit

string

i.ivd_actual_unit

varchar(6)

Insert/Update

24

ivd_allocatedrevenue

decimal

i.ivd_allocatedrev

money

Insert/Update

25

ivd_ARTaxAuth

string

i.ivd_ARTaxAuth

varchar(6)

Insert/Update

26

ivd_baserate

decimal

i.ivd_baserate

decimal(19,4)

Insert/Update

27

ivd_billable_flag

string

i.ivd_billable_flag

varchar(1)

Insert/Update

28

ivd_billto

string

i.ivd_billto

varchar(8)

Insert/Update

29

ivd_bolid

int

i.ivd_bolid

int

Insert/Update

30

ivd_car_key

int

i.ivd_car_key

int

Insert/Update

31

ivd_cbadjustment

decimal

i.ivd_cbadjustment

decimal(19,4)

Insert/Update

32

ivd_charge

decimal

i.ivd_charge

money

Insert/Update

33

ivd_charge_type

int

i.ivd_charge_type

smallint

Insert/Update

34

ivd_comment

string

i.ivd_comment

varchar(255)

Insert/Update

35

ivd_count

float

i.ivd_count

decimal(10,2)

Insert/Update

36

ivd_countunit

string

i.ivd_countunit

varchar(6)

Insert/Update

37

ivd_currencydate

DateTime

i.ivd_currencydate

datetime

Insert/Update

38

ivd_description

string

i.ivd_description

varchar(60)

Insert/Update

39

ivd_distance

float

i.ivd_distance

float

Insert/Update

40

ivd_distunit

string

i.ivd_distunit

varchar(6)

Insert/Update

41

ivd_empty_distance

float

i.ivd_empty_distance

float

Insert/Update

42

ivd_exportstatus

string

i.ivd_exportstatus

char(6)

Insert/Update

43

ivd_fromord

string

i.ivd_fromord

char(1)

Insert/Update

44

ivd_fsc

decimal

i.ivd_fsc

decimal(19,4)

Insert/Update

45

ivd_glnum

string

i.ivd_glnum

char(32)

Insert/Update

46

ivd_height

float

i.ivd_height

money

Insert/Update

47

ivd_heightunit

string

i.ivd_heightunit

varchar(6)

Insert/Update

48

ivd_hide

string

i.ivd_hide

char(1)

Insert/Update

49

ivd_invoicestatus

string

i.ivd_invoicestatus

varchar(6)

Insert/Update

50

ivd_leaseassetid

int

i.ivd_leaseassetid

int

Insert/Update

51

ivd_length

float

i.ivd_length

money

Insert/Update

52

ivd_lengthunit

string

i.ivd_lengthunit

varchar(6)

Insert/Update

53

ivd_loaded_distance

float

i.ivd_loaded_distance

float

Insert/Update

54

ivd_loadingmeters

float

i.ivd_loadingmeters

decimal(18,0)

Insert/Update

55

ivd_loadingmeters_unit

string

i.ivd_loadingmeters_unit

varchar(6)

Insert/Update

56

ivd_MaskFromRating

string

i.ivd_MaskFromRating

char(1)

Insert/Update

57

ivd_mileagetable

string

i.ivd_mileagetable

varchar(2)

Insert/Update

58

ivd_miscmoney1

decimal

i.ivd_miscmoney1

money

Insert/Update

59

ivd_number

int

i.ivd_number

int

Insert/Update

Required for update

60

ivd_oradjustment

decimal

i.ivd_oradjustment

decimal(19,4)

Insert/Update

61

ivd_ord_number

string

i.ivd_ord_number

varchar(13)

Insert/Update

62

ivd_ordered_count

decimal

i.ivd_ordered_count

decimal(18,0)

Insert/Update

63

ivd_ordered_loadingmeters

decimal

i.ivd_ordered_loadingmeters

decimal(18,0)

Insert/Update

64

ivd_ordered_volume

decimal

i.ivd_ordered_volume

decimal(18,0)

Insert/Update

65

ivd_ordered_weight

decimal

i.ivd_ordered_weight

decimal(18,0)

Insert/Update

66

ivd_orig_cmpid

string

i.ivd_orig_cmpid

varchar(8)

Insert/Update

67

ivd_paid_amount

decimal

i.ivd_paid_amount

money

Insert/Update

68

ivd_paid_indicator

string

i.ivd_paid_indicator

char(1)

Insert/Update

69

ivd_paylgh_number

int

i.ivd_paylgh_number

int

Insert/Update

70

ivd_payrevenue

decimal

i.ivd_payrevenue

money

Insert/Update

71

ivd_post_invoice

string

i.ivd_post_invoice

char(1)

Insert/Update

72

ivd_quantity

decimal

i.ivd_quantity

float

Insert/Update

73

ivd_quantity_type

int

i.ivd_quantity_type

smallint

Insert/Update

74

ivd_rate

decimal

i.ivd_rate

money

Insert/Update

75

ivd_rate_type

int

i.ivd_rate_type

smallint

Insert/Update

76

ivd_rateunit

string

i.ivd_rateunit

varchar(6)

Insert/Update

77

ivd_rawcharge

decimal

i.ivd_rawcharge

decimal(19,4)

Insert/Update

78

ivd_refnum

string

i.ivd_refnum

varchar(30)

Insert/Update

79

ivd_reftype

string

i.ivd_reftype

varchar(6)

Insert/Update

80

ivd_remark

string

i.ivd_remark

varchar(255)

Insert/Update

81

ivd_revtype1

string

i.ivd_revtype1

varchar(6)

Insert/Update

82

ivd_sequence

int

i.ivd_sequence

int

Insert/Update

83

ivd_shared_wgt

decimal

i.ivd_shared_wgt

decimal(19,4)

Insert/Update

84

ivd_showas_cmpid

string

i.ivd_showas_cmpid

varchar(8)

Insert/Update

85

ivd_sign

short

i.ivd_sign

smallint

Insert/Update

86

ivd_splitbillratetype

string

i.ivd_splitbillratetype

varchar(10)

Insert/Update

87

ivd_subtotalptr

int

i.ivd_subtotalptr

int

Insert/Update

88

ivd_tariff_type

string

i.ivd_tariff_type

char(1)

Insert/Update

89

ivd_tax_basis

decimal

i.ivd_tax_basis

money

Insert/Update

90

ivd_taxable1

bool

i.ivd_taxable1

char(1)

Insert/Update

91

ivd_taxable2

bool

i.ivd_taxable2

char(1)

Insert/Update

92

ivd_taxable3

bool

i.ivd_taxable3

char(1)

Insert/Update

93

ivd_taxable4

bool

i.ivd_taxable4

char(1)

Insert/Update

94

ivd_taxid

string

i.ivd_taxid

varchar(15)

Insert/Update

95

ivd_tollcost

decimal

i.ivd_tollcost

money

Insert/Update

96

ivd_transdate

DateTime

i.ivd_transdate

datetime

Insert/Update

97

ivd_trl_rent

string

i.ivd_trl_rent

varchar(13)

Insert/Update

98

ivd_trl_rent_end

DateTime

i.ivd_trl_rent_end

datetime

Insert/Update

99

ivd_trl_rent_start

DateTime

i.ivd_trl_rent_start

datetime

Insert/Update

100

ivd_type

string

i.ivd_type

varchar(6)

Insert/Update

101

ivd_unit

string

i.ivd_unit

varchar(6)

Insert/Update

102

ivd_volume

float

i.ivd_volume

float

Insert/Update

103

ivd_volunit

string

i.ivd_volunit

varchar(6)

Insert/Update

104

ivd_wgt

float

i.ivd_wgt

float

Insert/Update

105

ivd_wgtunit

string

i.ivd_wgtunit

varchar(6)

Insert/Update

106

ivd_width

float

i.ivd_width

money

Insert/Update

107

ivd_widthunit

string

i.ivd_widthunit

varchar(6)

Insert/Update

108

ivd_zipcode

string

i.ivd_zipcode

varchar(10)

Insert/Update

109

ivh_hdrnumber

int

i.ivh_hdrnumber

int

Insert/Update

110

last_updateby

string

i.last_updateby

varchar(256)

Insert/Update

111

last_updatedate

DateTime

i.last_updatedate

datetime

Insert/Update

112

mfh_hdrnumber

int

i.mfh_hdrnumber

int

Insert/Update

113

ord_hdrnumber

int

i.ord_hdrnumber

int

Insert/Update

114

stp_number

int

i.stp_number

int

Insert/Update

115

tar_number

int

i.tar_number

int

Insert/Update

116

tar_tariffitem

string

i.tar_tariffitem

varchar(12)

Insert/Update

117

tar_tariffnumber

string

i.tar_tariffnumber

varchar(12)

Insert/Update

118

UpdateableProperties

InvoiceDetailUpdateInfo

N/A

Not mapped

InvoiceDetail methods

The Return Value for all methods is InvoiceDetail.ReturnObject.

Internal

	Parameters
Method Name	Name	Data type (in C#)	InvoiceDetail.ReturnObject. ReturnCode	Description
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	int	0 = successful 100 = no records found 1000 = errors occurred	Deletes the InvoiceDetail object with the specified ivd_number

Parameters

Method Name

Name

Data type (in C#)

InvoiceDetail.ReturnObject.
ReturnCode

Description

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

int

0 = successful

100 = no records found

1000 = errors occurred

Deletes the InvoiceDetail object with the specified ivd_number

External

	Parameters
Method Name	Name	Data type (in C#)	InvoiceDetail.ReturnObject. ReturnCode	Description
NewInvoiceDetail	tokenValue	string	0 = successful 1000 = errors occurred	Creates a new InvoiceDetail object in memory
NewInvoiceDetails	tokenValue	string	0 = successful 1000 = errors occurred	Creates the specified number of new InvoiceDetail objects in memory
	total	int
RetrieveInvoiceDetail	tokenValue	string	0 = successful 100 = no records found 1000 = errors occurred	Returns all InvoiceDetail objects that meet the provided criteria
	criteria	InvoiceDetail.Criteria
SaveInvoiceDetail	tokenValue	string	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
	invoiceDetails	List<InvoiceDetail>
	updateDB	bool
DeleteInvoiceDetail	tokenValue	string	0 = successful 100 = no records found 1000 = errors occurred	Deletes the InvoiceDetail object with the specified ivd_number
	ivd_number	int

Parameters

Method Name

Name

Data type (in C#)

InvoiceDetail.ReturnObject.
ReturnCode

Description

NewInvoiceDetail

tokenValue

string

0 = successful

1000 = errors occurred

Creates a new InvoiceDetail object in memory

NewInvoiceDetails

tokenValue

string

0 = successful

1000 = errors occurred

Creates the specified number of new InvoiceDetail objects in memory

total

int

RetrieveInvoiceDetail

tokenValue

string

0 = successful

100 = no records found

1000 = errors occurred

Returns all InvoiceDetail objects that meet the provided criteria

criteria

InvoiceDetail.Criteria

SaveInvoiceDetail

tokenValue

string

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

invoiceDetails

List<InvoiceDetail>

updateDB

bool

DeleteInvoiceDetail

tokenValue

string

0 = successful

100 = no records found

1000 = errors occurred

Deletes the InvoiceDetail object with the specified ivd_number

ivd_number

int

InvoiceDetail.ReturnObject

	Property Name	Data Type (in C#)
1	ErrorMessages	List<string>
2	ErrorObjectIndexList	List<int>
3	Exceptions	List<Exception>
4	ReferenceObjects	List<InvoiceDetail>
5	ReturnCode	int
6	TraceMessages	List<string>
7	WarningMessages	List<string>

Property Name

Data Type (in C#)

Comments

1

ErrorMessages

List<string>

2

ErrorObjectIndexList

List<int>

3

Exceptions

List<Exception>

4

ReferenceObjects

List<InvoiceDetail>

5

ReturnCode

int

6

TraceMessages

List<string>

7

WarningMessages

List<string>

InvoiceDetailUpdateInfo object

Data types (in C#) for all properties are bool.
Set the property to true to update the corresponding InvoiceDetail property.

	Property Name
1	cht_basisunit
2	cht_class
3	cht_itemcode
4	cht_lh_min
5	cht_lh_prn
6	cht_lh_rev
7	cht_lh_rpt
8	cht_lh_stl
9	cht_rollintolh
10	cmd_code
11	cmp_id
12	cur_code
13	evt_number
14	fakestatus
15	fgt_number
16	fgt_supplier
17	ivd_actual_quantity
18	ivd_actual_unit
19	ivd_allocatedrevenue
20	ivd_ARTaxAuth
21	ivd_baserate
22	ivd_billable_flag
23	ivd_billto
24	ivd_bolid
25	ivd_car_key
26	ivd_cbadjustment
27	ivd_charge
28	ivd_charge_type
29	ivd_comment
30	ivd_count
31	ivd_countunit
32	ivd_currencydate
33	ivd_description
34	ivd_distance
35	ivd_distunit
36	ivd_empty_distance
37	ivd_exportstatus
38	ivd_fromord
39	ivd_fsc
40	ivd_glnum
41	ivd_height
42	ivd_heightunit
43	ivd_hide
44	ivd_invoicestatus
45	ivd_leaseassetid
46	ivd_length
47	ivd_lengthunit
48	ivd_loaded_distance
49	ivd_loadingmeters
50	ivd_loadingmeters_unit
51	ivd_MaskFromRating
52	ivd_mileagetable
53	ivd_miscmoney1
54	ivd_number
55	ivd_oradjustment
56	ivd_ord_number
57	ivd_ordered_count
58	ivd_ordered_loadingmeters
59	ivd_ordered_volume
60	ivd_ordered_weight
61	ivd_orig_cmpid
62	ivd_paid_amount
63	ivd_paid_indicator
64	ivd_paylgh_number
65	ivd_payrevenue
66	ivd_post_invoice
67	ivd_quantity
68	ivd_quantity_type
69	ivd_rate
70	ivd_rate_type
71	ivd_rateunit
72	ivd_rawcharge
73	ivd_refnum
74	ivd_reftype
75	ivd_remark
76	ivd_revtype1
77	ivd_sequence
78	ivd_shared_wgt
79	ivd_showas_cmpid
80	ivd_sign
81	ivd_splitbillratetype
82	ivd_subtotalptr
83	ivd_tariff_type
84	ivd_tax_basis
85	ivd_taxable1
86	ivd_taxable2
87	ivd_taxable3
88	ivd_taxable4
89	ivd_taxid
90	ivd_tollcost
91	ivd_transdate
92	ivd_trl_rent
93	ivd_trl_rent_end
94	ivd_trl_rent_start
95	ivd_type
96	ivd_unit
97	ivd_volume
98	ivd_volunit
99	ivd_wgt
100	ivd_wgtunit
101	ivd_width
102	ivd_widthunit
103	ivd_zipcode
104	ivh_hdrnumber
105	mfh_hdrnumber
106	ord_hdrnumber
107	stp_number
108	tar_number
109	tar_tariffitem
110	tar_tariffnumber

InvoiceDetail Criteria object

To condense the information in the table, the Database Column uses the following abbreviations for database tables:

i = invoicedetail

	Name	Database Column	Data Type (in C#)
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?

Name

Database Column

Data Type (in C#)

Comments

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?