Database: Pcarpts (Reports Database)
Path: C:\DATA\VFE6\DEVELOPMENT\PCASYSTEM\METADATA\PCARPTS.DBC
Version: 10

Pcrblg
Pcrcnt
Pcrcty
Pcrdiv
Pcrlot
Pcrlotbyprjandphase
Pcrlsc
Pcrlst
Pcrltd
Pcrlup
Pcrmlg
Pcrmlp
Pcropt
Pcrpfp
Pcrprg
Pcrprgbypalmid
Pcrprj
Pcrpuli
Pcrpur
Pcrsco
Pcrsop
Pcrstt
Pcrsub

Local View: Pcrblg (Buyer Contact Log)

    Update Type: Key Field

  SQL:
    SELECT *;
          FROM Pcadata!pcablg

Fields

Field Name

Type

Dialog Caption

Searchable

Filterable

ddate

D

Log Date

.T.

.T.

ctype

C(10)

Log Type

.T.

.T.

cregarding

C(50)

Regarding

.T.

.T.

mnote

M

Note

.F.

.F.

maction

M

Action

.F.

.F.

dtickle

D

Tickle Date

.T.

.T.

dcompleted

D

Completed

.T.

.T.



Local View: Pcrcnt (Countries)

    Update Type: Key Field

  SQL:
    SELECT *;
          FROM Pcadata!pcacnt

Fields

Field Name

Type

Dialog Caption

Searchable

Filterable

ccountry

C(100)

Country

.T.

.T.



Local View: Pcrcty (Cities)

    Update Type: Key Field

  SQL:
    SELECT *;
          FROM Pcadata!pcacty;
          ORDER BY Pcacty.ccity

Fields

Field Name

Type

Dialog Caption

Searchable

Filterable

ccity

C(50)

City

.T.

.T.



Local View: Pcrdiv (Divisions)

    Update Type: Key Field

  SQL:
    SELECT *;
          FROM Pcadata!pcadiv;
          ORDER BY Pcadiv.cdivid

Fields

Field Name

Type

Dialog Caption

Searchable

Filterable

cdivid

C(10)

Div ID

.T.

.T.

cdivname

C(50)

Division Name

.T.

.T.



Local View: Pcrlot (Lots)

    Update Type: Key Field

  SQL:
    SELECT Pcalot.*, Padr(alltrim(alltrim(cstreetnum)+" "+;
                Alltrim(cstreetnam)),60) As Cstreet,;
                Padl(allt(str(sum(nvl(pcalsc.ndayslost,0)))),5) As Ndayslost,;
                Padl(allt(str(sum(iif(nvl(pcalsc.ltaskcomp,.f.)=.t.,1,0)))),5);
                As Ntaskcomp, Padl(allt(str(sum(iif(nvl(pcalsc.clscpk,"!!!!");
                ="!!!!",1,1)))),5) As Ntaskcount,;
                Nvl(max(val(iif(pcalsc.ltaskcomp = .t.,pcalsc.ctasknum,''))),0000);
                As Nmaxtsknum, Maxlst.cstageid As Ccurstagid,;
                Maxlst.mdescr As Mcurstag, Maxlst.ctasknum As Ccurstagtk,;
                Maxlst.dcurr As Dcurstag, Maxlst.clstpk As Cmaxlstpk;
          FROM Pcadata!pcalot;
                LEFT OUTER JOIN Pcadata!pcalsc Pcalsc;
                      ON Pcalot.clotpk = Pcalsc.clsclotfk;
                LEFT OUTER JOIN Pcaview!pcvlstmaxtodayforlot Maxlst;
                      ON Pcalot.clotpk = Maxlst.clstlotfk;
          GROUP BY Clotpk

Fields

Field Name

Type

Dialog Caption

Searchable

Filterable

cphase

C(5)

Phase

.T.

.T.

clot

C(15)

Lot

.T.

.T.

cblk

C(10)

Block

.T.

.T.

ccontseq

C(10)

Sequence

.T.

.T.

cacctjobid

C(25)

Accounting Job ID

.T.

.T.

cpermit

C(15)

Permit

.T.

.T.

cplan

C(15)

Plan

.T.

.T.

celev

C(10)

Elev

.T.

.T.

cstreetnum

C(10)

Street #

.T.

.T.

cstreetnam

C(50)

Street Name

.T.

.T.

dcstart

D

Const. Start

.T.

.T.

dcfinal

D

Const. Final

.T.

.T.

dorigcomp

