Module List > Module SV tables SV000816
You are currently viewing the COMPANY database.
Change

COMPANY..SV000816 Table Definition

(COMPANY..SV_Invoice_Trailing_Costs)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
Service_Call_ID char(17)


Call_Invoice_Number char(17)


Reference_TRX_Number char(17)


SEQNUMBR int

Field Type...(more) Join Now
WS_Cost_Code int


WS_Other_Cost_Sub_Code int


TRXSOURC char(25)


GLPOSTDT datetime

GLPostingDate GL Date that posts distributions when the transaction was posted PAM30900.GLPOSTDT
Divisions char(15)


Actual_Costs_At_Post numeric(19,5)


Committed_Costs_At_Post numeric(19,5)


Committed_Qty_At_Post numeric(19,5)


Committed_Unit_Cost numeric(19,5)


Trailing_Cost numeric(19,5)


ACTINDX_CR int


ACTINDX_DR int


RECONFLG tinyint


Reconcile_Date datetime


Reconcile_JRNENTRY int


Reconcile_SEQNUMBR int


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