| RCPHSEQ |
BCD*10.0 |
Receipt Sequence Key |
|
| RCPLREV |
BCD*10.0 |
Line Number |
|
| AUDTDATE |
Date |
|
|
| AUDTTIME |
Time |
|
|
| AUDTUSER |
String*8 |
|
|
| AUDTORG |
String*6 |
|
|
| RCPLSEQ |
BCD*10.0 |
Receipt Line Sequence |
|
| RCPCSEQ |
BCD*10.0 |
Receipt 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 |
|
| PORHSEQ |
BCD*10.0 |
Purchase Order Sequence Key |
|
| PORLSEQ |
BCD*10.0 |
Purchase Order Line Sequence |
|
| POCOMPLETE |
Boolean |
Completes PO |
List:2 entries
|
| 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 |
|
| OQORDERED |
BCD*10.4 |
Ordered Quantity Ordered |
|
| OQPREVRECV |
BCD*10.4 |
Ordered Previously Received |
|
| OQOUTSTPO |
BCD*10.4 |
Ordered Outstanding on PO |
|
| RQRECEIVED |
BCD*10.4 |
Quantity Received |
|
| RQCANCELED |
BCD*10.4 |
Quantity Canceled |
|
| RQOUTSTAND |
BCD*10.4 |
Quantity Outstanding |
|
| SQORDERED |
BCD*10.4 |
Stocking Quantity Ordered |
|
| SQPREVRECV |
BCD*10.4 |
Stocking Previously Received |
|
| SQOUTSTPO |
BCD*10.4 |
Stocking Outstanding on PO |
|
| RQORDERED |
BCD*10.4 |
Quantity Ordered |
|
| RQPREVRECV |
BCD*10.4 |
Received to Date |
|
| RQOUTSTPO |
BCD*10.4 |
Quantity Outstanding |
|
| RQRCPEXTRA |
BCD*10.4 |
Receiving Qty. Received Extra |
|
| SQRECEIVED |
BCD*10.4 |
Stocking Quantity Received |
|
| SQCANCELED |
BCD*10.4 |
Stocking Quantity Canceled |
|
| SQOUTSTAND |
BCD*10.4 |
Stocking Quantity Outstanding |
|
| SQRCPEXTRA |
BCD*10.4 |
Stocking Quantity Received Extra |
|
| OQRECEIVED |
BCD*10.4 |
Ordered Quantity Received |
|
| OQCANCELED |
BCD*10.4 |
Ordered Quantity Canceled |
|
| OQOUTSTAND |
BCD*10.4 |
Ordered Quantity Outstanding |
|
| OQRCPEXTRA |
BCD*10.4 |
Received Extra |
|
| RQRETURNED |
BCD*10.4 |
Quantity Returned |
|
| SQRETURNED |
BCD*10.4 |
Stocking Quantity Returned |
|
| OQRETURNED |
BCD*10.4 |
Ordered Quantity Returned |
|
| RQSTOCKED |
BCD*10.4 |
Quantity Stocked |
|
| SQSTOCKED |
BCD*10.4 |
Stocking Quantity Stocked |
|
| OQSTOCKED |
BCD*10.4 |
Ordered Quantity Stocked |
|
| RQINADJUST |
BCD*10.4 |
Quantity Adjusted by Invoice |
|
| SQINADJUST |
BCD*10.4 |
Stocking Qty. Adj. by Invoice |
|
| OQINADJUST |
BCD*10.4 |
Ordered Quantity Adj. by Invoice |
|
| RQPOFILLED |
BCD*10.4 |
Quantity Filled on PO |
|
| SQPOFILLED |
BCD*10.4 |
Stocking Quantity Filled on PO |
|
| OQPOFILLED |
BCD*10.4 |
Ordered Quantity Filled on PO |
|
| RQSETTLED |
BCD*10.4 |
Quantity Settled |
|
| SQSETTLED |
BCD*10.4 |
Stocking Quantity Settled |
|
| OQSETTLED |
BCD*10.4 |
Ordered Quantity Settled |
|
| RQUSTOCKED |
BCD*10.4 |
Quantity Unstocked |
|
| SQUSTOCKED |
BCD*10.4 |
Stocking Quantity Unstocked |
|
| OQUSTOCKED |
BCD*10.4 |
Ordered Quantity Unstocked |
|
| 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 |
|
| 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 |
|
| 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 |
|
| GLACEXPENS |
String*45 |
Expense Account |
Mask: %-45C |
| DTARRIVAL |
Date |
Arrival Date |
|
| LABELCOUNT |
Integer |
Number of Labels |
|
| MPRORATED |
BCD*10.3 |
Manual Proration |
|
| HASDROPSHI |
Boolean |
Drop-Ship |
List:2 entries
|
| DROPTYPE |
Integer |
Drop-Ship Type |
List:4 entries
| 2 |
= |
Address Entered |
| 3 |
= |
Inventory Location Address |
| 4 |
= |
Customer Address |
| 5 |
= |
Customer Ship-To Address |
|
| IDCUST |
String*12 |
Drop-Ship Customer |
Mask: %-12C |
| IDCUSTSHPT |
String*6 |
Customer Ship-To Address |
Mask: %-6C |
| DLOCATION |
String*6 |
Drop-Ship Location |
Mask: %-6N |
| DESC |
String*60 |
Drop-Ship Description |
|
| ADDRESS1 |
String*60 |
Drop-Ship Address 1 |
|
| ADDRESS2 |
String*60 |
Drop-Ship Address 2 |
|
| ADDRESS3 |
String*60 |
Drop-Ship Address 3 |
|
| ADDRESS4 |
String*60 |
Drop-Ship Address 4 |
|
| CITY |
String*30 |
Drop-Ship City |
|
| STATE |
String*30 |
Drop-Ship State/Province |
|
| ZIP |
String*20 |
Drop-Ship Zip/Postal Code |
|
| COUNTRY |
String*30 |
Drop-Ship Country |
|
| PHONE |
String*30 |
Drop-Ship Phone Number |
Mask: (%-3C) %-3C-%-24C |
| FAX |
String*30 |
Drop-Ship Fax Number |
Mask: (%-3C) %-3C-%-24C |
| CONTACT |
String*60 |
Drop-Ship Contact |
|
| STOCKITEM |
Boolean |
Stock Item |
List:2 entries
|
| PONUMBER |
String*22 |
Purchase Order Number |
Mask: %-22C |
| EMAIL |
String*50 |
Drop-Ship E-mail |
|
| PHONEC |
String*30 |
Drop-Ship Contact Phone |
Mask: (%-3C) %-3C-%-24C |
| FAXC |
String*30 |
Drop-Ship Contact Fax |
Mask: (%-3C) %-3C-%-24C |
| EMAILC |
String*50 |
Drop-Ship Contact E-mail |
|
| 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 |
|
| XIRQRECEVD |
BCD*10.4 |
Part. Inv. Pv. Qty. Invoicied. |
|
| XIEXTWGHT |
BCD*10.4 |
Part. Inv. Pv. Ext. Wgt. Invcd. |
|
| XINETXTEND |
BCD*10.3 |
Part. Inv. Pv. Net Cost Invoiced |
|
| INVLINES |
Long |
Invoice Lines |
|
| VALUES |
Long |
Optional Fields |
|
| 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 |
|
| RTGAMTOVER |
Boolean |
Retainage Amount 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 |
|
| XIDEFEXTWT |
BCD*10.4 |
Part. Inv. Pv. Def. Ext. W. Inv. |
|
| FASDETAIL |
Boolean |
Fixed Asset |
List:2 entries
|
| 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 |
|
| CAXABLE1 |
Boolean |
Reverse Chargeable 1 |
List:2 entries
|
| CAXABLE2 |
Boolean |
Reverse Chargeable 2 |
List:2 entries
|
| CAXABLE3 |
Boolean |
Reverse Chargeable 3 |
List:2 entries
|
| CAXABLE4 |
Boolean |
Reverse Chargeable 4 |
List:2 entries
|
| CAXABLE5 |
Boolean |
Reverse Chargeable 5 |
List:2 entries
|
|