D

Original Completion

.T.

.T.

dcurrcomp

D

Expected Completion

.T.

.T.

dbldrwalk

D

Builder Walk

.T.

.T.

dhowalk

D

HO Walk

.T.

.T.

dhowalkso

D

HO Walk Signoff

.T.

.T.

dclose

D

Close of Escrow

.T.

.T.

dwarrexp

D

Warranty Expiration

.T.

.T.

dfloorrel

D

Floor Release

.T.

.T.

cschfile

C(30)

Schedule File Name

.T.

.T.

cgarage

C(5)

Garage

.T.

.T.

mnote

M

Note

.F.

.F.

cbtproject

C(6)

Btproject

.T.

.T.

cbtphase

C(4)

Btphase

.T.

.T.

cstreet

C(60)

Street Address

.T.

.T.

ndayslost

C(5)

Dayslost

.T.

.T.

ntaskcomp

C(5)

Taskcomp

.T.

.T.

ntaskcount

C(5)

Taskcount

.T.

.T.

nmaxtsknum

N(13,2)

Maxtsknum

.T.

.T.

ccurstagid

C(10)

Curstagid

.T.

.T.

mcurstag

M

Curstag

.F.

.F.

ccurstagtk

C(4)

Curstagtk

.T.

.T.

dcurstag

D

Curstag

.T.

.T.

cmaxlstpk

C(16)

Maxlstpk

.T.

.T.


Local View: Pcrlsc (Lot Schedules)
    Update Type: Key Field

  SQL:
    SELECT Pcalsc.*, Iif(pcalsc.ltaskcomp, Pcalsc.dcurrend,;
                {}) As Dtaskcomp, Val(pcalsc.ctasknum) As Ntasknum,;
                Nvl(trades.clup_id, Space(10)) As Ctrdid, Nvl(trades.cname,;
                Space(50)) As Ctrdname, Nvl(schcode.clup_id,;
                Space(10)) As Clostcode, Nvl(schcode.cname,;
                Space(50)) As Clostname, Pcasub.*, Subcty.ccity As Csubcity,;
                Substt.cabbrev As Csubst, Substt.cstate As Csubstate;
          FROM Pcadata!pcalsc;
                LEFT OUTER JOIN Pcadata!pcalup Trades;
                      ON Pcalsc.clsctrdfk = Trades.cluppk;
                LEFT OUTER JOIN Pcadata!pcalup Schcode;
                      ON Pcalsc.clostreasn = Schcode.cluppk;
                LEFT OUTER JOIN Pcadata!pcasub;
                      ON Pcalsc.clscsubfk = Pcasub.csubpk;
                LEFT OUTER JOIN Pcadata!pcastt Substt;
                      ON Pcasub.csubsttfk = Substt.csttpk Left Outer Join      Pcadata!pcacty;
                            Subcty;
                      ON Pcasub.csubctyfk = Subcty.cctypk;
          GROUP BY Clscpk

Fields

Field Name

Type

Dialog Caption

Searchable

Filterable

ctasknum

C(4)

Task #

.T.

.F.

ctaskdescr

C(250)

Task Description

.T.

.T.

ltaskcomp

L

Task Completed?

.T.

.T.

nduration

N(3)

Duration

.T.

.T.

ccontpmt

C(2)

Contract Pay Stage

.T.

.T.

ndaynum

N(4)

Day #

.T.

.T.

dorigend

D

Original End Date

.T.

.T.

dcurrstart

D

Task Start Date

.T.

.T.

dcurrend

D

Task End Date

.T.

.T.

ndayslost

N(4)

Days Lost

.T.

.T.

clostreasn

C(16)

Reason Code

.T.

.T.

mlostexp

M

Days Lost Explanation

.F.

.F.

lsuperappr

L

Super Approved

.T.

.T.

lsubappr

L

Sub Approved

.T.

.T.

lisformula

L

Re-Calc?

.T.

.T.

dpalmupdat

D

Palm Update

.T.

.T.

nlead

N(3)

Lead

.T.

.T.

dlead

D

Lead

.T.

.T.

dleadsent

D

Leadsent

.T.

.T.

dleadorig

D

Leadorig

.T.

.T.

dleadcurr

D

Leadcurr

.T.

.T.

tlupdated

T

Lupdated

.T.

.T.

clupdated

C(30)

Lupdated

.T.

.T.

dtaskcomp

D

Task Complete Date

.T.

.T.

ntasknum

N(7,2)

Task Number

.T.

