Module List > Module BS tables B3900902
You are currently viewing the COMPANY database.
Change

COMPANY..B3900902 Table Definition

(COMPANY..BSSI_AdvanceAcctSubsSetup)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
MODULE1 smallint
0

BSSI_SubModule smallint
0

BSSI_TransactionType int
0

DISTTYPE smallint
0

Distribution

Type

Integer Value

Sales /

Invoices

Sched

Payments

Debit

Memos

Finance

Charges

Service

Repairs

Warranty

Credit

Memos

Returns

Cash

Receipts

Cash

1

*

na

*

*

*

 

*

*

*

Terms Taken

2

*

na

*

*

*

 

*

*

*

Accts Rec

3

*

na

*

*

*

 

*

*

*

Writeoffs

4

 

na

 

 

 

 

*

*

*

Terms Avail

5

*

na

*

*

*

 

*

*

*

GST

6

 

na

 

 

 

 

*

*

*

PPS

7

 

na

 

 

 

 

*

*

*

Other

8

*

na

*

*

*

*

*

*

*

Sales

9

*

na

 

 

 

 

 

 

 

Trade

10

*

na

*

*

*

*

*

*

 

Freight

11

*

na

*

*

*

*

*

*

 

Miscellaneous

12

*

na

*

*

*

*

*

*

 

Taxes

13

*

na

*

*

*

*

*

*

 

COGS

14

*

na

*

*

*

*

*

*

 

Inventory

15

*

na

*

*

*

*

*

*

 

Finance Chrg

16

 

na

 

*

 

 

 

 

 

Returns

17

 

na

 

 

 

 

 

*

 

Debit Memo

18

 

na

*

 

 

 

 

 

 

Credit Memo

19

 

na

 

 

 

 

*

 

 

Service

20

 

na

 

 

*

 

 

 

 

Warr Exp

21

 

na

 

 

 

*

 

 

 

Warr Sls

22

 

na

 

 

 

*

 

 

 

Comm Exp

23

*

na

*

*

*

 

*

*

 

Comm Pay

24

*

na

*

*

*

 

*

*

 

Unit Acc

25

*

na

*

*

*

*

*

*

*

ROUND

26

*

na

*

*

*

 

*

*

*

RZGain

27

*

na

*

*

*

 

*

*

*

RZLOSS

28

*

na

*

*

*

 

*

*

*

URZGain

29

*

na

*

*

*

 

*

*

*

URZLoss

30

*

na

*

*

*

 

*

*

*

RVLPD030.DISTTYPE
BSSI_DisableModAcctSub tinyint
0

DEX_ROW_ID int
auto number (1,1)
Unique ide...(more) Join Now
Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables
3