KS_INVOICES

1

Invoice Number

string

30

Y

XREF LOOKUP

2

Customer Number

string

30

XREF LOOKUP

3

Sold To Name

string

50

4

Invoice Type

string

1

Y

S=Sales Invoice C=Credit Invoice

5

Invoice Date

datetime

6

Invoice Status

string

1

Y

O=Open C=Closed (paid) X=Cancelled

7

Order Type

string

1

S=Sales Order
R=RMA
C=Credit Sales Order

If the invoice type = 'C' for credit it is likely associated with an RMA ('R') or Credit Sales Order ('C'). If the invoice type = 'S' for a sale it is likely associated with a Sales Order ('S') or and RMA ('R') for the shipped replacement part with charges.

8

Order Number

string

30

XREF LOOKUP; Either the Sales order or RMA order number

9

Delivery Number

string

30

XREF LOOKUP; Either the Receipt or Shipment number

10

Invoice Class

string

50

User defined field. Example uses: DIRECT SALES', 'POINT-OF-SALES', 'MISC', 'ADJUSTMENT'

11

Product Amount

money

This is the sum of all line item charges for the invoice (units X unit price)

12

Freight Amount

money

This is the total freight charges for the invoice

13

Insurance Amount

money

This is the total insurance charges for the invoice

14

Tax Amount

money

This is the total tax for the invoice

15

Other Amount

money

This field can be used for the total of any other charges other than product, freight, tax, and insurance

16

SalesRep

string

10

17

Currency Code

string

10

This field is only populated with a currency code if the invoice was transacted in a foreign currency otherwise it is blank

18

Trans Product Amount

money

Used if transacted in foreign currency otherwise it can be blank or equal to Product Amount field

19

Trans Freight Amount

money

Used if transacted in foreign currency otherwise it can be blank or equal to Freight Amount field

20

Trans Sales Tax

money

Used if transacted in foreign currency otherwise it can be blank or equal to Tax Amount field

21

Trans Insurance Amount

money

Used if transacted in foreign currency otherwise it can be blank or equal to Insurance Amount field

22

Trans Other Amount

money

Used if transacted in foreign currency otherwise it can be blank or equal to Other Amount field

23

Project Number

string

30

XREF LOOKUP; Any reference to a project number such as a service order in webServiceCenter or regular project in webTeam. Leave blank if neither of these applications are used.

24

Invoice Line No

integer

4

Y

25

Part Number

string

25

If the item exists in the item_master table (FK) the item_id column will be updated as well.

26

Invoice Item Desc

string

50

27

Unit Price

money

28

Trans Unit Price

money

Used if transacted in foreign currency otherwise it can be blank or equal to Unit Price field

29

Quantity

decimal

12,3

30

Discount %

decimal

5,2

This is the sales discount % for the line item on the invoice

31

Status

string

1

Y

32

region

string

30

Xref Lookup to find the right row. This is primarily used for webSalesForce application

33

Special Charge Code

integer

Y

Lookup based on special_charge.charge_xref_id

34

Special
Charge OrderLine

integer

If this field is left blank, then the special charge is assumed to apply to the whole invoice.

35

Special Charge Amount

money

Y

36

Memo

string

8000

Single value field which should not contain value/sub-value marks. Text marks are OK for carriage returns.

37

Price UOM

string

10

Y

The price unit of measure for this invoice item

38

Open BalanceAmount

money

39

Transaction Open Balance

money

40

Due Date

datetime