.T.

ctrdid

C(10)

Trade ID

.T.

.T.

ctrdname

C(50)

Trade Name

.T.

.T.

clostcode

C(10)

Lostcode

.T.

.T.

clostname

C(50)

Lostname

.T.

.T.

csubid

C(15)

Sub ID

.T.

.T.

cpcasubid

C(15)

Pcasubid

.T.

.T.

csubtype

C(5)

Subtype

.T.

.T.

ccompany

C(50)

Subcontractor

.T.

.T.

cstreet1

C(75)

Sub Street

.T.

.T.

cstreet2

C(75)

Sub Street2

.T.

.T.

csubzip

C(15)

Sub Zip

.T.

.T.

csubphone

C(20)

Sub Phone

.T.

.T.

csubfax

C(20)

Sub Fax

.T.

.T.

csubemail

C(50)

Sub Email

.T.

.T.

cwebsite

C(75)

Sub Website

.T.

.T.

cmaincont

C(75)

Sub Contact

.T.

.T.

carcontact

C(75)

Sub AR Contact

.T.

.T.

capcontact

C(75)

Sub AP Contact

.T.

.T.

mnotes

M

Notes

.F.

.F.

dinactive

D

Inactive

.T.

.T.

csubcity

C(50)

Sub City

.T.

.T.

csubst

C(2)

Sub St

.T.

.T.

csubstate

C(75)

Sub State

.T.

.T.



Local View: Pcrlst (Lot Stages)

    Update Type: Key Field

  SQL:
    SELECT *;
          FROM Pcadata!pcalst

Fields

Field Name

Type

Dialog Caption

Searchable

Filterable

cstageid

C(10)

Cutoff Stage

.T.

.T.

ctasknum

C(4)

Task #

.T.

.T.

mdescr

M

Description

.F.

.F.

dorig

D

Original

.T.

.T.

dcurr

D

Current

.T.

.T.



Local View: Pcrltd (Lot Trades)

    Update Type: Key Field

  SQL:
    SELECT Pcaltd.*, Pcalup.clup_id As Ctrdid,;
                Pcalup.cname As Ctrdname, Pcasub.*, Pcacty.ccity As Csubcity,;
                Pcastt.cabbrev As Csubst, Pcastt.cstate As Csubstate,;
                Pcacnt.ccountry As Csubcntry;
          FROM Pcadata!pcaltd;
                LEFT OUTER JOIN Pcadata!pcalup;
                      ON Pcaltd.cltdtrdfk = Pcalup.cluppk;
                LEFT OUTER JOIN Pcadata!pcasub;
                      ON Pcaltd.cltdsubfk = Pcasub.csubpk;
                LEFT OUTER JOIN Pcadata!pcastt;
                      ON Pcasub.csubsttfk = Pcastt.csttpk;
                LEFT OUTER JOIN Pcadata!pcacty;
                      ON Pcasub.csubctyfk = Pcacty.cctypk;
                LEFT OUTER JOIN Pcadata!pcacnt;
                      ON Pcasub.csubcntfk = Pcacnt.ccntpk;
          GROUP BY Cltdpk

Fields

Field Name

Type

Dialog Caption

Searchable

Filterable

ctrdid

C(10)

Trade ID

.T.

.T.

ctrdname

C(50)

Trade Name

.T.

.T.

csubid

C(15)

Sub ID

.T.

.T.

cpcasubid

C(15)

PCA Web ID

.T.

.T.

ccompany

C(50)

Company

.T.

.T.

cstreet1

C(75)

Street1

.T.

.T.

cstreet2

C(75)

Street2

.T.

.T.

csubzip

C(15)

Zip

.T.

.T.

csubphone

C(20)

Main Phone

.T.

.T.

csubfax

C(20)

Main Fax

.T.

.T.

csubemail

C(50)

Main Email

.T.

.T.

cwebsite

C(75)

Website

.T.

.T.

cmaincont

C(75)

Main Contact

.T.

.T.

carcontact

C(75)

AR Contact

.T.

.T.

capcontact

C(75)

AP Contact

.T.

.T.

mnotes

M

Notes

.F.

.F.

dinactive

D

Inactive

.T.

.T.

csubcity

C(50)

City

.T.

.T.

csubst

C(2)

ST

.T.

.T.

csubstate

C(75)

State

.T.

.T.

csubcntry

C(100)

Country

.T.

.T.

Local View: Pcropt (Options)

    Update Type: Key Field

  SQL:
    SELECT *;
          FROM Pcadata!pcaopt

