ID | Name | Description | |
---|---|---|---|
AP0001 | APP01 | Company Options | View |
AP0002 | APP02 | Invoicing Options | View |
AP0003 | APP03 | Payment and Aging Options | View |
AP0004 | APP04 | Integration Options | View |
AP0005 | APRDC | Distribution Codes | View |
AP0006 | APRAS | Account Sets | View |
AP0007 | APCLX | 1099 / CPRS Codes | View |
AP0008 | APDSD | Distribution Set Details | View |
AP0009 | APDSH | Distribution Sets | View |
AP0010 | APPTP | Payment Codes | View |
AP0011 | APRTB | Terms Payment Schedule | View |
AP0012 | APRTA | Terms | View |
AP0013 | APCCS | 1099 / CPRS Amounts | View |
AP0014 | APVCM | Vendor Comments | View |
AP0015 | APVEN | Vendors | View |
AP0016 | APVGR | Vendor Groups | View |
AP0017 | APVGS | Vendor Group Statistics | View |
AP0018 | APVNR | Remit-To Locations | View |
AP0019 | APVSM | Vendor Statistics | View |
AP0020 | APIBC | Invoice Batches | View |
AP0021 | APIBH | Invoices | View |
AP0022 | APIBD | Invoice Details | View |
AP0023 | APIBS | Invoice Payment Schedules | View |
AP0024 | APIBT | Invoice Detail Comments | View |
AP0025 | APOBL | Documents | View |
AP0026 | APOBS | Document Sched. Payments | View |
AP0027 | APOBP | Document Payments | View |
AP0029 | APPYM | Posted Payments | View |
AP0030 | APBTA | Payment and Adjustment Batches | View |
AP0031 | APTCR | Payments/Adjustments | View |
AP0032 | APTCN | Miscellaneous Payments | View |
AP0033 | APTCP | Applied Payments | View |
AP0034 | APTCU | Adjustment G/L Distributions | View |
AP0035 | APSLH | Selection Criteria Header | View |
AP0036 | APSLD | Selection Criteria Details | View |
AP0037 | APTRK | Payment G/L Distributions | View |
AP0038 | APPTER | Posting Error Messages | View |
AP0039 | APIVPT | Post Invoices | View |
AP0040 | APPYPT | Post Payments and Adjustments | View |
AP0041 | APUNGL | Revaluation | View |
AP0042 | APGLTR | Create G/L Batch | View |
AP0043 | APAGE | Age Documents | View |
AP0044 | APYREN | Process Year End | View |
AP0045 | APINTCK | Integrity Checker | View |
AP0047 | APSTAT | Update Statistics | View |
AP0048 | APPOOP | Create Open Document List | View |
AP0049 | APPREN | Clear Fully Paid Documents | View |
AP0050 | APPGCM | Clear Vendor Comments | View |
AP0051 | APPGST | Clear Statistics | View |
AP0052 | APPGIA | Delete Inactive Records | View |
using (HuAPConnection Connection = new HuAPConnection())
using (HuView PORCPL = Connection.GetView("PO0710"))
using (HuView PORCPH = Connection.GetView("PO0700"))
using (HuView PORCPC = Connection.GetView("PO0695"))
using (HuView PORCPV = Connection.GetView("PO0718"))
using (HuView PORCPS = Connection.GetView("PO0714"))
using (HuView PORCPG = Connection.GetView("PO0699"))
using (HuView PORCPR = Connection.GetView("PO0705"))
using (HuView PORCPD = Connection.GetView("PO0696"))
using (HuView PORCPE = Connection.GetView("PO0697"))
using (HuView PORCPI = Connection.GetView("PO0701"))
using (HuView PORCPM = Connection.GetView("PO0711"))
using (HuView POPORH = Connection.GetView("PO0620"))
using (HuView POPORC = Connection.GetView("PO0610"))
using (HuView POPORL = Connection.GetView("PO0630"))
using (HuView POPORG = Connection.GetView("PO0619"))
using (HuView POPORR = Connection.GetView("PO0632"))
using (HuView POPORI = Connection.GetView("PO0621"))
using (HuView POPORM = Connection.GetView("PO0631"))
using (HuView PORQNH = Connection.GetView("PO0760"))
using (HuView PORQNC = Connection.GetView("PO0750"))
using (HuView PORQNL = Connection.GetView("PO0770"))
using (HuView PORQNG = Connection.GetView("PO0759"))
using (HuView PORQNLV = Connection.GetView("PO0777"))
using (HuView PORQNLO = Connection.GetView("PO0773"))
using (HuView PORQNHO = Connection.GetView("PO0763"))
using (HuView POPORLO = Connection.GetView("PO0633"))
using (HuView POPORHO = Connection.GetView("PO0623"))
using (HuView PORCPT = Connection.GetView("PO0715"))
using (HuView PORCPML = Connection.GetView("PO0781"))
using (HuView PORCPMS = Connection.GetView("PO0788"))
using (HuView PORCPSO = Connection.GetView("PO0719"))
using (HuView PORCPVO = Connection.GetView("PO0721"))
using (HuView PORCPHO = Connection.GetView("PO0703"))
using (HuView PORCPLO = Connection.GetView("PO0717"))
using (HuView PORCPLL = Connection.GetView("PO0789"))
using (HuView PORCPLS = Connection.GetView("PO0780"))
{
PORCPL.Compose(PORCPH, PORCPC, PORCPG, PORCPI, PORCPM, PORCPLO, PORCPLL, PORCPLS);
PORCPH.Compose(PORCPC, PORCPL, PORCPV, PORCPS, PORCPG, PORCPR, PORCPHO, PORCPD);
PORCPC.Compose(PORCPH, PORCPL);
PORCPV.Compose(PORCPH, PORCPS, PORCPG, PORCPVO);
PORCPS.Compose(PORCPV, PORCPG, PORCPH, PORCPI, PORCPT, PORCPSO, PORCPD);
PORCPG.Compose(PORCPH, PORCPC, PORCPL, PORCPS, PORCPV, PORCPR, PORCPD);
PORCPR.Compose(PORCPH, PORCPG);
PORCPD.Compose(PORCPS, PORCPV, PORCPH, PORCPG, PORCPE);
PORCPE.Compose(PORCPI, PORCPD, PORCPS);
PORCPI.Compose(PORCPM, PORCPT, POPORG, POPORH, POPORL, PORCPG, PORCPH, PORCPL, PORCPS, PORCPV, PORCPE, PORCPML, PORCPMS);
PORCPM.Compose(PORCPI, POPORH, POPORL, PORCPH, PORCPL, PORCPG, POPORG);
POPORH.Compose(POPORC, POPORL, POPORR, POPORG, POPORHO);
POPORC.Compose(POPORH, POPORL);
POPORL.Compose(POPORH, POPORC, POPORG, POPORI, POPORM, POPORLO);
POPORG.Compose(POPORH, POPORC, POPORL, POPORR);
POPORR.Compose(POPORH, POPORG);
POPORI.Compose(POPORM, POPORG, POPORH, PORQNC, PORQNG, PORQNH, PORQNL, PORQNLV);
POPORM.Compose(POPORI, POPORG, POPORH, POPORL, PORQNH, PORQNL);
PORQNH.Compose(PORQNC, PORQNL, PORQNG, PORQNHO, PORQNLV);
PORQNC.Compose(PORQNH, PORQNL);
PORQNL.Compose(PORQNH, PORQNC, PORQNG, PORQNLO, PORQNLV);
PORQNG.Compose(PORQNH, PORQNC, PORQNL, PORQNLV);
PORQNLV.Compose(PORQNH, PORQNG, PORQNL);
PORQNLO.Compose(PORQNL);
PORQNHO.Compose(PORQNH);
POPORLO.Compose(POPORL);
POPORHO.Compose(POPORH);
PORCPT.Compose(PORCPI, PORCPH, PORCPS, PORCPV);
PORCPML.Compose(PORCPI);
PORCPMS.Compose(PORCPI);
PORCPSO.Compose(PORCPS);
PORCPVO.Compose(PORCPV);
PORCPHO.Compose(PORCPH);
PORCPLO.Compose(PORCPL);
PORCPLL.Compose(PORCPL, PORCPM, PORCPML);
PORCPLS.Compose(PORCPL, PORCPM, PORCPMS);
// Code Here
}
Field Name | Type | Size | Precision | Description | Mask | Index | Attribute |
---|---|---|---|---|---|---|---|
RCPHSEQ | Decimal | 10 | 0 | Receipt Sequence Key | 1 | RKEA | |
RCPLREV | Decimal | 10 | 0 | Line Number | 2 | RKEA | |
RCPLSEQ | Decimal | 10 | 0 | Receipt Line Sequence | 3 | EA | |
RCPCSEQ | Decimal | 10 | 0 | Receipt Comment Sequence | 4 | A | |
OEONUMBER | Char | 22 | 0 | Order Number | %-22C | 5 | A |
INDBTABLE | Bool | 2 | 0 | Stored in Database Table | 6 | CA | |
POSTEDTOIC | Bool | 2 | 0 | Posted to I/C | 7 | CA | |
COMPLETION | Int | 2 | 0 | Completion Status | 8 | A | |
DTCOMPLETE | Date | 5 | 0 | Date Completed | 9 | A | |
PORHSEQ | Decimal | 10 | 0 | Purchase Order Sequence Key | 10 | A | |
PORLSEQ | Decimal | 10 | 0 | Purchase Order Line Sequence | 11 | A | |
POCOMPLETE | Bool | 2 | 0 | Completes PO | 12 | A | |
ITEMEXISTS | Bool | 2 | 0 | Item Exists | 13 | CA | |
ITEMNO | Char | 24 | 0 | Item Number | %-24C | 14 | AP |
LOCATION | Char | 6 | 0 | Location | %-6N | 15 | A |
ITEMDESC | Char | 60 | 0 | Item Description | 16 | A | |
VENDITEMNO | Char | 24 | 0 | Vendor Item Number | 17 | A | |
HASCOMMENT | Bool | 2 | 0 | Comments | 18 | A | |
ORDERUNIT | Char | 10 | 0 | Unit of Measure | %-10c | 19 | A |
ORDERCONV | Decimal | 10 | 6 | Order Unit Conversion | 20 | CA | |
ORDERDECML | Int | 2 | 0 | Order Unit Decimals | 21 | CA | |
RCPUNIT | Char | 10 | 0 | Unit of Measure | %-10c | 22 | A |
RCPCONV | Decimal | 10 | 6 | Receiving Conversion Factor | 23 | CA | |
RCPDECML | Int | 2 | 0 | Receiving Unit Decimals | 24 | CA | |
STOCKDECML | Int | 2 | 0 | Stock Unit Decimals | 25 | CA | |
OQORDERED | Decimal | 10 | 4 | Ordered Quantity Ordered | 26 | CA | |
OQPREVRECV | Decimal | 10 | 4 | Ordered Previously Received | 27 | CA | |
OQOUTSTPO | Decimal | 10 | 4 | Ordered Outstanding on PO | 28 | CA | |
RQRECEIVED | Decimal | 10 | 4 | Quantity Received | 29 | A | |
RQCANCELED | Decimal | 10 | 4 | Quantity Canceled | 30 | A | |
RQOUTSTAND | Decimal | 10 | 4 | Quantity Outstanding | 31 | A | |
SQORDERED | Decimal | 10 | 4 | Stocking Quantity Ordered | 32 | CA | |
SQPREVRECV | Decimal | 10 | 4 | Stocking Previously Received | 33 | CA | |
SQOUTSTPO | Decimal | 10 | 4 | Stocking Outstanding on PO | 34 | CA | |
RQORDERED | Decimal | 10 | 4 | Quantity Ordered | 35 | CA | |
RQPREVRECV | Decimal | 10 | 4 | Received to Date | 36 | CA | |
RQOUTSTPO | Decimal | 10 | 4 | Quantity Outstanding | 37 | CA | |
RQRCPEXTRA | Decimal | 10 | 4 | Receiving Qty. Received Extra | 38 | CA | |
SQRECEIVED | Decimal | 10 | 4 | Stocking Quantity Received | 39 | CA | |
SQCANCELED | Decimal | 10 | 4 | Stocking Quantity Canceled | 40 | CA | |
SQOUTSTAND | Decimal | 10 | 4 | Stocking Quantity Outstanding | 41 | CA | |
SQRCPEXTRA | Decimal | 10 | 4 | Stocking Quantity Received Extra | 42 | CA | |
OQRECEIVED | Decimal | 10 | 4 | Ordered Quantity Received | 43 | CA | |
OQCANCELED | Decimal | 10 | 4 | Ordered Quantity Canceled | 44 | CA | |
OQOUTSTAND | Decimal | 10 | 4 | Ordered Quantity Outstanding | 45 | CA | |
OQRCPEXTRA | Decimal | 10 | 4 | Received Extra | 46 | CA | |
RQRETURNED | Decimal | 10 | 4 | Quantity Returned | 47 | A | |
SQRETURNED | Decimal | 10 | 4 | Stocking Quantity Returned | 48 | CA | |
OQRETURNED | Decimal | 10 | 4 | Ordered Quantity Returned | 49 | CA | |
RQSTOCKED | Decimal | 10 | 4 | Quantity Stocked | 50 | A | |
SQSTOCKED | Decimal | 10 | 4 | Stocking Quantity Stocked | 51 | CA | |
OQSTOCKED | Decimal | 10 | 4 | Ordered Quantity Stocked | 52 | CA | |
RQINADJUST | Decimal | 10 | 4 | Quantity Adjusted by Invoice | 53 | A | |
SQINADJUST | Decimal | 10 | 4 | Stocking Qty. Adj. by Invoice | 54 | CA | |
OQINADJUST | Decimal | 10 | 4 | Ordered Quantity Adj. by Invoice | 55 | CA | |
RQPOFILLED | Decimal | 10 | 4 | Quantity Filled on PO | 56 | A | |
SQPOFILLED | Decimal | 10 | 4 | Stocking Quantity Filled on PO | 57 | CA | |
OQPOFILLED | Decimal | 10 | 4 | Ordered Quantity Filled on PO | 58 | CA | |
RQSETTLED | Decimal | 10 | 4 | Quantity Settled | 59 | CA | |
SQSETTLED | Decimal | 10 | 4 | Stocking Quantity Settled | 60 | CA | |
OQSETTLED | Decimal | 10 | 4 | Ordered Quantity Settled | 61 | CA | |
RQUSTOCKED | Decimal | 10 | 4 | Quantity Unstocked | 62 | A | |
SQUSTOCKED | Decimal | 10 | 4 | Stocking Quantity Unstocked | 63 | CA | |
OQUSTOCKED | Decimal | 10 | 4 | Ordered Quantity Unstocked | 64 | CA | |
UNITWEIGHT | Decimal | 10 | 4 | Unit Weight | 65 | A | |
EXTWEIGHT | Decimal | 10 | 4 | Extended Weight | 66 | A | |
UNITCOST | Decimal | 10 | 6 | Unit Cost | 67 | A | |
EXTENDED | Decimal | 10 | 3 | Extended Cost | 68 | A | |
TAXBASE1 | Decimal | 10 | 3 | Tax Base 1 | 69 | A | |
TAXBASE2 | Decimal | 10 | 3 | Tax Base 2 | 70 | A | |
TAXBASE3 | Decimal | 10 | 3 | Tax Base 3 | 71 | A | |
TAXBASE4 | Decimal | 10 | 3 | Tax Base 4 | 72 | A | |
TAXBASE5 | Decimal | 10 | 3 | Tax Base 5 | 73 | A | |
TAXCLASS1 | Int | 2 | 0 | Tax Class 1 | 74 | A | |
TAXCLASS2 | Int | 2 | 0 | Tax Class 2 | 75 | A | |
TAXCLASS3 | Int | 2 | 0 | Tax Class 3 | 76 | A | |
TAXCLASS4 | Int | 2 | 0 | Tax Class 4 | 77 | A | |
TAXCLASS5 | Int | 2 | 0 | Tax Class 5 | 78 | A | |
TAXRATE1 | Decimal | 8 | 5 | Tax Rate 1 | 79 | A | |
TAXRATE2 | Decimal | 8 | 5 | Tax Rate 2 | 80 | A | |
TAXRATE3 | Decimal | 8 | 5 | Tax Rate 3 | 81 | A | |
TAXRATE4 | Decimal | 8 | 5 | Tax Rate 4 | 82 | A | |
TAXRATE5 | Decimal | 8 | 5 | Tax Rate 5 | 83 | A | |
TAXINCLUD1 | Bool | 2 | 0 | Tax Includable 1 | 84 | A | |
TAXINCLUD2 | Bool | 2 | 0 | Tax Includable 2 | 85 | A | |
TAXINCLUD3 | Bool | 2 | 0 | Tax Includable 3 | 86 | A | |
TAXINCLUD4 | Bool | 2 | 0 | Tax Includable 4 | 87 | A | |
TAXINCLUD5 | Bool | 2 | 0 | Tax Includable 5 | 88 | A | |
TAXAMOUNT1 | Decimal | 10 | 3 | Tax Amount 1 | 89 | A | |
TAXAMOUNT2 | Decimal | 10 | 3 | Tax Amount 2 | 90 | A | |
TAXAMOUNT3 | Decimal | 10 | 3 | Tax Amount 3 | 91 | A | |
TAXAMOUNT4 | Decimal | 10 | 3 | Tax Amount 4 | 92 | A | |
TAXAMOUNT5 | Decimal | 10 | 3 | Tax Amount 5 | 93 | A | |
TXRECVAMT1 | Decimal | 10 | 3 | Tax Recoverable Amount 1 | 94 | A | |
TXRECVAMT2 | Decimal | 10 | 3 | Tax Recoverable Amount 2 | 95 | A | |
TXRECVAMT3 | Decimal | 10 | 3 | Tax Recoverable Amount 3 | 96 | A | |
TXRECVAMT4 | Decimal | 10 | 3 | Tax Recoverable Amount 4 | 97 | A | |
TXRECVAMT5 | Decimal | 10 | 3 | Tax Recoverable Amount 5 | 98 | A | |
TXEXPSAMT1 | Decimal | 10 | 3 | Tax Expense Amount 1 | 99 | A | |
TXEXPSAMT2 | Decimal | 10 | 3 | Tax Expense Amount 2 | 100 | A | |
TXEXPSAMT3 | Decimal | 10 | 3 | Tax Expense Amount 3 | 101 | A | |
TXEXPSAMT4 | Decimal | 10 | 3 | Tax Expense Amount 4 | 102 | A | |
TXEXPSAMT5 | Decimal | 10 | 3 | Tax Expense Amount 5 | 103 | A | |
TXALLOAMT1 | Decimal | 10 | 3 | Tax Allocated Amount 1 | 104 | A | |
TXALLOAMT2 | Decimal | 10 | 3 | Tax Allocated Amount 2 | 105 | A | |
TXALLOAMT3 | Decimal | 10 | 3 | Tax Allocated Amount 3 | 106 | A | |
TXALLOAMT4 | Decimal | 10 | 3 | Tax Allocated Amount 4 | 107 | A | |
TXALLOAMT5 | Decimal | 10 | 3 | Tax Allocated Amount 5 | 108 | A | |
TXBASEALLO | Decimal | 10 | 3 | Net of Tax | 109 | A | |
TXINCLUDED | Decimal | 10 | 3 | Tax Included | 110 | CA | |
TXEXCLUDED | Decimal | 10 | 3 | Tax Excluded | 111 | CA | |
TAXAMOUNT | Decimal | 10 | 3 | Total Tax | 112 | CA | |
TXRECVAMT | Decimal | 10 | 3 | Recoverable Tax | 113 | A | |
TXEXPSAMT | Decimal | 10 | 3 | Expensed Tax | 114 | A | |
TXALLOAMT | Decimal | 10 | 3 | Allocated Tax | 115 | A | |
TFBASEALLO | Decimal | 10 | 3 | Func. Net of Tax | 116 | CA | |
TFINCLUDE1 | Decimal | 10 | 3 | Func. Tax Included Amount 1 | 117 | CA | |
TFINCLUDE2 | Decimal | 10 | 3 | Func. Tax Included Amount 2 | 118 | CA | |
TFINCLUDE3 | Decimal | 10 | 3 | Func. Tax Included Amount 3 | 119 | CA | |
TFINCLUDE4 | Decimal | 10 | 3 | Func. Tax Included Amount 4 | 120 | CA | |
TFINCLUDE5 | Decimal | 10 | 3 | Func. Tax Included Amount 5 | 121 | CA | |
TFALLOAMT1 | Decimal | 10 | 3 | Func. Tax Allocated Amount 1 | 122 | CA | |
TFALLOAMT2 | Decimal | 10 | 3 | Func. Tax Allocated Amount 2 | 123 | CA | |
TFALLOAMT3 | Decimal | 10 | 3 | Func. Tax Allocated Amount 3 | 124 | CA | |
TFALLOAMT4 | Decimal | 10 | 3 | Func. Tax Allocated Amount 4 | 125 | CA | |
TFALLOAMT5 | Decimal | 10 | 3 | Func. Tax Allocated Amount 5 | 126 | CA | |
TFRECVAMT1 | Decimal | 10 | 3 | Func. Tax Recoverable Amount 1 | 127 | CA | |
TFRECVAMT2 | Decimal | 10 | 3 | Func. Tax Recoverable Amount 2 | 128 | CA | |
TFRECVAMT3 | Decimal | 10 | 3 | Func. Tax Recoverable Amount 3 | 129 | CA | |
TFRECVAMT4 | Decimal | 10 | 3 | Func. Tax Recoverable Amount 4 | 130 | CA | |
TFRECVAMT5 | Decimal | 10 | 3 | Func. Tax Recoverable Amount 5 | 131 | CA | |
TFEXPSAMT1 | Decimal | 10 | 3 | Func. Tax Expense Amount 1 | 132 | CA | |
TFEXPSAMT2 | Decimal | 10 | 3 | Func. Tax Expense Amount 2 | 133 | CA | |
TFEXPSAMT3 | Decimal | 10 | 3 | Func. Tax Expense Amount 3 | 134 | CA | |
TFEXPSAMT4 | Decimal | 10 | 3 | Func. Tax Expense Amount 4 | 135 | CA | |
TFEXPSAMT5 | Decimal | 10 | 3 | Func. Tax Expense Amount 5 | 136 | CA | |
GLACEXPENS | Char | 45 | 0 | Expense Account | %-45C | 137 | A |
DTARRIVAL | Date | 5 | 0 | Arrival Date | 138 | A | |
LABELCOUNT | Int | 2 | 0 | Number of Labels | 139 | A | |
MPRORATED | Decimal | 10 | 3 | Manual Proration | 140 | A | |
HASDROPSHI | Bool | 2 | 0 | Drop-Ship | 141 | A | |
DROPTYPE | Int | 2 | 0 | Drop-Ship Type | 142 | AP | |
IDCUST | Char | 12 | 0 | Drop-Ship Customer | %-12C | 143 | A |
IDCUSTSHPT | Char | 6 | 0 | Customer Ship-To Address | %-6C | 144 | A |
DLOCATION | Char | 6 | 0 | Drop-Ship Location | %-6N | 145 | A |
DESC | Char | 60 | 0 | Drop-Ship Description | 146 | A | |
ADDRESS1 | Char | 60 | 0 | Drop-Ship Address 1 | 147 | A | |
ADDRESS2 | Char | 60 | 0 | Drop-Ship Address 2 | 148 | A | |
ADDRESS3 | Char | 60 | 0 | Drop-Ship Address 3 | 149 | A | |
ADDRESS4 | Char | 60 | 0 | Drop-Ship Address 4 | 150 | A | |
CITY | Char | 30 | 0 | Drop-Ship City | 151 | A | |
STATE | Char | 30 | 0 | Drop-Ship State/Province | 152 | A | |
ZIP | Char | 20 | 0 | Drop-Ship Zip/Postal Code | 153 | A | |
COUNTRY | Char | 30 | 0 | Drop-Ship Country | 154 | A | |
PHONE | Char | 30 | 0 | Drop-Ship Phone Number | (%-3C) %-3C-%-24C | 155 | A |
FAX | Char | 30 | 0 | Drop-Ship Fax Number | (%-3C) %-3C-%-24C | 156 | A |
CONTACT | Char | 60 | 0 | Drop-Ship Contact | 157 | A | |
STOCKITEM | Bool | 2 | 0 | Stock Item | 158 | CA | |
PONUMBER | Char | 22 | 0 | Purchase Order Number | %-22C | 159 | A |
TAXCLASS1D | Char | 60 | 0 | Tax Class 1 Description | 161 | CA | |
TAXCLASS2D | Char | 60 | 0 | Tax Class 2 Description | 162 | CA | |
TAXCLASS3D | Char | 60 | 0 | Tax Class 3 Description | 163 | CA | |
TAXCLASS4D | Char | 60 | 0 | Tax Class 4 Description | 164 | CA | |
TAXCLASS5D | Char | 60 | 0 | Tax Class 5 Description | 165 | CA | |
GLACEXPNSD | Char | 60 | 0 | Expense Account Description | 166 | CA | |
TXINCLUDE1 | Decimal | 10 | 3 | Included Tax Amount 1 | 167 | A | |
TXINCLUDE2 | Decimal | 10 | 3 | Included Tax Amount 2 | 168 | A | |
TXINCLUDE3 | Decimal | 10 | 3 | Included Tax Amount 3 | 169 | A | |
TXINCLUDE4 | Decimal | 10 | 3 | Included Tax Amount 4 | 170 | A | |
TXINCLUDE5 | Decimal | 10 | 3 | Included Tax Amount 5 | 171 | A | |
TXEXCLUDE1 | Decimal | 10 | 3 | Excluded Tax Amount 1 | 172 | A | |
TXEXCLUDE2 | Decimal | 10 | 3 | Excluded Tax Amount 2 | 173 | A | |
TXEXCLUDE3 | Decimal | 10 | 3 | Excluded Tax Amount 3 | 174 | A | |
TXEXCLUDE4 | Decimal | 10 | 3 | Excluded Tax Amount 4 | 175 | A | |
TXEXCLUDE5 | Decimal | 10 | 3 | Excluded Tax Amount 5 | 176 | A | |
ISCOMPLETE | Bool | 2 | 0 | Completed | 177 | A | |
EXTRANEOUS | Long | 4 | 0 | Extraneous Line Count | 178 | A | |
TAXLINE | Long | 4 | 0 | Lines Tax Calculation Sees | 179 | A | |
LINEPRORAT | Long | 4 | 0 | Number of Lines Prorated | 180 | A | |
LINECMPL | Long | 4 | 0 | Lines Complete | 181 | A | |
LINE | Long | 4 | 0 | Line | 182 | A | |
EXSTDCOST | Decimal | 10 | 3 | Extended Std. Cost in Src Curr | 183 | CA | |
EXMRCOST | Decimal | 10 | 3 | Extended MR Cost in Src Curr | 184 | CA | |
EXALT1COST | Decimal | 10 | 3 | Extended Cost 1 in Src Curr | 185 | CA | |
EXALT2COST | Decimal | 10 | 3 | Extended Cost 2 in Src Curr | 186 | CA | |
Char | 50 | 0 | Drop-Ship E-mail | 187 | A | ||
PHONEC | Char | 30 | 0 | Drop-Ship Contact Phone | (%-3C) %-3C-%-24C | 188 | A |
FAXC | Char | 30 | 0 | Drop-Ship Contact Fax | (%-3C) %-3C-%-24C | 189 | A |
EMAILC | Char | 50 | 0 | Drop-Ship Contact E-mail | 190 | A | |
GLNONSTKCR | Char | 45 | 0 | Non-Stock Clearing Account | %-45C | 191 | A |
GLNONSTKCD | Char | 60 | 0 | Non-Stock Clearing Account Desc. | 192 | CA | |
IPCID | Long | 4 | 0 | Inter-process Comm. ID | 193 | A | |
FORCEPOPSN | Bool | 2 | 0 | Force Pop-up SN | 194 | A | |
POPUPSN | Int | 2 | 0 | Pop-up SN | 195 | A | |
CLOSESN | Bool | 2 | 0 | Close SN | 196 | A | |
LTSETID | Long | 4 | 0 | LT Set ID | 197 | A | |
FORCEPOPLT | Bool | 2 | 0 | Force Pop-up LT | 198 | A | |
POPUPLT | Int | 2 | 0 | Pop-up LT | 199 | A | |
CLOSELT | Bool | 2 | 0 | Close LT | 200 | A | |
MANITEMNO | Char | 24 | 0 | Manufacturer's Item Number | %-24C | 201 | A |
MAPMANITEM | Bool | 2 | 0 | Map Manufacturer's Item Number | 202 | EA | |
DISCPCT | Decimal | 5 | 5 | Discount Percentage | 203 | A | |
DISCOUNT | Decimal | 10 | 3 | Discount Amount | 204 | A | |
DISCOUNTF | Decimal | 10 | 3 | Func. Discount Amount | 205 | A | |
NETXTENDED | Decimal | 10 | 3 | Net Extended Cost | 206 | A | |
XIRQRECEVD | Decimal | 10 | 4 | Part. Inv. Pv. Qty. Invoicied. | 207 | A | |
XIEXTWGHT | Decimal | 10 | 4 | Part. Inv. Pv. Ext. Wgt. Invcd. | 208 | A | |
XINETXTEND | Decimal | 10 | 3 | Part. Inv. Pv. Net Cost Invoiced | 209 | A | |
INVLINES | Long | 4 | 0 | Invoice Lines | 210 | A | |
VALUES | Long | 4 | 0 | Optional Fields | 211 | CA | |
PORLREV | Decimal | 10 | 0 | Line Number | 212 | CA | |
PROCESSCMD | Int | 2 | 0 | Command | 213 | CA | |
CONTRACT | Char | 16 | 0 | Contract | %-16C | 214 | A |
PROJECT | Char | 16 | 0 | Project | %-16N | 215 | A |
CCATEGORY | Char | 16 | 0 | Category | %-16N | 216 | A |
COSTCLASS | Int | 2 | 0 | Cost Class | 217 | CA | |
BILLTYPE | Int | 2 | 0 | Billing Type | 218 | AP | |
BILLRATE | Decimal | 10 | 6 | Billing Rate | 219 | A | |
BILLCURR | Char | 3 | 0 | Billing Currency | %-3N | 220 | CA |
ARITEMNO | Char | 16 | 0 | A/R Item Number | %-16C | 221 | A |
ARUNIT | Char | 10 | 0 | A/R Unit of Measure | %-10C | 222 | A |
RTGPERCENT | Decimal | 5 | 5 | Retainage Percentage | 223 | A | |
RTGDAYS | Int | 2 | 0 | Retention Period | 224 | A | |
RTGAMOUNT | Decimal | 10 | 3 | Retainage Amount | 225 | A | |
RTGAMTOVER | Bool | 2 | 0 | Retainage Amount Overridden | 226 | CA | |
BILLLINE | Long | 4 | 0 | Billable Line | 227 | A | |
CONTSTYLE | Int | 2 | 0 | Project Style | 228 | CA | |
PROJTYPE | Int | 2 | 0 | Project Type | 229 | CA | |
REVREC | Int | 2 | 0 | Accounting Method | 230 | CA | |
UFMTCONTNO | Char | 16 | 0 | Unformatted Contract Code | %-16C | 231 | CA |
TARAMOUNT1 | Decimal | 10 | 3 | Tax Reporting Amount 1 | 232 | A | |
TARAMOUNT2 | Decimal | 10 | 3 | Tax Reporting Amount 2 | 233 | A | |
TARAMOUNT3 | Decimal | 10 | 3 | Tax Reporting Amount 3 | 234 | A | |
TARAMOUNT4 | Decimal | 10 | 3 | Tax Reporting Amount 4 | 235 | A | |
TARAMOUNT5 | Decimal | 10 | 3 | Tax Reporting Amount 5 | 236 | A | |
TRALLOAMT1 | Decimal | 10 | 3 | Tax Reporting Allocated Amount 1 | 237 | A | |
TRALLOAMT2 | Decimal | 10 | 3 | Tax Reporting Allocated Amount 2 | 238 | A | |
TRALLOAMT3 | Decimal | 10 | 3 | Tax Reporting Allocated Amount 3 | 239 | A | |
TRALLOAMT4 | Decimal | 10 | 3 | Tax Reporting Allocated Amount 4 | 240 | A | |
TRALLOAMT5 | Decimal | 10 | 3 | Tax Reporting Allocated Amount 5 | 241 | A | |
TRRECVAMT1 | Decimal | 10 | 3 | Tax Reporting Recoverable Amt. 1 | 242 | A | |
TRRECVAMT2 | Decimal | 10 | 3 | Tax Reporting Recoverable Amt. 2 | 243 | A | |
TRRECVAMT3 | Decimal | 10 | 3 | Tax Reporting Recoverable Amt. 3 | 244 | A | |
TRRECVAMT4 | Decimal | 10 | 3 | Tax Reporting Recoverable Amt. 4 | 245 | A | |
TRRECVAMT5 | Decimal | 10 | 3 | Tax Reporting Recoverable Amt. 5 | 246 | A | |
TREXPSAMT1 | Decimal | 10 | 3 | Tax Reporting Expense Amount 1 | 247 | A | |
TREXPSAMT2 | Decimal | 10 | 3 | Tax Reporting Expense Amount 2 | 248 | A | |
TREXPSAMT3 | Decimal | 10 | 3 | Tax Reporting Expense Amount 3 | 249 | A | |
TREXPSAMT4 | Decimal | 10 | 3 | Tax Reporting Expense Amount 4 | 250 | A | |
TREXPSAMT5 | Decimal | 10 | 3 | Tax Reporting Expense Amount 5 | 251 | A | |
TRINCLUDE1 | Decimal | 10 | 3 | Tax Reporting Included Amount 1 | 252 | A | |
TRINCLUDE2 | Decimal | 10 | 3 | Tax Reporting Included Amount 2 | 253 | A | |
TRINCLUDE3 | Decimal | 10 | 3 | Tax Reporting Included Amount 3 | 254 | A | |
TRINCLUDE4 | Decimal | 10 | 3 | Tax Reporting Included Amount 4 | 255 | A | |
TRINCLUDE5 | Decimal | 10 | 3 | Tax Reporting Included Amount 5 | 256 | A | |
TREXCLUDE1 | Decimal | 10 | 3 | Tax Reporting Excluded Amount 1 | 257 | A | |
TREXCLUDE2 | Decimal | 10 | 3 | Tax Reporting Excluded Amount 2 | 258 | A | |
TREXCLUDE3 | Decimal | 10 | 3 | Tax Reporting Excluded Amount 3 | 259 | A | |
TREXCLUDE4 | Decimal | 10 | 3 | Tax Reporting Excluded Amount 4 | 260 | A | |
TREXCLUDE5 | Decimal | 10 | 3 | Tax Reporting Excluded Amount 5 | 261 | A | |
TARAMOUNT | Decimal | 10 | 3 | Tax Reporting Total Amount | 262 | A | |
TRINCLUDED | Decimal | 10 | 3 | Tax Reporting Included Amount | 263 | A | |
TREXCLUDED | Decimal | 10 | 3 | Tax Reporting Excluded Amount | 264 | A | |
TRRECVAMT | Decimal | 10 | 3 | Tax Reporting Recoverable Amount | 265 | A | |
TREXPSAMT | Decimal | 10 | 3 | Tax Reporting Expensed Amount | 266 | A | |
TRALLOAMT | Decimal | 10 | 3 | Tax Reporting Allocated Amount | 267 | A | |
RAXBASE1 | Decimal | 10 | 3 | Retainage Tax Base 1 | 268 | A | |
RAXBASE2 | Decimal | 10 | 3 | Retainage Tax Base 2 | 269 | A | |
RAXBASE3 | Decimal | 10 | 3 | Retainage Tax Base 3 | 270 | A | |
RAXBASE4 | Decimal | 10 | 3 | Retainage Tax Base 4 | 271 | A | |
RAXBASE5 | Decimal | 10 | 3 | Retainage Tax Base 5 | 272 | A | |
RAXAMOUNT1 | Decimal | 10 | 3 | Retainage Tax Amount 1 | 273 | A | |
RAXAMOUNT2 | Decimal | 10 | 3 | Retainage Tax Amount 2 | 274 | A | |
RAXAMOUNT3 | Decimal | 10 | 3 | Retainage Tax Amount 3 | 275 | A | |
RAXAMOUNT4 | Decimal | 10 | 3 | Retainage Tax Amount 4 | 276 | A | |
RAXAMOUNT5 | Decimal | 10 | 3 | Retainage Tax Amount 5 | 277 | A | |
RXRECVAMT1 | Decimal | 10 | 3 | Retainage Tax Recoverable Amt. 1 | 278 | A | |
RXRECVAMT2 | Decimal | 10 | 3 | Retainage Tax Recoverable Amt. 2 | 279 | A | |
RXRECVAMT3 | Decimal | 10 | 3 | Retainage Tax Recoverable Amt. 3 | 280 | A | |
RXRECVAMT4 | Decimal | 10 | 3 | Retainage Tax Recoverable Amt. 4 | 281 | A | |
RXRECVAMT5 | Decimal | 10 | 3 | Retainage Tax Recoverable Amt. 5 | 282 | A | |
RXEXPSAMT1 | Decimal | 10 | 3 | Retainage Tax Expense Amount 1 | 283 | A | |
RXEXPSAMT2 | Decimal | 10 | 3 | Retainage Tax Expense Amount 2 | 284 | A | |
RXEXPSAMT3 | Decimal | 10 | 3 | Retainage Tax Expense Amount 3 | 285 | A | |
RXEXPSAMT4 | Decimal | 10 | 3 | Retainage Tax Expense Amount 4 | 286 | A | |
RXEXPSAMT5 | Decimal | 10 | 3 | Retainage Tax Expense Amount 5 | 287 | A | |
RXALLOAMT1 | Decimal | 10 | 3 | Retainage Tax Allocated Amount 1 | 288 | A | |
RXALLOAMT2 | Decimal | 10 | 3 | Retainage Tax Allocated Amount 2 | 289 | A | |
RXALLOAMT3 | Decimal | 10 | 3 | Retainage Tax Allocated Amount 3 | 290 | A | |
RXALLOAMT4 | Decimal | 10 | 3 | Retainage Tax Allocated Amount 4 | 291 | A | |
RXALLOAMT5 | Decimal | 10 | 3 | Retainage Tax Allocated Amount 5 | 292 | A | |
RAXAMOUNT | Decimal | 10 | 3 | Retainage Tax Total Amount | 293 | A | |
TXRXAMT1 | Decimal | 10 | 3 | Tax Amount Plus Rtg. Tax Amt. 1 | 294 | A | |
TXRXAMT2 | Decimal | 10 | 3 | Tax Amount Plus Rtg. Tax Amt. 2 | 295 | A | |
TXRXAMT3 | Decimal | 10 | 3 | Tax Amount Plus Rtg. Tax Amt. 3 | 296 | A | |
TXRXAMT4 | Decimal | 10 | 3 | Tax Amount Plus Rtg. Tax Amt. 4 | 297 | A | |
TXRXAMT5 | Decimal | 10 | 3 | Tax Amount Plus Rtg. Tax Amt. 5 | 298 | A | |
UCISMANUAL | Bool | 2 | 0 | Unit Cost is Manual | 299 | A | |
WEIGHTUNIT | Char | 10 | 0 | Weight Unit of Measure | 300 | A | |
WEIGHTCONV | Decimal | 10 | 6 | Weight Conversion | 301 | CA | |
DEFUWEIGHT | Decimal | 10 | 4 | Default Unit Weight | 302 | CA | |
DEFEXTWGHT | Decimal | 10 | 4 | Default Extended Weight | 303 | CA | |
XIDEFEXTWT | Decimal | 10 | 4 | Part. Inv. Pv. Def. Ext. W. Inv. | 304 | CA | |
BILLRATECV | Decimal | 10 | 6 | Billing Rate Conversion Factor | 305 | CA | |
UNITBILLSR | Decimal | 10 | 6 | Unit Billing Amount | 306 | CA | |
EXTBILLSR | Decimal | 10 | 3 | Extended Billing Amount | 307 | A | |
FASDETAIL | Bool | 2 | 0 | Fixed Asset | 308 | A | |
FASCREATED | Bool | 2 | 0 | Asset Created | 309 | A | |
FASDB | Char | 32 | 0 | Sage Fixed Assets Database | 310 | A | |
FASCMP | Char | 32 | 0 | Sage Fixed Assets Company/Org. | 311 | A | |
FASTMPL | Char | 25 | 0 | Sage Fixed Assets Template | 312 | A | |
TEXTDESC | Char | 80 | 0 | Sage Fixed Assets Asset Descript | 313 | A | |
SEPQTY | Bool | 2 | 0 | Separate Assets | 314 | A | |
FASQTY | Decimal | 10 | 5 | Sage Fixed Assets Quantity | 315 | A | |
UOM | Char | 10 | 0 | Sage Fixed Assets Unit of Measur | 316 | A | |
AMTSC | Decimal | 10 | 3 | Sage Fixed Assets Asset Value | 317 | A | |
SERIALQTY | Long | 4 | 0 | Serial Quantity | 318 | CA | |
LOTQTY | Decimal | 10 | 4 | Lot Quantity | 319 | CA | |
SLITEM | Int | 2 | 0 | Item Serialized/Lotted? | 320 | CAP | |
XGENALCQTY | Decimal | 10 | 4 | Serial/Lot Quantity to Process | 321 | CA | |
XLOTMAKQTY | Decimal | 10 | 4 | Number of Lots to Generate | 322 | CA | |
XPERLOTQTY | Decimal | 10 | 4 | Quantity per Lot | 323 | CA | |
SALLOCFROM | Char | 40 | 0 | Allocate from Serial | 324 | CA | |
LALLOCFROM | Char | 40 | 0 | Allocate from Lot | 325 | CA | |
METERHWND | Long | 4 | 0 | Serial/Lot Window Handle | 326 | CA | |
DETAILNUM | Int | 2 | 0 | Detail Number | 327 | CA |