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

COMPANY..ASI25833 Table Definition

(COMPANY..)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
CMPANYID smallint

Company ID...(more) Join Now WPPU0114.CMPANYID
join ... more text available
USERID char

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


PADocnumber20 char


LNITMSEQ int

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


PAReference_Line_Seq_N int


PACOSTDOCNO char


PACOSTSEQNO int


PAPROJNUMBER char

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

PA Transac...(more) Join Now PA11801.PATU
PACOSTCATID char

PA Cost Ca...(more) Join Now PA11801.PACOSTCATID
PAbllngtype smallint

PA Billing...(more) Join Now PA11801.PAbllngtype
PACOSTDATE datetime


PACOSTOWNER char


PAUnit_of_Measure char

PA Unit of...(more) Join Now PA11801.PAUnit_of_Measure
PAUNITCOST numeric

PA Unit Co...(more) Join Now PA11801.PAUNITCOST
PAProfitType smallint

PA Profit ...(more) Join Now PA11801.PAProfitType
PABILRATE numeric


PAMARKPERCENT numeric


PAQtyQ numeric


PAACREV numeric


PATOTCST numeric


PAWrite_UpDown_Amount numeric

PA Write U...(more) Join Now PA11801.PAWrite_UpDown_Amount
PAWrite_UpDown_Percenta int


PAApproved_Quantity numeric

PA Approve...(more) Join Now PA11801.PAApproved_Quantity
PAAPPROVBILLRATE numeric


PAAPPROVMKUPPCT numeric


PAApproved_Billing_Amou numeric


PARecognizedRevenue numeric


PATAXAMT numeric


PAbilltaxscheduleid char

PA Billing...(more) Join Now PA23201.PAbilltaxscheduleid
PABACKBILL numeric


PA_Trade_Discount_Amount numeric


PAAR_IDX int

From the R...(more) Join Now PA13203.PAAR_IDX
PACogs_Idx int

ACTIDX of ...(more) Join Now PA30101.PACogs_Idx
PARev_IDX int


PAUnbilled_AR_Idx int


PAUnbilled_Proj_Rev_Idx int


PACGBWIPIDX int

ACTIDX of ...(more) Join Now PA30101.PACGBWIPIDX
PABillSublineErrors binary


PA_Variance tinyint


PA_Variance_Accrued_Reve numeric


PAOrigUnitCost numeric


PAORIGBILLRATE numeric


PAORIACCRREV numeric


PAORIGTOTCOST numeric


PAOrigWUDAmt numeric


PAOrigApprBillRate numeric


PAOrigApprBillAmt numeric


PAOrigRecogRevenue numeric


PAORIGTAXAMT numeric


PAOrigBackoutBillAmt numeric


PAOrigTradeDiscAmt numeric


PAOrigVarAccruedRev numeric


PACHGORDNO char

PA Change ...(more) Join Now PA05200.PACHGORDNO
SEQUENCE1 numeric


CURRNIDX smallint

Currency I...(more) Join Now RM20102.CURRNIDX
join ... more text available
PAProjectType smallint

1= TIME AN...(more) Join Now PA01101.PAProjectType
PAProject_Type_Text char


PABillSubDetailType smallint


PAFeeID char

PA Fee ID ...(more) Join Now PA05200.PAFeeID
PAFeeAmount numeric

PA Fee Amo...(more) Join Now PA05200.PAFeeAmount
PAFeebillamount numeric


PAFeetaxamount numeric


PAOrigBillingAmtFee numeric


PAOrigFeeAmount numeric


PAOrigTaxAmtFee numeric


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