Fields

Field Name

Type

Dialog Caption

Searchable

Filterable

nqty

N(5,2)

Qty

.T.

.T.

coptcat

C(250)

Option Category

.T.

.T.

coptname

C(250)

Option Name

.T.

.T.

moptlname

M

Option Long Description

.F.

.F.

linstalled

L

Installed (Y/N)

.T.

.T.

dinstalled

D

Installed Date

.T.

.T.

moptnote

M

Option Note

.F.

.F.

dpalmupdat

D

Palmupdat

.T.

.T.

doptcx

D

Option Cancelled

.T.

.T.

lpreplot

L

Pre-plotted Option

.T.

.T.

nexpsprice

N(12,2)

Expected Sales Price

.T.

.T.

lmanual

L

Manual

.T.

.T.

nexpdeppct

N(5,2)

Expected Deposit %

.T.

.T.

nactsprice

N(12,2)

Actual Sales Price

.T.

.T.

nactdeppct

N(5,2)

Actual Deposit %

.T.

.T.

loptconfrm

L

Option Confirmed

.T.

.T.

coptdnso

C(10)

Option DNSO Code

.T.

.T.

coptidgrid

C(20)

Option Grid ID

.T.

.T.

coptcutoff

C(20)

Option Cutoff

.T.

.T.

coptplan

C(50)

Option Plan Restriction

.T.

.T.

coptccode

C(25)

Option Cost Code

.T.

.T.



Local View: Pcrpfp (Palm Filters)

    Update Type: Read-Only

  SQL:
    SELECT Pcapfp.*, Pcaprg.cpcareg, Pcaprg.dpcaexp, Pcaprg.cwarrreg,;
                Pcaprg.dwarrexp, Pcaprg.chdserial;
          FROM Pcadata!pcapfp;
                LEFT OUTER JOIN Pcadata!pcaprg;
                      ON Pcapfp.cpalmuser = Pcaprg.cpalmuser;
          GROUP BY Pcapfp.cpfppk

Fields

Field Name

Type

Dialog Caption

Searchable

Filterable

cpalmuser

C(125)

Palm User Name

.T.

.T.

cpalmid

C(20)

Palm ID

.T.

.T.

dlastsync

D

Last Sync Date

.T.

.T.

lporepauth

L

PO Authorization

.T.

.T.

nlotaftcoe

N(6)

Keep Lots # Days after Closing

.T.

.T.

llotro

L

Lotro

.T.

.T.

nsacomptsk

N(6)

SA-Days to keep Completed Task

.T.

.T.

nsaresnday

N(6)

SA-Days to Ask for Reason Lost

.T.

.T.

nsafutrtsk

N(6)

Safutrtsk

.T.

.T.

lsaro

L

Saro

.T.

.T.

npoaftapvd

N(6)

PO-Keep Days after approval

.T.

.T.

npoaftclos

N(6)

PO-Keep Days after Lot Close

.T.

.T.

npoautoapp

N(12,2)

Poautoapp

.T.

.T.

noaaftinst

N(6)

OA-Keep Days After Installed

.T.

.T.

noaaftordr

N(6)

OA-Keep Days After Ordered

.T.

.T.

noaaftcan

N(6)

Oaaftcan

.T.

.T.

loaro

L

Oaro

.T.

.T.

nwaaftwexp

N(6)

WA-Keep Days after Warr Exp

.T.

.T.

nwaaftclos

N(6)

WA-Keep Days After Close

.T.

.T.

nwacaftcom

N(6)

WA-Keep Days after Claim Comp

.T.

.T.

nwacafthos

N(6)

WA-Keep Days after Claim Sign

.T.

.T.

nwaiaftcom

N(6)

WA-Keep Days after Item Comp

.T.

.T.

nwaiafthos

N(6)

WA-Keep Days after Item Sign

.T.

.T.

nwadaftcom

N(6)

WA-Keep Days after Detail Comp

.T.

.T.

nwadafthos

N(6)

WA-Keep Days after Detail Sign

.T.

.T.

cpcareg

C(20)

PCA Palm Registration

.T.

.T.

dpcaexp

D

PCA Palm Expiration

.T.

.T.

cwarrreg

C(20)

WarrPalm Registration

.T.

.T.

dwarrexp

D

WarrPalm Expiration

.T.

.T.

chdserial

C(20)

PCA Check Value

.T.

.T.



