Module List > Module ASI tables ASI25806
You are currently viewing the COMPANY database.
Change

COMPANY..ASI25806 Table Definition

(COMPANY..)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
USERID char

The user t...(more) Join Now
join ... more text available
CMPANYID smallint

Company ID...(more) Join Now WPPU0114.CMPANYID
join ... more text available
PABill_Format_Key smallint


PADocnumber20 char


PACONTNUMBER char

PA Contrac...(more) Join Now PA01101.PACONTNUMBER
PAPROJNUMBER char

PA Project...(more) Join Now PA11801.PAPROJNUMBER
join ... more text available
PATranType smallint

The Type o...(more) Join Now PA01901.PATranType
PA_Long_Transaction_Name char


PAUD1Proj char


PAStatText char


LNITMSEQ int

Line Item ...(more) Join Now PA11801.LNITMSEQ
PABILLSEQ int


PAPrintSortOrd smallint


PAQtyQ numeric


PAACREV numeric


PAORIACCRREV numeric


PATOTCST numeric


PAORIGTOTCOST numeric


PATQTY numeric


PAtotbillings numeric


PAOrigTotalBilings numeric


PARecognizedRevenue numeric


PAOrigRecogRevenue numeric


PATOTTAX numeric


PAOrigTotalTaxAmt numeric


PABACKBILL numeric


PAOrigBackoutBillAmt numeric


TRDISAMT numeric

Trade Disc...(more) Join Now PA11801.TRDISAMT
ORTDISAM numeric


PATOTALOVERH numeric


PAORIGTOTOVRHD numeric


PATotAmt numeric

PA Total A...(more) Join Now PA02101.PATotAmt
PATotAmt1 numeric


PATax_Detail_ID_Array_1 char


PATax_Detail_ID_Array_2 char


PATax_Detail_ID_Array_3 char


PATax_Detail_ID_Array_4 char


PATax_Detail_ID_Array_5 char


PATax_Detail_ID_Array_6 char


PATax_Detail_ID_Array_7 char


PATax_Detail_ID_Array_8 char


PATax_Detail_ID_Array_9 char


PATax_Detail_ID_Array_10 char


PATax_Amount_Array_1 numeric


PATax_Amount_Array_2 numeric


PATax_Amount_Array_3 numeric


PATax_Amount_Array_4 numeric


PATax_Amount_Array_5 numeric


PATax_Amount_Array_6 numeric


PATax_Amount_Array_7 numeric


PATax_Amount_Array_8 numeric


PATax_Amount_Array_9 numeric


PATax_Amount_Array_10 numeric


PAOTaxAmtArr_1 numeric


PAOTaxAmtArr_2 numeric


PAOTaxAmtArr_3 numeric


PAOTaxAmtArr_4 numeric


PAOTaxAmtArr_5 numeric


PAOTaxAmtArr_6 numeric


PAOTaxAmtArr_7 numeric


PAOTaxAmtArr_8 numeric


PAOTaxAmtArr_9 numeric


PAOTaxAmtArr_10 numeric


PAWrite_UpDown_Amount numeric

PA Write U...(more) Join Now PA11801.PAWrite_UpDown_Amount
PAOrigWUDAmt numeric


DEX_ROW_ID int
auto number (1,1)
Unique ide...(more) Join Now
PAtx500 text


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