| INVHSEQ |
BCD*10.0 |
Invoice Sequence Key |
|
| INVLREV |
BCD*10.0 |
Line Number |
|
| AUDTDATE |
Date |
|
|
| AUDTTIME |
Time |
|
|
| AUDTUSER |
String*8 |
|
|
| AUDTORG |
String*6 |
|
|
| INVLSEQ |
BCD*10.0 |
Invoice Line Sequence |
|
| INVCSEQ |
BCD*10.0 |
Invoice Comment Sequence |
|
| OEONUMBER |
String*22 |
Order Number |
Mask: %-22C |
| INDBTABLE |
Boolean |
Stored in Database Table |
List: 2 entries
|
| POSTEDTOIC |
Boolean |
Posted to I/C |
List: 2 entries
|
| COMPLETION |
Integer |
Completion Status |
List: 3 entries
|
| DTCOMPLETE |
Date |
Date Completed |
|
| RCPHSEQ |
BCD*10.0 |
Receipt Sequence Key |
|
| RCPLSEQ |
BCD*10.0 |
Receipt Line Sequence |
|
| ITEMEXISTS |
Boolean |
Item Exists |
List: 2 entries
|
| ITEMNO |
String*24 |
Item Number |
Mask: %-24C |
| LOCATION |
String*6 |
Location |
Mask: %-6N |
| ITEMDESC |
String*60 |
Item Description |
|
| VENDITEMNO |
String*24 |
Vendor Item Number |
|
| HASCOMMENT |
Boolean |
Comments |
List: 2 entries
|
| ORDERUNIT |
String*10 |
Unit of Measure |
Mask: %-10c |
| ORDERCONV |
BCD*10.6 |
Order Unit Conversion |
|
| ORDERDECML |
Integer |
Order Unit Decimals |
|
| RCPUNIT |
String*10 |
Unit of Measure |
Mask: %-10c |
| RCPCONV |
BCD*10.6 |
Receiving Conversion Factor |
|
| RCPDECML |
Integer |
Receiving Unit Decimals |
|
| STOCKDECML |
Integer |
Stock Unit Decimals |
|
| RQRECEIVED |
BCD*10.4 |
Quantity Received |
|
| SQRECEIVED |
BCD*10.4 |
Stocking Quantity Received |
|
| OQRECEIVED |
BCD*10.4 |
Ordered Quantity Received |
|
| UNITWEIGHT |
BCD*10.4 |
Unit Weight |
|
| EXTWEIGHT |
BCD*10.4 |
Extended Weight |
|
| UNITCOST |
BCD*10.6 |
Unit Cost |
|
| EXTENDED |
BCD*10.3 |
Extended Cost |
|
| TAXBASE1 |
BCD*10.3 |
Tax Base 1 |
|
| TAXBASE2 |
BCD*10.3 |
Tax Base 2 |
|
| TAXBASE3 |
BCD*10.3 |
Tax Base 3 |
|
| TAXBASE4 |
BCD*10.3 |
Tax Base 4 |
|
| TAXBASE5 |
BCD*10.3 |
Tax Base 5 |
|
| TAXCLASS1 |
Integer |
Tax Class 1 |
|
| TAXCLASS2 |
Integer |
Tax Class 2 |
|
| TAXCLASS3 |
Integer |
Tax Class 3 |
|
| TAXCLASS4 |
Integer |
Tax Class 4 |
|
| TAXCLASS5 |
Integer |
Tax Class 5 |
|
| TAXRATE1 |
BCD*8.5 |
Tax Rate 1 |
|
| TAXRATE2 |
BCD*8.5 |
Tax Rate 2 |
|
| TAXRATE3 |
BCD*8.5 |
Tax Rate 3 |
|
| TAXRATE4 |
BCD*8.5 |
Tax Rate 4 |
|
| TAXRATE5 |
BCD*8.5 |
Tax Rate 5 |
|
| TAXINCLUD1 |
Boolean |
Tax Includable 1 |
List: 2 entries
|
| TAXINCLUD2 |
Boolean |
Tax Includable 2 |
List: 2 entries
|
| TAXINCLUD3 |
Boolean |
Tax Includable 3 |
List: 2 entries
|
| TAXINCLUD4 |
Boolean |
Tax Includable 4 |
List: 2 entries
|
| TAXINCLUD5 |
Boolean |
Tax Includable 5 |
List: 2 entries
|
| TAXAMOUNT1 |
BCD*10.3 |
Tax Amount 1 |
|
| TAXAMOUNT2 |
BCD*10.3 |
Tax Amount 2 |
|
| TAXAMOUNT3 |
BCD*10.3 |
Tax Amount 3 |
|
| TAXAMOUNT4 |
BCD*10.3 |
Tax Amount 4 |
|
| TAXAMOUNT5 |
BCD*10.3 |
Tax Amount 5 |
|
| TXRECVAMT1 |
BCD*10.3 |
Tax Recoverable Amount 1 |
|
| TXRECVAMT2 |
BCD*10.3 |
Tax Recoverable Amount 2 |
|
| TXRECVAMT3 |
BCD*10.3 |
Tax Recoverable Amount 3 |
|
| TXRECVAMT4 |
BCD*10.3 |
Tax Recoverable Amount 4 |
|
| TXRECVAMT5 |
BCD*10.3 |
Tax Recoverable Amount 5 |
|
| TXEXPSAMT1 |
BCD*10.3 |
Tax Expense Amount 1 |
|
| TXEXPSAMT2 |
BCD*10.3 |
Tax Expense Amount 2 |
|
| TXEXPSAMT3 |
BCD*10.3 |
Tax Expense Amount 3 |
|
| TXEXPSAMT4 |
BCD*10.3 |
Tax Expense Amount 4 |
|
| TXEXPSAMT5 |
BCD*10.3 |
Tax Expense Amount 5 |
|
| TXALLOAMT1 |
BCD*10.3 |
Tax Allocated Amount 1 |
|
| TXALLOAMT2 |
BCD*10.3 |
Tax Allocated Amount 2 |
|
| TXALLOAMT3 |
BCD*10.3 |
Tax Allocated Amount 3 |
|
| TXALLOAMT4 |
BCD*10.3 |
Tax Allocated Amount 4 |
|
| TXALLOAMT5 |
BCD*10.3 |
Tax Allocated Amount 5 |
|
| TXBASEALLO |
BCD*10.3 |
Net of Tax |
|
| TXINCLUDED |
BCD*10.3 |
Tax Included |
|
| TXEXCLUDED |
BCD*10.3 |
Tax Excluded |
|
| TAXAMOUNT |
BCD*10.3 |
Total Tax |
|
| TXRECVAMT |
BCD*10.3 |
Recoverable Tax |
|
| TXEXPSAMT |
BCD*10.3 |
Expensed Tax |
|
| TXALLOAMT |
BCD*10.3 |
Allocated Tax |
|
| TFBASEALLO |
BCD*10.3 |
Func. Net of Tax |
|
| TFINCLUDE1 |
BCD*10.3 |
Func. Tax Included Amount 1 |
|
| TFINCLUDE2 |
BCD*10.3 |
Func. Tax Included Amount 2 |
|
| TFINCLUDE3 |
BCD*10.3 |
Func. Tax Included Amount 3 |
|
| TFINCLUDE4 |
BCD*10.3 |
Func. Tax Included Amount 4 |
|
| TFINCLUDE5 |
BCD*10.3 |
Func. Tax Included Amount 5 |
|
| TFRECVAMT1 |
BCD*10.3 |
Func. Tax Recoverable Amount 1 |
|
| TFRECVAMT2 |
BCD*10.3 |
Func. Tax Recoverable Amount 2 |
|
| TFRECVAMT3 |
BCD*10.3 |
Func. Tax Recoverable Amount 3 |
|
| TFRECVAMT4 |
BCD*10.3 |
Func. Tax Recoverable Amount 4 |
|
| TFRECVAMT5 |
BCD*10.3 |
Func. Tax Recoverable Amount 5 |
|
| TFEXPSAMT1 |
BCD*10.3 |
Func. Tax Expense Amount 1 |
|
| TFEXPSAMT2 |
BCD*10.3 |
Func. Tax Expense Amount 2 |
|
| TFEXPSAMT3 |
BCD*10.3 |
Func. Tax Expense Amount 3 |
|
| TFEXPSAMT4 |
BCD*10.3 |
Func. Tax Expense Amount 4 |
|
| TFEXPSAMT5 |
BCD*10.3 |
Func. Tax Expense Amount 5 |
|
| TFALLOAMT1 |
BCD*10.3 |
Func. Tax Allocated Amount 1 |
|
| TFALLOAMT2 |
BCD*10.3 |
Func. Tax Allocated Amount 2 |
|
| TFALLOAMT3 |
BCD*10.3 |
Func. Tax Allocated Amount 3 |
|
| TFALLOAMT4 |
BCD*10.3 |
Func. Tax Allocated Amount 4 |
|
| TFALLOAMT5 |
BCD*10.3 |
Func. Tax Allocated Amount 5 |
|
| FCEXTENDED |
BCD*10.3 |
Func. Extended Amount |
|
| GLACEXPENS |
String*45 |
Expense Account |
Mask: %-45C |
| MPRORATED |
BCD*10.3 |
Manual Proration |
|
| STOCKITEM |
Boolean |
Stock Item |
List: 2 entries
|
| RCPNUMBER |
String*22 |
Receipt Number |
Mask: %-22C |
| PORHSEQ |
BCD*10.0 |
Purchase Order Sequence Key |
|
| PORLSEQ |
BCD*10.0 |
Purchase Order Line Sequence |
|
| PONUMBER |
String*22 |
Purchase Order Number |
Mask: %-22C |
| GLNONSTKCR |
String*45 |
Non-Stock Clearing Account |
Mask: %-45C |
| MANITEMNO |
String*24 |
Manufacturer's Item Number |
Mask: %-24C |
| DISCPCT |
BCD*5.5 |
Discount Percentage |
|
| DISCOUNT |
BCD*10.3 |
Discount Amount |
|
| DISCOUNTF |
BCD*10.3 |
Func. Discount Amount |
|
| XRRQRECEVD |
BCD*10.4 |
Part. Inv. Orig. Qty. Received |
|
| XIRQRECEVD |
BCD*10.4 |
Part. Inv. Pv. Qty. Invoicied. |
|
| PVINVLINES |
Long |
Previous Invoice Lines |
|
| FULLYINV |
Boolean |
Fully Invoiced |
List: 2 entries
|
| VALUES |
Long |
Optional Fields |
|
| TERMDISCBL |
Integer |
Payment Discountable |
List: 2 entries
|
| CONTRACT |
String*16 |
Contract |
Mask: %-16C |
| PROJECT |
String*16 |
Project |
Mask: %-16N |
| CCATEGORY |
String*16 |
(Cost) Category |
Mask: %-16N |
| COSTCLASS |
Integer |
Cost Class |
List: 7 entries
| 0 | = | | | 1 | = | Labor | | 2 | = | Material | | 3 | = | Equipment | | 4 | = | Subcontractor | | 5 | = | Overhead | | 6 | = | Miscellaneous |
|
| BILLTYPE |
Integer |
Billing Type |
List: 4 entries
| 0 | = | | | 1 | = | Non-billable | | 2 | = | Billable | | 3 | = | No Charge |
|
| BILLRATE |
BCD*10.6 |
Billing Rate |
|
| BILLCURR |
String*3 |
Billing Currency |
Mask: %-3N |
| ARITEMNO |
String*16 |
A/R Item Number |
Mask: %-16C |
| ARUNIT |
String*10 |
A/R Unit of Measure |
Mask: %-10C |
| RTGPERCENT |
BCD*5.5 |
Retainage Percentage |
|
| RTGDAYS |
Integer |
Retention Period |
|
| RTGAMOUNT |
BCD*10.3 |
Retainage Amount |
|
| RTGDATEDUE |
Date |
Retainage Due Date |
|
| RTGAMTOVER |
Boolean |
Retainage Amount Overridden |
List: 2 entries
|
| RTGDDTOVER |
Boolean |
Retainage Due Date Overridden |
List: 2 entries
|
| TARAMOUNT1 |
BCD*10.3 |
Tax Reporting Amount 1 |
|
| TARAMOUNT2 |
BCD*10.3 |
Tax Reporting Amount 2 |
|
| TARAMOUNT3 |
BCD*10.3 |
Tax Reporting Amount 3 |
|
| TARAMOUNT4 |
BCD*10.3 |
Tax Reporting Amount 4 |
|
| TARAMOUNT5 |
BCD*10.3 |
Tax Reporting Amount 5 |
|
| TRALLOAMT1 |
BCD*10.3 |
Tax Reporting Allocated Amount 1 |
|
| TRALLOAMT2 |
BCD*10.3 |
Tax Reporting Allocated Amount 2 |
|
| TRALLOAMT3 |
BCD*10.3 |
Tax Reporting Allocated Amount 3 |
|
| TRALLOAMT4 |
BCD*10.3 |
Tax Reporting Allocated Amount 4 |
|
| TRALLOAMT5 |
BCD*10.3 |
Tax Reporting Allocated Amount 5 |
|
| TRRECVAMT1 |
BCD*10.3 |
Tax Reporting Recoverable Amt. 1 |
|
| TRRECVAMT2 |
BCD*10.3 |
Tax Reporting Recoverable Amt. 2 |
|
| TRRECVAMT3 |
BCD*10.3 |
Tax Reporting Recoverable Amt. 3 |
|
| TRRECVAMT4 |
BCD*10.3 |
Tax Reporting Recoverable Amt. 4 |
|
| TRRECVAMT5 |
BCD*10.3 |
Tax Reporting Recoverable Amt. 5 |
|
| TREXPSAMT1 |
BCD*10.3 |
Tax Reporting Expense Amount 1 |
|
| TREXPSAMT2 |
BCD*10.3 |
Tax Reporting Expense Amount 2 |
|
| TREXPSAMT3 |
BCD*10.3 |
Tax Reporting Expense Amount 3 |
|
| TREXPSAMT4 |
BCD*10.3 |
Tax Reporting Expense Amount 4 |
|
| TREXPSAMT5 |
BCD*10.3 |
Tax Reporting Expense Amount 5 |
|
| RAXBASE1 |
BCD*10.3 |
Retainage Tax Base 1 |
|
| RAXBASE2 |
BCD*10.3 |
Retainage Tax Base 2 |
|
| RAXBASE3 |
BCD*10.3 |
Retainage Tax Base 3 |
|
| RAXBASE4 |
BCD*10.3 |
Retainage Tax Base 4 |
|
| RAXBASE5 |
BCD*10.3 |
Retainage Tax Base 5 |
|
| RAXAMOUNT1 |
BCD*10.3 |
Retainage Tax Amount 1 |
|
| RAXAMOUNT2 |
BCD*10.3 |
Retainage Tax Amount 2 |
|
| RAXAMOUNT3 |
BCD*10.3 |
Retainage Tax Amount 3 |
|
| RAXAMOUNT4 |
BCD*10.3 |
Retainage Tax Amount 4 |
|
| RAXAMOUNT5 |
BCD*10.3 |
Retainage Tax Amount 5 |
|
| RXRECVAMT1 |
BCD*10.3 |
Retainage Tax Recoverable Amt. 1 |
|
| RXRECVAMT2 |
BCD*10.3 |
Retainage Tax Recoverable Amt. 2 |
|
| RXRECVAMT3 |
BCD*10.3 |
Retainage Tax Recoverable Amt. 3 |
|
| RXRECVAMT4 |
BCD*10.3 |
Retainage Tax Recoverable Amt. 4 |
|
| RXRECVAMT5 |
BCD*10.3 |
Retainage Tax Recoverable Amt. 5 |
|
| RXEXPSAMT1 |
BCD*10.3 |
Retainage Tax Expense Amount 1 |
|
| RXEXPSAMT2 |
BCD*10.3 |
Retainage Tax Expense Amount 2 |
|
| RXEXPSAMT3 |
BCD*10.3 |
Retainage Tax Expense Amount 3 |
|
| RXEXPSAMT4 |
BCD*10.3 |
Retainage Tax Expense Amount 4 |
|
| RXEXPSAMT5 |
BCD*10.3 |
Retainage Tax Expense Amount 5 |
|
| RXALLOAMT1 |
BCD*10.3 |
Retainage Tax Allocated Amount 1 |
|
| RXALLOAMT2 |
BCD*10.3 |
Retainage Tax Allocated Amount 2 |
|
| RXALLOAMT3 |
BCD*10.3 |
Retainage Tax Allocated Amount 3 |
|
| RXALLOAMT4 |
BCD*10.3 |
Retainage Tax Allocated Amount 4 |
|
| RXALLOAMT5 |
BCD*10.3 |
Retainage Tax Allocated Amount 5 |
|
| UCISMANUAL |
Boolean |
Unit Cost is Manual |
List: 2 entries
|
| WEIGHTUNIT |
String*10 |
Weight Unit of Measure |
|
| WEIGHTCONV |
BCD*10.6 |
Weight Conversion |
|
| DEFUWEIGHT |
BCD*10.4 |
Default Unit Weight |
|
| DEFEXTWGHT |
BCD*10.4 |
Default Extended Weight |
|
| SERIALQTY |
Long |
Serial Quantity |
|
| LOTQTY |
BCD*10.4 |
Lot Quantity |
|
| SLITEM |
Integer |
Item Serialized/Lotted? |
List: 4 entries
| 0 | = | None | | 1 | = | Serialized | | 2 | = | Lotted | | 3 | = | Both |
|
| DETAILNUM |
Integer |
Detail Number |
|
|