Module List > Module IV tables BM10200
You are currently viewing the COMPANY database.
Change

COMPANY..BM10200 Table Definition

(COMPANY..Assembly Transaction)

Contains assembly transaction header information.


4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
TRX_ID char(19)
''
TRX ID The...(more) Join Now
BM_Trx_Status smallint
0
BM Trx Sta...(more) Join Now
BCHSOURC char(15)
''
Batch Sour...(more) Join Now
BACHNUMB char(15)
''
Batch Numb...(more) Join Now
join ... more text available
Batch_ID_Note_Index numeric(19,5)
0.00
Batch ID N...(more) Join Now
Completion_Date datetime
'1/1/1900'
Completion...(more) Join Now
BM_Start_Date datetime
'1/1/1900'
TRX Start ...(more) Join Now
TRXDATE datetime
'1/1/1900'
TRX Date T...(more) Join Now
PSTGDATE datetime
'1/1/1900'
Posting Da...(more) Join Now
REFRENCE char(31)
''
Reference ...(more) Join Now
Quantity_Shortage_Status smallint
0
Quantity S...(more) Join Now
BM_Trx_Errors binary(4)
0
BM Trx Err...(more) Join Now
BM_Component_Errors binary(4)
0
BM Compone...(more) Join Now
NOTEINDX numeric(19,5)
0.00
Note Index...(more) Join Now
join ... more text available
MODIFDT datetime
'1/1/1900'
Date the r...(more) Join Now
USER2ENT char(15)
''
User To En...(more) Join Now
CREATDDT datetime
'1/1/1900'
Created Da...(more) Join Now
PTDUSRID char(15)
''
Posted Use...(more) Join Now
POSTEDDT datetime
'1/1/1900'
Posted Dat...(more) Join Now
TRXSORCE char(13)
''
Transactio...(more) Join Now
USERDEF1 char(21)
''
User Defin...(more) Join Now
USERDEF2 char(21)
''
User Defin...(more) Join Now
USRDEF03 char(21)
''
User Defin...(more) Join Now
USRDEF04 char(21)
''
User Defin...(more) Join Now
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