Local View: Pcrprg (Palm Registrations)

    Update Type: Key Field

  SQL:
    SELECT *;
          FROM Pcadata!pcaprg

Fields

Field Name

Type

Dialog Caption

Searchable

Filterable

cpalmuser

C(125)

Palm User Name

.T.

.T.

cpalmid

C(20)

Palm ID

.T.

.T.

cpcareg

C(20)

PCA Palm Registration

.T.

.T.

dpcaexp

D

PCA Palm Expiration

.T.

.T.

cwarrreg

C(20)

WarrPalm Registration

.T.

.T.

dwarrexp

D

WarrPalm Expiration

.T.

.T.

chdserial

C(20)

PCA Check Value

.T.

.T.


Local View: Pcrprj (Projects)
    Update Type: Key Field

  SQL:
    SELECT Pcadiv.cdivid, Pcadiv.cdivname, Pcaprj.*,;
                Prjcty.ccity As Cprjcity, Prjstt.cabbrev As Cprjst,;
                Prjstt.cstate As Cprjstate, Pcasub.*, Subcty.ccity As Csubcity,;
                Substt.cabbrev As Csubst, Substt.cstate As Csubstate;
          FROM Pcadata!pcaprj;
                LEFT OUTER JOIN Pcadata!pcadiv;
                      ON Pcaprj.cdivfk = Pcadiv.cdivpk;
                LEFT OUTER JOIN Pcadata!pcacty Prjcty;
                      ON Pcaprj.cctyfk = Prjcty.cctypk;
                LEFT OUTER JOIN Pcadata!pcastt Prjstt;
                      ON Pcaprj.csttfk = Prjstt.csttpk;
                LEFT OUTER JOIN Pcadata!pcasub;
                      ON Pcaprj.cbldrfk = Pcasub.csubpk;
                LEFT OUTER JOIN Pcadata!pcastt Substt;
                      ON Pcasub.csubsttfk = Substt.csttpk;
                LEFT OUTER JOIN Pcadata!pcacty Subcty;
                      ON Pcasub.csubctyfk = Subcty.cctypk;
          GROUP BY Cprjpk

Fields

Field Name

Type

Dialog Caption

Searchable

Filterable

cdivid

C(10)

Div ID

.T.

.T.

cdivname

C(50)

Division Name

.T.

.T.

cprjid

C(10)

Project ID

.T.

.T.

cprjname

C(50)

Project Name

.T.

.T.

cprjzip

C(15)

Zip

.T.

.T.

cprjwebsit

C(50)

Project Web Site

.T.

.T.

cprjtract

C(15)

Tract #

.T.

.T.

cprjsalph

C(20)

Sales Phone

.T.

.T.

cprjsalfax

C(20)

Sales Fax

.T.

.T.

cprjsaleml

C(50)

Sales Email

.T.

.T.

cprjsuper

C(50)

Superintendent

.T.

.T.

cprjsupph

C(20)

Super Phone

.T.

.T.

cprjsupfax

C(20)

Super Fax

.T.

.T.

cprjsupeml

C(50)

Super Email

.T.

.T.

cprjfile5

C(5)

Prjfile5

.T.

.T.

cprjfile6

C(6)

Prjfile6

.T.

.T.

csamaster

C(8)

Schedule Advisor Master

.T.

.T.

nwarrdays

N(10)

Warranty Days

.T.

.T.

cbtentp

C(2)

Btentp

.T.

.T.

cbtenty

C(4)

Btenty

.T.

.T.

cbtdept

C(4)

Btdept

.T.

.T.

cbtglacct

C(6)

Btglacct

.T.

.T.

cbtcostcat

C(1)

Btcostcat

.T.

.T.

cbtcostlst

C(4)

Btcostlst

.T.

.T.

cbtpayentp

C(2)

Btpayentp

.T.

.T.

cbtpayenty

C(4)

Btpayenty

.T.

.T.

cprjcity

C(50)

City

.T.

.T.

cprjst

C(2)

St

.T.

.T.

cprjstate

C(75)

State

.T.

.T.

csubid

C(15)

Builder ID

.T.

.T.

cpcasubid

C(15)

Builder Web ID

.T.

.T.

ccompany

C(50)

Builder

.T.

.T.

cstreet1

C(75)

Street1

.T.

.T.

cstreet2

C(75)

Street2

.T.

.T.

csubzip

C(15)

Builder Zip

.T.

.T.

csubphone

C(20)

Builder Phone

.T.

.T.

csubfax

C(20)

Builder Fax

.T.

.T.

csubemail

C(50)

Builder Email

.T.

.T.

cwebsite

C(75)

Builder WebSite

.T.

.T.

cmaincont

C(75)

Builder Main Contact

.T.

.T.

carcontact

C(75)

Builder AR Contact

.T.

.T.

capcontact

C(75)

Builder AP Contact

.T.

.T.

mnotes

M

Notes

.F.

.F.

dinactive

D

Inactive

.T.

.T.

csubcity

C(50)

Builder CIty

.T.

.T.

csubst

C(2)

Builder ST

.T.

.T.

csubstate

C(75)

Builder State

.T.

.T.



Local View: Pcrpuli (Purchase Order Line Items)

    Update Type: Read-Only

  SQL:
    SELECT *;
          FROM Pcadata!pcapuli

Fields

Field Name

Type

Dialog Caption

Searchable

Filterable

cponum

C(25)

PO #

.T.

.T.

citmnum

C(25)

Item Number

.T.

.T.

cporeqid

C(15)

Poreqid

.T.

.T.

cvarcode

C(10)

Variance

.T.

.T.

mvarexpl

M

Variance Explanation

.F.

.F.

namount

N(10,2)

Amount

.T.

.T.

capprvdby

C(20)

Approved By

.T.

.T.

dapprvd

D

Approved Date

.T.

.T.

mpulidescr

M

Item Description

.F.

.F.

mpulicomm

M

Item Comments

.F.

.F.

nqty

N(5,2)

Qty

.T.

.T.

dcandate

D

Cancel Date

.T.

.T.

mcanreasn

M

Cancel Reason

.F.

.F.

dacctpost

D

Accounting Post Date

.T.

.T.

dacctpaid

D

Date Paid

.T.

.T.

cinvnum

C(25)

Vendor Invoice #

.T.

.T.

dinvdate

D

Vendor Invoice Date

.T.

.T.



Local View: Pcrpur (Purchase Orders)

    Update Type: Key Field

  SQL:
    SELECT Pcapur.*, Pcasub.*, Subcty.ccity As Csubcity,;
                Substt.cabbrev As Csubst, Substt.cstate As Csubstate;
          FROM Pcadata!pcapur;
                LEFT OUTER JOIN Pcadata!pcasub;
                      ON Pcapur.cpursubfk = Pcasub.csubpk;
                LEFT OUTER JOIN Pcadata!pcastt Substt;
                      ON Pcasub.csubsttfk = Substt.csttpk;
                LEFT OUTER JOIN Pcadata!pcacty Subcty;
                      ON Pcasub.csubctyfk = Subcty.cctypk;
          GROUP BY Cpurpk

Fields

Field Name

Type

Dialog Caption

Searchable

Filterable

cponum

C(25)

PO #

.T.

.T.

dpodate

D

PO Date

.T.

.T.

mpodescr

M

PO Description

.F.

.F.

crequis

C(25)

Requisitioner

.T.

.T.

csubid

C(15)

Sub ID

.T.

.T.

cpcasubid

C(15)

Sub PCA Web ID

.T.

.T.

ccompany

C(50)

Company

.T.

.T.

cstreet1

C(75)

Street1

.T.

.T.

cstreet2

C(75)

Street2

.T.

.T.

csubzip

C(15)

Zip

.T.

.T.

csubphone

C(20)

Phone

.T.

.T.

csubfax

C(20)

Fax

.T.

.T.

csubemail

C(50)

Email

.T.

.T.

cwebsite

C(75)

Web-Site

.T.

.T.

cmaincont

C(75)

Main Contact

.T.

.T.

carcontact

C(75)

AR Contact

.T.

.T.

capcontact

C(75)

AP Contact

.T.

.T.

mnotes

M

Sub Notes

.F.

.F.

dinactive

D

Inactive

.T.

.T.

csubcity

C(50)

City

.T.

.T.

csubst

C(2)

St

.T.

.T.

csubstate

C(75)

State

.T.

.T.



Local View: Pcrsco (Subcontractor Correspondence)

    Update Type: Key and Modified

  SQL:
    SELECT Pcasco.*, Pcasub.csubid, Pcasub.ccompany As Csubname,;
                Pcasub.cstreet1 As Csubaddr, Pcasub.cstreet2 As Csubaddr2,;
                Pcasub.csubzip, Pcasub.csubphone, Pcasub.csubfax,;
                Pcasub.csubemail, Pcasub.cwebsite As Csubweb,;
                Pcasub.cmaincont As Csubmncont, Pcasub.carcontact As Csubarcont,;
                Pcasub.capcontact As Csubapcont, Pcasub.mnotes As Msubnotes,;
                Pcacts.cprefix As Cempprefix, Pcacts.cfname As Cempfname,;
                Pcacts.clname As Cemplname, Pcacts.csuffix As Cempsuffix,;
                Pcacts.cinitials As Cempinit, Pcacts.cphone As Cempphone,;
                Pcacts.cfax As Cempfax, Pcacts.cemail As Cempemail,;
                Pcacts.ctitle As Cemptitle, Pcalup.clup_id As Cfilename,;
                Pcalup.cname As Ccorrdescr, Pcacty.ccity As Csubcity,;
                Pcastt.cabbrev As Csubstabbv, Pcastt.cstate As Csubstate;
          FROM Pcadata!pcasco;
                INNER JOIN Pcadata!pcalup;
                      ON Pcasco.cscosctfk = Pcalup.cluppk;
                INNER JOIN Pcadata!pcasub;
                      ON Pcasco.cscosubfk = Pcasub.csubpk;
                INNER JOIN Pcadata!pcacts;
                      ON Pcasco.cscoctsfk = Pcacts.cctspk;
                LEFT OUTER JOIN Pcadata!pcacty;
                      ON Pcasub.csubctyfk = Pcacty.cctypk;
                LEFT OUTER JOIN Pcadata!pcastt;
                      ON Pcasub.csubsttfk = Pcastt.csttpk

Fields

Field Name

Type

Dialog Caption

Searchable

Filterable

mbody

M

Body

.F.

.F.

cregarding

C(50)

Regarding

.T.

.T.

dcreated

D

Created

.T.

.T.

cprefdist

C(1)

Prefdist

.T.

.T.

dsent

D

Sent

.T.

.T.

csent

C(1)

Sent

.T.

.T.

csubid

C(15)

Subid

.T.

.T.

csubname

C(50)

Subname

.T.

.T.

csubaddr

C(75)

Subaddr

.T.

.T.

csubaddr2

C(75)

Subaddr2

.T.

.T.

csubzip

C(15)

Subzip

.T.

.T.

csubphone

C(20)

Subphone

.T.

.T.

csubfax

C(20)

Subfax

.T.

.T.

csubemail

C(50)

Subemail

.T.

.T.

csubweb

C(75)

Subweb

.T.

.T.

csubmncont

C(75)

Submncont

.T.

.T.

csubarcont

C(75)

Subarcont

.T.

.T.

csubapcont

C(75)

Subapcont

.T.

.T.

msubnotes

M

Subnotes

.F.

.F.

cempprefix

C(15)

Empprefix

.T.

.T.

cempfname

C(40)

Empfname

.T.

.T.

cemplname

C(40)

Emplname

.T.

.T.

cempsuffix

C(10)

Empsuffix

.T.

.T.

cempinit

C(4)

Empinit

.T.

.T.

cempphone

C(25)

Empphone

.T.

.T.

cempfax

C(25)

Empfax

.T.

.T.

cempemail

C(50)

Empemail

.T.

.T.

cemptitle

C(50)

Emptitle

.T.

.T.

cfilename

C(10)

Filename

.T.

.T.

ccorrdescr

C(50)

Corrdescr

.T.

.T.

csubcity

C(50)

Subcity

.T.

.T.

csubstabbv

C(2)

Substabbv

.T.

.T.

csubstate

C(75)

Substate

.T.

.T.



Local View: Pcrsop (Option Purchase Orders)

    Update Type: Read-Only

  SQL:
    SELECT Pcasop.*, Pcasub.*, Subcty.ccity As Csubcity,;
                Substt.cabbrev As Csubst, Substt.cstate As Csubstate;
          FROM Pcadata!pcasop;
                LEFT OUTER JOIN Pcadata!pcasub;
                      ON Pcasop.csopsubfk = Pcasub.csubpk;
                LEFT OUTER JOIN Pcadata!pcastt Substt;
                      ON Pcasub.csubsttfk = Substt.csttpk;
                LEFT OUTER JOIN Pcadata!pcacty Subcty;
                      ON Pcasub.csubctyfk = Subcty.cctypk;
          GROUP BY Csoppk

Fields

Field Name

Type

Dialog Caption

Searchable

Filterable

cref

C(15)

Ref

.T.

.T.

dorddate

D

Orddate

.T.

.T.

dcandate

D

Candate

.T.

.T.

dsopapprvd

D

Sopapprvd

.T.

.T.

csopapprvd

C(30)

Sopapprvd

.T.

.T.

dpalmupdat

D

Palmupdat

.T.

.T.

mvnote

M

Vnote

.F.

.F.

crequist

C(25)

Requist

.T.

.T.

nsubcost

N(12,2)

Subcost

.T.

.T.

dacctpost

D

Acctpost

.T.

.T.

dacctpaid

D

Acctpaid

.T.

.T.

dcxacctpst

D

Cxacctpst

.T.

.T.

lmanual

L

Manual

.T.

.T.

csubinvref

C(25)

Subinvref

.T.

.T.

cacctccode

C(25)

Acctccode

.T.

.T.

cacctglcod

C(25)

Acctglcod

.T.

.T.

dsubinv

D

Subinv

.T.

.T.

dsubinvrec

D

Subinvrec

.T.

.T.

dsubinvpay

D

Subinvpay

.T.

.T.

cinvapprvd

C(30)

Invapprvd

.T.

.T.

dinvapprvd

D

Invapprvd

.T.

.T.

lsopconfrm

L

Sopconfrm

.T.

.T.

mvscope

M

Vscope

.F.

.F.

cvxcode

C(20)

Vxcode

.T.

.T.

csubid

C(15)

Subid

.T.

.T.

ccompany

C(50)

Company

.T.

.T.

cstreet1

C(75)

Street1

.T.

.T.

cstreet2

C(75)

Street2

.T.

.T.

csubzip

C(15)

Subzip

.T.

.T.

csubphone

C(20)

Subphone

.T.

.T.

csubfax

C(20)

Subfax

.T.

.T.

csubemail

C(50)

Subemail

.T.

.T.

cwebsite

C(75)

Website

.T.

.T.

cmaincont

C(75)

Maincont

.T.

.T.

carcontact

C(75)

Arcontact

.T.

.T.

capcontact

C(75)

Apcontact

.T.

.T.

mnotes

M

Notes

.F.

.F.

dinactive

D

Inactive

.T.

.T.

csubcity

C(50)

Subcity

.T.

.T.

csubst

C(2)

Subst

.T.

.T.

csubstate

C(75)

Substate

.T.

.T.



Local View: Pcrstt (States)

    Update Type: Key Field

  SQL:
    SELECT *;
          FROM Pcadata!pcastt

Fields

Field Name

Type

Dialog Caption

Searchable

Filterable

cabbrev

C(2)

State Abbreviation

.T.

.T.

cstate

C(75)

State Name

.T.

.T.



Local View: Pcrsub (Subcontractors)

    Update Type: Key Field

  SQL:
    SELECT Pcasub.*, Subcty.ccity As Csubcity,;
                Substt.cabbrev As Csubst, Substt.cstate As Csubstate;
          FROM Pcadata!pcasub;
                LEFT OUTER JOIN Pcadata!pcastt Substt;
                      ON Pcasub.csubsttfk = Substt.csttpk;
                LEFT OUTER JOIN Pcadata!pcacty Subcty;
                      ON Pcasub.csubctyfk = Subcty.cctypk;
                LEFT OUTER JOIN Pcadata!pcacnt Subcnt;
                      ON Pcasub.csubcntfk = Subcnt.ccntpk;
          GROUP BY Csubpk

Fields

Field Name

Type

Dialog Caption

Searchable

Filterable

csubid

C(15)

Sub ID

.T.

.T.

cpcasubid

C(15)

PCA Web ID

.T.

.T.

ccompany

C(50)

Company

.T.

.T.

cstreet1

C(75)

Street1

.T.

.T.

cstreet2

C(75)

Street2

.T.

.T.

csubzip

C(15)

Zip

.T.

.T.

csubphone

C(20)

Phone

.T.

.T.

csubfax

C(20)

Fax

.T.

.T.

csubemail

C(50)

Email

.T.

.T.

cwebsite

C(75)

Web-Site

.T.

.T.

cmaincont

C(75)

Main Contact

.T.

.T.

carcontact

C(75)

AR Contact

.T.

.T.

capcontact

C(75)

AP Contact

.T.

.T.

mnotes

M

Sub Notes

.F.

.F.

dinactive

D

Inactive

.T.

.T.

csubcity

C(50)

City

.T.

.T.

csubst

C(2)

ST

.T.

.T.

csubstate

C(75)

State

.T.

.T.